<?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");
		   
		}
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");

if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="PayMiscFee";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from payinstallment where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
	  

		 
		   $installment_id=mysqli_query($con,"select * from setinstallment where id='".$upuserarr['installment_id']."'");
	  $installment_id=mysqli_fetch_array($installment_id);
	 
	  
	  $upuserresult1=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$installment_id['studentid']."'");
	  $upuserarr1=mysqli_fetch_array($upuserresult1);
		 
	
	
	  
	  
	  
	
	 
}else{
 	  $dovalue="PayMiscFee";
	  $doid='';
} 
?>
<style>
table#t01 tr:nth-child(even) {
    background-color: #eee;
}
table#t01 tr:nth-child(odd) {
   background-color: #fff;
}
table#t01 th {
    background-color: black;
    color: white;
}
</style>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Add Basic Salary <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Add Basic Salary</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">Add Basic Salary <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">
            <div class="col-md-12">

              
             
			    <div class="col-md-12">
                      
                <form action="" method="post" >
				<input type="text" name="mobile" placeholder="Search By 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'");
	  $upuserarr1=mysqli_fetch_array($upuserresult1);

	                  $Query=mysqli_query($con,"select * from leaveemployee where empid='".$mobile."' 
					  AND YEAR(created_at) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
AND MONTH(created_at) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)");

			  		$i = 1;
                     $leavecount=0;
	  				  while($Row=mysqli_fetch_array($Query)){
						  
						  $leavecount=mysqli_query($con,"SELECT DATEDIFF('".$Row['end']."','".$Row['start']."') 
						  ");
						  $leavecount=mysqli_fetch_array($leavecount);
						// print_r($leavecount);
                       $leavecounts=$leavecounts+$leavecount[0]+1;
					  } 
					// echo $leavecounts;
	  
	  
	    $holidays=mysqli_query($con,"select * from holiday where YEAR(created_at) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
AND MONTH(created_at) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)");

			  	
                     $holis=0;
	  				  while($Holiday=mysqli_fetch_array($holidays)){
						  
						  $holi=mysqli_query($con,"SELECT DATEDIFF('".$Holiday['holiday_end']."','".$Holiday['holiday_date']."') 
						  ");
						  $holi=mysqli_fetch_array($holi);
						//print_r($leavecount);
                       $holis=$holis+$holi[0]+1;
					  } 
					// echo $leavecounts;
	  
				?>
				
			
				  <div class="form-group col-md-3">
                 <h3> Name  :              
                 <?php echo $upuserarr1['EmployeeName']."</h3>";?>
                </div> 
                 <div class="form-group col-md-3">
                 <h3> Basic Salary  :              
                 <?php 

				 echo $upuserarr1['basic']."</h3>";
				 
				 $oneday= $upuserarr1['basic']/30;
				 ?>
                </div> 
				 <div class="form-group col-md-3">
                 <h3> Leaves  :              
                 <?php 

				 echo $leavecounts."</h3>";
				 $totalleavs=$leavecounts-1;
				 ?>
                </div> 
				 <div class="form-group col-md-3">
                 <h3> Casual  :              
                 <?php 

				 echo "1</h3>";?>
                </div>
				<!-- <div class="form-group col-md-3">
                 <h3> Holiday  :              
                 <?php 

				 //echo $holis."</h3>";?>
                </div  > -->
				<?php $allsalaryhead1=mysqli_query($con,"select * from employeesalaryhead");
			
	  $numrows=mysqli_num_rows($allsalaryhead1);
	  
	
		  $basic=$upuserarr1['basic'];
		  $dedection=0;
		  $addtion=0;
		  $amountdedection=0;
		  $amountaddtion=0;
		  echo '<table id="t01" style="width: 200px;">';
  echo '<tr><th>TYPE</th><th>Value</th></tr>';
   
  
    


		  while($allsalaryhead=mysqli_fetch_array($allsalaryhead1)){
			
	  ?>
				  <?php echo "<tr><td>".$allsalaryhead['name']."</td>"; ?>               
                 <?php 
				 if($allsalaryhead['calculatetype']=='InPercent'){
					 
				 $pf=$allsalaryhead['valuesd']*$basic/100;
				 echo "<td>".$pf."</td>";
						 if($allsalaryhead['type']=='Deduction')
						 {
							 $dedection=$dedection+$pf;
						 }if($allsalaryhead['type']=='Addition'){
							$addtion=$addtion+$pf; 
						 }
				 }
				 if($allsalaryhead['calculatetype']=='InAmount'){
					echo "<td>".$allsalaryhead['valuesd']."</td></tr>";
					 if($allsalaryhead['type']=='Deduction')
						 {
							 $amountdedection=$allsalaryhead['valuesd'];
						 }if($allsalaryhead['type']=='Addition'){
							$amountaddtion=$amountaddtion+$allsalaryhead['valuesd']; 
						 }
				 }
				 
				 ?>
               
		  <?php }

echo "</table>";		  ?>  
		  
		  <?php 
		  
		  ?>
                <div class="form-group col-md-4">
                 <h3> Total  :<?php

                $dedec=$dedection+$amountdedection;
				//echo $amountdedection."<br>";
				$addt=$addtion+$amountaddtion;
				//echo $addt."<br>";
				$total1=$basic+$addt-$dedec;
				$lesssalary=$totalleavs*$oneday;
				$total=$total1-$lesssalary;
				 echo $total1."</h3>";?>
				 </div>
				
             <div class="form-group col-md-4">
                 <h3> Total Paid :<?php

                
				
				 echo round($total)."</h3>";?>
				 </div>
              
                

				
				                                                          
                
				<?php } ?>
			
			
            </div> 
          </div>   
        </div><!-- /.box -->
      </div><!-- /.col-->
    </div><!-- ./row -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>