$this->auth->id, ]; $whereop = '(order.pay_type = 1 and order.status = 1) or (order.pay_type = 2)'; if($active_status == 1){ $where['active.activestarttime'] = ['gt',time()]; $where['order.status'] = 1; } if($active_status == 2){ $where['active.activestarttime'] = ['lt',time()]; $where['active.activeendtime'] = ['gt',time()]; $where['order.status'] = 1; } if($active_status == 3){ $where['active.activeendtime'] = ['lt',time()]; $where['order.status'] = 1; } if($active_status == 4){ $where['order.pay_type'] = 2; $where['order.status'] = 0; } $list = Db::name('order')->field('order.*,active.activestarttime,active.activeendtime,active.name,active.images') ->join('active','order.active_id = active.id','LEFT') ->where($where)->where($whereop)->order('order.id desc')->autopage()->select(); $list = list_domain_image($list,['images','offline_images']); if(!empty($list)){ foreach($list as $key => &$item){ //第一个图 $item['image'] = isset($item['images'][0]) ? $item['images'][0] : ''; //状态 $status_text = '进行中'; $status = 2; if(time() < $item['activestarttime']){ $status_text = '报名中'; $status = 1; } if(time() > $item['activeendtime']){ $status_text = '已结束'; $status = 3; } //是否能传图 $item['can_upload'] = 0; if($item['pay_type'] == 2 && $item['status'] == 0){ //收款码支付,待支付的 $item['can_upload'] = 1; //待审核状态 $status_text = '待审核'; $status = 4; } $item['status_text'] = $status_text; $item['active_status'] = $status; } } $this->success(1,$list); } public function info(){ $id = input('id',0); $info = Db::name('order')->field('order.*,active.activestarttime,active.activeendtime,active.name,us.realname,school.schoolname,grade.gradename,classes.classname') ->join('active','order.active_id = active.id','LEFT') ->join('user_student us','order.student_id = us.id','LEFT') ->join('school','us.school_id = school.id','LEFT') ->join('grade','us.grade_id = grade.id','LEFT') ->join('classes','us.classes_id = classes.id','LEFT') ->where('order.id',$id)->find(); $info = info_domain_image($info,['offline_images']); $status_text = '进行中'; $status = 2; if(time() < $info['activestarttime']){ $status_text = '报名中'; $status = 1; } if(time() > $info['activeendtime']){ $status_text = '已结束'; $status = 3; } //是否能传图 $info['can_upload'] = 0; if($info['pay_type'] == 2 && $info['status'] == 0){ //收款码支付,待支付的 $info['can_upload'] = 1; //待审核状态 $status_text = '待审核'; $status = 4; } $info['status_text'] = $status_text; $info['active_status'] = $status; $this->success(1,$info); } public function order_upload(){ $offline_images = input('offline_images','trim'); $remark = input('remark',''); $id = input('id',0); $data = [ 'offline_images' => $offline_images, 'remark' => $remark, 'ispayimg' => 1, ]; $info = Db::name('order')->where('id',$id)->update($data); $this->success('上传成功'); } public function pay_qrcode(){ $id = input('id',0,'intval'); $info = Db::name('pay_qrcode')->where('is_show',1)->where('id != '.$id)->orderRaw('rand()')->find(); $info = info_domain_image($info,['image']); $this->success(1,$info); } }