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";
}
public static function ubaci_vest($naslov, $link, $kategorija, $vreme, $descr, $id_novina, $automatic)
{
$db = new DB();
if (!Vest::da_li_postoji($naslov)) {
$db->set("INSERT INTO vesti (naslov,link,kategorija,vreme,descr,id_novina,automatic,datum_unosa) VALUES ('{$naslov}','{$link}','{$kategorija}','{$vreme}',\n '{$descr}', '{$id_novina}', '{$automatic}', NOW()) ");
if ($db->num == 1) {
return $db->last_id();
} else {
return 0;
}
}
return 0;
}
<?php
/**
* Created by PhpStorm.
* User: Stefan
* Date: 31.7.2015
* Time: 16:29
*/
require_once 'core/init.php';
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
}
if (isset($_GET['q']) && isset($_GET['kat'])) {
$id = sanitize($_GET['q']);
$kat = sanitize($_GET['kat']);
$db = new DB();
$v = new Vest($id);
if ($v->promeni_kategoriju($kat)) {
echo 'Kategorija je promenjena';
} else {
echo 'Doslo je do greske.';
}
} else {
echo 'Greska (GET)';
}
header("Location:index.php");
die;
} else {
$id_korisnika = $_SESSION["id_korisnika"];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>CMS</title>
<?php
require "includes/header.php";
?>
</head>
<body>
<div class="container">
<?php
if (isset($_GET["id"])) {
$vest = new Vest(sanitize($_GET["id"]));
$reci = $vest->get_words();
foreach ($reci as $rec) {
echo $rec;
echo "<br/>";
}
} else {
echo "Greska u GET id";
}
?>
</div>
</body>
</html>
</div>
<!-- kraj clanka -->
<?php
}
}
?>
<span class="label label-success">Vesti bez pronadjenog grada</span>
<?php
$niz_novina = Aplikacija::novine_za_auto();
foreach ($niz_novina as $nov) {
$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">
<?php
/**
* Created by PhpStorm.
* User: Stefan
* Date: 28.7.2015
* Time: 19:09
*/
require "core/init.php";
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
}
if (isset($_GET['q']) && isset($_GET['kat']) && isset($_GET['grad'])) {
$id = sanitize($_GET['q']);
$kat = sanitize($_GET['kat']);
$grad = sanitize($_GET['grad']);
$v = new Vest($id);
$v->postavi_grad($grad);
if ($v->topublic($kat) == 1) {
echo 'Vest je dodata.';
} else {
echo 'Greska tokom dodavanja vesti.';
}
} else {
echo 'Greska.';
}
<?php
/**
* Created by PhpStorm.
* User: Stefan
* Date: 9.8.2015
* Time: 16:07
*/
require "core/init.php";
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
}
if (isset($_GET['q']) && isset($_GET['grad']) && isset($_GET['kat'])) {
$id = sanitize($_GET['q']);
$grad = sanitize($_GET['grad']);
$kat = sanitize($_GET['kat']);
$v = new Vest($id);
$v->topublic($kat);
if ($v->odobri($kat, $grad) == 1) {
echo 'Vest je odobrena.';
} else {
echo 'Greska tokom odobravanja vesti.';
}
} else {
echo 'Greska u GET';
}
* User: Stefan
* Date: 28.7.2015
* Time: 20:10
*/
require "core/init.php";
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
}
if (isset($_GET['kontrola'])) {
$kontrola = sanitize($_GET['kontrola']);
switch ($kontrola) {
case "ukorpu":
if (isset($_GET["q"])) {
$id = sanitize($_GET["q"]);
$vest = new Vest($id);
if ($vest->ukorpu() == 1) {
echo "Vest je prebacena u korpu";
} else {
echo "Greska tokom prebacivanja u korpu";
}
} else {
echo "Nema q u GET";
}
break;
case "ispraznikorpu":
$br = Aplikacija::isprazni_korpu();
echo "Ukupno " . $br . "vesti izbrisano.";
break;
default:
echo "Greska u kontroli";
/**
* Created by PhpStorm.
* User: Stefan
* Date: 29.7.2015
* Time: 0:14
*/
require_once 'core/init.php';
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
} else {
$id_korisnika = $_SESSION["id_korisnika"];
}
if (isset($_GET['q'])) {
$id = sanitize($_GET['q']);
$v = new Vest($id);
$lat = $v->lat();
$lng = $v->lng();
$naziv = $v->grad();
} else {
die;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>CMS</title>
<?php
require "includes/header.php";
?>
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCqECZ8wTuVbGEVFw1o3TlwL4qhvMwYsn0"></script>
<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>
Ucitaj nove vesti
</div>
</div>
<a href="<?php
echo $nov->link_novina();
?>
" target="_blank" ><span class="label label-info"><?php
echo $nov->naziv();
?>
</span></a>
<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">
<?php
require "core/init.php";
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
}
if (isset($_GET["id_grada"]) && $_GET["id_vesti"]) {
$id_grada = sanitize($_GET["id_grada"]);
$id_vesti = sanitize($_GET["id_vesti"]);
$vest = new Vest($id_vesti);
if ($vest->postavi_grad($id_grada)) {
echo "Grad je promenjen.";
} else {
echo "GRESKA: db->num != 1";
}
} else {
echo "GRESKA: nisu lepo setovane GET var";
}
* 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);
<?php
/**
* Created by PhpStorm.
* User: Stefan
* Date: 29.7.2015
* Time: 20:03
*/
require_once "core/init.php";
if (!isset($_SESSION["id_korisnika"])) {
header("Location:index.php");
die;
} else {
$id_korisnika = $_SESSION["id_korisnika"];
}
if (isset($_GET["q"]) && isset($_GET["lat"]) && isset($_GET["lng"]) && isset($_GET["naziv"])) {
$id = sanitize($_GET["q"]);
$lat = sanitize($_GET["lat"]);
$lng = sanitize($_GET["lng"]);
$naziv = sanitize($_GET["naziv"]);
$n = new Vest($id);
$id_n_g = $n->dodaj_grad($lat, $lng, $naziv, 0);
if ($n->postavi_grad($id_n_g) == 1) {
echo "Lokacija promenjena";
} else {
echo "Greska tokom promene lokacije";
}
} else {
echo 'Doslo je do greske (GET)';
}
public function test()
{
$suma = 0;
$rss_array = $this->link_rss();
foreach ($rss_array as $rss) {
$raw_rss = file_get_contents($rss["link_rss"]);
$xml_rss = new SimpleXMLElement($raw_rss);
foreach ($xml_rss->channel->item as $news) {
$title = $news->title->__toString();
$desc = $news->description->__toString();
$link = $news->link->__toString();
$vr = $news->pubDate->__toString();
$vr = strtotime($vr);
$vreme = date("Y-m-d H:i:s", $vr);
$id = Vest::ubaci_vest($title, $link, 1, $vreme, $desc, $this->id_novina, 0);
$vest = new Vest($id);
$reci = $vest->get_words();
$suma = $suma + count($reci);
}
}
echo 'Broj reci = ' . $suma;
}
