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; }
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); }
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); }
function check_password($name, $password) { return parent::get_one(array('name' => $name, 'password' => $password)); }
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); }
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); }