function deleteAction()
{
// set page title
$this->view->title = "Supprimer un groupe d'administrateur";
// get params
$administratorGroupID = (int) $this->_getParam('administratorGroupID');
if ($this->_request->isPost()) {
// if is set delete, then delete
$delete = isset($_POST['delete']);
$returnLink = $this->view->url(array('controller' => 'administrator-group', 'action' => 'index', 'administratorGroupID' => null));
if ($delete && $administratorGroupID > 0) {
// delete group
$group = new ExtranetGroups();
$where = 'EG_ID = ' . $administratorGroupID;
$group->delete($where);
// delete group index
$groupIndex = new ExtranetGroupsIndex();
$where = 'EGI_GroupID = ' . $administratorGroupID;
$groupIndex->delete($where);
// delete Extranet_Groups_Pages_Permissions
$groupPagesPermissions = new ExtranetGroupsPagesPermissions();
$where = 'EGPP_GroupID = ' . $administratorGroupID;
$groupPagesPermissions->delete($where);
// delete Extranet_UsersGroups
$groupUsers = new ExtranetUsersGroups();
$where = 'EUG_GroupID = ' . $administratorGroupID;
$groupUsers->delete($where);
}
header("location:" . $returnLink);
} else {
if ($administratorGroupID > 0) {
$administratorGroup = new ExtranetGroupsIndex();
$this->view->group = $administratorGroup->fetchRow('EGI_GroupID=' . $administratorGroupID . ' AND EGI_LanguageID = ' . Zend_Registry::get("languageID"));
}
}
}
public static function getAdministratorGroupData($groupID)
{
$groupData = new ExtranetGroups();
$select = $groupData->select()->setIntegrityCheck(false)->from('Extranet_Groups')->join('Extranet_GroupsIndex', 'Extranet_Groups.EG_ID = Extranet_GroupsIndex.EGI_GroupID')->where("EG_ID = ?", $groupID)->where("EGI_LanguageID = ?", Zend_Registry::get("languageID"));
return $groupData->fetchRow($select);
}
