CN110263307A - Report form generation method, server and computer readable storage medium - Google Patents

Report form generation method, server and computer readable storage medium Download PDF

Info

Publication number
CN110263307A
CN110263307A CN201910298385.7A CN201910298385A CN110263307A CN 110263307 A CN110263307 A CN 110263307A CN 201910298385 A CN201910298385 A CN 201910298385A CN 110263307 A CN110263307 A CN 110263307A
Authority
CN
China
Prior art keywords
report
data
target
target report
logic
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
Application number
CN201910298385.7A
Other languages
Chinese (zh)
Inventor
陈欢
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chongqing Financial Assets Exchange LLC
Original Assignee
Chongqing Financial Assets Exchange LLC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Chongqing Financial Assets Exchange LLC filed Critical Chongqing Financial Assets Exchange LLC
Priority to CN201910298385.7A priority Critical patent/CN110263307A/en
Publication of CN110263307A publication Critical patent/CN110263307A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The present invention relates to data display technique, a kind of report form generation method, server and computer readable storage medium are disclosed, which comprises be configured to make a report in original text in the budget of a unit and final accounts make a report on and carry out the data that data are filled in original text and fill in logic;Judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if so, saving the data made a report on to presetting database, if it is not, then exporting prompt information, fills in people with prompt and modifies to the data made a report on;Report export request is received, and report template corresponding with the ID is obtained according to the ID of target report;Target report data is obtained from the presetting database according to the data target;The target report is generated based on the template framework and the target report data.The present invention can be achieved to reduce cumbersome report form statistics work, improves report generation efficiency, liberates manpower.

Description

Report form generation method, server and computer readable storage medium
Technical field
The present invention relates to technical field of data processing more particularly to report form generation method, server and computer-readable deposit Storage media.
Background technique
It is typically necessary in colleges and universities, government department, public institution at present and financial budget and final accounts is worked out, so And existing establishment and management also rest on the boostrap next stage, are worked out and are managed using paper document.Budget and final accounts are compiled Mode processed it is single, inefficient, if needing to work out nearly hundred various reports every year, huge financial budget and final accounts income, The statistics for paying data will lead to and need more personnel and cumbersome inefficient.Therefore, how to design it is a kind of can quickly work out it is pre- It calculates and the method for statement becomes a kind of urgent problem to be solved.
Summary of the invention
It, can be in view of this, the present invention proposes a kind of report form generation method, server and computer readable storage medium It realizes and reduces cumbersome report form statistics work, improve report generation efficiency, liberate manpower.
Firstly, to achieve the above object, the present invention proposes that a kind of server, the server include memory, processing Device is stored with the report generating system that can be run on the processor on the memory, and the report generating system is by institute It states when processor executes and realizes following steps:
It is configured to make a report in original text in the budget of a unit and final accounts makes a report on and carry out the data that data are filled in original text and fill in patrol Volume, wherein the data fill in the logic auditing formula that logic includes selective critical field and audits for data;
Judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if so, the data made a report on are protected It deposits to presetting database, if it is not, then exporting prompt information, people is filled in prompt and is modified to the data made a report on;
Report export request is received, and report template corresponding with the ID is obtained according to the ID of target report, wherein The report export request packet contains the ID of the target report, and the report template includes template framework and data target;
Target report data is obtained from the presetting database according to the data target;And
The target report is generated based on the template framework and the target report data.
Optionally, the described the step of target report is generated based on the template framework and the target report data Include:
The target report data is converted using default chart crossover tool, to obtain the target report number According to visual image;And
The target report is generated according to the template framework, the visual image and the target report data.
Optionally, described that the target report data is converted using default chart crossover tool, described in obtaining The step of visual image of target report data includes:
It obtains subtype and generates request, it includes that transfer function identifies that the subtype, which generates request,;
Corresponding transfer function method is obtained according to transfer function mark;And
The transfer function method is called to convert the target report data, to obtain the target report number According to visual image.
Optionally, it is described according to the data target from the presetting database obtain target report data after Step further include:
Critical field corresponding with the data target is obtained according to the data target;
According to the target report data and the critical field, judge the target report data with the presence or absence of abnormal Data;And
If there are abnormal datas for the target report data, abnormal mesh is highlighted in the visual image Mark report data.
In addition, to achieve the above object, the present invention also provides a kind of report form generation methods, it is applied to server, the report Table generating method includes:
It is configured to make a report in original text in the budget of a unit and final accounts makes a report on and carry out the data that data are filled in original text and fill in patrol Volume, wherein the data fill in the logic auditing formula that logic includes selective critical field and audits for data;
Judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if so, the data made a report on are protected It deposits to presetting database, if it is not, then exporting prompt information, people is filled in prompt and is modified to the data made a report on;
Report export request is received, and report template corresponding with the ID is obtained according to the ID of target report, wherein The report export request packet contains the ID of the target report, and the report template includes template framework and data target;
Target report data is obtained from the presetting database according to the data target;And
The target report is generated based on the template framework and the target report data.
Optionally, the described the step of target report is generated based on the template framework and the target report data Include:
The target report data is converted using default chart crossover tool, to obtain the target report number According to visual image;And
The target report is generated according to the template framework, the visual image and the target report data.
Optionally, described that the target report data is converted using default chart crossover tool, described in obtaining The step of visual image of target report data includes:
It obtains subtype and generates request, it includes that transfer function identifies that the subtype, which generates request,;
Corresponding transfer function method is obtained according to transfer function mark;And
The transfer function method is called to convert the target report data, to obtain the target report number According to visual image.
Optionally, it is described according to the data target from the presetting database obtain target report data after Step further include:
Critical field corresponding with the data target is obtained according to the data target;
According to the target report data and the critical field, judge the target report data with the presence or absence of abnormal Data;And
If there are abnormal datas for the target report data, abnormal mesh is highlighted in the visual image Mark report data.
Optionally, the critical field includes below one or more: unit fundamental property, unit execute accounting system Degree, entry property, project category, fund property, public budget financial allocation fund;The logic auditing formula is keyword Original text is made a report in section and budget and final accounts are made a report on income in original text, paid, the logical relation between surplus of carrying down data.
Further, to achieve the above object, the present invention also provides a kind of computer readable storage medium, the calculating Machine readable storage medium storing program for executing is stored with report generating system, and the report generating system can be executed by least one processor, so that At least one described processor is executed such as the step of above-mentioned report form generation method.
Compared to the prior art, report form generation method proposed by the invention, server and computer-readable storage medium Matter, first by being configured to make a report in original text in the budget of a unit and final accounts make a report on and carry out the data that data are filled in original text and fill out Write logic;Secondly judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if so, the number that will be made a report on According to saving to presetting database, if it is not, then exporting prompt information, people is filled in prompt and is modified to the data made a report on;Furthermore Report export request is received, and report template corresponding with the ID is obtained according to the ID of target report;Furthermore according to described Data target obtains target report data from the presetting database, is finally based on the template framework and the target report Table data generate the target report, so that budget is not necessarily to handle under boostrap with final accounts draft establishment report, reduce Cumbersome report form statistics work, liberates manpower, and supports report template extension, can satisfy personalized report form statistics function, mentions The high producing efficiency of report, and support tabular views visualization.
Detailed description of the invention
Fig. 1 is the schematic diagram of the optional hardware structure of server one of the present invention.
Fig. 2 is the program module schematic diagram of report generating system first embodiment of the present invention.
Fig. 3 is the implementation process diagram of report form generation method first embodiment of the present invention.
Appended drawing reference:
Server 2
Network 3
Memory 11
Processor 12
Network interface 13
Report generating system 100
Configuration module 101
Judgment module 102
Receiving module 103
Obtain module 104
Generation module 105
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, The present invention will be described in further detail.It should be appreciated that described herein, specific examples are only used to explain the present invention, It is not intended to limit the present invention.Embodiment according to the present invention, those of ordinary skill in the art are not making creative labor Every other embodiment obtained under the premise of dynamic, shall fall within the protection scope of the present invention.
It should be noted that the description for being related to " first ", " second " etc. in the present invention is used for description purposes only, without It can be interpreted as its relative importance of indication or suggestion or implicitly indicate the quantity of indicated technical characteristic.It defines as a result, The feature of " first ", " second " can explicitly or implicitly include at least one described feature.In addition, each embodiment it Between technical solution can be combined with each other, but must based on can be realized by those of ordinary skill in the art, work as technology There is conflicting or cannot achieve when and will be understood that the combination of this technical solution is not present in the combination of scheme, also not at this It invents within desired protection scope.
As shown in fig.1, being the schematic diagram of the optional hardware structure of application server 2 one of the present invention.
In the present embodiment, the application server 2 may include, but be not limited only to, and company can be in communication with each other by system bus Connect memory 11, processor 12, network interface 13.It should be pointed out that Fig. 2 illustrates only the application clothes with component 11-13 Business device 2, it should be understood that being not required for implementing all components shown, the implementation that can be substituted is more or less Component.
Wherein, the application server 2 can be rack-mount server, blade server, tower server or cabinet Formula server etc. calculates equipment, and the application server 2 can be independent server, be also possible to multiple server institutes group At server cluster.
The memory 11 include at least a type of readable storage medium storing program for executing, the readable storage medium storing program for executing include flash memory, Hard disk, multimedia card, card-type memory (for example, SD or DX memory etc.), random access storage device (RAM), static random are visited It asks memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), may be programmed read-only deposit Reservoir (PROM), magnetic storage, disk, CD etc..In some embodiments, the memory 11 can be the application The internal storage unit of server 2, such as the hard disk or memory of the application server 2.In further embodiments, described Memory 11 is also possible to the External memory equipment of the application server 2, such as is equipped on the application server 2 slotting Connect formula hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash memory Block (Flash Card) etc..Certainly, the memory 11 can also both include the internal storage unit of the application server 2 It also include its External memory equipment.In the present embodiment, the memory 11 is installed on the application server commonly used in storage 2 operating system and types of applications software, such as the program code of report generating system 100 etc..In addition, the memory 11 It can be also used for temporarily storing the Various types of data that has exported or will export.
The processor 12 can be in some embodiments central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 12 is commonly used in control institute State the overall operation of application server 2.In the present embodiment, the processor 12 is used to run to store in the memory 11 Program code or processing data, such as run the report generating system 100 etc..
The network interface 13 may include radio network interface or wired network interface, and the network interface 13 is usually used It is communicated to connect in being established between the application server 2 and other electronic equipments.
So far, oneself is through describing the hardware configuration and function of relevant device of the present invention in detail.In the following, will be according to above giving an account of It continues and proposes each embodiment of the invention.
Firstly, the present invention proposes a kind of report generating system 100.
As shown in fig.2, being the Program modual graph of 100 first embodiment of report generating system of the present invention.
In the present embodiment, the report generating system 100 includes a series of computer journey being stored on memory 11 The report generation of various embodiments of the present invention may be implemented when the computer program instructions are executed by processor 12 in sequence instruction Operation.In some embodiments, the specific operation realized according to described computer program instructions each section, report generation System 100 can be divided into one or more modules.For example, report generating system 100 can be divided into and match in Fig. 2 It sets module 101, judgment module 102, receiving module 103, obtain module 104 and generation module 105.Wherein:
The configuration module 101 is used to be configured to make a report in original text in the budget of a unit and final accounts are made a report in original text and carried out The data that data are filled in fill in logic, wherein the data fill in logic and include selective critical field and examine for data The logic auditing formula of core.
In one embodiment, original text is made a report in the budget and the final accounts are made a report in original text sub-item and filled out by function subject The income of declaration form position is paid and surplus data of carrying down.The income of the unit is paid and surplus data of carrying down include but unlimited Carry down in beginning of the year surplus, this annual income, this year expenditure and year end carries down surplus.Original text is made a report in the budget and the final accounts are made a report on Original text reflects the budget for making a report on unit and final accounts executive condition and accounting overall process, and is built-in with the pass for filling in or selecting Key field and the logic auditing formula for being audited in table.The data, which are filled in logic and be can be used to ensure that, fills in people according to unit Performed accounting system and the critical field fill in data.The critical field may include below one or more: Unit fundamental property, unit execute accounting system, entry property, project category, fund property, public budget financial allocation money Gold.The logic auditing formula can make a report on original text for critical field and budget and final accounts make a report on income in original text, pay, carry down Logical relation between surplus data.
In one embodiment, the project can refer to unit in order to complete its public functions, to the required commodity of purchase Various financial fund payment activities are carried out and the statistics of determination or the object of accounting with labor service, usually itself and Governmental Expenditure budget Project is consistent.The function subject refer to Governmental Expenditure by its Major Function activity made by a kind of classification subject, mainly Reflect the different function and policy goals of government activities, is specifically equipped with this three-level of class, money and item, can be united by National Ministry of Finance One regulation.The expenditure for making a report on unit is economic course.The economic course can refer to Governmental Expenditure by economic property and specific A kind of classification subject made by purposes, can be by National Ministry of Finance's Uniform provisions.
In one embodiment, the unit fundamental property includes administrative unit, referring to Civil Service Law public institution, finance Subsidize public institution, self-financed public institution and other unit.The entry property includes basic expenditure, administrative institution class Project, capital construction intermediate item and the item to manage.The fund property include finance pull out money, special family fund, floating capital and its His fund.It includes accounting of governmental units system, Institution Accounting System, cause of science list that the unit, which executes accounting system, Position accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals and Basic medical and health institutions Accounting system.The same level development concentrates the general public budget financial allocation fund arranged including being the same level development with reform department It concentrates the general public budget financial allocation fund of arrangement and non-the same level to develop with reform department and concentrates arrangement with reform department General public budget financial allocation fund.
The judgment module 102 for judging to make a report on whether the data made a report in original text meet the logic auditing formula, if It is then to save the data made a report on to presetting database, if it is not, then exporting prompt information, people is filled in the number made a report on prompt According to modifying.
In one embodiment, the judgment module 102 judgement makes a report on and makes a report on the income of unit in original text, pays and knot of carrying down Whether remainder evidence meets built-in logic auditing formula.If the receipts for making a report on unit in original text are made a report in the judgement of judgment module 102 Enter, pay, the logic auditing formula that surplus of carrying down data satisfaction is built-in, then the data made a report on will be passed through by audit in table The interior income audited of table pays and carries down the storage of surplus data into presetting database;If the judgement of judgment module 102 is filled out It reports in original text and makes a report on the income of unit, pay and surplus data of carrying down are unsatisfactory for built-in logic auditing formula, then people is filled in prompt It needs to the income made a report on, pay and surplus data of carrying down are modified, until built-in logic auditing formula is met.
In one embodiment, the project for making a report on unit is divided into two class of basic expenditure project and special expenditure.The base This expenditure and the special expenditure meet the service logic of setting.The expression formula of the service logic of the setting can To be: carry down surplus+this annual income-this year expenditure+make up balance of payment-surplus distribution=year end with enterprise fund of last year is tied Turn surplus.
The receiving module 103 obtains and the ID phase for receiving report export request according to the ID of target report Corresponding report template, wherein report export request packet contains the ID of the target report, the report template includes mould Plate framework and data target.
In one embodiment, the report export request refers to for triggering production data management system production target report The instruction of table.The ID of the target report is the corresponding mark of report template of user's selection.At the production interface of target report On in the form of grading list to report carry out Classification Management, for example, under the major class of financial statement include balance sheet, benefit Moisten table and finance change the reports such as table, facilitates user to select to use, promote user experience.It is appreciated that different target reports The ID of table can correspond to different report templates, for example the ID of three kinds of different target reports can respectively correspond beginning of the year budget Draft report adjusts budget document report, year end final accounts draft report in year.
In one embodiment, report template corresponding with all types of reports, each report template can be previously stored with With configuration information, report template can be carried out to realize by modifying configuration information or increasing new template configuration information newly Extension.The report template includes template framework and data target.Wherein, the template framework, which refers in report template, needs Make a report on the region of report data.The data target refers to index corresponding to the template framework in the report template, example Such as: media advertisement expense.It is appreciated that the receiving module 103 can receive report export request and according to target report ID inquires presetting database, report template corresponding with the ID of target report is obtained, so that call directly user can in advance The report template of storage, and target report is made using the report template, be conducive to the producing efficiency for improving target report.
The acquisition module 104 is used to obtain target report number from the presetting database according to the data target According to.
In one embodiment, the data target includes but is not limited to the pre-set cost subject of unit, such as media Advertising expenditure and creative making etc..The target report data refers to exist according to the data target in the report template Report data corresponding with the data target is searched in the presetting database.
In one embodiment, there can be the data target with pre-stored report template associated storage, each data refer to It marks a corresponding index ID and report data corresponding with the index ID, the acquisition module 104 is looked into according to the index ID The original report data for looking for the presetting database to be stored, and obtain report data, that is, institute corresponding with the data target State target report data.It is appreciated that the original report data can be the original number of data management system acquisition storage According to.Report data corresponding with the data target in real-time update presetting database can be set, so that the mesh of the report Marking report data has real time synchronization, provides more reliable data for user.
The generation module 105 is used to generate the target report based on the template framework and the target report data Table.
In one embodiment, the generation module 105 is based on the template framework and the target report data generates institute The concrete mode for stating target report may include:
D1. the target report data is converted using default chart crossover tool, to obtain the target report The visual image of data;
D2. the target report is generated according to the template framework, the visual image and the target report data Table.
In one embodiment, the visual image refers to report corresponding with the data target in the report template Table data carry out the obtained image of visualization processing.The chart crossover tool can use but be not limited to Echarts (Enterprise Charts, business level data drawing list) tool.ECharts is the chart library of a pure Javascript, can be with Smooth operates on PC and mobile device, and compatible various browsers, bottom relies on the Canvas class libraries ZRender of lightweight, It can provide the user with intuitively, vividly, the data visualization image of personalized customization.For example, the generation module 105 Can use ECharts tool to convert the target report data, and obtain obtained by visualization processing it is described The visual image of target report data, thus according to the template framework, the visual image and the target report Data generate the target report.
In one embodiment, the generation module 105 using default chart crossover tool to the target report data into Row is converted, and includes: to obtain the concrete mode of the visual image of the target report data
D11. it obtains subtype and generates request, it includes that transfer function identifies that the subtype, which generates request,;
D12. corresponding transfer function method is obtained according to transfer function mark;
D13. the transfer function method is called to convert the target report data, to obtain the target report The visual image of table data.
In one embodiment, it is that user selects visual image required for generating that the subtype, which generates request, The request of type.Transfer function mark is the different images that can be stored in the affiliated chart crossover tool of unique identification The mark of corresponding chart transfer function.It is appreciated that passing through pop-up when user is after selecting the report template Subtype generates the type of all visual images of interface display, due to the application scenarios of different types of visual image Difference, the effect of visualization embodied is also different, therefore user can be generated by subtype and request determination is to be selected can Type depending on changing image, operating process is simple and convenient, is conducive to promote user experience.
In one embodiment, it is stored with transfer function corresponding to different type image in the chart crossover tool, often The all corresponding transfer function mark of a transfer function, is identified by the transfer function, can call corresponding transfer function side Method.It include but is not limited to transfer function corresponding to the figures such as histogram, curve graph and line chart in the chart crossover tool Method.
In one embodiment, the generation module 105 may call upon the transfer function method pair in chart crossover tool Target report data is converted, and corresponding visual image is loaded, and shows the visual image.It is appreciated that the figure Table crossover tool can obtain target report data in real time and update visual image, so that target report has timing strong, The advantages of high reliablity.
In one embodiment, the generation module can also configure visualization figure 105 when generating Visual Chart Table highlights abnormal target report data, specifically, the generation module 105 according to the data target obtain with The corresponding critical field of the data target judges the target according to the target report data and the critical field Report data highlights in the visual image with the presence or absence of exception if the target report data has exception Abnormal target report data.
In one embodiment, historical data corresponding with the data target can be searched according to the data target, and Historical data is counted, to obtain critical field corresponding with the data target.The critical field can be applied In unit annual planning.The critical field can be for limiting target report number corresponding with the data target Amount whether Yi Chang index.
In one embodiment, the generation module 105 by by the target report data and the critical field into Row compares, to judge the target report data with the presence or absence of abnormal.If being appreciated that, the target report data does not exist When in the critical field, then it is abnormal to judge that the target report data exists for the judgment module 102;If the target report When table data are in the critical field, then judge that the target report data belongs to normal condition.It is appreciated that by institute It states target report data to obtain in real time, therefore, unit can obtain abnormal object report data in real time, increase target The real time synchronization of report data.
In one embodiment, by highlighting the abnormal target report data in the visual image, from And make abnormal target report data be easier to be concerned about by user so that user for abnormal target report data into Row processing.It is appreciated that the abnormal highlighted mode of target report data, which will be present, in the generation module 105 has very much Kind, such as: the generation module 105 can will be present abnormal target report data and be shown with blue runic, so use Family can quickly be seen in the presence of abnormal target report data, to make adjustment in time to abnormal target report data, Reduce the loss of unit.
Above-mentioned report generating system, first by being configured to make a report in original text in the budget of a unit and original text is made a report in final accounts The data that middle progress data are filled in fill in logic, wherein the data fill in logic and include selective critical field and be used for The logic auditing formula of data audit;Secondly judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if It is then to save the data made a report on to presetting database, if it is not, then exporting prompt information, people is filled in the number made a report on prompt According to modifying;Furthermore report export request is received, and report mould corresponding with the ID is obtained according to the ID of target report Plate, wherein report export request packet contains the ID of the target report, the report template includes template framework sum number According to index;Furthermore target report data is obtained from the presetting database according to the data target;Finally it is based on the mould Plate framework and the target report data generate the target report, so that budget and final accounts draft work out the equal nothing of report It needs to handle under boostrap, reduces cumbersome report form statistics work, liberate manpower, and support report template extension, can satisfy a Property report form statistics function, improve the producing efficiency of report, and support tabular views visualization.
In addition, the present invention also proposes a kind of report form generation method.
As shown in fig.3, being the implementation process diagram of report form generation method first embodiment of the present invention.In this implementation In example, the execution sequence of the step in flow chart shown in Fig. 3 be can change according to different requirements, and certain steps can save Slightly.
Step S400 is configured to make a report in original text in the budget of a unit and final accounts makes a report on and carry out what data were filled in original text Data fill in logic, wherein it includes that selective critical field and the logic audited for data are examined that the data, which fill in logic, Core formula.
In one embodiment, original text is made a report in the budget and the final accounts are made a report in original text sub-item and filled out by function subject The income of declaration form position is paid and surplus data of carrying down.The income of the unit is paid and surplus data of carrying down include but unlimited Carry down in beginning of the year surplus, this annual income, this year expenditure and year end carries down surplus.Original text is made a report in the budget and the final accounts are made a report on Original text reflects the budget for making a report on unit and final accounts executive condition and accounting overall process, and is built-in with the pass for filling in or selecting Key field and the logic auditing formula for being audited in table.The data, which are filled in logic and be can be used to ensure that, fills in people according to unit Performed accounting system and the critical field fill in data.The critical field may include below one or more: Unit fundamental property, unit execute accounting system, entry property, project category, fund property, public budget financial allocation money Gold.The logic auditing formula can make a report on original text for critical field and budget and final accounts make a report on income in original text, pay, carry down Logical relation between surplus data.
In one embodiment, the project can refer to unit in order to complete its public functions, to the required commodity of purchase Various financial fund payment activities are carried out and the statistics of determination or the object of accounting with labor service, usually itself and Governmental Expenditure budget Project is consistent.The function subject refer to Governmental Expenditure by its Major Function activity made by a kind of classification subject, mainly Reflect the different function and policy goals of government activities, is specifically equipped with this three-level of class, money and item, can be united by National Ministry of Finance One regulation.The expenditure for making a report on unit is economic course.The economic course can refer to Governmental Expenditure by economic property and specific A kind of classification subject made by purposes, can be by National Ministry of Finance's Uniform provisions.
In one embodiment, the unit fundamental property includes administrative unit, referring to Civil Service Law public institution, finance Subsidize public institution, self-financed public institution and other unit.The entry property includes basic expenditure, administrative institution class Project, capital construction intermediate item and the item to manage.The fund property include finance pull out money, special family fund, floating capital and its His fund.It includes accounting of governmental units system, Institution Accounting System, cause of science list that the unit, which executes accounting system, Position accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals and Basic medical and health institutions Accounting system.The same level development concentrates the general public budget financial allocation fund arranged including being the same level development with reform department It concentrates the general public budget financial allocation fund of arrangement and non-the same level to develop with reform department and concentrates arrangement with reform department General public budget financial allocation fund.
Step S402, judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if so, will fill out The data of report are saved to presetting database, if it is not, then exporting prompt information, are filled in people with prompt and are repaired to the data made a report on Change.
In one embodiment, judgement makes a report on and makes a report on the income of unit in original text, pays and in whether surplus data of carrying down meet The logic auditing formula set.If judgement makes a report on and makes a report on the income of unit in original text, pays and surplus data of carrying down meet built-in patrol Auditing formula is collected, then the data made a report on will be passed through the income audited in table, be paid, surplus of carrying down data by audit in table It stores in presetting database;If judgement makes a report on and makes a report on the income of unit in original text, pays and surplus data of carrying down be unsatisfactory for it is built-in Logic auditing formula, then prompt fills in people and needs to the income made a report on, pays and surplus data of carrying down are modified, until Built-in logic auditing formula is met.
In one embodiment, the project for making a report on unit is divided into two class of basic expenditure project and special expenditure.The base This expenditure and the special expenditure meet the service logic of setting.The expression formula of the service logic of the setting can To be: carry down surplus+this annual income-this year expenditure+make up balance of payment-surplus distribution=year end with enterprise fund of last year is tied Turn surplus.
Step S404 receives report export request, and obtains report corresponding with the ID according to the ID of target report Template, wherein report export request packet contains the ID of the target report, the report template includes template framework sum number According to index.
In one embodiment, the report export request refers to for triggering production data management system production target report The instruction of table.The ID of the target report is the corresponding mark of report template of user's selection.At the production interface of target report On in the form of grading list to report carry out Classification Management, for example, under the major class of financial statement include balance sheet, benefit Moisten table and finance change the reports such as table, facilitates user to select to use, promote user experience.It is appreciated that different target reports The ID of table can correspond to different report templates, for example the ID of three kinds of different target reports can respectively correspond beginning of the year budget Draft report adjusts budget document report, year end final accounts draft report in year.
In one embodiment, report template corresponding with all types of reports, each report template can be previously stored with With configuration information, report template can be carried out to realize by modifying configuration information or increasing new template configuration information newly Extension.The report template includes template framework and data target.Wherein, the template framework, which refers in report template, needs Make a report on the region of report data.The data target refers to index corresponding to the template framework in the report template, example Such as: media advertisement expense.It is appreciated that can receive report export request and inquire preset data according to the ID of target report Library obtains report template corresponding with the ID of target report, so that making user that can call directly pre-stored report mould Plate, and target report is made using the report template, be conducive to the producing efficiency for improving target report.
Step S406 obtains target report data according to the data target from the presetting database.
In one embodiment, the data target includes but is not limited to the pre-set cost subject of unit, such as media Advertising expenditure and creative making etc..The target report data refers to exist according to the data target in the report template Report data corresponding with the data target is searched in the presetting database.
In one embodiment, there can be the data target with pre-stored report template associated storage, each data refer to A corresponding index ID and report data corresponding with the index ID are marked, the preset data is searched according to the index ID The original report data that library is stored, and obtain report data, that is, target report data corresponding with the data target. It is appreciated that the original report data can be the initial data of data management system acquisition storage.It can be set in real time more Report data corresponding with the data target in new presetting database, so that the target report data of the report has in fact When synchronism, provide more reliable data for user.
Step S408 generates the target report based on the template framework and the target report data.
In one embodiment, described that the target report is generated based on the template framework and the target report data Concrete mode may include:
D1. the target report data is converted using default chart crossover tool, to obtain the target report The visual image of data;
D2. the target report is generated according to the template framework, the visual image and the target report data Table.
In one embodiment, the visual image refers to report corresponding with the data target in the report template Table data carry out the obtained image of visualization processing.The chart crossover tool can use but be not limited to Echarts (Enterprise Charts, business level data drawing list) tool.ECharts is the chart library of a pure Javascript, can It is operated on PC and mobile device with smooth, compatible various browsers, bottom relies on the Canvas class libraries of lightweight ZRender can be provided the user with intuitively, vividly, the data visualization image of personalized customization.For example, it can use ECharts tool converts the target report data, and obtains the target report obtained by visualization processing The visual image of data, to generate institute according to the template framework, the visual image and the target report data State target report.
In one embodiment, the target report data is converted using default chart crossover tool, to obtain The concrete mode for stating the visual image of target report data includes:
D11. it obtains subtype and generates request, it includes that transfer function identifies that the subtype, which generates request,;
D12. corresponding transfer function method is obtained according to transfer function mark;
D13. the transfer function method is called to convert the target report data, to obtain the target report The visual image of table data.
In one embodiment, it is that user selects visual image required for generating that the subtype, which generates request, The request of type.Transfer function mark is the different images that can be stored in the affiliated chart crossover tool of unique identification The mark of corresponding chart transfer function.It is appreciated that passing through pop-up when user is after selecting the report template Subtype generates the type of all visual images of interface display, due to the application scenarios of different types of visual image Difference, the effect of visualization embodied is also different, therefore user can be generated by subtype and request determination is to be selected can Type depending on changing image, operating process is simple and convenient, is conducive to promote user experience.
In one embodiment, it is stored with transfer function corresponding to different type image in the chart crossover tool, often The all corresponding transfer function mark of a transfer function, is identified by the transfer function, can call corresponding transfer function side Method.It include but is not limited to transfer function corresponding to the figures such as histogram, curve graph and line chart in the chart crossover tool Method.
In one embodiment, may call upon transfer function method in chart crossover tool to target report data into Row conversion, loads corresponding visual image, and show the visual image.It is appreciated that the chart crossover tool can be with Obtain target report data in real time and simultaneously update visual image so that target report has timing strong, high reliablity it is excellent Point.
In one embodiment, when generating Visual Chart, Visual Chart can also be configured and highlight abnormal mesh Report data is marked, specifically, critical field corresponding with the data target is obtained according to the data target, according to institute Target report data and the critical field are stated, judges the target report data with the presence or absence of exception, if the target report There is exception in data, then abnormal target report data is highlighted in the visual image.
In one embodiment, historical data corresponding with the data target can be searched according to the data target, and Historical data is counted, to obtain critical field corresponding with the data target.The critical field can be applied In unit annual planning.The critical field can be for limiting target report number corresponding with the data target Amount whether Yi Chang index.
It in one embodiment, can be by the way that the target report data be compared with the critical field, to sentence The target report data that breaks is with the presence or absence of abnormal.If being appreciated that the target report data not in the critical field When, then it is abnormal to judge that the target report data exists;If the target report data is in the critical field, sentence The target report data that breaks belongs to normal condition.It is appreciated that since the target report data obtains in real time, because This, unit can obtain abnormal object report data in real time, increase the real time synchronization of target report data.
In one embodiment, by highlighting the abnormal target report data in the visual image, from And make abnormal target report data be easier to be concerned about by user so that user for abnormal target report data into Row processing.It is appreciated that will be present there are many kinds of the abnormal highlighted modes of target report data, such as: it can will deposit It is shown in abnormal target report data with blue runic, such user can quickly see in the presence of abnormal target Report data reduces the loss of unit to make adjustment in time to abnormal target report data.
Above-mentioned report form generation method, first by being configured to make a report in original text in the budget of a unit and original text is made a report in final accounts The data that middle progress data are filled in fill in logic, wherein the data fill in logic and include selective critical field and be used for The logic auditing formula of data audit;Secondly judgement makes a report on whether the data made a report in original text meet the logic auditing formula, if It is then to save the data made a report on to presetting database, if it is not, then exporting prompt information, people is filled in the number made a report on prompt According to modifying;Furthermore report export request is received, and report mould corresponding with the ID is obtained according to the ID of target report Plate, wherein report export request packet contains the ID of the target report, the report template includes template framework sum number According to index;Furthermore target report data is obtained from the presetting database according to the data target;Finally it is based on the mould Plate framework and the target report data generate the target report, so that budget and final accounts draft work out the equal nothing of report It needs to handle under boostrap, reduces cumbersome report form statistics work, liberate manpower, and support report template extension, can satisfy a Property report form statistics function, improve the producing efficiency of report, and support tabular views visualization.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but many situations It is lower the former be more preferably embodiment.According to such understanding, technical solution of the present invention is substantially in other words to the prior art The part to contribute can be embodied in the form of software products, and the computer software product is stored in a storage In medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, calculate Machine, server, air conditioner or network equipment etc.) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content, it is relevant to be applied directly or indirectly in other Technical field is included within the scope of the present invention.

Claims (10)

1. a kind of report form generation method is applied to server, which is characterized in that the described method includes:
It is configured to make a report in original text in the budget of a unit and final accounts makes a report on the data that progress data are filled in original text and fill in logic, In, the data fill in the logic auditing formula that logic includes selective critical field and audits for data;
Judgement make a report on whether the data made a report in original text meet the logic auditing formula, if so, by the data made a report on save to Presetting database fills in people with prompt and modifies to the data made a report on if it is not, then exporting prompt information;
Report export request is received, and report template corresponding with the ID is obtained according to the ID of target report, wherein described Report export request packet contains the ID of the target report, and the report template includes template framework and data target;
Target report data is obtained from the presetting database according to the data target;And
The target report is generated based on the template framework and the target report data.
2. report form generation method as described in claim 1, which is characterized in that described to be based on the template framework and the target Report data generate the target report the step of include:
The target report data is converted using default chart crossover tool, it can with obtain the target report data Depending on changing image;And
The target report is generated based on the template framework, the visual image and the target report data.
3. report form generation method as claimed in claim 2, which is characterized in that described to utilize default chart crossover tool to described The step of target report data is converted, visual image to obtain the target report data include:
It obtains subtype and generates request, it includes that transfer function identifies that the subtype, which generates request,;
Corresponding transfer function method is obtained according to transfer function mark;And
The transfer function method is called to convert the target report data, it can with obtain the target report data Depending on changing image.
4. report form generation method as claimed in claim 2, which is characterized in that described to be preset according to the data target from described The step of in database after acquisition target report data further include:
Critical field corresponding with the data target is obtained according to the data target;
According to the target report data and the critical field, judge the target report data with the presence or absence of abnormal data; And
If there are abnormal datas for the target report data, abnormal target report is highlighted in the visual image Data.
5. the report form generation method as described in claim 1-4 any one, which is characterized in that the critical field includes following It is one or more: unit fundamental property, unit execute accounting system, entry property, project category, fund property, public pre- Calculate financial allocation fund;The logic auditing formula is that original text is made a report in the critical field and budget and receipts in original text are made a report in final accounts Enter, pay, the logical relation between surplus of carrying down data.
6. a kind of server, which is characterized in that the server includes memory, processor, and being stored on the memory can The report generating system run on the processor realizes following step when the report generating system is executed by the processor It is rapid:
It is configured to make a report in original text in the budget of a unit and final accounts makes a report on the data that progress data are filled in original text and fill in logic, In, the data fill in the logic auditing formula that logic includes selective critical field and audits for data;
Judgement make a report on whether the data made a report in original text meet the logic auditing formula, if so, by the data made a report on save to Presetting database fills in people with prompt and modifies to the data made a report on if it is not, then exporting prompt information;
Report export request is received, and report template corresponding with the ID is obtained according to the ID of target report, wherein described Report export request packet contains the ID of the target report, and the report template includes template framework and data target;
Target report data is obtained from the presetting database according to the data target;And
The target report is generated based on the template framework and the target report data.
7. server as claimed in claim 6, which is characterized in that described to be based on the template framework and the target report number Include: according to the step of generating the target report
The target report data is converted using default chart crossover tool, it can with obtain the target report data Depending on changing image;And
The target report is generated based on the template framework, the visual image and the target report data.
8. server as claimed in claim 7, which is characterized in that described to utilize default chart crossover tool to the target report The step of table data are converted, visual image to obtain the target report data include:
It obtains subtype and generates request, it includes that transfer function identifies that the subtype, which generates request,;
Corresponding transfer function method is obtained according to transfer function mark;And
The transfer function method is called to convert the target report data, it can with obtain the target report data Depending on changing image.
9. server as claimed in claim 7, which is characterized in that it is described according to the data target from the presetting database The step of after middle acquisition target report data further include:
Critical field corresponding with the data target is obtained according to the data target;
According to the target report data and the critical field, judge the target report data with the presence or absence of abnormal data; And
If there are abnormal datas for the target report data, abnormal target report is highlighted in the visual image Data.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has report generating system, the report Table generates system and can be executed by least one processor, so that at least one described processor is executed as appointed in claim 1-5 The step of report form generation method described in one.
CN201910298385.7A 2019-04-15 2019-04-15 Report form generation method, server and computer readable storage medium Pending CN110263307A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910298385.7A CN110263307A (en) 2019-04-15 2019-04-15 Report form generation method, server and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910298385.7A CN110263307A (en) 2019-04-15 2019-04-15 Report form generation method, server and computer readable storage medium

Publications (1)

Publication Number Publication Date
CN110263307A true CN110263307A (en) 2019-09-20

Family

ID=67913566

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910298385.7A Pending CN110263307A (en) 2019-04-15 2019-04-15 Report form generation method, server and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN110263307A (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111027300A (en) * 2019-10-30 2020-04-17 厦门天锐科技股份有限公司 Method and device for generating report form in user-defined mode
CN111144080A (en) * 2019-12-27 2020-05-12 深圳市金政软件技术有限公司 Budget document generation method and system
CN112016287A (en) * 2020-07-24 2020-12-01 浙江鸿程计算机系统有限公司 Data management method, platform, storage medium and electronic device
CN112307729A (en) * 2020-11-04 2021-02-02 恒瑞通(福建)信息技术有限公司 Online filling report generation method and terminal
CN112686010A (en) * 2020-12-23 2021-04-20 江苏苏宁云计算有限公司 Resource data report generation method and device, computer equipment and storage medium
CN113127547A (en) * 2019-12-31 2021-07-16 新奥数能科技有限公司 Data processing method and device, intelligent terminal and storage medium
CN114970473A (en) * 2022-06-08 2022-08-30 河北平普数政科技有限公司 Self-configuration report access method based on financial user report production
CN115147062A (en) * 2021-12-19 2022-10-04 中国铁道科学研究院集团有限公司电子计算技术研究所 Railway engineering management method and system
CN116402571A (en) * 2023-03-14 2023-07-07 上海峰沄网络科技有限公司 Budget data processing method, device, equipment and storage medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130173733A1 (en) * 2012-01-04 2013-07-04 Alcatel-Lucent Canada Inc. Configurable web service notification with templates
CN105320690A (en) * 2014-07-30 2016-02-10 北京中海纪元数字技术发展股份有限公司 Metadata based rapid statistic form generation method and system
CN106598925A (en) * 2016-11-22 2017-04-26 广州悦审软件科技有限公司 Method and system for quickly generating department final statement report data
CN107656968A (en) * 2017-08-31 2018-02-02 武汉斗鱼网络科技有限公司 High-volume business datum deriving method and system
CN108170655A (en) * 2017-12-26 2018-06-15 平安科技(深圳)有限公司 Production method, device, terminal device and the storage medium of Visual Report Forms

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130173733A1 (en) * 2012-01-04 2013-07-04 Alcatel-Lucent Canada Inc. Configurable web service notification with templates
CN105320690A (en) * 2014-07-30 2016-02-10 北京中海纪元数字技术发展股份有限公司 Metadata based rapid statistic form generation method and system
CN106598925A (en) * 2016-11-22 2017-04-26 广州悦审软件科技有限公司 Method and system for quickly generating department final statement report data
CN107656968A (en) * 2017-08-31 2018-02-02 武汉斗鱼网络科技有限公司 High-volume business datum deriving method and system
CN108170655A (en) * 2017-12-26 2018-06-15 平安科技(深圳)有限公司 Production method, device, terminal device and the storage medium of Visual Report Forms

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111027300A (en) * 2019-10-30 2020-04-17 厦门天锐科技股份有限公司 Method and device for generating report form in user-defined mode
CN111144080A (en) * 2019-12-27 2020-05-12 深圳市金政软件技术有限公司 Budget document generation method and system
CN111144080B (en) * 2019-12-27 2024-04-26 深圳市金政软件技术有限公司 Budget document generation method and system
CN113127547A (en) * 2019-12-31 2021-07-16 新奥数能科技有限公司 Data processing method and device, intelligent terminal and storage medium
CN112016287B (en) * 2020-07-24 2024-01-26 浙江鸿程计算机系统有限公司 Data management method, platform, storage medium and electronic equipment
CN112016287A (en) * 2020-07-24 2020-12-01 浙江鸿程计算机系统有限公司 Data management method, platform, storage medium and electronic device
CN112307729A (en) * 2020-11-04 2021-02-02 恒瑞通(福建)信息技术有限公司 Online filling report generation method and terminal
CN112686010B (en) * 2020-12-23 2024-03-01 江苏苏宁云计算有限公司 Resource data report generation method, device, computer equipment and storage medium
CN112686010A (en) * 2020-12-23 2021-04-20 江苏苏宁云计算有限公司 Resource data report generation method and device, computer equipment and storage medium
CN115147062A (en) * 2021-12-19 2022-10-04 中国铁道科学研究院集团有限公司电子计算技术研究所 Railway engineering management method and system
CN115147062B (en) * 2021-12-19 2024-04-30 中国铁道科学研究院集团有限公司电子计算技术研究所 Railway engineering management method and system
CN114970473A (en) * 2022-06-08 2022-08-30 河北平普数政科技有限公司 Self-configuration report access method based on financial user report production
CN116402571A (en) * 2023-03-14 2023-07-07 上海峰沄网络科技有限公司 Budget data processing method, device, equipment and storage medium
CN116402571B (en) * 2023-03-14 2024-04-26 上海峰沄网络科技有限公司 Budget data processing method, device, equipment and storage medium

Similar Documents

Publication Publication Date Title
CN110263307A (en) Report form generation method, server and computer readable storage medium
CN110119977A (en) Financial accounting voucher automatic generation method, system, medium and electronic equipment
CN110009471A (en) Financial affairs receipt generation method, device, computer equipment and storage medium
CN110532536A (en) A kind of rule configuration method and device
CN106485390A (en) The generation method of examination & approval stream and device
CN110442341A (en) Interface configuration method, device and the terminal device of application program
CN110046337B (en) Financial data acquisition method and system
CN105719112A (en) Determination method and device for distribution abnormal state, and server
CN109324905A (en) Database operation method, device, electronic equipment and storage medium
CN110309099A (en) Interface managerial method, device, equipment and computer readable storage medium
CN114579110B (en) Solution method of optimization model, electronic device, application program, and storage medium
Agarwal et al. The impact of non-performing assets on bank performance under Basel regime-empirical evidence from India
CN110866813A (en) Intelligent accounting system for managing accountants
JP2007272722A (en) Method and system for analyzing set-up of branch office
CN116091258A (en) Data processing method and device for account checking management
US7467105B2 (en) Price calculator
CN113989013A (en) Method, device and medium for managing account opening channel
CN106933544A (en) Declare table generating method and system
CN108228688B (en) Template generation method, system and server based on XBRL
CN110728571A (en) Loan amount allocation method and device
CN111221855A (en) Data processing method and device
CN111192137B (en) Multi-dimensional balance management method and system based on business scene
CN112711412B (en) Universal business plan compiling method and platform
JP7324345B2 (en) Foreign currency conversion device, foreign currency conversion method and foreign currency conversion program
CN117290620A (en) Display method and device

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
WD01 Invention patent application deemed withdrawn after publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20190920