@extends('admin.pages.Bussiness-plan-builder.layout.master')
@section('bussinessplanbuilder')
@section('var4','show')
@section('var6','show')
@section('pnl','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>Profit and Loss</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">
                    <thead>
                        <tr>
                            <th scope="col">Revenue</th>
                            <th scope="col">Year1</th>
                            <th scope="col">Year2</th>
                            <th scope="col">Year3</th>

                        </tr>
                    </thead>
                    @php
                        $GrossMarginPercentage1=0;
                        $GrossMarginPercentage2=0;
                        $GrossMarginPercentage3=0;
                        $one_year_expense=0;
                        $two_year_expense=0;
                        $three_year_expense=0;
                        //$GrossProfit1=($one_year_sale-$one_year_cost)-$percentage_direct_labor_one_year;
                        //$GrossProfit2=($two_year_sale-$two_year_cost)-$percentage_direct_labor_two_year;
                        //$GrossProfit3=($three_year_sale-$three_year_cost)-$percentage_direct_labor_three_year;

                        $GrossProfit1=$one_year_sale-$one_year_cost;
                        $GrossProfit2=$two_year_sale-$two_year_cost;
                        $GrossProfit3=$three_year_sale-$three_year_cost;
                        if($one_year_sale>0){
                            $GrossMarginPercentage1=($GrossProfit1*100)/$one_year_sale;
                        }
                        if($two_year_sale>0){
                            $GrossMarginPercentage2=($GrossProfit2*100)/$two_year_sale;
                        }
                        if($three_year_sale>0){
                            $GrossMarginPercentage3=($GrossProfit3*100)/$three_year_sale;
                        }
                    @endphp
                    <tbody>
                        <tr>
                            <td>Sales</td>
                            <td>{{number_format($one_year_sale,2)}}</td>
                            <td>{{number_format($two_year_sale,2)}}</td>
                            <td>{{number_format($three_year_sale,2)}}</td>
                        </tr>
                        <tr>
                            <td>Cost of Goods Sold</td>
                            <td>{{number_format($one_year_cost,2)}}</td>
                            <td>{{number_format($two_year_cost,2)}}</td>
                            <td>{{number_format($three_year_cost,2)}}</td>
                        </tr>

                        <tr>
                            <td>Gross Profit</td>
                            <td>{{number_format($GrossProfit1+$one_year_income,2)}}</td>
                            <td>{{number_format($GrossProfit2+$two_year_income,2)}}</td>
                            <td>{{number_format($GrossProfit3+$three_year_income,2)}}</td>
                        </tr>

                        <tr>
                            <td>Gross Margin Percentage</td>
                            <td>{{number_format($GrossMarginPercentage1,2)}}%</td>
                            <td>{{number_format($GrossMarginPercentage2,2)}}%</td>
                            <td>{{number_format($GrossMarginPercentage3,2)}}%</td>
                        </tr>

                        <tr>
                            <td>Other Income</td>
                            <td>{{number_format($one_year_income,2)}}</td>
                            <td>{{number_format($two_year_income,2)}}</td>
                            <td>{{number_format($three_year_income,2)}}</td>
                        </tr>
                        <thead>
                        <tr>
                            <th>PAYROLL EXPENSES</th>
                            <th>Year1</th>
                            <th>Year2</th>
                            <th>Year3</th>
                        </tr>
                        </thead>
                        <tr>
                            <td>Payroll</td>

                            <td>{{number_format($one_year_salary,2)}}</td>
                            <td>{{number_format($two_year_salary,2)}}</td>
                            <td>{{number_format($three_year_salary,2)}}</td>
                        </tr>


                        <tr>
                            <td>Payroll Taxes and Benefits</td>
                            <td>{{number_format($payroll_tax_benefit_one_year,2)}}</td>
                            <td>{{number_format($payroll_tax_benefit_two_year,2)}}</td>
                            <td>{{number_format($payroll_tax_benefit_three_year,2)}}</td>
                        </tr>
                        <thead>
                        <tr>
                            <th>OPERATING EXPENSES</th>
                            <th>Year1</th>
                            <th>Year2</th>
                            <th>Year3</th>
                        </tr>
                        </thead>
                         <tr>
                            <td>Insurance</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_insu'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_insu'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_insu'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Legal and Accounting</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_acc'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_acc'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_acc'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Maintenance</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_main'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_main'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_main'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Property</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_property'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_property'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_property'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Supplies</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_supply'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_supply'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_supply'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Telephone</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_telephone'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_telephone'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_telephone'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Travel</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_travel'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_travel'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_travel'],2)}}</td>
                        </tr>
                        <tr>
                            <td>Utilities</td>
                            <td>{{number_format($profit_loss_arr['one_year_expense_legal_utility'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_expense_legal_utility'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_expense_legal_utility'],2)}}</td>
                        </tr>
                        @if(!$profit_loss_arr['custom_expense']->isEmpty())
                            @foreach($profit_loss_arr['custom_expense'] as $key => $custom_value)
                               @php
                                   $one_year_expense=$one_year_expense+$custom_value->one_year_expense;
                                   $two_year_expense=$two_year_expense+$custom_value->two_year_expense;
                                   $three_year_expense=$three_year_expense+$custom_value->three_year_expense;
                               @endphp
                                <tr>
                                    <td>{{$custom_value->expense_name}}</td>
                                    <td>{{number_format($custom_value->one_year_expense,2)}}</td>
                                    <td>{{number_format($custom_value->two_year_expense,2)}}</td>
                                    <td>{{number_format($custom_value->three_year_expense,2)}}</td>
                                </tr>
                            @endforeach
                        @endif
                        <tr>
                            <td>Depreciation</td>
                            <td></td>
                            <td>0</td>
                            <td>0</td>
                        </tr>

                        <tr>
                            <td>Interest Expense</td>
                            <td>0</td>
                            <td>0</td>
                            <td>0</td>
                        </tr>

                        <tr>
                            <td>Marketing</td>
                            <td>{{number_format($profit_loss_arr['one_year_market_expense'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['two_year_market_expense'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['three_year_market_expense'],2)}}</td>
                        </tr>

                        <tr>
                            <td>Total Operating Expense</td>
                            <td>${{number_format($profit_loss_arr['one_year_expense_insu']+$profit_loss_arr['one_year_expense_legal_acc']+$profit_loss_arr['one_year_expense_legal_main']+$profit_loss_arr['one_year_expense_legal_property']+$profit_loss_arr['one_year_expense_legal_supply']+$profit_loss_arr['one_year_expense_legal_telephone']+$profit_loss_arr['one_year_expense_legal_travel']+$profit_loss_arr['one_year_expense_legal_utility']+$profit_loss_arr['one_year_market_expense']+$one_year_expense,2)}}</td>
                            <td>${{number_format($profit_loss_arr['two_year_expense_insu']+$profit_loss_arr['two_year_expense_legal_acc']+$profit_loss_arr['two_year_expense_legal_main']+$profit_loss_arr['two_year_expense_legal_property']+$profit_loss_arr['two_year_expense_legal_supply']+$profit_loss_arr['two_year_expense_legal_telephone']+$profit_loss_arr['two_year_expense_legal_travel']+$profit_loss_arr['two_year_expense_legal_utility']+$profit_loss_arr['two_year_market_expense']+$two_year_expense,2)}}</td>
                            <td>${{number_format($profit_loss_arr['three_year_expense_insu']+$profit_loss_arr['three_year_expense_legal_acc']+$profit_loss_arr['three_year_expense_legal_main']+$profit_loss_arr['three_year_expense_legal_property']+$profit_loss_arr['three_year_expense_legal_supply']+$profit_loss_arr['three_year_expense_legal_telephone']+$profit_loss_arr['three_year_expense_legal_travel']+$profit_loss_arr['three_year_expense_legal_utility']+$profit_loss_arr['three_year_market_expense']+$three_year_expense,2)}}</td>
                        </tr>
                        <thead>
                        <tr>
                            <th>TOTALS</th>
                            <th>Year1</th>
                            <th>Year2</th>
                            <th>Year3</th>
                        </tr>
                        </thead>

                        <tr>
                            <td>Earnings Before Taxes</td>
                            <td>${{number_format($profit_loss_arr['earnings_before_taxes_year1'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['earnings_before_taxes_year2'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['earnings_before_taxes_year3'],2)}}</td>
                        </tr>

                        <tr>
                            <td>Tax Percentage</td>
                            <td>{{number_format($profit_loss_arr['percentage_one_year']*100,2)}}%</td>
                            <td>{{number_format($profit_loss_arr['percentage_two_year']*100,2)}}%</td>
                            <td>{{number_format($profit_loss_arr['percentage_three_year']*100,2)}}%</td>
                        </tr>

                        <tr>
                            <td>Income Taxes</td>
                            <td>${{number_format($profit_loss_arr['income_tax_year1'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['income_tax_year2'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['income_tax_year3'],2)}}</td>
                        </tr>

                        <tr>
                            <td>Net Profit after Tax</td>
                            <td>${{number_format($profit_loss_arr['net_profit_after_tax_year1'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['net_profit_after_tax_year2'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['net_profit_after_tax_year3'],2)}}</td>
                        </tr>

                        <tr>
                            <td>Owner's Draws and Dividends</td>

                            <td>{{number_format($profit_loss_arr['ownerDrawyear1'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['ownerDrawyear2'],2)}}</td>
                            <td>{{number_format($profit_loss_arr['ownerDrawyear3'],2)}}</td>
                        </tr>

                        <tr>
                            <td>Change in Retained Earnings</td>
                            <td>${{number_format($profit_loss_arr['net_profit_after_tax_year1']-$profit_loss_arr['ownerDrawyear1'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['net_profit_after_tax_year2']-$profit_loss_arr['ownerDrawyear2'],2)}}</td>
                            <td>${{number_format($profit_loss_arr['net_profit_after_tax_year3']-$profit_loss_arr['ownerDrawyear3'],2)}}</td>
                        </tr>


                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="row mt-5">
        <div class="col-md-6"><a href="{{route('user.financialinfo.financialinfotext',Request()->id)}}" class="btn btn-success">« Back</a></div>

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

    {{-- 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