CN116561198A - Statistical data downloading method and device for supply chain finance - Google Patents
Statistical data downloading method and device for supply chain finance Download PDFInfo
- Publication number
- CN116561198A CN116561198A CN202310851289.7A CN202310851289A CN116561198A CN 116561198 A CN116561198 A CN 116561198A CN 202310851289 A CN202310851289 A CN 202310851289A CN 116561198 A CN116561198 A CN 116561198A
- Authority
- CN
- China
- Prior art keywords
- statistical data
- supply chain
- information
- configuration information
- query
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/2866—Architectures; Arrangements
- H04L67/30—Profiles
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Probability & Statistics with Applications (AREA)
- Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Fuzzy Systems (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Finance (AREA)
- Mathematical Physics (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention relates to the technical field of computers, and provides a statistical data downloading method and device for supply chain finance, wherein the method comprises the following steps: receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user; information configuration is carried out based on the statistical data downloading request, database configuration information and server configuration information are obtained, and the database configuration information is checked; under the condition that verification is passed, based on the configuration information of the database, carrying out data query from a financial statistics database of the supply chain to obtain financial statistics data of the supply chain; based on the supply chain finance statistics data and the server configuration information, a statistics data file of the supply chain finance is generated and sent to the client, decoupling of business logic and statistics data downloading logic is achieved, modification cost caused by user demand change is reduced, efficiency of statistics data downloading is guaranteed, and quick demand change is achieved.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for downloading statistical data of supply chain finance.
Background
With the wide development of supply chain finance, more and more supply chain finance enterprises are in full play, the business of the supply chain finance enterprises is also better developed for a longer time, and accordingly, the business data volume of the supply amount finance enterprises is continuously increased, and the statistical data download of the business is used as a statistical mode of the business data of the supply chain business, which is not only an important component of an enterprise business system, but also solves the problem that the business data is huge and disordered due to the continuous increase of the data.
At present, in the statistics data downloading of the supply chain finance, the business function and the logic of the statistics data downloading are usually connected together, and in a plurality of statistics businesses on the current market, most businesses generate corresponding data statistics through fixed requirements, in this case, any new increase or change of business requirements needs to modify the logic matched with the business requirements, so that the statistics business can be completed, however, the method not only needs to consume a great deal of time and effort, increases the modification cost caused by the requirement change, but also reduces the efficiency of the statistics data downloading, and slows down the implementation process of the requirement change.
Disclosure of Invention
The invention provides a statistical data downloading method and device for supply chain finance, which are used for solving the defects that in the prior art, due to the fact that business functions are connected with logic of statistical data downloading, any change of a requirement needs to modify the logic matched with the business functions, so that the cost of the requirement change is increased, the efficiency of the statistical data downloading is reduced, the implementation process of the requirement change is slowed down, decoupling of business logic and the statistical data downloading logic is realized, the modification cost caused by the requirement change is reduced, and the efficiency of the statistical data downloading is ensured.
The invention provides a statistical data downloading method of supply chain finance, which comprises the following steps:
receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user;
information configuration is carried out based on the statistical data downloading request, database configuration information and server configuration information are obtained, and verification is carried out on the database configuration information;
under the condition that verification is passed, based on the database configuration information, carrying out data query from a supply chain financial statistics database to obtain supply chain financial statistics data;
Generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information, and sending the statistical data file to the client.
According to the statistical data downloading method of the supply chain finance, the database configuration information comprises a statistical data downloading main key, statistical data downloading information corresponding to the statistical data downloading main key, statistical data downloading query component information and supply chain finance field information; the server configuration information comprises a configuration file path and a server template file under the configuration file path.
According to the method for downloading the statistical data of the supply chain finance provided by the invention, the data query is carried out from the supply chain finance statistical database based on the database configuration information to obtain the supply chain finance statistical data, and the method comprises the following steps:
determining statistical data downloading information, statistical data downloading query component information and supply chain financial field information corresponding to a statistical data downloading main key based on the statistical data downloading main key in the database configuration information;
based on the download query statement corresponding to the statistical data download information and the download query condition corresponding to the statistical data download query component information, carrying out data query from a supply chain financial statistical database to obtain query statistical data;
And performing paging detection based on the query statistics, acquiring the query statistics of the current page under the condition of paging the query statistics, and determining the supply chain financial statistics based on the query statistics of the current page and the supply chain financial field information.
According to the method for downloading the statistical data of the supply chain finance provided by the invention, the verification of the database configuration information comprises the following steps:
acquiring user identity information of the user based on the statistical data downloading request;
based on the user identity information, carrying out statistic data downloading permission detection;
and checking the database configuration information under the condition that the detection is passed.
According to the method for downloading the statistical data of the supply chain finance provided by the invention, the verification of the database configuration information comprises the following steps:
performing at least one of query verification, condition verification and field verification on the database configuration information;
the query verification is to verify the download query statement corresponding to the statistical data download information; the condition verification is to verify the downloading query condition corresponding to the statistical data downloading query component information; and the field verification is to verify the length and width of the word segment in the supply chain financial field information.
According to the method for downloading the statistical data of the supply chain finance provided by the invention, the statistical data file of the supply chain finance is generated based on the statistical data of the supply chain finance and the server configuration information, and the method comprises the following steps:
determining a server template file under a configuration file path based on the configuration file path in the server configuration information;
and performing matching rendering based on the server template file and the supply chain finance statistical data to obtain a supply chain finance statistical data file.
According to the statistical data downloading method of the supply chain finance, the server configuration information further comprises a file downloading path;
the generating a supply chain financial statistics file further comprises:
acquiring the file name of the statistical data file;
and storing the statistical data file based on the download file path in the server configuration information and the file name of the statistical data file.
The invention also provides a statistical data downloading device of the supply chain finance, which comprises the following steps:
the receiving module is used for receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user;
The configuration module is used for carrying out information configuration based on the statistical data downloading request to obtain database configuration information and server configuration information, and checking the database configuration information;
the query module is used for carrying out data query from the supply chain financial statistical database based on the database configuration information under the condition that the verification is passed, so as to obtain the supply chain financial statistical data;
and the downloading module is used for generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information and sending the statistical data file to the client.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the supply chain finance statistical data downloading method as described in any one of the above when executing the program.
The present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a supply chain financial statistics data downloading method as described in any of the above.
According to the statistical data downloading method and device for the supply chain finance, information configuration is carried out through the statistical data downloading request generated on the basis of user requirements, and the database configuration information is checked, under the condition that the checking is passed, the statistical data file is obtained through inquiring and downloading based on the database configuration information and the server configuration information, the statistical data file is sent to the client, decoupling of business logic and the statistical data downloading logic is achieved, the defect that the logic matched with the business function and the statistical data downloading logic is required to be modified due to cross connection of the business function and the statistical data downloading logic in the traditional scheme is overcome, the cost of the requirement change is increased, the efficiency of the statistical data downloading is reduced, and corresponding configuration information can be adjusted when the statistical data downloading field is required to be adjusted through information configuration, so that the modification cost caused by the user requirement change is reduced, the efficiency of the statistical data downloading is further guaranteed, and the rapid requirement change is achieved.
Drawings
In order to more clearly illustrate the invention or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for downloading statistical data of supply chain finance provided by the invention;
FIG. 2 is an exemplary diagram of a rendering template for matched rendering provided by the present invention;
FIG. 3 is a schematic diagram of a device for downloading statistics of supply chain finance according to the present invention;
fig. 4 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are 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.
At present, in the statistics data downloading of the supply chain finance, the business function and the logic of the statistics data downloading are usually together, and most businesses on the market at present generate corresponding data statistics through fixed demands, in this case, any new increase or change of business demands needs to modify the logic matched with the business demands, so that the statistics business can be completed, however, the method not only needs to consume a great deal of time and effort, increases the modification cost caused by the demand change, but also reduces the efficiency of the statistics data downloading, and slows down the implementation process of the demand change.
The invention provides a statistical data downloading method of supply chain finance, which aims at carrying out information configuration according to a statistical data downloading request generated on the basis of user demands, inquiring and downloading according to configuration information to obtain a statistical data file, and simultaneously, when a statistical data downloading field needs to be adjusted, adjusting corresponding configuration information in time, thereby reducing modification cost caused by user demand change and further realizing faster and more efficient statistical data downloading and demand change.
Fig. 1 is a flow chart of a method for downloading statistical data of supply chain finance, as shown in fig. 1, wherein an execution subject of the method is a business system, and the method comprises:
step 110, receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user;
and 120, carrying out information configuration based on the statistical data downloading request to obtain database configuration information and server configuration information, and checking the database configuration information.
Specifically, before the statistical data downloading is performed, firstly, a statistical data downloading request of a user needs to be acquired, namely, when the user has a statistical data downloading requirement in practical application, the user can input the self requirement through the client, then the client can generate a corresponding statistical data downloading request through the input user requirement, and the generated statistical data downloading request can be sent to the service system to request the service system to perform statistical data query downloading according to the request.
Here, the user requirements may include statistics data download related information (such as download file name, download type, etc.), statistics data download query related information (such as query order, query format, etc.), and statistics data download supply chain finance field related information (such as field alignment mode, field width, etc.), in addition to that, considering that some users have personalized setting requirements for fonts for statistics data download, the user requirements may also include font requirements for download fields, that is, font related information (such as font size, font color, font style, etc.).
After the client side obtains the related information, the client side can correspondingly generate a statistical data downloading request of the user, wherein the request carries downloading related information, inquiring related information, field related information, font related information and the like of the user for downloading the statistical data; therefore, after the client sends the statistical data downloading request to the service system, the service system can correspondingly carry out information configuration according to the statistical data downloading request so as to obtain server configuration information and database configuration information. The client can be an intelligent device such as a mobile phone, a tablet computer, a desktop computer and the like.
Specifically, after receiving the statistical data downloading request, the service system can correspondingly perform information configuration of the server and the database, namely, the server and the database in the service system can be used for configuring and downloading information, so that the server configuration information and the database configuration information can be obtained, the server configuration can comprise a configuration file path and a server template file, and the server template file can be in an excel form, so that the server template file can be called an excel template file. The database configuration information may be statistics download information (e.g., file name of statistics download, type of statistics download, query SQL of statistics download, etc.), statistics download query component information (query component order, query component type, query component format, etc.), and supply chain financial field information (e.g., field alignment, field width, etc.).
Further, after obtaining the database configuration information, considering the uncertainty of the user requirement, and the arbitrary nature and randomness of the user requirement input, the statistical data downloading request generated based on the user requirement and the normalization of the database configuration information obtained based on the statistical data downloading request configuration are poor, that is, the database configuration information is quite possibly not matched with the requirement/normalization of the service system on the input information of the statistical data downloading, so that in order to ensure the accuracy and the stability of the subsequent data query downloading and avoid the conditions of error codes and the like, in the embodiment of the invention, the database configuration information is also required to be checked before the data query is carried out so as to verify the normalization and the consistency with the service system requirement.
The method and the device specifically can check the query statement level of the configuration information of the database, check the query condition level of the configuration information of the database, check the field information level of the configuration information of the database, or check the multiple levels simultaneously.
Step 130, carrying out data query from the supply chain financial statistics database based on the database configuration information to obtain the supply chain financial statistics data under the condition that the verification is passed;
step 140, generating a statistics file of the supply chain finance based on the supply chain finance statistics data and the server configuration information, and sending the statistics file to the client.
In particular, under the condition that the verification result represents that the verification is passed, that is, under the condition that the verification that the database configuration information meets the requirement of the service system on the input information, in short, the database configuration information accords with the system specification, in this case, the stability of the query process can be ensured by carrying out data query downloading based on the verification result, and the follow-up query downloading can be ensured to be carried out stably, so that the data query can be carried out based on the database configuration information and the supply chain financial statistical database at the moment to obtain the supply chain financial statistical data, that is, the database configuration information serves as a benchmark, and the statistical data can be queried from the supply chain financial statistical database in the service system, so that the supply chain financial statistical data corresponding to the database configuration information can be obtained.
Specifically, the data query is performed from the supply chain financial statistics database according to the download query statement and the download query condition corresponding to the database configuration information, so as to obtain the supply chain financial statistics data corresponding to the database configuration information, that is, the statistics data matched with the download query condition is searched in the supply chain financial statistics database through the download search statement and is used as the required supply chain financial statistics data.
And then, generating a final required statistical data file according to the server configuration information and the supply chain financial statistical data, and returning the final required statistical data file to the client, namely, after the supply chain financial statistical data is obtained, integrating the supply chain financial statistical data according to the server template file in the server configuration information obtained through information configuration, thereby obtaining a supply chain financial statistical data file corresponding to the template, and sending the statistical data file to the client for sending a statistical data downloading request, so that a user at the client side can obtain the statistical data file required to be downloaded, and further, the statistical data downloading of the supply chain financial is realized.
The generation of the statistics file may be achieved by matching and integrating the server template file and the supply chain financial statistics data, that is, the supply chain financial statistics data and the server template file may be subjected to frame matching, for example, matching of a supply chain financial template name, a service start date, an expiration date, service personnel information, a service type, a supply chain financial institution, a service statistics detail, service total number information, and the like, and information integration is performed in combination with a matching result, so as to obtain the supply chain financial statistics data file.
According to the statistical data downloading method of the supply chain finance, information configuration is carried out through the statistical data downloading request generated on the basis of user requirements, database configuration information is checked, under the condition that the checking is passed, the statistical data file is obtained through inquiring and downloading based on the database configuration information and server configuration information, the statistical data file is sent to a client, decoupling of business logic and statistical data downloading logic is achieved, the defect that the logic matched with the business logic needs to be modified due to logical linkage of business functions and statistical data downloading in the traditional scheme, the cost of the requirement change is increased, the efficiency of the statistical data downloading is reduced is overcome, corresponding configuration information can be adjusted when the statistical data downloading field needs to be adjusted through information configuration, the modification cost caused by user requirement change is reduced, the efficiency of the statistical data downloading is further guaranteed, and the rapid requirement change is achieved.
Based on the above embodiment, the database configuration information includes a statistics download main key, and statistics download information, statistics download query component information, and supply chain financial field information corresponding to the statistics download main key; the server configuration information includes a configuration file path and a server template file under the configuration file path.
Specifically, in the process of performing information configuration according to the statistical data downloading request to obtain the database configuration information and the server configuration information, the information configuration can be performed through the server and the database, namely, the statistical data downloading template is configured through the server, so that a server template file, namely, an excel template file, is obtained, then, a path corresponding to the excel template file can be configured, the excel template file is placed under the corresponding path, and the path corresponding to the excel template file, namely, the configuration file path, can be a path corresponding to a configuration folder of a statistical data downloading program in a service system, namely, the excel template file can be configured under the program configuration folder.
Correspondingly, the database-based information configuration practice configures a database table related to the downloading of the statistical data according to the downloading requirement of the statistical data, and specifically comprises the steps of configuring the downloading information of the statistical data, configuring the downloading query component information of the statistical data and configuring the financial field information of a supply chain. In addition, font information may also be configured based on the user's personalized needs.
Here, the statistical data download information includes a file name of the statistical data download, a file name of the statistical data download template, a statistical data download type, and a statistical data download query SQL. The specific information is shown in the following table (statistical data download information table):
The statistics download ID (Identity document) is a statistics download key in the database configuration information, and corresponds to the statistics download information, the statistics download query component information, and the supply chain financial field information, respectively.
The download query statement may be determined by the statistical data download information, AND in particular, the download query statement may be represented by an "expression+statistical data download query SQL", where the expression may be represented as "$ { query field: operation symbol: whether OR not quoted: relational operator (OR OR AND) used in multi-value association: corresponding SQL field+redundant information }).
Wherein $ is a initiator; { } is an expression; within { is an expression; the character spacing device is a spacer for spacing characters; operation symbol: eq, le and ge are equal to, less than or equal to and greater than or equal to respectively; whether or not to add the quotation marks: n is not added, y is added; relational operators used in multi-value correlation: o is OR and is AND; corresponding SQL field + redundant information: if the value of the uploading field has a redundant field, the star is replaced by the redundant field, for example, the value is 20200101abc, the expression is [ field-abc ], and the actual value of abc can be intercepted to 20200101.
The following describes the expression using single field and multiple field as examples, respectively:
single field: { enddate: le:: y:: o: [ recvdate- ] }
If the value of the front field name enddate is 20200101, the single field expression may be escape as recvdate <20200101.
Multiple fields: a { NODECODE:: eq:: y:: o: [ NODECODE- ] }
If the codeword is an array and the value is [ '0000', '0001' ], the expression of the multi-field may be escaped as a codeword= '0000' OR codeword= '0001'.
The statistical data download query component information includes query component order, query component ID, query component name, query component type, query component format, and query component verification. The specific information is shown in the following table (statistical data download inquiry component table):
the business system can map the statistical data downloading query component information through the statistical data downloading query component table and initialize the downloading query condition, wherein the downloading query condition can be the financial name of a supply chain, the type of the query condition (text box, single selection box, cascade selection box, date selection and the like) and the like which need to be downloaded.
The supply chain financial field information includes query component order, field ID, field name, field alignment, field width, and parent supply chain financial field ID. The specific information is shown in the following table (supply chain financial field information table):
The font information includes at least one of a character size (No. two, no. three, no. four, no. five, etc.), a character color (black, green, red, etc.), a character style (regular, bold, italic, etc.).
Based on the above embodiment, based on the database configuration information, performing data query from the supply chain financial statistics database to obtain supply chain financial statistics data, including:
determining statistical data downloading information corresponding to the statistical data downloading main key, statistical data downloading query component information and supply chain financial field information based on the statistical data downloading main key in the database configuration information;
based on the download inquiry statement corresponding to the statistical data download information and the download inquiry condition corresponding to the statistical data download inquiry component information, carrying out data inquiry from the supply chain finance statistical database to obtain inquiry statistical data;
paging detection is performed based on the query statistics, the query statistics of the current page are acquired under the condition of paging the query statistics, and the supply chain financial statistics are determined based on the query statistics of the current page and the supply chain financial field information.
Specifically, in step 130, according to the database configuration information, a process of obtaining the supply chain financial statistics data by querying data from the supply chain financial statistics database specifically includes:
Firstly, a main statistical data downloading key is required to be acquired, wherein the main statistical data downloading key is the statistical data downloading ID in the database configuration information, and then the configuration information of a statistical data downloading program in a service system can be acquired according to the main statistical data downloading key, namely the statistical data downloading information, the statistical data downloading query component information and the supply chain financial field information corresponding to the main statistical data downloading key in the database configuration information are acquired;
then, according to the statistical data downloading information and the statistical data downloading inquiry component information, carrying out data inquiry from the supply chain financial statistical database to obtain statistical data matched with the statistical data, specifically, carrying out data inquiry according to a downloading inquiry statement corresponding to the statistical data downloading information and a downloading inquiry condition corresponding to the statistical data downloading inquiry component information, namely, carrying out data inquiry from the supply chain financial statistical database by using the downloading inquiry statement with the downloading inquiry condition as a reference, so as to obtain the statistical data matched with the downloading inquiry condition, wherein the statistical data is called inquiry statistical data because of inquiry;
after that, considering the huge data volume in the financial statistics database of the supply chain in the business system and quite a lot of inquiry statistics data obtained by inquiry, in the embodiment of the invention, after the inquiry statistics data are obtained, the inquiry statistics data can be further subjected to paging detection to detect whether the inquiry statistics data are paged or not, and partial inquiry statistics data can be obtained under the condition of confirming the paging of the inquiry statistics data, namely the inquiry statistics data of the current page can be obtained according to the paging start identification of the page, and the inquiry statistics data are used as the inquiry statistics data of the required inquiry;
And then, determining the supply chain financial statistical data according to the query statistical data of the current page and the supply chain financial field information, namely performing field rendering according to the query statistical data of the current page and the supply chain financial field information to obtain the supply chain financial statistical data.
In the embodiment of the invention, the data query is carried out by downloading the query statement, the query condition and the information of the financial field of the supply chain to obtain the financial statistical data of the supply chain, and the customization of the information configuration is carried out to realize the flexible activation and customization of the download field, the data style and the query component of the financial statistical data of the supply chain, thereby better meeting the requirements of users.
Based on the above embodiment, verifying the database configuration information includes:
acquiring user identity information of a user based on a statistical data downloading request;
based on the user identity information, carrying out statistic data downloading permission detection;
And checking the database configuration information under the condition that the detection is passed.
Specifically, in step 120, the process of verifying the database configuration information may specifically include the following steps:
in addition to whether the database configuration information is normalized and needs to be subjected to consistency verification or not, the business system has the condition that the corresponding data downloading authorities are necessarily different due to different responsibilities or posts corresponding to different users, so that the user needs to be subjected to authority verification before carrying out data query to verify whether the business system has the corresponding statistical data downloading authorities or not, and the safety of the statistical data is ensured not to leak.
Based on this, in the embodiment of the present invention, the user identity information may be obtained first, and because the user identity information is characterized by user login information (such as an account ID and an account name of a login account) in a specific service, the user must be in a login state when issuing a statistical data download request by means of a client, and the client will incorporate the identity information into the statistical data download request when generating the statistical data download request according to the user requirement, so that the generated statistical data download request includes the user identity information of the user, and therefore the user identity information may be obtained based on the statistical data download request.
Then, the statistical data downloading permission detection can be performed according to the user identity information, namely, the validity check of the permission is performed according to the user identity information, namely, whether the user sending the statistical data downloading request has the permission of the statistical data downloading is detected, and the statistical data downloading permission detection can be performed on the user identity information according to the corresponding relation between the identity information and the permission set in the service system, so that a detection result is obtained.
And then, under the condition that the detection result characterizes that the user has the statistical data downloading authority, namely under the condition that the detection is passed, the database configuration information is further checked, namely the consistency between the database configuration information and the service system requirement is verified. The method and the device specifically can check the query statement level of the configuration information of the database, check the query condition level of the configuration information of the database, check the field information level of the configuration information of the database, or check the multiple levels simultaneously.
Based on the above embodiment, verifying the database configuration information includes:
Performing at least one of query verification, condition verification and field verification on the database configuration information;
the query verification is to verify the download query statement corresponding to the statistical data download information; the condition check is to check the download inquiry condition corresponding to the statistical data download inquiry component information; the field verification is to verify the length and width of the field in the supply chain financial field information.
Specifically, when checking the database configuration information in the above process, any one or more of query check, condition check, and field check may be performed on the database configuration information, that is, any one or more of a download query statement corresponding to the statistical data download information in the database configuration information, a download query condition corresponding to the statistical data download query component information, and a field length and width in the supply chain financial field information may be checked.
The condition checking fact is to check whether the statistical data corresponding to the downloading query condition exists in the service system and whether the downloading query condition accords with the downloading type; the field verification is to verify whether the character set of the field is correct or not and whether the length and width of the field are matched with the database or not; the query verification is to verify whether the downloaded query statement meets the query requirement of the service system for the query statement.
In addition, in this process, the query component rendering may be performed, and the component may be displayed in the page of the user, where the query component is an input component for downloading the query component form based on the above statistics data, for example, an input box, a date selection box, a multiple selection box, a single selection box, etc., and specifically may be reading the configuration of the query component in the statistics data downloading database, that is, reading the statistics data downloading query component information, and rendering and loading data according to the query component type.
Based on the above embodiments, generating a supply chain financial statistics file based on supply chain financial statistics, and server configuration information, includes:
determining a server template file under the configuration file path based on the configuration file path in the server configuration information;
and performing matching rendering based on the server template file and the supply chain finance statistical data to obtain a supply chain finance statistical data file.
Specifically, in step 140, the process of generating the statistical data file of the supply chain finance according to the statistical data of the supply chain finance and the server configuration information may specifically include:
firstly, a configuration file path in the server configuration information can be obtained, and a server template file under the configuration file path can be determined according to the configuration file path, namely, the server template file under the configuration file path can be obtained through configuration file path inquiry;
And then, generating a final required statistical data file of the supply chain finance according to the server template file and the supply chain finance statistical data, namely carrying out matched rendering on the supply chain finance statistical data according to the server template file, so as to obtain the statistical data file of the supply chain finance corresponding to the template, and sending the statistical data file to the client, so that a user at the client side can acquire the required downloaded statistical data file, and the statistical data downloading of the supply chain finance is realized.
Here, the frame matching may be specifically performed on the supply chain financial statistics data and the server template file, for example, matching the supply chain financial template name, the service start date, the expiration date, the service personnel information, the service type, the supply chain financial institution, the service statistics detail, the service total number information, etc., fig. 2 is an exemplary diagram of a rendering template for matching rendering provided in the present invention, as shown in fig. 2, one is "$+ object name" rendering, that is, rendering the supply chain financial statistics data to the excel template file, and the other is "$+ excel function" rendering, that is, processing the supply chain financial statistics data with excel, where "G" represents a G column in excel. And information integration is carried out on the basis, so that a statistical data file of the supply chain finance is obtained.
In the embodiment of the invention, the server template file obtained through information configuration standardizes the downloading of the financial statistical data of the supply chain, so that the statistical data file obtained by downloading is more regular, and a user can specify the statistical data downloading format and standard according to the rule.
Based on the above embodiment, the server configuration information further includes a download file path;
in step 140, a statistics file of the supply chain finance is generated, which further includes:
acquiring file names of statistical data files;
and storing the statistical data file based on the download file path in the server configuration information and the file name of the statistical data file.
Specifically, the service system further includes an input/output stream of the statistics file, the statistics file may be stored in the server through a file input stream, and the statistics file may be sent to the client through the file output stream.
Specifically, for file input stream, file storage is performed, firstly, the file name of the statistical data file can be obtained, then the statistical data file can be stored according to the file name and the download file path in the server configuration information, and then the statistical data file corresponding to the file name can be stored to the position appointed by the download file path in the server.
The statistical data downloading device of the supply chain finance provided by the invention is described below, and the statistical data downloading device of the supply chain finance and the statistical data downloading method of the supply chain finance described below can be correspondingly referred to each other.
Fig. 3 is a schematic structural diagram of a supply chain finance statistics downloading device provided by the present invention, as shown in fig. 3, the device includes:
a receiving module 310, configured to receive a statistical data downloading request, where the statistical data downloading request is generated and sent by a client corresponding to a user based on a user requirement of the user;
the configuration module 320 is configured to perform information configuration based on the statistical data download request, obtain database configuration information and server configuration information, and verify the database configuration information;
the query module 330 is configured to perform a data query from a supply chain financial statistics database based on the database configuration information to obtain supply chain financial statistics data if the verification passes;
and the downloading module 340 is configured to generate a statistics file of the supply chain finance based on the supply chain finance statistics data and the server configuration information, and send the statistics file to the client.
According to the statistical data downloading device for the supply chain finance, information configuration is carried out through the statistical data downloading request generated on the basis of user requirements, database configuration information is checked, under the condition that the checking is passed, the statistical data file is obtained through inquiring and downloading based on the database configuration information and server configuration information, the statistical data file is sent to a client, decoupling of business logic and statistical data downloading logic is achieved, the defect that the logic matched with the business logic needs to be modified due to logical linkage of business functions and statistical data downloading in the traditional scheme, the cost of the requirement change is increased, the efficiency of the statistical data downloading is reduced is overcome, corresponding configuration information can be adjusted when the statistical data downloading field needs to be adjusted through information configuration, the modification cost caused by user requirement change is reduced, the efficiency of the statistical data downloading is further guaranteed, and the rapid requirement change is achieved.
Based on the above embodiment, the database configuration information includes a statistics download main key, and statistics download information, statistics download query component information, and supply chain financial field information corresponding to the statistics download main key; the server configuration information comprises a configuration file path and a server template file under the configuration file path.
Based on the above embodiment, the query module 330 is configured to:
determining statistical data downloading information, statistical data downloading query component information and supply chain financial field information corresponding to a statistical data downloading main key based on the statistical data downloading main key in the database configuration information;
based on the download query statement corresponding to the statistical data download information and the download query condition corresponding to the statistical data download query component information, carrying out data query from a supply chain financial statistical database to obtain query statistical data;
and performing paging detection based on the query statistics, acquiring the query statistics of the current page under the condition of paging the query statistics, and determining the supply chain financial statistics based on the query statistics of the current page and the supply chain financial field information.
Based on the above embodiment, the configuration module 320 is configured to:
acquiring user identity information of the user based on the statistical data downloading request;
based on the user identity information, carrying out statistic data downloading permission detection;
and checking the database configuration information under the condition that the detection is passed.
Based on the above embodiment, the configuration module 320 is configured to:
performing at least one of query verification, condition verification and field verification on the database configuration information;
the query verification is to verify the download query statement corresponding to the statistical data download information; the condition verification is to verify the downloading query condition corresponding to the statistical data downloading query component information; and the field verification is to verify the length and width of the word segment in the supply chain financial field information.
Based on the above embodiment, the download module 340 is configured to:
determining a server template file under a configuration file path based on the configuration file path in the server configuration information;
and performing matching rendering based on the server template file and the supply chain finance statistical data to obtain a supply chain finance statistical data file.
Based on the above embodiment, the server configuration information further includes a download file path;
the apparatus further comprises an input module for:
acquiring the file name of the statistical data file;
and storing the statistical data file based on the download file path in the server configuration information and the file name of the statistical data file.
Fig. 4 illustrates a physical schematic diagram of an electronic device, as shown in fig. 4, which may include: processor 410, communication interface (Communications Interface) 420, memory 430 and communication bus 440, wherein processor 410, communication interface 420 and memory 430 communicate with each other via communication bus 440. The processor 410 may invoke logic instructions in the memory 430 to perform a supply chain financial statistics download method comprising: receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user; information configuration is carried out based on the statistical data downloading request, database configuration information and server configuration information are obtained, and verification is carried out on the database configuration information; under the condition that verification is passed, based on the database configuration information, carrying out data query from a supply chain financial statistics database to obtain supply chain financial statistics data; generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information, and sending the statistical data file to the client.
Further, the logic instructions in the memory 430 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform a method of downloading statistical data of supply chain finance provided by the methods described above, the method comprising: receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user; information configuration is carried out based on the statistical data downloading request, database configuration information and server configuration information are obtained, and verification is carried out on the database configuration information; under the condition that verification is passed, based on the database configuration information, carrying out data query from a supply chain financial statistics database to obtain supply chain financial statistics data; generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information, and sending the statistical data file to the client.
In yet another aspect, the present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform a method of downloading statistical data of supply chain finance provided by the methods described above, the method comprising: receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user; information configuration is carried out based on the statistical data downloading request, database configuration information and server configuration information are obtained, and verification is carried out on the database configuration information; under the condition that verification is passed, based on the database configuration information, carrying out data query from a supply chain financial statistics database to obtain supply chain financial statistics data; generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information, and sending the statistical data file to the client.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for downloading statistical data of supply chain finance, comprising:
receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user;
information configuration is carried out based on the statistical data downloading request, database configuration information and server configuration information are obtained, and verification is carried out on the database configuration information;
under the condition that verification is passed, based on the database configuration information, carrying out data query from a supply chain financial statistics database to obtain supply chain financial statistics data;
generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information, and sending the statistical data file to the client.
2. The method for downloading statistical data of supply chain finance according to claim 1, wherein the database configuration information comprises a statistical data downloading main key, and statistical data downloading information, statistical data downloading query component information and supply chain finance field information corresponding to the statistical data downloading main key; the server configuration information comprises a configuration file path and a server template file under the configuration file path.
3. The method for downloading statistical data of supply chain finance according to claim 1, wherein the step of performing data query from a supply chain finance statistical database based on the database configuration information to obtain the supply chain finance statistical data comprises the steps of:
determining statistical data downloading information, statistical data downloading query component information and supply chain financial field information corresponding to a statistical data downloading main key based on the statistical data downloading main key in the database configuration information;
based on the download query statement corresponding to the statistical data download information and the download query condition corresponding to the statistical data download query component information, carrying out data query from a supply chain financial statistical database to obtain query statistical data;
and performing paging detection based on the query statistics, acquiring the query statistics of the current page under the condition of paging the query statistics, and determining the supply chain financial statistics based on the query statistics of the current page and the supply chain financial field information.
4. The supply chain finance statistics download method according to claim 2, wherein the verifying the database configuration information includes:
Acquiring user identity information of the user based on the statistical data downloading request;
based on the user identity information, carrying out statistic data downloading permission detection;
and checking the database configuration information under the condition that the detection is passed.
5. The method of supply chain finance statistics download according to claim 2 or 4, wherein the verifying the database configuration information includes:
performing at least one of query verification, condition verification and field verification on the database configuration information;
the query verification is to verify the download query statement corresponding to the statistical data download information; the condition verification is to verify the downloading query condition corresponding to the statistical data downloading query component information; and the field verification is to verify the length and width of the word segment in the supply chain financial field information.
6. The supply chain finance statistics download method according to any one of claims 1 to 4, wherein the generating a supply chain finance statistics file based on the supply chain finance statistics and the server configuration information includes:
Determining a server template file under a configuration file path based on the configuration file path in the server configuration information;
and performing matching rendering based on the server template file and the supply chain finance statistical data to obtain a supply chain finance statistical data file.
7. The supply chain finance statistics download method according to any one of claims 1 to 4, wherein the server configuration information further includes a download file path;
the generating a supply chain financial statistics file further comprises:
acquiring the file name of the statistical data file;
and storing the statistical data file based on the download file path in the server configuration information and the file name of the statistical data file.
8. A supply chain financial statistics download apparatus, comprising:
the receiving module is used for receiving a statistical data downloading request, wherein the statistical data downloading request is generated and sent by a client corresponding to a user based on the user requirement of the user;
the configuration module is used for carrying out information configuration based on the statistical data downloading request to obtain database configuration information and server configuration information, and checking the database configuration information;
The query module is used for carrying out data query from the supply chain financial statistical database based on the database configuration information under the condition that the verification is passed, so as to obtain the supply chain financial statistical data;
and the downloading module is used for generating a statistical data file of the supply chain finance based on the supply chain finance statistical data and the server configuration information and sending the statistical data file to the client.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the supply chain financial statistics download method of any one of claims 1 to 7 when the program is executed.
10. A non-transitory computer readable storage medium having stored thereon a computer program, which when executed by a processor implements the supply chain financial statistics data downloading method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310851289.7A CN116561198A (en) | 2023-07-12 | 2023-07-12 | Statistical data downloading method and device for supply chain finance |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310851289.7A CN116561198A (en) | 2023-07-12 | 2023-07-12 | Statistical data downloading method and device for supply chain finance |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116561198A true CN116561198A (en) | 2023-08-08 |
Family
ID=87503945
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310851289.7A Pending CN116561198A (en) | 2023-07-12 | 2023-07-12 | Statistical data downloading method and device for supply chain finance |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116561198A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050187969A1 (en) * | 2003-12-24 | 2005-08-25 | Chaudri Bikramjit S. | Investment database application |
| US20050268218A1 (en) * | 2004-04-28 | 2005-12-01 | Mitsuhiko Yoshimura | Method and system for checking downloaded input form |
| KR20100050608A (en) * | 2008-10-21 | 2010-05-14 | 에스케이 텔레콤주식회사 | Method and apparatus for providing download descriptor in content download |
| US20140007080A1 (en) * | 2012-06-27 | 2014-01-02 | Clearside, Inc. | System and method for dynamically creating executable files |
| CN109710665A (en) * | 2018-08-17 | 2019-05-03 | 深圳壹账通智能科技有限公司 | Report downloading method, apparatus, equipment and readable storage medium storing program for executing |
| CN111666745A (en) * | 2020-06-03 | 2020-09-15 | 中国建设银行股份有限公司 | File downloading method, device, server and medium |
| CN113467808A (en) * | 2021-07-12 | 2021-10-01 | 卡斯柯信号有限公司 | Redundant network-based trackside safety platform automatic upgrading method and system |
| WO2021238796A1 (en) * | 2020-05-26 | 2021-12-02 | 苏宁易购集团股份有限公司 | Asynchronous processing method, apparatus, and system for download tasks, and storage medium |
| CN114650281A (en) * | 2020-12-17 | 2022-06-21 | 腾讯科技（深圳）有限公司 | File downloading method, device, equipment and storage medium based on complex network |
-
2023
- 2023-07-12 CN CN202310851289.7A patent/CN116561198A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050187969A1 (en) * | 2003-12-24 | 2005-08-25 | Chaudri Bikramjit S. | Investment database application |
| US20050268218A1 (en) * | 2004-04-28 | 2005-12-01 | Mitsuhiko Yoshimura | Method and system for checking downloaded input form |
| KR20100050608A (en) * | 2008-10-21 | 2010-05-14 | 에스케이 텔레콤주식회사 | Method and apparatus for providing download descriptor in content download |
| US20140007080A1 (en) * | 2012-06-27 | 2014-01-02 | Clearside, Inc. | System and method for dynamically creating executable files |
| CN109710665A (en) * | 2018-08-17 | 2019-05-03 | 深圳壹账通智能科技有限公司 | Report downloading method, apparatus, equipment and readable storage medium storing program for executing |
| WO2021238796A1 (en) * | 2020-05-26 | 2021-12-02 | 苏宁易购集团股份有限公司 | Asynchronous processing method, apparatus, and system for download tasks, and storage medium |
| CN111666745A (en) * | 2020-06-03 | 2020-09-15 | 中国建设银行股份有限公司 | File downloading method, device, server and medium |
| CN114650281A (en) * | 2020-12-17 | 2022-06-21 | 腾讯科技（深圳）有限公司 | File downloading method, device, equipment and storage medium based on complex network |
| CN113467808A (en) * | 2021-07-12 | 2021-10-01 | 卡斯柯信号有限公司 | Redundant network-based trackside safety platform automatic upgrading method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108564339B (en) | Account management method, device, terminal equipment and storage medium | |
| CN109558575B (en) | Online form editing method, online form editing device, computer equipment and storage medium | |
| CN104391934B (en) | Data verification method and device | |
| CN107784552B (en) | Information push task execution method and device, computer equipment and storage medium | |
| CN111435367B (en) | Knowledge graph construction method, system, equipment and storage medium | |
| CN113901075B (en) | Method, device, computer equipment and storage medium for generating SQL statements | |
| CN106815725B (en) | Transaction verification method and device | |
| CN110852719A (en) | Electronic contract signing method and device, electronic equipment and storage medium | |
| CN111159016A (en) | Standard detection method and device | |
| CN112800127A (en) | Data mining analysis method and device based on transaction bill | |
| CN110516258B (en) | Data verification method and device, storage medium and electronic device | |
| CN116561198A (en) | Statistical data downloading method and device for supply chain finance | |
| CN120353711A (en) | Test case generation method, device, electronic device and storage medium | |
| CN111767543A (en) | Method, device and equipment for determining replay attack vulnerability and readable storage medium | |
| CN113938481A (en) | Receipt processing method, processing device, electronic device and readable storage medium | |
| CN108804889B (en) | Website registration method and device | |
| US20170134389A1 (en) | Third Party Paywall Authentication System | |
| CN116401148A (en) | Form data verification method and device | |
| CN111061885A (en) | Electronic document making method and system | |
| CN117057922A (en) | Financial asset management method, device, equipment and medium based on page display | |
| CN111930535B (en) | Application function calling method and device, computer equipment and storage medium | |
| CN115687385A (en) | A data query method and system | |
| CA3137185A1 (en) | License content error correction method, apparutus, and system | |
| CN113886245A (en) | System acceptance method, device, computer equipment and medium based on artificial intelligence | |
| CN112328745A (en) | Service application method, device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20230808 |