PHP Report::whereIn方法代码示例

 /**
  * Display a listing of reports
  *
  * @return Response
  */
 public function index()
 {
     if (!Report::canList()) {
         return $this->_access_denied();
     }
     if (Request::ajax()) {
         $users_under_me = Auth::user()->getAuthorizedUserids(Report::$show_authorize_flag);
         if (empty($users_under_me)) {
             $reports = Report::whereNotNull('reports.created_at');
         } else {
             $reports = Report::whereIn('reports.user_id', $users_under_me);
         }
         $reports = $reports->select(['reports.id', 'reports.name', 'reports.model', 'reports.path', 'reports.is_json', 'reports.id as actions']);
         return Datatables::of($reports)->edit_column('actions', function ($report) {
             $actions = [];
             $actions[] = $report->canShow() ? link_to_action('ReportsController@show', 'Show', $report->id, ['class' => 'btn btn-xs btn-primary']) : '';
             $actions[] = $report->canUpdate() ? link_to_action('ReportsController@edit', 'Update', $report->id, ['class' => 'btn btn-xs btn-default']) : '';
             $actions[] = $report->canDelete() ? Former::open(action('ReportsController@destroy', $report->id))->class('form-inline') . Former::hidden('_method', 'DELETE') . '<button type="button" class="btn btn-xs btn-danger confirm-delete">Delete</button>' . Former::close() : '';
             return implode(' ', $actions);
         })->remove_column('id')->make();
         return Datatables::of($reports)->make();
     }
     Asset::push('js', 'datatables');
     return View::make('reports.index');
 }

                $gt++;
                break;
            }
            if (count($players[0]->opponents($tournament)->where('players.id', '=', $players[$pt])->get()) == 0) {
                $games[$gt]->players = array($players[0], $players[$pt]);
                $gt++;
                unset($players[$pt]);
                unset($players[0]);
                $players = array_values($players);
                $pt = 0;
                continue;
            }
        }
        return $games;
    }
}
Round::deleting(function ($round) {
    $games = $round->games()->get();
    $gamesToDelete = array();
    foreach ($games as $game) {
        $gamesToDelete[] = $game->id;
    }
    Report::whereIn('game', $gamesToDelete)->delete();
    Game::whereIn('id', $gamesToDelete)->delete();
    $tournament = $round->tournament();
    $players = $tournament->players()->get();
    foreach ($players as $player) {
        $player->updateScore($tournament);
        $player->updateSos($tournament);
    }
});

 /**
  * @return \Illuminate\View\View
  * @throws Exception
  *
  */
 public function rawWeatherTable()
 {
     $title = 'Raw weather';
     $fields = Config::get('marauder.rawWeatherEntries');
     // all of the users log entries:
     $get = ['reports.id', 'reports.time'];
     /*
      * get the users cities:
      */
     $structures = Auth::user()->structures()->get();
     $cities = [];
     /** @var Structure $structure */
     foreach ($structures as $structure) {
         $city = City::findCity($structure->postal_code, $structure->country_code);
         $cities[] = $city->id;
     }
     $cities = array_unique($cities);
     $query = Report::whereIn('reports.city_id', $cities)->take(Config::get('marauder.weatherTableLimit'))->orderBy('time', 'DESC')->orderBy('reports.city_id', 'ASC');
     foreach ($fields as $field) {
         $query->withReportValue($field);
         $fieldName = str_replace('.', '_', $field);
         $get[] = $fieldName . '.value as ' . $fieldName;
     }
     $result = $query->get($get);
     if ($result->count() > 0) {
         $result = $result->toArray();
     }
     foreach ($result as $key => $entry) {
         foreach ($entry as $name => $value) {
             $result[$key][$name] = Format::format($name, $value);
         }
     }
     $ignore = [];
     return View::make('raw.table', compact('result', 'title', 'ignore'));
 }