117 lines
5.3 KiB
PHP
117 lines
5.3 KiB
PHP
<?php
|
|
class M_pasien extends CI_Model {
|
|
function index() {
|
|
//$this->db->join('master_tipeuser', 'master_tipeuser.mt_id = master_user.mu_tipeuser_id','left');
|
|
$this->db->where('mu_tipeuser_id', '6');
|
|
$query = $this->db->get('master_user');
|
|
return $query->result();
|
|
}
|
|
|
|
function statusaktif() {
|
|
$this->db->where('mu_status', '1');
|
|
$this->db->where('mu_tipeuser_id', '6');
|
|
$query = $this->db->get('master_user');
|
|
return $query->result();
|
|
}
|
|
|
|
function insert() {
|
|
$insert_userlogin = array(
|
|
|
|
'mu_nama_user' => $this->input->post('namauser'),
|
|
'mu_password' => md5($this->input->post('passworduser')),
|
|
'mu_tipeuser_id' => "6",
|
|
'mu_status' => $this->input->post('status'),
|
|
|
|
'mu_no_rekamedik' => $this->input->post('normpasien'),
|
|
'mu_nama_lengkap' => $this->input->post('namalengkappasien'),
|
|
'mu_NIK' => $this->input->post('nikpasien'),
|
|
'mu_alamat_KTP' => $this->input->post('alamatktp'),
|
|
'mu_alamat_domisili'=> $this->input->post('alamatdomisili'),
|
|
'mu_telepon_1' => $this->input->post('telpon1'),
|
|
'mu_telepon_2' => $this->input->post('telpon2'),
|
|
'mu_tanggal_lahir' => date("Y-m-d", strtotime($this->input->post('tgllahir'))),
|
|
'mu_jenis_kelamin' => $this->input->post('jkuser'),
|
|
'mu_gol_darah' => $this->input->post('golongandarah'),
|
|
'mu_berat_badan' => $this->input->post('beratbadan'),
|
|
'mu_tinggi_badan' => $this->input->post('tinggibadan'),
|
|
'mu_warna_kulit' => $this->input->post('warnakulit'),
|
|
);
|
|
$insert = $this->db->insert('master_user', $insert_userlogin);
|
|
}
|
|
|
|
function edit($id) {
|
|
$this->db->where('mu_id', $id);
|
|
$query = $this->db->get('master_user');
|
|
return $query;
|
|
}
|
|
|
|
function prosesedit() {
|
|
$password = $this->input->post('passworduser');
|
|
if(empty($password)){
|
|
$update_userlogin = array(
|
|
'mu_nama_lengkap' => $this->input->post('namalengkappasien'),
|
|
'mu_nama_user' => $this->input->post('namauser'),
|
|
'mu_tipeuser_id' => "6",
|
|
'mu_status' => $this->input->post('status'),
|
|
'mu_no_rekamedik' => $this->input->post('normpasien'),
|
|
'mu_NIK' => $this->input->post('nikpasien'),
|
|
'mu_alamat_KTP' => $this->input->post('alamatktp'),
|
|
'mu_alamat_domisili'=> $this->input->post('alamatdomisili'),
|
|
'mu_telepon_1' => $this->input->post('telpon1'),
|
|
'mu_telepon_2' => $this->input->post('telpon2'),
|
|
'mu_tanggal_lahir' => date("Y-m-d", strtotime($this->input->post('tgllahir'))),
|
|
'mu_jenis_kelamin' => $this->input->post('jkuser'),
|
|
'mu_gol_darah' => $this->input->post('golongandarah'),
|
|
'mu_berat_badan' => $this->input->post('beratbadan'),
|
|
'mu_tinggi_badan' => $this->input->post('tinggibadan'),
|
|
'mu_warna_kulit' => $this->input->post('warnakulit'),
|
|
);
|
|
}else{
|
|
$update_userlogin = array(
|
|
'mu_nama_lengkap' => $this->input->post('namalengkappasien'),
|
|
'mu_nama_user' => $this->input->post('namauser'),
|
|
'mu_password' => md5($this->input->post('passworduser')),
|
|
'mu_tipeuser_id' => "6",
|
|
'mu_status' => $this->input->post('status'),
|
|
'mu_no_rekamedik' => $this->input->post('normpasien'),
|
|
'mu_NIK' => $this->input->post('nikpasien'),
|
|
'mu_alamat_KTP' => $this->input->post('alamatktp'),
|
|
'mu_alamat_domisili'=> $this->input->post('alamatdomisili'),
|
|
'mu_telepon_1' => $this->input->post('telpon1'),
|
|
'mu_telepon_2' => $this->input->post('telpon2'),
|
|
'mu_tanggal_lahir' => date("Y-m-d", strtotime($this->input->post('tgllahir'))),
|
|
'mu_jenis_kelamin' => $this->input->post('jkuser'),
|
|
'mu_gol_darah' => $this->input->post('golongandarah'),
|
|
'mu_berat_badan' => $this->input->post('beratbadan'),
|
|
'mu_tinggi_badan' => $this->input->post('tinggibadan'),
|
|
'mu_warna_kulit' => $this->input->post('warnakulit'),
|
|
);
|
|
}
|
|
|
|
$id = $this->input->post('id');
|
|
$this->db->where('mu_id', $id);
|
|
$this->db->update('master_user', $update_userlogin);
|
|
}
|
|
|
|
function delete($id) {
|
|
$this->db->where('mu_id', $id);
|
|
$this->db->delete('master_user');
|
|
}
|
|
|
|
function disabled($id) {
|
|
$update_data = array(
|
|
'mu_status' => 0,
|
|
);
|
|
$this->db->where('mu_id', $id);
|
|
$this->db->update('master_user', $update_data);
|
|
}
|
|
|
|
function aktif($id) {
|
|
$update_data = array(
|
|
'mu_status' => 1,
|
|
);
|
|
$this->db->where('mu_id', $id);
|
|
$this->db->update('master_user', $update_data);
|
|
}
|
|
}
|
|
?>
|