public static function ClientsFeatured() { global $conn; $dl = new DataLayer($conn->link); $dl->debug = false; $query = "SELECT client_id,client_title,client_brief,client_thumbnail,client_date_submited"; $query .= " FROM "; $query .= "lab_clients"; $conditions = array('client_featured' => "Y"); $order = array('client_order' => "ASC", 'client_title' => "ASC", 'client_date_submited' => "DESC"); $limit = "5"; $fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError()); if (!empty($fun_array[0])) { return $fun_array; } return false; }
public static function ChildServicesList($service_parent_id) { global $conn; $dl = new DataLayer($conn->link); $dl->debug = false; $query = "SELECT service_id,service_parent_id,service_title,service_description,service_date_submited"; $query .= " FROM "; $query .= "lab_services"; $conditions = array('service_parent_id' => $service_parent_id); $order = array('service_order' => "ASC", 'service_title' => "ASC", 'service_date_submited' => "DESC"); $limit = array(); $fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError()); if (!empty($fun_array[0])) { return $fun_array; } return false; }
public static function CategoryList() { global $conn; $dl = new DataLayer($conn->link); $dl->debug = false; $query = "SELECT category_id,category_title"; $query .= " FROM "; $query .= "lab_categories"; $conditions = array(); $order = array('category_title' => "ASC", 'category_id' => "ASC"); $limit = array(); $fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError()); if (!empty($fun_array[0])) { return $fun_array; } return false; }
public static function RightBlocks($page_id) { global $conn; $dl = new DataLayer($conn->link); $dl->debug = false; $query = "SELECT block_id,page_id,block_title,block_has_title,block_content"; $query .= " FROM "; $query .= "lab_blocks"; $conditions = array('block_direction' => "RIGHT", 'page_id' => $page_id); $order = array('block_order' => "ASC"); $limit = array(); $fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError()); if (!empty($fun_array[0])) { return $fun_array; } return false; }
public static function GetSelectedPage($page_id) { global $conn; $dl = new DataLayer($conn->link); $dl->debug = false; $query = "SELECT page.page_id,\r\n\t\t\t\t\t\tpage.control_id, \r\n\t\t\t\t\t\tpage.page_title,\r\n\t\t\t\t\t\tpage.page_description, \r\n\t\t\t\t\t\tpage.page_meta_keyword,\r\n\t\t\t\t\t\tpage.page_meta_description,\r\n\t\t\t\t\t\tcontrol.control_file"; $query .= " FROM "; $query .= "lab_pages as page"; $query .= " LEFT OUTER JOIN "; $query .= "lab_controls as control"; $query .= " ON "; $query .= "page.control_id = control.control_id"; $conditions = array('page.page_id' => $page_id); $order = array(); $limit = "0,1"; $fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError()); if (!empty($fun_array[0])) { return $fun_array; } return false; }
public static function PortfolioDetails($portfolio_id) { global $conn; $dl = new DataLayer($conn->link); $dl->debug = false; $query = "SELECT port.portfolio_id,port.category_id,cat.category_title,port.portfolio_title,port.portfolio_brief,port.portfolio_thumbnail,port.portfolio_image,port.portfolio_date_submited"; $query .= " FROM "; $query .= "lab_portfolios as port"; $query .= " INNER JOIN "; $query .= "lab_categories as cat"; $query .= " ON "; $query .= "port.category_id = cat.category_id"; $conditions = array('portfolio_id' => $portfolio_id); $order = array(); $limit = array(1); $fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError()); if (!empty($fun_array[0])) { return $fun_array; } return false; }