CN112307101A - Project pricing auditing method, device, computer equipment and system - Google Patents
Project pricing auditing method, device, computer equipment and system Download PDFInfo
- Publication number
- CN112307101A CN112307101A CN202011150436.0A CN202011150436A CN112307101A CN 112307101 A CN112307101 A CN 112307101A CN 202011150436 A CN202011150436 A CN 202011150436A CN 112307101 A CN112307101 A CN 112307101A
- Authority
- CN
- China
- Prior art keywords
- data
- matching
- approval
- submission
- audit
- 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
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000012550 audit Methods 0.000 claims abstract description 117
- 238000012552 review Methods 0.000 claims description 56
- 238000012795 verification Methods 0.000 claims description 16
- 230000000877 morphologic effect Effects 0.000 claims description 14
- 238000009877 rendering Methods 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 10
- 238000012986 modification Methods 0.000 claims description 10
- 230000004048 modification Effects 0.000 claims description 10
- 230000004075 alteration Effects 0.000 claims 1
- 238000010276 construction Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000007728 cost analysis Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 108010001267 Protein Subunits Proteins 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/22—Matching criteria, e.g. proximity measures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Computational Linguistics (AREA)
- Entrepreneurship & Innovation (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Marketing (AREA)
- Evolutionary Biology (AREA)
- Bioinformatics & Computational Biology (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Artificial Intelligence (AREA)
- Economics (AREA)
- Evolutionary Computation (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Life Sciences & Earth Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The project pricing auditing method, device, computer equipment and system includes obtaining document data of submission and document data of approval, loading the document data into preset comparison auditing model to generate two kinds of form data of submission and approval, establishing matching relationship between the two kinds of form data of submission and approval by using data matching rule, comparing and matching the submission data and the approval data establishing matching relationship to generate matching result, determining data matching type according to matching result, determining whether to extract relevant submission and approval data to generate corresponding auditing task according to matching type, sending to auditing interface, classifying according to the two kinds of form data of submission and approval to form relevant auditing task, auditing person can audit modified submission and approval data according to auditing task, the auditing efficiency of people is improved.
Description
Technical Field
The application relates to the technical field of engineering cost, in particular to a method, a device, computer equipment and a system for checking project pricing.
Background
After the construction project tenders and bids and settles the cost book, the internal submission files and the external approval files need to be audited, one project generally has a plurality of different single projects and unit projects, and each unit project has hundreds of clear single projects and quota items. And several to dozens of material working machines exist under each quota item, and the contents all need to be examined and checked by auditors one by one.
In the process of checking the project cost document, the comparison and check are generally adopted to manually compare the submission document with the approval document item by item, then the cost project submitted is checked and modified, the list item, the quota item and the work and material machine item under the quota are checked, increased and reduced, and the modified content is recorded to be used as the basis of the check,
however, if the project is larger, the audit content needing to be compared and recorded is more, and workers need to manually perform comparison work item by item, so that the workload is larger, a large amount of time is spent, errors are easy to occur, the work focus is changed from review to comparison and recording, the auditing by the workers is inconvenient, and the work efficiency is lower.
Disclosure of Invention
In order to facilitate auditing of workers and improve the work efficiency of engineering auditing of the workers, the application provides an engineering pricing auditing method, device, computer equipment and system.
In a first aspect, the present application provides an engineering pricing auditing method, which adopts the following technical scheme:
a project pricing auditing method comprises the following steps:
acquiring the text data of the submission file and the text data of the approval file;
the text data of the submission file and the text data of the approval file are transferred into a preset comparison and verification model;
generating two types of form data of submission and approval in the comparison and approval model based on the text data of the submission file and the text data of the approval file, and establishing a matching relation between the two types of form data of submission and approval through a data matching rule;
comparing and matching the two forms of data which are submitted for examination and approved and establish the matching relationship to obtain a matching result;
determining a data matching type according to the matching result, wherein the data matching type comprises a non-change item, a non-matching item and a change item;
and determining whether to extract the related review and approval form data to generate a corresponding review task based on the data matching type, and sending a review interface for display.
By adopting the technical scheme, firstly, the document of the submission and the document of the approval are obtained, the document of the submission and the document of the approval are loaded into a preset comparison and verification model, the document of the submission and the document of the approval are sent to generate two types of form data of submission and approval in the comparison and verification model, then the two types of form data of submission and approval are matched by using a data matching rule so as to facilitate the subsequent association extraction of the two types of form data of submission and approval and generate a matching result, the data matching type is determined according to the matching result, whether the two types of form data of the submission and the approval are extracted or not is determined according to the data matching type to generate a corresponding audit task, and the audit task is sent to an audit interface, so that the two types of form data of the submission and the approval are classified according to the data matching type to form the related audit task, the auditor can audit the modified submission and approval data according to the audit task without comparing the audit one by one, so that the audit of the submission and approval data by people is facilitated, and the audit efficiency of people is improved.
Further, the step of determining whether to extract the relevant review and approval form data to generate a corresponding review task based on the data matching type and sending the corresponding review task to a review interface for display includes:
when the data matching type is a modification item, determining to extract the review and approval form data which are related to the modification item and establish a matching relationship, generating a corresponding review task, and sending the corresponding review task to the review interface for displaying;
and when the data matching type is no matching item, determining to extract the two form data of submission and approval related to the no matching item, generating a corresponding audit task, and sending the corresponding audit task to an audit interface for display.
By adopting the technical scheme, a matching relation is established between the submission and approval morphological data to obtain a matching result, a data matching type is obtained according to the matching result, when the data matching type is determined to be a change item, the modification between the submission and approval morphological data is shown, the submission and approval morphological data related to the change item is determined to be extracted, a corresponding audit task is generated, and the audit task is sent to an audit interface for display.
Further, the step of determining the data matching type includes:
comparing and matching the submission and approval morphological data establishing the matching relationship to obtain the following matching results:
when the data in the two forms of submission and examination have a matching relationship and the data is unchanged, determining that the data matching type is an unchanged item;
when the data in the two forms of submission and examination have a matching relationship and the data changes, determining the data matching type as a modified item;
and when the data in the two forms of submission and examination have no matching relationship, determining that the data matching type is a non-matching item.
By adopting the technical scheme, when the matching relationship between the two types of form data of submission and approval is established, and the matching relationship between the two types of form data of submission and approval is unchanged, the submission data and the approval data are not changed, the data matching type is determined to be an unchanged item, if the matching relationship between the two types of form data of submission and approval is changed, the submission data and the approval data are changed, the data matching type is determined to be an changed item, and when the matching relationship between the submission data of the submission and the approval data of the two types of form data of approval is not existed, the submission sub-project data or the approval sub-project data are excessive items and cannot be matched, the data matching type is determined to be an unmatched item.
Further, the step after determining the data matching type further includes:
establishing character marks about non-matching items and changing items for the related review and approval morphological data;
and forming data about the literal marks of the non-matching items and the changed items and sending the data to an audit interface for displaying.
By adopting the technical scheme, according to the data matching type, the character marks of the non-matching item type and the changing item type are established for the data of the two forms of data to be audited and audited, and the data are sent to the auditing interface to be displayed, so that the auditor can clearly see the change or non-matching of the data of the two forms of data to be audited and audited on the auditing interface, and the auditor can quickly check and classify the auditing data.
Further, the step after determining the data match type as a modified item is:
comparing the two forms of data which are determined to be changed items and are submitted to the trial and the approval to obtain a comparison result;
judging the data auditing difference grade based on the comparison result, wherein the data difference grade comprises small difference, small difference and large difference;
and determining whether to perform color rendering on the two forms of data to be audited and approved and form data to be displayed on an audit interface based on the data audit difference grade.
By adopting the technical scheme, when the data of the changed item is determined, the two form data of the data to be sent for examination and the data to be examined are compared to obtain a comparison result, the data examination difference grade is judged according to the comparison result, whether the two form data to be sent for examination and the data to be examined are subjected to color rendering and form data display is determined based on the data examination difference grade, so that an examiner can quickly judge the difference of data modification, and the data examination efficiency of people is improved.
In a second aspect, the present application provides an engineering pricing auditing device, which adopts the following technical scheme:
a project pricing auditing device comprises,
the data acquisition module is used for acquiring the text data of the submission file and the text data of the approval file;
the data generation module is used for loading the text data of the submission file and the text data of the approved file into a preset comparison and verification model, and generating submission and approval morphological data in the comparison and verification model based on the text data of the submission file and the text data of the approved file;
the rule base module is used for establishing a matching relation between the submission form data and the approval form data based on the data matching rule so as to generate a matching result;
the data judging module is used for determining the data matching type according to the matching result;
the data marking module is used for establishing character marks about the unmatched items and the modified items according to the data matching types and the two forms of data which are submitted for examination and approval;
and the first execution module is used for determining whether to extract related review and approval form data establishing a matching relation based on the data matching type, generating a corresponding review task and sending the corresponding review task to the review interface.
By adopting the technical scheme, the data acquisition module can acquire the text data of the submission document and the text data of the approval document, then the data generation module loads the text data of the submission document and the text data of the approval document into a preset comparison and audit model, generates two forms of submission and approval data in the comparison and audit model based on the text data of the submission document and the text data of the approval document, establishes a required data matching rule in the rule base module, establishes a matching relation between the two forms of submission and approval data based on the required data matching rule and generates a matching result, the data judgment module determines a data matching type according to the matching result, when the data matching type is determined, the data marking module establishes corresponding character marks for the two forms of data, and the first execution module carries out topping according to the data matching model to determine whether to extract the two forms of submission and approval data which are related to establish the matching relation or not, and generating a corresponding audit task and sending the audit task to an audit interface.
Further, the method also comprises the following steps:
the data comparison module is used for comparing the audited sub-project data determined as the changed items with the audited sub-project data to obtain a comparison result;
the grade judgment module is used for judging the grade of the data auditing difference according to the comparison result;
and the second execution module is used for determining whether to perform color rendering on the two forms of data which are submitted to the audit and approved based on the data difference grade top, and forming data to be sent to an audit interface for display.
By adopting the technical scheme, the data comparison module compares the audited sub-project data determined as the changed item with the approved sub-project data to obtain a comparison result, the grade judgment module can determine the data audit difference type according to the comparison result, and the second execution module can determine whether to perform color rendering on the audited and approved form data according to the data audit difference grade, so that an auditor can be helped to quickly audit the data difference after the changed item.
In a third aspect, the present application provides a computer device, which adopts the following technical solution:
a computer apparatus comprising a memory and a processor, the memory having stored thereon a computer program that can be loaded by the processor and that implements a project pricing auditing method according to any of the preceding claims.
In a fourth aspect, the present application provides a computer storage medium, which adopts the following technical solutions: .
A computer readable storage medium storing a computer program capable of being loaded by a processor and executing any one of the above project pricing auditing methods.
In a fifth aspect, the present application provides an engineering pricing auditing system, which adopts the following technical scheme:
an engineering pricing auditing system comprises
A computer apparatus as above;
and the data acquisition device is used for acquiring the text data of the submission file and the text data of the approval file.
By adopting the technical scheme, the audit text data and the approval text data are sent through the data acquisition device and transmitted to the computer equipment after the data are acquired, the computer equipment converts the audit text data and the approval text data into two forms of data of audit and approval in a preset comparison audit model, a matching relation is established based on the two forms of data of audit and approval to generate a matching result, the data matching type is judged according to the matching result, the corresponding character mark is established, whether a corresponding audit task is generated or not is determined according to the data matching type, and the corresponding audit task is sent to the audit interface for display.
In summary, the present application includes at least one of the following beneficial technical effects:
1. acquiring a document of a submission document and a document of an approval document, converting two types of document data into two types of form data in a comparison and verification model, establishing a matching relation between the two types of form data of submission and approval by using a data matching rule to generate a matching result, determining a data matching type according to the matching result, determining whether to extract the two types of form data of the submission and the approval to generate corresponding verification tasks according to the data matching type, and sending the verification tasks to a verification interface, so that the two types of form data of submission and approval can be classified according to the data matching type to form the related verification tasks, thereby facilitating people to verify the two types of form data of submission and approval and improving the verification efficiency of people;
2. obtaining a data matching type according to a matching result, when the data matching type is determined to be a change item, indicating that modification exists between the submission and approval morphological data, determining to extract the submission and approval morphological data related to the change item, generating a corresponding audit task, and sending the audit task to an audit interface for display;
3. according to the data matching type, character marks of a non-matching item type and a changing item type are established for the two form data which are submitted for examination and approved, and data are formed and sent to an examination interface for display, so that an examiner can clearly see whether the two form data which are submitted for examination and approved are changed or not matched on the examination interface, and the examiner can quickly check and classify the examination data.
Drawings
FIG. 1 is a block diagram of a project pricing auditing system according to an embodiment of the present application;
FIG. 2 is a schematic flow chart of a project pricing auditing method according to an embodiment of the present application;
FIG. 3 is a block diagram of a project pricing auditing apparatus according to an embodiment of the present application;
fig. 4 is a block diagram of a computer device according to an embodiment of the present application.
In the figure, 1, a data acquisition device, 2, a computer device; 3. a data acquisition module; 4. a data generation module; 5. a rule base module; 6. a data judgment module; 7. a data marking module; 8. a first execution module; 9. a data comparison module; 10. a grade judgment module; 11. and a second execution module.
Detailed Description
The present application is described in further detail below with reference to the attached drawings.
After the construction project tenders and bids and the construction cost book is compiled, the internal file and the external file need to be compared and checked, wherein the internal file is a submission file sent to the outside, and the external file is an approval file well agreed with the outside. Generally, in a project, more inventory items, quota items and work and material machine items under the quota items are subjected to increased audit and decreased audit, and the modified content is recorded to be used as an audit basis. However, the larger the project is, the more the project contents need to be audited, and the auditor needs to spend a lot of time to screen, compare and record the contents on the submission file and the approval file item by item, so that the workload is large, the auditor is not convenient to audit, errors are easy to occur, and the auditing efficiency of the auditor is low.
Therefore, the embodiment of the present application discloses a project pricing auditing system to improve auditing efficiency when documents are submitted for review and approved for review, as shown in fig. 1, the system includes a data acquisition device 1 and a computer device 2. The data acquisition device 1 and the computer device 2 may be in wireless connection or communication connection.
The data acquisition device 1 is used for acquiring the text data of the approval document of the text data of the submission document. Because the submission file and the approval file can be an electronic version or a paper version, in order to obtain the text data of the submission file and the text data of the approval file, the data obtaining device 1 can be a camera and a terminal, the camera is in communication connection with the terminal, and the terminal can be a mobile phone or a computer.
The computer device 2 may be a server, and the detailed description of the components thereof will be described in the following description of the computer device 2 disclosed in the embodiments of the present application. The computer equipment 2 is used for acquiring the text data of the submission file and the text data of the approval file, loading the text data of the submission file and the text data of the approval file into a preset comparison and verification model, converting the text of the submission file and the text of the approval file into two forms of submission and approval data, establishing a matching relation between the two forms of data to obtain a matching result, determining a data matching type according to the matching result, establishing a related character mark, generating an approval task based on the data matching type, and sending an approval interface. After receiving an audit request sent by an auditor on an audit interface, extracting relevant two form data and loading the data on the corresponding audit interface for the auditor to audit.
Meanwhile, based on an engineering pricing auditing system, the embodiment of the application also discloses an engineering pricing auditing method, as shown in fig. 2, the method comprises the following steps:
and S1, acquiring the text data of the submission file and the text data of the approval file.
In this embodiment, the obtained submission file and the approval file may be in an electronic version or a paper version. Therefore, in order to obtain the text data of the submission document and the text data of the approval document, the following two cases are described:
if the submission file and the approval file are electronic versions.
If the submission file and the approval file are electronic versions, the submission file and the approval file can be directly called out from the electronic versions stored in the database and subjected to conversion processing.
If the submission file and the approval file are paper versions.
Shooting the submission file and the approval file, identifying and analyzing the shot images to obtain the submission file and the approval file text data and storing the submission file and the approval file text data in a database, and calling out the submission file text data and the approval file text data and carrying out conversion processing when the submission file and the approval file data need to be audited.
And S2, loading the text data of the submission file and the text data of the approval file into a preset comparison and audit model.
And after acquiring the text of the submission file and the text data of the approval file, loading the text data of the submission file and the text data of the approval file into a preset comparison and audit model. In this embodiment, comparing the audit model refers to comparing the data of the submitted audit document and the data of the approved document one by one to obtain an audit result. The auditor can match and audit the submission data and the approval data in the comparison and audit model, and can mark the submission data and the approval data according to the required character mark.
S3, generating two types of form data of submission and approval in a preset comparison and approval model based on the text data of the submission file and the text data of the approval file, and establishing a matching relation between the two types of form data of submission and approval through a data matching rule to obtain a matching result. The method comprises the following specific steps:
(1) and converting the text data of the submission document and the text data of the approval document into two forms of data of submission and approval in a preset comparison and approval model.
(2) And establishing a data matching rule required by the auditor according to the two form data of submission and approval, and establishing a matching relation between the two form data of submission and approval so as to obtain a matching result.
Here, the data matching rule is to match the sub-items one by one according to names or codes of the classification items added to the preset comparison and audit model. The matching relationship is that the form data to be submitted for examination and the approved form data form an associated corresponding relationship according to the data matching rule, that is, when one sub-item data of the form data to be submitted for examination is changed, the corresponding sub-item data in the approved form data is also changed.
And the classification items can be list items, work and material machine summary items, project measure items, expense summary items and the like of the used materials of the project engineering. Meanwhile, each classification item also comprises a plurality of sub-items, and each sub-item also comprises a plurality of sub-units, so when a matching relation is established between the two forms of data to be audited and audited, an auditor can establish a classification item according to the auditor and the audited files, then classify and match the two forms of data to be audited and audited according to the names or codes of the classification items, and perform corresponding automatic identification and matching according to the names or codes of the sub-items in each classification item, and perform automatic matching of the names or codes of the next-stage sub-units after all the sub-items are automatically matched.
Such as: when an auditor establishes the name of a classification item in a preset audit interface of a comparison audit model, the classification item is a 'project measure', and the project measure comprises sub-items such as temporary facilities, lighting construction, night construction and temporary protection facilities. The preset comparison and examination model classifies the two forms of data to be examined and approved according to the name of the classification item of the project measure, and classifies all data related to the classification item of the project measure. And in the classification items of the project measures, automatically matching the form data to be examined and the form data to be examined one by one based on the names of the sub-items of the temporary facilities, the lighting construction, the night construction and the temporary protection facilities and establishing a corresponding matching relation, and then matching based on the names of the sub-units in each sub-item and establishing a corresponding matching relation after all the sub-items are matched.
And when the corresponding matching relationship is established between the censored data and the approved morphological data, generating a matching result, wherein the matching result can be matching but is different, and the matching has no change and no matching relationship.
And S4, determining the data matching type according to the matching result, wherein the data matching type comprises no change item, no matching item and a change item. Wherein,
(1) and when the submission and the approval of the two form data have a matching relationship and the data are unchanged, indicating that both the submission form data and the approval form data are not modified, and determining that the data matching type is an unchanged item.
(2) When the data of the two forms are checked and examined to have a matching relationship and the data is changed, determining the data matching type as a modified item,
in this embodiment, the names or codes of the sub-projects to be reviewed and approved are the same, but the sub-project data are different, which indicates that the data are modified.
(3) And when the data of the two forms of submission and approval established matching relationship do not have the matching relationship, determining the data matching type as a non-matching item.
In this embodiment, when one more item or one less item is found in the submitted or approved sub-items for establishing the matching relationship and the items cannot be matched, the item is determined to be an excessive item, and the data matching type is determined to be a non-matching item. The non-matching items comprise added items and deleted items, wherein the added items refer to sub items which are added, and the deleted items are sub items which are deleted. If the matched sub-project is the checked sub-project, the checked sub-project is determined to be a deleted project if the checked sub-project does not have the sub-project, and if the matched sub-project is the checked sub-project, the checked sub-project is determined to be an added project if the checked sub-project does not have the sub-project.
And S5, determining whether to extract the form data of the submission and the approval to generate a corresponding audit task based on the data matching type, and sending the audit task to an audit interface for display.
(1) And when the data matching type is a modified item, determining to extract review and approval form data related to the modified item, generating a corresponding review task, and sending the corresponding review task to a review interface.
Extracting two types of form data of submission and approval related to the change item refers to extracting all sub-project data which are matched as the change item based on submission and approval in the classification item. And generating the sub-project data into an audit task containing all the sub-project data according to the data matching type, and then sending the audit task to an audit interface for displaying.
(2) And when the data matching type is no matching item, determining to extract review and approval morphological data related to the no matching item, generating a corresponding review task, and sending the corresponding review task to a review interface.
Since the non-matching items include the added items and the deleted items, the following two cases are included:
1) when the sub-project data to be audited is matched with the approved sub-project data, if the sub-project data to be audited is redundant and cannot be matched with the approved sub-project data, the data matching type is determined to be an added project, the sub-project data to be audited and approved related to the added project are extracted, an audit task related to the added project is generated, and the audit task is sent to an audit interface.
2) When the submitted and examined sub-project data are matched with the approved sub-project data, if the approved sub-project data are redundant and cannot be matched with the approved sub-project data, the data matching type is determined to be deleted, the submitted and examined sub-project data related to the deleted items are extracted, an examination task related to the deleted items is generated, and the examination task is sent to an examination interface.
(3) And when the data matching type is a non-change item, determining that the related data of the two forms of submission and approval are not extracted, and generating no corresponding audit task and sending the audit task to an audit interface.
If the data matching type is a non-change item, the sub-project data sent to be examined and the approved sub-project data are the same, and data related to the non-matching item does not need to be extracted and a corresponding auditing task does not need to be generated.
In this embodiment, the generated audit task includes an audit link and an audit page, a corresponding relationship is established between the audit page and the audit link, the audit link is sent to an audit interface for display, an auditor can click the relevant audit link to send an audit feedback request to the server, when the server receives the feedback request based on the audit task, the server jumps to the audit page having a corresponding relationship with the audit link, and the relevant audit sub-item data to be audited and the audited sub-item data are loaded on the corresponding audit page, so that the audit operation can be performed in the audit page.
In addition, in order to facilitate the auditor to quickly identify the audited data, based on the data matching type, the text marks of no-matching items and changed items are established for the related two form data of submission and approval, and page data is formed and displayed on the corresponding audit page.
In this embodiment, the marks are divided into text marks without matching items and modified items, and the text marks without matching items can be divided into text marks with added items and text marks with deleted items, and text marks including "added", "modified" and "deleted" are generated for the added items, the modified items and the deleted items.
If the sub-item data is determined to be the changed item, extracting the sub-item data and generating the character mark of the changed item. If the sub-project data are determined to be the added terms, extracting the sub-project data and generating character marks of the added terms, and if the sub-project data which are determined to be checked and examined are the deleted terms, generating character marks of the deleted terms for the extracted sub-project data.
In order to facilitate the reviewer to distinguish the difference after the changed review and approval sub-project data, the changed review and approval sub-project data needs to be subjected to data review difference grade division, and the method specifically comprises the following steps:
(1) and comparing the extracted form data sent to the examination with the examined form data by taking the examined sub-project data as a standard to obtain a comparison result.
In the present embodiment, the form data of the post-submission and the approved form data are the submission and approved sub-project data determined as the modification items. And comparing the submitted sub-project data with the approved sub-project data to obtain a comparison result.
(2) And determining the data auditing difference types according to the comparison results, wherein the data auditing difference grades comprise large difference, small difference and small difference.
And determining the data audit difference type according to the comparison result, wherein the data audit difference type is as follows:
1) and when the absolute value of the difference between the audited sub-project data and the audited sub-project data is smaller than a first preset threshold value, determining that the difference level of data audit is small.
2) And if the absolute value of the difference between the audited sub-project data and the audited sub-project data is within the range between the first preset threshold and the second preset threshold, determining that the difference level of the data audit is smaller.
3) And if the absolute value of the difference between the audited sub-project data and the audited sub-project data is greater than a second preset threshold, determining that the data audit difference level is greater than the difference.
Such as: setting the matched sub-item as temporary facility cost, and the approved sub-item data is the temporary facility cost
At 4000, the approved sub-project data is sent
Setting the first preset threshold value to be 300 and the second preset threshold value to be 600 for 3500, comparing absolute values of differences between the sub-project data to be audited and the approved sub-project data, and calculating
-
(| = 500), i.e. 300 ≦
-
If | ≦ 600, it indicates that the absolute value of the difference between the data of the reviewed and approved sub-project data is between the first preset threshold and the second preset thresholdThen the review level is determined to be less gap.
(3) Determining whether to color render the reviewed sub-project data and the indicia of the reviewed sub-project data based on the data review difference level. The color rendering is to select corresponding color in the comparison and audit model according to the requirement of the auditor for rendering, and the color can be red or dark blue to represent the difference level of the data so as to remind the auditor of the data needing important attention. The following three cases are included:
1) and when the data auditing difference grade is large in difference, determining to generate the character marks of the audited sub-project data and the audited sub-project data for color rendering, and forming a data display to send to a corresponding auditing page.
2) And when the difference level of the data audit difference is smaller, determining to generate the character marks of the audited sub-project data and the audited sub-project data for color rendering, and forming data to be displayed and sent to a corresponding audit page.
3) And when the difference level of the data audit difference is small, determining to generate the character marks of the audited sub-project data and the audited sub-project data for color rendering, and forming data to be displayed and sent to a corresponding audit page.
After the auditor finishes auditing, a feedback request for generating a cost analysis report can be sent on the basis of the auditing interface, and when the feedback request for generating the cost analysis report is received, all the form data after two matched audits of submission and approval are merged, an analysis report is generated and sent to the auditing interface for displaying.
It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the present invention.
Based on an engineering pricing auditing method, the embodiment of the application also discloses an engineering pricing auditing device, as shown in fig. 3, comprising:
the data acquisition module 3 is used for acquiring the text data of the submission file and the text data of the approval file;
the data generation module 4 is used for loading the text data of the submission file and the text data of the approval file into a preset comparison and verification model, and generating submission and approval morphological data in the comparison and verification model based on the text data of the submission file and the text data of the approval file;
the rule base module 5 is used for establishing a matching relation between the submission form data and the approval form data based on a data matching rule so as to generate a matching result;
the data judging module 6 is used for determining the data matching type according to the matching result;
the data marking module 7 is used for establishing character marks about non-matching items and changing items according to the two morphological data which are submitted for examination and approval according to the data matching type;
and the first execution module 8 is used for determining whether to extract related review and approval form data establishing a matching relationship based on the data matching type, generating a corresponding review task and sending the corresponding review task to the review interface.
Wherein, when the data matching type of the data of the two forms of the submission and the approval obtained by the data judgment module 6 is a modification item, the device further comprises:
the data comparison module 9 is used for comparing the two form data determined as the submission and approval of the change item to obtain a comparison result;
a grade judging module 10, configured to judge a grade of the data audit difference based on the comparison result;
and the second execution module 11 is configured to determine whether to perform color rendering on the form data subjected to the review and the approval based on the data review difference level, and form data to send to the review interface for display.
In addition, the audit interface is displayed on the terminal, and the terminal can be a collection device, a tablet computer and other devices capable of displaying the audit interface. In this embodiment, on one hand, the data obtaining module 3 can obtain the text data of the submission document and the text data of the approval document, then the data generating module 4 loads the text data of the submission document and the text data of the approval document into a preset comparison and review model, and generates two forms of submission and approval data in the comparison and review model based on the text data of the submission document and the text data of the approval document, a required data matching rule is established in the rule base module 5, a matching relationship is established between the two forms of submission and approval data based on the required data matching rule, and a matching result is generated, the data judging module 6 determines a data matching type according to the matching result, and when the data matching type is determined, the first executing module 8 can determine whether to extract the two forms of submission and approval data which are related to establish the matching relationship or not according to the data matching model, and generating a corresponding audit task and sending the audit task to an audit interface. On the other hand, the data comparison module 9 compares the audited sub-project data determined as the changed item with the approved sub-project data to obtain a comparison result, the level judgment module 10 determines a data audit difference type according to the comparison result, and the second execution module 11 determines whether to perform color rendering on the audited sub-project data and the approved sub-project data according to the data audit difference level.
For the specific definition of the project pricing auditing device, reference may be made to the above definition of a project pricing auditing method, which is not described herein again. All or part of each module in the engineering pricing auditing device can be realized by software, hardware and a combination thereof. The modules may be embedded in a hardware form or independent from a processor in the computer device 2, or may be stored in a memory in the computer device 2 in a software form, so that the processor calls and executes operations corresponding to the modules.
The embodiment of the present application also discloses a computer device, as shown in fig. 4, which includes a processor, a memory and a computer program stored in the memory and running on the processor, which are connected by a system bus, and meanwhile, the computer device 2 includes a network interface and a database. The computer program is executed by a processor to implement a project pricing auditing method disclosed above.
Wherein the processor of the computer device 2 is arranged to provide computing and control capabilities. The memory of the computer device 2 includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database, and the internal memory provides an environment for the operating system and the computer program in the non-volatile storage medium to run. The database of the computer device 2 is used for storing the text data of the submission file, the text data of the approval file, the form data of the submission, the form data of the approval, the rule base rule and the like. The network interface of the computer device 2 is used for communicating with an external terminal through a network connection.
It will be understood by those skilled in the art that all or part of the process flow for implementing an engineering pricing review method can be implemented by instructing the associated hardware with a computer program, which can be stored in a non-volatile computer readable storage medium, and when executed, can include all or part of the process flow of an engineering pricing review method as described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
Based on the computing device disclosed above, the embodiment of the present application further discloses a computer readable storage medium, such as various media capable of storing program codes, for example, a usb disk, a removable hard disk, a read only memory, a random access memory, a magnetic disk or an optical disk, and the computer readable storage medium stores a computer program capable of being loaded with the engineering pricing auditing method disclosed above by a processor.
The present embodiment is only for explaining the present application, and it is not limited to the present application, and those skilled in the art can make modifications of the present embodiment without inventive contribution as needed after reading the present specification, but all of them are protected by patent law within the scope of the claims of the present application.
Claims (10)
1. A project pricing auditing method is characterized by comprising the following steps:
acquiring the text data of the submission file and the text data of the approval file;
loading the text data of the submission file and the text data of the approved file into a preset comparison and audit model;
generating two types of form data of submission and approval in the comparison and approval model based on the text data of the submission file and the text data of the approval file, and establishing a matching relation between the two types of form data of submission and approval through a data matching rule to obtain a matching result;
determining a data matching type according to the matching result, wherein the data matching type comprises a non-change item, a non-matching item and a change item;
and determining whether to extract the related review and approval form data to generate a corresponding review task based on the data matching type, and sending the corresponding review task to a review interface for display.
2. The method of claim 1, wherein determining whether to perform the data matching based on the data matching type
Extracting the related review and approval form data to generate a corresponding review task, and sending the corresponding review task to a review interface for displaying, wherein the steps comprise:
when the data matching type is a modification item, determining to extract the two form data of submission and approval related to the modification item and establishing a matching relationship, generating a corresponding audit task, and sending the corresponding audit task to an audit interface for display;
and when the data matching type is no matching item, determining to extract the two form data of submission and approval related to the no matching item, generating a corresponding audit task, and sending the corresponding audit task to an audit interface for display.
3. The method of claim 2, wherein said step of determining said data match type comprises
Comprises the following steps:
when the data in the two forms of submission and approval have a matching relation and the data are unchanged, determining that the data matching type is an unchanged item;
when the data in the two forms of submission and approval have a matching relationship and the data changes, determining that the data matching type is a modified item;
and when the data in the two forms of submission and approval do not have a matching relationship, determining that the data matching type is a non-matching item.
4. The method of claim 1, wherein the step after determining the data match type is performed
The method comprises the following steps:
establishing character marks about non-matching items and changing items for the related review and approval morphological data;
and forming data about the literal marks of the non-matching items and the change items, and sending the data to an audit interface for displaying.
5. The method of claim 2, wherein the step after determining the data match type as an alteration comprises:
comparing the two forms of data which are determined to be changed items and are submitted to the trial and the approval to obtain a comparison result;
judging the auditing difference grade based on the comparison result, wherein the data auditing difference grade comprises small difference, small difference and large difference;
and determining whether to perform color rendering on the two forms of data to be audited and approved and form data to be displayed on an audit interface based on the audit difference grade.
6. A project pricing auditing device is characterized by comprising,
the data acquisition module is used for acquiring the text data of the submission file and the text data of the approval file;
the data generation module is used for loading the text data of the submission file and the text data of the approved file into a preset comparison and verification model, and generating submission and approval morphological data in the comparison and verification model based on the text data of the submission file and the text data of the approved file;
the rule base module is used for establishing a matching relation between the submission form data and the approval form data based on the data matching rule so as to obtain a matching result;
the data judging module is used for determining the data matching type according to the matching result;
the data marking module is used for establishing character marks about the unmatched items and the modified items according to the data matching types and the two forms of data which are submitted for examination and approval;
and the first execution module is used for determining whether to extract related review and approval form data or not based on the data matching type, generating a corresponding review task and sending the corresponding review task to the review interface.
7. The method of claim 6, further comprising:
the data comparison module is used for comparing the two form data determined as the submission and the approval of the change item to obtain a comparison result;
the grade judging module is used for judging the grade of the data auditing difference based on the comparison result;
and the second execution module is used for determining whether to perform color rendering on the form data which is submitted for examination and approved based on the data difference grade, and forming data to be sent to an examination interface for display.
8. A computer device comprising a memory and a processor, the memory having stored thereon a computer program that can be loaded by the processor and that executes a method according to any one of claims 1 to 5.
9. A computer-readable storage medium, in which a computer program is stored which can be loaded by a processor and which executes a project pricing auditing method according to any one of claims 1 to 5.
10. A project pricing auditing system is characterized by comprising
A computer device according to claim 8;
and the data acquisition device is used for acquiring the text data of the submission file and the text data of the approval file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011150436.0A CN112307101A (en) | 2020-10-24 | 2020-10-24 | Project pricing auditing method, device, computer equipment and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011150436.0A CN112307101A (en) | 2020-10-24 | 2020-10-24 | Project pricing auditing method, device, computer equipment and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112307101A true CN112307101A (en) | 2021-02-02 |
Family
ID=74327313
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011150436.0A Pending CN112307101A (en) | 2020-10-24 | 2020-10-24 | Project pricing auditing method, device, computer equipment and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112307101A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113781012A (en) * | 2021-09-26 | 2021-12-10 | 深圳供电局有限公司 | Distribution network cost evaluation method and system |
| CN113781011A (en) * | 2021-09-26 | 2021-12-10 | 深圳供电局有限公司 | Verification method and system for project cost of power distribution network |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109190092A (en) * | 2018-08-15 | 2019-01-11 | 深圳平安综合金融服务有限公司上海分公司 | The consistency checking method of separate sources file |
| CN109766430A (en) * | 2018-12-17 | 2019-05-17 | 深圳壹账通智能科技有限公司 | Contract audit method, apparatus, computer equipment and storage medium |
| CN111046142A (en) * | 2019-12-13 | 2020-04-21 | 深圳前海环融联易信息科技服务有限公司 | Text examination method and device, electronic equipment and computer storage medium |
| CN111598732A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Construction project cost auditing system and method |
-
2020
- 2020-10-24 CN CN202011150436.0A patent/CN112307101A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109190092A (en) * | 2018-08-15 | 2019-01-11 | 深圳平安综合金融服务有限公司上海分公司 | The consistency checking method of separate sources file |
| CN109766430A (en) * | 2018-12-17 | 2019-05-17 | 深圳壹账通智能科技有限公司 | Contract audit method, apparatus, computer equipment and storage medium |
| CN111046142A (en) * | 2019-12-13 | 2020-04-21 | 深圳前海环融联易信息科技服务有限公司 | Text examination method and device, electronic equipment and computer storage medium |
| CN111598732A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Construction project cost auditing system and method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113781012A (en) * | 2021-09-26 | 2021-12-10 | 深圳供电局有限公司 | Distribution network cost evaluation method and system |
| CN113781011A (en) * | 2021-09-26 | 2021-12-10 | 深圳供电局有限公司 | Verification method and system for project cost of power distribution network |
| CN113781011B (en) * | 2021-09-26 | 2024-09-03 | 深圳供电局有限公司 | Auditing method and system for power distribution network engineering cost |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9690788B2 (en) | File type recognition analysis method and system | |
| CN111553137B (en) | Report generation method and device, storage medium and computer equipment | |
| CN114092951A (en) | Financial bill processing method, device, system, equipment and medium combining RPA and AI | |
| CN112307101A (en) | Project pricing auditing method, device, computer equipment and system | |
| CN114519498A (en) | Quality evaluation method and system based on BIM (building information modeling) | |
| CN113298497A (en) | Drawing review method and system based on building information model | |
| CN112529575A (en) | Risk early warning method, equipment, storage medium and device | |
| CN111462388A (en) | Bill inspection method and device, terminal equipment and storage medium | |
| CN115017272A (en) | Intelligent verification method and device based on registration data | |
| CN110414806B (en) | Employee risk early warning method and related device | |
| CN109214362B (en) | Document processing method and related equipment | |
| CN116757812A (en) | Method, device, electronic equipment and storage medium for detecting abnormal data | |
| CN111784423B (en) | Invoice matching method and device, electronic equipment and storage medium | |
| CN117541180A (en) | Invoice processing method, invoice processing device and invoice processing medium | |
| CN115423421A (en) | Method and device for automatically auditing process of inspection report, electronic equipment and medium | |
| CN113327023A (en) | Traversal test method and device, electronic equipment and computer readable storage medium | |
| CN115170073A (en) | Logistics arbitration list processing method, device, equipment and storage medium | |
| CN113837170A (en) | Automatic auditing processing method, device and equipment for vehicle insurance claim settlement application | |
| CN113537964A (en) | Application form processing method, device, storage medium and device | |
| CN108235324B (en) | Short message template testing method and server | |
| CN113762719A (en) | Text similarity calculation method, computer equipment and storage device | |
| CN113626655A (en) | Method for extracting information in file, computer equipment and storage device | |
| CN112052150A (en) | Page loading time detection method, equipment, storage medium and device | |
| CN112287828A (en) | Financial statement generation method and device based on machine learning | |
| CN112650864A (en) | Data processing method and device, electronic 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210202 |
|
| RJ01 | Rejection of invention patent application after publication |