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

class MY_Model extends CI_Model {
	
	//the variables we use for generic CRUD 
	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';		
		}
		
		/* if(!count($this->db->qb_orderby)) {
			$this->db->order_by($this->_order_by);
		} */

		$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);
	}
	
}