function testdbWeeksModule()
{
//Create two weeks and add them to the database
$days1 = array();
for ($i = 9; $i < 16; $i++) {
$days1[] = new RMHDate(date('y-m-d', mktime(0, 0, 0, 2, $i, 2015)), "house", array(), "");
}
$days2 = array();
for ($i = 16; $i < 23; $i++) {
$days2[] = new RMHDate(date('y-m-d', mktime(0, 0, 0, 2, $i, 2015)), "fam", array(), "");
}
$w1 = new Week($days1, "house", "archived");
$w2 = new Week($days2, "fam", "unpublished");
$this->assertTrue(insert_dbWeeks($w1));
$this->assertTrue(insert_dbWeeks($w2));
//retrieve the first Week and check its fields
$w = get_dbWeeks("02-09-15:house");
$this->assertTrue($w !== false);
$this->assertTrue($w->get_status() == "archived");
$this->assertTrue($w->get_venue() == "house");
$a = get_all_dbWeeks("house");
$this->assertEqual($a[0], $w1);
//update the second Week by a change of status
// $w2 = new Week($days2,"fam","published");
// $this->assertTrue(update_dbWeeks($w2));
// $this->assertEqual(get_dbWeeks($w2->get_id())->get_status(),"published");
//Remove the Weeks from the database
$this->assertTrue(delete_dbWeeks($w1));
$this->assertTrue(delete_dbWeeks($w2));
echo "testdbWeeks complete";
}
function remove_week($id)
{
$week = get_dbWeeks($id);
if ($week) {
if ($week->get_status() == "unpublished" || $week->get_status() == "archived") {
delete_dbWeeks($week);
add_log_entry(sprintf('<a href="personEdit.php?id=%s">%s %s</a> removed the week of <a href="calendar.php?id=%s&edit=true">%s</a>.', $_SESSION['_id'], $_SESSION['f_name'], $_SESSION['l_name'], $week->get_id(), $week->get_name()));
echo '<p>Week "' . $week->get_name() . '" removed.<br>';
} else {
echo '<p>Week "' . $week->get_name() . ' is published, so it cannot be removed.<br>';
}
}
}
} else {
if ($week->get_status() == "published") {
$week->set_status("unpublished");
}
}
update_dbWeeks($week);
add_log_entry('<a href=\\"personEdit.php?id=' . $_SESSION['_id'] . '\\">' . $_SESSION['f_name'] . ' ' . $_SESSION['l_name'] . '</a> ' . $week->get_status() . ' the week of <a href=\\"calendar.php?id=' . $week->get_id() . '&edit=true\\">' . $week->get_name() . '</a>.');
echo "<p>Week \"" . $week->get_name() . "\" " . $week->get_status() . ".<br>";
include 'addWeek_newweek.inc';
} else {
if (!$firstweek && $_GET['remove'] && $_SESSION['access_level'] >= 2) {
$id = $_GET['remove'];
$week = get_dbWeeks($id);
if ($week) {
if ($week->get_status() == "unpublished" || $week->get_status() == "archived") {
delete_dbWeeks($week);
add_log_entry('<a href=\\"personEdit.php?id=' . $_SESSION['_id'] . '\\">' . $_SESSION['f_name'] . ' ' . $_SESSION['l_name'] . '</a> removed the week of <a href=\\"calendar.php?id=' . $week->get_id() . '&edit=true\\">' . $week->get_name() . '</a>.');
echo "<p>Week \"" . $week->get_name() . "\" removed.<br>";
} else {
echo "<p>Week \"" . $week->get_name() . "\" is published, so it cannot be removed.<br>";
}
}
//include('addWeek_newweek.inc');
//unset($_GET('remove'));
echo "<br> (Back to <a href=\"addWeek.php?venue=" . $venue . "&archive=" . $_GET['archive'] . "\"><b>manage weeks</b></a>)";
} else {
if (!array_key_exists('_submit_check_newweek', $_POST)) {
include 'addWeek_newweek.inc';
} else {
process_form($firstweek, $venue);
include 'addWeek_newweek.inc';
function testget_dates_test()
{
$newWeek = new Week("03-30-14", "Bscah", "Active");
$nd = insert_dbWeeks($newDate);
$id = "03-30-14";
echo 'will test get_dates_test</br>';
$result = get_dates_text($dates);
if ($result != null) {
echo 'select_dbDates failed</br>';
}
$res = delete_dbWeeks($newWeek);
if ($res == null) {
echo 'Delete failed</br>';
}
}
/**
* Updates a week in the db by deleting it and re-inserting it
*
* @param $w Week the week to update
*/
function update_dbWeeks(Week $w)
{
if (delete_dbWeeks($w)) {
return insert_dbWeeks($w);
}
return false;
}
/**
* Updates a week in the db by deleting it and re-inserting it
* @param $w the week to update
*/
function update_dbWeeks($w)
{
if (!$w instanceof Week) {
die("Invalid argument for dbWeeks->replace_week function call");
}
if (delete_dbWeeks($w)) {
return insert_dbWeeks($w);
} else {
return false;
}
}
