<?php
namespace app\service;
use think\facade\Db;
use app\service\PaymentService;
use app\service\BuyService;
use app\service\IntegralService;
use app\service\RegionService;
use app\service\BrandService;
use app\service\ExpressService;
use app\service\ResourcesService;
use app\service\PayLogService;
use app\service\UserService;
use app\service\GoodsService;
use app\service\OrderAftersaleService;
use app\service\OrderCurrencyService;
use app\service\WarehouseService;
use app\service\SystemService;
use app\service\OtherHandleService;
* 订单服务层
* @author Devil
* @blog http://gong.gg/
* @version 0.0.1
* @datetime 2016-12-01T21:51:08+0800
*/
class OrderService
{
* 业务类型名称
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2023-02-08
* @desc description
*/
public static function BusinessTypeName()
{
return 'order';
}
* 订单支付
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-26
* @desc description
* @param [array] $params [输入参数]
*/
public static function Pay($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'ids',
'error_msg' => MyLang('order_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$ids = is_array($params['ids']) ? $params['ids'] : explode(',', urldecode($params['ids']));
if(empty($ids))
{
return DataReturn(MyLang('order_id_error_tips'), -1);
}
$order_payment_id = 0;
$client_type = '';
$order_ids = [];
$order_nos = [];
$address_data = self::OrderAddressData($ids);
$order_data = [];
foreach($ids as $k=>$order_id)
{
$where = ['id'=>intval($order_id)];
$order = Db::name('Order')->where($where)->find();
if(empty($order))
{
return DataReturn(MyLang('order_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, 'user');
if($operate['is_pay'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.'-'.$order['order_no'].']', -1);
}
$detail = self::OrderItemList([$order]);
$order['detail'] = (empty($detail) || !array_key_exists($order['id'], $detail)) ? [] : $detail[$order['id']];
$order['user'] = UserService::UserHandle(UserService::UserInfo('id', $order['user_id']));
if(empty($order['user']))
{
return DataReturn(MyLang('common_service.order.order_user_invalid_tips').'['.$order_id.']', -1);
}
$order['address_data'] = (!empty($address_data) && array_key_exists($order_id, $address_data)) ? $address_data[$order_id] : '';
$order_data[] = $order;
$order_ids[] = $order['id'];
$order_nos[] = $order['order_no'];
if($k == 0)
{
$client_type = $order['client_type'];
$order_payment_id = $order['payment_id'];
}
}
$ret = BuyService::MoreOrderPayBeginCheck(array_merge($params, ['order_data'=>$order_data]));
if($ret['code'] != 0)
{
return $ret;
}
$total_price = 0;
$success_count = 0;
foreach($order_data as $order)
{
if($order['total_price'] <= 0.00)
{
$pay_result = self::OrderDirectSuccess([
'order' => $order,
'user' => $order['user'],
'params' => $params,
]);
if($pay_result['code'] == 0)
{
$success_count++;
continue;
}
return $pay_result;
}
$total_price += $order['total_price'];
}
if($success_count > 0 && $success_count == count($order_data))
{
return DataReturn(MyLang('operate_success'), 0, ['is_success'=>1]);
}
$payment = [];
$payment_id = empty($params['payment_id']) ? Db::name('Order')->where(['id'=>$ids[0]])->value('payment_id') : intval($params['payment_id']);
if(!empty($payment_id))
{
$payment = PaymentService::PaymentData(['where'=>['id'=>$payment_id]]);
}
if(empty($payment))
{
return DataReturn(MyLang('payment_method_error_tips'), -1);
}
if($payment['id'] != $order_payment_id)
{
Db::name('Order')->where(['id'=>$ids])->update([
'payment_id' => $payment['id'],
'is_under_line' => in_array($payment['payment'], MyConfig('shopxo.under_line_list')) ? 1 : 0,
'upd_time' => time(),
]);
}
$pay_checked = PaymentService::EntranceFileChecked($payment['payment'], 'order');
if($pay_checked['code'] != 0)
{
$payment_params = [
'payment' => $payment['payment'],
'respond' => '/index/order/respond',
'notify' => '/api/ordernotify/notify',
];
$ret = PaymentService::PaymentEntranceCreated($payment_params);
if($ret['code'] != 0)
{
return $ret;
}
}
$respond_url = $pay_checked['data']['respond'];
$notify_url = $pay_checked['data']['notify'];
if(!empty($params['redirect_url']))
{
$redirect_url = base64_decode(urldecode($params['redirect_url']));
if(!empty($redirect_url))
{
$respond_url = $redirect_url;
}
}
if(empty($redirect_url))
{
$redirect_url = MyUrl('index/order/index');
}
$current_user = empty($params['user']) ? UserService::LoginUserInfo() : $params['user'];
if(!empty($current_user))
{
$temp_user = UserService::UserHandle(UserService::UserInfo('id', $current_user['id']));
if(!empty($temp_user))
{
$current_user = $temp_user;
}
}
$hook_name = 'plugins_service_order_pay_launch_begin';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'user' => $current_user,
'business_ids' => $order_ids,
'business_nos' => $order_nos,
'business_data' => $order_data,
'total_price' => $total_price,
'payment' => $payment['payment'],
'payment_name' => $payment['name'],
'client_type' => $client_type,
'params' => &$params,
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
$pay_log = self::OrderPayLogInsert([
'user_id' => $current_user['id'],
'business_ids' => $order_ids,
'business_nos' => $order_nos,
'business_data' => $order_data,
'total_price' => $total_price,
'system_type' => $order_data[0]['system_type'],
'payment' => $payment['payment'],
'payment_name' => $payment['name'],
]);
if($pay_log['code'] != 0)
{
return $pay_log;
}
$pay_data = [
'params' => $params,
'user' => $current_user,
'out_user' => md5($current_user['id']),
'business_type' => 'system-order',
'business_ids' => $order_ids,
'business_nos' => $order_nos,
'business_data' => $order_data,
'payment_data' => $payment,
'order_id' => $pay_log['data']['id'],
'order_no' => $pay_log['data']['log_no'],
'name' => MyLang('common_service.order.pay_subject_name'),
'total_price' => $total_price,
'client_type' => $client_type,
'notify_url' => $notify_url,
'call_back_url' => $respond_url,
'redirect_url' => $redirect_url,
'site_name' => MyC('home_site_name', 'ShopXO', true),
'check_url' => MyUrl('index/order/paycheck'),
];
$hook_name = 'plugins_service_order_pay_launch_handle';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'pay_log_id' => $pay_log['data']['id'],
'pay_log_no' => $pay_log['data']['log_no'],
'order_ids' => $order_ids,
'params' => &$params,
'pay_data' => &$pay_data,
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
if(APPLICATION_CLIENT_TYPE == 'pc' && IsWeixinEnv() && empty($pay_data['user']['weixin_web_openid']))
{
$weixin_params = [
'is_pay_auto' => 1,
'is_pay_submit' => 1,
'payment_id' => $payment['id'],
];
if(count($order_ids) == 1)
{
$weixin_params['id'] = $order_ids[0];
$weixin_params['ids'] = $order_ids[0];
$url = MyUrl('index/order/detail', $weixin_params);
} else {
$weixin_params['ids'] = urldecode(implode(',', $order_ids));
$url = MyUrl('index/order/index', $weixin_params);
}
MySession('plugins_weixinwebauth_pay_callback_view_url', $url);
}
if($payment['payment'] == 'CashPayment')
{
MySession('payment_business_order_index_url', MyUrl('index/order/index'));
}
$pay_name = 'payment\\'.$payment['payment'];
$ret = (new $pay_name($payment['config']))->Pay($pay_data);
if(isset($ret['code']) && $ret['code'] == 0)
{
$ret['data'] = [
'is_payment_type' => 0,
'data' => $ret['data'],
'order_id' => $pay_log['data']['id'],
'order_no' => $pay_log['data']['log_no'],
'payment' => [
'id' => $payment['id'],
'name' => $payment['name'],
'payment' => $payment['payment'],
],
];
if(in_array($payment['payment'], MyConfig('shopxo.under_line_list')))
{
$ret['data']['is_payment_type'] = 1;
$pay_ret = self::UserOrderPayUnderLine($pay_log['data']['log_no']);
if($pay_ret['code'] == 0)
{
$ret['data']['is_success'] = 1;
} elseif($pay_ret['code'] == -8888)
{
$ret['msg'] = $pay_ret['msg'];
} else {
return $pay_ret;
}
} else {
if($payment['payment'] == 'WalletPay')
{
$ret['data']['is_payment_type'] = 2;
}
}
return $ret;
}
return DataReturn(
empty($ret['msg']) ? MyLang('common_service.order.pay_api_abnormal_tips') : $ret['msg'],
isset($ret['code']) ? $ret['code'] : -1,
isset($ret['data']) ? $ret['data'] : '');
}
* 新增订单支付日志
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2020-07-28
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderPayLogInsert($params = [])
{
$business_ids = isset($params['business_ids']) ? $params['business_ids'] : [];
$business_nos = isset($params['business_nos']) ? $params['business_nos'] : [];
return PayLogService::PayLogInsert([
'user_id' => isset($params['user_id']) ? intval($params['user_id']) : 0,
'system_type' => empty($params['system_type']) ? '' : $params['system_type'],
'business_ids' => is_array($business_ids) ? $business_ids : [$business_ids],
'business_nos' => is_array($business_nos) ? $business_nos : [$business_nos],
'total_price' => isset($params['total_price']) ? PriceNumberFormat($params['total_price']) : 0.00,
'subject' => MyLang('common_service.order.pay_subject_name'),
'payment' => isset($params['payment']) ? $params['payment'] : '',
'payment_name' => isset($params['payment_name']) ? $params['payment_name'] : '',
'business_type' => self::BusinessTypeName(),
]);
}
* 线下订单支付
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-26
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderPaymentUnderLinePay($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$where = ['id'=>intval($params['id'])];
$order = Db::name('Order')->where($where)->find();
if(empty($order))
{
return DataReturn(MyLang('data_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, 'admin');
if($operate['is_pay'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.'-'.$order['order_no'].']', -1);
}
$ret = BuyService::SingleOrderPayBeginCheck(['order_id'=>$order['id'], 'order_data'=>$order]);
if($ret['code'] != 0)
{
return $ret;
}
$payment_id = empty($params['payment_id']) ? $order['payment_id'] : intval($params['payment_id']);
$payment = PaymentService::PaymentData(['where'=>['id'=>$payment_id]]);
if(empty($payment))
{
return DataReturn(MyLang('payment_method_error_tips'), -1);
}
$user = UserService::GetUserViewInfo($order['user_id']);
if(empty($user))
{
return DataReturn(MyLang('common_service.order.order_user_invalid_tips'), -1);
}
return self::OrderPaymentUnderLineSuccess([
'order' => $order,
'payment' => $payment,
'user' => $user,
'params' => $params,
]);
}
* 订单金额为小于等于0直接成功
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2020-04-07
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderDirectSuccess($params = [])
{
if(!empty($params['order']) && !empty($params['user']))
{
if($params['order']['total_price'] <= 0.00)
{
$pay_params = [
'order' => [$params['order']],
'payment' => [],
'pay_log_data' => [],
'pay' => [
'trade_no' => '',
'subject' => isset($params['params']['subject']) ? $params['params']['subject'] : MyLang('common_service.order.pay_subject_name'),
'buyer_user' => $params['user']['user_name_view'],
'pay_price' => $params['order']['total_price'],
],
];
return self::OrderPayHandle($pay_params);
}
return DataReturn(MyLang('common_service.order.pay_price_error_tips'), -1);
}
return DataReturn(MyLang('common_service.order.pay_params_error_tips'), -1);
}
* 线下支付方式、直接支付成功
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2020-04-07
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderPaymentUnderLineSuccess($params = [])
{
if(!empty($params['order']) && !empty($params['payment']) && !empty($params['user']))
{
if(in_array($params['payment']['payment'], MyConfig('shopxo.under_line_list')))
{
$pay_log = self::OrderPayLogInsert([
'user_id' => $params['user']['id'],
'business_ids' => $params['order']['id'],
'business_nos' => $params['order']['order_no'],
'total_price' => $params['order']['total_price'],
'system_type' => $params['order']['system_type'],
'payment' => $params['payment']['payment'],
'payment_name' => $params['payment']['name'],
]);
if($pay_log['code'] != 0)
{
return $pay_log;
}
$pay_params = [
'order' => [$params['order']],
'payment' => $params['payment'],
'pay_log_data' => $pay_log['data'],
'pay' => [
'trade_no' => '',
'subject' => isset($params['params']['subject']) ? $params['params']['subject'] : MyLang('common_service.order.pay_subject_name'),
'buyer_user' => $params['user']['user_name_view'],
'pay_price' => $params['order']['total_price'],
],
];
return self::OrderPayHandle($pay_params);
}
return DataReturn(MyLang('common_service.order.only_under_line_error_tips'), -1);
}
return DataReturn(MyLang('common_service.order.pay_params_error_tips'), -1);
}
* 支付同步处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-28
* @desc 一般仅web端回调这个页面
* @param [array] $params [输入参数]
*/
public static function Respond($params = [])
{
$payment_name = defined('PAYMENT_TYPE') ? PAYMENT_TYPE : (isset($params['paymentname']) ? $params['paymentname'] : '');
if(empty($payment_name))
{
return DataReturn(MyLang('payment_method_error_tips'), -1);
}
$payment = PaymentService::PaymentData(['where'=>['payment'=>$payment_name]]);
if(empty($payment))
{
return DataReturn(MyLang('payment_method_error_tips'), -1);
}
$pay_name = 'payment\\'.$payment_name;
$pay_ret = (new $pay_name($payment['config']))->Respond(array_merge(input('get.'), input('post.')));
if(isset($pay_ret['code']) && $pay_ret['code'] == 0)
{
if(in_array($payment_name, MyConfig('shopxo.under_line_list')))
{
$ret = self::UserOrderPayUnderLine($pay_ret['data']['out_trade_no']);
if($ret['code'] == -8888)
{
$pay_ret['msg'] = $ret['msg'];
}
}
}
return DataReturn(
empty($pay_ret['msg']) ? MyLang('pay_fail') : $pay_ret['msg'],
isset($pay_ret['code']) ? $pay_ret['code'] : -100,
isset($pay_ret['data']) ? $pay_ret['data'] : ''
);
}
* 用户线下支付订单
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2021-08-13
* @desc description
* @param [string] $pay_log_no [订单支付日志单号]
*/
public static function UserOrderPayUnderLine($pay_log_no)
{
if(MyC('common_is_under_line_order_normal') == 1)
{
$pay_data = self::OrderPayLogValueList($pay_log_no);
if($pay_data['code'] != 0)
{
return $pay_data;
}
if($pay_data['data']['pay_log_data']['status'] == 1)
{
return DataReturn(MyLang('operate_success'), 0);
}
Db::startTrans();
try {
$order_ids = array_column($pay_data['data']['order_list'], 'id');
$upd_data = [
'status' => 2,
'upd_time' => time(),
];
if(!Db::name('Order')->where(['id'=>$order_ids])->update($upd_data))
{
throw new \Exception(MyLang('common_service.order.order_update_fail_tips'));
}
foreach($pay_data['data']['order_list'] as $order)
{
if(!self::OrderHistoryAdd($order['id'], $upd_data['status'], $order['status'], MyLang('common_service.order.user_under_line_pay_history_desc'), 0, MyLang('system_title')))
{
throw new \Exception(MyLang('common_service.order.order_status_history_insert_fail_tips').'['.$order['id'].']');
}
}
if(!Db::name('PayLog')->where(['log_no'=>$pay_log_no])->update(['status'=>1]))
{
throw new \Exception(MyLang('common_service.order.order_status_history_update_fail_tips'));
}
Db::commit();
return DataReturn(MyLang('pay_success'), 0);
} catch(\Exception $e) {
Db::rollback();
return DataReturn($e->getMessage(), -1);
}
}
return DataReturn(MyLang('common_service.order.order_submit_await_confirm_tips'), -8888);
}
* 支付异步
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-28
* @desc description
* @param [array] $params [输入参数]
*/
public static function Notify($params = [])
{
$payment = PaymentService::PaymentData(['where'=>['payment'=>PAYMENT_TYPE]]);
if(empty($payment))
{
return DataReturn(MyLang('payment_method_error_tips'), -1);
}
$pay_name = 'payment\\'.PAYMENT_TYPE;
if(!class_exists($pay_name))
{
return DataReturn(MyLang('payment_method_no_exist_tips').'['.PAYMENT_TYPE.']', -1);
}
$payment_obj = new $pay_name($payment['config']);
$method = method_exists($payment_obj, 'Notify') ? 'Notify' : 'Respond';
$pay_ret = $payment_obj->$method(array_merge(input('get.'), input('post.')));
if(!isset($pay_ret['code']) || $pay_ret['code'] != 0)
{
return $pay_ret;
}
return self::NotifyHandle($pay_ret['data'], $payment);
}
* 支付异步处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-28
* @desc description
* @param [array] $data [支付数据]
* @param [array] $payment [支付方式]
*/
public static function NotifyHandle($data, $payment)
{
if(empty($data['out_trade_no']))
{
return DataReturn(MyLang('order_no_error_tips').'[out_trade_no]', -1);
}
$pay_data = self::OrderPayLogValueList($data['out_trade_no']);
if($pay_data['code'] == 0)
{
if($pay_data['data']['pay_log_data']['status'] == 1)
{
return DataReturn(MyLang('common_service.order.pay_log_already_pay_tips'), 0);
}
} else {
return $pay_data;
}
if(MyC('common_is_pay_price_must_max_equal', 0) == 1)
{
if($data['pay_price'] < $pay_data['data']['pay_log_data']['total_price'])
{
return DataReturn(MyLang('common_service.order.pay_price_less_than_order_price_tips').'['.$data['pay_price'].'<'.$pay_data['data']['pay_log_data']['total_price'].']', -1);
}
}
$pay_params = [
'order' => $pay_data['data']['order_list'],
'payment' => $payment,
'pay_log_data' => $pay_data['data']['pay_log_data'],
'pay' => [
'trade_no' => $data['trade_no'],
'subject' => $data['subject'],
'buyer_user' => $data['buyer_user'],
'pay_price' => $data['pay_price'],
],
];
$hook_name = 'plugins_service_order_pay_notify_handle';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'payment' => $payment,
'order' => $pay_data['data']['order_list'],
'pay_params' => &$pay_params,
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
return self::OrderPayHandle($pay_params);
}
* 订单支付日志订单列表
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2021-08-13
* @desc description
* @param [string] $pay_log_no [支付日志订单号]
*/
public static function OrderPayLogValueList($pay_log_no)
{
$pay_log_data = Db::name('PayLog')->where(['log_no'=>$pay_log_no])->find();
if(empty($pay_log_data))
{
return DataReturn(MyLang('common_service.order.pay_log_error_tips'), -1);
}
$pay_log_value = Db::name('PayLogValue')->where(['pay_log_id'=>$pay_log_data['id']])->column('business_id');
if(empty($pay_log_value))
{
return DataReturn(MyLang('common_service.order.pay_log_value_error_tips'), -1);
}
$order_list = Db::name('Order')->where(['id'=>$pay_log_value, 'status'=>1])->select()->toArray();
if(empty($order_list) && $pay_log_data['status'] != 1)
{
return DataReturn(MyLang('order_info_incorrect_tips'), -1);
}
return DataReturn(MyLang('get_success'), 0, [
'pay_log_data' => $pay_log_data,
'order_list' => $order_list,
]);
}
* 订单支付处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2020-07-28
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderPayHandle($params = [])
{
if(empty($params['order']) || !is_array($params['order']))
{
return DataReturn(MyLang('common_service.order.order_data_empty_or_format_error_tips'), -1);
}
$order_total_price = array_sum(array_column($params['order'], 'total_price'));
if($order_total_price > 0)
{
if(empty($params['payment']))
{
return DataReturn(MyLang('payment_method_error_tips'), -1);
}
if(empty($params['pay_log_data']))
{
return DataReturn(MyLang('common_service.order.pay_log_error_tips'), -2);
}
}
if($order_total_price > 0 && !empty($params['pay_log_data']) && !empty($params['payment']))
{
$pay_log_status = Db::name('PayLog')->where(['id'=>$params['pay_log_data']['id']])->field('id,status')->value('status');
if($pay_log_status == 1)
{
return DataReturn(MyLang('pay_success'), 0);
}
}
Db::startTrans();
try {
if($order_total_price > 0 && !empty($params['pay_log_data']) && !empty($params['payment']))
{
$pay_log_data = [
'log_id' => $params['pay_log_data']['id'],
'trade_no' => isset($params['pay']['trade_no']) ? $params['pay']['trade_no'] : '',
'buyer_user' => isset($params['pay']['buyer_user']) ? $params['pay']['buyer_user'] : '',
'pay_price' => isset($params['pay']['pay_price']) ? $params['pay']['pay_price'] : 0,
'subject' => isset($params['pay']['subject']) ? $params['pay']['subject'] : MyLang('common_service.order.pay_subject_name'),
'payment' => $params['payment']['payment'],
'payment_name' => $params['payment']['name'],
];
$ret = PayLogService::PayLogSuccess($pay_log_data);
if($ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
}
foreach($params['order'] as $order)
{
if($order['pay_status'] != 0)
{
continue;
}
$hook_name = 'plugins_service_order_pay_handle_begin';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => &$params,
'order_id' => $order['id']
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
$detail = MyLang('common_service.order.order_pay_user_message_msg', ['price'=>$order['total_price']]);
MessageService::MessageAdd($order['user_id'], MyLang('common_service.order.pay_subject_name'), $detail, self::BusinessTypeName(), $order['id']);
$upd_data = [
'pay_status' => 1,
'pay_price' => $order['total_price'],
'pay_time' => time(),
'upd_time' => time(),
];
if($order['status'] <= 1)
{
$upd_data['status'] = 2;
}
if($order['total_price'] > 0 && !empty($params['payment']))
{
$upd_data['payment_id'] = $params['payment']['id'];
$upd_data['is_under_line'] = in_array($params['payment']['payment'], MyConfig('shopxo.under_line_list')) ? 1 : 0;
}
if(!Db::name('Order')->where(['id'=>$order['id']])->update($upd_data))
{
throw new \Exception(MyLang('common_service.order.order_update_fail_tips').'['.$order['id'].']');
}
if(array_key_exists('status', $upd_data))
{
if(!self::OrderHistoryAdd($order['id'], $upd_data['status'], $order['status'], MyLang('payment_title'), 0, MyLang('system_title')))
{
throw new \Exception(MyLang('common_service.order.order_status_history_insert_fail_tips').'['.$order['id'].']');
}
}
$ret = BuyService::OrderInventoryDeduct(['order_id'=>$order['id'], 'opt_type'=>'pay']);
if($ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
$ret = self::GoodsSalesCountInc(['order_id'=>$order['id'], 'opt_type'=>'pay']);
if($ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
$hook_name = 'plugins_service_order_pay_success_handle_end';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => $params,
'order' => $order,
'order_id' => $order['id']
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
if($order['order_model'] == 3)
{
self::OrderDeliveryHandle([
'id' => $order['id'],
'creator' => 0,
'creator_name' => MyLang('system_title'),
'user_id' => $order['user_id'],
'user_type' => 'admin',
]);
}
}
Db::commit();
return DataReturn(MyLang('pay_success'), 0);
} catch(\Exception $e) {
Db::rollback();
return DataReturn($e->getMessage(), -1);
}
}
* 订单列表条件
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-29
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderListWhere($params = [])
{
$user_type = isset($params['user_type']) ? $params['user_type'] : 'user';
$where = [
['is_delete_time', '=', 0],
];
$user_base_where = [];
if(!empty($params['id']))
{
$where[] = ['id', '=', intval($params['id'])];
}
if(!empty($params['orderno']))
{
$where[] = ['order_no', '=', trim($params['orderno'])];
}
if(isset($params['user_type']) && $params['user_type'] == 'user')
{
$where[] = ['user_is_delete_time', '=', 0];
if(!empty($params['user']))
{
$where[] = ['user_id', '=', $params['user']['id']];
$user_base_where[] = ['user_id', '=', $params['user']['id']];
}
}
if(!empty($params['keywords']))
{
$keywords_status = false;
$oids = Db::name('Order')->where(array_merge($user_base_where, [['id|order_no', '=', $params['keywords']]]))->column('id');
if(!empty($oids))
{
$where[] = ['id', 'in', $oids];
$keywords_status = true;
}
if($keywords_status === false)
{
$oid = Db::name('OrderExpress')->where(array_merge($user_base_where, [['express_number', '=', $params['keywords']]]))->value('order_id');
if(!empty($oid))
{
$where[] = ['id', '=', $oid];
$keywords_status = true;
}
}
if($keywords_status === false && strlen(intval($params['keywords'])) == 4)
{
$oid = Db::name('OrderExtractionCode')->where(array_merge($user_base_where, [['code', '=', $params['keywords']]]))->value('order_id');
if(!empty($oid))
{
$where[] = ['id', '=', $oid];
$keywords_status = true;
}
}
if($keywords_status === false)
{
$oids = Db::name('OrderAddress')->where(array_merge($user_base_where, [['name|tel|extraction_contact_name|extraction_contact_tel', '=', $params['keywords']]]))->column('order_id');
if(!empty($oids))
{
$where[] = ['id', 'in', $oids];
$keywords_status = true;
}
}
if($keywords_status === false)
{
$oids = Db::name('OrderDetail')->where(array_merge($user_base_where, [['title|spec|simple_desc|spec_desc|approval_number|batch_number|coding|model|produce_company|produce_region|goods_params|goods_content_app|goods_content_web|goods_use_guide|spec_coding|spec_barcode', 'like', '%'.$params['keywords'].'%']]))->column('order_id');
if(!empty($oids))
{
$where[] = ['id', 'in', $oids];
$keywords_status = true;
}
}
if($keywords_status === false)
{
$where[] = ['id', '<', 0];
}
}
if(isset($params['is_more']) && $params['is_more'] == 1)
{
if(isset($params['payment_id']) && $params['payment_id'] > -1)
{
$where[] = ['payment_id', '=', intval($params['payment_id'])];
}
if(isset($params['express_id']) && $params['express_id'] > -1)
{
$where[] = ['express_id', '=', intval($params['express_id'])];
}
if(isset($params['pay_status']) && $params['pay_status'] > -1)
{
$where[] = ['pay_status', '=', intval($params['pay_status'])];
}
if(isset($params['order_model']) && $params['order_model'] > -1)
{
$where[] = ['order_model', '=', intval($params['order_model'])];
}
if(!empty($params['client_type']))
{
$where[] = ['client_type', '=', $params['client_type']];
}
if(isset($params['status']) && $params['status'] != -1)
{
if(!is_array($params['status']))
{
$params['status'] = explode(',', $params['status']);
}
$where[] = ['status', 'in', $params['status']];
}
if(isset($params['is_comments']) && $params['is_comments'] > -1)
{
$comments_field = ($user_type == 'user') ? 'user_is_comments' : 'is_comments';
if($params['is_comments'] == 0)
{
$where[] = [$comments_field, '=', 0];
} else {
$where[] = [$comments_field, '>', 0];
}
}
if(!empty($params['time_start']))
{
$where[] = ['add_time', '>', strtotime($params['time_start'])];
}
if(!empty($params['time_end']))
{
$where[] = ['add_time', '<', strtotime($params['time_end'])];
}
if(!empty($params['price_start']))
{
$where[] = ['price', '>', floatval($params['price_start'])];
}
if(!empty($params['price_end']))
{
$where[] = ['price', '<', floatval($params['price_end'])];
}
}
return $where;
}
* 订单总数
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-29
* @desc description
* @param [array] $where [条件]
*/
public static function OrderTotal($where = [])
{
$hook_name = 'plugins_service_order_total_begin';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'where' => &$where,
]);
return (int) Db::name('Order')->where($where)->count();
}
* 订单状态各项总数
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-29
* @desc description
* @param [array] $where [条件]
*/
public static function OrderStatusGroupTotal($where = [])
{
$hook_name = 'plugins_service_order_status_group_total_begin';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'where' => &$where,
]);
return Db::name('Order')->where($where)->field('COUNT(DISTINCT id) AS count, status')->group('status')->select()->toArray();
}
* 订单列表
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-29
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderList($params = [])
{
$where = empty($params['where']) ? [] : $params['where'];
$field = empty($params['field']) ? '*' : $params['field'];
$order_by = empty($params['order_by']) ? 'id desc' : $params['order_by'];
$m = isset($params['m']) ? intval($params['m']) : 0;
$n = isset($params['n']) ? intval($params['n']) : 10;
$hook_name = 'plugins_service_order_list_begin';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => &$params,
'where' => &$where,
'field' => &$field,
'order_by' => &$order_by,
'm' => &$m,
'n' => &$n,
]);
$data = Db::name('Order')->where($where)->field($field)->limit($m, $n)->order($order_by)->select()->toArray();
return self::OrderListHandle($data, $params);
}
* 订单数据处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2020-07-05
* @desc description
* @param [array] $data [订单数据]
* @param [array] $params [输入参数]
*/
public static function OrderListHandle($data, $params = [])
{
$result = [];
if(!empty($data))
{
$hook_name = 'plugins_service_order_list_handle_begin';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => &$params,
'data' => &$data,
]);
$keys = ArrayKeys($data);
$order_ids = array_column($data, 'id');
$is_operate = isset($params['is_operate']) ? intval($params['is_operate']) : 0;
$is_items = isset($params['is_items']) ? intval($params['is_items']) : 1;
$is_orderaftersale = isset($params['is_orderaftersale']) ? intval($params['is_orderaftersale']) : 0;
$is_status_history = isset($params['is_status_history']) ? intval($params['is_status_history']) : 0;
$user_type = isset($params['user_type']) ? $params['user_type'] : 'user';
$order_status_list = MyConst('common_order_status');
$order_pay_status = MyConst('common_order_pay_status');
$common_platform_type = MyConst('common_platform_type');
$common_order_type_list = MyConst('common_order_type_list');
$order_take_status_name = MyLang('common_service.order.order_take_status_name');
$order_under_line_pay_status_name = MyLang('common_service.order.order_under_line_pay_status_name');
$order_under_line_name = MyLang('common_service.order.order_under_line_name');
if(in_array('warehouse_id', $keys))
{
$we_ids = array_unique(array_column($data, 'warehouse_id'));
$warehouse_list = WarehouseService::WarehouseListHandle(Db::name('Warehouse')->where(['id'=>$we_ids])->field('id,name')->select()->toArray());
if(!empty($warehouse_list))
{
$warehouse_list = array_column($warehouse_list, null, 'id');
}
}
$currency_default = ResourcesService::CurrencyData();
$currency_data = OrderCurrencyService::OrderCurrencyGroupList($order_ids);
if(in_array('user_id', $keys) && isset($params['is_public']) && $params['is_public'] == 0)
{
$user_list = UserService::GetUserViewInfo(array_column($data, 'user_id'));
}
$payment_list = PaymentService::OrderPaymentName($order_ids);
$extraction_data = self::OrderExtractionData($order_ids);
$address_data = self::OrderAddressData($order_ids);
$express_data = self::OrderExpressData($order_ids);
$service_data = self::OrderServiceData($order_ids);
$trace_source_data = self::OrderTraceSourceData($order_ids);
$detail = ($is_items == 1) ? self::OrderItemList($data, $is_orderaftersale, $trace_source_data) : [];
$use_guide_config = ($is_items == 1) ? ResourcesService::OrderDetailGoodsUseGuideConfig() : [];
$status_history_data = ($is_status_history == 1) ? self::OrderStatusHistoryList($order_ids) : [];
foreach($data as &$v)
{
$hook_name = 'plugins_service_order_handle_begin';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => &$params,
'order' => &$v,
'order_id' => $v['id']
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
$v['currency_data'] = (!empty($currency_data) && is_array($currency_data) && array_key_exists($v['id'], $currency_data)) ? $currency_data[$v['id']] : $currency_default;
if(isset($v['warehouse_id']))
{
if(!empty($warehouse_list) && is_array($warehouse_list) && array_key_exists($v['warehouse_id'], $warehouse_list))
{
$v['warehouse_name'] = $warehouse_list[$v['warehouse_id']]['name'];
$v['warehouse_icon'] = $warehouse_list[$v['warehouse_id']]['icon'];
$v['warehouse_url'] = $warehouse_list[$v['warehouse_id']]['url'];
} else {
$v['warehouse_name'] = '';
$v['warehouse_icon'] = '';
$v['warehouse_url'] = '';
}
}
if(in_array($v['order_model'], [0,1,2]))
{
$v['address_data'] = (!empty($address_data) && array_key_exists($v['id'], $address_data)) ? $address_data[$v['id']] : '';
if($v['order_model'] == 2)
{
$v['extraction_data'] = (isset($v['status']) && !in_array($v['status'], [0,1,5,6]) && !empty($extraction_data) && array_key_exists($v['id'], $extraction_data)) ? $extraction_data[$v['id']] : '';
}
}
$v['express_data'] = (!empty($express_data) && array_key_exists($v['id'], $express_data)) ? $express_data[$v['id']] : '';
$v['service_data'] = (!empty($service_data) && array_key_exists($v['id'], $service_data)) ? $service_data[$v['id']] : '';
$v['trace_source_data'] = (!empty($trace_source_data) && array_key_exists($v['id'], $trace_source_data)) ? $trace_source_data[$v['id']] : '';
if(isset($v['user_id']))
{
if(isset($params['is_public']) && $params['is_public'] == 0)
{
$v['user'] = (!empty($user_list) && is_array($user_list) && array_key_exists($v['user_id'], $user_list)) ? $user_list[$v['user_id']] : [];
}
}
$v['order_model_name'] = isset($common_order_type_list[$v['order_model']]) ? $common_order_type_list[$v['order_model']]['name'] : '';
$v['client_type_name'] = isset($common_platform_type[$v['client_type']]) ? $common_platform_type[$v['client_type']]['name'] : '';
$v['status_name'] = ($v['order_model'] == 2 && $v['status'] == 2) ? $order_take_status_name : (array_key_exists($v['status'], $order_status_list) ? $order_status_list[$v['status']]['name'] : '');
$v['pay_status_name'] = (in_array($v['status'], [2,3,4]) && $v['pay_status'] == 0) ? $order_under_line_pay_status_name : $order_pay_status[$v['pay_status']]['name'];
$v['payment_name'] = (!empty($payment_list) && is_array($payment_list) && array_key_exists($v['id'], $payment_list)) ? $payment_list[$v['id']] : '';
$v['is_under_line_text'] = ($v['is_under_line'] == 1) ? $order_under_line_name : '';
$v['is_can_launch_aftersale'] = OrderAftersaleService::OrderIsCanLaunchAftersale($v['collect_time']);
$v['add_time_time'] = date('Y-m-d H:i:s', $v['add_time']);
$v['add_time_date'] = date('Y-m-d', $v['add_time']);
$v['add_time'] = date('Y-m-d H:i:s', $v['add_time']);
$v['upd_time'] = empty($v['upd_time']) ? '' : date('Y-m-d H:i:s', $v['upd_time']);
$v['confirm_time'] = empty($v['confirm_time']) ? '' : date('Y-m-d H:i:s', $v['confirm_time']);
$v['pay_time'] = empty($v['pay_time']) ? '' : date('Y-m-d H:i:s', $v['pay_time']);
$v['delivery_time'] = empty($v['delivery_time']) ? '' : date('Y-m-d H:i:s', $v['delivery_time']);
$v['collect_time'] = empty($v['collect_time']) ? '' : date('Y-m-d H:i:s', $v['collect_time']);
$v['cancel_time'] = empty($v['cancel_time']) ? '' : date('Y-m-d H:i:s', $v['cancel_time']);
$v['close_time'] = empty($v['close_time']) ? '' : date('Y-m-d H:i:s', $v['close_time']);
$v['user_is_comments_time'] = ($v['user_is_comments'] == 0) ? '' : date('Y-m-d H:i:s', $v['user_is_comments']);
if(empty($v['user_note']))
{
$v['user_note'] = '';
}
$v['extension_data'] = empty($v['extension_data']) ? '' : json_decode($v['extension_data'], true);
if($is_items == 1)
{
$v['items'] = (!empty($detail) && array_key_exists($v['id'], $detail)) ? $detail[$v['id']] : [];
$v['items_count'] = count($v['items']);
$v['describe'] = MyLang('common_service.order.order_item_summary_desc', ['buy_number_count'=>$v['buy_number_count'], 'currency_symbol'=>$v['currency_data']['currency_symbol'], 'total_price'=>$v['total_price']]);
if(!empty($v['items']) && !empty($use_guide_config))
{
$use_guide_data = $use_guide_config;
foreach($v['items'] as $ivs)
{
if(!empty($ivs['goods_use_guide']))
{
$use_guide_data['data'][] = [
'title' => $ivs['title'],
'images' => $ivs['images'],
'goods_use_guide' => $ivs['goods_use_guide'],
];
}
}
$v['use_guide_data'] = empty($use_guide_data['data']) ? '' : $use_guide_data;
}
}
if($is_status_history == 1)
{
$v['status_history_data'] = array_key_exists($v['id'], $status_history_data) ? $status_history_data[$v['id']] : [];
}
if($user_type == 'admin')
{
$v['aftersale_first'] = self::OrderAftersaleFirst($v['id']);
}
if($is_operate == 1 && isset($v['status']) && isset($v['pay_status']))
{
$v['operate_data'] = self::OrderOperateData($v, $user_type);
}
$hook_name = 'plugins_service_order_handle_end';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => &$params,
'order' => &$v,
'order_id' => $v['id']
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
}
if($is_operate == 1 && APPLICATION_CLIENT_TYPE == 'weixin' && MyC('common_app_mini_weixin_upload_shipping_status') == 1)
{
$weixin_collect_order_ids = array_filter(array_map(function($item)
{
if(!empty($item['operate_data']) && isset($item['operate_data']['is_collect']) && $item['operate_data']['is_collect'] == 1)
{
return $item['id'];
}
}, $data));
if(!empty($weixin_collect_order_ids))
{
$pay_log = Db::name('PayLog')->alias('pl')->join('pay_log_value plv', 'pl.id=plv.pay_log_id')->where(['plv.business_id'=>$weixin_collect_order_ids, 'pl.business_type'=>self::BusinessTypeName(), 'pl.status'=>1, 'pl.payment'=>'Weixin'])->column('pl.trade_no', 'plv.business_id');
if(!empty($pay_log))
{
foreach($data as $dk=>$dv)
{
if(array_key_exists($dv['id'], $pay_log))
{
$data[$dk]['weixin_collect_data'] = $pay_log[$dv['id']];
}
}
}
}
}
$hook_name = 'plugins_service_order_list_handle_end';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'params' => &$params,
'data' => &$data,
]);
}
return DataReturn('success', 0, $data);
}
* 订单操作状态处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2021-08-13
* @desc description
* @param [array] $data [订单数据]
* @param [string] $user_type [用户类型（user 用户、admin 管理员）]
*/
public static function OrderOperateData($data, $user_type = 'user')
{
$result = [
'is_confirm' => 0,
'is_pay' => 0,
'is_delivery' => 0,
'is_service' => 0,
'is_tracesource' => 0,
'is_take' => 0,
'is_collect' => 0,
'is_cancel' => 0,
'is_delete' => 0,
'is_comments' => 0,
];
$order_id = empty($data['order_id']) ? (empty($data['id']) ? 0 : $data['id']) : $data['order_id'];
if(!empty($order_id) && isset($data['status']) && isset($data['pay_status']))
{
if($user_type == 'admin')
{
$result['is_confirm'] = ($data['status'] == 0) ? 1 : 0;
$result['is_pay'] = ($data['pay_status'] == 0 && !in_array($data['status'], [0,5,6])) ? 1 : 0;
$result['is_delivery'] = (isset($data['order_model']) && $data['order_model'] == 0 && in_array($data['status'], [2,3])) ? 1 : 0;
$result['is_service'] = (isset($data['order_model']) && $data['order_model'] == 1 && in_array($data['status'], [2,3])) ? 1 : 0;
$result['is_tracesource'] = in_array($data['status'], [2,3]) ? 1 : 0;
$result['is_take'] = (isset($data['order_model']) && in_array($data['order_model'], [2,3]) && $data['status'] == 2) ? 1 : 0;
$result['is_collect'] = ($data['status'] == 3) ? 1 : 0;
$result['is_cancel'] = (in_array($data['status'], [0,1]) || (in_array($data['status'], [2,3,4]) && $data['pay_status'] == 0)) ? 1 : 0;
$result['is_delete'] = (in_array($data['status'], [5,6]) && isset($data['is_delete_time']) && $data['is_delete_time'] == 0) ? 1 : 0;
if($result['is_delivery']+$result['is_service']+$result['is_take'] > 0 && $result['is_tracesource'] == 1)
{
static $order_service_config_order_operate_data_trace_source_goods_category_ids = null;
if($order_service_config_order_operate_data_trace_source_goods_category_ids === null)
{
$temp_source_config = MyC('common_order_trace_source_config');
if(!empty($temp_source_config) && is_array($temp_source_config))
{
$cids = call_user_func_array('array_merge', array_filter(array_map(function($item)
{
return empty($item['category_ids']) ? [] : $item['category_ids'];
}, $temp_source_config)));
if(!empty($cids))
{
$order_service_config_order_operate_data_trace_source_goods_category_ids = GoodsCategoryService::GoodsCategoryItemsIds($cids);
}
}
}
if(!empty($order_service_config_order_operate_data_trace_source_goods_category_ids))
{
$count = Db::name('Order')->alias('o')->join('order_detail od', 'o.id=od.order_id')->join('goods_category_join gcj', 'gcj.goods_id=od.goods_id')->where(['o.id'=>$order_id, 'gcj.category_id'=>$order_service_config_order_operate_data_trace_source_goods_category_ids])->count();
if($count > 0)
{
if(Db::name('OrderTraceSource')->where(['order_id'=>$order_id])->count() <= 0)
{
$result['is_delivery'] = 0;
$result['is_service'] = 0;
$result['is_take'] = 0;
}
} else {
$result['is_tracesource'] = 0;
}
}
}
} else {
$result['is_pay'] = ($data['status'] == 1) ? 1 : 0;
$result['is_collect'] = ($data['status'] == 3) ? 1 : 0;
$result['is_cancel'] = (in_array($data['status'], [0,1]) || $data['status'] == 2 && $data['pay_status'] == 0) ? 1 : 0;
$result['is_comments'] = ($data['status'] == 4 && isset($data['user_is_comments']) && $data['user_is_comments'] == 0) ? 1 : 0;
$result['is_delete'] = (in_array($data['status'], [4,5,6]) && isset($data['user_is_delete_time']) && $data['user_is_delete_time'] == 0) ? 1 : 0;
}
}
return $result;
}
* 订单最新一条售后
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2020-05-15
* @desc description
* @param [int] $order_id [订单 id]
*/
public static function OrderAftersaleFirst($order_id)
{
$data = Db::name('OrderAftersale')->where(['order_id'=>$order_id])->field('status,type,number,price,reason,msg')->order('id desc')->find();
if(!empty($data))
{
$type_list = MyConst('common_order_aftersale_type_list');
$status_list = MyConst('common_order_aftersale_status_list');
$data['type_text'] = array_key_exists($data['type'], $type_list) ? $type_list[$data['type']]['name'] : '';
$data['status_text'] = array_key_exists($data['status'], $status_list) ? $status_list[$data['status']]['name'] : '';
}
return $data;
}
* 订单日志数据
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2024-02-28
* @desc description
* @param [array|int] $order_ids [订单id]
*/
public static function OrderStatusHistoryList($order_ids)
{
$data = Db::name('OrderStatusHistory')->where(['order_id'=>$order_ids])->select()->toArray();
if(!empty($data))
{
$group = [];
foreach($data as &$v)
{
$v['add_time'] = empty($v['add_time']) ? '' : date('Y-m-d H:i:s', $v['add_time']);
if(is_array($order_ids))
{
if(!array_key_exists($v['order_id'], $group))
{
$group[$v['order_id']] = [];
}
$group[$v['order_id']][] = $v;
}
}
if(is_array($order_ids) && !empty($group))
{
$data = $group;
}
}
return $data;
}
* 订单详情列表
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2022-06-22
* @desc description
* @param [array] $order [订单信息]
* @param [int] $is_orderaftersale [是否读取订单售后（0否, 1是）]
* @param [array] $trace_source_data [订单追溯数据]
*/
public static function OrderItemList($order, $is_orderaftersale = 0, $trace_source_data = [])
{
$result = [];
$order = array_column($order, null, 'id');
$order_ids = array_keys($order);
$detail = Db::name('OrderDetail')->where(['order_id'=>$order_ids])->select()->toArray();
if(!empty($detail))
{
$order_detail_ids = array_column($detail, 'id');
$fictitious_value_list = Db::name('OrderFictitiousValue')->where(['order_detail_id'=>$order_detail_ids])->column('value', 'order_detail_id');
$orderaftersale = [];
if($is_orderaftersale == 1)
{
$temp_aftersale = Db::name('OrderAftersale')->where(['order_detail_id'=>$order_detail_ids])->order('id desc')->select()->toArray();
if(!empty($temp_aftersale))
{
foreach($temp_aftersale as $av)
{
if(!array_key_exists($av['order_detail_id'], $orderaftersale))
{
$orderaftersale[$av['order_detail_id']] = $av;
}
}
}
}
$base_fields = MyConst('common_goods_base_data_fields');
$produce_region = RegionService::RegionName(array_filter(array_column($detail, 'produce_region')));
$brand = BrandService::BrandName(array_filter(array_column($detail, 'brand_id')));
foreach($detail as $v)
{
if(array_key_exists($v['order_id'], $order))
{
$ov = $order[$v['order_id']];
$v['goods_url'] = GoodsService::GoodsUrlCreate($v['goods_id']);
$v['images'] = empty($v['images']) ? '' : ResourcesService::AttachmentPathViewHandle($v['images']);
$v['spec_text'] = '';
if(empty($v['spec']))
{
$v['spec'] = '';
} else {
$v['spec'] = json_decode($v['spec'], true);
if(!empty($v['spec']) && is_array($v['spec']))
{
$v['spec_text'] = implode('，', array_map(function($spec)
{
return $spec['type'].':'.$spec['value'];
}, $v['spec']));
}
}
if(isset($ov['order_model']) && isset($ov['pay_status']) && isset($ov['status']) && $ov['order_model'] == 3 && $ov['pay_status'] == 1 && in_array($ov['status'], [3,4]))
{
$v['fictitious_goods_value'] = (!empty($fictitious_value_list) && is_array($fictitious_value_list) && array_key_exists($v['id'], $fictitious_value_list)) ? ResourcesService::ContentStaticReplace($fictitious_value_list[$v['id']], 'get') : '';
}
if($is_orderaftersale == 1 && isset($ov['status']))
{
$v['orderaftersale'] = (!empty($orderaftersale) && array_key_exists($v['id'], $orderaftersale)) ? $orderaftersale[$v['id']] : '';
$v['orderaftersale_btn_text'] = self::OrderAftersaleStatusBtnText($ov['status'], $v['orderaftersale']);
}
$v['goods_content_web'] = empty($v['goods_content_web']) ? '' : ResourcesService::ContentStaticReplace($v['goods_content_web'], 'get');
$v['goods_use_guide'] = empty($v['goods_use_guide']) ? '' : ResourcesService::ContentStaticReplace($v['goods_use_guide'], 'get');
$v['goods_content_app'] = empty($v['goods_content_app']) ? '' : array_map(function($item)
{
$item['images'] = ResourcesService::AttachmentPathViewHandle($item['images']);
return $item;
}, json_decode($v['goods_content_app'], true));
$v['goods_params'] = empty($v['goods_params']) ? '' : json_decode($v['goods_params'], true);
$v['approval_number_expire'] = empty($v['approval_number_expire']) ? '' : date('Y-m-d', $v['approval_number_expire']);
$v['batch_number_expire'] = empty($v['batch_number_expire']) ? '' : date('Y-m-d', $v['batch_number_expire']);
$v['brand_name'] = (!empty($v['brand_id']) && !empty($brand) && array_key_exists($v['brand_id'], $brand)) ? $brand[$v['brand_id']] : '';
$v['produce_region_name'] = (!empty($v['produce_region']) && !empty($produce_region) && array_key_exists($v['produce_region'], $produce_region)) ? $produce_region[$v['produce_region']] : '';
if(!empty($base_fields) && is_array($base_fields))
{
$base_data = [];
foreach($base_fields as $bfk=>$bfv)
{
if(array_key_exists($bfk, $v) && $v[$bfk] != 0 && $v[$bfk] != '')
{
$base_data[] = [
'field' => $bfk,
'name' => $bfv,
'value' => $v[$bfk],
];
}
}
$v['base_data'] = empty($base_data) ? '' : $base_data;
}
if(!array_key_exists($v['order_id'], $result))
{
$result[$v['order_id']] = [];
}
$result[$v['order_id']][] = $v;
}
}
}
$hook_name = 'plugins_service_order_detail_data';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_ids' => $order_ids,
'data' => &$result,
'is_orderaftersale' => $is_orderaftersale,
'trace_source_data' => $trace_source_data,
]);
return $result;
}
* 订单自提信息
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2019-11-26
* @desc description
* @param [array] $order_ids [订单id]
*/
public static function OrderExtractionData($order_ids)
{
$result = [];
$data = Db::name('OrderExtractionCode')->where(['order_id'=>array_unique($order_ids)])->column('code', 'order_id');
if(!empty($data) && is_array($data))
{
foreach($order_ids as $v)
{
$images = '';
if(array_key_exists($v, $data))
{
$params = [
'content' => $data[$v],
'path' => DS.'download'.DS.'order'.DS.'extraction_code'.DS,
'filename' => $v.'.png',
];
$ret = (new \base\Qrcode())->Create($params);
$images = ($ret['code'] == 0) ? $ret['data']['url'] : '';
}
$result[$v] = [
'code' => isset($data[$v]) ? $data[$v] : '',
'images' => $images,
];
}
}
$hook_name = 'plugins_service_order_extraction_data';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_ids' => $order_ids,
'data' => &$result,
]);
return $result;
}
* 订单追溯
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2019-11-26
* @desc description
* @param [array] $order_ids [订单id]
*/
public static function OrderTraceSourceData($order_ids)
{
$result = [];
$data = Db::name('OrderTraceSource')->where(['order_id'=>$order_ids])->select()->toArray();
if(!empty($data) && is_array($data))
{
foreach($data as $v)
{
$v['batch_number_expire'] = empty($v['batch_number_expire']) ? '' : date('Y-m-d', $v['batch_number_expire']);
$v['add_time'] = empty($v['add_time']) ? '' : date('Y-m-d H:i:s', $v['add_time']);
$v['upd_time'] = empty($v['upd_time']) ? '' : date('Y-m-d H:i:s', $v['upd_time']);
if(!array_key_exists($v['order_id'], $result))
{
$result[$v['order_id']] = [];
}
if(!array_key_exists($v['order_detail_id'], $result[$v['order_id']]))
{
$result[$v['order_id']][$v['order_detail_id']] = [];
}
$result[$v['order_id']][$v['order_detail_id']][$v['buy_number_value']] = $v;
}
}
$hook_name = 'plugins_service_order_trace_source_data';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_ids' => $order_ids,
'data' => &$result,
]);
return $result;
}
* 订单服务
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2019-11-26
* @desc description
* @param [array] $order_ids [订单id]
*/
public static function OrderServiceData($order_ids)
{
$result = [];
$data = Db::name('OrderService')->where(['order_id'=>$order_ids])->select()->toArray();
if(!empty($data) && is_array($data))
{
$day_unit = MyLang('day_title');
$hour_unit = MyLang('hour_title');
$minute_unit = MyLang('minute_title');
foreach($data as $v)
{
if(empty($v['service_duration_minute']))
{
$v['service_duration_minute_text'] = '';
} else {
$hour = intval($v['service_duration_minute']/60);
$minute = $v['service_duration_minute']-($hour*60);
if($hour > 24)
{
$day = intval($hour/24);
$hours = $hour-($day*60);
$v['service_duration_minute_text'] = $day.$day_unit.(($hours <= 0) ? '' : $hours.$hour_unit);
} else {
$v['service_duration_minute_text'] = ($hour <= 0) ? '' : $hour.$hour_unit;
}
if(!empty($minute))
{
$v['service_duration_minute_text'] .= $minute.$minute_unit;
}
}
$v['service_start_time'] = empty($v['service_start_time']) ? '' : date('Y-m-d H:i:s', $v['service_start_time']);
$v['service_end_time'] = empty($v['service_end_time']) ? '' : date('Y-m-d H:i:s', $v['service_end_time']);
$v['add_time'] = empty($v['add_time']) ? '' : date('Y-m-d H:i:s', $v['add_time']);
$v['upd_time'] = empty($v['upd_time']) ? '' : date('Y-m-d H:i:s', $v['upd_time']);
if(!array_key_exists($v['order_id'], $result))
{
$result[$v['order_id']] = [];
}
$result[$v['order_id']][] = $v;
}
}
$hook_name = 'plugins_service_order_service_data';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_ids' => $order_ids,
'data' => &$result,
]);
return $result;
}
* 订单快递
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2019-11-26
* @desc description
* @param [array] $order_ids [订单id]
*/
public static function OrderExpressData($order_ids)
{
$data = [];
$temp = Db::name('OrderExpress')->where(['order_id'=>$order_ids])->select()->toArray();
if(!empty($temp) && is_array($temp))
{
$express_list = ExpressService::ExpressData(array_unique(array_filter(array_column($temp, 'express_id'))));
foreach($temp as $v)
{
$express = (!empty($express_list) && is_array($express_list) && array_key_exists($v['express_id'], $express_list)) ? $express_list[$v['express_id']] : '';
if(empty($express))
{
$v['express_name'] = '';
$v['express_icon'] = '';
$v['express_website_url'] = '';
} else {
$v['express_name'] = $express['name'];
$v['express_icon'] = $express['icon'];
$v['express_website_url'] = $express['website_url'];
}
$v['add_time'] = empty($v['add_time']) ? '' : date('Y-m-d H:i:s', $v['add_time']);
$v['upd_time'] = empty($v['upd_time']) ? '' : date('Y-m-d H:i:s', $v['upd_time']);
if(!array_key_exists($v['order_id'], $data))
{
$data[$v['order_id']] = [];
}
$data[$v['order_id']][] = $v;
}
}
$hook_name = 'plugins_service_order_express_data';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_ids' => $order_ids,
'data' => &$data,
]);
return empty($data) ? [] : $data;
}
* 订单地址
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2019-11-26
* @desc description
* @param [array] $order_ids [订单id]
*/
public static function OrderAddressData($order_ids)
{
$data = Db::name('OrderAddress')->where(['order_id'=>$order_ids])->column('*', 'order_id');
if(!empty($data) && is_array($data))
{
foreach($data as &$v)
{
$v['idcard_front_old'] = $v['idcard_front'];
$v['idcard_front'] = ResourcesService::AttachmentPathViewHandle($v['idcard_front']);
$v['idcard_back_old'] = $v['idcard_back'];
$v['idcard_back'] = ResourcesService::AttachmentPathViewHandle($v['idcard_back']);
}
}
$hook_name = 'plugins_service_order_address_data';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_ids' => $order_ids,
'data' => &$data,
]);
return empty($data) ? [] : $data;
}
* 订单售后操作名称
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @datetime 2019-10-04T13:11:55+0800
* @desc description
* @param [int] $order_status [订单状态]
* @param [array] $orderaftersale [售后数据]
*/
public static function OrderAftersaleStatusBtnText($order_status, $orderaftersale)
{
$text = '';
if(!in_array($order_status, [0,1,5,6]))
{
$lang = MyLang('common_service.order.orderaftersale_create_title_data');
if(empty($orderaftersale))
{
$text = $lang['default'];
if($order_status == 4)
{
$text = $lang['collect'];
}
} else {
$text = ($orderaftersale['status'] == 3) ? $lang['success'] : $lang['step'];
}
}
return $text;
}
* 订单日志添加
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [int] $order_id [订单id]
* @param [int] $new_status [更新后的状态]
* @param [int] $original_status [原始状态]
* @param [string] $msg [描述]
* @param [int] $creator [操作人]
* @param [string] $creator_name [操作人名称]
* @return [boolean] [成功 true, 失败 false]
*/
public static function OrderHistoryAdd($order_id, $new_status, $original_status, $msg = '', $creator = 0, $creator_name = '')
{
$status_list = MyConst('common_order_status');
$original_status_name = ($original_status != '' && isset($status_list[$original_status])) ? $status_list[$original_status]['name'] : '';
$new_status_name = ($new_status != '' && isset($status_list[$new_status])) ? $status_list[$new_status]['name'] : '';
if(!empty($original_status_name) && !empty($new_status_name))
{
$msg .= '['.$original_status_name.'-'.$new_status_name.']';
} else if(!empty($original_status_name))
{
$msg .= '['.$original_status_name.']';
} else if(!empty($new_status_name))
{
$msg .= '['.$new_status_name.']';
}
$data = [
'order_id' => intval($order_id),
'new_status' => intval($new_status),
'original_status' => intval($original_status),
'msg' => htmlentities($msg),
'creator' => intval($creator),
'creator_name' => htmlentities($creator_name),
'add_time' => time(),
];
if(Db::name('OrderStatusHistory')->insertGetId($data) > 0)
{
$hook_name = 'plugins_service_order_status_change_history_success_handle';
MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'data' => $data,
'order_id' => $data['order_id']
]);
return true;
}
return false;
}
* 订单追溯
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderTraceSource($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$user_type = empty($params['user_type']) ? 'user' : $params['user_type'];
$where = ['id'=>intval($params['id']), 'is_delete_time'=>0, 'user_is_delete_time'=>0];
$order = Db::name('Order')->where($where)->field('id,status,pay_status,user_id,order_model')->find();
if(empty($order))
{
return DataReturn(MyLang('data_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, $user_type);
if($operate['is_tracesource'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.']', -1);
}
$trace_source = self::OrderTraceSourceData([$order['id']]);
$trace_source_data = (empty($trace_source) || empty($trace_source[$order['id']])) ? [] : $trace_source[$order['id']];
if(!empty($params['data']))
{
if(!is_array($params['data']))
{
$params['data'] = json_decode(htmlspecialchars_decode($params['data']), true);
}
foreach($params['data'] as $k=>$v)
{
if(!empty($v) && is_array($v))
{
foreach($v as $ks=>$vs)
{
if(!empty($vs) && is_array($vs) && !empty($vs['goods_id']))
{
$data = [
'user_id' => $order['user_id'],
'order_id' => $order['id'],
'order_detail_id' => $k,
'goods_id' => $vs['goods_id'],
'buy_number_value' => $ks,
'code' => empty($vs['code']) ? '' : $vs['code'],
'batch_number' => empty($vs['batch_number']) ? '' : $vs['batch_number'],
'batch_number_expire' => empty($vs['batch_number_expire']) ? 0 : strtotime($vs['batch_number_expire']),
];
if(!empty($trace_source_data) && array_key_exists($data['order_detail_id'], $trace_source_data) && array_key_exists($data['buy_number_value'], $trace_source_data[$data['order_detail_id']]))
{
$temp_info = $trace_source_data[$data['order_detail_id']][$data['buy_number_value']];
$data['upd_time'] = time();
Db::name('OrderTraceSource')->where(['id'=>$temp_info['id']])->update($data);
} else {
$data['add_time'] = time();
Db::name('OrderTraceSource')->insertGetId($data);
}
}
}
}
}
}
return DataReturn(MyLang('operate_success'), 0);
}
* 订单取消
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderCancel($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user_id',
'error_msg' => MyLang('user_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$user_type = empty($params['user_type']) ? 'user' : $params['user_type'];
$where = ['id'=>intval($params['id']), 'user_id'=>$params['user_id'], 'is_delete_time'=>0, 'user_is_delete_time'=>0];
$order = Db::name('Order')->where($where)->field('id,status,pay_status,user_id,order_model')->find();
if(empty($order))
{
return DataReturn(MyLang('data_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, $user_type);
if($operate['is_cancel'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.']', -1);
}
Db::startTrans();
$upd_data = [
'status' => 5,
'cancel_time' => time(),
'upd_time' => time(),
];
if(Db::name('Order')->where($where)->update($upd_data))
{
$ret = BuyService::OrderInventoryRollback(['order_id'=>$order['id'], 'order_data'=>$upd_data]);
if($ret['code'] != 0)
{
Db::rollback();
return DataReturn($ret['msg'], -10);
}
$lang = MyLang('common_service.order.order_cancel_message_data');
MessageService::MessageAdd($order['user_id'], $lang['title'], $lang['desc'], self::BusinessTypeName(), $order['id']);
$creator = isset($params['creator']) ? intval($params['creator']) : 0;
$creator_name = isset($params['creator_name']) ? htmlentities($params['creator_name']) : '';
self::OrderHistoryAdd($order['id'], $upd_data['status'], $order['status'], MyLang('cancel_title'), $creator, $creator_name);
Db::commit();
return DataReturn(MyLang('cancel_success'), 0);
}
Db::rollback();
return DataReturn(MyLang('cancel_fail'), -1);
}
* 订单发货
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderDelivery($params = [])
{
Db::startTrans();
$ret = self::OrderDeliveryHandle($params);
if($ret['code'] == 0)
{
Db::commit();
} else {
Db::rollback();
}
return $ret;
}
* 订单发货处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderDeliveryHandle($params = [])
{
try {
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user_id',
'error_msg' => MyLang('user_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
throw new \Exception($ret);
}
$user_type = empty($params['user_type']) ? 'user' : $params['user_type'];
$where = ['id'=>intval($params['id']), 'user_id'=>$params['user_id'], 'is_delete_time'=>0, 'user_is_delete_time'=>0];
$order = Db::name('Order')->where($where)->field('id,status,pay_status,user_id,order_model,client_type')->find();
if(empty($order))
{
throw new \Exception(MyLang('order_no_exist_or_delete_error_tips'));
}
$operate = self::OrderOperateData($order, $user_type);
if($operate['is_delivery'] != 1 && $operate['is_take'] != 1 && $operate['is_service'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
throw new \Exception(MyLang('status_not_can_operate_tips').'['.$status_text.']');
}
switch($order['order_model'])
{
case 0 :
if((empty($params['express_id']) || empty($params['express_number'])) && empty($params['express_data']))
{
throw new \Exception(MyLang('common_service.order.delivery_express_data_message'));
}
break;
case 2 :
$p = [
[
'checked_type' => 'empty',
'key_name' => 'extraction_code',
'error_msg' => MyLang('common_service.order.take_extraction_code_message'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
throw new \Exception($ret);
}
$extraction_code = Db::name('OrderExtractionCode')->where(['order_id'=>$order['id']])->value('code');
if(empty($extraction_code))
{
throw new \Exception(MyLang('common_service.order.take_extraction_code_empty_tips'));
}
if($extraction_code != $params['extraction_code'])
{
throw new \Exception(MyLang('common_service.order.take_extraction_code_error_tips'));
}
break;
}
$ret = self::OrderDeliveryUpdateHandle($order, $params);
if($ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
return $ret;
} catch(\Exception $e) {
return DataReturn($e->getMessage(), -1);
}
}
* 订单发货更新处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $order [订单信息]
* @param [array] $params[输入参数]
*/
public static function OrderDeliveryUpdateHandle($order, $params = [])
{
switch($order['order_model'])
{
case 0 :
if(!empty($params['express_id']) && !empty($params['express_number']))
{
$express_data = [
'express_id' => intval($params['express_id']),
'express_number' => $params['express_number'],
];
if(empty($params['order_express_id']))
{
$express_data['order_id'] = $order['id'];
$express_data['user_id'] = $order['user_id'];
$express_data['add_time'] = time();
if(Db::name('OrderExpress')->insertGetId($express_data) <= 0)
{
return DataReturn(MyLang('common_service.order.delivery_express_insert_fail_tips'), -1);
}
} else {
$express_data['upd_time'] = time();
if(Db::name('OrderExpress')->where(['id'=>intval($params['order_express_id']), 'order_id'=>$order['id']])->update($express_data) === false)
{
return DataReturn(MyLang('common_service.order.delivery_express_update_fail_tips'), -1);
}
}
} else {
if(!empty($params['order_express_id']))
{
Db::name('OrderExpress')->where(['id'=>intval($params['order_express_id']), 'order_id'=>$order['id']])->delete();
}
if(!empty($params['express_data']))
{
if(!is_array($params['express_data']))
{
$params['express_data'] = json_decode(urldecode(htmlspecialchars_decode($params['express_data'])), true);
}
}
if(!empty($params['express_data']) && is_array($params['express_data']))
{
$express_data_old = Db::name('OrderExpress')->where(['order_id'=>$order['id']])->column('*', 'id');
$express_insert_data = [];
foreach($params['express_data'] as $ev)
{
if(!empty($ev['express_id']) && !empty($ev['express_number']))
{
$temp = [
'order_id' => $order['id'],
'user_id' => $order['user_id'],
'express_id' => intval($ev['express_id']),
'express_number' => $ev['express_number'],
'note' => empty($ev['note']) ? '' : $ev['note'],
];
if(empty($express_data_old) || empty($ev['id']) || empty($express_data_old[$ev['id']]))
{
$temp['add_time'] = time();
$temp['upd_time'] = 0;
} else {
$temp['add_time'] = $express_data_old[$ev['id']]['add_time'];
$temp['upd_time'] = time();
}
$express_insert_data[] = $temp;
}
}
if(!empty($express_data_old))
{
Db::name('OrderExpress')->where(['id'=>array_column($express_data_old, 'id'), 'order_id'=>$order['id']])->delete();
}
if(!empty($express_insert_data))
{
if(Db::name('OrderExpress')->insertAll($express_insert_data) < count($express_insert_data))
{
return DataReturn(MyLang('common_service.order.delivery_express_insert_fail_tips'), -1);
}
}
} else {
Db::name('OrderExpress')->where(['order_id'=>$order['id']])->delete();
}
}
break;
case 1 :
if(!empty($params['service_data']))
{
if(!is_array($params['service_data']))
{
$params['service_data'] = json_decode(urldecode(htmlspecialchars_decode($params['service_data'])), true);
}
}
if(!empty($params['service_data']) && is_array($params['service_data']))
{
$service_data_old = Db::name('OrderService')->where(['order_id'=>$order['id']])->column('*', 'id');
$express_insert_data = [];
foreach($params['service_data'] as $sv)
{
if(!empty($sv['service_name']) && !empty($sv['service_mobile']))
{
$temp = [
'order_id' => $order['id'],
'user_id' => $order['user_id'],
'service_name' => $sv['service_name'],
'service_mobile' => $sv['service_mobile'],
'service_start_time' => empty($sv['service_start_time']) ? 0 : strtotime($sv['service_start_time']),
'service_end_time' => empty($sv['service_end_time']) ? 0 : strtotime($sv['service_end_time']),
'note' => empty($sv['note']) ? '' : $sv['note'],
];
if(!empty($temp['service_start_time']) && !empty($temp['service_end_time']) && $temp['service_start_time'] < $temp['service_end_time'])
{
$temp['service_duration_minute'] = intval(($temp['service_end_time']-$temp['service_start_time'])/60);
} else {
$temp['service_duration_minute'] = 0;
}
if(empty($service_data_old) || empty($sv['id']) || empty($service_data_old[$sv['id']]))
{
$temp['add_time'] = time();
$temp['upd_time'] = 0;
} else {
$temp['add_time'] = $service_data_old[$sv['id']]['add_time'];
$temp['upd_time'] = time();
}
$service_insert_data[] = $temp;
}
}
if(!empty($service_data_old))
{
Db::name('OrderService')->where(['id'=>array_column($service_data_old, 'id'), 'order_id'=>$order['id']])->delete();
}
if(!empty($service_insert_data))
{
if(Db::name('OrderService')->insertAll($service_insert_data) < count($service_insert_data))
{
return DataReturn(MyLang('common_service.order.delivery_service_insert_fail_tips'), -1);
}
}
} else {
Db::name('OrderService')->where(['order_id'=>$order['id']])->delete();
}
break;
}
if($order['status'] != 3)
{
$upd_data = [
'status' => 3,
'delivery_time' => time(),
'upd_time' => time(),
];
if(Db::name('Order')->where(['id'=>$order['id']])->update($upd_data) === false)
{
return DataReturn(MyLang('delivery_fail'), -1);
}
$ret = BuyService::OrderInventoryDeduct(['order_id'=>$order['id'], 'opt_type'=>'delivery']);
if($ret['code'] != 0)
{
return $ret;
}
$lang = MyLang('common_service.order.order_delivery_message_data');
MessageService::MessageAdd($order['user_id'], $lang['title'], $lang['desc'], self::BusinessTypeName(), $order['id']);
$creator = isset($params['creator']) ? intval($params['creator']) : 0;
$creator_name = isset($params['creator_name']) ? htmlentities($params['creator_name']) : '';
self::OrderHistoryAdd($order['id'], $upd_data['status'], $order['status'], MyLang('delivery_title'), $creator, $creator_name);
}
$ret = self::OrderDeliverySyncWeixin($order, $params);
if(!empty($ret) && isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
$msg = ($order['order_model'] == 1) ? MyLang('service_success') : ($order['order_model'] == 2 ? MyLang('verification_success') : MyLang('delivery_success'));
return DataReturn($msg, 0);
}
* 微信小程序发货同步到微信小程序
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2024-01-16
* @desc description
* @param [array] $order [订单信息]
* @param [array] $params [输入参数]
*/
public static function OrderDeliverySyncWeixin($order, $params = [])
{
$order_detail = Db::name('OrderDetail')->where(['order_id'=>$order['id']])->column('title');
if(!empty($order_detail))
{
$order_address = self::OrderAddressData($order['id']);
$receiver_tel = (!empty($order_address) && !empty($order_address[$order['id']]) && !empty($order_address[$order['id']]['tel'])) ? $order_address[$order['id']]['tel'] : '';
if(!empty($params['express_data']) && !empty($params['express_data'][0]) && isset($params['express_data'][0]['express_id']) && isset($params['express_data'][0]['express_number']))
{
$params['express_id'] = $params['express_data'][0]['express_id'];
$params['express_number'] = $params['express_data'][0]['express_number'];
}
$express_id = isset($params['express_id']) ? intval($params['express_id']) : 0;
$express_number = isset($params['express_number']) ? $params['express_number'] : '';
return OtherHandleService::OrderDeliverySyncWeixinHandle([
'business_id' => $order['id'],
'business_type' => self::BusinessTypeName(),
'order_model' => $order['order_model'],
'goods_title' => $order_detail,
'express_id' => $express_id,
'express_number' => $express_number,
'receiver_tel' => $receiver_tel,
'express_data' => empty($params['express_data']) ? [] : $params['express_data'],
'service_data' => empty($params['service_data']) ? [] : $params['service_data'],
]);
}
return DataReturn(MyLang('handle_noneed'), 0);
}
* 订单收货
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderCollect($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user_id',
'error_msg' => MyLang('user_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$user_type = empty($params['user_type']) ? 'user' : $params['user_type'];
$where = ['id'=>intval($params['id']), 'user_id'=>$params['user_id'], 'is_delete_time'=>0, 'user_is_delete_time'=>0];
$order = Db::name('Order')->where($where)->field('id,status,pay_status,user_id,order_model')->find();
if(empty($order))
{
return DataReturn(MyLang('data_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, $user_type);
if($operate['is_collect'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.']', -1);
}
Db::startTrans();
$ret = self::OrderCollectHandle($order, $params);
if($ret['code'] == 0)
{
Db::commit();
} else {
Db::rollback();
}
return $ret;
}
* 订单收货完成处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2021-08-26
* @desc description
* @param [array] $order [订单数据]
* @param [array] $params [输入参数]
*/
public static function OrderCollectHandle($order, $params = [])
{
$upd_data = [
'status' => 4,
'collect_time' => time(),
'upd_time' => time(),
];
if(Db::name('Order')->where(['id'=>$order['id']])->update($upd_data))
{
$ret = IntegralService::OrderGoodsIntegralGiving(['order_id'=>$order['id']]);
if($ret['code'] != 0)
{
return $ret;
}
$ret = self::GoodsSalesCountInc(['order_id'=>$order['id'], 'opt_type'=>'collect']);
if($ret['code'] != 0)
{
return $ret;
}
$ret = self::OrderDeliverySyncWeixin($order, $params);
if(!empty($ret) && isset($ret['code']) && $ret['code'] != 0)
{
return $ret;
}
$lang = MyLang('common_service.order.order_collect_message_data');
MessageService::MessageAdd($order['user_id'], $lang['title'], $lang['desc'], self::BusinessTypeName(), $order['id']);
$creator = isset($params['creator']) ? intval($params['creator']) : 0;
$creator_name = isset($params['creator_name']) ? htmlentities($params['creator_name']) : '';
self::OrderHistoryAdd($order['id'], $upd_data['status'], $order['status'], MyLang('collect_title'), $creator, $creator_name);
return DataReturn(MyLang('collect_success'), 0);
}
return DataReturn(MyLang('collect_fail'), -1);
}
* 订单确认
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderConfirm($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user_id',
'error_msg' => MyLang('user_id_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$user_type = empty($params['user_type']) ? 'user' : $params['user_type'];
$where = ['id'=>intval($params['id']), 'user_id'=>$params['user_id'], 'is_delete_time'=>0, 'user_is_delete_time'=>0];
$order = Db::name('Order')->where($where)->field('id,status,pay_status,user_id,order_model')->find();
if(empty($order))
{
return DataReturn(MyLang('data_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, $user_type);
if($operate['is_confirm'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.']', -1);
}
Db::startTrans();
try {
$upd_data = [
'status' => 1,
'confirm_time' => time(),
'upd_time' => time(),
];
if(!Db::name('Order')->where($where)->update($upd_data))
{
throw new \Exception(MyLang('confirm_fail'));
}
$ret = BuyService::OrderInventoryDeduct(['order_id'=>$params['id'], 'opt_type'=>'confirm']);
if($ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
$lang = MyLang('common_service.order.order_confirm_message_data');
MessageService::MessageAdd($order['user_id'], $lang['title'], $lang['desc'], self::BusinessTypeName(), $order['id']);
$creator = isset($params['creator']) ? intval($params['creator']) : 0;
$creator_name = isset($params['creator_name']) ? htmlentities($params['creator_name']) : '';
self::OrderHistoryAdd($order['id'], $upd_data['status'], $order['status'], MyLang('confirm_title'), $creator, $creator_name);
Db::commit();
return DataReturn(MyLang('confirm_success'), 0);
} catch(\Exception $e) {
Db::rollback();
return DataReturn($e->getMessage(), -1);
}
}
* 订单删除
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-09-30
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderDelete($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'id',
'error_msg' => MyLang('order_id_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user_id',
'error_msg' => MyLang('user_id_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user_type',
'error_msg' => MyLang('user_type_error_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$user_type = empty($params['user_type']) ? 'user' : $params['user_type'];
switch($user_type)
{
case 'admin' :
$delete_field = 'is_delete_time';
break;
case 'user' :
$delete_field = 'user_is_delete_time';
break;
default :
$delete_field = empty($params['delete_field']) ? '' : $params['delete_field'];
}
if(empty($delete_field))
{
return DataReturn(MyLang('user_type_error_tips').'['.$user_type.']', -2);
}
$where = ['id'=>intval($params['id']), 'user_id'=>$params['user_id'], $delete_field=>0];
$order = Db::name('Order')->where($where)->field('id,status,pay_status,user_id,order_model,is_delete_time,user_is_delete_time')->find();
if(empty($order))
{
return DataReturn(MyLang('data_no_exist_or_delete_error_tips'), -1);
}
$operate = self::OrderOperateData($order, $user_type);
if($operate['is_delete'] != 1)
{
$status_text = MyConst('common_order_status')[$order['status']]['name'];
return DataReturn(MyLang('status_not_can_operate_tips').'['.$status_text.']', -1);
}
Db::startTrans();
try {
$data = [
$delete_field => time(),
'upd_time' => time(),
];
if(!Db::name('Order')->where($where)->update($data))
{
throw new \Exception(MyLang('delete_fail'));
}
$lang = MyLang('common_service.order.order_delete_message_data');
MessageService::MessageAdd($order['user_id'], $lang['title'], $lang['desc'], self::BusinessTypeName(), $order['id']);
$hook_name = 'plugins_service_order_delete_success';
$ret = EventReturnHandle(MyEventTrigger($hook_name, [
'hook_name' => $hook_name,
'is_backend' => true,
'order_id' => $params['id'],
'params' => $params,
]));
if(isset($ret['code']) && $ret['code'] != 0)
{
throw new \Exception($ret['msg']);
}
Db::commit();
return DataReturn(MyLang('delete_success'), 0);
} catch(\Exception $e) {
Db::rollback();
return DataReturn($e->getMessage(), -1);
}
}
* 订单每个环节状态总数
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-10-10
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderStatusStepTotal($params = [])
{
$result = [];
$is_comments = isset($params['is_comments']) && $params['is_comments'] == 1;
$is_aftersale = isset($params['is_aftersale']) && $params['is_aftersale'] == 1;
$order_status_list = MyConst('common_order_status_step_total_list');
foreach($order_status_list as $v)
{
if($v['value'] <= 6 || ($is_comments && $v['value'] == 100) || ($is_aftersale && $v['value'] == 101))
{
$result[] = [
'name' => $v['name'],
'status' => $v['value'],
'count' => 0,
];
}
}
$is_query = true;
$where = [
['is_delete_time', '=', 0]
];
$user_type = isset($params['user_type']) ? $params['user_type'] : 'user';
if($user_type == 'user')
{
if(empty($params['user']))
{
$is_query = false;
} else {
$where[] = ['user_is_delete_time', '=', 0];
$where[] = ['user_id', '=', $params['user']['id']];
}
}
if($is_query)
{
$data = self::OrderStatusGroupTotal($where);
if($is_comments)
{
switch($user_type)
{
case 'user' :
$where[] = ['user_is_comments', '=', 0];
break;
case 'admin' :
$where[] = ['is_comments', '=', 0];
break;
default :
$where[] = ['user_is_comments', '=', 0];
$where[] = ['is_comments', '=', 0];
}
$where[] = ['status', '=', 4];
$data[] = [
'status' => 100,
'count' => self::OrderTotal($where),
];
}
}
if($is_aftersale)
{
$aftersale = [
'status' => 101,
'count' => 0,
];
if($is_query)
{
$where = [
['status', '<=', 2],
];
if($user_type == 'user' && !empty($params['user']))
{
$where[] = ['user_id', '=', $params['user']['id']];
}
$aftersale['count'] = OrderAftersaleService::OrderAftersaleTotal($where);
}
$data[] = $aftersale;
}
if(!empty($data))
{
foreach($result as &$v)
{
foreach($data as $vs)
{
if($v['status'] == $vs['status'])
{
$v['count'] = $vs['count'];
continue;
}
}
}
}
return DataReturn('success', 0, $result);
}
* 订单商品销量添加
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2018-11-14
* @desc description
* @param [array] $params [输入参数]
*/
public static function GoodsSalesCountInc($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'order_id',
'error_msg' => MyLang('order_id_error_tips'),
],
[
'checked_type' => 'in',
'key_name' => 'opt_type',
'checked_data' => ['pay', 'collect'],
'error_msg' => '订单操作类型有误',
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$status = false;
if(MyC('common_goods_sales_count_inc_rules', 1) == 1)
{
if($params['opt_type'] == 'collect')
{
$status = true;
}
} else {
if($params['opt_type'] == 'pay')
{
$status = true;
}
}
if($status)
{
$order_detail = Db::name('OrderDetail')->field('id,goods_id,title,buy_number')->where(['order_id'=>$params['order_id']])->select()->toArray();
if(!empty($order_detail))
{
foreach($order_detail as $v)
{
if(Db::name('Goods')->where(['id'=>$v['goods_id']])->inc('sales_count', $v['buy_number'])->update() === false)
{
return DataReturn(MyLang('common_service.order.order_goods_sales_count_inc_fail_tips').'['.$v['title'].']', -10);
}
}
return DataReturn(MyLang('operate_success'), 0);
} else {
return DataReturn(MyLang('common_service.order.order_detail_goods_empty_tips'), -100);
}
}
return DataReturn(MyLang('handle_noneed'), 0);
}
* 支付状态校验
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2019-01-08
* @desc description
* @param [array] $params [输入参数]
*/
public static function OrderPayCheck($params = [])
{
$p = [
[
'checked_type' => 'empty',
'key_name' => 'order_no',
'error_msg' => MyLang('order_no_error_tips'),
],
[
'checked_type' => 'empty',
'key_name' => 'user',
'error_msg' => MyLang('user_info_incorrect_tips'),
],
];
$ret = ParamsChecked($params, $p);
if($ret !== true)
{
return DataReturn($ret, -1);
}
$where = ['log_no'=>$params['order_no'], 'user_id'=>$params['user']['id']];
$pay_log = Db::name('PayLog')->where($where)->field('id,status')->find();
if(empty($pay_log))
{
return DataReturn(MyLang('common_service.order.pay_log_error_tips'), -400, ['url'=>SystemService::DomainUrl()]);
}
if($pay_log['status'] == 1)
{
$pay_log_value = Db::name('PayLogValue')->where(['pay_log_id'=>$pay_log['id']])->column('business_id');
if(empty($pay_log_value) || count($pay_log_value) > 1)
{
$url = MyUrl('index/order/index');
} else {
$url = MyUrl('index/order/detail', ['id'=>$pay_log_value[0]]);
}
return DataReturn(MyLang('pay_success'), 0, ['url'=>$url]);
}
return DataReturn(MyLang('common_service.order.pay_have_in_hand_tips'), -333);
}
* 订单支付参数处理
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2021-08-07
* @desc description
* @param [array] $params [输入参数]
*/
public static function PayParamsHandle($params = [])
{
$payment_id = empty($params['payment_id']) ? '' : intval($params['payment_id']);
$order_ids = '';
if(!empty($params['ids']))
{
$ids = array_filter(array_map(function($v)
{
return intval($v);
}, explode(',', urldecode($params['ids']))));
if(!empty($ids))
{
$order_ids = implode(',', $ids);
}
}
return [
'payment_id' => $payment_id,
'order_ids' => $order_ids,
];
}
* 订单进度数据
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2023-01-23
* @desc description
* @param [array] $order [订单数据]
*/
public static function OrderStepData($order)
{
$result = [];
if(!empty($order))
{
$lang = MyLang('common_service.order.order_status_setp_data');
$result[] = [
'title' => $lang['add'],
'time' => $order['add_time'],
'is_check' => 1,
'is_current'=> 1,
];
if(in_array($order['status'], [5,6]))
{
switch($order['status'])
{
case 5 :
$result[] = [
'title' => $lang['cancel'],
'time' => $order['cancel_time'],
'is_check' => 1,
'is_current'=> 1,
];
break;
case 6 :
$result[] = [
'title' => $lang['close'],
'time' => $order['close_time'],
'is_check' => 1,
'is_current'=> 1,
];
break;
}
} else {
$result[] = [
'title' => $lang['pay'],
'time' => empty($order['pay_time']) ? '' : $order['pay_time'],
'is_check' => ($order['status'] > 1) ? 1 : 0,
'is_current'=> ($order['status'] == 2) ? 1 : 0,
];
$result[] = [
'title' => $lang['delivery'],
'time' => empty($order['delivery_time']) ? '' : $order['delivery_time'],
'is_check' => ($order['status'] > 2) ? 1 : 0,
'is_current'=> ($order['status'] == 3) ? 1 : 0,
];
$result[] = [
'title' => $lang['collect'],
'time' => empty($order['collect_time']) ? '' : $order['collect_time'],
'is_check' => ($order['status'] > 3) ? 1 : 0,
'is_current'=> ($order['status'] == 4) ? 1 : 0,
];
$is_current = empty($order['user_is_comments']) ? 0 : 1;
$result[] = [
'title' => $lang['comments'],
'time' => empty($order['user_is_comments_time']) ? '' : $order['user_is_comments_time'],
'is_check' => $is_current,
'is_current'=> $is_current,
];
}
}
return $result;
}
* 订单数据追溯过滤
* @author Devil
* @blog http://gong.gg/
* @version 1.0.0
* @date 2026-01-29
* @desc description
* @param [array] $order [订单数据]
*/
public static function OrderDataTraceSourceFilter($order)
{
if(!empty($order) && is_array($order) && !empty($order['items']) && is_array($order['items']))
{
$source_config = MyC('common_order_trace_source_config');
if(!empty($source_config) && is_array($source_config))
{
foreach($order['items'] as &$dv)
{
$is_trace_source = 0;
$trace_source_required = [];
foreach($source_config as $cv)
{
if(!empty($cv['category_ids']))
{
$count = Db::name('OrderDetail')->alias('od')->join('goods_category_join gcj', 'gcj.goods_id=od.goods_id')->where(['od.goods_id'=>$dv['goods_id'], 'gcj.category_id'=>GoodsCategoryService::GoodsCategoryItemsIds($cv['category_ids'])])->count();
if($count > 0)
{
$is_trace_source = 1;
$trace_source_required = empty($cv['required']) ? '' : $cv['required'];
break;
}
}
}
$dv['is_trace_source'] = $is_trace_source;
$dv['trace_source_required'] = $trace_source_required;
}
} else {
foreach($order['items'] as &$dv)
{
$dv['is_trace_source'] = 1;
$dv['trace_source_required'] = 0;
}
}
}
return $order;
}
}
?>