~~~[api] get:/shebao/Admin_Sbbdsq/Sbbcsq_zcsq?id=14 <<< success { "code":0, "data":[ { "id":4, "yuangong_name":"莫卓才", "yuangong_sfz":"460025199505041216", "tbtime":"1111", "tbsyyy":"1111", "fkxx_status":2, "fkxx_msg":null }] } <<< error {"code":1,"msg":xxxx} ~~~ ```[sql] CREATE TABLE `daijun_sb_bcsq_more` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `yuangong_name` varchar(50) NOT NULL COMMENT '员工姓名', `yuangong_sfz` varchar(100) NOT NULL COMMENT '员工身份证', `qegz` varchar(50) NOT NULL COMMENT '全额工资', `ksny` varchar(50) NOT NULL COMMENT '开始年月', `zzny` varchar(50) NOT NULL COMMENT '终止年月', `yanglao` varchar(50) NOT NULL COMMENT '养老', `yanglao_gr_bili` varchar(50) DEFAULT NULL COMMENT '养老个人比例', `yanglao_qy_bili` varchar(50) DEFAULT NULL COMMENT '养老企业比例', `shiye` varchar(50) NOT NULL COMMENT '失业', `shiye_gr_bili` varchar(50) DEFAULT NULL COMMENT '失业个人比例', `shiye_qy_bili` varchar(50) DEFAULT NULL COMMENT '失业企业比例', `yiliao` varchar(50) NOT NULL COMMENT '医疗', `yiliao_gr_bili` varchar(50) DEFAULT NULL COMMENT '医疗个人比例', `yiliao_qy_bili` varchar(50) DEFAULT NULL COMMENT '医疗企业比例', `gongshang` varchar(50) NOT NULL COMMENT '工伤', `gongshang_gr_bili` varchar(50) DEFAULT NULL COMMENT '工伤个人比例', `gongshang_qy_bili` varchar(50) DEFAULT NULL COMMENT '工伤企业比例', `shengyu` varchar(50) NOT NULL COMMENT '生育', `shengyu_gr_bili` varchar(50) DEFAULT NULL COMMENT '生育个人比例', `shengyu_qy_bili` varchar(50) DEFAULT NULL COMMENT '工伤企业比例', `gongbu` varchar(50) NOT NULL COMMENT '公补', `gongbu_gr_bili` varchar(50) DEFAULT NULL COMMENT '公补个人比例', `gongbu_qy_bili` varchar(50) DEFAULT NULL COMMENT '公补企业比例', `gwyylbzgz` varchar(50) DEFAULT NULL COMMENT '公务员医疗补助工资', `fkxx_status` int(2) DEFAULT '2' COMMENT '反馈状态1成功，2失败', `fkxx_msg` text COMMENT '反馈信息', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='社保补差申请-附表'; ``` ~~~[api] post:/shebao/Admin_Sbbdsq/Sbbcsq_zcsq?id=14 <<< success {"code":0,"count":0,"data":"xxx"} <<< error {"code":1,"msg":xxxx} ~~~ ```[sql] CREATE TABLE `daijun_sb_bcsq_more` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `yuangong_name` varchar(50) NOT NULL COMMENT '员工姓名', `yuangong_sfz` varchar(100) NOT NULL COMMENT '员工身份证', `qegz` varchar(50) NOT NULL COMMENT '全额工资', `ksny` varchar(50) NOT NULL COMMENT '开始年月', `zzny` varchar(50) NOT NULL COMMENT '终止年月', `yanglao` varchar(50) NOT NULL COMMENT '养老', `yanglao_gr_bili` varchar(50) DEFAULT NULL COMMENT '养老个人比例', `yanglao_qy_bili` varchar(50) DEFAULT NULL COMMENT '养老企业比例', `shiye` varchar(50) NOT NULL COMMENT '失业', `shiye_gr_bili` varchar(50) DEFAULT NULL COMMENT '失业个人比例', `shiye_qy_bili` varchar(50) DEFAULT NULL COMMENT '失业企业比例', `yiliao` varchar(50) NOT NULL COMMENT '医疗', `yiliao_gr_bili` varchar(50) DEFAULT NULL COMMENT '医疗个人比例', `yiliao_qy_bili` varchar(50) DEFAULT NULL COMMENT '医疗企业比例', `gongshang` varchar(50) NOT NULL COMMENT '工伤', `gongshang_gr_bili` varchar(50) DEFAULT NULL COMMENT '工伤个人比例', `gongshang_qy_bili` varchar(50) DEFAULT NULL COMMENT '工伤企业比例', `shengyu` varchar(50) NOT NULL COMMENT '生育', `shengyu_gr_bili` varchar(50) DEFAULT NULL COMMENT '生育个人比例', `shengyu_qy_bili` varchar(50) DEFAULT NULL COMMENT '工伤企业比例', `gongbu` varchar(50) NOT NULL COMMENT '公补', `gongbu_gr_bili` varchar(50) DEFAULT NULL COMMENT '公补个人比例', `gongbu_qy_bili` varchar(50) DEFAULT NULL COMMENT '公补企业比例', `gwyylbzgz` varchar(50) DEFAULT NULL COMMENT '公务员医疗补助工资', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='社保补差申请-附表'; ```