<?php
|
|
namespace app\operations\model\order;
|
|
use app\common\model\order\OrderRefund as OrderRefundModel;
|
use app\common\service\message\MessageService;
|
use app\operations\model\supplier\Supplier as SupplierRegionModel;
|
|
/**
|
* 售后管理模型
|
*/
|
class OrderRefund extends OrderRefundModel
|
{
|
// 定义全局的查询范围
|
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 getList($query = [])
|
{
|
|
$model = $this;
|
// 查询条件：订单号
|
if (isset($query['order_no']) && !empty($query['order_no'])) {
|
$model = $model->where('order.order_no', 'like', "%{$query['order_no']}%");
|
}
|
// 查询条件：起始日期
|
if (isset($query['create_time']) && !empty($query['create_time'])) {
|
$sta_time = array_shift($query['create_time']);
|
$end_time = array_pop($query['create_time']);
|
$model = $model->whereBetweenTime('m.create_time', $sta_time, date('Y-m-d 23:59:59', strtotime($end_time)));
|
}
|
// 售后类型
|
if (isset($query['type']) && $query['type'] > 0) {
|
$model = $model->where('m.type', '=', $query['type']);
|
}
|
|
// 售后单状态(选项卡)
|
if (isset($query['status']) && $query['status'] >= 0) {
|
$model = $model->where('m.status', '=', $query['status']);
|
}
|
|
if(isset($query['shop_supplier_ids'])&&$query['shop_supplier_ids']){
|
$model = $model->where('m.shop_supplier_id', 'in', $query['shop_supplier_ids']);
|
}
|
|
// 获取列表数据
|
$list = $model->alias('m')
|
->field('m.*, order.order_no')
|
->with(['orderproduct.image', 'orderMaster.advance', 'user', 'supplier'])
|
->join('order', 'order.order_id = m.order_id')
|
->order(['m.create_time' => 'desc'])
|
->paginate($query);
|
foreach ($list as &$item) {
|
if ($item['orderMaster']['order_source'] == 70) {
|
$item['orderproduct']['total_pay_price'] = round($item['orderproduct']['total_pay_price'] + $item['orderMaster']['advance']['pay_price'], 2);
|
}
|
}
|
return $list;
|
}
|
|
/**
|
* 获取平台售后单列表
|
*/
|
public function getplateList($query = [])
|
{
|
|
$model = $this;
|
// 查询条件：订单号
|
if (isset($query['order_no']) && !empty($query['order_no'])) {
|
$model = $model->where('order.order_no', 'like', "%{$query['order_no']}%");
|
}
|
// 查询条件：起始日期
|
if (isset($query['create_time']) && !empty($query['create_time'])) {
|
$sta_time = array_shift($query['create_time']);
|
$end_time = array_pop($query['create_time']);
|
$model = $model->whereBetweenTime('m.create_time', $sta_time, date('Y-m-d 23:59:59', strtotime($end_time)));
|
}
|
// 售后类型
|
if (isset($query['type']) && $query['type'] > 0) {
|
$model = $model->where('m.type', '=', $query['type']);
|
}
|
|
// 售后单状态(选项卡)
|
if (isset($query['plate_status']) && $query['plate_status'] == -1) {
|
$model = $model->where('m.plate_status', '>', 0);
|
}
|
if (isset($query['plate_status']) && in_array($query['plate_status'], [10, 20, 30])) {
|
$model = $model->where('m.plate_status', '=', $query['plate_status']);
|
}
|
if (isset($query['plate_status']) && $query['plate_status'] == 40) {
|
$model = $model->where('m.status', '=', 20)
|
->where('m.plate_status', '>', 10);
|
}
|
if(isset($query['shop_supplier_ids'])&&$query['shop_supplier_ids']){
|
$model = $model->where('m.shop_supplier_id', 'in', $query['shop_supplier_ids']);
|
}
|
|
// 获取列表数据
|
return $model->alias('m')
|
->field('m.*, order.order_no')
|
->with(['orderproduct.image', 'orderMaster', 'user', 'supplier'])
|
->join('order', 'order.order_id = m.order_id')
|
->order(['m.create_time' => 'desc'])
|
->paginate($query);
|
}
|
|
public function groupCount($query)
|
{
|
$model = $this;
|
// 查询条件：订单号
|
if (isset($query['order_no']) && !empty($query['order_no'])) {
|
$model = $model->where('order.order_no', 'like', "%{$query['order_no']}%");
|
}
|
// 查询条件：起始日期
|
if (isset($query['create_time']) && !empty($query['create_time'])) {
|
$sta_time = array_shift($query['create_time']);
|
$end_time = array_pop($query['create_time']);
|
$model = $model->whereBetweenTime('m.create_time', $sta_time, $end_time);
|
}
|
// 售后类型
|
if (isset($query['type']) && $query['type'] > 0) {
|
$model = $model->where('m.type', '=', $query['type']);
|
}
|
|
if(isset($query['shop_supplier_ids'])&&$query['shop_supplier_ids']){
|
$model = $model->where('m.shop_supplier_id', 'in', $query['shop_supplier_ids']);
|
}
|
|
// 获取列表数据
|
return $model->alias('m')
|
->field('m.status,COUNT(*) as total')
|
->join('order', 'order.order_id = m.order_id')
|
->group('m.status')->select()->toArray();
|
}
|
|
public function plategroupCount($query)
|
{
|
$model = $this;
|
// 查询条件：订单号
|
if (isset($query['order_no']) && !empty($query['order_no'])) {
|
$model = $model->where('order.order_no', 'like', "%{$query['order_no']}%");
|
}
|
// 查询条件：起始日期
|
if (isset($query['create_time']) && !empty($query['create_time'])) {
|
$sta_time = array_shift($query['create_time']);
|
$end_time = array_pop($query['create_time']);
|
$model = $model->whereBetweenTime('m.create_time', $sta_time, $end_time);
|
}
|
// 售后类型
|
if (isset($query['type']) && $query['type'] > 0) {
|
$model = $model->where('m.type', '=', $query['type']);
|
}
|
if(isset($query['shop_supplier_ids'])&&$query['shop_supplier_ids']){
|
$model = $model->where('m.shop_supplier_id', 'in', $query['shop_supplier_ids']);
|
}
|
// 获取列表数据
|
return $model->alias('m')
|
->field('m.plate_status,COUNT(*) as total')
|
->join('order', 'order.order_id = m.order_id')
|
->group('m.plate_status')->select()->toArray();
|
|
|
}
|
|
//获取已完成数
|
public function finishcount($query)
|
{
|
$model = $this;
|
// 查询条件：订单号
|
if (isset($query['order_no']) && !empty($query['order_no'])) {
|
$model = $model->where('order.order_no', 'like', "%{$query['order_no']}%");
|
}
|
// 查询条件：起始日期
|
if (isset($query['create_time']) && !empty($query['create_time'])) {
|
$sta_time = array_shift($query['create_time']);
|
$end_time = array_pop($query['create_time']);
|
$model = $model->whereBetweenTime('m.create_time', $sta_time, $end_time);
|
}
|
// 售后类型
|
if (isset($query['type']) && $query['type'] > 0) {
|
$model = $model->where('m.type', '=', $query['type']);
|
}
|
// 获取列表数据
|
return $model->alias('m')
|
->join('order', 'order.order_id = m.order_id')
|
->where('m.status', '=', 20)
|
->where('m.plate_status', '>', 10)
|
->count();
|
}
|
|
/**
|
* 平台审核
|
*/
|
public function plateaudit($data)
|
{
|
if ($data['is_agree'] == 20 && empty($data['plate_desc'])) {
|
$this->error = '请输入拒绝原因';
|
return false;
|
}
|
$this->startTrans();
|
try {
|
// 拒绝申请, 标记售后单状态为已拒绝
|
$data['is_agree'] == 20 && $data['status'] = 10;
|
// 同意换货申请, 标记售后单状态为已完成
|
//$data['is_agree'] == 10 && $this['type']['value'] == 20 && $data['status'] = 20;
|
$data['plate_status'] = $data['is_agree'] == 20 ? 30 : 20;
|
// 更新退款单状态
|
$this->save($data);
|
// 订单详情
|
$order = Order::detail($this['order_id']);
|
// 如果是同意退款，则直接退款
|
if ($data['plate_status'] == 20) {
|
if ($data['refund_money'] > $this['orderproduct']['total_pay_price']) {
|
$this->error = '退款金额不能大于商品实付款金额';
|
return false;
|
}
|
$this->refundMoney($order, $data);
|
}
|
// 发送模板消息
|
(new MessageService)->refund(self::detail($this['order_refund_id']), $order['order_no'], 'audit');
|
// 事务提交
|
$this->commit();
|
return true;
|
} catch (\Exception $e) {
|
$this->error = $e->getMessage();
|
$this->rollback();
|
return false;
|
}
|
}
|
|
|
/**
|
* 统计售后订单
|
*/
|
public function getRefundOrderTotal()
|
{
|
$filter['is_agree'] = 0;
|
return $this->where($filter)->count();
|
}
|
|
/**
|
* 统计售后订单
|
*/
|
public function getPlateOrderTotal()
|
{
|
$filter['plate_status'] = 10;
|
return $this->where($filter)->count();
|
}
|
}
|
