<?php
|
|
|
namespace app\api\model\store;
|
|
use app\common\model\store\Order as OrderModel;
|
use app\common\service\order\OrderService;
|
|
/**
|
* 模型
|
*/
|
class Order extends OrderModel
|
{
|
/**
|
* 获取列表数据
|
*/
|
public function getList($store_id = 0, $search = '', $params)
|
{
|
$model = $this;
|
if ($store_id > 0) {
|
$model = $model->where('clerk.store_id', '=', (int)$store_id);
|
}
|
if (!empty($search)) {
|
$model = $model->where('clerk.real_name', 'like', '%' . $search . '%');
|
}
|
if(!empty($params["start_time"])){
|
$start_time = strtotime($params["start_time"])-1;
|
$model = $model->where('order.create_time', '>', $start_time);
|
}
|
if(!empty($params["end_time"])){
|
$end_time = strtotime($params["end_time"]) + 86399;
|
$model = $model->where('order.create_time', '<', $end_time);
|
}
|
|
// 查询列表数据
|
$data = $model->with(['store', 'clerk', 'supplier'])
|
->alias('order')
|
->field(['order.*'])
|
->join('store_clerk clerk', 'clerk.clerk_id = order.clerk_id', 'INNER')
|
->order(['order.create_time' => 'desc'])
|
->paginate($params);
|
if ($data->isEmpty()) {
|
return $data;
|
}
|
// 整理订单信息
|
return OrderService::getOrderList($data);
|
}
|
|
}
|
