db_onedev = $this->load->database("onedev", true); $this->load->helper(array('form', 'url')); } function getdetails($id){ $rows = []; $sql = "SELECT so_walklettercourierdetail.*, M_SexName, CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname, T_SampleTypeName as samplename, T_OrderHeaderLabNumber as labnumber, 'Y' as active, So_WalkLetterCourierDetailFlagImage as flag_image, So_WalkLetterCourierDetailFlagReceiveImage as flag_image_receive, So_WalkLetterCourierDetailFlagReceiveResult as flag_result_receive, So_WalkLetterCourierDetailID as idx, T_OrderHeaderID as orderid, T_SampleTypeID as sampleid FROM so_walklettercourierdetail JOIN t_orderheader ON So_WalkLetterCourierDetailT_OrderHeaderID = T_OrderHeaderID JOIN t_sampletype ON So_WalkLetterCourierDetailT_SampleTypeID = T_SampleTypeID JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID JOIN m_title ON M_PatientM_TitleID = M_TitleID JOIN m_sex ON M_PatientM_SexID = M_SexID WHERE So_WalkLetterCourierDetailSo_WalkLetterCourierID = {$id} AND So_WalkLetterCourierDetailIsActive = 'Y'"; //echo $sql; $rows = $this->db_onedev->query($sql)->result_array(); return $rows; } function getdeliveries($orderid){ $query =" SELECT T_OrderDeliveryID as id, IFNULL(Fo_VerificationDeliveryID,0) as xid, M_DeliveryTypeCode as code, IF(ISNULL(Fo_VerificationDeliveryID),'N',Fo_VerificationDeliveryIsOK) as chex, M_DeliveryID as deliveryid, M_DeliveryTypeID as typedeliveryid, T_OrderDeliveryM_KelurahanID as vilageid, IF(ISNULL(Fo_VerificationDeliveryID),'',Fo_VerificationDeliveryReason) as note, 'reguler' as type, CASE WHEN T_OrderDeliveryM_DeliveryID = 1 THEN M_DeliveryName WHEN T_OrderDeliveryM_DeliveryID = 4 THEN CONCAT(M_DeliveryName) WHEN T_OrderDeliveryM_DeliveryID = 2 THEN CONCAT(M_DeliveryName) WHEN ( T_OrderDeliveryM_DeliveryID = 7 OR T_OrderDeliveryM_DeliveryID = 9 ) THEN CONCAT(M_DeliveryName) WHEN ( T_OrderDeliveryM_DeliveryID = 6 OR T_OrderDeliveryM_DeliveryID = 8 ) THEN CONCAT(M_DeliveryName) ELSE CONCAT(M_DeliveryName) END as label, CASE WHEN T_OrderDeliveryM_DeliveryID = 1 THEN '' WHEN T_OrderDeliveryM_DeliveryID = 4 THEN M_DoctorAddressDescription WHEN T_OrderDeliveryM_DeliveryID = 2 THEN M_PatientAddressDescription WHEN ( T_OrderDeliveryM_DeliveryID = 7 OR T_OrderDeliveryM_DeliveryID = 9 ) THEN M_DoctorHP WHEN ( T_OrderDeliveryM_DeliveryID = 6 OR T_OrderDeliveryM_DeliveryID = 8 ) THEN M_PatientHP ELSE T_OrderDeliveryDestination END as destination, CASE WHEN T_OrderDeliveryM_DeliveryID = 4 THEN M_DoctorAddressID WHEN T_OrderDeliveryM_DeliveryID = 2 THEN M_PatientAddressID ELSE 0 END as addressid FROM t_orderdelivery JOIN t_orderheader ON T_OrderDeliveryT_OrderHeaderID = T_OrderHeaderID JOIN m_delivery ON T_OrderDeliveryM_DeliveryID = M_DeliveryID JOIN m_deliverytype ON T_OrderDeliveryM_DeliveryTypeID = M_DeliveryTypeID LEFT JOIN m_doctoraddress ON T_OrderDeliveryAddressID = M_DoctorAddressID AND T_OrderDeliveryM_DeliveryID = 4 LEFT JOIN m_patientaddress ON T_OrderDeliveryAddressID = M_PatientAddressID AND T_OrderDeliveryM_DeliveryID = 2 LEFT JOIN fo_verification_delivery ON Fo_VerificationDeliveryT_OrderHeaderID = T_OrderDeliveryT_OrderHeaderID AND Fo_VerificationDeliveryIsActive = 'Y' LEFT JOIN m_doctor ON T_OrderHeaderSenderM_DoctorID = M_DoctorID AND ( T_OrderDeliveryM_DeliveryID = 7 OR T_OrderDeliveryM_DeliveryID = 9 ) LEFT JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID AND ( T_OrderDeliveryM_DeliveryID = 6 OR T_OrderDeliveryM_DeliveryID = 8 ) WHERE T_OrderDeliveryT_OrderHeaderID = {$orderid} AND T_OrderDeliveryIsActive = 'Y' GROUP BY T_OrderDeliveryID UNION SELECT 0 as id, IFNULL(Fo_VerificationDeliveryAddID,0) as xid, M_DeliveryTypeCode as code, IF(ISNULL(Fo_VerificationDeliveryAddID),'N',Fo_VerificationDeliveryAddOK) as chex, Fo_VerificationDeliveryAddM_DeliveryID as deliveryid, Fo_VerificationDeliveryAddM_DeliveryTypeID as typedeliveryid, Fo_VerificationDeliveryAddM_KelurahanID as vilageid, IF(ISNULL(Fo_VerificationDeliveryAddID),'',Fo_VerificationDeliveryAddReason) as note, 'reguler' as type, CASE WHEN Fo_VerificationDeliveryAddM_DeliveryID = 1 THEN 'Ambil Sendiri' WHEN Fo_VerificationDeliveryAddM_DeliveryID = 4 THEN CONCAT(M_DeliveryName) WHEN Fo_VerificationDeliveryAddM_DeliveryID = 2 THEN CONCAT(M_DeliveryName) WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 7 OR Fo_VerificationDeliveryAddM_DeliveryID = 9 ) THEN CONCAT(M_DeliveryName) WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 6 OR Fo_VerificationDeliveryAddM_DeliveryID = 8 ) THEN CONCAT(M_DeliveryName) ELSE CONCAT(M_DeliveryName) END as label, CASE WHEN Fo_VerificationDeliveryAddM_DeliveryID = 1 THEN '' WHEN Fo_VerificationDeliveryAddM_DeliveryID = 4 THEN M_DoctorAddressDescription WHEN Fo_VerificationDeliveryAddM_DeliveryID = 2 THEN M_PatientAddressDescription WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 7 OR Fo_VerificationDeliveryAddM_DeliveryID = 9 ) THEN M_DoctorHP WHEN ( Fo_VerificationDeliveryAddM_DeliveryID = 6 OR Fo_VerificationDeliveryAddM_DeliveryID = 8 ) THEN M_PatientHP ELSE Fo_VerificationDeliveryAddDestination END as destination, CASE WHEN Fo_VerificationDeliveryAddM_DeliveryID = 4 THEN M_DoctorAddressID WHEN Fo_VerificationDeliveryAddM_DeliveryID = 2 THEN M_PatientAddressID ELSE 0 END as addressid FROM fo_verification_delivery_add JOIN t_orderheader ON Fo_VerificationDeliveryAddT_OrderHeaderID = T_OrderHeaderID JOIN m_delivery ON Fo_VerificationDeliveryAddM_DeliveryID = M_DeliveryID JOIN m_deliverytype ON Fo_VerificationDeliveryAddM_DeliveryTypeID = M_DeliveryTypeID LEFT JOIN m_doctoraddress ON Fo_VerificationDeliveryAddAddressID = M_DoctorAddressID AND Fo_VerificationDeliveryAddM_DeliveryID = 4 LEFT JOIN m_patientaddress ON Fo_VerificationDeliveryAddAddressID = M_PatientAddressID AND Fo_VerificationDeliveryAddM_DeliveryID = 2 LEFT JOIN m_doctor ON T_OrderHeaderSenderM_DoctorID = M_DoctorID AND ( Fo_VerificationDeliveryAddM_DeliveryID = 7 OR Fo_VerificationDeliveryAddM_DeliveryID = 9 ) LEFT JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID AND ( Fo_VerificationDeliveryAddM_DeliveryID = 6 OR Fo_VerificationDeliveryAddM_DeliveryID = 8 ) WHERE Fo_VerificationDeliveryAddT_OrderHeaderID = {$orderid} AND Fo_VerificationDeliveryAddIsActive = 'Y' "; //echo $query ; $rows = $this->db_onedev->query($query)->result_array(); //echo $this->db_onedev->last_query(); $rst = ''; foreach($rows as $k => $v){ if($rst != ''){ $rst = $rst.' , '.$v['label']; } else{ $rst = $v['label']; } } return $rst; } function getphotos($orderid,$sampletypeid){ $rows = []; //print_r($_SERVER); $urlbase = 'http://'.$_SERVER['SERVER_NAME']."/one-media/one-image-nonlab/"; $sql = "SELECT So_ImageUploadID as id, So_ImageUploadOldName as oldname, CONCAT('{$urlbase}',So_ImageUploadNewName) as newname FROM so_imageupload WHERE So_ImageUploadT_OrderHeaderID = {$orderid} AND So_ImageUploadT_SampleTypeID = {$sampletypeid} AND So_ImageUploadIsActive = 'Y'"; //echo $sql; $rows = $this->db_onedev->query($sql)->result_array(); return $rows; } function getdoctors($sampletypeid){ $rows = []; $sql = "SELECT M_DoctorID as doctor_id, CONCAT(M_DoctorPrefix,M_DoctorPrefix2,' ',M_DoctorName,'...') as doctor_fullname FROM m_doctorso JOIN m_doctor ON M_DoctorSOM_DoctorID = M_DoctorID JOIN t_test ON T_TestT_SampleTypeID = {$sampletypeid} AND M_DoctorSONat_SubGroupID = T_TestNat_SubgroupID WHERE M_DoctorSOIsActive = 'Y' GROUP BY M_DoctorSOID"; //echo $sql; $rows = $this->db_onedev->query($sql)->result_array(); return $rows; } public function search() { $prm = $this->sys_input; if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $search = $prm["search"]; $status = $prm["stationid"]; $startdate = $prm["startdate"]; $enddate = $prm["enddate"]; $groupid = $prm["groupid"]; $subgroupid = $prm["subgroupid"]; $join_group = ''; if($groupid != 0){ $join_group = "JOIN nat_group ON T_TestNat_GroupID = Nat_GroupID AND Nat_GroupID = {$groupid}"; } $join_subgroup = ''; if($subgroupid != 0){ $join_group = "JOIN nat_subgroup ON T_TestNat_SubgroupID = Nat_SubgroupID AND Nat_SubgroupID = {$subgroupid}"; } if(!isset($prm['current_page'])) $prm['current_page'] = 1; $sql_where = "WHERE ( T_SamplingSoDoneDate BETWEEN '{$startdate} 00:00:00' AND '{$enddate} 23:59:59' ) AND So_ResultEntryIsActive = 'Y'"; $number_limit = 10; $number_offset = ($prm['current_page'] - 1) * $number_limit ; //$sql_param = array(); if ($search != "") { $sql_where = " WHERE ( T_OrderHeaderLabNumber like '%$search%' OR M_PatientName like '%$search%' ) "; } $sql = " SELECT count(*) as total FROM ( SELECT So_ResultEntryID FROM so_resultentry JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID JOIN t_test ON T_OrderDetailT_TestID = T_TestID JOIN t_orderheader ON So_ResultEntryT_OrderHeaderID = T_OrderHeaderID JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID JOIN m_sex ON M_PatientM_SexID = M_SexID LEFT JOIN m_title ON M_PatientM_TitleID = M_TitleID JOIN m_lang ON So_ResultEntryM_LangID = M_LangID JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = T_OrderHeaderID JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID AND DocumentationGroupName = 'other' $sql_where GROUP BY So_ResultEntryID ) x "; //echo $sql; $query = $this->db_onedev->query($sql); $tot_count = 0; $tot_page = 0; if ($query) { $tot_count = $query->result_array()[0]["total"]; $tot_page = ceil($tot_count/$number_limit); } else { $this->sys_error_db("t_samplestorageout count", $this->db_onedev); exit; } $sql = "SELECT T_OrderHeaderID as trx_id, So_ResultEntryID as re_id, T_OrderHeaderLabNumber as ordernumber, CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname, UPPER(M_SexName) as sexname, DATE_FORMAT(T_OrderHeaderDate,'%d-%m-%Y') as orderdate, DATE_FORMAT(M_PatientDOB,'%d-%m-%Y') as dob, T_OrderHeaderM_PatientAge as age, UPPER(T_OrderHeaderM_PatientAge) as umur, M_LangName as languange_name, T_TestName as test_name, '' as details, CASE WHEN So_ResultEntryStatus = 'NEW' THEN 'BARU' WHEN So_ResultEntryStatus = 'VAL1' THEN 'VERIFIKASI' WHEN So_ResultEntryStatus = 'VAL2' THEN 'VALIDASI' END as status_name, '' as deliveries, T_OrderPromiseDateTime, T_OrderHeaderIsCito as iscito, IF(ISNULL(M_DoctorID),'-',CONCAT(M_DoctorPrefix,M_DoctorPrefix2,' ',M_DoctorName,'...')) as doctor_fullname FROM so_resultentry JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID AND T_OrderDetailIsActive = 'Y' JOIN t_test ON T_OrderDetailT_TestID = T_TestID JOIN t_orderheader ON So_ResultEntryT_OrderHeaderID = T_OrderHeaderID JOIN m_doctor ON T_OrderHeaderSenderM_DoctorID = M_DoctorID JOIN t_orderpromise ON T_OrderPromiseT_OrderHeaderID = T_OrderHeaderID AND T_OrderPromiseIsActive = 'Y' JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID JOIN m_sex ON M_PatientM_SexID = M_SexID LEFT JOIN m_title ON M_PatientM_TitleID = M_TitleID JOIN m_lang ON So_ResultEntryM_LangID = M_LangID JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = T_OrderHeaderID JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID AND DocumentationGroupName = 'other' $sql_where GROUP BY So_ResultEntryID ORDER BY iscito DESC,T_OrderPromiseDateTime ASC,T_OrderHeaderID ASC limit $number_limit offset $number_offset"; //echo $sql; $query = $this->db_onedev->query($sql); $rows = $query->result_array(); //echo $this->db_onedev->last_query(); if($rows){ foreach($rows as $k => $v){ $sql = "SELECT So_ResultEntryID as trx_id, So_ResultEntryID as re_id, T_OrderDetailT_OrderHeaderID as orderid, T_TestT_SampleTypeID as sampletypeid, T_SamplingSoID, So_TemplateFlagOther as template_flag_other, So_TemplateOther as template_name, UPPER(T_TestName) as test_name, T_TestID as test_id, M_LangID as language_id, So_ResultEntrySo_TemplateID as template_id, CASE WHEN So_ResultEntryStatus = 'NEW' THEN 'BARU' WHEN So_ResultEntryStatus = 'VAL1' THEN 'VALIDASI 1' WHEN So_ResultEntryStatus = 'VAL2' THEN 'VALIDASI 2' END as status_name, So_ResultEntryStatus as status, M_LangName as language_name, '' as doctors, IFNULL(M_DoctorID,0) as doctor_id, IF(ISNULL(M_DoctorID),'-',CONCAT(M_DoctorPrefix,M_DoctorPrefix2,' ',M_DoctorName,'...')) as doctor_fullname, '' as details, '' as langs, '' as photos FROM so_resultentry JOIN so_template ON So_ResultEntrySo_TemplateID = So_TemplateID JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID JOIN t_test ON T_OrderDetailT_TestID = T_TestID JOIN m_lang ON So_ResultEntryM_LangID = M_LangID JOIN t_samplingso ON T_SamplingSoT_OrderHeaderID = So_ResultEntryT_OrderHeaderID AND T_SamplingSoT_TestID = T_TestID JOIN documentation_group_detail ON DocumentationGroupDetailNat_SubGroupID = T_TestNat_SubGroupID JOIN documentation_group ON DocumentationGroupDetailDocumentationGroupID = DocumentationGroupID AND DocumentationGroupName = 'other' LEFT JOIN m_doctor ON T_SamplingSoM_DoctorID = M_DoctorID WHERE So_ResultEntryID = {$v['re_id']}"; //echo $sql; $rst_details = $this->db_onedev->query($sql)->result_array(); foreach($rst_details as $ki => $vi){ $sql = "SELECT So_ResultEntryDetailID as trx_id, So_ResultEntryDetailSo_TemplateDetailID as template_detail_id, So_TemplateDetailName as result_label, So_ResultEntryDetailResult as result_value, So_ResultEntryDetailFlagPrint as flag_print, So_ResultEntryDetailResult as result_value_before FROM so_resultentrydetail JOIN so_templatedetail ON So_TemplateDetailID = So_ResultEntryDetailSo_TemplateDetailID WHERE So_ResultEntryDetailSo_ResultEntryID = {$vi['trx_id']} AND So_ResultEntryDetailisActive = 'Y'"; //echo $sql; $rst_details[$ki]['details'] = $this->db_onedev->query($sql)->result_array(); $rst_details[$ki]['langs'] = $this->getlangs($vi['orderid']); $rst_details[$ki]['photos'] = $this->getphotos($vi['orderid'],$vi['sampletypeid']); $rst_details[$ki]['doctors'] = $this->getdoctors($vi['sampletypeid']); } $rows[$k]['details'] = $rst_details; $rows[$k]['deliveries'] = $this->getdeliveries($v['trx_id']); } } //$this->_add_address($rows); $result = array("total" => $tot_page, "records" => $rows, "sql"=> $this->db_onedev->last_query()); $this->sys_ok($result); exit; } function getlangs($orderid){ $sql = " SELECT M_LangID as id, M_LangCode as code, M_LangName as name, 'N' as chex FROM t_orderheader JOIN m_lang ON T_OrderHeaderM_LangID = M_LangID WHERE T_OrderHeaderID = {$orderid} UNION SELECT M_LangID as id, M_LangCode as code, M_LangName as name, 'N' as chex FROM t_orderheader JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID JOIN m_lang ON T_OrderHeaderAddOnSecondM_LangID = M_LangID WHERE T_OrderHeaderID = {$orderid} "; $rst = $this->db_onedev->query($sql)->result_array(); return $rst; } function getordersamples(){ $prm = $this->sys_input; if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $doctorid = $prm['doctorid']; $doctoraddressid = $prm['doctoraddressid']; $sql = "SELECT 0 as idx, M_SexName, CONCAT(M_TitleName,' ',M_PatientName) as patient_fullname, T_SampleTypeName as samplename, T_OrderHeaderLabNumber as labnumber, T_OrderHeaderID as orderid, T_SampleTypeID as sampleid, 'Y' as active, 'N' as flag_image FROM t_samplingso JOIN t_orderheader ON T_SamplingSoT_OrderHeaderID = T_OrderHeaderID JOIN t_sampletype ON T_SamplingSoT_SampleTypeID = T_SampleTypeID JOIN m_patient ON T_OrderHeaderM_PatientID = M_PatientID JOIN m_title ON M_PatientM_TitleID = M_TitleID JOIN m_sex ON M_PatientM_SexID = M_SexID WHERE T_SamplingSoM_DoctorID = {$doctorid} AND T_SamplingSoM_DoctorAddressID = {$doctoraddressid} AND T_SamplingSoVerifyFlagWL = 'N' AND T_SamplingSoIsActive = 'Y'"; //echo $sql; $rows = $this->db_onedev->query($sql)->result_array(); $result = array( "total" => count($rows) , "records" => $rows, ); $this->sys_ok($result); exit; } function getumum(){ $prm = $this->sys_input; if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $rst = array(); $rst['riwayats'] = array(); $rst['fisiks'] = array(); $rst['umum_saran'] = ''; $rst['k3s'] = array(); $rows = array(); $prm = $this->sys_input; $sql = "SELECT COUNT(*) as x_count FROM so_resultentry_fisik_umum WHERE So_ResultEntryFisikUmumSo_ResultEntryID = {$prm['trx_id']} AND So_ResultEntryFisikUmumM_LangID = {$prm['language_id']} AND So_ResultEntryFisikUmumIsActive = 'Y'"; $x_count = $this->db_onedev->query($sql)->row()->x_count; if($x_count == 0){ /* [{"title":"KELUHAN SAAT INI","subtitle":"","label_flag_normal":"Tidak ada keluhan","flag_normal":"Y","show_all":"N","type_form":"XV","details":[{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_1","id":"1","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Demam","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_2","id":"2","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Nyeri Kepala","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_3","id":"3","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Batuk dan influensa","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_4","id":"4","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Batuk lebih dari 1 bulan","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_5","id":"5","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Pusing atau rasa berputar (vertigo)","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_6","id":"6","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lemas","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_7","id":"7","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan mata atau penglihatan","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_8","id":"8","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Mata berkunang-kunang","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_9","id":"9","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan pendengaran","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_10","id":"10","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Nyeri dada","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_11","id":"11","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Sesak Napas","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_12","id":"12","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Sakit Jantung","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_13","id":"13","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Hipertensi / tekanan darah tinggi","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_14","id":"14","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Tidak nafsu makan lebih dari 1 bulan","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_15","id":"15","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gastritis (maag)","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_16","id":"16","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Nyeri perut atau gangguan pencernaan lainnya","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_17","id":"17","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Haemorrhoid (wasir/ambeien)","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_18","id":"18","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Diare berulang / lama (kronis)","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_19","id":"19","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Sakit pinggang","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_20","id":"20","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan berkemih","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_21","id":"21","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan ginjal","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_22","id":"22","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan pada alat reproduksi","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_23","id":"23","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Nyeri otot dan sendi","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_24","id":"24","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kesemutan","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_25","id":"25","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Bengkak pada kaki atau anggota badan lainnya","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_26","id":"26","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gatal atau gangguan kulit lainnya","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_27","id":"27","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Benjolan abnormal pada bagian tubuh","chx":false,"value":""},{"table_name":"fisik_keluhan","id_code":"fisik_keluhan_28","id":"28","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Keluhan lain-lain","chx":false,"value":""}]},{"title":"RIWAYAT POBIA","subtitle":"","label_flag_normal":"Tidak ada pobia","flag_normal":"Y","show_all":"N","type_form":"XV","details":[{"table_name":"fisik_pobia","id_code":"fisik_pobia_1","id":"1","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Rasa takut yang berlebihan (phobia)","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_2","id":"2","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Takut ketinggian","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_3","id":"3","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Takut di ruangan gelap","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_4","id":"4","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Takut melihat darah","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_5","id":"5","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Takut di ruang sempit","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_6","id":"6","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Takut berada di tengah laut","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_7","id":"7","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Takut naik pesawat/helikopter","chx":false,"value":""},{"table_name":"fisik_pobia","id_code":"fisik_pobia_8","id":"8","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Mabuk laut atau mabuk perjalanan","chx":false,"value":""}]},{"title":"RIWAYAT PENYAKIT","subtitle":"","label_flag_normal":"Tidak ada riwayat penyakit","flag_normal":"Y","show_all":"N","type_form":"XVS","details":[{"name":"System Pencernaan","details":[{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_1","id":"1","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gastritis (maag)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_2","id":"2","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Hepatitis (penyakit hati/kuning)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_3","id":"3","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Batu empedu","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_4","id":"4","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Demam typoid","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_5","id":"5","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Haemorrhoid (wasir/ambeien)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_6","id":"6","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Operasi saluran pencernaan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pencernaan","id_code":"fisik_penyakit_7","id":"7","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Pencernaan )","chx":false,"value":""}]},{"name":"System Pernafasan","details":[{"table_name":"fisik_penyakit","segment_name":"System Pernafasan","id_code":"fisik_penyakit_8","id":"8","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Asma","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pernafasan","id_code":"fisik_penyakit_9","id":"9","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Tuberculosa (TBC)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pernafasan","id_code":"fisik_penyakit_10","id":"10","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Batuk lebih dari 1 bulan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pernafasan","id_code":"fisik_penyakit_11","id":"11","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Pneumonia","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Pernafasan","id_code":"fisik_penyakit_12","id":"12","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Pernafasan )","chx":false,"value":""}]},{"name":"System cardiovaskuler","details":[{"table_name":"fisik_penyakit","segment_name":"System cardiovaskuler","id_code":"fisik_penyakit_13","id":"13","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit jantung","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System cardiovaskuler","id_code":"fisik_penyakit_14","id":"14","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Hipertensi","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System cardiovaskuler","id_code":"fisik_penyakit_15","id":"15","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Stroke","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System cardiovaskuler","id_code":"fisik_penyakit_16","id":"16","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Pasang pen atau ring","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System cardiovaskuler","id_code":"fisik_penyakit_17","id":"17","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Anemia","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System cardiovaskuler","id_code":"fisik_penyakit_18","id":"18","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Cardiovaskuler )","chx":false,"value":""}]},{"name":"Sistem Saraf","details":[{"table_name":"fisik_penyakit","segment_name":"Sistem Saraf","id_code":"fisik_penyakit_19","id":"19","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Vertigo (pusing memutar)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Saraf","id_code":"fisik_penyakit_20","id":"20","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Epilepsi (ayan), kejang, pingsan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Saraf","id_code":"fisik_penyakit_21","id":"21","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Polio","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Saraf","id_code":"fisik_penyakit_22","id":"22","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan mental / kejiwaan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Saraf","id_code":"fisik_penyakit_23","id":"23","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Mengalami cidera kepala","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Saraf","id_code":"fisik_penyakit_24","id":"24","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Syaraf )","chx":false,"value":""}]},{"name":"Sistem Penglihatan","details":[{"table_name":"fisik_penyakit","segment_name":"Sistem Penglihatan","id_code":"fisik_penyakit_25","id":"25","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kacamata Minus","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Penglihatan","id_code":"fisik_penyakit_26","id":"26","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kacamata (+)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Penglihatan","id_code":"fisik_penyakit_27","id":"27","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kacamata Silender","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Penglihatan","id_code":"fisik_penyakit_28","id":"28","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Trauma","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Penglihatan","id_code":"fisik_penyakit_29","id":"29","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Fotopobia","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Penglihatan","id_code":"fisik_penyakit_30","id":"30","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Penglihatan )","chx":false,"value":""}]},{"name":"Sistem Pendengaran/THT","details":[{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_31","id":"31","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan Pendengaran","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_32","id":"32","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Sinusitis","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_33","id":"33","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Rhinitis Allergika","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_34","id":"34","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Amandel/tonsilitis","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_35","id":"35","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Otitis","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_36","id":"36","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Trauma","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Sistem Pendengaran/THT","id_code":"fisik_penyakit_37","id":"37","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Pendengaran/THT )","chx":false,"value":""}]},{"name":"Ginjal & Saluran Kemih","details":[{"table_name":"fisik_penyakit","segment_name":"Ginjal & Saluran Kemih","id_code":"fisik_penyakit_38","id":"38","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Batu ginjal","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Ginjal & Saluran Kemih","id_code":"fisik_penyakit_39","id":"39","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit ginjal (akut/kronis)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Ginjal & Saluran Kemih","id_code":"fisik_penyakit_40","id":"40","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Infeksi saluran kemih","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Ginjal & Saluran Kemih","id_code":"fisik_penyakit_41","id":"41","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Operasi saluran kemih","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Ginjal & Saluran Kemih","id_code":"fisik_penyakit_42","id":"42","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Ginjal & Saluran Kemih )","chx":false,"value":""}]},{"name":"Tulang, Sendi & Otot","details":[{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_43","id":"43","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Patah tulang","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_44","id":"44","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Radang sendi (arthritis)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_45","id":"45","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Rheumatik","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_46","id":"46","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kecelakaan / cidera / trauma / luka parah","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_47","id":"47","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Nyeri otot lebih dari 1 bulan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_48","id":"48","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Nyeri punggung / back pain","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Tulang, Sendi & Otot","id_code":"fisik_penyakit_49","id":"49","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Tulang, Sendi & Otot )","chx":false,"value":""}]},{"name":"Kulit & system reproduksi","details":[{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_50","id":"50","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan alat reproduksi","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_51","id":"51","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kista / tumor / kanker alat reproduksi","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_52","id":"52","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit Akibat Hubungan Sex","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_53","id":"53","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"HIV","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_54","id":"54","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lepra","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_55","id":"55","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit kulit yang lama / kronis","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Kulit & system reproduksi","id_code":"fisik_penyakit_56","id":"56","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Kulit & Sistem Reproduksi )","chx":false,"value":""}]},{"name":"System Endokrin","details":[{"table_name":"fisik_penyakit","segment_name":"System Endokrin","id_code":"fisik_penyakit_57","id":"57","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Diabetes Militus (Kencing manis)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Endokrin","id_code":"fisik_penyakit_58","id":"58","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan tiroid (gondok, hipo/hipertiroid)","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"System Endokrin","id_code":"fisik_penyakit_59","id":"59","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Sistem Endokrin )","chx":false,"value":""}]},{"name":"Allergi","details":[{"table_name":"fisik_penyakit","segment_name":"Allergi","id_code":"fisik_penyakit_60","id":"60","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Allergi Obat","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Allergi","id_code":"fisik_penyakit_61","id":"61","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Allergi Makanan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Allergi","id_code":"fisik_penyakit_62","id":"62","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Allergi Hirupan","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Allergi","id_code":"fisik_penyakit_63","id":"63","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Allergi Kontak","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Allergi","id_code":"fisik_penyakit_64","id":"64","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Allergi )","chx":false,"value":""}]},{"name":"Penyakit daerah tropis","details":[{"table_name":"fisik_penyakit","segment_name":"Penyakit daerah tropis","id_code":"fisik_penyakit_65","id":"65","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"DHF / Demam berdarah","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Penyakit daerah tropis","id_code":"fisik_penyakit_66","id":"66","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Malaria","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Penyakit daerah tropis","id_code":"fisik_penyakit_67","id":"67","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Typoid","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Penyakit daerah tropis","id_code":"fisik_penyakit_68","id":"68","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Penyakit daerah tropis )","chx":false,"value":""}]},{"name":"Penyakit lainnya","details":[{"table_name":"fisik_penyakit","segment_name":"Penyakit lainnya","id_code":"fisik_penyakit_69","id":"69","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Tumor / kanker","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Penyakit lainnya","id_code":"fisik_penyakit_70","id":"70","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Leukimia","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Penyakit lainnya","id_code":"fisik_penyakit_71","id":"71","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Pernah operasi","chx":false,"value":""},{"table_name":"fisik_penyakit","segment_name":"Penyakit lainnya","id_code":"fisik_penyakit_72","id":"72","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lain-lain ( Penyakit lainnya )","chx":false,"value":""}]}]},{"title":"RIWAYAT PENYAKIT KELUARGA","subtitle":"Apakah orang tua, kakek nenek, saudara kandung atau keluarga dekat menderita penyakit dibawah ini ?","label_flag_normal":"Tidak ada riwayat penyakit","flag_normal":"Y","show_all":"N","type_form":"XV","details":[{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_1","id":"1","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Diabetes Millitus","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_2","id":"2","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Hypertensi","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_3","id":"3","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Stroke","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_4","id":"4","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit Jantung","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_5","id":"5","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit Ginjal","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_6","id":"6","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"TBC","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_7","id":"7","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Lepra","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_8","id":"8","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Penyakit hati / hepatitis","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_9","id":"9","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Epilepsi (ayan)","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_10","id":"10","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Gangguan jiwa","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_11","id":"11","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kanker / tumor ganas","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_12","id":"12","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Autoimmum / Rheumatik / Lupus","chx":false,"value":""},{"table_name":"fisik_penyakitkeluarga","id_code":"fisik_penyakitkeluarga_13","id":"13","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Asma","chx":false,"value":""}]},{"title":"RIWAYAT KEBIASAAN HIDUP","subtitle":"","label_flag_normal":"Tidak ada riwayat kebiasaan hidup","flag_normal":"Y","show_all":"N","type_form":"XVS","details":[{"name":"Minum alkohol","details":[{"table_name":"fisik_kebiasaanhidup","segment_name":"Minum alkohol","id_code":"fisik_kebiasaanhidup_1","id":"1","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Tidak","chx":false,"value":""},{"table_name":"fisik_kebiasaanhidup","segment_name":"Minum alkohol","id_code":"fisik_kebiasaanhidup_2","id":"2","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kadang-kadang","chx":false,"value":""},{"table_name":"fisik_kebiasaanhidup","segment_name":"Minum alkohol","id_code":"fisik_kebiasaanhidup_3","id":"3","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Rutin","chx":false,"value":""}]},{"name":"Olahraga","details":[{"table_name":"fisik_kebiasaanhidup","segment_name":"Olahraga","id_code":"fisik_kebiasaanhidup_4","id":"4","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Tidak","chx":false,"value":""},{"table_name":"fisik_kebiasaanhidup","segment_name":"Olahraga","id_code":"fisik_kebiasaanhidup_5","id":"5","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kadang-kadang","chx":false,"value":""},{"table_name":"fisik_kebiasaanhidup","segment_name":"Olahraga","id_code":"fisik_kebiasaanhidup_6","id":"6","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Rutin","chx":false,"value":""}]},{"name":"Merokok","details":[{"table_name":"fisik_kebiasaanhidup","segment_name":"Merokok","id_code":"fisik_kebiasaanhidup_8","id":"8","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Tidak","chx":false,"value":""},{"table_name":"fisik_kebiasaanhidup","segment_name":"Merokok","id_code":"fisik_kebiasaanhidup_9","id":"9","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Kadang-kadang","chx":false,"value":""},{"table_name":"fisik_kebiasaanhidup","segment_name":"Merokok","id_code":"fisik_kebiasaanhidup_10","id":"10","lang_id":"1","type":"RIWAYAT","category":"UMUM","label":"Rutin","chx":false,"value":""}]}]},{"title":"RIWAYAT KONSUMSI OBAT TERATUR","subtitle":"","label_flag_normal":"Tidak ada","flag_normal":"Y","show_all":"N","type_form":"XV","details":[{"table_name":"fisik_konsumsiobatteratur","id_code":"fisik_konsumsiobatteratur_1","id":"1","lang_id":"1","type":"UMUM","category":"RIWAYAT","label":"Obat anti Diabetes Millitus","chx":false,"value":""},{"table_name":"fisik_konsumsiobatteratur","id_code":"fisik_konsumsiobatteratur_2","id":"2","lang_id":"1","type":"UMUM","category":"RIWAYAT","label":"Obat anti hypertensi","chx":false,"value":""},{"table_name":"fisik_konsumsiobatteratur","id_code":"fisik_konsumsiobatteratur_3","id":"3","lang_id":"1","type":"UMUM","category":"RIWAYAT","label":"Obat lainnya","chx":false,"value":""}]}]*/ $sql = "SELECT * FROM fisik_templateresult WHERE Fisik_TemplateResultM_LangID = {$prm['language_id']} AND Fisik_TemplateResultType = 'riwayat' AND Fisik_TemplateResultIsActive = 'Y' LIMIT 1"; $rst['riwayats'] = json_decode($this->db_onedev->query($sql)->row()->Fisik_TemplateResultText); /* [{"title":"TANDA VITAL","show_all":"N","type_form":"VXX","details":[{"table_name":"tanda_vital","id_code":"tanda_vital_1","type":"vxx-v","label":"Denyut nadi","value":"","unit":"x/menit","chx_y":false,"label_y":"","chx_x":false,"label_x":""},{"table_name":"tanda_vital","id_code":"tanda_vital_2","type":"vxx-xx","label":"Ritme denyut nadi","value":"","unit":"","chx_y":false,"label_y":"Reguler","chx_x":false,"label_x":"Ireguler"},{"table_name":"tanda_vital","id_code":"tanda_vital_3","type":"vxx-v","label":"Laju pernafasan","value":"","unit":"x/menit","chx_y":false,"label_y":"","chx_x":false,"label_x":""},{"table_name":"tanda_vital","id_code":"tanda_vital_4","type":"vxx-xx","label":"Pola nafas","value":"","unit":"","chx_y":false,"label_y":"Normal","chx_x":false,"label_x":"Tidak normal"},{"table_name":"tanda_vital","id_code":"tanda_vital_5","type":"vxx-v","label":"Tekanan Darah","value":"","unit":"mmHg","chx_y":false,"label_y":"","chx_x":false,"label_x":""},{"table_name":"tanda_vital","id_code":"tanda_vital_4","type":"vxx-xx","label":"Suhu","value":"","unit":"","chx_y":false,"label_y":"Normal","chx_x":false,"label_x":"Demam"}]}] */ $sql = "SELECT * FROM fisik_templateresult WHERE Fisik_TemplateResultM_LangID = {$prm['language_id']} AND Fisik_TemplateResultType = 'fisik' AND Fisik_TemplateResultIsActive = 'Y' LIMIT 1"; $rst['fisiks'] = json_decode($this->db_onedev->query($sql)->row()->Fisik_TemplateResultText); $rst['umum_saran'] = ''; $sql = "SELECT * FROM fisik_templateresult WHERE Fisik_TemplateResultM_LangID = {$prm['language_id']} AND Fisik_TemplateResultType = 'k3' AND Fisik_TemplateResultIsActive = 'Y' LIMIT 1"; $rst['k3s'] = json_decode($this->db_onedev->query($sql)->row()->Fisik_TemplateResultText); }else{ $sql = "SELECT * FROM so_resultentry_fisik_umum WHERE So_ResultEntryFisikUmumSo_ResultEntryID = {$prm['trx_id']} AND So_ResultEntryFisikUmumM_LangID = {$prm['language_id']} AND So_ResultEntryFisikUmumType = 'riwayat' AND So_ResultEntryFisikUmumIsActive = 'Y' LIMIT 1"; $rst['riwayats'] = json_decode($this->db_onedev->query($sql)->row()->So_ResultEntryFisikUmumDetails); $sql = "SELECT * FROM so_resultentry_fisik_umum WHERE So_ResultEntryFisikUmumSo_ResultEntryID = {$prm['trx_id']} AND So_ResultEntryFisikUmumM_LangID = {$prm['language_id']} AND So_ResultEntryFisikUmumType = 'fisik' AND So_ResultEntryFisikUmumIsActive = 'Y' LIMIT 1"; $rst['fisiks'] = json_decode($this->db_onedev->query($sql)->row()->So_ResultEntryFisikUmumDetails); $sql = "SELECT * FROM so_resultentry_fisik_umum WHERE So_ResultEntryFisikUmumSo_ResultEntryID = {$prm['trx_id']} AND So_ResultEntryFisikUmumM_LangID = {$prm['language_id']} AND So_ResultEntryFisikUmumType = 'saran' AND So_ResultEntryFisikUmumIsActive = 'Y' LIMIT 1"; //echo $sql; $rst['umum_saran'] = $this->db_onedev->query($sql)->row()->So_ResultEntryFisikUmumDetails; $sql = "SELECT * FROM so_resultentry_fisik_umum WHERE So_ResultEntryFisikUmumSo_ResultEntryID = {$prm['trx_id']} AND So_ResultEntryFisikUmumM_LangID = {$prm['language_id']} AND So_ResultEntryFisikUmumType = 'k3' AND So_ResultEntryFisikUmumIsActive = 'Y' LIMIT 1"; $rst['k3s'] = json_decode($this->db_onedev->query($sql)->row()->So_ResultEntryFisikUmumDetails); //echo $rst['umumu_saran']; } $result = array( "total" => count($rst) , "records" => $rst, ); $this->sys_ok($result); exit; } function getgroups(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $rows = []; $query =" SELECT Nat_GroupID as id, Nat_GroupName as title, CONCAT('GROUP : ',Nat_GroupName) as fulltitle, '' as childrens FROM nat_group WHERE Nat_GroupIsActive = 'Y' AND ( Nat_GroupCode = 2 OR Nat_GroupCode = 3 ) "; //echo $query; $rows['groups'] = $this->db_onedev->query($query)->result_array(); if($rows['groups']){ foreach($rows['groups'] as $k => $v){ $childrens = array(array('id'=>0, 'title'=>'Semua', 'fulltitle'=>'Subgroub : Semua')); $query =" SELECT Nat_SubGroupID as id, Nat_SubGroupName as title, CONCAT('SUBGROUP : ',Nat_SubGroupName) as fulltitle FROM nat_subgroup WHERE Nat_SubGroupNat_GroupID = {$v['id']} AND Nat_SubGroupIsActive = 'Y' "; //echo $query; $xrst = $this->db_onedev->query($query)->result_array(); if($xrst){ foreach($xrst as $ki => $vi){ array_push($childrens,$vi); } } $rows['groups'][$k]['childrens'] = $childrens ; } } $query =" SELECT M_LangID as id, M_LangCode as name FROM m_lang WHERE M_LangIsActive = 'Y' "; //echo $query; $rows['langs'] = $this->db_onedev->query($query)->result_array(); $result = array( "total" => count($rows) , "records" => $rows, ); $this->sys_ok($result); exit; } function getsubgroups(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $rows = array(array('id'=>0, 'title'=>'Semua', 'fulltitle'=>'Subgroub : Semua')); $query =" SELECT Nat_SubGroupID as id, Nat_SubGroupName as title, CONCAT('SUBGROUP : ',Nat_SubGroupName) as fulltitle FROM nat_subgroup WHERE Nat_SubGroupNat_GroupID = {$prm['id']} AND Nat_SubGroupIsActive = 'Y' "; //echo $query; $rst = $this->db_onedev->query($query)->result_array(); if($rst){ foreach($rst as $k => $v){ array_push($rows,$v); } } $result = array( "total" => count($rows) , "records" => $rows, ); $this->sys_ok($result); exit; } function getstation(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $rows = []; $query =" SELECT T_SampleStationID as id, T_SampleStationName as name FROM t_samplestation WHERE T_SampleStationIsActive = 'Y' "; //echo $query; $rows['stations'] = $this->db_onedev->query($query)->result_array(); //print_r($statuses); foreach($statuses as $k=>$v){ array_push($rows['statuses'],$v); } $result = array( "total" => count($rows) , "records" => $rows, ); $this->sys_ok($result); exit; } function getdoctoraddress(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $query =" SELECT M_DoctorAddressID as id, M_DoctorAddressDescription as name FROM m_doctoraddress WHERE M_DoctorAddressM_DoctorID = {$prm['id']} AND M_DoctorAddressIsActive = 'Y' "; //echo $query; $rows = $this->db_onedev->query($query)->result_array(); $result = array( "total" => count($rows) , "records" => $rows, ); $this->sys_ok($result); exit; } function saveresult(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $userid = $this->sys_user["M_UserID"]; if($prm['act'] === 'val1'){ $sql = "UPDATE so_resultentry SET So_ResultEntryValidation1 = 'Y', So_ResultEntryStatus = 'VAL1', So_ResultEntryUserID = {$userid} WHERE So_ResultEntryID = {$prm['trx']['trx_id']}"; $this->db_onedev->query($sql); //echo $this->db_onedev->last_query(); } if($prm['act'] === 'unval1'){ $sql = "UPDATE so_resultentry SET So_ResultEntryValidation1 = 'N', So_ResultEntryStatus = 'NEW', So_ResultEntryUserID = {$userid} WHERE So_ResultEntryID = {$prm['trx']['trx_id']}"; $this->db_onedev->query($sql); } if($prm['act'] === 'val2'){ $sql = "UPDATE so_resultentry SET So_ResultEntryValidation2 = 'Y', So_ResultEntryStatus = 'VAL2', So_ResultEntryUserID = {$userid} WHERE So_ResultEntryID = {$prm['trx']['trx_id']}"; $this->db_onedev->query($sql); $sql = "SELECT t_samplingso.* FROM t_samplingso JOIN so_resultentry ON So_ResultEntryT_OrderHeaderID = T_SamplingSoT_OrderHeaderID AND So_ResultEntryID = {$prm['trx']['trx_id']} JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID JOIN t_test ON T_OrderDetailT_TestID = T_TestID JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID JOIN t_barcodelab ON T_BarcodeLabT_OrderHeaderID = T_OrderDetailT_OrderHeaderID AND T_BarcodeLabT_SampleTypeID = T_SampleTypeID WHERE T_SamplingSoIsActive = 'Y' GROUP BY T_SamplingSoID"; $data_sampling = $this->db_onedev->query($sql)->result_array(); if($data_sampling){ foreach($data_sampling as $k => $v){ $sql = "UPDATE t_samplingso SET T_SamplingSoIsDone = 'Y' WHERE T_SamplingSoID = {$v['T_SamplingSoID']}"; $this->db_onedev->query($sql); } } } if($prm['act'] === 'unval2'){ $sql = "UPDATE so_resultentry SET So_ResultEntryValidation2 = 'N', So_ResultEntryStatus = 'VAL1', So_ResultEntryUserID = {$userid} WHERE So_ResultEntryID = {$prm['trx']['trx_id']}"; $this->db_onedev->query($sql); $sql = "SELECT t_samplingso.* FROM t_samplingso JOIN so_resultentry ON So_ResultEntryT_OrderHeaderID = T_SamplingSoT_OrderHeaderID AND So_ResultEntryID = {$prm['trx']['trx_id']} JOIN t_orderdetail ON So_ResultEntryT_OrderDetailID = T_OrderDetailID JOIN t_test ON T_OrderDetailT_TestID = T_TestID JOIN t_sampletype ON T_TestT_SampleTypeID = T_SampleTypeID JOIN t_barcodelab ON T_BarcodeLabT_OrderHeaderID = T_OrderDetailT_OrderHeaderID AND T_BarcodeLabT_SampleTypeID = T_SampleTypeID WHERE T_SamplingSoIsActive = 'Y' GROUP BY T_SamplingSoID"; $data_sampling = $this->db_onedev->query($sql)->result_array(); if($data_sampling){ foreach($data_sampling as $k => $v){ $sql = "UPDATE t_samplingso SET T_SamplingSoIsDone = 'N' WHERE T_SamplingSoID = {$v['T_SamplingSoID']}"; $this->db_onedev->query($sql); } } } $sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = '{$prm['trx']['trx_id']}'"; //echo $sql; $re_langid = $this->db_onedev->query($sql)->row()->So_ResultEntryM_LangID; if($re_langid == $prm['trx']['language_id']){ foreach($prm['trx']['details'] as $k => $v){ $sql = "UPDATE so_resultentrydetail SET So_ResultEntryDetailResult = '{$v['result_value']}', So_ResultEntryDetailUserID = {$userid} WHERE So_ResultEntryDetailID = {$v['trx_id']}"; $this->db_onedev->query($sql); //echo $this->db_onedev->last_query(); } } else{ foreach($prm['trx']['details'] as $k => $v){ if($v['trx_id'] == 0 || $v['trx_id'] === '0'){ $sql = " INSERT so_resultentrydetail_other( So_ResultEntryDetailOtherM_LangID, So_ResultEntryDetailOtherSo_ResultEntryID, So_ResultEntryDetailOtherSo_TemplateDetailID, So_ResultEntryDetailOtherResult, So_ResultEntryDetailOtherCreated, So_ResultEntryDetailOtherUserID ) VALUES( {$prm['trx']['language_id']}, {$prm['trx']['trx_id']}, {$v['template_detail_id']}, '{$v['result_value']}', NOW(), {$userid} ) "; } else{ $sql = "UPDATE so_resultentrydetail_other SET So_ResultEntryDetailOtherResult = '{$v['result_value']}', So_ResultEntryDetailOtherUserID = {$userid} WHERE So_ResultEntryDetailOtherID = {$v['trx_id']}"; } $this->db_onedev->query($sql); //echo $this->db_onedev->last_query(); } } $last_id = $prm['trx']['trx_id']; $sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = {$last_id}"; $data_log_header = $this->db_onedev->query($sql)->result(); $sql = "SELECT * FROM so_resultentrydetail WHERE So_ResultEntryDetailSo_ResultEntryID = {$last_id}"; $data_log_details = $this->db_onedev->query($sql)->result(); $sql = "SELECT * FROM so_resultentrydetail_other WHERE So_ResultEntryDetailOtherSo_ResultEntryID = {$last_id}"; $data_log_other_details = $this->db_onedev->query($sql)->result(); $data_log = json_encode(array('header'=>$data_log_header,'details'=>$data_log_details,'details_other'=>$data_log_other_details)); $sql = "INSERT INTO one_log.log_resultentry_so ( Log_ResultEntrySoDate, Log_ResultEntrySoJSON, Log_ResultEntrySoUserID ) VALUES( NOW(), '{$data_log}', {$userid} )"; //echo $sql; $this->db_onedev->query($sql); $result = array( "total" => 1 , "records" => array('status'=>'OK') ); $this->sys_ok($result); exit; } function deletetrx(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $userid = $this->sys_user["M_UserID"]; $query ="UPDATE so_walklettercourier SET So_WalkLetterCourierIsActive = 'N', So_WalkLetterCourierUserID = '{$userid}' WHERE So_WalkLetterCourierID = {$prm['trx_id']} "; //echo $query; $saveheader = $this->db_onedev->query($query); $last_id = $prm['trx_id']; $sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = {$last_id}"; $data_log_header = $this->db_onedev->query($sql)->result(); $sql = "SELECT * FROM so_resultentrydetail WHERE So_ResultEntryDetailSo_ResultEntryID = {$last_id}"; $data_log_details = $this->db_onedev->query($sql)->result(); $data_log = json_encode(array('header'=>$data_log_header,'details'=>$data_log_details)); $sql = "INSERT INTO one_log.log_resultentry_so ( Log_ResultEntrySoDate, Log_ResultEntrySoJSON, Log_ResultEntrySoUserID ) VALUES( NOW(), '{$data_log}', {$userid} )"; //echo $sql; $this->db_onedev->query($sql); $result = array( "total" => 1 , "records" => array('status'=>'OK'), "numbering" => $prm['trx_numbering'], "id" => $prm['trx_id'] ); $this->sys_ok($result); exit; } function savedoctor(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $userid = $this->sys_user["M_UserID"]; $rst = array(); $sql = "UPDATE t_samplingso SET T_SamplingSoFlagDoctorInOffice = 'Y', T_SamplingSoM_DoctorID = {$prm['selected_doctor']['doctor_id']} WHERE T_SamplingSOID = {$prm['selected_detail']['T_SamplingSoID']}"; //echo $sql; $rst = $this->db_onedev->query($sql); $result = array( "total" => 1 , "records" => $rst ); $this->sys_ok($result); exit; } function savefisik(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $userid = $this->sys_user["M_UserID"]; $rst = array(); if($prm['act'] == 'UMUM' || $prm['act'] == 'UMUM_K3'){ $riwayats = json_encode($prm["riwayats"]); $sql = "INSERT INTO so_resultentry_fisik_umum ( So_ResultEntryFisikUmumSo_ResultEntryID, So_ResultEntryFisikUmumM_LangID, So_ResultEntryFisikUmumType, So_ResultEntryFisikUmumDetails, So_ResultEntryFisikUmumUserID, So_ResultEntryFisikUmumCreated ) VALUES( {$prm['trx']['trx_id']}, {$prm['trx']['language_id']}, 'riwayat', '{$riwayats}', {$userid}, NOW() ) ON DUPLICATE KEY UPDATE So_ResultEntryFisikUmumDetails = '{$riwayats}', So_ResultEntryFisikUmumUserID = {$userid} "; $rst = $this->db_onedev->query($sql); $fisiks = json_encode($prm["fisiks"]); $sql = "INSERT INTO so_resultentry_fisik_umum ( So_ResultEntryFisikUmumSo_ResultEntryID, So_ResultEntryFisikUmumM_LangID, So_ResultEntryFisikUmumType, So_ResultEntryFisikUmumDetails, So_ResultEntryFisikUmumUserID, So_ResultEntryFisikUmumCreated ) VALUES( {$prm['trx']['trx_id']}, {$prm['trx']['language_id']}, 'fisik', '{$fisiks}', {$userid}, NOW() ) ON DUPLICATE KEY UPDATE So_ResultEntryFisikUmumDetails = '{$fisiks}', So_ResultEntryFisikUmumUserID = {$userid} "; $rst = $this->db_onedev->query($sql); $umum_saran = $prm['umum_saran']; $sql = "INSERT INTO so_resultentry_fisik_umum ( So_ResultEntryFisikUmumSo_ResultEntryID, So_ResultEntryFisikUmumM_LangID, So_ResultEntryFisikUmumType, So_ResultEntryFisikUmumDetails, So_ResultEntryFisikUmumUserID, So_ResultEntryFisikUmumCreated ) VALUES( {$prm['trx']['trx_id']}, {$prm['trx']['language_id']}, 'saran', '{$umum_saran}', {$userid}, NOW() ) ON DUPLICATE KEY UPDATE So_ResultEntryFisikUmumDetails = '{$umum_saran}', So_ResultEntryFisikUmumUserID = {$userid} "; $rst = $this->db_onedev->query($sql); } if($prm['act'] == 'UMUM_K3'){ $k3s = json_encode($prm["k3s"]); $sql = "INSERT INTO so_resultentry_fisik_umum ( So_ResultEntryFisikUmumSo_ResultEntryID, So_ResultEntryFisikUmumM_LangID, So_ResultEntryFisikUmumType, So_ResultEntryFisikUmumDetails, So_ResultEntryFisikUmumUserID, So_ResultEntryFisikUmumCreated ) VALUES( {$prm['trx']['trx_id']}, {$prm['trx']['language_id']}, 'k3', '{$k3s}', {$userid}, NOW() ) ON DUPLICATE KEY UPDATE So_ResultEntryFisikUmumDetails = '{$k3s}', So_ResultEntryFisikUmumUserID = {$userid} "; $rst = $this->db_onedev->query($sql); } $result = array( "total" => 1 , "records" => $rst ); $this->sys_ok($result); exit; } function gettemplate(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $userid = $this->sys_user["M_UserID"]; $rst = array(); $sql = "SELECT So_TemplateLabelID as id, So_TemplateLabelName as label, '' as details FROM so_templatelabel WHERE So_TemplateLabelM_DoctorID = {$prm['doctor_id']} AND So_TemplateLabelT_TestID = {$prm['test_id']} AND So_TemplateLabelSo_TemplateID = {$prm['template_id']} AND So_TemplateLabelIsActive = 'Y'"; //echo $sql; $rst = $this->db_onedev->query($sql)->result(); if(!$rst){ $sql = "SELECT So_TemplateLabelID as id, So_TemplateLabelName as label, '' as details FROM so_templatelabel WHERE So_TemplateLabelM_DoctorID = 0 AND So_TemplateLabelT_TestID = {$prm['test_id']} AND So_TemplateLabelSo_TemplateID = {$prm['template_id']} AND So_TemplateLabelIsActive = 'Y'"; $rst = $this->db_onedev->query($sql)->result(); } if($rst){ foreach($rst as $k => $v){ $sql = "SELECT so_templatevalueid as id, So_TemplateValueText as value, So_TemplateValueSo_TemplateDetailID as template_detail_id FROM so_templatevalue JOIN so_templatedetail ON So_TemplateValueSo_TemplateDetailID = So_TemplateDetailID AND So_TemplateDetailM_LangID = {$prm['language_id']} WHERE So_TemplateValueSo_TemplateLabelID = {$v->id} AND So_TemplateValueIsActive = 'Y' "; //echo $sql; $v->details = $this->db_onedev->query($sql)->result(); } } $result = array( "total" => 1 , "records" => $rst ); $this->sys_ok($result); exit; } function printcount(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $userid = $this->sys_user["M_UserID"]; $trx_id = $prm["trx_id"]; $sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = '{$trx_id}'"; $orderdetail_id = $this->db_onedev->query($sql)->row()->So_ResultEntryT_OrderDetailID; $sql = "UPDATE t_orderdetail SET T_OrderDetailPrintCount = T_OrderDetailPrintCount + 1 WHERE T_OrderDetailID = '{$orderdetail_id}'"; $this->db_onedev->query($sql); $result = array( "total" => 1 , "records" => $prm ); $this->sys_ok($result); exit; } function save_flagprint(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $rst_data = array('status'=>'OK'); $prm = $this->sys_input; $row = $prm['row']; $selected_trx = $prm['selected_trx']; $userid = $this->sys_user["M_UserID"]; $sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = '{$selected_trx['re_id']}'"; //echo $sql; $re_langid = $this->db_onedev->query($sql)->row()->So_ResultEntryM_LangID; if($re_langid == $prm['selected_trx']['language_id']){ $sql = "UPDATE so_resultentrydetail SET So_ResultEntryDetailFlagPrint = '{$row['flag_print']}', So_ResultEntryDetailUserID = {$userid} WHERE So_ResultEntryDetailID = {$row['trx_id']}"; //echo $sql; $this->db_onedev->query($sql); } else{ $sql = "UPDATE so_resultentrydetail_other SET So_ResultEntryDetailOtherFlagPrint = '{$row['flag_print']}', So_ResultEntryDetailOtherUserID = {$userid} WHERE So_ResultEntryDetailOtherID = {$row['trx_id']}"; //echo $sql; $this->db_onedev->query($sql); } $result = array( "total" => 1 , "records" => $rst_data ); $this->sys_ok($result); exit; } function getrstbylang(){ if (! $this->isLogin) { $this->sys_error("Invalid Token"); exit; } $prm = $this->sys_input; $x_langid = $prm['lang']['id']; $x_reid = $prm['detail']['trx_id']; $sql = "SELECT * FROM so_resultentry WHERE So_ResultEntryID = '{$x_reid}'"; //echo $sql; $re_langid = $this->db_onedev->query($sql)->row()->So_ResultEntryM_LangID; if($x_langid == $re_langid){ $sql = "SELECT So_ResultEntryDetailID as trx_id, So_ResultEntryDetailSo_TemplateDetailID as template_detail_id, So_TemplateDetailName as result_label, IFNULL(So_ResultEntryDetailResult,'') as result_value FROM so_resultentrydetail JOIN so_templatedetail ON So_TemplateDetailID = So_ResultEntryDetailSo_TemplateDetailID JOIN so_resultentry ON So_ResultEntryDetailSo_ResultEntryID = So_ResultEntryID AND So_ResultEntryM_LangID = {$x_langid} WHERE So_ResultEntryDetailSo_ResultEntryID = {$x_reid} AND So_ResultEntryDetailisActive = 'Y' "; }else{ $sql = " SELECT IFNULL(So_ResultEntryDetailOtherID,0) as trx_id, So_TemplateDetailID as template_detail_id, So_TemplateDetailName as result_label, So_ResultEntryDetailOtherResult as result_value FROM so_resultentry JOIN t_orderdetail ON T_OrderDetailID = So_ResultEntryT_OrderDetailID JOIN so_testtemplate ON So_TestTemplateT_TestID = T_OrderDetailT_TestID JOIN so_templatedetail ON So_TemplateDetailSo_TemplateID = So_TestTemplateSo_TemplateID AND So_TemplateDetailM_LangID = {$x_langid} LEFT JOIN so_resultentrydetail_other ON So_ResultEntryDetailOtherM_LangID = So_TemplateDetailM_LangID AND So_ResultEntryDetailOtherSo_ResultEntryID = So_ResultEntryID AND So_ResultEntryDetailOtherSo_TemplateDetailID = So_TemplateDetailID AND So_ResultEntryDetailOtherIsActive = 'Y' WHERE So_ResultEntryID = {$x_reid} AND So_ResultEntryIsActive = 'Y' "; } //echo $sql; $rst = $this->db_onedev->query($sql)->result_array(); $result = array( "total" => 1 , "records" => $rst ); $this->sys_ok($result); exit; } /* -- Adminer 4.7.5 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `fisik_templateresult`; CREATE TABLE `fisik_templateresult` ( `Fisik_TemplateResultID` int(11) NOT NULL AUTO_INCREMENT, `Fisik_TemplateResultM_LangID` int(11) NOT NULL, `Fisik_TemplateResultType` varchar(15) NOT NULL, `Fisik_TemplateResultText` text NOT NULL, `Fisik_TemplateResultIsActive` char(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (`Fisik_TemplateResultID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO `fisik_templateresult` (`Fisik_TemplateResultID`, `Fisik_TemplateResultM_LangID`, `Fisik_TemplateResultType`, `Fisik_TemplateResultText`, `Fisik_TemplateResultIsActive`) VALUES (1, 1, 'riwayat', '[{\"title\":\"KELUHAN SAAT INI\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada keluhan\",\"flag_normal\":\"Y\",\"show_all\":\"N\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_1\",\"id\":\"1\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Demam\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_2\",\"id\":\"2\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Nyeri Kepala\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_3\",\"id\":\"3\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Batuk dan influensa\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_4\",\"id\":\"4\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Batuk lebih dari 1 bulan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_5\",\"id\":\"5\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Pusing atau rasa berputar (vertigo)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_6\",\"id\":\"6\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lemas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_7\",\"id\":\"7\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan mata atau penglihatan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_8\",\"id\":\"8\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Mata berkunang-kunang\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_9\",\"id\":\"9\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan pendengaran\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_10\",\"id\":\"10\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Nyeri dada\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_11\",\"id\":\"11\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Sesak Napas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_12\",\"id\":\"12\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Sakit Jantung\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_13\",\"id\":\"13\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Hipertensi / tekanan darah tinggi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_14\",\"id\":\"14\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Tidak nafsu makan lebih dari 1 bulan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_15\",\"id\":\"15\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gastritis (maag)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_16\",\"id\":\"16\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Nyeri perut atau gangguan pencernaan lainnya\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_17\",\"id\":\"17\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Haemorrhoid (wasir/ambeien)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_18\",\"id\":\"18\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Diare berulang / lama (kronis)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_19\",\"id\":\"19\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Sakit pinggang\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_20\",\"id\":\"20\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan berkemih\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_21\",\"id\":\"21\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan ginjal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_22\",\"id\":\"22\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan pada alat reproduksi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_23\",\"id\":\"23\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Nyeri otot dan sendi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_24\",\"id\":\"24\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kesemutan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_25\",\"id\":\"25\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Bengkak pada kaki atau anggota badan lainnya\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_26\",\"id\":\"26\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gatal atau gangguan kulit lainnya\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_27\",\"id\":\"27\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Benjolan abnormal pada bagian tubuh\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_keluhan\",\"id_code\":\"fisik_keluhan_28\",\"id\":\"28\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Keluhan lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"RIWAYAT POBIA\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada pobia\",\"flag_normal\":\"Y\",\"show_all\":\"N\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_1\",\"id\":\"1\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Rasa takut yang berlebihan (phobia)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_2\",\"id\":\"2\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Takut ketinggian\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_3\",\"id\":\"3\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Takut di ruangan gelap\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_4\",\"id\":\"4\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Takut melihat darah\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_5\",\"id\":\"5\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Takut di ruang sempit\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_6\",\"id\":\"6\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Takut berada di tengah laut\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_7\",\"id\":\"7\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Takut naik pesawat/helikopter\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_pobia\",\"id_code\":\"fisik_pobia_8\",\"id\":\"8\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Mabuk laut atau mabuk perjalanan\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"RIWAYAT PENYAKIT\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada riwayat penyakit\",\"flag_normal\":\"Y\",\"show_all\":\"N\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"System Pencernaan\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_1\",\"id\":\"1\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gastritis (maag)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_2\",\"id\":\"2\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Hepatitis (penyakit hati/kuning)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_3\",\"id\":\"3\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Batu empedu\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_4\",\"id\":\"4\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Demam typoid\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_5\",\"id\":\"5\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Haemorrhoid (wasir/ambeien)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_6\",\"id\":\"6\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Operasi saluran pencernaan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pencernaan\",\"id_code\":\"fisik_penyakit_7\",\"id\":\"7\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Pencernaan )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"System Pernafasan\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pernafasan\",\"id_code\":\"fisik_penyakit_8\",\"id\":\"8\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Asma\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pernafasan\",\"id_code\":\"fisik_penyakit_9\",\"id\":\"9\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Tuberculosa (TBC)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pernafasan\",\"id_code\":\"fisik_penyakit_10\",\"id\":\"10\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Batuk lebih dari 1 bulan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pernafasan\",\"id_code\":\"fisik_penyakit_11\",\"id\":\"11\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Pneumonia\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Pernafasan\",\"id_code\":\"fisik_penyakit_12\",\"id\":\"12\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Pernafasan )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"System cardiovaskuler\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System cardiovaskuler\",\"id_code\":\"fisik_penyakit_13\",\"id\":\"13\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit jantung\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System cardiovaskuler\",\"id_code\":\"fisik_penyakit_14\",\"id\":\"14\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Hipertensi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System cardiovaskuler\",\"id_code\":\"fisik_penyakit_15\",\"id\":\"15\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Stroke\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System cardiovaskuler\",\"id_code\":\"fisik_penyakit_16\",\"id\":\"16\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Pasang pen atau ring\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System cardiovaskuler\",\"id_code\":\"fisik_penyakit_17\",\"id\":\"17\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Anemia\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System cardiovaskuler\",\"id_code\":\"fisik_penyakit_18\",\"id\":\"18\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Cardiovaskuler )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Sistem Saraf\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Saraf\",\"id_code\":\"fisik_penyakit_19\",\"id\":\"19\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Vertigo (pusing memutar)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Saraf\",\"id_code\":\"fisik_penyakit_20\",\"id\":\"20\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Epilepsi (ayan), kejang, pingsan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Saraf\",\"id_code\":\"fisik_penyakit_21\",\"id\":\"21\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Polio\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Saraf\",\"id_code\":\"fisik_penyakit_22\",\"id\":\"22\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan mental / kejiwaan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Saraf\",\"id_code\":\"fisik_penyakit_23\",\"id\":\"23\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Mengalami cidera kepala\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Saraf\",\"id_code\":\"fisik_penyakit_24\",\"id\":\"24\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Syaraf )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Sistem Penglihatan\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Penglihatan\",\"id_code\":\"fisik_penyakit_25\",\"id\":\"25\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kacamata Minus\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Penglihatan\",\"id_code\":\"fisik_penyakit_26\",\"id\":\"26\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kacamata (+)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Penglihatan\",\"id_code\":\"fisik_penyakit_27\",\"id\":\"27\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kacamata Silender\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Penglihatan\",\"id_code\":\"fisik_penyakit_28\",\"id\":\"28\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Trauma\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Penglihatan\",\"id_code\":\"fisik_penyakit_29\",\"id\":\"29\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Fotopobia\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Penglihatan\",\"id_code\":\"fisik_penyakit_30\",\"id\":\"30\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Penglihatan )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Sistem Pendengaran/THT\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_31\",\"id\":\"31\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan Pendengaran\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_32\",\"id\":\"32\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Sinusitis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_33\",\"id\":\"33\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Rhinitis Allergika\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_34\",\"id\":\"34\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Amandel/tonsilitis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_35\",\"id\":\"35\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Otitis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_36\",\"id\":\"36\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Trauma\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Sistem Pendengaran/THT\",\"id_code\":\"fisik_penyakit_37\",\"id\":\"37\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Pendengaran/THT )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Ginjal & Saluran Kemih\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Ginjal & Saluran Kemih\",\"id_code\":\"fisik_penyakit_38\",\"id\":\"38\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Batu ginjal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Ginjal & Saluran Kemih\",\"id_code\":\"fisik_penyakit_39\",\"id\":\"39\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit ginjal (akut/kronis)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Ginjal & Saluran Kemih\",\"id_code\":\"fisik_penyakit_40\",\"id\":\"40\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Infeksi saluran kemih\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Ginjal & Saluran Kemih\",\"id_code\":\"fisik_penyakit_41\",\"id\":\"41\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Operasi saluran kemih\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Ginjal & Saluran Kemih\",\"id_code\":\"fisik_penyakit_42\",\"id\":\"42\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Ginjal & Saluran Kemih )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Tulang, Sendi & Otot\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_43\",\"id\":\"43\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Patah tulang\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_44\",\"id\":\"44\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Radang sendi (arthritis)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_45\",\"id\":\"45\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Rheumatik\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_46\",\"id\":\"46\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kecelakaan / cidera / trauma / luka parah\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_47\",\"id\":\"47\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Nyeri otot lebih dari 1 bulan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_48\",\"id\":\"48\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Nyeri punggung / back pain\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Tulang, Sendi & Otot\",\"id_code\":\"fisik_penyakit_49\",\"id\":\"49\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Tulang, Sendi & Otot )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Kulit & system reproduksi\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_50\",\"id\":\"50\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan alat reproduksi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_51\",\"id\":\"51\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kista / tumor / kanker alat reproduksi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_52\",\"id\":\"52\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit Akibat Hubungan Sex\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_53\",\"id\":\"53\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"HIV\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_54\",\"id\":\"54\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lepra\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_55\",\"id\":\"55\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit kulit yang lama / kronis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Kulit & system reproduksi\",\"id_code\":\"fisik_penyakit_56\",\"id\":\"56\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Kulit & Sistem Reproduksi )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"System Endokrin\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Endokrin\",\"id_code\":\"fisik_penyakit_57\",\"id\":\"57\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Diabetes Militus (Kencing manis)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Endokrin\",\"id_code\":\"fisik_penyakit_58\",\"id\":\"58\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan tiroid (gondok, hipo/hipertiroid)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"System Endokrin\",\"id_code\":\"fisik_penyakit_59\",\"id\":\"59\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Sistem Endokrin )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Allergi\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Allergi\",\"id_code\":\"fisik_penyakit_60\",\"id\":\"60\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Allergi Obat\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Allergi\",\"id_code\":\"fisik_penyakit_61\",\"id\":\"61\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Allergi Makanan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Allergi\",\"id_code\":\"fisik_penyakit_62\",\"id\":\"62\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Allergi Hirupan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Allergi\",\"id_code\":\"fisik_penyakit_63\",\"id\":\"63\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Allergi Kontak\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Allergi\",\"id_code\":\"fisik_penyakit_64\",\"id\":\"64\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Allergi )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Penyakit daerah tropis\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit daerah tropis\",\"id_code\":\"fisik_penyakit_65\",\"id\":\"65\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"DHF / Demam berdarah\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit daerah tropis\",\"id_code\":\"fisik_penyakit_66\",\"id\":\"66\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Malaria\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit daerah tropis\",\"id_code\":\"fisik_penyakit_67\",\"id\":\"67\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Typoid\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit daerah tropis\",\"id_code\":\"fisik_penyakit_68\",\"id\":\"68\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Penyakit daerah tropis )\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Penyakit lainnya\",\"details\":[{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit lainnya\",\"id_code\":\"fisik_penyakit_69\",\"id\":\"69\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Tumor / kanker\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit lainnya\",\"id_code\":\"fisik_penyakit_70\",\"id\":\"70\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Leukimia\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit lainnya\",\"id_code\":\"fisik_penyakit_71\",\"id\":\"71\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Pernah operasi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakit\",\"segment_name\":\"Penyakit lainnya\",\"id_code\":\"fisik_penyakit_72\",\"id\":\"72\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lain-lain ( Penyakit lainnya )\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"RIWAYAT PENYAKIT KELUARGA\",\"subtitle\":\"Apakah orang tua, kakek nenek, saudara kandung atau keluarga dekat menderita penyakit dibawah ini ?\",\"label_flag_normal\":\"Tidak ada riwayat penyakit\",\"flag_normal\":\"Y\",\"show_all\":\"N\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_1\",\"id\":\"1\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Diabetes Millitus\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_2\",\"id\":\"2\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Hypertensi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_3\",\"id\":\"3\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Stroke\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_4\",\"id\":\"4\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit Jantung\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_5\",\"id\":\"5\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit Ginjal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_6\",\"id\":\"6\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"TBC\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_7\",\"id\":\"7\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Lepra\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_8\",\"id\":\"8\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Penyakit hati / hepatitis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_9\",\"id\":\"9\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Epilepsi (ayan)\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_10\",\"id\":\"10\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Gangguan jiwa\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_11\",\"id\":\"11\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kanker / tumor ganas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_12\",\"id\":\"12\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Autoimmum / Rheumatik / Lupus\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_penyakitkeluarga\",\"id_code\":\"fisik_penyakitkeluarga_13\",\"id\":\"13\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Asma\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"RIWAYAT KEBIASAAN HIDUP\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada riwayat kebiasaan hidup\",\"flag_normal\":\"Y\",\"show_all\":\"N\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Minum alkohol\",\"details\":[{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Minum alkohol\",\"id_code\":\"fisik_kebiasaanhidup_1\",\"id\":\"1\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Tidak\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Minum alkohol\",\"id_code\":\"fisik_kebiasaanhidup_2\",\"id\":\"2\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kadang-kadang\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Minum alkohol\",\"id_code\":\"fisik_kebiasaanhidup_3\",\"id\":\"3\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Rutin\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Olahraga\",\"details\":[{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Olahraga\",\"id_code\":\"fisik_kebiasaanhidup_4\",\"id\":\"4\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Tidak\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Olahraga\",\"id_code\":\"fisik_kebiasaanhidup_5\",\"id\":\"5\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kadang-kadang\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Olahraga\",\"id_code\":\"fisik_kebiasaanhidup_6\",\"id\":\"6\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Rutin\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Merokok\",\"details\":[{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Merokok\",\"id_code\":\"fisik_kebiasaanhidup_8\",\"id\":\"8\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Tidak\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Merokok\",\"id_code\":\"fisik_kebiasaanhidup_9\",\"id\":\"9\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Kadang-kadang\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_kebiasaanhidup\",\"segment_name\":\"Merokok\",\"id_code\":\"fisik_kebiasaanhidup_10\",\"id\":\"10\",\"lang_id\":\"1\",\"type\":\"RIWAYAT\",\"category\":\"UMUM\",\"label\":\"Rutin\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"RIWAYAT KONSUMSI OBAT TERATUR\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"N\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"fisik_konsumsiobatteratur\",\"id_code\":\"fisik_konsumsiobatteratur_1\",\"id\":\"1\",\"lang_id\":\"1\",\"type\":\"UMUM\",\"category\":\"RIWAYAT\",\"label\":\"Obat anti Diabetes Millitus\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_konsumsiobatteratur\",\"id_code\":\"fisik_konsumsiobatteratur_2\",\"id\":\"2\",\"lang_id\":\"1\",\"type\":\"UMUM\",\"category\":\"RIWAYAT\",\"label\":\"Obat anti hypertensi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"fisik_konsumsiobatteratur\",\"id_code\":\"fisik_konsumsiobatteratur_3\",\"id\":\"3\",\"lang_id\":\"1\",\"type\":\"UMUM\",\"category\":\"RIWAYAT\",\"label\":\"Obat lainnya\",\"chx\":false,\"value\":\"\"}]}]', 'Y'), (2, 1, 'fisik', '[{\"title\":\"TANDA VITAL\",\"show_all\":\"Y\",\"type_form\":\"VXX\",\"details\":[{\"table_name\":\"tanda_vital\",\"id_code\":\"tanda_vital_1\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Denyut nadi\",\"value\":\"\",\"unit\":\"x/menit\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"tanda_vital\",\"id_code\":\"tanda_vital_2\",\"lang_id\":\"1\",\"type\":\"vxx-xx\",\"label\":\"Ritme denyut nadi\",\"value\":\"\",\"unit\":\"\",\"chx_y\":true,\"label_y\":\"Reguler\",\"chx_x\":false,\"label_x\":\"Ireguler\"},{\"table_name\":\"tanda_vital\",\"id_code\":\"tanda_vital_3\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Laju pernafasan\",\"value\":\"\",\"unit\":\"x/menit\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"tanda_vital\",\"id_code\":\"tanda_vital_4\",\"lang_id\":\"1\",\"type\":\"vxx-xx\",\"label\":\"Pola nafas\",\"value\":\"\",\"unit\":\"\",\"chx_y\":true,\"label_y\":\"Normal\",\"chx_x\":false,\"label_x\":\"Tidak normal\"},{\"table_name\":\"tanda_vital\",\"id_code\":\"tanda_vital_5\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Tekanan Darah\",\"value\":\"\",\"unit\":\"mmHg\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"tanda_vital\",\"id_code\":\"tanda_vital_4\",\"lang_id\":\"1\",\"type\":\"vxx-xx\",\"label\":\"Suhu\",\"value\":\"\",\"unit\":\"\",\"chx_y\":true,\"label_y\":\"Normal\",\"chx_x\":false,\"label_x\":\"Demam\"}]},{\"title\":\"STATUS GIZI\",\"show_all\":\"Y\",\"type_form\":\"VXX\",\"details\":[{\"table_name\":\"status_gizi\",\"id_code\":\"status_gizi_1\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Berat badan\",\"value\":\"\",\"unit\":\"kg\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"status_gizi\",\"id_code\":\"status_gizi_2\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Tinggi badan\",\"value\":\"\",\"unit\":\"cm\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"status_gizi\",\"id_code\":\"status_gizi_3\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Lingkar perut\",\"value\":\"\",\"unit\":\"cm\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"status_gizi\",\"id_code\":\"status_gizi_4\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"BMI\",\"value\":\"\",\"unit\":\"\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"},{\"table_name\":\"status_gizi\",\"id_code\":\"status_gizi_5\",\"lang_id\":\"1\",\"type\":\"vxx-v\",\"label\":\"Lingkar pinggang / Panggul\",\"value\":\"\",\"unit\":\"cm\",\"chx_y\":false,\"label_y\":\"\",\"chx_x\":false,\"label_x\":\"\"}]},{\"title\":\"KEADAAN UMUM\",\"show_all\":\"Y\",\"type_form\":\"XXV\",\"details\":[{\"table_name\":\"keadaan_umum\",\"id_code\":\"keadaan_umum_1\",\"lang_id\":\"1\",\"type\":\"\",\"label\":\"Kesadaran\",\"value\":\"\",\"unit\":\"\",\"chx_y\":true,\"label_y\":\"Normal\",\"chx_x\":false,\"label_x\":\"Tidak Normal\"},{\"table_name\":\"keadaan_umum\",\"id_code\":\"keadaan_umum_2\",\"lang_id\":\"1\",\"type\":\"\",\"label\":\"Sikap & tingkah laku\",\"value\":\"\",\"unit\":\"\",\"chx_y\":true,\"label_y\":\"Normal\",\"chx_x\":false,\"label_x\":\"Tidak Normal\"},{\"table_name\":\"keadaan_umum\",\"id_code\":\"keadaan_umum_3\",\"lang_id\":\"1\",\"type\":\"\",\"label\":\"Kontak psikis / perhatian\",\"value\":\"\",\"unit\":\"\",\"chx_y\":true,\"label_y\":\"Normal\",\"chx_x\":false,\"label_x\":\"Tidak Normal\"}]},{\"title\":\"KEPALA WAJAH\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"kepala_wajah\",\"id_code\":\"kepala_wajah_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"kepala_wajah\",\"id_code\":\"kepala_wajah_2\",\"lang_id\":\"1\",\"label\":\"Deformitas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"kepala_wajah\",\"id_code\":\"kepala_wajah_3\",\"lang_id\":\"1\",\"label\":\"Luka\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"kepala_wajah\",\"id_code\":\"kepala_wajah_4\",\"lang_id\":\"1\",\"label\":\"Tumor\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"kepala_wajah\",\"id_code\":\"kepala_wajah_5\",\"lang_id\":\"1\",\"label\":\"Kepala benjol\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"kepala_wajah\",\"id_code\":\"kepala_wajah_6\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"MATA\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"mata\",\"id_code\":\"mata_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_2\",\"lang_id\":\"1\",\"label\":\"Strabismus\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_3\",\"lang_id\":\"1\",\"label\":\"Hiperemis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_4\",\"lang_id\":\"1\",\"label\":\"Ikterik\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_5\",\"lang_id\":\"1\",\"label\":\"Sekret\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_6\",\"lang_id\":\"1\",\"label\":\"Pterigium\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_7\",\"lang_id\":\"1\",\"label\":\"Lensa keruh\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_8\",\"lang_id\":\"1\",\"label\":\"Anemis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_9\",\"lang_id\":\"1\",\"label\":\"Merah\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mata\",\"id_code\":\"mata_10\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"PERSEPSI WARNA\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"persepsi_warna\",\"id_code\":\"persepsi_warna_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"persepsi_warna\",\"id_code\":\"persepsi_warna_2\",\"lang_id\":\"1\",\"label\":\"Buta warna parsial\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"persepsi_warna\",\"id_code\":\"persepsi_warna_3\",\"lang_id\":\"1\",\"label\":\"Hiperemis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"persepsi_warna\",\"id_code\":\"persepsi_warna_4\",\"lang_id\":\"1\",\"label\":\"Buta warna total\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"VISUS JAUH\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Tanpa kacamata\",\"details\":[{\"table_name\":\"visus_jauh\",\"segment_name\":\"Tanpa kacamata\",\"id_code\":\"visus_jauh_1\",\"lang_id\":\"1\",\"label\":\"-OD\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"visus_jauh\",\"segment_name\":\"Tanpa kacamata\",\"id_code\":\"visus_jauh_2\",\"lang_id\":\"1\",\"label\":\"-OS\",\"chx\":true,\"value\":\"\"}]},{\"name\":\"Dengan kacamata\",\"details\":[{\"table_name\":\"visus_jauh\",\"segment_name\":\"Dengan kacamata\",\"id_code\":\"visus_jauh_3\",\"lang_id\":\"1\",\"label\":\"-OD\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"visus_jauh\",\"segment_name\":\"Dengan kacamata\",\"id_code\":\"visus_jauh_4\",\"lang_id\":\"1\",\"label\":\"-Os\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"TELINGA\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"telinga\",\"id_code\":\"telinga_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"telinga\",\"id_code\":\"telinga_2\",\"lang_id\":\"1\",\"label\":\"Tanda infeksi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"telinga\",\"id_code\":\"telinga_3\",\"lang_id\":\"1\",\"label\":\"Serumen\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"telinga\",\"id_code\":\"telinga_4\",\"lang_id\":\"1\",\"label\":\"Perforasi MT\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"telinga\",\"id_code\":\"telinga_5\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"HIDUNG\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"hidung\",\"id_code\":\"hidung_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"hidung\",\"id_code\":\"hidung_2\",\"lang_id\":\"1\",\"label\":\"Hiperemis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"hidung\",\"id_code\":\"hidung_3\",\"lang_id\":\"1\",\"label\":\"Oedem\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"hidung\",\"id_code\":\"hidung_4\",\"lang_id\":\"1\",\"label\":\"Deviasi Septum\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"MULUT\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Mukosa rongga mulut\",\"details\":[{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Mukosa rongga mulut\",\"id_code\":\"mukosa_rongga_mulut_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Mukosa rongga mulut\",\"id_code\":\"mukosa_rongga_mulut_2\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Tenggorokan\",\"details\":[{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Tenggorokan\",\"id_code\":\"tenggorokan_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Tenggorokan\",\"id_code\":\"tenggorokan_2\",\"lang_id\":\"1\",\"label\":\"Hiperemis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Tenggorokan\",\"id_code\":\"tenggorokan_3\",\"lang_id\":\"1\",\"label\":\"Tonsil hipertrofi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Tenggorokan\",\"id_code\":\"tenggorokan_4\",\"lang_id\":\"1\",\"label\":\"Deviasi uvula\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"mukosa_rongga_mulut\",\"segment_name\":\"Tenggorokan\",\"id_code\":\"tenggorokan_5\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"LEHER\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"leher\",\"id_code\":\"hidung_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"leher\",\"id_code\":\"leher_2\",\"lang_id\":\"1\",\"label\":\"Spasme\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"leher\",\"id_code\":\"leher_3\",\"lang_id\":\"1\",\"label\":\"Pembesaran tiroid\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"leher\",\"id_code\":\"leher_4\",\"lang_id\":\"1\",\"label\":\"Pembesaran kelenjar limfe\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"leher\",\"id_code\":\"leher_5\",\"lang_id\":\"1\",\"label\":\"JVP meningkat\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"leher\",\"id_code\":\"leher_5\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"THORAX / DADA\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"thorax\",\"id_code\":\"thorax_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"thorax\",\"id_code\":\"thorax_2\",\"lang_id\":\"1\",\"label\":\"Deformitas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"thorax\",\"id_code\":\"thorax_3\",\"lang_id\":\"1\",\"label\":\"Tumor mammae\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"thorax\",\"id_code\":\"thorax_4\",\"lang_id\":\"1\",\"label\":\"Gineko mastia\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"thorax\",\"id_code\":\"thorax_5\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"PARU-PARU\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"paru\",\"id_code\":\"paru_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"}]},{\"title\":\"PEMERIKSAAN FISIK\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"pemeriksaan_fisik\",\"id_code\":\"pemeriksaan_fisik_1\",\"lang_id\":\"1\",\"label\":\"Gerak asimetris\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"pemeriksaan_fisik\",\"id_code\":\"pemeriksaan_fisik_2\",\"lang_id\":\"1\",\"label\":\"Perkusi abnormal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"pemeriksaan_fisik\",\"id_code\":\"pemeriksaan_fisik_3\",\"lang_id\":\"1\",\"label\":\"Suara nafas tambahan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"pemeriksaan_fisik\",\"id_code\":\"pemeriksaan_fisik_4\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"JANTUNG\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"JVP\",\"details\":[{\"table_name\":\"jantung\",\"segment_name\":\"JVP\",\"id_code\":\"jantung_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"jantung\",\"segment_name\":\"JVP\",\"id_code\":\"jantung_2\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Apex\",\"details\":[{\"table_name\":\"jantung\",\"segment_name\":\"Apex\",\"id_code\":\"jantung_3\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"jantung\",\"segment_name\":\"Apex\",\"id_code\":\"jantung_4\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Suara jantung\",\"details\":[{\"table_name\":\"jantung\",\"segment_name\":\"Suara jantung\",\"id_code\":\"jantung_5\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"jantung\",\"segment_name\":\"Suara jantung\",\"id_code\":\"jantung_6\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Bising jantung / Murmur\",\"details\":[{\"table_name\":\"jantung\",\"segment_name\":\"Bising jantung / Murmur\",\"id_code\":\"jantung_7\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"jantung\",\"segment_name\":\"Bising jantung / Murmur\",\"id_code\":\"jantung_8\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"PERUT / ABDOMEN\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Abdomen\",\"details\":[{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_2\",\"lang_id\":\"1\",\"label\":\"Nyeri tekan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_3\",\"lang_id\":\"1\",\"label\":\"Nyeri ketok ginjal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_4\",\"lang_id\":\"1\",\"label\":\"Shifting Dulness\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_5\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Bising Usus\",\"details\":[{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_6\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_7\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Hati\",\"details\":[{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_8\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_9\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Limpa\",\"details\":[{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_11\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_12\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Hernia\",\"details\":[{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_13\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_14\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Hemorroid\",\"details\":[{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_15\",\"lang_id\":\"1\",\"label\":\"Tidak diperiksa\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_16\",\"lang_id\":\"1\",\"label\":\"Tidak Ada\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"perut\",\"segment_name\":\"Abdomen\",\"id_code\":\"perut_17\",\"lang_id\":\"1\",\"label\":\"Ada\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"GENITOURINARIA\",\"subtitle\":\"\",\"label_flag_normal\":\"Tidak ada\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XV\",\"details\":[{\"table_name\":\"genitourinaria\",\"id_code\":\"genitourinaria_1\",\"lang_id\":\"1\",\"label\":\"Tidak diperiksa\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"genitourinaria\",\"id_code\":\"genitourinaria_2\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"genitourinaria\",\"id_code\":\"genitourinaria_3\",\"lang_id\":\"1\",\"label\":\"Retensi Urin\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"genitourinaria\",\"id_code\":\"genitourinaria_4\",\"lang_id\":\"1\",\"label\":\"Tanda Infeksi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"genitourinaria\",\"id_code\":\"genitourinaria_5\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"title\":\"ANGGOTA GERAK\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Ekstrimitas atas\",\"details\":[{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_2\",\"lang_id\":\"1\",\"label\":\"Deformitas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_3\",\"lang_id\":\"1\",\"label\":\"Tremor\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_4\",\"lang_id\":\"1\",\"label\":\"Oedem\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_5\",\"lang_id\":\"1\",\"label\":\"Palmer eritem\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_6\",\"lang_id\":\"1\",\"label\":\"Penurunan Kekuatan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas atas\",\"id_code\":\"anggota_gerak_7\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Ekstrimitas bawah\",\"details\":[{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_8\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_9\",\"lang_id\":\"1\",\"label\":\"Deformitas\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_10\",\"lang_id\":\"1\",\"label\":\"Varices\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_11\",\"lang_id\":\"1\",\"label\":\"Oedem\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_12\",\"lang_id\":\"1\",\"label\":\"Vascularisasi abnormal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_13\",\"lang_id\":\"1\",\"label\":\"Penurunan Kekuatan\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Ekstrimitas bawah\",\"id_code\":\"anggota_gerak_15\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Tonus / otot\",\"details\":[{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Tonus / otot\",\"id_code\":\"anggota_gerak_16\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Tonus / otot\",\"id_code\":\"anggota_gerak_17\",\"lang_id\":\"1\",\"label\":\"Paresis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Tonus / otot\",\"id_code\":\"anggota_gerak_18\",\"lang_id\":\"1\",\"label\":\"Paralysis\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Tonus / otot\",\"id_code\":\"anggota_gerak_19\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Bising anggota_gerak / Murmur\",\"details\":[{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Bising anggota_gerak / Murmur\",\"id_code\":\"anggota_gerak_7\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"anggota_gerak\",\"segment_name\":\"Bising anggota_gerak / Murmur\",\"id_code\":\"anggota_gerak_8\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"SISTEM PERSYARAFAN\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Refleks Fisiologis\",\"details\":[{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Fisiologis\",\"id_code\":\"sistem_persyarafan_1\",\"lang_id\":\"1\",\"label\":\"Tonus / otot\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Fisiologis\",\"id_code\":\"sistem_persyarafan_2\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Fisiologis\",\"id_code\":\"sistem_persyarafan_3\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Refleks Pathologis\",\"details\":[{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Pathologis\",\"id_code\":\"sistem_persyarafan_4\",\"lang_id\":\"1\",\"label\":\"Tidak ada\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Pathologis\",\"id_code\":\"sistem_persyarafan_5\",\"lang_id\":\"1\",\"label\":\"Ada\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Keseimbangan & Koordinasi\",\"details\":[{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Keseimbangan & Koordinasi\",\"id_code\":\"sistem_persyarafan_6\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Keseimbangan & Koordinasi\",\"id_code\":\"sistem_persyarafan_7\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Refleks Neurologis Lainnya\",\"details\":[{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Neurologis Lainnya\",\"id_code\":\"sistem_persyarafan_8\",\"lang_id\":\"1\",\"label\":\"Tidak ada\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_persyarafan\",\"segment_name\":\"Refleks Neurologis Lainnya\",\"id_code\":\"sistem_persyarafan_9\",\"lang_id\":\"1\",\"label\":\"Ada\",\"chx\":false,\"value\":\"\"}]}]},{\"title\":\"SISTEM INTEGUMEN\",\"subtitle\":\"\",\"label_flag_normal\":\"\",\"flag_normal\":\"Y\",\"show_all\":\"Y\",\"type_form\":\"XVS\",\"details\":[{\"name\":\"Kulit\",\"details\":[{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kulit\",\"id_code\":\"sistem_integumen_1\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kulit\",\"id_code\":\"sistem_integumen_2\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kulit\",\"id_code\":\"sistem_integumen_3\",\"lang_id\":\"1\",\"label\":\"Bekas Operasi\",\"chx\":false,\"value\":\"\"},{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kulit\",\"id_code\":\"sistem_integumen_4\",\"lang_id\":\"1\",\"label\":\"Lain-lain\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Kuku\",\"details\":[{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kuku\",\"id_code\":\"sistem_integumen_5\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kuku\",\"id_code\":\"sistem_integumen_6\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]},{\"name\":\"Rambut\",\"details\":[{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kuku\",\"id_code\":\"sistem_integumen_7\",\"lang_id\":\"1\",\"label\":\"Normal\",\"chx\":true,\"value\":\"\"},{\"table_name\":\"sistem_integumen\",\"segment_name\":\"Kuku\",\"id_code\":\"sistem_integumen_8\",\"lang_id\":\"1\",\"label\":\"Tidak Normal\",\"chx\":false,\"value\":\"\"}]}]}]', 'Y'); -- 2019-12-15 14:10:04 */ }