/**
* 操作日志列表//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='리밋트' οnchange="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>