/** * test grabbing a Vendor that does not exist **/ public function testGetInvalidVendorByVendorId() { // grab a vendor id that exceeds the maximum allowable vendor id $vendor = Vendor::getVendorByVendorId($this->getPDO(), InventoryTextTest::INVALID_KEY); $this->assertNull($vendor); }
} // post to a new Vendor } else { if ($method === "POST") { // convert POSTed JSON to an object verifyXsrf(); $requestContent = file_get_contents("php://input"); $requestObject = json_decode($requestContent); $vendor = new Vendor(null, $requestObject->contactName, $requestObject->vendorEmail, $requestObject->vendorName, $requestObject->vendorPhoneNumber); $vendor->insert($pdo); $reply->data = "Vendor created OK"; // delete an existing Vendor } else { if ($method === "DELETE") { verifyXsrf(); $vendor = Vendor::getVendorByVendorId($pdo, $vendorId); $vendor->delete($pdo); $reply->data = "Vendor deleted OK"; // put to an existing Vendor } else { if ($method === "PUT") { // convert PUTed JSON to an object verifyXsrf(); $requestContent = file_get_contents("php://input"); $requestObject = json_decode($requestContent); $vendor = new Vendor($vendorId, $requestObject->contactName, $requestObject->vendorEmail, $requestObject->vendorName, $requestObject->vendorPhoneNumber); $vendor->update($pdo); $reply->data = "Vendor Updated Ok"; } } }
$allProducts = Product::getAllProducts($pdo, 0); foreach ($allProducts as $product) { $numberOfProducts = 0; // Make an array of product location from the above product $productLocations = ProductLocation::getProductLocationByProductId($pdo, $product->getProductId()); foreach ($productLocations as $productLocation) { $numberOfProducts = $numberOfProducts + $productLocation->getQuantity(); } // check if levels trigger notification according to alert operator $productAlerts = ProductAlert::getProductAlertByProductId($pdo, $product->getProductId()); foreach ($productAlerts as $productAlert) { $alertLevel = AlertLevel::getAlertLevelByAlertId($pdo, $productAlert->getAlertId()); if ($alertLevel->getAlertOperator() === "<" && $numberOfProducts < $alertLevel->getAlertPoint() || $alertLevel->getAlertOperator() === ">" && $numberOfProducts > $alertLevel->getAlertPoint()) { // give warning $productTitle = $product->getTitle(); $vendor = Vendor::getVendorByVendorId($pdo, $product->getVendorId()); $vendorName = $vendor->getVendorName(); $message = $message . <<<EOF \t\t\t\t<tr> \t\t\t\t\t<td>{$productTitle}</td> \t\t\t\t\t<td>{$numberOfProducts}</td> \t\t\t\t\t<td>{$vendorName}</td> \t\t\t\t</tr> EOF; } } } $message = $message . <<<EOF \t\t\t</tbody> EOF; /**