Файловый менеджер

Файловый менеджер - Редактировать - /home/d46091/invoice.ecogenix.in/dashboard.php

Назад
<?php require_once('includes/connection.php'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $item_name = $_POST['item_name']; $unit = $_POST['unit']; $hsn = $_POST['hsn']; $cgst = $_POST['cgst']; $sgst = $_POST['sgst']; $igst = $_POST['igst']; $description = $_POST['description']; // $status = $_POST['status']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("INSERT INTO `item_master` (`item_name`, `unit`, `hsn`, `cgst`, `sgst`, `igst`, `description`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"); if ($stmt) { // Bind parameters: s = string, s = string, s = string $stmt->bind_param("ssssssss", $item_name, $unit, $hsn, $cgst, $sgst, $igst, $description, $created_at); // Execute the statement if ($stmt->execute()) { echo "<script> alert('Item added successfully!'); window.location.href = 'index.php'; </script>"; // Optionally redirect or clear form here } else { echo "Error executing query: " . $stmt->error; } $stmt->close(); } else { echo "Failed to prepare statement: " . $conn->error; } } require_once('includes/header.php'); ?> <!-- Content --> <div class="content"> <nav class="navbar navbar-expand-lg navbar-light bg-light mb-4"> <div class="container-fluid"> <button id="sidebarToggle" class="btn btn-outline-secondary d-md-none mr-auto"> <span class="navbar-toggler-icon"></span> </button> <a class="navbar-brand d-md-none" href="#">ECOGENIX</a> <div class="d-flex"> <!-- <input class="form-control me-2" type="search" placeholder="Search" aria-label="Search"> --> <!-- <button class="btn btn-outline-success" type="submit">Search</button> --> </div> </div> </nav> <div class="container-fluid"> <div class="row"> <div class="col-12"> <h2 class="mb-4">Item Dashboard</h2> </div> </div> <!-- <div class="row mb-4"> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-primary"> <div class="card-body"> <h5 class="card-title">Total Products</h5> <h3 class="card-text">-</h3> </div> </div> </div> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-success"> <div class="card-body"> <h5 class="card-title">Active Products</h5> <h3 class="card-text">-</h3> </div> </div> </div> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-warning"> <div class="card-body"> <h5 class="card-title">Low Stock</h5> <h3 class="card-text">-</h3> </div> </div> </div> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-danger"> <div class="card-body"> <h5 class="card-title">Out of Stock</h5> <h3 class="card-text">-</h3> </div> </div> </div> </div> --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-header d-flex justify-content-between align-items-center"> <span>Item's Inventory</span> <div> <!-- <button class="btn btn-sm btn-outline-primary">Export</button> --> <button class="btn btn-sm btn-primary" data-bs-toggle="modal" data-bs-target="#addItemModal">Add New</button> </div> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-striped table-hover"> <thead> <tr> <th>ID</th> <th>Item Name</th> <th>Unit</th> <th>HSN Code</th> <th>CGST(%)</th> <th>SGST(%)</th> <th>IGST(%)</th> <th>Special Note</th> <!-- <th>Status</th> --> <th>Actions</th> </tr> </thead> <tbody> <?php $query = "SELECT * FROM `item_master` ORDER BY `id` DESC"; $result = $conn->query($query); $index = 1; // Initialize row index if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { // Determine status label and badge class // $statusLabel = ($row['status'] == 1) ? 'Active' : 'Deactive'; // $badgeClass = ($row['status'] == 1) ? 'bg-success' : 'bg-danger'; // <td><span class='badge {$badgeClass}'>{$statusLabel}</span></td> echo "<tr> <td>" . $index++ . "</td> <td>" . htmlspecialchars($row['item_name']) . "</td> <td>" . htmlspecialchars($row['unit']) . "</td> <td>" . htmlspecialchars($row['hsn']) . "</td> <td>" . htmlspecialchars($row['cgst']) . "</td> <td>" . htmlspecialchars($row['sgst']) . "</td> <td>" . htmlspecialchars($row['igst']) . "</td> <td>" . (!empty($row['description']) ? htmlspecialchars($row['description']) : 'N/A') . "</td> <td> <a href='index_edit.php?id=" . $row['id'] . "' class='btn btn-sm btn-warning'> <i class='fa-solid fa-pen'></i> </a> </td> </tr>"; } } else { echo '<tr><td colspan="10" class="text-center">No records found.</td></tr>'; } ?> </tbody> </table> </div> <!-- <nav> <ul class="pagination justify-content-center"> <li class="page-item disabled"> <a class="page-link" href="#" tabindex="-1">Previous</a> </li> <li class="page-item active"><a class="page-link" href="#">1</a></li> <li class="page-item"><a class="page-link" href="#">2</a></li> <li class="page-item"><a class="page-link" href="#">3</a></li> <li class="page-item"> <a class="page-link" href="#">Next</a> </li> </ul> </nav> --> </div> </div> </div> </div> </div> </div> <!-- Add Item Modal --> <div class="modal fade" id="addItemModal" tabindex="-1" aria-labelledby="addItemModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <form action="" method="POST"> <!-- Replace with your actual form handler --> <div class="modal-header"> <h5 class="modal-title" id="addItemModalLabel">Add New Item</h5> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <div class="modal-body"> <!-- Item Name --> <div class="mb-3"> <label for="itemName" class="form-label">Item Name</label> <input type="text" class="form-control" id="itemName" name="item_name" required> </div> <!-- Unit --> <div class="mb-3"> <label for="unit" class="form-label">Unit</label> <input type="text" class="form-control" id="unit" name="unit" required> </div> <div class="mb-3"> <label for="hsn" class="form-label">HSN Code</label> <input type="text" class="form-control" id="hsn" name="hsn" required> </div> <div class="mb-3"> <label for="cgst" class="form-label">CGST</label> <input type="number" class="form-control" minlength="1" maxlength="2" id="cgst" name="cgst" required> </div> <div class="mb-3"> <label for="sgst" class="form-label">SGST</label> <input type="number" class="form-control" minlength="1" maxlength="2" id="sgst" name="sgst" required> </div> <div class="mb-3"> <label for="igst" class="form-label">IGST</label> <input type="number" class="form-control" minlength="1" maxlength="2" id="igst" name="igst" required> </div> <!-- Description --> <div class="mb-3"> <label for="description" class="form-label">Special Note (It Will be appear on Invoice)</label> <textarea type="text" class="form-control" id="description" name="description"></textarea> </div> <!-- Status --> <!-- <div class="mb-3"> <label for="status" class="form-label">Status</label> <select class="form-select" id="status" name="status" required> <option value="1">Active</option> <option value="0">Deactive</option> </select> </div> --> </div> <div class="modal-footer"> <button type="submit" class="btn btn-success">Save Item</button> <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button> </div> </form> </div> </div> </div> <?php require_once('includes/footer.php'); ?>

| ver. 1.4 | Github | . | PHP 8.1.32 | Генерация страницы: 0 | proxy | phpinfo | Настройка