public function view() { $answerDB = new AnswerModelDB(); //普通条件,检查GET参数 $fieldArr = $answerDB->getFields(); $where = $whereArr = array(); foreach ($fieldArr as $v) { if (array_key_exists($v, $_GET) && $_GET[$v] !== null) { $where[] = "`{$v}` = ?"; $whereArr[] = $_GET[$v]; } } $whereStr = count($where) > 0 ? implode(" AND ", $where) : '1=1'; if (array_key_exists('_search_field', $_GET) && $_GET['_search_field'] != '' && in_array($_GET['_search_field'], $fieldArr, true) && array_key_exists('_search_keyword', $_GET) && $_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 `" . $answerDB->getTableName() . "` WHERE {$whereStr} ORDER BY {$orderStr}"; $data = $answerDB->getData($sql, $whereArr, 20); $pageStr = $answerDB->getPageStr(); //读取外键数据 $resultDB = new ResultModelDB(); $questionDB = new QuestionModelDB(); $questionList = $questionDB->getQuestionList($_GET['vote_id']); $resultList = $resultDB->getResultList($_GET['vote_id']); $this->setView('questionList', $questionList); $this->setView('resultList', $resultList); $this->setView('vote_id', $_GET['vote_id']); $this->setView('question_id', $_GET['question_id']); //模版显示 $this->setView('pageStr', $pageStr); $this->setView('data', $data); $this->display('Answer.html'); }
public function logicResume() { $questionDB = new QuestionModelDB(); $updateArr = array('' => 0); $whereArr = array(); $whereArr['id'] = $_GET['id']; $rs = $questionDB->update($updateArr, $whereArr); Log::write($this->adminUserName, $this->ip, $_GET['id'], self::$controller . "__" . self::$action, $rs); $rs ? Message::showSucc('恢复成功') : Message::showError('恢复失败:' . implode(" ", $questionDB->getErrorInfo())); }