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);
}
}
