Добавить просмотр лайков сообщений канала

This commit is contained in:
AidarKC
2026-09-09 17:01:13 +03:00
parent 9f77c54955
commit 2d059e9ff5
11 changed files with 595 additions and 20 deletions
@@ -75,6 +75,7 @@ import server.logic.ws_protocol.JSON.handlers.connections.entyties.Net_GetFriend
import server.logic.ws_protocol.JSON.handlers.channels.ChannelNamesStateBootstrapper;
import server.logic.ws_protocol.JSON.handlers.channels.Net_GetChannelMessages_Handler;
import server.logic.ws_protocol.JSON.handlers.channels.Net_GetMessageThread_Handler;
import server.logic.ws_protocol.JSON.handlers.channels.Net_GetMessageLikes_Handler;
import server.logic.ws_protocol.JSON.handlers.channels.Net_GetPersonalDiary_Handler;
import server.logic.ws_protocol.JSON.handlers.channels.Net_GetGroupDialog_Handler;
import server.logic.ws_protocol.JSON.handlers.channels.Net_GetChannelsCounters_Handler;
@@ -85,6 +86,7 @@ import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetChannelsC
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetChannelMessages_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetGroupDialog_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetMessageThread_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetMessageLikes_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetPersonalDiary_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_ListGroupChats200_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_ListSubscriptionsFeed_Request;
@@ -210,6 +212,7 @@ public final class JsonHandlerRegistry {
Map.entry("GetChannelMessages", new Net_GetChannelMessages_Handler()),
Map.entry("GetPersonalDiary", new Net_GetPersonalDiary_Handler()),
Map.entry("GetMessageThread", new Net_GetMessageThread_Handler()),
Map.entry("GetMessageLikes", new Net_GetMessageLikes_Handler()),
Map.entry("GetGroupDialog", new Net_GetGroupDialog_Handler()),
Map.entry("ListGroupChats200", new Net_ListGroupChats200_Handler()),
Map.entry("GetChannelsCounters", new Net_GetChannelsCounters_Handler()),
@@ -302,6 +305,7 @@ public final class JsonHandlerRegistry {
Map.entry("GetChannelMessages", Net_GetChannelMessages_Request.class),
Map.entry("GetPersonalDiary", Net_GetPersonalDiary_Request.class),
Map.entry("GetMessageThread", Net_GetMessageThread_Request.class),
Map.entry("GetMessageLikes", Net_GetMessageLikes_Request.class),
Map.entry("GetGroupDialog", Net_GetGroupDialog_Request.class),
Map.entry("ListGroupChats200", Net_ListGroupChats200_Request.class),
Map.entry("GetChannelsCounters", Net_GetChannelsCounters_Request.class),
@@ -0,0 +1,112 @@
package server.logic.ws_protocol.JSON.handlers.channels;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import server.logic.ws_protocol.JSON.ConnectionContext;
import server.logic.ws_protocol.JSON.entyties.Net_Request;
import server.logic.ws_protocol.JSON.entyties.Net_Response;
import server.logic.ws_protocol.JSON.handlers.JsonMessageHandler;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetMessageLikes_Request;
import server.logic.ws_protocol.JSON.handlers.channels.entyties.Net_GetMessageLikes_Response;
import server.logic.ws_protocol.JSON.utils.NetExceptionResponseFactory;
import server.logic.ws_protocol.WireCodes;
import shine.db.DbController;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class Net_GetMessageLikes_Handler implements JsonMessageHandler {
private static final Logger log = LoggerFactory.getLogger(Net_GetMessageLikes_Handler.class);
private static final int HARD_LIMIT = 1000;
@Override
public Net_Response handle(Net_Request baseRequest, ConnectionContext ctx) {
Net_GetMessageLikes_Request req = (Net_GetMessageLikes_Request) baseRequest;
Net_GetMessageLikes_Request.MessageSelector message = req.getMessage();
if (message == null || message.getBlockchainName() == null || message.getBlockchainName().isBlank()
|| message.getBlockNumber() == null || message.getBlockNumber() < 0
|| message.getBlockHash() == null || message.getBlockHash().isBlank()) {
return NetExceptionResponseFactory.error(req, WireCodes.Status.BAD_REQUEST, "bad_fields", "Некорректные поля message");
}
final byte[] blockHash;
try {
blockHash = ChannelsReadSupport.hexToBytes(message.getBlockHash());
} catch (Exception e) {
return NetExceptionResponseFactory.error(req, WireCodes.Status.BAD_REQUEST, "bad_hash", "Некорректный blockHash");
}
if (blockHash == null || blockHash.length == 0) {
return NetExceptionResponseFactory.error(req, WireCodes.Status.BAD_REQUEST, "bad_hash", "Некорректный blockHash");
}
int requested = req.getLimit() == null ? HARD_LIMIT : Math.max(1, Math.min(HARD_LIMIT, req.getLimit()));
try (Connection c = DbController.getInstance().getConnection()) {
String sql = """
SELECT rs.from_login,
COALESCE(ups.first_name, '') AS first_name,
COALESCE(ups.last_name, '') AS last_name,
COALESCE(ups.ava_ar, '') AS avatar_ar,
COALESCE(ups.account_role, 'unknown') AS account_role,
COALESCE(ups.shine_status, 'unknown') AS shine_status
FROM reactions_state rs
LEFT JOIN user_profile_state ups ON LOWER(ups.login) = LOWER(rs.from_login)
WHERE rs.reaction_type = 1
AND rs.last_sub_type = 1
AND rs.to_bch_name = ?
AND rs.to_block_number = ?
AND rs.to_block_hash = ?
ORDER BY LOWER(rs.from_login)
LIMIT ?
""";
List<Net_GetMessageLikes_Response.UserItem> shining = new ArrayList<>();
List<Net_GetMessageLikes_Response.UserItem> official = new ArrayList<>();
List<Net_GetMessageLikes_Response.UserItem> others = new ArrayList<>();
try (PreparedStatement ps = c.prepareStatement(sql)) {
ps.setString(1, message.getBlockchainName().trim());
ps.setInt(2, message.getBlockNumber());
ps.setBytes(3, blockHash);
ps.setInt(4, requested + 1);
try (ResultSet rs = ps.executeQuery()) {
int accepted = 0;
boolean truncated = false;
while (rs.next()) {
if (accepted >= requested) {
truncated = true;
break;
}
accepted++;
Net_GetMessageLikes_Response.UserItem user = new Net_GetMessageLikes_Response.UserItem();
user.setLogin(rs.getString("from_login"));
user.setFirstName(rs.getString("first_name"));
user.setLastName(rs.getString("last_name"));
user.setAvatarAr(rs.getString("avatar_ar"));
boolean isOfficial = "primary".equalsIgnoreCase(rs.getString("account_role"));
boolean isShining = "shining".equalsIgnoreCase(rs.getString("shine_status"));
if (isOfficial && isShining) shining.add(user);
else if (isOfficial) official.add(user);
else others.add(user);
}
Net_GetMessageLikes_Response resp = new Net_GetMessageLikes_Response();
resp.setOp(req.getOp());
resp.setRequestId(req.getRequestId());
resp.setStatus(WireCodes.Status.OK);
resp.setShining(shining);
resp.setOfficial(official);
resp.setOthers(others);
resp.setTotal(shining.size() + official.size() + others.size());
resp.setTruncated(truncated);
return resp;
}
}
} catch (Exception e) {
log.error("GetMessageLikes failed", e);
return NetExceptionResponseFactory.error(req, WireCodes.Status.INTERNAL_ERROR, "internal_error", "Внутренняя ошибка сервера");
}
}
}
@@ -0,0 +1,29 @@
package server.logic.ws_protocol.JSON.handlers.channels.entyties;
import server.logic.ws_protocol.JSON.entyties.Net_Request;
public class Net_GetMessageLikes_Request extends Net_Request {
private MessageSelector message;
private Integer limit;
public MessageSelector getMessage() { return message; }
public void setMessage(MessageSelector message) { this.message = message; }
public Integer getLimit() { return limit; }
public void setLimit(Integer limit) { this.limit = limit; }
public static class MessageSelector {
private String blockchainName;
private Integer blockNumber;
private String blockHash;
public String getBlockchainName() { return blockchainName; }
public void setBlockchainName(String blockchainName) { this.blockchainName = blockchainName; }
public Integer getBlockNumber() { return blockNumber; }
public void setBlockNumber(Integer blockNumber) { this.blockNumber = blockNumber; }
public String getBlockHash() { return blockHash; }
public void setBlockHash(String blockHash) { this.blockHash = blockHash; }
}
}
@@ -0,0 +1,40 @@
package server.logic.ws_protocol.JSON.handlers.channels.entyties;
import server.logic.ws_protocol.JSON.entyties.Net_Response;
import java.util.ArrayList;
import java.util.List;
public class Net_GetMessageLikes_Response extends Net_Response {
private List<UserItem> shining = new ArrayList<>();
private List<UserItem> official = new ArrayList<>();
private List<UserItem> others = new ArrayList<>();
private int total;
private boolean truncated;
public List<UserItem> getShining() { return shining; }
public void setShining(List<UserItem> shining) { this.shining = shining; }
public List<UserItem> getOfficial() { return official; }
public void setOfficial(List<UserItem> official) { this.official = official; }
public List<UserItem> getOthers() { return others; }
public void setOthers(List<UserItem> others) { this.others = others; }
public int getTotal() { return total; }
public void setTotal(int total) { this.total = total; }
public boolean isTruncated() { return truncated; }
public void setTruncated(boolean truncated) { this.truncated = truncated; }
public static class UserItem {
private String login;
private String firstName;
private String lastName;
private String avatarAr;
public String getLogin() { return login; }
public void setLogin(String login) { this.login = login; }
public String getFirstName() { return firstName; }
public void setFirstName(String firstName) { this.firstName = firstName; }
public String getLastName() { return lastName; }
public void setLastName(String lastName) { this.lastName = lastName; }
public String getAvatarAr() { return avatarAr; }
public void setAvatarAr(String avatarAr) { this.avatarAr = avatarAr; }
}
}