<?php 
error_reporting(0);
include("common.php");
include("config.php");  
       $id = $_GET['id'];
      $q = "SELECT * FROM applications WHERE id='$id'";
        $r = $conn->query($q);
        $data = mysqli_fetch_assoc($r);                          
?>

        <!-- START: Template CSS-->
        <link rel="stylesheet" href="dist/vendors/bootstrap/css/bootstrap.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.theme.min.css">
        <link rel="stylesheet" href="dist/vendors/simple-line-icons/css/simple-line-icons.css">        
        <link rel="stylesheet" href="dist/vendors/flags-icon/css/flag-icon.min.css"> 
        <link rel="stylesheet" href="dist/vendors/flag-select/css/flags.css">
        <!-- END Template CSS-->   

        <!-- START: Page CSS-->
        <link rel="stylesheet" href="dist/vendors/quill/quill.snow.css" />
        <!-- END: Page CSS-->

        <!-- START: Custom CSS-->
        <link rel="stylesheet" href="dist/css/main.css">
        <!-- END: Custom CSS-->
  
<style>
table {
  
  border-collapse: collapse;
  width: 100%;
}

td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #fff;
}
</style>

        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
    

							
                <!-- START: Card Data-->
                <div class="row">
                    <div class="col-8 mt-3">
                       <div class="card">
<div class="card-header justify-content-between align-items-center">
        <h4 class="card-title"><?PHP ECHO $data[applicant_name];?></h4>
     <span style="float:right"> <a href="member.php">Back to page </a></span>
    </div>
	
    <div class="card-body">
        <div class="table-responsive">
           <table>
  <tr>
    <td>Status</td>
    <td><b><?php echo $data[status];?></b></td>
  
  </tr>
  <tr>
    <td>Applicant Date</td>
    <td><?php echo date('d M, Y',strtotime($data['appliaction_date'])); ?> </td>
  
  </tr>
   
 
<tr style="background-color:#ddd;">
    <td>Permanent Address</td>
    <td><?php echo $data[address_permanant];?> </td>
   
  </tr>
   <tr>
    <td>Town</td>
    <td><?php echo $data[town];?></td>
  
  </tr>
  <tr>
    <td>Taluka</td>
    <td><?php echo $data[taluka];?></td>
  
  </tr>
  <tr>
    <td>District</td>
    <td><?php echo $data[distrtict];?></td>
  
  </tr>
     <tr>
    <td>State</td>
    <td><?php echo $data[state_local];?></td>
  
  </tr>
   <tr>
    <td>Pincode</td>
    <td><?php echo $data[pincode_local];?></td>
  
  </tr>
  <tr style="background-color:#ddd;">
    <td>Local Address</td>
    <td><?php echo $data[address_local];?></td>
    </tr>
	   <tr>
    <td>Town</td>
    <td><?php echo $data[town_local];?></td>
  
  </tr>
  <tr>
    <td>Taluka</td>
    <td><?php echo $data[taluka_local];?></td>
  
  </tr>
  <tr>
    <td>District</td>
    <td><?php echo $data[district_local];?></td>
  
  </tr>
   <tr>
    <td>State</td>
    <td><?php echo $data[state_local];?></td>
  
  </tr>
   <tr>
    <td>Pincode</td>
    <td><?php echo $data[pincode_local];?></td>
  
  </tr>
	  <tr>
    <td>Refrence by</td>
    <td><?php echo $data[refrence];?></td>
    </tr>
	  <tr>
    <td>Gender</td>
    <td><?php echo $data[gender];?></td>
    </tr>
	  <tr>
    <td>Marital Status</td>
    <td><?php echo $data[mstatus];?></td>
    </tr>
	  <tr>
    <td>Birth Date</td>
    <td><?php echo $data[birth_day];?>/<?php echo $data[birth_month];?>/<?php echo $data[birth_year];?></td>
    </tr>
	  <tr>
    <td>Age</td>
    <td><?php echo $data[age];?></td>
    </tr>
	  <tr>
    <td>Education</td>
    <td><?php echo $data[education];?></td>
    </tr>
	  <tr>
    <td>Height</td>
    <td><?php echo $data[height];?></td>
    </tr>
	  <tr>
    <td>Previous Expereinece</td>
    <td><?php echo $data[prev_exp];?></td>
    </tr>
	<?php if($data[prev_exp]=='Yes'){?>
	
	  <tr>
    <td>Company Info</td>
    <td>Company Name: <?php echo $data[company_name1];?><br>
	Type Of Experience: <?php echo $data[typ_exp1];?><br>
	POST : <?php echo $data[post1];?><br>
	Duration: <?php echo $data[duration1];?> <?php echo $data[duration_type1];?>
	</td>
    </tr>
	<tr>
    <td>Company Info</td>
    <td>Company Name: <?php echo $data[company_name2];?><br>
	Type Of Experience: <?php echo $data[typ_exp2];?><br>
	POST : <?php echo $data[post2];?><br>
	Duration: <?php echo $data[duration2];?> <?php echo $data[duration_type2];?>
	</td>
    </tr>
	
	<tr>
    <td>Company Info</td>
    <td>Company Name: <?php echo $data[company_name3];?><br>
	Type Of Experience: <?php echo $data[typ_exp3];?><br>
	POST : <?php echo $data[post3];?><br>
	Duration: <?php echo $data[duration3];?> <?php echo $data[duration_type3];?>
	</td>
    </tr>
	
	
	
	<?php } ?>
	  <tr>
    <td>Other Ability</td>
    <td><?php echo $data[other_ability];?></td>
    </tr>
	<?php if($data[other_ability]=='Yes'){?>
	<tr>
    <td> Ability Information</td>
    <td><?php echo $data[ability_info];?></td>
    </tr>
	<?php } ?>
	 <tr>
    <td>Four Whieler driving Licence</td>
    <td><?php echo $data[driving_lic];?></td>
    </tr>
	 <tr>
    <td>Gun Licence</td>
    <td><?php echo $data[gun_lic];?></td>
    </tr>
	
	 <tr>
    <td>Shift Prefrance</td>
    <td><?php echo $data[shift_pre];?></td>
    </tr>
	 <tr>
    <td>Salary Expectation</td>
    <td><?php echo $data[salary_expe];?></td>
    </tr>
	 <tr>
    <td>Own Gun/Revalvar</td>
    <td><?php echo $data[own_gun];?></td>
    </tr>
	 <tr>
    <td>Mobile No</td>
    <td><?php echo $data[mobile];?></td>
    </tr>
	 <tr>
    <td>Alternate Mobile No</td>

    <td><?php echo $data[alt_mobile];?></td>
    </tr>
	 <tr>
    <td>Email Id</td>
    <td><?php echo $data[email];?></td>
    </tr>
	 <tr>
    <td>Aadharcard No</td>
    <td><?php echo $data[adharcardno];?></td>
    </tr>
	
</table>

      
                                </div>
                            </div>
                        </div> 

                    </div>    
 <div class="col-4 mt-3">
 <B>OFFICE USE:</B>
 <div class="card-body">
        <div class="table-responsive">
           <table>
<form action="update_interview_call.php" method="POST">
  <tr style="background-color:#fff;">
    <td>First Interview Call</td>
    <td><input type="date" name="firstcall" value="<?php echo $data[first_call_date];?>" class="form-control"> </td>
	</tr>	
<td>Any Message</td>	
	<td><textarea name="fbox" cols="15" rows="1"> <?php echo $data[fbox];?></textarea> 
<br>
 <tr style="background-color:#fff;">
  <td></td>
  <input type="hidden" name="table_id" value="<?php echo $_GET['id'];?>">
    <td><button class="btn5"> Submit </button></td>
    </tr>
</form>
	</td>
	<?php if($data[first_call_date]!=''){?>
<form action="update_interview_call_two.php" method="POST">	
<tr style="background-color:#f9f5d5;">
    <td>Second Interview Call</td>
    <td><input type="date" name="secondcall" value="<?php echo $data[sec_call_date];?>" class="form-control"> </td>
  
  </tr>	 
  <tr style="background-color:#f9f5d5;">
<td>Any Message</td>	
	<td><textarea name="sbox" cols="15" rows="1"> <?php echo $data[sbox];?></textarea>
 </tr>		
<br>  
<tr style="background-color:#f9f5d5;">
  <td></td>
  <input type="hidden" name="table_id" value="<?php echo $_GET['id'];?>">
    <td><button class="btn5"> Submit </button></td>
    </tr>	
</form>
	<?php } ?>
<?php if($data[status]!=''){?>
<tr style="background-color:green;color:#dceab7;">
    <td>Status</td>
    <td><?php echo $data[status];?></td>
  
  </tr>	
<tr style="background-color:green;color:#dceab7;">
    <td>Joining Date</td>
    <td><?php echo date('d M,  Y',strtotime($data['joining_date'])); ?> </td>
  
  </tr>
<?php } ?>

  </table>
  
   <div class="card-body">
    <table>
    <form action="update_join_date.php" method="POST">
        <tr style="background-color:#dceab7;">
            <td>Joining Status</td>
            <td>
                <select name="status" id="status" class="form-control" onchange="toggleJoiningDate()">
                    <option value="">Select</option>
                    <option value="Joined" <?php if ($data['status'] == "Joined") echo 'selected="selected"'; ?>>Selected</option>
                    <option value="Reject" <?php if ($data['status'] == "Reject") echo 'selected="selected"'; ?>>Reject</option>
                </select>
            </td>
        </tr>
       <tr style="background-color:#dceab7;">
            <td>Joining Date</td>
            <td>
                <input type="date" name="joining_date" value="<?php echo $data['joining_date']; ?>" class="form-control">
            </td>
        </tr>
       <tr style="background-color:#dceab7;">
            <td></td>
            <input type="hidden" name="id" value="<?php echo $_GET['id']; ?>">
            <td><button class="btn5"> Submit </button></td>
        </tr>
    </form>
</table>

<script>
    function toggleJoiningDate() {
        const statusSelect = document.getElementById('status');
        const joiningDateRow = document.getElementById('joining-date-row');

        if (statusSelect.value === "Joined") {
            joiningDateRow.style.display = "table-row";
        } else {
            joiningDateRow.style.display = "none";
        }
    }

    // Call toggleJoiningDate on page load to apply the correct visibility based on the initial value
    window.onload = toggleJoiningDate;
</script>

   </div> 
 </div> 
 </div> 
 </div> 
                </div>
            </div>
        </main>
        <!-- END: Content-->

      

        <!-- START: Template JS-->
        <script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
         
        <script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        <!-- END: Template JS-->
        
        <!-- START: APP JS-->
        <script src="dist/js/app.js"></script>
        <!-- END: APP JS-->

        <!-- START: Page Vendor JS-->
        <script src="dist/vendors/quill/quill.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- END: Page Script JS-->
		<style>
		.btn5{
			padding:2px;
			background-color:#fc2210;
			color:#fff;
			border-radius:2px;
			padding-left:10px;padding-right:10px;
			border:2px solid #fc2210;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:100px;	
			
		}
		
		</style>
		
    </body>
   
</html>
