"; while($row = mysql_fetch_array($qq)){ $usageSessionCount=0; $pack = $row['index_hdr_package']; $hdrID = $row['index_hdr_id']; $patientID = $row['index_patient_id']; $allotedTreatment = $row['index_alloted_treatment']; $usageSession = mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `session_header_id`='$hdrID' AND `session_patient_id`='$patientID'"),0); $doctor = mysql_result(mysql_query("SELECT `assigned_doctor` FROM `patient_list` WHERE `patient_id`='$patientID'"),0); $docFName = mysql_result(mysql_query("SELECT `doc_fname` FROM `doctors_profile` WHERE `doc_id`='$doctor'"),0); $docLname = mysql_result(mysql_query("SELECT `doc_lname` FROM `doctors_profile` WHERE `doc_id`='$doctor'"),0); $docSuf = mysql_result(mysql_query("SELECT `suffix` FROM `doctors_profile` WHERE `doc_id`='$doctor'"),0); //Scan Treatment table based on header table to prevent duplicate entry echo ""; $chkSessionCovered=mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `phic_soa`='Yes' AND `branch_code`='$compCode' AND `phic_claim`='Valid' AND `session_patient_id`='$patientID' AND `date_added` BETWEEN '$rangeFrom' AND '$rangeTo'"),0); $headPackage=mysql_result(mysql_query("SELECT `session_package_code` FROM `treatment_session` WHERE `phic_soa`='Yes' AND `branch_code`='$compCode' AND `phic_claim`='Valid' AND `session_patient_id`='$patientID' AND `date_added` BETWEEN '$rangeFrom' AND '$rangeTo' AND `session_package_code`!='OUTRIGHT_PATIENT'"),0); if($chkSessionCovered > 0){ $count = $count + 1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "

PHILHEALTH UTILIZATION SUMMARY
".$branchName."";?>
" . $branchAddress ."";?>

Date Covered:

"; echo "

NAME

PHIC Package

Remarks

Treatment Dates

TOTAL NO. OF TX

Billable

NEPHROLOGIST

".$count."

".$row['index_hdr_lname'].", ".$row['index_hdr_fname']."

"; $headPacakge = $row['index_hdr_package']; if($headPacakge ==='OUTRIGHT_PATIENT'){ // echo "NBBP"; //}else { // echo $myCoPay; } echo "

".$row['index_alloted_treatment']."

"; //$qqHdr=mysql_query("SELECT * FROM `treatment_session` WHERE `branch_code`='$compCode' AND `phic_soa`='No' ORDER by `date_added` ASC"); $qqTD=mysql_query("SELECT * FROM `treatment_session` WHERE `phic_soa`='Yes' AND `branch_code`='$compCode' AND `phic_claim`='Valid' AND `session_patient_id`='$patientID' AND `phic_soa_code` ='$transID' AND `date_added` BETWEEN '$rangeFrom' AND '$rangeTo' AND `session_package_code`!='OUTRIGHT_PATIENT' ORDER by `session_id` ASC"); //$qqTD=mysql_query("SELECT * FROM `treatment_session` WHERE `phic_soa`='No' AND `branch_code`='$compCode' AND `phic_claim`='Valid' AND `session_patient_id`='$patientID' ORDER by `session_id` ASC"); echo ""; echo ""; while($TDrow = mysql_fetch_array($qqTD)){ $sdate = explode("/",$TDrow['date_added']); $sday = $sdate[1]; $smon = $sdate[0]; $usageSessionCount = $usageSessionCount +1; echo ""; } echo "

".$smon ."/".$sday."

"; echo "

"; //$remainingSession = $allotedTreatment - $usageSession; echo $usageSessionCount; echo "

"; $remainingSession = $allotedTreatment - $usageSessionCount; echo $remainingSession; //echo $chkSessionCovered; echo "

"; //$remainingSession = $allotedTreatment - $usageSession; echo $docSuf ." ". $docLname . "," . $docFName; echo "

"; ?>