@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

      @php 
        $total_amount = 0;
        if($cash_transfer)
        {
            $total_amount += $cash_transfer->amount; 
        }
      @endphp

    <div class="xl:w-10/12 lg:w-11/12 w-full mx-auto p-4 relative overflow-x-auto  sm:rounded-lg bg-white mb-2">
        <p class="text-xl uppercase w-[90%] py-3 font-bold text-center pl-4 barlow text-blue-800">ক্যাশ জমা রিপোর্ট</p>
        <p class="text-xl uppercase w-[90%] py-3 font-bold text-center pl-4 barlow text-blue-600">তারিখ : {{$search_date}}</p>
        @if($cash_transfer)
        <p class="text-xl uppercase w-[90%] py-3 font-bold text-center pl-4 barlow text-blue-600">সাবেক ক্যাশ :@if($cash_transfer) {{$cash_transfer->amount}} টাকা / {{date('d-m-Y',strtotime($cash_transfer->reference_date))}} @endif</p>
        @endif
        <div class="w-full p-2">
        <hr>
        </div>
    </div>

    <!-- নগদ বিক্রয় টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                
                @if($cash_sales)
                    @php
                    $total = 0;
                    $total_bank = 0;
                    $count = 1;
                    @endphp
                @foreach($cash_sales as $v)
                    @php
                    $total += $v->total_taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3 font-bold text-blue-700"><a class="url" onclick="return false;" href="{{route('ponno_sales_report.memo',$v->id)}}">{{$v->id}}</a></td>
                        <td class="px-2 py-3">@if($v->sales_type == 1) নগদ @elseif($v->sales_type == 2) বাকি @endif</td>
                        @if($v->sales_type == 2)
                        <td class="px-2 py-3">{{$v->kreta_setup->address}}</td>
                        <td class="px-2 py-3">{{$v->kreta_setup->name}}</td>
                        @else
                        <td class="px-2 py-3">{{$v->cash_kreta_address}}</td>
                        <td class="px-2 py-3">{{$v->cash_kreta_name}}</td>
                        @endif
                        <td class="px-2 py-3">{{$v->bikroy_marfot_setup->marfot_name}}</td>
                        <td class="px-2 py-3">{{$v->total_taka}}</td>
                    </tr>
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="6" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- ব্যাংক উত্তোলন টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-xs">
                    <th>
                        নং
                    </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">
                
                @if($bank_uttolon)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($bank_uttolon as $v)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-xs">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->bank_setup->bank_name }}</td>
                        <td class="px-2 py-3">{{ $v->bank_setup->account_name }}</td>
                        <td class="px-2 py-3">{{ $v->bank_setup->account_no }}</td>
                        <td class="px-2 py-3">{{ $v->bank_setup->shakha }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                @endforeach

                @foreach($mohajon_payment as $v)
                    @if($v->payment_by == 2)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-xs">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">মহাজন পেমেন্ট</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->area }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">-</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                @endforeach

                @foreach($amanot as $v)
                    @if($v->payment_by == 2)
                    @if($v->type == 2)
                    <!-- amanot khoroc -->
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-xs">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td colspan="2" class="px-2 py-3">আমানত/হাওলাত খরচ</td>
                        <td class="px-2 py-3">{{ $v->amanot_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->amanot_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                    @endif
                @endforeach

                {{-- 
                @foreach($hawlat as $v)
                @if($v->payment_by == 2)
                @if($v->type == 2)
                    <!-- hawlat khoroc -->
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-xs">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td colspan="2" class="px-2 py-3">হাওলাত খরচ</td>
                        <td class="px-2 py-3">{{ $v->hawlat_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->hawlat_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                    @endif
                @endforeach
                --}}

                @foreach($other as $v)
                    @if($v->payment_by == 2)
                    @if($v->type == 2)
                    <!-- other khoroc -->
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-xs">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td colspan="2" class="px-2 py-3">অন্যান্য খরচ</td>
                        <td colspan="2" class="px-2 py-3">{{ $v->other_joma_khoroc_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                    @endif
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="9" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- ক্রেতা জমা টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                
                @if($kreta_joma)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($kreta_joma as $v)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->kreta_setup->area }}</td>
                        <td class="px-2 py-3">{{ $v->kreta_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->kreta_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="7" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- মহাজন কৈফিয়ত টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                
                @if($mohajon_koifiyot)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($mohajon_koifiyot as $v)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->area }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->name }}</td>
                        <td class="px-2 py-3">{{ $v->description }}</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="6" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- ক্রেতা কৈফিয়ত টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                
                @if($kreta_koifiyot)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($kreta_koifiyot as $v)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->kreta_setup->area }}</td>
                        <td class="px-2 py-3">{{ $v->kreta_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->kreta_setup->name }}</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="5" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- মহাজন ফেরত টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                
                @if($mohajon_return)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($mohajon_return as $v)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->area }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->mohajon_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="7" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- আমানত জমা টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                

                @if($amanot)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($amanot as $v)
                    @if($v->type == 1)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->amanot_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->amanot_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="7" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <!-- হাওলাত জমা টেবিল -->

    {{-- 
    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                

                @if($hawlat)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($hawlat as $v)
                @if($v->type == 1)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->hawlat_setup->address }}</td>
                        <td class="px-2 py-3">{{ $v->hawlat_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="7" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    --}}

    <!-- অন্যান্য জমা টেবিল -->

    <div class="xl:w-10/12 lg:w-11/12 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>
        
        <table id="table" class="w-full text-sm text-left text-gray-500 data-table">
            <thead class="text-xs text-gray-700 uppercase bg-gray-50 ">
                <tr class="border border-collapse text-base">
                    <th>
                        নং
                    </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">
                

                @if($other)
                    @php
                    $total = 0;
                    $count = 1;
                    @endphp
                @foreach($other as $v)
                    @if($v->type == 1)
                    @php
                    $total += $v->taka;
                    @endphp
                    <tr class="border border-collapse odd:bg-white even:bg-gray-100 text-base">
                        <td class="px-2 py-3">{{ $count++ }}</td>
                        <td class="px-2 py-3">{{ $v->other_joma_khoroc_setup->name }}</td>
                        <td class="px-2 py-3">@if($v->payment_by == 1) ক্যাশ @else ব্যাংক @endif</td>
                        <td class="px-2 py-3">@if($v->bank_setup_id == "" or null) - @else {{$v->bank_setup->bank_name .'/'.$v->bank_setup->account_name}} @endif</td>
                        <td class="px-2 py-3">@if($v->check_id == null or "") - @else {{$v->check_book_page_setup->page}} @endif</td>
                        <td class="px-2 py-3">{{ $v->marfot }}</td>
                        <td class="px-2 py-3">{{ $v->taka }}</td>
                    </tr>
                    @endif
                @endforeach
                <tr class="border border-collapse odd:bg-white even:bg-gray-100">
                    <td colspan="6" class="px-2 py-3 text-base font-bold text-red-600 text-center">মোট টাকা : </td>
                    <td class="px-2 py-3 text-base font-bold text-red-600 text-left">{{$total}}</td>
                </tr>
                @php
                $total_amount +=$total;
                @endphp
                @endif
            </tbody>
            
        </table>
    </div>

    <div class="xl:w-10/12 lg:w-11/12 w-full mx-auto p-4 relative overflow-x-auto  sm:rounded-lg bg-white mb-6">
        <h1 class="text-2xl font-bold text-green-700">সর্বমোট জমা : {{$total_amount}}</h1>
    </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=' + '400' +
                ', height=' + '700' + ', top=' +
                top + ', left=' + left);
        })
    </script>

@endsection