It’s a system about small group
Every group has a group leader and a group leader must have a unique identification number which associate him/her with his/her group.
The groups are categorized in four categories as follows
- Group of men only
2. Group of women only
3. Group of both men and women
4. Group of youth only
The system should be able to say this group has a total of 50 members where by 26 are men and 24 are women this should apply to group of both men and women and groups of youth but for group of men only it should just display total saying total member of group is let say 29 the same to group of women only.
Also the group should have initial capital, it can be money or it can be plantation or it can be livestock like hen or cow or goat
Also the system should display registration date of the group and date the group was established.
Also the system should display the total numbers of members registered in the system
Also the system should display total number of women member in system and total number of men member in the system.
Also the system should display statistics by location let say it should say this village has five groups, and total member in that five groups is 345 where by men are 200 and women are 145.
Also the system should display the numbers of groups registered in the system
Also the system should display if the group is active or inactive.
Also the system should display if the group has loan or has no loan, and if it has loan what is the status of it’s payment.
Location of the group
The system should say this group is in certain region, then certain district, then division and up to village level, this should be a dependent select box, if you choose a region then the district should be displayed and so on, I have already created a database of this region to village level dependent select it’s just to implement it.
Every group should have a registration number of this format HW/ITL/MJ/CBO/72 the last part of the registration number will vary but the other part are constant, during group registration the system should fail to register if the registration number is already registered, the system should reply by custom message with red colour saying that number is already registered .
Also each group must have at least one activity, sample activity are livestock keeping, agriculture, cultivation, farming there are many activities but these are just sample.
The loan Part
Admin should assign loan to the group which need loan and the loan should come from the following part
4) District council
The amount of loan should be given to the group which need that loan
The date in which the loan was assigned
The due date for the loan to be fully paid
The interest is 10% of the original amount of the loan
The loan is coming from which parts
On payment of the loan.
The loan must be paid in ten months or twelve months
The system should display original loan
The system should display the remaining amount
The system should display the due date for the loan
The system should calculate repayment schedules and shows the amount which must be paid by the group each month until the loan is finished.
Admin should enter returned amount and feed it to the specific group and debt should decrement.
Admin should be able to print statement showing repayment of any group he/she want to see
Admin should be able to generates reports also the reports should display the current date of report generation..
Admin should be able to generate exports
Also implement nice pagination like in your online quiz project.
Also please implement search, example admin might need to search for a certain group, he/she might search using group registration number or search by or search by group leader location and then do CRUD operation or print group details.
How to use
XAMPP Server /WAMP Server Or Web server. In this example I’m using web server
Step 1 Download the source code and put the file inside public folder or if is Xampp place here “c:/xampp/htdocs/”.
Step 2. Extract the file and go To phpmyadmin or for Xampp server go to “localhost/phpmyadmin” in any browser and create Database named “loan” for web server give it any name and don’t forget to create user with a
password set. privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, and LOCK TABLES.
Step 3. In That Database, Import loan_management_system.sql found inside the extracted folder and finally open go to URL: “http://localhost/file_name/phpfilename” to configure.
To download SOURCE CODE use the download link below