public function testQueryCount() { $someDate = new QDateTime(); $someDate->setDate(2006, 1, 1); $intItemCount = Milestone::QueryCount(QQ::GreaterThan(QQN::Milestone()->Project->StartDate, $someDate), QQ::Distinct()); $this->assertEqual($intItemCount, 3); $intItemCount2 = Milestone::QueryCount(QQ::GreaterThan(QQN::Milestone()->Project->StartDate, $someDate), QQ::Clause(QQ::Distinct(), QQ::Distinct())); $this->assertEqual($intItemCount2, 3); }
public function testSetProperties() { $obj1 = new QDateTime(); $obj1->setDate(2002, 3, 15); $obj2 = new QDateTime("2002-03-15"); $obj3 = new QDateTime("2002-03-15 13:15"); $obj4 = new QDateTime("2002-03-16"); $this->assertTrue($obj1->IsEqualTo($obj2)); $this->assertTrue($obj1->IsEqualTo($obj3)); // dates are the same! $this->assertFalse($obj3->IsEqualTo($obj4)); // dates are different! }
public function testQueryArray() { $someDate = new QDateTime(); $someDate->setDate(2006, 1, 1); $objItems = Milestone::QueryArray(QQ::GreaterThan(QQN::Milestone()->Project->StartDate, $someDate), QQ::OrderBy(QQN::Milestone()->Project->Name)); $this->assertEqual(sizeof($objItems), 3); $this->assertEqual($objItems[0]->Name, "Milestone F"); $this->assertEqual($objItems[0]->Project->Name, "Blueman Industrial Site Architecture"); $this->assertEqual($objItems[1]->Name, "Milestone D"); $this->assertEqual($objItems[1]->Project->Name, "State College HR System"); $this->assertEqual($objItems[2]->Name, "Milestone E"); $this->assertEqual($objItems[2]->Project->Name, "State College HR System"); }
public function ParsePostData() { if (array_key_exists($this->strControlId . '_lstMonth', $_POST) || array_key_exists($this->strControlId . '_lstHour', $_POST)) { $dttNewDateTime = new QDateTime(); // Update Date Component switch ($this->strDateTimePickerType) { case QDateTimePickerType::Date: case QDateTimePickerType::DateTime: case QDateTimePickerType::DateTimeSeconds: $strKey = $this->strControlId . '_lstMonth'; if (array_key_exists($strKey, $_POST)) { $intMonth = $_POST[$strKey]; } else { $intMonth = null; } $strKey = $this->strControlId . '_lstDay'; if (array_key_exists($strKey, $_POST)) { $intDay = $_POST[$strKey]; } else { $intDay = null; } $strKey = $this->strControlId . '_lstYear'; if (array_key_exists($strKey, $_POST)) { $intYear = $_POST[$strKey]; } else { $intYear = null; } $this->intSelectedMonth = $intMonth; $this->intSelectedDay = $intDay; $this->intSelectedYear = $intYear; if (strlen($intYear) && strlen($intMonth) && strlen($intDay)) { $dttNewDateTime->setDate($intYear, $intMonth, $intDay); } else { $dttNewDateTime->Year = null; } break; } // Update Time Component switch ($this->strDateTimePickerType) { case QDateTimePickerType::Time: case QDateTimePickerType::TimeSeconds: case QDateTimePickerType::DateTime: case QDateTimePickerType::DateTimeSeconds: $strKey = $this->strControlId . '_lstHour'; if (array_key_exists($strKey, $_POST)) { $intHour = $_POST[$strKey]; if (strlen($intHour)) { $intHour = $_POST[$this->strControlId . '_lstHour']; $intMinute = $_POST[$this->strControlId . '_lstMinute']; $intSecond = 0; if ($this->strDateTimePickerType == QDateTimePickerType::TimeSeconds || $this->strDateTimePickerType == QDateTimePickerType::DateTimeSeconds) { $intSecond = $_POST[$this->strControlId . '_lstSecond']; } if (strlen($intHour) && strlen($intMinute) && strlen($intSecond)) { $dttNewDateTime->setTime($intHour, $intMinute, $intSecond); } else { $dttNewDateTime->Hour = null; } } } break; } // Update local intTimestamp $this->dttDateTime = $dttNewDateTime; } }
public function testSetProperties() { $obj1 = new QDateTime(); $obj1->setDate(2002, 3, 15); $this->assertTrue($obj1->IsTimeNull(), "Setting only a date after null constructor keeps time null"); $obj2 = new QDateTime("2002-03-15"); $obj3 = new QDateTime("2002-03-15 13:15"); $obj4 = new QDateTime("2002-03-16"); $this->assertTrue($obj1->IsEqualTo($obj2)); $this->assertTrue($obj1->IsEqualTo($obj3)); // dates are the same! $this->assertFalse($obj3->IsEqualTo($obj4)); // dates are different! $obj5 = new QDateTime('13:15:02', null, QDateTime::TimeOnlyType); $this->assertTrue($obj5->IsDateNull(), "Setting only a date after null constructor keeps time null"); $obj6 = new QDateTime('2002-03-15 13:15:02'); $obj1->SetTime($obj5); $this->assertFalse($obj1->IsTimeNull(), "Setting a time with object results in a change in null time status"); $this->assertTrue($obj1->IsEqualTo($obj6), "SetTime correctly combines date only and time only values"); }