root/racing.league/files/lib/form/RacingLeagueResultsForm.class.php @ 656

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

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

class RacingLeagueResultsForm extends RacingLeagueForm {
 
        public $templateName = 'racingLeagueResults';
        public $saisonID = 0;
        public $new = 0;
        public $edit = 0;
        public $results = array();
        public $result = array();
        public $groupID = 0;
        public $userIDs = array();
        public $places = array();
        public $race = array();
        public $raceID = 0;             

        public $redirect = 'RacingLeagueResults';
        
        /**
         * @see Form::readParameters()
         */
        public function readParameters() {
                parent::readParameters();

                if (isset($_REQUEST["saisonID"]))               $this->saisonID = intval($_REQUEST["saisonID"]);        
                if (isset($_REQUEST["new"]))            $this->new = intval($_REQUEST["new"]);
                if (isset($_REQUEST["edit"]))           $this->edit = intval($_REQUEST["edit"]);
                if (isset($_REQUEST["resultsID"]))              $this->resultsID = intval($_REQUEST["resultsID"]);
                if (isset($_REQUEST["raceID"]))         $this->raceID = intval($_REQUEST["raceID"]);
                
        }
        
        /**
         * @see Form::readFormParameters()
         */
        public function readFormParameters() {
                parent::readFormParameters();
                
                var_dump($_POST["result"]);
                if (isset($_POST["result"]))    $this->result = $_POST["result"];               
        }
        
        /**
         * @see Form::validate()
         */
        public function validate() {
                parent::validate();

                // point bei NEW
                if ($this->new == 1) {
                        if (empty($this->result)) {
                                $this->new = '1';
                                throw new UserInputException('result');
                        }
                }                               
        }

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

                if ($this->activeSaisonID != 0) {
                        // Hier wird das aktuelle Rennen ermittelt
                        $sql = "SELECT *
                                        FROM wcf".WCF_N."_racing_races
                                        WHERE saisonID = '".$this->activeSaisonID."'
                                        AND drived = '0'
                                        ORDER BY raceNo ASC
                                        LIMIT 1";
                                                
                        $res = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($res)) {
                                $this->race[] = $row;
                                $this->raceID = $row["raceID"];
                        }
                        
                        
                        if (!$this->race) {
                                header("Location: index.php?form=RacingLeagueRaces".SID_ARG_2ND_NOT_ENCODED);
                                exit;
                        }
                        
        
                        // Hier wird die groupID der Saison ermittelt
                        $sql = "SELECT *
                                        FROM wcf".WCF_N."_racing_group
                                        WHERE saisonID = '".$this->activeSaisonID."'
                                        ";
                        $res = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($res)) {
                                $this->groupID = $row["groupID"];
                        }
                }

                
                if ($this->new == 1 && $this->activeSaisonID != 0 && $this->groupID != 0) {

                        // Hier werden alle verfÌgbaren PlÀtze ermittelt
                        $sql = "SELECT *
                                        FROM wcf".WCF_N."_racing_points
                                        WHERE saisonID = '".$this->activeSaisonID."'
                                        ORDER BY place asc";

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

                        while ($row = WCF::getDB()->fetchArray($res)) {
                                $this->places[$row['place']] = $row;
                        }
                                
                        if (!$this->places) {
                                header("Location: index.php?form=RacingLeaguePoints".SID_ARG_2ND_NOT_ENCODED);
                                exit;
                        }                       
                }

                // Hier wird ein Ergebnis geladen was editiert werden soll
                if ($this->edit == 1) {

                        $sql = "SELECT * 
                                        FROM wcf".WCF_N."_racing_results
                                        WHERE resultID = '".$this->resultID."'
                                        ";
                
                        $res = WCF::getDB()->sendQuery($sql);
                
                        while ($row = WCF::getDB()->fetchArray($res)) {
                                
                        }                       
                }               
                        
                //Hier werden alle Ergebnisse geladen
                if ($this->activeSaisonID != 0) {
                        $sql = "SELECT *
                                        FROM wcf".WCF_N."_racing_results
                                        WHERE saisonID = ".$this->activeSaisonID."
                                        ORDER BY place ASC
                                        ";

                        $res = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($res)) {
                                $this->results[] = $row;
                        }                       
                }       
        }
        
        /**
         * @see Form::save()
         */
        public function save() {
                parent::save();
                
                // Hier wird ein neues Ergebnis gespeichert
                if ($this->result && $this->activeSaisonID != 0 && $this->new == 1 && $this->edit == 1) {
                        
                        $sql = "INSERT INTO wcf".WCF_N."_racing_results (saisonID, resultID, userID, place, points)
                                VALUES ('".escapeString($this->activeSaisonID)."', '', '".escapeString($this->result["userID"])."', '', '".escapeString($this->result["points"])."')
                                ";
                        $res = WCF::getDB()->sendQuery($sql);

                        $row = 0;
                        $row = WCF::getDB()->getAffectedRows($res);
                        $this->new = 0;
                        if ($row > 0) {                         
                                WCF::getTPL()->append('userMessages', WCF::getTPL()->fetch('racingLeagueNewSuccess'));
                        }
                        else {
                                WCF::getTPL()->append('userMessages', WCF::getTPL()->fetch('racingLeagueNewError'));
                        }
                }

                // Hier wird ein Ergebnis bearbeitet
                if ($this->result && $this->activeSaisonID != 0 && $this->edit == 1 && $this->pointsID != 0) {
                
                        $sql = "UPDATE wcf".WCF_N."_racing_points 
                                        SET     points = '".escapeString($this->point)."',
                                                place = '".escapeString($this->place)."'
                                        WHERE   pointsID = '".escapeString($this->pointsID)."'
                                        LIMIT 1
                                        ";
                        
                        $res = WCF::getDB()->sendQuery($sql);

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

                WCF::getTPL()->assign(array(
                        'saisonID' => $this->saisonID,
                        'new' => $this->new,
                        'edit' => $this->edit,
                        'results' => $this->results,
                        'groupID' => $this->groupID,
                        'places' => $this->places,
                        'race' => $this->race,
                        'raceID' => $this->raceID,                      
                                                
                        '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();         
    }
}
?>