Example #1
0
<?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];
if ($idrole < 2) {
    die("Nemate pravo pristupa");
}
function adresa($korisnicko_ime)
{
    require_once 'baza.class.php';
    if (!isset($baza)) {
        $baza = new baza();
    }
    $upit = "SELECT adresa,grad from korisnici where korisnicko_ime='{$korisnicko_ime}' LIMIT 1";
    $res = $baza->selectUpit($upit);
    $l = $res->fetch_assoc();
    $zarez = " , ";
    $temp = $l['adresa'] . $zarez . $l['grad'];
    return $temp;
}
function vrsta($idzahtjeva)
{
    require_once 'baza.class.php';
    if (!isset($baza)) {
Example #2
0
<?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
Example #3
0
    $upit = "SELECT * FROM mjesta";
    $podaci = $baza->selectUpit($upit);
    header("Content-Type:application/xml");
    echo '<?xml version="1.0" encoding="utf-8"?><mjesta>';
    while ($l = $podaci->fetch_assoc()) {
        echo "<mjesto id='" . $l['idmjesta'] . "' ime='" . $l['postanski_broj'] . " " . $l['naziv_mjesta'] . "'/>";
    }
    echo "</mjesta>";
    die;
}
if ($_GET['id'] == "provjeraKorisnika") {
    $korisnik = $_GET['korisnik'];
    $upit = "select count(*) as br from korisnici WHERE korisnicko_ime='{$korisnik}' ";
    $podaci = $baza->selectUpit($upit);
    echo "<korisnici>";
    $red = $podaci->fetch_array();
    echo "<korisnik>" . $red['br'] . "</korisnik>";
    echo "</korisnici>";
}
if ($_POST['act'] == "msg") {
    $kome = $_POST['kome'];
    $naslov = $_POST['naslov'];
    $poruka = $_POST['poruka'];
    require_once "mail.class.php";
    require_once "korisnici.class.php";
    $k = new korisnici();
    $m = new email();
    foreach (explode(",", $kome) as $uname) {
        $m->salji($k->email($uname), $naslov, $poruka);
    }
}
Example #4
0
<?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];
if ($idrole != 3) {
    die("Nemate pravo pristupa");
}
include "header.php";
include "izbornik.php";
require_once 'baza.class.php';
$baza = new baza();
?>




<div class="container" style="margin-top: 80px">
    <h3>Odaberi odgovarajuću tablicu</h3>
<select class="form-control" id="izbor">
  <option>Odaberi tablicu</option>
  <option value="korisnici">Korisnici</option>
  <option value="sluzbe">Kurirske službe</option>
  <option value="role">Role</option>
  <option value="mjesta">Mjesta</option>
Example #5
0
    require_once 'baza.class.php';
    $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'])) {