echo '<div class="vacancyBox">';
echo '<p><strong>Upcoming Vacancies:</strong><ul>';
while ($thisRow = mysql_fetch_array($vacancy_list, MYSQL_ASSOC)) {
$shift_date = mktime(0, 0, 0, substr($thisRow['SHIFTID'], 0, 2), substr($thisRow['SHIFTID'], 3, 2), substr($thisRow['SHIFTID'], 6, 2));
if ($shift_date > $today && $shift_date < $two_weeks) {
echo '<li type="circle"><a href="' . $path . 'editShift.php?shift=' . $thisRow['SHIFTID'] . '">' . get_shift_name_from_id($thisRow['SHIFTID']) . '</a></li>';
}
}
echo '</ul></p></div><br>';
}
//active applicants
// connect();
//Checks all of the volunteers to see if they are within 7 days old, if so add them to $array_New_Volunteers
$one_Week = 7;
$array_New_Volunteers;
$volunteers_within_week = getall_persons();
foreach ($volunteers_within_week as $temp_Week_Volunteer) {
$daysAsVolunteer = check_Days_As_Volunteer($temp_Week_Volunteer->get_date_added());
if ($daysAsVolunteer <= $one_Week) {
#array_push($array_New_Volunteers, $temp_Week_Volunteer);
$array_New_Volunteers[] = $temp_Week_Volunteer;
}
}
//If $array_New_Volunteers has any new volunteers it will display their first and last name, else it will say there are no new volunteers.
echo '<div class="applicantsBox"><p><strong>New Volunteers (within a week):</strong><ul>';
if (empty($array_New_Volunteers)) {
echo 'There are no new volunteers within the past week.';
} else {
//Old way of displaying applicants
/* $applicants_tab = getall_applicants();
$numLines = 0;
include 'header.php';
?>
<div id="content">
<!-- your main page data goes here. This is the place to enter content -->
<p><strong>View Persons in the Database</strong><br />
To find a specific person, <a href="searchPeople.php">search the database</a>!</p>
<?php
if ($_SESSION['access_level'] < 1) {
//you can only edit your own entry
echo '<p>You do not have sufficient permissions to view all persons in the database. You can <a href="searchPeople.php">search</a> or you can ';
echo '<a href="personEdit.php?id=' . $_SESSION['_id'] . '">edit</a> your own profile.</p>';
} else {
//grab stuff from the db
include_once 'database/dbPersons.php';
include_once 'domain/Person.php';
$allPersons = getall_persons();
//the beginnings of not listing all people at once.
$i = 0;
$num_results = $_GET['num_results'];
if (!$num_results) {
$num_results = 25;
$page_num = 0;
} else {
$page_num = $_GET['page_num'];
}
$min_num = $num_results * $page_num;
$max_num = $num_results * ($page_num + 1);
if (sizeof($allPersons) <= $max_num) {
$max_num = sizeof($allPersons);
}
echo "Viewing results " . ($min_num + 1) . "-" . $max_num . ". Showing ";
*/
?>
<html>
<title>
Database Sandbox Initialization
</title>
<body>
<?php
include_once dirname(__FILE__) . '/dbZipCodes.php';
include_once dirname(__FILE__) . '/dbPersons.php';
create_dbZipCodes();
/* now add counties to the address of all Maine persons in the database
*
*/
$every_person = getall_persons();
$allpersons = sizeof($every_person);
$mainepersons = $countiesadded = 0;
foreach ($every_person as $person) {
if ($person->get_state() == "ME") {
$mainepersons += 1;
$countydata = false;
if ($person->get_zip() != "") {
$countydata = retrieve_dbZipCodes($person->get_zip(), "");
} else {
if (!$countydata) {
$countydata = retrieve_dbZipCodes("", $person->get_city());
}
}
if ($countydata) {
$person->set_county($countydata[3]);