@php /* */ @endphp @foreach ($tb_report as $tb) @php $tb->sample = ""; $arr = array(); $arr[0]['report_cid'] = $tb->report_cid; $arr[0]['report_hn'] = pdpaDecode($tb->report_hn); $arr[0]['report_patientname'] = pdpaDecode($tb->report_patientname); $arr[0]['report_age'] = $tb->report_age; $arr[0]['report_gender'] = $tb->report_gender; $arr[0]['report_citizen'] = $tb->report_citizen; $arr[0]['report_allergic'] = $tb->report_allergic; $arr[0]['report_contact'] = $tb->report_contact; $arr[0]['report_conginital_disease'] = $tb->report_conginital_disease; $arr[0]['report_right2treatment'] = $tb->report_right2treatment; $arr[0]['report_type_of_case'] = $tb->report_type_of_case; $arr[0]['report_appointment_date'] = $tb->report_appointment_year.'-'.$tb->report_appointment_month.'-'.$tb->report_appointment_day; $arr[0]['report_appointment_time'] = $tb->report_appointment_time; $arr[0]['report_procedure'] = $tb->report_procedure; $arr[0]['report_endoscopist'] = $tb->report_endoscopist; $arr[0]['report_doctorconsult01'] = $tb->report_doctorconsult01; $arr[0]['report_doctorconsult02'] = $tb->report_doctorconsult02; $arr[0]['report_doctorconsult03'] = $tb->report_doctorconsult03; $arr[0]['report_nurse01'] = $tb->report_nurse01; $arr[0]['report_nurse02'] = $tb->report_nurse02; $arr[0]['report_nurse03'] = $tb->report_nurse03; $arr[0]['report_nurse04'] = $tb->report_nurse04; $arr[0]['report_scope'] = $tb->report_scope; $i = 0; $json = jsonDecode($tb->report_scope); foreach($json as $j){ $arr[$i]['report_scope'] = $j; if($j!=""){$i++;} } $arr[0]['report_room'] = $tb->report_room; $arr[0]['report_ward'] = $tb->report_ward; $arr[0]['report_opd'] = $tb->report_opd; $arr[0]['report_refer'] = $tb->report_refer; $arr[0]['report_briefhistory'] = $tb->report_briefhistory; $arr[0]['report_prediagnosis'] = $tb->report_prediagnosis; $i = 0; $json = jsonDecode($tb->report_anesthesia); foreach($json as $j){ $arr[$i]['report_anesthesia'] = $j; if($j!=""){$i++;} } $arr[0]['report_medication'] = ""; $i = 0; $json = jsonDecode($tb->report_medication); foreach($json as $j=>$a){ if($a!=0){ $arr[$i]['report_medication'] = $j." ".$a; } if($j!=""){$i++;} } $i = 0; $json = jsonDecode($tb->report_finding); foreach($json as $key => $val){ $arr[$i]['report_finding'] = $key; $arr[$i]['report_findingval'] = $val; if($j!=""){$i++;} } $arr[0]['report_overallfinding'] = $tb->report_overallfinding; $arr[0]['report_diagnostic_primary'] = $tb->report_diagnostic_primary; $arr[0]['report_diagnostic_secondary'] = $tb->report_diagnostic_secondary; $arr[0]['report_diagnostic_other01'] = $tb->report_diagnostic_other01; $arr[0]['report_diagnostic_other02'] = $tb->report_diagnostic_other02; $arr[0]['report_diagnostic_other03'] = $tb->report_diagnostic_other03; $i = 0; $json = jsonDecode($tb->report_icd10code); foreach($json as $j){ $arr[$i]['report_icd10code'] = $j; if($j!=""){$i++;} } $arr[0]['report_diagnostic_freetext'] = $tb->report_diagnostic_freetext; $arr[0]['report_procedure_primary'] = $tb->report_procedure_primary; $arr[0]['report_procedure_secondary'] = $tb->report_procedure_secondary; $arr[0]['report_procedure_other01'] = $tb->report_procedure_other01; $arr[0]['report_procedure_other02'] = $tb->report_procedure_other02; $arr[0]['report_procedure_other03'] = $tb->report_procedure_other03; $i = 0; $json = jsonDecode($tb->report_icd9code); foreach($json as $j){ $arr[$i]['report_icd9code'] = $j; if($j!=""){$i++;} } $arr[0]['sample'] = ""; $i = 0; $json = jsonDecode($tb->report_complication); foreach($json as $j){ $arr[$i]['report_complication'] = $j; if($j!=""){$i++;} } $arr[0]['report_histopathology'] = $tb->report_histopathology; $arr[0]['report_recommendation'] = $tb->report_recommendation; $arr[0]['report_comment'] = $tb->report_comment; @endphp @php $i=0; @endphp @foreach($arr as $a) @php $i++; @endphp @endforeach @endforeach

Case ID	HN	Name	HN	Patient Name	Age	Gender	ID/Passport	Allergic	TypeOfCase	Contact	Conginital disease	Right to treatment	Appointment Date	Time	Procedure	Endoscopist	Doctor consult#1	Doctor consult#2	Doctor consult#3	Nurse #1	Nurse #2	Assist nurse#1	Assist nurse#2	Scope	Room	Ward	OPD	Refer	Brief history	Pre Diagnosis	Anesthesia	Medication	Finding	---	Overall finding	Primary Diagnosis	Secondary Diagnosis	Other Diagnosis(1)	Other Diagnosis(2)	Other Diagnosis(3)	ICD 10 Code	Freetext Diagnosis	Primary Procedure	Secondary Procedure	Other Procedure(1)	Other Procedure(2)	Other Procedure(3)	icd9code	Freetext Diagnosis	Complication	Histopathology	Recommendation	Comment
{{@$arr[$i]['report_cid']}}	{{@$arr[$i]['report_hn']}}	{{@$arr[$i]['report_patientname']}}	{{@$arr[$i]['report_age']}}	{{@$arr[$i]['report_gender']}}	{{@$arr[$i]['report_citizen']}}	{{@$arr[$i]['report_allergic']}}	{{@$arr[$i]['report_contact']}}	{{@$arr[$i]['report_conginital_disease']}}	{{@$arr[$i]['report_right2treatment']}}	{{@$arr[$i]['report_type_of_case']}}	{{@$arr[$i]['report_appointment_date']}}	{{@$arr[$i]['report_appointment_time']}}	{{@$arr[$i]['report_procedure']}}	{{@$arr[$i]['report_endoscopist']}}	{{@$arr[$i]['report_doctorconsult01']}}	{{@$arr[$i]['report_doctorconsult02']}}	{{@$arr[$i]['report_doctorconsult03']}}	{{@$arr[$i]['report_nurse01']}}	{{@$arr[$i]['report_nurse02']}}	{{@$arr[$i]['report_nurse03']}}	{{@$arr[$i]['report_nurse04']}}	{{@$arr[$i]['report_scope']}}	{{@$arr[$i]['report_room']}}	{{@$arr[$i]['report_ward']}}	{{@$arr[$i]['report_opd']}}	{{@$arr[$i]['report_refer']}}	{{@$arr[$i]['report_briefhistory']}}	{{@$arr[$i]['report_prediagnosis']}}	{{@$arr[$i]['report_anesthesia']}}	{{@$arr[$i]['report_medication']}}	{{@$arr[$i]['report_finding']}}	{{@$arr[$i]['report_findingval']}}	{{@$arr[$i]['report_overallfinding']}}	{{@$arr[$i]['report_diagnostic_primary']}}	{{@$arr[$i]['report_diagnostic_secondary']}}	{{@$arr[$i]['report_diagnostic_other01']}}	{{@$arr[$i]['report_diagnostic_other02']}}	{{@$arr[$i]['report_diagnostic_other03']}}	{{@$arr[$i]['report_icd10code']}}	{{@$arr[$i]['report_diagnostic_freetext']}}	{{@$arr[$i]['report_procedure_primary']}}	{{@$arr[$i]['report_procedure_secondary']}}	{{@$arr[$i]['report_procedure_other01']}}	{{@$arr[$i]['report_procedure_other02']}}	{{@$arr[$i]['report_procedure_other03']}}	{{@$arr[$i]['report_icd9code']}}	{{@$arr[$i]['sample']}}	{{@$arr[$i]['report_complication']}}	{{@$arr[$i]['report_histopathology']}}	{{@$arr[$i]['report_recommendation']}}	{{@$arr[$i]['report_comment']}}