{
float: left;
position: relative;
left: 3%;
}
.floatRight
{
float: right;
position: relative;
width:500px;
}
</style>
<br />
<h1 class="center">Update Training</h1><br />
<h3 class="center">Training Period: <?php
echo date("F j, Y", strtotime(getTeamingPeriod('start', $area))) . ' ' . ' - ' . date("F j, Y", strtotime(getTeamingPeriod('end', $area)));
?>
</h3>
<br /><br />
<div class='floatLeft'>
<h2>Update Current Training Team</h2>
<form name='teaming' id='teaming' method='post' >
<?php
printTeamForUpdate($netID, $area);
?>
<input type='submit' value="Submit Update" name='submit' id='submit' />
</form>
</div>
<div class='floatRight'>
<h2>Training Stats for <?php
echo nameByNetId($netID);
function updateEmployeeTeamingInfo($empNetID, $empTeamID, $empArea)
{
global $db;
if (isEmployeeInTheTeamingTable($empNetID)) {
// Update teaming
try {
$updateQuery = $db->prepare("UPDATE teaming SET `supervisorID` = :leadId WHERE netID=:netId");
$updateQuery->execute(array(':leadId' => teamLeadIdByTeamId($empTeamID), ':netId' => $empNetID));
} catch (PDOException $e) {
exit("error in query");
}
} else {
//Insert into teaming
try {
$insertQuery = $db->prepare("INSERT INTO teaming (netID,supervisorID,startDate,endDate,teamed,timely,area,guid) VALUES (:netId, :leadId, :start, :end,'0','0',:area,:guid)");
$insertQuery->execute(array(':netId' => $empNetID, ':leadId' => teamLeadIdByTeamId($empTeamID), ':start' => getTeamingPeriod('start', $empArea), ':end' => getTeamingPeriod('end', $empArea), ':area' => $empArea, ':guid' => newGuid()));
} catch (PDOException $e) {
exit("error in query");
}
}
}
