Fabrik is the Joomla application builder
You will find a joomlafabrik.sql file with some sample data for nested joins and corresponding branch called rowspans-for-lists
Tables:
-
main_data, location, grouped_entry, collection, items
-
one, two, three, four, five
Test the nested joins (mark all repeated):
main tables are main_data and one (of course you can create lists for each table)
Joins under main_data:
from main_data to location from id to main_id
from main_data to grouped_entry id to main_id
from main_data to collection id to main_id
from collection to items id to collection_id
Choose option Merge table cells (no Ajax)
Joins under one:
from one to two from id to one_id
from two to three from id to two_id
from three to four from id to three_id
from four to five from id to four_id
Choose option Merge table cells (no Ajax)
CHALLENGES
-
make the nested table correctly displayed when ajax navigation enabled
-
make a form template which allows to submit nested data where all related data can repeat
input names could be then like table_name[nr][field], table_name[nr][joined_table1][nr][field] and so on
- Check out the files into your Joomla installations root directory
- Log into your Joomla administration control panel
- Go to Extensions > Extension Manager
- Click the 'Discover' link
- Click the 'Purge Cache' icon
- Click the 'Discover' icon
- Select the Fabrik package and click the 'Install' icon
Fabrik ships with several of the most common element and validation plugins, however to reduce installation package size not all available plugins are pre-installed.
All other element and validation plugins can be found by following these steps:
- Go to Extensions > Extension Manager
- Click the 'Discover' link
- Click the 'Purge Cache' icon
- Click the 'Discover' icon
- Find the element or validation plugin you want to install
- Select it
- Click 'Install'
- Go to 'Manage' and make sure it is published
The element or validation plugin will then appear as an option when creating an element or validation.
Once you have installed Fabrik 3.x, if you want to stay up to date with the latest code updates between official releases, you can 'update from GitHub'.
Please see here for instructions on how to update from GitHub - http://fabrikar.com/forums/index.php?wiki/update-from-github/.
At the time of an official release, please follow the steps here - http://fabrikar.com/forums/index.php?wiki/upgrade-instructions/
We have a Grunt build file which will create the Fabrik package for you, and place it in a folder /fabrik_build The build relies on node-gpy, which depending on your operating system may require additional installations beyond node itself. Please follow the instructions @ https://github.com/nodejs/node-gyp
Once done you should be able open a command prompt (best to run as administrator in Windows) and then do
npm install Grunt
An additional tasks is available for minimising the javascript:
Grunt js
Wiki
FAQ
Forum
Things You Can Do
Contribute Code
Contribute Translation