@extends('layouts.admin')

@section('title' , 'Company Product Report')

@section('breadcrumb-item')
    <li class="breadcrumb-item active">Margin Product Report</li>
@endsection

@section('styles')
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
    <link href="https://unpkg.com/gijgo@1.9.13/css/gijgo.min.css" rel="stylesheet" type="text/css" />
@endsection

@section('content')
    <div class="card">
        <div class="card-header bg-theme">
            <p class="h5 pt-2 mb-0 float-left"><i class="fa fa-list pr-1"></i>Margin Product Report</p>
        </div>
    </div>

    <div class="card-body" style="overflow-x: auto">
        <form action="{{ route('admin.reports.company-product-margin-search') }}" method="POST">
            @csrf
            <div class="row">
                <div class="col-3">
                    <div class="form-group">
                        <label>Companies</label>
                        <select class="form-control js-example-theme-multiple" name="company_names[]" multiple>
                            @foreach(_companies() as $company_name)
                                <option value="{{ $company_name }}"
                                    {{ isset($company_names) && in_array($company_name, $company_names) ? 'selected' : '' }}>
                                    {{ $company_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-3">
                    <div class="form-group">
                        <label>Shops</label>
                        <select class="form-control js-example-theme-multiple" name="shop_ids[]" multiple>
                            @foreach(_shops() as $shop)
                                <option value="{{ $shop->id }}"
                                    {{ isset($shop_ids) && in_array($shop->id, $shop_ids) ? 'selected' : '' }}>
                                    {{ $shop->name }} [{{$shop->area ? $shop->area->name : ""}}]  [{{ $shop->id }}]
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-2">
                    <div class="form-group">
                        <label>Status</label>
                        <select class="form-control" name="order_status">
                            <option value="">All</option>
                            @foreach($statuses as $key => $value)
                                <option value="{{ $value }}"
                                    {{ isset($order_status) ? $order_status == $value ? 'selected' : '' : '' }}>
                                    {{ $key }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-2">
                    <div class="form-group">
                        <label>Start Date</label>
                        <input id="datepicker1" name="start_date" value="{{ request()->start_date ?? date('Y-m-d') }}" />
                    </div>
                </div>
                <div class="col-2">
                    <div class="form-group">
                        <label>End Date</label>
                        <input id="datepicker2" name="end_date" value="{{ request()->end_date ?? date('Y-m-d') }}" />
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-3">
                    <div class="form-group">
                        <label>Employees</label>
                        <select class="form-control js-example-theme-multiple" name="employee_ids[]" multiple>
                            @foreach(_employees() as $employee)
                                <option value="{{ $employee->id }}"
                                    {{ isset($employee_ids) && in_array($employee->id, $employee_ids) ? 'selected' : '' }}>
                                    {{ $employee->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>

                <div class="col-3">
                    <div class="form-group">
                        <label>Areas</label>
                        <select class="form-control js-example-theme-multiple" name="area_ids[]" multiple>
                            @foreach(_areas() as $area)
                                <option value="{{ $area->id }}"
                                    {{ isset($area_ids) && in_array($area->id, $area_ids) ? 'selected' : '' }}>
                                    {{ $area->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-3">
                    <div class="form-group">
                        <label>Products</label>
                        <select class="form-control js-example-theme-multiple" name="product_ids[]" multiple>
                            @foreach(_products() as $product)
                                <option value="{{ $product->id }}"
                                    {{ isset($product_ids) && in_array($product->id, $product_ids) ? 'selected' : '' }}>
                                    {{ $product->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
            </div>
            <br />
            <div class="row mt-4">
                <div class="col-md-12 text-center">
                    <button type="submit" class="btn btn-sm btn-success col-md-3 search-btn" onclick="saveSelections()">
                        Search
                    </button>
                    <a href="{{ route('admin.reports.company-product-margin') }}">
                        <button type="button" class="btn btn-sm btn-success col-md-3">
                            Reload
                        </button>
                    </a>
                </div>
            </div>
        </form>

        <div class="print_content">

            <div class="header">
                <table>
                    <thead>
                    <td></td>
                    </thead>
                </table>
            </div>

            <div class="summary-header text-center mt-4 mb-4">
                <h4>Grand Product Report</h4>
                <table class="printFontSize table table-bordered">
                    <tr>
                        <td><b>Company Name</b></td>
                        <td><b><span id="company"></span></b></td>
                    </tr>
                    <tr>
                        <td><b>Booker Name</b></td>
                        <td><b><span id="employee"></span></b></td>
                    </tr>
                    <tr>
                        <td><b>Start Date</b></td>
                        <td><b><span id="start_date"></span></b></td>
                    </tr>
                    <tr>
                        <td><b>End Date</b></td>
                        <td><b><span id="end_date"></span></b></td>
                    </tr>
                </table>
            </div>

            <table class="printFontSize table table-hover">
                <tbody>
                @foreach($result['summery'] ?? [] as $company_name => $products)
                    <tr>
                        <td colspan="3" class="text-center">
                            <b>{{ empty($company_name) ? 'No Company' : $company_name }}</b>
                        </td>
                        <td></td>
                    </tr>
                    <tr>
                        <td><b>#</b></td>
                        <td><b>Product Name</b></td>
                        <td><b>Distributor Price</b></td>
                        <td><b>Cost Price</b></td>
                        <td><b>Sales Tax</b></td>
                        <td><b>Additional Sales Tax</b></td>
                        <td><b>Total Price</b></td>
                        <td><b>Sale Qty</b></td>
                        <td><b>Bonus</b></td>
                        <td><b>Total Qty</b></td>
                        <td><b>Cost Amount</b></td>
                        <td><b>Amount</b></td>
                        <td><b>Margin %</b></td>
                        <td><b>Margin</b></td>
                    </tr>
                    @if($products['records'] ?? '')
                        @foreach($products['records'] as $product)
                            <tr>
                                <td>{{ $loop->iteration }}</td>
                                <td>{{ $product['product_name'] }}</td>
                                <td>{{ $product['price'] }}</td>
                                <td>{{ $product['cost_price'] }}</td>
                                <td>{{ $product['sale_tax'] ?? 0 }}</td>
                                <td>{{ $product['additional_sale_tax'] ?? 0 }}</td>
                                <td>{{ $product['price'] + ($product['sale_tax'] ?? 0) + ($product['additional_sale_tax'] ?? 0) }}</td>
                                <td>{{ $product['quantity'] }}</td>
                                <td>{{ $product['bonus'] }}</td>
                                <td>{{ $product['bonus'] + $product['quantity'] }}</td>
                                <td>{{ $product['cost_amount'] }}</td>
                                <td>{{ $product['amount'] }}</td>
                                <td>{{ round((($product['amount'] - $product['cost_amount']) / $product['cost_amount']) * 100, 2) }}%</td>
                                @if($product['margin_amount'] >= 0)
                                    <td class="btn-success">{{ $product['margin_amount'] }}</td>
                                @else
                                    <td class="btn-danger">{{ $product['margin_amount'] }}</td>
                                @endif
                            </tr>
                        @endforeach
                    @endif

                    <tr>
                        <td colspan="4"><b>Total</b></td>
                        <td colspan="4"><b>Qty: {{ $products['quantity_total'] }}</b></td>
                        <td><b>Cost Amount: {{ $products['cost_amount_total'] }}</b></td>
                        <td><b>Amount: {{ $products['amount_total'] }}</b></td>
                    </tr>
                @endforeach
                </tbody>
            </table>

            <div class="report-header text-center mt-4 mb-4">
                <h4>Product Report</h4>
            </div>

            <div class="row">
                <div class="col-12">
                    <table class="printFontSize table table-bordered">
                        <tr>
                            <td><b>Grand Total:</b></td>
                            <td><b>{{ $result['grand_total'] ?? 0 }}</b></td>
                        </tr>
                        <tr>
                            <td><b>Grand Quantity Total:</b></td>
                            <td><b>{{ $result['grand_quantity_total'] ?? 0  }}</b></td>
                        </tr>
                        <tr>
                            <td><b>Grand Margin Total:</b></td>
                            <td><b>{{ $result['grand_margin_amount_total'] ?? 0  }}</b></td>
                        </tr>
                    </table>
                </div>
            </div>

            <br>

            <table class="printFontSize table table-hover">
                <tbody>
                @forelse ($result['dates'] ?? [] as $date => $records)
                    <tr>
                        <td colspan="3" class=" text-center">
                            <b>{{ $date }}</b>
                        </td>
                        <td></td>
                    </tr>
                    @if($records['records'] ?? '')
                        @foreach($records['records'] as $company_name => $products)
                            <tr>
                                <td colspan="3" class="text-center">
                                    <b>{{ empty($company_name) ? 'No Company' : $company_name }}</b>
                                </td>
                                <td></td>
                            </tr>
                            <tr>
                                <td><b>#</b></td>
                                <td><b>Product Name</b></td>
                                <td><b>Distributor Price</b></td>
                                <td><b>Cost Price</b></td>
                                <td><b>Sales Tax</b></td>
                                <td><b>Additional Sales Tax</b></td>
                                <td><b>Total Price</b></td>
                                <td><b>Sale Qty</b></td>
                                <td><b>Bonus</b></td>
                                <td><b>Total Qty</b></td>
                                <td><b>Cost Amount</b></td>
                                <td><b>Amount</b></td>
                                <td><b>Margin %</b></td>
                                <td><b>Margin</b></td>
                            </tr>
                            @foreach($products as $product)
                                <tr>
                                    <td> {{ $loop->iteration }}</td>
                                    <td>{{ $product['product_name'] }}</td>
                                    <td >{{$product['price']}}</td>
                                    <td >{{$product['cost_price'] ?? $product['price']}}</td>
                                    <td>{{ $product['sale_tax'] ?? 0 }}</td>
                                    <td>{{ $product['additional_sale_tax'] ?? 0 }}</td>
                                    <td>{{ $product['price'] + ($product['sale_tax'] ?? 0) + ($product['additional_sale_tax'] ?? 0) }}</td>
                                    <td>{{ $product['quantity'] }}</td>
                                    <td>{{ $product['bonus'] }}</td>
                                    <td>{{ $product['bonus'] + $product['quantity'] }}</td>
                                    <td>{{ $product['cost_amount'] }}</td>
                                    <td>{{ $product['amount'] }}</td>
                                    <td>{{ round((($product['amount'] - $product['cost_amount']) / $product['cost_amount']) * 100, 2) }}%</td>
                                    @if($product['margin_amount'] >= 0)
                                        <td class="btn-success">{{ $product['margin_amount'] }}</td>
                                    @else
                                        <td class="btn-danger">{{ $product['margin_amount'] }}</td>
                                    @endif
                                </tr>
                            @endforeach
                            <tr>
                                <td colspan="2"><b>Total</b></td>
                                <td colspan="2"><b> Qty: {{ $records['total'][$company_name]['quantity'] ?? '' }}</b></td>
                                <td><b>Amount: {{ $records['total'][$company_name]['amount'] ?? '' }}</b></td>
                            </tr>
                        @endforeach
                    @endif
                @empty
                    <tr>
                        <td class="text-center">
                            No records found
                        </td>
                    </tr>
                @endforelse
                </tbody>
            </table>
        </div>

    </div>
@endsection

@section('scripts')
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="https://unpkg.com/gijgo@1.9.13/js/gijgo.min.js" type="text/javascript"></script>

    <script>
        $(document).ready(function() {
            $('.js-example-theme-multiple').select2({
                theme: 'classic',

            });

            $('#datepicker1').datepicker({
                format: 'yyyy-mm-dd',
                uiLibrary: 'bootstrap4',
            });

            $('#datepicker2').datepicker({
                format: 'yyyy-mm-dd',
                uiLibrary: 'bootstrap4',
            });
        });
        function displaySelectedDates() {
            let startDate = document.getElementById('datepicker1').value;
            let endDate = document.getElementById('datepicker2').value;
            document.getElementById('start_date').textContent = startDate ? startDate : 'No Start Date Selected';
            document.getElementById('end_date').textContent = endDate ? endDate : 'No End Date Selected';
        }
        window.onload = function() {
            displaySelectedDates();
        };
        document.getElementById('start_date').addEventListener('change', displaySelectedDates);
        document.getElementById('end_date').addEventListener('change', displaySelectedDates);


        function saveSelections() {
            let selectedCompanies = [];
            let selectedEmployees = [];

            let companyOptions = document.querySelectorAll('select[name="company_names[]"] option:checked');
            companyOptions.forEach(function(option) {
                selectedCompanies.push(option.textContent);
            });

            let employeeOptions = document.querySelectorAll('select[name="employee_ids[]"] option:checked');
            employeeOptions.forEach(function(option) {
                selectedEmployees.push(option.textContent);
            });

            sessionStorage.setItem('selectedCompanies', JSON.stringify(selectedCompanies));
            sessionStorage.setItem('selectedEmployees', JSON.stringify(selectedEmployees));
        }

        $(document).on('click', '.search-btn', function() {
            saveSelections();
        });

        function loadSelections() {
            let companies = JSON.parse(sessionStorage.getItem('selectedCompanies')) || [];
            let employees = JSON.parse(sessionStorage.getItem('selectedEmployees')) || [];

            let selectedCompanyElement = document.getElementById('company');
            selectedCompanyElement.textContent = companies.length > 0 ? companies.join(',') : 'No Company Selected';

            let selectedEmployeeElement = document.getElementById('employee');
            selectedEmployeeElement.textContent = employees.length > 0 ? employees.join(',') : 'No Booker Name Selected';
        }

        $(document).ready(function() {
            loadSelections();
        });

        $(document).on('click', '.print-btn', function() {
            let printContents = document.querySelector('.print_content').innerHTML;
            let wholecontentbody = document.querySelector('.print_content').offsetHeight
            let wholecontentbody1 = document.querySelector('.report-header').clientHeight
            let wholecontentbody2 = document.querySelector('.print_content').scrollHeight
            console.log(wholecontentbody)
            console.log(wholecontentbody1)
            console.log(wholecontentbody2)
            console.log((wholecontentbody2 + wholecontentbody1) / 1587)

            let pageheight1 = document.body.clientHeight
            console.log(pageheight1)
            let pages = ((wholecontentbody2 + wholecontentbody1) / 1587);
            if (pages % 1 == 0) {

            } else {

                pages = (parseInt(pages.toString().split(".")[0]) + 1)
            }

            let pageheight = (pages * 100) - 20
            pageheight = pageheight.toString() + "vh"
            // document.getElementById("div_con_change").style.height = pageheight

            let printWindow = window.open('', '_blank');
            printWindow.document.write('<html><head><title>Print</title>');
            printWindow.document.write('<link rel="stylesheet" type="text/css" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">');
            printWindow.document.write('</head><body>');
            printWindow.document.write(printContents);
            printWindow.document.write('</body></html>');
            printWindow.document.close();
            function printContent() {
                printWindow.print();
                printWindow.close();
            }
            setTimeout(printContent, 1000);
        });

    </script>
@endsection