基于python企业对账分析系统设计与实现-计算机毕业设计源码+LW文档-CSDN博客

本文链接：https://blog.csdn.net/qq_375279829/article/details/127234834

就是收入支出申报管理员审批然后可以通过日期查到集体的交易往来。
最少要有收入支出申报和审批两种账号和日期查询记录这样

开发语言：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;