@extends('layouts.master')

@section('page_title', 'Campaign Sale Report')
@section('title', 'Campaign Sale Report')
@section('main_item', 'Reports')
@section('sub_item', 'Campaign Sale Report')

@section('content')
    <div class="col-12">
        <div class="card">
            <div id="accordion">
                <div class="border-bottom card-header" style="background-color: white; cursor: pointer;" data-toggle="collapse"
                    data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                    <h4 class="mb-0 header-title">
                        Filter
                    </h4>
                </div>
                <div id="collapseOne" class="collapse show mt-3" aria-labelledby="headingOne" data-parent="#accordion">
                    <div class="card-body">
                        <form action="{{ url('batch/sale/report') }}" method="get" id="filter_form">
                            <div class="row">
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label class="required" style="font-weight: bold">Business Location</label>
                                        <select class="form-control select2" id="business_location_id"
                                            name="business_location_id">
                                            <option value="">All</option>
                                            @if (Auth::user()->role_id == '1')
                                                @foreach ($users_access_location as $business_location)
                                                    @if ($business_location->is_active == '1')
                                                        <option value="{{ $business_location->id }}"
                                                            @if (request('business_location_id') == $business_location->id) selected @endif>
                                                            {{ $business_location->name }}
                                                        </option>
                                                    @else
                                                    @endif
                                                @endforeach
                                            @else
                                                @foreach ($users_access_location as $business_location)
                                                    @if ($business_location->is_active == '1')
                                                        <option value="{{ $business_location->business_location_id }}"
                                                            @if (request('business_location_id') == $business_location->business_location_id) selected @endif>
                                                            {{ $business_location->name }}
                                                        </option>
                                                    @else
                                                    @endif
                                                @endforeach
                                            @endif
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label style="font-weight: bold" for="">Order Campagin </label>
                                        <select class = "form-control select2" name="order_batch" id="order_batch"
                                            style="color:black; font-weight:bold">
                                            <option value=""> Choose Order Campagin </option>
                                            @foreach ($batchs as $batch)
                                                <option value="{{ $batch->id }}"
                                                    @if (request('order_batch') == $batch->id) selected @endif>
                                                    {{ $batch->batch_name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label style="font-weight: bold" for="supplier">Date Range</label>
                                        <div class="input-group">
                                            <input type="text" class="form-control" name="dates" id="reportrange"
                                                readonly>
                                            <div class="input-group-append">
                                                <span class="input-group-text"><i class="dripicons-calendar"></i></span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label style="font-weight: bold" for="order_count">Marketing Cost</label>
                                        <input id="markating_cost" name="markating_cost" type="text" class="form-control"
                                            placeholder="Enter Markating Cost..." aria-label="Enter Markating Cost..."
                                            value="{{ request('markating_cost') }}">
                                    </div>
                                </div>
                            </div>
                            <div>
                                <button class="btn btn-primary px-5 py-2 submit-filters" id="filter">Generate</button>
                                <a href="{{ url('batch/sale/report') }}" class="btn btn-danger px-5 py-2">Reset</a>
                            </div>
                            <div>
                                <a href="{{ url('batch/sale/report') }}"
                                    class="btn btn-primary float-right px-5 py-2 submit-filters" data-type="excel">Download
                                    Excel</a>
                                <span id="btn_print">
                                    <button type="button" id="print" class="btn btn-primary float-right px-5 py-2"
                                        style="position: relative;">Print</button></span>
                            </div>
                            <input type="hidden" name="data_type" id="data_type" value="">
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-12 mt-2">
        <div class = "card">
            <div class="card-body">
                <div class="h4"><i class="dripicons-cart"></i>&nbsp; Summary</div>
                <h4>Total Sale : Rs.{{ number_format($total_sale, 2) }}<span></span></h4>
                <h4>Total Order Cost : Rs.{{ number_format($order_cost, 2) }}<span></span></h4>
                <h4>Total Delivery Fee : Rs.{{ number_format($total_delivery_free) }}<span></span></h4>
                <h4>Total Return Fee : Rs.{{ number_format($return_free, 2) }}<span></span></h4>
                <h4>Total Marketing Cost : Rs.{{ number_format($marketing_cost, 2) }}<span></span></h4>
                <h4>Profit :
                    Rs.{{ number_format($profit, 2) }} <span></span></h4>
                    (Total Sale - (Total Order Cost + Total Delivery Fee + Total Return Fee + Total Marketing Cost))
            </div>
        </div>
    </div>
    <div class="col-12 mt-2">
        <div class = "card">
            <div class="card-body">
                <h4 class="header-title mt-2">Campaign Sale Details</h4>
                <table id="laravel_datatable" class="table table-hover">
                    <thead class="thead-dark">
                        <tr>
                            <th>
                                Campgin Name
                            </th>
                            <th>
                                Bussiness Location
                            </th>
                            <th>
                                Waybill No
                            </th>
                            <th>
                                Sale Date
                            </th>
                            <th>
                                Selling Price
                            </th>
                            <th>
                                Order Cost
                            </th>
                            <th>
                                Delivery Fee
                            </th>
                            <th>
                                Marketing Cost
                            </th>
                            <th>
                                Gross Profit
                            </th>
                            <th>
                                Order By Profit
                            </th>
                        </tr>
                    </thead>
                    <tbody id="table-body">
                        @foreach ($campagin_batchs as $campagin_batch)
                            <tr>
                                <td>
                                    @if (!empty($campagin_batch->batch_name))
                                        {{ $campagin_batch->batch_name }}
                                    @else
                                        N/A
                                    @endif
                                </td>
                                <td>
                                    @if (!empty($campagin_batch->location))
                                        {{ $campagin_batch->business_locations->name }}
                                    @else
                                        N/A
                                    @endif
                                </td>
                                <td>{{ $campagin_batch->full_waybill_no }}</td>
                                <td>
                                    {{ Carbon\Carbon::parse($campagin_batch->sale_date)->toDateString() }}
                                </td>
                                <td>
                                    {{ number_format($campagin_batch->invoice_nettotal, 2) }}
                                </td>
                                <td>{{ number_format($campagin_batch->order_cost, 2) }}</td>
                                @php
                                    $delivery_fee = App\OrderCourierPayment::where('waybill_id', $campagin_batch->full_waybill_no)->first();
                                @endphp
                                <td>
                                    @if (!empty($delivery_fee->courier_fee))
                                        {{ number_format($delivery_fee->courier_fee, 2) }}
                                    @elseif (!empty($campagin_batch->delivery_fee))
                                        {{ number_format($campagin_batch->delivery_fee, 2) }}
                                    @else
                                        0.0
                                    @endif
                                </td>
                                <td>{{ number_format($markating, 2) }}</td>
                                <td>{{ number_format($campagin_batch->invoice_nettotal - $campagin_batch->order_cost, 2) }}
                                </td>
                                <td>
                                    @php
                                        if (!empty($delivery_fee->courier_fee)) {
                                            $courier_fee = number_format($delivery_fee->courier_fee, 2);
                                        } elseif (!empty($campagin_batch->delivery_fee)) {
                                            $courier_fee = number_format($campagin_batch->delivery_fee, 2);
                                        } else {
                                            $courier_fee = '0.0';
                                        }
                                        if (!empty($delivery_fee->return_fee)) {
                                            $return_free = $delivery_fee->return_fee;
                                        } else {
                                            $return_free = '0.00';
                                        }
                                        $cost = $courier_fee + $campagin_batch->order_cost + $markating + $return_free;
                                        $profit = $campagin_batch->invoice_nettotal - $cost;
                                    @endphp
                                    {{ number_format($profit, 2) }}
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
                <div class="d-flex justify-content-end">
                    {{ $campagin_batchs->appends($_GET)->links() }}
                </div>
                <div>
                    @php
                        $count = $campagin_batchs->count();
                    @endphp
                    <span style="font-weight: bold">Total Count&nbsp;&nbsp;
                        {{ $count }}
                    </span>
                </div>
            </div>
        </div>
    </div>
    <input type="hidden" id="enable_today_date" value="{{ $setting->enable_today_date == '1' ? '1' : '0' }}">
@endsection
@section('scripts')
    <script>
        $(document).ready(function() {
            var getUrlParameter = function getUrlParameter(sParam) {
                var sPageURL = decodeURIComponent(window.location.search.substring(1)),
                    sURLVariables = sPageURL.split('&'),
                    sParameterName,
                    i;
                for (i = 0; i < sURLVariables.length; i++) {
                    sParameterName = sURLVariables[i].split('=');

                    if (sParameterName[0] === sParam) {
                        return sParameterName[1] === undefined ? true : sParameterName[1];
                    }
                }
            };
            var report_date = getUrlParameter('dates');
            myString = report_date.split('+-+').join('/');
            var result = myString.split('/');
            
            var enableTodayDateForCallList = document.getElementById('enable_today_date').value;

            let ranges = {};

            if (enableTodayDateForCallList !== '1') {
                ranges['All Data'] = ['2020-01-01', moment()];
            }

            ranges['Today'] = [moment(), moment()];
            ranges['Yesterday'] = [moment().subtract(1, 'days'), moment().subtract(1, 'days')];
            ranges['Day before yesterday'] = [moment().subtract(2, 'days'), moment().subtract(2, 'days')];
            ranges['Last 7 Days'] = [moment().subtract(6, 'days'), moment()];
            ranges['Last 30 Days'] = [moment().subtract(29, 'days'), moment()];
            ranges['This Month'] = [moment().startOf('month'), moment().endOf('month')];
            ranges['Last Month'] = [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')];
            ranges['Last 6 Months'] = [moment().subtract(5, 'month'), moment()];

            $('#reportrange').daterangepicker({
                startDate: result[0],
                endDate: result[1],
                ranges: ranges,
                locale: {
                    format: 'Y-M-DD'
                }
            });
        });
        $(document).on('click', '.submit-filters', function(e) {
            e.preventDefault()
            let data_type = $(this).data('type');
            $('#data_type').val(data_type);
            $('#filter_form').submit();
        });
        $(document).on('click', '#print', function() {
            $('#accordion').hide();
            $("#print_ariea").show();
            window.print();
            $('#accordion').show();
        });
    </script>
@endsection