Method and system for judging changes in business trip itinerary

By obtaining and standardizing the itinerary data of the business trip application form, and performing changes and verification, the difficulty of synchronization of the itinerary change of the business trip application form in the existing technology and the problems of dirty database data, achieving improvements in accuracy and performance, and supporting multi-platform changes need.

CN117974063BActive Publication Date: 2024-11-15苏州思客科技(集团)有限公司
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410199521.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-02-22
Publication Date
2024-11-15
Estimated Expiration
2044-02-22

AI Technical Summary

Technical Problem

In the prior art, when the itinerary of the business trip is changed, it is difficult to accurately and synchronize the original application form, resulting in a lot of dirty data in the database, a decrease in synchronization performance, and the inability to effectively judge the itinerary change.

Method used

By obtaining the business trip application ID, obtaining historical data from the database, standardized processing is carried out to generate standard itinerary data, and changing the new and old application forms, including time, city and personnel matching verification, and using MD5 encryption to compare personnel consistency .

Benefits of technology

It realizes accurate judgment of itinerary changes, reduces database dirty data, improves system performance, and supports the need for multiple platform business trip applications to apply for single changes, with strong scalability, high calibration accuracy and high performance.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117974063B_ABST
    Figure CN117974063B_ABST
Patent Text Reader

Abstract

The present invention discloses a method and system for judging the itinerary change of a business trip, the method comprising: S1, obtaining the business trip application form with historical storage from the database according to the business trip application form ID; S2, standardizing the itinerary data in the business trip application form to generate standard itinerary data; S3, performing change verification on the business trip application form according to the standard itinerary data. The itinerary matching scheme provided by the present invention can accurately verify the application form with changed itinerary and reduce the generation of dirty data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention belongs to the technical field of data processing, and in particular relates to a method and system for determining a change in a single itinerary of a business trip. Background Art

[0002] Usually, business travelers need to submit a business trip application form before the business trip begins. The business trip application form often includes itinerary information. However, after the business trip begins, itinerary changes are inevitable due to weather factors, work progress, temporary arrangements, etc.

[0003] In view of the above situation, the existing technology has a solution for changing the existing business trip application form, such as referring to DingTalk, WeChat for Enterprise, etc. When the business trip form is changed, it is necessary to first operate the original application form to withdraw it and reapply. In this way, for the platform, it is necessary to pay attention to the original application form and invalidate the original application form. Another way is to make adjustments on the original application form. In this way, for the platform, it is necessary to pay attention to the last segment of the application and verify it with the existing itinerary.

[0004] In the method of canceling the original application form, because the approval status of the original application form has not been updated, the platform cannot accurately synchronize the withdrawn original application form when using incremental acquisition of business trip application forms; and the method of matching itineraries will cause a lot of dirty data in the database, and the synchronization performance of the application form will be reduced. Summary of the invention

[0005] The object of the present invention is to provide an efficient itinerary matching solution, which can accurately verify application forms with itinerary changes and reduce the generation of dirty data in the database.

[0006] In order to achieve the aforementioned object of the invention, the present invention adopts the following scheme:

[0007] One aspect of the present invention provides a method for determining a change in a single itinerary of a business trip, comprising the following steps:

[0008] S1. Obtain the historical business trip application form from the database according to the business trip application form ID;

[0009] S2. Based on the itinerary data in the business trip application form, the itinerary data is standardized to generate standard itinerary data;

[0010] S3. Perform change verification on the business trip application form according to the standard itinerary data.

[0011] Another aspect of the present invention provides a business trip single itinerary change judgment system, the system comprising:

[0012] The business trip application form acquisition module is used to obtain the business trip application forms that have been stored in the database according to the business trip application form ID;

[0013] A standard itinerary data generating module, used for standardizing the itinerary data in the business trip application form to generate standard itinerary data;

[0014] The change verification module is used to perform change verification on the business trip application form according to the standard itinerary data.

[0015] Compared with the prior art, the present invention has at least the following advantages: (1) The present invention can reduce the generation of dirty data in the database and improve the performance of the system; (2) The present invention makes up for the shortcomings of the prior art in judging itinerary changes, can accurately judge whether the itinerary has changed, and improve the freshness of the itinerary of the business trip application form; (3) The present invention supports the change requirements of the business trip application form on multiple platforms of customers, and has strong scalability; (4) The present invention supports the change requirements of the business trip application form in the OA system to modify the time or itinerary of the business trip application form separately; (5) The matching method in the technical solution proposed by the present invention has high performance and high accuracy. By testing the date change of one or more segments of itineraries, and the city change of one or more segments of itineraries, the results show that the itinerary change verification is accurate and the verification performance is high. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 It is the main flow chart of the prior art for judging the change of a single itinerary of a business trip;

[0018] Figure 2 This is a main flow chart of a method for determining a change in a single itinerary of a business trip in one embodiment of the present invention. DETAILED DESCRIPTION

[0019] In order to make the purpose, technical scheme and advantages of the present invention clearer, the specific embodiments of the present invention are described in detail below in conjunction with the accompanying drawings. Examples of these preferred embodiments are illustrated in the accompanying drawings. The embodiments of the present invention shown in the accompanying drawings and described according to the accompanying drawings are merely exemplary, and the present invention is not limited to these embodiments.

[0020] It should also be noted that, in order to avoid obscuring the present invention due to unnecessary details, only structures and / or processing steps closely related to the solutions according to the present invention are shown in the accompanying drawings, while other details that are not closely related to the present invention are omitted.

[0021] One aspect of the present invention provides a method for determining a change in a single itinerary of a business trip, comprising the following steps:

[0022] S1. Obtain the historical business trip application form from the database according to the business trip application form ID;

[0023] S2. Based on the itinerary data in the business trip application form, the itinerary data is standardized to generate standard itinerary data;

[0024] S3. Perform change verification on the business trip application form according to the standard itinerary data.

[0025] In one embodiment, the step S2 of normalizing the travel data comprises the following steps:

[0026] S21. Convert the start time and end time of all trips into standard UTC time;

[0027] S22, converting the departure city and destination city of all trips into preset standard cities, each of which has a unique city CODE;

[0028] S23, uniformly processing the data structure of the applicant and the traveling companions of the business trip application form, and using the uniformly processed data structure for verifying the traveling companions of the business trip application form;

[0029] S24. Group the old business trip application itineraries into the same groups and serialize the personnel data.

[0030] In one embodiment, in step S3, the business trip application form is subjected to change verification, including: travel time change verification, itinerary change verification, and personnel change verification.

[0031] In one embodiment, the method further includes: the travel time change check includes: grouping and matching the travel time in the new and old business trip application forms, grouping by the start time point and the end time point, and if the groups are inconsistent, determining that there is a change;

[0032] The itinerary change verification includes: grouping and matching the itinerary cities after standardization of the new and old business trip application forms, and when any departure city and destination city in the itinerary of the two business trip application forms do not match each other, it is determined that there is a change;

[0033] The personnel change verification includes: performing MD5 encryption on the traveler information in the new and old business trip application forms and comparing the consistency. If they are inconsistent, it is determined that there is a change.

[0034] In one embodiment, the itinerary change verification further includes: concatenating and grouping the departure city and the destination city before matching.

[0035] Another aspect of the present invention provides a business trip single itinerary change judgment system, the system comprising:

[0036] The business trip application form acquisition module is used to obtain the business trip application forms that have been stored in the database according to the business trip application form ID;

[0037] A standard itinerary data generating module, used for standardizing the itinerary data in the business trip application form to generate standard itinerary data;

[0038] The change verification module is used to perform change verification on the business trip application form according to the standard itinerary data.

[0039] In one embodiment, the standard travel data generation module includes the following submodules:

[0040] The time standardization submodule is used to convert the start and end time points of all trips into standard UTC time;

[0041] The city standardization submodule is used to convert the departure city and destination city of all trips into preset standard cities, and each of the standard cities has a unique city CODE;

[0042] A traveler unified processing submodule is used to perform unified data structure processing on the applicant and the accompanying persons of the business trip application form, and the unified processed data structure is used for traveler verification of the business trip application form;

[0043] The grouping and serialization processing submodule is used to group the old business trip application itineraries into the same groups and serialize the personnel data.

[0044] In one embodiment, the change verification module is specifically used to perform change verification on the business trip application form, including: travel time change verification, itinerary change verification, and personnel change verification.

[0045] In one embodiment, the travel time change check includes: grouping and matching the travel time in the new and old business trip application forms, grouping by start time point and end time point, and if the groups are inconsistent, determining that there is a change;

[0046] The itinerary change verification includes: grouping and matching the itinerary cities after standardization of the new and old business trip application forms, and when any departure city and destination city in the itinerary of the two business trip application forms do not match each other, it is determined that there is a change;

[0047] The personnel change verification includes: performing MD5 encryption on the traveler information in the new and old business trip application forms and comparing the consistency. If they are inconsistent, it is determined that there is a change.

[0048] In one embodiment, the itinerary change verification further includes: concatenating and grouping the departure city and the destination city before matching.

[0049] Figure 1 It is the main flow chart of the technical solution of the present invention. Figure 1 The business trip itinerary change plan of the present invention includes the following contents:

[0050] 1. Obtain the business trip application form that has been stored in the database according to the application form ID; if it is not obtained, a new business trip application form is stored;

[0051] 2. Standardized trip data:

[0052] (1) Convert the start and end time of all trips into UTC time; convert the start and end time of a trip into UTC time to facilitate time comparison;

[0053] (2) All the departure and destination cities of all itineraries are converted into standard cities of Travel Butler. After the departure and arrival cities in the itinerary are converted into standard cities of Travel Butler, they can be compared by city code.

[0054] (3) Unify the data structure of the applicant and the traveler of the application form; the unified data structure is used for traveler verification of the application form;

[0055] (4) Group the old application trip data into the same groups and serialize the personnel data;

[0056] 3. Change verification of business trip order:

[0057] (1) Travel time change verification: Group and match the travel time of the new and old application orders by start time point and end time point. If the groups are inconsistent, it is judged as a change;

[0058] (2) Itinerary change verification: Group and match the itinerary cities of the old and new application forms after formatting. If any departure city or destination city in the itinerary of the two business trip forms does not match, determine whether to change it;

[0059] (3) Personnel change verification: MD5 encryption is performed on the new and old application forms to compare the consistency of the traveler information. If they are inconsistent, it is considered a change;

[0060] The verification includes obtaining the departure city and destination city of the itinerary, matching different judgment rules with different types of combinations, and checking whether the two itineraries meet the matching judgment rules to determine whether to change;

[0061] It should be understood that although this specification is described according to implementation methods, not every implementation method contains only one independent technical solution. This narrative method of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions of each embodiment can also be appropriately combined to form other implementation methods that can be understood by those skilled in the art.

Claims

1. A method for determining changes in a single business trip itinerary, characterized in that: The following steps are involved: S1. Obtain the historical business trip application form from the database according to the business trip application form ID; S2. Based on the itinerary data in the business trip application form, the itinerary data is standardized to generate standard itinerary data; S3. Performing change verification on the business trip application form according to the standard itinerary data; The step S2 of normalizing the travel data includes the following steps: S21. Convert the start time and end time of all trips into standard UTC time; S22, converting the departure city and destination city of all trips into preset standard cities, each of which has a unique city CODE; S23, uniformly processing the data structure of the applicant and the traveling companions of the business trip application form, and using the uniformly processed data structure for verifying the traveling companions of the business trip application form; S24, grouping the same itineraries of the old business trip applications and serializing the personnel data; In step S3, the business trip application form is checked for changes, including: travel time change check, itinerary change check, and personnel change check; The travel time change check includes: grouping and matching the travel time in the new and old business trip application forms, grouping by start time point and end time point, and if the groups are inconsistent, determining that there is a change; The itinerary change verification includes: grouping and matching the itinerary cities after standardization of the new and old business trip application forms, and when any departure city and destination city in the itinerary of the two business trip application forms do not match each other, it is determined that there is a change; The personnel change verification includes: performing MD5 encryption on the traveler information in the new and old business trip application forms and comparing the consistency. If they are inconsistent, it is determined that there is a change.

2. The method according to claim 1, characterized in that: In the itinerary change verification, before matching, the following steps are further performed: splicing and grouping the departure city and the destination city.

3. A business trip itinerary change judgment system, characterized in that: The system comprises: The business trip application form acquisition module is used to obtain the business trip application forms that have been stored in the database according to the business trip application form ID; A standard itinerary data generating module, used for standardizing the itinerary data in the business trip application form to generate standard itinerary data; A change verification module, used to perform change verification on the business trip application form according to the standard itinerary data; The standard travel data generation module includes the following submodules: The time standardization submodule is used to convert the start and end time points of all trips into standard UTC time; The city standardization submodule is used to convert the departure city and destination city of all trips into preset standard cities, and each of the standard cities has a unique city CODE; A traveler unified processing submodule is used to perform unified data structure processing on the applicant and the accompanying persons of the business trip application form, and the unified processed data structure is used for traveler verification of the business trip application form; The grouping and serialization processing submodule is used to group the old business trip application itineraries into the same groups and serialize the personnel data; The change verification module is specifically used to perform change verification on business trip application forms, including: travel time change verification, itinerary change verification, and personnel change verification; The travel time change check includes: grouping and matching the travel time in the new and old business trip application forms, grouping by start time point and end time point, and if the groups are inconsistent, determining that there is a change; The itinerary change verification includes: grouping and matching the itinerary cities after standardization of the new and old business trip application forms, and when any departure city and destination city in the itinerary of the two business trip application forms do not match each other, it is determined that there is a change; The personnel change verification includes: performing MD5 encryption on the traveler information in the new and old business trip application forms and comparing the consistency. If they are inconsistent, it is determined that there is a change.

4. The system according to claim 3, characterized in that In the itinerary change verification, before matching, the following steps are further performed: splicing and grouping the departure city and the destination city.