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

class Mdepartment extends CI_Model {

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

    }

    public function get_department(){
        $this->db->select('a.*,1 department_count');
        $this->db->from('master_department a');
        $this->db->where('status <>','2');
        $this->db->order_by('department_id','desc');
		/*$this->db->group_by('department_name');*/
        $query=$this->db->get();
        return $query->result_array();
    }

    public function submit_department($data){
        $this->db->insert('master_department', $data);
        return $this->db->insert_id();
    }

    public function edit_department($department_id){
        $this->db->select('department_id,department_name,department_code,status');
        $this->db->from('master_department');
		$this->db->where('department_id',$department_id);
        $query=$this->db->get();
        return $query->row_array();
    }

    public function update_department($condition,$data){
        $result=$this->db->update('master_department', $data, $condition);
        return $result;
    }

    public function delete_department($condition,$data){
        $result=$this->db->update('master_department', $data, $condition);
        return $result;
    }
}