Preview: editActivity.php
Size: 61.50 KB
/home/jambtst2015/public_html/giraffeng.com/admin/editActivity.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php //require_once('mail_function/class.phpmailer.php'); ?>
<?php include ("includes/libmail.php"); ?>
<script>
$(document).ready(function(){
jQuery(".checkTask").click(function(){
var all_checked = false;
jQuery(".checkTask").each(function(){
if(jQuery(this).is(':checked')){
all_checked = true;
}else{
all_checked = false;
return all_checked;
}
});
jQuery("#chkAllFiles").attr('checked', all_checked);
});
jQuery('#chkAllFiles').click(function(){
jQuery(".checkTask").attr('checked', jQuery('#chkAllFiles').is(':checked'));
$("#h_checked").val('');
$("#h_unchecked").val('');
$(".checkTask").each(function() {
//alert(this.checked);
//alert($(this).val());
var val = $(this).val();
var prevch = $("#h_checked").val();
var prevunch = $("#h_unchecked").val();
//selected.push($(this).val());
if(this.checked==false){
if (prevch.indexOf(',') >= -1){
var removeValue = removeFile(prevch,val,',');
$("#h_checked").val(removeValue);
//$("#h_checked").val('');
if(prevunch==''){
$("#h_unchecked").val(val);
} else{
var multicat = $("#h_unchecked").val(prevunch+','+val);
}
}
else{
var removeValue = '';
}
}else{
if (prevunch.indexOf(',') >= -1){
var removeValue = removeFile(prevunch,val,',');
$("#h_unchecked").val(removeValue);
//$("#h_unchecked").val('');
if(prevch==''){
$("#h_checked").val(val);
} else{
var multicat = $("#h_checked").val(prevch+','+val);
}
}
}
});
});
});
jQuery.noConflict();
(function($) {jQuery(document).ready(function(){
// binds form submission and fields to the validation engine
jQuery("#formID").validationEngine();
});})(jQuery);
function removeFile(list, value, separator) {
//separator = separator || ",";
//alert(list);
//alert(value);
//alert(separator);
var values = list.split(separator);
//alert(values);
for(var i = 0 ; i < values.length ; i++) {
if(values[i] == value) {
values.splice(i, 1);
return values.join(separator);
}
}
//alert(list);
return list;
}
$(document).ready(function(){
$('.checkTask').on('change', function() {
// alert(1);
var val = this.checked ? this.value : this.value;
var prevch = $("#h_checked").val();
var prevunch = $("#h_unchecked").val();
//alert(val);
//alert(this.checked);
if(this.checked==true){
//alert(prevunch.indexOf(','));
if (prevunch.indexOf(',') >= -1){
var removeValue = removeFile(prevunch,val,',');
$("#h_unchecked").val(removeValue);
if(prevch==''){
$("#h_checked").val(val);
} else{
var multicat = $("#h_checked").val(prevch+','+val);
}
}
}else{
//alert(prevch.indexOf(','));
if (prevch.indexOf(',') >= -1){
var removeValue = removeFile(prevch,val,',');
$("#h_checked").val(removeValue);
if(prevunch==''){
$("#h_unchecked").val(val);
} else{
var multicat = $("#h_unchecked").val(prevunch+','+val);
}
}
else{
var removeValue = '';
}
$("#cathid").val(removeValue);
}
//alert(finalval);
});
});
//Hold//
$(document).ready(function(){
$('.hold').on('change', function() {
//alert(1);
var val = this.checked ? this.value : this.value;
var prevchh = $("#h_hold").val();
var prevunchh = $("#h_unhold").val();
//alert(val);
//alert(this.checked);
if(this.checked==true){
//alert(prevunch.indexOf(','));
if (prevunchh.indexOf(',') >= -1){
var removeValue = removeFile(prevunchh,val,',');
$("#h_unhold").val(removeValue);
if(prevchh==''){
$("#h_hold").val(val);
} else{
var multicat = $("#h_hold").val(prevchh+','+val);
}
}
}else{
//alert(prevch.indexOf(','));
if (prevchh.indexOf(',') >= -1){
var removeValue = removeFile(prevchh,val,',');
$("#h_hold").val(removeValue);
if(prevunchh==''){
$("#h_unhold").val(val);
} else{
var multicat = $("#h_unhold").val(prevunchh+','+val);
}
}
else{
var removeValue = '';
}
$("#cathid").val(removeValue);
}
//alert(finalval);
});
});
//Hold//
//Single Hold //
$(document).ready(function(){
$('.hold1').on('change', function() {
//alert(1);
var val = this.checked ? this.value : this.value;
var prevchh1 = $("#h_hold1").val();
var prevunchh1 = $("#h_unhold1").val();
//alert(val);
//alert(this.checked);
if(this.checked==true){
//alert(prevunch.indexOf(','));
if (prevunchh1.indexOf(',') >= -1){
var removeValue = removeFile(prevunchh1,val,',');
$("#h_unhold1").val(removeValue);
if(prevchh1==''){
$("#h_hold1").val(val);
} else{
var multicat = $("#h_hold1").val(prevchh1+','+val);
}
}
}else{
//alert(prevch.indexOf(','));
if (prevchh1.indexOf(',') >= -1){
var removeValue = removeFile(prevchh1,val,',');
$("#h_hold1").val(removeValue);
if(prevunchh1==''){
$("#h_unhold1").val(val);
} else{
var multicat = $("#h_unhold1").val(prevunchh1+','+val);
}
}
else{
var removeValue = '';
}
$("#cathid").val(removeValue);
}
//alert(finalval);
});
});
// Single hold //
function removeFile(list, value, separator) {
//separator = separator || ",";
//alert(list);
//alert(value);
//alert(separator);
var values = list.split(separator);
//alert(values);
for(var i = 0 ; i < values.length ; i++) {
if(values[i] == value) {
values.splice(i, 1);
return values.join(separator);
}
}
//alert(list);
return list;
}
$(document).ready(function(){
$('.checkTask1').on('change', function() {
//alert(1);
var val = this.checked ? this.value : this.value;
var prevch = $("#checked1").val();
var prevunch = $("#unchecked1").val();
//alert(val);
//alert(this.checked);
if(this.checked==true){
//alert(prevunch.indexOf(','));
$("#change_date").addClass("validate[required]");
if (prevunch.indexOf(',') >= -1){
var removeValue = removeFile(prevunch,val,',');
$("#unchecked1").val(removeValue);
if(prevch==''){
$("#checked1").val(val);
} else{
var multicat = $("#checked1").val(prevch+','+val);
}
}
}else{
//alert(prevch.indexOf(','));
$("#change_date").removeClass("validate[required]");
if (prevch.indexOf(',') >= -1){
var removeValue = removeFile(prevch,val,',');
$("#checked1").val(removeValue);
if(prevunch==''){
$("#unchecked1").val(val);
} else{
var multicat = $("#unchecked1").val(prevunch+','+val);
}
}
else{
var removeValue = '';
}
$("#cathid").val(removeValue);
}
//alert(finalval);
});
});
</script>
<?php
//------- save Values ------//
$edit_data = mysql_fetch_array(mysql_query("SELECT * FROM `sat_staff_activity` WHERE `staff_activity_id` = '$_REQUEST[edit_id]'"));
$staff = $edit_data['staff_id'];
if($staff==''){
//header("location:activity.php");
}
$client_name = $edit_data['client_name'];
$main_activity_id = $edit_data['main_activity_id'];
$end_client_name = $edit_data['end_client_name'];
$effective_date = $edit_data['effective_date'];
$work_location = $edit_data['work_location'];
$comments = $edit_data['comments'];
$complite_date_post = $edit_data['complite_date'];
$today_date = date("Y-m-d");
// get details from task table //
$get_task_id = mysql_fetch_array(mysql_query("SELECT `task_id` , `user_id` , `comments` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
$user_initial = mysql_fetch_array(mysql_query("select `user_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
// end of getting details //
//end of save value//
/////////////// sat_staff_activity ///////////////////////////////////////////////
if($_REQUEST['save']=="Update")
{
mysql_query("update `sat_staff_activity` set
client_name='$_REQUEST[c_name]',
end_client_name='$_REQUEST[ec_name]',
work_location='$_REQUEST[w_location]' ,
comments='$_REQUEST[com]'
WHERE `staff_activity_id` = '$_REQUEST[edit_id]'");
header("location:editActivity.php?edit_id=$_REQUEST[edit_id]&msg=2");
}
/////////////End Update //////////////////////////////////////////////
//insert from side edit button //
if($_REQUEST["save"]=="SAVE"){
if($_REQUEST['h_hold1']!=''){
$holdStat = '1' ;
}
if($_REQUEST['h_hold1']==''){
$holdStat = '0' ;
}
if($_REQUEST['checked1']!=''){
$c_id = $_REQUEST['checked1'];
$checked_values = mysql_fetch_array(mysql_query("SELECT `staff_task_id`,`resource` , `complete_date` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['checked1']."'"));
$exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$c_id."'"));
if($exist>0){
$com_date = change_dateformat($_REQUEST['change_date_'.$c_id]);
$sql89 = "UPDATE `sat_staff_task` SET `complete_date` = '".$com_date."' , comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$c_id])."' , `resource` = '$_REQUEST[resource]' , `hold_status` = '".$holdStat."'";
if($checked_values['complete_date']=='0000-00-00'){
$sql89 .=" , `user_id`='".$_SESSION['sat_login_id']."'";
}
$sql89 .=" WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['checked1']."'";
//echo "UPDATE `sat_staff_task` SET `complete_date` = '".$com_date."' , comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$c_id])."' , `resource` = '$_REQUEST[resource]' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['checked1']."'";exit;
$update_query = mysql_query($sql89);
}else{
}
}
if($_REQUEST['unchecked1']!=''){
$id = $_REQUEST['unchecked1'];
$exist1 = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['unchecked1']."'"));
if($exist1>0){
$update_query = mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00' , comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$id])."' , `resource` = '$_REQUEST[resource]' , `hold_status` = '".$holdStat."' , `user_id`='".$_SESSION['sat_login_id']."' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['unchecked1']."'");
}
if($exist1==0 && $_REQUEST['unchecked1']!=0){
mysql_query("insert into `sat_staff_task` set
staff_activity_id='".$_REQUEST['h_edit_id']."',
task_id='". $_REQUEST['unchecked1']."',
user_id='".$_SESSION['sat_login_id']."',
start_date='".$today_date."' ,
complete_date='0000-00-00' ,
staff_task_status='".$task_values['task_status']."' ,
resource='".$task_values['user_id']."' ,
comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$id])."'");
}
}
header("location:activity.php?msg=2");
}
//end of insert from side edit button //
if($_REQUEST['submit1']=="Save"){
$checked_id = explode(",",$_REQUEST["h_checked"]);
//print_r($checked_id);
$unchecked_id = explode(",",$_REQUEST["h_unchecked"]);
$hold_task = explode(",",$_REQUEST['h_hold']);
$unhold_task = explode(",",$_REQUEST["h_unhold"]);
$depertment = '';
//echo '<pre>';print_r($checked_id);exit;
foreach($checked_id as $checked_id_array){
$depertment = check_null_value('department','sat_task','task_id',$checked_id_array);
//exit;
//echo "SELECT `staff_task_id`,`resource` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$checked_id_array."'";
$checked_values = mysql_fetch_array(mysql_query("SELECT `staff_task_id`,`resource` , `complete_date` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$checked_id_array."'"));
//echo "hi";exit;
//$get_user_initial = mysql_fetch_array(mysql_query("SELECT `user_initial` FROM `sat_users` WHERE `user_id`='".$_SESSION['sat_login_id']."'"));
//if($checked_values['resource'] == $_SESSION['sat_login_id']){
$exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$checked_id_array."'"));
if($exist>0){
$exsist_com_date = mysql_fetch_array(mysql_query("SELECT `complete_date` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$checked_id_array."'"));
//echo "hiiiiiiii";exit;
if($exsist_com_date['complete_date']=='0000-00-00'){
if (in_array($checked_id_array, $hold_task)){
$hold_stat=1;
}else{
$hold_stat=0;
}
$sql3 = "UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' , comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$checked_id_array])."' , `hold_status` ='".$hold_stat."'";
if($checked_values['complete_date']=='0000-00-00'){
$sql3 .=" , `user_id`='".$_SESSION['sat_login_id']."'";
}
$sql3 .=" WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$checked_id_array."'";
//echo "UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' , comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$checked_id_array])."' , `user_id`='".$_SESSION['sat_login_id']."' , `hold_status` ='".$hold_stat."' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$checked_id_array."'";
$update_query = mysql_query($sql3);
/*===============ar-11 email===============*/
if($_REQUEST['activity_id']=='9'){ //for "Change - Home ADDRESS" activity
if($checked_id_array == '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['h_stuff_id']);
$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
$mail_to = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['h_stuff_id']);
$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($checked_id_array == '389' || $checked_id_array == '332' || $checked_id_array == '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['h_stuff_id']);
$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
$mail_to = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['h_stuff_id']);
$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($checked_id_array == '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['h_stuff_id']);
$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
$mail_to = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['h_stuff_id']);
$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($checked_id_array == '277' || $checked_id_array == '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['h_stuff_id']);
$ac_email = check_null_value('email','sat_users','user_id',$acmgr_id);
$mail_to = check_null_value('pemail','sat_staff','staff_id',$_REQUEST['h_stuff_id']);
$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===============*/
}
//header("location:activity.php?msg=2");
}else{
}
//}else{
//header("location:activity.php?msg=2");
//}
}
foreach($unchecked_id as $unchecked_id_array){
$task_values = mysql_fetch_array($sql_query=mysql_query("SELECT `task_id` , `task_status` , `user_id`, `task` FROM `sat_task` WHERE task_id='".$unchecked_id_array."'"));
$exist1 = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$unchecked_id_array."'"));
if($exist1>0){
if (in_array($unchecked_id_array, $hold_task)){
echo $hold_stat=1;
}else{
echo $hold_stat=0;
}
$update_query = mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00' , comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$unchecked_id_array])."' ,`user_id` = '".$_SESSION['sat_login_id']."', `hold_status` ='".$hold_stat."' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$unchecked_id_array."'");
}
if($exist1==0 && $unchecked_id_array!=0){
mysql_query("insert into `sat_staff_task` set
staff_activity_id='".$_REQUEST['h_edit_id']."',
task_id='". $unchecked_id_array."',
user_id='".$_SESSION['sat_login_id']."',
start_date='".$today_date."' ,
complete_date='0000-00-00' ,
staff_task_status='".$task_values['task_status']."' ,
resource='".$task_values['user_id']."' ,
comments = '".mysql_real_escape_string($_REQUEST['comments2_'.$unchecked_id_array])."'");
}
}
// echo sizeof($_REQUEST['task']);
// // exit;
// if(sizeof($_REQUEST['task'])>0){
//
// foreach($_REQUEST['task'] as $request_task){
//
// $data_date = change_dateformat($_REQUEST['change_date']);
// mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$request_task."'");
//
//
// }
// }
//
//
//if($_REQUEST['task']==''){
//
// $exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['h_id_task11']."'"));
// //echo $exist;exit;
// $update_query = "UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00'";
// if($_REQUEST['comments2']!=''){
// $update_query .= " , `comments` = '$_REQUEST[comments2]'";
// }
// $update_query .= " WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['h_id_task11']."'";
//
//
//
//
//
// mysql_query($update_query);
//
// if($exist==0){
// mysql_query("insert into `sat_staff_task` set
// staff_activity_id='".$_REQUEST['h_edit_id']."',
//
// task_id='".$_REQUEST['h_id_task11']."',
// user_id='".$_SESSION['sat_login_id']."',
// start_date='".$today_date."' ,
// complete_date='0000-00-00' ,
// staff_task_status=' ' ,
// comments = '".mysql_real_escape_string($_REQUEST["comments2"])."'");
// }
//
//header("location:activity.php?msg=2");
header("location:activity.php?msg=2");
}
?>
<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;
}
}
//]]>
<?php if($_REQUEST['act']=='edit'){ ?>
jQuery(document).ready(function() {
$('html, body').animate({ scrollTop: $('.newtxtedit').offset().top - 40 }, '100');
});
<?php } ?>
</script>
<?php
$msg=$_REQUEST['msg'];
if($msg == 1){
$msg = '<font color="#009933">Task added successfully</font>';
}
if($msg == 2){
$msg = '<font color="#009933">Activity updated successfully</font>';
}
if($msg == 3){
$msg = "Date field can't be empty to complite a task";
}
if($msg == 4){
$msg = "Task already exsists under this department, activity and user initial";
}
$no_data=mysql_num_rows(mysql_query("select * from sat_task"));
// create array for existing task id //
//echo "SELECT `task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."' AND `complete_date` = '0000-00-00'";
//$g = mysql_query("SELECT `task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."' AND `complete_date` = '0000-00-00'");
$g = mysql_query("SELECT `task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'");
while($get_task_id1 = mysql_fetch_array($g)){
$x[] = $get_task_id1['task_id'];
}
// create array for existing task id //
$query_res="select * from sat_task where main_activity_id='".$main_activity_id."' AND `task_status` = 'Active'";
if($_REQUEST['search_market']!='')
{
$query_res.=" and category_id='".$_REQUEST['search_market']."'";
}
$query_res.=" order by main_activity_id,task";
$sel_product=mysql_query($query_res);
$num_row = mysql_num_rows($sel_product);
?>
<script>
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>
<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">
<tr>
<td width="86%" height="128" align="center"><table width="660" 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">Edit Staff Activity <?php $task_name=mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '".$_REQUEST['main_activity_id']."'")); echo $task_name['main_activity']; ?></td>
</tr>
<tr class="smalltext">
<td height="28" colspan="5" align="left" valign="middle" class="enquiery">
<form name="frmproduct" id="myformID" action="" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="smalltext">
<td width="120" align="left" valign="middle" class="head_text2 alignleft">Staff Name</td><td width="3">:</td>
<td width="187" height="32" align="left" valign="middle" class="head_text2 alignleft"><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` = '".$staff."'")); echo $staff_name['firstname']." ".$staff_name['lastname']; ?></td>
<td width="19" align="left" valign="middle" class="enquiery"> </td>
<td width="121" align="left" valign="middle" class="head_text2 alignleft" >Activity</td><td width="5">
:</td>
<td width="203" 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` = '".$main_activity_id."'")); echo $task_name['main_activity']; ?></td>
</tr>
<tr>
<td align="left" valign="middle" class="head_text2 alignleft" width="120">Client Name</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2 alignleft" width="187" ><input class="textfield require_field" type="text" value="<?php echo $client_name; ?>" name="c_name" /><?php //echo $_REQUEST['client_name']; ?></td>
<td align="left" valign="middle" class="enquiery"></td>
<td align="left" valign="middle" class="head_text2 alignleft" width="121" >Effective Date</td><td> :</td>
<td class="head_text2 alignleft" width="203"><input type="hidden" re value="<?php echo $effective_date; ?>" name="e_date" /><?php echo change_dateformat_reverse($effective_date) ;?></td>
</tr>
<tr>
<td align="left" valign="middle" class="head_text2 alignleft" width="120">End Client Name</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2 alignleft" width="187"><input class="textfield require_field" type="text" value="<?php echo $end_client_name; ?>" name="ec_name" /><?php //echo $_REQUEST['end_client_name']; ?></td>
<td align="left" valign="middle" class="enquiery"></td>
<td align="left" valign="middle" class="head_text2 alignleft" width="121" >Work Location</td><td>:</td>
<td class="head_text2 alignleft" width="203" style="margin-right:8px;"><input class="textfield require_field" type="text" value="<?php echo $work_location; ?>" name="w_location" /><?php //echo $work_location; ?></td>
</tr>
<tr>
<td class="head_text2 alignleft" width="120">Comments</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2 alignleft" width="187"><textarea name="com" class="textfield require_field" style="width:180px; height:66px" /><?php echo $comments ; ?></textarea></td>
</tr>
<tr align="center">
<td height="31" colspan="7" align="center" class="head_text2"> <input type="submit" class="newadd" name="save" value="Update">
</td>
</tr>
<tr class="smalltext">
<td height="10" colspan="5" align="left" valign="middle" class="enquiery"></td>
</tr>
</table>
</form>
</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">
<form action="editActivity.php" method="post" id="formID" name="formID">
<input type="hidden" value="<?php echo $main_activity_id; ?>" name="activity_id" />
<table width="100%" height="99" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" style="border-collapse:collapse;" class="editTable">
<tr class="smalltexthead" bgcolor="#C4E1FF">
<!--<td width="5%" height="22" align="center" class="head_text">No</td>-->
<td width="10%" align="center" class="head_text">Department</td>
<td width="10%" align="center" class="head_text">Task Id</td>
<td width="18%" align="left" class="head_text" style="text-align:left; padding-left:16px;"> <span 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;" />
</span>Task</td>
<td width="9%" align="center" class="head_text">Activity</td>
<td width="7%" align="center" class="head_text">Resource</td>
<td width="8%" align="center" class="head_text">User Initial</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">Completion Date</td>
<td width="3%" align="center" class="head_text">Hold</td>
<?php if($user_level==1){ ?>
<td width="8%" align="center" class="head_text">Action</td>
<?php } ?>
</tr>
<?php /*?> <td width="22%" align="center" class="head_text">E / D</td><?php */?>
<?php
//////////////////////start pagination/////////////////////////
$page=$_REQUEST['page'];
if($_REQUEST['page']=="")
{
$page = 1;
}
//echo $page;
$max_results = 5000;
$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";
$query_res;
$query_products=mysql_query($query_res);
////////////////////////////////End pagination////////////////////////////////////
$separator = '';
$separator1 = "";
$checked = '';
if(mysql_num_rows($query_products)>0)
{
$inc=1;
while($array_products=mysql_fetch_array($query_products))
{
if($inc%2==0)
{
?>
<tr class="<?php if($_REQUEST['act']=='edit' && $_REQUEST['row']==$inc){ ?>newtxtedit<?php }else{ ?> newtxt<?php } ?>">
<?
}else{
?>
<tr class="<?php if($_REQUEST['act']=='edit' && $_REQUEST['row']==$inc){ ?>newtxtedit<?php } ?>">
<?php
}
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']."'"));
$query_checked_hold = mysql_query("SELECT `hold_status` FROM `sat_staff_task` WHERE `task_id` = '".$array_products['task_id']."' AND `staff_activity_id` = '".$_REQUEST['edit_id']."'");
$hold_status = mysql_fetch_array($query_checked_hold);
?>
<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" class="head_text2" style="text-align:left; padding-left:16px">
<?php $query_checked_date = mysql_query("SELECT `complete_date` FROM `sat_staff_task` WHERE `task_id` = '".$array_products['task_id']."' AND `staff_activity_id` = '".$_REQUEST['edit_id']."'");
$query_checked_date1 = mysql_fetch_assoc($query_checked_date);
$query_checked_date1['complete_date'];
$get_task_created_by = mysql_fetch_array(mysql_query("select `user_id` from sat_task where main_activity_id='".$main_activity_id."' AND `task_status` = 'Active' AND `task_id` = '".$array_products['task_id']."'"));
if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){ ?>
<input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>" align="left" id="chkFile<?php echo $a ; ?>" <?php if($hold_status['hold_status']=='1'){?> disabled="disabled" <?php } if($query_checked_date1['complete_date']!='0000-00-00'){?> checked <?php } ?>style="margin-right:8px;" class="checkTask1" ><?php echo $array_products['task']; ?>
<?php
}else{
?>
<input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>" align="left" id="chkFile<?php echo $a ; ?>" <?php if($hold_status['hold_status']=='1'){?> disabled="disabled" <?php } if($query_checked_date1['complete_date']!='0000-00-00'){?> checked <?php } ?>style="margin-right:8px;" class="checkTask check_box" ><?php echo $array_products['task']; ?>
<?php } ?>
</td>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('main_activity','sat_main_activity','main_activity_id',$array_products['main_activity_id']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php //echo $initial_user['user_initial']; ?>
<?php
//echo "SELECT `resource` FROM `sat_staff_task` WHERE `task_id`='".$array_products['task_id']."' AND `staff_activity_id` = $_REQUEST[edit_id]";
$initial_user = mysql_fetch_array(mysql_query("SELECT `resource` FROM `sat_staff_task` WHERE `task_id`='".$array_products['task_id']."' AND `staff_activity_id` = $_REQUEST[edit_id]"));
// if does not exist in table(get value from main task table)//
$initial_user_blank = mysql_fetch_array(mysql_query("SELECT `user_id` FROM `sat_task` WHERE `task_id`='".$array_products['task_id']."'"));
$get_resource2 = mysql_fetch_array(mysql_query("SELECT `user_id` , `user_initial` FROM `sat_users` where `user_id`='".$initial_user_blank['user_id']."'"));
// if does not exist in table(get value from main task table)//
//elseif($initial_user_blank['user_id']==$get_resource2['user_id']){selected="selected" //}
if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
//echo "SELECT `user_id` , `user_initial` FROM `sat_users`";
//echo "3".$initial_user['resource'];
$get_resource = mysql_query("SELECT `user_id` , `user_initial` FROM `sat_users`");
?>
<select name="resource">
<?php
while($get_resource1 = mysql_fetch_array($get_resource)){
?>
<option value="<?php echo $get_resource1['user_id']; ?>" <?php if($initial_user['resource']!=''){if($get_resource1['user_id']==$initial_user['resource']){?> selected="selected" <?php } }else{ if($get_resource2['user_id']==$get_resource1['user_id']){ ?> selected="selected" <?php } } ?>><?php echo $get_resource1['user_initial']; ?></option>
<?php
}
?>
</select>
<?php
}else{
$name = mysql_fetch_array(mysql_query("SELECT `user_initial` FROM `sat_users` WHERE `user_id` = '".$initial_user['resource']."'"));
if($name['user_initial']==''){
echo $get_resource2['user_initial'];
}else{
echo $name['user_initial'];
}
}
?>
</td>
<td align="center" valign="middle" class="head_text2">
<?php
$getStaffInitial = mysql_fetch_array(mysql_query("SELECT `user_id` FROM `sat_staff_task` WHERE staff_activity_id = '".$_REQUEST['edit_id']."' AND task_id = '".$array_products['task_id']."'"));
//$get_staff_initial['user_id'] ;
//echo $query_checked_date1['complete_date'];
//echo $get_task_id['user_id'];
if($query_checked_date1['complete_date']!='0000-00-00'){
$StaffInitial = mysql_fetch_array(mysql_query("SELECT `user_initial` FROM `sat_users` WHERE `user_id`='".$getStaffInitial['user_id']."'"));
echo $StaffInitial['user_initial'];
}else{
//echo $edit_data['user_id'];
$initial_user1 = mysql_fetch_array(mysql_query("SELECT `user_initial` FROM `sat_users` WHERE `user_id`='".$edit_data['user_id']."'"));
echo $initial_user1['user_initial'];
}
?>
</td>
<?php
$comments_task = mysql_fetch_array(mysql_query("SELECT `comments` FROM `sat_staff_task` WHERE staff_activity_id = $_REQUEST[edit_id] AND task_id = '".$array_products['task_id']."'"));
?>
<?php /*?><td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_status']?></td><?php */?>
<td align="center" valign="middle" class="head_text2">
<?php if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
?>
<input type="text" name="comments2_<?php echo $array_products['task_id'] ;?>" id="comments2" value="<?php echo $comments_task['comments']; ?>">
<?php
}else{
?>
<input type="text" name="comments2_<?php echo $array_products['task_id'] ;?>" id="comments2" value="<?php echo $comments_task['comments']; ?>">
<?php
}
?>
</td>
<td align="center" valign="middle" class="head_text2">
<?php
$staff_task_date = mysql_fetch_array(mysql_query("SELECT `complete_date` FROM `sat_staff_task` WHERE staff_activity_id = '".$_REQUEST['edit_id']."' AND `task_id` = '".$array_products['task_id']."'"));
$staff_activity_date = mysql_fetch_array(mysql_query("SELECT `complite_date` FROM `sat_staff_activity` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
?>
<script>
$(function() {
$( "#change_date" ).datepicker({
dateFormat:"<?php echo $dateFormat; ?>"
});
});
</script>
<?php
if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
?>
<input type="text" name="change_date_<?php echo $array_products['task_id']; ?>" id="change_date" value="<?php if($staff_task_date['complete_date']!='0000-00-00'){ echo change_dateformat_reverse($staff_task_date['complete_date']); } ?>" class="" readonly="readonly">
<?php
}else{
//echo 'date'.$staff_task_date['complete_date'];
if($staff_task_date['complete_date']=="0000-00-00"){
//echo change_dateformat_reverse($staff_task_date['complete_date']);
//echo 'date'.change_dateformat_reverse($complite_date_post);
}else{
echo change_dateformat_reverse($staff_task_date['complete_date']);
}
if($query_checked_date1['complete_date']==''){
echo change_dateformat_reverse($complite_date_post);
}
}
?>
</td>
<td align="center" valign="middle" class="head_text2">
<?php
if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){ ?>
<input type="checkbox" name="hold1[]" value="<?php echo $array_products['task_id']; ?>" class="hold1" <?php if($query_checked_date1['complete_date']!='0000-00-00'){?> disabled="disabled" <?php } if($hold_status['hold_status']=='1'){?> checked="checked" <?php } ?> />
<?php }else{?>
<input type="checkbox" name="hold[]" value="<?php echo $array_products['task_id']; ?>" class="hold" <?php if($query_checked_date1['complete_date']!='0000-00-00'){?> disabled="disabled" <?php } if($hold_status['hold_status']=='1'){?> checked="checked" <?php } ?> />
<?php } ?>
</td>
<input type="hidden" name="task1[]" value="<?php echo $array_products['task_id'];?>" />
<?php
if($query_checked_date1['complete_date']!='0000-00-00'){
$checked = $checked.$separator.$array_products['task_id'];
$separator = ",";
//$checked = NULL;
//exit;
}
if($query_checked_date1['complete_date']=='0000-00-00'){
$unchecked = $unchecked.$separator1.$array_products['task_id'];
$separator1 = ",";
// $unchecked = NULL;
}
if($hold_status['hold_status']=='1'){
$checked_hold = $checked_hold.$separator2.$array_products['task_id'];
$separator2=',';
}
if($hold_status['hold_status']!='1'){
$unchecked_hold = $unchecked_hold.$separator3.$array_products['task_id'];
$separator3=',';
}
?>
<?php
if(isset($_REQUEST['act']) && $_REQUEST['row']==$inc){
?>
<!-- <a href="editActivity.php?update=update&id=<?php echo $array_products['task_id']; ?>&edit_id=<?php echo $_REQUEST['edit_id'];?>">-->
<?php if($query_checked_date1['complete_date']!='0000-00-00'){
$checked1 = $array_products['task_id'];
}
if($query_checked_date1['complete_date']=='0000-00-00'){
$unchecked1 = $array_products['task_id'];
}
if($hold_status['hold_status']=='1'){
$checked_hold1 = $array_products['task_id'];
}
if($hold_status['hold_status']!='1'){
$unchecked_hold1 = $array_products['task_id'];
}
}
?>
<?php if($user_level==1){ ?>
<td align="center" valign="middle" class="head_text2">
<?php if($_REQUEST['row']!=$inc){ ?>
<a href="editActivity.php?act=edit&id=<?php echo $array_products['task_id']; ?>&edit_id=<?php echo $_REQUEST['edit_id'];?>&row=<?php echo $inc ;?>">Edit</a>
<?php } ?>
<?php
if(isset($_REQUEST['act']) && $_REQUEST['row']==$inc){
?>
<input type="submit" name="save" value="SAVE" width="40px" class="newadd" style="font-size:12px !important; font-family:Arial, Helvetica, sans-serif !important; margin-top:0; margin-bottom:5px !important; padding:3px 18px;"/>
<a href="editActivity.php?edit_id=<?php echo $_REQUEST['edit_id'];?>" class="newadd" style="text-decoration:none;font-size:12px !important; color:#fff !important; padding:3px 18px; margin-top:-12px!important; margin-bottom:5px; float:left; display:block !important; width:34px !important; height:18px; line-height:16px; font-weight:bold !important; font-family:Arial, Helvetica, sans-serif !important; text-align:center !important;">Cancel</a>
<?php } ?>
</td>
<?php
}
?>
<?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 class="head_text2" height="10px">
<td colspan="10" align="center" class="head_text2" style="padding-bottom:6px">
<?php
//echo "Checked ".$checked;
//echo "<br>Unchecked ".$unchecked;
?>
<input type="hidden" value="<?php echo $checked_hold ; ?>" name="h_hold" class="ho_checked1" id="h_hold"/>
<input type="hidden" value="<?php echo $unchecked_hold ; ?>" name="h_unhold" class="uho_checked1" id="h_unhold"/>
<input type="hidden" value="<?php echo $checked_hold1 ; ?>" name="h_hold1" class="ho_checked11" id="h_hold1"/>
<input type="hidden" value="<?php echo $unchecked_hold1 ; ?>" name="h_unhold1" class="uho_checked11" id="h_unhold1"/>
<input type="hidden" value="<?PHP echo $_REQUEST['edit_id']; ?>" name="h_edit_id" />
<input type="hidden" value="<?php echo $staff; ?>" name="h_stuff_id" />
<input type="hidden" value="<?php echo $checked1;?>" name="checked1" class="c_checked1" id="checked1" />
<input type="hidden" value="<?php echo $unchecked1;?>" name="unchecked1" class="c_unchecked1" id="unchecked1" />
<input type="hidden" value="<?php echo $checked ; ?>" name="h_checked" class="c_checked" id="h_checked" />
<input type="hidden" value="<?php echo $unchecked ; ?>" name="h_unchecked" class="c_unchecked" id="h_unchecked" />
<?php if(!isset($_REQUEST['act'])){ ?>
<input type="submit" class="newadd marginBottom" name="submit1" value="Save" onclick="return confirm('Are you sure you want to update the record(Please check whether you have selected the task or not)?');")">
<?php }
?>
<a href="activity.php">
<input type="button" class="newadd" name="submit" value="Cancel">
</a>
</td>
</tr>
<?php
}
else{
?>
<tr class="smalltexthead">
<td height="20" colspan="10" align="center" style="color:#666; font-weight:bold; font-family:Verdana, Geneva, sans-serif; font-size:13px;">Sorry, no result found.</td>
</tr>
<?php
}
?>
</table>
</form>
</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>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180