
-- 行政区号
INSERT INTO `sysarea` (`id`, `name`, `code`, `create_time`, `update_time`, `update_by`, `active`, `parentid`) VALUES ('3513', '曲江新区', '610126', '2017-12-03 20:29:48', '2017-12-03 20:29:51', 'system', '', '3061');
INSERT INTO `sysarea` (`id`, `name`, `code`, `create_time`, `update_time`, `update_by`, `active`, `parentid`) VALUES ('3514', '经济技术开发区', '610127', '2017-12-03 20:29:48', '2017-12-03 20:29:51', 'system', '', '3061');

--  将审批状态设为失效
update sys_approval set active = 0 where businesstype= '008' and businessid not in(24,29,142,55,94,65,27,51,118,87)
 	
-- 删除年度报表信息
delete from yearreportdata;

INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('24', '', 'sn20160023', '2017-12-01 07:27:14', '2017-11-15 19:20:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '60', '40', '20', '1', '1', '1', '山东阳谷谷山标志服装厂', 'getResource.do?path=upload/2017-11-26/1511679751284.jpg', 'getResource.do?path=upload/2017-11-26/1511679757216.jpg', 'getResource.do?path=upload/2017-11-26/1511679762810.jpg', '8', '30', '55', '1', '0', '1', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3', '1', '0', '5000', '0', '0', '否', '3', '无', '无', '无', 'getResource.do?path=upload/2017-11-26/1511681228269.doc', NULL, '1347', '20', '0', '1', '2', NULL, '4', NULL, '002', '18', '0', '1', '0', '0', '0', '0', '17', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '21', '11', '11', '0', NULL, '1', '1', '0', '1', '0', NULL, NULL, '2017', '1', '18', '0', '0', '20', '7', '002', '', NULL, '610000', '610700', '610725', NULL, NULL, NULL, NULL, '2017-12-01 07:27:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '阳秀江', '18228680060');


INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('29', '', 'sn20160038', '2017-11-29 15:46:26', '2017-11-16 11:17:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '72', '72', '0', '72', '72', '72', '1', '1', '1', '陕西省厅调配中心', 'getResource.do?path=upload/2017-11-20/1511151071813.jpg', 'getResource.do?path=upload/2017-11-20/1511151059921.jpg', 'getResource.do?path=upload/2017-11-20/1511151079639.jpg', '5', '5.6', '109.8', '5.09', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '2', '2.6', '0', '0', '否', '6', '1', '陕西龙兴卫安保服务有限公司', 'www.longxingwei.com', 'getResource.do?path=upload/2017-11-29/1511941305084.doc', NULL, '1374', '0', '50', '1', '2', NULL, '4', NULL, '002', '50', '0', '1', '0', '0', '0', '1', '46', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '75', '10', '12', '0', NULL, '1', '1', '0', '1', '0', NULL, NULL, '2017', '1', '29', '21', '0', '0', '6', '002', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2017-11-29 15:46:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '秦松', '13909258255');




INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('142', '', 'sn20160046', '2017-11-29 12:38:57', '2017-12-03 11:50:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '6', '15', '0', '50', '20', '60', '1', '1', '1', '', 'getResource.do?path=upload/2017-11-29/1511929363160.jpg', '', '', '2', '26', '20', '2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'getResource.do?path=upload/2017-11-29/1511929989571.docx', NULL, '1389', '0', '7', NULL, NULL, NULL, '4', NULL, '002', '7', '0', '0', '0', '0', '0', '0', '7', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10', '4', '4', '0', NULL, '1', '0', '0', '0', '0', NULL, NULL, '2017', '0', '7', '0', '0', '0', '0', '002', '', NULL, '610000', '610100', '610116 ', NULL, NULL, NULL, NULL, '2017-11-29 12:38:57', NULL, NULL, '陕西勇士保安服务有限公司', '610100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '张晓勇', '15319714301');




INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('55', '', 'sn20110002', '2017-12-03 16:14:10', '2017-11-22 08:12:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '104', '542', '0', '542', '542', '542', '1', '1', '1', ' 陕西聚辉警用装备器材有限公司', 'getResource.do?path=upload/2017-11-22/1511307790607.jpg', 'getResource.do?path=upload/2017-11-22/1511309359527.jpg', 'getResource.do?path=upload/2017-11-22/1511309360938.jpg', '82', '28', '1500', '114626', '0', '0', '0', '400', '0', '0', '盾牌、防爆叉、辣椒水、伸缩警棍', '0', '0', '1', '6', '20', '0', '0', '0', '50', '4', '2', '100', '200', '50', '无', '12', '十九大学习', '无', '无', 'getResource.do?path=upload/2017-11-22/1511308942620.doc', NULL, '1346', '494', '0', '1', NULL, NULL, NULL, NULL, '002', '420', '0', '4', '2', '0', '0', '0', '309', '111', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '494', '226', '235', '0', NULL, '1', '1', '0', '0', '0', NULL, NULL, '2017', '0', '420', '0', '0', '0', '0', '002', '', NULL, '610000', '610900', '610902', NULL, NULL, NULL, NULL, '2017-11-28 16:14:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '刘庆东', '13709156036');


INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('94', '', 'sn20110051', '2017-12-03 14:25:13', '2017-11-25 19:36:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '60', '60', '0', '30', '60', '60', '1', '1', '1', '咸阳永力标志服饰商贸有限公司', 'getResource.do?path=upload/2017-11-25/1511609039613.jpg', '', '', '12', '160', '69.6761', '1.39', '0', '0', '12', '100', '0', '5', '30', '1', '0', '0', '2', '3', '0', '0', '0', '6', '5', '0', '12', '860', '120', '0', '10', '0', '华辰保安', 'http//www.华辰保安.com', 'getResource.do?path=upload/2017-11-25/1511609321722.doc', NULL, '1594', '12', '42', '1', '2', '3', '4', '5', '002', '54', '0', '0', '0', '0', '0', '0', '49', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '59', '6', '4', '0', NULL, '1', '1', '0', '0', '0', NULL, NULL, '2017', '0', '0', '54', '0', '0', '0', '002', '', NULL, '610000', '610400', '610427', NULL, NULL, NULL, NULL, '2017-11-27 14:25:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '秦鹰', '15591032222');


INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('65', '', 'snpx20150003', '2017-12-03 10:49:30', '2017-11-23 10:21:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '423', '370', '63', '0', '0', '0', '0', 'getResource.do?path=upload/2017-11-23/1511406726826.png', '', '', '50', '100', '16', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'getResource.do?path=upload/2017-11-23/1511402845721.doc', NULL, '1034081', '2', '0', '1', '2', '3', '4', '5', '002', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, '1', '1', '0', '0', '0', NULL, NULL, '2017', '0', '0', '0', '0', '0', '0', '002', '', NULL, '610000', '610800', '610821', NULL, NULL, NULL, NULL, '2017-11-27 10:49:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '张峰', '18066536667');


INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('27', '', 'sn20170085', '2017-12-02 09:44:04', '2017-11-16 09:52:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '5', '4', '6', '1', '1', '1', '西安市雁塔区碧空被服经销部', 'getResource.do?path=upload/2017-11-20/1511162333183.jpg', '', '', '0', '50', '0', '0', '0', '0', '10', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '否', '1', '无', '无', '无', 'getResource.do?path=upload/2017-12-01/1512115061337.doc', NULL, '1017114', '2', '18', '1', '2', '3', '4', '5', '002', '20', '0', '0', '0', '0', '0', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25', '4', '5', '0', NULL, '1', '1', '0', '0', '0', NULL, NULL, '2017', '1', '20', '0', '0', '20', '0', '002', '', NULL, '610000', '610100', '610112', NULL, NULL, NULL, NULL, '2017-12-02 09:44:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '郭梦娜', '13572983813');


INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('51', '', 'sn20120006', '2017-12-03 09:56:02', '2017-11-21 16:40:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '45', '50', '0', '98', '105', '85', '1', '1', '1', '特盾服装销售中心', 'getResource.do?path=upload/2017-11-29/1511920287861.jpg', 'getResource.do?path=upload/2017-11-29/1511920290935.jpg', 'getResource.do?path=upload/2017-11-29/1511920295141.jpg', '98', '43.3', '998', '129', '0', '0', '0', '50', '0', '1', '0', '0', '0', '0', '1', '2', '0', '0', '0', '2', '0', '5', '30', '59', '20', '无', '3', '无', '榆林睿泰威远保安服务有限公司', 'http://www.ylrtwy.com', 'getResource.do?path=upload/2017-11-28/1511851014813.docx', NULL, '1609', '126', '0', NULL, NULL, NULL, '4', NULL, '002', '102', '1', '2', '0', '0', '1', '1', '100', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '126', '21', '22', '0', NULL, '1', '1', '0', '1', '1', NULL, NULL, '2017', '1', '69', '33', '0', '0', '7', '002', '', NULL, '610000', '610800', '610802', NULL, NULL, NULL, NULL, '2017-11-29 09:56:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '陈妮妮', '15229120123');



INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('118', '', 'sn20170033', '2017-12-03 18:57:28', '2017-11-27 18:54:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '东菀市常平景安劳保用品经营部', 'getResource.do?path=upload/2017-11-27/1511778360220.jpg', 'getResource.do?path=upload/2017-11-27/1511778802392.jpg', 'getResource.do?path=upload/2017-11-27/1511779669698.jpg', '0', '150000', '0', '0', '1', '0', '10', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '是', '4', '1', '西安家运保安服务有限公司', 'www.jiayuns.com', 'getResource.do?path=upload/2017-11-27/1511779899324.doc', NULL, '1334', '0', '0', '1', '2', NULL, '4', NULL, '002', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3', '2', '1', '0', NULL, '1', '1', '0', '0', '0', NULL, NULL, '2017', '1', '0', '0', '0', '0', '0', '002', '', NULL, '610000', '610100', '610126', NULL, NULL, NULL, NULL, '2017-11-27 18:57:28', NULL, NULL, '西安家运保安服务有限公司', '610100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '刘军', '13152086215');


INSERT INTO `yearreportdata` (`id`, `active`, `update_by`, `update_time`, `create_time`, `generalmanager`, `education`, `major`, `fontgeneralmanager`, `fgeneralmanager`, `feducation`, `fmajor`, `xspxrs`, `sgqpxrs`, `szgpxrs`, `mryxs`, `xpxrs`, `xgqpxrs`, `xzgpxrs`, `sffzsg`, `sffzbj`, `sfzqqc`, `bjly`, `fpzpic`, `fpfpic`, `bzcgpic`, `khsl`, `gdzc`, `nyye`, `nlx`, `zjjk`, `ycc`, `ftbx`, `xjg`, `fbq`, `jyywrs`, `zbqkqt`, `ygfsrs`, `ygxxrs`, `sqgbzrs`, `ssjbzrs`, `sshijbzrs`, `dxbayrs`, `szacrs`, `zjxszrrs`, `tgpaxs`, `zhxyr`, `yfszsg`, `whjjss`, `wtzlhd`, `sjczgz`, `sfdjzz`, `dyrs`, `dyhdnr`, `wzmc`, `wz`, `ndbg`, `ffzgeneralmanager`, `userid`, `gmsbrs`, `wgmsbrs`, `ylaobx`, `ylbx`, `syebx`, `gsbx`, `sybx`, `zc`, `personnum`, `certificateCount`, `cjnum`, `zjnum`, `gjnum`, `managernum`, `gjmanagernum`, `malenum`, `femalenum`, `escortnum`, `armnum`, `approvalCount`, `personcertificateCount`, `crosscompanyCount`, `subsidiaryCount`, `traincompanyCount`, `legalchangeCount`, `taskTotal`, `cycleCount`, `temporaryCount`, `urgentCount`, `personCount`, `initCount`, `authCount`, `unAuthCount`, `baseInfo`, `investor`, `management`, `branch`, `serviceHt`, `device`, `filingIsStamped`, `filingIsPassed`, `filingYear`, `laborHt`, `policyCount`, `unPolicyCount`, `quotaCount`, `unQuotaCount`, `securityNum`, `approvalstate`, `lineInsure`, `szss`, `province`, `city`, `district`, `approvalperson`, `approvaldate`, `wtzlhdrc`, `sjczgzrc`, `applydate`, `approvalreason`, `approvalfile`, `companyName`, `areaCode`, `legalPhone`, `legalPerson`, `legalPersonNo`, `publicSecurityLicenseNumber`, `securityScope`, `socialCode`, `tel`, `location`, `registeredMoney`, `postalcode`, `operatorname`, `operatorphone`) VALUES ('87', '', 'sn20150015', '2017-12-03 13:46:03', '2017-11-24 16:51:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '220', '10', '0', '220', '220', '220', '1', '1', '1', '方双根', 'getResource.do?path=upload/2017-11-27/1511759475273.jpg', 'getResource.do?path=upload/2017-11-27/1511759476189.jpg', 'getResource.do?path=upload/2017-11-27/1511759476572.jpg', '10', '0.8', '1175.30', '15.63', '0', '0', '0', '10', '0', '0', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '十九大学习', '陕西中保华安保安服务有限公司', 'www.sxzbha.com', 'getResource.do?path=upload/2017-11-27/1511759901042.总结报告', NULL, '1510', '0', '220', '1', '2', '3', '4', '5', '002', '218', '1', '16', '2', '0', '0', '0', '197', '21', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '220', '74', '79', '0', NULL, '1', '1', '0', '0', '0', NULL, NULL, '2017', '0', '218', '0', '0', '0', '0', '002', '', NULL, '610000', '610100', '610127', NULL, NULL, NULL, NULL, '2017-11-27 13:46:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '张金花', '15829067667');
