# oa

**Repository Path**: itcode-itcode/oa

## Basic Information

- **Project Name**: oa
- **Description**: 本项目根据JFinalOA重构，原项目：https://gitee.com/glorylion/JFinalOA
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 8
- **Created**: 2019-06-07
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#JFinalOA

本项目根据：[JFinalOA](https://gitee.com/glorylion/JFinalOA) 重构，因为本人用作者的项目没跑起来，特重构一份。

```
    idea: 2017
    jdk:1.8
    maven: 3.5.0
```

运行方法：

```
    1、clone项目导入idea
    2、导入idea，ctrl+alt+shift+s,设置里面选中facets,选中web，若没有请自行创建，配置项目下面的web.xml位置
    3、配置到本地tomcat,tomcat用的7.0
    4、导入doc目录下的sql脚本，首先导入jfinaloa.sql，导入时大概有200多行错误，不管他，再导入视图sql，最后在此导入jfinaloa.sql就行了
    5、启动项目访问即可。
```

maven命令运行
    
    1.edit configurations--新建maven
    2.commond line中输入tomcat7:run  或使用jetty:run或者tomcat:run
    3.运行，默认端口为80，若需修改在pom.xml中修改即可.
![输入图片说明](https://gitee.com/uploads/images/2018/0521/110108_2ab4b4a1_493095.png "xxxxx.png")
    
如何登陆？

    访问http://localhost/oa，默认用户名密码都为：admin

mysql数据库5.6+请用如下语句创建视图
```
CREATE OR REPLACE VIEW V_TASKLIST AS
SELECT A.ID_ AS TASKID,
       A.PROC_INST_ID_ AS INSID,
       A.TASK_DEF_KEY_ AS TASKDEFKEY,
       D.KEY_ AS DEFKEY,
       D.NAME_ AS DEFNAME,
       A.NAME_ AS TASKNAME,
       A.ASSIGNEE_ AS ASSIGNEE,
 I.USER_ID CANDIDATE,
       A.PROC_DEF_ID_ AS DEFID,
       A.DELEGATION_ AS DELEGATIONID,
       A.DESCRIPTION_ AS DESCRIPTION,
       date_format(A.CREATE_TIME_,'%Y-%m-%d') AS CREATETIME,
       date_format(A.DUE_DATE_,'%Y-%m-%d') AS DUEDATE
  FROM ACT_RU_TASK A
  LEFT JOIN (SELECT DISTINCT * FROM (SELECT TASK_ID_, USER_ID_ USER_ID
                    FROM ACT_RU_IDENTITYLINK I, ACT_RU_TASK T
                      WHERE TASK_ID_ IS NOT NULL
                        AND USER_ID_ IS NOT NULL
                        AND I.TASK_ID_ = T.ID_
                        AND T.ASSIGNEE_ IS NULL
                        AND TYPE_ = 'candidate'
                    )U) I
    ON A.ID_ = I.TASK_ID_ 
   LEFT JOIN ACT_RE_PROCDEF D 
   ON A.PROC_DEF_ID_ = D.ID_;
```