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'); }