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());
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
ini_set('max_execution_time', 0);
$data = DB::select('select * from location');
$insert = [];
foreach ($data as $d) {
$insert[] = ['id' => $d->id, 'name' => $d->location_name, 'code' => $d->location_code];
}
Location::insert($insert);
}
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());
}
public function run()
{
// Initialize empty array
$location = array();
$date = new DateTime();
$location[] = array('name' => 'NY - Broad St', 'address' => '200 Broad Street', 'address2' => 'Suite 142', 'city' => 'New York', 'state' => 'NY', 'country' => 'US', 'zip' => '10004', 'currency' => '$', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'deleted_at' => NULL);
$location[] = array('name' => 'NY - Water St', 'address' => '200 Broad Street', 'address2' => 'Suite 142', 'city' => 'New York', 'state' => 'NY', 'country' => 'US', 'zip' => '10004', 'currency' => '$', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'deleted_at' => NULL);
$location[] = array('name' => 'SF - Broadway', 'address' => '200 Broadway', 'address2' => 'Suite 142', 'city' => 'San Francisco', 'state' => 'CA', 'country' => 'US', 'zip' => '94111', 'currency' => '$', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'deleted_at' => NULL);
$location[] = array('name' => 'LA - Hollywood Blvd', 'address' => '6253 Hollywood Blvd', 'address2' => 'Suite 142', 'city' => 'Los Angeles', 'state' => 'CA', 'country' => 'US', 'zip' => '90028', 'currency' => '$', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'deleted_at' => NULL);
// Delete all the old data
DB::table('locations')->truncate();
// Insert the new posts
Location::insert($location);
}
/**
* 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 location
**/
public function testPutValidLocation()
{
// create a new Location
$newLocation = new Location(null, $this->VALID_storageCode, $this->VALID_description);
$newLocation->insert($this->getPDO());
// run a get request to establish session tokens
$this->guzzle->get('https://bootcamp-coders.cnm.edu/~invtext/backend/php/api/location/');
// 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/location/' . $newLocation->getLocationId(), ['headers' => ['X-XSRF-TOKEN' => $this->getXsrfToken()], 'json' => $newLocation]);
$this->assertSame($response->getStatusCode(), 200);
$body = $response->getBody();
$location = json_decode($body);
$this->assertSame(200, $location->status);
}
/**
* Allows a user to add a location.
*
*/
public function addAction()
{
$messages = array();
$location = new Location();
$form = $location->form();
if ($this->_request->isPost()) {
if ($form->isValid($_POST)) {
$data = array('name' => $form->getValue('name'), 'locationType' => $form->getValue('locationType'), 'capacity' => $form->getValue('capacity'), 'description' => $form->getValue('description'), 'address' => $form->getValue('address'), 'status' => $form->getValue('status'));
$locationId = $location->insert($data);
$trigger = new Ot_Trigger();
$data['accountId'] = Zend_Auth::getInstance()->getIdentity()->accountId;
$trigger->setVariables($data);
$trigger->dispatch('Location_Add');
$this->_helper->flashMessenger->addMessage('msg-info-locationAdded');
$this->_helper->redirector->gotoUrl('/workshop/location/details/?locationId=' . $locationId);
} else {
$messages[] = "msg-error-formSubmitProblem";
}
}
$this->view->messages = $messages;
$this->view->form = $form;
$this->view->headScript()->appendFile($this->view->baseUrl() . '/scripts/jquery.wysiwyg.js');
$this->view->headLink()->appendStylesheet($this->view->baseUrl() . '/css/jquery.wysiwyg.css');
$this->_helper->pageTitle('workshop-location-add:title');
}
/**
* test grabbing location by productId
**/
public function testGetValidProductByLocationId()
{
// count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("location");
// create a new location and insert to into mySQL
$location = new Location(null, $this->VALID_storageCode, $this->VALID_description);
$location->insert($this->getPDO());
$quantity = 5.9;
// create a new location and insert to into mySQL
$productLocation = new productLocation($location->getLocationId(), $this->product->getProductId(), $this->unitOfMeasure->getUnitId(), $quantity);
$productLocation->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$pdoProductArray = Location::getProductByLocationId($this->getPDO(), $location->getLocationId());
for ($i = 0; $i < count($pdoProductArray); $i++) {
if ($i === 0) {
$this->assertSame($pdoProductArray[$i]->getStorageCode(), $this->VALID_storageCode);
$this->assertSame($pdoProductArray[$i]->getDescription(), $this->VALID_description);
} else {
$this->assertSame($pdoProductArray[$i]->getProductId(), $this->product->getProductId());
$this->assertSame($pdoProductArray[$i]->getVendorId(), $this->product->getVendorId());
$this->assertSame($pdoProductArray[$i]->getDescription(), $this->product->getDescription());
$this->assertSame($pdoProductArray[$i]->getSku(), $this->product->getSku());
$this->assertSame($pdoProductArray[$i]->getTitle(), $this->product->getTitle());
}
}
}
/**
* Insert city if not found and return id
* otherwise just return actual city id
*/
public static function insertIfNotFound($region_name, $parent_id, $tier)
{
if (!$region_name) {
return false;
}
$city_id = self::verifyHierarchy($region_name, $parent_id, $tier);
if (!$city_id) {
$cityTable = new Location();
$data = array();
$data['location_name'] = $region_name;
$data['parent_id'] = $parent_id;
$data['tier'] = $tier;
$city_id = $cityTable->insert($data);
}
return $city_id;
}
} else {
if (empty($storageCode) === false) {
$reply->data = Location::getLocationByStorageCode($pdo, $storageCode);
} else {
$reply->data = Location::getALLLocations($pdo)->toArray();
}
}
// post to a new Location
} else {
if ($method === "POST") {
// convert POSTed JSON to an object
verifyXsrf();
$requestContent = file_get_contents("php://input");
$requestObject = json_decode($requestContent);
$location = new Location($locationId, $requestObject->storageCode, $requestObject->description);
$location->insert($pdo);
$reply->data = "Location created OK";
// delete an existing Location
} else {
if ($method === "DELETE") {
verifyXsrf();
$location = Location::getLocationByLocationId($pdo, $locationId);
$location->delete($pdo);
$reply->data = "Location deleted OK";
// put to an existing Location
} else {
if ($method === "PUT") {
// convert PUTed JSON to an object
verifyXsrf();
$requestContent = file_get_contents("php://input");
$requestObject = json_decode($requestContent);
$box->printForm($_GET['action']);
} else {
$box->printForm($_GET['action']);
}
}
}
}
}
}
}
if ($_GET['type'] == 'location') {
$location = new Location($connection);
if (isset($_POST['submit'])) {
if ($_GET['action'] == 'add') {
$location->loadFromPage();
$location->insert();
} else {
if ($_GET['action'] == 'edit') {
$location->loadFromPage();
$location->update();
}
}
} else {
if ($_GET['action'] == 'edit') {
$location->loadEntry($_GET['index']);
}
$location->printForm($_GET['action']);
}
}
}
} catch (Exception $e) {
