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';
