244 lines
10 KiB
PHP
244 lines
10 KiB
PHP
<?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');
|
|
}
|
|
}
|
|
?>
|