PHP database4::deleted_inventory Exemples

Exemple #1

Fichier : deleted-medicine-search.php Projet : rickyx12/protacio

<?php

include "../../myDatabase4.php";
include "../../myDatabase.php";
$search = $_GET['search'];
$ro4 = new database4();
$ro = new database();
$ro4->deleted_inventory($search, "medicine");
$myInventoryCode = [];
foreach ($ro4->deleted_inventory_inventoryCode() as $inventoryCode) {
    array_push($myInventoryCode, ["inventoryCode" => $inventoryCode, "stockCardNo" => $ro->selectNow("inventory", "stockCardNo", "inventoryCode", $inventoryCode), "description" => $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode), "genericName" => $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode), "unitcost" => $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode), "ipdPrice" => $ro->selectNow("inventory", "ipdPrice", "inventoryCode", $inventoryCode), "opdPrice" => $ro->selectNow("inventory", "opdPrice", "inventoryCode", $inventoryCode), "status" => $ro->selectNow("inventory", "status", "inventoryCode", $inventoryCode)]);
}
$json = json_encode($myInventoryCode);
echo $json;

Exemple #2

Fichier : deleted-supplies-search.php Projet : rickyx12/protacio

<?php

include "../../myDatabase4.php";
include "../../myDatabase.php";
$search = $_GET['search'];
$ro4 = new database4();
$ro = new database();
$ro4->deleted_inventory($search, "supplies");
$myInventoryCode = [];
foreach ($ro4->deleted_inventory_inventoryCode() as $inventoryCode) {
    array_push($myInventoryCode, ["inventoryCode" => $inventoryCode, "stockCardNo" => $ro->selectNow("inventory", "stockCardNo", "inventoryCode", $inventoryCode), "description" => $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode), "unitcost" => $ro->selectNow("inventory", "suppliesUNITCOST", "inventoryCode", $inventoryCode), "price" => $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode), "status" => $ro->selectNow("inventory", "status", "inventoryCode", $inventoryCode)]);
}
$json = json_encode($myInventoryCode);
echo $json;