public function getProduct($product_id) { $db = Database::getDB(); $query = "SELECT * FROM products\n WHERE productID = '{$product_id}'"; $result = $db->query($query); $row = $result->fetch(); $category = CategoryDB::getCategory($row['categoryID']); $product = new Product(); $product->setCategory($category); $product->setId($row['productID']); $product->setCode($row['productCode']); $product->setName($row['productName']); $product->setPrice($row['listPrice']); return $product; }
function createProduct() { //Product 1 $product1 = new Product(); $product1->setCode(1); $product1->setDescription("Produto de teste 1"); $product1->setAmount(2); $product1->setValue(5.5); $product1->setExtraDescription("Este produto é um exemplo"); //Product 2 $product2 = new Product(); $product2->setCode(2); $product2->setDescription("Produto de teste 2"); $product2->setAmount(1); $product2->setValue(9); $product2->setExtraDescription(""); //Product Array $products = array($product1, $product2); return $products; }
header("Location: .?category_id={$category_id}"); } else { if ($action == 'show_add_form') { $categories = $categoryDB->getCategories(); include 'product_add.php'; } else { if ($action == 'add_product') { $category_id = filter_input(INPUT_POST, 'category_id', FILTER_VALIDATE_INT); $code = filter_input(INPUT_POST, 'code'); $name = filter_input(INPUT_POST, 'name'); $price = filter_input(INPUT_POST, 'price'); if ($category_id == NULL || $category_id == FALSE || $code == NULL || $name == NULL || $price == NULL || $price == FALSE) { $error = "Invalid product data. Check all fields and try again."; include '../errors/error.php'; } else { $current_category = $categoryDB->getCategory($category_id); // Create the Product object $product = new Product(); $product->setCategory($current_category); $product->setCode($code); $product->setName($name); $product->setPrice($price); // Add the Product object to the database $productDB->addProduct($product); // Display the Product List page for the current category header("Location: .?category_id={$category_id}"); } } } } }
public function parseProducts() { $products = new Products(); $keyParams = array(); $currencies = $this->parseCurrencies(); $measurements = $this->parseMeasurements(); foreach ($this->xmlProducts as $xmlProduct) { $code = $xmlProduct->getCode(); $name = $xmlProduct->getName(); $isAGroup = $xmlProduct->isAGroup(); $articul = $xmlProduct->getArticul(); $basicMeasurementUnitCode = $xmlProduct->getBasicMeasurementUnit(); $basicMeasurementUnit = $measurements->getUnitByCode($basicMeasurementUnitCode); $price = $xmlProduct->getPrice(); $currencyCode = $xmlProduct->getCurrency(); $currency = $currencies->getUnitByCode($currencyCode); $measurementUnitCode = $xmlProduct->getBasicMeasurementUnit(); $measurementUnit = $measurements->getUnitByCode($measurementUnitCode); if (!empty($code) && !in_array($code, $keyParams)) { array_push($keyParams, $code); $product = new Product(); $product->setIsAGroup($isAGroup); $product->setCode($code); $product->setName($name); $product->setArticul($articul); $product->setBasicMeasurementUnit($basicMeasurementUnit); $product->setPrice($price); $currency == null ? '' : $product->setCurrency($currency); $measurementUnit == null ? '' : $product->setMeasurementUnit($measurementUnit); $products->setItem($product); } } $categories = $this->parseCategories(); foreach ($this->xmlProducts as $xmlProduct) { $catCode = $xmlProduct->getCategoryCode(); $code = $xmlProduct->getCode(); $current = $products->getItemByCode($code); $parent = $categories->getItemByCode($catCode); if ($parent != null) { $current->setParent($parent); } } $productDAO = new ProductDAO(); $productDAO->insertItems($products); return $products; }