Cakefest 2024 Workshop 1

Transcript

1. CakeFest 2024 Luxembourg Workshop 1
2. Workshop 1 • 3h session • Quick CakePHP project setup • Building a plugin from scratch: Report builder • Code https:/ /github.com/steinkel/cakefest2024 • Database https:/ /github.com/steinkel/cakefest2024/blob/master/db.sql • Slides
3. About Jorge González https:/ /phpc.social/@steinkel • VP at CakeDC jorge.gonzalez@cakedc.com https:/ /www.cakedc.com
4. CakePHP Introduction • Setting up a development environment • Example application • Baking our application CRUD
5. Setup dev environment • Requirements $ sudo apt install -y php-cli php-intl php-mbstring php-sqlite3 zip php-zip // setup composer 5
6. OR Use ddev • Check https:/ /ddev.readthedocs.io/en/stable/ 6
7. Composer • Create a CakePHP 5 project • https:/ /github.com/cakephp/app $ composer create-project cakephp/app cakefest2024 Installing... … Do you want to remove the existing VCS (.git, .svn..) history? [Y,n]? ←Y {skeleton} 7
8. Configure ddev $ ddev config # edit .ddev/config.yml file $ ddev get --list # install phpmyadmin 8
9. Configuration • Application class • CakePHP Bootstrap • config/bootstrap.php • config/app.php • Configure default datasource via environment (done for you by ddev in .env) 9
10. • Database download URL: https:/ /raw.githubusercontent.com/steinkel/cakefest2024/master/db.sql • ddev import-db Database schema 10
11. $ bin/cake bake all --everything --prefix Admin (you will need to setup Admin prefix routing) Bake Shell • Build a CRUD for our tables 11
12. Plugins • CakePHP Plugins
13. • https:/ /github.com/FriendsOfCake/awesome-cakephp • Plugin setup and configuration • We'll set up an existing plugin later today Plugin concepts 13
14. Report Builder • New, generic plugin • Provide simple reporting features to existing CakePHP projects
21. • bin/cake bake plugin ReportBuilder • Tweak routes and initial configuration Let's go! 21
22. • bin/cake bake migration initial --plugin ReportBuilder cake bake model --table rb_reports Reports --plugin ReportBuilder cake bake controller Reports --plugin ReportBuilder cake bake template Reports --plugin ReportBuilder Start with a migration 22
23. • bin/cake bake migration addStartingTable --plugin ReportBuilder Add the starting table 23
24. • We need to be sure the starting table exists Add validation 24
25. • Build editAssociations action, add javascript to navigate associations Navigate associations 25
26. • Create new table to store the associations • Use Ajax to save associations • Do not save duplicated associations Add association (save) 26
27. • Add new type to store comma separated values to store the selected columns Create new Database Type 27
28. • Use the associations to select the columns for the report • Save the selected columns as comma separated Select columns 28
29. • Prepare initial report run with contained associations Run the report 29
30. • Add the selected columns to the report run Add selected columns 30
31. • Store the filters as json • Add a filter widget for the starting table Add filter widget 31
32. • Create logic to parse the filters and apply them to the query executed Apply filters to report run 32
33. • Create another filter for relative dates, like "this week" Add filter for relative dates 33
34. • Add simple pagination to report run Add Simple Pagination 34
35. • Add headers to the starting table in report run Add Headers 35
36. • In case we want to fetch the data using an endpoint Add a simple API 36
37. Consume API for charts 37
38. • In case we want to fetch the data using an endpoint Add a simple API 38
39. Questions ?
40. Thank You ありがとうございました。 Gracias
41. • Create a widget to provide autocomplete filter for associations following conventions Autocomplete association 41