芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/editActivity_bk.php

<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php //require_once('mail_function/class.phpmailer.php'); ?>
<?php include ("includes/libmail.php"); ?>
<?php
//------- save Values ------//
$edit_data = mysql_fetch_array(mysql_query("SELECT * FROM `sat_staff_activity` WHERE `staff_activity_id` = '$_REQUEST[edit_id]'"));
$staff = $edit_data['staff_id'];
if($staff==''){
	//header("location:activity.php");
}
$client_name = $edit_data['client_name'];
$main_activity_id = $edit_data['main_activity_id'];
$end_client_name = $edit_data['end_client_name'];
$effective_date = $edit_data['effective_date'];
$work_location = $edit_data['work_location'];
$comments = $edit_data['comments'];
$complite_date_post = $edit_data['complite_date'];
$today_date = date("Y-m-d");
// get details from task table //
 $get_task_id = mysql_fetch_array(mysql_query("SELECT `task_id` , `user_id` , `comments` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
 
 
 $user_initial = mysql_fetch_array(mysql_query("select `user_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));

// end of getting details //

//end of save value//

/////////////// sat_staff_activity ///////////////////////////////////////////////	
if($_REQUEST['save']=="Update")

{
		
		mysql_query("update `sat_staff_activity` set 
		
		 client_name='$_REQUEST[c_name]',
 
end_client_name='$_REQUEST[ec_name]',
 
work_location='$_REQUEST[w_location]' ,

comments='$_REQUEST[com]'

WHERE `staff_activity_id` = '$_REQUEST[edit_id]'");
}

/////////////End Update //////////////////////////////////////////////

//insert from side edit button //

if($_REQUEST["save"]=="SAVE"){
	
	
	
	echo "<pre>";
	print_r($_REQUEST['task']);
	print_r($_REQUEST['task1']);
	print_r($_REQUEST['h_id_task'][14]);
	//exit;
	
	if(sizeof($_REQUEST['task'])>0){

if($_POST['resource']!=''){
		
	mysql_query("UPDATE `sat_task` SET `user_id` = '".$_REQUEST['resource']."' WHERE `task_id` = '".$_REQUEST['h_id_task']."'");
	}

if($_REQUEST['change_date']!=''){
		
		
		$data_date = change_dateformat($_REQUEST['change_date']);
		mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' ,  `comments` = '$_REQUEST[comments2]' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['h_id_task']."'");
	}
	
  }
  
  	
	foreach($_REQUEST['task1'] as $tasks){
	
		$exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$tasks."'"));
		//echo $exist;exit;
		$update_query = "UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00'";
		if($_REQUEST['comments2']!=''){
		$update_query .= " , `comments` = '$_REQUEST[comments2]'";
		}
		$update_query .= " WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$tasks."'";
		
		
		
		
		
		mysql_query($update_query);
	
	if($exist==0){
	mysql_query("insert into `sat_staff_task` set 
		 staff_activity_id='".$_REQUEST['h_edit_id']."',
		 
		  task_id='".$tasks."', 
		  user_id='".$_SESSION['sat_login_id']."',
		   start_date='".$today_date."' , 
		   complete_date='0000-00-00' , 
			staff_task_status=' ' ,
			comments = '".mysql_real_escape_string($_REQUEST["comments2"])."'");
	    }
	
	}
	
	header("location:editActivity.php?edit_id=$_REQUEST[h_edit_id]");
	
}

//end of insert from side edit button //
	
if($_REQUEST['submit1']=="Save"){
	 
	if(sizeof($_REQUEST['task'])>0){
		
		  foreach($_REQUEST['task'] as $request_task){
		
		$data_date = change_dateformat($_REQUEST['change_date']);
		mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$request_task."'");
	
	
  }
 }
	if(!isset($_REQUEST['task'])){
		
		
		$exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['task_id']."'"));
		//echo $exist;exit;
		mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00'  WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['task_id']."'");
	
	if($exist==0){
	mysql_query("insert into `sat_staff_task` set 
		 staff_activity_id='".$_REQUEST['h_edit_id']."',
		 
		  task_id='".$_REQUEST['task_id']."', 
		  user_id='".$_SESSION['sat_login_id']."',
		   start_date='".$today_date."' , 
		   complete_date='0000-00-00'");
			
			
	    
	}
	
	
}
	
	header("location:editActivity.php?edit_id=$_REQUEST[h_edit_id]");

}

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

}

//<![CDATA[

function selectAllFiles(c,a) {
			  //alert ("hi" + a);
            for (i = 1; i <= a; i++) {
                document.getElementById('chkFile' + i).checked = c;
            }
        }

//]]>
    </script>

</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 = "Date field can't be empty to complite a task";

}

if($msg == 4){

$msg = "Task already exsists under this department, activity and user initial";

}

$no_data=mysql_num_rows(mysql_query("select * from sat_task"));

// create array for existing task id //
//echo "SELECT `task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."' AND `complete_date` = '0000-00-00'";

//$g = mysql_query("SELECT `task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."' AND `complete_date` = '0000-00-00'");
$g = mysql_query("SELECT `task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'");
while($get_task_id1 = mysql_fetch_array($g)){
	$x[] = $get_task_id1['task_id'];
}

// create array for existing task id //

$query_res="select * from sat_task where main_activity_id='".$main_activity_id."'  AND `task_status` = 'Active'";

if($_REQUEST['search_market']!='')

{

$query_res.=" and category_id='".$_REQUEST['search_market']."'";

}

$query_res.=" order by main_activity_id,task";

$sel_product=mysql_query($query_res);
					$num_row = mysql_num_rows($sel_product);

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

<?php if($_REQUEST['action']=="" && $_REQUEST['id']==''){ ?>

<?php } ?>
<div class="clear"></div>

<tr>

<?php /*?><tr>

</tr><?php */?>

<tr>

<td width="86%" align="center">
				<?php /*?><div id="div_add_task" style="display:<?php if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit']){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table width="531" height="378" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

</tr>
					<tr class="smalltext">

</tr>
                   <tr class="smalltext">

<td width="153" height="28" align="left" valign="middle" class="head_text2">Staff Name<font color="#FF0000">*</font></td>

<td width="170" align="left" valign="middle">
                     <select id="staff" name="staff" class="validate[required] textfield">
                     	<option value="">-- Select --</option>
                       <?php
					   $get_staff = mysql_query("SELECT `staff_id`,`firstname`,`lastname` FROM `sat_staff`");
					   while($staff_details = mysql_fetch_array($get_staff)){
					   ?>
                       <option value="<?php echo $staff_details['staff_id'];?>"><?php echo $staff_details['firstname']." ".$staff_details['lastname'];?></option>
                       <?php
					   }
					   ?>
                    </select>
                     </td>

</tr>

<td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">Client Name<font color="#FF0000">*</font></td>

<td align="left" valign="middle"><input name="client_name" size="25" type="text"   class="validate[required] textfield" value="<?php echo $_REQUEST['client_name']; ?>"  id="client_name"/></td>

</tr>
                   
                     <tr class="smalltext">

<td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">End Client Name<font color="#FF0000">*</font></td>

<td align="left" valign="middle"><input name="end_client_name" size="25" type="text"   class="validate[required] textfield" value="<?php echo $_REQUEST['end_client_name']; ?>"  id="end_client_name"/></td>

</tr>
                   
                   <tr class="smalltext">
                     <td align="left" valign="middle" class="enquiery"> </td>
                     <td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">Activity<font color="#FF0000">*</font></td>
                     <td align="left" valign="middle" class="enquiery">:</td>
                     <td align="left" valign="middle">
                     <select id="main_activity_id" name="main_activity_id" class="validate[required] textfield">
                     	<option value="">-- Select --</option>
                        <?php
						$sql_product=sprintf("select * from sat_main_activity where 1 order by main_activity_id");
						$query_product=mysql_query($sql_product);
					    while($array_product=mysql_fetch_array($query_product)){
					   ?>
                       <option value="<?php echo $array_product['main_activity_id']; ?>" <?php if($array_product_details['main_activity_id']==$array_product['main_activity_id']) echo "selected"; ?>>
                       <?php echo $array_product['main_activity']?>
                       </option>
                       <?php
					   }
					   ?>
                        </select>
                        </td>
                     <td> </td>
                   </tr>
                   
                   <tr class="smalltext">
					
                     <script>
					$(function() {
						$( "#effective_date" ).datepicker({
							dateFormat:"<?php echo $dateFormat; ?>"
						});
						//$( "#post_date" ).datepicker( "dd-mm-yy", "dateFormat" );
					});
					</script> 
                    
                     <td align="left" valign="middle" class="enquiery"> </td>

<td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">Effective Date<font color="#FF0000">*</font></td>

<td align="left" valign="middle"><input name="effective_date" size="25" type="text"   class="validate[required] textfield" value="<?php echo $_REQUEST['effective_date']; ?>"  id="effective_date"/></td>

</tr>
                   
                   <tr class="smalltext">

<td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">Work Location<font color="#FF0000">*</font></td>

<td align="left" valign="middle"><input name="work_location" size="25" type="text"   class="validate[required] textfield" value="<?php echo $_REQUEST['work_location']; ?>"  id="work_location"/></td>

</tr>
                   
                   <tr class="smalltext">

<td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">Comments<font color="#FF0000">*</font></td>

</tr>

<tr>

<td colspan="2" valign="middle" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

?>
                       
                       <input type="submit" name="edit" class="newadd" value="EDIT" border="0" style="margin:0px;" onclick="return validate();"  />
                       <a href="activity.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" /></a>
                       <?

}

else

{

?>
                       
                       <input type="submit" name="add" class="newadd" value="ADD" border="0" style="margin:0px;" onclick="return validate();" />
                       <a href="activity.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table> 
                 </div><?php */?>
                 </td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<tr>

<td align="center" valign="middle" class="head_text" colspan="5">Edit Employee Activity <?php $task_name=mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '".$_REQUEST['main_activity_id']."'")); echo $task_name['main_activity']; ?></td>

</tr>

<td width="70" align="left" valign="middle" class="head_text2">Staff Name</td><td width="5">:</td>

<td width="181" align="left" valign="middle" class="head_text2" style="text-align:right">Activity</td><td width="4">
                       :</td>

</tr>

<tr>

<td align="left" valign="middle" class="head_text2">Client Name</td><td>:</td>

<td align="left" valign="middle" class="head_text2" style="text-align:right">Effective Date</td><td> :</td>

</tr>
                     
                     
                     <tr>

<td align="left" valign="middle" class="head_text2">End Client Name</td><td>:</td>

<td align="left" valign="middle" class="head_text2" style="text-align:right">Work Location</td><td>:</td>

<td class="head_text2"><input class="textfield require_field" type="text" value="<?php echo $work_location; ?>" name="w_location" /><?php //echo $work_location; ?></td>

</tr>
                     <tr align="center">
						<td> </td>
                        <td> </td>
                       <td align="right" style="text-align:right" class="head_text2">Comments</td><td>:</td>

</tr>

</table></td>

</tr>

</table></td>

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

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

<tr>

<tr>

<td width="13%" align="center" class="head_text">Department</td>

<td width="23%" align="left" class="head_text" style="text-align:left; padding-left:16px"> <input id="chkAllFiles" <?php if($_REQUEST['act']!='edit'){ ?> disabled="disabled" <?php } ?> type="checkbox" title="All Files" onchange="selectAllFiles(this.checked,<?php echo $num_row; ?>);" />Task</td>
					 <td width="10%" align="center" class="head_text">Activity</td>
                     <td width="14%" align="center" class="head_text">Resource</td>
                      <td width="14%" align="center" class="head_text">User Initial</td>
                      
                     <td width="14%" align="center" class="head_text">Comments</td>
                     <td width="9%" align="center" class="head_text">Completion Date</td>
                     <td width="5%" align="center" class="head_text">Hold</td>
                     <td width="5%" align="center" class="head_text">Action</td></tr>
                     <form action="editActivity.php" method="post">
                    <?php /*?> <td width="22%" align="center" class="head_text">E / D</td><?php */?>

<?php

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

{

?>
                    <?php
					if(isset($_REQUEST['act']) && $_REQUEST['row']==$inc){
						?>
                        <tr bgcolor="#72ACF3" class="newtxt" style="background-color:#CCC; color:#CCC">
                        <?php
					}else{
						?>

<?
                    }

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="left"  class="head_text2" style="text-align:left; padding-left:16px">
                      
                      <?php $query_checked_date =  mysql_query("SELECT `complete_date` FROM `sat_staff_task` WHERE `task_id` = '".$array_products['task_id']."' AND `staff_activity_id` = '".$_REQUEST['edit_id']."'");
						  $query_checked_date1 =  mysql_fetch_assoc($query_checked_date);
						  $query_checked_date1['complete_date'];
						  
						  $get_task_created_by = mysql_fetch_array(mysql_query("select `user_id` from sat_task where main_activity_id='".$main_activity_id."'  AND `task_status` = 'Active' AND `task_id` = '".$array_products['task_id']."'"));
						  
						 // echo "ff".$get_task_id['user_id'];
						  //!in_array($array_products['task_id'], $x)
						  //$_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id'] && 
						  if($get_task_created_by['user_id'] == $_SESSION['sat_login_id']){ ?>
                      <input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>"  align="left" id="chkFile<?php echo $a ; ?>"  <?php if($query_checked_date1['complete_date']!='0000-00-00'){?>  checked <?php }  ?>><?php echo $array_products['task']; ?>
                      <?php
					  }else{
						  //echo "SELECT `complete_date` FROM `sat_staff_task` WHERE `task_id` = '".$array_products['task_id']."' AND `staff_activity_id` = '1'";
						 
					  ?>
                     <input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>"  align="left" id="chkFile<?php echo $a ; ?>"  disabled="disabled" <?php if($query_checked_date1['complete_date']!='0000-00-00'){?>  checked <?php }  ?>><?php echo $array_products['task']; ?>
                      <?php  } ?>
                      
                      
                      </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 $initial_user['user_initial']; ?>
                      
                      <?php
					
					$initial_user = mysql_fetch_array(mysql_query("SELECT `user_id` ,`user_initial` FROM `sat_users` WHERE `user_id`='".$array_products['user_id']."'"));
					
					if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
						
						$get_resource = mysql_query("SELECT `user_id` , `user_initial` FROM  `sat_users`");
						?>
                        <select name="resource">
                        <option value="">--Select--</option>
                        <?php
						while($get_resource1 = mysql_fetch_array($get_resource)){
						?>
                        
                       <option value="<?php echo $get_resource1['user_id']; ?>" <?php if($get_resource1['user_id'] == $initial_user['user_id']){?> selected="selected" <?php  } ?>><?php echo $get_resource1['user_initial']; ?></option> 
                        
                        <?php
						}
						?>
                        </select>
                        <?php
					}else{
					 
                       echo $initial_user['user_initial']; 
					
					}
					
					?>
                      
                      
                      </td>
                      
                      <td align="center" valign="middle" class="head_text2">
                     
                     <?php
					 
                     
                     
                      //$user_initial
                       $initial_user1 = mysql_fetch_array(mysql_query("SELECT  `user_initial` FROM `sat_users` WHERE `user_id`='".$user_initial['user_id']."'"));
					   echo $initial_user1['user_initial'];
					?>
                      
                      
                      </td>
                      
                      <?php
					  $comments_task = mysql_fetch_array(mysql_query("SELECT `comments` FROM `sat_staff_task` WHERE staff_activity_id = $_REQUEST[edit_id] AND task_id = '".$array_products['task_id']."'"));
					  ?>
                      
					  <?php /*?><td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_status']?></td><?php */?>
                      <td align="center" valign="middle" class="head_text2">
                       <?php if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
						   ?>
                      <input type="text" name="comments2" id="comments2" value="<?php echo $comments_task['comments']; ?>">
                      <?php
					   }else{
					   echo $comments_task['comments'];
					   }
					   ?>
                      
                      </td>
                      <td align="center" valign="middle" class="head_text2">
                      
                      <?php
					  $staff_task_date = mysql_fetch_array(mysql_query("SELECT `complete_date` FROM  `sat_staff_task` WHERE staff_activity_id = '".$_REQUEST['edit_id']."' AND `task_id` = '".$array_products['task_id']."'"));
					  
					  
					  $staff_activity_date = mysql_fetch_array(mysql_query("SELECT `complite_date` FROM `sat_staff_activity` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
					  
					  ?>
                      
                       <script>
					$(function() {
						$( "#change_date" ).datepicker({
							dateFormat:"<?php echo $dateFormat; ?>"
						});
						
					});
					</script> 
					  <?php
					  
					  if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
						  ?>
                          <input type="text" name="change_date" id="change_date" value="<?php if($staff_task_date['complete_date']!='0000-00-00'){ echo change_dateformat_reverse($staff_task_date['complete_date']); } ?>">
						  <?php
					  }else{
						  //echo 'date'.$staff_task_date['complete_date'];
					  	if($staff_task_date['complete_date']=="0000-00-00"){
							//echo change_dateformat_reverse($staff_task_date['complete_date']);
						//echo 'date'.change_dateformat_reverse($complite_date_post);	  
						}else{
						echo change_dateformat_reverse($staff_task_date['complete_date']);
						}
						if($query_checked_date1['complete_date']==''){
						echo change_dateformat_reverse($complite_date_post);	
							}
							
					  }
                        ?>
                      
                      </td>
                      
                      <td align="center" valign="middle" class="head_text2">
                      <input type="checkbox" />
                      </td>
                      <input type="hidden" name="task1[]" value="<?php echo $array_products['task_id'];?>" />
                      
                       <td align="center" valign="middle" class="head_text2">
                       
                          <input type="hidden" value="<?PHP echo $array_products['task_id']; ?>" name="h_id_task[<?php echo $array_products['task_id'];?>]" />
                          
                          <input type="hidden" value="<?PHP echo $_REQUEST['edit_id']; ?>" name="h_edit_id" />
                       
                       <?php
					   if(isset($_REQUEST['act']) && $_REQUEST['row']==$inc){
						   ?>
                          
                          
                         
                          
                         <input type="submit"  name="save" value="SAVE" width="40px" class="newadd" style="font-size:10px; margin-top:2px; padding:3px 18px;"/>
                             
                           <a href="editActivity.php?edit_id=<?php echo $_REQUEST['edit_id'];?>" class="newadd" style="text-decoration:none;font-size:10px; margin-top:2px; padding:2px 11px; margin-bottom:5px">Cancel</a>
                           <?php
					   }else{
						   ?>
                       
                       <a href="editActivity.php?act=edit&id=<?php echo $array_products['task_id']; ?>&edit_id=<?php echo $_REQUEST['edit_id'];?>&row=<?php echo $inc ;?>">Edit</a>
                       <?php
					   }
					   ?>
                       </td>

<?php /*?><td align="center" class="head_text2" valign="middle"><a href="manage_task.php?action=edit&id=<?php echo $array_products['task_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>"><img src="images/1304761512_pen.png" alt="Edit" title="Edit" border="0" /></a>  <a href="manage_task.php?delete=del&delete_id=<?php echo $array_products['task_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure you want to delete this task?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a>                      </td><?php */?>

</tr>

<?php

$inc++;
						
						
						}
						?>
                        
    <tr>
    	<td colspan="10" align="center">
         
         <input type="submit" class="newadd" name="submit1" value="Save">
         
          
         <a href="activity.php">
         <input type="button" class="newadd" name="submit" value="Cancel">
         </a>
         </td>
   </tr> 
                        <?php

}

else{

<td height="20" colspan="10" align="center" style="color:#666; font-weight:bold; font-family:Verdana, Geneva, sans-serif; font-size:13px;">Sorry, no result found.</td>

</tr>

<?php

}

</form>
             </table></td>

</tr>

<tr>

</tr>

<tr>

<?php /*?> <td height="20" colspan="10" align="center" valign="middle" bgcolor="#B2CEFC" class="head_text"><?=$pagination;?></td><?php */?>

</tr>

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

</table>

</div>

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