<?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);
    }

}