format("W"); if(isset($_GET['empID'])){ $myPatientName = $empFname ." " .$empLname. "---". $empID; }else { $myPatientName = ''; } ?>
SPONSORS UTILIZATION SUMMARY: " .$empLname ." , ".$empFname ."";?>
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if($_GET['gName']==='INTELLICARE' || $_GET['gName']==='MEDICARD' || $_GET['gName']==='VALUECARE'){ echo ""; }else{ echo ""; } echo ""; echo ""; echo ""; echo ""; echo "
Name of Patient:"; echo ""; echo "
Select Item:"; echo ""; echo "
Type of Payment LOE No. Approval:
Quantity Amount:
O.R Number C.S Number
Remarks:
   
"; //====================================================== echo "
"; echo ""; echo ""; echo ""; echo "
"; $qq=mysql_query("SELECT * FROM `guarantee_letter_usage` WHERE `p_id`='$empID' AND `or_number`='$or' AND `branch_code`='$comCode' ORDER by `date` ASC"); echo ""; echo ""; //$TreatmentUsage = mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `session_patient_id`='$patientID' AND `session_header_id`='$transactionID'"),0); while($row = mysql_fetch_array($qq)){ $totalORAmount = $row['amount'] +$totalORAmount; $count = $count +1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo "
No. Availment Date Reference Number Item Description Qty Total Amount
".$count."".$row['date']."".$row['or_number'].""; $item_id = $row['item_id']; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$item_id'"),0); echo $itemDesc; echo "".$row['qty']."".$row['amount']."
TOTAL     "; echo number_format($totalORAmount,2,'.',','); echo "
"; echo "
"; echo "
"; //============================================================================================== } //============================================================================================== if(isset($_GET['action'])){ $search = $_GET['action']; if($search==='search'){ echo "
"; echo "

ITEM SEARCH...

"; echo "
"; echo "

"; echo ""; echo "
"; echo "
"; //search item //================================================================================================================= //================================================================================================================= if(isset($_POST['itemsearch'])){ $medicinelookup = $_POST['searchItem']; $q=mysql_query("SELECT * FROM `medicines` WHERE `medicine_desc` LIKE '%$medicinelookup%'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=30; $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 `medicines` WHERE `medicine_desc` LIKE '%$medicinelookup%'"); echo "
"; echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $itemID=$row['medicine_id']; $checkInvnty = mysql_result(mysql_query("SELECT `item_qty` FROM `inventory` WHERE `item_id`='$itemID'"),0); $count =$count + 1 ; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if($checkInvnty > 0){ echo ""; }else { echo ""; } echo ""; } echo "
No. Item Code Medicine Type -
".$count."".$row['item_code']."".$row['medicine_desc']."".$row['type']."
"; } } echo "
"; } //================================================================================================================= //================================================================================================================= //Saving Records Guarantee letter usage if(isset($_POST['addpayments'])){ $curYear =$toDate; $exCurYear = explode("/",$curYear); $selYear = $exCurYear[2]; //CHECK IF PCSO OR HMO $Type = $_GET['gName']; if($Type === 'PCSO'){ $pfType ='PCSO'; }else { $pfType ='HMO'; } $LOENumber = $_POST['LOENumber']; $ApprovalCode = $_POST['ApprovalCode']; $patientName = $_POST['patientName']; $itemName = $_POST['medicine']; $exPatient = explode("---",$patientName); $exItem = explode("---",$itemName); $hID = $_GET['hID']; $empID = $_GET['empID']; $itemID = $exItem[1]; $itemDesc= $exItem[0]; $pfName = mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id`='$empID'"),0); $plName = mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `patient_id`='$empID'"),0); $docID = mysql_result(mysql_query("SELECT `assigned_doctor` FROM `patient_list` WHERE `patient_id`='$empID'"),0); $paymentmethod=$_POST['paymentmethod']; $Amount=$_POST['Amount']; $remarks=$_POST['remarks']; $remarks = mysql_real_escape_string($remarks); $OrNo= $_GET['or']; $gName=$_GET['gName']; $CSNo= $_POST['CSNo']; //echo "My CS Number: ". $cs; //exit; $medType = mysql_result(mysql_query("SELECT `type` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); $qty = $_POST['qty']; //CHECK IF INVENTORY $pPackage =mysql_result(mysql_query("SELECT `index_hdr_package` FROM `pindex_hdr` WHERE `index_patient_id` = '$empID' AND `index_hdr_status`='Open' AND `branch_code`='$comCode'"),0); $onHand = mysql_result(mysql_query("SELECT `item_qty` FROM `inventory` WHERE `item_id`='$itemID' AND `inv_comp_id` = '$comCode'"),0); //UPDATE usage Amount $uAmount =mysql_result(mysql_query("SELECT `g_usage` FROM `guarantee_letter` WHERE `g_id`='$hID' AND `g_patient_id`='$empID' AND `ref_id`='$OrNo' AND `g_branch_code`='$comCode'"),0); $orAmount = mysql_result(mysql_query("SELECT `g_amount` FROM `guarantee_letter` WHERE `g_id`='$hID' AND `g_patient_id`='$empID' AND `ref_id`='$OrNo' AND `g_branch_code`='$comCode'"),0); $totalUsageIF = $uAmount + $Amount; $newAmount = $uAmount + $Amount; $balance = $orAmount - $uAmount; //==================================================================================================================== //==================================================================================================================== //==================================================================================================================== //INSERT ENTRY TO DIALYZER TABLE IF SELECTED ITEMS IS DIALYER //=========================================================== //Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`,issued_by`,`reused_count`,`expired_date`,`remarks`,`dialyer_status`) VA' at line 1 $checkItemType = mysql_result(mysql_query("SELECT `type` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); if($checkItemType ==='Dialyzer'){ $checkPrescription = mysql_result(mysql_query("SELECT `dialyzer` FROM `patient_list` WHERE `patient_id`='$empID'"),0); if($itemID != $checkPrescription){ //echo "
checkItemType" . $checkItemType; //echo "
checkPrescription" . $checkPrescription; //echo "
itemID" . $itemID; echo "

WRONG DIALYZER!
WARNING! You are giving a wrong Dialyzer to patient. Prescribed dialyzer by doctor was code: ".$checkPrescription.". Please check your entry and try again, or you may ask your nurser/doctor for updates. Thank you.


"; exit(); } $IssuedDialyzer = 'true'; } //================================================================================================================= //CHECK FOR DUPLICATE TREATMENT PAYMENT. SYSTEM WILL ALLOW ONLY ONE PAYMENT PER OR //================================================================================================================= if($itemID ==='219'){ $ddup = mysql_result(mysql_query("SELECT COUNT('payment_id') FROM `payments` WHERE `item_id` = '219' AND `patient_id`='$empID' AND `branch_code`='$comCode' AND `payment_date`='$toDate'"),0); if($ddup > 0){ echo "

SYSTEM ALERT!
WARNING! Duplicate treatment is detected, you can only process one (1) treament session per day per Patient. Please check your entry and try again.


"; exit(); } } //=========================================================== //CHECK IF PREVIOUSLY ISSUED DIALZYER STILL USABLE OR NOT EXHUASTED YET //=========================================================== $chkDialyzerUsage = mysql_result(mysql_query("SELECT `reused_count` FROM `dialyzer_usage` WHERE `pID`='$empID' AND `dialyzer_status`='Open' AND `dialyzer_code`='$itemID'"),0); if($chkDialyzerUsage < 10 && $chkDialyzerUsage !=''){ echo "

DIALYZER ISSUANCE ERROR
WARNING! Previously issued dialyzer is not exhausted yet with only (".$chkDialyzerUsage." / 10) re-used count. If dialyzer already expired, kindly update patient record first to process new issuance. Thank you.


"; exit(); } //==================================================================================================================== //==================================================================================================================== //==================================================================================================================== if($totalUsageIF > $orAmount) { echo "

Amount not sufficient. You only have ".number_format($balance,2,'.',',').". Please check your entry and try again. Thank you!




"; break; } if($itemDesc != 'Treatment'){ if($onHand >= $qty){ $adsql="INSERT INTO `guarantee_letter_usage` (`gu_id`, `g_id`,`ref_id`,`p_id`,`cs_number`, `or_number`,`item_id`, `qty`,`amount`,`date`, `time`,`by`,`branch_code`,`remarks`,`sponsor_loe`,`sponsor_approval`) VALUES('','$hID','$OrNo','$empID','$CSNo','$OrNo','$itemID','$qty','$Amount','$toDate','$currentTime','$user','$comCode','$remarks','$LOENumber','$ApprovalCode')"; if(!mysql_query($adsql)){ die('Error: ' . mysql_error()); }else{ } mysql_query("UPDATE `guarantee_letter` SET `g_usage` = '$newAmount' WHERE `g_patient_id`='$empID' AND `ref_id`='$OrNo' AND `g_branch_code`='$comCode'"); //UPDATE usage Amount //UPDATE INVENTORY RECORD $qtyBalance = $onHand - $qty; mysql_query("UPDATE `inventory` SET `item_qty` = '$qtyBalance' WHERE `item_id`='$itemID' AND `inv_comp_id`='$comCode'"); //CREATE HEADER IN SALES JOURNAL $checkIfExist = mysql_result(mysql_query("SELECT COUNT('journal_hdr') FROM `sales_journal_hdr` WHERE `journal_date`='$toDate' AND `journal_comp_id`='$comCode' AND `ref_number`='$OrNo'"),0); if($checkIfExist == 0){ $hdrsql="INSERT INTO `sales_journal_hdr` (`journal_hdr`, `ref_number`,`journal_patient_id`,`journal_date`,`journal_time`,`journal_by`,`journal_comp_id`,`cs_number`,`notes`) VALUES('','$OrNo','$empID','$toDate','$currentTime','$user','$comCode','$CSNo','Receivables')"; if(!mysql_query($hdrsql)){ die('Error: ' . mysql_error()); }else{ } } //Add entry to sales journal details $sql="INSERT INTO `sales_journal` (`sj_id`, `trans_id`,`patient_id`,`cust_fname`, `cust_lname`,`item_id`,`item_desc`, `trans_qty`,`amount`,`trans_type`,`trans_date`,`trans_time`,`trans_by`,`remarks`,`branch_code`,`doctor_id`,`cs_number`) VALUES('','$OrNo','$empID','$pfName','$plName','$itemID','$itemDesc','$qty','$Amount','$paymentmethod','$toDate','$currentTime','$user','$remarks','$comCode','$docID','$CSNo')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ } //UPDATE STOCKCARD TABLE $begQTY = $onHand; $endQTY = $begQTY - $qty; $sql="INSERT INTO `stockcard` (`stk_id`, `ref_number`, `trans_type`,`item_id`,`beg_qty`,`trans_qty`,`end_qty`,`date`,`time`,`branch_code`,`by`,`posted`,`transType`) VALUES('','$OrNo','Sales Transaction','$itemID','$begQTY','$qty','$endQTY','$toDate','$currentTime','$compCode','$user','No','$paymentmethod')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } //=========================================================== //INSERT ENTRY TO DIALYZER TABLE IF SELECTED ITEMS IS DIALYER //=========================================================== //$checkItemType = mysql_result(mysql_query("SELECT `type` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); // ErrorError: Unknown column 'dialyer_status' in 'field if($IssuedDialyzer === 'true'){ $hdrsql="INSERT INTO `dialyzer_usage` (`trans_id`,`pay_id`,`issued_date`,`issued_time`,`issued_by`,`reused_count`,`expired_date`,`remarks`,`dialyzer_status`,`pID`,`dialyzer_code`) VALUES('','$OrNo','$toDate','$currentTime','$user','','','New Issuance','Open','$empID','$itemID')"; if(!mysql_query($hdrsql)){ die('Error: ' . mysql_error()); }else{ } } //=========================================================== //=========================================================== //Insert records to payments table // amount chargeable to sponsor $sql="INSERT INTO `payments` (`payment_id`, `last_name`,`payment_or`,`payment_amount`, `payment_type`, `payment_by`,`payment_date`,`payment_time`, `quantity`,`item_id`,`patient_id`,`payment_method`,`branch_code`,`remarks`,`cancel`,`year`,`week`,`payment_cs`,`sponsor_loe`,`sponsor_approval`) VALUES('','$plName','$OrNo','$Amount','$medType','$user','$toDate','$currentTime','$qty','$itemID','$empID','$paymentmethod','$comCode','$remarks','no','$selYear','$week','$CSNo','$LOENumber','$ApprovalCode')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

Payment has been received with issued O.R Number ".$OrNo.".

Thank you!




"; } }else{ echo "

Sorry, you don't have enough stock available. Please check your entry and try again.

Thank you!




"; } }else{ //=====================================================================================================================================================// // IF TREATMENT TRANSACTION USING GL //=====================================================================================================================================================// if($pPackage==='OUTRIGHT_PATIENT'){ $pfType = mysql_result(mysql_query("SELECT `pf_type` FROM `patient_list` WHERE `patient_id`='$empID'"),0); // PER BRACH PACKAGE $ChargeablePF = mysql_result(mysql_query("SELECT `doctor_pf` FROM `package_header` WHERE `package_code`='$pPackage' AND `branch_code`='$comCode'"),0); $PgName = $_GET['gName']; $gName = "Tx-".$PgName; $gPFName =$gName ."-PF"; $gINCName =$gName ."-Incentive"; $ChargeablePF = mysql_result(mysql_query("SELECT `pf_amount` FROM `sponsors` WHERE `sponsor_name`='$PgName'"),0); $ChargeableIncentives =mysql_result(mysql_query("SELECT `incentive` FROM `sponsors` WHERE `sponsor_name`='$PgName'"),0); $companyAmount = ($Amount - $ChargeablePF) - $ChargeableIncentives; $docID = mysql_result(mysql_query("SELECT `assigned_doctor` FROM `patient_list` WHERE `patient_id`='$empID'"),0); //CREATE HEADER IN SALES JOURNAL $checkIfExist = mysql_result(mysql_query("SELECT COUNT('journal_hdr') FROM `sales_journal_hdr` WHERE `journal_date`='$toDate' AND `journal_comp_id`='$comCode' AND `ref_number`='$OrNo'"),0); if($checkIfExist == 0){ $hdrsql="INSERT INTO `sales_journal_hdr` (`journal_hdr`, `ref_number`,`journal_patient_id`,`journal_date`,`journal_time`,`journal_by`,`journal_comp_id`,`cs_number`,`notes`) VALUES('','$OrNo','$empID','$toDate','$currentTime','$user','$comCode','$CSNo','Receivables')"; if(!mysql_query($hdrsql)){ die('Error: ' . mysql_error()); }else{ } } //insert charging amount to sales journal tag as cash (co-pay amount) $sql="INSERT INTO `sales_journal` (`sj_id`, `trans_id`,`cs_number`,`patient_id`,`cust_fname`, `cust_lname`,`item_id`,`item_desc`, `trans_qty`,`amount`,`trans_type`,`trans_date`,`trans_time`,`trans_by`,`remarks`,`branch_code`,`doctor_id`) VALUES('','$OrNo','$CSNo','$empID','$pfName','$plName','0','$gName','1','$companyAmount','Receivables','$toDate','$currentTime','$user','','$comCode','$docID')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ } //insert PF amount to sales journal $sql="INSERT INTO `sales_journal` (`sj_id`, `trans_id`,`cs_number`,`patient_id`,`cust_fname`, `cust_lname`,`item_id`,`item_desc`, `trans_qty`,`amount`,`trans_type`,`trans_date`,`trans_time`,`trans_by`,`remarks`,`branch_code`,`doctor_id`) VALUES('','$OrNo','$CSNo','$empID','$pfName','$plName','0','$gPFName','1','$ChargeablePF','Receivables','$toDate','$currentTime','$user','','$comCode','$docID')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ } if($ChargeableIncentives > 0){ $sql="INSERT INTO `sales_journal` (`sj_id`, `trans_id`,`cs_number`,`patient_id`,`cust_fname`, `cust_lname`,`item_id`,`item_desc`, `trans_qty`,`amount`,`trans_type`,`trans_date`,`trans_time`,`trans_by`,`remarks`,`branch_code`,`doctor_id`) VALUES('','$OrNo','$CSNo','$empID','$pfName','$plName','0','$gINCName','1','$ChargeableIncentives','$paymentmethod','$toDate','$currentTime','$user','','$comCode','$docID')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ } } $adsql="INSERT INTO `guarantee_letter_usage` (`gu_id`, `g_id`,`ref_id`,`p_id`,`cs_number`, `or_number`,`item_id`, `qty`,`amount`,`date`, `time`,`by`,`branch_code`,`remarks`,`sponsor_loe`,`sponsor_approval`) VALUES('','$hID','$OrNo','$empID','$CSNo','$OrNo','$itemID','$qty','$Amount','$toDate','$currentTime','$user','$comCode','$remarks','$LOENumber','$ApprovalCode')"; if(!mysql_query($adsql)){ die('Error: ' . mysql_error()); }else{ } mysql_query("UPDATE `guarantee_letter` SET `g_usage` = '$newAmount' WHERE `g_patient_id`='$empID' AND `ref_id`='$OrNo' AND `g_branch_code`='$comCode'"); //NEWLY ADJUSTED CODE TO AUTOMATE ENDORSEMENT OF PATIENT FOR OUTRIGHT PACKAGE //IF item is TREATMENT //ENDORSE PATIENT TO NURSE STATIONS IF TREAMENT PAYMENT IS DETECTED DURING CASHIER'S TRANSACTION //UPDATE CHECK-IN STATUS mysql_query("UPDATE `pindex_hdr` SET `active_session` = 'Yes',`pf_type`='$pfType', `patient_status`='In' WHERE `index_hdr_status`='Open' AND `branch_code`='$comCode' AND `index_patient_id`='$empID'"); mysql_query("UPDATE `patient_list` SET `patient_status`='In' WHERE `patient_id`='$empID' AND `branch_code`='$comCode'"); //Insert records to payments table $sql="INSERT INTO `payments` (`payment_id`, `last_name`,`payment_or`,`payment_cs`,`payment_amount`, `payment_type`, `payment_by`,`payment_date`,`payment_time`, `quantity`,`item_id`,`patient_id`,`payment_method`,`branch_code`,`remarks`,`sponsor_loe`,`sponsor_approval`) VALUES('','$plName','$OrNo','$CSNo','$Amount','$medType','$user','$toDate','$currentTime','$qty','$itemID','$empID','$paymentmethod','$comCode','$remarks','$LOENumber','$ApprovalCode')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

Payment has been received with issued O.R Number ".$OrNo.".

Thank you!




"; } } else { echo "

Please change package to OUTRIGHT_PATIENT....

Thank you!




"; } } } } ?>