// +---------------------------------------------------------------------- namespace App\Services\Api; use App\Models\OrderModel; use App\Services\BaseService; /** * 订单-服务类 * @author laravel开发员 * @since 2020/11/11 * @package App\Services\Api */ class OrderService extends BaseService { // 静态对象 protected static $instance = null; /** * 构造函数 * @author laravel开发员 * @since 2020/11/11 */ public function __construct() { $this->model = new OrderModel(); } /** * 静态入口 */ public static function make() { if (!self::$instance) { self::$instance = new static(); } return self::$instance; } /** * 订单列表 * @param $params * @param int $pageSize * @return array */ public function getDataList($params, $pageSize = 15) { $model = $this->getQuery($params); // 数据 $list = $model->where(function ($query) use ($params) { $status = isset($params['status']) ? $params['status'] : 0; // 进行中 if ($status > 0 && is_array($status)) { $query->whereIn('a.status', $status); }else if($status>0){ $query->where('a.status', $status); } })->select(['a.*']) ->orderBy('a.status', 'desc') ->orderBy('a.create_time', 'desc') ->orderBy('a.id', 'desc') ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list ? $list->toArray() : []; if ($list) { $statusArr = [1 => '待审核', 2 => '进行中', 3 => '已完成']; foreach ($list['data'] as &$item) { $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : ''; $status = isset($item['status']) ? $item['status'] : 0; $item['status_text'] = '待审核'; if ($status) { $item['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : ''; } } unset($item); } return [ 'pageSize' => $pageSize, 'total' => isset($list['total']) ? $list['total'] : 0, 'list' => isset($list['data']) ? $list['data'] : [] ]; } /** * 查询条件 * @param $params * @return mixed */ public function getQuery($params) { $where = ['a.mark' => 1]; return $this->model->from('orders as a') ->leftJoin('member as b', 'b.id', '=', 'a.user_id') ->where($where) ->where(function($query) use($params){ $userId = isset($params['user_id']) ? intval($params['user_id']) : 0; if($userId>0){ $query->where('a.user_id', $userId); } }) ->where(function ($query) use ($params) { $keyword = isset($params['keyword']) ? $params['keyword'] : ''; if ($keyword) { $query->where('a.order_no', 'like', "%{$keyword}%") ->orWhere('b.nickname', 'like', "%{$keyword}%") ->orWhere('b.mobile', 'like', "%{$keyword}%"); } }); } /** * 订单详情 * @param $id */ public function getOrderInfo($id) { $statusArr = [1 => '待审核', 2 => '进行中', 3 => '已完成']; $info = $this->model->from('orders as a') ->leftJoin('member as b', 'b.id', '=', 'a.user_id') ->where(['a.id' => $id, 'a.mark' => 1]) ->select(['a.*']) ->first(); if ($info) { $info = $info->toArray(); $info['create_time'] = $info['create_time'] ? datetime($info['create_time'], 'Y-m-d H:i:s') : ''; $status = isset($info['status']) ? $info['status'] : 0; $info['status_text'] = '待付款'; if ($status) { $info['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : ''; } } return $info; } }