mangoo-microfinance/mangoo-microfinance

A lightweight, yet powerfull solution for microfinance institutions based on web technologies

mangoO Microfinance Management

mangoO Microfinance Management is a lightweight, yet powerful software solution for small microfinance institutions. It uses web technologies like PHP, MySQL, JavaScript (with jQuery), and CSS.

mangoO was initially developed for Luweero Diocese SACCO (Savings and Credit Cooperative) of the Anglican Luweero Diocese in Uganda. Typically, customers of such SACCOs will have to buy shares to become members of the society. These members will then hold both a savings and a loans account with the financial institution.

The development of mangoO Microfinance Management was funded by Christian Services International (Stuttgart, Germany).

Features

• Customer management
• Share account management
• Savings account management
• Loan management
• Employee management
• Reporting
• Accounting

Installation

As mangoO is fully based on web technology, it requires a PHP-capable webserver and a MySQL database. For testing purposes, using XAMPP is recommended.

To connect to the test database included in this repository (mangoo.sql), the required configuration is as follows. Server: 127.0.0.1 / Database user: root / Database password: '' (empty password). These are the current default settings included in ./config/config.php. They should only be used for test installations. Make sure to change database user and password for any productive environment! It is also highly recommended to change the password pepper in each new installation by editing ./config/pepper.php.

The default login for the program GUI is: Username: admin Password: password

Licence

This software is licensed under the GNU General Public License 3.0, a copy of which can be found in the LICENSE file.

mangoo-microfinance's Issues

User manual needs update to v5.0

The manual (both user and admin) need to be updated to mangoO Microfinance Management v5.0.

Unable to Dispaly the Next Month Same Date in Due Date Display Table

I need one more help from you
How to bring the date of due date date table as constant
I mean
I need all months of a date should be same .
For example

01.02.2018
01.03.2018
01.04.2018

How to do this?

User verification does not work after fresh install

the application is not authenticating users after a fresh install. Any other way to get this to login

Printing of Statement of Accounts for Customers

I would like to request that @mangoO-Microfinance make efforts to add this and account closure functions.

Documentation (Admin)

An administrator documentation needs to be written.

Statistics Widget

It would be desirable to implement an optional statistics widget for the dashboard. The widget should - among others - include statistics about:

• Number of customers
  

• Customer details like gender, age, etc.
  

• Current loan recovery rates
  

• Incomes / Expense ratio
  

• and others...
  

Automatic Receipt Printing?

Currently, receipt numbers must be entered manually. The reason is, that most MFIs buy pre-printed receipt books. In such books, the empty receipts already have numbers.
Would it be desirable to have receipt numbers generated and receipts printed by mangoO?

Tables missing in DB you provide

hello,
how are you, i downloaded and run the mfi app on my localhost but some tables are missing in the db

e.g employee table and the savbalance table

could you please update the db upload with a complete db.

P.S nice work on this

Will download

Will take a look at your project.

And indeed we can develop my project further. Do you do Laravel or CakePhp?

cant install mangoo on my server

hello guys i have downloaded mangoo now wanna install on my server keeps on giving me this problem

please HELP BROTHERS AND SISTERS

Could not create database "code2qzp_mango" Access denied for user 'code2qzp_mango'@'dali.aserv.co.za' to database 'code2qzp_mango'

deposit money not saving

Hello Guys
I installed mangoo mfg version 5. However, All attempt to add deposit for customer is failing with errors.

Unable to Host it into the web server

I hosted the pages into the server ,I'm unable to setup the installation setup.php page and further after installed anyway ,once the user and passowrd is entered next login.php pages shows blank.
I need some one to help completely to upload and further steps.

Employee Management

Introduce a new feature for employee management. Integrate into Expenses in Accounting section.

Documentation (User)

A user documentation needs to be written.

ERRORS, Am new here

Am sorry But inhave tried the mangoO system but
shares are not inserted
deposits are not made
( ! ) Notice: Undefined variable: sav_depos_percent in dashboard\dash_stat_finance.php on line 38
( ! ) Notice: Undefined variable: inc_percent in dashboard\dash_stat_finance.php on line 23
( ! ) Notice: Undefined variable: sav_withd_percent in dashboard\dash_stat_finance.php on line 39
( ! ) Warning: Division by zero in dashboard\dash_stat_finance.php on line 39
.....
even wen i used mango test Database
savbal_fixed tabble does not have a default value
Many many other errors........ Renew, etcs

WAMP
Database server
Server: MySQL (127.0.0.1 via TCP/IP)
Server type: MySQL
Server connection: SSL is not being used Documentation
Server version: 5.7.26 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Web server
Apache/2.4.39 (Win64) PHP/7.2.18
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id:
phpMyAdmin
Version information: 4.8.5

Quuick replies makess no worry

SQL error when creating new Customer

Hi, thank you in advance for this good job!
I have successfully install Mangoo with Test Database on this config:
PHP 7, MySQL 5.7.
After login, when I try to create a new customer, I have this error: SQL-Statement failed: Field 'inc_text' doesn't have a default value on a blank screen, But when I return to the Customers List, I can see that the customer has been added successfully to the list!
How can I fix It.

fixing more loan repayment shedule dates enhacment

lets say customer has payed all his schedule and left with same balance it would be better to increase his schedule for a specified dates to pay his balance .

Loan setting Module error occur

Responsive design

The design of mangoO should be worked upon to become responsive on all devices and screen sizes.

Warning: require_once(config/config.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ezeeloan\functions.php on line 6

Warning: require_once(config/config.php): failed to open stream: No such file or directory in C:\xampp\htdocs....\functions.php on line 6

PHP code deprecation

mangoO still make heavy use of old mysql_* functions. In PHP 7, support for this old API has been removed. To make mangoO future proof, we must shift to the new mysqli_* or PDO.

Customer login issues

How do existing customers login into the system and get an overview of their account information

Handling of loan securities

For the handling of loan securities, mechanisms for listing, returning, or deleting loan securities should be included.