exportsmain = async event context = const db = clouddatabase; const yddata = dbcollectionyddata; const pageSize = 1000; 定义每页显示的数据数量 const startIndex = 0; 定义起始索引值 let query = yddatawh

exports.main = async (event, context) => { const db = cloud.database(); const yddata = db.collection('yddata'); const pageSize = 1000; // 定义每页显示的数据数量 const startIndex = 0; // 定义起始索引值 let query = yddata.where({});

const startDate = event.startDate.split('-').join('.') + ' 0:0:0';
const endDate = event.startDate.split('-').join('.') + ' 0:0:0';

if (event.mailNumber) {
    query = query.where({ mailNumber: event.mailNumber });
    const searchData = await query.orderBy('date', 'desc').skip(startIndex).limit(pageSize).get().then(res => {
    if (res.data.length > 0) {
        const data = res.data[0];
        return {
        searchData: data
        // mailNumber:data.mailNumber,
        // images: data.images,
        // describe: data.describe,
        // date: data.date
        };
    } else {
        return {
        error: '未找到相关数据'
        };
    }
    }).catch(err => {
    console.error(err);
    return {
        error: err
    };
    });
    return searchData;
}else {
  query = query.where({
    date: db.command.gte(startDate).and(db.command.lte(endDate))
  });
  const searchData = await query.orderBy('date', 'desc').skip(startIndex).limit(pageSize).get().then(res => {
    if (res.data.length > 0) {
      const data = res.data;
      return {
        searchData: data
        // mailNumber:data.mailNumber,
        // images: data.images,
        // describe: data.describe,
        // date: data.date
      };
    } else {
      return {
        error: '未找到相关数据'
      };
    }
  }).catch(err => {
    console.error(err);
    return {
      error: err
    };
  });
  return searchData;
}