@extends('operations.layout.mainlayout')

@section('content')
{{--    @if(session('role') != 4 && session('role') != 5 && session('role') != 8 && session('role') != 1 && session('role') != 19)--}}
{{--        {{exit("<h1>Unauthorized access</h1>")}}--}}
{{--    @endif--}}
<!-- Content Wrapper. Contains page content -->

<style>
    #payment-table th {
        white-space: nowrap;
    }
</style>
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
        <div class="container-fluid card">
            <div class="row mb-2">
                <div class="col-sm-6 card-body">
                    <h1 class="m-0 text-dark" style="color: var(--blazma-text)!important;">User Income Report - Reservation</h1>
                </div><!-- /.col -->
                <div class="col-sm-6">

                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">

                    <!-- /.card -->
                    <div class="col-12 col-sm-12 col-md-12">
                        <br />
                        <div class="card bg-light">
                            <div class="card-header text-muted border-bottom-0">
                            </div>
                            <form method="get" action="" style="width:100%;">
                                <div class="card-body pt-0">
                                    <div class="row">
                                        <div class="col-12">


                                            <div class="row">
                                                <div class="col-md-4">
                                                    <span class="text-muted text-sm"><b>Payment Date from</b></span>
                                                    <input id="date-from" class="form-control" type="date" name="date_from" value="@if(!empty($date_from)){{$date_from}}@endif" placeholder="Date From" />                                         </div>
                                                <div class="col-md-4">
                                                    <span class="text-muted text-sm"><b>Payment Date to</b></span>
                                                    <input id="date-to" class="form-control"  type="date" name="date_to" value="@if(!empty($date_to)){{$date_to}}@endif" placeholder="Date To" />
                                                </div>
                                                <div class="col-md-2">
                                                    <span class="text-muted text-sm"><b>User</b></span>
                                                    <select class="form-control rhospital_id" name="user" @if(session('role') == 1) required @endif>
                                                        <option value="">Select User</option>
                                                        @foreach($users as $euser)
                                                            <option @if(!empty($user) && $user == $euser->ID) selected @endif value="{{$euser->ID}}">{{$euser->USERNAME}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-2">
                                                    <span class="text-muted text-sm"><b>Reservation Type</b></span>
                                                    <select class="form-control" name="type_id">
                                                        <option value="">Select Type</option>
                                                        <option value="1" {{!empty($type) && $type == 1 ? 'selected' : ''}}>Normal</option>
                                                        <option value="2" {{!empty($type) && $type == 2 ? 'selected' : ''}}>Home Visit</option>
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-4" @if(session('role') == 1 || session('role') == 19) style="display: none;" @endif>
                                                    <span class="text-muted text-sm"><b>Branch</b></span>
                                                    <select class="form-control rhospital_id multi"  multiple="multiple" name="hospital[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option value="">Select Branch</option>
                                                        @foreach($hospitals as $ehospital)
                                                            <option class="hospital-option" @if(!empty($hospital) && in_array($ehospital->ID,$hospital) ) selected @endif value="{{$ehospital->ID}}">{{$ehospital->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                    <div class="custom-control custom-switch">
                                                        <input type="checkbox" class="custom-control-input" @if(isset($all_hospital)) checked @endif value="1" name="all_hospital" id="select-all">
                                                        <label class="custom-control-label" for="select-all"  style="margin-right: 10px;font-weight: 300;"> Select All</label>
                                                    </div>
                                                </div>

                                                <div class="col-md-4">
                                                    <span class="text-muted text-sm"><b>Client</b></span>
                                                    <select id="report-org-id" class="form-control rhospital_id" name="org_id">
                                                        <option value="">Select Client</option>
                                                        @foreach($companies as $company)
                                                            <option value="{{$company->ID}}" {{!empty($org_id) & $org_id == $company->ID ? 'selected' : ''}}>{{$company->COMPANY_NAME}}{{!empty($company->CLIENT_CODE)?' ('.$company->CLIENT_CODE.')':''}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-2">
                                                    <span class="text-muted text-sm"><b>Payment Method</b></span>
                                                    <select id="payment-method" name="payment_method" class="form-control rhospital_id">
                                                        <option value="">Select Payment Method</option>
                                                        <option value="1" {{!empty($payment_method) && $payment_method == '1' ? ' selected' : ''}}>Cash</option>
                                                        <option value="2" {{!empty($payment_method) && $payment_method == '2' ? ' selected' : ''}}>Visa</option>
                                                        <option value="3" {{!empty($payment_method) && $payment_method == '3' ? ' selected' : ''}}>Cash + Visa</option>
                                                        <option value="4" {{!empty($payment_method) && $payment_method == '4' ? ' selected' : ''}}>Bank Trans</option>
                                                        <option value="5" {{!empty($payment_method) && $payment_method == '5' ? ' selected' : ''}}>Refund ( Refund Cash OR Refund Visa )</option>
                                                        <option value="6" {{!empty($payment_method) && $payment_method == '6' ? ' selected' : ''}}>Tabby</option>
                                                        <option value="7" {{!empty($payment_method) && $payment_method == '7' ? ' selected' : ''}}>Tamara</option>
                                                    </select>
                                                </div>
                                                <div class="col-md-2">
                                                    <span class="text-muted text-sm"><b>Taxable</b></span>
                                                    <select class="form-control rhospital_id multi"  name="tax_type">
                                                        <option value="">All</option>
                                                        <option value="2" {{!empty($tax_type) && $tax_type == 2 ? 'selected' : ''}}>Non Taxable</option>
                                                        <option value="1" {{!empty($tax_type) && $tax_type == 1 ? 'selected' : ''}}>Taxable</option>
                                                    </select>
                                                </div>
                                            </div>


                                        </div>
                                    </div>
                                </div>
                                <div class="card-footer">
                                    <div class="text-right">
                                        <button type="submit" class="btn btn-sm btn-info">
                                            <i class="fas fa-search"></i> Submit
                                        </button>
                                        <button  type="submit" name="export" value="export" class="btn btn-sm btn-success">
                                            <i class="fas fa-download"></i> Export Excel
                                        </button>
                                    </div>
                                </div>

                            </form>
                        </div>
                    </div>
                    <div class="card">

                        <!-- /.card-header -->
                        <div class="card-body">
                            <table id="payment-summary-details" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th class="w-100">User</th>
                                    <th>Paid User ID</th>
                                    <th>Reservation ID</th>
                                    <th>Invoice ID</th>
                                    <th>Payment Date & Time</th>
                                    <th>Reference No</th>
                                    <th>Patient Name</th>
                                    <th>Nationality</th>
                                    <th>Client Name</th>
                                    <th>Identity</th>
                                    <th>Registration Branch</th>
                                    <th>Payment Branch</th>
                                    <th>Collection Branch</th>
                                    <th>Reservation Type</th>
                                    <th>Payment Method</th>
                                    <th>Refund Reason</th>
                                    <th>POS Serial Number</th>
                                    <th>B2B Cash</th>
                                    <th>Cash</th>
                                    <th>Visa</th>
                                    <th>Bank Transfer</th>
                                    <th>Online</th>
                                    <th>Credit</th>
                                    <th>Discount</th>
                                    <th>Point Amount</th>
                                    <th>Qitaf Amount</th>
                                    <th>Subtotal</th>
                                    <th>Taxable Amount</th>
                                    <th>{{$global_symbol['tax'] ?? 'TAX'}}</th>
                                    <th>Net Total</th>
                                    <th>Cost Price</th>
                                    <th>P&L (Subtotal - Cost)</th>
                                    <th>Remaining Amount</th>
                                    <th>Client Group</th>
                                    <th>Verification Reference Order</th>
                                    <th>Notes</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                        <tr>
                                            <td>{{$order->USERNAME}}</td>
                                            <td>{{$order->EMPLOYEE_NUM}}</td>
                                            <td><a href="/operations/reservations/{{$order->END_USER_LAB_ORDER_ID}}">{{$order->END_USER_LAB_ORDER_ID}}</a></td>
                                            <td>{{$order->INVOICE_NUMBER}}</td>
                                            <td>{{$order->REFUND_TIME??$order->PAID_TIME}}</td>
                                            <td>{{$order->REFERENCE_NO ?? ''}}</td>
                                            <td>{{$order->NAME}}</td>
                                            <td>{{$order->NATIONALITY_ID == 140 ? 'Saudi' : 'Non Saudi'}}</td>
                                            <td>{{$order->COMPANY_NAME}}</td>
                                            <td>{{$order->IDENTIFICATION}}</td>
                                            <td>{{empty($order->NAME_EN) ? 'Home Visit' : $order->NAME_EN}}</td>
                                            <td>{{$order->PAYMENT_BRANCH ?? (empty($order->NAME_EN) ? 'Home Visit' : $order->NAME_EN)}}</td>
                                            <td>{{$order->COLLECTED_BRANCH ?? (empty($order->NAME_EN) ? 'Home Visit' : $order->NAME_EN)}}</td>
                                            <td>{{$order->TYPE_ID == 1 ? 'Normal' : 'Home Visit'}}</td>
                                            <td>{{$order->DESC_EN}}</td>
                                            <td>{{$order->REFUND_REASON ?? ''}}</td>
                                            <td>{{$order->pos_serial_number}}</td>
                                            <td>{{$order->TOTAL_B2B_CASH}}</td>
                                            <td>{{$order->CASH_AMOUNT / 100}}</td>
                                            <td>{{$order->VISA_AMOUNT / 100}}</td>
                                            <td>{{$order->BANK_TRANSFER ?? 0}}</td>
                                            <td>{{$order->ONLINE ?? 0}}</td>
                                            <td>{{$order->CREDIT ?? 0}}</td>
                                            <td>{{$order->DISCOUNT_AMOUNT}}</td>
                                            <td>{{$order->POINT_AMOUNT}}</td>
                                            <td>{{$order->QITAF_AMOUNT ?? 0}}</td>
                                            <td>{{round(($order->SUBTOTAL_AMOUNT),2)}}</td>
                                            <td>@if($order->TAX > 0) {{round(($order->PRICE - $order->TAX_AMOUNT),2)}} @else 0 @endif</td>
                                            <td>{{round(($order->TAX_AMOUNT),2)}}</td>
                                            <td>{{($order->PRICE)}}</td>
                                            <td>{{round(($order->COST_PRICE),2)}}</td>
                                            <td>{{round(($order->PRICE - $order->TAX_AMOUNT) -($order->COST_PRICE),2)}}</td>
                                            <td>{{$order->REMAINING_AMOUNT}}</td>
                                            <td>{{$order->CLIENT_GROUP ?? ''}}</td>
                                            <td>{{$order->VERIFICATION_REFERENCE_ORDER ?? ''}}</td>
                                            <td>
                                                @if($order->NOTES)
                                                    <span class="comment-cell" style="cursor:pointer;color:#007bff;"
                                                          data-comment="{{ $order->NOTES }}">
                                                        {{ Str::limit($order->NOTES, 50) }}
                                                    </span>
                                                @endif
                                            </td>
                                        </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th>Totals</th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th>{{$b2b_total}}</th>
                                <th>{{$cash_total}}</th>
                                <th>{{$visa_total}}</th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th>{{$discount_total}}</th>
                                <th>{{$point_amount_total}}</th>
                                <th>{{$qitaf_amount_total ?? 0}}</th>
                                <th>{{round($subtotal,2)}}</th>
                                <th>{{round($total_taxable,2)}}</th>
                                <th>{{round($tax_total,2)}}</th>
                                <th>{{round($net_total,2)}}</th>
                                <th>{{round($total_cost_price,2)}}</th>
                                <th>{{round($subtotal - $total_cost_price,2)}}</th>
                                <th>{{round($remaining_total,2)}}</th>
                                <th></th>
                                <th></th>
                                <th></th>
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->

<!-- Comment Modal -->
<div class="modal fade" id="commentModal" tabindex="-1" role="dialog">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Comment</h5>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
            </div>
            <div class="modal-body">
                <p id="commentModalContent"></p>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

@endsection
@section('footer-scripts')
    <script>
        $('#select-all').on("click", function (e) {
            if($("#select-all").is(':checked'))
            {
                $(".rhospital_id > .hospital-option").prop("selected","selected");
                $(".rhospital_id").trigger("change");
            }
            else{
                $(".rhospital_id > .hospital-option").prop("selected","");
                $(".rhospital_id").trigger("change");
            }

        });

        $("#payment-summary-details").DataTable({
            dom: 'lBfrtip',
            "buttons" : [
                'copy', {
                    extend: 'csv',
                    charset: 'UTF-8',
                    bom: true,
                    footer: true,
                    filename: 'User Income Report - Reservation',
                    title: 'User Income Report - Reservation'
                }, 'excel', 'pdf', 'print'
            ],
            "lengthMenu": [[10, 25, 50, 100, 500,1000,5000,10000,100000], [10, 25, 50, 100, 500, 1000,5000,10000,100000]],
            scrollX: true,
            "autoWidth": false,
            "order": [[ 0, "asc" ]],
            "paging": true,
        });

        $('#payment-summary-details').on('click', '.comment-cell', function() {
            showCommentModal($(this).data('comment'));
        });

        function showCommentModal(comment) {
            $('#commentModalContent').text(comment);
            $('#commentModal').modal('show');
        }
    </script>
@endsection