
<h3>Jobs Pending to Schedule </h3>	

<table width="100%" cellpadding="3" cellspacing="0" border="1" style="border:#808080 1px solid; border-collapse:collapse;">
<tr>
    <th width="4%"><strong>S. No.</strong></th>
	<th><strong>Branch</strong></th>
    <th width="10%"><strong>Job Type</strong></th>
    <th width="10%"><strong>Vacancy Code</strong></th>
	<th width="10%"><strong>Vacancy Date</strong></th>
    <th width="7%" style="text-align:center;"><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><?php echo $i+1; ?></td>
	<td><?php echo $sitename=$s->GetFieldValue('locations',"loccode='".$GetRec['branch']."'",'locationname'); ?></td>
    <td><?php if($GetRec['job_type']=="p"){ echo "Permanent"; } else if($GetRec['job_type']=="c"){ echo "Contract" ;} ?></td>
    <td><?php echo $GetRec['vacancy_code']; ?></td>
    <td><?php echo ConvertSQLDate($GetRec['vac_date'])   ?></td>
    <td style="text-align:center;"><a href="index.php?route=HRModule/Master/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>
    <td colspan="6">No Result Found.</td>
</tr>
<?php } ?>
</table>