<!--<meta http-equiv="refresh" content="10; URL=<?php echo $base_url; ?>home.php?newtribe=newtribe&sub_module_id=87">-->
<?php
$my_hier;
$progress_dur=0;
$qr_confirm23a="SELECT * from user_group_submodule WHERE sub_module_id='$sub_module_id' and `add`='A' and user_group_id='$user_group_id'";
$qr_res23a=mysql_query($qr_confirm23a) or die ('Error : $qr_confirm23a.' .mysql_error());
$num_rows23a=mysql_num_rows($qr_res23a); 
if ($num_rows23a==0) 
{ 
include ('includes/restricted.php');
}
else
{
 ?>
<script language="javascript" src="gen_validatorv31.js" type="text/javascript"></script>
<script type="text/javascript" src="calender/calendar.js"></script>
<script type="text/javascript" src="calender/lang/calendar-en.js"></script>
<script type="text/javascript" src="calender/calendar-setup.js"></script>

<link href="src/facebox.css" media="screen" rel="stylesheet" type="text/css" />
<script src="lib/jquery.js" type="text/javascript"></script>
<script src="src/facebox.js" type="text/javascript"></script>
  <script type="text/javascript">
	jQuery(document).ready(function($) {
	  $('a[rel*=facebox]').facebox({
		loadingImage : 'src/loading.gif',
		closeImage   : 'src/closelabel.png'
	  })
	})
  </script>
  <script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<script src="js/application.js" type="text/javascript" charset="utf-8"></script>

<Style>
.error_strings{ font-family:Verdana; font-size:10px; color: #FF0000;}
</Style>

<style type="text/css">

@import url(calender/calendar-win2k-1.css);

.blink_me {
  animation: blinker 1s linear infinite;
  color:#ff0000;
  font-weight:bold;
}

@keyframes blinker {  
  50% { opacity: 0; }
}

</style>

<script type="text/javascript"> 

function confirmResume()
{
    return confirm("Are you sure you want to resume task");
}

function confirmReactivate()
{
    return confirm("Are you sure you want to reactivate the user?");
}


</script>
 <form name="search" method="post" action="">  
<table width="100%" border="0" align="center" bgcolor="#9AD7AF" style="border-radius:5px;">
  <tr bgcolor="#FFFFCC">
   
    <td colspan="12" height="30" align="center"> 
	<?php

if ($_GET['updateuserconfirm']==1)
echo '<div align="center" style="background: #FFCC33; height:20px; width:550px; border:#FF0000 solid 1px; font-size:11px;" class="br-5"> <p align="center"><font color="#FF0000" >User Updated Successfully!!</font></strong></p></div>';
?> 

<?php 

if ($_GET['deleteuserconfirm']==1)
echo '<div align="center" style="background: #FFCC33; height:20px; width:550px; border:#FF0000 solid 1px; font-size:11px;" class="br-5"> <p align="center"><font color="#FF0000" >User deleted successfully!!</font></strong></p></div>';
?>
	
<span style="float:right;"><a style="width:40%; border-radius:5px; color:#fff; text-decoration:none; padding-left:40px; padding-top:5px; padding-bottom:5px; padding-right:40px; background:#ff0000;" href="<?php echo $_SERVER['HTTP_REFERER']; ?>"><< Back</a></span>	</td>
	
    </tr>
<!--<tr bgcolor="#FFFFCC">
   
    <td  height="30"  colspan="12" align="center">
	<strong>Search Task - Enter Task Name: 
    </strong>
       
    <input type="text" name="task_name" size="30" />
	
	Publish Status : <select style="width:150px;" name="status"><option value="0">Select.......................................</option>
								 
										  
                                    <option value="1">Active</option>
                                   <option value="2">Domant</option>                
                                   <option value="3">Complete</option>                
 </select>
 
Task Nature : <select style="width:150px;" name="nature"><option value="0">Select.......................................</option>
								 
										  
                                    <option value="1">Open</option>
                                   <option value="2">Time Bound</option>                
                                          
 </select>
	
	<input type="submit" name="generate" value="Search"></td>
	
    </tr>	-->
	
  
  <tr  style="background:url(images/description.gif) repeat-x;" height="30" >
  <?php 
  
$queryop2c = "SELECT * FROM user_group order by user_group_id asc";
$results2c= mysql_query($queryop2c) or die ("Error $queryop2c.".mysql_error());

while ($rows2c=mysql_fetch_object($results2c))
{
  
  ?>
  
    <td style="hover{background:#ff0000;}" align="center" width="10%" style="cursor:pointer; font-weight:bold; border-radius:5px;"  onclick="location.href='home.php?viewdistrict=viewdistrict&sub_module_id=<?php echo $sub_module_id; ?>&ug_id=<?php echo $rows2c->user_group_id; ?>'" height="50"><strong><?php echo $rows2c->user_group_name;?></strong></td>
 <?php
}

 ?>    
    </tr> 
</table>

<table width="100%" border="0" align="center" bgcolor="#9AD7AF" style="border-radius:5px;">
<tr height="30" bgcolor="#FFFFCC">
<td ><strong>User Group : <font color="#ff0000"><?php $get_ug_id=$_GET['ug_id']; 

$queryop2cg = "SELECT * FROM user_group where user_group_id='$get_ug_id'";
$results2cg= mysql_query($queryop2cg) or die ("Error $queryop2cg.".mysql_error());
$rows2cg=mysql_fetch_object($results2cg);

echo $rows2cg->user_group_name;

?></font></strong></td>
</tr>
</table>

<table width="100%" border="0" align="center" bgcolor="#9AD7AF" style="border-radius:5px;">
<tr height="30" align="center">

<?php 
$sql3="SELECT * FROM users where user_group_id='$get_ug_id' order by f_name asc";
$results3= mysql_query($sql3) or die ("Error $sql3.".mysql_error());
while ($rows3=mysql_fetch_object($results3))
{
?>
<td width="10%" onclick="location.href='home.php?viewdistrict=viewdistrict&sub_module_id=<?php echo $sub_module_id; ?>&ug_id=<?php echo $get_ug_id; ?>&staff_id=<?php echo $rows3->user_id;?>'" bgcolor="#FB6A00" style="cursor:pointer; font-weight:bold; border-radius:5px;"><?php echo $rows3->f_name;?></td>

<?php
}
 ?>

</tr>





</table>

<table width="100%" border="0" align="center" bgcolor="#9AD7AF" style="border-radius:5px;">
<tr height="30" bgcolor="#FFFFCC">
<td ><strong>Staff Name : <font color="#ff0000"><?php $get_staff_id=$_GET['staff_id']; 

$queryop2cgs = "SELECT * FROM users where user_id='$get_staff_id'";
$results2cgs= mysql_query($queryop2cgs) or die ("Error $queryop2cgs.".mysql_error());
$rows2cgs=mysql_fetch_object($results2cgs);

echo $rows2cgs->f_name;

?></font></strong></td>
</tr>
</table>

<table>
<tr  style="background:url(images/description.gif);" height="30" >
    <td align="center" width="150"><strong>Staff Name</strong></td>
    <td align="center" width="150"><strong>Task Name</strong></td>    
	<td align="center" width="150"><strong>Status</strong></td>
	<td align="center" width="150"><strong>Date Assigned</strong></td>
	<td align="center" width="150"><strong>Min. Past Allocated Time</strong></td>
    <td align="center" width="150"><strong>Task Duration (Minutes)</strong></td>    
    <td align="center" width="150"><strong>Time Count Down</strong></td>
    <td align="center" width="150"><strong>Download Document</strong></td>
	<td align="center" width="100"><strong>View Comments</strong></td>
	<!--<td align="center" width="100"><strong>Stop Task</strong></td>
    <td width="150" align="center"><strong>View Task Details</strong></td>-->


    
    </tr>
  
  <?php 
  
   

if ($user_group_id==15) 
  
{ 
 
  if (!isset($_POST['generate']))
{



$queryop = "SELECT * FROM tasks,staff_task,users where staff_task.task_id=tasks.task_id and 
users.user_id=staff_task.staff_id and staff_task.staff_id='$get_staff_id' group by tasks.task_id order by date_assigned desc";
$results= mysql_query($queryop) or die ("Error $queryop.".mysql_error());

} 


else
{

$staff_id=$_POST['staff_id'];
$status=$_POST['status'];
$task_name=$_POST['task_name'];


$queryop= "SELECT * FROM tasks,staff_task,users";
    $conditions = array();

	
if($task_name!='') 
{
	
      $conditions[] = "tasks.task_name LIKE '%$task_name%' ";
} 


 if($staff_id!=0 ) 
 {
	
      $conditions[] = "staff_task.staff_id='$staff_id'";
}
	
if (count($conditions) > 0) 
	
    
 {


$queryop .= " WHERE " . implode(' AND ', $conditions)." and staff_task.task_id=tasks.task_id and 
users.user_id=staff_task.staff_id order by date_assigned desc";
//$queryop .= " order by task_name asc";
 
 
 }
 
 else
 {

$queryop = "SELECT * FROM tasks,staff_task,users where staff_task.task_id=tasks.task_id and 
users.user_id=staff_task.staff_id order by date_assigned desc";
$results= mysql_query($queryop) or die ("Error $queryop.".mysql_error());
 
 
 }
	
	

    $results = mysql_query($queryop) or die ("Error $queryop.".mysql_error());


} 

}
else
{

$sql22="SELECT * FROM users where report_to_user_group_id='$user_group_id'";
$results22= mysql_query($sql22) or die ("Error $sql22.".mysql_error());
$numrows22=mysql_num_rows($results22);

if ($numrows22>0)

{

if (!isset($_POST['generate']))
{



$queryop = "SELECT * FROM tasks,staff_task,users where staff_task.task_id=tasks.task_id and staff_task.staff_id=users.user_id and tasks.status='4' and users.report_to_hierachy >='$my_hier' 
and users.report_to_user_group_id='$user_group_id' group by tasks.task_id order by date_assigned desc";
$results= mysql_query($queryop) or die ("Error $queryop.".mysql_error()); 

} 


else
{

$task_name=$_POST['task_name'];
$status=$_POST['status'];
$nature=$_POST['nature'];


$queryop= "SELECT * FROM tasks,staff_task,users";
    $conditions = array();

	
 if($task_name!='' ) 
 {
	
      $conditions[] = "task_name LIKE '%$task_name%' ";
} 

 if($status!=0 ) 
 {
	
      $conditions[] = "status ='$status'";
}

 if($nature!=0 ) 
 {
	
      $conditions[] = "task_nature='$nature'";
}
	
if (count($conditions) > 0) 
	
    
 {


$queryop .= " WHERE " . implode(' AND ', $conditions)." and staff_task.task_id=tasks.task_id and tasks.status='1' and 
users.user_id=staff_task.staff_id and staff_task.staff_id='$user_id' order by date_assigned desc";
//$queryop .= " order by task_name asc";
 
 
 }
 
 else
 {

$queryop = "SELECT * FROM tasks,staff_task,users where staff_task.task_id=tasks.task_id and tasks.status='4' and 
users.user_id=staff_task.staff_id and staff_task.staff_id='$user_id' group by tasks.task_id order by date_assigned desc";
$results= mysql_query($queryop) or die ("Error $queryop.".mysql_error());
 
 
 }
	
	

    $results = mysql_query($queryop) or die ("Error $queryop.".mysql_error());


} 






}
else
{
if (!isset($_POST['generate']))
{



$queryop = "SELECT * FROM tasks,staff_task,users where staff_task.task_id=tasks.task_id  and 
users.user_id=staff_task.staff_id and staff_task.staff_id='$user_id' and tasks.status='4' 
group by tasks.task_id order by date_assigned desc";
$results= mysql_query($queryop) or die ("Error $queryop.".mysql_error());

} 


else
{

$task_name=$_POST['task_name'];
$status=$_POST['status'];
$nature=$_POST['nature'];


$queryop= "SELECT * FROM tasks,staff_task,users";
    $conditions = array();

	
 if($task_name!='' ) 
 {
	
      $conditions[] = "task_name LIKE '%$task_name%' ";
} 

 if($status!=0 ) 
 {
	
      $conditions[] = "status ='$status'";
}

 if($nature!=0 ) 
 {
	
      $conditions[] = "task_nature='$nature'";
}
	
if (count($conditions) > 0) 
	
    
 {


$queryop .= " WHERE " . implode(' AND ', $conditions)." and staff_task.task_id=tasks.task_id  and 
users.user_id=staff_task.staff_id and staff_task.staff_id='$user_id' and tasks.status='4' group by tasks.task_id order by date_assigned desc";
//$queryop .= " order by task_name asc";
 
 
 }
 
 else
 {

$queryop = "SELECT * FROM tasks,staff_task,users where staff_task.task_id=tasks.task_id  and 
users.user_id=staff_task.staff_id and staff_task.staff_id='$user_id' and tasks.status='4' group by tasks.task_id order by date_assigned desc";
$results= mysql_query($queryop) or die ("Error $queryop.".mysql_error());
 
 
 }
	
	

    $results = mysql_query($queryop) or die ("Error $queryop.".mysql_error());


}


} 

}
























if (mysql_num_rows($results) > 0)
						  {
							  $RowCounter=0;
							  while ($rows=mysql_fetch_object($results))
							  { 
							  
							  $RowCounter++;
							  if($RowCounter % 2==0)
{
echo '<tr bgcolor="#C0D7E5" height="25">';
}
else 
{
echo '<tr bgcolor="#FFFFCC" height="25" >';
}
 
 
 ?>
  
    <td><?php echo $rows->f_name;?></td>
    <td><?php echo $rows->task_name;?></td>
    
    
	<td><?php 
	 $status=$rows->status;
	 $assigned=$rows->assigned;
	if ($status==1 && $assigned==1)
	{
	
	$stat='<font color="#000"><b>Not Started !!</b></font>';
	
	}
	elseif ($status==2)
	{
	
	$stat='<font color="#993300"><b>Domant</b></font>';
	}
	
	elseif ($status==3)
	{
	
	$stat='<font color="#ff0000"><b>Complete</b></font>';
	}
	
	elseif ($status==4)
	{
	
	$stat='<font color="#0033FF"><b>In Progress....</b></font>';
	}
	echo $stat;
	?></td>
	<td><?php echo $date_assignedx=$rows->date_assigned;?></td>
	 <td>
	 
<strong>	 
	 <?php
 $assigned=$rows->assigned;

if ($assigned==1 && $status==1)
{

//echo "ndio";
$curr_timex=date( 'Y-m-d H:i:s', time());
$date_assignedx=$rows->date_assigned;
$curr_time2x= strtotime($date_assignedx);
$final_time2x= strtotime($curr_timex);

$durationrrr2x = $final_time2x - $curr_time2x;

echo number_format($progress_durx=$durationrrr2x/60,0);





}
else
{
echo " ";

}
	 
	 
	 ?>
	 
	 
</strong>	 
	 
	 </td>
	 
	 
	 <td><?php echo $task_duration=$rows->task_duration;?></td>

    <td width="" align="center">
	
	<?php
$t_id=$rows->task_id;	
$status;


 $curr_time=date( 'Y-m-d H:i:s', time());

 $final_time=$rows->exp_end_time;

$final_time2 = strtotime($final_time);
$curr_time2 = strtotime($curr_time);

$durationrrr2 = $final_time2 - $curr_time2;

$progress_dur=$durationrrr2/60;



	?>

<?php 
$task_id=$rows->task_id;

$queryop = "SELECT * FROM stopped_task where task_id='$task_id' and status='1'";
$resultsop= mysql_query($queryop) or die ("Error $queryop.".mysql_error());
$num_rows=mysql_num_rows($resultsop);

if ($num_rows>0)
{
?>
<span class="blink_me">Stopped</span>
<?php
}
else
{

if ($status==4)
{
?>



	
<span style="float:left;">
<span id="timeLeft" style="color:#fff; font-size:12px; background:#000; width:100px;" ></div>
	
	<input id="minutes" type="text" value="<?php echo number_format($progress_dur,0); ?>" readonly style="width:30px; border: none; color:#ff0000; background-color:none; font-size: 12px; font-weight: bold;"> Minutes 
	
	      
	 </span>
	 </span>
<?php 
}
else
{

}


}
?>	 
	 
</td>  
<td align="center">
<?php //echo $task_id; 
$pht=$rows->photos;

if ($pht=='')
{


}
else
{
?>
<a href="photos/<?php echo $pht; ?>"><img src="images/downloadicon.png"></a>
<?php 
}
?>
</td>	
	
<td align="center">
<?php 
if ($status==1 && $assigned==1)
	{
	
	}
	else
	{

?>

<a style="text-decoration:none; color:#ff0000; margin-top:-15px;" rel="facebox" href="view_comments.php?task_id=<?php echo $task_id; ?>"><img src="images/comments.png">
<?php
$querycn = "SELECT * FROM task_comments where task_id='$task_id'";
$resultscn= mysql_query($querycn) or die ("Error $querycn.".mysql_error());


echo "<span style='margin-top:-15px;'>".$num_rows_cn=mysql_num_rows($resultscn)."</span>";
 ?>
</a>
<?php } ?>

</td> 	
		
		
	
  
	
   
    </tr>
  <?php 
  
  }
  
  }
  
  else 
  
  {
  ?>
  
  <tr><td colspan="8" align="center"><font color="#ff0000"><strong>No Results</strong></font></td></tr>
  
  <?php 
  
  
  }
  
  
  ?>
</table>

</table>





</form>

<?php 
}
?>

