Preview: userpendingtasklist.php
Size: 19.02 KB
/home/jambtst2015/public_html/giraffeng.com/admin/userpendingtasklist.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php
//echo check_null_value('email','sat_users','user_id',$_SESSION['sat_login_id']);
if($_POST){
include ("includes/libmail.php");
$userid = $_POST['userid'];
$user_id = mysql_query("SELECT user_id ,`email`, `firstname`, `lastname` FROM `sat_users` WHERE status='Active' and user_id='".$userid."'");
while($user_id1 = mysql_fetch_array($user_id)){
$list1='';
//$task_details = mysql_query("select * FROM `sat_staff_task` where `resource` = '".$user_id1['user_id']."' AND `complete_date` = '0000-00-00' GROUP BY `task_id` order by staff_task_id desc");
//echo "select * FROM `sat_staff_task` where `resource` = '".$user_id1['user_id']."' AND `complete_date` = '0000-00-00' order by staff_task_id desc";
$task_details = mysql_query("select * FROM `sat_staff_task` where `resource` = '".$user_id1['user_id']."' AND `complete_date` = '0000-00-00' order by staff_task_id desc");
$row = mysql_num_rows($task_details);
//$mail_details = mysql_query("select `resource`,`task_id` FROM `sat_staff_task` where `resource` = '".$user_id1['user_id']."' AND `complete_date` = '0000-00-00' GROUP BY `task_id`");
while($task_details1=mysql_fetch_array($task_details)){
$staff_activity = mysql_fetch_array(mysql_query("select * from sat_staff_activity where staff_activity_id='".$task_details1['staff_activity_id']."'"));
$main_activity_id = $staff_activity['main_activity_id'];
$staff_activity_id = $staff_activity['staff_activity_id'];
$effective_date = date('m/d/Y',strtotime($staff_activity['effective_date']));
$staff_id = $staff_activity['staff_id'];
$comments = $staff_activity['comments'];
$main_activity = mysql_fetch_array(mysql_query("select * from sat_main_activity where main_activity_id='".$main_activity_id."'"));
$staff = mysql_fetch_array(mysql_query("select * from sat_staff where staff_id='".$staff_id."'"));
$task_name = mysql_query("SELECT `task` FROM `sat_task` WHERE `task_id` = '".$task_details1['task_id']."'");
while($tasks = mysql_fetch_array($task_name)){
//$list = '<li>'.$tasks['task'].'</li>';
//$list1 = $list1.$list;
//$mail_details2=mysql_fetch_array($mail_details)
$list = '<tr style=" background-color:#eeeeee; font: 13px Arial,Helvetica,sans-serif; padding: 10px 0; margin:4px 0 0 0;">
<td style="padding:5px;">'.$main_activity['main_activity'].'</td>
<td style="padding:5px;">'.$staff['firstname'].' '.$staff['lastname'].'</td>
<td style="padding:5px;">'.$tasks['task'].'</td>
<td style="padding:5px;">'.$comments.'</td>
<td align="center">'.$staff_activity_id.'</td>
<td align="center">'.$effective_date.'</td>
</tr>';
$list1 = $list1.$list;
}
}
// echo $row;
// echo $list1;
if($row>0){
$to = check_null_value('email','sat_users','user_id',$_SESSION['sat_login_id']);;
//$to = 'sayantan@infosolz.com';
//exit;
$from = 'SAT@ABSI itteam@absi-usa.com'; // sender
$subject = 'Pending tasks for '.$user_id1['firstname'].' '.$user_id1['lastname'].' - SAT';
$message = ($list1);
$content = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>American Business Solutions Inc - SAT</title>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0" bordercolor="#000000" style="border-collapse:collapse; margin:0 auto; border:#C4C4C4 1px solid;">
<tr>
<td width="600" colspan="5" style=" background:#DCDBDB; border-bottom: 1px solid #C4C4C4; height: 100px;">
<img width="205" height="59" style="padding:10px 0 10px 20px;" src="http://' . $_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']).'/images/logo.png">
</td>
</tr>
<tr>
<td colspan="2">
<p style=" background-color: #7AAAF5; color: #FFFFFF; font: bold 13px Arial,Helvetica,sans-serif; padding: 10px 0; margin:4px 0 0 0; text-align: center;">'.$subject.'</p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:15px; font-family: Arial,Helvetica,sans-serif; font-size: 13px;">
<table width="100%" border="0">
<tr style=" background-color: #7AAAF5; color: #FFFFFF; font: bold 13px Arial,Helvetica,sans-serif; padding: 10px 0; margin:4px 0 0 0; text-align: center;">
<td>Activity</td>
<td>Staff</td>
<td>Task</td>
<td>Comments</td>
<td>Ref No</td>
<td>Effective Date</td>
</tr>
##EMAIL_BODY##
</table>
</td>
</tr>
<tr>
<td colspan="5" style="background:#094A66;"><p style="color: #2597C9; font-family: Arial,Helvetica,sans-serif; font-size: 11px; padding: 6px 0;
text-align: center;">© 2013 <a href="http://' . $_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']).'/" style=" color: #ffffff; font-family: Arial,Helvetica,sans-serif; font-size: 11px;
text-decoration: none;">American Business Solutions Inc</a>. All rights reserved.</p></td>
</tr>
<td width="500"></tr>
</table>
</body>
</html>';
$email_body = str_replace(array("##EMAIL_BODY##"),array($message),$content);
// message lines should not exceed 70 characters (PHP rule), so wrap it
//$message = wordwrap($message, 70);
// send mail
$ccEmail = 'info@absi-usa.com';
$m= new Mail; // create the mail
$m->From($from);
//$to1="ABS <".$sendEmail.">";
//$to2="ABS <".$ac_mgrEmail.">";
$m->To($to);
//$m->cc('info@absi-usa.com');
//$m->To($to2);
//$m->Bcc($userEmail);
$m->Subject($subject);
$m->Body($email_body);
$m->cc($ccEmail);
//$m->attach($dest);
$m->Send();
}
}
header("location:userpendingtasklist.php?msg=5&userid=".$userid);
exit;
}
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();
}
</script>
<?php
$msg=$_REQUEST['msg'];
if($msg == 1){
$msg = '<font color="#009933">Task added successfully</font>';
}
if($msg == 2){
$msg = '<font color="#009933">Task updated successfully</font>';
}
if($msg == 3){
$msg = "Task deleted successfully";
}
if($msg == 4){
$msg = "Task already exsists under this department, activity and user initial";
}
if($msg == 5){
$msg = "Pending Task Mail Send to ".check_null_value('firstname','sat_users','user_id',$_SESSION['sat_login_id'],'lastname')."'s email (".check_null_value('email','sat_users','user_id',$_SESSION['sat_login_id']).")";
}
?>
<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 } ?>
<?php if($_REQUEST['msg']=='5'){ ?>
<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 } ?>
<!--<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:window.history.back();" class="require" style="margin-right:5px; margin-bottom:5px;">Back</a>
<?php } ?>
<?php if($level == 1){ ?>
<a href="javascript:document.frmproduct.submit();" class="require tmsend" style="margin-right:5px; margin-bottom:5px;" id="mSend">Send pending task mail</a>
<?php } ?>
<div class="clear"></div>
<form name="frmproduct" id="formID" action="userpendingtasklist.php" method="post">
<input type="hidden" name="id" value="<?php echo $_REQUEST['id']?>" />
<input type="hidden" name="userid" value="<?php echo $_REQUEST['userid']?>" />
<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 */?>
</table></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 class="smalltext" style="color:#2597C9; padding:0 0 15px 5px;"><?php echo check_null_value('firstname','sat_users','user_id',$_REQUEST['userid'],'lastname'); ?>'s Pending Tasks</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="12%" align="center" class="head_text">Department</td>
<td width="11%" align="center" class="head_text">Task ID</td>
<td width="29%" align="center" class="head_text">Task Name</td>
<td width="13%" align="center" class="head_text">Main Activity</td>
<td width="14%" align="center" class="head_text">Staff Name</td>
<td width="12%" align="center" class="head_text">Eff Date</td>
<td width="9%" align="center" class="head_text">Ref. No.</td>
</tr>
<?php
// $no_data=mysql_num_rows(mysql_query("SELECT * FROM `sat_staff_task` WHERE `task_id` in (SELECT task_id FROM `sat_task` WHERE `user_id` = '".$_REQUEST['userid']."') AND `complete_date` = '0000-00-00'"));
$no_data=mysql_num_rows(mysql_query("SELECT * FROM `sat_staff_task` WHERE `resource` = '".$_REQUEST['userid']."' AND `complete_date` = '0000-00-00'"));
//$query_res="SELECT * FROM `sat_staff_task` WHERE `user_id` = '".$_REQUEST['userid']."' AND `complete_date` = '0000-00-00' group by `task_id`";
$query_res="SELECT * FROM `sat_staff_task` WHERE `resource` = '".$_REQUEST['userid']."' AND `complete_date` = '0000-00-00'";
if($_REQUEST['search_market']!='')
{
$query_res.=" and category_id='".$_REQUEST['search_market']."'";
}
$query_res.=" order by staff_task_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=\"userpendingtasklist.php?page=$prev&userid=".$_REQUEST['userid']."\" 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=\"userpendingtasklist.php?page=$i&userid=".$_REQUEST['userid']."\" class=\"more_link_pagination\">$i</a>";
$pagination.=' ';
}
}
if($page < $total_pages)
{
$pagination .= "<a href=\"userpendingtasklist.php?page=$next&userid=".$_REQUEST['userid']."\" 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)
{
//echo "hi";
$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 check_null_value('department','sat_task','task_id',$array_products['task_id']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['task_id']; ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('task','sat_task','task_id',$array_products['task_id']); ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('main_activity','sat_main_activity','main_activity_id',check_null_value('main_activity_id','sat_task','task_id',$array_products['task_id'])); ?></td>
<?php
$getStaff = mysql_query("SELECT * FROM `sat_staff_activity` WHERE staff_activity_id='".$array_products['staff_activity_id']."'");
$arrStaff = mysql_fetch_assoc($getStaff);
?>
<td align="center" valign="middle" class="head_text2"><?php echo check_null_value('firstname','sat_staff','staff_id',$arrStaff['staff_id'],'lastname'); ?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $arrStaff['effective_date']?></td>
<td align="center" valign="middle" class="head_text2"><?php echo $array_products['staff_activity_id']?></td>
</tr>
<?php
$inc++;}
}
else{
?>
<tr class="smalltexthead">
<td height="20" colspan="7" 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