<?php include 'inc_classes.php'; 
include "admin_authentication.php";
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Apply Leave</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <!-- Bootstrap 3.3.7 -->
  <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css">
  <!-- daterange picker -->
  <link rel="stylesheet" href="bower_components/bootstrap-daterangepicker/daterangepicker.css">
  <!-- bootstrap datepicker -->
  <link rel="stylesheet" href="bower_components/bootstrap-datepicker/dist/css/bootstrap-datepicker.min.css">
  <!-- iCheck for checkboxes and radio inputs -->
  <link rel="stylesheet" href="plugins/iCheck/all.css">
  <!-- Bootstrap Color Picker -->
  <link rel="stylesheet" href="bower_components/bootstrap-colorpicker/dist/css/bootstrap-colorpicker.min.css">
  <!-- Bootstrap time Picker -->
  <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
  <!-- Select2 -->
  <link rel="stylesheet" href="bower_components/select2/dist/css/select2.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <!-- AdminLTE Skins. Choose a skin from the css/skins
       folder instead of downloading all of them to reduce the load. -->
  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  <!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->
  <!-- Google Font -->
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
  <?php include "include/header-main.php"; ?>
  <!-- Left side column. contains the logo and sidebar -->
  <?php include "include/menu_left.php"; ?>
  <!-- Content Wrapper. Contains page content -->
    <!-- Left side column. contains the logo and sidebar -->
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Apply Leave
        <!--<small>Version 2.0</small>-->
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
      </ol>
    </section>

	<?php
   if($_REQUEST['id'] !='')
   {
     $record_id=$_REQUEST['id'];
     $query="select * from pr_apply_leave where  leave_id='".$record_id."'";
     $ptr_data_2=mysql_query($query);
     $data=mysql_fetch_array( $ptr_data_2);
    //  echo $data['leave_id'];
   }
   else{
    $record_id='';
   }

if(isset($_POST['submit']))
{
	$leave_type=$_POST['leave_type'];
	$reason_leave=$_POST['reason_leave'];
	$no_of_days=$_POST['leave_days'];
	$from_date=$_POST['from_date'];
	$to_date=$_POST['to_date'];
	//$comment=$_POST['comment'];
	//$approved=$_POST['approved_by'];
	$admin_id =$_SESSION['admin_id'];

	$insert_salary="insert into pr_apply_leave (`leave_type`,`reason`,`no_of_days`,`from_date`,`to_date`, `status` ,`admin_id`,`cm_id`,`added_date`) values('".$leave_type."','".$reason_leave."','".$no_of_days."','".$from_date."','".$to_date."','Pending','".$admin_id."','".$_SESSION['cm_id']."','".date('Y-m-d H:i:s')."')";
	$ptr_ins=mysql_query($insert_salary);
  $insert_id=mysql_insert_id();

  //=============================send automated task==================================
    //--------------------Leave apply-------------------------
    $sel_name="select name from site_setting where admin_id='".$admin_id."'";
    $ptr_name=mysql_query($sel_name);
    $data_names=mysql_fetch_array($ptr_name);
    $name=$data_names['name'];
    $where_cms=" and cm_id='".$_SESSION['cm_id']."'";
    if($_SESSION['type']=='S' || $_SESSION['type']=='Z' || $_SESSION['type']=='LD' )
    {
      $where_cms='';
    }
    $task_access='';
    $staff_id='';
    $sel_acc="select * from task_previleges where 1 and privilege_id='411' ".$where_cms." order by access_id desc";
    $ptr_access=mysql_query($sel_acc);
    if(mysql_num_rows($ptr_access))
    {
      $data_staff=mysql_fetch_array($ptr_access);
      $staff_id=$data_staff['admin_id'];
      if($data_staff['minutes']!='')
      {
        $minutes=$data_staff['minutes'];
      }
      else
      {
        $minutes=5;
      }
      if($data_staff['points']!='')
      {
        $points=$data_staff['points'];
      }
      else
      {
        $points=floatval($minutes * 0.21,3);
      }
      if($data_staff['priority']!='')
      {
        $priority=$data_staff['priority'];
      }
      else
      {
        $priority='high';
      }
      if($data_staff['due_date_period']!='')
      {
        $due_date_period=$data_staff['due_date_period'];
        $due_date=date('Y-m-d H:i:s',strtotime('+'.$due_date_period.' days'));
      }
      else
      {
        $due_date=date('Y-m-d H:i:s',strtotime('+2 days'));
      }
    }
    $task_data=array();
    $task_data['on_action']="leave_requested";
    $task_data['task_name']="Leave Requested";
    $task_data['description']="<b>".$name."</b> is applied <b>".$leave_type."</b>. Please check.  ";
    $task_data['hours']=$minutes;
    $task_data['points']=$points;
    $task_data['rating_point']="100";
    $task_data['due_date']=$due_date;
    $task_data['priority']=$priority;
    $task_data['Validation']="valid";
    $task_data['status']="in_progress";
    $task_data['deadline_count']="1";
    $task_data['staff_id']=$staff_id;
    $task_data['admin_id']=$admin_id;
    $task_data['added_date']=date('Y-m-d H:i:s');
    $task_data['cm_id']=$_SESSION['cm_id'];
    $task_data['action_name']="Leave Requested";
    $task_data['action_description']="<b>".$name."</b> is applied <b>".$leave_type."</b>. Please check.  ";
    $task_data['action_id']=$insert_id;
    $task_data['url']="leave_followup_details.php?id=".$insert_id."";
    //print_r($task_data);
    $task_assign=taskScheduler($task_data);
    //---------------------------------------------------

	echo '<div class="callout callout-success"><h4>Tour Leave Application Submitted Successfully</h4></div>';
	?>
	<script type="text/javascript">
		setTimeout('document.location.href="lv_apply_leave.php";',500);
	</script>
	<?php
	
} 
if(isset($_POST['approved']))
{
	$status= "Approved";
	$comment=$_POST['comment'];
    $leave_id=$_POST['leave_id'];

    $insert_salary="UPDATE `pr_apply_leave` set `status`= '$status',`comment`='$comment' where `leave_id`=' $leave_id'";
	$ptr_ins=mysql_query($insert_salary);
}
if(isset($_POST['rejected']))
{

 $status= 'Rejected';
 $comment=$_POST['comment'];
 $leave_id=$_POST['leave_id'];

  $insert_salary="UPDATE `pr_apply_leave` set `status`= '$status',`comment`='$comment' where `leave_id`=' $leave_id'";
	 $ptr_ins=mysql_query($insert_salary);
}
?>   
  
    <!-- Main content -->
    <section class="content">
	
      <!-- SELECT2 EXAMPLE -->
      <div class="box box-default">
        <!--<div class="box-header with-border">
          <h3 class="box-title">Select2</h3>

          <div class="box-tools pull-right">
            <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
            <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-remove"></i></button>
          </div>
        </div>-->
        <!-- /.box-header -->
        <form name="loan_form" method="post" >
            <div class="box-body">
              <div class="row">
                <div class="col-md-6">
                  <div class="form-group">
                    <label>Leave Type</label>
                    <select class="form-control select2" name="leave_type" id="leave_type" style="width: 100%;">
                      <option selected="selected">Select Leave Type</option>
                      <option value="casual_leave">Casual Leave</option>
                      <option value="sick_leave">Sick Leave</option>
                      <option value="privilage_leave">Privilage Leave</option>
                      <option value="compensatory_leave">Compensatory Leave</option>
                    </select>
                  </div>
                  <div class="form-group">
                      <label>Reason for Leave</label>
                      <textarea class="form-control" name="reason_leave" rows="3" placeholder="Enter ..."></textarea>
                  </div>
                </div>
                <!-- /.col -->
                <div class="col-md-6">
                  <div class="form-group">
                    <div class="col-md-6">
                        <label>From Date</label>
                        <div class="input-group date">
                          <div class="input-group-addon">
                            <i class="fa fa-calendar"></i>
                          </div>
                          <input type="text" class="form-control pull-right"  name="from_date" id="datepicker" value="">
                        </div>
                    </div>
                    <div class="col-md-6">
                        <label>To Date</label>
                        <div class="input-group date">
                          <div class="input-group-addon">
                            <i class="fa fa-calendar"></i>
                          </div>
                          <input type="text" class="form-control pull-left" onChange="count_days(this.value)" name="to_date" id="datepicker1" value="">
                        </div>
                    </div>
                  </div>
                
                  <!-- /.form-group -->
                  <div class="form-group">
                      <label>No of Days</label>
                      <input type="text" readonly class="form-control" name="leave_days" id="leave_days" placeholder="" >
                  </div> 
                  
                  
                            
                  <!-- /.form-group -->
                
                <!-- /.col -->
              </div>
                <div class="col-md-12">
                    <input type="submit" name="submit" value="Submit" class="btn btn-block btn-success">
                </div>
              <!-- /.row -->
            </div>
            </form>
            <?php
             
            ?> 


        <!-- /.box-body -->
        <!--<div class="box-footer">
          Visit <a href="https://select2.github.io/">Select2 documentation</a> for more examples and information about
          the plugin.
        </div>-->
      </div>
      
      <div class="row">
        <!-- Left col -->
        <div class="col-md-12">
          <!-- TABLE: LATEST ORDERS -->
          <div class="box box-info">
            <div class="box-header with-border">
              <h3 class="box-title">Past Leaves</h3>

              <div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                </button>
                <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
              </div>
            </div>
            <!-- /.box-header -->
             <div class="box-body">
              <div class="table-responsive">
                <table class="table no-margin">
                  <thead>
                  <tr>
                    <th style="text-align:center !important">Sr. No.</th>
                    <th style="text-align:center !important">Leave Type</th>
                    <th style="text-align:center !important">Reason</th>
                    <th style="text-align:center !important">From Date</th>
                    <th style="text-align:center !important">To Date</th>
                    <th style="text-align:center !important">No of Days</th>
                    <th style="text-align:center !important">Status</th>
					<th style="text-align:center !important">Approved By</th>
                    <th style="text-align:center !important">Follow up</th>
                    
                  </tr>
                  </thead> 
                   <tbody>

                  	<?php
					$sel_app="select * from pr_apply_leave where 1 and cm_id='".$_SESSION['cm_id']."' and admin_id='".$_SESSION['admin_id']."'";
				    $ptr_app=mysql_query($sel_app);
					while($data_app=mysql_fetch_array($ptr_app))
				  	{
						$sel_staff="select name from site_setting where 1 and admin_id='".$data_app['status_updated_by']."'";
					  	$ptr_staff=mysql_query($sel_staff);
					  	$data_staff=mysql_fetch_array($ptr_staff);
						$t++;
					  	?> 
                      	<tr>
                        <td align="center"><?php echo $t; ?></td>
                        <td align="center"><?php echo $data_app['leave_type']; ?></td>
                        <td align="center"><?php echo $data_app['reason']; ?></td>
                        <td align="center"><?php echo $data_app['from_date']; ?></td>
                        <td align="center"><?php echo $data_app['to_date']; ?></td>
                        <td align="center"><?php echo $data_app['no_of_days']; ?></td>

                         
                        <td align="center">
                        <?php 
                        if($data_app['status'] =='Approved' ){
                          ?>
                          <span class="label label-success"><?php echo $data_app['status'] ?> </span>
                          <?php
                        }
                         
                        if($data_app['status'] =='Rejected' ){
                          ?>
                          <span class="label label-danger"><?php echo $data_app['status'] ?> </span>
                          <?php
                        }
                        
                        if($data_app['status'] =='Pending' ){
                          ?>
                          <span class="label label-warning"><?php echo $data_app['status'] ?> </span>
                          <?php
                        }
                        ?>
                        </td>
						<td align="center"><?php echo $data_app['approved_by']; ?></td>
                        <td align="center"><a href="leave_followup2.php?id=<?= $data_app['leave_id']?>" class="fa fa-edit"></a></td> 
                        <!-- <td><a href="leave_followup2.php?id=<?php //$data_app['leave_id']?>" class="fa fa-edit"></a></td>  -->
                             <!-- <input type="hidden" name="leave_id" value="<?php //echo $data_app['leave_id']; ?>">  
                         <td>
                         <button type="submit" name="approved" value="Submit" span class="label label-success">Approved</button> 
                        
                         <button type="submit" name="rejected" value="Submit" span class="label label-danger">Reject</button> 
                       
                        </form></td>
                        <td><?php //echo $data_staff['name']; ?></td>-->
                        
                      </tr> 
                    <?php
				    }
				            ?>
                  </tbody>
                  </table>
                  </div>
              <!-- /.table-responsive -->
                </div>
            <!-- /.box-body -->
                <div class="box-footer clearfix">
              <!--<a href="javascript:void(0)" class="btn btn-sm btn-info btn-flat pull-left">Place New Order</a>
              <a href="javascript:void(0)" class="btn btn-sm btn-default btn-flat pull-right">View All Orders</a>-->
              </div>
            <!-- /.box-footer -->
            </div>
          <!-- /.box -->
        </div>
        <!-- /.col -->
	  </div>
      <!-- /.box -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <?php include "include/footer-main.php"; ?>
</div>

<!-- jQuery 3 -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Select2 -->
<script src="bower_components/select2/dist/js/select2.full.min.js"></script>
<!-- InputMask -->
<script src="plugins/input-mask/jquery.inputmask.js"></script>
<script src="plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="plugins/input-mask/jquery.inputmask.extensions.js"></script>
<!-- date-range-picker -->
<script src="bower_components/moment/min/moment.min.js"></script>
<script src="bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<!-- bootstrap datepicker -->
<script src="bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
<!-- bootstrap color picker -->
<script src="bower_components/bootstrap-colorpicker/dist/js/bootstrap-colorpicker.min.js"></script>
<!-- bootstrap time picker -->
<script src="plugins/timepicker/bootstrap-timepicker.min.js"></script>
<!-- SlimScroll -->
<script src="bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- iCheck 1.0.1 -->
<script src="plugins/iCheck/icheck.min.js"></script>
<!-- FastClick -->
<script src="bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- Page script -->
<script>
  $(function () {
    //Initialize Select2 Elements
    $('.select2').select2()

    //Datemask dd/mm/yyyy
    /*$('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
    //Datemask2 mm/dd/yyyy
    $('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
    //Money Euro
    $('[data-mask]').inputmask()

    //Date range picker
    $('#reservation').daterangepicker()
    //Date range picker with time picker
    $('#reservationtime').daterangepicker({ timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A' })
    //Date range as a button
    $('#daterange-btn').daterangepicker(
      {
        ranges   : {
          'Today'       : [moment(), moment()],
          'Yesterday'   : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
          'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
          'Last 30 Days': [moment().subtract(29, 'days'), moment()],
          'This Month'  : [moment().startOf('month'), moment().endOf('month')],
          'Last Month'  : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
        },
        startDate: moment().subtract(29, 'days'),
        endDate  : moment()
      },
      function (start, end) {
        $('#daterange-btn span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
      }
    )*/

    //Date picker
    $('#datepicker').datepicker({
      autoclose: true,
	  format: 'dd/mm/yyyy',
	  startDate: '-0d',
	  Default: true,
	  todayHighlight: true
    })
	$('#datepicker1').datepicker({
      autoclose: true,
	  format: 'dd/mm/yyyy',
	  Default: true,
	  todayHighlight: true
    })

    //iCheck for checkbox and radio inputs
    $('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
      checkboxClass: 'icheckbox_minimal-blue',
      radioClass   : 'iradio_minimal-blue'
    })
    //Red color scheme for iCheck
    $('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
      checkboxClass: 'icheckbox_minimal-red',
      radioClass   : 'iradio_minimal-red'
    })
    //Flat red color scheme for iCheck
    $('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
      checkboxClass: 'icheckbox_flat-green',
      radioClass   : 'iradio_flat-green'
    })

    //Colorpicker
    $('.my-colorpicker1').colorpicker()
    //color picker with addon
    $('.my-colorpicker2').colorpicker()

    //Timepicker
    $('.timepicker').timepicker({
      showInputs: false
    })
  })
</script>
<script>
  function count_days(to_date)
  {
    var frm_date=document.getElementById("datepicker").value;
    frm_date_split=frm_date.split('/');
    new_frm_date=frm_date_split[1]+'/'+frm_date_split[0]+'/'+frm_date_split[2];

    to_date_split=to_date.split('/');
    new_to_date=to_date_split[1]+'/'+to_date_split[0]+'/'+to_date_split[2];
	
    const dt_date1 = new Date(new_frm_date);
    const dt_date2 = new Date(new_to_date);
	  
	
    var difference_time = dt_date2.getTime() - dt_date1.getTime();
	var diff = parseInt(difference_time / (1000 * 3600 * 24));
    document.getElementById("leave_days").value=diff+1;
    //var daydiff = diff / (1000 * 60 * 60 * 24);   
    //alert("differance days "+diff);
  }
  </script>
</body>
</html>