<?php include '../inc/config.php'; unset($_SESSION['alreadydone']); $myaward = getTeamNomination($_GET['id']); ?> <div id="alertTitle" class="title"> Approve/Decline Team Nomination </div> <div id="alertBody" class="alertBody"> <div class="tableRow"> <div class="textLeft"> <b>Award:</b> <?php echo cleanWorkAward($myaward->amount); ?> <i class="icon-icons_i clickAble blueText" data-type="subPopup"></i> </div> </div> <div class="tableRow"> <div class="textLeft"> <b>Reason provided by the Nominator:</b> <?php echo $myaward->Reason; ?> </div> </div> <div id="teamMembers" class="greyBox"> <div class="row mCustomScrollbar height120 scrollBar" data-mcs-theme="dark-2"> <div class="row withSidePadding">
<?php include '../inc/config.php'; // upload data and create emails //if($_SESSION['alreadydone']!='yes'){ // get award details $ID = $_POST['ID']; $award = getTeamNomination($ID); print_r($award); echo '<br><br>'; if ($_POST['dReason'] == '') { // update award if ($_SESSION['user']->EmpNum != $award->ApproverEmpNum) { $stmt = $db->prepare("UPDATE tblnominations_team SET AprDate = NOW(), AprStatus = :AprStatus, AprSUEmpNum = :AprSUEmpNum WHERE ID = :ID"); $stmt->bindParam(':AprSUEmpNum', $_SESSION['user']->EmpNum); } else { $stmt = $db->prepare("UPDATE tblnominations_team SET AprDate = NOW(), AprStatus = :AprStatus WHERE ID = :ID"); } $stmt->bindParam(':AprStatus', $a = 1); $stmt->bindParam(':ID', $ID); $stmt->execute(); // loop to add awards to each person $TeamMembers = $award->teamNominees(); print_r($TeamMembers); foreach ($TeamMembers as $list) { $stmt = $db->prepare("INSERT INTO tblnominations(\n\t\t\t\t\t\t\t\tawardType, NominatorEmpNum, NominatedEmpNum, nomination_teamID, Volunteer, personalMessage, ApproverEmpNum,\n\t\t\t\t\t\t\t\tlittleExtra, amount, NomDate, AprDate, AprStatus, AwardClaimed, DateClaimed) \n\t\t\t\t\t\t\t\tVALUES (:awardType, :NominatorEmpNum, :NominatedEmpNum, :nomination_teamID, :Volunteer, :personalMessage, :ApproverEmpNum, \n\t\t\t\t\t\t\t\t:littleExtra, :amount, :NomDate, NOW(), :AprStatus, :AwardClaimed, NOW())"); $stmt->bindParam(':awardType', $a = 2); $stmt->bindParam(':NominatorEmpNum', $award->NominatorEmpNum); $stmt->bindParam(':NominatedEmpNum', $list->EmpNum); $stmt->bindParam(':nomination_teamID', $award->ID); $stmt->bindParam(':Volunteer', $award->Volunteer);