@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;
            }
            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;
            }

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

            .card-body.gfont h4, .card-body.gfont h5, .card-body.gfont h3 {
                font-weight: 600;
            }
            .table td {
                font-size: 15px
            }
            .table th {
                font-size: 16px;
                font-weight: bold;
            }
        </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-4">
                                        <div class="form-group ">
                                            <input class="form-control" readonly type="text" name="trans_date_start" id="trans_date_start" placeholder="Search Date"  value="{{ old('trans_date_start')}}" autocomplete="off">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group ">
                                            <input class="form-control" readonly 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-4">
                                        <div class="form-group">
                                            <select name="transaction_type" class="select2 form-control mb-3 custom-selec">
                                                <option disabled="" selected value="">Select Type</option>
                                                @foreach ($transaction_types as $transaction_type)
                                                    <option value="{{ $transaction_type->type }}" @if($transaction_type->type ==  app('request')->input('transaction_type')) selected @endif>{{ $transaction_type->type }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <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="{{url('account/commisition-statement/'.$user->id)}}" 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="{{url('account/monthly-commisition')}}" class="btn btn-danger btn-sm">Cancel</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">
                        <div class="card-body gfont">
                            <div class="row">
                                {{-- <div class="col-lg-6">
                                    <img src="{{ asset('uploads/images/'.get_option('app_logo')) }}" alt="" class="img-fluid" width="75">
                                </div> --}}
                                <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>
                                            <p><b>Statement</b></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>{{$user->name}}<br></h4>
                                            {{$user->email}}<br>
                                            {{$user->phone_number}}
                                        </address>
                                    </div>
                                    <div class="float-right text-right mt-2">
                                        <h3 class="name">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>
                                    </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>Detais</th>
                                                <th>Business</th>
                                                <th>Principal</th>
                                                <th>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>{{$statement->module_text}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td>{{ number_format(cn($statement, 'invest.amount', '')) }}</td>
                                                            <td>{{ number_format($statement->amount) }}</td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>

                                                    <td class="mbcom">TOTAL AGENT INVESTMENT Amount</td>
                                                    <td></td>
                                                    <td class="mbcom">{{ number_format($investment_total) }}</td>
                                                    <td class="mbcom">{{ 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>{{$statement->module_text}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td>{{ number_format(cn($statement, 'invest.amount', '')) }}</td>
                                                            <td>{{ number_format($statement->amount) }}</td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach

                                                <tr>
                                                    <td></td>
                                                    <td></td>

                                                    <td class="mbcom">TOTAL AGENT COMMISSION Amount</td>
                                                    <td></td>
                                                    <td class="mbcom">{{ number_format($agent_total) }}</td>
                                                    <td class="mbcom">{{ 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>{{$statement->module_text}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td>{{ number_format(cn($statement, 'invest.amount', '')) }}</td>
                                                            <td>{{ number_format($statement->amount) }}</td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom">TOTAL MONTHLY BUSINESS PROFIT Amount</td>
                                                    <td></td>
                                                    <td class="mbcom">{{ number_format($monthly_profit_total) }}</td>
                                                    <td class="mbcom">{{ number_format($monthly_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>{{$statement->module_text}}</td>
                                                            <td>{{cn($statement, 'invest.package.package_name', '') }}</td>
                                                            <td>{{ number_format(cn($statement, 'invest.amount', '')) }}.00</td>
                                                            <td>{{ number_format($statement->amount) }}.00 </td>
                                                        </tr>
                                                    @endif
                                                                                                    @endforeach
                                                <tr>
                                                    <td></td>
                                                    <td></td>
                                                    <td class="mbcom">TOTAL MONTHLY BUSINESS COMMISSION Amount</td>
                                                    <td></td>
                                                    <td class="mbcom">{{ number_format($monthly_business_total,2) }}</td>
                                                    <td class="mbcom">{{ number_format($monthly_business_commission,2) }}</td>

                                                </tr>
                                            @endif

                                            <!-- <tr>
                                                 <td></td>
                                                 <td class="incomedtls" colspan="2">EXPENSE DETAILS</td>
                                                 <td></td>
                                                 <td></td>
                                                 <td></td>
                                             </tr>
                                             <tr>
                                                 <td></td>
                                                 <td></td>
                                                 <td class="font-size-14 right subtoal" colspan="2">Total:</td>
                                                 <td><strong>0.00</strong></td>
                                                 <td></td>

                                             </tr> -->
                                            <tr>
                                                <td></td>
                                                <td class="font-size-14 right subtoal" colspan="2">Payable Total:</td>
                                                <td></td>
                                                <td></td>
                                                @php
                                                    $payable_total = $investment_commission+$agent_commission+$monthly_profit_commission+$monthly_business_commission;
                                                @endphp
                                                <td class="mbcom">{{ number_format($payable_total, 2) }}</td>

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

                                </div>

                            </div>
                            <hr>

                            <div style="display:flex">
                                <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>
                    </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