public function actionGetList($limit = 1000, $win_min = null, $live = false) { $forks = Fork::model()->with(['event', 'f1_event', 'f2_event', 'f3_event'])->findAll(['condition' => implode(' and ', array_filter(['win is not null', 'event.visible = true', $win_min !== null ? 'win > ' . $win_min : null, $live ? '(event.islive = true)' : null])), 'order' => 'win desc', 'limit' => $limit]); $list = []; foreach ($forks as $fork) { $item = $fork->attributes; $item['event'] = $fork->event; $item['events'] = $fork->eventsByField; $list[] = $item; } $this->renderJson(['list' => $list, 'events_updated' => Yii::app()->settings->get('events_updated')]); }
public function actionDeleteOld() { Event::model()->deleteAll('date < date_sub(utc_timestamp(), interval 4 hour)'); Fork::model()->deleteAll('(select id from event where event.id = fork.event_id) is null'); }