import { ResultSetHeader, RowDataPacket } from "mysql2";
import DB from "../config/database/db";
import CONSTANTS from "../config/constants";
import serviceProviderTypes from "../schemas/serviceProvider.schema";

const serviceProviderDB: any = {};

serviceProviderDB.getActiveByType = async ({ type }: serviceProviderTypes) => {
  const query =
    "Select * from ServiceProviders where type = ? and status = ? order by id desc limit 1";
  const data = [type, CONSTANTS.SERVICE_PROVIDERS_STATUS.ACTIVE];
  const [rows] = await DB.execute<RowDataPacket[]>(query, data);
  if (rows?.length > 0) return rows[0];
  else return false;
};

export default serviceProviderDB;