<?php require_once('../Connections/oprmConn.php'); ?>
<?php $msg = ""; if(isset($_REQUEST['msg'])) $msg = $_REQUEST['msg']; ?>

<?php mysql_select_db($database_oprmConn, $oprmConn);
$query_getRes1 = "SELECT weby_users.user_id, weby_users.employee_id, weby_users.email_address, weby_users.caeated_date, weby_profiles.profile_id, weby_profiles.full_name, weby_profiles.job_title, weby_profiles.skill_set, weby_profiles.profile_pic, weby_users.status, weby_profiles.hr_rate FROM weby_users, weby_profiles WHERE weby_profiles.user_id = weby_users.user_id AND weby_profiles.status = 'P' AND weby_users.user_role != '1' AND weby_users.status in ('A','P')";
$getRes1 = mysql_query($query_getRes1, $oprmConn) or die(mysql_error());
$row_getRes1 = mysql_fetch_assoc($getRes1);
$totalRows_getRes1 = mysql_num_rows($getRes1);

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SS WEB TECHNOLOGIES- Tool-Admin Pending Resource List</title>
<link rel="stylesheet" href="../css/style.css" type="text/css">
    <!-- IE Fix for HTML5 Tags -->
    <!--[if IE]> <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> 
	<![endif]-->
    <style>
.act_resource { background: #373938;
  color: #fff;}
</style>
</head>

<body>

<!-- Wrapper Starts -->

<div class="wrapper">

    <?php  require_once('../includes/header.php'); ?>
    
<?php  require_once('../includes/tools-menu.php'); ?>
  <!-- Content Goes here -->
 
    <article class="inside_wrapper clear_fix">
    <!-- Main Content Goes here -->
    <section class="main_content" style="width:100%;">
    <h1>All Pending Resources</h1>
    <?php if(isset($_REQUEST['msg']) ){ ?>
             <font color="#FF0000"><?php echo $msg; ?><a href="pending-resources-list.php"><img src="/RM/images/cross.png" width="12" height="12" alt="delete"></a></font> <?php } ?>

    <div class="clear-fix">&nbsp;</div>
    <article class="resource_list clear_fix"><?php  $odd=1; ?>
    <?php if($totalRows_getRes1>0) { do { ?>
    <div class="resource_item odd <?php if($row_getRes1['status']=="A") echo "active"; ?>">
      <div class="img_wrap"><img src="/RM/images/<?php if(!empty($row_getRes1['profile_pic'])) echo $row_getRes1['profile_pic']; else echo "black-img.jpg";?>" width="68"></div>
      <p class="resource_title"><?php echo $row_getRes1['full_name']; ?><span class="desig"><br>
          <?php echo $row_getRes1['job_title']; ?><br/>		  Emp id: SDS0<?php echo $row_getRes1['employee_id']; ?>		  </span></p>
      <p class="resource_desc"><?php echo substr($row_getRes1['skill_set'],0,100); ?></p>

<div class="edit_links"> <a href="pending-resources-view.php?user_id=<?php echo $row_getRes1['user_id']; ?>" class="view"></a> <a href="pending-resources-view.php?user_id=<?php echo $row_getRes1['user_id']; ?>" class="edit"></a> </div></div>
<?php } while ($row_getRes1 = mysql_fetch_assoc($getRes1)); } else echo "No records found"; ?>
    </article>
    </section>
    <!-- Sidebar Goes here -->
    <aside class="sidebar">
      <?php #include("timesheet.php"); ?>
    </aside>
    <div class="clear-fix">&nbsp;</div>
    </article>
    
  <div class="clear-fix">&nbsp;</div>
       <!-- Footer Goes here -->
     <?php  require_once('../includes/footer.php'); ?>
    
    
</div>
</body>
</html>
<?php
//mysql_free_result($getRes1);
//mysql_free_result($getProf);
?>