Header ID: ". $transHDRID; $transHDRID = mysql_result(mysql_query("SELECT `id` FROM `phic_claim_summary` WHERE `ref_number`='$ptransID'"),0); //exit; $pselCom =$_GET['selCom']; $pcompName = explode("---",$pselCom); $pcompanyID = $pcompName[1]; $selUser = $_POST['selUser']; $exSelUser = explode("---",$selUser); $selUserID = $exSelUser[1]; $patientLname= mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `patient_id`='$selUserID'"),0); $patientFname= mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id`='$selUserID'"),0); //CHECK IF CLAIMS EXISTS IN RECORS $checkClaims = mysql_result(mysql_query("SELECT COUNT('id') FROM `phic_claim_summary_dtl` WHERE `delete`= 0 AND `patient_id`='$selUserID' AND `tx_dateA` ='$txDateA' AND `branch_id`='$pcompanyID'"),0); if($checkClaims > 0){ $errorFileS = mysql_result(mysql_query("SELECT `date_start` FROM `phic_claim_summary_dtl` WHERE `delete`= 0 AND `patient_id` ='$selUserID' AND `date_start` BETWEEN '$pstartDate' AND '$pendDate' AND `branch_id`='$pcompanyID' || `delete`= 0 AND `patient_id` ='$selUserID' AND `date_end` BETWEEN '$pstartDate' AND '$pendDate' AND `branch_id`='$pcompanyID'"),0); $errorFileE= mysql_result(mysql_query("SELECT `date_end` FROM `phic_claim_summary_dtl` WHERE `delete`= 0 AND `patient_id` ='$selUserID' AND `date_start` BETWEEN '$pstartDate' AND '$pendDate' AND `branch_id`='$pcompanyID' || `delete`= 0 AND `patient_id` ='$selUserID' AND `date_end` BETWEEN '$pstartDate' AND '$pendDate' AND `branch_id`='$pcompanyID'"),0); echo "
"; echo "DUPLICATE FILING DETECTED
ERROR!

Duplicate Filing is detected for Patient ".$patientLname.", " .$patientFname. ". Same entry was filed on same date range ". $errorFileS ." - ".$errorFileE.". Please check your entry and try again!.

Thank you!
"; $insertHeader = 'false'; exit; } $dtlsql="INSERT INTO `phic_claim_summary_dtl` (`id`,`hdr_id`,`ref_number`,`patient_id`,`branch_id`,`encoded_by`,`date_start`,`date_end`,`type`,`amount`,`notes`,`last_name`,`first_name`,`date_created`,`tx_dateA` ) VALUES('','$transHDRID','$ptransID','$selUserID','$pcompanyID','$user','$pstartDate','$pendDate','New','','','$patientLname','$patientFname','$toDate','$txDateA' )";// if(!mysql_query($dtlsql)){ die('Error: ' . mysql_error()); }else{ } $insertHeader = 'false'; echo "My Header Tagging: ". $insertHeader; } ?>
" . $_GET['search'] ."";?> &view=plist&id='>

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
Date Start:
required align='center' id='datepickerA' type='text' name='startdate' value='' style='background:;font-size:12px;color:;text-align:center;width:80px;height:30px;border:1px solid lightgray; border-radius:3px'> 		-
 Date End:
required align='center' id='datepicker' type='text' name='enddate' value='' style='background:;font-size:12px;color:;text-align:center;width:80px;height:30px;border:1px solid lightgray; border-radius:3px'>
Select Center:
> >
"; if($checkPosted > 0) { $chkDisabled ='Disabled'; $bgcolor='lightgray'; echo ""; }else { $chkDisabled ='enabled'; $bgcolor='#F78181'; echo " "; } if($checkPosted > 0) { echo " "; }else { echo " "; } echo "";echo "
"; if($checkPosted > 0) { echo "
"; }else { echo " "; } echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
No. Ref.No. Date Covered Patient Name. Confinement Date. Branch ID. Encoded By
".$count."".$row['ref_number']."".$row['date_start']." - ".$row['date_end']."".$row['last_name'].", ".$row['first_name']."".$row['tx_dateA']."".$row['branch_id']."".$row['encoded_by']."