Skip to content

Instantly share code, notes, and snippets.

@JeffreyWay

JeffreyWay/CommunityLinksQuery.php

Created August 3, 2016 20:12
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save JeffreyWay/9c7071aee31c1b2db3ec595d6d3373b7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save JeffreyWay/9c7071aee31c1b2db3ec595d6d3373b7 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. JeffreyWay revised this gist Aug 3, 2016. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion CommunityLinksQuery.php
    View file
    Original file line number Diff line number Diff line change
    @@ -12,7 +12,7 @@ class CommunityLinksQuery
    * @param string|null $channel
    * @return \Illuminate\Database\Eloquent\Collection
    */
    public static function run($channel)
    public static function get($channel)
    {
    return CommunityLink::with('votes', 'creator', 'channel')
    ->forChannel($channel)
  2. JeffreyWay created this gist Aug 3, 2016.
    31 changes: 31 additions & 0 deletions CommunityLinksQuery.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,31 @@
    <?php

    namespace App\Queries;

    use App\CommunityLink;

    class CommunityLinksQuery
    {
    /**
    * Fetch all relevant community links.
    *
    * @param string|null $channel
    * @return \Illuminate\Database\Eloquent\Collection
    */
    public static function run($channel)
    {
    return CommunityLink::with('votes', 'creator', 'channel')
    ->forChannel($channel)
    ->where('approved', 1)
    ->leftJoin(
    'community_links_votes',
    'community_links_votes.community_link_id', '=', 'community_links.id'
    )
    ->selectRaw(
    'community_links.*, count(community_links_votes.id) as vote_count'
    )
    ->groupBy('community_links.id')
    ->orderBy('updated_at', 'desc')
    ->paginate(3);
    }
    }
    18 changes: 18 additions & 0 deletions LinksController.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,18 @@
    <?php

    namespace App\Http\Controllers;

    use App\Queries\CommunityLinksQuery;

    class LinksController extends Controller
    {
    /**
    * Display all community links.
    */
    public function index()
    {
    $links = CommunityLinksQuery::get();

    return view('community.links', compact('links'));
    }
    }