root
/
qc.ifish7.com
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
qc.ifish7.com/Application/Data/sqlBake/mhzljc_20200831173249/db_task_sub_1.php

128 lines
26 KiB
PHP
Raw Permalink Blame History

<?php
$this->E_D("DROP TABLE IF EXISTS `db_task_sub`;");
$this->E_C("CREATE TABLE `db_task_sub` (
`subtask_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '子任务id',
`task_id` int(20) DEFAULT NULL COMMENT '任务id',
`subtask_operator_id` int(20) DEFAULT NULL COMMENT '操作工id',
`subtask_qc_id` int(20) DEFAULT NULL COMMENT '质检员id',
`subtask_time_add` varchar(20) DEFAULT NULL COMMENT '子任务 添加时间',
`subtask_time_qc` varchar(20) DEFAULT NULL COMMENT '质检时间',
`subtask_plan_num` int(20) DEFAULT NULL COMMENT '子任务 产品计划数量',
`subtask_complete_num` int(20) DEFAULT '0' COMMENT '子任务 产品完成数量',
`subtask_pass_rate` double(10,4) DEFAULT NULL COMMENT '子任务 合格率',
`subtask_pass_num` int(20) DEFAULT NULL COMMENT '子任务 合格数量',
`subtask_feiliao_num` int(20) DEFAULT NULL COMMENT '子任务 废料数量',
`subtask_rangbu_num` int(20) DEFAULT NULL COMMENT '子任务 让步数量',
`subtask_jiangji_num` int(20) DEFAULT NULL COMMENT '子任务 降级数量',
`subtask_liewen_num` int(20) DEFAULT NULL COMMENT '子任务 裂纹数量',
`subtask_maopi_num` int(20) DEFAULT NULL COMMENT '子任务 毛坯数量',
`subtask_hunliao_num` int(20) DEFAULT NULL COMMENT '子任务 混料数量',
`subtask_shengxiu_num` int(20) DEFAULT NULL COMMENT '子任务 生锈数量',
`subtask_baofei_num` int(20) DEFAULT NULL COMMENT '子任务 报废数量',
`subtask_tongzhi_num` int(20) DEFAULT NULL COMMENT '子任务 报废数量',
`subtask_spbiaoguan_num` int(20) DEFAULT NULL COMMENT '子任务 sp数量',
`subtask_spwaijing_num` int(20) DEFAULT NULL COMMENT '子任务 sp数量',
`subtask_sppingmian_num` int(20) DEFAULT NULL COMMENT '子任务 sp数量',
`subtask_zhenquexian_num` int(20) DEFAULT NULL COMMENT '子任务 针缺陷数量',
`subtask_quezhen_num` int(20) DEFAULT NULL COMMENT '子任务 缺针数量',
`subtask_hunzhen_num` int(20) DEFAULT NULL COMMENT '子任务 混针数量',
`subtask_tonext_num` int(20) DEFAULT '0' COMMENT '子任务 进入下一道工序数量',
`task_flow_id` int(20) DEFAULT NULL COMMENT '任务流程id',
`operator_name` varchar(255) DEFAULT NULL COMMENT '操作工 姓名',
`flow_craft_id` int(20) DEFAULT NULL COMMENT '流程工艺id',
`craft_id` int(20) DEFAULT NULL COMMENT '工艺id',
`type_id` int(11) DEFAULT NULL COMMENT '工种id',
`type_name` varchar(255) DEFAULT NULL COMMENT '工种名称',
`qc_name` varchar(255) DEFAULT NULL COMMENT '质检员 姓名',
`craft_name` varchar(255) DEFAULT NULL COMMENT '工艺名称',
`money` float(20,2) DEFAULT NULL COMMENT '最后金额',
`is_checked` tinyint(1) DEFAULT '0' COMMENT '是否复核',
`subtask_check_id` int(20) DEFAULT NULL COMMENT ' 复核员id',
`check_name` varchar(255) DEFAULT NULL COMMENT '复核员姓名',
`subtask_sanshi_num` int(20) DEFAULT NULL COMMENT '散失数',
`subtask_qita_num` int(20) DEFAULT NULL COMMENT '其他数',
`subtask_fanxiu_num` int(20) DEFAULT NULL COMMENT '返修数',
`subtask_paomo_num` int(20) DEFAULT NULL COMMENT '抛磨数',
PRIMARY KEY (`subtask_id`) USING BTREE,
KEY `task_id` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8");
$this->E_D("replace into `db_task_sub` values('73','15','6','7','1591837168','1591861956','2000','2000','1.0000','1990','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2000','42','操作工1','24','11','7','工种02','检验员1','工艺003-02',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('74','16','6','7','1591837368','1591862079','10000','10000','1.0000','10000','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'10000','44','操作工1','18','9','6','工种01','检验员1','工艺001-01',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('75','15','6','7','1591842439','1591862352','2000','2000','1.0000','2000','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2000','42','操作工1','24','11','7','工种02','检验员1','工艺003-02',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('76','17','6','7','1591863900','1591864223','1000','1000','1.0000','1000','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1000','50','操作工1','27','9','6','工种01','检验员1','工艺001-01',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('77','15','6','7','1591868067','1591868182','100','100','0.9000','90','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'90','42','操作工1','24','11','7','工种02','检验员1','工艺003-02',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('82','15','6','7','1591887806','1592210599','4000','3960','0.9995','3958','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3960','42','操作工1','24','11','7','工种02','检验员1','工艺003-02',NULL,'1','11','主管2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('87','18','6','7','1591948703','1592197613','10000','10000','0.9999','9999','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'10000','51','操作工1','28','9','6','工种01','检验员1','工艺001-01',NULL,'1','8','主管',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('88','19','6','7','1591951308','1591951442','10000','10000','1.0000','9990','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9999','53','操作工1','31','15','10','测试工种','检验员1','测试工艺',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('91','15','6','7','1592147738','1592385193','2000','2000','0.9945','1989','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2000','42','操作工1','24','11','7','工种02','检验员1','工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('93','18','6','7','1592187640','1592197200','5000','4999','1.0000','4998','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4999','51','操作工1','28','9','6','工种01','检验员1','工艺001-01',NULL,'1','10','检验员2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('94','15','6',NULL,'1592291450',NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('95','18','6',NULL,'1592291673',NULL,'2000','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','52','操作工1','29','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('96','15','6','10','1592292657','1593450295','100','100','0.9900','99',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','42','操作工1','24','11','7','工种02','检验员2','工艺003-02','0.00','1','10','检验员2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('97','15','6','7','1592299824','1592464745','200','200','0.0000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'200','42','操作工1','24','11','7','工种02','检验员1','工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('98','15','6',NULL,'1592301661',NULL,'200','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('99','15','6',NULL,'1592306876',NULL,'200','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('100','15','6',NULL,'1592307353',NULL,'100','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('101','15','6',NULL,'1592309594',NULL,'200','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','43','操作工1','25','9','6','工种01',NULL,'工艺001-01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('102','15','6','10','1592309641','1593447886','200','200','1.0000','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'200','42','操作工1','24','11','7','工种02','检验员2','工艺003-02','0.00','1','10','检验员2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('103','15','6',NULL,'1592310177',NULL,'200','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('104','15','6',NULL,'1592371924',NULL,'123','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('105','18','6',NULL,'1592372101',NULL,'54','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','52','操作工1','29','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('106','18','6',NULL,'1592372102',NULL,'54','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','52','操作工1','29','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('107','15','6',NULL,'1592461419',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('108','21','6',NULL,'1592477963',NULL,'1000','500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','55','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('109','21','6',NULL,'1592478035',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','55','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('110','20','6','7','1592478175','1592528281','200','200','1.0000','200','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'200','54','操作工1','31','15','10','测试工种','检验员1','测试工艺',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('111','15','6',NULL,'1592530757',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('112','30','9','10','1592534462','1592535166','500','500','0.9960','498',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'499','85','操作工2','32','17','11','平面磨','检验员2','平面工艺',NULL,'1','11','主管2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('113','30','6',NULL,'1592537609',NULL,'100','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','85','操作工1','32','17','11','平面磨',NULL,'平面工艺',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('114','15','6',NULL,'1592541850',NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('115','15','6',NULL,'1592541906',NULL,'500','500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('116','30','6',NULL,'1592655461',NULL,'100','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','85','操作工1','32','17','11','平面磨',NULL,'平面工艺',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('117','15','6',NULL,'1592807224',NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('118','15','6',NULL,'1592807240',NULL,'1000','1000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('119','30','6','7','1592848717','1592848929','200','200','1.0000','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'200','85','操作工1','32','17','11','平面磨','检验员1','平面工艺','400.00','1','11','主管2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('120','30','6','7','1592848975','1592849980','100','100','1.0000','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','85','操作工1','32','17','11','平面磨','检验员1','平面工艺','200.00','1','10','检验员2',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('121','30','6','7','1592906535','1592906723','200','200','1.0000','200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'200','86','操作工1','33','18','12','无心磨','检验员1','无心工艺','200.00','1',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('122','34','6','7','1594780460','1594816793','50000','40000','0.9975','39900','10','50','40','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'40000','102','操作工1','57','20','11','平面磨','检验员1','磨双端面','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('123','34','6','7','1594863771','1594864252','25000','25000','0.9999','24998','1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'24999','103','操作工1','58','21','12','无心磨','检验员1','粗磨外圆','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('124','34','6','7','1595053149','1595058982','20000','20000','1.0000','20000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'20000','102','操作工1','57','20','11','平面磨','检验员1','磨双端面','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('125','35','6',NULL,'1595226871',NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','108','操作工1','50','26','13','磨孔',NULL,'精磨孔',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('126','35','6',NULL,'1595385458',NULL,'10000','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','108','操作工1','50','26','13','磨孔',NULL,'精磨孔',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('127','35','6',NULL,'1595385585',NULL,'10000','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','108','操作工1','50','26','13','磨孔',NULL,'精磨孔',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('128','40','6','7','1595385630','1595385949','50000','40000','0.9998','39991',NULL,'8','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'40000','144','操作工1','57','20','11','平面磨','检验员1','磨双端面','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('129','40','6',NULL,'1595385976',NULL,'20000','500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','144','操作工1','57','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('130','35','6',NULL,'1595390238',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','108','操作工1','50','26','13','磨孔',NULL,'精磨孔',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('131','15','6',NULL,'1595570858',NULL,'1000','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('132','41','6',NULL,'1595573265',NULL,'989','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','150','操作工1','77','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('133','41','6',NULL,'1595573303',NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','150','操作工1','77','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('134','41','6',NULL,'1595573384',NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','150','操作工1','77','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('135','41','6',NULL,'1595575666',NULL,'11','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','150','操作工1','77','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('136','43','6',NULL,'1595577974',NULL,'100','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','169','操作工1','89','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('137','43','6',NULL,'1595577996',NULL,'100','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','169','操作工1','89','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('138','43','6',NULL,'1595578170',NULL,'100','98',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','169','操作工1','89','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('139','43','6',NULL,'1595641604',NULL,'98','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','169','操作工1','89','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('140','44','6',NULL,'1595642736',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','179','操作工1','89','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('141','36','6',NULL,'1596005491',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','117','操作工1','65','35','16','装配',NULL,'装配',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('142','35','6',NULL,'1596005542',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','108','操作工1','50','26','13','磨孔',NULL,'精磨孔',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('143','15','6',NULL,'1596163774',NULL,'10','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('144','15','6',NULL,'1596174051',NULL,'10','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','43','操作工1','25','9','6','工种01',NULL,'工艺001-01',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('145','36','6',NULL,'1596174252',NULL,'10','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','117','操作工1','65','35','16','装配',NULL,'装配',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('146','46','6','7','1596174412','1596175552','10','10','1.0000','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'10','195','操作工1','65','35','16','装配','检验员1','装配','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('147','47','24','7','1596185581','1596190667','10','9','1.0000','9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9','201','操作工4','24','11','7','工种02','检验员1','工艺003-02','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('148','18','24','7','1596190499','1596193878','10','10','1.0000','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'10','52','操作工4','29','11','7','工种02','检验员1','工艺003-02','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('149','48','24','7','1596190549','1596193414','100','5','1.0000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5','204','操作工4','29','11','7','工种02','检验员1','工艺003-02','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('150','43','24','10','1596247477','1596247706','1000','800','0.9988','799',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'800','169','操作工4','89','20','11','平面磨','检验员2','磨双端面','0.00','1','8','主管',NULL,NULL,NULL,'1');");
$this->E_D("replace into `db_task_sub` values('151','39','24',NULL,'1596266099',NULL,'10000','10000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','138','操作工4','65','35','16','装配',NULL,'装配',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('152','46','24',NULL,'1596266257',NULL,'10','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','196','操作工4','66','36','14','检测',NULL,'内复圆检测',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('153','51','9','7','1596593143','1596604510','1000','900','1.0000','900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'900','223','操作工2','77','20','11','平面磨','检验员1','磨双端面','0.00','1','7','检验员1',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('154','52','9','7','1596594159','1596767863','1000','500','0.9400','470','1','5','3',NULL,NULL,NULL,NULL,'11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'470','232','操作工2','89','20','11','平面磨','检验员1','磨双端面','0.00','0',NULL,NULL,'10',NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('155','52','6','7','1596594627','1596767771','200','200','0.9850','197','1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'197','232','操作工1','89','20','11','平面磨','检验员1','磨双端面','0.00','0',NULL,NULL,NULL,NULL,'1',NULL);");
$this->E_D("replace into `db_task_sub` values('156','53','6','7','1596595062','1596595687','30000','30000','0.9967','29900',NULL,'100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30000','242','操作工1','57','20','11','平面磨','检验员1','磨双端面','0.00','1','7','检验员1',NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('157','52','6','7','1596595210','1596767718','100','50','0.9200','46','1','1',NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46','232','操作工1','89','20','11','平面磨','检验员1','磨双端面','0.00','0',NULL,NULL,'1',NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('158','51','6',NULL,'1596595483',NULL,'50','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','223','操作工1','77','20','11','平面磨',NULL,'磨双端面',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('159','56','9',NULL,'1596604810',NULL,'100','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','266','操作工2','65','35','16','装配',NULL,'装配',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('160','15','6',NULL,'1596972476',NULL,'100','100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','42','操作工1','24','11','7','工种02',NULL,'工艺003-02',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);");
$this->E_D("replace into `db_task_sub` values('161','59','6','7','1597305530','1597406235','100000','40000','0.8750','35000',NULL,NULL,'5000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'40000','299','操作工1','125','58','42','热处理','检验员1','高频淬火','0.00','1','7','检验员1',NULL,NULL,NULL,NULL);");
?>
Reference in New Issue View Git Blame Copy Permalink