// team_assignments.php -- Shows WO Assignemnts for entire team.
//
// Created: 01/05/16 DLB
// --------------------------------------------------------------------
require_once "../maindef.php";
$loc = rmabs(__FILE__);
$timer = new timer();
session_start();
log_page();
CheckLogin();
$pagetitle = "Work Order Assignments";
$sql = 'SELECT * FROM UserView WHERE Active=1 ORDER BY LastName, FirstName';
$result = SqlQuery($loc, $sql);
$workers = array();
while ($row = $result->fetch_assoc()) {
if (CheckRawTagList("Worker", $row["Tags"])) {
$workers[] = $row;
}
}
$sql = 'SELECT * FROM AssignmentsView WHERE Closed=0';
$result = SqlQuery($loc, $sql);
$allasignments = array();
while ($row = $result->fetch_assoc()) {
$allasignments[] = $row;
}
$table = array();
foreach ($workers as $w) {
$table[] = BuildRow($w, $allasignments);
}
GenerateHTML:
$stylesheet = array("../css/global.css", "../css/nav.css", "../css/team_assignments.css");
function GetTeamMembers($team, $everybody, $workers = false)
{
$list = array();
$leadlist = array();
$workerlist = array();
$mentorlist = array();
foreach ($everybody as $p) {
if (CheckRawTagList("guest", $p["Tags"])) {
continue;
}
if ($workers) {
if (CheckRawTagList("worker", $p["Tags"]) === false) {
continue;
}
if (CheckRawTagList("mentor", $p["Tags"])) {
continue;
}
}
if ($p["IPT"] == $team) {
$m = $p["FirstName"] . ' ' . $p["LastName"];
if (CheckRawTagList("iptlead", $p["Tags"])) {
$m .= ' - Lead';
$leadlist[] = $m;
} else {
if (CheckRawTagList("mentor", $p["Tags"])) {
$m .= ' - Mentor';
$mentorlist[] = $m;
} else {
$workerlist[] = $m;
}
}
}
}
$list = array_merge($leadlist, $workerlist, $mentorlist);
return $list;
}
