root/racing.league/files/lib/form/RacingLeaguePunishForm.class.php @ 707

<?php
// wcf imports
require_once(WCF_DIR.'lib/form/RacingLeagueForm.class.php');

/**
 * Seite um Strafen bzw. Strafpunkte zu erfassen
 * 
 * @author      Markus Gerdelmann
 * @copyright   2008 MDMAN
 * @license GNU
 * @package     de.mdman.racing.league
 */

class RacingLeaguePunishForm extends RacingLeagueForm {
 
        public $templateName = 'racingLeaguePunish';
        public $saisonID = 0;
        public $editPunishID = 0;
        public $newPunish = 0;
        public $punish = array();
        public $addPunish = 0;
        public $raceID = 0;
        public $driver = '';
        public $minusPoints = '';
        public $punishReason = '';
        
        public $drivedRaces = array();
        
        public $redirect = 'RacingLeaguePunish';

        /**
         * @see Form::readParameters()
         */
        public function readParameters() {
                parent::readParameters();

                if (isset($_REQUEST["saisonID"]))               $this->saisonID = intval($_REQUEST["saisonID"]);
                if (isset($_REQUEST["editPunishID"]))   $this->editPunishID = intval($_REQUEST["editPunishID"]);
                if (isset($_REQUEST["addPunish"]))              $this->addPunish = intval($_REQUEST["addPunish"]);
                if (isset($_REQUEST["raceID"]))         $this->raceID = intval($_REQUEST["raceID"]);
                                        
        }
        
        /**
         * @see Form::readFormParameters()
         */
        public function readFormParameters() {
                parent::readFormParameters();
                
                if (isset($_POST["raceID"]))    $this->raceID = intval($_POST["raceID"]);
                if (isset($_POST["driver"]))    $this->driver = intval($_POST["driver"]);
                if (isset($_POST["minusPoints"]))       $this->minusPoints = intval($_POST["minusPoints"]);
                if (isset($_POST["punishReason"]))      $this->punishReason = StringUtil::trim($_POST["punishReason"]);

        }
        
        /**
         * @see Form::validate()
         */
        public function validate() {
                parent::validate();

                // driver
                if (empty($this->driver) && $this->addPunish == 3) {
                        throw new UserInputException('driver');
                }

                // punishReason
                if (empty($this->punishReason) && $this->addPunish == 3) {
                        throw new UserInputException('punishReason');
                }                               
        }

        /**
         * @see Form::readData()
         */
        public function readData() {
                parent::readData();

                // Hier werden alle Rennen inklusive Strafen geladen
                if ($this->activeSaisonID != 0) {
                        $sql = "SELECT  `a`.*, 
                                                        `b`.`username`,
                                                        `b`.`userID`,
                                                        `c`.`raceName`,
                                                        `c`.`raceNo`
                                FROM `wcf".WCF_N."_racing_punish` AS `a`
                                LEFT JOIN `wcf".WCF_N."_user` AS `b`
                                ON (`b`.`userID` = `a`.`userID`)
                                LEFT JOIN `wcf".WCF_N."_racing_races` AS `c`
                                ON (`a`.`raceID` = `c`.`raceID`)
                                WHERE `a`.`saisonID` = '".$this->activeSaisonID."'
                                AND `c`.`saisonID` = '".$this->activeSaisonID."'
                                ORDER BY `raceNo` ASC                           
                                ";
                        $res = WCF::getDB()->sendQuery($sql);

                        while ($row = WCF::getDB()->fetchArray($res)) {
                                $this->punish[] = $row;
                        }
                }

                if ($this->activeSaisonID != 0 && $this->addPunish == 1) {
                        // Hier werden alle gefahrenen Rennen geladen (drived = 1)
                        $sql = "SELECT raceID, raceName
                                FROM `wcf".WCF_N."_racing_races`
                                WHERE `saisonID` = '".$this->activeSaisonID."'
                                AND `drived` = '1'
                                ORDER BY `raceNO` ASC
                                ";              
                        
                        $res = WCF::getDB()->sendQuery($sql);

                        while ($row = WCF::getDB()->fetchArray($res)) {
                                $this->drivedRaces[] = $row;
                        }                       
                }
                
                if ($this->activeSaisonID != 0 && $this->raceID > 0) {

                        
                }                       
                
        }
        
        /**
         * @see Form::save()
         */
        public function save() {
                parent::save();

                if ($this->addPunish == 3 && isset($this->driver) && isset($this->minusPoints) && isset($this->punishReason) && $this->raceID > 0 && $this->activeSaisonID != 0) {
                
                        $sql = "INSERT INTO `wcf".WCF_N."_racing_punish`
                                (`saisonID`, `raceID`, `userID`, `minusPoints`, `punishReason`)
                                VALUES ('".escapeString($this->activeSaisonID)."', '".escapeString($this->raceID)."', '".escapeString($this->driver)."', '".escapeString($this->minusPoints)."', '".escapeString($this->punishReason)."')
                                ";

                        $res = WCF::getDB()->sendQuery($sql);

                        $row = 0;
                        $row = WCF::getDB()->getAffectedRows($res);
                        $this->addPunish = 0;
                        $this->raceID = 0;
                        if ($row > 0) {                         
                                WCF::getTPL()->append('userMessages', WCF::getTPL()->fetch('racingLeagueNewSuccess'));
                        }
                        else {
                                WCF::getTPL()->append('userMessages', WCF::getTPL()->fetch('racingLeagueNewError'));
                        }
                        
                }       
        }       
        
        /**
         * @see Page::assignVariables();
         */
        public function assignVariables() {
                parent::assignVariables();

                WCF::getTPL()->assign(array(
                        'saisonID' => $this->saisonID,
                        'editPunishID' => $this->editPunishID,
                        'punish' => $this->punish,
                        'addPunish' => $this->addPunish,
                        'drivedRaces' => $this->drivedRaces,
                        'raceID' => $this->raceID,
                        'driver' => $this->driver,
                                                                        
                        'redirect' => $this->redirect
                        ));
        }
        
        /**
         * @see Page::show()
         */
        public function show() {
                
                // check permission
                WCF::getUser()->checkPermission('admin.racing.league.caneditresults');
                require_once(WCF_DIR.'lib/page/util/menu/HeaderMenu.class.php');
                HeaderMenu::setActiveMenuItem('wcf.header.menu.racing.league');
                parent::show();         
    }
}
?>