<?php  if (! defined('BASEPATH')) exit('No direct script access allowed');
class Common_model extends CI_Model
{
	function __construct() 
	{
		parent::__construct();
	}
	
	function get_all($table,$where,$order)
	{
		
		
	}
	
	function count_all($table,$where)
	{
		
	}
	
	function get_id($table,$where)
	{
		
	}
	
	function get_where($tbl, $wh='', $value=0, $num=100, $start=0, $order='')
	{
		if($wh) $this->db->where($wh, $value) ;
		if($order) $this->db->order_by($order, 'DESC') ;
		$this->db->where('bl_active', 1) ;
		$query = $this->db->get($tbl, $num, $start);
		return $query->result() ;
	}

	function count_where($tbl, $where='', $id=0)
	{
		if($where) $this->db->where($where, $id) ;
		$this->db->where('bl_active', 1) ;
		$query = $this->db->get($tbl);
		return $query->num_rows() ;
	}
    function select_data($list_fields,$tbl_name,$str_where,$type="obj",$row=false)
    {
        try
        {
            $rs=array();
            $sql = sprintf("SELECT ".(($list_fields!="")?$list_fields:"*")."
                            FROM ". $tbl_name."
                            ".$str_where);
            $query = $this->db->query($sql);
            if($type=="arr")
                if($row)
                    $rs = $query->row_array();
                else
                    $rs	= $query->result_array();
            elseif($type=="obj")
                if($row)
                    $rs = $query->row();
                else
                    $rs = $query->result();

            return $rs;
        }
        catch(Exception $ex)
        {
                return false;
        }
    }
	
    function update_data($tbl_name,$data,$wh_field,$wh_value)
    {
        try{
            $this->db->where($wh_field, $wh_value);
            $rs=$this->db->update($tbl_name, $data);
            return $rs;
        }catch(Exception $ex){
            return false;
        }
    }
	
    function insert_data($tbl_name,$data)
    {
        try{
            $rs=$this->db->insert($tbl_name, $data);
            return $rs;
        }
		catch(Exception $ex)
        {
            return false;
        }
    }
	
    function delete_data($table_name,$arr_where)
    {
        try{
            $rs=$this->db->delete($table_name,$arr_where);
            return $rs;
        }catch(Exception $ex){
            return false;
        }
    }
}
?>