ServiceOrderLogic.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741
  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. * @return void
  252. */
  253. // public function canleOrderCoupon()
  254. // {
  255. //
  256. // }
  257. /**
  258. * 获取订单工程师信息
  259. * * @param $params
  260. * * @return array|false
  261. */
  262. public static function getMasterWorker($params)
  263. {
  264. try {
  265. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  266. $query->visible(['goods_name','goods_image','goods_number','good_unit']);
  267. },'service_work'=>function ($query) {
  268. $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']);
  269. }])
  270. ->visible(['id','sn','payment_type','order_total','order_amount','pay_status','create_time','title','work_id'])
  271. ->where([
  272. 'order_type' => 0,
  273. 'user_id' => $params['user_id'],
  274. 'sn'=>$params['sn']
  275. ])->findOrEmpty()->toArray();
  276. $data = [];
  277. //获取师傅参数
  278. if(!empty($order_info['service_work']['master_worker_id'])){
  279. $worker = MasterWorker::find($order_info['service_work']['master_worker_id']);
  280. $data['avatar'] = $worker['avatar'];
  281. $data['real_name'] = $worker['real_name'];
  282. $data['worker_number'] = $worker['worker_number'];
  283. $data['mobile'] = $worker['mobile'];
  284. $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:'';
  285. $data['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name');
  286. $data['appointment_time'] = $order_info['service_work']['appointment_time'];
  287. }
  288. return $data;
  289. }
  290. catch (\Exception $e) {
  291. self::setError($e->getMessage());
  292. return false;
  293. }
  294. }
  295. /**
  296. * 获取订单详情
  297. * @param $params
  298. * @return array|false
  299. */
  300. public static function detail($params)
  301. {
  302. try {
  303. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  304. $query->visible(['goods_name','goods_image','goods_number','good_unit']);
  305. },'service_work'=>function ($query) {
  306. $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']);
  307. }])
  308. ->visible(['id','sn','payment_type','order_total','order_amount','paid_amount','pay_status','create_time','title','work_id'])
  309. ->where([
  310. 'order_type' => 0,
  311. 'user_id' => $params['user_id'],
  312. 'sn'=>$params['sn']
  313. ])->findOrEmpty()->toArray();
  314. if(empty($order_info)){
  315. throw new Exception('订单不存在');
  316. }
  317. $order_info['master_worker'] = [
  318. 'avatar' => '',
  319. 'real_name'=>'',
  320. 'worker_number'=>'',
  321. 'mobile'=>'',
  322. 'worker_exp'=>''
  323. ];
  324. //查询总价
  325. $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');
  326. $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');
  327. //获取师傅参数
  328. if(!empty($order_info['service_work']['master_worker_id'])){
  329. $worker = MasterWorker::find($order_info['service_work']['master_worker_id']);
  330. $order_info['master_worker']['avatar'] = $worker['avatar'];
  331. $order_info['master_worker']['real_name'] = $worker['real_name'];
  332. $order_info['master_worker']['worker_number'] = $worker['worker_number'];
  333. $order_info['master_worker']['mobile'] = $worker['mobile'];
  334. $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:'';
  335. $order_info['master_worker']['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name');
  336. }
  337. //搜索当前工单下的所有订单记录
  338. $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();
  339. $pay_status_data = DictData::where('type_value','pay_status')->column('name','value');
  340. $payment_type_data = DictData::where('type_value','payment_type')->column('name','value');
  341. $pay_way_data = DictData::where('type_value','pay_way')->column('name','value');
  342. $coupon_price = 0;
  343. foreach ($order_info['pay_orders'] as $k=>&$v){
  344. $v['pay_status_name'] = $pay_status_data[$v['pay_status']];
  345. $v['payment_type_name'] = $payment_type_data[$v['payment_type']];
  346. $v['pay_way_name'] = $pay_way_data[$v['pay_way']];
  347. if($v['payment_type']!=1 and !empty($order_info['service_work']['spare_total'])){
  348. $v['order_total'] = $v['order_total'] - $order_info['service_work']['spare_total'];
  349. $v['order_amount'] = $v['order_total'] - $order_info['service_work']['spare_total'];
  350. }
  351. $coupon_price += $v['coupon_price'];
  352. }
  353. //汇总优惠卷额度
  354. $order_info['coupon_price'] = $coupon_price;
  355. // 所有配件
  356. $order_info['spare_total'] = $order_info['service_work']['spare_total']??0;
  357. $order_info['spare_parts'] = [];
  358. if($order_info['service_work']['service_work_spare_id']){
  359. $work_spare_parts = json_decode(ServiceWorkSpare::where('id',$order_info['service_work']['service_work_spare_id'])->value('spare_parts'),true);
  360. $spare_parts = SparePart::where('id','in',array_column($work_spare_parts,'id'))
  361. ->field(['id', 'goods_category_id', 'spare_name', 'spare_image', 'spare_number', 'spare_unit','spare_status'])
  362. ->select()
  363. ->toArray();
  364. $spare_parts = array_column($spare_parts,null,'id');
  365. foreach (array_column($work_spare_parts,null,'id') as $k=>&$v){
  366. $spare_parts[$k] = array_merge($spare_parts[$k],$v);
  367. }
  368. $order_info['spare_parts'] = array_values($spare_parts)??[];
  369. }
  370. return $order_info;
  371. }
  372. catch (\Exception $e) {
  373. self::setError($e->getMessage());
  374. return false;
  375. }
  376. }
  377. /**
  378. * 获取订单支付详情
  379. * @param $params
  380. * @return array|false
  381. */
  382. public static function orderPayInfo($params)
  383. {
  384. try {
  385. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  386. $query->visible(['goods_payment_type','goods_category_id']);
  387. },'service_work'=>function ($query) {
  388. $query->visible(['service_fee','spare_total','service_work_spare_id']);
  389. }])
  390. ->visible(['id','sn','work_id'])
  391. ->where([
  392. 'order_type' => 0,
  393. 'user_id' => $params['user_id'],
  394. 'sn'=>$params['sn']
  395. ])->findOrEmpty()->toArray();
  396. if(empty($order_info)){
  397. throw new Exception('订单不存在');
  398. }
  399. //查询总价
  400. $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');
  401. $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');
  402. //搜索当前工单下的所有订单记录
  403. $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();
  404. $pay_status_data = DictData::where('type_value','pay_status')->column('name','value');
  405. $payment_type_data = DictData::where('type_value','payment_type')->column('name','value');
  406. $pay_way_data = DictData::where('type_value','pay_way')->column('name','value');
  407. $coupon_price = 0;
  408. foreach ($order_info['pay_orders'] as $k=>&$v){
  409. $v['pay_status_name'] = $pay_status_data[$v['pay_status']];
  410. $v['payment_type_name'] = $payment_type_data[$v['payment_type']];
  411. $v['pay_way_name'] = $pay_way_data[$v['pay_way']];
  412. if($v['payment_type']!=1 and !empty($order_info['service_work']['spare_total'])){
  413. $v['order_total'] = $v['order_total'] - $order_info['service_work']['spare_total'] + $v['coupon_price'];
  414. $v['order_amount'] = $v['order_amount'] - $order_info['service_work']['spare_total'] + $v['coupon_price'];
  415. }
  416. $coupon_price += $v['coupon_price'];
  417. }
  418. //汇总优惠卷额度
  419. $order_info['coupon_price'] = $coupon_price;
  420. // 所有配件
  421. $order_info['spare_total'] = $order_info['service_work']['spare_total']??0;
  422. $order_info['spare_parts'] = [];
  423. if($order_info['service_work']['service_work_spare_id']){
  424. $work_spare_parts = json_decode(ServiceWorkSpare::where('id',$order_info['service_work']['service_work_spare_id'])->value('spare_parts'),true);
  425. $spare_parts = SparePart::where('id','in',array_column($work_spare_parts,'id'))
  426. ->field(['id', 'goods_category_id', 'spare_name', 'spare_image', 'spare_number', 'spare_unit','spare_status'])
  427. ->select()
  428. ->toArray();
  429. $spare_parts = array_column($spare_parts,null,'id');
  430. foreach (array_column($work_spare_parts,null,'id') as $k=>&$v){
  431. $spare_parts[$k] = array_merge($spare_parts[$k],$v);
  432. }
  433. $order_info['spare_parts'] = array_values($spare_parts)??[];
  434. }
  435. return $order_info;
  436. }
  437. catch (\Exception $e) {
  438. self::setError($e->getMessage());
  439. return false;
  440. }
  441. }
  442. /**
  443. * 取消订单
  444. * @param $params
  445. * @return false|void
  446. */
  447. public static function cancelOrder($params)
  448. {
  449. Db::startTrans();
  450. try {
  451. $work_id = \app\common\model\recharge\RechargeOrder::where([
  452. 'order_type' => 0,
  453. 'user_id' => $params['user_id'],
  454. 'sn'=>$params['sn']
  455. ])->value('work_id');
  456. if(empty($work_id)){
  457. throw new Exception('订单不存在');
  458. }
  459. $payed_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id,'pay_status'=>1])->findOrEmpty();
  460. if(!$payed_order->isEmpty()){
  461. throw new Exception('存在已支付订单,不允许取消订单,请联系客服');
  462. }
  463. //软删除订单
  464. $cancel_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id])->findOrEmpty();
  465. $cancel_order->pay_status = 2;
  466. $cancel_order->save();
  467. //更新工单状态为已取消
  468. $service_work = ServiceWork::find($work_id);
  469. $service_work->service_status = 4;
  470. $service_work->save();
  471. //判断如果存在优惠券,返还优惠券
  472. if(!empty($payed_order->coupon_id)){
  473. $user_coupon = UserCoupon::where(['user_id'=>$payed_order->user_id,'id'=>$payed_order->coupon_id])->findOrEmpty();
  474. $user_coupon->voucher_status = 0;
  475. $user_coupon->voucher_count = $user_coupon->voucher_count+1;
  476. $user_coupon->save();
  477. }
  478. Db::commit();
  479. }
  480. catch (\Exception $e) {
  481. self::setError($e->getMessage());
  482. return false;
  483. }
  484. }
  485. /**
  486. * 用户确认尾款报价单
  487. * @param $params
  488. * @return false|void
  489. */
  490. public static function confirmOrder($params)
  491. {
  492. Db::startTrans();
  493. try {
  494. $work_id = \app\common\model\recharge\RechargeOrder::where([
  495. 'order_type' => 0,
  496. 'user_id' => $params['user_id'],
  497. 'sn'=>$params['sn']
  498. ])->value('work_id');
  499. if(empty($work_id)){
  500. throw new Exception('订单不存在');
  501. }
  502. //更新工单状态为已取消
  503. $service_work = ServiceWork::find($work_id);
  504. if($service_work->user_confirm_status==2){
  505. throw new Exception('请勿重复操作');
  506. }
  507. $service_work->work_status = 5;
  508. $service_work->user_confirm_status = 2;
  509. $service_work->save();
  510. $work_log = [
  511. 'work_id'=>$work_id,
  512. 'master_worker_id'=>$service_work->master_worker_id,
  513. 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认了报价单',
  514. ];
  515. ServiceWorkLogLogic::add($work_log);
  516. Db::commit();
  517. }
  518. catch (\Exception $e) {
  519. self::setError($e->getMessage());
  520. return false;
  521. }
  522. }
  523. /**
  524. * 用户确认服务完成
  525. * @param $params
  526. * @return false|void
  527. */
  528. public static function confirmServiceFinish($params)
  529. {
  530. Db::startTrans();
  531. try {
  532. $work_id = \app\common\model\recharge\RechargeOrder::where([
  533. 'order_type' => 0,
  534. 'user_id' => $params['user_id'],
  535. 'sn'=>$params['sn']
  536. ])->value('work_id');
  537. if(empty($work_id)){
  538. throw new Exception('订单不存在');
  539. }
  540. $service_work = ServiceWork::find($work_id);
  541. if($service_work->user_confirm_status!=3){
  542. throw new Exception('请勿重复操作');
  543. }
  544. $orders = RechargeOrder::where(['work_id'=>$work_id,'user_id'=>$params['user_id']])->select()->toArray();
  545. //确认所有订单总金额和结算金额
  546. //若订单是全款已支付订单
  547. if(count($orders)==1 and $orders[0]['payment_type']==0 and $orders[0]['pay_status']==1){
  548. $service_work->work_status = 7;
  549. $service_work->user_confirm_status = 5;
  550. $service_work->service_status = 3;
  551. $service_work->work_pay_status = 1;
  552. }else{
  553. $service_work->work_status = 6;
  554. $service_work->user_confirm_status = 4;
  555. }
  556. $service_work->finished_time = time();
  557. $service_work->save();
  558. //更新师傅的进行工单数量
  559. MasterWorker::setWorktotal('dec',$service_work->master_worker_id);
  560. $work_log = [
  561. 'work_id'=>$work_id,
  562. 'master_worker_id'=>$service_work->master_worker_id,
  563. 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认服务完成',
  564. ];
  565. ServiceWorkLogLogic::add($work_log);
  566. Db::commit();
  567. }
  568. catch (\Exception $e) {
  569. self::setError($e->getMessage());
  570. return false;
  571. }
  572. }
  573. public static function firmOrderSave($params)
  574. {
  575. Db::startTrans();
  576. try {
  577. $goodIds = array_column($params['order_goods'],'id');
  578. $goodInfo = Goods::whereIn('id',$goodIds)->select();
  579. $ids = $goodInfo->column('id');
  580. if(!empty(array_diff($goodIds,$ids))){
  581. throw new Exception('产品不存在!');
  582. }
  583. if(empty($params['user_info']['mobile'])){
  584. throw new Exception('请先补充您的联系方式后在提交订单');
  585. }
  586. $order_amount = 0;
  587. $order_total = 0;
  588. $orderGoodsData = [];
  589. $goodsPaymentTypeArr = [];
  590. //计算订单总金额和结算金额
  591. foreach($params['order_goods'] as $val){
  592. $goods = $goodInfo->where('id',$val['id'])->toArray()[0];
  593. //根据服务工单计算当前订单应支付金额
  594. $order_total = $goods['service_total'];
  595. if($goods['goods_payment_type'] == GoodsEnum::ISGOODS_PAYMENT_TYPE){
  596. //一口价订单
  597. $order_amount = $goods['service_fee']*$val['goods_number'];
  598. }else{
  599. $order_total = $goods['base_service_fee']*$val['goods_number'];
  600. $order_amount = $goods['service_fee']*$val['goods_number'];
  601. }
  602. $goodsPaymentTypeArr[] = $goods['goods_payment_type'];
  603. $orderGoodsData[] = [
  604. 'goods_id' => $goods['id'],
  605. 'category_type' => $goods['category_type'],
  606. 'goods_category_ids' => $goods['goods_category_ids'],
  607. 'goods_category_id' => $goods['goods_category_id'],
  608. 'goods_name' => $goods['goods_name'],
  609. 'goods_image' => $goods['goods_image'],
  610. 'goods_video' => $goods['goods_video'],
  611. 'goods_number' => $val['goods_number'],
  612. 'good_unit' => $goods['good_unit'],
  613. 'goods_size' => $goods['goods_size'],
  614. 'goods_type' => $goods['goods_type'],
  615. 'goods_brand' => $goods['goods_brand'],
  616. 'install_guide' => $goods['install_guide'],
  617. 'goods_payment_type'=>$goods['goods_payment_type'],
  618. 'base_service_fee' => $goods['base_service_fee'],
  619. 'service_total' => $goods['service_total'],
  620. 'service_fee' => $goods['service_fee'],
  621. 'service_image' => $goods['service_image'],
  622. 'warranty_period'=>$goods['warranty_period'],
  623. 'fee_schedule' => $goods['fee_schedule'],
  624. 'goods_status' => $goods['goods_status'],
  625. ];
  626. }
  627. if(count(array_unique($goodsPaymentTypeArr))>1){
  628. throw new Exception('订单中存在多种支付方式');
  629. }
  630. //生成服务工单
  631. $work_data = [
  632. 'work_sn' => generate_sn(ServiceWork::class, 'work_sn'),
  633. 'real_name' => $params['contact_people'],
  634. 'mobile' => $params['contact_number'],
  635. 'address' => $params['address'],
  636. 'title' => $goods['goods_name'] . '*' .$val['goods_number'].$goods['good_unit'],
  637. 'category_type' => $goods['category_type'],
  638. 'goods_category_ids' => $goods['goods_category_ids'],
  639. 'goods_category_id' => $goods['goods_category_id'],
  640. 'base_service_fee' => $goods['base_service_fee'],
  641. 'service_fee' => $goods['service_fee'],
  642. 'work_pay_status'=>WorkEnum::UN_PAY_STATUS,
  643. 'appointment_time' => strtotime($params['appointment_time']),
  644. 'user_id' => $params['user_id'],
  645. 'work_type' => 1,
  646. ];
  647. $service_work = ServiceWork::create($work_data);
  648. //生成服务订单
  649. $data = [
  650. 'work_id'=> $service_work['id'],
  651. 'sn' => generate_sn(RechargeOrder::class, 'sn'),
  652. 'order_type'=>0,//服务订单
  653. 'order_terminal' => $params['terminal'],
  654. 'payment_type'=>$goods['goods_payment_type']==1?1:0,
  655. 'user_id' => $params['user_id'],
  656. 'pay_status' => PayEnum::UNPAID,
  657. 'coupon_id'=>!empty($params['coupon_id'])?$params['coupon_id']:0,
  658. 'coupon_price'=>!empty($order_coupon_amount)?$order_coupon_amount:0,
  659. 'pay_way' => $params['pay_way'],
  660. 'order_total' => $order_total,
  661. 'order_amount' => $order_amount,
  662. ];
  663. $order = RechargeOrder::create($data);
  664. array_walk($orderGoodsData, function (&$value, $key, $data) {
  665. $value = array_merge($value, ['sn' => $data['sn']]);
  666. },$data);
  667. $orderGoodsModel = new OrderGoods();
  668. $orderGoodsModel->saveAll($orderGoodsData);
  669. Db::commit();
  670. return [
  671. 'order_id' => (int)$order['id'],
  672. ];
  673. } catch (\Exception $e) {
  674. Db::rollback();
  675. self::setError($e->getMessage());
  676. return false;
  677. }
  678. }
  679. }