刚学tp5不久,有些不会用,这里遇到一个问题不是知道是我的问题还是bug
做分页查询,查询是用query 三张表关联查询,统计子表累加,判断昵称存不存在,不存在返回联系电话,问题就出在这,两个子表的 as 命名字段在视图上就是打印不出来,但是dump() 却有这个字段数值
Public function index(){
//分页
$project_list = Db('project')->where('(TO_DAYS(NOW())-TO_DAYS(FROM_UNIXTIME(creat_time, \'%Y-%m-%d %H:%i:%S\')))<days and status=1')->group('id')->paginate(config('config_page'));
$page = $project_list->render();
$this->assign("page",$page);
//数据
$page_num = input('page')*config('config_page');
$sql = 'SELECT p.id,p.ti
tle,p.share_money,p.picture_id,IF(u.nickname IS NULL,u.tel,u.nickname) AS nickname,SUM(IF(s.pay_status=1,1,0)) AS sup_num FROM m_project p LEFT JOIN m_supporter s ON p.id=s.project_id LEFT JOIN m_wx_users u ON p.user_id=u.id WHERE ( (TO_DAYS(NOW())-TO_DAYS(FROM_UNIXTIME(p.creat_time, \'%Y-%m-%d %H:%i:%S\')))<p.days ) GROUP BY p.id LIMIT '.$page_num.','.config('config_page');
$projectlist = Db('project')->query($sql);
$this->assign('share',$project_list);
return view();
}