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);