Untitled

userList.jsp
mail@pastecode.io avatar
unknown
plain_text
a year ago
12 kB
1
Indexable
Never
<%-- 
    Document   : OrderList
    Created on : Oct 17, 2023, 4:39:35 PM
    Author     : HP
--%>

<%@page import="DAOs.AdminDAOs"%>
<%@page import="java.sql.ResultSet"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Navbar với Bootstrap</title>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        <link rel="stylesheet" href="<%out.print(request.getContextPath());%>/public/assets/css/adminOrderList.css">
        <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
        <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.3/dist/umd/popper.min.js"></script>
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        <link rel="stylesheet" href="node_modules/bootstrap-social/bootstrap-social.css">
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css">

    </head>
    <body>

        <div class="container-fluid myheader">
            <div class="row">
                <div class="col-md-2">
                    <div class="row mt-2">
                        <div class="col-md-3 ">
                            <img src="<%out.print(request.getContextPath());%>/public/assets/imgs/Logo.png" alt="" style="height: 50px; width: 50px;" />
                        </div>
                        <div class="col-md-9 py-3">ADMIN</div>
                    </div>
                </div>

                <div class="col-md-8 mt-1 shope-inform">
                    <div class="row">
                        <div class="col-md-3 py-3 inform" style="border-radius: 10px; border: 1px solid black;">PRODUCT</div>
                        <div class="col-md-3 py-3 inform" style="border-radius: 10px; border: 1px solid black;">PRODUCT</div>
                        <div class="col-md-3 py-3 inform" style="border-radius: 10px; border: 1px solid black;">PRODUCT</div>
                        <div class="col-md-3 py-3 inform" style="border-radius: 10px; border: 1px solid black;">PRODUCT</div>
                    </div>
                </div>

                <div class="col-md-2">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="row">
                                <div class="col-md-4 py-1">
                                    <i class="fa-solid fa-user fa-xl mt-md-4"></i>
                                </div>
                                <div class="col-md-8 py-3">
                                    <a href="link-to-profile-page">Name</a>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="row">
                                <div class="col-md-4 py-1">
                                    <i class="fa-solid fa-right-from-bracket fa-xl mt-md-4"></i>
                                </div>
                                <div class="col-md-8 py-3">
                                    <a href="link-to-logout-page">Logout</a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="container-fluid">
            <div class="row">
                <div class="col-md-2 list-group" style="background-color: grey">
                    <div class="row row-cols-1 px-md-4">
                        <div class="row-3">
                            <div class="col-md-3 home">
                                <i class="fa-solid fa-house fa-xl" style="padding-top: 18px;"></i>
                            </div>
                            <div class="col-md-9 py-2">
                                <a href="link-to-home-page">Home</a>
                            </div>
                        </div>
                        <div class="row-3">
                            <div class="col-md-3 user">
                                <i class="fa-solid fa-user fa-xl" style="padding-top: 18px; padding-left: 3px;"></i>
                            </div>
                            <div class="col-md-9 py-2">
                                <a href="/AdminController/userList">User List</a>
                            </div>
                        </div>
                        <div class="row-3">
                            <div class="col-md-3 order">
                                <i class="fa-solid fa-cart-shopping fa-xl" style="padding-top: 18px;"></i>
                            </div>
                            <div class="col-md-9 py-2">
                                <a href="/AdminController/orderList">Order List</a>
                            </div>
                        </div>
                        <div class="row-3">
                            <div class="col-md-3 import">
                                <i class="fa-solid fa-industry fa-xl" style="padding-top: 18px; padding-left: 2px;"></i>
                            </div class="import">
                            <div class="col-md-9 py-2">
                                <a href="link-to-import-source">Import Source</a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-md-10">
                    <div class="add-search-feature">
                        <div class="row add-search-control">
                            <div class="col-md-8 d-flex">
                                <a class="mb-1" style="border-radius: 10px; display: inline-block; padding: 10px 20px; background-color: #007bff; color: #fff; text-decoration: none;" href="/AdminController/addNewUser">Add New+</a>
                                <div class=" show-proper mt-2">
                                    <p class="show-proper-p">Show</p>
                                    <div class="show-proper-select">
                                        <select id="quantity" style="border-radius: 10px; border: 2px solid black;">
                                            <option value="1">1</option>
                                            <option value="2">2</option>
                                            <option value="3">3</option>
                                            <option value="4">4</option>
                                            <option value="5">5</option>
                                            <option value="6">6</option>
                                            <option value="7">7</option>
                                            <option value="8">8</option>
                                            <option value="9">9</option>
                                            <option value="10">10</option>
                                        </select>
                                    </div>
                                    <p class="show-proper-p">Order</p>
                                </div>
                            </div>
                            <div class="col-md-4 search-box">
                                <div class="text-right">
                                    <input style="border-radius: 10px; border: 2px solid black;" type="text"
                                           class="form-search" id="tableSearch" placeholder="Search" />
                                    <!--<input type="text" id="" placeholder="Tìm kiếm...">-->
                                    <button id="search-button" style="border-radius: 10px;"><span><i
                                                class="fa-solid fa-magnifying-glass"></i></span></button>
                                </div>
                            </div>
                        </div>
                    </div>


                    <div class="table-content">
                        <table class="table" id="product-table">
                            <!-- Header của bảng -->
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Avatar</th>
                                    <th>Username</th>
                                    <th>Password</th>
                                    <th>Email</th>
                                    <th>FirstName</th>                      
                                    <th>LastName</th>
                                    <th>Gender</th>
                                    <th>Birthday</th>
                                    <th>Role</th>
                                    <th>Active</th>
                                </tr>
                            </thead>
                            <tbody id="table-body">
                                <!-- Bảng dữ liệu sẽ được thêm vào đây -->
                                <!-- tr gốc -->            
                                <!-- Các hàng dữ liệu khác -->
                                <%
                                    AdminDAOs dao = new AdminDAOs();
                                    ResultSet rs = dao.GetAllUser();
                                    while (rs.next()) {
                                %>
                                <tr>                                   
                                    <td><%= rs.getInt("Account_ID")%></td>
                                    <td><%= rs.getString("avatar")%></td>
                                    <td><%= rs.getString("username")%></td>
                                    <td style="max-width: 100px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis;"><%= rs.getString("password")%></td>
                                    <td style="max-width: 100px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis;"><%= rs.getString("email")%></td>
                                    <td><%= rs.getString("firstName")%></td>
                                    <td><%= rs.getString("lastName")%></td>
                                    <td><%= rs.getString("gender")%></td>
                                    <td><%= rs.getDate("birthday")%></td>
                                    <td><%= rs.getInt("role")%></td>
                                    <td class="d-flex">                                 
                                        <a class="fa-solid fa-trash fa-xl mr-2 mt-2 " href="/AdminController/deleteUser/<%= rs.getInt("Account_ID")%>" style="color: black;"></a>
                                        <a class="fa-solid fa-pen-to-square fa-xl mt-2" href="/AdminController/updateUser/<%= rs.getInt("Account_ID")%>" style="color: black;"></a>
                                    </td>
                                    <!-- Ô trống -->
                                </tr>
                                <%
                                    }
                                %>
                            </tbody>
                        </table>
                    </div>


                    <footer>
                        <div class="pagination" style="display: flex; justify-content: center; align-items: center;">
                            <button id="prevPage" style="margin-right: 10px; border-radius: 8px; border: 1px solid black;">Previous</button>
                            <div class="page-numbers" style="display: flex; align-items: center;">
                                <button class="page-number">1</button>
                                <button class="page-number">2</button>
                                <button class="page-number">3</button>
                            </div>
                            <button id="nextPage" style="margin-left: 10px; border-radius: 8px; border: 1px solid black;">Next</button>
                        </div>
                    </footer>
                </div>
            </div>
        </div>
        <script src="<%out.print(request.getContextPath());%>/public/assets/js/adminOrderList.js"></script>
    </body>
</html>