Preview: usertasklist.php
Size: 15.05 KB
/home/jambtst2015/public_html/giraffeng.com/admin/usertasklist.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php
///////////////Add Events///////////////////////////////////////////////
if($_REQUEST['add']=="ADD" && count($_POST)>0 && $_REQUEST['id']=='' && $_REQUEST['action']!="edit")
{
$sql_query=mysql_query("SELECT * FROM `sat_task` WHERE department='".mysql_real_escape_string($_REQUEST['department'])."' AND task='".mysql_real_escape_string($_REQUEST['task'])."' AND main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."' AND user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."'");
$sql_num=mysql_num_rows($sql_query);
if($sql_num>0){
$msg = 4;
header("location:manage_task.php?msg=$msg");
}else{
mysql_query("insert into sat_task set department='".mysql_real_escape_string($_REQUEST['department'])."', task='".mysql_real_escape_string($_REQUEST['task'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."', task_status='".mysql_real_escape_string($_REQUEST['status'])."',type='".mysql_real_escape_string($_REQUEST['type'])."', post_date=now()");
$msg = 1;
header("location:manage_task.php?msg=$msg");
}
}
/////////////End Add//////////////////////////////////////////////
///////////////////////////Edit Events////////////////////////////
if($_REQUEST['edit']=="EDIT" && count($_POST)>0 && $_REQUEST['id']!='' && $_REQUEST['action']=="edit")
{
//echo "update sat_task set department='".mysql_real_escape_string($_REQUEST['department'])."', task='".mysql_real_escape_string($_REQUEST['task'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."', task_status='".mysql_real_escape_string($_REQUEST['status'])."' where task_id=".$_REQUEST['id']."";
//exit;
mysql_query("update sat_task set department='".mysql_real_escape_string($_REQUEST['department'])."', task='".mysql_real_escape_string($_REQUEST['task'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."', task_status='".mysql_real_escape_string($_REQUEST['status'])."' , type='".mysql_real_escape_string($_REQUEST['type'])."' where task_id=".$_REQUEST['id']."");
$msg = 2;
header("location:manage_task.php?msg=$msg&search_market=".$_REQUEST['search_market']."&page=".$_REQUEST['page_hide']."");
}
///////////////////////////End edit events////////////////////////
///////////////////////////For Edit////////////////////////////////////////////////
$array_product_details="";
if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit'])
{
$array_product_details=mysql_fetch_array(mysql_query("select * from sat_task where task_id=".$_REQUEST['id'].""));
//$_REQUEST['productname']=$array_product_details['exhibit'];
//$_REQUEST['market']=$array_product_details['category_id'];
}
//////////////////////End for edit///////////////////////////////////////////
///////////////////For Delete//////////////////////////////////////////////
if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')
{
//echo $_REQUEST['page'];
//exit("yes");
mysql_query("delete from sat_task where task_id=".$_REQUEST['delete_id']."");
$msg = 3;
header("location:manage_task.php?msg=$msg&search_market=".$_REQUEST['search_market']."&page=".$_REQUEST['page']."");
}
///////////////////////End for delete//////////////////////////////////
if(!$_REQUEST['page'])
{
$_SESSION['srchstr']="";
$_SESSION['srchkey']="";
}
?>
<script type="text/javascript" language="javascript">
function validate()
{
if(document.frmproduct.market.value=='')
{
alert("Please enter category");
document.frmproduct.market.focus();
return false;
}
if(document.frmproduct.productname.value=='')
{
alert("Please enter exhibit name");
document.frmproduct.productname.focus();
return false;
}
return true();
}
</script>
<?php
$msg=$_REQUEST['msg'];
if($msg == 1){
$msg = '<font color="#009933">Task added successfully</font>';
}
if($msg == 2){
$msg = '<font color="#009933">Task updated successfully</font>';
}
if($msg == 3){
$msg = "Task deleted successfully";
}
if($msg == 4){
$msg = "Task already exsists under this department, activity and user initial";
}
?>
<script>
jQuery.noConflict();
(function($) {jQuery(document).ready(function(){
// binds form submission and fields to the validation engine
jQuery("#formID").validationEngine();
});})(jQuery);
function open_src(val){
if(val==''){
$('#div_add_task').toggle("slow");
}
else{
$('#div_src_req').toggle("slow");
}
}
$(document).ready(function(){
setTimeout(function(){
$(".mydiv").fadeOut("slow", function () {
$(".mydiv").remove("slow");
});
}, 4000);
});
</script>
<div class="container_bottom_section">
<?php if($_REQUEST['msg']=='3'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='1'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='2'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='4'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<!--<a href="javascript:window.history.back();" class="require" style="margin-right:5px; margin-bottom:5px;">Back</a>-->
<?php if($_REQUEST['action']=="" && $_REQUEST['id']==''){ ?>
<a href="javascript:window.history.back();" class="require" style="margin-right:5px; margin-bottom:5px;">Back</a>
<?php } ?>
<div class="clear"></div>
<form name="frmproduct" id="formID" action="manage_task.php" method="post">
<input type="hidden" name="id" value="<?php echo $_REQUEST['id']?>" />
<input type="hidden" name="action" value="<?php echo $_REQUEST['action']?>" />
<input type="hidden" name="page_hide" value="<?php echo $_REQUEST['page']?>" />
<input type="hidden" name="search_market" value="<?php echo $_REQUEST['search_market']?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php /*?><tr>
<td style="padding-left:20px; padding-top:15px;"> </td>
</tr><?php */?>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<?php /*?><tr>
<td width="86%" height="128" align="center"><table width="531" height="129" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">
<tr>
<td align="center" valign="middle" class="head_text" colspan="5">Sort by Exhibit Category</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="111" align="left" valign="middle" class="enquiery"> </td>
<td width="153" height="32" align="left" valign="middle" class="head_text2">Select Exhibit Category </td>
<td width="24" align="left" valign="middle" class="enquiery">:</td>
<td width="170" align="left" valign="middle"><select name="search_market" class="selectfield">
<option value="">--Select --</option>
<? $sql_product=sprintf("select * from sat_task_category where 1 order by category");
$query_product=mysql_query($sql_product);
while($array_product=mysql_fetch_array($query_product))
{
?>
<option value="<?=$array_product['id']?>" <? if($_REQUEST['search_market']==$array_product['id']) echo "selected"; ?>>
<?=$array_product['category']?>
</option>
<?
}
?>
</select></td>
<td width="71"> </td>
</tr>
<tr>
<td align="left" valign="middle" class="enquiery"> </td>
<td height="31" align="left" valign="middle" class="enquiery"> </td>
<td align="left" valign="middle" class="enquiery"></td>
<td align="left" valign="middle" class="button"><input type="submit" name="go" class="newadd" value="GO" border="0" style="margin:0px;" /></td>
<td> </td>
</tr>
<tr class="smalltext">
<td height="10" colspan="5" align="left" valign="middle" class="enquiery"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><?php */?>
</table></td>
</tr>
<tr>
<td class="smalltext" style="color:#2597C9; padding:0 0 15px 5px;"><?php echo check_null_value('firstname','sat_users','user_id',$_REQUEST['userid'],'lastname'); ?>'s Task Lists</td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top" class="smalltext">
<table width="100%" height="99" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" style="border-collapse:collapse;">
<tr class="smalltexthead" bgcolor="#C4E1FF">
<?php /*?><td width="5%" height="22" align="center" class="head_text">No</td><?php */?>
<td width="12%" align="center" class="head_text">Department</td>
<td width="14%" align="center" class="head_text">Task ID</td>
<td width="28%" align="center" class="head_text">Task Name</td>
<td width="9%" align="center" class="head_text">Task Type</td>
<td width="11%" align="center" class="head_text">Main Activity</td>
<td width="12%" align="center" class="head_text">User Initial</td>
<td width="14%" align="center" class="head_text">Status</td>
</tr>
<?php
$no_data=mysql_num_rows(mysql_query("select * from sat_task"));
$query_res="select * from sat_task where task_id!='' and user_id='".$_REQUEST['userid']."'";
if($_REQUEST['search_market']!='')
{
$query_res.=" and category_id='".$_REQUEST['search_market']."'";
}
$query_res.=" order by main_activity_id desc,task";
$sel_product=mysql_query($query_res);
//////////////////////start pagination/////////////////////////
$page=$_REQUEST['page'];
if($_REQUEST['page']=="")
{
$page = 1;
}
//echo $page;
$max_results = 10;
$prev = ($page - 1);
$next = ($page + 1);
$from = (($page * $max_results) - $max_results);
$total_results = mysql_num_rows($sel_product);
$total_pages = ceil($total_results / $max_results);
$pagination = '';
if($page > 1)
{
$pagination .= "<a href=\"manage_task.php?page=$prev&search_market=".$_REQUEST['search_market']."\" class=\"more_link_pagination_prev\">Previous</a>";
$pagination.=" ";
}
for($i = 1; $i <=$total_pages; $i++)
{
if(($page) == $i)
{
$pagination .= $i;
$pagination.=' ';
}
else
{
$pagination .= "<a href=\"manage_task.php?page=$i&search_market=".$_REQUEST['search_market']."\" class=\"more_link_pagination\">$i</a>";
$pagination.=' ';
}
}
if($page < $total_pages)
{
$pagination .= "<a href=\"manage_task.php?page=$next&search_market=".$_REQUEST['search_market']."\" class=\"more_link_pagination_prev\">Next</a>";
$pagination.=" ";
}
$query_res.=" limit $from,$max_results";
//echo $query_res;
$query_products=mysql_query($query_res);
////////////////////////////////End pagination////////////////////////////////////
if(mysql_num_rows($query_products)>0)
{
$inc=1;
while($array_products=mysql_fetch_array($query_products))
{
if($inc%2==0)
{
?>
<tr bgcolor="#eeeeee" class="newtxt">
<?
}
if($_REQUEST['page']!="")
{
$j=($_REQUEST['page']-1)*10;
}
?>
<?php /*?> <td height="30" align="center" valign="middle" class="head_text2"><?php echo $a=($j+$inc); ?></td><?php */?>
<? //$productName=mysql_fetch_array(mysql_query("select * from sat_task_category where id ='".$array_products['category_id']."'")); ?>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['department']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_id']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['task']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['type']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('main_activity','sat_main_activity','main_activity_id',$array_products['main_activity_id']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('user_initial','sat_users','user_id',$array_products['user_id']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_status']?></td>
</tr>
<?php
$inc++;}
}
else{
?>
<tr class="smalltexthead">
<td height="20" colspan="7" align="center" style="color:#666; font-weight:bold; font-family:Verdana, Geneva, sans-serif; font-size:13px;">Sorry, no result found.</td>
</tr>
<?php
}
?>
</table></td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td height="20" colspan="10" align="center" valign="middle" bgcolor="#B2CEFC" class="head_text"><?=$pagination;?></td>
</tr>
</table></td></tr></table>
</form>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180