CN111028074B - Method, system, server and storage medium for updating and inquiring overdue bill - Google Patents
Method, system, server and storage medium for updating and inquiring overdue bill Download PDFInfo
- Publication number
- CN111028074B CN111028074B CN201911240562.2A CN201911240562A CN111028074B CN 111028074 B CN111028074 B CN 111028074B CN 201911240562 A CN201911240562 A CN 201911240562A CN 111028074 B CN111028074 B CN 111028074B
- Authority
- CN
- China
- Prior art keywords
- overdue
- bill
- information
- days
- updating
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 42
- 238000004364 calculation method Methods 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 4
- 238000012545 processing Methods 0.000 description 12
- 230000003287 optical effect Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/03—Credit; Loans; Processing thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a method, a system, a server and a storage medium for updating and inquiring overdue bills. The method for updating the overdue bill comprises the following steps: acquiring bill main table information; judging whether an overdue bill exists after the next daily cut time according to the bill master table information; if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from the preset reference date is even or not; if yes, updating the overdue amount and the overdue days to a first field of the overdue information table; if not, updating the overdue amount and the overdue days to the second field of the overdue information table. The embodiment of the invention realizes efficient synchronization of overdue bills of high orders of magnitude.
Description
Technical Field
The embodiment of the invention relates to information technology, in particular to a method, a system, a server and a storage medium for updating and inquiring overdue bills.
Background
With the transition of people's consumption consciousness and consumption habit and the advocacy of national policy, the development of loan services such as consumption loan is rapid, and the problem of overdue loan repayment is also more and more prominent. For example, as the traffic volume increases, the number of overdue bills increases rapidly, breaking through the hundred million level of quantity, the original batch processing mechanism cannot meet the data level, and normal business requirements and usage are affected. Transformation optimization is urgently needed, and data processing efficiency is improved to ensure normal operation of each service.
The currently used technical scheme supports the level of tens of millions, bill information which is expected to be overdue in open days is completely sent to an MQ queue at 10 hours per day and 30 hours per day, and the overdue calculation is carried out by starting consuming the MQ information at 0 hours in the morning, so that 2 hours are required to finish processing. In addition, the number is increased, the time required for synchronization is correspondingly increased, the overall processing time is increased, the database can reach the bottleneck, and the online business of the company is further affected.
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 efficient synchronization of overdue bills of high orders of magnitude.
To achieve the above objective, an embodiment of the present invention provides a method for updating an overdue bill, which includes:
acquiring bill main table information;
judging whether an overdue bill exists after the next daily cut time according to the bill master table information;
if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from the preset reference date is even or not;
if yes, updating the overdue amount and the overdue days to a first field of the overdue information table;
if not, updating the overdue amount and the overdue days to the second field of the overdue information table.
Further, the bill master table information includes user information, month supply information, principal information, service charge information, and payment date information of the bill.
Further, the determining whether the overdue bill exists after the next date cut time according to the bill master table information includes:
and judging whether an overdue bill exists after the next date cutting time according to the repayment date information.
Further, the calculating the overdue amount and the overdue days of the overdue bill according to the bill master table information includes:
calculating the overdue amount of the overdue bill according to the monthly supply information, principal information and service charge information;
and calculating the overdue days of the overdue bill according to the repayment day information.
Further, the updating the overdue amount and the overdue number of days to the first field of the overdue information table and the updating the overdue amount and the overdue number of days to the second field of the overdue information table includes:
updating the overdue amount and the overdue number of days to a first field corresponding to the user information in the overdue information table;
and updating the overdue amount and the overdue number of days to a second type field corresponding to the user information in the overdue information table.
In one aspect, an embodiment of the present invention further provides a system for updating an overdue bill, where the system for updating an overdue bill includes:
the information acquisition module is used for acquiring bill main table information;
the overdue judging module is used for judging whether overdue bills exist after the next date 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 bill master table information if yes, and judging whether the number of days of the current time from the preset reference date is even or not;
the field updating module is used for updating the overdue amount and the overdue days to the first field of the overdue information table when the number of days from the preset reference date in the current time is even; and when the number of days of the current time from the preset reference date is not even, updating the overdue amount and the overdue number of days into a second field of the overdue information table.
In one aspect, the embodiment of the present invention further provides a method for querying an overdue bill, where the method for querying an overdue bill includes:
receiving a query request of a first overdue bill sent by a user;
obtaining a overdue information table according to the query request;
judging whether the number of days of the current time from the preset reference date is an odd number or not;
if yes, searching a first field in the overdue information table to obtain overdue amount and overdue days of the first overdue bill;
if not, searching a second field in the 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.
In one aspect, the embodiment of the present invention further provides a system for querying an overdue bill, where the system for querying an overdue bill includes:
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 the overdue information table according to the query request;
the date judging module is used for judging whether the number of days of the current time from the preset reference date is an odd number or not;
the bill inquiry module is used for inquiring a first field in the overdue information table to obtain the overdue amount and the overdue days of the first overdue bill when the number of days of the current time from the preset reference date is an odd number; when the number of days of the current time from the preset reference date is not an odd number, searching a second type field in the overdue information table to obtain the overdue amount and the overdue number of days of the first overdue bill;
and the bill display module is used for displaying the overdue amount and the overdue days.
In another aspect, an embodiment of the present invention further provides a server, where the server includes: one or more processors; and a storage means for storing one or more programs that, when executed by the one or more processors, cause the one or more processors to implement a method as provided by any of the embodiments of the present invention.
In yet another aspect, embodiments of the present invention further provide a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a method as provided by any of the embodiments of the present invention.
According to the embodiment of the invention, the bill main table information is obtained; judging whether an overdue bill exists after the next daily cut time according to the bill master table information; if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from the preset reference date is even or not; if yes, updating the overdue amount and the overdue days to a first field of the overdue information table; if not, updating the overdue amount and the overdue days to the second field of the overdue information table, so that the problem of low overdue bill processing efficiency of high orders of magnitude is solved, and the effect of high-efficiency synchronization of overdue bills of high orders of magnitude is realized.
Drawings
FIG. 1 is a flowchart illustrating a method for updating an overdue bill according to an embodiment of the invention;
FIG. 2 is a schematic diagram of a system for updating overdue bills according to a second embodiment of the invention;
FIG. 3 is a flowchart illustrating a method for querying an overdue bill according to a third embodiment of the present invention;
FIG. 4 is a schematic 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 invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are for purposes of illustration and not of limitation. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Before discussing exemplary embodiments in more detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart depicts steps as a sequential process, many of the steps may be implemented in parallel, concurrently, or with other steps. Furthermore, the order of the steps may be rearranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figures. The processes may correspond to methods, functions, procedures, subroutines, and the like.
Furthermore, the terms "first," "second," and the like, may be used herein to describe various directions, acts, steps, or elements, etc., but these directions, acts, 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 referred to as a second module, and similarly, a second module may be referred to as a first module, without departing from the scope of the present application. Both the first module and the second module are modules, but they are not the same module. The terms "first," "second," and the like, are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more of the described features. In the description of the embodiments of the present invention, the meaning of "plurality" is at least two, for example, two, three, etc., unless explicitly defined otherwise.
Example 1
As shown in fig. 1, a first embodiment of the present invention provides a method for updating an overdue bill, where the method for updating an overdue bill includes:
s110, acquiring bill master table information.
And S120, judging whether an overdue bill exists after the next date cutting time according to the repayment date information.
In this embodiment, the bill master table information includes user information, month supply information, principal information, service fee information, and payment date information of the bill. The method can be specifically executed by adopting a computer system, the system can calculate the overdue according to the acquired main list information of all bills, namely, whether the overdue bill exists after the next date cutting time or not is judged according to the repayment date information, and if the current date is 2019-11-12, and the repayment date information of the bill R is 2019-11-12, and if the user does not pay today, namely, the bill repayment state shows that the bill is to be returned, the bill R is overdue on the next day, namely, 2019-11-13 is overdue, overdue fee is required to be calculated, and the system can judge that the bill R is overdue bill, so that all bills can be continuously judged, and overdue bills are selected. Preferably, the start time of the overdue calculation may start from 7 a.m.
And S130, if so, calculating the overdue amount of the overdue bill according to the month supply information, principal information and service charge information, calculating the overdue days of the overdue bill according to the repayment day information, and judging whether the number of days of the current time from the preset reference date is even or not.
And S140, if yes, updating the overdue amount and the overdue number of days to a first field corresponding to the user information in the overdue information table.
And S150, if not, updating the overdue amount and the overdue number of days to 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 continuously 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 overdue days of the overdue bill according to the repayment day information. After the overdue amount and the overdue number of days of the overdue bill are obtained, whether the number of days of the current time, which is away from the preset reference date, is even or not is required to be broken, and if the number of days of the current time, which is away from the preset reference date, is even, the overdue amount and the overdue number of days are updated to a first field corresponding to the user information in the overdue information table. If the number of days of the current time from the preset reference date is not even and is odd, updating the overdue amount and the overdue number of days to a second type field of the overdue information table corresponding to the user information.
For example, the current time may be the current date and time, the preset reference date may be 2013-01-01, the number of days 2019-11-12 is 2506 days, 2506 is even, and the overdue amount and the overdue number of days are updated to the first field of the overdue information table corresponding to the user information. If the current date is 2019-11-11, the number of days 2019-11-11 is 2505 days, and 2505 is odd, updating the overdue amount and the overdue number of days to a second type field of the overdue information table corresponding to the user information.
The first type of field comprises Fpendency_a and Foverdure_a, the second type of field comprises Fpendency_b and Foverdure_b, the unique bill identification 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 expiration information table may be implemented as follows:
the overdue information table is independent, namely, is separated from the bill main table, the updating operation of the overdue information table does not affect the inquiry of the main table, so that two types of fields are redundant, the first type of field is updated after the expiration of T days, the second type of field is updated after T+1, the fields are updated alternately every other days, the space of the system can be utilized to exchange the updating efficiency, overdue calculation is started during the daytime, the processing time is surplus, the pressure of a database is small, and overdue data is available immediately after the daily cutting time.
According to the embodiment of the invention, the bill main table information is obtained; judging whether an overdue bill exists after the next daily cut time according to the bill master table information; if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from the preset reference date is even or not; if yes, updating the overdue amount and the overdue days to a first field of the overdue information table; if not, updating the overdue amount and the overdue days to the second field of the overdue information table, so that the problem of low overdue bill processing efficiency of high orders of magnitude is solved, and the effect of high-efficiency synchronization of overdue bills of high orders of magnitude is realized.
Example two
As shown in fig. 2, the second embodiment of the present invention provides a system 200 for updating an overdue bill, and the system 200 for updating an overdue bill provided in the second embodiment of the present invention can execute the method for updating an overdue bill provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method. The system 200 for updating an overdue bill includes an information acquisition module 210, an overdue determination module 220, a bill calculation module 230, and a field updating module 240.
Specifically, the information obtaining module 210 is configured to obtain bill master table information; the overdue judging module 220 is configured to judge whether an overdue bill exists after the next day-cut time according to the bill master table information; the bill calculation module 230 is configured to calculate the overdue amount and the overdue days of the overdue bill according to the bill master table information if yes, and determine whether the days of the current time from the preset reference date are even; the field updating module 240 is configured to update the overdue amount and the overdue number of days to the first field of the overdue information table when the current time is even from the preset reference date; and when the number of days of the current time from the preset reference date is not even, updating the overdue amount and the overdue number of days into a second field of the overdue information table.
In this embodiment, the bill master table information includes user information, month supply information, principal information, service fee information, and payment date information of the bill. The overdue determining module 220 is specifically configured to determine whether an overdue bill exists after the next day-cut time according to the payment date information. The bill calculating module 230 is specifically configured to calculate an overdue amount of the overdue bill according to the month supply information, principal information and service fee information; and calculating the overdue days of the overdue bill according to the repayment day information. The field updating module 240 is specifically configured to update the overdue amount and the overdue day to a first type field of the overdue information table corresponding to the user information; and updating the overdue amount and the overdue number of days to a second type field corresponding to the user information in the overdue information table.
Example III
As shown in fig. 3, a third embodiment of the present invention provides a method for querying an overdue bill, where the method for querying an overdue bill includes:
s310, receiving a query request of a first overdue bill sent by a user.
S320, obtaining the overdue information table according to the query request.
S330, judging whether the number of days of the current time from the preset reference date is odd.
And S340, if yes, inquiring a first field in the overdue information table to obtain the overdue amount and the overdue days of the first overdue bill.
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.
S360, displaying the overdue amount and the overdue days.
The embodiment of the present invention is the same as the first embodiment of the present invention, in that the embodiment of the present invention is a method for querying a overdue bill, the overdue information table is the overdue information table provided in the first embodiment of the present invention, and, illustratively, in 2019-11-12, the overdue bill R is queried, and the overdue amount and the overdue number of days in the overdue bill R are displayed by querying the second field in the overdue information table for a period of 2505 days, 2505 is an odd number, and the overdue amount and the overdue number of days in the overdue bill R are updated in the second field corresponding to the user information, so that the system determines that the overdue amount and the overdue number of days in the overdue information table are 2506 days, and the overdue number of days in the overdue information table is even numbered, and the overdue amount and the overdue number of days in the overdue information table are obtained.
Example IV
As shown in fig. 4, a fourth embodiment of the present invention provides a system 400 for querying an overdue bill, where the system 400 for querying an overdue bill provided in the fourth embodiment of the present invention can execute the method for querying an overdue bill provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects of the execution method. Such an overdue bill query system 400 includes a request receiving module 410, an information obtaining module 420, a date determining module 430, a bill query module 440, and a bill presentation 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 an overdue information table according to the query request; the date judging module 430 is configured to judge whether the number of days of the current time from the preset reference date is odd; the bill inquiry module 440 is configured to inquire a first field in the 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 the preset reference date is odd; when the number of days of the current time from the preset reference date is not an odd number, searching a second type field in the overdue information table to obtain the overdue amount and the overdue number of 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 merely an example and should not be construed as limiting the functionality and scope of use of embodiments of the present invention.
As shown in FIG. 5, the computer device 12 is in the form of a general purpose computing device. Components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, a bus 18 that connects the various system components, including the system memory 28 and the processing units 16.
Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, and a local bus using any of a variety of bus architectures. By way of example, and not limitation, such architectures include 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 can 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. The 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 or write to non-removable, nonvolatile magnetic media (not shown in FIG. 5, commonly referred to as a "hard disk drive"). Although not shown in fig. 5, a magnetic disk drive for reading from and writing to a removable non-volatile magnetic disk (e.g., a "floppy disk"), and an optical disk drive for reading from or writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In such cases, each drive may be coupled to bus 18 through one or more data medium interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules 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 in, for example, 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 or some combination of which may include an implementation of a network environment. Program modules 42 generally perform the functions and/or methods of the embodiments described herein.
The computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), one or more devices that enable a user to interact with the computer device 12, and/or any devices (e.g., network card, modem, etc.) that enable the computer device 12 to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 22. Moreover, computer device 12 may also communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN) and/or a public network, such as the Internet, through network adapter 20. As shown, network adapter 20 communicates with other modules of computer device 12 via bus 18. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with computer device 12, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.
The processing unit 16 executes various functional applications and data processing by running 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 bill main table information;
judging whether an overdue bill exists after the next daily cut time according to the bill master table information;
if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from the preset reference date is even or not;
if yes, updating the overdue amount and the overdue days to a first field of the overdue information table;
if not, updating the overdue amount and the overdue days to the second field of the overdue information table.
Or the inquiry method of the overdue bill provided by all the embodiments of the invention:
receiving a query request of a first overdue bill sent by a user;
obtaining a overdue information table according to the query request;
judging whether the number of days of the current time from the preset reference date is an odd number or not;
if yes, searching a first field in the overdue information table to obtain overdue amount and overdue days of the first overdue bill;
if not, searching a second field in the 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.
Example five
The fifth embodiment of the present invention further provides a computer readable storage medium having a computer program stored thereon, which when executed by a processor implements the method for updating an overdue bill as provided in all the embodiments of the present invention:
acquiring bill main table information;
judging whether an overdue bill exists after the next daily cut time according to the bill master table information;
if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from the preset reference date is even or not;
if yes, updating the overdue amount and the overdue days to a first field of the overdue information table;
if not, updating the overdue amount and the overdue days to the second field of the overdue information table.
Or the inquiry method of the overdue bill provided by all the embodiments of the invention:
receiving a query request of a first overdue bill sent by a user;
obtaining a overdue information table according to the query request;
judging whether the number of days of the current time from the preset reference date is an odd number or not;
if yes, searching a first field in the overdue information table to obtain overdue amount and overdue days of the first overdue bill;
if not, searching a second field in the 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.
The computer storage media of embodiments of the invention may take the form of 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. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any 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 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.
The computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. 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 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 ++ 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 kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. 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, while the invention has been described in connection with the above embodiments, the invention is not limited to the above embodiments, but may include many other equivalent embodiments without departing from the spirit of the invention, the scope of which is determined by the scope of the appended claims.
Claims (9)
1. A method for updating an overdue bill, comprising:
acquiring bill main table information;
judging whether an overdue bill exists after the next daily cut time according to the bill master table information;
if so, calculating the overdue amount and the overdue number of days of the overdue bill according to the bill master table information, and judging whether the number of days of the current time from a preset reference date is even, wherein the preset reference date is a preset fixed date;
if yes, updating the overdue amount and the overdue days to a first field of the overdue information table;
if not, updating the overdue amount and the overdue days to the second type field of the overdue information table;
the updating the overdue amount and the overdue number of days to the first field of the overdue information table and the updating the overdue amount and the overdue number of days to the second field of the overdue information table includes:
updating the overdue amount and the overdue number of days to a first field corresponding to the overdue information in the overdue information table;
and updating the overdue amount and the overdue days to a second type field corresponding to the overdue information table and the user information, wherein the overdue information table and the bill main table information are mutually independent.
2. The updating method according to claim 1, wherein the bill master table information includes user information, month supply information, principal information, service fee information, and payment date information of a bill.
3. The method of updating according to claim 2, wherein the determining whether the overdue bill exists after the next day time according to the bill master table information comprises:
and judging whether an overdue bill exists after the next date cutting time according to the repayment date information.
4. The method of updating according to claim 2, wherein calculating the overdue amount and the overdue days of the overdue bill according to the bill master table information comprises:
calculating the overdue amount of the overdue bill according to the monthly supply information, principal information and service charge information;
and calculating the overdue days of the overdue bill according to the repayment day information.
5. A system for updating an overdue bill, comprising:
the information acquisition module is used for acquiring bill main table information;
the overdue judging module is used for judging whether overdue bills exist after the next date 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 bill main table information if yes, and judging whether the number of days of the current time from a preset reference date is even or not, wherein the preset reference date is a preset fixed date;
the field updating module is used for updating the overdue amount and the overdue days to the first field of the overdue information table when the number of days from the preset reference date in the current time is even; when the number of days from the current time to the preset reference date is not even, updating the overdue amount and the overdue number of days into a second field of the overdue information table;
the field updating module is used for updating the overdue amount and the overdue days to a first field corresponding to the overdue information table and the user information;
and updating the overdue amount and the overdue days to a second type field corresponding to the overdue information table and the user information, wherein the overdue information table and the bill main table information are mutually independent.
6. A method for querying an overdue bill, comprising:
receiving a query request of a first overdue bill sent by a user;
obtaining a overdue information table according to the query request; wherein the overdue information table and the bill main table information are mutually independent;
judging whether the number of days of the current time from the preset reference date is an odd number or not; wherein the preset reference date is a preset fixed date;
if yes, searching a first field in the overdue information table to obtain overdue amount and overdue days of the first overdue bill;
if not, searching a second field in the 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.
7. A system for querying an overdue bill, comprising:
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 the overdue information table according to the query request; wherein the overdue information table and the bill main table information are mutually independent;
the date judging module is used for judging whether the number of days of the current time from the preset reference date is an odd number or not; wherein the preset reference date is a preset fixed date;
the bill inquiry module is used for inquiring a first field in the overdue information table to obtain the overdue amount and the overdue days of the first overdue bill when the number of days of the current time from the preset reference date is an odd number; when the number of days of the current time from the preset reference date is not an odd number, searching a second type field in the overdue information table to obtain the overdue amount and the overdue number of days of the first overdue bill;
and the bill display module is used for displaying the overdue amount and the overdue days.
8. A server, the server comprising:
one or more processors;
storage means for storing one or more programs,
when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-4, 6.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the method according to any one of claims 1-4, 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911240562.2A CN111028074B (en) | 2019-12-06 | 2019-12-06 | Method, system, server and storage medium for updating and inquiring overdue bill |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911240562.2A CN111028074B (en) | 2019-12-06 | 2019-12-06 | Method, system, server and storage medium for updating and inquiring overdue bill |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111028074A CN111028074A (en) | 2020-04-17 |
| CN111028074B true CN111028074B (en) | 2024-03-19 |
Family
ID=70204460
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911240562.2A Active CN111028074B (en) | 2019-12-06 | 2019-12-06 | Method, system, server and storage medium for updating and inquiring overdue bill |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111028074B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111882413B (en) * | 2020-07-20 | 2024-02-27 | 深圳乐信软件技术有限公司 | Batch updating method and device for overdue rules of bills, server and storage medium |
| CN112581165A (en) * | 2020-12-11 | 2021-03-30 | 北京首汽智行科技有限公司 | Method for collecting overdue car returning cost of entire rental user |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102509237A (en) * | 2011-10-24 | 2012-06-20 | 中国联合网络通信集团有限公司 | Credit card repayment reminding method and system as well as third-party credit card repayment reminding platform |
| CN105190559A (en) * | 2012-12-20 | 2015-12-23 | 甲骨文国际公司 | System and method for implementing shared probabilistic counters storing update probability values |
| CN106656839A (en) * | 2016-10-20 | 2017-05-10 | 财付通支付科技有限公司 | Resource transfer method and apparatus |
| CN107818436A (en) * | 2016-09-12 | 2018-03-20 | 埃森哲环球解决方案有限公司 | For determining adaptive logistics platform that is overdue and being detained data |
| CN108305162A (en) * | 2018-02-28 | 2018-07-20 | 努比亚技术有限公司 | Bill sharing method, mobile terminal and computer readable storage medium |
| CN109064315A (en) * | 2018-08-02 | 2018-12-21 | 平安科技（深圳）有限公司 | Overdue bill intelligence collection method, apparatus, computer equipment and storage medium |
| CN109325728A (en) * | 2018-08-14 | 2019-02-12 | 平安普惠企业管理有限公司 | A kind of debt data processing method and terminal device based on user data resource |
| CN110046988A (en) * | 2019-04-18 | 2019-07-23 | 重庆天蓬网络有限公司 | A kind of batch processing system operational approach, device, medium and electronic equipment |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140172445A1 (en) * | 2012-12-13 | 2014-06-19 | Homan Hajbandeh | Bill Payment Risk Level Determination |
-
2019
- 2019-12-06 CN CN201911240562.2A patent/CN111028074B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102509237A (en) * | 2011-10-24 | 2012-06-20 | 中国联合网络通信集团有限公司 | Credit card repayment reminding method and system as well as third-party credit card repayment reminding platform |
| CN105190559A (en) * | 2012-12-20 | 2015-12-23 | 甲骨文国际公司 | System and method for implementing shared probabilistic counters storing update probability values |
| CN107818436A (en) * | 2016-09-12 | 2018-03-20 | 埃森哲环球解决方案有限公司 | For determining adaptive logistics platform that is overdue and being detained data |
| CN106656839A (en) * | 2016-10-20 | 2017-05-10 | 财付通支付科技有限公司 | Resource transfer method and apparatus |
| CN108305162A (en) * | 2018-02-28 | 2018-07-20 | 努比亚技术有限公司 | Bill sharing method, mobile terminal and computer readable storage medium |
| CN109064315A (en) * | 2018-08-02 | 2018-12-21 | 平安科技（深圳）有限公司 | Overdue bill intelligence collection method, apparatus, computer equipment and storage medium |
| CN109325728A (en) * | 2018-08-14 | 2019-02-12 | 平安普惠企业管理有限公司 | A kind of debt data processing method and terminal device based on user data resource |
| CN110046988A (en) * | 2019-04-18 | 2019-07-23 | 重庆天蓬网络有限公司 | A kind of batch processing system operational approach, device, medium and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111028074A (en) | 2020-04-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8355967B2 (en) | Personal finance integration system and method | |
| EP2901303A1 (en) | Aggregation source routing | |
| CN111125106B (en) | Batch running task execution method, device, server and storage medium | |
| CN103544153A (en) | Data updating method and system based on database | |
| CN102509237A (en) | Credit card repayment reminding method and system as well as third-party credit card repayment reminding platform | |
| CN111427971B (en) | Business modeling method, device, system and medium for computer system | |
| CN111028074B (en) | Method, system, server and storage medium for updating and inquiring overdue bill | |
| CN111881329A (en) | Account balance management method and system | |
| CN111179090A (en) | Transaction data processing method, device and equipment | |
| CN112613964A (en) | Account checking method, account checking device, account checking equipment and storage medium | |
| CN115187378A (en) | Loan automatic repayment method, system, computer equipment and storage medium | |
| CN110675249A (en) | Matching method, device, server and storage medium for network lending | |
| EP1669919A1 (en) | A data processing system and data processing method | |
| CN108280134B (en) | Data circulation system and method based on account limit control, storage medium and terminal | |
| CN110515954B (en) | Data processing method, device, equipment and storage medium | |
| CN111882413B (en) | Batch updating method and device for overdue rules of bills, server and storage medium | |
| CN115760404A (en) | Stock reduction scheme generation method, system, terminal and storage medium | |
| CN110969518B (en) | Clearing account configuration method and device, server and storage medium | |
| CN114239519A (en) | Credit investigation data processing method and device, electronic equipment and computer readable medium | |
| CN112163844A (en) | Capital supervision method, device, equipment and storage medium | |
| CN111192088A (en) | Method and apparatus for determining settlement target of point and computer readable storage medium | |
| CN111369238A (en) | Payment channel selection method, system, payment equipment and storage medium | |
| CN113971007B (en) | Information processing method, device, electronic equipment and medium | |
| CN110648208B (en) | Group identification method and device and electronic equipment | |
| CN113032650B (en) | Library book management method, library book management device, library book management server and library book management storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |