From 4af492babeb7967b5ed74717f5e86b809077bed8 Mon Sep 17 00:00:00 2001
From: chenyc <501753378@qq.com>
Date: 星期六, 21 十二月 2024 15:54:37 +0800
Subject: [PATCH] gx
---
app.js | 302 ++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 242 insertions(+), 60 deletions(-)
diff --git a/app.js b/app.js
index dfe80cf..cda3bb2 100644
--- a/app.js
+++ b/app.js
@@ -2,6 +2,7 @@
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
@@ -45,9 +46,28 @@
config.endpoint = `facebody.cn-shanghai.aliyuncs.com`;
return new facebody20191230.default(config);
}
-app.get('/',async(req,res)=>{
- res.send('设备交换患者信息');
-})
+app.get('/', (req, res) => {
+ const title = '岱特智能'; // 动态设置标题
+ const html = `
+ <!DOCTYPE html>
+ <html lang="zh-CN">
+ <head>
+ <meta charset="UTF-8">
+ <meta name="viewport" content="width=device-width, initial-scale=1.0">
+ <title>${title}</title>
+ </head>
+ <body>
+ <iframe
+ src="https://udify.app/chatbot/irsmISE8DBCWAhxz"
+ style="width: 100%; height: 100%; min-height: 700px"
+ frameborder="0"
+ allow="microphone">
+ </iframe>
+ </body>
+ </html>
+ `;
+ res.send(html);
+ });
// 定义 /webuser 路由处理器 用患者code 换信息
app.post('/webuser', async (req, res) => {
const mode=req.body
@@ -96,6 +116,49 @@
res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
}
});
+app.post('/webuserPatientId',async(req,res)=>{
+ const mode=req.body
+ logHttps(mode)
+ const patientId = req.query.patientId;
+ if (patientId) {
+ let query = `SELECT * FROM patient_info WHERE code = '${xid}'`
+ try {
+ const [rows] = await pool.promise().query(query);
+ if (rows.length > 0) {
+ const user = rows[0];
+ const 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: getAgeFromIdCard(user.patient_identity_no),
+ headimgurl: user.patient_avatar_icon,
+ imgBaseData: '',
+ remark: ''
+ },
+ dbinfo: {}, // 如果没有需要更新的数据库信息，可以保持空
+ 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" });
+ }
+})
// 定义人脸识别 用base64图片文件换患者信息
app.post('/faceuser', async (req, res) => {
@@ -144,24 +207,22 @@
name: user.patient_name,
sex: user.patient_gender === 0 ? '男' : '女',
age: getAgeFromIdCard(user.patient_identity_no),
- usernum: user.patient_no,
- address: user.code,
+ usernum: user.code, //这个是数据返回会携带回来UID
+ address: user.patient_address,
remark: '患者人脸识别111'
},
remsg: "success"
};
- // res.json(response);
} else {
response = {
- retCode: "0",
- msg: "没有找到患者，请先检查患者code"
+ retcode: 1001,
+ remsg: "没有找到患者，请先检查患者code"
};
- // res.json(response);
}
} else {
response = {
- retCode: "0",
- msg: "没有找到患者，请先检查患者code"
+ retcode: 1001,
+ remsg: "没有找到患者，请先检查患者code"
};
}
res.json(response);
@@ -194,20 +255,22 @@
const action = req.body.action;
const deviceID = req.body.deviceID;
const mode=req.body
+ mode.action='webResults'
logHttps(mode)
try {
+
const datas=mode.datas
datas.forEach(async element => {
await installData(element)
});
response = {
- retCode: "1",
- msg: "成功"
+ recode: "2000",
+ remsg: "成功2222"
};
res.json(response)
}catch(err){
- res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ res.status(4000).json({ reCode: "4000", msg: "Invalid request parameters" });
}
})
@@ -215,26 +278,30 @@
/**
* patientId={patientId}
*/
-app.post('/getpatientInfo',async(req,res)=>{
+app.get('/getpatientInfo',async(req,res)=>{
// 使用req.query访问查询字符串参数
- const patientId = req.query.patientid;
- const mode={"action":'getpatientInfo',"patientId":patientId}
+ const patientId = req.query.patientId;
+ const clientCode = req.query.clientCode;
+ const mode={"action":'getpatientInfo',"patientId":patientId,}
+ console.log(patientId,'-----------------',clientCode)
logHttps(mode)
- if(patientId){
+ if(patientId&&clientCode){
// 输出传入的patientid值
console.log('Patient ID:',patientId)
- let query = `SELECT * FROM patient_info WHERE code = '${patientId}'`
+ let query = `SELECT * FROM patient_info WHERE patient_name_py LIKE '${patientId}' AND client_code = '${clientCode}'`
+ console.log(query)
try {
const [rows] = await pool.promise().query(query);
if (rows.length > 0) {
- const user = rows[0];
- const response = {
- code: "1",
- result:[ {
+ // const user = rows[0];
+ let users=[]
+ rows.forEach(user=>{
+ users.push({
patientId: user.code,
fullName: user.patient_name,
gender: user.patient_gender,
age: getAgeFromIdCard(user.patient_identity_no),
+ birthday:'',
phoneNum:user.patient_mobile,
address: user.patient_avatar_icon,
idType: user.patient_identity_type,
@@ -246,16 +313,15 @@
examDoctor:'',
examDept:"",
diagnosisDoctor:''
- }],
- msg: "success"
- };
- res.json(response);
+ })
+ })
+ res.json(users);
} else {
const response = {
retCode: "0",
msg: "没有找到患者，请先检查患者code"
};
- res.json(response);
+ res.json([]);
}
} catch (err) {
console.error(err);
@@ -264,22 +330,129 @@
}else{
// 如果请求参数不符合预期，则返回错误信息
- res.status(400).json({ retCode: "-1", msg: "Invalid request parameters" });
+ res.status(400).json({ retCode: "-1", msg: "Invalid request parameters333" });
}
-
- console
})
/**
* PostCheckExam 病人信息及检测结果以JSON的形式回传至服务器
*/
-app.post('/PostCheckExam',async(req,res)=>{
+app.post('/PostCheckExam',(req,res)=>{
+ try {
+ const mode={
+ action:'PostCheckExam',
+ params:'jjjj'
+ }
+ logHttps(mode)
+ // 查看body参数
+ const body=req.body
+ console.log(body)
+ const data={
+ id:0,
+ code:body.examId,
+ patient_code :body.patientId,
+ client_code:'',
+ exam_id:body.examId,
+ SBPLB:body.SBPLB,
+ MBPLB:body.MBPLB,
+ DBPLB:body.DBPLB,
+ PPLB:body.PPLB,
+ SBPRB:body.SBPRB,
+ MBPRB:body.MBPRB,
+ DBPRB:body.DBPRB,
+ PPRB:body.PPRB,
+ SBPLA:body.SBPLA,
+ MBPLA:body.MBPLA,
+ DBPLA:body.DBPLA,
+ SBPRA:body.SBPRA,
+ MBPRA:body.MBPRA,
+ DBPRA:body.DBPRA,
+ ABIL:body.ABIL,
+ ABIR:body.ABIR,
+ BAIL:body.BAIL,
+ BAIR:body.BAIR,
+ PWVL:body.PWVL,
+ PWVR:body.PWVR,
+ TBIL:body.TBIL,
+ TBIR:body.TBIR,
+ SBPLAPTA:body.SBPLAPTA,
+ DBPLAPTA:body.DBPLAPTA,
+ MBPLAPTA:body.MBPLAPTA,
+ PPLAPTA:body.PPLAPTA,
+ SBPRAPTA:body.SBPRAPTA,
+ DBPRAPTA:body.DBPRAPTA,
+ MBPRAPTA:body.MBPRAPTA,
+ PPRAPTA:body.PPRAPTA,
+ SBPLAFA:body.SBPLAFA,
+ DBPLAFA:body.DBPLAFA,
+ MBPLAFA:body.MBPLAFA,
+ PPLAFA:body.PPLAFA,
+ SBPRAFA:body.SBPRAFA,
+ DBPRAFA:body.DBPRAFA,
+ MBPRAFA:body.MBPRAFA,
+ PPRAFA:body.PPRAFA,
+ index_LB:body.indexLB,
+ index_RB:body.indexRB,
+ index_LAPTA:body.indexLAPTA,
+ index_RAPTA:body.indexRAPTA,
+ index_LAFA:body.indexLAFA,
+ index_RAFA:body.indexRAFA,
+ image:body.image,
+ request_doctor:body.requestDoctor,
+ request_department:body.requestDepartment,
+ request_date:body.requestDate,
+ exam_department:body.examDepartment,
+ diagnostician_doctor:body.diagnosticianDoctor,
+ check_date:body.checkDate,
+ check_result:body.checkResult,
+ diagnosis:body.diagnosis,
+ exam_type_id:body.examTypeId,
+ exam_type_name:body.examTypeName,
+ operator_doctor:body.operatorDoctor,
+ abi_advice:body.abiAdvice,
+ pwv_result:body.pwvResult
+ }
+ const { query, params } = createInsertQuery('patient_result_from_doppler_blood_flow_device', data);
+ pool.query(query, params, (error, results) => {
+ if (error) {
+ console.error('Error inserting data:', error);
+ return res.status(500).json({Status:'error', Msg: '数据库错误'+error });
+ }
+
+ res.json({ Status:'SUCCESS',Msg: '插入成功'+ results.insertId });
+ });
+ }
+ catch(err){
+ console.log(err)
+ res.status(400).json({ retCode: "-1", msg: "请求出错了" });
+ }
+
+
})
+
// 启动服务器
app.listen(port, async () => {
console.log(`Server running at http://localhost:${port}/`);
});
+/**
+ *
+ * @param {表名称} tableName
+ * @param {表列内容} data
+ * @returns
+ */
+const createInsertQuery=(tableName, data) =>{
+ const columns = Object.keys(data).map(key => `\`${key}\``).join(', ');
+ const placeholders = Object.keys(data).map(() => '?').join(', ');
+
+ const query = `INSERT INTO \`${tableName}\` (${columns}) VALUES (${placeholders})`;
+
+ // 返回查询字符串和参数数组
+ return {
+ query,
+ params: Object.values(data)
+ };
+}
/**
*
@@ -320,7 +493,6 @@
await fs.mkdir(directory, { recursive: true });
} catch (err) {
console.error('Error creating directory:', err);
- throw err;
}
}
// 将文件上传到阿里的oss
@@ -334,44 +506,54 @@
const logHttps=(mode)=>{
try{
let sqlStr=`INSERT INTO system_log (id, code, url, parameter) VALUES (0, '', '${mode.action}', '${JSON.stringify(mode)}')`
+ console.log(sqlStr)
pool.promise().query(sqlStr)
}catch (err) {
- console.error('Error creating directory2222:', err);
- throw err;
+ console.error('访问日志记录错误:', err);
}
}
// 插入数据
const installData=async (mode)=>{
+ console.log(mode)
try{
- let sqlStr=`INSERT INTO patient_rtcf_result (id, code, patient_code,`+
+ let selectSql=`SELECT * FROM patient_rtcf_result WHERE code='${mode.recordNo}'`
+ const [rows] = await pool.promise().query(selectSql);
+ if(rows.length>0){
+ let updateSql=''
+ if(mode.fatFree){
+ updateSql=`UPDATE patient_rtcf_result SET rtcf_json_bf ='${JSON.stringify(mode)}'`
+ }else if (mode.bmi){
+ updateSql=`UPDATE patient_rtcf_result SET rtcf_json_bmi ='${JSON.stringify(mode)}'`
+ }
+ if(updateSql){
+ console.log(`-------------------------更新${updateSql}---------`)
+ console.log(updateSql)
+ await pool.promise().query(updateSql)
+ }
+ }else{
+ console.log('34')
+ // 临时的人体成分分析
+ let bf=''
+ // 临时的身高体重
+ let bmi=''
+ if(mode.fatFree){
+ bf=JSON.stringify(mode)
+ }
+ if(mode.bmi){
+ bmi=JSON.stringify(mode)
+ }
+ console.log(`bf=${bf},bmi=====${bmi}`)
+ 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.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('-------------------')
+ `create_time)`+
+ `VALUES (0, '${mode.recordNo}', '${mode.userID}', '${mode.measureTime}','${bmi}','${bf}','${moment(new Date()).format('YYYY-MM-DD HH:mm:ss')}')`
console.log(sqlStr)
- await pool.promise().query(sqlStr)
+ await pool.promise().query(sqlStr)
+ }
+
}catch(err){
- console.log('数据写入异常')
+ console.log('数据写入异常22')
}
}
--
Gitblit v1.8.0