<?php include("includes/head.php"); ?>

<?php include("includes/header.php"); ?>

<?php

if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')

{

	//mysql_query("delete from abs_users where user_id='".$_REQUEST['delete_id']."'");

	mysql_query("delete from  abs_users_history where id='".$_REQUEST['delete_id']."'");

	$delmsg="User details deleted successfully";

}

?>

<script type="text/javascript" language="javascript">

function view(userid)

{

	window.open('view_user.php?userhid='+userid,'news view','height=400, width=1000, resizable=yes, scrollbars=yes');

}

</script>

<div class="container_bottom_section">

<a href="view_user.php?userid=<?php echo $_REQUEST['hid']; ?>&page=<?php echo $_REQUEST['page_main']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&username=<?=$_REQUEST['username']?>&order=<?=$_REQUEST['order']?>&title=<?=$_REQUEST['title']?>&status=<?=$_REQUEST['status']?>&rcv_reqs_email=<?=$_REQUEST['rcv_reqs_email']?>&submittals_emails=<?=$_REQUEST['submittals_emails']?>&rvc_hotlist_email=<?=$_REQUEST['rvc_hotlist_email']?>&submit2=<?=$_REQUEST['submit2']?>" class="require">Back</a>

<div class="clear">&nbsp;</div>

<table width="1100" border="1" cellspacing="0" cellpadding="0" bordercolor="#616161" style="border-collapse:collapse;">

<?php

if(empty($_REQUEST['success'])){ $_REQUEST['success']=''; }

if($_REQUEST['success']=='1'){

?>

  <tr>

    <td colspan="10" class="head_text" style="background-color:#B2CEFC;">User Added Successfully</td>

  </tr>

<?php

}

if($_REQUEST['success']=='2'){

?>

  <tr>

    <td colspan="10" class="head_text" style="background-color:#B2CEFC;">Details Updated Successfully</td>

  </tr>

<?php

}

if($delmsg!=''){

?>

  <tr>

    <td colspan="10" class="head_text" style=" color:#F00;background:none; text-align:left;" align="left"><?php echo $delmsg; ?></td>

  </tr>

<?php

}

?>

  <tr>

    <td width="107" class="head_text">Name</td>

    <td width="115" class="head_text">User ID</td>

    <td width="109" class="head_text">Title</td>

    <td width="106" class="head_text">User Level</td>

    <td width="109" class="head_text">Status</td>

    <td width="100" class="head_text">Rcv Reqs Email</td>

    <td width="98" class="head_text">Submittals Emails</td>

    <td width="124" class="head_text">Rvc Hotlist Email</td>

    <td width="108" class="head_text">Phone</td>

    <?php /*?><td width="102" class="head_text">V / D</td><?php */?>

  </tr>

  <?php

	$qry_contact = "select * from  abs_users_history where user_id='".$_REQUEST['hid']."' order by effective_date desc";

	$sel_events=mysql_query($qry_contact);

	////////////////////////////////Start pagination////////////////////////////////////

	if(empty($_REQUEST['page'])) { $_REQUEST['page']=''; }

	$page=$_REQUEST['page'];

	if($page==""){ 

		$page = 1; 

	} 

	$max_results = 20; 

	$prev = ($page - 1); 

	$next = ($page + 1); 

	$from = (($page * $max_results) - $max_results); 

	

	$total_results = mysql_num_rows($sel_events); 

	$total_pages = ceil($total_results / $max_results); 

	

	$pagination = ''; 

	

	if($page > 1) 

	{ 

	$pagination .= "<a href=\"user_history.php?page=$prev\" class=\"more_link_pagination_prev\">Previous</a>"; 

	$pagination.="&nbsp;&nbsp;&nbsp;";

	} 

	

	for($i = 1; $i <=$total_pages; $i++) 

	{ 

	if(($page) == $i) 

	{ 

	$pagination .= $i; 

	$pagination.='&nbsp;&nbsp;&nbsp;';

	} 

	else 

	{ 

	$pagination .= "<a href=\"user_history.php?page=$i\" class=\"more_link_pagination\">$i</a>"; 

	$pagination.='&nbsp;&nbsp;&nbsp;';

	} 

	} 

	

	if($page < $total_pages) 

	{ 

	$pagination .= "<a href=\"user_history.php?page=$next\" class=\"more_link_pagination_prev\">Next</a>"; 

	$pagination.="&nbsp;&nbsp;&nbsp;";

	} 

	

	$qry_contact.=" limit $from,$max_results";

	//echo $qry_contact;

	$result=mysql_query($qry_contact);

	////////////////////////////////End pagination////////////////////////////////////

				if(mysql_num_rows($result)>0)

				{

					 $inc=1;

						 while($row_contact_details=mysql_fetch_array($result))

						 {

							 $name = $row_contact_details['name'];

							 $userName = $row_contact_details['username'];

							 $title = $row_contact_details['title'];

							 /*---get title----*/

							 $sql_title = "select * from abs_user_level where id='".$title."'";

							 $qry_title = mysql_query($sql_title);

							 $arr_title = mysql_fetch_assoc($qry_title);

							 $titleName = $arr_title['user_level'];

							 /*------end-------*/

							 $user_level = $row_contact_details['user_level'];

							 $status = $row_contact_details['status'];

							 $rcv_reqs_email = $row_contact_details['rcv_reqs_email'];

							 $submittals_emails = $row_contact_details['submittals_emails'];

							 $rvc_hotlist_email = $row_contact_details['rvc_hotlist_email'];

							 $phone = $row_contact_details['phone'];

  ?>

  <tr>

    <td class="head_text2">
	<a href="view_user.php?userhid=<?php echo $row_contact_details['id'];?>&hid=<?php echo $row_contact_details['user_id'];?>&page=<?=$_REQUEST['page_main']?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&username=<?=$_REQUEST['username']?>&order=<?=$_REQUEST['order']?>&title=<?=$_REQUEST['title']?>&status=<?=$_REQUEST['status']?>&rcv_reqs_email=<?=$_REQUEST['rcv_reqs_email']?>&submittals_emails=<?=$_REQUEST['submittals_emails']?>&rvc_hotlist_email=<?=$_REQUEST['rvc_hotlist_email']?>&submit2=<?=$_REQUEST['submit2']?>" style="color:#094A66; font-family:Arial, Helvetica, sans-serif;">
	<?php echo $name; ?>
    </a>
    </td>

    <td class="head_text2"><?php echo $userName; ?></td>

    <td class="head_text2"><?php echo $titleName; ?></td>

    <td class="head_text2"><?php echo "(".$user_level.":".$titleName.")"; ?></td>

    <td class="head_text2"><?php echo $status; ?></td>

    <td class="head_text2"><?php echo $rcv_reqs_email; ?></td>

    <td class="head_text2"><?php echo $submittals_emails; ?></td>

    <td class="head_text2"><?php echo $rvc_hotlist_email; ?></td>

    <td class="head_text2"><?php echo $phone; ?></td>

    <?php /*?><td class="edit">

    <a href="javascript:void(0);" onClick="return view('<?php echo $row_contact_details['id'];?>');"><img src="images/view.png" alt="View" title="View" /></a>

    <a href="user_history.php?delete=del&delete_id=<?php echo $row_contact_details['id'];?>&hid=<?php echo $row_contact_details['user_id'];?>&page=<?=$_REQUEST['page']?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&main_skills=<?=$_REQUEST['main_skills']?>&order=<?=$_REQUEST['order']?>" onclick="return confirm('Are you sure you want to delete this user?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a>

    </td><?php */?>

  </tr>

  <?php

						 }

  ?>

  <tr>

    <td colspan="10" class="head_text" style="background-color:#B2CEFC;"><?php echo $pagination; ?></td>

  </tr>

  <?php

				}

				else

				{

  ?>

  <tr>

    <td colspan="10" class="head_text" style="background-color:#B2CEFC;">No user found</td>

  </tr>

  <?php

				}

  ?>

</table>





<div class="clear"></div>



</div>

<?php include("includes/footer.php"); ?>