{% if order.payments is not empty %}
    {% set payment = order.payments|first %}
    {% set Paymentamount = payment.paymentamount %}

    {# Check if the payment has subscriptions #}
    {% if payment.subscriptions is not empty %}
        {% set subscription = payment.subscriptions|first %}
        {% set subscriptionduration = subscription.duration ~ ' ' ~ (subscription.duration == 1 ? 'Month' : 'Months') %}

        {# Check if subscription has auto-renewal enabled #}
        {% if subscription.autorenewal == 1 %}
            {# Calculate next payment date if auto-renewal is enabled #}
            {% set nextpayment = subscription.enddate|date('Y-m-d') %}
        {% else %}
            {% set nextpayment = 'No next payment' %}
        {% endif %}
    {% else %}
        {% set subscriptionduration = 'No subscription found' %}
        {% set nextpayment = 'N/A' %}
    {% endif %}
{% else %}
    {% set Paymentamount = 'No payment found' %}
    {% set subscriptionduration = 'N/A' %}
    {% set nextpayment = 'N/A' %}
{% endif %}
<tr>
    <td class="sticky-col-1">{{ order.id }}</td>
        <td class="sticky-col-2">
            {% if order.userid is null %}
                N/A
            {% else %}
                {{ order.userid.firstname }} {{ order.userid.lastname }}
            {% endif %}
        </td>
        <td>
            {% if order.productid is empty %}
                N/A
            {% else %}
                {{ order.productid.name }}
            {% endif %}
        </td>
         <td>
            {% if order.customeremailid is null %}
                N/A
            {% else %}
                {{ order.customeremailid }}
            {% endif %}
        </td>
        <td>
            {% set badgeClass = '' %}
            {% set statusText = order.status is not null ? order.status : 'N/A' %}

            {% if order.status is null %}
                N/A
            {% elseif order.createdby is not null and 'ROLE_ADMINISTRATOR' in order.createdby.getRoles and statusText != 'completed' %}
                <select class="form-select status-select" data-order-id="{{ order.id }}">
                    <option value="completed" {% if statusText == 'completed' %}selected{% endif %}>Completed</option>
                    <option value="pending" {% if statusText == 'pending' %}selected{% endif %}>Pending</option>
                    <option value="hold" {% if statusText == 'hold' %}selected{% endif %}>On Hold</option>
                    <option value="canceled" {% if statusText == 'canceled' %}selected{% endif %}>Canceled</option>
                </select>
            {% else %}
                {% if statusText == 'completed' %}
                    {% set badgeClass = 'badge bg-success' %}
                {% elseif statusText in ['refunded', 'cancelled', 'expired','failed'] %}
                    {% set badgeClass = 'badge bg-danger' %}
                {% elseif statusText in ['processing', 'pending'] %}
                    {% set badgeClass = 'badge bg-warning' %}
                {% elseif statusText in ['on hold', 'on-hold'] %}
                    {% set badgeClass = 'badge bg-info' %}
                {% else %}
                    {% set badgeClass = 'badge bg-secondary' %}
                {% endif %}
                <span class="badge {{ badgeClass }}">{{ statusText|upper }}</span>
            {% endif %}
        </td>
        <td>
            {% if order.getCreatedAt is null %}
                N/A
            {% else %}
                {{ order.getCreatedAt|date('Y-m-d H:i:s') }}
            {% endif %}
        </td>
        <td>{{ subscriptionduration }}</td>
        <td>{{ Paymentamount|number_format(2,',','.') }} €</td>
        <td>{{ nextpayment }}</td>
        {#<td>
            {% if order.wordpressorderId is empty %}
                No
            {% else %}
                Yes
            {% endif %}
        </td>#}
        <td>
            <div class="row d-flex justify-content-center">
                <div class="col-md-4 d-flex justify-content-center">
                    <a href="{{ path('app_admin_order_view', {'id': order.id}) }}" class="list-icons-item" data-bs-popup="tooltip" data-bs-original-title="View">
                        <i class="ph-eye text-info"></i>
                    </a>
                </div>
            </div>
        </td>
</tr>