I'm trying to build a system to provide an easy access but very clever service select (sounds confusing, I will explain).
Essentially I'm trying to create a system then will firstly store devices of different types, these types are:
- Device type (iPhone, iPod, iPad)
- Generation (4th Gen, 5th Gen etc.)
- Model (iPhone 4s, iPod Touch , iPad 2 etc)
In addition to this I also need to give optional parameters for instance "colour" or "memory" and then options "black" or "16GB" etc. and as I said these must be optional, for instance an iPhone 3G or 3GS will need the parameter of "Memory" with options "8GB" or "> 8GB".
This is just the begining. I then need some way ofadding a repair to each item all though the repairs are muchly the same for instance "Front Screen" replacement. That's nice and easy and I could do that BUT what I need the system to do is calculate the cost of that repair by finding the correct parts involved in that repair. Each part is model specific.
I have a pretty advanced knowledge of PHP and MySql it's just the design of the table structure that leaves me a little bit cufuffled!
Any help would be greatly appreciated.