云函数搜索数据 - 基于时间和邮件号的检索

exports.main = async (event, context) => {\n const db = cloud.database();\n const yddata = db.collection('yddata');\n const pageSize = 1000; // 定义每页显示的数据数量\n const startIndex = 0; // 定义起始索引值\n let query = yddata.where({});\n\n const startDate1 = event.startDate.split("-");\n const endDate1 = event.endDate.split("-");\n\n const startDate2 = startDate1.join(".");\n const endDate2 = endDate1.join(".");\n\n const startDatestr = startDate2 + " 00:00:00";\n const endDatestr = endDate2 + " 00:00:00";\n \n if (event.mailNumber) {\n query = query.where({ mailNumber: event.mailNumber });\n }\n if(event.startDate && event.endDate) {\n query = query.where({\n date: db.command.gte(startDatestr).and(db.command.lte(endDatestr))\n });\n }\n const searchData = await query.orderBy('date', 'desc').skip(startIndex).limit(pageSize).get().then(res => {\n if (res.data.length > 0) {\n const data = res.data[0];\n return {\n searchData: data\n };\n } else {\n return {\n error: '未找到相关数据'\n };\n }\n }).catch(err => {\n console.error(err);\n return {\n error: err\n };\n });\n return searchData;\n }