<?php 
$pageName = "VIew Employe";

require_once('config/config.php');
require_once(CLASS_DIR.'dbClass.php');
require_once(INCLUDES_DIR.'header.php');

include('hitCounter.php');

$obj = new DBClass();
$obj5 = new DBClass();

$functionalarea = $_REQUEST['functionalarea'];
?>
<style type="text/css">
<!--
.style13 {
	font: bold Arial;
	color: #000000;
	font-size: medium;
}
.style15 {font-size: 14}
.style16 {
	font: bold "Times New Roman";
	color: #000000;
	font-size: 14px;
}
-->
</style>


<!--workarea start------------------------->
<div class="workarea">
	<div class="workareatop">
		<img src="images/workareatopcorner_03.PNG" alt="" />
	</div>
	<!--workareamid start--------------------->
	<div class="workareamid">
		<div id="floatleft" style="width:590px; float:left;">
			<div class="welcomediv">

                        
                        <h2><?php echo $_GET['functionalarea']; ?><div class="urls"><a href="coaljobs.php">Coal Jobs</a> <img src="images/arow.PNG" height="15" alt="arow" width="15"/> <a href="employee.php">Database</a></div></h2>

<?php 

$adjacents = 5;

$tbl_name=TBL_JOBSEEKER;

$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE status = '0' and functional = '".$functionalarea."'  ORDER BY id DESC";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$targetpage = "viewEmploye.php?functionalarea=".$functionalarea;

$limit = 10;
$page = $_GET['page'];
if($page) 
	$start = ($page - 1) * $limit;
else
	$start = 0;	

$sql = "SELECT * FROM $tbl_name WHERE status = '0' and functional ='".$functionalarea."'  ORDER BY id DESC LIMIT $start, $limit";
	$result = mysql_query($sql);
	

	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
	$prev = $page - 1;							//previous page is page - 1
	$next = $page + 1;							//next page is page + 1
	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
	$lpm1 = $lastpage - 1;						//last page minus 1
	
	/* 
		Now we apply our rules and draw the pagination object. 
		We're actually saving the code to a variable in case we want to draw it more than once.
	*/
	$pagination = "";
	if($lastpage > 1)
	{	
		$pagination .= "<div class=\"pagination\">";
		//previous button
		if ($page > 1) 
			$pagination.= "<a href=\"$targetpage&page=$prev\">previous</a>";
		else
			$pagination.= "<span class=\"disabled\">previous</span>";	
		
		//pages	
		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
		{	
			for ($counter = 1; $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage&page=$counter\">$counter</a>";					
			}
		}
		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
		{
			//close to beginning; only hide later pages
			if($page < 1 + ($adjacents * 2))		
			{
				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage&page=$counter\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage&page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage&page=$lastpage\">$lastpage</a>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage&page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage&page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage&page=$counter\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage&page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage&page=$lastpage\">$lastpage</a>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<a href=\"$targetpage&page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage&page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage&page=$counter\">$counter</a>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage&page=$next\">next</a>";
		else
			$pagination.= "<span class=\"disabled\">next</span>";
		$pagination.= "</div>\n";		
	}


	$rs = $obj->executeQry($sql);
	$rownum = $obj->getrow();
	if($obj->getrow()>0) {
	while($row = $obj->fetchrow()) { 
	?>
<table  class="main" width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
			<td class="bdr1">
				<table width="100%" border="0" cellspacing="0" cellpadding="0">
					<tr>
						<td colspan="2" bgcolor="#A0A0A4" class="form_head" style="padding-left:5px;background-image:none;" width="100%">
							<font size="3" color="#000000"><b><?php echo $row['name'];?></b></font>
						</td>
					</tr>
					<tr class="bg_td1"  >
						<td width="25%" style="padding:5px;"><span class="style15"><b>Designation</b></span></td>
						<td width="75%" style="padding:5px;" class="style15"><?php echo "<b>".$row['designation']."</b>(".$row['experince'].")";?></td>
					</tr>
					<tr class="bg_td1"  >
						<td width="25%" style="padding:5px;" align="top" class="style15"><strong>Organization</strong></td>
						<td width="75%" style="padding:5px;" class="style15"><?php echo $row['organization'];?></td>
					</tr>
					<tr class="bg_td1"  >
						<td width="25%" style="padding:5px;" align="top" class="style15"><strong>Key Skills</strong></td>
						<td width="75%" style="padding:5px;" class="style15"><?php echo $row['keyskills'];?></td>
					</tr>
					<tr class="bg_td1"  >
						<td width="25%" style="padding:5px;" align="top" class="style15" valign="top"><strong>Resume<br /><br /><br /><br /><br /><br /><br /><?php if($row['File_Name'] != ''){ ?>Download Resume<?php } ?></strong></td>
						<td width="75%" style="padding:5px;" class="style15"><textarea name="resume" readonly="readonly" cols="50" rows="4"><?php echo $row['resume'];?></textarea><br /><a href="download.php?fileName=<?php echo $row['File_Name']; ?>"><?php echo $row['File_Name']; ?></a></td>
					</tr>
					<tr class="bg_td1"  >
						<td width="25%" style="padding:5px;" align="top" class="style15"><strong>Contact Details</strong></td>
						<td width="75%" style="padding:5px;" class="style15"><?php echo "<b>".$row['name'].", Mail id - </b> ".$row['mailid']. ",<b> Contact No.</b> ".$row['mobile'];?></td>
					</tr>
				</table>
			</td>
		</tr>
<p>&nbsp;</p>
</table>
<?php 
} }  else { ?>                            
<table>
	<tr>
		<td><font color="#D40000">Record not found !</font></td>
	</tr>
</table> 
<?php } ?>
<br /><br />
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">                        
	<tr>
		<td valign="top" class="bg_innerfoot">
			<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
				<tr>
					<td align="center" class="footer_num"><?php if ($rownum > 0) echo $pagination;?></td>
				</tr>
			</table>
		</td>
	</tr>                   
</table>  


						</div>
				</div>
				<?php require_once(INCLUDES_DIR.'left_bar.php');?>
                <!--floatright close-------------------->
                <div style="clear:both;"></div>
            </div>
            <!--workareamid close--------------------->
            <div class="workareabottom">
                <img src="images/workareabottomcorner_03.PNG" alt="" />
            </div>
        </div>
    <!--workarea close------------------------->
<?php require_once(INCLUDES_DIR.'footer.php');?>