1, ]; $banner = Db::name('banner')->field('id,title,type,image,video_file,url')->where($where)->order('weigh', 'desc')->select(); $banner = list_domain_image($banner, ['image','video_file']); if(!empty($banner)){ foreach($banner as $key => $val){ $banner[$key]['thumb_image'] = '1.jpg'; } } //第一条公告 $message = Db::name('message_sys')->where('is_show',1)->where('is_index',1)->order('weigh','desc')->find(); $message = $this->info_lang($message,['title','info']); if($message){ $message['createtime'] = get_last_time($message['createtime']); } //留个好评 $haoping = Db::name('appplat')->field('image,url')->where('type',1)->order('weigh', 'desc')->select(); $haoping = list_domain_image($haoping, ['image']); //关注我们 $followus = Db::name('appplat')->field('image,url')->where('type',2)->order('weigh', 'desc')->select(); $followus = list_domain_image($followus, ['image']); $result = [ 'banner' => $banner, 'message' => $message, 'haoping' => $haoping, 'followus' => $followus, 'contact_mobile' => config('site.contact_mobile'), 'contact_email' => config('site.contact_email'), 'index_middle_image' => localpath_to_netpath(config('site.index_middle_image')), 'index_bottom_image' => localpath_to_netpath(config('site.index_bottom_image')), 'map_longitude' => '103.8014002', 'map_latitude' => '1.2763445', ]; $this->success(1,$result); } //搜索 public function search(){ $keyword = input('keyword','','trim'); if(empty($keyword)){ $this->error(); } //搜课时表 $where = [ 'lesson.name|lesson.name_en' => ['LIKE','%'.$keyword.'%'], 'slot.starttime' => ['gt',time()],//未开始 'slot.status' => 0,//报名中 ]; $list = Db::name('lesson_slot')->alias('slot') ->field('slot.*,lesson.name,lesson.name_en,lesson.image,lesson.price') ->join('lesson','slot.lesson_id = lesson.id','LEFT') ->where($where)->autopage()->select(); $list = list_domain_image($list,['image']); $list = $this->list_lang($list,['name']); //准备教练数据 $coach_list = Db::name('coach')->column('id,nickname'); foreach($list as $key => &$slot){ //放入教练 $coach_text = ''; $coach_ids = explode(',',$slot['coach_ids']); foreach($coach_ids as $coach_id){ $coach_text .= $coach_list[$coach_id].','; } $slot['coach_text'] = substr($coach_text,0,-1); } $this->success(1,$list); } }