<?php
require_once(WCF_DIR.'lib/form/CaptchaForm.class.php');
require_once(WCF_DIR.'lib/data/user/User.class.php');
require_once(WCF_DIR.'lib/page/util/menu/HeaderMenu.class.php');
require_once(WCF_DIR.'lib/page/util/InlineCalendar.class.php');
require_once(WCF_DIR.'lib/data/user/rank/UserRank.class.php');
require_once(WCF_DIR.'lib/data/user/UserProfile.class.php');
/**
 * Form for adding a Donation.
 *
 * @author  Lars Mehrhoff
 * @license GPLv3 <http://www.gnu.org/licenses/gpl-3.0.txt>
 * @package de.evolutio.paysafecard.donation
 */
class PaysafecardDonationAddForm extends CaptchaForm {
    // template name
    public $templateName = 'paysafecardDonationAdd';
    public $neededPermissions = 'user.paysafecard_donation.canAdd';

    public function readFormParameters() {
        parent::readFormParameters();

        if (isset($_POST['paysafecardID'])) {
            $this->psc['paysafecardID'] = intval($_POST['paysafecardID']);
        }
        if (isset($_POST['pin'])) {
            $this->psc['pin'] = intval($_POST['pin']);
        }
        if (isset($_POST['creator'])) {
            $this->psc['creator'] = StringUtil::trim($_POST['creator']);
        }
        if (isset($_POST['creatorID'])) {
            $this->psc['creatorID'] = intval($_POST['creatorID']);
        }
        if (isset($_POST['description'])) {
            $this->psc['description'] = StringUtil::trim($_POST['description']);
        }
    }

    public function validate() {
        parent::validate();

        if (empty($this->psc['pin'])) {
            throw new UserInputException('pin', 'empty');
        }
        if (empty($this->psc['description'])) {
            throw new UserInputException('description', 'empty');
        }
        $this->convertAndValidateDate();
    }

    public function save() {
        parent::save();

        $sql = "INSERT INTO wcf".WCF_N."_paysafecard
                    (userID, paysafecardID, pin, amount,description
                    )
                VALUES ('".WCF::getUser()->userID."',
                        '".escapeString($this->psc['paysafecardID'])."',
                        '".escapeString($this->psc['pin'])."',
                        '".escapeString($this->psc['amount'])."',
                        '".escapeString($this->psc['description'])."')";

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

        $this->saved();

        // redirect to ToDoList
        HeaderUtil::redirect('index.php?page=paysafecardDonation'.SID_ARG_2ND_NOT_ENCODED);
        exit;
    }

    public function readData() {
        parent::readData();

        $sql = "SELECT *
                FROM wcf".WCF_N."_paysafecard
                ORDER BY sortOrder ASC";

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

        // get groupIDs with groupOption isAssignableUser
        $assignableGroupIDs = "0";
        $sql = "SELECT groupOptionValue.groupID
                FROM wcf".WCF_N."_group_option_value groupOptionValue
                    LEFT JOIN wcf".WCF_N."_group_option groupOption
                        ON (groupOptionValue.optionID = groupOption.optionID)
                WHERE groupOption.optionName = 'user.todolist.assigments.isAssignableUser'
                    AND groupOptionValue.optionValue = 1";
        $result = WCF::getDB()->sendQuery($sql);
        while ($row = WCF::getDB()->fetchArray($result)) {
            $assignableGroupIDs .= ",".intval($row['groupID']);
        }

        // query for user to whom a todo can be assigned
        $sql = "SELECT DISTINCT usergroups.userID, user.username
                FROM wcf".WCF_N."_user_to_groups usergroups
                    LEFT JOIN wcf".WCF_N."_user user
                        ON (user.userID = usergroups.userID)
                WHERE
                    usergroups.groupID
                IN
                    ( ".$assignableGroupIDs." )
                ORDER BY user.username ASC";
        $result = WCF::getDB()->sendQuery($sql);

        // empty entry in list -> possibility not to assign a todo to an user
        $this->assignableUsersArray[""] = "";

        while ($row = WCF::getDB()->fetchArray($result)) {
          $this->assignableUsersArray[$row['userID']] = $row['username'];
        }

    }
}
?>