CN117150074B - Transaction flow video generation method, device, equipment and medium - Google Patents

Transaction flow video generation method, device, equipment and medium Download PDF

Info

Publication number
CN117150074B
CN117150074B CN202311189961.7A CN202311189961A CN117150074B CN 117150074 B CN117150074 B CN 117150074B CN 202311189961 A CN202311189961 A CN 202311189961A CN 117150074 B CN117150074 B CN 117150074B
Authority
CN
China
Prior art keywords
transaction
target
preset
history
transaction record
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
Application number
CN202311189961.7A
Other languages
Chinese (zh)
Other versions
CN117150074A (en
Inventor
鲁健翔
李尼科
潘斌
刘涛
汤敏
卢炼
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hunan Changyin May 8th Consumer Finance Co ltd
Original Assignee
Hunan Changyin May 8th Consumer Finance Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Hunan Changyin May 8th Consumer Finance Co ltd filed Critical Hunan Changyin May 8th Consumer Finance Co ltd
Priority to CN202311189961.7A priority Critical patent/CN117150074B/en
Publication of CN117150074A publication Critical patent/CN117150074A/en
Application granted granted Critical
Publication of CN117150074B publication Critical patent/CN117150074B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/70Information retrieval; Database structures therefor; File system structures therefor of video data
    • G06F16/73Querying
    • G06F16/735Filtering based on additional data, e.g. user or group profiles
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/70Information retrieval; Database structures therefor; File system structures therefor of video data
    • G06F16/73Querying
    • G06F16/732Query formulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/70Information retrieval; Database structures therefor; File system structures therefor of video data
    • G06F16/78Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
    • G06F16/7867Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using information manually generated, e.g. tags, keywords, comments, title and artist information, manually generated time, location and usage information, user ratings
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/03Credit; Loans; Processing thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/04Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Multimedia (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Computational Linguistics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Library & Information Science (AREA)
  • Mathematical Physics (AREA)
  • Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)

Abstract

The application discloses a transaction flow video generation method, a device, equipment and a medium, which relate to the technical field of computers and comprise the following steps: monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before the change and a history transaction record after the change; storing the history transaction record before the change and the history transaction record after the change into a preset transaction record database; when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened out from a preset transaction record database; screening out a target view template and a target voice text template corresponding to the target transaction type of the target historical transaction record from a preset view template set and a preset voice text template set; and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client. The transaction flow can be more specifically displayed.

Description

Transaction flow video generation method, device, equipment and medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a medium for generating a transaction flow video.
Background
In a personal financial scenario, a customer may initiate multiple transactions for a loan, each transaction may affect the balance component type, balance component amount, repayment day, repayment plan, etc. of the customer loan, and as time goes on or the interweaving of various complex transactions, the customer may not determine the transaction flow, and thus may not clearly and quickly know the result of the repayment plan, and may have a question about repayment components and repayment amounts.
In summary, how to more specifically present a transaction flow is a problem to be solved in the art.
Disclosure of Invention
Accordingly, the present invention is directed to a method, apparatus, device and medium for generating a transaction flow video, which can more specifically display a transaction flow. The specific scheme is as follows:
in a first aspect, the application discloses a transaction flow video generation method, applied to a preset video generation system, comprising:
monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively;
Storing the history transaction record before change and the history transaction record after change into a preset transaction record database;
when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined;
screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set;
and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
Optionally, the monitoring the target transaction service table of the preset service database includes:
and starting a logic log through a preset service database, and setting the format of the logic log into a preset copy mode so that the preset video generation system monitors a target transaction service table of the preset service database.
Optionally, the monitoring the target transaction service table of the preset service database includes:
Receiving all transaction service tables fed back by the preset service database;
screening a target transaction service table from all the transaction service tables according to a preset monitoring service configuration table, and monitoring the target transaction service table;
correspondingly, before receiving all the transaction service tables fed back by the preset service database, the method further comprises:
determining a transaction service table to be monitored of a database to be monitored in a preset service database, and generating a preset monitoring service configuration table according to the transaction service table to be monitored.
Optionally, the obtaining the history transaction record before the change and the history transaction record after the change from the target transaction service table before the change and the target transaction service table after the change respectively includes:
acquiring original historical transaction records before modification and original historical transaction records after modification from a target transaction service table before modification and a target transaction service table after modification respectively; the original historical transaction records before modification and the original historical transaction records after modification are all in a structured query statement format;
performing format conversion on the original historical transaction record before modification and the original historical transaction record after modification to obtain a historical transaction record before modification and a historical transaction record after modification; wherein the pre-change historical transaction record and the post-change historical transaction record are both in a data exchange format.
Optionally, before the target view template and the target voice text template corresponding to the target transaction type are screened out from the preset view template set and the preset voice text template set, the method further includes:
establishing a first mapping relation between a historical transaction type and a historical view template file path and a second mapping relation between the historical transaction type and a historical voice text template file path;
correspondingly, the screening the target view template and the target voice text template corresponding to the target transaction type from the preset view template set and the preset voice text template set comprises the following steps:
determining a target view template file path corresponding to the target transaction type according to the first mapping relation, and screening a target view template corresponding to the target view template file path from a preset view template set;
and determining a target voice text template file path corresponding to the target transaction type according to the second mapping relation, and screening out a target voice text template corresponding to the target voice text template file path from a preset voice text template set.
Optionally, the sending, to the client, the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template includes:
Filling the target view template and the target voice text template by using the target historical transaction record respectively to obtain filled view format data and filled voice text format data;
converting the filled back view format data into a picture list in a target image file format;
synthesizing corresponding voice information by using the filled voice text format data, and determining the audio duration of the voice information;
and generating a transaction flow video by using the picture list, the voice information and the audio duration, and sending the transaction flow video to the client.
Optionally, the transaction flow video generated by using the picture list, the voice information and the audio duration includes:
establishing a third mapping relation among the picture list, the voice information and the audio time length, and determining a frame rate by utilizing the audio time length;
and generating a transaction flow video corresponding to the frame rate by using the third mapping relation, the picture list and the voice information.
In a second aspect, the application discloses a transaction flow video generating device, which is applied to a preset video generating system, and includes:
The transaction record acquisition module is used for monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively;
the transaction record storage module is used for storing the history transaction record before the change and the history transaction record after the change into a preset transaction record database;
the transaction type determining module is used for screening a target historical transaction record corresponding to the transaction history inquiry request from the preset transaction record database when receiving the transaction history inquiry request sent by the client, and determining a target transaction type corresponding to the target historical transaction record;
the target template screening module is used for screening target view templates and target voice text templates corresponding to the target transaction types from a preset view template set and a preset voice text template set;
and the transaction video generation module is used for sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
In a third aspect, the present application discloses an electronic device comprising:
a memory for storing a computer program;
and a processor for executing the computer program to implement the steps of the transaction flow video generation method disclosed above.
In a fourth aspect, the present application discloses a computer-readable storage medium for storing a computer program; wherein the computer program when executed by a processor implements the steps of the transaction flow video generation method disclosed previously.
The beneficial effects of the application are that: the method is applied to a preset video generation system, monitors a target transaction business table of a preset business database, and acquires a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively if the target transaction business table is changed; storing the history transaction record before change and the history transaction record after change into a preset transaction record database; when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined; screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set; and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client. Therefore, the preset video generation system is introduced, and the target transaction business table of the preset business database is monitored in a non-invasive way by utilizing the monitoring mechanism, so that the transaction work of the preset business database is not influenced; when a transaction history query request sent by a client is received, a subsequent video generation process is triggered, that is, a transaction process video is not generated when the transaction history query request is not received, so that calculation resources and storage space can be saved; generating a video by using the template, namely generating a transaction flow video by using the target view template and the target voice text template, so that the generation efficiency of the transaction flow video can be improved; the generated transaction flow video can more specifically display the target historical transaction record, so that a user of the client can know the transaction flow more easily and clearly.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings may be obtained according to the provided drawings without inventive effort to a person skilled in the art.
FIG. 1 is a flow chart of a method for generating a video of a transaction flow disclosed in the present application;
FIG. 2 is a flowchart of a specific transaction process video generation method disclosed in the present application;
FIG. 3 is a schematic diagram of a specific transaction flow video generation disclosed herein;
FIG. 4 is a flowchart of another specific transaction flow video generation method disclosed herein;
FIG. 5 is a schematic diagram of a view template under one specific borrowing type disclosed herein;
FIG. 6 is a schematic diagram of a view template under one specific partial payment type disclosed herein;
FIG. 7 is a pictorial representation of a specific borrowing type disclosed herein;
FIG. 8 is a pictorial listing of a specific partial payment type disclosed herein;
Fig. 9 is a schematic structural diagram of a transaction flow video generating device disclosed in the present application;
fig. 10 is a block diagram of an electronic device disclosed in the present application.
Detailed Description
The following description of the technical solutions in the embodiments of the present application will be made clearly and completely with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In a personal financial scenario, a customer may initiate multiple transactions for a loan, each transaction may affect the balance component type, balance component amount, repayment day, repayment plan, etc. of the customer loan, and as time goes on or the interweaving of various complex transactions, the customer may not determine the transaction flow, and thus may not clearly and quickly know the result of the repayment plan, and may have a question about repayment components and repayment amounts.
Therefore, the video generation scheme of the transaction flow is correspondingly provided, and the transaction flow can be displayed more specifically.
Referring to fig. 1, an embodiment of the present application discloses a transaction flow video generating method, which is applied to a preset video generating system, and includes:
step S11: and monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively.
In this embodiment, the monitoring the target transaction service table of the preset service database includes: receiving all transaction service tables fed back by the preset service database; and screening a target transaction service table from all the transaction service tables according to a preset monitoring service configuration table, and monitoring the target transaction service table. It will be appreciated that the preset transaction database will feed back DDL (Data Definition Language, i.e. database definition language), DML (Data Manipulation Language, i.e. database operation language) statements in all transaction tables to the monitoring unit (db_monitor) of the preset video generation system, but contains a lot of data invalid to the transaction, so that such data needs to be filtered, that is, it is filtered according to the preset monitoring service configuration table to obtain the target transaction table.
In this embodiment, before receiving all the transaction service tables fed back by the preset service database, the method further includes: determining a transaction service table to be monitored of a database to be monitored in a preset service database, and generating a preset monitoring service configuration table according to the transaction service table to be monitored. The preset monitoring service configuration table is specifically shown as follows:
list one
According to the first table, only the data tables "t_txn" and "t_schedule" in the database "CCS" need to be monitored by the preset video generating system;
for example, when the SQL statement (Structured Query Language, i.e., the structured query statement) received by the preset video generation system is:
INSERT INTO 'T_user' SET@1=2, @ 2= 'Lifour';
presetting a transaction service table without T_user in a monitoring service configuration table, namely indicating that the SQL statement should not be monitored, namely filtered;
when the SQL sentence received by the preset video generating system is:
INSERT INTO`T_Txn`SET@1=1000001,@2=2000001,@3=‘PAY’;
the transaction service table of the 'T_Txn' exists in the preset monitoring service configuration table, namely the SQL statement is indicated to be monitored, namely cannot be filtered.
In this embodiment, the obtaining the history transaction record before the change and the history transaction record after the change from the target transaction service table before the change and the target transaction service table after the change respectively includes: acquiring original historical transaction records before modification and original historical transaction records after modification from a target transaction service table before modification and a target transaction service table after modification respectively; the original historical transaction records before modification and the original historical transaction records after modification are all in a structured query statement format; performing format conversion on the original historical transaction record before modification and the original historical transaction record after modification to obtain a historical transaction record before modification and a historical transaction record after modification; wherein the pre-change historical transaction record and the post-change historical transaction record are both in a data exchange format. Converting the statement format of the transaction record into a data exchange format, namely a JSON (JavaScript Object Notation, object representation) format, can facilitate subsequent video generation.
For Insert operation of the trade table, the pre-change history trade record is:
{“T_Txn”:“”};
the post-change history transaction record is:
{“T_Txn”:{“Txn_Id”:1000001,“Loan_Id”:2000001,“Txn_Code”:“PAY”,“Txn_Time”:“2023-01-01 01:01:01”,“Cust_ID”:3000001,.....}}。
since the Update operation of the Binary Log will record the original value as a window condition, the data of the front-back change recorded in the target transaction service table can be obtained and converted into JSON format, for example:
update‘T_Schedule’set‘Txn_id’=1000001,‘Loan_Id’=‘2000001’;
‘Principal_AMT’=‘3000.00’....where‘Txn_id’=1000001And;
‘Loan_Id’=2000001’And Principal_AMT’=‘10000.00’;
for Update operation of the repayment schedule, the pre-change JSON format is:
{“T_Schedule”:{[“Loan_Id”:2000001,“Cust_ID”:3000001,“Term”:1,“Principal_AMT”:10000.00,“Interest_AMT”:30.00,“Fee_AMT”:10.00],...};
the changed JSON format is:
{[“Loan_Id”:2000001,“Cust_ID”:3000001,“Term”:1,“Principal_AMT”:3000.00,“Interest_AMT”:10.00,“Fee_AMT”:3.00],...}}。
step S12: and storing the history transaction record before the change and the history transaction record after the change into a preset transaction record database.
The monitoring unit of the preset video generation system stores the history transaction Record before modification and the history transaction Record after modification into a preset transaction Record database (record_DB) so as to trigger the flow of generating the transaction flow video when a transaction history inquiry request is received later; note that, the history transaction record before and after the change is in JSON format.
Step S13: when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined.
In order to avoid that excessive transaction flow videos are generated and occupy a large amount of storage resources, a Video production unit (video_processor) in the preset Video generation system can start corresponding transaction flow Video generation only when a transaction history query request sent by a client is received. The video production unit is required to screen out corresponding target historical transaction records from a preset transaction record database according to client information and inquiry time periods in the transaction history inquiry request, order all the target historical transaction records according to the sequence of transaction time, and determine target transaction types of all the target historical transaction records, wherein the target transaction types are for example, partial repayment types, borrowing types and the like.
Step S14: and screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set.
In this embodiment, before the screening the target view template and the target voice text template corresponding to the target transaction type from the preset view template set and the preset voice text template set, the method further includes: and establishing a first mapping relation between the historical transaction type and the historical view template file path and a second mapping relation between the historical transaction type and the historical voice text template file path. It will be appreciated that a first mapping relationship between different historical transaction types and corresponding historical view template file paths and a second mapping relationship between different historical transaction types and corresponding historical phonetic text template file paths are required in advance, wherein the view templates are HTML (Hyper Text Markup Language, i.e., hypertext markup language) view templates. For example, a specific first mapping relationship shown in table two:
Watch II
Transaction type HTML view template encoding HTML view template file path
PAY HTML_PAY /home/app/xx/HTML_PAY.html
REPAY HTML_REPAY /home/app/xx/HTML_REPAY.html
In the second table, the transaction type and the HTML view template file path establish a first mapping relationship, and the HTML view template file path corresponds to the HTML view template code, that is, corresponds to the view template.
It should be noted that if a new transaction type exists subsequently, a new history view template file path and a new history voice text template file path need to be established, that is, a new history view template and a new history voice text template are established, and the first mapping relationship and the second mapping relationship need to be updated, so that the flexibility and the expansibility of the system are facilitated.
In this embodiment, the screening the target view template and the target voice text template corresponding to the target transaction type from the preset view template set and the preset voice text template set includes: determining a target view template file path corresponding to the target transaction type according to the first mapping relation, and screening a target view template corresponding to the target view template file path from a preset view template set; and determining a target voice text template file path corresponding to the target transaction type according to the second mapping relation, and screening out a target voice text template corresponding to the target voice text template file path from a preset voice text template set. And determining a target view template file path and a target voice text template file path corresponding to the target transaction type according to the first mapping relation and the second mapping relation respectively, and further screening out corresponding target view templates and target voice text templates from a preset view template set and a preset voice text template set respectively.
Step S15: and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
The target historical transaction records are utilized to replace corresponding template variables, namely placeholders, in the target view templates and the target voice text templates, so that filled back view format data and filled back voice text format data can be obtained, the filled back view format data and the filled back voice text format data are utilized to generate corresponding transaction flow videos, and finally the transaction flow videos are sent to the client, so that a user of the client can watch the transaction flow videos on line or download the transaction flow videos, professionals in the prior art use telephones for user communication, the user cannot quickly and visually understand the transaction process, the user can know the transaction records in the corresponding transaction flow more specifically through watching the transaction flow videos, and the user experience is greatly improved.
The beneficial effects of the application are that: the method is applied to a preset video generation system, monitors a target transaction business table of a preset business database, and acquires a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively if the target transaction business table is changed; storing the history transaction record before change and the history transaction record after change into a preset transaction record database; when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined; screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set; and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client. Therefore, the preset video generation system is introduced, and the target transaction business table of the preset business database is monitored in a non-invasive way by utilizing the monitoring mechanism, so that the transaction work of the preset business database is not influenced; when a transaction history query request sent by a client is received, a subsequent video generation process is triggered, that is, a transaction process video is not generated when the transaction history query request is not received, so that calculation resources and storage space can be saved; generating a video by using the template, namely generating a transaction flow video by using the target view template and the target voice text template, so that the generation efficiency of the transaction flow video can be improved; the generated transaction flow video can more specifically display the target historical transaction record, so that a user of the client can know the transaction flow more easily and clearly.
Referring to fig. 2, an embodiment of the present application discloses a specific transaction flow video generating method, which is applied to a preset video generating system, including:
step S21: and starting a logic log through a preset service database, and setting the format of the logic log into a preset copy mode so that the preset video generation system monitors a target transaction service table of the preset service database.
In this embodiment, for example, a specific transaction flow video generation schematic diagram shown in fig. 3 is taken as an example, a client initiates a loan transaction a request and a loan transaction B request in different time periods, a business system accepts each transaction request in different time periods, generates corresponding loan data according to the original loan transaction flow and according to the loan transaction calculation logic, and sends the corresponding loan data including transaction information, repayment plan detail data, bill data and the like to a preset business database (Biz _db), the preset business database starts a transaction, and records data generated in a transaction process into a corresponding transaction business table, including: the transaction table, the repayment schedule table, the bill composition table and the like, the preset service database starts a logic log, and the binlog-format is set in a ROW mode, namely the format of the logic log is set in a preset copying mode, so that the preset service database can copy all DDL and DML sentences in various transaction service tables, and send backups to a preset video generation system, and the preset video generation system can monitor a target transaction service table.
Step S22: and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively.
Step S23: and storing the history transaction record before the change and the history transaction record after the change into a preset transaction record database.
Step S24: when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined.
Step S25: and screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set.
Step S26: and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
Therefore, the binlog master-slave replication capability of MySQL is utilized, the preset service system is completely noninvasive, the stability of the preset service system is ensured, meanwhile, the preset service system can be monitored, the target transaction record corresponding to the transaction history query request is screened out by utilizing the monitored target transaction service table, and finally, the transaction flow video is generated, so that a user of the client can watch the transaction flow video, the corresponding transaction flow can be known more conveniently and rapidly, and the working cost required by staff for solving the transaction flow for the user is reduced.
Referring to fig. 4, an embodiment of the present application discloses a specific transaction flow video generating method, which is applied to a preset video generating system, including:
step S31: and monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively.
Step S32: and storing the history transaction record before the change and the history transaction record after the change into a preset transaction record database.
Step S33: when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined.
Step S34: and screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set.
Step S35: and filling the target view template and the target voice text template by using the target historical transaction record respectively to obtain filled view format data and filled voice text format data.
Fig. 5 and fig. 6 are schematic views of a view template under a borrowing type and a view template under a partial repayment type respectively, and template variables in a target view template and a target voice text template are respectively filled by using a target historical transaction record. The template variables of the view template may specifically be: transaction Type (txn_type_name), transaction Time (txn_time), contract number (load_no), customer information (test_name), transaction amount (txn_ Amt), transaction pre-change payment plan (before_schedule), transaction post-change payment plan (after_schedule), etc., the template variables of the phonetic text template may specifically be: transaction Time (Txn_Time), transaction Type (Txn_Type_Name), contract number (Loan_No), transaction amount (Txn_ Amt), loan Term change (Before_term, after_term), loan component Type, and amount (Basance_Type_Name: basance_Type_ Amt).
Step S36: converting the filled back view format data into a picture list in a target image file format; and synthesizing corresponding voice information by using the filled voice text format data, and determining the audio duration of the voice information.
The filled back view format data is converted into a picture list in a target image file format, for example, fig. 7 and 8 are respectively a picture list schematic diagram under a borrowing type and a picture list schematic diagram under a partial repayment type, wherein the target image file format is specifically JPG (Joint Photographic Experts Group) format.
The filled Voice Text format data is sequentially synthesized into a plurality of pieces of Voice information (Voice) by using a TTS (Text-to-Speech) capability, and the audio Duration (Voice Duration) of each piece of Voice information is obtained.
Step S37: and generating a transaction flow video by using the picture list, the voice information and the audio duration, and sending the transaction flow video to the client.
In this embodiment, the transaction flow video generated by using the picture list, the voice information and the audio duration includes: establishing a third mapping relation among the picture list, the voice information and the audio time length, and determining a frame rate by utilizing the audio time length; and generating a transaction flow video corresponding to the frame rate by using the third mapping relation, the picture list and the voice information. Establishing a third mapping relation among the generated picture list, the voice information and the audio time length:
([image_1_path,voice_1_path,voice_1_duration],...[image_n_path,voice_n_path,voice_n_duration]);
taking each picture in the picture list as a frame in turn, calculating a frame rate (1/voice_n_duration) through a corresponding audio time length by using an audio file of the corresponding picture, and finally manufacturing the MP4 format transaction flow video, wherein the frame rate needs to be adjusted according to configuration in the manufacturing process so that a client can easily check a transaction history process.
Therefore, in order to enable the user of the client to more easily know the corresponding transaction flow, the corresponding transaction flow video is generated according to the target transaction record, the corresponding transaction process is known in the form of the video, and the user experience and the product competitiveness are effectively improved.
Referring to fig. 9, an embodiment of the application discloses a transaction flow video generating device, which is applied to a preset video generating system, and includes:
the transaction record acquisition module 11 is configured to monitor a target transaction service table of a preset service database, and if the target transaction service table is changed, acquire a history transaction record before the change and a history transaction record after the change from the target transaction service table before the change and the target transaction service table after the change respectively;
a transaction record keeping module 12, configured to keep the pre-change historical transaction record and the post-change historical transaction record in a preset transaction record database;
the transaction type determining module 13 is configured to, when receiving a transaction history query request sent by a client, screen a target history transaction record corresponding to the transaction history query request from the preset transaction record database, and determine a target transaction type corresponding to the target history transaction record;
The target template screening module 14 is configured to screen a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set;
and the transaction video generating module 15 is used for sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
The beneficial effects of the application are that: the method is applied to a preset video generation system, monitors a target transaction business table of a preset business database, and acquires a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively if the target transaction business table is changed; storing the history transaction record before change and the history transaction record after change into a preset transaction record database; when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined; screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set; and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client. Therefore, the preset video generation system is introduced, and the target transaction business table of the preset business database is monitored in a non-invasive way by utilizing the monitoring mechanism, so that the transaction work of the preset business database is not influenced; when a transaction history query request sent by a client is received, a subsequent video generation process is triggered, that is, a transaction process video is not generated when the transaction history query request is not received, so that calculation resources and storage space can be saved; generating a video by using the template, namely generating a transaction flow video by using the target view template and the target voice text template, so that the generation efficiency of the transaction flow video can be improved; the generated transaction flow video can more specifically display the target historical transaction record, so that a user of the client can know the transaction flow more easily and clearly.
Further, the embodiment of the application also provides electronic equipment. Fig. 10 is a block diagram of an electronic device 20, according to an exemplary embodiment, and nothing in the figure should be taken as a limitation on the scope of use of the present application.
Fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application. Specifically, the method comprises the following steps: at least one processor 21, at least one memory 22, a power supply 23, a communication interface 24, an input output interface 25, and a communication bus 26. The memory 22 is configured to store a computer program that is loaded and executed by the processor 21 to implement relevant steps in the transaction flow video generation method performed by the electronic device as disclosed in any of the foregoing embodiments.
In this embodiment, the power supply 23 is configured to provide an operating voltage for each hardware device on the electronic device; the communication interface 24 can create a data transmission channel between the electronic device and an external device, and the communication protocol to be followed is any communication protocol applicable to the technical solution of the present application, which is not specifically limited herein; the input/output interface 25 is used for acquiring external input data or outputting external output data, and the specific interface type thereof may be selected according to the specific application requirement, which is not limited herein.
Processor 21 may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor 21 may be implemented in at least one hardware form of DSP (Digital Signal Processing ), FPGA (Field-Programmable Gate Array, field programmable gate array), PLA (Programmable Logic Array ). The processor 21 may also comprise a main processor, which is a processor for processing data in an awake state, also called CPU (Central Processing Unit ); a coprocessor is a low-power processor for processing data in a standby state. In some embodiments, the processor 21 may integrate a GPU (Graphics Processing Unit, image processor) for rendering and drawing of content required to be displayed by the display screen. In some embodiments, the processor 21 may also include an AI (Artificial Intelligence ) processor for processing computing operations related to machine learning.
The memory 22 may be a carrier for storing resources, such as a read-only memory, a random access memory, a magnetic disk, or an optical disk, and the resources stored thereon include an operating system 221, a computer program 222, and data 223, and the storage may be temporary storage or permanent storage.
The operating system 221 is used for managing and controlling various hardware devices on the electronic device and the computer program 222, so as to implement the operation and processing of the processor 21 on the mass data 223 in the memory 22, which may be Windows, unix, linux. The computer program 222 may further include a computer program that can be used to perform other specific tasks in addition to the computer program that can be used to perform the transaction flow video generation method performed by the electronic device as disclosed in any of the previous embodiments. The data 223 may include, in addition to data received by the electronic device and transmitted by the external device, data collected by the input/output interface 25 itself, and so on.
Further, the application also discloses a computer readable storage medium for storing a computer program; the method for generating the transaction flow video comprises the steps of executing a computer program, wherein the computer program is executed by a processor and realizes the transaction flow video generation method disclosed in the prior art. For specific steps of the method, reference may be made to the corresponding contents disclosed in the foregoing embodiments, and no further description is given here.
In this specification, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different point from other embodiments, so that the same or similar parts between the embodiments are referred to each other. For the device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant points refer to the description of the method section.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative elements and steps are described above generally in terms of functionality in order to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application. The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. The software modules may be placed in random access Memory (Random Access Memory), memory, read-Only Memory (ROM), electrically programmable EPROM (Erasable Programmable Read Only Memory), electrically erasable programmable EEPROM (Electrically Erasable Programmable Read Only Memory), registers, hard disk, removable disk, CD-ROM (CoMP 23026731act Disc Read-Only Memory), or any other form of storage medium known in the art.
Finally, it is further noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The foregoing describes in detail a method, apparatus, device and medium for generating a transaction flow video, and specific examples are applied to illustrate the principles and embodiments of the present invention, and the above examples are only used to help understand the method and core idea of the present invention; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present invention, the present description should not be construed as limiting the present invention in view of the above.

Claims (10)

1. The transaction flow video generation method is characterized by being applied to a preset video generation system and comprising the following steps of:
monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively;
storing the history transaction record before change and the history transaction record after change into a preset transaction record database;
when a transaction history inquiry request sent by a client is received, a target history transaction record corresponding to the transaction history inquiry request is screened from the preset transaction record database, and a target transaction type corresponding to the target history transaction record is determined;
screening out a target view template and a target voice text template corresponding to the target transaction type from a preset view template set and a preset voice text template set;
and sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
2. The method for generating a transaction flow video according to claim 1, wherein monitoring the target transaction service table of the preset service database comprises:
And starting a logic log through a preset service database, and setting the format of the logic log into a preset copy mode so that the preset video generation system monitors a target transaction service table of the preset service database.
3. The method for generating a transaction flow video according to claim 1, wherein monitoring the target transaction service table of the preset service database comprises:
receiving all transaction service tables fed back by the preset service database;
screening a target transaction service table from all the transaction service tables according to a preset monitoring service configuration table, and monitoring the target transaction service table;
correspondingly, before receiving all the transaction service tables fed back by the preset service database, the method further comprises:
determining a transaction service table to be monitored of a database to be monitored in a preset service database, and generating a preset monitoring service configuration table according to the transaction service table to be monitored.
4. The method for generating a transaction flow video according to claim 1, wherein the obtaining the pre-change historical transaction record and the post-change historical transaction record from the pre-change target transaction table and the post-change target transaction table, respectively, comprises:
Acquiring original historical transaction records before modification and original historical transaction records after modification from a target transaction service table before modification and a target transaction service table after modification respectively; the original historical transaction records before modification and the original historical transaction records after modification are all in a structured query statement format;
performing format conversion on the original historical transaction record before modification and the original historical transaction record after modification to obtain a historical transaction record before modification and a historical transaction record after modification; wherein the pre-change historical transaction record and the post-change historical transaction record are both in a data exchange format.
5. The method for generating a transaction flow video according to any one of claims 1 to 4, wherein before the target view template and the target voice text template corresponding to the target transaction type are screened from a preset view template set and a preset voice text template set, the method further comprises:
establishing a first mapping relation between a historical transaction type and a historical view template file path and a second mapping relation between the historical transaction type and a historical voice text template file path;
correspondingly, the screening the target view template and the target voice text template corresponding to the target transaction type from the preset view template set and the preset voice text template set comprises the following steps:
Determining a target view template file path corresponding to the target transaction type according to the first mapping relation, and screening a target view template corresponding to the target view template file path from a preset view template set;
and determining a target voice text template file path corresponding to the target transaction type according to the second mapping relation, and screening out a target voice text template corresponding to the target voice text template file path from a preset voice text template set.
6. The method of generating a transaction flow video according to claim 1, wherein the sending the transaction flow video generated using the target historical transaction record, the target view template, and the target phonetic text template to the client comprises:
filling the target view template and the target voice text template by using the target historical transaction record respectively to obtain filled view format data and filled voice text format data;
converting the filled back view format data into a picture list in a target image file format;
synthesizing corresponding voice information by using the filled voice text format data, and determining the audio duration of the voice information;
And generating a transaction flow video by using the picture list, the voice information and the audio duration, and sending the transaction flow video to the client.
7. The method of generating a transaction flow video according to claim 6, wherein the transaction flow video generated using the picture list, the voice information, and the audio duration comprises:
establishing a third mapping relation among the picture list, the voice information and the audio time length, and determining a frame rate by utilizing the audio time length;
and generating a transaction flow video corresponding to the frame rate by using the third mapping relation, the picture list and the voice information.
8. A transaction flow video generating device, which is applied to a preset video generating system, comprising:
the transaction record acquisition module is used for monitoring a target transaction business table of a preset business database, and if the target transaction business table is changed, acquiring a history transaction record before change and a history transaction record after change from the target transaction business table before change and the target transaction business table after change respectively;
the transaction record storage module is used for storing the history transaction record before the change and the history transaction record after the change into a preset transaction record database;
The transaction type determining module is used for screening a target historical transaction record corresponding to the transaction history inquiry request from the preset transaction record database when receiving the transaction history inquiry request sent by the client, and determining a target transaction type corresponding to the target historical transaction record;
the target template screening module is used for screening target view templates and target voice text templates corresponding to the target transaction types from a preset view template set and a preset voice text template set;
and the transaction video generation module is used for sending the transaction flow video generated by using the target historical transaction record, the target view template and the target voice text template to the client.
9. An electronic device, comprising:
a memory for storing a computer program;
a processor for executing the computer program to implement the steps of the transaction flow video generation method of any of claims 1 to 7.
10. A computer-readable storage medium storing a computer program; wherein the computer program when executed by a processor implements the steps of the transaction flow video generation method of any of claims 1 to 7.
CN202311189961.7A 2023-09-15 2023-09-15 Transaction flow video generation method, device, equipment and medium Active CN117150074B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311189961.7A CN117150074B (en) 2023-09-15 2023-09-15 Transaction flow video generation method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311189961.7A CN117150074B (en) 2023-09-15 2023-09-15 Transaction flow video generation method, device, equipment and medium

Publications (2)

Publication Number Publication Date
CN117150074A CN117150074A (en) 2023-12-01
CN117150074B true CN117150074B (en) 2024-03-22

Family

ID=88911897

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311189961.7A Active CN117150074B (en) 2023-09-15 2023-09-15 Transaction flow video generation method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN117150074B (en)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110930240A (en) * 2019-11-21 2020-03-27 深圳乐信软件技术有限公司 Repayment method and device, terminal equipment and storage medium
CN111242783A (en) * 2020-01-16 2020-06-05 腾讯科技(深圳)有限公司 Transaction data processing method and device, computer equipment and storage medium
CN111369287A (en) * 2020-03-04 2020-07-03 腾讯科技(深圳)有限公司 Information processing method, information processing device, computer storage medium and computer equipment
CN112801666A (en) * 2021-03-30 2021-05-14 北京宇信科技集团股份有限公司 Monitoring management method, system, medium and equipment based on enterprise service bus
CN115052073A (en) * 2021-03-09 2022-09-13 中移(上海)信息通信科技有限公司 Video generation method and device and electronic equipment
CN115796764A (en) * 2022-11-04 2023-03-14 北京沐融信息科技股份有限公司 Loan archive management method, system and terminal based on block chain and IPFS
CN116010672A (en) * 2022-12-12 2023-04-25 山东浪潮质量链科技有限公司 Data processing method and device based on identification analysis system

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10631070B2 (en) * 2014-05-22 2020-04-21 Idomoo Ltd System and method to generate a video on-the-fly

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110930240A (en) * 2019-11-21 2020-03-27 深圳乐信软件技术有限公司 Repayment method and device, terminal equipment and storage medium
CN111242783A (en) * 2020-01-16 2020-06-05 腾讯科技(深圳)有限公司 Transaction data processing method and device, computer equipment and storage medium
CN111369287A (en) * 2020-03-04 2020-07-03 腾讯科技(深圳)有限公司 Information processing method, information processing device, computer storage medium and computer equipment
CN115052073A (en) * 2021-03-09 2022-09-13 中移(上海)信息通信科技有限公司 Video generation method and device and electronic equipment
CN112801666A (en) * 2021-03-30 2021-05-14 北京宇信科技集团股份有限公司 Monitoring management method, system, medium and equipment based on enterprise service bus
CN115796764A (en) * 2022-11-04 2023-03-14 北京沐融信息科技股份有限公司 Loan archive management method, system and terminal based on block chain and IPFS
CN116010672A (en) * 2022-12-12 2023-04-25 山东浪潮质量链科技有限公司 Data processing method and device based on identification analysis system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
商品详情动态生成系统的设计与实现;游江平;《中国优秀硕士学位论文全文数据库 信息科技辑》;20220315;I139-241 *
基于区块链技术的数字知识产权保护方案研究;宁梦月;《中国优秀硕士学位论文全文数据库 社会科学Ⅰ辑》;20210515;G117-93 *

Also Published As

Publication number Publication date
CN117150074A (en) 2023-12-01

Similar Documents

Publication Publication Date Title
US8355935B2 (en) Third party information transfer
CN109344170B (en) Stream data processing method, system, electronic device and readable storage medium
US20140013301A1 (en) Resource Processing Using an Intermediary for Context-Based Customization of Interaction Deliverables
US9411575B2 (en) Systems and methods for quality assurance automation
US11755461B2 (en) Asynchronous consumer-driven contract testing in micro service architecture
WO2020119540A1 (en) Group profile picture generation method and device
US20150170271A1 (en) System and Method to Request and Collect Information to Determine Personalized Credit
US9557880B2 (en) Shared user interface services framework
US11010200B2 (en) Finite state machine driven workflows
US20170017677A1 (en) Application event bridge
CN110321283A (en) Interface testing case generation method, device, computer installation and storage medium
US11748662B2 (en) Contextual modeling using application metadata
US8606762B2 (en) Data quality administration framework
US10505873B2 (en) Streamlining end-to-end flow of business-to-business integration processes
CN109241435A (en) It is a kind of for digital cash transaction data push method, apparatus and system
CN117150074B (en) Transaction flow video generation method, device, equipment and medium
CN117291517A (en) Method and device for constructing approval process
CN111488344A (en) User operation data uplink method and system based on service data block chain
US20100211435A1 (en) Package Review Process Mentorship System
CN115422202A (en) Service model generation method, service data query method, device and equipment
JP5202797B2 (en) Maintenance amount calculation device, maintenance amount calculation program
CN113253991A (en) Task visualization processing method and device, electronic equipment and storage medium
JPWO2019234845A1 (en) Future prediction simulation device, method, and computer program
US8055694B1 (en) Modular investment position calculation
CN112468543B (en) Method, device, equipment and computer readable medium for publishing information

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