Please, complete following tasks:
- Set up DB using provided mysql dump file. You may use provided docker-compose.yml if you like. But docker knowledge is not required.
- Create a script to generate a JSON file, containing a nested
items_categories
data. OnlyID
andname
fields are required in export. - Create a script to generate an Excel file, containing
items_categories
data. OnlyID
andname
fields are required in export. Data hierarchy should be visualized.
There is install.php script present, which was used to generate test-data. This script somewhat represents current state of codebase (sql.php is actually a part of a current system).
docker-compose exec lap-stack php /var/www/html/export.php
Files will be created on the app/export folder