Skip to main content

IT Project

Inventory Management System for Construction Company using PHP and MySQL

Search This Blog

Posts

Learn PHP by Coding - Free Tutorial

on July 23, 2018

Download Free Tutorial

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Upload Site Photos (For Customer App)

on July 23, 2018

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Disposed Item Report

on July 23, 2018

Disposal Report Reports

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Low Stocks and BOQ Reports

on July 23, 2018

BOQ Low Stocks Reports

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Stock Issues Detail Report

on July 23, 2018

Detail Stock Issues Reports

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Stock Issues Report

on July 23, 2018

Reports Stock Issues

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Issue Stocks

on July 20, 2018

Issue Stocks Stock Control System

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Create Purchase Order

on July 20, 2018

Purchase Order Stock Control System

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Handle Return Stocks

on July 20, 2018

Return Stocks Stock Control System

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

View and Edit Stocks

on July 20, 2018

Stock Control System View Edit Stocks

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Archive

July 201826

Labels

Add Stocks BOQ Create New Supplier Detail Stock Issues Disposal Report Download File and Folder Structure Free Tutorial Func Folder Contents Inc Folder Contents

Introduction Inventory Control System Issue Stocks Low Stocks Manage Users New Category New Customer New Product Purchase Order Reports Return Stocks Site Navigation Site Structure Stock Control System Stock Issues System Login Upload Photos View Edit Customers View Edit Products View Edit Stocks View Edit Suppliers

Show more Show less

Popular Posts

View and Edit Stocks

In the Stocks menu, select the "View / Edit Stocks" sub menu. It is linked to "view_stocks.php" page / file. This page shows stocks of all items (items that has an stock record). Stocks table in the MySQL database records stocks details of products. An item can have many stocks records. This table only records stock purchases. To get the stock balance we get the total of all stocks in's and total of stock out's. By getting the difference of total in and total out, we can get the balance stock. This page has another php script for pagination. If there are hundreds of items, showing all in one page is difficult and takes long time to load, therefore we uses pagination process. Also included a search function to locate an item easily. To edit a stock record, you should click on an item name. Item name is linked to "view_stock_items.php?itm=15" with an URL parameter "itm" having the value of item index (primary key). In this page

View and Edit Items

View and edit of items are handled in "view_items.php" file. We link this file in the "View Items" sub menu in "Inventory" main menu. When visit to the page, it shows all items we created. When click on "Edit" link, item editing panel shows in the right side panel. That because when you click on "edit" link, it refer to the same page, but with a url parameter "id" and with a value of the product id of the database table. In PHP we write argument to show the editing form, only if this URL parameter is passed to the page. Source code of "view_items.php" page: <?php include("inc/page_header.php"); ?> <?php if(check('Manage Inventory') != 'Valid'){ header("Location: sys_home.php?pre=error"); ob_end_flush(); } ?> <script type="text/javascript"> function newCat(){ var catname=prompt("New Category Name: "); if(catname!=null &&a

Low Stocks and BOQ Reports

In the low stocks report shows all the items that the current stock balance is less than the previously set limit. This is called re-order level, and we set it when the product is created. In the BOQ report shows all the BOQs created. This is a customer wise report.

BCS Online Lectures

Free online lectures for BCS (British Computer Society) Professional Qualifications Certificate Level Examinations. Subject includes Information Systems, Software Development, Computer and Network Technology.

bcsonlinelectures.com/

Followers

Free PHP / MySQL Tutorial

Learn to develop an easy payment system for an electronic store using PHP and MySQL. Complete coding with full project directory.

phpfromexample.blogspot.com

Total Pageviews

Report Abuse

Powered by Blogger