<?php
class M_resume extends CI_Model {

    function index() {
        $query = '
            SELECT pr_id,pr_diagnosa,pr_tindakan,pr_keterangan,pr_date_resume,pr_status,pr_jenis_pelayanan,
                udok.mu_id	 		      AS dok_id, 
                udok.mu_nama_lengkap 	  AS dok_nama, 
                
                masp.ms_nama 		      AS sp_nama, 
                masp.ms_kode              AS sp_kode, 
                
                upas.mu_id 			      AS pas_id,
                upas.mu_nama_lengkap 	  AS pas_nama,
                upas.mu_no_rekamedik	  AS pas_rm,
                upas.mu_NIK 		      AS pas_nik,
                upas.mu_alamat_KTP 		  AS pas_alamat,
                upas.mu_alamat_domisili	  AS pas_domisili,
                upas.mu_telepon_1		  AS pas_telp1,
                upas.mu_telepon_2		  AS pas_telp2,
                upas.mu_tanggal_lahir	  AS pas_tgl_lahir,
                upas.mu_gol_darah		  AS pas_gd,
                upas.mu_berat_badan		  AS pas_bb,
                upas.mu_tinggi_badan	  AS pas_tb,
                upas.mu_warna_kulit		  AS pas_wk,
                upas.mu_jenis_kelamin	  AS pas_jk,
                upas.mu_gambar	          AS pas_gambar,
                
                ruang.mr_kode		      AS ru_id,
                ruang.mr_kode		      AS ru_kode,
                ruang.mr_nama		      AS ru_nama
            
            FROM proses_resume 
            
            LEFT JOIN master_user         AS udok 	ON (udok.mu_id=pr_user_dokter_id)
            LEFT JOIN master_user         AS upas 	ON (upas.mu_id=pr_user_pasien_id)
            LEFT JOIN master_spesialis    AS masp	ON (masp.ms_id=pr_spesialis_id)
            LEFT JOIN master_ruang        AS ruang  ON (ruang.mr_id=pr_ruang_id)
            
            WHERE pr_date_resume LIKE "%'.date("Y-m-d").'%"
            ';
             $result = $this->db->query($query);

        return $result->result();
    }
    
    function search() {
        if(! $this->input->post('reservation')){
            $date1 = date("Y-m-d");
            $date2 = date("Y-m-d");
        }else{
            $datemya    = explode("-",$this->input->post('reservation'));
            $date1      = date("Y-m-d", strtotime($datemya[0]));
            $date2      = date("Y-m-d", strtotime($datemya[1]));
        }
        
        $spesialis      = "";
        if($this->input->post('spesialis')!="0"){
            $spesialis  = 'AND pr_spesialis_id = "'.$this->input->post('spesialis').'"';    
        }
        $query = '
            SELECT pr_id,pr_diagnosa,pr_tindakan,pr_keterangan,pr_date_resume,pr_status,pr_jenis_pelayanan,pr_user_dokter_id,pr_spesialis_id,
                udok.mu_id	 		      AS dok_id, 
                udok.mu_nama_lengkap 	  AS dok_nama, 
                
                masp.ms_nama 		      AS sp_nama, 
                masp.ms_kode              AS sp_kode, 
                
                upas.mu_id 			      AS pas_id,
                upas.mu_nama_lengkap 	  AS pas_nama,
                upas.mu_no_rekamedik	  AS pas_rm,
                upas.mu_NIK 		      AS pas_nik,
                upas.mu_alamat_KTP 		  AS pas_alamat,
                upas.mu_alamat_domisili	  AS pas_domisili,
                upas.mu_telepon_1		  AS pas_telp1,
                upas.mu_telepon_2		  AS pas_telp2,
                upas.mu_tanggal_lahir	  AS pas_tgl_lahir,
                upas.mu_gol_darah		  AS pas_gd,
                upas.mu_berat_badan		  AS pas_bb,
                upas.mu_tinggi_badan	  AS pas_tb,
                upas.mu_warna_kulit		  AS pas_wk,
                upas.mu_jenis_kelamin	  AS pas_jk,
                upas.mu_gambar	          AS pas_gambar,
                
                ruang.mr_kode		      AS ru_id,
                ruang.mr_kode		      AS ru_kode,
                ruang.mr_nama		      AS ru_nama
            
            FROM proses_resume 
            
            LEFT JOIN master_user         AS udok 	ON (udok.mu_id=pr_user_dokter_id)
            LEFT JOIN master_user         AS upas 	ON (upas.mu_id=pr_user_pasien_id)
            LEFT JOIN master_spesialis    AS masp	ON (masp.ms_id=pr_spesialis_id)
            LEFT JOIN master_ruang        AS ruang  ON (ruang.mr_id=pr_ruang_id)
            
            WHERE pr_date_resume between "'.$date1.' 00:00:00" AND "'.$date2.' 23:59:59"
            
            '.$spesialis.'
            
            ';
             $result = $this->db->query($query);

        return $result->result();
    }
    
    function status_petugas() {
        $this->db->join('master_user', 'master_tipeuser.mt_id = master_user.mu_tipeuser_id','left');
        $this->db->where('pr_status', 1);
        $query = $this->db->get('proses_resume');
        return $query->result();
    }
    
    function status_dokter() {
        $this->db->where('pr_status', 2);
        $query = $this->db->get('proses_resume');
        return $query->result();
    }
    
    function insert_petugas() {
        $originalDate = $this->input->post('tanggal');
        $originalTime = $this->input->post('waktu');
        $newDate = date("Y-m-d", strtotime($originalDate));
        $newTime = date("H:i:s", strtotime($originalTime));
        $datetime = $newDate." ".$newTime;
        
        $insert = array(
            'pr_user_pasien_id' => $this->input->post('pasien'),
            'pr_ruang_id'       => $this->input->post('ruang'),
            'pr_spesialis_id'   => $this->input->post('spesialis'),
            'pr_date_resume'    => $datetime,
            'pr_status'         => "1",
            'pr_jenis_pelayanan'=> $this->input->post('pelayanan'),
        );
        $insert = $this->db->insert('proses_resume', $insert);
    }
    
    function edit_petugas($id) {
            $query = '
            SELECT pr_id,pr_diagnosa,pr_tindakan,pr_keterangan,pr_date_resume,pr_status,pr_user_pasien_id,pr_ruang_id,pr_spesialis_id,pr_jenis_pelayanan,
                udok.mu_id	 		      AS dok_id, 
                udok.mu_nama_lengkap 	  AS dok_nama, 
                
                udpjp.mu_id	 		      AS dpjp_id, 
                udpjp.mu_nama_lengkap 	  AS dpjp_nama, 
                
                masp.ms_nama 		      AS sp_nama, 
                masp.ms_kode              AS sp_kode, 
                
                upas.mu_id 			      AS pas_id,
                upas.mu_nama_lengkap 	  AS pas_nama,
                upas.mu_no_rekamedik	  AS pas_rm,
                upas.mu_NIK 		      AS pas_nik,
                upas.mu_alamat_KTP 		  AS pas_alamat,
                upas.mu_alamat_domisili	  AS pas_domisili,
                upas.mu_telepon_1		  AS pas_telp1,
                upas.mu_telepon_2	      AS pas_telp2,
                upas.mu_tanggal_lahir	  AS pas_tgl_lahir,
                upas.mu_gol_darah		  AS pas_gd,
                upas.mu_berat_badan		  AS pas_bb,
                upas.mu_tinggi_badan	  AS pas_tb,
                upas.mu_warna_kulit		  AS pas_wk,
                upas.mu_jenis_kelamin	  AS pas_jk,
                upas.mu_gambar	          AS pas_gambar,
                
                ruang.mr_kode		      AS ru_id,
                ruang.mr_kode		      AS ru_kode,
                ruang.mr_nama		      AS ru_nama,
                
                spdok.ms_nama 		      AS spdok_nama, 
                spdok.ms_kode             AS spdok_kode,
                
                spdpjp.ms_nama 		      AS spdpjp_nama, 
                spdpjp.ms_kode            AS spdpjp_kode
            
            FROM proses_resume 
            
            LEFT JOIN master_user         AS udok 	ON (udok.mu_id=pr_user_dokter_id)
            LEFT JOIN master_user         AS upas 	ON (upas.mu_id=pr_user_pasien_id)
            LEFT JOIN master_user         AS udpjp 	ON (udpjp.mu_id=pr_user_dokter_dpjp_id)
            LEFT JOIN master_ruang        AS ruang  ON (ruang.mr_id=pr_ruang_id)
                        
            LEFT JOIN master_spesialis    AS masp	ON (masp.ms_id=pr_spesialis_id)
            LEFT JOIN master_spesialis    AS spdok	ON (spdok.ms_id=udok.mu_spesialis_id)
            LEFT JOIN master_spesialis    AS spdpjp	ON (spdpjp.ms_id=udpjp.mu_spesialis_id)
            
            WHERE pr_id = '.$id.'
            ';
             $result = $this->db->query($query);
             return $result;
    }
    
    function proseseditpetugas() {
        $originalDate = $this->input->post('tanggal');
        $originalTime = $this->input->post('waktu');
        $newDate = date("Y-m-d", strtotime($originalDate));
        $newTime = date("H:i:s", strtotime($originalTime));
        $datetime = $newDate." ".$newTime;
        
        $update = array(
            'pr_user_pasien_id' => $this->input->post('pasien'),
            'pr_ruang_id'       => $this->input->post('ruang'),
            'pr_spesialis_id'   => $this->input->post('spesialis'),
            'pr_date_resume'    => $datetime,
            //'pr_status'         => "1",
            'pr_jenis_pelayanan'=> $this->input->post('pelayanan'),
        );
        $id = $this->input->post('id');
        $this->db->where('pr_id', $id);
        $this->db->update('proses_resume', $update);
    }
    
    function proseseditdokter() {
        $update = array(
            'pr_user_dokter_id'         => $this->input->post('iddokter'),
            'pr_user_dokter_dpjp_id'    => $this->input->post('dpjp'),
            'pr_diagnosa'               => $this->input->post('diagnosa'),
            'pr_tindakan'               => $this->input->post('tindakan'),
            'pr_keterangan'             => $this->input->post('keterangan'),
            'pr_status'                 => "2",
        );
        $id = $this->input->post('id');
        $this->db->where('pr_id', $id);
        $this->db->update('proses_resume', $update);
    }
    
    function deletedokter($id) {
        $update = array(
            'pr_user_dokter_id'         => null,
            'pr_user_dokter_dpjp_id'    => null,
            'pr_diagnosa'               => null,
            'pr_tindakan'               => null,
            'pr_keterangan'             => null,
            'pr_status'                 => "1",
        );
        $this->db->where('pr_id', $id);
        $this->db->update('proses_resume', $update);
    }

    function delete($id) {
        $this->db->where('pr_id', $id);
        $this->db->delete('proses_resume');
    }
}
?>