function testShiftModule() { $noonshift = new Shift("08-03-28:1-5", "house", 3, array(), array(), "", ""); $this->assertEqual($noonshift->get_hours(), "1-5"); $this->assertTrue($noonshift->get_id() == "08-03-28:1-5:house"); $this->assertEqual($noonshift->get_yy_mm_dd(), "08-03-28"); // Test new function for resetting shift's start/end time $this->assertTrue($noonshift->get_start_time() == 13); $this->assertEqual($noonshift->get_end_time(), 17); // Be sure that invalid times are caught. $this->assertFalse($noonshift->set_start_end_time(13, 12)); $this->assertTrue($noonshift->get_id() == "08-03-28:1-5:house"); $this->assertTrue($noonshift->get_hours() == "1-5"); $this->assertTrue($noonshift->num_vacancies() == 3); $this->assertTrue($noonshift->get_day() == "Fri"); $this->assertFalse($noonshift->has_sub_call_list()); $persons = array(); $persons[] = "alex1234567890+alex+jones"; $noonshift->assign_persons($persons); $noonshift->ignore_vacancy(); $persons[] = "malcom1234567890+malcom+jones"; $noonshift->assign_persons($persons); $noonshift->ignore_vacancy(); $persons[] = "nat1234567890+nat+jones"; $noonshift->assign_persons($persons); $noonshift->ignore_vacancy(); $this->assertTrue($noonshift->num_vacancies() == 0); $noonshift->add_vacancy(); $this->assertTrue($noonshift->num_slots() == 4); $noonshift->ignore_vacancy(); $this->assertTrue($noonshift->num_slots() == 3); $noonshift->set_notes("Hello 1-5 shift!"); $this->assertTrue($noonshift->get_notes() == "Hello 1-5 shift!"); echo "testShift complete"; }
function insert_dbShifts(Shift $s) { connect(); $query = 'SELECT * FROM SHIFT WHERE SHIFTID ="' . $s->get_id() . '"'; error_log('in insert_dbShifts, query is ' . $query); $result = mysql_query($query); if (mysql_num_rows($result) != 0) { delete_dbShifts($s); connect(); } $query = "INSERT INTO SHIFT VALUES ('" . $s->get_id() . "','" . $s->get_date() . "','" . $s->get_start_time() . "','" . $s->get_end_time() . "','" . $s->get_venue() . "','" . $s->num_vacancies() . "','" . implode("*", $s->get_persons()) . "','" . implode("*", $s->get_removed_persons()) . "','" . $s->get_notes() . "');"; error_log('in insert_dbShifts, query is ' . $query); $result = mysql_query($query); if (!$result) { echo "unable to insert into SHIFT " . $s->get_id() . mysql_error(); mysql_close(); return false; } mysql_close(); return true; }