Distributed Account Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Distributed Account Management System

Distributed Account Management System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Transaction,Outlet,Credit Report,Sales,User. Admin user can manage all the operations of Sales,User,Transaction,Stock Update,Outlet and their details. Admin can create different type of reports of Transaction,Outlet,Credit Report,Sales,User according to their choise and filters. You can Download PHP and MySQL Project Distributed Account Management System with source code and database from this site. We also provide Project Report of Distributed Account Management System.

Functionalities and their descriptions of Distributed Account Management System are as follows:

  • You can search records on various criterias. Such as Transaction, Credit Report, Sales, User
  • Create, read, update and delete (CRUD) application has been implemented on Transaction,Outlet,Credit Report,Sales,User
  • Keep the track logs of Outlet, Stock Update, Sales ect
  • Advance search has been implemented on Outlet,Stock Update, Sales
  • You can see all the details of the Transaction, Credit Report, Stock Update, Sales
  • All the modules Stock Update, Sales, Outlet,User, Transaction are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Sales.
  • All the Outlet,Stock Update, Sales modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Transaction data.

Modules of Distributed Account Management System and their descriptions:

  • Transaction Module : Manage all the operations of Transaction
  • Outlet Module : Manage all the operations of Outlet
  • Stock Update Module : Manage all the operations of Stock Update
  • Credit Report Module : Manage all the operations of Credit Report
  • Sales Module : Manage all the operations of Sales
  • User Module : Manage all the operations of User

Classes and their methods of Distributed Account Management System:

  • Transaction Methods : addTransaction(), editTransaction(), deleteTransaction(), updateTransaction(), saveTransaction(), searchTransaction()
  • Outlet Methods : addOutlet(), editOutlet(), deleteOutlet(), updateOutlet(), saveOutlet(), searchOutlet()
  • Stock Update Methods : addStock Update(), editStock Update(), deleteStock Update(), updateStock Update(), saveStock Update(), searchStock Update()
  • Credit Report Methods : addCredit Report(), editCredit Report(), deleteCredit Report(), updateCredit Report(), saveCredit Report(), searchCredit Report()
  • Sales Methods : addSales(), editSales(), deleteSales(), updateSales(), saveSales(), searchSales()
  • User Methods : addUser(), editUser(), deleteUser(), updateUser(), saveUser(), searchUser()

Database tables and attributes of the Distributed Account Management System:

  • Transaction Entity : Attributes of Transaction are transaction_id, transaction_customer_id, transaction_amount, transaction_bill, transaction_number, transaction_type, transaction_history, transaction_description
  • Outlet Entity : Attributes of Outlet are outlet_id, outlet_stock_id, outlet_title, outlet_type, outlet_description
  • Stock Update Entity : Attributes of Stock Update are stock_id, stock_items, stock_number, stock_type, stock_description
  • Credit Report Entity : Attributes of Credit Report are credit_report_id, credit_report_product_id, credit_report_name, credit_report_type, credit_report_description
  • Sales Entity : Attributes of Sales are sales_id, sales_customer_id, sales_amount, sales_type, sales_description
  • User Entity : Attributes of User are user_id, user_name, user_specialist, user_mobile, user_email, user_username, user_password, user_address

Database definition of Distributed Account Management System:

  • The details of Transaction is store into the Transaction tables respective with all tables
  • Each entity (User, Stock Update, Sales, Outlet, Transaction) contains primary key and unique keys.
  • The entity Stock Update, Sales has binded with Transaction, Outlet entities with foreign key
  • There is one-to-one and one-to-many relationships available between Sales, Credit Report, User, Transaction
  • All the entities Transaction, Sales, Stock Update, User are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Distributed Account Management System tables for fast query execution.

Super admin functionality of Distributed Account Management System:

  • Admin can add, edit, delete and view the records of Transaction, Sales, Stock Update, User
  • Admin can manage all the details of Outlet, Stock Update, Credit Report, Sales
  • Admin can also generate reports of Transaction, Outlet, Stock Update, Credit Report
  • Admin can search the details of Transaction, Sales, Stock Update, User
  • Admin can apply different level of filters on report of Transaction, Stock Update, User
  • Admin can tracks the detailed information of Sales, User, Transaction, Outlet

Report of Distributed Account Management System:

  • Generates the report on Stock Update,Credit Report,Transaction,Outlet,Sales,User,
  • Credit Report,Sales,User has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Credit Report,Sales,User
  • Excel Sheet report has also been integrated for Outlet,Credit Report,User
  • You can create the CSV reports for Transaction,Sales,Stock Update

Limitation of Distributed Account Management System

  • Run time report generation is not available in Distributed Account Management System.
  • We have not implemented the dynamic report for Transaction,Credit Report,Sales,Outlet,Stock Update,User
  • This project Distributed Account Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Transaction, Credit Report, User cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Distributed Account Management System

  • We have added all the validations for input value on the modules Transaction,Outlet,Stock Update
  • Credit Report,Sales,User can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Transaction,Stock Update,User
  • CSRF token has also been implemented on Credit Report,Outlet,Transaction, Sales,User
  • All the Transaction,Credit Report,Sales,Outlet,Stock Update,User has integrated with captcha for spam protections
  • Access level validation has been implemented on User,Sales,Credit Report
  • Number and character validation has also been implemented on Stock Update,Sales,Transaction

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database