Complete solution for integration of Finereport and OA systems

With the rapid development of social information, Enterprise Informatization has also been improved, and how to improve office efficiency has become an important and urgent task of enterprises, traditional paper reports and other files not only waste paper, difficult to archive, difficult to access, not easy to statistics, how to more effective and faster to improve office efficiency and office quality, has become the biggest bottleneck restricting the efficiency improvement.

From the point to the surface, from the Friends of the computer desktop a wide range of report files, obviously can see the busy day-to-day work, but the feeling of processing the document is not much.

Geographical Restrictions : Because the group can not be real-time and subsidiary to achieve synchronous office, in the communication cost is very high, and the office efficiency is low, the production report data and financial data is inaccurate, and not timely.

the difference of staff quality : everyone's way of doing things is different, resulting in "porridge" phenomenon, which requires us to use process tools and reporting tools to standardize carding work.

file loss : Employee turnover, resulting in loss of report documents has become the biggest loss of enterprises.

Through the phenomenon to see the essence, the realization of information is imminent, the group urgently needed a set of OA and integrated reporting software system, and pan-micro OA just meet our needs, and Finereport report is seamless integration in the pan-micro OA.

Effect Show

first, development tools

Let us first look at this B/s architecture development environment:

Operating system: Redhat 5.4 Linux 64-bit

WBE Application Server: RESIN

Development language: JAVA

Database: ORACLE 10.2g

Report development tool: Finereport

Web Development tools: Dreamweaver 8

OA system: Pan-Micro Cooperative OA

Finereport data from Oracle's existing database, through the new menu OA, link JSP Web page, using the OA Role and Rights control unit in the JSP page (embedded report page) to do two development, and authorized users to access the report.

ii. sources of data

Since OA already has a ready-made oracle10g database, our report requires a database source mainly from the OA database table.

First, we'll open the FR designer, connect to the data source, and the menu bar at the top of the designer-server-defines the data connection. Select the data source that you just named with your mouse, and display the corresponding data source properties edit panel on the right, there are five properties:

Database: Oracle

Drive: Oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@192.168.x.x:1521: Instance Name

Enter your username and password and click on the "Test Connection" button as shown in:

Prompt, the test succeeded, on behalf of the Oracle database connection succeeded.

Main database tables:

1. Workflow_currentoperator Workflow Request node operator Information table

, the following fields are stored: Request ID

, User ID, workflow type, workflow ID, operation Node ID, operation date, operation time

2. Workflow_requestlog Workflow Request Signature Log table

, the following fields are stored: operator, operation time, client IP, next node ID, workflow ID, request ID, operation date, Operation Node ID

3, Formtable_main_4 sign the process of customizing the table, the following fields are stored: Head, Host department, sent, telephone, fax and other sensitive fields

4, hrmlocations Human Resources Office Location table

, store the following fields: City, country, telephone, fax, mobile phone.

Sysmaintenancelog System operation log Table

, the following fields are stored: Operation date, operation User ID, Operation time, type of operation, whether it is a process template

5. Workflow_currentoperator Workflow Request node operator Information Table

, the following fields are stored: Workflow ID

, workflow type, operation Node ID, Date Received, Time received, marking process archived, Operation time

6, Hrmdepartment Human Resources Department table, the following fields are stored: Parent Department ID, Division 1, all parent department ID, department name, department logo, etc.

such as Hrmsubcompany Human Resources Division table, the following fields are stored: The Headquarters ID, Division abbreviation, Division description, etc. hrmresource Human Resources table, the following fields: ID card number, account ID, hometown, work status, password, etc. n more information, here no longer introduced.

third, the demand analysis

Based on the Finereport report, and integrated into the OA, through the Finereport implementation of the database complex query/fill the way, in the office OA to achieve real-time interaction, so that the OA project to spend the least effort in reporting work. Reflected in:

1. Document signing, centralized report

2, attendance data, centralized report

3. Asset management, centralized reporting

4, personnel login, centralized control

5, Process Control, centralized and unified

6, authority control, centralized and unified

Then spend most of the time to solve problems, improve performance, decision-making, effective implementation and other core issues, thereby improving work efficiency.

Iv. Data Analysis

First analyze the project data collection, report data through the Office OA process, with the accumulation of time, bit by bit.

Data range: Fixed assets, personnel login, group/Subsidiaries of the official documents, application, attendance and other data

Data plane: Employee level

Longitudinal dimension: OA complex process

Horizontal dimension: Branch Office, Department, employee, attendance type, etc.

Time Dimension: Date

V. Design of the report

Generally speaking, a complete report design process is broadly divided into the following steps:

Open the designer, skip the configuration data source These simple steps, go straight to the design report topic, for example, the group to sign the report, first, to understand the needs of the signing of the field, usually the group confidential Secretary to manage the issuance and collection, the fields are listed all out,

Second, the report of the summary of the reporting of the Office of the OA process part of the process, review the process,

Include the President confidential Secretary of the date of receipt, the President confidential Secretary needs to statistical communications units, documents subject, and then decide to send to which group in charge of leadership, and then the statistics in charge of leadership and the counter-signer's opinion, finally filed to the manager and the President confidential Secretary, so this report is of great significance, Can save the President confidential Secretary frequent registration-tray and leadership, improve the leadership of the efficiency of the signing.

The constraint is RequestID, and the table is associated with the table by RequestID, writing out the criteria that the field needs to query, and the date is judged by the process node "viewed" or "committed" as the time criterion.

After thinking clearly, the direct design of the report field of SQL, if the ordinary Web page to make this signing report, I think I will go crazy. Because it is too complicated, and Oracle's long Type field in the PL is not displayed, and the Finereport tool can be displayed, really let people admire.

Click "Preview", the results are displayed, if the page will still exist cache, very annoying, and instead of using the FR designer, more concise and faster.

In order to improve the browsing speed, the design needs to consider paging, click "File Number", right-click, set the condition properties. Set the formula to &b4% 31, set 31 lines after paging. This is a one-month data that makes sense for the report.

vi. Control of permissions

JSP page code writing, see Example jtgw.jsp for details

<%@ pageimport= "Weaver.general.Util"%>

<%@ page import= "weaver.conn.*"%>

<%@ pagelanguage= "java" contenttype= "text/html; CHARSET=GBK "%><%@ include file="/systeminfo/init.jsp "%>

<jsp:usebeanid= "rs" class= "Weaver.conn.RecordSet" scope= "page"/>

<HTML><HEAD>

<linkhref= "/css/weaver.css" Type=text/css rel=stylesheet>

<%

String imagefilename = "/images/hdsystem.gif";

String titlename = "Summary form of official documents";

String needfav = "1";

String needhelp = "";

%>

<BODY>

<%@ includefile= "/systeminfo/toptitle.jsp"%>

<%@ includefile= "/systeminfo/rightclickmenuconent.jsp"%>

<%@ includefile= "/systeminfo/rightclickmenu.jsp"%>

<%

if (! Hrmuservarify.checkuserright ("oa-report-02", user)) {

Response.sendredirect ("/notice/noright.jsp");

Return

}

%>

<metahttp-equiv= "Content-type" content= "text/html;charset=gb2312"/>

<title> reports </title>

<!--here with the IFrame method embedded in the Finereport report page--

<iframename= "SBJLJGML" id= "SBJLJGML" src= "/reportserver?reportlet=jtgw.cpt&op=write" width= "100%" height= " 100% "frameborder=" 0 "border=" 0 "marginwidth=" 0 "marginheight=" 0 "scrolling=" yes "target=" contents "align=" center " ></iframe>

<body>

</body>

In addition, Oracle inserts two sql:

INSERT into systemrights values (' 902 ', ' summary table of official documents ', ' 3 ', ' 0 ');

INSERT into systemrightdetail values (' 9002 ', ' summary of official documents ', ' oa-report-02 ', ' 902 ')

Comment oa-report-01

Permissions: 901 start numbering

Detail Unit: 9001 Start numbering

Vii. Deployment Reports

1, install the Finereport installation program

2, through the SSH tool, the extracted \finereport_6.5\webreport\web-inf address under the Reportlets,resources file upload to the server \weaver\ecology\web-inf directory.

3, through the SSH tool, the \finereport_6.5\webreport\web-inf\lib address under the Fr-server-6.5.jar,fr-third-6.5.jar,ojdbc14.jar file upload as for the server \ The Weaver\resin\lib directory.

4, in the Linux server \weaver\ecology\web-inf directory of Web. XML add content,

More than 5 configuration modifications completed, restart the resin service.

6, open IE, enter HTTP://LOCALHOST/WEBREPORT/REPORTSERVER?OP=FS, test whether can open.

7, on the Cisco firewall to map the external network IP to the OA intranet server, and open 80 ports, binding the company domain name to the OA extranet IP, and then in IE input http://oa.xx.com, you can access to the Finereport integrated OA system.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Complete solution for integration of Finereport and OA systems