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'));
 }
Beispiel #3
0
 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');
 }
Beispiel #4
0
 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);
 }