Preview: editActivity_bk.php
Size: 36.72 KB
/home/jambtst2015/public_html/giraffeng.com/admin/editActivity_bk.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php //require_once('mail_function/class.phpmailer.php'); ?>
<?php include ("includes/libmail.php"); ?>
<?php
//------- save Values ------//
$edit_data = mysql_fetch_array(mysql_query("SELECT * FROM `sat_staff_activity` WHERE `staff_activity_id` = '$_REQUEST[edit_id]'"));
$staff = $edit_data['staff_id'];
if($staff==''){
//header("location:activity.php");
}
$client_name = $edit_data['client_name'];
$main_activity_id = $edit_data['main_activity_id'];
$end_client_name = $edit_data['end_client_name'];
$effective_date = $edit_data['effective_date'];
$work_location = $edit_data['work_location'];
$comments = $edit_data['comments'];
$complite_date_post = $edit_data['complite_date'];
$today_date = date("Y-m-d");
// get details from task table //
$get_task_id = mysql_fetch_array(mysql_query("SELECT `task_id` , `user_id` , `comments` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
$user_initial = mysql_fetch_array(mysql_query("select `user_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
// end of getting details //
//end of save value//
/////////////// sat_staff_activity ///////////////////////////////////////////////
if($_REQUEST['save']=="Update")
{
mysql_query("update `sat_staff_activity` set
client_name='$_REQUEST[c_name]',
end_client_name='$_REQUEST[ec_name]',
work_location='$_REQUEST[w_location]' ,
comments='$_REQUEST[com]'
WHERE `staff_activity_id` = '$_REQUEST[edit_id]'");
}
/////////////End Update //////////////////////////////////////////////
//insert from side edit button //
if($_REQUEST["save"]=="SAVE"){
echo "<pre>";
print_r($_REQUEST['task']);
print_r($_REQUEST['task1']);
print_r($_REQUEST['h_id_task'][14]);
//exit;
if(sizeof($_REQUEST['task'])>0){
if($_POST['resource']!=''){
mysql_query("UPDATE `sat_task` SET `user_id` = '".$_REQUEST['resource']."' WHERE `task_id` = '".$_REQUEST['h_id_task']."'");
}
if($_REQUEST['change_date']!=''){
$data_date = change_dateformat($_REQUEST['change_date']);
mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' , `comments` = '$_REQUEST[comments2]' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['h_id_task']."'");
}
}
foreach($_REQUEST['task1'] as $tasks){
$exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$tasks."'"));
//echo $exist;exit;
$update_query = "UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00'";
if($_REQUEST['comments2']!=''){
$update_query .= " , `comments` = '$_REQUEST[comments2]'";
}
$update_query .= " WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$tasks."'";
mysql_query($update_query);
if($exist==0){
mysql_query("insert into `sat_staff_task` set
staff_activity_id='".$_REQUEST['h_edit_id']."',
task_id='".$tasks."',
user_id='".$_SESSION['sat_login_id']."',
start_date='".$today_date."' ,
complete_date='0000-00-00' ,
staff_task_status=' ' ,
comments = '".mysql_real_escape_string($_REQUEST["comments2"])."'");
}
}
header("location:editActivity.php?edit_id=$_REQUEST[h_edit_id]");
}
//end of insert from side edit button //
if($_REQUEST['submit1']=="Save"){
if(sizeof($_REQUEST['task'])>0){
foreach($_REQUEST['task'] as $request_task){
$data_date = change_dateformat($_REQUEST['change_date']);
mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '".$today_date."' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$request_task."'");
}
}
if(!isset($_REQUEST['task'])){
$exist = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['task_id']."'"));
//echo $exist;exit;
mysql_query("UPDATE `sat_staff_task` SET `complete_date` = '0000-00-00' WHERE `staff_activity_id` = '".$_REQUEST['h_edit_id']."' AND `task_id` = '".$_REQUEST['task_id']."'");
if($exist==0){
mysql_query("insert into `sat_staff_task` set
staff_activity_id='".$_REQUEST['h_edit_id']."',
task_id='".$_REQUEST['task_id']."',
user_id='".$_SESSION['sat_login_id']."',
start_date='".$today_date."' ,
complete_date='0000-00-00'");
}
}
header("location:editActivity.php?edit_id=$_REQUEST[h_edit_id]");
}
?>
<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 = "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>
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>
<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">
<form name="frmproduct" id="formID" action="" method="post">
<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">Edit Employee Activity <?php $task_name=mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '".$_REQUEST['main_activity_id']."'")); echo $task_name['main_activity']; ?></td>
</tr>
<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="70" align="left" valign="middle" class="head_text2">Staff Name</td><td width="5">:</td>
<td width="144" height="32" align="left" valign="middle" class="head_text2"><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="5" align="left" valign="middle" class="enquiery"> </td>
<td width="181" align="left" valign="middle" class="head_text2" style="text-align:right">Activity</td><td width="4">
:</td>
<td width="147" class="head_text2"><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">Client Name</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2" ><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" style="text-align:right">Effective Date</td><td> :</td>
<td class="head_text2"><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">End Client Name</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2"><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" style="text-align:right">Work Location</td><td>:</td>
<td class="head_text2"><input class="textfield require_field" type="text" value="<?php echo $work_location; ?>" name="w_location" /><?php //echo $work_location; ?></td>
</tr>
<tr align="center">
<td> </td>
<td> </td>
<td align="right" style="text-align:right" class="head_text2">Comments</td><td>:</td>
<td height="31" align="left" valign="middle" class="head_text2"><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></td>
</tr>
</table></td>
</tr>
</form>
</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="23%" align="left" class="head_text" style="text-align:left; padding-left:16px"> <input id="chkAllFiles" <?php if($_REQUEST['act']!='edit'){ ?> disabled="disabled" <?php } ?> type="checkbox" title="All Files" onchange="selectAllFiles(this.checked,<?php echo $num_row; ?>);" />Task</td>
<td width="10%" align="center" class="head_text">Activity</td>
<td width="14%" align="center" class="head_text">Resource</td>
<td width="14%" align="center" class="head_text">User Initial</td>
<!--<td width="14%" align="center" class="head_text">Status</td>-->
<td width="14%" align="center" class="head_text">Comments</td>
<td width="9%" align="center" class="head_text">Completion Date</td>
<td width="5%" align="center" class="head_text">Hold</td>
<td width="5%" align="center" class="head_text">Action</td></tr>
<form action="editActivity.php" method="post">
<?php /*?> <td width="22%" align="center" class="head_text">E / D</td><?php */?>
<?php
//////////////////////start pagination/////////////////////////
$page=$_REQUEST['page'];
if($_REQUEST['page']=="")
{
$page = 1;
}
//echo $page;
$max_results = 10;
$prev = ($page - 1);
$next = ($page + 1);
$from = (($page * $max_results) - $max_results);
$total_results = mysql_num_rows($sel_product);
$total_pages = ceil($total_results / $max_results);
$pagination = '';
if($page > 1)
{
$pagination .= "<a href=\"manage_task.php?page=$prev&search_market=".$_REQUEST['search_market']."\" class=\"more_link_pagination_prev\">Previous</a>";
$pagination.=" ";
}
for($i = 1; $i <=$total_pages; $i++)
{
if(($page) == $i)
{
$pagination .= $i;
$pagination.=' ';
}
else
{
$pagination .= "<a href=\"manage_task.php?page=$i&search_market=".$_REQUEST['search_market']."\" class=\"more_link_pagination\">$i</a>";
$pagination.=' ';
}
}
if($page < $total_pages)
{
$pagination .= "<a href=\"manage_task.php?page=$next&search_market=".$_REQUEST['search_market']."\" class=\"more_link_pagination_prev\">Next</a>";
$pagination.=" ";
}
$query_res.=" limit $from,$max_results";
//echo $query_res;
$query_products=mysql_query($query_res);
////////////////////////////////End pagination////////////////////////////////////
if(mysql_num_rows($query_products)>0)
{
$inc=1;
while($array_products=mysql_fetch_array($query_products))
{
if($inc%2==0)
{
?>
<?php
if(isset($_REQUEST['act']) && $_REQUEST['row']==$inc){
?>
<tr bgcolor="#72ACF3" class="newtxt" style="background-color:#CCC; color:#CCC">
<?php
}else{
?>
<tr bgcolor="#eeeeee" class="newtxt">
<?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']."'")); ?>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['department']; ?></td>
<td align="left" class="head_text2" style="text-align:left; padding-left:16px">
<?php $query_checked_date = mysql_query("SELECT `complete_date` FROM `sat_staff_task` WHERE `task_id` = '".$array_products['task_id']."' AND `staff_activity_id` = '".$_REQUEST['edit_id']."'");
$query_checked_date1 = mysql_fetch_assoc($query_checked_date);
$query_checked_date1['complete_date'];
$get_task_created_by = mysql_fetch_array(mysql_query("select `user_id` from sat_task where main_activity_id='".$main_activity_id."' AND `task_status` = 'Active' AND `task_id` = '".$array_products['task_id']."'"));
// echo "ff".$get_task_id['user_id'];
//!in_array($array_products['task_id'], $x)
//$_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id'] &&
if($get_task_created_by['user_id'] == $_SESSION['sat_login_id']){ ?>
<input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>" align="left" id="chkFile<?php echo $a ; ?>" <?php if($query_checked_date1['complete_date']!='0000-00-00'){?> checked <?php } ?>><?php echo $array_products['task']; ?>
<?php
}else{
//echo "SELECT `complete_date` FROM `sat_staff_task` WHERE `task_id` = '".$array_products['task_id']."' AND `staff_activity_id` = '1'";
?>
<input type="checkbox" name="task[]" value="<?php echo $array_products['task_id'] ;?>" align="left" id="chkFile<?php echo $a ; ?>" disabled="disabled" <?php if($query_checked_date1['complete_date']!='0000-00-00'){?> checked <?php } ?>><?php echo $array_products['task']; ?>
<?php } ?>
</td>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('main_activity','sat_main_activity','main_activity_id',$array_products['main_activity_id']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php //echo $initial_user['user_initial']; ?>
<?php
$initial_user = mysql_fetch_array(mysql_query("SELECT `user_id` ,`user_initial` FROM `sat_users` WHERE `user_id`='".$array_products['user_id']."'"));
if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
$get_resource = mysql_query("SELECT `user_id` , `user_initial` FROM `sat_users`");
?>
<select name="resource">
<option value="">--Select--</option>
<?php
while($get_resource1 = mysql_fetch_array($get_resource)){
?>
<option value="<?php echo $get_resource1['user_id']; ?>" <?php if($get_resource1['user_id'] == $initial_user['user_id']){?> selected="selected" <?php } ?>><?php echo $get_resource1['user_initial']; ?></option>
<?php
}
?>
</select>
<?php
}else{
echo $initial_user['user_initial'];
}
?>
</td>
<td align="center" valign="middle" class="head_text2">
<?php
//$user_initial
$initial_user1 = mysql_fetch_array(mysql_query("SELECT `user_initial` FROM `sat_users` WHERE `user_id`='".$user_initial['user_id']."'"));
echo $initial_user1['user_initial'];
?>
</td>
<?php
$comments_task = mysql_fetch_array(mysql_query("SELECT `comments` FROM `sat_staff_task` WHERE staff_activity_id = $_REQUEST[edit_id] AND task_id = '".$array_products['task_id']."'"));
?>
<?php /*?><td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_status']?></td><?php */?>
<td align="center" valign="middle" class="head_text2">
<?php if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
?>
<input type="text" name="comments2" id="comments2" value="<?php echo $comments_task['comments']; ?>">
<?php
}else{
echo $comments_task['comments'];
}
?>
</td>
<td align="center" valign="middle" class="head_text2">
<?php
$staff_task_date = mysql_fetch_array(mysql_query("SELECT `complete_date` FROM `sat_staff_task` WHERE staff_activity_id = '".$_REQUEST['edit_id']."' AND `task_id` = '".$array_products['task_id']."'"));
$staff_activity_date = mysql_fetch_array(mysql_query("SELECT `complite_date` FROM `sat_staff_activity` WHERE `staff_activity_id` = '".$_REQUEST['edit_id']."'"));
?>
<script>
$(function() {
$( "#change_date" ).datepicker({
dateFormat:"<?php echo $dateFormat; ?>"
});
});
</script>
<?php
if(isset($_REQUEST['act']) && $_REQUEST['id']==$array_products['task_id']){
?>
<input type="text" name="change_date" id="change_date" value="<?php if($staff_task_date['complete_date']!='0000-00-00'){ echo change_dateformat_reverse($staff_task_date['complete_date']); } ?>">
<?php
}else{
//echo 'date'.$staff_task_date['complete_date'];
if($staff_task_date['complete_date']=="0000-00-00"){
//echo change_dateformat_reverse($staff_task_date['complete_date']);
//echo 'date'.change_dateformat_reverse($complite_date_post);
}else{
echo change_dateformat_reverse($staff_task_date['complete_date']);
}
if($query_checked_date1['complete_date']==''){
echo change_dateformat_reverse($complite_date_post);
}
}
?>
</td>
<td align="center" valign="middle" class="head_text2">
<input type="checkbox" />
</td>
<input type="hidden" name="task1[]" value="<?php echo $array_products['task_id'];?>" />
<td align="center" valign="middle" class="head_text2">
<input type="hidden" value="<?PHP echo $array_products['task_id']; ?>" name="h_id_task[<?php echo $array_products['task_id'];?>]" />
<input type="hidden" value="<?PHP echo $_REQUEST['edit_id']; ?>" name="h_edit_id" />
<?php
if(isset($_REQUEST['act']) && $_REQUEST['row']==$inc){
?>
<!-- <a href="editActivity.php?update=update&id=<?php echo $array_products['task_id']; ?>&edit_id=<?php echo $_REQUEST['edit_id'];?>">-->
<input type="submit" name="save" value="SAVE" width="40px" class="newadd" style="font-size:10px; margin-top:2px; padding:3px 18px;"/>
<a href="editActivity.php?edit_id=<?php echo $_REQUEST['edit_id'];?>" class="newadd" style="text-decoration:none;font-size:10px; margin-top:2px; padding:2px 11px; margin-bottom:5px">Cancel</a>
<?php
}else{
?>
<a href="editActivity.php?act=edit&id=<?php echo $array_products['task_id']; ?>&edit_id=<?php echo $_REQUEST['edit_id'];?>&row=<?php echo $inc ;?>">Edit</a>
<?php
}
?>
</td>
<?php /*?><td align="center" class="head_text2" valign="middle"><a href="manage_task.php?action=edit&id=<?php echo $array_products['task_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>"><img src="images/1304761512_pen.png" alt="Edit" title="Edit" border="0" /></a> <a href="manage_task.php?delete=del&delete_id=<?php echo $array_products['task_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure you want to delete this task?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a> </td><?php */?>
</tr>
<?php
$inc++;
}
?>
<tr>
<td colspan="10" align="center">
<input type="submit" class="newadd" name="submit1" value="Save">
<a href="activity.php">
<input type="button" class="newadd" name="submit" value="Cancel">
</a>
</td>
</tr>
<?php
}
else{
?>
<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
}
?>
</form>
</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>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180