Breaking News: Grepper is joining You.com. Read the official announcement!

creaete controller to get users who have sent a user messages

Smiling Skunk answered on June 26, 2023 Popularity 1/10 Helpfulness 1/10

answer creaete controller to get users who have sent a user messages

creaete controller to get users who have sent a user messages

Comment

import mssql from "mssql";
import { sqlConfig } from "../../db/config.js";
import api from "../../utilities/api.js";

// Get users who have sent messages to a user
export const getUsersWhoSentMessagesToUser = async (req, res) => {
  try {
    const { userID } = req.params;
    const pool = await mssql.connect(sqlConfig);
    const request = pool.request();
    const query = `SELECT DISTINCT SenderID FROM UsereActivity.Messages WHERE ReceiverID = @userID`;
    request.input("userID", mssql.UniqueIdentifier, userID);
    const result = await request.query(query);

    const senderIDs = result.recordset.map((record) => record.SenderID);

    if (senderIDs.length === 0) {
      res.send(api(null, "No users found", true));
    } else {
      const getUsersQuery = `SELECT * FROM UsereActivity.Users WHERE UserID IN (${senderIDs.map(
        (id, index) => `@id${index}`
      )})`;

      const getUsersRequest = pool.request();
      senderIDs.forEach((id, index) => {
        getUsersRequest.input(`id${index}`, mssql.UniqueIdentifier, id);
      });

      const getUsersResult = await getUsersRequest.query(getUsersQuery);

      res.send(api(getUsersResult.recordset, "Users who sent messages retrieved successfully", true));
    }
  } catch (err) {
    res.send(api(err, "Error retrieving users who sent messages", false));
  } finally {
    mssql.close();
  }
};

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: controller get javascript messages

Link to this answer
Share Copy Link

Contributed on Jun 26 2023

Smiling Skunk

0 Answers Avg Quality 2/10

creaete controller to get users who have sent a user messages

Contents

More Related Answers

creaete controller to get users who have sent a user messages

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.