芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/activity.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_staff_activity` set staff_id='".mysql_real_escape_string($_REQUEST['staff'])."', client_name='".mysql_real_escape_string($_REQUEST['client_name'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', end_client_name='".mysql_real_escape_string($_REQUEST['end_client_name'])."', effective_date='".change_dateformat(mysql_real_escape_string($_REQUEST['effective_date']))."', work_location='".mysql_real_escape_string($_REQUEST['work_location'])."' , comments='".mysql_real_escape_string($_REQUEST['comments'])."'");
		//$msg = 1;
		
	//}
//}
/////////////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'])."' where task_id=".$_REQUEST['id']."");
	$msg = 2;
	header("location:manage_task.php?msg=$msg&search_market=".$_REQUEST['search_market']."&page=".$_REQUEST['page']."");
	
	
}
///////////////////////////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']!='')
{
	 $_REQUEST['page'];
	//exit("yes");
	mysql_query("delete from `sat_staff_activity` where staff_activity_id=".$_REQUEST['delete_id']."");
	mysql_query("delete from `sat_staff_task` where staff_activity_id=".$_REQUEST['delete_id']."");
	$msg = 3;
	header("location:activity.php?msg=3&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();

}

/* 
						$(function() {
						$( "#credit_1" ).datepicker({
							dateFormat:"<?php echo $dateFormat; ?>"
						});
						//$( "#post_date" ).datepicker( "dd-mm-yy", "dateFormat" );
						});
*/

$('body').on('click', 'input.datepicker', function(event) {
    $(this).datepicker({
        showOn: 'focus',
        //yearRange: '1900:+0',
        //changeMonth: true,
        //changeYear: true,
		dateFormat:"<?php echo $dateFormat; ?>"
    }).focus();
});

/* Edit Date */
$(document).ready(function(){
	$(".editDateef").on("click", function() {
    // statement
	var answerid = $(this).attr('id');
	
	var res = answerid.split("_");
	
	var incb = res['1'];
	var idb = res['2'];
	$.ajax({
		url : 'editdate.php',
		type : 'POST',
		data : 'inc=' + incb +'&id=' + idb+'&show=1',
		//dataType : 'json',
		beforeSend : function(jqXHR, settings ){
			//alert(1);
		},
		success : function( data, textStatus, jqXHR){
			//alert(data);
			var total = data.split("||");
			var creditVal = total[0];
			var inc = total[1];
			$('#credit-container'+inc).html('<input type="text" class="textfield datepicker" name="credit_'+inc+'" id="credit_'+inc+'" value="'+creditVal+'" onkeypress="return goodchars(event,\'1234567890.\');" />');
			$('#credit_'+inc).focus();
			$('#editImg'+inc).hide();
			$('#saveImg'+inc).show("slow");
			$('#refImg'+inc).show("slow");
		},
		error : function( jqXHR, textStatus, errorThrown){
			
		}
	});
	});
});

/*function editCredite(inc,user_id){
	$.ajax({
		url : 'editdate.php',
		type : 'POST',
		data : 'inc=' + inc +'&id=' + user_id,
		//dataType : 'json',
		beforeSend : function(jqXHR, settings ){
			//alert(1);
		},
		success : function( data, textStatus, jqXHR){
			//alert(data);
			var total = data.split("||");
			var creditVal = total[0];
			var inc = total[1];
			$('#credit-container'+inc).html('<input type="text" class="textfield date" name="credit_'+inc+'" id="credit_'+inc+'" value="'+creditVal+'" onkeypress="return goodchars(event,\'1234567890.\');" />');
			$('#credit_'+inc).focus();
			$('#editImg'+inc).hide();
			$('#saveImg'+inc).show("slow");
			$('#refImg'+inc).show("slow");
		},
		error : function( jqXHR, textStatus, errorThrown){
			
		}
	});
}*/

/* Edit Date */
/* save edit date */
function saveCredite(inc,user_id){
	
	var date = $('#credit_'+inc).val();
	$.ajax({
		url : 'updatedate.php',
		type : 'POST',
		data : 'inc=' + inc +'&date=' + date +'&user_id=' + user_id+'&action=save',
		//dataType : 'json',
		beforeSend : function(jqXHR, settings ){
			//alert(1);
		},
		success : function( data, textStatus, jqXHR){
			if(data =='error'){
				//window.location.href="activity.php?msg=4";
				alert("Activity already exsists under this department, activity and user initial with the same date");
				$(".hasDatepicker").focus();
			}else{
			var total1 = data.split("||");
			var total = data.split("//");
			var userCredit1 = total[1];
			var userCredit2 = userCredit1.split("||");
			var userCredit = userCredit2[0];
			//alert(userCredit);
			var inc = total1[1];
			$('#credit-container'+inc).html(userCredit);
			$('#saveImg'+inc).hide();
			$('#refImg'+inc).hide();
			$('#editImg'+inc).show("slow");
			}
		},
		/*complete : function( jqXHR, textStatus){
			alert(3);
		},*/
		error : function( jqXHR, textStatus, errorThrown){
			
		}
	});
}
/* save edit date */

</script>

<?php
$msg=$_REQUEST['msg'];
if($msg == 1){

$msg = '<font color="#009933">Activity added successfully</font>';

}

if($msg == 2){

$msg = '<font color="#009933">Activity updated successfully</font>';

}

if($msg == 3){

$msg = "Activity deleted successfully";

}

if($msg == 4){

$msg = "Activity already exsists under this department, activity and user initial with the same date";

}

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

function open_src_search(val){
	if(val==''){
		$('#div_src').toggle("slow");
	}
	else{
		$('#div_src').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:open_src_search();" class="require" style="margin-right:5px; margin-bottom:5px;">Search</a>
<?php if($_REQUEST['action']=="" && $_REQUEST['id']==''){ ?>
<?php if($level != 3){ ?>
<a href="javascript:open_src('');" class="require" style="margin-right:5px; margin-bottom:5px;">Create Ticket</a>
<?php } } ?>

<div style="padding:5px; <?php if($_REQUEST['submit2']=='') { ?>display:none;<?php } ?> border:1px solid #C4C4C4; margin-bottom:10px;" id="div_src">

<h3 style="font-family:Arial, Helvetica, sans-serif; font-size:18px; float:left; color:#2597C9; padding-bottom:5px;">Search By</h3>

</div>

<tr>

</tr>

<tr>

$(function() {

$( "#from" ).datepicker({

dateFormat:"<?php echo $dateFormat; ?>"

});

});
	</script>

</td>

$(function() {

$( "#to" ).datepicker({

dateFormat:"<?php echo $dateFormat; ?>"

});

</script></td>

<td width="115" valign="top" class="require_table_search">Staff:</td>

<td width="264" colspan="4" align="left" valign="top">
    <select name="staff" id="staff" class="selectfield require_select">
    <option value="">-- Select --</option>
          <?php
		  $ActUsers = mysql_query("SELECT `staff_id` , `firstname` , `lastname` FROM `sat_staff` WHERE `current_associate_status`='Active' order by firstname");
		  while($ActUsers1 = mysql_fetch_array($ActUsers))
		  {
		  ?>
          <option value="<?php echo $ActUsers1['staff_id']; ?>" <?php if($ActUsers1['staff_id']==$_REQUEST['staff']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
          <?php } ?>
          </select></td>

</tr>

<td width="132" height="25" valign="top" class="require_table_search">Activity:</td>

<select name="main_activity_id" id="main_activity_id" class="selectfield require_select">
    <option value="">-- Select --</option>
          <?php
		  $ActUsers = mysql_query("SELECT * FROM `sat_main_activity` WHERE 1 order by main_activity");
		  while($ActUsers1 = mysql_fetch_array($ActUsers))
		  {
		  ?>
          <option value="<?php echo $ActUsers1['main_activity_id']; ?>" <?php if($ActUsers1['main_activity_id']==$_REQUEST['main_activity_id']){ ?> selected <?php } ?>><?php echo $ActUsers1['main_activity']; ?></option>
          <?php } ?>
          </select>

</td>

<td colspan="4" align="left" valign="top"><select name="ac_mgr" id="ac_mgr" class="selectfield require_select">
    <option value="">-- Select --</option>
          <?php
		  $ActUsers = mysql_query("SELECT `user_id` , `firstname` , `lastname` FROM `sat_users` WHERE `status`='Active' order by firstname");
		  while($ActUsers1 = mysql_fetch_array($ActUsers))
		  {
		  ?>
          <option value="<?php echo $ActUsers1['user_id']; ?>" <?php if($ActUsers1['user_id']==$_REQUEST['ac_mgr']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
          <?php } ?>
          </select>
</td>

<td width="115" valign="top" class="require_table_search">Created By:</td>

<td width="264" colspan="4" align="left" valign="top">
    <select name="user_id" id="user_id" class="selectfield require_select">
    <option value="">-- Select --</option>
          <?php
		  $ActUsers = mysql_query("SELECT `user_id` , `firstname` , `lastname` FROM `sat_users` WHERE `status`='Active' order by firstname");
		  while($ActUsers1 = mysql_fetch_array($ActUsers))
		  {
		  ?>
          <option value="<?php echo $ActUsers1['user_id']; ?>" <?php if($ActUsers1['user_id']==$_REQUEST['user_id']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
          <?php } ?>
          </select></td>

</tr>
  
  <tr>

</span>
    </td>

</tr>

</table>

</form>

</div>

<tr>

<?php /*?><tr>

</tr><?php */?>

<tr>

<td width="86%" align="center">
				<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="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" class="head_text" >
                     <?php if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit']){ ?>Edit<?php }else{ ?>Add<?php } ?> Staff Activity
                     </td>

</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` WHERE `current_associate_status` = 'Active' ORDER BY firstname,lastname");
					   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</td>

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

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

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

<td align="left" valign="middle"><input name="end_client_name" size="25" type="text" value="<?php echo $_REQUEST['end_client_name']; ?>" class="textfield require_field"  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");
						$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"  readonly="readonly" 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</td>

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

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

<td height="38" align="left" valign="middle" class="head_text2" style="padding:3px;">Comments</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();"  />
                       <input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" onclick="document.location.href='activity.php';" />
                       <?

}

else

{

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

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table> 
                 </div>
                 </td>

</tr>

</table></td>

</tr>

<tr>

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

<tr>

<?php /*?> <td width="5%" height="22" align="center" class="head_text">No</td><?php */?>
                     
                      <td width="7%" align="center" class="head_text">Ref. No.</td>

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

<td width="31%" align="center" class="head_text">Activities</td>
					 <td width="10%" align="center" class="head_text">Pending Tasks</td>
                     <td width="10%" align="center" class="head_text">Effective Date</td>
                     <td width="12%" align="center" class="head_text">A/c Mngr.</td>
                     <td width="11%" align="center" class="head_text">Created By</td>
                      <?php if($user_level==1){ ?>
                     <td colspan="2" align="center" class="head_text">E / D</td>
                     <?php } ?>
                    
                   </tr>

<?php

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

$query_res="select * from `sat_staff_activity` where staff_id!=''";
					if($_REQUEST['from']!='' && $_REQUEST['to']!=''){
							$query_res .= " and `effective_date` >= '".change_dateformat($_REQUEST['from'])."' AND `effective_date` <= '".change_dateformat($_REQUEST['to'])."'";
					}
					if($_REQUEST['from']!='' && $_REQUEST['to']==''){
						$query_res .= " and `effective_date` >= '".change_dateformat($_REQUEST['from'])."'";
					}
					if($_REQUEST['from']=='' && $_REQUEST['to']!=''){
						$query_res .= " AND `effective_date` <= '".change_dateformat($_REQUEST['to'])."'";
					}
					if($_REQUEST['staff']!=''){
						$query_res .= " AND `staff_id` = '".$_REQUEST['staff']."'";
					}
					if($_REQUEST['main_activity_id']!=''){
						$query_res .= " AND `main_activity_id` = '".$_REQUEST['main_activity_id']."'";
					}
					if($_REQUEST['ac_mgr']!=''){
						$query_res .= " AND `staff_id` in (select staff_id from sat_staff where account_manager='".$_REQUEST['ac_mgr']."')";
					}
					if($_REQUEST['user_id']!=''){
						$query_res .= " AND `staff_activity_id` in (select staff_activity_id from sat_staff_task where user_id='".$_REQUEST['user_id']."')";
					}
					$query_res.=" order by `staff_activity_id`  DESC";
					$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=\"activity.php?page=$prev&from=".$_REQUEST['from']."&to=".$_REQUEST['to']."&staff=".$_REQUEST['staff']."&main_activity_id=".$_REQUEST['main_activity_id']."&ac_mgr=".$_REQUEST['ac_mgr']."&user_id=".$_REQUEST['user_id']."\" 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=\"activity.php?page=$i&from=".$_REQUEST['from']."&to=".$_REQUEST['to']."&staff=".$_REQUEST['staff']."&main_activity_id=".$_REQUEST['main_activity_id']."&ac_mgr=".$_REQUEST['ac_mgr']."&user_id=".$_REQUEST['user_id']."\" class=\"more_link_pagination\">$i</a>";

$pagination.='   ';

}

if($page < $total_pages)

{

$pagination .= "<a href=\"activity.php?page=$next&from=".$_REQUEST['from']."&to=".$_REQUEST['to']."&staff=".$_REQUEST['staff']."&main_activity_id=".$_REQUEST['main_activity_id']."&ac_mgr=".$_REQUEST['ac_mgr']."&user_id=".$_REQUEST['user_id']."\" 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']."'")); ?>
                      <td align="center" valign="middle" class="head_text2"><?php echo $array_products['staff_activity_id']; ?></td>

<td align="center" valign="middle" class="head_text2"><?php $user_name = mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_staff` WHERE `staff_id` = '$array_products[staff_id]'")); echo $user_name['firstname']." ".$user_name['lastname'];?></td>
                      <td align="center" valign="middle" class="head_text2"><?php $get_activity = mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '$array_products[main_activity_id]'"));echo $get_activity['main_activity']; ?></td>
                      <td align="center" valign="middle" class="head_text2"><a href="editActivity.php?edit_id=<?php echo $array_products['staff_activity_id'];?>"><u><?php 
					 echo  $no_of_row = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$array_products['staff_activity_id']."'  AND `complete_date` = '0000-00-00' AND `task_id`!='0'"));
					  
					   ?></u></a></td>
                      <td align="center" class="head_text2" id="credit-container<?php echo $inc; ?>">
					  <?php echo change_dateformat_reverse($array_products['effective_date']); ?></td>
					  <td align="center" valign="middle" class="head_text2"><?php
					 // echo "SELECT `account_manager` FROM `sat_staff` WHERE `staff_id` = '$array_products[staff_id]'";
					  $acc_mngr = mysql_fetch_array(mysql_query("SELECT `account_manager` FROM `sat_staff` WHERE `staff_id` = '$array_products[staff_id]'"));
					 
					  $name_of_acc_mngr = mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_users` WHERE `user_id` = '".$acc_mngr['account_manager']."'"));
					  //print_r($name_of_acc_mngr);
					  if($name_of_acc_mngr['firstname']!=''){
						  echo $name_of_acc_mngr['firstname']." ".$name_of_acc_mngr['lastname'];
					  }else{
						  echo "N/A";
					  }
					  
					   ?>
                      
					  </td>
					   <td align="center" valign="middle" class="head_text2"><?php 
					$created_by =  mysql_fetch_array(mysql_query("SELECT `user_id` FROM `sat_staff_activity` WHERE `staff_activity_id` = '$array_products[staff_activity_id]'")); 
					$created_by1 = mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_users` WHERE `user_id` = '$created_by[user_id]'"));
					if($created_by1['firstname']!=''){ 
					echo $created_by1['firstname']." ".$created_by1['lastname']; 
						}else{
							echo "N/A";
						}
					   ?></td>
					
						 <?php if($user_level==1){ ?>
					  <td width="6%" align="center" valign="middle" class="head_text2">
                      <a href="javascript:void(0);" id="editImg_<?php echo $inc; ?>_<?php echo $array_products["staff_activity_id"]; ?>" class="editDateef"><img src="images/1304761512_pen.png" title="Edit Date"></a>
                          
                            <a href="javascript:saveCredite(<?php echo $inc; ?>,<?php echo $array_products['staff_activity_id']; ?>);" id="saveImg<?php echo $inc; ?>" style="display:none;"><img src="images/save.png" title="Save Date"></a>
                            
                            <a href="javascript:refCredite(<?php echo $inc; ?>,<?php echo $array_products['staff_activity_id']; ?>);" id="refImg<?php echo $inc; ?>" style="display:none;"><img src="images/refresh.png" title="Reload"></a>
                            
                            <a href="activity.php?delete=del&delete_id=<?php echo $array_products['staff_activity_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure you want to delete this activity?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a>
                      </td>
                      <?php } ?>
                      
                      
                      
                      
                      
                      
                     <?php /*?> <a href="javascript:void(0);" class="editDateef" id="editImg_<?php echo $inc; ?>_<?php echo $array_products["staff_activity_id"]; ?>"><img src="" alt="Edit" title="Edit" border="0" /></a>  
                      
                      <a href="javascript:saveCredite(<?php echo $inc; ?>,<?php echo $array_products["staff_activity_id"]; ?>);" id="saveImg<?php echo $inc; ?>" style="display:none;"><img src="images/save.png" title="Save date"></a>  
                      
                       <a href="javascript:refCredite(<?php echo $inc; ?>,<?php echo $array_products["staff_activity_id"]; ?>);" id="refImg<?php echo $inc; ?>" style="display:none;"><img src="images/refresh.png" title="Reload"></a>  
                      </td>
                      <td>
                      <a href="activity.php?delete=del&delete_id=<?php echo $array_products['staff_activity_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure you want to delete this activity?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a><?php */?>

</tr>

<?php

$inc++;}

}
					else

{

<td height="20" colspan="8" 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"); ?>