芝麻web文件管理V1.00

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

<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<script>

$(document).ready(function(){

jQuery('#chkAllFiles').click(function(){

jQuery(".check_box").attr('checked', jQuery('#chkAllFiles').is(':checked'));

});
});

</script>
<?php //require_once('mail_function/class.phpmailer.php'); ?>
<?php include ("includes/libmail.php"); ?>
<?php
//------- save Values ------//

$staff = $_REQUEST['staff'];
if($staff==''){
	//header("location:activity.php");
}
$client_name = mysql_real_escape_string($_REQUEST['client_name']);
$main_activity_id = $_REQUEST['main_activity_id'];
$end_client_name = mysql_real_escape_string($_REQUEST['end_client_name']);
$effective_date = $_REQUEST['effective_date'];
$work_location = mysql_real_escape_string($_REQUEST['work_location']);
$comments = mysql_real_escape_string($_REQUEST['comments']);
//end of save value//

//DUPLICATE CHECK//
//echo "SELECT `staff_id` FROM `sat_staff_activity` WHERE `staff_id` ='".$staff."' AND `effective_date`='".change_dateformat($effective_date)."' AND `main_activity_id`='".$main_activity_id."'";
 $check_duplicate = mysql_num_rows(mysql_query("SELECT `staff_id` FROM `sat_staff_activity` WHERE `staff_id` ='".$staff."' AND `effective_date`='".change_dateformat($effective_date)."' AND `main_activity_id`='".$main_activity_id."'"));
if($check_duplicate!=0){
	header("location:activity.php?msg=4");
}
//END OF DUPLICATE CHECK//

///////////////Add Events///////////////////////////////////////////////	
if($_REQUEST['submit']=="Save")
{
	
	$ccEmail = 'info@absi-usa.com';
	$query = mysql_query("select `task_id` from `sat_task` where main_activity_id='".$_REQUEST['a_id']."'  AND `task_status` = 'Active'");
	
	//get all id of task//
	while($task_array = mysql_fetch_array($query)){
		$task_array1[] = $task_array['task_id'];
	}
	//get all id of task//
	
	$date_today = date("Y-m-d");
		
		mysql_query("insert into `sat_staff_activity` set staff_id='$_REQUEST[s_name]', client_name='$_REQUEST[c_name]', main_activity_id='$_REQUEST[a_id]', end_client_name='$_REQUEST[ec_name]', effective_date='".change_dateformat($_REQUEST["e_date"])."', work_location='$_REQUEST[w_location]' , comments='$_REQUEST[com]' ,
		`complite_date` = '$date_today' , user_id='".$_SESSION['sat_login_id']."'");
		//$activity_id = mysql_fetch_array(mysql_query("SELECT `staff_activity_id` FROM  `sat_staff_activity` ORDER by `staff_activity_id` desc"));
		$activity_id = mysql_insert_id();
		//echo "<pre>";
		//print_r($task_array1);
		//print_r($_POST['task']);
		$diff = array_uncommon($task_array1 ,$_POST['task'] );
			//print_r($diff);
			
	?>
    <?php
		$table=NULL;
		$pending_task_names ='';
		$userId = '';
		$sep = '';
		foreach($diff as $lang){
		$toEmail = '';
		$to='';
		$task_values = mysql_fetch_array($sql_query=mysql_query("SELECT `task_id` , `task_status` , `user_id`, `task` FROM `sat_task` WHERE  task_id='".$lang."'"));
	
		//store users id
		if($userId!=''){
			$HiddenProducts = explode(',',$userId);
			if (!in_array($task_values['user_id'], $HiddenProducts)) {
				$userId = $userId.$sep.$task_values['user_id'];
				$sep = ',';
			}
		}else{
			$userId = $userId.$sep.$task_values['user_id'];
			$sep = ',';
		}
		
		
		mysql_query("insert into `sat_staff_task` set 
		staff_activity_id='".$activity_id."',
		task_id='".$task_values['task_id']."', 
		resource='".$task_values['user_id']."', 
		user_id='".$_SESSION['sat_login_id']."',
		start_date='".change_dateformat($_REQUEST['e_date'])."' , 
		complete_date='0000-00-00' , 
		staff_task_status='".$task_values['task_status']."' ,
		comments = '".mysql_real_escape_string($_REQUEST["comments2"])."'");
		
		//$task_name[] = $task_values['task'];
		
		/*===============ar-11 email===============*/
		if($_REQUEST['a_id']=='9'){						//for "Change - Home ADDRESS" activity
			if($task_values['task_id'] == '103'){		//for "Inform Staff about AR11 if Non US Citizen" activity
				$ifNotUsCitizen = check_null_value('visa_status','sat_staff','staff_id',$_REQUEST['s_name']);
				if($ifNotUsCitizen!='US Citizen'){		//check Staff visa status not equal "US Citizen" 
				
					// generate ar11 mail //	
					$acmgr_id = check_null_value('account_manager','sat_staff','staff_id',$_REQUEST['s_name']);
					$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
					$mail_to  = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['s_name']);
					$ccEmail = 'info@absi-usa.com';	
					$m = new Mail();
					//$m->clear(TRUE);
					$to=$mail_to; 
					$form = 'itteam@absi-usa.com';
					$subject='AR-11 - SAT';
					
					$body = check_null_value('body','sat_email_template','id','1');
					
					$templete_body = emailTempalte($subject , $body);
					
					$m->From($form);
					$m->Subject($subject);
					$m->Body($templete_body);
					$m->To($to);
					$m->To($ac_email);
					$m->Cc($ccEmail);
					$m->Send();
					//end of ar11 mail //
				}
			}
	
		}
		
		/*===============ar-11 email===============*/
		
		/*===============ABSI Time Reporting, Supplemental Timesheet email===============*/
		if($task_values['task_id'] == '389' || $task_values['task_id'] == '332' || $task_values['task_id'] == '291'){		//for "Inform Staff about AR11 if Non US Citizen" activity
			
			// generate Time Reporting mail //	
			$acmgr_id = check_null_value('account_manager','sat_staff','staff_id',$_REQUEST['s_name']);
			$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
			$mail_to  = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['s_name']);
			$ccEmail = 'info@absi-usa.com';	
			$tr = new Mail();
			//$tr->clear(TRUE);
			$to=$mail_to; 
			$form = 'itteam@absi-usa.com';
			$subject = check_null_value('subject','sat_email_template','id','2');
			
			$body = check_null_value('body','sat_email_template','id','2');
			
			$templete_body = emailTempalte($subject , $body);
			$attach = 'mail_attachment/ABSITimeSheet.xls';
			
			$tr->From($form);
			$tr->Subject($subject);
			$tr->Body($templete_body);
			$tr->To($to);
			$tr->To($ac_email);
			$tr->Cc($ccEmail);
			$tr->Attach($attach);
			$tr->Send();
			//end of Time Reporting mail //
			
			//send Supplemental Timesheet (STS) //
			$getTemplate = check_null_value('body','sat_email_template','id','5');
			$getSubject = check_null_value('subject','sat_email_template','id','5');
			$templete_body = emailTempalte($getSubject,$getTemplate);
			$stsattach = 'mail_attachment/sts.xlsx';
			
			$sts = new Mail();
			$sts->From($form);
			$sts->Subject($getSubject);
			$sts->Body($templete_body);
			
			$sts->To($to);
			$sts->To($ac_email);
			$sts->Cc($ccEmail);
			
			$sts->Attach($stsattach);
			$sts->Send();
			//end Supplemental Timesheet (STS) //
		}
		/*===============ABSI Time Reporting, Supplemental Timesheet email===============*/
		
		/*===============ABSI Project Ending email===============*/
		if($task_values['task_id'] == '415'){		//for "Send Email Reminder on Last day of Project and Make sure get the timesheet" activity
			
			// generate Time Reporting mail //	
			$acmgr_id = check_null_value('account_manager','sat_staff','staff_id',$_REQUEST['s_name']);
			$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
			$mail_to  = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['s_name']);
			$ccEmail = 'info@absi-usa.com';	
			$pe = new Mail();
			//$pe->clear(TRUE);
			$to=$mail_to; 
			$form = 'itteam@absi-usa.com';
			$subject = check_null_value('subject','sat_email_template','id','3');
			
			$body = check_null_value('body','sat_email_template','id','3');
			
			$templete_body = emailTempalte($subject , $body);
			//$attach = 'mail_attachment/ABSITimeSheet.xls';
			
			$pe->From($form);
			$pe->Subject($subject);
			$pe->Body($templete_body);
			$pe->To($to);
			$pe->To($ac_email);
			$pe->Cc($ccEmail);
			//$pe->Attach($attach);
			$pe->Send();
			//end of Time Reporting mail //
		}
		/*===============ABSI Project Ending email===============*/
		
		/*===============ABSI W2 Employee Payroll System Login - ADP & Payroll Calendar email===============*/
		if($task_values['task_id'] == '277' || $task_values['task_id'] == '351'){		//for "Setup ADP & 401K - Send Email to Staff" activity
			
			// generate Time Reporting mail //	
			$acmgr_id = check_null_value('account_manager','sat_staff','staff_id',$_REQUEST['s_name']);
			$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
			$mail_to  = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['s_name']);
			$ccEmail = 'info@absi-usa.com';	
			$w2e = new Mail();
			//$m->clear(TRUE);
			$to=$mail_to; 
			$form = 'itteam@absi-usa.com';
			$subject = check_null_value('subject','sat_email_template','id','4');
			
			$body = check_null_value('body','sat_email_template','id','4');
			
			$templete_body = emailTempalte($subject , $body);
			$attachPayroll = 'mail_attachment/W2_Payroll_Calender_Rel_705.xlsx';
			
			$w2e->From($form);
			$w2e->Subject($subject);
			$w2e->Body($templete_body);
			$w2e->To($to);
			$w2e->To($ac_email);
			$w2e->Cc($ccEmail);
			$w2e->Attach($attachPayroll);
			$w2e->Send();
			//end of Time Reporting mail //
		}
		/*===============ABSI W2 Employee Payroll System Login - ADP & Payroll Calendar email===============*/
		
	
	}
	//echo 'userId: '.$userId;
		//exit('yes');
	//
	//create sm task //
	//$staff_details1=mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` , `visa_status` , `associate_type` , `hphone` , `pemail`,`account_manager` FROM `sat_staff` WHERE `staff_id` = '".$_REQUEST['s_name']."'"));
	
	$qryActivitytask = mysql_query("select task_id from sat_staff_task where staff_activity_id='".$activity_id."' and resource='2'");
	while($arrActivitytask = mysql_fetch_array($qryActivitytask)){
		$task_values = mysql_fetch_array(mysql_query("SELECT `task_id` , `task_status` , `user_id`, `task` FROM `sat_task` WHERE  task_id='".$arrActivitytask['task_id']."'"));
		
		//create sm task //
		$pending_task_names_sm = "<p><li>".$task_values['task']."</li></p>" ;
		$pennding_task_names2_sm = $pending_task_names_sm.$pennding_task_names2_sm;
		//create sm task //
		
	}
	if($pennding_task_names2_sm!=''){
		$table_sm = "<div style='padding-left:5px'><p><b>Pending Tasks (SM):</b></p>".$pennding_task_names2_sm."</div>";
	}else{
		$table_sm = '';
	}
	
	$admin = mysql_fetch_array(mysql_query("SELECT `email` FROM `sat_users` WHERE `user_id` = '".$_SESSION['sat_login_id']."'"));
		
		
		
		//$form_name = 'ayan';
		
		$staff_details1=mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` , `visa_status` , `associate_type` , `hphone` , `pemail`,`account_manager`,`hr_manager` FROM `sat_staff` WHERE `staff_id` = '".$_REQUEST['s_name']."'"));
		
		//print_r($staff_details1);exit;
		
		$activity_name = mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '".$_REQUEST['a_id']."'"));
		$account_manager = mysql_fetch_array(mysql_query("SELECT `email` FROM `sat_users` WHERE `user_id` = '".$staff_details1['account_manager']."'"));
		$subject1 = "New Ticket Create for ".$staff_details1['firstname']." ".$staff_details1['lastname']." - Activity: ".$activity_name['main_activity']." (Effective ".$_REQUEST['e_date'].")";
		
		if($staff_details1['hphone']!='0000-00-00')
		{ 
		$phone =  $staff_details1['hphone']; 
		}else{ 
		$phone = "N/A"; 
		}
		
		
		$toEmail = check_null_value('email','sat_users','user_id',$UserID);
		
		$body1 = "<table><tr><td>
		<p style='margin-bottom:15px;'>".$subject1."</p>
		<p>Client: ".check_null($_REQUEST['c_name'])."</p>
		<p>End Client: ".check_null($_REQUEST['ec_name'])."</p>
		<p>Comments: ".check_null($_REQUEST['com'])."</p><br>".$table_sm."<br>
		<p>Reference No.: ".check_null($activity_id)."</p><br>
		<p>His/Her:</p>
		<p>Visa: ".check_null($staff_details1['visa_status'])."</p>
		<p>Type: ".check_null($staff_details1['associate_type'])."</p>
		<p>Contact Phone: ".$phone."</p>
		<p>Contact Email: ".check_null($staff_details1['pemail'])."</p></td></tr></table>";
		
		$acc_mngrEmail =  check_null_value('email','sat_users','user_id',$staff_details1['account_manager']);
		$hr_mngrEmail =  check_null_value('email','sat_users','user_id',$staff_details1['hr_manager']);
		
		if($hr_mngrEmail!='N/A'){
			$tomail_sat = $hr_mngrEmail; //hr maneger
		}else{
			$tomail_sat = $acc_mngrEmail; //ac mgr
		}
		
		
		
		//$attach = 'mail_attachment/ABSITimeSheet.xls';
		//$t='ayan@infosolz.com';
		$body2 = emailTempalte($subject1,$body1);
		$acc_mngr =  $account_manager['email'];
		$e = new Mail();
		$form1 = "SAT@ABSI <itteam@absi-usa.com>";
		$e->From ($form1);
		$e->Subject ($subject1);
		$e->Body ($body2);
		//$e->to ($staff_details1['pemail']);
		//$e->to ($acc_mngr);//previous one
		$e->to ($tomail_sat); 
		//$e->to ($t);$e->to ($acc_mngr);
		//$m->attach($attach);
		$e->cc($ccEmail);
		$e->Send();
	
	
	//create sm task //
	
	$UserID = explode(',',$userId); 
	foreach($UserID as $UserID){
		if($UserID!=2){
		$table=NULL;
		$pending_task_names ='';
		$pennding_task_names2='';
		$toEmail = '';
		$to='';
		$qryActivitytask = mysql_query("select task_id from sat_staff_task where staff_activity_id='".$activity_id."' and resource='".$UserID."' and resource!='2'");
		while($arrActivitytask = mysql_fetch_array($qryActivitytask)){
			$task_values = mysql_fetch_array(mysql_query("SELECT `task_id` , `task_status` , `user_id`, `task` FROM `sat_task` WHERE  task_id='".$arrActivitytask['task_id']."'"));
	
			//create task //
			$pending_task_names = "<p><li>".$task_values['task']."</li></p>" ;
			$pennding_task_names2 = $pending_task_names.$pennding_task_names2;
			//create task //
			
		}
		$table = "<div style='padding-left:5px'>".$pennding_task_names2."</div>";
		
		
		
	//$table_sm = "<div style='padding-left:5px'>".$pennding_task_names2_sm."</div>";
	
		//mail for pending task //
		
		$admin = mysql_fetch_array(mysql_query("SELECT `email` FROM `sat_users` WHERE `user_id` = '".$_SESSION['sat_login_id']."'"));
		
		
		
		//$form_name = 'ayan';
		
		$staff_details1=mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` , `visa_status` , `associate_type` , `hphone` , `pemail`,`account_manager` FROM `sat_staff` WHERE `staff_id` = '".$_REQUEST['s_name']."'"));
		
		$activity_name = mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '".$_REQUEST['a_id']."'"));
		$account_manager = mysql_fetch_array(mysql_query("SELECT `email` FROM `sat_users` WHERE `user_id` = '".$staff_details1['account_manager']."'"));
		$subject1 = "New Tasks for ".$staff_details1['firstname']." ".$staff_details1['lastname']." - Activity: ".$activity_name['main_activity']." (Effective ".$_REQUEST['e_date'].")";
		
		if($staff_details1['hphone']!='0000-00-00')
		{ 
		$phone =  $staff_details1['hphone']; 
		}else{ 
		$phone = "N/A"; 
		}
		
		$toEmail = check_null_value('email','sat_users','user_id',$UserID);
		
		$body1 = "<table><tr><td>
		<p style='margin-bottom:15px;'>".$subject1."</p>
		<p>Client: ".check_null($_REQUEST['c_name'])."</p>
		<p>End Client: ".check_null($_REQUEST['ec_name'])."</p>
		<p>Comments: ".check_null($_REQUEST['com'])."</p><br>
		<p><b>Pending Tasks:</b></p>".$table."<br>
		<p>Reference No.: ".check_null($activity_id)."</p><br>
		<p>His/Her:</p>
		<p>Visa: ".check_null($staff_details1['visa_status'])."</p>
		<p>Type: ".check_null($staff_details1['associate_type'])."</p>
		<p>Contact Phone: ".$phone."</p>
		<p>Contact Email: ".check_null($staff_details1['pemail'])."</p></td></tr></table>";
		
		//$attach = 'mail_attachment/ABSITimeSheet.xls';
		//$t='ayan@infosolz.com';
		$body2 = emailTempalte($subject1,$body1);
		$acc_mngr =  $account_manager['email'];
		$e = new Mail();
		$form1 = "SAT@ABSI <itteam@absi-usa.com>";
		$e->From ($form1);
		$e->Subject ($subject1);
		$e->Body ($body2);
		//$e->to ($staff_details1['pemail']);
		$e->to ($toEmail);
		//$e->to ($t);
		//$m->attach($attach);
		//if($staff_details1['account_manager']==$UserID){
			//$e->cc($acc_mngr);
		//}
		$e->cc($ccEmail);
		$e->Send();
		
		//mail for pending task //	
	
		}
	}
	
	
	
	
	
	
	
	header("location:activity.php?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_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'].""));
//	$mum_row = mysql_num_rows($array_product_details);
//	//$_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();

}

//<![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 = "Task deleted successfully";

}

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

$query_res="select * from sat_task where main_activity_id='".$_REQUEST['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>

</tr>

<td width="123" align="left" valign="middle" class="head_text2 alignleft">Staff Name</td><td width="17">:</td>

<td width="135" align="left" valign="middle" class="head_text2 alignleft">Activity</td><td width="10">
                       :</td>

</tr>

<tr>

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

<td align="left" valign="middle" class="head_text2 alignleft">Effective Date</td><td> :</td>

</tr>
                     
                     
                     <tr>

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

<td align="left" valign="middle" class="head_text2 alignleft">Work Location</td><td>:</td>

<td class="head_text2 alignleft"><input type="hidden" value="<?php echo $work_location; ?>" name="w_location" /><?php if($_REQUEST['work_location']!=''){ echo $_REQUEST['work_location']; }else { echo "N/A" ; } ?></td>

</tr>
                     <tr align="center">
						<td align="left" valign="middle" class="head_text2 alignleft">Comments</td><td>:</td>
                        <td height="31" align="left" valign="middle" class="head_text2 alignleft borderRight"><input type="hidden" value="<?php echo $comments; ?>" name="com" /><?php if($_REQUEST['comments']!=''){ echo $_REQUEST['comments']; }else{ echo "N/A"; } ?></td>

</tr>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

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

<tr>

<tr>

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

<td width="23%" align="left" class="head_text" style="padding-left:16px; text-align:left"> <input id="chkAllFiles" type="checkbox" title="All Files" <?php /*?>onchange="selectAllFiles(this.checked,<?php echo $num_row; ?>);"<?php */?> style="margin-right:8px;" />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">Comments</td>
                     <td width="13%" align="center" class="head_text">Effective Date</td>
                    <?php /*?> <td width="22%" align="center" class="head_text">E / D</td><?php */?>

</tr>

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

{

}

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="left" style="padding-left:16px; text-align:left" class="head_text2"><input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>" align="left" id="chkFile" style="margin-right:8px;" class="check_box"><?php echo $array_products['task']; ?></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 $initial_user = mysql_fetch_array(mysql_query("SELECT `user_initial` FROM `sat_users` WHERE `user_id`='".$array_products['user_id']."'")); echo $initial_user['user_initial']; ?></td>
					 <?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"><input type="text" name="comments2" id="comments2"></td>
                      <td align="center" valign="middle" class="head_text2"><?php echo $_REQUEST['effective_date']; ?></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="8" align="center">
         <input type="submit" class="newadd" name="submit" value="Save">
          
         <button name="cancel" class="newadd" onclick="document.location.href='activity.php';" >Cancel</button>
         </td>
   </tr> 
                        <?php

}

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>
                     
                      <tr class="smalltexthead">

<td height="20" colspan="8" align="center" style="color:#666; font-weight:bold; font-family:Verdana, Geneva, sans-serif; font-size:13px;"><button name="cancel" class="newadd" onclick="document.location.href='activity.php';" >Cancel</button></td>

</tr>

<?php

}

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

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