PHP Board::where方法代码示例

 /**
  * Tests the board model and depndant views.
  *
  * @return void
  */
 public function testModelAndViews()
 {
     // Get a board.
     $boards = Board::take(1)->get();
     // Get a board that cannot exist.
     // The maximum `board_uri` length should be, at most, 31.
     $noBoards = Board::where('board_uri', "12345678901234567890123456789012")->take(1)->get();
     $this->assertInstanceOf("Illuminate\\Database\\Eloquent\\Collection", $boards);
     $this->assertInstanceOf("Illuminate\\Database\\Eloquent\\Collection", $noBoards);
     $this->assertEquals(0, count($noBoards));
     if (count($boards)) {
         $this->board = $board = $boards[0];
         $this->assertInstanceOf("App\\Board", $board);
         // Test relationships
         $this->assertInstanceOf("Illuminate\\Database\\Eloquent\\Relations\\HasMany", $board->posts());
         $this->assertInstanceOf("Illuminate\\Database\\Eloquent\\Relations\\HasMany", $board->logs());
         $this->assertInstanceOf("Illuminate\\Database\\Eloquent\\Relations\\HasMany", $board->threads());
         $this->assertInstanceOf("Illuminate\\Database\\Eloquent\\Relations\\HasMany", $board->roles());
         // Test modern routes
         $response = $this->call('GET', url("{$board->board_uri}"));
         $this->assertEquals(200, $response->getStatusCode());
         $this->doBoardIndexAssertions();
         $response = $this->call('GET', url("{$board->board_uri}/1"));
         $this->assertEquals(200, $response->getStatusCode());
         $this->doBoardIndexAssertions();
         $response = $this->call('GET', url("{$board->board_uri}/catalog"));
         $this->assertEquals(200, $response->getStatusCode());
         $response = $this->call('GET', url("{$board->board_uri}/logs"));
         $this->assertEquals(200, $response->getStatusCode());
         $this->assertViewHas('board');
         $this->assertViewHas('logs');
         // Test legacy routes
         $legacyCode = env('LEGACY_ROUTES', false) ? 302 : 404;
         $response = $this->call('GET', url("{$board->board_uri}/index.html"));
         $this->assertEquals($legacyCode, $response->getStatusCode());
         $response = $this->call('GET', url("{$board->board_uri}/1.html"));
         $this->assertEquals($legacyCode, $response->getStatusCode());
         $response = $this->call('GET', url("{$board->board_uri}/catalog.html"));
         $this->assertEquals($legacyCode, $response->getStatusCode());
     } else {
         $this->assertEquals(0, Board::count());
     }
 }

 /**
  * Returns a list of board_uris where the canEditConfig permission is given.
  *
  * @return Collection  of Board
  */
 public function getBoardsWithConfigRights()
 {
     $whitelist = true;
     $boardlist = [];
     if ($this->canEditConfig(null)) {
         $whitelist = false;
     }
     foreach ($this->getPermissions() as $board_uri => $permission) {
         if ($this->canEditConfig($board_uri) === $whitelist) {
             $boardlist[] = $board_uri;
         }
     }
     $boardlist = array_unique($boardlist);
     return Board::where(function ($query) use($whitelist, $boardlist) {
         if ($whitelist) {
             $query->whereIn('board_uri', $boardlist);
         } else {
             $query->whereNotIn('board_uri', $boardlist);
         }
     })->andCreator()->andOperator()->andStaffAssignments()->get();
 }

 /**
  * Imports board attachments.
  *
  * @return void
  */
 public function importInfinityAttachments()
 {
     $this->info("\tImporting attachments ...");
     Board::where('board_uri', '>=', "jonimu")->orderBy('board_uri', 'asc')->chunk(1, function ($boards) {
         foreach ($boards as $board) {
             FileAttachment::whereForBoard($board)->forceDelete();
             $this->line("\t\tImporting attachments from /{$board->board_uri}/");
             $tTable = $this->tcon->table("posts_{$board->board_uri}");
             $storageLinked = 0;
             $attachmentsMade = 0;
             // Threads first, replies by id.
             $tTable->where('num_files', '>', 0)->orderByRaw('thread asc, id asc')->chunk(200, function ($posts) use(&$board, &$attachmentsMade, &$storageLinked) {
                 $this->line("\t\t\tImporting 200 more posts's attachments ...");
                 $aModels = [];
                 $fModels = [];
                 $skips = 0;
                 // [{
                 // 	"name":"1417727856564.png",
                 // 	"type":"image\/png",
                 // 	"tmp_name":"\/tmp\/php05oN25",
                 // 	"error":0,
                 // 	"size":13034,
                 // 	"filename":"1417727856564.png",
                 // 	"extension":"png",
                 // 	"file_id":"1423141860833",
                 // 	"file":"1423141860833.png",
                 // 	"thumb":"1423141860833.jpg",
                 // 	"is_an_image":true,
                 // 	"hash":"8c63f0b812657c38966ddc7d387a9a4b",
                 // 	"width":223,
                 // 	"height":200,
                 // 	"thumbwidth":223,
                 // 	"thumbheight":200,
                 // 	"file_path":"b\/src\/1423141860833.png",
                 // 	"thumb_path":"b\/thumb\/1423141860833.jpg"
                 // }]
                 // files, num_files, filehash
                 foreach ($posts as $post) {
                 }
                 if (FileAttachment::insert($aModels)) {
                     $attachmentsMade += count($aModels);
                 }
             });
             $this->line("\t\t\tImported {$storageLinked} files with {$attachmentsMade} attachments.");
         }
     });
 }

 /**
  * Returns the primary navigation board list.
  *
  * @return array|false  Returns false if the setting boardListShow is disabled.
  */
 public function getNavigationPrimaryBoards()
 {
     if ($this->hasDB() && $this->get('boardListShow', false)) {
         return Cache::remember('site.gnav.boards', 1, function () {
             $popularBoards = Board::where('posts_total', '>', 0)->wherePublic()->select('board_uri', 'title')->orderBy('posts_total', 'desc')->take(20)->get();
             $recentBoards = Board::where('posts_total', '>', 0)->wherePublic()->whereNotIn('board_uri', $popularBoards->pluck('board_uri'))->select('board_uri', 'title')->orderBy('last_post_at', 'desc')->take(20)->get();
             return ['popular_boards' => $popularBoards, 'recent_boards' => $recentBoards];
         });
     }
     return false;
 }

 /**
  * Returns a list of board_uris where the canEditConfig permission is given.
  *
  * @return Collection  of Board
  */
 public function getBoardsWithConfigRights()
 {
     $whitelist = true;
     $boardlist = [];
     if ($this->canEditConfig(null)) {
         $whitelist = false;
     }
     $boardlist = $this->canInBoards('board.config');
     $boardlist = array_unique($boardlist);
     if (empty($boardlist)) {
         return collect();
     }
     return Board::where(function ($query) use($whitelist, $boardlist) {
         if ($whitelist && !in_array(null, $boardlist)) {
             $query->whereIn('board_uri', $boardlist);
         }
     })->andAssets()->andCreator()->andOperator()->andStaffAssignments()->paginate(25);
 }

 /**
  * Returns the primary navigation board list.
  *
  * @return array|false  Returns false if the setting boardListShow is disabled.
  */
 public function getNavigationPrimaryBoards()
 {
     if ($this->hasDB() && $this->get('boardListShow', false)) {
         if (Cache::has("site.boardlist")) {
             return Cache::remember('site.gnav.boards', 1, function () {
                 $popularBoards = collect();
                 $recentBoards = collect();
                 $popularBoardArray = Board::getBoardsForBoardlist(0, 20);
                 foreach ($popularBoardArray as $popularBoard) {
                     $popularBoards->push(new Board($popularBoard));
                 }
                 $recentBoards = Board::where('posts_total', '>', 0)->whereNotNull('last_post_at')->wherePublic()->whereNotIn('board_uri', $popularBoards->pluck('board_uri'))->select('board_uri', 'title')->orderBy('last_post_at', 'desc')->take(20)->get();
                 return ['popular_boards' => $popularBoards, 'recent_boards' => $recentBoards];
             });
         }
         return ['popular_boards' => collect(), 'recent_boards' => collect()];
     }
     return false;
 }