From ed2ff23d1c95fcfa3077b4c82859a39755e8ea00 Mon Sep 17 00:00:00 2001
From: chenyc <501753378@qq.com>
Date: 星期二, 29 十月 2024 21:20:22 +0800
Subject: [PATCH] 34
---
app.js | 348 ++++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 266 insertions(+), 82 deletions(-)
diff --git a/app.js b/app.js
index 14da19b..e82de23 100644
--- a/app.js
+++ b/app.js
@@ -2,17 +2,24 @@
const bodyParser = require('body-parser');
const mysql = require('mysql2');
const fs = require('fs').promises;
+const fs2=require('fs')
const path = require('path');
+const moment = require('moment')
// 转成能识别的url
const ViapiUtil = require('@alicloud/viapi-utils');
const facebody20191230 = require('@alicloud/facebody20191230');
const OpenApi = require('@alicloud/openapi-client');
const Util = require('@alicloud/tea-util');
-const Tea = require('@alicloud/tea-typescript');
const app = express();
const port = 3000;
+
+// 设置 JSON 请求体的最大大小为 5MB
+app.use(express.json({ limit: '5mb' }));
+
+// 设置 URL 编码请求体的最大大小为 5MB
+app.use(express.urlencoded({ extended: true, limit: '5mb' }));
// 使用 body-parser 中间件解析 JSON 请求体
app.use(bodyParser.json());
@@ -39,7 +46,9 @@
config.endpoint = `facebody.cn-shanghai.aliyuncs.com`;
return new facebody20191230.default(config);
}
-
+app.get('/', (req, res) => {
+ res.send('<h1>Hello World!</h1>');
+ });
// 定义 /webuser 路由处理器 用患者code 换信息
app.post('/webuser', async (req, res) => {
const mode=req.body
@@ -63,7 +72,7 @@
userNum: user.patient_no,
name: user.patient_name,
sex: user.patient_gender === 0 ? '男' : '女',
- age: user.patient_age_2,
+ age: getAgeFromIdCard(user.patient_identity_no),
headimgurl: user.patient_avatar_icon,
imgBaseData: '',
remark: ''
@@ -91,93 +100,189 @@
// 定义人脸识别 用base64图片文件换患者信息
app.post('/faceuser', async (req, res) => {
- const action = req.body.action;
- const deviceID = req.body.deviceID;
- // base64图像内容，base64 编码(长宽像素值范围：80*80~200*200，注意：图片的base64 编码是不包含图片头的，如 data:image/jpg;base64,)
- const content = req.body.content;
- const mode=req.body
- logHttps(mode)
- if (action == 'doFace' && deviceID && content) {
- // 转成oss路径
- const ossurl = await base64toFile(content, deviceID)
- console.log('得到oss图片路径', ossurl)
- let searchFaceRequest = new facebody20191230.SearchFaceRequest({
- dbName: 'Face_emeishan',
- imageUrl: ossurl,
- limit: 1,
- });
+ try{
+ const action = req.body.action;
+ const deviceID = req.body.deviceID;
+ // base64图像内容，base64 编码(长宽像素值范围：80*80~200*200，注意：图片的base64 编码是不包含图片头的，如 data:image/jpg;base64,)
+ const content = req.body.content;
+ const mode=req.body
+ mode.content=''
+ logHttps(mode)
+ if (action == 'doFace' && deviceID && content) {
+ // 转成oss路径
+ const ossurl = await base64toFile(content, deviceID)
+ console.log('得到oss图片路径', ossurl)
+ let searchFaceRequest = new facebody20191230.SearchFaceRequest({
+ dbName: 'Face_systemtest',
+ imageUrl: ossurl,
+ limit: 1,
+ });
- let runtime = new Util.RuntimeOptions({});
- try {
- // 复制代码运行请自行打印 API 的返回值
- const data = await createClient().searchFaceWithOptions(searchFaceRequest, runtime);
- const matchList = data.body.data?.matchList
- let response = null
- if (matchList?.length > 0) {
- const faceItems = matchList[0].faceItems
- if (faceItems?.length === 0) {
- console.log('没有找到患者对应的人脸')
- response = {
- retCode: "0",
- msg: "没有找到患者，请先检查患者code"
- };
- } else if (faceItems[0].score >= 0.2) {
- const entityId = faceItems[0].entityId
- console.log(entityId, '患者id找到了')
- let query = `SELECT * FROM patient_info WHERE code = '${entityId}'`
- const [rows] = await pool.promise().query(query);
- if (rows.length > 0) {
- const user = rows[0];
- response = {
- retCode: "1",
- uinfo: {
- title: user.client_code,
- cardID: user.code,
- userNum: user.patient_no,
- name: user.patient_name,
- sex: user.patient_gender === 0 ? '男' : '女',
- age: user.patient_age_2,
- headimgurl: user.patient_avatar_icon,
- imgBaseData: '',
- remark: ''
- },
- dbinfo: {}, // 如果没有需要更新的数据库信息，可以保持空
- msg: "success"
- };
- // res.json(response);
- } else {
+ let runtime = new Util.RuntimeOptions({});
+ try {
+ // 复制代码运行请自行打印 API 的返回值
+ const data = await createClient().searchFaceWithOptions(searchFaceRequest, runtime);
+ const matchList = data.body.data?.matchList
+ let response = null
+ if (matchList?.length > 0) {
+ const faceItems = matchList[0].faceItems
+ if (faceItems?.length === 0) {
+ console.log('没有找到患者对应的人脸')
response = {
retCode: "0",
msg: "没有找到患者，请先检查患者code"
};
- // res.json(response);
+ } else if (faceItems[0].score >= 0.2) {
+ const entityId = faceItems[0].entityId
+ console.log(entityId, '患者id找到了')
+ let query = `SELECT * FROM patient_info WHERE code = '${entityId}'`
+ const [rows] = await pool.promise().query(query);
+ if (rows.length > 0) {
+ const user = rows[0];
+ response = {
+ recode: 2001,
+ userinfo: {
+ name: user.patient_name,
+ sex: user.patient_gender === 0 ? '男' : '女',
+ age: getAgeFromIdCard(user.patient_identity_no),
+ usernum: user.code, //这个是数据返回会携带回来UID
+ address: user.patient_address,
+ remark: '患者人脸识别111'
+ },
+ remsg: "success"
+ };
+ } else {
+ response = {
+ retcode: 1001,
+ remsg: "没有找到患者，请先检查患者code"
+ };
+ }
+ } else {
+ response = {
+ retcode: 1001,
+ remsg: "没有找到患者，请先检查患者code"
+ };
}
- } else {
- response = {
- retCode: "0",
- msg: "没有找到患者，请先检查患者code"
- };
+ res.json(response);
}
- res.json(response);
- }
- else {
- res.status(500).json({ retCode: "-1", msg: "没有识别到患者" });
- }
- } catch (error) {
- // 此处仅做打印展示，请谨慎对待异常处理，在工程项目中切勿直接忽略异常。
- // 错误 message
- console.log(error)
- res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ else {
+ res.status(500).json({ retCode: "-1", msg: "没有识别到患者" });
+ }
+ } catch (error) {
+ // 此处仅做打印展示，请谨慎对待异常处理，在工程项目中切勿直接忽略异常。
+ // 错误 message
+ console.log(error)
+ res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ }
+ } else {
+ // 如果请求参数不符合预期，则返回错误信息
+ res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
}
- } else {
- // 如果请求参数不符合预期，则返回错误信息
- res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ }catch(err){
+ res.status(400).json({ retCode: "-1", msg: err });
}
+})
+// 定义设备数据回传接口
+// 定义数据回传接口
+app.post('/webResults',async (req, res) =>{
+ const action = req.body.action;
+ const deviceID = req.body.deviceID;
+ const mode=req.body
+ logHttps(mode)
+ try {
+ const datas=mode.datas
+ datas.forEach(async element => {
+ await installData(element)
+ });
+ response = {
+ retCode: "1",
+ msg: "成功"
+ };
+ res.json(response)
+
+ }catch(err){
+ res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ }
+
+})
+// 定义北京悦琦创通科技有限公司VBP-10系列HTTP通信协议
+/**
+ * patientId={patientId}
+ */
+app.get('/getpatientInfo',async(req,res)=>{
+ // 使用req.query访问查询字符串参数
+ const patientId = req.query.patientid;
+ const mode={"action":'getpatientInfo',"patientId":patientId}
+ logHttps(mode)
+ if(patientId){
+ // 输出传入的patientid值
+ console.log('Patient ID:',patientId)
+ let query = `SELECT * FROM patient_info WHERE code = '${patientId}'`
+ try {
+ const [rows] = await pool.promise().query(query);
+ if (rows.length > 0) {
+ const user = rows[0];
+ const response = {
+ code: "1",
+ result:[ {
+ patientId: user.code,
+ fullName: user.patient_name,
+ gender: user.patient_gender,
+ age: getAgeFromIdCard(user.patient_identity_no),
+ phoneNum:user.patient_mobile,
+ address: user.patient_avatar_icon,
+ idType: user.patient_identity_type,
+ idNum: user.patient_identity_no,
+ height:'',
+ weight:'',
+ requestDoctor:'',
+ requestDept :"",
+ examDoctor:'',
+ examDept:"",
+ diagnosisDoctor:''
+ }],
+ msg: "success"
+ };
+ res.json(response);
+ } else {
+ const response = {
+ retCode: "0",
+ msg: "没有找到患者，请先检查患者code"
+ };
+ res.json(response);
+ }
+ } catch (err) {
+ console.error(err);
+ res.status(500).json({ retCode: "-1", msg: "Database error" });
+ }
+
+ }else{
+ // 如果请求参数不符合预期，则返回错误信息
+ res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ }
+
+
+ console
+})
+/**
+ * PostCheckExam 病人信息及检测结果以JSON的形式回传至服务器
+ */
+app.post('/PostCheckExam',async(req,res)=>{
+ const mode=req.body
+ if(mode){
+ logHttps(mode)
+ }else{
+ mode.action='hahhaha'
+ logHttps(mode)
+ }
+ res.status(400).json({ retCode: "-1", msg: "kankan" });
+
+
})
// 启动服务器
app.listen(port, async () => {
@@ -223,7 +328,6 @@
await fs.mkdir(directory, { recursive: true });
} catch (err) {
console.error('Error creating directory:', err);
- throw err;
}
}
// 将文件上传到阿里的oss
@@ -235,8 +339,88 @@
// 访问日志记录
const logHttps=(mode)=>{
- console.log(mode)
- console.log(JSON.stringify(mode))
- let sqlStr=`INSERT INTO system_log (id, code, url, parameter) VALUES (0, '', '${mode.action}', '${JSON.stringify(mode)}')`
- pool.promise().query(sqlStr)
-}
\ No newline at end of file
+ try{
+ let sqlStr=`INSERT INTO system_log (id, code, url, parameter) VALUES (0, '', '${mode.action}', '${JSON.stringify(mode)}')`
+ pool.promise().query(sqlStr)
+ }catch (err) {
+ console.error('访问日志记录错误:', err);
+ }
+}
+// 插入数据
+const installData=async (mode)=>{
+ try{
+ let selectSql=`SELECT * FROM patient_rtcf_result WHERE code='${mode.occurTime}'`
+ const [rows] = await pool.promise().query(selectSql);
+ if(rows.length>0){
+ let updateSql=''
+ if(mode.BF){
+ updateSql=`UPDATE patient_rtcf_result SET rtcf_json_bf ='${JSON.stringify(mode.BF)}'`
+ }else if (mode.BMI){
+ updateSql=`UPDATE patient_rtcf_result SET rtcf_json_bmi ='${JSON.stringify(mode.BMI)}'`
+ }
+ if(updateSql){
+ console.log(`-------------------------更新${updateSql}---------`)
+ console.log(updateSql)
+ await pool.promise().query(updateSql)
+ }
+ }else{
+ let sqlStr=`INSERT INTO patient_rtcf_result (id, code, patient_code,`+
+ `comm_time,rtcf_json_bmi,`+
+ `rtcf_json_bp,`+
+ `rtcf_json_bf,`+
+ `rtcf_json_temp,`+
+ `rtcf_json_bo,`+
+ `rtcf_json_bs,`+
+ `rtcf_json_whr,`+
+ `rtcf_json_ncg,`+
+ `rtcf_json_zytz,`+
+ `rtcf_json_ecg,`+
+ `rtcf_json_xzsx,`+
+ `rtcf_json_eye,`+
+ `rtcf_json_sds,`+
+ `rtcf_json_txhxdb,`+
+ `rtcf_json_fei,`+
+ `rtcf_jiu,`+
+ `rtcf_gmd)`+
+ `VALUES (0, '${mode.occurTime}', '${mode.UID}', '${moment(new Date()).format('YYYY-MM-DD HH:mm:ss')}','${JSON.stringify(mode.BMI)}',`+
+ `'${JSON.stringify(mode.BP)}','${JSON.stringify(mode.BF)}','${JSON.stringify(mode.temp)}','${JSON.stringify(mode.bo)}',`+
+ `'${JSON.stringify(mode.bs)}','${JSON.stringify(mode.whr)}','${JSON.stringify(mode.ncg)}','${JSON.stringify(mode.zytz)}',`+
+ `'${JSON.stringify(mode.ecg)}','${JSON.stringify(mode.xzsx)}','${JSON.stringify(mode.eye)}',`+
+ `'${JSON.stringify(mode.sds)}','${JSON.stringify(mode.thxhdb)}','${JSON.stringify(mode.fei)}','${JSON.stringify(mode.jiu)}','${JSON.stringify(mode.gmd)}')`
+ console.log(sqlStr)
+ await pool.promise().query(sqlStr)
+ }
+
+ }catch(err){
+ console.log('数据写入异常')
+ }
+}
+
+function getAgeFromIdCard(idCard) {
+ // 检查身份证号码长度是否正确
+ if (idCard.length !== 18) {
+ // throw new Error('身份证号码长度必须为18位');
+ return ''
+ }
+ // 获取出生年月日
+ const birthYear = parseInt(idCard.substring(6, 10), 10);
+ const birthMonth = parseInt(idCard.substring(10, 12), 10);
+ const birthDay = parseInt(idCard.substring(12, 14), 10);
+
+ // 获取当前日期
+ const now = new Date();
+ const currentYear = now.getFullYear();
+ const currentMonth = now.getMonth() + 1; // 注意：getMonth() 返回的月份是从0开始的
+ const currentDay = now.getDate();
+
+ // 计算年龄
+ let age = currentYear - birthYear;
+
+ // 如果当前日期在生日之前，则年龄减一
+ if (currentMonth < birthMonth || (currentMonth === birthMonth && currentDay < birthDay)) {
+ age--;
+ }
+
+ return age;
+}
+
--
Gitblit v1.8.0