CN112270495B - Charging circuit flow acquisition guarantee and auditing method and device - Google Patents
Charging circuit flow acquisition guarantee and auditing method and device Download PDFInfo
- Publication number
- CN112270495B CN112270495B CN202011268747.7A CN202011268747A CN112270495B CN 112270495 B CN112270495 B CN 112270495B CN 202011268747 A CN202011268747 A CN 202011268747A CN 112270495 B CN112270495 B CN 112270495B
- Authority
- CN
- China
- Prior art keywords
- auditing
- flow
- flow data
- data
- charging circuit
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 36
- 230000004907 flux Effects 0.000 claims abstract description 38
- 238000012545 processing Methods 0.000 claims abstract description 27
- 230000002159 abnormal effect Effects 0.000 claims abstract description 12
- 238000012550 audit Methods 0.000 claims description 34
- 238000004590 computer program Methods 0.000 claims description 10
- 230000001360 synchronised effect Effects 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 5
- 230000002354 daily effect Effects 0.000 description 4
- 238000009499 grossing Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000003203 everyday effect Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013524 data verification Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- 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/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- 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
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Game Theory and Decision Science (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a device for collecting, guaranteeing and auditing flow of a charging circuit, wherein the method comprises the following steps: the method comprises the steps of deploying main and standby acquisition modules on different servers, and carrying out redundant acquisition on a charging circuit; the main acquisition module acquires data into the flux library table, and the backup acquisition module acquires data into the flux library table; synchronizing data in the flux library table to the accounting database table flux at regular time; processing the abnormal flow data by combining the main data and the standby data, and correcting a billing database table fluxmerge; auditing the corrected flow data by two-stage personnel in the city and province; and outputting a data month report based on the checked-out database table fluxmerge. The method and the device ensure the accuracy of the data of the charging circuit through the flow acquisition backup, the data processing and the data auditing of the charging circuit, enhance the reliability of the charging circuit and reduce the complaint phenomenon of inaccurate charging of users.
Description
Technical Field
The invention relates to the field of flow collection of charging circuits, in particular to a method and a device for guaranteeing and auditing flow collection of a charging circuit.
Background
The flow data of the large-client charging circuit is the basis of cost settlement, once the data is inaccurate, problems such as fund disputes and user complaints are generated, so that the crisis of losing user trust is caused, and bad influence of lost users and markets is caused, therefore, a scheme is needed to ensure the accuracy and the reliability of the charging data, and a set of auditing flow is adopted to control the output of the flow data of the large-client charging circuit finally used for charging.
Disclosure of Invention
In order to solve the problem that the accuracy of flow data of a large-client charging circuit cannot be guaranteed, the invention provides a charging circuit flow acquisition and verification method and device, which ensure the accuracy of the flow data of the large-client charging circuit by aiming at a flow data acquisition backup scheme, a data processing mechanism and a flow data verification flow of the charging circuit, enhance the reliability of the flow data of the charging circuit and reduce complaints of users on inaccurate charging.
In order to achieve the above purpose, the present invention adopts the following technical scheme:
in an embodiment of the present invention, a method for collecting, guaranteeing and auditing flow of a charging circuit is provided, the method includes:
a main acquisition module and a backup acquisition module are deployed on different servers, and redundant acquisition is carried out on flow data of a charging circuit; the main acquisition module acquires the flow data into a flux library table, and the backup acquisition module acquires the flow data into the flux library table;
the flow data in the flux library table are synchronized to the flux database table in a timing mode;
processing the abnormal flow data by combining the main flow data and the standby flow data, and correcting a billing database table fluxmerge;
auditing by two-stage staff in the city and province aiming at the corrected flow data;
and outputting a charging circuit flow data month report based on the checked and approved accounting database table fluxmerge.
Further, the method further comprises:
the streaming data is queried by query conditions including node location, query date, device name, port name, customer name, and circuit name.
Further, daily traffic data to be audited is generated based on the flux library table, and the traffic data status is divided into three types:
there is 0 flow, i.e. the flow inflow or outflow speed is 0 in any period;
the flow is complete, namely the speed of inflow or outflow of the flow is not 0 in any period;
the current day is the absence of flow, i.e. no flow is collected during the current day.
Further, the two-stage personnel in the city and province audit the corrected flow data, including:
the charging circuit flow data under the provincial center node is directly checked and passed by the provincial company personnel;
after the level 2 auditing of the charging circuit flow data under the local city node is passed through the corporate staff auditing and the provincial staff auditing, the final auditing is passed, or the provincial staff directly passes the final auditing;
after the final auditing is passed, the auditing state and auditing time are not changed any more;
before or after the final audit is passed, the audit opinion of the user is allowed to be added and is reserved as a historical audit opinion.
In an embodiment of the present invention, there is also provided a device for collecting, guaranteeing and auditing flow of a charging circuit, the device including:
the flow data redundancy acquisition module is used for deploying a main acquisition module and a backup acquisition module on different servers and carrying out redundancy acquisition on flow data of the charging circuit; the main acquisition module acquires the flow data into a flux library table, and the backup acquisition module acquires the flow data into the flux library table;
the main data synchronization module is used for synchronizing the flow data in the flux database table to the flux database table at regular time;
the flow data processing module is used for processing the abnormal flow data by combining the main flow data and the standby flow data and correcting the accounting database table fluxmerge;
the flow data auditing module is used for auditing the corrected flow data by two-stage personnel in the city and province;
and the monthly statement statistical module is used for outputting the monthly statement of the flow data of the charging circuit based on the accounting database table fluxmerg after the auditing is passed.
Further, the apparatus further comprises:
and the flow data query module is used for querying the flow data through query conditions including node positions, query dates, device names, port names, client names and circuit names.
Further, daily traffic data to be audited is generated based on the flux library table, and the traffic data status is divided into three types:
there is 0 flow, i.e. the flow inflow or outflow speed is 0 in any period;
the flow is complete, namely the speed of inflow or outflow of the flow is not 0 in any period;
the current day is the absence of flow, i.e. no flow is collected during the current day.
Further, the flow data auditing module is specifically configured to:
the charging circuit flow data under the provincial center node is directly checked and passed by the provincial company personnel;
after the level 2 auditing of the charging circuit flow data under the local city node is passed through the corporate staff auditing and the provincial staff auditing, the final auditing is passed, or the provincial staff directly passes the final auditing;
after the final auditing is passed, the auditing state and auditing time are not changed any more;
before or after the final audit is passed, the audit opinion of the user is allowed to be added and is reserved as a historical audit opinion.
In an embodiment of the present invention, a computer device is further provided, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the foregoing method for collecting, guaranteeing and auditing the flow of the charging circuit when executing the computer program.
In an embodiment of the present invention, a computer readable storage medium is also provided, where the computer readable storage medium stores a computer program for executing the method for collecting, guaranteeing and auditing the flow of the charging circuit.
The beneficial effects are that:
1. the invention adopts a redundant acquisition means to ensure the integrity of flow data acquisition.
2. The invention processes the charging circuit with abnormal flow data, and improves the accuracy and the integrity of the flow data.
3. The invention ensures that the final account-out data is repeatedly checked and confirmed by carrying out 2-level audit on the flow data of the charging circuit.
4. The invention strictly guarantees the integrity, accuracy and reliability of the account data and enhances the trust of users.
Drawings
FIG. 1 is a schematic diagram of a flow collection, security and auditing method for a billing circuit according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a charging circuit flow data audit according to an embodiment of the present invention;
FIG. 3 is a graph of daily flow (data averaged every 5 minutes) for a billing circuit according to an embodiment of the invention;
FIG. 4 is a schematic diagram of a flow collection, security and audit device for a billing circuit according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The principles and spirit of the present invention will be described below with reference to several exemplary embodiments, with the understanding that these embodiments are merely provided to enable those skilled in the art to better understand and practice the invention and are not intended to limit the scope of the invention in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
Those skilled in the art will appreciate that embodiments of the invention may be implemented as a system, apparatus, device, method, or computer program product. Accordingly, the present disclosure may be embodied in the following forms, namely: complete hardware, complete software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
According to the embodiment of the invention, a method and a device for collecting, guaranteeing and auditing the flow of a charging circuit are provided, and the method comprises the following functions: adding backup collection of flow data of a charging circuit, and when the existing collection has problems, manually correcting the flow data acquired by backup; inquiring flow data of a charging circuit and processing abnormal flow data; an auditing flow of flow data of the charging circuit; and (5) a month statistics report of the flow data of the charging circuit.
The principles and spirit of the present invention are explained in detail below with reference to several representative embodiments thereof.
Fig. 1 is a logic schematic diagram of a method for collecting, guaranteeing and auditing flow of a charging circuit according to an embodiment of the present invention. As shown in fig. 1, the method includes:
a main acquisition module and a backup acquisition module are deployed on different servers, and redundant acquisition is carried out on flow data of a charging circuit; the main acquisition module acquires the flow data into the flux library table, and the standby acquisition module acquires the flow data into the flux library table.
The synchronization program periodically synchronizes the flux table traffic data into the egress database table fluxmerge.
Processing the abnormal flow data by combining the main flow data and the standby flow data, and correcting the accounting database table fluxmerge.
And auditing by two-stage staff in the city and province aiming at the corrected staff.
And outputting a circuit flow data month report based on the checked-out database table fluxmerge.
Generating flow data to be audited every day based on a flux table, wherein the flow conditions are divided into the following steps:
there is 0 flow: i.e. the flow rate into or out of the flow chamber is 0 at any period.
The flow is complete: i.e. the flow rate in or out is not 0 at any period.
Current day flow loss: i.e. no flow is collected during the day.
And processing the abnormal flow data by adopting a flow data smoothing tool.
Flow data smoothing tool:
tool naming: ipsflux smooth.pl;
the functions are as follows: a flow rate billing data smoothing program;
parameters:
-c [ ircuitid ] CIR00000 represents a specific circuit identity
-s [ source ] main/back/merge represents the data source, and the primary/standby/egress data correspond to the tables flux/fluxback/fluxmerge, respectively
-p [ policy ] replace/smooth represent processing policy, direct overlay/smooth post-computation replacement
-d [ ays ] 7 represents the time point data of how many days before use in the smoothing calculation, defaults to 7, maximum 7
Ts [ start ] 201508251000 represents the start time, format: YYYYMMDDHH24MI 24
Te [ nd ] 201508251400 represents the expiration time, format: YYYYMMDDHH24MI 24
If the parameter-p is replace, directly taking the data in the corresponding time range in the Flux or Fluxbak table to replace the data in the Fluxmerge table.
If the parameter-p is smooths, the mean value is calculated from the time point data of how many days before being taken from the data source table, and then the data in the fluxmerge table is replaced.
Fig. 2 is a logic diagram of a charging circuit traffic data audit according to an embodiment of the present invention. As shown in fig. 2, two-stage auditing is performed for charging circuit data:
the charging circuit flow data under the provincial center node is directly checked and passed by the provincial company personnel;
the charging circuit flow data under the local city node is required to pass through a branch auditing pass-provincial auditing pass-level 2 auditing before final auditing pass, but provincial staff can also pass the final auditing directly;
after the auditing is finally passed, the auditing state and auditing time can not be changed any more;
before or after the auditing is finally passed, the user can add own auditing opinion, and the system is used as a historical auditing opinion to be reserved.
It should be noted that although the operations of the method of the present invention are described in a particular order in the above embodiments and the accompanying drawings, this does not require or imply that the operations must be performed in the particular order or that all of the illustrated operations be performed in order to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step to perform, and/or one step decomposed into multiple steps to perform.
In order to more clearly explain the above-mentioned charging circuit flow collection and auditing method, the following description is made with reference to specific embodiments, however, it should be noted that this embodiment is only for better explaining the present invention, and is not meant to limit the present invention unduly.
Inquiring flow data of a charging circuit and processing abnormal flow data:
inquiring through a charging circuit flow inquiry interface, wherein the user interface interaction flow is as follows:
1. the user enters the query conditions to locate the charging circuit to be queried, and must locate a unique one. The following resource positioning needs to be controlled according to the current user authority.
(1) Node position: the same as the circuit maintenance page. And filling is needed, and the node position corresponding to the account number is loaded by default, so that only the lower node position can be selected.
(2) Device name: with a drop-down selection box entered, the device name is searched for and a selection list is provided immediately upon entry. It is necessary to coordinate with the node location.
(3) Port name: with the drop-down selection box entered, the port name is searched for and a selection list is provided immediately upon entry. It is necessary to link with the device name.
(4) Customer name: with a drop down selection box entered, the customer name is searched for and a list of selections is provided immediately upon entry. It is necessary to interwork with the device name and port name.
(5) Circuit name: with a drop-down selection box entered, the circuit name is searched for in real time and a selection list is provided. It is necessary to link with the customer name.
2. Screening mechanism: after determining the node position, all charging circuits under the node position are queried, and then the corresponding charging circuits are matched in the memory according to the conditions set by the user. The user selects the query date: the date control is changed to the date of year, month and day, defaulting to the previous day of the system, and other dates can be changed.
The user clicks the "query" button, and if the "circuit name" is empty, the "please specify a circuit first" is prompted. Otherwise, the system presents 3 daily flow charts of the current circuit according to the circuit ID positioned in the step 1 and the flow time obtained in the step 2, and the data are respectively from a main flow table flux, a standby flow table flux bak and an account-out data table flux merge. Like that shown in fig. 3.
4. And the user manually judges whether data processing is needed according to the graph comparison, and if so, clicks a data processing button.
5. The system popup window presents account data processing pages:
(1) Customer name, circuit name, device name, and port name: the flow inquiry interface of the charging circuit transmits parameters.
(2) Start time and end time: the flow inquiry interface of the charging circuit can be changed, but the time span is not allowed to exceed 24 hours.
(3) Data sources: the drop-down box is optional, and the primary data, the standby data and the outbound data are selected.
(4) The processing mode is as follows: pull-down is optional, replace and smooth; when the data source selects the account data, the processing mode is not replaced optionally.
6. The user clicks the "start processing" button, and the system invokes the daemon according to the above specified parameters:
IPSLFluxSmooth.pl-c CIR00000-s main/back/merge-p replace/smooth-ts 201508230000-te 201508240000。
the parameters CIR00000, main/back/merge, replace/smooth, 201508230000 and 201508240000 correspond to: circuit identification, data source (primary, backup and check out), processing mode and start-stop date.
At the same time, the system displays the dialog box "in process, please be … …" later. After the system waits for the program to run, the dialog box is closed and the graphic data on the page is automatically refreshed.
7. The user can click on the "data download" button and the system generates the raw data in the corresponding map as Excel for the user to download. Excel column entries: time point, inflow speed, and outflow speed.
The charging circuit is to be checked:
checking through a charging circuit interface to be checked, wherein the user interface interaction flow is as follows:
1. all circuit lists to be audited in the previous day are displayed by default, and the list field comprises: customer name, circuit name, device name, port name, traffic status, and audit status. Ordered by customer name and circuit name.
(1) Node position: the same as the circuit maintenance page. And filling is needed, and the node position corresponding to the account number is loaded by default, so that only the lower node position can be selected.
(2) Query date: the date control is changed to the date of year, month and day, defaulting to the previous day of the system, and other dates can be changed.
(3) Device name: with a drop-down selection box entered, the device name is searched for and a selection list is provided immediately upon entry. It is necessary to coordinate with the node location.
(4) Port name: with the drop-down selection box entered, the port name is searched for and a selection list is provided immediately upon entry. It is necessary to link with the device name.
(5) Customer name: with a drop down selection box entered, the customer name is searched for and a list of selections is provided immediately upon entry. It is necessary to interwork with the device name and port name.
(6) Circuit name: with a drop-down selection box entered, the circuit name is searched for in real time and a selection list is provided. It is necessary to link with the customer name.
(7) Auditing state: drop down select box, enumerate values: 0-to be audited; 1-branch office auditing passes; 2-province company audit passed.
Screening mechanism: after the node position and the query date are determined, all charging circuits under the node position are queried, and then the corresponding circuits are matched in the memory according to the conditions set by the user.
2. The user clicks the "query" button and the system presents a list of pending records that currently satisfy the condition.
3. The user clicks the right-most auditing word of each record, the system popup window presents an auditing page of a single circuit, and the user can conduct auditing processing. The page displays the following information:
customer name: alemba;
circuit name: IDC_Aliba 14 (billing flow) _TZ-spiced river-connected New building IDC second building 3A-NE40E-S1-G4/1/5to IDC-second building 3A_0212_Aliba;
the display mode is as follows: a flow chart and a data list;
selecting a flow chart, as illustrated in fig. 3;
historical audit opinion:
zhang Yong 2019-04-0912:12:00
Failure of the harvester results in loss of circuit flow.
Sun Juan 2019-04-0917:12:00
And checking is passed.
My audit opinion:
checking is passed; adding audit opinions; and canceling.
(a) Customer name and circuit name: text labels, from parent pages.
(b) The display mode is as follows: the checkbox may select a flow graph and a data list, defaulting to the flow graph. When a data list is selected, the list field includes a point in time, an inflow speed, and an outflow speed. The traffic map and data list are both from the fluxmerge table.
Historical audit opinion: the interface is similar to that of the first acting auditor and audit time, the audit opinion of which follows.
(c) Filling in audit opinions: after inputting comments, the user can click the corresponding button to operate, and the specific button style and the logic for updating data are shown in the step 4.
4. The user can also select the leftmost selection frame, support multiple selection and full selection, and carry out batch processing. Clicking a batch audit button, and popping up an audit opinion filling frame by the system to support clicking an operation button after inputting opinions. The operation buttons include the following 3 kinds:
(a) The auditing is as follows: batch audit pass processing is implemented for the selected circuit. If the node is a city node and the branch office checks the passing circuit, only the provincial company account can be clicked, and the button is disabled under the condition of the branch office account. The update logic is as follows:
if it is the province company account: and recording auditors, auditing time and opinion.
If yes, the account of the branch company: and recording auditors, auditing time and opinion.
(b) Adding audit opinion: and realizing batch examination and addition examination opinion processing on the selected circuits, wherein the examination state is unchanged. The update logic is as follows: a record is inserted into the table circuit_comments to record the auditor, the auditing time and the opinion.
(c) Cancellation: the current operation is canceled.
Based on the same inventive concept, the invention also provides a charging circuit flow acquisition guarantee and auditing device. The implementation of the device can be referred to as implementation of the above method, and the repetition is not repeated. The term "module" as used below may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.
Fig. 4 is a schematic structural diagram of a charging circuit flow collection, security and auditing device according to an embodiment of the present invention. As shown in fig. 4, the apparatus includes:
the flow data redundancy acquisition module 101 is used for deploying a main acquisition module and a backup acquisition module on different servers and performing redundancy acquisition on flow data of the charging circuit; the main acquisition module acquires the flow data into a flux library table, and the backup acquisition module acquires the flow data into the flux library table;
the primary data synchronization module 102 is configured to synchronize the flow data in the flux database table to the flux database table at regular time;
generating flow data to be audited every day based on a flux library table, wherein the flow data status is divided into three types:
there is 0 flow, i.e. the flow inflow or outflow speed is 0 in any period;
the flow is complete, namely the speed of inflow or outflow of the flow is not 0 in any period;
the current day flow is lost, namely no flow is collected in the current day;
the flow data processing module 103 is configured to process abnormal flow data by combining the primary flow data and the backup flow data, and correct a billing database table fluxmerge;
the flow data auditing module 104 is used for auditing the corrected flow data by two-stage personnel in the city and province;
the charging circuit flow data under the provincial center node is directly checked and passed by the provincial company personnel;
after the level 2 auditing of the charging circuit flow data under the local city node is passed through the corporate staff auditing and the provincial staff auditing, the final auditing is passed, or the provincial staff directly passes the final auditing;
after the final auditing is passed, the auditing state and auditing time are not changed any more;
before or after the final audit is passed, allowing the audit opinion of the user to be added as a historical audit opinion to be reserved;
the monthly statement statistics module 105 is used for outputting a charging circuit flow data monthly statement based on the audit-passed accounting database table fluxmerg;
the traffic data query module 106 is configured to query traffic data by querying conditions including node location, query date, device name, port name, customer name, and circuit name.
It should be noted that while several modules of the billing circuit flow collection assurance and auditing apparatus are mentioned in the above detailed description, this division is merely exemplary and not mandatory. Indeed, the features and functions of two or more modules described above may be embodied in one module in accordance with embodiments of the present invention. Conversely, the features and functions of one module described above may be further divided into a plurality of modules to be embodied.
Based on the foregoing inventive concept, as shown in fig. 5, the present invention further provides a computer device 200, including a memory 210, a processor 220, and a computer program 230 stored in the memory 210 and capable of running on the processor 220, where the processor 220 implements the foregoing charging circuit flow collection guarantee and auditing method when executing the computer program 230.
Based on the foregoing inventive concept, the present invention further provides a computer readable storage medium, where the computer readable storage medium stores a computer program for executing the foregoing charging circuit flow collection guarantee and auditing method.
The charging circuit flow acquisition guaranteeing and auditing method and device provided by the invention adopt a redundant acquisition means to guarantee the integrity of data acquisition; data processing is carried out on a circuit with abnormal flow, so that the accuracy and the integrity of the data are improved; through two-stage auditing of the charging circuit data, the final account-out data is ensured to be repeatedly checked and confirmed; because the integrity, accuracy and reliability of the account data are strictly ensured, the trust of the user is enhanced.
While the spirit and principles of the present invention have been described with reference to several particular embodiments, it is to be understood that the invention is not limited to the disclosed embodiments nor does it imply that features of the various aspects are not useful in combination, nor are they useful in any combination, such as for convenience of description. The invention is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.
It should be apparent to those skilled in the art that various modifications or variations can be made in the present invention without requiring any inventive effort by those skilled in the art based on the technical solutions of the present invention.
Claims (10)
1. The method for collecting, guaranteeing and auditing the flow of the charging circuit is characterized by comprising the following steps:
a main acquisition module and a backup acquisition module are deployed on different servers, and redundant acquisition is carried out on flow data of a charging circuit; the main acquisition module acquires the flow data into a flux library table, and the backup acquisition module acquires the flow data into the flux library table;
the flow data in the flux library table are synchronized to the flux database table in a timing mode;
processing the abnormal flow data by combining the main flow data and the standby flow data, and correcting a billing database table fluxmerge;
auditing by two-stage staff in the city and province aiming at the corrected flow data;
and outputting a charging circuit flow data month report based on the checked and approved accounting database table fluxmerge.
2. The method for guaranteeing and auditing traffic collection for a charging circuit according to claim 1, further comprising:
the streaming data is queried by query conditions including node location, query date, device name, port name, customer name, and circuit name.
3. The method for collecting, guaranteeing and auditing flow of charging circuit according to claim 1, wherein the daily flow data to be audited is generated based on a flux library table, and the flow data status is divided into three types:
there is 0 flow, i.e. the flow inflow or outflow speed is 0 in any period;
the flow is complete, namely the speed of inflow or outflow of the flow is not 0 in any period;
the current day is the absence of flow, i.e. no flow is collected during the current day.
4. The method for guaranteeing and auditing flow collection of charging circuits according to claim 1, wherein auditing the corrected flow data is performed by two-stage staff in the city and province, comprising:
the charging circuit flow data under the provincial center node is directly checked and passed by the provincial company personnel;
after the level 2 auditing of the charging circuit flow data under the local city node is passed through the corporate staff auditing and the provincial staff auditing, the final auditing is passed, or the provincial staff directly passes the final auditing;
after the final auditing is passed, the auditing state and auditing time are not changed any more;
before or after the final audit is passed, the audit opinion of the user is allowed to be added and is reserved as a historical audit opinion.
5. The utility model provides a charging circuit flow collection guarantee and audit device which characterized in that, this device includes:
the flow data redundancy acquisition module is used for deploying a main acquisition module and a backup acquisition module on different servers and carrying out redundancy acquisition on flow data of the charging circuit; the main acquisition module acquires the flow data into a flux library table, and the backup acquisition module acquires the flow data into the flux library table;
the main data synchronization module is used for synchronizing the flow data in the flux database table to the flux database table at regular time;
the flow data processing module is used for processing the abnormal flow data by combining the main flow data and the standby flow data and correcting the accounting database table fluxmerge;
the flow data auditing module is used for auditing the corrected flow data by two-stage personnel in the city and province;
and the monthly statement statistical module is used for outputting the monthly statement of the flow data of the charging circuit based on the accounting database table fluxmerg after the auditing is passed.
6. The billing circuit traffic collection assurance and auditing apparatus of claim 5, further comprising:
and the flow data query module is used for querying the flow data through query conditions including node positions, query dates, device names, port names, client names and circuit names.
7. The method for guaranteeing and auditing flow collection of charging circuits according to claim 5, wherein the daily flow data to be audited is generated based on a flux library table, and the flow data status is divided into three types:
there is 0 flow, i.e. the flow inflow or outflow speed is 0 in any period;
the flow is complete, namely the speed of inflow or outflow of the flow is not 0 in any period;
the current day is the absence of flow, i.e. no flow is collected during the current day.
8. The method for guaranteeing and auditing traffic collection of charging circuit according to claim 5, wherein the traffic data auditing module is specifically configured to:
the charging circuit flow data under the provincial center node is directly checked and passed by the provincial company personnel;
after the level 2 auditing of the charging circuit flow data under the local city node is passed through the corporate staff auditing and the provincial staff auditing, the final auditing is passed, or the provincial staff directly passes the final auditing;
after the final auditing is passed, the auditing state and auditing time are not changed any more;
before or after the final audit is passed, the audit opinion of the user is allowed to be added and is reserved as a historical audit opinion.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1-4 when executing the computer program.
10. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for executing the method of any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011268747.7A CN112270495B (en) | 2020-11-13 | 2020-11-13 | Charging circuit flow acquisition guarantee and auditing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011268747.7A CN112270495B (en) | 2020-11-13 | 2020-11-13 | Charging circuit flow acquisition guarantee and auditing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112270495A CN112270495A (en) | 2021-01-26 |
| CN112270495B true CN112270495B (en) | 2023-05-02 |
Family
ID=74340732
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011268747.7A Active CN112270495B (en) | 2020-11-13 | 2020-11-13 | Charging circuit flow acquisition guarantee and auditing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112270495B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101364240A (en) * | 2008-10-14 | 2009-02-11 | 杭州华三通信技术有限公司 | Metadata management method and device |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN107819591A (en) * | 2017-10-25 | 2018-03-20 | 新华三技术有限公司 | Method of data synchronization, device, system and the network equipment |
| CN108764683A (en) * | 2018-05-21 | 2018-11-06 | 贵州电网有限责任公司 | Operation of power networks data analysis assessment and reporting system |
| CN108933873A (en) * | 2018-06-08 | 2018-12-04 | 新华三技术有限公司 | A kind of synchronous method and device of user data |
| CN111262711A (en) * | 2018-11-30 | 2020-06-09 | 武汉新软科技有限公司 | Internet data center charging statistics management system |
-
2020
- 2020-11-13 CN CN202011268747.7A patent/CN112270495B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101364240A (en) * | 2008-10-14 | 2009-02-11 | 杭州华三通信技术有限公司 | Metadata management method and device |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN107819591A (en) * | 2017-10-25 | 2018-03-20 | 新华三技术有限公司 | Method of data synchronization, device, system and the network equipment |
| CN108764683A (en) * | 2018-05-21 | 2018-11-06 | 贵州电网有限责任公司 | Operation of power networks data analysis assessment and reporting system |
| CN108933873A (en) * | 2018-06-08 | 2018-12-04 | 新华三技术有限公司 | A kind of synchronous method and device of user data |
| CN111262711A (en) * | 2018-11-30 | 2020-06-09 | 武汉新软科技有限公司 | Internet data center charging statistics management system |
Non-Patent Citations (1)
| Title |
|---|
| "电能数据采集终端冗余备份方案的研究";万剑等;《华北电力技术》;20081025;第14-15页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112270495A (en) | 2021-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10346394B2 (en) | Importation, presentation, and persistent storage of data | |
| CA2701046C (en) | Analysis of a system for matching data records | |
| US7302433B2 (en) | Method and apparatus for updating rules and transmitting change notifications | |
| US11636092B2 (en) | General, flexible, resilent ticketing interface between a device management system and ticketing systems | |
| CN105989059B (en) | Data record checking method and device | |
| US7835921B1 (en) | Patient credit balance account analysis, overpayment reporting and recovery tools | |
| US20150074103A1 (en) | Metadata-driven audit reporting system with dynamically created display names | |
| CN109682436B (en) | Method for additionally reading meter reading data of gas meter of Internet of things | |
| WO2003009108A2 (en) | Method and apparatus for management of court schedules | |
| CA3177218C (en) | Data processing method, device, computer equipment, and storage medium | |
| AU2013201034A1 (en) | System for analyzing security compliance requirements | |
| CN112926858A (en) | Power marketing service operation index design method and device | |
| CN106779961A (en) | Sales information statistical method | |
| JP5090193B2 (en) | System, method, and program for synchronizing multi-source spread data | |
| US11928100B2 (en) | Method and system for creating a unified data repository | |
| CN112270495B (en) | Charging circuit flow acquisition guarantee and auditing method and device | |
| US10679163B2 (en) | Workflow management | |
| Boehr et al. | Preparing for the future: National Library of Medicine's® project to add MeSH® RDF URIs to its bibliographic and authority records | |
| CN115455106B (en) | Power distribution monitoring method, service platform, equipment and storage medium for power distribution operation and maintenance | |
| US7653587B2 (en) | Automated account statement generation process | |
| EP4348441A1 (en) | Systems and methods for ensuring quality of search system data | |
| CN112231325A (en) | Data mapping method and system for offline and online equipment | |
| US12039614B2 (en) | Generic configuration platform for generating electronic reports | |
| US7533053B2 (en) | Method and apparatus for accommodating quality review in an automated account statement generation process | |
| US11908023B1 (en) | Method and system for generating user interfaces to prompt users to perform an activity in a software application based on transaction time analysis |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder |
Address after: 200000 room 702-2, No. 4811 Cao'an Road, Jiading District, Shanghai Patentee after: CHINA UNITECHS Address before: Room 1004-4, 10 / F, 1112 Hanggui Road, Anting Town, Jiading District, Shanghai Patentee before: CHINA UNITECHS |
|
| CP02 | Change in the address of a patent holder |