Untitled

mail@pastecode.io avatar
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