Preview: transfer.php
Size: 8.36 KB
/home/jambtst2015/public_html/giraffeng.com/admin/transfer.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php
$get_values = mysql_fetch_array(mysql_query("SELECT `user_id` , `user_initial` FROM `sat_users` WHERE `user_id` = '".$_REQUEST['userid']."'"));
$get_all_values = mysql_query("SELECT `user_id` , `user_initial` FROM `sat_users` WHERE status='Active' order by user_initial");
$get_all_value = mysql_query("SELECT `user_id` , `user_initial` FROM `sat_users` WHERE status='Active' order by user_initial");
if(!$_REQUEST['page'])
{
$_SESSION['srchstr']="";
$_SESSION['srchkey']="";
}
if($_REQUEST['edit']=="EDIT"){
mysql_query("UPDATE `sat_staff_task` SET `resource` = '".$_REQUEST['initial']."' WHERE `complete_date`='0000-00-00' AND `resource` = '".$_REQUEST['h_id']."'");
$msg=1;
}
if($_REQUEST['edit1']=="EDIT"){
mysql_query("UPDATE `sat_task` SET `user_id` = '".$_REQUEST['initial1']."' WHERE `user_id` = '".$_REQUEST['h_id1']."'");
$msg=1;
}
?>
<script>
jQuery.noConflict();
(function($) {jQuery(document).ready(function(){
// binds form submission and fields to the validation engine
jQuery("#formID").validationEngine();
});})(jQuery);
</script>
<script type="text/javascript" language="javascript">
function validate()
{
if(document.frmproduct.categoryname.value=='')
{
alert("Please enter exhibit category name");
document.frmproduct.categoryname.focus();
return false;
}
return true();
}
</script>
<?php
//$msg=$_REQUEST['msg'];
if($msg == 1){
$msg = "Transfer tasks Successfully";
}
if($msg == 2){
$msg = "Notes updated successfully";
}
if($msg == 3){
$msg = "Notes deleted successfully";
}
if($msg == 4){
$msg = "Notes already exsists";
}
?>
<div class="container_bottom_section">
<a href="user.php?userid=<?php echo $_REQUEST['userid']; ?>&page=<?php echo $_REQUEST['pre_page']; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&username=<?=$_REQUEST['username']?>&order=<?=$_REQUEST['order']?>&userclass=<?=$_REQUEST['userclass']?>&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" style="margin-right:5px; margin-bottom:5px;">Back</a>
<div class="clear"></div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php if($msg!='')
{?>
<tr>
<td height="30" colspan="4" align="center" style="color:#093; font-size: 13px; font-weight: bold; padding: 0 0 5px; font-family:Arial,Helvetica,sans-serif"><?php echo $msg;?></td>
</tr>
<?php
}
?>
<tr>
<td width="86%" height="153" align="center">
<table width="100%" height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">
<tr>
<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Transfer User</td>
</tr>
<tr class="smalltext">
<td height="28" colspan="5" align="left" valign="middle" class="enquiery"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="smalltext">
<td width="94" align="left" valign="top" class="enquiery"></td>
<td width="858" height="10" align="left" valign="top" class="head_text2" style="padding:3px;"></td>
<td width="1" align="left" valign="top" class="enquiery"></td>
<td width="257" align="left" valign="top"></td>
<td width="117" valign="top"></td>
</tr>
<tr class="smalltext">
<td height="10" colspan="5" align="left" valign="top" class="enquiery">
<form name="frmproduct" id="formID" action="" method="post" >
<table width="100%" class="head_text3">
<tbody>
<tr>
<td width="58" align="left"> </td>
<input type="hidden" name="h_id" value="<?php echo $_REQUEST['userid']; ?>" />
<td width="887" align="left">Transfer All Pending tasks From
<?php echo " ".$get_values['user_initial']." ";?> To
</td>
<td width="194" align="left" valign="top"><select name="initial" class="validate[required] selectfield require_select">
<option value="">-- Select --</option>
<?php
//$sql_title = "select * from abs_users where title in (1,2,3) and status = 'Active' order by user_id";
// $qry_title = getUsers();
while($get_all_values1 = mysql_fetch_array($get_all_values)){
?>
<option value="<?php echo $get_all_values1['user_id']; ?>" <?php if($get_all_values1['user_id']==$_REQUEST['userid']) { ?>selected="selected"<?php } ?>><?php echo $get_all_values1['user_initial']; ?></option>
<?php
}
?>
</select></td>
<td width="87"><input type="submit" name="edit" class="newadd" value="EDIT" border="0" style="margin:0px;" /></td>
<td width="77"> </td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
<tr class="smalltext">
<td height="10" colspan="5" align="left" valign="top" class="enquiery">
<form name="frmproduct1" id="formID1" action="" method="post" >
<table width="100%" class="head_text3">
<tbody>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left" valign="top"> </td>
<td > </td>
<td > </td>
</tr>
<tr>
<td width="4%" align="left"> </td>
<input type="hidden" name="h_id1" value="<?php echo $_REQUEST['userid']; ?>" />
<td width="68%" align="left">Transfer All tasks Which has been assigned to this resource in the Master List From <?php echo $get_values['user_initial']; ?> to
</td>
<td width="15%" align="left" valign="top"><select name="initial1" class="validate[required] selectfield require_select">
<option value="">-- Select --</option>
<?php
while($get_all_values2 = mysql_fetch_array($get_all_value)){
?>
<option value="<?php echo $get_all_values2['user_id']; ?>" <?php if($get_all_values2['user_id']==$_REQUEST['userid']) { ?>selected="selected"<?php } ?>><?php echo $get_all_values2['user_initial']; ?></option>
<?php
}
?>
</select></td>
<td width="7%" ><input type="submit" name="edit1" class="newadd" value="EDIT" border="0" style="margin:0px;" /></td>
<td width="6%" > </td>
</tr>
</tbody>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr class="smalltext head_text3" style="padding:3px;">
<td class="head_text3" width="430" valign="top" align="left" height="22" style="padding:3px;">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td></tr></table>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180