@extends('layouts.app')
@section('content')

@php
$table = "yes";
@endphp
<style type="text/css">
.dropdown-menu .show{
    inset:none !important;
}
</style>
<div class="container-fluid">
    <!-- Page Header -->
    <div class="d-md-flex d-block align-items-center justify-content-between my-4 page-header-breadcrumb">
        <div class="p-2 main-dashboard-header-left mt-2">
            
        </div>
    </div>
    <!-- End Page Header -->

    <div class="row">
        <div class="col-xl-12">
            <div class="card custom-card">
                <div class="card-body">
                    <form id="searchForm">
                        <div class="row">
                            <div class="col-xl-9">
                                <div class="row">
                                    <div class="col-xl-2">
                                        <p class="text-muted">From Date:</p>
                                        <input type="date" name="from_date" class="form-control" id="input">  
                                    </div>

                                    <div class="col-xl-2">
                                        <p class="text-muted">To Date:</p>
                                        <input type="date" name="to_date" class="form-control" id="">  
                                    </div>

                                    <div class="col-xl-2">
                                        <p class="text-muted">Category:</p>
                                        <select name="bill_category" class="form-control">
                                            <option value="">--Selecy --</option>
                                            <option value="Electricity">Electricity</option>
                                            <option value="Water">Water</option>
                                            <option value="Gas">Gas</option>
                                            <option value="Mobile Postpaid">Mobile Postpaid</option>
                                            <option value="DTH">DTH</option>
                                            <option value="Broadband">Broadband</option>
                                            <option value="Landline">Landline</option>
                                            <option value="Fastag Recharge">Fastag Recharge</option>
                                            <option value="Insurance Premium">Insurance Premium</option>
                                            <option value="Loan Repayment">Loan Repayment</option>
                                            <option value="Municipal Tax">Municipal Tax</option>
                                            <option value="Subscription">Subscription (OTT, Apps)</option>
                                        </select>

                                    </div>

                                    <div class="col-xl-2">
                                        <p class="text-muted">Status:</p>
                                        <select name="status" class="form-control">
                                            <option value="">-- Select Status --</option>
                                            <option value="Success">Success</option>
                                            <option value="Pending">Pending</option>
                                            <option value="Failed">Failed</option>
                                            <option value="Refunded">Refunded</option>
                                        </select>

                                    </div>

                                    <div class="col-xl-2">
                                        <p class="text-muted">User ID:</p>
                                         <input type="text" name="to_date" placeholder="Searchab..." class="form-control" id="">
                                    </div>

                                    <div class="col-xl-2 mt-3"><br>
                                        <button type="submit" class="btn btn-sm btn-primary-gradient waves-light">Search</button>
                                    </div>
                                </div>
                            </div>
                            <div class="col-xl-3">
                                <div class="btn-list text-end" style="margin-top: 36px;">
                                   
                                    <button class="btn btn-sm btn-orange-gradient waves-light">Export Excel</button>
                                    <button class="btn btn-sm btn-purple-gradient waves-light">Export PDF</button> 
                                </div>

                            </div>
                        </div>
                    </form>    
                </div>
             </div>   
        </div>   
    </div> 

    <div class="col-xl-12">
        <div class="card custom-card">
            <div class="card-header justify-content-between">
               <div class="card-title">
                  <h5>Report</h5>
               </div>
         
            </div>
            <div class="card-body">
               <div class="table-responsive custom-scroll">
                  <table class="table text-nowrap table-bordered" id="datatables">
                     <thead>
                        <tr>
                           <th scope="col">Sr No</th>
                           <th scope="col">Date & Time</th>
                           <th scope="col">Member ID</th>
                           <th scope="col">Contact No</th>
                           <th scope="col">Category</th>
                           <th scope="col">Biller</th>
                           <th scope="col">Wallet Balance</th>
                           <th scope="col">Txn. ID</th>
                           <th scope="col">Txn. Amt</th>
                           <th scope="col">Commission</th>
                           <th scope="col">Closing Balance</th>
                           <th scope="col">Status</th>
                           <th scope="col">Device</th>
                           <th scope="col">Remark</th>
                           <th scope="col">Re-check</th>
                           <th scope="col">Edit</th>
                           <th scope="col">Invoice</th>
                        </tr>
                     </thead>
                     <tbody>
                    @php
                        // Payment Status
                        $statuses = ["Success", "Pending", "Failed", "Refunded"];

                        // Devices
                        $devices = ["Android", "Web", "API"];

                        // Random Names
                        $names = ["Rahul Sharma","Amit Verma","Neha Yadav","Pooja Chauhan","Sanjay Patel","Rohit Gupta","Kiran Singh","Vikas Mehta","Sunita Rajput","Deepak Agarwal","Anjali Saxena","Ayesha Rathod","Pawan Mishra","Manoj Tiwari","Sneha Kulkarni","Kunal Kapoor","Rajesh Sahu","Priya Mathur","Vivek Srivastava","Reena Desai"];

                        // Bill Categories + Billers
                        $billCategories = [
                            "Electricity" => ["Adani Electricity", "Tata Power", "BSES Rajdhani", "UPPCL", "KSEB"],
                            "Water" => ["Delhi Jal Board", "Chennai Metro Water", "BWSSB", "Nagpur Water"],
                            "Gas" => ["Indane Gas", "HP Gas", "Bharat Gas", "MNGL"],
                            "Mobile Postpaid" => ["Airtel Postpaid", "Jio Postpaid", "Vi Postpaid", "BSNL"],
                            "DTH" => ["Tata Play", "Airtel DTH", "Dish TV", "Videocon D2H"],
                            "Broadband" => ["Airtel Broadband", "Jio Fiber", "ACT Fibernet", "BSNL Broadband"],
                            "Landline" => ["BSNL Landline", "Airtel Landline", "MTNL"],
                            "Fastag Recharge" => ["HDFC FASTag", "ICICI FASTag", "Paytm FASTag", "Airtel FASTag"],
                            "Insurance" => ["LIC India", "HDFC Life", "ICICI Lombard", "SBI Life"],
                            "Loan Repayment" => ["Bajaj Finance", "HDFC Loan", "ICICI Loan", "IDFC Loan"]
                        ];

                        $rows = [];

                        for ($i = 1; $i <= 10; $i++) {

                            // Random Category
                            $category = array_rand($billCategories);

                            // Random Biller under that category
                            $biller = $billCategories[$category][array_rand($billCategories[$category])];

                            $fullName = $names[array_rand($names)];
                            $uniqueId = "RT" . rand(10000000, 99999999);

                            $rows[] = [
                                'srno' => $i,
                                'datetime' => now()->subMinutes(rand(10, 900))->format('d M Y h:i A'),
                                'member_id' => "$fullName ($uniqueId)",
                                'contact' => "9" . rand(100000000, 999999999),

                                'category' => $category,
                                'biller' => $biller,

                                'wallet_balance' => rand(100, 5000),
                                'txn_id' => "TXN" . rand(100000, 999999),
                                'txn_amt' => rand(50, 2000),
                                'commission' => rand(1, 50),   // Commission = charges

                                'closing_balance' => rand(100, 5000),
                                'status' => $statuses[array_rand($statuses)],
                                'device' => $devices[array_rand($devices)],
                                'remark' => "remark generated…"
                            ];
                        }
                    @endphp

                    
                    @foreach($rows as $row)
                        <tr>
                            <td>{{ $row['srno'] }}</td>
                            <td>{{ $row['datetime'] }}</td>
                            <td>{{ $row['member_id'] }}</td>
                            <td>{{ $row['contact'] }}</td>

                            <td>{{ $row['category'] }}</td>
                            <td>{{ $row['biller'] }}</td>

                            <td>₹ {{ $row['wallet_balance'] }}</td>
                            <td>{{ $row['txn_id'] }}</td>
                            <td>₹ {{ $row['txn_amt'] }}</td>
                            <td>₹ {{ $row['commission'] }}</td>
                            <td>₹ {{ $row['closing_balance'] }}</td>

                            <!-- STATUS -->
                            <td>
                                @if($row['status'] == 'Success')
                                    <span class="badge bg-success"><i class="fa fa-check-circle"></i> Success</span>
                                @elseif($row['status'] == 'Pending')
                                    <span class="badge bg-warning text-dark"><i class="fa fa-clock"></i> Pending</span>
                                @elseif($row['status'] == 'Failed')
                                    <span class="badge bg-danger"><i class="fa fa-times-circle"></i> Failed</span>
                                @elseif($row['status'] == 'Refunded')
                                    <span class="badge bg-info text-dark"><i class="fa fa-rotate-left"></i> Refunded</span>
                                @else
                                    <span class="badge bg-dark"><i class="fa fa-ban"></i> Chargeback</span>
                                @endif
                            </td>

                            <td>{{ $row['device'] }}</td>
                            <td>{{ $row['remark'] }}</td>

                            <!-- Re-check -->
                            <td>
                                <a href="javascript:void(0);" class="btn btn-sm btn-primary">
                                    <i class="fa fa-sync-alt"></i>
                                </a>
                            </td>

                            <!-- Edit -->
                            <td>
                                <a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#updatereportModal" class="btn btn-sm btn-warning">
                                    <i class="fa fa-edit"></i>
                                </a>
                            </td>

                            <!-- Invoice -->
                            <td>
                                <a href="javascript:void(0);" class="btn btn-sm btn-info text-white">
                                    <i class="fa fa-file-invoice"></i> View Now
                                </a>
                            </td>
                        </tr>
                    @endforeach

                     </tbody>
                  </table>
               </div>
            </div>
        </div>
    </div> 

</div>


    <div class="modal fade" id="updatereportModal"
        aria-labelledby="updatereportModalLabel" tabindex="-1" aria-hidden="true"
        style="display: none;">
        <div class="modal-dialog modal-sm modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header">
                  <h6 class="modal-title" id="staticBackdropLabel1">Update Report
                  </h6>
                  <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form id="update">
                <div class="modal-body">
                  <div class="formerror"></div>
                   @csrf
                   <div class="row">

                      <div class="col-md-12 mb-3">
                         <label class="form-label">Status</label>
                        <select name="status" class="form-control">
                            <option value="">-- Select Status --</option>
                            <option value="Success">Success</option>
                            <option value="Pending">Pending</option>
                            <option value="Failed">Failed</option>
                            <option value="Refunded">Refunded</option>
                            <option value="Chargeback">Chargeback</option>
                        </select>
                      </div>

                      <div class="col-md-12 mb-3">
                         <label class="form-label">Remark</label>
                         <textarea name="remark" rows="2" class="form-control" placeholder="Enter Remark...."></textarea>
                      </div>

                      <div class="col-md-12 mb-3">
                            Are you sure you want to update the
                            record on selected Transactions
                      </div>

                   </div>
                </div>
                <div class="modal-footer">
                  <button type="button" class="btn btn-sm btn-purple-gradient waves-light">Update</button> 
                  <button class="btn btn-danger btn-sm" data-bs-dismiss="modal">Close</button>
                </div>
                </form> 
            </div>
        </div>
    </div>
@endsection

@section('scripts')
<script type="text/javascript">
  $(document).ready(function() {
    var url = "{{url('statement/fetchdata')}}/topuprequest/0";
    var onDraw = function() {

    };
    var options = [
        { "data" : "name",
            'className' : "notClick",
            render:function(data, type, full, meta){
                return `#` + (meta.row + 1);
            }
        },
        { "data" : "created_at" },
   
        { "data" : "id" },
        { "data" : "id" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" },
        { "data" : "amount" }

    ];

    datatableSetup(url, options, onDraw);
    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('input[name="_token"]').val()
        }
    });




let actionClicked = '';

$('#topupUpdateFrm button[type="submit"]').on('click', function () {
    actionClicked = $(this).data('action'); // approved or rejected
});

$("#topupUpdateFrm").validate({
    rules: {
        remark: { required: true }
    },
    messages: {
        remark: { required: "Please enter remark" }
    },
    submitHandler: function (form, event) {
        var $form = $(form);
        $form.find('span.text-danger').remove();

        var action = actionClicked;

        // SweetAlert confirm (dynamic message)
        Swal.fire({
            title: (action === "approved") ? "Approve this request?" : "Reject this request?",
            text: "You cannot undo this action.",
            icon: "warning",
            showCancelButton: true,
            confirmButtonText: "Yes, " + action,
            cancelButtonText: "Cancel"
        }).then((result) => {
            if (result.isConfirmed) {
                $form.ajaxSubmit({
                    dataType: 'json',
                    data: { status: action }, // send clicked action
                    beforeSubmit: function () {
                        var btn = $(event.submitter);
                        btn.data('Submit', btn.html());
                        btn.prop('disabled', true).html('Loading...');
                    },
                    complete: function () {
                        var btn = $(event.submitter);
                        btn.prop('disabled', false).html(btn.data('Submit'));
                    },
                    success: function (result) {
                        if (result.statuscode == 'TXN') {
                            form.reset();
                            $('#fundRequestUpdateModel').modal('hide'); // close modal
                            msgalert('success', result.message);
                        } else {
                            msgalert('failed', result.message);
                        }
                    },
                    error: function (xhr) {
                        if (xhr.status === 422 && xhr.responseJSON && xhr.responseJSON.errors) {
                            let errors = xhr.responseJSON.errors;
                            let errorMessages = [];
                            Object.keys(errors).forEach(function (key) {
                                errorMessages.push(errors[key][0]);
                            });
                            Swal.fire({
                                icon: 'error',
                                title: 'Validation Error',
                                html: errorMessages.join('<br>')
                            });
                        } else {
                            Swal.fire({
                                icon: 'error',
                                title: 'Error',
                                text: xhr.responseJSON?.message || 'Something went wrong!'
                            });
                        }
                    }
                });
            }
        });
    }
});


  });

 
</script>
@endsection