{% extends 'super_admin_templates/base.html' %}
{% block content %}

<style type="text/css">
    .centered {
        text-align: center;
    }
</style>

<!-- Start::app-content -->
<div class="main-content app-content">
    <div class="container-fluid">

        <!-- Page Header -->
        <div class="d-md-flex d-block align-items-center justify-content-between my-4 page-header-breadcrumb">
            <h1 class="page-title fw-semibold fs-18 mb-0">Ledger</h1>
            <div class="ms-md-1 ms-0">
                <nav>
                    <ol class="breadcrumb mb-0">
                        <li class="breadcrumb-item"><a href="{{ url_for('admin.dashboard') }}">Home</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Payout Ledger Reports</li>
                    </ol>
                </nav>
            </div>
        </div>
        <!-- Page Header Close -->

        <!-- Start::row-1 -->
        <div class="row">
            <div class="col-xl-12">
                <div class="card custom-card">
                    <div class="card-header">
                        <div class="card-title">
                            Payout Ledger Reports List
                        </div>
                    </div>
                    <div class="card-body">
                        <center>
                            {% if error %}
                            <h2><b><center style="color:RED">{{ error }}</center></b></h2>
                            {% endif %}
                        </center>

                            <div class="row">
                                <div class="col-xl-12">
                                    <form method="GET" action="{{ url_for('admin_reports.payout_ledger_reports') }}" class="row gy-2 gx-3 align-items-center mb-4">
                                        
                                        <div class="col-auto">
                                            <input type="text" class="form-control flatpickrdate" value="{{startDate}}" name="startDate" id="startDate" placeholder="Select start date">
                                        </div>

                                        <div class="col-auto">
                                            <input type="text" class="form-control flatpickrdate" value="{{endDate}}" name="endDate" id="endDate" placeholder="Select end date">
                                        </div>

                                        

                                        <div class="col-auto">
                                            <input type="text" class="form-control" value="{{searchId}}" name="searchId" id="searchId" minlength="4" maxlength="32"  pattern="^[a-zA-Z0-9]+$" title="Accepts only alphanumeric characters (a-z, A-Z, 0-9)"
                                                placeholder="Orderid or txn id">
                                        </div>

                                        <div class="col-auto">
                                            <select class="form-control chosen-select" name="pgId" id="choices-single-default">
                                                <option value="">Select pg</option>
                                                {% for each_pg in pgList %}
                                                    <option value="{{each_pg.id}}" {% if each_pg.id|string == pgId|string %}selected{% endif %}>{{each_pg.apiName}}</option>
                                                {% endfor %}
                                            </select>
                                        </div>

                                        <div class="col-auto">
                                            <select class="form-select" id="transactionType" name="transactionType">
                                                <option value="All" {% if transactionType == "All" %} selected {% endif %}>Transaction type</option>
                                                <option value="Credit" {% if transactionType == "Credit" %} selected {% endif %}>Credit</option>
                                                <option value="Debit" {% if transactionType == "Debit" %} selected {% endif %}>Debit</option>
                                            </select>
                                        </div>

                                        <div class="col-auto">
                                            <select class="form-control chosen-select" name="merchantId" id="choices-single-default">
                                                <option value="">Select merchant</option>
                                                {% for each_merchant in merchantsList %}
                                                    <option value="{{each_merchant.id}}" {% if each_merchant.id|string == merchantId|string %}selected{% endif %}>{{each_merchant.fullName}} - {{each_merchant.phoneNumber}}</option>
                                                {% endfor %}
                                            </select>
                                        </div>
                                        <div class="col-auto">
                                            <select class="form-control chosen-select" name="siteTitle" id="choices-single-default">
                                              <option value="">Select site title</option>
                                                  {% for each_site in siteTitleList %}
                                                    <option value="{{each_site.siteCode}}" {% if each_site.siteCode == siteTitle %}selected{% endif %}>{{ each_site.siteCode }} </option>
                                                  {% endfor %}
                                            </select>                                        
                                          </div>
                                        
                                        <div class="col-auto">
                                            <button type="submit" class="btn btn-primary">Search</button>
                                        </div>

                                        <div class="col-auto">
                                            <a href="{{url_for('admin_reports.admin_download_payout_ledger_xlsx_reports',selectStatus=selectStatus,startDate=startDate,endDate=endDate,searchId=searchId,merchantId=merchantId,pgId=pgId,transactionType=transactionType,siteTitle=siteTitle)}}"><button type="button" title="Click to download" class="btn btn-secondary"><i class="ri-file-excel-line"></i></button></a>
                                        </div>
                                        <div class="col-auto">
                                            <a href="{{url_for('admin_reports.payout_ledger_reports')}}"><button type="button" class="btn btn-warning">Reset</button></a>
                                        </div>

                                        {% for error in form.startDate.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span><br>
                                    {% endfor %}

                                    {% for error in form.endDate.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span><br>
                                    {% endfor %}
                                    {% for error in form.transactionType.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span><br>
                                    {% endfor %}

                                    {% for error in form.searchId.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span><br>
                                    {% endfor %}

                                    {% for error in form.pgId.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span><br>
                                    {% endfor %}

                                    {% for error in form.merchantId.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span><br>
                                    {% endfor %}

                                    {% for error in form.siteTitle.errors %}
                                    <span class="text-danger" class="error">{{ error }}</span>
                                    {% endfor %}
                                    </form>
                                </div>
                            </div>

                            <!-- Add some space -->
                            <div class="mt-3"></div>
                            <!-- End space -->
                            <div class="table-responsive">
                                <table id="datatable-basic" class="table text-nowrap">
                                <thead class="table-primary">
                                    <tr>
                                        <th scope="col">S.No</th>
                                        <th scope="col">Site Title</th>
                                        <th scope="col">Order ID</th>
                                        <th scope="col">Txn ID</th>
                                        <th scope="col">PG OrderId</th>
                                        <th scope="col">Merchant Name</th>
                                        <th scope="col">UTR</th>
                                        <th scope="col">Opening Balance(₹)</th>
                                        <th scope="col">CrDrType</th>
                                        <th scope="col">Credit Amount(₹)</th>
                                        <th scope="col">Debit Amount(₹)</th>
                                        <th scope="col">Closing Balance(₹)</th>
                                        <th scope="col">Date</th>
                                        <th scope="col">Status</th>
                                        
                                    </tr>
                                </thead>
                                <tbody>
                                        {% if payoutsList %}
                                    {% for each_payout in payoutsList %}
                                    <tr>
                                        <td>{{snoCount + loop.index}}</td>

                                        {% if each_payout.siteTitle %}
                                        <td>{{each_payout.siteTitle}}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        
                                        {% if each_payout.merchantReferenceNumber %}
                                        <td>{{each_payout.merchantReferenceNumber }}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.transactionUniqueId %}
                                        <td>{{each_payout.transactionUniqueId }}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.pgOrderId %}
                                        <td>{{ each_payout.pgOrderId }}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.userName %}
                                        <td>{{each_payout.userName}}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.bankReferenceNumber %}
                                        <td>{{ each_payout.bankReferenceNumber }}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        <td style="text-align: left;">{{each_payout.previousBalance}}</td>

                                        {% if each_payout.transferType %}
                                        <td>{{each_payout.transferType}}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.creditAmount %}
                                        <td style="text-align: left;">{{each_payout.creditAmount}}</td>
                                        {% else %}
                                        <td>-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.debitAmount %}
                                        <td style="text-align: left;">{{each_payout.debitAmount}}</td>
                                        {% else %}
                                        <td>-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.currentBalance %}
                                        <td style="text-align: left;">{{each_payout.currentBalance}}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        

                                        {% if each_payout.createdOn %}
                                        <td class="extended">{{each_payout.createdOn}}</td>
                                        {% else %}
                                        <td class="centered">-</td>
                                        {% endif %}
                                        
                                        {% if each_payout.transactionStatus == "Success" %}
                                            <td><button class="btn btn-sm btn-success" type="button">{{ each_payout.transactionStatus }}</button></td>
                                        {% else %}
                                            <td><button class="btn btn-sm btn-warning" type="button">{{ each_payout.transactionStatus }}</button></td>
                                        {% endif %}
                                        <!-- <td>{{each_payout.transferType}}</td> -->
                                    </tr>
                                    {% endfor %}
                                     {% else %}
                                    <tr ><td colspan="16" style="text-align: center;">No Data Found</td> </tr>
                                    {% endif %}
                                </tbody>
                                {% with messages = get_flashed_messages() %}
                                {% if messages %}
                                <ul class="flashes">
                                    {% for message in messages %}
                                    <h2>
                                        <b>
                                            <center style="color:green">{{ message }}</center>
                                        </b>
                                    </h2>
                                    {% endfor %}
                                </ul>
                                {% endif %}
                                {% endwith %}
                                </table>
                               
                            </div>

                            <!-- Add some space -->
                            <div class="col-sm-12 col-md-12 mt-3">
                                <nav aria-label="Page navigation" class="pagination-style-1">
                                  <ul class="pagination mb-0">
                                      {% if pagination %}
                                            <div class="pagination">
                                                {{ pagination.links }}
                                            </div>
                                        {% endif %}
                                  </ul>
                              </nav>
                            </div>
                            <!-- End space -->
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--End::row-1 -->

    </div>
</div>
<!-- End::app-content -->


{% endblock %}