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

class Home_footer_m extends MY_Model
{

	protected $_table_name = 'home_footer';
	protected $_primary_key = 'id_home_footer';
	protected $_order_by = 'id_home_footer';


	function __construct()
	{
		parent::__construct();
	}

	//pagination included
	function get_all_home_footer($limit, $start)
	{
		$this->db->select('*');
		$this->db->from('home_footer');
		$this->db->order_by('priority', 'ASC');
		$this->db->limit($limit, $start);
		$query = $this->db->get();
		return $query->result();
	}

	//function to display new home left banners, where all fields are empty
	public function get_new()
	{
		$home_footer = new stdClass();
		$home_footer->title = '';
		$home_footer->display_title = '';
		$home_footer->description = '';
		$home_footer->more_description = '';
		$home_footer->image = '';
		$home_footer->priority = '';
		$home_footer->status = '';
		$home_footer->banner_link = '';
		return $home_footer;
	}

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

	//function add new brand
	function add_home_footer($data)
	{
		$this->db->insert('home_footer', $data);
		$user_id = $this->session->userdata('admin')['id'];
		$activity = 'User menambah home footer (' . $data['title'] . ')';

		log_activity($user_id, $activity);
		return $this->db->insert_id();
	}

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

	//function edit 
	function edit_home_footer($id, $data)
	{
		$this->db->where('id_home_footer', $id);
		$this->db->update('home_footer', $data);
		$user_id = $this->session->userdata('admin')['id'];
		$activity = 'User mengedit home footer (' . $data['title'] . ')';

		log_activity($user_id, $activity);
	}
}