sohopros
Member
We are developing a application for a Joomla website. Our customer is a manufacturer's representative that sells electronic components through Sales Representatives.
The company has three division and represents dozens of manufacturers within many product categories. Manufacturers are related with Product Categories and Product Categories with a company division.
Manufacturer's authorize the company to sell products in certain regions. And Regions are a collection of zipcodes.
Representatives are assigned to product categories. Once they represent a product category they can to sell products from any manufacturer that is assigned to the same product category. The representative area (not related with manufacturer's region) is defined by zipcodes.
For the representatives list we decided to map the Joomla contacts table inside Fabrik in order to keep the contact forms and to make the management easier for the customer.
We mapped six main entities (or Fabrik lists) on our schema.
- Company Division
- Product Category
- Manufacturer
- Region
- Representative
- Zipcode
The database model is shown below:
We were able to create this model using Fabrik. The only issue that we need to create a interface where users will be able to find a Representative by selecting a Product Category or a Manufacturer along with a zipcode. (Please, see attached image).
In order to make the "Find a Representative" feature work properly we have two questions:
1 - How can we filter representatives by Manufacturer, once the manufacturer table is not directly associated with the representative table? Please, see attached database model.
2 - How can we make the list page display the representatives data only after a selection was made in the filters?
3 - How can we force the zipcode filter to be required along with the manufacturer's filter OR the Product Category Filter?
(Zipcode Filter) AND ((Manufacturer Filter) OR (Product Category Filter) = Display Data
Thank you,
SOHO Prospecting Team
The company has three division and represents dozens of manufacturers within many product categories. Manufacturers are related with Product Categories and Product Categories with a company division.
Manufacturer's authorize the company to sell products in certain regions. And Regions are a collection of zipcodes.
Representatives are assigned to product categories. Once they represent a product category they can to sell products from any manufacturer that is assigned to the same product category. The representative area (not related with manufacturer's region) is defined by zipcodes.
For the representatives list we decided to map the Joomla contacts table inside Fabrik in order to keep the contact forms and to make the management easier for the customer.
We mapped six main entities (or Fabrik lists) on our schema.
- Company Division
- Product Category
- Manufacturer
- Region
- Representative
- Zipcode
The database model is shown below:
We were able to create this model using Fabrik. The only issue that we need to create a interface where users will be able to find a Representative by selecting a Product Category or a Manufacturer along with a zipcode. (Please, see attached image).
In order to make the "Find a Representative" feature work properly we have two questions:
1 - How can we filter representatives by Manufacturer, once the manufacturer table is not directly associated with the representative table? Please, see attached database model.
2 - How can we make the list page display the representatives data only after a selection was made in the filters?
3 - How can we force the zipcode filter to be required along with the manufacturer's filter OR the Product Category Filter?
(Zipcode Filter) AND ((Manufacturer Filter) OR (Product Category Filter) = Display Data
Thank you,
SOHO Prospecting Team