public function delete() { try { if ($this->_controller->getEntity()->getRow()->uid != $this->_controller->getPermiso()->getAuth()->getId()) { return false; } $whereClauses = array('id = ' . $this->_controller->getDatabase()->quote($this->_controller->getEntity()->getRow()->id)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); return $this->_controller->getFrontController()->getBlogPackage()->getCommentsTable()->delete($where); } catch (Exception $exception) { require_once 'Sitengine/Blog/Frontend/Blogs/Posts/Comments/Exception.php'; throw new Sitengine_Blog_Frontend_Blogs_Posts_Comments_Exception('delete error', $exception); } }
public function updateFromList($id, array $data) { try { if ($id == Sitengine_Permiso::UID_ROOT || $id == Sitengine_Permiso::UID_GUEST || $id == Sitengine_Permiso::UID_LOSTFOUND) { return 0; } if ($this->_controller->getPermiso()->getDirectory()->userIsMember($id, Sitengine_Permiso::GID_ADMINISTRATORS) && !$this->_controller->getPermiso()->getDirectory()->userIsMember($this->_controller->getPermiso()->getAuth()->getId(), Sitengine_Permiso::GID_ADMINISTRATORS)) { # only administrators can update users that are administrators members return 0; } # sanitize data foreach ($data as $k => $v) { if (!preg_match('/^(enabled|locked)$/', $k)) { unset($data[$k]); } } require_once 'Zend/Date.php'; $date = new Zend_Date(); $date->setTimezone('UTC'); $data['mdate'] = $date->get('YYYY-MM-dd HH:mm:ss', Sitengine_Env::LANGUAGE_EN); $whereClauses = array('id = ' . $this->_controller->getDatabase()->quote($id)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); return $this->_controller->getFrontController()->getPermiso()->getUsersTable()->updateOrRollback($data, $where); } catch (Exception $exception) { require_once 'Sitengine/Permiso/Backend/Users/Exception.php'; throw new Sitengine_Permiso_Backend_Users_Exception('update from list error', $exception); } }
public function updateFromList($id, array $data) { try { # sanitize data foreach ($data as $k => $v) { if (!preg_match('/^(sorting|publish)$/', $k)) { unset($data[$k]); } } $date = new Zend_Date(); $date->setTimezone('UTC'); $data['mdate'] = $date->get('YYYY-MM-dd HH:mm:ss', Sitengine_Env::LANGUAGE_EN); $whereClauses = array('id = ' . $this->_controller->getDatabase()->quote($id), $this->_controller->getPermiso()->getDac()->getUpdateAccessSql($this->_controller->getFrontController()->getBlogPackage()->getAuthorizedGroups(), '', false)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); return $this->_controller->getRecord()->update($data, $where); } catch (Exception $exception) { require_once 'Sitengine/Blog/Frontend/Blogs/Posts/Files/Exception.php'; throw new Sitengine_Blog_Frontend_Blogs_Posts_Files_Exception('update from list error', $exception); } }
public function deleteRowsAndFilesRecursively($col, $val) { $whereClauses = array($col . ' = ' . $this->_controller->getDatabase()->quote($val)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); $children = $this->selectRowsAndFiles($where); $deleted = 0; foreach ($children as $child) { $deleted += $this->deleteRowAndFiles($child); $deleted += $this->deleteRowsAndFilesRecursively($col, $child['id']); } return $deleted; }
public function updateFromList($id, array $data) { try { if (!$this->_ok2modify($id)) { return 0; } # sanitize data foreach ($data as $k => $v) { if (!preg_match('/^(enabled|locked)$/', $k)) { unset($data[$k]); } } require_once 'Zend/Date.php'; $date = new Zend_Date(); $date->setTimezone('UTC'); $data['mdate'] = $date->get('YYYY-MM-dd HH:mm:ss', Sitengine_Env::LANGUAGE_EN); $whereClauses = array('id = ' . $this->_controller->getDatabase()->quote($id)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); return $this->_controller->getFrontController()->getPermiso()->getGroupsTable()->updateOrRollback($data, $where); } catch (Exception $exception) { require_once 'Sitengine/Permiso/Backend/Groups/Exception.php'; throw new Sitengine_Permiso_Backend_Groups_Exception('update from list error', $exception); } }
public function delete($id) { try { $whereClauses = array('id = ' . $this->_controller->getDatabase()->quote($id), $this->_controller->getPermiso()->getDac()->getDeleteAccessSql($this->_controller->getFrontController()->getNewsletterPackage()->getAuthorizedGroups(), '', false)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); return $this->_controller->getFrontController()->getNewsletterPackage()->getAttachmentsTable()->delete($where); } catch (Exception $exception) { require_once 'Sitengine/Newsletter/Backend/Campaigns/Attachments/Exception.php'; throw new Sitengine_Newsletter_Backend_Campaigns_Attachments_Exception('delete error', $exception); } }
public function updateFromList($id, array $data) { try { # sanitize data foreach ($data as $k => $v) { if (!preg_match('/^(sorting|publish|locked|displayThis)$/', $k)) { unset($data[$k]); } } $date = new Zend_Date(); $date->setTimezone('UTC'); $data['mdate'] = $date->get(Zend_Date::ISO_8601, Sitengine_Env::LANGUAGE_EN); $whereClauses = array('id = ' . $this->_controller->getDatabase()->quote($id), $this->_controller->getPermiso()->getDac()->getUpdateAccessSql($this->_controller->getFrontController()->getProtoPackage()->getAuthorizedGroups(), '', false)); require_once 'Sitengine/Sql.php'; $where = Sitengine_Sql::getWhereStatement($whereClauses, false); return $this->_controller->getFrontController()->getProtoPackage()->getShouldiesTable()->updateOrRollback($data, $where); } catch (Exception $exception) { require_once 'Sitengine/Proto/Backend/Goodies/Shouldies/Exception.php'; throw new Sitengine_Proto_Backend_Goodies_Shouldies_Exception('update from list error', $exception); } }