yueke/application/api/controller/Index.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
/**
 * 首页接口
 */
class Index extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 首页
     *
     */
    public function index()
    {
        //轮播图
        $where = [
            'status' => 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']);

        //第一条公告
        $message = Db::name('message_sys')->where('is_show',1)->where('is_index',1)->order('weigh','desc')->find();
        $message = $this->info_lang($message,['title','info']);

        //留个好评
        $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')),
        ];

        $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);
    }
}