@extends('operations.layout.mainlayout')

@section('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;">Price Adjustment</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">

                    <div class="col-12 col-sm-12 col-md-12 p-3">
                        <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>Paid from</b></span>
                                                    <input id="report-date-from" class="form-control mt-2 mb-2" 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>Paid to</b></span>
                                                    <input id="report-date-to" class="form-control mt-2 mb-2"  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>Result from</b></span>
                                                    <input id="report-r-date-from" class="form-control mt-2 mb-2" type="date" name="result_from" value="@if(!empty($result_from)){{$result_from}}@endif" placeholder="Date From">
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Result to</b></span>
                                                    <input id="report-r-date-to" class="form-control mt-2 mb-2"  type="date" name="result_to" value="@if(!empty($result_to)){{$result_to}}@endif" placeholder="Date To">
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-3">

                                                    <div class="mb-2">
                                                        <span class="text-muted text-sm"><b>Hospital</b></span>
                                                    </div>
                                                    <select class="form-control rhospital_id mt-2 mb-2" id="report-hospital-id" name="hospital">
                                                        <option value="">Select Hospital</option>
                                                        @foreach($hospitals as $ehospital)
                                                            <option value="{{$ehospital->ID}}">{{$ehospital->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-lg-3">
                                                    <div class="mb-2">
                                                        <span class="text-muted text-sm"><b>Location</b></span>
                                                    </div>
                                                    <select class="form-control rhospital_id mt-2 mb-2" id="report-location-id" name="location">
                                                        <option value="">Select Location</option>
                                                    </select>
                                                </div>
                                                <div class="col-md-3" >
                                                    <div class="mb-2">
                                                        <span class="text-muted text-sm"><b>Result</b></span>
                                                    </div>
                                                    <select class="form-control rhospital_id mt-2 mb-2" id="report-result" name="result">
                                                        <option value="">Select Result</option>
                                                        <option value="-1">Pending</option>
                                                        <option value="1">Negative</option>
                                                        <option value="2">Positive</option>
                                                        <option value="3">Pending Release</option>
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <div class="mb-2">
                                                        <span class="text-muted text-sm"><b>Status</b></span>
                                                    </div>
                                                    <select class="form-control rhospital_id mt-2 mb-2" id="report-status-id" name="status">
                                                        <option value="">Select Status</option>
                                                        <option value="-1">Rejected</option>
                                                        <option value="1">Order Confirmed</option>
                                                        <option value="13">Pre Analytical</option>
                                                        <option value="2">Sample Collected</option>
                                                        <option value="6">In Transit</option>
                                                        <option value="7">Dropped off</option>
                                                        <option value="5">Outsourced</option>
                                                        <option value="3">Sample Analyzed</option>
                                                        <option value="4">Ready</option>

                                                        <!-- @foreach($statuses as $status) -->
                                                        <!-- <option value="{{$status->LAB_ORDER_STATUS_ID}}">{{$status->DESC_EN}}</option> -->
                                                        <!-- @endforeach -->
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-6 mt-3">
                                                    <div class="mb-2">
                                                        <span class="text-muted text-sm"><b>Organization</b></span>
                                                    </div>
                                                    <select required id="report-org-id" class="form-control rhospital_id" name="org_id">
                                                        <option value="">Select Organization</option>
                                                        @foreach($companies as $company)
                                                            <option  value="{{$company->ID}}">{{$company->COMPANY_NAME}}{{!empty($company->CLIENT_CODE)?' ('.$company->CLIENT_CODE.')':''}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-6 mt-3">
                                                    <div class="mb-2">
                                                        <span class="text-muted text-sm"><b>Select Test Type</b></span>
                                                    </div>
                                                    <select class="form-control col-md-2 rhospital_id" multiple="multiple" id="samples-category-id" name="package_id">
                                                        @foreach($packages as $package)
                                                            <option value="{{$package->ID}}">{{$package->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="row mb-2">
                                                <div class="col-md-2 mt-3">
                                                    <span class="text-muted text-sm"><b>Reservation No.</b></span>
                                                    <input type="text"  class="form-control mt-2 mb-2" id="res-no" placeholder="Search by Reservation No." />
                                                </div>
                                                <div class="col-md-2 mt-3">
                                                    <span class="text-muted text-sm"><b>Sample ID</b></span>
                                                    <input type="text"  class="form-control mt-2 mb-2" id="sample-id" placeholder="Search by Sample ID" />
                                                </div>
                                                <div class="col-md-2 mt-3">
                                                    <span class="text-muted text-sm"><b>Mobile No.</b></span>
                                                    <input type="text"  class="form-control mt-2 mb-2" id="sample-mobile" placeholder="Search by Mobile No." />
                                                </div>
                                                <div class="col-md-2 mt-3">
                                                    <span class="text-muted text-sm"><b>Identification</b></span>
                                                    <input type="text"  class="form-control mt-2 mb-2" id="sample-identification" placeholder="Search by Identification" />
                                                </div>
                                                <div class="col-md-2 mt-3">
                                                    <span class="text-muted text-sm"><b>Name</b></span>
                                                    <input type="text"  class="form-control mt-2 mb-2" id="sample-name" placeholder="Search by Name" />
                                                </div>
                                                <div class="col-md-2 mt-3">
                                                    <span class="text-muted text-sm"><b>Passport</b></span>
                                                    <input type="text"  class="form-control mt-2 mb-2" id="sample-passport" placeholder="Search by Passport" />
                                                </div>
                                            </div>

                                            <div class="row">

                                                <div class="col-md-2">
                                                    <span class="text-muted text-sm"><b>Patient ID</b></span>
                                                    <input type="text"  class="form-control" id="patient-id" placeholder="Search by Patient ID" />
                                                </div>
                                                <div class="col-md-2">
                                                    <span class="text-muted text-sm"><b>MRN#</b></span>
                                                    <input type="text"  class="form-control" id="mrn-no" placeholder="Search by MRN#" />
                                                </div>
                                            </div>

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

                            </form>
                            <div class="card-footer bg-gray-200">



                                <div class="row">



                                    <div class="col-md-12">
                                        <div class="custom-control custom-switch">
                                            <input type="checkbox" class="custom-control-input" name="group-by-reservation" value="urgent" id="group-by-reservation">
                                            <label class="custom-control-label" for="group-by-reservation" style="margin-right: 10px;font-weight: 300;"> Group by Reservation ID</label>
                                        </div>
                                    </div>
                                </div>


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

                    <!-- /.card -->

                    <div class="card">

                        <!-- /.card-header -->
                        <div class="card-body">
                            <table id="price-adjustment-datatable" class="table table-bordered table-striped table-responsive"></table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<style>
    #report-hospital-id{
        margin-top: 8px;
    }
</style>
@endsection

@section('footer-scripts')
    <script>
        var PriceAdjustmentReportTable = $("#price-adjustment-datatable").DataTable({
            "responsive": false,
            "autoWidth": false,
            "lengthMenu": [[10, 25, 50, 500], [10, 25, 50, 500]],
            serverSide: true,
            "ordering": false,
            "searching": false,
            rowGroup: {
                enable: false,
                dataSrc:"END_USER_LAB_ORDER_ID",
            },
            "processing": true,
            ajax: {
                url : '/operations/price-adjustment-datatable',
                data: function (d) {
                    d.date_from = $('#report-date-from').val(),
                        d.date_to = $('#report-date-to').val(),
                        d.result_from = $('#report-r-date-from').val(),
                        d.result_to = $('#report-r-date-to').val(),
                        d.hospital_id = $('#report-hospital-id').val(),
                        d.status_id = $('#report-status-id').val(),
                        d.org_id = $('#report-org-id').val(),
                        d.only_seha = $('#only-seha-pending').is(':checked'),
                        d.result = $('#report-result').val(),
                        d.location = $('#report-location-id').val(),
                        d.test_category = $('#samples-category-id').val(),
                        d.res_id = $('#res-no').val(),
                        d.sample_id = $('#sample-id').val(),
                        d.sample_mobile = $('#sample-mobile').val(),
                        d.sample_identification = $('#sample-identification').val(),
                        d.sample_name = $('#sample-name').val(),
                        d.sample_passport = $('#sample-passport').val(),
                        d.patient_id = $('#patient-id').val(),
                        d.mrn = $('#mrn-no').val(),
                        d.group_by_reservation = $('#group_by_reservation').is(':checked')
                }
            },
            "order": [[ 0, "desc" ]],
            columns: [
                { data: "END_USER_LAB_ORDER_ID", title: "ReservationID" },
                { data: "ID", title: "TestID" },
                { data: "company", title: "Company" },
                { data: "NAME", title: "Patient" },
                { data: "NAME_EN", title: "Test"},
                { data: "AMOUNT", title: "Total" },
                { data: "payment_method_name", title: "Payment Method" },
                { data: "PRICE", title: "Price" },
                { data: "CASH_AMOUNT", title: "Cash" },
                { data: "VISA_AMOUNT", title: "Visa" },
                { data: "AMOUNT_TOTAL", title: "Amount" },
                { data: "IS_PAID", title: "Paid?" },
                { data: "PAID_BY", title: "Paid By" },
                { data: "PAID_TIME", title: "Paid Time" },
                { data: "OUTSOURCE_AMOUNT", title: "Outsource Total" },
                { data: "OUTSOURCE_CREDIT_AMOUNT", title: "Outsource Credit" },
                { data: "OUTSOURCE_PAYMENT_METHOD_NAME", title: "Outsource Payment M" },
                { data: "OUTSOURCE_PRICE", title: "Outsource price" },
                { data: "OUTSOURCE_TIME", title: "Outsource Time" },
                { data: "OUTSOURCE_ORG", title: "Outsource Contract" },
            ],
            "rowCallback": function( row, data ) {
                var increase = 0;
                if ($('#group-by-reservation').is(':checked')) {
                    increase = 1;
                }
                let is_paid = 'OFF';
                let is_paid_value = 0;
                if (data["IS_PAID"] == 1) {
                    is_paid = 'ON';
                    is_paid_value = 1;
                }
                $("td:eq(" + (7 - increase) + ")", row).html('<a href="#" class="text-link name xedit-price " data-pk="' + data["ID"] + '" data-title="Enter Price">' + (data["PRICE"] ? data["PRICE"] : '') + '</a>');
                $("td:eq(" + (8 - increase) + ")", row).html('<a href="#" class="text-link name xedit-cash-amount " data-pk="' + data["ID"] + '" data-title="Enter Cash amount">' + (data["CASH_AMOUNT"] ? data["CASH_AMOUNT"] : '') + '</a>');
                $("td:eq(" + (9 - increase) + ")", row).html('<a href="#" class="text-link name xedit-visa-amount " data-pk="' + data["ID"] + '" data-title="Enter Visa amount">' + (data["VISA_AMOUNT"] ? data["VISA_AMOUNT"] : '') + '</a>');
                $("td:eq(" + (10 - increase) + ")", row).html('<a href="#" class="text-link name xedit-total-amount " data-pk="' + data["ID"] + '" data-title="Enter Amount">' + (data["AMOUNT_TOTAL"] ? data["AMOUNT_TOTAL"] : '') + '</a>');
                $("td:eq(" + (11 - increase) + ")", row).html('<a href="#" class="text-link name xedit-is-paid " data-pk="' + data["ID"] + '" data-title="Is Paid" data-value="' + is_paid_value + '">' + is_paid + '</a>');
                $("td:eq(" + (12 - increase) + ")", row).html('<a href="#" class="text-link name xedit-paid-by " data-pk="' + data["ID"] + '" data-title="Paid By" >' + (data["PAID_BY"] ? data["PAID_BY"] : '') + '</a>');
                $("td:eq(" + (13 - increase) + ")", row).html('<a href="#" class="text-link name xedit-paid-time " data-pk="' + data["ID"] + '" data-title="Paid Time" >' + (data["PAID_TIME"] ? data["PAID_TIME"] : '') + '</a>');
                if (data["OUTSOURCE_ORG"]) {
                    $("td:eq(" + (14 - increase) + ")", row).html('<a href="#" class="text-link name xedit-outsource-amount " data-pk="' + data["ID"] + '" data-title="Outsouce amount" >' + (data["OUTSOURCE_AMOUNT"] ? data["OUTSOURCE_AMOUNT"] : '') + '</a>');
                    $("td:eq(" + (15 - increase) + ")", row).html('<a href="#" class="text-link name xedit-outsource-credit-amount " data-pk="' + data["ID"] + '" data-title="Outsource credit amount" >' + (data["OUTSOURCE_CREDIT_AMOUNT"] ? data["OUTSOURCE_CREDIT_AMOUNT"] : '') + '</a>');
                    $("td:eq(" + (16 - increase) + ")", row).html('<a href="#" class="text-link name xedit-outsource-payment-method " data-pk="' + data["ID"] + '" data-title="Enter Payment Method">' + (data["OUTSOURCE_PAYMENT_METHOD_NAME"] ? data["OUTSOURCE_PAYMENT_METHOD_NAME"] : '') + '</a>');
                    $("td:eq(" + (17 - increase) + ")", row).html('<a href="#" class="text-link name xedit-outsource-price " data-pk="' + data["ID"] + '" data-title="Enter Outsouce price">' + (data["OUTSOURCE_PRICE"] ? data["OUTSOURCE_PRICE"] : '') + '</a>');
                    $("td:eq(" + (18 - increase) + ")", row).html('<a href="#" class="text-link name xedit-outsource-time " data-pk="' + data["ID"] + '" data-title="Enter outsource time">' + (data["OUTSOURCE_TIME"] ? data["OUTSOURCE_TIME"] : '') + '</a>');
                }
                $("td:eq(" + (19 - increase) + ")", row).html('<a href="#" class="text-link name xedit-outsource-org " data-pk="' + data["ID"] + '" data-title="Enter Outsource org">' + (data["OUTSOURCE_ORG"] ? data["OUTSOURCE_ORG"] : '') + '</a>');
                if (data['is_company_user']){
                    $("td:eq(2)", row).html('<a href="#" class="text-link name xedit-company " data-pk="' + data["END_USER_LAB_ORDER_ID"] + '" data-title="Enter Company">' + (data["company"] ? data["company"] : '') + '</a>');
                }
            },
            "drawCallback": function( settings ) {
                $('.xedit-outsource-payment-method').editable({
                    type: 'select',
                    url: '/operations/price-adjustment/outsource-payment-method',
                    source: [
                            @if(!empty($payments))
                            @foreach($payments as $payment)
                        {value: {{$payment->PAYMENT_METHOD_ID}}, text: "{{$payment->DESC_EN}}"},
                        @endforeach
                        @endif
                    ],
                    success: function(response, newValue) {
                        PriceAdjustmentReportTable.draw();
                    }
                })
                $(".xedit-price").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/lab-order-package-price",
                });
                $(".xedit-outsource-price").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/outsource-price",
                });
                $(".xedit-outsource-amount").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/outsource-amount",
                });
                $(".xedit-outsource-credit-amount").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/outsource-credit-amount",
                });

                $(".xedit-cash-amount").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/outsource-cash-amount",
                    success: function(response, newValue) {
                        PriceAdjustmentReportTable.draw();
                    }
                })
                $(".xedit-visa-amount").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/outsource-visa-amount",
                    success: function(response, newValue) {
                        PriceAdjustmentReportTable.draw();
                    }
                })
                $(".xedit-total-amount").editable({
                    type: 'number',
                    step: 'any',
                    url: "/operations/price-adjustment/outsource-total-amount",
                    success: function(response, newValue) {
                        PriceAdjustmentReportTable.draw();
                    }
                })

                $(".xedit-is-paid").editable({
                    type: 'select',
                    url: "/operations/price-adjustment/is-paid",
                    source: [
                        {value: 0, text: "Off"},
                        {value: 1, text: "On"}
                    ],
                })


                $(".xedit-paid-by").editable({
                    type: 'select',
                    url: '/operations/price-adjustment/paidBy',
                    source: [
                            @if(!empty($users))
                            @foreach($users as $user)
                        {value: {{$user->ID}}, text: "{{$user->USERNAME}}"},
                        @endforeach
                        @endif
                    ]
                })
                $(".xedit-outsource-org").editable({
                    type: 'select',
                    url: '/operations/price-adjustment/outsource-org',
                    source: [
                            @if(!empty($usersOutSource))
                            @foreach($usersOutSource as $user)
                        {value: {{$user->ID}}, text: "{{$user->COMPANY_NAME}}"},
                        @endforeach
                        @endif
                    ],
                    success: function(response, newValue) {
                        PriceAdjustmentReportTable.draw();
                    }
                })
                $(".xedit-company").editable({
                    type: 'select',
                    url: '/operations/price-adjustment/user-company',
                    source: [
                            @if(!empty($companies))
                            @foreach($companies as $company)
                        {value: {{$company->ID}}, text: "{{$company->COMPANY_NAME}}"},
                        @endforeach
                        @endif
                    ],
                    success: function(response, newValue) {
                        PriceAdjustmentReportTable.draw();
                    }
                })

                $(".xedit-paid-time").editable({
                    template: 'YYYY / MM / DD  HH:mm:ss',
                    type : 'combodate',
                    format: 'YYYY-MM-DD HH:mm:ss',
                    viewformat: 'YYYY/MM/DD HH:mm:ss',
                    url: '/operations/price-adjustment/paid-time',
                });

                $(".xedit-outsource-time").editable({
                    template: 'YYYY / MM / DD  HH:mm:ss',
                    type : 'combodate',
                    format: 'YYYY-MM-DD HH:mm:ss',
                    viewformat: 'YYYY/MM/DD HH:mm:ss',
                    url: '/operations/price-adjustment/outsource-time',
                });


            }
        });

        $("#report-date-from").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#report-r-date-from").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#sample-passport").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#patient-id").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#mrn-no").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#res-no").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#sample-id").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#sample-mobile").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#sample-identification").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#sample-name").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#report-date-to").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#report-r-date-to").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#report-location-id").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#report-status-id").change(function(){
            PriceAdjustmentReportTable.draw();
        });

        $("#report-org-id").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#report-result").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#samples-category-id").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#only-seha-pending").change(function(){
            PriceAdjustmentReportTable.draw();
        });
        $("#group-by-reservation").change(function(){
            if($('#group-by-reservation').is(':checked')){
                PriceAdjustmentReportTable.rowGroup().enable().draw();
                PriceAdjustmentReportTable.columns([0]).visible(false);
            }else {
                PriceAdjustmentReportTable.rowGroup().disable().draw();
                PriceAdjustmentReportTable.columns([0]).visible(true);
            }
        });


        $("#report-hospital-id").change(function(){
            if($("#report-hospital-id").val()) {
                $.ajax({
                    type: "GET",
                    url: "/hospital/" + $("#report-hospital-id").val() + "/getLocations",
                }).done(function (data, textStatus, xhr) {
                    if (data.payload) {
                        $("#report-location-id").empty();
                        $("#report-location-id").append('<option value="0">Select Location</option>');
                        data.payload.forEach(function (element) {
                            $("#report-location-id").append('<option value="' + element.ID + '">' + element.NAME_EN + '</option>');
                        })
                    } else {
                        alert("Please re-login, your session has ended");
                    }
                }).fail(function (jqXHR, textStatus, errorThrown) {
                    alert(jqXHR.responseJSON.errorMessage);
                });
            }else{
                $("#report-location-id").empty();
                $("#report-location-id").append('<option value="0">Select Location</option>');
            }
            PriceAdjustmentReportTable.draw();
        });
    </script>
@endsection