CN111767293A - Method and device for automatically extracting and refreshing script - Google Patents

Method and device for automatically extracting and refreshing script Download PDF

Info

Publication number
CN111767293A
CN111767293A CN202010587520.2A CN202010587520A CN111767293A CN 111767293 A CN111767293 A CN 111767293A CN 202010587520 A CN202010587520 A CN 202010587520A CN 111767293 A CN111767293 A CN 111767293A
Authority
CN
China
Prior art keywords
account
script
refresh
payment
refreshing
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
Application number
CN202010587520.2A
Other languages
Chinese (zh)
Inventor
杜超
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Si Tech Information Technology Co Ltd
Original Assignee
Beijing Si Tech Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Si Tech Information Technology Co Ltd filed Critical Beijing Si Tech Information Technology Co Ltd
Priority to CN202010587520.2A priority Critical patent/CN111767293A/en
Publication of CN111767293A publication Critical patent/CN111767293A/en
Pending legal-status Critical Current

Links

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/23—Updating
    • G06F16/235—Update request formulation
    • 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/242—Query formulation
    • G06F16/2433—Query languages
    • G06F16/2445—Data retrieval commands; View definitions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
    • G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
    • G06F9/45508—Runtime interpretation or emulation, e g. emulator loops, bytecode interpretation
    • G06F9/45512—Command shells
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12—Accounting
    • G06Q40/125—Finance or payroll

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • General Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Mathematical Physics (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Computational Linguistics (AREA)
  • Technology Law (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Development Economics (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention provides a method and a device for automatically extracting a refresh script, which comprise the following steps: obtaining a problem reason of data needing to be refreshed, and compiling a refreshing script corresponding to the problem reason to obtain a refreshing script set; receiving account difference data; analyzing the difference data of the account, and determining at least one problem reason corresponding to the account; according to the problem reason corresponding to the account, extracting a refresh script corresponding to the account from the refresh script set as a target refresh script; and executing a target refreshing script corresponding to the account, and refreshing the difference data of the account. Repeated manual labor is avoided for compiling the refreshing script, and the working efficiency of developers is improved.

Description

Method and device for automatically extracting and refreshing script
Technical Field
The invention relates to the field of software development, in particular to a method and a device for automatically extracting a refresh script.
Background
The BOSS system has three times of simulated expenditure and one time of formal expenditure each month, the financial reports can also have three times of simulated expenditure and formal expenditure, partial difference data can exist after each time of expenditure, the partial difference data can be caused by abnormal operation of a related table due to on-line demand, the partial difference data can also be data generated by simulation test, particularly problem data such as cross-time point payment and the like exist after the formal expenditure, and a refreshing script is manually written according to an account after the difference data needs to be analyzed each time, so that time and labor are wasted.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and an apparatus for automatically extracting a refresh script, so as to solve technical defects in the prior art.
The embodiment of the invention discloses a method for automatically extracting a refresh script, which comprises the following steps:
obtaining a problem reason of data needing to be refreshed, and compiling a refreshing script corresponding to the problem reason to obtain a refreshing script set;
receiving account difference data;
analyzing the difference data of the account, and determining at least one problem reason corresponding to the account;
according to the problem reason corresponding to the account, extracting a refresh script corresponding to the account from the refresh script set as a target refresh script;
and executing a target refreshing script corresponding to the account, and refreshing the difference data of the account.
Further, the problem causes comprise cross-time point payment, bad account payment and wrong bill classes;
writing a refresh script corresponding to the problem reason to obtain a refresh script set, including:
and compiling a first refreshing script, a second refreshing script and a third refreshing script which respectively correspond to the cross-time point payment, the bad account payment and the wrong order type to obtain a refreshing script set.
Further, analyzing the difference data of the account, and determining at least one problem reason corresponding to the account includes:
under the condition that the same payment record of the current month and the payment record of the next month in the difference data of the account are not in the same payment cycle, determining that the problem reason corresponding to the account is payment at a cross-time point;
under the condition that the cost returned by marketing credit participates in the account cancellation in the difference data of the account, determining that the problem reason corresponding to the account is bad account payment;
and determining that the problem reason corresponding to the account is the wrong bill type when the error type in the difference data of the account is insufficient.
Further, the first refresh script includes:
the same payment is respectively extracted in batch from the payment record of the current month and the payment record of the next month by correlating the payment record of the current month and the payment record of the next month, and the same payment in the payment record of the next month is moved into the payment record of the current month, so that the same payment is in the same accounting period table;
the second refresh script includes:
associating the payment record, the collection and payment record and the account book of the account, and clearing the residual amount of the bad account;
the third refresh script includes:
and associating the payment record, the expense work order and the account book of the account, and updating the refund amount in the expense work order into the amount available in the account book.
The invention also provides a device for automatically extracting the refresh script, which comprises:
the problem reason acquisition module is configured to acquire a problem reason of data needing to be refreshed, and compile a refresh script corresponding to the problem reason to acquire a refresh script set;
a data receiving module configured to receive difference data of an account;
the problem reason determining module is configured to analyze the difference data of the account and determine at least one problem reason corresponding to the account;
the extracting module is configured to extract the refreshing script corresponding to the account in the refreshing script set as a target refreshing script according to the problem reason corresponding to the account;
and the refreshing module is configured to execute a target refreshing script corresponding to the account and refresh the difference data of the account.
The invention provides a method and a device for automatically extracting a refresh script, and the method for automatically extracting the refresh script comprises the steps of firstly obtaining a problem reason of data to be refreshed, compiling the refresh script corresponding to the problem reason to obtain a refresh script set, namely, analyzing and combing the refresh script corresponding to the problem reason, analyzing difference data of an account, and determining at least one problem reason corresponding to the account; and then according to the problem reason corresponding to the account, extracting a refresh script corresponding to the account in the refresh script set as a target refresh script, and finally executing the target refresh script corresponding to the account to refresh the difference data of the account so as to reduce the manual writing of the refresh script for each difference account. Repeated manual labor is avoided for compiling the refreshing script, and the working efficiency of developers is improved.
Drawings
FIG. 1 is a flow chart illustrating a method for automatically extracting a refresh script according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an apparatus for automatically extracting a refresh script according to the present invention.
Detailed Description
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein, but rather construed as limited to the embodiments set forth herein.
The terminology used in the description of the one or more embodiments is for the purpose of describing the particular embodiments only and is not intended to be limiting of the description of the one or more embodiments. As used in one or more embodiments of the present specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used in one or more embodiments of the present specification refers to and encompasses any and all possible combinations of one or more of the associated listed items.
It will be understood that, although the terms first, second, etc. may be used herein in one or more embodiments to describe various information, these information should not be limited by these terms. These terms are only used to distinguish one type of information from another. For example, a first can also be referred to as a second and, similarly, a second can also be referred to as a first without departing from the scope of one or more embodiments of the present description. The word "if" as used herein may be interpreted as "at … …" or "when … …" or "in response to a determination", depending on the context.
The invention provides a method and a device for automatically extracting a refresh script, and the invention is described in detail with reference to fig. 1.
FIG. 1 shows a schematic flow chart of a method of automatically extracting a refresh script according to an embodiment of the present invention, including steps 102 to 110.
Step 102: and obtaining the problem reason of the data needing to be refreshed, and writing a refreshing script corresponding to the problem reason to obtain a refreshing script set.
The problem causes include cross-time point payment, bad bill payment and wrong bill classes. And compiling a first refreshing script, a second refreshing script and a third refreshing script which respectively correspond to the cross-time point payment, the bad account payment and the wrong order type to obtain a refreshing script set.
Step 104: differential data for the account is received.
The difference data of the account is the data of error reporting of the system. The refreshing script is a script capable of refreshing the difference data corresponding to the modified account.
Step 106: and analyzing the difference data of the account, and determining at least one problem reason corresponding to the account.
Step 108: and according to the problem reason corresponding to the account, extracting the refresh script corresponding to the account from the refresh script set as a target refresh script.
Step 110: and executing a target refreshing script corresponding to the account, and refreshing the difference data of the account.
The invention provides a method for automatically extracting a refresh script, which comprises the steps of firstly obtaining a problem reason of data to be refreshed, compiling the refresh script corresponding to the problem reason to obtain a refresh script set, namely, completing the refresh script corresponding to the problem reason after analysis and combing, analyzing difference data of an account, and determining at least one problem reason corresponding to the account; and then, according to the problem reason corresponding to the account, extracting a refresh script corresponding to the account in the refresh script set as a target refresh script, and finally, executing the target refresh script corresponding to the account to refresh the difference data of the account, thereby reducing the workload of manually writing the refresh script for each difference account. Repeated manual writing of the refreshing script is avoided, and the working efficiency of developers is improved.
The reason for the problem is the generation of the billing, bad bill billing and wrong bill category at a time point, which is described in detail below with reference to the examples.
The reason for the problem is that the payment occurs across time points: at the time of monthly payment, a user pays 200 yuan at 23:59:59 of the last day of the month, the record of the payment of 200 yuan is recorded in a payment record table of the month, the processing of the bill of charge of 200 yuan at the time needs a certain time through background process processing at 1: 00:01 of the next month, the background processing is completed at 1: 00:01 of the next month, the payment of 200 yuan is recorded in the payment record of the next month, namely the payment of 200 yuan is entered into a next month table, and the payment record of the month and the payment record of the next month are not in the same account table when the financial newspaper side audits.
Step 106 comprises: and under the condition that the payment record and the payment record of the same month in the difference data of the account are not in the same payment cycle, determining that the reason of the problem corresponding to the account is payment at a cross-time point.
The first refresh script includes: and by associating the payment record of the current month with the payment record of the next month, extracting the data of the same payment respectively appearing in the payment record of the current month and the payment record of the next month in batch, and transferring the same payment in the payment record of the next month into the payment record of the current month, so that the same payment is in the same accounting period table.
Specifically, the following is the code of the first refresh script, and it should be noted that the following code is only one specific implementation scheme that can be implemented.
Figure BDA0002554336520000061
The specific process of the problem reason caused by bad account payment is as follows: when the user pays 100 yuan of bad account fee in the business foreground, the bad account user takes 10 yuan of fee returned by marketing before the bad account user exists and participates in the account cancellation, and the bad account user pays 90 yuan of fee to pay 100 yuan of amount of the bad account to be cleared. However, when the account book of the bad-account user is checked at the financial and newspaper side, the remaining bad-account amount is 10 yuan, which causes the difference of the financial and newspaper side data corresponding to the account of the user.
Step 106 comprises: and under the condition that the cost returned by the marketing credit participates in the account sales in the difference data of the account, determining that the problem reason corresponding to the account is bad account payment.
The second refresh script includes: and associating the payment record, the collection and payment record and the account book of the account, and clearing the residual amount of the account.
Specifically, the following is the code of the second refresh script, and it should be noted that the following code is only one specific implementation.
Figure BDA0002554336520000071
Figure BDA0002554336520000081
Figure BDA0002554336520000091
The problem is that the wrong work order is caused, the expense work order is wrong in the daily maintenance process, the wrong type is insufficient balance, offline balance transfer is carried out through a CRM system (customer management system), the work order is a monthly order, the BOSS side collects user expense in the same month due to the fact that the CRM system and the BOSS side system are not synchronous, the balance is insufficient due to the fact that the CRM side user transfers the returned work order, and the expense work order is generated. Wherein, a BOSS (Business & Operation Support System, abbreviated as BOSS) refers to a service Operation Support System. The BOSS is divided into a billing and settlement system, a business and accounting system, a customer service system, and a decision support system.
Step 106 comprises: and determining that the problem reason corresponding to the account is the wrong bill type when the error type in the difference data of the account is insufficient.
That is, the BOSS system will report an error, and the error type of the error is insufficient balance.
The third refresh script includes: and associating the payment record, the expense work order and the account book, and updating the refund amount in the expense work order into the amount available in the account book.
Specifically, the following is the code of the third refresh script, and it should be noted that the following code is only one specific implementation scheme.
Figure BDA0002554336520000101
Figure BDA0002554336520000111
FIG. 2 is a block diagram of an apparatus for automatically extracting a refresh script according to an embodiment of the present specification, including:
the problem reason acquisition module 202 is configured to acquire a problem reason of data needing to be refreshed, and write a refresh script corresponding to the problem reason to acquire a refresh script set;
a data receiving module 204 configured to receive difference data of the account;
the problem reason determining module 206 is configured to analyze the difference data of the account and determine at least one problem reason corresponding to the account;
an extracting module 208, configured to extract, according to the problem reason corresponding to the account, a refresh script corresponding to the account in the refresh script set as a target refresh script;
and the refreshing module 210 is configured to execute a target refreshing script corresponding to the account to refresh the difference data of the account.
It should be noted that, for the sake of simplicity, the above-mentioned method embodiments are described as a series of acts or combinations, but those skilled in the art should understand that the present invention is not limited by the described order of acts, as some steps may be performed in other orders or simultaneously according to the present invention. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no acts or modules are necessarily required of the invention.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
The preferred embodiments of the invention disclosed above are intended to be illustrative only. Alternative embodiments are not exhaustive and do not limit the invention to the precise embodiments described. Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best utilize the invention. The invention is limited only by the claims and their full scope and equivalents.

Claims (5)

1. A method for automatically extracting a refresh script, comprising:
obtaining a problem reason of data needing to be refreshed, and compiling a refreshing script corresponding to the problem reason to obtain a refreshing script set;
receiving account difference data;
analyzing the difference data of the account, and determining at least one problem reason corresponding to the account;
according to the problem reason corresponding to the account, extracting a refresh script corresponding to the account from the refresh script set as a target refresh script;
and executing a target refreshing script corresponding to the account, and refreshing the difference data of the account.
2. The method of automatically extracting refresh scripts of claim 1, wherein the problem causes comprise cross-time point payment, bad-bill payment and wrong-order classes;
writing a refresh script corresponding to the problem reason to obtain a refresh script set, including:
and compiling a first refreshing script, a second refreshing script and a third refreshing script which respectively correspond to the cross-time point payment, the bad account payment and the wrong order type to obtain a refreshing script set.
3. The method for automatically extracting a refresh script according to claim 2, wherein analyzing the difference data of the account to determine at least one problem reason corresponding to the account comprises:
under the condition that the same payment record of the current month and the payment record of the next month in the difference data of the account are not in the same payment cycle, determining that the problem reason corresponding to the account is payment at a cross-time point;
under the condition that the cost returned by marketing credit participates in the account cancellation in the difference data of the account, determining that the problem reason corresponding to the account is bad account payment;
and determining that the problem reason corresponding to the account is the wrong bill type when the error type in the difference data of the account is insufficient.
4. The method of automatically extracting a refresh script of claim 3, wherein the first refresh script comprises:
the same payment is respectively extracted in batch from the payment record of the current month and the payment record of the next month by correlating the payment record of the current month and the payment record of the next month, and the same payment in the payment record of the next month is moved into the payment record of the current month, so that the same payment is in the same accounting period table;
the second refresh script includes:
associating the payment record, the collection and payment record and the account book of the account, and clearing the residual amount of the bad account;
the third refresh script includes:
and associating the payment record, the expense work order and the account book of the account, and updating the refund amount in the expense work order into the amount available in the account book.
5. An apparatus for automatically extracting a refresh script, comprising:
the problem reason acquisition module is configured to acquire a problem reason of data needing to be refreshed, and compile a refresh script corresponding to the problem reason to acquire a refresh script set;
a data receiving module configured to receive difference data of an account;
the problem reason determining module is configured to analyze the difference data of the account and determine at least one problem reason corresponding to the account;
the extracting module is configured to extract the refreshing script corresponding to the account in the refreshing script set as a target refreshing script according to the problem reason corresponding to the account;
and the refreshing module is configured to execute a target refreshing script corresponding to the account and refresh the difference data of the account.
CN202010587520.2A 2020-06-24 2020-06-24 Method and device for automatically extracting and refreshing script Pending CN111767293A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010587520.2A CN111767293A (en) 2020-06-24 2020-06-24 Method and device for automatically extracting and refreshing script

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010587520.2A CN111767293A (en) 2020-06-24 2020-06-24 Method and device for automatically extracting and refreshing script

Publications (1)

Publication Number Publication Date
CN111767293A true CN111767293A (en) 2020-10-13

Family

ID=72722359

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010587520.2A Pending CN111767293A (en) 2020-06-24 2020-06-24 Method and device for automatically extracting and refreshing script

Country Status (1)

Country Link
CN (1) CN111767293A (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109242332A (en) * 2018-09-25 2019-01-18 广东中标数据科技股份有限公司 A kind of monitoring analysis system of tax collection and administration data, method and device
CN109325865A (en) * 2018-08-13 2019-02-12 中国平安人寿保险股份有限公司 Abnormality eliminating method, device, computer equipment and storage medium
CN109741015A (en) * 2018-12-17 2019-05-10 广州华工信息软件有限公司 ETC consumption abnormality eliminating method, equipment, medium and system on highway

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109325865A (en) * 2018-08-13 2019-02-12 中国平安人寿保险股份有限公司 Abnormality eliminating method, device, computer equipment and storage medium
CN109242332A (en) * 2018-09-25 2019-01-18 广东中标数据科技股份有限公司 A kind of monitoring analysis system of tax collection and administration data, method and device
CN109741015A (en) * 2018-12-17 2019-05-10 广州华工信息软件有限公司 ETC consumption abnormality eliminating method, equipment, medium and system on highway

Similar Documents

Publication Publication Date Title
US6904411B2 (en) Multi-processing financial transaction processing system
CN110309975A (en) Project-developing process control method, device, equipment and computer storage medium
CN101221503A (en) Software testing method and device
US20170323391A1 (en) Processing apparatus having a reference identification tied to a locked entry
CN110827132A (en) Automatic reconciliation method for marketing account of power enterprise
CN110555758A (en) Enterprise finance and tax intelligent management system
CN110472961A (en) Business is deducted fees the execution method and device of operation
CN113643113A (en) Automatic electric charge auditing method, system, medium and electronic equipment
CN114328625A (en) Electric charge data rescreening method and system
CN109598631A (en) Human resource speciality client's bill generation method and generation system based on social security policy
CN114418714A (en) 5G base station operation and maintenance management system and method
CN110750302B (en) Assembly line account making method for accountant
CN117252719A (en) Financial accounting management system suitable for enterprise
CN111767293A (en) Method and device for automatically extracting and refreshing script
CN114969127B (en) Reconciliation method, reconciliation system and storage medium for automatically combining reconciliation transactions
CN112419052B (en) Transaction testing method, device, electronic equipment and readable storage medium
CN115470139A (en) Interface testing method and related equipment
CN105068978A (en) Method and system for automatically auditing daily statement and monthly statement based on database
CN115205000A (en) Account checking method, account checking terminal and account checking system
CN105787792A (en) Information processing method of loan transaction and information processing device
CN113159789A (en) Cross-bank transfer and remittance method and device
CN111274138A (en) Method and device for testing account merging function
CN113516542B (en) Day and month knot and year trial calculation method and system in intelligent property accounting
CN115964306A (en) Automatic testing method, device and equipment for target system
CN115796794A (en) Automatic account checking method and device based on RPA technology and terminal equipment

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