gistfile1.kt

    @SuppressLint("Range")
    public ArrayList<EquipmentModel> getRoomEquipmentByType(String whereQuery, String roomId) {
        ArrayList<EquipmentModel> equipmentList = new ArrayList<>();
        SQLiteDatabase readableDatabase = getDatabase().getReadableDatabase();

        String query = "SELECT * FROM " + RoomEquipmentTable.TABLE_NAME +
                " WHERE " + RoomEquipmentTable.ROOM_ID + " = '" + roomId + "' AND " + whereQuery +
                " ORDER BY " + RoomEquipmentTable.PRIORITY + " DESC";

        try (Cursor cursor = readableDatabase.rawQuery(query, null)) {
            if (cursor.getCount() > 0) {
                while (cursor.moveToNext()) {
                    String deviceType = cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.DEVICE));
                    String description = cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.DESCRIPTION));

                    if ("hangings".equals(deviceType)) {
                        if (description == null || !description.toLowerCase().contains("zasłon")) {
                            Log.d("EquipmentModule", "Skipping 'hangings' device, it's not a curtain (zasłona). Name: " + description);
                            continue;
                        }
                    }
                    EquipmentModel equipmentModel = new EquipmentModel();
                    equipmentModel.setId(cursor.getInt(cursor.getColumnIndex(RoomEquipmentTable.ID)));
                    equipmentModel.setManufacturer(cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.MANUFACTURER)));
                    equipmentModel.setDevice(deviceType);
                    equipmentModel.setIp(cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.IP)));
                    equipmentModel.setPort(cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.PORT)));
                    equipmentModel.setAddress(cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.ADDRESS)));
                    equipmentModel.setSlot(cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.SLOT)));
                    equipmentModel.setRange(cursor.getString(cursor.getColumnIndex(RoomEquipmentTable.RANGE)));
                    equipmentModel.setDescription(description);
                    equipmentModel.setRefreshTime(cursor.getInt(cursor.getColumnIndex(RoomEquipmentTable.REFRESH_TIME)));
                    equipmentModel.setNotifyTargetGroup(cursor.getInt(cursor.getColumnIndex(RoomEquipmentTable.NOTIFY_TARGET_GROUP)));
                    equipmentModel.setGroupId(cursor.getInt(cursor.getColumnIndex(RoomEquipmentTable.GROUP_ID)));
                    equipmentModel.setPriority(cursor.getInt(cursor.getColumnIndex(RoomEquipmentTable.PRIORITY)));

                    equipmentList.add(equipmentModel);
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return equipmentList;
    }