@extends('master.app')
@section('title', 'customer')
@section('pageCSS')
    <style id="table_style">
        table {
            width: 100%;
            border-collapse: collapse;
            margin: auto;
            border: 0.2px solid black;
        }

        td,
        th {
            border: 0.5px solid black;
            text-align: center;
        }

        td {
            font-size: 11px;
            padding: 0px;

            height: 15px;
            text-align: center;
        }

        th {
            font-size: 12px;
            width: 300px;
        }

        .report-logo {
            margin-left: 480px;
            height: 100px;
            width: 100px;
            padding-top: 0px;
            margin-bottom: 0px;
        }

        h6 {
            padding: 0px;
            margin: 0px;
        }

        p {
            padding: 0px;
            margin: 0px;
        }
    </style>
@endsection
@section('body')
    <main class="app-content">
        <section class="">
            <div class="">
                <div class="card">
                    <div class="card-body">
                        <div class="row g-0">
                            <div class="col-md-12">
                                <div class="row pt-1">
                                    <div class="col-md-9">
                                        <h5>Rural Rehabilitation and Development Program Organization</h5>
                                        <h6>{{ $data->name . ' ' . $data->code }}</h6>
                                        <h6>{{ $data->location }}</h6>
                                    </div>
                                    <div class="col-md-3">
                                        <strong>Start Date: {{ $data->start_date }}</strong><br>
                                        <strong>End Date: {{ $data->start_date }}</strong><br>
                                        <strong>Deadline Date: {{ $data->start_date }}</strong><br>
                                        <strong>Approved Budget: {{ $data->approved_budget }}</strong><br>
                                        <strong>Estimation Budget: {{ $data->estimation_budget }}</strong><br>
                                    </div>
                                </div>

                                <div class="row mt-2">
                                    <div class="col-md-12">
                                        <table id="table" class="">
                                            <tr>
                                                <th rowspan="2">Account Name</th>
                                                <th colspan="{{ $currencies->count() }}">VALUES</th>
                                            </tr>
                                            <tr>
                                                @foreach ($currencies as $row)
                                                    <td style="background: #000; color:#fff;">
                                                        {{ $row->title_en }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Purchase/حریداری <a href="" target="__blank"><i
                                                            class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $purchase->where('currency_id', $row->id)->sum('grand_total') }}

                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Purchase Payment/تادیه حریداری <a href="" target="__blank"><i
                                                            class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $payment->where('currency_id', $row->id)->sum('amount') }}

                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Expences/مصارف<a href="" target="__blank"><i
                                                            class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $expencies->where('currency_id', $row->id)->sum('amount') }}

                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Stuff Overtime MT/کارمندانو اضافه کاری<a href=""
                                                        target="__blank"><i class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $overtimes->where('currency_id', $row->id)->where('type_id', 1)->sum('amount') }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Stuff Overtime None MT/کارمندانو اضافه کاری<a href=""
                                                        target="__blank"><i class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $overtimes->where('currency_id', $row->id)->where('type_id', 2)->sum('amount') }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Stuff Advance MT/کارمندانو  پیشکی<a href=""
                                                        target="__blank"><i class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $advances->where('currency_id', $row->id)->where('type_id', 1)->sum('payment') }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Stuff Advance None MT/کارمندانو  پیشکی<a href=""
                                                        target="__blank"><i class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $advances->where('currency_id', $row->id)->where('type_id', 2)->sum('payment') }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Stuff Salary MT/کارمندانو تنخوا<a href="" target="__blank"><i
                                                            class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $salaries->where('currency_id', $row->id)->where('type_id', 1)->sum('net_salary') }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                <th>Stuff Salary None MT/کارمندانو تنخوا<a href=""
                                                        target="__blank"><i class="fa fa-eye"></i></a></th>
                                                @foreach ($currencies as $row)
                                                    <td>
                                                        {{ $salaries->where('currency_id', $row->id)->where('type_id', 2)->sum('net_salary') }}
                                                    </td>
                                                @endforeach
                                            </tr>

                                        </table>
                                    </div>
                                </div>


                            </div>
                        </div>

                    </div>
                </div>
        </section>
    </main>
@endsection


@section('pageJs')
    <script type="text/javascript">
        $(".app-menu").removeClass("active");
        $("#nav_salei").addClass("active");
        $("#salei").addClass("is-expanded");
        $("#customer_add").addClass("active");
    </script>
@endsection