@extends('Admin.master_layout.master')

@section('title', getTitleInPage())

@section('header_menu')
@parent
@endsection

@section('sidebar_menu')
@parent
@endsection
@section('styles')

@parent
@endsection
@section('content')
<div id="content">
    <div id="content-header">
        <div id="breadcrumb"> 
            <a href="{{ url('/') }}" title="Go to Home" class="tip-bottom">
                <i class="icon-home"></i> Home
            </a> 
            <a href="{{ gotoback() }}" title="Go to Back" class="tip-bottom">
                Back
            </a>
            <a href="{{ url('cash-book-ledger') }}" title="Go to {{ getTitleInPage() }}" class="tip-bottom">
                {{ getTitleInPage() }}
            </a> 
            <a href="" class="current">
                Add
            </a> 
        </div>
        <h1>{{ getTitleInPage() }} </h1>
    </div>
    <form action="{{ url('cash-book-ledger') }}" method="post" class="form-horizontal" id="cashinhandFrm">
                    <input type="hidden" name="_token" value="{{ csrf_token() }}">
                    @if(!getMechantIds())
                    @if(count($enterprise) > 0)
                    <div class="control-group" style="float: left;border: 0;">
                        <label class="control-label">Select EnterPrise :</label>
                        <div class="controls">
                            <select name="enterprise_id" id="enterprise_id">
                                <option value="">All</option>
                                @foreach($enterprise as $enterprises)
                                <option value="{{ $enterprises->id }}" {{ ($enterprise_id==$enterprises->id)?'selected':'' }}>{{ $enterprises->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    @endif
                    <div class="control-group" style="float: left;border: 0;">
                        <label class="control-label">Select Merchant :</label>
                        <div class="controls">
                            <select name="ho_id" id="ho_id">
                                <option value="">All</option>
                                @foreach($merchant as $merchants)
                                <option value="{{ $merchants->id }}" {{ ($ho_id==$merchants->id)?'selected':'' }}>{{ $merchants->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    @else
                    <input type="hidden" name="ho_id" id="ho_id" value="{{ getHoId(Auth::user()->id) }}" />
                    @endif
                    <div class="control-group"  style="float: left;border: 0;width:39%">
                                <label class="control-label">Main/Parent Branch*:</label>
                                <div class="controls">
                                    <select name="parent_merchant_id" id="parent_merchant_id" class="searchdata span11">
                                        <option value="">All</option>
                                        @if(Auth::user()->is_ho_branch_show == 1)
                                        <option value="{{ getHoId(Auth::user()->id) }}" @if($parent_merchant_id == getHoId(Auth::user()->id) ) selected @endif> {{ getMechantShortCode(getHoId(Auth::user()->id)) }}-{{ getBranchCode(getHoId(Auth::user()->id)) }}-{{ getMechantName(getHoId(Auth::user()->id)) }}</option>
                                        @endif
                                        @foreach($parentMerchantId as $mercha)
                                        <option value="{{ $mercha->id }}" @if($parent_merchant_id == $mercha->id) selected @endif>{{ getMechantShortCode($mercha->id) }}-{{ $mercha->ashram_id }}-{{ $mercha->name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                    <div class="control-group"  style="float: left;border: 0;width:43%">
                                <label class="control-label">Sub Merchant*:</label>
                                <div class="controls">
                                    <select name="sub_merchant_id" id="sub_merchant_id" class="searchdata span11">
                                        <option value="">All</option>
                                        @foreach($subMerchantId as $mercha)
                                        <option value="{{ $mercha->id }}" @if($sub_merchant_id == $mercha->id) selected @endif>{{ $mercha->ashram_id }}-{{ $mercha->name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                    </div>
                    <div class="control-group"  style="float: left;border: 0;width:39%">
                                <label class="control-label">Fiscal Year*:</label>
                                <div class="controls">
                                    <select name="fiscal_year" id="fiscal_year" class="span3">
                                    @if(getMechantIds())
                                    @foreach(MerchantFiscalYearArray() as $year)
                                    <option value="{{ $year }}" {{ ($fiscal_year==$year || MerchantCurrentFiscalYear() == $year)?'selected':'' }} >{{ $year }}</option>
                                    @endforeach
                                    @else
                                    @foreach(fiscalYearArray() as $year)
                                    <option value="{{ $year }}" {{ ($fiscal_year==$year || MerchantCurrentFiscalYear() == $year)?'selected':'' }} >{{ $year }}</option>
                                    @endforeach
                                    @endif
                                    </select>
                                </div>
                            </div>
                            <div class="control-group"  style="float: left;border: 0;width:39%">
                                <label class="control-label">Month*:</label>
                                <div class="controls">
                                    <select name="from_month" id="from_month" class="span3">
                                        @foreach(getFinacialYearMonth() as $mon)
                                        <option value="{{ $mon['month'] }}" @if($from_month == $mon['month']) selected @endif>{{$mon['month_name'] }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <!--<div class="control-group"  style="float: left;border: 0;">
                                <label class="control-label">From :</label>
                                <div class="controls">
                                    <input type="text" data-date="01-02-2013" data-date-format="dd-mm-yyyy" value="{{ $from_date }}" class="datepicker fromDate" name="from">
                                    <span class="help-block">Date (dd-mm-yy)</span> </div>
                                </div>

                            <div class="control-group" style="float: left;border: 0;">
                                <label class="control-label">To :</label>
                                <div class="controls">
                                <input type="text" data-date="01-02-2013" data-date-format="dd-mm-yyyy" value="{{ $to_date }}" class="datepicker toDate" name="to">
                                <span class="help-block">Date (dd-mm-yy)</span> </div>
                            </div>-->
                            <div class="controls" style="border: 0;width: 25%;text-align: right;">
                                <button type="submit" class="btn btn-primary" id="stateSubmit">GO</button>
                            </div>
                 
                </form>
    <div class="container-fluid">
        <div class="row-fluid">
            <div class="span12">
                @foreach ($errors->all() as $error)
                <p class="alert alert-warning">{{ $error }}</p>
                @endforeach
                @if (Session::has('error'))
                <div class="alert alert-warning">{!! Session::get('error') !!}</div>
                @endif
                @if($ho_id > 0 && $parent_merchant_id > 0)
                <div class="widget-box">
                    <div class="widget-title"> <span class="icon"> <i class="icon-align-justify"></i> </span>
                        <h5>{{ getTitleInPage() }} </h5>
                    </div>
        <div class="widget-content nopadding">
        
        <table style="width: 100%; padding: 0;" cellspacing="0">
        
        <tr>
            
            <td style="text-align: center;" colspan="5"><b>{{ $getHo->receipt_number_prefix }}-{{ $getHo->ashram_id }} {{ $getHo->name }} ({{ $fiscal_year }})<br>
            {{ $parentMerchant->ashram_id }} Cash {{ $parentMerchant->full_address }} {{ getCityName($parentMerchant->city_id) }} {{ getStateName($parentMerchant->state_id) }} {{ getCountryName($parentMerchant->country_id) }} Book<br>
                
            <br><br>{{ date('d-M-Y', strtotime($from_date)) }} to {{ date('d-M-Y', strtotime($to_date)) }}</b>
        </td>
            
        </tr>
        <tr style="height: 50px;"></tr>
        <tr></tr>
        <tr>
            <td style="text-align: left;border: 1px solid #000;padding: 5px; border-right: 0;width: 10%;"><b>Date</b></td>
            <td style="text-align: left;border: 1px solid #000;padding: 5px;border-left: 0; border-right: 0;width: 48%;"><b>Particulars </b></td>
            <td style="text-align: left;border: 1px solid #000;padding: 5px;border-left: 0; border-right: 0;width: 10%;"><b>Vch Type</b></td>
            <td style="text-align: center;border: 1px solid #000;padding: 5px;border-left: 0; border-right: 0;width: 11%;"><b>Vch No.</b></td>
            <td style="text-align: left;border: 1px solid #000;padding: 5px;border-left: 0; border-right: 0;width: 10%;"><b>Debit</b></td>
            <td style="text-align: left;border: 1px solid #000;padding: 5px;border-left: 0;width: 10%; "><b>Credit</b></td>
        </tr>
        <tr>
        </tr>
        @if(count($openingArr) > 0)
        <tr>
            <td style="text-align: left;width: 10%;padding: 5px;">{{  date('d-m-Y', strtotime($openingArr['date'])) }}</td>
            <td style="text-align: left;width: 48%;padding: 5px;">{{ $openingArr['cr_dr_type'] }} {{ $openingArr['Particulars'] }}</td>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: center;width: 11%;padding: 5px;"></td>
            <td style="text-align: left;width: 10%;padding: 5px;">{{ $openingArr['dr'] }}</td>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
        </tr>
        @endif
        @if(count($orderArr) >  0)
        @foreach($orderArr as $key => $val)
        @if(count($val['OrderItems']) > 0)
        @foreach($val['OrderItems'] as $i => $v)
            @if(isset($v['totalItem']))
            <tr>
                <td style="text-align: left;width: 10%;padding: 5px;">@if($v['date'] != null) {{  date('d-m-Y', strtotime($v['date'])) }} @endif</td>
                <td style="text-align: left;width: 48%;padding: 5px;">{{ $v['cr_dr_type'] }} {{ $v['Particulars'] }}</td>
                <td style="text-align: left;width: 10%;padding: 5px;">{{  getMerchantVoucherType($v['voucher_type_id']) }}</td>
                <td style="text-align: center;width: 11%;padding: 5px;">{{ $v['order_id'] }}</td>
                <td style="text-align: left;width: 10%;padding: 5px;">@if($v['dr'] > 0) {{  $v['totalItem'] }} @endif</td>
                <td style="text-align: left;width: 10%;padding: 5px;">@if($v['cr'] > 0) {{  $v['totalItem'] }} @endif</td>
            </tr>
            @else
            <tr>
                <td style="text-align: left;width: 10%;padding: 5px;">@if($v['date'] != null) {{  date('d-m-Y', strtotime($v['date'])) }} @endif</td>
                <td style="text-align: left;width: 48%;padding: 5px;">@if($v['is_check_main'] == 0) {{ $v['cr_dr_type'] }} @else &nbsp;&nbsp;&nbsp; @endif @if($v['cr_dr_type'] == 'Cr') {{ getAccountHeadByIdMerchant($v['ledger_id']) }}<!--{{ getRahebarName($v['rahebar_id']) }}--> @else {{ getAccountHeadByIdMerchant($v['ledger_id']) }} @endif</td>
                <td style="text-align: @if($v['is_check_main'] != 0) right; @else left; @endif width: 10%;padding: 5px;">@if($v['is_check_main'] == 1) {{ $v['amount'] }} {{ $v['cr_dr_type'] }}  @else {{  getMerchantVoucherType($v['voucher_type_id']) }} @endif</td>
                <td style="text-align: center;width: 11%;padding: 5px;">@if($v['is_check_main'] == 0) {{ $v['order_id'] }} @endif</td>
                <td style="text-align: left;width: 10%;padding: 5px;">@if($v['dr'] > 0 && $v['is_check_main'] == 0) {{  $v['dr'] }} @endif</td>
                <td style="text-align: left;width: 10%;padding: 5px;">@if($v['cr'] > 0 && $v['is_check_main'] == 0) {{  $v['cr'] }} @endif</td>
            </tr>
            @endif
       
        @endforeach
        @else
        <tr>
            <td style="text-align: left;width: 10%;padding: 5px;">@if($val['date'] != null) {{  date('d-m-Y', strtotime($val['date'])) }} @endif</td>
            <td style="text-align: left;width: 48%;padding: 5px;">{{ $val['cr_dr_type'] }} @if($val['cr_dr_type'] == 'Cr') <!--{{ getRahebarName($val['rahebar_id']) }}-->{{ getAccountHeadByIdMerchant($val['ledger_id']) }} @else {{ getAccountHeadByIdMerchant($val['ledger_id']) }} @endif</td>
            <td style="text-align: left;width: 10%;padding: 5px;">{{  getMerchantVoucherType($val['voucher_type_id']) }}</td>
            <td style="text-align: center;width: 11%;padding: 5px;">{{ $val['order_id'] }}</td>
            <td style="text-align: left;width: 10%;padding: 5px;">@if($val['dr'] > 0) {{  $val['dr'] }} @endif</td>
            <td style="text-align: left;width: 10%;padding: 5px;">@if($val['cr'] > 0) {{  $val['cr'] }} @endif</td>
        </tr>
        @endif
        
        @endforeach
        @endif
        <tr>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: left;width: 48%;padding: 5px;"><b>Dr  <span style="margin-left: 50px;">Closing Balance</span></b></td>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: center;width: 11%;padding: 5px;"></td>
            <td style="text-align: left;border: 1px solid #000;border-left: 0; border-bottom: 0;border-right: 0;width: 10%;padding: 5px;"><b>{{$grandTotalDr}}</b></td>
            <td style="text-align: left;border: 1px solid #000;border-left: 0; border-bottom: 0;border-right: 0;width: 10%;padding: 5px;"><b>{{$grandTotalCr}}</b> </td>
        </tr>
        <tr>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: left;width: 48%;padding: 5px;"></td>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: center;width: 11%;padding: 5px;"></td>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: left;width: 10%;padding: 5px;"><b>{{ $grandTotalDr-$grandTotalCr}}</b></td>
        </tr>
        <tr>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: left;width: 48%;padding: 5px;"></td>
            <td style="text-align: left;width: 10%;padding: 5px;"></td>
            <td style="text-align: center;width: 11%;padding: 5px;"></td>
            <td style="text-align: left;border: 1px solid #000;border-left: 0; border-right: 0;width: 10%;padding: 5px;"><b>{{$grandTotalDr}}</b></td>
            <td style="text-align: left;border: 1px solid #000;border-left: 0; border-right: 0;width: 10%;padding: 5px;"><b>{{$grandTotalDr}}</b></td>
        </tr>
        
        </table>
        
                    </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('footer')
@parent
@endsection

@section('extraa_script_and_js')
<script type="text/javascript">
    
    $(document).ready(function () {
        $('select[name="parent_merchant_id"]').on('change', function() {
        var parent_merchant_id = $(this).val();
        if(parent_merchant_id) {
          $.ajax({
            url: "{{url('get-sub-branch')}}/"+parent_merchant_id,
            type: "GET",
            dataType: "json",
            success:function(data) {
              $('select[name="sub_merchant_id"]').empty();
              $('select[name="sub_merchant_id"]').append('<option value="">All</option>');
              $.each(data, function(key, value) {
               $('select[name="sub_merchant_id"]').append('<option value="'+ value.id +'">'+ value.receipt_number_prefix +'-'+value.ashram_id+'-'+value.name+'</option>');
              });
            }
          });
          
        }
      });
        $('select[name="enterprise_id"]').on('change', function () {
            $('#cashinhandFrm').submit();
        });
        $('select[name="ho_id"]').on('change', function () {
            $('#cashinhandFrm').submit();
        });
        $('select[name="parent_merchant_id"]').on('change', function () {
            $('#cashinhandFrm').submit();
        });      
    });
    

</script>
@parent
@endsection