@extends('layouts.admin')

@section('content')
    @push('css')
        <!-- Google Fonts -->
        <link rel="preconnect" href="https://fonts.googleapis.com">
        <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
        <link href="https://fonts.googleapis.com/css2?family=Lato:wght@400;700&display=swap" rel="stylesheet">
        <style>
            .incomedtls{
                color:red;
                text-align:center;
                text-decoration:underline;
                font-weight:bold;
            }
            .mbcom{
                text-decoration:underline;
                font-weight:bold;
                font-size: 14px !important;
            }
            thead{
                color:teal;
            }
            .subtoal{
                font-weight:bold;
                text-align:right;
            }
            .netamount{
                color:#44a2d2;
            }
            .name{
                line-height: .5;
            }
            hr{
                padding:0px;
            }
            .btnb{
                margin-left:135px;
            }
            form{
                display:flex;
            }
            .address-details p {
                margin-bottom: 0;
                font-size: 15px;
            }
            body {
                font-family: 'Lato', sans-serif !important;
            }

            .card-body.gfont {
                font-family: 'Lato', sans-serif;
            }

            .card-body.gfont h4, .card-body.gfont h5, .card-body.gfont h3 {
                font-weight: 600;
            }
            .table{
                text-transform: uppercase;
            }
            .table td {
                font-size: 13px;
                font-weight: bold;
            }
            .table th {
                font-size: 16px;
                font-weight: bold;
            }
            @media print
            {
                @foreach($user_data as $k => $user_id)
                @if($k > 0)
                .card-body .gfont{{$k}}  {page-break-before: always;}
                @endif
                @endforeach
            }
        </style>
    @endpush



    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-8 d-print-none" >

                                <form method="GET" action="{{ url()->current() }}">
                                    <div class="col-md-3">
                                        <div class="form-group ">
                                            <input class="form-control" required  type="text" name="trans_date_start" id="trans_date_start" placeholder="Start Date"  value="{{ old('trans_date_start')}}" autocomplete="off">
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group ">
                                            <input class="form-control" required type="text" name="trans_date_end" id="trans_date_end" placeholder="End Date"  value="{{ old('trans_date_end')}}" autocomplete="off">
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <select name="transaction_type[]" class="select2 form-control mb-3 custom-selec" required multiple>
                                                <option value="" disabled>Select Type</option>
                                                @foreach ($transaction_types as $transaction_type)
                                                    <option value="{{ $transaction_type->type }}" @if(old('transaction_type'))@foreach(old('transaction_type') as $t_type) @if($transaction_type->type == $t_type) selected @endif @endforeach @endif>{{ $transaction_type->type }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <select name="team" class="select2 form-control mb-3 custom-selec">
                                                <option value="">Select Team</option>
                                                @foreach ($teams as $team)
                                                    <option value="{{ $team->id }}" @if(old('team')==$team->id) selected @endif>{{ $team->name }}-{{ @$team->parent_data->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <select name="view_type" class="select2 form-control mb-3 custom-selec">
                                                <option disabled="" selected value="">Select Type</option>
                                                <option {{ old('view_type') == 'full_statement' ? 'selected' : '' }} value="full_statement">Full Statement</option>
                                                <option {{ old('view_type') == 'summary_statement' ? 'selected' : '' }} value="summary_statement">Summary Statement</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <button class="btn btn-primary">Search</button>
                                            <a href="{{ route('account.multiple_print') }}" class="btn btn-danger">Clear</a>

                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>


                        <div class="d-print-none">
                            <div class="float-right ">
                                <a href="#" class="btn btn-success btn-sm">Home</a>
                                <a href="javascript:window.print()" class="btn btn-info btn-sm"><i class="fa fa-print"></i></a>

                            </div>

                        </div><br>
                        <hr class="d-print-none">

                        @foreach($user_data as $k => $user_id)
                            @php
                                $statements = model('Transaction')::with('invest', 'agent')->whereIn('for_report', ['agent_commission','agent_investment'])->where('agent_id', $user_id);
                                 if (old('trans_date_start') && old('trans_date_end')) {
                                      $statements =  $statements->whereDate('trans_date', '>=', now()->parse(old('trans_date_start')))->whereDate('trans_date', '<=', now()->parse(old('trans_date_end')));
                                  }
                                  if (old('transaction_type')) {
                                      $statements =  $statements->whereIn('type', old('transaction_type'));
                                  }
                                $order_by = model('Investment')::orderBy('user_id','ASC')->pluck('id')->toArray();
                                 $rawOrder = \DB::raw(sprintf('FIELD(module_id, %s)', implode(',', $order_by)));
                                 $statements = $statements->orderByRaw($rawOrder)->get();
                                 $user = \App\Models\User::find($user_id);
                            @endphp
                        @if(!empty($user))
                        <div class="card-body gfont{{ $k }}">
                            <div class="row">
                                <div class="col-lg-12">
                                    <div class="text-center mt-2">
                                        <address class="font-10 address-details">
                                            <h3>{{$setting->app_name}}</h3>
                                            <p>{{$setting->email}}</p>
                                        </address>
                                    </div>
                                </div>
                            </div>
                            <hr>
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="float-left mt-2">
                                        <address class="font-13">
                                            <small class="font-size-14">STATEMENT TO : <strong>{{$user->user_id}}</strong></small><br>
                                            <h4 style="text-transform: uppercase">{{$user->name}}<br></h4>
                                            {{$user->email}}<br>
                                            {{$user->phone_number}}
                                        </address>
                                    </div>
                                    <div class="float-right text-right mt-2" style="text-transform: uppercase;">
                                        <h3 class="name">BUSINESS STATEMENT</h3><br>
                                        <span>DATE OF STATEMENT : <strong>{{ date('d-M-y') }}</strong></span><br>
                                        <span>REF: {{cn($user,'refer_data.name',' ')}}, ID: {{cn($user,'refer_data.user_id',' ')}}</span><br>
                                        <span>TEAM: {{@$user->payment_teams[0]->name}}</span>
                                    </div>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-lg-12">
                                    <div class="table-responsive">
                                        <table class="table table-bordered mb-0">
                                            <thead>
                                            <tr>
                                                <th>SL.</th>
                                                <th>Date</th>
                                                <th>Details</th>
                                                <th>Business</th>
                                                <th class="text-right">Principal</th>
                                                <th class="text-right">Amount</th>
                                            </tr>
                                            </thead>
                                                                                        <tbody>


                                            <!-- Agent Investment -->

                                                                                        @if(count(collect($statements)->where('type','Agent Investment'))>0)
                                                <tr>
                                                    <td>{{++$sl_count}}</td>
                                                    <td></td>
                                                    <td class="mbcom">AGENT INVESTMENT</td>
                                                    <td colspan="2"></td>
                                                    <td></td>
                                                </tr>
                                                @foreach(collect($statements)->where('type','Agent Investment') as $statement)
                                                    @if(old('view_type') != 'summary_statement')
                                                        <tr>
                                                            <td></td>
                                                            <td>{{ utc_to_local('d M Y',$statement->trans_date) }}</td>
                                                            <td>{{preg_replace('/Investment from/','',$statement->module_text)}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td class="text-right">{{ number_format(cn($statement, 'invest.amount', ''),2) }}</td>
                                                            <td class="text-right">{{ number_format($statement->amount,2) }}</td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom text-right">Sub Total</td>
                                                    <td class="mbcom text-right">{{ number_format($investment_total,2) }}</td>
                                                    <td class="mbcom text-right">{{ number_format($investment_commission,2) }}</td>


                                                </tr>

                                            @endif

                                                                                        @if(count(collect($statements)->where('type', 'Agent Commission')) > 0)
                                                <tr>
                                                    <td>{{++$sl_count}}</td>
                                                    <td></td>
                                                    <td class="mbcom">AGENT COMMISSION</td>
                                                    <td colspan="2"></td>
                                                    <td></td>
                                                </tr>

                                                @foreach(collect($statements)->where('type', 'Agent Commission') as $statement)
                                                    @if(old('view_type') != 'summary_statement')
                                                        <tr>
                                                            <td></td>
                                                            <td>{{ utc_to_local('d M Y',$statement->trans_date) }}</td>
                                                            <td>{{preg_replace('/Funding Refer Bonus from/','-',$statement->module_text)}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td class="text-right">{{ number_format(cn($statement, 'invest.amount', ''),2) }}</td>
                                                            <td class="text-right">{{ number_format($statement->amount,2) }}</td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach

                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom text-right">Sub Total</td>
                                                    <td class="mbcom text-right">{{ number_format($agent_total,2) }}</td>
                                                    <td class="mbcom text-right">{{ number_format($agent_commission,2) }}</td>
                                                </tr>



                                            @endif

                                            <!-- Monthly Business Profit -->
                                                                                        @if ( count(collect($statements)->where('type', 'Monthly Business Profit')) > 0)
                                                <tr>
                                                    <td>{{++$sl_count}}</td>
                                                    <td></td>
                                                    <td class="mbcom">MONTHLY BUSINESS PROFIT</td>
                                                    <td colspan="2"></td>
                                                    <td></td>
                                                </tr>


                                                @foreach(collect($statements)->where('type', 'Monthly Business Profit') as $statement)
                                                    @if(old('view_type') != 'summary_statement')
                                                        <tr>
                                                            <td></td>
                                                            <td>{{ utc_to_local('d M Y',$statement->trans_date) }}</td>
                                                            <td>{{preg_replace('/TakeProfit from/','',$statement->module_text)}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td class="text-right">{{ number_format(cn($statement, 'invest.amount', ''),2) }}</td>
                                                            <td class="text-right">{{ number_format($statement->amount,2) }}</td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom text-right">Sub Total</td>
                                                    <td class="mbcom text-right">{{ number_format($monthly_profit_total,2) }}</td>
                                                    <td class="mbcom text-right">{{ number_format($monthly_profit_commission,2) }}</td>

                                                </tr>
                                            @endif

                                            <!-- Termly Business Profit -->
                                                                                        @if ( count(collect($statements)->where('type', 'Business Profit')) > 0)
                                                <tr>
                                                    <td>{{++$sl_count}}</td>
                                                    <td></td>
                                                    <td class="mbcom">BUSINESS PROFIT</td>
                                                    <td colspan="2"></td>
                                                    <td></td>
                                                </tr>


                                                @foreach(collect($statements)->where('type', 'Business Profit') as $statement)
                                                        @if(old('view_type') != 'summary_statement')
                                                        <tr>
                                                            <td></td>
                                                            <td>{{ utc_to_local('d M Y',$statement->trans_date) }}</td>
                                                            <td>{{preg_replace('/Bonus from/','',$statement->module_text)}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td class="text-right">{{ number_format(cn($statement, 'invest.amount', ''),2) }}</td>
                                                            <td class="text-right">{{ number_format($statement->amount,2) }}</td>
                                                        </tr>
                                                        @endif
                                                                                                        @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom text-right">Sub Total</td>
                                                    <td class="mbcom text-right">{{ number_format($termly_profit_total,2) }}</td>
                                                    <td class="mbcom text-right">{{ number_format($termly_profit_commission,2) }}</td>

                                                </tr>
                                            @endif

                                            <!-- Monthly Business Commission -->
                                                                                        @if(count(collect($statements)->where('type', 'Monthly Business Commission')) > 0)

                                                <tr>
                                                    <td>{{++$sl_count}}</td>
                                                    <td></td>
                                                    <td class="mbcom">MONTHLY BUSINESS COMMISSION</td>
                                                    <td colspan="2"></td>
                                                    <td></td>
                                                </tr>

                                                @foreach(collect($statements)->where('type', 'Monthly Business Commission') as $statement)
                                                    @if(old('view_type') != 'summary_statement')
                                                        <tr>
                                                            <td></td>
                                                            <td>{{ utc_to_local('d M Y',$statement->trans_date) }}</td>
                                                            <td>{{preg_replace('/Bonus from/','-',$statement->module_text)}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td class="text-right">{{ number_format(cn($statement, 'invest.amount', ''),2) }}</td>
                                                            <td class="text-right">{{ number_format($statement->amount,2) }} </td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom text-right">Sub Total</td>
                                                    <td></td>
                                                    <td class="mbcom text-right">{{ number_format($monthly_business_total,2) }}</td>
                                                    <td class="mbcom text-right">{{ number_format($monthly_business_commission,2) }}</td>

                                                </tr>
                                            @endif
                                            <tr>
                                                <td></td>
                                                <td></td>
                                                <td class="right subtoal mbcom" style="font-size:17px !important" colspan="2">Payable Total</td>
                                                <td></td>
                                                @php
                                                    $payable_total = $investment_commission+$agent_commission+$monthly_profit_commission+$monthly_business_commission;
                                                @endphp
                                                <td class="mbcom text-right"  style="font-size:17px !important">{{ number_format($payable_total) }}.00</td>

                                            </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <div class="row justify-content-center" style="text-transform: uppercase;">
                                <div class="col-lg-12">
                                    <span class="mt-4">Note :</span>

                                </div>

                            </div>
                            <hr>

                            <div style="display:flex;text-transform: uppercase;">
                                <div class="col-lg-4 align-self-end">
                                    <div class="w-40 float-left">
                                        <img src="assets/images/signature.png" alt="" class="img-fluid">
                                        <p class="border-top">Customer Signature</p>
                                    </div>
                                </div>
                                <div class="col-lg-4 align-self-end">
                                    <div class="w-40 text-center">
                                        <p class="text-muted">Thank You</p>
                                    </div>
                                </div>
                                <div class="col-lg-4 align-self-end">
                                    <div class="w-40 float-right">
                                        <img src="assets/images/signature.png" alt="" class="img-fluid">
                                        <p class="border-top">Authorize Signature</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                            <br>
                            <br>
                            @endif
                        @endforeach
                    </div>
                </div>
            </div>
        </div>
    </div><!-- container-fluid -->

    @push('alljs')
        <script src="{{asset('assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>

        <script type="text/javascript">
            $('#trans_date_start').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
            $('#trans_date_end').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
        </script>
    @endpush
@endsection