new_sdk_wu/www/new_sdk/application/home/controller/Search.php

<?php

// 搜索页
namespace app\home\controller;

use think\Db;
use think\Config;
use app\common\model\GameHome as GameModel;
use app\common\model\News as NewsModel;

class Search extends Home{

	/**
     * 初始化操作
     */
    protected function _initialize()
    {
        parent::_initialize();
    }

    /**
     * 搜索
     */
    public function index(){

    	$keyword = input('keyword');

    	$gameList = $this->_getGameList($keyword);
    	$newsList = $this->_getNewsList($keyword);
    	$adModel = Db::name('cy_ad');
    	$adInfo = Db::connect(config('database_slave'))->table('cy_ad')->cache(Config::get('QUERY_RESULT_CACHE_TIME'))->where(['type'=>99])->order('sort asc,create_time asc')->find();

        $this->assign('adInfo',$adInfo);
    	$this->assign('list',$gameList['list']);
    	$this->assign('newsList',$newsList['list']);
        $this->assign('page',$gameList['page']);
        $this->assign('newsPage',$newsList['page']);
        $this->assign('keyword',$keyword);
  
        return $this->fetch();
    }


    // 游戏列表
    public function _getGameList($keyword) {
       
        $list = (new GameModel())->alias('game')->cache(Config::get('QUERY_RESULT_CACHE_TIME'))
                ->join('cy_gameinfo info', 'game.id = info.game_id')
                ->join('cy_sdkgamelist sdk', 'game.id=sdk.gameid and sdk.package_type=0 and sdk.upload_status=1 and sdk.channel_id='.MEMBER_DEFAULT_CHANNEL_ID,'left')
                ->field('LENGTH(game.nickname) as tLen,LOCATE("'.$keyword.'",game.nickname) as tIndex,LOCATE("'.$keyword.'",game.pinyin) as cIndex,game.id,game.nickname,game.power,info.androidurl,game.pinyin,info.mobileicon,game.type,game.subject,sdk.filename')
                ->where(['game.cooperation_status' => ['in','1,2'],'game.is_show' => 1])
                ->where('game.nickname|game.pinyin','like','%'. $keyword .'%')
               ->order('tIndex, cIndex,tLen,game.create_time desc')
                ->paginate(9, false, array('path'=>'javascript:AjaxGamePage([PAGE]);',))       
				->each(function ($item, $key){
					$item['icon'] = getGameIcon($item['mobileicon']);
					$item['size'] = getSize($item);
					$item['download'] = getDownload($item);
					$item['subject'] = Db::connect(config('database_slave'))->cache(Config::get('QUERY_RESULT_CACHE_TIME'))->table('cy_gamesubject')->where('id',$item['subject'])->value('name') ? : '未知';
					$item['type'] = Db::connect(config('database_slave'))->cache(Config::get('QUERY_RESULT_CACHE_TIME'))->table('cy_gametype')->where('id',$item['type'])->value('name') ? : '未知';
					$item['gameUrl'] = getGameUrl($item['id']);
					$item['libaonum'] = model('Gift')->where(['isdelete'=>0,'gameid'=>$item['id'],'endtime'=>['gt',NOW_TIMESTAMP]])->where('total > used')->count('id');
					return $item;
            });

			return ['list'=>$list,'page'=>$list->render()];

    }

    public function _getNewsList($keyword) {

        $newsList = (new NewsModel())->cache(Config::get('QUERY_RESULT_CACHE_TIME'))
				->alias('a')
                ->join('cy_content b', 'a.id = b.id','left')
                ->field('a.id,a.title,a.image,a.jlink,a.create_time,a.total,a.zhiding,a.type,a.gameid,b.content')
                ->where(['a.isdelete' => 0,'a.type' => ['in',[1,2,3,4,5]]])
                ->where('a.title','like','%'. $keyword .'%')
                ->order('a.zhiding desc,a.id desc')
                ->paginate(10, false, array('path'=>'javascript:AjaxPage([PAGE]);',))         
				->each(function ($item, $key){
					$item['image'] = getNewsImage($item['image']);
					$item['url'] = getNewsUrl($item['id'],$item['jlink']);
					$item['createtime'] = date('Y-m-d H:i:s',$item['create_time']);
					$item['cutcontent'] = getCutcontent($item['content']);
					return $item;
            });

		return ['list'=>$newsList,'page'=>$newsList->render(),'keyword'=>$keyword];
    }
}