<?php

namespace database;

include_once "../../global.inc.php";
include_once PATH_UTILITTY . "/ArrayManager.php";
require_once PATH_DATABASE . "/SqlManager.php";

/**
 * Description of PisSqlManager
 * 
 * @author stubbfel
 * @since 20.06.2013
 */
class PisSqlManager extends SQLManager {

    /**
     * Fieldname of the placeID
     * @var string
     */
    public static $placeId = "pid";

    /**
     * Fieldname of the name of the information
     * @var string
     */
    public static $infName = "iName";

    /**
     * Fieldname of the value of the information
     * @var string
     */
    public static $infValue = "iValue";

    /**
     * Fieldname of the parendId
     * @var string
     */
    public static $parentId = "parent";

    /**
     * Fieldname of the refpoint
     * @var string
     */
    public static $refpoint = "refpoint";

    /**
     * String for the select part of the query
     * @var string
     */
    private static $selectTerm = "SELECT pid, parent, refpoint, iName, iValue FROM pis WHERE ";

    /**
     * String for the select all part of the query
     * @var string
     */
    private static $selectAllTerm = "SELECT pid, parent, refpoint, iName, iValue FROM pis ";

    /**
     * String for the orderby part of the query
     * @var string
     */
    private static $orderByTerm = " ORDER BY pid, iName";

    /**
     * String for like-Statement fo iValue field
     * @var string 
     */
    private static $iValueLikeTerm = "iValue LIKE ";

    /**
     * String for the pid part of the query
     * @var string
     */
    private static $pidTerm = "pid = ";

    /**
     * String for the parent part of the query
     * @var string
     */
    private static $parentTerm = "parent = ";

    /**
     * String for the iName part of the query
     * @var string
     */
    private static $iNameTerm = "iName = ";

    /**
     * Variable for the max lenght of an valid pattern string
     * @var int
     */
    private static $patterMaxLenght = 30;

    /**
     * Default-Constructor
     */
    public function __construct() {
        parent::__construct();
    }

    /**
     * Default-DeConstructor
     */
    public function __destruct() {
        parent::__destruct();
    }

    /**
     * Methods send an query for the pis-service
     * @param array $queryArgs
     * @return array [num][assoc]
     */
    public function sendPisQuery($pidList, $parentId, $iNameList, $iPatter = "*") {

        // build query string
        $query = self::$selectTerm;
        if (\utiliy\ArrayManager::validIntList($pidList)) {
            $query .= self::$openBracket;
            $query .= \utiliy\ArrayManager::toSqlWhereString($pidList, self::$orTerm, self::$pidTerm);
            $query .= self::$closeBracket;
        } else if ($pidList[0] != "*") {
            return null;
        }

        if ($parentId != "*" && \utiliy\StringManager::validInt($parentId)) {
            if ($query != self::$selectTerm) {
                $query .= self::$andTerm;
            }
            $query .= self::$parentTerm . "$parentId";
        }

        if (count($iNameList) > 0 && \utiliy\ArrayManager::validAlphaNumList($iNameList)) {
            if ($query != self::$selectTerm) {
                $query .= self::$andTerm;
            }
            $query .= self::$openBracket;
            $query .= \utiliy\ArrayManager::toSqlWhereString($iNameList, self::$orTerm, self::$iNameTerm);
            $query .= self::$closeBracket;
        }

        if ($iPatter != "*" && $this->validIPatter($iPatter)) {
            if ($query != self::$selectTerm) {
                $query .= self::$andTerm;
            }
            $query .= self::$iValueLikeTerm . "'%$iPatter%'";
        }

        if ($query == self::$selectTerm) {
            $query = self::$selectAllTerm;
        }

        $query .= self::$orderByTerm;

        // send query
        return $this->query($query);
    }

    /**
     * Method check if the input value for pattern string is valid
     * @param string $domain
     * @return boolean
     */
    private function validIPatter($iPatter) {
        if (\utiliy\StringManager::validSQLString($iPatter) && ctype_alnum($iPatter) && strlen($iPatter) <= self::$patterMaxLenght) {
            return TRUE;
        }
        return FALSE;
    }

}

?>