Example #1
0
 function test($name)
 {
     $this->table = LZ_MYSQL_PREFIX . 'item';
     $data = parent::query("SELECT * FROM `lz_item` WHERE `name` like '" . $name . "%' ORDER BY user_id DESC;");
     var_dump($data);
     $this->table = LZ_MYSQL_PREFIX . 'user';
     return $data;
 }
Example #2
0
 function get_list($data = array())
 {
     if (isset($data['status'])) {
         !$data['where'] && ($data['where'] = ' 1=1 ');
         $data['where'] .= " AND status IN ({$data['status']}) ";
         unset($data['status']);
     } else {
         $data['status'] = '1';
     }
     !$data['order'] && ($data['order'] = "order_id DESC,time DESC");
     return parent::get_list($data);
 }
Example #3
0
 function get_list($data = array())
 {
     if ($data['category_id'] == 0) {
         unset($data['category_id']);
     }
     if (isset($data['status'])) {
         !$data['where'] && ($data['where'] = ' 1=1 ');
         $data['where'] .= " AND status IN ({$data['status']}) ";
         unset($data['status']);
     } else {
         $data['status'] = '1';
     }
     if ($data['with_children_category']) {
         include_once LZ_BASEPATH . '/model/category.php';
         if ($data['category_id']) {
             $category = new LZ_Category();
             $tree = $category->tree_category($data['category_id']);
             $arr = array();
             $category->flat_tree($tree, $arr);
             $ids = array();
             foreach ($arr as $_arr) {
                 $ids[] = $_arr['category_id'];
             }
             $ids[] = $data['category_id'];
             if ($data['where']) {
                 $data['where'] .= ' AND ';
             }
             $data['where'] .= ' category_id IN (' . join(',', $ids) . ')';
         }
         unset($data['with_children_category']);
         unset($data['category_id']);
     }
     if (LZ_MODULE == 'admin' && $_SESSION['login_user']['rights']['limit_category_id'] && $_SESSION['login_user']['allowed_categories']) {
         $data['where'] && ($data['where'] .= ' AND ');
         $data['where'] .= 'category_id IN (' . $_SESSION['login_user']['allowed_categories'] . ')';
     }
     !$data['order'] && ($data['order'] = "order_id DESC,publish_time DESC");
     return parent::get_list($data);
 }
Example #4
0
 function check_password($name, $password)
 {
     return parent::get_one(array('name' => $name, 'password' => $password));
 }
Example #5
0
 function get_list($data = array())
 {
     if (LZ_MODULE == 'admin' && $_SESSION['login_user']['rights']['limit_category_id'] && $_SESSION['login_user']['allowed_categories']) {
         $data['where'] && ($data['where'] .= ' AND ');
         $data['where'] .= 'category_id IN (' . $_SESSION['login_user']['allowed_categories'] . ')';
     }
     return parent::get_list($data);
 }
Example #6
0
 function get_prev_next($curCid = "")
 {
     $map = "SELECT category_id FROM `lz_category` WHERE parent_id=1 AND status=1 ORDER BY category_id desc limit 1";
     if (isset($curCid)) {
         $map = $map = "SELECT * FROM `lz_category` WHERE parent_id=1 AND category_id=" . $curCid . " AND status=1 ORDER BY category_id DESC  LIMIT 1";
     }
     $lastestId = parent::query($map);
     $lastestId = $lastestId[0]['category_id'];
     $prevId = parent::query("SELECT * FROM `lz_category` where `category_id`<" . $lastestId . "  and `parent_id`=1 and `status`=1 order by `category_id` desc limit 1");
     $prevId = $prevId[0]['category_id'];
     $nextId = parent::query("SELECT * FROM `lz_category` where `category_id`>" . $lastestId . "  and `parent_id`=1 and `status`=1 order by `category_id` asc limit 1");
     $nextId = $nextId[0]["category_id"];
     return array("prev" => $prevId, "cur" => $lastestId, "next" => $nextId);
 }