File: /home/cafsindia/.trash/application/views/payroll_dashboard/manage_rebar.php
<?php
$this->load->view("partial/header"); ?>
<style type="text/css">
.form-group{
margin-top:4px;
display: inline-block;
}
.highcharts-no-data{
font-size: 1.8em !important;
}
</style>
<?php
$company_name = $this->config->item('company');
$today = date('d-m-Y');
$prev_month = date('01-m-Y', strtotime("-6 month", strtotime($today)));
$last_month = date('m-Y', strtotime("-1 month", strtotime($today)));
$view_data = $this->db->query("CALL sp_a_run ('SELECT','select * from cw_branch where trans_status = 1')");
$view_result = $view_data->result();
$view_data->next_result();
$branch_list[""] = "-- All --";
foreach($view_result as $for){
$branch_id = $for->prime_branch_id;
$branch = $for->branch;
$branch_list[$branch_id] = $branch;
}
$data['branch_list'] = $branch_list;
$logged_user_role = $this->session->userdata('logged_user_role');
if((int)$logged_user_role === 1){
include('admin_dashboard.php');
}else{
echo "<h3>Welcome</h3>";
}
?>
<div class="container-fluid" style="background-color: #f2f2f2;">
<h4 class="center bold mrgb15" style="color:#5C5C61;">DASHBOARD</h4>
<div class='col-md-12'>
<div class='form-group'>
<label>Start Date</label>
<input type='text' id='start_date' value='<?php echo $prev_month; ?>' class='datepicker form-control input-sm'>
</div>
<div class='form-group' style="margin-left:5px;">
<label>End Date</label>
<input type='text' id='end_date' value='<?php echo $today; ?>' class='datepicker form-control input-sm '>
</div>
<div class='form-group' style="margin-left:10px;">
<?php
echo form_label('Choose Branch', 'branch');
echo form_dropdown(array( 'name' => 'branch', 'id' => 'branch','class' => 'form-control input-sm'),$branch_list);
?>
</div>
<div class='form-group'>
<button id='search' class='btn btn-info btn-sm' style="margin-left:30px;margin-bottom:5px" onclick='dashboard_search()'>search</button>
</div>
</div>
<div class="row">
<div class="row" style="margin:20px;">
<div class="col-md-12" >
<div class="dash_layer_bar">
<div id="monthwise_empcount" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
</div>
<div class="row" style="margin:20px;">
<div class="col-md-6" id="ave_status">
<div class="dash_layer_bar">
<div id="get_active_status" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
<div class="col-md-6">
<div class="dash_layer">
<div id="employees_Attrition_chart" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
</div>
<div class="row" style="margin:20px;">
<div class="col-md-4">
<div class="dash_layer">
<div id="gen_distribution_chart" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
<div class="col-md-8" >
<div class="dash_layer">
<div id="dept_salary_info" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
</div>
<div class="row" style="margin:20px;">
<div class="col-md-12" >
<div class="dash_layer">
<div id="total_salary_month_chart" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
</div>
<div class="row" style="margin:20px;">
<div class="col-md-12" id="ave_status">
<div class="dash_layer_bar" style="padding-top: 0px !important;">
<div class='form-group ' style="width: 8%; margin:0px !important" >
<input id='monthwise' value='<?php echo $last_month; ?>' class='form-control input-sm monthpicker-min'>
</div>
<div id="get_min_salary" style="min-width: 268px; height: 307px; margin: 0 auto;"></div>
</div>
</div>
</div>
</div>
</div>
<script src="./dist/highcharts/highcharts.js"></script>
<script src="./dist/highcharts/exporting.js"></script>
<script src="./dist/highcharts/highchartnodata.js"></script>
<script src="./dist/highcharts/modules_export-data.js"></script>
<script src="./dist/highcharts/dashboard_rebar.js"></script>
<script type="text/javascript" src="dist/highcharts/drilldown.js"></script>
<!-- <script type="text/javascript" src="dist/highcharts/highcharts-3d.js"></script>
<script type="text/javascript" src="dist/highcharts/data.js"></script>
-->
<script type="text/javascript">
$(document).ready(function() {
$(function () {
$(".datepicker").datetimepicker({
format: 'DD-MM-YYYY',
});
$(".monthpicker-min").datetimepicker({
format: 'MM-YYYY',
}).on('dp.change', function (e) {
var monthwise = $("#monthwise").val();
get_min_salary(monthwise);
});
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
});
});
dashboard_search();
});
function dashboard_search(){
var start_date = $('#start_date').val();
var end_date = $('#end_date').val();
var branch = $('#branch').val();
var monthwise = $("#monthwise").val();
get_min_salary(monthwise);
get_salary_info(start_date,end_date,branch);
monthwise_empcount(start_date,end_date,branch);
total_salary_month_chart(start_date,end_date,branch);
gen_distribution_chart(start_date,end_date,branch);
get_active_status(start_date,end_date,branch);
employees_Attrition_chart(start_date,end_date,branch);
}
</script>
<?php
$this->load->view('partial/footer');
?>