Garment Shop Automation

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Garment Shop Automation

Garment Shop Automation 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 Garments,Sales,Brands,Inventory,Stocks. Admin user can manage all the operations of Inventory,Stocks,Garments,Customers,Sales and their details. Admin can create different type of reports of Garments,Sales,Brands,Inventory,Stocks according to their choise and filters. You can Download PHP and MySQL Project Garment Shop Automation with source code and database from this site. We also provide Project Report of Garment Shop Automation.

Functionalities and their descriptions of Garment Shop Automation are as follows:

  • You can search records on various criterias. Such as Garments, Brands, Inventory, Stocks
  • Create, read, update and delete (CRUD) application has been implemented on Garments,Sales,Brands,Inventory,Stocks
  • Keep the track logs of Sales, Customers, Inventory ect
  • Advance search has been implemented on Sales,Customers, Inventory
  • You can see all the details of the Garments, Brands, Customers, Inventory
  • All the modules Customers, Inventory, Sales,Stocks, Garments are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Inventory.
  • All the Sales,Customers, Inventory 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 Garments data.

Modules of Garment Shop Automation and their descriptions:

  • Garments Module : Manage all the operations of Garments
  • Sales Module : Manage all the operations of Sales
  • Customers Module : Manage all the operations of Customers
  • Brands Module : Manage all the operations of Brands
  • Inventory Module : Manage all the operations of Inventory
  • Stocks Module : Manage all the operations of Stocks

Classes and their methods of Garment Shop Automation:

  • Garments Methods : addGarments(), editGarments(), deleteGarments(), updateGarments(), saveGarments(), searchGarments()
  • Sales Methods : addSales(), editSales(), deleteSales(), updateSales(), saveSales(), searchSales()
  • Customers Methods : addCustomers(), editCustomers(), deleteCustomers(), updateCustomers(), saveCustomers(), searchCustomers()
  • Brands Methods : addBrands(), editBrands(), deleteBrands(), updateBrands(), saveBrands(), searchBrands()
  • Inventory Methods : addInventory(), editInventory(), deleteInventory(), updateInventory(), saveInventory(), searchInventory()
  • Stocks Methods : addStocks(), editStocks(), deleteStocks(), updateStocks(), saveStocks(), searchStocks()

Database tables and attributes of the Garment Shop Automation:

  • Garments Entity : Attributes of Garments are garment_id, garment_brand_id, garment_name, garment_quality, garment_type, garment_description
  • Sales Entity : Attributes of Sales are sales_id, sales_customer_id, sales_amount, sales_type, sales_description
  • Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Brands Entity : Attributes of Brands are brand_id, brand_name, brand_company, brand_type, brand_description
  • Inventory Entity : Attributes of Inventory are inventory_id, inventory_items, inventory_number, inventory_type, inventory_description
  • Stocks Entity : Attributes of Stocks are stock_id, stock_items, stock_number, stock_type, stock_description

Database definition of Garment Shop Automation:

  • The details of Garments is store into the Garments tables respective with all tables
  • Each entity (Stocks, Customers, Inventory, Sales, Garments) contains primary key and unique keys.
  • The entity Customers, Inventory has binded with Garments, Sales entities with foreign key
  • There is one-to-one and one-to-many relationships available between Inventory, Brands, Stocks, Garments
  • All the entities Garments, Inventory, Customers, Stocks are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Garment Shop Automation tables for fast query execution.

Super admin functionality of Garment Shop Automation:

  • Admin can add, edit, delete and view the records of Garments, Inventory, Customers, Stocks
  • Admin can manage all the details of Sales, Customers, Brands, Inventory
  • Admin can also generate reports of Garments, Sales, Customers, Brands
  • Admin can search the details of Garments, Inventory, Customers, Stocks
  • Admin can apply different level of filters on report of Garments, Customers, Stocks
  • Admin can tracks the detailed information of Inventory, Stocks, Garments, Sales

Report of Garment Shop Automation:

  • Generates the report on Customers,Brands,Garments,Sales,Inventory,Stocks,
  • Brands,Inventory,Stocks 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 Brands,Inventory,Stocks
  • Excel Sheet report has also been integrated for Sales,Brands,Stocks
  • You can create the CSV reports for Garments,Inventory,Customers

Limitation of Garment Shop Automation

  • Run time report generation is not available in Garment Shop Automation.
  • We have not implemented the dynamic report for Garments,Brands,Inventory,Sales,Customers,Stocks
  • This project Garment Shop Automation has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Garments, Brands, Stocks cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Garment Shop Automation

  • We have added all the validations for input value on the modules Garments,Sales,Customers
  • Brands,Inventory,Stocks can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Garments,Customers,Stocks
  • CSRF token has also been implemented on Brands,Sales,Garments, Inventory,Stocks
  • All the Garments,Brands,Inventory,Sales,Customers,Stocks has integrated with captcha for spam protections
  • Access level validation has been implemented on Stocks,Inventory,Brands
  • Number and character validation has also been implemented on Customers,Inventory,Garments

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database