From 94652b486a9f4ee8958e37e6681a83c1e1ceef1f Mon Sep 17 00:00:00 2001 From: tuqin <tuqin@tuqin.cn> Date: 星期五, 23 十月 2026 09:17:42 +0800 Subject: [PATCH] docs(sql): 码鼎人力(62.70)审批模块缺列补丁——approve_process/approve_node/approve_log/staff_contacts_personal --- doc/sql/rlzyxt_approve_ddl.sql | 52 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 52 insertions(+), 0 deletions(-) diff --git a/doc/sql/rlzyxt_approve_ddl.sql b/doc/sql/rlzyxt_approve_ddl.sql new file mode 100644 index 0000000..c443719 --- /dev/null +++ b/doc/sql/rlzyxt_approve_ddl.sql @@ -0,0 +1,52 @@ +-- 鐮侀紟浜哄姏璧勬簮绯荤粺锛�10.136.62.70锛夊鎵规ā鍧楃己鍒楄ˉ涓� +-- 鐜拌薄锛氳繘鍏ュ鎵圭浉鍏抽〉闈㈡姤 +-- java.sql.SQLSyntaxErrorException: Unknown column 'business_id' in 'field list' +-- The error may exist in com/ruoyi/approve/mapper/ApproveProcessMapper.java +-- 鍘熷洜锛歞ev_tide 鍒嗘敮瀹炰綋锛坈om.ruoyi.approve.pojo.ApproveProcess / ApproveNode / ApproveLog锛� +-- 宸叉湁浠ヤ笅瀛楁锛屼絾绾夸笂搴撹〃缁撴瀯钀藉悗锛堢己鍒楋級銆侻yBatis-Plus 鐢熸垚 SELECT 鏃跺甫鍑哄叏閮ㄥ疄浣撳垪锛� +-- 搴撶己鍒楀嵆鎶� Unknown column銆� +-- 鎵ц搴擄細mis-ruoyi @10.136.62.70锛堝垪瀹氫箟鍙栬嚜鑺 10.136.58.66 鐨勫悓鍚嶅簱锛� +-- 鎵ц鏃堕棿锛�2026-10-23 + +-- 1. approve_process 缂� 7 鍒� +ALTER TABLE approve_process + ADD COLUMN business_id bigint NULL COMMENT '涓氬姟id', + ADD COLUMN business_no varchar(255) NULL COMMENT '涓氬姟缂栧彿', + ADD COLUMN business_title varchar(255) NULL COMMENT '涓氬姟鏍囬', + ADD COLUMN amount decimal(18,2) NULL COMMENT '閲戦', + ADD COLUMN business_data text NULL COMMENT '涓氬姟鏁版嵁', + ADD COLUMN flow_definition_id bigint NULL COMMENT '娴佺▼瀹氫箟id', + ADD COLUMN update_time datetime NULL COMMENT '鏇存柊鏃堕棿'; + +-- 2. approve_node 缂� 5 鍒� +ALTER TABLE approve_node + ADD COLUMN approve_node_name varchar(255) NULL, + ADD COLUMN condition_field varchar(255) NULL, + ADD COLUMN condition_operator varchar(255) NULL, + ADD COLUMN condition_value varchar(1000) NULL, + ADD COLUMN is_current int NULL; + +-- 3. approve_log 缂� 4 鍒� +ALTER TABLE approve_log + ADD COLUMN approve_node_id bigint NULL, + ADD COLUMN approve_process_id bigint NULL, + ADD COLUMN approve_user_name varchar(255) NULL, + ADD COLUMN tenant_id bigint NULL; + +-- 4. staff_contacts_personal 缂� 1 鍒楋紙浜哄姏璧勬簮-鍛樺伐涓汉鑱旂郴浜猴級 +ALTER TABLE staff_contacts_personal + ADD COLUMN user_id int NULL; + +-- 璇存槑锛氬悓搴撹繕鏈変互涓嬭〃鐩稿鏍囧噯搴撶己鍒楋紝灞炲叾瀹冧笟鍔℃ā鍧楋紙渚涘簲鍟�/鍙戠エ/鍞悗/璁惧缁存姢/鍑哄叆搴擄級锛� +-- 浜哄姏璧勬簮绯荤粺褰撳墠鏈敤鍒帮紝闇�瑕佹椂鍐嶈ˉ锛� +-- after_sales_service : status_name +-- device_maintenance : maintenance_cycle, maintenance_content +-- procurement_record_out : supplier_name, type +-- procurement_record_storage : min_stock, total_price, unit_price +-- supplier_manage : cooperation_history_summary, cooperation_start_date, cooperation_status, +-- delete_flag, qualification_expiry_date, qualification_status, remark, +-- supplied_products_summary, supplier_category, supplier_code, +-- supplier_level, supplier_short_name +-- ticket_registration : create_user, currency, delete_flag, file_name, invoice_code, +-- invoice_status, invoice_type, remark, sales_contract_no_id, supplier_id, +-- tax_amount, tax_rate, update_time, update_user, verification_status -- Gitblit v1.9.3