<?php
|
|
|
namespace app\operations\model\store;
|
|
use app\common\model\store\Order as OrderModel;
|
use app\common\service\order\OrderService;
|
|
/**
|
* 店员模型
|
*/
|
class Order extends OrderModel
|
{
|
// 定义全局的查询范围
|
protected $globalScope = ['status'];
|
public function scopeStatus($query)
|
{
|
$shop_supplier_ids = \app\operations\model\supplier\Supplier::getSupplierIdsByUser(session('jjjshop_operations')['user']);
|
if (empty($shop_supplier_ids)){
|
$query->where($query->getTable() . '.shop_supplier_id', -1);
|
}else{
|
$query->where($query->getTable() . '.shop_supplier_id', 'in', $shop_supplier_ids);
|
}
|
}
|
/**
|
* 获取列表数据
|
*/
|
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(isset($params['shop_supplier_ids'])&&$params['shop_supplier_ids']){
|
$model = $model->where('order.shop_supplier_id', 'in', $params['shop_supplier_ids']);
|
}
|
|
// 查询列表数据
|
$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);
|
}
|
|
}
|
