Summary of the invention
Technical matters to be solved by this invention is for above-mentioned deficiency of the prior art, a kind of ticket business classifying system and method is provided, it can be carried out unified management, monitoring, ticket information implementation real-time oversight is controlled by the ticket information of traffic route, grasp in time ticket information dynamic, by sorting center, realize the sorting of ticketing service.
The technical solution adopted for the present invention to solve the technical problems is: a kind of ticket business classifying system, comprise data acquisition subsystem, data verification subsystem, financial clearing subsystem, reconciliation subsystem, clearing subsystem, report form statistics subsystem, system configuration ADMINISTRATION SUBSYSTEM and system monitoring ADMINISTRATION SUBSYSTEM; Also comprise external system and clearing rules ADMINISTRATION SUBSYSTEM, described external system comprises clearing bank and ticket business classifying system for settling account; Above-mentioned data acquisition acquisition subsystem, for communicating by letter with external system, receives the data from external system, and data by type of transaction and business date, leave in the memory module of ticket business classifying system for settling account after pretreatment; Above-mentioned data verification subsystem, serves by backstage start by set date batch processing, to the transaction data collecting the same day, by type of transaction, carries out in batches repeated authentication, and the write verification result table of authentication failed, provides the interface of access the result simultaneously; Above-mentioned financial clearing subsystem, by backstage start by set date sorting batch processing, serve, to, by the transaction data of data verification, according to set clearing rules, carry out step by step sorting and the process data of sorting is write to one-level sorting result table and secondary sorting result table; Above-mentioned reconciliation subsystem, after every day, sorting was finished dealing with, according to sorting main body tabulate statistics sorting result, generate one-level reconciliation data and secondary reconciliation data, service interface is provided simultaneously, for external system inquiry reconciliation data, and receives the reconciliation result that external system is uploaded; Above-mentioned clearing subsystem, for sorting main body provides inquiry allocation of the funds service interface, and returns to allocation of the funds result for the clearing bank in external system service interface is provided, and receives allocation of the funds result and also upgrades corresponding allocation of the funds data; Above-mentioned report form statistics subsystem, by the statistics service of backstage start by set date, after day, sorting processing finished, adds up all kinds of report datas, and writes corresponding database table, with the form of service interface, provides external system inquiry; Said system configuration management subsystem, for completing maintenance, the management function of ticket business classifying system for settling account parameter, provides maintenance management function to the required configuration parameter of ticket business classifying system for settling account, to the underlying parameter of each circuit ticketing system, only provides query function; Said system monitoring management subsystem, the processing procedure of monitoring score-clearing system background service, provides log management, alarm logging management and sorting to process monitoring function; Above-mentioned clearing rules ADMINISTRATION SUBSYSTEM, provides ticket fee sorting ratio, safeguards the sorting ratio generating and generates relevant allocation algorithm, the weight proportion information of sorting ratio.
Further: said external system also comprises stored value card system, the marketing and planning system, the control system of urban transportation card system and Department of Communications.
The invention also discloses a kind of ticket business classifying method that adopts above-mentioned ticket business classifying system, the data acquisition flow that comprises data acquisition subsystem; The status poll service procedure of data verification subsystem, inquiry checking process, booking checking process, station yard out of the station pairing checking process and card remaining sum checking flow process; The inquiry business type sorting flow process of financial clearing subsystem and departures business sorting flow process; Reconciliation data flow is confirmed in the request reconciliation data flow of reconciliation subsystem, request reconciliation detailed data flow process and request; The settlement process of clearing subsystem; Report Subsystem flow process; System configuration ADMINISTRATION SUBSYSTEM flow process; The data receiver of system monitoring ADMINISTRATION SUBSYSTEM is monitored flow process, data send monitoring flow process, transaction data monitoring flow process, financial clearing monitoring flow process, reconciliation data generation monitoring flow process, the monitoring flow process of entering account and allocation of the funds data and generate monitoring flow process; And the sorting rule subsystem flow process of sorting rule subsystem, clearing rules management process and service clearing rules management process.
The present invention compared with prior art has the following advantages:
In the present invention, ticket business classifying system is a set of comprehensive central computer system, the needs of its main business need satisfaction integrated traffic development strategy; Meet and to realize the needs that multi-line, many subjects of operation put into effect; Meet the needs of accessible transfer between each circuit; Meet the requirement that realizes ticket business classifying under diversification operation condition; Meet the needs of realizing government regulation under diversification operation condition; Meet the needs of Rail traffic network operation management; Meet the needs of inter-city rail transit network ticketing system resource sharing;
The present invention can gather the operation management data with each circuit of statistical dependence, receives and process ticket dealing data, volume of the flow of passengers data and other related datas that each circuit is uploaded; The present invention can also realize the sorting clearance function of ticket dealing data in inter-city rail transit line range, completes clearance, reconciliation and minute account work of inter-city rail transit inside; The transaction data that the present invention and the exchange of outside related system are used in inter-city rail transit system, completes clearance, reconciliation and minute account work with external system; The present invention also provides the support of data, services for related systems such as the marketing and planning systems.
Embodiment
Below in conjunction with embodiment, the specific embodiment of the invention is described:
As shown in Figure 1, a kind of ticket business classifying system, comprises data acquisition subsystem, data verification subsystem, financial clearing subsystem, reconciliation subsystem, clearing subsystem, report form statistics subsystem, system configuration ADMINISTRATION SUBSYSTEM and system monitoring ADMINISTRATION SUBSYSTEM; Also comprise external system and clearing rules ADMINISTRATION SUBSYSTEM, described external system comprises clearing bank and ticket business classifying system for settling account; Above-mentioned data acquisition acquisition subsystem, for communicating by letter with external system, receives the data from external system, and data by type of transaction and business date, leave in the memory module of ticket business classifying system for settling account after pretreatment; Above-mentioned data verification subsystem, serves by backstage start by set date batch processing, to the transaction data collecting the same day, by type of transaction, carries out in batches repeated authentication, and the write verification result table of authentication failed, provides the interface of access the result simultaneously; Above-mentioned financial clearing subsystem, by backstage start by set date sorting batch processing, serve, to, by the transaction data of data verification, according to set clearing rules, carry out step by step sorting and the process data of sorting is write to one-level sorting result table and secondary sorting result table; Above-mentioned reconciliation subsystem, after every day, sorting was finished dealing with, according to sorting main body tabulate statistics sorting result, generate one-level reconciliation data and secondary reconciliation data, service interface is provided simultaneously, for external system inquiry reconciliation data, and receives the reconciliation result that external system is uploaded; Above-mentioned clearing subsystem, for sorting main body provides inquiry allocation of the funds service interface, and returns to allocation of the funds result for the clearing bank in external system service interface is provided, and receives allocation of the funds result and also upgrades corresponding allocation of the funds data; Above-mentioned report form statistics subsystem, by the statistics service of backstage start by set date, after day, sorting processing finished, adds up all kinds of report datas, and writes corresponding database table, with the form of service interface, provides external system inquiry; Said system configuration management subsystem, for completing maintenance, the management function of ticket business classifying system for settling account parameter, provides maintenance management function to the required configuration parameter of ticket business classifying system for settling account, to the underlying parameter of each circuit ticketing system, only provides query function; Said system monitoring management subsystem, the processing procedure of monitoring score-clearing system background service, provides log management, alarm logging management and sorting to process monitoring function; Above-mentioned clearing rules ADMINISTRATION SUBSYSTEM, provides ticket fee sorting ratio, safeguards the sorting ratio generating and generates relevant allocation algorithm, the weight proportion information of sorting ratio.
With reference to figure 1, described external system also comprises stored value card system equally, the marketing and planning system, the control system of urban transportation card system and Department of Communications.
In the present invention, adopt a kind of ticket business classifying method of above-mentioned ticket business classifying system, the data acquisition flow that comprises data acquisition subsystem; The status poll service procedure of data verification subsystem, inquiry checking process, booking checking process, station yard out of the station pairing checking process and card remaining sum checking flow process; The inquiry business type sorting flow process of financial clearing subsystem and departures business sorting flow process; Reconciliation data flow is confirmed in the request reconciliation data flow of reconciliation subsystem, request reconciliation detailed data flow process and request; The settlement process of clearing subsystem; Report Subsystem flow process; System configuration ADMINISTRATION SUBSYSTEM flow process; The data receiver of system monitoring ADMINISTRATION SUBSYSTEM is monitored flow process, data send monitoring flow process, transaction data monitoring flow process, financial clearing monitoring flow process, reconciliation data generation monitoring flow process, the monitoring flow process of entering account and allocation of the funds data and generate monitoring flow process; And the sorting rule subsystem flow process of sorting rule subsystem, clearing rules management process and service clearing rules management process.
As shown in Figure 2, described data acquisition flow comprises following steps:
1, the WebService/DCS interface of ticket business classifying system receives the transaction data that external system data source sends; 2, the data that receive are resolved, write daily record/source file; 3, data are carried out to legitimate verification.Whether comprise that whether TAC code is correct, whether the field of transaction record is correct, be blacklist data, comprises the legitimacy of dealing money, the several data format verification such as date format mistake; 4, the data based type of transaction by checking writes in the transaction data table of current date, comprise inquiry, enter the station, departures, booking, buy one's ticket after normal time, the transaction data table such as returned ticket, Stored Value; 5, the data by checking are not first recorded to and upload transaction errors table, then write in the transaction data table of current date, and mark verification state is non-legal, then return data mistake are to business datum source yet; 6, the transaction data of non-current date, the inquiry business date is to the repeatability of all data trade table checking datas of current date; 7, whether inquire data, if do not inquire data, data acquisition success, returns to successful data acquisition result to business datum source; If 8 inquire data, the verification state that upgrades these data is repeating data, and returns to repeating data to business datum source.
As shown in Figure 3 and Figure 4, in described data verification subsystem, described data query subsystem comprises following steps: 1, the status poll service interface of ACC is called in business datum source, ACC services request processing logic layer; 2, processing logic layer judges whether batch processing completes, if do not completed, return and wait for that, to interface, if completed, inquiring and authenticating result table, then returns results, how many sortings, how many not sorting to interface; Described inquiry checking process is according to trade company's code, and serial number and time, inquiry current date tran list, if there is repeating data write verification result table, if not then finishes; Described booking checking process is according to ticket card number, and serial number and time, inquiry current date tran list, if there is repeating data write verification result table, if not then finishes; Described station yard pairing checking process out of the station comprises following steps: 1, take out departures record, judge whether the station yard that enters the station is empty, gets tickets/card number; 2, according to ticket/card number, inquire about the record that enters the station, by time backward sequence, find out the nearest record that enters the station, and the mistiming is less than or equal to the maximum duration interval of system regulation; 3, judge whether to find record, if find record, the station yard that enters the station is updated to departures and shows in corresponding departures record; If can not find record, these departures of mark are recorded as illegally; 4, finish; Described card remaining sum checking flow process comprises following steps: 1, read outbound data or load value data; 2, gather outbound data or load value data record, by card and time, sort; 3, according to card number, obtain the remaining sum of blocking in card balance sheet, then with wallet balances in transaction record, compare; 4, whether the remaining sum in judgement card balance sheet is more than or equal to wallet balances; If be more than or equal to, upgrade the remaining sum in balance sheet; If be not more than, equal, mark this be recorded as illegally; 5, finish.
As shown in Figure 5 and Figure 6, in described financial clearing subsystem,
Described inquiry business type sorting flow process comprises following steps: 1, reading out data, according to station yard and type of transaction, obtains corresponding service fee; 2, according to station yard, obtain corresponding one-level sorting main body, service fee, sorting main body, business date, verification state etc. are write to one-level sorting result table; If 3 one-level sortings are processed successfully, jump to step (4), otherwise revise one-level sorting outcome record state, be illegal, finish sorting treatment scheme; 4,, according to station yard and type of transaction, obtain all sorting main bodys and the ratio of service fee and participation sorting; 5, judged whether sorting main body and ratio, if not, finished; Have and jump to step (6); 6, according to sorting ratio and the amount of money, calculate each sorting main body gained service fee, result is write to secondary sorting result table; 7, generate reconciliation mathematical logic and carry out one-level, secondary; 8, according to one-level sorting data result table data, according to sorting main body Classifying Sum, result is write to one-level reconciliation table; 9, according to secondary sorting data result table data, according to sorting main body Classifying Sum, result is write to secondary reconciliation table; 10, call the service interface that issues reconciliation data; 11, finish;
Described departures type of service sorting flow process comprises following steps:
1, Pearl River Delta ticketing service product, need select different expense standards and rule according to product type, ticket Card Type, obtains corresponding one-level sorting main body and corresponding total charge; Non-Pearl River Delta ticketing service product, as stored value card, magnetic card etc., according to hair fastener main body, information such as the standard admission fee of one-level sorting main body corresponding to hair fastener main body, OD section, verification states, writes one-level sorting result table; 2,, in Pearl River Delta ticketing service product, for one-way ticket and stored-value ticket, the accurate admission fee of OD segment table of one-level sorting main body corresponding to hair fastener main body and the generation of utilization rule, and verification state writes in one-level sorting result table; For metering ticket and periodical ticket, according to corresponding fees policy collection of funds, write in the one-level sorting result table on the same day; If 3 one-level sortings are processed successfully, continue; If failure, revises the state of these data of one-level sorting result for illegal, and finishes sorting treatment scheme.4, according to OD, inquire about corresponding clearing rules, if there is no clearing rules, the state of revising these data in one-level sorting result table is dispute, and finishes sorting treatment scheme; If there is clearing rules, continue.5,, for one-way ticket and stored-value ticket, according to entering the station, station yard and departures station yard are inquired about receivable service fee and are participated in all sorting main bodys of service sorting and corresponding sorting ratio; For metering ticket and periodical ticket, according to respective rule, carry out sorting, and result is write to secondary sorting on same day result table; 6, for one-way ticket and stored-value ticket, calculate each sorting main body gained service fee, write secondary sorting result table; 7, for one-way ticket and stored-value ticket, according to OD station yard, inquire about corresponding clearing rules, without clearing rules, be labeled as dispute data; 8, for one-way ticket and stored-value ticket, according to clearing rules, carry out sorting, and write secondary sorting result table, wherein, the sorting amount of money=standard admission fee-standard service fee out of the station; 9, generate reconciliation mathematical logic and carry out one-level, secondary; 10, according to one-level sorting data result table data, according to sorting main body Classifying Sum, write one-level reconciliation table; 11, according to secondary sorting data result table data, according to sorting main body Classifying Sum, write secondary reconciliation table; 12, call the service interface that issues reconciliation data; 13, finish.
As shown in Figure 8, in described reconciliation subsystem,
Described request reconciliation data flow comprises following steps: 1, the WebService interface at ticket business classifying center receives the reconciliation request msg that external system data source sends; 2, judgement request reconciliation data are one-level reconciliation data or secondary reconciliation data; 3, according to judged result and sorting type of subject, inquiry reconciliation result table; 4, return to Query Result and finish;
Described request reconciliation detailed data flow process comprises following steps: 1, the WebService interface of ticket business classifying system receives the reconciliation request msg that external system data source sends; 2, judgement request reconciliation data are one-level reconciliation data or secondary reconciliation data; 3, according to judged result and sorting type of subject, inquiry reconciliation detail list; 4, return to the detailed result of inquiry and finish;
Described request confirms that reconciliation data flow comprises following steps: 1, the WebService interface of ACC receives the confirmation reconciliation request msg that external system data source sends; 2,, according to sorting type of subject, reconciliation result is updated to reconciliation result table; 3, finish.
In the inventive method, in described clearing subsystem, comprise request allocation of the funds data and upload and draw account result flow process;
Described request allocation of the funds data flow comprises following steps: 1, the WebService interface of ticket business classifying system receives the allocation of the funds request of data that external system data source sends; 2, according to firsts and seconds clearance result combined data, write the table of entering account; 3, firsts and seconds sorting result data is transferred to history lists; 4, judgement request sorting type, credit side forwards step (5) to, and debit forwards step (6) to; 5,, according to credit side's sorting type of theme, inquire about and enter account data and put back to end; 6, judge whether credit side's allocation of the funds completes, returns to the allocation of the funds also do not complete as do not completed, finish; 7,, according to debit's sorting type of subject, inquiry allocation of the funds data are also returned;
The described stroke account result flow process of uploading comprises following steps: 1, the WebService interface of ticket business classifying system receives stroke account result that clearing bank sends; 2, more new funds is drawn account data.
As shown in Figure 9, described system configuration ADMINISTRATION SUBSYSTEM flow process comprises parameter management flow process, start-up parameter configuration management flow process, type of service management process, sorting main body management process, business datum source control flow process, system types management process and inquiry into balance flow process.
As shown in Figure 10 to 16, in described system monitoring ADMINISTRATION SUBSYSTEM,
Described data receiver monitoring flow process comprises following steps: 1, start; 2, reading out data receives abnormal information; 3, output abnormality information is to control and monitor console; 4, managerial personnel according to circumstances adjust, and wherein data connect two kinds of processing modes extremely: a) check network condition; B) check and connect configuration; Data integrity is not by there being two kinds of processing modes: whether the key that a) checks both sides consistent, b) whether the other side send invalid data etc.; Data legitimacy is not by notifying the other side to check source data; Data-switching extremely checks data and relevant configuration; 5, complete;
Described data send monitoring flow process and comprise following steps: 1, start; 2, reading out data sends abnormal information; 3, output abnormality information is to control and monitor console and give a warning; 4, managerial personnel according to circumstances adjust; 5, complete;
Described transaction data verification monitoring flow process comprises following steps: 1, start; 2, read transaction data verification abnormal information; 3, output abnormality information is to control and monitor console and give a warning; 4, managerial personnel according to circumstances adjust; 5, whether verification can be recovered, beginning can not be back to; 6, can recover verification and recover abnormal transaction data state to be verified; 7, complete;
Described financial clearing monitoring flow process comprises following steps: 1, start; 2, read the reconciliation data exception information that generates; 3, output abnormality information is to control and monitor console and give a warning; 4, managerial personnel according to circumstances adjust; 5, whether reconciliation data can be regenerated, beginning can not be back to; 6, can regenerate reconciliation data and restart the operation of generation reconciliation data; 7, complete;
The described monitoring flow process of entering account comprises following steps: 1, start; 2, read the abnormal information of entering account; 3, output abnormality information is to control and monitor console and give a warning; 4, managerial personnel according to circumstances adjust; 5, complete;
Described reconciliation data generate monitoring flow process and comprise following steps: 1, start; 2, read financial clearing abnormal information; 3, output abnormality information is to control and monitor console and give a warning; 4, managerial personnel according to circumstances adjust; 5, whether again sorting, can not be back to beginning; 6, sorting recovers extremely to treat sorting transaction data state again; 7, complete;
Described allocation of the funds data generate monitoring flow process and comprise following steps: 1, start; 2, read the allocation of the funds data exception information that generates; 3, output abnormality information is to control and monitor console and give a warning; 4, managerial personnel according to circumstances adjust; 5, whether allocation of the funds data can be regenerated, beginning can not be back to; 6, can regenerate allocation of the funds data and restart the operation of generation allocation of the funds data; 7, complete.
As shown in figure 17, in described clearing rules ADMINISTRATION SUBSYSTEM,
Clearing rules ADMINISTRATION SUBSYSTEM flow process comprises following steps: 1, start; 2, enter algorithm management interface; 3, clearing rules algorithm information is checked; 4, complete;
Described clearing rules management process comprises following steps: 1, start; 2, enter the main interface of algorithm management; 3, select sorting main body; 4, choose sorting principle; 5, choose the method for assigning weight; 6, generate sorting ratio; 7, safeguard sorting ratio; 8, be saved to database; 9, complete;
Described service clearing rules management system comprises following steps: 1, start; 2, the cost ratio that configuration service is taken; 3, according to service content and station yard, obtain clearing rules; 4,, according to clearing rules, calculate the service fee that each sorting main body is collected; 5, be saved to database; 6, complete.