CN111028074A

CN111028074A - Overdue bill updating and inquiring method, system, server and storage medium

Info

Publication number: CN111028074A
Application number: CN201911240562.2A
Authority: CN
Inventors: 张俊业
Original assignee: Shenzhen Lexin Software Technology Co Ltd
Current assignee: Shenzhen Lexin Software Technology Co Ltd
Priority date: 2019-12-06
Filing date: 2019-12-06
Publication date: 2020-04-17
Anticipated expiration: 2039-12-06
Also published as: CN111028074B

Abstract

Embodiments of the present invention disclose a method, system, server and storage medium for updating and querying overdue bills. The method for updating overdue bills includes: acquiring information on the master bill table; judging whether there is an overdue bill after the next cut time according to the information on the master bill table; if so, calculating the overdue amount of the overdue bill according to the information on the master bill table and the number of overdue days, and determine whether the number of days from the current time to the preset reference date is an even number; if so, update the overdue amount and the number of overdue days to the first type field of the overdue information table; if not, add the overdue amount and The number of days overdue is updated to the second type field of the overdue information table. The embodiment of the present invention realizes efficient synchronization of overdue bills of a high order of magnitude.

Description

Overdue bill updating and inquiring method, system, server and storage medium

Technical Field

The embodiment of the invention relates to an information technology, in particular to a method, a system, a server and a storage medium for updating and inquiring overdue bills.

Background

With the change of consumption consciousness and consumption habits of people and the advocation of national policies, loan borrowing services such as loan consumption and the like develop rapidly, and the overdue repayment problem of the loan is more and more prominent. For example, as the amount of business increases, the number of overdue bills also increases rapidly, and the hundred million level quantity level is broken through rapidly, so that the original batch processing mechanism cannot meet the level of the quantity, and normal business requirements and use are influenced. The transformation and optimization are urgently needed, and the data processing efficiency is improved to ensure that each service is normally operated.

The technical scheme used at present is that ten million quantity levels are supported, bill information expected to be overdue tomorrow is completely sent to an MQ queue at 10 o 'clock and 30 o' clock every night, MQ messages are separately consumed at 0 o 'clock and 30 o' clock in the next morning for overdue calculation, 2 hours are needed for processing and completing, as a large number of updating operations are concentrated in a short time, the load of a database is increased, the query time is increased, normal business on the line is influenced, and the bill data is not beneficial to other business parties to use during the overdue synchronization. In addition, the number of the databases is increased, the time required for synchronization is correspondingly increased, the overall processing time is increased, the databases can also reach the bottleneck, and the online business of the company is further influenced.

Disclosure of Invention

The embodiment of the invention provides a method, a system, a server and a storage medium for updating and inquiring overdue bills, so as to realize high-efficiency synchronization of overdue bills with high orders of magnitude.

To achieve the object, an embodiment of the present invention provides a method for updating a overdue bill, where the method for updating the overdue bill includes:

acquiring information of a bill master table;

judging whether overdue bills exist after next cutting time of day or not according to the bill master table information;

if yes, calculating the overdue amount and the overdue days of the overdue bill according to the main bill table information, and judging whether the days of the current time from the preset reference date are even numbers or not;

if yes, updating the overdue amount and the overdue days into a first type field of an overdue information table;

if not, updating the overdue amount and the overdue days into a second type field of the overdue information table.

Further, the bill master table information includes user information, monthly supply information, principal fee information, service fee information and repayment date information of the bill.

Further, the determining whether there is an overdue bill after the next cutting time of day according to the bill master table information includes:

and judging whether overdue bills exist after next day cutting time according to the repayment date information.

Further, said calculating the amount and days of expiration of said overdue bill from said main bill form information comprises:

calculating the overdue amount of the overdue bill according to the monthly supply information, the principal information and the service fee information;

and calculating the overdue days of the overdue bill according to the repayment date information.

Further, the updating the amount of overdue and the number of days of overdue into the first field of the overdue information table and the updating the amount of overdue and the number of days of overdue into the second field of the overdue information table may comprise:

updating the overdue amount and the overdue days to a first type field corresponding to the user information in an overdue information table;

and updating the overdue amount and the overdue days to a second type field corresponding to the user information in an overdue information table.

On one hand, the embodiment of the invention also provides a system for updating the overdue bill, which comprises the following steps:

the information acquisition module is used for acquiring the information of the bill master table;

the overdue judging module is used for judging whether overdue bills exist after next cutting time according to the bill master table information;

the bill calculation module is used for calculating the overdue amount and the overdue days of the overdue bill according to the main bill table information if the current time is the even number, and judging whether the days of the current time from the preset reference date are even numbers or not;

the field updating module is used for updating the overdue amount and the overdue days into a first type field of an overdue information table when the number of days between the current time and a preset reference date is an even number; and when the number of days between the current time and the preset reference date is not an even number, updating the overdue amount and the overdue number of days into a second type field of the overdue information table.

On one hand, the embodiment of the invention also provides a method for inquiring the overdue bill, which comprises the following steps:

receiving a query request of a first overdue bill sent by a user;

acquiring a overdue information table according to the query request;

judging whether the number of days between the current time and a preset reference date is an odd number or not;

if yes, inquiring a first type field in a overdue information table to obtain the overdue amount and the overdue days of the first overdue bill;

if not, inquiring a second type field in a overdue information table to obtain the overdue amount and the overdue days of the first overdue bill;

and displaying the overdue amount and the overdue days.

On one hand, the embodiment of the invention also provides a system for inquiring the overdue bill, which comprises the following steps:

the request receiving module is used for receiving a query request of a first overdue bill sent by a user;

the information acquisition module is used for acquiring a overdue information table according to the query request;

the date judging module is used for judging whether the number of days between the current time and the preset reference date is an odd number;

the bill query module is used for querying a first type field in an overdue information table to obtain the overdue amount and the overdue days of the first overdue bill when the number of days between the current time and the preset reference date is an odd number; when the number of days between the current time and the preset reference date is not an odd number, inquiring a second type field in an overdue information table to obtain the overdue amount and the overdue days of the first overdue bill;

and the bill display module is used for displaying the overdue amount and the overdue days.

On the other hand, an embodiment of the present invention further provides a server, where the server includes: one or more processors; a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement a method as provided by any embodiment of the invention.

In yet another aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the method provided in any embodiment of the present invention.

The embodiment of the invention obtains the information of the main bill table; judging whether overdue bills exist after next cutting time of day or not according to the bill master table information; if yes, calculating the overdue amount and the overdue days of the overdue bill according to the main bill table information, and judging whether the days of the current time from the preset reference date are even numbers or not; if yes, updating the overdue amount and the overdue days into a first type field of an overdue information table; if not, updating the overdue amount and the overdue days into a second type field of the overdue information table, solving the problem of low efficiency of processing overdue bills with high orders of magnitude, and realizing the effect of efficiently synchronizing the overdue bills with high orders of magnitude.

Drawings

FIG. 1 is a flowchart illustrating a method for updating a overdue bill according to an embodiment of the present invention;

FIG. 2 is a schematic structural diagram of a system for updating a overdue bill according to a second embodiment of the present invention;

fig. 3 is a flowchart illustrating a method for querying a overdue bill according to a third embodiment of the present invention;

fig. 4 is a schematic structural diagram of a system for querying overdue bills according to a fourth embodiment of the present invention;

fig. 5 is a schematic structural diagram of a server according to a fifth embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are for purposes of illustration and not limitation. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the steps as a sequential process, many of the steps can be performed in parallel, concurrently or simultaneously. In addition, the order of the steps may be rearranged. A process may be terminated when its operations are completed, but may have additional steps not included in the figure. A process may correspond to a method, a function, a procedure, a subroutine, a subprogram, etc.

Furthermore, the terms "first," "second," and the like may be used herein to describe various orientations, actions, steps, elements, or the like, but the orientations, actions, steps, or elements are not limited by these terms. These terms are only used to distinguish one direction, action, step or element from another direction, action, step or element. For example, a first module may be termed a second module, and, similarly, a second module may be termed a first module, without departing from the scope of the present application. The first module and the second module are both modules, but they are not the same module. The terms "first", "second", etc. are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, features defined as "first", "second", may explicitly or implicitly include one or more of the described features. In the description of the embodiments of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.

Example one

As shown in fig. 1, an embodiment of the present invention provides a method for updating a overdue bill, where the method for updating the overdue bill includes:

and S110, acquiring the bill master table information.

And S120, judging whether overdue bills exist after next day cutting time according to the repayment date information.

In this embodiment, the bill master table information includes user information, monthly supply information, principal information, service fee information, and repayment date information of the bill. The method can be specifically executed by a computer system, the system can perform overdue calculation according to the acquired main bill table information, namely whether overdue bills exist after next day time is judged according to the repayment date information, illustratively, if the current date is 2019-11-12 and the repayment date information of the bill R is 2019-11-12, if the user does not repay today, namely the bill repayment state is displayed to be restored, the bill R will be overdue the next day, namely 2019-11-13, the overdue fee needs to be calculated, the system can judge that the bill R is overdue, so that the system can continuously judge all bills and select the overdue bills. Preferably, the start time of the overdue calculation may start from 7 am.

And S130, if yes, calculating the overdue amount of the overdue bill according to the monthly supply information, principal information and service fee information, calculating the overdue days of the overdue bill according to the repayment date information, and judging whether the days of the current time from the preset reference date are even numbers.

And S140, if yes, updating the overdue amount and the overdue days into a first type field corresponding to the user information in an overdue information table.

And S150, if not, updating the overdue amount and the overdue days into a second type field corresponding to the user information in the overdue information table.

In this embodiment, if there is an overdue bill, the system may continue to calculate the overdue amount of the overdue bill according to the monthly supply information, principal information, and service fee information corresponding to the overdue bill, and calculate the number of overdue days of the overdue bill according to the repayment date information. And after the overdue amount and the overdue days of the overdue bill are obtained, judging whether the days of the current time from the preset reference date are even numbers, and if the days of the current time from the preset reference date are even numbers, updating the overdue amount and the overdue days into a first type field corresponding to the user information in an overdue information table. And if the number of days between the current time and the preset reference date is not an even number and is an odd number, updating the overdue amount and the overdue number of days into a second type field corresponding to the user information in an overdue information table.

For example, the current time may be a current cutting time, the preset reference date may be set to 2013-01-01, the number of days 2019-11-12 away from 2013-01-01 is 2506 days, and 2506 is an even number, and the overdue amount and the overdue number of days are updated to a first field of an overdue information table corresponding to the user information. And if the current cutting time of day is 2019-11-11, the number of days between 2019-11-11 and 2013-01-01 is 2505 days, and 2505 is an odd number, updating the overdue amount and the overdue number into a second field corresponding to the user information in an overdue information table.

The first field comprises Fpendity _ a and Foverdure _ a, the second field comprises Fpendity _ b and Foverdure _ b, the bill unique identifier of the overdue bill R comprises Frepay _ id, the user information comprises Fuid, the bill repayment state comprises Frepay _ state, and the repayment date information comprises Frepay _ date.

The design of the overdue information table can be realized as follows:

CREATE TABLE t_overdue_info(

frepay _ id varchar (32) NOT NULL DEFAULT ' COMMENT ' Bill unique identifier ',

fuid int (11) NOT NULL DEFAULT 0COMMENT 'user information',

frepay _ state int (11) NOT NULL DEFAULT 0COMMENT' bill repayment status, 1 waiting for payment, 10 overdue, 20 paid,

frepay _ date int (11) NOT NULL DEFAULT '19700101' COMMENT 'repayment date information',

fpendability _ a int (11) NOT NULL DEFAULT 0COMMENT 'overdue amount A',

foverdie _ a int (11) NOT NULL DEFAULT '0' COMMENT 'days-to-expire A',

fpendability _ B int (11) NOT NULL DEFAULT 0COMMENT 'overdue amount B',

foverdie _ B int (11) NOT NULL DEFAULT '0' COMMENT 'days-out B',

fnext _ sync _ day NOT NULL DEFAULT '1970-01-01' COMMENT 'next overdue update date',

fcreate _ time datatime NOT NULL DEFAULT '1970-01-0100: 00' COMMENT 'creation time',

fmodify _ time datetime NOT NULL DEFAULT '1970-01-0100: 00' COMMENT 'modification time',

fversion int (11) NOT NULL DEFAULT '0' COMMENT 'version number',

PRIMARY KEY(Frepay_id),

KEY idx_uid_date_state(Fuid,Frepay_date,Frepay_state),

KEY idx_Fmodify_time(Fmodify_time)

) The present invention relates to a method for determining a time-out information table, which comprises an ENGINE (InnoDB DEFAULT circuit) circuit, a utf8 common (overdue information table);

the overdue information table is independent, namely is separated from a bill main table, the query of the main table is not influenced by the updating operation of the overdue information table, two types of fields are redundant, the first type of field is updated when the T day is overdue, the second type of field is updated when the T +1 is over, the fields are updated alternately every other day, the updating efficiency can be obtained by using the space of the system, overdue calculation is started in the daytime, the processing time is redundant, the database pressure is small, and overdue data after the day is cut can be immediately available.

Example two

As shown in fig. 2, a second embodiment of the present invention provides a system 200 for updating an overdue bill, where the system 200 for updating an overdue bill provided by the second embodiment of the present invention can execute a method for updating an overdue bill provided by any embodiment of the present invention, and has corresponding functional modules and beneficial effects of the execution method. The overdue bill updating system 200 includes an information obtaining module 210, an overdue determining module 220, a bill calculating module 230, and a field updating module 240.

Specifically, the information obtaining module 210 is configured to obtain information of a main bill table; the overdue judging module 220 is configured to judge whether an overdue bill exists after the next cutting time according to the bill master table information; the bill calculation module 230 is configured to calculate an overdue amount and an overdue number of days of the overdue bill according to the bill master table information if the current time is the even number, and determine whether the number of days from the current time to a preset reference date is the even number; the field updating module 240 is configured to update the overdue amount and the overdue days to a first type field of the overdue information table when the number of days between the current time and the preset reference date is an even number; and when the number of days between the current time and the preset reference date is not an even number, updating the overdue amount and the overdue number of days into a second type field of the overdue information table.

In this embodiment, the bill master table information includes user information, monthly supply information, principal information, service fee information, and repayment date information of the bill. The overdue determining module 220 is specifically configured to determine whether an overdue bill exists after the next time of day according to the repayment date information. The bill calculating module 230 is specifically configured to calculate an overdue amount of the overdue bill according to the monthly supply information, the principal information, and the service fee information; and calculating the overdue days of the overdue bill according to the repayment date information. The field updating module 240 is specifically configured to update the overdue amount and the overdue days to the first type field corresponding to the user information in the overdue information table; and updating the overdue amount and the overdue days to a second type field corresponding to the user information in an overdue information table.

EXAMPLE III

As shown in fig. 3, a third embodiment of the present invention provides a method for querying a overdue bill, where the method for querying a overdue bill includes:

s310, receiving a query request of the first overdue bill sent by the user.

And S320, acquiring a overdue information table according to the query request.

S330, judging whether the number of days between the current time and the preset reference date is an odd number.

And S340, if yes, inquiring a first type field in a overdue information table to obtain the overdue amount and the overdue days of the first overdue bill.

And S350, if not, inquiring a second type field in the overdue information table to obtain the overdue amount and the overdue days of the first overdue bill.

And S360, displaying the overdue amount and the overdue days.

The specific implementation method of the embodiment of the invention is the same as that of the first embodiment of the invention, and the difference is that the embodiment of the invention is a method for querying overdue bills, the overdue information table is the overdue information table provided by the first embodiment of the invention, illustratively, the overdue bill R is queried in 2019-11-12, because the information of the overdue bill R is 2019-11-11 updated, the number of days 2019-11-11 from 2013-01-01 is 2505 days, 2505 is odd, the overdue amount and the overdue number of days of the overdue bill R are updated in the second type field corresponding to the user information in the overdue information table, the system judges that the number of days 2019-11-12 from 2013-01-01 is 2506 days, and 2506 is even, the second type field in the overdue information table is queried to obtain the overdue amount and the number of days of the first overdue bill, thereby showing the amount and number of days of expiration.

Example four

As shown in fig. 4, a system 400 for querying a overdue bill is provided in the fourth embodiment of the present invention, and the system 400 for querying a overdue bill provided in the fourth embodiment of the present invention can execute a method for querying a overdue bill provided in any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method. The query system 400 for overdue bills comprises a request receiving module 410, an information acquiring module 420, a date judging module 430, a bill querying module 440 and a bill showing module 450.

Specifically, the request receiving module 410 is configured to receive a query request of a first overdue bill sent by a user; the information obtaining module 420 is configured to obtain a overdue information table according to the query request; the date judging module 430 is configured to judge whether the number of days from the current time to the preset reference date is an odd number; the bill query module 440 is configured to query a first type field in an overdue information table to obtain an overdue amount and an overdue number of days of the first overdue bill when the number of days of the current time from a preset reference date is an odd number; when the number of days between the current time and the preset reference date is not an odd number, inquiring a second type field in an overdue information table to obtain the overdue amount and the overdue days of the first overdue bill; the bill display module 450 is used to display the overdue amount and the overdue days.

EXAMPLE five

Fig. 5 is a schematic structural diagram of a server according to a fourth embodiment of the present invention. FIG. 5 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 5 is only an example and should not bring any limitations to the functionality or scope of use of embodiments of the present invention.

As shown in FIG. 5, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.

Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

Computer device 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.

The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 5, and commonly referred to as a "hard drive"). Although not shown in FIG. 5, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.

A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.

Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, computer device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.

The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing the method for updating the overdue bill provided by the embodiment of the present invention:

acquiring information of a bill master table;

Or the overdue bill query method provided by all the invention embodiments of the present application:

receiving a query request of a first overdue bill sent by a user;

acquiring a overdue information table according to the query request;

and displaying the overdue amount and the overdue days.

EXAMPLE five

The fifth embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for updating a overdue bill, provided in all embodiments of the present invention:

acquiring information of a bill master table;

receiving a query request of a first overdue bill sent by a user;

acquiring a overdue information table according to the query request;

and displaying the overdue amount and the overdue days.

Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A method for updating overdue bills, comprising:

Get the billing master table information;

Determine whether there is an overdue bill after the next cut-off time according to the information in the bill master table;

If so, calculate the overdue amount and the overdue days of the overdue bill according to the bill master table information, and determine whether the number of days between the current time and the preset reference date is an even number;

If so, update the overdue amount and the overdue days into the first type field of the overdue information table;

If not, update the overdue amount and the overdue days into the second type field of the overdue information table.

2 . The update method according to claim 1 , wherein the information of the bill master table includes user information, monthly payment information, principal information, service fee information and repayment date information of the bill. 3 .

3. The update method according to claim 2, wherein the determining whether there is an overdue bill after the next date cut time according to the bill master table information comprises:

According to the repayment date information, it is determined whether there is an overdue bill after the cut time of the next day.

4. The update method according to claim 2, wherein the calculating the overdue amount and the overdue days of the overdue bill according to the bill master table information comprises:

Calculate the overdue amount of the overdue bill according to the monthly payment information, principal information and service fee information;

Calculate the overdue days of the overdue bill according to the repayment date information.

5. The updating method according to claim 2, characterized in that, updating the overdue amount and overdue days to the first type field of the overdue information table and updating the overdue amount and overdue days to overdue information The second type of fields in the table include:

updating the overdue amount and overdue days to the first type field corresponding to the overdue information table and the user information;

The overdue amount and the overdue days are updated into the second type field corresponding to the user information in the overdue information table.

6. A system for updating overdue bills, comprising:

The information acquisition module is used to acquire the information of the main bill table;

The overdue judgment module is used to judge whether there is an overdue bill after the next day cut time according to the information in the bill master table;

A bill calculation module, configured to calculate the overdue amount and the overdue days of the overdue bill according to the bill master table information, and determine whether the number of days between the current time and the preset reference date is an even number;

The field update module is used for updating the overdue amount and the overdue days to the first type field of the overdue information table when the number of days from the current time to the preset reference date is an even number; the number of days from the current time to the preset reference date is not When the number is even, the overdue amount and the overdue days are updated into the second type field of the overdue information table.

7. A query method for overdue bills, comprising:

Receive the query request for the first overdue bill sent by the user;

Obtain an overdue information table according to the query request;

Determine whether the number of days from the current time to the preset base date is an odd number;

If yes, query the first type field in the overdue information table to obtain the overdue amount and overdue days of the first overdue bill;

If no, query the second type field in the overdue information table to obtain the overdue amount and overdue days of the first overdue bill;

Display the stated overdue amount and the number of days overdue.

8. A query system for overdue bills, comprising:

a request receiving module, configured to receive a query request for the first overdue bill sent by the user;

an information acquisition module, configured to acquire an overdue information table according to the query request;

The date judgment module is used to judge whether the number of days between the current time and the preset reference date is an odd number;

The bill query module is used to query the first type field in the overdue information table when the number of days between the current time and the preset reference date is odd to obtain the overdue amount and the overdue days of the first overdue bill; the current time is away from the preset benchmark When the number of days of the date is not an odd number, query the second type field in the overdue information table to obtain the overdue amount and overdue days of the first overdue bill;

The bill display module is used to display the overdue amount and overdue days.

9. A server, wherein the device comprises:

one or more processors;

storage means for storing one or more programs,

The one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-5, 7.

10. A computer-readable storage medium on which a computer program is stored, characterized in that, when the program is executed by a processor, the method according to any one of claims 1-5, 7 is implemented.