@extends('layouts.master')
@section('title')
    {{translate('profit_loss')}}
@endsection
@section('content')
    <div class="panel panel-white">
        <div class="panel-heading">
            <h6 class="panel-title">
                {{translate('profit_loss')}}
                @if(!empty($start_date))
                    for period: <b>{{$start_date}} to {{$end_date}}</b>
                @endif
            </h6>

            <div class="heading-elements">
                <button class="btn btn-sm btn-info hidden-print" onclick="window.print()">Print</button>
            </div>
        </div>
        <div class="panel-body hidden-print">
            <h4 class="">{{translate('date range')}}</h4>
            {!! Form::open(array('url' => Request::url(), 'method' => 'post','class'=>'form-horizontal', 'name' => 'form')) !!}
            <div class="row">
                <div class="col-xs-5">
                    {!! Form::text('start_date',null, array('class' => 'form-control date-picker', 'placeholder'=>"From Date",'required'=>'required')) !!}
                </div>
                <div class="col-xs-1  text-center" style="padding-top: 5px;">
                    to
                </div>
                <div class="col-xs-5">
                    {!! Form::text('end_date',null, array('class' => 'form-control date-picker', 'placeholder'=>"To Date",'required'=>'required')) !!}
                </div>
            </div>
            <div class="panel-body">
                <div class="row">
                    <div class="col-xs-2">
                        <span class="input-group-btn">
                          <button type="submit" class="btn bg-olive btn-flat">{{translate('search')}}!
                          </button>
                        </span>
                        <span class="input-group-btn">
                            <a href="{{Request::url()}}"
                               class="btn bg-purple  btn-flat pull-right">{{translate('reset')}}!</a>
                        </span>
                    </div>
                </div>
            </div>
            {!! Form::close() !!}

        </div>
        <!-- /.panel-body -->

    </div>
    <!-- /.box -->
    <div class="row">
        <div class="col-md-4">
            <table id="profitloss" class="table table-bordered table-hover " style="background: #FFF;">
                <tbody>
                <tr style="background: #CCC;">
                    <td style="font-weight:bold">{{translate('profit_loss statement')}}</td>
                    <td align="right" style="font-weight:bold">{{translate('balance')}}</td>
                </tr>
                <tr class="bg-green">
                    <td style="font-weight:bold">{{translate('operating_profit')}} (P)</td>
                    <td style="font-weight:bold"></td>
                </tr>
                <tr>
                    <td>{{translate('interest repayment')}}</td>
                    <td align="right">{{round($interest_paid)}}</td>
                </tr>
                <tr>
                    <td>{{translate('fee repayment')}}</td>
                    <td align="right">{{round($fees_paid)}}</td>
                </tr>
                <tr>
                    <td>{{translate('penalty repayment')}}</td>
                    <td align="right">{{round($penalty_paid)}}</td>
                </tr>
                <tr>
                    <td>{{translate('other_income')}}</td>
                    <td align="right">{{round($other_income)}}</td>
                </tr>
                <tr class="bg-red">
                    <th>{{translate('operating_expense')}} (E)
                    </th>
                    <th>
                    </th>
                </tr>
                <tr>
                    <td>{{translate('payroll')}}</td>
                    <td align="right">{{round($payroll)}}</td>
                </tr>
                <tr>
                    <td>{{translate('expense')}}</td>
                    <td align="right">{{round($expenses)}}</td>
                </tr>
                <tr>
                    <td style="font-weight:bold">{{translate('gross profit')}}
                        (G) = P - E
                    </td>
                    <td style="font-weight:bold" align="right">{{round($gross_profit)}}</td>
                </tr>
                <tr class="bg-red">
                    <td style="font-weight:bold">{{translate('other expense')}}
                        (O)
                    </td>
                    <td></td>
                </tr>
                <tr>
                    <td>{{translate('saving interest')}} *</td>
                    <td align="right">{{round($savings)}}</td>
                </tr>
                <tr>
                    <td>{{translate('default loan')}} *</td>
                    <td align="right">{{round($loan_default)}}</td>
                </tr>
                <tr style="background: #CCC;">
                    <td style="font-weight:bold">{{translate('net income')}}
                        (N) = G - O
                    </td>
                    <td style="font-weight:bold" align="right">{{round($net_profit)}}</td>
                </tr>
                </tbody>
            </table>
            <p><b>Default Loans *</b> is loans(principal amount - repayments made) that have been marked as default.</p>
        </div>
        <div class="col-md-8 hidden-print">
            <!-- AREA CHART -->
            <!-- LINE CHART -->
            <div class="panel panel-white">
                <div class="panel-heading">
                    <h3 class="panel-title">{{translate('monthly net income')}}</h3>

                    <div class="heading-elements">

                    </div>
                </div>
                <div class="panel-body">
                    <div id="netIncomeChart" style="height: 250px;">
                    </div>
                </div>
                <!-- /.panel-body -->
            </div>
            <!-- /.box -->
            <div class="panel panel-white hidden-print">
                <div class="panel-heading">
                    <h3 class="panel-title"><span
                                style="color: #00a65a">{{translate('operating_profit')}}</span>
                        / {{translate('operating_expense')}}</h3>

                    <div class="heading-elements">

                    </div>
                </div>
                <div class="panel-body">
                    <div class="chart" id="operatingProfit" style="height: 350px;">
                    </div>
                </div>
                <!-- /.panel-body -->
            </div>
            <!-- /.box -->

            <!-- LINE CHART -->
            <div class="panel panel-white hidden-print">
                <div class="panel-heading">
                    <h3 class="panel-title">{{translate('other expense')}}</h3>

                    <div class="heading-elements">

                    </div>
                </div>
                <div class="panel-body" style="display: block;">
                    <div class="chart" id="otherExpensesChart" style="height: 250px;">
                    </div>
                </div>
                <!-- /.panel-body -->
            </div>
            <!-- /.box -->
        </div>
    </div>
@endsection
@section('footer-scripts')
    <script src="{{ asset('assets/plugins/amcharts/amcharts.js') }}"
            type="text/javascript"></script>
    <script src="{{ asset('assets/plugins/amcharts/serial.js') }}"
            type="text/javascript"></script>
    <script src="{{ asset('assets/plugins/amcharts/pie.js') }}"
            type="text/javascript"></script>
    <script src="{{ asset('assets/plugins/amcharts/themes/light.js') }}"
            type="text/javascript"></script>

    <script>
        AmCharts.makeChart("netIncomeChart", {
            "type": "serial",
            "theme": "light",
            "autoMargins": true,
            "marginLeft": 30,
            "marginRight": 8,
            "marginTop": 10,
            "marginBottom": 26,
            "fontFamily": 'Open Sans',
            "color": '#888',

            "dataProvider": {!! $monthly_net_income_data !!},
            "valueAxes": [{
                "axisAlpha": 0,

            }],
            "startDuration": 1,
            "graphs": [{
                "balloonText": "<span style='font-size:13px;'>[[title]] in [[category]]:<b> [[value]]</b> [[additional]]</span>",
                "bullet": "round",
                "bulletSize": 8,
                "lineColor": "#637bb6",
                "lineThickness": 4,
                "negativeLineColor": "#d1655d",
                "title": "{{translate('net income')}}",
                "type": "smoothedLine",
                "valueField": "amount"
            }],
            "categoryField": "month",
            "categoryAxis": {
                "gridPosition": "start",
                "axisAlpha": 0,
                "tickLength": 0,
                "labelRotation": 30,

            }


        });
        AmCharts.makeChart("operatingProfit", {
            "type": "serial",
            "theme": "light",
            "autoMargins": true,
            "marginLeft": 30,
            "marginRight": 8,
            "marginTop": 10,
            "marginBottom": 26,
            "fontFamily": 'Open Sans',
            "color": '#888',

            "dataProvider": {!! $monthly_operating_profit_expenses_data !!},
            "valueAxes": [{
                "axisAlpha": 0,

            }],
            "startDuration": 1,
            "graphs": [{
                "balloonText": "<span style='font-size:13px;'>[[title]] in [[category]]:<b> [[value]]</b> [[additional]]</span>",
                "lineAlpha": 0,
                "fillColors": "#00a65a",
                "fillAlphas": 1,
                "title": "{{translate('profit')}}",
                "type": "column",
                "valueField": "profit"
            }, {
                "balloonText": "<span style='font-size:13px;'>[[title]] in [[category]]:<b> [[value]]</b> [[additional]]</span>",
                "lineAlpha": 0,
                "fillColors": "#000",
                "fillAlphas": 1,
                "title": "{{translate('expense')}}",
                "type": "column",
                "valueField": "expenses"
            }],
            "categoryField": "month",
            "categoryAxis": {
                "gridPosition": "start",
                "axisAlpha": 0,
                "tickLength": 0,
                "labelRotation": 30,

            }


        }).addLegend(new AmCharts.AmLegend());
        AmCharts.makeChart("otherExpensesChart", {
            "type": "serial",
            "theme": "light",
            "autoMargins": true,
            "marginLeft": 30,
            "marginRight": 8,
            "marginTop": 10,
            "marginBottom": 26,
            "fontFamily": 'Open Sans',
            "color": '#888',

            "dataProvider": {!! $monthly_other_expenses_data !!},
            "valueAxes": [{
                "axisAlpha": 0,

            }],
            "startDuration": 1,
            "graphs": [{
                "balloonText": "<span style='font-size:13px;'>[[title]] in [[category]]:<b> [[value]]</b> [[additional]]</span>",
                "bullet": "round",
                "bulletSize": 8,
                "lineColor": "#d1655d",
                "lineThickness": 4,
                "negativeLineColor": "#637bb6",
                "title": "{{translate('other expense')}}",
                "type": "smoothedLine",
                "valueField": "expenses"
            }],
            "categoryField": "month",
            "categoryAxis": {
                "gridPosition": "start",
                "axisAlpha": 0,
                "tickLength": 0,
                "labelRotation": 30,

            }


        });

    </script>

@endsection