VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION PROJECT WEBSITE DEVELOPMENT ABOUT RICE RUBBER COMPANY Student’s name: Nguyễn Thành Trung Hanoi - Year 2024 VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION PROJECT WEBSITE DEVELOPMENT ABOUT RICE RUBBER COMPANY SUPERVISOR: MSc Phạm Hải Yến STUDENT: Nguyễn Thành Trung STUDENT ID: 19071637 COHORT: QH2019 SUBJECT CODE: INS4014 MAJOR: Informatics and Computer Engineering – ICE2019 Hanoi - Year 2024 TABLE OF CONTENT TABLE OF CONTENT. 1 LIST OF FIGURES. 3 LIST OF TABLES. 5 ABBREVIATIONS AND TERMS.
8 CHAPTER 1: OVERVIEW OF THE WEBSITE SYSTEM. Overview of the Project Website. Warehouse Management Concept.2 Main Professional Content .3 Tools and Technical Platforms .3 PHP Programming Language [1].4 Combination of Laravel and PHP [4] .io Online Tool [2] .5 Main Structure of the Project. 19 CHAPTER 2: DESIGN MODEL OF THE WAREHOUSE MANAGEMENT WEBSITE .1 Description of Business Processes .2 Use Case and System Specifications .1 Use Case Diagram Model .2 Use Case Specification .3 Functional Hierarchy Diagram .4 Data Flow Diagrams .1 Context Level Data Flow Diagram .2 Level 1 Data Flow Diagrams .1 Conceptual Database Design .2 Logical Database Design.
Error! Bookmark not defined.3 Physical Database Design. 72 CHAPTER 3: IMPLEMENTATION OF THE WAREHOUSE MANAGEMENT WEBSITE .3 Dashboard - Home Page .5 Invoice Management Interface .6 Inventory Management Interface. 81 CHAPTER 4: GENERAL CONCLUSION AND FUTURE DEVELOPMENT DIRECTIONS .3 Future Development Directions. 86 2 LIST OF FIGURES Figure 1.1 Basic Symbolic Image for Website .2 Structure of a Website .7 Laravel is the Best PHP Framework .io Online Tool .1: General Use Case of the Management System .2: Warehouse Management Use Case .3: Unit Management Use Case.4: Order Management Use Case .5: Customer Management Use Case .6: Product Management Use Case .7: Supplier Management Use Case .8: Category Management Use Case .9: Account Management Use Case .10: Create Warehouse Export Slip Use Case .11: Create Warehouse Import Slip Use Case .12: Shopping Cart Management Use Case .13: Login Use Case .14 Functional Hierarchy Diagram.15 Context Level DFD .16 Level 1 DFD - Inventory Management .17 Level 1 DFD - Order Management .18 Level 1 DFD - Cart Management .20 Level 1 DFD - Inventory Receipt/Dispatch .21 Level 1 DFD - Customer Management .22 Level 1 DFD - Supplier Management .23 Level 1 DFD - Product Management .24 Level 1 DFD - Account Management .25 Level 1 DFD - Payment .26: Logical Database Design.
Error! Bookmark not defined.27: Physical Database Design .3: Home Page Interface .4: Website Category Interface.9: Invoice Management Interface .10: Pending Invoice List .12: Invoice Report Interface .13: Inventory Management Interface .14: Print Inventory Report .15: Inventory Report by Supplier. 82 4 LIST OF TABLES Table 2.1: Use Case Description "Login" .2 Use Case Description for "Account Management" .3 Use Case Description for "Category Management" .4 Use Case Description for "Order Management" .5 Use Case Description for "Customer Management" .6 Use Case Description for "Product Management" .7 Use Case Description for "Warehouse Management" .8 Use Case Description for "Supplier Management" .9 Use Case Description for "Unit of Measurement Management" .10 Use Case Description for "Shopping Cart Management" .11 Use Case Description: "Create Warehouse Receipt" .12: Use Case Description for “Creating Warehouse Dispatch Slip” .13: Sample Data for the "Categories" Entity.14: Sample Data for the "Customer" Entity .15: Sample Data for the "Invoices" Entity .16: Sample Data for the "Invoice_details" Entity .17: Sample Data for the "Migrations" Entity .18: Sample Data for the "Payment" Entity .19: Sample Data for the "Payment_details" Entity .20: Sample Data for the "Products" Entity .21: Sample Data for the "Suppliers" Entity.22: Sample Data for the "Units" Entity .23: Sample Data for the "Users" Entity. 70 5 ABBREVIATIONS AND TERMS No Abbreviation Terms 1 CLI Common Language Infrastructure 2 OOP Object Oriented Programming 3 CDM Conceptual Data Model 4 PDM Physical Data Model 5 RDBMS Relational Database Management System 6 IIS Microsoft Internet Information Server 7 SSAS SQL Server Analysis Services 8 SSRS SQL Server Reporting Services 9 SSIS SQL Server Integration Services 10 ETL Extract, Transform, Load 11 EIT Engineering Institute of Technology 12 UML Unified Modeling Language 13 SAP System Application Programming 14 SQL Structured Query Language 15 BFD Business Function Diagram 16 DFD Data Flow Diagram 17 ERD Entity Relationship Diagram 6 ACKNOWLEDGMENTS As Vietnam advances toward industrialization and modernization, striving to become a foundational industrialized nation, the importance of industrial facilities, including the need for a website, is paramount. This is the basis of my thesis research, which centers on a warehouse management module website for a rubber roller company.
The aim is to manage orders, facilitate business activities related to import and export, and ultimately boost revenue. This objective is the primary motivator for my research. I am profoundly grateful to Ms. Pham Hai Yen for her invaluable guidance, direction, and unwavering support throughout the thesis process.
Her deep expertise and insights significantly influenced my research path and served as a constant source of inspiration. I also extend my heartfelt thanks to the esteemed faculty members at ICE, VNU, International School, and all the exceptional professors who have shaped my academic journey. Their dedication to creating a supportive learning environment greatly impacted my academic growth. While I recognize that this project had the potential for full completion, limitations in time and knowledge have inevitably led to some shortcomings.
7 DECLARATION With the exception of a few specified references, I declare that all the content in this thesis is my original work. It has not been previously submitted for any other academic purpose, and all sources have been properly cited. I understand the gravity of plagiarism, which entails using someone else's work without proper acknowledgment. I certify that this thesis is the result of my own independent research and complies with the ethical standards of the International School - VNU.
Moreover, I affirm the accuracy and validity of all data and findings presented in this thesis. Any opinions expressed are either correctly attributed or are my own. I take full responsibility for the information contained in this document. Date: June 5th, 2024 Nguyễn Thành Trung 8 CHAPTER 1: OVERVIEW OF THE WEBSITE SYSTEM 1.
Overview of the Project Website 1.1 Website Concept A website is a collection of pages containing text, images, videos, audio, etc., hosted on a domain name and served by a web server. Also known as web pages or sites, websites typically reside within a single domain or subdomain and can only be accessed via the Internet.1 Basic Symbolic Image for Website 9 A website is an HTML or XHTML file accessible via HTTP or HTTPS protocols. Websites can be built from HTML files (static websites) or operated by CMS running on a server (dynamic websites). Websites can be created using various programming languages such as PHP, .NET, Java, etc.
Structure and Operation of a Website • Domain Name: The web address that allows users to easily access the site. • Hosting: The server used to store the source code and other components of the website. • Source Code: A system of files written in a programming language that creates the user interface of the website. Additionally, for users to access the website, an internet connection is required.2 Structure of a Website 10 1.
Warehouse Management Concept Warehouse management involves organizing, managing records, inspecting goods, and ensuring a continuous supply process that is timely and quick, with minimal costs and maximized profits.3 Warehouse Management Roles of Warehouse Management: - Preventing loss of goods - Reducing costs - Optimizing revenue and profit - Increasing the turnover of working capital 1.2 Main Professional Content a. Applying basic knowledge of warehouse management: 11 • Product and goods management • Order management • Supplier management: warehouse receipts, payment invoices • Customer management: delivery notes, payment invoices • Account management: accounts with different access permissions b. Applying knowledge and skills to develop a database using MySQL and PHP programming. Additionally, a basic understanding of warehouse management is necessary to create the Warehouse Management Website and complete the Graduation Project Report.3 Tools and Technical Platforms 1.1 MySQL Tool It is developed, distributed, and supported by Oracle Corporation, making it a part of Oracle's suite of Relational Database Management Systems.
MySQL utilizes the Structured Query Language (SQL) for database access and management, offering features such as complex queries, user management, and a graphical interface. It is extensively used in web applications and is among the most popular database management systems worldwide, benefiting from a large community and extensive support. ▪ Optimal Features of MySQL: - High Performance: Optimized for web applications and high-load requirements, utilizing techniques such as indexing, caching, and query optimization. - Data Consistency and Safety: Supports features like transactions and locking to ensure data consistency, along with backup and recovery mechanisms to protect data.
- Scalability: Easily scalable using configurations like replication, sharding, and clustering, allowing it to handle large loads and increasing user numbers. 12 - Cross-Platform Support: Available on many operating systems like Linux, Windows, macOS, and supports various programming languages. - Large Community and Extensive Support: A large community of developers, database administrators, and support professionals provide rich documentation, discussion forums, and technical support.2 Laravel Framework Laravel is an open-source framework for developing web applications using PHP. It is designed to help developers build modern and flexible web applications quickly and easily.
Laravel offers powerful features like routing, session management, authentication, caching, and more, reducing the time and effort required for web development. • Optimal Features: - Organized Project Structure: Provides a well-organized project structure that separates logic and presentation, making the application easy to maintain and extend. - Comprehensive Features: Offers a range of features like powerful routing, smart ORM (Object-Relational Mapping), authentication, caching, queuing, and more, accelerating development. 13 - Easy Integration with External Services: Integrates readily with third-party services like Amazon S3, Redis, and more, simplifying development.
- Open Source and Large Community: Being open source with a large, enthusiastic community means ample documentation, tutorials, and available packages to support development. - Flexibility and Customizability: Allows customization and extension to meet the specific needs of your project despite having default configurations. - Support for APIs and Cross-Platform Applications: Supports developing both web applications and APIs, enabling you to build cross-platform applications, from web to mobile.3 PHP Programming Language [1] PHP, short for "Hypertext Preprocessor," is a server-side scripting language primarily used for developing dynamic websites and web applications. PHP is often embedded into HTML and executed on a web server to create dynamic content before sending it to the user's web browser.
PHP can perform various server tasks, such as file creation and management, database interactions, form processing, and generating dynamic content like forums, e-commerce sites, and more. - Advantages of PHP: 14 - Easy to Learn and Use: Designed to be easy to learn and use, especially for beginners in web programming. Its syntax is relatively straightforward and similar to natural language. - Large Community and Rich Support: Has a large, enthusiastic community of developers providing extensive documentation, tutorials, and online support, making it easy to find solutions to development problems.
- Good Integration with Many Technologies and Services: Easily integrates with popular databases like MySQL, PostgreSQL, and SQLite, as well as external services like Redis, Memcached, and third-party APIs. - Good Web Performance: Optimized for web performance, handling web requests efficiently. PHP applications can be deployed on various popular web servers like Apache, Nginx, and Microsoft IIS. - Flexibility and Extendability: Supports multiple programming paradigms, from object-oriented to functional programming, allowing you to choose the best style for your project.
It also supports a wide range of frameworks and libraries to reduce development time and effort. - Open Source and Free: Being open source means you can use and modify the source code freely without any costs.4 Combination of Laravel and PHP [4] The combination of Laravel and PHP creates a powerful development environment for building modern and flexible web applications.