protected function modify(Category $category)
{
$q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET NAME = :name, DESCRIPTION = :description, PARENT_CATEGORY_ID = :parentCategoryId, IS_ROOT = :isRoot WHERE ID = :id');
$q->bindValue(':name', $category->getName());
$q->bindValue(':description', $category->getDescription());
$q->bindValue(':parentCategoryId', $category->getParentCategoryId());
$q->bindValue(':isRoot', $category->getIsRoot());
$q->bindValue(':id', $category->id(), PDO::PARAM_INT);
$q->execute();
}
public function edit(User $currentUser, Category $category)
{
$id = intval($category->getId());
$name = $this->database->quote($category->getName());
$description = $this->database->quote($category->getDescription());
$query = "UPDATE category SET name = '" . $name . "', description = '" . $description . "' WHERE id = " . $id;
$result = $this->database->exec($query);
if ($result) {
return true;
} else {
throw new Exception("Catastrophe base de données.");
}
}
public function create($name, $description, $img)
{
$category = new Category($this->db);
$errors = array();
try {
$category->setName($name);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$category->setDescription($description);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
try {
$category->setImg($img);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
if (count($errors) == 0) {
$name = $this->db->quote($category->getName());
$description = $this->db->quote($category->getDescription());
$img = $this->db->quote($category->getImg());
$query = "INSERT INTO category (name, description, img) VALUES(" . $name . "," . $description . "," . $img . ")";
$res = $this->db->exec($query);
if ($res) {
$id = $this->db->lastInsertId();
if ($id) {
return $this->findById($id);
} else {
$errors[] = "Category not found";
return $errors;
}
} else {
$errors[] = "Internal server error";
return $errors;
}
} else {
return $errors;
}
}
public function update(Category $category)
{
$id = intval($category->getId());
$name = $this->db->quote($category->getName());
$description = $this->db->quote($category->getDescription());
$query = "UPDATE category SET name='" . $name . "', description='" . $description . "', WHERE id='" . $id . "'";
$res = $this->db->exec($query);
if ($result) {
return $this->readById($id);
} else {
return "Error";
}
}
public function update(Category $category, $errors = array())
{
$id = $category->getId();
$name = $this->db->quote($category->getName());
$description = $this->db->quote($category->getDescription());
$query = "UPDATE category SET name = " . $name . ", description = " . $description . "WHERE id = " . $id;
$data = $this->db->exec($query);
if ($data) {
$id = $this->db->lastInsertId();
if ($id) {
try {
$category = $this->findByid($id);
return $category;
} catch (Exception $e) {
$errors[] = $e->getMessage();
return $errors;
}
} else {
throw new Exception('Last insert error');
}
} else {
throw new Exception('Update error');
}
}
