/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50525
Source Host : localhost:3306
Source Database : communicationcrm
Target Server Type : MYSQL
Target Server Version : 50525
File Encoding : 65001
Date: 2018-06-11 08:35:00
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_contract`
-- ----------------------------
DROP TABLE IF EXISTS `t_contract`;
CREATE TABLE `t_contract` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`sn` varchar(255) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`signTime` date DEFAULT NULL,
`seller_id` bigint(20) DEFAULT NULL,
`sum` decimal(10,2) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_contract
-- ----------------------------
INSERT INTO `t_contract` VALUES ('9', 'HT2786220180605155904', '2', '2018-06-05', '6', '1000000.00', '1');
INSERT INTO `t_contract` VALUES ('10', 'HT1585920180605162438', '6', '2018-06-05', '6', '2000000.00', '1');
INSERT INTO `t_contract` VALUES ('11', 'HT7860320180605162837', '3', '2018-06-05', '6', '1000000.00', '1');
INSERT INTO `t_contract` VALUES ('12', 'HT2330020180605162906', '7', '2018-06-05', '6', '500000.00', '1');
INSERT INTO `t_contract` VALUES ('13', 'HT7477220180605162936', '33', '2018-06-05', '6', '200000.00', '1');
INSERT INTO `t_contract` VALUES ('14', 'HT7038520180605162942', '31', '2018-06-05', '6', '1000.00', '1');
INSERT INTO `t_contract` VALUES ('15', 'HT9283620180605162948', '27', '2018-06-05', '6', '5000.00', '1');
INSERT INTO `t_contract` VALUES ('16', 'HT2809920180605162953', '18', '2018-06-05', '6', '200000.00', '1');
INSERT INTO `t_contract` VALUES ('17', 'HT2810320180605162958', '15', '2018-06-05', '6', '1000000.00', '1');
INSERT INTO `t_contract` VALUES ('18', 'HT2419820180605163005', '20', '2018-06-05', '6', '400000.00', '1');
INSERT INTO `t_contract` VALUES ('19', 'HT7426620180605163021', '29', '2018-06-05', '6', '1000.00', '1');
INSERT INTO `t_contract` VALUES ('20', 'HT3777620180605163028', '28', '2018-06-05', '6', '900.00', '1');
INSERT INTO `t_contract` VALUES ('21', 'HT2741120180605163620', '39', '2018-06-05', '6', '1000000.00', '1');
INSERT INTO `t_contract` VALUES ('22', 'HT1592020180605163628', '38', '2018-06-05', '6', '50000.00', '1');
INSERT INTO `t_contract` VALUES ('23', 'HT7814520180605163635', '36', '2018-06-05', '6', '2000000.00', '1');
INSERT INTO `t_contract` VALUES ('24', 'HT4970920180605164034', '14', '2018-06-05', '6', '900000.00', '1');
INSERT INTO `t_contract` VALUES ('25', 'HT3114820180605201626', '5', '2018-06-05', '6', '1000000.00', '1');
INSERT INTO `t_contract` VALUES ('26', 'HT7517220180605204203', '9', '2018-06-05', '6', '1000.00', '1');
INSERT INTO `t_contract` VALUES ('27', 'HT4027920180606102507', '12', '2018-06-06', '6', '2000.00', '1');
INSERT INTO `t_contract` VALUES ('28', 'HT4576520180606102724', '34', '2018-06-06', '6', '2000000.00', '1');
-- ----------------------------
-- Table structure for `t_contractitem`
-- ----------------------------
DROP TABLE IF EXISTS `t_contractitem`;
CREATE TABLE `t_contractitem` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`contract_id` bigint(20) DEFAULT NULL,
`payTime` date DEFAULT NULL,
`money` decimal(10,2) DEFAULT NULL,
`scale` varchar(255) DEFAULT NULL,
`intro` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_contractitem
-- ----------------------------
INSERT INTO `t_contractitem` VALUES ('10', '9', '2018-06-05', '100000.00', '10.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('11', '9', '2018-06-05', '50000.00', '5.00%', '', '1');
INSERT INTO `t_contractitem` VALUES ('12', '9', '2018-06-05', '100000.00', '10.00%', '', '1');
INSERT INTO `t_contractitem` VALUES ('13', '9', '2018-06-05', '80000.00', '8.00%', '', '1');
INSERT INTO `t_contractitem` VALUES ('14', '9', '2018-06-05', '500000.00', '50.00%', '', '1');
INSERT INTO `t_contractitem` VALUES ('15', '10', '2018-06-05', '400000.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('16', '11', '2018-06-05', '200000.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('17', '12', '2018-06-05', '50000.00', '10.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('18', '13', '2018-06-05', '10000.00', '5.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('19', '14', '2018-06-05', '200.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('20', '15', '2018-06-05', '1000.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('21', '16', '2018-06-05', '100000.00', '50.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('22', '17', '2018-06-05', '50000.00', '5.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('23', '18', '2018-06-05', '100000.00', '25.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('24', '19', '2018-06-05', '200.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('25', '20', '2018-06-05', '100.00', '11.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('26', '10', '2018-06-05', '100000.00', '5.00%', '', '1');
INSERT INTO `t_contractitem` VALUES ('27', '9', '2018-06-05', '100000.00', '10.00%', '明天付款', '1');
INSERT INTO `t_contractitem` VALUES ('28', '9', '2018-06-05', '70000.00', '7.00%', '', '1');
INSERT INTO `t_contractitem` VALUES ('29', '21', '2018-06-05', '200000.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('30', '22', '2018-06-05', '10000.00', '20.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('31', '23', '2018-06-05', '200000.00', '10.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('32', '24', '2018-06-05', '30000.00', '3.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('33', '25', '2018-06-05', '20000.00', '2.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('34', '26', '2018-06-05', '100.00', '10.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('35', '27', '2018-06-06', '1000.00', '50.00%', null, '1');
INSERT INTO `t_contractitem` VALUES ('36', '28', '2018-06-06', '100000.00', '5.00%', null, '1');
-- ----------------------------
-- Table structure for `t_customer`
-- ----------------------------
DROP TABLE IF EXISTS `t_customer`;
CREATE TABLE `t_customer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`contacts` varchar(255) DEFAULT NULL,
`age` bigint(20) DEFAULT NULL,
`sex` bit(1) DEFAULT NULL,
`tel` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`qq` varchar(255) DEFAULT NULL,
`wechat` varchar(255) DEFAULT NULL,
`inputTime` date DEFAULT NULL,
`inputUser_id` bigint(20) DEFAULT NULL,
`seller_id` bigint(20) DEFAULT NULL,
`job_id` bigint(20) DEFAULT NULL,
`salaryLevel_id` bigint(20) DEFAULT NULL,
`customerSource_id` bigint(20) DEFAULT NULL,
`customerStatus_id` bigint(20) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`pool` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `job_id` (`job_id`),
CONSTRAINT `t_customer_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `t_systemdictionaryitem` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_customer
-- ----------------------------
INSERT INTO `t_customer` VALUES ('1', '用友科技公司', '凯隐', '22', '', '15230805967', '842389033@qq.com', '842389033', 'wang_wyl', '2017-04-14', '6', '7', '9', '12', '40', '22', '1', '1');
INSERT INTO `t_customer` VALUES ('2', '金蝶', '贾克斯', '24', '', '18232953812', '1392214323@qq.com', '1392214323', 'jiakesi', '2018-04-11', '9', '6', '9', '14', '43', '25', '3', '-1');
INSERT INTO `t_customer` VALUES ('3', '华为', '霞洛', '25', '', '15368748954', 'jiakesi@163.com', '849578466', 'jiakesi', '2018-04-11', '6', '8', '9', '15', '43', '24', '3', '-1');
INSERT INTO `t_
毕业设计，通信设备公司客户关系管理系统（此项目为BS架构，使用SSM框架+JSP+Ajax+EasyUI+MySQL）.zip （2000个子文件） 
CustomerController.class 10KB ResourceServiceImpl.class 9KB OrderController.class 7KB PotentialCustomerController.class 6KB LoginController.class 6KB ValidateCode.class 6KB ResourceController.class 5KB UserContext.class 5KB LogString.class 5KB PotentialCustomerServiceImpl.class 5KB EmployeeServiceImpl.class 5KB CustomerServiceImpl.class 5KB GuaranteeItemController.class 4KB ExcelUtil.class 4KB SystemMenuControlle.class 4KB CustomerDevPlanController.class 4KB DepartmentController.class 4KB EmployeeController.class 4KB ContractItemServiceImpl.class 4KB ImageRandServlet.class 4KB PermissionController.class 4KB CustomerTransferController.class 4KB AuthInterceptor.class 4KB RoleServiceImpl.class 4KB ContractServiceImpl.class 4KB PermissionServiceImpl.class 4KB OrderItemController.class 3KB SystemDictionaryTypeController.class 3KB CustomerTraceHistoryController.class 3KB RoleController.class 3KB SystemLogController.class 3KB SystemMenuServiceImpl.class 3KB CustomerDevPlanServiceImpl.class 3KB ContractItemController.class 3KB SendCode.class 3KB SystemLogUtils.class 3KB SystemDictionaryItemController.class 3KB ContractController.class 3KB DepartmentServiceImpl.class 3KB GuaranteeController.class 3KB CustomerTraceHistoryServiceImpl.class 3KB SystemLogServiceImpl.class 3KB DeptServiceTestDemo.class 3KB OrderItemServiceImpl.class 2KB SystemDictionaryTypeServiceImpl.class 2KB SystemDictionaryItemServiceImpl.class 2KB OrderServiceImpl.class 2KB CustomerTransferServiceImpl.class 2KB DeptDAOTestDemo.class 2KB GuaranteetItemServiceImpl.class 2KB SystemMenuTest.class 2KB GuaranteeServiceImpl.class 2KB CustomerDevPlanQuery.class 2KB SystemLogQuery.class 2KB DepartmentQuery.class 2KB PieController.class 2KB PageResult.class 1KB AjaxResult.class 1KB LogicException.class 1KB CheckUserPermissionTag.class 1KB SendEmailTest.class 1KB ICustomerService.class 1KB PieServiceImpl.class 1KB EncryptUtil.class 1KB PotentialCustomerMapper.class 1KB MakeOrderNum.class 1KB IPermissionService.class 1KB PieQuery.class 1KB PermissionMapper.class 1012B IPotentialCustomerService.class 999B CustomerMapper.class 995B EmployeeMapper.class 987B SystemException.class 968B CustomerTraceHistoryMapper.class 949B RoleMapper.class 940B CustomerDevPlanMapper.class 918B SystemMenuMapper.class 914B ICustomerTraceHistoryService.class 895B ICustomerDevPlanService.class 891B SystemDictionaryItemMapper.class 873B IResourceService.class 859B ISystemMenuService.class 842B OrderMapper.class 835B IEmployeeService.class 823B ResourceMapper.class 817B CustomerTransferMapper.class 807B OrderItemMapper.class 800B IOrderService.class 796B SystemDictionaryTypeMapper.class 789B SystemLogMapper.class 780B GuaranteeItemMapper.class 762B IOrderItemService.class 757B ICustomerTransferService.class 757B DepartmentMapper.class 735B IGuaranteeItemService.class 715B IRoleService.class 711B ISystemLogService.class 709B ISystemDictionaryItemService.class 707B ISystemDictionaryTypeService.class 707B IDepartmentService.class 700B共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
