Given the product.template table with a line for each of all the products, and the product.pricelist.item table with, for each pricelist version, for each pricelist, a line for each product in that pricelist version.
I have to access in the front-end to ALL information of "that" line in the product.pricelist.item which is referring to "that" product (same product_id) in the product.template table.
Imagine other fields like the price surchage that i have to access for each product and display in the front-end.
I currently implemented a ultra-bad, debug only function in the backend which retrieve the whole product.pricelist.item table, and the frontend makes the join to find out these information.
This is (off course) performance killing and insecure and a real mess.
Do anyone of you know a way to make the join in the backend, serverside, and retrive the information in a form accessible in the front-end with something like product.item.myInformation?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/20/16, 5:35 AM|
|Seen: 293 times|
|Last updated: 6/20/16, 6:25 AM|