root/de.wbb-security.database.autojoingroup/files/lib/acp/form/DatabaseAutoJoinGroupForm.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 DatabaseAutoJoinGroupForm extends ACPForm {

        public $templateName = 'databaseAutoJoinGroup';
        public $activeMenuItem = 'wcf.acp.menu.link.content.database.autojoingroup.view';
        public $neededPermissions = 'admin.database.canViewAutoJoinGroup';
        
        public $groups = array();
        public $joins = array();
        public $groupID = 0;
        public $uploads = '';
                
        /**
         * @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']);
                }               
        }       
        
        /**
         * @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');
                }               
        }
        
        /**
         * @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 werden die schon vorhandenen AutoJoinGroups geladen.
                $sql = "SELECT `a`.*, `b`.`groupName`, `b`.`groupType`
                                FROM `wcf".WCF_N."_database_autojoingroup` AS `a`
                                LEFT JOIN `wcf".WCF_N."_group` AS `b`
                                        ON ( `a`.`groupID` = `b`.`groupID`)
                                ORDER BY `uploads` ASC
                                ";
        
                $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; };
                        
                        $row['editable'] = '0';
                        
                        if (Group::isAccessibleGroup($row['groupID'])) {
                                $row['editable'] = '1';
                        }
                        
                        $this->joins[] = $row;
                }                                       
        }
        
        /**
         * @see Form::save()
         */
        public function save() {
                parent::save();
                
                if (Group::isAccessibleGroup($this->groupID)) {         
                        $sql = "INSERT INTO `wcf".WCF_N."_database_autojoingroup` (`joinID`, `groupID`, `uploads`)
                        VALUES ('', '".escapeString($this->groupID)."', '".escapeString($this->uploads)."')
                        ";
                        
                        WCF::getDB()->sendQuery($sql);
                                
                        // show success.
                        WCF::getTPL()->assign(array(
                                'success' => true
                        ));
                        
                        $this->groupID = 0;
                        $this->uploads = '';
                }               
        }
        
        /**
         * @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,
                        'groupID' => $this->groupID
                ));             
        }
}
?>