/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex()
{
// display carousel widget with last rates
$subquery = Rate::find()->select('ratedate as lastdate')->orderBy('ratedate DESC')->limit(1);
$models = Rate::find()->innerJoin(['u' => $subquery], 'u.lastdate = ratedate')->all();
$dates = Rate::getDatesForLiderTab('day');
$leaders = Rate::getLidersBetweenSelectedDates($dates[0], $dates[1]);
$loosers = Rate::getLidersBetweenSelectedDates($dates[0], $dates[1], false);
return $this->render('index', compact('models', 'leaders', 'loosers'));
}
private function getRatesForPeriod($quoteid, $startdate, $enddate)
{
$models = Rate::find()->select(['rate.ratedate', 'rate.maximum', 'rate.minimum', 'rate.openrate', 'rate.closerate'])->join('INNER JOIN', 'quote', 'quote.qid = rate.quoteid')->where('quote.qid = :qid', [':qid' => $quoteid])->andWhere(['between', 'rate.ratedate', $startdate, $enddate])->all();
$result = array();
if (!empty($models)) {
foreach ($models as $model) {
$result[] = $model->toArray();
}
}
return $result;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Rate::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['rateid' => $this->rateid, 'quoteid' => $this->quoteid, 'openrate' => $this->openrate, 'closerate' => $this->closerate, 'ratedate' => $this->ratedate, 'minimum' => $this->minimum, 'maximum' => $this->maximum, 'lastdeal' => $this->lastdeal, 'deals' => $this->deals, 'wa' => $this->wa, 'dayval' => $this->dayval, 'dayvol' => $this->dayvol, 'ActiveFlag' => $this->ActiveFlag, 'ChangeDate' => $this->ChangeDate]);
return $dataProvider;
}
