reportTransport.js

function readTransport(stmt, cell) {
	makeReport(stmt, {
		sheetName: "Transport",
		query: `
      SELECT
        \`first_name\` AS "First Name",
        \`nickname\` AS "Facebook Name",
        \`transport-need-lift\` AS "Needs Lift",
        \`transport-will-you-give-lift\` AS "Offering Lift",
        \`transport-leaving-location\` AS "Leaving From",
        \`transport-depature-time\` AS "Departure Time",
        pd.order_id AS "Order ID"
      FROM jtl_member_db db
      LEFT JOIN jtl_order_product_customer_lookup pd ON pd.user_id = db.id
      WHERE product_id=${cell} AND status="wc-processing"
      ORDER BY \`transport-need-lift\` ASC
    `,
		formatting: [
			{
				type: "color",
				column: "Needs Lift",
				search: "Yes",
				color: colors.lightRed,
			},
			{
				type: "color",
				column: "Offering Lift",
				search: "Yes",
				color: colors.lightGreen,
			},
			{ type: "text", column: "Needs Lift", search: "No", color: colors.grey },
			{
				type: "text",
				column: "Offering Lift",
				search: "No",
				color: colors.grey,
			},
		],
	});
}