<?php
include_once 'includes/login.php';
if(empty($_POST['search'])) {
    include_once 'includes/forms/extended-search.php';
}

else {

    $search = $_POST['search'];
    $sql = "SELECT * FROM ";
    $tip = mysql_real_escape_string($search['tip']);
    if (strlen($tip)==0) $tip = null;
    switch($tip) {
        case 'article': case 'news': case 'journal':
            if($tip=='journal')
                $sql.="akula_journal WHERE ISNULL(tip)";
            else $sql.="akula_journal WHERE tip='$tip'";
            $queries = array_unique(preg_split("/[,. ]/", $search['title']));
            $q='';
            if(count($queries)>1) {
                    for($i=0; $i<count($queries); $i++) {
                        $q.=" (`title` LIKE '%$queries[$i]%'";
                        $q.=" OR annotation LIKE '%$queries[$i]%'";
                        $q.=" OR content LIKE '%$queries[$i]%')";
                    }
                    $sql.=" $q ";
                }
                else {
                        $sql.=" (`title` LIKE '%$queries[0]%'";
                        $sql.=" OR annotation LIKE '%$queries[0]%'";
                        $sql.=" OR content LIKE '%$queries[0]%')";
                    }
                $sql.=isset($search['author_id'])?' AND author_id=\''.$search['author_id'].'\'':'';
                $sql.=isset($search['theme_id'])?' AND theme_id=\''.$search['theme_id'].'\'':'';
                if(!empty($search['date1'])) {
                    $date1 = explode('-', $search['date1']);
                    $date1Unix = mktime(0,0,0,$date1[1],$date1[0],$date1[2]);
                    $sql.=' AND date>=\''.$date1Unix.'\' ';
                  }
                    if(!empty($search['date2'])) {
                    $date2 = explode('-', $search['date2']);
                    $date2Unix = mktime(0,0,0,$date2[1],$date2[0],$date2[2]);
                    $sql.=' AND date<=\''.$date2Unix.'\' ';
                  }

        break;
        case 'norm':
            $sql.="akula_documents WHERE ";
            $sql.=(isset($search['author_id'])?"author_id='".$search['author_id']."'":'');
                $queries = array_unique(preg_split("/[,. ]/", $search['title']));
            $q='';
            if(count($queries)>1) {
                    for($i=0; $i<count($queries); $i++) {
                        $q.=" OR (`title` LIKE '%$queries[$i]%'";
                        $q.=" OR annotation LIKE '%$queries[$i]%'";
                        $q.=" OR content LIKE '%$queries[$i]%')";
                    }
                    $sql.=" $q ";
                }
                else {
                        $sql.=" AND (`title` LIKE '%$queries[0]%'";
                        $sql.=" OR annotation LIKE '%$queries[0]%'";
                        $sql.=" OR content LIKE '%$queries[0]%')";
                    }

            break;
        default:
            $queries = array_unique(preg_split("/[,. ]/", $search['title']));
            $qj='';
            $qd='';
            if(count($queries)>1) {
                    for($i=0; $i<count($queries); $i++) {
                        $qj.=" j.`title` LIKE '%$queries[$i]%'";
                        $qj.=" OR j.annotation LIKE '%$queries[$i]%'";
                        $qj.=" OR j.content LIKE '%$queries[$i]%'";
                        $qd.=" d.`title` LIKE '%$queries[$i]%'";
                        $qd.=" OR d.annotation LIKE '%$queries[$i]%'";
                        $qd.=" OR d.content LIKE '%$queries[$i]%'";
                }
            }

                else {
                        $qj.=" j.`title` LIKE '%$queries[0]%'";
                        $qj.=" OR j.annotation LIKE '%$queries[0]%'";
                        $qj.=" OR j.content LIKE '%$queries[0]%'";
                        $qd.=" d.`title` LIKE '%$queries[0]%'";
                        $qd.=" OR d.annotation LIKE '%$queries[0]%'";
                        $qd.=" OR d.content LIKE '%$queries[0]%'";
                    }

            $sql.="akula_journal j, akula_documents d WHERE
            (j.author_id='".$search['author_id']."' OR d.author_id='".$search['author_id']."')
            AND ($qj OR $qd)";
            break;
    }
    echo $sql;
$contents = mysql_query($sql) or die (mysql_error());
}