CN117743373A - Document processing method, device, computer equipment and storage medium - Google Patents
Document processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN117743373A CN117743373A CN202311816282.8A CN202311816282A CN117743373A CN 117743373 A CN117743373 A CN 117743373A CN 202311816282 A CN202311816282 A CN 202311816282A CN 117743373 A CN117743373 A CN 117743373A
- Authority
- CN
- China
- Prior art keywords
- field
- target
- bill
- index
- dimension
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 30
- 238000004458 analytical method Methods 0.000 claims abstract description 49
- 238000012545 processing Methods 0.000 claims abstract description 39
- 238000000034 method Methods 0.000 claims abstract description 35
- 230000004044 response Effects 0.000 claims abstract description 31
- 238000004590 computer program Methods 0.000 claims abstract description 22
- 230000001960 triggered effect Effects 0.000 claims description 16
- 239000000463 material Substances 0.000 description 20
- 230000000737 periodic effect Effects 0.000 description 16
- 238000010586 diagram Methods 0.000 description 14
- 230000000007 visual effect Effects 0.000 description 9
- 238000004891 communication Methods 0.000 description 6
- 238000004364 calculation method Methods 0.000 description 5
- 230000008520 organization Effects 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000005553 drilling Methods 0.000 description 1
- 229910021389 graphene Inorganic materials 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012946 outsourcing Methods 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a document processing method, a document processing device, a computer device, a storage medium and a computer program product. The method comprises the following steps: displaying a bill detail interface corresponding to the target bill; the bill detail interface displays a basic field and a target index field of a target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field; displaying an index card of the target document aiming at the target index field in response to the query analysis operation aiming at the target index field, and displaying a first splitting result of the target field value in the target display dimension in the index card; the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model. The bill processing efficiency can be improved by adopting the method.
Description
Technical Field
The present invention relates to the field of computer technology, and in particular, to a document processing method, apparatus, computer device, storage medium, and computer program product.
Background
Along with the development of computer technology, document processing technology appears, and in document analysis scenes, different business scenes often correspond to different document inquiry requirements. And inquiring the documents meeting the requirements in a large number of documents under different service scenes, and carrying out statistical analysis on the inquired documents according to the service scene requirements.
The traditional method needs to develop a corresponding query interface according to the requirements of each service scene, manually inputs query conditions in the query interface, queries documents meeting the requirements, analyzes and processes the queried documents, and has the problem of low document processing efficiency.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a document processing method, apparatus, computer device, computer-readable storage medium, and computer program product that can improve the document processing efficiency.
The application provides a bill processing method. The method comprises the following steps:
displaying a bill detail interface corresponding to the target bill; the bill detail interface displays a basic field and a target index field of a target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field;
Displaying an index card of the target document aiming at the target index field in response to the query analysis operation aiming at the target index field, and displaying a first splitting result of the target field value in the target display dimension in the index card; the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model.
The application also provides a bill processing device. The device comprises:
the bill display module is used for displaying bill detail interfaces corresponding to the target bill; the bill detail interface displays a basic field and a target index field of a target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field;
the index card display module is used for responding to query analysis operation aiming at the target index field, displaying an index card of the target document aiming at the target index field, and displaying a first split result of a target field value in a target display dimension in the index card; the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model.
A computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps of the bill processing method when executing the computer program.
A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the document processing method described above.
A computer program product comprising a computer program which, when executed by a processor, performs the steps of the document processing method described above.
According to the bill processing method, the bill processing device, the computer equipment, the storage medium and the computer program product, through displaying the bill detail interface corresponding to the target bill, the basic field and the target index field of the target bill are displayed in the bill detail interface, the target field value of the target index field is obtained by obtaining the target index model containing the target index field corresponding to the target bill, inquiring the bill based on the condition field in the target index model, and counting the inquired first bill set based on the target index field. In this way, the target index field and the target index model corresponding to the target index field are set for the target bill, and when the bill detail interface is displayed, bill inquiry and statistics are carried out based on the target index model corresponding to the target index field, so that the field value corresponding to the target index field is obtained, automatic processing of bill inquiry analysis is realized, and the bill processing efficiency can be effectively improved. And further, in response to query analysis operation for the target index field, displaying an index card of the target document for the target index field, and displaying a first splitting result of the target field value in the target display dimension in the index card, wherein a second document set corresponding to the first splitting result is obtained by inquiring the document based on the dimension field in the target index model. In this way, document inquiry is carried out according to the dimension field in the target index model corresponding to the target index field, so that a first splitting result of the target field value in the target display dimension is obtained, multi-level visual inquiry and analysis of the target index field are realized, and document processing efficiency can be improved.
Drawings
FIG. 1 is an application environment diagram of a document processing method in one embodiment;
FIG. 2 is a flow diagram of a document processing method in one embodiment;
FIG. 3 is a schematic diagram of a document detail interface in one embodiment;
FIG. 4 is a schematic diagram of an index model configuration interface in one embodiment;
FIG. 5 is a schematic diagram of a toggle query button display indicator card in one embodiment;
FIG. 6 is a schematic diagram of a pointer card in one embodiment;
FIG. 7 is a flow diagram of configuring a target index model in one embodiment;
FIG. 8 is a schematic diagram of creating an index field in one embodiment;
FIG. 9 is a schematic diagram of an index model configuration interface in another embodiment;
FIG. 10 is a flow chart of a document processing method according to another embodiment;
FIG. 11 is a schematic diagram of creating an index field in one embodiment;
FIG. 12 is a block diagram of a document processing device in one embodiment;
FIG. 13 is a block diagram of a document processing device in another embodiment;
fig. 14 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The bill processing method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, which may be smart televisions, smart car devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers. The terminal 102 and the server 104 may be directly or indirectly connected through wired or wireless communication, which is not limited herein.
The terminal can be independently used for executing the bill processing method provided in the embodiment of the application.
For example, the terminal displays a bill detail interface corresponding to the target bill. The bill detail interface displays a basic field and a target index field of a target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field. The terminal responds to query analysis operation aiming at the target index field, an index card of the target bill aiming at the target index field is displayed, a first splitting result of the target field value in the target display dimension is displayed in the index card, and a second bill set corresponding to the first splitting result is obtained by bill query based on the dimension field in the target index model.
In one embodiment, as shown in fig. 2, a document processing method is provided, and the method is applied to a terminal for illustration, and the document processing method includes the following steps:
step S202, a bill detail interface corresponding to a target bill is displayed; the bill detail interface displays a basic field and a target index field of a target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field.
The target bill refers to a bill to be processed. The bill detail interface is an interface for displaying bill detailed information, and comprises a basic field and an index field in the bill. For example, as shown in fig. 3, a document detail interface is shown, where a document base field area and an index field area are included, where the base field area shows base fields such as document number, usage organization, calculation status, material coding, minimum stock, etc., and the index field area shows seven index fields such as periodic ex-warehouse number, unit price, periodic maximum ex-warehouse number, days with transaction date, etc. The basic field refers to the original field of the bill, the index field refers to the field obtained by counting the queried bill set, and the index field is displayed on the bill detail interface, so that a manager can conveniently and quickly know some statistics index information corresponding to the bill, and the manager does not need to manually query the bill and count the index. For example, when the order document is an order document of the customer a, the order document includes a plurality of basic fields for indicating detailed information of the order, and index fields such as a monthly average order amount, a monthly maximum order amount, a monthly order acceptance rate and the like can be set in the order document of the customer a, wherein the field values of the monthly average order amount and the monthly maximum order amount are obtained by counting the order amounts of the order documents of the customer a in the current month, the monthly order acceptance rate is obtained by counting the order states of the order documents of the customer a in the current month, and the monthly average order amount, the monthly maximum order amount and the monthly order acceptance rate are set in the document detail interface of the order document of the customer a, so that a manager can conveniently and rapidly know the month comprehensive acceptance condition corresponding to the month in which the order document of the customer a is located when opening the document detail interface of any one of the order document of the customer a.
The target index field refers to an index field displayed on a bill detail interface corresponding to the target bill. The target field value of the target index field refers to a field value corresponding to the target index field obtained by counting the queried first bill set based on the target index field.
The index model is a model obtained by binding each condition field with a corresponding dimension field in an index template after determining a plurality of condition fields in each basic field contained in the bill. For example, as shown in fig. 4, when an index field is created in a document, an index template (index value model) needs to be selected first, after an inventory pipeline model is selected as the index template, each preset condition field is respectively bound with a corresponding dimension field in the index template, specifically, basic fields such as an organization name parameter, a time parameter, a material coding parameter and the like in the document are preset as condition fields, further, the organization name parameter is bound with the dimension field of the inventory organization name in the index template, the time parameter is bound with the dimension field of the service date in the index template, and the material coding parameter is bound with the dimension field of the material coding in the index template, so as to obtain the configured index model.
The index template is provided with a plurality of dimension fields and one or more index fields, each dimension field is used as a query condition, document query is carried out through field values corresponding to condition fields bound with the dimension fields in documents, and statistics is carried out on a first document set obtained through query based on a field value calculation method respectively corresponding to each index field configured in the index template to obtain field values respectively corresponding to each index field. For example, after the index model configuration interface shown in fig. 4 configures the index model corresponding to the bill, the index fields to be displayed on the bill detail interface need to be selected from the index fields included in the index model, and as shown in fig. 3, the number of periodic outgoing, the unit price of outgoing, the maximum number of periodic outgoing, the number of days with transaction date, the amount of periodic outgoing, the number of days with transaction date, and the average outgoing number of each batch are all index fields included in the inventory running water model. In the actual implementation process, the index models of the index fields included in the bill detail interface may be different, that is, a plurality of index fields may be created in the same bill by different index models. Inquiring a first bill set corresponding to the bill according to the field value corresponding to the condition field bound by each dimension field in the index model in the bill, and further counting the first bill set according to the calculation method of the index field configured in the index model to obtain the field value corresponding to the index field. The target index model refers to an index model to which a target index field belongs. The first bill collection refers to a collection comprising bills obtained by inquiring the bills based on condition fields in the target index model.
The terminal displays a bill detail interface corresponding to the target bill, and the bill detail interface displays a basic field contained in the target bill and a target index field corresponding to the target bill. Specifically, a target index field in a target bill is configured through a target index model, a target index model to which the target index field belongs is obtained, a first bill set is queried based on a field value corresponding to a condition field in the target index model in the target bill, and statistics is performed on the queried first bill set based on the target index field to obtain a target field value corresponding to the target index field.
Step S204, in response to query analysis operation for the target index field, displaying an index card of the target document for the target index field, and displaying a first split result of the target field value in the target display dimension in the index card; the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model.
The query analysis operation is an operation triggered by a user on a bill detail interface and used for checking a first splitting result of a target index field on a target display dimension. In an actual implementation process, the query analysis operation may be a trigger operation for the target indicator field, a trigger operation for a query button corresponding to the target indicator field, and so on. For example, as shown in fig. 5, a query button for triggering a query analysis operation is correspondingly set in the index field in the bill detail interface, after the query button is triggered, field values corresponding to each condition field in the index model corresponding to the index field are respectively used as parameters to be transmitted into the index model, bill query is performed based on the field values corresponding to each condition field in the index model, and a query result is displayed in an index card corresponding to the index field.
The index card refers to a statistical analysis interface for the target index field, which is displayed in response to a query analysis operation for the target index field, and displays a first splitting result of a target field value of the target index field in a target display dimension in a visual chart (such as a bar chart, a line chart and the like). For example, as shown in fig. 6, the index card corresponding to the index field of the periodic ex-warehouse number shows a field value 4941.00 corresponding to the periodic ex-warehouse number in the index card, the field value corresponding to each dimension field in the target index model respectively, and when the dimension field of the service date is taken as the target showing dimension, the first splitting result corresponding to the target field value, specifically, the field value corresponding to the condition field bound by the dimension field in the target document is taken as the field value of the dimension field, and further, the second document set is queried based on the field value corresponding to each dimension field respectively, the document numbers corresponding to each document in the second document set are summed to obtain the field value of the periodic ex-warehouse number, and when the target showing dimension is the service date, each document in the second document set is divided according to the service date to obtain the periodic ex-warehouse number corresponding to each document. In the actual implementation process, the index card corresponding to the target index field can also display each dimension field and the field value corresponding to each dimension field in the target index model, so that the user can intuitively know the query condition corresponding to the second bill set.
The second bill collection is a collection of bills obtained by inquiring the bills based on field values corresponding to dimension fields in the target index model. Dividing the second bill set into a plurality of sub bill sets based on the target display dimension, and respectively counting each sub bill set based on the target index field to obtain statistics values respectively corresponding to each sub bill set, wherein a first splitting result of the target field value on the target display dimension comprises statistics values respectively corresponding to each sub bill set and each sub bill set corresponding to the second bill set under the target display dimension. The splitting result is a result obtained by carrying out finer division and statistics on the queried bill set based on the target display dimension. The first splitting result is a result obtained by dividing and counting the second bill set based on the target display dimension.
Illustratively, the terminal presents an index card for the target index field for the target document in response to a query analysis operation for the target index field. Specifically, based on field values corresponding to the condition fields bound to the dimension fields in the target index model in the target document, document inquiry is performed to obtain a second document set. Dividing the second bill set into a plurality of sub bill sets based on the target display dimension, respectively counting each sub bill set based on the target index field to obtain statistics values respectively corresponding to each sub bill set, and obtaining a first splitting result of the target field value in the target display dimension based on statistics values respectively corresponding to each sub bill set and each sub bill set of the second bill set under the target display dimension. The first split result can be displayed in the index card in the form of a statistical chart, a list and the like. In addition, the bill detail interface can be divided into a basic field display area, an index field display area and an index card display area, the index card display area in the bill detail interface displays the index card of the target index field in response to the query analysis operation on the target index field, in addition, the bill detail interface can be displayed in a popup window creating mode, and the index card is displayed through a newly-built independent window.
In one embodiment, as shown in fig. 6, the index card includes a splitting result display area, where the splitting result display area is used to display splitting results corresponding to the index fields in the form of a statistical chart, a list, or the like, and in addition, at least one of a dimension determining area, a dimension field display area, and a target index field display area may be displayed in the index card. The dimension display area displays a plurality of selectable display dimensions, the target display dimensions can be determined in a plurality of display dimensions provided by the dimension display area, the dimension field display area is used for displaying field values corresponding to each dimension field in the target index model respectively, namely bill filtering conditions corresponding to the target index model at present, and the target index field display area is used for displaying target field values corresponding to the target index fields.
In the bill processing method, through displaying the bill detail interface corresponding to the target bill, the basic field and the target index field of the target bill are displayed in the bill detail interface, the target field value of the target index field is obtained by obtaining the target index model containing the target index field corresponding to the target bill, bill inquiry is carried out based on the condition field in the target index model, and statistics is carried out on the inquired first bill set based on the target index field. In this way, the target index field and the target index model corresponding to the target index field are set for the target bill, and when the bill detail interface is displayed, bill inquiry and statistics are carried out based on the target index model corresponding to the target index field, so that the field value corresponding to the target index field is obtained, automatic processing of bill inquiry analysis is realized, and the bill processing efficiency can be effectively improved. And further, in response to query analysis operation for the target index field, displaying an index card of the target document for the target index field, and displaying a first splitting result of the target field value in the target display dimension in the index card, wherein a second document set corresponding to the first splitting result is obtained by inquiring the document based on the dimension field in the target index model. In this way, document inquiry is carried out according to the dimension field in the target index model corresponding to the target index field, so that a first splitting result of the target field value in the target display dimension is obtained, multi-level visual inquiry and analysis of the target index field are realized, and document processing efficiency can be improved.
In one embodiment, as shown in fig. 7, before the document detail interface corresponding to the target document is displayed, the document processing method further includes:
step S702, responding to the index template selection operation aiming at the target bill, displaying the fields matched with the selected target index template in the basic fields as the condition fields, and binding the dimension fields matched with the condition fields in the plurality of dimension fields provided by the target index template with the condition fields.
Step S704, in response to the index field configuration operation, shows a target index field selected from a plurality of candidate index fields provided by the target index template.
Step S706, the condition field, the dimension field bound with the condition field and the target index field form a target index model of the target document on the target index template.
Wherein the index template selection operation refers to an operation for selecting an index template. The index field configuration operation refers to an operation of selecting an index field for displaying on a document detail interface corresponding to a target document from among index fields provided by a target index template. The target index template is the index template selected by the index template selection operation.
Illustratively, before a document detail interface corresponding to a target document is displayed, a target index field needs to be configured in the target document. First, in response to an index template selection operation for a target document, an index template selected by the index template selection operation is taken as a target index template. Further, the condition field is determined in the basic fields included in the target document and matched with the target index template, and the basic fields matched with the target index template are basic fields having the same data type as the data type of a certain dimension field in the target index template, for example, when the dimension field included in the target index model is a date, the basic fields such as a shipment date, a calculation date, a collection date and the like are basic fields matched with the target index template. Next, a dimension field matched with each condition field is determined from a plurality of dimension fields provided by the target index template, and the condition field is bound with the matched dimension field. Further, in response to the target indicator field configuration operation, a target indicator field that needs to be presented in the target document is determined among a plurality of candidate indicator fields provided by the target indicator template. And forming a target index model of the target document on the target index template based on the condition field, the dimension field bound with the condition field and the target index field.
In one embodiment, after the target index template is selected, an index model configuration interface corresponding to the target index template is displayed, and a condition field is determined in basic fields which are contained in the target document and matched with the target index template is displayed in the index model configuration interface. And setting a corresponding dimension field binding component for each condition field, displaying each dimension field contained in the target index template based on the dimension field binding component corresponding to the condition field, and binding the dimension field selected by the dimension field binding operation with the condition field in response to the dimension field binding operation for the condition field. The index model configuration flow is realized through the visual configuration interface, so that the efficiency and the flexibility of index model configuration can be improved.
In one embodiment, the condition fields exhibited by the target index template for the target document may be a pre-selected plurality of base fields among the base fields contained by the target document that match the target index template. For example, as shown in fig. 4, the index model configuration interface corresponding to the target index template is preconfigured for the condition fields shown by the target bill, that is, the condition fields such as the organization name parameter, the time parameter, the material coding parameter and the like are preconfigured, and manual selection is not needed, so that the flow of index model configuration can be simplified, and the bill processing efficiency is improved.
In one embodiment, as shown in fig. 8, the terminal may create an index field in a target document and expose an index model configuration interface corresponding to the index field in response to a drag operation for the index field control 802 triggered in the document configuration interface. The index model configuration interface corresponding to the index field is shown in fig. 9, and includes an index condition field configuration area 902 and a dimension field determination area 904. The condition fields displayed for the target document can be fields determined in basic fields which are contained in the target document and matched with the target index template in response to the condition field selection operation for the target index template, namely, the condition fields and the dimension fields in the target index template can be manually configured, so that the flexibility of document processing can be improved.
In the above embodiment, the preset index template is obtained as the target index template, so that corresponding dimension fields are bound for each condition field in the target index template, and finally, the index field required to be displayed on the target document is selected from all the index fields contained in the target index template, so as to obtain the target index model of the target document on the target index template. By configuring the target index model for the target bill, the automatic processing of bill inquiry analysis is realized, and the bill processing efficiency can be effectively improved.
In one embodiment, the document processing method further includes:
inquiring a bill with a condition field and a field value of the target bill on the condition field in each candidate bill belonging to the same bill type with the target bill to obtain a first bill set; for any bill in the first bill set, acquiring a field matched with a target index field from a basic field of the bill as a reference field; and fusing the field values of all documents in the first document set on the respective reference fields based on the corresponding index description information of the target index field in the target index model to obtain the target field value of the target index field.
The document types are used for distinguishing the types of different documents, and for example, the documents can be classified into different types of documents such as sales delivery, production receiving, and outsourcing receiving.
The reference field refers to a field in a basic field of the bill, which is used for calculating a field value corresponding to a target index field, for example, when the target index field is a monthly average order amount, the reference field corresponding to the target index field in the bill is the basic field of the order amount in the bill; when the target index field is the monthly order success rate, the reference field corresponding to the target index field in the bill is the basic field of the order state in the bill; when the target index field is the periodic ex-warehouse number, the reference field corresponding to the target index field in the bill is the basic field of the ex-warehouse number in the bill; etc.
The index description information is configured in the target index model, and is used for indicating a reference field corresponding to a target index field in the document and indicating how to calculate a target field value of the target index field according to the field value of each queried document on the respective reference field. For example, when the target index field is a monthly average order amount, the reference field corresponding to the target index field in the bill is a basic field of the order amount in the bill, and the index description information corresponding to the monthly average order amount is Avg (order amount), that is, the order amounts corresponding to the respective orders in the bill set are averaged; when the target index field is the periodic ex-warehouse number, the reference field corresponding to the target index field in the bill is the basic field of the ex-warehouse number in the bill, and the index description information corresponding to the periodic ex-warehouse number is Sum (ex-warehouse number), namely the ex-warehouse numbers corresponding to the bills in the bill set are summed; etc.
The terminal queries candidate documents including the condition field in the target index model in each candidate document belonging to the same document type as the target document based on the field value corresponding to the condition field in the target index model corresponding to the target document, and the field value on the condition field is the same as the field value of the condition field in the target document, so as to obtain a first document set. And aiming at any bill in the first bill set, acquiring a field matched with the target index field from the basic field of the bill as a reference field. Specifically, based on index description information of the target index field in the target index model, a corresponding reference field of the target index field in the bill is determined. Further, a target field value of the target index field is calculated based on the index description information corresponding to the target index field in the target index model and the field values of the respective documents in the first document set on the respective reference fields.
In the above embodiment, the first document set is queried according to the field values corresponding to the condition fields in the target index model corresponding to the target index field. And further, determining a reference field corresponding to the target index field according to index description information corresponding to the target index field in the target index model, and fusing field values of all documents in the first document set on the respective reference fields based on the index description information to obtain a target field value of the target index field. By configuring the target index field in the target bill, the first bill set meeting the requirement can be quickly inquired based on the target index model corresponding to the target index field, and further, the target field value corresponding to the target index field can be calculated based on the inquired first bill set based on the index description information corresponding to the target index field in the target index model, so that the automatic processing of bill inquiry and bill totalization analysis is realized, and the bill processing efficiency can be effectively improved.
In one embodiment, in response to a query analysis operation for a target index field, displaying an index card of a target document for the target index field, displaying a first split result of a target field value in a target display dimension in the index card, comprising:
Responding to query analysis operation aiming at a target index field, and querying a document with a condition field bound with a dimension field in a target index model and a field value on the condition field matched with a field value of the dimension field in each candidate document belonging to the same document type with the target document to obtain a second document set; determining a target display dimension based on each dimension field corresponding to the target index model, and dividing the second bill set into a plurality of sub bill sets according to the target display dimension; for any bill in the sub-bill collection, acquiring a field matched with a target index field from a basic field of the bill as a reference field; based on index description information corresponding to the target index field in the target index model, fusing field values of all documents in the sub-document sets on respective reference fields to respectively obtain statistical values of all the sub-document sets aiming at the target index field, and forming a first splitting result of the target field value on a target display dimension; and displaying an index card of the target bill aiming at the target index field, and displaying a first splitting result in the index card.
The candidate bill is a bill which belongs to the same bill type as the target bill. The target presentation dimension refers to a presentation dimension determined based on each dimension field corresponding to the target index model. For example, when the target index model contains dimension fields such as customer name, customer province, material code, date, etc., any one of the dimension fields may be used as the target presentation dimension. The sub document set refers to a set obtained by dividing the second document set based on the target display dimension. For example, when the target display field is a material code, the second bill set is divided into sub bill sets corresponding to different material codes based on the material codes corresponding to the respective bills in the second bill set, and the material codes corresponding to the respective bills in the same sub bill set are the same; when the target display field is a customer province, dividing the second bill set into sub bill sets corresponding to different provinces, wherein the customer provinces corresponding to all the bills in the same sub bill set are the same; when the target display field is a date, dividing the second bill set into sub bill sets corresponding to different periods, specifically, the second bill set can be divided into bill sets corresponding to weekly/monthly/yearly, and the periods of all the bills in the same sub bill set are the same; etc.
The statistic value of the sub-bill set aiming at the target index field refers to a numerical value obtained by carrying out statistics on field values respectively corresponding to all the bills in the sub-bill set on respective reference fields based on index description information corresponding to the target index field. For example, when the target display dimension is a service date and the target index field is a periodic ex-warehouse number, the second bill set is divided into a plurality of sub bill sets based on the service date, and the statistics value corresponding to each sub bill set is the periodic ex-warehouse number corresponding to each week.
In an exemplary embodiment, the terminal queries, in response to a query analysis operation for the target indicator field, documents having a condition field bound to a dimension field in the target indicator model and a field value on the condition field matching a field value of the dimension field among candidate documents belonging to the same document type as the target document, to obtain the second document set. Specifically, a field value corresponding to a condition field contained in a target index model corresponding to a target bill in the target bill is obtained, the field value of the condition field is used as a field value of a dimension field bound with the condition field in the target index model, the target index model uses the field values corresponding to the dimension fields as filtering conditions, and a second bill set is queried in candidate bills belonging to the same type as the target bill. And then determining the target display dimension in each dimension field corresponding to the target index model. Specifically, a default dimension field may be set in each dimension field corresponding to the target index model, and when the field selection operation is not received, the default dimension field is directly used as the target display dimension, or the dimension field selected by the field selection operation may be used as the target display dimension in response to the field selection operation. And dividing the second bill set into a plurality of sub bill sets according to the target display dimension. For any bill in the sub-bill collection, a field matched with the target index field is obtained from the basic field of the bill to serve as a reference field, and specifically, the corresponding reference field of the target index field in the bill is determined based on the index description information of the target index field in the target index model. Further, based on the index description information corresponding to the target index field in the target index model and the field values of the respective documents in the same sub-document set on the respective reference fields, the statistical values of the respective sub-document sets for the target index field are calculated respectively. The statistic values respectively corresponding to the sub-bill sets form a first splitting result of the target field value in the target display dimension. And displaying a first splitting result through an index card of the target bill aiming at the target index field.
In the above embodiment, document inquiry is performed according to the target dimension field in the target index model corresponding to the target index field, so as to obtain the first splitting result of the target field value in the target display dimension, thereby realizing multi-level and visual inquiry and analysis for the target index field and improving the document processing efficiency.
In one embodiment, a query button corresponding to a target index field is displayed in a bill detail page, the query button is used for triggering a query analysis operation, an index card of the target bill for the target index field is displayed in response to the query analysis operation for the target index field, and the method comprises the following steps:
and responding to the triggering operation of the query button corresponding to the target index field in the bill detail interface, and displaying the index card of the target bill for the target index field.
The query button is a button control set for a target index field in the bill detail interface and is used for triggering query analysis operation for the target index field. And each target index control displayed in the bill detail interface is correspondingly provided with a query button.
The terminal responds to triggering operation of a query button corresponding to a target index field in the bill detail interface, and performs bill query based on a field value corresponding to a condition field bound by a dimension field in a target index model of the target index field in the target bill to obtain a second bill set. Dividing the second bill set into a plurality of sub bill sets based on the target display dimension, respectively counting each sub bill set based on the target index field to obtain statistics values respectively corresponding to each sub bill set, and obtaining a first splitting result of the target field value in the target display dimension based on statistics values respectively corresponding to each sub bill set and each sub bill set of the second bill set under the target display dimension. The first split result can be displayed in the index card in the form of a statistical chart, a list and the like.
In the embodiment, the query button for triggering the query analysis operation is correspondingly arranged for each target index field in the bill detail interface, and the index card corresponding to the display target index field can be rapidly triggered by triggering the query button corresponding to the target index field in the bill detail interface, so that the bill query efficiency is improved. And a query button is arranged for the target index field, so that a user can be intuitively prompted, and the target index field can be triggered to perform further query analysis through the query button, thereby improving the readability of the bill detail interface and the bill query efficiency.
In one embodiment, the document processing method further includes:
displaying a dimension field and a field value of the dimension field in the target index model in the index card; the field value of the dimension field is determined based on the field value corresponding to the condition field bound by the dimension field in the target document; responding to a field value updating operation aiming at a dimension field in the index card, and updating a field value corresponding to the dimension field under the constraint of the field value corresponding to the dimension field; the field value constraint corresponding to the dimension field is determined based on the field value of the target document on the condition field bound with the dimension field; responding to the query analysis operation triggered in the index card, and displaying a second split result of the updated field value of the target index field in the target display dimension in the index card; updating the field value, namely performing document inquiry based on the dimension field with the updated field value, and counting the inquired third document set based on the target index field.
The field value updating operation is an operation for updating a field value corresponding to a dimension field in the index card. The second splitting result is a result obtained by dividing and counting the third bill set based on the target display dimension. The query analysis operation triggered in the index card is triggered by a query button arranged in the index card, for example, as shown in fig. 6, a query button is arranged at the upper right corner of the index card corresponding to the target index field, which is the periodic ex-warehouse number, and after the field value corresponding to the dimension field in the index card is updated by the field value updating operation, the document query can be performed based on the dimension field with the updated field value by clicking the query button.
The terminal obtains a field value corresponding to a condition field in the target document, where the field value is included in the target index model corresponding to the target document, and takes the field value of the condition field as a field value of a dimension field bound with the condition field in the target index model. The dimension fields and field values of the dimension fields in the target index model are shown in the index card. And in response to a field value updating operation for the dimension field in the index card, updating the field value corresponding to the dimension field under the field value constraint corresponding to the dimension field. Specifically, under the condition that the dimension field binds the condition field, the field value updating operation can only update the field value of the dimension field in the index card within the range of the field value corresponding to the condition field bound by the dimension field, and at this time, the field value constraint corresponding to the dimension field is the field value of the condition field bound by the dimension field in the target document. For example, when the dimension field is a business date and the field value corresponding to the condition field bound by the business date is 2022-12-2023-07-09, the field value corresponding to the business date in the index card can be updated to any one time period of 2022-12-2023-07-09 through a field value updating operation. When the dimension field of the unbound condition field exists in the target index model, the field value corresponding to the dimension field is null, and at the moment, the union of the field values corresponding to the dimension fields of each bill in the second bill set is used as the field value constraint corresponding to the dimension field, and the field value updating operation can only update the field value of the dimension field in the index card in the field value set corresponding to the field value constraint corresponding to the dimension field. For example, when the dimension field is a material code and the material code is not bound to the condition field, the field value corresponding to the material code is null, and the field value corresponding to the material code in the index card can be updated to the material code corresponding to any one bill in the second bill set or a set formed by the material codes respectively corresponding to a plurality of bills in the second bill set through the field value updating operation in the index card. And further, responding to inquiry analysis operation triggered in the index card, and inquiring the bill based on the updated field values respectively corresponding to the dimension fields to obtain a third bill set.
And the terminal divides the third bill set into a plurality of sub bill sets according to the target display dimension. For any bill in the sub-bill collection, a field matched with the target index field is obtained from the basic field of the bill to serve as a reference field, and specifically, the corresponding reference field of the target index field in the bill is determined based on the index description information of the target index field in the target index model. Further, based on the index description information corresponding to the target index field in the target index model and the field values of the respective documents in the same sub-document set on the respective reference fields, the statistical values of the respective sub-document sets for the target index field are calculated respectively. And the statistic values respectively corresponding to the sub-bill sets form a second splitting result of the target field value in the target display dimension. In addition, the updated target field value corresponding to the target index field, namely the updated field value, can be obtained based on the index description information corresponding to the target index field in the target index model and the field values corresponding to the respective reference fields of the documents in the third document set. And updating the first split result and the target index field displayed in the index card based on the second split result and the updated field value corresponding to the target index field.
In the above embodiment, the field values of the dimension fields are updated under the constraint of the field values corresponding to the dimension fields by displaying the field values corresponding to the dimension fields in the index card and performing the field value updating operation. Under the constraint of field values corresponding to dimension fields, the document query range is further narrowed, so that the index card can be adapted to multi-level document query under different service scenes, multi-level and interactive document query is realized through the visualized index card, and the document query efficiency and flexibility can be effectively improved.
In one embodiment, the document processing method further includes:
displaying a set identifier corresponding to each sub-bill set and a statistical value of each sub-bill set aiming at a target index field respectively; and responding to the triggering operation aiming at the target set identifier, and displaying a bill list of the sub-bill set corresponding to the target set identifier.
Wherein, the set identifier refers to an identifier for distinguishing different sub-bill sets. The target set identifier refers to a set identifier aimed at by triggering operation in all set identifiers displayed by the bill card. The triggering operation is an operation for checking a bill list corresponding to the sub-bill set corresponding to the set identifier.
The terminal displays the set identifiers respectively corresponding to the sub-bill sets in the index card, and the statistics values of the sub-bill sets aiming at the target index fields respectively. For example, as shown in fig. 6, for a target index field, which is the number of periodic ex-warehouse, the target display dimension in the index card is a service date, the queried bill set is divided into sub-bill sets corresponding to each week based on the service date, 2023W18 is the set identifier of the sub-bill set corresponding to the 18 th week of 2023, when the target display dimension is a material code, the queried bill set is divided into sub-bill sets corresponding to different material codes based on the material code, and at this time, the material code can be used as the set identifier corresponding to the sub-bill set. And responding to the triggering operation aiming at the target set identifier, and displaying a bill list of the sub-bill set corresponding to the target set identifier, wherein the bill list consists of all the bills in the sub-bill set.
In the above embodiment, after the queried document set is divided into a plurality of sub-document sets based on the target display dimension, a corresponding set identifier is determined for each sub-document set. And the set identifier can be set as a triggerable control, and each bill contained in the sub-bill set corresponding to the target set identifier can be checked through triggering operation aiming at the target set identifier. Therefore, the index card can not only check the target field value corresponding to the target index field, and the statistics value corresponding to each sub-bill set respectively, but also further inquire the bill list corresponding to each sub-bill set respectively, so that the multi-level inquiry of the bills is realized, and the bill processing efficiency and flexibility can be improved.
In one embodiment, the document processing method further includes:
displaying each dimension field corresponding to the target index model in a display dimension determining area in the index card; in response to a field selection operation triggered in the presentation dimension determination area, a target presentation dimension is determined among the candidate presentation dimensions.
The display dimension determining area refers to an area in the bill card, wherein each display dimension is displayed in the selectable mode. The field selection operation refers to an operation of determining a target presentation dimension in each dimension field.
The display dimension determining area in the index card may directly display each dimension field corresponding to the target index model, or may display each dimension field corresponding to the target index model through a drop-down menu. For example, as shown in FIG. 6, the individual dimension fields in the target index model are directly presented within the presentation dimension determination area. And responding to a field selection operation triggered in the display dimension determination area, and taking the candidate display dimension corresponding to the dimension field selected by the field selection operation as a target display dimension.
In the embodiment, the target display dimension can be flexibly selected in each dimension field by the user according to actual needs by displaying each dimension field in the target index model in the index card, so that the flexibility of document inquiry can be improved, and the flexibility and efficiency of document inquiry can be improved.
In a specific embodiment, the document processing method provided by the application can be applied to various business systems, such as an enterprise resource planning system (Enterprise Resource Planning, ERP), an enterprise management system, a financial system, a manpower system, a supply chain system and the like, and is used for managing mass documents stored in the business systems. As shown in fig. 10, the document processing method includes the steps of:
1. configuration index field
And the service system configures target index fields to be displayed on the service bill through the index model. Specifically, as shown in fig. 11, the service system first obtains a service bill set related to an index field, generates a wide table or a star table based on the service bill set, and can perform a query in the wide table or the star table corresponding to the service bill set when performing a bill query. For example, the sales order amount depends on the sales order. And in response to the index template selection operation aiming at the target document, displaying the fields matched with the selected target index template in the basic fields as the condition fields, and binding the dimension fields matched with the condition fields in the plurality of dimension fields provided by the target index template with the condition fields. In response to the metrics field configuration operation, a target metrics field selected from a plurality of candidate metrics fields provided by the target metrics template is presented. As shown in fig. 11, the condition field, the dimension field bound with the condition field, and the target index field form a target index model of the target document on the target index template, and the document query can be performed in a wide table or a star table corresponding to the target document through the target index model corresponding to the target index field, so as to obtain a target field value corresponding to the target index field, and the field value corresponding to the target index field is displayed on the target document.
2. Display index card
The business system responds to query analysis operation aiming at the target index field, wherein the query analysis operation can be triggered by clicking an index field joint check button corresponding to the target index field by a user, and in each candidate bill belonging to the same bill type with the target bill, the business system queries the bill with the condition field bound with the dimension field in the target index model and the field value on the condition field and the field value of the dimension field are matched to obtain a bill set. And determining a target display dimension based on each dimension field corresponding to the target index model, and dividing the second bill set into a plurality of sub bill sets according to the target display dimension. For any bill in the sub-bill collection, a field matched with the target index field is obtained from the basic field of the bill and used as a reference field. And based on the index description information corresponding to the target index field in the target index model, fusing the field values of all documents in the sub-document sets on the respective reference fields to respectively obtain the statistic values of all the sub-document sets aiming at the target index field, and forming a splitting result of the target field value on the target display dimension. And displaying the splitting result of the target index field in the target display dimension through the index card visual interface.
In the above embodiment, the target index field is created in the document by the code-free index model configuration method, and the query of the dimension statistics data and the detail data corresponding to the target index field is realized in a chart-combined manner, so that the application threshold is low, and the code-free index model configuration method can be used by a user without a code development foundation. In addition, the bill processing method is high in universality, the visual joint check of the data can be realized by the method aiming at any data needing joint check and drilling detail, corresponding query interfaces are not required to be developed one by one aiming at different query requirements, and the development cost can be reduced.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a bill processing device for realizing the bill processing method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiments of the document processing device or devices provided below may refer to the limitation of the document processing method hereinabove, and will not be repeated herein.
In one embodiment, as shown in fig. 12, there is provided a document processing apparatus including: a document presentation module 1202 and an index card presentation module 1204, wherein:
the bill display module 1202 is used for displaying a bill detail interface corresponding to the target bill; the bill detail interface displays a basic field and a target index field of a target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field;
an index card display module 1204, configured to display an index card of the target document for the target index field in response to a query analysis operation for the target index field, and display a first split result of the target field value in the target display dimension in the index card; the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model.
In one embodiment, the index card presentation module 1204 is further configured to:
responding to query analysis operation aiming at a target index field, and querying a document with a condition field bound with a dimension field in a target index model and a field value on the condition field matched with a field value of the dimension field in each candidate document belonging to the same document type with the target document to obtain a second document set; determining a target display dimension based on each dimension field corresponding to the target index model, and dividing the second bill set into a plurality of sub bill sets according to the target display dimension; for any bill in the sub-bill collection, acquiring a field matched with a target index field from a basic field of the bill as a reference field; based on index description information corresponding to the target index field in the target index model, fusing field values of all documents in the sub-document sets on respective reference fields to respectively obtain statistical values of all the sub-document sets aiming at the target index field, and forming a first splitting result of the target field value on a target display dimension; and displaying an index card of the target bill aiming at the target index field, and displaying a first splitting result in the index card.
In one embodiment, the document detail page displays a query button corresponding to the target index field and used for triggering a query analysis operation, and the index card display module 1204 is further configured to:
and responding to the triggering operation of the query button corresponding to the target index field in the bill detail interface, and displaying the index card of the target bill for the target index field.
In one embodiment, as shown in fig. 13, the document processing apparatus further includes:
the index model configuration module 1302 is configured to respond to an index template selection operation for a target document, display a field matched with a selected target index template in a basic field as a condition field, and bind a dimension field matched with the condition field in a plurality of dimension fields provided by the target index template with the condition field; displaying a target indicator field selected from a plurality of candidate indicator fields provided by a target indicator template in response to an indicator field configuration operation; and forming a target index model of the target document on the target index template by the condition field, the dimension field bound with the condition field and the target index field.
In one embodiment, as shown in fig. 13, the document processing apparatus further includes:
The target field value calculation module 1304 is configured to query, in each candidate document belonging to the same document type as the target document, documents having a condition field and a field value of the target document on the condition field, to obtain a first document set; for any bill in the first bill set, acquiring a field matched with a target index field from a basic field of the bill as a reference field; and fusing the field values of all documents in the first document set on the respective reference fields based on the corresponding index description information of the target index field in the target index model to obtain the target field value of the target index field.
In one embodiment, as shown in fig. 13, the document processing apparatus further includes:
a query module 1306 configured to display, in the index card, a dimension field and a field value of the dimension field in the target index model; the field value of the dimension field is determined based on the field value corresponding to the condition field bound by the dimension field in the target document; responding to a field value updating operation aiming at a dimension field in the index card, and updating a field value corresponding to the dimension field under the constraint of the field value corresponding to the dimension field; the field value constraint corresponding to the dimension field is determined based on the field value of the target document on the condition field bound with the dimension field; responding to the query analysis operation triggered in the index card, and displaying a second split result of the updated field value of the target index field in the target display dimension in the index card; updating the field value, namely performing document inquiry based on the dimension field with the updated field value, and counting the inquired third document set based on the target index field.
In one embodiment, the query module 1306 is further configured to display a set identifier corresponding to each sub-document set and a statistics value of each sub-document set for the target index field respectively; and responding to the triggering operation aiming at the target set identifier, and displaying a bill list of the sub-bill set corresponding to the target set identifier.
In one embodiment, as shown in fig. 13, the document processing apparatus further includes:
the display dimension determining module 1302 is configured to display, in a display dimension determining area in the index card, each dimension field corresponding to the target index model; in response to a field selection operation triggered in the presentation dimension determination area, a target presentation dimension is determined among the candidate presentation dimensions.
According to the bill processing device, through showing the bill detail interface corresponding to the target bill, the basic field and the target index field of the target bill are shown in the bill detail interface, the target field value of the target index field is obtained by obtaining the target index model containing the target index field corresponding to the target bill, bill inquiry is carried out based on the condition field in the target index model, and statistics is carried out on the inquired first bill set based on the target index field. In this way, the target index field and the target index model corresponding to the target index field are set for the target bill, and when the bill detail interface is displayed, bill inquiry and statistics are carried out based on the target index model corresponding to the target index field, so that the field value corresponding to the target index field is obtained, automatic processing of bill inquiry analysis is realized, and the bill processing efficiency can be effectively improved. And further, in response to query analysis operation for the target index field, displaying an index card of the target document for the target index field, and displaying a first splitting result of the target field value in the target display dimension in the index card, wherein a second document set corresponding to the first splitting result is obtained by inquiring the document based on the dimension field in the target index model. In this way, document inquiry is carried out according to the dimension field in the target index model corresponding to the target index field, so that a first splitting result of the target field value in the target display dimension is obtained, multi-level visual inquiry and analysis of the target index field are realized, and document processing efficiency can be improved.
The modules in the document processing device may be implemented in whole or in part by software, hardware, or a combination 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 terminal, and the internal structure thereof may be as shown in fig. 14. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. 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 and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a document processing method. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 14 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the computer device to which the present application applies, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, implements the steps of the method embodiments described above.
In one embodiment, a computer program product or computer program is provided that includes computer instructions stored in a computer readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps in the above-described method embodiments.
It should be noted that, the user information (including, but not limited to, user equipment information, user personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data are required to comply with the related laws and regulations and standards of the related countries and regions.
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, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (11)
1. A document processing method, the method comprising:
displaying a bill detail interface corresponding to the target bill; the bill detail interface displays a basic field and a target index field of the target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field;
Displaying an index card of the target document for the target index field in response to a query analysis operation for the target index field, and displaying a first splitting result of the target field value in a target display dimension in the index card; and the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model.
2. The method of claim 1, wherein before the displaying the document detail interface corresponding to the target document, the method further comprises:
responding to an index template selection operation aiming at a target bill, displaying a field matched with a selected target index template in the basic field as a condition field, and binding a dimension field matched with the condition field in a plurality of dimension fields provided by the target index template with the condition field;
displaying a target indicator field selected from a plurality of candidate indicator fields provided by the target indicator template in response to an indicator field configuration operation;
and forming a target index model of the target document on the target index template by the condition field, the dimension field bound with the condition field and the target index field.
3. The method according to claim 1, wherein the method further comprises:
inquiring a bill with the condition field and the field value of the target bill on the condition field in each candidate bill belonging to the same bill type with the target bill to obtain a first bill set;
for any bill in the first bill set, acquiring a field matched with the target index field from a basic field of the bill as a reference field;
and fusing field values of all documents in the first document set on respective reference fields based on index description information corresponding to the target index field in the target index model to obtain a target field value of the target index field.
4. The method of claim 1, wherein the presenting, in response to the query analysis operation for the target indicator field, an indicator card for the target indicator field for the target document, in which indicator card a first split result of the target field value in a target presentation dimension is presented, comprises:
responding to query analysis operation aiming at the target index field, and querying a document with a condition field bound with a dimension field in the target index model and a field value on the condition field matched with a field value of the dimension field in each candidate document belonging to the same document type with the target document to obtain a second document set;
Determining a target display dimension based on each dimension field corresponding to the target index model, and dividing the second bill set into a plurality of sub bill sets according to the target display dimension;
for any bill in the sub-bill collection, acquiring a field matched with the target index field from a basic field of the bill as a reference field;
based on index description information corresponding to the target index field in the target index model, fusing field values of all documents in the sub-document sets on respective reference fields to respectively obtain statistical values of all sub-document sets aiming at the target index field, and forming a first splitting result of the target field value on a target display dimension;
and displaying an index card of the target bill aiming at the target index field, and displaying the first splitting result in the index card.
5. The method of claim 1, wherein the document detail page displays a query button corresponding to the target index field for triggering a query analysis operation, and wherein the displaying the index card of the target document for the target index field in response to the query analysis operation for the target index field comprises:
And responding to the triggering operation of a query button corresponding to a target index field in the bill detail interface, and displaying an index card of the target bill for the target index field.
6. The method according to claim 1, wherein the method further comprises:
displaying a dimension field and a field value of the dimension field in the target index model in the index card; the field value of the dimension field is determined based on the field value corresponding to the condition field bound by the dimension field in the target document;
responding to a field value updating operation aiming at the dimension field in the index card, and updating the field value corresponding to the dimension field under the field value constraint corresponding to the dimension field; the field value constraint corresponding to the dimension field is determined based on the field value of the target document on the condition field bound with the dimension field;
responding to a query analysis operation triggered in the index card, and displaying a second split result of the updated field value of the target index field in the target display dimension in the index card; and updating the field value, namely performing document inquiry based on the dimension field with the updated field value, and counting the inquired third document set based on the target index field.
7. The method of claim 6, wherein the method further comprises:
displaying a set identifier corresponding to each sub-bill set and a statistical value of each sub-bill set aiming at the target index field respectively;
and responding to the triggering operation aiming at the target set identifier, and displaying a bill list of the sub bill set corresponding to the target set identifier.
8. The method according to claim 1, wherein the method further comprises:
displaying each dimension field corresponding to the target index model in a display dimension determining area in the index card;
a target presentation dimension is determined among the respective candidate presentation dimensions in response to a field selection operation triggered in the presentation dimension determination area.
9. A document processing apparatus, the apparatus comprising:
the bill display module is used for displaying bill detail interfaces corresponding to the target bill; the bill detail interface displays a basic field and a target index field of the target bill, wherein a target field value of the target index field is obtained by acquiring a target index model corresponding to the target bill and containing the target index field, inquiring the bill based on a condition field in the target index model, and counting the inquired first bill set based on the target index field;
The index card display module is used for responding to the query analysis operation aiming at the target index field, displaying the index card of the target bill aiming at the target index field, and displaying a first splitting result of the target field value in a target display dimension in the index card; and the second bill collection corresponding to the first splitting result is obtained by inquiring the bill based on the dimension field in the target index model.
10. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 8 when the computer program is executed.
11. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311816282.8A CN117743373A (en) | 2023-12-26 | 2023-12-26 | Document processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311816282.8A CN117743373A (en) | 2023-12-26 | 2023-12-26 | Document processing method, device, computer equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN117743373A true CN117743373A (en) | 2024-03-22 |
Family
ID=90259142
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202311816282.8A Pending CN117743373A (en) | 2023-12-26 | 2023-12-26 | Document processing method, device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN117743373A (en) |
-
2023
- 2023-12-26 CN CN202311816282.8A patent/CN117743373A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9727836B2 (en) | Systems and methods for generating data visualization dashboards | |
CN105917315B (en) | Method and computing system for generating content of data record | |
US9740363B2 (en) | Methods and systems for managing community information | |
US8170903B2 (en) | System and method for weighting configuration item relationships supporting business critical impact analysis | |
CN112036631B (en) | Purchasing quantity determining method, purchasing quantity determining device, purchasing quantity determining equipment and storage medium | |
CN112667612A (en) | Data quality checking method and device, electronic equipment and storage medium | |
CN115544183A (en) | Data visualization method and device, computer equipment and storage medium | |
CN114444478A (en) | Voucher visualization method and device, electronic equipment and storage medium | |
CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
US20150248685A1 (en) | Automated identification of sales opportunities based on stored market data | |
CN116166820A (en) | Visualized knowledge graph generation method and device based on provider data | |
US8856126B2 (en) | Simplifying grouping of data items stored in a database | |
CN114841791A (en) | Budget management and control method, system, device, computer equipment and storage medium | |
CN117743373A (en) | Document processing method, device, computer equipment and storage medium | |
CN114596147A (en) | Data reconciliation method and device, computer equipment and storage medium | |
US20140012632A1 (en) | Extension of business scenarios | |
CN114969031A (en) | Visual data display method and related device | |
CN109857501B (en) | APP page display method and device, storage medium and server | |
US20140304031A1 (en) | Method and system for performing analysis of item order frequency | |
CN115408396B (en) | Method, device, computer equipment and storage medium for storing business data | |
CN114416235B (en) | Document display method, device, computer equipment and storage medium | |
CN115423595B (en) | File information processing method and device, computer equipment and storage medium | |
US20160307207A1 (en) | Analytical Functionality Selecting Relevant Market Research Data for Global Reporting | |
CN116383138A (en) | Document changing method, device, computer equipment and storage medium | |
CN114764483A (en) | Information display method, device, equipment and 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 |