public function delete($object) { // get database $db = $this->database; // update childrens parent category $query = "UPDATE " . $this->name . " SET parent=" . $object->parent . " WHERE parent=" . $object->id; $db->query($query); // delete category to item relations $this->app->category->deleteCategoryItemRelations($object->id); $result = parent::delete($object); // trigger deleted event $this->app->event->dispatcher->notify($this->app->event->create($object, 'category:deleted')); return $result; }
public function delete($object) { // Check ACL if (!$object->isAdmin()) { throw new ApplicationTableException('Invalid Access Permissions'); } // delete related categories $table = $this->app->table->category; $categories = $table->all(array('conditions' => array('application_id=?', $object->id))); foreach ($categories as $category) { $table->delete($category); } // delete related items $table = $this->app->table->item; $items = $table->all(array('conditions' => array('application_id=?', $object->id))); foreach ($items as $item) { $table->delete($item); } $result = parent::delete($object); // trigger deleted event $this->app->event->dispatcher->notify($this->app->event->create($object, 'application:deleted')); return $result; }
public function delete($object) { // Check ACL if (!$object->canDelete()) { throw new ItemTableException('Invalid Access Permission'); } // get database $db = $this->database; // delete item to category relations $query = "DELETE FROM " . ZOO_TABLE_CATEGORY_ITEM . " WHERE item_id = " . (int) $object->id; $db->query($query); // delete related comments $query = "DELETE FROM " . ZOO_TABLE_COMMENT . " WHERE item_id = " . (int) $object->id; $db->query($query); // delete related search data rows $query = "DELETE FROM " . ZOO_TABLE_SEARCH . " WHERE item_id = " . (int) $object->id; $db->query($query); // delete related rating data rows $query = "DELETE FROM " . ZOO_TABLE_RATING . " WHERE item_id = " . (int) $object->id; $db->query($query); // delete related tag data rows $query = "DELETE FROM " . ZOO_TABLE_TAG . " WHERE item_id = " . (int) $object->id; $db->query($query); $result = parent::delete($object); // trigger deleted event $this->app->event->dispatcher->notify($this->app->event->create($object, 'item:deleted')); return $result; }
public function delete($object) { // delete related categories $table = $this->app->table->category; $categories = $table->all(array('conditions' => array('application_id=?', $object->id))); foreach ($categories as $category) { $table->delete($category); } // delete related items $table = $this->app->table->item; $items = $table->all(array('conditions' => array('application_id=?', $object->id))); foreach ($items as $item) { $table->delete($item); } $result = parent::delete($object); // trigger deleted event $this->app->event->dispatcher->notify($this->app->event->create($object, 'application:deleted')); return $result; }
public function delete($object) { // get database $db = $this->database; $old_parent = $object->id; $new_parent = $object->parent_id; parent::delete($object); $query = "UPDATE " . $this->name . " SET parent_id = " . $new_parent . " WHERE parent_id = " . $old_parent; $result = $db->query($query); // trigger deleted event $this->app->event->dispatcher->notify($this->app->event->create($object, 'comment:deleted')); return $result; }
public function delete($object) { // Check ACL if (!$object->canManageCategories()) { throw new CategoryTableException('Invalid Access Permissions'); } // get database $db = $this->database; // update childrens parent category $query = "UPDATE " . $this->name . " SET parent=" . $object->parent . " WHERE parent=" . $object->id; $db->query($query); // delete category to item relations $this->app->category->deleteCategoryItemRelations($object->id); $result = parent::delete($object); // trigger deleted event $this->app->event->dispatcher->notify($this->app->event->create($object, 'categeory:deleted')); return $result; }