就是收入支出申报 管理员审批 然后可以通过日期查到集体的交易往来。
最少要有收入支出申报和审批两种账号 和日期查询记录这样
开发语言：Python
框架：django
Python版本：python3.7.7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：PyCharm
浏览器：谷歌浏览器
数据库：
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shenbaoyuan`
--
DROP TABLE IF EXISTS `shenbaoyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shenbaoyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) NOT NULL COMMENT '账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` varchar(200) DEFAULT NULL COMMENT '年龄',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
PRIMARY KEY (`id`),
UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540609430 DEFAULT CHARSET=utf8 COMMENT='申报员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shenbaoyuan`
--
LOCK TABLES `shenbaoyuan` WRITE;
/*!40000 ALTER TABLE `shenbaoyuan` DISABLE KEYS */;
INSERT INTO `shenbaoyuan` VALUES (11,'2022-03-06 04:22:00','账号1','123456','姓名1','男','年龄1','13823888881','upload/shenbaoyuan_tupian1.jpg'),(12,'2022-03-06 04:22:00','账号2','123456','姓名2','男','年龄2','13823888882','upload/shenbaoyuan_tupian2.jpg'),(13,'2022-03-06 04:22:00','账号3','123456','姓名3','男','年龄3','13823888883','upload/shenbaoyuan_tupian3.jpg'),(14,'2022-03-06 04:22:00','账号4','123456','姓名4','男','年龄4','13823888884','upload/shenbaoyuan_tupian4.jpg'),(15,'2022-03-06 04:22:00','账号5','123456','姓名5','男','年龄5','13823888885','upload/shenbaoyuan_tupian5.jpg'),(16,'2022-03-06 04:22:00','账号6','123456','姓名6','男','年龄6','13823888886','upload/shenbaoyuan_tupian6.jpg'),(1646540609429,'2022-03-06 04:23:29','11','11','第三方','女','11','11222211111','upload/1646540630650.jpg');
/*!40000 ALTER TABLE `shenbaoyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shenpiyuan`
--
DROP TABLE IF EXISTS `shenpiyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shenpiyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shenpizhanghao` varchar(200) NOT NULL COMMENT '审批账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`shenpixingming` varchar(200) NOT NULL COMMENT '审批姓名',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
PRIMARY KEY (`id`),
UNIQUE KEY `shenpizhanghao` (`shenpizhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540620717 DEFAULT CHARSET=utf8 COMMENT='审批员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shenpiyuan`
--
LOCK TABLES `shenpiyuan` WRITE;
/*!40000 ALTER TABLE `shenpiyuan` DISABLE KEYS */;
INSERT INTO `shenpiyuan` VALUES (21,'2022-03-06 04:22:00','审批账号1','123456','审批姓名1',1,'男','13823888881','upload/shenpiyuan_zhaopian1.jpg'),(22,'2022-03-06 04:22:00','审批账号2','123456','审批姓名2',2,'男','13823888882','upload/shenpiyuan_zhaopian2.jpg'),(23,'2022-03-06 04:22:00','审批账号3','123456','审批姓名3',3,'男','13823888883','upload/shenpiyuan_zhaopian3.jpg'),(24,'2022-03-06 04:22:00','审批账号4','123456','审批姓名4',4,'男','13823888884','upload/shenpiyuan_zhaopian4.jpg'),(25,'2022-03-06 04:22:00','审批账号5','123456','审批姓名5',5,'男','13823888885','upload/shenpiyuan_zhaopian5.jpg'),(26,'2022-03-06 04:22:00','审批账号6','123456','审批姓名6',6,'男','13823888886','upload/shenpiyuan_zhaopian6.jpg'),(1646540620716,'2022-03-06 04:23:40','22','22','地方',22,'女','11122233341','upload/1646540704277.jpg');
/*!40000 ALTER TABLE `shenpiyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shourushenbao`
--
DROP TABLE IF EXISTS `shourushenbao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shourushenbao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shenbaoyuanyin` longtext COMMENT '申报原因',
`shenbaojine` float DEFAULT NULL COMMENT '申报金额',
`fapiaopingzheng` varchar(200) DEFAULT NULL COMMENT '发票凭证',
`shenbaoshijian` date DEFAULT NULL COMMENT '申报时间',
`shenpizhanghao` varchar(200) DEFAULT NULL COMMENT '审批账号',
`shenpixingming` varchar(200) DEFAULT NULL COMMENT '审批姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540683397 DEFAULT CHARSET=utf8 COMMENT='收入申报';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shourushenbao`
--
LOCK TABLES `shourushenbao` WRITE;
/*!40000 ALTER TABLE `shourushenbao` DISABLE KEYS */;
INSERT INTO `shourushenbao` VALUES (41,'2022-03-06 04:22:00','账号1','姓名1','申报原因1',1,'upload/shourushenbao_fapiaopingzheng1.jpg','2022-03-06','审批账号1','审批姓名1','是',''),(42,'2022-03-06 04:22:00','账号2','姓名2','申报原因2',2,'upload/shourushenbao_fapiaopingzheng2.jpg','2022-03-06','审批账号2','审批姓名2','是',''),(43,'2022-03-06 04:22:00','账号3','姓名3','申报原因3',3,'upload/shourushenbao_fapiaopingzheng3.jpg','2022-03-06','审批账号3','审批姓名3','是',''),(44,'2022-03-06 04:22:00','账号4','姓名4','申报原因4',4,'upload/shourushenbao_fapiaopingzheng4.jpg','2022-03-06','审批账号4','审批姓名4','是',''),(45,'2022-03-06 04:22:00','账号5','姓名5','申报原因5',5,'upload/shourushenbao_fapiaopingzheng5.jpg','2022-03-06','审批账号5','审批姓名5','是',''),(46,'2022-03-06 04:22:00','账号6','姓名6','申报原因6',6,'upload/shourushenbao_fapiaopingzheng6.jpg','2022-03-06','审批账号6','审批姓名6','是',''),(1646540683396,'2022-03-06 04:24:43','11','第三方','的发顺丰水电费第三方是否手动发生的',33,'upload/1646540675607.jpg','2022-03-06','22','地方','是','122');
/*!40000 ALTER TABLE `shourushenbao` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shourushenpi`
--
DROP TABLE IF EXISTS `shourushenpi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shourushenpi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shenbaoyuanyin` longtext COMMENT '申报原因',
`shenbaojine` float DEFAULT NULL COMMENT '申报金额',
`fapiaopingzheng` varchar(200) DEFAULT NULL COMMENT '发票凭证',
`shenbaoshijian` date DEFAULT NULL COMMENT '申报时间',
`shenpizhanghao` varchar(200) DEFAULT NULL COMMENT '审批账号',
`shenpixingming` varchar(200) DEFAULT NULL COMMENT '审批姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540735863 DEFAULT CHARSET=utf8 COMMENT='收入审批';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shourushenpi`
--
LOCK TABLES `shourushenpi` WRITE;
/*!40000 ALTER TABLE `shourushenpi` DISABLE KEYS */;
INSERT INTO `shourushenpi` VALUES (61,'2022-03-06 04:22:00','账号1','姓名1','申报原因1',1,'upload/shourushenpi_fapiaopingzheng1.jpg','2022-03-06','审批账号1','审批姓名1','是',''),(62,'2022-03-06 04:22:00','账号2','姓名2','申报原因2',2,'upload/shourushenpi_fapiaopingzheng2.jpg','2022-03-06','审批账号2','审批姓名2','是',''),(63,'2022-03-06 04:22:00','账号3','姓名3','申报原因3',3,'upload/shourushenpi_fapiaopingzheng3.jpg','2022-03-06','审批账号3','审批姓名3','是',''),(64,'2022-03-06 04:22:00','账号4','姓名4','申报原因4',4,'upload/shourushenpi_fapiaopingzheng4.jpg','2022-03-06','审批账号4','审批姓名4','是',''),(65,'2022-03-06 04:22:00','账号5','姓名5','申报原因5',5,'upload/shourushenpi_fapiaopingzheng5.jpg','2022-03-06','审批账号5','审批姓名5','是',''),(66,'2022-03-06 04:22:00','账号6','姓名6','申报原因6',6,'upload/shourushenpi_fapiaopingzheng6.jpg','2022-03-06','审批账号6','审批姓名6','是',''),(1646540735862,'2022-03-06 04:25:35','11','第三方','的发顺丰水电费第三方是否手动发生的',33,'upload/1646540675607.jpg','2022-03-06','22','地方','是','可以666订单');
/*!40000 ALTER TABLE `shourushenpi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-03-06 04:22:00');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhichushenbao`
--
DROP TABLE IF EXISTS `zhichushenbao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhichushenbao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shenbaoyuanyin` longtext COMMENT '申报原因',
`shenbaojine` float DEFAULT NULL COMMENT '申报金额',
`fapiaopingzheng` varchar(200) DEFAULT NULL COMMENT '发票凭证',
`shenbaoshijian` date DEFAULT NULL COMMENT '申报时间',
`shenpizhanghao` varchar(200) DEFAULT NULL COMMENT '审批账号',
`shenpixingming` varchar(200) DEFAULT NULL COMMENT '审批姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540666949 DEFAULT CHARSET=utf8 COMMENT='支出申报';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhichushenbao`
--
LOCK TABLES `zhichushenbao` WRITE;
/*!40000 ALTER TABLE `zhichushenbao` DISABLE KEYS */;
INSERT INTO `zhichushenbao` VALUES (31,'2022-03-06 04:22:00','账号1','姓名1','申报原因1',1,'upload/zhichushenbao_fapiaopingzheng1.jpg','2022-03-06','审批账号1','审批姓名1','是',''),(32,'2022-03-06 04:22:00','账号2','姓名2','申报原因2',2,'upload/zhichushenbao_fapiaopingzheng2.jpg','2022-03-06','审批账号2','审批姓名2','是',''),(33,'2022-03-06 04:22:00','账号3','姓名3','申报原因3',3,'upload/zhichushenbao_fapiaopingzheng3.jpg','2022-03-06','审批账号3','审批姓名3','是',''),(34,'2022-03-06 04:22:00','账号4','姓名4','申报原因4',4,'upload/zhichushenbao_fapiaopingzheng4.jpg','2022-03-06','审批账号4','审批姓名4','是',''),(35,'2022-03-06 04:22:00','账号5','姓名5','申报原因5',5,'upload/zhichushenbao_fapiaopingzheng5.jpg','2022-03-06','审批账号5','审批姓名5','是',''),(36,'2022-03-06 04:22:00','账号6','姓名6','申报原因6',6,'upload/zhichushenbao_fapiaopingzheng6.jpg','2022-03-06','审批账号6','审批姓名6','是',''),(1646540666948,'2022-03-06 04:24:26','11','第三方',' 胜多负少的发生的发生的发生的 胜多负少的发生的发生的发生的 胜多负少的发生的发生的发生的 胜多负少的发生的发生的发生的 胜多负少的发生的发生的发生的',44,'upload/1646540644294.jpg','2022-03-06','22','地方','是','给你提交给管理员审核');
/*!40000 ALTER TABLE `zhichushenbao` ENABLE KEYS */;
UNLOCK TABLES;
