root/de.wbb-security.database.additionalrating/files/lib/system/event/listener/DatabaseAdditionalRatingCategoryACPListener.class.php @ 951

<?php
require_once(WCF_DIR.'lib/system/event/EventListener.class.php');
require_once(WCF_DIR.'lib/acp/form/DatabaseCategoryEditForm.class.php');

/**
 * Shows the additonalRatings in the Webdisk-Item
 * 
 * @author              Markus Gerdelmann
 * @copyright   2005-2009
 * @package             de.wbb-security.database.additionalrating
 */
class DatabaseAdditionalRatingCategoryACPListener extends DatabaseCategoryEditForm {

    private $catID = 0;
    private $fields = array();
    private $ratingID = 0;
    private $edit = 0;
    private $rating = array();
    private $field = '';
    private $sortOrder = 0;
   

    /**
    * @see EventListener::readFormParameters()
    */
    public function readFormParameters() {
        parent::readFormParameters();
        
        if(isset($_POST['field'])) $this->field = StringUtil::Trim($_POST['field']);
        if(isset($_POST['sortOrder'])) $this->sortOrder = intval($_POST['sortOrder']);
    }
    
    /**
    * @see EventListener::readParameters()
    */
    public function readParameters() {
        parent::readParameters();
        
                if(isset($_REQUEST['ratingID'])) $this->ratingID = intval($_REQUEST['ratingID']);
        if(isset($_REQUEST['edit'])) $this->edit = intval($_REQUEST['edit']);
    }
    
    /**
    * @see EventListener::validate()
    */
    public function validate() {
        parent::validate();
        
        if (empty($this->field)) {
                throw new UserInputException('field');
        }
        
        if ($this->sortOrder == 0) {
                throw new UserInputException('sortOrder');
        }
    }
    
    /**
    * @see EventListener::execute()
    */
    public function execute($eventObj, $className, $eventName){
        
        // Hier wird die aktuelle KategoryID ausgelesen
        $this->catID = $eventObj->categoryID;

        if ($this->edit == 1 && $this->ratingID > 0) {
                
                $sql = "SELECT *
                                FROM `wcf".WCF_N."_database_additionalrating`
                                WHERE `ratingID` = '".$this->ratingID."'
                                ";
                $result = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($result)) {
                                $this->rating[] = $row;
                        }               
        }
        
        
        if ($this->catID > 0) {
                
                //Hier werden die vorhandenen Felder geladen.
                $sql = "SELECT *
                                FROM `wcf".WCF_N."_database_additionalrating`
                                WHERE `catID` = '".$this->catID."'
                                ORDER by `sortOrder` ASC
                                ";
                
                $result = WCF::getDB()->sendQuery($sql);
                        while ($row = WCF::getDB()->fetchArray($result)) {
                                $this->fields[] = $row;
                        }                       
        }       
                        
                        //Hier werden die Variablen in den Template-Variabeln registriert
                WCF::getTPL()->assign(array(
                'fields' => $this->fields,
                'catID' => $this->catID,
                'field' => $this->field,
                'sortOrder' => $this->sortOrder
                ));

                        //Hier wird das Template in den Platzhalter der databaseItem.tpl geladen
                        if(!defined("DATABASE_ADDITIONALRATING_CATEGORY_TPL")) { 
                                        WCF::getTPL()->append('additionalFields2', WCF::getTPL()->fetch('databaseAdditionalRatingCategory'));   
                                        define("DATABASE_ADDITIONALRATING_CATEGORY_TPL",1);
                        }                       
        }
        
        /**
    * @see EventListener::save()
    */
    public function save() {
        parent::save();
        
        if (!empty($this->field) && $this->catID > 0) {
                
                $sql = "INPUT INTO `wcf".WCF_N."_database_additionalrating`
                                (`catID`, `field`, `sortOrder`)
                                VALUES ('".escapeString($this->catID)."', '".escapeString($this->field)."', '".escapeString($this->sortOrder)."')
                                ";
                
                WCF::getDB()->sendQuery($sql);
                
                $this->field = '';
                $this->sortOrder = 0;
                
                WCF::getTPL()->assign(array(
                                'success' => true
                        ));
        }   
    }
}
?>