kaizenoctopus
2010-11-01 22:29:22 UTC
I had been a programmer in Oracle 9i and D2k for past 17 years, I am very strong in database design and D2k Front end programming, I am currently having big systems designed at database level. Most of the cost (almost 99%) is handled by the database by way of triggers.
My current requirement is very very few out of a php framework, to brief it :-
1. I want master detail form in php wherein I want to see both master and detail form in a single screen available for data entry ( I have seen most of the frameworks tutorial, and it was very hard for me to find this scenario, the scenario normally I found is first enter master record, save it and then expand detail tab and enter detail, it is wrong when i want to enter invoice and enter all the line items at the same time when master record is filled, I hope you agree to this)
2. when joining 2 tables in master detail I want to relate multiple columns in relation to each other, this should be supported by framework. (this is a must otherwise there cannot be any good software generated out of it)
3. I want vlookup or list items in a column, it should be ms-sql query based for example I am entering invoice and in invoice line items (detail table), i want to select order for that customer then i should be able to lookup by way of sql query into order table, orders of that customer only and display it in lookup, return value of other column into my detail column.
If my above 3 things are satisfied, I think I can generate data entry screens and my system will work ok. I do not have any programming experience in php. zero knowledge.
I want you professionals to suggest me such a framework which will satisfy my above requirement. It is very difficult for me to judge whether i will be able to go comfortably with MVC architecture without any problems. I have tried and operated phprunner, but there are certain flaws in lookup (it is not sql query based) that is the reason I want to shift to some other framework, it is creating big problem for me due to the same)
Please advise professionals. I need preferably free framework under gpl license. Look and feel is also a bit important for me, but i feel that if I get the master detail in a single form for entry at the same time without changing screens, then it will be the best for me along with my other 2 requirements.
Please Please help me suggest a framework. Please do not just advise. Advise such a framework for a noob (zero php knowledge) like me. I would also prefer to read a bit, but not much like a novel for help in framework.