Hi,
I have been part of a development team for a while, working on a system that was originally built by one guy. The system is a CRM for a large company and the time has come to completely rebuild the architecture.
What I want to know is where can I find a simple to advanced guide on building a complex system?
The main thing is that I have found a lot of guides on “how to build a video rental system”, or “keeping track of student’s marks”, however our system is far more complex than that.
I am looking for a good OO based guide, with class inheritance etc.
One of the most important topics that I need covered is using 5 to 7 tables in complex queries, and where to put the logic for those queries. For example, if you are generating a report for a campus’s average final marks for a particular qualification, and you are retrieving data from many tables (learner, campus, qualification, marks), where do you put the logic?
I have been working in CodeIgniter at the moment, but I am willing to try something else even if it means I need to build everything from scratch.
Any help would be greatly appreciated.