<!--row -->
<div class="row">
<div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="ti-user bg-megna"></i>
<div class="bodystate">
<h4><?php echo $this->db->count_all_results('student');?></h4>
<span class="text-muted"><?php echo get_phrase('New Patient');?></span>
</div>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="ti-user bg-info"></i>
<div class="bodystate">
<h4><?php echo $this->db->count_all_results('teacher');?></h4>
<span class="text-muted"><?php echo get_phrase('OPD Patient');?></span>
</div>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="ti-user bg-success"></i>
<div class="bodystate">
<h4><?php echo $this->db->count_all_results('parent');?></h4>
<span class="text-muted"><?php echo get_phrase('Todays Operations');?></span>
</div>
</div>
</div>
</div>
<!-- <div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="ti-user bg-inverse"></i>
<div class="bodystate">
<h4><?php echo $this->db->count_all_results('accountant');?></h4>
<span class="text-muted"><?php echo get_phrase('Todays Operations');?></span>
</div>
</div>
</div>
</div> -->
<div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<!-- <i class="ti-money bg-megna"></i> -->
<i class="fa fa-inr" aria-hidden="true"></i>
<div class="bodystate">
<?php
$this->db->select_sum('amount');
$this->db->from('payment');
$this->db->where('payment_type', 'expense');
$query = $this->db->get();
$expense_amount = $query->row()->amount;
?>
<h4><?php echo $this->db->get_where('settings', array('type' => 'currency'))->row()->description;?> <?php echo $expense_amount;?></h4>
<span class="text-muted"><?php echo get_phrase('Clinic earning');?></span>
</div>
</div>
</div>
</div>
<!-- <div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="fa fa-inr" aria-hidden="true" style="background: #036c86"></i>
<div class="bodystate">
<?php
$this->db->select_sum('amount');
$this->db->from('payment');
$this->db->where('payment_type', 'income');
$query = $this->db->get();
$income_amount = $query->row()->amount; ?>
<h4>
<?php echo $this->db->get_where('settings', array('type' => 'currency'))->row()->description;?> <?php echo $income_amount;?>
</h4>
<span class="text-muted"><?php echo get_phrase('Income');?></span>
</div>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="ti-wallet bg-success"></i>
<div class="bodystate">
<h4><?php echo $this->db->count_all_results('admin');?></h4>
<span class="text-muted"><?php echo get_phrase('Admin');?></span>
</div>
</div>
</div>
</div>
<div class="col-md-3 col-sm-6">
<div class="white-box">
<div class="r-icon-stats">
<i class="ti-wallet bg-inverse"></i>
<div class="bodystate">
<h4>
<?php
$check_daily_attendance = array('date' => date('Y-m-d'), 'status' => '1');
$get_attendance_information = $this->db->get_where('attendance', $check_daily_attendance);
$display_attendance_here = $get_attendance_information->num_rows();
echo $display_attendance_here;
?>
</h4>
<span class="text-muted"><?php echo get_phrase('Attendance');?></span>
</div>
</div>
</div>
</div> -->
</div>
<!--/row -->
<div class="row">
<div class="col-sm-6">
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="box-title m-b-0"><?php echo get_phrase('Recently Added Teachers');?></h3></div>
<div class="panel-body table-responsive">
<table id="example01" class="table table-striped" cellspacing="0" width="100%">
<thead>
<tr>
<th>Image</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
</tr>
</thead>
<tbody>
<tr>
<?php $get_teacher_from_model = $this->crud_model->list_all_teacher_and_order_with_teacher_id();
foreach ($get_teacher_from_model as $key => $teacher):?>
<td><img src="<?php echo $teacher['face_file'];?>" class="img-circle" width="40px"></td>
<td><?php echo $teacher['name'];?></td>
<td><?php echo $teacher['email'];?></td>
<td><?php echo $teacher['phone'];?></td>
</tr>
<?php endforeach;?>
</tbody>
</table>
</div>
</div>
</div>
<div class="col-sm-6">
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="box-title m-b-0"><?php echo get_phrase('Recently Added Students');?></h3>
</div>
<div class="panel-body table-responsive">
<table id="example23" class="table table-striped" cellspacing="0" width="100%">
<thead>
<tr>
<th>Image</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
</tr>
</thead>
<tbody>
<tr>
<?php $get_student_from_model = $this->crud_model->list_all_student_and_order_with_student_id();
foreach ($get_student_from_model as $key => $student):?>
<td><img src="<?php echo $student['face_file'];?>" class="img-circle" width="40px"></td>
<td><?php echo $student['name'];?></td>
<td><?php echo $student['email'];?></td>
<td><?php echo $student['phone'];?></td>
</tr>
<?php endforeach;?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- /.row -->