@extends('operations.layout.mainlayout')

@section('content')
{{--    @if(session('role') != 4 && session('role') != 5 && session('role') != 8)--}}
{{--        {{exit("<h1>Unauthorized access</h1>")}}--}}
{{--    @endif--}}
<!-- Content Wrapper. Contains page content -->
<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;">Branch Income Report</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-3">
                                                    <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-3">
                                                    <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-3">
                                                    <span class="text-muted text-sm"><b>Branch</b></span>
                                                    <select required class="form-control rhospital_id multi" id="branches_id"  multiple="multiple" name="hospital[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option value="" disabled>Select Branch</option>
                                                        @foreach($hospitals as $ehospital)
                                                            <option class="hospital-option" @if(!empty($hospital) && in_array($ehospital->ID,explode(",",$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-3">
                                                    <span class="text-muted text-sm"><b>Client Groups</b></span>
                                                    <select  class="form-control rhospital_id multi" id="group_ids"  multiple="multiple" name="groups_filter[]">
                                                        <option value="" disabled>Select Group</option>
                                                        @foreach($groups as $group)
                                                            <option class="hospital-option" @if(!empty($groups_filter) && in_array($group->ID,explode(",",$groups_filter)) ) selected @endif  value="{{$group->ID}}">{{$group->NAME}}-{{$group->CODE}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>

                                                <div class="col-md-3">
                                                    <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 class="col-md-3">
                                                <span class="text-muted text-sm"><b>Reservation Type</b></span>
                                                <select class="form-control" name="reservation_type" id="reservation_type">
                                                            <option value="">Reservation Type</option>
                                                            <option @if(!empty($reservation_type) && $reservation_type == 1) selected @endif value="1">Normal</option>
                                                            <option @if(!empty($reservation_type) && $reservation_type == 2) selected @endif value="2">Home Visit</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-report" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>User</th>
                                    <th>Test QTY</th>
                                    <th>Reservations QTY</th>
                                    <th>Patients QTY</th>
                                    <th>Total Price</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 Price</th>
                                    <th>Cost Price</th>
                                    <th>P&L (Subtotal - Cost)</th>
                                    <th>Refund ({{$global_symbol['tax'] ?? 'TAX'}})</th>
                                    <th>Refund</th>
                                    <th>Refund-{{$global_symbol['tax'] ?? 'TAX'}}</th>

                                    <th>Credit</th>
                                    <th>Online</th>
                                    <th>Bank Trans</th>
                                    <th>Tamara</th>
                                    <th>Tabby</th>
                                    <th>Cash</th>
                                    <th>Visa</th>
                                    <th>Delivered Custody</th>
                                    <th>Remaining Custody</th>
                                    <th>Invoice Payment</th>
                                    <th>Branch</th>
                                    <th>Employee Number</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                    <tr>
                                        @php
                                        $hospital_query=[];
                                            if(!empty($hospital)){
                                                foreach (explode(',',$hospital) as $h){
                                                    $hospital_query[]='hospital[]='.$h;
                                                }
                                            }
                                            if (!empty($hospital_query)){
                                                $hospital_query = implode('&',$hospital_query);
                                            }
                                        @endphp
                                        <td><a target="_blank" href="/operations/payment-summery-details-report?date_from={{empty($date_from) ? '' : $date_from}}&date_to={{empty($date_to) ? '' : $date_to}}&user={{$order->PAID_BY}}{{ !empty($hospital_query) ? '&'.$hospital_query : '&hospital[]=' }}&submit=Filter+Results">{{$order->USERNAME}}</a></td>
                                        <td>{{$order->QTY}}</td>
                                        <td>{{$order->TOTAL_RESERVATIONS}}</td>
                                        <td>{{$order->TOTAL_PATIENT}}</td>
                                        <td>{{round($order->TOTAL_DISCOUNT + $order->TOTAL_PRICE - $order->TOTAL_TAX, 2)}}</td>
                                        <td>{{$order->TOTAL_DISCOUNT}}</td>
                                        <td>{{$order->TOTAL_POINT_AMOUNT}}</td>
                                        <td>{{$order->TOTAL_QITAF_AMOUNT ?? 0}}</td>
                                        <td>{{round($order->TOTAL_PRICE - $order->TOTAL_TAX, 2)}}</td>
                                        <td>{{round($order->TAXABLE, 2)}}</td>
                                        <td>{{round($order->TOTAL_TAX,2)}}</td>
                                        <td>{{round($order->TOTAL_PRICE, 2)}}</td>
                                        <td>{{round($order->COST_PRICE, 2)}}</td>
                                        <td>{{round($order->TOTAL_PRICE - $order->TOTAL_TAX, 2) - round($order->COST_PRICE, 2)}}</td>
                                        <td>{{round($order->TOTAL_REFUND, 2)}}</td>
                                        <td>{{round($order->TOTAL_REFUND - $order->TOTAL_TAX_REFUND, 2)}}</td>
                                        <td>{{round($order->TOTAL_TAX_REFUND, 2)}}</td>
                                        <td>{{round($order->TOTAL_CREDIT,2)}}</td>
                                        <td>{{round(($order->TOTAL_ONLINE),2)}}</td>
                                        <td>{{round($order->TOTAL_BANK_TRANSFER,2)}}</td>
                                        <td>{{round($order->TOTAL_TAMARA,2)}}</td>
                                        <td>{{round($order->TOTAL_TABBY,2)}}</td>
                                        <td>{{$order->TOTAL_CASH / 100}}</td>
                                        <td>{{$order->TOTAL_VISA / 100}}</td>
                                        <td>{{empty($order->TOTAL_INVOICE) ? "0" : $order->TOTAL_INVOICE}}</td>
                                        <td>{{round(($order->TOTAL_CASH / 100) + ($order->TOTAL_VISA / 100),2) - (empty($order->TOTAL_INVOICE) ? 0 : round($order->TOTAL_INVOICE,2))}}</td>
                                        <td>
                                            @permission('view_reporting_income_payment_invoice')
                                                <button id="user-invoice" user-id="{{$order->PAID_BY}}" class="btn btn-info user-invoice">Handover Custody</button>
                                            @endpermission
                                        </td>
                                        <td>{{$order->NAME_EN}}</td>
                                        <td>{{$order->EMPLOYEE_NUM}}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th>Totals</th>
                                <th>{{$qty_total}}</th>
                                <th>{{$total_reservations}}</th>
                                <th>{{$total_patient}}</th>
                                <th>{{$total_price}}</th>
                                <th>{{$discount_total}}</th>
                                <th>{{$point_amount_total}}</th>
                                <th>{{$qitaf_amount_total ?? 0}}</th>
                                <th>{{round($sub_total, 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($sub_total-$total_cost_price, 2)}}</th>
                                <th>{{round($total_refund, 2)}}</th>
                                <th>{{round($total_refund-$total_tax_refund, 2)}}</th>
                                <th>{{round($total_tax_refund, 2)}}</th>
                                <th>{{round($credit_total,2)}}</th>
                                <th>{{round(($online_total),2)}}</th>
                                <th>{{round($bank_transfer_total,2)}}</th>
                                <th>{{round($total_tamara,2)}}</th>
                                <th>{{round($total_tabby,2)}}</th>
                                <th>{{$cash_total}}</th>
                                <th>{{$visa_total}}</th>
                                <th>{{$total_invoice}}</th>
                                <th>{{round($total,2) - round($total_invoice,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 -->
<div class="modal fade" id="modal-invoice">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h3 class="modal-title">Handover Custody</h3>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <form id="invoice-form" method="post"  action="/suser/invoice">
                <input class="form-control" type="hidden" name="date_from" value="@if(!empty($date_from)){{$date_from}}@endif">
                <input class="form-control"  type="hidden" name="date_to" value="@if(!empty($date_to)){{$date_to}}@endif">
                <input class="form-control"  type="hidden" name="hospital" value="@if(!empty($hospital)){{$hospital}}@endif">
                <div class="modal-body">
                    <label for="invoice-date">Date</label>
                    <input required id="invoice-date" class="form-control" type="date" name="invoice-date" value="@if(!empty($date_from)){{$date_from}}@endif" placeholder="Invoice Date">
                    <label for="invoice-amount">Custody Amount</label>
                    <input required id="invoice-amount" name="invoice_amount" class="form-control" value="0" type="number" step="0.01" />
                </div>
                <div class="modal-footer ">
                    <button style="border-radius: 20px;padding:14px;font-size:15px;min-width:150px;" type="button" class="btn btn-default" data-dismiss="modal">{{trans("web.cancel")}}</button>
                    <button style="border-radius: 20px;padding:14px;font-size:15px;min-width:150px;" id="invoice"  type="submit" class="btn btn-info">Submit</button>
                </div>
            </form>
        </div>
        <!-- /.modal-content -->
    </div>
    <!-- /.modal-dialog -->
</div>

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

        });
        $("#payment-report").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,
        });

    </script>
@endsection