master

分支 (1)

管理

管理

master

menjiabannew
/
ssi_common_code.sql

/*
Navicat MySQL Data Transfer

Source Server         : acetext
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : meijia

Target Server Type    : MYSQL
Target Server Version : 50540
File Encoding         : 65001

Date: 2018-03-15 18:26:01
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ssi_common_code
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_code`;
CREATE TABLE `ssi_common_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `code` varchar(32) NOT NULL COMMENT '返回代码',
  `value` text NOT NULL COMMENT '返回信息',
  `intro` varchar(200) NOT NULL COMMENT '返回说明',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='公共返回代码表';

-- ----------------------------
-- Records of ssi_common_code
-- ----------------------------
INSERT INTO `ssi_common_code` VALUES ('2', '-1', '系统繁忙，此时稍候再试', '', '1');
INSERT INTO `ssi_common_code` VALUES ('3', '-2', '不合法的请求方式', '', '1');
INSERT INTO `ssi_common_code` VALUES ('4', '-3', '没有权限', '', '1');
INSERT INTO `ssi_common_code` VALUES ('5', '-4', '未知错误', '', '1');
INSERT INTO `ssi_common_code` VALUES ('6', '-5', '活动总结不能少于30字', '', '1');
INSERT INTO `ssi_common_code` VALUES ('7', '0', '请求成功', '', '1');
INSERT INTO `ssi_common_code` VALUES ('8', '1', '请求成功', '', '1');
INSERT INTO `ssi_common_code` VALUES ('9', '10000001', '没有带数据的请求', '', '1');
INSERT INTO `ssi_common_code` VALUES ('10', '10000002', '信息被占用无法修改', '', '1');
INSERT INTO `ssi_common_code` VALUES ('11', '10000003', '原密码错误', '', '1');
INSERT INTO `ssi_common_code` VALUES ('12', '10000004', '信息被占用无法新增', '', '1');
INSERT INTO `ssi_common_code` VALUES ('13', '10000005', '用户不存在', '', '1');
INSERT INTO `ssi_common_code` VALUES ('15', '123', '请输入正确的手机号码', '', '1');
INSERT INTO `ssi_common_code` VALUES ('16', '222', '用户名不能为空', '', '1');

-- ----------------------------
-- Table structure for ssi_common_conf
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_conf`;
CREATE TABLE `ssi_common_conf` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `fcid` int(11) NOT NULL COMMENT '所属上级配置',
  `tier` int(11) NOT NULL COMMENT '层级',
  `name` varchar(32) NOT NULL COMMENT '配置',
  `value` varchar(32) NOT NULL COMMENT '配置值',
  `intro` varchar(200) NOT NULL COMMENT '说明',
  `sort` int(11) NOT NULL COMMENT '排序',
  `img` varchar(500) NOT NULL COMMENT '配置图片',
  `status` tinyint(4) NOT NULL COMMENT '配置状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COMMENT='公共配置表';

-- ----------------------------
-- Records of ssi_common_conf
-- ----------------------------
INSERT INTO `ssi_common_conf` VALUES ('1', '0', '1', '系统配置', '系统配置', '系统设置', '1000', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('2', '1', '2', 'LOGIN_AUTH_TYPE', '1', '登录验证1为cookie 2为session', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('3', '1', '2', 'ITEM_NAME', '美家板信息化管理系统', '项目名称', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('4', '1', '2', 'ITEM_VERSION', '', '项目版本 下级是版本详情', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('5', '1', '2', 'ITEM_BEGIN_TIME', '2017', '项目开始时间', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('6', '1', '2', 'ITEM_COPYRIGHT', '大连肆网科技有限公司 &amp; 大连肆网软件研发中心', '项目版权方', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('7', '1', '2', 'ACTION_LOG', '0', '1是开启 0是关闭', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('8', '1', '3', '', '1.0', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('9', '1', '2', 'LOGIN_AUTH_TIME', '36000', '如果是cookie的话登陆时长', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('10', '0', '1', '门参数配置', 'Door_setting', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('11', '10', '2', '门型', 'Door_type', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('12', '11', '3', '英式斜拼', 'British_oblique', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('13', '11', '3', '英式直拼', 'British_straight', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('14', '11', '3', '英式拱形', 'British_arch', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('15', '11', '3', '德式', 'German', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('16', '11', '3', '法式', 'French', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('17', '11', '3', '中式', 'Chinese_style', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('18', '11', '3', '韩式', 'Korean', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('19', '11', '3', 'XS-16-1', 'XS_16_1', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('20', '11', '3', 'XS-16-2', 'XS_16_2', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('21', '10', '2', '芯板', 'Core_board', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('22', '21', '3', '芯板-1', 'Core_board_1', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('23', '21', '3', '芯板-2', 'Core_board_2', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('24', '21', '3', '平板', 'Flat', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('25', '21', '3', '中式芯板', 'Core_board_chinese_style', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('26', '21', '3', '网格', 'Grid', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('27', '21', '3', '上玻璃下芯板-1', 'Glass_core_board_1', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('28', '21', '3', '上玻璃下芯板-2', 'Glass_core_board_2', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('29', '21', '3', '上假百叶下芯板-1', 'Shutter_false_core_board_1', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('30', '21', '3', '上假百叶下芯板-2', 'Shutter_false_core_board_2', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('31', '21', '3', '透气百叶', 'Shutter_air_permeable', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('32', '21', '3', '假百叶', 'Shutter_false', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('33', '21', '3', '普通玻璃', 'Glass_commen', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('34', '21', '3', '钻石玻璃', 'Glass_diamond', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('35', '21', '3', '磨砂玻璃', 'Glass_frosted', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('36', '21', '3', '铜条玻璃', 'Glass_copper', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('37', '21', '3', '布纹玻璃', 'Glass_woven', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('38', '21', '3', '挖框不配玻璃背板开槽', 'Glass_no_slotting', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('39', '10', '2', '表面颜色', 'Color_surface', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('40', '39', '3', '羊脂白', 'Suet_white', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('41', '39', '3', '田园橡木', 'Garden_oak', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('42', '39', '3', '苏香桐', 'Suxiangtong', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('43', '39', '3', '盾美白橡', 'Whitening_rubber_shield', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('44', '39', '3', '海之蓝', 'Blue_sea', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('45', '39', '3', '金丝樱桃', 'Golden_cherry', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('46', '39', '3', '相思木-4', 'Acacia_4', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('47', '39', '3', '拉菲红', 'Red_laffey', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('48', '39', '3', '米兰橡木', 'Milan_oak', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('49', '39', '3', '云橡', 'Cloud_oak', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('50', '39', '3', '新枫木', 'New_maple', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('51', '39', '3', '黄金枫木', 'Gold_maple', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('52', '39', '3', '古木樱桃', 'Antique_cherry', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('53', '39', '3', '复古黄橡-2', 'Yellow_oak_2', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('54', '39', '3', '龙凤檀', 'Cumaru', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('55', '39', '3', '索菲亚白', 'Sophia_white', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('56', '39', '3', '复古银橡', 'Silvery_oak', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('57', '39', '3', '黄樱桃', 'Rainier_cherry', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('58', '39', '3', '秋樱色', 'Autumn_cherry', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('59', '39', '3', '立体油墨', 'Solid_ink', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('60', '39', '3', 'LG橡木', 'Lg_oak', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('61', '10', '2', '打孔', 'Punch', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('62', '61', '3', '无', 'Punch_no', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('63', '61', '3', '2', 'Punch_2', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('64', '61', '3', '3', 'Punch_3', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('65', '61', '3', '4', 'Punch_4', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('66', '61', '3', '5', 'Punch_5', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('67', '10', '2', '打孔样式', 'Punch_style', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('68', '67', '3', '正常打孔', 'Punch_common', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('69', '67', '3', '特殊位置打孔', 'Punch_special', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('70', '67', '3', '中恒位置46分', 'Punch_constant_46', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('71', '67', '3', '中恒特殊如图', 'Punch_constant_special', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('72', '67', '3', '无中恒', 'Punch_constant_no', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('73', '0', '1', '工序参数配置', 'Way_setting', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('74', '73', '2', '包覆系统', 'Cladding_System', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('75', '73', '2', '吸塑系统', 'Plastic_System', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('76', '74', '3', '原料入库', 'BF_YLRK', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('77', '74', '3', '门芯下料', 'BF_MXXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('78', '74', '3', '边框下料', 'BF_BKXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('79', '74', '3', '裸料小件下料', 'BF_LLXJXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('80', '74', '3', '英法式中横下料', 'BF_YFSZHXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('81', '74', '3', '德式中横下料', 'BF_DSZHXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('82', '74', '3', '网格百叶下料', 'BF_WGBYXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('83', '74', '3', '成品小件下料', 'BF_CPXJXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('84', '74', '3', '铣型', 'BF_XX', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('85', '74', '3', '打磨', ' BF_DM', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('86', '74', '3', '吸覆', 'BF_XF', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('87', '74', '3', '组框', 'BF_ZK', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('88', '74', '3', '打孔', 'BF_DK', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('89', '74', '3', '修色质检', 'BF_XSZJ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('90', '74', '3', '做旧', 'BF_ZJ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('91', '74', '3', '包装', 'BF_BZ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('92', '74', '3', '成品库', 'BF_CPK', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('93', '74', '3', '物流发货', 'BF_WLFH', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('94', '75', '3', '原料入库', 'XS_YLRK', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('95', '75', '3', '门板下料', 'XS_MBXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('96', '75', '3', '裸料小件下料', 'XS_LLXJXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('97', '75', '3', '成品小件下料', 'XS_CPXJXL', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('98', '75', '3', '雕刻', 'XS_DK', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('99', '75', '3', '打孔', 'XS_DAKONG', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('100', '75', '3', '铣边', 'XS_XB', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('101', '75', '3', '镶嵌', 'XS_XQ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('102', '75', '3', '打磨', 'XS_DM', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('103', '75', '3', '吸覆', 'XS_XF', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('104', '75', '3', '修色质检', 'XS_XSZJ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('105', '75', '3', '做旧', 'XS_ZJ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('106', '75', '3', '包装', 'XS_BZ', '', '0', '', '1');
INSERT INTO `ssi_common_conf` VALUES ('107', '75', '3', '物流发货', 'XS_WLFH', '', '0', '', '1');

-- ----------------------------
-- Table structure for ssi_common_menu
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_menu`;
CREATE TABLE `ssi_common_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `fmid` int(11) NOT NULL COMMENT '所属上级菜单',
  `tier` int(11) NOT NULL COMMENT '菜单的层级',
  `name` varchar(32) NOT NULL COMMENT '菜单名称',
  `url` varchar(500) NOT NULL COMMENT '菜单连接',
  `target` int(11) NOT NULL DEFAULT '1' COMMENT '打开类型 1为当前 2为新窗口',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT '类型3组表 4行为  1为内链 2为外联',
  `sort` int(11) NOT NULL COMMENT '排序',
  `icon` varchar(32) NOT NULL COMMENT '图标',
  `status` tinyint(4) NOT NULL COMMENT '菜单状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=98 DEFAULT CHARSET=utf8 COMMENT='公共菜单表';

-- ----------------------------
-- Records of ssi_common_menu
-- ----------------------------
INSERT INTO `ssi_common_menu` VALUES ('1', '0', '1', '系统', 'Admin/Console/Dashboard.html', '1', '1', '1000', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('2', '1', '2', '控制台', '', '2', '3', '1000', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('3', '1', '2', '菜单管理', 'Admin/Menu/Manage.html', '1', '1', '990', 'fa fa-list', '1');
INSERT INTO `ssi_common_menu` VALUES ('4', '1', '2', '群组管理', 'Admin/Group/Manage.html', '1', '1', '960', 'fa fa-group', '1');
INSERT INTO `ssi_common_menu` VALUES ('5', '1', '2', '用户管理', 'Admin/User/Manage.html', '1', '1', '950', 'fa fa-user', '1');
INSERT INTO `ssi_common_menu` VALUES ('6', '1', '2', '数据管理', 'Admin/Data/Manage.html', '1', '1', '920', 'fa fa-copy', '1');
INSERT INTO `ssi_common_menu` VALUES ('7', '1', '2', '文件管理', 'Admin/File/Manage.html', '1', '1', '910', 'fa fa-file', '1');
INSERT INTO `ssi_common_menu` VALUES ('8', '1', '2', '我的信息', '', '1', '3', '900', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('9', '1', '2', '修改资料', 'Admin/My/Info.html', '1', '1', '890', 'fa fa-vimeo-square', '1');
INSERT INTO `ssi_common_menu` VALUES ('10', '1', '2', '修改密码', 'Admin/My/Password.html', '1', '1', '880', 'fa fa-lock', '1');
INSERT INTO `ssi_common_menu` VALUES ('11', '6', '3', '备份记录', 'Admin/Data/Log.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('12', '5', '3', '创建用户', 'Admin/User/Create.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('13', '3', '3', '创建菜单', 'Admin/Menu/Create.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('14', '3', '3', '编辑菜单', 'Admin/Menu/Edit.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('15', '3', '3', '删除菜单', 'Admin/Menu/Delete.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('16', '4', '3', '群组权限', 'Admin/Group/Auth.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('17', '4', '3', '编辑群组权限', 'Admin/Group/AuthEdit.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('18', '4', '3', '创建群组', 'Admin/Group/Create.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('19', '4', '3', '编辑群组', 'Admin/Group/Edit.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('20', '4', '3', '删除群组', 'Admin/Group/Delete.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('21', '5', '3', '编辑用户', 'Admin/User/Edit.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('22', '5', '3', '用户权限', 'Admin/User/Auth.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('23', '5', '3', '编辑用户权限', 'Admin/User/AuthEdit.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('24', '5', '3', '改变用户信息', 'Admin/User/Status.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('25', '6', '3', '数据库备份', 'Admin/Data/Backup.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('26', '6', '3', '数据库优化', 'Admin/Data/Optimize.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('27', '6', '3', '数据库下载', 'Admin/Data/Download.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('28', '6', '3', '数据库修复', 'Admin/Data/Repair.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('29', '6', '3', '数据库还原', 'Admin/Data/Restore.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('30', '6', '3', '数据库救世主备份', 'Admin/Data/Redeemer.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('31', '6', '3', 'phpMyAdmin插件', 'Home/Auth/Login/Addon/PHPMyAdmin.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('32', '7', '3', 'KODExplorer插件', 'Home/Auth/Login/Addon/KODExplorer.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('33', '1', '2', '配置管理', 'Admin/Conf/Manage.html', '1', '1', '980', 'fa fa-cog', '1');
INSERT INTO `ssi_common_menu` VALUES ('34', '0', '1', '门厂', 'Admin/Material/Track.html', '1', '1', '1000', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('36', '34', '2', '数据设置', '', '1', '3', '1000', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('97', '34', '2', '工序配置', 'Admin/Process/Manage.html', '1', '1', '970', 'fa fa-cogs', '1');
INSERT INTO `ssi_common_menu` VALUES ('38', '34', '2', '下料单', '', '1', '3', '800', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('96', '0', '0', '', '', '1', '1', '0', '', '0');
INSERT INTO `ssi_common_menu` VALUES ('40', '39', '3', '新增下料单', 'Admin/Material/Add.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('41', '39', '3', '编辑下料单', 'Admin/Material/EditM.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('42', '39', '3', '预览下料单', 'Admin/Material/View.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('95', '34', '2', '纸材设置', 'Admin/Promap/Manage.html', '1', '1', '770', 'fa fa-user', '1');
INSERT INTO `ssi_common_menu` VALUES ('44', '34', '2', '扫码枪设置', 'Admin/Scanning/Manage.html', '1', '1', '980', 'fa fa-crosshairs', '1');
INSERT INTO `ssi_common_menu` VALUES ('45', '44', '3', '工序关联', 'Admin/Scanning/Relation.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('94', '34', '2', '板张设置', 'Admin/Proma/Manage.html', '1', '1', '770', 'fa fa-user', '1');
INSERT INTO `ssi_common_menu` VALUES ('47', '39', '3', '流程定义', 'Admin/Material/Step.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('48', '34', '2', '下料单追踪', 'Admin/Plates/Track.html', '1', '1', '770', 'fa fa-shield', '1');
INSERT INTO `ssi_common_menu` VALUES ('49', '48', '3', '下料单检索', 'Admin/Material/Search.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('50', '34', '2', '客户管理', 'Admin/Member/Manage.html', '1', '1', '960', 'fa fa-user', '1');
INSERT INTO `ssi_common_menu` VALUES ('51', '50', '3', '添加客户', 'Admin/Member/Create.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('52', '50', '3', '修改客户', 'Admin/Member/Edit.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('53', '39', '3', '获取条形码', 'Admin/Material/barcode_create.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('54', '39', '3', 'AJAX添加下料单', 'Admin/Material/AddData.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('55', '39', '3', 'AJAX下料单新增产品', 'Admin/Material/Creat.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('56', '39', '3', '删除下料单', 'Admin/Material/Delete.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('57', '39', '3', 'AJAX新增芯板', 'Admin/Material/CoreCreate.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('58', '39', '3', '自动匹配颜色', 'Admin/Material/InputColorSearch.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('59', '39', '3', '关联用户列表', 'Admin/Material/SelectMemberSearch.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('60', '39', '3', '流程修改', 'Admin/Material/StepEdit.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('61', '43', '3', '修改付款状态', 'Admin/Material/AuditPay.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('62', '39', '3', '修改发货信息', 'Admin/Material/SetLG.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('63', '39', '3', '修改订单状态', 'Admin/Material/SStatus.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('64', '35', '3', '下料单检索', 'Admin/Material/SearchManage.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('65', '43', '3', '下料单检索', 'Admin/Material/SearchAudit.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('66', '39', '3', '下料单检索', 'Admin/Material/SearchManage.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('67', '1', '2', '操作行为', 'Admin/Behavior/Manage.html', '1', '1', '970', 'fa fa-male', '1');
INSERT INTO `ssi_common_menu` VALUES ('68', '67', '3', '行为记录', 'Admin/Behavior/Log.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('69', '39', '3', '新增订单', 'Admin/Material/AddOrder.html', '1', '4', '2', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('70', '39', '3', '编辑订单', 'Admin/Material/EditOrder.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('71', '39', '3', '编辑订单', 'Admin/Material/EditOrder.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('72', '39', '3', '预览订单', 'Admin/Material/ViewOrder.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('73', '39', '3', '打印销售单', 'Admin/Material/ViewL.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('74', '39', '3', '打印下料单', 'Admin/Material/ViewR.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('76', '39', '3', 'Ajax添加订单', 'Admin/Material/Addpro.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('77', '39', '3', 'Ajax修改订单', 'Admin/Material/AjaxEditMaterial.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('78', '39', '3', 'Ajax删除产品', 'Admin/Material/AjaxDelPro.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('79', '39', '3', 'Ajax修改芯板', 'Admin/Material/AjaxEditBoard.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('80', '39', '3', 'Ajax修改产品', 'Admin/Material/AjaxEditProduct.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('81', '39', '3', 'Ajax财务付款', 'Admin/Material/AuditPay.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('82', '39', '3', 'Ajax财务修改付款', 'Admin/Material/EditPay.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('83', '43', '3', '修改款项', 'Admin/Material/EditPay.html', '1', '4', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('84', '34', '2', '统计查询', '', '1', '3', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('85', '34', '2', '扫码枪统计', 'Admin/Material/CountQr', '1', '1', '0', 'fa fa-bar-chart-o', '1');
INSERT INTO `ssi_common_menu` VALUES ('86', '34', '2', '条码打印', 'Admin/Print/Manage', '1', '1', '0', ' fa fa-edit', '1');
INSERT INTO `ssi_common_menu` VALUES ('87', '86', '3', '打印', 'Admin/Print/ViewR.html', '1', '1', '0', '', '1');
INSERT INTO `ssi_common_menu` VALUES ('88', '34', '2', '板材下单', 'Admin/Plates/Manage.html', '1', '1', '770', 'fa fa-edit', '1');
INSERT INTO `ssi_common_menu` VALUES ('89', '34', '2', '门板下单审核', 'Admin/Plates/Audit.html', '1', '1', '770', 'fa fa-edit', '1');
INSERT INTO `ssi_common_menu` VALUES ('92', '34', '2', '销售人员管理', 'Admin/Saler/Manage.html', '1', '1', '960', 'fa fa-user', '1');

-- ----------------------------
-- Table structure for ssi_common_upload
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_upload`;
CREATE TABLE `ssi_common_upload` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源id',
  `uid` int(11) NOT NULL COMMENT '所属用户',
  `title` varchar(32) NOT NULL COMMENT '新文件名',
  `original` varchar(200) NOT NULL COMMENT '原文件名',
  `url` varchar(500) NOT NULL COMMENT '资源地址',
  `size` int(11) NOT NULL COMMENT '文件大小',
  `type` varchar(32) NOT NULL COMMENT '类型',
  `time` int(11) NOT NULL COMMENT '上传时间',
  `is_ok` tinyint(4) NOT NULL DEFAULT '2' COMMENT '审核状态 2为待审核 1为审核通过 0为删除',
  `is_time` int(11) NOT NULL COMMENT '审核时间',
  `is_uid` int(11) NOT NULL COMMENT '审核管理员',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COMMENT='公共上传资源数据库';

-- ----------------------------
-- Records of ssi_common_upload
-- ----------------------------
INSERT INTO `ssi_common_upload` VALUES ('61', '1', '5922a9985f5e1.png', 'oufeite.png', '/upload/1/2017/05/22/5922a9985f5e1.png', '53451', '1', '1495443864', '2', '0', '0', '1');
INSERT INTO `ssi_common_upload` VALUES ('62', '1', '595498f838cfa.jpg', 'user.jpg', '/upload/1/2017/06/29/595498f838cfa.jpg', '2510', '2', '1498716408', '2', '0', '0', '1');
INSERT INTO `ssi_common_upload` VALUES ('63', '1', '5959a33ab4930.jpg', 'user.jpg', '/upload/1/2017/07/03/5959a33ab4930.jpg', '2510', '2', '1499046714', '2', '0', '0', '1');
INSERT INTO `ssi_common_upload` VALUES ('64', '1', '596b0bfb03baf.jpg', 'user.jpg', '/upload/1/2017/07/16/596b0bfb03baf.jpg', '2510', '2', '1500187643', '2', '0', '0', '1');
INSERT INTO `ssi_common_upload` VALUES ('65', '1', '596b588c410a7.jpg', 'user.jpg', '/upload/1/2017/07/16/596b588c410a7.jpg', '2510', '2', '1500207244', '2', '0', '0', '1');

-- ----------------------------
-- Table structure for ssi_common_upload_type
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_upload_type`;
CREATE TABLE `ssi_common_upload_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '上传类型id',
  `title` varchar(32) NOT NULL COMMENT '上传类型',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上传状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='上传类型表';

-- ----------------------------
-- Records of ssi_common_upload_type
-- ----------------------------
INSERT INTO `ssi_common_upload_type` VALUES ('1', 'png', '1');
INSERT INTO `ssi_common_upload_type` VALUES ('2', 'jpg', '1');

-- ----------------------------
-- Table structure for ssi_common_user
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_user`;
CREATE TABLE `ssi_common_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户UID',
  `cid` int(11) NOT NULL COMMENT '采购人员',
  `nickname` varchar(32) NOT NULL COMMENT '用户昵称',
  `sex` int(11) NOT NULL COMMENT '性别 1男 2女',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `email` varchar(32) NOT NULL COMMENT '邮箱',
  `tel` varchar(200) NOT NULL COMMENT '电话',
  `weixin_openid` varchar(32) NOT NULL COMMENT '微信openid',
  `weixin_unionid` varchar(50) NOT NULL COMMENT '微信unid',
  `img` varchar(500) NOT NULL DEFAULT 'http://image.zaiyoudao.com/image.php/zyd_386.html' COMMENT '头像',
  `password` varchar(32) NOT NULL COMMENT '用户密码',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `create_ip` varchar(32) NOT NULL COMMENT '创建ip',
  `auth` text NOT NULL COMMENT '权限列表',
  `auth_type` int(11) NOT NULL DEFAULT '1' COMMENT '权限类型 1为群组优先 2为用户优先',
  `money` float(10,2) NOT NULL COMMENT '用户余额',
  `integral` int(11) NOT NULL COMMENT '用户积分',
  `partner` int(11) NOT NULL COMMENT '是否是合作者 0为不是 1是',
  `province` varchar(32) NOT NULL COMMENT '地址',
  `country` varchar(32) NOT NULL COMMENT '国家',
  `is_perfect` int(11) NOT NULL COMMENT '是否完善 0未完善 1已完善',
  `superior` int(11) NOT NULL DEFAULT '1' COMMENT '推荐人ID',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态 1正常 2停用 0伪删除',
  `address` varchar(500) NOT NULL COMMENT '地址',
  `remark` varchar(500) NOT NULL COMMENT '备注',
  `company` varchar(500) NOT NULL COMMENT '公司',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COMMENT='公共用户表';

-- ----------------------------
-- Records of ssi_common_user
-- ----------------------------
INSERT INTO `ssi_common_user` VALUES ('1', '0', '大Boss', '1', 'admin', '215440666@qq.com', '', '', '', '/public/static/defaultadmin/assets/img/avatars/avatar.jpg', '86a375aacb17606c185d31c8d3e320ce', '1463234393', '123.117.58.209', '', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');
INSERT INTO `ssi_common_user` VALUES ('56', '0', '店小二', '0', 'kefu', '', '15555555555', '', '', '/upload/1/2017/06/29/595498f838cfa.jpg', '86a375aacb17606c185d31c8d3e320ce', '1498716411', '127.0.0.1', '', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');
INSERT INTO `ssi_common_user` VALUES ('57', '0', '大财务', '0', 'caiwu', '123@123.com', '1555555555', '', '', '/upload/1/2017/07/03/5959a33ab4930.jpg', '86a375aacb17606c185d31c8d3e320ce', '1499046728', '127.0.0.1', 'a:1:{i:0;s:2:\"43\";}', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');
INSERT INTO `ssi_common_user` VALUES ('58', '0', '财务测试', '0', '财务测试', '1234567@qq.com', '13312341234', '', '', '/public/static/defaultadmin/assets/img/avatars/avatar.jpg', '86a375aacb17606c185d31c8d3e320ce', '1505808567', '124.92.82.97', '', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');
INSERT INTO `ssi_common_user` VALUES ('59', '0', '内勤测试', '0', '内勤测试', '123456711@qq.com', '13312341234', '', '', '/public/static/defaultadmin/assets/img/avatars/avatar.jpg', '86a375aacb17606c185d31c8d3e320ce', '1505808605', '124.92.82.97', 's:0:\"\";', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');
INSERT INTO `ssi_common_user` VALUES ('60', '0', '生产管理测试', '0', '生产管理测试', '12345678@qq.com', '13312341234', '', '', '/public/static/defaultadmin/assets/img/avatars/avatar.jpg', '86a375aacb17606c185d31c8d3e320ce', '1505808665', '124.92.82.97', '', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');
INSERT INTO `ssi_common_user` VALUES ('61', '0', '打印', '0', '打印', '321321321@qq.com', '13312334123', '', '', '', '86a375aacb17606c185d31c8d3e320ce', '1511169859', '175.171.187.88', 'a:4:{i:0;s:2:\"34\";i:1;s:2:\"37\";i:2;s:2:\"86\";i:3;s:2:\"87\";}', '1', '0.00', '0', '0', '', '', '0', '1', '1', '', '', '');

-- ----------------------------
-- Table structure for ssi_common_user_behavior
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_user_behavior`;
CREATE TABLE `ssi_common_user_behavior` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '行为id',
  `fbid` int(11) NOT NULL COMMENT '所属上级ID',
  `tier` int(11) NOT NULL COMMENT '层级',
  `sole` varchar(200) NOT NULL COMMENT '唯一标示',
  `name` varchar(32) NOT NULL COMMENT '行为名称',
  `intro` varchar(200) NOT NULL COMMENT '行为介绍',
  `status` tinyint(4) NOT NULL COMMENT '行为状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COMMENT='用户行为表';

-- ----------------------------
-- Records of ssi_common_user_behavior
-- ----------------------------
INSERT INTO `ssi_common_user_behavior` VALUES ('1', '75', '2', 'admin_behavior_log', '查看行为记录', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('2', '75', '2', 'admin_behavior_manage', '查看行为类型', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('3', '75', '2', 'admin_behavior_create', '新增行为类型', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('4', '75', '2', 'admin_behavior_edit', '编辑行为类型', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('5', '75', '2', 'admin_behavior_delete', '删除行为类型', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('7', '75', '2', 'admin_conf_manage', '查看配置信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('8', '75', '2', 'admin_conf_create', '新增配置', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('9', '75', '2', 'admin_conf_edit', '编辑配置', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('10', '75', '2', 'admin_conf_delete', '删除配置', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('11', '75', '2', 'admin_console_dashboard', '进入仪表盘', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('12', '75', '2', 'admin_data_manage', '查看数据库信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('13', '75', '2', 'admin_data_backup', '进行数据库备份', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('14', '75', '2', 'admin_data_optimize', '优化数据库', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('15', '75', '2', 'admin_data_download', '下载数据库', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('16', '75', '2', 'admin_data_repair', '修复数据表', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('17', '75', '2', 'admin_data_log', '查看数据库备份记录', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('18', '75', '2', 'admin_data_restore', '进行数据库还原', 'TODO', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('19', '75', '2', 'admin_data_redeemer', '救世主数据备份', 'TODO', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('20', '75', '2', 'admin_file_manage', '查看文件信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('21', '75', '2', 'admin_group_auth', '查看群组权限', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('22', '75', '2', 'admin_group_authedit', '群组权限修改', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('23', '75', '2', 'admin_group_manage', '查看群组分类', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('24', '75', '2', 'admin_group_create', '新增群组', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('25', '75', '2', 'admin_group_edit', '编辑群组', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('26', '75', '2', 'admin_group_delete', '删除群组', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('27', '75', '2', 'admin_menu_manage', '查看菜单信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('28', '75', '2', 'admin_menu_create', '新增菜单', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('29', '75', '2', 'admin_menu_edit', '编辑菜单', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('30', '75', '2', 'admin_menu_delete', '删除菜单', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('31', '75', '2', 'admin_my_info_edit', '编辑我的信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('32', '75', '2', 'admin_my_info_view', '查看我的信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('33', '75', '2', 'admin_my_password_edit', '修改密码', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('34', '75', '2', 'admin_my_password_view', '进入修改密码页面', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('35', '75', '2', 'admin_nav_manage', '查看导航分类', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('36', '75', '2', 'admin_nav_create', '新增导航', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('37', '75', '2', 'admin_nav_edit', '编辑导航', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('38', '75', '2', 'admin_nav_delete', '删除导航', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('39', '75', '2', 'admin_public_logout', '用户安全退出', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('40', '75', '2', 'admin_public_register', '用户注册', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('41', '75', '2', 'admin_public_login', '用户登录', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('42', '75', '2', 'admin_user_auth', '查看用户权限', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('43', '75', '2', 'admin_user_authedit', '编辑用户权限', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('44', '75', '2', 'admin_user_manage', '查看用户信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('45', '75', '2', 'admin_user_create_create', '新增用户', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('46', '75', '2', 'admin_user_create_view', '进入新增用户页面', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('47', '75', '2', 'admin_user_edit_edit', '编辑用户', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('48', '75', '2', 'admin_user_edit_view', '进入编辑用户页面', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('49', '75', '2', 'admin_user_status_password', '重置密码', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('50', '75', '2', 'admin_user_status_enabled', '启用用户', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('51', '75', '2', 'admin_user_status_outage', '停用用户', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('52', '75', '2', 'addon_systeminfo_system_log', '查看YiPHP更新日志', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('53', '75', '2', 'addon_systeminfo_system_info', '查看系统信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('54', '75', '2', 'addon_clearcache_clear_cache', '清除缓存', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('55', '75', '2', 'addon_teaminfo_team_info', '查看产品团队页面', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('56', '75', '2', 'addon_phpmyadmin_auth_login', '使用phpMyAdmin', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('57', '75', '2', 'addon_kodexplorer_auth_login', '使用KODExplorer', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('58', '75', '2', 'addon_isdceserve_help_conf', '查看如何配置项目信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('59', '75', '2', 'addon_isdceserve_help_remoteintro', '查看远程登录说明', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('60', '75', '2', 'addon_isdceserve_help_disclaimer', '查看免责声明', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('61', '75', '2', 'addon_isdceserve_item_conf_view', '进入服务项目配置页面', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('62', '75', '2', 'addon_isdceserve_item_conf_edit', '编辑服务配置', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('63', '75', '2', 'addon_isdceserve_item_info', '查看项目信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('64', '75', '2', 'addon_isdceserve_item_demand', '查看项目需求', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('65', '75', '2', 'addon_isdceserve_item_demandlog', '常看往期需求', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('66', '75', '2', 'addon_isdceserve_item_calendar', '查看项目排期', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('67', '75', '2', 'addon_isdceserve_item_chatroom', '进入聊天室', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('68', '75', '2', 'addon_isdceserve_item_developer', '查看开发者', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('69', '75', '2', 'addon_isdceserve_item_offer', '查看项目报价', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('70', '75', '2', 'addon_isdceserve_item_contract', '查看合同信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('71', '75', '2', 'addon_isdceserve_item_money', '查看资金信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('72', '75', '2', 'addon_isdceserve_workorder_create', '提交工单', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('73', '75', '2', 'addon_isdceserve_workorder_info', '查看工单信息', '', '1');
INSERT INTO `ssi_common_user_behavior` VALUES ('75', '0', '1', '系统行为', '系统行为', '系统行为', '1');

-- ----------------------------
-- Table structure for ssi_common_user_behavior_log
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_user_behavior_log`;
CREATE TABLE `ssi_common_user_behavior_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '行为记录ID',
  `bid` int(11) NOT NULL COMMENT '所属行为id',
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `sole` varchar(32) NOT NULL COMMENT '行为标示',
  `i` text NOT NULL COMMENT '获得用户提交信息',
  `time` int(11) NOT NULL COMMENT '产生时间',
  `ip` varchar(50) NOT NULL COMMENT '产生IP',
  `status` tinyint(4) NOT NULL COMMENT '状态 1为正常',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户行为记录';

-- ----------------------------
-- Records of ssi_common_user_behavior_log
-- ----------------------------

-- ----------------------------
-- Table structure for ssi_common_user_for_group
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_user_for_group`;
CREATE TABLE `ssi_common_user_for_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自然ID',
  `uid` int(11) NOT NULL COMMENT '用户UID',
  `gid` int(11) NOT NULL COMMENT '群组GID',
  `type` int(11) NOT NULL COMMENT '群组类型',
  `status` tinyint(4) NOT NULL COMMENT '状态 1为正常 2停用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='用户关联群组表';

-- ----------------------------
-- Records of ssi_common_user_for_group
-- ----------------------------
INSERT INTO `ssi_common_user_for_group` VALUES ('1', '1', '1', '1', '1');
INSERT INTO `ssi_common_user_for_group` VALUES ('3', '56', '4', '1', '1');
INSERT INTO `ssi_common_user_for_group` VALUES ('5', '57', '5', '1', '1');
INSERT INTO `ssi_common_user_for_group` VALUES ('11', '58', '5', '1', '1');
INSERT INTO `ssi_common_user_for_group` VALUES ('10', '59', '4', '1', '1');
INSERT INTO `ssi_common_user_for_group` VALUES ('9', '60', '7', '1', '1');
INSERT INTO `ssi_common_user_for_group` VALUES ('12', '61', '3', '1', '1');

-- ----------------------------
-- Table structure for ssi_common_user_group
-- ----------------------------
DROP TABLE IF EXISTS `ssi_common_user_group`;
CREATE TABLE `ssi_common_user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '群组GID',
  `name` varchar(32) NOT NULL COMMENT '群组名称',
  `type` int(11) NOT NULL COMMENT '群组类型 1为后台 2为独立群组',
  `intro` varchar(200) NOT NULL COMMENT '群组介绍',
  `auth` text NOT NULL COMMENT '群组权限',
  `url` varchar(200) NOT NULL COMMENT '登录后跳转页面',
  `status` tinyint(4) NOT NULL COMMENT '群组状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='公共群组表';

-- ----------------------------
-- Records of ssi_common_user_group
-- ----------------------------
INSERT INTO `ssi_common_user_group` VALUES ('1', '开发者', '1', '开发者', 'a:18:{i:0;s:1:\"1\";i:1;s:1:\"3\";i:2;s:1:\"4\";i:3;s:2:\"17\";i:4;s:2:\"18\";i:5;s:2:\"19\";i:6;s:2:\"20\";i:7;s:2:\"12\";i:8;s:2:\"21\";i:9;s:2:\"22\";i:10;s:2:\"23\";i:11;s:2:\"24\";i:12;s:2:\"25\";i:13;s:2:\"26\";i:14;s:2:\"27\";i:15;s:2:\"28\";i:16;s:2:\"86\";i:17;s:2:\"87\";}', 'Admin/Console/Dashboard', '1');
INSERT INTO `ssi_common_user_group` VALUES ('2', '管理员', '1', '管理员', 'a:14:{i:0;s:1:\"1\";i:1;s:1:\"3\";i:2;s:2:\"13\";i:3;s:2:\"14\";i:4;s:2:\"15\";i:5;s:1:\"4\";i:6;s:2:\"20\";i:7;s:2:\"21\";i:8;s:2:\"24\";i:9;s:2:\"26\";i:10;s:2:\"27\";i:11;s:2:\"28\";i:12;s:2:\"86\";i:13;s:2:\"87\";}', 'Admin/Console/Dashboard', '1');
INSERT INTO `ssi_common_user_group` VALUES ('3', '默认用户组', '1', '默认用户组', 'a:3:{i:0;s:2:\"34\";i:1;s:2:\"86\";i:2;s:2:\"87\";}', 'Admin/Print/Manage', '1');
INSERT INTO `ssi_common_user_group` VALUES ('4', '内勤', '1', '内勤', 'a:33:{i:0;s:2:\"50\";i:1;s:2:\"51\";i:2;s:2:\"52\";i:3;s:2:\"38\";i:4;s:2:\"39\";i:5;s:2:\"69\";i:6;s:2:\"40\";i:7;s:2:\"41\";i:8;s:2:\"42\";i:9;s:2:\"47\";i:10;s:2:\"53\";i:11;s:2:\"54\";i:12;s:2:\"55\";i:13;s:2:\"56\";i:14;s:2:\"57\";i:15;s:2:\"58\";i:16;s:2:\"59\";i:17;s:2:\"60\";i:18;s:2:\"62\";i:19;s:2:\"63\";i:20;s:2:\"66\";i:21;s:2:\"70\";i:22;s:2:\"71\";i:23;s:2:\"72\";i:24;s:2:\"73\";i:25;s:2:\"74\";i:26;s:2:\"76\";i:27;s:2:\"77\";i:28;s:2:\"78\";i:29;s:2:\"79\";i:30;s:2:\"80\";i:31;s:2:\"48\";i:32;s:2:\"49\";}', 'Admin/Material/Manage', '1');
INSERT INTO `ssi_common_user_group` VALUES ('5', '财务', '1', '财务', 'a:12:{i:0;s:2:\"42\";i:1;s:2:\"53\";i:2;s:2:\"72\";i:3;s:2:\"73\";i:4;s:2:\"74\";i:5;s:2:\"81\";i:6;s:2:\"82\";i:7;s:2:\"43\";i:8;s:2:\"61\";i:9;s:2:\"65\";i:10;s:2:\"48\";i:11;s:2:\"49\";}', 'Admin/Material/Audit', '1');
INSERT INTO `ssi_common_user_group` VALUES ('6', '财务主管', '1', '财务主管', 'a:12:{i:0;s:2:\"42\";i:1;s:2:\"53\";i:2;s:2:\"72\";i:3;s:2:\"73\";i:4;s:2:\"74\";i:5;s:2:\"81\";i:6;s:2:\"82\";i:7;s:2:\"43\";i:8;s:2:\"61\";i:9;s:2:\"65\";i:10;s:2:\"48\";i:11;s:2:\"49\";}', 'Admin/Material/Audit', '1');
INSERT INTO `ssi_common_user_group` VALUES ('7', '生产管理', '1', '生产管理', 'a:4:{i:0;s:2:\"42\";i:1;s:2:\"72\";i:2;s:2:\"48\";i:3;s:2:\"49\";}', 'Admin/Material/Track', '1');

-- ----------------------------
-- Table structure for ssi_door_material
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_material`;
CREATE TABLE `ssi_door_material` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `sn` varchar(20) DEFAULT NULL,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '下料单标题',
  `company` varchar(255) DEFAULT NULL COMMENT '订货单位',
  `number` varchar(20) NOT NULL DEFAULT '' COMMENT '编号',
  `style` varchar(255) DEFAULT NULL COMMENT '造型',
  `frame` int(11) DEFAULT NULL COMMENT '边框',
  `deep` int(11) DEFAULT NULL COMMENT '槽深',
  `middle` int(11) DEFAULT NULL COMMENT '中横',
  `color` varchar(50) DEFAULT NULL COMMENT '颜色',
  `create_user` varchar(20) DEFAULT NULL COMMENT '制单人',
  `money` int(11) NOT NULL DEFAULT '0' COMMENT '金额',
  `packing_info` varchar(50) DEFAULT NULL COMMENT '包装时注明',
  `core_board_finish_time` int(11) DEFAULT NULL COMMENT '芯板单完成日期',
  `small_items_finsh_time` int(11) DEFAULT NULL COMMENT '小件完成日期',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0删除1正常2流程未定义',
  `mstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '支付状态0未付款1已付款2有欠款',
  `paynum` int(11) NOT NULL DEFAULT '0' COMMENT '已支付金额',
  `discountnum` int(11) NOT NULL DEFAULT '0' COMMENT '优惠金额',
  `arrearnum` int(11) NOT NULL DEFAULT '0' COMMENT '欠款金额',
  `arrears` int(11) NOT NULL DEFAULT '0',
  `sstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0未开始1已开始未完成2已完成',
  `tstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0未超时1已超时',
  `nstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0正常1加急',
  `starttime` int(11) NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endtime` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
  `logistics_number` varchar(50) NOT NULL DEFAULT '' COMMENT '货运单号',
  `logistics_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '收货人电话',
  `logistics_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '件数',
  `memberid` int(11) NOT NULL DEFAULT '0' COMMENT '关联用户id',
  `accept_time` int(11) NOT NULL DEFAULT '0' COMMENT '接单日期',
  `square` double(11,3) NOT NULL DEFAULT '0.000' COMMENT '总平方数',
  `to_user` varchar(50) DEFAULT NULL COMMENT '谨致',
  `to_user_copy` varchar(50) DEFAULT NULL COMMENT '抄送',
  `fax_no` varchar(25) DEFAULT NULL COMMENT '传真号码',
  `order_time` varchar(25) DEFAULT NULL COMMENT '订单日期',
  `order_tel` varchar(25) DEFAULT NULL COMMENT '订单电话',
  `sum_num` int(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  `square_pro` double(11,3) NOT NULL DEFAULT '0.000' COMMENT '芯板总面积',
  `money_pro` int(11) NOT NULL DEFAULT '0' COMMENT '芯板金额',
  `money_small` int(11) NOT NULL DEFAULT '0' COMMENT '小件金额',
  `square_small` double(11,3) NOT NULL DEFAULT '0.000' COMMENT '小件总面积',
  `sum_num_pro` int(11) NOT NULL DEFAULT '0' COMMENT '产品总数',
  `sum_num_small` int(11) NOT NULL DEFAULT '0' COMMENT '小件总数',
  `sum_num_pro_board` int(11) NOT NULL DEFAULT '0' COMMENT '产品芯板拆单数量',
  `title_o` varchar(50) NOT NULL DEFAULT '' COMMENT '订单标题',
  `make_money` int(11) NOT NULL DEFAULT '0' COMMENT '加工费',
  `make_money_info` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '加工费备注',
  `astatus` int(2) NOT NULL DEFAULT '0' COMMENT '财务审核状态0未通过1通过',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='下料单';

-- ----------------------------
-- Records of ssi_door_material
-- ----------------------------
INSERT INTO `ssi_door_material` VALUES ('39', '1', '171017171924', '', null, '', '法式', null, null, null, null, null, '4073', null, null, null, '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '4.350', null, null, null, null, '15566662066', '0', '4.200', '4073', '0', '0.150', '16', '2', '26', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('40', '59', '171017172353', '', '朝阳喀左展志天华', '1-110', '', '60', '8', '65', null, null, '473', '合顺李学忠', null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '1509033600', '2.380', null, null, null, null, '024-89244399', '11', '1.630', '473', '0', '0.750', '6', '5', '6', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('31', '59', '170921141722', '下料单', '唯意家', '9-1147', '法式1', '10', '20', '20', '金丝', null, '662', '唯意家', null, null, '3', '1', '662', '0', '0', '2', '0', '0', '0', '0', '0', '', '', '0', '0', '1507392000', '5.452', null, null, '024-89244393', null, '024-89244399', '22', '3.952', '652', '0', '1.500', '7', '15', '9', '', '10', '111', '0');
INSERT INTO `ssi_door_material` VALUES ('41', '1', '171119172835', '', null, '', '', null, null, null, null, null, '0', null, null, null, '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0.150', null, null, null, null, null, '0', '0.000', '0', '0', '0.150', '0', '1', '0', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('42', '1', '171203151155', '', null, '', null, null, null, null, null, null, '0', null, null, null, '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0.000', null, null, null, null, null, '0', '0.000', '0', '0', '0.000', '0', '0', '0', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('43', '1', '171210171732', '', null, '', '', null, null, null, null, null, '149', null, null, null, '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '13.574', null, null, null, null, null, '11', '13.574', '149', '0', '0.000', '11', '0', '0', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('44', '1', '171230122649', '', '张天罚', '0104414', '', '10', '10', '10', '黄色', null, '10884', '保护', null, null, '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '1514649600', '43.150', '陈谷金茂', '陈朝贤', null, null, null, '203', '33.150', '440', '10444', '10.000', '151', '163', '161', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('45', '1', '180104095225', '欧 菲 特 下 料 单 ', '沈阳正林橱柜', '1-974', '', '80', null, null, null, null, '3853', '中海盛京阁', null, null, '1', '0', '0', '0', '0', '0', '1', '0', '0', '1516157119', '0', '', '', '0', '0', '1516118400', '0.953', null, null, null, null, null, '6', '0.862', '328', '3525', '0.091', '4', '5', '4', '', '0', '', '1');
INSERT INTO `ssi_door_material` VALUES ('46', '1', '180117104305', '', null, '', '法式', null, null, null, null, null, '20', null, null, null, '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '13.650', null, null, null, null, null, '31', '13.650', '20', '0', '0.000', '31', '0', '10', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('47', '1', '180117172157', '', null, '', 'a\'a\'a\'a', null, null, null, '', null, '0', null, null, null, '3', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '', '', '0', '4', '0', '0.000', null, null, null, null, null, '0', '0.000', '0', '0', '0.000', '0', '0', '0', '', '0', '', '1');
INSERT INTO `ssi_door_material` VALUES ('48', '1', '180118180139', '', null, '', null, null, null, null, null, null, '0', null, null, null, '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0.000', null, null, null, null, null, '0', '0.000', '0', '0', '0.000', '0', '0', '0', '', '0', '', '0');
INSERT INTO `ssi_door_material` VALUES ('49', '1', '180118180145', '', '沈阳3D', '1-1061-1', '111', '60', '8', '65', null, null, '822', '3001', null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '1516896000', '2.821', null, null, null, null, null, '7', '2.745', '713', '109', '0.076', '5', '2', '7', '', '30', '', '0');

-- ----------------------------
-- Table structure for ssi_door_material_core_board
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_material_core_board`;
CREATE TABLE `ssi_door_material_core_board` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(20) DEFAULT NULL COMMENT '芯板名称',
  `middle_position` int(11) NOT NULL DEFAULT '0' COMMENT '中横位置',
  `height` int(11) NOT NULL DEFAULT '0' COMMENT '高',
  `width` int(11) NOT NULL DEFAULT '0' COMMENT '宽',
  `num` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `square` double(11,3) NOT NULL DEFAULT '0.000' COMMENT '平方数',
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=289 DEFAULT CHARSET=utf8 COMMENT='下料单芯板';

-- ----------------------------
-- Records of ssi_door_material_core_board
-- ----------------------------
INSERT INTO `ssi_door_material_core_board` VALUES ('1', '1', '中式芯板', '0', '274', '413', '4', '0.432', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('2', '1', '中式芯板', '59', '22', '80', '3', '3.223', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('3', '2', '中式芯板', '34', '2', '22', '3', '2.221', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('4', '3', '中式芯板', '0', '274', '413', '4', '0.453', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('5', '4', '芯板-1', '0', '274', '158', '2', '0.087', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('6', '6', '123', '11', '1', '1', '1', '1.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('7', '8', '123', '123', '123', '123', '123', '123.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('14', '14', '芯板-02', '0', '880', '400', '3', '0.352', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('15', '15', '芯板-02', '10', '80', '8', '2', '0.001', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('16', '15', '芯板-02', '6', '0', '0', '2', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('17', '24', '111', '0', '0', '0', '2', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('18', '25', '10', '0', '300', '10', '11', '0.003', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('19', '27', '10', '0', '100', '100', '121', '0.010', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('20', '29', '六格百叶', '0', '654', '410', '2', '0.536', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('21', '31', '平板', '0', '1734', '294', '2', '1.020', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('22', '32', '', '0', '0', '0', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('23', '33', '芯板-02', '0', '334', '234', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('24', '34', '10', '0', '98', '198', '10', '2.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('25', '35', '123123', '0', '1220', '2220', '2', '5.417', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('30', '38', '111', '0', '1123', '678', '2', '1.523', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('29', '38', '111', '0', '1123', '678', '2', '1.523', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('84', '112', '门芯-1', '0', '440', '325', '3', '0.600', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('87', '117', '', '0', '0', '459', '2', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('86', '116', '', '0', '0', '0', '2', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('35', '41', '五格百叶', '0', '980', '335', '1', '0.328', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('37', '46', '芯板-02', '849', '901', '421', '1', '0.380', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('36', '42', '五格百叶', '0', '594', '335', '1', '0.200', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('38', '46', '芯板-02', '543', '1054', '421', '1', '0.444', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('40', '48', '芯板-01', '1362', '1283', '398', '2', '1.022', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('41', '48', '芯板-01', '907', '828', '398', '2', '0.659', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('42', '49', '芯板-02', '990', '971', '774', '2', '1.504', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('43', '49', '芯板-02', '450', '431', '774', '2', '0.668', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('44', '50', '透明玻璃', '0', '943', '291', '2', '0.549', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('45', '54', '芯板-01', '0', '994', '216', '5', '1.073', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('46', '56', '测试', '0', '994', '194', '10', '2.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('47', '57', '打磨', '0', '10014', '214', '1', '2.143', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('48', '59', '门芯-2', '1191', '1071', '241', '1', '0.258', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('49', '59', '门芯-2', '1039', '966', '241', '1', '0.233', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('51', '62', '门芯-2', '1258', '1138', '249', '1', '0.283', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('52', '62', '门芯-2', '1039', '919', '249', '1', '0.229', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('58', '71', '门芯-2', '0', '437', '437', '8', '1.600', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('59', '72', '门芯-2', '0', '1171', '437', '4', '2.047', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('60', '73', '门芯-2', '0', '211', '861', '4', '0.800', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('61', '74', '门芯-2', '0', '561', '437', '8', '1.961', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('62', '77', '芯板-01', '0', '994', '94', '10', '2.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('63', '78', '门芯-1', '0', '340', '324', '4', '0.800', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('64', '79', '门芯-1', '0', '340', '321', '4', '0.800', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('65', '80', '门芯-1', '1019', '940', '324', '4', '1.220', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('66', '80', '门芯-1', '837', '758', '324', '4', '0.984', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('67', '81', '门芯-1', '0', '116', '320', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('68', '82', '门芯-1', '0', '340', '321', '3', '0.600', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('69', '83', '门芯-1', '0', '200', '246', '6', '1.200', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('70', '91', '门芯-1', '0', '940', '321', '3', '0.905', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('71', '92', '', '0', '251', '712', '3', '0.600', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('72', '93', '', '0', '14', '408', '5', '1.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('73', '93', '', '0', '14', '408', '5', '1.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('74', '94', '', '0', '462', '408', '5', '1.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('75', '95', '', '0', '161', '420', '1', '0.200', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('76', '96', '', '0', '227', '420', '3', '0.600', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('77', '97', '', '0', '507', '420', '1', '0.213', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('78', '98', '单孔透明', '0', '762', '420', '2', '0.640', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('79', '99', '', '0', '462', '419', '4', '0.800', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('80', '100', '', '0', '462', '437', '4', '0.808', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('81', '109', '门芯-2', '130', '1107', '406', '2', '0.899', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('82', '110', '门芯-2', '30', '824', '406', '2', '0.669', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('83', '111', '门芯-2', '30', '897', '405', '1', '0.363', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('88', '119', '门芯-1', '0', '712', '407', '3', '0.870', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('89', '120', '门芯-1', '0', '311', '921', '2', '0.572', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('90', '121', '门芯-1', '0', '654', '431', '4', '1.128', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('91', '122', '门芯-1', '0', '654', '321', '3', '0.630', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('92', '123', '门芯-1', '0', '654', '351', '2', '0.460', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('124', '157', '门芯-1', '0', '72', '467', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('263', '332', '芯板-02', '0', '373', '300', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('113', '147', '六格透明', '0', '279', '306', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('114', '148', '门芯-2', '0', '822', '341', '2', '0.560', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('117', '151', '1', '0', '19', '19', '1', '0.200', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('118', '153', '门芯', '10', '999', '494', '2', '0.988', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('119', '153', '门芯', '10', '999', '494', '2', '0.988', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('120', '154', '单芯板', '0', '24', '1314', '5', '1.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('121', '155', '双芯板', '0', '14', '3014', '10', '2.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('122', '155', '双芯板', '0', '14', '3014', '10', '2.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('261', '325', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('262', '331', '平板', '0', '21', '300', '2', '0.400', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('259', '323', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('260', '324', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('257', '321', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('258', '322', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('256', '320', '双新版', '0', '990', '994', '10', '9.840', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('255', '320', '双新版', '0', '990', '994', '10', '9.840', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('254', '319', '单新班', '0', '994', '94', '10', '2.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('264', '335', '平板', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('265', '336', '', '0', '0', '15', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('266', '337', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('270', '341', '', '0', '0', '0', '0', '0.000', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('283', '397', '芯板-01', '0', '440', '416', '3', '0.600', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('284', '398', '芯板-01', '0', '1764', '416', '2', '1.468', '1');
INSERT INTO `ssi_door_material_core_board` VALUES ('285', '398', '芯板-01', '0', '1764', '416', '2', '1.468', '1');

-- ----------------------------
-- Table structure for ssi_door_material_log
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_material_log`;
CREATE TABLE `ssi_door_material_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL,
  `info` varchar(1000) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ssi_door_material_log
-- ----------------------------
INSERT INTO `ssi_door_material_log` VALUES ('1', '1', '7', 'admin增加了1000元已支付金额；增加了122元优惠金额；', '1504799423');
INSERT INTO `ssi_door_material_log` VALUES ('2', '1', '10', 'admin', '1504854602');
INSERT INTO `ssi_door_material_log` VALUES ('3', '1', '10', 'admin', '1504854725');
INSERT INTO `ssi_door_material_log` VALUES ('4', '1', '11', 'admin', '1504858498');
INSERT INTO `ssi_door_material_log` VALUES ('5', '1', '12', 'admin增加了450元已支付金额；', '1505799226');
INSERT INTO `ssi_door_material_log` VALUES ('6', '58', '16', '财务测试增加了1000元已支付金额；增加了200元优惠金额；', '1505812075');
INSERT INTO `ssi_door_material_log` VALUES ('7', '58', '15', '财务测试', '1505812487');
INSERT INTO `ssi_door_material_log` VALUES ('8', '58', '17', '财务测试', '1505870199');
INSERT INTO `ssi_door_material_log` VALUES ('9', '1', '21', 'admin', '1505871875');
INSERT INTO `ssi_door_material_log` VALUES ('10', '1', '20', 'admin', '1505871879');
INSERT INTO `ssi_door_material_log` VALUES ('11', '1', '19', 'admin', '1505871884');
INSERT INTO `ssi_door_material_log` VALUES ('12', '1', '18', 'admin', '1505871890');
INSERT INTO `ssi_door_material_log` VALUES ('13', '1', '23', 'admin', '1505881581');
INSERT INTO `ssi_door_material_log` VALUES ('14', '1', '24', 'admin', '1505887332');
INSERT INTO `ssi_door_material_log` VALUES ('15', '58', '22', '财务测试增加了300元已支付金额；增加了100元优惠金额；', '1505891429');
INSERT INTO `ssi_door_material_log` VALUES ('16', '1', '22', 'admin增加了394元已支付金额；减少了-394元优惠金额；', '1505891637');
INSERT INTO `ssi_door_material_log` VALUES ('17', '1', '22', 'admin', '1505891792');
INSERT INTO `ssi_door_material_log` VALUES ('18', '1', '22', 'admin减少了594元已支付金额；', '1505954211');
INSERT INTO `ssi_door_material_log` VALUES ('19', '58', '31', '财务测试增加了651元已支付金额；', '1506412434');
INSERT INTO `ssi_door_material_log` VALUES ('20', '58', '31', '财务测试减少了600元已支付金额；', '1507529831');
INSERT INTO `ssi_door_material_log` VALUES ('21', '58', '31', '财务测试增加了49元已支付金额；', '1507529843');
INSERT INTO `ssi_door_material_log` VALUES ('22', '58', '31', '财务测试增加了551元已支付金额；', '1507529887');
INSERT INTO `ssi_door_material_log` VALUES ('23', '1', '31', 'admin减少了20元已支付金额；', '1507691307');
INSERT INTO `ssi_door_material_log` VALUES ('24', '1', '31', 'admin增加了31元已支付金额；', '1511066280');

-- ----------------------------
-- Table structure for ssi_door_material_product
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_material_product`;
CREATE TABLE `ssi_door_material_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(12) NOT NULL DEFAULT '0' COMMENT 'sn码',
  `name` varchar(50) DEFAULT NULL,
  `door_type` varchar(25) DEFAULT NULL COMMENT '门型',
  `door_board` varchar(255) DEFAULT NULL COMMENT '芯板',
  `door_board_type` int(11) NOT NULL DEFAULT '0' COMMENT '芯板类型',
  `height` int(11) DEFAULT '0' COMMENT '高',
  `width` int(11) NOT NULL DEFAULT '0' COMMENT '宽',
  `thickness` int(11) NOT NULL DEFAULT '0' COMMENT '厚度',
  `color` varchar(25) DEFAULT NULL COMMENT '表面颜色',
  `num` int(11) DEFAULT NULL COMMENT '数量',
  `square` double(11,3) DEFAULT '0.000' COMMENT '平方数',
  `punch` int(11) DEFAULT NULL COMMENT '打孔',
  `style` varchar(20) DEFAULT NULL COMMENT '样式',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  `is_small` int(1) NOT NULL DEFAULT '0' COMMENT '0不是小件  1是小件',
  `status` int(11) DEFAULT '1',
  `sum_square` double(11,3) NOT NULL DEFAULT '0.000' COMMENT '总平方',
  `sum_money` int(11) NOT NULL DEFAULT '0' COMMENT '总金额',
  `price` int(11) NOT NULL DEFAULT '0' COMMENT '单价',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=410 DEFAULT CHARSET=utf8 COMMENT='下料单产品';

-- ----------------------------
-- Records of ssi_door_material_product
-- ----------------------------
INSERT INTO `ssi_door_material_product` VALUES ('1', '170627032151', '门板', null, null, '0', '280', '100', '0', null, '2', '2.130', '4', '对开', '上下100', '0', '1', '0.000', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('2', '170627032151', '门板', null, null, '0', '45', '22', '0', null, '2', '2.330', '5', '对开', '上下100', '0', '1', '0.000', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('4', '693079950125', '门板', null, null, '0', '390', '274', '0', null, '2', '0.214', '2', '对开', '上下100', '0', '1', '0.000', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('5', '693079950125', '帽线', null, null, '0', '95', '1542', '0', null, '3', '0.146', '0', '0', '', '1', '1', '0.000', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('6', '170718175525', '成品', null, null, '0', '123', '11', '0', null, '2', '12.000', '2', '22', '11', '0', '1', '0.000', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('7', '170718175525', '2222', null, null, '0', '2', '2', '0', null, '1', '2.000', '2', '2', '2', '1', '1', '0.000', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('14', '170814132934', '门板', '法式', '芯板-02', '0', '1000', '880', '22', '羊脂白', '3', '0.880', '3', '对开', '2223', '0', '1', '2.640', '528', '200');
INSERT INTO `ssi_door_material_product` VALUES ('15', '170814132934', '门板', '法式', '芯板-02', '1', '800', '300', '22', '羊脂白', '2', '0.240', '2', '对开+左开1', '000', '0', '1', '0.480', '158', '330');
INSERT INTO `ssi_door_material_product` VALUES ('23', '170814132934', '123', '', '', '0', '111', '111', '11', '111', '10', '0.012', null, '11', null, '1', '1', '0.123', '136', '1111');
INSERT INTO `ssi_door_material_product` VALUES ('24', '170814132934', '111', '111', '111', '0', '1000', '500', '33', '111', '2', '0.500', null, '33', null, '0', '1', '1.000', '300', '300');
INSERT INTO `ssi_door_material_product` VALUES ('25', '170714141246', '大件', '大', '10000', '0', '1323', '1320', '12', '红色', '11', '1.746', null, '12', null, '0', '1', '19.210', '230', '12');
INSERT INTO `ssi_door_material_product` VALUES ('26', '170714141246', '小件', '', '', '0', '123', '23', '33', '红色', '10', '0.003', null, '321', null, '1', '1', '0.028', '0', '12');
INSERT INTO `ssi_door_material_product` VALUES ('27', '170908150442', '门', '中', '10', '0', '10000', '2000', '12', '红色', '121', '20.000', null, '', null, '0', '1', '2420.000', '29040', '12');
INSERT INTO `ssi_door_material_product` VALUES ('28', '170908150442', '小件1', '', '', '0', '100', '200', '15', '红色', '12', '0.020', null, '', null, '1', '1', '0.240', '3', '15');
INSERT INTO `ssi_door_material_product` VALUES ('29', '170908150853', '门板', '法式', '六格百叶', '0', '720', '476', '22', '黄樱桃', '2', '0.343', '2', '对开', null, '0', '1', '0.685', '205', '300');
INSERT INTO `ssi_door_material_product` VALUES ('30', '170908150853', 'LMZ16-10', '', '', '0', '2200', '50', '0', '黄樱桃', '2', '0.110', null, '带柱头', null, '1', '1', '0.220', '17', '80');
INSERT INTO `ssi_door_material_product` VALUES ('31', '170908150853', '抽屉', '法式', '平板', '0', '1800', '360', '22', '黄樱桃', '2', '0.648', null, '', null, '0', '1', '1.296', '388', '300');
INSERT INTO `ssi_door_material_product` VALUES ('32', '170908150853', '六孔玻璃加工费', '', '', '0', '0', '0', '0', '黄樱桃', '2', '0.000', null, '', null, '0', '1', '0.000', '0', '30');
INSERT INTO `ssi_door_material_product` VALUES ('33', '170908150853', '门板', '法式', '芯板-02', '0', '400', '300', '0', '黄樱桃', '2', '0.120', null, '', null, '0', '1', '0.240', '72', '300');
INSERT INTO `ssi_door_material_product` VALUES ('34', '170908161352', '天美', 'ot003', '10', '0', '100', '200', '300', '法兰克', '10', '0.200', '10', '测试商品', null, '0', '1', '2.000', '10', '5');
INSERT INTO `ssi_door_material_product` VALUES ('35', '170908161352', '123123', '1231', '123123', '0', '1222', '2222', '22', '法兰克', '2', '2.715', null, '2222', null, '0', '1', '5.431', '662', '122');
INSERT INTO `ssi_door_material_product` VALUES ('38', '170627032152', '111', '111', '111', '1', '1110', '666', '11', '金丝樱桃', '2', '0.739', null, '123', null, '0', '1', '1.478', '295', '200');
INSERT INTO `ssi_door_material_product` VALUES ('116', '170919165540', '门板', 'XS17-7', '', '0', '550', '475', '20', null, '2', '0.261', null, '对开', null, '0', '1', '0.522', '183', '350');
INSERT INTO `ssi_door_material_product` VALUES ('112', '170919162312', '门板', '英式', '门芯-1', '0', '546', '431', '22', '海之蓝', '3', '0.235', null, '对开', null, '0', '1', '0.705', '183', '260');
INSERT INTO `ssi_door_material_product` VALUES ('41', '170919140025', '门板', '英式', '五格百叶', '0', '1086', '441', '22', '云橡', '1', '0.479', '2', '右开', null, '0', '1', '0.479', '117', '245');
INSERT INTO `ssi_door_material_product` VALUES ('42', '170919140025', '门板', '英式', '五格百叶', '0', '700', '441', '22', '云橡', '1', '0.309', '2', '右开', null, '0', '1', '0.309', '75', '245');
INSERT INTO `ssi_door_material_product` VALUES ('43', '170919140025', '平板直边', '', '', '0', '2200', '50', '20', '云橡', '2', '0.150', null, '', null, '1', '1', '0.300', '51', '170');
INSERT INTO `ssi_door_material_product` VALUES ('44', '170919140025', '平板直边', '', '', '0', '445', '50', '20', '云橡', '1', '0.150', null, '', null, '1', '1', '0.150', '25', '170');
INSERT INTO `ssi_door_material_product` VALUES ('45', '170919140025', '平板直边', '', '', '0', '445', '61', '20', '云橡', '1', '0.150', null, '', null, '1', '1', '0.150', '25', '170');
INSERT INTO `ssi_door_material_product` VALUES ('46', '170919231747', '门板', '法式', '芯板-02', '1', '1392', '567', '22', null, '1', '0.789', null, '做开', null, '0', '1', '0.789', '299', '380');
INSERT INTO `ssi_door_material_product` VALUES ('48', '170919234656', '门板', '英式', '芯板-01', '1', '2068', '504', '22', null, '2', '1.042', null, '', null, '0', '1', '2.084', '510', '245');
INSERT INTO `ssi_door_material_product` VALUES ('49', '170920084102', '门板', '英式', '芯板-02', '1', '1000', '800', '22', null, '2', '0.800', null, '', null, '0', '1', '1.600', '384', '240');
INSERT INTO `ssi_door_material_product` VALUES ('50', '170919165839', '门板', '中式斜边', '透明玻璃', '0', '1025', '373', '22', '黒木卡其套锦绣红', '2', '0.382', null, '对开', null, '0', '1', '0.765', '210', '275');
INSERT INTO `ssi_door_material_product` VALUES ('51', '170919165839', '大弯铰链', '', '', '0', '0', '0', '0', '黒木卡其套锦绣红', '32', '0.150', null, '', null, '1', '1', '4.800', '19', '4');
INSERT INTO `ssi_door_material_product` VALUES ('52', '170919165839', '拉手', '', '', '0', '0', '0', '0', '黒木卡其套锦绣红', '10', '0.150', null, '', null, '1', '1', '1.500', '15', '10');
INSERT INTO `ssi_door_material_product` VALUES ('53', '170919165839', '平板', '', '', '0', '1200', '50', '20', '黒木卡其套锦绣红', '1', '0.150', null, '', null, '1', '1', '0.150', '25', '170');
INSERT INTO `ssi_door_material_product` VALUES ('54', '170920084308', '门板', '英式', '芯板-01', '0', '1000', '222', '22', null, '5', '0.222', null, '', null, '0', '1', '1.110', '166', '150');
INSERT INTO `ssi_door_material_product` VALUES ('55', '170920084308', '铰链', '', '', '0', '100', '100', '22', null, '2', '0.150', null, '', null, '1', '1', '0.300', '45', '150');
INSERT INTO `ssi_door_material_product` VALUES ('56', '170920094232', '测试', '测试', '测试', '0', '1000', '200', '22', null, '10', '0.200', null, '', null, '0', '1', '2.000', '480', '240');
INSERT INTO `ssi_door_material_product` VALUES ('57', '170920122054', '打磨', '打磨', '打磨', '0', '10000', '200', '22', null, '1', '2.000', null, '', null, '0', '1', '2.000', '490', '245');
INSERT INTO `ssi_door_material_product` VALUES ('58', '170920122054', '打磨', '', '', '0', '100', '200', '22', null, '1', '0.150', null, '', null, '1', '1', '0.150', '28', '190');
INSERT INTO `ssi_door_material_product` VALUES ('59', '170920090917', '门板', '法式', '门芯-2', '1', '2230', '387', '22', null, '1', '0.863', null, '', null, '0', '1', '0.863', '284', '330');
INSERT INTO `ssi_door_material_product` VALUES ('60', '170920090917', '平板', '', '', '0', '188', '797', '20', null, '2', '0.150', null, '', null, '1', '1', '0.300', '99', '330');
INSERT INTO `ssi_door_material_product` VALUES ('62', '170920090917', '门板', '法式', '门芯-2', '1', '2297', '395', '22', null, '1', '0.907', null, '', null, '0', '1', '0.907', '299', '330');
INSERT INTO `ssi_door_material_product` VALUES ('63', '170920090917', '罗马柱16-10', '', '', '0', '50', '50', '2', null, '8', '0.150', null, '', null, '1', '1', '1.200', '12', '10');
INSERT INTO `ssi_door_material_product` VALUES ('64', '170920090917', '罗马柱16-10', '', '', '0', '2385', '50', '0', null, '2', '0.150', null, '', null, '1', '1', '0.300', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('75', '170920150134', '平板', '', '', '0', '200', '1700', '20', null, '2', '0.340', null, '', null, '1', '1', '0.680', '115', '170');
INSERT INTO `ssi_door_material_product` VALUES ('71', '170920150134', '门板', '法式', '门芯-2', '0', '423', '423', '22', null, '8', '0.200', null, '对开', null, '0', '1', '1.600', '480', '300');
INSERT INTO `ssi_door_material_product` VALUES ('72', '170920150134', '门板', '法式', '门芯-2', '0', '1157', '423', '22', null, '4', '0.489', null, '对开', null, '0', '1', '1.958', '587', '300');
INSERT INTO `ssi_door_material_product` VALUES ('73', '170920150134', '抽屉', '法式', '门芯-2', '0', '197', '847', '22', null, '4', '0.200', null, '', null, '0', '1', '0.800', '240', '300');
INSERT INTO `ssi_door_material_product` VALUES ('74', '170920150134', '门板', '法式', '门芯-2', '0', '547', '423', '22', null, '8', '0.231', null, '对开', null, '0', '1', '1.851', '555', '300');
INSERT INTO `ssi_door_material_product` VALUES ('76', '170920140150', '门板', '', '', '0', '100', '10', '22', null, '10', '0.150', null, '', null, '1', '1', '1.500', '100', '182');
INSERT INTO `ssi_door_material_product` VALUES ('77', '170920140150', '门板', '英式', '芯板-01', '0', '1000', '100', '22', null, '10', '0.200', null, '', null, '0', '1', '2.000', '384', '192');
INSERT INTO `ssi_door_material_product` VALUES ('78', '170920165208', '门板', '英式', '门芯-1', '0', '446', '430', '22', null, '4', '0.200', null, '对开', null, '0', '1', '0.800', '208', '260');
INSERT INTO `ssi_door_material_product` VALUES ('79', '170920165208', '门板', '英式', '门芯-1', '0', '446', '427', '22', null, '4', '0.200', null, '对开', null, '0', '1', '0.800', '208', '260');
INSERT INTO `ssi_door_material_product` VALUES ('80', '170920165208', '门板', '英式', '门芯-1', '1', '1856', '430', '22', null, '4', '0.798', null, '对开', null, '0', '1', '3.192', '829', '260');
INSERT INTO `ssi_door_material_product` VALUES ('81', '170920165208', '抽屉', '英式', '门芯-1', '0', '222', '426', '22', null, '2', '0.200', null, '', null, '0', '1', '0.400', '104', '260');
INSERT INTO `ssi_door_material_product` VALUES ('82', '170920165208', '门板', '英式', '门芯-1', '0', '446', '427', '22', null, '3', '0.200', null, '对开+右开', null, '0', '1', '0.600', '156', '260');
INSERT INTO `ssi_door_material_product` VALUES ('83', '170920165208', '门板', '英式', '门芯-1', '0', '306', '352', '22', null, '6', '0.200', null, '对开', null, '0', '1', '1.200', '312', '260');
INSERT INTO `ssi_door_material_product` VALUES ('84', '170920165208', '平板', '', '', '0', '2130', '48', '20', null, '1', '0.150', null, '', null, '1', '1', '0.150', '0', '170');
INSERT INTO `ssi_door_material_product` VALUES ('85', '170920165208', '40厚炕沿', '', '', '0', '2230', '100', '40', null, '1', '0.223', null, '', null, '1', '1', '0.223', '0', '400');
INSERT INTO `ssi_door_material_product` VALUES ('86', '170920165208', '楣板16-4', '', '', '0', '120', '428', '0', null, '1', '0.150', null, '', null, '1', '1', '0.150', '0', '60');
INSERT INTO `ssi_door_material_product` VALUES ('87', '170920165208', '罗马柱柱体', '', '', '0', '2400', '50', '0', null, '5', '0.150', null, '', null, '1', '1', '0.750', '0', '60');
INSERT INTO `ssi_door_material_product` VALUES ('88', '170920165208', '罗马柱柱头', '', '', '0', '50', '50', '0', null, '12', '0.150', null, '', null, '1', '1', '1.800', '0', '10');
INSERT INTO `ssi_door_material_product` VALUES ('89', '170920165208', '踢脚板', '', '', '0', '90', '2400', '0', null, '1', '0.216', null, '', null, '1', '1', '0.216', '0', '65');
INSERT INTO `ssi_door_material_product` VALUES ('90', '170920165208', '顶线16-3', '', '', '0', '80', '2400', '0', null, '2', '0.192', null, '', null, '1', '1', '0.384', '0', '85');
INSERT INTO `ssi_door_material_product` VALUES ('91', '170921102819', '门板', '英式', '门芯-1', '0', '1046', '427', '22', null, '3', '0.447', null, '对开+右开', null, '0', '1', '1.341', '349', '260');
INSERT INTO `ssi_door_material_product` VALUES ('92', '170921103914', '抽屉', 'XS16-1', '', '0', '237', '698', '20', null, '3', '0.200', null, '', null, '0', '1', '0.600', '102', '170');
INSERT INTO `ssi_door_material_product` VALUES ('93', '170921103914', '门板', 'XS16-1', '', '1', '1548', '394', '20', null, '5', '0.610', null, '对开+左开', null, '0', '1', '3.050', '519', '170');
INSERT INTO `ssi_door_material_product` VALUES ('94', '170921103914', '门板', 'XS16-1', '', '0', '448', '394', '20', null, '5', '0.200', null, '对开+左开', null, '0', '1', '1.000', '170', '170');
INSERT INTO `ssi_door_material_product` VALUES ('95', '170921103914', '抽屉', 'XS16-1', '', '0', '147', '406', '20', null, '1', '0.200', null, '', null, '0', '1', '0.200', '34', '170');
INSERT INTO `ssi_door_material_product` VALUES ('96', '170921103914', '抽屉', 'XS16-1', '', '0', '213', '406', '20', null, '3', '0.200', null, '', null, '0', '1', '0.600', '102', '170');
INSERT INTO `ssi_door_material_product` VALUES ('97', '170921103914', '门板', 'XS16-1', '', '0', '493', '406', '20', null, '1', '0.200', null, '左开', null, '0', '1', '0.200', '34', '170');
INSERT INTO `ssi_door_material_product` VALUES ('98', '170921103914', '门板', 'XS16-1', '单孔透明', '0', '748', '406', '20', null, '2', '0.304', null, '', null, '0', '1', '0.608', '103', '170');
INSERT INTO `ssi_door_material_product` VALUES ('99', '170921103914', '门板', 'XS16-1', '', '0', '448', '405', '20', null, '4', '0.200', null, '对开', null, '0', '1', '0.800', '136', '170');
INSERT INTO `ssi_door_material_product` VALUES ('100', '170921103914', '门板', 'XS16-1', '', '0', '448', '423', '20', null, '4', '0.200', null, '对开', null, '0', '1', '0.800', '136', '170');
INSERT INTO `ssi_door_material_product` VALUES ('101', '170921103914', '平板', '', '', '0', '2101', '77', '20', null, '2', '0.162', null, '', null, '1', '1', '0.324', '0', '170');
INSERT INTO `ssi_door_material_product` VALUES ('102', '170921103914', '平板', '', '', '0', '400', '702', '20', null, '1', '0.281', null, '', null, '1', '1', '0.281', '0', '170');
INSERT INTO `ssi_door_material_product` VALUES ('103', '170921103914', '平板', '', '', '0', '1978', '97', '20', null, '1', '0.192', null, '', null, '1', '1', '0.192', '0', '170');
INSERT INTO `ssi_door_material_product` VALUES ('104', '170921103914', '平板', '', '', '0', '406', '77', '20', null, '2', '0.150', null, '', null, '1', '1', '0.300', '0', '170');
INSERT INTO `ssi_door_material_product` VALUES ('105', '170921103914', '顶线', '', '', '0', '0', '2000', '0', null, '2', '0.150', null, '', null, '1', '1', '0.300', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('106', '170921103914', '顶线', '', '', '0', '0', '900', '0', null, '1', '0.150', null, '', null, '1', '1', '0.150', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('107', '170921103914', '顶线', '', '', '0', '0', '2300', '0', null, '1', '0.150', null, '', null, '1', '1', '0.150', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('108', '170921093617', '测试', '', '', '0', '111', '22', '22', null, '12', '0.150', null, '', null, '1', '1', '1.800', '0', '1332');
INSERT INTO `ssi_door_material_product` VALUES ('109', '170921141722', '门板', '法式', '门芯-2', '0', '1113', '412', '22', '金丝', '2', '0.459', null, '对开', null, '0', '1', '0.918', '303', '330');
INSERT INTO `ssi_door_material_product` VALUES ('110', '170921141722', '门板', '法式', '门芯-2', '0', '830', '412', '22', '金丝', '2', '0.342', null, '对开', null, '0', '1', '0.684', '226', '330');
INSERT INTO `ssi_door_material_product` VALUES ('111', '170921141722', '门板', '法式', '门芯-2', '0', '903', '411', '22', '金丝', '1', '0.371', null, '左开', null, '0', '1', '0.371', '122', '330');
INSERT INTO `ssi_door_material_product` VALUES ('118', '170921141722', '小件1', '', '', '0', '100', '100', '2', '金丝', '10', '0.150', null, '', null, '1', '1', '1.500', '0', '0');
INSERT INTO `ssi_door_material_product` VALUES ('117', '170919165540', '门板', 'XS17-7', '', '0', '1748', '475', '20', null, '2', '0.830', null, '对开', null, '0', '1', '1.660', '581', '350');
INSERT INTO `ssi_door_material_product` VALUES ('119', '170926140755', '门板', '英式', '门芯-1', '0', '698', '393', '22', null, '3', '0.274', null, '对开+右开', null, '0', '1', '0.822', '226', '275');
INSERT INTO `ssi_door_material_product` VALUES ('120', '170926140755', '门板', '英式', '门芯-1', '0', '297', '907', '22', null, '2', '0.269', null, '上翻', null, '0', '1', '0.538', '148', '275');
INSERT INTO `ssi_door_material_product` VALUES ('121', '170926140755', '门板', '英式', '门芯-1', '0', '640', '417', '22', null, '4', '0.267', null, '对开', null, '0', '1', '1.068', '294', '275');
INSERT INTO `ssi_door_material_product` VALUES ('122', '170926140755', '门板', '英式', '门芯-1', '0', '640', '307', '22', null, '3', '0.200', null, '对开+右开', null, '0', '1', '0.600', '165', '275');
INSERT INTO `ssi_door_material_product` VALUES ('123', '170926140755', '门板', '英式', '门芯-1', '0', '640', '337', '22', null, '2', '0.216', null, '对开', null, '0', '1', '0.432', '119', '275');
INSERT INTO `ssi_door_material_product` VALUES ('124', '170926140755', '罗马柱17-3', '', '', '0', '700', '50', '0', null, '2', '0.150', null, '', null, '1', '1', '0.300', '50', '25');
INSERT INTO `ssi_door_material_product` VALUES ('125', '170926140755', '罗马柱17-3', '', '', '0', '640', '50', '0', null, '6', '0.150', null, '', null, '1', '1', '0.900', '150', '25');
INSERT INTO `ssi_door_material_product` VALUES ('126', '170926140755', '顶线17-2', '', '', '0', '85', '2400', '0', null, '2', '0.204', null, '', null, '1', '1', '0.408', '170', '85');
INSERT INTO `ssi_door_material_product` VALUES ('329', '171230122649', '罗马柱', '', '', '0', '100', '0', '0', '黄色', '10', '0.000', null, '', null, '1', '1', '0.000', '10000', '10');
INSERT INTO `ssi_door_material_product` VALUES ('330', '171230122649', '罗马柱', '', '', '0', '0', '0', '0', '黄色', '12', '0.000', null, '', null, '1', '1', '0.000', '144', '12');
INSERT INTO `ssi_door_material_product` VALUES ('159', '171119172835', 'ASD', '', '', '0', '1', '1', '1', null, '1', '0.150', null, '1', null, '1', '1', '0.150', '0', '1');
INSERT INTO `ssi_door_material_product` VALUES ('147', '171017172353', '门板', 'XS16-1', '', '0', '385', '412', '22', null, '2', '0.200', null, '对开', null, '0', '1', '0.400', '120', '300');
INSERT INTO `ssi_door_material_product` VALUES ('148', '171017172353', '门板', '英式', '门芯-1', '0', '928', '447', '22', null, '2', '0.415', null, '对开', null, '0', '1', '0.830', '249', '300');
INSERT INTO `ssi_door_material_product` VALUES ('151', '171017171924', '抽屉', '1', '1', '0', '5', '5', '35', null, '1', '0.200', null, '', null, '0', '1', '0.200', '2', '10');
INSERT INTO `ssi_door_material_product` VALUES ('152', '171017171924', '平板单扇', '', '', '0', '5', '5', '2', null, '1', '0.150', null, '', null, '1', '1', '0.150', '0', '10');
INSERT INTO `ssi_door_material_product` VALUES ('153', '170921141722', '门板', '法式', '门芯', '1', '1000', '500', '2', '金丝', '2', '0.500', null, '', null, '0', '1', '1.000', '1', '1');
INSERT INTO `ssi_door_material_product` VALUES ('154', '171017171924', '单芯板', '法式', '单芯板', '0', '10', '1300', '2', null, '5', '0.200', null, '', null, '0', '1', '1.000', '1002', '1002');
INSERT INTO `ssi_door_material_product` VALUES ('155', '171017171924', '双芯板', '法式', '双芯板', '1', '100', '3000', '5', null, '10', '0.300', null, '', null, '0', '1', '3.000', '3069', '1023');
INSERT INTO `ssi_door_material_product` VALUES ('157', '171017172353', '抽屉', '英式', '门芯-1', '0', '178', '573', '22', null, '2', '0.200', null, '', null, '0', '1', '0.400', '104', '260');
INSERT INTO `ssi_door_material_product` VALUES ('158', '171017172353', '罗马柱17-2', '', '', '0', '2198', '50', '0', null, '5', '0.150', null, '', null, '1', '1', '0.750', '0', '35');
INSERT INTO `ssi_door_material_product` VALUES ('164', '171210171732', '111', '', '无', '2', '1111', '1111', '0', null, '11', '1.234', null, '', null, '0', '1', '13.574', '149', '11');
INSERT INTO `ssi_door_material_product` VALUES ('321', '171230122649', '抽屉', '抽屉', '', '2', '1000', '100', '0', '黄色', '1', '0.150', null, '', null, '0', '1', '0.150', '0', '1');
INSERT INTO `ssi_door_material_product` VALUES ('322', '171230122649', '抽屉', '抽屉', '', '2', '1000', '2000', '0', '黄色', '10', '2.000', null, '', null, '0', '1', '20.000', '200', '10');
INSERT INTO `ssi_door_material_product` VALUES ('323', '171230122649', '玻璃', '玻璃', '', '3', '1000', '100', '0', '黄色', '10', '0.100', null, '', null, '0', '1', '1.000', '10', '10');
INSERT INTO `ssi_door_material_product` VALUES ('324', '171230122649', '包覆', '包覆', '', '4', '0', '0', '0', '黄色', '100', '0.000', null, '', null, '0', '1', '0.000', '100', '1');
INSERT INTO `ssi_door_material_product` VALUES ('325', '171230122649', '吸塑', '包覆', '', '5', '0', '0', '0', '黄色', '10', '0.000', null, '', null, '0', '1', '0.000', '10', '1');
INSERT INTO `ssi_door_material_product` VALUES ('326', '171230122649', '罗马柱', '', '', '0', '1000', '1000', '10', '黄色', '10', '1.000', null, '10', null, '1', '1', '10.000', '100', '10');
INSERT INTO `ssi_door_material_product` VALUES ('327', '171230122649', '罗马柱', '', '', '4', '0', '0', '0', '黄色', '10', '0.000', null, '', null, '1', '1', '0.000', '100', '10');
INSERT INTO `ssi_door_material_product` VALUES ('328', '171230122649', '罗马柱', '', '', '0', '0', '0', '0', '黄色', '10', '0.000', null, '', null, '1', '1', '0.000', '100', '10');
INSERT INTO `ssi_door_material_product` VALUES ('319', '171230122649', '单新班', '单新班', '单新班', '0', '1000', '100', '10', '黄色', '10', '0.200', null, '11', null, '0', '1', '2.000', '20', '10');
INSERT INTO `ssi_door_material_product` VALUES ('320', '171230122649', '双新版', '双新版', '双新版', '1', '1000', '1000', '10', '黄色', '10', '1.000', null, '12', null, '0', '1', '10.000', '100', '10');
INSERT INTO `ssi_door_material_product` VALUES ('331', '180104095225', '连体上抽屉', '法式', '平板', '0', '167', '446', '22', null, '2', '0.200', null, '', null, '0', '1', '0.400', '152', '380');
INSERT INTO `ssi_door_material_product` VALUES ('332', '180104095225', '连体下门板', '法式', '芯板-02', '0', '519', '446', '0', null, '2', '0.231', '2', '总高687对开', null, '0', '1', '0.462', '176', '380');
INSERT INTO `ssi_door_material_product` VALUES ('333', '180104095225', '平板铣门边', '', '', '0', '1900', '48', '18', null, '1', '0.091', null, '', null, '1', '1', '0.091', '25', '270');
INSERT INTO `ssi_door_material_product` VALUES ('334', '180104095225', '顶线17-1', '', '', '0', '70', '0', '0', null, '1', '0.000', null, '', null, '1', '1', '0.000', '3500', '50');
INSERT INTO `ssi_door_material_product` VALUES ('335', '180117104305', '连体上抽屉', '法式', '平板', '2', '100', '10000', '0', null, '10', '1.000', null, '', null, '0', '1', '10.000', '15', '1');
INSERT INTO `ssi_door_material_product` VALUES ('336', '180117104305', '抽屉', '法式', '', '2', '1000', '1', '0', null, '10', '0.200', null, '', null, '0', '1', '2.000', '2', '1');
INSERT INTO `ssi_door_material_product` VALUES ('337', '180117104305', '抽屉  ', '抽屉 ', '', '2', '111', '111', '0', null, '1', '0.150', null, '', null, '0', '1', '0.150', '0', '1');
INSERT INTO `ssi_door_material_product` VALUES ('341', '180117104305', '抽屉', '法式', '', '2', '1000', '1', '0', null, '10', '0.150', null, '', null, '0', '1', '1.500', '3', '2');
INSERT INTO `ssi_door_material_product` VALUES ('404', '180118180145', '平板直边', '', '', '0', '1905', '40', '20', null, '1', '0.076', null, '00000', null, '1', '1', '0.076', '13', '170');
INSERT INTO `ssi_door_material_product` VALUES ('403', '180118180145', '楣板17-2', '', '', '0', '1200', '0', '0', null, '1', '0.000', null, '', null, '1', '1', '0.000', '96', '80');
INSERT INTO `ssi_door_material_product` VALUES ('397', '180118180145', '门板', '英式', '六孔玻璃', '0', '546', '522', '22', '白胡桃', '3', '0.285', null, '对开+左开', null, '0', '1', '0.855', '222', '260');
INSERT INTO `ssi_door_material_product` VALUES ('398', '180118180145', '门板', '英式', '芯板-01', '1', '1810', '522', '22', '白胡桃', '2', '0.945', null, '对开', null, '0', '1', '1.890', '491', '260');

-- ----------------------------
-- Table structure for ssi_door_material_step
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_material_step`;
CREATE TABLE `ssi_door_material_step` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL DEFAULT '0' COMMENT '下料单id',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '流程id',
  `needtime` int(11) NOT NULL DEFAULT '0' COMMENT '流程完成的指定时长（天）',
  `sid` int(11) NOT NULL DEFAULT '0' COMMENT '完成扫描的扫码枪id',
  `stime` int(11) NOT NULL DEFAULT '0' COMMENT '完成扫描的扫码时间',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0未完成1已完成2超时3超时已完成',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=utf8 COMMENT='流程表';

-- ----------------------------
-- Records of ssi_door_material_step
-- ----------------------------
INSERT INTO `ssi_door_material_step` VALUES ('7', '1', '3', '1', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('8', '1', '4', '1', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('9', '1', '11', '1', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('10', '1', '12', '1', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('11', '1', '13', '2', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('12', '1', '14', '2', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('13', '1', '15', '2', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('14', '1', '16', '2', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('15', '1', '17', '2', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('16', '1', '18', '3', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('17', '1', '19', '4', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('18', '1', '20', '5', '0', '1499626800', '1');
INSERT INTO `ssi_door_material_step` VALUES ('19', '2', '3', '1', '8', '1499823439', '1');
INSERT INTO `ssi_door_material_step` VALUES ('20', '2', '4', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('21', '2', '5', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('22', '2', '6', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('23', '2', '7', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('24', '2', '8', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('25', '2', '9', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('26', '2', '10', '2', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('27', '2', '11', '3', '4', '1500824424', '3');
INSERT INTO `ssi_door_material_step` VALUES ('28', '2', '12', '4', '7', '1500868224', '3');
INSERT INTO `ssi_door_material_step` VALUES ('29', '2', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('30', '2', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('31', '2', '15', '7', '7', '1500868224', '3');
INSERT INTO `ssi_door_material_step` VALUES ('32', '2', '16', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('33', '2', '17', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('34', '2', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('35', '2', '19', '11', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('36', '2', '20', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('37', '4', '3', '1', '8', '1502637974', '3');
INSERT INTO `ssi_door_material_step` VALUES ('38', '4', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('39', '4', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('40', '4', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('41', '4', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('42', '4', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('43', '4', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('44', '4', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('45', '4', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('46', '4', '12', '5', '7', '1500882715', '1');
INSERT INTO `ssi_door_material_step` VALUES ('47', '4', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('48', '4', '15', '10', '7', '1500882715', '1');
INSERT INTO `ssi_door_material_step` VALUES ('49', '4', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('50', '4', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('51', '4', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('52', '4', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('53', '4', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('165', '7', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('166', '7', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('167', '7', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('168', '7', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('169', '7', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('170', '7', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('171', '7', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('172', '7', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('173', '7', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('174', '7', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('175', '7', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('176', '7', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('177', '7', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('178', '7', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('179', '7', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('180', '7', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('181', '7', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('182', '7', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('183', '10', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('184', '10', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('185', '10', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('186', '10', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('187', '10', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('188', '10', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('189', '10', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('190', '10', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('191', '10', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('192', '10', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('193', '10', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('194', '10', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('195', '10', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('196', '10', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('197', '10', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('198', '10', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('199', '10', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('200', '10', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('201', '11', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('202', '11', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('203', '11', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('204', '11', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('205', '11', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('206', '11', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('207', '11', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('208', '11', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('209', '11', '11', '4', '4', '1505792702', '3');
INSERT INTO `ssi_door_material_step` VALUES ('210', '11', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('211', '11', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('212', '11', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('213', '11', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('214', '11', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('215', '11', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('216', '11', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('217', '11', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('218', '11', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('219', '12', '11', '2', '4', '1505813253', '1');
INSERT INTO `ssi_door_material_step` VALUES ('220', '12', '14', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('221', '12', '17', '5', '10', '1505813253', '1');
INSERT INTO `ssi_door_material_step` VALUES ('222', '12', '20', '6', '11', '1505813253', '1');
INSERT INTO `ssi_door_material_step` VALUES ('223', '15', '3', '1', '7', '1505813577', '1');
INSERT INTO `ssi_door_material_step` VALUES ('224', '15', '4', '3', '7', '1505813577', '1');
INSERT INTO `ssi_door_material_step` VALUES ('225', '15', '5', '3', '7', '1505813577', '1');
INSERT INTO `ssi_door_material_step` VALUES ('226', '15', '6', '3', '7', '1505813577', '1');
INSERT INTO `ssi_door_material_step` VALUES ('227', '15', '7', '3', '8', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('228', '15', '8', '3', '8', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('229', '15', '9', '3', '8', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('230', '15', '10', '3', '8', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('231', '15', '11', '2', '8', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('232', '15', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('233', '15', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('234', '15', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('235', '15', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('236', '15', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('237', '15', '17', '14', '10', '1505813577', '1');
INSERT INTO `ssi_door_material_step` VALUES ('238', '15', '18', '15', '11', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('239', '15', '19', '15', '11', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('240', '15', '20', '15', '11', '1505813637', '1');
INSERT INTO `ssi_door_material_step` VALUES ('241', '16', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('242', '16', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('243', '16', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('244', '16', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('245', '16', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('246', '16', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('247', '16', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('248', '16', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('249', '16', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('250', '16', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('251', '16', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('252', '16', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('253', '16', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('254', '16', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('255', '16', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('256', '16', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('257', '16', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('258', '16', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('259', '17', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('260', '17', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('261', '17', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('262', '17', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('263', '17', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('264', '17', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('265', '17', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('266', '17', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('267', '17', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('268', '17', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('269', '17', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('270', '17', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('271', '17', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('272', '21', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('273', '21', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('274', '21', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('275', '21', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('276', '21', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('277', '21', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('278', '21', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('279', '21', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('280', '21', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('281', '21', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('282', '21', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('283', '21', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('284', '21', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('285', '21', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('286', '21', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('287', '21', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('288', '21', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('289', '21', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('290', '20', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('291', '20', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('292', '20', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('293', '20', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('294', '20', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('295', '20', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('296', '20', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('297', '20', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('298', '20', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('299', '20', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('300', '20', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('301', '20', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('302', '20', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('303', '20', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('304', '20', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('305', '20', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('306', '20', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('307', '20', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('308', '19', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('309', '19', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('310', '19', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('311', '19', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('312', '19', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('313', '19', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('314', '19', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('315', '19', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('316', '19', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('317', '19', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('318', '19', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('319', '19', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('320', '19', '15', '10', '15', '1505896850', '3');
INSERT INTO `ssi_door_material_step` VALUES ('321', '19', '16', '12', '9', '1505961588', '3');
INSERT INTO `ssi_door_material_step` VALUES ('322', '19', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('323', '19', '18', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('324', '19', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('325', '19', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('326', '18', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('327', '18', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('328', '18', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('329', '18', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('330', '18', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('331', '18', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('332', '18', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('333', '18', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('334', '18', '11', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('335', '18', '12', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('336', '18', '13', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('337', '18', '14', '9', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('338', '18', '15', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('339', '18', '16', '12', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('340', '18', '17', '14', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('341', '18', '18', '15', '41', '1505897288', '1');
INSERT INTO `ssi_door_material_step` VALUES ('342', '18', '19', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('343', '18', '20', '15', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('344', '23', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('345', '23', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('346', '23', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('347', '23', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('348', '23', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('349', '23', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('350', '23', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('351', '23', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('352', '23', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('353', '23', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('354', '23', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('355', '23', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('356', '23', '15', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('357', '23', '16', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('358', '23', '17', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('359', '23', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('360', '23', '19', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('361', '23', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('362', '23', '26', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('363', '24', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('364', '24', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('365', '24', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('366', '24', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('367', '24', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('368', '24', '8', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('369', '24', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('370', '24', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('371', '24', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('372', '24', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('373', '24', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('374', '24', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('375', '24', '15', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('376', '24', '16', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('377', '24', '17', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('378', '24', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('379', '24', '19', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('380', '24', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('381', '24', '26', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('382', '24', '27', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('383', '24', '28', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('384', '24', '21', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('385', '24', '22', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('386', '24', '23', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('387', '24', '24', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('388', '24', '25', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('389', '22', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('390', '22', '4', '3', '11', '1505972688', '1');
INSERT INTO `ssi_door_material_step` VALUES ('391', '22', '6', '3', '13', '1505972628', '1');
INSERT INTO `ssi_door_material_step` VALUES ('392', '22', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('393', '22', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('394', '22', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('395', '22', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('396', '22', '14', '6', '19', '1505973108', '1');
INSERT INTO `ssi_door_material_step` VALUES ('397', '22', '15', '6', '17', '1505974008', '1');
INSERT INTO `ssi_door_material_step` VALUES ('398', '22', '16', '7', '10', '1505974608', '1');
INSERT INTO `ssi_door_material_step` VALUES ('399', '22', '17', '8', '31', '1505960397', '1');
INSERT INTO `ssi_door_material_step` VALUES ('400', '22', '18', '10', '31', '1505960217', '1');
INSERT INTO `ssi_door_material_step` VALUES ('401', '22', '19', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('402', '22', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('403', '22', '26', '7', '21', '1505973316', '1');
INSERT INTO `ssi_door_material_step` VALUES ('404', '22', '28', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('461', '45', '16', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('460', '45', '15', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('459', '45', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('458', '45', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('457', '45', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('456', '45', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('455', '45', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('454', '45', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('453', '45', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('452', '45', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('451', '45', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('450', '31', '29', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('449', '31', '26', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('448', '31', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('447', '31', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('446', '31', '16', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('445', '31', '15', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('444', '31', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('443', '31', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('442', '31', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('441', '31', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('440', '31', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('439', '31', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('462', '45', '17', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('463', '45', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('464', '45', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('465', '45', '26', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('466', '44', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('467', '44', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('468', '44', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('469', '44', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('470', '44', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('471', '44', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('472', '44', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('473', '44', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('474', '44', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('475', '44', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('476', '44', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('477', '44', '15', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('478', '44', '16', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('479', '44', '17', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('480', '44', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('481', '44', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('482', '44', '26', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('483', '44', '29', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('484', '44', '31', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('485', '44', '30', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('486', '44', '32', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('487', '44', '33', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('488', '44', '34', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('489', '47', '3', '1', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('490', '47', '4', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('491', '47', '5', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('492', '47', '6', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('493', '47', '7', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('494', '47', '9', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('495', '47', '10', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('496', '47', '11', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('497', '47', '12', '4', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('498', '47', '13', '5', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('499', '47', '14', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('500', '47', '15', '6', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('501', '47', '16', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('502', '47', '17', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('503', '47', '18', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('504', '47', '20', '10', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('505', '47', '26', '7', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('506', '47', '29', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('507', '47', '31', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('508', '47', '30', '8', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('509', '47', '32', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('510', '47', '33', '3', '0', '0', '0');
INSERT INTO `ssi_door_material_step` VALUES ('511', '47', '34', '3', '0', '0', '0');

-- ----------------------------
-- Table structure for ssi_door_materialp
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_materialp`;
CREATE TABLE `ssi_door_materialp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL,
  `sn` int(11) DEFAULT NULL,
  `money` int(11) DEFAULT '0' COMMENT '订单总金额',
  `status` int(11) DEFAULT '0' COMMENT '0删除1正常',
  `starttime` int(11) DEFAULT '0' COMMENT '开始时间',
  `none` varchar(225) DEFAULT NULL,
  `sum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT='下料单';

-- ----------------------------
-- Records of ssi_door_materialp
-- ----------------------------
INSERT INTO `ssi_door_materialp` VALUES ('23', '板厂1', '2147483647', '0', '1', '0', '板厂做的完美', '1');
INSERT INTO `ssi_door_materialp` VALUES ('27', '86a375aacb17606c185d', '1520419170', '127', '1', '1520419170', '1', '3');
INSERT INTO `ssi_door_materialp` VALUES ('31', '111', '111', '111', '0', '1520476998', '111', '111');
INSERT INTO `ssi_door_materialp` VALUES ('29', '12', '12', '12', '0', '1520472367', '0', '12');
INSERT INTO `ssi_door_materialp` VALUES ('32', '222', '222', '222', '1', '1520477049', '222', '222');
INSERT INTO `ssi_door_materialp` VALUES ('39', '111', '11', '11', '0', '1520495653', '11', '11');
INSERT INTO `ssi_door_materialp` VALUES ('40', '888', '888', '888', '1', '1520495671', '888', '88');

-- ----------------------------
-- Table structure for ssi_door_platesa
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_platesa`;
CREATE TABLE `ssi_door_platesa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `sn` varchar(20) DEFAULT NULL,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '下料单标题',
  `company` varchar(255) DEFAULT NULL COMMENT '订货单位',
  `number` varchar(220) NOT NULL DEFAULT '' COMMENT '编号',
  `style` varchar(255) DEFAULT NULL COMMENT '造型',
  `frame` int(11) DEFAULT NULL COMMENT '边框',
  `deep` int(11) DEFAULT NULL COMMENT '槽深',
  `middle` int(11) DEFAULT NULL COMMENT '中横',
  `color` varchar(50) DEFAULT NULL COMMENT '颜色',
  `create_user` varchar(20) DEFAULT NULL COMMENT '制单人',
  `money` int(11) NOT NULL DEFAULT '0' COMMENT '金额',
  `packing_info` varchar(50) DEFAULT NULL COMMENT '包装时注明',
  `core_board_finish_time` int(11) DEFAULT NULL COMMENT '芯板单完成日期',
  `small_items_finsh_time` int(11) DEFAULT NULL COMMENT '小件完成日期',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0删除1正常2流程未定义',
  `paynum` int(11) NOT NULL DEFAULT '0' COMMENT '已支付金额',
  `discountnum` int(11) NOT NULL DEFAULT '0' COMMENT '优惠金额',
  `arrearnum` int(11) NOT NULL DEFAULT '0' COMMENT '欠款金额',
  `arrears` int(11) NOT NULL DEFAULT '0' COMMENT '0未审核、1无欠款通过、2有欠款审核通过',
  `sstatus` int(3) NOT NULL DEFAULT '0' COMMENT '0未开始1已开始未完成2已完成',
  `tstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0未超时1已超时',
  `nstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0正常1加急',
  `starttime` int(11) NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endtime` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
  `logistics_number` varchar(50) NOT NULL DEFAULT '' COMMENT '货运单号',
  `logistics_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '收货人电话',
  `logistics_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '件数',
  `memberid` int(11) NOT NULL DEFAULT '0' COMMENT '关联用户id',
  `saler_id` int(10) NOT NULL,
  `accept_time` int(11) NOT NULL DEFAULT '0' COMMENT '接单日期',
  `square` double NOT NULL DEFAULT '0' COMMENT '总平方数',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COMMENT='下料单';

-- ----------------------------
-- Records of ssi_door_platesa
-- ----------------------------
INSERT INTO `ssi_door_platesa` VALUES ('129', '1', '180315175217', '', null, '', null, null, null, null, null, null, '0', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0');
INSERT INTO `ssi_door_platesa` VALUES ('128', '1', '180315174503', '', null, '', null, null, null, null, 'hg', '大Boss', '0', null, null, null, '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '4', '2', '0', '0');
INSERT INTO `ssi_door_platesa` VALUES ('127', '1', '180315174104', '', null, '', null, null, null, null, null, null, '0', null, null, null, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '4', '0', '0', '0');
INSERT INTO `ssi_door_platesa` VALUES ('126', '1', '180315144952', '', null, '', null, null, null, null, '45', '大Boss', '0', null, null, null, '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '4', '1', '0', '0');
INSERT INTO `ssi_door_platesa` VALUES ('125', '1', '180315144936', '', '家里', '1', '板子', null, null, null, null, '大Boss', '108968', '好看点', null, null, '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '10', '4', '0', '0', '0');

-- ----------------------------
-- Table structure for ssi_door_platesa_core_board
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_platesa_core_board`;
CREATE TABLE `ssi_door_platesa_core_board` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(20) DEFAULT NULL COMMENT '芯板名称',
  `middle_position` int(11) DEFAULT NULL COMMENT '中横位置',
  `height` int(11) DEFAULT NULL COMMENT '高',
  `width` varchar(255) DEFAULT NULL COMMENT '宽',
  `num` int(11) DEFAULT NULL COMMENT '数量',
  `square` float(11,3) DEFAULT NULL COMMENT '平方数',
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='下料单芯板';

-- ----------------------------
-- Records of ssi_door_platesa_core_board
-- ----------------------------
INSERT INTO `ssi_door_platesa_core_board` VALUES ('9', '1', '中式芯板', '0', '274', '413', '4', '0.432', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('10', '1', '中式芯板', '59', '22', '80', '3', '3.223', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('11', '2', '中式芯板', '34', '2', '22', '3', '2.221', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('12', '3', '中式芯板', '0', '274', '413', '4', '0.453', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('13', '4', '芯板-1', '0', '274', '158', '2', '0.087', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('14', '6', '123', '11', '1', '1', '1', '1.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('15', '8', '123', '123', '123', '123', '123', '123.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('16', '11', '门板', '0', '0', '0.2', '100', '300.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('18', '29', '1', null, '15', '15', '111', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('19', '30', '2', null, '16', '16', '222', '0.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('20', '31', '11', null, '14', '14', '111', '22.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('21', '32', '666', null, '14', '14', '444', '88.800', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('22', '33', '11111', null, '14', '14', '1111', '222.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('23', '34', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('24', '35', '13', null, '14', '14', '13', '2.600', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('25', '36', '14', null, '14', '14', '14', '2.800', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('26', '37', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('27', '38', '44', null, '14', '14', '44', '8.800', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('28', '39', '55', null, '14', '14', '5', '1.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('29', '40', '66', null, '14', '14', '66', '13.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('30', '41', '333', null, '14', '14', '555', '111.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('31', '42', '2', null, '14', '14', '2', '0.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('32', '43', '测试', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('33', '44', '66', null, '14', '14', '66', '13.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('34', '45', '55', null, '14', '14', '55', '11.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('35', '46', '33', null, '14', '14', '33', '6.600', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('36', '47', '55', null, '14', '14', '55778', '11.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('37', '48', '22', null, '14', '14', '22', '4.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('38', '49', '55', null, '14', '14', '55', '11.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('39', '50', '44', null, '14', '14', '44', '8.800', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('40', '51', '55', null, '14', '14', '55', '11.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('41', '52', '66', null, '14', '14', '66', '13.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('42', '53', '77', null, '14', '14', '77', '15.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('43', '54', '88', null, '14', '14', '8', '1.600', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('44', '55', '', null, '1137', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('45', '56', '32', null, '110045', '14', '33', '50.853', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('46', '57', '23', null, '1919', '14', '15', '3.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('47', '58', '测试1', null, '1014', '14', '50', '10.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('48', '59', '测试1', null, '5023', '14', '20', '4.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('49', '60', '规格', null, '17', '14', '2', '0.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('50', '61', '6', null, '114', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('51', '62', '11', null, '26', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('52', '63', '11', null, '25', '14', '11', '2.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('53', '64', '11', null, '25', '14', '11', '2.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('54', '65', '1', null, '15', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('55', '66', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('56', '67', '11', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('57', '68', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('58', '69', '11', null, '14', '14', '33', '6.600', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('59', '70', '44', null, '14', '14', '66', '13.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('60', '71', '11', null, '14', '14', '33', '6.600', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('61', '72', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('62', '73', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('63', '74', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('64', '75', '1c', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('65', '76', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('66', '77', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('67', '78', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('68', '79', '11', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('69', '80', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('70', '81', '11', null, '14', '14', '11', '2.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('71', '82', '12', null, '14', '14', '121', '24.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('72', '83', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('73', '84', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('74', '85', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('75', '86', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('76', '87', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('77', '88', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('78', '89', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('79', '90', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('80', '91', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('81', '92', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('82', '93', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('83', '94', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('84', '95', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('85', '96', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('86', '97', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('87', '98', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('88', '99', '1', null, '14', '14', '1', '0.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('89', '100', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('90', '101', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('91', '102', '12', null, '14', '14', '121', '24.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('92', '103', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('93', '104', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('94', '105', '12', null, '14', '14', '12', '2.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('95', '106', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('96', '107', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('97', '108', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('98', '109', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('99', '110', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('100', '111', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('101', '112', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('102', '113', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('103', '114', '12', null, '14', '14', '121', '24.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('104', '115', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('105', '116', '', null, '14', '14', '0', '0.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('106', '117', '121', null, '14', '14', '21', '4.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('107', '118', '111', null, '14', '14', '111', '22.200', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('108', '119', '12', null, '14', '14', '212', '42.400', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('109', '120', '12', null, '14', '14', '415', '83.000', '1');
INSERT INTO `ssi_door_platesa_core_board` VALUES ('110', '121', '22', null, '14', '14', '2', '0.400', '1');

-- ----------------------------
-- Table structure for ssi_door_platesa_product
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_platesa_product`;
CREATE TABLE `ssi_door_platesa_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(12) NOT NULL DEFAULT '0' COMMENT 'sn码',
  `name` varchar(50) DEFAULT NULL,
  `height` int(11) DEFAULT '0' COMMENT '高',
  `width` int(11) DEFAULT NULL COMMENT '宽',
  `num` int(11) DEFAULT NULL COMMENT '数量',
  `square` float(11,3) DEFAULT '0.000' COMMENT '平方数',
  `punch` int(11) DEFAULT NULL COMMENT '打孔',
  `style` varchar(20) DEFAULT NULL COMMENT '样式',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  `is_small` int(1) NOT NULL DEFAULT '0' COMMENT '0不是小件  1是小件',
  `status` int(11) DEFAULT '1',
  `door_type` varchar(255) DEFAULT NULL,
  `door_board` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `jc_name` varchar(250) NOT NULL,
  `jc_price` int(10) NOT NULL,
  `zm_name` varchar(250) NOT NULL,
  `zm_price` int(10) NOT NULL,
  `bg_name` varchar(250) NOT NULL,
  `bg_price` float NOT NULL,
  `sum_price` float NOT NULL,
  `sum_num_price` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COMMENT='下料单产品';

-- ----------------------------
-- Records of ssi_door_platesa_product
-- ----------------------------
INSERT INTO `ssi_door_platesa_product` VALUES ('16', '170627032151', '门板', '280', '100', '2', '2.130', '4', '对开', '上下100', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('17', '170627032151', '门板', '45', '22', '2', '2.330', '5', '对开', '上下100', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('18', '693079950125', '门板', '390', '274', '2', '0.214', '2', '对开', '上下100', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('19', '693079950125', '帽线', '95', '1542', '3', '0.146', '0', '0', '', '1', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('20', '170718175525', '成品', '123', '11', '2', '12.000', '2', '22', '11', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('21', '170718175525', '2222', '2', '2', '1', '2.000', '2', '2', '2', '1', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('22', '170831191641', '橱柜', '2', '2', '10', '80.000', '10', '30', '', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('23', '170901102105', '门框', '2', '1', '100', '1332.000', '200', '300', '', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('24', '170901102105', '门锁', '0', '0', '100', '300.000', '300', '中式', '', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('25', '170901102105', '小件1', '0', '0', '300', '500.000', '300', '', '', '1', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('26', '170901103709', '门', '2', '1', '100', '500.000', '200', '200', '', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('27', '170901153334', '测试商品1', '10', '5', '100', '300.000', '500', '中式', '', '0', '1', null, null, null, '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('34', '171208083453', '12', '0', null, '12', '0.000', null, '12', null, '0', '1', '1222', '121', '122', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('35', '171208083453', '13', '0', null, '13', '0.000', null, '13', null, '0', '1', '13', '1311', '13', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('36', '171208083453', '14', '0', null, '14', '0.000', null, '14', null, '0', '1', '14', '14', '14', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('38', '171208083453', '44', '0', null, '44', '0.000', null, '44', null, '0', '1', '44', '44', '44', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('39', '171208083453', '55', '0', null, '5', '0.000', null, '555', null, '0', '1', '55', '55', '55', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('40', '171208083453', '66', '0', null, '66', '0.000', null, '666', null, '0', '1', '66', '66', '66', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('41', '171209072440', '111', '0', null, '555', '0.000', null, '666', null, '0', '1', '222', '333', '444', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('42', '171209072440', '2', '0', null, '2', '0.000', null, '2', null, '0', '1', '2', '2', '2', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('43', '171209074437', '测试', '0', null, '0', '0.000', null, '测试', null, '0', '1', '测试', '测试', '测试', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('44', '171209081803', '66', '0', null, '66', '0.000', null, '66', null, '0', '1', '66', '66', '66', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('45', '171209084805', '55', '0', null, '55', '0.000', null, '55', null, '0', '1', '55', '55', '55', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('46', '171209085153', '33', '0', null, '33', '0.000', null, '33', null, '0', '1', '33', '33', '33', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('47', '171209210352', '552', '0', null, '55778', '0.000', null, '5557', null, '0', '1', '555', '551', '557', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('48', '171209211434', '22', '0', null, '22', '0.000', null, '22', null, '0', '1', '22', '22', '22', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('49', '171209232601', '55', '0', null, '55', '0.000', null, '55', null, '0', '1', '55', '55', '55', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('50', '171209234410', '44', '0', null, '44', '0.000', null, '44', null, '0', '1', '44', '44', '44', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('51', '171209234410', '55', '0', null, '55', '0.000', null, '55', null, '0', '1', '55', '55', '55', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('52', '171209234410', '66', '0', null, '66', '0.000', null, '12', null, '0', '1', '66', '66', '66', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('53', '171209234410', '77', '0', null, '77', '0.000', null, '77', null, '0', '1', '77', '77', '77', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('54', '171209234410', '88', '0', null, '8', '0.000', null, '88', null, '0', '1', '88', '88', '88', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('55', '171209234410', '5', '1123', null, '0', '0.000', null, '', null, '0', '1', '', '', '', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('56', '171209234410', '1023', '110031', null, '33', '0.000', null, '1100313', null, '0', '1', '11', '32', '01', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('57', '171210000628', '11', '1905', null, '15', '0.000', null, '1', null, '0', '1', '11', '23', '32', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('58', '171210171236', '测试', '1000', null, '50', '0.000', null, '测试1', null, '0', '1', '测试1', '测试1', '10', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('59', '171210171236', '测试1', '5009', null, '20', '0.000', null, '测试1', null, '0', '1', '测试1', '测试1', '10', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('60', '171210172810', '基材', '3', null, '2', '0.000', null, '4', null, '0', '1', '型号', '规格', '1', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('61', '171210193758', '55', '100', null, '12', '0.000', null, '', null, '0', '1', '6', '6', '7', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('62', '171210193827', '11', '12', null, '1', '0.000', null, '备注', null, '0', '1', '11', '11', '11', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('63', '171212120915', '11', '11', null, '11', '0.000', null, '11', null, '0', '1', '11', '11', '11', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('64', '171212120915', '11', '11', null, '11', '0.000', null, '', null, '0', '1', '11', '11', '11', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('67', '171212160009', null, '0', '0', '1', '0.000', null, '快点', null, '0', '1', null, '11', '家里蹲', '111', '111', '板厂1', '0', '板厂1', '0', '111', '111');
INSERT INTO `ssi_door_platesa_product` VALUES ('69', '180315113038', null, '0', '0', '33', '0.000', null, '44', null, '0', '1', null, '11', '22', '12', '12', '86a375aacb17606c185d', '86', '222', '222', '609', '20097');
INSERT INTO `ssi_door_platesa_product` VALUES ('70', '180315120902', null, '0', '0', '66', '0.000', null, '77', null, '0', '1', null, '44', '55', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '20658');
INSERT INTO `ssi_door_platesa_product` VALUES ('71', '180315121027', null, '0', '0', '33', '0.000', null, '44', null, '0', '1', null, '11', '22', '111', '111', '86a375aacb17606c185d', '86', '板厂1', '0', '186', '6138');
INSERT INTO `ssi_door_platesa_product` VALUES ('72', '180315121258', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '3756');
INSERT INTO `ssi_door_platesa_product` VALUES ('73', '180315121731', null, '0', '0', '0', '0.000', null, '', null, '0', '1', null, '', '', '', '0', '', '0', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('74', '180315121738', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '86a375aacb17606c185d', '86', '', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('75', '180315121750', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1c', '1', '111', '111', '86a375aacb17606c185d', '86', '板厂1', '0', '186', '186');
INSERT INTO `ssi_door_platesa_product` VALUES ('76', '180315121816', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '板厂1', '0', '板厂1', '0', '12', '12');
INSERT INTO `ssi_door_platesa_product` VALUES ('77', '180315121943', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '111', '111', '86a375aacb17606c185d', '86', '板厂1', '0', '186', '186');
INSERT INTO `ssi_door_platesa_product` VALUES ('78', '180315122311', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '514');
INSERT INTO `ssi_door_platesa_product` VALUES ('79', '180315122311', null, '0', '0', '0', '0.000', null, 'qq', null, '0', '1', null, '11', '22', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('80', '180315123138', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '514');
INSERT INTO `ssi_door_platesa_product` VALUES ('81', '180315123359', null, '0', '0', '11', '0.000', null, '11', null, '0', '1', null, '11', '11', '12', '12', '222', '222', '86a375aacb17606c185d', '127', '-83', '-913');
INSERT INTO `ssi_door_platesa_product` VALUES ('82', '180315123426', null, '0', '0', '121', '0.000', null, '2', null, '0', '1', null, '12', '12', '12', '12', '222', '222', '222', '222', '12', '1452');
INSERT INTO `ssi_door_platesa_product` VALUES ('83', '180315124101', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '111', '111', '86a375aacb17606c185d', '86', '板厂1', '0', '186', '186');
INSERT INTO `ssi_door_platesa_product` VALUES ('84', '180315124250', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '514');
INSERT INTO `ssi_door_platesa_product` VALUES ('85', '180315124707', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '514');
INSERT INTO `ssi_door_platesa_product` VALUES ('86', '180315124931', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '6168');
INSERT INTO `ssi_door_platesa_product` VALUES ('87', '180315124950', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '板厂1', '0', '186', '2232');
INSERT INTO `ssi_door_platesa_product` VALUES ('88', '180315125044', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '3756');
INSERT INTO `ssi_door_platesa_product` VALUES ('89', '180315125147', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '3756');
INSERT INTO `ssi_door_platesa_product` VALUES ('90', '180315125234', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '222', '222', '408', '4896');
INSERT INTO `ssi_door_platesa_product` VALUES ('91', '180315125442', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', 'q', '12', '12', '板厂1', '0', '86a375aacb17606c185d', '127', '139', '139');
INSERT INTO `ssi_door_platesa_product` VALUES ('92', '180315134428', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '3756');
INSERT INTO `ssi_door_platesa_product` VALUES ('93', '180315125718', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '313');
INSERT INTO `ssi_door_platesa_product` VALUES ('94', '180315135053', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '6168');
INSERT INTO `ssi_door_platesa_product` VALUES ('96', '180315135221', null, '0', '0', '0', '0.000', null, '', null, '0', '1', null, '', '', '', '0', '', '0', '86a375aacb17606c185d', '127', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('97', '180315135946', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '12', '12', '222', '222', '86a375aacb17606c185d', '127', '-83', '-996');
INSERT INTO `ssi_door_platesa_product` VALUES ('98', '180315140041', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '111', '111', '86a375aacb17606c185d', '86', '板厂1', '0', '186', '186');
INSERT INTO `ssi_door_platesa_product` VALUES ('99', '180315140240', null, '0', '0', '1', '0.000', null, '1', null, '0', '1', null, '1', '1', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '514');
INSERT INTO `ssi_door_platesa_product` VALUES ('102', '180315140908', null, '0', '0', '121', '0.000', null, '2', null, '0', '1', null, '12', '12', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '37873');
INSERT INTO `ssi_door_platesa_product` VALUES ('103', '180315140908', null, '0', '0', '0', '0.000', null, '', null, '0', '1', null, '', '', 'undefine', '0', 'undefine', '0', 'undefine', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('104', '180315140908', null, '0', '0', '0', '0.000', null, '', null, '0', '1', null, '', '', 'undefine', '0', 'undefine', '0', 'undefine', '0', '0', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('105', '180315141727', null, '0', '0', '12', '0.000', null, '12', null, '0', '1', null, '12', '12', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '6168');
INSERT INTO `ssi_door_platesa_product` VALUES ('114', '180315142729', null, '0', '0', '121', '0.000', null, '212', null, '0', '1', null, '12', '12', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '62194');
INSERT INTO `ssi_door_platesa_product` VALUES ('116', '180315143939', null, '0', '0', '0', '0.000', null, '', null, '0', '1', null, '', '', '111', '111', '板厂1', '0', '86a375aacb17606c185d', '127', '238', '0');
INSERT INTO `ssi_door_platesa_product` VALUES ('117', '180315144055', null, '0', '0', '21', '0.000', null, '21', null, '0', '1', null, '121', '12', '12', '12', '222', '222', '86a375aacb17606c185d', '127', '-83', '-1743');
INSERT INTO `ssi_door_platesa_product` VALUES ('118', '180315144116', null, '0', '0', '111', '0.000', null, '111', null, '0', '1', null, '111', '111', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '57054');
INSERT INTO `ssi_door_platesa_product` VALUES ('119', '180315144936', null, '0', '0', '212', '0.000', null, '12', null, '0', '1', null, '12', '121', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '108968');
INSERT INTO `ssi_door_platesa_product` VALUES ('120', '180315144952', null, '0', '0', '415', '0.000', null, '4', null, '0', '1', null, '12', '45', '12', '12', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '514', '213310');
INSERT INTO `ssi_door_platesa_product` VALUES ('121', '180315174503', null, '0', '0', '2', '0.000', null, 'g', null, '0', '1', null, '22', 'hg', '111', '111', '86a375aacb17606c185d', '86', '86a375aacb17606c185d', '127', '313', '626');

-- ----------------------------
-- Table structure for ssi_door_print
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_print`;
CREATE TABLE `ssi_door_print` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(20) DEFAULT NULL,
  `barcode` int(11) DEFAULT NULL,
  `createtime` date DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `doprint` int(11) NOT NULL DEFAULT '0' COMMENT '1不可打印、0可打印',
  `sstatus` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1274 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ssi_door_print
-- ----------------------------
INSERT INTO `ssi_door_print` VALUES ('1264', '171212160009', '4', '2018-03-15', '1', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1239', '171210193827', '1', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1220', '170921141722', null, '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1221', '170921141722', '5', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1222', '170921141722', '6', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1223', '170921141722', '7', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1224', '170921141722', '8', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1225', '170921141722', '9', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1226', '170921141722', '10', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1227', '170921141722', '11', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1228', '170921141722', '12', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1229', '170921141722', '13', '0000-00-00', '0', '1', null);
INSERT INTO `ssi_door_print` VALUES ('1230', '170921141722', '14', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1231', '170921141722', '15', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1232', '170921141722', '16', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1233', '170921141722', '17', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1234', '170921141722', '18', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1235', '170921141722', '19', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1236', '171212160009', '1', '0000-00-00', '1', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1242', '17121216000', '1', '0000-00-00', '0', '0', '0');
INSERT INTO `ssi_door_print` VALUES ('1244', '171210193827', '2', '0000-00-00', '0', '0', '0');
INSERT INTO `ssi_door_print` VALUES ('1245', '171210193827', '3', '0000-00-00', '0', '0', '0');
INSERT INTO `ssi_door_print` VALUES ('1246', '171210193827', '4', '0000-00-00', '0', '0', '0');
INSERT INTO `ssi_door_print` VALUES ('1247', '171210193827', '5', '0000-00-00', '0', '0', '0');
INSERT INTO `ssi_door_print` VALUES ('1248', '171210193827', '6', '0000-00-00', '0', '0', '0');
INSERT INTO `ssi_door_print` VALUES ('1266', '180315113038', '1', '2018-03-15', '0', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1255', '171212160009', '2', '0000-00-00', '0', '1', '0');
INSERT INTO `ssi_door_print` VALUES ('1267', '180315144936', '1', '2018-03-15', '1', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1265', '171212120915', '3', '2018-03-15', '0', '0', '1');
INSERT INTO `ssi_door_print` VALUES ('1263', '171212160009', '3', '2018-03-15', '1', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1268', '180315144936', '2', '2018-03-15', '0', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1269', '180315144936', '3', '2018-03-15', '0', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1270', '180315144936', '4', '2018-03-15', '0', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1271', '180315144936', '5', '2018-03-15', '0', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1272', '180315174104', '1', '2018-03-15', '0', '1', '1');
INSERT INTO `ssi_door_print` VALUES ('1273', '180315174104', '2', '2018-03-15', '0', '1', '1');

-- ----------------------------
-- Table structure for ssi_door_printb
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_printb`;
CREATE TABLE `ssi_door_printb` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(20) DEFAULT NULL,
  `barcode` int(11) DEFAULT NULL,
  `createtime` date DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `doprint` int(11) NOT NULL DEFAULT '0' COMMENT '1不可打印、0可打印',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1237 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ssi_door_printb
-- ----------------------------
INSERT INTO `ssi_door_printb` VALUES ('1217', '170921141722', '1', '2017-11-19', '0', '1');
INSERT INTO `ssi_door_printb` VALUES ('1236', '180104095225', '1', '2018-03-12', '0', '1');

-- ----------------------------
-- Table structure for ssi_door_process
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_process`;
CREATE TABLE `ssi_door_process` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fcid` int(11) NOT NULL DEFAULT '0' COMMENT '所属上级配置',
  `tier` int(11) NOT NULL DEFAULT '0' COMMENT '层级',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名称',
  `day` int(11) NOT NULL DEFAULT '0' COMMENT '默认天数',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `img` varchar(500) NOT NULL DEFAULT '' COMMENT '配置图片',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='工序配置表';

-- ----------------------------
-- Records of ssi_door_process
-- ----------------------------
INSERT INTO `ssi_door_process` VALUES ('1', '0', '1', '包覆系统', '15', '0', '', '1');
INSERT INTO `ssi_door_process` VALUES ('2', '0', '1', '吸塑系统', '15', '0', '', '1');
INSERT INTO `ssi_door_process` VALUES ('3', '1', '2', '确定接单', '1', '1', '', '1');
INSERT INTO `ssi_door_process` VALUES ('4', '1', '2', '门芯下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('5', '1', '2', '边框下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('6', '1', '2', '裸料小件下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('7', '1', '2', '镶线英法式中横下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('9', '1', '2', '网格百叶/德式中横下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('10', '1', '2', '成品小件下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('11', '1', '2', '铣型芯板', '3', '3', '', '1');
INSERT INTO `ssi_door_process` VALUES ('12', '1', '2', '打磨', '4', '4', '', '1');
INSERT INTO `ssi_door_process` VALUES ('13', '1', '2', '吸塑', '5', '5', '', '1');
INSERT INTO `ssi_door_process` VALUES ('14', '1', '2', '组框', '6', '6', '', '1');
INSERT INTO `ssi_door_process` VALUES ('15', '1', '2', '打孔', '6', '7', '', '1');
INSERT INTO `ssi_door_process` VALUES ('16', '1', '2', '质检', '7', '8', '', '1');
INSERT INTO `ssi_door_process` VALUES ('17', '1', '2', '做旧', '8', '9', '', '1');
INSERT INTO `ssi_door_process` VALUES ('18', '1', '2', '包装', '10', '10', '', '1');
INSERT INTO `ssi_door_process` VALUES ('20', '1', '2', '物流发货', '10', '12', '', '1');
INSERT INTO `ssi_door_process` VALUES ('21', '2', '2', '原料入库', '1', '1', '', '1');
INSERT INTO `ssi_door_process` VALUES ('22', '2', '2', '门板下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('23', '2', '2', '裸料小件下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('24', '2', '2', '成品小件下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('25', '2', '2', '雕刻', '3', '3', '', '1');
INSERT INTO `ssi_door_process` VALUES ('26', '1', '2', '修色', '7', '8', '', '1');
INSERT INTO `ssi_door_process` VALUES ('29', '1', '2', '铣边门板', '3', '3', '', '1');
INSERT INTO `ssi_door_process` VALUES ('31', '1', '2', '格兰条下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('30', '1', '2', '喷漆', '8', '8', '', '1');
INSERT INTO `ssi_door_process` VALUES ('32', '1', '2', '罗马柱围栏下料', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('33', '1', '2', '拱直韩式', '3', '2', '', '1');
INSERT INTO `ssi_door_process` VALUES ('34', '1', '2', '门板下料', '3', '2', '', '1');

-- ----------------------------
-- Table structure for ssi_door_relation
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_relation`;
CREATE TABLE `ssi_door_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自然ID',
  `door_type_id` int(11) DEFAULT NULL COMMENT '门型ID',
  `core_board_ids` varchar(200) DEFAULT NULL COMMENT '芯板ID',
  `color_surface_ids` varchar(200) DEFAULT NULL COMMENT '表面颜色ID',
  `punch_ids` varchar(200) DEFAULT NULL COMMENT '打孔ID',
  `punch_style_ids` varchar(200) DEFAULT NULL COMMENT '打孔样式ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='门厂产品参数关联表';

-- ----------------------------
-- Records of ssi_door_relation
-- ----------------------------
INSERT INTO `ssi_door_relation` VALUES ('1', null, null, null, null, null);

-- ----------------------------
-- Table structure for ssi_door_scanning
-- ----------------------------
DROP TABLE IF EXISTS `ssi_door_scanning`;
CREATE TABLE `ssi_door_scanning` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(50) NOT NULL DEFAULT '',
  `uname` varchar(50) NOT NULL DEFAULT '',
  `utel` varchar(11) NOT NULL DEFAULT '',
  `mids` varchar(2000) NOT NULL DEFAULT '' COMMENT '扫码枪关联的程序process',
  `info` varchar(50) NOT NULL DEFAULT '' COMMENT '备注',
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ssi_door_scanning
-- ----------------------------
INSERT INTO `ssi_door_scanning` VALUES ('21', '13', '吕宏伟', '', 'a:1:{i:0;s:2:\"21\";}', '下料小件', '1');
INSERT INTO `ssi_door_scanning` VALUES ('22', '14', '夏亮亮', '', 'a:1:{i:0;s:2:\"25\";}', '雕刻', '1');
INSERT INTO `ssi_door_scanning` VALUES ('20', '12', '刘子祥', '', 'a:1:{i:0;s:2:\"21\";}', '下料门板', '1');
INSERT INTO `ssi_door_scanning` VALUES ('18', '10', '李艳娟', '', 'a:1:{i:0;s:2:\"16\";}', '质检吸塑', '1');
INSERT INTO `ssi_door_scanning` VALUES ('19', '11', '李伟康', '', 'a:1:{i:0;s:1:\"4\";}', '下料芯板', '1');
INSERT INTO `ssi_door_scanning` VALUES ('17', '09', '王世华', '', 'a:1:{i:0;s:2:\"16\";}', '质检半成品', '1');
INSERT INTO `ssi_door_scanning` VALUES ('16', '34', '杨淑艳', '', 'a:1:{i:0;s:2:\"16\";}', '质检成品', '1');
INSERT INTO `ssi_door_scanning` VALUES ('15', '07', '于忠波', '', 'a:1:{i:0;s:1:\"3\";}', '生产安排', '1');
INSERT INTO `ssi_door_scanning` VALUES ('10', '02', '02', '', '', '', '1');
INSERT INTO `ssi_door_scanning` VALUES ('11', '03', '03', '', '', '', '1');
INSERT INTO `ssi_door_scanning` VALUES ('12', '04', '04', '', '', '', '1');
INSERT INTO `ssi_door_scanning` VALUES ('13', '05', '05', '', '', '', '1');
INSERT INTO `ssi_door_scanning` VALUES ('14', '06', '06', '', '', '', '1');
INSERT INTO `ssi_door_scanning` VALUES ('9', '01', '01', '', 's:0:\"\";', '', '1');
INSERT INTO `ssi_door_scanning` VALUES ('23', '15', '李呈硕', '', 'a:1:{i:0;s:2:\"15\";}', '打孔', '1');
INSERT INTO `ssi_door_scanning` VALUES ('24', '16', '姜涛', '', 'a:1:{i:0;s:2:\"29\";}', '铣边', '1');
INSERT INTO `ssi_door_scanning` VALUES ('25', '46', '王博', '', 'a:1:{i:0;s:2:\"11\";}', '铣型', '1');
INSERT INTO `ssi_door_scanning` VALUES ('26', '18', '钱帅', '', 'a:1:{i:0;s:1:\"5\";}', '边框下料', '1');
INSERT INTO `ssi_door_scanning` VALUES ('27', '19', '王宁', '', 'a:1:{i:0;s:2:\"14\";}', '组框', '1');
INSERT INTO `ssi_door_scanning` VALUES ('28', '20', '孙宝童', '', 'a:1:{i:0;s:2:\"14\";}', '组框', '1');
INSERT INTO `ssi_door_scanning` VALUES ('29', '21', '邵丽', '', 'a:1:{i:0;s:2:\"26\";}', '修色', '1');
INSERT INTO `ssi_door_scanning` VALUES ('30', '22', '赵双', '', 'a:1:{i:0;s:2:\"26\";}', '修色', '1');
INSERT INTO `ssi_door_scanning` VALUES ('31', '23', '李秀荣', '', 'a:1:{i:0;s:2:\"26\";}', '修色', '1');
INSERT INTO `ssi_door_scanning` VALUES ('32', '24', '张玉', '', 'a:1:{i:0;s:2:\"18\";}', '打包', '1');
INSERT INTO `ssi_door_scanning` VALUES ('33', '25', '黄晓丽', '', 'a:1:{i:0;s:2:\"18\";}', '打包', '1');
INSERT INTO `ssi_door_scanning` VALUES ('34', '35', '吴家勇', '', 'a:1:{i:0;s:2:\"10\";}', '小件成品', '1');
INSERT INTO `ssi_door_scanning` VALUES ('35', '27', '鲍玉斌', '', 'a:1:{i:0;s:1:\"7\";}', '小件镶线英法中横', '1');
INSERT INTO `ssi_door_scanning` VALUES ('36', '28', '白天鹏', '', 'a:1:{i:0;s:2:\"31\";}', '小件格兰条', '1');
INSERT INTO `ssi_door_scanning` VALUES ('37', '29', '丁世恒', '', 'a:2:{i:0;s:1:\"8\";i:1;s:1:\"9\";}', '小件德式中横/网格百叶', '1');
INSERT INTO `ssi_door_scanning` VALUES ('38', '30', '伟平新', '', 'a:1:{i:0;s:2:\"32\";}', '小件罗马柱围栏', '1');
INSERT INTO `ssi_door_scanning` VALUES ('39', '31', '何家福', '', 'a:1:{i:0;s:2:\"33\";}', '小件拱直韩式', '1');
INSERT INTO `ssi_door_scanning` VALUES ('40', '32', '范文娟', '', 'a:1:{i:0;s:2:\"17\";}', '做旧', '1');
INSERT INTO `ssi_door_scanning` VALUES ('41', '33', '胡文波', '', 'a:1:{i:0;s:2:\"17\";}', '做旧', '1');
INSERT INTO `ssi_door_scanning` VALUES ('42', '08', '薛九海', '', 'a:1:{i:0;s:2:\"17\";}', '做旧', '1');
INSERT INTO `ssi_door_scanning` VALUES ('43', '26', '梦维成', '', 'a:1:{i:0;s:2:\"30\";}', '喷漆', '1');
INSERT INTO `ssi_door_scanning` VALUES ('44', '36', '王丽丽', '', 'a:1:{i:0;s:2:\"13\";}', '吸塑', '1');
INSERT INTO `ssi_door_scanning` VALUES ('45', '37', '王玲', '', 'a:1:{i:0;s:2:\"13\";}', '吸塑', '1');
INSERT INTO `ssi_door_scanning` VALUES ('46', '38', '苏福成', '', 'a:1:{i:0;s:2:\"13\";}', '吸塑', '1');
INSERT INTO `ssi_door_scanning` VALUES ('47', '39', '陈明国', '', 'a:1:{i:0;s:2:\"13\";}', '吸塑', '1');
INSERT INTO `ssi_door_scanning` VALUES ('48', '40', '张英芝', '', 'a:1:{i:0;s:2:\"13\";}', '吸塑', '1');
INSERT INTO `ssi_door_scanning` VALUES ('49', '41', '赵诚', '', 'a:1:{i:0;s:2:\"18\";}', '打包', '1');
INSERT INTO `ssi_door_scanning` VALUES ('50', '42', '路海侠', '', 'a:1:{i:0;s:2:\"20\";}', '发货', '1');
INSERT INTO `ssi_door_scanning` VALUES ('51', '43', '梁秀娟', '', 'a:1:{i:0;s:2:\"12\";}', '打磨', '1');
INSERT INTO `ssi_door_scanning` VALUES ('52', '44', '胜月梅', '', 'a:1:{i:0;s:2:\"12\";}', '打磨', '1');
INSERT INTO `ssi_door_scanning` VALUES ('53', '45', '张丽敏', '', 'a:1:{i:0;s:2:\"12\";}', '打磨', '1');
INSERT INTO `ssi_door_scanning` VALUES ('54', '17', '董宝', '', 'a:1:{i:0;s:2:\"14\";}', '组框打孔', '1');

-- ----------------------------
-- Table structure for ssi_front_member
-- ----------------------------
DROP TABLE IF EXISTS `ssi_front_member`;
CREATE TABLE `ssi_front_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户UID',
  `nickname` varchar(32) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `sex` int(11) NOT NULL COMMENT '性别 1男 2女',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `email` varchar(32) NOT NULL COMMENT '邮箱',
  `tel` varchar(200) NOT NULL COMMENT '电话',
  `weixin_openid` varchar(32) NOT NULL COMMENT '微信openid',
  `weixin_unionid` varchar(50) NOT NULL COMMENT '微信unid',
  `img` varchar(500) NOT NULL DEFAULT 'http://o7d9c7p7z.bkt.clouddn.com/avator.jpg' COMMENT '头像',
  `password` varchar(32) NOT NULL COMMENT '用户密码',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `partner` int(11) NOT NULL COMMENT '是否是合作者 0为不是 1是',
  `province` varchar(32) NOT NULL COMMENT '地址',
  `country` varchar(32) NOT NULL COMMENT '国家',
  `is_perfect` int(11) NOT NULL COMMENT '是否完善 0未完善 1已完善',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态 1正常 2停用 0伪删除',
  `address` varchar(500) NOT NULL COMMENT '地址',
  `remark` varchar(500) NOT NULL COMMENT '备注',
  `company` varchar(500) NOT NULL COMMENT '公司',
  `groupid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '客户群组',
  `parm` varchar(11) NOT NULL DEFAULT '0' COMMENT '是否包月',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='公共用户表';

-- ----------------------------
-- Records of ssi_front_member
-- ----------------------------
INSERT INTO `ssi_front_member` VALUES ('1', '测试用户', '1', 'test', '215440666@qq.com', '15566662064', '', '', 'http://o7d9c7p7z.bkt.clouddn.com/avator.jpg', '86a375aacb17606c185d31c8d3e320ce', '1463234393', '0', '', '', '0', '1', '软件园路', '无', '肆网科技', '0', '1', '0');
INSERT INTO `ssi_front_member` VALUES ('2', '张大侠', '0', 'zcf', '333@33.com', '15555555555', '', '', '/upload/1/2017/07/16/596b588c410a7.jpg', '86a375aacb17606c185d31c8d3e320ce', '1500187760', '0', '', '', '0', '1', '', '', '', '0', '1', '0');
INSERT INTO `ssi_front_member` VALUES ('3', '测试用户2', '0', 'test2', '1232@123.com', '13333333333', '', '', 'http://o7d9c7p7z.bkt.clouddn.com/avator.jpg', '86a375aacb17606c185d31c8d3e320ce', '1500188218', '0', '', '', '0', '1', '', '', '', '0', '6', '1515826618');
INSERT INTO `ssi_front_member` VALUES ('4', 'zby', '0', '测试客户郑', '183400707@qq.com', '15210331870', '', '', 'http://o7d9c7p7z.bkt.clouddn.com/avator.jpg', '86a375aacb17606c185d31c8d3e320ce', '1515462791', '0', '', '', '0', '1', '', '', '', '0', '4', '1526003591');
INSERT INTO `ssi_front_member` VALUES ('5', '121', '0', '1212', '121', '21', '', '', 'http://o7d9c7p7z.bkt.clouddn.com/avator.jpg', '86a375aacb17606c185d31c8d3e320ce', '1520838054', '0', '', '', '0', '1', '', '', '', '0', '2', '1526108454');

-- ----------------------------
-- Table structure for ssi_front_saler
-- ----------------------------
DROP TABLE IF EXISTS `ssi_front_saler`;
CREATE TABLE `ssi_front_saler` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户UID',
  `nickname` varchar(32) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `sex` int(11) NOT NULL COMMENT '性别 1男 2女',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `email` varchar(32) NOT NULL COMMENT '邮箱',
  `tel` varchar(200) NOT NULL COMMENT '电话',
  `weixin_openid` varchar(32) NOT NULL COMMENT '微信openid',
  `weixin_unionid` varchar(50) NOT NULL COMMENT '微信unid',
  `img` varchar(500) NOT NULL DEFAULT 'http://o7d9c7p7z.bkt.clouddn.com/avator.jpg' COMMENT '头像',
  `password` varchar(32) NOT NULL COMMENT '用户密码',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `partner` int(11) NOT NULL COMMENT '是否是合作者 0为不是 1是',
  `province` varchar(32) NOT NULL COMMENT '地址',
  `country` varchar(32) NOT NULL COMMENT '国家',
  `is_perfect` int(11) NOT NULL COMMENT '是否完善 0未完善 1已完善',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态 1正常 2停用 0伪删除',
  `address` varchar(500) NOT NULL COMMENT '地址',
  `remark` varchar(500) NOT NULL COMMENT '备注',
  `company` varchar(500) NOT NULL COMMENT '公司',
  `groupid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '客户群组',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='公共用户表';

-- ----------------------------
-- Records of ssi_front_saler
-- ----------------------------
INSERT INTO `ssi_front_saler` VALUES ('1', '1', '1', '1', '1', '1', '1', '1', '', '1', '0', '0', '', '', '0', '1', '', '', '', '0');
INSERT INTO `ssi_front_saler` VALUES ('2', '2', '0', '2', '2', '2', '', '', '/upload/1/2018/03/08/5aa01416df660.jpg', '86a375aacb17606c185d31c8d3e320ce', '1520440344', '0', '', '', '0', '1', '', '', '', '0');