@extends('layouts.app')
@section('title', 'User Balance')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header  no-print">
    <h1>User Balance
    </h1>
    <!-- <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Level</a></li>
        <li class="active">Here</li>
    </ol> -->
</section>

<!-- Main content -->
<section class="content  no-print">
<div class="box">
        <div class="box-header">
            <form method="get" action="{{route('account.user-balance.view')}}">
                <div class="row">
                    <div class="col-md-3 col-xs-6">
                        <div class="input-group">
                            <span class="input-group-addon">
                                <i class="fa fa-calendar"></i>
                            </span>
                            {!! Form::text('filter_date', request()->get('date') ? @format_date(request()->get('date')) : @format_date('now'), ['class' => 'form-control', 'readonly', 'required', 'id' => 'filter_date']); !!}
                        </div>
                    </div>
                    <div class="col-md-3 col-xs-6">
                        <div class="input-group">
                            <span class="input-group-addon">
                                <i class="fa fa-user"></i>
                            </span>
                            <select name="user_id" class="form-control" id="store_id">
                                <option value="">All</option>
                                @foreach(App\User::get() as $user) 
                                <option value="{{$user->id}}" {{request()->get('user_id') && request()->get('user_id') == $user->id ? 'selected' : ''}}>{{$user->first_name}}</option> 
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3 col-xs-6">
                        <button type="submit" class="btb btn-primary">Filter</button>
                    </div>    
                </div>
            </form>
        </div>
    </div>
	<div class="box">
        <div class="box-body">
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th scope="col">Details</th>
                        <th scope="col">Cash</th>
                        <th scope="col">Bank</th>
                        <th scope="col">Other Payments</th>
                    </tr>
                </thead>
                <tbody>
                    <tr style="background-color: #c3e6cb;">
                        <td>Hand Payment</td>
                        <td>{{ $final_stats['cash_in_hand'] !== 0 ? @num_format($final_stats['cash_in_hand']) : '0.00' }}</td>
                        <td>{{ $final_stats['bank_balance'] !== 0 ? @num_format($final_stats['bank_balance']) : '0.00'}}</td>
                        <td>0.00</td>
                    </tr>
                    <tr  style="background-color: #c3e6cb;">
                        <td>Sales</td>
                        <td>{{ $row_stats['invoice_cash'] != 0 ? @num_format($row_stats['invoice_cash']) :'0.00' }}</td>
                        <td>{{ $row_stats['invoice_bank'] != 0 ? @num_format($row_stats['invoice_bank']) :'0.00' }}</td>
                        <td>{{ $row_stats['invoice_other'] != 0 ? @num_format($row_stats['invoice_other']) :'0.00' }}</td>
                    </tr>
                    <tr  style="background-color: #f5c6cb;">
                        <td>Purchase</td>
                        <td>{{ $row_stats['purchase_cash'] != 0 ? @num_format($row_stats['purchase_cash']) :'0.00' }}</td>
                        <td>{{ $row_stats['purchase_bank'] != 0 ? @num_format($row_stats['purchase_bank']) :'0.00' }}</td>
                        <td>{{ $row_stats['purchase_other'] != 0 ? @num_format($row_stats['purchase_other']) :'0.00' }}</td>
                    </tr>
                    <tr  style="background-color: #f5c6cb;">
                        <td>Expense</td>
                        <td>{{ $row_stats['expense_cash'] != 0 ? @num_format($row_stats['expense_cash']) :'0.00' }}</td>
                        <td>{{ $row_stats['expense_bank'] != 0 ? @num_format($row_stats['expense_bank']) :'0.00' }}</td>
                        <td>{{ $row_stats['expense_other'] != 0 ? @num_format($row_stats['expense_other']) :'0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <td>Sales Refund</td>
                        <td>{{$final_stats['return_paid'] !== 0 ? @num_format($final_stats['return_paid']) : '0.00' }}</td>
                        <td>0.00</td>
                        <td>0.00</td>
                    </tr>
                    <tr  style="background-color: #f5c6cb;">
                        <td>Location Transcation</td>
                        <td>{{ $final_stats['cash_transfer'] !== 0 ? @num_format($final_stats['cash_transfer'])  : '0.00' }}</td>
                        <td>{{ $final_stats['bank_transfer'] !== 0 ? @num_format($final_stats['bank_transfer'])  : '0.00' }}</td>
                        <td>0.00</td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <th colspan="4"></th>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Sale</th>
                        <td colspan="2">{{ $final_stats['invoice_total'] !== 0 ? @num_format($final_stats['invoice_total'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Sale Settlement</th>
                        <td colspan="2">{{ $final_stats['exsit_invoice'] !== 0 ? @num_format($final_stats['exsit_invoice'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #f5c6cb;">
                        <th colspan="2">Total Sale Due</th>
                        <td colspan="2">{{ $final_stats['invoice_due'] !== 0 ? @num_format($final_stats['invoice_due'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Purchase</th>
                        <td colspan="2">{{ $final_stats['purchase_total'] !== 0 ? @num_format($final_stats['purchase_total'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Purchase Settlement</th>
                        <td colspan="2">{{ $final_stats['exsit_purchase'] !== 0 ? @num_format($final_stats['exsit_purchase'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #f5c6cb;">
                        <th colspan="2">Total Purchase Due</th>
                        <td colspan="2">{{ $final_stats['purchase_due'] !== 0 ? @num_format($final_stats['purchase_due'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Sale Refund</th>
                        <td colspan="2">{{$final_stats['return_paid'] !== 0 ? @num_format($final_stats['return_paid']) : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #f5c6cb;">
                        <th colspan="2">Total Expense</th>
                        <td colspan="2">{{ $final_stats['expense_total'] !== 0 ? @num_format($final_stats['expense_total'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Expense Settlement</th>
                        <td colspan="2">{{ $final_stats['exsit_expense'] !== 0 ? @num_format($final_stats['exsit_expense'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Expense Due</th>
                        <td colspan="2">{{ $final_stats['expense_due'] !== 0 ? @num_format($final_stats['expense_due'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #f5c6cb;">
                        <th colspan="2">Total Location Transactions</th>
                        <td colspan="2">{{ $final_stats['transfer'] !== 0 ? @num_format($final_stats['transfer'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Total Bank Deposit</th>
                        <td colspan="2">{{ $final_stats['bank_deposit'] !== 0 ? @num_format($final_stats['bank_deposit'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #f5c6cb;">
                        <th colspan="2">Total Bank Withdrawal</th>
                        <td colspan="2">{{ $final_stats['bank_withdrow'] !== 0 ? @num_format($final_stats['bank_withdrow'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #c3e6cb;">
                        <th colspan="2">Un Balance Cash</th>
                        <td colspan="2"><span class="un-balance-cash">{{ $final_stats['un_balance'] !== 0 ? @num_format($final_stats['un_balance'])  : '0.00' }}</span></td>
                    </tr>
                    <tr style="background-color: #b5c6cb;">
                        <th colspan="2">Total Bank Balance</th>
                        <td colspan="2">{{ $final_stats['final_bank_balance'] !== 0 ? @num_format($final_stats['final_bank_balance'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #b5c6cb;">
                        <th colspan="2">Total Cash Balance</th>
                        <td colspan="2">{{ $final_stats['balance'] !== 0 ? @num_format($final_stats['balance'])  : '0.00' }}</td>
                    </tr>
                    <tr style="background-color: #b5c6cb;">
                        <th colspan="2">Grand Total</th>
                        <td colspan="2"><span class="final_total">{{ $final_stats['grand_total'] !== 0 ? @num_format($final_stats['grand_total'])  : '0.00' }}</span></td>
                    </tr>
                </tfoot>
            </table>
            <br>
            <!-- {!! Form::open(['url' => action('AccountingController@store'), 'method' => 'post']) !!}
            {!! Form::hidden('date', request()->get('date') ? @format_date(request()->get('date')) : @format_date('now'), ['class' => 'form-control', 'readonly', 'required', 'id' => 'filter_date']); !!}
            {!! Form::hidden('user_id', request()->get('user_id'), ['class' => 'form-control input_number', 'placeholder' => __( 'cash_register.total_cash' ) ]); !!}
            <div class="row">
            {!! Form::hidden('closing_amount', $final_stats['balance'] !== 0 ? @num_format($final_stats['balance'])  : 0, ['class' => 'form-control input_number closing-amount', 'required', 'placeholder' => __( 'cash_register.total_cash' ) ]); !!}
            {!! Form::hidden('bank_total', $final_stats['final_bank_balance'] !== 0 ? @num_format($final_stats['final_bank_balance'])  : 0, ['class' => 'form-control input_number bank_total', 'required', 'placeholder' => __( 'cash_register.total_cash' ) ]); !!}
                <div class="col-sm-4">
                    <div class="form-group">
                        {!! Form::label('grand_total', 'Total(Cash in Hand):') !!}
                        {!! Form::text('grand_total', $final_stats['balance'] !== 0 ? $final_stats['balance']  : 0, ['class' => 'form-control input_number', 'id' => 'closing_grand_total' ]); !!}
                    </div>
                </div>
                <div class="col-sm-4">
                    {!! Form::hidden('adnormal_balance', 0, ['class' => 'form-control adnormal_balance', 'placeholder' => 'Unbalance Amount', 'id' => 'unbalance-amount-two' ]); !!}
                    <div class="form-group">
                        {!! Form::label('balance', 'Unbalance Amount:') !!}
                        {!! Form::number('balance', 0, ['class' => 'form-control adnormal_balance', 'placeholder' => 'Unbalance Amount', 'id' => 'unbalance-amount', 'disabled' ]); !!}
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <button type="submit" class="btn btn-primary">Save</button>
                    <a href="#" class="print-receipt  btn btn-info" data-href="{{route('account.user-balance.receipt')}}" class="btn btn-primary">Print</a>
                </div>    
            </div>    
            {!! Form::close() !!} -->
        </div>
    </div>

    <div class="modal fade bank_modal" tabindex="-1" role="dialog" 
    	aria-labelledby="gridSystemModalLabel">
    </div>

</section>
@endsection
@section('javascript')
    <script type="text/javascript">
    $('#filter_date').datepicker({
		autoclose: true,
		format: datepicker_date_format
	});
    $('input#closing_grand_total').change(function (e) {
        var total = 0;
        var amount = __read_number($('input.closing-amount'));
        total =  __read_number($('input#closing_grand_total')) - amount;

        $('input#unbalance-amount').val(total);
        $('input#unbalance-amount-two').val(total);
        $('.un-balance-cash').html(total.toFixed(2));
        $grandTotall =  __read_number($('input.closing-amount'));
        $bankTotal =  __read_number($('input.bank_total'));
        $final = total + $grandTotall + $bankTotal;
        $('.final_total').html($final.toFixed(2));
    });
    </script>
@endsection