<?php
class M_ruangan extends CI_Model {

    function index() {
        $query = $this->db->get('master_ruang');
        return $query->result();
    }
    
    function status() {
        $this->db->where('mr_status', 1);
        $query = $this->db->get('master_ruang');
        return $query->result();
    }
    
    function pelayanan($pel) {
        $this->db->where('mr_status', 1);
        $this->db->where('mr_pelayanan', $pel);
        $query = $this->db->get('master_ruang');
        return $query->result();
    }
    
    function insert() {
        $insert = array(
            'mr_nama'       => $this->input->post('nama'),
            'mr_kode'       => $this->input->post('kode'),
            'mr_status'     => $this->input->post('status'),
            'mr_pelayanan'  => $this->input->post('pelayanan'),
        );
        $insert = $this->db->insert('master_ruang', $insert);
    }
    
    function edit($id) {
        $this->db->where('mr_id', $id);
        $query = $this->db->get('master_ruang');
        return $query;
    }
    
    function prosesedit() {
        $update = array(
            'mr_nama'       => $this->input->post('nama'),
            'mr_kode'       => $this->input->post('kode'),
            'mr_status'     => $this->input->post('status'),
            'mr_pelayanan'  => $this->input->post('pelayanan'),
        );
        $id = $this->input->post('id');
        $this->db->where('mr_id', $id);
        $this->db->update('master_ruang', $update);
    }

    function delete($id) {
        $this->db->where('mr_id', $id);
        $this->db->delete('master_ruang');
    }
    
    function disabled($id) {
        $update_data = array(
            'mr_status'    => 0,
        );
        $this->db->where('mr_id', $id);
        $this->db->update('master_ruang', $update_data);
    }
    
    function aktif($id) {
        $update_data = array(
            'mr_status'    => 1,
        );
        $this->db->where('mr_id', $id);
        $this->db->update('master_ruang', $update_data);
    }
}
?>