272 lines
12 KiB
PHP
272 lines
12 KiB
PHP
<?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();
|
|
}
|
|
}
|
|
?>
|