public static function auto_vesti()
{
$brojac = 0;
$novine = Aplikacija::novine_za_auto();
echo "Izvestaj za auto dodavanje vesti.\r\n";
echo "Vreme: " . date("G:i d(D). m. Y.");
foreach ($novine as $nov) {
$id = $nov["id_novina"];
$n = new Novina($id);
echo "\r\nNovine: " . $n->naziv() . "\r\n";
$brojac = $brojac + $n->ucitaj_vesti(1);
$rez = $n->prikazi_vesti_neobjavljene(1, "10 MINUTE", "datum_unosa");
$bool = false;
foreach ($rez as $r) {
$vest = new Vest($r["id_vesti"]);
if ($vest->grad() != "") {
$bool = true;
$vest->topublic(1);
echo "Grad: " . $vest->grad() . ". Naslov: " . $vest->naslov() . "\r\n";
}
}
if (!$bool) {
echo "\r\nNema dodatih vesti vesti";
}
}
echo "\r\nUkupno " . $brojac . " vesti ucitanih";
}
$id_novina = $nov["id_novina"];
$novina = new Novina($id_novina);
$rez = $novina->prikazi_vesti_neobjavljene(1);
foreach ($rez as $r) {
$id_vesti = $r["id_vesti"];
$v = new Vest($id_vesti);
?>
<!-- pocetak clanak -->
<div class="panel panel-default">
<div class="panel-heading">
<h2 class="panel-title" style="display:inline;">
<a href="<?php
echo $v->link();
?>
"><?php
echo $v->naslov();
?>
</a>
</h2>
<div class="pull-right">
<div class="btn-group">
<div class="btn btn-default" triger="odobri_vest" role="stara" id="<?php
echo $v->id_vesti;
?>
">
Odobri vest
</div>
<div class="btn btn-default" triger="obrisi_vest" role="stara" id="<?php
echo $v->id_vesti;
?>
<p class="date" id="nove-vesti"></p>
<?php
$res = $nov->prikazi_vesti_neobjavljene(0);
foreach ($res as $r) {
$id = $r["id_vesti"];
$n_vest = new Vest($id);
?>
<!-- pocetak clanak -->
<div class="panel panel-default">
<div class="panel-heading">
<h2 class="panel-title" style="display:inline;">
<a href="<?php
echo $n_vest->link();
?>
"> <?php
echo $n_vest->naslov();
?>
</a>
</h2>
<div class="pull-right">
<div class="btn-group">
<div class="btn btn-default" triger="dodaj_vest" role="nova" id="<?php
echo $n_vest->id_vesti;
?>
">
Dodaj vest
</div>
<div class="btn btn-default" triger="obrisi_vest" role="nova" id="<?php
echo $n_vest->id_vesti;
?>
<marquee scrollamount="5">
<?php
$db = new DB();
$db->get("SELECT id_vesti FROM vesti WHERE obrisano=0 AND datum_publikovanja IS NOT NULL AND obrisano=0 AND vreme >= DATE(NOW() - INTERVAL 1 DAY) ORDER BY datum_publikovanja DESC ");
//$db->get("SELECT id_vesti FROM vesti WHERE datum_publikovanja IS NOT NULL AND obrisano=0");
$rez = $db->res;
foreach ($rez as $r) {
$id_v = $r["id_vesti"];
$v = new Vest($id_v);
echo '<span class="mali-logo"></span><a class="fancy" href="' . $v->link() . '"><span style="color: #D54401">' . $v->kategorija() . ' </span> ' . $v->naslov() . '</a>';
}
?>
</marquee>
* Date: 12.6.2015
* Time: 13:20
*/
$vreme = '1';
$kat = '0';
if (isset($_POST["filter"]) && $_POST["filter"] != "") {
$filter = json_decode($_POST["filter"], true);
$vreme = $filter['vreme'];
$kat = $filter['kategorije'];
}
if ($kat == '0') {
$katsql = "";
} else {
$katsql = "AND kategorija='{$kat}'";
}
$db = new DB();
$sql = "SELECT id_vesti FROM vesti WHERE obrisano=0 AND datum_publikovanja IS NOT NULL AND DATE(`vreme`) >= DATE(NOW() - INTERVAL '{$vreme}' DAY)" . $katsql;
$db->get($sql);
$data = array();
$i = 0;
$rez = $db->res;
foreach ($rez as $r) {
$vest = new Vest($r['id_vesti']);
$data[$i]['tittle'] = $vest->naslov();
$data[$i]['link'] = $vest->link();
$data[$i]['lat'] = $vest->lat();
$data[$i]['lng'] = $vest->lng();
$data[$i]['time'] = $vest->vreme();
$i++;
}
echo json_encode($data, JSON_PRETTY_PRINT);
