<?php 

include ("include/makeSession.php"); 

$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Manage Payrool',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
$_SESSION['page_name']="Payroll Master";

include('include/function.php');

include("include/header.php");

include("include/sidebar.php");

if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){

	$dovalue="";

	$doid=$_REQUEST['did'];

	mysqli_query($con,"delete from leaveemployee where id='$doid'");

	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=leaveemployee.php">';

	exit;

}

if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){

	  $dovalue="Leaveday";

	  $doid=$_REQUEST['upid'];

	  $upuserresult=mysqli_query($con,"select * from leaveemployee where id='".$_REQUEST['upid']."'");

	  $upuserarr=mysqli_fetch_array($upuserresult);

}else{

 	  $dovalue="Leaveday";

	  $doid='';

}

?>

<div class="content-wrapper"> 

  <!-- Content Header (Page header) -->

  <section class="content-header">

    <h1> Leave <small></small> </h1>

    <ol class="breadcrumb">

      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>

      <li><a href="#">Leave</a></li>

    </ol>

  </section>

  <!-- Main content -->

  <section class="content">

    <div class="row">

      <div class="col-md-12">

        <div class="box box-info">

          <div class="box-header">

            <h3 class="box-title"> Leave Entry <small></small></h3>

            <!-- tools box -->

            <div class="pull-right box-tools">

              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>

              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>

            </div>

            <!-- /. tools --> 

          </div>

          <!-- /.box-header -->

          <div class="box-body pad">
<?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-8">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
            <div class="col-md-8">
			                <form action="" method="post" >
				<input type="text" name="mobile" placeholder="Emp Id "
value="<?php if(!empty($_POST['mobile'])){ echo $_POST['mobile']; }else{ } ?>"
				class="form-control col-md-3" style="width:300px;" />
				<input type="submit" value="Search" class="btn btn-primary"/>
                </div> 
				</form>
				<?php 
				$mobile=$_POST['mobile'];
				if(!empty($mobile)){ 
				
				$upuserresult1=mysqli_query($con,"select * from employeeentryform where empid='".$mobile."' and resign='1'");
	  $upuserresult12=mysqli_fetch_array($upuserresult1);
	  $numrows=mysqli_num_rows($upuserresult1);
	 
				}
       if(!empty($numrows)){
				?> 

              <form method="post" action="action2.php" name="addcategory" id="addcategory" enctype="multipart/form-data"  role="form">

                <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />

                <!-- text input -->
			
                      

				
			  <input type="hidden"  name="empid" value="<?php echo $upuserresult12['empid'];?>" />
				  <div class="form-group col-md-6">
                 <h3> Name  :              
                 <?php echo $upuserresult12['EmployeeName']."</h3>";?>
                </div> 
				
				<div class="form-group col-md-6">
                  <h3> Contact No :
                  <?php echo $upuserresult12['ContactNo']."</h3>";?>               
                </div>
				<br/><br/>
                   <div class="form-group col-md-4">

                  <label>Leave Start Date</label>

                  <input name="dates" type="date"  class="form-control" 
				  value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['holiday_date'];}?>" placeholder="Enter Date">

                </div>
				<div class="form-group col-md-4">

                  <label>Leave End Date</label>

                  <input name="holiday_end" type="date"  class="form-control" 
				  value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['holiday_end'];}?>" placeholder="Enter Date">

                </div>
                <div class="form-group col-md-4">

                  <label>Leave Name</label>

                  <input name="name" type="text" id="ContentPlaceHolder1_txt_subtitle" 
				  class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['name'];}?>" 
				  placeholder="Enter Leave ">

                </div>
                
                <div class="form-group col-md-4">

                  <label>Leave Description</label>

              <textarea name="description" class="form-control">
			  <?php if(isset($_REQUEST['upid'])){ echo $upuserarr['description'];}?></textarea>
                </div>

                <div class="box-footer col-md-12">

                  <input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/>

                </div>

              </form>
	   <?php }else{
		  		   echo "<center><h3 style='color:red;'>No Record Found !</h3></center>";
	   } ?>
            </div>

          </div>

        </div>

        <!-- /.box --> 

     </div>
      <!-- /.col--> 

  
    <!-- ./row --> 

  </section>

  <!-- /.content -->

  <section class="content">

    <div class="row">

      <div class="col-xs-12">

        <div class="box">

          <div class="box-header">

            <h3 class="box-title">REPORT</h3>

          </div>

          <!-- /.box-header -->

          <div class="box-body">

            <table id="example1" class="table table-bordered table-striped">

              <thead>

                <tr>

                  <th>No</th>

                  <th scope="col">Emp Id</th>
                  
                    <th scope="col">Leave</th>
                   <th scope="col">Description</th>
				   <th scope="col">Start Date</th>
				   <th scope="col">End Date</th>
				   <th scope="col">Number Of Leave</th>
				    <th scope="col">Creating Date</th>
                  <th scope="col">Action </th>

                </tr>

              </thead>

              <tbody>

                <?php $Query=mysqli_query($con,"select * from leaveemployee");

			  		$i = 1;

	  				  while($Row=mysqli_fetch_array($Query)){
						  
						  $leavecount=mysqli_query($con,"SELECT DATEDIFF('".$Row['end']."','".$Row['start']."')");
						  $leavecount=mysqli_fetch_array($leavecount);
						 // print_r($leavecount);
                        //echo $leavecount[0];
					  ?>

                <tr>

                  <td><?php echo $i; ?></td>

                  <td><?=$Row['empid'];?></td>
                  
                  <td><?=$Row['leavetype'];?></td>
                  <td><?=$Row['description'];?></td>
				     <td><?=$Row['start'];?></td>
					  <td><?=$Row['end'];?></td>
					 
				  <td><?=$leavecount[0]+1;?></td>
				  <td scope="col"><?=$Row['created_at'];?></td>
                  <td><a href="?upid=<?php echo $Row["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; <a href="?did=<?php echo $Row["id"]; ?>"><i class="fa fa-remove text-red"></i></a></td>

                </tr>

                <?php $i++;} ?>

              </tbody>

            </table>

          </div>

          <!-- /.box-body --> 

        </div>

        <!-- /.box --> 

      </div>

      <!-- /.col --> 

    </div>

    <!-- /.row --> 

  </section>


</div>

</div>
<?php include('include/footer.php');?>