function addListObjectID($data, $type = "news") { global $sys_config; $key = "{$type}-listcontent"; if (!isset($sys_config[$key])) { $sys_config[$key] = array(); } if (is_array($data)) { // du lieu la mang if (isset($data["id"])) { //1 chieu addObjectID($data["id"], $type); } else { foreach ($data as $item) { if (is_object($item)) { //mang cac doi tuong if (isset($item->id)) { addObjectID($item->id, $type); } } else { if (is_array($item)) { //mang 2 chieu if (isset($item["id"])) { addObjectID($item["id"], $type); } } } } } } else { if (is_object($data)) { // du lieu la doi tuong if (isset($data->id)) { addObjectID($data->id, $type); } } else { addObjectID($data, $type); } } return count($sys_config[$key]); }
function getItems($catID = null, $feature = 0, $limit = 10, $start = 0) { // filter_order, filter_order_Dir, limit, limitstart $filter_order = Request::getVar('filter_order', 'viewed'); $filter_order_Dir = Request::getVar('filter_order_Dir', 'DESC'); $command = Yii::app()->db->createCommand(); $command->limit($limit, $start); $command->order("{$filter_order} {$filter_order_Dir}"); $where = array(); $where[] = "B.id = {$catID}"; if ($feature == 1) { $where[] = "A.feature = 1"; } $command->where(implode(" AND ", $where)); $items = $command->select('A.*,B.title as cat_name,B.alias as cat_alias')->from("{$this->table} A")->join("{$this->table_categories} B", 'A.catID=B.id')->queryAll(); if (count($items)) { foreach ($items as &$item) { $params = array("view" => "detail", "id" => $item['id'], "alias" => $item['alias'], "catID" => $item['catID'], "cat_alias" => $item['cat_alias']); $item['link'] = Router::buildLink('videos', $params); addObjectID($item['id'], "videos"); } } return $items; }
function getVideoCategoy($catID, $start = 0, $limit = 10) { global $mainframe, $db; $list_ids = getListObjectID("videos"); $where = array(); $where[] = "A.status = 1"; $where[] = "B.status = 1"; $where[] = "A.catID = {$catID} "; if ($list_ids != false and $list_ids != "") { $where[] = "A.id not in({$list_ids})"; } $where = implode(" AND ", $where); $query = "SELECT A.*, B.alias cat_alias, B.title cat_title " . "FROM " . TBL_VIDEOS . " A LEFT JOIN " . TBL_CATEGORIES . " B ON A.catID = B.id " . " WHERE {$where} " . " ORDER BY A.cdate DESC LIMIT {$start}, {$limit}"; $query_command = $db->createCommand($query); $items = $query_command->queryAll(); if (count($items)) { foreach ($items as &$item) { $params = array("view" => "detail", "id" => $item['id'], "alias" => $item['alias'], "catID" => $item['catID'], "cat_alias" => $item['cat_alias']); $item['link'] = Router::buildLink('videos', $params); addObjectID($item['id'], "video"); } } return $items; }
function getItem($cid, $alias = null) { global $mainframe, $db; $where = array(); $where[] = "A.status = 1"; $where[] = "B.status = 1"; if (intval($cid) != 0) { $where[] = " A.id = {$cid}"; } else { $where[] = " A.alias = '{$alias}'"; } $where = implode(" AND ", $where); $query_command = Yii::app()->db->createCommand(); $query_command->select("A.*, B.alias cat_alias, B.title cat_title")->from($this->tablename . " A")->leftJoin($this->tbl_category . " B", "A.catID = B.id")->where($where); $item = $query_command->queryRow(); if ($item == FALSE) { return false; } $params = array("view" => "category", "id" => $item['catID'], "alias" => $item['cat_alias']); $item['cat_link'] = Router::buildLink('articles', $params); $params = array("view" => "detail", "id" => $item['id'], "alias" => $item['alias'], "catID" => $item['catID'], "cat_alias" => $item['cat_alias']); $item['link'] = Router::buildLink('articles', $params); addObjectID($item['id'], "articles"); return $item; }