CN112183050A - Method and system for realizing automatic data report design and collection - Google Patents

Method and system for realizing automatic data report design and collection Download PDF

Info

Publication number
CN112183050A
CN112183050A CN202011081777.7A CN202011081777A CN112183050A CN 112183050 A CN112183050 A CN 112183050A CN 202011081777 A CN202011081777 A CN 202011081777A CN 112183050 A CN112183050 A CN 112183050A
Authority
CN
China
Prior art keywords
excel
data
collection
report
attachment
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
CN202011081777.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.)
Guizhou Power Grid Co Ltd
Original Assignee
Guizhou Power Grid Co Ltd
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 Guizhou Power Grid Co Ltd filed Critical Guizhou Power Grid Co Ltd
Priority to CN202011081777.7A priority Critical patent/CN112183050A/en
Publication of CN112183050A publication Critical patent/CN112183050A/en
Pending legal-status Critical Current

Links

Images

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/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/958Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The invention discloses a method for realizing automatic data report design and collection, and also relates to a system, which helps realize quick information acquisition and collection in a simple, convenient and quick way by utilizing information and data processing technology, thereby saving a large amount of time wasted by staff in manual collection and improving the working efficiency; the standardized collection of the report forms and the data and the networked, paperless and digital management of the whole-process management are realized.

Description

Method and system for realizing automatic data report design and collection
Technical Field
The invention relates to the technical field of automatic data processing, in particular to a method for realizing automatic data report design and collection and a system.
Background
With the continuous increase of business volume of enterprises, particularly, a large number of reports are required to be generated in daily work, the format and the content of the reports are changed frequently, a large amount of time and energy are consumed in the report collection statistics and summarization and data verification process, the reports are designed, distributed, collected and summarized, the efficiency is extremely low, the process is complicated, and a large amount of work needs to be carried out manually due to the fact that no tool of a system is used for supporting, so that the daily work volume of staff is increased, a lot of important time is put on a lot of meaningless repetitive work by the staff, and the work efficiency of the staff is reduced. Therefore, a simple, convenient and quick tool is needed to help the staff to perform quick information acquisition and collection, so that a large amount of time wasted in manual collection of the staff is saved, and the working efficiency is improved.
Disclosure of Invention
In view of the above, the present invention provides a method and a system for implementing automatic data report design and collection, which helps to implement information collection and summarization, thereby saving a lot of time wasted in manual collection and improving work efficiency; meanwhile, the standardized collection of reports and data and the networked, paperless and digital management of the whole-process management are realized.
The purpose of the first aspect of the invention is realized by the following technical scheme:
the method for realizing the automatic data report form design and collection comprises the following steps
Collecting Excel reports and report contents of related unified templates, and performing database model modeling through a background algorithm;
providing JSON format data based on HTTP protocol standard for a user and a third party platform, and providing an interface for the third party access platform, wherein the interface is used for passively receiving a uniform report Excel template attachment of an independent flow;
when the attachment is received, feeding back the attachment processing condition to the third-party platform, and after the third-party platform confirms the attachment processing condition, the system carries out persistence processing on the Excel attachment and the related flow information;
when the distributed users in the related process submit Excel accessories and process related contents, the system verifies the Excel accessories, extracts data after verification and persists the data in a database;
the process initiator logs in the system through the network and the browser by using the address and the account password provided by the system through the system, and counts, summarizes and analyzes Excel attachment statistics in the initiated independent process.
Particularly, the persistence processing mode is that the Excel attachment is stored in an attachment form, rows and columns in the Excel attachment are split, data obtained after splitting are used for building Excel model modeling and are persisted in a database, and a user verifies, counts, summarizes and analyzes the content of the Excel attachment submitted in the independent flow.
The second aspect of the invention is realized by the following technical scheme:
the system for realizing the automatic data report design and collection adopts a B/S layered architecture and comprises
The environment of the operation is that the operation,
a durable layer, wherein the durable layer is formed by a plurality of layers,
the data layer is used for realizing data processing work including caching and reading of data;
the business layer comprises a basic information module, a report automatic acquisition module, a report automatic counting and analyzing module and a data interface module;
and the display layer adopts an Anguboss framework and is used for displaying and outputting the requested content.
Particularly, the user views, counts, queries and analyzes the automatically collected Excel report form through a web page.
In particular, the HTTP protocol based on a browser and the RESTful interface style are adopted;
in particular, the technical stack adopted therein comprises JavaScript, html5, CSS language;
in particular, the framework employs the latest open source angularjs, angularjs components, jQuery.
Particularly, by adopting a B/S system architecture, a user views, counts, queries and analyzes an automatically acquired Excel report form through a designed web page through an intelligent terminal.
The invention has the beneficial effects that:
1) the method has good expansibility: the invention provides a module design divided according to functions, aiming at the functions provided by a report, a system is divided into Excel acquisition modules; an Excel gathering and counting module; and an Excel query analysis module. The basic module in the system is subdivided into user modules; a permission module; and a role module. For the system architecture adopted by the system, a mainstream full back end separation mode is adopted, the angularjs of MVVM is adopted at the front end, and the back end and the front end are expanded in function. The spring boot and the related plug-in are adopted at the rear end, and the advantage of convenient development can be fully exerted.
2) Platform ease of use and security: the platform usability is explained from three aspects, namely, the processing based on the most common Excel file is supported, and a file client comprises a WPS and a micro soft office Excel; secondly, based on the B/S system architecture, a user can use the system directly through a common browser, and the user interaction interface adopts a flat style, so that the interface structure is clear and the operation is convenient; third, the system provides a JSON data format based on the HTTP protocol for the third-party platform, the protocol is general, the data is clear, and the third-party platform can well perform interface butt joint. The Security is simply stated, the system provides data transmission of an HTTPS encryption protocol, meanwhile, a background strictly verifies the user authority, and the Spring Security and JWT components are adopted for achieving the purpose.
Additional advantages, objects, and features of the invention will be set forth in part in the description which follows and in part will become apparent to those having ordinary skill in the art upon examination of the following or may be learned from practice of the invention. The objectives and other advantages of the present invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described in detail with reference to the accompanying drawings, in which:
FIGS. 1, 2 and 3 are schematic flow charts of the steps of the method of the present invention;
fig. 4 is a schematic structural diagram of the system of the present invention.
Detailed Description
Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. It should be understood that the preferred embodiments are illustrative of the invention only and are not limiting upon the scope of the invention.
The invention discloses a method for realizing automatic data report design and collection, which comprises the following steps:
(1) collecting Excel reports and report contents of related unified templates, and performing database model modeling through a background algorithm;
(2) providing JSON format data based on HTTP protocol standard for a user and a third party platform, and providing an interface for the third party access platform, wherein the interface is used for passively receiving a uniform report Excel template attachment of an independent flow;
(3) when the attachment is received, feeding back the attachment processing condition to the third-party platform, and after the third-party platform confirms the attachment processing condition, the system carries out persistence processing on the Excel attachment and the related flow information;
(4) when the distributed users in the related process submit Excel accessories and process related contents, the system verifies the Excel accessories, extracts data after verification and persists the data in a database;
(5) the process initiator logs in the system through the network and the browser by using the address and the account password provided by the system through the system, and counts, summarizes and analyzes Excel attachment statistics in the initiated independent process.
The persistence processing method comprises the steps of storing the Excel attachment in an attachment mode, splitting lines and columns in the Excel attachment, using data obtained after splitting to build an Excel model for modeling, and persisting the Excel model in a database, and verifying, counting, summarizing and analyzing the content of the Excel attachment submitted in an independent flow by a user.
Fig. 1-3 of the present invention are schematic flow diagrams of the method of the present invention, and an OA process is taken as a third party platform docking example, as shown in fig. 1, in an OA system, when a user a initiates a report distribution process (including distribution to B, C users), and the process is submitted, the OA automatically invokes a report collection interface of the system, pushes information such as a process name (naming format convention such as "xxx — report function name"), an ID, a submission date, a report Excel template attachment (providing an attachment as an identifier of a template at the same time), a process initiator, and distribution user information (including a user name, an ID, an organization name, an ID, a department name, and an ID). After the information is submitted, the report acquisition module of the system provides automatic feedback to check state information, if the check fails, the error is fed back to the user A, and the user A can submit the flow again; if the information is successfully submitted, the system processes the information submitted by the user A, and the processing method is as shown in FIG. 1.
As shown in fig. 2, when a user B, C submits a distribution flow after receiving the distribution flow in the OA system, the user submits flow information and an Excel attachment to the OA system, and after the information is submitted, the report collection module of the OA system provides automatic feedback for checking and verifying state information, and if the verification fails, the report collection module feeds back an error to a B, C user, so that the user B, C can resubmit the flow; if the submission is successful, the system processes B, C the information submitted by the user in the manner shown in FIG. 2.
As shown in fig. 3, after the user B, C has submitted the distribution flow information and the attachments to the system, the user a logs in the system through the browser to manage the flow Excel attachments initiated in the OA, and the user a can manage the report by using the functions of summary statistics, query and analysis of the Excel attachments provided by the system.
As shown in FIG. 4, the present invention also provides a system for realizing the automatic report design and collection of data, which adopts a B/S layered architecture and comprises (1) an operation environment; (2) a permanent layer; (4) and (3) a data layer: the data processing system is used for realizing data processing work including caching and reading of data; (4) and (4) a service layer: the system comprises a basic information module, a report automatic acquisition module, a report automatic counting and analyzing module and a data interface module; (5) a display layer: and adopting an Anguboss framework for requesting the display output of the content.
In this embodiment, the system uses a browser-based HTTP protocol and a RESTful interface style. The technical stack adopted by the method comprises JavaScript, html5 and CSS languages, and the framework adopts latest open source angularjs, angularjs components (routing, authority, forms and the like), jQuery, jQuery. And viewing, counting, inquiring and analyzing the automatically collected Excel report form by the user through the web page.
Fig. 4 is a schematic structural diagram of the system of the present invention, as shown in the figure, the system of the present invention is developed by adopting the B/S layered architecture promoted by the current industry, in the Browser/Server system, a user can send a request to a plurality of servers distributed on the network through a Browser. The Browser/Server structure greatly simplifies the work of the client, only a small amount of client software needs to be installed and configured on the client (almost zero installation, only one current popular Browser needs to access resource information on the Server), the Server can bear more work, and the access to the database and the execution of the application program are completed on the Server. The system business modular design mainly comprises a basic information module, a report automatic acquisition module, a report automatic statistics module, a report automatic analysis module and a data interface module.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, and the program may be stored in a computer readable storage medium, and when executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium. The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc.
Finally, the above embodiments are only intended to illustrate the technical solutions of the present invention and not to limit the present invention, and although the present invention has been described in detail with reference to the preferred embodiments, it will be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions, and all of them should be covered by the claims of the present invention.

Claims (8)

1. The method for realizing the automatic data report design and collection is characterized in that: the method comprises the following steps
Collecting Excel reports and report contents of related unified templates, and performing database model modeling through a background algorithm;
providing JSON format data based on HTTP protocol standard for a user and a third party platform, and providing an interface for the third party access platform, wherein the interface is used for passively receiving a uniform report Excel template attachment of an independent flow;
when the attachment is received, feeding back the attachment processing condition to the third-party platform, and after the third-party platform confirms the attachment processing condition, the system carries out persistence processing on the Excel attachment and the related flow information;
when the distributed users in the related process submit Excel accessories and process related contents, the system verifies the Excel accessories, extracts data after verification and persists the data in a database;
the process initiator logs in the system through the network and the browser by using the address and the account password provided by the system through the system, and counts, summarizes and analyzes Excel attachment statistics in the initiated independent process.
2. The method for realizing the automatic report design and collection of data according to claim 1, wherein: the persistence processing mode is that Excel accessories are stored in an accessory form, lines and columns in the Excel accessories are split, data obtained after splitting are used for building Excel model modeling and are persisted in a database, and a user verifies, counts, summarizes and analyzes the content of the Excel accessories submitted in the independent flow.
3. The system for realizing the automatic data report design and collection is characterized in that: the system employs a B/S layered architecture including
The environment of the operation is that the operation,
a durable layer, wherein the durable layer is formed by a plurality of layers,
the data layer is used for realizing data processing work including caching and reading of data;
the business layer comprises a basic information module, a report automatic acquisition module, a report automatic counting and analyzing module and a data interface module;
and the display layer adopts an Anguboss framework and is used for displaying and outputting the requested content.
4. The system for implementing automated data reporting design and collection as recited in claim 3, wherein: and viewing, counting, inquiring and analyzing the automatically collected Excel report form by the user through the web page.
5. The system for implementing automated data reporting design and collection as claimed in claim 4, wherein: a browser-based HTTP protocol and RESTful interface style are employed.
6. The system for implementing automated data reporting design and collection as claimed in claim 5, wherein: the adopted technical stack comprises JavaScript, html5 and CSS languages.
7. The system for realizing the automatic report design and collection of the data according to the claim 5 or 6, characterized in that: the framework employs angularjs, angularjs components, jQuery.
8. The system for implementing automated data reporting design and collection as claimed in claim 5, wherein: the system adopts a B/S system architecture, and a user views, counts, queries and analyzes an automatically acquired Excel report form through a designed web page by using an intelligent terminal.
CN202011081777.7A 2020-10-12 2020-10-12 Method and system for realizing automatic data report design and collection Pending CN112183050A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011081777.7A CN112183050A (en) 2020-10-12 2020-10-12 Method and system for realizing automatic data report design and collection

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011081777.7A CN112183050A (en) 2020-10-12 2020-10-12 Method and system for realizing automatic data report design and collection

Publications (1)

Publication Number Publication Date
CN112183050A true CN112183050A (en) 2021-01-05

Family

ID=73948159

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011081777.7A Pending CN112183050A (en) 2020-10-12 2020-10-12 Method and system for realizing automatic data report design and collection

Country Status (1)

Country Link
CN (1) CN112183050A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114385693A (en) * 2021-12-22 2022-04-22 贵州电网有限责任公司 Intelligent data statistical method based on RPA robot

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1504879A (en) * 2002-12-02 2004-06-16 深圳市中兴通讯股份有限公司 Method and system for realizing cross-platform and complex statistics calculation statement
CN101719119A (en) * 2009-11-18 2010-06-02 上海众恒信息产业有限公司 Report management system and method
CN102509163A (en) * 2011-11-21 2012-06-20 山东浪潮齐鲁软件产业股份有限公司 Realization method for unified management and centralized check of enterprise report
CN102722533A (en) * 2012-05-09 2012-10-10 浙江图讯科技有限公司 Method and system for displaying and filling report
CN103064916A (en) * 2012-12-20 2013-04-24 成都羿明科技有限公司 Emin DI data integration engine and report generation method
CN103345533A (en) * 2013-07-26 2013-10-09 北京中电普华信息技术有限公司 Data storage method and device
CN105096083A (en) * 2015-07-30 2015-11-25 中国石油化工股份有限公司 Information system for warehouse
CN105447681A (en) * 2015-11-22 2016-03-30 沈阳黎明航空发动机(集团)有限责任公司 Physicochemical detection control and information management system
CN106649225A (en) * 2016-12-30 2017-05-10 冶金自动化研究设计院 JSON self-definition-based report generation system and method
CN111061732A (en) * 2019-12-05 2020-04-24 深圳迅策科技有限公司 Report generation method based on big data processing
CN111179634A (en) * 2019-12-04 2020-05-19 浙江科技学院 Indoor parking system based on Wi-Fi position fingerprint

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1504879A (en) * 2002-12-02 2004-06-16 深圳市中兴通讯股份有限公司 Method and system for realizing cross-platform and complex statistics calculation statement
CN101719119A (en) * 2009-11-18 2010-06-02 上海众恒信息产业有限公司 Report management system and method
CN102509163A (en) * 2011-11-21 2012-06-20 山东浪潮齐鲁软件产业股份有限公司 Realization method for unified management and centralized check of enterprise report
CN102722533A (en) * 2012-05-09 2012-10-10 浙江图讯科技有限公司 Method and system for displaying and filling report
CN103064916A (en) * 2012-12-20 2013-04-24 成都羿明科技有限公司 Emin DI data integration engine and report generation method
CN103345533A (en) * 2013-07-26 2013-10-09 北京中电普华信息技术有限公司 Data storage method and device
CN105096083A (en) * 2015-07-30 2015-11-25 中国石油化工股份有限公司 Information system for warehouse
CN105447681A (en) * 2015-11-22 2016-03-30 沈阳黎明航空发动机(集团)有限责任公司 Physicochemical detection control and information management system
CN106649225A (en) * 2016-12-30 2017-05-10 冶金自动化研究设计院 JSON self-definition-based report generation system and method
CN111179634A (en) * 2019-12-04 2020-05-19 浙江科技学院 Indoor parking system based on Wi-Fi position fingerprint
CN111061732A (en) * 2019-12-05 2020-04-24 深圳迅策科技有限公司 Report generation method based on big data processing

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114385693A (en) * 2021-12-22 2022-04-22 贵州电网有限责任公司 Intelligent data statistical method based on RPA robot

Similar Documents

Publication Publication Date Title
CN108519967B (en) Chart visualization method and device, terminal and storage medium
CN111143352B (en) Data processing method and device, electronic equipment and storage medium
CA2819359C (en) Using text messages to interact with spreadsheets
US8787616B2 (en) Document processing system and method
US20230305907A1 (en) A rest interface specification encapsulation system based on network sniffing
CN103246963B (en) Based on the staffs training system of Internet of Things
CN110868322B (en) Network management method, system, device and storage medium for distributed message service
CN115168352A (en) Data association method, terminal and storage medium
CN111694561A (en) Interface management method, device, equipment and storage medium
WO2021093673A1 (en) E-mail sending method, apparatus and device, and computer-readable storage medium
CN109902182A (en) Knowledge data processing method, device, equipment and storage medium
CN112183050A (en) Method and system for realizing automatic data report design and collection
CN111427899A (en) Method, device, equipment and computer readable medium for storing file
CN114741261A (en) Distributed link tracking method, device, equipment and storage medium
CN112579632A (en) Data verification method, device, equipment and medium
CN111026972A (en) Subscription data pushing method, device, equipment and storage medium in Internet of things
CN115134353A (en) Automatic file uploading method, file previewing method, device, medium and equipment
CN114201659A (en) Message track transmission query method, device and system
CN111401889B (en) Credit data processing method, device, equipment and medium based on block chain
CN114297495A (en) Service data searching method and device, electronic equipment and storage medium
CN109803017B (en) File intercommunication method and device, computing equipment and computer readable storage medium
CN111399825A (en) API (application programming interface) development management method and system based on API document
CN113765773B (en) Method and device for processing communication record
CN116340363B (en) Data storage and loading method based on relational database and related device
CN116610683B (en) Data binding 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