post-check-api/sql/UpdateTableV2.sql

ALTER TABLE "public"."post_list" MODIFY COLUMN "status" integer COMMENT '状态：0-待提交；1-待审核；2-审核中；3-通过；4-驳回；';

=============================================================================================================
=================================================== 已更新 ===================================================
=============================================================================================================

1、问题Controller查询详情接口添加后台鉴权：
313224854171649
select
	*
from "sys_menu" WHERE "menu_name" like '%整改实施%'

811932129460226
select
	*
from "sys_menu" WHERE "menu_name" like '%整改审核%'

313438029672450
select
	*
from "sys_menu" WHERE "menu_name" like '%整改验证%'

864815655854081
select
	*
from "sys_menu" WHERE "menu_name" like '%问题整改台账%'

INSERT INTO sys_menu (menu_id,menu_name,parent_id,order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark)
select
	'20240429001' AS menu_id,
	'查询详情' AS menu_name,
	313224854171649 AS parent_id,
	order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark
from "sys_menu" WHERE "perms" = 'postCheck:postCheckedProblem:query' LIMIT 1;

INSERT INTO sys_menu (menu_id,menu_name,parent_id,order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark)
select
	'20240429002' AS menu_id,
	'查询详情' AS menu_name,
	811932129460226 AS parent_id,
	order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark
from "sys_menu" WHERE "perms" = 'postCheck:postCheckedProblem:query' LIMIT 1;

INSERT INTO sys_menu (menu_id,menu_name,parent_id,order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark)
select
	'20240429003' AS menu_id,
	'查询详情' AS menu_name,
	313438029672450 AS parent_id,
	order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark
from "sys_menu" WHERE "perms" = 'postCheck:postCheckedProblem:query' LIMIT 1;

INSERT INTO sys_menu (menu_id,menu_name,parent_id,order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark)
select
	'20240429004' AS menu_id,
	'查询详情' AS menu_name,
	864815655854081 AS parent_id,
	order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark
from "sys_menu" WHERE "perms" = 'postCheck:postCheckedProblem:query' LIMIT 1;