$30 off During Our Annual Pro Sale. View Details »

The Right Toolbox

The Right Toolbox

Choosing the right tool for the job sometimes means bringing along a whole toolbox. I’ll show how a complex back-end system was built with Craft, Laravel, Redis, and more, all working in harmony.

Anthony Colangelo

April 24, 2014
Tweet

More Decks by Anthony Colangelo

Other Decks in Programming

Transcript

  1. https://www.flickr.com/photos/iangbl/

    View Slide

  2. https://www.flickr.com/photos/florianric/

    View Slide

  3. https://www.flickr.com/photos/pennuja/

    View Slide

  4. Yeah, we could make that work.

    View Slide

  5. Yeah, we could make that work.
    But…

    View Slide

  6. View Slide

  7. View Slide

  8. View Slide

  9. View Slide

  10. View Slide

  11. View Slide

  12. Content

    View Slide

  13. Content Users

    View Slide

  14. Content Users Voting

    View Slide

  15. https://www.flickr.com/photos/beraldoleal

    View Slide

  16. View Slide

  17. Route::get('/', array(
    'as' => 'home',
    'uses' => 'HomeController@ ',
    'after' => 'cache'
    ));
    showVoteHome

    View Slide

  18. !
    !
    Route::filter('cache', function($route, $request, $response, $max_age=1200)
    {
    });

    View Slide

  19. class Nominee extends Eloquent {
    !
    // ...
    !
    }

    View Slide

  20. View Slide

  21. Content

    View Slide

  22. View Slide

  23. View Slide

  24. View Slide

  25. SELECT description,
    body,
    tagline,
    hashtag,
    closingTime
    FROM craft_content

    View Slide

  26. View Slide

  27. View Slide

  28. View Slide

  29. View Slide

  30. View Slide

  31. View Slide

  32. // ...
    }
    class Nominee extends Eloquent {

    View Slide

  33. // ...
    }
    class Nominee extends Eloquent {
    protected $table = 'craft_entries_i18n';

    View Slide

  34. // ...
    }
    class Nominee extends Eloquent {
    protected $table = 'craft_entries_i18n';
    private $sectionId = 2;

    View Slide

  35. public function scopeListing($query)
    {
    return $query
    ->select( /* ... */ )
    ->join( /* ... */ )
    ->where( /* ... */ );
    }

    View Slide

  36. public function scopeListing($query)
    {
    return $query
    ->select( /* ... */ )
    ->join('craft_content', 'craft_content.elementId', '=', 'craft_entries_i18n.entryId')
    ->join('craft_entries', 'craft_entries.id', '=', 'craft_entries_i18n.entryId')
    ->join('craft_elements', 'craft_elements.id', '=', 'craft_entries_i18n.entryId')
    ->where('craft_entries_i18n.sectionId','=',$this->sectionId)
    ->where('craft_entries.postDate','<=',date_format(new DateTime(),'Y-m-d G:i:s'))
    ->where(function($query)
    {
    $query
    ->where('craft_entries.expiryDate','=',NULL)
    ->orWhere('craft_entries.expiryDate','>=',date_format(new DateTime(),'Y-m-d G:i:s'));
    })
    ->where('craft_elements.enabled','=',1);
    }

    View Slide

  37. ->where(
    'craft_entries_i18n.sectionId','=',
    $this->sectionId
    )

    View Slide

  38. ->join('craft_content',
    'craft_content.elementId', '=',
    'craft_entries_i18n.entryId'
    )

    View Slide

  39. ->join('craft_entries',
    'craft_entries.id', '=',
    'craft_entries_i18n.entryId'
    )

    View Slide

  40. ->where('craft_entries.postDate','<=',
    date_format(new DateTime(),'Y-m-d G:i:s')
    )

    View Slide

  41. ->where(function($query)
    {
    $query
    ->where('craft_entries.expiryDate','=',NULL)
    ->orWhere('craft_entries.expiryDate','>=',
    date_format(new DateTime(),'Y-m-d G:i:s'));
    })

    View Slide

  42. ->join('craft_elements',
    'craft_elements.id', '=',
    'craft_entries_i18n.entryId'
    )

    View Slide

  43. ->where('craft_elements.enabled','=',1)

    View Slide

  44. public function scopeListing($query)
    {
    return $query
    ->select( /* ... */ )
    ->join( /* ... */ )
    ->where( /* ... */ );
    }

    View Slide

  45. $nominees = Nominee::listing()
    ->orderBy('craft_entries_i18n.title')
    ->get();

    View Slide

  46. View Slide

  47. Users

    View Slide

  48. View Slide

  49. View Slide

  50. View Slide

  51. View Slide

  52. View Slide

  53. View Slide

  54. View Slide

  55. // ...
    }
    class User extends Eloquent {

    View Slide

  56. // ...
    }
    class User extends Eloquent {
    protected $table = 'craft_users';

    View Slide

  57. craft_users
    id
    username
    firstName
    lastName
    status

    View Slide

  58. oma_users
    userId
    avatar
    bio
    providerData
    providerTokens
    craft_users
    id
    username
    firstName
    lastName
    status

    View Slide

  59. View Slide

  60. View Slide

  61. View Slide

  62. View Slide

  63. Voting

    View Slide

  64. View Slide

  65. public function cast($voterId, $nomineeId, $categoryId, $influencerId = 0)
    {
    !
    // ...
    !
    }

    View Slide

  66. $redis = Redis::connection('oma4-votes');
    !
    $voter = "user[{$voterId}]";
    $nominee = "nominee[{$nomineeId}]";
    $category = "category[{$categoryId}]";
    $influencer = “user[{$influencerId}]”;
    !
    $datetime = new DateTime();
    $date['day'] = $datetime->format('Y-m-d');
    $date['hour'] = $datetime->format('Y-m-d-H');

    View Slide

  67. // Vote Counts
    $redis->incrby('votes',1);
    $redis->hincrby("votes:{$voter}",'total',1);
    $redis->hincrby("votes:{$voter}",'cast',1);

    View Slide

  68. // Nominee Standings
    $redis->zincrby("standings:nominee",1,$nominee);
    $redis->zincrby("standings:nominee:{$category}",1,$nominee);
    $redis->zincrby("standings:nominee:{$voter}",1,$nominee);

    View Slide

  69. $redis->zrevrange(
    "standings:nominee", 0, -1, 'WITHSCORES'
    );

    View Slide

  70. // Activity Trends
    $redis->hincrby("trends:{$voter}",$date['day'],1);
    $redis->hincrby("trends:{$voter}",$date['hour'],1);
    $redis->hincrby("trends:{$nominee}",$date['hour'],1);
    $redis->hincrby("trends:{$category}",$date['hour'],1);

    View Slide

  71. $hourOne = $redis->hget("trends:{$nominee}", '2013-06-19-20');
    $hourTwo = $redis->hget("trends:{$nominee}", '2013-06-19-21');
    $hourThree = $redis->hget("trends:{$nominee}", '2013-06-19-22');

    View Slide

  72. View Slide

  73. View Slide

  74. View Slide

  75. View Slide

  76. View Slide

  77. View Slide

  78. Be Pragmatic.

    View Slide

  79. @acolangelo

    View Slide