Web server software requirements¶

1. PHP 5.3.2+

2. One of the following operating systems:

   • Linux/Unix/BSD
   • Microsoft Windows XP SP3, Vista, Windows 7, Server 2008, Server 2008 R2
   • Mac OS X 10.4+

   1. Database:

      • MySQL 5.0+

   2. Web server:

      • Apache 2.0+

Web server hardware requirements¶

Hardware requirements vary widely depending on the traffic to the system, the complexity of its logic (i.e., PHP), and its size (i.e., database.) By default, all pages are dynamic, and thus access both the database and execute PHP code to generate.

The recommendations for the hardware are:

1. Atleast 50 GB disk space in the server.
2. Atleast 5 GB RAM

Client side requirements¶

The malaria stock status is designed to work well with Google Chrome, Mozilla Firefox and Internet Explorer 8+. The application works well across Windows, Linux, and Mac operating systems.

Source Code Structure¶

The source code is organized into Model-View-Controller development pattern. This is because CodeIgniter is based on the Model-View-Controller development pattern. MVC is a software approach that separates application logic from presentation. In practice, it permits the web pages to contain minimal scripting since the presentation is separate from the PHP scripting.

• The Model represents your data structures. Typically your model classes will contain functions that help you retrieve, insert, and update information in your database.
• The View is the information that is being presented to a user. A View will normally be a web page, but in CodeIgniter, a view can also be a page fragment like a header or footer. It can also be an RSS page, or any other type of “page”.
• The Controller serves as an intermediary between the Model, the View, and any other resources needed to process the HTTP request and generate a web page.

CodeIgniter has a fairly loose approach to MVC since Models are not required.

CodeIgniter framework was chosen for:

• maximum performance
• capability, and
• flexibility in the smallest, lightest possible package.

Installation Steps¶

Deployment on Linux (Unix) servers¶

It is important to ensure you check the Server Requirements list before deploying on your unix server.

At a high level you will need a:

• Web server ie Apache
• Database ie MySQL
• PHP

You should have a working LAMP (Linux + Apache + MySQL + PHP) installation before the actual deployment of the system.

Note

The user has to be root when installing applications by typing sudo su on the terminal.

For Ubuntu servers, visit this page for LAMP installation.

Windows server with WAMPServer 2.5+¶

Assets¶

These are the resources needed in this project.

It contains:

• CSS
• Bootstrap
• PHP - CodeIgniter framework
• JavaScript

Client¶

This is the presentation and user interface logic.

It contains scripts that will display on the browser. The client side is linked to the server side so that the user can make use of the server side logic.

Database¶

This is the database logic. It contains scripts for database authentication and connection creation as well as those for inserting, fetching and updating items on the database.

The project’s landing page is at: http://41.89.93.232/stock-monitoring/

Database - MySQL¶

• A MySQL database is used to store data.

• However, another database like PostgreSQL can also be used.

• The choice of the database was purely due to:

  • The rapid turn around time.
  • It manages memory very well: MySQL server has been thoroughly tested to prevent memory leaks.
  • It runs on many operating systems: MySQL runs on many operating systems, including Novell NetWare, Windows,Linux, many varieties of UNIX* (such as Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others.
  • It supports several development interfaces: Development interfaces include JDBC, ODBC, and scripting (PHP and Perl), letting you create database solutions that run not only in your NetWare 6.5 environment, but across all major platforms, including Linux, UNIX, and Windows.

PHP and Apache2 for the server side¶

• The scripting language PHP and web server Apache2 were used for the server side logic.
• CodeIgniter PHP framework was used to develop the system.

JavaScript¶

JavaScript was used in the client side for validation and for responsives purposes.

HTML5, Bootstrap and JavaScript for user interface¶

Since this is a Web application, the interface is coded in HTML5 with Bootstrap framework incorporated to provide a better user experience JavaScript is also used to make the interface responsive and event/data driven.

Introduction¶

This documentation set describes the data characteristics of the tables and columns in the malaria stock status monitoring database: including datatypes and sizes, nullability, index, sequence, key and constraint information. Additional commentary is also provided for key tables and columns.

Here is the screenshot of the database schema:

Database Tables¶

1. User_table
2. County_level_soh
3. Commodity_forecast_data
4. Current_stock
5. Pending_shipment_details
6. Counties
7. Central_level_data
8. Facility_level_data
9. County_level_reporting_rates
10. Zones
11. Supply_chain_agencies
12. County_level_data
13. Mapping_drugs_category
14. Facility _level_reporting_rates
15. Funding_agencies
16. Facility_level_soh
17. Malaria_commodities
18. Planned_procurement_details

Tables attributes and design¶

Color codes Key¶

County Level MOS Report¶

MOS report is generated of each drug based on the period selected at the county level.

County level months of stock(MOS) chart¶

Individual county level months of stock(MOS) Charts are produced here as per the selected period

National Level months of stock(MOS) chart¶

National level months of Stock (MOS) charts are produced as per the selected period from the drop-down menu.