Enterprise car use bill generation method and device, electronic equipment and storage medium
By collecting and aggregating multi-dimensional data associated with corporate car bills, and combining HIVE result tables and preset databases, customized bills are generated, which solves the problems of long bill generation and low accuracy in the existing technology, and achieves efficient and accurate bills. Build and customize functionality.
Patent Information
- Application Number
- CN202310884922.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-07-18
- Publication Date
- 2025-01-21
AI Technical Summary
In the prior art, the enterprise car bill generation method has the problems of high export time, low data accuracy, and abnormal blocking. The big data batch export flexibility is poor, so it is impossible to differentiate the export of car data.
Multi-dimensional data related to corporate car bills are collected through big data technology, aggregated into bill details based on order dimensions, stored as HIVE result tables, summarized based on corporate dimensions, and stored in a preset database after verification. Based on the bill template of the target enterprise, the database is queried to generate a customized bill.
It realizes the efficient and accurate generation of enterprise car bills, meets the needs of enterprises for customized bills, and improves the flexibility and accuracy of data export.
Smart Images
Figure CN119338603A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a method, device, electronic device, and computer-readable storage medium for generating a corporate vehicle bill. Background Art
[0002] In the travel platform, the enterprise vehicle usage data needs to be exported from time to time, so that the enterprise can grasp the vehicle usage within a billing period. In the existing technology, the export of enterprise-level bills through pure Java has the problems of high export time, low accuracy of exported data, and easy blockage in case of abnormalities. If the export is done through big data batch running, there is poor flexibility and it is impossible to export vehicle usage data in a differentiated manner.
[0003] It can be seen that the existing method of generating corporate vehicle bills still needs to be improved. Summary of the invention
[0004] The embodiments of the present application provide a method and device for generating an enterprise vehicle bill, an electronic device, and a storage medium, which can customize the generated vehicle bill according to the needs of the user, and the exported data is highly efficient and accurate.
[0005] In a first aspect, an embodiment of the present application provides a method for generating a corporate vehicle bill, comprising:
[0006] Collect multi-dimensional data related to the enterprise's vehicle bills through big data technology according to a first preset period;
[0007] Aggregating the multidimensional data into bill detail data based on the order dimension, and storing the data as a HIVE result table;
[0008] Summarize the billing details data within the specified order cycle in the HIVE result table based on the enterprise dimension to obtain summary data corresponding to the enterprise;
[0009] Verifying the summary data, and using the verified summary data as the bill summary data;
[0010] The bill summary data and the bill detail data corresponding to the bill summary data are used as the enterprise vehicle bill source data of the corresponding enterprise and stored in a preset database;
[0011] Based on the preset bill template of the target enterprise, the enterprise vehicle bill source data corresponding to the target enterprise in the preset database is queried to generate a bill file of the customized bill of the target enterprise within the specified order cycle.
[0012] In a second aspect, an embodiment of the present application provides a device for generating a corporate vehicle bill, including:
[0013] A multi-dimensional data collection module, used to collect multi-dimensional data associated with the enterprise's vehicle bills through big data technology according to a first preset period;
[0014] A first data storage module, configured to aggregate the multidimensional data into bill detail data based on the order dimension, and store the data as a HIVE result table;
[0015] A data aggregation module is used to aggregate the billing details data within the specified order cycle in the HIVE result table based on the enterprise dimension to obtain aggregated data corresponding to the enterprise;
[0016] A data audit module is used to check the summary data and use the summary data that passes the check as the bill summary data;
[0017] A second data storage module is used to store the bill summary data and the bill detail data corresponding to the bill summary data as the enterprise vehicle bill source data of the corresponding enterprise in a preset database;
[0018] The customized bill file generation module is used to query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database based on the bill template preset by the target enterprise, and generate a bill file of the customized bill of the target enterprise within a specified order cycle.
[0019] In a third aspect, an embodiment of the present application further discloses an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the method for generating a corporate vehicle bill as described in the embodiment of the present application is implemented.
[0020] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the steps of the method for generating a corporate vehicle bill disclosed in the embodiment of the present application are performed.
[0021] The enterprise vehicle bill generation method disclosed in the embodiment of the present application is to collect multidimensional data associated with the enterprise vehicle bill through big data technology according to the first preset period; aggregate the multidimensional data into bill detail data based on the order dimension and store it as a HIVE result table; summarize the bill detail data within the specified order period in the HIVE result table based on the enterprise dimension to obtain summary data corresponding to the enterprise; verify the summary data and use the verified summary data as bill summary data; use the bill summary data and the bill detail data corresponding to the bill summary data as the enterprise vehicle bill source data of the corresponding enterprise and store them in a preset database; based on the preset bill template of the target enterprise, query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database to generate a bill file of the customized bill of the target enterprise within the specified order period. This method collects multidimensional vehicle data by combining big data processing technology, and stores it in the database after preliminary processing. In this way, the specified data field can be flexibly queried through the database query statement according to the customized bill template of the enterprise to generate a customized bill, which meets the needs of the enterprise for customized bills.
[0022] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS
[0023] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution 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 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 creative work are within the scope of protection of this application.
[0024] Figure 1 This is one of the flow charts of the method for generating a corporate vehicle bill disclosed in the embodiment of the present application;
[0025] Figure 2 This is a schematic diagram of the bill template customization interface disclosed in the embodiment of the present application;
[0026] Figure 3 This is the second flow chart of the method for generating a corporate vehicle bill disclosed in the embodiment of the present application;
[0027] Figure 4 It is a structural schematic diagram of a device for generating a corporate vehicle bill disclosed in an embodiment of the present application;
[0028] Figure 5A block diagram schematically shows an electronic device for executing the method according to the present application; and
[0029] Figure 6 A storage unit for holding or carrying a program code for implementing the method according to the present application is schematically shown. DETAILED DESCRIPTION
[0030] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are 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 creative work are within the scope of protection of this application.
[0031] The embodiment of the present application discloses a method for generating a corporate vehicle bill, such as Figure 1 As shown, the method includes: steps 110 to 160.
[0032] Step 110: Collect multi-dimensional data associated with the enterprise's vehicle bills through big data technology according to a first preset period.
[0033] Optionally, the first preset period may be one day, or other periods.
[0034] Optionally, the multi-dimensional data associated with the enterprise car bill is collected through big data technology according to the first preset cycle, including: multi-dimensional data including enterprise car related data, car order data, and car order payment data is collected through big data technology according to the first preset cycle, wherein the car order data includes at least one of the following information: car order number, car usage time, car user ID, and user type; the enterprise car related data includes at least one of the following information: car user ID, car usage department, and car usage rules; the car order payment data includes at least one of the following information: car order number and payment amount.
[0035] Optionally, multi-dimensional data associated with the enterprise's vehicle bills and stored in various data centers or databases are collected through big data technology.
[0036] For example, car order data can be collected from the travel database, car order payment data can be collected from the payment database, and enterprise car-related data such as enterprise organizational structure and car usage scenarios or rule data can be collected from the enterprise car database.
[0037] Step 120: Aggregate the multi-dimensional data into bill detail data based on the order dimension and store it as a HIVE result table.
[0038] Optionally, the collected multidimensional data is aggregated into bill detail data and stored as a HIVE result table, including: based on the association between the multidimensional data, the information of the same car order number of the same car user ID is aggregated into a bill detail data corresponding to the car user ID and the car order number.
[0039] By widening the data collected in the multidimensional database, detailed bill data is formed. For example, when a company employee takes a taxi at night, it is necessary to obtain the employee's car order number, car use time, car user ID, user type, car use start and end locations, driver receiving the order and other travel information from the travel database; obtain the employee's department (i.e. car use department), car use rules and other information from the company's car use related data (such as the company's organization library); obtain the car order payment data (such as the settlement price of the order and the detailed items of the fee) from the payment library database. Optionally, if the order has price changes, refunds and other payment behavior-related operations, it is also necessary to obtain refund information from the payment library database; if there is a customer complaint about the order, it is also necessary to obtain negative business information (such as customer complaint classification and processing results) from the customer service database.
[0040] After obtaining the above information, the data related to the employee's car order is used to generate a bill detail data according to the preset field definition and format of the bill detail data, and the generated bill detail data is stored in the HIVE result table.
[0041] Optionally, the bill detail fields include but are not limited to one or more of the following fields: the company to which the ordering user belongs, the ordering user, the ordering user's phone number, the order time, the business type, the personal payment amount (Yuan), the passenger boarding time, the passenger's name, the passenger's phone number, the company's actual payment amount (Yuan), the company's credit payment amount (Yuan), the company's credit refund (Yuan), the company's cash payment amount (Yuan), the company's cash refund (Yuan), the company's gift currency refund (Yuan), the company's refund amount (Yuan), coupons (Yuan), parking fees (Yuan), others (Yuan), departure place, detailed address of the departure place, cancellation fee (Yuan), the ordering user's employee number, the reason for the exception, the discount fee (Yuan), sensitive order description, whether it is a sensitive order, the reason for using the car, post-use approval, car use scenario, car use city, car use approver, car use time (minutes), destination, detailed address of the destination, itinerary number, trip end time, trip fee (Yuan), order status, order type, order number, order amount (Yuan), fee attribution, gift currency payment (Yuan), refund time, mileage (kilometers), highway fee (Yuan).
[0042] The preset fields and formats of the bill detail data are defined according to specific business requirements, and this application does not impose any restrictions on this.
[0043] Optionally, the structured bill detail data may be mapped into a database table through HIVE data warehouse tools and stored in a first preset database, wherein the first preset database may be a database that supports reading and writing according to database tables, and each bill detail data is stored as a row of table data in a HIVE result table.
[0044] HIVE is a data warehouse analysis system built on Hadoop. It provides a rich set of SQL query methods to analyze data stored in the Hadoop distributed file system (such as bill details data). It can map structured data files into a database table and provide complete SQL query functions.
[0045] Step 130 , the billing detail data within the specified order cycle in the HIVE result table is summarized based on the enterprise dimension to obtain summary data corresponding to the enterprise.
[0046] Next, by reading the bill detail data within the specified order cycle stored in the HIVE result table in the first preset database, and summarizing the read bill detail data according to the enterprise information field in the bill detail data (such as the enterprise field to which the order user belongs), the bill detail data corresponding to the car orders of the employees of each enterprise (such as a row of table data) are summarized according to the preset rules to obtain the summary data corresponding to each enterprise.
[0047] Optionally, the summary data includes but is not limited to one or more of the following data: the number of car orders, the number of paid car orders, the paid order amount, the order amount to be paid, the refund amount and other payment data.
[0048] Optionally, the specified order cycle can be one month. For example, by using big data technology to collect multidimensional data, and through multidimensional data joint query, the bill detail data is obtained, and the daily bill detail data is further summarized, and then at the beginning of the month, the daily bill detail data is aggregated by the order number dimension to form the monthly bill data. For example, for orders that have a refund operation within a month, the refund order and the original order are aggregated into one bill detail data. For a certain enterprise, the corresponding monthly bill data includes the bill detail data of all car orders of the employees of the enterprise in that month.
[0049] After that, the monthly bill data, i.e., the bill details of all the aggregated car orders in the current month, is aggregated according to the enterprise dimension to obtain the summary data of the bill details of each enterprise in the specified month. For example, the total number of car orders of each enterprise in the current month, the payable order amount, paid order amount, and pending order amount of each enterprise are summarized to obtain the summary data of the corresponding enterprise.
[0050] Step 140, verifying the summary data, and using the summary data that passes the verification as the bill summary data.
[0051] In the actual process of corporate car use, each company may generate thousands or even more bill details every month. In order to ensure the accuracy of the generated bills, in the embodiments of the present application, before generating the company's bills based on the collected and processed bill details, it is necessary to verify the bill details based on the summary data.
[0052] Optionally, the summary data is checked and the verified summary data is used as the bill summary data, including: for the summary data corresponding to each enterprise, based on the pre-acquired car order payment data, the payment data in the summary data is compared and checked; in response to the payment data in the summary data being consistent with the car order payment data, the summary data is used as the bill summary data of the enterprise. For example, the monthly amount to be paid in the summary data is compared with the amount to be paid in the car order payment system. If the comparison is consistent, the summary data verification is passed, and it can be considered that the current summary data and the bill detail data used to obtain the summary data are accurate, and the subsequent bill generation operation is performed. On the contrary, if the comparison is inconsistent, the summary data verification fails, and the subsequent bill generation operation is not performed.
[0053] Optionally, after comparing and checking the payment data in the summary data based on the pre-acquired vehicle order payment data, the method further includes: in response to the payment data in the summary data being inconsistent with the vehicle order payment data, outputting abnormal prompt information indicating that the bill summary data of the enterprise is abnormal. The abnormal prompt information is used to notify the operation and maintenance personnel to intervene in the comparison result, re-correct the bill detail data, and then summarize and check again, so as to form consistency between the bill detail data and the accounts receivable.
[0054] In the embodiments of the present application, other payment data can also be compared. For example, the monthly paid amount in the summary data is compared with the paid amount in the car order payment system, and at the same time, the monthly to-be-paid amount in the summary data is compared with the to-be-paid amount in the car order payment system, and a more detailed verification result has been output.
[0055] Step 150: The bill summary data and the bill detail data corresponding to the bill summary data are stored in a preset database as the enterprise vehicle bill source data of the corresponding enterprise.
[0056] Optionally, the preset database is a database that can be queried in JAVA mode. For example, the preset database includes but is not limited to any of the following databases: DB database, MySQL, Oracle database, etc.
[0057] For enterprises that have passed the summary data verification, a customized bill for the enterprise can be generated based on the bill summary data of the enterprise and the bill detail data obtained by summarizing the bill summary data.
[0058] In order to facilitate customized query of bill data, in the embodiment of the present application, the bill summary data and bill detail data of each enterprise are used as the enterprise vehicle bill source data and stored in a database that can be queried based on JAVA mode. For example, for a certain enterprise, the bill summary data of the enterprise can be stored in one database table, and the bill detail data of the enterprise can be stored in another database table.
[0059] By exchanging and storing the enterprise vehicle bill source data in a database that can be queried in JAVA mode, technical support is provided for querying the enterprise vehicle bill source data according to the database table fields, so that customized bills can be flexibly generated according to the enterprise's customized bill templates.
[0060] Step 160, based on the preset bill template of the target enterprise, query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database, and generate a bill file of the customized bill of the target enterprise within the specified order cycle.
[0061] After completing the preparation of the enterprise vehicle bill source data, the next step is to query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database based on the preset bill template of the target enterprise, and generate a customized bill for the target enterprise within the specified order cycle.
[0062] Optionally, based on the bill template preset by the target enterprise, the enterprise vehicle bill source data corresponding to the target enterprise in the preset database is queried to generate a bill file for the customized bill of the target enterprise within the specified order cycle, including: performing the following customized bill data acquisition operations in batches: reading a preset number of enterprise vehicle bill source data corresponding to the target enterprise in the preset database into a data pool; based on the bill template preset by the target enterprise, querying the enterprise vehicle bill source data in the data pool to obtain the customized bill data of the corresponding batch; generating a bill file for the customized bill of the target enterprise within the specified order cycle according to the customized bill data.
[0063] In view of the characteristics of large-scale enterprise vehicle usage, many vehicle orders, and massive bill detail data, in order to reduce the occupation of system storage resources and device storage resources, in the embodiment of the present application, the enterprise vehicle bill source data of the target enterprise in the preset database is read in batches, and customized output is performed to generate a customized bill for the target enterprise.
[0064] Optionally, a data pool cache can be applied for based on the availability of system storage resources and device storage resources, or a data pool cache can be applied for based on the size of a custom bill written to a file at one time, and the size of the enterprise vehicle bill source data read in each batch can be determined based on the capacity of the data pool cache. For example, 5,000 enterprise vehicle bill source data can be read into the data pool in each batch. In the embodiment of the present application, the size of the data pool is not limited.
[0065] After reading each batch of enterprise vehicle bill source data into the data pool, each enterprise vehicle bill source data in the data pool is further processed according to the bill template pre-set by the enterprise, and the data of the corresponding fields in the bill template are extracted as customized bill data.
[0066] Optionally, based on the bill template preset by the target enterprise, the enterprise vehicle bill source data in the data pool is queried to obtain the corresponding batch of customized bill data, including: obtaining the customized bill field in the bill template; obtaining the data field corresponding to the customized bill field as the target data field according to the mapping relationship between the customized bill field and the data field of the enterprise vehicle bill source data; querying the data content of each target data field of the enterprise vehicle bill source data in the data pool through a database query statement, and assigning the queried data content to the corresponding customized bill field based on the mapping relationship; generating customized bill detail data according to the assigned customized bill field.
[0067] Optionally, companies can customize bill templates through the interface provided by the travel platform. Figure 2 As shown, in the bill template customization interface, the various data fields of the enterprise car bill source data and the display content description of the corresponding fields are displayed. The bill template customization interface is also provided with a display content modification entry for the business. The enterprise can select the data fields of the enterprise car bill source data that need to be displayed in the generated bill, and modify the display name of the corresponding data field. The bill template customization interface will use the data fields selected by the enterprise as the customized bill fields of the bill template, and establish a mapping relationship between the customized bill fields and the corresponding data fields of the enterprise car bill source data, and use the modified display name of the corresponding data field as the display name of the corresponding customized bill field to generate a customized bill template.
[0068] For example, an enterprise may select some data fields from several data fields (usually dozens) of enterprise vehicle bill source data to generate a customized bill, and define the display names of the corresponding fields in the generated customized bill.
[0069] When a customized bill needs to be generated, the customized bill field in the bill template of the target enterprise is first obtained. Then, according to the mapping relationship between the customized bill field generated when the enterprise customizes the bill template and the data field of the enterprise car bill source data, the data field in the enterprise car bill source data that needs to be read to generate the customized bill of the target enterprise is determined and recorded as the target data field. After that, the data content of the target field of each enterprise car bill source data in the data pool can be queried through the JAVA database query statement, and the obtained data content is assigned to the corresponding customized bill field, thereby obtaining a customized bill data.
[0070] For example, in the bill template of Enterprise A, the following four data fields of the enterprise car bill source data are selected as an example: contract company, car usage scenario, car usage reason, and expense attribution. In addition, Enterprise A modifies the display content of the contract company field to "department". When generating customized bill data, for each enterprise car bill source data of Enterprise A in the data pool, the JAVA database query statement can be used to query the data content of the contract company, car usage scenario, car usage reason, and expense attribution of the four data fields of the enterprise car bill source data, and assign the data content of the contract company field to the "department" field of the current customized bill data, assign the data content of the car usage scenario field to the "car usage scenario" field of the current customized bill data, assign the data content of the car usage reason field to the "car usage scenario" field of the current customized bill data, and assign the data content of the car usage scenario expense attribution field to the "expense attribution" field of the current customized bill data, thereby obtaining a customized bill data.
[0071] According to the above method, the data content of the target data field of the enterprise vehicle bill source data in the data pool is read one by one, and the corresponding customized bill field is assigned a value to generate customized bill data corresponding to each enterprise vehicle bill source data.
[0072] In an embodiment of the present application, the customized billing data needs to be uploaded to a designated server in the form of a billing file for download by the enterprise. Optionally, the billing file can be a first format file or a second format file, wherein the first format file is a file that can be written one by one, and the second format file is a file that is written as a whole. For files of different formats, for each customized billing data generated, a corresponding method needs to be used to generate a customized bill.
[0073] Optionally, generating a billing file for the customized bill of the target enterprise within a specified order cycle based on the customized bill data includes: after obtaining each piece of customized bill data, synchronously writing the customized bill data into a first format file in an append-write manner until the reading of the target enterprise's corporate vehicle bill source data is completed; and using the first format file as the billing file for the customized bill of the target enterprise within the specified order cycle.
[0074] Optionally, the first format file is an EXCEL file. Accordingly, each customized bill data can be written into a specified EXCEL file through easy excel. For example, each time a customized bill data is generated, the generated customized bill data is written into the corresponding table item of the first format file.
[0075] Optionally, generating a billing file of a customized bill of the target enterprise within a specified order cycle according to the customized billing data includes: writing the customized billing data into corresponding second format files batch by batch according to a preset batching rule; and obtaining a billing file of the customized bill of the target enterprise within the specified order cycle according to all the second format files written in batches. The preset batching rule may be a preset number of items or a preset data size, etc.
[0076] Optionally, the second format file is a PDF (portable document format) format file.
[0077] Optionally, the customized bill data is written into the corresponding second format file batch by batch according to preset batch rules, including: after obtaining each customized bill data, synchronously writing the customized bill data into the local file cache in an append-write manner until the customized bill data stored in the local file cache is equal to the preset number of items in each batch or the reading of the target enterprise's corporate vehicle bill source data is completed; creating a new second format file; and writing the customized bill data in the local file cache into the newly created second format file.
[0078] Optionally, after writing the customized billing data in the local file cache into the newly created second format file, the method further includes: initializing the local file cache, for example, clearing the data in the previous batch of cache.
[0079] When the generated bill file is a second format file, it is necessary to first cache each customized bill data generated in sequence to obtain a batch of customized bill data (such as a specified number of customized bill data), and then write this batch of customized bill data from the local cache to the second format file at one time. If there is still unread enterprise car bill source data, recreate a second format file and repeat the operations of generating customized bill data, caching, and batch writing to the second format file until all enterprise car bill source data are read.
[0080] In the specific implementation process, based on the enterprise vehicle bill source data, one second format file may be generated, or multiple second format files may be generated. When multiple second format files are generated, a file name corresponding to a write batch may be set for each generated second format file.
[0081] Optionally, when multiple second format files are generated, the second format files written in each batch may be compressed to generate a compressed package, and the compressed package may be used as a customized bill for the second format files of the target enterprise within a specified order cycle.
[0082] In some embodiments of the present application, Figure 3 As shown, after generating the bill file of the customized bill of the target enterprise within the specified order cycle, it also includes: step 170 and step 180.
[0083] Step 170, uploading the bill file to a preset storage container, and obtaining a download link for the customized bill;
[0084] Step 180: send the download link to the target enterprise, so that the target enterprise downloads the bill file of the customized bill through the download link.
[0085] For example, the travel platform uploads the generated bill file of the target enterprise to the OBS bucket (Object Storage Service), and obtains the download link of the bill file as the download link of the customized bill. Afterwards, the travel platform will obtain the download link and store it in the local database. The enterprise can obtain the download link of the customized bill corresponding to the enterprise by logging into the travel platform, and download the bill file corresponding to the customized bill by accessing the download link. Optionally, the travel platform can also push the obtained download link to the target enterprise.
[0086] The enterprise vehicle bill generation method disclosed in the embodiment of the present application is to collect multidimensional data associated with the enterprise vehicle bill through big data technology according to the first preset period; aggregate the multidimensional data into bill detail data based on the order dimension and store it as a HIVE result table; summarize the bill detail data within the specified order period in the HIVE result table based on the enterprise dimension to obtain summary data corresponding to the enterprise; verify the summary data and use the verified summary data as bill summary data; use the bill summary data and the bill detail data corresponding to the bill summary data as the enterprise vehicle bill source data of the corresponding enterprise and store them in a preset database; based on the preset bill template of the target enterprise, query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database to generate a bill file of the customized bill of the target enterprise within the specified order period. This method collects multidimensional vehicle data by combining big data processing technology, and stores it in the database after preliminary processing. In this way, the specified data field can be flexibly queried through the database query statement according to the customized bill template of the enterprise to generate a customized bill, which meets the needs of the enterprise for customized bills.
[0087] This method can solve the problem of enterprise customized bill field aliases, bill field order, etc. By regularly uploading the enterprise's customized bill to the designated storage service end, the enterprise can quickly download the customized bill by accessing the download link.
[0088] Furthermore, the method provides two customized bill file formats to meet subsequent bill processing requirements.
[0089] The present application also discloses a device for generating a corporate vehicle bill, such as Figure 4 As shown, the device comprises:
[0090] The multi-dimensional data collection module 410 is used to collect multi-dimensional data associated with the enterprise vehicle bill through big data technology according to a first preset period;
[0091] A first data storage module 420, configured to aggregate the multi-dimensional data into bill detail data based on the order dimension, and store the data as a HIVE result table;
[0092] A data aggregation module 430 is used to aggregate the billing details data within the specified order cycle in the HIVE result table based on the enterprise dimension to obtain aggregated data corresponding to the enterprise;
[0093] The data audit module 440 is used to check the summary data and use the summary data that passes the check as the bill summary data;
[0094] The second data storage module 450 is used to store the bill summary data and the bill detail data corresponding to the bill summary data as the enterprise vehicle bill source data of the corresponding enterprise in a preset database;
[0095] The customized bill file generation module 460 is used to query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database based on the bill template preset by the target enterprise, and generate a bill file of the customized bill of the target enterprise within a specified order cycle.
[0096] Optionally, the customized bill file generating module 460 is further configured to:
[0097] Perform the following customized bill data acquisition operations in batches: read a preset number of enterprise vehicle bill source data corresponding to the target enterprise in the preset database into a data pool; query the enterprise vehicle bill source data in the data pool based on the preset bill template of the target enterprise to obtain the customized bill data of the corresponding batch;
[0098] A billing file of the customized bill of the target enterprise within a specified order cycle is generated based on the customized billing data.
[0099] Optionally, generating a billing file of a customized bill of the target enterprise within a specified order cycle according to the customized billing data includes:
[0100] After obtaining each piece of customized bill data, the customized bill data is synchronously written into the first format file in an append-write manner until the enterprise vehicle bill source data of the target enterprise is read completely;
[0101] The first format file is used as a billing file for a customized bill of the target enterprise within a specified order cycle.
[0102] Optionally, generating a billing file of a customized bill of the target enterprise within a specified order cycle according to the customized billing data includes:
[0103] Writing the customized bill data into corresponding second format files batch by batch according to preset batch rules;
[0104] According to all the second format files written in batches, a bill file of the customized bill of the target enterprise within a specified order cycle is obtained.
[0105] Optionally, writing the customized bill data into corresponding second format files batch by batch according to a preset batch rule includes:
[0106] After obtaining each customized bill data, the customized bill data is synchronously written into the local file cache in an append-write manner until the customized bill data stored in the local file cache is equal to the preset number of items in each batch or the enterprise vehicle bill source data of the target enterprise is read;
[0107] Create a new second format file;
[0108] The customized bill data in the local file cache is written into the newly created second format file.
[0109] Optionally, based on the bill template preset by the target enterprise, query the enterprise vehicle bill source data in the data pool to obtain the corresponding batch of customized bill data, including:
[0110] Obtaining a custom bill field in the bill template;
[0111] According to the mapping relationship between the customized bill field and the data field of the enterprise vehicle bill source data, the data field corresponding to the customized bill field is obtained as the target data field;
[0112] Query the data content of each target data field of the enterprise vehicle bill source data in the data pool through a database query statement, and assign the queried data content to the corresponding customized bill field based on the mapping relationship;
[0113] Generate customized bill detail data based on the assigned customized bill fields.
[0114] Optionally, the data audit module 440 is further used to:
[0115] For the summary data corresponding to each enterprise, based on the pre-acquired car order payment data, the payment data in the summary data is compared and checked;
[0116] In response to the payment data in the summary data being consistent with the vehicle order payment data, the summary data is used as the bill summary data of the enterprise.
[0117] The enterprise vehicle bill generation device disclosed in the embodiment of the present application is used to implement the enterprise vehicle bill generation method described in the embodiment of the present application. The specific implementation methods of each module of the device will not be repeated here, and reference can be made to the specific implementation methods of the corresponding steps in the method embodiment.
[0118] The enterprise vehicle bill generation device disclosed in the embodiment of the present application collects multidimensional data associated with the enterprise vehicle bill through big data technology according to a first preset period; aggregates the multidimensional data into bill detail data based on the order dimension and stores it as a HIVE result table; summarizes the bill detail data within the specified order period in the HIVE result table based on the enterprise dimension to obtain summary data corresponding to the enterprise; verifies the summary data and uses the verified summary data as the bill summary data; uses the bill summary data and the bill detail data corresponding to the bill summary data as the enterprise vehicle bill source data of the corresponding enterprise and stores them in a preset database; based on the preset bill template of the target enterprise, queries the enterprise vehicle bill source data corresponding to the target enterprise in the preset database, and generates a bill file of the customized bill of the target enterprise within the specified order period. The device collects multidimensional vehicle data by combining big data processing technology, and stores it in the database after preliminary processing. In this way, the specified data field can be flexibly queried through the database query statement according to the customized bill template of the enterprise, and the customized bill can be generated, meeting the needs of the enterprise customized bill.
[0119] This device can solve the problem of enterprise customized bill field aliases, bill field order, etc. By regularly uploading the enterprise's customized bills to the designated storage service end, the enterprise can quickly download the customized bills by accessing the download link.
[0120] Each embodiment in this specification is described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the embodiments can be referred to each other. For the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0121] The above is a detailed introduction to a method and device for generating a corporate vehicle bill provided by the present application. This article uses specific examples to illustrate the principles and implementation methods of the present application. The description of the above embodiments is only used to help understand the method of the present application and a core idea. At the same time, for general technical personnel in this field, according to the idea of the present application, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present application.
[0122] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.
[0123] The various component embodiments of the present application can be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. It should be understood by those skilled in the art that a microprocessor or digital signal processor (DSP) can be used in practice to implement some or all functions of some or all components in the electronic device according to the embodiment of the present application. The present application can also be implemented as a device or apparatus program (e.g., computer program and computer program product) for executing part or all of the methods described herein. Such a program implementing the present application can be stored on a computer-readable medium, or can have the form of one or more signals. Such a signal can be downloaded from an Internet website, or provided on a carrier signal, or provided in any other form.
[0124] For example, Figure 5 An electronic device that can implement the method according to the present application is shown. The electronic device can be a PC, a mobile terminal, a personal digital assistant, a tablet computer, etc. The electronic device traditionally includes a processor 510 and a memory 520 and a program code 530 stored on the memory 520 and can be run on the processor 510, and the processor 510 implements the method described in the above embodiment when executing the program code 530. The memory 520 can be a computer program product or a computer-readable medium. The memory 520 can be an electronic memory such as a flash memory, an EEPROM (electrically erasable programmable read-only memory), an EPROM, a hard disk or a ROM. The memory 520 has a storage space 5201 for the program code 530 of the computer program for executing any method step in the above method. For example, the storage space 5201 for the program code 530 can include various computer programs for implementing the various steps in the above method respectively. The program code 530 is a computer-readable code. These computer programs can be read from one or more computer program products or written into the one or more computer program products. These computer program products include program code carriers such as hard disks, compact disks (CDs), memory cards or floppy disks. The computer program includes a computer readable code, and when the computer readable code is executed on an electronic device, the electronic device is caused to execute the method according to the above embodiment.
[0125] The embodiment of the present application also discloses a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the steps of the method for generating a corporate vehicle bill as described in the embodiment of the present application are implemented.
[0126] Such a computer program product may be a computer-readable storage medium, which may have a computer-readable storage medium having a Figure 5 The memory 520 in the electronic device shown in the figure is similar to the storage segment, storage space, etc. The program code can be compressed and stored in the computer-readable storage medium in an appropriate form. The computer-readable storage medium is generally as shown in the reference Figure 6 The portable or fixed storage unit. Generally, the storage unit includes computer readable code 530', which is a code read by a processor. When the code is executed by the processor, each step in the method described above is implemented.
[0127] The term "one embodiment", "embodiment" or "one or more embodiments" herein means that a particular feature, structure or characteristic described in conjunction with the embodiment is included in at least one embodiment of the present application. In addition, please note that the examples of the term "in one embodiment" here do not necessarily all refer to the same embodiment.
[0128] In the description provided herein, a large number of specific details are described. However, it is understood that the embodiments of the present application can be practiced without these specific details. In some instances, well-known methods, structures and techniques are not shown in detail so as not to obscure the understanding of this description.
[0129] In the claims, any reference signs placed between brackets shall not be construed as limiting the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The present application may be implemented by means of hardware comprising several different elements and by means of a suitably programmed computer. In a unit claim enumerating several means, several of these means may be embodied by the same item of hardware. The use of the words first, second, and third etc. does not indicate any order. These words may be interpreted as names.
[0130] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should 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. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.
Claims
1. A method for generating a corporate vehicle bill, characterized in that: The method comprises: Collect multi-dimensional data related to the enterprise's vehicle bills through big data technology according to a first preset period; Aggregating the multidimensional data into bill detail data based on the order dimension, and storing the data as a HIVE result table; Summarize the billing details data within the specified order cycle in the HIVE result table based on the enterprise dimension to obtain summary data corresponding to the enterprise; Verifying the summary data, and using the verified summary data as the bill summary data; The bill summary data and the bill detail data corresponding to the bill summary data are used as the enterprise vehicle bill source data of the corresponding enterprise and stored in a preset database; Based on the preset bill template of the target enterprise, the enterprise vehicle bill source data corresponding to the target enterprise in the preset database is queried to generate a bill file of the customized bill of the target enterprise within the specified order cycle.
2. The method according to claim 1, characterized in that The method of querying the enterprise vehicle bill source data corresponding to the target enterprise in a preset database based on the bill template preset by the target enterprise, and generating a bill file of a customized bill of the target enterprise within a specified order cycle, includes: Perform the following customized bill data acquisition operations in batches: read a preset number of enterprise vehicle bill source data corresponding to the target enterprise in the preset database into a data pool; query the enterprise vehicle bill source data in the data pool based on the preset bill template of the target enterprise to obtain the customized bill data of the corresponding batch; A billing file of the customized bill of the target enterprise within a specified order cycle is generated based on the customized billing data.
3. The method according to claim 2, characterized in that The step of generating a billing file of a customized bill of the target enterprise within a specified order cycle according to the customized billing data includes: After obtaining each piece of customized bill data, the customized bill data is synchronously written into the first format file in an append-write manner until the enterprise vehicle bill source data of the target enterprise is read completely; The first format file is used as a billing file for a customized bill of the target enterprise within a specified order cycle.
4. The method according to claim 2, characterized in that: The step of generating a billing file of a customized bill of the target enterprise within a specified order cycle according to the customized billing data includes: Writing the customized bill data into corresponding second format files batch by batch according to preset batch rules; According to all the second format files written in batches, a bill file of the customized bill of the target enterprise within a specified order cycle is obtained.
5. The method according to claim 4, characterized in that The step of writing the customized bill data into corresponding second format files batch by batch according to a preset batch rule includes: After obtaining each customized bill data, the customized bill data is synchronously written into the local file cache in an append-write manner until the customized bill data stored in the local file cache is equal to the preset number of items in each batch or the enterprise vehicle bill source data of the target enterprise is read; Create a new second format file; The customized bill data in the local file cache is written into the newly created second format file.
6. The method according to claim 2, characterized in that Based on the bill template preset by the target enterprise, query the enterprise vehicle bill source data in the data pool to obtain the corresponding batch of customized bill data, including: Obtaining a custom bill field in the bill template; According to the mapping relationship between the customized bill field and the data field of the enterprise vehicle bill source data, the data field corresponding to the customized bill field is obtained as the target data field; Query the data content of each target data field of the enterprise vehicle bill source data in the data pool through a database query statement, and assign the queried data content to the corresponding customized bill field based on the mapping relationship; Generate customized bill detail data based on the assigned customized bill fields.
7. The method according to claim 1, characterized in that The step of checking the summary data and using the summary data that passes the check as the bill summary data includes: For the summary data corresponding to each enterprise, based on the pre-acquired car order payment data, the payment data in the summary data is compared and checked; In response to the payment data in the summary data being consistent with the vehicle order payment data, the summary data is used as the bill summary data of the enterprise.
8. A device for generating a corporate vehicle bill, characterized in that: The device comprises: A multi-dimensional data collection module, used to collect multi-dimensional data associated with the enterprise's vehicle bills through big data technology according to a first preset period; A first data storage module, configured to aggregate the multidimensional data into bill detail data based on the order dimension, and store the data as a HIVE result table; A data aggregation module is used to aggregate the billing details data within the specified order cycle in the HIVE result table based on the enterprise dimension to obtain aggregated data corresponding to the enterprise; A data audit module is used to check the summary data and use the summary data that passes the check as the bill summary data; A second data storage module is used to store the bill summary data and the bill detail data corresponding to the bill summary data as the enterprise vehicle bill source data of the corresponding enterprise in a preset database; The customized bill file generation module is used to query the enterprise vehicle bill source data corresponding to the target enterprise in the preset database based on the bill template preset by the target enterprise, and generate a bill file of the customized bill of the target enterprise within a specified order cycle.
9. An electronic device comprising a memory, a processor, and a program code stored in the memory and executable on the processor, wherein: When the processor executes the program code, the method for generating a corporate vehicle bill according to any one of claims 1 to 7 is implemented.
10. A computer-readable storage medium having program code stored thereon, characterized in that: When the program code is executed by a processor, the steps of the method for generating a corporate vehicle bill as described in any one of claims 1 to 7 are implemented.