SuiteCRM based system looking for report. Don't need to be familiar with SuiteCRM, we have all SQL queries from MySQL database. NEED HTML based report like on document attached.
SHIPMENT has links to BOXES or/and INVENTORY
BOX has links to INVENTORY
SHIPMENT, BOX, INVENTORY have links to pictures
script (probably PHP) must
1. pool data for SHIPMENT by provided ID
2. show SHIPMENT parameters and all PICTURES attached to SHIPMENT
3. pool all BOXES attached to SHIPMENT
4. loop details and PICTURES of all BOXES attached to SHIPMENT
5. pool all INVENTORY attached to BOX by BOXID
6. loop details and PICTURES of all INVENTORY attached to each BOX
7. pool all INVENTORY attached to SHIPMENT
8. loop details and PICTURES of all INVENTORY attached to SHIPMENT
as i mentioned before SHIPMENT can has BOXES or/and INVENTORY
very important to deal with pictures. pictures can be of 10MB in size. Initial report should show pictures resized to 800x600 or even smaller but with option to zoom to original size in the same window or in new.
To assign project to someone want to see sample of page in general with some pictures.
15 freelancers are bidding on average $161 for this job
I am an expert in web development with over 10 years experiences. PHP. MySQL and HTML are my main skills. My profile link is [login to view URL] If you give me an opportunity, I will do my best. Sincerely.