<?php
include "../../myDatabase.php";
$registrationNo = $_GET['registrationNo'];
$batchNo = $_GET['batchNo'];
$serverTime = $_GET['serverTime'];
$username = $_GET['username'];
$ro = new database();
//if( $room == "" ) {
//echo "<font color=red>The Patient Has No room.....Pls Select an appropriate room for patient before you can charge</font>";
//$ro->getAvailableCharges($_GET['charges'],$registrationNo,$batchNo,$ro->getSynapseTime(),$username,"OPD_OPD");
//}else {
$ro->getAvailableCharges($_GET['charges'], $registrationNo, $batchNo, $ro->getSynapseTime(), $username, "");
//}
<?php
include "../../../myDatabase1.php";
$userz = $_GET['username'];
$ro = new database();
$ro->coconutDesign();
$ro->coconutFormStart("get", "addVoucher1.php");
$ro->coconutHidden("username", $userz);
$ro->coconutHidden("timeIssued", $ro->getSynapseTime());
echo "<Br><br>";
$ro->coconutBoxStart("500", "320");
echo "<br>";
echo "<table>";
echo "<tr>";
echo "<TD>Voucher#</tD>";
echo "<TD>";
$ro->coconutTextBox("voucherNo", "");
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<TD>Payment Mode</tD>";
echo "<TD>";
$ro->coconutComboBoxStart_long("paymentMode");
echo "<option value='cash'>Cash</option>";
echo "<option value='check'>Check</option>";
$ro->coconutComboBoxStop();
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<TD>Description</tD>";
echo "<TD>";
a.close();
}
</script>
<a href='#' onClick="printF('printData')" style="text-decoration:none;"><?php
echo $ro->coconutImages("printer.jpeg");
?>
<font color=red>Print</font></a><Br><Br>
<?php
echo "<div id='printData'>";
echo "Reg#: " . $registrationNo . " Batch#: " . $dispensedNo;
echo "<br>";
echo "Name: " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName();
echo "<br>";
echo "PHIC:" . $ro->getPatientRecord_phic() . " + " . $ro->getRegistrationDetails_company();
echo "<br>";
echo "Date" . date("M d, Y") . " @ " . $ro->getSynapseTime();
echo "<Br>";
echo "Room:" . $ro->getRegistrationDetails_room();
echo "<br>";
echo "Pharmacy:" . $username;
echo "<br>";
echo "Doctor:" . $ro->getAttendingDoc($registrationNo, "Attending");
echo "<table border=1 cellpadding=1 cellspacing=1>";
echo "<tr>";
echo "<th>Particulars</th>";
echo "<th>QTY</th>";
echo "</tr>";
for ($x = 0, $z = 0; $x < $disp, $z < $countz; $x++, $z++) {
echo "<Tr>";
$dispense = preg_split("/\\_/", $dispensed[$x]);
if ($ro->selectNow("patientCharges", "status", "itemNo", $remitted[$z]) == "PAID") {
$pricing = $_POST['pricing'];
$criticalLevel = $_POST['criticalLevel'];
$supplier = $_POST['supplier'];
$phicPrice = $_POST['phicPrice'];
$companyPrice = $_POST['companyPrice'];
$autoDispense = $_POST['autoDispense'];
$chargingStatus = $_POST['chargingStatus'];
$stockCardNo = $_POST['stockCardNo'];
$status = $_POST['status'];
$ro = new database();
$begCapital = $unitcost * $quantity;
$expiration = $year . "-" . $month . "-" . $day;
$pricingOption;
if ($inventoryType == "medicine" && $additional == "") {
echo "<script type='text/javascript'>alert('Pls input the price of medicine.');history.back(-1);</script>";
} else {
if ($status == "new") {
$ro->addInventoryStockCard($stockCardNo, $description, $generic, date("Y-m-d"), $addedBy, $inventoryType);
if ($inventoryType == "supplies") {
$ro->addNewMedicine($stockCardNo, $description, $generic, $pricing, $quantity, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, "", $criticalLevel, $supplier, $begCapital, $quantity, $unitcost, $autoDispense, $chargingStatus);
} else {
$ro->addNewMedicine($stockCardNo, $description, $generic, $unitcost, $quantity, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, $pricing . "_" . $additional, $criticalLevel, $supplier, $begCapital, $quantity, "", $autoDispense, $chargingStatus);
}
} else {
if ($inventoryType == "supplies") {
$ro->addNewMedicine($stockCardNo, $description, $generic, $pricing, $quantity, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, "", $criticalLevel, $supplier, $begCapital, $quantity, $unitcost, $autoDispense, $chargingStatus);
} else {
$ro->addNewMedicine($stockCardNo, $description, $generic, $unitcost, $quantity, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, $pricing . "_" . $additional, $criticalLevel, $supplier, $begCapital, $quantity, "", $autoDispense, $chargingStatus);
}
}
}
<?php include "../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $batchNo = $_GET['batchNo']; $serverTime = $_GET['serverTime']; $username = $_GET['username']; $searchBy = $_GET['searchBy']; $searchFrom = $_GET['searchFrom']; $branch = $_GET['branch']; $room = $_GET['room']; $ro = new database(); $ro->getAvailableMedicine($searchBy, $_GET['charges'], $registrationNo, $batchNo, $ro->getSynapseTime(), $username, $searchFrom, $branch, $room);
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$quantity = $_GET['quantity'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$paycash = $_GET['paycash'];
$remarks = $_GET['remarks'];
$stockCardNo = $_GET['stockCardNo'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
if ($quantity > $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode)) {
$ro->getBack("Current Stock is " . $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) . " only");
} else {
//$dateCharge = $year."-".$month."-".$day;
$discount = 0;
$totalPrice = $sellingPrice * $quantity;
//addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room,$remarks,$docSpecialization,$Capital,$stockCardNo,$dispenseFlag,$dispenseQTY)
//check autoDispense????
if ($ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $chargesCode) != "PHARMACY") {
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode);
// current qty ng meds/sup sa inventory
$newQTY = $currentQTY - $quantity;
// less sa inventory as in qty after ibawas ung desired qty ng user
$ro->editNow("inventory", "inventoryCode", $chargesCode, "quantity", $newQTY);
// update qty sa database
$ro->addCharges_cash_autoDispense($status, $registrationNo, $chargesCode, $description, $sellingPrice, $discount, $totalPrice, $totalPrice, "0", "0", $ro->getSynapseTime(), $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime(), $stockCardNo, "dispense", $quantity);
} else {
$ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $discount, $totalPrice, $totalPrice, "0", "0", $ro->getSynapseTime(), $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, $remarks, "", "", $stockCardNo, "", "");
}
}
<?php
include "../../../myDatabase.php";
require_once '../authentication.php';
$requestNo = $_POST['requestNo'];
$username = $_POST['username'];
$date = $_POST['date'];
$status = $_POST['status'];
$ro = new database();
$ro->editNow("admin2request", "requestNo", $requestNo, "status", $status . "_" . $username);
$ro->editNow("admin2request", "requestNo", $requestNo, "status_time", $ro->getSynapseTime());
$ro->editNow("admin2request", "requestNo", $requestNo, "status_date", date("Y-m-d"));
$ro->editNow("admin2request", "requestNo", $requestNo, "status_encodeIn", getenv("REMOTE_ADDR") . "-" . php_uname("n"));
//$ro->gotoPage("http://".$ro->getMyUrl()."/COCONUT/ADMIN/request/table.php?date=$date");
/*
echo "
<script>
setTimeout(function(){ history.go(-1); return false; },3000);
</script>
";
*/
echo "<Br><br><br><br><Br><Br><Br>";
echo "<CenteR>";
$ro->coconutImages("ajax-loader.gif");
if ($status == "APPROVED") {
echo " Please Wait While Approving.....";
} else {
echo " Please Wait While Cancelling.....";
}
echo "</center>";
?>
<?php include "../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $batchNo = $_GET['batchNo']; $serverTime = $_GET['serverTime']; $username = $_GET['username']; $searchBy = $_GET['searchBy']; $searchFrom = $_GET['searchFrom']; $branch = $_GET['branch']; $ro = new database(); $ro->getAvailableSupplies($searchBy, $_GET['charges'], $registrationNo, $batchNo, $ro->getSynapseTime(), $username, $searchFrom, $branch);
$fh = fopen($myFile, 'r');
$dispensedNo = fread($fh, 100);
fclose($fh);
$timezone = "Asia/Manila";
date_default_timezone_set($timezone);
for ($i = 0, $g = 0; $i < $countz, $g < $qty; $i++, $g++) {
//FOR LOOP
if ($ro->checkInventory($remitted[$i]) == "PHARMACY" || $ro->checkInventory($remitted[$i]) == "CSR") {
if ($ro->getChargesStatus($remitted[$i]) != "Return") {
if ($ro->selectNow("patientCharges", "dispensedNo", "itemNo", $remitted[$i]) == "") {
$ro->remitNow($remitted[$i], "dispensedBy_" . $username);
$ro->editNow("patientCharges", "itemNo", $remitted[$i], "departmentStatus_time", date("H:i:s"));
//MAGBBWAS SA QUANTITY NG CURRENT INVENTORY
$ro->changeQTY($ro->getChargesCode($remitted[$i]), $ro->getCurrentQTY($ro->getChargesCode($remitted[$i])) - $quantity[$g]);
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $ro->getChargesCode($remitted[$i])) < 1) {
$ro->insertInventoryZero($ro->selectNow("patientCharges", "chargesCode", "itemNo", $remitted[$i]), $ro->selectNow("patientCharges", "description", "itemNo", $remitted[$i]), $ro->getSynapseTime(), date("Y-m-d"), $username, $ro->selectNow("patientCharges", "registrationNo", "itemNo", $remitted[$i]), $remitted[$i]);
} else {
}
} else {
//echo "<font color=red>the meds/Supplies is allready dispensed</font><Br><br><Br>";
}
//echo $ro->getChargesCode($remitted[$i])."_".$remitted[$i];
//echo $quantity;
} else {
$ro->changeQTY($ro->getChargesCode($remitted[$i]), $ro->getCurrentQTY($ro->getChargesCode($remitted[$i])) + $quantity[$g]);
$deptStatus = preg_split("/\\_/", $ro->getDepartmentStatus($remitted[$i]));
if ($ro->getPatientChargesQTY($remitted[$i]) == $deptStatus[0]) {
//$ro->deletePatientCharges($deptStatus[1],$remitted[$i]); // DELETE CHARGES IF ALL WILL RETRUN
$ro->editNow("patientCharges", "itemNo", $remitted[$i], "status", "DELETED_" . $username);
//instead n delete tLGa i-tag nLang as Deleted so i can track who deleted the meds/sup.
$ro->editNow("patientCharges", "itemNo", $remitted[$i], "departmentStatus", "dispensedBy_" . $username);
$freegoods = $_POST['fgquantity'];
$ro = new database();
$quantity1 = $quantity + $freegoods;
$unitcost1 = $unitcost * $quantity / $quantity1;
$begCapital = $unitcost1 * $quantity1;
$expiration = $year . "-" . $month . "-" . $day;
if ($status == "new") {
//new inventory w/ stock card
$ro->addInventoryStockCard($stockCardNo, $description, $generic, date("Y-m-d"), $addedBy, $inventoryType);
$incrementStockCardNo = $ro->selectNow("trackingNo", "value", "name", "stockCardNo") + 1;
$ro->editNow("trackingNo", "name", "stockCardNo", "value", $incrementStockCardNo);
if ($inventoryType == "supplies") {
if (!is_numeric($quantity) || !is_numeric($unitcost) || !is_numeric($pricing) || !is_numeric($freegoods) || !is_numeric($criticalLevel)) {
echo "\n<script type='text/javascript' >\n alert('Invalid number. Try again!');\n window.location='addInventory_supplies.php?username={$username}&sino={$sino}&page={$page}&invoiceNo={$invoiceNo}&status={$status}&stockCardNo={$stockCardNo}&description={$description}';\n</script>\n";
} else {
$ro->addNewMedicinepurch($stockCardNo, $description, $generic, $pricing, $quantity1, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, "", $criticalLevel, $supplier, $begCapital, $quantity1, $unitcost1, $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $username, $sino, $page, $invoiceNo, $freegoods, $unitcost, $quantity);
}
} else {
if (!is_numeric($quantity) || !is_numeric($unitcost) || !is_numeric($additional) || !is_numeric($freegoods) || !is_numeric($criticalLevel) || !is_numeric($opdPrice) || !is_numeric($ipdPrice)) {
echo "\n<script type='text/javascript' >\n alert('Invalid number. Try again!');\n window.location='addInventory.php?username={$username}&sino={$sino}&page={$page}&invoiceNo={$invoiceNo}&status={$status}&stockCardNo={$stockCardNo}&description={$description}&genericName={$genericName}';\n</script>\n";
} else {
$ro->addNewMedicinepurch($stockCardNo, $description, $generic, $unitcost1, $quantity1, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, $pricing . "_" . $additional, $criticalLevel, $supplier, $begCapital, $quantity1, "", $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $username, $sino, $page, $invoiceNo, $freegoods, $unitcost, $quantity);
}
}
} else {
if ($inventoryType == "supplies") {
if (!is_numeric($quantity) || !is_numeric($unitcost) || !is_numeric($pricing) || !is_numeric($freegoods) || !is_numeric($criticalLevel)) {
echo "\n<script type='text/javascript' >\n alert('Invalid number. Try again!');\n window.location='addInventory_supplies.php?username={$username}&sino={$sino}&page={$page}&invoiceNo={$invoiceNo}&status={$status}&stockCardNo={$stockCardNo}&description={$description}';\n</script>\n";
} else {
$ro->addNewMedicinepurch($stockCardNo, $description, $generic, $pricing, $quantity1, $expiration, $addedBy, $date, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, "", $criticalLevel, $supplier, $begCapital, $quantity1, $unitcost1, $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $username, $sino, $page, $invoiceNo, $freegoods, $unitcost, $quantity);
}
} else {
echo "";
}
} else {
$unpaid = $totalPaid - $ro->getItemNo_total($cashierPaid[$x]);
$ro->paymentManager($cashierPaid[$x], "BALANCE", $username, abs($totalPaid), date("Y-m-d"), date("H:i:s"), abs($unpaid));
$ro->editNow("patientCharges", "itemNo", $cashierPaid[$x], "orNO", $orNO);
if ($paymentType != "Cash") {
$ro->editNow("patientCharges", "itemNo", $cashierPaid[$x], "paidVia", $paymentType);
$ro->editNow("patientCharges", "itemNo", $cashierPaid[$x], "orNO", $orNO);
} else {
echo "";
}
}
}
} else {
for ($x = 0; $x < $countz; $x++) {
//FOR LOOP
$ro->payBalance($cashierPaid[$x], date("M_d_Y"), $serverTime, $username, $totalPaid);
$ro->updateStatus($cashierPaid[$x], "PAID");
$ro->editCharges($cashierPaid[$x], "cashUnpaid", "0");
}
// FOR LOOP
}
} else {
if ($ro->getRegistrationDetails_type() == "IPD") {
$ro->addPayment($registrationNo, $totalPaid, date("Y-m-d"), $ro->getSynapseTime(), $username, "FULL PAYMENT", $orNO, $paymentType);
} else {
echo "<font color=red>I can't Determine if " . $ro->getPatientRecord_completeName() . " is an OPD or IPD. Pls Check Before I Can Proceed to Payment Processing</font> ";
}
}
}
</script>
<a href='#' onClick="printF('printData')" style="text-decoration:none;"><?php
echo $ro->coconutImages("printer.jpeg");
?>
<font color=red>Print</font></a><Br><Br>
<?php
echo "<div id='printData'>";
echo "\n<style type='text/css'>\n<!--\n.style1 {font-family: Arial;font-size: 16px;color: #000000;font-weight: bold;}\n.style2 {font-family: 'Times New Roman';font-size: 16px;color: #FF0000;font-weight: bold;}\n.style3 {text-decoration: none;font-family: Arial;font-size: 12px;color: #000000;font-weight: bold;}\n.style4 {font-family: Arial;font-size: 12px;color: #000000;font-weight: bold;}\n.style5 {font-family: Arial;font-size: 14px;color: #000000;}\n.style6 {font-family: Arial;font-size: 12px;color: #FFFFFF;}\n.style7 {font-family: Arial;font-size: 11px;color: #000000;}\n.style8 {font-family: Arial;font-size: 12px;color: #FFFFFF;font-weight: bold;}\n-->\n</style>\n";
echo "<span class='style4'>Reg#: </span><span class='style5'>" . $registrationNo . "</span><span class='style4'> Batch#: </span><span class='style5'>" . $dispensedNo . "</span>";
echo "<br>";
echo "<span class='style4'>Name: </span><span class='style5'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</span>";
echo "<br>";
echo "<span class='style4'>PHIC: </span><span class='style5'>" . $ro->getPatientRecord_phic() . " + " . $ro->getRegistrationDetails_company() . "</span>";
echo "<br>";
echo "<span class='style4'>Date: </span><span class='style5'>" . date("M d, Y") . " @ " . $ro->getSynapseTime() . "</span>";
echo "<Br>";
echo "<span class='style4'>Room: </span><span class='style5'>" . $ro->getRegistrationDetails_room() . "</span>";
echo "<br>";
echo "<span class='style4'>Pharmacy: </span><span class='style5'>" . $username . "</span>";
echo "<br>";
echo "<span class='style4'>Doctor: </span><span class='style5'>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</span>";
echo "<br /><br />";
echo "<table border=1 bordercolor=black cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td class='style4'> Particulars </td>";
echo "<td class='style4'> QTY </td>";
echo "</tr>";
for ($x = 0, $z = 0; $x < $disp, $z < $countz; $x++, $z++) {
if ($ro->selectNow("patientCharges", "dispensedNo", "itemNo", $remitted[$z]) == "") {
$ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $remitted[$z], "dispensedNo", $dispensedNo);
$username = $_GET['username'];
$remarks = $_GET['remarks'];
$ro = new database();
if (strpos($ro->selectNow("patientCharges", "departmentStatus", "itemNo", $itemNo), 'dispensedBy_') !== false) {
echo "<script type='text/javascript'>alert('You cannot delete that meds/sup here its already dispensed pls return instead in Medicine menu');</script>";
} else {
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") {
//echo "<script type='text/javascript'>alert('You cannot delete that meds/sup here its already dispensed pls return instead in Medicine menu');</script>";
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/itemDepartment.php?itemNo={$itemNo}&username={$username}&return=ecart");
} else {
$title = $ro->selectNow("patientCharges", "title", "itemNo", $itemNo);
//$ro->deleteNow("patientCharges","itemNo",$itemNo);
//$ro->editNow("patientCharges","itemNo",$itemNo,"status","DELETED_".$username."[".date("Y-m-d")."@".$ro->getSynapseTime()."]");
if ($title == "LABORATORY" || $title == "RADIOLOGY") {
if ($remarks == '') {
echo "<font size='4' color='red'><b>Please input your reason.</b></font>";
echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/reasonBeforeDeleteCart.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}&itemNo={$itemNo}'>";
} else {
$ro->editNow("patientCharges", "itemNo", $itemNo, "pendingDelete", "PENDING_" . $username . "_" . date("Y-m-d") . "_" . $ro->getSynapseTime());
$datetime = date("YmdHis");
$rem = $remarks . "_" . $datetime;
$ro->editNow("patientCharges", "itemNo", $itemNo, "deleteRemarks", $remarks);
echo "<font size='4' color='red'><b>Notify supervisor to delete the charge completely.</b></font>";
echo "<META HTTP-EQUIV='Refresh'CONTENT='4;URL=http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}'>";
}
} else {
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . $ro->getSynapseTime() . "]");
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}");
}
}
}
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$inventoryFrom = $_GET['inventoryFrom'];
$paycash = $_GET['paycash'];
$remarks = $_GET['remarks'];
$stockCardNo = $_GET['stockCardNo'];
$ro = new database();
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < 1) {
$ro->getBack("Sorry, Out of Stock");
}
echo "\n<style type='text/css'>\n.qty {order: 1px solid #000;color: #000;height:25px;width: 100px;padding:4px 4px 4px 10px;}\n</style>\n\n\n<br /><br /><br />\n<form method='get' action='http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/addCharges_cash.php'>\n<br>\n<div align='center'>\n<table border='1' cellpadding='0' cellspacing='0'>\n <tr>\n <td><table border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td colspan='2' height='25'><div align='left'><font size='4'><b> Select Syringe to use:</b></font></div></td>\n </tr>\n <tr>\n <td colspan='3' height='30'> <input type='button' class='button' value=' <<Back ' onClick='javascript: history.go(-1)' style='border:1px solid #000000; background-color:transparent;'></td>\n </tr>\n <tr>\n <td colspan='2' height='20'></td>\n </tr>\n <tr>\n <td><div align='left'> No Syringe </div></td>\n <td width='100'><div align='center'> </div></td>\n <td> <a href='http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/quantitySyringe.php?status=UNPAID®istrationNo={$registrationNo}&chargesCode=&description=&sellingPrice=0&timeCharge=" . $ro->getSynapseTime() . "&chargeBy={$username}&service=Others&title=SUPPLIES&paidVia=Cash&cashPaid=0&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}&discount=0&room=&paycash=no&remarks=&classification=&status2={$status}&qty2=1®istrationNo2={$registrationNo}&chargesCode2={$chargesCode}&description2={$description}&sellingPrice2={$sellingPrice}&month2=" . date("m") . "&day2=" . date("d") . "&year2=" . date("Y") . "&timeCharge2={$timeCharge}&chargeBy2={$chargeBy}&service2={$service}&title2={$title}&paidVia2={$paidVia}&cashPaid2={$cashPaid}&batchNo2={$batchNo}&username2={$username}&discount2={$discount}&inventoryFrom2={$inventoryFrom}&room2={$room}&paycash2={$paycash}&remarks2={$remarks}'><font color=blue>[SELECT]</font></a> </td>\n </tr>\n <tr>\n <td colspan='2' height='20'></td>\n </tr>\n <tr>\n <td colspan='3' height='20'><b>Inventory From {$inventoryFrom}</b></td>\n </tr>\n <tr>\n <td height='15'><div align='left'><font color='green' size='1'><b>Description</b></div></td>\n <td height='15'><div align='center'><font color='green' size='1'><b>Qty</b></div></td>\n <td height='15'><div align='center'><font color='green' size='1'><b></b></div></td>\n </tr>\n";
$asql = mysql_query("SELECT inventoryCode,description,unitcost,quantity,classification FROM inventory WHERE description LIKE '%%%%%%%%syringe%%%%%%%' AND inventoryType='supplies' AND inventoryLocation='{$inventoryFrom}' AND quantity > 0 AND status NOT LIKE 'DELETED_%%%%%%' GROUP BY description ORDER BY description ASC");
while ($row = mysql_fetch_array($asql)) {
echo "\n <tr>\n <td><div align='left'> " . $row['description'] . " </div></td>\n <td width='100'><div align='center'> " . $row['quantity'] . " </div></td>\n <td> <a href='http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/quantitySyringe.php?status=UNPAID®istrationNo={$registrationNo}&chargesCode={$row['inventoryCode']}&description={$row['description']}&sellingPrice=0&timeCharge=" . $ro->getSynapseTime() . "&chargeBy={$username}&service=Others&title=SUPPLIES&paidVia=Cash&cashPaid=0&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}&discount=0&room=&paycash=no&remarks=&classification={$row['classification']}&status2={$status}&qty2=1®istrationNo2={$registrationNo}&chargesCode2={$chargesCode}&description2={$description}&sellingPrice2={$sellingPrice}&month2=" . date("m") . "&day2=" . date("d") . "&year2=" . date("Y") . "&timeCharge2={$timeCharge}&chargeBy2={$chargeBy}&service2={$service}&title2={$title}&paidVia2={$paidVia}&cashPaid2={$cashPaid}&batchNo2={$batchNo}&username2={$username}&discount2={$discount}&inventoryFrom2={$inventoryFrom}&room2={$room}&paycash2={$paycash}&remarks2={$remarks}'><font color=blue>[SELECT]</font></a> </td>\n </tr>\n";
}
echo "\n <tr>\n <td colspan='2' height='20'></td>\n </tr>\n";
$bsql = mysql_query("SELECT inventoryLocation FROM inventory WHERE inventoryType='supplies' AND (inventoryLocation NOT LIKE '{$inventoryFrom}' AND inventoryLocation NOT LIKE 'CSR') AND quantity > 0 AND status NOT LIKE 'DELETED_%%%%%%' GROUP BY inventoryLocation ORDER BY inventoryLocation");
while ($bfetch = mysql_fetch_array($bsql)) {
$binventoryloc = $bfetch['inventoryLocation'];
$csql = mysql_query("SELECT inventoryCode,description,unitcost,quantity,classification FROM inventory WHERE description LIKE '%%%%%%%%syringe%%%%%%%' AND inventoryType='supplies' AND inventoryLocation='{$binventoryloc}' AND quantity > 0 AND status NOT LIKE 'DELETED_%%%%%%' GROUP BY description ORDER BY description ASC");
$ccount = mysql_num_rows($csql);
if ($ccount != 0) {
echo "\n <tr>\n <td colspan='3' height='20'><b>Inventory From {$binventoryloc}</b></td>\n </tr>\n <tr>\n <td height='15'><div align='left'><font color='green' size='1'><b>Description</b></div></td>\n <td height='15'><div align='center'><font color='green' size='1'><b>Qty</b></div></td>\n <td height='15'><div align='center'><font color='green' size='1'><b></b></div></td>\n </tr>\n";
while ($cfetch = mysql_fetch_array($csql)) {
echo "\n <tr>\n <td><div align='left'> " . $cfetch['description'] . " </div></td>\n <td width='100'><div align='center'> " . $cfetch['quantity'] . " </div></td>\n <td> <a href='http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/quantitySyringe.php?status=UNPAID®istrationNo={$registrationNo}&chargesCode={$cfetch['inventoryCode']}&description={$cfetch['description']}&sellingPrice=0&timeCharge=" . $ro->getSynapseTime() . "&chargeBy={$username}&service=Others&title=SUPPLIES&paidVia=Cash&cashPaid=0&batchNo={$batchNo}&username={$username}&inventoryFrom={$binventoryloc}&discount=0&room=&paycash=no&remarks=&classification={$cfetch['classification']}&status2={$status}&qty2=1®istrationNo2={$registrationNo}&chargesCode2={$chargesCode}&description2={$description}&sellingPrice2={$sellingPrice}&month2=" . date("m") . "&day2=" . date("d") . "&year2=" . date("Y") . "&timeCharge2={$timeCharge}&chargeBy2={$chargeBy}&service2={$service}&title2={$title}&paidVia2={$paidVia}&cashPaid2={$cashPaid}&batchNo2={$batchNo}&username2={$username}&discount2={$discount}&inventoryFrom2={$inventoryFrom}&room2={$room}&paycash2={$paycash}&remarks2={$remarks}'><font color=blue>[SELECT]</font></a> </td>\n </tr>\n";
}
<?php
include "../../../myDatabase.php";
$itemNo = $_GET['itemNo'];
$batchNo = $_GET['batchNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
if ($ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) != "PHARMACY") {
//echo "<script type='text/javascript'>alert('You cannot delete that meds/sup here its already dispensed pls return instead in Medicine menu');</script>";
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/itemDepartment.php?itemNo={$itemNo}&username={$username}&return=ecart");
} else {
//$ro->deleteNow("patientCharges","itemNo",$itemNo);
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . $ro->getSynapseTime() . "]");
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}");
<?php
include "../../myDatabase.php";
$comment = $_GET['comment'];
$username = $_GET['username'];
$ro = new database();
if ($comment != "") {
$ro->addNewNote("", "guest", $username, $comment, date("M d, Y"), $ro->getSynapseTime());
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Homepage/homepage.php");
} else {
echo "\n<script type='text/javascript'>\nalert('Pls put a message');\nhistory.back();\n</script>\n\n";
}
<?php
include "../../../myDatabase.php";
$unlockNo = $_GET['unlockNo'];
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "timeClosed", $ro->getSynapseTime());
$ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "dateClosed", date("Y-m-d"));
$ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "status", "Closed");
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/currentPatient/locked/showLocked.php?registrationNo={$registrationNo}&username={$username}");
$timeCharge = $_GET['timeCharge'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$quantity = $_GET['quantity'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
//public function addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
//selectNow($table,$cols,$identifier,$identifierData)
$medsPrice = preg_split("/\\_/", $ro->selectNow("inventory", "Added", "inventoryCode", $chargesCode));
$companyPrice = $medsPrice[1] * 0.25 + $medsPrice[1];
$totalCompanyPrice = $companyPrice * $quantity;
//check autoDispense????
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $chargesCode) == "yes") {
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode);
// current qty ng meds/sup sa inventory
$newQTY = $currentQTY - $quantity;
// less sa inventory as in qty after ibawas ung desired qty ng user
$ro->editNow("inventory", "inventoryCode", $chargesCode, "quantity", $newQTY);
// update qty sa database
$ro->addCharges_cash_autoDispense($status, $registrationNo, $chargesCode, $description, $companyPrice, $discount, $totalCompanyPrice, "0", "0", $totalCompanyPrice, $ro->getSynapseTime(), date("M_d_Y"), $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime());
} else {
$ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $companyPrice, $discount, $totalCompanyPrice, "0", "0", $totalCompanyPrice, $ro->getSynapseTime(), date("M_d_Y"), $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room);
}
//$ro->addCharges_cash($status,$registrationNo,$chargesCode,$description,$companyPrice,$discount,$totalCompanyPrice,"0","0",$totalCompanyPrice,$ro->getSynapseTime(),date("M_d_Y"),$username,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$ro->getRegistrationDetails_branch(),$room);
<?php
include "../../../myDatabase.php";
$payee = $_POST['payee'];
$amount = $_POST['amount'];
$username = $_POST['username'];
$requestNo = $_POST['requestNo'];
$date = $_POST['date'];
$ro = new database();
$ro->coconutDesign();
$ro->editNow("admin2request", "requestNo", $requestNo, "releasedBy", $username);
$ro->editNow("admin2request", "requestNo", $requestNo, "releaseTime", $ro->getSynapseTime());
$ro->editNow("admin2request", "requestNo", $requestNo, "releaseDate", date("Y-m-d"));
$ro->editNow("admin2request", "requestNo", $requestNo, "releaseTo", $payee);
$ro->editNow("admin2request", "requestNo", $requestNo, "releasedAmount", $amount);
//$ro->gotoPage("http://".$ro->getMyUrl()."/COCONUT/ADMIN/request/viewApprovedRequest.php?date=$date&username=$username");
echo "\n<style type='text/css'>\ntr:hover { background-color:yellow; color:black;}\na { text-decoration:none; color:black; }\n</style>";
echo "Request#:" . $requestNo;
echo "<br>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Description</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "description", "requestNo", $requestNo));
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>QTY</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "qty", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Price</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "price", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro = new database();
$username = $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
foreach ($_POST['itemNo'] as $itemNo) {
$returnNo = $ro->selectNow('returnInventory', 'returnNo', 'itemNo', $itemNo);
$registrationNo = $ro->selectNow('patientCharges', 'registrationNo', 'itemNo', $itemNo);
$returnQTY = $ro->selectNow("returnInventory", "qty", "returnNo", $returnNo);
$newQTY = $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) - $returnQTY;
$invQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) + $returnQTY;
if ($ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo) != "") {
echo "<br><br><br><Br><center><font color=red>Cannot Return.<br>The Patient is discharged<Br>This is to prevent possible changes in the S.O.A</font>";
} else {
if ($ro->selectNow("returnInventory", "qty", "returnNo", $returnNo) == $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo)) {
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username);
$ro->editNow("patientCharges", "itemNo", $itemNo, "returnFlag", "return");
$ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $invQTY);
$ro->editNow("returnInventory", "returnNo", $returnNo, "returnDetails_PHARMACY", date("Y-m-d") . "@" . $ro->getSynapseTime());
$ro->editNow("returnInventory", "returnNo", $returnNo, "returnPHARMACY", $username);
} else {
$ro->editNow("returnInventory", "returnNo", $returnNo, "returnDetails_PHARMACY", date("Y-m-d") . "@" . $ro->getSynapseTime());
$ro->editNow("returnInventory", "returnNo", $returnNo, "returnPHARMACY", $username);
$ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $newQTY);
$ro->editNow("patientCharges", "itemNo", $itemNo, "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $newQTY);
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $newQTY);
$ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $invQTY);
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "UNPAID");
$ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", "dispensedBy_" . $username);
$regNo = $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo);
$stockCardNo = $ro->selectNow("patientCharges", "stockCardNo", "itemNo", $itemNo);
$chargeCodez = $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo);
$desc = $ro->selectNow("patientCharges", "description", "itemNo", $itemNo);
$sp = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo);
<?php
include "../../myDatabase.php";
$radioSavedNo = $_GET['radioSavedNo'];
$username = $_GET['username'];
$module = $_GET['module'];
$doctorCode = $_GET['doctorCode'];
$ro = new database();
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approved", "yes");
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedDate", date("Y-m-d"));
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedTime", $ro->getSynapseTime());
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedBy", $username);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/radiology/forApproval.php?username={$username}&module={$module}&doctorCode={$doctorCode}");
$beginningBalance = $_POST['beginningBalance'];
$unitOfMeasure = $_POST['unitOfMeasure'];
$biQTY = $_POST['biQTY'];
$biInventoryCode = $_POST['biInventoryCode'];
$invoiceNo = $_POST['invoiceNo'];
$lock = $_POST['lock'];
$ro = new database();
if ($beginningBalance != "") {
$begCapital = $beginningBalance;
} else {
$begCapital = $unitcost * $quantity;
}
$expiration = $yearExpired . "-" . $monthExpired . "-" . $dayExpired;
$dateAdded = $yearAdded . "-" . $monthAdded . "-" . $dayAdded;
if ($status == "new") {
//new inventory w/ stock card
$ro->addInventoryStockCard($stockCardNo, $description, $generic, date("Y-m-d"), $addedBy, $inventoryType);
$incrementStockCardNo = $ro->selectNow("trackingNo", "value", "name", "stockCardNo") + 1;
$ro->editNow("trackingNo", "name", "stockCardNo", "value", $incrementStockCardNo);
if ($inventoryType == "supplies") {
$ro->addNewMedicine($stockCardNo, $description, $generic, $pricing, $quantity, $expiration, $addedBy, $dateAdded, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, "", $criticalLevel, $supplier, $begCapital, $quantity, $unitcost, $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $unitOfMeasure, $biQTY, $biInventoryCode, $quantity, $invoiceNo, $lock);
} else {
$ro->addNewMedicine($stockCardNo, $description, $generic, $unitcost, $quantity, $expiration, $addedBy, $dateAdded, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, $pricing . "_" . $additional, $criticalLevel, $supplier, $begCapital, $quantity, "", $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $unitOfMeasure, $biQTY, $biInventoryCode, $quantity, $invoiceNo, $lock);
}
} else {
if ($inventoryType == "supplies") {
$ro->addNewMedicine($stockCardNo, $description, $generic, $pricing, $quantity, $expiration, $addedBy, $dateAdded, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, "", $criticalLevel, $supplier, $begCapital, $quantity, $unitcost, $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $unitOfMeasure, $biQTY, $biInventoryCode, $quantity, $invoiceNo, $lock);
} else {
$ro->addNewMedicine($stockCardNo, $description, $generic, $unitcost, $quantity, $expiration, $addedBy, $dateAdded, $ro->getSynapseTime(), $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, $pricing . "_" . $additional, $criticalLevel, $supplier, $begCapital, $quantity, "", $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $unitOfMeasure, $biQTY, $biInventoryCode, $quantity, $invoiceNo, $lock);
}
}
echo "<Br><br><select name='casetype' class='company'>";
//echo "<option value='Standard_PHIC_Medicine'>Standard_PHIC_Medicine</option>";
$ro->showOption("phicLimit", "casetype");
echo "</select>";
echo "<Br><Br>";
echo "<select name='admittingDoctor' class='company' >";
echo "<option value='admitting'> Admitting Doctor</option>";
$ro->showOption("Doctors", "Name");
echo "</select>";
echo "<Br><Br>";
echo "<select name='attendingDoctor' class='company' >";
echo "<option value='attending'> Attending Doctor</option>";
$ro->showOption("Doctors", "Name");
echo "</select>";
echo "<Br><br><select name='room' class='company'>";
echo "<option value='OPD'>OPD</option>";
echo "<option value='OPD'>OPD</option>";
//echo "<option value='ER'>ER</option>";
echo "<option value='OR/DR'>OR/DR</option>";
$ro->showOptionRoom("room", "Description", "status");
echo "</select>";
echo "<p id='curTime'></p>";
echo "<input type=hidden name='registrationNo' value='{$registrationNo}'>";
echo "<input type=hidden name='patientNo' value='{$patientNo}'>";
echo "<input type=hidden name='registrationStatus' value='old'>";
echo "<input type=hidden name='serverTime' value='" . $ro->getSynapseTime() . "'>";
echo "<input type=hidden name='dateRegistered' value='" . date("Y-m-d") . "'>";
echo "<br><br><input type=submit value='Register' style='border:1px solid #000000; background:#3b5998 no-repeat 4px 4px; color:white;'><br>";
echo "</form>";
echo "</div>\n\n</center>";
echo "</body>";
<?php
include "../../myDatabase.php";
$registrationNo = $_POST['registrationNo'];
$noteType = $_POST['noteType'];
$noteBy = $_POST['noteBy'];
$noteMessage = $_POST['noteMessage'];
$ro = new database();
$ro->addNewNote($registrationNo, $noteType, $noteBy, $noteMessage, date("M_d_Y"), $ro->getSynapseTime());
