<?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);
    }
}
?>