/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50529
Source Host           : localhost:3306
Source Database       : php2

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

Date: 2024-10-23 14:27:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for qmcrm_baogao
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_baogao`;
CREATE TABLE `qmcrm_baogao` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `types` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT '',
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `fujian` varchar(255) DEFAULT NULL,
  `isread` int(11) DEFAULT '0',
  `reply` text,
  `tousers` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_baogao
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_caiwu
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_caiwu`;
CREATE TABLE `qmcrm_caiwu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(4) DEFAULT '1',
  `cid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT '',
  `model` varchar(255) DEFAULT NULL,
  `xid` int(11) DEFAULT NULL,
  `xcode` varchar(255) DEFAULT NULL,
  `htuser` varchar(255) DEFAULT NULL,
  `hsrq` datetime DEFAULT NULL,
  `gysid` int(11) DEFAULT NULL,
  `gysname` varchar(255) DEFAULT NULL,
  `outin` tinyint(4) DEFAULT '1',
  `type` varchar(255) DEFAULT '',
  `type1` varchar(255) DEFAULT NULL,
  `type0` varchar(255) DEFAULT NULL,
  `money` decimal(11,2) DEFAULT '0.00',
  `content` text,
  `szfs` varchar(255) DEFAULT NULL,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `reason` varchar(255) DEFAULT '',
  `biaoji` varchar(255) DEFAULT NULL,
  `biaoji_yanse` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  `drpc` varchar(255) DEFAULT NULL,
  `drjson` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_caiwu
-- ----------------------------
INSERT INTO `qmcrm_caiwu` VALUES ('1', '1', '1', '客户1', '合同', '1', 'HT202305270316', null, null, null, null, '1', '合同款', '合同款', null, '8000.00', '收款备注：1', '现金', '超级管理员', '超级管理员', '2024-10-23 14:26:32', null, null, null, '', null, null, '0', null, null, null);

-- ----------------------------
-- Table structure for qmcrm_call
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_call`;
CREATE TABLE `qmcrm_call` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(4) DEFAULT '1',
  `type` varchar(255) DEFAULT NULL,
  `cid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT '',
  `state` tinyint(1) DEFAULT NULL,
  `recordfile` text,
  `timing` varchar(255) DEFAULT NULL,
  `stime` datetime DEFAULT NULL,
  `atime` datetime DEFAULT NULL,
  `etime` datetime DEFAULT NULL,
  `devicename` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_call
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_chanpin
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_chanpin`;
CREATE TABLE `qmcrm_chanpin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `class1` varchar(255) DEFAULT '',
  `class2` varchar(255) DEFAULT '',
  `name` varchar(255) DEFAULT '',
  `pic` varchar(255) DEFAULT '0',
  `xinghao` varchar(255) DEFAULT '0',
  `guige` varchar(255) DEFAULT NULL,
  `danwei` varchar(255) DEFAULT NULL,
  `kucun` decimal(11,2) DEFAULT NULL,
  `chengben` decimal(11,2) DEFAULT NULL,
  `shoujia` decimal(11,2) DEFAULT NULL,
  `content` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT '',
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `drpc` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_chanpin
-- ----------------------------
INSERT INTO `qmcrm_chanpin` VALUES ('1', '产品大类', '产品小类', '默认产品', '/theme/qmsoft/images/nopic.png', 'XH01', 'GG01', '箱', '9995.88', '500.00', '1000.00', '', '超级管理员', '超级管理员', '2020-05-22 16:01:00', '2023-11-09 16:29:59', null, '0', null);

-- ----------------------------
-- Table structure for qmcrm_chanpin_class
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_chanpin_class`;
CREATE TABLE `qmcrm_chanpin_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `parentid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_chanpin_class
-- ----------------------------
INSERT INTO `qmcrm_chanpin_class` VALUES ('1', '0', '产品大类', '0');
INSERT INTO `qmcrm_chanpin_class` VALUES ('2', '1', '产品小类', '0');

-- ----------------------------
-- Table structure for qmcrm_chanpin_gys
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_chanpin_gys`;
CREATE TABLE `qmcrm_chanpin_gys` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `lxr` varchar(255) DEFAULT NULL,
  `lxrdh` varchar(255) DEFAULT NULL,
  `gysdz` text,
  `kpzl` text,
  `content` text,
  `inuse` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `upduser` varchar(255) DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_chanpin_gys
-- ----------------------------
INSERT INTO `qmcrm_chanpin_gys` VALUES ('1', '武汉XX科技有限公司', 'XXX', '13888888888', '', '', '', null, '超级管理员', '2024-03-23 13:43:19', null, null, '0', null);

-- ----------------------------
-- Table structure for qmcrm_chat
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_chat`;
CREATE TABLE `qmcrm_chat` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `type` varchar(255) NOT NULL DEFAULT 'friend' COMMENT '聊天类型',
  `idhash` varchar(255) NOT NULL COMMENT 'hash值',
  `touid` mediumint(11) unsigned NOT NULL DEFAULT '0' COMMENT '会话发送的id',
  `uid` mediumint(11) NOT NULL DEFAULT '0' COMMENT '消息来源用户名',
  `fromid` int(11) DEFAULT NULL,
  `content` text,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录时间',
  `writetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '送达时间',
  `hasview` tinyint(11) NOT NULL DEFAULT '0' COMMENT '0 为未读',
  `cid` int(11) DEFAULT NULL,
  `isdel` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `touid` (`touid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_chat
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_chat_group
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_chat_group`;
CREATE TABLE `qmcrm_chat_group` (
  `id` int(100) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `groupname` varchar(255) NOT NULL COMMENT '群名称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '群头像',
  `qunzhu` int(100) NOT NULL COMMENT '群主id',
  `chengyuan` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_chat_group
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_config
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_config`;
CREATE TABLE `qmcrm_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `name` varchar(255) DEFAULT NULL,
  `value` text,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_config
-- ----------------------------
INSERT INTO `qmcrm_config` VALUES ('1', 'config_dom', 'test.com', '0');
INSERT INTO `qmcrm_config` VALUES ('2', 'config_sqm', '8957OLP08300O511N7279N14O203P7K9N137870O', '0');
INSERT INTO `qmcrm_config` VALUES ('3', 'login_title', '用户登录', '0');
INSERT INTO `qmcrm_config` VALUES ('4', 'login_wytitle', '企孟CRM客户管理系统', '0');
INSERT INTO `qmcrm_config` VALUES ('5', 'logo', '', '0');
INSERT INTO `qmcrm_config` VALUES ('6', 'favicon', '/theme/favicon.ico', '0');
INSERT INTO `qmcrm_config` VALUES ('7', 'icp', '鄂ICP备666888号-1', '0');
INSERT INTO `qmcrm_config` VALUES ('8', 'vision', '1.3.8', '0');
INSERT INTO `qmcrm_config` VALUES ('9', 'icon_support_on', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('10', 'bao_on', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('11', 'bao_gendan_on', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('12', 'bao_gendan_day', '30', '0');
INSERT INTO `qmcrm_config` VALUES ('13', 'bao_hetong_on', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('14', 'bao_hetong_day', '90', '0');
INSERT INTO `qmcrm_config` VALUES ('15', 'bao_tixing', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('16', 'bao_tixing_day', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('17', 'bao_paichu_cj', '是', '0');
INSERT INTO `qmcrm_config` VALUES ('18', 'sms_on', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('19', 'mail_on', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('20', 'call_on', '0', '0');
INSERT INTO `qmcrm_config` VALUES ('21', 'sms_api', 'http://sms.30qe.com', '0');
INSERT INTO `qmcrm_config` VALUES ('22', 'zf_kehu', '客户', '0');
INSERT INTO `qmcrm_config` VALUES ('23', 'zf_gendan', '跟单', '0');
INSERT INTO `qmcrm_config` VALUES ('24', 'zf_hetong', '合同订单', '0');
INSERT INTO `qmcrm_config` VALUES ('25', 'zf_huifang', '回访', '0');
INSERT INTO `qmcrm_config` VALUES ('26', 'zf_caiwu', '财务', '0');
INSERT INTO `qmcrm_config` VALUES ('27', 'zf_gonghai', '公海', '0');
INSERT INTO `qmcrm_config` VALUES ('28', 'zf_chanpin', '产品', '0');
INSERT INTO `qmcrm_config` VALUES ('29', 'show_bianhao', '0', '0');
INSERT INTO `qmcrm_config` VALUES ('30', 'mobile_yz', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('31', 'qc_name', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('32', 'qc_mobile', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('33', 'config_dom1', '', '0');
INSERT INTO `qmcrm_config` VALUES ('34', 'config_sqm1', '', '0');
INSERT INTO `qmcrm_config` VALUES ('35', 'logs_time', '2024-08-30 19:28:04', '0');
INSERT INTO `qmcrm_config` VALUES ('36', 'fuzhi_off', '0', '0');
INSERT INTO `qmcrm_config` VALUES ('37', 'users_select_all', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('40', 'imgyasuo', '1', '0');
INSERT INTO `qmcrm_config` VALUES ('41', 'yeji_ziduan', 'ysmoney', '0');
INSERT INTO `qmcrm_config` VALUES ('42', 'zf_gongdan', '工单', '0');

-- ----------------------------
-- Table structure for qmcrm_feiyongbx
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_feiyongbx`;
CREATE TABLE `qmcrm_feiyongbx` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `types` varchar(255) DEFAULT NULL,
  `riqi` datetime DEFAULT NULL,
  `jine` decimal(11,2) DEFAULT NULL,
  `content` text,
  `fujian_name` text,
  `fujian_url` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `tousers` text,
  `shenhe` tinyint(1) DEFAULT '0',
  `shenhebeizhu` text,
  `shenheuser` varchar(255) DEFAULT NULL,
  `shenhetime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_feiyongbx
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_files
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_files`;
CREATE TABLE `qmcrm_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `xid` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filepath` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `isshare` varchar(255) COLLATE utf8_unicode_ci DEFAULT '否',
  `nowuser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adduser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_files
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_fujian
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_fujian`;
CREATE TABLE `qmcrm_fujian` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `cid` int(11) DEFAULT '0',
  `name` text,
  `model` varchar(255) DEFAULT NULL,
  `xid` int(11) DEFAULT '0',
  `client_name` text,
  `url` text,
  `file_size` varchar(255) DEFAULT NULL,
  `is_image` varchar(255) DEFAULT NULL,
  `zdname` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_fujian
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_gendan
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_gendan`;
CREATE TABLE `qmcrm_gendan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `isnew` tinyint(1) DEFAULT '0',
  `weizhi` tinyint(4) DEFAULT '1',
  `cid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `linkman` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT '',
  `state` varchar(255) DEFAULT '',
  `nexttime` datetime DEFAULT NULL,
  `remind` int(50) DEFAULT '0',
  `content` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `biaoji` varchar(255) DEFAULT NULL,
  `biaoji_yanse` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  `drpc` varchar(255) DEFAULT NULL,
  `drjson` text,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_gendan
-- ----------------------------
INSERT INTO `qmcrm_gendan` VALUES ('1', '0', '1', '1', '客户1', '111', '上门拜访', '有意向', '2024-10-26 14:26:32', '0', '客户有购买意向', '张三', '张三', '2024-10-23 14:26:32', null, null, null, null, null, '0', null, null, null);
INSERT INTO `qmcrm_gendan` VALUES ('2', '0', '1', '2', '客户2', '222', '电话跟进', '初次沟通', '2024-10-26 14:26:32', '0', '客户说不需要', '李四', '李四', '2024-10-23 14:26:32', null, null, null, null, null, '0', null, null, null);

-- ----------------------------
-- Table structure for qmcrm_gongdan
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_gongdan`;
CREATE TABLE `qmcrm_gongdan` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `linkman` varchar(255) DEFAULT NULL,
  `leixing` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `renyuan` text,
  `stime` datetime DEFAULT NULL,
  `etime` datetime DEFAULT NULL,
  `content` text,
  `shenhe` varchar(255) DEFAULT NULL,
  `shenhebeizhu` text,
  `shenhetime` datetime DEFAULT NULL,
  `fujian` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  `drpc` varchar(255) DEFAULT NULL,
  `drjson` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_gongdan
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_gongdan_gzjl
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_gongdan_gzjl`;
CREATE TABLE `qmcrm_gongdan_gzjl` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gdid` int(11) DEFAULT NULL,
  `content` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `upduser` varchar(255) DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_gongdan_gzjl
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_gonggao
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_gonggao`;
CREATE TABLE `qmcrm_gonggao` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `types` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT '',
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `fujian` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_gonggao
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_hetong
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_hetong`;
CREATE TABLE `qmcrm_hetong` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(4) DEFAULT '1',
  `cid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT '',
  `linkman` varchar(255) DEFAULT '',
  `number` varchar(255) DEFAULT '',
  `httype` varchar(255) DEFAULT NULL,
  `stime` datetime DEFAULT NULL,
  `etime` datetime DEFAULT NULL,
  `money` decimal(11,2) DEFAULT NULL,
  `ysmoney` decimal(11,2) DEFAULT NULL,
  `qkmoney` decimal(11,2) DEFAULT NULL,
  `kaipiao_jine` decimal(11,2) DEFAULT NULL,
  `content` text,
  `shenhe` varchar(255) DEFAULT '待审',
  `shenhebeizhu` text,
  `hetong_chanpin` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `biaoji` varchar(255) DEFAULT NULL,
  `biaoji_yanse` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  `drpc` varchar(255) DEFAULT NULL,
  `drjson` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_hetong
-- ----------------------------
INSERT INTO `qmcrm_hetong` VALUES ('1', '1', '1', '客户1', '111', 'HT202305270316', '服务合同', '2024-10-23 14:26:32', '2025-10-23 14:26:32', '1000.00', '0.00', '1000.00', null, '客户很爽快', '待审', null, null, '张三', '张三', '2024-10-23 14:26:32', null, null, null, null, null, '0', null, null, null);

-- ----------------------------
-- Table structure for qmcrm_hetong_chanpin
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_hetong_chanpin`;
CREATE TABLE `qmcrm_hetong_chanpin` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `hetongid` int(11) DEFAULT '0',
  `chanpinid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT '',
  `pic` varchar(255) DEFAULT NULL,
  `xinghao` varchar(255) DEFAULT NULL,
  `guige` varchar(255) DEFAULT NULL,
  `danwei` varchar(255) DEFAULT NULL,
  `nums` decimal(11,2) DEFAULT '0.00',
  `chengben` decimal(11,2) DEFAULT '0.00',
  `shoujia` decimal(11,2) DEFAULT '0.00',
  `zhekou` decimal(11,2) DEFAULT '0.00',
  `money` decimal(11,2) DEFAULT '0.00',
  `content` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_hetong_chanpin
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_hetong_fahuo
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_hetong_fahuo`;
CREATE TABLE `qmcrm_hetong_fahuo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `hid` int(11) DEFAULT NULL,
  `fhrq` datetime DEFAULT NULL,
  `fhjs` varchar(255) DEFAULT NULL,
  `fhje` decimal(11,2) DEFAULT NULL,
  `wlgs` varchar(255) DEFAULT NULL,
  `wldh` varchar(255) DEFAULT NULL,
  `beizhu` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_hetong_fahuo
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_hetong_xufei
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_hetong_xufei`;
CREATE TABLE `qmcrm_hetong_xufei` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `hid` int(11) DEFAULT NULL,
  `xfrq` datetime DEFAULT NULL,
  `skje` decimal(11,2) DEFAULT NULL,
  `szfs` varchar(255) DEFAULT NULL,
  `ydqrq` datetime DEFAULT NULL,
  `xdqrq` datetime DEFAULT NULL,
  `beizhu` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_hetong_xufei
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_huifang
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_huifang`;
CREATE TABLE `qmcrm_huifang` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(4) DEFAULT '1',
  `cid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT '',
  `linkman` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT '',
  `title` varchar(255) DEFAULT '',
  `content` text,
  `shenhe` varchar(255) DEFAULT NULL,
  `shenhebeizhu` text,
  `shenhetime` datetime DEFAULT NULL,
  `stime` datetime DEFAULT NULL,
  `etime` datetime DEFAULT NULL,
  `issolve` varchar(255) DEFAULT '否',
  `solvecontent` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `reason` varchar(255) DEFAULT '',
  `updtime` datetime DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `biaoji` varchar(255) DEFAULT NULL,
  `biaoji_yanse` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  `drpc` varchar(255) DEFAULT NULL,
  `drjson` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='回访';

-- ----------------------------
-- Records of qmcrm_huifang
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_kaipiao
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_kaipiao`;
CREATE TABLE `qmcrm_kaipiao` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(1) DEFAULT '0',
  `cid` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `xid` int(11) DEFAULT '0',
  `htnumber` varchar(255) DEFAULT NULL,
  `leixing` varchar(255) DEFAULT NULL,
  `riqi` datetime DEFAULT NULL,
  `jine` decimal(11,2) DEFAULT NULL,
  `taitou` varchar(255) DEFAULT NULL,
  `shibiehao` varchar(255) DEFAULT NULL,
  `yinhang_zhanghao` text,
  `dizhi_dianhua` text,
  `beizhu` text,
  `shenhe` varchar(255) DEFAULT NULL,
  `shenhebeizhu` text,
  `shenhetime` datetime DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_kaipiao
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_kaoqin
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_kaoqin`;
CREATE TABLE `qmcrm_kaoqin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `types` varchar(255) DEFAULT NULL,
  `qdtime` datetime DEFAULT NULL,
  `content` text,
  `fujian_name` text,
  `fujian_url` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_kaoqin
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_kehu
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_kehu`;
CREATE TABLE `qmcrm_kehu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(1) DEFAULT '1',
  `name` varchar(255) DEFAULT NULL,
  `chengjiao` varchar(255) DEFAULT '否',
  `type` varchar(255) DEFAULT NULL,
  `linkman` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `laiyuan` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `content` text,
  `groupid` int(11) DEFAULT NULL,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `squser` varchar(255) DEFAULT NULL,
  `sqtime` datetime DEFAULT NULL,
  `tg_sqtime` datetime DEFAULT NULL,
  `olduser` varchar(255) DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `share_xinxi` text,
  `drpc` varchar(255) DEFAULT NULL,
  `ghtime` datetime DEFAULT NULL,
  `ghreason` text,
  `bao` tinyint(1) DEFAULT NULL,
  `bao_start_time` datetime DEFAULT NULL,
  `last_gendan_time` datetime DEFAULT NULL,
  `next_gendan_time` datetime DEFAULT NULL,
  `last_hetong_time` datetime DEFAULT NULL,
  `last_huifang_time` datetime DEFAULT NULL,
  `last_caiwu_time` datetime DEFAULT NULL,
  `tixing_time1` datetime DEFAULT NULL,
  `tixing_time2` datetime DEFAULT NULL,
  `biaoji` varchar(255) DEFAULT NULL,
  `biaoji_yanse` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_kehu
-- ----------------------------
INSERT INTO `qmcrm_kehu` VALUES ('1', '1', '客户1', '是', 'A 重点客户', '111', '13111111111', '', '活动促销', '安徽省-合肥市-瑶海区', '', '', null, '张三', '张三', '2024-10-23 14:26:32', '2024-10-23 14:26:32', null, null, null, null, null, null, null, null, null, null, '1', '2024-10-23 14:26:32', '2024-10-23 14:26:32', '2024-10-26 14:26:32', '2024-10-23 14:26:32', null, null, '2024-11-22 14:26:32', '2024-11-22 14:26:32', null, null, '0', null);
INSERT INTO `qmcrm_kehu` VALUES ('2', '1', '客户2', '否', 'B 一般客户', '222', '13222222222', '', '在线咨询', '广东省-佛山市-南海区', '', '', null, '李四', '李四', '2024-10-23 14:26:32', '2024-10-23 14:26:32', null, null, null, null, null, null, null, null, null, null, '1', '2024-10-23 14:26:32', '2024-10-23 14:26:32', '2024-10-26 14:26:32', null, null, null, '2024-11-22 14:26:32', '2024-11-22 14:26:32', null, null, '0', null);
INSERT INTO `qmcrm_kehu` VALUES ('3', '0', '公海客户可领取', '否', 'B 一般客户', '未填写', '13333333333', '', '在线咨询', '', '', '', null, '超级管理员', '超级管理员', '2024-10-23 14:26:32', '2024-10-23 14:26:32', null, null, null, null, null, null, null, null, null, null, '1', '2024-10-23 14:26:32', null, null, null, null, null, '2024-11-22 14:26:32', '2024-11-22 14:26:32', null, null, '0', null);

-- ----------------------------
-- Table structure for qmcrm_linkman
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_linkman`;
CREATE TABLE `qmcrm_linkman` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `weizhi` tinyint(4) DEFAULT '1',
  `zhu` tinyint(1) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `linkman` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `job` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `qq` varchar(255) DEFAULT NULL,
  `birthday` varchar(255) DEFAULT NULL,
  `content` text,
  `nowuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isshare` varchar(255) DEFAULT NULL,
  `share_users` text,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_linkman
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_mail
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_mail`;
CREATE TABLE `qmcrm_mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `types` varchar(255) DEFAULT '',
  `email` varchar(255) DEFAULT '',
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `sendtime` datetime DEFAULT NULL,
  `senduser` varchar(255) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_mail
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_menu
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_menu`;
CREATE TABLE `qmcrm_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `parentid` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bgcolor` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `width` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `height` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lever` int(11) DEFAULT NULL,
  `inuse` varchar(255) COLLATE utf8_unicode_ci DEFAULT '是',
  `m_inuse` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `tiaoz` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `class` int(11) DEFAULT NULL,
  `w_class` int(11) DEFAULT NULL,
  `ordnum` int(11) DEFAULT '50',
  `w_ordnum` int(11) DEFAULT NULL,
  `sys_ordnum` int(11) DEFAULT '50',
  `isicon` tinyint(1) DEFAULT NULL,
  `system` int(11) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE,
  KEY `parentId` (`parentid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1013 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_menu
-- ----------------------------
INSERT INTO `qmcrm_menu` VALUES ('1', '0', '客户管理', 'fa-users', '/index.php/kehu/index', '#7a7a7a', '#21a9f5', '', '', '1', '是', '是', null, '2', '1', '10', '10', '10', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('2', '1', '新增', '', '', null, null, null, null, '2', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('3', '1', '修改', '', '', null, null, null, null, '3', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('4', '1', '删除', '', '', null, null, null, null, '4', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('5', '1', '共享', '', '', null, null, null, null, '5', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('6', '1', '转移', '', '', null, null, null, null, '6', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('7', '1', '转移到公海', '', '/theme/free.htm', null, null, null, null, '7', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('8', '1', '导入', '', '/theme/free.htm', null, null, null, null, '8', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('9', '1', '导出', '', '/theme/free.htm', null, null, null, null, '9', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('11', '0', '客户联系人', 'fa-vcard-o', '/index.php/linkman/index', '#7a7a7a', '#14d3af', '', '', '11', '否', '否', null, '2', '1', '20', '11', '15', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('12', '11', '新增', '', '', null, null, null, null, '12', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('13', '11', '修改', '', '', null, null, null, null, '13', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('14', '11', '删除', '', '', null, null, null, null, '14', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('15', '11', '导入', '', '/theme/free.htm', null, null, null, null, '15', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('16', '11', '导出', '', '/theme/free.htm', null, null, null, null, '16', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('21', '0', '跟单管理', 'fa-fax', '/index.php/gendan/index', '#7a7a7a', '#ef9b41', '', '', '21', '是', '是', null, '2', '1', '30', '20', '20', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('22', '21', '新增', '', '', null, null, null, null, '22', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('23', '21', '修改', '', '', null, null, null, null, '23', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('24', '21', '删除', '', '', null, null, null, null, '24', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('25', '21', '导入', '', '/theme/free.htm', null, null, null, null, '25', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('26', '21', '导出', '', '/theme/free.htm', null, null, null, null, '26', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('31', '0', '合同订单', 'fa-line-chart', '/index.php/hetong/index', '#7a7a7a', '#12b96c', '', '', '31', '是', '是', null, '2', '1', '40', '30', '30', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('32', '31', '新增', '', '', null, null, null, null, '32', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('33', '31', '修改', '', '', null, null, null, null, '33', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('34', '31', '删除', '', '', null, null, null, null, '34', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('35', '31', '收款', '', '', null, null, null, null, '35', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('36', '31', '审核', '', '', null, null, null, null, '36', null, null, null, null, null, '50', null, '60', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('37', '31', '产品', '', '', null, null, null, null, '37', null, null, null, null, null, '50', null, '90', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('38', '31', '导入', '', '/theme/free.htm', null, null, null, null, '38', null, null, null, null, null, '50', null, '100', null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('39', '31', '导出', '', '/theme/free.htm', null, null, null, null, '39', null, null, null, null, null, '50', null, '110', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('41', '0', '开票管理', 'fa-percent', '/index.php/kaipiao/index', '#7a7a7a', '#4c6ba3', null, null, '41', '是', '是', null, '2', '1', '50', '40', '40', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('42', '41', '新增开票', '', '', null, null, null, null, '42', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('43', '41', '开票作废', '', '', null, null, null, null, '43', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('51', '0', '财务管理', 'fa-database', '/index.php/caiwu/index', '#7a7a7a', '#bc5257', '', '', '51', '是', '是', null, '2', '1', '50', '50', '50', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('52', '51', '新增收入', '', '', null, null, null, null, '52', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('53', '51', '新增支出', '', '', null, null, null, null, '53', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('54', '51', '修改', '', '', null, null, null, null, '54', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('55', '51', '删除', '', '', null, null, null, null, '55', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('56', '51', '审核', '', '', null, null, null, null, '56', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('57', '51', '导入', '', '/theme/free.htm', null, null, null, null, '57', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('58', '51', '导出', '', '/theme/free.htm', null, null, null, null, '58', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('61', '0', '回访管理', 'fa-exclamation-triangle', '/index.php/huifang/index', '#7a7a7a', '#78c5b9', '', '', '61', '是', '是', null, '2', '1', '60', '60', '60', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('62', '61', '新增', '', '', null, null, null, null, '62', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('63', '61', '修改', '', '', null, null, null, null, '63', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('64', '61', '删除', '', '', null, null, null, null, '64', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('65', '61', '处理', '', '', null, null, null, null, '65', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('66', '61', '审核', '', '', null, null, null, null, '66', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('67', '61', '导入', '', '/theme/free.htm', null, null, null, null, '67', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('68', '61', '导出', '', '/theme/free.htm', null, null, null, null, '68', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('71', '0', '客户公海', 'fa-user-o', '/theme/free.htm', '#7a7a7a', '#008bf1', '', '', '71', '是', '是', null, '2', '1', '80', '70', '70', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('72', '71', '新增', '', '', null, null, null, null, '72', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('73', '71', '修改', '', '', null, null, null, null, '73', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('74', '71', '删除', '', '', null, null, null, null, '74', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('75', '71', '申请', '', '', null, null, null, null, '75', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('76', '71', '审核', '', '', null, null, null, null, '76', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('77', '71', '导入', '', '', null, null, null, null, '77', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('78', '71', '导出', '', '', null, null, null, null, '78', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('81', '0', '客户回收站', 'fa-institution', '/index.php/huishouzhan', '#7a7a7a', '#86a6d9', '', '', '81', '是', '是', null, '2', '1', '90', '80', '80', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('82', '81', '恢复数据', '', '', null, null, null, null, '82', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('83', '81', '彻底删除', '', '', null, null, null, null, '83', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('91', '0', '产品管理', 'fa-th', '/index.php/chanpin/index', '#7a7a7a', '#bd9a69', '', '', '91', '是', '是', null, '3', '1', '10', '90', '90', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('92', '91', '新增', '', '', null, null, null, null, '92', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('93', '91', '修改', '', '', null, null, null, null, '93', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('94', '91', '删除', '', '', null, null, null, null, '94', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('95', '91', '采购', '', '/theme/free.htm', null, null, null, null, '95', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('101', '0', '产品分类', 'fa-cogs', '/index.php/chanpin/class_', '#7a7a7a', null, '', '', '101', '是', '是', null, '3', null, '20', null, '95', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('102', '101', '新增', '', '', null, null, null, null, '102', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('103', '101', '修改', '', '', null, null, null, null, '103', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('104', '101', '删除', '', '', null, null, null, null, '104', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('111', '0', '内部公告', 'fa-volume-up', '/index.php/gonggao', '#7a7a7a', '#0c9dc7', '', '', '111', '是', '是', null, '4', '1', '10', '120', '120', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('112', '111', '新增', null, null, null, null, null, null, '112', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('113', '111', '修改', '', '', null, null, null, null, '113', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('114', '111', '删除', '', '', null, null, null, null, '114', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('121', '0', '工作报告', 'fa-flag', '/theme/free.htm', '#7a7a7a', '#ca60aa', '', '', '121', '是', '是', null, '4', '1', '20', '130', '170', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('122', '121', '新增', '', '', null, null, null, null, '122', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('123', '121', '修改', '', '', null, null, null, null, '123', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('124', '121', '删除', '', '', null, null, null, null, '124', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('125', '121', '批注', '', '', null, null, null, null, '125', null, null, null, null, null, '0', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('131', '0', '文件管理', 'fa-folder-open', '/theme/free.htm', '#7a7a7a', '#efb686', '', '', '131', '是', '是', null, '4', '1', '40', '140', '220', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('132', '131', '新增', '', '', null, null, null, null, '132', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('133', '131', '修改', '', '', null, null, null, null, '133', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('134', '131', '删除', '', '', null, null, null, null, '134', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('151', '0', '邮件发送', 'fa-share-square-o', '/theme/free.htm', '#7a7a7a', '#de974b', '', '', '151', '是', null, null, '4', '2', '70', '110', '222', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('152', '151', '发送', '', '', null, null, null, null, '152', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('153', '151', '删除', '', '', null, null, null, null, '153', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('161', '250', '内部通讯录', 'fa-address-book-o', '/index.php/tongxunlu', '#7a7a7a', '#a3d063', '', '', '161', '是', '是', null, '4', '1', '30', '110', '255', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('171', '250', '快递查询', 'fa-truck', 'https://www.100926.com/users/kuaidi/', null, null, null, null, '171', null, null, null, null, null, '70', null, '256', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('181', '0', '数据统计', 'fa-pie-chart', '/theme/free.htm', null, '#33774b', null, null, '181', '是', '是', null, null, '1', '10', '100', '100', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('182', '181', '数据概况', 'fa-pie-chart', '/theme/free.htm', '#7a7a7a', '#f3c006', '', '', '182', '是', '是', null, '5', null, '10', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('183', '181', '客户统计', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '183', '是', null, null, '5', null, '20', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('184', '181', '跟单统计', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '184', '是', null, null, '5', null, '30', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('185', '181', '合同统计', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '185', '是', null, null, '5', null, '40', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('187', '181', '回访统计', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '187', '是', null, null, '5', null, '60', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('188', '181', '财务统计', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '188', '是', null, null, '5', null, '45', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('189', '181', '日志报表', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '189', '是', null, null, '5', null, '80', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('190', '181', '数据报表', 'fa-pie-chart', '/theme/free.htm', null, null, null, null, '190', '是', null, null, '5', null, '90', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('191', '0', '员工管理', 'fa-user-circle', '/index.php/user/index', '#7a7a7a', '#099090', '', '', '191', '是', '是', null, '6', '1', '10', '999', '230', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('192', '191', '新增', '', '', null, null, null, null, '192', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('193', '191', '修改', '', '', null, null, null, null, '193', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('194', '191', '删除', '', '', null, null, null, null, '194', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('195', '191', '部门设置', 'fa-sitemap', '/index.php/user_group', null, '#336def', null, null, '195', '是', '是', null, '6', '2', '20', '60', null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('196', '191', '权限角色', 'fa-check-circle', '/index.php/user_role', null, '#d0372b', null, null, '196', '是', '是', null, '6', '2', '30', '70', null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('197', '191', '导入', '', '/theme/free.htm', null, null, null, null, '197', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('198', '191', '导出', '', '/theme/free.htm', null, null, null, null, '198', null, null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('201', '0', '系统设置', 'fa-cog', '/index.php/setting', null, '#33BD85', '890', '550', '201', '是', '是', null, '7', '2', '10', '10', '240', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('204', '201', '栏目菜单', 'fa-toggle-on', '/theme/free.htm', null, '#5186de', null, null, '204', '是', null, null, '7', '2', '20', '80', null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('205', '204', '新增', '', '', null, null, null, null, '205', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('206', '204', '修改', '', '', null, null, null, null, '206', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('207', '204', '删除', '', '', null, null, null, null, '207', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('208', '201', '自定义字段', 'fa-gears', '/index.php/ziduan/index', null, '#9f0dea', null, null, '208', '是', null, null, '7', '2', '30', '90', null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('209', '208', '新增', '', '', null, null, null, null, '209', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('210', '208', '修改', '', '', null, null, null, null, '210', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('211', '208', '删除', '', '', null, null, null, null, '211', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('212', '201', '外呼系统设置', 'fa-fax', '/theme/free.htm', null, '#d4ae60', '880', '500', '212', '是', null, null, '7', '2', '65', '120', null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('213', '201', '短信设置', 'fa-envelope-o', '/theme/free.htm', null, '#2288cc', '880', '500', '213', '是', null, null, '7', '2', '50', '555', null, '1', '1', '1');
INSERT INTO `qmcrm_menu` VALUES ('214', '201', '邮箱设置', 'fa-share-square-o', '/theme/free.htm', null, '#de974b', '880', '500', '214', '是', null, null, '7', '2', '60', '555', null, '1', '1', '1');
INSERT INTO `qmcrm_menu` VALUES ('215', '201', '主题设置', 'fa-envelope-o', '/index.php/setting/theme', null, null, '880', '500', '215', '否', '否', null, '7', null, '70', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('221', '0', '控制台', 'fa-home', '/index.php/home/work', '#7a7a7a', null, '', '', '221', '否', '否', null, '1', null, '10', null, '41', '1', '1', '1');
INSERT INTO `qmcrm_menu` VALUES ('222', '250', '消息中心', 'fa-commenting', '/index.php/message', null, '#de8471', '880', '500', '222', '是', '是', null, '1', '2', '20', '20', '250', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('223', '222', '新增', '', '', null, null, null, null, '223', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('224', '222', '修改', '', '', null, null, null, null, '224', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('225', '222', '删除', '', '', null, null, null, null, '225', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('226', '250', '个人资料', 'fa-user-circle', '/index.php/user/info', null, '#00b6de', '880', '500', '226', '是', '是', null, '1', '2', '30', '30', '250', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('227', '250', '登录日志', 'fa-file-text-o', '/index.php/userloginlog', null, '#56a0c7', null, null, '227', '是', '是', null, '1', '2', '40', '40', '250', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('228', '250', '操作日志', 'fa-file-text-o', '/index.php/userlog', null, '#e80936', null, null, '228', '是', '是', null, '1', '2', '50', '50', '250', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('231', '0', '帮助中心', '', '', null, null, null, null, '231', '', null, null, null, null, '50', null, null, null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('232', '231', '使用帮助', 'fa-info-circle', 'http://www.100926.com/users/bangzhu/', null, '#d9c597', null, null, '232', '是', null, null, '8', '2', '10', '130', null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('233', '231', '问题反馈', 'fa-info-circle', 'http://www.100926.com/users/fankui/', null, null, null, null, '233', '是', null, null, '8', null, '20', null, null, '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('234', null, '', '', '', null, null, null, null, '234', '', null, null, null, null, null, null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('235', '0', '短信管理', 'fa-envelope-o', '/theme/free.htm', '#7a7a7a', '#2288cc', '', '', '235', '是', null, null, '4', '2', '60', '100', '224', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('236', '235', '发送', '', '', null, null, null, null, '236', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('237', '235', '删除', '', '', null, null, null, null, '237', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('238', '235', '新增模板', '', '', null, null, null, null, '238', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('239', '235', '修改模板', '', '', null, null, null, null, '239', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('240', '235', '删除模板', '', '', null, null, null, null, '240', null, null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('250', '0', '其它权限', '', '', null, null, null, null, '250', '', null, null, null, null, '50', null, '250', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('260', '250', 'xxx', '', '', null, null, null, null, '0', '否', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('270', '0', '知识库', 'fa-star', '/index.php/zhishiku/index', '#7a7a7a', '#2196f3', null, null, '270', '是', '是', null, '4', '1', '32', '122', '130', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('271', '270', '新增', '', '', null, null, null, null, '271', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('272', '270', '修改', '', '', null, null, null, null, '272', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('273', '270', '删除', '', '', null, null, null, null, '273', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('280', '0', '考勤签到', 'fa-calendar-check-o', '/index.php/kaoqin/index', '#7a7a7a', '#d01e1e', '1080', '600', '280', '是', '是', null, '4', '1', '33', '123', '140', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('281', '280', '签到', '', '', null, null, null, null, '281', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('282', '280', '统计', '', '', null, null, null, null, '282', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('283', '280', '删除', '', '', null, null, null, null, '283', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('290', '0', '请假管理', 'fa-clock-o', '/theme/free.htm', '#7a7a7a', '#08a769', '1080', '600', '290', '是', '是', null, '4', '1', '34', '124', '150', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('291', '290', '申请', '', '', null, null, null, null, '291', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('292', '290', '审批', '', '', null, null, null, null, '292', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('293', '290', '删除', '', '', null, null, null, null, '293', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('300', '0', '费用报销', 'fa-rmb', '/theme/free.htm', '#7a7a7a', '#0974bb', '1080', '600', '300', '是', '是', null, '4', '1', '36', '126', '160', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('301', '300', '申请', '', '', null, null, null, null, '301', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('302', '300', '审批', '', '', null, null, null, null, '302', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('303', '300', '删除', '', '', null, null, null, null, '303', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('310', '0', '业绩目标', 'fa-bar-chart', '/theme/free.htm', '#7a7a7a', '#a505b3', null, null, '310', '是', '否', null, '2', '1', '150', '150', '1000', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('311', '310', '设定目标', '', '', null, null, null, null, '311', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('312', '310', '业绩关联设置', '', '', null, null, null, null, '312', '是', '', null, null, null, '50', null, '50', null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('320', '0', '工单管理', 'fa-navicon', '/theme/free.htm', '#7a7a7a', '#e68785', null, null, '320', '是', '是', null, '2', '1', '65', '65', '1020', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('321', '320', '新增', '', '', null, null, null, null, '321', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('322', '320', '修改', '', '', null, null, null, null, '322', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('323', '320', '删除', '', '', null, null, null, null, '323', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('324', '320', '记录查看', '', '', null, null, null, null, '324', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('325', '320', '记录新增', '', '', null, null, null, null, '325', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('326', '320', '记录修改', '', '', null, null, null, null, '326', '是', '', null, null, null, '50', null, '50', null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('327', '320', '记录删除', '', '', null, null, null, null, '327', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('328', '320', '导入', '', '', null, null, null, null, '328', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('329', '320', '导出', '', '', null, null, null, null, '329', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('330', '0', '产品供应商', 'fa-handshake-o', '/index.php/chanpin_gys/index', '#7a7a7a', '#e68785', null, null, '330', '是', '是', null, '3', '0', '28', '28', '98', '1', '1', '0');
INSERT INTO `qmcrm_menu` VALUES ('331', '330', '新增', '', '', null, null, null, null, '331', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('332', '330', '修改', '', '', null, null, null, null, '332', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('333', '330', '删除', '', '', null, null, null, null, '333', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('334', '330', '显示联系资料', '', '', null, null, null, null, '334', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('400', '61', '处理状态', '', '', null, null, null, null, '400', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('401', '320', '处理状态', '', '', null, null, null, null, '401', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('402', '31', '收款删除', '', '', null, null, null, null, '402', '是', '', null, null, null, '50', null, '51', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('403', '31', '收款业绩关联设置', '', '', null, null, null, null, '403', '是', '', null, null, null, '50', null, '52', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('404', '31', '续费删除', '', '', null, null, null, null, '404', '是', '', null, null, null, '50', null, '71', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('405', '31', '发货删除', '', '', null, null, null, null, '405', '是', '', null, null, null, '50', null, '81', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('406', '41', '处理状态', '', '', null, null, null, null, '406', '是', '', null, null, null, '50', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('410', '181', '工单统计', 'fa-pie-chart', '/index.php/tongji/tj_huifang', null, null, null, null, '410', '是', '', null, null, null, '65', null, '50', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1001', '71', '显示手机号', '', '', null, null, null, null, '1001', '是', null, null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1002', '191', '管理范围', '', '', null, null, null, null, '1002', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1003', '71', '分配', '', '', null, null, null, null, '1003', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1004', '91', '导入', '', '/theme/free.htm', null, null, null, null, '1004', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1005', '91', '导出', '', '/theme/free.htm', null, null, null, null, '1005', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1006', '250', '录入时指定业务员', '', '', null, null, null, null, '1006', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1007', '250', '修改时指定业务员', '', '', null, null, null, null, '1007', '是', '', null, null, null, '50', null, null, null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1008', '31', '续费', '', '', null, null, null, null, '1008', '是', '是', null, null, null, '50', null, '70', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1009', '31', '发货', '', '', null, null, null, null, '1009', '是', '', null, null, null, '50', null, '80', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1010', '31', '打印', '', '/theme/free.htm', null, null, null, null, '1010', '是', '', null, null, null, '50', null, '50', null, null, '1');
INSERT INTO `qmcrm_menu` VALUES ('1011', '31', '显示汇总', '', '/theme/free.htm', null, null, null, null, '1011', '是', '', null, null, null, '60', null, '60', null, null, '0');
INSERT INTO `qmcrm_menu` VALUES ('1012', '51', '显示汇总', '', '/theme/free.htm', null, null, null, null, '1012', '是', '', null, null, null, '60', null, '60', null, null, '0');

-- ----------------------------
-- Table structure for qmcrm_menu_kehu
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_menu_kehu`;
CREATE TABLE `qmcrm_menu_kehu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `issystem` tinyint(4) DEFAULT '0',
  `lever` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `isshow` varchar(50) DEFAULT NULL,
  `ordnum` int(11) DEFAULT NULL,
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_menu_kehu
-- ----------------------------
INSERT INTO `qmcrm_menu_kehu` VALUES ('1', '1', '0', 'gendan', '跟单', '/index.php/gendan/kehu_gendan', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('2', '1', '0', 'linkman', '联系人', '/index.php/linkman', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('3', '1', '0', 'info', '详细资料', '/index.php/kehu/info', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('4', '1', '0', 'hetong', '合同', '/index.php/hetong', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('5', '1', '0', 'kaipiao', '开票', '/index.php/kaipiao', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('6', '1', '0', 'caiwu', '款项', '/index.php/caiwu', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('7', '1', '0', 'huifang', '回访', '/index.php/huifang', '是', '50', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('8', '1', '0', 'share', '客户共享', '/index.php/kehu/share', '是', '100', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('9', '1', '0', 'userlog', '操作日志', '/index.php/userlog/kehu_userlog', '是', '100', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('10', '1', '0', 'call', '通话记录', '/index.php/callrecord', '是', '100', '0');
INSERT INTO `qmcrm_menu_kehu` VALUES ('11', '1', '0', 'gongdan', '工单管理', '/index.php/gongdan', '是', '60', '0');

-- ----------------------------
-- Table structure for qmcrm_message
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_message`;
CREATE TABLE `qmcrm_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `model` varchar(255) DEFAULT NULL,
  `xid` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT '',
  `content` text,
  `backurl` text,
  `showtime` datetime DEFAULT NULL,
  `show_web` tinyint(1) DEFAULT '0',
  `show_app` tinyint(1) DEFAULT '0',
  `show_dingding` tinyint(1) DEFAULT '0',
  `show_wechat` tinyint(1) DEFAULT '0',
  `isread` tinyint(1) DEFAULT '0',
  `readtime` datetime DEFAULT NULL,
  `reply` text,
  `replytime` datetime DEFAULT NULL,
  `touser` varchar(255) DEFAULT NULL,
  `touid` int(11) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_message
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_message_set
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_message_set`;
CREATE TABLE `qmcrm_message_set` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `model` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `tips` varchar(255) DEFAULT NULL,
  `content` text,
  `inuse` varchar(255) DEFAULT NULL,
  `ordnum` int(11) DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_message_set
-- ----------------------------
INSERT INTO `qmcrm_message_set` VALUES ('1', 'kehu', 'kehu_zhuanyi', '客户转移', null, '是', '50', '0');
INSERT INTO `qmcrm_message_set` VALUES ('2', 'gendan', 'gendan_tixing', '跟单提醒', null, '是', '50', '0');
INSERT INTO `qmcrm_message_set` VALUES ('3', 'hetong', 'hetong_daoqi01', '合同即将到期', null, '是', '50', '0');
INSERT INTO `qmcrm_message_set` VALUES ('4', 'gonghai', 'gonghai_fenpei', '公海分配', null, '是', '50', '0');
INSERT INTO `qmcrm_message_set` VALUES ('5', 'gonghai', 'gonghai_daishenhe', '公海待审核', null, '是', '50', '0');
INSERT INTO `qmcrm_message_set` VALUES ('6', 'gonghai', 'gonghai_yishenhe', '公海已审核', null, '是', '50', '0');
INSERT INTO `qmcrm_message_set` VALUES ('7', 'gongdan', 'gongdan_canyu', '工单指定参与', null, '是', '50', '0');

-- ----------------------------
-- Table structure for qmcrm_qingjia
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_qingjia`;
CREATE TABLE `qmcrm_qingjia` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `types` varchar(255) DEFAULT NULL,
  `riqis` datetime DEFAULT NULL,
  `riqis_qf` varchar(255) DEFAULT NULL,
  `riqie` datetime DEFAULT NULL,
  `riqie_qf` varchar(255) DEFAULT NULL,
  `shichang` decimal(11,1) DEFAULT NULL,
  `content` text,
  `fujian_name` text,
  `fujian_url` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `tousers` text,
  `shenhe` tinyint(1) DEFAULT '0',
  `shenhebeizhu` text,
  `shenheuser` varchar(255) DEFAULT NULL,
  `shenhetime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_qingjia
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_sms
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_sms`;
CREATE TABLE `qmcrm_sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `types` varchar(255) DEFAULT '',
  `mobile` varchar(255) DEFAULT '',
  `content` text,
  `sendtime` datetime DEFAULT NULL,
  `senduser` varchar(255) DEFAULT NULL,
  `state` tinyint(1) DEFAULT '1',
  `backjson` text,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_sms
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_sms_template
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_sms_template`;
CREATE TABLE `qmcrm_sms_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `inuse` varchar(255) DEFAULT NULL,
  `leixing` varchar(255) DEFAULT NULL,
  `duixiang` varchar(255) DEFAULT NULL,
  `tousers` text,
  `hetong_daoqi_tianshu` int(11) DEFAULT NULL,
  `mbid` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `state` tinyint(1) DEFAULT '0',
  `backjson` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_sms_template
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_theme
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_theme`;
CREATE TABLE `qmcrm_theme` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `themeurl` text,
  `beizhu` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_theme
-- ----------------------------
INSERT INTO `qmcrm_theme` VALUES ('1', '/theme/qmsoft/images/bg/bg1.jpg', '系统壁纸', null, null, '0');
INSERT INTO `qmcrm_theme` VALUES ('2', '/theme/qmsoft/images/bg/bg2.jpg', '系统壁纸', null, null, '0');
INSERT INTO `qmcrm_theme` VALUES ('3', '/theme/qmsoft/images/bg/bg3.jpg', '系统壁纸', null, null, '0');
INSERT INTO `qmcrm_theme` VALUES ('4', '/theme/qmsoft/images/bg/bg4.jpg', '系统壁纸', null, null, '0');

-- ----------------------------
-- Table structure for qmcrm_user
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_user`;
CREATE TABLE `qmcrm_user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `realname` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `userpwd` varchar(255) DEFAULT NULL,
  `groupid` int(11) DEFAULT '0',
  `roleid` tinyint(1) DEFAULT '1',
  `lever` text,
  `manage` text,
  `iszhuguan` varchar(255) DEFAULT '0',
  `maxnum` int(11) DEFAULT '0',
  `maxnum_paichu_cj` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT '',
  `email` varchar(255) DEFAULT '',
  `avatar` text,
  `content_user` text,
  `bianqian` text,
  `theme` varchar(255) DEFAULT NULL,
  `theme_id` int(11) DEFAULT NULL,
  `theme_color` varchar(255) DEFAULT NULL,
  `desk_grzl` tinyint(4) DEFAULT '1',
  `desk_zmbq` tinyint(4) DEFAULT '1',
  `desk_zmtx` tinyint(4) DEFAULT '1',
  `hasyjtj` varchar(255) DEFAULT '是',
  `hasim` tinyint(1) DEFAULT '1',
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `state` tinyint(1) DEFAULT '1',
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_user
-- ----------------------------
INSERT INTO `qmcrm_user` VALUES ('1', '超级管理员', 'admin', '2e4c7aff6af885933505e4acfffcdf1d', '1', '0', null, null, '0', '0', null, '', '', '/theme/qmsoft/images/noicon.png', null, '今天还有一些工作没做，怎么办才好呢？', null, null, null, '1', '1', '1', '是', '1', null, '2024-10-23 14:26:32', '1', '0', null);
INSERT INTO `qmcrm_user` VALUES ('2', '张三', '张三', '185e9e3eebe73d7f68a5107acea061bd', '5', '2', '191,192,1,2,3,5,6,7,8,9,11,12,13,21,22,23,26,31,32,33,35,36,37,39,1008,41,42,43,51,52,53,55,58,61,62,63,64,68,71,72,73,75,76,77,78,1001,1003,81,82,181,182,183,184,185,187,188,189,190,91,92,93,101,102,103,111,112,113,121,122,123,125,131,132,133,235,236,238,239,151,152,215,222,226,227,228,161,171,1006,1007', null, '是', '0', '否', '', '', '/theme/qmsoft/images/noicon.png', '密码：111111', null, null, null, null, '1', '1', '1', '是', '1', null, '2024-10-23 14:26:32', '1', '0', null);
INSERT INTO `qmcrm_user` VALUES ('3', '李四', '李四', '185e9e3eebe73d7f68a5107acea061bd', '5', '4', '1,2,3,6,7,11,12,13,21,22,23,31,32,33,41,61,62,63,71,72,73,75,111,112,121,122,131,132,215,221,222,226,227,228,235,236,238,239,250,161,171', null, '否', '0', '否', '', '', '/theme/qmsoft/images/noicon.png', '密码：111111', null, null, null, null, '1', '1', '1', '是', '1', null, '2024-10-23 14:26:32', '1', '0', null);

-- ----------------------------
-- Table structure for qmcrm_userlog
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_userlog`;
CREATE TABLE `qmcrm_userlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `model` varchar(255) DEFAULT '',
  `xid` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT '',
  `action` varchar(255) DEFAULT '',
  `reason` text,
  `ywyuser` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT '',
  `addtime` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT '',
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_userlog
-- ----------------------------
INSERT INTO `qmcrm_userlog` VALUES ('1', '客户', '1', '1', '客户1', '新增', '备注：', '张三', '张三', '2024-10-23 14:26:32', '127.0.0.1', '0');
INSERT INTO `qmcrm_userlog` VALUES ('2', '跟单', '1', '1', '客户1', '新增', '跟单备注：客户有购买意向', '张三', '张三', '2024-10-23 14:26:32', '127.0.0.1', '0');
INSERT INTO `qmcrm_userlog` VALUES ('3', '合同', '1', '1', '客户1', '新增', '合同备注：客户很爽快', '张三', '张三', '2024-10-23 14:26:32', '127.0.0.1', '0');
INSERT INTO `qmcrm_userlog` VALUES ('4', '客户', '2', '2', '客户2', '新增', '备注：', '李四', '李四', '2024-10-23 14:26:32', '127.0.0.1', '0');
INSERT INTO `qmcrm_userlog` VALUES ('5', '跟单', '2', '2', '客户2', '新增', '跟单备注：客户说不需要', '李四', '李四', '2024-10-23 14:26:32', '127.0.0.1', '0');
INSERT INTO `qmcrm_userlog` VALUES ('6', '合同', '1', '1', '客户1', '收款', '合同备注：1', null, '超级管理员', '2024-10-23 14:26:32', '127.0.0.1', '0');
INSERT INTO `qmcrm_userlog` VALUES ('7', '客户', '3', '3', '公海客户可领取', '新增', '备注：', '超级管理员', '超级管理员', '2024-10-23 14:26:32', '127.0.0.1', '0');

-- ----------------------------
-- Table structure for qmcrm_userloginlog
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_userloginlog`;
CREATE TABLE `qmcrm_userloginlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `type` varchar(255) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT '',
  `addtime` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT '',
  `isok` tinyint(4) DEFAULT '1',
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_userloginlog
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_user_group
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_user_group`;
CREATE TABLE `qmcrm_user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `parentid` int(11) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '',
  `zhuguan` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '',
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_user_group
-- ----------------------------
INSERT INTO `qmcrm_user_group` VALUES ('1', '0', '总经办', '', '0', null);
INSERT INTO `qmcrm_user_group` VALUES ('2', '0', '业务部', '', '0', null);
INSERT INTO `qmcrm_user_group` VALUES ('3', '0', '财务部', '', '0', null);
INSERT INTO `qmcrm_user_group` VALUES ('4', '0', '客服部', '', '0', null);
INSERT INTO `qmcrm_user_group` VALUES ('5', '2', '业务一部', '', '0', null);
INSERT INTO `qmcrm_user_group` VALUES ('6', '2', '业务二部', '', '0', null);

-- ----------------------------
-- Table structure for qmcrm_user_role
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_user_role`;
CREATE TABLE `qmcrm_user_role` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lever` text COLLATE utf8_unicode_ci,
  `right` int(11) DEFAULT '0',
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_user_role
-- ----------------------------
INSERT INTO `qmcrm_user_role` VALUES ('1', '总经理', '1,2,3,4,5,6,7,8,9,11,12,13,14,21,22,23,24,26,31,32,33,34,35,36,37,39,1008,1009,402,403,404,405,1011,41,42,43,51,52,53,54,55,58,1012,61,62,63,64,68,71,72,73,74,75,76,77,78,1001,1003,81,82,83,91,92,93,94,95,1004,1005,101,102,103,104,330,331,332,333,334,181,182,183,184,185,188,187,189,190,111,112,113,114,270,271,272,273,280,281,282,283,290,291,292,293,300,301,302,303,121,122,123,124,125,131,132,133,134,151,152,153,235,236,237,238,239,240,191,195,196,192,193,194,1002,204,208,215,222,161,226,227,228,1006,1007,171,310,311,320,321,322,323,324,325,327,401,328,329', null, '0', null);
INSERT INTO `qmcrm_user_role` VALUES ('2', '部门主管', '1,2,3,5,6,7,8,9,11,12,13,21,22,23,26,31,32,33,35,36,37,39,1008,1009,403,1011,41,42,43,406,51,52,53,55,58,1012,61,62,63,64,68,71,72,73,75,76,77,78,1001,1003,81,82,91,92,93,101,102,103,181,182,183,184,185,188,187,410,189,190,111,112,113,270,271,272,280,281,282,290,291,292,300,301,302,121,122,123,125,131,132,133,151,152,235,236,238,239,191,192,215,222,161,226,227,228,1006,1007,171,310,311,320,321,322,324,325,401,328,329', '0', '0', null);
INSERT INTO `qmcrm_user_role` VALUES ('3', '客服专员', '1,2,3,11,12,13,21,22,31,32,41,42,51,52,61,62,71,72,181,182,183,184,185,188,187,111,112,270,271,280,281,290,291,300,301,121,122,123,131,132,235,236,238,239,215,222,161,226,227,228,171,310,311,320,321', '0', '0', null);
INSERT INTO `qmcrm_user_role` VALUES ('4', '销售经理', '1,2,3,6,7,11,12,13,21,22,23,31,32,33,41,42,61,62,63,71,72,73,75,181,182,183,184,185,188,187,410,189,190,111,112,270,271,280,281,290,291,300,301,121,122,131,132,235,236,238,239,215,222,161,226,227,228,171,310,311,320,321,322,324,325,401', '0', '0', null);
INSERT INTO `qmcrm_user_role` VALUES ('6', '销售员', '1,2,3,11,12,13,21,22,23,31,32,33,37,41,42,406,61,62,71,72,75,181,182,183,184,111,112,270,271,280,281,290,291,300,301,121,122,131,132,310,311,320,321,324,325', '0', '0', null);

-- ----------------------------
-- Table structure for qmcrm_yejimubiao
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_yejimubiao`;
CREATE TABLE `qmcrm_yejimubiao` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `realname` varchar(255) DEFAULT NULL,
  `nian` varchar(255) DEFAULT NULL,
  `yue01` decimal(11,2) DEFAULT NULL,
  `yue02` decimal(11,2) DEFAULT NULL,
  `yue03` decimal(11,2) DEFAULT NULL,
  `yue04` decimal(11,2) DEFAULT NULL,
  `yue05` decimal(11,2) DEFAULT NULL,
  `yue06` decimal(11,2) DEFAULT NULL,
  `yue07` decimal(11,2) DEFAULT NULL,
  `yue08` decimal(11,2) DEFAULT NULL,
  `yue09` decimal(11,2) DEFAULT NULL,
  `yue10` decimal(11,2) DEFAULT NULL,
  `yue11` decimal(11,2) DEFAULT NULL,
  `yue12` decimal(11,2) DEFAULT NULL,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `upduser` varchar(255) DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_yejimubiao
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_zhishiku
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_zhishiku`;
CREATE TABLE `qmcrm_zhishiku` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `types` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `fujian_name` text,
  `fujian_url` text,
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `upduser` varchar(255) DEFAULT NULL,
  `updtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  `deltime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qmcrm_zhishiku
-- ----------------------------

-- ----------------------------
-- Table structure for qmcrm_ziduan
-- ----------------------------
DROP TABLE IF EXISTS `qmcrm_ziduan`;
CREATE TABLE `qmcrm_ziduan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '企孟软件版权所有',
  `table_name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `content` text,
  `glzd_kehu` text,
  `default_val` text,
  `tip` varchar(255) DEFAULT NULL,
  `maxlimit` int(11) DEFAULT NULL,
  `inuse` varchar(255) DEFAULT NULL,
  `xitong` tinyint(1) DEFAULT '0',
  `guding` tinyint(1) DEFAULT '0',
  `biaodan` tinyint(1) DEFAULT NULL,
  `bitian` tinyint(1) DEFAULT NULL,
  `bd_teshu` tinyint(1) DEFAULT NULL,
  `liebiao` tinyint(1) DEFAULT NULL,
  `lb_teshu` tinyint(1) DEFAULT '0',
  `sousuo` tinyint(1) DEFAULT NULL COMMENT '1 =，2 like，3 datetime',
  `ss_style` tinyint(1) DEFAULT NULL,
  `dao` tinyint(1) DEFAULT '1',
  `lie_width` int(11) DEFAULT NULL,
  `qx_lock` tinyint(4) DEFAULT '0',
  `qx_view` text,
  `qx_add` text,
  `qx_edit` text,
  `ord` int(11) DEFAULT '50',
  `adduser` varchar(255) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `isdel` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qmcrm_ziduan
-- ----------------------------
INSERT INTO `qmcrm_ziduan` VALUES ('1', 'kehu', '客户名称', 'name', 'text', '', null, null, '', null, '是', '1', '1', '1', '1', '1', '0', null, '1', '2', '1', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('2', 'kehu', '是否成交', 'chengjiao', 'yes', '', null, null, '', null, '是', '1', '1', '0', '0', '1', '1', '1', '1', '1', '0', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('3', 'kehu', '客户类型', 'type', 'select', 'A 重点客户|B 一般客户|C 渠道客户|D 开发中', null, null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', '200', '0', null, null, null, '10', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('4', 'kehu', '联系人', 'linkman', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', null, '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('5', 'kehu', '手机号码', 'mobile', 'text', '', null, null, '', null, '是', '1', '0', '1', '1', '1', '1', null, '1', '2', '1', null, '0', null, null, null, '30', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('6', 'kehu', '电子邮箱', 'email', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '0', null, '1', '2', '1', null, '0', null, null, null, '40', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('7', 'kehu', '客户来源', 'laiyuan', 'select', '搜索引擎|广告投放|活动促销|转介绍|在线咨询|在线注册|电话营销|陌拜', null, null, '', null, '是', '1', '0', '1', '0', null, '1', '0', '1', '1', '1', '0', '0', null, null, null, '50', '', null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('8', 'kehu', '所在地区', 'area', 'area', null, null, null, null, null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', null, '0', null, null, null, '60', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('9', 'kehu', '详细地址', 'address', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '0', null, '1', '2', '1', null, '0', null, null, null, '70', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('10', 'kehu', '备注', 'content', 'textarea', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '200', '0', null, null, null, '500', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('11', 'kehu', '上次跟单时间', 'last_gendan_time', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, '', null, '是', '1', '0', '1', '0', '1', '1', '0', '1', '3', '0', '0', '0', null, null, null, '800', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('12', 'kehu', '下次联系时间', 'next_gendan_time', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, '', null, '是', '1', '0', '1', '1', '1', '1', '0', '1', '3', '0', '0', '0', null, null, null, '800', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('13', 'kehu', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, '', null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('14', 'kehu', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('15', 'kehu', '创建者', 'adduser', 'users', '', null, null, '', null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('16', 'kehu', '业务员', 'nowuser', 'users', '', null, null, '', null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('17', 'linkman', '客户名称', 'name', 'text', '', null, null, '', null, '是', '1', '1', '1', '1', '1', '0', null, '1', '2', '1', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('18', 'linkman', '联系人', 'linkman', 'text', null, null, null, null, null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('19', 'linkman', '性别', 'sex', 'select', '先生|女士', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('20', 'linkman', '职位', 'job', 'select', '老板|董事长|总经理|项目负责人|业务员|技术员|未知', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('21', 'linkman', '手机号', 'mobile', 'text', null, null, null, null, null, '是', '1', '0', '1', '1', '1', '1', null, '1', '2', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('22', 'linkman', '邮箱', 'email', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('23', 'linkman', 'QQ', 'qq', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('24', 'linkman', '生日', 'birthday', 'datetime', 'yyyy-MM-dd', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '3', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('25', 'linkman', '备注', 'content', 'textarea', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '50', '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('26', 'linkman', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('27', 'linkman', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('28', 'linkman', '创建者', 'adduser', 'users', '', null, null, '', null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('29', 'linkman', '业务员', 'nowuser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('30', 'gendan', '客户名称', 'name', 'text', '', null, null, '', null, '是', '1', '1', '1', '1', '1', '0', null, '1', '2', '1', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('31', 'gendan', '跟单联系人', 'linkman', 'linkman', '', null, null, '', null, '是', '1', '0', '1', '1', null, '1', null, null, null, '1', null, '0', null, null, null, '10', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('32', 'gendan', '跟单方式', 'type', 'select', '电话跟进|上门拜访|QQ交谈|Email邮件', null, null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', null, '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('33', 'gendan', '跟单进度', 'state', 'select', '初次沟通|有意向|考虑购买|结束跟单', null, null, null, null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', null, '0', null, null, null, '30', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('34', 'gendan', '下次联系', 'nexttime', 'datetime', 'yyyy-MM-dd HH:mm', null, null, null, null, '是', '1', '0', '1', '0', '1', '1', null, '1', '3', '1', null, '0', null, null, null, '40', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('35', 'gendan', '备注', 'content', 'textarea', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '50', '0', null, null, null, '500', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('38', 'gendan', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('39', 'gendan', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('40', 'gendan', '创建者', 'adduser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('41', 'gendan', '业务员', 'nowuser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('42', 'hetong', '客户名称', 'name', 'text', '', null, null, '', null, '是', '1', '1', '1', '1', '1', '0', null, '1', '2', '1', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('43', 'hetong', '客户联系人', 'linkman', 'linkman', '', '', null, '', null, '是', '1', '1', '1', '0', null, '1', null, '0', '1', '1', '0', '0', null, null, null, '10', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('44', 'hetong', '合同编号', 'number', 'text', '', null, null, '', null, '是', '1', '0', '1', '1', '1', '1', null, '1', '2', '1', null, '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('45', 'hetong', '合同类型', 'httype', 'select', '服务合同|买卖合同|工程合同|代理合同', '', null, '', null, '是', '1', '0', '1', '0', null, '0', '0', '1', '1', '1', '0', '0', null, null, null, '30', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('47', 'hetong', '开始日期', 'stime', 'datetime', 'yyyy-MM-dd', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '3', '1', '0', '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('48', 'hetong', '结束日期', 'etime', 'datetime', 'yyyy-MM-dd', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '3', '1', '0', '0', null, null, null, '60', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('49', 'hetong', '总金额', 'money', 'money', '', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '0', '1', '1', '0', '0', null, null, null, '70', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('50', 'hetong', '已收款', 'ysmoney', 'money', '', '', null, '', null, '是', '1', '0', '1', '0', null, '1', null, '0', '1', '1', '200', '1', null, null, null, '80', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('51', 'hetong', '欠款', 'qkmoney', 'money', '', '', null, '', null, '是', '1', '0', '1', '0', null, '1', null, '0', '1', '1', '200', '1', null, null, null, '90', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('52', 'hetong', '开票金额', 'kaipiao_jine', 'money', '', null, null, null, null, '是', '1', '0', '0', '0', '1', '0', '0', '0', '1', '0', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('53', 'hetong', '备注', 'content', 'textarea', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '50', '0', null, null, null, '500', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('54', 'hetong', '审核', 'shenhe', 'radio', '合同有效|合同无效|待审', null, '待审', null, null, '是', '1', '0', '0', '1', null, '1', '1', '1', '1', '1', null, '1', null, null, null, '510', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('55', 'hetong', '审核备注', 'shenhebeizhu', 'textarea', null, null, null, null, null, '是', '1', '0', '0', '0', null, '1', null, null, null, '1', null, '1', null, null, null, '520', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('56', 'hetong', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('57', 'hetong', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('58', 'hetong', '创建者', 'adduser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('59', 'hetong', '业务员', 'nowuser', 'users', '', '', null, '', null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', '0', '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('60', 'huifang', '客户名称', 'name', 'text', '', null, null, '', null, '是', '1', '1', '1', '1', '1', '0', null, '1', '2', '1', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('61', 'huifang', '联系人', 'linkman', 'linkman', '', null, null, '', null, '是', '1', '0', '1', '1', null, '1', null, null, null, '1', null, '0', null, null, null, '10', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('62', 'huifang', '回访分类', 'type', 'select', '节日问候|优惠促销', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', '0', '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('63', 'huifang', '回访主题', 'title', 'text', '', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '2', '1', '0', '0', null, null, null, '30', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('64', 'huifang', '回访备注', 'content', 'textarea', '', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '2', '1', '50', '0', null, null, null, '500', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('65', 'huifang', '回访日期', 'stime', 'datetime', 'yyyy-MM-dd', '', null, '', null, '是', '1', '0', '1', '1', null, '1', null, '1', '3', '1', '0', '0', null, null, null, '40', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('66', 'huifang', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('67', 'huifang', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('68', 'huifang', '创建者', 'adduser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('69', 'huifang', '业务员', 'nowuser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('70', 'caiwu', '关联客户', 'name', 'text', '', null, null, '', null, '是', '1', '1', '1', '1', '1', '0', null, '1', '2', '1', null, '1', null, null, null, '0', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('71', 'caiwu', '关联项目', 'model', 'text', '', null, null, '', null, '是', '1', '1', '1', '0', '1', '1', '1', null, null, '0', null, '0', null, null, null, '10', null, null, '1');
INSERT INTO `qmcrm_ziduan` VALUES ('72', 'caiwu', '关联id', 'xid', 'text', '', null, null, '', null, '是', '1', '1', '1', '0', '1', '0', '0', null, null, '0', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('73', 'caiwu', '收入/支出', 'outin', 'yes', null, null, null, null, null, '是', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', null, '1', null, null, null, '30', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('74', 'caiwu', '收支类别', 'type', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', '0', '1', null, null, null, '1', null, '0', null, null, null, '40', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('75', 'caiwu', '收入类别', 'type1', 'select', '合同款|合同续费|维护费|其它', null, null, '', null, '是', '1', '0', '1', '0', '0', '1', '1', '1', '1', '0', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('76', 'caiwu', '支出类别', 'type0', 'select', '交通费|通讯费|餐饮住宿|赠送礼品|采购|其它', null, null, '', null, '是', '1', '0', '1', '0', '0', '1', '1', '1', '1', '0', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('77', 'caiwu', '收支金额', 'money', 'money', null, null, null, '[金额确定后无法修改]', null, '是', '1', '0', '1', '1', '1', '1', null, null, null, '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('78', 'caiwu', '备注', 'content', 'textarea', null, null, null, null, null, '是', '1', '0', '1', '1', null, '1', null, '1', '2', '1', '50', '0', null, null, null, '500', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('79', 'caiwu', '收支方式', 'szfs', 'select', '现金|对公账户|支付宝|微信|其它', null, null, '', null, '是', '1', '0', '1', '0', '0', '1', '1', '1', '1', '0', null, '0', null, null, null, '60', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('80', 'caiwu', '合同订单', 'xcode', 'text', '', null, null, '', null, '是', '1', '1', '1', '0', '1', '1', '0', '1', '1', '0', null, '0', null, null, null, '10', '', null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('81', 'caiwu', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('82', 'caiwu', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('83', 'caiwu', '创建者', 'adduser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('84', 'caiwu', '业务员', 'nowuser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('85', 'chanpin', '产品大类', 'class1', 'text', '', null, null, '', null, '是', '1', '0', '1', '1', '1', '1', null, '1', '1', '1', null, '0', null, null, null, '2', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('86', 'chanpin', '产品小类', 'class2', 'text', '', null, null, '', null, '是', '1', '0', '1', '1', '1', '1', null, '1', '1', '1', null, '0', null, null, null, '3', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('87', 'chanpin', '产品名称', 'name', 'text', '', null, null, '', null, '是', '1', '0', '1', '1', null, '0', null, '1', '2', '1', null, '1', null, null, null, '1', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('88', 'chanpin', '缩略图', 'pic', 'upload_img', '', null, null, '', null, '是', '1', '0', '1', '0', '1', '1', '1', null, null, '1', null, '0', null, null, null, '10', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('89', 'chanpin', '型号', 'xinghao', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '0', '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('90', 'chanpin', '规格', 'guige', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '0', '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('91', 'chanpin', '单位', 'danwei', 'text', '', null, null, '', null, '是', '1', '0', '1', '0', null, '1', null, '1', '1', '1', null, '0', null, null, null, '40', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('92', 'chanpin', '库存数量', 'kucun', 'number2', '', null, null, '', null, '是', '1', '0', '1', '1', null, '1', null, null, null, '1', null, '0', null, null, null, '30', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('93', 'chanpin', '成本价', 'chengben', 'money', '', null, null, null, null, '是', '1', '0', '1', '0', null, '1', null, null, null, '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('94', 'chanpin', '售价', 'shoujia', 'money', '', null, null, null, null, '是', '1', '0', '1', '1', null, '1', null, null, null, '1', null, '0', null, null, null, '60', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('95', 'chanpin', '备注', 'content', 'textarea', '', null, null, null, null, '是', '1', '0', '1', '0', null, '1', null, '1', '2', '1', '50', '0', null, null, null, '500', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('96', 'chanpin', '录入时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '1', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('97', 'chanpin', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('98', 'chanpin', '创建者', 'adduser', 'users', null, null, null, null, null, '是', '1', '0', '0', '1', null, '0', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('99', 'chanpin', '业务员', 'nowuser', 'users', '', null, null, '', null, '是', '1', '0', '0', '1', null, '1', null, '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('100', 'gonggao', '公告分类', 'class', 'select', '公司公告|规章制度', null, null, null, null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('101', 'files', '文件分类', 'class', 'select', '我的文件|工作存档', null, null, null, null, '是', '1', '0', '1', '1', null, '1', null, '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('102', 'zhishiku', '请假类型', 'types', 'select', '销售话术|成单技巧|行业分析', null, null, null, null, '是', '1', '0', '1', '1', null, '1', '0', '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('103', 'kaoqin', '签到类型', 'types', 'select', '上班|下班|加班', null, null, null, null, '是', '1', '0', '1', '1', null, '1', '0', '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('104', 'qingjia', '请假类型', 'types', 'select', '年假|事假|病假|调休假|婚假|产假|陪产假|其他', null, null, null, null, '是', '1', '0', '1', '1', null, '1', '0', '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('105', 'feiyongbx', '报销类型', 'types', 'select', '差旅费|交通费|招待费|垫付费用|其他', null, null, null, null, '是', '1', '0', '1', '1', null, '1', '0', '1', '1', '1', null, '0', null, null, null, '50', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('106', 'gongdan', '客户名称', 'name', 'text', '', null, null, null, null, '是', '1', '1', '1', '0', '1', '0', '1', '1', '1', '1', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('107', 'gongdan', '联系人', 'linkman', 'linkman', '', null, null, null, null, '是', '1', '0', '1', '0', '0', '1', '0', '1', '1', '1', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('108', 'gongdan', '工单类型', 'leixing', 'select', '出差洽谈|售后安装|售后维护|故障报修|客户投诉|临时工单', null, null, null, null, '是', '1', '0', '1', '1', '0', '1', '0', '1', '1', '1', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('109', 'gongdan', '工单主题', 'title', 'text', '', null, null, null, null, '是', '1', '0', '1', '1', '0', '1', '0', '1', '1', '1', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('110', 'gongdan', '指派人员', 'renyuan', 'users_duo', '', null, null, null, null, '是', '1', '0', '1', '1', '0', '1', '0', '1', '1', '1', '200', '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('111', 'gongdan', '起始时间', 'stime', 'datetime', 'yyyy-MM-dd HH:mm', null, null, null, null, '是', '1', '0', '1', '0', '0', '1', '0', '1', '3', '1', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('112', 'gongdan', '结束时间', 'etime', 'datetime', 'yyyy-MM-dd HH:mm', null, null, null, null, '是', '1', '0', '1', '0', '0', '1', '0', '1', '3', '1', null, '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('113', 'gongdan', '工作内容', 'content', 'textedit', '', null, null, null, null, '是', '1', '0', '1', '1', '0', '1', '0', '1', '1', '1', '200', '0', null, null, null, '100', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('114', 'gongdan', '工单附件', 'fujian', 'upload_files', '', null, null, null, null, '是', '1', '0', '1', '0', '0', '1', '0', '1', '1', '0', null, '0', null, null, null, '300', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('115', 'gongdan', '工作记录', 'gongdan_gzjl', 'btn', '', null, null, null, null, '是', '1', '0', '0', '0', '1', '1', '1', '0', '0', '0', null, '0', null, null, null, '300', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('116', 'gongdan', '业务员', 'nowuser', 'users', '', null, null, null, null, '是', '1', '0', '0', '1', '0', '0', '0', '1', '1', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('117', 'gongdan', '创建者', 'adduser', 'users', '', null, null, null, null, '是', '1', '0', '0', '1', '0', '1', '0', '1', '1', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('118', 'gongdan', '创建时间', 'addtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', '0', '1', '0', '1', '3', '1', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('119', 'gongdan', '更新时间', 'updtime', 'datetime', 'yyyy-MM-dd HH:mm:ss', null, null, null, null, '是', '1', '0', '0', '1', '0', '0', '0', '1', '3', '0', null, '1', null, null, null, '999', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('120', 'hetong', '产品', 'hetong_chanpin', 'btn', '', null, null, null, null, '是', '1', '0', '0', '0', '1', '1', '1', '0', '0', '0', null, '0', null, null, null, '530', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('121', 'caiwu', '关联供应商', 'gysname', 'text', '', null, null, null, null, '是', '1', '0', '0', '0', '1', '1', '0', '1', '2', '0', null, '0', null, null, null, '20', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('122', 'huifang', '处理状态', 'shenhe', 'btn', '已处理|处理中|未处理', null, null, null, null, '是', '1', '0', '0', '0', '1', '1', '1', '0', '0', '0', null, '0', null, null, null, '600', null, null, '0');
INSERT INTO `qmcrm_ziduan` VALUES ('123', 'gongdan', '处理状态', 'shenhe', 'btn', '已处理|处理中|未处理', null, null, null, null, '是', '1', '0', '0', '0', '1', '1', '1', '0', '0', '0', null, '0', null, null, null, '200', null, null, '0');
