hadoop+Spark+django基于大数据技术的智慧居家养老服务平台(源码+文档+调试+可视化大屏)
本次系统所涉及到的有关的功能，都是用功能结构图来简洁和清晰的表示出来，功能结构图就是能够把比较复杂的功能结构用图的形式清晰的描绘下来，并且为后续的设计以及测试等模块提供了明确的方向，在构思功能结构图的时候，便可以给设计的过程带来一定的思维导向，不至于在设计过程中有所遗漏，可以尽可能的明确系统所涉及到的功能。管理、健康报告管理、服务类型管理、服务订单管理、接单服务管理、服务评价管理、紧急求助管理、救
·
收藏关注不迷路！！
🌟文末获取源码+数据库🌟
感兴趣的可以先收藏起来，还有大家在毕设选题（免费咨询指导选题），项目以及论文编写等相关问题都可以给我留言咨询，希望帮助更多的人
前言
智慧居家养老服务平台是一款专为老年人设计的智能养老解决方案，旨在提供全方位的居家养老服务。该系统具有多种功能，包括服务人员、食谱信息、社区互动、健康资讯等，为老年人提供了一个安全、便捷的居住环境。智慧居家养老服务平台是一款集多种功能于一体的智能养老解决方案，对于改善老年人的生活质量具有重要意义。
智慧居家养老服务平台中采用python技术和mysql数据库。主要为管理员、服务人员和老人三部分，主要功能是实现对个人中心、老人管理、服务人员管理、慢性病管理、食谱信息管理、健康监测管理、健康报告管理、服务类型管理、服务订单管理、接单服务管理、服务评价管理、紧急求助管理、救助响应管理、社区互动、系统管理等功能进行解析，使管理变得方便快捷。相对于管理者而言，本系统可以减少工作人员的工作量，从而提高工作效率。经过对本系统的全面测试，表明了本系统具有良好的可行性。
详细视频演示
文章底部名片，联系我看更详细的演示视频
一、项目介绍
开发语言：Python
python框架：Django
软件版本：python3.7/python3.8
数据库：mysql 5.7或更高版本
数据库工具：Navicat11
开发软件：PyCharm/vs code
前端框架:vue.js
二、功能介绍
本次系统所涉及到的有关的功能，都是用功能结构图来简洁和清晰的表示出来，功能结构图就是能够把比较复杂的功能结构用图的形式清晰的描绘下来，并且为后续的设计以及测试等模块提供了明确的方向，在构思功能结构图的时候，便可以给设计的过程带来一定的思维导向，不至于在设计过程中有所遗漏，可以尽可能的明确系统所涉及到的功能。系统的功能结构图如图4-1所示。
图4-1 系统功能结构图
三、核心代码
部分代码：
def users_login(request):
if request.method in ["POST", "GET"]:
msg = {'code': normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
if req_dict.get('role')!=None:
del req_dict['role']
datas = users.getbyparams(users, users, req_dict)
if not datas:
msg['code'] = password_error_code
msg['msg'] = mes.password_error_code
return JsonResponse(msg)
req_dict['id'] = datas[0].get('id')
return Auth.authenticate(Auth, users, req_dict)
def users_register(request):
if request.method in ["POST", "GET"]:
msg = {'code': normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
error = users.createbyreq(users, users, req_dict)
if error != None:
msg['code'] = crud_error_code
msg['msg'] = error
return JsonResponse(msg)
def users_session(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code,"msg":mes.normal_code, "data": {}}
req_dict = {"id": request.session.get('params').get("id")}
msg['data'] = users.getbyparams(users, users, req_dict)[0]
return JsonResponse(msg)
def users_logout(request):
if request.method in ["POST", "GET"]:
msg = {
"msg": "退出成功",
"code": 0
}
return JsonResponse(msg)
def users_page(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code,
"data": {"currPage": 1, "totalPage": 1, "total": 1, "pageSize": 10, "list": []}}
req_dict = request.session.get("req_dict")
tablename = request.session.get("tablename")
try:
__hasMessage__ = users.__hasMessage__
except:
__hasMessage__ = None
if __hasMessage__ and __hasMessage__ != "否":
if tablename != "users":
req_dict["userid"] = request.session.get("params").get("id")
if tablename == "users":
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = users.page(users, users, req_dict)
else:
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = [],1,0,0,10
return JsonResponse(msg)
数据库参考
--
-- Current Database: `django0173syfi`
--
/*!40000 DROP DATABASE IF EXISTS `django0173syfi`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `django0173syfi` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `django0173syfi`;
--
-- Table structure for table `config`
--
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 '配置参数值',
`url` varchar(500) DEFAULT NULL COMMENT 'url',
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',NULL),(2,'picture2','upload/picture2.jpg',NULL),(3,'picture3','upload/1710146357038.jpg',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum`
--
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
`content` longtext NOT NULL COMMENT '帖子内容',
`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`avatarurl` longtext COMMENT '头像',
`isdone` varchar(200) DEFAULT NULL COMMENT '状态',
`istop` int(11) DEFAULT '0' COMMENT '是否置顶',
`toptime` datetime DEFAULT NULL COMMENT '置顶时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710146701185 DEFAULT CHARSET=utf8 COMMENT='社区互动';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum`
--
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (151,'2024-03-11 07:54:36','帖子标题1','帖子内容1',0,1,'用户名1','upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg','开放',0,'2024-03-11 15:54:36'),(152,'2024-03-11 07:54:36','帖子标题2','帖子内容2',0,2,'用户名2','upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg','开放',0,'2024-03-11 15:54:36'),(153,'2024-03-11 07:54:36','帖子标题3','帖子内容3',0,3,'用户名3','upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg','开放',0,'2024-03-11 15:54:36'),(155,'2024-03-11 07:54:36','帖子标题5','帖子内容5',0,5,'用户名5','upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg','开放',0,'2024-03-11 15:54:36'),(156,'2024-03-11 07:54:36','帖子标题6','帖子内容6',0,6,'用户名6','upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg','开放',0,'2024-03-11 15:54:36'),(157,'2024-03-11 07:54:36','帖子标题7','帖子内容7',0,7,'用户名7','upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg','开放',0,'2024-03-11 15:54:36'),(158,'2024-03-11 07:54:36','帖子标题8','帖子内容8',0,8,'用户名8','upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg,upload/forum_avatarurl10.jpg','开放',1,'2024-03-11 16:50:31'),(1710146692418,'2024-03-11 08:44:52','健康交流','<p>健康交流健康交流健康交流健康交流健康交流健康交流健康交流</p><p><img src=\"http://localhost:8080/django0173syfi/upload/1710146690755.jpg\"></p>',0,1710146543216,'22',NULL,'开放',1,'2024-03-11 16:50:32'),(1710146701184,'2024-03-11 08:45:01',NULL,'<p>666</p>',151,1710146543216,'22','upload/1710146542450.jpeg',NULL,0,NULL);
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwudingdan`
--
DROP TABLE IF EXISTS `fuwudingdan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwudingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`renyuanbianhao` varchar(200) DEFAULT NULL COMMENT '人员编号',
`renyuanxingming` varchar(200) DEFAULT NULL COMMENT '人员姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`zhaopian` longtext COMMENT '照片',
`fuwufei` varchar(200) DEFAULT NULL COMMENT '服务费',
`jifeibiaozhun` varchar(200) DEFAULT NULL COMMENT '计费标准',
`laorenzhanghao` varchar(200) DEFAULT NULL COMMENT '老人账号',
`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`dizhi` varchar(200) NOT NULL COMMENT '地址',
`fuwuxuqiu` longtext NOT NULL COMMENT '服务需求',
`xiadanshijian` datetime DEFAULT NULL COMMENT '下单时间',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1710146660348 DEFAULT CHARSET=utf8 COMMENT='服务订单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwudingdan`
--
LOCK TABLES `fuwudingdan` WRITE;
/*!40000 ALTER TABLE `fuwudingdan` DISABLE KEYS */;
INSERT INTO `fuwudingdan` VALUES (81,'2024-03-11 07:54:36','1111111111','人员编号1','人员姓名1','联系电话1','服务类型1','upload/fuwudingdan_zhaopian1.jpg,upload/fuwudingdan_zhaopian2.jpg,upload/fuwudingdan_zhaopian3.jpg','服务费1','计费标准1','老人账号1','老人姓名1','手机号码1','地址1','服务需求1','2024-03-11 15:54:36','是',''),(82,'2024-03-11 07:54:36','2222222222','人员编号2','人员姓名2','联系电话2','服务类型2','upload/fuwudingdan_zhaopian2.jpg,upload/fuwudingdan_zhaopian3.jpg,upload/fuwudingdan_zhaopian4.jpg','服务费2','计费标准2','老人账号2','老人姓名2','手机号码2','地址2','服务需求2','2024-03-11 15:54:36','是',''),(83,'2024-03-11 07:54:36','3333333333','人员编号3','人员姓名3','联系电话3','服务类型3','upload/fuwudingdan_zhaopian3.jpg,upload/fuwudingdan_zhaopian4.jpg,upload/fuwudingdan_zhaopian5.jpg','服务费3','计费标准3','老人账号3','老人姓名3','手机号码3','地址3','服务需求3','2024-03-11 15:54:36','是',''),(84,'2024-03-11 07:54:36','4444444444','人员编号4','人员姓名4','联系电话4','服务类型4','upload/fuwudingdan_zhaopian4.jpg,upload/fuwudingdan_zhaopian5.jpg,upload/fuwudingdan_zhaopian6.jpg','服务费4','计费标准4','老人账号4','老人姓名4','手机号码4','地址4','服务需求4','2024-03-11 15:54:36','是',''),(85,'2024-03-11 07:54:36','5555555555','人员编号5','人员姓名5','联系电话5','服务类型5','upload/fuwudingdan_zhaopian5.jpg,upload/fuwudingdan_zhaopian6.jpg,upload/fuwudingdan_zhaopian7.jpg','服务费5','计费标准5','老人账号5','老人姓名5','手机号码5','地址5','服务需求5','2024-03-11 15:54:36','是',''),(86,'2024-03-11 07:54:36','6666666666','人员编号6','人员姓名6','联系电话6','服务类型6','upload/fuwudingdan_zhaopian6.jpg,upload/fuwudingdan_zhaopian7.jpg,upload/fuwudingdan_zhaopian8.jpg','服务费6','计费标准6','老人账号6','老人姓名6','手机号码6','地址6','服务需求6','2024-03-11 15:54:36','是',''),(87,'2024-03-11 07:54:36','7777777777','人员编号7','人员姓名7','联系电话7','服务类型7','upload/fuwudingdan_zhaopian7.jpg,upload/fuwudingdan_zhaopian8.jpg,upload/fuwudingdan_zhaopian9.jpg','服务费7','计费标准7','老人账号7','老人姓名7','手机号码7','地址7','服务需求7','2024-03-11 15:54:36','是',''),(88,'2024-03-11 07:54:36','8888888888','人员编号8','人员姓名8','联系电话8','服务类型8','upload/fuwudingdan_zhaopian8.jpg,upload/fuwudingdan_zhaopian9.jpg,upload/fuwudingdan_zhaopian10.jpg','服务费8','计费标准8','老人账号8','老人姓名8','手机号码8','地址8','服务需求8','2024-03-11 15:54:36','是',''),(1710146660347,'2024-03-11 08:44:20','1710146601927','11','陈晓','15615615611','保洁','upload/1710146478323.jpeg','100','每小时收费','22','李明','15615615622','北京朝阳阳光花园567','11111','2024-03-11 16:43:21','是','服务人员根据老人需求和自己的时间安排决定是否接单');
/*!40000 ALTER TABLE `fuwudingdan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwuleixing`
--
DROP TABLE IF EXISTS `fuwuleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwuleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fuwuleixing` varchar(200) NOT NULL COMMENT '服务类型',
PRIMARY KEY (`id`),
UNIQUE KEY `fuwuleixing` (`fuwuleixing`)
) ENGINE=InnoDB AUTO_INCREMENT=1710146331692 DEFAULT CHARSET=utf8 COMMENT='服务类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwuleixing`
--
LOCK TABLES `fuwuleixing` WRITE;
/*!40000 ALTER TABLE `fuwuleixing` DISABLE KEYS */;
INSERT INTO `fuwuleixing` VALUES (71,'2024-03-11 07:54:36','服务类型1'),(72,'2024-03-11 07:54:36','服务类型2'),(73,'2024-03-11 07:54:36','服务类型3'),(74,'2024-03-11 07:54:36','服务类型4'),(75,'2024-03-11 07:54:36','服务类型5'),(76,'2024-03-11 07:54:36','服务类型6'),(77,'2024-03-11 07:54:36','服务类型7'),(78,'2024-03-11 07:54:36','服务类型8'),(1710146331691,'2024-03-11 08:38:51','保洁');
/*!40000 ALTER TABLE `fuwuleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwupingjia`
--
DROP TABLE IF EXISTS `fuwupingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwupingjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`renyuanbianhao` varchar(200) DEFAULT NULL COMMENT '人员编号',
`renyuanxingming` varchar(200) DEFAULT NULL COMMENT '人员姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`zhaopian` longtext COMMENT '照片',
`laorenzhanghao` varchar(200) DEFAULT NULL COMMENT '老人账号',
`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`pingjianeirong` longtext NOT NULL COMMENT '评价内容',
`pingjiashijian` datetime DEFAULT NULL COMMENT '评价时间',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
`shhf` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710147165863 DEFAULT CHARSET=utf8 COMMENT='服务评价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwupingjia`
--
LOCK TABLES `fuwupingjia` WRITE;
/*!40000 ALTER TABLE `fuwupingjia` DISABLE KEYS */;
INSERT INTO `fuwupingjia` VALUES (101,'2024-03-11 07:54:36','订单编号1','人员编号1','人员姓名1','联系电话1','服务类型1','upload/fuwupingjia_zhaopian1.jpg,upload/fuwupingjia_zhaopian2.jpg,upload/fuwupingjia_zhaopian3.jpg','老人账号1','老人姓名1','手机号码1','评价内容1','2024-03-11 15:54:36',1,1,''),(102,'2024-03-11 07:54:36','订单编号2','人员编号2','人员姓名2','联系电话2','服务类型2','upload/fuwupingjia_zhaopian2.jpg,upload/fuwupingjia_zhaopian3.jpg,upload/fuwupingjia_zhaopian4.jpg','老人账号2','老人姓名2','手机号码2','评价内容2','2024-03-11 15:54:36',2,2,''),(103,'2024-03-11 07:54:36','订单编号3','人员编号3','人员姓名3','联系电话3','服务类型3','upload/fuwupingjia_zhaopian3.jpg,upload/fuwupingjia_zhaopian4.jpg,upload/fuwupingjia_zhaopian5.jpg','老人账号3','老人姓名3','手机号码3','评价内容3','2024-03-11 15:54:36',3,3,''),(104,'2024-03-11 07:54:36','订单编号4','人员编号4','人员姓名4','联系电话4','服务类型4','upload/fuwupingjia_zhaopian4.jpg,upload/fuwupingjia_zhaopian5.jpg,upload/fuwupingjia_zhaopian6.jpg','老人账号4','老人姓名4','手机号码4','评价内容4','2024-03-11 15:54:36',4,4,''),(105,'2024-03-11 07:54:36','订单编号5','人员编号5','人员姓名5','联系电话5','服务类型5','upload/fuwupingjia_zhaopian5.jpg,upload/fuwupingjia_zhaopian6.jpg,upload/fuwupingjia_zhaopian7.jpg','老人账号5','老人姓名5','手机号码5','评价内容5','2024-03-11 15:54:36',5,5,''),(106,'2024-03-11 07:54:36','订单编号6','人员编号6','人员姓名6','联系电话6','服务类型6','upload/fuwupingjia_zhaopian6.jpg,upload/fuwupingjia_zhaopian7.jpg,upload/fuwupingjia_zhaopian8.jpg','老人账号6','老人姓名6','手机号码6','评价内容6','2024-03-11 15:54:36',6,6,''),(107,'2024-03-11 07:54:36','订单编号7','人员编号7','人员姓名7','联系电话7','服务类型7','upload/fuwupingjia_zhaopian7.jpg,upload/fuwupingjia_zhaopian8.jpg,upload/fuwupingjia_zhaopian9.jpg','老人账号7','老人姓名7','手机号码7','评价内容7','2024-03-11 15:54:36',7,7,''),(108,'2024-03-11 07:54:36','订单编号8','人员编号8','人员姓名8','联系电话8','服务类型8','upload/fuwupingjia_zhaopian8.jpg,upload/fuwupingjia_zhaopian9.jpg,upload/fuwupingjia_zhaopian10.jpg','老人账号8','老人姓名8','手机号码8','评价内容8','2024-03-11 15:54:36',8,8,''),(1710147165862,'2024-03-11 08:52:45','1710146601927','11','陈晓','15615615611','保洁','upload/1710146478323.jpeg','22','李明','15615615622','<p>6666</p>','2024-03-11 16:51:52',1710146543216,1710146955560,'谢谢好评');
/*!40000 ALTER TABLE `fuwupingjia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwurenyuan`
--
DROP TABLE IF EXISTS `fuwurenyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwurenyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`renyuanbianhao` varchar(200) NOT NULL COMMENT '人员编号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`renyuanxingming` varchar(200) NOT NULL COMMENT '人员姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`fuwuleixing` varchar(200) NOT NULL COMMENT '服务类型',
`fuwufei` double DEFAULT NULL COMMENT '服务费',
`jifeibiaozhun` varchar(200) DEFAULT NULL COMMENT '计费标准',
`zhaopian` longtext COMMENT '照片',
`fuwujianjie` longtext COMMENT '服务简介',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`),
UNIQUE KEY `renyuanbianhao` (`renyuanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1710146493154 DEFAULT CHARSET=utf8 COMMENT='服务人员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwurenyuan`
--
LOCK TABLES `fuwurenyuan` WRITE;
/*!40000 ALTER TABLE `fuwurenyuan` DISABLE KEYS */;
INSERT INTO `fuwurenyuan` VALUES (21,'2024-03-11 07:54:36','人员编号1','e10adc3949ba59abbe56e057f20f883e','人员姓名1','男',1,'13823888881','服务类型1',1,'计费标准1','upload/fuwurenyuan_zhaopian1.jpg','服务简介1','是','','2024-03-11 15:54:36',1,1),(22,'2024-03-11 07:54:36','人员编号2','e10adc3949ba59abbe56e057f20f883e','人员姓名2','男',2,'13823888882','服务类型2',2,'计费标准2','upload/fuwurenyuan_zhaopian2.jpg','服务简介2','是','','2024-03-11 15:54:36',6,2),(23,'2024-03-11 07:54:36','人员编号3','e10adc3949ba59abbe56e057f20f883e','人员姓名3','男',3,'13823888883','服务类型3',3,'计费标准3','upload/fuwurenyuan_zhaopian3.jpg','服务简介3','是','','2024-03-11 15:54:36',4,4),(24,'2024-03-11 07:54:36','人员编号4','e10adc3949ba59abbe56e057f20f883e','人员姓名4','男',4,'13823888884','服务类型4',4,'计费标准4','upload/fuwurenyuan_zhaopian4.jpg','服务简介4','是','','2024-03-11 15:54:36',5,5),(25,'2024-03-11 07:54:36','人员编号5','e10adc3949ba59abbe56e057f20f883e','人员姓名5','男',5,'13823888885','服务类型5',5,'计费标准5','upload/fuwurenyuan_zhaopian5.jpg','服务简介5','是','','2024-03-11 15:54:36',5,5),(26,'2024-03-11 07:54:36','人员编号6','e10adc3949ba59abbe56e057f20f883e','人员姓名6','男',6,'13823888886','服务类型6',6,'计费标准6','upload/fuwurenyuan_zhaopian6.jpg','服务简介6','是','','2024-03-11 15:54:36',6,6),(27,'2024-03-11 07:54:36','人员编号7','e10adc3949ba59abbe56e057f20f883e','人员姓名7','男',7,'13823888887','服务类型7',7,'计费标准7','upload/fuwurenyuan_zhaopian7.jpg','服务简介7','是','','2024-03-11 15:54:36',7,7),(28,'2024-03-11 07:54:36','人员编号8','e10adc3949ba59abbe56e057f20f883e','人员姓名8','男',8,'13823888888','服务类型8',8,'计费标准8','upload/fuwurenyuan_zhaopian8.jpg','服务简介8','是','','2024-03-11 15:54:36',9,9),(1710146493153,'2024-03-11 08:41:33','11','6512bd43d9caa6e02c990b0a82652dca','陈晓','女',35,'15615615611','保洁',100,'每小时收费','upload/1710146478323.jpeg','<p>服务简介服务简介服务简介服务简介服务简介服务简介</p>','是','',NULL,5,2);
/*!40000 ALTER TABLE `fuwurenyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huifuxinxi`
--
DROP TABLE IF EXISTS `huifuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huifuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaoliubianhao` varchar(200) DEFAULT NULL COMMENT '交流编号',
`renyuanbianhao` varchar(200) DEFAULT NULL COMMENT '人员编号',
`renyuanxingming` varchar(200) DEFAULT NULL COMMENT '人员姓名',
`jiaoliuzhe` varchar(200) DEFAULT NULL COMMENT '交流者',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`huifuneirong` longtext NOT NULL COMMENT '回复内容',
`huifushijian` datetime DEFAULT NULL COMMENT '回复时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710147524351 DEFAULT CHARSET=utf8 COMMENT='回复信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huifuxinxi`
--
LOCK TABLES `huifuxinxi` WRITE;
/*!40000 ALTER TABLE `huifuxinxi` DISABLE KEYS */;
INSERT INTO `huifuxinxi` VALUES (141,'2024-03-11 07:54:36','交流编号1','人员编号1','人员姓名1','交流者1','姓名1','回复内容1','2024-03-11 15:54:36'),(142,'2024-03-11 07:54:36','交流编号2','人员编号2','人员姓名2','交流者2','姓名2','回复内容2','2024-03-11 15:54:36'),(143,'2024-03-11 07:54:36','交流编号3','人员编号3','人员姓名3','交流者3','姓名3','回复内容3','2024-03-11 15:54:36'),(144,'2024-03-11 07:54:36','交流编号4','人员编号4','人员姓名4','交流者4','姓名4','回复内容4','2024-03-11 15:54:36'),(145,'2024-03-11 07:54:36','交流编号5','人员编号5','人员姓名5','交流者5','姓名5','回复内容5','2024-03-11 15:54:36'),(146,'2024-03-11 07:54:36','交流编号6','人员编号6','人员姓名6','交流者6','姓名6','回复内容6','2024-03-11 15:54:36'),(147,'2024-03-11 07:54:36','交流编号7','人员编号7','人员姓名7','交流者7','姓名7','回复内容7','2024-03-11 15:54:36'),(148,'2024-03-11 07:54:36','交流编号8','人员编号8','人员姓名8','交流者8','姓名8','回复内容8','2024-03-11 15:54:36'),(1710147524350,'2024-03-11 08:58:44','1710147431355','人员编号8','人员姓名8','11','陈晓','<p>回复交流6</p>','2024-03-11 16:57:46');
/*!40000 ALTER TABLE `huifuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiankangbaogao`
--
DROP TABLE IF EXISTS `jiankangbaogao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiankangbaogao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`baogaodanhao` varchar(200) DEFAULT NULL COMMENT '报告单号',
`laorenzhanghao` varchar(200) DEFAULT NULL COMMENT '老人账号',
`laorenxingming` varchar(200) DEFAULT NULL COMMENT '老人姓名',
`baogaotupian` longtext COMMENT '报告图片',
`jiankangzhuangtai` varchar(200) NOT NULL COMMENT '健康状态',
`jiankangbaogao` longtext NOT NULL COMMENT '健康报告',
`jiankangqushi` longtext NOT NULL COMMENT '健康趋势',
`jiankangjingbao` longtext COMMENT '健康警报',
`jiankangjianyi` longtext COMMENT '健康建议',
`baogaoshijian` datetime DEFAULT NULL COMMENT '报告时间',
PRIMARY KEY (`id`),
UNIQUE KEY `baogaodanhao` (`baogaodanhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1710147052461 DEFAULT CHARSET=utf8 COMMENT='健康报告';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiankangbaogao`
--
LOCK TABLES `jiankangbaogao` WRITE;
/*!40000 ALTER TABLE `jiankangbaogao` DISABLE KEYS */;
INSERT INTO `jiankangbaogao` VALUES (61,'2024-03-11 07:54:36','1111111111','老人账号1','老人姓名1','upload/jiankangbaogao_baogaotupian1.jpg,upload/jiankangbaogao_baogaotupian2.jpg,upload/jiankangbaogao_baogaotupian3.jpg','健康','','健康趋势1','健康警报1','健康建议1','2024-03-11 15:54:36'),(62,'2024-03-11 07:54:36','2222222222','老人账号2','老人姓名2','upload/jiankangbaogao_baogaotupian2.jpg,upload/jiankangbaogao_baogaotupian3.jpg,upload/jiankangbaogao_baogaotupian4.jpg','健康','','健康趋势2','健康警报2','健康建议2','2024-03-11 15:54:36'),(63,'2024-03-11 07:54:36','3333333333','老人账号3','老人姓名3','upload/jiankangbaogao_baogaotupian3.jpg,upload/jiankangbaogao_baogaotupian4.jpg,upload/jiankangbaogao_baogaotupian5.jpg','健康','','健康趋势3','健康警报3','健康建议3','2024-03-11 15:54:36'),(64,'2024-03-11 07:54:36','4444444444','老人账号4','老人姓名4','upload/jiankangbaogao_baogaotupian4.jpg,upload/jiankangbaogao_baogaotupian5.jpg,upload/jiankangbaogao_baogaotupian6.jpg','健康','','健康趋势4','健康警报4','健康建议4','2024-03-11 15:54:36'),(65,'2024-03-11 07:54:36','5555555555','老人账号5','老人姓名5','upload/jiankangbaogao_baogaotupian5.jpg,upload/jiankangbaogao_baogaotupian6.jpg,upload/jiankangbaogao_baogaotupian7.jpg','健康','','健康趋势5','健康警报5','健康建议5','2024-03-11 15:54:36'),(66,'2024-03-11 07:54:36','6666666666','老人账号6','老人姓名6','upload/jiankangbaogao_baogaotupian6.jpg,upload/jiankangbaogao_baogaotupian7.jpg,upload/jiankangbaogao_baogaotupian8.jpg','健康','','健康趋势6','健康警报6','健康建议6','2024-03-11 15:54:36'),(67,'2024-03-11 07:54:36','7777777777','老人账号7','老人姓名7','upload/jiankangbaogao_baogaotupian7.jpg,upload/jiankangbaogao_baogaotupian8.jpg,upload/jiankangbaogao_baogaotupian9.jpg','健康','','健康趋势7','健康警报7','健康建议7','2024-03-11 15:54:36'),(68,'2024-03-11 07:54:36','8888888888','老人账号8','老人姓名8','upload/jiankangbaogao_baogaotupian8.jpg,upload/jiankangbaogao_baogaotupian9.jpg,upload/jiankangbaogao_baogaotupian10.jpg','健康','','健康趋势8','健康警报8','健康建议8','2024-03-11 15:54:36'),(1710147052460,'2024-03-11 08:50:52','1710146933001','22','李明','upload/1710146997519.jpg','异常','upload/1710147004979.docx','糖尿病趋势','注意血糖和血压','饮食睡眠运动保持心情平稳','2024-03-11 16:48:53');
/*!40000 ALTER TABLE `jiankangbaogao` ENABLE KEYS */;
UNLOCK TABLES;
四、效果图
五、文章目录
目 录
摘 要 1
Abstract 2
第1章 绪 论 5
1.1研究背景 5
1.2研究的目的 5
1.3国内外研究现状 6
1.4 课题研究的主要内容 6
第2章 相关技术 7
2.1 Python语言 7
2.2 Django框架 7
2.3 MySQL数据库 7
2.4 VUE技术 8
2.5 Hadoop介绍 9
2.6 推荐算法介绍 9
2.7系统运行环境 9
2.8本章小结 10
第3章 系统分析 11
3.1系统可行性分析 11
3.1.1经济可行性分析 11
3.1.2技术可行性分析 11
3.1.3操作可行性分析 11
3.2系统现状分析 12
3.3系统用例分析 12
3.4系统流程分析 14
3.5本章小结 15
第4章 系统设计 16
4.1系统功能结构设计图 16
4.2数据库设计 16
4.3本章小结 30
第5章 系统实现 31
5.1系统功能实现 31
5.1.1前台首页页面实现 31
5.1.2个人中心页面实现 32
5.2 后台模块实现 33
5.2.1管理员模块实现 33
5.2.2服务人员模块实现 38
5.3本章小结 38
第6章 系统测试 39
6.1系统测试目的 39
6.2系统功能测试 39
6.3系统测试结论 40
6.4本章小结 40
结 论 41
参考文献 42
致 谢 43
六 、源码获取
下方名片联系我即可！！
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻
永洪科技，致力于打造全球领先的数据技术厂商，具备从数据应用方案咨询、BI、AIGC智能分析、数字孪生、数据资产、数据治理、数据实施的端到端大数据价值服务能力。
更多推荐
14
0- 0
已为社区贡献13条内容
所有评论(0)