 
<h1><strong>Jobs Pending to Schedule</strong></h1>
<table width="100%" cellpadding="3" cellspacing="0" border="1" style="border:#808080 1px solid; border-collapse:collapse;">
<tr>
   	<th width="5%"><strong>S. No.</strong></th>
	  <th><strong>Branch</strong></th>
   	<th width="15%"><strong>Job Type</strong></th>
    <th width="10%"><strong>Vacancy Code</strong></th>
	  <th width="10%"><strong>Vacancy Date</strong></th>
    <th width="5%"><strong>Action</strong></th>
</tr>
<?php $i=0; $SQL=DB_query("SELECT * FROM hr_job_created where companyid='".$_SESSION['ACGCompanyId']."' and schedule_status='0' ",$db);
if(DB_num_rows($SQL)>0){
while($GetRec=DB_fetch_array($SQL)) {?>
<tr bgcolor="#fff">
	<td><input type="text" readonly="" class="input_read" value="<?php echo $i+1; ?>" style="width:98%;" /></td>
	<td><input type="text" readonly="" class="input_read" value="<?php echo $sitename=$s->GetFieldValue('locations',"loccode='".$GetRec['branch']."'",'locationname'); ?>" style="width:98%;" /></td>
   	<td><input type="text" readonly="" class="input_read" value="<?php if($GetRec['job_type']=="p"){ echo "Permanent"; } else if($GetRec['job_type']=="c"){ echo "Contract" ;} ?>" style="width:98%;" /></td>
    <td><input type="text" readonly="" class="input_read" value="<?php echo $GetRec['vacancy_code']; ?>" style="width:98%;" /></td>
    <td><input type="text" readonly="" class="input_read" value="<?php echo ConvertSQLDate($GetRec['vac_date'])   ?>" style="width:98%;" /></td>
    <td><a href="index.php?route=HRModule/intrvw_plan_schedule&modid=<?php echo $_REQUEST['modid'] ?>&frmid=<?php echo $_REQUEST['frmid'] ?>&vacid=<?php echo $GetRec['id'] ?>"><input type="button" value="Schedule" class="search" /></a></td>
</tr>
<?php $i++;} }else{?>
<tr bgcolor="#fff">
    <td colspan="6" align="center" class="tabledata">No Result Found.</td>
</tr>
<?php } ?>
</table>