@extends('layouts.layout')
@section('body_class', 'nav-md')
@section('body_content')
<div class="container body">
    <div class="main_container">
        @include('includes.sidebar')
        <div class="right_col" role="main">
            <div class="page-title">
                <div class="title_left">
                    <h3>Report AUM</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">                       
                        <div class="x_content">
                            <div style="margin-bottom:16px;">
                                <form class="form-horizontal" method="get">    
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-2 control-label">Start :</label>
                                        <div class="col-xs-12 col-sm-10">
                                            <input class="form-control" type="date" name="start" value="{{ $request['start_date'] }}" />
                                        </div>
                                    </div>   
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-2 control-label">End :</label>
                                        <div class="col-xs-12 col-sm-10">
                                            <input class="form-control" type="date" name="end" value="{{ $request['end_date'] }}" />
                                        </div>
                                    </div>                                
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-2 control-label">RM :</label>
                                        <div class="col-xs-12 col-sm-10">
                                            <select class="form-control" name="rm">
                                                <option value="all" @if($request['rm'] == 'all') selected @endif>All</option>
                                                @foreach($rms as $rm)
                                                    <option value="{{ $rm->id }}" @if($request['rm'] == $rm->id) selected @endif>{{ $rm->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <div class="col-xs-12 col-sm-offset-2 col-sm-10">
                                            <button type="submit" class="btn btn-default"><i class="fa fa-search" aria-hidden="true"></i> Search</button>
                                        </div>
                                    </div>

                                    @if(isset($request['error']))
                                        <div class="form-group">
                                            <div class="alert alert-danger" role="alert">                                          
                                                <strong>Error!</strong> {{ $request['error'] }}
                                            </div>
                                        </div>
                                    @endif
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

                @if($summary_account)
                    <div class="col-xs-12 col-sm-6">
                        <div class="x_panel">         
                            <div class="x_title">
                                <div class="row">
                                    <div class="col-xs-6"><h2 style="font-size:1em;">Graph AUM</h2></div>
                                    <div class="col-xs-6 text-right">
                                        <a class="collapse-link" style="font-size:1em; cursor:pointer;"><i class="fa fa-chevron-up"></i></a>
                                    </div>
                                </div>
                            </div>              
                            <div class="x_content"> 
                                <div style="margin-bottom:16px;">
                                    <div id="graph_aum"></div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xs-12 col-sm-6">
                        <div class="x_panel">         
                            <div class="x_title">
                                <div class="row">
                                    <div class="col-xs-6"><h2 style="font-size:1em;">Graph Account</h2></div>
                                    <div class="col-xs-6 text-right">
                                        <a class="collapse-link" style="font-size:1em; cursor:pointer;"><i class="fa fa-chevron-up"></i></a>
                                    </div>
                                </div>
                            </div>              
                            <div class="x_content"> 
                                <div style="margin-bottom:16px;">
                                    <div id="graph_accounts"></div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xs-12">
                        <div class="x_content">
                            <div class="text-right">
                                <a href="{{ route('account/lakusimpan/report/aum/export', ['rm'=>$request['rm'], 'start'=>$request['start_date'], 'end'=>$request['end_date']]) }}" class="btn btn-default" target="_blank"><i class="fa fa-download" aria-hidden="true"></i> Export Data</a>
                            </div>
                            <table class="table table-bordered table-striped" style="margin-top:16px;">
                                <thead>
                                    <tr>
                                        <th rowspan="2" class="text-center">No</th>
                                        <th rowspan="2" class="text-center">Date</th>
                                        <th colspan="2" class="text-center">Ending Balance</th>
                                        <th colspan="2" class="text-center">Open</th>
                                        <th colspan="2" class="text-center">Close</th>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Nominal</th>
                                        <th class="text-center">#</th>
                                        <th class="text-center">Nominal</th>
                                        <th class="text-center">#</th>
                                        <th class="text-center">Nominal</th>
                                        <th class="text-center">#</th>
                                    </tr>
                                </thead>
                                <tbody>                                    
                                    <tr>
                                        <td class="text-center">1</td>
                                        <td class="text-center">Begining Balance</td>
                                        <td class="text-center">{{ $start_balance }}</td>
                                        <td class="text-center">{{ $count_balance }}</td>
                                        <td colspan="4"></td>
                                    </tr>

                                    @foreach($summary_account as $transaction)
                                        <tr>
                                            <td class="text-center">{{ $loop->iteration + 1 }}</td>
                                            <td class="text-center">{{ $transaction["date"] }}</td>
                                            <td class="text-center">{{ $start_balance = $start_balance + $transaction["amount_opened"] - $transaction["amount_closed"] }}</td>
                                            <td class="text-center">{{ $count_balance = $count_balance + $transaction["total_opened"] - $transaction["total_closed"] }}</td>
                                            <td class="text-center">{{ $transaction["amount_opened"] }}</td>
                                            <td class="text-center">{{ $transaction["total_opened"] }}</td>
                                            <td class="text-center">{{ $transaction["amount_closed"] }}</td>
                                            <td class="text-center">{{ $transaction["total_closed"] }}</td>                                            
                                        </tr>
                                    @endforeach

                                </tbody>                        
                            </table>
                        </div>
                    </div>
                @endif
            </div>
        </div>
        @include('includes.footer')
    </div>
</div>
@endsection

@section("scripts")
<script src="//cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.min.js"></script>
<script type="text/javascript">    
    function generate_graph_aum() {
        Morris.Line({
            element: 'graph_aum',
            data: {!! json_encode($summary_account) !!},
            xkey: 'date',
            ykeys: ['aum'],
            labels: ['Total Amount']
        });
    }
    function generate_graph_count_aum() {
        Morris.Line({
            element: 'graph_accounts',
            data: {!! json_encode($summary_account) !!},
            xkey: 'date',
            ykeys: ['count_aum'],
            labels: ['Count Account']
        });
    }
    generate_graph_aum();
    generate_graph_count_aum();
</script>
@endsection