Current File : /home/giriqfky/public_html/Barga/application/modules/dashboard/views//index_chart.php
<!-- Content Wrapper. Contains page content -->
<!-- Content Header (Page header) -->
<section class="content-header">
<h1><?php echo $title;?></h1>
<ol class="breadcrumb">
<li><a href="javascript:void(0);"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Dashboard</li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<!-- Small boxes (Stat box) -->
<div class="row">
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-aqua"><i class="ion ion-person-stalker"></i></span>
<div class="info-box-content">
<small>Pending Verification</small>
<span class="info-box-number"><?php echo $total_pending_verifications;?></span>
<a href="<?php echo base_url().'customers/customerList/1'; ?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-red"><i class="ion ion-stats-bars"></i></span>
<div class="info-box-content">
<small>Pending Loan Approval</small>
<span class="info-box-number"><?php echo $total_pending_loan_approval;?></span>
<a href="<?php echo base_url().'loan/loanList'; ?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<!-- fix for small devices only -->
<div class="clearfix visible-sm-block"></div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-green"><i class="ion ion-person-stalker"></i></span>
<div class="info-box-content">
<small>Total Customers</small>
<span class="info-box-number"><?php echo $total_customer; ?></span>
<a href="<?php echo base_url().'customers/customerList/0'; ?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-yellow"><i class="ion ion-stats-bars"></i></span>
<div class="info-box-content">
<small>Requested Loans</small>
<span class="info-box-number"><?php echo $pendingLoanRequest; ?></span>
<a href="<?php echo base_url().'loan/loanList'; ?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-tin"><i class="ion ion-stats-bars"></i></span>
<div class="info-box-content">
<small>Approved Loans</small>
<span class="info-box-number"><?php echo $approvedLoanRequest; ?></span>
<a href="<?php echo base_url().'loan/loanApprovedList/1'; ?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-blue"><i class="ion ion-stats-bars"></i></span>
<div class="info-box-content">
<small>Disbursed Loans</small>
<span class="info-box-number"><?php echo $totalLoanPaid; ?></span>
<a href="<?php echo base_url().'loan/loanApprovedList/2'; ?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-aqua"><i class="fa fa-inr"></i></span>
<div class="info-box-content">
<small>Total Loan Given</small>
<span class="info-box-number"><i class="fa fa-inr"></i> <?php echo numberFormat($total_given_loan, 2); ?></span>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-red"><i class="fa fa-inr"></i></span>
<div class="info-box-content">
<small>Total Loan Recovered</small>
<span class="info-box-number"><i class="fa fa-inr"></i> <?php echo numberFormat($total_recovered_loan, 2); ?></span>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-green"><i class="fa fa-inr"></i></span>
<div class="info-box-content">
<small>Total Due Loan</small>
<span class="info-box-number"><i class="fa fa-inr"></i> <?php echo numberFormat(($total_given_loan - $total_recovered_loan), 2); ?></span>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-aqua"><i class="fa fa-inr"></i></span>
<div class="info-box-content">
<small>Total Interest Amount Recovered</small>
<span class="info-box-number"><i class="fa fa-inr"></i> <?php echo numberFormat($total_interest_amount, 2); ?></span>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-red"><i class="fa fa-inr"></i></span>
<div class="info-box-content">
<small>Total Penalty Amount Recovered</small>
<span class="info-box-number"><i class="fa fa-inr"></i> <?php echo numberFormat($total_penalty_amount, 2); ?></span>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-blue"><i class="fa fa-inr"></i></span>
<div class="info-box-content">
<small>Total Amount</small>
<span class="info-box-number"><i class="fa fa-inr"></i> <?php echo numberFormat(($total_recovered_loan + $total_interest_amount + $total_penalty_amount), 2); ?></span>
</div>
</div>
</div>
</div>
<!-- row -->
<?php if(!empty($diff_given_loan_amount) && 1 == 2){?>
<!-- char.js start here -->
<div class="row">
<section class="col-lg-12 connectedSortable">
<div class="box box-primary">
<div class="box-header"><i class="ion ion-stats-bars"></i><h3 class="box-title">Loan Analysis Graph</h3>
<div class="chart"><canvas id="salesChart" style="height:180px;"></canvas></div>
</div>
</div>
</section>
</div>
<!-- char.js end here -->
<?php }?>
<!-- Main row -->
<div class="row">
<!-- Left col -->
<section class="col-lg-12 connectedSortable">
<div class="box box-primary">
<div class="box-header"><i class="ion ion-clipboard"></i><h3 class="box-title">Today's New Requested Loan</h3></div>
<div class="col-md-12 col-xs-12 searchform">
<!-- Search Form -->
<div class="row">
<form name="frm_search_filter" method="post" action="" id="frm_search_filter">
<div class="col-md-3 col-sm-2 col-xs-12">
<div class="form-group">
<input id="mobile_no" name="mobile_no" type="text" placeholder="Mobile Number" class="form-control numeric" maxlength="10">
</div>
</div>
<div class="col-md-3 col-sm-2 col-xs-12">
<div class="form-group">
<input id="profile_name" name="profile_name" type="text" placeholder="Profile Name" class="form-control">
</div>
</div>
<div class="col-md-3 col-sm-2 col-xs-12">
<div class="form-group">
<input id="loan_req_no" name="loan_req_no" type="text" placeholder="Loan Request No." class="form-control">
</div>
</div>
<div class="col-md-3 col-sm-3 col-xs-12 pull-left">
<button type="button" class="btn btn-success btn-md" onclick="searchFilter();">Search</button>
<button type="button" class="btn btn-danger btn-md" onclick="searchClear();">Clear</button>
</div>
<input type="hidden" name="url_link" id="url_link" value="dashboard/ajaxloanList/" />
</form>
</div>
<!-- End of Search Form -->
</div>
<!-- /.box-header -->
<div class="data_list" id="data_list">
<table id="example2" class="table table-bordered table-hover">
<thead style="background-color:#f5f5f5">
<tr>
<th width="15">#</th>
<th width="200">Customer Name</th>
<th width="100">Loan Request Number</th>
<th width="110">Loan Amount</th>
<th width="90">Status</th>
<th width="100">Requested Date</th>
<th width="70">Action</th>
</tr>
</thead>
<tbody>
<?php if(count($loan) > 0){?>
<?php $i=1;foreach($loan as $l){?>
<tr>
<td><?php echo $i;?></td>
<td>
<?php echo $l->profile_name == "" ? "NA" : $l->profile_name;?>
<br /><small class="text-danger">Customer Code : <?php echo $l->customer_unique_code;?></small>
<br /><small class="text-danger">Mobile : <?php echo $l->mobile_no;?></small>
<br /><small class="text-danger">Email : <?php echo $l->email_id == "" ? "NA" : $l->email_id;?></small>
<br /><small class="text-danger">Status : <?php echo customerStatus($l->customer_status);?></small>
</td>
<td>
<?php echo $l->loan_request_no;?>
<br /><small class="text-danger">Duration : <?php echo $l->loan_duration;?> [ <?php echo $l->loan_duration_range;?> ] Days</small>
</td>
<td>
<i class="fa fa-inr" aria-hidden="true"></i> <?php echo $l->loan_amount;?>
<br /><small class="text-danger">Interest : <i class="fa fa-inr" aria-hidden="true"></i> <?php echo $l->interest_amount;?></small>
</td>
<td><?php echo getLoanStatus(1, $l->loan_request_status);?></td>
<td><?php echo showDate($l->doc);?></td>
<td>
<a class="btn btn-success tooltips" href="<?php echo site_url('loan/requestLoanProcess/'.$l->loan_request_id.'/'.$l->customer_id);?>" title="Process Loan"><i class="fa fa-eye"></i></a>
<!--<a class="btn btn-primary tooltips" href="<?php echo site_url('loan/requestedLoanCommentsList/'.$l->loan_request_id);?>" title="Requested Loan Comments"><i class="fa fa-comment"></i> </a>-->
</td>
</tr>
<?php $i++;}?>
<?php }else{?>
<tr><td colspan="7"><?php echo getMessage("record_not_found", 3);?></td></tr>
<?php }?>
</tbody>
</table>
<div class="clearfix"></div>
<div class="pagination pull-right"><?php echo $this->ajax_pagination->create_links(); ?></div>
<?php $this->load->view('includes/data_loading');?>
</div>
<!-- /.box-body -->
</div>
</section>
</div>
<!-- /.row (main row) -->
</section>
<!-- /.content -->
<!-- /.content-wrapper -->
<?php if(!empty($diff_given_loan_amount) && 1 == 2){?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js"></script>
<script type="application/javascript">
new Chart(document.getElementById("salesChart"), {
type: 'line',
data: {
labels: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
datasets: [{
data: [<?php echo $diff_given_loan_amount;?>],
label: "Loan Given (Rs.)",
//backgroundColor: "#3e95cd", // for line chart this option is not required
borderColor: "#3e95cd",
fill: true
}, {
data: [<?php echo $diff_recovered_loan_amount;?>],
label: "Loan Repay (Rs.)",
//backgroundColor: "#8e5ea2", // for line chart this option is not required
borderColor: "#8e5ea2",
fill: true
}
]
},
options: {
title: {
display: true,
text: 'Loan Analysis Graph in Rupees'
}
}
});
</script>
<?php }?>
