Visualization method and device based on airline free luggage function

Abstract

The invention relates to a visualization method based on an airline free luggage function. The method comprises the following steps: receiving a login instruction; logging in an AOS system, and opening a free luggage function bar by using an operation and maintenance tool; obtaining dimension data and verifying the dimension data; after the verification is passed, receiving an online change order number and online title data; verifying the change information recorded in the online change order number by using the preview associated online change system; if the verification is not passed, prompting'please input a correct change number ', and if the verification is passed, completing the opening of the free luggage according to a submission instruction; and obtaining a query instruction, and performing query operation on the opened free luggage record. According to the method, the airline code, the service sub-code, the effective date and the deadline are taken as dimensions, the free luggage function is quickly, visually and safely opened for the airline, a database does not need to be logged in, a server configuration file does not need to be manually modified, and the server does not need to be restarted, so that no influence is caused on production service.

Description

Technical Field

[0001] The present application belongs to the technical field of aviation additional services, and in particular, relates to a visualization method and device based on the free baggage function of airlines. Background Art

[0002] In recent years, with the rapid development of the aviation industry and airline fare business, additional services as a value-added service in addition to the basic fare have been increasingly valued by airlines and customers, and free baggage service is an important one among the additional services. Passengers basically have luggage when they take a plane. Airlines have strict requirements on the weight, size, and volume of luggage. Those who meet the requirements will be given free baggage treatment. Therefore, domestic airlines of all sizes need to enable the free baggage function and use it frequently. In the early stage of function activation, it can only rely on manual addition in the database, which is inefficient and does not have a rollback mechanism, which has a great impact on the security of fare data. At present, as China Aviation Information Network pays more and more attention to production safety, the control of personnel who can directly operate the production environment is becoming more and more strict. Safety regulations such as prohibiting direct operation of production databases have been issued one after another, and automated tools are used as much as possible to solve the operation plan on the database side. Therefore, it is necessary to develop new methods and tools for enabling free baggage. Summary of the invention

[0003] In order to address the above problems, the present application proposes a visualization method and device based on the free baggage function of airlines. This method can enable the free baggage function for airlines.

[0004] In summary, this application uses airline code, service subcode, effective and expiration date as dimensions to quickly, visually and safely enable the free baggage function for airlines. There is no need to log in to the database, manually modify the server configuration file, or restart the server, so it will not cause any impact on production services. This application realizes the integration of front-end and back-end databases. The front-end adopts the Web (Vue framework) framework, a combination of JavaScript and python languages, and visually selects input parameters as needed, and sends requests to the back-end in the form of http; the back-end adopts the Django framework, and after receiving the request with parameters sent by the front-end, it automatically splices SQL, without manually entering SQL and various parameters in the comparison file. At the same time, this application verifies and controls information according to the online change system, and finally submits the modification statement to the database to complete the activation of the free baggage function. The use of the device of this application needs to be associated with the online change system to obtain the change information of the day, avoid unauthorized operations and misoperations, and has permission control and fast rollback functions, which can effectively avoid the interference of modification errors on real-time data, improve system security, and provide a solution for operation and maintenance personnel to make additional service configuration changes.

[0005] In order to achieve the above objectives, this application provides the following technical solutions:

[0006] The first aspect of the present application provides a visualization method based on the free baggage function of an airline, comprising:

[0007] Receive login instructions; log in to the AOS system and use the operation and maintenance tool to activate the free baggage function column;

[0008] Acquire dimensional data and verify the dimensional data; the dimensional data includes: airline, service subcode, effective date and expiration date;

[0009] After the dimension data is verified, the online change order number data and the online title data are received; the change information recorded in the online change order number is verified using the preview-related online change system; if the verification fails, a prompt "Please enter the correct change order number" is displayed; if the verification passes, the free baggage activation is completed according to the submission instructions;

[0010] Get the query instruction and query the enabled free baggage records.

[0011] Optionally, in the present application method, the operation and maintenance tool is an FCM operation and maintenance tool; the free baggage activation function column is located under the additional service fare publication column.

[0012] Optionally, in the present application method, the free baggage activation function column includes the following four input dimensions: airline, service sub-code, effective date, and expiration date; and query instructions are used to view the free baggage records that already exist in the current system.

[0013] Optionally, in the present application method, the airline supports the two-letter airline code format; the service subcode supports the ODF format; the effective date and expiration date are in the form of a date drop-down box, and the effective date and expiration date are the year, month, day, hour, minute, second or the current time selected by the user.

[0014] Optionally, in the method of the present application, the preview-associated online change system is used to verify the change information recorded in the online change order number, and the verification items include: verifying whether the online change order number exists and is correct, verifying whether the change date is the date and time on the online change system, and verifying whether the changed software is ASFF.

[0015] Optionally, the method of the present application also includes: when a rollback is required, clicking the record button, displaying the records that can be rolled back and their online titles, as well as the SQL for executing the rollback, and clicking rollback after confirmation to restore the records before modification.

[0016] A second aspect of the present application provides a visualization device based on the free baggage function of an airline, the device comprising:

[0017] Front-end page module: used to receive login instructions; log in to the AOS system and use the operation and maintenance tool to activate the free baggage function column; and obtain dimension data and verify the dimension data; the dimension data includes: airline, service sub-code, effective date and expiration date;

[0018] Back-end control module: used to receive the online change order number data and online title data after the dimension data verification is passed; use the preview-associated online change system to verify the change information recorded in the online change order number; if the verification fails, it prompts "Please enter the correct change order number", if the verification passes, complete the activation of free baggage according to the submission instructions; and obtain query instructions to query the activated free baggage records.

[0019] Optionally, in the device of the present application,

[0020] The front-end page module includes: input legality verification component, query component, new addition component, and record component;

[0021] The back-end control module includes: a permission management component, an SQL splicing component, a rollback SQL splicing component, a database driver component, and a transaction submission component.

[0022] Optionally, the front-end page module in the device of the present application adopts the Vue framework, which combines JavaScript and python languages ​​to visually select input parameters as needed and send requests to the back-end control module in http form; the back-end control module adopts the Django framework, and automatically splices SQL after receiving the request with parameters sent by the front-end page module.

[0023] Optionally, the device of the present application is associated with an online change system. The device obtains the change information of the day through the online change system, verifies and controls the information according to the online change system, and finally submits the modification statement to the database to complete the activation of the free baggage function.

[0024] In summary, this application proposes a new visualization method based on the airline free baggage function, the purpose of which is to unify the management of the corresponding function configuration through automation in the massive civil aviation fare publishing system scenario and improve the efficiency, accuracy and security of configuration changes. The method of this application has the following advantages:

[0025] (1) High efficiency: The automated configuration management used in this application is more efficient than manual configuration. In the past, manual configuration required operation and maintenance personnel to manually operate one by one, which took a lot of time and manpower. However, this application uses automated configuration tools to save a lot of time and manpower costs, especially in a large-scale freight rate publishing environment. This application can complete the configuration task at a faster speed and with higher accuracy.

[0026] (2) High consistency: The automated configuration management used in this application can provide more consistent configuration results, avoiding configuration differences caused by human negligence and errors. Manual configuration is prone to human errors and omissions, resulting in configuration inconsistencies.

[0027] (3) Traceability: The configuration management tool used in this application has better traceability. Operations and decisions during manual configuration are usually not recorded, making it difficult to track configuration changes and causes. However, the automated configuration management of this application uses configuration management tools to record the configuration change process, execution status, and source of modifications, making it easier to roll back, audit, and troubleshoot.

[0028] (4) High security: The automated configuration management adopted in this application can improve security. Manual configuration is prone to human negligence and errors, and directly modifying the database is very risky and unsafe, especially for novice operation and maintenance personnel who are not familiar with the corresponding business.

[0029] (5) High scalability: The automated configuration management adopted in this application is easier to expand. In addition to the activation function of the additional service free baggage, it can also be used to expand other services and realize more automated configuration change functions.

[0030] Other features and advantages of the present application will be described in the following description, and partly become apparent from the description, or understood by practicing the present application. The purpose and other advantages of the present application can be realized and obtained by the techniques indicated in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] In order to more clearly illustrate the technical solutions of the embodiments of the present application, a brief introduction is given below to the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present application. For those skilled in the art, other drawings can be obtained based on these drawings without creative work.

[0032] Figure 1 This is a structural diagram of the composition of a visualization device based on the airline's free baggage function provided in an embodiment of the present application.

[0033] Figure 2This is a flowchart of the overall implementation of the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0034] Figure 3 The figure is a schematic diagram of the process of creating a free baggage function based on the method of an embodiment of the present application.

[0035] Figure 4 An example diagram of field descriptions in a visualization method based on an airline's free baggage function provided in an embodiment of the present application.

[0036] Figure 5 This is a diagram of the date option interface in the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0037] Figure 6 This is a diagram of the free baggage query interface in the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0038] Figure 7 This is a diagram of the newly added interface for free baggage in the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0039] Figure 8 This is a diagram of the free baggage addition-submission confirmation interface in the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0040] Fig. 9 This is a diagram of the free baggage addition-submission success interface in the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0041] Fig.10 This is a diagram of the successful free baggage rollback interface in the visualization method based on the airline's free baggage function provided in an embodiment of the present application.

[0042] Fig.11 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0043] In order to make the purpose, technical scheme and advantages of the embodiments of the present application clearer, the technical scheme in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this application.

[0044] As used herein, the term “including” and its variations are open inclusions, ie, “including but not limited to”; the term “based on” means “based at least in part on”; and the term “one embodiment” means “at least one embodiment”.

[0045] It should be noted that the modifications of "one" and "plurality" mentioned in the present application are illustrative rather than restrictive, and those skilled in the art should understand that unless the context clearly indicates otherwise, it should be understood as "one or more".

[0046] Explanation of terms

[0047] ASM: Ancillary Service Maintenance.

[0048] AOS: Application Operation System.

[0049] ASFF: Ancillary Fare Filing additional service rates are released.

[0050] fcm operation and maintenance tool: Fare Configuration Maintenance freight configuration operation and maintenance tool.

[0051] Front-end page: fcm operation and maintenance tool in AOS - additional service fare release - activation of free baggage page.

[0052] Components: including query, add, and record components, which are basic components of the Web framework and send requests to the backend control in the form of post.

[0053] Input validity check component: A basic component of the Web framework that checks the input. For example, if the airline field type is string and the field length is 2, an error will be reported if it does not meet the requirements.

[0054] Permission control: Account permission control, for example, accounts without permission cannot click to query or add new components.

[0055] SQL splicing: The backend will splice SQL according to the input parameters, such as update requests, and will also splice rollback SQL for rollback operations.

[0056] Database driver: cx_oracle module that links to Oracle in Python3.

[0057] Commit transaction: database data commit operation.

[0058] Online change system: a platform for unified management of online changes, which records a lot of information such as online change order number, title, changed software, change time, etc.

[0059] This embodiment adopts the Vue framework adapted to the AOS platform and uses a combination of JavaScript and Python languages ​​to achieve development.

[0060] Figure 1 The figure shows the composition structure of a visualization device based on the free baggage function of airlines provided by the present application, including:

[0061] Front-end page module: used for user login, selection of functional components, input of dimensions for legality verification, and query of existing records; specifically including: receiving login instructions; logging into the AOS system, using the operation and maintenance tool to activate the free baggage function column; and obtaining dimension data and verifying the dimension data; the dimension data includes: airline, service subcode, effective date and expiration date. The front-end page module includes input legality verification component, query component, new component, and record component.

[0062] Backend control module: used to input the online order number and title, perform SQL splicing and rollback SQL splicing, and submit transactions; specifically includes: after the dimension data verification is passed, receive the online change order number data and online title data; use the preview associated online change system to verify the change information recorded in the online change order number; if the verification fails, it prompts "Please enter the correct change order number", if the verification passes, complete the activation of free baggage according to the submission instructions; and obtain query instructions to query the activated free baggage records. The backend control module includes permission management components, SQL splicing components, rollback SQL splicing components, database driver components, and transaction submission components.

[0063] Related systems of this device: online change system.

[0064] When the above device is running, the steps of the visualization method based on the airline's free baggage function disclosed in this application are implemented.

[0065] Figure 2 The figure shows the overall implementation process of a visualization method based on the free baggage function of airlines provided by this application. Figure 3 The figure shows the process of creating the free baggage function based on this method.

[0066] like Figure 2 and Figure 3 As shown, the method comprises the following steps:

[0067] Step 1: After receiving the change work order, the ASM operation and maintenance personnel log in to the AOS system, enter the fcm operation and maintenance tool, and select the additional service fare release-activate free baggage function column.

[0068] Step 2: The free baggage function column contains four input dimensions: airline, service sub-code, effective date, and expiration date; you can click the query button to view the free baggage records that already exist in the current system.

[0069] Step 3: Click the Add button and enter the dimensions in the pop-up input box: airline, service subcode, effective date, and expiration date. The system will also verify the input dimensions. Airlines support two-letter airline code format, service subcode only supports 0DF (a hexadecimal color code) format, effective date and expiration date use date drop-down box format, users can select year, month, day, hour, minute, second or the current time.

[0070] Step 4: After the input conditions are met and the correct dimensions are entered, enter the required items, the online change order number and the online title. The online title is only used as a confirmation item during rollback and does not participate in the verification. After entering the online change order number, click Preview. The system will link the online change system for verification and verify whether the online change order number exists and is correct, whether the change date is the date and time on the online change system, and whether the change software is ASFF. If all verifications are not met, the prompt "Please enter the correct change order number" will be displayed and the cursor will automatically return to the work order input box. If all verifications are met, click the Submit button to complete the activation of free baggage.

[0071] Step 5: You can click the query button to query the newly enabled free baggage records, or delete the records.

[0072] Step 6: When a rollback is required, click the record button to display the records that can be rolled back and their online titles, as well as the SQL for executing the rollback. After confirming that everything is correct, click Rollback to restore the records before the modification.

[0073] In order to better understand the technical solution of the present application, the following will take the query, addition and rollback of free baggage as an example for explanation.

[0074] (1) Check free baggage

[0075] Log in to an account with query function. The account permissions reuse the permissions of the AOS system. The permission approval is under the name of the AOS administrator. If you do not have permission, you can only see the query, add and record buttons but cannot click them. Enter the corresponding dimensions on the query page: CARR_CODE (airline two-letter code), SERVICE_SUB_CODE (service sub-code), FIRST_MAINTENANCE_DATE (effective date), LAST_MAINTENANCE_DATE (expiration date). The system will check the input items to determine whether they meet the input conditions. The judgment basis is Figure 4 For example, CARR_CODE only supports the two-letter airline code format, and other formats will not be allowed. In addition, CARR_CODE and SERVICE_SUB_CODE are required, and the remaining FIRST_MAINTENANCE_DATE and LAST_MAINTENANCE_DATE are optional input items in the form of a date drop-down box, such as Figure 5 After clicking the query button, you can see all the free baggage records that meet the conditions, such as Figure 6 shown.

[0076] (2) Added free baggage

[0077] like Figure 7 As shown, click the Add button, and enter the above-mentioned dimension parameters in the Add interface that pops up. The system will still verify the input items. In addition, you also need to enter the online order number and online title. After entering, you can click Preview to check the new items, but the database changes will not be submitted at this time. After clicking Preview, the system will link to the online change system, and obtain the change information from the online change system according to the entered online order number for verification. Verify whether the online order number is entered in the online change system; whether the actual change date and time meet the date and time requirements corresponding to the online order; whether the change software corresponding to the online order number is ASFF. If any item does not meet the verification, the system will prompt "Please enter the correct change order number", and then the cursor will return to the online order number input box. Only after all items have been verified and meet the conditions, click Submit, and the system will prompt a modification reminder "Are you sure you want to submit the modified data to the database?", such as Figure 8 As shown, after confirming again, click OK to complete the operation of adding free baggage records. Fig. 9 shown.

[0078] (3) Roll back free baggage

[0079] When the newly added free baggage is incorrect and needs to be rolled back, you can click the record button and the system will display the 10 most recent work orders. You can also perform an accurate search based on the online order number. After searching, the records will be displayed. You can find the records that need to be rolled back based on the online order number, title, online time and other information. The rollback status in the last column is divided into "not rolled back" and "rolled back". The rolled back records are distinguished by orange and no longer have a circle selection box at the beginning of the row. If you click the circle selection box for the unrolled record and then click Roll Back, you will jump to the rollback confirmation interface, such as Fig.10 As shown, all the information of the free baggage record can be seen on this interface. The rollback SQL that needs to be executed after splicing will also be displayed. You can verify the online order number, title, rollback SQL and other important information again. After confirming that everything is correct, click the red button "Rollback" to roll back the corresponding free baggage record.

[0080] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the device, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, program segment or a part of code, and the module, program segment or a part of code contains one or more executable instructions for realizing the specified logical function. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be realized by a special hardware-based system that performs the specified function or operation, or can be realized by a combination of special hardware and computer instructions.

[0081] like Fig.11 As shown, the embodiment of the present application also discloses an electronic device, including: a processor 310, a communication interface 320, a memory 330 for storing a computer program executable by the processor, and a communication bus 340. The processor 310, the communication interface 320, and the memory 330 communicate with each other through the communication bus 340. The processor 310 runs the executable computer program to implement the steps of the visualization method based on the airline's free baggage function.

[0082] It is understandable that, in addition to the memory and the processor, the electronic device may also include an input device such as a keyboard, an output device such as a display, and other communication modules. The input device, the output device, and other communication modules communicate with the processor via an I / O interface (i.e., an input / output interface).

[0083] Computer program code for performing the operations of the present application may be written in one or more programming languages ​​or a combination thereof, including, but not limited to, object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0084] Furthermore, the present application also discloses a computer-readable storage medium. When the instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the various steps of the visualization method based on the airline's free baggage function disclosed in the present application.

[0085] In the context of the present application, a computer-readable storage medium may be a tangible medium, more specific examples of which would include a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0086] In particular, according to an embodiment of the present application, the process described in the flowchart can be implemented as a computer software program. For example, an embodiment of the present application includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program code for executing the visualization method based on the airline free baggage function disclosed in the present application. When the computer program is executed by a processing device, the above functions defined in the method of the embodiment of the present application are executed.

[0087] Although several specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present application. The above description is only a preferred embodiment of the present application and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present application is not limited to the technical solutions formed by a specific combination of the above technical features, but also should cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above public concept.

[0088] Those skilled in the art should also understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of this application.

Claims

1. A visualization method based on the free baggage function of airlines, characterized in that: The method comprises: Receive login instructions; log in to the AOS system and use the operation and maintenance tool to activate the free baggage function column; Acquire dimensional data and verify the dimensional data; the dimensional data includes: airline, service subcode, effective date and expiration date; After the dimension data is verified, the online change order number data and online title data are received; the change information recorded in the online change order number is verified using the preview-related online change system; if the verification fails, a prompt "Please enter the correct change order number" is displayed; if the verification passes, the free baggage activation is completed according to the submission instructions; Get the query instruction and query the enabled free baggage records.

2. The method according to claim 1, characterized in that The operation and maintenance tool is the FCM operation and maintenance tool; the free baggage activation function column is located under the additional service fare release column.

3. The method according to claim 1, characterized in that The free baggage activation function column includes the following four input dimensions: airline, service subcode, effective date, and expiration date; the free baggage records existing in the current system can be viewed through query instructions.

4. The method according to claim 1, characterized in that: The airline supports the two-letter airline code format; the service subcode supports the 0DF format; the effective date and expiration date use the date drop-down box format, and the effective date and expiration date are the year, month, day, hour, minute, second or the current time selected by the user.

5. The method according to claim 1, characterized in that The preview-associated online change system is used to verify the change information recorded in the online change order number, and the verification items include: verifying whether the online change order number exists and is correct, verifying whether the change date is the date and time on the online change system, and verifying whether the changed software is ASFF.

6. The method according to claim 1, characterized in that The method further includes: when rollback is required, clicking a record button, displaying the records that can be rolled back and their online titles, as well as splicing the SQL for executing the rollback, and clicking rollback after confirmation to restore the records before modification.

7. A visualization device based on the free baggage function of airlines, characterized in that: The device comprises: Front-end page module: used to receive login instructions; log in to the AOS system and use the operation and maintenance tool to activate the free baggage function column; and obtain dimension data and verify the dimension data; the dimension data includes: airline, service sub-code, effective date and expiration date; Back-end control module: used to receive the online change order number data and online title data after the dimension data verification is passed; use the preview-associated online change system to verify the change information recorded in the online change order number; if the verification fails, it prompts "Please enter the correct change order number"; if the verification passes, complete the activation of free baggage according to the submission instruction; and obtain query instructions to query the activated free baggage records.

8. The device according to claim 7, characterized in that The front-end page module includes: input legality verification component, query component, new addition component, and record component; The back-end control module includes: a permission management component, an SQL splicing component, a rollback SQL splicing component, a database driver component, and a transaction submission component.

9. The device according to claim 7, characterized in that The front-end page module in the device adopts the Vue framework, and in a combination of JavaScript and Python languages, visually selects input parameters as needed, and sends a request to the back-end control module in the form of http; the back-end control module adopts the Django framework, and automatically splices SQL after receiving the request with parameters sent by the front-end page module.

10. The device according to claim 7, characterized in that The device is associated with the online change system. The device obtains the change information of the day through the online change system, verifies and controls the information according to the online change system, and finally submits the modification statement to the database to complete the activation of the free baggage function.

Images