@csrf @php $columnses=[ "Late_fol_duration" , "Next_Appointment" , "Time" , "own_clinic_Bp", "own_Bp_Stage" , "FBS", "FBS_test_date" , "2HPP" , "2HPP_test_date" , "Loaction_test" , "Lab_res_Date" , "Alt" , "HBA1C" , "Uring_AC_ratio" , "Glucose_res" , "Protein_res" , "Creatinine" , "Creat_unit" , "CRCL" , "Total_cholesterol" , "Total_cho_Unit" , "CVD_Risk" , "HDL" , "HDL_unit" , "LDL" , "LDL_unit" , "Triglyceride" , "Triglyceride_unit" , "Pulse" , "Pulse_rate", "Diabetic_foot" , "Diabetic_Neuropathy" , "Lifestyle advice" , "Medication changed" , "Patient_adhe medic" , "Drug_Supply" , "F_Amlodipine_dose" , "F_Amlodipine_Freq" , "F_Amlodipine_duration" , "F_Amlodipine_durUnit" , "F_Enalapril_dose" , "F_Enalapril_Freq" , "F_Enalapril_duration" , "F_Enalapril_durUnit" , "F_Atorvastain_dose" , "F_Atorvastain_Freq" , "F_Atorvastain_duration" , "F_Atorvastain_durUnit" , "F_Hydrochlorothiazide_dose" , "F_Hydrochlorothiazide_Freq" , "F_Hydrochlorothiazide_duration" , "F_Hydrochlorothiazide_durUnit" , "F_Aspirin_dose" , "F_Aspirin_Freq" , "F_Aspirin_duration" , "F_Aspirin_durUnit" , "F_Metformin(500)_dose" , "F_ Metformin(500)_Freq" , "F_Metformin(500)_duration" , "F_Metformin(500)_durUnit" , "F_Metformin(1000)_dose" , "F_ Metformin(1000)_Freq" , "F_Metformin(1000)_duration" , "F_Metformin(1000)_durUnit" , "F_Gliclazide(500)_dose" , "F_Gliclazide(500)_Freq" , "F_Gliclazide(500)_duraion" , "F_Gliclazide(500)_durUnit" , "F_Gliclazide(1000)_dose" , "F_ Gliclazide(1000)_Freq" , "F_Gliclazide(1000)_duration" , "F_Gliclazide(1000)_durUnit" , "Symptom hypoglycemia" , "Foth_medi" , "Foth_medi_spec" , "Out_come" , "Tout_mam_clinic" , "Tout_physician_data" , "death_date" , "Cause_of_death" , "Fup_doc_initial" , "RBS result" , "visit_type", ] @endphp @foreach ($ncd_records as $ncd_record) {{-- get form ncd register table --}} @foreach ($columnses as $item) @endforeach @endforeach

Clinic code	General ID	Fuchia ID	Visit Date	Register Date	NCD Register Age	NCD Follow_UP Age	Sex	State	Township	NCD Diagnosis	Height	Weight	BMI	Type_current_visit	Late_duration	late_duration_unit	Followup_required_Duration	Fup_req_dur_unit	Next:Follow_up_date	Time	BP MAM	BP state	FBS result	FBS Date	2HPP	2Hpp Date	Location_of_test	Other Lab Result Date	ALT	HBA1C	Urine_ACR	Glucose result	Protein result	Creatinine	Creatinine unit	CRCL	Total cholesterol	Total cholesterol unit	CVD_risk	HDL	HDL_unit	LDL	LDL unit	Triglyceride	Triglyceride unit	Pulse	Pulse rate	Diabetic foot	Diabetic Neuropathy	Lifestyle advice	Medication changed	Patient Adherence to medication	Drug supply	Amlodipine dose	Amlodipine frequency	Amlodipine dose duration	Amlodipine dose duration_unit	Enalapril dose	Enalapril frequency	Enalapril duration	Enalapril duration_unit	Atorvastain dose	Atorvastain frequency	Atorvastain duration	Atorvastain duration_unit	Hydrochlorothiazide dose	Hydrochlorothiazide frequency	Hydrochlorothiazide duration	Hydrochlorothiazide duration_unit	Aspirin dose	Aspirin frequency	Aspirin duration	Aspirin duration_unit	Metformin(500) dose	Metformin(500) frequency	Metformin(500) duration	Metformin(500) duration_unit	Metformin(1000) dose	Metformin(1000) frequency	Metformin(1000) duration	Metformin(1000) duration_unit	Gliclazide(500) dose	Gliclazide(500) frequency	Gliclazide(500) duration	Gliclazide(500) duration_unit	Gliclazide(1000) dose	Gliclazide(1000) frequency	Gliclazide(1000) duration	Gliclazide(1000) duration_unit	Symptom hypoglycemia	Followup Other Medication	Other_med_spec	Outcome	Tout_mam_clinic	Tout_physician	Death Date	Cause_of_death	Dr Initial	RBS result	Visit type(old data)
{{$ncd_record["Clinic Code"]}}	{{$ncd_record["Pid"]}}	{{$ncd_record["FuchiaID"]}}	{{$ncd_record["Visit_date"]}}	{{$ncd_record["Reg_Date"]}}	{{$ncd_record["visit_Age"]}}	{{$ncd_record["Current Agey"]}}	{{$ncd_record["Gender"]}}	{{$ncd_record["Area_Division"]}}	{{$ncd_record["Township"]}}	{{$ncd_record["NCD_Diagnosis"]}}	{{$ncd_record["Follow_Height"]}}	{{$ncd_record["Follow_Weight"]}}	{{$ncd_record["Follow_Bmi"]}}	{{$ncd_record["Type_cur_visit"]}}	{{$ncd_record["Late_visit"]}}	{{$ncd_record["Late_duration"]}}	{{$ncd_record["Late_follow"]}}	{{$ncd_record[$item]}}