@extends('dashboard.components.main')
@section('content')
    <!-- ============================================================== -->
    <!-- Start right Content here -->
    <!-- ============================================================== -->
    <div class="main-content">
        <div class="page-content">
            <!-- start page title -->
            <div class="row">
                <div class="col-12">
                    <div class="page-title-box d-flex align-items-center justify-content-between">
                        <h4 class="page-title mb-0 font-size-18">@lang('dashboard_sidebar.taxes')</h4>
                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item active">@lang('dashboard.welcome') </li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>
            <!-- Errors -->
            @include('dashboard.components.errors')
            <!-- Success Message -->
            @if (session()->has('message'))
                <p class="alert alert-success text-center">
                    {{ session()->get('message') }}
                </p>
            @endif

            <!-- end page title -->
            <p class="text-center mb-4">
                @lang('reports.from') <b class="">{{ \Carbon\Carbon::parse($tax->start_date)->format('Y-m-d')}}</b> @lang('reports.to') <b class="">{{ \Carbon\Carbon::parse($tax->end_date)->format('Y-m-d')}}</b>

            </p>
            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <p class="col-lg-3">اجمالي المبيعات الخاضعة للضريبة</p>
                        <p class="col-lg-9 text-center text-dark">{{  $all_sales }} $</p>
                    </div>

                    
                </div>
            </div>

            <div class="card">
                <div class="card-body">
                    <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap"
                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                        <thead>
                            <tr>
                                <th data-priority="1">@lang('dashboard_sales_expenses.date')</th>
                                <th data-priority="3">@lang('dashboard_sales_expenses.movement_type')</th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.number') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.customer') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.due_date') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.balance') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.tax') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.total_before_tax') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.total_after_tax') </th>
                                
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($first_table_collection as $collection)
                                @foreach ($collection as $item)
                                    
                                <tr>
                                    
                                    <td>{{ $item->date }}</td>
                                    <td>{{ Str::upper($item->type)  }}</td>
                                    <td>{{ $item->number }}</td>
                                    <td>{{ $item->client }}</td>
                                    <td>{{ $item->due_date }}</td>
                                    <td>{{ $item->balance }}</td>
                                    <td>{{ $item->tax_value }}</td>
                                    <td>{{ $item->total_before_tax }}</td>
                                    <td>{{ $item->total }}</td>
                                </tr>
                                @endforeach
                                @endforeach
                               
                                
                        </tbody>
                    </table>
                </div>
            </div>
            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <p class="col-lg-3">مبلغ الضريبة المستحقة على المبيعات</p>
                        <p class="col-lg-9 text-center text-dark">{{ $all_required }}$</p>
                    </div>
                </div>
            </div>

            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <p class="col-lg-3">اجمالي المشتريات الخاضعة للضريبة</p>
                        <p class="col-lg-9 text-center text-dark">{{ $total_sales_include_tax }} $</p>
                    </div>
                </div>
            </div>
            <div class="card">
                <div class="card-body">
                    <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap"
                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                        <thead>
                            <tr>
                                <th data-priority="1">@lang('dashboard_sales_expenses.date')</th>
                                <th data-priority="3">@lang('dashboard_sales_expenses.movement_type')</th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.number') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.customer') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.due_date') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.balance') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.tax') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.total_before_tax') </th>
                                <th data-priority="1">@lang('dashboard_sales_expenses.total_after_tax') </th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($second_table_collection as $collection)
                            @foreach ($collection as $item)
                                
                            <tr>
                                
                                <td>{{ $item->date }}</td>
                                <td>{{ Str::upper($item->type)  }}</td>
                                <td>{{ $item->number }}</td>
                                <td>{{ $item->supplier }}</td>
                                <td>{{ $item->due_date }}</td>
                                <td>{{ $item->balance }}</td>
                                <td>{{ $item->tax_value }}</td>
                                <td>{{ $item->total_before_tax }}</td>
                                <td>{{ $item->total }}</td>
                            </tr>
                            @endforeach
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <p class="col-lg-3">مبلغ الضريبة المدفوعة عن المشتريات</p>
                        <p class="col-lg-9 text-center text-dark">{{ $total_cost_of_tax }} $</p>
                    </div>
                </div>
            </div>
            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <p class="col-lg-3">صافي الضريبة المستحقة للدفع للمؤسسة</p>
                        <p class="col-lg-9 text-center text-dark">{{ $all_required - $total_cost_of_tax }} $</p>
                    </div>
                </div>
            </div>
        </div>
    @endsection