public function getProductByGroup($id = NULL) { if ($id) { $stmt = $this->pdo->PDOInstance->prepare("SELECT * FROM product as p WHERE p.id_group = :id"); $stmt->bindParam(':id', $id); } else { $stmt = $this->pdo->PDOInstance->prepare("SELECT * FROM product as p"); } try { $stmt->execute(); } catch (Exception $e) { echo "Problem at " . $e->getLine() . " from model Extraction :" . $e->getMessage(); } $result = $stmt->fetchAll(PDO::FETCH_ASSOC); if ($id) { $result_group = $this->getGroup($id); } else { $result_group = $this->getGroup(); } foreach ($result as $product) { $product_ = new product(); $product_->setId($product["id"]); $product_->setRef($product["ref"]); $product_->setName($product["name"]); $product_->setDescription($product["description"]); $product_->setCost($product["cost"]); $product_->setPrice($product["price"]); $product_->setUnit($product["unit"]); $product_->setId_group($product["id_group"]); $indice = 0; foreach ($result_group as $group) { if ($group->getId() == $product_->getId_group()) { $result_group[$indice]->addProduct($product_); } $indice++; } } return $result_group; }
} // convert to bool the published box if (isset($_REQUEST['published'])) { $published = true; } else { $published = false; } // convert to bool the onhome box if (isset($_REQUEST['onhome'])) { $onhome = true; } else { $onhome = false; } $product->setContent($_REQUEST['title_1'], $_REQUEST['content_1'], $_REQUEST['title_2'], $_REQUEST['content_2'], $_REQUEST['title_3'], $_REQUEST['content_3'], $_REQUEST['title_4'], $_REQUEST['content_4'], $_REQUEST['title_5'], $_REQUEST['content_5'], $_REQUEST['title_6'], $_REQUEST['content_6'], $_REQUEST['code']); $product->setReference($_REQUEST['reference']); $product->setPrice($_REQUEST['price']); $product->setVAT($_REQUEST['vat']); $product->setDiscount($_REQUEST['discount']); $product->setCategory($_REQUEST['category']); $product->setDateUpdate(); $product->setService($service); $product->setPublished($published); $product->setonHome($onhome); if ($product->update()) { print 'sucess'; } else { print 'failure'; } } } else { print 'error';