$page = isset($p) ? $p : 1;
$first = $pagesize * ($page-1);
$join = "LEFT JOIN __USER_COMPANY__ u ON u.user_id = o.user_id
LEFT JOIN __PAY_LOG__ p ON p.order_id = o.order_id
LEFT JOIN __ORDER_INVOICE__ i ON i.order_id = o.order_id
LEFT JOIN __ORDER_SHIPPING__ s ON s.order_id = o.order_id";
$field = 'o.order_id, o.order_sn, o.order_amount, o.create_time, o.status, o.order_shipping_type, u.com_name, p.pay_name pay_name, p.is_paid is_paid, i.invoice_status invoice_status, s.status shipping_status';
//分页查询数据
$data = $this->alias('o')
->join($join)
->field($field)
->limit($first.','.$pagesize)
->order("create_time desc")
->select();
// echo $this->_sql();die;
return $data; 最佳答案
