Thank you Serge Middendorf . I want to access the 'records' collection and display the fields inside that collection to the pdf file.

I tried to create a function as below but its not deploying at all...

const functions = require('firebase-functions');

const admin = require('firebase-admin');

const PDFDocument = require('pdfkit');

const nodemailer = require('nodemailer');

const cors = require('cors')({ origin: true });

admin.initializeApp();

exports.generatePDF = functions.https.onRequest(async (request, response) => {

cors(request, response, async () => {

// Set CORS headers to allow all origins during development

response.setHeader('Access-Control-Allow-Origin', '*');

response.setHeader('Access-Control-Allow-Methods', 'GET, POST, OPTIONS');

response.setHeader('Access-Control-Allow-Headers', 'Origin, X-Requested-With, Content-Type, Accept');

try {

const { userId, selectedNickname, email } = request.query;

// Validate and handle dynamically passed parameters

if (!userId || !selectedNickname || !email) {

throw new Error('Missing required parameters');

}

// Access Firestore to get user data

const userDoc = await admin.firestore().collection('users').doc(userId).get();

const displayName = userDoc.get('display_name');

const displayLocation = userDoc.get('location');

// Access Firestore to get records

const fromDate = new Date();

const toDate = new Date();

const querySnapshot = await admin.firestore()

.collection('records')

.where('created_at', '>=', fromDate)

.where('created_at', '<=', toDate)

.where('userRef', '==', admin.firestore().collection('users').doc(userId))

.orderBy('created_at', 'desc')

.get();

let documents = querySnapshot.docs.map(doc => doc.data());

// Apply nickname condition

documents = documents.filter(doc => doc['nickname'] === selectedNickname);

const pdfBuffer = await generatePDF({

displayName,

displayLocation,

selectedNickname,

fromDate,

toDate,

documents

});

// Send email with PDF attachment using SMTP

await sendEmailSMTP(email, pdfBuffer);

console.log('PDF generated and email sent successfully');

response.status(200).json({ success: true });

} catch (error) {

console.error('Error:', error);

response.status(500).json({ success: false, error: error.message });

}

});

async function generatePDF({ displayName, displayLocation, selectedNickname, fromDate, toDate, documents }) {

return new Promise((resolve, reject) => {

const pdfDoc = new PDFDocument();

// Add content to the PDF

pdfDoc.text(`Account Statement for ${selectedNickname}`, { fontSize: 18, margin: 20 });

// Add headers for the table

const tableHeaders = ['Date', 'Pay Mode', 'Amount', 'Transaction No', 'Mobile No', 'Remarks'];

const headerHeight = 15;

const cellMargin = 10;

const startY = pdfDoc.y + 15;

// Draw headers

tableHeaders.forEach((header, index) => {

pdfDoc.text(header, cellMargin + index * 120, startY, { bold: true });

});

// Add table rows to the PDF

documents.forEach((doc, rowIndex) => {

const rowHeight = 15;

const startY = pdfDoc.y + (rowIndex + 1) * rowHeight + 15;

pdfDoc.text(DateFormat('dd/MM/yy').format(doc['created_at'].toDate()), cellMargin + 0 * 120, startY);

pdfDoc.text(`${doc['payMode']}`, cellMargin + 1 * 120, startY);

pdfDoc.text(`${doc['amount']}`, cellMargin + 2 * 120, startY);

pdfDoc.text(`${doc['rr_no']}`, cellMargin + 3 * 120, startY);

pdfDoc.text(`${doc['mobile_no'] || ''}`, cellMargin + 4 * 120, startY);

pdfDoc.text(`${doc['remarks']}`, cellMargin + 5 * 120, startY);

});

// Add Online and Cash counts and amounts to the PDF

const onlineCount = documents.filter(doc => doc['payMode'] === 'Online').length;

const cashCount = documents.filter(doc => doc['payMode'] === 'Cash').length;

const totalCount = onlineCount + cashCount;

const onlineAmount = documents.filter(doc => doc['payMode'] === 'Online')

.map(doc => doc['amount'])

.reduce((a, b) => a + b, 0);

const cashAmount = documents.filter(doc => doc['payMode'] === 'Cash')

.map(doc => doc['amount'])

.reduce((a, b) => a + b, 0);

const totalAmount = onlineAmount + cashAmount;

pdfDoc.text(`Online Count: ${onlineCount} | Cash Count: ${cashCount} | Total Count: ${totalCount}`, { fontSize: 12, margin: 10 });

pdfDoc.text(`Online Amount: ${onlineAmount} | Cash Amount: ${cashAmount} | Total Amount: ${totalAmount}`, { fontSize: 12, margin: 10 });

const buffers = [];

pdfDoc.on('data', buffers.push.bind(buffers));

pdfDoc.on('end', () => {

const pdfBuffer = Buffer.concat(buffers);

resolve(pdfBuffer);

});

pdfDoc.end();

});

}

async function sendEmailSMTP(toEmail, pdfBuffer) {

// Configure nodemailer with your SMTP server

const transporter = nodemailer.createTransport({

host: 'hostname', // Replace with your SMTP server host

port: 465, // Replace with your SMTP server port

auth: {

user: '',

pass: '',

});

// Email options

const mailOptions = {

from: 'test@mail.com',

to: toEmail,

subject: 'Your PDF Statement',

text: 'Attached is your PDF statement.',

attachments: [

{

filename: 'statement.pdf',

content: pdfBuffer,

encoding: 'base64',

};

// Send the email

await transporter.sendMail(mailOptions);

}

How can I access Firestore Database via FF cloud function?