tp5并表查询整理
$list=$release->alias('a') ->join('purchase_company b','a.company_id=b.com_id','left') ->join('service_user c','c.sid=a.sid','left') ->join('service_statis d','d.type=2 and d.handle_id=a.id','left') ->join('purchase_user e','e.cid=a.cid','left') ->where(array('a.sid'=>$this->sid,'a.data'=>$data,'a.order_type'=>4)) ->field('a.id,a.order_num,a.order_type,a.up_username as fbr,FROM_UNIXTIME(a.create_time,"%Y-%m-%d %H:%i:%s") as fb_time,b.company_name,c.name as slr,FROM_UNIXTIME(d.creat_time,"%Y-%m-%d %H:%i:%s") as sl_time,e.user_name as yslr') ->page($page) ->paginate(10);
相关推荐
-
PHP时间处理函数 php
2019-1-8
-
swoole 连接池 php
2019-1-7
-
php密码强度检测 php
2019-1-7
-
php红包算法函数[优化] php
2019-1-13
-
判断两个日期是否为同一天 php
2019-1-8
-
php读取csv文件数据并输出 php
2019-1-8
-
PHP生成自定义验证码 php
2019-1-8
-
PHP图片压缩类,高清无损 php
2019-1-8
-
tp5的多条件查询及分页 php
2019-1-7
-
经典抽奖概率算法 php
2019-1-7