validate('createnew'); // $question = trim($request->question); if(mb_strlen($question) > 300){ return $this->fail(200016,[],'咨询内容不能超过300字'); } // $images = trim($request->images); $images = trim($images,','); if(count(explode(',',$images)) > 9){ return $this->fail(200016,[],'咨询图片最大9张'); } //验证答主 if($request->uid == $request->blogger_user_id){ return $this->fail(200016,[],'不能咨询自己'); } $blogger = DB::table('blogger')->where('user_id',$request->blogger_user_id)->first(); if(empty($blogger)){ return $this->fail(200016,[],'此答主没有经过认证'); } if($blogger->status != 1){ return $this->fail(200016,[],'此答主没有经过认证'); } // $data = [ 'user_id' => $request->uid, 'blogger_user_id' => $request->blogger_user_id, 'question' => $question, 'images' => $images, 'createtime' => time(), 'ask_price' => $blogger->ask_price, 'sit_price' => $blogger->sit_price, 'ask_minute' => $blogger->ask_minute, 'is_hidden' => $request->is_hidden, 'is_public' => $request->is_public, ]; //0元的直接已付 $need_pay = 1; if($blogger->ask_price == 0){ $data['status'] = 10; $data['paytime'] = time(); $need_pay = 0; } $order_id = DB::table('ask_order')->insertGetId($data); return $this->success(['order_id'=>$order_id,'need_pay'=>$need_pay]); } //评价此次咨询 public function evaluate(AskRequest $request){ // 验证 $request->validate('evaluate'); // $eva_content = trim($request->eva_content); if(mb_strlen($eva_content) > 100){ return $this->fail(200016,[],'咨询内容不能超过100字'); } // $score = $request->eva_score; if($score < 0){ $score = 0; } if($score > 5){ $score = 5; } // $order_id = _empty_default_($request->order_id,0); $order = DB::table('ask_order')->where('id',$order_id)->where('user_id',$request->uid)->where('status','>',0)->first(); if(empty($order)){ return $this->fail(200016,[],'没有找到该咨询'); } if($order->status != 20){ return $this->fail(200016,[],'咨询还没有结束'); } if(!empty($order->eva_content)){ return $this->fail(200016,[],'已经评价过了'); } // $update = [ 'eva_score' => $request->eva_score, 'eva_content' => $request->eva_content, ]; DB::table('ask_order')->where('id',$order_id)->update($update); return $this->success(); } //结束此次咨询 //旁听 public function sit(Request $request){ $order_id = _empty_default_($request->order_id,0); $order = DB::table('ask_order')->where('id',$order_id)->first(); if(empty($order)){ return $this->fail(200016,[],'没有找到该咨询'); } if($order->status != 20){ return $this->fail(200016,[],'咨询还没有结束'); } if($order->is_public != 1){ return $this->fail(200016,[],'咨询没有公开'); } if($order->user_id == $request->uid){ return $this->fail(200016,[],'不需要旁听自己咨询的内容'); } if($order->blogger_user_id == $request->uid){ return $this->fail(200016,[],'不需要旁听自己回答的内容'); } //是否需要支付 $need_pay = 1; //检查旁听订单 $sit_order_id = 0; $sit_order = DB::table('ask_sit_order')->where('order_id',$order_id)->where('sit_user_id',$request->uid)->first(); if($sit_order){ $sit_order_id = $sit_order->id; if($sit_order->status == 10){ return $this->fail(200016,[],'已经旁听过了'); }else{ //去支付即可 } }else{ $data = [ 'order_id' => $order_id, 'sit_user_id' => $request->uid, 'createtime' => time(), 'sit_price' => $order->sit_price, ]; if($order->sit_price == 0){ $need_pay = 0; //零元不需要支付 $data['status'] = 10; $data['paytime'] = time(); } $sit_order_id = DB::table('ask_sit_order')->insertGetId($data); } return $this->success(['sit_order_id'=>$sit_order_id,'need_pay'=>$need_pay]); } //付费咨询拉起订单 public function payAskOrder(Request $request) { $order_id = _empty_default_($request->order_id,0); $uid = $request->uid; $order = DB::table('ask_order')->where('id',$order_id)->where('user_id',$request->uid)->first(); if(empty($order)){ return $this->fail(200016,[],'没有找到该咨询'); } if($order->status != 0){ return $this->fail(200016,[],'该咨询已经支付过了'); } //使用余额支付 if($request->pay_type == 'balance'){ //检查支付密码 $rs = $this->check_paycode($uid,$request->paycode); if($rs !== true){ return $rs; } //检查余额 $balance = UserUtils::user_balance($uid); if($balance <= $order->ask_price){ return $this->fail(200012); } DB::beginTransaction(); //余额支付 $pay_res = UserUtils::update_user_financial($uid, 101, $order->ask_price, '您花费了¥'.$order->ask_price.'余额,付费咨询'); if(!$pay_res){ DB::rollBack(); return $this->fail(200012); } //直接修改订单状态,支付完成 $rs1 = DB::table('ask_order')->where('id',$order_id)->update(['status'=>10,'paytime'=>time()]); if(!$rs1){ DB::rollBack(); return $this->fail([],200,'支付失败'); } DB::commit(); return $this->success([],200,'余额支付成功'); } //拉起三方支付 $body = '付费咨询'; $data['body'] = '付费咨询'; $total_fee = $order->ask_price; $orderSn = 'A' . Utils::getSn('A'); $parame = serialize($data); // 创建订单 $this->createOrder($uid,101,$body,$total_fee,$total_fee,$orderSn,$parame,'ask_order',$order_id); $openid = WxUser::where('id', $uid)->value('weixin_openid'); $appid = Settings::get('app_id'); $mch_id = Settings::get('mch_id'); $key = Settings::get('mch_secret'); $out_trade_no = $orderSn; if(_empty_($openid)){ return $this->fail(200043, [ 'title' => '未绑定微信', 'content' => '还没有获取到您的小程序openId,无法拉起支付', 'confirmText' => '去绑定', 'target_type' => 6, 'target_id' => '/pagesA/mine/editmine/accountbind' ], '未绑定微信'); } return $this->payHandler($uid, 'wxpay', 'mini', $total_fee, $data['body'], $out_trade_no, 1); } //付费咨询拉起订单 public function paySitOrder(Request $request) { $order_id = _empty_default_($request->order_id,0); $uid = $request->uid; $order = DB::table('ask_sit_order')->where('id',$order_id)->where('sit_user_id',$request->uid)->first(); if(empty($order)){ return $this->fail(200016,[],'没有找到该旁听'); } if($order->status != 0){ return $this->fail(200016,[],'该旁听已经支付过了'); } //使用余额支付 if($request->pay_type == 'balance'){ //检查支付密码 $rs = $this->check_paycode($uid,$request->paycode); if($rs != true){ return $rs; } //检查余额 $balance = UserUtils::user_balance($uid); if($balance <= $order->sit_price){ return $this->fail(200012); } DB::beginTransaction(); //余额支付 $pay_res = UserUtils::update_user_financial($uid, 102, $order->sit_price, '您花费了¥'.$order->sit_price.'余额,付费旁听'); if(!$pay_res){ DB::rollBack(); return $this->fail(200012); } //直接修改订单状态,支付完成 $rs1 = DB::table('ask_order')->where('id',$order_id)->update(['status'=>10,'paytime'=>time()]); if(!$rs1){ DB::rollBack(); return $this->fail([],200,'支付失败'); } DB::commit(); return $this->success([],200,'余额支付成功'); } //拉起三方支付 $body = '付费旁听'; $data['body'] = '付费旁听'; $total_fee = $order->sit_price; $orderSn = 'S' . Utils::getSn('S'); $parame = serialize($data); // 创建订单 $this->createOrder($uid,102,$body,$total_fee,$total_fee,$orderSn,$parame,'sit_order',$order_id); $openid = WxUser::where('id', $uid)->value('weixin_openid'); $appid = Settings::get('app_id'); $mch_id = Settings::get('mch_id'); $key = Settings::get('mch_secret'); $out_trade_no = $orderSn; if(_empty_($openid)){ return $this->fail(200043, [ 'title' => '未绑定微信', 'content' => '还没有获取到您的小程序openId,无法拉起支付', 'confirmText' => '去绑定', 'target_type' => 6, 'target_id' => '/pagesA/mine/editmine/accountbind' ], '未绑定微信'); } return $this->payHandler($uid, 'wxpay', 'mini', $total_fee, $data['body'], $out_trade_no, 1); } //检查支付密码 private function check_paycode($uid, $paycode){ //验证支付密码 if(_empty_($paycode)){ return $this->fail(200004, [], '请先输入支付密码'); } if(is_array($paycode) && str_replace(',', '', implode(',', $paycode)) !== get_user_meta($uid, 'paycode', 's')){ return $this->fail(200043, [ 'title' => '支付密码错误', 'content' => '已忘记,前往修改?', 'confirmText' => '去修改', 'target_type' => 6, 'target_id' => '/pagesA/mine/paycode/forget' ], '支付密码错误'); } if(is_string($paycode) && $paycode !== get_user_meta($uid, 'paycode', 's')){ return $this->fail(200004, [], '支付密码不匹配'); } return true; } /** * 创建支付订单 * $order_type = 101 咨询订单 * $order_type = 102 旁听订单 */ private function createOrder($user_id,$order_type,$order_information,$order_price,$order_pay_price,$order_number,$parame='',$table_name,$table_id) { $orderModel = new WxOrder(); $orderModel->user_id = $user_id; $orderModel->order_type = $order_type; $orderModel->order_information = $order_information; $orderModel->order_price = $order_price; $orderModel->order_pay_price = $order_pay_price; $orderModel->order_number = $order_number; $orderModel->parame = $parame; $orderModel->table_name = $table_name; $orderModel->table_id = $table_id; $orderModel->save(); return $orderModel; } //答主的主页 //咨询首页 //首页轮播 //推荐答主列表 //某个提问的旁听详情 //我购买的旁听列表 //我发起的咨询 //所有问答列表 //答主的评价列表 // // // // // // // // }