StoreOrder.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\merchant\model\order;
  12. use app\merchant\model\user\User;
  13. use app\admin\model\user\UserBill;
  14. use app\admin\model\wechat\WechatUser;
  15. use traits\ModelTrait;
  16. use basic\ModelBasic;
  17. use service\WechatTemplateService;
  18. use think\Url;
  19. use think\Db;
  20. use service\HookService;
  21. use EasyWeChat\Core\Exception;
  22. use service\SystemConfigService;
  23. use app\wap\model\routine\RoutineTemplate;
  24. use service\PhpSpreadsheetService;
  25. /**
  26. * 订单管理Model
  27. * Class StoreOrder
  28. * @package app\admin\model\order
  29. */
  30. class StoreOrder extends ModelBasic
  31. {
  32. use ModelTrait;
  33. public static function getOrderList($where)
  34. {
  35. $model = UserBill::where('u.uid', $where['uid'])->alias('u')->join('__STORE_ORDER__ a', 'a.id=u.link_id')
  36. ->where('u.category', 'now_money')->where('u.type', 'brokerage')
  37. ->where(['a.paid' => 1, 'a.is_gift' => 0, 'a.is_receive_gift' => 0])->order('a.add_time desc')->field('a.*');
  38. if ($where['start_date'] && $where['end_date']) $model = $model->where('a.add_time', 'between', [strtotime($where['start_date']), strtotime($where['end_date'])]);
  39. if ($where['excel']) {
  40. $list = $model->select();
  41. $excel = [];
  42. foreach ($list as $item) {
  43. $item['title'] = self::get_title($item);
  44. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  45. $item['nickname'] = self::getDb('user')->where('uid', $item['uid'])->value('nickname');
  46. $excel[] = [$item['add_time'], $item['order_id'], $item['nickname'], $item['title'], $item['pay_price']];
  47. }
  48. $filename = '直推订单导出' . time() . '.xlsx';
  49. $head = ['时间', '订单号', '用户名', '名称', '订单金额'];
  50. PhpSpreadsheetService::outdata($filename, $excel, $head);
  51. } else
  52. $list = $model->page((int)$where['page'], (int)$where['limit'])->select();
  53. $list = count($list) > 0 ? $list->toArray() : [];
  54. foreach ($list as &$item) {
  55. $item['title'] = self::get_title($item);
  56. $item['add_time'] = date('Y-m-d H:i:s', $item['add_time']);
  57. $item['nickname'] = self::getDb('user')->where('uid', $item['uid'])->value('nickname');
  58. }
  59. return $list;
  60. }
  61. public static function get_title($item)
  62. {
  63. switch ($item['type']) {
  64. case 0:
  65. return self::getDb('special')->where('id', $item['cart_id'])->value('title');
  66. break;
  67. case 1:
  68. return self::getDb('member_ship')->where('id', $item['member_id'])->value('title');
  69. break;
  70. case 2:
  71. $product_id = self::getDb('store_order_cart_info')->where('oid', $item['id'])->value('product_id');
  72. return self::getDb('store_product')->where('id', $product_id)->value('store_name');
  73. break;
  74. }
  75. }
  76. public static function orderCount($type = 0, $mer_id = 0)
  77. {
  78. $data['wz'] = self::statusByWhere(0, new self(), '', $type, $mer_id)->count();
  79. $data['wf'] = self::statusByWhere(1, new self(), '', $type, $mer_id)->count();
  80. $data['sh'] = self::statusByWhere(2, new self(), '', $type, $mer_id)->count();
  81. $data['pj'] = self::statusByWhere(3, new self(), '', $type, $mer_id)->count();
  82. $data['wc'] = self::statusByWhere(4, new self(), '', $type, $mer_id)->count();
  83. $data['pt'] = self::statusByWhere(5, new self(), '', $type, $mer_id)->count();
  84. $data['pu'] = self::statusByWhere(6, new self(), '', $type, $mer_id)->count();
  85. $data['lw'] = self::statusByWhere(7, new self(), '', $type, $mer_id)->count();
  86. $data['sp'] = self::statusByWhere(8, new self(), '', $type, $mer_id)->count();
  87. $data['vip'] = self::statusByWhere(9, new self(), '', $type, $mer_id)->count();
  88. $data['tk'] = self::statusByWhere(-1, new self(), '', $type, $mer_id)->count();
  89. $data['yt'] = self::statusByWhere(-2, new self(), '', $type, $mer_id)->count();
  90. return $data;
  91. }
  92. public static function OrderList($where)
  93. {
  94. $model = self::getOrderWhere($where, self::alias('a')->join('User r', 'r.uid=a.uid', 'LEFT'), 'a.', 'r')->field('a.*,r.nickname,r.phone');
  95. if ($where['order'] != '') {
  96. $model = $model->order(self::setOrder($where['order']));
  97. } else {
  98. $model = $model->order('a.id desc');
  99. }
  100. if (isset($where['mer_id']) && $where['mer_id']) $model->where('mer_id', $where['mer_id']);
  101. if (isset($where['excel']) && $where['excel'] == 1) {
  102. $data = ($data = $model->select()) && count($data) ? $data->toArray() : [];
  103. } else {
  104. $data = ($data = $model->page((int)$where['page'], (int)$where['limit'])->select()) && count($data) ? $data->toArray() : [];
  105. }
  106. foreach ($data as &$item) {
  107. switch ($item['type']) {
  108. case 0:
  109. $item['_info'] = db('special')->where('id', $item['cart_id'])->find();
  110. if ($item['pink_id']) {
  111. $item['pink_name'] = '[拼团订单]';
  112. $item['color'] = '#895612';
  113. } else if ($item['is_gift'] && !$item['pink_id']) {
  114. $item['pink_name'] = '[送礼物订单]';
  115. $item['color'] = '#895612';
  116. } else if (!$item['is_gift'] && !$item['pink_id'] && $item['gift_order_id']) {
  117. $item['pink_name'] = '[领礼物订单]';
  118. $item['color'] = '#895612';
  119. } else {
  120. $item['pink_name'] = '[普通订单]';
  121. $item['color'] = '#895612';
  122. }
  123. if (!$item['_info']) {
  124. $item['_info']['title'] = '专题被删除';
  125. } else {
  126. $len = strlen($item['_info']['title']);
  127. $item['_info']['title'] = $len > 16 ? mb_substr($item['_info']['title'], 0, 16) . '...' : $item['_info']['title'];
  128. }
  129. break;
  130. case 1:
  131. $item['_info'] = db('member_ship')->where('id', $item['member_id'])->find();
  132. $item['pink_name'] = '[会员订单]';
  133. $item['color'] = '#895612';
  134. if (!$item['_info']) $item['_info']['title'] = '会员被删除';
  135. break;
  136. case 2:
  137. $_info = Db::name('store_order_cart_info')->where('oid', $item['id'])->field('cart_info')->select();
  138. foreach ($_info as $k => &$v) {
  139. $cart_info = json_decode($v['cart_info'], true);
  140. if (!isset($cart_info['productInfo'])) $cart_info['productInfo'] = [];
  141. $len = strlen($cart_info['productInfo']['store_name']);
  142. $cart_info['productInfo']['store_name'] = $len > 30 ? mb_substr($cart_info['productInfo']['store_name'], 0, 30) . '...' : $cart_info['productInfo']['store_name'];
  143. $v['cart_info'] = $cart_info;
  144. unset($cart_info);
  145. }
  146. $item['_info'] = $_info;
  147. $item['pink_name'] = '[商品订单]';
  148. $item['color'] = '#895612';
  149. break;
  150. }
  151. if ($item['paid'] == 1) {
  152. switch ($item['pay_type']) {
  153. case 'weixin':
  154. $item['pay_type_name'] = '微信支付';
  155. break;
  156. case 'yue':
  157. $item['pay_type_name'] = '余额支付';
  158. break;
  159. case 'offline':
  160. $item['pay_type_name'] = '线下支付';
  161. break;
  162. case 'zhifubao':
  163. $item['pay_type_name'] = '支付宝支付';
  164. break;
  165. default:
  166. $item['pay_type_name'] = '其他支付';
  167. break;
  168. }
  169. } else {
  170. switch ($item['pay_type']) {
  171. case 'offline':
  172. $item['pay_type_name'] = '线下支付';
  173. $item['pay_type_info'] = 1;
  174. break;
  175. default:
  176. $item['pay_type_name'] = '未支付';
  177. break;
  178. }
  179. }
  180. if ($item['paid'] == 0 && $item['status'] == 0) {
  181. $item['status_name'] = '未支付';
  182. } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0 && $item['type'] != 2) {
  183. $item['status_name'] = '已支付';
  184. } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0 && $item['type'] == 2) {
  185. $item['status_name'] = '待发货';
  186. } else if ($item['paid'] == 1 && $item['status'] == 1 && $item['refund_status'] == 0 && $item['type'] == 2) {
  187. $item['status_name'] = '待收货';
  188. } else if ($item['paid'] == 1 && $item['status'] == 2 && $item['refund_status'] == 0 && $item['type'] == 2) {
  189. $item['status_name'] = '待评价';
  190. } else if ($item['paid'] == 1 && $item['status'] == 3 && $item['refund_status'] == 0 && $item['type'] == 2) {
  191. $item['status_name'] = '已完成';
  192. } else if ($item['paid'] == 1 && $item['refund_status'] == 1) {
  193. $item['status_name'] = <<<HTML
  194. <b style="color:#f124c7">申请退款</b><br/>
  195. HTML;
  196. } else if ($item['paid'] == 1 && $item['refund_status'] == 2) {
  197. $item['status_name'] = '已退款';
  198. }
  199. if ($item['paid'] == 0 && $item['status'] == 0 && $item['refund_status'] == 0) {
  200. $item['_status'] = 1;
  201. } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0) {
  202. $item['_status'] = 2;
  203. } else if ($item['paid'] == 1 && $item['refund_status'] == 1) {
  204. $item['_status'] = 3;
  205. } else if ($item['paid'] == 1 && $item['status'] == 1 && $item['refund_status'] == 0) {
  206. $item['_status'] = 4;
  207. } else if ($item['paid'] == 1 && $item['status'] == 2 && $item['refund_status'] == 0) {
  208. $item['_status'] = 5;
  209. } else if ($item['paid'] == 1 && $item['status'] == 3 && $item['refund_status'] == 0) {
  210. $item['_status'] = 6;
  211. } else if ($item['paid'] == 1 && $item['refund_status'] == 2) {
  212. $item['_status'] = 7;
  213. }
  214. $item['spread_name'] = '';
  215. $item['spread_name_two'] = '';
  216. if ($item['type'] == 0 || $item['type'] == 1) {
  217. if ($item['link_pay_uid']) {
  218. $spread_name = User::where('uid', $item['link_pay_uid'])->value('nickname');
  219. $item['spread_name'] = $spread_name ? $spread_name . '/' . $item['link_pay_uid'] : '无';
  220. $spread_uid_two = User::where('uid', $item['link_pay_uid'])->value('spread_uid');
  221. if ($spread_uid_two) {
  222. $spread_name_two = User::where('uid', $spread_uid_two)->value('nickname');
  223. $item['spread_name_two'] = $spread_name_two ? $spread_name_two . '/' . $spread_uid_two : '无';
  224. } else {
  225. $item['spread_name_two'] = '无';
  226. }
  227. } else if ($item['spread_uid']) {
  228. $spread_name = User::where('uid', $item['spread_uid'])->value('nickname');
  229. $item['spread_name'] = $spread_name ? $spread_name . '/' . $item['spread_uid'] : '无';
  230. $spread_uid_two = User::where('uid', $item['spread_uid'])->value('spread_uid');
  231. if ($spread_uid_two) {
  232. $spread_name_two = User::where('uid', $spread_uid_two)->value('nickname');
  233. $item['spread_name_two'] = $spread_name_two ? $spread_name_two . '/' . $spread_uid_two : '无';
  234. } else {
  235. $item['spread_name_two'] = '无';
  236. }
  237. } else {
  238. $item['spread_name'] = '无';
  239. $item['spread_name_two'] = '无';
  240. }
  241. } else {
  242. $item['spread_name'] = '不参与分销';
  243. $item['spread_name_two'] = '不参与分销';
  244. }
  245. }
  246. if (isset($where['excel']) && $where['excel'] == 1) {
  247. self::SaveExcel($data, $where['types']);
  248. }
  249. $count = self::getOrderWhere($where, self::alias('a')->join('user r', 'r.uid=a.uid', 'LEFT'), 'a.', 'r')->count();
  250. return compact('count', 'data');
  251. }
  252. /*
  253. * 保存并下载excel
  254. * $list array
  255. * return
  256. */
  257. public static function SaveExcel($list, $type)
  258. {
  259. $export = [];
  260. foreach ($list as $index => $item) {
  261. if ($item['paid'] == 0 && $item['status'] == 0) {
  262. $item['status_name'] = '未支付';
  263. } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0 && $item['type'] != 2) {
  264. $item['status_name'] = '已支付';
  265. } else if ($item['paid'] == 1 && $item['status'] == 0 && $item['refund_status'] == 0 && $item['type'] == 2) {
  266. $item['status_name'] = '待发货';
  267. } else if ($item['paid'] == 1 && $item['status'] == 1 && $item['refund_status'] == 0 && $item['type'] == 2) {
  268. $item['status_name'] = '待收货';
  269. } else if ($item['paid'] == 1 && $item['status'] == 2 && $item['refund_status'] == 0 && $item['type'] == 2) {
  270. $item['status_name'] = '已完成';
  271. } else if ($item['paid'] == 1 && $item['refund_status'] == 1) {
  272. $item['status_name'] = '退款中';
  273. } else if ($item['paid'] == 1 && $item['refund_status'] == 2) {
  274. $item['status_name'] = '已退款';
  275. }
  276. if ($type == 0) {
  277. $special = self::getDb('special')->where('id', $item['cart_id'])->field('title,money')->find();
  278. if ($special) {
  279. $goodsName = $special['title'] . '| ' . $special['money'];
  280. } else {
  281. $goodsName = '专题被删除';
  282. }
  283. $export[] = [
  284. $item['order_id'], $item['pay_type_name'],
  285. $item['total_num'], $item['total_price'], $item['pay_price'], $item['refund_price'],
  286. $goodsName,
  287. $item['spread_name'],
  288. $item['spread_name_two'],
  289. $item['paid'] == 1 ? '已支付' : '未支付' . '/支付时间: ' . ($item['pay_time'] > 0 ? date('Y/m/d H:i', $item['pay_time']) : '暂无'),
  290. $item['status_name'],
  291. $item['nickname'] . '/' . $item['uid'],
  292. $item['phone']
  293. ];
  294. } else if ($type == 2) {
  295. $_info = Db::name('store_order_cart_info')->where('oid', $item['id'])->column('cart_info');
  296. $goodsName = [];
  297. foreach ($_info as $k => $v) {
  298. $v = json_decode($v, true);
  299. $goodsName = implode(
  300. [$v['productInfo']['store_name'],
  301. isset($v['productInfo']['attrInfo']) ? '(' . $v['productInfo']['attrInfo']['suk'] . ')' : '',
  302. "[{$v['cart_num']} * {$v['truePrice']}]"
  303. ], ' ');
  304. }
  305. $item['cartInfo'] = $_info;
  306. $export[] = [
  307. $item['order_id'], $item['pay_type_name'],
  308. $item['total_num'], $item['total_price'], $item['total_postage'], $item['pay_price'], $item['refund_price'],
  309. $goodsName,
  310. $item['spread_name'],
  311. $item['spread_name_two'],
  312. $item['paid'] == 1 ? '已支付' : '未支付' . '/支付时间: ' . ($item['pay_time'] > 0 ? date('Y/m/d H:i', $item['pay_time']) : '暂无'),
  313. $item['status_name'],
  314. $item['nickname'] . '/' . $item['uid'],
  315. '收货人:' . $item['real_name'],
  316. '联系电话:' . $item['user_phone'],
  317. '收货地址:' . $item['user_address']
  318. ];
  319. } else if ($type == 1) {
  320. $_info = db('member_ship')->where('id', $item['member_id'])->find();
  321. if ($_info) {
  322. $goodsName = $_info['title'] . '会员| ' . $_info['price'];
  323. } else {
  324. $goodsName = '会员信息被删除';
  325. }
  326. $export[] = [
  327. $item['order_id'], $item['pay_type_name'],
  328. $item['total_price'], $item['pay_price'], $item['refund_price'],
  329. $goodsName,
  330. $item['spread_name'],
  331. $item['spread_name_two'],
  332. $item['paid'] == 1 ? '已支付' : '未支付' . '/支付时间: ' . ($item['pay_time'] > 0 ? date('Y/m/d H:i', $item['pay_time']) : '暂无'),
  333. $item['status_name'],
  334. $item['nickname'] . '/' . $item['uid'],
  335. $item['phone']
  336. ];
  337. }
  338. }
  339. switch ($type) {
  340. case 0:
  341. $filename = '专题课程订单导出' . time() . '.xlsx';
  342. $head = ['订单号', '支付方式', '专题总数', '专题总价', '支付金额', '退款金额', '专题信息', '推广人', '推广人上级', '支付状态', '订单状态', '微信昵称/UID', '手机号'];
  343. break;
  344. case 1:
  345. $filename = '会员订单导出' . time() . '.xlsx';
  346. $head = ['订单号', '支付方式', '会员总价', '支付金额', '退款金额', '会员信息', '推广人', '推广人上级', '支付状态', '订单状态', '微信昵称/UID', '手机号'];
  347. break;
  348. case 2:
  349. $filename = '商品订单导出' . time() . '.xlsx';
  350. $head = ['订单号', '支付方式', '商品总数', '商品总价', '邮费', '支付金额', '退款金额', '商品信息', '推广人', '推广人上级', '支付状态', '订单状态', '收货人', '联系电话', '收货地址'];
  351. break;
  352. }
  353. PhpSpreadsheetService::outdata($filename, $export, $head);
  354. }
  355. public static function statusByWhere($status, $model = null, $alert = '', $type = 0, $mer_id = 0)
  356. {
  357. if ($model == null) $model = new self;
  358. switch ($type) {
  359. case 0:
  360. $model = $model->where($alert . 'type', 0);
  361. break;
  362. case 1:
  363. $model = $model->where($alert . 'type', 1);
  364. break;
  365. case 2:
  366. $model = $model->where($alert . 'type', 2);
  367. break;
  368. }
  369. if ($mer_id) $model = $model->where($alert . 'mer_id', $mer_id);
  370. if ('' === $status)
  371. return $model;
  372. else if ($status == 0)//未支付
  373. return $model->where($alert . 'paid', 0)->where($alert . 'is_system_del', 0)->where($alert . 'status', 0)->where($alert . 'refund_status', 0);
  374. else if ($status == 1)//已支付 待发货
  375. return $model->where($alert . 'paid', 1)->where($alert . 'is_system_del', 0)->where($alert . 'status', 0)->where($alert . 'refund_status', 0);
  376. else if ($status == 2)//已支付 待收货
  377. return $model->where($alert . 'paid', 1)->where($alert . 'is_system_del', 0)->where($alert . 'status', 1)->where($alert . 'refund_status', 0);
  378. else if ($status == 3)//已支付 待评价
  379. return $model->where($alert . 'paid', 1)->where($alert . 'is_system_del', 0)->where($alert . 'status', 2)->where($alert . 'refund_status', 0);
  380. else if ($status == 4)//已支付 已完成
  381. return $model->where($alert . 'paid', 1)->where($alert . 'is_system_del', 0)->where($alert . 'status', 3)->where($alert . 'refund_status', 0);
  382. else if ($status == 5)//课程订单
  383. return $model->where($alert . 'combination_id', 0)->where($alert . 'is_system_del', 0)->where($alert . 'is_gift', 0);
  384. else if ($status == 6)// 拼团订单
  385. return $model->where($alert . 'combination_id', '>', 0)->where($alert . 'is_system_del', 0)->where($alert . 'is_gift', 0);
  386. else if ($status == 7)// 礼物订单
  387. return $model->where($alert . 'combination_id', 0)->where($alert . 'is_system_del', 0)->where($alert . 'is_gift', '>', 0);
  388. else if ($status == 8)//商品订单
  389. return $model->where($alert . 'combination_id', 0)->where($alert . 'is_system_del', 0)->where($alert . 'is_gift', 0);
  390. else if ($status == 9)//会员订单
  391. return $model->where($alert . 'combination_id', 0)->where($alert . 'is_system_del', 0)->where($alert . 'is_gift', 0);
  392. else if ($status == -1)//退款中
  393. return $model->where($alert . 'paid', 1)->where($alert . 'is_system_del', 0)->where($alert . 'refund_status', 1);
  394. else if ($status == -2)//已退款
  395. return $model->where($alert . 'paid', 1)->where($alert . 'is_system_del', 0)->where($alert . 'refund_status', 2);
  396. else
  397. return $model;
  398. }
  399. public static function timeQuantumWhere($startTime = null, $endTime = null, $model = null)
  400. {
  401. if ($model === null) $model = new self;
  402. if ($startTime != null && $endTime != null)
  403. $model = $model->where('add_time', '>', strtotime($startTime))->where('add_time', '<', strtotime($endTime));
  404. return $model;
  405. }
  406. public static function changeOrderId($orderId)
  407. {
  408. $ymd = substr($orderId, 2, 8);
  409. $key = substr($orderId, 16);
  410. return 'wx' . $ymd . date('His') . $key;
  411. }
  412. /**
  413. * 线下付款
  414. * @param $id
  415. * @return $this
  416. */
  417. public static function updateOffline($id)
  418. {
  419. $orderId = self::where('id', $id)->value('order_id');
  420. $res = self::where('order_id', $orderId)->update(['paid' => 1, 'pay_time' => time()]);
  421. return $res;
  422. }
  423. /**
  424. * 退款发送模板消息
  425. * @param $oid
  426. * $oid 订单id key
  427. */
  428. public static function refundTemplate($data, $oid)
  429. {
  430. $order = self::where('id', $oid)->find();
  431. $wechat_notification_message = SystemConfigService::get('wechat_notification_message');
  432. if ($wechat_notification_message == 1) {
  433. WechatTemplateService::sendTemplate(WechatUser::uidToOpenid($order['uid']), WechatTemplateService::ORDER_REFUND_STATUS, [
  434. 'first' => '亲,您的订单已退款,本次退款' . $data['refund_price'] . '金额',
  435. 'keyword1' => $order['order_id'],
  436. 'keyword2' => $data['refund_price'],
  437. 'keyword3' => date('Y-m-d H:i:s', $order['add_time']),
  438. 'remark' => '请查看账单'
  439. ], '');
  440. } else {
  441. $dataAdmin['character_string7']['value'] = $order['order_id'];
  442. $dataAdmin['time8']['value'] = date('Y-m-d H:i:s', $order['add_time']);
  443. $dataAdmin['amount3']['value'] = $data['refund_price'];
  444. RoutineTemplate::sendOrderRefundSuccess($dataAdmin, $order['uid'], Url::build('wap/special/order', ['uni' => $order['order_id']], true, true));
  445. }
  446. }
  447. /**
  448. * 处理where条件
  449. * @param $where
  450. * @param $model
  451. * @return mixed
  452. */
  453. public static function getOrderWhere($where, $model, $aler = '', $join = '')
  454. {
  455. if (isset($where['status']) && $where['status'] != '') {
  456. $model = self::statusByWhere($where['status'], $model, $aler, $where['types']);
  457. } else {
  458. $model = $model->where($aler . 'is_system_del', 0);
  459. }
  460. if (isset($where['real_name']) && $where['real_name'] != '') {
  461. $model = $model->where($aler . 'order_id|' . $aler . 'real_name|' . $aler . 'user_phone' . ($join ? '|' . $join . '.nickname|' . $join . '.uid|' . $join . '.phone' : ''), 'LIKE', "%$where[real_name]%");
  462. }
  463. if (isset($where['mer_id']) && $where['mer_id']) {
  464. $model = $model->where($aler . 'mer_id', $where['mer_id']);
  465. }
  466. $model = $model->where($aler . 'type', $where['types']);
  467. if ($where['type'] != '') {
  468. switch ($where['type']) {
  469. case 5:
  470. $model = $model->where($aler . 'combination_id', 0)->where($aler . 'is_gift', 0);
  471. break;
  472. case 6:
  473. $model = $model->where($aler . 'combination_id', '>', 0)->where($aler . 'is_gift', 0);
  474. break;
  475. case 7:
  476. $model = $model->where($aler . 'combination_id', 0)->where($aler . 'is_gift', '>', 0);
  477. break;
  478. case 8:
  479. $model = $model->where($aler . 'combination_id', 0)->where($aler . 'is_gift', 0);
  480. break;
  481. case 9:
  482. $model = $model->where($aler . 'combination_id', 0)->where($aler . 'is_gift', 0);
  483. break;
  484. }
  485. }
  486. if ($where['data'] !== '') {
  487. $model = self::getModelTime($where, $model, $aler . 'add_time');
  488. }
  489. return $model;
  490. }
  491. public static function getBadge($where)
  492. {
  493. $price = self::getOrderPrice($where);
  494. switch ($where['types']) {
  495. case 0:
  496. $name = '售出专题';
  497. break;
  498. case 1:
  499. $name = '售出会员';
  500. break;
  501. case 2:
  502. $name = '售出商品';
  503. break;
  504. }
  505. return [
  506. [
  507. 'name' => '订单数量',
  508. 'field' => '件',
  509. 'count' => $price['order_sum'],
  510. 'background_color' => 'layui-bg-blue',
  511. 'col' => 3
  512. ],
  513. [
  514. 'name' => $name,
  515. 'field' => '件',
  516. 'count' => $price['total_num'],
  517. 'background_color' => 'layui-bg-blue',
  518. 'col' => 3
  519. ],
  520. [
  521. 'name' => '订单金额',
  522. 'field' => '元',
  523. 'count' => $price['pay_price'],
  524. 'background_color' => 'layui-bg-blue',
  525. 'col' => 3
  526. ],
  527. [
  528. 'name' => '退款金额',
  529. 'field' => '元',
  530. 'count' => $price['refund_price'],
  531. 'background_color' => 'layui-bg-blue',
  532. 'col' => 3
  533. ],
  534. [
  535. 'name' => '微信支付金额',
  536. 'field' => '元',
  537. 'count' => $price['pay_price_wx'],
  538. 'background_color' => 'layui-bg-blue',
  539. 'col' => 3
  540. ],
  541. [
  542. 'name' => '余额支付金额',
  543. 'field' => '元',
  544. 'count' => $price['pay_price_yue'],
  545. 'background_color' => 'layui-bg-blue',
  546. 'col' => 3
  547. ],
  548. [
  549. 'name' => '支付宝支付金额',
  550. 'field' => '元',
  551. 'count' => $price['pay_price_zhifubao'],
  552. 'background_color' => 'layui-bg-blue',
  553. 'col' => 3
  554. ]
  555. ];
  556. }
  557. /**
  558. * 处理订单金额
  559. * @param $where
  560. * @return array
  561. */
  562. public static function getOrderPrice($where)
  563. {
  564. $price = array();
  565. $price['pay_price'] = 0;//支付金额
  566. $price['refund_price'] = 0;//退款金额
  567. $price['pay_price_wx'] = 0;//微信支付金额
  568. $price['pay_price_yue'] = 0;//余额支付金额
  569. $price['pay_price_offline'] = 0;//线下支付金额
  570. $price['pay_price_zhifubao'] = 0;//支付宝支付金额
  571. $price['pay_price_other'] = 0;//其他支付金额
  572. $list = self::getOrderWhere($where, self::alias('a')->join('User r', 'r.uid=a.uid', 'LEFT'), 'a.', 'r')->field([
  573. 'sum(a.total_num) as total_num',
  574. 'sum(a.pay_price) as pay_price',
  575. 'sum(a.refund_price) as refund_price'])->find()->toArray();
  576. $price['total_num'] = $list['total_num'];//商品总数
  577. $price['pay_price'] = $list['pay_price'];//支付金额
  578. $price['refund_price'] = $list['refund_price'];//退款金额
  579. $list = self::getOrderWhere($where, self::alias('a')->join('User r', 'r.uid=a.uid', 'LEFT'), 'a.', 'r')->field('sum(a.pay_price) as pay_price,a.pay_type')->group('a.pay_type')->select()->toArray();
  580. foreach ($list as $v) {
  581. if ($v['pay_type'] == 'weixin') {
  582. $price['pay_price_wx'] = $v['pay_price'];
  583. } elseif ($v['pay_type'] == 'yue') {
  584. $price['pay_price_yue'] = $v['pay_price'];
  585. } elseif ($v['pay_type'] == 'offline') {
  586. $price['pay_price_offline'] = $v['pay_price'];
  587. } elseif ($v['pay_type'] == 'zhifubao') {
  588. $price['pay_price_zhifubao'] = $v['pay_price'];
  589. } else {
  590. $price['pay_price_other'] = $v['pay_price'];
  591. }
  592. }
  593. $price['order_sum'] = self::getOrderWhere($where, self::alias('a')->join('User r', 'r.uid=a.uid', 'LEFT'), 'a.', 'r')->count();
  594. return $price;
  595. }
  596. }