CN115080802A

CN115080802A - Running number processing method and device and computer equipment

Info

Publication number: CN115080802A
Application number: CN202210636436.4A
Authority: CN
Inventors: 姚卓宗
Original assignee: Kingdee Deeking Cloud Computing Co ltd
Current assignee: Kingdee Deeking Cloud Computing Co ltd
Priority date: 2022-06-07
Filing date: 2022-06-07
Publication date: 2022-09-20

Abstract

The application relates to a serial number processing method, a serial number processing device and computer equipment, which can be applied to an Enterprise Resource Planning (ERP) system. The method comprises the following steps: acquiring a broken number recovery request, wherein the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value; checking an initial point value according to the number break, and updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value; acquiring a serial number acquisition request, wherein the serial number acquisition request carries a document type and a serial basis item value; acquiring an encoding rule ID according to the type of the document, acquiring a current water level value according to the encoding rule ID and the running water basis item value, and determining a running water number according to the type of the document, the encoding rule ID, the running water basis item value and the current water level value. The labor cost is reduced, and the efficiency is greatly improved.

Description

Running water number processing method and device and computer equipment

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a serial number processing method, device, and computer equipment.

Background

In most business scenarios, especially in business of an Enterprise Resource Planning (ERP) system, serial numbers of business documents need to be kept continuous and sequential. However, the number is interrupted due to reasons such as deleting business documents or missing records. When a business document is deleted, a business code corresponding to the business document triggers a broken number recovery interface to store a serial number in a document code of the business document in a broken number table or a broken number cache, and when the business document is newly added next time, the serial number used as the serial number in a new document code is preferentially inquired from the broken number table or the broken number cache. However, a bug may exist in the service code corresponding to the service document, or the system runtime environment may cause the number break to be unable to be recovered normally.

In the prior art, for a business document allowing a user to edit and additionally record a document code, the user can manually additionally record and modify a serial number in the document code, thereby repairing a broken number and ensuring the serial number continuity of the business document; for the business documents which do not allow the user to edit and additionally record the document codes, the broken number table can be manually modified only by system technical support personnel at the background, so that the broken numbers which are not normally recycled are added into the broken number table, and the serial number continuity of the business documents is ensured. No matter which mode, all need great human cost, the processing procedure is loaded down with trivial details, efficiency is not high still makes mistakes once more easily.

Disclosure of Invention

In view of the above, it is desirable to provide a serial number processing method, apparatus, and computer device that can reduce labor costs.

In a first aspect, the present application provides a serial number processing method. The method comprises the following steps:

acquiring a broken number recovery request, wherein the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value; checking an initial point value according to the number break, and updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value; acquiring a serial number acquisition request, wherein the serial number acquisition request carries a document type and a serial basis item value; acquiring an encoding rule ID according to the type of the document, acquiring a current water level value according to the encoding rule ID and the running water basis item value, and determining a running water number according to the type of the document, the encoding rule ID, the running water basis item value and the current water level value.

In one embodiment, determining the running water number according to the document type, the encoding rule ID, the running water dependency item value and the current water level value comprises: inquiring the serial number increment step length according to the coding rule ID and the coding rule sub-table; acquiring a document business table corresponding to the document type according to the document type; m serial numbers corresponding to the serial flow basis item values are inquired in the document business table; storing N serial numbers which are larger than the current water level value in the M serial numbers into a set; and determining the running water number according to the current water level value, the running water number increasing step length and the set.

In one embodiment, determining the serial number according to the current water level value, the serial number increment step size and the set comprises: solving the sum of the current water level value and the incremental step length of the serial number to obtain a summation result, and judging whether the summation result is in a set; if the summation result is not in the set, taking the summation result as a serial number; if the summation result is in the set, the summation result is taken as the current water level value, and the process is repeated until the summation result is not in the set.

In one embodiment, before determining the water flow number according to the current water level value, the water flow number increment step size and the set, the method further comprises: inquiring K broken numbers which are smaller than the current water level value in the broken numbers corresponding to the coding rule ID and the pipelining basis item value in the broken number table; and updating the current water level value to be the minimum value of the K break marks.

In one embodiment, after determining the serial number according to the current water level value, the serial number increment step size and the set, the method further comprises: and updating the water level values corresponding to the coding rule ID and the running water item value in the running water number water level table into a running water number, and deleting the broken number which is larger than the running water number in the broken number corresponding to the coding rule ID and the running water item value in the broken number table.

In one embodiment, the updating process of the encoding rule ID in the running water number water level table and the water level value corresponding to the running water according to the entry value according to the number break check starting point value includes: judging whether the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value are larger than the break number check starting point value or not; if the value is larger than the threshold value, updating the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value into a number-off check starting point value.

In one embodiment, acquiring the number-breaking recycling request includes: after detecting the triggering operation of a user on the broken number recovery entry on the coding rule editing interface, determining whether to display a pipelining basis item editing entry according to coding rule information corresponding to the coding rule editing interface; if the fact that the running water foundation item editing entry is displayed is determined, displaying a broken number recycling setting interface comprising the running water foundation item editing entry; receiving a running water check starting point value input by a user through a broken number recovery setting interface according to the item value and the broken number, and acquiring an encoding rule ID from encoding rule information; and generating a broken number recovery request based on the stream according to the item value, the broken number check starting point value and the encoding rule ID.

In a second aspect, the present application provides an serial number processing apparatus comprising:

the broken number recovery module is used for acquiring a broken number recovery request, and the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value; the serial number recovery module is also used for checking the starting point value according to the serial number and updating the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value; the serial number acquisition module is used for acquiring a serial number acquisition request, and the serial number acquisition request carries a document type and a serial number basis item value; the running water number obtaining module is further used for obtaining an encoding rule ID according to the bill type, obtaining a current water level value according to the encoding rule ID and the running water basis item value, and determining the running water number according to the bill type, the encoding rule ID, the running water basis item value and the current water level value.

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the method as provided by the first aspect when executing the computer program.

In a fourth aspect, the present application further provides a computer-readable storage medium. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method provided by the first aspect.

In a fifth aspect, the present application further provides a computer program product. A computer program product comprising a computer program which, when executed by a processor, carries out the method provided by the first aspect.

The serial number processing method, the device and the computer equipment obtain the broken number recovery request, wherein the broken number recovery request carries the coding rule ID, the serial number item value and the broken number check starting point value; checking an initial point value according to the number break, and updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value; acquiring a serial number acquisition request, wherein the serial number acquisition request carries a document type and a serial basis item value; acquiring an encoding rule ID according to the type of the document, acquiring a current water level value according to the encoding rule ID and the running water basis item value, and determining a running water number according to the type of the document, the encoding rule ID, the running water basis item value and the current water level value. The labor cost is reduced, and the efficiency is greatly improved.

Drawings

FIG. 1 is a diagram of a database table structure design in one embodiment;

FIG. 2 is an exemplary diagram of a database table storing data in one embodiment;

FIG. 3 is a schematic diagram of a system in one embodiment;

FIG. 4 is a schematic flow chart showing a serial number processing method in one embodiment;

FIG. 5 is a schematic diagram of an interrupt recovery entry in one embodiment;

FIG. 6 is a diagram of an interrupt recovery settings interface in accordance with one embodiment;

FIG. 7 is a block diagram showing the construction of an serial number processing apparatus according to an embodiment;

FIG. 8 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

In some embodiments, when a service document is deleted, a service code corresponding to the service document triggers a number-breaking recovery interface to store a serial number in a document code of the service document in a number-breaking table or a number-breaking cache, and when the service document is newly added next time, the serial number used as a new document code is preferentially inquired from the number-breaking table or the number-breaking cache. However, since a service code corresponding to a service document may have a bug, when the service document is deleted, the service code may not trigger the disconnected number recovery interface, and also, due to a system runtime environment, such as a sudden power failure of a server or a restart of a service process, the disconnected number recovery interface may not work normally, both of the above two phenomena may cause that the disconnected number cannot be recovered normally. In order to solve the problems, for the business document allowing the user to edit and additionally record the document code, the user can manually additionally record and modify the serial number in the document code, thereby repairing the broken number and ensuring the serial number continuity of the business document; for the business documents which do not allow the user to edit and additionally record the document codes, the broken number table can be manually modified only by system technical support personnel at the background, so that the broken numbers which are not normally recycled are added into the broken number table, and the serial number continuity of the business documents is ensured. No matter which mode, all need great human cost, the processing procedure is loaded down with trivial details, efficiency is not high still makes mistakes once more easily.

To this end, an embodiment of the present application provides a serial number processing method, in a serial number recovery stage, obtaining a serial number recovery request, where the serial number recovery request carries an encoding rule ID, a serial number item value, and a serial number check start point value, and updating the encoding rule ID in a serial number water level table and a water level value corresponding to the serial number item value according to the serial number check start point value. In the number interruption obtaining stage, a serial number obtaining request is obtained, the serial number obtaining request carries a document type and a serial basis item value, a coding rule ID is obtained according to the document type, a current water level value is obtained according to the coding rule ID and the serial basis item value, and the serial number is determined according to the document type, the coding rule ID, the serial basis item value and the current water level value. The continuity and the sequency of serial numbers can be guaranteed, the labor cost is reduced, and the efficiency is greatly improved. See below for detailed procedures.

For convenience of understanding, the following description is provided for the terms related to the embodiments of the present application:

document serial number: integer numbers of fixed length with complementary bits that are incremented by the specified initial value in pipelining terms of values and specified increment steps, hereinafter referred to as pipelining numbers.

And (3) document serial number interruption: in all the business documents of a certain document type stored by the system, the difference value between two adjacent serial numbers with the same serial number item value is not equal to the incremental step length, so that a document serial number break exists between the two adjacent serial numbers, which is hereinafter referred to as a break number. For example, only serial numbers 001, 002 and 005 are in the document business table corresponding to the purchase orders already stored by the system, and if the increment step is 1 and the difference between 2 and 5 is not equal to the increment step 1, it indicates that there is an open number in the middle (003 and 004).

The flow criterion item: and a classification record basis for serial numbers under the same document type. The system records the maximum value of the broken number and the used serial number according to the item values of the serial number. The chronological item may be a date or a code of the basic material, wherein the code of the basic material may be, for example, a customer code or a supplier code, etc. For example, assuming that the date is the chronological item, the maximum value of the serial number used on days 2021-12-01 is 6, the document code by days 2021-12-02 is to be acquired and recorded again starting from serial number 1, rather than starting from 7.

The water level value of the flowing water is as follows: each flow depends on the maximum value of the number of flows used under the term value.

Document coding: a set of strings for a document is identified. The document encoding may be user-defined, a document encoding comprising at least one segment, the at least one segment possibly comprising: fixed string constants, dates, base data codes or names, serial numbers, etc.

And (3) encoding rules: a document code generation rule which can be set by a user determines whether a document code contains segments of fixed character string constants, dates, codes or names of basic data, serial numbers and the like, and determines the sequence among the segments, separators among the segments, the length of the serial numbers, complement characters of the serial numbers, incremental steps of the serial numbers, whether serial basis items exist and the like.

And (3) broken number recovery: and the broken number caused by deleting the business document or missing the business document and the like can still be preferentially obtained and used according to the sequence when the document is newly added next time, and the processing process is broken number recovery.

Encoding rule main table: the background database table structure design is shown in fig. 1, and mainly relates to 4 tables, which are respectively: the system comprises a coding rule main table, a coding rule sub table, a serial number water level table and a number interruption table. The encoding rule master table is used for storing encoding rule IDs corresponding to various bill types, and the core field of the encoding rule master table comprises: encoding rule ID (integer type, primary key), document type (character string type, document type corresponding to record), segment number (integer type, record how many segments the document code has), and segment separator (character string type, record separator between each segment of the document code).

Encoding rule sub-table: the system is used for storing the segment information corresponding to each encoding rule ID, one line of data corresponds to one segment in the document encoding, and the one line of data is in a many-to-one relation with the encoding rule main table; the core fields of the coding rule sub-table include: encoding rule ID (integer type, outer key, corresponding to encoding rule ID field in encoding rule main table), segment sequence number (integer type, recording position of segment corresponding to this row data in document encoding), segment type (enumeration type, recording type of segment corresponding to this row data, such as constant, date, basic data or serial number), whether running data item (integer type, 1 indicates that segment corresponding to this row data is running data item, 0 is not), basic data reference object (character string type, if segment type field value of segment corresponding to this row data is "basic data", recording which basic data is referred, otherwise, value is null string), constant value (character string type, if segment type field value of segment corresponding to this row data is "constant", there is value, otherwise, value is null string), serial number bit supplement character (character string type, when the serial number is not the maximum serial number length, the padding character is used for carrying out left padding, the serial number increment step length (an integer type, a value of each increment of the serial number is recorded), and the serial number initial value (an integer type, corresponding to the initial value of the serial number acquired for the first time under the serial number item value).

Water level gauge of serial number: the maximum value (namely, the water level value) of the used water level number corresponding to each flow rate basis item value below the coding rule is stored, the maximum value and the water level value are in a many-to-one relationship with the main coding rule table, and the core field of the water level table of the water level number comprises: the method comprises the steps of encoding rule ID (integer type, external key, encoding rule ID field corresponding to an encoding rule main table), pipelining basis item (character string type, pipelining basis item value corresponding to recorded water level value), and water level value (integer type, maximum pipelining number used under the corresponding pipelining basis item value in all business documents is recorded).

And (4) number-off table: the system is used for storing the break number which is corresponding to each flow line item value under the coding rule and is normally recovered by the break number recovery interface, and the break number and the coding rule main table are in a many-to-one relationship; the core fields of the outage table include: coding rule ID (integer type, foreign key, coding rule ID field corresponding to coding rule main table), pipelining base item and break number value.

When a user wants to set the coding rule of a document code of a certain document type, the user can input the document type on a coding rule editing interface provided by a terminal and set the values of all fields related in the rule code main table and the rule code sub table, and the terminal can send the values set by the user to a server, so that the server can generate the 4 tables. Illustratively, FIG. 2 shows a schematic diagram of a rule code main table and a rule code sub table of a purchase order generated by a server based on values set by a user, and a number break table and a serial number water level table generated based on all of the purchase order, the rule code main table and the rule code sub table. As can be seen from the rule code main table and the rule code sub table in fig. 2, the document code of the purchase order includes 3 segments, which are respectively a constant (value "CGDD"), a date (pipelining basis item), a serial number (complement symbol is 0, increment step is 1, length is 3, initial value is 1), and separators between the segments are "-". As shown in FIG. 2, the table for recording all purchase orders is called the purchase order master table, and the purchase order master table records the document date, the document code, the flow dependence item and the flow number. From the purchase order master table, it can be seen that the maximum values of the running water numbers used for 2021-12-01 and 2021-12-02 for two days are 6 and 5 respectively, so that the running water number water level table has two corresponding records; 2021-12-01 produces two

break numbers

3 and 5, 2021-12-02 produces 1 break number 2; the broken number which is only two service codes in the broken number table trigger the broken number recycling interface to recycle normally is 5 of 2021-12-01 and 2 of 2021-12-02 respectively, which shows that the broken number 3 of 2021-12-01 day is not recycled normally.

The serial number processing method provided by the embodiment of the application can be applied to the system shown in fig. 3. The system shown in fig. 3 includes a terminal and a server. The terminal can be any device configured with an interactive screen, such as a personal computer, a notebook computer, a smart phone, a tablet computer, an internet of things device and a portable wearable device, and the internet of things device can be an intelligent sound box, an intelligent television, an intelligent air conditioner, an intelligent vehicle-mounted device and the like. The portable wearable device may be a smart watch, smart bracelet, head mounted device, etc., illustrated in fig. 3 using a personal computer. The server may be implemented as a stand-alone server or a server cluster composed of a plurality of servers, which is illustrated in fig. 3 by a stand-alone server.

The embodiment of the application can be applied to an Enterprise Resource Planning (ERP) system to perform serial number processing on business documents in the ERP system, wherein the ERP system includes but is not limited to a production and manufacturing management system, a supply chain system, a personnel system, a financial system, a tax system and an auditing system.

The following describes the implementation of the water number processing method in detail with reference to specific embodiments.

In one embodiment, a serial number processing method is provided, as shown in fig. 4, the method comprising the steps of:

s402, acquiring a broken number recovery request, wherein the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value.

In some embodiments, the terminal may provide a coding rule editing interface, the coding rule editing interface is not only provided with an entry for editing a coding rule, but also provided with a broken number recovery entry, and a user may trigger the broken number recovery process of the embodiment of the present application by triggering the broken number recovery entry. The implementation manner of the various related entries is not limited in the embodiment of the present application, and for example, the various related entries may be implemented in a control form, that is, the broken number recycling entry may be a broken number recycling control, and so on. It should be noted that: aiming at the condition that multiple document types exist in an Enterprise Resource Planning (ERP) system, broken number recycling entries corresponding to the multiple document types can be displayed in a coding rule editing interface, and a user can trigger according to requirements.

In some embodiments, after detecting that a user triggers an interrupt recovery entry in a coding rule editing interface, the terminal determines whether to display a pipeline criterion item editing entry according to coding rule information corresponding to the coding rule editing interface; and if the running water basis item editing entry is determined to be displayed, displaying a broken number recycling setting interface comprising the running water basis item editing entry.

Specifically, after detecting the triggering operation of the user on the broken number recovery entry, the coding rule editing interface transmits the coding rule information corresponding to the coding rule editing interface to the broken number recovery setting interface, where the coding rule information includes a coding rule ID and a running number segment setting information, and if the user sets a running basis item, the running basis item type and the running basis item format need to be set, and in this case, the coding rule information further includes the running basis item type and the running basis item format. After receiving the coding rule information, the number-break recycling setting interface may determine whether to display the pipelining basis item editing entry according to the coding rule information, specifically, determine whether to display the pipelining basis item editing entry according to whether the coding rule information includes a pipelining basis item type and a pipelining basis item format, determine to display the pipelining basis item editing entry if the pipelining basis item type and the pipelining basis item format are included, and determine not to display the pipelining basis item editing entry if the pipelining basis item type and the pipelining basis item format are not included. Further, if it is determined that the pipelined entry is displayed according to the item edit rule, the corresponding edit entry is added to the number-break recovery setting interface according to the encoding rule information, specifically, the entries corresponding to the pipelined entry type and the pipelined entry format may be added to the number-break recovery setting interface, for example: if the pipeline is date according to the item type, adding a date entry to the broken number recycling setting interface, if the pipeline is basic data according to the item type, adding a basic data selection entry to the broken number recycling setting interface, and finally displaying the broken number recycling setting interface comprising a pipeline editing entry according to the item.

Alternatively, the break recovery entry may be configured in the form shown in FIG. 5.

In some embodiments, the terminal receives a running water basis item value and a broken number check starting point value input by a user through a broken number recycling setting interface, and acquires an encoding rule ID from encoding rule information; and generating a broken number recovery request based on the stream according to the item value, the broken number check starting point value and the encoding rule ID.

Optionally, the user may input the running water check start point value according to the actual situation, if the running water check start point value is a date according to the item type, the running water check start point value is input through the date entry, that is, a date value, and if the running water check start point value is a basic data according to the item type, the running water check start point value is selected through the basic data selection entry, that is, a specific basic data encoding data, such as a user code, according to the basic data selection entry.

Optionally, after the terminal detects that the user triggers the broken number recycling entry, the broken number table stored in the server can be called out to display, so that the user can inquire which broken numbers which are not normally recycled under the condition of the entry value of the stream to be input in the broken number table, the smallest broken number in the broken numbers is taken out, and when the input stream checks the starting point value according to the entry value and the broken number, the input starting point value of the broken number check is ensured to be smaller than the smallest broken number in the broken numbers which are not normally recycled.

Alternatively, the break recovery setting interface may be configured in the form shown in fig. 6.

Taking fig. 2 as an example, 2021-12-01 generates the broken number 3 which is not normally recycled, because the pipeline is date according to the item type and the format is yyy-mm-dd, the pipeline is input 2021-12-01 according to the item value, and the broken number check starting point is input with a value smaller than the broken number 3, such as 1 or 2, which is exemplified by input 1 in the embodiment of the present application.

S404, checking the starting point value according to the break number, and updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number according to the item value.

Optionally, it may be determined whether the encoding rule ID in the serial number water level table and the water level value corresponding to the serial number entry value are greater than the break number check start point value; if the current water level value is greater than the preset water level value, updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value into a broken number check starting point value, wherein the current water level value is the broken number check starting point value; if the water level value is less than or equal to the water level value, updating the water level value in the serial number water level table, wherein the current water level value is still the original water level value.

The following examples illustrate:

assuming that the coding rule ID carried by the outage request is 1, the entry value of the pipelining basis is 2021-12-01, and the outage check starting point value is 1, the coding rule ID is 1 according to the pipelining water level table illustrated in fig. 2, and the corresponding water level value of the pipelining basis under the entry value of 2021-12-01 is 6, and 6 is greater than 1, the coding rule ID is 1 in the pipelining water level table, and the corresponding water level value of the pipelining basis under the entry value of 2021-12-01 is updated to 1.

Optionally, after the server executes S404, the server may return a processing result status to the terminal, where the processing result status is used to indicate that the processing is successful or failed. If the processing result state indicates that the processing is successful, prompt information can be displayed on the interface, and the user can close the broken number recycling setting interface after seeing the prompt information.

S406, acquiring a serial number acquisition request, wherein the serial number acquisition request carries the document type and the serial number basis item value.

In some embodiments, after detecting a triggering operation of a user on a newly added service document entry, a terminal sends a serial number acquisition request to a server, where the serial number acquisition request carries a document type and a serial number basis item value.

Optionally, when a user wants to add a new service document of a certain document type, the new service document entry may be triggered on a page related to the document type.

Optionally, the user may input the value of the running rule on the same page before triggering the newly added service document entry, and may also input the value of the running rule on the page before triggering the newly added service document entry on the relevant page of the purchase order. The running water item value is the same as the running water item value input in the broken number recycling setting interface.

And S408, acquiring an encoding rule ID corresponding to the bill type according to the bill type.

Optionally, according to the type of the document, the encoding rule ID corresponding to the type of the document may be queried in the encoding rule master table, as illustrated in fig. 1 and fig. 2. The encoding rule master table is used for indicating the corresponding relation between the bill type and the encoding rule ID.

The following examples illustrate:

assuming that the type of the document carried by the serial number acquisition request is a purchase order, according to the encoding rule master table illustrated in fig. 2, it can be queried that the encoding rule ID corresponding to the purchase order is 1.

S4010, obtaining the current water level value according to the coding rule ID and the running water basis item value.

Optionally, according to the encoding rule ID and the running water item value, the water level value corresponding to the encoding rule ID and the running water item value may be queried in the running water number water level table, and the queried water level value is used as the current water level value.

The following examples illustrate:

assuming that the type of the document carried by the serial number acquisition request is a purchase order, the item value of the serial number is 2021-12-01, and according to the main encoding rule table illustrated in fig. 2, it can be queried that the ID of the encoding rule corresponding to the purchase order is 1. Since the encoding rule ID is 1 in S408, the corresponding water level value of the running water according to the entry value 2021-12-01 is updated to 1, and the water level value found by the query is 1.

S4012, determining the running water number according to the bill type, the coding rule ID, the running water basis item value and the current water level value.

Optionally, according to the coding rule ID and the coding rule sub-table, the serial number increment step length may be queried; acquiring a document business table corresponding to the document type according to the document type; m serial numbers corresponding to the serial flow basis item values are inquired in the document business table; storing N serial numbers which are larger than the current water level value in the M serial numbers into a set; inquiring K broken numbers smaller than the current water level value in the broken numbers corresponding to the coding rule ID and the pipelining basis item value in the broken number table; and updating the current water level value to be the minimum value of the K break marks. And then determining the serial number according to the current water level value, the serial number increment step length and the set.

Optionally, when determining the serial number according to the current water level value, the serial number increment step size, and the set, the following method may be adopted: solving the sum of the current water level value and the incremental step length of the running water number to obtain a summation result, and judging whether the summation result is in the set or not; if the summation result is not in the set, taking the summation result as a serial number; if the summation result is in the set, the above process is repeated by taking the summation result as the current water level value until the summation result is not in the set.

The following examples illustrate:

assuming that the type of the document carried by the serial number acquisition request is a purchase order, the item value of the serial number is 2021-12-01, and according to the main encoding rule table illustrated in fig. 2, it can be queried that the ID of the encoding rule corresponding to the purchase order is 1. Suppose that the document business table corresponding to the purchase order is the main table of the purchase order in fig. 2, and the current water level value is 1. Referring to fig. 2, based on the encoding rule ID, the serial number increment step size is 1, which can be looked up from the encoding rule sub-table, and the serial number of 2021-12-01 has 1, 2, 4, 6, where the serial numbers greater than 1 are 2, 4, 6, storing 2, 4, 6 into a set, the set is {2, 4, 6}, the coding rule ID in the break table is 1, the break corresponding to the condition of the running water entry value 2021-12-01 is 5, since 5 is greater than 1, there is no need to update the current water level value, i.e. the current water level value is still 1, executing m-m + s, where m is the current water level value and s is the increment step, checking whether m exists in the set, and if so, if m is not present, m at this time is returned to the terminal as the final serial number. Since m is 1, s is 1, the first execution of m + s results in m 2, since 2 belongs to the set, the execution of m + s continues to result in m 3, and since 3 does not belong to the set, 3 is returned to the terminal as the final serial number.

Optionally, after the final serial number is determined, the water level values corresponding to the coding rule ID and the serial number item value in the serial number water level table may be updated to the serial number determined in S408, and the break number greater than the serial number determined in S408 in the break number corresponding to the coding rule ID and the serial number item value in the break number table is deleted.

The following examples illustrate:

after determining that 3 is the final serial number, updating the serial number water level value with the encoding rule ID of 1 in the serial number water level table, updating the water level value with the serial number item value of 2021-12-01 to 3, and deleting the record with the encoding rule ID of 1 and the serial number item value of 2021-12-01 in the break table. Namely, the deletion encoding rule ID is 1, the stream is recorded according to the row with the item value of 2021-12-01 and the break value of 5.

In some embodiments, the server transmits the serial number determined in S4016 to the terminal. It should be noted that: the serial number determined here is also the serial number allocated by the server for the document corresponding to the serial number acquisition request.

According to the serial number processing method provided by the embodiment of the application, the terminal is provided with the setting interface, the user can input the serial number according to the item value and the serial number checking starting point on the setting interface, the user clicks the determining button after the input, the automatic recovery of the serial number can be realized, and when a business document is newly added next time, the serial number is determined based on the water level value updated in the recovery process, so that the continuity of the serial number in document coding is ensured, the labor cost is reduced, and the efficiency is greatly improved. In addition, according to the scheme of the embodiment of the application, the broken number recovery is set and triggered by the user through a broken number recovery setting interface, the operation is simple and convenient, technical support personnel do not need to manually compile codes in a system background to modify a database or cache, and the labor cost and the time cost are greatly reduced. In the broken number recovery stage, all broken numbers are not directly checked in a traversal mode, the broken numbers do not need to be stored in a broken number table, only the serial number water level value needs to be reset to a smaller value, the whole process is only used for performing database updating operation at most once, and the recovery speed is greatly improved. And the scheme of the embodiment of the application also supports the user to autonomously decide the range of the number-breaking check.

It should be understood that, although the steps in the flowcharts related to the embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, embodiments of the present application further provide a terminal for implementing the serial number processing method, where an implementation scheme for solving the problem provided by the terminal is similar to the steps of the terminal side in the method, so that specific limitations in one or more terminal embodiments provided below may refer to the steps of the terminal side in the foregoing, and are not described herein again.

Based on the same inventive concept, embodiments of the present application further provide a server for implementing the serial number processing method, where an implementation scheme for solving the problem provided by the server is similar to the steps on the server side in the method, so that specific limitations in one or more server embodiments provided below may refer to the steps on the server side above, and are not described herein again.

In one embodiment, as shown in fig. 7, there is provided an serial number processing apparatus including:

the broken number recovery module 701 is configured to obtain a broken number recovery request, where the broken number recovery request carries an encoding rule ID, a running water basis item value, and a broken number check start point value; the serial number interruption recovery module 701 is further configured to check an initial point value according to the serial number interruption, and update the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value; a serial number obtaining module 702, configured to obtain a serial number obtaining request, where the serial number obtaining request carries a document type and a serial number basis item value; the running water number obtaining module 702 is further configured to obtain an encoding rule ID according to the type of the document, obtain a current water level value according to the encoding rule ID and the running water basis item value, and determine a running water number according to the type of the document, the encoding rule ID, the running water basis item value, and the current water level value.

In some embodiments, the serial number obtaining module 702 is specifically configured to: inquiring the serial number increment step length according to the coding rule ID and the coding rule sub-table; acquiring a document business table corresponding to the document type according to the document type; m serial numbers corresponding to the serial flow basis item values are inquired in the document business table; storing N serial numbers which are larger than the current water level value in the M serial numbers into a set; and determining the running water number according to the current water level value, the running water number increasing step length and the set.

In some embodiments, the serial number obtaining module 702 is specifically configured to: solving the sum of the current water level value and the incremental step length of the serial number to obtain a summation result, and judging whether the summation result is in a set; if the summation result is not in the set, taking the summation result as a serial number; if the summation result is in the set, the above process is repeated by taking the summation result as the current water level value until the summation result is not in the set.

In some embodiments, the serial number obtaining module 702 is further configured to: inquiring K broken numbers which are smaller than the current water level value in the broken numbers corresponding to the coding rule ID and the pipelining basis item value in the broken number table; and updating the current water level value to be the minimum value of the K break marks.

In some embodiments, the serial number obtaining module 702 is further configured to: and updating the water level values corresponding to the coding rule ID and the running water item value in the running water number water level table into a running water number, and deleting the broken number which is larger than the running water number in the broken number corresponding to the coding rule ID and the running water item value in the broken number table.

In some embodiments, the break number recycling module 701 is specifically configured to: judging whether the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value are larger than the break number check starting point value or not; if the value is larger than the threshold value, updating the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value into a number-off check starting point value.

In some embodiments, the break number recycling module 701 is specifically configured to: after detecting the triggering operation of a user on the broken number recovery entry on the coding rule editing interface, determining whether to display a pipelining basis item editing entry according to coding rule information corresponding to the coding rule editing interface; if the fact that the running water foundation item editing entry is displayed is determined, displaying a broken number recycling setting interface comprising the running water foundation item editing entry; receiving a running water check starting point value input by a user through a broken number recovery setting interface according to the item value and the broken number, and acquiring an encoding rule ID from encoding rule information; and generating a broken number recovery request based on the stream according to the item value, the broken number check starting point value and the encoding rule ID.

The modules in the terminal and the server can be wholly or partially implemented by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, and the internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing the data which needs to be stored at the server side in the serial number processing method. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a serial number processing method.

Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program:

In some embodiments, the processor, when executing the computer program, further performs the steps of: inquiring the serial number increment step length according to the coding rule ID and the coding rule sub-table; acquiring a document business table corresponding to the document type according to the document type; m serial numbers corresponding to the serial flow basis item values are inquired in the document business table; storing N serial numbers which are larger than the current water level value in the M serial numbers into a set; and determining the running water number according to the current water level value, the running water number increasing step length and the set.

In some embodiments, the processor when executing the computer program further performs the steps of: solving the sum of the current water level value and the incremental step length of the serial number to obtain a summation result, and judging whether the summation result is in a set; if the summation result is not in the set, taking the summation result as a serial number; if the summation result is in the set, the above process is repeated by taking the summation result as the current water level value until the summation result is not in the set.

In some embodiments, the processor, when executing the computer program, further performs the steps of: inquiring K broken numbers which are smaller than the current water level value in the broken numbers corresponding to the coding rule ID and the pipelining basis item value in the broken number table; and updating the current water level value to be the minimum value of the K break marks.

In some embodiments, the processor, when executing the computer program, further performs the steps of: and updating the water level values corresponding to the coding rule ID and the running water item value in the running water number water level table into a running water number, and deleting the broken number which is larger than the running water number in the broken number corresponding to the coding rule ID and the running water item value in the broken number table.

In some embodiments, the processor, when executing the computer program, further performs the steps of: judging whether the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value are larger than the break number check starting point value or not; if the value is larger than the threshold value, updating the coding rule ID in the serial number water level table and the water level value corresponding to the serial number according to the item value into a broken number check starting point value.

In some embodiments, the processor, when executing the computer program, further performs the steps of: after detecting the triggering operation of a user on the broken number recovery entry on the coding rule editing interface, determining whether to display a pipelining basis item editing entry according to coding rule information corresponding to the coding rule editing interface; if the fact that the running water basis item editing entry is displayed is determined, displaying a broken number recycling setting interface comprising the running water basis item editing entry; receiving a running water check starting point value input by a user through a broken number recovery setting interface according to the item value and the broken number, and acquiring an encoding rule ID from encoding rule information; and generating a broken number recovery request based on the stream according to the item value, the broken number check starting point value and the encoding rule ID.

In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring a broken number recovery request, wherein the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value; checking an initial point value according to the number break, and updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value; acquiring a serial number acquisition request, wherein the serial number acquisition request carries a document type and a serial basis item value; acquiring an encoding rule ID according to the type of the document, acquiring a current water level value according to the encoding rule ID and the running water basis item value, and determining a running water number according to the type of the document, the encoding rule ID, the running water basis item value and the current water level value.

In some embodiments, the computer program when executed by the processor further performs the steps of: inquiring the serial number increment step length according to the coding rule ID and the coding rule sub-table; acquiring a document business table corresponding to the document type according to the document type; m serial numbers corresponding to the serial flow basis item values are inquired in the document business table; storing N serial numbers which are larger than the current water level value in the M serial numbers into a set; and determining the running water number according to the current water level value, the running water number increasing step length and the set.

In some embodiments, the computer program when executed by the processor further performs the steps of: solving the sum of the current water level value and the incremental step length of the serial number to obtain a summation result, and judging whether the summation result is in a set; if the summation result is not in the set, taking the summation result as a serial number; if the summation result is in the set, the above process is repeated by taking the summation result as the current water level value until the summation result is not in the set.

In some embodiments, the computer program when executed by the processor further performs the steps of: inquiring K broken numbers which are smaller than the current water level value in the broken numbers corresponding to the coding rule ID and the pipelining basis item value in the broken number table; and updating the current water level value to be the minimum value of the K break marks.

In some embodiments, the computer program when executed by the processor further performs the steps of: and updating the water level values corresponding to the coding rule ID and the running water item value in the running water number water level table into a running water number, and deleting the broken number which is larger than the running water number in the broken number corresponding to the coding rule ID and the running water item value in the broken number table.

In some embodiments, the computer program when executed by the processor further performs the steps of: judging whether the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value are larger than the break number check starting point value or not; if the value is larger than the threshold value, updating the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value into a number-off check starting point value.

In some embodiments, the computer program when executed by the processor further performs the steps of: after detecting the triggering operation of a user on the broken number recovery entry on the coding rule editing interface, determining whether to display a pipelining basis item editing entry according to coding rule information corresponding to the coding rule editing interface; if the fact that the running water foundation item editing entry is displayed is determined, displaying a broken number recycling setting interface comprising the running water foundation item editing entry; receiving a running water check starting point value input by a user through a broken number recovery setting interface according to the item value and the broken number, and acquiring an encoding rule ID from encoding rule information; and generating a broken number recovery request based on the stream according to the item value, the broken number check starting point value and the encoding rule ID.

In one embodiment, a computer program product is provided, comprising a computer program which when executed by a processor performs the steps of: acquiring a broken number recovery request, wherein the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value; checking an initial point value according to the number break, and updating the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value; acquiring a serial number acquisition request, wherein the serial number acquisition request carries a document type and a serial basis item value; acquiring an encoding rule ID according to the type of the document, acquiring a current water level value according to the encoding rule ID and the running water basis item value, and determining a running water number according to the type of the document, the encoding rule ID, the running water basis item value and the current water level value.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware related to instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. A serial number processing method, comprising:

acquiring a broken number recovery request, wherein the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number check starting point value;

according to the number interruption check starting point value, updating the coding rule ID in the running water level table and the running water level value corresponding to the running water level item value;

acquiring a serial number acquisition request, wherein the serial number acquisition request carries a document type and the serial basis item value;

and acquiring the coding rule ID according to the bill type, acquiring a current water level value according to the coding rule ID and the running water basis item value, and determining a running water number according to the bill type, the coding rule ID, the running water basis item value and the current water level value.

2. The method of claim 1, wherein determining the running water number based on the document type, the encoding rule ID, the running water dependency term value, and the current water level value comprises:

inquiring the serial number increment step length according to the coding rule ID and the coding rule sub-table;

acquiring a bill business table corresponding to the bill type according to the bill type;

m serial numbers corresponding to the serial number according to item values are inquired in the bill business table;

storing N serial numbers which are larger than the current water level value in a set from the M serial numbers;

and determining the serial number according to the current water level value, the serial number increment step length and the set.

3. The method of claim 2, wherein determining the serial number according to the current water level value, the serial number increment step size, and the set comprises:

solving the sum of the current water level value and the serial number incremental step length to obtain a summation result, and judging whether the summation result is in the set;

if the summation result is not in the set, taking the summation result as the serial number;

if the summation result is in the set, the summation result is taken as the current water level value, and the process is repeated until the summation result is not in the set.

4. The method of claim 2 or 3, wherein before determining the serial number according to the current water level value, the serial number increment step size, and the set, the method further comprises:

inquiring K broken numbers which are smaller than the current water level value in the broken numbers corresponding to the coding rule ID and the pipelining basis item value in a broken number table;

and updating the current water level value to be the minimum value in the K break marks.

5. The method according to claim 2 or 3, wherein after determining the serial number according to the current water level value, the serial number increment step size and the set, the method further comprises:

updating the water level value corresponding to the coding rule ID and the running water item value in the running water number water level table into the running water number, and deleting the broken number which is larger than the running water number in the broken number corresponding to the coding rule ID and the running water item value in the broken number table.

6. The method according to claim 1, wherein the checking the start point value according to the break number, and updating the encoding rule ID in the running water number water level table and the water level value corresponding to the running water item value comprises:

judging whether the coding rule ID in the running water number water level table and the water level value corresponding to the running water number item value are larger than the break number check starting point value or not;

and if so, updating the coding rule ID in the serial number water level table and the water level value corresponding to the serial number item value to the broken number check starting point value.

7. The method of claim 1, wherein obtaining the outage reclamation request comprises:

after detecting the triggering operation of a user on a broken number recovery entry on a coding rule editing interface, determining whether to display a pipelining basis item editing entry or not according to coding rule information corresponding to the coding rule editing interface;

if the fact that the streamline foundation item editing entry is displayed is determined, displaying a broken number recycling setting interface comprising the streamline foundation item editing entry;

receiving the running water item value and the broken number check starting point value input by a user through a broken number recovery setting interface, and acquiring the coding rule ID from the coding rule information;

and generating the broken number recycling request based on the stream dependency item value, the broken number check starting point value and the encoding rule ID.

8. An serial number processing apparatus, comprising:

the system comprises a broken number recovery module, a broken number recovery module and a broken number checking module, wherein the broken number recovery module is used for acquiring a broken number recovery request, and the broken number recovery request carries an encoding rule ID, a running water basis item value and a broken number checking starting point value;

the broken number recovery module is further configured to update the coding rule ID in the serial number water level table and the water level value corresponding to the running water item value according to the starting point value checked by the broken number, so as to obtain a current water level value;

the serial number acquisition module is used for acquiring a serial number acquisition request, and the serial number acquisition request carries a document type and the serial basis item value;

the serial number obtaining module is further configured to obtain the coding rule ID according to the document type, obtain a current water level value according to the coding rule ID and the serial number item value, and determine a serial number according to the document type, the coding rule ID, the serial number item value, and the current water level value.

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.