CN109685668B - Order batch processing method, device, computer equipment and storage medium - Google Patents
Order batch processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109685668B CN109685668B CN201811339094.XA CN201811339094A CN109685668B CN 109685668 B CN109685668 B CN 109685668B CN 201811339094 A CN201811339094 A CN 201811339094A CN 109685668 B CN109685668 B CN 109685668B
- Authority
- CN
- China
- Prior art keywords
- order
- information
- template
- customization
- order information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 24
- 238000012545 processing Methods 0.000 claims abstract description 47
- 238000005516 engineering process Methods 0.000 claims description 20
- 238000000605 extraction Methods 0.000 claims description 14
- 238000004422 calculation algorithm Methods 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 13
- 230000002688 persistence Effects 0.000 claims description 10
- 230000002194 synthesizing effect Effects 0.000 claims 1
- 238000000034 method Methods 0.000 abstract description 25
- 238000010586 diagram Methods 0.000 description 9
- 238000004458 analytical method Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 230000010365 information processing Effects 0.000 description 4
- 238000006243 chemical reaction Methods 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000005287 template synthesis Methods 0.000 description 2
- 230000001550 time effect Effects 0.000 description 2
- 238000007635 classification algorithm Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/154—Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an order batch processing method, an order batch processing device, terminal equipment and a storage medium, wherein the method comprises the following steps: acquiring an order information base, wherein the order information base comprises order information and a type identifier corresponding to each order information; dividing order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification; configuring a template of the general information to obtain an order agreement template; customizing a file template of the customization information to obtain an order customization template; correlating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information; and generating a target order information base corresponding to each type of identification through a list uploading control of the order service system based on the corresponding relation. The method can improve the efficiency of order batch processing.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and apparatus for batch processing of orders, a computer device, and a storage medium.
Background
With the rapid development of society, for a large transaction processing platform, a series of processing is generally required for a large volume of orders. Taking an insurance order of an insurance industry as an example, one person usually purchases insurance orders of multiple risk types, such as car insurance, health insurance, accident insurance, and the like, or multiple persons purchase the same risk types, for this purpose, a large number of insurance types need to be filled in, and the large number of insurance information contains a large number of repeated information, such as basic information of insurance users of different risk types, and insurance fees, insurance amounts, effective dates, and the like of the same risk types. At present, the policy information table is filled manually by service personnel, if thousands of policy are available, thousands of policy information is required to be filled by service personnel one by one, so that on one hand, the filling difficulty of the service personnel is increased, and on the other hand, the policy application and protection efficiency is seriously affected. Accordingly, there is a need to provide a convenient and efficient method of order bulk processing that addresses the above-described problems.
Disclosure of Invention
The embodiment of the invention provides an order batch processing method, an order batch processing device, computer equipment and a storage medium, which are used for solving the problem of low order batch processing efficiency.
An order batch processing method, comprising:
Acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to the order information;
dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification;
performing template configuration on the general information to obtain an order protocol template;
customizing the file template of the customization information to obtain an order customization template;
associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information;
and generating a target order information base corresponding to each type identifier through a list uploading control of the order service system based on the corresponding relation.
An order batch processing device, comprising:
the order information base acquisition module is used for acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to the order information;
the order information dividing module is used for dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification;
The protocol template acquisition module is used for carrying out template configuration on the general information to obtain an order protocol template;
the custom template acquisition module is used for customizing the file template of the custom information to obtain an order custom template;
the corresponding relation acquisition module is used for associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information;
and the target order information base acquisition module is used for generating a target order information base corresponding to each type identifier through a list uploading control of the order service system based on the corresponding relation.
A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the order bulk processing method described above when the computer program is executed.
A computer readable storage medium storing a computer program which, when executed by a processor, performs the steps of the order bulk processing method described above.
In the order batch processing method, the order batch processing device, the computer equipment and the storage medium, an order information base is firstly obtained. Then, the order information corresponding to each type of identification is divided according to a preset classification mode, so that the general information and the custom information corresponding to each type of identification are obtained, further processing is carried out on the batch order more efficiently, and the workload of repeatedly processing the batch order is reduced. And then, configuring the template of the general information to obtain an order agreement template, so that the work load of repeatedly processing batch orders is reduced by the general information through the order agreement template. And the custom information is subjected to file template customization to obtain an order custom template, so that the time effect of processing the custom information one by one is saved, errors caused by negligence can be avoided, and the processing efficiency of the custom information is improved. And then, associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information, wherein the corresponding relation is used for combining the order information according to the corresponding relation, so that the batch order information with the same type of identification can be processed at the same time. And the accuracy of order information processing is ensured. And finally, generating a target order information base corresponding to each type of identification through a list uploading control of the order service system based on the corresponding relation, thereby improving the efficiency of batch processing of orders.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments of the present invention will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of an application environment of an order batch processing method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating an exemplary method for order bulk processing according to an embodiment of the present invention;
FIG. 3 is another exemplary diagram of an order bulk processing method provided by an embodiment of the present invention;
FIG. 4 is another exemplary diagram of an order bulk processing method provided by an embodiment of the present invention;
FIG. 5 is another exemplary diagram of an order bulk processing method provided by an embodiment of the present invention;
FIG. 6 is another exemplary diagram of an order bulk processing method provided by an embodiment of the present invention;
FIG. 7 is another exemplary diagram of an order bulk processing method provided by an embodiment of the present invention;
FIG. 8 is a schematic block diagram of an order batch processing apparatus according to an embodiment of the present invention;
fig. 9 is a schematic diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The order batch processing method provided by the application can be applied to an application environment as shown in fig. 1, wherein a client communicates with a server through a network, the server receives an order information base sent by the client, then the order information in the order information base is divided into general information and custom information, the general information is subjected to template configuration to obtain an order agreement template, and the custom information is subjected to file template custom to obtain an order custom template. And then, the order agreement template is associated with the order customization template, and a target order library corresponding to each type of identification is generated through a list uploading control of the service system according to the corresponding relation. The clients may be, but are not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server may be implemented by a stand-alone server or a server cluster formed by a plurality of servers.
In one embodiment, as shown in fig. 2, the method is applied to the server in fig. 1, and the method includes the following steps:
s10: and acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to each order information.
The order information base refers to an order information database composed of batch order information, and comprises order information and type identifiers corresponding to the order information. Order information refers to information related to an electronic trade order (e.g., an insurance application order), such as the order information of a vehicle model number, a license plate number, and an insurance age in the vehicle insurance application order information. The type identifier is used to identify different kinds of order information, and in particular, a number or a name or the like may be used as the type identifier. Each order information carries a type identifier corresponding to the order information. Specifically, the server receives an order information base sent by the client, for example, the order information base includes vehicle insurance application order information, the type corresponding to the order information is identified as "ID01", the type corresponding to the personal property insurance application order information is identified as "ID02", and the type corresponding to the engineering insurance application order information is identified as "ID03".
In one embodiment, the act of retrieving the order information repository may be triggered by a specific instruction or request. Optionally, the client initiates an order information base query request, and sends the order information base query request to the server, and the server triggers an order information base query instruction according to the order information base query request after obtaining the order information base query request, so as to query a corresponding order information base and obtain the order information base.
Further, the user inputs a user name and a password through the client to log in an access page of the order information base, and the client generates an order information base query request according to query information input in the access page. The server receives an order information base query request sent by the client. After receiving the order information base query request, the server analyzes the order information base query request, and extracts an order information base identifier in the order information base query request through analyzing the order information base query request. The server side stores a plurality of order information bases, and different order information bases are distinguished by adopting order information base identifiers. After the server side extracts the order information base identification in the order information base query request, querying whether an order information base corresponding to the order information base identification exists in the stored order information base, and if so, querying. If not, returning prompt information of failed inquiry. And finally, extracting an order information base corresponding to the order information base identification.
S20: and dividing order information corresponding to each type of identification according to a preset classification mode to obtain general information and custom information corresponding to each type of identification.
The preset classification mode refers to a preset mode of classifying the order information according to categories, for example, classifying the same information in the order information into one category and classifying different information in the order information into another category. Alternatively, the preset classification mode may be a classification mode based on a text classification algorithm, that is, an algorithm for identifying and classifying text information of order information. The classification method of the keyword extraction algorithm, that is, the algorithm for classifying according to the same number of keywords, may be also used. It can be appreciated that the classification method of classifying by extracting the keywords is simpler and more efficient. Preferably, the classification is performed by using a classification method of a keyword extraction algorithm in the present embodiment.
The general information refers to order fields contained in order information corresponding to a plurality of types of identifiers. The custom information refers to order fields contained in order information corresponding to fewer type identifications. The classification of the general message and the custom message may be performed by setting a threshold value, and determining whether to divide the corresponding order field into general information or custom information according to the threshold value. Continuing with the example of the insuring order information in step S10, the customer information, channel information, and target information included in the vehicle insurance order are order fields, i.e., general information, included in the order information corresponding to the many types of identification. And the order field contained in the corresponding order information is identified by the fewer types of content information of the order information of the vehicle model number, the license plate number and the insurance year, namely the customization information.
It will be appreciated that, since there are typically large batches of orders to be processed in electronic transactions, each type of order information corresponding to a type of identification includes order fields included in order information corresponding to a plurality of types of identifications and order fields included in order information corresponding to a lesser number of types of identifications. Therefore, the order information corresponding to each type of identification is classified, so that the batch order can be further processed more efficiently, and the workload of repeatedly processing the batch order information is reduced.
S30: and configuring the template of the general information to obtain an order protocol template.
Wherein the template configuration refers to an operation of setting general information into a standardized form. The order protocol template is a template for classifying and sorting the general information, wherein the general information comprises basic structures and contents. For example, a general information of "customer information", the order agreement template of which includes "name", "phone number", and "identification card number", etc. Specifically, after analyzing the general information, the server side configures the general information by adopting a web front-end technology to generate an order protocol template. The web front-end technology may be php technology, HTML technology, asp.net technology, etc.
In one embodiment, taking an insurance application order as an example, the server may generate a related policy agreement based on different policies. Firstly, the corresponding dangerous seed is determined, and then the basic structure and the content of the order protocol template are configured according to the characteristics of the dangerous seed, for example, the client information in the general information comprises applicant information, channel information cost, signing parties, insurance targets, payment information, special agreements and the like.
For example, there are A, B, C three kinds of risk, wherein the A kind has 100 pieces of insurance information, the B kind has 1000 pieces of insurance information, and the C kind has 2000 pieces of insurance information, so that 3 order protocol templates are required to be configured to classify and sort general information in 3100 pieces of insurance information into 3 order protocol templates.
In this embodiment, the order agreement template is obtained by configuring the template for the general information, so that the work load of repeatedly processing batch orders by using the order agreement template for the general information is reduced.
S40: and customizing the file template of the customization information to obtain an order customization template.
Where file template customization refers to the operation of customizing the customization information to the formatted file template for storing the information. The order customization template is a file template for storing customization information, and can be an xls file template, namely a template for storing information by adopting an Excel form, or an xml file template for classifying and sorting the customization information. Specifically, the server may analyze the custom information by using an analysis technique based on the custom information in the order information corresponding to each type identifier, and then generate a corresponding order custom template, where the analysis technique may be a POI analysis technique or a DOM analysis technique. The POI is an open source function library and is used for providing an API for Java programs to read and write files in the Microsoft Office format. The DOM is a document management model for the function of Java programs to read and operate on xml formats.
Taking the custom information such as the car model number, the license plate number and the insurance age included in the car insurance order in the step S20 as an example, when the server identifies the custom information, after analyzing the custom information, a custom file template containing the custom information such as the car model number, the license plate number and the insurance age is generated, so that custom information in order information corresponding to each type of identification can be accurately and conveniently stored, the time for processing the custom information one by one is saved, errors caused by negligence can be avoided, and the processing efficiency of the custom information is improved.
It will be appreciated that the order information corresponding to each type identifier includes general information and custom information, each general information corresponds to an order agreement template, and each custom information corresponds to an order custom template, so that the order agreement templates correspond to the order custom templates one by one. So that the batch order information is efficiently processed.
S50: and associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information.
The association refers to the operation of performing corresponding mapping on the order agreement template and the order customization template corresponding to the same type identifier. The correspondence is the correspondence existing between the order agreement template and the order customization template in each order information. The correspondence may be a one-to-one correspondence, a one-to-many correspondence, or a many-to-many correspondence. In this embodiment, since the order information corresponding to each type identifier includes general information and custom information, each general information corresponds to an order agreement template, each custom information corresponds to an order custom template, and the corresponding relationship in this embodiment is a one-to-one corresponding relationship, that is, the order agreement template corresponds to the order custom template one by one. Specifically, the order agreement template and the order customization template are associated to obtain the corresponding relation between the order agreement template and the order customization template in each order information, and the corresponding relation is used for combining the order information subsequently according to the corresponding relation, so that the batch order information with the same type of identification can be processed efficiently subsequently. And the accuracy of processing the batch order information is ensured.
S60: and generating a target order information base corresponding to each type of identification through a list uploading control of the order service system based on the corresponding relation.
The order service system refers to a system for processing order service and comprises an order service processing control, wherein the list uploading control is a control for uploading an order object (such as a file object or an xml object) with a corresponding relation to generate an order with the corresponding relation. The target order information base is a target order information database composed of order information generated by uploading batch order information according to a corresponding relation. Because each target order information in the target order information base is generated according to the corresponding relation between the order agreement template and the order customization template in each order information, the accuracy of each target order information is ensured, and meanwhile, the target order information base can be generated at one time through the list uploading control, so that the processing efficiency of batch orders is improved.
Specifically, after the server side obtains the corresponding relation between the order agreement template and the order customization template in each order information, the corresponding relation is used for generating a target order information base corresponding to each type identifier through a list uploading control of the order service system. The method and the device realize simultaneous processing of batch order information and improve the efficiency of batch order processing.
In this embodiment, first, an order information base is acquired. Then, the order information corresponding to each type of identification is divided according to a preset classification mode, so that the general information and the custom information corresponding to each type of identification are obtained, further processing is carried out on the batch order more efficiently, and the workload of repeatedly processing the batch order is reduced. And then, configuring the template of the general information to obtain an order agreement template, so that the work load of repeatedly processing batch orders is reduced by the general information through the order agreement template. And the custom information is subjected to file template customization to obtain an order custom template, so that the time effect of processing the custom information one by one is saved, errors caused by negligence can be avoided, and the processing efficiency of the custom information is improved. And then, associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information, wherein the corresponding relation is used for combining the order information according to the corresponding relation, so that the batch order information with the same type of identification can be processed at the same time. And the accuracy of order information processing is ensured. And finally, generating a target order information base corresponding to each type of identification through a list uploading control of the order service system based on the corresponding relation, thereby improving the efficiency of batch processing of orders.
In an embodiment, as shown in fig. 3, in step S20, the order information corresponding to each type identifier is divided according to a preset classification mode to obtain general information and custom information corresponding to each order type, which specifically includes:
s21: and extracting the keywords of each order information by adopting a keyword extraction algorithm.
The keyword extraction algorithm is an algorithm for extracting keywords from text information and is used as a basis for classifying the text information. The keyword extraction algorithm includes, but is not limited to, a TF-IDF keyword extraction method, a Topic-model keyword extraction method, or a RAKE keyword extraction algorithm.
Specifically, after the order information base is obtained, a keyword extraction algorithm is used to extract keywords contained in each order information, in this embodiment, the keywords refer to vocabularies with order information category distinguishing guidance contained in the order information, and are used to evaluate the degree of repeated order information between order information corresponding to each type identifier in the order information base. For example, in the vehicle insurance order information, keywords include "car insurance", "car model", and "license plate number", etc. It will be appreciated that by extracting keywords for each order information, order information is efficiently sorted based on the keywords later.
S22: and traversing each order information to obtain the number of each keyword.
Wherein, traversal (trade) refers to access to all keywords in each order information, i.e. access to each keyword of each order information in sequence, so as to count the occurrence times of each keyword as the number of the keywords. Among these, traversal methods include, but are not limited to: preamble traversal, midamble traversal, and postamble traversal, etc. Preferably, the traversal method used in the present embodiment is preamble traversal.
Specifically, the number of occurrences of the keyword is accumulated in the traversal process, that is, when the same keyword is repeatedly accessed once, the number of the keywords is increased by one based on the original number. It will be appreciated that the greater the number of keywords, the more duplicate information in the order information is indicated, and therefore, the order information is more accurately divided by obtaining the number of each keyword so as to take the number of each keyword as the basis for dividing the order information.
S23: and using the keywords with the number of which reaching the threshold value as general information and using the keywords with the number of which not reaching the threshold value as custom information.
The threshold value refers to the minimum number value of keywords of order information which meet the repeated content in the order information. It will be appreciated that when the number of keywords reaches the threshold, i.e. the number of keywords in the order information is greater than or equal to the threshold, i.e. the number of times the keywords appear in the order information is high, it may be used as general information. When the number of keywords does not reach the threshold, the number of keywords in the order information is smaller than the threshold, that is, the number of times the keywords appear in the order information is small, so that the keywords can be used as custom information. And the keywords with the number reaching the threshold value are used as general information, and the keywords with the number not reaching the threshold value are used as custom information, so that the accuracy of order information division is improved.
In this embodiment, first, a keyword extraction algorithm is used to extract keywords of each order information. Then, each order information is traversed, and the number of each keyword is obtained, so that the number of each keyword is used as the basis for dividing the order information, and the order information is more accurately divided. And finally, using the keywords with the number reaching the threshold value as general information and using the keywords with the number not reaching the threshold value as custom information, thereby improving the accuracy of order information division.
In one embodiment, as shown in fig. 4, in step S30, the template configuration is performed on the general information to obtain an order agreement template, which specifically includes the following steps:
s31: and carrying out validity check on the general information.
The validity check refers to verifying the validity of the general information in the order information. Specifically, the method of validity verification includes, but is not limited to, a regular expression, a numerical type, a length, or a non-null validity verification method. Taking the general information in step S30 as "customer information", when the identification card number in the "customer information" accords with the encoding rule of the chinese resident identification card number, the validity check of the identification card number in the "customer information" is passed. Understandably, the validity of the general information is ensured by verifying the validity of the general information, so that the subsequent further processing of the general information is facilitated.
S32: and if the validity check is passed, generating an order protocol template from the general information by adopting an HTML technology.
Among them, HTML technology is a technology of a standard markup language for creating web pages. In the embodiment, the general information passing through the validity check is generated into the order agreement template by adopting the HTML technology, so that the order agreement template generation efficiency is improved.
In this embodiment, validity verification is performed on the general information, so that validity of the general information is guaranteed, and further processing of the general information is facilitated. If the validity check is passed, the general information is generated into an order agreement template by adopting an HTML technology, so that the order agreement template generation efficiency is improved.
In one embodiment, as shown in fig. 5, in step S32, the general information is generated into an order agreement template by using HTML technology, which specifically includes the following steps:
s321: and acquiring a protocol framework of the general information as an order protocol framework.
The protocol framework refers to a basic structure of text information, and in this embodiment, the order protocol framework is a basic structure of general information.
S322: an order protocol framework is synthesized into an initial protocol template by using an inline framework in the HTML technology.
Wherein the inline frame is a tag in HTML for an inline combined protocol frame. The inline frame may be, but is not limited to being, an iframe. The initial protocol template is a protocol template obtained by combining order protocol frames. For example, when the order information is the insurance application order information of the vehicle, the general information protocol framework of the order information comprises a customer information order protocol framework, a channel information order protocol framework, a target information order protocol framework and the like, and the order protocol frameworks are combined into a complete protocol template through an HTML (hypertext markup language) inline framework, so that the initial protocol template is obtained.
It can be appreciated that the order protocol framework is synthesized into the initial protocol template by utilizing the inline framework in the HTML technology, so that the protocol framework of the general information is accurate and complete, and the subsequent further processing of the general information based on the initial protocol template is facilitated. The workload of repeated information processing is reduced.
S323: and in the initial protocol template, the general information is stored by using a data persistence layer framework, so as to obtain the order protocol template.
Wherein the data persistence layer framework is a lightweight Object Relational Mapping (ORM) framework for storing files. The data persistence layer framework may be, but is not limited to being, tbatis.
In this embodiment, the data persistence layer framework is used to store general information. Specifically, in the initial protocol template, the general information is transmitted to the background through the SpingMVC framework, and then is stored into the database through the data persistence layer framework. The SpringMVC framework provides a full-function MVC module for constructing Web application programs. The MVC architecture using Spring insertable can be selected to use a built-in Spring Web framework Web frame. The data persistence layer framework configures various general information to be executed in an xml or annotation mode, maps the java object and the sql statement in the state to generate a finally executed sql statement, and finally, the data persistence layer framework executes the sql statement, maps the general information into the java object and returns the java object to obtain an order protocol template. The method realizes quick and accurate generation of the order agreement template.
In this embodiment, first, a protocol framework of general information is acquired as an order protocol framework. And then, an order protocol framework is synthesized into an initial protocol template by utilizing an inline framework in an HTML technology, so that the protocol framework of the general information is accurate and complete, and the general information is further processed based on the initial protocol template. The workload of repeated information processing is reduced. Finally, in the initial protocol template, the general information is saved by using the data persistence layer framework to obtain an order protocol template, so that the order protocol template is quickly and accurately generated.
In one embodiment, as shown in fig. 6, in step S40, the customization information is subjected to file template customization to obtain an order customization template, which specifically includes the following steps:
s41: and acquiring a custom template sample through the JSP page according to the custom information.
Where a JSP page refers to a Web page with JSP elements that define the content of the document information. In this embodiment, according to the customization information, the content of the customization information is defined through the JSP page and is used as a customization template sample.
S42: the custom template sample is transformed into an XSL file using a background framework.
The background frame is a frame for converting the format of the file by the background. XSL files refer to files that use Excel tables for storing information. Specifically, the custom template sample is converted into an XSL file by using the background frame, so that custom information can be stored more accurately and conveniently, and further processing can be performed on the custom information more efficiently.
In a specific embodiment, for order information of a vehicle model number, a license plate number and an insurance year, after a custom template sample is obtained through a JSP page, the custom template sample is set to be a vehicle model number custom template sample, a license plate number custom template sample and an insurance year custom template sample, and corresponding custom template samples are defined, namely three fields of a vehicle model number field, a license plate number field and an insurance year field are defined, the types of the vehicle model number field and the license plate number field are character string types, and the types of the insurance year field are date types. And converting the custom template sample into an XSL file by using a background frame according to the corresponding field and the field type.
S43: and outputting the XLS file through a Java output stream to obtain an order customization template.
The Java output stream is an output class in Java, and is used for outputting a file. Specifically, the XLS file is downloaded to the client through a Java output stream and then output and displayed, so that an order customization template is obtained.
In this embodiment, the XLS file is output through the Java output stream, so that the XLS file can be accurately and quickly output, and further, an order customization template is obtained, and the generation efficiency of the order customization template is improved.
In this embodiment, first, according to the customization information, a customization template sample is obtained through a JSP page. And then, converting the custom template sample into an XSL file by using a background frame, so that the custom information can be stored more accurately and conveniently, and further processing the custom information more efficiently. And finally, outputting the XLS file through a Java output stream to obtain an order customization template, so that the generation efficiency of the order customization template is improved.
In one embodiment, as shown in fig. 7, in step S42, the custom template sample is transformed into an XSL file by using a background frame, which specifically includes the following steps:
S421: the customization information is generated into a document object, which includes the cell identification.
Where a document object refers to an information object contained in a file. For example, word objects, excel objects, or Visio objects, etc. In this embodiment, the document object refers to an Excel object, where the Excel object includes a cell identifier for uniquely identifying a cell where the document object is located.
Specifically, the customization information is generated into a document object through an HSSF interface. I.e. first create an HSSHWorkbook, corresponding to an Excel file, using the HSSF interface. The form HSSFsheet is then generated by HSSHWorkbook, corresponding to the sheet in the Excel file. Then, a list HSSFRow is generated by HSSHWorkbook, the zeroth row of the header is added to HSSFsheet, and a list HSSFCell is generated by HSSHWorkbook. And creating the cells, setting the customized information as the values of the cells, and further generating the document object.
S422: and storing the customized information in the cell corresponding to the cell identifier by using the background frame to obtain the XLS file.
Specifically, the background frame is utilized to store the customized information in the cell corresponding to the cell identifier, and the file is output to the client to obtain the XLS file. The order customization template generation efficiency is improved, so that customization information can be efficiently processed later.
In this embodiment, the customization information is generated into a document object. And storing the customized information in the cell corresponding to the cell identifier by using the background frame to obtain an XLS file, so that the order customization template generation efficiency is improved, and the customized information can be processed in a high-efficiency manner.
In one embodiment, in step S60, generating, based on the correspondence, a target order information base corresponding to each type of identifier through a manifest upload control of the order service system includes:
traversing each order agreement template, and generating the target order information base corresponding to each type of identification through a list uploading control of the order business system by an order customization template with a corresponding relation with the order agreement template.
Specifically, each order agreement template is traversed, and when the order customization template with the corresponding relation with the order agreement template is traversed, the order agreement template and the order customization template are generated into a target order information base corresponding to each type identifier through a list uploading control of an order service system. Because the order agreement template and the order customization template with the corresponding relation are used for simultaneously generating the target order information base, the rapid and accurate generation of the target order information base is ensured, and the efficiency of order batch processing is improved.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
In one embodiment, an order batch processing apparatus is provided, where the order batch processing apparatus corresponds to the order batch processing method in the above embodiment one by one. As shown in fig. 8, the order batch processing apparatus includes an order information base acquisition module 10, an order information dividing module 20, a protocol template acquisition module 30, a custom template acquisition module 40, a correspondence acquisition module 50, and a target order information base acquisition module 60. The functional modules are described in detail as follows:
the order information base acquisition module 10 is configured to acquire an order information base, where the order information base includes order information and a type identifier corresponding to each order information;
the order information dividing module 20 is configured to divide order information corresponding to each type of identifier according to a preset classification mode, so as to obtain general information and custom information corresponding to each type of identifier;
the protocol template acquisition module 30 is used for configuring the template of the general information to obtain an order protocol template;
The custom template obtaining module 40 is configured to perform file template customization on the custom information to obtain an order custom template;
the correspondence acquiring module 50 is configured to associate the order agreement template with the order customization template, so as to obtain a correspondence between the order agreement template and the order customization template in each order information;
the target order information base obtaining module 60 is configured to generate a target order information base corresponding to each type of identifier through a list uploading control of the order service system based on the correspondence.
Preferably, the order information dividing module includes a keyword extraction unit, a keyword number acquisition unit, and an information dividing unit.
The keyword extraction unit is used for extracting keywords of each order information by adopting a keyword extraction algorithm;
the keyword number acquisition unit is used for traversing each order information and acquiring the number of each keyword;
the information dividing unit is used for taking the keywords with the number of the keywords reaching the threshold value as general information and taking the keywords with the number of the keywords not reaching the threshold value as custom information.
Preferably, the protocol template acquisition module comprises a validity check unit and an order protocol generation unit.
The validity checking unit is used for carrying out validity checking on the general information;
And the order protocol generation unit is used for generating the general information into an order protocol template by adopting an HTML technology if the validity check is passed.
Preferably, the order protocol generation unit comprises a protocol framework acquisition subunit, an initial protocol template synthesis subunit and a protocol template acquisition subunit.
The protocol framework acquisition subunit is used for acquiring a protocol framework of the general information and is used as an order protocol framework;
an initial protocol template synthesis subunit, configured to synthesize an order protocol framework into an initial protocol template by using an inline framework in an HTML technology;
and the protocol template acquisition subunit is used for storing the general information in the initial protocol template by using the data persistence layer framework to obtain the order protocol template.
Preferably, the customized template acquisition module includes a template sample acquisition unit, a file conversion unit, and a customized template output unit.
The template sample acquisition unit is used for acquiring a customized template sample through a JSP page according to the customized information;
the file conversion unit is used for converting the custom template sample into an XSL file by using a background frame;
and the custom template output unit is used for outputting the XLS file through a Java output stream to obtain an order custom template.
Preferably, the file conversion unit includes a document object generation sub-unit and a file acquisition sub-unit.
A document object generating subunit, configured to generate a document object from the customization information, where the document object includes a cell identifier;
and the file acquisition subunit is used for storing the customized information in the cell corresponding to the cell identifier by utilizing the background frame to obtain the XSL file.
Preferably, the target order information base acquiring module includes a target order information base acquiring unit, configured to traverse each order agreement template, and generate, through a manifest uploading control of the order service system, the target order information base corresponding to each type identifier, an order customization template having a corresponding relationship with the order agreement template.
For specific limitations of the order batch processing apparatus, reference may be made to the above limitation of the order batch processing method, and no further description is given here. The various modules in the order batch processing device described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 9. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used for storing data used in the order batch processing method. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program when executed by a processor implements an order bulk processing method.
In one embodiment, a computer device is provided comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of when executing the computer program:
Acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to the order information;
dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification;
performing template configuration on the general information to obtain an order protocol template;
customizing the file template of the customization information to obtain an order customization template;
associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information;
and generating a target order information base corresponding to each type identifier through a list uploading control of the order service system based on the corresponding relation.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
the order information base acquisition module is used for acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to the order information;
The order information dividing module is used for dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification;
the protocol template acquisition module is used for carrying out template configuration on the general information to obtain an order protocol template;
the custom template acquisition module is used for customizing the file template of the custom information to obtain an order custom template;
the corresponding relation acquisition module is used for associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information;
and the target order information base acquisition module is used for generating a target order information base corresponding to each type identifier through a list uploading control of the order service system based on the corresponding relation.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (4)
1. An order batch processing method, characterized in that the order batch processing method comprises:
acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to the order information;
Dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification;
performing template configuration on the general information to obtain an order protocol template;
customizing the file template of the customization information to obtain an order customization template;
associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information;
traversing each order agreement template, and generating a target order information base corresponding to each type identifier through a list uploading control of an order service system by using the order customization templates with the corresponding relation with the order agreement templates;
the step of dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and custom information corresponding to each type of identification comprises the following steps:
extracting keywords of each order information by using a keyword extraction algorithm;
traversing each order information to obtain the number of each keyword;
the keywords with the number reaching the threshold value are used as general information, and the keywords with the number not reaching the threshold value are used as custom information;
The configuring the template for the general information to obtain an order protocol template comprises the following steps:
carrying out validity check on the general information;
if the validity check is passed, the general information is generated into the order protocol template by adopting an HTML technology;
the step of generating the order agreement template from the general information by adopting an HTML technology comprises the following steps:
acquiring a protocol framework of the general information as an order protocol framework;
synthesizing the order protocol framework into an initial protocol template by using an inline framework in an HTML technology;
in the initial protocol template, the general information is stored by using a data persistence layer framework to obtain the order protocol template;
the customizing the file template of the customizing information to obtain an order customizing template comprises the following steps:
acquiring a custom template sample through a JSP page according to the custom information;
converting the customized template sample into an XLS file by using a background frame;
outputting the XLS file through a Java output stream to obtain the order customization template;
the converting the custom template sample into an XLS file using a background framework includes:
generating a document object from the customized information, wherein the document object comprises a cell identifier;
And storing the customized information in the cell corresponding to the cell identifier by using a background frame to obtain the XLS file.
2. An order batch processing apparatus for implementing the order batch processing method of claim 1, characterized in that the order batch processing apparatus comprises:
the order information base acquisition module is used for acquiring an order information base, wherein the order information base comprises order information and type identifiers corresponding to the order information;
the order information dividing module is used for dividing the order information corresponding to each type of identification according to a preset classification mode to obtain general information and customized information corresponding to each type of identification;
the protocol template acquisition module is used for carrying out template configuration on the general information to obtain an order protocol template;
the custom template acquisition module is used for customizing the file template of the custom information to obtain an order custom template;
the corresponding relation acquisition module is used for associating the order agreement template with the order customization template to obtain the corresponding relation between the order agreement template and the order customization template in each order information;
And the target order information base acquisition module is used for traversing each order agreement template, and generating a target order information base corresponding to each type identifier through a list uploading control of an order service system by using the order customization templates with the corresponding relations with the order agreement templates.
3. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the order bulk processing method of claim 1 when the computer program is executed by the processor.
4. A computer readable storage medium storing a computer program, which when executed by a processor implements the order bulk processing method of claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811339094.XA CN109685668B (en) | 2018-11-12 | 2018-11-12 | Order batch processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811339094.XA CN109685668B (en) | 2018-11-12 | 2018-11-12 | Order batch processing method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109685668A CN109685668A (en) | 2019-04-26 |
| CN109685668B true CN109685668B (en) | 2024-03-29 |
Family
ID=66184723
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811339094.XA Active CN109685668B (en) | 2018-11-12 | 2018-11-12 | Order batch processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109685668B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110704425B (en) * | 2019-09-04 | 2023-07-11 | 华东江苏大数据交易中心股份有限公司 | Data customizing system |
| CN111429243A (en) * | 2020-03-23 | 2020-07-17 | 北京同邦卓益科技有限公司 | Bill generation method and device, electronic equipment and storage medium |
| CN113222519A (en) * | 2021-06-11 | 2021-08-06 | 刘慧莹 | System management method and device, electronic equipment and readable storage medium |
| CN113723903A (en) * | 2021-08-02 | 2021-11-30 | 北京来也网络科技有限公司 | RPA (Security platform Association) and AI (Internet Access Association) combined pass ticket transaction method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106815366A (en) * | 2017-01-23 | 2017-06-09 | 北京思特奇信息技术股份有限公司 | A kind of method and system of Mass production data |
| CN106933598A (en) * | 2017-03-27 | 2017-07-07 | 广州市轩辕云翰信息科技有限公司 | Realize the method and system of the automatic management of template file |
| CN107798579A (en) * | 2017-10-19 | 2018-03-13 | 中国平安财产保险股份有限公司 | The generation method and its terminal of a kind of document of agreement |
| CN107977876A (en) * | 2016-10-25 | 2018-05-01 | 北京京东尚科信息技术有限公司 | For handling the method and device of sequence information |
| CN108268593A (en) * | 2017-12-08 | 2018-07-10 | 中国平安财产保险股份有限公司 | Credit card is insured processing method, device, server and the storage medium of information |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7742931B2 (en) * | 2001-08-20 | 2010-06-22 | Siemens Medical Solutions Usa, Inc. | Order generation system and user interface suitable for the healthcare field |
-
2018
- 2018-11-12 CN CN201811339094.XA patent/CN109685668B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107977876A (en) * | 2016-10-25 | 2018-05-01 | 北京京东尚科信息技术有限公司 | For handling the method and device of sequence information |
| CN106815366A (en) * | 2017-01-23 | 2017-06-09 | 北京思特奇信息技术股份有限公司 | A kind of method and system of Mass production data |
| CN106933598A (en) * | 2017-03-27 | 2017-07-07 | 广州市轩辕云翰信息科技有限公司 | Realize the method and system of the automatic management of template file |
| CN107798579A (en) * | 2017-10-19 | 2018-03-13 | 中国平安财产保险股份有限公司 | The generation method and its terminal of a kind of document of agreement |
| CN108268593A (en) * | 2017-12-08 | 2018-07-10 | 中国平安财产保险股份有限公司 | Credit card is insured processing method, device, server and the storage medium of information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109685668A (en) | 2019-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109685668B (en) | Order batch processing method, device, computer equipment and storage medium | |
| CN109947789B (en) | Method, device, computer equipment and storage medium for processing data of multiple databases | |
| WO2020186786A1 (en) | File processing method and apparatus, computer device and storage medium | |
| CN109558575B (en) | Online form editing method, online form editing device, computer equipment and storage medium | |
| CN109710677B (en) | Experiment data processing method and device, computer equipment and storage medium | |
| CN110909226A (en) | Financial document information processing method and device, electronic equipment and storage medium | |
| CN109783785B (en) | Method and device for generating experiment detection report and computer equipment | |
| WO2020057021A1 (en) | Data table processing method and device, computer device and storage medium | |
| CN110765101B (en) | Label generation method and device, computer readable storage medium and server | |
| CN110674131A (en) | Financial statement data processing method and device, computer equipment and storage medium | |
| CN110046155B (en) | Method, device and equipment for updating feature database and determining data features | |
| CN114357943A (en) | Universal efficient Excel reading processing method, tool, medium and equipment | |
| US11544669B2 (en) | Computing framework for compliance report generation | |
| CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
| CN114003692A (en) | Contract text information processing method and device, computer equipment and storage medium | |
| US11500840B2 (en) | Contrasting document-embedded structured data and generating summaries thereof | |
| CN109542890B (en) | Data modification method, device, computer equipment and storage medium | |
| CN111639903A (en) | Review processing method for architecture change and related equipment | |
| CN116453125A (en) | Data input method, device, equipment and storage medium based on artificial intelligence | |
| WO2020057023A1 (en) | Natural-language semantic parsing method, apparatus, computer device, and storage medium | |
| CN113050933B (en) | Brain graph data processing method, device, equipment and storage medium | |
| CN111882419B (en) | Method and device for quality inspection of files and server | |
| CN109582676B (en) | Power data processing method and device, computer equipment and storage medium | |
| CN112860722A (en) | Data checking method and device, electronic equipment and readable storage medium | |
| CN111913993B (en) | Table data generation method, apparatus, electronic device and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |