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



class Activity_m extends MY_Model {

	

	protected $_table_name = 'activity';

	protected $_primary_key = 'id'; 

	protected $_order_by = 'id';



	public $rules = array(  

        array(

             'field'   => 'activity', 

             'label'   => 'Activity Name',

             'rules'   => 'trim|required|callback__cek_existing_activity_title'

        ),

		array(

             'field'   => 'status', 

             'label'   => 'status',

             'rules'   => 'trim|required'

        ),

        array(

             'field'   => 'description',

             'label'   => 'description',

             'rules'   => 'trim'

        ),     

		 array(

             'field'   => 'author',

             'label'   => 'author',

             'rules'   => 'trim'

        ),  

		 array(

             'field'   => 'publish_date',

             'label'   => 'publish date',

             'rules'   => 'trim|required'

        ),    

       

    );



	function __construct() {

		parent::__construct();	

	}	

	

	//pagination included

	function get_all_blog($limit, $start) {

		$this->db->select('*');

		$this->db->from('blog');

		$this->db->order_by('publish_date', 'DESC');

		$this->db->limit($limit, $start);

		$query = $this->db->get();		

		return $query->result();

	}



	//function to display new blog, where all fields are empty

	public function get_new() {

		$activity = new stdClass();

		$activity->activity 	= '';	

		$activity->status 		= '';	

		$activity->description 	= '';	

		$activity->priority 	= '';	

		$activity->author 		= '';	

		$activity->publish_date = '';	

		

		return $activity;

	}



	//get all blog 

	function get_blog() {

		$this->db->select('*');

		$this->db->from('activity');

		$this->db->order_by('id asc');

		$query = $this->db->get();		

		return $query->result();

	}

	

	//function add new blog

	function add_activity($data) {

		$this->db->insert('activity', $data);	

		return $this->db->insert_id();	 

	}

	

	//function edit blog

	function edit_activity($id, $data) {

		$this->db->where('id', $id);

		$this->db->update('activity', $data);	

	}

	

	//function count all record for blog

	public function record_count() {

        return $this->db->get('activity')->num_rows();

    }



    //function count if existing record exist

	public function count_exist($id) {

        $this->db->select('*');

        $this->db->from('activity');

        $this->db->where('id', $id);

        $query = $this->db->get();		

		return $query->num_rows();

    }



	//cek if blog title already exist

	public function cek_existing_activity_title($str, $id) {



		$this->db->select('id');

		$this->db->from('activity');

		$this->db->where('activity', $str);

		if ($id != NULL) {

			$this->db->where('id !=', $id);	

		} 

		$query = $this->db->get();

		return $query->num_rows();

	}



}