/home/hdwebsolution/www/sareenn/application/helpers/default_helper.php
<?php
function admin_login(){
$ci =& get_instance();
$id = $ci->session->userdata('id');
$ci->db->select("*");
$ci->db->from("tbl_admin");
$ci->db->where("id",$id);
return $ci->db->get()->row();
}
function getdata($table){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where('status','1');
return $ci->db->get($table)->result();
}
function getdatalimitquery1($table,$where,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($where);
$ci->db->order_by('id','asc');
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatalimitquery($table,$where,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($where);
$ci->db->order_by('id','Desc');
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatadesc($table,$array){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->Order_by('id','Desc');
$ci->db->where($array);
return $ci->db->get($table)->result();
}
function getdatadesc22($table){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->Order_by('id','Desc');
return $ci->db->get($table)->row();
}
function getdatanostatus($table){
$ci =& get_instance();
$ci->db->select("*");
return $ci->db->get($table)->result_array();
}
function getdatabyslug($table,$array){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
return $ci->db->get($table)->result();
}
function getdatabyslugorder($table,$array,$order,$value){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by($order,$value);
return $ci->db->get($table)->result();
}
function getdatabyslugorderlimit($table,$array,$order,$value,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by($order,$value);
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatabyslugbitween($table,$from,$to){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where("perm_age BETWEEN '$from' AND '$to'");
return $ci->db->get($table)->result();
}
function getdatabyslugnostatus($table,$array){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
return $ci->db->get($table)->result();
}
function getdatasingle($table,$array){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
return $ci->db->get($table)->row();
}
function getdatasingledes($table){
$ci =& get_instance();
$ci->db->select("*");
//$ci->db->where($array);
$ci->db->order_by('id',"Desc");
return $ci->db->get($table)->row();
}
function getdataorderby($table,$array,$name,$order){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by($name,$order);
return $ci->db->get($table)->result();
}
function getdatasingledesarray($table,$array){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by('id',"Desc");
return $ci->db->get($table)->result();
}
function getdatasingleno($table){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where('status','1');
return $ci->db->get($table)->row();
}
function getdatabyslug_limit($table,$array,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by('id',"Desc");
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatabyslugasc_limit($table,$array,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
//$ci->db->order_by('id',"Desc");
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatabyslugasc1_limit($table,$array,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by('id',"Desc");
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatabyslugascsingle_limit($table,$array,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
//$ci->db->order_by('id',"Desc");
$ci->db->limit($start,$end);
return $ci->db->get($table)->row();
}
function descdata($table,$array){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->order_by('id',"Desc");
return $ci->db->get($table)->row();
}
function getdatalike_order1($table,$array,$field,$id,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->like($field,$id);
$ci->db->limit($start,$end);
return $ci->db->get($table)->result();
}
function getdatalike_order12($table,$array,$field,$id,$start,$end){
$ci =& get_instance();
$ci->db->select("*");
$ci->db->where($array);
$ci->db->like($field,$id);
$ci->db->limit($start,$end);
return $ci->db->get($table)->row();
}
function offers(){
/*$array=array(
array('id'=>'1','name'=>'ON SALE PRODUCTS'),
array('id'=>'2','name'=>'HOT PRODUCTS'),
array('id'=>'3','name'=>'TOP VIEWED'),
);*/
$array=array(
array('id'=>'1','name'=>'Most Popular'),
array('id'=>'2','name'=>'Best Sellers'),
array('id'=>'3','name'=>'Latest Items'),
//array('id'=>'2','name'=>'Best Seller'),
//array('id'=>'3','name'=>'Most Popular'),
//array('id'=>'4','name'=>'Featured'),
);
return $array;
}
function footer_tags(){
$array=array(
array('id'=>'1','name'=>'POPULAR'),
array('id'=>'2','name'=>'NEW ARRIVALS'),
array('id'=>'3','name'=>'SPECIALS'),
array('id'=>'4','name'=>'ON SALE'),
array('id'=>'5','name'=>'TOP RATED'),
);
return $array;
}
function websitesetting(){
$array = array(
"select" => array(
array('id'=>'1','name'=>'Live'),
array('id'=>'2','name'=>'Demo'),
array('id'=>'3','name'=>'Suspend'),
array('id'=>'12','name'=>'Bandwidth Exceeded'),
),
"checkbox" => array(
array('id'=>'4','name'=>'Brand'),
array('id'=>'5','name'=>'Blogs'),
array('id'=>'6','name'=>'Coupon'),
array('id'=>'7','name'=>'Testimonials'),
array('id'=>'8','name'=>'Tracking'),
array('id'=>'9','name'=>'Reating'),
array('id'=>'10','name'=>'Location'),
array('id'=>'11','name'=>'User'),
array('id'=>'13','name'=>'Category'),
array('id'=>'14','name'=>'Sub Category'),
array('id'=>'15','name'=>'Child Category'),
array('id'=>'16','name'=>'Color'),
array('id'=>'17','name'=>'Size'),
),
"order_status" => array(
array('id'=>'0','name'=>'Pending'),
array('id'=>'1','name'=>'User Cancel'),
array('id'=>'2','name'=>'Merchant Cancel'),
array('id'=>'3','name'=>'Process'),
array('id'=>'4','name'=>'Shipping'),
array('id'=>'5','name'=>'Return'),
),
"user_status" => array(
array('id'=>'1','name'=>'Show'),
array('id'=>'0','name'=>'hidden'),
array('id'=>'2','name'=>'Suspended'),
),
);
return $array;
}
?>