| | |
| | | //所属灯杆 |
| | | private String belongTo; |
| | | //设备状态:在线/离线 |
| | | private String equipmentState; |
| | | private int equipmentState; |
| | | //绑定状态:已绑定/未绑定 |
| | | private String bindingState; |
| | | private int bindingState; |
| | | //执行的任务 |
| | | private String task; |
| | | //接入时间 |
| | |
| | | private String belongTo; |
| | | //地址 |
| | | private String address; |
| | | //设备状态:在线/离线 |
| | | private String equipmentState; |
| | | //工作状态:正常使用/禁止使用 |
| | | private String workState; |
| | | //绑定状态:已绑定/未绑定 |
| | | private String bindingState; |
| | | //设备状态:在线:1/离线:0 |
| | | private int equipmentState; |
| | | //工作状态:正常使用:1/禁止使用:0 |
| | | private int workState; |
| | | //绑定状态:已绑定:1/未绑定:0 |
| | | private int bindingState; |
| | | //备注 |
| | | private String note; |
| | | //接入时间 |
| | |
| | | |
| | | @Mapper |
| | | public interface AdvisementPlayerMapper extends BaseMapper<AdvisementPlayer> { |
| | | List<AdvisementPlayer> listAdvisementPlayerByKeyword(String keyword, String equipmentState1, String equipmentState2, |
| | | String bindingState1, String bindingState2); |
| | | List<AdvisementPlayer> listAdvisementPlayerByKeyword(String keyword, int equipmentState1, int equipmentState2, |
| | | int bindingState1, int bindingState2); |
| | | } |
| | |
| | | |
| | | @Mapper |
| | | public interface MonitorMapper extends BaseMapper<Monitor> { |
| | | List<Monitor> listMonitorByKeyword(String keyword, String equipmentState1, String equipmentState2, |
| | | String bindingState1, String bindingState2); |
| | | List<Monitor> listMonitorByKeyword(String keyword, int equipmentState1, int equipmentState2, |
| | | int bindingState1, int bindingState2); |
| | | } |
| | |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="macAddress" column="mac_address" jdbcType="VARCHAR"/> |
| | | <result property="belongTo" column="belong_to" jdbcType="VARCHAR"/> |
| | | <result property="equipmentState" column="equipment_state" jdbcType="VARCHAR"/> |
| | | <result property="bindingState" column="binding_state" jdbcType="VARCHAR"/> |
| | | <result property="equipmentState" column="equipment_state" jdbcType="INTEGER"/> |
| | | <result property="bindingState" column="binding_state" jdbcType="INTEGER"/> |
| | | <result property="task" column="task" jdbcType="VARCHAR"/> |
| | | <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> |
| | | </resultMap> |
| | |
| | | <result property="serialNumber" column="serial_number" jdbcType="VARCHAR"/> |
| | | <result property="belongTo" column="belong_to" jdbcType="VARCHAR"/> |
| | | <result property="address" column="address" jdbcType="VARCHAR"/> |
| | | <result property="equipmentState" column="equipment_state" jdbcType="VARCHAR"/> |
| | | <result property="workState" column="work_state" jdbcType="VARCHAR"/> |
| | | <result property="bindingState" column="binding_state" jdbcType="VARCHAR"/> |
| | | <result property="equipmentState" column="equipment_state" jdbcType="INTEGER"/> |
| | | <result property="workState" column="work_state" jdbcType="INTEGER"/> |
| | | <result property="bindingState" column="binding_state" jdbcType="INTEGER"/> |
| | | <result property="note" column="note" jdbcType="VARCHAR"/> |
| | | <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> |
| | | </resultMap> |
| | |
| | | |
| | | private String keyword; |
| | | @NotEmpty |
| | | private String equipmentState; |
| | | private int equipmentState; |
| | | @NotEmpty |
| | | private String bindingState; |
| | | private int bindingState; |
| | | } |
| | |
| | | |
| | | private String keyword; |
| | | @NotEmpty |
| | | private String equipmentState; |
| | | private int equipmentState; |
| | | @NotEmpty |
| | | private String bindingState; |
| | | private int bindingState; |
| | | } |
| | |
| | | */ |
| | | public List<AdvisementPlayer> listAdvisementPlayerParamByKeyword(AdvisementPlayerParam advisementPlayerParam) { |
| | | //设备状态:在线/离线/全部 |
| | | String equipmentState1; |
| | | String equipmentState2; |
| | | if ("全部".equals(advisementPlayerParam.getEquipmentState())) { |
| | | equipmentState1 = "在线"; |
| | | equipmentState2 = "离线"; |
| | | int equipmentState1; |
| | | int equipmentState2; |
| | | if (2 == advisementPlayerParam.getEquipmentState()) { |
| | | //在线 |
| | | equipmentState1 = 1; |
| | | //离线 |
| | | equipmentState2 = 0; |
| | | } else { |
| | | equipmentState1 = advisementPlayerParam.getEquipmentState(); |
| | | equipmentState2 = advisementPlayerParam.getEquipmentState(); |
| | | } |
| | | |
| | | //绑定状态:已绑定/未绑定/全部 |
| | | String bindingState1; |
| | | String bindingState2; |
| | | if ("全部".equals(advisementPlayerParam.getBindingState())) { |
| | | bindingState1 = "已绑定"; |
| | | bindingState2 = "未绑定"; |
| | | int bindingState1; |
| | | int bindingState2; |
| | | if (2 == advisementPlayerParam.getBindingState()) { |
| | | //已绑定 |
| | | bindingState1 = 1; |
| | | //未绑定 |
| | | bindingState2 = 0; |
| | | } else { |
| | | bindingState1 = advisementPlayerParam.getBindingState(); |
| | | bindingState2 = advisementPlayerParam.getBindingState(); |
| | |
| | | } |
| | | return removeById(Id); |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | |
| | | */ |
| | | public List<Monitor> listMonitorByKeyword(MonitorParam monitorParam) { |
| | | //设备状态:在线/离线/全部 |
| | | String equipmentState1; |
| | | String equipmentState2; |
| | | if ("全部".equals(monitorParam.getEquipmentState())) { |
| | | equipmentState1 = "在线"; |
| | | equipmentState2 = "离线"; |
| | | int equipmentState1; |
| | | int equipmentState2; |
| | | if (2 == monitorParam.getEquipmentState()) { |
| | | //在线 |
| | | equipmentState1 = 1; |
| | | //离线 |
| | | equipmentState2 = 0; |
| | | } else { |
| | | equipmentState1 = monitorParam.getEquipmentState(); |
| | | equipmentState2 = monitorParam.getEquipmentState(); |
| | | } |
| | | |
| | | //绑定状态:已绑定/未绑定/全部 |
| | | String bindingState1; |
| | | String bindingState2; |
| | | if ("全部".equals(monitorParam.getBindingState())) { |
| | | bindingState1 = "已绑定"; |
| | | bindingState2 = "未绑定"; |
| | | int bindingState1; |
| | | int bindingState2; |
| | | if (2 == monitorParam.getBindingState()) { |
| | | //已绑定 |
| | | bindingState1 = 1; |
| | | //未绑定 |
| | | bindingState2 = 0; |
| | | } else { |
| | | bindingState1 = monitorParam.getBindingState(); |
| | | bindingState2 = monitorParam.getBindingState(); |
| | |
| | | } |
| | | return removeById(Id); |
| | | } |
| | | |
| | | |
| | | |
| | | } |