<?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'];