[web] [fix] fix unread last message timestamp
ClosedPublic
Actions

Show First 20 Lines • Show All 226 Lines • ▼ Show 20 Lines	const row = [
description,		description,
viewer.userID,		viewer.userID,
time,		time,
color,		color,
parentThreadID,		parentThreadID,
threadAncestry.containingThreadID,		threadAncestry.containingThreadID,
threadAncestry.community,		threadAncestry.community,
threadAncestry.depth,		threadAncestry.depth,
newRoles.default.id,
sourceMessageID,		sourceMessageID,
];		];

let existingThreadQuery = null;		let existingThreadQuery = null;
if (threadType === threadTypes.PERSONAL) {		if (threadType === threadTypes.PERSONAL) {
const otherMemberID = initialMemberIDs?.[0];		const otherMemberID = initialMemberIDs?.[0];
invariant(		invariant(
otherMemberID,		otherMemberID,
'Other member id should be set for a PERSONAL thread',		'Other member id should be set for a PERSONAL thread',
);		);
existingThreadQuery = personalThreadQuery(viewer.userID, otherMemberID);		existingThreadQuery = personalThreadQuery(viewer.userID, otherMemberID);
} else if (sourceMessageID) {		} else if (sourceMessageID) {
existingThreadQuery = SQL`		existingThreadQuery = SQL`
SELECT t.id		SELECT t.id
FROM threads t		FROM threads t
WHERE t.source_message = ${sourceMessageID}		WHERE t.source_message = ${sourceMessageID}
`;		`;
}		}

if (existingThreadQuery) {		if (existingThreadQuery) {
const query = SQL`		const query = SQL`
INSERT INTO threads(id, type, name, description, creator, creation_time,		INSERT INTO threads(id, type, name, description, creator, creation_time,
color, parent_thread_id, containing_thread_id, community, depth,		color, parent_thread_id, containing_thread_id, community, depth,
default_role, source_message)		source_message)
SELECT ${row}		SELECT ${row}
WHERE NOT EXISTS (`;		WHERE NOT EXISTS (`;
query.append(existingThreadQuery).append(SQL`)`);		query.append(existingThreadQuery).append(SQL`)`);
const [result] = await dbQuery(query);		const [result] = await dbQuery(query);

if (result.affectedRows === 0) {		if (result.affectedRows === 0) {
const deleteRoles = SQL`		const deleteRoles = SQL`
DELETE FROM roles		DELETE FROM roles
▲ Show 20 Lines • Show All 50 Lines • ▼ Show 20 Lines	if (result.affectedRows === 0) {
userInfos,		userInfos,
newMessageInfos,		newMessageInfos,
};		};
}		}
} else {		} else {
const query = SQL`		const query = SQL`
INSERT INTO threads(id, type, name, description, creator, creation_time,		INSERT INTO threads(id, type, name, description, creator, creation_time,
color, parent_thread_id, containing_thread_id, community, depth,		color, parent_thread_id, containing_thread_id, community, depth,
default_role, source_message)		source_message)
VALUES ${[row]}		VALUES ${[row]}
`;		`;
await dbQuery(query);		await dbQuery(query);
}		}

let initialMemberPromise;		let initialMemberPromise;
if (initialMemberIDs) {		if (initialMemberIDs) {
initialMemberPromise = changeRole(id, initialMemberIDs, null, {		initialMemberPromise = changeRole(id, initialMemberIDs, null, {
▲ Show 20 Lines • Show All 178 Lines • Show Last 20 Lines

[web] [fix] fix unread last message timestampClosedPublicActions

Details

Diff Detail

Event Timeline

Revision ContentsChangeset List

Diff 11438

web/chat/chat-thread-list.css

[web] [fix] fix unread last message timestamp
ClosedPublic
Actions

Revision Contents
Changeset List