<?php
session_start();
include 'config.php';

// Obrada brisanja artikla
if(isset($_GET['obrisi'])) {
    $id = intval($_GET['obrisi']);
    $stmt = $conn->prepare("DELETE FROM artikli WHERE ID = ?");
    $stmt->bind_param("i", $id);
    if($stmt->execute()) {
        $_SESSION['success_message'] = "Artikl uspješno obrisan!";
    } else {
        $_SESSION['error_message'] = "Greška pri brisanju artikla!";
    }
    header("Location: lista_artikala.php");
    exit();
}

// Dohvat svih artikala
$artikli = [];
$sql = "SELECT * FROM artikli ORDER BY Naziv_artikla ASC";
$result = $conn->query($sql);
if($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $artikli[] = $row;
    }
}
?>

<!DOCTYPE html>
<html lang="bs">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Lista artikala</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/1.13.6/css/dataTables.bootstrap5.min.css" rel="stylesheet">
    <style>
        .action-buttons .btn {
            margin: 2px;
            min-width: 80px;
        }
        .print-header {
            display: none;
        }
        @media print {
            .no-print, .dataTables_filter, .dataTables_length {
                display: none !important;
            }
            .print-header {
                display: block;
                text-align: center;
                margin-bottom: 20px;
            }
            table {
                width: 100% !important;
                font-size: 12px !important;
            }
        }
    </style>
</head>
<body class="bg-light">
    <div class="container mt-5">
        <div class="print-header">
            <h2>Lista artikala</h2>
            <p>Datum štampe: <?= date('d.m.Y H:i') ?></p>
        </div>

        <div class="card shadow">
            <div class="card-header d-flex justify-content-between align-items-center">
                <h4 class="m-0">Lista artikala</h4>
                <div class="no-print">
                    <a href="unos_artikla.php" class="btn btn-success btn-sm">
                        <i class="bi bi-plus-circle"></i> Novi artikl
                    </a>
                    <button onclick="window.print()" class="btn btn-secondary btn-sm">
                        <i class="bi bi-printer"></i> Štampaj
                    </button>
                </div>
            </div>

            <div class="card-body">
                <?php if(isset($_SESSION['success_message'])): ?>
                    <div class="alert alert-success"><?= $_SESSION['success_message'] ?></div>
                    <?php unset($_SESSION['success_message']); ?>
                <?php endif; ?>

                <?php if(isset($_SESSION['error_message'])): ?>
                    <div class="alert alert-danger"><?= $_SESSION['error_message'] ?></div>
                    <?php unset($_SESSION['error_message']); ?>
                <?php endif; ?>

                <table class="table table-striped" id="artikliTable">
                    <thead>
                        <tr>
                            <th>Šifra</th>
                            <th>Naziv</th>
                            <th>Jed. mjere</th>
                            <th>Cijena (KM)</th>
                            <th>Dobavljač</th>
                            <th class="no-print">Akcije</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach($artikli as $artikl): ?>
                            <tr>
                                <td><?= htmlspecialchars($artikl['Sifra_artikla']) ?></td>
                                <td><?= htmlspecialchars($artikl['Naziv_artikla']) ?></td>
                                <td><?= htmlspecialchars($artikl['Jed_mjere']) ?></td>
                                <td><?= number_format($artikl['Cijena'], 2) ?></td>
                                <td><?= htmlspecialchars($artikl['Dobavljac']) ?></td>
                                <td class="action-buttons no-print">
                                    <a href="izmjeni_artikl.php?id=<?= $artikl['ID'] ?>" 
                                       class="btn btn-warning btn-sm">
                                       <i class="bi bi-pencil"></i> Izmjeni
                                    </a>
                                    <a href="lista_artikala.php?obrisi=<?= $artikl['ID'] ?>" 
                                       class="btn btn-danger btn-sm" 
                                       onclick="return confirm('Da li ste sigurni?')">
                                       <i class="bi bi-trash"></i> Obriši
                                    </a>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/dataTables.bootstrap5.min.js"></script>
    <script>
        $(document).ready(function() {
            $('#artikliTable').DataTable({
                language: {
                    url: '//cdn.datatables.net/plug-ins/1.13.6/i18n/bs.json'
                },
                columnDefs: [
                    { orderable: false, targets: 5 }
                ]
            });
        });
    </script>
</body>
</html>
<?php $conn->close(); ?>