ServiceOrderLogic.php 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761
  1. <?php
  2. namespace app\api\logic;
  3. use app\common\enum\GoodsEnum;
  4. use app\common\enum\PayEnum;
  5. use app\common\enum\WorkEnum;
  6. use app\common\logic\BaseLogic;
  7. use app\common\logic\PaymentLogic;
  8. use app\common\model\coupon\UserCoupon;
  9. use app\common\model\dict\DictData;
  10. use app\common\model\goods\Goods;
  11. use app\common\model\master_worker\MasterWorker;
  12. use app\common\model\orders\RechargeOrder;
  13. use app\common\model\recharge\OrderGoods;
  14. use app\common\model\spare_part\SparePart;
  15. use app\common\model\works\ServiceWork;
  16. use app\common\model\works\ServiceWorkSpare;
  17. use app\workerapi\logic\ServiceWorkLogLogic;
  18. use think\Exception;
  19. use think\facade\Db;
  20. /**
  21. * 订单逻辑层
  22. * Class ServiceOrderLogic
  23. * @package app\api\logic
  24. */
  25. class ServiceOrderLogic extends BaseLogic
  26. {
  27. /**
  28. * 提交订单
  29. * @param array $params
  30. * @return array|false
  31. */
  32. public static function submitOrder($params)
  33. {
  34. Db::startTrans();
  35. try {
  36. $goods = Goods::findOrEmpty($params['goods_id']);
  37. if($goods->isEmpty()){
  38. throw new Exception('产品不存在!');
  39. }
  40. if(empty($params['user_info']['mobile'])){
  41. throw new Exception('请先补充您的联系方式后在提交订单');
  42. }
  43. //根据服务工单计算当前订单应支付金额
  44. if($goods['goods_payment_type'] == GoodsEnum::ISGOODS_PAYMENT_TYPE){
  45. //一口价订单
  46. $order_total = $goods['service_fee'];
  47. $order_amount = $goods['service_fee'];
  48. }else{
  49. $order_total = $goods['base_service_fee'];
  50. $order_amount = $goods['service_fee'];
  51. }
  52. //优惠券验证
  53. if(!empty($params['coupon_id'])){
  54. $user_coupon = UserCoupon::where(['id'=>$params['coupon_id'],'user_id'=>$params['user_id'],'voucher_status'=>0])
  55. ->where('voucher_count','>',0)
  56. ->where('expire_time','>=',time())
  57. ->where('begin_use','<',time())
  58. ->findOrEmpty();
  59. if($user_coupon->isEmpty()){
  60. throw new Exception('该优惠券无法使用');
  61. }
  62. if($goods['goods_payment_type'] == GoodsEnum::ISGOODS_PAYMENT_TYPE and $order_amount<$user_coupon['amount_require']){
  63. throw new Exception('该优惠劵不满足满减使用条件');
  64. }
  65. if($goods['goods_payment_type'] != GoodsEnum::ISGOODS_PAYMENT_TYPE){
  66. throw new Exception('请在支付尾款的时候使用该优惠券');
  67. }
  68. //优惠券折扣
  69. if($user_coupon['mold_type'] == 1){
  70. //按比例折扣
  71. if($user_coupon['discount_ratio']>=1){
  72. throw new Exception('优惠券有误,请联系客服');
  73. }
  74. $order_coupon_amount = intval($order_amount*(1-$user_coupon['discount_ratio']));
  75. }else{
  76. $order_coupon_amount = $user_coupon['amount'];
  77. }
  78. if(!empty($user_coupon['max_deductible_price'])){
  79. $order_amount = ($order_coupon_amount>$user_coupon['max_deductible_price'])?($order_amount-$user_coupon['max_deductible_price']):($order_amount-$order_coupon_amount);
  80. }else{
  81. $order_amount = $order_amount-$order_coupon_amount;
  82. }
  83. $user_coupon->voucher_status = 1;
  84. $user_coupon->voucher_count = $user_coupon->voucher_count-1;
  85. $user_coupon->save();
  86. }
  87. //生成服务工单
  88. $work_data = [
  89. 'work_sn' => generate_sn(ServiceWork::class, 'work_sn'),
  90. 'real_name' => $params['contact_people'],
  91. 'mobile' => $params['contact_number'],
  92. 'address' => $params['address'],
  93. 'title' => $goods->goods_name . '*' . $goods->goods_number.$goods->good_unit,
  94. 'category_type' => $goods['category_type'],
  95. 'goods_category_ids' => $goods['goods_category_ids'],
  96. 'goods_category_id' => $goods['goods_category_id'],
  97. 'base_service_fee' => $goods['base_service_fee'],
  98. 'service_fee' => $goods['service_fee'],
  99. 'work_pay_status'=>WorkEnum::UN_PAY_STATUS,
  100. 'appointment_time' => strtotime($params['appointment_time']),
  101. 'user_id'=>$params['user_id'],
  102. 'lon'=>!empty($params['lon'])?$params['lon']:0,
  103. 'lat'=>!empty($params['lat'])?$params['lat']:0,
  104. ];
  105. //判断是否是加单
  106. if(!empty($params['worker'])){
  107. $worker_id = MasterWorker::where('worker_number',$params['worker'])->value('id');
  108. $work_data['master_worker_id'] = $worker_id;
  109. $work_data['work_status'] = 1;
  110. $work_data['dispatch_time'] = time();
  111. $work_data['work_type'] = 2;
  112. }
  113. $service_work = ServiceWork::create($work_data);
  114. //生成服务订单
  115. $data = [
  116. 'work_id'=> $service_work['id'],
  117. 'sn' => generate_sn(RechargeOrder::class, 'sn'),
  118. 'order_type'=>0,//服务订单
  119. 'order_terminal' => $params['terminal'],
  120. 'payment_type'=>$goods['goods_payment_type']==1?1:0,
  121. 'user_id' => $params['user_id'],
  122. 'pay_status' => PayEnum::UNPAID,
  123. 'coupon_id'=>!empty($params['coupon_id'])?$params['coupon_id']:0,
  124. 'coupon_price'=>!empty($order_coupon_amount)?$order_coupon_amount:0,
  125. 'pay_way' => $params['pay_way'],
  126. 'order_total' => $order_total,
  127. 'order_amount' => $order_amount,
  128. ];
  129. $order = RechargeOrder::create($data);
  130. //生成订单服务详情
  131. OrderGoods::create([
  132. 'sn' => $order['sn'],
  133. 'goods_id' => $params['goods_id'],
  134. 'category_type' => $goods['category_type'],
  135. 'goods_category_ids' => $goods['goods_category_ids'],
  136. 'goods_category_id' => $goods['goods_category_id'],
  137. 'goods_name' => $goods['goods_name'],
  138. 'goods_image' => $goods['goods_image'],
  139. 'goods_video' => $goods['goods_video'],
  140. 'goods_number' => $goods['goods_number'],
  141. 'good_unit' => $goods['good_unit'],
  142. 'goods_size' => $goods['goods_size'],
  143. 'goods_type' => $goods['goods_type'],
  144. 'goods_brand' => $goods['goods_brand'],
  145. 'install_guide' => $goods['install_guide'],
  146. 'goods_payment_type'=>$goods['goods_payment_type'],
  147. 'base_service_fee' => $goods['base_service_fee'],
  148. 'service_total' => $goods['service_total'],
  149. 'service_fee' => $goods['service_fee'],
  150. 'service_image' => $goods['service_image'],
  151. 'warranty_period'=>$goods['warranty_period'],
  152. 'fee_schedule' => $goods['fee_schedule'],
  153. 'goods_status' => $goods['goods_status'],
  154. ]);
  155. Db::commit();
  156. } catch (\Exception $e) {
  157. self::setError($e->getMessage());
  158. return false;
  159. }
  160. return [
  161. 'order_id' => (int)$order['id'],
  162. 'work_id' => (int)$order['work_id'],
  163. ];
  164. }
  165. /**
  166. * 提交尾款订单
  167. * @param array $params
  168. * @return array|false
  169. */
  170. public static function submitFinalOrder($params)
  171. {
  172. Db::startTrans();
  173. try {
  174. $order = \app\common\model\recharge\RechargeOrder::where('sn',$params['sn'])->findOrEmpty();
  175. if ($order->isEmpty()) {
  176. throw new Exception('订单不存在');
  177. }
  178. //判断订单类型.服务订单尾款处理
  179. if($order['order_type'] == 0 and $order['pay_status'] == PayEnum::ISPAID)//服务工单
  180. {
  181. $order = RechargeOrder::where(['work_id'=>$order['work_id'],'pay_status'=>0])->findOrEmpty();
  182. if($order->isEmpty()){
  183. throw new Exception('订单已支付');
  184. }
  185. }
  186. if ($order['pay_status'] == PayEnum::ISPAID) {
  187. throw new Exception('订单已支付');
  188. }
  189. $order_goods = OrderGoods::where('sn',$params['sn'])->findOrEmpty();
  190. $goods = Goods::findOrEmpty($order_goods['goods_id']);
  191. //判断是否存在优惠券
  192. //优惠券验证
  193. if(!empty($order['coupon_id'])){
  194. $order->coupon_id = 0;
  195. $order->coupon_price = 0;
  196. $order->order_amount = $order->order_total;
  197. $order->save();
  198. $user_coupon_ed = UserCoupon::findOrEmpty($order['coupon_id']);
  199. $user_coupon_ed->voucher_count = $user_coupon_ed->voucher_count+1;
  200. $user_coupon_ed->voucher_status = 0;
  201. $user_coupon_ed->save();
  202. $order = \app\common\model\recharge\RechargeOrder::where('sn',$order['sn'])->findOrEmpty();
  203. }
  204. if(!empty($params['coupon_id']) && empty($order['coupon_id'])){
  205. $user_coupon = UserCoupon::where(['id'=>$params['coupon_id'],'user_id'=>$params['user_id'],'voucher_status'=>0])
  206. ->where('voucher_count','>',0)
  207. ->where('expire_time','>=',time())
  208. ->where('begin_use','<',time())
  209. ->findOrEmpty();
  210. if($user_coupon->isEmpty()){
  211. throw new Exception('该优惠券无法使用');
  212. }
  213. if($goods['goods_payment_type'] == GoodsEnum::ISGOODS_PAYMENT_TYPE and $order['order_amount']<$user_coupon['amount_require']){
  214. throw new Exception('该优惠劵不满足满减使用条件');
  215. }
  216. //优惠券折扣
  217. if($user_coupon['mold_type'] == 1){
  218. //按比例折扣
  219. if($user_coupon['discount_ratio']>=1){
  220. throw new Exception('优惠券有误,请联系客服');
  221. }
  222. $order_coupon_amount = intval($order['order_amount']*(1-$user_coupon['discount_ratio']));
  223. }else{
  224. $order_coupon_amount = $user_coupon['amount'];
  225. }
  226. if(!empty($user_coupon['max_deductible_price'])){
  227. $order_amount = ($order_coupon_amount>$user_coupon['max_deductible_price'])?($order['order_amount']-$user_coupon['max_deductible_price']):($order['order_amount']-$order_coupon_amount);
  228. }else{
  229. $order_amount = $order['order_amount']-$order_coupon_amount;
  230. }
  231. $user_coupon->voucher_status = 1;
  232. $user_coupon->voucher_count = $user_coupon->voucher_count-1;
  233. $user_coupon->save();
  234. }
  235. $order->coupon_id = !empty($params['coupon_id'])?$params['coupon_id']:0;
  236. $order->coupon_price = !empty($order_coupon_amount)?$order_coupon_amount:0;
  237. $order->order_amount = !empty($order_amount)?$order_amount:$order->order_amount;
  238. $order->save();
  239. Db::commit();
  240. } catch (\Exception $e) {
  241. self::setError($e->getMessage());
  242. return false;
  243. }
  244. return [
  245. 'order_id' => (int)$order['id'],
  246. 'work_id' => (int)$order['work_id'],
  247. ];
  248. }
  249. /**
  250. * 重置订单优惠券
  251. * * @param $params
  252. * * * @return array|false
  253. */
  254. public static function cancelOrderCoupon($params)
  255. {
  256. Db::startTrans();
  257. try {
  258. $order = \app\common\model\recharge\RechargeOrder::where('id',$params['order_id'])->findOrEmpty();
  259. if(!empty($order['coupon_id'])){
  260. $user_coupon_ed = UserCoupon::findOrEmpty($order['coupon_id']);
  261. $user_coupon_ed->voucher_count = $user_coupon_ed->voucher_count+1;
  262. $user_coupon_ed->voucher_status = 0;
  263. $user_coupon_ed->save();
  264. $order->order_amount = $order->order_amount+$order->coupon_price;
  265. $order->coupon_id = 0;
  266. $order->coupon_price = 0;
  267. $order->save();
  268. }
  269. Db::commit();
  270. } catch (\Exception $e) {
  271. self::setError($e->getMessage());
  272. return false;
  273. }
  274. }
  275. /**
  276. * 获取订单工程师信息
  277. * * @param $params
  278. * * @return array|false
  279. */
  280. public static function getMasterWorker($params)
  281. {
  282. try {
  283. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  284. $query->visible(['goods_name','goods_image','goods_number','good_unit']);
  285. },'service_work'=>function ($query) {
  286. $query->visible(['real_name','mobile','address','service_status','appointment_time','master_worker_id','work_images','finished_images','finished_time'])->append(['service_status_text','user_service_status','user_service_status_text']);
  287. }])
  288. ->visible(['id','sn','payment_type','order_total','order_amount','pay_status','create_time','title','work_id'])
  289. ->where([
  290. 'order_type' => 0,
  291. 'user_id' => $params['user_id'],
  292. 'sn'=>$params['sn']
  293. ])->findOrEmpty()->toArray();
  294. $data = [];
  295. //获取师傅参数
  296. if(!empty($order_info['service_work']['master_worker_id'])){
  297. $worker = MasterWorker::find($order_info['service_work']['master_worker_id']);
  298. $data['avatar'] = $worker['avatar'];
  299. $data['real_name'] = $worker['real_name'];
  300. $data['worker_number'] = $worker['worker_number'];
  301. $data['mobile'] = $worker['mobile'];
  302. $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:'';
  303. $data['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name');
  304. $data['appointment_time'] = $order_info['service_work']['appointment_time'];
  305. }
  306. return $data;
  307. }
  308. catch (\Exception $e) {
  309. self::setError($e->getMessage());
  310. return false;
  311. }
  312. }
  313. /**
  314. * 获取订单详情
  315. * @param $params
  316. * @return array|false
  317. */
  318. public static function detail($params)
  319. {
  320. try {
  321. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  322. $query->visible(['goods_name','goods_image','goods_number','good_unit']);
  323. },'service_work'=>function ($query) {
  324. $query->visible(['real_name','mobile','address','service_status','appointment_time','master_worker_id','work_images','finished_images','finished_time','spare_total','service_work_spare_id'])->append(['service_status_text','user_service_status','user_service_status_text']);
  325. }])
  326. ->visible(['id','sn','payment_type','order_total','order_amount','paid_amount','pay_status','create_time','title','work_id'])
  327. ->where([
  328. 'order_type' => 0,
  329. 'user_id' => $params['user_id'],
  330. 'sn'=>$params['sn']
  331. ])->findOrEmpty()->toArray();
  332. if(empty($order_info)){
  333. throw new Exception('订单不存在');
  334. }
  335. $order_info['master_worker'] = [
  336. 'avatar' => '',
  337. 'real_name'=>'',
  338. 'worker_number'=>'',
  339. 'mobile'=>'',
  340. 'worker_exp'=>''
  341. ];
  342. //查询总价
  343. $order_info['order_amount'] = \app\common\model\recharge\RechargeOrder::where(['order_type'=>0,'user_id'=>$params['user_id'],'work_id'=>$order_info['work_id']])->sum('order_amount');
  344. $order_info['paid_amount'] = \app\common\model\recharge\RechargeOrder::where(['order_type'=>0,'user_id'=>$params['user_id'],'work_id'=>$order_info['work_id']])->sum('paid_amount');
  345. //获取师傅参数
  346. if(!empty($order_info['service_work']['master_worker_id'])){
  347. $worker = MasterWorker::find($order_info['service_work']['master_worker_id']);
  348. $order_info['master_worker']['avatar'] = $worker['avatar'];
  349. $order_info['master_worker']['real_name'] = $worker['real_name'];
  350. $order_info['master_worker']['worker_number'] = $worker['worker_number'];
  351. $order_info['master_worker']['mobile'] = $worker['mobile'];
  352. $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:'';
  353. $order_info['master_worker']['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name');
  354. }
  355. //搜索当前工单下的所有订单记录
  356. $order_info['pay_orders'] = \app\common\model\recharge\RechargeOrder::where(['work_id'=>$order_info['work_id']])->field('id as order_id, pay_status,payment_type,pay_way,pay_time,order_total,order_amount,coupon_price')->order('id asc')->select()->toArray();
  357. $pay_status_data = DictData::where('type_value','pay_status')->column('name','value');
  358. $payment_type_data = DictData::where('type_value','payment_type')->column('name','value');
  359. $pay_way_data = DictData::where('type_value','pay_way')->column('name','value');
  360. $coupon_price = 0;
  361. foreach ($order_info['pay_orders'] as $k=>&$v){
  362. $v['pay_status_name'] = $pay_status_data[$v['pay_status']];
  363. $v['payment_type_name'] = $payment_type_data[$v['payment_type']];
  364. $v['pay_way_name'] = $pay_way_data[$v['pay_way']];
  365. if($v['payment_type']!=1 and !empty($order_info['service_work']['spare_total'])){
  366. $v['order_total'] = $v['order_total'] - $order_info['service_work']['spare_total'];
  367. $v['order_amount'] = $v['order_total'] - $order_info['service_work']['spare_total'];
  368. }
  369. $coupon_price += $v['coupon_price'];
  370. }
  371. //汇总优惠卷额度
  372. $order_info['coupon_price'] = $coupon_price;
  373. // 所有配件
  374. $order_info['spare_total'] = $order_info['service_work']['spare_total']??0;
  375. $order_info['spare_parts'] = [];
  376. if($order_info['service_work']['service_work_spare_id']){
  377. $work_spare_parts = json_decode(ServiceWorkSpare::where('id',$order_info['service_work']['service_work_spare_id'])->value('spare_parts'),true);
  378. $spare_parts = SparePart::where('id','in',array_column($work_spare_parts,'id'))
  379. ->field(['id', 'goods_category_id', 'spare_name', 'spare_image', 'spare_number', 'spare_unit','spare_status'])
  380. ->select()
  381. ->toArray();
  382. $spare_parts = array_column($spare_parts,null,'id');
  383. foreach (array_column($work_spare_parts,null,'id') as $k=>&$v){
  384. $spare_parts[$k] = array_merge($spare_parts[$k],$v);
  385. }
  386. $order_info['spare_parts'] = array_values($spare_parts)??[];
  387. }
  388. return $order_info;
  389. }
  390. catch (\Exception $e) {
  391. self::setError($e->getMessage());
  392. return false;
  393. }
  394. }
  395. /**
  396. * 获取订单支付详情
  397. * @param $params
  398. * @return array|false
  399. */
  400. public static function orderPayInfo($params)
  401. {
  402. try {
  403. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  404. $query->visible(['goods_payment_type','goods_category_id']);
  405. },'service_work'=>function ($query) {
  406. $query->visible(['service_fee','spare_total','service_work_spare_id']);
  407. }])
  408. ->visible(['id','sn','work_id'])
  409. ->where([
  410. 'order_type' => 0,
  411. 'user_id' => $params['user_id'],
  412. 'sn'=>$params['sn']
  413. ])->findOrEmpty()->toArray();
  414. if(empty($order_info)){
  415. throw new Exception('订单不存在');
  416. }
  417. //查询总价
  418. $order_info['order_amount'] = \app\common\model\recharge\RechargeOrder::where(['order_type'=>0,'user_id'=>$params['user_id'],'work_id'=>$order_info['work_id']])->sum('order_amount');
  419. $order_info['paid_amount'] = \app\common\model\recharge\RechargeOrder::where(['order_type'=>0,'user_id'=>$params['user_id'],'work_id'=>$order_info['work_id']])->sum('paid_amount');
  420. //搜索当前工单下的所有订单记录
  421. $order_info['pay_orders'] = \app\common\model\recharge\RechargeOrder::where(['work_id'=>$order_info['work_id']])->field('id as order_id, pay_status,payment_type,pay_way,pay_time,order_total,order_amount,coupon_price')->order('id asc')->select()->toArray();
  422. $pay_status_data = DictData::where('type_value','pay_status')->column('name','value');
  423. $payment_type_data = DictData::where('type_value','payment_type')->column('name','value');
  424. $pay_way_data = DictData::where('type_value','pay_way')->column('name','value');
  425. $coupon_price = 0;
  426. foreach ($order_info['pay_orders'] as $k=>&$v){
  427. $v['pay_status_name'] = $pay_status_data[$v['pay_status']];
  428. $v['payment_type_name'] = $payment_type_data[$v['payment_type']];
  429. $v['pay_way_name'] = $pay_way_data[$v['pay_way']];
  430. if($v['payment_type']!=1 and !empty($order_info['service_work']['spare_total'])){
  431. $v['order_total'] = $v['order_total'] - $order_info['service_work']['spare_total'];
  432. $v['order_amount'] = $v['order_amount'] - $order_info['service_work']['spare_total'] + $v['coupon_price'];
  433. }
  434. $coupon_price += $v['coupon_price'];
  435. }
  436. //汇总优惠卷额度
  437. $order_info['coupon_price'] = $coupon_price;
  438. // 所有配件
  439. $order_info['spare_total'] = $order_info['service_work']['spare_total']??0;
  440. $order_info['spare_parts'] = [];
  441. if($order_info['service_work']['service_work_spare_id']){
  442. $work_spare_parts = json_decode(ServiceWorkSpare::where('id',$order_info['service_work']['service_work_spare_id'])->value('spare_parts'),true);
  443. $spare_parts = SparePart::where('id','in',array_column($work_spare_parts,'id'))
  444. ->field(['id', 'goods_category_id', 'spare_name', 'spare_image', 'spare_number', 'spare_unit','spare_status'])
  445. ->select()
  446. ->toArray();
  447. $spare_parts = array_column($spare_parts,null,'id');
  448. foreach (array_column($work_spare_parts,null,'id') as $k=>&$v){
  449. $spare_parts[$k] = array_merge($spare_parts[$k],$v);
  450. }
  451. $order_info['spare_parts'] = array_values($spare_parts)??[];
  452. }
  453. return $order_info;
  454. }
  455. catch (\Exception $e) {
  456. self::setError($e->getMessage());
  457. return false;
  458. }
  459. }
  460. /**
  461. * 取消订单
  462. * @param $params
  463. * @return false|void
  464. */
  465. public static function cancelOrder($params)
  466. {
  467. Db::startTrans();
  468. try {
  469. $work_id = \app\common\model\recharge\RechargeOrder::where([
  470. 'order_type' => 0,
  471. 'user_id' => $params['user_id'],
  472. 'sn'=>$params['sn']
  473. ])->value('work_id');
  474. if(empty($work_id)){
  475. throw new Exception('订单不存在');
  476. }
  477. $payed_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id,'pay_status'=>1])->findOrEmpty();
  478. if(!$payed_order->isEmpty()){
  479. throw new Exception('存在已支付订单,不允许取消订单,请联系客服');
  480. }
  481. //软删除订单
  482. $cancel_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id])->findOrEmpty();
  483. $cancel_order->pay_status = 2;
  484. $cancel_order->save();
  485. //更新工单状态为已取消
  486. $service_work = ServiceWork::find($work_id);
  487. $service_work->service_status = 4;
  488. $service_work->save();
  489. //判断如果存在优惠券,返还优惠券
  490. if(!empty($payed_order->coupon_id)){
  491. $user_coupon = UserCoupon::where(['user_id'=>$payed_order->user_id,'id'=>$payed_order->coupon_id])->findOrEmpty();
  492. $user_coupon->voucher_status = 0;
  493. $user_coupon->voucher_count = $user_coupon->voucher_count+1;
  494. $user_coupon->save();
  495. }
  496. Db::commit();
  497. }
  498. catch (\Exception $e) {
  499. self::setError($e->getMessage());
  500. return false;
  501. }
  502. }
  503. /**
  504. * 用户确认尾款报价单
  505. * @param $params
  506. * @return false|void
  507. */
  508. public static function confirmOrder($params)
  509. {
  510. Db::startTrans();
  511. try {
  512. $work_id = \app\common\model\recharge\RechargeOrder::where([
  513. 'order_type' => 0,
  514. 'user_id' => $params['user_id'],
  515. 'sn'=>$params['sn']
  516. ])->value('work_id');
  517. if(empty($work_id)){
  518. throw new Exception('订单不存在');
  519. }
  520. //更新工单状态为已取消
  521. $service_work = ServiceWork::find($work_id);
  522. if($service_work->user_confirm_status==2){
  523. throw new Exception('请勿重复操作');
  524. }
  525. $service_work->work_status = 5;
  526. $service_work->user_confirm_status = 2;
  527. $service_work->save();
  528. $work_log = [
  529. 'work_id'=>$work_id,
  530. 'master_worker_id'=>$service_work->master_worker_id,
  531. 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认了报价单',
  532. ];
  533. ServiceWorkLogLogic::add($work_log);
  534. Db::commit();
  535. }
  536. catch (\Exception $e) {
  537. self::setError($e->getMessage());
  538. return false;
  539. }
  540. }
  541. /**
  542. * 用户确认服务完成
  543. * @param $params
  544. * @return false|void
  545. */
  546. public static function confirmServiceFinish($params)
  547. {
  548. Db::startTrans();
  549. try {
  550. $work_id = \app\common\model\recharge\RechargeOrder::where([
  551. 'order_type' => 0,
  552. 'user_id' => $params['user_id'],
  553. 'sn'=>$params['sn']
  554. ])->value('work_id');
  555. if(empty($work_id)){
  556. throw new Exception('订单不存在');
  557. }
  558. $service_work = ServiceWork::find($work_id);
  559. if($service_work->user_confirm_status!=3){
  560. throw new Exception('请勿重复操作');
  561. }
  562. $orders = RechargeOrder::where(['work_id'=>$work_id,'user_id'=>$params['user_id']])->select()->toArray();
  563. //确认所有订单总金额和结算金额
  564. //若订单是全款已支付订单
  565. if(count($orders)==1 and $orders[0]['payment_type']==0 and $orders[0]['pay_status']==1){
  566. $service_work->work_status = 7;
  567. $service_work->user_confirm_status = 5;
  568. $service_work->service_status = 3;
  569. $service_work->work_pay_status = 1;
  570. }else{
  571. $service_work->work_status = 6;
  572. $service_work->user_confirm_status = 4;
  573. }
  574. $service_work->finished_time = time();
  575. $service_work->save();
  576. //更新师傅的进行工单数量
  577. MasterWorker::setWorktotal('dec',$service_work->master_worker_id);
  578. $work_log = [
  579. 'work_id'=>$work_id,
  580. 'master_worker_id'=>$service_work->master_worker_id,
  581. 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认服务完成',
  582. ];
  583. ServiceWorkLogLogic::add($work_log);
  584. Db::commit();
  585. }
  586. catch (\Exception $e) {
  587. self::setError($e->getMessage());
  588. return false;
  589. }
  590. }
  591. public static function firmOrderSave($params)
  592. {
  593. Db::startTrans();
  594. try {
  595. $goodIds = array_column($params['order_goods'],'id');
  596. $goodInfo = Goods::whereIn('id',$goodIds)->select();
  597. $ids = $goodInfo->column('id');
  598. if(!empty(array_diff($goodIds,$ids))){
  599. throw new Exception('产品不存在!');
  600. }
  601. if(empty($params['user_info']['mobile'])){
  602. throw new Exception('请先补充您的联系方式后在提交订单');
  603. }
  604. $order_amount = 0;
  605. $order_total = 0;
  606. $orderGoodsData = [];
  607. $goodsPaymentTypeArr = [];
  608. //计算订单总金额和结算金额
  609. foreach($params['order_goods'] as $val){
  610. $goods = $goodInfo->where('id',$val['id'])->toArray()[0];
  611. //根据服务工单计算当前订单应支付金额
  612. $order_total = $goods['service_total'];
  613. if($goods['goods_payment_type'] == GoodsEnum::ISGOODS_PAYMENT_TYPE){
  614. //一口价订单
  615. $order_amount = $goods['service_fee']*$val['goods_number'];
  616. }else{
  617. $order_total = $goods['base_service_fee']*$val['goods_number'];
  618. $order_amount = $goods['service_fee']*$val['goods_number'];
  619. }
  620. $goodsPaymentTypeArr[] = $goods['goods_payment_type'];
  621. $orderGoodsData[] = [
  622. 'goods_id' => $goods['id'],
  623. 'category_type' => $goods['category_type'],
  624. 'goods_category_ids' => $goods['goods_category_ids'],
  625. 'goods_category_id' => $goods['goods_category_id'],
  626. 'goods_name' => $goods['goods_name'],
  627. 'goods_image' => $goods['goods_image'],
  628. 'goods_video' => $goods['goods_video'],
  629. 'goods_number' => $val['goods_number'],
  630. 'good_unit' => $goods['good_unit'],
  631. 'goods_size' => $goods['goods_size'],
  632. 'goods_type' => $goods['goods_type'],
  633. 'goods_brand' => $goods['goods_brand'],
  634. 'install_guide' => $goods['install_guide'],
  635. 'goods_payment_type'=>$goods['goods_payment_type'],
  636. 'base_service_fee' => $goods['base_service_fee'],
  637. 'service_total' => $goods['service_total'],
  638. 'service_fee' => $goods['service_fee'],
  639. 'service_image' => $goods['service_image'],
  640. 'warranty_period'=>$goods['warranty_period'],
  641. 'fee_schedule' => $goods['fee_schedule'],
  642. 'goods_status' => $goods['goods_status'],
  643. ];
  644. }
  645. if(count(array_unique($goodsPaymentTypeArr))>1){
  646. throw new Exception('订单中存在多种支付方式');
  647. }
  648. //生成服务工单
  649. $work_data = [
  650. 'work_sn' => generate_sn(ServiceWork::class, 'work_sn'),
  651. 'real_name' => $params['contact_people'],
  652. 'mobile' => $params['contact_number'],
  653. 'address' => $params['address'],
  654. 'title' => $goods['goods_name'] . '*' .$val['goods_number'].$goods['good_unit'],
  655. 'category_type' => $goods['category_type'],
  656. 'goods_category_ids' => $goods['goods_category_ids'],
  657. 'goods_category_id' => $goods['goods_category_id'],
  658. 'base_service_fee' => $goods['base_service_fee'],
  659. 'service_fee' => $goods['service_fee'],
  660. 'work_pay_status'=>WorkEnum::UN_PAY_STATUS,
  661. 'appointment_time' => strtotime($params['appointment_time']),
  662. 'user_id' => $params['user_id'],
  663. 'work_type' => 1,
  664. ];
  665. $service_work = ServiceWork::create($work_data);
  666. //生成服务订单
  667. $data = [
  668. 'work_id'=> $service_work['id'],
  669. 'sn' => generate_sn(RechargeOrder::class, 'sn'),
  670. 'order_type'=>0,//服务订单
  671. 'order_terminal' => $params['terminal'],
  672. 'payment_type'=>$goods['goods_payment_type']==1?1:0,
  673. 'user_id' => $params['user_id'],
  674. 'pay_status' => PayEnum::UNPAID,
  675. 'coupon_id'=>!empty($params['coupon_id'])?$params['coupon_id']:0,
  676. 'coupon_price'=>!empty($order_coupon_amount)?$order_coupon_amount:0,
  677. 'pay_way' => $params['pay_way'],
  678. 'order_total' => $order_total,
  679. 'order_amount' => $order_amount,
  680. ];
  681. $order = RechargeOrder::create($data);
  682. array_walk($orderGoodsData, function (&$value, $key, $data) {
  683. $value = array_merge($value, ['sn' => $data['sn']]);
  684. },$data);
  685. $orderGoodsModel = new OrderGoods();
  686. $orderGoodsModel->saveAll($orderGoodsData);
  687. Db::commit();
  688. return [
  689. 'order_id' => (int)$order['id'],
  690. ];
  691. } catch (\Exception $e) {
  692. Db::rollback();
  693. self::setError($e->getMessage());
  694. return false;
  695. }
  696. }
  697. }