Reimbursement bill examination and approval query method and system

Abstract

The invention discloses a reimbursement bill examination and approval query method which is characterized by comprising the following steps: obtaining bi n log log data of a PostgreSQL (Structured Query Language) database, setting a Debezium monitoring plug-in, and monitoring reimbursement bill examination and approval core list data in the bi n log log data; synchronizing the reimbursement bill approval core list data to the kafka cluster for storage; establishing an ElasticSearch index, and synchronizing the stored reimbursement bill approval core list data to an ElasticSearch database; and inquiring the reimbursement bill approval core list data through the ElasticSearch index. According to the method and the system, a corresponding reimbursement bill examination and approval core data list in a PostgreSQL database is synchronized into a kafka cluster, query operation of the reimbursement bill examination and approval core data list is realized through an El last icSearch search engine, complex query logic does not need to be constructed in the PostgreSQL database in the query process, separated query of processing logic of a code level is realized, and thus the coupling degree of codes can be reduced, and maintenance of the PostgreSQL database is facilitated.

Description

technical field [0001] The invention relates to the field of financial inquiry, in particular to a method and system for examining and approving an reimbursement form. Background technique [0002] At present, the query method of reimbursement approval is mainly the real-time query implemented by the PostgreSQL database itself. The existing reimbursement system provides field dynamic query, fuzzy query and other query services. However, the reimbursement query through the PostgreSQL database requires multi-table association, subquery and Left and right matching fuzzy query methods are used to query. Only using PostgreSQL database requires some complex SQL such as multi-table association and nested query, which makes the code of the query system less readable. Difference. Contents of the invention [0003] One of the purposes of the present invention is to provide a reimbursement form approval query method and system. The method and system can meet the query requirements o...

AI Technical Summary

Problems solved by technology

[0002] At present, the query method of reimbursement approval is mainly the real-time query implemented by the PostgreSQL database itself. The existing reimbursement system provides field dynamic query, fuzzy query and other query services. However, the reimbursement query through the PostgreSQL database requires multi-table association, subquery and Left and right matching fuzzy query methods are used to query. Only using PostgreSQL database requires some complex SQL such as multi-table association and nested query, which makes the code of the query system less readable. Difference

Images