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

class Role_m extends MY_Model {
	
	protected $_table_name = 'role';
	protected $_primary_key = 'id_role';
	protected $_order_by = 'id_role';

	public $rules = array( 
	    array(
	         'field'   => 'role_name',
	         'label'   => 'Role Name',
	         'rules'   => 'trim|required'
	      ),
	    array(
             'field'   => 'module_cek[]',
             'label'   => 'Module',
             'rules'   => 'required'
          ),  
    );


	function __construct() {
		parent::__construct();	
	}	
	
	//pagination included
	function get_all_menus($limit, $start) {
		$this->db->select('*');
		$this->db->from('role');
		$this->db->where('id_role !=', '0');
		$this->db->order_by('role_name');
		$this->db->limit($limit, $start);
		$query = $this->db->get();		
		return $query->result();
	}

	//function count all record for role
	public function record_count() {
        return $this->db->get('role')->num_rows();
    }
	
	//function edit role
	function edit_role($id, $data) {
		$this->db->where('id_role', $id);
		$this->db->update('role', $data);	
	}

	//function to display new menu, where all fields are empty
	public function get_new() {
		$roles = new stdClass();
		$roles->role_name = '';
		$roles->role_itme_name = '';
		return $roles;
	}

	public function add_role($data, $table) {
		$this->db->insert($table, $data);
	}

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

    public function add_role_item($data){
			$this->db->insert('role_item',$data);
		}
}