@extends('admin.pages.Bussiness-plan-builder.layout.master')
@section('bussinessplanbuilder')
@section('var4','show')
@section('var6','show')
@section('cf','active1')
    <style>
        #productsales {
            backgnumber_format: gainsboro;
            border: 1px solid rgb(161, 161, 235);
            COLOR: white;
            border-radius: 14px;
        }

        input.form-control.form-control-sm {
            backgnumber_format: #dddddd;
        }

        .overlay {
            pointer-events: none;
            margin-top: 29%;
            margin-bottom: 10%;
            backgnumber_format: #dddddd;
        }

        #img-preview {
            display: none;
            width: 155px;
            border: 2px dashed #333;
            margin-bottom: 20px;
        }

        #img-preview img {
            width: 100%;
            height: auto;
            display: block;
        }

        [type="file"] {
            height: 0;
            width: 0;
            overflow: hidden;
        }

        [type="file"]+label {
            font-family: sans-serif;
            backgnumber_format: black;
            padding: 10px 30px;
            border: 2px solid black;
            border-radius: 3px;
            color: #fff;
            cursor: pointer;
            transition: all 0.2s;
        }

        [type="file"]+label:hover {
            backgnumber_format-color: #fff;
            color: #f44336;
        }



        @media (min-width: 576px) {
            .modal-dialog {
                max-width: 750px;
            }
        }

        @media(min-width:992px) {
            .avatar {
                margin-top: -6rem;
                margin-bottom: 1rem;
                width: 200px;
                height: 130px;
                margin-right: 29rem;
            }

            .card-title {
                margin-top: -6rem;
                color: #fff;
            }
        }

        @media(max-width:990px) {
            .avatar {
                border: 0.3rem solid rgba(#fff, 0.3);
                margin-top: -6rem;
                margin-bottom: 1rem;
                width: 100px;
                height: 100px;
                margin-right: 8rem
            }

            .chn {
                margin-top: -7rem;
            }

            .chcn {
                color: #fff;
            }



            .chpn {
                border-bottom: #333 2px solid;
                display: none;
            }

        }



        .chpn {
            border-bottom: #333 2px solid;

        }

        .lab-style {
            font-weight: bold !important;
            margin-right: 14rem;
        }

        .table:not(.table-sm):not(.table-md):not(.dataTable) td,
        .table:not(.table-sm):not(.table-md):not(.dataTable) th {
            height: 15px;
        }

    </style>
    <div class="row">
        <div class="col-md-12">
            <h1>Cash Flow</h1>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div class="text-left" style="backgnumber_format-color: #ddecf2; padding: 1rem; padding-bottom: 3rem;">
                <h6>DID YOU NEED HELP WITH THIS?</h6>
                <h4>Financials don't need to be done on your own.</h4>
                <p>Financials are a critical component of any business plan. Get expert help to get it done right including
                    the revenue forecasting, balance sheet, cash flow statement and your profit/loss statement. Figure out
                    your net worth with expert help.</p>
                {{-- <button type="button" class="btn btn-primary" data-toggle="modal" data-target="#basicModal">Get an Expert
                    for this</button> --}}

            </div>
        </div>
    </div>
    {{-- <div class="row mt-3">
        <div class="col-md-12">
            <button type="button" class="btn btn-primary float-right">Download Table as PNG</button>
        </div>
        <div class="col-md-12 mt-2">
            <button type="button" class="btn btn-primary float-right">Download Table as Csv</button>
        </div>
    </div> --}}
    <div class="row mt-3">
        <div class="col-md-12">
            <div class="table-responsive">
                <table class="table table-bordered">
                    <tbody>
                        <thead>
                            <tr>
                                <th>CASH IN</th>
                                <th>Year 1</th>
                                <th>Year 2</th>
                                <th>Year 3</th>
                            </tr>
                        </thead>
                        <tr>
                            <td>Sales</td>

                            <td>{{number_format($cash_flow_arr["one_year_sale"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["two_year_sale"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["three_year_sale"],2)}}</td>
                        </tr>

                        <tr>
                            <td>Other Income</td>
                            <td>{{number_format($cash_flow_arr["one_year_income"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["two_year_income"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["three_year_income"],2)}}</td>
                        </tr>

                        <tr>
                            <td>Investments</td>
                            <td>{{number_format($cash_flow_arr["investor_one_year"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["investor_two_year"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["investor_three_year"],2)}}</td>
                        </tr>
                        <tr>
                            <td colspan="4">&nbsp;</td>
                        </tr>
                        <thead>
                            <tr>
                                <th><strong>Total Cash In</strong></th>
                                <th><strong>${{number_format($cash_flow_arr["one_year_sale"]+$cash_flow_arr["investor_one_year"]+$cash_flow_arr["one_year_income"],2)}}</strong></th>
                                <th><strong>${{number_format($cash_flow_arr["two_year_sale"]+$cash_flow_arr["investor_two_year"]+$cash_flow_arr["two_year_income"],2)}}</strong></th>
                                <th><strong>${{number_format($cash_flow_arr["three_year_sale"]+$cash_flow_arr["investor_three_year"]+$cash_flow_arr["three_year_income"],2)}}</strong></th>
                            </tr>
                        </thead>

                        <tr>
                            <td colspan="4">&nbsp;</td>
                        </tr>

                        <thead>
                            <tr>
                                <th>CASH OUT</th>
                                <th>Year 1</th>
                                <th>Year 2</th>
                                <th>Year 3</th>
                            </tr>
                        </thead>
                        <tr>
                            <td>COGS</td>
                            <td>{{number_format($cash_flow_arr["one_year_cost"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["two_year_cost"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["three_year_cost"],2)}}</td>
                        </tr>

                        <tr>
                            <td>Other Expenses</td>
                            <td>{{number_format($cash_flow_arr["one_year_expense_total"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["two_year_expense_total"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["three_year_expense_total"],2)}}</td>
                        </tr>


                        <tr>
                            <td>Payroll</td>
                            <td>{{number_format($cash_flow_arr["one_year_salary_payroll"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["two_year_salary_payroll"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["three_year_salary_payroll"],2)}}</td>
                        </tr>

                        <tr>
                            <td>Cash Paid for Taxes</td>
                            <td>0</td>
                            <td>0</td>
                            <td>0</td>
                        </tr>

                        <tr>
                            <td>Cash Paid for Fixed Assets</td>
                            <td>0</td>
                            <td>0</td>
                            <td>0</td>
                        </tr>


                        <tr>
                            <td>Loan Principal Payments</td>
                            <td>{{number_format($cash_flow_arr['LoanPrincipalPaymentsTotal'],2)}}</td>
                            <td>{{number_format($cash_flow_arr['LoanPrincipalPaymentsTotal'],2)}}</td>
                            <td>{{number_format($cash_flow_arr['LoanPrincipalPaymentsTotal'],2)}}</td>
                        </tr>


                        <tr>
                            <td>Loan Interest Payments</td>
                            <td>{{number_format($cash_flow_arr['LoanInterestPaymentsTotal'],2)}}</td>
                            <td>{{number_format($cash_flow_arr['LoanInterestPaymentsTotal'],2)}}</td>
                            <td>{{number_format($cash_flow_arr['LoanInterestPaymentsTotal'],2)}}</td>
                        </tr>

                        <tr>
                            <td>Owner's Draws and Dividends</td>
                            <td>{{number_format($cash_flow_arr["ownerDrawyear1"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["ownerDrawyear2"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["ownerDrawyear3"],2)}}</td>
                        </tr>

                        <tr>
                            <td>Other Assets</td>
                            <td>0</td>
                            <td>0</td>
                            <td>0</td>
                        </tr>
                        <tr>
                            <td colspan="4">&nbsp;</td>
                        </tr>
                        <thead>
                            <tr>
                                <th><strong>Total Cash Out</strong></th>
                                <th><strong>{{number_format($cash_flow_arr["total_cash_one_year"],2)}}</strong></th>
                                <th><strong>{{number_format($cash_flow_arr["total_cash_two_year"],2)}}</strong></th>
                                <th><strong>{{number_format($cash_flow_arr["total_cash_three_year"],2)}}</strong></th>
                            </tr>
                        </thead>
                        <tr>
                            <td colspan="4">&nbsp;</td>
                        </tr>
                        <thead>
                            <tr>
                                <th>TOTALS</th>
                                <th>Year 1</th>
                                <th>Year 2</th>
                                <th>Year 3</th>
                            </tr>
                        </thead>
                        <tr>
                            <td>Starting Cash Balance</td>
                            <td>{{number_format($cash_flow_arr["start_cash"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["EndingCashBalanceYear1"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["EndingCashBalanceYear2"],2)}}</td>
                        </tr>

                        <tr>
                            <td>Net Cash Flow</td>

                            <td>{{number_format($cash_flow_arr["total_cash_in_year1"]-$cash_flow_arr["total_cash_one_year"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["total_cash_in_year2"]-$cash_flow_arr["total_cash_two_year"],2)}}</td>
                            <td>{{number_format($cash_flow_arr["total_cash_in_year3"]-$cash_flow_arr["total_cash_three_year"],2)}}</td>
                        </tr>
                        <tr>
                            <td colspan="4">&nbsp;</td>
                        </tr>
                        <thead>
                            <tr>
                                <th><strong>Ending Cash Balance</strong></th>
                                <th><strong>{{number_format($cash_flow_arr["EndingCashBalanceYear1"],2)}}</strong></th>
                                <th><strong>{{number_format($cash_flow_arr["EndingCashBalanceYear2"],2)}}</strong></th>
                                <th><strong>{{number_format($cash_flow_arr["EndingCashBalanceYear3"],2)}}</strong></th>
                            </tr>
                        </thead>
                        <tr>
                            <td colspan="4">&nbsp;</td>
                        </tr>
                        @php
                            $total=$cash_flow_arr["EndingCashBalanceYear1"]+$cash_flow_arr["EndingCashBalanceYear2"]+$cash_flow_arr["EndingCashBalanceYear3"]
                        @endphp
                        <tr>
                          @if($total>0)
                            <td colspan="4">
                                <h2 style="color:#264409;"> Your Cash Balance is Positive!</h2>
                            </td>
                          @elseif($total==0)
                            <td colspan="4">
                                <h2 style="color:#264409;"> Your Cash Balance is Zero!</h2>
                            </td>
                          @else
                            <td colspan="4">
                                <h2 style="color:#264409;"> Your Cash Balance is Negative!</h2>
                            </td>
                          @endif  
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="row mt-5">
        <div class="col-md-6"><a href="{{route('user.report.profitlosstext',Request()->id)}}" class="btn btn-success">« Back</a></div>

        <div class="col-md-6 text-right"><a href="{{route('user.report.cashflowtext',Request()->id)}}" class="btn btn-primary">Continue to Cash Flow Text »</a></div>
    </div>

    {{-- Hire a expert Modak] --}}
    <div class="modal fade" id="basicModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content" style="backgnumber_format:transparent;    box-shadow:none; ">
                <div class="modal-header">
                    <h5 class="modal fade show" id="exampleModalLabel">Modal title</h5>

                </div>
                <div class="modal-body">



                    <div class="card">
                        <img class="card-img-top"
                            src="https://s3.eu-central-1.amazonaws.com/bootstrapbaymisc/blog/24_days_bootstrap/oslo.jpg"
                            alt="Bologna" height="120px">
                        <div class="card-body text-center">
                            <div class="row">
                                <div class="col-4">
                                    <img class="avatar number_formated-circle"
                                        src="https://s3.eu-central-1.amazonaws.com/bootstrapbaymisc/blog/24_days_bootstrap/robert.jpg"
                                        alt="Bologna">
                                </div>
                                <div class="col-8 chn">
                                    <h4 class="card-title chcn">Get Your Logo Completed for You.</h4>
                                </div>
                                <p class="card-subtitle mb-2 text-muted chpn">If you require a logo design expert* to
                                    create
                                    a stunning brand face for your business plan, complete the form below and help will
                                    be
                                    on the way.</p>

                            </div>
                            <div class="row">
                                <div class="form-group col-6">
                                    <label class="lab-style">First Name</label>
                                    <input type="text" class="form-control">
                                </div>
                                <div class="form-group col-6">
                                    <label class="lab-style">Email</label>
                                    <input type="email" class="form-control">
                                </div>
                            </div>
                            <div class="row">
                                <div class="form-group col-6">
                                    <label class="lab-style">Province</label>
                                    <select class="form-control">
                                        <option disabled="" selected="">Province</option>
                                        <option>Option 2</option>
                                        <option>Option 3</option>
                                    </select>
                                </div>
                                <div class="form-group col-6">
                                    <label class="lab-style">City</label>
                                    <input type="text" class="form-control">
                                </div>
                            </div>
                            <a type="button" class="btn btn-primary">Save changes</a>
                            <a type="button" class="btn btn-secondary" data-dismiss="modal">Close</a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection