Kurdistan Regional Government

Ministry of Higher Education

University of Suleimani
College of Basic Education
Computer Science Department

Inventory Management System

Submitted to the scientific council of the computer science department at the
College Basic Education, University of Suleimani in partial fulfillment for the
requirements of the degree of bachelor in Computer Science.

Prepared by:
Hemn Azez KakaAbdulla
Peshraw Zerak Hama

Supervised by
MSc. Lecture: Wria Muhamed Salih

2019(A.D) 2719(K)

1
 ‫فؤرمى ثيَشكةشكردنى ثرؤذةى دةرضوون‬
‫‪ :‬ثرؤذةى دةرضوونى هةردوو خويَندكار ( هيَمن عزيز كاكةعبدهللا ‪ ،‬ثيَشرةو زيرةك حةمة ) بةناونيشانى‪L‬‬

‫‪Inventory Management System‬‬

‫دةخةينة بةردةست ئةجنوومةنى بةش‪ ،‬كة تيايدا هةموو ثيَداويستى‪ L‬يةكانى تويَذينةوةى‪ L‬زانستيمان تةواو‬
‫كردووة‬
‫بة ثيَى ئةو ثيَشنيارةى‪ L‬ئةم تويَذينةوةية ثيَشكةش بة ليذنةى هةلَسةنطاندن دةكةين‬

‫سةرثةرشتيار‪L‬‬

‫‪2‬‬
 ‫بريارى ليذنةى طفتوطؤى‪ L‬ثرؤذةى دةرضوون‬
‫ِ‬
‫هةرسى خويَندكارى‪ L‬قؤناغى‬
‫َ‬ ‫ئيَمة ئةندامانى‪ L‬ليذنةى طفتوطؤ‪ L‬و هةلَسةنطاندنى ثرؤذةى‪ L‬دةرضوونى‪L‬‬
‫ضوارةمى بةشى كؤمثيوتةر ئةم تويَذينةوةيةمان خويَندةوة لةطةل هةردوو خويَندكار طفتوطؤمان دةربارةى‬
‫بريارماندا بة (‪ )...........................................‬وةك بةشيَك لة‬
‫ناوةرؤك و اليةنةكانى ترى كرد و ِ‬
‫بروانامةى بةكالؤريؤس‪L.‬‬
‫ثيَداويستى‪ِ L‬‬

‫سةرؤكى‬ ‫ئةندام‬ ‫ئةندام‬ ‫سةرثةرشتيار‬

‫ليذنة‬
‫‪/ /‬‬ ‫‪2019 / /‬‬ ‫‪2019 / /‬‬ ‫‪2019 / /‬‬
‫‪2019‬‬

‫سةرؤكى بةشى زانستى‪ L‬كؤمثيوتةر‪L‬‬

‫م‪.‬ى ئارى‪ L‬صابر عارف‬

‫‪DEDICATION‬‬

‫‪3‬‬
 We loving dedicate this project for our supervisor (MSc. Wria Mohammad Salih) which
was just like climbing a high peak step by step accompanied with encouragement, hardship, trust,
and frustration.

We dedicate it to Suleimani University (Faculty of Physical and Basic Education

Computer Department). We want to thank our wives and families, for all of the support they have
given through all of these years of study in university.

We want to respect our Teachers who are the Nation Builders and they have taught us in
our study journey in school and university.

We have Sincere Dedication to All lecturers of the Computer Science department in

College of Basic Education at Suleimani University.

ACKNOWLEDGEMENTS

4
 In The Name of Allah, Most Gracious, Most Merciful

thank you for your advice, guidance and assistance, without your precious support this
work will not have been completed. We would like to express our admiration to (MSc. Wria
muhamad) for guiding us through each and every step of the process with knowledge and
support. We want to offer our thankfulness to the almighty God who had given us the power,
good sense, and confidence to complete our project successfully. In completing this graduate
project, we have been fortunate to have help, support and encouragement. We sincerely
acknowledge and thank our family members and friends who gave moral support and confidence
for us.

ABSTRACT

5
 Over the past two decades, the manual attendance management has been carried across
most of educational institutions. This is to overcome the problem of manual purchase; in this
project we have developed “Inventory Management System”. This Inventory Management
System is based on web server, which can be implemented on any computer in anywhere even
around the world. In This project, there are three different techniques has been utilized to develop
this system. First, Node.js is server side language. encode, MySQL is used for database. Third,
HTML, CSS, JavaScript, JQuery and Ajax are used as front-end tools for design the project. The
system communicates with database residing on a remote server. It calculates automatically, the
absence percentage of students without any manual paper-based work. They tool which are
utilized in the system are the most modern and advanced techniques. Particularly, in the secure
aspects, strong protection has been used including hashing passport.

LIST OF FIGURES

6
Figure 1 : URLExample..................................................................................................................................7
Figure 2: Xampp.........................................................................................................................................12
Figure 3 Design of Inventory Management system....................................................................................14
Figure 4 Design of Administrator Website.................................................................................................15
Figure 5 Design of cashier User..................................................................................................................2
Figure 6: all tables........................................................................................................................................2
Figure 7: user table.......................................................................................................................................3
Figure 8: category table................................................................................................................................3
Figure 9: brand table....................................................................................................................................3
Figure 10: products......................................................................................................................................4
Figure 11: Sell table.....................................................................................................................................4
Figure 12: login form...................................................................................................................................5
Figure 13: setting inventory..........................................................................................................................5
Figure 14: add administrator........................................................................................................................6
Figure 15: admin management.....................................................................................................................6
Figure 16: add product table........................................................................................................................7
Figure 17: list of product..............................................................................................................................7
Figure 18: discount form..............................................................................................................................8
Figure 19: brand form..................................................................................................................................9
Figure 20: brand menu...............................................................................................................................10
Figure 21: Side menu.................................................................................................................................11

TABLE OF CONTENTS

7
Chapter 1....................................................................................................................................................1
INTRODUCTION..................................................................................................................................1
1.1 Overview...........................................................................................................................................1
1-2. The Project problem.......................................................................................................................2
1-3. The aim of the project.....................................................................................................................2
1-4. Project objectives............................................................................................................................2
1-5. Limitation........................................................................................................................................3
1-6. SCOPE OF THE PROJECT:.........................................................................................................3
1-7. Researches organize:.......................................................................................................................3
Chapter 2....................................................................................................................................................5
LITERATURE REVIEW AND BACKGROUNDS.............................................................................5
2.1 Related Works..................................................................................................................................5
2.2 Inventory Management System.......................................................................................................5
2.3 BACKROUNDS................................................................................................................................6
2.3.1 Website...........................................................................................................................................7
2.3.2 website vs web page.......................................................................................................................7
2.3.3 HTML5:.........................................................................................................................................7
2.3.4. CSS:...............................................................................................................................................9
2.3.5 Bootstrap4......................................................................................................................................9
2.3.6 JQuery:.........................................................................................................................................10
2.3.7 PHP 7:.........................................................................................................................................10
2.3.8 JavaScript:...................................................................................................................................11
2.3.9 xampp :........................................................................................................................................12
CHAPTER 3.............................................................................................................................................14
DESIGN AND IMPLEMENTATION................................................................................................14
3.1 Design..............................................................................................................................................14
3.1.1. Administrator Website...........................................................................................................14
3.1.2. Cashier.....................................................................................................................................15
3-2. Database design:..............................................................................................................................2
3.3 Implementation...................................................................................................................................5
CHAPTER 4.............................................................................................................................................12
CONCLUSION AND FUTURE WORKS..........................................................................................12

8
 4-1. Conclusion.......................................................................................................................................12
4-2. Future Work....................................................................................................................................12
References.................................................................................................................................................13

LIST OF ABBRIVATIONS

HTML Hyper Text Markup Language

9
CSS Cascading Style Sheets
AJAX Asynchronous JavaScript and XML
URL Uniform Resource Locator
HTTP Hypertext Transfer Protocol
OS Operating System
I/O Input Output
API Application Programming Interface
DNA Deoxyribonucleic Acid
XML Extensible Markup Language
IBM International Business Machines
PHP Hypertext Preprocessor
SQL Structured Query Language
DBMS Database Management System
ASP Active Server Pag

10
 Chapter 1

INTRODUCTION

1.1 Overview
Recently, Inventory has become one of the well-known website in the World Wide Web
because most of the business transformed from the market to online. such as www.ebay.com,
www.amazon.com, www.abebooks.com and so on. Also, one the business has mostly
transformed to online system is purchase goods. For example www.ebay.com is an online system
to sell goods; even second-hand products can find them on this website.

In our project we are going to build a website to sale products in Kurdistan regional
government because until now there is not any e-commerce website to sell goods, there are some
websites, but none of them are perfecting works.

Totally, this project consists of two main different websites. The first website is for
administration and second one is for general users.

Administration website, the managers can insert new information to the website. Another
advantage of this project is the website can have more than one administrator.

Second website of this project is for general user. In here user can search for any available books
in our website, even though, they can use some filtration to find the purposed book easily.

1
1-2. The Project problem
The main purpose of this project is to build a website to sell products including Brand
new goods, second-hand goods and rare products. In Kurdistan there is not any website to sell
goods that is why we are going to build this website. Furthermore, the goals of using PhP with
MySQL to build this website are, firstly, PhP is easy to use, and secondly, you can provide a
better security for our website. Also, PhP has amazing performance. It is as a new tool is used
because there is new functionality that we can use easily.

1-3. The aim of the project

The main purpose in this research is making a website for absent systems at the university
of Sulaimani that the lecturers can have an account. As well as, student also can have an account
for knowing the daily, weekly and yearly information, such as absent rates. Also, lecturers can
see the subjects with different departments and different stages, furthermore, lecturer can do the
absent systems. The head of departments, who are administrator, can insert, modify or delete the
lecturers and subjects. Another benefit of the system is to know about the rates of the student
absents by the administrators and lecturers.

1-4. Project objectives

The Objectives of this project is classified to sub-objects:

 This project is used for sale products via using website, it does not need a specific
program to run the application.
 It does not need for reader to spend a long way to obtain the book. Also, nowadays, roads
and streets are crowed and it needs more time to buy a book.
 The most important advantage of an online bookstore is less of cost for readers.
 Familiarizing the Kurdish reader to online bookstore.
 It allows you to buy books while relaxing at home at any time of the day or night.

2
  Sometimes you can also hunt for great deals as most online bookstore invariably offer big
discount for newly released books, or offer of free shipping if your order is above a
certain amount.

1-5. Limitation
The Limitation of this project classified as: -

In this project PhP is used, the possible opportunity for PhP is different types of tools
including sublime; a possible opportunity for the database is MySQL. Also, (Bootstrap and CSS)
are used for giving an amazing design to in front of the website. PhP is based on the JavaScript
which can have the most modern design for the website. Moreover, it has the security login page
for the website. There is the list of students which available for each level and departments, the
lecturer can see the list of student for his/her own subjects.

The subject is available for each stage for each department including the scores and units of the
subject.

The limitation of this project is university of Sulaimani.

1-6. SCOPE OF THE PROJECT:

As a first test, this project is work in Kurdistan regional government, because it is not
easy to cover all the costs to make this website as a global website.

1-7. Researches organize:

In chapter one, firstly, overview of this research is written, the overview is covered the short
description of this research. Then problem statement has explained, as well as aim and objects are
clarified, such as this project is built by usingNode.js. Also, limitation of the project is written, finally,
research outline.

In chapter two, the background information and literature review about this project is written. In
the literature review some previous works have been discussed, also, in the background information, the
necessity of the project has been explained.

3
 In chapter three, the design and implementation of the project is explained. The design of this
projects include design of whole system, also database and diagrams as well as the methodology, the
implementation of whole website has been discussed. The main two parts including admin part and
general user part have been explained in detail. The implementation is explained with different types of
page figures.

In chapter four, both future works and conclusion are illustrated. Future work includes all future
works that we want to add for this project. Also the main conclusion which we got from this project has
been discussed.

In chapter four, both future works and conclusion are illustrated. Future work includes all future
works that we want to add for this project. Also the main conclusion which we got from this project has
been discussed.

4
 Chapter 2

LITERATURE REVIEW AND BACKGROUNDS

2.1 Related Works

2.2 Inventory Management System

2.3 BACKROUNDS

5
2.3.1 Website

A website is a collection of web pages (documents that are accessed through the Internet),
such as the one you're looking at now. A web page is what you see on the screen when you type
in a web address, click on a link, or put a query in a search engine. A web page can contain any
type of information, and can include text, color, graphics, animation and sound. [CITATION
com19 \l 1033 ][ CITATION Lea161 \l 1033 ]

A web page or web page is a document commonly written in HyperText Markup

Language (HTML) that is accessible through the Internet or other network using an Internet
browser. A web page is accessed by entering a URL address and may contain text, graphics, and
hyperlinks to other web pages and files. The page you are reading now is an example of a web
page.[CITATION com19 \l 1033 ]

2.3.2 website vs web page

A website refers to a central location that contains more than one web page.
For example, Computer Hope is considered a website, which includes thousands of
different web pages, including this web page you are reading now.

Figure 1 : URLExample

In the above URL example, the website is computerhope.com and the web page is
"url.htm" and is always the last part of the URL[4]

6
2.3.3 HTML5:

HTML5 is the most exciting step forward in web development since the launch of
XHTML 1.0 in the year 2000. HTML5 is the future of web design, but it can be implemented
right now; and yet it does not make any of your current knowledge of HTML4 or CSS2
redundant. It is a welcome enhancement that increases the flexibility and usefulness of HTML. It
also solves some problems; for instance, it can dispense with plugins for embedded video and
audio clips, and the number of video file formats is drastically reduced. A raft of new semantic
tags makes coding and maintaining a web site much easier. The number of DOCTYPES is
reduced from six to two, and the HTML5 DOCTYPES are so brief that you can easily commit
them to memory. HTML5 has brought agreement between the browser vendors because they
participated in its formulation. This means that the way they handle coding errors is now
standardized; all those little differences are ironed out. A browser’s parsing rules as specified by
HTML5 ensure that all existing web sites continue to function as before; HTML5 is backwardly
compatible. Because this chapter focuses on the aspects of HTML5 that will enhance the most
common types of web site, you will not find a comprehensive discussion on APIs (Application
Programming Interfaces); nor will you find a history of the development of HTML5. Several
books are available on APIs and the history of HTML5. They cover those topics very well;
duplicating them would be pointless (see the tip at the end of the chapter for a list of resources).
The chapter ends with a brief mention of some APIs, but it is probably safe to assume that the
great majority of web designers and site owners are not yet implementing them on traditional web
sites. This view is reinforced by a recent poll taken by CSS Tricks (http://css-tricks.com). Two
years after the release of the APIs, the poll asked web designers the following question: Which
HTML5 features have you implemented on production sites? The results were as follows:
Semantic tags 58% Forms 36% Audio/video 30% Other 16% CHAPTER 1 ■ MOVING TO
HTML5 2 The “Other”16 percent was split between nine APIs: Canvas, Web Workers, Web
Storage, Geolocation, Drag and Drop, ContentEditable, History, and Microdata. The total adds up
to more than 100 percent because most respondents implemented more than one feature. Moving
to HTML5 Now is the time to take advantage of the new features in HTML5; by trying the
projects in this and subsequent chapters, you will discover the benefits and enhancements made
possible by the new version of HTML. The emphasis of this book is the word Practical in the
7
title; therefore, I have “cut to the chase” and provided fully-worked projects covering all the most
useful new features of HTML5. I expect you are eager to get started, so let’s move on! The
HTML5 and XHTML5 DOCTYPES HTML 4/XHTML have several DOCTYPES, but
HTML5/XHTML5 have only one DOCTYPE each, as follows: HTML5: meta details go here
XHTML5: meta details go here.[ CITATION Pra15 \l 1033 ]

2.3.4. CSS:

CSS allows you to separate presentation from content when building a Web site. Put
another way, HTML itself is rather limited in what it can effectively display. It’s fine for holding
or describing content (such as a paragraph of text), but the appearance of raw HTML Web pages
isn’t very stylish (to put it kindly). With HTML, you often can’t find an easy way — or any way
at all — to display the content so that it looks really good when someone views it in a browser.
Using CSS techniques, you can often make your site much more attractive, and at the same time,
enforce style rules that help unify the entire site’s appearance across all its pages. In this book,
you find out how to wrap your online content in appealing visual designs using CSS, including
special dramatic effects such as animated transitions between images or entire pages. Style sheets
can provide striking, well designed containers into which relatively plain HTML content is
poured. The best Web pages aren’t merely efficient, logical, and stable — they also look really
cool. The end result of employing CSS is a more attractive Web site with a more coherent,
effective overall design. [ CITATION CSS15 \l 1033 ]

2.3.5 Bootstrap4:
Bootstrap has become a very popular tool in front-end projects over the years. The
framework's ease-of use along with its cross-browser compatibility, support for mobile user
interfaces, and responsive web design capabilities, make it an essential building block for any
modern web application. The course will enable you to rapidly build elegant, powerful, and
responsive interfaces for professional-level web pages using Bootstrap 4. At the beginning of the
course, take a deep dive into the Bootstrap frontend framework with the help of examples that
will illustrate the usage of each element and component in a proper way. By seeing examples,
you will get a better understanding of what is happening and where you want to reach. With this
8
guide, along the examples, you will get confident with the framework and develop some very
common examples using Bootstrap. These are a landing page, a web application, and a
dashboard, which is desired by 10 out 10 web developers. Second module is comprehensive
tutorial, which will teach you everything that you need to know to start building websites with
Bootstrap 4 in a practical way. You'll learn about build tools such as Node, Grunt, and many
others. You'll also discover the principles of mobile-first design in order to ensure your pages can
fit any screen size and meet the responsive requirements. This guide will make sure you're geared
up and ready to build amazingly beautiful and responsive websites in a jiffy. By third module, get
to the grips with Bootstrap's key features and quickly discover the various ways in which
Bootstrap can help you develop web-interfaces You will know how to both extend the
framework, integrate it with third-party components and frameworks, as well as optimize and
automate your Bootstrapped builds.[ CITATION Boo16 \l 1033 ]

2.3.6 JQuery:

JQuery is a fast, small, and feature-rich JavaScript library. It makes things like
HTML document traversal and manipulation, event handling, animation, and Ajax
much simpler with an easy-to-use API that works across a multitude of browsers. If
you're new to jQuery, we recommend that you check out the Center, If you're
updating to a newer version of jQuery, be sure to read the release notes published
on our blog. If you're coming from a version prior 1.9, you should check out the 1.9
Upgrade Guides as well [9].

2.3.7 PHP 7:
PHP 7: Object-Oriented Modular Programming using HTML5, CSS3, JavaScript, XML, JSON,
and MySQL is intended for use as a beginning level programming book. It is not the goal of this
book to cover advanced techniques in the current versions of the PHP programming language.
Some knowledge of general programming concepts is expected but no actual programming
9
experience or education is assumed. All code examples in this book are compatible with PHP 7.
Most examples are compatible with PHP 5.6. The newest (as of the publication date) methods
(functions) available in PHP have been used to provide the reader with the most current coding
techniques. The examples use core methods provided in the PHP language. PHP includes many
additional methods to accomplish similar tasks. The reader may, and should, research additional
ways of improving security, performance, and other techniques. It is the goal of this book to
prompt users to always consider using the most secure and efficient methods of program
development. The code in this book provides some examples of using these techniques. The user
should remember that no program is 100% secure. The programmer can only strive to make an
application as secure as possible. It takes a team of developers, network personnel, security
administrators, data center personnel, and others working together to provide the safest
environment.[ CITATION PHP16 \l 1033 ]

2.3.8 JavaScript:
JavaScript was developed by Brendan Eich, a developer at Netscape Communications
Corporation, in 1995. Its initial development was very rapid, and much of the criticism leveled at
JavaScript has cited the lack of planning foresight during its development. However, Brendan
Eich was not a dabbler: he had a solid foundation in computer science, and incorporated
remarkably sophisticated and prescient ideas into JavaScript. In many ways, it was ahead of its
time, and it took 15 years for main‐ stream developers to catch on to the sophistication the
language offered. JavaScript started life with the name Mocha, and was briefly named Live Script
before being officially renamed to JavaScript in a Netscape Navigator release in 1995. The word
“Java” in “JavaScript” was not coincidental, but it is confusing: aside from a common syntactic
ancestry, JavaScript has more in common with Self (a proto-type based language developed at
Xerox PARC in the mid-’80s) and Scheme (a language developed in the 1970s by Guy Steele and
Gerald Sussman, which was in turn heavily influenced by Lisp and ALGOL) than with Java. Eich
was familiar with both Self and Scheme, and used some of their forward-thinking paradigms in
developing Java‐ Script. The name JavaScript was partially a marketing attempt to tie into the
success Java was enjoying at the time.1 In November 1996, Netscape announced that they had
submitted JavaScript to Ecma, a private, international nonprofit standards organization that

10
carries significant influence in the technology and communications industries. Ecma International
published the first edition of the ECMA-26 specification, which was, in essence, JavaScript.
[ CITATION Lea161 \l 1033 ]

2.3.9 xampp :
XAMPP is an AMP stack which lets you install Apache, MySQL and PHP in your
computer together with some other useful software. It has been designed to provide you an easy
installation experience. It’s free and available for Windows, Mac OS and Linux.

Go to XAMPP web site and download the installer based on your operating system.
Installation should be similar to a normal software installation you do in your operating system.

When installing, there would be an option to select whether you want to run Apache and MySQL
as services. If you chose it, Apache and MySQL will start at system boot-up which may not need
if your computer is tight with memory resources or if you are not doing PHP development
frequently. You can change these settings after installation.

Go to the location where you installed XAMPP (usually C:\Program Files\xampp) and

double click on XAMPP Control Panel (xampp-control.exe). This will bring you following
screen.

Click on Start buttons next to Apache and MySQL for starting them.

11
 Figure 2: Xampp

Once opened, you would see XAMPP icon on the right of your task bar. Clicking on that icon
will show/hide XAMPP control panel. To exit from XAMPP, click on Exit button in XAMPP
Control Panel [ CITATION wor19 \l 1033 ].

12
 CHAPTER 3

DESIGN AND IMPLEMENTATION

3.1 Design
the Inventory website consists of two main parts; one of them is administrator website and
another is Cashier user website as shows in figure 8.

Inventory
managment system

Administrator
Cashier
website
Figure 3 Design of Inventory Management system

13
 3.1.1. Administrator Website
As previously mentioned that one of the main part of this online system is administrator
part. In administrator, also there are two other parts; admin and super admin; the responsibility of
admin is add new products, search for specific products for purpose of editing or updating.
Furthermore, edit items and delete items can be deleted in admin part.

However, super admin also have all responsibility of admin, but super admin is the manager of
bookstore, he/she can add new admin or delete the existing admin as shows in figure 8.

Administrator Website

Admin Super Admin

Add New Search Edit Delete Add Delete

products items Admin
item item Admin

Figure 4 Design of Administrator Website

14
3.1.2. Cashier
This type of user only can sell products that available on our system; they cannot see other parts of the
website such as statistics and accounting the system. They only see when they want to sell something.

cashier

Search item Detail Buy it now

Figure 5 Design of cashier User

3-2. Database design:

15
In the figure 6, the list of tables are available, which includes category, marka, product, sell and user.

Figure 6: all tables

In the figure 7, table user can have all information about user logins. The following table includes
password, username, email, zip code, phone and roll.

Figure 7: user table

In the figure 8, category_id, category_name are ustilized in the category table, the category table is about
the category of products such as food, drink, clothes.

16
 Figure 8: category table.

In Marka table includes all information about brands, such as brand name, id and the quantity of available
brand items.

Figure 9: brand table.

Figure 10 is about products including id, barcode, pro_name, category_id, price, qnt, brand_id
and image. This table includes all information about products. This table is the main table.

17
 Figure 10: products

In the Figure 11, all sale products will be registered including the date of the sale and the amount
of each data. This table includes sell_id,sell_product_id,sell_price,sell_qnt and so on, this table is
important for the whole project because it includes all archives information about the sale
product in the past.

Figure 11: Sell table

3.3 Implementation

18
 Figure 12: login form

In the figure 12, the security login will be required, the about image includes the username and password
which are mandatory to enter.

Figure 13: setting inventory

Figure 13 is about managing sale and purchase products; this includes the name of brands, the name of
administrators, the list of discount and the list of products.

19
 Figure 14: add administrator

As shows in figure 14, the administrator can register here, the new admin information will enter
in this forms, then, it will be a member of the system. The system has some administrators who
are registered from this form.

Figure 15: admin management

All information about the administrators are appeared in the figure 15, figure 15 includes all information
such as the role of admins, the mobile number, the email and the name of admins. This form has specific
permission to access, all the administrator cannot access this form.

20
In figure 16, all information about products will entered here. The whole information such as the name of
product, the barcode for each product, the quantity of product, the price of product and the brand of
products are entered in the form of figure 16.

Figure 16: add product table.

figure 17 shows the list of products, all products are available here, the can search for specific products b
using a text in the above textfield.

Figure 17: list of product.

The discount of products are illustrated in the figure 18, this figure has all discounts such as the number of
products and the price with the discount.
21
 Figure 18: discount form

In the following figure, which is figure 19, category is available in the following category, the category
form includes all types of products, this category links to other information about products.

Figure 19: brand form

22
In the figure 20, brand is available in the following category, the brand form includes all brands of
products, this category links to other information about products. the international brands are available in
this form, the brand can be edit and delete on the figure 20.

Figure 20: brand menu

23
 Figure 21: Side menu.

This tool includes all necessary links to pages. Pages like all products, add products, logout button,
setting, report, sale, and admin management.

24
 CHAPTER 4

CONCLUSION AND FUTURE WORKS

4-1. Conclusion
In this study the web site database has designed for inventory. It consisted of several parts such as
purchase, sale, product add, product list and reports. Fortunately, the database was responsive which can
run for computer, iPad, and mobile. One of the properties of this project there have permitted for any users
who is allowed previously. This project has many different users, the different users have different roles,
and some pages have permission, such as permission has for some admin, for example add new user can
be access only by the super admin.

4-2. Future Work

The project is a part of great web site database which will develop in the future. In this study the
part of the project has taken and designed because of time restriction and several functionality of the
database. In the future work, this system will be online, it means administrator can access all pages
outside Kurdistan. Also, the real server will be add to this project. The project has some other future works
such as adding new brand and discount.

25
 References

Pro HTML5 Programming: Powerful APIs for Richer Internet Application Development. (2010). US: Peter
Lubbers, Brian Albers, Frank Salim.

Xampp. (2010). VDM Publishing.

JavaScript and JQuery: Interactive Front-End Web Development Hardcover. (2014). indyan: Jon Duckett,
Gilles Ruppert, Jack Moore.

CSS Web Design For Dummies. (2015). Hoboken, NJ 07030-5774: Wiley Publishing, Inc.

Practical HTML 5 Projects. (2015). Adrian W.West.

Learning PHP 7. (2016). Birmingham B3 2 PB , U k: Antonio Lopez.

Mastering Bootstrap 4. (2016). birmingham: Benjamin Jakobus, Jason Marah.

PHP 7. (2016). Stone Mountain, Georgia USA : Steve Prettyman.

Mastering PHP 7. (2017). birmingham: Branko Ajzele.

Learning JavaScript. (March 2016:). United States of America: Ethan Brown.

Bootstrap 4 – Responsive Web Design. (September 2016). Birmingham B3 2PB, UK.: Packt Publishing Ltd.

working-with-xampp. (n.d.). Retrieved 4 12, 2019, from phpknowhow:

https://www.phpknowhow.com/basics/working-with-xampp/

www.computerhope.com. (n.d.). Retrieved 4 12, 2019, from jargon.

26