<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class MY_Model extends CI_Model 
{	
		protected $_table_name = '';
		protected $_primary_key = 'id';
		protected $_primary_filter = 'intval';
		protected $_order_by = '';
		public $_rules = array();
		protected $_timestamps = FALSE;
	
		function __construct() 
		{
				parent::__construct();	
		}
	
		public function array_from_post($fields) 
		{
				$data = array();
				foreach($fields as $field) 
				{
						$data[$field] = $this->input->post($field);		
				}
				return $data;
		}
	
		//Generic function to get all datas, or to get datas by id
		function get($id = NULL, $single = NULL) 
		{
				if($id != NULL) 
				{
						$filter = $this->_primary_filter;
						$id = $filter($id);	
						$this->db->where($this->_primary_key, $id);
						$method = 'row';
				} 
				elseif($single == TRUE) 
				{
					$method = 'row';		
				}
				else 
				{
					$method = 'result';		
				}
				
				$this->db->order_by($this->_order_by);
				
				return $this->db->get($this->_table_name)->$method();
		}
	
		//generic function get by where...
		function get_by($where, $single = FALSE) 
		{
				$this->db->where($where);
				return $this->get(NULL, $single);		
		}
	
		//generic function for save (create or update)
		function save($data, $id = NULL) 
		{
				//if timestamps is true
				if($this->_timestamps == TRUE) 
				{
						$now = date('Y-m-d H:i:s');	
						$id || $data['created'] = $now;
						$data['modified'] = $now;
				}

				//insert
				if($id === NULL) 
				{
						!isset($data[$this->_primary_key]) || $data[$this->_primary_key] = NULL;
						$this->db->set($data);
						$this->db->insert($this->_table_name);	
						$id = $this->db->insert_id();	
				}
				//update	
				else 
				{
					$filter = $this->_primary_filter;
					$id = $filter($id);
					$this->db->set($data);
					$this->db->where($this->_primary_key, $id);
					$this->db->update($this->_table_name);
				}

				return $id;
		}
	
		//generic function for delete
		function delete($id) 
		{
				$filter = $this->_primary_filter;
				$id = $filter($id);	
				
				if(!$id) 
				{
					return FALSE;	
				}
				
				$this->db->where($this->_primary_key, $id);
				$this->db->limit(1);
				$this->db->delete($this->_table_name);
		}
}