基于python企業(yè)對(duì)賬分析系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
就是收入支出申報(bào)? ?管理員審批? ?然后可以通過(guò)日期查到集體的交易往來(lái)。
最少要有收入支出申報(bào)和審批兩種賬號(hào)? ?和日期查詢記錄這樣
開(kāi)發(fā)語(yǔ)言：Python
框架：django
Python版本：python3.7.7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：PyCharm?
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫(kù)：
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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `zhanghao` varchar(200) NOT NULL COMMENT '賬號(hào)',
? `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 '手機(jī)',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? PRIMARY KEY (`id`),
? UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540609430 DEFAULT CHARSET=utf8 COMMENT='申報(bào)員';
/*!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','賬號(hào)1','123456','姓名1','男','年齡1','13823888881','upload/shenbaoyuan_tupian1.jpg'),(12,'2022-03-06 04:22:00','賬號(hào)2','123456','姓名2','男','年齡2','13823888882','upload/shenbaoyuan_tupian2.jpg'),(13,'2022-03-06 04:22:00','賬號(hào)3','123456','姓名3','男','年齡3','13823888883','upload/shenbaoyuan_tupian3.jpg'),(14,'2022-03-06 04:22:00','賬號(hào)4','123456','姓名4','男','年齡4','13823888884','upload/shenbaoyuan_tupian4.jpg'),(15,'2022-03-06 04:22:00','賬號(hào)5','123456','姓名5','男','年齡5','13823888885','upload/shenbaoyuan_tupian5.jpg'),(16,'2022-03-06 04:22:00','賬號(hào)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 '創(chuàng)建時(shí)間',
? `shenpizhanghao` varchar(200) NOT NULL COMMENT '審批賬號(hào)',
? `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 '手機(jī)',
? `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','審批賬號(hào)1','123456','審批姓名1',1,'男','13823888881','upload/shenpiyuan_zhaopian1.jpg'),(22,'2022-03-06 04:22:00','審批賬號(hào)2','123456','審批姓名2',2,'男','13823888882','upload/shenpiyuan_zhaopian2.jpg'),(23,'2022-03-06 04:22:00','審批賬號(hào)3','123456','審批姓名3',3,'男','13823888883','upload/shenpiyuan_zhaopian3.jpg'),(24,'2022-03-06 04:22:00','審批賬號(hào)4','123456','審批姓名4',4,'男','13823888884','upload/shenpiyuan_zhaopian4.jpg'),(25,'2022-03-06 04:22:00','審批賬號(hào)5','123456','審批姓名5',5,'男','13823888885','upload/shenpiyuan_zhaopian5.jpg'),(26,'2022-03-06 04:22:00','審批賬號(hào)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 '創(chuàng)建時(shí)間',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號(hào)',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shenbaoyuanyin` longtext COMMENT '申報(bào)原因',
? `shenbaojine` float DEFAULT NULL COMMENT '申報(bào)金額',
? `fapiaopingzheng` varchar(200) DEFAULT NULL COMMENT '發(fā)票憑證',
? `shenbaoshijian` date DEFAULT NULL COMMENT '申報(bào)時(shí)間',
? `shenpizhanghao` varchar(200) DEFAULT NULL COMMENT '審批賬號(hào)',
? `shenpixingming` varchar(200) DEFAULT NULL COMMENT '審批姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540683397 DEFAULT CHARSET=utf8 COMMENT='收入申報(bào)';
/*!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','賬號(hào)1','姓名1','申報(bào)原因1',1,'upload/shourushenbao_fapiaopingzheng1.jpg','2022-03-06','審批賬號(hào)1','審批姓名1','是',''),(42,'2022-03-06 04:22:00','賬號(hào)2','姓名2','申報(bào)原因2',2,'upload/shourushenbao_fapiaopingzheng2.jpg','2022-03-06','審批賬號(hào)2','審批姓名2','是',''),(43,'2022-03-06 04:22:00','賬號(hào)3','姓名3','申報(bào)原因3',3,'upload/shourushenbao_fapiaopingzheng3.jpg','2022-03-06','審批賬號(hào)3','審批姓名3','是',''),(44,'2022-03-06 04:22:00','賬號(hào)4','姓名4','申報(bào)原因4',4,'upload/shourushenbao_fapiaopingzheng4.jpg','2022-03-06','審批賬號(hào)4','審批姓名4','是',''),(45,'2022-03-06 04:22:00','賬號(hào)5','姓名5','申報(bào)原因5',5,'upload/shourushenbao_fapiaopingzheng5.jpg','2022-03-06','審批賬號(hào)5','審批姓名5','是',''),(46,'2022-03-06 04:22:00','賬號(hào)6','姓名6','申報(bào)原因6',6,'upload/shourushenbao_fapiaopingzheng6.jpg','2022-03-06','審批賬號(hào)6','審批姓名6','是',''),(1646540683396,'2022-03-06 04:24:43','11','第三方','的發(fā)順豐水電費(fèi)第三方是否手動(dòng)發(fā)生的',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 '創(chuàng)建時(shí)間',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號(hào)',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shenbaoyuanyin` longtext COMMENT '申報(bào)原因',
? `shenbaojine` float DEFAULT NULL COMMENT '申報(bào)金額',
? `fapiaopingzheng` varchar(200) DEFAULT NULL COMMENT '發(fā)票憑證',
? `shenbaoshijian` date DEFAULT NULL COMMENT '申報(bào)時(shí)間',
? `shenpizhanghao` varchar(200) DEFAULT NULL COMMENT '審批賬號(hào)',
? `shenpixingming` varchar(200) DEFAULT NULL COMMENT '審批姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? 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','賬號(hào)1','姓名1','申報(bào)原因1',1,'upload/shourushenpi_fapiaopingzheng1.jpg','2022-03-06','審批賬號(hào)1','審批姓名1','是',''),(62,'2022-03-06 04:22:00','賬號(hào)2','姓名2','申報(bào)原因2',2,'upload/shourushenpi_fapiaopingzheng2.jpg','2022-03-06','審批賬號(hào)2','審批姓名2','是',''),(63,'2022-03-06 04:22:00','賬號(hào)3','姓名3','申報(bào)原因3',3,'upload/shourushenpi_fapiaopingzheng3.jpg','2022-03-06','審批賬號(hào)3','審批姓名3','是',''),(64,'2022-03-06 04:22:00','賬號(hào)4','姓名4','申報(bào)原因4',4,'upload/shourushenpi_fapiaopingzheng4.jpg','2022-03-06','審批賬號(hào)4','審批姓名4','是',''),(65,'2022-03-06 04:22:00','賬號(hào)5','姓名5','申報(bào)原因5',5,'upload/shourushenpi_fapiaopingzheng5.jpg','2022-03-06','審批賬號(hào)5','審批姓名5','是',''),(66,'2022-03-06 04:22:00','賬號(hào)6','姓名6','申報(bào)原因6',6,'upload/shourushenpi_fapiaopingzheng6.jpg','2022-03-06','審批賬號(hào)6','審批姓名6','是',''),(1646540735862,'2022-03-06 04:25:35','11','第三方','的發(fā)順豐水電費(fèi)第三方是否手動(dòng)發(fā)生的',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 '新增時(shí)間',
? 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 '創(chuàng)建時(shí)間',
? `zhanghao` varchar(200) DEFAULT NULL COMMENT '賬號(hào)',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `shenbaoyuanyin` longtext COMMENT '申報(bào)原因',
? `shenbaojine` float DEFAULT NULL COMMENT '申報(bào)金額',
? `fapiaopingzheng` varchar(200) DEFAULT NULL COMMENT '發(fā)票憑證',
? `shenbaoshijian` date DEFAULT NULL COMMENT '申報(bào)時(shí)間',
? `shenpizhanghao` varchar(200) DEFAULT NULL COMMENT '審批賬號(hào)',
? `shenpixingming` varchar(200) DEFAULT NULL COMMENT '審批姓名',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646540666949 DEFAULT CHARSET=utf8 COMMENT='支出申報(bào)';
/*!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','賬號(hào)1','姓名1','申報(bào)原因1',1,'upload/zhichushenbao_fapiaopingzheng1.jpg','2022-03-06','審批賬號(hào)1','審批姓名1','是',''),(32,'2022-03-06 04:22:00','賬號(hào)2','姓名2','申報(bào)原因2',2,'upload/zhichushenbao_fapiaopingzheng2.jpg','2022-03-06','審批賬號(hào)2','審批姓名2','是',''),(33,'2022-03-06 04:22:00','賬號(hào)3','姓名3','申報(bào)原因3',3,'upload/zhichushenbao_fapiaopingzheng3.jpg','2022-03-06','審批賬號(hào)3','審批姓名3','是',''),(34,'2022-03-06 04:22:00','賬號(hào)4','姓名4','申報(bào)原因4',4,'upload/zhichushenbao_fapiaopingzheng4.jpg','2022-03-06','審批賬號(hào)4','審批姓名4','是',''),(35,'2022-03-06 04:22:00','賬號(hào)5','姓名5','申報(bào)原因5',5,'upload/zhichushenbao_fapiaopingzheng5.jpg','2022-03-06','審批賬號(hào)5','審批姓名5','是',''),(36,'2022-03-06 04:22:00','賬號(hào)6','姓名6','申報(bào)原因6',6,'upload/zhichushenbao_fapiaopingzheng6.jpg','2022-03-06','審批賬號(hào)6','審批姓名6','是',''),(1646540666948,'2022-03-06 04:24:26','11','第三方',' 勝多負(fù)少的發(fā)生的發(fā)生的發(fā)生的 勝多負(fù)少的發(fā)生的發(fā)生的發(fā)生的 勝多負(fù)少的發(fā)生的發(fā)生的發(fā)生的 勝多負(fù)少的發(fā)生的發(fā)生的發(fā)生的 勝多負(fù)少的發(fā)生的發(fā)生的發(fā)生的',44,'upload/1646540644294.jpg','2022-03-06','22','地方','是','給你提交給管理員審核');
/*!40000 ALTER TABLE `zhichushenbao` ENABLE KEYS */;
UNLOCK TABLES;
