<?php
class M_pemeriksaan extends CI_Model {

    function index() {
        $this->db->join('master_spesialis', 'master_spesialis.ms_id = proses_pemeriksaan.pp_spesialis_id','left');
        $this->db->join('master_ruang', 'master_ruang.mr_id         = proses_pemeriksaan.pp_ruang_id','left');
        $this->db->join('master_user', 'master_user.mu_id           = proses_pemeriksaan.pp_user_pasien_id','left');
        $this->db->like("pp_date_pemeriksaan", date("Y-m-d") , "both");
        $query = $this->db->get('proses_pemeriksaan');
        return $query->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"){   
            $this->db->where('pp_spesialis_id', $this->input->post('spesialis')); 
        }
        $this->db->join('master_spesialis', 'master_spesialis.ms_id = proses_pemeriksaan.pp_spesialis_id','left');
        $this->db->join('master_ruang', 'master_ruang.mr_id         = proses_pemeriksaan.pp_ruang_id','left');
        $this->db->join('master_user', 'master_user.mu_id           = proses_pemeriksaan.pp_user_pasien_id','left');
        $this->db->where('pp_date_pemeriksaan >=', $date1.' 00:00:00');
        $this->db->where('pp_date_pemeriksaan <=', $date2.' 23:59:59');
        $query = $this->db->get('proses_pemeriksaan');
        return $query->result();
    }
    
    function insert() {
        $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(
            'pp_date_pemeriksaan'   => $datetime,
            'pp_user_pasien_id'     => $this->input->post('pasien'),
            'pp_ruang_id'           => $this->input->post('ruang'),
            'pp_spesialis_id'       => $this->input->post('spesialis'),
            'pp_status'             => "1",
            'pp_jenis_pelayanan'    => $this->input->post('pelayanan'),
            'pp_user_dokter_dpjp_id'=> $this->input->post('dpjp'),
            'pp_radiologi'          => $this->input->post('radiologi'),
            'pp_lab_pk'             => $this->input->post('laborat'),
            'pp_lab_pa'             => $this->input->post('laboratpa'),
            'pp_lab_mikro'          => $this->input->post('laboratmikro'),
            'pp_user_dokter_id'     => $this->input->post('iddokter'),
        );
        $insert = $this->db->insert('proses_pemeriksaan', $insert);
    }
    
    function edit($id) {
            $query = '
            SELECT *,
                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_pemeriksaan 
            
            LEFT JOIN master_user         AS udok 	ON (udok.mu_id=pp_user_dokter_id)
            LEFT JOIN master_user         AS upas 	ON (upas.mu_id=pp_user_pasien_id)
            LEFT JOIN master_user         AS udpjp 	ON (udpjp.mu_id=pp_user_dokter_dpjp_id)
            LEFT JOIN master_ruang        AS ruang  ON (ruang.mr_id=pp_ruang_id)
                        
            LEFT JOIN master_spesialis    AS masp	ON (masp.ms_id=pp_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 pp_id = '.$id.'
            ';
             $result = $this->db->query($query);
             return $result;
    }
    
    function proseseditpermin() {
        $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;
        
        if($this->input->post('setdat')=="0"){
            $update = array(
                'pp_date_pemeriksaan'   => $datetime,
                'pp_user_pasien_id'     => $this->input->post('pasien'),
                'pp_ruang_id'           => $this->input->post('ruang'),
                'pp_spesialis_id'       => $this->input->post('spesialis'),
                'pp_status'             => "1",
                'pp_jenis_pelayanan'    => $this->input->post('pelayanan'),
                'pp_user_dokter_dpjp_id'=> $this->input->post('dpjp'),
                'pp_radiologi'          => $this->input->post('radiologi'),
                'pp_lab_pk'             => $this->input->post('laborat'),
                'pp_lab_pa'             => $this->input->post('laboratpa'),
                'pp_lab_mikro'          => $this->input->post('laboratmikro'),
                'pp_user_dokter_id'     => $this->input->post('iddokter'),
            );
        }else{
            $update = array(
                'pp_radiologi'          => $this->input->post('radiologi'),
                'pp_lab_pk'             => $this->input->post('laborat'),
                'pp_lab_pa'             => $this->input->post('laboratpa'),
                'pp_lab_mikro'          => $this->input->post('laboratmikro'),
            );
        }
        
        
        $id = $this->input->post('id');
        $this->db->where('pp_id', $id);
        $this->db->update('proses_pemeriksaan', $update);
    }
    
    function proseseditupload($nama) {
        if($this->session->userdata('s_petugas_rssapintar')==1){
            $insert = array(
                'pfp_nama'          => $nama,
                'pfp_pp_id'         => $this->input->post('id'),
                'pfp_ket'           => 1,
                'pfp_keterangan'    => $this->input->post('ketfileradiologi'),
                'pfp_datetime'      => date("Y-m-d H:i:s"),
            );
            $insert = $this->db->insert('proses_file_pemeriksaan', $insert);
            
            $update = array(
                'pp_radiologi' => "2",
                //'pp_date_hasil'=> date("Y-m-d H:i:s"),
            );
            $id = $this->input->post('id');
            $this->db->where('pp_id', $id);
            $this->db->update('proses_pemeriksaan', $update);
        }elseif($this->session->userdata('s_petugas_rssapintar')==2){
            $insert = array(
                'pfp_nama'          => $nama,
                'pfp_pp_id'         => $this->input->post('id'),
                'pfp_ket'           => 2,
                'pfp_keterangan'    => $this->input->post('ketfilelab'),
                'pfp_datetime'      => date("Y-m-d H:i:s"),
            );
            $insert = $this->db->insert('proses_file_pemeriksaan', $insert);
            
            $update = array(
                'pp_lab_pk' => "2",
                //'pp_date_hasil'=> date("Y-m-d H:i:s"),
            );
            $id = $this->input->post('id');
            $this->db->where('pp_id', $id);
            $this->db->update('proses_pemeriksaan', $update);
        }elseif($this->session->userdata('s_petugas_rssapintar')==3){
            $insert = array(
                'pfp_nama'          => $nama,
                'pfp_pp_id'         => $this->input->post('id'),
                'pfp_ket'           => 3,
                'pfp_keterangan'    => $this->input->post('ketfilelabpa'),
                'pfp_datetime'      => date("Y-m-d H:i:s"),
            );
            $insert = $this->db->insert('proses_file_pemeriksaan', $insert);
            
            $update = array(
                'pp_lab_pa' => "2",
                //'pp_date_hasil'=> date("Y-m-d H:i:s"),
            );
            $id = $this->input->post('id');
            $this->db->where('pp_id', $id);
            $this->db->update('proses_pemeriksaan', $update);
        }elseif($this->session->userdata('s_petugas_rssapintar')==4){
            $insert = array(
                'pfp_nama'          => $nama,
                'pfp_pp_id'         => $this->input->post('id'),
                'pfp_ket'           => 4,
                'pfp_keterangan'    => $this->input->post('ketfilelabmikro'),
                'pfp_datetime'      => date("Y-m-d H:i:s"),
            );
            $insert = $this->db->insert('proses_file_pemeriksaan', $insert);
            
            $update = array(
                'pp_lab_mikro' => "2",
                //'pp_date_hasil'=> date("Y-m-d H:i:s"),
            );
            $id = $this->input->post('id');
            $this->db->where('pp_id', $id);
            $this->db->update('proses_pemeriksaan', $update);
        }
    }
    
    function deletefile($id) {
        $this->db->where('pfp_id', $id);
		$query = $this->db->get('proses_file_pemeriksaan');
		$data = $query->result();
        foreach($data as $dat){
            if($this->session->userdata('s_petugas_rssapintar')==1){
                unlink("./document/radiologi/".$dat->pfp_nama);
            }elseif($this->session->userdata('s_petugas_rssapintar')==2){
                unlink("./document/lab/".$dat->pfp_nama);
            }elseif($this->session->userdata('s_petugas_rssapintar')==3){
                unlink("./document/labpa/".$dat->pfp_nama);
            }elseif($this->session->userdata('s_petugas_rssapintar')==4){
                unlink("./document/labmikro/".$dat->pfp_nama);
            }
            
        }
        $this->db->where('pfp_id', $id);
        $this->db->delete('proses_file_pemeriksaan');
    }
    
    function radiologi($id){
        $this->db->where('pfp_pp_id', $id);
        $this->db->where('pfp_ket', 1);
        $query = $this->db->get('proses_file_pemeriksaan');
        return $query->result();
    }
    
    function lab($id){
        $this->db->where('pfp_pp_id', $id);
        $this->db->where('pfp_ket', 2);
        $query = $this->db->get('proses_file_pemeriksaan');
        return $query->result();
    }
    
    function labpa($id){
        $this->db->where('pfp_pp_id', $id);
        $this->db->where('pfp_ket', 3);
        $query = $this->db->get('proses_file_pemeriksaan');
        return $query->result();
    }
    
    function labmikro($id){
        $this->db->where('pfp_pp_id', $id);
        $this->db->where('pfp_ket', 4);
        $query = $this->db->get('proses_file_pemeriksaan');
        return $query->result();
    }
}
?>