function listTestDates($logon, $db, $level, $Managers)
{
$isManager = 0;
$empsSupervised = 0;
$x = 0;
$leftMargin = $level * 25;
$row_count = 0;
$query = "SELECT * FROM [APACS Sandbox].[dbo].[00securitytestTEMP] where suplogon = '" . $logon . "'";
// echo $query;
$qresult = sqlsrv_query($db, $query, array(), array("Scrollable" => "buffered"));
if ($qresult === False) {
$db->exitWithError('query fail');
}
if (!sqlsrv_has_rows($qresult)) {
// no rows not a manager maybe manger livel -1 ????
//echo "supervises no one incementer = " . $x;
//$isManager=0;
} else {
//$isManager=1;
// supervisor add a level
$level++;
$row_count = sqlsrv_num_rows($qresult);
}
while ($row = sqlsrv_fetch_array($qresult)) {
$date = $row['testdate'];
$formattedDate = $date->format('m-d-Y');
$x++;
if ($x == 1) {
$Managers[$row['suplogon']] = $row['supervisor'];
?>
<div id="employeePod" style="margin-left:<?php
echo $leftMargin;
?>
px;" >
<?php
//echo "Supervises ". $row_count . " people";
include 'heading.inc';
}
?>
<div id=dataline">
<div id="Emp"><?php
echo $row['name'];
?>
<br></div>
<div id="Email"><?php
echo $row['email'];
?>
</div>
<div id="Date"><?php
echo $formattedDate;
?>
</div>
<div id="Attempts"><?php
echo $row['attempts'];
?>
</div>
<div id="OldMan"><?php
echo $row['supervisor'];
?>
</div>
<div id="ManEmail"><?php
echo $row['supervisor email'];
?>
</div>
<div id="spacer"> </div>
</div>
<?php
//Check if this employee is a supervior
$mquery = "SELECT * FROM [APACS Sandbox].[dbo].[00securitytestTEMP] where suplogon = '" . $row['logon'] . "'";
// echo $query;
$mqresult = sqlsrv_query($db, $query, array(), array("Scrollable" => "buffered"));
if ($mqresult === False) {
$db->exitWithError('query fail');
}
if (!sqlsrv_has_rows($mqresult)) {
// no rows not a manager maybe manger livel -1 ????
} else {
//$isManager=1;
// supervisor add a level
//$level++;
//$row_count = sqlsrv_num_rows( $mqresult );
list($level, $Managers) = listTestDates($row['logon'], $db, $level, $Managers);
}
// echo " employee listed increnter =" . $x ;
// echo "rowcount = " .$row_count;
//echo "Employee level is " .$level;
if ($row_count == $x) {
//last of level down
$level--;
echo "\t </div>";
}
//$level =listTestDates($row['logon'], $db, $level );
//list($level, $Managers) = listTestDates($row['logon'], $db, $level, $Managers);
// echo $row['name'] . "is Manager" . $isManager;
}
//return $level;
return array($level, $Managers);
}
function listTestDates($logon, $db, $level, $ManagerId)
{
$isManager = 0;
$empsSupervised = 0;
$x = 0;
//$leftMargin=$level * 25;
$row_count = 0;
$query = "SELECT * FROM [APACS Sandbox].[dbo].[00securitytestTEMP] where suplogon = '" . $logon . "'";
//echo $query;
$qresult = sqlsrv_query($db, $query, array(), array("Scrollable" => "buffered"));
if ($qresult === False) {
$db->exitWithError('query fail');
}
if (!sqlsrv_has_rows($qresult)) {
// no rows not a manager maybe manger livel -1 ????
//echo "supervises no one incementer = " . $x;
//$isManager=0;
} else {
//$isManager=1;
// supervisor add a level
$level++;
$row_count = sqlsrv_num_rows($qresult);
}
while ($row = sqlsrv_fetch_array($qresult)) {
$date = $row['testdate'];
$formattedDate = $date->format('m-d-Y');
$x++;
//echo "incrementer =" . $x;
if ($x == 1) {
//$Managers[$row['suplogon']] = $row['supervisor'] ;
//echo "Supervises ". $row_count . " people";
}
//$x++;
//Check if this employee is a supervior
$mquery = "SELECT * FROM [APACS Sandbox].[dbo].[00securitytestTEMP] where suplogon = '" . $row['logon'] . "'";
// echo $query;
$mqresult = sqlsrv_query($db, $mquery, array(), array("Scrollable" => "buffered"));
if ($mqresult === False) {
$db->exitWithError('query fail');
}
if (!sqlsrv_has_rows($mqresult)) {
// no rows not a manager maybe manger livel -1 ????
?>
<li class="dataline"><?php
echo $row['name'];
?>
<?php
echo $row['email'];
?>
<span style=" position:absolute; left:500px;"> Test Date:<?php
echo $formattedDate;
?>
<?php
echo $row['attempts'];
?>
attempts</span>
</li>
<?php
} else {
$ManagerId++;
?>
<li class="dataline">
<input type="checkbox" unchecked id="Manager<?php
echo $ManagerId;
?>
" /> <label for="Manager<?php
echo $ManagerId;
?>
"><?php
echo $row['name'];
?>
<?php
echo $row['email'];
?>
<span style=" position:absolute; left:500px;"> Test Date:<?php
echo $formattedDate;
?>
<?php
echo $row['attempts'];
?>
attempts</span></label>
<ul>
<?php
list($level, $ManagerId) = listTestDates($row['logon'], $db, $level, $ManagerId);
}
//echo " employee listed increnter =" . $x ;
//echo "rowcount = " .$row_count;
//echo "Employee level is " .$level;
if ($row_count == $x) {
//last of level down
$level--;
echo "<li> </li>\t </ul></li>";
}
// echo $row['name'] . "is Manager" . $isManager;
}
//return $level;
return array($level, $ManagerId);
}
function listTestDates($logon, $db, $level, $latestTests, $line)
{
$isManager = 0;
$empsSupervised = 0;
$x = 0;
$leftMargin = $level * 25;
$row_count = 0;
$query = "SELECT * FROM [APACS Sandbox].[dbo].[00securitytestTEMP] where suplogon = '" . $logon . "'";
// echo $query;
$qresult = sqlsrv_query($db, $query, array(), array("Scrollable" => "buffered"));
if ($qresult === False) {
$db->exitWithError('query fail');
}
if (!sqlsrv_has_rows($qresult)) {
// no rows not a manager maybe manger livel -1 ????
//echo "supervises no one incementer = " . $x;
//$isManager=0;
} else {
//$isManager=1;
// supervisor add a level
$level++;
$row_count = sqlsrv_num_rows($qresult);
}
while ($row = sqlsrv_fetch_array($qresult)) {
$date = $row['testdate'];
$formattedDate = $date->format('m-d-Y');
$x++;
if ($x == 1) {
//echo "Supervises ". $row_count . " people";
}
// Fill the Array for excel export
$latestTests[$line]['Employee'] = $row['name'];
$latestTests[$line]['Email'] = $row['email'];
$latestTests[$line]['Date'] = $formattedDate;
$latestTests[$line]['Attempts'] = $row['attempts'];
$latestTests[$line]['supervisor'] = $row['supervisor'];
$latestTests[$line]['supervisorEmail'] = $row['supervisor email'];
$line++;
//Check if this employee is a supervior
$mquery = "SELECT * FROM [APACS Sandbox].[dbo].[00securitytestTEMP] where suplogon = '" . $row['logon'] . "'";
// echo $query;
$mqresult = sqlsrv_query($db, $query, array(), array("Scrollable" => "buffered"));
if ($mqresult === False) {
$db->exitWithError('query fail');
}
if (!sqlsrv_has_rows($mqresult)) {
// no rows not a manager maybe manger livel -1 ????
} else {
// supervisor add a level
//$level++;
//$row_count = sqlsrv_num_rows( $mqresult );
list($level, $latestTests, $line) = listTestDates($row['logon'], $db, $level, $latestTests, $line);
}
// echo " employee listed increnter =" . $x ;
// echo "rowcount = " .$row_count;
//echo "Employee level is " .$level;
if ($row_count == $x) {
//last of level down
$level--;
}
// echo $row['name'] . "is Manager" . $isManager;
}
return array($level, $latestTests, $line);
}
