@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">মহাজন লেজার</p>
        <div class="grid grid-cols-1 mt-2 text-center px-4">
            <div class="col-span-1 py-1">
                <h1 class="text-base font-bold text-red-600">মহাজনের নাম : {{$mohajon_setup->name}}</h1>
            </div>
            <div class="col-span-1 py-1">
                <h1 class="text-base font-bold text-red-600">মহাজনের ঠিকানা : {{$mohajon_setup->address}}</h1>
            </div>
            <div class="col-span-1 py-1">
                <h1 class="text-base font-bold text-red-600">মহাজনের এরিয়া : {{$mohajon_setup->area}}</h1>
            </div>
            <div class="col-span-1 py-1">
                <h1 class="text-base font-bold text-red-600">মহাজনের মোবাইল : {{$mohajon_setup->mobile}}</h1>
            </div>
            <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>
        
        <table id="table" class="w-full text-sm text-center text-gray-500 data-table ">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <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
                $total = 0;
                $total_joma = 0;
                $total_khoroc = 0;
                $count = 1;
                @endphp

                @if($mohajon_setup)
                @php
                $total += $old_amount;
                @endphp
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="10" class="px-2 py-3 text-right">সাবেক দেনা :</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600 ">{{ floatval($total) }}</td>
                </tr>
                @endif

                @if($record)
                @foreach($record as $data)
                @php
                if($data['table'] != 2)
                {
                    $total_joma += $data['joma'];
                }
                else
                {
                    $total_khoroc += $data['khoroc'];
                }

                @endphp
                <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-center">
                    <td class="px-2 py-3">{{ $count++ }}</td>
                    <td class="px-2 py-3">{{ $data['entry_date'] }}</td>
                    @if($data['table'] == 1)
                    <td class="px-2 py-3 font-bold text-blue-700 "><a href="{{route('ponno_purchase_report.memo',$data['id'])}}" class="url" onclick="return false;">{{ $data['id'] }}</a></td>
                    @elseif($data['table'] == 4)
                    <td class="px-2 py-3 font-bold text-blue-700 "><a href="{{route('arod_chotha.memo',$data['id'])}}" class="url" onclick="return false;">{{ $data['id'] }}</a></td>
                    @else
                    <td class="px-2 py-3">{{ $data['id'] }}</td>
                    @endif
                    <td class="px-2 py-3">{{ $data['reference'] }}</td>
                    <td class="px-2 py-3">{{ $data['mohajon_owner'] }}</td>
                    <td class="px-2 py-3">{{ $data['ponno_info'] }}</td>
                    <td class="px-2 py-3">{{ $data['payment'] }}</td>
                    <td class="px-2 py-3">{{ $data['mohajon_bank'] }}</td>
                    <td class="px-2 py-3">{{ $data['marfot'] }}</td>
                    <td class="px-2 py-3">{{ is_numeric($data['joma']) ? number_format($data['joma'], 2) : $data['joma'] }}</td>
                    <td class="px-2 py-3">{{ is_numeric($data['khoroc']) ? number_format($data['khoroc'], 2) : $data['khoroc'] }}</td>
                    @if($data['table'] != 2)
                        @php
                        $total += is_numeric($data['joma']) ? $data['joma'] : 0;
                        @endphp
                        <td class="px-2 py-3">{{ number_format($total, 2) }}</td>
                    @else
                        @php
                        $total -= is_numeric($data['khoroc']) ? $data['khoroc'] : 0;
                        @endphp
                        <td class="px-2 py-3">{{ number_format($total, 2) }}</td>
                    @endif
                </tr>

                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="9" class="px-2 py-3 text-sm font-bold text-red-600 text-center">মোট</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{number_format($total_joma,2)}}</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600">{{number_format($total_khoroc,2)}}</td>
                    <td class="px-2 py-3 text-sm font-bold text-red-600"></td>
                </tr>
                @endif
            </tbody>
            
        </table>
    </div>


    <style>
        tr:nth-last-child(2) td:last-child {
            color: orangered;
            font-weight: bold;
            font-size: 1rem;
        }
        @page { 
            size:210mm 297mm; 
            margin: 0;
        }
    </style>
    <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=' + '800' +
                ', height=' + '700' + ', top=' +
                top + ', left=' + left);
        })
    </script>

@endsection