@extends('user.layout.report_layout')
@section('report_body')

<div class=" mx-auto max-w-screen ">
    <div class="p-4 px-4 mb-6 text-center bg-white md:p-8">
    @component('components.project_headline')
    @endcomponent

        <div class=" w-full mx-auto p-4 relative overflow-x-auto  sm:rounded-lg bg-white mb-6">
            <p class="text-xl uppercase w-[90%] py-3 font-bold text-center pl-4 barlow text-green-800">বিক্রয় রিপোর্ট @if($sales_type == 1)(নগদ)@elseif($sales_type == 2)(বাকি)@endif</p>
            <div class="grid grid-cols-2 mt-2 text-center px-4">
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">তারিখ শুরু : {{$request->date_from}}</h1>
                </div>
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">তারিখ শেষ : {{$request->date_to}}</h1>
                </div>
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">রিপোর্টের ধরন : {{$request->report_type == 3 ? 'পন্য (ইনভোয়েস)' : 'পন্য'}}</h1>
                </div>
                <div class="col-span-1 py-1">
                    <h1 class="text-base font-bold text-red-600">বিক্রির ধরন : {{ SalesType($request->sales_type) }}</h1>
                </div>
            </div>

            <table id="sales-table" class="w-full text-sm text-left text-gray-500 data-table">
                @if($sales)
                <thead class="text-xs text-gray-700 uppercase bg-gray-50 dark:bg-gray-700 dark:text-gray-400">
                    <tr class="border border-collapse">
                        <th scope="col" class="px-2 py-3">
                            ইনভয়েস
                        </th>
                        <th scope="col" class="px-2 py-3">
                            ধরণ
                        </th>
                        <th scope="col" class="px-2 py-3">
                            এরিয়া
                        </th>
                        <th scope="col" class="px-2 py-3">
                            ঠিকানা
                        </th>
                        <th scope="col" class="px-2 py-3">
                            ক্রেতার নাম
                        </th>
                        <th scope="col" class="px-2 py-3">
                            ছাড়
                        </th>
                        <th scope="col" class="px-2 py-3">
                            মারফত
                        </th>
                        <th scope="col" class="px-2 py-3">
                            মোট সংখ্যা
                        </th>
                        <th scope="col" class="px-2 py-3">
                            মোট ওজন
                        </th>
                        <th scope="col" class="px-2 py-3">
                            মোট টাকা
                        </th>
                        <th scope="col" class="px-2 py-3">
                            ম্যানুয়াল চৌথা নং
                        </th>
                        <th scope="col" class="px-2 py-3">
                            তারিখ
                        </th>
                    </tr>
                </thead>
                <tbody id="table_body">
                    @php
                    $countRow = count($sales);
                    $total_qty = 0;
                    $total_weight = 0;
                    $total = 0;
                    @endphp
                    @if($countRow > 0)
                    @foreach($sales as $s)
                    <tr class="border border-collapse">
                        <td class="px-6 py-3 font-bold text-blue-700"><a class="url" onclick="return false;" href="{{route('ponno_sales_report.memo',$s->id)}}">{{$s->id}}</a></td>
                        <td class="px-6 py-3">@if($s->sales_type == 1) নগদ @elseif($s->sales_type == 2) বাকি @endif</td>
                        @if($s->sales_type == 2)
                        <td class="px-6 py-3">{{$s->kreta_setup->area}}</td>
                        <td class="px-6 py-3">{{$s->kreta_setup->address}}</td>
                        <td class="px-6 py-3">{{$s->kreta_setup->name}}</td>
                        @else
                        <td class="px-6 py-3">-</td>
                        <td class="px-6 py-3">{{$s->cash_kreta_address}}</td>
                        <td class="px-6 py-3">{{$s->cash_kreta_name}}</td>
                        @endif
                        <td class="px-6 py-3">{{$s->discount}}</td>
                        <td class="px-6 py-3">{{$s->bikroy_marfot_setup->marfot_name}}</td>
                        <td class="px-6 py-3">{{$s->ponno_sales_entry->sum('sales_qty')}}</td>
                        <td class="px-6 py-3">{{$s->ponno_sales_entry->sum('sales_weight')}}</td>
                        <td class="px-6 py-3">{{$s->total_taka}}</td>
                        <td class="px-6 py-3">{{$s->description}}</td>
                        <td class="px-6 py-3">{{$s->entry_date}}</td>
                        @php
                        $total_qty += $s->ponno_sales_entry->sum('sales_qty');
                        $total_weight += $s->ponno_sales_entry->sum('sales_weight');
                        $total += $s->total_taka;
                        @endphp
                    </tr>
                    @endforeach
                    @endif
                </tbody>
                <tfoot>
                    <tr class="border border-collapse">
                        <td class="px-6 py-3 font-bold text-red-700 text-center" colspan="7">মোট</td>
                        <td class="px-6 py-3 font-bold text-red-700">{{ number_format($total_qty) }}</td>
                        <td class="px-6 py-3 font-bold text-red-700">{{ number_format($total_weight) }}</td>
                        <td class="px-6 py-3 font-bold text-red-700">{{ number_format($total) }}</td>
                        <td class="px-6 py-3"></td>
                        <td class="px-6 py-3"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <script>
            $('.url').click(function() {
                var left = (screen.width - 800) / 2;
                var top = (screen.height - 700) / 4;

                var url = $(this).attr('href');

                var myWindow = window.open(url, url,
                    'resizable=yes, width=' + '600' +
                    ', height=' + '1200' + ', top=' +
                    top + ', left=' + left);
            })

            $('#sales-table').DataTable({
                "paging": true,
                "searching": true,
                "ordering": true,
                "info": true,
                "language": {
                    "emptyTable": "ডাটা পাওয়া যায়নি",
                    "search": "সার্চ করুন : ",
                    "info": "",
                    "infoEmpty": "",
                    "infoFiltered": "",
                    "lengthMenu": "_MENU_টি এন্ট্রি দেখুন",
                    "loadingRecords": "লোড হচ্ছে...",
                    "zeroRecords": "রেকর্ড পাওয়া যায়নি",
                    "paginate": {
                        "first": "প্রথম",
                        "last": "শেষ",
                        "next": "পরবর্তি",
                        "previous": "পুর্বে"
                    },
                },
            });
        </script>
        @endif
        
@endsection