/**
* Set up to create vendor, product, unitOfMeasure objects
*
**/
public function setUp()
{
parent::setUp();
$this->guzzle = new \GuzzleHttp\Client(['cookies' => true]);
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$unitId = null;
$quantity = 3.5;
$unitCode = "ea";
$this->unitOfMeasure = new UnitOfMeasure($unitId, $unitCode, $quantity);
$this->unitOfMeasure->insert($this->getPDO());
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$name = "TruFork";
$contactName = "Trevor Rigler";
$email = "*****@*****.**";
$phoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $name, $contactName, $email, $phoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bracelet for any occasion to use";
$leadTime = 15;
$sku = "457847";
$title = "Bracelet-Green-Blue";
$this->finishedProduct = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->finishedProduct->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "354";
$title = "Bead-Green-Blue-Circular";
$this->rawMaterial = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->rawMaterial->insert($this->getPDO());
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$locationId = null;
$description = "Back Stock";
$storageCode = 7;
$this->location = new Location($locationId, $storageCode, $description);
$this->location->insert($this->getPDO());
$unitId = null;
$unitCode = "pk";
$quantity = 10.5;
$this->unitOfMeasure = new UnitOfMeasure($unitId, $unitCode, $quantity);
$this->unitOfMeasure->insert($this->getPDO());
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$alertId = null;
$alertCode = "WM";
$alertFrequency = "D2";
$alertOperator = "L";
$alertPoint = 100.514;
$this->alertLevel = new AlertLevel($alertId, $alertCode, $alertFrequency, $alertPoint, $alertOperator);
$this->alertLevel->insert($this->getPDO());
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
}
} else {
if (empty($vendorName) === false) {
$reply->data = Vendor::getVendorByVendorName($pdo, $vendorName)->toArray();
} else {
$reply->data = Vendor::getAllVendors($pdo)->toArray();
}
}
// 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);
public function map_products_vendor($vendor_name)
{
$security_where = $_SESSION["do_crm_action_permission"]->get_user_where_condition('vendor', 11);
$qry = "select * from `vendor` where `vendor_name` = ? " . $security_where;
$stmt = $this->getDbConnection()->executeQuery($qry, array($vendor_name));
if ($stmt->rowCount() > 0) {
$data = $stmt->fetch();
$idvendor = $data["idvendor"];
return $idvendor;
} else {
if (strlen($vendor_name) > 0) {
$do_vendor = new Vendor();
$data = array("vendor_name" => CommonUtils::purify_input($vendor_name), "iduser" => $_SESSION["do_user"]->iduser, "added_on" => date("Y-m-d H:i:s"));
$do_vendor->insert("vendor", $data);
$idvendor = $do_vendor->getInsertId();
$do_vendor->insert("vendor_address", array("idvendor" => $idvendor));
$do_vendor->insert("vendor_custom_fld", array("idvendor" => $idvendor));
$do_vendor->free();
$do_data_history = new DataHistory();
$do_data_history->add_history($idvendor, 11, 'add');
$do_data_history->free();
return $idvendor;
}
}
}
/**
* Set up for Vendor as well as guzzle/cookies
**/
public final function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$this->vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$this->vendor->insert($this->getPDO());
$locationId = null;
$description = "Front Stock";
$storageCode = 12;
$this->location = new Location($locationId, $storageCode, $description);
$this->location->insert($this->getPDO());
$unitId = null;
$unitCode = "pk";
$quantity = 10.5;
$this->unitOfMeasure = new UnitOfMeasure($unitId, $unitCode, $quantity);
$this->unitOfMeasure->insert($this->getPDO());
$alertCode = "78";
$alertFrequency = "56";
$alertPoint = 1.4;
$alertOperator = "A";
$this->alertLevel = new AlertLevel(null, $alertCode, $alertFrequency, $alertPoint, $alertOperator);
$this->alertLevel->insert($this->getPDO());
$notificationId = null;
$alertId = $this->alertLevel->getAlertId();
$emailStatus = false;
$notificationDateTime = null;
$notificationHandle = "unit test";
$notificationContent = "place holder";
$notificationDateTime = DateTime::createFromFormat("Y-m-d H:i:s", "1985-06-28 04:26:03");
$this->notification = new Notification($notificationId, $alertId, $emailStatus, $notificationDateTime, $notificationHandle, $notificationContent);
$this->notification->insert($this->getPDO());
// create and insert a GuzzleHttp
$this->guzzle = new \GuzzleHttp\Client(['cookies' => true]);
}
/**
* test ability to Put valid vendor
**/
public function testPutValidVendor()
{
// create a new vendor
$newVendor = new Vendor(null, $this->VALID_contactName, $this->VALID_vendorEmail, $this->VALID_vendorName, $this->VALID_vendorPhoneNumber);
$newVendor->insert($this->getPDO());
// run a get request to establish session tokens
$this->guzzle->get('https://bootcamp-coders.cnm.edu/~invtext/backend/php/api/vendor/');
// grab the data from guzzle and enforce the status' match our expectations
$response = $this->guzzle->put('https://bootcamp-coders.cnm.edu/~invtext/backend/php/api/vendor/' . $newVendor->getVendorId(), ['headers' => ['X-XSRF-TOKEN' => $this->getXsrfToken()], 'json' => $newVendor]);
$this->assertSame($response->getStatusCode(), 200);
$body = $response->getBody();
$vendor = json_decode($body);
echo $body . PHP_EOL;
$this->assertSame(200, $vendor->status);
}
public function setUp()
{
parent::setUp();
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$alertId = null;
$alertCode = "33";
$alertFrequency = "11";
$alertLevel = "100.01";
$alertOperator = "1";
$this->alertLevel = new AlertLevel($alertId, $alertCode, $alertFrequency, $alertLevel, $alertOperator);
$this->alertLevel->insert($this->getPDO());
$productEnabled = true;
$this->productAlert = new ProductAlert($this->alertLevel->getAlertId(), $this->product->getProductId(), $productEnabled);
$this->productAlert->insert($this->getPDO());
$this->VALID_notificationDateTime = DateTime::createFromFormat("Y-m-d H:i:s", "1985-06-28 04:26:03");
}
/**
* test grabbinbg all Vendors
**/
public function testGetAllValidVendors()
{
//count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("vendor");
//create a new vendor and insert it into mySQL
$vendor = new Vendor(null, $this->VALID_contactName, $this->VALID_vendorEmail, $this->VALID_vendorName, $this->VALID_vendorPhoneNumber);
$vendor->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$pdoVendor = Vendor::getAllVendors($this->getPDO());
foreach ($pdoVendor as $ven) {
$this->assertSame($numRows + 1, $this->getConnection()->getRowCount("vendor"));
$this->assertSame($ven->getContactName(), $this->VALID_contactName);
$this->assertSame($ven->getVendorEmail(), $this->VALID_vendorEmail);
$this->assertSame($ven->getVendorName(), $this->VALID_vendorName);
$this->assertSame($ven->getVendorPhoneNumber(), $this->VALID_vendorPhoneNumber);
}
}
public function setUp()
{
parent::setUp();
$this->guzzle = new \GuzzleHttp\Client(['cookies' => true]);
$this->VALID_movementDate = DateTime::createFromFormat("Y-m-d H:i:s", "2015-09-26 08:45:25");
$this->INVALID_movementDate = DateTime::createFromFormat("Y-m-d H:i:s", "2015-14-26 06:25:25");
$userId = null;
$firstName = "Jim";
$lastName = "Jim";
$root = 1;
$attention = "Urgent: ";
$addressLineOne = "123 House St.";
$addressLineTwo = "P.O Box. 9965";
$city = "Tattoine";
$state = "AK";
$zipCode = "52467";
$email = "*****@*****.**";
$phoneNumber = "5052253231";
$salt = bin2hex(openssl_random_pseudo_bytes(32));
$hash = hash_pbkdf2("sha512", "password1234", $salt, 262144, 128);
$this->user = new User($userId, $lastName, $firstName, $root, $attention, $addressLineOne, $addressLineTwo, $city, $state, $zipCode, $email, $phoneNumber, $salt, $hash);
$this->user->insert($this->getPDO());
$vendorId = null;
$contactName = "Trevor Rigler";
$vendorEmail = "*****@*****.**";
$vendorName = "TruFork";
$vendorPhoneNumber = "5053594687";
$vendor = new Vendor($vendorId, $contactName, $vendorEmail, $vendorName, $vendorPhoneNumber);
$vendor->insert($this->getPDO());
$productId = null;
$vendorId = $vendor->getVendorId();
$description = "A glorius bead to use";
$leadTime = 10;
$sku = "TGT354";
$title = "Bead-Green-Blue-Circular";
$this->product = new Product($productId, $vendorId, $description, $leadTime, $sku, $title);
$this->product->insert($this->getPDO());
$locationId = null;
$description = "Back Stock";
$storageCode = 13;
$this->fromLocation = new Location($locationId, $storageCode, $description);
$this->fromLocation->insert($this->getPDO());
$locationId = null;
$description = "Front Stock";
$storageCode = 12;
$this->toLocation = new Location($locationId, $storageCode, $description);
$this->toLocation->insert($this->getPDO());
$unitId = null;
$unitCode = "pk";
$quantity = 10.5;
$this->unitOfMeasure = new UnitOfMeasure($unitId, $unitCode, $quantity);
$this->unitOfMeasure->insert($this->getPDO());
}
