 Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory : /home/gositeme/domains/gositeme.com/private_html/quickqr/admin/ |
<?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>