Preview: activitytask.php
Size: 42.77 KB
/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']="";
//}
?>
<script type="text/javascript" language="javascript">
function validate()
{
if(document.frmproduct.market.value=='')
{
alert("Please enter category");
document.frmproduct.market.focus();
return false;
}
if(document.frmproduct.productname.value=='')
{
alert("Please enter exhibit name");
document.frmproduct.productname.focus();
return false;
}
return true();
}
//<![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);
?>
<script>
jQuery.noConflict();
(function($) {jQuery(document).ready(function(){
// binds form submission and fields to the validation engine
jQuery("#formID").validationEngine();
});})(jQuery);
function open_src(val){
if(val==''){
$('#div_add_task').toggle("slow");
}
else{
$('#div_src_req').toggle("slow");
}
}
$(document).ready(function(){
setTimeout(function(){
$(".mydiv").fadeOut("slow", function () {
$(".mydiv").remove("slow");
});
}, 4000);
});
</script>
<div class="container_bottom_section">
<?php if($_REQUEST['msg']=='3'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='1'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='2'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='4'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<!--<a href="javascript:window.history.back();" class="require" style="margin-right:5px; margin-bottom:5px;">Back</a>-->
<?php if($_REQUEST['action']=="" && $_REQUEST['id']==''){ ?>
<!--<a href="javascript:open_src('');" class="require" style="margin-right:5px; margin-bottom:5px;">Add Activity</a>-->
<?php } ?>
<div class="clear"></div>
<form name="frmproduct" id="formID" action="activitytask.php" method="post">
<input type="hidden" name="id" value="<?php echo $_REQUEST['id']?>" />
<input type="hidden" name="action" value="<?php echo $_REQUEST['action']?>" />
<input type="hidden" name="page_hide" value="<?php echo $_REQUEST['page']?>" />
<input type="hidden" name="search_market" value="<?php echo $_REQUEST['search_market']?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php /*?><tr>
<td style="padding-left:20px; padding-top:15px;"> </td>
</tr><?php */?>
<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>
<td align="center" valign="middle" colspan="5" class="head_text" >
<?php if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit']){ ?>Edit<?php }else{ ?>Add<?php } ?> Task
</td>
</tr>
<tr class="smalltext">
<td height="11" colspan="5" align="left" valign="middle" class="enquiery"></td>
</tr>
<tr class="smalltext">
<td height="28" colspan="5" align="left" valign="middle" class="enquiery"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="smalltext">
<td width="110" align="left" valign="middle" class="enquiery"> </td>
<td width="153" height="28" align="left" valign="middle" class="head_text2">Staff Name<font color="#FF0000">*</font></td>
<td width="25" align="left" valign="middle" class="enquiery">:</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>
<td width="71"> </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;">Client Name<font color="#FF0000">*</font></td>
<td align="left" valign="middle" class="enquiery">:</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>
<td> </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;">End Client Name<font color="#FF0000">*</font></td>
<td align="left" valign="middle" class="enquiery">:</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>
<td> </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" class="enquiery">:</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>
<td> </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;">Work Location<font color="#FF0000">*</font></td>
<td align="left" valign="middle" class="enquiery">:</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>
<td> </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;">Comments<font color="#FF0000">*</font></td>
<td align="left" valign="middle" class="enquiery">:</td>
<td align="left" valign="middle">
<textarea name="comments" id="comments" class="validate[required] textfield" style="width:180px; height:66px" ><?php echo $_REQUEST['comments']; ?></textarea>
</td>
<td> </td>
</tr>
<tr>
<td align="left" valign="middle" class="enquiery"> </td>
<td height="30" align="left" valign="middle" class="enquiery"> </td>
<td align="left" valign="middle" class="enquiery"></td>
<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 class="smalltext">
<td height="10" colspan="5" align="left" valign="middle" class="enquiery"></td>
</tr>
</table></td>
</tr>
</table>
</div><?php */?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="taskList">
<?php /*?><form name="frmproduct" id="formID" action="activitytask.php" method="post"><?php */?>
<tr>
<td width="86%" height="128" align="center"><table width="531" height="129" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">
<tr>
<td align="center" valign="middle" class="head_text" colspan="5">Task List For <?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>
<tr class="smalltext">
<td height="28" colspan="5" align="left" valign="middle" class="enquiery"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="smalltext">
<td width="123" align="left" valign="middle" class="head_text2 alignleft">Staff Name</td><td width="17">:</td>
<td width="126" height="32" align="left" valign="middle" class="head_text2 alignleft borderRight"><input type="hidden" value="<?php echo $staff; ?>" name="s_name" /><?php $staff_name=mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_staff` WHERE `staff_id` = '".$_REQUEST['staff']."'")); echo $staff_name['firstname']." ".$staff_name['lastname']; ?></td>
<td width="16" align="left" valign="middle" class="enquiery"> </td>
<td width="135" align="left" valign="middle" class="head_text2 alignleft">Activity</td><td width="10">
:</td>
<td width="102" class="head_text2 alignleft"><input type="hidden" value="<?php echo $main_activity_id; ?>" name="a_id" /><?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>
<tr>
<td align="left" valign="middle" class="head_text2 alignleft">Client Name</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2 alignleft borderRight" ><input type="hidden" value="<?php echo $client_name; ?>" name="c_name" /><?php if($_REQUEST['client_name']!=''){ echo $_REQUEST['client_name']; }else{ echo "N/A"; }?></td>
<td align="left" valign="middle" class="enquiery"></td>
<td align="left" valign="middle" class="head_text2 alignleft">Effective Date</td><td> :</td>
<td class="head_text2 alignleft"><input type="hidden" value="<?php echo $effective_date; ?>" name="e_date" /><?php echo $_REQUEST['effective_date'];?></td>
</tr>
<tr>
<td align="left" valign="middle" class="head_text2 alignleft">End Client Name</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2 alignleft borderRight"><input type="hidden" value="<?php echo $end_client_name; ?>" name="ec_name" /><?php if($_REQUEST['end_client_name']!=''){ echo $_REQUEST['end_client_name']; }else{ echo "N/A"; } ?></td>
<td align="left" valign="middle" class="enquiery"></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 class="smalltext">
<!--<td height="10" colspan="5" align="left" valign="middle" class="enquiery"></td>-->
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr><td> </td></tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top" class="smalltext">
<table width="100%" height="99" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" style="border-collapse:collapse;">
<tr class="smalltexthead" bgcolor="#C4E1FF">
<!--<td width="5%" height="22" align="center" class="head_text">No</td>-->
<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">Status</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)
{
?>
<tr bgcolor="#eeeeee" class="newtxt">
<?
}
if($_REQUEST['page']!="")
{
$j=($_REQUEST['page']-1)*10;
}
?>
<?php /*?><td height="30" align="center" valign="middle" class="head_text2"><?php echo $a=($j+$inc); ?></td><?php */?>
<? //$productName=mysql_fetch_array(mysql_query("select * from sat_task_category where id ='".$array_products['category_id']."'")); ?>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['department']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_id']; ?></td>
<td align="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{
?>
<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;">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>
<td align="center" valign="top"> </td>
</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"); ?>
Directory Contents
Dirs: 17 × Files: 180