<?php
require_once 'config/dbconn.php';

if(!$user->is_loggedin())
{
	$user->redirect('login.php');
}
else
{
$user_id = $_SESSION['user_session'];

$user->getUserLoggedIn($user_id);

$site_id=1;


$user->checkDriversLicenseExpiry();
$user->checkVehicleInsuranceExpiry();
$user->checkVehicleFitnessExpiry();
$user->checkVehicleLicensceExpiry();
$user->checkBorrowedVehicleExpiry();


$user->SiteConfig($site_id);

$user_logged_in=$user->userid;
//echo $_SESSION['user_full_name'];

	?>
    
<?php
 $hr_app_status=0;
 $sup_app_status=1;

$toApprove = $DB_con->prepare("SELECT
    ems_leave_application.leave_applicationid, 
    ems_leave_application.employeeid, 
    ems_leave_application.leave_typeid, 
    ems_leave_application.application_date, 
    ems_leave_application.start_date, 
    ems_leave_application.days_applied, 
    ems_leave_application.days_approved, 
    ems_leave_application.leave_pay, 
    ems_leave_application.travel_perm, 
    ems_leave_application.travel_address, 
    ems_leave_application.travel_phone, 
    ems_leave_application.arrangements, 
    ems_leave_application.supervisorid, 
    ems_leave_application.supervisor_approval_statusid, 
    ems_leave_application.supervisor_approval_date, 
    ems_leave_application.hr_approval_statusid, 
    ems_leave_application.supervisor_remarks, 
    ems_leave_application.hr_approval_date, 
    ems_leave_application.created
FROM
    ems_leave_application WHERE ems_leave_application.hr_approval_statusid = :hrpapp AND ems_leave_application.supervisor_approval_statusid = :supapp AND ems_leave_application.leave_typeid IN(1,2,4,5,6,7,8,9,11,12)");




        
          $toApprove->bindParam(':supapp',$sup_app_status);
          $toApprove->bindParam(':hrpapp',$hr_app_status);
          $toApprove->execute();
          $toApprove->setFetchMode(PDO::FETCH_ASSOC);
          $rowtoApp = $toApprove->fetch();
        $counttoApp = $toApprove->rowCount();

       // echo $rowtoApp['supervisorid'];


?>


   <?php
$this_year= date("Y");
 
 $five_year= date("Y")+6;
 
 
 // get Total Number of active employees
$sql4 = "SELECT count(ems_employee.employeeid) AS count_emp FROM ems_employee WHERE ems_employee.employee_statusid=1";
$stmt4= $DB_con->query($sql4);
$stmt4->setFetchMode(PDO::FETCH_ASSOC);
$emp_all = $stmt4->fetch();
$total_emp=$emp_all["count_emp"];

 // get Total Number of in-active employees
$sql9 = "SELECT count(ems_employee.employeeid) AS count_emp FROM ems_employee WHERE ems_employee.employee_statusid<>1";
$stmt9= $DB_con->query($sql9);
$stmt9->setFetchMode(PDO::FETCH_ASSOC);
$emp_all_inactive = $stmt9->fetch();
$total_emp_inactive=$emp_all_inactive["count_emp"];

 
 // Get Employee Count
$sql = 'SELECT * FROM view_employee_count_by_division';
$stmt = $DB_con->query($sql);
$resultBar = $stmt->fetchAll();

//Get retirement
 $sql = "SELECT * FROM view_retirement_by_year Where RET_YEAR<=$five_year AND RET_YEAR>=$this_year";
$stmt = $DB_con->query($sql);
$resultLine = $stmt->fetchAll();

//Get Travelling Officers
 $sql2 = "SELECT * FROM view_count_travelling_officers";
$stmt2 = $DB_con->query($sql2);
$stmt2->setFetchMode(PDO::FETCH_ASSOC);
$travelling = $stmt2->fetch();
$trav=$travelling["trav_count"];

//Get Online Leave Applications
 $sql2 = "SELECT * FROM view_count_travelling_officers";
$stmt2 = $DB_con->query($sql2);
$stmt2->setFetchMode(PDO::FETCH_ASSOC);
$travelling = $stmt2->fetch();
$trav=$travelling["trav_count"];

//Get Birthday Club
 $sqlBirthdays = "SELECT COUNT(*) AS birthday_count
FROM ems_employee
WHERE DATE_FORMAT(date_of_birth, '%m-%d') = DATE_FORMAT(CURDATE(), '%m-%d')
  AND employee_statusid = 1;
";
$sqlBirthdays = $DB_con->query($sqlBirthdays);
$sqlBirthdays->setFetchMode(PDO::FETCH_ASSOC);
$Birthdays = $sqlBirthdays->fetch();
$bdayToday=$Birthdays["birthday_count"];

// get Number of employees on leave
$sql3 = "SELECT count(ems_leave_transaction.employeeid) as emp_on_leave FROM ems_leave_transaction WHERE ems_leave_transaction.resume_date>curdate()";
$stmt3= $DB_con->query($sql3);
$stmt3->setFetchMode(PDO::FETCH_ASSOC);
$emp_leave = $stmt3->fetch();
$leave_emp=$emp_leave["emp_on_leave"];

// get sex
$row=$DB_con->prepare ("SELECT count(ems_employee.employeeid) AS count_emp, ems_sex.sex FROM ems_employee INNER JOIN ems_sex ON ems_employee.sexid = ems_sex.sexid WHERE ems_employee.employee_statusid=1 GROUP BY ems_sex.sex");

$row->execute(); 
$json_data=array();  
foreach($row as $rec)  
{  
    $json_array['label']=$rec['sex'];  
    $json_array['value']=$rec['count_emp'];  
    array_push($json_data,$json_array);  
}  

// get education
$sql_ed = 'SELECT count(ems_education.educationid) AS emp_count, 
	ems_qualification.qualification_obtained
FROM ems_education INNER JOIN ems_qualification ON ems_education.qualificationid = ems_qualification.qualificationid
WHERE ems_qualification.qualificationid=4 OR ems_qualification.qualificationid=1 OR ems_qualification.qualificationid=2 OR ems_qualification.qualificationid=8 OR ems_qualification.qualificationid=13 OR ems_qualification.qualificationid=28
GROUP BY ems_qualification.qualification_obtained';

$stmt = $DB_con->query($sql_ed);
$resultEd = $stmt->fetchAll();

?> 
        
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    
  <title><?php  echo $user->siteName;?></title>

  <!-- Google Font & Material Icons  -->
  <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
  <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&amp;lang=en" rel="stylesheet">

  <!-- App CSS -->
  <link type="text/css" href="assets/css/style.css" rel="stylesheet">
  
  <!-- Vendor CSS -->
  <link rel="stylesheet" href="charts/css/morris.min.css"> <!-- CHART (morris)-->
  <!-- Jquery -->
  <script src="node_modules/jquery/dist/jquery.min.js"></script>
  
  <link rel="stylesheet" type="text/css" href="node_modules/datatables/media/css/jquery.dataTables.css">
    <link rel="stylesheet" type="text/css" href="node_modules/datatables/media/css/buttons.dataTables.min.css">
  <script type="text/javascript" language="javascript" src="js/jquery.js"></script>
  

		<script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/jquery.dataTables.min.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/dataTables.buttons.min.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/buttons.flash.min.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/buttons.print.min.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/jquery.dataTables.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/buttons.flash.min.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/jszip.min.js"></script>
        <script type="text/javascript" language="javascript" src="node_modules/datatables/media/js/vfs_fonts.js"></script>        
        
        		<script type="text/javascript" language="javascript" >
			$(document).ready(function() {
				var dataTable = $('#employee-grid').DataTable( {
					"order": [[ 2, "asc" ]],
					"processing": true,
					"serverSide": true,
					
					"aLengthMenu": [[5, 10, 25, 50, 100, 1000], [5, 10, 25, 50, 100, "All"]],
        "iDisplayLength": 7,
		
					 "fnRowCallback": function( nRow, aData, iDisplayIndex ) {
            $('td:eq(0)', nRow).html('<a href="show_data.php?id=' + aData[0] + '">' +
                aData[1] + '</a>');
            return nRow;
        },
		"columnDefs": [
            {
                "targets": [ 0 ],
                "visible": false,
                "searchable": false
            }],
					"ajax":{
						url :"employee-grid-data.php", // json datasource
						type: "post",  // method  , by defaultget
						error: function(){  // error handling
							$(".employee-grid-error").html("");
							$("#employee-grid").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
							$("#employee-grid_processing").css("display","none");
							
						}
					}
				} );
			} );
		</script>
        
        <script type="text/javascript" language="javascript" >
			$(document).ready(function() {
				var dataTable = $('#employee-cug-grid').DataTable( {
					"order": [[ 1, "asc" ]],
					"processing": true,
					"serverSide": true,
			//dom: 'Bfrtip',
//        buttons: [
//            'copy', 'csv', 'excel', 'print'
//        ],		
					"aLengthMenu": [[5, 10, 25, 50, 100], [5, 10, 25, 50, 100]],
        "iDisplayLength": 7,
		
		
		
				
					"ajax":{
						url :"employee-cug-grid-data.php", // json datasource
						type: "post",  // method  , by default get
						error: function(){  // error handling
							$(".employee-cug-grid-error").html("");
							$("#employee-cug-grid").append('<tbody class="employee-cug-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
							$("#employee-cug-grid_processing").css("display","none");
							
						}
					}
				} );
			} );
		</script>
</head>
<body>
<?php
if(isset($_POST['chg_pass']))
{
	$upass = $_POST['txt_password'];
	$confpass = $_POST['conf_password'];
	$passhash= password_hash($upass, PASSWORD_BCRYPT);
	

		 
$change_code_yn=0;	  
$sql = "UPDATE ems_administrators SET change_password_yn=?, password=? WHERE id=?";
	
$q = $DB_con->prepare($sql);

$q->execute(array($change_code_yn, $passhash ,$user_logged_in));

$notice="Your Password has been sucessfully changed";

}
?>
  
  <!-- Navbar -->

<?php require("nav_bar.php"); ?>

  <!-- Sidebar -->

  <?php require("side_bar.php"); ?>
  
 
  <!--  Content -->

  <div class="content-wrapper">
  <?php if(isset($notice))
			{
					 ?>
                     <div class="alert alert-danger">
                        <i class="glyphicon glyphicon-warning-sign"></i> &nbsp; <?php echo $notice; ?> !
                     </div>
                     <?php
			} else{ ?>
            
  <?php if($user->changePass==1)
  
{//echo $user->changePass;
	?>
	<div class="card-red text-xs-center m-b-1">
      <div class="card-block">
      
        You must change your password: You will not be able to login again using the Code :
        <!-- Button trigger modal -->
        <button type="button" class="btn btn-primary" data-toggle="modal" data-target="#myModal">
          Change password
        </button>
        
        <!-- Modal -->
        <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
          <div class="modal-dialog" role="document"> 
          <form method="post" action="index.php">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
                <h4 class="modal-title" id="myModalLabel">Change Password</h4>
              </div>
              <div class="modal-body"> 
              
              
              <div class="row">
               <div class="col-lg-12">
              
              
                            
                            <div class="form-group">
                            
                                <input type="password" class="form-control" name="txt_password" placeholder="Your Password" required />
                                <div class="clearfix"></div>
                               
                            </div>
                            <div class="form-group">
                            
                                <input type="password" class="form-control" name="txt_password2" placeholder="Confirm Password" required />
                                <div class="clearfix"></div>
                               
                            </div>
                           
                        
                        </div>
                        </div>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                <button type="submit" name="chg_pass" class="btn btn-primary">Change Password</button>
                
              </div>
              
            </div></form>
          </div>
        </div>
      </div>
    </div>
	
	
<?php }
			}?>


    <ol class="breadcrumb m-b-0">
      <li><a href="index.php">Home</a></li>
      <li>Dashboard</li>
    </ol>
    <?php
if($counttoApp>=1){
    ?>
    <div class="alert alert-danger" role="alert">
  <h4><b>There are outstanding leave application(s) to view/approve</b></h4>
<br>
<a href="get_leave_applications.php">Click here to view list</a>
</div>
     
    <?php

}

             ?>
    <div class="row "><div class="card-group m-b-1 ">
      <div class="card c-t m-a-0">
        <div class="card-block ">
        <ul  style="line-height:20px; margin-bottom:0">
        <li><h6><a class="c-t"href="travelling_officers_expired_dl.php"><?php echo" Travelling officers with expired Drivers License : ". $user->DLEcount ?></li></a></h6>
         <li><h6><a class="c-t" href="travelling_officers_expired_ins.php"><?php echo" Travelling officers with expired Vehicle Insurance : ". $user->Ins_expiryAMT ?></li> </a></h6>
         <li><h6><a class="c-t" href="travelling_officers_expired_fitness.php"><?php echo" Travelling officers with expired Vehicle Fitness : ". $user->Fit_expiryAMT ?></li> </a></h6>
         <li><h6><a class="c-t" href="travelling_officers_expired_registration.php"><?php echo" Travelling officers with expired Vehicle License : ". $user->VehiclelicenceExpAMT ?></li> </a></h6>
         <li><h6><a class="c-t" href="expired_vehicle_declarations.php"><?php echo" Travelling officers with expired Vehicle Declaration : ". $user->VehicleBorExpAMT ?></li> </a></h6>
          </ul>
        </div>
      </div>
      <div class="card m-t m-a-0">
        <div class="card-block">
         <ul  style="line-height:20px; margin-bottom:0">
        <h6><li><a class="c-t"href="stat_declaration_list.php">Employees earning above $3,500,000 per annum</a></li></h6>
         <h6><li><a class="c-t"href="employees_near_retirement_list.php">Employees nearing retirement</a></li></h6>
         <h6><li><a class="c-t"href="employees_granted_seniority.php">Employees with seniorities granted</a></li></h6>
          <h6><li><a class="c-t"href="employees_male.php">Male Employees</a></li></h6>
           <h6><li><a class="c-t"href="employees_female.php">Female Employees</a></li></h6>
          </ul>
        </div>
      </div>
      <div class="card c-t2 m-a-0">
        <div class="card-block">
         
          <a href="hrma_reports/" style="margin:70px 0 0 20px" target="_blank" class="btn btn-primary btn-rounded-deep btn-sm">Go to Reports</a>
        </div>
      </div>
    </div></div>
    <div class="row">
    <div class="col-md-5">
        <div class="card m-t">
          <div class="card-header bg-white center">
            <h5 class="card-title">Employee Search</h5>
            <p class="card-subtitle m-b-0">All Employees</p> 
          </div>
         <table id="employee-grid"  cellpadding="0" cellspacing="0" border="0" class="display" width="100%">
					<thead>
						<tr><th>Employeeid</th>                           
							<th>Firstname</th>
							<th>Lastname</th>
                            <th>ID No.</th>
							<th>Location</th>
                            
						</tr></thead>
			</table>
      </div>
      </div>
      <div class="col-md-4">
        <div class="card">
          <div class="card-block center">
            <h5 class="card-title">Employee Distribution</h5>
            <p class="card-subtitle">by Department</p>
            <div id="emp_dep_count" style="height:300px;padding-bottom:25px;} svg { height:500px;}"></div>
      <a href="#" class="btn btn-primary btn-rounded-deep btn-sm">See Reports</a>
          </div>
        </div>    
      </div>
      <div class="col-md-3">
        <div class="card">
          <div class="card-button-wrapper">
          </div>
          <div class="card-block center">
            <h5 class="card-title">Employees Retirement</h5>
            <p class="card-subtitle">Count by Year</p>
            <div id="emp_ret_sex" style="height:300px;padding-bottom:25px;} svg { height:500px;}"></div>
           <a href="#" class="btn btn-primary btn-rounded-deep btn-sm">See Reports</a>
          

          </div>
        </div>    
      </div>
      
    </div>
    <div class="row">
     <div class="col-md-2">
     <a href="active_staff.php">
        <div class="card-primary">
          <div class="card-block">
            <i class="material-icons pull-xs-right md-48">group</i>
            <h5 class="m-b-0"><?php echo $total_emp ?></h5>
            <p class="m-a-0">Total Active Staff</p>
          </div>
        </div>
        </a>
      </div>
       <div class="col-md-2">
       <a href="employees_on_leave.php">
        <div class="card-primary">
          <div class="card-block">
            <i class="material-icons pull-xs-right md-48">group</i>
            <h5 class="m-b-0"><?php echo $leave_emp?></h5>
            <p class="m-a-0">Employees on Leave</p>
          </div>
        </div></a>
      </div>


<div class="col-md-2">
       <a href="employees_online_leave.php">
        <div class="card-primary">
          <div class="card-block">
            <i class="material-icons pull-xs-right md-48">group</i>
            <h5 class="m-b-0">1</h5>
            <p class="m-a-0">Online Leave Application</p>
          </div>
        </div></a>
      </div>


      <div class="col-md-2"><a href="travelling_officers.php">
        <div class="card-primary">
          <div class="card-block">
            <i class="material-icons pull-xs-right md-48">group</i>
            <h5 class="m-b-0"><?php echo $trav ?></h5>
            <p class="m-a-0">Travelling Officers</p>
          </div>
        </div></a>
      </div>
      <div class="col-md-2"><a href="inactive_staff.php">
        <div class="card-primary">
          <div class="card-block">
            <i class="material-icons pull-xs-right md-48">group</i>
            <h5 class="m-b-0"><?php echo $total_emp_inactive ?></h5>
            <p class="m-a-0">Inactive Staff</p>
          </div>
        </div></a>
      </div>
         <div class="col-md-2"><a href="birthday_staff.php">
        <div class="card-primary">
          <div class="card-block">
            <i class="material-icons pull-xs-right md-48">group</i>
            <h5 class="m-b-0"><?php echo $bdayToday ?></h5>
            <p class="m-a-0">Today's Birthdays</p>
          </div>
        </div></a>
      </div>
    </div>
    <div class="row">
      <div class="col-md-4">
        <div class="card c-t">
          <div class="card-button-wrapper">
            <div class="dropdown">
              <a href="#" class="card-button" data-toggle="dropdown" aria-haspopup="true"
                 aria-expanded="true"><i class="material-icons">more_vert</i></a>
              <div class="dropdown-menu dropdown-menu-right">
                <a class="dropdown-item" href="employees_male.php">View Males</a>
                <a class="dropdown-item" href="employees_female.php">View Females</a>
              </div>
            </div>
          </div>
          <div class="card-block">
            <h5 class="card-title">Gender Distribution</h5>
            <p class="card-subtitle">Mouseover to view</p>

            <div id="donut" style="height:300px;"></div>
          </div>
        </div>
              </div>
              <div class="col-md-4">
        <div class="card m-t">
          <div class="card-button-wrapper">
            <div class="dropdown">
            
              <div class="dropdown-menu dropdown-menu-right">
                <a class="dropdown-item" href="#">View Males</a>
                <a class="dropdown-item" href="#">View Females</a>
              </div>
            </div>
          </div>
          <div class="card-block">
          <h5 class="card-title">Employee Education</h5>
            <p class="card-subtitle">Summary</p>
            <div id="emp_Ed" style="height:300px;padding-bottom:25px;} svg { height:500px;}"></div>
          </div>
        </div>
              </div>
      <div class="col-md-4">
        <div class="card c-t">
            <div class="card-header bg-white">
              <div class="media">
                <div class="media-body ">
                  <h5 class="card-title">Employee CUG List</h5>
                  <p class="card-subtitle"></p>
                </div>
                <div class="media-right media-middle">
                </div>
              </div>
            </div>
             <table id="employee-cug-grid"  cellpadding="0" cellspacing="0" border="0" class="display" width="100%">
					<thead>
						<tr><th>Firstname</th>
							<th>Lastname</th>
							<th>CUG Number</th>
						</tr>
					</thead>
			</table>
        </div>
        
        
      </div>
    </div>
  </div>
   <script src="node_modules/raphael/raphael.js"></script> <!-- Required by CHART (morrisjs) -->
    <script src="node_modules/morris.js/morris.min.js"></script> <!-- Required by CHART (morrisjs) -->

 
<script type="text/javascript">
 
Morris.Bar({
    // ID of the element in which to draw the chart.
    element: 'emp_dep_count',
    // Chart data records -- each entry in this array corresponds to a point
    // on the chart.
    data: <?php echo json_encode($resultBar);?>,
 
    // The name of the data record attribute that contains x-values.
    xkey: 'department',
 
    // A list of names of data record attributes that contain y-values.
    ykeys: ['emp_count'],
 
    // Labels for the ykeys -- will be displayed when you hover over the
    // chart.
	xLabels: 'department',
    labels: ['count'],
 
    barColors: ['#00aae4'],
	
    //xLabels: 'department',
     xLabelAngle: 70,
	 xLabelMargin: 05,
    // Disables line smoothing
    smooth: true,
    resize: true
});
 
 
 Morris.Bar({
    // ID of the element in which to draw the chart.
    element: 'emp_Ed',
    // Chart data records -- each entry in this array corresponds to a point
    // on the chart.
    data: <?php echo json_encode($resultEd);?>,
 
    // The name of the data record attribute that contains x-values.
    xkey: 'qualification_obtained',
 
    // A list of names of data record attributes that contain y-values.
    ykeys: ['emp_count'],
	
     gridTextSize:10,
    // Labels for the ykeys -- will be displayed when you hover over the
    // chart.
	xLabels: 'qualification_obtained',
    labels: ['Count'],
 
    barColors: ['#663333'],
	
    //xLabels: 'department',
     xLabelAngle: 70,
	 xLabelMargin: 05,
    // Disables line smoothing
    smooth: true,
    resize: true
});


Morris.Line({
    // ID of the element in which to draw the chart.
    element: 'emp_ret_sex',
 
    // Chart data records -- each entry in this array corresponds to a point
    // on the chart.
    data: <?php echo json_encode($resultLine);?>,
 
    // The name of the data record attribute that contains x-values.
      xkey: 'RET_YEAR',
 
    // A list of names of data record attributes that contain y-values.
    ykeys: ['ret_count'],
 
    // Labels for the ykeys -- will be displayed when you hover over the
    // chart.
	xLabels: 'retirement_year',
	
    labels: ['Count'],
 
    lineColors: ['#D58665'],
	//lineColors: ['#0b62a4' '#D58665']
    //xLabels: 'department',
     xLabelAngle: 70,
	 xLabelMargin: 20,
    // Disables line smoothing
    smooth: true,
    resize: true
});

Morris.Donut({
  element: 'donut',
  data: <?php echo json_encode($json_data)?>,
    colors: ['#FF5722', '#4CAF50']
  });

	

    </script>
  
  <!-- App JS -->
  <script src="assets/js/sidebar.min.js"></script> <!-- // APP Sidebar -->
  <!-- // END App JS -->
  <!-- Bootstrap JS -->
  <script src="node_modules/tether/dist/js/tether.min.js"></script> <!-- // Tooltips in BS4 -->
  <script src="node_modules/bootstrap/dist/js/bootstrap.min.js"></script> <!-- // BS4-->
  <!-- // END Bootstrap -->
  <?php }?>

</body>
</html>