ServiceOrderLogic.php 33 KB

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