New عرض تقديمي من Microsoft PowerPoint.pptx

ZXVXVBVXCVB

1. Bookshop Inventory System Osama Younes Ibrahim Muhammad Sabah Rafiq Wadah Haseeb Ali Supervisor Dr . Tariq Abed Mohammed

2. Abstract Inventory is one of the most visible and tangible aspects of doing business. Raw materials, goods in process and finished goods all represent various forms of inventory. Each type represents money tied up until the inventory leaves the company as purchased products. Likewise, merchandise stocks in a retail store contribute to profits only when their sale puts money into the cash register. In a literal sense, inventory refers to stocks of anything necessary to do business. These stocks represent a large portion of the business investment and must be well managed in order to maximize profits. The purpose of this project is to develop a database inventory system for Book shop. The development of this system will provide more inventory controlling and also give services and facilitate for customers and staffs of bookstore. This project develops a database and data management enhancement platform through incorporation the conventional data gathering and management approaches with the IT applications. It also establish a user friendly system to ease the accessibility, usage and sharing of the available data and information in the developed database.

3. INTRODUCTION Online shopping is the process whereby consumers directly buy goods, services etc. from a seller interactively in real-time without an intermediary service over the internet. Online shopping is the process of buying goods and services from merchants who sell on the Internet. Since the emergence of the World Wide Web, merchants have sought to sell their books to people who surf the Internet. Shoppers can visit web stores from the comfort of their homes and shop as they sit in front of the computer. Consumers buy a variety of items from online stores. In fact, people can purchase just about anything from companies that provide their books online. Books, clothing, household appliances, toys, hardware, software, and health insurance are just some of the hundreds of books consumers can buy from an online store. Many people choose to conduct shopping online because of the convenience. For example, when a person shops at a brick-and-mortar store, she has to drive to the store, find a parking place, and walk throughout the store until she locates the books she needs. After finding the items she wants to purchase, she may often need to stand in long lines at the cash register. The goal of project is to design an online bookstore that sells computer, technical, architecture, sports and various categories books. The book inventories are stored in Mysql database. Customers can access the bookstore web site through the World Wide Web. Customers will be able to search the database to find the books they want, check the availability, and place the order to buy the book using their credit cards. This Application software allow customer to search the inventory of these real bookstores, and display the searching results such as the title, the price and availability of the book.

4. Problem Statement Managing your Online Book Store System may seem tricky, but a Online Bookstore is a part of E-commerce Service System (Application support direct contact with users ). Objectives of the study My objective is to design such an application using which one can say 'goodbye' to the days when you stood in line waiting, and waiting some more for a store clerk to finally check out your items. Online shopping transactions occur instantly-saving you time to get your other errands done! Additionally, unlike a store, online shopping has friendly customer service representatives available 24 hours a day, 7 days a week to assist you with locating, purchasing and shipping your merchandise. My main aim is to design such a book store where customer can visit our site anytime of the day from anywhere to view the available books, choose any of them and can order by paying online or can opt for cash on delivery as well. The administrator will regularly add any new books available to them for sale. The administrator will take books from the reputed publishers and vendors only.

5. Purpose and Scope - Purpose Online Shopping system would have the following goals: -Provide a web user interface to add, view, delete records in different areas. -Provide a user interface to enter computer details. -Provide a user interface to change details of all the computers and accessories. -Provide a user interface for users to explore the store and choose items to buy. - Scope The main scope and deliverables of the project would be to: -Understand and prepare detailed requirement and specifications -Prepare high level and detailed design specifications of the system -Prepare Test Plan and Test cases -Develop the system and coding -Perform unit testing, integration and system testing -Demonstrate a bug free application after suitable modification if needed.

6. Software And Hardware Requirements - Microsoft Windows 7/8. -HTML/PHP. -Apache Server -My SQL - Ms -Office package. -Intel Processor 2.0 GHz or above. -2 GB RAM or more. -160 GB or more Hard Disk Drive or above.

7. INVENTORY The word inventory doesn't have the same meaning in the USA and in the UK. In American English and in a business accounting context, the word inventory is commonly used to describe the goods and materials that a business holds for the ultimate purpose of resale. In American English, the word stock is commonly used to describe the capital invested in a business, while in British English, the sentence stock shared is used in the same context. In the rest of the English speaking world stock is more commonly used, although the word inventory is recognized as a synonym. In British English, the word inventory is more commonly thought of as a list compiled for some formal purpose, such as the details of an estate going to probate, or the contents of a house let furnished. In both British and American English, stock is the collective noun for one hundred shares as shares were usually traded in stocks on Stock Exchanges. For this reason the word stock is used by both American and British English in the term Stock Exchange. Inventories are materials stored, waiting for processing , or experiencing processing. They are ubiquitous throughout all sectors of the economy. Observation of almost any company balance sheet, for example, reveals that significant portion of its assets comprises inventories of raw materials, components and subassemblies within the production process, and finished goods. Most managers don't like inventories because they are like money placed in a drawer, assets tied up in investments that are not producing any return and , in fact, incurring a borrowing cost.

8. INVENTORY MANAGEMENT In any business or organization all functions are interlinked and connected to each other and are often overlapping. Some key aspects like supply chain management, logistics and inventory from the backbone of the business delivery function. Therefore these functions are extremely important to marketing managers as well as finance controllers. Inventory management is a very important function that determines the health of the supply chain as well as the impacts the financial health of the balance sheet. Every organization constantly strives to maintain optimum inventory to be able to meet its requirements and avoid over or under inventory that can impact the financial figures. Inventory is always dynamic. Inventory management requires constant and careful evaluation of external and internal factors and control through planning and review. Most of the organizations have a separate department or job function called inventory planners who continuously monitor, control and review inventory and interface with production, procurement and finance departments.

9. Inventory Important Inventory is one of the biggest costs of capital of any product-based business. If you look at the balance sheet of this type of company, you’re likely to find that inventory makes up a large portion of current assets and uses up a lot of working capital. Inventory control helps avoid the many costs related with buying too much inventory and the strains of going without the needed inventory. While some companies using just-in-time ordering may carry extremely small inventories, nearly any business requires some form of inventory, which is best managed through inventory control systems. If a company can lower inventory, it may find new funds available for expansion or profits. If a company needs to carry more inventory and tight inventory control processes bring inventory levels up, the business could find higher sales, and again higher profits. Using inventory control to optimize your warehouse, stock room, supply room, or storefront is a sure way to cut costs and better manage any kind of product.

10. Typical Ways to Control Inventory 1-Manual 2-Stock Cards 3-Simple Spreadsheets 4-Basic Inventory Software Types of Inventory Systems -The Periodic Inventory System -The Perpetual Inventory System 1-Radio Frequency Identification (RFID) 2-Barcodes

11. Software 1- PHP PHP is a scripting language designed to fill the gap between SSI (Server Side Includes) and Perl, intended largely for the web environment. PHP has gained quite a following in recent times, and it is one of the forerunners in the Open Source software movement. Its popularity derives from its C-like syntax, its speed and its simplicity. PHP is currently divided into two major versions: PHP 4 and PHP 5, although PHP 4 is deprecated and is no longer developed or supplied with critical bug fixes. PHP 6 is currently under development. If you've ever been to a website that needs you to login, you've probably encountered a server-side scripting language. Due to its market saturation, this means you've probably come across PHP

12. ADVANTAGES Of PHP 1.Speed up custom web application development 2.Simplify web application maintenance 3.No need to write additional code 4.Work with databases more efficiently 5.Automate common web development tasks 6.Protect websites from targeted security attacks 7.Perform unit testing efficiently 8.No need to increase web development cost Disadvantages Of PHP -Programmers need to learn PHP frameworks instead of PHP -Quality of PHP frameworks differs -Lack of option to modify core behavior -Affect Speed and performance of websites

13. 2-HTML HTML stands for Hypertext Markup Language. It allows the user to create and structure sections, paragraphs, headings, links, and blockquotes for web pages and applications. HTML is not a programming language, meaning it doesn’t have the ability to create dynamic functionality. Instead, it makes it possible to organize and format documents, similarly to Microsoft Word[9]. When working with HTML, we use simple code structures (tags and attributes) to mark up a website page. For example, we can create a paragraph by placing the enclosed text within a starting <p> and closing </p> tag. Overall, HTML is a markup language that is really straightforward and easy to learn even for complete beginners in website building. 3-CSS CSS stands for cascading style sheets. In short, CSS is a design language that makes a website look more appealing than just plain or uninspiring pieces of text. Whereas HTML largely determines textual content, CSS determines visual structure, layout, and aesthetics. HTML is a markup language, and CSS is a style sheet language. Think “look and feel” when you think CSS

14. 4-MySQL My is the daughter’s name of the MySQL’s co-founder, Monty Widenius . The name of MySQL is the combination of My and SQL, MySQL. MySQL is a database management system that allows you to manage relational databases. It is open source software backed by Oracle. It means you can use MySQL without paying a dime. Also, if you want, you can change its source code to suit your needs[11]. Even though MySQL is open source software, you can buy a commercial license version from Oracle to get premium support services. MySQL is pretty easy to master in comparison with other database software like Oracle Database, or Microsoft SQL Server. MySQL can run on various platforms UNIX, Linux, Windows, etc. You can install it on a server or even in a desktop. Besides, MySQL is reliable, scalable, and fast. If you develop websites or web applications, MySQL is a good choice. MySQL is an essential component of the LAMP stack, which includes Linux, Apache, MySQL, and PHP

15. login page

16. 2.Cashier's home page

17. 3.sales page

18. 4.admin home page

19. 5.Book Category

20. 6.Books section page

21. 7.Transaction History

22. 8.User Management

23. CONCLUSION AND FUTURE WORK - CONCLUSION Inventory management is very important to bookshop and any type of shop, effective inventory management and minimizing this can provide competitive advantage to your firm in the market place. That is why the development of this outstanding piece of work is carried out. This is a perfect solution to the book shops having inventory problems. This work is of great significance because it carries to support customers and sales. Successful inventory book shop management involves balancing the cost of inventory with the benefits of inventory – many small business owners fail to appreciate fully the true cost of carrying inventory which include not only direct cost of storage, insurance and taxes but also the cost of money, tied up in the inventory. Also, in controlling the inventory, it is necessary to establish adequate control over inventory in order and inventory in stock. To implement this as a web application we used PHP as the Technology. PHP (XAMPP) has several advantages such as enhanced performance, scalability, built- in security and simplicity. To build any web application using PHP we need a programming language such as , HTML # and so on. php was the language used to build this application. PHP uses MySQL server to interact with the database as it provides in-memory caching that eliminates the need to contact the database server frequently and it can easily deploy and maintain an PHP application. MySQL was used as back-end database since it is one of the most popular open source databases, and it provides fast data access, easy installation and simplicity. The inventory book shop system will restore calm state of mind to the business of book shops. This judgment is depended on some of the business features, which it has provided for the safety of transaction.

24. -FUTURE WORK There are some limitations for the current system to which solutions can be provided as a future development: 1.The system is not configured for multi- users at this time. The concept of transaction can be used to achieve this. 2.The Website is not accessible to everyone. It can be deployed on a web server so that everybody who is connected to the Internet can use it. 3.Credit Card validation is not done. Third party proprietary software can be used for validation check. 4.I recommend this work to all business both large and small whose inventory management processes are still carried out manually. 5.I recommend that the users of this application make effort to follow the change in information technology, which certainly translates their method of operation into a modern way of information processing. This is important because no matter how efficient the application is, it will not be productive if the user do not use it well.

25. Thanks..