Pro Yearly is on sale from $80 to $50! »

QueryFilter: Model Filtering

QueryFilter: Model Filtering

Filtering gives you a bunch of options. Many options and conditionals make your controller bigger and bigger. Let's use the QueryFilter concept to map all query string parameters with our model layer, cleaning up your controller.

Talk presented on Darkmira Tour PHP 2018, in Brasília, DF Brazil,

7bb3a66a199daec275d5ad339724c754?s=128

Junior Grossi

April 14, 2018
Tweet

Transcript

  1. QueryFilter: Model Filtering Junior Grossi @ Darkmira Tour PHP 2018

    April 2018
  2. About me @junior_grossi

  3. Resume PHPMG group organizer Software Engineer at InterNACHI (PHP/Laravel) Creator

    of Corcel PHP Ph.D. in Information Science ‑ UFMG 2018 (in progress) Master's in Information Science ‑ UFMG 2015 Specialization in Web Developmenet ‑ PUCMG 2013 MBA in Business Management ‑ FGV 2009 Bachelor's in Computer Science ‑ PUCMG 2007 Zend Certified Engineer ‑ 2011
  4. Contact GitHub: http://github.com/jgrossi Twitter: http://twitter.com/junior_grossi Blog: https://blog.jgrossi.com

  5. Talk's dynamics 35' talk + 5' questions = 40' 20%

    slides + 80% live coding
  6. What's QueryFilter ? Code abstraction for filtering objects based on

    the `URL. From Laracasts: http://laracasts.com
  7. /posts?title=foo&status=bar Select Post which title contains foo ; Select Post

    which status is bar .
  8. Example Listing posts in JSON format Posts from WordPress http://blog.jgrossi.com

    Using Corcel PHP http://github.com/corcel/corcel Use WordPress backend with Laravel or any PHP app Laravel 5.6 app to handle all the logic
  9. composer require jgrossi/corcel

  10. Listing posts in JSON public function index() { $posts =

    Post::newest()‑>limit(10)‑>get(); return PostResource::collection($posts); // json }
  11. Filtering by Request public function index(Request $request) { $query =

    Post::query()‑>newest()‑>limit(10); if ($request‑>filled('title')) { $value = $request‑>get('title'); $query‑>where('post_title', 'like', "%$value%"); } if ($request‑>filled('status')) { $query‑>where('post_status', $request‑>get('status' } $posts = $query‑>get(); return PostResource::collection($posts); }
  12. Filtering by QueryFilter SOLID's Single responsibility principle ... a class

    should have only a single responsibility. Dependency/Method Injection ... is a technique whereby one object supplies the dependencies of another object.
  13. Show me the code Talk is cheap. Show me the

    code. ‑‑ Linus Trovals
  14. After 20 minutes of live coding...

  15. QueryFilter is a concept

  16. Update: Talk's code https://github.com/jgrossi/darkmira‑query‑filter

  17. Composer Packages cerbero/query‑filters kblais/query‑filter

  18. Thanks! Questions? GitHub: http://github.com/jgrossi Twitter: http://twitter.com/junior_grossi Blog: https://blog.jgrossi.com