/**
* 操作日志
*/
public function opLogAction()
{
$this->setLeftNav('opLog');
$req = $this->request;
$page = intval($req->getQuery('page', null, 1));
$page = $page > 0 ? $page : 1;
$limit = $this->pageNavLimit;
$filterOp = intval($req->getQuery('filterOp', null, -10000));
$filterType = intval($req->getQuery('filterType', null, -10000));
$where = [];
$bindParams = [];
if ($filterOp > -10000) {
$where[] = 'Apps\\Common\\Models\\BackendOperatorLog.operator_id = :opId:';
$bindParams['opId'] = $filterOp == -10000 ? 0 : $filterOp;
}
if ($filterType > -10000) {
$where[] = 'log_type = :opType:';
$bindParams['opType'] = $filterType;
}
$whereStr = implode(' AND ', $where);
// 总数
$total = BackendOperatorLog::count(['conditions' => $whereStr, 'bind' => $bindParams]);
// 操作员列表
$opList = BackendOperator::find();
$this->view->setVar('opList', $opList);
// 操作类型
$this->view->setVar('opLogTypes', BackendOperatorLogType::find());
$data = BackendOperatorLog::query()->columns(['Apps\\Common\\Models\\BackendOperatorLog.log_id', 'op.operator_id', 'op.operator_show_name', 'logType.type_title log_type', 'Apps\\Common\\Models\\BackendOperatorLog.log_client_info', 'Apps\\Common\\Models\\BackendOperatorLog.log_addtime'])->where($whereStr)->bind($bindParams)->leftJoin('Apps\\Common\\Models\\BackendOperator', 'op.operator_id = Apps\\Common\\Models\\BackendOperatorLog.operator_id', 'op')->leftJoin('Apps\\Common\\Models\\BackendOperatorLogType', 'logType.type_id = Apps\\Common\\Models\\BackendOperatorLog.log_type', 'logType')->limit($limit, ($page - 1) * $limit)->orderBy('Apps\\Common\\Models\\BackendOperatorLog.log_id DESC')->execute();
$this->view->setVar('total', $total);
$this->view->setVar('page', $page);
$this->view->setVar('limit', $limit);
$this->view->setVar('filterOp', $filterOp);
$this->view->setVar('filterType', $filterType);
$this->view->setVar('data', $data);
}
