$ro4 = new database4();
$user = $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
foreach ($endingNo as $end) {
    $totalEnding += $ro->selectNow("endingInventory", "endingQTY", "endingNo", $end);
    $endingNo1 = $end;
    $ro->editNow("endingInventory", "endingNo", $end, "status", "encoded_" . $user);
}
if ($ro->selectNow("inventoryStockCard", "inventoryType", "stockCardNo", $ro->selectNow("endingInventory", "stockCardNo", "endingNo", $endingNo1)) == "medicine") {
    $stockCardNo = $ro->selectNow("endingInventory", "stockCardNo", "endingNo", $endingNo1);
    $genericName = $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo);
    $brandName = $ro->selectNow("inventoryStockCard", "description", "stockCardNo", $stockCardNo);
    $preparation = $ro->selectNow("inventory", "preparation", "stockCardNo", $stockCardNo);
    $qty = $totalEnding;
    $unitcost = $ro->selectNow("endingInventory", "unitcost", "endingNo", $endingNo1);
    //selectLast($table,$cols,$identifier,$identifierData,$ordering)
    $opdPrice = $ro4->selectLast("inventory", "opdPrice", "stockCardNo", $stockCardNo, "inventoryCode");
    $ipdPrice = $ro4->selectLast("inventory", "ipdPrice", "stockCardNo", $stockCardNo, "inventoryCode");
    $expiration = $ro4->selectLast('inventory', 'expiration', 'stockCardNo', $stockCardNo, 'inventoryCode');
    $remarks = "Ending inventory - " . date('Y-m-d');
    $locked = "no";
    $criticalLevel = "5";
    $inventoryType = $ro->selectNow("inventoryStockCard", "inventoryType", "stockCardNo", $stockCardNo);
    $inventoryLocation = $ro->selectNow("endingInventory", "inventoryLocation", "endingNo", $endingNo1);
    $supplier = $ro4->selectLast("inventory", "supplier", "stockCardNo", $stockCardNo, "inventoryCode");
    $dateAdded = date('Y-m-d');
    $timeAdded = date('H:i:s');
    $addedBy = $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']);
    $beginningQTY = $totalEnding;
    $medicine = array("stockCardNo" => $stockCardNo, "genericName" => $genericName, "description" => $brandName, "preparation" => $preparation, "quantity" => $qty, "unitcost" => $unitcost, "opdPrice" => $opdPrice, "ipdPrice" => $ipdPrice, "expiration" => $expiration, "remarks" => $remarks, "locked" => $locked, "criticalLevel" => $criticalLevel, "inventoryType" => $inventoryType, "inventoryLocation" => $inventoryLocation, "supplier" => $supplier, "dateAdded" => $dateAdded, "timeAdded" => $timeAdded, "addedBy" => $addedBy, "beginningQTY" => $qty);
    $ro4->insertNow("inventory", $medicine);
} else {
예제 #2
0
echo "<br>";
echo "lock: ".$lock;
*/
$counterDate = $ro->selectNow("counters", "counterdate", "id", "1");
$counter02 = $ro->selectNow("counters", "counter02", "id", "1");
$purchaseDate = date("Ymd");
if ($counterDate != $purchaseDate) {
    $ro->editNow("counters", "id", "1", "counter02", "0");
} else {
    $newCounter02 = $counter02 + 1;
    $ro->editNow("counters", "id", "1", "counter02", $newCounter02);
}
if ($counter02 < 10) {
    $refNo = $purchaseDate . "000" . $counter02;
} else {
    if ($counter02 > 9 && $counter02 < 100) {
        $refNo = $purchaseDate . "00" . $counter02;
    } else {
        if ($counter02 > 99 && $counter02 < 1000) {
            $refNo = $purchaseDate . "0" . $counter02;
        } else {
            $refNo = $purchaseDate . $counter02;
        }
    }
}
$inventory = array("stockCardNo" => $stockCardNo, "description" => $brandName, "genericName" => $genericName, "preparation" => $preparation, "quantity" => $quantity + $freeGoods, "fgQuantity" => $freeGoods, "unitcost" => $unitcost, "opdPrice" => $opdPrice, "ipdPrice" => $ipdPrice, "expiration" => $expiration, "addedBy" => $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']), "timeAdded" => date("H:i:s"), "dateAdded" => $dateAdded, "inventoryType" => "medicine", "inventoryLocation" => $inventoryLocation, "criticalLevel" => $criticalLevel, "supplier" => $supplier, "invoiceNo" => $invoiceNo, "remarks" => $remarks, "locked" => $lock, "autoDispense" => "no", "classification" => "inventory", "beginningQTY" => $quantity + $freeGoods);
$ro4->insertNow("inventory", $inventory);
//inventorycode nung last inserted
$inventoryCode = $ro4->selectLast("inventory", "inventoryCode", "stockCardNo", $stockCardNo, "inventoryCode");
$salesInvoiceItem = array("refNo" => $refNo, "siNo" => $siNo, "inventoryCode" => $inventoryCode, "description" => $brandName, "unit" => $preparation, "unitPrice" => $unitcost, "quantity" => $quantity + $freeGoods, "fgquantity" => $freeGoods, "type" => "medicine", "status" => "Active", "encodedBy" => $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']), "dateEncoded" => date("YmdHi"));
$ro4->insertNow("salesInvoiceItems", $salesInvoiceItem);