Preview: activity.php
Size: 38.77 KB
/home/jambtst2015/public_html/giraffeng.com/admin/activity.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php
///////////////Add Events///////////////////////////////////////////////
//if($_REQUEST['add']=="ADD" && count($_POST)>0 && $_REQUEST['id']=='' && $_REQUEST['action']!="edit")
//{
//$sql_query=mysql_query("SELECT * FROM `sat_task` WHERE department='".mysql_real_escape_string($_REQUEST['department'])."' AND task='".mysql_real_escape_string($_REQUEST['task'])."' AND main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."' AND user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."'");
//$sql_num=mysql_num_rows($sql_query);
//if($sql_num>0){
//$msg = 4;
//header("location:manage_task.php?msg=$msg");
//}else{
//mysql_query("insert into `sat_staff_activity` set staff_id='".mysql_real_escape_string($_REQUEST['staff'])."', client_name='".mysql_real_escape_string($_REQUEST['client_name'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', end_client_name='".mysql_real_escape_string($_REQUEST['end_client_name'])."', effective_date='".change_dateformat(mysql_real_escape_string($_REQUEST['effective_date']))."', work_location='".mysql_real_escape_string($_REQUEST['work_location'])."' , comments='".mysql_real_escape_string($_REQUEST['comments'])."'");
//$msg = 1;
//}
//}
/////////////End Add//////////////////////////////////////////////
///////////////////////////Edit Events////////////////////////////
if($_REQUEST['edit']=="EDIT" && count($_POST)>0 && $_REQUEST['id']!='' && $_REQUEST['action']=="edit")
{
//echo "update sat_task set department='".mysql_real_escape_string($_REQUEST['department'])."', task='".mysql_real_escape_string($_REQUEST['task'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."', task_status='".mysql_real_escape_string($_REQUEST['status'])."' where task_id=".$_REQUEST['id']."";
//exit;
mysql_query("update sat_task set department='".mysql_real_escape_string($_REQUEST['department'])."', task='".mysql_real_escape_string($_REQUEST['task'])."', main_activity_id='".mysql_real_escape_string($_REQUEST['main_activity_id'])."', user_id='".mysql_real_escape_string($_REQUEST['user_initial'])."', task_status='".mysql_real_escape_string($_REQUEST['status'])."' where task_id=".$_REQUEST['id']."");
$msg = 2;
header("location:manage_task.php?msg=$msg&search_market=".$_REQUEST['search_market']."&page=".$_REQUEST['page']."");
}
///////////////////////////End edit events////////////////////////
///////////////////////////For Edit////////////////////////////////////////////////
$array_product_details="";
if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit'])
{
$array_product_details=mysql_fetch_array(mysql_query("select * from sat_task where task_id=".$_REQUEST['id'].""));
//$_REQUEST['productname']=$array_product_details['exhibit'];
//$_REQUEST['market']=$array_product_details['category_id'];
}
//////////////////////End for edit///////////////////////////////////////////
///////////////////For Delete//////////////////////////////////////////////
if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')
{
$_REQUEST['page'];
//exit("yes");
mysql_query("delete from `sat_staff_activity` where staff_activity_id=".$_REQUEST['delete_id']."");
mysql_query("delete from `sat_staff_task` where staff_activity_id=".$_REQUEST['delete_id']."");
$msg = 3;
header("location:activity.php?msg=3&search_market=".$_REQUEST['search_market']."&page=".$_REQUEST['page']."");
}
///////////////////////End for delete//////////////////////////////////
if(!$_REQUEST['page'])
{
$_SESSION['srchstr']="";
$_SESSION['srchkey']="";
}
?>
<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();
}
/*
$(function() {
$( "#credit_1" ).datepicker({
dateFormat:"<?php echo $dateFormat; ?>"
});
//$( "#post_date" ).datepicker( "dd-mm-yy", "dateFormat" );
});
*/
$('body').on('click', 'input.datepicker', function(event) {
$(this).datepicker({
showOn: 'focus',
//yearRange: '1900:+0',
//changeMonth: true,
//changeYear: true,
dateFormat:"<?php echo $dateFormat; ?>"
}).focus();
});
/* Edit Date */
$(document).ready(function(){
$(".editDateef").on("click", function() {
// statement
var answerid = $(this).attr('id');
var res = answerid.split("_");
var incb = res['1'];
var idb = res['2'];
$.ajax({
url : 'editdate.php',
type : 'POST',
data : 'inc=' + incb +'&id=' + idb+'&show=1',
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(1);
},
success : function( data, textStatus, jqXHR){
//alert(data);
var total = data.split("||");
var creditVal = total[0];
var inc = total[1];
$('#credit-container'+inc).html('<input type="text" class="textfield datepicker" name="credit_'+inc+'" id="credit_'+inc+'" value="'+creditVal+'" onkeypress="return goodchars(event,\'1234567890.\');" />');
$('#credit_'+inc).focus();
$('#editImg'+inc).hide();
$('#saveImg'+inc).show("slow");
$('#refImg'+inc).show("slow");
},
error : function( jqXHR, textStatus, errorThrown){
}
});
});
});
/*function editCredite(inc,user_id){
$.ajax({
url : 'editdate.php',
type : 'POST',
data : 'inc=' + inc +'&id=' + user_id,
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(1);
},
success : function( data, textStatus, jqXHR){
//alert(data);
var total = data.split("||");
var creditVal = total[0];
var inc = total[1];
$('#credit-container'+inc).html('<input type="text" class="textfield date" name="credit_'+inc+'" id="credit_'+inc+'" value="'+creditVal+'" onkeypress="return goodchars(event,\'1234567890.\');" />');
$('#credit_'+inc).focus();
$('#editImg'+inc).hide();
$('#saveImg'+inc).show("slow");
$('#refImg'+inc).show("slow");
},
error : function( jqXHR, textStatus, errorThrown){
}
});
}*/
/* Edit Date */
/* save edit date */
function saveCredite(inc,user_id){
var date = $('#credit_'+inc).val();
$.ajax({
url : 'updatedate.php',
type : 'POST',
data : 'inc=' + inc +'&date=' + date +'&user_id=' + user_id+'&action=save',
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(1);
},
success : function( data, textStatus, jqXHR){
if(data =='error'){
//window.location.href="activity.php?msg=4";
alert("Activity already exsists under this department, activity and user initial with the same date");
$(".hasDatepicker").focus();
}else{
var total1 = data.split("||");
var total = data.split("//");
var userCredit1 = total[1];
var userCredit2 = userCredit1.split("||");
var userCredit = userCredit2[0];
//alert(userCredit);
var inc = total1[1];
$('#credit-container'+inc).html(userCredit);
$('#saveImg'+inc).hide();
$('#refImg'+inc).hide();
$('#editImg'+inc).show("slow");
}
},
/*complete : function( jqXHR, textStatus){
alert(3);
},*/
error : function( jqXHR, textStatus, errorThrown){
}
});
}
/* save edit date */
function refCredite(inc,user_id){
$.ajax({
url : 'editdate.php',
type : 'POST',
data : 'inc=' + inc +'&id=' + user_id,
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(1);
},
success : function( data, textStatus, jqXHR){
//alert(data);
var total = data.split("||");
var creditVal = total[0];
var inc = total[1];
$('#credit-container'+inc).html(creditVal);
$('#saveImg'+inc).hide();
$('#refImg'+inc).hide();
$('#editImg'+inc).show("slow");
},
/*complete : function( jqXHR, textStatus){
alert(3);
},*/
error : function( jqXHR, textStatus, errorThrown){
}
});
}
</script>
<?php
$msg=$_REQUEST['msg'];
if($msg == 1){
$msg = '<font color="#009933">Activity added successfully</font>';
}
if($msg == 2){
$msg = '<font color="#009933">Activity updated successfully</font>';
}
if($msg == 3){
$msg = "Activity deleted successfully";
}
if($msg == 4){
$msg = "Activity already exsists under this department, activity and user initial with the same date";
}
?>
<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");
}
}
function open_src_search(val){
if(val==''){
$('#div_src').toggle("slow");
}
else{
$('#div_src').toggle("slow");
}
}
$(document).ready(function(){
setTimeout(function(){
$(".mydiv").fadeOut("slow", function () {
$(".mydiv").remove("slow");
});
}, 4000);
});
</script>
<div class="container_bottom_section">
<?php if($_REQUEST['msg']=='3'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='1'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='2'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='4'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<!--<a href="javascript:window.history.back();" class="require" style="margin-right:5px; margin-bottom:5px;">Back</a>-->
<a href="javascript:open_src_search();" class="require" style="margin-right:5px; margin-bottom:5px;">Search</a>
<?php if($_REQUEST['action']=="" && $_REQUEST['id']==''){ ?>
<?php if($level != 3){ ?>
<a href="javascript:open_src('');" class="require" style="margin-right:5px; margin-bottom:5px;">Create Ticket</a>
<?php } } ?>
<div class="clear"></div>
<div style="padding:5px; <?php if($_REQUEST['submit2']=='') { ?>display:none;<?php } ?> border:1px solid #C4C4C4; margin-bottom:10px;" id="div_src">
<div class="require_add">
<h3 style="font-family:Arial, Helvetica, sans-serif; font-size:18px; float:left; color:#2597C9; padding-bottom:5px;">Search By</h3>
<div class="clear"></div>
</div>
<form name="myfrm" id="myfrm" action="activity.php" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="table_search">
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td width="132" height="25" valign="top" class="require_table_search">From Date:</td>
<td colspan="4" align="left" valign="top">
<input name="from" id="from" type="text" class="validate[required] textfield require_field" value="<?php if($_REQUEST['from']!=''){ echo $_REQUEST['from'];}/*else{ echo date("m/d/Y" , strtotime('-14 days') ); }*/ ?>" />
<script>
$(function() {
$( "#from" ).datepicker({
dateFormat:"<?php echo $dateFormat; ?>"
});
});
</script>
</td>
<td width="39"> </td>
<td width="171" valign="top" class="require_table_search">To Date:</td>
<td colspan="4" align="left" valign="top"><input name="to" id="to" type="text" class="textfield require_field" value="<?php if($_REQUEST['to']!=''){ echo $_REQUEST['to'];} ?>" />
<script>
$(function() {
$( "#to" ).datepicker({
dateFormat:"<?php echo $dateFormat; ?>"
});
});
</script></td>
<td width="26"> </td>
<td width="115" valign="top" class="require_table_search">Staff:</td>
<td width="264" colspan="4" align="left" valign="top">
<select name="staff" id="staff" class="selectfield require_select">
<option value="">-- Select --</option>
<?php
$ActUsers = mysql_query("SELECT `staff_id` , `firstname` , `lastname` FROM `sat_staff` WHERE `current_associate_status`='Active' order by firstname");
while($ActUsers1 = mysql_fetch_array($ActUsers))
{
?>
<option value="<?php echo $ActUsers1['staff_id']; ?>" <?php if($ActUsers1['staff_id']==$_REQUEST['staff']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td width="132" height="25" valign="top" class="require_table_search">Activity:</td>
<td colspan="4" align="left" valign="top">
<select name="main_activity_id" id="main_activity_id" class="selectfield require_select">
<option value="">-- Select --</option>
<?php
$ActUsers = mysql_query("SELECT * FROM `sat_main_activity` WHERE 1 order by main_activity");
while($ActUsers1 = mysql_fetch_array($ActUsers))
{
?>
<option value="<?php echo $ActUsers1['main_activity_id']; ?>" <?php if($ActUsers1['main_activity_id']==$_REQUEST['main_activity_id']){ ?> selected <?php } ?>><?php echo $ActUsers1['main_activity']; ?></option>
<?php } ?>
</select>
</td>
<td width="39"> </td>
<td width="171" valign="top" class="require_table_search">A/C Mgr:</td>
<td colspan="4" align="left" valign="top"><select name="ac_mgr" id="ac_mgr" class="selectfield require_select">
<option value="">-- Select --</option>
<?php
$ActUsers = mysql_query("SELECT `user_id` , `firstname` , `lastname` FROM `sat_users` WHERE `status`='Active' order by firstname");
while($ActUsers1 = mysql_fetch_array($ActUsers))
{
?>
<option value="<?php echo $ActUsers1['user_id']; ?>" <?php if($ActUsers1['user_id']==$_REQUEST['ac_mgr']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
<?php } ?>
</select>
</td>
<td width="26"> </td>
<td width="115" valign="top" class="require_table_search">Created By:</td>
<td width="264" colspan="4" align="left" valign="top">
<select name="user_id" id="user_id" class="selectfield require_select">
<option value="">-- Select --</option>
<?php
$ActUsers = mysql_query("SELECT `user_id` , `firstname` , `lastname` FROM `sat_users` WHERE `status`='Active' order by firstname");
while($ActUsers1 = mysql_fetch_array($ActUsers))
{
?>
<option value="<?php echo $ActUsers1['user_id']; ?>" <?php if($ActUsers1['user_id']==$_REQUEST['user_id']){ ?> selected <?php } ?>><?php echo $ActUsers1['firstname']." ".$ActUsers1['lastname']; ?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td> </td>
<td width="22"> </td>
<td width="20"> </td>
<td width="21"> </td>
<td width="131"> </td>
<td> </td>
<td style="padding-right:5px;"><span style="float:right;">
<input name="submit2" type="submit" value="Search" class="submit" style="margin-top:0px;" />
</span>
</td>
<td colspan="4">
<span style="float:left;">
<a href="activity.php" style="text-decoration:none;">
<input name="submit3" type="button" value="Show All" class="submit" style="margin-top:0px;" />
</a>
</span>
</td>
<td> </td>
<td> </td>
<td colspan="4"> </td>
</tr>
</table>
</form>
</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">
<div id="div_add_task" style="display:<?php if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit']){ ?>block<?php }else{ ?>none<?php } ?>;">
<table width="531" height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">
<tr>
<td align="center" valign="middle" colspan="5" class="head_text" >
<?php if($_REQUEST['action']=="edit" && $_REQUEST['id']!='' && !$_REQUEST['edit']){ ?>Edit<?php }else{ ?>Add<?php } ?> Staff Activity
</td>
</tr>
<tr class="smalltext">
<td height="10" 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` WHERE `current_associate_status` = 'Active' ORDER BY firstname,lastname");
while($staff_details = mysql_fetch_array($get_staff)){
?>
<option value="<?php echo $staff_details['staff_id'];?>"><?php echo $staff_details['firstname']." ".$staff_details['lastname'];?></option>
<?php
}
?>
</select>
</td>
<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</td>
<td align="left" valign="middle" class="enquiery">:</td>
<td align="left" valign="middle"><input name="client_name" size="25" type="text" value="<?php echo $_REQUEST['client_name']; ?>" class="textfield require_field" id="client_name"/></td>
<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</td>
<td align="left" valign="middle" class="enquiery">:</td>
<td align="left" valign="middle"><input name="end_client_name" size="25" type="text" value="<?php echo $_REQUEST['end_client_name']; ?>" class="textfield require_field" id="end_client_name"/></td>
<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");
$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" readonly="readonly" 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</td>
<td align="left" valign="middle" class="enquiery">:</td>
<td align="left" valign="middle"><input name="work_location" size="25" type="text" value="<?php echo $_REQUEST['work_location']; ?>" id="work_location" class="textfield require_field"/></td>
<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</td>
<td align="left" valign="middle" class="enquiery">:</td>
<td align="left" valign="middle">
<textarea name="comments" id="comments" style="width:180px; height:66px" class="textfield require_field" ><?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();" />
<input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" onclick="document.location.href='activity.php';" />
<?
}
else
{
?>
<input type="submit" name="add" class="newadd" value="ADD" border="0" style="margin:0px;" onclick="return validate();" />
<input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" onclick="document.location.href='activity.php';" />
<?
}
?> </td>
</tr>
<tr class="smalltext">
<td height="10" colspan="5" align="left" valign="middle" class="enquiery"></td>
</tr>
</table></td>
</tr>
</table>
</div>
</td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<?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">Sort by Exhibit Category</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="111" align="left" valign="middle" class="enquiery"> </td>
<td width="153" height="32" align="left" valign="middle" class="head_text2">Select Exhibit Category </td>
<td width="24" align="left" valign="middle" class="enquiery">:</td>
<td width="170" align="left" valign="middle"><select name="search_market" class="selectfield">
<option value="">--Select --</option>
<? $sql_product=sprintf("select * from sat_task_category where 1 order by category");
$query_product=mysql_query($sql_product);
while($array_product=mysql_fetch_array($query_product))
{
?>
<option value="<?=$array_product['id']?>" <? if($_REQUEST['search_market']==$array_product['id']) echo "selected"; ?>>
<?=$array_product['category']?>
</option>
<?
}
?>
</select></td>
<td width="71"> </td>
</tr>
<tr>
<td align="left" valign="middle" class="enquiery"> </td>
<td height="31" align="left" valign="middle" class="enquiery"> </td>
<td align="left" valign="middle" class="enquiery"></td>
<td align="left" valign="middle" class="button"><input type="submit" name="go" class="newadd" value="GO" border="0" style="margin:0px;" /></td>
<td> </td>
</tr>
<tr class="smalltext">
<td height="10" colspan="5" align="left" valign="middle" class="enquiery"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr><?php */?>
</table></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">
<?php /*?> <td width="5%" height="22" align="center" class="head_text">No</td><?php */?>
<td width="7%" align="center" class="head_text">Ref. No.</td>
<td width="13%" align="center" class="head_text">Staff Name</td>
<td width="31%" align="center" class="head_text">Activities</td>
<td width="10%" align="center" class="head_text">Pending Tasks</td>
<td width="10%" align="center" class="head_text">Effective Date</td>
<td width="12%" align="center" class="head_text">A/c Mngr.</td>
<td width="11%" align="center" class="head_text">Created By</td>
<?php if($user_level==1){ ?>
<td colspan="2" align="center" class="head_text">E / D</td>
<?php } ?>
</tr>
<?php
$no_data=mysql_num_rows(mysql_query("select * from sat_task"));
$query_res="select * from `sat_staff_activity` where staff_id!=''";
if($_REQUEST['from']!='' && $_REQUEST['to']!=''){
$query_res .= " and `effective_date` >= '".change_dateformat($_REQUEST['from'])."' AND `effective_date` <= '".change_dateformat($_REQUEST['to'])."'";
}
if($_REQUEST['from']!='' && $_REQUEST['to']==''){
$query_res .= " and `effective_date` >= '".change_dateformat($_REQUEST['from'])."'";
}
if($_REQUEST['from']=='' && $_REQUEST['to']!=''){
$query_res .= " AND `effective_date` <= '".change_dateformat($_REQUEST['to'])."'";
}
if($_REQUEST['staff']!=''){
$query_res .= " AND `staff_id` = '".$_REQUEST['staff']."'";
}
if($_REQUEST['main_activity_id']!=''){
$query_res .= " AND `main_activity_id` = '".$_REQUEST['main_activity_id']."'";
}
if($_REQUEST['ac_mgr']!=''){
$query_res .= " AND `staff_id` in (select staff_id from sat_staff where account_manager='".$_REQUEST['ac_mgr']."')";
}
if($_REQUEST['user_id']!=''){
$query_res .= " AND `staff_activity_id` in (select staff_activity_id from sat_staff_task where user_id='".$_REQUEST['user_id']."')";
}
$query_res.=" order by `staff_activity_id` DESC";
$sel_product=mysql_query($query_res);
//////////////////////start pagination/////////////////////////
$page=$_REQUEST['page'];
if($_REQUEST['page']=="")
{
$page = 1;
}
//echo $page;
$max_results = 10;
$prev = ($page - 1);
$next = ($page + 1);
$from = (($page * $max_results) - $max_results);
$total_results = mysql_num_rows($sel_product);
$total_pages = ceil($total_results / $max_results);
$pagination = '';
if($page > 1)
{
$pagination .= "<a href=\"activity.php?page=$prev&from=".$_REQUEST['from']."&to=".$_REQUEST['to']."&staff=".$_REQUEST['staff']."&main_activity_id=".$_REQUEST['main_activity_id']."&ac_mgr=".$_REQUEST['ac_mgr']."&user_id=".$_REQUEST['user_id']."\" class=\"more_link_pagination_prev\">Previous</a>";
$pagination.=" ";
}
for($i = 1; $i <=$total_pages; $i++)
{
if(($page) == $i)
{
$pagination .= $i;
$pagination.=' ';
}
else
{
$pagination .= "<a href=\"activity.php?page=$i&from=".$_REQUEST['from']."&to=".$_REQUEST['to']."&staff=".$_REQUEST['staff']."&main_activity_id=".$_REQUEST['main_activity_id']."&ac_mgr=".$_REQUEST['ac_mgr']."&user_id=".$_REQUEST['user_id']."\" class=\"more_link_pagination\">$i</a>";
$pagination.=' ';
}
}
if($page < $total_pages)
{
$pagination .= "<a href=\"activity.php?page=$next&from=".$_REQUEST['from']."&to=".$_REQUEST['to']."&staff=".$_REQUEST['staff']."&main_activity_id=".$_REQUEST['main_activity_id']."&ac_mgr=".$_REQUEST['ac_mgr']."&user_id=".$_REQUEST['user_id']."\" class=\"more_link_pagination_prev\">Next</a>";
$pagination.=" ";
}
$query_res.=" limit $from,$max_results";
//echo $query_res;
$query_products=mysql_query($query_res);
////////////////////////////////End pagination////////////////////////////////////
if(mysql_num_rows($query_products)>0)
{
$inc=1;
while($array_products=mysql_fetch_array($query_products))
{
if($inc%2==0)
{
?>
<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['staff_activity_id']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php $user_name = mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_staff` WHERE `staff_id` = '$array_products[staff_id]'")); echo $user_name['firstname']." ".$user_name['lastname'];?></td>
<td align="center" valign="middle" class="head_text2"><?php $get_activity = mysql_fetch_array(mysql_query("SELECT `main_activity` FROM `sat_main_activity` WHERE `main_activity_id` = '$array_products[main_activity_id]'"));echo $get_activity['main_activity']; ?></td>
<td align="center" valign="middle" class="head_text2"><a href="editActivity.php?edit_id=<?php echo $array_products['staff_activity_id'];?>"><u><?php
echo $no_of_row = mysql_num_rows(mysql_query("SELECT `staff_task_id` FROM `sat_staff_task` WHERE `staff_activity_id` = '".$array_products['staff_activity_id']."' AND `complete_date` = '0000-00-00' AND `task_id`!='0'"));
?></u></a></td>
<td align="center" class="head_text2" id="credit-container<?php echo $inc; ?>">
<?php echo change_dateformat_reverse($array_products['effective_date']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php
// echo "SELECT `account_manager` FROM `sat_staff` WHERE `staff_id` = '$array_products[staff_id]'";
$acc_mngr = mysql_fetch_array(mysql_query("SELECT `account_manager` FROM `sat_staff` WHERE `staff_id` = '$array_products[staff_id]'"));
$name_of_acc_mngr = mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_users` WHERE `user_id` = '".$acc_mngr['account_manager']."'"));
//print_r($name_of_acc_mngr);
if($name_of_acc_mngr['firstname']!=''){
echo $name_of_acc_mngr['firstname']." ".$name_of_acc_mngr['lastname'];
}else{
echo "N/A";
}
?>
</td>
<td align="center" valign="middle" class="head_text2"><?php
$created_by = mysql_fetch_array(mysql_query("SELECT `user_id` FROM `sat_staff_activity` WHERE `staff_activity_id` = '$array_products[staff_activity_id]'"));
$created_by1 = mysql_fetch_array(mysql_query("SELECT `firstname`,`lastname` FROM `sat_users` WHERE `user_id` = '$created_by[user_id]'"));
if($created_by1['firstname']!=''){
echo $created_by1['firstname']." ".$created_by1['lastname'];
}else{
echo "N/A";
}
?></td>
<?php if($user_level==1){ ?>
<td width="6%" align="center" valign="middle" class="head_text2">
<a href="javascript:void(0);" id="editImg_<?php echo $inc; ?>_<?php echo $array_products["staff_activity_id"]; ?>" class="editDateef"><img src="images/1304761512_pen.png" title="Edit Date"></a>
<a href="javascript:saveCredite(<?php echo $inc; ?>,<?php echo $array_products['staff_activity_id']; ?>);" id="saveImg<?php echo $inc; ?>" style="display:none;"><img src="images/save.png" title="Save Date"></a>
<a href="javascript:refCredite(<?php echo $inc; ?>,<?php echo $array_products['staff_activity_id']; ?>);" id="refImg<?php echo $inc; ?>" style="display:none;"><img src="images/refresh.png" title="Reload"></a>
<a href="activity.php?delete=del&delete_id=<?php echo $array_products['staff_activity_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure you want to delete this activity?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a>
</td>
<?php } ?>
<?php /*?> <a href="javascript:void(0);" class="editDateef" id="editImg_<?php echo $inc; ?>_<?php echo $array_products["staff_activity_id"]; ?>"><img src="" alt="Edit" title="Edit" border="0" /></a>
<a href="javascript:saveCredite(<?php echo $inc; ?>,<?php echo $array_products["staff_activity_id"]; ?>);" id="saveImg<?php echo $inc; ?>" style="display:none;"><img src="images/save.png" title="Save date"></a>
<a href="javascript:refCredite(<?php echo $inc; ?>,<?php echo $array_products["staff_activity_id"]; ?>);" id="refImg<?php echo $inc; ?>" style="display:none;"><img src="images/refresh.png" title="Reload"></a>
</td>
<td>
<a href="activity.php?delete=del&delete_id=<?php echo $array_products['staff_activity_id'];?>&search_market=<?=$_REQUEST['search_market']?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure you want to delete this activity?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a><?php */?>
</tr>
<?php
$inc++;}
}
else
{
?>
<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>
<?php
}
?>
</table></td>
</tr>
<tr>
<td align="center" valign="top"> </td>
</tr>
<tr>
<td height="20" colspan="10" align="center" valign="middle" bgcolor="#B2CEFC" class="head_text"><?=$pagination;?></td>
</tr>
</table></td></tr></table>
</form>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180