Seite wählen

👉 Get in touch with us & start the recruitment with this test task:

  • Prepare an asynchronous pageview counter

Description

Database entities:

 

PageView PageViewLog
– ulid
– url
– views_count
– created_at
– updated_at
– ulid
– url
– user_id (nullable)
– created_at
– updated_at

 

  1. Use auth scaffold laravel and write user id to browsing log if he was logged in
  2. make a seed of data in PageViewLog for 6 months and write an SQL query how many page views were with and without authorization, grouped by days and months (grouping by months is a separate query)
  3. As a result of work please provide the repository on gitlab/github with code uploaded.

Please send your CV and info to test task to: info@mediapool-friends.com