Example #1
0
    $html .= "<div class='passengers block'>";
    while ($passenger = mysql_fetch_array($carpoolDetails)) {
        //$passengers[] = $passenger['memberID'];
        if ($passenger['memberID'] !== $driver) {
            //$shouldAttend='';
            //$isConfirmed ='';
            //$passengerSpots=0;
            $emails .= ', ' . prefFullNameFromEmail($passenger['memberID']) . ' <' . $passenger['memberID'] . '>';
            if (shouldAttend($passenger['memberID'], $eventNo)) {
                $shouldAttend = '<span class="label label-info">should</span>';
                $isConfirmed = isConfirmed($passenger['memberID'], $eventNo) == true ? '<span class="label label-info">confirmed</span>' : '<span class="label label-warning">unconfirmed</span>';
            } else {
                $shouldAttend = '<span class="label label-important">shouldn\'t</span>';
                $isConfirmed = '<span class="label label-important">not attending</span>';
            }
            $passengerSpots = passengerSpots($passenger['memberID']) !== "0" ? "<span class='badge badge-info'>" . passengerSpots($passenger['memberID']) . "</span>" : '';
            $livesAt = "<span class='label'>" . livesAt($passenger['memberID']) . "</span>";
            $phoneNumber = "<a href='tel:" . phoneNumber($passenger['memberID']) . "'>" . phoneNumber($passenger['memberID']) . "</a>";
            $html .= "<div class='person' id='" . $passenger['memberID'] . "'><table>\n\t\t\t<tr>\n\t\t\t\t<td class='carpoolLives'>" . $livesAt . "</td>\n\t\t\t\t<td class='carpoolName'><a href='profile:" . $passenger['memberID'] . "'>" . prefFullNameFromEmail($passenger['memberID']) . "</a></td>\n\t\t\t\t<td class='carpoolSpots'>" . $passengerSpots . "</td>\n\t\t\t\t<td class='carpoolShould'>" . $phoneNumber . "</td>\n\t\t\t\t<td class='carpoolConfirmed'>" . $isConfirmed . "</td>\n\t\t\t\t</tr>\n\t\t\t</table></div>";
        }
    }
    $sql = "select `name` from `event` where `eventNo` = {$eventNo}";
    $event = mysql_fetch_array(mysql_query($sql));
    $html .= '</div>';
    //end passengers div
    $html .= '<div style="display: inline-block; width: 100%"><a href="mailto:' . rawurlencode($emails) . '?subject=' . rawurlencode('Carpool for ' . $event['name']) . '" class="btn pull-right"><i class="icon-envelope"></i>&nbsp;Mail this carpool</a></div>';
    $html .= "</div>";
    //end carpool div
}
$html .= "</div>";
echo $html;
<?php

require_once 'functions.php';
$eventNo = $_POST['eventNo'];
$needRides = array();
$sql = "\n\tSELECT email,shouldAttend,attends.confirmed \n\tFROM member,attends\n\tWHERE\n\t\temail NOT IN (\n\t\t\tSELECT email FROM carpool, ridesin LEFT JOIN member \n\t\t\t\tON email=memberID \n\t\t\tWHERE carpool.carpoolID=ridesin.carpoolID AND carpool.eventNo={$eventNo})\n\t\tAND exists (select * from `activeSemester` where `activeSemester`.`semester` = '{$SEMESTER}' and `activeSemester`.`member` = `member`.`email`)\n\t\tAND attends.eventNo={$eventNo}\n\t\tAND attends.memberID=email\n\tORDER BY shouldAttend DESC, lastName ASC, firstName ASC";
$results = mysql_query($sql);
while ($personInNeedOfRide = mysql_fetch_array($results)) {
    $email = $personInNeedOfRide['email'];
    $shouldAttend = $personInNeedOfRide['shouldAttend'];
    $confirmed = $personInNeedOfRide['confirmed'];
    $shouldAttendHTML = $shouldAttend == '1' ? '<span class="label label-info">should</span>' : '<span class="label label-important">shouldn\'t</span>';
    $confirmedHTML = $confirmed == '1' ? '<span class="label label-info">confirmed</span>' : '<span class="label label-warning">unconfirmed</span>';
    $passengerSpots = passengerSpots($email) !== "0" ? "<span class='badge badge-info'>" . passengerSpots($email) . "</span>" : "";
    $livesAt = "<span class='label'>" . livesAt($email) . "</span>";
    echo "<div class='person' id='" . $email . "'><table>\n\t\t<tr>\n\t\t\t<td>{$livesAt}</td>\n\t\t\t<td>" . prefFullNameFromEmail($email) . "</td>\n\t\t\t<td class='passengerSpots'>{$passengerSpots}</td>\n\t\t\t<td>{$shouldAttendHTML}</td>\n\t\t\t<td>{$confirmedHTML}</td>\n\t\t</tr>\n\t</table></div>";
}