ServiceOrderLogic.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392
  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\model\dict\DictData;
  8. use app\common\model\goods\Goods;
  9. use app\common\model\master_worker\MasterWorker;
  10. use app\common\model\orders\RechargeOrder;
  11. use app\common\model\performance\PerformanceRules;
  12. use app\common\model\recharge\OrderGoods;
  13. use app\common\model\works\ServiceWork;
  14. use app\workerapi\logic\ServiceWorkLogLogic;
  15. use think\Exception;
  16. use think\facade\Db;
  17. /**
  18. * 订单逻辑层
  19. * Class ServiceOrderLogic
  20. * @package app\api\logic
  21. */
  22. class ServiceOrderLogic extends BaseLogic
  23. {
  24. /**
  25. * 提交订单
  26. * @param array $params
  27. * @return array|false
  28. */
  29. public static function submitOrder($params)
  30. {
  31. Db::startTrans();
  32. try {
  33. $goods = Goods::findOrEmpty($params['goods_id']);
  34. if($goods->isEmpty()){
  35. throw new Exception('产品不存在!');
  36. }
  37. if(empty($params['user_info']['mobile'])){
  38. throw new Exception('请先补充您的联系方式后在提交订单');
  39. }
  40. //根据服务工单计算当前订单应支付金额
  41. $order_total = $goods['service_total'];
  42. if($goods['goods_payment_type'] == GoodsEnum::ISGOODS_PAYMENT_TYPE){
  43. //一口价订单
  44. $order_amount = $goods['service_fee'];
  45. $pay_status = PayEnum::UNPAID;
  46. $work_pay_status = WorkEnum::UN_PAY_STATUS;
  47. }else{
  48. $order_total = $goods['base_service_fee'];
  49. $order_amount = $goods['base_service_fee'];
  50. $pay_status = !empty($order_amount)?PayEnum::UNPAID:PayEnum::ISPAID;
  51. $work_pay_status = !empty($order_amount)?WorkEnum::UN_PAY_STATUS:WorkEnum::IS_PAY_STATUS;
  52. }
  53. //生成服务工单
  54. $work_data = [
  55. 'work_sn' => generate_sn(ServiceWork::class, 'work_sn'),
  56. 'real_name' => $params['contact_people'],
  57. 'mobile' => $params['contact_number'],
  58. 'address' => $params['address'],
  59. 'title' => $goods->goods_name . '*' . $goods->goods_number.$goods->good_unit,
  60. 'category_type' => $goods['category_type'],
  61. 'goods_category_ids' => $goods['goods_category_ids'],
  62. 'goods_category_id' => $goods['goods_category_id'],
  63. 'base_service_fee' => $goods['base_service_fee'],
  64. 'service_fee' => $goods['service_fee'],
  65. 'work_pay_status'=>$work_pay_status,
  66. 'appointment_time' => strtotime($params['appointment_time']),
  67. 'user_id'=>$params['user_id']
  68. ];
  69. $service_work = ServiceWork::create($work_data);
  70. //生成服务订单
  71. $data = [
  72. 'work_id'=> $service_work['id'],
  73. 'sn' => generate_sn(RechargeOrder::class, 'sn'),
  74. 'order_type'=>0,//服务订单
  75. 'order_terminal' => $params['terminal'],
  76. 'payment_type'=>$goods['goods_payment_type']==1?1:0,
  77. 'user_id' => $params['user_id'],
  78. 'pay_status' => $pay_status,
  79. 'pay_way' => $params['pay_way'],
  80. 'order_total' => $order_total,
  81. 'order_amount' => $order_amount,
  82. ];
  83. $order = RechargeOrder::create($data);
  84. //生成订单服务详情
  85. OrderGoods::create([
  86. 'sn' => $order['sn'],
  87. 'goods_id' => $params['goods_id'],
  88. 'category_type' => $goods['category_type'],
  89. 'goods_category_ids' => $goods['goods_category_ids'],
  90. 'goods_category_id' => $goods['goods_category_id'],
  91. 'goods_name' => $goods['goods_name'],
  92. 'goods_image' => $goods['goods_image'],
  93. 'goods_video' => $goods['goods_video'],
  94. 'goods_number' => $goods['goods_number'],
  95. 'good_unit' => $goods['good_unit'],
  96. 'goods_size' => $goods['goods_size'],
  97. 'goods_type' => $goods['goods_type'],
  98. 'goods_brand' => $goods['goods_brand'],
  99. 'install_guide' => $goods['install_guide'],
  100. 'goods_payment_type'=>$goods['goods_payment_type'],
  101. 'base_service_fee' => $goods['base_service_fee'],
  102. 'service_total' => $goods['service_total'],
  103. 'service_fee' => $goods['service_fee'],
  104. 'service_image' => $goods['service_image'],
  105. 'warranty_period'=>$goods['warranty_period'],
  106. 'fee_schedule' => $goods['fee_schedule'],
  107. 'goods_status' => $goods['goods_status'],
  108. ]);
  109. Db::commit();
  110. } catch (\Exception $e) {
  111. self::setError($e->getMessage());
  112. return false;
  113. }
  114. return [
  115. 'order_id' => (int)$order['id'],
  116. ];
  117. }
  118. /**
  119. * 获取订单工程师信息
  120. * * @param $params
  121. * * @return array|false
  122. */
  123. public static function getMasterWorker($params)
  124. {
  125. try {
  126. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  127. $query->visible(['goods_name','goods_image','goods_number','good_unit']);
  128. },'service_work'=>function ($query) {
  129. $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']);
  130. }])
  131. ->visible(['id','sn','payment_type','order_total','order_amount','pay_status','create_time','title','work_id'])
  132. ->where([
  133. 'order_type' => 0,
  134. 'user_id' => $params['user_id'],
  135. 'sn'=>$params['sn']
  136. ])->findOrEmpty()->toArray();
  137. $data = [];
  138. //获取师傅参数
  139. if(!empty($order_info['service_work']['master_worker_id'])){
  140. $worker = MasterWorker::find($order_info['service_work']['master_worker_id']);
  141. $data['avatar'] = $worker['avatar'];
  142. $data['real_name'] = $worker['real_name'];
  143. $data['worker_number'] = $worker['worker_number'];
  144. $data['mobile'] = $worker['mobile'];
  145. $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:'';
  146. $data['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name');
  147. $data['appointment_time'] = $order_info['service_work']['appointment_time'];
  148. }
  149. return $data;
  150. }
  151. catch (\Exception $e) {
  152. self::setError($e->getMessage());
  153. return false;
  154. }
  155. }
  156. /**
  157. * 获取订单详情
  158. * @param $params
  159. * @return array|false
  160. */
  161. public static function detail($params)
  162. {
  163. try {
  164. $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) {
  165. $query->visible(['goods_name','goods_image','goods_number','good_unit']);
  166. },'service_work'=>function ($query) {
  167. $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']);
  168. }])
  169. ->visible(['id','sn','payment_type','order_total','order_amount','pay_status','create_time','title','work_id'])
  170. ->where([
  171. 'order_type' => 0,
  172. 'user_id' => $params['user_id'],
  173. 'sn'=>$params['sn']
  174. ])->findOrEmpty()->toArray();
  175. $order_info['master_worker'] = [
  176. 'avatar' => '',
  177. 'real_name'=>'',
  178. 'worker_number'=>'',
  179. 'mobile'=>'',
  180. 'worker_exp'=>''
  181. ];
  182. if(empty($order_info)){
  183. throw new Exception('订单不存在');
  184. }
  185. //获取师傅参数
  186. if(!empty($order_info['service_work']['master_worker_id'])){
  187. $worker = MasterWorker::find($order_info['service_work']['master_worker_id']);
  188. $order_info['master_worker']['avatar'] = $worker['avatar'];
  189. $order_info['master_worker']['real_name'] = $worker['real_name'];
  190. $order_info['master_worker']['worker_number'] = $worker['worker_number'];
  191. $order_info['master_worker']['mobile'] = $worker['mobile'];
  192. $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:'';
  193. $order_info['master_worker']['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name');
  194. }
  195. //搜索当前工单下的所有订单记录
  196. $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_amount')->order('id asc')->select()->toArray();
  197. $pay_status_data = DictData::where('type_value','pay_status')->column('name','value');
  198. $payment_type_data = DictData::where('type_value','payment_type')->column('name','value');
  199. $pay_way_data = DictData::where('type_value','pay_way')->column('name','value');
  200. foreach ($order_info['pay_orders'] as $k=>&$v){
  201. $v['pay_status_name'] = $pay_status_data[$v['pay_status']];
  202. $v['payment_type_name'] = $payment_type_data[$v['payment_type']];
  203. $v['pay_way_name'] = $pay_way_data[$v['pay_way']];
  204. }
  205. return $order_info;
  206. }
  207. catch (\Exception $e) {
  208. self::setError($e->getMessage());
  209. return false;
  210. }
  211. }
  212. /**
  213. * 取消订单
  214. * @param $params
  215. * @return false|void
  216. */
  217. public static function cancelOrder($params)
  218. {
  219. Db::startTrans();
  220. try {
  221. $work_id = \app\common\model\recharge\RechargeOrder::where([
  222. 'order_type' => 0,
  223. 'user_id' => $params['user_id'],
  224. 'sn'=>$params['sn']
  225. ])->value('work_id');
  226. if(empty($work_id)){
  227. throw new Exception('订单不存在');
  228. }
  229. $payed_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id,'pay_status'=>1])->findOrEmpty();
  230. if(!$payed_order->isEmpty()){
  231. throw new Exception('存在已支付订单,不允许取消订单,请联系客服');
  232. }
  233. //软删除订单
  234. $cancel_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id])->findOrEmpty();
  235. $cancel_order->delete();
  236. //更新工单状态为已取消
  237. $service_work = ServiceWork::find($work_id);
  238. $service_work->service_status = 4;
  239. $service_work->save();
  240. Db::commit();
  241. }
  242. catch (\Exception $e) {
  243. self::setError($e->getMessage());
  244. return false;
  245. }
  246. }
  247. /**
  248. * 用户确认尾款报价单
  249. * @param $params
  250. * @return false|void
  251. */
  252. public static function confirmOrder($params)
  253. {
  254. Db::startTrans();
  255. try {
  256. $work_id = \app\common\model\recharge\RechargeOrder::where([
  257. 'order_type' => 0,
  258. 'user_id' => $params['user_id'],
  259. 'sn'=>$params['sn']
  260. ])->value('work_id');
  261. if(empty($work_id)){
  262. throw new Exception('订单不存在');
  263. }
  264. //更新工单状态为已取消
  265. $service_work = ServiceWork::find($work_id);
  266. if($service_work->user_confirm_status==2){
  267. throw new Exception('请勿重复操作');
  268. }
  269. $service_work->work_status = 5;
  270. $service_work->user_confirm_status = 2;
  271. $service_work->save();
  272. $work_log = [
  273. 'work_id'=>$work_id,
  274. 'master_worker_id'=>$service_work->master_worker_id,
  275. 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认了报价单',
  276. ];
  277. ServiceWorkLogLogic::add($work_log);
  278. Db::commit();
  279. }
  280. catch (\Exception $e) {
  281. self::setError($e->getMessage());
  282. return false;
  283. }
  284. }
  285. /**
  286. * 用户确认服务完成
  287. * @param $params
  288. * @return false|void
  289. */
  290. public static function confirmServiceFinish($params)
  291. {
  292. Db::startTrans();
  293. try {
  294. $work_id = \app\common\model\recharge\RechargeOrder::where([
  295. 'order_type' => 0,
  296. 'user_id' => $params['user_id'],
  297. 'sn'=>$params['sn']
  298. ])->value('work_id');
  299. if(empty($work_id)){
  300. throw new Exception('订单不存在');
  301. }
  302. //更新工单状态为已取消
  303. $service_work = ServiceWork::find($work_id);
  304. if($service_work->user_confirm_status!=3){
  305. throw new Exception('请勿重复操作');
  306. }
  307. $orders = RechargeOrder::where(['work_id'=>$work_id,'user_id'=>$params['user_id']])->select()->toArray();
  308. //确认所有订单总金额和结算金额
  309. //若订单是全款已支付订单
  310. if(count($orders)==1 and $orders[0]['payment_type']==0 and $orders[0]['pay_status']==1){
  311. $service_work->work_status = 7;
  312. $service_work->user_confirm_status = 5;
  313. $service_work->service_status = 3;
  314. $service_work->work_pay_status = 1;
  315. $service_work->work_total = $orders[0]['order_total'];
  316. $service_work->work_amount = $orders[0]['order_amount'];
  317. }else{
  318. $service_work->work_status = 6;
  319. $service_work->user_confirm_status = 4;
  320. $order_total = 0;
  321. foreach ($orders as $k=>$v){
  322. $order_total += $v['order_total'];
  323. }
  324. $service_work->work_total = $order_total;
  325. }
  326. $service_work->save();
  327. $work_log = [
  328. 'work_id'=>$work_id,
  329. 'master_worker_id'=>$service_work->master_worker_id,
  330. 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认服务完成',
  331. ];
  332. ServiceWorkLogLogic::add($work_log);
  333. Db::commit();
  334. }
  335. catch (\Exception $e) {
  336. self::setError($e->getMessage());
  337. return false;
  338. }
  339. }
  340. public static function queryEffective($params)
  341. {
  342. Db::startTrans();
  343. try {
  344. $work_id = \app\common\model\recharge\RechargeOrder::where([
  345. 'order_type' => 0,
  346. 'user_id' => $params['user_id'],
  347. 'sn'=>$params['sn']
  348. ])->value('work_id');
  349. if(empty($work_id)){
  350. throw new Exception('订单不存在');
  351. }
  352. return true;
  353. }catch(\Exception $e){
  354. Db::rollback();
  355. self::setError($e->getMessage());
  356. return false;
  357. }
  358. }
  359. }