| | |
| | | xou.id_card_front, xou.id_card_back, xou.driver_license, xou.certificate_of_no_criminal_record, |
| | | xou.training_graduation_certificate, xou.is_deleted, xou.create_time, xou.update_time, xou.create_by |
| | | from xp_operations_user xou |
| | | left join xp_operations_role xore on xou.id = xore.operations_user_id |
| | | where xou.is_deleted = 0 |
| | | <if test="query.nickName != null and query.nickName != ''"> |
| | | and xou.nick_name like concat('%',#{query.nickName},'%') |
| | |
| | | and xou.phone_number like concat('%',#{query.phoneNumber},'%') |
| | | </if> |
| | | <if test="query.roleId != null"> |
| | | and xore.role_id = #{query.roleId} |
| | | AND EXISTS (SELECT 1 FROM xp_operations_role xor |
| | | WHERE xor.operations_user_id = xou.id |
| | | AND xor.role_id = #{query.roleId}) |
| | | </if> |
| | | <if test="query.status != null"> |
| | | and xou.status = #{query.status} |
| | | </if> |
| | | |
| | | |
| | | order by xou.create_time desc |
| | | </select> |
| | | |
| | |
| | | */ |
| | | @GetMapping("/base/v1/aliPush/test") |
| | | public R<String> test(){ |
| | | String s = aliPushUtil.pushMessage(1, "13540694412", "事故即将超时提示", "{\"content\":\"车辆川A12345在天府新谷发生的紧急事故即将超时,剩余时间5分钟,请及时到达现场!\",\"strategy\":2\"type\":7,\"id\":1}","NOTICE"); |
| | | String s = aliPushUtil.pushMessage(1, "13540694412", "事故即将超时提示", "{\"content\":\"你目前剩余1条待办任务,请及时处理!\",\"strategy\":6,\"type\":2,\"id\":3}","NOTICE"); |
| | | return R.ok(s); |
| | | } |
| | | /** |
| | |
| | | */ |
| | | @GetMapping("/base/v1/aliPush/test1") |
| | | public R<String> test1(){ |
| | | String s = aliPushUtil.pushMessage(1, "13540694412", "APP版本更新提示", "{\"content\":\"新版本上线啦!请前往更新。\",\"strategy\":8\"type\":0,\"id\":0}","MESSAGE"); |
| | | String s = aliPushUtil.pushMessage(1, "13540694412", "APP版本更新提示", "{\"content\":\"新版本上线啦!请前往更新。\",\"strategy\":8,\"type\":0,\"id\":0}","MESSAGE"); |
| | | return R.ok(s); |
| | | } |
| | | |