5.27——工作记录

前言

昨天完成的任务





今天的任务：
1.测试
2.信息类型得是session传来的一系列的id

过程

效果

总结

--感知探测心跳bug
SELECT ase_id,ase01,ase20,ase30 from  dtm_statusperception_heart 
LEFT JOIN  dtm_usecompany_device ON dtm_statusperception_heart.ase01  = dtm_usecompany_device.dud02 
LEFT JOIN dtm_usecompany_info ON dtm_usecompany_device.dud07 = dtm_usecompany_info.dui_id 
LEFT OUTER JOIN dtm_usecompany_trade ON dtm_usecompany_device.dud07 = dtm_usecompany_trade.dut04 WHERE 1=1
--感知探测心跳最终确定sql

SELECT ase_id,ase01,ase20,ase30 from  dtm_statusperception_heart 
LEFT JOIN dtm_usecompany_info ON dtm_statusperception_heart.ase20 = dtm_usecompany_info.dui_id 
LEFT OUTER JOIN dtm_usecompany_trade ON dtm_statusperception_heart.ase20 = dtm_usecompany_trade.dut04 WHERE 1=1
--人脸识别心跳
SELECT ase_id,ase01,ase20,ase30,ase31,dfh01,dfh02,dfh03 from dtm_facesnapshot_heart 
LEFT JOIN dtm_usecompany_info ON dtm_facesnapshot_heart.ase20 = dtm_usecompany_info.dui_id 
LEFT JOIN dtm_usecompany_trade ON dtm_facesnapshot_heart.ase20 = dtm_usecompany_trade.dut04 WHERE 1=1