auth->id; $order_no = createUniqueNo('W',$auth_id); //成员信息 $member_info = Db::name('user_member')->where('user_id',$auth_id)->where('id',$member_id)->find(); if(empty($member_info)){ $this->error('不存在的就诊者'); } //医生信息 $doctor_info = Db::name('doctor_info')->where('doctor_id',$doctor_id)->find(); if(empty($doctor_info)){ $this->error('不存在的医生'); } //ordertype if(!in_array($ordertype,[1,2])){ $this->error(); } //价格 $price = 0; if($ordertype == 1){ if($doctor_info['typing_switch'] != 1){ $this->error('该医生未开通图文问诊'); } $price = $doctor_info['typing_price']; } if($ordertype == 2){ if($doctor_info['video_switch'] != 1){ $this->error('该医生未开通视频问诊'); } $price = $doctor_info['video_price']; } if($price <= 0){ $this->error('价格为零'); } //订单数据 $order_data = [ 'order_no' => $order_no, 'user_id' => $auth_id, 'member_id' => $member_id, 'doctor_id' => $doctor_id, 'ordertype' => $ordertype, 'total_fee' => $price, 'book_time' => strtotime($book_time), 'createtime' => time(), 'status' => 0,//订单状态enum ]; Db::startTrans(); //下单 $order_id = Db::name('wenzhen_order')->insertGetId($order_data); if(!$order_id){ Db::rollback(); $this->error('下单失败'); } //订单附表,就诊人信息 $member_data = $member_info; unset($member_data['id']); $member_data['order_id'] = $order_id; $member_data['member_id'] = $member_info['id']; $member_data['member_disease'] = $member_disease; $member_data['member_images'] = $member_images; $order_member_id = Db::name('wenzhen_order_member')->insertGetId($member_data); if(!$order_member_id){ Db::rollback(); $this->error('下单失败'); } // Db::commit(); $this->success('下单成功',$order_id); } //支付订单 public function pay_order(){ $order_id = input('order_id',0); $pay_type = input('pay_type','wechat'); //pay_type if(!in_array($pay_type,['wechat','alipay','wallet'])){ $this->error(); } //订单详情 $wenzhen_order = Db::name('wenzhen_order')->where('user_id',$this->auth->id)->where('id',$order_id)->find(); if(empty($wenzhen_order)){ $this->error('不存在的订单'); } if($wenzhen_order['status'] != 0){ $this->error('该订单不能支付'); } if($pay_type == 'wallet'){ Db::startTrans(); //扣钱 $logtype = $wenzhen_order['ordertype'] == 1 ? 11 : 12; $rs_wallet = model('wallet')->lockChangeAccountRemain($this->auth->id,'money',$wenzhen_order['total_fee'],$logtype,'图文问诊'.$wenzhen_order['order_no'],'wenzhen_order',$order_id); if($rs_wallet['status'] == false){ Db::rollback(); $this->error($rs_wallet['msg']); } //订单改为已支付 $wenzhen_update['status'] = 10;//订单状态enum $wenzhen_update['pay_type'] = $pay_type; $wenzhen_update['pay_time'] = time(); $update_rs = Db::name('wenzhen_order')->where('id',$order_id)->where('status',0)->update($wenzhen_update); if(!$update_rs){ Db::rollback(); $this->error('支付失败,重试一下吧'); } Db::commit(); $result = [ 'pay_type' => $pay_type, 'pay_params' => '', ]; $this->success(1,$result); } //创建订单 $platform = 'app'; $data = []; $data['user_id'] = $this->auth->id; $data['out_trade_no'] = createUniqueNo('W',$this->auth->id); $data['order_amount'] = $wenzhen_order['total_fee']; $data['createtime'] = time(); $data['pay_type'] = $pay_type; $data['platform'] = $platform; $data['order_status'] = 0; $data['table_name'] = 'wenzhen_order'; $data['table_id'] = $order_id; $data['args'] = ''; $orderid = Db::name('pay_order')->insertGetId($data); $openid = ''; //下单 $params = [ 'type' => $pay_type, 'orderid' => $data['out_trade_no'], 'title' => '支付订单', 'amount' => $data['order_amount'], 'method' => $platform, 'openid' => $openid, 'notifyurl' => config('pay_notify_url').'/api/notify/wenzhen_notify_base/paytype/'.$pay_type, 'returnurl' => '', ]; $res = Service::submitOrder($params); $result = [ 'pay_type'=> $pay_type, 'pay_params'=> $pay_type ]; if($pay_type == 'wechat'){ $result['pay_params'] = json_decode($res,true); }else{ $result['pay_params'] = $res; } $this->success(1,$result); } //订单列表 public function order_list(){ $status = input('status','all'); $where = ['user_id'=>$this->auth->id]; if($status != 'all'){ $where['order.status'] = $status; if($status == 30){ $where['order.status'] = ['IN',$status]; } } $field = [ 'order.id','order.order_no','order.createtime','order.status','order.ordertype','order.accept_time', 'doctor.avatar','doctor.nickname', ]; $list = Db::name('wenzhen_order')->alias('order') ->field($field) ->join('doctor','order.doctor_id = doctor.id','LEFT') ->order('order.id desc') ->where($where) ->autopage()->select(); $list = list_domain_image($list,['avatar']); if(!empty($list)){ //循环处理 foreach($list as $key => $val){ $list[$key] = $this->orderinfo_appen($val); } } $this->success(1,$list); } //单个订单,追加数据 private function orderinfo_appen($val){ //订单类型 $ordertype_data = [ 1 => ['name'=>'图文订单','name_en'=>'Visual Order'], 2 => ['name'=>'视频订单','name_en'=>'Video Order'], ]; //状态备注 $status_data = $this->order_status_enum(); //开始处理 //订单类型,辅助 $val['ordertype_data'] = $ordertype_data[$val['ordertype']]; //订单状态,辅助 $status_data_val = $status_data[$val['status']]; //未支付订单N分钟后自动取消 if($val['status'] == 0){ $remain_time = $val['createtime'] + (config('site.nopay_order_autocancel_minute')*60) - time(); if($remain_time > 0){ $status_data_val['minute'] = Sec2Time($remain_time); $status_data_val['minute_en'] = Sec2Time_en($remain_time); $status_data_val['seconds'] = $remain_time; } } //视频订单接诊后N分钟自动结束 if($val['status'] == 30 && $val['ordertype'] == 2){ $remain_time = $val['accept_time'] + (config('site.accept_videoorder_autofinish_minute')*60) - time(); if($remain_time > 0){ $status_data_val['minute'] = Sec2Time($remain_time); $status_data_val['minute_en'] = Sec2Time_en($remain_time); $status_data_val['seconds'] = $remain_time; } } $val['status_data'] = $status_data_val; //处理完成,返回 return $val; } //订单状态备注枚举 private function order_status_enum(){ $status_data = [ 0 => [ 'name'=>'等待支付时间', 'name_en'=>'Waiting time for payment', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], 10 => [ 'name'=>'等待医生接诊:已通知医生尽快接诊,超时自动取消订单并退款', 'name_en'=>'Waiting for the doctor. If not accepted within the specified time,the consultation will be automatically canceled, and a refund will be issued', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], 20 => [ 'name'=>'距离结束时间', 'name_en'=>'Time Remaining', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], 30 => [ 'name'=>'点击查看医生反馈结果', 'name_en'=>'Click to view the consultation results', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], 90 => [ 'name'=>'您的订单未及时支付,已失效', 'name_en'=>'Your order was not paid on time and has expired.', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], 91 => [ 'name'=>'您的订单已申请退款', 'name_en'=>'Your order has been requested for a refund', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], 92 => [ 'name'=>'您的订单已被退诊', 'name_en'=>'Your order has been returned for consultation', 'minute' => '', 'minute_en' => '', 'seconds' => '', ], ]; return $status_data; } //订单详情 public function order_info(){ $order_id = input('order_id',0); //订单详情 $wenzhen_order = Db::name('wenzhen_order')->where('user_id',$this->auth->id)->where('id',$order_id)->find(); if(empty($wenzhen_order)){ $this->error('不存在的订单'); } $wenzhen_order = info_domain_image($wenzhen_order,['feedback_images']); $wenzhen_order = $this->orderinfo_appen($wenzhen_order); //就诊人详情 $order_member_info = Db::name('wenzhen_order_member')->where('order_id',$order_id)->find(); $order_member_info = info_domain_image($order_member_info,['member_images']); $order_member_info['age'] = birthtime_to_age($order_member_info['birthday']); $wenzhen_order['member_info'] = $order_member_info; //医生详情 $field = [ 'd.nickname','d.avatar','d.keshi_id','d.level_id','d.hospital','d.goodat','d.ordernum', 'keshi.name as keshi_name', 'level.name as level_name' ]; $doctor_info = Db::name('doctor')->alias('d') ->field($field) ->join('doctor_level level','d.level_id = level.id','LEFT') ->join('keshi','d.keshi_id = keshi.id','LEFT') ->where('d.id',$wenzhen_order['doctor_id'])->find(); $doctor_info = info_domain_image($doctor_info,['avatar']); $wenzhen_order['doctor_info'] = $doctor_info; $this->success(1,$wenzhen_order); } }