lcollong
FabriKant d'applications web
Hi,
First the whole scope. We have developed a Fabrik app "sticked" on Acymailing. Thus we have Fabrik's lists for subscribers, lists etc... the subscriber list is joined 1-1 to a specific list allowing us to enhance the Acymailing's possibilities. One among other : the possibility to associate a subscriber to several (repeated) categories (DBJ & CDD). The idea is to let the administrators use the power of Fabrik to filter their subscriber list (using basic filtering, full word one and advanced one). In particular, using the category to select, say, "all women between 30 and 40, living in Paris belonging to category 'manager' and to the category 'graduate' ". upon they are happy with their filtering they hit a button which will subscribe all these records to an acymailing list (in the purpose to send them a newsletter). Actually, this button will fill the acymailing table which is doing the "n-m" relationship between subscribers and lists.
It's very comfortable to use the php list plugin to make this happen. However, if you want to catch all the rows in the same "click", you firstly have to change the display limit to "all" in order to be able to check all the box and trigger the php script for all rows in one move. The problem raise when the selection made is very large (the db is over 130 000 records, one selection could involve several thousands records).
Is there any way to catch the whole list of filtered pk values allowing me to trigger the right sql whatever rows are actually checked ? Another way would be to fetch back the sql query used by Fabrik to actually render the result ? Just the way fabrikDebug shows it. I'll have to change the "limit" to fetch all the data....
I've search a way using $model->setLimits(0,-1); $model->getData(); but I always get the displayed data, not all the rows concerned by the filter.
I'm afraid the js or php list plugin are fired after the date being loaded, thus making impossible to fetch all the rows. I don't see how to do it using php_events plugin as I need the action being under user control.
I've the feeling something should be doable here but I would appreciate any starting point idea.
First the whole scope. We have developed a Fabrik app "sticked" on Acymailing. Thus we have Fabrik's lists for subscribers, lists etc... the subscriber list is joined 1-1 to a specific list allowing us to enhance the Acymailing's possibilities. One among other : the possibility to associate a subscriber to several (repeated) categories (DBJ & CDD). The idea is to let the administrators use the power of Fabrik to filter their subscriber list (using basic filtering, full word one and advanced one). In particular, using the category to select, say, "all women between 30 and 40, living in Paris belonging to category 'manager' and to the category 'graduate' ". upon they are happy with their filtering they hit a button which will subscribe all these records to an acymailing list (in the purpose to send them a newsletter). Actually, this button will fill the acymailing table which is doing the "n-m" relationship between subscribers and lists.
It's very comfortable to use the php list plugin to make this happen. However, if you want to catch all the rows in the same "click", you firstly have to change the display limit to "all" in order to be able to check all the box and trigger the php script for all rows in one move. The problem raise when the selection made is very large (the db is over 130 000 records, one selection could involve several thousands records).
Is there any way to catch the whole list of filtered pk values allowing me to trigger the right sql whatever rows are actually checked ? Another way would be to fetch back the sql query used by Fabrik to actually render the result ? Just the way fabrikDebug shows it. I'll have to change the "limit" to fetch all the data....
I've search a way using $model->setLimits(0,-1); $model->getData(); but I always get the displayed data, not all the rows concerned by the filter.
I'm afraid the js or php list plugin are fired after the date being loaded, thus making impossible to fetch all the rows. I don't see how to do it using php_events plugin as I need the action being under user control.
I've the feeling something should be doable here but I would appreciate any starting point idea.