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

class Home_slideshow_m extends MY_Model 
{	
		protected $_table_name = 'home_slideshow';
		protected $_primary_key = 'id_home_slideshow';
		protected $_order_by = 'id_home_slideshow'; 

		function __construct() 
		{
				parent::__construct();	
		}	
	
		//pagination included
		function get_all_home_slideshow($limit, $start) 
		{
				$this->db->select('*');
				$this->db->from('home_slideshow');
				$this->db->order_by('type', 'ASC');
				$this->db->order_by('priority', 'ASC');
				$this->db->limit($limit, $start);
				$query = $this->db->get();		
				return $query->result();
		}

		//function to display new home center banners, where all fields are empty
		public function get_new() 
		{
				$home_slideshow = new stdClass();
				$home_slideshow->title = '';
				$home_slideshow->image = '';	
				$home_slideshow->type = '';	
				$home_slideshow->priority = ''; 
				$home_slideshow->status = '';
				$home_slideshow->button_link = '';
				$home_slideshow->button_label = '';
				$home_slideshow->text_content = '';
				return $home_slideshow;
		}

		//function count all record for home center banners
		public function record_count() 
		{
        return $this->db->get('home_slideshow')->num_rows();
    }

    //function add new
		function add_home_slideshow($data) 
		{
				$this->db->insert('home_slideshow', $data);	
				return $this->db->insert_id();	 
		}

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

    //function edit 
		function edit_home_slideshow($id, $data) 
		{
				$this->db->where('id_home_slideshow', $id);
				$this->db->update('home_slideshow', $data);	
		}
}