bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
/**
 * api/news.php
 *
 * @author Mitsutoshi Nakamura <mitsutoshi.nakamura.jp@gmail.com>
 */

require(BV_APPROOT . 'site/app/api/_core.php');

class news extends core
{
    public function __construct()
    {
        parent::__construct();
        // ini_set('display_errors', 1);
        // error_reporting(-1);
    }

public function pageIndex()
    {
        $this->biva->error('Invalid access');
    }

/**
     * /api/news/json/[target]/[limit]
     * @return void
     */
    public function pageJson()
    {
        $params =& $this->biva->params;

switch (true) {
            case !isset($params[0]) || !is_numeric($params[0]):
            case !isset($params[1]) || !is_numeric($params[1]):
                $this->biva->error('Invalid parameters');
                break;
        }

$target = $params[0];
        $limit = $params[1];

$sql_base = 'SELECT * FROM p_news WHERE %s ORDER BY date_fr DESC, id DESC LIMIT %d';

$where = array(
            "date_fr <= '" . date('Y-m-d H:i:s') . "'",
           'target & ' . $target,
           '!(status & 4)',
           'status & 1'
        );

$sql = sprintf($sql_base,
                       join(' AND ', $where),
                       $limit);

//echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);

while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }

// bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageFm_wedding()
    {
        $where = array("date_fr <= '" . date('Y-m-d H:i:s') . "'",
                       'target & 16384',
                       'status & 1');

$sql_base = "SELECT * FROM p_news WHERE %s ORDER BY date_fr DESC, id DESC";
        $sql = sprintf($sql_base, join(' AND ', $where));
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageCvstos()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 64
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            if (!$row['open_date_fr']) {
                $row['open_date_fr'] = '0000-00-00 00:00:00';
            }
            if (!$row['open_date_to']) {
                $row['open_date_to'] = '0000-00-00 00:00:00';
            }
            //bvPr($row); exit;
            $data[] = $row;
        }
        $this->outputHttpResponse($data);
    }

public function pagePierre()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 128
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageEuropean()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 256
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageBackes()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 512
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageMartin()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 1024
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageRodolphe()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 2048
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

public function pageBarthelay()
    {
        $today = date('Y-m-d H:i:s');
        $sql_base = <<<__SQL__
SELECT * FROM p_news
WHERE
        target & 4096
    AND date_fr <= '%s'
    AND status & 1
    AND (status & 4) = 0
ORDER BY
      date_fr DESC
    , id DESC
__SQL__;
        $sql = sprintf($sql_base, $today);
        //echo $sql; exit;
        $r_sql = $this->biva->Db->query($sql);
        while ($row = mysqli_fetch_assoc($r_sql)) {
            $data[] = $row;
        }
        //bvPr($data); exit;
        $this->outputHttpResponse($data);
    }

private function outputHttpResponse(&$data)
    {
        header('Access-Control-Allow-Origin: *');
        header('Content-Type: application/javascript; charset=utf-8');

if (isset($_GET['callback']) && $_GET['callback']) {
            // JSONP
            $callback = htmlspecialchars(strip_tags($_GET["callback"]));
            echo $callback . "(" . json_encode($data) . ")";
        } else {
            // JSON
            echo json_encode($data);
        }
    }
}