# worklog

**Repository Path**: chenwei2399/worklog

## Basic Information

- **Project Name**: worklog
- **Description**: 就是简单的工作日志呀
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-07-22
- **Last Updated**: 2022-08-01

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

<p align="center">
	<img alt="logo" src="https://oscimg.oschina.net/oscnet/up-d3d0a9303e11d522a06cd263f3079027715.png">
</p>
<h1 align="center" style="margin: 30px 0 30px; font-weight: bold;">RuoYi v3.8.3</h1>
<h4 align="center">基于SpringBoot+Vue前后端分离的Java快速开发框架</h4>


## 暂时就是这么多

# **日志管理系統**

## 1.日志表

| ID              | int（主鍵） |                    |
| --------------- | ----------- | ------------------ |
| staff_id        | bigint      | not null 外键      |
| content         | String      |                    |
| work_time       | tinyint     | 工作時長           |
| approval_status | tinyint     | 審核狀態(11,12,13) |
| image_url       | string      | 圖片地址           |
| file_url        | string      | 文件地址           |
| created_at      | Date        | 創建時間           |
| updated_at      | Date        |                    |
|                 |             |                    |

## 2.項目表

| id         | int    | 項目id   |
| ---------- | ------ | -------- |
| name       | string | 項目名稱 |
| leader_id  | Long   | ID組長   |
| created_at | Date   | 創建時間 |
| updated_at | Date   |          |
| remark     | string | 备注     |



## 3.員工表（若依）

## 4.員工-項目表（多对多）

| staff_id   | int  | id（主键）                    |
| ---------- | ---- | ----------------------------- |
| project_id | int  | id（主键）                    |
| role       | int  | 角色（組長，後端，前端.....） |

## 5.部门表（若依）

## 6.组长-组员表

| leader_id | bigint | 组长 |
| --------- | ------ | ---- |
| member_id | bigint | 组员 |

## 6.1日报-项目表

| wl_id      | int  | 日报id |
| ---------- | ---- | ------ |
| project_id | int  | 项目id |



## 7.api

### 7.1 日志表

**增加一个日报** 参数：日志表

```json
POST {{localhost}}/worklog/log/add
Content-Type: application/json
Authorization: {{Authorization}}
参数
{
   "content": string ，必须
   " work_time":int，0-24 ，必须
    "log_type":int，1是日报，2是月报，必须
    "image_url"：string
    "file_url"：string
    "create_at":Date 必须
    "staff": {  object 必须
    	"userId": 1 必须
  	}
	"projects":[ 项目id，非必须
        {"id":1},
        {"id":3}
    ]
}
例如
request：
{
  "content": "劳资不想上班",
  "created_at":"2022-07-27 14:41:21",
  "staff": {
    "userId": 1
  },
   "projects":[ 
        {"id":1},
        {"id":3}
    ]
}
result：
{
  "msg": "操作成功",
  "code": 200
}
失败都是这样子的结构：
{
  "msg": "操作失败",
  "code": 500
}
```

**修改一个日报**：参数：日志表

```json
PUT {{localhost}}/worklog/log
Content-Type: application/json
Authorization: {{Authorization}}
参数：
{
    content: string ，非必须
    work_time:int，0-24 ，非必须
    log_type:int，1是日报，2是月报，非必须
    image_url：string
    file_url：string
}
例如

request：
{
  "id": 1,
  "content": "hello word 1"
}
result：
{
  "msg": "操作成功",
  "code": 200
}
```

**删除一或多个日报数据**：参数：ids

```
DELETE {{localhost}}/worklog/log/delete/{ids}
Authorization: {{Authorization}}
例如：
参数:4,5
 {{localhost}}/worlklog/log/delete/4,5

result：
{
  "msg": "操作成功",
  "code": 200
}
```

**得到日报列表**

```json
POST {{localhost}}/worklog/log/list
Content-Type: application/json
Authorization: {{Authorization}}

参数：
{
   " work_time":int，0-24 ，非必须
    "log_type":int，1是日报，2是月报，必须
    “approval_status”: 日报状态 ，非必须
    "staff": {  object 必须
    	"userId": 1 必须
  	}
}
例如：
result:
{
  "total": 2,
  "rows": [
    {
      "id": 1,
      "content": "hello word 1",
      "log_type": 1,
      "work_time": 0,
      "approval_status": 12,
      "image_url": null,
      "file_url": null,
      "created_at": "2022-07-27T11:35:31.000+08:00",
      "updated_at": "2022-07-27T12:36:38.000+08:00",
      "staff": null,
      "project": null
    },
    {
      "id": 2,
      "content": "劳资不想上班",
      "log_type": 1,
      "work_time": 0,
      "approval_status": 12,
      "image_url": null,
      "file_url": null,
      "created_at": "2022-07-27T12:35:45.000+08:00",
      "updated_at": null,
      "staff": null,
      "project": null
    }
  ],
  "code": 200,
  "msg": "查询成功"
}
```

**用日报id 获得日报详细信息（包括项目和用户）**

```
GET {{localhost}}/worklog/log/{id}
Content-Type: application/json
Authorization: {{Authorization}}

参数：2
例如：{{localhost}}/worlklog/log/2
result：
{
  "msg": "操作成功",
  "code": 200,
  "data": {
    "id": 2,
    "content": "劳资不想上班",
    "log_type": 1,
    "work_time": 0,
    "approval_status": 12,
    "image_url": null,
    "file_url": null,
    "created_at": "2022-07-27T12:35:45.000+08:00",
    "updated_at": null,
    "staff": {
      "searchValue": null,
      "createBy": null,
      "createTime": null,
      "updateBy": null,
      "updateTime": null,
      "remark": "管理员",
      "params": {},
      "userId": null,
      "deptId": null,
      "userName": null,
      "nickName": null,
      "email": "ry@163.com",
      "phonenumber": "15888888888",
      "sex": "1",
      "avatar": "",
      "password": "$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2",
      "status": "0",
      "delFlag": null,
      "loginIp": null,
      "loginDate": null,
      "dept": null,
      "roles": null,
      "roleIds": null,
      "postIds": null,
      "roleId": null,
      "admin": false
    },
    "project": [
      {
        "id": 1,
        "project_name": "java_pro3",
        "leader_id": 1,
        "create_at": "2022-07-27T14:26:55.000+08:00",
        "update_at": null,
        "remark": null
      }
    ]
  }
}
```



### 7.2 项目表

增加一个项目project

```
GET {{localhost}}//worklog/project/list
Content-Type: application/json
Authorization: {{Authorization}}
参数：
{
	"project_name": string, 必须
	"leader_id": int, 必须
	"remark": string, 非必须
}

例如：
传参：
{
  "project_name":"java_pro1"
  "leader_id": 1
}

result：
{
  "msg": "操作成功",
  "code": 200
}
```

查询项目列表

```
GET {{localhost}}//worklog/project/list
Content-Type: application/json
Authorization: {{Authorization}}

无参数

result：
{
  "total": 2,
  "rows": [
    {
      "id": 1,
      "project_name": "java_pro2",
      "leader_id": 1,
      "create_at": "2022-07-27T17:59:34.000+08:00",
      "update_at": null,
      "remark": null
    },
    {
      "id": 2,
      "project_name": "java_pro1",
      "leader_id": 1,
      "create_at": "2022-07-28T10:04:12.000+08:00",
      "update_at": null,
      "remark": null
    }
  ],
  "code": 200,
  "msg": "查询成功"
}

```

查询user登录 用户的所有项目

```
GET {{localhost}}/system/user/profile/userProject
Authorization: {{Authorization}}

无参数

result:
{
  "total": 0,
  "rows": [],
  "code": 200,
  "msg": "查询成功"
}

```

删除一个或多个项目以及对应的员工项目表

```
DELETE {{localhost}}//worklog/project/1，2
Content-Type: application/json
Authorization: {{Authorization}}

例如：
传参：1,2
{{localhost}}//worklog/project/1，2

result：
{
  "msg": "操作成功",
  "code": 200
}
```

更新一个项目

```
PUT {{localhost}}//worklog/project
Content-Type: application/json
Authorization: {{Authorization}}
参数：
{
	"id": int, 必须
	"project_name": string, 非必须
	"leader_id": int, 非必须
	"remark": string, 非必须
}

传参：
{
  "id": 2
  "project_name":"java_pro111111"
  "leader_id":1
}

result：
{
  "msg": "操作成功",
  "code": 200
}
```

通过组长id，查询对应项目列表

```
GET {{localhost}}//worklog/project/listbyid/1
Authorization: {{Authorization}}

例如：
传参：1
 {{localhost}}//worklog/project/listbyid/1

result：
{
  "total": 2,
  "rows": [
    {
      "id": 2,
      "project_name": "java_pro111111",
      "leader_id": 1,
      "create_at": "2022-07-28T10:04:12.000+08:00",
      "update_at": "2022-07-28T10:14:26.000+08:00",
      "remark": null
    },
    {
      "id": 4,
      "project_name": "java_pro4",
      "leader_id": 1,
      "create_at": "2022-07-28T10:12:14.000+08:00",
      "update_at": null,
      "remark": null
    }
  ],
  "code": 200,
  "msg": "查询成功"
}
```



### 7.3 员工-项目表

**通过员工id和项目id具体查询**（参数员工和项目id）

```javascript
GET {{localhost}}//worklog/staffAndProject/getinfo
Content-Type: application/json
Authorization: {{Authorization}}

参数{
     "staff_id": long--必须
  "project_id": int--必须
  
}
传参：
{
  "staff_id": 1,
  "project_id": 2001
}

result：{
    
    "msg": "操作成功",
  "code": 200,
  "data": {
    "staff_id": 1,
    "project_id": 2001,
    "role": "tttttt"
  
}

```



**通过员工id获取其下项目id**（参数员工id）

```javascript
GET {{localhost}}/worklog/staffAndProject/projectids/{id}
Content-Type: application/json
Authorization: {{Authorization}}

参数1：GET {{localhost}}/worklog/staffAndProject/projectids/1

result：
{
    
  "total": 1,
  "rows": [
    2001
  ],
  "code": 200,
  "msg": "查询成功"
}
```



**通过项目id获取该项目下员工id**（参数项目id）

```
GET {{localhost}}/worklog/staffAndProject/staffids/1008
Content-Type: application/json
Authorization: {{Authorization}}

参数：1008
GET {{localhost}}/worklog/staffAndProject/staffids/1008
result：{
 "total": 2,
  "rows": [
    4,
    9
  ],
  "code": 200,
  "msg": "查询成功"
}
```



**添加员工项目**（参数员工id项目id角色role）

```
POST {{localhost}}/worklog/staffAndProject/add
Content-Type: application/json
Authorization: {{Authorization}}

参数{
     "staff_id": long--必须
  "project_id": int--必须
  "role" :String--必须
}
参数：
{
	"staff_id": 33,
  	"project_id": 2001,
 	 "role": "普通员工"
}

result{
	 "msg": "操作成功",
  	"code": 200
}
```

```
###修改员工角色身份
POST {{localhost}}/worklog/staffAndProject/edit
Content-Type: application/json
Authorization: {{Authorization}}
参数{
    "staff_id": long--必须
  "project_id": int--必须
  "role" :String--必须
}

{
"staff_id": 1,
"project_id": "1009"
}

result:
{
  "msg": "操作成功",
  "code": 200
}


**通过员工ID和项目id删除员工项目**(参数员工id和项目id)

```
DELETE {{localhost}}/worklog/staffAndProject/delete
Content-Type: application/json
Authorization: {{Authorization}}

参数{
     "staff_id": long--必须
  "project_id": int--必须

}
参数：{
"staff_id": 33,
  	"project_id": 2001,
}

result{
"msg": "操作成功",
  "code": 200
}

```

**通过员工id批量删除关联的项目id**（参数员工id）

```
DELETE {{localhost}}/worklog/staffAndProject/deletebystaff/{staffId}
Authorization: {{Authorization}}

参数：9：DELETE {{localhost}}/worklog/staffAndProject/deletebystaff/9

result{
	"msg": "操作成功",
  	"code": 200
}

```

**通过项目id批量删除关联的员工id**（参数项目id）

```
DELETE {{localhost}}/worklog/staffAndProject//deletebyproject/{projectid}
Authorization: {{Authorization}}

参数：2001：DELETE {{localhost}}/worklog/staffAndProject//deletebyproject/2001

result{
 	"msg": "操作成功",
  	"code": 200
}

### 7.4组长-组员表

### 7.5员工新增接口

```json
查询user登录 用户的所有项目
GET {{localhost}}/system/user/profile/userProject
Authorization: {{Authorization}}

无参数
例如
result:
{
  "total": 2,
  "rows": [
    {
      "id": 1,
      "project_name": "java_pro111111",
      "leader_id": 1,
      "create_at": "2022-07-27T14:26:55.000+08:00",
      "update_at": "2022-07-27T17:16:32.000+08:00",
      "remark": null
    },
    {
      "id": 7,
      "project_name": "pro_n1",
      "leader_id": 1,
      "create_at": "2022-07-28T16:14:04.000+08:00",
      "update_at": null,
      "remark": null
    }
  ],
  "code": 200,
  "msg": "查询成功"
}


```

修改日报审核状态

```json
POST {{localhost}}/system/user/profile/approval/status
Content-Type: application/json
Authorization: {{Authorization}}
参数：
{
    "id": 日报的id，int, 必须
    "approval_status":批准状态， int，必须
}
例如
{
    "id": 3,
    "approval_status": 11
}
```