mescloud/db/mysql/add_mes_piece_salary.sql

-- 计件工资核算
-- 先维护每个产线工位的计件单价，再按生产记录统计件数并导出工资表。

CREATE TABLE IF NOT EXISTS `mes_station_piece_price` (
  `id` varchar(64) NOT NULL COMMENT 'id',
  `line_sn` varchar(64) NOT NULL COMMENT '产线编号',
  `oprno` varchar(64) NOT NULL COMMENT '工位号',
  `oprno_name` varchar(100) DEFAULT NULL COMMENT '工位名称',
  `unit_price` decimal(18,4) NOT NULL DEFAULT 0.0000 COMMENT '计件单价',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态（0正常 1删除 2停用）',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_mes_station_piece_price_line_oprno` (`line_sn`,`oprno`),
  KEY `idx_mes_station_piece_price_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工位计件单价';

-- 建议在正式库执行前先确认是否已存在同名索引。
-- CREATE INDEX `idx_mes_pda_scan_record_salary` ON `mes_pda_scan_record` (`create_date`, `line_sn`, `oprno`, `ucode`);

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
) VALUES (
  'mesPieceSalaryReport', '1672118505143263232', '0,1672118505143263232,',
  2500, '0000009290,0000002500,', '0', 1,
  '生产管理/计件工资核算', '计件工资核算', '1', '/mes/mesPieceSalaryReport/list', '',
  'fa-calculator', '', '', 'mes:mesPieceSalaryReport:view', 40, '1', 'default', 'core', NULL, NULL,
  '0', 'system', NOW(), 'system', NOW(), ''
) ON DUPLICATE KEY UPDATE
  `menu_name` = VALUES(`menu_name`),
  `menu_href` = VALUES(`menu_href`),
  `permission` = VALUES(`permission`),
  `status` = '0',
  `update_by` = 'system',
  `update_date` = NOW();

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
) VALUES (
  'mesPieceSalaryReportView', 'mesPieceSalaryReport', '0,1672118505143263232,mesPieceSalaryReport,',
  30, '0000009290,0000002500,0000000030,', '1', 2,
  '生产管理/计件工资核算/查看', '查看', '2', '', '',
  '', '', '', 'mes:mesPieceSalaryReport:view', 40, '1', 'default', 'core', NULL, NULL,
  '0', 'system', NOW(), 'system', NOW(), ''
) ON DUPLICATE KEY UPDATE
  `permission` = VALUES(`permission`),
  `status` = '0',
  `update_by` = 'system',
  `update_date` = NOW();

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
) VALUES (
  'mesStationPiecePrice', 'mesPieceSalaryReport', '0,1672118505143263232,mesPieceSalaryReport,',
  40, '0000009290,0000002500,0000000040,', '1', 2,
  '生产管理/计件工资核算/单价维护', '单价维护', '1', '/mes/mesStationPiecePrice/list', '',
  'fa-money', '', '', 'mes:mesStationPiecePrice:view,mes:mesStationPiecePrice:edit', 40, '1', 'default', 'core', NULL, NULL,
  '0', 'system', NOW(), 'system', NOW(), ''
) ON DUPLICATE KEY UPDATE
  `menu_name` = VALUES(`menu_name`),
  `menu_href` = VALUES(`menu_href`),
  `permission` = VALUES(`permission`),
  `status` = '0',
  `update_by` = 'system',
  `update_date` = NOW();

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
) VALUES (
  'mesStationPiecePriceEdit', 'mesStationPiecePrice', '0,1672118505143263232,mesPieceSalaryReport,mesStationPiecePrice,',
  40, '0000009290,0000002500,0000000040,0000000040,', '1', 3,
  '生产管理/计件工资核算/单价维护/编辑', '编辑', '2', '', '',
  '', '', '', 'mes:mesStationPiecePrice:edit', 40, '1', 'default', 'core', NULL, NULL,
  '0', 'system', NOW(), 'system', NOW(), ''
) ON DUPLICATE KEY UPDATE
  `permission` = VALUES(`permission`),
  `status` = '0',
  `update_by` = 'system',
  `update_date` = NOW();