NEPHRO GROUP

"; echo "

PhilHealth Notification:

"; echo "4

"; //========================================================================================== $q=mysql_query("SELECT * FROM `treatment_session` WHERE `phic_soa`='No' AND `phic_claim`='Valid' AND `branch_code`='$compCode'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=15; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)*$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT * FROM `treatment_session` WHERE `phic_soa` !='Post' AND `branch_code`='$compCode' ORDER by `date_added` ASC"); echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $addDate = $row['date_added']; //get lapses days from date of philhealth filed up to current date $diff = abs(strtotime($toDate) - strtotime($addDate)); $years = floor($diff / (365*60*60*24)); $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24)); $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); if($days >= 49 ){ $bgColor = '#FF6666'; }else { $bgColor = '#33FF66'; } if($months >1){ $msuffix ='s'; }else { $msuffix =''; } if($days >1){ $dsuffix ='s'; }else { $dsuffix =''; } //$diff=date_diff($toDate,$addDate); $sponsor_control_number='0'; $headID = $row['session_header_id']; //$sponsor_control_number = mysql_result(mysql_query("SELECT `sponsor_control_number` FROM `pindex_hdr` WHERE `index_hdr_id`='$headID'"),0); $tranID = $row['index_hdr_id']; //$gender = mysql_result(mysql_query("SELECT `patient_sex` FROM `patient_list` WHERE `patient_id` ='".$row['index_hdr_id']."'"),0); //$status = mysql_result(mysql_query("SELECT `patient_status` FROM `patient_list` WHERE `patient_id` ='".$row['session_patient_id']."'"),0); //$sesqq=mysql_query("SELECT * FROM `treatment_session` WHERE `session_header_id`='$tranID' AND `branch_code`='$compCode'"); // while($sesrow = mysql_fetch_array($sesqq)){ // $getTransID =$sesrow['session_header_id']; // if($getTransID==$tranID){ // $usage = $usage + $sesrow['sponsor_amount']; // } // } echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; echo "

Trans. #	First Name	Last Name	Package	Date	Lapses MM \| DD	Amount	-
" . $row['session_id'] . "	" . $sponsor_control_number . "	" . $row['session_fname'] . "	" . $row['session_lname'] . "	" . $row['session_package_code'] . "	" . $row['date_added'] . "	"; echo $months . " mon".$msuffix." & " . $days . " day".$dsuffix; echo "	" . number_format($row['session_package_copay'],2,'.',',') . "	Details
"; if($page_cur>1){ echo ' style="cursor:pointer;color:lightgray;" > '; }else { echo ''; } echo ' [ ' . $page_cur . ' of ' . $total_page . ' ] '; for($i=1;$i<=$total_page;$i++) { //if($page_cur==$i) //{ // echo ' '; //} //else //{ //echo ' '; //} } if($page_cur<$total_page) { echo ' '; } else { echo ''; } echo "

"; //========================================================================================== echo "

"; echo "