public function removeConcert($id) { $this->db->begin(); try { $this->db->query("DELETE FROM concert WHERE id=%i", $id); $this->nameModel->clear('concert', array('name_id', 'place_name_id', 'text_name_id')); } catch (Exception $ex) { $this->db->rollback(); throw $ex; } $this->db->commit(); return $this; }
public function setMenu(array $items) { $this->db->begin(); try { $this->saveMenu($items, 0); $this->nameModel->clear('menu'); } catch (Exception $ex) { $this->db->rollback(); throw $ex; } $this->db->commit(); return $this; }
public function setPage($menuId, $text) { $this->db->begin(); try { $nameId = $this->nameModel->setName($text, 'page', FALSE); $this->db->query("INSERT INTO [page] (menu_id, name_id) VALUES (%i, %i) ON DUPLICATE KEY UPDATE name_id=%i", $menuId, $nameId, $nameId); $this->nameModel->clear('page'); } catch (Exception $ex) { $this->db->rollback(); throw $ex; } $this->db->commit(); return $this; }
public function setArticle($menuId, $text, $id = NULL) { $this->db->begin(); try { $nameId = $this->nameModel->setName($text, 'article', FALSE); if ($id) { $this->db->query("UPDATE [article] SET name_id=%i WHERE id=%i", $nameId, $id); } else { $this->db->query("INSERT INTO [article] (menu_id, name_id) VALUES (%i, %i)", $menuId, $nameId); $id = $this->db->getInsertId(); } $this->setArticleUrl($text, $menuId, $id, $nameId); $this->moveArticleUp($menuId); $this->nameModel->clear('article'); } catch (Exception $ex) { $this->db->rollback(); throw $ex; } $this->db->commit(); return $id; }
public function remove($id, $type) { $this->db->begin(); try { $this->db->query("DELETE FROM %sql WHERE id=%i", $type, $id); $this->nameModel->clear($type); } catch (Exception $ex) { $this->db->rollback(); throw $ex; } $this->db->commit(); return $this; }
public function removeAlbum($id) { $this->db->begin(); try { $this->db->query("DELETE FROM song WHERE album_id=%i", $id); $this->db->query("DELETE FROM album WHERE id=%i", $id); $this->nameModel->clear('album', array('name_id', 'text_name_id'))->clear('song', array('name_id', 'text_name_id')); } catch (Exception $ex) { $this->db->rollback(); throw $ex; } $this->db->commit(); }