1.1.基础模版
```php
/**
* 修改后事件
* @param id [id]
*/
public function edit_after($params = []){
//代码编写位置
return ["code"=>0,"msg"=>"success"];
}
```
1.2.传入的数据
```js
$params = [
'name_db' => 'od_monthly_target', // 数据库表名
'act' => 'add_after', // 动作类型,添加单据后
'id' => 新插入或被编辑记录的ID // 新增操作或编辑操作生成的记录ID
];
```
第二步获取数据
2.1.需要用到的数据表
```sql
-- ----------------------------
-- Table structure for g_od_monthly_target
-- ----------------------------
DROP TABLE IF EXISTS `g_od_monthly_target`;
CREATE TABLE `g_od_monthly_target` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`project` int NULL DEFAULT NULL COMMENT '项目名称',
`uid` int NULL DEFAULT 0 COMMENT '用户id',
`status` int NULL DEFAULT 0 COMMENT '审核状态[-1:退回修改 0:正常 1:流程中 2:审批完成]',
`create_time` int NULL DEFAULT 0 COMMENT '新增时间',
`update_time` int NULL DEFAULT 0 COMMENT '更新时间',
`is_delete` int NULL DEFAULT 0 COMMENT '关联软删除字段[0:正常 1:删除]',
`y_year` int NULL DEFAULT NULL COMMENT '目标年份',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '月度目标' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of g_od_monthly_target
-- ----------------------------
INSERT INTO `g_od_monthly_target` VALUES (1, 4, 1, 0, 1748015669, 0, 0, 2025);
INSERT INTO `g_od_monthly_target` VALUES (2, 3, 1, 0, 1748072525, 0, 0, 2025);
```
//月度目标子表
```sql
-- ----------------------------
-- Table structure for g_od_monthly_target_d1
-- ----------------------------
DROP TABLE IF EXISTS `g_od_monthly_target_d1`;
CREATE TABLE `g_od_monthly_target_d1` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`d_id` int NULL DEFAULT 0 COMMENT '关联主表id',
`unit_subproject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`jan` decimal(18, 2) NULL DEFAULT NULL COMMENT '一月',
`feb` decimal(18, 2) NULL DEFAULT NULL COMMENT '二月',
`mar` decimal(18, 2) NULL DEFAULT NULL COMMENT '三月',
`apr` decimal(18, 2) NULL DEFAULT NULL COMMENT '四月',
`may` decimal(18, 2) NULL DEFAULT NULL COMMENT '五月',
`jun` decimal(18, 2) NULL DEFAULT NULL COMMENT '六月',
`jul` decimal(18, 2) NULL DEFAULT NULL COMMENT '七月',
`aug` decimal(18, 2) NULL DEFAULT NULL COMMENT '八月',
`sept` decimal(18, 2) NULL DEFAULT NULL COMMENT '九月',
`oct` decimal(18, 2) NULL DEFAULT NULL COMMENT '十月',
`nov` decimal(18, 2) NULL DEFAULT NULL COMMENT '十一月',
`dece` decimal(18, 2) NULL DEFAULT NULL COMMENT '十二月',
`sum` decimal(18, 2) NULL DEFAULT NULL COMMENT '当年小计',
`current_year` int NULL DEFAULT NULL COMMENT '当前年份',
`uid` int NULL DEFAULT 0 COMMENT '用户id',
`status` int NULL DEFAULT 0 COMMENT '审核状态',
`create_time` int NULL DEFAULT 0 COMMENT '新增时间',
`update_time` int NULL DEFAULT 0 COMMENT '更新时间',
`is_delete` int NULL DEFAULT 0 COMMENT '关联软删除字段[0:正常 1:删除]',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'od_monthly_target子表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of g_od_monthly_target_d1
-- ----------------------------
INSERT INTO `g_od_monthly_target_d1` VALUES (1, 1, '04260002', 85.00, 0.00, 0.00, 0.00, 0.00, 96.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 181.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (2, 1, '04260003', 0.00, 58.00, 0.00, 0.00, 69.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 127.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (3, 1, '04270002', 0.00, 0.00, 85.00, 96.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 181.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (4, 1, '04270003', 0.00, 0.00, 69.00, 58.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 127.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (5, 1, '04270004', 0.00, 96.00, 0.00, 0.00, 85.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 181.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (6, 1, '04270005', 69.00, 0.00, 0.00, 0.00, 0.00, 58.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 127.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (7, 1, '04280002', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (8, 1, '04280003', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (9, 1, '04280005', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (10, 1, '04290004', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (11, 1, '04300002', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (12, 1, '04300003', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (13, 1, '04300004', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (14, 1, '04300005', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748015669, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (15, 2, '03000102', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 85.00, 85.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (16, 2, '03000103', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 585.00, 0.00, 585.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (17, 2, '03000104', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 85.00, 0.00, 0.00, 85.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (18, 2, '03000105', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 85.00, 0.00, 0.00, 0.00, 85.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (19, 2, '03000202', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 585.00, 0.00, 0.00, 585.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (20, 2, '03000203', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 588.00, 0.00, 588.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (21, 2, '03000204', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5.00, 5.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (22, 2, '03000205', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (23, 2, '03000302', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (24, 2, '03000303', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (25, 2, '03000304', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (26, 2, '03000305', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (27, 2, '03000402', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (28, 2, '03000403', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (29, 2, '03000404', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (30, 2, '03000405', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (31, 2, '03000504', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (32, 2, '03000602', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (33, 2, '03000603', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (34, 2, '03000604', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (35, 2, '03000605', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (36, 2, '03000702', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (37, 2, '03000703', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (38, 2, '03000704', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (39, 2, '03000705', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (40, 2, '03000802', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (41, 2, '03000803', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (42, 2, '03000804', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (43, 2, '03000805', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (44, 2, '03000902', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (45, 2, '03000903', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (46, 2, '03000904', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (47, 2, '03000905', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (48, 2, '03001002', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (49, 2, '03001003', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (50, 2, '03001004', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (51, 2, '03001005', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (52, 2, '03001102', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (53, 2, '03001103', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (54, 2, '03001104', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (55, 2, '03001105', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (56, 2, '03001202', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (57, 2, '03001203', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (58, 2, '03001302', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (59, 2, '03001303', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (60, 2, '03001304', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (61, 2, '03001305', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (62, 2, '03001403', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (63, 2, '03001502', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (64, 2, '03001602', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (65, 2, '03001603', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (66, 2, '03001604', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (67, 2, '03001605', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (68, 2, '03001704', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (69, 2, '03001802', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (70, 2, '03001803', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (71, 2, '03001804', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (72, 2, '03001805', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (73, 2, '03001902', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (74, 2, '03001903', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (75, 2, '03002003', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (76, 2, '03002103', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (77, 2, '03002202', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (78, 2, '03002302', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (79, 2, '03002303', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (80, 2, '03002304', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
INSERT INTO `g_od_monthly_target_d1` VALUES (81, 2, '03002305', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2023, 1, 0, 1748072525, 0, 0);
SET FOREIGN_KEY_CHECKS = 1;
```
//年度目标
```sql
-- ----------------------------
-- Table structure for g_od_annual_target
-- ----------------------------
DROP TABLE IF EXISTS `g_od_annual_target`;
CREATE TABLE `g_od_annual_target` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`project` int NULL DEFAULT NULL COMMENT '项目名称',
`uid` int NULL DEFAULT 0 COMMENT '用户id',
`status` int NULL DEFAULT 0 COMMENT '审核状态[-1:退回修改 0:正常 1:流程中 2:审批完成]',
`create_time` int NULL DEFAULT 0 COMMENT '新增时间',
`update_time` int NULL DEFAULT 0 COMMENT '更新时间',
`is_delete` int NULL DEFAULT 0 COMMENT '关联软删除字段[0:正常 1:删除]',
`t_year` int NULL DEFAULT NULL COMMENT '目标年份',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '年度目标' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of g_od_annual_target
-- ----------------------------
INSERT INTO `g_od_annual_target` VALUES (1, 3, 1, 0, 1748069481, 0, 0, 2025);
INSERT INTO `g_od_annual_target` VALUES (2, 4, 1, 0, 1748079479, 0, 0, 2025);
```
//年度目标子表d1
```sql
-- ----------------------------
-- Table structure for g_od_annual_target_d1
-- ----------------------------
DROP TABLE IF EXISTS `g_od_annual_target_d1`;
CREATE TABLE `g_od_annual_target_d1` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`d_id` int NULL DEFAULT 0 COMMENT '关联主表id',
`subproject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子项目名称',
`sum` decimal(18, 2) NULL DEFAULT NULL COMMENT '当年目标',
`current_year` int NULL DEFAULT NULL COMMENT '当前年份',
`uid` int NULL DEFAULT 0 COMMENT '用户id',
`status` int NULL DEFAULT 0 COMMENT '审核状态',
`create_time` int NULL DEFAULT 0 COMMENT '新增时间',
`update_time` int NULL DEFAULT 0 COMMENT '更新时间',
`is_delete` int NULL DEFAULT 0 COMMENT '关联软删除字段[0:正常 1:删除]',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'od_annual_target子表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of g_od_annual_target_d1
-- ----------------------------
INSERT INTO `g_od_annual_target_d1` VALUES (1, 2, '04002602', 432.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (2, 2, '04002603', 2344.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (3, 2, '04002702', 432.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (4, 2, '04002703', 234.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (5, 2, '04002704', 423.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (6, 2, '04002705', 234.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (7, 2, '04002802', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (8, 2, '04002803', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (9, 2, '04002805', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (10, 2, '04002904', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (11, 2, '04003002', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (12, 2, '04003003', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (13, 2, '04003004', 0.00, 2024, 1, 0, 1748252636, 0, 0);
INSERT INTO `g_od_annual_target_d1` VALUES (14, 2, '04003005', 0.00, 2024, 1, 0, 1748252636, 0, 0);
```
//年度目标子表d2
```sql
-- ----------------------------
-- Table structure for g_od_annual_target_d2
-- ----------------------------
DROP TABLE IF EXISTS `g_od_annual_target_d2`;
CREATE TABLE `g_od_annual_target_d2` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`d_id` int NULL DEFAULT 0 COMMENT '关联主表id',
`subproject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子项目名称',
`sum` decimal(18, 2) NULL DEFAULT NULL COMMENT '当年目标',
`current_year` int NULL DEFAULT NULL COMMENT '当前年份',
`uid` int NULL DEFAULT 0 COMMENT '用户id',
`status` int NULL DEFAULT 0 COMMENT '审核状态',
`create_time` int NULL DEFAULT 0 COMMENT '新增时间',
`update_time` int NULL DEFAULT 0 COMMENT '更新时间',
`is_delete` int NULL DEFAULT 0 COMMENT '关联软删除字段[0:正常 1:删除]',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'od_annual_target子表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of g_od_annual_target_d2
-- ----------------------------
INSERT INTO `g_od_annual_target_d2` VALUES (1, 1, '08002401', 234.00, 2025, 1, 0, 1748252620, 0, 0);
INSERT INTO `g_od_annual_target_d2` VALUES (2, 1, '08002501', 432.00, 2025, 1, 0, 1748252620, 0, 0);
```
//项目管理表
```sql
-- ----------------------------
-- Table structure for g_od_projects
-- ----------------------------
DROP TABLE IF EXISTS `g_od_projects`;
CREATE TABLE `g_od_projects` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`applicable_unit_type` int NULL DEFAULT NULL COMMENT '项目适用单位类型',
`uid` int NULL DEFAULT 0 COMMENT '用户id',
`status` int NULL DEFAULT 0 COMMENT '审核状态[-1:退回修改 0:正常 1:流程中 2:审批完成]',
`create_time` int NULL DEFAULT 0 COMMENT '新增时间',
`update_time` int NULL DEFAULT 0 COMMENT '更新时间',
`is_delete` int NULL DEFAULT 0 COMMENT '关联软删除字段[0:正常 1:删除]',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of g_od_projects
-- ----------------------------
INSERT INTO `g_od_projects` VALUES (3, '综合经营', 0, 1, 0, 1747795096, 0, 0);
INSERT INTO `g_od_projects` VALUES (4, '校内配送', 0, 1, 0, 1747795118, 0, 0);
INSERT INTO `g_od_projects` VALUES (5, '外包餐饮', 0, 1, 0, 1747795126, 0, 0);
INSERT INTO `g_od_projects` VALUES (6, '自营餐饮', 0, 1, 0, 1747795136, 0, 0);
INSERT INTO `g_od_projects` VALUES (7, '综合经营(公司自营项目)', 1, 1, 0, 1747820006, 0, 0);
INSERT INTO `g_od_projects` VALUES (8, '校外配送', 1, 1, 0, 1747882494, 0, 0);
```
第三步,数据更新
将g_od_monthly_target_d1表中的sum更新到年度目标中的对应的年度目标子表中的sum
如果g_od_annual_target_d1是0的话,在表g_od_annual_target_d1中更新数据
如果g_od_annual_target_d1是1的话,在表g_od_annual_target_d2中更新数据