先查询用户状态为未完成的目标,没有在取最新一条 1.SELECT t.* from app_user_target t LEFT JOIN app_user_target_device d ON t.id = d.user_target_id WHERE t.meb_id = #{mebId} AND d.device_id = #{deviceId} AND t.status = 0 LIMIT 1 2.SELECT t.* from app_user_target t LEFT JOIN app_user_target_device d ON t.id = d.user_target_id WHERE t.meb_id = #{mebId} AND d.device_id = #{deviceId} ORDER BY t.create_time DESC, t.id DESC LIMIT 1
请求参数
Query 参数
deviceId
string
可选
示例值:
d9:5c:0e:38:39:f9
Header 参数
TOK
string
可选
默认值:
{{token}}
示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl--location--request GET 'https://test.myusmile.online/user/target/selectUserNewTarget?deviceId=d9:5c:0e:38:39:f9' \
--header'TOK: '