root/de.wbb-security.database.autojoingroup/files/lib/acp/form/DatabaseAutoJoinGroupEditForm.class.php @ 985

<?php
require_once(WCF_DIR.'lib/acp/form/ACPForm.class.php');

/**
 * @author              Markus Gerdelmann
 * @copyright   2005-2009
 * @package             de.wbb-security.database.autojoingroup
 */
class DatabaseAutoJoinGroupEditForm extends ACPForm {

        public $templateName = 'databaseAutoJoinGroupEdit';
        public $activeMenuItem = 'wcf.acp.menu.link.content.database.autojoingroup.view';
        public $neededPermissions = 'admin.database.canViewAutoJoinGroup';
        
        public $groups = array();
        public $joins = array();
        public $joinID = 0;
        public $edit = 0;
        public $groupID = 0;
        public $uploads = '';
        public $groupName = '';
                
        /**
         * @see Form::readFormParameters()
         */
        public function readFormParameters() {
                parent::readFormParameters();

                if (isset($_POST['groupID'])) {
                        $this->groupID = intval($_POST['groupID']);
                }
                
                if (isset($_POST['uploads'])) {
                        $this->uploads = intval($_POST['uploads']);
                }

                if (isset($_POST['joinID']))    {
                        $this->joinID = intval($_POST['joinID']);
                }       
        }
        
        /**
         * @see Page::readParameters()
         */
        public function readParameters() {
                parent::readParameters();
                
                if (isset($_REQUEST['joinID'])) {
                        $this->joinID = intval($_REQUEST['joinID']);
                }
        }
        
        /**
         * @see Form::validate()
         */
        public function validate() {
                parent::validate();
                
                if ($this->groupID == 0){
                        throw new UserInputException('groupID');
                }
                
                if (empty($this->uploads) || $this->uploads != intval($this->uploads) || intval($this->uploads) < 0) {
                        throw new UserInputException('uploads');
                }

                if ($this->joinID == 0){
                        throw new IllegalLinkException();
                }       
        }
        
        /**
         * @see Page::readData()
         */
        public function readData() {
                parent::readData();
                
                // Hier werden alle Benutzergruppen geladen.
                $sql = "SELECT groupID, groupName, groupType
                                FROM `wcf".WCF_N."_group`
                                ";
                
                $res = WCF::getDB()->sendQuery($sql);
                
                while ($row = WCF::getDB()->fetchArray($res)) {
                        
                        if($row['groupType'] == Group::EVERYONE || $row['groupType'] == Group::GUESTS || $row['groupType'] == Group::USERS) { continue; };
                        
                        if (Group::isAccessibleGroup($row['groupID'])) {
                                $this->groups[] = $row;
                        }
                }

                // Hier wird die zu editierende Regel geladen   
                $sql = "SELECT `a`.*, `b`.`groupName`
                                FROM `wcf".WCF_N."_database_autojoingroup` AS `a`
                                LEFT JOIN `wcf".WCF_N."_group` AS `b`
                                        ON ( `a`.`groupID` = `b`.`groupID`)
                                WHERE `a`.`joinID` = '".$this->joinID."'
                                ";
                
                $res = WCF::getDB()->sendQuery($sql);
        
                while ($row = WCF::getDB()->fetchArray($res)) {
                        $this->joins[] = $row;
                        $this->uploads = $row['uploads'];
                        $this->groupName = $row['groupName'];
                }                               
        }
        
        /**
         * @see Form::save()
         */
        public function save() {
                parent::save();
                
                if (Group::isAccessibleGroup($this->groupID)) {
                        $sql = "UPDATE `wcf".WCF_N."_database_autojoingroup`
                                        SET `groupID` = '".escapeString($this->groupID)."',
                                                `uploads` = '".escapeString($this->uploads)."'
                                        WHERE `joinID` = '".escapeString($this->joinID)."'
                                        ";
                        
                        WCF::getDB()->sendQuery($sql);
                        
                        // show success.
                        WCF::getTPL()->assign(array(
                                'success' => true
                        ));                             
                }       
        }
        
        /**
         * @see Page::show()
         */
        public function show() {
                parent::show();
                
        }
        
        /**
         * @see Page::assignVariables()
         */
        public function assignVariables() {
                parent::assignVariables();
                
                WCF::getTPL()->assign(array(
                
                        'groups' => $this->groups,
                        'joins' => $this->joins,
                        'uploads' => $this->uploads,
                        'groupName' => $this->groupName,
                        'joinID' => $this->joinID
                ));             
        }
}
?>