MAINHACK

Viewing / Editing File: list-settlements.php

<?php
/*
 * Using OAuth access token to list settlements of an account.
 */

try {
    /*
     * Initialize the Mollie API library with your OAuth access token.
     */
    require "../initialize_with_oauth.php";

/*
     * Get the all the settlements for this account.
     */
    $settlements = $mollie->settlements->page();
    echo '<ul>';
    foreach ($settlements as $settlement) {
        echo '<li><b>Settlement ' . htmlspecialchars($settlement->reference) . ':</b> (' . htmlspecialchars($settlement->createdAt) . ')';
        echo '<table border="1"><tr><th>Month</th><th>Description</th><th>Count</th><th>Net</th><th>VAT</th><th>Gross</th></tr>';
        // Convert from stdClass to array
        $settlement_periods = json_decode(json_encode($settlement->periods), true);
        foreach ($settlement_periods as $year => $months) {
            foreach ($months as $month => $monthly_settlement) {
                foreach ($monthly_settlement['revenue'] as $revenue) {
                    echo '<tr>';
                    echo '<td>' . htmlspecialchars($year . '-' . $month) . '</td>';
                    echo '<td>' . htmlspecialchars($revenue['description']) . '</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['count']) . ' x</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['amountNet']['value'] ? $revenue['amountNet']['value'] . " " . $revenue['amountNet']['currency'] : '-') . '</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['amountVat']['value'] ? $revenue['amountVat']['value'] . " " . $revenue['amountVat']['currency'] : '-') . '</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['amountGross']['value'] ? $revenue['amountGross']['value'] . " " . $revenue['amountGross']['currency'] : '-') . '</td>';
                    echo '</tr>';
                }
                foreach ($monthly_settlement['costs'] as $revenue) {
                    echo '<tr>';
                    echo '<td>' . htmlspecialchars($year . '-' . $month) . '</td>';
                    echo '<td>' . htmlspecialchars($revenue['description']) . '</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['count']) . ' x</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['amountNet']['value'] ? $revenue['amountNet']['value'] . " " . $revenue['amountNet']['currency'] : '-') . '</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['amountVat']['value'] ? $revenue['amountVat']['value'] . " " . $revenue['amountVat']['currency'] : '-') . '</td>';
                    echo '<td align="right">' . htmlspecialchars($revenue['amountGross']['value'] ? $revenue['amountGross']['value'] . " " . $revenue['amountGross']['currency'] : '-') . '</td>';
                    echo '</tr>';
                }
            }
        }
        echo '<tr><th colspan="5" align="right">TOTAL</th><th align="right">' . htmlspecialchars($settlement->amount->value . " " . $settlement->amount->currency) . '</th></tr>';
        echo '</table>';
        echo '</li>';
    }
    echo '</ul>';
} catch (\Mollie\Api\Exceptions\ApiException $e) {
    echo "API call failed: " . htmlspecialchars($e->getMessage());
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: list-settlements.php

Server Info

System Features

User Info