Esempio n. 1
0
 /**
  * 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);
 }
Esempio n. 2
0
     }
     // 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;
    /**