34

chenyc

2024-12-09 54ea363cf6dcd585b10f95c750dd1a830c116913

34

 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')
    }
}


 test.js

@@ -1,2 +0,0 @@
{"action":"webResults","deviceID":"G241016090739070",
"datas":[{"address":"","age":"25","UID":"20241104141547932","occurTime":"1730700947933","name":"雷雨","timestamp":"1730700947933","birthday":"","sex":"1","BMI":{"height":"168.5","bmi_normal":"[18.5,24.9]","weight":"56.3","bmi":"19.8"}}]}