芝麻web文件管理V1.00

编辑当前文件:/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']="";
}		
?>

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";

}

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>

<tr>

<?php /*?><tr>

</tr><?php */?>

</table></td>

</tr>

<tr>

<?php /*?><tr>

<tr>

<td align="center" valign="middle" class="head_text" colspan="5">Sort by Exhibit Category</td>

</tr>

<td width="153" height="32" align="left" valign="middle" class="head_text2">Select Exhibit Category </td>

<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))

{

<?=$array_product['category']?>

</option>

}

</select></td>

</tr>

<tr>

</tr>

</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>

<tr>

<?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)

{

}

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']."'")); ?>

</tr>

<?php

$inc++;}

}

else{

<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>

</tr>

<tr>

</tr>

</table></td></tr></table>

</form>

</div>

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