$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>"; } } }