function Query() { $queryFilter = queryFilter(); $querySort = querySort(); $query = 'SELECT * FROM archi' . $queryFilter . $querySort; $monsters = getMonsters($query); return $monsters; }
public function index() { $data = $this->_post('query'); if (!empty($data)) { $data = queryFilter($data); $type = "query"; } $M = M('Backup'); $select = $M->where($data)->join()->order(); R('Comm/Comm/page', array($select, null, 'null')); }
public function index() { $condition = $this->_param('query'); if (!empty($condition)) { $condition = queryFilter($condition); } $M = M(MODULE_NAME); $condition['is_deleted'] = '0'; $select = $M->where()->join()->order(); $this->page($select, $condition, 'menu'); }
public function index() { $condition = $this->_param('query'); if (!empty($condition)) { $query = C("query." . MODULE_NAME); foreach ($query as $key => $v) { switch ($v['query_type']) { case 'eq': $map[$key] = array($v['query_type'], $condition[$key]); break; case 'like': $map[$key] = array($v['query_type'], '%' . $condition[$key] . '%'); break; case 'between': $map[$key] = array($v['query_type'], $condition[$key] . ',' . $condition[$key . '_1']); break; } } $map = queryFilter($map); } else { $condition = $this->_param('pill'); if (!empty($condition)) { $para = explode('&', urldecode($condition)); foreach ($para as $key => $v) { $cond = explode('=', $v); if (count($cond) === 2) { $map[$cond[0]] = $cond[1]; } } } } $M = D(MODULE_NAME); $condition['is_deleted'] = '0'; $select = $M->scope('default')->join()->where($map)->order(); $this->page($select, $map); }