VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION PROJECT BUILD A TOUR MANAGEMENT WEBSITE Vũ Đức Long Hanoi - Year 2024. 1 VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION PROJECT BUILD A TOUR MANAGEMENT WEBSITE SUPERVISOR: DO TIEN THANH (Academic title, academic degree, full name) STUDENT: VU DUC LONG STUDENT ID: 19071615 COHORT: QH-2019 SUBJECT CODE: INS401401 MAJOR: Informatics And Computer Engineering Hanoi - Year. 2 ACKNOWLEDGMENT With sincere respect and gratitude, I would like to express my deep gratitude to MSc. Do Tien Thanh orientated and guided me enthusiastically throughout the research process so that I could successfully complete my thesis.
I would like to sincerely thank the teachers of the Faculty of Applied Sciences, VNU, for their dedicated help and creating conditions for me to study, improve my knowledge and skills to complete my thesis. Thesis Faculty of Applied Sciences. In the process of writing a graduation thesis, even though you try your best, it is still difficult to avoid shortcomings. I look forward to receiving comments from my teachers to make my graduation essay more complete.
Sincerely thank! 3 DECLARATION OF AUTHORSHIP I declare that this is my own research work is supervised by M. Do Tien Thanh. The content and research results in this topic are honest and have never been published in any form before. The data in the analysis, comments, and evaluation tables were prepared by the author and collected from many different sources and are clearly stated in the reference section.
In addition, the article also uses data, images, and information from other authors and organizations, all with citations and sources. If any fraud is discovered, I will take full responsibility for the content of my article. International University is not involved in any copyright issues or copyright violations caused by me during the implementation process, if any. Ha Noi,Day 25 month 05 year 2024 Author Vũ Đức Long 4 SUMMARY Demand for tourism services is increasingly not only in VietNam but also other countries.
Grasping the situation, the essay builds a tour management website for meeting most of the essential needs of the tourism service industry. For the purpose of creating a website to manage tours for each specific location; corporate member customer management; manage news, articles introducing restaurants, hotels with the best service for customers to refer; manage comments, contacts, and feedbacks from customers so that the company can answer questions and improve service better; manage tour orders clearly and transparently to create trust for customers, ensure safety, security and meet important functions of a tour management website such as: Provide users with the most accurate and specific information about the best tour packages, restaurants and hotels, and help users easily pay, book tours and track the status of their orders. Helping users to trust more about the service through comments, feedback, and online contact on the system. Help manage tour packages, manage customers and manage revenue by day, week, month, year effectively.
The system operates stably and has high information security. 5 TABLE CONTENTS ACKNOWLEDGMENT. 3 DECLARATION OF AUTHORSHIP .1 Reason for implementing the topic .3 Subjects and scope of research .5 Scientific and practical significance .6 Layout of the thesis. 14 CHAPTER 2: LITERATURE REVIEW .1 Introduction to Tour Management Systems .2 Evolution of Tour Management Systems .3 Key Components and Functionalities.5 Benefits and Challenges .6 Case Studies and Examples.
17 CHAPTER 3: CHOOSING THE TOOL. Introduction to PHP language. Introduction to MySQL. Introduction to HTML .4 Introduction to CSS.
20 CHAPTER 4: REQUIREMENTS ANALYSIS .1 Introducing the topic .2 Analyze and determine requirements .2 Non-functional requirements. 22 6 CHAPTER 5: DESIGN OF THE APPLICATION .1 General use cases.2 Usecase for article management .3 Usecase for tour booking management .4 Usecase for customer management.5 Contact management usecase .6 Admin management usecase .7 Site management usecase _ collaborator .8 Usecase tour management _ collaborator .9 Usecase tour management _ collaborator .10 Usecase management Admin _ collaborator .16 Usecase book tour .17 Usecase online paying .1 Usecase location management .2 Usecase Tour management .3 Usecase for article management .4 Usecase for tour booking management .5 Usecase for comment management .6 Usecase for customer management.7 Contact management usecase .8 Admin management usecase .9 Site management usecase _ collaborator .10 Usecase tour management _ collaborator .11 Usecase of tour booking management _ collaborator .12 Admin _ collaborator management usecase .18 Usecase of tour booking.19 Electronic payment usecase .5 Book_tours Table .5 Instance of the database.5 Book_tours Table. 64 CHAPTER 6: DEVELOPMENT OF THE APPLICATION .1 Admin login page .2 Admin home page .3 Location management page .4 Tour management page.5 Article management page.6 Tour booking management page .1 Test location management functionality .2 Test the tour management function .3 Edit the code according to reviewer comments .1 Summary of Achievements .2 Challenges and Solutions: .1 Integration of Features. Logo of PHP .2 Introduction to HTML .1 General use case .2 Use case for location management .4 Usecase for article management .5 Usecase for tour booking management.6 Usecase for comment management .7 Usecase for customer management .8 Contact management usecase .9 Admin management usecase .10 Site management usecase _ collaborator .11 Usecase tour management _ collaborator .12 Usecase tour management _ collaborator .13 Usecase management Admin _ collaborator .19 Usecase book tour .20 Usecase online paying .26 Book_tours table .1 Admin login page interface .2 Admin home page interface .3 Location management page interface .4 Tour management page interface .5 Article management page interface .6 Tour booking management page interface .7 UI_LC_01: Check the title path of the site management page.8 UI_LC_02: Check the interface of the “List of locations” form.9 FT_LC_01: Successfully added new location with valid location name, location, featured location, status, and image (1).10 FT_LC_01: Successfully added new location with valid location name, location, featured location, status, and image (2).11 FT_LC_02: Display the warning "Deleted data cannot be recovered, please consider" when clicking on the delete button.12 FT_LC_03: The location is successfully deleted and displays the message “Deleted successfully”.13 UI_T_01: Check the title and link of the tour management page .14 UI_T_02: Check the “Tour List” form interface.15 UI_T_03: Check the search bar in the tour list.16 FT_T_01: Successfully added new tour location, tour title, tour code, tour price, number of customers, travel time, departure date, return date, vehicles, sale, images, schedule, policies, content valid (1) .17 FT_T_01: Successfully added new tour location, tour title, tour code, tour price, number of customers, travel time, departure date, return date, vehicles, sale, images, schedule, policies, content valid (2) .18 FT_T_02: New addition failed with tour location, tour title, tour code, tour price, number of customers being null.19 FT_T_03: Successfully view tour details when clicking on the tour in the tour list (1).20 FT_T_03: Successfully view tour details when clicking on the tour in the tour list (2).21 FT_T_04: Successfully entered the tour editing page when clicking on the "Update" button.22 FT_T_05: Successfully edited tour with tour location, tour title, tour code, tour price, number of valid customers (1) .23 FT_T_05: Successfully edited tour with tour location, tour title, tour code, tour price, number of valid customers (2) .24 FT_T_06: Successfully changed the tour status when selecting the "Show" "Hide" button.25 FT_T_07: Successfully delete the tour when clicking the "Delete" button (1).26 FT_T_07: Successfully delete the tour when clicking the "Delete" button (2).27 FT_T_08: Successfully searched for tours by tour name.28 FT_T_09: Successfully searched for tours by location .29 FT_T_10: Successfully searched for tours by ID Tours.1 Reason for implementing the topic Currently, the demand for tourism services in our country is improving.
Not only does it attract a large number of domestic tourists, but it also receives special attention from foreign tourists. However, Vietnam's tourism industry has not been able to develop strongly due to weak infrastructure, service quality and tourism management, leading to limited quality of tourism communication, making it difficult for the tourism industry to reach. In addition, Vietnam's tourism industry is being warned about "cutting and cutting", kidnapping tourists, inaccurate images and content, providing poor services that are far from expectations, thereby losing trust. of tourists, making Vietnam's tourism industry increasingly decline.
Therefore, to solve the above problems for the tourism industry, the author chose the topic: "Building a tourism management website" to research and implement. Thanks to the diversity, prestige, speed and efficiency brought by the new system, it increases search efficiency, user experience and achieves high efficiency in the company's management and business, helping Saves a lot of time, effort and money.2 Research purpose Successfully built a tour management website to ensure reputation, service quality as well as improve management quality for travel companies as well as for the Vietnamese tourism industry.3 Subjects and scope of research Subjects: services, management, tours. Scope: within Vietnam.4 Research methods The main methods used in the process of writing graduation essays include: 13 Theoretical research methods Research through reading books, newspapers, and related documents to build the theoretical basis of the topic and necessary measures to solve the problems of the topic. Analysis and design methods Research through analyzing research subjects to solve problems and design program data.5 Scientific and practical significance 1.1 Scientific meaning The research results of the graduation project bring scientific significance in applying information technology to the field of commerce in general and the tourism service industry in particular.2 Practical significance Not only does it solve management difficulties for travel companies, but it also ensures transparency, helping users simplify location selection and payment.6 Layout of the thesis The structure of the thesis includes five chapters: Chapter 1: General introduction Chapter 2: Overview of the topic Chapter 3: System analysis and design Chapter 4: Program interface Chapter 5: Conclusion 14 CHAPTER 2: LITERATURE REVIEW 2.1 Introduction to Tour Management Systems Tour management systems are essential tools for modern travel and tourism businesses, facilitating the organization, booking, and management of tours and related services.
These systems have evolved significantly with advancements in information technology, integrating various functionalities to enhance operational efficiency and customer satisfaction.2 Evolution of Tour Management Systems The development of tour management systems can be traced back to the early use of computer systems in the travel industry. Initially, these systems were primarily used for booking and reservation management. However, with the advent of the internet and e-commerce, tour management systems have transformed into comprehensive platforms that manage all aspects of a travel company's operations, from customer relationship management to financial accounting and marketing.3 Key Components and Functionalities Modern tour management systems typically include a variety of components and functionalities, such as: Booking and Reservations: Allowing customers to book tours online, manage their itineraries, and make payments. Customer Relationship Management (CRM): Managing customer interactions, feedback, and service inquiries.
Content Management: Updating and managing content related to tours, destinations, hotels, and restaurants. Financial Management: Handling invoicing, payments, and financial reporting. Marketing and Promotion: Tools for promoting tours, managing advertising campaigns, and analyzing market trends.4 Technological Frameworks The technological backbone of tour management systems includes various programming languages and database systems. For example: PHP: A popular server-side scripting language that is widely used for developing dynamic web applications.
MySQL: An open-source relational database management system that is commonly used in conjunction with PHP for managing and querying data. HTML and CSS: Fundamental technologies for building and styling the web interface of tour management systems. JavaScript: Enhances the interactivity and functionality of web pages, often used alongside AJAX for asynchronous web applications.5 Benefits and Challenges Implementing a tour management system offers several benefits, including improved efficiency, better customer service, and enhanced data security. However, there are also challenges such as the need for continuous updates, handling large volumes of data, and ensuring system security against potential cyber threats.6 Case Studies and Examples Several case studies highlight the successful implementation of tour management systems in different contexts.