isEmpty()){ throw new Exception('产品不存在!'); } if(empty($params['user_info']['mobile'])){ throw new Exception('请先补充您的联系方式后在提交订单'); } //根据服务工单计算当前订单应支付金额 $order_total = $goods['service_total']; if($goods['goods_payment_type'] = GoodsEnum::ISGOODS_PAYMENT_TYPE){ //一口价订单 $order_amount = $goods['service_fee']; $pay_status = PayEnum::UNPAID; $work_pay_status = WorkEnum::UN_PAY_STATUS; }else{ $order_amount = $goods['base_service_fee']; $pay_status = !empty($order_amount)?PayEnum::UNPAID:PayEnum::ISPAID; $work_pay_status = !empty($order_amount)?WorkEnum::UN_PAY_STATUS:WorkEnum::IS_PAY_STATUS; } //生成服务工单 $work_data = [ 'work_sn' => generate_sn(ServiceWork::class, 'work_sn'), 'real_name' => !empty($params['user_info']['real_name'])?$params['user_info']['real_name']:$params['user_info']['nickname'], 'mobile' => $params['user_info']['mobile'], 'address' => $params['address'], 'title' => $goods->goods_name . '*' . $goods->goods_number.$goods->good_unit, 'category_type' => $goods['category_type'], 'goods_category_ids' => $goods['goods_category_ids'], 'goods_category_id' => $goods['goods_category_id'], 'base_service_fee' => $goods['base_service_fee'], 'service_fee' => $goods['service_fee'], 'work_pay_status'=>$work_pay_status, 'appointment_time' => strtotime($params['appointment_time']), ]; $service_work = ServiceWork::create($work_data); //生成服务订单 $data = [ 'work_id'=> $service_work['id'], 'sn' => generate_sn(RechargeOrder::class, 'sn'), 'order_type'=>0,//服务订单 'order_terminal' => $params['terminal'], 'user_id' => $params['user_id'], 'pay_status' => $pay_status, 'pay_way' => $params['pay_way'], 'order_total' => $order_total, 'order_amount' => $order_amount, ]; $order = RechargeOrder::create($data); //生成订单服务详情 OrderGoods::create([ 'sn' => $order['sn'], 'goods_id' => $params['goods_id'], 'category_type' => $goods['category_type'], 'goods_category_ids' => $goods['goods_category_ids'], 'goods_category_id' => $goods['goods_category_id'], 'goods_name' => $goods['goods_name'], 'goods_image' => $goods['goods_image'], 'goods_video' => $goods['goods_video'], 'goods_number' => $goods['goods_number'], 'good_unit' => $goods['good_unit'], 'goods_size' => $goods['goods_size'], 'goods_type' => $goods['goods_type'], 'goods_brand' => $goods['goods_brand'], 'install_guide' => $goods['install_guide'], 'goods_payment_type'=>$goods['goods_payment_type'], 'base_service_fee' => $goods['base_service_fee'], 'service_total' => $goods['service_total'], 'service_fee' => $goods['service_fee'], 'service_image' => $goods['service_image'], 'warranty_period'=>$goods['warranty_period'], 'fee_schedule' => $goods['fee_schedule'], 'goods_status' => $goods['goods_status'], ]); Db::commit(); } catch (\Exception $e) { self::setError($e->getMessage()); return false; } return [ 'order_id' => (int)$order['id'], ]; } /** * 获取详情 * @param $params * @return array|false */ public static function detail($params) { try { $order_info = \app\common\model\recharge\RechargeOrder::with(['order_goods'=>function ($query) { $query->visible(['goods_name','goods_image','goods_number','good_unit']); },'service_work'=>function ($query) { $query->visible(['service_status','appointment_time','address','master_worker_id']); }]) ->visible(['id','sn','order_total','order_amount','pay_status','create_time','title','work_id']) ->where([ 'order_type' => 0, 'user_id' => $params['user_id'], 'sn'=>$params['sn'] ])->findOrEmpty()->toArray(); $order_info['master_worker'] = [ 'real_name'=>'', 'worker_number'=>'', 'mobile'=>'', 'worker_exp'=>'' ]; //获取师傅参数 if(!empty($order_info['service_work']['master_worker_id'])){ $worker = MasterWorker::find($order_info['service_work']['master_worker_id']); $order_info['master_worker']['real_name'] = $worker['real_name']; $order_info['master_worker']['worker_number'] = $worker['worker_number']; $order_info['master_worker']['mobile'] = $worker['mobile']; $maintain_exp_type = !empty($worker->worker_register->maintain_exp_type)?$worker->worker_register->maintain_exp_type:''; $order_info['master_worker']['worker_exp'] = DictData::where(['type_value'=>'worker_exp_type','value'=>$maintain_exp_type])->value('name'); } //搜索当前工单下的所有订单记录 $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(); $pay_status_data = DictData::where('type_value','pay_status')->column('name','value'); $payment_type_data = DictData::where('type_value','payment_type')->column('name','value'); $pay_way_data = DictData::where('type_value','pay_way')->column('name','value'); foreach ($order_info['pay_orders'] as $k=>&$v){ $v['pay_status_name'] = $pay_status_data[$v['pay_status']]; $v['payment_type_name'] = $payment_type_data[$v['payment_type']]; $v['pay_way_name'] = $pay_way_data[$v['pay_way']]; } return $order_info; } catch (\Exception $e) { self::setError($e->getMessage()); return false; } } /** * 取消订单 * @param $params * @return false|void */ public static function cancelOrder($params) { Db::startTrans(); try { $work_id = \app\common\model\recharge\RechargeOrder::where([ 'order_type' => 0, 'user_id' => $params['user_id'], 'sn'=>$params['sn'] ])->value('work_id'); if(empty($work_id)){ throw new Exception('订单不存在'); } $payed_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id,'pay_status'=>1])->findOrEmpty(); if(!$payed_order->isEmpty()){ throw new Exception('存在已支付订单,不允许取消订单,请联系客服'); } //软删除订单 $cancel_order = \app\common\model\recharge\RechargeOrder::where(['user_id'=>$params['user_id'],'work_id'=>$work_id])->findOrEmpty(); $cancel_order->delete(); //更新工单状态为已取消 $service_work = ServiceWork::find($work_id); $service_work->service_status = 4; $service_work->save(); Db::commit(); } catch (\Exception $e) { self::setError($e->getMessage()); return false; } } /** * 用户确认尾款报价单 * @param $params * @return false|void */ public static function confirmOrder($params) { Db::startTrans(); try { $work_id = \app\common\model\recharge\RechargeOrder::where([ 'order_type' => 0, 'user_id' => $params['user_id'], 'sn'=>$params['sn'] ])->value('work_id'); if(empty($work_id)){ throw new Exception('订单不存在'); } //更新工单状态为已取消 $service_work = ServiceWork::find($work_id); if($service_work->user_confirm_status==1){ throw new Exception('请勿重复操作'); } $service_work->work_status = 5; $service_work->user_confirm_status = 2; $service_work->save(); $work_log = [ 'work_id'=>$work_id, 'master_worker_id'=>$service_work->master_worker_id, 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认了报价单', ]; ServiceWorkLogLogic::add($work_log); Db::commit(); } catch (\Exception $e) { self::setError($e->getMessage()); return false; } } /** * 用户确认服务完成 * @param $params * @return false|void */ public static function confirmServiceFinish($params) { Db::startTrans(); try { $work_id = \app\common\model\recharge\RechargeOrder::where([ 'order_type' => 0, 'user_id' => $params['user_id'], 'sn'=>$params['sn'] ])->value('work_id'); if(empty($work_id)){ throw new Exception('订单不存在'); } //更新工单状态为已取消 $service_work = ServiceWork::find($work_id); if($service_work->user_confirm_status!=3){ throw new Exception('请勿重复操作'); } $orders = RechargeOrder::where(['work_id'=>$work_id,'user_id'=>$params['user_id']])->select()->toArray(); //确认所有订单总金额和结算金额 //若订单是全款已支付订单 if(count($orders)==1 and $orders[0]['payment_type']==0 and $orders[0]['pay_status']==1){ $service_work->work_status = 7; $service_work->user_confirm_status = 5; $service_work->work_total = $orders[0]['order_total']; $service_work->work_amount = $orders[0]['order_amount']; }else{ $service_work->work_status = 6; $service_work->user_confirm_status = 4; $order_total = 0; foreach ($orders as $k=>$v){ $order_total += $v['order_total']; } $service_work->work_total = $order_total; } $service_work->save(); $work_log = [ 'work_id'=>$work_id, 'master_worker_id'=>$service_work->master_worker_id, 'opera_log'=>'用户'.$params['user_info']['real_name'].'于'.date('y-m-d H:i:s',time()).'于'.date('Y-m-d H:i:s',time()).'确认服务完成', ]; ServiceWorkLogLogic::add($work_log); Db::commit(); } catch (\Exception $e) { self::setError($e->getMessage()); return false; } } public static function queryEffective($params) { Db::startTrans(); try { $work_id = \app\common\model\recharge\RechargeOrder::where([ 'order_type' => 0, 'user_id' => $params['user_id'], 'sn'=>$params['sn'] ])->value('work_id'); if(empty($work_id)){ throw new Exception('订单不存在'); } return true; }catch(\Exception $e){ Db::rollback(); self::setError($e->getMessage()); return false; } } }