I have all the relations and ActiveRecords set up for this. I know I can create this GridView in a non Yii way. But i want to know if there is a way to do this with CGridView because i need to have filters, pagination and sorting in this situation.
This is a good idea but how am i really supposed to approach my problem using this. Lets say, I am starting from Prices because the prices have access to both stores and products. Lets say we know that usually the number regions are way less than the number of products. So as an example, I have 20 products and 5 regions. Am i going to have 5 activedataproviders (1 per region)? How efficient is it relative to plain SQL. I know activerecord is usually slower than plain sql query but in my scenario it sounds like an overhead, isnt it? Im going to give it a shot and do couple tests to see how it is.