CN113535713A - System-type resident family economic condition checking report generation method - Google Patents
System-type resident family economic condition checking report generation method Download PDFInfo
- Publication number
- CN113535713A CN113535713A CN202110638564.8A CN202110638564A CN113535713A CN 113535713 A CN113535713 A CN 113535713A CN 202110638564 A CN202110638564 A CN 202110638564A CN 113535713 A CN113535713 A CN 113535713A
- Authority
- CN
- China
- Prior art keywords
- report
- check
- configuration
- checking
- item
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
- G06F9/44526—Plug-ins; Add-ons
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Human Computer Interaction (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
本发明特别涉及一种制式居民家庭经济状况核对报告生成方法。该制式居民家庭经济状况核对报告生成方法，首先，利用iText组件和sftp协议，在服务器端基于数据配置自动生成PDF并上传至文件服务器；然后在客户端采用超链接下载形成获取居民家庭经济状况核对报告；包括基础配置、核对报告生成、核对报告上传和核对报告下载四个步骤。该制式居民家庭经济状况核对报告生成方法，针对核对报告展示内容多、字典多、变化快的特点，基于iText组件和数据库配置，通过数据库一次性配置即可在服务器后台自动生成核对报告，减少了因数据项修改导致的前端代码开发量，提高了核对工作效率。
The invention particularly relates to a method for generating a standard household economic status check report. The method for generating a household economic status check report of this standard. First, using the iText component and the sftp protocol, a PDF is automatically generated based on the data configuration on the server side and uploaded to the file server; then, a hyperlink is used to download on the client side to obtain the household economic status check. Report; including basic configuration, verification report generation, verification report upload and verification report download four steps. The method for generating a verification report on the economic status of a resident household in this standard is based on the characteristics of a large number of displayed contents, many dictionaries, and rapid changes in the verification report. Based on the iText component and database configuration, the verification report can be automatically generated in the server background through a one-time configuration of the database, reducing the need for The amount of front-end code development caused by the modification of data items improves the efficiency of checking work.
Description
Technical Field
The invention relates to the technical field of civil informatization, in particular to a system-type resident family economic condition checking report generating method.
Background
Social aid is an important component of a social security system, and bears the important roles of guaranteeing the bottom line of the livelihood, promoting social fairness and maintaining social stability. The method for checking and identifying the family economic condition of the help application is a mode for accurately evaluating the family economic condition of the help application according to the conditions of family income, property and the like declared by the social help application applicant, submitting a checking organization and checking the family income application and the economic condition of vehicles, real estate, financial assets and the like, and is a precondition and basis for realizing accurate help. The checking report is a final output product for summarizing and applying for rescuing family income and economic conditions such as vehicles, real estate and financial assets, and provides an important reference for auditing and approving social rescue. The following were used:
TABLE 1 economic status check content table
As shown in the table, the domestic economic status check report needs to show more than 300 data items of more than 10 committees, the data items related to the committees are updated gradually, and the data items which can be obtained are updated gradually, so that the check report has three main characteristics: the data content is more, the dictionary mapping is more, and the data item change is fast. In addition, since a verification report is required to be non-tamper-proof as a data reference to be issued to a social aid unit, there is a certain requirement for a file format.
In order to standardize the generation format of the household economic condition checking report of residents and reduce the development amount of front-end codes caused by modifying data items, the invention provides a system type household economic condition checking report generation method.
Disclosure of Invention
In order to make up for the defects of the prior art, the invention provides a simple and efficient system-type residential family economic condition checking report generating method.
The invention is realized by the following technical scheme:
a system type resident family economic condition checking report generation method is characterized by comprising the following steps: firstly, automatically generating PDF on a server side based on data configuration by using an iText component and an sftp protocol and uploading the PDF to a file server; then, a hyperlink is downloaded at the client to form a check report for acquiring the household economic condition of the residents;
the method specifically comprises four steps of basic configuration, generation of a check report, uploading of the check report and downloading of the check report.
The basic configuration step comprises two parts of checking item configuration and data content configuration of each item display;
the check item configuration refers to configuration of check items to be displayed in the check report, and comprises item names, item codes, whether to display, the number of columns and sequence numbers used for displaying, and the configuration name is BODY _ CONFIG;
the configuration of the content of each item display data refers to the configuration of the display content of each check item in the check report, and the configuration comprises a data name, an item code, a data dictionary, a data content expression, whether to display, the number of columns used for displaying and a sequence number, wherein the configuration name is DETAIL _ CONFIG.
The verification report generation step comprises two parts of file creation and verification content output;
the file creation refers to creating a pdf file by using an iText component;
the check content output refers to respectively creating and acquiring a check item and data content, and then respectively creating a check item table (table) and a data content field (cell) by using an iText component.
When creating the file, the pdf file is created by using the com.
When the content is checked and output, firstly, a common method queryDisplayItem and a queryDisplayColumn are used for respectively creating and acquiring a check item and data content, and then, a check item table (table) and a data content field (cell) are respectively created by using the classes of com.
In the checking report uploading step, the checking report is uploaded to a file server by an application server through an SFTP protocol, and the file name and the file path are stored in a mechanization database.
The file name format is formed by 24 characters, and the 24 characters sequentially comprise eight layers from front to back:
wherein, the checking report number must begin with the 'first', so the first layer includes 2 characters, which are the fixed character 'first';
the second layer is an administrative division code, and the administrative division code of the checking organization location with the checking report is required to be taken out and comprises 6 characters;
the third layer is a year code, and 4 complete codes including 4 characters in the gregorian calendar year of the time of the check report are required to be taken;
the fourth layer is serial numbers, serial numbers are sequentially generated in the order of issuing check reports in a gregorian calendar year, and the serial numbers are 1 month and 1 day every year and are 0: 00 restarts at 0000001, comprising 7 characters;
the fifth layer is a service identifier, marks the check item type to which the check report belongs, comprises 1 character and has a value range of a-z;
the sixth layer is a property identifier for marking the property of the checking report, comprises 1 character and consists of 1-digit English letters;
the property identifier includes F, S, and T, wherein:
f represents a check report issued for the first time to a check family;
s represents that after dispute occurs in the check report, the check report is rechecked aiming at a check family issue;
t represents a second rechecking check report issued by a checking family after the rechecking check report disputes again;
the seventh layer is a copy identifier which comprises 1 character, if one checking family provides a plurality of checking reports, the running codes are sequentially generated according to the providing sequence; wherein:
numeral 1 represents a check report of a family;
numerals 2 to 9 represent a plurality of check reports for one family;
since the collation report number is terminated with a "number", the eighth layer is a fixed character "number" including 1 character.
In the step of downloading the check report, a severlet service downloaded by the check report is firstly established, access authority control is carried out, and a check report downloading end acquires data from a server end, namely a copy of a file stored in a file server is downloaded to a client.
The invention has the beneficial effects that: according to the standard type resident family economic condition checking report generation method, aiming at the characteristics of multiple displayed contents, multiple dictionaries and quick change of the checking report, the checking report can be automatically generated at the background of the server through one-time configuration of the database based on iText components and database configuration, the development amount of front-end codes caused by data item modification is reduced, and the checking work efficiency is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a schematic diagram of arrangement rules of file name format characters according to the present invention.
Detailed Description
In order to make those skilled in the art better understand the technical solution of the present invention, the technical solution in the embodiment of the present invention will be clearly and completely described below with reference to the embodiment of the present invention. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Firstly, by using an iText component and an sftp protocol, automatically generating PDF on a server side based on data configuration and uploading the PDF to a file server; then, a hyperlink is downloaded at the client to form a check report for acquiring the household economic condition of the residents;
the method specifically comprises four steps of basic configuration, generation of a check report, uploading of the check report and downloading of the check report.
The basic configuration step comprises two parts of checking item configuration and data content configuration of each item display;
the check item configuration refers to configuration of check items to be displayed in the check report, and comprises item names, item codes, whether to display, the number of columns and sequence numbers used for displaying, and the configuration name is BODY _ CONFIG; the concrete configuration is as follows:
table 2 collation item configuration example
The configuration of the content of each item display data refers to the configuration of the display content of each check item in the check report, and the configuration comprises a data name, an item code, a data dictionary, a data content expression, whether to display, the number of columns used for displaying and a sequence number, wherein the configuration name is DETAIL _ CONFIG. The specific configuration of the data content of each project presentation is as follows:
table 3 items show data content configuration examples
Taking table 4 as an example, if check items shown in the following format are configured, then "BODY _ config. item name is" fair fund ", and BODY _ config. display used column is" 4 ". The default number of columns for display of the remaining fields is 1, but since the data content of the name of the payment unit is relatively long, "number of columns for display of detach _ config" may be 3 ".
Table 4 accumulation fund presentation data content configuration example
The verification report generation step comprises two parts of file creation and verification content output;
the file creation refers to creating a pdf file by using an iText component;
the check content output refers to respectively creating and acquiring a check item and data content, and then respectively creating a check item table (table) and a data content field (cell) by using an iText component.
When creating the file, the pdf file is created by using the com.
When the content is checked and output, firstly, a common method queryDisplayItem and a queryDisplayColumn are used for respectively creating and acquiring a check item and data content, and then, a check item table (table) and a data content field (cell) are respectively created by using the classes of com.
In the checking report uploading step, the checking report is uploaded to a file server by an application server through an SFTP protocol, and the file name and the file path are stored in a mechanization database.
The file name format is formed by 24 characters, and the 24 characters sequentially comprise eight layers from front to back:
wherein, the checking report number must begin with the 'first', so the first layer includes 2 characters, which are the fixed character 'first';
the second layer is an administrative division code, and the administrative division code of the checking organization location with the checking report is required to be taken out and comprises 6 characters;
the third layer is a year code, and 4 complete codes including 4 characters in the gregorian calendar year of the time of the check report are required to be taken;
the fourth layer is serial numbers, serial numbers are sequentially generated in the order of issuing check reports in a gregorian calendar year, and the serial numbers are 1 month and 1 day every year and are 0: 00 restarts at 0000001, comprising 7 characters;
the fifth layer is a service identifier, marks the check item type to which the check report belongs, comprises 1 character and has a value range of a-z;
the sixth layer is a property identifier for marking the property of the checking report, comprises 1 character and consists of 1-digit English letters;
the property identifier includes F, S, and T, wherein:
f represents a check report issued for the first time to a check family;
s represents that after dispute occurs in the check report, the check report is rechecked aiming at a check family issue;
t represents a second rechecking check report issued by a checking family after the rechecking check report disputes again;
the seventh layer is a copy identifier which comprises 1 character, if one checking family provides a plurality of checking reports, the running codes are sequentially generated according to the providing sequence; wherein:
numeral 1 represents a check report of a family;
numerals 2 to 9 represent a plurality of check reports for one family;
since the collation report number is terminated with a "number", the eighth layer is a fixed character "number" including 1 character.
In the step of downloading the check report, a severlet service downloaded by the check report is firstly established, access authority control is carried out, and a check report downloading end acquires data from a server end, namely a copy of a file stored in a file server is downloaded to a client.
The standard resident family economic condition checking report generating method can be in seamless butt joint with an original resident family economic condition checking system, and can be released into independent web service after being matched with data management.
The above-described embodiment is only one specific embodiment of the present invention, and general changes and substitutions by those skilled in the art within the technical scope of the present invention are included in the protection scope of the present invention.
Claims (8)
1. A system type resident family economic condition checking report generation method is characterized by comprising the following steps: firstly, automatically generating PDF on a server side based on data configuration by using an iText component and an sftp protocol and uploading the PDF to a file server; then, a hyperlink is downloaded at the client to form a check report for acquiring the household economic condition of the residents;
the method specifically comprises four steps of basic configuration, generation of a check report, uploading of the check report and downloading of the check report.
2. The system-based resident household economic condition reconciliation report generating method according to claim 1, characterized in that: the basic configuration step comprises two parts of checking item configuration and data content configuration of each item display;
the check item configuration refers to configuration of check items to be displayed in the check report, and comprises item names, item codes, whether to display, the number of columns and sequence numbers used for displaying, and the configuration name is BODY _ CONFIG;
the configuration of the content of each item display data refers to the configuration of the display content of each check item in the check report, and the configuration comprises a data name, an item code, a data dictionary, a data content expression, whether to display, the number of columns used for displaying and a sequence number, wherein the configuration name is DETAIL _ CONFIG.
3. The system-based resident household economic condition reconciliation report generating method according to claim 1, characterized in that: the verification report generation step comprises two parts of file creation and verification content output;
the file creation refers to creating a pdf file by using an iText component;
the check content output refers to respectively creating and acquiring a check item and data content, and then respectively creating a check item table and a data content field by using an iText component.
4. The system-based resident household economic condition reconciliation report generating method according to claim 3, characterized in that: when creating the file, the pdf file is created by using the com.
5. The system-based resident household economic condition reconciliation report generating method according to claim 3, characterized in that: when the content is checked and output, firstly, a common method queryDisplayItem and a queryDisplayColumn are used for respectively creating and acquiring a check item and data content, and then, a check item table and a data content field are respectively created by using the classes of com.
6. The system-based resident household economic condition reconciliation report generating method according to claim 1, characterized in that: in the checking report uploading step, the checking report is uploaded to a file server by an application server through an SFTP protocol, and the file name and the file path are stored in a mechanization database.
7. The system-based resident household economic condition reconciliation report generating method according to claim 6, characterized in that: the file name format is formed by 24 characters, and the 24 characters sequentially comprise eight layers from front to back:
wherein, the checking report number must begin with the 'first', so the first layer includes 2 characters, which are the fixed character 'first';
the second layer is an administrative division code, and the administrative division code of the checking organization location with the checking report is required to be taken out and comprises 6 characters;
the third layer is a year code, and 4 complete codes including 4 characters in the gregorian calendar year of the time of the check report are required to be taken;
the fourth layer is serial numbers, serial numbers are sequentially generated in the order of issuing check reports in a gregorian calendar year, and the serial numbers are 1 month and 1 day every year and are 0: 00 restarts at 0000001, comprising 7 characters;
the fifth layer is a service identifier, marks the check item type to which the check report belongs, comprises 1 character and has a value range of a-z;
the sixth layer is a property identifier for marking the property of the checking report, comprises 1 character and consists of 1-digit English letters;
the property identifier includes F, S, and T, wherein:
f represents a check report issued for the first time to a check family;
s represents that after dispute occurs in the check report, the check report is rechecked aiming at a check family issue;
t represents a second rechecking check report issued by a checking family after the rechecking check report disputes again;
the seventh layer is a copy identifier which comprises 1 character, if one checking family provides a plurality of checking reports, the running codes are sequentially generated according to the providing sequence; wherein:
numeral 1 represents a check report of a family;
numerals 2 to 9 represent a plurality of check reports for one family;
since the collation report number is terminated with a "number", the eighth layer is a fixed character "number" including 1 character.
8. The system-based resident household economic condition reconciliation report generating method according to claim 1, characterized in that: in the step of downloading the check report, a severlet service downloaded by the check report is firstly established, access authority control is carried out, and a check report downloading end acquires data from a server end, namely a copy of a file stored in a file server is downloaded to a client.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110638564.8A CN113535713A (en) | 2021-06-08 | 2021-06-08 | System-type resident family economic condition checking report generation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110638564.8A CN113535713A (en) | 2021-06-08 | 2021-06-08 | System-type resident family economic condition checking report generation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113535713A true CN113535713A (en) | 2021-10-22 |
Family
ID=78124720
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110638564.8A Pending CN113535713A (en) | 2021-06-08 | 2021-06-08 | System-type resident family economic condition checking report generation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113535713A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114372444A (en) * | 2021-12-20 | 2022-04-19 | 浪潮软件股份有限公司 | PDF resident family economic condition checking report generation method |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101192976A (en) * | 2006-11-30 | 2008-06-04 | 中兴通讯股份有限公司 | Method for automatic generation of value-added service standard report |
| CN104331405A (en) * | 2013-07-22 | 2015-02-04 | 腾讯科技（深圳）有限公司 | Method and device for processing a data report |
| CN110070330A (en) * | 2019-03-08 | 2019-07-30 | 中科恒运股份有限公司 | Resident information checking method and system |
| US10565298B1 (en) * | 2014-09-05 | 2020-02-18 | Addepar, Inc. | Systems and user interfaces for dynamic and interactive report generation and editing based on automatic traversal of complex data structures |
| CN111145855A (en) * | 2019-12-30 | 2020-05-12 | 南京求臻基因科技有限公司 | Automatic generation method and system for clinical PDF report |
| CN111444293A (en) * | 2020-04-17 | 2020-07-24 | 重庆市勘测院 | Intelligent report generation method for multi-source heterogeneous safety monitoring data |
| CN111752999A (en) * | 2020-06-30 | 2020-10-09 | 潘传迪 | Configured report generation system and method |
-
2021
- 2021-06-08 CN CN202110638564.8A patent/CN113535713A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101192976A (en) * | 2006-11-30 | 2008-06-04 | 中兴通讯股份有限公司 | Method for automatic generation of value-added service standard report |
| CN104331405A (en) * | 2013-07-22 | 2015-02-04 | 腾讯科技（深圳）有限公司 | Method and device for processing a data report |
| US10565298B1 (en) * | 2014-09-05 | 2020-02-18 | Addepar, Inc. | Systems and user interfaces for dynamic and interactive report generation and editing based on automatic traversal of complex data structures |
| CN110070330A (en) * | 2019-03-08 | 2019-07-30 | 中科恒运股份有限公司 | Resident information checking method and system |
| CN111145855A (en) * | 2019-12-30 | 2020-05-12 | 南京求臻基因科技有限公司 | Automatic generation method and system for clinical PDF report |
| CN111444293A (en) * | 2020-04-17 | 2020-07-24 | 重庆市勘测院 | Intelligent report generation method for multi-source heterogeneous safety monitoring data |
| CN111752999A (en) * | 2020-06-30 | 2020-10-09 | 潘传迪 | Configured report generation system and method |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114372444A (en) * | 2021-12-20 | 2022-04-19 | 浪潮软件股份有限公司 | PDF resident family economic condition checking report generation method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220138878A1 (en) | System and method for document transformation | |
| US20230130670A1 (en) | System and method for carbon management lifecycle management and extensible carbon markup machine language | |
| US10706221B2 (en) | Method and system operable to facilitate the reporting of information to a report reviewing entity | |
| Debreceny et al. | XBRL for interactive data: Engineering the information value chain | |
| US8078512B1 (en) | Document manifest and publication in association with dataset quality control | |
| US20020022987A1 (en) | Common database system for sales and marketing process | |
| WO2017079224A1 (en) | Rich data types | |
| EP1573472A2 (en) | Data collection method and report generation apparatus including an automatch function for generating a report illustrating a field order and associated invoice | |
| CN112487198B (en) | Physical model processing method and device, electronic equipment and computer storage medium | |
| US20130246133A1 (en) | Systems and methods for incentives | |
| US20150006491A1 (en) | Just-in-Time Data Quality Assessment for Best Record Creation | |
| WO2011134001A1 (en) | Automatic report generation system and method therefor | |
| Cohen et al. | Issues with the communication and integrity of audit reports when financial reporting shifts to an information-centric paradigm | |
| US9009583B2 (en) | Creating cross-tabular reports | |
| US10891294B1 (en) | Automatically migrating computer content | |
| US8719007B2 (en) | Determining offer terms from text | |
| US20090265279A1 (en) | System and method for managing and distributing hedge fund data | |
| CN114880331A (en) | Financial data accurate tracing method based on block chain MPT tree | |
| CN113535713A (en) | System-type resident family economic condition checking report generation method | |
| CN117670007A (en) | Process model generation method, related devices and media | |
| US20140052653A1 (en) | System And Method For Completing, Validating And Submitting Regulatory Forms | |
| US9116935B2 (en) | Method and system to promote database cost savings | |
| CA2815118A1 (en) | Systems and methods for incentives | |
| Coruhlu et al. | Data model development for ‘buying and selling’transactions as a real estate acquisition method | |
| Mc Cabe et al. | System testing aided by structured analysis: A practical experience |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211022 |
|
| RJ01 | Rejection of invention patent application after publication |