<?php
mysql_connect("localhost","kodknatte_root","xxx");
mysql_select_db("kodknatte_derp");
require_once('idna_convert.class.php');
class Search {
    private $query;

    private $searchBar;
    private $startDate;
    private $endDate;
    private $minmax;
    private $length;
    public $obj;

    private $error_handler = array();

    public function __construct($query, $searchBar = "", $startDate = "", $endDate = "", $minmax = "", $length = 0) {
        $this->query = $query;
        $this->searchBar = trim($searchBar);
        $this->startDate = $startDate;
        $this->endDate = $endDate;
        $this->minmax = $minmax;
        $this->length = $length;

        $this->db_host = "localhost";
        $this->db_user = "kodknatte_root";
        $this->db_pass = "xxx";
        $this->db_name = "kodknatte_derp";

        $this->link = false;
        $obj = new idna_convert(array('idn_version' => 2008));
    }

    public function decode_idn($domain) {
        return $obj->decode($domain);
    }

    public function handleError($error) {
        if(is_string($error)) {
            $this->error_handler[] = $error;
        }
    }

    public function showErrors() {
        if(is_array($this->error_handler)) {
            for($i=0;$i<count($this->error_handler);$i++) {
                echo $this->error_handler[$i]."<br />";
            }
        }
    }

    public function writeDate($date) {
        $dated = date("Y-m-d");
        if(date("Y-m-d") > $date)
            return "<span style='color:green;font-weight:bold;'>Ledig!</span>";
        elseif(date("Y-m-d") == $date)
            return "<span style='color:green;font-weight:bold;'>Idag!</span>";
        elseif(date("Y-m-d",strtotime("+30 days",strtotime($dated))) < $date)
            return "<span style='color:red'>".$date."</span>";
        else
            return $date;
    }

    public function printRecords() {
        if($this->doQuery() && count($this->error_handler) == 0) {
            $query = $this->doQuery();
            echo "<table style='width:300px'>";
            while($r = mysql_fetch_array($query)) {
                echo "<tr><td align='left'>".$this->decode_idn($r['name'])."</td><td align='right'>".$this->writeDate($r['date'])."</td></tr>";
            }
            echo "<table>";
        }
    }

    public function doQuery() {
        $this->link = mysql_connect($this->db_host, $this->db_user, $this->db_pass);
        if(!$this->link) {
            $this->handleError(mysql_error());
            return false;
        }
        else
        {
            $link_db = mysql_select_db($this->db_name, $this->link);
            if(!$link_db) {
                $this->handleError(mysql_error());
                return false;
            }
            else
            {
                $query = mysql_query($this->query);
                if(!$query) {
                    $this->handleError(mysql_error(). $this->query);
                    return false;
                }
                else
                    return $query;
            }
        }
    }

    public function buildQuery() {
        if($this->setKeywords() == false && count($this->error_handler) == 0) {
            if($this->setDate() == false) {
                $this->query = $this->query." date = '".date("Y-m-d")."'";
                return true;
            }
            else
            {
                $this->query = $this->query." ".$this->setDate();
                return true;
            }
        }
        elseif($this->setKeywords() && count($this->error_handler) == 0) {
            if($this->setDate()) {
                $this->query = $this->query." (".$this->setKeywords().") AND (".$this->setDate().")";
                return true;
            }
            else
            {
                $this->query = $this->query." ".$this->setKeywords();
                return true;
            }
        }
    }

    public function setKeywords() {
        if(strlen($this->searchBar) == 0) {
            return false;
        }
        else
        {
            $keywords = explode(" ", $this->searchBar);
            if(count($keywords) < 2) {
                if(strlen($keywords[0]) >= 2)
                    return "name LIKE '%".$keywords[0]."%'";
                else {
                    handleError("Sökordet måste vara minst 2 tecken långt");
                    return false;
                }
            }
            else
            {
                if(preg_match('/\s/', $this->searchBar)) {
                    $query = "";
                    for($i=0;$i<count($keywords);$i++) {
                        if(strlen($keywords[$i]) < 2) {
                            handleError("Sökord måste vara minst 2 tecken långa");
                            return false;
                        }
                        else
                        {
                            $query .= "name LIKE '%".trim($keywords[$i])."%' OR ";
                        }
                    }
                    return substr($query,0,(strlen($query)-3));
                }
            }
        }
    }

    public function setDate() {
        if(strlen(trim($this->startDate)) > 0 && strlen(trim($this->endDate)) > 0) {
            if($this->startDate < $this->endDate) {
                if(!preg_match("#^((19|20)?[0-9]{2}[- /.](0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01]))*$#", $this->startDate) && !preg_match("#^((19|20)?[0-9]{2}[- /.](0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01]))*$#", $this->endDate)) {
                    handleError("Datumen är i fel format");
                    return false;
                }
                else
                {
                    $query = "date >= '{$this->startDate}' AND date <= '{$this->endDate}'";
                    return $query;
                }
            }
            else
            {
                $this->handleError("Startdatumet kan inte vara mindre än slutdatumet");
                return false;
            }
        }
        elseif(strlen(trim($this->startDate)) > 0 && strlen(trim($this->endDate)) == 0) {
            if(!preg_match("#^((19|20)?[0-9]{2}[- /.](0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01]))*$#", $this->startDate)) {
                handleError("Start-datumet är i fel format");
                return false;
            }
            else
            {
                $query = "date >= '{$this->startDate}'";
                return $query;
            }
        }
        elseif(strlen(trim($this->startDate)) == 0 && strlen(trim($this->endDate)) > 0) {
            if(!preg_match("#^((19|20)?[0-9]{2}[- /.](0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01]))*$#", $this->startDate)) {
                handleError("Slut-datumet är i fel format");
                return false;
            }
            else
            {
                $query = "date <= '{$this->endDate}'";
                return $query;
            }
        }
        elseif(strlen(trim($this->startDate)) == 0 && strlen(trim($this->endDate)) == 0) {
            return false;
        }
    }
}
$obj = new Search("SELECT * FROM domains WHERE", "", "2011-11-02", "2011-11-09", "min", 6);
$obj->buildQuery();
$obj->printRecords();
$obj->showErrors();
?>