public static function Insert(ContactsDetails $c)
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$lab_contacts = array('contact_name' => $c->_contact_name, 'contact_email' => $c->_contact_email, 'contact_type' => $c->_contact_type, 'contact_company' => $c->_contact_company, 'contact_title' => $c->_contact_title, 'contact_subject' => $c->_contact_subject, 'contact_message' => $c->_contact_message, 'contact_date_submited' => $c->_contact_date_submited);
$dl->insert("lab_contacts", $lab_contacts) or die($dl->getError());
$val_array = array("id" => $dl->inserted(""));
return $val_array;
}
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;
}
