public function actionIndex()
{
$this->layout = "column2";
$yearSelectRange = array();
$yearSelectRange = YearRangeCollection::getCollection();
$dateFrom = date("Y-m-d H:i:s", strtotime(sprintf("first day of October %s", date("Y"))));
$dateTo = date("Y-m-d H:i:s", strtotime(sprintf("last day of September %s", intval(date("Y")) + 1)));
if (Yii::app()->request->isPostRequest) {
$searchRange = $_POST['searchRange'];
$dateFrom = date("Y-m-d H:i:s", strtotime(sprintf("first day of October %s", $searchRange)));
$dateTo = date("Y-m-d H:i:s", strtotime(sprintf("last day of September %s", intval($searchRange) + 1)));
}
$criteria = new CDbCriteria();
$criteria->addCondition("DATE(term_from) between :dateFrom and :dateTo");
$criteria->params = array(":dateFrom" => $dateFrom, ":dateTo" => $dateTo);
$barangayOfficialsModels = BarangayOfficials::model()->findAll($criteria);
$this->render('index', compact('yearSelectRange', 'dateFrom', 'dateTo', 'barangayOfficialsModels'));
}
/**
* Test if collection returned is correct
* @covers YearRangeCollection::getCollection()
*/
public function testGetCollection()
{
$yearRangeCollection = YearRangeCollection::getCollection();
$this->assertArrayHasKey('2015', $yearRangeCollection, 'Assert that there is 2015 in the array collection');
}