CN103235809A - Method for data acquisition of summary report - Google Patents

Method for data acquisition of summary report Download PDF

Info

Publication number
CN103235809A
CN103235809A CN 201310142479 CN201310142479A CN103235809A CN 103235809 A CN103235809 A CN 103235809A CN 201310142479 CN201310142479 CN 201310142479 CN 201310142479 A CN201310142479 A CN 201310142479A CN 103235809 A CN103235809 A CN 103235809A
Authority
CN
Grant status
Application
Patent type
Prior art keywords
summary
data
report
users
reporting
Prior art date
Application number
CN 201310142479
Other languages
Chinese (zh)
Inventor
孙杰
刘英伟
孙丹阳
Original Assignee
长春吉联科技集团有限公司
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

Links

Abstract

The invention discloses a method for data acquisition of a summary report. The method comprises the steps of summarizing summary items selected by users and reporting users, judging whether summary items and reporting users are valid or not, if summary items and reporting users are valid, generating a summary report format, generating a current summary report after reporting users fill their data in the summary report format, and exporting the current summary report. A summarizing user can draw a complex summary report simply through simple setting, a corresponding summary report can be obtained through direct inputting of necessary data names and measurement units, only current data are required to be input to finish data reporting for users reporting data, and simultaneously, reporting users are reminded through mobile phone short messages, so that missing of summary data is avoided, both summarizers and reporters can inquire historical data of reports, the generated summary report is in seamless connection with an EXCEL, and usage by users is facilitated.

Description

一种汇表取数方法 The method of one kind glossary access

技术领域 FIELD

[0001] 本发明涉及数据汇总领域,尤其涉及一种汇表取数方法。 [0001] The present invention relates to data collection, and in particular relates to a method for access Glossary.

背景技术 Background technique

[0002] 数据汇总是一项重要的统计工作,在会计、统计学中尤其重要,一般用于两种情况:一是单位内部不同期间的同一种报表的汇总,主要用于统计较长期间的累计值;二是不同单位同一期间同一种报表的汇总,主要用于总公司对下属分公司或上级主管部门对下属单位有关报表的汇总。 [0002] data collection is an important statistical work is particularly important in accounting, statistics, generally used in two cases: one is the summary of a reporting unit within the same period a different, mainly used for a longer period statistics the cumulative value; the second is the same kind of summary reports in different units during the same period, a summary of the main headquarters for the division or the higher authorities about reports of subordinate units. 两种情况要求汇总的都是同一种报表,即数据可以不同但格式必须完全相同。 In both cases the requirements are the same kind of summary of the report that the data can be different but the format must be identical.

[0003] 显然,数据汇总可以转化为表页之间的汇总问题。 [0003] Clearly, the data can be aggregated into a summary of the issues between the tables page. 因为,不仅单位内部不同期间的报表一般用不同表页表示,而且下属分公司的报表也可以采集进表页。 Because the report is not only different periods of general internal units represented by a different page tables, and a division of reports can be collected into the page table. 但在数据汇总时需要填写不同的项目,对表格操作繁琐,给用户带来诸多不便。 However, when data collection required to complete different projects, to form complicated operation, causing much inconvenience to the user.

[0004] 因此,现有技术还有待于更进一步的改进和发展。 [0004] Thus, the prior art has yet to be further improved and developed.

发明内容 SUMMARY

[0005] 鉴于上述现有技术的不足,本发明的目的在于提供一种汇表取数方法,以方便用户操作,避免汇总数据遗漏。 [0005] In view of the deficiencies of the prior art, an object of the present invention is to provide a glossary access method to facilitate the user operation, to avoid missing data summary.

[0006] 本发明的技术方案如下: [0006] aspect of the present invention is as follows:

一种汇表取数方法,其包括以下步骤: One kind glossary access method comprising the steps of:

汇总用户选择汇总项目与上报用户,判断所述汇总项目与所述上报用户是否有效,若为是,则生成汇总表格式,上报用户在所述汇总表格式上填写己方数据后生成当期汇总表并导出。 Summary user selects item summary report and the user determines the item summary report and the user is valid, if it is yes, generate summary tabular, summary reporting user generates profit after the consolidated fill own data format table and export.

[0007] 所述的汇表取数方法,其中,在上述生成汇总表格式时,同步的通过短信通知上报用户已生成所述汇总表格式。 According to [0007] Glossary access method, wherein when said generated summary table format, the user has synchronized report generated by the SMS notification summary table format.

[0008] 所述的汇表取数方法,其中,所述汇表取数方法还包括服务器部署步骤: [0008] Glossary said access method, wherein the glossary access server deployment method further comprises the steps of:

A、在所述服务器为阿帕奇服务器,在所述阿帕奇服务器上安装Linux操作系统; A, the Apache server is a server, the Linux operating system installed on the Apache server;

B、将汇表取数服务器与域名绑定,所述汇表取数服务器通过Internet网与所述阿帕奇服务器通信连接。 B, and glossary access server binding domain, the glossary access Apache server connected with the communication server through the Internet network.

[0009] 所述的汇表取数方法,其中,所述步骤A具体的包括:在所述阿帕奇服务器上安装超文本预处理语言系统与关联数据库管理系统。 [0009] Glossary said access method, wherein the step A specifically comprises: mounting Language Hypertext Preprocessor systems and relational database management systems on the Apache server.

[0010] 所述的汇表取数方法,其中,所述步骤A具体的包括:将汇总表格式放置在所述阿帕奇服务器的发布目录内。 [0010] Glossary said access method, wherein the step A comprises: placing in a tabular summary of the Apache server publishing directory.

[0011] 本发明提供的一种汇表取数方法,通过简单的设置,可令汇总用户以简单的形式绘制一张复杂的汇总报表,直接录入所需数据名称和计量单位就可以获得对应的汇总报表,而对于上报数据的用户,只需录入本期数据,即可完成数据上报,同时通过手机短信提醒上报用户,避免汇总数据发生遗漏,无论汇总者还是上报者,都可以对报表的历史数据进行查询,生成的汇总表与EXCEL无缝连接,方便了用户使用。 [0011] A glossary of the present invention provides a method of access, through a simple setting, the user can make to draw a complex summary summary report in a simple manner, directly enter the desired name and units of measurement data can be obtained the corresponding summary reports, and report data for the user, simply enter the current data to complete the data reporting, while reminding the user by SMS report, summary data to avoid the occurrence of omission, whether aggregators or report who can report on history query data, generates a summary table with the EXCEL seamless, convenient for users to use.

附图说明 BRIEF DESCRIPTION

[0012] 图1为本发明中汇表取数方法的流程示意图; [0012] FIG. 1 process glossary access method of the present invention, a schematic diagram;

图2为本发明中汇表取数方法实施例的流程示意图。 FIG 2 of the present invention glossary access method of an embodiment schematic flow chart.

具体实施方式 detailed description

[0013] 本发明提供了一种汇表取数方法,为使本发明的目的、技术方案及效果更加清楚、明确,以下对本发明进一步详细说明。 [0013] The present invention provides a glossary access method, for the purposes of the present invention, technical solutions and advantages clearer, explicit, the following detailed description of the present invention further. 应当理解,此处所描述的具体实施例仅仅用以解释本发明,并不用于限定本发明。 It should be understood that the specific embodiments described herein are only intended to illustrate the present invention and are not intended to limit the present invention.

[0014] 本发明提供了一种汇表取数方法,如图1与图2所示的,其包括以下步骤: [0014] The present invention provides a method of access glossary, as shown in FIGS. 1 and 2, comprising the steps of:

步骤101:汇总用户选择汇总项目与上报用户,判断所述汇总项目与所述上报用户是否有效,若为是,则生成汇总表格式,上报用户在所述汇总表格式上填写己方数据后生成当期汇总表并导出。 Step 101: the user selects a summary item summary report and the user determines the item summary report and the user is valid, if YES, the generated summary table format, reports generated profit after the user to fill in the summary table own data format summary and export. 本发明中取数汇表采用了PHP、JavaScript、HTML、CSS等语言,并大量使用了AJAX技术,通过各项技术完美的结合,使用户得到了更好的体验,获得了更多更精准的分析数据。 The present invention uses a fetch Glossary PHP, JavaScript, HTML, CSS and other languages, and extensive use of AJAX technology, combined with the perfect through the technology, so that users get a better experience, gained more and more accurate analyze data. 服务器使用了Linux操作系统、Apache Web服务器软件,通过HTTP协议为用户进行实时服务。 The server uses the Linux operating system, Apache Web server software for real-time services to users via HTTP protocol. 并且本发明汇表取数的程序方面使用了MVC架构,用户只能看到一段呼叫行为的网址,而无法根据这个网址得到任何文件,使得系统安全性增加。 Glossary and procedures to take number of the present invention uses the MVC architecture, user behavior can only see the URL for a call, but can not get any file from this site, making the system safety is increased. 本发明采用对应分层,利于压缩成本,减少了代码的复制,即减少了代码的维护量,同时,还极大的方便了单元测试。 Corresponding to the present invention adopts a layered, conducive to reduce costs, reduce the replication of code, i.e., reduced maintenance code, while also greatly facilitates the testing unit.

[0015] 更进一步的,在上述生成汇总表格式时,同步的通过短信通知上报用户已生成所述汇总表格式。 [0015] still further, in the above summary table format generating, synchronized as SMS report the user has to generate the summary table format.

[0016] 在本发明的另一较佳实施例中,所述步骤101还包括服务器部署步骤: [0016] In another preferred embodiment of the present invention, the step 101 further comprises the step of deploying the server:

在所述服务器为阿帕奇服务器,在所述阿帕奇服务器上安装Linux操作系统; In the Apache server is a server, the Linux operating system installed on the Apache server;

将汇表取数服务器与域名绑定,所述汇表取数服务器通过Internet网与所述阿帕奇服务器通信连接。 The glossary access server binding domain, taking the number of server connections glossary of the Apache server communicate with the Internet network.

[0017] 更进一步的,所述步骤101还包括:在所述阿帕奇服务器上安装超文本预处理语言系统与关联数据库管理系统。 [0017] Further still, the step 101 further comprises: mounting Language Hypertext Preprocessor systems and relational database management systems on the Apache server.

[0018] 更进一步的,所述步骤101具体的还包括:将汇总表格式放置在所述阿帕奇服务器的发布目录内。 [0018] Still further, the step 101 further comprises specifically: Tabular summary of the published directory disposed within the Apache server.

[0019] 为了更详尽的描述本发明,以下列举服务器部署步骤的实施例。 [0019] For a more detailed description of the present invention, the following examples include server deployment steps.

[0020] 在服务器上安装Linux操作系统,所述服务器为Apache服务器(阿帕奇服务器); 将取数汇表服务器与需要使用的域名进行绑定,并保证DNS域名系统能够正确解析; 安装PHP超文本预处理语言系统,使所述Apache服务器支持PHP超文本预处理语言系 [0020] installed on a server Linux operating system, the Apache server is a server (Apache server); the number of taken Glossary bind the domain name server requires the use of, and to ensure that the system can correctly resolve DNS name; installed PHP hypertext Preprocessor language system, the Apache server PHP hypertext Preprocessor language support system

统; EC;

安装Mysql关联数据库管理系统的数据库; Installation Mysql database relational database management system;

将汇总表格式放置在所述Apache服务器的发布目录上,并配置程序相关参数,方便了用户汇总或上报。 The tabular summary published directory placed on the Apache server, and program configuration parameters, the user convenience or summary report.

[0021] 应当理解的是,本发明的应用不限于上述的举例,对本领域普通技术人员来说,可以根据上述说明加以改进或变换,所有这些改进和变换都应属于本发明所附权利要求的保护范围。 [0021] It should be appreciated that the present invention is applied is not limited to the above-described example, those of ordinary skill in the art, can be modified or converted according to the above description, all such modifications and variations shall fall within the appended claims of the invention protected range.

Claims (5)

  1. 1.一种汇表取数方法,其包括以下步骤: 汇总用户选择汇总项目与上报用户,判断所述汇总项目与所述上报用户是否有效,若为是,则生成汇总表格式,上报用户在所述汇总表格式上填写己方数据后生成当期汇总表并导出。 A glossary access method comprising the steps of: summing up the selected item summary report and the user determines the item summary report and the user is valid, if YES, the generated summary table format, the user reporting summary of the profit generated summary table fill own format and data export.
  2. 2.根据权利要求1所述的汇表取数方法,其特征在于,在上述生成汇总表格式时,同步的通过短信通知上报用户已生成所述汇总表格式。 Glossary The access method according to claim 1, wherein when said generated summary table format, the user has synchronized report generated by the SMS notification summary table format.
  3. 3.根据权利要求1所述的汇表取数方法,其特征在于,所述汇表取数方法还包括服务器部署步骤: A、在所述服务器为阿帕奇服务器,在所述阿帕奇服务器上安装Linux操作系统; B、将汇表取数服务器与域名绑定,所述汇表取数服务器通过Internet网与所述阿帕奇服务器通信连接。 Glossary The access method according to claim 1, wherein the glossary access method further comprises the step of deploying the server: A, the Apache server is a server, the Apache Linux operating system installed on the server; B, the glossary access server binding domain, the glossary access Apache server connected with the communication server through the Internet network.
  4. 4.根据权利要求3所述的汇表取数方法,其特征在于,所述步骤A具体的包括:在所述阿帕奇服务器上安装超文本预处理语言系统与关联数据库管理系统。 4. A fetching method according to claim Glossary 3, wherein said step A comprises: mounting Language Hypertext Preprocessor systems and relational database management systems on the Apache server.
  5. 5.根据权利要求3所述的汇表取数方法,其特征在于,所述步骤A具体的包括:将汇总表格式放置在所述阿帕奇服务器的发布目录内。 The access method according to claim 3 glossary, wherein said step A comprises: placing in a tabular summary of the Apache server publishing directory.
CN 201310142479 2013-04-23 2013-04-23 Method for data acquisition of summary report CN103235809A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201310142479 CN103235809A (en) 2013-04-23 2013-04-23 Method for data acquisition of summary report

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201310142479 CN103235809A (en) 2013-04-23 2013-04-23 Method for data acquisition of summary report

Publications (1)

Publication Number Publication Date
CN103235809A true true CN103235809A (en) 2013-08-07

Family

ID=48883850

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201310142479 CN103235809A (en) 2013-04-23 2013-04-23 Method for data acquisition of summary report

Country Status (1)

Country Link
CN (1) CN103235809A (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2000072197A2 (en) * 1999-05-21 2000-11-30 E-Numerate Solutions, Inc. Reusable data markup language
CN201974846U (en) * 2010-10-29 2011-09-14 无锡永中软件有限公司 Data collecting and counting system
CN102611724A (en) * 2011-01-25 2012-07-25 中国移动通信集团公司 Server notice data synchronization and synchronization server migration method, system and device

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2000072197A2 (en) * 1999-05-21 2000-11-30 E-Numerate Solutions, Inc. Reusable data markup language
CN201974846U (en) * 2010-10-29 2011-09-14 无锡永中软件有限公司 Data collecting and counting system
CN102611724A (en) * 2011-01-25 2012-07-25 中国移动通信集团公司 Server notice data synchronization and synchronization server migration method, system and device

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
胡立辉: "《基于B_S的超级汇总报表处理系统的设计》", 《计算机工程与设计》, vol. 26, no. 7, 28 July 2006 (2006-07-28), pages 1900 - 1906 *

Similar Documents

Publication Publication Date Title
CN102215253A (en) Layered exchange and control method for real-time monitoring system data by power dispatching
CN101256589A (en) Method and system for pushing-sending service information
CN103458033A (en) System for providing services of event-driven service-oriented internet of things and working method thereof
US20140230006A1 (en) Instrumentation and monitoring of service level agreement (sla) and service policy enforcement
CN101257694A (en) Mobile communication network managing intelligent sending method based on information support system
CN103593434A (en) Application recommendation method and device and server equipment
CN102325191A (en) Fully automatic treatment method and frame without page refresh
CN102279884A (en) Based on Web pages for data acquisition and display, system and Web server
CN102368261A (en) Expandable running maintenance report generation method
US20140201321A1 (en) Systems, methods, and/or apparatus for enabling communication between devices using different communication protocols
CN102208991A (en) Blog processing method, device and system
CN103136335A (en) Data control method based on data platforms
CN102970343A (en) Method and device for displaying push information
CN102404126A (en) Charging method of cloud computing during application process
CN101770449A (en) Dynamic report generation method and device employing XML
US20150100679A1 (en) Web application monitoring verification
CN103699108A (en) OBD (on-board diagnostics) technology-based motor vehicle real-time monitoring system
CN104135069A (en) Method for configuring operating parameters of secondary equipment of intelligent substation
CN1889110A (en) Intelligent prompting system for weather and traffic state
CN102255389A (en) Method for implementing intensive intelligent substation based on intelligent power grid system
CN103337191A (en) Public transportation information real-time sharing and query system and method
CN101446971A (en) Method for building content management system and device thereof
CN102413486A (en) Terminal information detection method and system thereof
CN101266545A (en) Electric power industry integral supporting platform
CN103269381A (en) Cloud-computing-based WEB-supervisory control and data acquisition (SCADA) energy management and monitoring system

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
RJ01