CN113656428A - Full-flow automatic reporting method for uniform registration and announcement of movable property financing - Google Patents
Full-flow automatic reporting method for uniform registration and announcement of movable property financing Download PDFInfo
- Publication number
- CN113656428A CN113656428A CN202111219729.4A CN202111219729A CN113656428A CN 113656428 A CN113656428 A CN 113656428A CN 202111219729 A CN202111219729 A CN 202111219729A CN 113656428 A CN113656428 A CN 113656428A
- Authority
- CN
- China
- Prior art keywords
- registration
- data
- record
- processing
- contract
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 32
- 230000008859 change Effects 0.000 claims abstract description 42
- 238000010276 construction Methods 0.000 claims abstract description 4
- 238000003032 molecular docking Methods 0.000 claims abstract description 4
- 238000001914 filtration Methods 0.000 claims description 14
- 230000004048 modification Effects 0.000 claims description 5
- 238000012986 modification Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 claims description 5
- 230000003203 everyday effect Effects 0.000 claims description 3
- 230000000977 initiatory effect Effects 0.000 abstract description 2
- 238000007619 statistical method Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 230000002354 daily effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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/06—Asset management; Financial planning or analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/18—Legal services
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Databases & Information Systems (AREA)
- Technology Law (AREA)
- Finance (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a full-flow automatic reporting method for a uniform registration and announcement of movable property financing. The method comprises the steps of completing the construction of a message template according to the registration content of the middle-level network and the requirement of a delivery interface, and realizing the docking of the delivery interface; and (4) building a front system to interface the service system and the middle login network, so as to realize the automatic submission function. The invention can realize automatic initiation, change registration and logout registration of financing lease by constructing a front-end system, butting a service system and a middle-level network, and has the advantages of automatic submission, no manual intervention, high efficiency, low error rate, standard and uniform submission content and the like; the promptness of the report can be guaranteed, and the problem that manual registration is untimely or forgotten to register is solved; the preposed system unifies the reporting gates, can perform statistical analysis on the reporting amount and is convenient to manage.
Description
Technical Field
The invention relates to the technical field of a full-flow automatic reporting method for a mobile property financing unified registration bulletin, in particular to a full-flow automatic reporting method for a mobile property financing unified registration bulletin.
Background
The financing lease business announces ownership of lease property to the outside for resisting a third good-minded person by registering the financing lease business in a dynamic financing unified registration bulletin system (middle-boarding). Currently, the logging-in registration is mainly performed manually, and includes initial registration, change registration, log-out registration and the like. With the business transformation retail, the business volume is continuously increased, the pressure of manual registration in middle-level network is continuously increased, the situation of untimely registration occurs, and certain influence is generated on the business continuity. In addition, the department registration period is long, manual logout and registration are required after the department registration period is expired, so that the possibility of forgetting exists, and bad experience is brought to customers.
Disclosure of Invention
The invention aims to provide a full-flow automatic reporting method for the uniform registration and announcement of the movable property financing aiming at the defects in the prior art.
In order to achieve the aim, the invention provides a full-flow automatic reporting method for the uniform registration and announcement of the movable property financing, which comprises the following steps
Completing the construction of a message template according to the registration content of the middle-login network and the requirement of a delivery interface, and realizing the docking of the delivery interface;
the method comprises the following steps of building a front-end system to interface a service system and a middle log-on network, realizing an automatic reporting function, and specifically comprising the following steps:
designing an external service interface, a report completion notification interface and creating a data table, so that a business system pushes original data into the data table through the external service interface, wherein the original data comprises initial registration data pushed after a contract is signed, change registration data pushed when the contract is changed or basic information of a lessee is changed and logout registration data pushed after the contract is cleared;
creating a processing table, wherein original data in the data table is inserted into the processing table after being subjected to logic processing;
adopting the message template and taking the data in the processing table as the variable access parameters of the logging-in the submission to assemble the message;
calling the submission interface to submit the assembled message, and modifying the processing state of the data in the processing table according to the return result of the submission interface;
and creating a display table, updating the reported data to the display table after each successful report, and sending back a report success result to the service system through a report completion notification interface.
Further, the method also comprises the following steps:
and designing a timing task for the data sheet, so that the initial registered original data are immediately pushed to a processing sheet after entering the data sheet, and the original data of the changed registration and the unregistered data are pushed to the processing sheet in batch at set time intervals.
Further, the method also comprises the following steps:
and designing a timing task for the processing table so as to report the data with unprocessed state and processing failure in the processing table at a timing.
Further, the method also comprises the following steps:
and creating a contract filtering table, wherein the contract filtering table is used for storing the contract names and the remarks which are manually registered in the past so as to filter the data corresponding to the contract names and the remarks stored in the contract filtering table in the data table.
Further, the method also comprises the following steps:
creating a leasing object sub-table and an accessory sub-table, wherein the leasing object sub-table and the accessory sub-table are respectively used for storing leasing property information and accessories in the original data, and the external keys of the leasing object sub-table and the accessory sub-table respectively fetch the main keys of corresponding records in the data table.
Further, the pushing of the original data into the data table by the service system through the external service interface, the pushing of the initially registered original data into the data table immediately after entering the data table specifically includes:
calling an external service interface, verifying the external service interface, and if the external service interface fails to be verified, returning a request failure and a failure reason;
if the data table passes the checking, adding a record of whether the processed field is 'no' to the data table, initially assigning the lease contract number, the lease term, the registration content, the change source, the creation date and the creation time, inserting records of corresponding number into the lease item sub-table according to the list of the lease items to be pushed, inserting records of corresponding number into the accessory sub-table according to the accessory list to be pushed, and taking the main key of the record of the newly added data table by the external keys of the lease item sub-table and the accessory sub-table;
and judging whether the called registration type is initial registration or not, if so, inserting a record of which the processing state is unprocessed and the registration type is initial registration into the processing table, assigning values to a main key, a registration period, a contract name, registration content, property description, a unique property identification code and a property type of the record, and setting the field of whether the record is processed or not to be 'yes' after the main key of the record is newly added into the data table.
Further, the batch pushing of the original data of the change registration and the de-registration to the processing table at set time intervals specifically comprises:
triggering the processing of the data table at regular time every day;
acquiring all the processed fields of the data table as 'no' records, grouping the acquired records according to contract names, and traversing each group to sequentially perform the following operations:
judging whether the contract name of the current group has a record in the contract filtering table, if so, setting all processed fields of all records in the current group as 'yes', and then ending;
if the contract name of the current group has no record in the contract filtering table, judging whether the contract name of the current group has a record in the display table, if the contract name of the current group has no record, judging whether the contract name of the current group has a record in the processing table, if so, directly ending, otherwise, setting the processed field of the record with the registration type being unregistered in the current group as 'yes', and then ending;
if the contract name of the current group has a record in the display list, judging whether the logout registration number of the contract name of the current group in the display list is empty, if not, setting the processed fields of all records in the current group as 'yes', and then ending;
if the logout registration number of the contract name of the current group in the display list is empty, judging whether a registration type is a record of logout registration in the current group, if so, inserting a record of which the processing state is unprocessed and the registration type is the record of logout registration in the processing list, assigning a registration number and a modification code to obtain a result corresponding to the record of the contract in the display list, setting a processed field of all records in the current group as 'yes', and then ending;
if no record with the registration type of deregistering exists in the current group, comparing the registration content of the record with the latest creation date and creation time in the current group as the registration content of the record for changing registration with the data in the corresponding lease thing sub-table and the corresponding attachment sub-table with the registration content, property description, property unique identification code, property type and data in the attachment sub-table of the record of the contract in the display table, judging whether an inconsistent result exists, if not, setting the processed fields of all the records in the current group as 'yes', and then ending;
if the inconsistent result exists, inserting a record of which the processing state is unprocessed and the registration type is change registration into the processing table, assigning values to the main key, the contract name, the registration number, the revision code, the field for comparing the inconsistency and the change source of the data table, and assigning the registration number and the revision code to obtain the result corresponding to the record of the contract in the display table; the change source takes all change sources of the change register in the group and combines the result after the duplication removal, and a plurality of sources are separated by using semicolons; assigning values according to property description, property unique identification codes, property types which are spelled out from the rental sub-tables and inconsistent property description, property unique identification codes and property type fields in the display tables; if the result of the attachment sub-table of the record is inconsistent with the result of the attachment sub-table of the record of the contract in the display table, setting whether to change the attachment field to be 'yes', and otherwise, setting the attachment field to be 'no'; then, the processed field of all records in the current group is set to 'yes', and then the process is ended.
Has the advantages that: the invention can realize automatic initiation, change registration and logout registration of financing lease by constructing a front-end system, butting a service system and a middle login network, and has the following advantages:
1. the automatic reporting is realized, manual intervention is avoided, the efficiency is high, the error rate is low, and the reporting content is standard and uniform;
2. the promptness of the report is guaranteed, and the problem that manual registration is untimely or forgotten to register is solved;
3. the preposed system unifies the reporting gates, can perform statistical analysis on the reporting amount and is convenient to manage.
Drawings
FIG. 1 is a schematic structural diagram of a full-flow automatic reporting method for a uniform registration bulletin of mobile asset financing;
FIG. 2 is a schematic flow chart of initial registration of original data into a data table and then pushing the data to a processing table;
FIG. 3 is a schematic diagram illustrating a flow of pending data submissions in a processing table;
FIG. 4 is a flow chart illustrating the reporting of a processing error in a processing table.
Detailed Description
The present invention will be further illustrated with reference to the accompanying drawings and specific examples, which are carried out on the premise of the technical solution of the present invention, and it should be understood that these examples are only for illustrating the present invention and are not intended to limit the scope of the present invention.
As shown in fig. 1 to 4, an embodiment of the present invention provides a full-flow automatic reporting method for a uniform registration and bulletin of mobile asset financing, which includes
And completing the construction of a message template according to the registration content of the middle-level network and the requirement of the delivery interface, and realizing the docking of the delivery interface. The submission interface includes an initial registration interface, a change registration interface, and a deregistration interface for financing leases. The registration content of the mid-log can be obtained by analyzing the registration content of the mid-log, wherein the registration content comprises basic registration information, lessee information, lessor information and leasing property information. The basic registration information includes a registration term, an archive number, a registration type, and the like. The registration types are divided into three types, initial registration, change registration and deregistration of financing leases. The tenant information includes, for example, a tenant name and a tenant certificate number. The lessor information includes, for example, lessor name and lessor certificate number. The rental property information includes a description of the property information (e.g., rental item name, model, price, quantity, etc.) and a unique identification code, etc.
The method comprises the following steps of building a front-end system to interface a service system and a middle log-on network, realizing an automatic reporting function, and specifically comprising the following steps: designing an external service interface, and creating a data table, a processing table and a display table, so that the service system pushes original data into the data table through the external service interface. Corresponding to the registration type, the original data may also be classified into 3 types, which are initial registration data pushed when a contract is signed, changed registration data pushed when a contract is changed or basic information of a tenant is changed, and unregistered data pushed when a contract is cleared, respectively.
And inserting the original data in the data table into the processing table after logic processing. Specifically, the logic processing comprises the steps of mapping and converting provincial region code values, splicing property description, merging unique identifiers of a plurality of leased properties and the like.
And (4) adopting a message template and taking the data in the processing table as the variable access parameters of the log-in network in the submission to assemble the message. Specifically, the message template can be divided into an initial registration message template, a changed registration message template and a de-registration message template according to the registration type, wherein the initial registration is the initial registration message template, the changed registration is the changed registration message template, and the de-registration is the de-registration message template.
And calling the reporting interface to report the assembled message, and modifying the processing state of the data in the processing table according to a return result of the reporting interface. The specific processing table is determined by the type of registration, which delivery interface is used for delivery. The processing status of the data in the processing table can be classified into unprocessed, successful processing, and failed processing, and when the processing status is unprocessed, it indicates that the data has not been reported. When the processing state is processing success, the report success is indicated. When the processing state is processing failure, the report operation is executed, but the report is not successfully reported due to network fluctuation or message non-conformity with the log-in related requirements.
After each successful delivery, the data of the delivery is updated to the display list, and the successful delivery result is sent back to the service system through the delivery completion notification interface. Thereby causing the latest registration to be presented in the display list. The entries of the report success result are the registration type, contract name, registration number, and the like.
The embodiment of the invention also comprises a timing task designed for the data sheet, so that the initial registered original data is immediately pushed to the processing sheet after entering the data sheet, and the original data of the change registration and the logout registration is pushed to the processing sheet in batch at set time intervals. The timing task of the data table is preferably executed in a daily timing trigger mode, namely, original data of change registration and de-registration are pushed to the processing table at set time of each day.
The embodiment of the invention also comprises a timing task designed for the processing table so as to report the data with unprocessed state and failed processing state in the processing table at a timing. The timing task of the processing table is preferably triggered and executed every minute, and the execution time interval of the processing table is small, so that the initially registered data can be quickly pushed to a middle log-in network, and the timeliness of initial registration is guaranteed.
When the manually registered contract is changed or cancelled, the pre-system cannot find the previously registered information and cannot compare the information, so that the system can make mistakes. Therefore, the embodiment of the present invention further includes creating a contract filtering table, which is used to store the contract names and the remarks that are manually registered in the past, so as to filter the data in the data table corresponding to the contract names and the remarks stored in the contract filtering table. Therefore, the partial data cannot enter the automatic reporting flow, namely cannot be pushed from the data table to the processing table.
The embodiment of the invention also comprises creating a leasing object sub-table and an accessory sub-table, wherein the leasing object sub-table and the accessory sub-table are respectively used for storing the leasing property information and the accessories in the original data, and the external keys of the leasing object sub-table and the accessory sub-table respectively fetch the main keys of the corresponding records in the data tables so as to carry out association. When the data table pushes data to the processing table, the rental property information and the accessories do not need to be pushed, and meanwhile, the rental property information and the data in the accessories are guaranteed to be normally used when the messages are assembled.
Referring to fig. 2, the pushing, by the service system according to the embodiment of the present invention, the original data into the data table through the external service interface, and the pushing, immediately after the initially registered original data enters the data table, to the processing table specifically includes:
and calling an external service interface, checking the external service interface, and if the external service interface fails to be checked, returning a request failure and a failure reason.
And judging whether the called registration type is initial registration or not, if so, inserting a record of which the processing state is unprocessed and the registration type is initial registration into the processing table, assigning values to a main key, a registration period, a contract name, registration content, property description, a unique property identification code and a property type of the record, and setting the field of whether the record is processed or not to be 'yes' after the main key of the record is newly added into the data table.
And judging whether the called registration type is initial registration or not, if so, inserting a record of which the processing state is unprocessed and the registration type is initial registration into the processing table, assigning values to a main key, a registration period, a contract name, registration content, property description, a property unique identification code and a property type of the record, and setting a processed field or not of the newly added record in the data table to be 'yes'.
The method for pushing the original data of the change registration and the logout registration to the processing table in batch at set time intervals in the embodiment of the invention specifically comprises the following steps:
the processing of the data table is triggered periodically every day.
Acquiring all the processed fields of the data table as 'no' records, grouping the acquired records according to contract names, and traversing each group to sequentially perform the following operations:
and judging whether the contract name of the current group has a record in the contract filtering table, if so, setting the processed fields of all the records in the current group as 'yes', and then ending.
If the contract name of the current group has no record in the contract filtering table, judging whether the contract name of the current group has a record in the display table, if not, judging whether the contract name of the current group has a record in the processing table, if so, directly ending, otherwise, setting the processed field of the record with the registration type of de-registration in the current group as 'yes', and ending.
If the contract name of the current group has a record in the display list, judging whether the logout registration number of the contract name of the current group in the display list is empty, if not, setting the processed fields of all records in the current group as 'yes', and then ending.
If the log-out number of the contract name of the current group in the display list is empty, judging whether a record with the log-out type as log-out exists in the current group, if so, inserting a record with the processing state as unprocessed and the log-out type as log-out in the processing list, assigning the log-in number and the modification code to obtain a result corresponding to the record of the contract in the display list, setting the processed fields of all records in the current group as 'yes', and then ending.
If no record with the registration type of deregistering exists in the current group, comparing the registration content of the record with the latest creation date and creation time in the current group as the registration content of the record for changing registration with the data in the corresponding lease thing sub-table and the corresponding attachment sub-table with the registration content, property description, property unique identification code, property type and data in the attachment sub-table of the record of the contract in the display table, judging whether an inconsistent result exists, if not, setting the processed fields of all the records in the current group as 'yes', and then ending.
If the inconsistent result exists, inserting a record of which the processing state is unprocessed and the registration type is change registration into the processing table, assigning values to the main key, the contract name, the registration number, the revision code, the field for comparing the inconsistency and the change source of the data table, and assigning the registration number and the revision code to obtain the result corresponding to the record of the contract in the display table; the change source takes all change sources of the change register in the group and combines the result after the duplication removal, and a plurality of sources are separated by using semicolons; assigning values according to property description, property unique identification codes, property types which are spelled out from the rental sub-tables and inconsistent property description, property unique identification codes and property type fields in the display tables; if the result of the attachment sub-table of the record is inconsistent with the result of the attachment sub-table of the record of the contract in the display table, setting whether to change the attachment field to be 'yes', and otherwise, setting the attachment field to be 'no'; then, the processed field of all records in the current group is set to 'yes', and then the process is ended.
The timing reporting of the data with unprocessed and failed processing states in the processing table of the embodiment of the invention specifically comprises the following steps:
and reporting the data with the processing state of unprocessed or failed processing in the processing table at set time intervals.
Referring to fig. 3, the report flow for the unprocessed processing status is as follows:
and assembling the request message, and calling a corresponding reporting interface to report.
And judging that the report interface returns a result, and recording the state of the record in the processing table as 'processing failure' if the report interface fails.
If the record is successful, recording the record state in the processing table as 'processing success', simultaneously updating the corresponding data in the display table, then judging whether the registration type is initial registration or de-registration, if not, directly ending, calling a 'reporting completion notification interface' to send a reporting success result back to the service system, and then ending. That is, when the change registration submission is performed, there is no need to feed back the submission success result to the service system.
The reporting flow for the processing state as processing failure is as follows:
and judging whether the message assembled by the data with the processing state of failure does not meet the requirement of network logging, if the processing table does not have a record which does not meet the requirement, the processing failure is probably caused by network fluctuation, and in this case, directly calling a reporting interface to report the assembled message. If the record which does not meet the requirement exists in the processing table, reading all unprocessed change registration records of the contract in the data table, updating all fields of the record of which the processing state in the processing table is processing failure and the registration type is initial registration into the corresponding result of the unprocessed change registration record with the latest creation date and creation time, correcting the part of the message which does not meet the requirement, setting whether the unprocessed change registration field is taken out from the data table as 'yes', and calling a reporting interface to report the assembled message. The subsequent reporting process is consistent with the reporting process whose processing state is unprocessed, and is not described in detail.
Referring to fig. 4, the reason for the processing failure occurring in the initial registration is explained as the property description is too long: if yes, all the unprocessed change registration records of the contract in the data table are taken, all the fields of the record of which the processing state of the contract in the processing table is processing failure and the registration type is initial registration are updated to be the corresponding result of the unprocessed change registration record with the latest creation date and creation time, wherein the property description is changed to intercept the description of the last lease item before overlength, the description is added with ' equal ' and the like ', and the field of whether the extracted unprocessed change registration is processed is set to ' yes '.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that other parts not specifically described are within the prior art or common general knowledge to those of ordinary skill in the art. Without departing from the principle of the invention, several improvements and modifications can be made, and these improvements and modifications should also be construed as the scope of the invention.
Claims (9)
1. A full-flow automatic reporting method for the uniform registration and announcement of the capital investment is characterized by comprising
Completing the construction of a message template according to the registration content of the middle-login network and the requirement of a delivery interface, and realizing the docking of the delivery interface;
the method comprises the following steps of building a front-end system to interface a service system and a middle log-on network, realizing an automatic reporting function, and specifically comprising the following steps:
designing an external service interface, a report completion notification interface and creating a data table, so that a business system pushes original data into the data table through the external service interface, wherein the original data comprises initial registration data pushed after a contract is signed, change registration data pushed when the contract is changed or basic information of a lessee is changed and logout registration data pushed after the contract is cleared;
creating a processing table, wherein original data in the data table is inserted into the processing table after being subjected to logic processing;
adopting the message template and taking the data in the processing table as the variable access parameters of the logging-in the submission to assemble the message;
calling the submission interface to submit the assembled message, and modifying the processing state of the data in the processing table according to the return result of the submission interface;
and creating a display table, updating the reported data to the display table after each successful report, and sending back a report success result to the service system through a report completion notification interface.
2. The full-flow automatic submission method for the dynamic property financing unified registration bulletin as claimed in claim 1, further comprising:
and designing a timing task for the data sheet, so that the initial registered original data are immediately pushed to a processing sheet after entering the data sheet, and the original data of the changed registration and the unregistered data are pushed to the processing sheet in batch at set time intervals.
3. The full-flow automatic submission method for the dynamic property financing unified registration bulletin as claimed in claim 1, further comprising:
and designing a timing task for the processing table so as to report the data with unprocessed state and processing failure in the processing table at a timing.
4. The full-flow automatic submission method for the dynamic property financing unified registration bulletin as claimed in claim 2, further comprising:
and creating a contract filtering table, wherein the contract filtering table is used for storing the contract names and the remarks which are manually registered in the past so as to filter the data corresponding to the contract names and the remarks stored in the contract filtering table in the data table.
5. The full-flow automatic submission method for the dynamic property financing unified registration bulletin as claimed in claim 2, further comprising:
creating a leasing object sub-table and an accessory sub-table, wherein the leasing object sub-table and the accessory sub-table are respectively used for storing leasing property information and accessories in the original data, and the external keys of the leasing object sub-table and the accessory sub-table respectively fetch the main keys of corresponding records in the data table.
6. The full-flow automatic submission method of the dynamic property financing unified registration bulletin as claimed in claim 5, wherein the business system pushes the original data into the data sheet through the external service interface, and the pushing of the initially registered original data into the data sheet immediately after entering the data sheet specifically comprises:
calling an external service interface, verifying the external service interface, and if the external service interface fails to be verified, returning a request failure and a failure reason;
if the data table passes the checking, adding a record of whether the processed field is 'no' to the data table, initially assigning the lease contract number, the lease term, the registration content, the change source, the creation date and the creation time, inserting records of corresponding number into the lease item sub-table according to the list of the lease items to be pushed, inserting records of corresponding number into the accessory sub-table according to the accessory list to be pushed, and taking the main key of the record of the newly added data table by the external keys of the lease item sub-table and the accessory sub-table;
and judging whether the called registration type is initial registration or not, if so, inserting a record of which the processing state is unprocessed and the registration type is initial registration into the processing table, assigning values to a main key, a registration period, a contract name, registration content, property description, a unique property identification code and a property type of the record, and setting the field of whether the record is processed or not to be 'yes' after the main key of the record is newly added into the data table.
7. The method of claim 4, wherein the step of pushing the original data of the change registration and the de-registration to the processing table at a predetermined time interval comprises:
triggering the processing of the data table at regular time every day;
acquiring all the processed fields of the data table as 'no' records, grouping the acquired records according to contract names, and traversing each group to sequentially perform the following operations:
judging whether the contract name of the current group has a record in the contract filtering table, if so, setting all processed fields of all records in the current group as 'yes', and then ending;
if the contract name of the current group has no record in the contract filtering table, judging whether the contract name of the current group has a record in the display table, if the contract name of the current group has no record, judging whether the contract name of the current group has a record in the processing table, if so, directly ending, otherwise, setting the processed field of the record with the registration type being unregistered in the current group as 'yes', and then ending;
if the contract name of the current group has a record in the display list, judging whether the logout registration number of the contract name of the current group in the display list is empty, if not, setting the processed fields of all records in the current group as 'yes', and then ending;
if the logout registration number of the contract name of the current group in the display list is empty, judging whether a registration type is a record of logout registration in the current group, if so, inserting a record of which the processing state is unprocessed and the registration type is the record of logout registration in the processing list, assigning a registration number and a modification code to obtain a result corresponding to the record of the contract in the display list, setting a processed field of all records in the current group as 'yes', and then ending;
if no record with the registration type of deregistering exists in the current group, comparing the registration content of the record with the latest creation date and creation time in the current group as the registration content of the record for changing registration with the data in the corresponding lease thing sub-table and the corresponding attachment sub-table with the registration content, property description, property unique identification code, property type and data in the attachment sub-table of the record of the contract in the display table, judging whether an inconsistent result exists, if not, setting the processed fields of all the records in the current group as 'yes', and then ending;
if the inconsistent result exists, inserting a record of which the processing state is unprocessed and the registration type is change registration into the processing table, assigning values to the main key, the contract name, the registration number, the revision code, the field for comparing the inconsistency and the change source of the data table, and assigning the registration number and the revision code to obtain the result corresponding to the record of the contract in the display table; the change source takes all change sources of the change register in the group and combines the result after the duplication removal, and a plurality of sources are separated by using semicolons; assigning values according to property description, property unique identification codes, property types which are spelled out from the rental sub-tables and inconsistent property description, property unique identification codes and property type fields in the display tables; if the result of the attachment sub-table of the record is inconsistent with the result of the attachment sub-table of the record of the contract in the display table, setting whether to change the attachment field to be 'yes', and otherwise, setting the attachment field to be 'no'; then, the processed field of all records in the current group is set to 'yes', and then the process is ended.
8. The full-flow automatic submission method of the dynamic property financing unified registration bulletin as claimed in claim 3, wherein the timely submission of the data with unprocessed status in the processing table specifically comprises:
triggering to report the data with unprocessed processing state in the processing table at set time intervals;
assembling a request message, and calling a corresponding submission interface to submit;
judging the return result of the reporting interface, and recording the state of the record in the processing table as 'processing failure' if the reporting interface fails;
if the record is successful, recording the record state in the processing table as 'processing success', simultaneously updating the corresponding data in the display table, then judging whether the registration type is initial registration or de-registration, if not, directly ending, calling a 'reporting completion notification interface' to send a reporting success result back to the service system, and then ending.
9. The full-flow automatic submission method of the dynamic property financing unified registration bulletin as claimed in claim 3, wherein the timely submission of the data with the state of processing failure in the processing table specifically comprises:
judging whether a message assembled by data with a processing state of failure processing does not meet the requirement of logging in the middle or not, and if the processing table does not have a record which does not meet the requirement, directly calling a reporting interface to report the assembled message;
if the record which does not meet the requirement exists in the processing table, reading all unprocessed change registration records of the contract in the data table, updating all fields of the record of which the processing state in the processing table is processing failure and the registration type is initial registration into the corresponding result of the unprocessed change registration record with the latest creation date and creation time, correcting the part of the message which does not meet the requirement, setting whether the unprocessed change registration field is taken out from the data table as 'yes', and calling a reporting interface to report the assembled message.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111219729.4A CN113656428A (en) | 2021-10-20 | 2021-10-20 | Full-flow automatic reporting method for uniform registration and announcement of movable property financing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111219729.4A CN113656428A (en) | 2021-10-20 | 2021-10-20 | Full-flow automatic reporting method for uniform registration and announcement of movable property financing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113656428A true CN113656428A (en) | 2021-11-16 |
Family
ID=78484296
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111219729.4A Pending CN113656428A (en) | 2021-10-20 | 2021-10-20 | Full-flow automatic reporting method for uniform registration and announcement of movable property financing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113656428A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105577808A (en) * | 2015-12-29 | 2016-05-11 | 中国建设银行股份有限公司 | Supervision reporting method and system |
| CN111539803A (en) * | 2020-04-02 | 2020-08-14 | 普洛斯科技(重庆)有限公司 | Pledge financing monitoring method, system and computer readable storage medium |
| CN112598519A (en) * | 2020-12-28 | 2021-04-02 | 深圳市佑荣信息科技有限公司 | System and method for accounts receivable pledge transfer registered property based on NLP technology |
| CN112988867A (en) * | 2021-03-15 | 2021-06-18 | 中国建设银行股份有限公司 | Supervision data sending method and device |
-
2021
- 2021-10-20 CN CN202111219729.4A patent/CN113656428A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105577808A (en) * | 2015-12-29 | 2016-05-11 | 中国建设银行股份有限公司 | Supervision reporting method and system |
| CN111539803A (en) * | 2020-04-02 | 2020-08-14 | 普洛斯科技(重庆)有限公司 | Pledge financing monitoring method, system and computer readable storage medium |
| CN112598519A (en) * | 2020-12-28 | 2021-04-02 | 深圳市佑荣信息科技有限公司 | System and method for accounts receivable pledge transfer registered property based on NLP technology |
| CN112988867A (en) * | 2021-03-15 | 2021-06-18 | 中国建设银行股份有限公司 | Supervision data sending method and device |
Non-Patent Citations (1)
| Title |
|---|
| 徐晗: "不动产登记一窗受理数据共享系统设计与实现", 《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8015151B2 (en) | Method and system for managing and modifying time dependent data structures | |
| US8938421B2 (en) | Method and a system for synchronizing data | |
| CN108228814B (en) | Data synchronization method and device | |
| US8930010B2 (en) | Intelligent assembly system and method of use | |
| US8868483B2 (en) | Database load engine | |
| CN108509392B (en) | Multi-mechanism account checking method, system, computer equipment and storage medium | |
| CN110088744A (en) | A kind of database maintenance method and its system | |
| US20050240843A1 (en) | Method, computer program and device for deleting data sets contained in a data list from a table system | |
| CN113656428A (en) | Full-flow automatic reporting method for uniform registration and announcement of movable property financing | |
| US11169984B2 (en) | Data management system | |
| CN114090634A (en) | Hotel data management method and device based on data warehouse | |
| CN108173711B (en) | Data exchange monitoring method for internal system of enterprise | |
| CN110879779B (en) | Joint debugging test method and system | |
| CN115774881A (en) | Code auditing method, device, equipment and medium | |
| CN115981718A (en) | Code publishing method and device, computer equipment and storage medium | |
| CN108156203B (en) | Storage system and storage node management method | |
| CN115660543A (en) | Multi-storage standardized integrated management system based on block chain and control method | |
| CN115510169A (en) | Asset checking method, terminal and computer readable storage medium | |
| CN111309370B (en) | Version number directed graph ordering auditing method and system for multi-project multi-system environment | |
| CN115269917A (en) | Goods receiving system and goods receiving method | |
| CN115292175A (en) | Regression testing method, device, equipment and storage medium | |
| CN111159206A (en) | Method and device for updating device information database and computer readable storage medium | |
| CN115358607B (en) | Order process one-key copy maintenance method, device and storage medium | |
| CN113902364A (en) | Inventory checking method and device | |
| EP2175377B1 (en) | Method and system for managing and modifying time dependent data structures |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211116 |