(laravel框架)为分页添加小功能：用下拉框设置每页显示的条数

来源：互联网发布：win7注册表卸载软件编辑：程序博客网时间：2024/05/17 17:55

/**     * 操作日志列表//SystemServer.php：逻辑代码区     */    public static function log(&$request)    {        $_db = DB::table('logs')            ->leftJoin('admin','logs.emp_id','=','admin.user_id');        //操作时间        if($request['create_start'])        {            $start_time = strtotime($request['create_start']);            $_db = $_db->where('logs.log_create', '>=', $start_time);        }        if($request['create_end'])        {            $end_time = strtotime($request['create_end']. ' 23:59:59');            $_db = $_db->where('logs.log_create', '<=',$end_time);        }        //操作人        if($request['name'])        {            $_db = $_db->where('admin.name', 'like', '%'.$request['name'].'%');        }        //用户编号        if($request['emp_id'])        {            $_db = $_db->where('logs.emp_id', '=', $request['emp_id']);        }        //操作内容        if($request['log_content'])        {            $_db = $_db->where('logs.log_content', 'like', '%'.$request['log_content'].'%');        }        $data = $_db->orderBy('log_create','desc')            ->select(                'admin.name',                'logs.emp_id',                'logs.log_type',                'logs.log_table',                'logs.log_dataid',                'logs.log_content',                'logs.log_create'            )            ->paginate(max($request['pageSize'],20));        //dd($data);//dd($data->perPage());//获取每页显示的条数        return $data;    }

/** * 操作日志列表//SystemController.php:控制器代码去 */public function log(){    //var_dump(Request::all());    if($this->_request['output'])    {        if($this->_request['create_start'] || $this->_request['create_end'] || $this->_request['name'] || $this->_request['emp_id'] || $this->_request['log_content'])        {            $tsv = array();            $tsv['title'] = array("操作人","员工编号","操作类型","相关表","region","操作内容","操作时间");            $tsv['filename'] = "操作日志";            $tsv['content'] = array();            $result = SystemService::excel($this->_request);            $data  = object_array($result); //对象转数组            $tmp = array();            foreach ($data as $item){                $tmp[] = $item['name'];                $tmp[] = $item['emp_id'];                $tmp[] = $item['log_type'];                $tmp[] = $item['log_table'];                $tmp[] = $item['log_dataid'];                $tmp[] = $item['log_content'];                $tmp[] = date('Y-m-d H:i:s', $item['log_create']);                $tsv['content'][] = $tmp;                $tmp = array();            }            if (exportToExcel($tsv)){                return true;            }        }else        {            return redirect('/System/log');        }    }    else    {        $data = SystemService::log($this->_request);        View::share('log',$data);        //dd($data->perPage());        return $this->display('admin.system.log');    }}

/*

HTML代码区域

*/

<select class="form-control input-sm" name="pageSize" id="pageSize" itemname='리밋트' onchange="javascript:document.yzForm.submit(this);">    <option value="{{$log->perPage()}}"    <?=$pageSize == $log->perPage() ? 'selected':'';?> style="display: none">{{$log->perPage()}}</option>    <option value="20" <?=$pageSize == '20' ? 'selected':'';?>>20</option>    <option value="30" <?=$pageSize == '30' ? 'selected':'';?>>30</option>    <option value="50" <?=$pageSize == '50' ? 'selected':'';?>>50</option>    <option value="100" <?=$pageSize == '100' ? 'selected':'';?>>100</option></select>

0 0