/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 5.5.53 : Database - stufees
*********************************************************************
*/




CREATE DATABASE /*!32312 IF NOT EXISTS*/`stufees` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `stufees`;

/*Table structure for table `stu_admin_access` */


CREATE TABLE `stu_admin_access` (
  `role_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `node_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `group_id` tinyint(3) DEFAULT '0',
  KEY `groupId` (`role_id`),
  KEY `nodeId` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `stu_admin_access` */

insert into `stu_admin_access`(`role_id`,`node_id`,`level`,`pid`,`group_id`) values 

(2,75,2,74,3),

(2,73,2,72,3),

(2,71,2,70,3),

(2,69,2,68,3),

(2,67,2,66,3),

(2,65,2,64,3),

(2,82,2,39,2),

(2,40,2,39,2),

(2,25,2,7,1),

(2,24,2,7,1),

(2,23,2,7,1),

(2,22,2,7,1),

(2,20,2,6,1),

(2,19,2,6,1),

(2,18,2,6,1),

(2,17,2,6,1),

(2,30,2,4,1);

/*Table structure for table `stu_admin_group` */


CREATE TABLE `stu_admin_group` (
  `id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'icon小图标',
  `sort` int(11) unsigned NOT NULL DEFAULT '50',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `remark` varchar(255) NOT NULL DEFAULT '',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `stu_admin_group` */

insert  into `stu_admin_group`(`id`,`name`,`icon`,`sort`,`status`,`remark`,`isdelete`,`create_time`,`update_time`) values 

(1,'参数设置','icon-parameter',2,1,'',0,1450752856,1481180175),

(2,'收费管理','icon-pay',3,1,'',0,1476016712,1481180175),

(3,'统计报表','icon-statistics',4,1,'',0,0,0),

(4,'草稿','icon-draft',5,1,'',0,0,0);

/*Table structure for table `stu_admin_node` */


CREATE TABLE `stu_admin_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `group_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `remark` varchar(255) NOT NULL DEFAULT '',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '节点类型，1-控制器 | 0-方法',
  `controller` varchar(255) DEFAULT NULL COMMENT '控制器名称',
  `action` varchar(255) DEFAULT NULL COMMENT '方法名称',
  `sort` smallint(6) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `level` (`level`),
  KEY `pid` (`pid`),
  KEY `status` (`status`),
  KEY `name` (`name`),
  KEY `isdelete` (`isdelete`),
  KEY `sort` (`sort`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `stu_admin_node` */

insert  into `stu_admin_node`(`id`,`pid`,`group_id`,`name`,`title`,`remark`,`level`,`type`,`controller`,`action`,`sort`,`status`,`isdelete`) values 

(1,0,1,'','角色管理','',1,1,'role','',50,0,0),

(2,1,1,'','查看','',2,2,'role','index',0,0,0),

(3,0,1,'','用户管理','',1,1,'admin_user','',0,0,0),

(4,0,1,'','校园信息','',1,1,'school','',0,0,0),

(5,0,1,'','基础数据','',1,1,'basic','',0,0,0),

(6,0,1,'','学生资料导入','',1,1,'data_import','',0,0,0),

(7,0,1,'','收费项目管理','',1,1,'charge_project','',0,0,0),

(8,0,1,'','收费标准管理','',1,1,'standard_manage','',0,0,0),

(9,0,1,'','模板编辑','',1,1,'template','',0,0,0),

(10,1,1,'','新建角色','',2,2,'role','addrole',0,0,0),

(11,1,1,'','编辑','',2,2,'role','editrole',0,0,0),

(12,1,1,'','删除','',2,2,'role','del',0,0,0),

(13,3,1,'','添加用户','',2,2,'admin_user','adduser',0,0,0),

(14,3,1,'','查看','',2,2,'admin_user','index',0,0,0),

(15,3,1,'','编辑','',2,2,'admin_user','edituser',0,0,0),

(16,3,1,'','删除','',2,2,'admin_user','del',0,0,0),

(17,6,1,'','查看','',2,2,'data_import','index',0,0,0),

(18,6,1,'','新增','',2,2,'data_import','adddata',0,0,0),

(19,6,1,'','编辑','',2,2,'data_import','editdata',0,0,0),

(20,6,1,'','删除','',2,2,'data_import','del',0,0,0),

(22,7,1,'','查看','',2,2,'charge_project','index',0,0,0),

(23,7,1,'','新增','',2,2,'charge_project','addproject',0,0,0),

(24,7,1,'','编辑','',2,2,'charge_project','editproject',0,0,0),

(25,7,1,'','删除','',2,2,'charge_project','del',0,0,0),

(26,8,1,'','查看','',2,2,'standard_manage','index',0,0,0),

(27,8,1,'','新增','',2,2,'standard_manage','addstandard',0,0,0),

(28,8,1,'','编辑','',2,2,'standard_manage','editstandard',0,0,0),

(29,8,1,'','删除','',2,2,'standard_manage','del',0,0,0),

(30,4,1,'','查看','',2,2,'school','index',0,0,0),

(31,5,1,'','添加学年','',2,2,'basic','addschoolyear',0,0,0),

(32,5,1,'','新增学期','',2,2,'basic','addschoolterm',0,0,0),

(33,5,1,'','添加年级','',2,2,'basic','addgrade',0,0,0),

(34,5,1,'','添加班级','',2,2,'basic','addclasses',0,0,0),

(35,5,1,'','查看','',2,2,'basic','index',0,0,0),

(36,5,1,'','删除','',2,2,'basic','del',0,0,0),

(37,9,1,'','查看','',2,2,'template','index',0,0,0),

(38,1,1,'','授权','',2,2,'role','auth',0,0,0),

(39,0,2,'','缴费','',1,1,'charge_fee','',0,0,0),

(40,39,2,'','缴费','',2,2,'charge_fee','index',0,0,0),

(41,5,1,'','编辑学年','',2,2,'basic','editschoolyear',0,0,0),

(42,5,1,'','编辑学期','',2,2,'basic','editschoolterm',0,0,0),

(43,5,1,'','编辑年级','',2,2,'basic','editgrade',0,0,0),

(44,5,1,'','编辑班级','',2,2,'basic','editclasses',0,0,0),

(45,8,1,'','审核','',2,2,'standard_manage','checkstandard',0,0,0),

(46,8,1,'','导出汇总表','',2,2,'standard_manage','exportstandard',0,0,0),

(47,8,1,'','导出明细表','',2,2,'standard_manage','exportdetail',0,0,0),

(48,7,1,'','导出','',2,2,'charge_project','importproject',0,0,0),

(49,6,1,'','导出','',2,2,'data_import','exportdata',0,0,0),

(50,6,1,'','导入','',2,2,'data_import','leadout',0,0,0),

(54,0,2,'','补欠费','',1,1,'charge_arrears','',0,0,0),

(55,54,2,'','补欠费','',2,2,'charge_arrears','index',0,0,0),

(56,0,2,'','退费','',1,1,'charge_refund','',0,0,0),

(57,56,1,'','退费','',2,2,'charge_refund','index',0,0,0),

(58,3,1,'','导出','',2,2,'admin_user','exportdata',0,0,0),

(59,3,1,'','导入','',2,2,'admin_user','leadout',0,0,0),

(60,0,3,'','学生费用明细表','',1,1,'charge_detail','',0,0,0),

(61,60,3,'','查看','',2,2,'charge_detail','index',0,0,0),

(62,0,3,'','项目费用总账','',1,1,'expense_account','',0,0,0),

(63,62,3,'','查看','',2,2,'expense_account','index',0,0,0),

(64,0,3,'','应收款总金额','',1,1,'receive','',0,0,0),

(65,64,3,'','查看','',2,2,'receive','index',0,0,0),

(66,0,3,'','减退补额度','',1,1,'diminished','',0,0,0),

(67,66,3,'','查看','',2,2,'diminished','index',0,0,0),

(68,0,3,'','学生人数','',1,1,'number','',0,0,0),

(69,68,3,'','查看','',2,2,'number','index',0,0,0),

(70,0,3,'','收费日账','',1,1,'charge','',0,0,0),

(71,70,3,'','查看','',2,2,'charge','index',0,0,0),

(72,0,3,'','收费总账','',1,1,'charge_all','',0,0,0),

(73,72,3,'','查看','',2,2,'charge_all','index',0,0,0),

(74,0,3,'','操作员收费汇总','',1,1,'operator','',0,0,0),

(75,74,3,'','查看','',2,2,'operator','index',0,0,0),

(76,0,3,'','操作员收费科目','',1,1,'operator_project','',0,0,0),

(77,76,3,'','查看','',2,2,'operator_project','index',0,0,0),

(78,9,1,'','新增模板','',2,2,'template','addtemplate',0,0,0),

(79,9,1,'','编辑','',2,2,'template','edittemplate',0,0,0),

(80,9,1,'','删除模板','',2,2,'template','del',0,0,0),

(81,39,2,'','新增缴费','',2,2,'charge_fee','save',0,0,0),

(82,39,2,'','导出','',2,2,'charge_fee','exportdata',0,0,0),

(83,56,2,'','新增退费','',2,2,'charge_refund','saverefund',0,0,0),

(84,56,2,'','批量退费','',2,2,'charge_refund','savebatchrefund',0,0,0),

(85,56,2,'','删除','',2,2,'charge_refund','savedel',0,0,0),

(86,56,2,'','审核','',2,2,'charge_refund','savecheck',0,0,0),

(87,56,2,'','批量审核','',2,2,'charge_refund','savebatchcheck',0,0,0),

(88,56,2,'','导出','',2,2,'charge_refund','exportrefund',0,0,0),

(89,9,1,'','设为默认','',2,2,'template','makedefault',0,0,0),

(94,93,4,'','查看','',2,2,'draft','index',0,0,0),

(93,0,4,'','草稿箱','',1,1,'draft','',0,0,0),

(96,0,4,'','作废箱','',1,1,'scrap','',0,0,0),

(97,96,4,'','查看','',2,2,'scrap','index',0,0,0),

(98,54,2,'','导出未缴费','',2,2,'charge_arrears','exportunpay',0,0,0),

(99,54,2,'','导出欠费','',2,2,'charge_arrears','exportarrears',0,0,0),

(100,54,2,'','导出补交记录','',2,2,'charge_arrears','exportafterarrears',0,0,0),

(101,54,2,'','补交费用','',2,2,'charge_arrears','savearrears',0,0,0),

(102,93,4,'','删除','',2,2,'draft','savedel',0,0,0),

(103,96,4,'','导出','',2,2,'scrap','exportscrap',0,0,0),

(104,39,2,'','作废','',2,2,'charge_fee','savescrap',0,0,0);

/*Table structure for table `stu_admin_node_load` */


CREATE TABLE `stu_admin_node_load` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='节点快速导入';

/*Data for the table `stu_admin_node_load` */

insert  into `stu_admin_node_load`(`id`,`title`,`name`,`status`) values 

(4,'编辑','edit',1),

(5,'添加','add',1),

(6,'首页','index',1),

(7,'删除','delete',1);

/*Table structure for table `stu_admin_role` */


CREATE TABLE `stu_admin_role` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `pid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parentId` (`pid`),
  KEY `status` (`status`),
  KEY `isdelete` (`isdelete`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `stu_admin_role` */

insert  into `stu_admin_role`(`id`,`pid`,`name`,`remark`,`status`,`isdelete`,`create_time`,`update_time`) values 

(1,0,'领导组',' ',1,0,1208784792,1254325558),

(2,0,'网编组','大家好',0,0,1215496283,1454049929),

(4,0,'老师','这是我1',1,0,0,0),

(6,0,'校长','大家好',1,0,0,0);

/*Table structure for table `stu_admin_role_user` */


CREATE TABLE `stu_admin_role_user` (
  `role_id` mediumint(9) unsigned DEFAULT NULL,
  `user_id` char(32) DEFAULT NULL,
  KEY `group_id` (`role_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

/*Data for the table `stu_admin_role_user` */

insert  into `stu_admin_role_user`(`role_id`,`user_id`) values 

(1,'1'),

(1,'1'),

(1,'1');

/*Table structure for table `stu_charge_fee` */


CREATE TABLE `stu_charge_fee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year_id` tinyint(4) NOT NULL COMMENT '学年id',
  `term_id` tinyint(4) NOT NULL COMMENT '学期id',
  `grade_id` tinyint(4) NOT NULL COMMENT '年级id',
  `classes_id` tinyint(4) NOT NULL COMMENT '班级id',
  `stu_id` int(11) NOT NULL COMMENT '学生id',
  `year_name` varchar(50) NOT NULL COMMENT '学年',
  `term_name` varchar(50) NOT NULL COMMENT '学期',
  `grade_name` varchar(50) NOT NULL COMMENT '年级',
  `classes_name` varchar(50) NOT NULL COMMENT '班级',
  `number` varchar(50) NOT NULL COMMENT '学号',
  `status` tinyint(5) NOT NULL DEFAULT '0' COMMENT '1草稿2完成3作废4欠费ing',
  `refund_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '1退费审核申请2退费完成3审核不通过',
  `must_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '必交费用',
  `derate_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '减免费用',
  `taotal_account` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总共应收取费用',
  `arrears_fee` decimal(10,2) NOT NULL COMMENT '补交金额',
  `payed_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '已交费用',
  `unpay_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '未交费用(欠费金额)',
  `refund_fee` decimal(10,2) NOT NULL COMMENT '退费金额',
  `refund_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0正常1退费2退费草稿3作废',
  `arrears_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0正常1补欠费2补欠费草稿3作废',
  `created_time` int(11) NOT NULL COMMENT '创建时间',
  `created_by` varchar(25) NOT NULL COMMENT '创建人',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `log_str` text COMMENT '提交数据json',
  `jf_number` varchar(50) NOT NULL COMMENT '缴费编号',
  `tf_number` varchar(50) DEFAULT NULL COMMENT '退费编号',
  `arrears_time` int(11) DEFAULT NULL COMMENT '补交时间',
  `arrears_by` varchar(25) DEFAULT NULL COMMENT '补交操作人',
  `refund_time` int(11) DEFAULT NULL COMMENT '退费时间',
  `refund_by` varchar(25) DEFAULT NULL COMMENT '退费人',
  `admin_id` int(11) DEFAULT NULL COMMENT '管理员id',
  `refund_check_remark` varchar(255) DEFAULT NULL COMMENT '审核意见',
  `checked_by` varchar(255) DEFAULT NULL COMMENT '退款审核人',
  `checked_time` int(11) DEFAULT NULL COMMENT '退款审核时间',
  PRIMARY KEY (`id`),
  KEY `index` (`year_id`,`term_id`,`grade_id`,`classes_id`,`stu_id`,`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='学费';

/*Data for the table `stu_charge_fee` */

insert  into `stu_charge_fee`(`id`,`year_id`,`term_id`,`grade_id`,`classes_id`,`stu_id`,`year_name`,`term_name`,`grade_name`,`classes_name`,`number`,`status`,`refund_status`,`must_fee`,`derate_fee`,`taotal_account`,`arrears_fee`,`payed_fee`,`unpay_fee`,`refund_fee`,`refund_type`,`arrears_type`,`created_time`,`created_by`,`remark`,`log_str`,`jf_number`,`tf_number`,`arrears_time`,`arrears_by`,`refund_time`,`refund_by`,`admin_id`,`refund_check_remark`,`checked_by`,`checked_time`) values 

(10,3,2,3,2,2,'2016','第三学期','高三年级','三班','1303056',2,1,0.00,0.00,4000.00,0.00,0.00,0.00,2000.00,2,0,1537331160,'admin','你好你好','{\"stu_number\":\"1303056\",\"derate_money\":\"0\",\"stu_remark\":\"\",\"must_money\":\"4000.00\",\"already_money\":\"0.00\",\"no_money\":\"0.00\",\"check_arr\":[\"17\",\"16\"]}','JF_201809190006','TF_201809260001',NULL,NULL,1537948202,'超级管理员',1,'你好你好1',NULL,NULL),

(11,3,2,3,2,6,'2016','第三学期','高三年级','三班','134567886',3,0,0.00,0.00,2000.00,0.00,2000.00,0.00,0.00,0,0,1537338709,'admin','','{\"stu_number\":\"134567886\",\"derate_money\":\"0\",\"stu_remark\":\"\",\"must_money\":\"2000.00\",\"already_money\":\"0.00\",\"no_money\":\"0.00\",\"jf_number\":\"JF_201809190016\",\"check_arr\":[\"17\"]}','JF_201809190016',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),

(12,2,6,3,2,8,'2017','第一学期','高三年级','三班','123456',2,0,0.00,0.00,1000.00,0.00,1000.00,0.00,0.00,0,0,1537430137,'admin','','{\"stu_number\":\"123456\",\"derate_money\":\"0\",\"stu_remark\":\"\",\"must_money\":\"200.00\",\"already_money\":\"0.00\",\"no_money\":\"0.00\",\"jf_number\":\"JF_201809200002\",\"check_arr\":[\"18\"]}','JF_201809200002','TF_201809250014',NULL,NULL,1537861957,'admin',1,'',NULL,NULL),

(13,3,2,3,2,2,'2016','第三学期','高三年级','三班','1303056',2,0,0.00,0.00,4000.00,2000.00,4000.00,0.00,0.00,0,1,1537491647,'admin','','{\"stu_number\":\"1303056\",\"derate_money\":\"0\",\"stu_remark\":\"\",\"must_money\":\"2000.00\",\"already_money\":\"0.00\",\"no_money\":\"0.00\",\"jf_number\":\"JF_201809210002\",\"check_arr\":[\"17\"]}','JF_201809210002',NULL,1537502270,'admin',NULL,NULL,1,NULL,NULL,NULL),

(14,0,0,0,0,0,'','','','','',0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),

(16,12,8,3,2,13,'2018学年','第二学期','高三年级','三班','20180929001',2,2,0.00,0.00,2000.00,0.00,2000.00,0.00,1000.00,1,0,1538201419,'超级管理员','','{\"stu_number\":\"20180929001\",\"derate_money\":\"0\",\"stu_remark\":\"\",\"must_money\":\"2000.00\",\"already_money\":\"0.00\",\"no_money\":\"0.00\",\"jf_number\":\"JF_201809290003\",\"check_arr\":[\"20\",\"21\"],\"data_type\":\"2\"}','JF_201809290003','TF_201809290001',NULL,NULL,1538201459,'超级管理员',1,'','超级管理员',1538201498),

(17,12,8,3,2,14,'2018学年','第二学期','高三年级','三班','20180929002',3,0,0.00,0.00,1000.00,0.00,1000.00,1000.00,0.00,0,0,1538201554,'超级管理员','','{\"stu_number\":\"20180929002\",\"derate_money\":\"0\",\"stu_remark\":\"\",\"must_money\":\"1000.00\",\"already_money\":\"0.00\",\"no_money\":\"0.00\",\"jf_number\":\"JF_201809290004\",\"check_arr\":[\"20\"],\"data_type\":\"2\"}','JF_201809290004',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL);

/*Table structure for table `stu_charge_fee_detail` */


CREATE TABLE `stu_charge_fee_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_id` int(11) NOT NULL COMMENT '学费id',
  `charge_item_id` int(11) NOT NULL COMMENT '收费项目id',
  `price` decimal(10,2) NOT NULL COMMENT '价格',
  `stu_id` int(11) NOT NULL COMMENT '学生id',
  `created_time` int(11) NOT NULL COMMENT '创建时间',
  `created_by` varchar(25) NOT NULL COMMENT '创建人',
  `grade_id` int(11) DEFAULT NULL COMMENT '年级id',
  `classes_id` int(11) DEFAULT NULL COMMENT '班级id',
  `operation_type` tinyint(5) NOT NULL COMMENT '0正常1补欠费2退费',
  `admin_id` int(11) DEFAULT NULL COMMENT '管理员账户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `stu_charge_fee_detail` */

insert  into `stu_charge_fee_detail`(`id`,`fee_id`,`charge_item_id`,`price`,`stu_id`,`created_time`,`created_by`,`grade_id`,`classes_id`,`operation_type`,`admin_id`) values 

(1,10,17,2000.00,2,1537331160,'admin',3,2,2,1),

(2,10,16,2000.00,2,1537331160,'admin',3,2,0,1),

(3,11,17,2000.00,6,1537338709,'admin',3,2,0,1),

(4,12,18,1000.00,8,1537430138,'admin',3,2,2,1),

(5,13,17,2000.00,2,1537491648,'admin',3,2,0,1),

(6,13,16,2000.00,2,1537502270,'admin',3,2,0,1),

(7,16,20,1000.00,13,1538201419,'超级管理员',3,2,2,1),

(8,16,21,1000.00,13,1538201420,'超级管理员',3,2,0,1),

(10,17,20,1000.00,14,1538201554,'超级管理员',3,2,0,1);

/*Table structure for table `stu_charge_project` */


CREATE TABLE `stu_charge_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT '' COMMENT '收费项目名称',
  `remark` varchar(255) DEFAULT '' COMMENT '说明',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

/*Data for the table `stu_charge_project` */

insert  into `stu_charge_project`(`id`,`name`,`remark`) values 

(1,'学费','这是学费'),

(2,'书本费','这是书本费'),

(8,'退学费','ww'),

(9,'住宿费','545');

/*Table structure for table `stu_charge_unpay_item` */


CREATE TABLE `stu_charge_unpay_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_id` int(11) NOT NULL COMMENT 'fee表id',
  `charge_item_id` int(11) NOT NULL COMMENT 'project表id',
  `stu_id` int(11) NOT NULL COMMENT '学生id',
  `price` decimal(10,2) NOT NULL COMMENT '价格',
  `created_time` int(11) NOT NULL COMMENT '创建时间',
  `created_by` varchar(25) NOT NULL COMMENT '创建人',
  `is_del` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0未删除1已删除',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `stu_charge_unpay_item` */

insert  into `stu_charge_unpay_item`(`id`,`fee_id`,`charge_item_id`,`stu_id`,`price`,`created_time`,`created_by`,`is_del`) values 

(1,13,16,2,2000.00,1537491648,'admin',0),

(3,15,19,12,400.00,1537951626,'超级管理员',0),

(4,17,21,14,1000.00,1538201554,'超级管理员',0);

/*Table structure for table `stu_classes` */


CREATE TABLE `stu_classes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grade_id` tinyint(3) NOT NULL COMMENT '年级id',
  `grade_name` varchar(50) NOT NULL COMMENT '年级名称',
  `name` varchar(50) NOT NULL COMMENT '班级名称',
  `ctime` int(11) DEFAULT NULL COMMENT '创建时间',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

/*Data for the table `stu_classes` */

insert  into `stu_classes`(`id`,`grade_id`,`grade_name`,`name`,`ctime`,`description`) values 

(8,2,'高二年级','三班',1537424789,''),

(2,3,'高三年级','三班',1536546273,'这也是个很好的班级'),

(7,2,'高二年级','一班',1537424780,''),

(6,3,'高三年级','二班',1536738225,'你好'),

(9,7,'初一年级','一班',1537496857,''),

(10,8,'初二年级','二班',1537496868,''),

(11,9,'初三年级','三班',1537496877,''),

(12,6,'高一年级','一班',1537496897,''),

(13,7,'初一年级','二班',1537497295,''),

(14,7,'初一年级','十班',1537927526,'');

/*Table structure for table `stu_config` */


CREATE TABLE `stu_config` (
  `id` tinyint(3) NOT NULL,
  `logo` varchar(255) DEFAULT NULL COMMENT '学校Logo',
  `name` varchar(255) DEFAULT NULL COMMENT '学校名称',
  `address` varchar(255) DEFAULT NULL COMMENT '学校地址',
  `contact` varchar(50) DEFAULT NULL COMMENT '联系方式',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `stu_config` */

insert  into `stu_config`(`id`,`logo`,`name`,`address`,`contact`,`remark`) values 

(1,'/upload/20180907/5b91f42d5f54d.jpg','安徽大学','安徽省合肥市长江西路268号','13565659898','0558-321456');

/*Table structure for table `stu_file` */


CREATE TABLE `stu_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cate` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '文件类型，1-image | 2-file',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `original` varchar(255) NOT NULL DEFAULT '' COMMENT '原文件名',
  `domain` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '',
  `size` int(10) unsigned NOT NULL DEFAULT '0',
  `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `stu_file` */

/*Table structure for table `stu_grade` */


CREATE TABLE `stu_grade` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '年级名称',
  `ctime` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

/*Data for the table `stu_grade` */

insert  into `stu_grade`(`id`,`name`,`ctime`) values 

(7,'初一年级',1537496820),

(2,'高二年级',1536544093),

(3,'高三年级',1536544106),

(6,'高一年级',1537496805),

(8,'初二年级',1537496830),

(9,'初三年级',1537496843);

/*Table structure for table `stu_login_log` */


CREATE TABLE `stu_login_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `login_ip` char(15) NOT NULL DEFAULT '',
  `login_location` varchar(255) NOT NULL DEFAULT '',
  `login_browser` varchar(255) NOT NULL DEFAULT '',
  `login_os` varchar(255) NOT NULL DEFAULT '',
  `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `stu_login_log` */

/*Table structure for table `stu_node_map` */


CREATE TABLE `stu_node_map` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
  `controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
  `action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
  `method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
  `comment` varchar(255) NOT NULL DEFAULT '' COMMENT '节点图描述',
  PRIMARY KEY (`id`),
  KEY `map` (`method`,`module`,`controller`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='节点图';

/*Data for the table `stu_node_map` */

/*Table structure for table `stu_pay_num` */


CREATE TABLE `stu_pay_num` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `auto_num` varchar(50) NOT NULL COMMENT '当天最后数字',
  `last_num` int(11) NOT NULL COMMENT '缴费编号',
  `jf_date` date NOT NULL COMMENT '日期',
  PRIMARY KEY (`id`),
  KEY `jd` (`jf_date`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COMMENT='缴费编号自动生成表';

/*Data for the table `stu_pay_num` */

insert  into `stu_pay_num`(`id`,`auto_num`,`last_num`,`jf_date`) values 

(2,'JF_201809180001',1,'2018-09-18'),

(3,'JF_201809180002',2,'2018-09-18'),

(4,'JF_201809180003',3,'2018-09-18'),

(5,'JF_201809180004',4,'2018-09-18'),

(6,'JF_201809180005',5,'2018-09-18'),

(7,'JF_201809180006',6,'2018-09-18'),

(8,'JF_201809180007',7,'2018-09-18'),

(9,'JF_201809180008',8,'2018-09-18'),

(10,'JF_201809180009',9,'2018-09-18'),

(11,'JF_201809180010',10,'2018-09-18'),

(12,'JF_201809180011',11,'2018-09-18'),

(13,'JF_201809180012',12,'2018-09-18'),

(14,'JF_201809180013',13,'2018-09-18'),

(15,'JF_201809180014',14,'2018-09-18'),

(16,'JF_201809180015',15,'2018-09-18'),

(17,'JF_201809180016',16,'2018-09-18'),

(18,'JF_201809180017',17,'2018-09-18'),

(19,'JF_201809180018',18,'2018-09-18'),

(20,'JF_201809180019',19,'2018-09-18'),

(21,'JF_201809180020',20,'2018-09-18'),

(22,'JF_201809180021',21,'2018-09-18'),

(23,'JF_201809180022',22,'2018-09-18'),

(24,'JF_201809180023',23,'2018-09-18'),

(25,'JF_201809180024',24,'2018-09-18'),

(26,'JF_201809180025',25,'2018-09-18'),

(27,'JF_201809180026',26,'2018-09-18'),

(28,'JF_201809180027',27,'2018-09-18'),

(29,'JF_201809180028',28,'2018-09-18'),

(30,'JF_201809180029',29,'2018-09-18'),

(31,'JF_201809180030',30,'2018-09-18'),

(32,'JF_201809180031',31,'2018-09-18'),

(33,'JF_201809180032',32,'2018-09-18'),

(34,'JF_201809180033',33,'2018-09-18'),

(35,'JF_201809180034',34,'2018-09-18'),

(36,'JF_201809190001',1,'2018-09-19'),

(37,'JF_201809190002',2,'2018-09-19'),

(38,'JF_201809190003',3,'2018-09-19'),

(39,'JF_201809190004',4,'2018-09-19'),

(40,'JF_201809190005',5,'2018-09-19'),

(41,'JF_201809190006',6,'2018-09-19'),

(42,'JF_201809190007',7,'2018-09-19'),

(43,'JF_201809190008',8,'2018-09-19'),

(44,'JF_201809190009',9,'2018-09-19'),

(45,'JF_201809190010',10,'2018-09-19'),

(46,'JF_201809190011',11,'2018-09-19'),

(47,'JF_201809190012',12,'2018-09-19'),

(48,'JF_201809190013',13,'2018-09-19'),

(49,'JF_201809190014',14,'2018-09-19'),

(50,'JF_201809190015',15,'2018-09-19'),

(51,'JF_201809190016',16,'2018-09-19'),

(52,'JF_201809200001',1,'2018-09-20'),

(53,'JF_201809200002',2,'2018-09-20'),

(54,'JF_201809200003',3,'2018-09-20'),

(55,'JF_201809200004',4,'2018-09-20'),

(56,'JF_201809200005',5,'2018-09-20'),

(57,'JF_201809210001',1,'2018-09-21'),

(58,'JF_201809210002',2,'2018-09-21'),

(59,'JF_201809260001',1,'2018-09-26'),

(60,'JF_201809260002',2,'2018-09-26'),

(61,'JF_201809260003',3,'2018-09-26'),

(62,'JF_201809260004',4,'2018-09-26'),

(63,'JF_201809270001',1,'2018-09-27'),

(64,'JF_201809290001',1,'2018-09-29'),

(65,'JF_201809290002',2,'2018-09-29'),

(66,'JF_201809290003',3,'2018-09-29'),

(67,'JF_201809290004',4,'2018-09-29');

/*Table structure for table `stu_project_fee` */


CREATE TABLE `stu_project_fee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` tinyint(3) DEFAULT NULL COMMENT '收费项目id',
  `project_name` varchar(50) DEFAULT NULL COMMENT '项目名称',
  `money` varchar(50) DEFAULT NULL COMMENT '收费项目金额',
  `standard_id` int(11) DEFAULT NULL COMMENT '收费标准id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

/*Data for the table `stu_project_fee` */

insert  into `stu_project_fee`(`id`,`project_id`,`project_name`,`money`,`standard_id`) values 

(1,1,'学费','1000',1),

(2,2,'书本费','3000',1),

(3,1,'学费','2000',3),

(4,2,'书本费','1300',3),

(8,1,'学费','1000',3),

(7,1,'学费','1200',NULL),

(9,1,'学费','2000',4),

(10,1,'学费','1900',5),

(11,2,'书本费','2300',5),

(17,2,'书本费','2000',7),

(14,1,'学费','200',NULL),

(16,1,'学费','2000',7),

(18,1,'学费','200',8),

(19,1,'学费','400',9),

(20,1,'学费','1000',10),

(21,9,'住宿费','1000',10);

/*Table structure for table `stu_refund_num` */


CREATE TABLE `stu_refund_num` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `auto_num` varchar(40) NOT NULL COMMENT '当天最后数字',
  `last_num` int(11) NOT NULL COMMENT '缴费编号',
  `jf_date` date NOT NULL COMMENT '日期',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

/*Data for the table `stu_refund_num` */

insert  into `stu_refund_num`(`id`,`auto_num`,`last_num`,`jf_date`) values 

(1,'JF_201809250001',1,'2018-09-25'),

(2,'JF_201809250002',2,'2018-09-25'),

(3,'JF_201809250003',3,'2018-09-25'),

(4,'JF_201809250004',4,'2018-09-25'),

(5,'TF_201809250005',5,'2018-09-25'),

(6,'TF_201809250006',6,'2018-09-25'),

(7,'TF_201809250007',7,'2018-09-25'),

(8,'TF_201809250008',8,'2018-09-25'),

(9,'TF_201809250009',9,'2018-09-25'),

(10,'TF_201809250010',10,'2018-09-25'),

(11,'TF_201809250011',11,'2018-09-25'),

(12,'TF_201809250012',12,'2018-09-25'),

(13,'TF_201809250013',13,'2018-09-25'),

(14,'TF_201809250014',14,'2018-09-25'),

(15,'TF_201809260001',1,'2018-09-26'),

(16,'TF_201809290001',1,'2018-09-29');

/*Table structure for table `stu_school_term` */


CREATE TABLE `stu_school_term` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year_id` int(11) NOT NULL COMMENT '学年id',
  `year_name` varchar(50) NOT NULL COMMENT '学年名称',
  `name` varchar(50) NOT NULL COMMENT '学期名称',
  `start_time` int(11) NOT NULL COMMENT '学期开始时间',
  `end_time` int(11) NOT NULL COMMENT '学期结束时间',
  `ctime` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `stu_school_term` */

insert  into `stu_school_term`(`id`,`year_id`,`year_name`,`name`,`start_time`,`end_time`,`ctime`) values 

(8,12,'2018学年','第二学期',1535731200,1546185600,1538200177),

(2,3,'2016','第三学期',1598803200,1568044800,NULL),

(7,3,'2016','第二学期',1535817600,1538236800,1536840631),

(6,2,'2017','第一学期',1536422400,1538236800,1536840609);

/*Table structure for table `stu_school_year` */


CREATE TABLE `stu_school_year` (
  `id` tinyint(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '学年名称',
  `start_time` int(11) NOT NULL DEFAULT '0' COMMENT '学年开始时间',
  `end_time` int(11) NOT NULL DEFAULT '0' COMMENT '学年结束时间',
  `ctime` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

/*Data for the table `stu_school_year` */

insert  into `stu_school_year`(`id`,`name`,`start_time`,`end_time`,`ctime`) values 

(14,'2014',1536422400,1538236800,1537925300),

(2,'2017',1502035200,1536249600,1536305159),

(3,'2016',1465228800,1504713600,1536310021),

(4,'2015',1536249600,1536768000,1536310055),

(8,'2017',1536249600,1537459200,1536310119),

(15,'2013',1537632000,1538236800,1537925321),

(12,'2018学年',1536249600,1538496000,1536550280),

(13,'2015学年',1536508800,1537891200,1536546381);

/*Table structure for table `stu_standard` */


CREATE TABLE `stu_standard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year_id` tinyint(3) DEFAULT NULL COMMENT '学年id',
  `term_id` int(11) DEFAULT NULL COMMENT '学期id',
  `grade_id` tinyint(3) DEFAULT NULL COMMENT '年级id',
  `year_name` varchar(50) DEFAULT NULL COMMENT '学年名称',
  `term_name` varchar(50) DEFAULT NULL COMMENT '学期名称',
  `grade_name` varchar(50) DEFAULT NULL COMMENT '年级名称',
  `money` decimal(10,2) DEFAULT '0.00' COMMENT '收费总金额',
  `apply_id` int(11) DEFAULT NULL COMMENT '申请人',
  `apply_time` int(11) DEFAULT NULL COMMENT '申请时间',
  `auditor_id` int(11) DEFAULT NULL COMMENT '审核人',
  `auditor_time` int(11) DEFAULT NULL COMMENT '审核时间',
  `status` tinyint(2) DEFAULT '0' COMMENT '0:未审核 1:审核通过 2:审核拒绝',
  `start_time` int(11) DEFAULT NULL COMMENT '开始收费时间',
  `end_time` int(11) DEFAULT NULL COMMENT '结束收费时间',
  `type` tinyint(2) DEFAULT NULL COMMENT '1:必交 2:选交',
  `suggest` varchar(255) DEFAULT NULL COMMENT '审核意见',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `stu_standard` */

insert  into `stu_standard`(`id`,`year_id`,`term_id`,`grade_id`,`year_name`,`term_name`,`grade_name`,`money`,`apply_id`,`apply_time`,`auditor_id`,`auditor_time`,`status`,`start_time`,`end_time`,`type`,`suggest`) values 

(5,2,6,2,'2017','第一学期','高二年级',4200.00,1,1536840686,NULL,NULL,0,1535212800,1538755200,1,NULL),

(6,3,7,3,'2016','第二学期','高三年级',3423.00,1,1536840735,1,1537235062,1,1535817600,1538755200,1,'非常好的标准'),

(3,3,2,2,'2016','第三学期','高二年级',4300.00,1,1536836182,NULL,NULL,1,1535817600,1538236800,2,NULL),

(7,3,2,3,'2016','第三学期','高二年级',4000.00,1,1537239484,NULL,NULL,1,1535990400,1540915200,1,NULL),

(8,2,6,3,'2017','第一学期','高三年级',1000.00,1,1537430075,NULL,NULL,1,1536681600,1538236800,1,NULL),

(9,2,6,6,'2017','第一学期','高一年级',400.00,1,1537951405,1,1537951428,1,1537113600,1540915200,1,''),

(10,12,8,3,'2018学年','第二学期','高三年级',2000.00,1,1538200349,1,1538201405,1,1535731200,1541001600,1,'');

/*Table structure for table `stu_students` */


CREATE TABLE `stu_students` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year_id` tinyint(3) DEFAULT '0' COMMENT '学年id',
  `term_id` int(11) DEFAULT '0' COMMENT '班级id',
  `grade_id` tinyint(3) DEFAULT '0' COMMENT '年级id',
  `classes_id` int(11) DEFAULT '0' COMMENT '班级id',
  `year_name` varchar(30) DEFAULT '' COMMENT '学年名称',
  `term_name` varchar(30) DEFAULT '' COMMENT '学期名称',
  `grade_name` varchar(30) DEFAULT '' COMMENT '年级名称',
  `classes_name` varchar(30) DEFAULT '' COMMENT '班级名称',
  `number` varchar(30) DEFAULT '' COMMENT '学号',
  `name` varchar(50) DEFAULT '' COMMENT '姓名',
  `sex` tinyint(2) DEFAULT '1' COMMENT '1:男 2:女',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

/*Data for the table `stu_students` */

insert  into `stu_students`(`id`,`year_id`,`term_id`,`grade_id`,`classes_id`,`year_name`,`term_name`,`grade_name`,`classes_name`,`number`,`name`,`sex`) values 

(1,3,2,2,7,'2016','第三学期','高二年级','一班','1201010481','于海洋',2),

(2,3,2,3,2,'2016','第三学期','高三年级','三班','1303056','王力宏',1),

(8,2,6,3,2,'2017','第一学期','高三年级','三班','123456','李荣浩',2),

(6,3,2,3,2,'2016','第三学期','高三年级','三班','134567886','xx',1),

(7,3,2,3,6,'2016','第三学期','高三年级','二班','120101048','周杰伦',1),

(9,3,7,7,9,'2016','第二学期','初一年级','一班','1201481','陶喆',1),

(10,2,6,8,10,'2017','第一学期','初二年级','二班','1304556','林俊杰',2),

(11,3,7,9,11,'2016','第二学期','初三年级','三班','221201481','福临',1),

(12,2,6,6,12,'2017','第一学期','高一年级','一班','231304556','阿亮',2),

(13,12,8,3,2,'2018学年','第二学期','高三年级','三班','20180929001','gdf',1),

(14,12,8,3,2,'2018学年','第二学期','高三年级','三班','20180929002','cgfgg',2);

/*Table structure for table `stu_template` */


CREATE TABLE `stu_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL COMMENT '模板名称',
  `admin_id` int(11) DEFAULT NULL COMMENT '操作者id',
  `is_default` tinyint(2) DEFAULT '0' COMMENT '1:没人模板 0:普通',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `content` text COMMENT '模板编辑内容',
  `type` tinyint(2) DEFAULT NULL COMMENT '1:收费单 2:补费单 3:退费单',
  `change_time` int(11) DEFAULT NULL COMMENT '动态时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `stu_template` */

insert  into `stu_template`(`id`,`title`,`admin_id`,`is_default`,`create_time`,`content`,`type`,`change_time`) values 

(1,'缴费单5',1,1,1537859926,'<p style=\"text-align: center;\"><span style=\"font-size: xx-large; font-weight: bold;\">缴费单</span><br></p><p style=\"text-align: left;\">姓名:&nbsp;&nbsp;&nbsp;$XM$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;性别:&nbsp; $NJ$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;收费编号:&nbsp; &nbsp; $NUMBER$</p><p><br></p><p style=\"text-align: left;\">年级:&nbsp; &nbsp;$BJ$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;班级:&nbsp; $XXMC$&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;开单日期: $TIMES$</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br></p><p>&nbsp; &nbsp;&nbsp;<br></p><table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center;\"><tbody><tr><th style=\"text-align: left;\">&nbsp;序号</th><th style=\"text-align: left;\">收费项目&nbsp;</th><th style=\"text-align: left;\">收费金额(元)&nbsp;</th></tr><tr><td style=\"text-align: left;\">&nbsp;1</td><td style=\"text-align: left;\">$SFXTMMC$<br></td><td style=\"text-align: left;\">$SFXMJEONE$&nbsp;&nbsp;&nbsp;&nbsp;<br></td></tr><tr><td style=\"text-align: left;\">&nbsp;合计金额(大写):</td><td style=\"text-align: left;\">$XXMC$</td><td style=\"text-align: left;\">$XXMC$</td></tr></tbody></table><p style=\"text-align: center;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p><p style=\"text-align: left;\">&nbsp;开单人:&nbsp; &nbsp;\n\n$ADMIN$&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 已收金额:$SFXMMC$</p><p style=\"text-align: center;\"><br></p><p style=\"text-align: left;\">学校名称:&nbsp;&nbsp;$SCHOOL$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;待收金额:$SFXMJE$</p><p style=\"text-align: right;\"><br></p>',1,1538016111),

(5,'退费单',1,1,1538040564,'<p style=\"text-align: center;\"><span style=\"font-size: xx-large; font-weight: bold;\">退费单</span><br></p><p>姓名:&nbsp;&nbsp;&nbsp;$XM$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;性别:&nbsp; $NJ$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;退费编号:&nbsp; $RENUMBER$</p><p><br></p><p>年级:&nbsp; &nbsp;$BJ$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;班级:&nbsp; $XXMC$&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;开单日期: $TIMES$</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br></p><p>&nbsp; &nbsp;&nbsp;<br></p><table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><th style=\"text-align: left;\">&nbsp;序号</th><th style=\"text-align: left;\">收费项目&nbsp;</th><th style=\"text-align: left;\">收费金额(元)&nbsp;</th></tr><tr><td>&nbsp;1</td><td>$SFXTMMC$<br></td><td>$SFXMJEONE$&nbsp;&nbsp;&nbsp;&nbsp;<br></td></tr><tr><td>&nbsp;</td><td><br></td><td></td></tr></tbody></table><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p><p>&nbsp;开单人:&nbsp; &nbsp; $ADMIN$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 退费总金额:$REFUNDALL$</p><p><br></p><p>学校名称:&nbsp;&nbsp;$SCHOOL$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</p><p><br></p>',3,1538040576),

(4,'退费单',1,1,1537867962,'<p style=\"text-align: center;\"><span style=\"font-size: xx-large;\">退费单</span><br></p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 姓名:&nbsp;&nbsp;&nbsp;$XM$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;性别:&nbsp; $NJ$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;收费编号:&nbsp; &nbsp; $NUMBER$</p><p><br></p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 年级:&nbsp; &nbsp;$BJ$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;班级:&nbsp; $XXMC$&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;开单日期: $TIMES$</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br></p><p>&nbsp; &nbsp;&nbsp;<br></p><table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><th>&nbsp;序号</th><th>补费项目&nbsp;</th><th>补费金额(元)&nbsp;</th></tr><tr><td>&nbsp;1</td><td>&nbsp; &nbsp; &nbsp;\n\n$SFXTMMC$</td><td>&nbsp;&nbsp;\n\n$SFXMJE$</td></tr><tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;&nbsp;</td></tr></tbody></table><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;开单人:&nbsp; &nbsp;$ADMIN$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;已收金额:$SFXMMC$</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;学校名称:&nbsp;&nbsp;$SCHOOL$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;\n\n补交总金额&nbsp; :$SFXMJEALL$</p><p><br></p><p><br></p>',2,1538051259);

