File manager

File manager - Edit - /home/autoph/public_html/portal/backup/phic-statement-of-account.php

Back
<?php include 'core/init.php'; $user = $user_data['u_name']; $fuser = $user_data['u_fname']; $luser = $user_data['u_lname']; $compCode = $user_data['company_assignment']; $branchName = mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`='$compCode'"),0); $branchAddress = mysql_result(mysql_query("SELECT `company_address` FROM `company` WHERE `company_id`='$compCode'"),0); $rangeFrom=$_GET['dateFrom']; $rangeTo=$_GET['dateTo']; $transID = $_GET['transID']; $by = $_GET['by']; $byFUser = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `u_name`='$by'"),0); $byLUser = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `u_name`='$by'"),0); ?> <script type="text/javascript"> function printpage() { //Get the print button and put it into a variable var printButton = document.getElementById("printpagebutton"); //var postButton = document.getElementById("postbutton"); //Set the print button visibility to 'hidden' removeButton printButton.style.visibility = 'hidden'; //postButton.style.visibility = 'hidden'; //Print the page content window.print() //Set the print button to 'visible' again //[Delete this line if you want it to stay hidden after printing] printButton.style.visibility = 'visible'; //postButton.style.visibility = 'visible'; } </script> <center><input id="printpagebutton" type="button" value="Print..." onclick="printpage()"/> <table style="border-collapse:collapse;background:#fff:border:none;height:100%;width:100%"> <tr> <td valign="top" class="lightGradient" style="width:400px;border:1px solid white;border-bottom:1px solid lightgray;height:32px;font-size:14px;font-weight:normal;color:gray"> <b style="font-size:20px;color:black;font-family:Calibri">PHILHEALTH UTILIZATION SUMMARY</b> <br><?php echo "<b style='font-size:14px'>".$branchName."</b>";?> <br><?php echo "<i style='font-size:12px'>" . $branchAddress ."</i>";?><br><br> Date Covered: <?php echo $rangeFrom . " - " . $rangeTo ; ?> </td> <td valign="top" class="lightGradient" style="border:1px solid white;border-bottom:1px solid lightgray;height:32px;font-size:14px;font-weight:normal;color:gray"> </td> </tr> <tr> <td colspan='2' valign="top" style="min-height:300px;width:100%;border:1px solid white;font-size:14px;weight:bold;color:gray;background:white;border-bottom:1px solid lightgray"> <?php //Load header Table $qq=mysql_query("SELECT * FROM `pindex_hdr` WHERE `branch_code`='$compCode' AND `processed_phic`='0' AND `index_hdr_status`='Open' ORDER by `index_hdr_lname` ASC"); echo "<table style='width:100%; height:95% border:1px solid white; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:30px;background:#f5f5f5;border:1px solid gray;font-size:12px;font-family:calibri;height:25px'>NO</th> <th class='Gradient' style='text-align:center;width:150px;background:#f5f5f5;border:1px solid gray;font-size:12px;font-family:calibri;height:25px'>NAME</th> <th class='Gradient' align='center' style='font-size:12px;font-family:calibri;width:50px;background:#f5f5f5;border:1px solid gray;font-size:12px'>PHIC Package</th> <th class='Gradient' align='center' style='font-size:12px;font-family:calibri;width:50px;background:#f5f5f5;border:1px solid gray;font-size:12px'>Remarks</th> <th class='Gradient' align='center' style='font-size:12px;font-family:calibri;width:500px;background:#f5f5f5;border:1px solid gray;font-size:12px'>Treatment Dates</th> <th class='Gradient' align='center' style='font-size:12px;font-family:calibri;width:60px;background:#f5f5f5;border:1px solid gray;font-size:12px'>TOTAL NO. OF TX</th> <th class='Gradient' align='center' style='font-size:12px;font-family:calibri;width:40px;background:#f5f5f5;border:1px solid gray;font-size:12px'>Billable</th> <th class='Gradient' align='center' style='font-size:12px;font-family:calibri;width:120px;background:#f5f5f5;border:1px solid gray;font-size:12px'>NEPHROLOGIST</th> </tr>"; 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 "<tr>"; $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 "<td style='font-size:12px;font-family:calibri;text-align:center;border:1px solid gray'>".$count."</td>"; echo "<td style='font-size:12px;font-family:calibri;text-align:left;border:1px solid gray'>".$row['index_hdr_lname'].", ".$row['index_hdr_fname']."</td>"; echo "<td style='font-size:12px;font-family:calibri;text-align:right;border:1px solid gray;background:#F5C270;font-weight:bold'>"; $headPacakge = $row['index_hdr_package']; if($headPacakge ==='OUTRIGHT_PATIENT'){ // echo "<center>NBBP</center>"; //}else { // echo $myCoPay; } echo "<td style='font-size:12px;font-family:calibri;text-align:center;border:1px solid gray'>".$row['index_alloted_treatment']."</td>"; echo "<td style='font-size:12px;font-family:calibri;text-align:left;border:1px solid gray'>"; //$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 "<table style='border:1px solid white; border-collapse:collapse;'>"; echo "<tr>"; while($TDrow = mysql_fetch_array($qqTD)){ $sdate = explode("/",$TDrow['date_added']); $sday = $sdate[1]; $smon = $sdate[0]; $usageSessionCount = $usageSessionCount +1; echo "<td style='min-width:35px;font-size:12px;border:1px solid gray;text-align:center;border:1px solid white;border-right:1px solid gray'>".$smon ."/".$sday." </td>"; } echo "</tr> </table>"; echo "</td>"; echo "<td style='font-size:12px;font-family:calibri;text-align:center;border:1px solid gray'>"; //$remainingSession = $allotedTreatment - $usageSession; echo $usageSessionCount; echo "</td>"; echo "<td style='font-size:12px;font-family:calibri;text-align:center;border:1px solid gray;font-weight:bold'>"; $remainingSession = $allotedTreatment - $usageSessionCount; echo $remainingSession; //echo $chkSessionCovered; echo "</td>"; echo "<td style='font-size:12px;font-family:calibri;text-align:left;border:1px solid gray'>"; //$remainingSession = $allotedTreatment - $usageSession; echo $docSuf ." ". $docLname . "," . $docFName; echo "</td>"; echo "</tr>"; } } echo "</table>"; ?> </td> </tr> <tr> <td colspan='2' valign="top" style="width:100%;border:1px solid white;font-size:14px;weight:bold;color:gray;background:white"> <br><br><?php echo "Date Printed: ". $toDate;?> <br><?php echo "Prepared by: ".$byFUser." ".$byLUser;?> </td> </tr> </table>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings