Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
conjoinedly
/
admin
:
dashboard.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php session_start(); include("./../config/config.php"); include("./backend/validated_admin.php"); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Dashboard - iCouponWorld | Coupons | Discounts| Promo Codes</title> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <link id="favicon" rel="icon" type="image/x-icon" href="../images/web-images/logo\1754686066.png"> <meta name="robots" content="index, follow" /> <meta name="author" content="Design Collection"> <meta name="description" content="This is the dashboard of icouponworld with the help of which you can manage the whole website." /> <link rel="canonical" href="dashboard.php"/> <meta name="keywords" content="Dashboard, Total Coupon, Total Affiliate Company, Total Brand, Total Store, Total Merchant"> <!-- Viewport configuration, scaling options --> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> <!-- Bootstrap CSS --> <link href="../css/icouponworld.css" rel="stylesheet"> <!-- CSS Stylesheet --> <link href="../css/dashboard.css" rel="stylesheet"> <!-- DataTables Bootstrap CSS --> <link href="../css/dataTables.bootstrap5.min.css" rel="stylesheet"> <!-- Font Awesome icon --> <link href="../fontawesome/css/fontawesome.css" rel="stylesheet" /> <!-- Roboto font --> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Roboto:ital,wght@0,100;0,300;0,400;0,500;0,700;1,100;1,300;1,400;1,500;1,700&display=swap" rel="stylesheet"> <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head> <body> <!--unique id begin --> <div id="s_mm"> <!-- Preloader Begin--> <!-- <div class="preloader"> <div class="loading"> <img src="../images/web-images/dashboard/loader.gif" class="mx-auto d-flex"> <h4 class="text-center fw-bold pt-3">loading...</h4> </div> </div> --> <!-- Preloader End--> <!--scroll-top Begin--> <div id="scroll-top"> <!--sidebarwrapper Begin--> <div id="sidebarwrapper"> <!--Sidebarmenu Begin--> <?php include("./includefiles/sidebar.php"); ?> <!--Sidebarmenu End--> <!--content-wrapper Begin--> <div id="content-wrapper" class="d-flex flex-column dashboard-navbar"> <div id="maincontent"> <!-- Navbar Topbar Begin--> <?php include("./includefiles/header.php"); ?> <!-- Navbar Topbar End--> <!-- Container Begin--> <div class="container-fluid px-4"> <div class="d-sm-flex align-items-center justify-content-between mb-4"> <h3> Dashboard </h3> </div> <?php include("./includefiles/coupon_count.php"); ?> <div class="row"> <!--Coupon uploaded Begin--> <div class="col-md-6"> <div class="card border-0 shadow mb-4"> <div class="card-header bg-white border-bottom py-3"> <h6 class="m-0 fw-bold text-inherit">Total Coupon uploaded </h6> </div> <div class="card-body"> <div class="table-responsive"> <!--Table Begin--> <table id="affiliatecompany" class="table table-striped table-hover"> <thead class="table-light-success"> <tr> <th>Company Name</th> <th>Coupon</th> </tr> </thead> <tbody class="text-capitalize"> <?php $data = affiliate_company(); foreach($data as $row){ ?> <tr> <td><?php echo $row['from_site']?></td> <td><?php echo total_coupan($row['from_site']) ?></td> </tr> <?php } ?> </tbody> <tfoot> <tr> <th>Company Name</th> <th>Coupon</th> </tr> </tfoot> </table> <!--Table End--> </div> </div> </div> </div> <!--Coupon uploaded End--> <!--Product uploaded Begin--> <div class="col-md-6"> <div class="card border-0 shadow mb-4"> <div class="card-header bg-white border-bottom py-3"> <h6 class="m-0 fw-bold text-inherit">Total Product uploaded</h6> </div> <div class="card-body"> <div class="table-responsive"> <!--Table Begin--> <table class="table table-striped table-hover" id="company_wise"> <thead class="table-light-success"> <tr> <th>Company Name</th> <th>Product</th> </tr> </thead> <tbody class="text-capitalize"> <?php $data = affiliate_product(); foreach($data as $row){ ?> <tr> <td><?php echo $row['company_name']?></td> <td><?php echo products_count(addslashes($row['company_name']))?></td> </tr> <?php } ?> </tbody> <tfoot> <tr> <th>Company Name</th> <th>Product</th> </tr> </tfoot> </table> <!--Table End--> </div> </div> </div> </div> <!---Product uploaded End--> <!--Coupon and Product uploaded by merchant Begin--> <div class="col-md-12"> <div class="card border-0 shadow mb-4"> <div class="card-header bg-white border-bottom py-3"> <h6 class="m-0 fw-bold text-inherit text-inherit">Coupon and product uploaded by merchant</h6> </div> <div class="card-body"> <div class="table-responsive"> <!--Table Begin--> <table class="table table-striped table-hover" id="merchant"> <thead class="table-light-success"> <tr> <th>Merchant Name</th> <th>Company Name</th> <th>Coupon</th> <th>product</th> </tr> </thead> <tbody> <?php $sql = "SELECT * FROM vendor_master "; $myquery=$conn->query($sql); $mydara= $myquery->fetchAll() ; $rows_found = $myquery->rowCount(); foreach ($mydara as $key ) { $rows_found_s=0; $rowId= $key['rowId']; $full_name= $key['full_name']; $company_name = $key['company_name']; $sql_s = "SELECT created_by FROM coupon WHERE created_by='$rowId' "; $myquery_s=$conn->query($sql_s); $mydara_s= $myquery->fetchAll() ; $rows_found_s = $myquery->rowCount(); $sql_p = "SELECT created_by FROM product_master WHERE created_by='$rowId' "; $myquery_p=$conn->query($sql_p); $mydara_p= $myquery_p->fetchAll() ; $rows_found_p = $myquery_p->rowCount(); ?> <tr> <td><?=$full_name?></td> <td><?=$company_name?></td> <td><?=$rows_found_s?></td> <td><?=$rows_found_p?></td> </tr> <?php } ?> </tbody> <tfoot> <tr> <th>Merchant Name</th> <th>Company Name</th> <th>Coupon</th> <th>product</th> </tr> </tfoot> </table> <!--Table End--> </div> </div> </div> </div> <!---Coupon and Product uploaded by merchant End--> </div> </div> <!-- Container End--> </div> <!--Copyright Begin--> <?php include("./includefiles/footer.php"); ?> <!--Copyright End--> </div> <!--content-wrapper End--> </div> <!--sidebarwrapper End--> <!--Scroll to top Begin--> <a class="scroll-to-top rounded" href="#scroll-top"> <i class="fas fa-angle-up"></i> </a> <!--Scroll to top End--> <!-- Jquery Script Begin--> <script src="../js/jquery-3.4.1.min.js"></script> <!-- Jquery Script End--> <!-- Bootstrap Script Begin--> <script src="../js/bootstrap.bundle.min.js"></script> <!-- Bootstrap Script End--> <!-- dashboard-icouponworld Script Begin--> <script src="../js/dashboard-icouponworld.js"></script> <!-- dashboard-icouponworld Script End--> <!-- jQuery Datatable js Script Begin--> <script src="../js/jquery.dataTables.min.js"></script> <!-- jQuery Datatable js End --> <!-- dataTables.bootstrap5.min js Begin--> <script src="../js/dataTables.bootstrap5.min.js"></script> <!-- dataTables.bootstrap5.min js End--> </div> <!--scroll-top End--> </div> <!--unique id End --> <!-- Script for table footer filteration Begin--> <script> $(document).ready(function () { $('#affiliatecompany tfoot th, #merchant tfoot th, #company_wise tfoot th').each(function () { var title = $(this).text(); $(this).html('<input type="text" class="form-control" placeholder="Search ' + title + '" />'); }); // DataTable var table = $('#affiliatecompany, #merchant , #company_wise').DataTable({ searchPanes: true, initComplete: function () { // Apply the search this.api() .columns() .every(function () { var that = this; $('input', this.footer()).on('keyup change clear', function () { if (that.search() !== this.value) { that.search(this.value).draw(); } }); }); }, }); }) </script> <!-- Script for table footer filteration End--> </body> </html>