<?php

class Ecrit
{
    const ONLINE = 1;
    const OFFLINE = 0;

    const NO_CACHE = 0;
    const SESSION_CACHE = 1;

    private $use_cache = 0;

    static public function getLastURI($journal)
    {
        $res = DB::aQuery('SELECT uri FROM ecrits WHERE journal = \''.DB::esc($journal).'\' AND status = 1
            ORDER BY date DESC LIMIT 1;',
            false, DB::FETCH_NUM);

        if (empty($res[0][0]))
            return false;

        return $res[0][0];
    }

    static public function listMonths($journal)
    {
        $out = array();
        $res = DB::aQuery('SELECT mois  FROM ecrits WHERE journal="'.DB::esc($journal).'"
            GROUP BY mois ORDER BY mois;', false, DB::FETCH_NUM);

        foreach ($res as $row)
        {
            $out[] = $row[0];
        }

        return $out;
    }

    static public function getLastMonth($journal)
    {
        $res = DB::aQuery('SELECT mois FROM ecrits WHERE journal="'.DB::esc($journal).'"
            ORDER BY mois DESC LIMIT 1;', false, DB::FETCH_NUM);

        if (!empty($res[0][0]))
            return $res[0][0];

        return false;
    }

    static public function listForMonth($journal, $month)
    {
        return DB::aQuery('SELECT * FROM ecrits WHERE journal = "'.DB::esc($journal).'"
            AND mois = "'.(int)$month.'" ORDER BY date;', false, DB::FETCH_ASSOC);
    }

    static public function addNew($journal, $title, $text, $status = self::OFFLINE, $date=false, $uri=false)
    {
        if (!trim($title))
            throw new userException('Le titre est obligatoire');

        if (!trim($text))
            throw new userException('Le texte est obligatoire');

        if (!$date)
            $date = time();

        if (!$uri)
            $uri = utils::makeURI($title);
        else
            $uri = utils::makeURI($uri);

        if (!trim($uri))
        {
            $uri = date('Y-m-d-H-i-s', $date);
        }

        $month = date('Ym', $date);

        DB::startMultipleQueries();
        DB::uQuery('INSERT INTO ecrits (journal, titre, date, status, ip, mois, uri)
            VALUES ("'.DB::esc($journal).'", "'.DB::esc($title).'", "'.(int)$date.'", "'.(int)(bool)$status.'",
            "'.DB::esc($_SERVER['REMOTE_ADDR']).'", "'.$month.'", "'.DB::esc($uri).'");');

        $id = DB::getInsertId();

        $exist = DB::aQuery('SELECT 1 FROM ecrits WHERE journal="'.DB::esc($journal).'"
            AND uri="'.DB::esc($uri).'" AND id != "'.(int)$id.'";');

        if (!empty($exist[0]))
        {
            $uri = utils::id2url($id) . '-' . $uri;
            DB::uQuery('UPDATE ecrits SET uri = "'.DB::esc($uri).'" WHERE id="'.$id.'";');
        }

        $text = str_replace("\r", '', $text);

        DB::uQuery('UPDATE journaux SET dernier = '.time().' WHERE id = "'.DB::esc($journal).'";');
        DB::uQuery('INSERT INTO ecrits_html (id, texte) VALUES ("'.(int)$id.'", "'.DB::esc($text).'");');
        DB::endMultipleQueries();

        return $id;
    }

    static public function edit($journal, $id, $title, $text, $status, $date, $uri)
    {
        if (!trim($title))
            throw new userException('Le titre est obligatoire');

        if (!trim($text))
            throw new userException('Le texte est obligatoire');

        $uri = utils::makeURI($uri);

        if (!trim($uri))
        {
            $uri = date('Y-m-d-H-i-s', $date);
        }

        $exist = DB::aQuery('SELECT 1 FROM ecrits WHERE journal="'.DB::esc($journal).'"
            AND uri="'.DB::esc($uri).'" AND id != "'.(int)$id.'";');

        if (!empty($exist[0]))
        {
            throw new userException('URI invalide');
        }

        $month = date('Ym', $date);
        $text = str_replace("\r", '', $text);

        DB::startMultipleQueries();
        DB::uQuery('UPDATE ecrits SET titre = "'.DB::esc($title).'", date = "'.(int)$date.'",
            status = "'.(int)(bool)$status.'", mois = "'.(int)$month.'", uri = "'.DB::esc($uri).'"
            WHERE journal = "'.DB::esc($journal).'" AND id = "'.(int)$id.'";');
        DB::uQuery('UPDATE ecrits_html SET texte = "'.DB::esc($text).'" WHERE id = "'.(int)$id.'";');
        DB::endMultipleQueries();

        return true;
    }

    static public function get($journal, $id)
    {
        $res = DB::aQuery('SELECT e.*, h.texte FROM ecrits AS e INNER JOIN ecrits_html AS h ON e.id = h.id
            WHERE e.journal = "'.DB::esc($journal).'" AND e.id = \''.(int)$id.'\' LIMIT 1;', false, DB::FETCH_ASSOC);

        if (empty($res[0]))
            return false;

        return $res[0];
    }

    static public function delete($journal, $id)
    {
        return DB::uQuery('DELETE ecrits, ecrits_html
            FROM ecrits, ecrits_html
            WHERE ecrits.journal = "'.DB::esc($journal).'"
                AND ecrits.id = "'.(int)$id.'"
                AND ecrits.id = ecrits_html.id;');
    }

    static public function search($journal, $query, $online_only = true)
    {
        $res = DB::aQuery('SELECT e.*, h.texte FROM ecrits AS e INNER JOIN ecrits_html AS h ON e.id = h.id
            WHERE e.journal = "'.DB::esc($journal).'" '.
            ($online_only ? 'AND e.status = '.self::ONLINE : '').
            ' AND (e.titre LIKE "%'.DB::esc($query).'%" OR MATCH(h.texte) AGAINST("'.DB::esc($query).'")) LIMIT 100;', false, DB::FETCH_ASSOC);

        return $res;
    }

    static public function getNext($journal, $id)
    {
        $res = DB::aQuery('SELECT * FROM ecrits 
            WHERE journal = "'.DB::esc($journal).'"
                AND date > (SELECT date FROM ecrits WHERE id = '.(int)$id.') 
            ORDER BY date ASC LIMIT 1;', false, DB::FETCH_ASSOC);

        if (empty($res[0]))
            return false;

        return $res[0];
    }

    static public function getPrev($journal, $id)
    {
        $res = DB::aQuery('SELECT * FROM ecrits 
            WHERE journal = "'.DB::esc($journal).'"
                AND date < (SELECT date FROM ecrits WHERE id = '.(int)$id.') 
            ORDER BY date DESC LIMIT 1;', false, DB::FETCH_ASSOC);

        if (empty($res[0]))
            return false;

        return $res[0];
    }
}

?>