{{ drupal_block('edgeworth_payment_report_search_block') }}

<button id="downloadCsv">Download CSV</button>

<div class="edgeworth-stats-box">
    <div class="edgeworth-stats-total"><strong>Total Units: </strong>{{ total_results }}</div>
</div>

<table id="errorLogs">
    <thead>
    <tr>
        <th>{{ "CpmpanyID" | t }}</th>
        <th>{{ "Company Name" | t }}</th>
        <th>{{ "LocationID" | t }}</th>
        <th>{{ "Location Name" | t }}</th>
        <th>{{ "PlaylistID" | t }}</th>
        <th>{{ "Playlist Name" | t }}</th>
        <th>{{ "# of Boards" | t }}</th>
        <th>{{ "Status" | t }}</th>
        <th>{{ "Playlist Status" | t }}</th>
        <th>{{ "Allow Non-Cannabis Ads" | t }}</th>
        <th>{{ "Go Live Date" | t }}</th>
        <th>{{ "Data Agmt" | t }}</th>
        <th>{{ "ETF Agmt" | t }}</th>
        {# <th>{{ "Cancellation Date" | t }}</th> #}
        <th>{{ "Ad Plays" | t }}</th>
        <th>{{ "Days Played" | t }}</th>
        <th>{{ "Payment" | t }}</th>
    {#  <th>{{ "Last Seen Online" | t }}</th>
        <th>{{ "Date" | t }}</th>
        <th>{{ "Time" | t }}</th>
        <th>{{ "Smart Ads Status" | t }}</th>
        <th>{{ "Cancellation Date" | t }}</th>
        <th>{{ "Email Location" | t }}</th>
        <th>{{ "Last Offline Email Notification" | t }}</th> #}
    </tr>
    </thead>
    <tbody>
    {% for log in logs %}
        <tr>
        <td>{% if log.referenced_company_nid is not empty %}<a href="/node/{{ log.referenced_company_nid }}" target="_Blank">{{ log.referenced_company_nid }}</a>{% endif %}</td>
        <td>{% if log.referenced_company_title is not empty %}{{ log.referenced_company_title }}{% endif %}</td>
        <td><a href="/node/{{ log.referenced_node_nid }}" target="_Blank">{{ log.referenced_node_nid }}</a></td>
        <td>{{ log.referenced_node_title }}</td>
        <td><a href="/node/{{ log.playlist_id }}" target="_Blank">{{ log.playlist_id }}</a></td>
        <td>{{ log.name }}</td>
        <td>{{ log.num_of_smart_ad_tvs }}</td>
        <td>{{ log.status }}</td>
        <td>{{ log.playlist_status }}</td>
        <td>{{ log.allow_non_cannabis_ads }}</td>
        <td>{{ log.playlist_go_live_date }}</td>
        <td>{{ log.data_agreement }}</td>
        <td>{{ log.eft_agreement }}</td>
        <td>{{ log.total_ad_plays }}</td>
        <td>{{ log.total_unique_days }}</td>
        {# <td>{{ log.date }}</td>
        <td>{{ log.time }}</td>
        <td>{{ log.smart_ads_status }}</td>
        <td>{{ log.smart_cancellation_date }}</td>
        <td>
        {% if log.store_email is not empty %}
            <a href="mailto:{{ log.store_email }}" class="send-reminder" data-node-id="{{ log.referenced_node_nid }}">{{ 'Send Reminder' }}</a>
        {% endif %}
        </td>
        <td class="email-notification">{{ log.last_offline_email_notification }}</td> #}
        </tr>
    {% endfor %}
    </tbody>
</table>


<script>
    document.getElementById('downloadCsv').addEventListener('click', function() {
        const table = document.getElementById('errorLogs');
        const rows = Array.from(table.querySelectorAll('tr'));
        
        const csvContent = rows.map(row => {
            const cols = Array.from(row.querySelectorAll('td, th')).map(col => {
                let text = col.innerText;
                text = text.replace(/(\r\n|\n|\r)/gm, "").replace(/(\s\s+)/gm, " ").trim();
                if (col.querySelector('a')) {
                    text = col.querySelector('a').innerText;
                }
                return `"${text}"`;
            }).join(',');
            return cols;
        }).join('\n');
        
        const blob = new Blob([csvContent], { type: 'text/csv;charset=utf-8;' });
        const link = document.createElement('a');
        const url = URL.createObjectURL(blob);
        link.setAttribute('href', url);
        link.setAttribute('download', 'EdgeworthPaymentReport.csv');
        link.style.visibility = 'hidden';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    });
</script>