/home/hdwebsolution/public_html/sareen-1/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;
  }
	

?>