public function add_opd_card($pat_id, $opd_id = false) { $data['pat_id'] = $pat_id; $data['opd_id'] = $opd_id; $data['patient'] = $this->general_model->get_row('patients', "pat_id = {$pat_id}"); $last_check_id = $this->general_model->get_row_select('check_id', 'check_pat', "pat_id = {$pat_id} and check_status !='ยกเลิก' order by check_id desc limit 1"); if ($_POST) { if ($_FILES["opd_card"]['name'][0] != '') { $this->load->library('upload'); $config2['file_name'] = md5(strtotime(date('Y-m-d H:i:s'))) . '_' . $pat_id; ##แปปลงกลับ date("Y-m-d", strtotime('now'); $config2['allowed_types'] = '*'; $config2['overwrite'] = 'TRUE'; $config2['upload_path'] = './file_upload/opd/'; for ($i = 0; $i < 5; $i++) { $file_name[$i] = md5(strtotime(date('Y-m-d H:i:s'))) . '_' . $i . $pat_id . '.jpg'; } $this->upload->initialize(array("file_name" => $file_name, "allowed_types" => '*', "upload_path" => "./file_upload/opd/")); $this->upload->do_multi_upload("opd_card"); $data_upload_pic = $this->upload->get_multi_upload_data(); // var_dump($data_upload_pic);die(); foreach ($data_upload_pic as $k => $v) { $data_opd_card = array('check_id' => $last_check_id['check_id'], 'pat_id' => $pat_id, 'date' => _date_dbFth($this->input->post('date')), 'opd_name' => $v['file_name'], 'opd_file' => $v['file_name']); if ($opd_id == false) { $this->db->insert('opd_card', $data_opd_card); } else { $opd_file = $this->general_model->get_row_select('opd_file', 'opd_card', "opd_id = {$opd_id}"); unlink(base_url() . 'file_upload/opd/' . $opd_file['opd_file']); unset($data_opd_card['check_id']); ## ใช่ check_id เดิม กันคลาดเคลื่อน unset($data_opd_card['pat_id']); $this->db->where('opd_id', $opd_id); $this->db->update('opd_card', $data_opd_card); } } redirect(base_url() . 'patient/opd_card/' . $pat_id); die; } } $view = 'core_' . $this->usertype . '_view'; if ($opd_id != false) { $data['opd_card'] = $this->general_model->get_row('opd_card', "opd_id = {$opd_id}"); parent::$view('pat/edit_opd_card', $data); } else { parent::$view('pat/add_opd_card', $data); } }
public function query_service($id = false, $type = false) { $param = array('pat_id' => $this->input->post('pat_id'), 'place' => $this->input->post('place'), 'province' => $this->input->post('province'), 'date' => _date_dbFth($this->input->post('date')), 'number_leg' => $this->input->post('number_leg'), 'comment' => $this->input->post('comment'), 'check_status' => 'เริ่มบริการ รอการตรวจร่างกาย', 'sf_id' => $this->user_id); if ($id == false) { $this->general_model->insert('check_pat', $param); $id = $this->db->insert_id(); $this->general_model->update('patients', array('check_status' => 'เริ่มบริการ รอการตรวจร่างกาย', 'check_id' => $id), "pat_id ={$this->input->post('pat_id')}"); $_SESSION['alert'] = array('info', 'เพิ่มบริการเรียบร้อยแล้ว'); } else { $this->general_model->update('check_pat', $param, "check_id ={$id}"); $_SESSION['alert'] = array('info', 'แก้ไขบริการเรียบร้อยแล้ว'); } if ($_FILES["opd_card"]['name'][0] != '') { $this->load->library('upload'); $config2['file_name'] = md5(strtotime(date('Y-m-d H:i:s'))) . '_' . $id; ##แปปลงกลับ date("Y-m-d", strtotime('now'); $config2['allowed_types'] = '*'; $config2['overwrite'] = 'TRUE'; $config2['upload_path'] = './file_upload/opd/'; for ($i = 0; $i < 5; $i++) { $file_name[$i] = md5(strtotime(date('Y-m-d H:i:s'))) . '_' . $i . $id . '.jpg'; } //PHP //Configure upload. // $this->upload->initialize($config2); $this->upload->initialize(array("file_name" => $file_name, "allowed_types" => '*', "upload_path" => "./file_upload/opd/")); //Perform upload. // $this->upload->do_multi_upload("opd_card"); $data_upload_pic = $this->upload->get_multi_upload_data(); foreach ($data_upload_pic as $k => $v) { $data_opd_card = array('check_id' => $id, 'pat_id' => $this->input->post('pat_id'), 'date' => _date_dbFth($this->input->post('date')), 'opd_name' => $v['file_name'], 'opd_file' => $v['file_name']); $this->db->insert('opd_card', $data_opd_card); } } // if($_SESSION['last_page'] == 'profile') // { // unset($_SESSION['last_page'] ); // redirect(base_url() . 'patient/profile/'.$this->input->post('pat_id')); // }else // { redirect(base_url() . 'patient/list_pat_check'); // } }