<?php include("../secure.php"); ?>
<!DOCTYPE html>
<html lang="en" data-layout="vertical" data-topbar="light" data-sidebar="dark" data-sidebar-size="lg" data-sidebar-image="none">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
        <meta name="description" content="Smarthr - Bootstrap Admin Template">
		<meta name="keywords" content="admin, estimates, bootstrap, business, corporate, creative, management, minimal, modern, accounts, invoice, html5, responsive, CRM, Projects">
        <meta name="author" content="Dreamguys - Bootstrap Admin Template">
        <meta name="robots" content="noindex, nofollow">
        <title>Attendance Processing - HR Marsa System </title>
                <style>
@font-face {
    font-family: 'DroidSansArabic';
    src: url('../../font/DroidSansArabic.ttf');
}
body * {
    font-family: "DroidSansArabic", sans-serif ;
}
    </style>
		<?php 
	$lang=$_GET['lang'];  
    $link_lang='lang='.$lang;
    $company_id=$_GET['company_id']; 
    $main_system_id='2222';
	?> 
	
	 <?php include("../languege_filee_hr.php");?>
	 
	 <?php include("../hr_permission.php");?>
	
		<!-- Favicon -->
        <link rel="shortcut icon" type="image/x-icon" href="../../assets/img/favicon.png">
        
        <link rel="stylesheet" href="../../assets/plugins/alertify/alertify.min.css">
        
		<?php
	if($lang=='ar'){
	?>


         <link rel="stylesheet" href="../../assets/css/bootstrap.rtl.min.css">
   
		<!-- Fontawesome CSS -->
        <link rel="stylesheet" href="../../assets/plugins/fontawesome/css/fontawesome.min.css">
    	<link rel="stylesheet" href="../../assets/plugins/fontawesome/css/all.min.css">

		<!-- Lineawesome CSS -->
        <link rel="stylesheet" href="../../assets/css/line-awesome.min.css">
		<link rel="stylesheet" href="../../assets/css/material.css">
		
		<!-- Fontawesome CSS -->
        <link rel="stylesheet" href="../../assets/css/font-awesome.min.css">
		
		<!-- Datatable CSS -->
		<link rel="stylesheet" href="../../assets/css/dataTables.bootstrap4.min.css">
		
		 <!-- Select2 CSS -->
         <link rel="stylesheet" href="../../assets/css/select2.min.css">
         
         <!-- Datetimepicker CSS -->
         <link rel="stylesheet" href="../../assets/css/bootstrap-datetimepicker.min.css">
		
		
		<!-- Main CSS -->
        <link rel="stylesheet" href="../../assets/css/style.css">
             
             
             
             
        <?php }else{ ?>
            <link rel="stylesheet" href="../../assets_en/css/bootstrap.min.css">
   
		<!-- Fontawesome CSS -->
        <link rel="stylesheet" href="../../assets_en/plugins/fontawesome/css/fontawesome.min.css">
    	<link rel="stylesheet" href="../../assets_en/plugins/fontawesome/css/all.min.css">

		<!-- Lineawesome CSS -->
        <link rel="stylesheet" href="../../assets_en/css/line-awesome.min.css">
		<link rel="stylesheet" href="../../assets_en/css/material.css">
		
		<!-- Fontawesome CSS -->
        <link rel="stylesheet" href="../../assets_en/css/font-awesome.min.css">
		
		<!-- Datatable CSS -->
		<link rel="stylesheet" href="../../assets_en/css/dataTables.bootstrap4.min.css">
		
		<!-- Main CSS -->
        <link rel="stylesheet" href="../../assets_en/css/style.css">
        

            <?php } ?>
		
		 
    </head>
    <body>
		<!-- Main Wrapper -->
        <div class="main-wrapper">
		
			<!-- Toper -->
            <?php include("../toper.php"); ?>
			<!-- /Toper -->
			
			<!-- header -->
            <?php include("../header.php");?>
			
			<!-- /header -->
			
			
				<!-- permission View -->
	<?php //if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_add_dept==1)){ ?>			
					<!-- /permission View -->
		
		
			
			<!-- Page Wrapper -->
            <div class="page-wrapper">
			
				<!-- Page Content -->
                <div class="content container-fluid">
				
					<!-- Page Header -->
					<div class="page-header">
					    
						<div class="row align-items-center">
							<div class="col">
								<h3 class="page-title"><?php echo $Attendance_processing; ?></h3>
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="../main/index.php?<?php echo $link_lang; ?>&company_id=<?php echo $company_id; ?>"><?php echo $Dashboard; ?></a></li>
									<li class="breadcrumb-item active"><?php echo $Attendance_processing; ?></li>
								</ul>
							</div>
							<!--div class="col-auto float-end ms-auto">
							 <?php //include("hr_add_holidays_modal.php");?>
							 
							 <?php 
							
							 if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_add_dept==1)){ ?>
								<a href="#" class="btn add-btn" data-bs-toggle="modal" data-bs-target="#add_department"><i class="fa fa-plus"></i><?php  echo $Add_a_public_holiday; ?></a>
							<?php }else{ ?>
							<a href="#" class="btn add-btn up_add" ><i class="fa fa-plus"></i><?php echo $add_dept; ?><?php  echo $hr_add_dept; ?></a>
							<?php }  ?>
							</div-->
							
							<div class="col-auto float-end ms-auto">
							     <?php include("connect_shift_modal.php");?>
								<!--a href="#" class="btn add-btn m-r-5" data-bs-toggle="modal" data-bs-target="#add_custom_policy"><?php echo $Add_attendance_and_leave_Excel; ?></a-->
								<!--a href="#" class="btn add-btn m-r-5" data-bs-toggle="modal" data-bs-target="#add_schedule"> Assign Shifts</a-->
							</div>	
							
							
						</div>
					</div>
					<!-- /Page Header -->
					
			
					
					
					
		<?php 
			if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_attendance_processing==1)){
		     echo'Yes Permation';
			}else{
          // echo 'No Permation'; 
             //header("Refresh:0; url=../main/error_permation.php?$link_lang&company_id=$company_id"); 
			}
			?>
			
			<?php
         if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_attendance_processing==1)){
         }else{
       ?>
             <script>window.location="https://www.marsalogistics.com/new/hr_marsa_system/ar/main/error_permation.php?<?php echo $link_lang; ?>&company_id=<?php echo $company_id;?>"</script>;
          </script>
        <?php } ?> 
			
			
			
					
					<div class="row">
					    
		<div class="alert1" id="messages" style="font-family:'Tajawal',sans-serif;">
		    
         	   <?php if(isset($_SESSION['message'])): ?>
            <div class="alert3 alert3-success">
            <?php echo $_SESSION['message']; ?>
            <script>
    setTimeout(function() {
        let alert = document.querySelector(".alert3");
            alert.remove();
    }, 3000);
    </script>
           </div>
            <?php endif; ?>
           <?php unset($_SESSION['message']); ?></div>
			
			
			<?php
			   $modal_table_name='hr_waseet_employ_shift_tbl';
              
                $id_name='waseet_id';
                  $proccess_details_delete='حذف شفت الموظف رقم  '.$modal_id;
                   $proccess_details_en_delete='Delete Shift Employee Number'.$modal_id;
                  $proccess_details_delete_disable='الغاء تنشيط فت الموظف رقم '.$modal_id;
                $proccess_details_en_delete_disable='Disable Shift Employee Number'.$modal_id;
               
                $proccess_details_enable=' تنشيط شفت الموظف رقم '.$modal_id;
                 $proccess_details_en_enable='Enable Shift Employee Number'.$modal_id;        
			
			?>		    
			<input type="hidden" name="modal_table_name" id="modal_table_name" readonly value="<?php echo $modal_table_name; ?>"> 
            <input type="hidden" name="id_name" id="id_name" readonly value="<?php echo $id_name; ?>"> 
           <input type="hidden" name="proccess_details_delete" id="proccess_details_delete" readonly value="<?php echo $proccess_details_delete; ?>"> 
           <input type="hidden" name="proccess_details_en_delete" id="proccess_details_en_delete" readonly value="<?php echo $proccess_details_en_delete; ?>">
           
           
              <input type="hidden" name="$proccess_details_delete_disable" id="proccess_details_delete_disable" readonly value="<?php echo $proccess_details_delete_disable; ?>"> 
           <input type="hidden" name="proccess_details_en_delete_disable" id="proccess_details_en_delete_disable" readonly value="<?php echo $proccess_details_en_delete_disable; ?>">
           
           
           <input type="hidden" name="proccess_details_enable" id="proccess_details_enable" readonly value="<?php echo $proccess_details_enable; ?>"> 
           <input type="hidden" name="proccess_details_en_enable" id="proccess_details_en_enable" readonly value="<?php echo $proccess_details_en_enable; ?>">
           

           
            <?php  $info_type=$_GET['info_type'];  
                //echo $info_type;
                if($info_type=='takeed' or($info_type=='')){$classb='nav-link b active';}else{$classb='nav-link b ';}
                if($info_type=='pr'){$classc='nav-link b active';}else{$classc='nav-link b ';}
                if($info_type=='gh'){$classd='nav-link b active';}else{$classd='nav-link b ';}
                
                ?>
           		
				<div class="card">
				<div class="card-body">
				<!-- <h4 class="card-title">Solid justified</h4> -->
				<ul class="nav nav-tabs nav-tabs-solid nav-justified">
				<!--li class="nav-item"><a class="<?php echo $classb; ?>" href="hr_attendance_processing.php?<?php echo $link_lang; ?>&company_id=<?php echo $company_id; ?>&info_type=<?php echo 'takeed'; ?>" id="active_employ">تم التأكيد<?php //echo $Add_attendance_and_leave_Excel; ?> <span class="spinner-border spinner-border-sm me-2" role="status" id="loaderr" style="display: none;"></span></a></li-->
				<li class="nav-item"><a class="<?php echo $classc; ?>"href="hr_attendance_processing.php?<?php echo $link_lang; ?>&company_id=<?php echo $company_id; ?>&info_type=<?php echo 'pr'; ?>" id="inactive_employ">تسجيل حضور بدون انصراف او العكس<?php //echo $shifts_connect_employ; ?> </a></li>
				<li class="nav-item"><a class="<?php echo $classd; ?>"href="hr_attendance_absencee_vacation.php?<?php echo $link_lang; ?>&company_id=<?php echo $company_id; ?>&info_type=<?php echo 'gh'; ?>" id="inactive_employ">الغياب او عدم تسجيل حضور و انصراف<?php //echo $shifts_connect_employ; ?> </a></li>
               	<!--li class="nav-item"><a class="<?php echo $classe; ?>"href="hr_attendance_processing.php?<?php echo $link_lang; ?>&company_id=<?php echo $company_id; ?>&info_type=<?php echo 'mo'; ?>" id="inactive_employ">تأكيد المسائلات<?php //echo $shifts_connect_employ; ?>
               	</a></li--> 
               	

				</ul> 
						</div>
					</div> 
           
           
           
           		 <form  action="" method="post" >
           		     
           		   <?php 
           		   if(ISSET($_POST['sav_btn'])){
           		    $date_from=$_POST['date_from']; // echo $date_from; 
	                $date_to=$_POST['date_to'];     //echo $date_to;
           		   }else{
           		    $date_from=0; 
           		    $date_to=0;
           		   }
           		   
           		        $without_type=$_POST['without_type'];   //echo $without_type;
           		   
           		   ?>  
           		     
				<div class="row filter-row">
						<div  class="col-md-6 col-sm-6 col-lg-6 col-xl-3"  clas="col-lg-4 col-sm-6 col-12" clas="col-sm-6 col-md-3"> 
					<div class="form-group form-focus select-focus focused">
						<input type="date" value="<?php echo $date_from; ?>" name="date_from" id="date_from" class="form-control" style="font-size:14px; font-weight:bold;">
					<label class="focus-label"><?php echo $date_fromm; ?></label>
				   	</div>
				</div>
						
						<div class="col-md-6 col-sm-6 col-lg-6 col-xl-3"  clas="col-lg-4 col-sm-6 col-12" clas="col-sm-6 col-md-3"> 
						<div class="form-group form-focus select-focus focused">
						<label class="focus-label"><?php echo $date_too; ?></label>
							<input type="date" value="<?php echo $date_to; ?>" name="date_to" id="date_to" class="form-control" style="font-size:14px; font-weight:bold;" >
							</div>
						</div>
						
						
						
	<?php 
	$ar = array();
    $add = array();
     $holiday_dates = array();
     
     
     
	
	 
	 function getBetweenDates($startDate, $endDate) {
    $rangArray = [];
 
    $startDate = strtotime($startDate);
    $endDate = strtotime($endDate);
 
    for ($currentDate = $startDate; $currentDate <= $endDate; $currentDate += (86400)) {
        $date = date('Y-m-d', $currentDate);
        $rangArray[] = $date;
    }
 
    return $rangArray;
 } 
 
  
 $dates = getBetweenDates($date_from, $date_to);

//print_r($dates);
	 
	if(ISSET($_POST['sav_btn'])){
	    
     date_default_timezone_set("Asia/Riyadh");
     $dd1=strtotime($date_from);
     $dd2=strtotime($date_to);
   $datediff = $dd2 - $dd1;
   $add_ayam=round($datediff / (60 * 60 * 24)+1);
   //echo $add_ayam ;
   


$from_date = new DateTime($date_from);
$to_date = new DateTime($date_to);
$i = 0;
for ($date = $from_date; $date <= $to_date; $date->modify('+1 day')) {
    $d = $date->format('l');
  if($d=="Friday"){
      $i++;
  }
}

 
 // صافي عدد الأيام
 
   $safy_ayam=$add_ayam-$i; 
     
	}     
     
	?>		
	
	
		<div class="col-md-6 col-sm-6 col-lg-6 col-xl-3" clas="col-lg-9">
								<select style="font-size:18px; font-weight:bold;" name="without_type" id="without_type" class="form-select form-select-lg mb-3" clas="form-select" >
                                 <option value="pending"><?php echo $pending; ?></option>
                                 <option value="done"><?php echo $Processing_Done; ?></option>
                                </select>	
														
									</div>
									
									
						
						<div class="col-md-6 col-sm-6 col-lg-6 col-xl-3">  
							<div class="d-grid">
								<input type="submit" name="sav_btn" id="sav_btn" class="btn btn-success" value="<?php echo $search; ?>"> 
							</div></form>
						</div>     
                    </div>
                    
            
             <div class="card">
		  <div class="card-body"> 
		  <div class="row"> 
		  	<div class="col-lg-4 col-sm-6 col-12"> 
		  	<label><?php echo $count_the_days; ?>/ </label>
		  <?php echo $add_ayam; ?>
		  	 </div> 

		  	 	<div class="col-lg-4 col-sm-6 col-12">
		  	 	<label><?php echo $The_number_of_Fridays; ?>/ </label>	
		  <?php echo $i; ?>
		  	 </div> 
		  	 	<div class="col-lg-4 col-sm-6 col-12"> 
		  	 	<label><?php echo $net_number_of_days; ?>/ </label>
		  	<?php echo $safy_ayam; ?>
		  	 </div>	 
		  	 
		  
		  </div>
		  </div>
		 </div>  
		 
		   	<div class="card">
		  <div class="card-body">
		      
		      
		      
              <div class="row">
           
        <div class="col-md-6 mb-3">
			<div class="form-group">
		<?php  if($without_type=='pending'){ ?>	<label style="font-size:18px; font-weight:bold;"> <?php echo $pending; ?> </label>
		
		<?php }elseif($without_type=='done'){ ?>
			<label style="font-size:18px; font-weight:bold;"> <?php echo $Processing_Done; ?> </label>
				<?php } ?>
			</div>
		   </div> 
		   
		
		 <?php  if($without_type=='pending'){ ?>			
		<div class="col-md-6 mb-3">
           <!-- ==========dropdown action========================================== -->
           <?php if($lang=='ar'){ ?><div class="btn-group" style="float:left;"><?php }else{ ?>
           <div class="btn-group" style="float:right;"><?php } ?>
			<button type="button" class="btn btn-success dropdown-toggle" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><?php echo $Options; ?></button>
			<div class="dropdown-menu" style="">
			<a class="dropdown-item btn_takeed" id="btn_exception" href="javascript:void(0);">إستثناء</a>
			<a class="dropdown-item" id="btn_mosala" href="javascript:void(0);">إرسال مسائله</a>
			<div class="dropdown-divider"></div>
			<a class="dropdown-item" id="absence" href="javascript:void(0);"><?php echo $absence; ?></a>
			</div>
			</div>
           <!-- ==========/dropdown action========================================== -->
           	</div>
			</div>
			 <?php } ?>
				</div>  
				
					</div>
					
						</div>

						<div class="col-md-12">
							<div>
							    <div class="table-responsive">
							    <table class="table  datanew table-striped mb-0">
								<!--table class="table table-striped custom-table mb-0 datatable" -->
                                <thead>
										<tr>
											<th>
												<label class="checkboxs">
													<input type="checkbox"style="width:20px;height:20px;" class="all_ch_att" name="all_ch_att" id="all_ch_att">
													<span class="checkmarks"></span>
												</label>
											</th>
											<th><?php echo $id; ?></th>
											<th><?php echo $Employee_data; ?></th>
											<th><?php echo $Shift_Details; ?></th>
										     <th><?php echo $the_date; ?></th>
									     	<th><?php echo $type; ?></th>
									     	<th><?php echo $Employee_Justification; ?></th> 
									     	<th style="font-size:12px;"><?php echo $attachments; ?></th>
											<th><?php echo $status; ?></th>
											<!--th>Action</th-->
										</tr>
									</thead>
									<tbody>
                   			  <?php 
                   		 
				//  if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($view_employees_ul==1)){
				// 	if($company_id=='all_company'){
    //               $sql_cw="SELECT * FROM waseet_company_user_tbl where system_id='2222' and company_id IN ('$ids') AND company_id!='' AND deleted='0'  GROUP BY user_id  ORDER BY `waseet_company_user_tbl`.`crateddate_time` DESC";
    //                 }else{
    //               $sql_cw="SELECT * FROM waseet_company_user_tbl where system_id='2222' and company_id='$company_id'AND company_id!='' AND deleted='0'  GROUP BY user_id ORDER BY `waseet_company_user_tbl`.`crateddate_time` DESC";
    //                 }
                    
    //               }else{
    //                   $sql_cw="SELECT * FROM waseet_company_user_tbl where system_id='2222' and user_id='".$urow['user_id']."'AND company_id!='' AND deleted='0' GROUP BY user_id ORDER BY `waseet_company_user_tbl`.`crateddate_time` DESC";  
    //               }
                   
                   
                    if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($view_employees_ul==1)){
					if($company_id=='all_company'){
                  $sql_cw="SELECT * FROM hr_employ_tbl where system_id='2222' and company_id IN ('$ids') AND company_id!='' AND deleted='0' ORDER BY `hr_employ_tbl`.`employ_name_ar` DESC ";
                    }else{
                  $sql_cw="SELECT * FROM hr_employ_tbl where system_id='2222' and company_id='$company_id'AND company_id!='' AND deleted='0' ORDER BY `hr_employ_tbl`.`employ_name_ar` DESC ";
                    }
                    
                  }else{
                      $sql_cw="SELECT * FROM hr_employ_tbl where system_id='2222' and employ_id='".$urow['user_id']."'AND company_id!='' AND deleted='0' ORDER BY `hr_employ_tbl`.`employ_name_ar` DESC";  
                  }
     
                    
                   $result_cw = $conn->query($sql_cw);
                   if ($result_cw->num_rows > 0) {
                    while($row_cw = $result_cw->fetch_assoc()) {
                    //echo $row_cw['employ_id']; 
                    
                    
                    
            
                    
                    
                  
                     $sql_ws="SELECT * FROM hr_waseet_employ_shift_tbl where company_id='".$row_cw['company_id']."' AND deleted='0' and stop='0' and waseet_stat='0'  ";
                          $result_ws = $conn->query($sql_ws);
                           if ($result_ws->num_rows > 0) {
                            while($row_ws = $result_ws->fetch_assoc()) { 
                             $modal_id=$row_ws['waseet_id'];
                                //shift
                             
                                $sql_sh="SELECT * FROM hr_shift_tbl where shift_id='".$row_ws['shift_id']."' AND hodoor_ghyab='0' AND stop='0' AND deleted='0'  ";
                                 $result_sh = $conn->query($sql_sh);
                                 if ($result_sh->num_rows > 0) {
                                while($row_sh = $result_sh->fetch_assoc()) {
                                 

                                   $sat = $row_sh['sat'];
                                   $sun = $row_sh['sun'];
                                   $mon = $row_sh['mon'];
                                   $tue = $row_sh['tue'];
                                   $we = $row_sh['we'];
                                   $thu = $row_sh['thu'];
                                   $fr = $row_sh['fr'];

                                  
                                  
                                
                                    
                             
                                //end shift
                                  // حساب العطل الرسميه
                                if($company_id=='all_company'){
                                    $sql_holiday_w="SELECT * FROM holidays_waseet_tbl where company_id IN ('$ids') AND company_id!='' AND deleted='0'  ";
                
                                    }else{
                                 $sql_holiday_w="SELECT * FROM holidays_waseet_tbl where company_id='$company_id' AND company_id!='' AND deleted='0'  ";
                                    }
                                $result_holiday_w = $conn->query($sql_holiday_w);
                                if ($result_holiday_w->num_rows > 0) {
                               while($row_holiday_w = $result_holiday_w->fetch_assoc()) {
                              
                                $sql_holiday="SELECT * FROM holidays_tbll where holiday_id='".$row_holiday_w["holiday_id"]."' and stop='0' and deleted='0'";
                                $result_holiday = $conn->query($sql_holiday);
                                if ($result_holiday->num_rows > 0) {
                               while($row_holiday = $result_holiday->fetch_assoc()) {
                                
                                array_push($holiday_dates,$row_holiday["holiday_date"]);
                               }}
                            }}
                                //
                              
                    $sql_emp="SELECT * FROM hr_employ_tbl where  employ_id='".$row_ws['employ_id']."' and  employ_stat='active_employ' AND stop='0' and employ_id='".$row_cw['employ_id']."' AND deleted='0' group by employ_id ORDER BY `hr_employ_tbl`.`employ_name_ar` DESC ";
                          $result_emp = $conn->query($sql_emp);
                           if ($result_emp->num_rows > 0) {
                            while($row_emp = $result_emp->fetch_assoc()) {   
                                 
                          if($lang=='ar'){$employ_name=$row_emp['employ_name_ar'];}else{$employ_name=$row_emp['employ_name_en'];}
                          
                          $employee_number_fingerprint = $row_emp['employee_number_fingerprint'];
                           $date_commencement=$row_emp["date_commencement"];
                     array_push($ar,$employee_number_fingerprint);
                  foreach ($dates as $val) {
                    
                       if (in_array($val, $holiday_dates)) {

                    }else{
                    $day_num = date('N', strtotime($val));
                    $day_name = date('l', strtotime($val));
                    $today_date = date("Y-m-d");
                    if($val>$today_date || $val=="1970-01-01"){
                    }elseif($val<$date_commencement){
                        
                    }else{
                    if($day_name=="Saturday" & $sat==0){ ?>
                       
                       <?php }elseif($day_name=="Sunday" & $sun==0){ ?>
                      
                       <?php }elseif($day_name=="Monday" & $mon==0){ ?>
                        
                      <?php  }elseif($day_name=="Tuesday" & $tue==0){ ?>
                       
                      <?php  }elseif($day_name=="Wednesday" & $we==0){ ?>
                       
                      <?php  }elseif($day_name=="Thursday" & $thu==0){ ?>
                       
                      <?php }elseif($day_name=="Friday" & $fr==0){ ?>
                       
                      <?php }else{
                          
                         // echo $val.'<br>';
                        
                        //$done_stat='hodor_ensraf_stat=Answered_by_the_employee or hodor_ensraf_stat=exception_ghyab or hodor_ensraf_stat=Absence_was_approved or hodor_ensraf_stat=Absence_was_rejected ' ;
                        
                       //  $done_stat='hodor_ensraf_stat=Answered_by_the_employee or hodor_ensraf_stat=exception_ghyab or hodor_ensraf_stat=Absence_was_approved or hodor_ensraf_stat=Absence_was_rejected ' ;
                        
                        
                    $sql_add="SELECT * FROM hr_add_hodor_ensraf_tbl where hodor_ensraf_date='$val' and employee_number_fingerprint='$employee_number_fingerprint'";
                        
                    //       if($without_type=='pending'){
                    //       $sql_add="SELECT * FROM hr_add_hodor_ensraf_tbl where hodor_ensraf_date='$val' and employee_number_fingerprint='$employee_number_fingerprint'";
                    //     }elseif($without_type=='done'){
                    //      $sql_add="SELECT * FROM hr_add_hodor_ensraf_tbl where hodor_ensraf_date BETWEEN '$date_from' AND '$date_to' and employee_number_fingerprint='$employee_number_fingerprint'  ";
                    //     }else{
                    //   $sql_add="SELECT * FROM hr_add_hodor_ensraf_tbl where hodor_ensraf_date='$val' and employee_number_fingerprint='555555555'";
                    //     }
                         
                          $result_add = $conn->query($sql_add);
                          if ($result_add->num_rows > 0) {
                          while($row_add = $result_add->fetch_assoc()) { 
                              
                           $hodor_ensraf_stat=$row_add['hodor_ensraf_stat'];
                           
					         ?> 
				 <!-- ==================tr done========================================================================== -->   
				 <?php if(($without_type=='done') && ($row_add['hodor_ensraf_stat']=='ghyab' or $row_add['hodor_ensraf_stat']=='Answered_by_the_employee' or $row_add['hodor_ensraf_stat']=='exception_ghyab' or $row_add['hodor_ensraf_stat']=='Absence_was_approved' or $row_add['hodor_ensraf_stat']=='Absence_was_rejected')){  ?>
				 
				 <tr class="D<?php echo $row_add['hodor_ensraf_id']; ?>">
											<td>
											    
											    <?php //echo $row_add['hodor_ensraf_id']; ?>
												<label class="checkboxs">
                                                    <?php 
                                                   //echo $row_emp["employ_id"].$val;
                                                    ?>
													<input type="checkbox" style="width:20px;height:20px;" class="ch_att" name="ch_att" id="ch_att" value="<?php echo $row_emp["employ_id"].$val; ?>">
													<span class="checkmarks"></span>
                                                    <input type="hidden" style="width:20px;height:20px;" class="employ_id" name="employ_id" id="employ_id<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $row_emp["employ_id"]; ?>">
                                                    <input type="hidden" style="width:20px;height:20px;" class="employee_number_fingerprint" name="employee_number_fingerprint" id="employee_number_fingerprint<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $row_emp["employee_number_fingerprint"]; ?>">
												</label>
												
											<?php 
										//	echo $employee_number_fingerprint."(".$employ_name.")".":".$row_emp["employ_id"]."</br>";
											?>	
										
											</td>
						 <td>
						    <?php echo  $row_add['hodor_ensraf_id']; ?><br>
						 
							<h2 class="table-avatar">
							
							<a class="avatar" clas="avatar avatar-xs" href="profile.html">
							<?php
							$attach_link=0;
                          $sql_ico="SELECT * FROM hr_employ_attachments_tbl where employ_id='".$row_emp['employ_id']."' AND att_name='employ_photo' AND  stop='0' AND deleted='0' ";
                          $result_ico = $conn->query($sql_ico);
                           if ($result_ico->num_rows > 0) {
                            while($row_ico = $result_ico->fetch_assoc()) {
                              $attach_link=$row_ico['attach_link'];  
                            }}
                             ?>  
                               <?php if($attach_link==''){ ?>  
								<img alt="" src="../../assets/img/profiles/avatar-09.jpg">
								<?php }elseif($attach_link!=''){ ?>
								<img alt="" src="../../../Shipping_Clearance_System/jquery/pages/system_maintenance/user_img/<?php echo $attach_link; ?>">
							<?php }else{ ?>
							<img alt="" src="../../assets/img/profiles/avatar-09.jpg">
							<?php } ?>
								
								</a>
							
						  
							  </h2>
								</td>
								
						
								
								<td>
								<a href="profile.html"><?php echo $employ_name; ?></a><br>
								<input  type="hidden" readonly="readonly" name="employ_id" id="employ_id<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['employ_id']; ?>">
                            	<input  type="hidden" readonly="readonly" name="employ_name_ar" id="employ_name_ar<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['employ_name_ar']; ?>">
							   	<input  type="hidden" readonly="readonly" name="employ_name_en" id="employ_name_en<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['employ_name_en']; ?>">
							    <input  type="hidden" readonly="readonly" name="mobile_number" id="mobile_number<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['mobile_number']; ?>">
							    
							    <?php $mosala_type='ghyab';  ?>
							    <input  type="hidden" readonly="readonly" name="mosala_type" id="mosala_type<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $mosala_type; ?>">

							    

								 <small class="text-muted" style="font-size:12px;">
									 <?php
                                             $sql_cy="SELECT * FROM main_company_tbl where company_id='".$row_emp['company_id']."' ";
                                             $result_cy = $conn->query($sql_cy);
                                             if ($result_cy->num_rows > 0) {
                                             while($row_cy = $result_cy->fetch_assoc()) {
                                                if($lang=='ar'){$company_name=$row_cy['company_name_ar'];}else{$company_name=$row_cy['company_name_en'];} 
                                            echo $company_name;     
                                             }}
                                            // echo $row_emp['company_id'];
                                               ?> 
								<br>	
								   <?php 
					             $sql_c="SELECT * FROM dept_tb where dept_id='".$row_emp['dept_id']."' AND dept_id!='0' ";
                                  $result_c = $conn->query($sql_c);
                                  if ($result_c->num_rows > 0) {
                                   while($row_c = $result_c->fetch_assoc()) {
                                  if($lang=='ar'){$dept_name=$row_c['dept_name'];}else{$city_name2=$row_c['dept_name_en'];} 
                                        echo $dept_name;     
                                    }}
					            ?>-
					         	<?php if($row_cw['user_type']=='Top_Manager' or $row_cw['user_type']=='System_Manager'){ echo $row_cw['user_type'];
					         	}else{ ?>
									      <?php 
									     $sql_jo="SELECT * FROM job_tb where job_id='".$row_emp['job_id']."' AND job_id!='0' ";
                                         $result_jo = $conn->query($sql_jo);
                                         if ($result_jo->num_rows > 0) {
                                         while($row_jo = $result_jo->fetch_assoc()) {
                                          if($lang=='ar'){$job_name=$row_jo['job_name'];}else{$job_name=$row_jo['jop_name_en'];} 
                                          echo $job_name;
                                         //echo $row_jo['job_id'];
                                         
                                         }}else{ echo $no_jop;}
									     ?><?php } ?>
									</small><br>
									<small class="m3"><?php echo $row_emp['id_num']; ?></small>
								</td>		
								
								
								
											
							<td>
									  <?php 
									   $sql_sh="SELECT * FROM hr_shift_tbl where shift_id='".$row_ws['shift_id']."' AND stop='0' AND deleted='0'  ";
                                        $result_sh = $conn->query($sql_sh);
                                        if ($result_sh->num_rows > 0) {
                                       while($row_sh = $result_sh->fetch_assoc()) {
                                        if($lang=='ar'){$shift_name=$row_sh['shift_name_ar'];}else{$shift_name=$row_sh['shift_name_en'];}
                                       $min_start_time=$row_sh['min_start_time'];
                                        $start_time=$row_sh['start_time'];
                                         $max_start_time=$row_sh['max_start_time'];
                                         
                                          $min_end_time=$row_sh['min_end_time'];
                                        $end_time=$row_sh['end_time'];
                                         $max_end_time=$row_sh['max_end_time'];
                                         
                                         $number_hours=$row_sh['number_hours'];
                                         
                                       }}   
                                           
									  ?>
									  <small style="font-size:12px;"><?php echo $shift_name;  ?></small><br>
									  <small style="font-size:12px;"><?php echo $min_start_time; ?>-<?php echo $start_time; ?>-<?php echo $max_start_time; ?></small><br>
									   <small style="font-size:12px;"><?php echo $min_end_time; ?>-<?php echo $end_time; ?>-<?php echo $max_end_time; ?></small>
									</td>
								
									<td>
									<small style="font-size:14px;" dir="ltr"><?php  echo $val; ?>
									
									</small>
								
									<input  type="hidden" readonly="readonly" name="hodor_ensraf_date" id="hodor_ensraf_date<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $val; ?>">
									</td>			
					     
                         
                         	<td>
                             <span class="task-priority badge bg-inverse-danger"><?php echo $absence; ?></span>
                              </td>	
											    
					 <td>
                      
							<?php 
							$employee_reply=0;
							 $sql_q="SELECT * FROM hr_question_tbl where hr_question_type='ghyab'AND employ_id='".$row_ws['employ_id']."'AND hr_question_date='$val' AND stop='0' AND deleted='0'  ";
                             $result_q = $conn->query($sql_q);
                              if ($result_q->num_rows > 0) {
                                  $check_question=1;
                              while($row_q = $result_q->fetch_assoc()) {
                         
                            $employee_reply=$row_q['employee_reply'];
                                  
                              $hr_question_stat=$row_q['hr_question_stat']; //echo $hr_question_stat;   
                             
                             $hr_question_id=$row_q['hr_question_id'] ;
                              
                              }}else{$check_question=0;}
                             
                           //  echo $check_question; 
                              
							?> 
                         
                         <?php if($check_question=='1'){ ?>
                            <small style="width:50px;" clas="small doj text-muted"> 
							<textarea readonly name="notes" id="notes" class="form-control" style="width: 200px;overflow: scroll; font-size:12px;">
							 <?php echo $employee_reply ; ?></textarea>	
							 </small><?php } ?>
                        
                         </td>
                         
                         <td clas="text-end">
							<?php
                          $sql_ico="SELECT * FROM hr_employ_attachments_tbl where employ_id='".$row_ws['employ_id']."' AND attach_type='219231' AND connect_id='".$hr_question_id."' AND  stop='0' AND deleted='0' ";
                          $result_ico = $conn->query($sql_ico);
                           if ($result_ico->num_rows > 0) {
                            while($row_ico = $result_ico->fetch_assoc()) {
                              $attach_link=$row_ico['attach_link']; 
                              $attach_id=$row_ico['attach_id']; 
                              $att_name=$row_ico['att_name'];
                              //echo  $attach_id.'<br>';
                             ?>

                             <ul class="team-members">
									<li>
									<?php if($row_ico['file_type']=='image/png' or $row_fil['file_type']=='image/jpeg'){ ?><a href="../hr_files/<?php echo $row_ico['attach_link']; ?>" target="_new" data-bs-toggle="tooltip" title="" data-bs-original-title="<?php echo $att_name; ?>" aria-label="John Doe"><img alt="" src="../hr_files/<?php echo $row_ico['attach_link']; ?>">
									 <?php echo $att_name; ?>
									</a>
									<?php }else{ ?>
									<a href="../hr_files/<?php echo $row_ico['attach_link']; ?>" target="_new" data-bs-toggle="tooltip" title="" data-bs-original-title="<?php echo $att_name; ?>" aria-label="John Doe"><img alt="" src="../../assets/img/profiles/avatar-02.jpg">
									 <?php echo $att_name; ?>
									</a>
									<?php } ?>
									</li>
											
										</ul>
                             
							<?php }}  ?>
							</td> 	 
                         
				
											
					<td> <?php //echo $hodor_ensraf_stat.'<br>'; ?>
	 
					
					<?php if($hodor_ensraf_stat=='Answered_by_the_employee'){ ?>
					<span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-success"></i> <?php echo $Answered_by_the_employee; ?>
					</a></span>
					
							<?php }elseif($hodor_ensraf_stat=='exception_ghyab'){ ?>
					<span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-danger"></i> <?php echo $An_exception_was_made_for_absence; ?>
						</a></span>
						
						
									<?php }elseif($hodor_ensraf_stat=='Absence_was_approved'){ ?>
					<span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-success"></i> <?php echo $Has_been_approved; ?>
						</a>	</span>
						
						
						<?php }elseif($hodor_ensraf_stat=='Absence_was_rejected'){ ?>
					<span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-success"></i> <?php echo $The_employee_was_rejected_and_registered_absent; ?>
						</a></span> 
						
						
							<?php }elseif($hodor_ensraf_stat=='ghyab'){ ?>
					<span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-danger"></i> <?php echo $The_employee_has_been_registered_absent; ?>
						</a></span>
						<?php } ?>
					
					</div>
					</td>
											
											<!--td class="text-end">
											    
											 <?php //include("../modals/hr_delete_modal.php");?>   
											 <?php //include("hr_edit_holidays_modal.php");?>
											    	
										<div class="dropdown dropdown-action">
										<a href="#" class="action-icon dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false"><i class="material-icons">more_vert</i></a>
										<div class="dropdown-menu dropdown-menu-right" style="">
											<?php if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_edit_dept==1)){ ?>  
										<a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#edit_holday<?php echo $modal_id; ?>"><i class="fa fa-pencil m-r-5"></i> <?php echo $edit; ?></a>
										<?php }else{ ?>
										<a class="dropdown-item up_add" href="javascript:void(0);" ><i class="fa fa-pencil m-r-5"></i> <?php echo $edit; ?></a>
									    <?php } ?>
									    
									    <?php if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_delete_dept==1)){ ?>  
										<a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#delete_modal<?php echo $modal_id; ?>"><i class="fa fa-trash-o m-r-5"></i> <?php echo $delete; ?></a>
											<?php }else{ ?>
										<a class="dropdown-item up_add" href="javascript:void(0);" ><i class="fa fa-pencil m-r-5"></i> <?php echo $delete; ?></a>
									    <?php } ?>
													</div>
												</div>	
												</td-->
				
										</tr>
				 
		    	 <!-- ==================/tr done========================================================================== -->   
	                  <?php } ?>
				 
                                       
                 <?php  }}elseif(($without_type=='pending')){ ?>
                    <tr class="D<?php echo $row_add['hodor_ensraf_id']; ?>">
                        
											<td>
											    
											    
										<?php  
					 //---------------------vacation----------------------------------------------------
                    
                    //   $sql_vac="SELECT * FROM hr_add_hodor_ensraf_tbl where employ_id='".$row_ws['employ_id']."' AND vac_stat='done_takeed'   ";
                    //              $result_vac = $conn->query($sql_vac);
                    //              if ($result_vac->num_rows > 0) {
                    //             while($row_vac = $result_vac->fetch_assoc()) {
                                 
                    //              echo $row_vac['vac_date_from'].'<br>'; 
                    
                    //              echo $row_vac['vac_date_to']; 

                    //             }}  
                    
              $check_vacation=0;        
         $vacation_dates= array();
       
        $sql_vac = "SELECT * FROM hr_add_hodor_ensraf_tbl WHERE employ_id='".$row_ws['employ_id']."' AND vac_stat='done_takeed'";
      $result_vac = $conn->query($sql_vac);

   if ($result_vac->num_rows > 0) {
    while ($row_vac = $result_vac->fetch_assoc()) {
        
        
        //echo $row_vac['employ_id']; 
        
        $vac_val_date=$val;  
        
        //echo $vac_val_date;


        array_push($vacation_dates,$val);
        
       // print_r($vacation_dates);
        
        $date_from = $row_vac['vac_date_from'];
        $date_to = $row_vac['vac_date_to'];

        // تحويل التاريخين إلى كائنات DateTime
        $start = new DateTime($date_from);
        $end = new DateTime($date_to);
        $end->modify('+1 day'); // تضمين اليوم الأخير في التكرار

        // التكرار خلال كل يوم بين التاريخين
        $interval = new DateInterval('P1D');
        $period = new DatePeriod($start, $interval, $end);

        foreach ($period as $date) {
            $hodor_vacation_date=$date->format('Y-m-d');
            
           // echo $hodor_vacation_date.'<br>';
            
            //echo $date->format('Y-m-d') . '<br>';
            
     
     
     //--------------------------------------------
     
       if (in_array($val, $vacation_dates)) {  
       $check_vacation='vacation';
       
       $stat_ghyabb=$vacation;   
                  
      // echo 'vac';
       
       
         }else{
        $stat_ghyabb=$absence;   
         }
     //--------------------------------------------
            
        }
        
         
    //   if($check_vacation=='vacation'){
    //   $stat_ghyabb=$vacation;   
    //   }else{
    //   $stat_ghyabb=$absence;
    //   }  
    }
}



 
                    
     
                    
                    
                    //---------------------/vacation----------------------------------------------------
                    
										?>	  
										
										
					<!--br><b style="color:red;"><?php echo $val; ?></b-->					
											    
											    
											    <?php //echo $row_add['hodor_ensraf_id']; ?>
												<label class="checkboxs">
                                                    <?php 
                                                   //echo $row_emp["employ_id"].$val;
                                                    ?>
												
												  <?php   if (in_array($val, $vacation_dates)) {  ?>
											<span class="task-priority badge bg-inverse-warning" style="font-size:18px;"> 	  <?php echo $stat_ghyabb; ?> </span> 
												  
												  <?php }else{ ?>
													<input type="checkbox" style="width:20px;height:20px;" class="ch_att" name="ch_att" id="ch_att" value="<?php echo $row_emp["employ_id"].$val; ?>">
												 <?php } ?>
												
													<span class="checkmarks"></span>
                                                    <input type="hidden" style="width:20px;height:20px;" class="employ_id" name="employ_id" id="employ_id<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $row_emp["employ_id"]; ?>">
                                                    <input type="hidden" style="width:20px;height:20px;" class="employee_number_fingerprint" name="employee_number_fingerprint" id="employee_number_fingerprint<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $row_emp["employee_number_fingerprint"]; ?>">
												</label>
												
											<?php 
										//	echo $employee_number_fingerprint."(".$employ_name.")".":".$row_emp["employ_id"]."</br>";
											?>	
										
											</td>
						 <td>
						    <?php echo  $row_add['hodor_ensraf_id']; ?><br>
						 
							<h2 class="table-avatar">
							
							<a class="avatar" clas="avatar avatar-xs" href="profile.html">
							<?php
							$attach_link=0;
                          $sql_ico="SELECT * FROM hr_employ_attachments_tbl where employ_id='".$row_emp['employ_id']."' AND att_name='employ_photo' AND  stop='0' AND deleted='0' ";
                          $result_ico = $conn->query($sql_ico);
                           if ($result_ico->num_rows > 0) {
                            while($row_ico = $result_ico->fetch_assoc()) {
                              $attach_link=$row_ico['attach_link'];  
                            }}
                             ?>  
                               <?php if($attach_link==''){ ?>  
								<img alt="" src="../../assets/img/profiles/avatar-09.jpg">
								<?php }elseif($attach_link!=''){ ?>
								<img alt="" src="../../../Shipping_Clearance_System/jquery/pages/system_maintenance/user_img/<?php echo $attach_link; ?>">
							<?php }else{ ?>
							<img alt="" src="../../assets/img/profiles/avatar-09.jpg">
							<?php } ?>
								
								</a>
							
						  
							  </h2>
								</td>
								
						
								
								<td>
								<a href="profile.html"><?php echo $employ_name; ?></a><br>
								<input  type="hidden" readonly="readonly" name="employ_id" id="employ_id<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['employ_id']; ?>">
                            	<input  type="hidden" readonly="readonly" name="employ_name_ar" id="employ_name_ar<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['employ_name_ar']; ?>">
							   	<input  type="hidden" readonly="readonly" name="employ_name_en" id="employ_name_en<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['employ_name_en']; ?>">
							    <input  type="hidden" readonly="readonly" name="mobile_number" id="mobile_number<?php echo $row_add["hodor_ensraf_id"]; ?>" value="<?php echo $row_emp['mobile_number']; ?>">
							    
							    <?php $mosala_type='ghyab';  ?>
							    <input  type="hidden" readonly="readonly" name="mosala_type" id="mosala_type<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $mosala_type; ?>">

							    

								 <small class="text-muted" style="font-size:12px;">
									 <?php
                                             $sql_cy="SELECT * FROM main_company_tbl where company_id='".$row_emp['company_id']."' ";
                                             $result_cy = $conn->query($sql_cy);
                                             if ($result_cy->num_rows > 0) {
                                             while($row_cy = $result_cy->fetch_assoc()) {
                                                if($lang=='ar'){$company_name=$row_cy['company_name_ar'];}else{$company_name=$row_cy['company_name_en'];} 
                                            echo $company_name;     
                                             }}
                                            // echo $row_emp['company_id'];
                                               ?> 
								<br>	
								   <?php 
					             $sql_c="SELECT * FROM dept_tb where dept_id='".$row_emp['dept_id']."' AND dept_id!='0' ";
                                  $result_c = $conn->query($sql_c);
                                  if ($result_c->num_rows > 0) {
                                   while($row_c = $result_c->fetch_assoc()) {
                                  if($lang=='ar'){$dept_name=$row_c['dept_name'];}else{$city_name2=$row_c['dept_name_en'];} 
                                        echo $dept_name;     
                                    }}
					            ?>-
					         	<?php if($row_cw['user_type']=='Top_Manager' or $row_cw['user_type']=='System_Manager'){ echo $row_cw['user_type'];
					         	}else{ ?>
									      <?php 
									     $sql_jo="SELECT * FROM job_tb where job_id='".$row_emp['job_id']."' AND job_id!='0' ";
                                         $result_jo = $conn->query($sql_jo);
                                         if ($result_jo->num_rows > 0) {
                                         while($row_jo = $result_jo->fetch_assoc()) {
                                          if($lang=='ar'){$job_name=$row_jo['job_name'];}else{$job_name=$row_jo['jop_name_en'];} 
                                          echo $job_name;
                                         //echo $row_jo['job_id'];
                                         
                                         }}else{ echo $no_jop;}
									     ?><?php } ?>
									</small><br>
									<small class="m3"><?php echo $row_emp['id_num']; ?></small>
								</td>		
								
								
								
											
							<td>
									  <?php 
									   $sql_sh="SELECT * FROM hr_shift_tbl where shift_id='".$row_ws['shift_id']."' AND stop='0' AND deleted='0'  ";
                                        $result_sh = $conn->query($sql_sh);
                                        if ($result_sh->num_rows > 0) {
                                       while($row_sh = $result_sh->fetch_assoc()) {
                                        if($lang=='ar'){$shift_name=$row_sh['shift_name_ar'];}else{$shift_name=$row_sh['shift_name_en'];}
                                       $min_start_time=$row_sh['min_start_time'];
                                        $start_time=$row_sh['start_time'];
                                         $max_start_time=$row_sh['max_start_time'];
                                         
                                          $min_end_time=$row_sh['min_end_time'];
                                        $end_time=$row_sh['end_time'];
                                         $max_end_time=$row_sh['max_end_time'];
                                         
                                         $number_hours=$row_sh['number_hours'];
                                         
                                       }}   
                                           
									  ?>
									  <small style="font-size:12px;"><?php echo $shift_name;  ?></small><br>
									  <small style="font-size:12px;"><?php echo $min_start_time; ?>-<?php echo $start_time; ?>-<?php echo $max_start_time; ?></small><br>
									   <small style="font-size:12px;"><?php echo $min_end_time; ?>-<?php echo $end_time; ?>-<?php echo $max_end_time; ?></small>
									</td>
								
									<td>
									<small style="font-size:14px;" dir="ltr"><?php  echo $val; ?>
									
									</small>
								
									<input  type="hidden" readonly="readonly" name="hodor_ensraf_date" id="hodor_ensraf_date<?php echo $row_emp["employ_id"].$val; ?>" value="<?php echo $val; ?>">
									</td>			
					     
                         
                         	<td>	  <?php   if (in_array($val, $vacation_dates)) {  ?>
											<span class="task-priority badge bg-inverse-warning" style="font-size:18px;"> 	  <?php echo $vacation; ?> </span> 
												  
								 <?php }else{ ?>
                             <span class="task-priority badge bg-inverse-danger"><?php echo $absence; ?></span>
                                 <?php } ?>
                             
                             <?php //echo $check_vacation; ?>
                             
                             
                              </td>	
											    
					 <td>
                      
							<?php 
							 $sql_q="SELECT * FROM hr_question_tbl where hr_question_type='ghyab'AND employ_id='".$row_ws['employ_id']."'AND hr_question_date='$val' AND stop='0' AND deleted='0'  ";
                             $result_q = $conn->query($sql_q);
                              if ($result_q->num_rows > 0) {
                                  $check_question=1;
                              while($row_q = $result_q->fetch_assoc()) {
                              $hr_question_stat=$row_q['hr_question_stat']; //echo $hr_question_stat;   
                              }}else{$check_question=0;}
							?> 
                         
                        
                         </td>
                         
                         
                           <td clas="text-end">
                               
                               
                            </td>
				
											
					<td> <?php //echo $modal_id; ?>
					 <?php   if (in_array($val, $vacation_dates)) {  ?>
				
					<small>لا تحتاج معالجة - إجازة </small>
					
					<?php }else{ ?>

					<div class="action-label">
				<?php if($check_question!='1'){ ?>	    
				 <span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-success"></i> <?php echo $pending; ?>
					</a></span>
					<?php }elseif($hr_question_stat=='waiting_employee_response'){ ?>
					<span>	<a style="font-size:12px;" class="btn btn-white bt/n-sm btn-rounded" href="javascript:void(0);">
					<i class="fa fa-dot-circle-o text-success"></i> <?php echo $waiting_employee_response; ?>
					</a></span><?php } ?>
					
					</div>
					
			 	<?php } ?>
					
					</td>
											
											<!--td class="text-end">
											    
											 <?php //include("../modals/hr_delete_modal.php");?>   
											 <?php //include("hr_edit_holidays_modal.php");?>
											    	
										<div class="dropdown dropdown-action">
										<a href="#" class="action-icon dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false"><i class="material-icons">more_vert</i></a>
										<div class="dropdown-menu dropdown-menu-right" style="">
											<?php if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_edit_dept==1)){ ?>  
										<a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#edit_holday<?php echo $modal_id; ?>"><i class="fa fa-pencil m-r-5"></i> <?php echo $edit; ?></a>
										<?php }else{ ?>
										<a class="dropdown-item up_add" href="javascript:void(0);" ><i class="fa fa-pencil m-r-5"></i> <?php echo $edit; ?></a>
									    <?php } ?>
									    
									    <?php if(($urow['user_type']=='Top_Manager' or $urow['user_type']=='System_Manager')or($hr_delete_dept==1)){ ?>  
										<a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#delete_modal<?php echo $modal_id; ?>"><i class="fa fa-trash-o m-r-5"></i> <?php echo $delete; ?></a>
											<?php }else{ ?>
										<a class="dropdown-item up_add" href="javascript:void(0);" ><i class="fa fa-pencil m-r-5"></i> <?php echo $delete; ?></a>
									    <?php } ?>
													</div>
												</div>	
											</td-->
                        <?php  } ?>
											<?php  } ?>
                                            <?php  } ?>
                                            <?php  } ?>
                                             <?php  } ?>
											<?php  }}  }} }}  }}   ?>
										</tr>
								

									</tbody>
								</table>
							</div>
						</div>
					</div>
                </div>
                	</div>
				<!-- /Page Content -->

				
            </div>
			<!-- /Page Wrapper -->

        </div>
		<!-- /Main Wrapper -->
		
	 
		<!-- sitting -->
		<?php include("../setting.php"); ?>
	    <!-- /sitting -->

	<!-- Footer -->
		<?php include("../footer.php"); ?>
		<!-- /Footer -->

	 <!-- jQuery -->
        <script src="../../assets/js/jquery-3.6.0.min.js"></script>

        <!-- Feather Icon JS -->
        <script src="../../assets/js/feather.min.js"></script>

        <!-- Slimscroll JS -->
        <script src="../../assets/js/jquery.slimscroll.min.js"></script>
        
          <!-- Select2 JS -->
    <script src="../../assets/js/select2.min.js"></script>
    
    <!-- Datetimepicker JS -->
    <script src="../../assets/js/moment.min.js"></script>
    <script src="../../assets/js/bootstrap-datetimepicker.min.js"></script>

        <!-- Datatable JS -->
        <script src="../../assets/js/jquery.dataTables.min.js"></script>
        <script src="../../assets/js/dataTables.bootstrap4.min.js"></script>
        
        <!-- Bootstrap Core JS -->
        <script src="../../assets/js/bootstrap.bundle.min.js"></script>

        <!-- Custom JS -->
        <script src="../../assets/js/script.js"></script>
      
<!-- Multiselect JS -->
		<script src="../../assets/js/multiselect.min.js"></script>

		 <!-- Theme Settings JS -->
		<script src="../../assets/js/layout.js"></script>
		<script src="../../assets/js/theme-settings.js"></script>
		<script src="../../assets/js/greedynav.js"></script>
		
	 <script src="../../assets/js/app_tow.js"></script>

		<!-- Custom JS -->
		<!--script src="../../assets/js/app.js"></script-->
		
		<script src="../script_lang.js"></script> 
		
		  <!-- Alertify JS -->
		<script src="../../assets/plugins/alertify/alertify.min.js"></script>
		<!--script src="../../assets/plugins/alertify/custom-alertify.min.js"></script-->
        <!-- /Alertify JS -->
		
		
		
	    <script>
  $(document).ready(function(e) {
   $(".up_add").click(function(){
   alertify.error(message_per);
      });
      });
       </script>	
    
    
    <script>
  $(document).ready(function(e) {
   $(".up_addh").click(function(){
   alertify.error(message_per);
      });
      });
       </script>
       
  
    <script>
$('.all_ch_att').click(function(event) { 
   var id = [];
            if(this.checked) { 
                $('.ch_att').each(function(i) { 
                  if(i<30){
                    this.checked = true;
                    id[i] = $(this).val(); 
                  }    
                });
            }else{
                $('.ch_att').each(function() {
                    this.checked = false; 
                });        
            }
        });
        </script>
        
        
        
         <script>
//تسجيل غياب
$("#absence").click(function(){
      if(confirm("هل انت متاكد انك تريد تسجيل غياب ؟")){
        var id = [];
         var employ_id = [];
          var hodor_ensraf_date = [];
          var mosala_type = [];
            var add_user_id=$('#add_user_id').val();
            var employee_number_fingerprint = [];
       //alert(add_user_id);
          //var att_abs_date = $("#att_abs_date").val();

         // var att_or_abs_or_late = $('#att_or_abs_or_late').find(":selected").val();
        $(":checkbox:checked").each(function(i){
          id[i] = $(this).val();
             
               
          employ_id1=$('#employ_id'+id[i]).val();
          employ_id.push(employ_id1);
         
          hodor_ensraf_date1=$('#hodor_ensraf_date'+id[i]).val();
          hodor_ensraf_date.push(hodor_ensraf_date1);
          
          mosala_type1=$('#mosala_type'+id[i]).val();
          mosala_type.push(mosala_type1);

          employee_number_fingerprint1=$('#employee_number_fingerprint'+id[i]).val();
          employee_number_fingerprint.push(employee_number_fingerprint1);

        });
//alert(employ_id);
//alert(hodor_ensraf_date);
//alert(mosala_type);
        if(id.length == 0){
          alert("اختر على الاقل احد الموظفين لإرسال المسائله !");

        }else{

      $.post('hr_ghyab_Codeee.php', {'id':id,'employ_id':employ_id,'hodor_ensraf_date':hodor_ensraf_date,'mosala_type':mosala_type,'employee_number_fingerprint':employee_number_fingerprint,'add_user_id':add_user_id}, function(r) {
              // alert("تمت عملية التسجيل بنجاح");
              alertify.success(message_success);
               if(r==1){
                for( var i=0; i<id.length; i++){
         $(".D"+id[i]+'').css("background-color", "#ccc");
         $(".D"+id[i]+'').fadeOut("slow");

         }
               }
               window.location.reload();
              }); 
              
        }

      }else{
        return false;

      }

    });

     </script>
     
     
     
             
         <script>
//تسجيل إستثناء
$("#btn_exception").click(function(){
      if(confirm("هل انت متاكد انك تريد إستثناء الموظف من الغياب ؟")){
        var id = [];
         var employ_id = [];
          var hodor_ensraf_date = [];
          var mosala_type = [];
            var add_user_id=$('#add_user_id').val();
            var employee_number_fingerprint = [];
       //alert(add_user_id);
          //var att_abs_date = $("#att_abs_date").val();

         // var att_or_abs_or_late = $('#att_or_abs_or_late').find(":selected").val();
        $(":checkbox:checked").each(function(i){
          id[i] = $(this).val();
             
               
          employ_id1=$('#employ_id'+id[i]).val();
          employ_id.push(employ_id1);
         
          hodor_ensraf_date1=$('#hodor_ensraf_date'+id[i]).val();
          hodor_ensraf_date.push(hodor_ensraf_date1);
          
          mosala_type1=$('#mosala_type'+id[i]).val();
          mosala_type.push(mosala_type1);

          employee_number_fingerprint1=$('#employee_number_fingerprint'+id[i]).val();
          employee_number_fingerprint.push(employee_number_fingerprint1);

        });
//alert(employ_id);
//alert(hodor_ensraf_date);
//alert(mosala_type);
        if(id.length == 0){
          alert("اختر على الاقل احد الموظفين  !");

        }else{

      $.post('hr_exception_ghyab_Codeee.php', {'id':id,'employ_id':employ_id,'hodor_ensraf_date':hodor_ensraf_date,'mosala_type':mosala_type,'employee_number_fingerprint':employee_number_fingerprint,'add_user_id':add_user_id}, function(r) {
              // alert("تمت عملية التسجيل بنجاح");
              alertify.success(message_success);
               if(r==1){
                for( var i=0; i<id.length; i++){
         $(".D"+id[i]+'').css("background-color", "#ccc");
         $(".D"+id[i]+'').fadeOut("slow");

         }
               }
               window.location.reload();
              }); 
              
        }

      }else{
        return false;

      }

    });

     </script>
     
     
     
                  
         <script>
//تسجيل المسائله
$("#btn_mosala").click(function(){
      if(confirm("هل انت متاكد انك تريد إرسال المسائله ؟")){
        var id = [];
         var employ_id = [];
          var hodor_ensraf_date = [];
          var mosala_type = [];
            var add_user_id=$('#add_user_id').val();
            var employee_number_fingerprint = [];
       //alert(add_user_id);
          //var att_abs_date = $("#att_abs_date").val();

         // var att_or_abs_or_late = $('#att_or_abs_or_late').find(":selected").val();
        $(":checkbox:checked").each(function(i){
          id[i] = $(this).val();
             
               
          employ_id1=$('#employ_id'+id[i]).val();
          employ_id.push(employ_id1);
         
          hodor_ensraf_date1=$('#hodor_ensraf_date'+id[i]).val();
          hodor_ensraf_date.push(hodor_ensraf_date1);
          
          mosala_type1=$('#mosala_type'+id[i]).val();
          mosala_type.push(mosala_type1);

          employee_number_fingerprint1=$('#employee_number_fingerprint'+id[i]).val();
          employee_number_fingerprint.push(employee_number_fingerprint1);

        });
//alert(employ_id);
//alert(hodor_ensraf_date);
//alert(mosala_type);
        if(id.length == 0){
          alert("اختر على الاقل احد الموظفين  !");

        }else{

    $.post('hr_mosala_ghyab_Codeee.php', {'id':id,'employ_id':employ_id,'hodor_ensraf_date':hodor_ensraf_date,'mosala_type':mosala_type,'employee_number_fingerprint':employee_number_fingerprint,'add_user_id':add_user_id}, function(r) {
              // alert("تمت عملية التسجيل بنجاح");
              alertify.success(message_success);
              //alert(r);
               if(r==1){
                for( var i=0; i<id.length; i++){
         $(".D"+id[i]+'').css("background-color", "#ccc");
         $(".D"+id[i]+'').fadeOut("slow");

         }
               }
               window.location.reload();
              }); 
              
        }

      }else{
        return false;

      }

    });

     </script>
     
     
        
        
 <!--script>
//إرسال مسائله لعدد من الموظفين
$("#btn_mosala").click(function(){
      if(confirm("هل انت متاكد انك تريد إرسال المسائله ؟")){
        var id = [];
         var employ_id = [];
          var hodor_ensraf_date = [];
          var mosala_type = [];
            var add_user_id=$('#add_user_id').val();
      // alert(add_user_id);
          //var att_abs_date = $("#att_abs_date").val();

         // var att_or_abs_or_late = $('#att_or_abs_or_late').find(":selected").val();
        $(":checkbox:checked").each(function(i){
          id[i] = $(this).val();
             
               
          employ_id1=$('#employ_id'+id[i]).val();
          employ_id.push(employ_id1);
         
          hodor_ensraf_date1=$('#hodor_ensraf_date'+id[i]).val();
          hodor_ensraf_date.push(hodor_ensraf_date1);
          
          mosala_type1=$('#mosala_type'+id[i]).val();
          mosala_type.push(mosala_type1);

        });

        if(id.length == 0){
          alert("اختر على الاقل احد الموظفين  !");

        }else{

      $.post('hr_mosala_ghyab_Codeee.php', {'id':id,'employ_id':employ_id,'hodor_ensraf_date':hodor_ensraf_date,'mosala_type':mosala_type,'add_user_id':add_user_id}, function(r) {
              // alert("تمت عملية التسجيل بنجاح");
              alertify.error(message_success);
               if(r==1){
                for( var i=0; i<id.length; i++){
         $(".D"+id[i]+'').css("background-color", "#ccc");
         $(".D"+id[i]+'').fadeOut("slow");

         }
               }
               window.location.reload();
              }); 
              
        }

      }else{
        return false;

      }

    });

     </script-->
     
     
     
     
     
     <!--script>
//تعديل الحضور والإنصراف

$("#btn_takeed").click(function(){
      if(confirm("هل انت متاكد انك تريد إرسال التعديل ؟")){
        var id = [];
         var employ_id = [];
          var hodor_ensraf_date = [];
          var mosala_type = [];
             var hodor_time = [];
              var ensraf_time = [];
      var j = 0;
      
          //var att_abs_date = $("#att_abs_date").val();

         // var att_or_abs_or_late = $('#att_or_abs_or_late').find(":selected").val();
        $(":checkbox:checked").each(function(i){
          id[i] = $(this).val();
            // alert(id);
              
          employ_id1=$('#employ_id'+id[i]).val();
          employ_id.push(employ_id1);
         
          hodor_ensraf_date1=$('#hodor_ensraf_date'+id[i]).val();
          hodor_ensraf_date.push(hodor_ensraf_date1);
          
          mosala_type1=$('#mosala_type'+id[i]).val();
          mosala_type.push(mosala_type1);
         
           
          hodor_time1=$('#hodor_time'+id[i]).val();
          hodor_time.push(hodor_time1);
          
           
            ensraf_time1=$('#ensraf_time'+id[i]).val();
          ensraf_time.push(ensraf_time1);
          
           //alert(hodor_time1);
           //alert(ensraf_time1);
           if((hodor_time1==ensraf_time1) || (hodor_time1>ensraf_time1)){
               j++;
           }else{}

        });
        if(id.length == 0){
          alert("اختر  الاقل احد الموظفين لتأكيد التعديل !");

        }else{
if(j>0){
   alert("لا يمكن ان يكون وقت الحضور اكبر او يساوي وقت الانصراف"); 
}else{
    
      $.post('hr_takeed_edit_att_Code.php', {'id':id,'employ_id':employ_id,'hodor_ensraf_date':hodor_ensraf_date,'mosala_type':mosala_type,'hodor_time':hodor_time,'ensraf_time':ensraf_time}, function(r) {
          //     alert("تمت عملية التسجيل بنجاح");
              alertify.success(message_success);
               if(r==1){
                for( var i=0; i<id.length; i++){
         $(".D"+id[i]+'').css("background-color", "#ccc");
         $(".D"+id[i]+'').fadeOut("slow");

         }
               }
               window.location.reload();
              }); 
              
        }}

      }else{
        return false;

      }

    });

     </script-->
        
        
        
        
      
       
       	<!--script>
        $('.b').click(function() {
		   $('.nav-link').removeClass('active');
		   $(this).addClass('active');
		});
      </script-->
       
       
       
       	<script>
       	 var modal_table_name=$('#modal_table_name').val();
       	 var id_name=$('#id_name').val();
       	 var proccess_details_delete_disable=$('#proccess_details_delete_disable').val();
       	 var proccess_details_en_delete_disable=$('#proccess_details_en_delete_disable').val();
       	 
       	 var proccess_details_enable=$('#proccess_details_enable').val();
       	 var proccess_details_en_enable=$('#proccess_details_en_enable').val();
       	  
    $(".checktoggle").click(function(e){
        var id = $(this).attr('data-id');
        //alert(id);
        
           var id_check=$('#id_check').val(); 
        if(id_check==''){
      alertify.error(message_per);
        }else{
        
        if($('#user'+id).is(':checked') ){
      if(confirm(message_disabled)){
         //alert("Checkbox Is checked");
    $('#user'+id).prop('checked', true);
    
   //======================
      var add_user_id=$('#add_user_id').val();
      var company_id=$('#company_id').val();
      var g = $(this).attr('data-id');
      var date_did = $("#date_did"+g).val();
   //alert(g);
          $.post('../modals/hr_disabeld_code.php', {'g':g,'add_user_id':add_user_id,'company_id':company_id,'modal_table_name':modal_table_name,'id_name':id_name,'proccess_details_delete_disable':proccess_details_delete_disable,'proccess_details_en_delete_disable':proccess_details_en_delete_disable}, function(r) {
              //alert(r);
        if (r == 1) {
     //  alert("تمت العمليه بنجاح");
      alertify.error(message_success);
         // window.location.reload();
         $(".D"+i).css("background-color", "#ccc");
         $(".D"+i).fadeOut("slow");
       

               }
             });
             
      }else{
        return false;
      }
   
   //======================
}
else{
   // alert("Checkbox Is not checked");
    $('#user'+id).prop('checked', false);
     if(confirm(message_enabled)){
    
      //======================
      var add_user_id=$('#add_user_id').val();  
      var company_id=$('#company_id').val();
      var g = $(this).attr('data-id');
      var date_did = $("#date_did"+g).val();
  // alert(g);
          $.post('../modals/hr_enable_code.php', {'g':g,'add_user_id':add_user_id,'company_id':company_id,'modal_table_name':modal_table_name,'id_name':id_name,'proccess_details_enable':proccess_details_enable,'proccess_details_en_enable':proccess_details_en_enable}, function(r) {
             // alert(r);
        if (r == 1) {
     //  alert("تمت العمليه بنجاح");
   alertify.success(message_success);
         $(".D"+i).css("background-color", "#ccc");
         $(".D"+i).fadeOut("slow");
          window.location.reload();

               }
             });
             
      }else{
        return false;
      }
   
 }  //====================== 
    
}
    });
</script>
       
       
		
		
   <style>
.alert {
  text-align: center;
  padding: 10px;
  background: rgb(168, 240, 177);
  color: green;
  margin-bottom: 10px;
  display: none;
}
.alert3 {
  text-align: center;
  padding: 10px;
  background: rgb(168, 240, 177);
  color: green;
  margin-bottom: 10px;
  
}
.alert4 {
  text-align: center;
  padding: 10px;
  margin-bottom: 10px;
  border-color: #ebad30;
  font-size:18px;
}

</style>	
		
    </body>
</html>




