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;
$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());
}
/**
* 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;
$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();
$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 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());
}
include "models/function.php";
if (isset($_POST["go"])) {
$objImg = new UploadImg();
$name_img = $objImg->upload($_FILES, $_POST["photo_now"]);
$objAttr = new AttrValue();
$data_attr = $objAttr->conbine($_POST["attr"], $_POST["val"]);
if (isset($_POST["related"]) and $_POST["related"]) {
$related = array_slice($_POST["related"], 0, 4);
$data_related = serialize($related);
} else {
$data_related = "";
}
require_once "classes/Product.php";
$obj = new Product();
if ($_POST["go"] == "save") {
$fff = $obj->insert($obj->insertSql(), trimStr($_POST["section"]), trimStr($_POST["name"]), trimStr($_POST["nomer"]), trimStr($_POST["brand"]), trimStr($_POST["viscous"]), trimStr($_POST["type"]), trimStr($_POST["volume"]), trimStr($_POST["kol"]), trimStr($_POST["price"]), trimStr($_POST["text"]), $data_related, $data_attr, trimStr($_POST["title"]), trimStr($_POST["description"]), trimStr($_POST["keywords"]), $name_img, trimStr($_POST["img_title"]), trimStr($_POST["img_alt"]));
header("Location: production.php?id=" . $_POST["section"]);
} else {
$obj->update($obj->updateSql(), trimStr($_POST["section"]), trimStr($_POST["name"]), trimStr($_POST["nomer"]), trimStr($_POST["brand"]), trimStr($_POST["viscous"]), trimStr($_POST["type"]), trimStr($_POST["volume"]), trimStr($_POST["kol"]), trimStr($_POST["price"]), trimStr($_POST["text"]), $data_related, $data_attr, trimStr($_POST["title"]), trimStr($_POST["description"]), trimStr($_POST["keywords"]), $name_img, trimStr($_POST["img_title"]), trimStr($_POST["img_alt"]), $_POST['go']);
header("Location: production.php?id=" . $_POST["section"]);
}
}
if (isset($_GET["delete"])) {
$delete = new Delete();
$delete->del($_GET["title"], $_GET["delete"]);
header("Location: production.php?id=" . $_GET["delete"]);
}
require_once "classes/Catalog.php";
$section = new Catalog();
require_once "classes/Product.php";
$objEdit = new Product();
/**
* test deleting a valid Product
**/
public function testDeleteValidProduct()
{
// create a new Product
$newProduct = new Product(null, $this->vendor->getVendorId(), $this->VALID_description, $this->VALID_leadTime, $this->VALID_sku, $this->VALID_title);
$newProduct->insert($this->getPDO());
// grab the data from guzzle and enforce the status' match our expectations
$this->guzzle->get('https://bootcamp-coders.cnm.edu/~invtext/backend/php/api/product/' . $newProduct->getProductId());
$response = $this->guzzle->get('https://bootcamp-coders.cnm.edu/~invtext/backend/php/api/product/' . $newProduct->getProductId(), ['headers' => ['X-XSRF-TOKEN' => $this->getXsrfToken()]]);
$this->assertSame($response->getStatusCode(), 200);
$body = $response->getBody();
$product = json_decode($body);
$this->assertSame(200, $product->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");
}
if ($sub_cato == $yy) {
$Nsub_cato = $srow['id_sub'];
// var_dump("$Ncato");
break;
}
}
$prod = new Product();
// $allimg=$sub_cato."/".$IMG;
$prod->id_cato = $Ncato;
$prod->id_sub = $Nsub_cato;
$prod->type_prod = $sub_cato;
$prod->descrp = $descp;
$prod->image = $IMG;
$prod->quantity = $quant;
$prod->unit_price = $pric;
$prod->id_product = 'NULL';
$prod->insert();
print_r($prod);
echo $Ncato;
echo $Nsub_cato;
if ($Ncato == 0 || $Nsub_cato == 0) {
header("location:insert_products.php");
}
// echo "<a href='profile.php'>aaa<a/>";
echo "<meta http-equiv='Refresh' content='0;url=profile.php' />";
} else {
header("location:insert_products.php");
}
?>
function inserProduct($name, $description, $price, $img)
{
$p = new Product();
return $p->insert($name, $description, $price, $img);
}
if (isset($_POST['color'])) {
$color_arr = $_POST['color'];
$product->color = implode(",", $color_arr);
/*$arr = preg_split("/[,]+/", color);*/
} else {
$product->color = 'not-avilable';
}
if (isset($_POST['quantity'])) {
$product->quantity = $_POST['quantity'];
} else {
$product->quantity = '0';
}
$d = mktime(11, 14, 54, 8, 12, 2014);
$product->add_date = date("Y-m-d h:i:sa", $d);
$product->status = '1';
echo $product->insert();
$product_id = $product->insert();
echo $product_id;
if ($product_id) {
$_SESSION['Psuccess'] = "Product add has success";
header('location:../controle.php#tabs-4');
}
} else {
$_SESSION['Pname'] = "Please enter valid name ";
header('location:../controle.php#tabs-4');
}
}
echo "error";
}
echo "error";
}
/**
* test grabbing product by notification
**/
public function testGetValidNotificationByProductId()
{
// create a new product and insert to into mySQL
$product = new Product(null, $this->vendor->getVendorId(), $this->VALID_description, $this->VALID_leadTime, $this->VALID_sku, $this->VALID_title);
$product->insert($this->getPDO());
// create a new product and insert to into mySQL
$productAlert = new ProductAlert($this->alertLevel->getAlertId(), $product->getProductId(), true);
$productAlert->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$pdoNotificationArray = Product::getNotificationByProductId($this->getPDO(), $product->getProductId());
for ($i = 0; $i < count($pdoNotificationArray); $i++) {
if ($i === 0) {
$this->assertSame($pdoNotificationArray[$i]->getVendorId(), $this->vendor->getVendorId());
$this->assertSame($pdoNotificationArray[$i]->getDescription(), $this->VALID_description);
$this->assertSame($pdoNotificationArray[$i]->getLeadTime(), $this->VALID_leadTime);
$this->assertSame($pdoNotificationArray[$i]->getSku(), $this->VALID_sku);
$this->assertSame($pdoNotificationArray[$i]->getTitle(), $this->VALID_title);
} else {
$this->assertSame($pdoNotificationArray[$i]->getNotificationId(), $this->notification->getNotificationId());
$this->assertSame($pdoNotificationArray[$i]->getAlertId(), $this->notification->getAlertId());
$this->assertSame($pdoNotificationArray[$i]->getEmailStatus(), $this->notification->getEmailStatus());
$this->assertEquals($pdoNotificationArray[$i]->getNotificationDateTime(), $this->notification->getNotificationDateTime());
$this->assertSame($pdoNotificationArray[$i]->getNotificationHandle(), $this->notification->getNotificationHandle());
$this->assertSame($pdoNotificationArray[$i]->getNotificationContent(), $this->notification->getNotificationContent());
}
}
}
}
}
if (!$wasError) {
if (isset($param) && !empty($param)) {
// ha van kep, akkor regit toroljuk, uj elmentodik
if (isset($_POST['image'])) {
$theProduct = $product->find((int) $param);
@unlink(FOTO_UPLOAD_DIR . $theProduct['image']);
@unlink(THUMB_UPLOAD_DIR . $theProduct['image']);
}
//update
$product->update($_POST, (int) $param);
$theProduct = $product->find((int) $param);
} else {
//insert
$product->insert($_POST);
Redirect::to(BASE_URL . 'products/');
}
} else {
$theProduct = $_POST;
}
}
//$template = 'products_edit';
break;
case 'delete':
if (isset($param) && !empty($param)) {
$p = $product->find((int) $param);
$product->delete((int) $param);
if ($p['image']) {
@unlink(FOTO_UPLOAD_DIR . $p['image']);
@unlink(THUMB_UPLOAD_DIR . $p['image']);
require "../includes/injection.php";
require "../../includes/trackXML.php";
$cate = sqlInjection($_POST['CateID']);
$lable = sqlInjection($_POST['Lable']);
$price = sqlInjection($_POST['Price']);
$artist = sqlInjection($_POST['Artist']);
$producer = sqlInjection($_POST['Producer']);
$year = sqlInjection($_POST['pubYear']);
$disktype = sqlInjection($_POST['DiskType']);
$description = sqlInjection($_POST['Description']);
$tracklist = "";
$image = sqlInjection($_POST['proImage']);
$status = sqlInjection($_POST['ProStatus']);
$continue = $_POST['continue'];
$trck = new TrackXML();
$prod = new Product();
if (isset($_POST['trackname']) && isset($_POST['tracklength'])) {
$tracklist = $trck->createXML($_POST['trackname'], $_POST['tracklength']);
}
//echo $lable."<br>".$cate."<br>".$price
// ."<br>".$artist."<br>".$producer."<br>".$year."<br>".$disktype."<br>".$description
// ."<br>".$tracklist."<br>".$image."<br>".$status;
$prod->insert($lable, $cate, $price, $artist, $producer, $year, $disktype, $description, $tracklist, $image, $status);
if ($continue == "OK") {
echo "<meta http-equiv='refresh' content='0;url=../admincp.php?opt=addproduct'>";
//header("location: ../admincp.php?opt=addproduct");
//exit();
}
echo "<meta http-equiv='refresh' content='0;url=../admincp.php?opt=listproduct'>";
//header("location: ../admincp.php?opt=listproduct");
//exit();
<?php
require_once "/etc/apache2/capstone-mysql/encrypted-config.php";
require_once "product.php";
$pdo = connectToEncryptedMySQL("/etc/apache2/data-design/jfindley2.ini");
$product = new Product(null, "imagefile", 10, "Info", "Detail", "Tech", "Name");
$product->insert($pdo);
$product->setProductName("This is the new name");
$product->update($pdo);
$product->delete($pdo);
$dProCreate = strtotime(str_replace('/', '-', $_POST["txtProCreated"]));
//d-m-Y
$Product->setProCreated($dProCreate);
}
if (isset($_POST["cboCatPro"])) {
$oCatPro = new Category($_POST["cboCatPro"]);
$Product->setCatPro($oCatPro);
}
if (isset($_POST["txtTinyDes"])) {
$Product->setTinyDes($_POST["txtTinyDes"]);
}
if (isset($_POST["txtFullDes"])) {
$Product->setFullDes($_POST["txtFullDes"]);
}
if ($control == Controls::Insert) {
$Product->insert();
addImageURL($Product);
addListImages($Product);
$insert = true;
} else {
if ($control == Controls::Update) {
if (isset($_POST["chkStatus"])) {
$Product->setStatus($_POST["chkStatus"]);
} else {
$Product->setStatus(0);
}
$Product->update();
addImageURL($Product);
addListImages($Product);
$update = true;
}
* For the full copyright and license information,
* please see the COPYING and AUTHORS files
* that were distributed with this source code.
*/
require_once __DIR__ . '/../../init.php';
$tpl = new Template_Helper();
$tpl->setTemplate('manage/products.tpl.html');
Auth::checkAuthentication();
$role_id = Auth::getCurrentRole();
if ($role_id < User::ROLE_MANAGER) {
Misc::setMessage('Sorry, you are not allowed to access this page.', Misc::MSG_ERROR);
$tpl->displayTemplate();
exit;
}
if (@$_POST['cat'] == 'new') {
$res = Product::insert($_POST['title'], $_POST['version_howto'], $_POST['rank'], @$_POST['removed'], @$_POST['email']);
Misc::mapMessages($res, array(1 => array('Thank you, the product was added successfully.', Misc::MSG_INFO), -1 => array('An error occurred while trying to add the product.', Misc::MSG_ERROR)));
} elseif (@$_POST['cat'] == 'update') {
$res = Product::update($_POST['id'], $_POST['title'], $_POST['version_howto'], $_POST['rank'], @$_POST['removed'], @$_POST['email']);
Misc::mapMessages($res, array(1 => array('Thank you, the product was updated successfully.', Misc::MSG_INFO), -1 => array('An error occurred while trying to update the product.', Misc::MSG_ERROR)));
} elseif (@$_POST['cat'] == 'delete') {
Product::remove($_POST['items']);
}
if (@$_GET['cat'] == 'edit') {
$info = Product::getDetails($_GET['id']);
$tpl->assign('info', $info);
$user_options = User::getActiveAssocList(Auth::getCurrentProject(), User::ROLE_CUSTOMER, false, $_GET['id']);
} else {
$user_options = User::getActiveAssocList(Auth::getCurrentProject(), User::ROLE_CUSTOMER, true);
}
$tpl->assign('list', Product::getList());
} else {
if ($dataType == "detail" && $module == "product") {
try {
Tool::logger(__METHOD__, __LINE__, sprintf("action: %s", $action), _LOG_DEBUG);
$product = new Product(_NONE);
$product->productId = isset($_REQUEST["productId"]) ? $_REQUEST["productId"] : _NONE;
if ($product->productId > 0) {
$product = Product::first($product);
}
$product->productName = isset($_REQUEST["productName"]) ? $_REQUEST["productName"] : $product->productName;
$product->productNo = isset($_REQUEST["productNo"]) ? $_REQUEST["productNo"] : $product->productNo;
$product->productType = isset($_REQUEST["productType"]) ? $_REQUEST["productType"] : $product->productType;
$product->mImage = isset($_REQUEST["mImage"]) ? $_REQUEST["mImage"] : $product->mImage;
$product->aliUrl = isset($_REQUEST["aliUrl"]) ? $_REQUEST["aliUrl"] : $product->aliUrl;
if ($action == "insert") {
$newId = Product::insert($product);
if ($newId > 0) {
Content::insert(array($module . $newId => isset($_REQUEST["productDetail"]) ? $_REQUEST["productDetail"] : ""), $module);
}
} else {
if ($action == "update") {
Product::update($product);
Content::update(array($module . $product->productId => isset($_REQUEST["productDetail"]) ? $_REQUEST["productDetail"] : ""), $module);
} else {
if ($action == "delete") {
Product::delete($product);
Content::delete($module . $product->productId, $module);
$docFile = new DocFile(_NONE);
$docFile->fileUrl = $product->mImage;
DocFile::delete($docFile);
}
