From 54ea363cf6dcd585b10f95c750dd1a830c116913 Mon Sep 17 00:00:00 2001
From: chenyc <501753378@qq.com>
Date: 星期一, 09 十二月 2024 14:50:35 +0800
Subject: [PATCH] 34
---
app.js | 53 ++++++++++++++++++++++++-----------------------------
1 files changed, 24 insertions(+), 29 deletions(-)
diff --git a/app.js b/app.js
index efa19d0..eafc44d 100644
--- a/app.js
+++ b/app.js
@@ -214,20 +214,20 @@
const mode=req.body
mode.action='webResults'
logHttps(mode)
- console.log('----------')
try {
+
const datas=mode.datas
datas.forEach(async element => {
await installData(element)
});
response = {
recode: "2000",
- remsg: "成功"
+ remsg: "成功2222"
};
res.json(response)
}catch(err){
- res.status(4000).json({ retCode: "-1", msg: "Invalid request parameters" });
+ res.status(4000).json({ reCode: "4000", msg: "Invalid request parameters" });
}
})
@@ -370,15 +370,16 @@
}
// 插入数据
const installData=async (mode)=>{
+ console.log(mode)
try{
- let selectSql=`SELECT * FROM patient_rtcf_result WHERE code='${mode.occurTime}'`
+ 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.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(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}---------`)
@@ -386,35 +387,29 @@
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.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)}')`
+ `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)
}
}catch(err){
- console.log('数据写入异常')
+ console.log('数据写入异常22')
}
}
--
Gitblit v1.8.0