$today_id = date("y-m-d");
$two_weeks_id = date("y-m-d", $two_weeks);
connect();
$vacancy_query = "SELECT id,slots,persons FROM dbCrews " . "WHERE id > '" . $today_id . "' AND id <= '" . $two_weeks_id . "' ORDER BY id;";
$vacancy_list = mysql_query($vacancy_query);
if (!$vacancy_list) {
echo mysql_error();
}
//upcoming vacancies
if (mysql_num_rows($vacancy_list) > 0) {
echo '<div class="vacancyBox">';
echo '<p><strong>Upcoming Vacancies (next two weeks):</strong><ul>';
while ($thisRow = mysql_fetch_array($vacancy_list, MYSQL_ASSOC)) {
$vacancies = $thisRow['slots'] - sizeof(explode(',', $thisRow['persons']));
if ($vacancies > 0) {
echo '<li type="circle"><a href="' . $path . 'editCrew.php?id=' . $thisRow['id'] . '">' . get_crew_name_from_id($thisRow['id']) . '</a></li>';
}
}
echo '</ul></p></div><br>';
}
// active volunteers who haven't worked recently
$everyone = getall_names("active", "volunteer");
if ($everyone && mysql_num_rows($everyone) > 0) {
//active volunteers who haven't worked for the last two months
$two_months_ago = $today - 60 * 86400;
echo '<div class="inactiveBox">';
echo '<p><strong>Unscheduled active house volunteers who haven\'t worked during the last two months:</strong>';
echo '<table class="searchResults"><tr><td class="searchResults"><u>Name</u></td><td class="searchResults"><u>Date Last Worked</u></td></tr>';
while ($thisRow = mysql_fetch_array($everyone, MYSQL_ASSOC)) {
if (!preg_match("/manager/", $thisRow['type'])) {
$crews = selectScheduled_dbCrews($thisRow['id']);
$crew = select_dbCrews($crewid);
} else {
if (process_add_slot($_POST, $crew, $group)) {
$crew = select_dbCrews($crewid);
} else {
if (process_clear_crew($_POST, $crew, $group)) {
$crew = select_dbCrews($crewid);
} else {
if (process_ignore_slot($_POST, $crew, $group)) {
$crew = select_dbCrews($crewid);
}
}
}
}
$persons = $crew->get_persons();
echo "<br><br><table align=\"center\" border=\"1px\"><tr><td align=\"center\" colspan=\"3\"><b>" . get_crew_name_from_id($crewid) . "</b></td><td></td></tr>";
echo "<tr><td valign=\"top\"><br> " . do_slot_num($crew->get_slots()) . "</td><td>";
if ($_SESSION['access_level'] == 2) {
echo "<form method=\"POST\" style=\"margin-bottom:0;\">\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"_submit_add_slot\" value=\"1\"><br>\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"submit\" value=\"Add Slot\"\n\t\t\t\t\t\t\t\t\t\t\tname=\"submit\" >\n\t\t\t\t\t\t\t\t\t\t\t</form></td><td><br>";
echo "<form method=\"POST\" style=\"margin-bottom:0;\">\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"_submit_clear_crew\" value=\"1\">\n\t\t\t\t\t\t\t\t\t\t\t<input type=\"submit\" value=\"Clear Entire Crew\"\n\t\t\t\t\t\t\t\t\t\t\tname=\"submit\" >\n\t\t\t\t\t\t\t\t\t\t\t</form></td>";
} else {
echo "</td><td></td>";
}
echo "<td></td></tr>";
echo display_filled_slots($persons);
echo display_vacant_slots($crew->num_vacancies());
echo "</td></tr></table>";
echo "<p align=\"center\"><a href=\"calendar.php?month=" . substr($crewid, 0, 5) . "&group=" . $group . "&edit=true" . "\">\n\t\t\t\t\t\t\t\t\tBack to Calendar</a>";
}
}
}
