@extends('layouts.app')
<style>
    .clearfix:after {
        content: "";
        display: table;
        clear: both;
    }

    a {
        color: #0087C3;
        text-decoration: none;
    }

    body {
        position: relative;
        margin: 0 auto;
        width: 32cm;
        color: #555555;
        background: #FFFFFF;
        font-family: Arial, sans-serif;
        font-size: 12px;
        font-family: SourceSansPro;
    }

    header {
        padding: 10px 0;
        margin-bottom: 15px;

    }

    #logo {
        float: left;
        margin-top: 6px;
    }

    #logo img {
        height: 100px;
    }

    #company {
        float: right;
        text-align: right;
    }

    #details {
        margin-bottom: 50px;
    }

    #client {
        padding-left: 6px;
        border-left: 6px solid #0087C3;
        float: left;
    }

</style>
@section('content')
    <div class="card card-info" id="printcontent">
        <div class="col-md-12">
            <div class="card card-info">
                <div class="card-header">
                    <div class="row">
                        <div class="col-md-9">
                            <h3 class="card-title"> Sale Report</h3>
                        </div>

                    </div>
                </div>
                <?php  if($from== NULL) {
                   // dd('hi');
                    ?>
                <form action="{{ route('list') }}" method="get">
                    @csrf
                    <div class="row hide_content">
                        <div class="col-md-3" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px;">From: </span>
                                </div>
                                <input type="text" class="form-control datepicker" value="" id="StartDate" name="from">
                            </div>
                        </div>
                        <div class="col-md-3" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">To: </span>
                                </div>
                                <input type="text" class="form-control datepicker" value="" id="EndDate" name="to">
                            </div>
                        </div>
                        <div class="col-md-2" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">File No: </span>
                                </div>
                                <input type="text" class="form-control" value="" id="fileNo" name="fileNo">
                            </div>
                        </div>
                        <div class="col-md-3" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">Member: </span>
                                </div>
                                <select name="member_id" id="member_id" class="form-control">
                                    <option value="">Select Member</option>
                                    @foreach ($members as $member)
                                        <option value="{{ $member->id }}">{{ $member->name }}
                                            ({{ $member->serial_id }})
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-1">
                            <span class="input-group-append mt-3">
                                <button class="btn btn-secondary" type="submit">
                                    <i class="fa fa-search"></i>
                                </button>
                            </span>
                        </div>
                    </div>
                </form>
                <?php }else{?>
                <?php
                $from = date('d-m-Y', strtotime($from));
                $to = date('d-m-Y', strtotime($to));

                ?>
                <form action="{{ route('list') }}" method="get">
                    @csrf
                    <div class="row hide_content">
                        <div class="col-md-3" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">From: </span>
                                </div>
                                <input type="text" class="form-control datepicker" value="{{ $from }}"
                                    id="StartDate" name="from">
                            </div>
                        </div>

                        <div class="col-md-3" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">To: </span>
                                </div>
                                <input type="text" class="form-control datepicker" value="{{ $to }}" id="EndDate"
                                    name="to">
                            </div>
                        </div>

                        <div class="col-md-2" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">File No: </span>
                                </div>
                                <input type="text" class="form-control datepicker" value="" id="fileNo" name="fileNo">
                            </div>
                        </div>
                        <div class="col-md-3" style="padding-top:15px;padding-left:20px">
                            <div class="input-group">
                                <div>
                                    <span style="padding-right: 10px">Member: </span>
                                </div>
                                <select name="member_id" id="member_id" class="form-control">
                                    <option value="">Select Member</option>
                                    @foreach ($members as $member)
                                        <option value="{{ $member->id }}">{{ $member->name }}
                                            ({{ $member->serial_id }})
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-1">
                            <span class="input-group-append mt-3">
                                <button class="btn btn-secondary" type="submit">
                                    <i class="fa fa-search"></i>
                                </button>
                            </span>
                        </div>
                    </div>
                </form>
                <?php  } ?>
                <div class="card-body">


                    @if (count($sales))
                        <header class="clearfix" id="company_details" style="display:none">
                            <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
                            <table cellpadding="0" cellspacing="0">
                                <tr class="top">
                                    <td colspan="2">
                                        <table>
                                            <tr>
                                                <td>
                                                    <img src="{{ asset('/storage/app/public/' . $company->logo) }}"
                                                        style="width: 180px; height:120px">
                                                </td>
                                                <td style="padding-left: 130px">
                                                    <h2 style="padding-left:40px;color:#297f39">{{ $company->name }}
                                                    </h2>
                                                    <p style="text-align:center;padding-left:10px; line-height:20px;">
                                                        <b>{{ $company->address }}<br>
                                                            {{ $company->mobile }}</b><br>
                                                        <b>{{ $company->email }}</b>
                                                    </p>
                                                </td>

                                                <td>

                                                </td>

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

                            </table>
                            <hr style="border-bottom: 1px solid #AAAAAA;">
                            <table cellpadding="0" cellspacing="0">
                                <tr class="top">
                                    <td colspan="2">
                                        <table>
                                            <tr>
                                                <td></td>
                                                <td style="padding-left: 410px">
                                                    <h2> <strong>Sales Report</strong></h2>
                                                    <hr>
                                                </td>
                                                <td></td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>

                            </table> <br>
                            <table cellpadding="0" cellspacing="0">
                                <tr class="top">
                                    <td colspan="2">
                                        <table>
                                            <tr>
                                                <td>
                                                    <?php if($from!= NULL){ ?>
                                                    <h2> <strong>
                                                            From:</strong>{{ Carbon\Carbon::parse($from)->format('d-m-Y') }}
                                                        <strong>
                                                            To:</strong>{{ Carbon\Carbon::parse($to)->format('d-m-Y') }}
                                                    </h2>
                                                    <?php }else{?>
                                                    <h2 style="padding-left: 450px"> <strong>All Time </strong> </h2>
                                                    <?php }?>
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>

                            </table>
                        </header>

                        <div class="row">
                            <div class="col-md-12">
                                <div class="table-responsive">
                                    <table id="example1" class="table table-bordered mt-4 table-striped">
                                        <thead>
                                            <tr>
                                                <th>SL</th>
                                                <th>Date</th>
                                                <th>Refferal ID</th>
                                                <th>Refference name </th>
                                                <th>File no</th>
                                                <th>Member ID</th>
                                                <th>Member Name</th>
                                                <th>Client Paid</th>
                                                <th>Client Due amount</th>
                                                <th>Referral commision balance</th>
                                                <th>Referral withdraw balance</th>
                                                <th>Company Balance</th>

                                                <th class="hide_content">Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($sales as $sale)
                                                <?php
                                                $salDetail = App\Sale::where('id', $sale->sales_id)->first();
                                                $ref_amount1 = App\ReferenceIncome::where('sell_id', $sale->sales_id)->sum('rest_amount');
                                                $ref_with1 = App\ReferenceWithdraw::where('sell_id', $sale->sales_id)->sum('amount');
                                                ?>
                                                <tr>


                                                    <td>{{ $loop->index + 1 }}</td>
                                                    <td>{{ Carbon\Carbon::parse($sale->date)->format('d-m-Y') }} </td>
                                                    <td>{{ $sale->refference_id }}</td>
                                                    <td>{{ $sale->refference_name }}</td>
                                                    <td>{{ $salDetail->sale_no }}</td>
                                                    <td>{{ $sale->member->serial_id }}</td>
                                                    <td>{{ $sale->member->name }}</td>
                                                    <td>{{ $sale->paid }}</td>
                                                    <td>{{ $sale->due_amount }}</td>
                                                    <td>{{ $ref_amount1 }}</td>
                                                    <td>{{ $ref_with1 }}</td>
                                                    <td>{{ $sale->company_log }}</td>

                                                    <td class="hide_content">
                                                        <a href="{{ route('show_list', $sale->sales_id) }}"
                                                            class="btn btn-sm btn-info"><i class="fa fa-eye"></i></a>

                                                        <a onclick="return confirm('Are you sure,You want to delete this item ?');"
                                                            href="{{ route('delete_list', $sale->id) }}"
                                                            class="btn btn-sm btn-danger"><i class="fa fa-trash"></i></a>


                                                    </td>
                                                </tr>
                                            @endforeach

                                        </tbody>
                                    </table>

                                    {{-- <h5><b>Total refferal commission:</b></h5>
                                    <h6 class="name">Total booking amount: <b>{{ $total_booking_amount }} tk</b> </h6>
                                    <h6 class="name">Total installment amount: <b>{{ $total_install_amount }} tk</b> </h6>
                                    <h6 class="name">Total এককালীন amount: <b>{{ $total_ekkalin_amount }} tk</b> </h6>
                                    <br> --}}
                                    <h6 class="name">Total paid amount: <b>{{ $total_paid_amount }} tk</b>
                                    </h6>
                                    <h6 class="name">Total due amount: <b>{{ $total_due_amount }} tk</b> </h6>

                                    <h6 class="name">Referral commision balance: <b>{{ $ref_amount }}
                                            tk</b> </h6>
                                    <h6 class="name">Referral withdraw balance: <b>{{ $ref_with }}
                                            tk</b>
                                    </h6>
                                    <h6 class="name">Total Company Balance now: <b>{{ $total }} tk</b>
                                    </h6>

                                </div>

                                <button class="btn-block btn-primary btn btn-sm hide_content"
                                    onclick="printDiv('printcontent')">Print</button>
                            @else
                                <div class="row">
                                    <div class="col-12">
                                        <div class="alert text-center alert-default-secondary">
                                            No Data Found!
                                        </div>
                                    </div>
                                </div>
                    @endif



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

    @include('extra.delete-modal')
@endsection

@section('footer-script')
    <script>
        function deleteHead(route) {
            $('#deleteForm').attr("action", route);
        }
    </script>
    <script src="{{ asset('/plugins/datatables/jquery.dataTables.min.js') }}"></script>

    <script src="{{ asset('/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('/plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>
    <script src="{{ asset('/plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>

    <script>
        document.getElementById('member_id').value = '{{ $mem }}';
    </script>
    <script>
        $(".datepicker").datepicker({
            dateFormat: 'dd-mm-yy'
        });

        function printDiv(divName) {

            $('#company_details').css('display', 'block');
            $('.hide_content').css('display', 'none');

            var printContents = document.getElementById(divName).innerHTML;
            var originalContents = document.body.innerHTML;

            document.body.innerHTML = printContents;

            window.print();

            document.body.innerHTML = originalContents;

            window.location.href = "{{ url()->current() }}";

            $('#company_details').css('display', 'none');

            $('.hide_content').css('display', 'block');
        }
    </script>
    <script type="text/javascript">
        $("#EndDate").change(function() {
            var startDate = document.getElementById("StartDate").value;
            var endDate = document.getElementById("EndDate").value;

            if ((Date.parse(startDate) > Date.parse(endDate))) {
                alert("End date should be greater than Start date");
                document.getElementById("EndDate").value = "";
            }
        });

        $('#customer_id').select2();
        $('#customer_mobile').select2();
    </script>
@endsection