1879 lines
69 KiB
PHP
1879 lines
69 KiB
PHP
<?php
|
|
class Fisik extends MY_Controller
|
|
{
|
|
public function __construct() {
|
|
parent::__construct();
|
|
$this->db_smartone = $this->load->database("onedev", true);
|
|
}
|
|
function pribadi($id,$langid,$type) {
|
|
//$id = So_ResultEntryID
|
|
$sql = "select concat(M_TitleName,' ', M_PatientName) M_PatientName,
|
|
T_OrderHeaderLabNumber RegNo, fn_numbering_external(T_OrderHeaderLabNumber) ExternalRegNo,
|
|
T_OrderHeaderM_PatientAge,
|
|
date_format(M_PatientDOB,'%d-%m-%Y') M_PatientDOB ,
|
|
date_format(T_OrderHeaderDate,'%d-%m-%Y') T_OrderHeaderDate,
|
|
M_SexName,
|
|
(SELECT concat(M_PatientAddressDescription,' ',M_KelurahanName,' ' ,M_DistrictName,' ',M_CityName) from m_patientaddress AS p
|
|
left join m_kelurahan on M_PatientAddressM_KelurahanID = M_KelurahanID
|
|
left join m_district on M_KelurahanM_DistrictID = M_DistrictID
|
|
left join m_city on M_DistrictM_CityID = M_CityID
|
|
WHERE M_PatientAddressM_PatientID = M_PatientID
|
|
ORDER BY M_PatientAddressM_PatientID
|
|
LIMIT 1) AS M_PatientAddressDescription,M_CompanyName,
|
|
S_SystemsCompanyName ,M_PatientNoReg,
|
|
concat(S_SystemsCompanyAddress, ' ',S_SystemsCompanyCity,' ', 'Telp. ', S_SystemsCompanyPhone ) as alamatcabang,
|
|
M_No_FormRev,S_SystemsCompanyCity, DATE_FORMAT(now(), '%d-%m-%Y' ) AS DATENOW,
|
|
concat('http://localhost/one-api/v1/su/code128/?no=',M_PatientNoReg) aS Barcode,
|
|
M_PatientHP ,CONCAT(p.M_DoctorPrefix, ' ',p.M_DoctorName, ' ',p.M_DoctorSufix) AS M_DoctorName,
|
|
CONCAT(so.M_DoctorPrefix, ' ',so.M_DoctorName, ' ',so.M_DoctorSufix) AS dokterso,
|
|
ifnull(`fn_get_mcu_saran`($id,$langid),'') as saran,
|
|
ifnull(`fn_get_mcu_konsul`($id,$langid),'') as konsul
|
|
|
|
|
|
|
|
from so_resultentry
|
|
join t_orderheader on So_ResultEntryT_OrderHeaderID = T_OrderHeaderID
|
|
and So_ResultEntryID = ?
|
|
join m_patient on M_PatientID = T_OrderHeaderM_PatientID
|
|
join m_title on M_PatientM_TitleID = M_TitleID
|
|
left join m_sex on M_PatientM_SexID = M_SexID
|
|
left join m_company ON T_OrderHeaderM_CompanyID = M_CompanyID AND M_CompanyIsActive = 'Y'
|
|
left join m_doctor p ON T_OrderHeaderSenderM_DoctorID = p.M_DoctorID AND p.M_DoctorIsActive = 'Y'
|
|
LEFT JOIN m_no_form on M_No_FormID > 0 and M_No_FormName = 'LAB'
|
|
left join conf_systems on S_SystemsID > 0
|
|
left join t_orderdetail on So_ResultEntryT_OrderDetailID = T_OrderDetailID and T_OrderDetailIsActive = 'Y'
|
|
left join t_test ON T_TestID = T_OrderDetailT_TestID and T_TestIsActive = 'Y'
|
|
left join t_samplingso on T_SamplingSoT_OrderHeaderID = T_OrderHeaderID and T_SamplingSoT_TestID = T_TestID
|
|
left join m_doctor so on T_SamplingSoM_DoctorID = so.M_DoctorID
|
|
";
|
|
$qry = $this->db_smartone->query($sql,array($id));
|
|
if ($qry) {
|
|
$rows = $qry->result_array();
|
|
|
|
foreach($rows as $idx => $r ) {
|
|
$rows[$idx]["keluhan_saat_ini"] = $this->keluhan_saat_ini($id,$langid,$type);
|
|
$rows[$idx]["phobia"] = $this->phobia($id,$langid,$type);
|
|
$rows[$idx]["kesimpulan"] = $this->kesimpulanv4($id,$langid);
|
|
}
|
|
|
|
echo json_encode($rows);
|
|
} else {
|
|
echo json_encode(array());
|
|
}
|
|
}
|
|
|
|
function phobia($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return "";
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return "";
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$phobia = "";
|
|
foreach($details as $d) {
|
|
if ($d["title"] == "RIWAYAT POBIA") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$phobia = $d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $xd) {
|
|
if ($xd["chx"] == "1" ) {
|
|
if ( $phobia != "" ) $phobia .= ", ";
|
|
$phobia .= $xd["label"];
|
|
if ($xd["value"] != "") $phobia .= " (" .$xd["value"] . ")";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
return $phobia;
|
|
}
|
|
|
|
function keluhan_saat_ini($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return "";
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return "";
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$keluhan_saat_ini = "";
|
|
foreach($details as $d) {
|
|
if ($d["title"] == "KELUHAN SAAT INI") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$keluhan_saat_ini = $d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $xd) {
|
|
if ($xd["chx"] == "1" ) {
|
|
if ( $keluhan_saat_ini != "" ) $keluhan_saat_ini .= ", ";
|
|
$keluhan_saat_ini .= $xd["label"];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
return $keluhan_saat_ini;
|
|
}
|
|
function keluhan_saat_ini_new($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$keluhan_saat_ini_new = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "KELUHAN SAAT INI") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$keluhan_saat_ini_new = array();
|
|
//$d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$keluhan_saat_ini_new[] = array(
|
|
"a1" => $gp["label"],
|
|
"a2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($keluhan_saat_ini_new);
|
|
}
|
|
|
|
function riwayat_phobia($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$riwayat_phobia = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "RIWAYAT POBIA") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$riwayat_phobia = array();
|
|
//$d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$riwayat_phobia[] = array(
|
|
"b1" => $gp["label"],
|
|
"b2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($riwayat_phobia);
|
|
}
|
|
|
|
function riwayat_penyakit($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$riwayat_penyakit = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "RIWAYAT PENYAKIT") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$riwayat_penyakit = array();
|
|
//$d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($xd["label"],$xd["value"]) ;
|
|
$riwayat_penyakit[] = array(
|
|
"c1" => $xd["label"],
|
|
"c2" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($riwayat_penyakit);
|
|
}
|
|
|
|
function riwayat_keluarga($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$riwayat_keluarga = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "RIWAYAT PENYAKIT KELUARGA") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$riwayat_keluarga = array();
|
|
//$d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$riwayat_keluarga[] = array(
|
|
"d1" => $gp["label"],
|
|
"d2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($riwayat_keluarga);
|
|
}
|
|
function riwayat_hidup($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$riwayat_hidup = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "RIWAYAT KEBIASAAN HIDUP") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$riwayat_hidup = array();
|
|
//$d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($xd["segment_name"],$xd["label"],$xd["value"]) ;
|
|
$riwayat_hidup[] = array(
|
|
"e1" => $xd["segment_name"],
|
|
"e2" => $xd["label"].' '.$xd["value"],
|
|
"e3" => $xd["value"],
|
|
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($riwayat_hidup);
|
|
}
|
|
|
|
function riwayat_obat($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$riwayat_obat = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "RIWAYAT KONSUMSI OBAT TERATUR") {
|
|
if ($d["flag_normal"] == "Y") {
|
|
$riwayat_obat = array();
|
|
//$d["label_flag_normal"];
|
|
break;
|
|
} else {
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$riwayat_obat[] = array(
|
|
"f1" => $gp["label"],
|
|
"f2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($riwayat_obat);
|
|
}
|
|
|
|
|
|
//pemeriksaan Fisik
|
|
function tanda_vital($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$tanda_vital = array();
|
|
foreach($details as $d) {
|
|
if ($d["title"] == "TANDA VITAL") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
$value = $gp["value"].' '.$gp["unit"];
|
|
if ($gp["chx_x"] == "1") $value = $gp["label_x"];
|
|
if ($gp["chx_y"] == "1") $value = $gp["label_y"];
|
|
|
|
$tanda_vital[] = array(
|
|
"aa1" => $gp["label"],
|
|
"aa2" => $value,
|
|
"aa3" => ucwords(strtolower($gp["value_x"])),
|
|
);
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($tanda_vital);
|
|
}
|
|
|
|
|
|
function status_gizi($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$status_gizi = array();
|
|
foreach($details as $d) {
|
|
if ($d["title"] == "STATUS GIZI") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
$value = $gp["value"];
|
|
if ($gp["chx_x"] == "1") $value = $gp["label_x"];
|
|
if ($gp["chx_y"] == "1") $value = $gp["label_y"];
|
|
|
|
$status_gizi[] = array(
|
|
"qq1" => $gp["label"],
|
|
"qq2" => $value,
|
|
"qq3" => $gp["unit"],
|
|
);
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($status_gizi);
|
|
}
|
|
|
|
function keadaan_umum($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$keadaan_umum = array();
|
|
foreach($details as $d) {
|
|
if ($d["title"] == "KEADAAN UMUM") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
$value = $gp["value"];
|
|
if ($gp["chx_x"] == "1") $value = $gp["label_x"];
|
|
if ($gp["chx_y"] == "1") $value = $gp["label_y"];
|
|
|
|
$keadaan_umum[] = array(
|
|
"rr1" => $gp["label"],
|
|
"rr2" => $value,
|
|
"rr3" => $gp["unit"],
|
|
);
|
|
}
|
|
}
|
|
}
|
|
echo json_encode($keadaan_umum);
|
|
}
|
|
|
|
|
|
function kepala_wajah($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$kepala_wajah = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "KEPALA WAJAH") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$kepala_wajah[] = array(
|
|
"bb1" => $gp["label"],
|
|
"bb2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($kepala_wajah);
|
|
}
|
|
|
|
function mata($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$mata = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "MATA") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$mata[] = array(
|
|
"cc1" => $gp["label"],
|
|
"cc2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($mata);
|
|
}
|
|
|
|
function persepsi_warna($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$persepsi_warna = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "PERSEPSI WARNA") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$persepsi_warna[] = array(
|
|
"dd1" => $gp["label"],
|
|
"dd2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($persepsi_warna);
|
|
}
|
|
|
|
|
|
function telinga($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$telinga = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "TELINGA") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$telinga[] = array(
|
|
"ee1" => $gp["label"],
|
|
"ee2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($telinga);
|
|
}
|
|
|
|
|
|
function visus($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$visus = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "VISUS JAUH") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$visus[] = array(
|
|
"xx1" => $gp["name"],
|
|
"xx2" => $xd["label"],
|
|
"xx3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($visus);
|
|
}
|
|
|
|
function hidung($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$hidung = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "HIDUNG") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$hidung[] = array(
|
|
"ff1" => $gp["label"],
|
|
"ff2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($hidung);
|
|
}
|
|
|
|
function gigi($id,$langid,$type) {
|
|
$kode_gigi = array( "X" => "Berlubang" , "C" => "Tambalan", "O" => "Tanggal",
|
|
"R" => "Sisa akar", "A" => "Gigi Palsu" , "K" => "Karang Gigi" );
|
|
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$da= json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
$arr_gigi= array();
|
|
foreach($da as $db) {
|
|
if ($db["title"] != "GIGI") continue;
|
|
foreach($db["details"] as $dx) {
|
|
foreach($dx["details"] as $dc) {
|
|
$dc["value"] = strtoupper($dc["value"]);
|
|
if ($dc["value"] != "" && isset($kode_gigi[$dc["value"]])) {
|
|
//$value = $kode_gigi[$dc["value"]];
|
|
$value = $dc["value"];
|
|
if (! isset($arr_gigi[$value]) ) $arr_gigi[$value] = array();
|
|
$kode = $dc["id_code"];
|
|
$pos = substr($kode,-1);
|
|
|
|
if ( strpos($kode,"atas")) {
|
|
if (strpos($kode,"kiri")) {
|
|
$arr_gigi[$value][] = $pos . "┘" ;
|
|
} else {
|
|
$arr_gigi[$value][] = "└" . $pos ;
|
|
}
|
|
} else {
|
|
if (strpos($kode,"kiri")) {
|
|
$arr_gigi[$value][] = $pos . "┐" ;
|
|
} else {
|
|
$arr_gigi[$value][] = "┌" .$pos;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
$gigi= array();
|
|
foreach($arr_gigi as $v => $g) {
|
|
$gigi[] = array("gg1" => join($g,", "), "gg2" => "" , "gg3" => $v);
|
|
}
|
|
echo json_encode($gigi);
|
|
}
|
|
|
|
function gigi_lama($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$gigi = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "GIGI") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["value"] <> '' ) {
|
|
$arr_result[] = array($xd["id_code"],$xd["label"],$xd["value"]) ;
|
|
$gigi[] = array(
|
|
"gg1" => $xd["id_code"],
|
|
"gg2" => $xd["label"],
|
|
"gg3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
$gigi = array(
|
|
array("gg1" => "+8, +7, +7, +8", "gg2" => "b" , "gg3" => "O")
|
|
);
|
|
echo json_encode($gigi);
|
|
}
|
|
|
|
function mulut($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$mulut = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "MULUT") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$mulut[] = array(
|
|
"hh1" => $gp["name"],
|
|
"hh2" => $xd["label"],
|
|
"hh3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($mulut);
|
|
}
|
|
function leher($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$leher = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "LEHER") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$leher[] = array(
|
|
"ii1" => $gp["label"],
|
|
"ii2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($leher);
|
|
}
|
|
|
|
function thorax($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$thorax = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "THORAX / DADA") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$thorax[] = array(
|
|
"jj1" => $gp["label"],
|
|
"jj2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($thorax);
|
|
}
|
|
function paru($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$paru = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "PARU-PARU") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$paru[] = array(
|
|
"kk1" => $gp["label"],
|
|
"kk2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($paru);
|
|
}
|
|
|
|
|
|
function jantung($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$jantung = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "JANTUNG") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$jantung[] = array(
|
|
"ll1" => $gp["name"],
|
|
"ll2" => $xd["label"],
|
|
"ll3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($jantung);
|
|
}
|
|
|
|
|
|
function perut($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$perut = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "PERUT / ABDOMEN") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$perut[] = array(
|
|
"mm1" => $gp["name"],
|
|
"mm2" => $xd["label"],
|
|
"mm3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($perut);
|
|
}
|
|
function genitourinaria($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$genitourinaria = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "GENITOURINARIA") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$genitourinaria[] = array(
|
|
"nn1" => $gp["label"],
|
|
"nn2" => $gp["value"],
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($genitourinaria);
|
|
}
|
|
function anggota($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$anggota = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "ANGGOTA GERAK") {
|
|
//WIP
|
|
//echo "<pre>"; print_r($d["details"]);
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$anggota[] = array(
|
|
"oo1" => $gp["name"],
|
|
"oo2" => $xd["label"],
|
|
"oo3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($anggota);
|
|
}
|
|
function sistem($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$sistem = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "SISTEM PERSYARAFAN") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$sistem[] = array(
|
|
"pp1" => $gp["name"],
|
|
"pp2" => $xd["label"],
|
|
"pp3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($sistem);
|
|
}
|
|
|
|
function integumen($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$integumen = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "SISTEM INTEGUMEN") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
foreach($gp["details"] as $xd) {
|
|
if ($xd["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["name"],$xd["label"],$xd["value"]) ;
|
|
$integumen[] = array(
|
|
"pp1" => $gp["name"],
|
|
"pp2" => $xd["label"],
|
|
"pp3" => $xd["value"]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|
|
echo json_encode($integumen);
|
|
}
|
|
|
|
|
|
//end pemeriksaan fisik
|
|
|
|
//saran
|
|
//konsul
|
|
|
|
function kesimpulan($id,$langid) {
|
|
return "Ini adalah contoh kesimpulan dari pemeriksaan di atas.";
|
|
/* $sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
$kesimpulan = "ada apa denganmu ";
|
|
|
|
echo json_encode(array("abc" => $kesimpulan));
|
|
*/
|
|
}
|
|
|
|
function kesimpulanx($id,$langid) {
|
|
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType='fisik'";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid));
|
|
$rows = $qry->result_array();
|
|
if ( count($rows) == 0 ) return '';
|
|
|
|
$data = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
echo "<pre>"; print_r($data);
|
|
}
|
|
|
|
function kesimpulanv4($id,$langid) {
|
|
$kode_gigi = array( "X" => "Berlubang" , "C" => "Tambalan", "O" => "Tanggal",
|
|
"R" => "Sisa akar", "A" => "Gigi Palsu" , "K" => "Karang Gigi" );
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType='fisik'";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid));
|
|
$rows = $qry->result_array();
|
|
if ( count($rows) == 0 ) return '';
|
|
$data = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
$kesimpulan = "";
|
|
|
|
foreach($data as $da) {
|
|
if ($da["title"] == "TANDA VITAL") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx_x"] == "1" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "STATUS GIZI") {
|
|
$bmi_value = "";
|
|
foreach($da["details"] as $db) {
|
|
if ($db["id_code"] == "status_gizi_4") $bmi_value = $db["value"];
|
|
if( $db["chx_x"] == "1" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
if ($db["label"] == "Klasifikasi" && $db["value"] != "Normal" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["value"] . " ( BMI : $bmi_value )";
|
|
}
|
|
}
|
|
} elseif($da["title"] == "KEADAAN UMUM") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx_x"] == "1" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "KEPALA WAJAH") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "MATA") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "PERSEPSI WARNA") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "VISUS JAUH") {
|
|
foreach($da["details"] as $db) {
|
|
$str_data = "";
|
|
foreach($db["details"] as $dc ) {
|
|
if ($dc["chx"] == "") continue;
|
|
$value = str_replace(" ","",$dc["value"]);
|
|
if (strpos($value,"6/6") === false) {
|
|
$str_data .= $dc["label"] . " " . $dc["value"];
|
|
}
|
|
}
|
|
if ($str_data != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . "( " . $str_data . " )";
|
|
}
|
|
}
|
|
} elseif($da["title"] == "TELINGA") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "HIDUNG") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "GIGI") {
|
|
$arr_gigi= array();
|
|
foreach($da["details"] as $db) {
|
|
foreach($db["details"] as $dc) {
|
|
$dc["value"] = strtoupper($dc["value"]);
|
|
if ($dc["value"] != "" && isset($kode_gigi[$dc["value"]])) {
|
|
$value = $kode_gigi[$dc["value"]];
|
|
if (! isset($arr_gigi[$value]) ) $arr_gigi[$value] = array();
|
|
$kode = $dc["id_code"];
|
|
$pos = substr($kode,-1);
|
|
|
|
if ( strpos($kode,"atas")) {
|
|
if (strpos($kode,"kiri")) {
|
|
$arr_gigi[$value][] = $pos . "┘" ;
|
|
} else {
|
|
$arr_gigi[$value][] = "└" . $pos ;
|
|
}
|
|
} else {
|
|
if (strpos($kode,"kiri")) {
|
|
$arr_gigi[$value][] = $pos . "┐" ;
|
|
} else {
|
|
$arr_gigi[$value][] = "┌" .$pos;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
$r_gigi = "";
|
|
foreach($arr_gigi as $v => $g) {
|
|
$r_gigi .= $v . " " . join($g,", ") . " ";
|
|
}
|
|
if ($r_gigi != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= "<br/>Gigi : ";
|
|
$kesimpulan .= $r_gigi;
|
|
}
|
|
} elseif($da["title"] == "MULUT") {
|
|
foreach($da["details"] as $db) {
|
|
$s_res = "";
|
|
foreach($db["details"] as $dc) {
|
|
if( $dc["chx"] == "1" && $dc["is_normal"] == "N" ) {
|
|
if ($s_res != "") $s_res.= ", ";
|
|
$s_res .= $dc["label"] . " " . $dc["label_x"];
|
|
}
|
|
}
|
|
if ($s_res != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . " " . $s_res;
|
|
}
|
|
}
|
|
} elseif($da["title"] == "LEHER") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "THORAX / DADA") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "PARU-PARU") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["label_x"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "JANTUNG") {
|
|
foreach($da["details"] as $db) {
|
|
$s_res = "";
|
|
foreach($db["details"] as $dc) {
|
|
if( $dc["chx"] == "1" && $dc["is_normal"] == "N" ) {
|
|
if ($s_res != "") $s_res.= ", ";
|
|
$s_res .= $dc["label"] . " " . $dc["label_x"];
|
|
}
|
|
}
|
|
if ($s_res != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . " " . $s_res;
|
|
}
|
|
}
|
|
} elseif($da["title"] == "PERUT / ABDOMEN") {
|
|
foreach($da["details"] as $db) {
|
|
$s_res = "";
|
|
foreach($db["details"] as $dc) {
|
|
if ($dc["label"] == "Tidak Ada") continue;
|
|
if( $dc["chx"] == "1" && $dc["is_normal"] == "N" ) {
|
|
if ($s_res != "") $s_res.= ", ";
|
|
$s_res .= $dc["label"] . " " . $dc["value"];
|
|
}
|
|
}
|
|
if ($s_res != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . " " . $s_res;
|
|
}
|
|
}
|
|
} elseif($da["title"] == "GENITOURINARIA") {
|
|
foreach($da["details"] as $db) {
|
|
if( $db["chx"] == "1" && $db["is_normal"] == "N" && $db["label"] != "Tidak diperiksa") {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["label"] . " " . $db["value"];
|
|
}
|
|
}
|
|
} elseif($da["title"] == "ANGGOTA GERAK") {
|
|
foreach($da["details"] as $db) {
|
|
$s_res = "";
|
|
//WIP
|
|
foreach($db["details"] as $dc) {
|
|
if( $dc["chx"] == "1" ) {
|
|
if ($s_res != "") $s_res.= ", ";
|
|
$s_res .= $dc["label"] . " " . $dc["value"];
|
|
}
|
|
}
|
|
|
|
|
|
if ($s_res != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . " " . $s_res;
|
|
}
|
|
|
|
|
|
|
|
}
|
|
} elseif($da["title"] == "SISTEM PERSYARAFAN") {
|
|
foreach($da["details"] as $db) {
|
|
$s_res = "";
|
|
foreach($db["details"] as $dc) {
|
|
if( $dc["chx"] == "1" && $dc["is_normal"] == "N" ) {
|
|
if ($s_res != "") $s_res.= ", ";
|
|
$s_res .= $dc["label"] . " " . $dc["value"];
|
|
}
|
|
}
|
|
if ($s_res != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . " " . $s_res;
|
|
}
|
|
}
|
|
} elseif($da["title"] == "SISTEM INTEGUMEN") {
|
|
foreach($da["details"] as $db) {
|
|
$s_res = "";
|
|
foreach($db["details"] as $dc) {
|
|
if( $dc["chx"] == "1" && $dc["is_normal"] == "N" ) {
|
|
if ($s_res != "") $s_res.= ", ";
|
|
$s_res .= $dc["label"] . " " . $dc["value"];
|
|
}
|
|
}
|
|
if ($s_res != "" ) {
|
|
if ($kesimpulan != "") $kesimpulan .= ", ";
|
|
$kesimpulan .= $db["name"] . " " . $s_res;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if ($kesimpulan == "" ) {
|
|
$kesimpulan = "Dalam batas normal.";
|
|
} else {
|
|
$kesimpulan = "Pada saat ini didapatkan kelainan berupa :<br/>" . $kesimpulan;
|
|
}
|
|
return $kesimpulan;
|
|
}
|
|
|
|
function kesimpulanv2($id,$langid) {
|
|
$kode_gigi = array( "X" => "Berlubang" , "C" => "Tambalan", "O" => "Tanggal",
|
|
"R" => "Sisa akar", "A" => "Gigi Palsu" , "K" => "Karang Gigi" );
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType='fisik'";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid));
|
|
$rows = $qry->result_array();
|
|
if ( count($rows) == 0 ) return '';
|
|
$data = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
$kesimpulan = "";
|
|
$arr_gigi = array();
|
|
foreach($data as $obj) {
|
|
if ( isset($obj["details"]) ) {
|
|
$dd = $obj["details"];
|
|
if (isset($dd["details"])) {
|
|
if (isset($dh["chx_x"])) {
|
|
if ($dh["chx_x"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["label_x"];
|
|
}
|
|
} elseif (isset($dh["is_normal"])) {
|
|
if ($dh["is_normal"] == "N" && $dh["chx"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
} elseif (isset($dh["chx"])) {
|
|
if ($dh["chx"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
}
|
|
} else {
|
|
foreach($dd as $dh) {
|
|
if ( $obj["type_form"] == "TOOTH" ) {
|
|
foreach($dh["details"] as $xd) {
|
|
if ($xd["value"] != "" ) {
|
|
if ( ! in_array($arr_gigi , $kode_gigi[$xd["value"]]) ) {
|
|
$arr_gigi[] = $kode_gigi[$xd["value"]];
|
|
}
|
|
}
|
|
}
|
|
} elseif (isset($dh["chx_x"])) {
|
|
if ($dh["chx_x"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["label_x"];
|
|
}
|
|
} elseif (isset($dh["is_normal"])) {
|
|
if ($dh["is_normal"] == "N" && $dh["chx"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
} elseif (isset($dh["chx"])) {
|
|
if ($dh["chx"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if ($kesimpulan == "" ) {
|
|
$kesimpulan = "Dalam batas normal";
|
|
} else {
|
|
$kesimpulan = "Pada saat ini di dapatkan kelainan berupa : \n$kesimpulan";
|
|
}
|
|
if ( count($arr_gigi) > 0 ) {
|
|
$kesimpulan .= "\nGigi : " . join($arr_gigi);
|
|
} else {
|
|
$kesimpulan .= "\nGigi : normal.";
|
|
}
|
|
return $kesimpulan;
|
|
}
|
|
|
|
function kesimpulanv3($id,$langid) {
|
|
$kode_gigi = array( "X" => "Berlubang" , "C" => "Tambalan", "O" => "Tanggal",
|
|
"R" => "Sisa akar", "A" => "Gigi Palsu" , "K" => "Karang Gigi" );
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType='fisik'";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid));
|
|
$rows = $qry->result_array();
|
|
if ( count($rows) == 0 ) return '';
|
|
$data = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
$kesimpulan = "";
|
|
$arr_gigi = array();
|
|
foreach($data as $obj) {
|
|
if ( isset($obj["details"]) ) {
|
|
$dd = $obj["details"];
|
|
if (isset($dd["details"])) {
|
|
if (isset($dh["chx_x"])) {
|
|
if ($dh["chx_x"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["label_x"];
|
|
}
|
|
} elseif (isset($dh["is_normal"])) {
|
|
if ($dh["is_normal"] == "N") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
} elseif (isset($dh["chx"])) {
|
|
if ($dh["chx"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
}
|
|
} else {
|
|
foreach($dd as $dh) {
|
|
if ( $obj["type_form"] == "TOOTH" ) {
|
|
foreach($dh["details"] as $xd) {
|
|
if ($xd["value"] != "" ) {
|
|
if ( ! in_array($arr_gigi , $kode_gigi[$xd["value"]]) ) {
|
|
$arr_gigi[] = $kode_gigi[$xd["value"]];
|
|
}
|
|
}
|
|
}
|
|
} elseif (isset($dh["chx_x"])) {
|
|
if ($dh["chx_x"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["label_x"];
|
|
}
|
|
} elseif (isset($dh["is_normal"])) {
|
|
if ($dh["is_normal"] == "N") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
} elseif (isset($dh["chx"])) {
|
|
if ($dh["chx"] == "1") {
|
|
if ($kesimpulan != "" ) $kesimpulan .= ", ";
|
|
$kesimpulan .= $dh["label"] . " " . $dh["value"];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if ($kesimpulan == "" ) {
|
|
$kesimpulan = "Dalam batas normal";
|
|
} else {
|
|
$kesimpulan = "Pada saat ini di dapatkan kelainan berupa : \n$kesimpulan";
|
|
}
|
|
if ( count($arr_gigi) > 0 ) {
|
|
$kesimpulan .= "\nGigi : " . join($arr_gigi);
|
|
}
|
|
return $kesimpulan;
|
|
}
|
|
|
|
|
|
function saran($id,$langid) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType='saran'";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid));
|
|
$saran = "";
|
|
$rows = $qry->result_array();
|
|
if (count($rows) > 0 ) {
|
|
$saran = $rows[0]["So_ResultEntryFisikUmumDetails"];
|
|
}
|
|
|
|
echo json_encode(array("saran" => $saran));
|
|
}
|
|
|
|
function konsul($id,$langid) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType='konsul'";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid));
|
|
$rows = $qry->result_array();
|
|
if (count($rows) > 0 ) {
|
|
$konsul = $rows[0]["So_ResultEntryFisikUmumDetails"];
|
|
}
|
|
echo json_encode(array( "konsul" => $konsul));
|
|
}
|
|
|
|
|
|
|
|
//k3
|
|
function faktor_fisik($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$faktor_fisik = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "FAKTOR FISIK") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value_sumber"],$gp["value_lama"]) ;
|
|
$faktor_fisik[] = array(
|
|
"aaa1" => $gp["label"],
|
|
"aaa2" => $gp["value_sumber"],
|
|
"aaa3" => $gp["value_lama"]
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($faktor_fisik);
|
|
}
|
|
|
|
function faktor_kimia($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$faktor_kimia = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "FAKTOR KIMIA") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value_sumber"],$gp["value_lama"]) ;
|
|
$faktor_kimia[] = array(
|
|
"bbb1" => $gp["label"],
|
|
"bbb2" => $gp["value_sumber"],
|
|
"bbb3" => $gp["value_lama"]
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($faktor_kimia);
|
|
}
|
|
|
|
function faktor_biologi($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$faktor_biologi = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "FAKTOR BIOLOGI") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value_sumber"],$gp["value_lama"]) ;
|
|
$faktor_biologi[] = array(
|
|
"ccc1" => $gp["label"],
|
|
"ccc2" => $gp["value_sumber"],
|
|
"ccc3" => $gp["value_lama"]
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($faktor_biologi);
|
|
}
|
|
|
|
function faktor_ergonomi($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$faktor_ergonomi = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "FAKTOR ERGONOMI") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value_sumber"],$gp["value_lama"]) ;
|
|
$faktor_ergonomi[] = array(
|
|
"ddd1" => $gp["label"],
|
|
"ddd2" => $gp["value_sumber"],
|
|
"ddd3" => $gp["value_lama"]
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($faktor_ergonomi);
|
|
}
|
|
function faktor_psikologi($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$faktor_psikologi = array();
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "FAKTOR PSIKOLOGI") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value_sumber"],$gp["value_lama"]) ;
|
|
$faktor_psikologi[] = array(
|
|
"eee1" => $gp["label"],
|
|
"eee2" => $gp["value_sumber"],
|
|
"eee3" => $gp["value_lama"]
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode($faktor_psikologi);
|
|
}
|
|
|
|
//k3
|
|
function kesimpulanx2($id,$langid,$type) {
|
|
$sql = "select * from so_resultentry_fisik_umum
|
|
where So_ResultEntryFisikUmumSo_ResultEntryID= ?
|
|
and So_ResultEntryFisikUmumM_LangID=?
|
|
and So_ResultEntryFisikUmumType=?";
|
|
$qry = $this->db_smartone->query($sql,array($id,$langid,$type));
|
|
if (! $qry) {
|
|
return json_encode(array());
|
|
}
|
|
$rows = $qry->result_array();
|
|
if (count($rows) == 0 ) {
|
|
return json_encode(array());
|
|
}
|
|
$details = json_decode($rows[0]["So_ResultEntryFisikUmumDetails"],true);
|
|
//keluhan saat ini
|
|
$kesimpulanx = array("asdasdasdasdasd");
|
|
foreach($details as $d) {
|
|
|
|
if ($d["title"] == "") {
|
|
|
|
foreach($d["details"] as $gp) {
|
|
if ($gp["chx"] == 1 ) {
|
|
$arr_result[] = array($gp["label"],$gp["value"]) ;
|
|
$kesimpulanx[] = array(
|
|
"nn1" => $gp["label"],
|
|
"nn2" => $gp["value"]
|
|
);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|
|
echo json_encode(array("abc" => $kesimpulanx));
|
|
}
|
|
|
|
|
|
function list() {
|
|
$sql = "select * from m_religion";
|
|
$qry = $this->db_smartone->query($sql);
|
|
if ($qry) {
|
|
$rows = $qry->result_array();
|
|
echo json_encode($rows);
|
|
} else {
|
|
echo json_encode(array());
|
|
}
|
|
}
|
|
function get($id) {
|
|
$sql = "select * from m_religion where M_ReligionID=?";
|
|
$qry = $this->db_smartone->query($sql,$id);
|
|
if ($qry) {
|
|
$rows = $qry->result_array();
|
|
echo json_encode($rows);
|
|
} else {
|
|
echo json_encode(array());
|
|
}
|
|
}
|
|
}
|
|
?>
|