<?php
session_start();
if (empty($_SESSION['korisnicko_ime'])) {
die("Niste logirani");
}
require_once "korisnici.class.php";
$k = new korisnici();
$tmp = $k->uloga($_SESSION['korisnicko_ime']);
$rola = $tmp[1];
$idrole = $tmp[0];
$idkurirske = $k->ksid($_SESSION['korisnicko_ime']);
if ($idrole < 2) {
die("Nemate pravo pristupa");
}
if ($_POST['pdf'] == 1) {
$stat = $_POST['pdf'];
require 'mysqlpdf.php';
class PDF extends PDF_MySQL_Table
{
function Header()
{
//Title
$this->SetFont('Arial', '', 18);
$this->Cell(0, 6, 'Statistika korisnika po broju poslanih paketa', 0, 1, 'C');
$this->Ln(10);
//Ensure table header is output
parent::Header();
}
}
//Connect to database
{
require_once 'baza.class.php';
if (!isset($baza)) {
$baza = new baza();
}
$upit = "SELECT *from tip_dostave where idtip_dostave={$idzahtjeva} LIMIT 1";
$res = $baza->selectUpit($upit);
$l = $res->fetch_assoc();
$temp = $l['naziv'];
return $temp;
}
include "header.php";
include "izbornik.php";
require_once 'baza.class.php';
$baza = new baza();
$tmp1 = $k->ksid($_SESSION['korisnicko_ime']);
if ($tmp1 > 0) {
$upit = "SELECT * FROM zahtjevi WHERE obradjen=0 AND idkurirske_sluzbe='{$tmp1}'";
$podaci = $baza->selectUpit($upit);
} else {
$upit = "SELECT * FROM zahtjevi WHERE obradjen=0";
$podaci = $baza->selectUpit($upit);
}
?>
<div class="container">
<h3>Neobrađeni zahtjevi</h3>
<br>
<table id="popis" class="table table-responsive">
<thead>
<tr>
$baza = new baza();
$out = "";
$upit = "SELECT * FROM rute_has_mjesta rhm LEFT JOIN mjesta m ON (rhm.mjesta_idmjesta=m.idmjesta) WHERE rhm.rute_idrute={$id} ORDER BY rhm.redosljed ASC";
$podaci = $baza->selectUpit($upit);
$tmp = array();
while ($l = $podaci->fetch_array()) {
$tmp[] = $l['naziv_mjesta'];
}
if (count($tmp) > 0) {
$out = implode(' - ', $tmp);
}
return $out;
}
require_once "korisnici.class.php";
$k = new korisnici();
$idks = $k->ksid($_SESSION['korisnicko_ime']);
if (!empty($idks) && !empty($_POST['idrute1'])) {
$brisi = $_POST['idrute1'];
$upit = "DELETE FROM rute_has_mjesta where rute_idrute='{$brisi}'";
$podaci = $baza->selectUpit($upit);
$upit = "DELETE FROM rute WHERE idrute='{$brisi}' LIMIT 1;";
$podaci = $baza->selectUpit($upit);
$poruka = '<div class="alert alert-success">Uspješno izbrisana kurirska služba</div>';
}
if (!empty($idks) && !empty($_POST['unos'])) {
$upit = "INSERT INTO rute (`vrijeme_trajanja`,`kilometraza`,`tip_dostave`,`idkurirske_sluzbe`) VALUES ({$_POST['vrijeme_trajanja']},{$_POST['km']},{$_POST['tip_dostave']},{$idks});";
$podaci = $baza->selectUpit($upit);
$poruka = '<div class="alert alert-success">Uspješno dodana kurirska služba</div>';
}
if (empty($idks) && !empty($_POST['idrute1']) && !empty($_POST['id_sluzbe'])) {
$id_sluzbe = $_POST['id_sluzbe'];
