function createNominee($empnum)
{
global $db;
$stmt = $db->prepare('SELECT * FROM tblempall WHERE EmpNum = :EmpNum');
$stmt->execute(array('EmpNum' => $empnum));
$stmt->setFetchMode(PDO::FETCH_CLASS, 'User');
if ($result = $stmt->fetch()) {
if ($result->Offline == 'Y') {
// find Shop Mgr
$stmt = $db->prepare('SELECT * FROM tblempall WHERE Shop = :Shop AND JobTitle= :JobTitle');
$stmt->execute(array('Shop' => $result->Shop, 'JobTitle' => 'Shop Mgr'));
if ($mgr = $stmt->fetch(PDO::FETCH_OBJ)) {
$result->shopMEmpNum = $mgr->EmpNum;
$result->shopMFname = $mgr->Fname;
$result->shopMSname = $mgr->Sname;
$result->shopMEaddress = $mgr->Eaddress;
}
}
print_r($result);
if ($result->AppEmpNum == '') {
$result = getApprover($result);
}
$_SESSION['nominee'] = $result;
}
}
$AppEmpNum = getTeamsApprover($list->EmpNum);
$_SESSION['teamnominee']->AppEmpNum = $AppEmpNum->AppEmpNum;
$_SESSION['teamnominee']->full_App_name = $AppEmpNum->Fname . ' ' . $AppEmpNum->Sname;
if (!isset($firstPersonEmpNum)) {
$firstPersonEmpNum = $list;
}
//print_r($AppEmpNum);
//echo "<br><br>";
if ($AppEmpNum->AppEmpNum != '') {
break;
}
}
}
if ($AppEmpNum->AppEmpNum == '') {
//print_r($firstPersonEmpNum);
$approver = getApprover($firstPersonEmpNum);
$AppEmpNum->AppEmpNum = $approver->AppEmpNum;
}
if ($totalTeamMembers > 21) {
$AppEmpNum = getSUApprover();
$_SESSION['teamnominee']->AppEmpNum = $AppEmpNum->AppEmpNum;
$_SESSION['teamnominee']->full_App_name = $AppEmpNum->AppFname;
}
$stmt->bindParam(':ApproverEmpNum', $AppEmpNum->AppEmpNum);
$stmt->bindParam(':Team', getmyTeamName($_SESSION['teamnominee']->teamID));
$stmt->bindParam(':TeamID', $_SESSION['teamnominee']->teamID);
$stmt->bindParam(':littleExtra', $_SESSION['teamnominee']->littleExtra);
$stmt->bindParam(':includeMe', $_SESSION['teamnominee']->includeMe);
$stmt->bindParam(':personalMessage', $_SESSION['teamnominee']->personalMessage);
$stmt->bindParam(':Reason', $_SESSION['teamnominee']->Reason);
$stmt->bindParam(':BeliefID', $_SESSION['teamnominee']->BeliefID);
