@extends('layouts/acc_layout')
@section('title', '| Bank Account Register')
@section('content')
@include('successMsg')

<style>
    .acClosingDate{
        color: red;
    }
    .acClosingDate input{
        color: red;
        border: 1px solid red;
    }
    .acClosingDate input::placeholder {
        color: red;
    }
</style>

<div class="row add-data-form">
    <div class="col-md-1"></div>
    <div class="col-md-10 fullbody">
        <div class="viewTitle" style="border-bottom: 1px solid white;">
            <a href="{{url('bankAcRegister/bankAcRegisterListFiltering/')}}" class="btn btn-info pull-right addViewBtn"><i class="glyphicon glyphicon-th-list viewIcon">
            </i>View Bank Account List</a>
        </div>

        <div class="panel panel-default panel-border">
            <div class="panel-heading">
                <div class="panel-title">Add Bank Account</div>
            </div>
            <div class="panel-body">

                @if($BankAcRegisters->approveStatus == 0)
                    <div class="row">
                        <div class="col-md-12">
                        {!! Form::open(array('url' => '','id'=>'entryForm', 'role' => 'form', 'class'=>'form-horizontal form-groups')) !!}
                        <div class="col-md-6">
                            <div class="form-group">
                                {!! Form::label('projectId', 'Project:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-9">
                                    @php
                                        $projectIds = DB::table('gnr_project')->select('id','name','projectCode')->get();
                                    @endphp
                                    <select class="form-control" id="projectId" name="projectId" >
                                        <option value="">Select Project</option>
                                        @foreach($projectIds as $projectId)
                                            <option value="{{$projectId->id}}" @if($projectId->id == $BankAcRegisters->projectId) selected= "selected" @endif>{{str_pad($projectId->projectCode,3,'0',STR_PAD_LEFT).' - '.$projectId->name}}</option>
                                        @endforeach
                                    </select>
                                    <p id='projectIde' style="max-height:3px;"></p>
                                </div>
                            </div>
                            <div class="form-group">
                                {!! Form::label('projectTypeId', 'Project Type:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-9">
                                    @php
                                        $projectTypeIds = DB::table('gnr_project_type')->select('id','name','projectTypeCode')->get();
                                    @endphp
                                    <select class="form-control" id="projectTypeId" name="projectTypeId" >
                                        <option value="">Select Project</option>
                                        @foreach($projectTypeIds as $projectTypeId)
                                            <option value="{{$projectTypeId->id}}" @if($projectTypeId->id == $BankAcRegisters->projectTypeId) selected= "selected" @endif>{{str_pad($projectTypeId->projectTypeCode,3,'0',STR_PAD_LEFT).' - '.$projectTypeId->name}}</option>
                                        @endforeach
                                    </select>
                                    <p id='projectTypeIde' style="max-height:3px;"></p>
                                </div>
                            </div>
                            <div class="form-group">
                                {!! Form::label('branchId', 'Assign Branch:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-9">
                                    @php
                                        $branchIds = DB::table('gnr_branch')->selectRaw('id, CONCAT(LPAD(branchCode, 3, "0"), " - ", name) AS formatted_branch')->get();
                                        $branchArray = json_decode(json_encode($branchIds), true);
                                        array_unshift($branchArray, ['id' => 0, 'formatted_branch' => 'All (with HO)']);
                                        array_unshift($branchArray, ['id' => -1, 'formatted_branch' => 'All (without HO)']);
                                        $branchIds = json_decode(json_encode($branchArray));

                                        //dd($branchIds);
                                    @endphp
                                    <select class="form-control" id="branchId" name="branchId" >
                                        <option value="">Select Branch</option>
                                        @foreach($branchIds as $branchId)
                                            <option value="{{$branchId->id}}" @if($branchId->id == $BankAcRegisters->branchId) selected= "selected" @endif>
                                                {{$branchId->formatted_branch}}
                                            </option>
                                        @endforeach
                                    </select>
                                    <p id='branchIde' style="max-height:3px;"></p>
                                </div>
                            </div>
                            <div class="form-group">
                                {!! Form::label('operateBranchId', 'Operate Branch:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-9">
                                    @php
                                        $operateBranchIds = DB::table('gnr_branch')->selectRaw('id, CONCAT(LPAD(branchCode, 3, "0"), " - ", name) AS formatted_branch')->get();
                                        $branchArray = json_decode(json_encode($operateBranchIds), true);
                                        array_unshift($branchArray, ['id' => 0, 'formatted_branch' => 'All (with HO)']);
                                        array_unshift($branchArray, ['id' => -1, 'formatted_branch' => 'All (without HO)']);
                                        $operateBranchIds = json_decode(json_encode($branchArray));

                                        // dd($branchIds);
                                    @endphp
                                    <select class="form-control" id="operateBranchId" name="operateBranchId" >
                                        <option value="">Select Branch</option>
                                        @foreach($operateBranchIds as $operateBranchId)
                                            <option value="{{$operateBranchId->id}}" @if($operateBranchId->id == $BankAcRegisters->operateBranchId) selected= "selected" @endif>
                                                {{$operateBranchId->formatted_branch}}
                                            </option>
                                        @endforeach
                                    </select>
                                    <p id='branchIde' style="max-height:3px;"></p>
                                </div>
                            </div>

                            <div class="form-group">
                                {!! Form::label('ledgerId', 'Ledger Account:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-9">
                                    @php
                                       $ledgerAccounts = DB::table('acc_account_ledger')
                                        ->where('accountTypeId', 5)
                                        ->orderBy('code', 'asc')
                                        ->select(DB::raw("CONCAT(code, ' - ', name) AS nameWithCode"), 'id')
                                        ->get();
                                    @endphp
                                    <select class="form-control" id="ledgerId" name="ledgerId">
                                        <option value="">Select Ledger Account</option>
                                        @foreach($ledgerAccounts as $ledgerAccount)
                                            <option value="{{$ledgerAccount->id}}" @if($ledgerAccount->id == $BankAcRegisters->ledgerIdFk) selected= "selected" @endif>{{$ledgerAccount->nameWithCode}}</option>
                                        @endforeach
                                    </select>
                                    <p id='ledgeride' style="max-height:3px;"></p>
                                </div>
                            </div>


                            <div class="form-group">
                                {!! Form::label('acTypeId', 'Account Type:', ['class' => 'col-sm-3 control-label']) !!}
                                <div class="col-sm-9">
                                    <br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DB&quot; not found in /home/shikkhaplus/public_html/morning_bird_bk/resources/views/accounting/bankAc/bankAcRegister/editItem.blade.php:140
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/morning_bird_bk/resources/views/accounting/bankAc/bankAcRegister/editItem.blade.php</b> on line <b>140</b><br />