EPO ID".$PatientEPOID; //break; $exPackage =explode("---",$ptPackage); $myPackageName = $exPackage[0]; $myPackageCode = $exPackage[1]; $exDialyzer =explode("---",$ptDialyzer); $myDialyzerCode = $exDialyzer[1]; $myDialyzerID = $exDialyzer[0]; //============================= $taddress=$_POST['taddress']; $occupation=$_POST['occupation']; $paddress=$_POST['paddress']; $landline=$_POST['landline']; $mobile=$_POST['mobile']; $emergencycontat=$_POST['emergencycontat']; $emergencyaddress=$_POST['emergencyaddress']; $emergencymobile=$_POST['emergencymobile']; $emergencylandline=$_POST['emergencylandline']; $hpActive=$_POST['hpActive']; $hpType=$_POST['hpType']; $datediagnosed=$_POST['datediagnosed']; $datefirstdialysis=$_POST['datefirstdialysis']; $placeofdialysis=$_POST['placeofdialysis']; $tmember = $_POST['tmember']; $onPD = $_POST['onPD']; $HDReasons=$_POST['HDReasons']; $renaldiagnosis=$_POST['renaldiagnosis']; $comordities1=$_POST['comordities1']; $comordities2=$_POST['comordities2']; $comordities3=$_POST['comordities3']; $comordities4=$_POST['comordities4']; $comordities5=$_POST['comordities5']; $comordities6=$_POST['comordities6']; //$attendingphysician=$_POST['attendingphysician']; mysql_query("UPDATE `patient_list` SET `pf_type`='$pfType',`patient_package_code`='$myPackageCode',`tx_package`='$myPackageName',`region`='$region',`reg_city`='$regCity',`admission_date`='$admissionDate',`phic_member`='$tmember',`admission_status`='$AdmissionStatus',`hospital_id`='$HosID',`tx_frequency`='$frequency',`access`='$access',`patient_fname`='$fname',`patient_mname`='$mname',`patient_lname`='$lname',`patient_bday`='$bday',`patient_age`='$age',`patient_sex`='$sex',`patient_status`='$status',`phic_number`='$phicNumber',`assigned_doctor`='$doctor',`patient_occupation`='$occupation',`patient_taddress`='$taddress',`patient_paddress`='$paddress',`patient_mobile`='$mobile',`patient_line`='$landline', `patient_ername`='$emergencycontat',`patient_eraddress`='$emergencyaddress',`patient_ermobile`='$emergencymobile',`patient_erline`='$emergencylandline',`patient_datefirstdiagnose`='$datediagnosed',`patient_datefirstdialysis`='$datefirstdialysis', `patient_placedialysis`='$placeofdialysis',`patient_pd`='$onPD',`patient_pdreason`='$HDReasons',`patient_renal`='$renaldiagnosis',`patient_como1`='$comordities1',`patient_como2`='$comordities2',`patient_como3`='$comordities3',`patient_como4`='$comordities4',`patient_como5`='$comordities5',`patient_como6`='$comordities6',`hepa_class`='$hpActive',`hepa_type`='$hpType',`entry_type`='$referral',`epo`='$PatientEPOID',`dialyzer`='$myDialyzerCode' WHERE `patient_id`='$pID'"); mysql_query("UPDATE `pindex_hdr` SET `index_hdr_fname`='$fname',`index_hdr_mname`='$mname',`index_hdr_lname`='$lname' WHERE `index_patient_id`='$pID'"); mysql_query("UPDATE `treatment_session` SET `session_fname`='$fname',`session_lname`='$lname' WHERE `session_patient_id`='$pID'"); mysql_query("UPDATE `sales_journal` SET `cust_fname`='$fname',`cust_lname`='$lname' WHERE `patient_id`='$pID'"); if($dialyzerID != $myDialyzerCode){ $sql="INSERT INTO `patient_dialyzer_issuance` (`trans_id`,`dialyzer_id`,`patient_id`,`date_issue`,`time_issue`,`issued_by`,`branch_code`) VALUES('','$myDialyzerCode','$pID','$toDate','$currentTime','$u_id ','$compCode')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

Record Saved. Thank you!



"; } }else{ echo "

Record Saved. Thank you!



"; } } $pID=$_GET['pID']; $recordStatus =mysql_result(mysql_query("SELECT `nephro_status` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $docid = mysql_result(mysql_query("SELECT `assigned_doctor` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); // get name of doctor base on doctor it in the patient list $access = mysql_result(mysql_query("SELECT `access` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $region = mysql_result(mysql_query("SELECT `region` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $frequency = mysql_result(mysql_query("SELECT `tx_frequency` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $HospitalID = mysql_result(mysql_query("SELECT `hospital_id` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $HospitalName = mysql_result(mysql_query("SELECT `hos_name` FROM `hospitals` WHERE `hos_id` ='$HospitalID'"),0); $AdmissionStatus = mysql_result(mysql_query("SELECT `admission_status` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $ptINDialyzerID = mysql_result(mysql_query("SELECT `dialyzer` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $ptINDialyzer = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id` ='$ptINDialyzerID'"),0); $pfType = mysql_result(mysql_query("SELECT `pf_type` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $PackageCodeName = mysql_result(mysql_query("SELECT `tx_package` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $ptINPackageCode = mysql_result(mysql_query("SELECT `package_hdr_id` FROM `package_header` WHERE `package_code` ='$PackageCodeName'"),0); $getMyEPOID = mysql_result(mysql_query("SELECT `epo` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $getMyEPO = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id` ='$getMyEPOID'"),0); $lname = mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $fname = mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $mname = mysql_result(mysql_query("SELECT `patient_mname` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $sex = mysql_result(mysql_query("SELECT `patient_sex` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $age = mysql_result(mysql_query("SELECT `patient_age` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $status = mysql_result(mysql_query("SELECT `patient_status` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $occupation = mysql_result(mysql_query("SELECT `patient_occupation` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $bday = mysql_result(mysql_query("SELECT `patient_bday` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $renaldiagnosis = mysql_result(mysql_query("SELECT `patient_renal` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $fdoctor = mysql_result(mysql_query("SELECT `doc_fname` FROM `doctors_profile` WHERE `doc_id` ='$docid'"),0); $ldoctor = mysql_result(mysql_query("SELECT `doc_lname` FROM `doctors_profile` WHERE `doc_id` ='$docid'"),0); $regCity = mysql_result(mysql_query("SELECT `reg_city` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $phic_number = mysql_result(mysql_query("SELECT `phic_number` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $phic_member = mysql_result(mysql_query("SELECT `phic_member` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $taddress = mysql_result(mysql_query("SELECT `patient_taddress` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $paddress = mysql_result(mysql_query("SELECT `patient_paddress` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $mobile = mysql_result(mysql_query("SELECT `patient_mobile` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $eraddress = mysql_result(mysql_query("SELECT `patient_eraddress` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $line = mysql_result(mysql_query("SELECT `patient_line` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $ername = mysql_result(mysql_query("SELECT `patient_ername` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $ermobile = mysql_result(mysql_query("SELECT `patient_ermobile` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $erline = mysql_result(mysql_query("SELECT `patient_erline` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $admissionDate = mysql_result(mysql_query("SELECT `admission_date` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $datefirstdiagnose = mysql_result(mysql_query("SELECT `patient_datefirstdiagnose` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $hepaClass = mysql_result(mysql_query("SELECT `hepa_class` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $hepaType = mysql_result(mysql_query("SELECT `hepa_type` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $datefirstdialysis = mysql_result(mysql_query("SELECT `patient_datefirstdialysis` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $placedialysis= mysql_result(mysql_query("SELECT `patient_placedialysis` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $pd = mysql_result(mysql_query("SELECT `patient_pd` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $pdreason = mysql_result(mysql_query("SELECT `patient_pdreason` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $renal = mysql_result(mysql_query("SELECT `patient_renal` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $comordities1= mysql_result(mysql_query("SELECT `patient_como1` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $comordities2= mysql_result(mysql_query("SELECT `patient_como2` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $comordities3= mysql_result(mysql_query("SELECT `patient_como3` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $comordities4= mysql_result(mysql_query("SELECT `patient_como4` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $comordities5= mysql_result(mysql_query("SELECT `patient_como5` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $comordities6= mysql_result(mysql_query("SELECT `patient_como6` FROM `patient_list` WHERE `patient_id` ='$pID'"),0); $checkAccess = $user_data['edit_patient_reocrd']; ?>
Last Name:
 First Name:
 Middle Name:
 Age:
format('%y'); ?> 		Sex:
 Status:
Occupation:
 Landline No.:
 Mobile No.:
 Birthdate:          Access:                   TX Frequency/Week:
Present Address:
 City: PhilHealth No.:               PhilHealth Memeber:
Provincial/Other Address:
 Region:
 Referral:                    Assigned Doctor:

Nearest Relative (to notify in case of emergency):		 Admission Date
 HD Unit / Hospital
 Admission Status:
Relative Full Name:
 Contact Details:
Complete Address:
 Mobile Number:

Date first diagnosed with kidney disease (mm-dd-yyyy)
Date of first dialysis (mm-dd-yyyy)
Place where first dialysis done		 Hepatitis (HP) Hepatitis (Type)






Previously on PD?
If yes, what was the reason for shifting to HD?		 PF TYPE
Renal Diagnoses:
Dialyzer: EPO: Package:

Co-morbidities:
1. 2.
3. 4.
5. 6.