public function view() { $moduleDB = new ModuleModelDB(); //普通条件,检查GET参数 $fieldArr = $moduleDB->getFields(); foreach ($fieldArr as $v) { if ($_GET[$v] !== null) { $where[] = "`{$v}` = ?"; $whereArr[] = $_GET[$v]; } } $whereStr = count($where) > 0 ? implode(" AND ", $where) : '1=1'; if ($_GET['_search_field'] != '' && in_array($_GET['_search_field'], $fieldArr) && $_GET['_search_keyword'] != '') { $whereStr = $whereStr == '1=1' ? $_GET['_search_field'] . " LIKE ?" : $whereStr . " AND " . $_GET['_search_field'] . " LIKE ?"; $whereArr[] = "%" . $_GET['_search_keyword'] . "%"; } //排序条件 $orderStr = '`id` DESC'; if (!empty($_POST['order'])) { foreach ($_POST['order'] as $k => $v) { $orderArr[] = "`{$k}` {$v}"; } $orderStr = implode(',', $orderArr); } //查询操作 $sql = "SELECT * FROM `" . $moduleDB->getTableName() . "` WHERE {$whereStr} ORDER BY {$orderStr}"; $data = $moduleDB->getData($sql, $whereArr, 20); $pageStr = $moduleDB->getPageStr(); $pageJump = $moduleDB->getPageJump(); //读取外键数据 $projectFkArr = ModuleModel::getProject(); $this->setView('projectFkArr', $projectFkArr); $sysmoduleFkArr = ModuleModel::getSysmodule(); $this->setView('sysmoduleFkArr', $sysmoduleFkArr); $onoffArrDictFkArr = DictConfig::$onoffArr; $this->setView('onoffArrDictFkArr', $onoffArrDictFkArr); $monitorFkArr = ModuleModel::getMonitor(); $this->setView('monitorFkArr', $monitorFkArr); //模版显示 $this->setView('pageTitle', '模块'); $this->setView('pageStr', $pageStr); $this->setView('pageJump', $pageJump); $this->setView('data', $data); $this->display('Module.html'); }