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')]);
 }
示例#2
0
 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');
 }