我一直在使用Grocery Crud开发一个简单的本地应用程序,允许用户自己注册并喜欢乐队并对其进行评级,并选择他们知道的也在应用程序中注册的人 .
Entities:
人(person_id,person_URL,全名,家乡)
乐队(band_id,band_URL,band_name,国家,流派)
Relationships:
喜欢(为person_id,band_id,速率)
知道(为person_id,known_person_id)
我的问题是:
1) 我想要返回一张人和知名人士的表格,如下所示:
KNOWS person_id | fullname | known_person_id | known_fullname
但我不能使用* set_relation_n_n * function'因为关系是(Person - > Likes - > Person),所以它给了我错误 . 我想出的另一个解决方案是创建一个自定义表,使查询返回我想要的值并在表中显示(下面的代码) . 返回的自定义表是正确的但是当我将它呈现给我的Grocery Crud表时,我需要指定$ crud-> columns('person_id','fullname','known_person_id','fullname'),它无法区分全名该人的姓名和已知人的姓名 . 如何能够以这种方式显示表格?
2) 我在另一个表中遇到了同样的问题,但是可以使用函数* set_relation_n_n * 'cause it'一个关系(Person - > Likes - > Band)管理它,所以因为它's 2 different entities it didn' t给我一个错误 . 问题是查询(下面的代码)返回整个表格,我每页只需要25条记录 . 当我尝试在查询中使用"LIMIT 25"时,它只返回25条记录,"next page"按钮不起作用 . 有解决方案吗
下面,所有信息:
CODE for question 1:
function knows_management()
{
$crud = new grocery_CRUD();
$crud->set_model('model_socialnetwork');
$crud->set_table('knows');
$crud->set_subject('Known');
$crud->basic_model->set_query_str('SELECT tb1.person_id, tb1.fullname, tb1.known_person_id, person.fullname FROM (SELECT person.person_id, person.fullname, knows.known_person_id FROM person INNER JOIN knows ON person.person_id = knows.person_id) tb1 INNER JOIN person ON tb1.known_person_id = person.person_id');<br>
$crud->columns('person_id','fullname','known_person_id','fullname');
$output = $crud->render();
$this->_socialnetwork_output($output);
}
CODE for question 2:
function likes_management()
{
$crud = new grocery_CRUD();
$crud->set_model('model_socialnetwork');
$crud->set_table('likes');
$crud->set_subject('Like');
$crud->columns('person_id','fullname','band_id','band_name', 'rate');
$crud->basic_model->set_query_str('SELECT tb2.person_id, tb2.fullname, tb2.band_id, band.band_name, tb2.rate FROM(SELECT tb1.person_id, person.fullname, tb1.band_id, tb1.rate FROM(SELECT person.person_id, likes.band_id, likes.rate FROM person INNER JOIN likes ON person.person_id = likes.person_id) tb1 INNER JOIN person ON tb1.person_id = person.person_id) tb2 INNER JOIN band ON tb2.band_id = band.band_id');
$output = $crud->render();
$this->_socialnetwork_output($output);
}
1 回答
问题1)例如,如果在查询中使用别名,该怎么办?
SELECT tb1.person_id,tb1.fullname为Tb1fullName,tb1.known_person_id,person.fullname为PersonFullName
问题2)我不建议您在查询中直接/手动添加LIMIT . 在文件application / config / grocery_crud.php中,您有两个与分页直接相关的选项
您应该正确使用和配置它们