MOON
Server: Apache
System: Linux nserver.cafsindia.com 4.18.0-553.104.1.lve.el8.x86_64 #1 SMP Tue Feb 10 20:07:30 UTC 2026 x86_64
User: cafsindia (1002)
PHP: 8.2.30
Disabled: NONE
Upload Files
File: /home/cafsindia/.trash/application.1/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">
$(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();
			var key        = '<?php echo $encKey; ?>';
			var encData1   = encrypt(key,{month:monthwise});
			get_min_salary(encData1);		
		});
		$('.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();
	var key        = '<?php echo $encKey; ?>';
	var encData    = encrypt(key,{start_date:start_date,end_date:end_date,branch:branch});
	var encData1   = encrypt(key,{month:monthwise});
	get_min_salary(encData1);
	get_salary_info(start_date,end_date,encData);
	monthwise_empcount(start_date,end_date,encData);
	total_salary_month_chart(start_date,end_date,branch);
	gen_distribution_chart(encData);	
	employees_Attrition_chart(start_date,end_date,encData);
	get_active_status(start_date,end_date,encData);
}



</script>

<?php
$this->load->view('partial/footer');
?>