<?php
// session_name("admin_session");
session_start();
if (!$_SESSION["username"]) {

    header("Location:index.php");
}

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">

    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>DROP SHIPPING PANEL : ADMIN</title>

    <!-- Google Font: Source Sans Pro -->
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">

    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/2.1.2/sweetalert.min.css">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/2.1.2/sweetalert.min.js"></script>
    <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
    <!-- Tempusdominus Bootstrap 4 -->
    <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
    <!-- iCheck -->
    <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css">
    <!-- JQVMap -->
    <link rel="stylesheet" href="plugins/jqvmap/jqvmap.min.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="dist/css/adminlte.min.css">
    <!-- overlayScrollbars -->
    <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css">
    <!-- Daterange picker -->
    <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">
    <!-- select option -->
    <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css" rel="stylesheet">


    <!-- summernote -->
    <link rel="stylesheet" href="plugins/summernote/summernote-bs4.min.css">
    <!-- DataTables -->
    <link rel="stylesheet" href="plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
    <link rel="stylesheet" href="plugins/datatables-buttons/css/buttons.bootstrap4.min.css">

    <style>
        .blink {
            animation: blinker 1.5s linear infinite;
            color: white;
            font-family: sans-serif;
        }

        @keyframes blinker {
            50% {
                opacity: 0;
            }
        }

        .sidebar-dark-primary .nav-sidebar>.nav-item>.nav-link.active,
        .sidebar-light-primary .nav-sidebar>.nav-item>.nav-link.active {
            background-color: #6c757d;
            color: #fff;
        }

        [class*=sidebar-dark-] .nav-treeview>.nav-item>.nav-link.active,
        [class*=sidebar-dark-] .nav-treeview>.nav-item>.nav-link.active:focus,
        [class*=sidebar-dark-] .nav-treeview>.nav-item>.nav-link.active:hover {
            background-color: #6c757d;
            color: #ffffff;
        }

        .checkbox-round {
            width: 1.1em;
            height: 1.1em;
            background-color: white;
            border-radius: 50%;
            vertical-align: middle;
            border: 1px solid #ddd;
            appearance: none;
            -webkit-appearance: none;
            outline: none;
            cursor: pointer;
        }

        .checkbox-round:checked {
            background-color: gray;
        }

        #google_translate_element select option {
            background-color: #343a40;
        }

        #google_translate_element select.goog-te-combo {
            width: 100%;
            height: 35px;
            border-radius: 4px;
            padding: 5px;
            background: transparent;
            color: #fcfcfc;
        }

        .goog-te-gadget .goog-te-combo {
            margin: 4px 0;
        }

        .sidebar-footer {
            background-color: #343a40;
            text-align: center;
            bottom: 0;
            margin-top: 35px;
            left: 0;
            width: 250px;
            display: block;
            font-size: 1.25rem;
            line-height: 1.5;
            padding: 0.81rem;
            transition: width .3s ease-in-out;
            white-space: nowrap;
        }


        .layout-fixed .wrapper .sidebar {
            height: calc(100vh - (10.10rem + 2px));
        }

        /* Add this style to hide the footer when the pushmenu is activated */
        .sidebar-push .wrapper .sidebar-footer {
            display: none;
        }

        .card-secondary:not(.card-outline)>.card-header {
            background-color: #343a40;
            height: 48px;

        }

        .flex-wrap .btn-secondary {
            background-color: #343a40;
        }

        .dt-button-collection .dropdown-menu .buttons-columnVisibility {
            background-color: #343a40;

        }

        .page-item.active .page-link {
            z-index: 3;
            color: #fff;
            background-color: #202124;
            border-color: #202124;
        }

        .modal-header {
            background-color: #1a1d20;
            height: 48px;
            color: white;
        }

        .modal-footer .btn {
            background-color: #1a1d20;

        }

        .modal-title {
            margin-bottom: 0;
            line-height: 0.5;
            font-weight: 600;
            text-transform: uppercase;

        }

        .close {
            color: white;
        }

        .card-title {
            float: left;
            font-size: 1.1rem;
            font-weight: 600;
            margin: 0;
            text-transform: uppercase;
        }

        .breadcrumb {
            display: -ms-flexbox;
            text-transform: capitalize;
            display: flex;
            -ms-flex-wrap: wrap;
            flex-wrap: wrap;
            padding: 0;
            margin-bottom: 1rem;
            list-style: none;
            background-color: #343a40;
            border-radius: 0.25rem;
        }

        .breadcrumb-item+.breadcrumb-item::before {
            display: inline-block;
            padding-right: 0.5rem;
            color: #ffffff;
            content: "/";
        }

        .breadcrumb-item.active {
            color: #ffffff;
        }

        .alert {
            height: 48px;
        }

        @import url('https://fonts.googleapis.com/css2?family=Poppins&display=swap');

        a {
            color: #fff;
            text-decoration: none;
        }

        .user-panel .info {
            display: inline-block;
            font-weight: 600;
            padding: 5px 5px 5px 10px;
        }

        .user-panel img {
            height: auto;
            width: 3.1rem;

        }

        .user-panel .image {
            display: inline-block;
            padding-left: 0.8rem;
            margin-top: 5%;
        }

        .fixed-chat-buttons {
            position: fixed;
            bottom: 20px;
            right: 20px;
            z-index: 9999;
        }

        .fixed-chat-buttons .btn {
            position: relative;
            width: 50px;
            height: 50px;
            border-radius: 50%;
            display: flex;
            align-items: center;
            justify-content: center;
            margin-bottom: 10px;
            font-size: 20px;
            text-align: center;
            line-height: 1;
        }

        .btn-whatsapp {
            background-color: #25D366;
            color: #fff;
        }

        .btn-telegram {
            background-color: #0088cc;
            color: #fff;
        }

        .btn-skype {
            background-color: #00AFF0;
            color: #fff;
        }

        .nav-sidebar>.nav-item {
            margin-bottom: -6px;
        }

        .brand-link {
            display: block;
            font-size: 1.25rem;
            line-height: 0.9;
            padding: 0.8125rem 0.5rem;
            transition: width .3s ease-in-out;
            white-space: nowrap;
        }

        .select2-container .select2-selection--single {
            height: 37px;
            border: 1px solid #d8dde1;
        }

        .select2-results {
            display: block;
            overflow-y: scroll;
        }
    </style>
</head>

<body class="hold-transition sidebar-mini layout-fixed">
    <div class="wrapper">

        <!-- Preloader -->
        <div class="preloader flex-column justify-content-center align-items-center">
            <img class="animation__shake" src="dist/img/AdminLTELogo.png" alt="AdminLTELogo" height="60" width="60">
        </div>

        <!-- Navbar -->
        <nav class="main-header navbar navbar-expand navbar-white navbar-light" style="background-color: #343a40;">
            <!-- Left navbar links -->
            <ul class="navbar-nav">
                <li class="nav-item">
                    <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars" style="color:white"></i></a>
                </li>

            </ul>

            <!-- Right navbar links -->
            <ul class="navbar-nav ml-auto">


                <!-- Notifications Dropdown Menu -->
                <!-- Notifications Dropdown Menu -->
                <li class="nav-item dropdown">
                    <a class="nav-link" data-toggle="dropdown" href="#">

                        <i class="far fa-bell" style="color:white" id="notification-bell"></i>
                        <?php
                        include('connection.php');
                        $query = "SELECT count(id) as num FROM notifications WHERE  seen_status='0' ";
                        $result = mysqli_query($conn, $query);
                        if ($data = mysqli_fetch_array($result)) {
                            $p = $data['num'];
                        }
                        ?>
                        <span class="badge badge-warning navbar-badge"><?php echo $p; ?></span>
                    </a>
                    <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
                        <span class="dropdown-item dropdown-header"> Notifications <?php echo $p; ?></span>
                        <div class="dropdown-divider"></div>
                        <?php
                        include('connection.php');

                        if (isset($_GET['notification_id'])) {
                            $notification_id = $_GET['notification_id'];

                            $update_sql = "UPDATE notifications SET seen_status = '1' WHERE id = $notification_id";
                            mysqli_query($conn, $update_sql);
                        }

                        $sql = "SELECT * FROM notifications WHERE seen_status='0' ORDER BY id DESC";
                        $res = mysqli_query($conn, $sql);
                        $unread_notifications = array();

                        while ($row = mysqli_fetch_array($res)) {
                            $unread_notifications[] = $row;
                        }
                        ?>

                        <div id="unread-notifications">
                            <?php
                            $count = 0;
                            foreach ($unread_notifications as $notification) {
                                if ($count < 2) {
                            ?>
                                    <a href="?notification_id=<?php echo $notification['id']; ?>" class="dropdown-item">
                                        <i class="fas fa-envelope mr-2"></i> <?php echo $notification['message'] ?>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a href="?notification_id=<?php echo $notification['id']; ?>" class="dropdown-item hidden-notification" style="display: none;">
                                        <i class="fas fa-envelope mr-2"></i> <?php echo $notification['message'] ?>
                                    </a>
                            <?php
                                }
                                $count++;
                            }
                            ?>
                        </div>

                        <div class="dropdown-divider"></div>
                        <a href="#" class="dropdown-item" id="view-all-link" onclick="showAllMessages();">
                            <i class="fas fa-file mr-2"></i> View All Message
                        </a>

                        <script>
                            function showAllMessages() {
                                var hiddenNotifications = document.querySelectorAll('.hidden-notification');
                                var viewAllLink = document.getElementById('view-all-link');

                                hiddenNotifications.forEach(function(notification) {
                                    notification.style.display = 'block';
                                });

                                viewAllLink.style.display = 'none';
                            }
                        </script>


                </li>

                <li class="nav-item">
                    <a class="nav-link" href="logout.php" style="color:white">
                        <i class="fa fa-sign-out" style="color:white"></i>logout
                    </a>
                </li>

            </ul>
        </nav>
        <!-- /.navbar -->

        <!-- Main Sidebar Container -->
        <aside class="main-sidebar sidebar-dark-primary elevation-4">

            <!-- Brand Logo -->
            <a href="#" class="brand-link">
                <?php
                include('connection.php');
                $sql = "SELECT * FROM user_admin";
                $res = mysqli_query($conn, $sql);
                while ($row = mysqli_fetch_array($res)) {


                ?>
                    <!-- <img src="dist/img/avatar5.png" height="30" width="30" class="brand-image img-circle elevation-3" style="opacity: .8"> -->
                    <span class="brand-text font-weight-light"><span style="margin-left: 3%;font-weight:600;font-size: 33px;"><?php echo $row['title']; ?></span></span>
                <?php
                }
                ?>

            </a>

            <!-- Sidebar -->
            <div class="sidebar">
                <!-- Sidebar user panel (optional) -->
                <div class="user-panel mt-1 mb-1 p-1 d-flex">
                    <div class="image" style="padding-left: 0;">
                        <img src="dist/img/avatar5.png" class="img-circle elevation-2" alt="User Image" style="margin-left: 12px;">

                    </div>
                    <div class="info">
                        <a href="#" class="d-block" style="font-size: 150%;">Admin</a>
                        <span class="right badge badge-success" style="margin-top: 3%;height: 19px;">online</span>
                    </div>
                    <br>
                </div>



                <!-- Sidebar Menu -->
                <nav class="mt-2" style="font-weight:600">
                    <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false" style="text-transform: uppercase;">
                        <!-- Add icons to the links using the .nav-icon class
               with font-awesome or any other icon font library -->
                        <li class="nav-item">
                            <a href="dashboad.php" class="nav-link">
                                <i class="nav-icon fas fa-tachometer-alt"></i>
                                <p>
                                    Dashboard
                                </p>
                            </a>
                        </li>
                        <li class="nav-header">Vendor</li>
                        <li class="nav-item">
                            <a href="add_track.php" class="nav-link">
                                <i class="nav-icon fas fa-truck"></i>
                                <p>
                                    Add Track
                                </p>
                            </a>
                        </li>
                        
                        <li class="nav-item">
                            <a href="order_sent.php" class="nav-link">
                                <i class="nav-icon fa fa-shopping-bag"></i>
                                <p>
                                    Order Sent
                                    <!-- <span class="right badge badge-danger">New</span> -->
                                </p>
                            </a>
                        </li>
                        <li class="nav-header">ORDERS</li>
                        <li class="nav-item">
                            <a href="pending_order.php" class="nav-link">
                                <i class="nav-icon fas fa-clock-o"></i>
                                <p>
                                    Pending Orders
                                    <!-- <span class="right badge badge-danger">New</span> -->
                                </p>
                            </a>
                        </li>
                        <li class="nav-item">
                            <a href="order_history.php" class="nav-link">
                                <i class="nav-icon fas fa-history"></i>
                                <p>
                                    Order History
                                </p>
                            </a>
                        </li>
                        <li class="nav-item">
                            <a href="cancel_order.php" class="nav-link">
                                <i class="nav-icon fas fa-times"></i>
                                <p>
                                    Cancel Orders
                                </p>
                            </a>
                        </li>
                        
                        
                        
                        
                        
                        <li class="nav-header">Profile</li>
                        
                        
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-users"></i>
                                <p>
                                    User
                                    <i class="fas fa-chevron-circle-left right"></i>
                                    <!-- <span class="badge badge-info right">6</span> -->
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                                <li class="nav-item">
                                    <a href="add_user.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Users</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="add_reseller.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Reseller</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="view_all.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>view All</p>
                                    </a>
                                </li>
                               
                              
                            </ul>
                        </li>
                        <li class="nav-item">
                            <a href="add_vender.php" class="nav-link">
                                <i class="nav-icon fas fa-user-plus"></i>
                                <p>
                                    Add Vendors
                                </p>
                            </a>
                        </li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-user"></i>
                                <p>
                                Affilate
                                    <i class="fas fa-chevron-circle-left right"></i>
                                    <!-- <span class="badge badge-info right">6</span> -->
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                             
                                <li class="nav-item">
                                    <a href="add_affilate.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Affilate</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="view_affilate.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>view Affilate</p>
                                    </a>
                                </li>
                              
                            </ul>
                        </li>
                        <?php
                        $rid = $_SESSION['username'];


                        // Construct the SQL query to fetch the desired count
                        $sql = "SELECT COUNT(ur.id) as num
                        FROM usdt_request AS ur
                        INNER JOIN user AS u ON ur.user_id = u.user_id
                        WHERE u.added_by = '$rid' AND ur.status = '0'";

                        $res = mysqli_query($conn, $sql);
                        $row1 = mysqli_fetch_array($res);
                        $count = $row1['num'];
                        ?>

                        <!-- Display the count in your HTML -->
                        <li class="nav-header">Transaction</li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-money"></i>
                                <p>
                                   Payment Setting
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">

                                <li class="nav-item">
                                    <a href="usdt_payment.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>USDT Payment</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="upi_payment.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>UPI Payment</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="bank_details.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Bank Details</p>
                                    </a>
                                </li>

                            </ul>
                        </li>
                        <li class="nav-item">
                            <a href="usdt_request.php" class="nav-link">
                                <img src="img/t_icon.png" style="width: 1.1rem; margin-right: 0.6rem;margin-left: 0.2rem; text-align: center;">
                                <p>
                                    USDT Request
                                    <span class="badge badge-danger right"><?php echo $count; ?></span>
                                </p>
                            </a>
                        </li>

                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-money"></i>
                                <p>
                                    Credits
                                    <i class="right fas fa-chevron-circle-left"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                                <li class="nav-item">
                                    <a href="add_credit.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Credits</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="remove_credit.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Remove Credits</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="credit_history.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Credit History</p>
                                    </a>
                                </li>

                            </ul>
                        </li>
                        <li class="nav-header">Inventory</li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-camera"></i>
                                <p>
                                    Picture
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                                <li class="nav-item">
                                    <a href="catalouge.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p> Product Picture</p>
                                    </a>
                                </li>

                                <li class="nav-item">
                                    <a href="view_all_product.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>view All</p>
                                    </a>
                                </li>
                            </ul>
                        </li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-clipboard-list"></i>
                                <p>
                                    Products
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                                <li class="nav-item">
                                    <a href="add_salt.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add salt</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="add_origin.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Origins</p>
                                    </a>
                                </li>


                                <li class="nav-item">
                                    <a href="add_quantity.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Quantity</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="add_product.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Add Products</p>
                                    </a>
                                </li>


                            </ul>
                        </li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-credit-card"></i>
                                <p>
                                    Price Update
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                                <li class="nav-item">
                                    <a href="product_price.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Product Price</p>
                                    </a>
                                </li>


                            </ul>
                        </li>
                        <li class="nav-header">NOTIFICATION</li>
                        <li class="nav-item">
                            <a href="add_event.php" class="nav-link">
                                <i class="nav-icon far fa-calendar-alt"></i>
                                <p>
                                    Add Event
                                    <?php
                                    $query1 = mysqli_query($conn, "SELECT count(id) as num from calendar_event_master");

                                    if ($row1 = mysqli_fetch_array($query1)) {
                                        $p = $row1['num'];
                                    }
                                    ?>
                                    <span class="badge badge-info right"><?php echo $p; ?></span>
                                </p>
                                </p>
                            </a>
                        </li>
                        <li class="nav-item">
                            <a href="compose.php" class="nav-link">
                                <i class="nav-icon fas fa-pencil-square"></i>
                                <p>
                                Compose
                                </p>
                            </a>
                        </li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fas fa-bell"></i>
                                <p>
                                    Notice Update
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">

                                <li class="nav-item">
                                    <a href="add_user_notice.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>User Panel</p>
                                    </a>
                                </li>

                            </ul>
                        </li>
                     
                        
                        <li class="nav-header">Marketing</li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fa fa-address-book"></i>
                                <p>
                                    Phonebook
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">
                                <li class="nav-item">
                                    <a href="contact-add.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Contacts</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="add_website.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Websites</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="#" class="nav-link">
                                    <i class="far fa-circle nav-icon"></i>
                                    <p>
                                    Skype
                                        <i class="right fas fa-angle-left"></i>
                                    </p>
                                    </a>
                                    <ul class="nav nav-treeview">
                                    <li class="nav-item">
                                        <a href="skype-add.php" class="nav-link">
                                        <i class="far fa-dot-circle nav-icon"></i>
                                        <p>Skype Contact</p>
                                        </a>
                                    </li>
                                    <li class="nav-item">
                                        <a href="our_skype.php" class="nav-link">
                                        <i class="far fa-dot-circle nav-icon"></i>
                                        <p>Our Skype</p>
                                        </a>
                                    </li>
                                   
                                    </ul>
                                </li>
                                <li class="nav-item">
                                    <a href="add_telegram.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Telegram</p>
                                    </a>
                                </li>
                            </ul>
                        </li>

                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fa fa-barcode"></i>
                                <p>
                                    Tools
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">

                                <li class="nav-item">
                                    <a href="usps-address.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>USPS Track</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="ems-lable.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>EMS Track</p>
                                    </a>
                                </li>

                                <li class="nav-item">
                                    <a href="usdt-receipt.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>USDT Receipt</p>
                                    </a>
                                </li>
                                <li class="nav-item">
                                    <a href="check_web_status.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Web Scrapping</p>
                                    </a>
                                </li>
                            </ul>
                        </li>
                        <li class="nav-header">Filters</li>
                        <li class="nav-item">
                            <a href="whatsapp_filter.php" class="nav-link">
                                <i class="nav-icon fa fa-whatsapp"></i>
                                <p>
                                    WhatsApp Filter
                                    <?php
                                    $query1 = mysqli_query($conn, "SELECT count(id) as num from whatsapp_filter WHERE status = 'Pending'");

                                    if ($row1 = mysqli_fetch_array($query1)) {
                                        $p = $row1['num'];
                                    }
                                    ?>
                                    <span class="badge badge-warning right"><?php echo $p; ?></span>
                                </p>
                            </a>
                        </li>
                        <li class="nav-header">Settings</li>
                        <li class="nav-item">
                            <a href="#" class="nav-link">
                                <i class="nav-icon fa fa-gear"></i>
                                <p>
                                    Setting
                                    <i class="fas fa-chevron-circle-left right"></i>
                                </p>
                            </a>
                            <ul class="nav nav-treeview">


                                <li class="nav-item">
                                    <a href="profile_setting.php" class="nav-link">
                                        <i class="far fa-circle nav-icon"></i>
                                        <p>Profile Setting</p>
                                    </a>
                                </li>
                            </ul>
                        </li>
                    </ul>

                </nav>
                <!-- /.sidebar-menu -->

            </div>

            <footer class="sidebar-footer ">
                <div class="flex-col">



                    <div class="translate" id="google_translate_element"></div>
                    <div class="skiptranslate goog-te-gadget" dir="ltr">
                        <div id=":0.targetLanguage">
                        </div>
                    </div>
                    <script type="text/javascript">
                        function googleTranslateElementInit() {
                            new google.translate.TranslateElement({
                                pageLanguage: 'en'
                            }, 'google_translate_element');
                        }
                    </script>
                    <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
                    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@10.15.5/dist/sweetalert2.all.min.js"></script>
                    <div class="fixed-chat-buttons">
                        <a href="https://web.whatsapp.com/send?phone=YOUR_PHONE_NUMBER" target="_blank" class="btn btn-whatsapp" data-toggle="tooltip" data-placement="left" title="WhatsApp">
                            <i class="fab fa-whatsapp"></i>
                        </a>
                        <a href="https://t.me/YOUR_TELEGRAM_USERNAME" target="_blank" class="btn btn-telegram" data-toggle="tooltip" data-placement="left" title="Telegram">
                            <i class="fab fa-telegram"></i>
                        </a>
                        <a href="skype:YOUR_SKYPE_USERNAME?chat" target="_blank" class="btn btn-skype" data-toggle="tooltip" data-placement="left" title="Skype">
                            <i class="fab fa-skype"></i>
                        </a>


                    </div>
            </footer>

            <!-- /.sidebar -->
        </aside>
        <!-- Content Wrapper. Contains page content -->