/**
* Рассчитать кол-во дней между двумя датами
*/
public function testDateDiff()
{
$testingPlan = array('2009-01-01---2009-01-01' => 0, '2009-01-01 00:00:00---2009-01-01 23:59:59' => 0, '2009-01-02---2009-01-01' => 1, '2009-01-02 10:00:00---2009-01-01' => 1, '2008-12-31---2009-01-02' => -2);
foreach ($testingPlan as $dates => $expectedResult) {
list($startDate, $endDate) = explode('---', $dates);
$this->assertEquals($expectedResult, myBaseTable::dateDiff($startDate, $endDate), "Expected diff `{$expectedResult}` for dates {$startDate} - {$endDate}");
}
$this->assertSame(myBaseTable::dateDiff('2009-01-05', '2009-01-01'), myBaseTable::dateDiff('2009-01-05', '2009-01-01'));
}
/**
* Добавление сортировки по дате начала
*
* @param string $alias
* @return Doctrine_Query
*/
public function createQuery($alias = 'a')
{
return parent::createQuery($alias)->orderBy($alias . '.created_at DESC');
}
