export async function getMoneyData(networkId) {
    const purchases = await context.sql`
        SELECT * FROM purchases
        WHERE network_id = ${networkId}
        ORDER BY created DESC
    `;

    const subscriptions = await context.sql`
        SELECT mn.id, mn.created, mn.active, mn.network_plan_id,
                np.name AS plan_name, np.price AS plan_price,
                m.first_name, m.last_name, m.email
        FROM member_networks mn
        JOIN network_plans np ON mn.network_plan_id = np.id
        LEFT JOIN members m ON mn.member_id = m.id
        WHERE mn.network_id = ${networkId}
            AND mn.network_plan_id IS NOT NULL
        ORDER BY mn.created DESC
    `;

    return { purchases, subscriptions }
}