Exemplo n.º 1
0
<?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">
Exemplo n.º 2
0
<?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);