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.

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