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

class Testimonials_m extends MY_Model {
	
	protected $_table_name = 'testimonials';
	protected $_primary_key = 'testimonial_id';
	protected $_order_by = 'updated_at';

	public $rules = array( 
	    array(
            'field'   => 'author',
            'label'   => 'reviewer',
            'rules'   => 'trim|required'
        ),
		array(
            'field'   => 'quotes',
            'label'   => 'quotes',
            'rules'   => 'trim|required'
        ),  
	    array(
            'field'   => 'rating', 
            'label'   => 'rating',
            'rules'   => 'trim|required|numeric' 
        ),
        array(
            'field'   => 'status', 
            'label'   => 'status',
            'rules'   => 'trim|required'
        )       
    );


	function __construct() {
		parent::__construct();	
	}	
	
	//pagination included
	function get_all_testimonials($limit, $start) {
		$this->db->select('*');
		$this->db->from('testimonials');
		$this->db->order_by('testimonial_id');
        $this->db->where('deleted_at', NULL);
		$this->db->limit($limit, $start);
		$query = $this->db->get();		
		return $query->result();
	}

	//function to display new testimonial, where all fields are empty
	public function get_new() {
		$testimonial = new stdClass();
		$testimonial->author = '';
		$testimonial->quotes = '';
		$testimonial->rating = '';	 
		$testimonial->status = '';
		return $testimonial;
	}
	
	//function add new testimony
	function add_testimonial($data) {
		$this->db->insert('testimonials', $data);	
		return $this->db->insert_id();	 
	}
	
	//function edit testimony
	function edit_testimonial($id, $data) {
		$this->db->where('testimonial_id', $id);
		$this->db->update('testimonials', $data);	
	}

    // function to delete testimony
    function delete_testimonial($id) {
        $this->db->where('testimonial_id', $id);
        $this->db->update('testimonials', array('deleted_at' => date('Y-m-d H:i:s')));
    }
	
	//function count all record for testimony
	public function record_count() {
        return $this->db->get('testimonials')->num_rows();
    }

    //function count if existing record exist
	public function count_exist($id) {
        $this->db->select('*');
        $this->db->from('testimonials');
        $this->db->where('testimonial_id', $id);
        $this->db->where('deleted_at', NULL);
        $query = $this->db->get();		
		return $query->num_rows();
    }
	
}