pier67
Pierantonio
I have a database with 90.000 people data where about 800 of them have a photo stored in joomgalley.
I have a search page with a fabrik module and a redirect plugin to a search results page.
I want to search in Fabrik form for people who have a photo in joomgallery, and display it in result detail form.
So I think I will need:
I need some step-by-step help to choose the right way. I know that the second point is not Fabrik strictly related, but any help is welcome.
Thank you.
I have a search page with a fabrik module and a redirect plugin to a search results page.
I want to search in Fabrik form for people who have a photo in joomgallery, and display it in result detail form.
So I think I will need:
- To create a column named "PHOTO" inside the db table with people data (already done).
- To create a sql query that for each record (column name+column surname) in people's table look for filename in the Joomgallery's table (column name and surname) and, in case of a name+surname match, then store the file url in "PHOTO" column of people table. This have to be done once, because the database is static.
- To add, in Fabrik search module, an element dropdown to choose from "null" and "yes". If "yes" is choosen then the module have to tell to the redirect page to search for records where "PHOTO" column is not null. How can I do?
- In search results list I want to display an icon in the PHOTO column to indicate that a photo is availabe.
- In search result detail I want to display the photos from joomgallery path. May I use an image element? Or a file upload element?
I need some step-by-step help to choose the right way. I know that the second point is not Fabrik strictly related, but any help is welcome.
Thank you.