File manager - Edit - /home/linknsbh/m.linkat.online/admin/index.php
Back
<?php require_once('includes.php'); $total_active_item = ORM::for_table($config['db']['pre'].'restaurant') ->table_alias('r') ->inner_join($config['db']['pre']."user","u.id = r.user_id",'u') ->count(); $banned_user = ORM::for_table($config['db']['pre'].'user')->where('status',2)->count(); $total_user = ORM::for_table($config['db']['pre'].'user')->count(); $quick_fetch= ORM::for_table($config['db']['pre'].'balance')->find_one(1); $totalearning = price_format($quick_fetch['total_earning'],$config['currency_code']); ?> <main class="app-layout-content"> <!-- Page Content --> <div class="container-fluid p-y-md"> <!-- Stats --> <div class="row"> <div class="col-sm-6 col-lg-4"> <a class="card" href="#"> <div class="card-block clearfix"> <div class="pull-right"> <p class="h6 text-muted m-t-0 m-b-xs">Total Restaurants</p> <p class="h3 text-blue m-t-sm m-b-0"><?php echo $total_active_item; ?></p> </div> <div class="pull-left m-r"> <span class="img-avatar img-avatar-48 bg-blue bg-inverse"><i class="ion-ios-bell fa-1-5x"></i></span> </div> </div> </a> </div> <!-- .col-sm-6 --> <!-- .col-sm-6 --> <div class="col-sm-6 col-lg-4"> <a class="card bg-purple bg-inverse" href="#"> <div class="card-block clearfix"> <div class="pull-right"> <p class="h6 text-muted m-t-0 m-b-xs">Total Users</p> <p class="h3 m-t-sm m-b-0"><?php echo $total_user; ?></p> </div> <div class="pull-left m-r"> <span class="img-avatar img-avatar-48 bg-gray-light-o"><i class="ion-ios-people fa-1-5x"></i></span> </div> </div> </a> </div> <!-- .col-sm-6 --> <div class="col-sm-6 col-lg-4"> <a class="card bg-blue bg-inverse" href="#"> <div class="card-block clearfix"> <div class="pull-right"> <p class="h6 text-muted m-t-0 m-b-xs">Total Income</p> <p class="h3 m-t-sm m-b-0"><?php echo $totalearning; ?></p> </div> <div class="pull-left m-r"> <span class="img-avatar img-avatar-48 bg-gray-light-o"><i class="ion-cash fa-1-5x"></i></span> </div> </div> </a> </div> <!-- .col-sm-6 --> </div> <!-- .row --> <!-- End stats --> <div class="row"> <div class="col-lg-8"> <!-- Transactions history Widget --> <div class="card"> <div class="card-header"> <h4>Restaurant Statistics</h4> </div> <div class="card-block"> <div style="height: 238px;"><canvas class="js-chartjs-lines4"></canvas></div> </div> </div> <!-- .card --> <!-- End Transactions history Widget --> </div> <!-- .col-lg-8 --> <div class="col-lg-4"> <!-- Weekly users Widget --> <div class="card"> <div class="card-header"> <h4>Weekly users </h4> </div> <div class="card-block"> <div style="height: 238px;"><canvas class="js-chartjs-bars3"></canvas></div> </div> </div> <!-- .card --> <!-- End Weekly users Widget --> </div> <!-- .col-lg-4 --> </div> <!-- .row --> <!-- .row --> <div class="row"> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12"> <div class="card"> <div class="card-header"> <h4>Recent 5 Restaurant</h4> </div> <div class="card-block"> <?php $getItem = ORM::for_table($config['db']['pre'].'restaurant') ->table_alias('r') ->select_many_expr('r.id rid','r.name','r.created_at','r.main_image') ->inner_join($config['db']['pre']."user","u.id = r.user_id",'u') ->limit(5) ->order_by_desc('r.id') ->find_many(); foreach ($getItem as $ads) { $ad_id = $ads['rid']; $ad_title = $ads['name']; $ad_location = $ads['location']; $ad_created_at = $ads['created_at']; $ad_pic = !empty($ads['main_image'])?$ads['main_image']:'default.png'; ?> <div class="pro-list"> <div class="pro-img p-r-10"> <a href="#"> <img src="../storage/restaurant/logo/<?php echo $ad_pic; ?>" alt="<?php echo $ad_title ?>" style="width:75px; height: 75px;"> </a> </div> <div class="pro-detail"> <h5 class="m-t-0 m-b-5"> <a href="<?php echo $config['site_url'] ?>restaurant/<?php echo $ad_id.'/'.create_slug($ad_title);?>"><?php echo $ad_title; ?></a> </h5> <p class="text-muted font-12"><?php echo $ad_created_at; ?> </p> </div> </div> <?php } ?> <div class="text-right"> <a href="restaurant.php" class="btn btn-sm btn-rounded btn-info m-t-10">View All</a> </div> </div> </div> </div> <div class="col-md-6 col-lg-6 col-sm-12"> <div class="card"> <div class="card-header"> <h4>Recent Registered </h4> </div> <div class="card-block"> <div class="table-responsive"> <table class="table "> <thead> <tr> <th>NAME</th> <th>EMAIL</th> <th>DATE</th> </tr> </thead> <tbody> <?php $rows = ORM::for_table($config['db']['pre'].'user') ->order_by_desc('id') ->limit(5) ->find_many(); foreach ($rows as $info) { ?> <tr> <td class="txt-oflo"><?php echo $info['name']; ?></td> <td><span class="label label-info label-rounded"><?php echo $info['email']; ?></span> </td> <td class="txt-oflo"><?php echo timeAgo($info['created_at']); ?></td> </tr> <?php } ?> </tbody> </table> <a href="users.php">Check all Users</a> </div> </div> </div> </div> </div> <!-- /.row --> </div> <!-- .container-fluid --> <!-- End Page Content --> </main> <?php include("footer.php"); ?> <!--Code For Chart--> <!-- Page Plugins --> <script src="assets/js/plugins/slick/slick.min.js"></script> <script src="assets/js/plugins/chartjs/Chart.min.js"></script> <?php $today = date('Y-m-d'); $todayPost = ORM::for_table($config['db']['pre'].'restaurant')->where_like('created_at', ''.$today.'%')->count(); $todayUser = ORM::for_table($config['db']['pre'].'user')->where_like('created_at', ''.$today.'%')->count(); $minusValue = $today; $minusValue2 = $today; $minusValue3 = $today; $chartPostValue = "'".$todayPost."'"; $chartUserValue = "'".$todayUser."'"; $chartWeeklyLable = "'".date('M-d')."'"; for ($x = 0; $x <= 5; $x++) { $minusValue = date('M-d', strtotime('-1 day', strtotime($minusValue))); $chartWeeklyLable .= ",'".$minusValue."'"; $minusValue2 = date('Y-m-d', strtotime('-1 day', strtotime($minusValue2))); $rows = ORM::for_table($config['db']['pre'].'restaurant')->where_like('created_at', ''.$minusValue2.'%')->count(); $chartPostValue .= ",'".$rows."'"; $minusValue3 = date('Y-m-d', strtotime('-1 day', strtotime($minusValue3))); $rows = ORM::for_table($config['db']['pre'].'user')->where_like('created_at', ''.$minusValue3.'%')->count(); $chartUserValue .= ",'".$rows."'"; } ?> <script> // Lines Chart Data 3 var $dashChartLinesData3 = { labels: [<?php echo $chartWeeklyLable; ?>], datasets: [ { label: 'This Week', fillColor: App.hexToRgba( App.colors.blue, 50 ), pointColor: App.colors.blue, data: [<?php echo $chartUserValue; ?>] } ] }; // Lines Chart Data 4 var $dashChartLinesData4 = { labels: [<?php echo $chartWeeklyLable; ?>], datasets: [ { label: 'This Week', strokeColor: App.colors.blue, pointColor: '#fff', pointStrokeColor: App.colors.blue, data: [<?php echo $chartPostValue; ?>] } ] }; </script> <!--Code For Chart--> <!-- Page JS Code --> <script src="assets/js/pages/index.js"></script> <script> $(function() { // Init page helpers (Slick Slider plugin) App.initHelpers('slick'); }); </script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.2.31 | Generation time: 0.11 |
proxy
|
phpinfo
|
Settings