/**
 * 获取机构信息API - 完全基于官方文档语法
 * 严格按照微搭官方文档的语法编写
 * 参考：https://docs.cloudbase.net/lowcode/api/model_crud
 */

module.exports = async function (params, context) {
  try {
    // 第一步：获取机构表的数据 - 使用官方确认的语法
    const institutionResult = await context.callModel({
      dataSourceName: 'institutions',
      methodName: 'wedaGetRecordsV2',
      params: {
        select: { $master: true }
      }
    });

    // 检查查询结果
    if (!institutionResult.records || institutionResult.records.length === 0) {
      return {
        code: 404,
        message: '未找到机构信息',
        data: null,
        timestamp: Date.now()
      };
    }

    // 取第一条记录
    const institution = institutionResult.records[0];
    const institutionId = institution._id;

    // 第二步：根据机构ID获取机构优势信息
    const advantagesResult = await context.callModel({
      dataSourceName: 'dance_advantages',
      methodName: 'wedaGetRecordsV2',
      params: {
        filter: {
          where: {
            institution_id: { $eq: institutionId }
          }
        },
        select: { $master: true }
      }
    });

    const campuses = await context.callModel({
      dataSourceName: 'dance_campuses',
      methodName: 'wedaGetRecordsV2',
      params: {
        filter: {
          where: {
            institution_id: { $eq: institutionId }
          }
        },
        select: { $master: true }
      }
    })

    // 对优势信息进行排序（在代码中处理，避免使用不确定的orderBy语法）
    const sortedAdvantages = advantagesResult.records.sort((a, b) => {
      return (a.sort_order || 0) - (b.sort_order || 0);
    });

    // 构建返回的数据结构
    const responseData = {
      institution: {
        id: institution._id,
        name: institution.name,
        logo: institution.logo,
        description: institution.description,
        contactPhone: institution.contact_phone,
        email:institution.email,
        businessHours: institution.business_hours,
        status: institution.status,
        createdTime: institution.created_time,
        updatedTime: institution.updated_time
      },
      advantages: sortedAdvantages.map(advantage => ({
        id: advantage._id,
        title: advantage.title,
        description: advantage.description,
        sortOrder: advantage.sort_order,
        createdTime: advantage.created_time,
        updatedTime: advantage.updated_time
      })),
      campuses:campuses.records
    };

    return {
      code: 200,
      message: '获取机构信息成功',
      data: responseData,
      timestamp: Date.now()
    };

  } catch (error) {
    console.error('获取机构信息错误:', error);
    return {
      code: 500,
      message: '服务器内部错误',
      data: null,
      timestamp: Date.now()
    };
  }
};