/**
* 查看 - 源代码 - 网盘搜索 YB第一阶段开发完成
*/
public function index()
{
$this->request->filter(['strip_tags', 'trim']);
if ($this->request->isAjax()) {
if ($this->request->request('keyField')) {
return $this->selectpage();
}
//list($where, $sort, $order, $offset, $limit) = $this->buildparams();
$sort = input('sort');
$order = input('order');
$limit = input('limit');
$list = Db::table('yb_host_log')
->alias('log')
->field('max(log.nowtime) as maxtime,log.ipaddrs as ip,log.hostname,list.*,reserve.title as areaname')
->join('yb_host list','list.id = log.host_id','INNER')
->join('yb_reserve reserve','list.reserve_code = reserve.id','LEFT')
->group('log.host_id')
->where($this->getSearch(input('param.')))
->order($sort, $order)
->paginate($limit);
$param = $this->getSearch(input('param.'));
$result = array("total" => $list->total(), "rows" => $list->items(), "param"=> $param);
return json($result);
}
return $this->view->fetch();
}