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

<?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';
        
        private $groups = array();
        private $joins = array();
        private $joinID = '';
        private $edit = 0;
        private $groupID = 0;
        private $uploads = '';
        private $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']);
                if (isset($_REQUEST['edit']))   $this->edit = intval($_REQUEST['edit']);
        
        }
        
        /**
         * @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;
                        }
                }
                
                if ($this->edit == 0) {
                        // 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;
                        }
                }
                
                if ($this->edit == 1) {
                        
                        $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 ($this->edit == 0 && 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
                        ));             
                }
                
                if ($this->joinID > 0 && $this->edit == 2 && 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);
                        
                        $this->edit = 0;
                        
                        // 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,
                        'edit' => $this->edit,
                        'uploads' => $this->uploads,
                        'groupName' => $this->groupName,
                        'joinID' => $this->joinID,
                ));
                
        }
}
?>