Untitled
unknown
plain_text
14 days ago
7.7 kB
13
Indexable
Never
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" type="text/css" href="../styles/styles.css"> <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script> <title>RITS | Item data</title> <style> .content-container { margin-left: 290px; } @media (max-width: 1000px) { .content-container { padding-left: 0; margin: 0; } } </style> </head> <body class="content-container"> <?php include('../templates/_navbar.php'); include('../templates/sidebar.php'); include('../db/db_connection.php'); $itemsPerPage = 8; if (isset($_GET['page']) && is_numeric($_GET['page'])) { $currentPage = intval($_GET['page']); } else { $currentPage = 1; } $offset = ($currentPage - 1) * $itemsPerPage; if (isset($_GET['search'])) { $search = $_GET['search']; $search = str_replace("'", '', $search); $strsql = "SELECT * FROM ViewItemDetails WHERE control_number LIKE '%$search%' OR item_serial LIKE '%$search%' OR item_name LIKE '%$search%' OR cat_name LIKE '%$search%' OR item_Remarks LIKE'%$search%' OR item_availability LIKE '$search%' ORDER BY item_id OFFSET $offset ROWS FETCH NEXT $itemsPerPage ROWS ONLY"; } else { $strsql = "SELECT * FROM ViewItemDetails ORDER BY item_id OFFSET $offset ROWS FETCH NEXT $itemsPerPage ROWS ONLY"; } $query = sqlsrv_query($conn, $strsql); if (sqlsrv_has_rows($query)) { // Rows were found, so you can display the results //while ($row = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)) { // Display the results here //} } else { // No data found $strsql = "SELECT * FROM ViewItemDetails ORDER BY item_id OFFSET $offset ROWS FETCH NEXT $itemsPerPage ROWS ONLY"; $query = sqlsrv_query($conn, $strsql); } if (!$query) { die("Query failed: " . sqlsrv_errors()); } $totalItemsQuery = sqlsrv_query($conn, "SELECT COUNT(*) as total FROM ViewItemDetails"); $totalItems = sqlsrv_fetch_array($totalItemsQuery, SQLSRV_FETCH_ASSOC)['total']; $totalPages = ceil($totalItems / $itemsPerPage); ?> <div> <div style="margin-left: 20px; margin-right: 20px; display: flex; justify-content: space-between; align-items: center;"> <h4 href="#" style="width: 150px; margin: 0;">Items</h4> <div class="right" style="display: flex; align-items: center;"> <form action="../pages/items.php" method="get" style="display: flex; align-items: center;"> <input type="text" name="search" id="searchBox" placeholder="Search..." style="width: 300px; margin-right: 10px;" oninput="validateInput(this);"> <button class="waves-effect green-text btn-flat" type="submit"> <i class="material-icons">search</i> </button> <button class="waves-effect green-text btn-flat" type="button" onclick="refreshPage()"> <i class="material-icons">refresh</i> </button> </form> <a class="waves-effect green darken-4 btn-large" href="../pages/itemAdd.php" style="margin: 0;">Add Items</a> </div> </div> <div class="row"> <div class="col s12"> <table class="striped highlight responsive-table"> <thead> <tr> <th>Item ID</th> <th>Control #</th> <th>Serial #</th> <th>Item Name</th> <th>Category</th> <th>Remarks</th> <th>Availability</th> <th>Actions</th> </tr> </thead> <tbody> <?php while ($row = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)) { echo "<tr>"; echo "<td>" . $row['item_id'] . "</td>"; echo "<td>" . $row['control_number'] . "</td>"; echo "<td>" . $row['item_serial'] . "</td>"; echo "<td>" . $row['item_name'] . "</td>"; echo "<td>" . $row['cat_name'] . "</td>"; echo "<td>" . $row['item_Remarks'] . "</td>"; $statusAvailability = $row['item_availability'] === 'Not Available' ? 'red-text' : 'green-text'; echo "<td class='$statusAvailability'>" . $row['item_availability'] . "</td>"; if ($statusAvailability === 'Not Available') { echo "<td class = right> <a class='btn light-blue accent-4 waves-effect' href='ViewItemDetails.php?id=" . $row['control_number'] . "'>View Details</a> </td>"; echo "</tr>"; } else { echo "<td class = right> <a class='btn waves-effect' href='../pages/itemEdit.php?id=" . $row['control_number'] . "'>Edit</a> <a class='btn light-blue accent-4 waves-effect' href='../pages/ViewItemDetails.php?id=" . $row['control_number'] . "'>View Details</a> </td>"; echo "</tr>"; } } ?> </tbody> </table> <?php sqlsrv_close($conn); ?> </div> </div> <div class="row"> <ul class="pagination center"> <?php if ($totalPages > 1) { if ($currentPage > 1) { echo "<li class='waves-effect'><a href='../pages/items.php?page=" . ($currentPage - 1) . "'><i class='material-icons'>chevron_left</i></a></li>"; } for ($i = 1; $i <= $totalPages; $i++) { $activeClass = ($i === $currentPage) ? 'active' : ''; echo "<li class='waves-effect $activeClass'><a href='../pages/items.php?page=$i'>$i</a></li>"; } if ($currentPage < $totalPages) { echo "<li class='waves-effect'><a href='../pages/items.php?page=" . ($currentPage + 1) . "'><i class='material-icons'>chevron_right</i></a></li>"; } } ?> </ul> </div> </div> <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/js/materialize.min.js"></script> <script> function refreshPage() { window.location.href = '../pages/items.php'; } function validateInput(input) { input.value = input.value.replace(/'/g, ''); } </script> </body> <?php include('../templates/footer.php'); ?> </html>
Leave a Comment