<?php
|
|
namespace app\operations\model\order;
|
|
use app\common\model\order\OrderSettled as OrderSettledModel;
|
use app\operations\model\supplier\Supplier as SupplierRegionModel;
|
|
/**
|
* 订单结算模型
|
*/
|
class OrderSettled extends OrderSettledModel
|
{
|
// 定义全局的查询范围
|
protected $globalScope = ['status'];
|
public function scopeStatus($query)
|
{
|
$shop_supplier_ids = SupplierRegionModel::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 getSettledData()
|
{
|
$today = date('Y-m-d');
|
$yesterday = date('Y-m-d', strtotime('-1 day'));
|
$data = [
|
// 供应商结算
|
'real_supplier_money' => [
|
'today' => number_format($this->getDatas(null, $today, 'real_supplier_money')),
|
'yesterday' => number_format($this->getDatas(null, $yesterday, 'real_supplier_money'))
|
],
|
// 平台提成
|
'real_sys_money' => [
|
'today' => number_format($this->getDatas($today, null, 'real_sys_money')),
|
'yesterday' => number_format($this->getDatas($yesterday, null, 'real_sys_money'))
|
],
|
// 分销佣金
|
'agent_money' => [
|
'today' => number_format($this->getDatas($today, null, 'agent_money')),
|
'yesterday' => number_format($this->getDatas($yesterday, null, 'agent_money'))
|
],
|
// 退款金额
|
'refund_money' => [
|
'today' => number_format($this->getDatas($today, null, 'refund_money')),
|
'yesterday' => number_format($this->getDatas($yesterday, null, 'refund_money'))
|
],
|
];
|
return $data;
|
}
|
|
/**
|
* 按日期获取结算数据
|
*/
|
public function getSettledDataByDate($days){
|
$data = [];
|
foreach ($days as $day) {
|
$data[] = [
|
'day' => $day,
|
'real_supplier_money' => $this->getDatas($day, null, 'real_supplier_money'),
|
'real_sys_money' => $this->getDatas($day, null, 'real_sys_money'),
|
'agent_money' => $this->getDatas($day, null, 'agent_money'),
|
'refund_money' => $this->getDatas($day, null, 'refund_money')
|
];
|
}
|
return $data;
|
}
|
/**
|
* 获取供应商统计数量
|
*/
|
public function getDatas($startDate = null, $endDate = null, $type = 'real_supplier_money')
|
{
|
$model = $this;
|
if(!is_null($startDate)){
|
$model = $model->where('create_time', '>=', strtotime($startDate));
|
} else{
|
$model = $model->where('create_time', '>=', strtotime($endDate) - 86400);
|
}
|
if(is_null($endDate)){
|
$model = $model->where('create_time', '<', strtotime($startDate) + 86400);
|
}else{
|
$model = $model->where('create_time', '<', strtotime($endDate) + 86400);
|
}
|
if($type == 'real_supplier_money'){
|
return $model->sum('real_supplier_money');
|
} else if($type == 'real_sys_money'){
|
return $model->sum('real_sys_money');
|
} else if($type == 'agent_money'){
|
return $model->sum('agent_money');
|
} else if($type == 'refund_money'){
|
return $model->sum('refund_money');
|
}
|
return 0;
|
}
|
|
|
/**
|
* 获取售后单列表
|
*/
|
public function getList($params)
|
{
|
$model = $this;
|
// 查询条件：订单号
|
if (isset($params['order_no']) && !empty($params['order_no'])) {
|
$model = $model->where('order.order_no', 'like', "%{$params['order_no']}%");
|
}
|
if(isset($params['start_day']) && !empty($params['start_day'])){
|
$model = $model->where('settled.create_time', '>=', strtotime($params['start_day']));
|
}
|
if(isset($params['end_day']) && !empty($params['end_day'])){
|
$model = $model->where('settled.create_time', '<', strtotime($params['end_day']));
|
}
|
// 是否结算
|
if (isset($params['is_settled']) && $params['is_settled'] > -1) {
|
$model = $model->where('settled.is_settled', '=', $params['is_settled']);
|
}
|
// 获取列表数据
|
return $model->alias('settled')->field('settled.*')
|
->with(['orderMaster', 'supplier'])
|
->join('order', 'order.order_id = settled.order_id')
|
->order(['settled.create_time' => 'desc'])
|
->paginate($params);
|
}
|
}
|
