This is a basic system designed with PHP and MySQL for a customer who sells consumer products for installment payment basis. This is a very basic level software and have many more to develop. It is never tested on a real environment though need more adjustments to do. Since this is for learning purposes, anyone interesting can fine tune the rest of the system and even use it in a real world operation.
This system has been developed in about 2009 and some PHP functions or extensions are now deprecated in the latest versions of PHP (version 5.5 and above).
mysql_connect, mysql_query, mysql_fetch_assoc and other mysql_xxx extensions are now deprecated. User mysqli_xxxx instead.
CASE STUDY
Customer Name: ACME ELECTRICAL CORP
Nature of the Business:
Our customer Acme Electrical Corp. is engaged in selling consumer electrical products such as TVs, Home Theater Systems, DVD / Blue Ray Players, Refrigerators, Cookers, etc. They sells these items to their customers to pay by installments. Customer pay an initial down payment and the balance pay by installments within a given period.
Our client want to have a system to manage his business process. Track payments of their customers and view sales reports, etc.