就是收入支出申报 管理员审批 然后可以通过日期查到集体的交易往来。
最少要有收入支出申报和审批两种账号 和日期查询记录这样
开发语言：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;