# Development and Application of Sales System Software Based on Computer Network

Authors: Chang Liu
Journal: Wireless Communications and Mobile Computing
 (2022)

---

## Abstract

In order to solve the problem that the automobile sales management becomes more and more complicated, this paper proposes a sales system software platform based on a computer network. The automobile sales management system based on the MVVM framework, with Java as the development language and MySQL as the database, is implemented by the progressive framework Vue in the front end and developed by the Spring Boot framework in the back end. Starting with the design and implementation of the system, the technical framework, functional modules, and implementation processes used to develop the system are studied. The experimental results show that the function tests are normal, the response time of the system client is generally 1-2 seconds, the processing speed is fast, and the influence ability is good. The system improves the comprehensive management ability and promotes the rapid development of automobile industry.


---

## Body

## 1. Introduction

In recent years, with the development of computer technology and the arrival of the Internet era, we have entered the information age. In this digital age, the continuous and rapid development of Internet technology also puts forward new requirements for the traditional automobile sales model. At some times, some defects in the traditional automobile sales model can be solved through the convenience of the network. According to the needs of automobile sales market management, in order to provide perfect services for the majority of car users, the automobile sales and leasing system came into being [1]. It integrates ordering, leasing, replacement, customer service and other businesses. Its successful structure will bring good social and economic benefits to the company and provide simple and fast services to our customers. With the strong support of the state for the automobile industry and the continuous improvement of people’s living standards, it has become a reality for cars to enter the family [2]. The continuous expansion of the application range also puts forward further and deeper requirements for the traditional electronic information and data centralized management of automobile sales. It also makes the development and improvement of automobile sales management system. Based on the network, the mature and stable Internet platform, relevant database system, and Java language with good cross platform portability are used to complete the development of relevant program content to meet the ease of use, stability, and wide use of the system [3]. The automobile online sales management system based on the Internet makes the enterprise break through the limitations of time and space. Both consumers and employees and managers of the enterprise can access the system through the public platform of the network, which has strong timeliness and improves the competitiveness of the enterprise. Because the core part of the system adopts Java language, it solves the problem of cross platform application of software and can be used on any operating system without obstacles. It integrates the functions of ordering, leasing, replacement, customer service, and business management. Its successful structure will bring good social and economic benefits to the company and provide simple and fast services to our customers.


## 2. Literature Review

With the development of information technology, more and more enterprises introduce the concepts of information management and e-commerce into their own management and marketing activities. This not only improves the quality and efficiency of enterprise management but also brings more profits and development space to enterprises. Din and Paul mainly applied data mining technology when analyzing and predicting the real estate market and demonstrated that this technology has a good application effect. Other scholars have applied this situation to issues related to customer relationship management [2]. Guo and others mainly used data mining technology to analyze customer relationship management issues from multiple perspectives, such as customer retention and customer segmentation [4]. Yang and others mainly analyzed and discussed cart decision tree comprehensively according to the actual situation and improved and optimized it under the guidance of Fayyad boundary point determination principle, so as to ensure that the decision tree technology can be widely used in the real estate industry and obtain good practical results. Specifically, the decision tree can be improved from the following two aspects. First, when the decision tree is built, the analysis is carried out after the threshold value of continuous attribute segmentation is selected. In this process, it is not necessary to check all the segmentation points. The second is to properly solve the uneven distribution by adopting specific methods to ensure that this technology has good practical application [5]. Neves and others discussed how to use b/s structure and java development language to develop and design a real estate sales management system with strong scalability and maintainability [6]. Kovács and others mainly used the analytic hierarchy process when dividing the system structure and then set the authority structure. They mainly used the MVC mode when designing the real estate sales management system [7]. After understanding the business development of the real estate market, Guo and others applied GIS and java development technology in the system design to meet the needs of relevant institutions [8]. Sussner and Campiotti took a real estate enterprise as an example to design the system. When analyzing business requirements and system architecture, they applied unified modeling language. When building the real estate sales control management system, they applied Java EE and hibernate technology [9]. In their research, Li and others mainly analyzed the role and development trend of the housing sales system under the current era background, applied Net4.0 and other technologies for system research, development and design, and then tested it, continuously improved work efficiency, optimized and improved the existing business processing process, reasonably adjusted the enterprise structure, and accelerated the development of information construction in the real estate industry [10].With the rapid development of China’s economy, there are more and more sales orders for automobile enterprises. Therefore, an investigation is conducted on the automobile sales information of automobile enterprises. It is found that with the increase of automobile sales information, the sales management of automobile stores is becoming more and more cumbersome. Manual management can no longer meet the current needs. It is error prone and has a large amount of data. Therefore, in order to improve the efficiency of sales management in automobile enterprises, it is necessary to develop an automobile sales management system.


## 3. Research Methods

### 3.1. System Design

#### 3.1.1. System Architecture

The automobile sales management system is developed with b/s architecture and MVVM framework, which is an improved version of the standard MVC mode. The whole system is divided into four layers, namely, Dao layer, service layer, controller layer, and view layer. Dao layer is responsible for the interaction with the database, service layer is responsible for the application logic of the business, controller layer is responsible for the request processing and business process control, and view layer is responsible for page data rendering. The front end of the system is developed by the progressive framework Vue, and the back end is developed by the Spring Boot framework, which reduces the coupling between the front and back ends and realizes the separation of the front and back ends.


#### 3.1.2. Function Module Design

The system is mainly divided into two user roles: administrator and employee, which are as follows:(1)
AdministratorAfter the administrator logs in, the main functions include personal information, employee management, automobile information, sales information, statistical reports, system management, and announcement management [11]. The function module diagram of the administrator is shown in Figure 1.
(2)
EmployeesFigure 1
Administrator function module diagramThe main functions of employees after logging in include announcement information, personal information, car information, sales information, and statistical reports. The function module diagram of employees is shown in Figure2.
(3)
Coding management moduleFigure 2
Employee function module diagramIn order to ensure the consistency of relevant names during information entry, query, data statistics, and other operations of the management system, the system has uniformly coded the information of automobile brands, suppliers, sales outlets, salespeople, and so on. Users only need to select from the drop-down menu during operations.(4)
Daily business management moduleThe daily business management module is divided into three submodules: sales management, purchase management, and inventory management:(i)
Sales management submodule: its main function is to complete the entry of vehicle files, owner files, sales invoices, and other information. It can flexibly handle the sales without vehicle collection, sales without Invoicing, and sales agency business (account registration, insurance, etc.) and automatically charge accounts. Handle sales returns effectively to ensure the accuracy of sales data. Query, statistics, and analysis are carried out for the sold vehicles in a variety of ways, so that the decision-makers of the enterprise can timely and accurately obtain the current market sales situation and provide a scientific and powerful basis for the sales and procurement decisions of the enterprise [12](ii)
Purchase management submodule: its main functions are purchase entry, purchase/return processing, purchase settlement, and purchase classification query and statistics(iii)
Inventory management submodule: inventory management is an important part of enterprise logistics system. The main function and function of inventory is to establish an effective buffer zone between the supply and demand of finished vehicles, so as to reduce the contradiction between the supply and demand of finished vehicles [13]. Scientific and reasonable inventory management can not only promote sales and improve labor productivity but also reduce sales costs and increase economic benefits. The main functions of the module include the management of vehicle in/out notification, vehicle status (in/out time, main performance parameters, storage location, appearance, etc.), vehicle internal allocation management, inventory query, inventory statistical analysis, safety inventory early warning, etc., so as to monitor the inventory status in real time, realize inventory early warning, reduce the inventory level as much as possible, and reduce the backlog of funds(5)
Order contract management moduleThe order contract management module is a management module for sales orders and contracts. It includes the functions of order and contract formulation, modification, summary, execution, query, and statistics.(6)
Plan management moduleBased on the current management system of the enterprise, to meet the actual needs of integrated plan management, an integrated plan management subsystem with purchase plan generation, sales plan management, and other functions is established, which takes the contract as the entry point and aims to meet the needs of enterprise sales and improve work efficiency. Shorten the preparation time of various plans (annual, quarterly, monthly purchase plans, contract to sales plans, etc.), improve the effectiveness and scientificity of the plans, and provide detailed management information. The formulation of the plan is based on the orders, contracts and market forecasts of the enterprise in each period.(7)
Report management moduleThe report management module is a module for managing reports related to the management of enterprise purchase, sales and inventory. Process various forms and time periods of statistical reports according to users’ specific needs, such as sales year, quarter, month, daily report, issue details, and receipt details. This module involves a large number of data query, statistics and report generation, so it is a key and difficult point of the system.(8)
Human resource management moduleThe human resource management module contains the comprehensive functions of enterprise personnel management. It consists of the following functions: personnel file management, labor and personnel management, personnel business assessment, attendance management system, personnel education and training, recruitment management, etc.


#### 3.1.3. Database Design

(1) Database E-R Diagram Design. E-R diagram is an entity connection diagram, which provides a method to represent entities, attributes and connections. It is a conceptual model used to describe the real world [14]. Entities are what we call objects or fields, attributes, and methods, that is, the attributes and methods of an object. E-R diagram is a data description method to describe and display the relationship between data types. E-R diagram can completely map the relationship between real models. The three most important elements in the E-R diagram are entity, attribute and relationship. The E-R diagram is composed of these three points.(2) Database Table Design. The automobile sales management system needs a background database. The system uses MySQL database to store data. The following describes the details of each table in the database.(1) Administrator information table is used to store administrator information, as shown in Table1Table 1
Administrator information table.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyadminIdNumberInt10YesNoadminNameUser nameVarchar20NoYesadminPasswordPasswordVarchar15NoYesadminPhoneTelephoneVarchar20NoYesadminSexGenderInt10NoYesadminAgeAgeInt10NoYesAdminXingmingFull nameVarchar10NoYes(2) Employee information table is used to store employee information, as shown in Table2Table 2
Employee information.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyuserIdNumberInt10YesNoUsername’User nameVarchar20NoYesuserPasswordPasswordVarchar15NoYesuserXingmingFull nameVarchar20NoYesuserSexGenderInt10NoYesuserAgeAgeInt10NoYesuserPhoneTelephoneVarchar20NoYesuserMarkRemarksVarchar255NoYesuserDateEntry timeDatetime15NoYes(3) Automobile information table is used to store automobile information, as shown in Table3Table 3
Vehicle information table.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyshangpinIdNumberInt10YesNoshangpinNameNameVarchar20NoYesshangpinMarkManufactorVarchar20NoYesshangpinMark1ColorVarchar10NoYesshangpinMark2ModelVarchar20NoYesshangpinMark3OtherVarchar40NoYesshangpinDatePurchase timeDatetime15NoYesshangpinZongTotalInt10NoYesshangpinTypeTypeVarchar10NoYes(4) Sales information table is used to store car sales information, as shown in Table4Table 4
Sales information.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyspchuIdOrder noInt10YesNospchuDateTimeDatetime15NoYesspchuZongTotalInt10NoYesspchuJineUnit PriceDouble20NoYesspchuZeTotalDouble20NoYesshangpinIdCar numberInt10NoYesshangpinNameVehicle nameVarchar20NoYesuserIdEmployee numberInt10NoYesuserNameEmployee nameVarchar20NoYesconsumerNameCustomer nameVarchar20NoYesconsumerPhoneCustomer telephoneVarchar20NoYesIn order to overcome the impact of the dynamic changes of the network on the database transmission, the network QoS monitoring technology is introduced, and real-time monitoring is used to lay a good foundation for intelligent transmission control. Add a timestamp at the protocol layer to monitor the network delay, add two fields to each message, and record the last received timestamp (LRT) and the currently sent timestamp (CST). After receiving the message, the receiving end calculates the local packet delay according to the LRT and SCT of the message. At the same time, the processing delay of the message in the network can be obtained by subtracting the processing delay of the opposite end according to the last time stamp (LST) saved by the receiving end and the time when the message is currently received [15].When endB replies a message,
(1)LRT=TB+∆t1,CST=TB+∆t1+∆t2.When endA receives the message from end B, its local
(2)LRT=TA+∆t1.And its current time is(3)CT=TA+∆t1+∆t2+∆t3.At this time, it can be calculated that the bidirectional delay of message sending is(4)CT−LST−CST−LRT.


### 3.2. System Realization

The implementation of this system is divided into two modes: administrator and employee. The system adopts b/s architecture and MVVM framework development, separates the view UI from the business logic, realizes the separation of the front and back ends, and achieves the purpose of understanding the coupling. The interaction between the front and back ends is realized through Axios cross-domain. The front end of the system is developed by the progressive framework Vue. The Vue framework is based on modularization and componentization. The modularization idea is to encapsulate the modules and provide external interfaces. The componentization idea is to piece together complete pages with components to realize code reuse. The front end sends a request to the back end by calling the interface API provided by the back end. After receiving the data returned by the back end, the front end stores the data first and finally renders the page through two-way binding of data [16].The back-end of the system is implemented by the Spring Boot framework. It is mainly responsible for receiving and processing the front-end requests, interacting with the database and returning the required data to the front-end. The back-end does not need to care about how the data is loaded into the front-end and how the front-end pages are rendered [17]. The back-end is mainly divided into three layers, namely, Dao layer, service layer, and controller layer. The controller layer is responsible for receiving and processing the front-end requests and providing the front-end with the interface API to be called. After receiving the front-end requests, it calls the service layer and Dao layer in turn, and finally returns the data to the front-end in JSON format.The database of this system is MySQL database, the server uses the Tomcat server built in springboot, and the development environment is JDK1.8.0. The reason why MVVM framework is adopted is that it has the advantages of low coupling, reusability, independent development, and convenient testing. The operation of the system only requires the user to call the API interface to send a request to the background. The background will process the received request and then return the processing result to the front end. After receiving the data returned from the background, the front end will render it to the page. The interaction process between the front end and the back end of the system is shown in Figure3.Figure 3
Front and rear end interaction diagram.


## 3.1. System Design

### 3.1.1. System Architecture

The automobile sales management system is developed with b/s architecture and MVVM framework, which is an improved version of the standard MVC mode. The whole system is divided into four layers, namely, Dao layer, service layer, controller layer, and view layer. Dao layer is responsible for the interaction with the database, service layer is responsible for the application logic of the business, controller layer is responsible for the request processing and business process control, and view layer is responsible for page data rendering. The front end of the system is developed by the progressive framework Vue, and the back end is developed by the Spring Boot framework, which reduces the coupling between the front and back ends and realizes the separation of the front and back ends.


### 3.1.2. Function Module Design

The system is mainly divided into two user roles: administrator and employee, which are as follows:(1)
AdministratorAfter the administrator logs in, the main functions include personal information, employee management, automobile information, sales information, statistical reports, system management, and announcement management [11]. The function module diagram of the administrator is shown in Figure 1.
(2)
EmployeesFigure 1
Administrator function module diagramThe main functions of employees after logging in include announcement information, personal information, car information, sales information, and statistical reports. The function module diagram of employees is shown in Figure2.
(3)
Coding management moduleFigure 2
Employee function module diagramIn order to ensure the consistency of relevant names during information entry, query, data statistics, and other operations of the management system, the system has uniformly coded the information of automobile brands, suppliers, sales outlets, salespeople, and so on. Users only need to select from the drop-down menu during operations.(4)
Daily business management moduleThe daily business management module is divided into three submodules: sales management, purchase management, and inventory management:(i)
Sales management submodule: its main function is to complete the entry of vehicle files, owner files, sales invoices, and other information. It can flexibly handle the sales without vehicle collection, sales without Invoicing, and sales agency business (account registration, insurance, etc.) and automatically charge accounts. Handle sales returns effectively to ensure the accuracy of sales data. Query, statistics, and analysis are carried out for the sold vehicles in a variety of ways, so that the decision-makers of the enterprise can timely and accurately obtain the current market sales situation and provide a scientific and powerful basis for the sales and procurement decisions of the enterprise [12](ii)
Purchase management submodule: its main functions are purchase entry, purchase/return processing, purchase settlement, and purchase classification query and statistics(iii)
Inventory management submodule: inventory management is an important part of enterprise logistics system. The main function and function of inventory is to establish an effective buffer zone between the supply and demand of finished vehicles, so as to reduce the contradiction between the supply and demand of finished vehicles [13]. Scientific and reasonable inventory management can not only promote sales and improve labor productivity but also reduce sales costs and increase economic benefits. The main functions of the module include the management of vehicle in/out notification, vehicle status (in/out time, main performance parameters, storage location, appearance, etc.), vehicle internal allocation management, inventory query, inventory statistical analysis, safety inventory early warning, etc., so as to monitor the inventory status in real time, realize inventory early warning, reduce the inventory level as much as possible, and reduce the backlog of funds(5)
Order contract management moduleThe order contract management module is a management module for sales orders and contracts. It includes the functions of order and contract formulation, modification, summary, execution, query, and statistics.(6)
Plan management moduleBased on the current management system of the enterprise, to meet the actual needs of integrated plan management, an integrated plan management subsystem with purchase plan generation, sales plan management, and other functions is established, which takes the contract as the entry point and aims to meet the needs of enterprise sales and improve work efficiency. Shorten the preparation time of various plans (annual, quarterly, monthly purchase plans, contract to sales plans, etc.), improve the effectiveness and scientificity of the plans, and provide detailed management information. The formulation of the plan is based on the orders, contracts and market forecasts of the enterprise in each period.(7)
Report management moduleThe report management module is a module for managing reports related to the management of enterprise purchase, sales and inventory. Process various forms and time periods of statistical reports according to users’ specific needs, such as sales year, quarter, month, daily report, issue details, and receipt details. This module involves a large number of data query, statistics and report generation, so it is a key and difficult point of the system.(8)
Human resource management moduleThe human resource management module contains the comprehensive functions of enterprise personnel management. It consists of the following functions: personnel file management, labor and personnel management, personnel business assessment, attendance management system, personnel education and training, recruitment management, etc.


### 3.1.3. Database Design

(1) Database E-R Diagram Design. E-R diagram is an entity connection diagram, which provides a method to represent entities, attributes and connections. It is a conceptual model used to describe the real world [14]. Entities are what we call objects or fields, attributes, and methods, that is, the attributes and methods of an object. E-R diagram is a data description method to describe and display the relationship between data types. E-R diagram can completely map the relationship between real models. The three most important elements in the E-R diagram are entity, attribute and relationship. The E-R diagram is composed of these three points.(2) Database Table Design. The automobile sales management system needs a background database. The system uses MySQL database to store data. The following describes the details of each table in the database.(1) Administrator information table is used to store administrator information, as shown in Table1Table 1
Administrator information table.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyadminIdNumberInt10YesNoadminNameUser nameVarchar20NoYesadminPasswordPasswordVarchar15NoYesadminPhoneTelephoneVarchar20NoYesadminSexGenderInt10NoYesadminAgeAgeInt10NoYesAdminXingmingFull nameVarchar10NoYes(2) Employee information table is used to store employee information, as shown in Table2Table 2
Employee information.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyuserIdNumberInt10YesNoUsername’User nameVarchar20NoYesuserPasswordPasswordVarchar15NoYesuserXingmingFull nameVarchar20NoYesuserSexGenderInt10NoYesuserAgeAgeInt10NoYesuserPhoneTelephoneVarchar20NoYesuserMarkRemarksVarchar255NoYesuserDateEntry timeDatetime15NoYes(3) Automobile information table is used to store automobile information, as shown in Table3Table 3
Vehicle information table.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyshangpinIdNumberInt10YesNoshangpinNameNameVarchar20NoYesshangpinMarkManufactorVarchar20NoYesshangpinMark1ColorVarchar10NoYesshangpinMark2ModelVarchar20NoYesshangpinMark3OtherVarchar40NoYesshangpinDatePurchase timeDatetime15NoYesshangpinZongTotalInt10NoYesshangpinTypeTypeVarchar10NoYes(4) Sales information table is used to store car sales information, as shown in Table4Table 4
Sales information.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyspchuIdOrder noInt10YesNospchuDateTimeDatetime15NoYesspchuZongTotalInt10NoYesspchuJineUnit PriceDouble20NoYesspchuZeTotalDouble20NoYesshangpinIdCar numberInt10NoYesshangpinNameVehicle nameVarchar20NoYesuserIdEmployee numberInt10NoYesuserNameEmployee nameVarchar20NoYesconsumerNameCustomer nameVarchar20NoYesconsumerPhoneCustomer telephoneVarchar20NoYesIn order to overcome the impact of the dynamic changes of the network on the database transmission, the network QoS monitoring technology is introduced, and real-time monitoring is used to lay a good foundation for intelligent transmission control. Add a timestamp at the protocol layer to monitor the network delay, add two fields to each message, and record the last received timestamp (LRT) and the currently sent timestamp (CST). After receiving the message, the receiving end calculates the local packet delay according to the LRT and SCT of the message. At the same time, the processing delay of the message in the network can be obtained by subtracting the processing delay of the opposite end according to the last time stamp (LST) saved by the receiving end and the time when the message is currently received [15].When endB replies a message,
(1)LRT=TB+∆t1,CST=TB+∆t1+∆t2.When endA receives the message from end B, its local
(2)LRT=TA+∆t1.And its current time is(3)CT=TA+∆t1+∆t2+∆t3.At this time, it can be calculated that the bidirectional delay of message sending is(4)CT−LST−CST−LRT.


## 3.1.1. System Architecture

The automobile sales management system is developed with b/s architecture and MVVM framework, which is an improved version of the standard MVC mode. The whole system is divided into four layers, namely, Dao layer, service layer, controller layer, and view layer. Dao layer is responsible for the interaction with the database, service layer is responsible for the application logic of the business, controller layer is responsible for the request processing and business process control, and view layer is responsible for page data rendering. The front end of the system is developed by the progressive framework Vue, and the back end is developed by the Spring Boot framework, which reduces the coupling between the front and back ends and realizes the separation of the front and back ends.


## 3.1.2. Function Module Design

The system is mainly divided into two user roles: administrator and employee, which are as follows:(1)
AdministratorAfter the administrator logs in, the main functions include personal information, employee management, automobile information, sales information, statistical reports, system management, and announcement management [11]. The function module diagram of the administrator is shown in Figure 1.
(2)
EmployeesFigure 1
Administrator function module diagramThe main functions of employees after logging in include announcement information, personal information, car information, sales information, and statistical reports. The function module diagram of employees is shown in Figure2.
(3)
Coding management moduleFigure 2
Employee function module diagramIn order to ensure the consistency of relevant names during information entry, query, data statistics, and other operations of the management system, the system has uniformly coded the information of automobile brands, suppliers, sales outlets, salespeople, and so on. Users only need to select from the drop-down menu during operations.(4)
Daily business management moduleThe daily business management module is divided into three submodules: sales management, purchase management, and inventory management:(i)
Sales management submodule: its main function is to complete the entry of vehicle files, owner files, sales invoices, and other information. It can flexibly handle the sales without vehicle collection, sales without Invoicing, and sales agency business (account registration, insurance, etc.) and automatically charge accounts. Handle sales returns effectively to ensure the accuracy of sales data. Query, statistics, and analysis are carried out for the sold vehicles in a variety of ways, so that the decision-makers of the enterprise can timely and accurately obtain the current market sales situation and provide a scientific and powerful basis for the sales and procurement decisions of the enterprise [12](ii)
Purchase management submodule: its main functions are purchase entry, purchase/return processing, purchase settlement, and purchase classification query and statistics(iii)
Inventory management submodule: inventory management is an important part of enterprise logistics system. The main function and function of inventory is to establish an effective buffer zone between the supply and demand of finished vehicles, so as to reduce the contradiction between the supply and demand of finished vehicles [13]. Scientific and reasonable inventory management can not only promote sales and improve labor productivity but also reduce sales costs and increase economic benefits. The main functions of the module include the management of vehicle in/out notification, vehicle status (in/out time, main performance parameters, storage location, appearance, etc.), vehicle internal allocation management, inventory query, inventory statistical analysis, safety inventory early warning, etc., so as to monitor the inventory status in real time, realize inventory early warning, reduce the inventory level as much as possible, and reduce the backlog of funds(5)
Order contract management moduleThe order contract management module is a management module for sales orders and contracts. It includes the functions of order and contract formulation, modification, summary, execution, query, and statistics.(6)
Plan management moduleBased on the current management system of the enterprise, to meet the actual needs of integrated plan management, an integrated plan management subsystem with purchase plan generation, sales plan management, and other functions is established, which takes the contract as the entry point and aims to meet the needs of enterprise sales and improve work efficiency. Shorten the preparation time of various plans (annual, quarterly, monthly purchase plans, contract to sales plans, etc.), improve the effectiveness and scientificity of the plans, and provide detailed management information. The formulation of the plan is based on the orders, contracts and market forecasts of the enterprise in each period.(7)
Report management moduleThe report management module is a module for managing reports related to the management of enterprise purchase, sales and inventory. Process various forms and time periods of statistical reports according to users’ specific needs, such as sales year, quarter, month, daily report, issue details, and receipt details. This module involves a large number of data query, statistics and report generation, so it is a key and difficult point of the system.(8)
Human resource management moduleThe human resource management module contains the comprehensive functions of enterprise personnel management. It consists of the following functions: personnel file management, labor and personnel management, personnel business assessment, attendance management system, personnel education and training, recruitment management, etc.


## 3.1.3. Database Design

(1) Database E-R Diagram Design. E-R diagram is an entity connection diagram, which provides a method to represent entities, attributes and connections. It is a conceptual model used to describe the real world [14]. Entities are what we call objects or fields, attributes, and methods, that is, the attributes and methods of an object. E-R diagram is a data description method to describe and display the relationship between data types. E-R diagram can completely map the relationship between real models. The three most important elements in the E-R diagram are entity, attribute and relationship. The E-R diagram is composed of these three points.(2) Database Table Design. The automobile sales management system needs a background database. The system uses MySQL database to store data. The following describes the details of each table in the database.(1) Administrator information table is used to store administrator information, as shown in Table1Table 1
Administrator information table.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyadminIdNumberInt10YesNoadminNameUser nameVarchar20NoYesadminPasswordPasswordVarchar15NoYesadminPhoneTelephoneVarchar20NoYesadminSexGenderInt10NoYesadminAgeAgeInt10NoYesAdminXingmingFull nameVarchar10NoYes(2) Employee information table is used to store employee information, as shown in Table2Table 2
Employee information.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyuserIdNumberInt10YesNoUsername’User nameVarchar20NoYesuserPasswordPasswordVarchar15NoYesuserXingmingFull nameVarchar20NoYesuserSexGenderInt10NoYesuserAgeAgeInt10NoYesuserPhoneTelephoneVarchar20NoYesuserMarkRemarksVarchar255NoYesuserDateEntry timeDatetime15NoYes(3) Automobile information table is used to store automobile information, as shown in Table3Table 3
Vehicle information table.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyshangpinIdNumberInt10YesNoshangpinNameNameVarchar20NoYesshangpinMarkManufactorVarchar20NoYesshangpinMark1ColorVarchar10NoYesshangpinMark2ModelVarchar20NoYesshangpinMark3OtherVarchar40NoYesshangpinDatePurchase timeDatetime15NoYesshangpinZongTotalInt10NoYesshangpinTypeTypeVarchar10NoYes(4) Sales information table is used to store car sales information, as shown in Table4Table 4
Sales information.
Field nameField meaningField typeField lengthPrimary keyCan it be emptyspchuIdOrder noInt10YesNospchuDateTimeDatetime15NoYesspchuZongTotalInt10NoYesspchuJineUnit PriceDouble20NoYesspchuZeTotalDouble20NoYesshangpinIdCar numberInt10NoYesshangpinNameVehicle nameVarchar20NoYesuserIdEmployee numberInt10NoYesuserNameEmployee nameVarchar20NoYesconsumerNameCustomer nameVarchar20NoYesconsumerPhoneCustomer telephoneVarchar20NoYesIn order to overcome the impact of the dynamic changes of the network on the database transmission, the network QoS monitoring technology is introduced, and real-time monitoring is used to lay a good foundation for intelligent transmission control. Add a timestamp at the protocol layer to monitor the network delay, add two fields to each message, and record the last received timestamp (LRT) and the currently sent timestamp (CST). After receiving the message, the receiving end calculates the local packet delay according to the LRT and SCT of the message. At the same time, the processing delay of the message in the network can be obtained by subtracting the processing delay of the opposite end according to the last time stamp (LST) saved by the receiving end and the time when the message is currently received [15].When endB replies a message,
(1)LRT=TB+∆t1,CST=TB+∆t1+∆t2.When endA receives the message from end B, its local
(2)LRT=TA+∆t1.And its current time is(3)CT=TA+∆t1+∆t2+∆t3.At this time, it can be calculated that the bidirectional delay of message sending is(4)CT−LST−CST−LRT.


## 3.2. System Realization

The implementation of this system is divided into two modes: administrator and employee. The system adopts b/s architecture and MVVM framework development, separates the view UI from the business logic, realizes the separation of the front and back ends, and achieves the purpose of understanding the coupling. The interaction between the front and back ends is realized through Axios cross-domain. The front end of the system is developed by the progressive framework Vue. The Vue framework is based on modularization and componentization. The modularization idea is to encapsulate the modules and provide external interfaces. The componentization idea is to piece together complete pages with components to realize code reuse. The front end sends a request to the back end by calling the interface API provided by the back end. After receiving the data returned by the back end, the front end stores the data first and finally renders the page through two-way binding of data [16].The back-end of the system is implemented by the Spring Boot framework. It is mainly responsible for receiving and processing the front-end requests, interacting with the database and returning the required data to the front-end. The back-end does not need to care about how the data is loaded into the front-end and how the front-end pages are rendered [17]. The back-end is mainly divided into three layers, namely, Dao layer, service layer, and controller layer. The controller layer is responsible for receiving and processing the front-end requests and providing the front-end with the interface API to be called. After receiving the front-end requests, it calls the service layer and Dao layer in turn, and finally returns the data to the front-end in JSON format.The database of this system is MySQL database, the server uses the Tomcat server built in springboot, and the development environment is JDK1.8.0. The reason why MVVM framework is adopted is that it has the advantages of low coupling, reusability, independent development, and convenient testing. The operation of the system only requires the user to call the API interface to send a request to the background. The background will process the received request and then return the processing result to the front end. After receiving the data returned from the background, the front end will render it to the page. The interaction process between the front end and the back end of the system is shown in Figure3.Figure 3
Front and rear end interaction diagram.


## 4. Result Analysis

System function test includes link test, programming language test, form test, data addition, editing, deletion test, and input and query test. Figure4 shows the current number of customers counted by the system. After querying the database for comparative analysis, it can be seen that the system can correctly count the number of customers, and the data calculation is correct and can meet the corresponding requirements. Other content items of this system function test can also meet the needs of dealers, including links, forms and page display, which will not be listed in detail here. The system performance test is used to check whether the system can return the prompt for correct processing and whether the system exception handling meets the expectations. In addition, it also includes whether the system architecture can withstand the heavy load business capability, the system response capability, the system throughput, etc. This system test verifies the login reminder of the system [18].Figure 4
Statistics of customer information by month.The system designed in this paper can make friendly reminders for the abnormal conditions of login. The test results are consistent with the expectations. Other abnormal conditions can also be reminded, which will not be listed in detail here. For the test of system architecture load capacity, response capacity and throughput, in the local test phase, the response time of the system client is generally 1-2 seconds, with fast processing speed and good impact capacity. In the remote test stage, the response capability of the system is related to the user’s hardware and network performance [19]. This test has only been tried in a small range. Therefore, at present, the load test and stress test cannot be fully implemented, which will be the focus of the next test of the system. System availability test is to evaluate the availability of the system and check whether the system meets the availability standard. According to the classification of evaluators, it can be divided into expert evaluation and user evaluation. According to the evaluation stage, it can be divided into formative evaluation and summative evaluation. For this availability test, system users are invited to make a summary evaluation. After testing, the system has been well received in interface design and navigation, but some functions are insufficient and need to be further improved.


## 5. Conclusion

Automobile sales management system is an important part of automobile sales enterprises. The development of this system strengthens the management of automobile sales information, improves the comprehensive management ability, and promotes the rapid development of automobile industry. This paper designs and implements an automobile sales management system based on the sales orders of automobile enterprises. The system adopts IntelliJ idea and visual studio code compilation software, Tomcat server, MySQL database, jdk1.8.0 development environment, and Google Chrome browser, including two modes of employees and managers. The development of this system will promote the application and development of information technology in automobile sales enterprises and improve the core competitiveness of automobile enterprises.



---

*Source: 4524698-2022-08-03.xml*