CN115713309A

CN115713309A - Internal auditing system

Info

Publication number: CN115713309A
Application number: CN202211492056.4A
Authority: CN
Inventors: 王海洋; 王岩; 苏亚武; 张保泉; 邵治国; 王珂
Original assignee: China Construction Eighth Engineering Division Co Ltd
Current assignee: China Construction Eighth Engineering Division Co Ltd
Priority date: 2022-11-25
Filing date: 2022-11-25
Publication date: 2023-02-24

Abstract

The invention discloses an internal auditing system, which comprises: the project information summarizing module is used for summarizing and increasing project information; the project information filling module is used for filling project information, and the project information comprises market information, contract information, business information, material information, engineering information, financial information, other information and audit information; and the system authority management module is used for performing role management, member management and function distribution of system authority. The internal audit system is a platform based on the full-process management of the audit project and is used for managing and reporting the full-process data in the project process. The platform provides data filling in each stage of the project and submits standardization of an auditing process. The platform provides auditing and approving of audit data. The standardization, unification and informatization of the global data management of the audit project management are achieved through the construction of a system platform, and reasonable and standard management is provided.

Description

Internal auditing system

Technical Field

The invention relates to the technical field of information, in particular to an internal auditing system.

Background

In order to implement the strategy of enterprise comprehensive informatization transformation and upgrading, project audit management deployment is enhanced, and the informatization level is further audited and calculated. It is necessary to build a project database for audit management. However, the data is time-consuming and labor-consuming through manual statistics, the timeliness and the accuracy are poor, the management value of the data is lost after the statistics is completed, the fineness degree of the manual statistics cannot meet the increasingly refined management requirement, the statistics is not timely and accurate, the analysis and early warning are insufficient, and the repetitive work occupies a large amount of working time.

Disclosure of Invention

In order to overcome the defects in the prior art, the invention provides an internal audit system, which achieves the standardization, unification and informatization of data management of audit project management and provides reasonable and standard management.

The invention is realized by the following technical scheme:

an inside audit system, comprising:

the project information summarizing module is used for providing a project information summarizing page for a login person with authority to log in and then summarize and add project information;

the project information filling module is used for providing a project information filling page for a login person with authority to log in and then filling project information, wherein the project information comprises market information, contract information, business information, material information, engineering information, financial information, other information and audit information;

and the system authority management module is used for providing a system authority management page for the login of a login person with authority to perform role management, member management and function distribution of the system authority.

The internal auditing system of claim 1 further comprising a logic processing module that employs a Springboot technique to perform logic processing between the project information aggregation module, the project information reporting module, and the system privilege management module.

In some embodiments, the system further comprises a storage module for generating and logically processing required data in the internal auditing system, wherein the storage module comprises a master database and a slave database, the master database is responsible for data writing, and the slave database is responsible for data reading; the master database is provided with a source database of all bottom data, forms a plurality of levels according to the authority level of an organization, and acquires different source data information at different personnel organization levels; each project establishes a separate slave database, establishes project ID, is matched with the slave database, and contains project data, project table data tables and project characteristic data.

In some embodiments, the project information summarizing module, the project information filling module and the system authority management module call data from a database selected by a user after receiving a request of the user, transmit the data to a View layer for data analysis in a JSON data transmission mode, and present the data to the user for data selection.

In some embodiments, the memory module further comprises: the data of the corresponding table and the corresponding field are captured from the corresponding slave database through the storage relation of the basic logic data of the master database, the data are analyzed into standard XML data and then are transmitted to a Sprie component, the Sprie component carries out merging generation of Word versions according to the analysis style of the master database and the filling positions of the data and the data,

in some embodiments, the storage module of the internal examination system adopts an Oracle database technology, and the View layer is realized by adopting a Vue technology.

In some embodiments, the internal examination system further includes a scheme compiling and approving module, which is used for establishing a scheme template, pre-inputting scheme source data, generating a scheme, compiling the scheme, auditing and approving the scheme, and browsing the scheme.

In some embodiments, the internal auditing system further comprises a major project joint auditing module, a technical backbone and project auditor module, a head office authorization management module and a data logic module of a double-optimization case base.

Due to the adoption of the technical scheme, the invention has the beneficial effects that:

the internal auditing system is a platform based on the whole-process management of the auditing project and is used for managing and reporting the whole-process data in the project process. The platform provides data filling in each stage of the project and submits standardization of an auditing process. The platform provides auditing and approving of audit data. The standardization, unification and informatization of the global data management of the audit project management are achieved through the construction of a system platform, and reasonable and standard management is provided.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is an application functional architecture diagram of an audit system according to an embodiment of the present invention.

FIG. 2 is a diagram of a deployment architecture of an in-flight system in accordance with an embodiment of the present invention.

Detailed Description

Some terms referred to herein are to be interpreted as follows:

OA: office Automation (OA for short) is a new Office mode formed by applying modern technologies such as computer and communication to the traditional Office mode.

A Spire component: is an enterprise-level NET Office operations component.

Oracle database: also known as Oracle RDBMS, or Oracle for short, is a group of software products with distributed databases as the core, offered by Oracle corporation of america, one of the most popular databases of the CLIENT/SERVER (CLIENT/SERVER) or B/S architecture. Such as SilverStream, is a database-based middleware. The ORACLE database is the most widely used database management system in the world, and is used as a general database system which has complete data management function; as a relational database, it is a complete relational product; it implements distributed processing functions as a distributed database.

And (3) a View layer: as the name implies, the display pages (such as jsp, html and the like) at the front end are the main ones.

Spring Boot: is a completely new framework provided by the Pivotal team, designed to simplify the initial set-up and development process of new Spring applications. The SpringBoot completes the integration of various frames, so that the frames are integrated more simply, and the complicated templated configuration in the integration process is simplified.

Vue 3: is a library written in TypeScript that can enjoy automatic type-defined hints.

JSON: (JavaScript Object Notation, JS Object Notation) is a lightweight data exchange format.

DM: the tables of the database can be divided into two types, namely an internal table and an external table of the database, wherein the internal table of the database is automatically organized and managed by a database management system, and the external table is organized outside the database and is an operating system file. Wherein the internal table includes: database normal table, partition table, temporary table, heap table (rowid), and inventory table (HUGE).

SpreadJS: the control is a pure front-end table control, is compatible with more than 450 Excel formulas based on HTML5, and has the product characteristics of high performance, cross-platform and high compatibility with Excel. The SpreadJS is highly similar to Excel in interface and function, but is not limited to Excel, and provides application scene support of form document collaborative editing, data filling and Excel report-like design for an enterprise information system, so that enterprise research and development cost and project delivery risk are greatly reduced.

WCF: the Windows Communication Foundation is a series of application program frameworks developed by microsoft and supporting data Communication, and can be translated into a Windows Communication development platform.

The following further describes embodiments of the present invention with reference to the drawings. It should be noted that the description of the embodiments is provided to help understanding of the present invention, but the present invention is not limited thereto. In addition, the technical features involved in the embodiments of the present invention described below may be combined with each other as long as they do not conflict with each other.

Referring to fig. 1, the internal auditing system of the embodiment of the present invention mainly includes three business modules: the system comprises a project information gathering module, a project information filling module and a system authority setting module, wherein different service functions and service operations are subdivided under each service module. The main functions are as follows:

the project information summarizing module is used for providing a project information summarizing page for a login person with authority to log in and then summarizing and increasing project information;

and the system authority management module is used for providing a system authority management page for role management, member management and function distribution of system authority after a login person with authority logs in.

The internal auditing system of the embodiment of the invention further comprises a logic processing module which adopts a Springboot technology to carry out logic processing among the project information summarizing module, the project information filling module and the system authority management module.

The internal audit system of the embodiment of the invention further comprises a storage module, which is used for generating and logically processing the required data in the internal audit system, wherein the storage module comprises a master database (also called an OS master database) and a slave database (also called an OSP slave database), and the master database is responsible for data writing and the slave database is responsible for data reading. The database architecture uses a master-slave database design mode, and the design aims to enable data to have relevance and independence and improve data reading and writing efficiency. And when the servers are increased due to the increase of the traffic, the migration and the distribution deployment of data are facilitated.

The main database is provided with a source database of all bottom data, and all data information of the system, such as an excellent scheme data table, a scheme template data table, personnel information, organization information and the like, is in the database. The main database forms a plurality of hierarchies according to the authority levels of the organization, and different personnel organization levels acquire different source data information;

and (3) the user calls a system recommendation function, a call request is input on front-end pages of the project information summarizing module, the project information filling module and the system authority management module, the system receives the request of the user and calls data from an OSP (open shortest Path first) selected by the user from a library, the data are transmitted to a View logic layer for data analysis in a JSON (Java Server object oriented notation) data transmission mode, and finally the data are presented to the user for selecting scheme data. And capturing the data of the corresponding table and the corresponding field from the corresponding OSP slave library through the storage relation of the basic logic data of the OS master library, analyzing the data into standard XML data and transmitting the standard XML data to the Sprie component, and merging and generating the Word version by the Sprie component according to the analysis style of the OS master library and the filling position of the data and the data.

Wherein each project establishes a separate OSP slave library, establishes a project ID, and matches with the slave database. The database comprises project characteristic data such as project data of project data, project table data tables, project headquartering authority and the like.

The design principle of the internal examination system of the invention is as follows: after the system WEB terminal collects data input and instructions, different database units are called to carry out data interaction after the data are screened, preanalyzed and processed. And performing data interaction between the master database and the slave database according to different business function operations.

The storage module of the internal examination system in the embodiment of the invention adopts an Oracle database technology, the View layer is realized by adopting a Vue technology, and the system deployment architecture of the internal examination system is shown in FIG. 2.

Furthermore, the internal examination system of the invention also comprises a scheme compiling and approving module which is used for establishing a scheme template, pre-inputting scheme source data, generating a scheme, compiling the scheme, auditing and approving the scheme and browsing the scheme, and the specific contents are as follows.

1. Project template creation

According to six types (construction organization total design, unit engineering construction organization design, A type construction scheme, B type construction scheme, C type construction scheme and D type construction scheme, wherein the construction organization total design is divided into house construction organization total design, municipal engineering construction organization total design, highway engineering construction organization total design, railway engineering construction organization total design, EPC engineering construction organization total design, pipe gallery engineering construction organization total design, rail traffic engineering construction organization total design and the like) scheme standard templates, contents of sections, tables, scheme texts and the like in the scheme templates are subjected to data structuring to be used as templates and are input into an OS database through a background management tool, each table corresponds to one DM table in the database, and fields in the DM table correspond to cell contents in the scheme table one by one. The purpose of this step is to structure the schema table data for later use in word consolidation.

2. Plan source data pre-entry

Aiming at the existing excellent scheme, a scheme template stored in an OS library is called out through a system, the system automatically brings in information such as project names, filling personnel and the like according to a preset standard, and the residual content needs to be manually input according to the actual situation. After the entry is completed, the system converts the whole scheme content into a Json character string through the SpreadJS control, calls WCF service, and stores the Json character string into a respective project database (OSP).

3. Schema generation

The scheme generation data structure logic analysis is divided into two steps:

1) When the WEB side generates an operation scheme, the system converts the scheme template selected by the user in the UI interface into a parameter and transmits the parameter to a Business Logic Layer (BLL), and the system extracts the excellent scheme selected by the user from an OS library by calling WCF service according to the received template message selected by the user and inserts the excellent scheme into an OSP database of the project.

2) Screening out data nodes needing to be compiled and filled in the scheme table in the OSP sub-database, searching out a corresponding scheme table from the main database OS according to the screened data nodes, inserting the scheme table into a corresponding DM table in the OSP sub-database, returning corresponding results after the operation is finished, summarizing and processing the results, and then transmitting the results back to a WEB end page for displaying the results.

Example (c): generation scheme by taking standardized template scheme as template

And the WEB terminal acquires the current user information, obtains the organization structure of the user from the OS main database through screening analysis, and transmits the organization structure to a corresponding database table according to the association data table of the organization database and the WEB terminal transmission instruction operation. Data analysis is the execution of a modular schema generation for this operation for sub-database B.

Listing the list of corresponding form modules and chapter module directories which accord with the conditions in the main database according to the screening conditions (scheme types, engineering types and the like), executing copy operation, storing the copy operation in a corresponding table, and transmitting the copy operation to the sub-database B.

And the subdata B receives the transmitted data table, then executes the operation of writing in the data table, returns a corresponding instruction to the WEB side after the operation is finished, and simultaneously transmits a piece of record information to be stored in the table corresponding to the main database. And the WEB terminal processes the data and then displays a corresponding result to the user.

Example (c): scheme for generating template by using excellent scheme

And the WEB terminal acquires information such as user ID and the like, screens and analyzes the information into the main database to acquire a corresponding organization structure, and transmits the information into a corresponding database table according to the associated data table of the organization database and the WEB terminal transmission instruction operation. After data screening, analyzing and processing, the operation takes the excellent scheme a as a template to generate a scheme for the sub-database B.

And finding the excellent scheme a in the sub-data A base through the excellent scheme a information in the main database. And obtaining a form module and a chapter module corresponding to the excellent scheme a in the sub-database A and corresponding data information, copying, and transmitting to the sub-database B.

And the subdata B receives the data table and the like transmitted by the subdatabase A, then executes the operation of writing in the data table, and returns a corresponding instruction to the WEB end after the operation is finished. And the WEB terminal processes the data and then displays a corresponding result to the user.

4. Planning of a project

Scheme compilation data logic: when a user opens a generated scheme compiling task 1, the system acquires an project library (OSP) corresponding to a mechanism where the user is located in a database from an organization mechanism table in a main database OS through current user information, acquires a scheme form required to be input by the project scheme from a sub database (OSP) according to the task 1 information, transmits a Json character string converted in the system according to the form to a Business Logic Layer (BLL) through WCF service, and transmits the Json character string to a UI through front and back ends to display a specific scheme form.

And when the node is compiled in the compiling process, the background converts the form into a Json character string through the SpreadJS control displayed at the front section, the Json character string is transmitted to a background Business Logic Layer (BLL) through the Ajax technology, the system updates Json to a database (OSP) corresponding to the project through WCF service according to business logic, and the content of each cell is stored in a corresponding DM field for the functions of ledger display, condition query and the like.

And in the closing operation, the system acquires the information from an item database (OSP) where the user is located according to the user information.

According to the template form of the project scheme, json character strings of the scheme form are transmitted to a business logic layer BLL by calling WCF service, the form is subjected to manuscript combination operation through Sprie components through background logic, a manuscript combination file is converted into Json character strings and transmitted to the front end after manuscript combination is completed, and the file after manuscript combination is displayed through SpreadJS controls.

5. Scheme examination and approval

Approval process data logic: when a user initiates an approval request, the system automatically initiates approval according to approval process information preset in a process library (WF), determines specific information of a next approver according to a mechanism where the current user is located and a post to which the next approver belongs, and pushes the information to the approver.

After receiving the message, the approver opens the specific table contents and the accessory information of the scheme by double-click, and after the specific table contents and the accessory information are determined, the approver can perform approval operation, select approval results, input approval opinions and the like. And after the approval is finished, automatically transferring to the next approver according to the flow until the approval is finished.

6. Project browsing

Scheme browsing data logic: the system inquires the related information of the current user through the information of the current user and the WCF service, determines the level of the scheme browsing authority of the current user, displays different contents according to the authority, transmits the part which the user allows to see to a Business Logic Layer (BLL) through the WCF service, and transmits the part to a front end (UI) for display after background processing. When a user views a specific scheme c in the list, the corresponding c scheme information is inquired into a scheme in a sub-database (OSP) A according to a selected c scheme-main database (OS) corresponding table,

the Json character string of the scheme is transmitted to a Business Logic Layer (BLL) through WCF service, the Json character string is transmitted to a front end after being processed through Ajax technology, and the Json character string is displayed to a user through a SpreadJS control.

Furthermore, the internal examination system in the embodiment of the present invention further includes a major scheme co-examination module, a technical backbone and scheme auditor module, a total worker authorization management module, and a data logic module of a double-optimization case base, and the specific functions of each module are as follows:

1. joint review of major projects

Major scheme joint review data logic: and filling a form of the important scheme to be released, and automatically reading the screened technical scheme temporary form information and the optional personnel temporary form in the auditor library by the system according to the user information in a main database (OS). And clicking the item name cell, selecting the item name through the unit selection specification, calling an event preset in advance in the database, and automatically bringing the selected item into the second-level unit and the third-level unit. And clicking the name cell, automatically bringing in the selected expert through expert selection specifications, triggering an event, automatically bringing in the expert role and the specialty category, and manually inputting the rest contents. And after the entry is finished, performing storage operation, converting the entered form into a Json character string through a SpreadJS control, transmitting the Json character string to a background through an Ajax technology, calling WCF service, and storing the WCF service in the project database (OSP). And screening out corresponding technical scheme information and auditor information according to the returned data information, and storing the technical scheme information and the auditor information into a corresponding form library. And when the major project joint review is initiated, reading the corresponding technical project information and personnel information from the system autonomous database, and then pushing the information to the corresponding examination and approval personnel. The approval process refers to the approval functional logic. Meanwhile, an open information exchange area is established to show information of a large scheme, so that all users of the system can browse and publish opinions.

2. Technical backbone and scheme auditor

Data logic of technical backbone and scheme auditors: the information template is established in the OS master database in the same way as the scheme template. The system collects user information, transmits the user information to a main database (OS), screens out corresponding information according to conditions, processes the information into a temporary table, transmits the temporary table to a Business Logic Layer (BLL) through WCF service, and transmits the temporary table to a WEB side for display after code processing. And during data entry, the data is filled in a form of a table, the front end converts the table content into a Json character string through a SpreadJS control, the Json character string is transmitted to the rear end through an Ajax technology, and the WCF service is called after code processing and is stored in DM and DU tables corresponding to an item database (OSP) and is stored in a corresponding data unit.

3. Master authority management

The head office authorizes and manages the data logic: corresponding unit information is read in the main database when a general worker authorization table is created, the Json strings are transmitted to the rear end through the WCF service, and after logical processing, the Json strings are transmitted to the front end UI and displayed through the SpreadJS control. When the information is stored, according to the information in the filled form + the information of the user, the corresponding sub database (OSP) is searched by using the user information table + the organization table of the autonomous database (OS), the master worker authorization data unit table of the sub database is generated in the sub database (OSP) according to the data unit copy of the master worker authorization table template of the main database, and the corresponding data is stored in the corresponding unit. Meanwhile, a master authority list record is created in the main database.

3. Data logic of double-optimized case base

Data logic of the double-optimization case base: and transmitting the current user information and the selected filtering condition to a main database (OS), reading corresponding mechanism information from the mechanism table according to the user information, combining the filtering condition information and the mechanism information to the main table of the double-optimization library, reading the corresponding information, creating a temporary table and returning the temporary table to a WEB terminal.

The embodiments of the present invention have been described in detail with reference to the accompanying drawings, but the present invention is not limited to the described embodiments. It will be apparent to those skilled in the art that various changes, modifications, substitutions and alterations can be made in the embodiments without departing from the principles and spirit of the invention, and these embodiments are still within the scope of the invention.

Claims

1. An inside audit system comprising:

2. The internal auditing system of claim 1 further comprising a logic processing module that employs a Springboot technique to perform logic processing between the project information aggregation module, the project information reporting module, and the system privilege management module.

3. The inside audit system according to claim 2 further comprising a storage module for generating and logically processing required data within the inside audit system, the storage module including a master database responsible for data writing and a slave database responsible for data reading; the master database is provided with source databases of all bottom data, forms a plurality of levels according to the authority levels of the organization, and acquires different source data information at different personnel organization levels; each project establishes a separate slave database, establishes project ID, is matched with the slave database, and contains project data, project table data tables and project characteristic data.

4. The inside audit system of claim 3 wherein the project information summarization module, the project information reporting module, and the system authority management module retrieve data from a database selected by a user after receiving a request from the user, transmit the data to a View layer for data parsing through a JSON data transmission mode, and present the data to the user for data selection.

5. The inside audit system of claim 4 wherein the storage module further comprises: the data of the corresponding table and the corresponding field are captured from the corresponding slave database through the storage relation of the basic logic data of the master database, the data are analyzed into standard XML data and then are transmitted to a Sprie component, the Sprie component carries out merging generation of Word versions according to the analysis style of the master database and the filling positions of the data and the data,

6. the in-house inspection system of claim 5, wherein the storage module of the in-house inspection system is implemented by using Oracle database technology, and the View layer is implemented by using Vue technology.

7. The inside examination system according to claim 6, further comprising a scheme compiling and approving module, which is used for establishing a scheme template, pre-inputting scheme source data, generating a scheme, compiling the scheme, auditing and approving the scheme, and browsing the scheme.

8. The inside examination system of claim 7, further comprising a major project co-examination module, a technical backbone and project auditor module, a head office authorization management module, and a data logic module of a double optimized case base.