public function view()
{
$queueTaskLogDB = new QueueTaskLogModelDB();
//普通条件，检查GET参数
$whereStr = count($where) > 0 ? implode(" AND ", $where) : '1=1';
if (preg_match("/\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:\\d{1,2}/", $_GET['begin_time_start']) || preg_match("/\\d{4}-\\d{1,2}-\\d{1,2}\\s\\d{1,2}:\\d{1,2}/", $_GET['begin_time_end'])) {
$whereStr = $whereStr == '1=1' ? "`begin_time` > ? AND `begin_time` < ?" : $whereStr . " AND `begin_time` > ? AND `begin_time` < ?";
$whereArr[] = strtotime($_GET['begin_time_start']);
$whereArr[] = strtotime($_GET['begin_time_end']);
}
if (!empty($_GET['project_id'])) {
Common::debug('111');
$whereStr = $whereStr . " AND `project_id` = ?";
$whereArr[] = $_GET['project_id'];
}
if (is_numeric($_GET['status'])) {
$whereStr = $whereStr . " AND `status` = ?";
$whereArr[] = $_GET['status'];
}
if (!empty($_GET['task'])) {
$whereStr = $whereStr . " AND `task` LIKE ?";
$whereArr[] = "%" . $_GET['task'] . "%";
}
//排序条件
$orderStr = '`id` DESC';
if (!empty($_POST['order'])) {
foreach ($_POST['order'] as $k => $v) {
$orderArr[] = "`{$k}` {$v}";
}
$orderStr = implode(',', $orderArr);
}
//查询操作
$sql = "SELECT * FROM `" . $queueTaskLogDB->getTableName() . "` WHERE {$whereStr} ORDER BY {$orderStr}";
$data = $queueTaskLogDB->getData($sql, $whereArr, 40);
$pageStr = $queueTaskLogDB->getPageStr();
$pageJump = $queueTaskLogDB->getPageJump();
//读取外键数据
$projectFkArr = QueueTaskLogModel::getProject();
$this->setView('projectFkArr', $projectFkArr);
//模版显示
$this->setView('pageStr', $pageStr);
$this->setView('pageJump', $pageJump);
$this->setView('data', $data);
$this->display('QueueTaskLog.html');
}
