@extends('layouts/gnr_layout')
@section('title', '| Branch')
@section('content')
@include('successMsg')


@php
  $branchIdsFromEmployeeTable = DB::table('hr_emp_org_info')->distinct()->pluck('branch_id_fk')->toArray();

  $branchIdsFromLedgerTable = array();
  $ledgers = DB::table('acc_account_ledger')->select('projectBranchId')->get();

  foreach ($ledgers as $ledger) {
    $projectBranchIdString = str_replace(["[","]","\""],"",$ledger->projectBranchId);
    $firstResultArray = explode(',',$projectBranchIdString);

    foreach ($firstResultArray as $firstResult) {
      $secondResultArray = explode(':',$firstResult);      
      array_push($branchIdsFromLedgerTable, (int) $secondResultArray[1]);
    }
  }
  
  $branchIdsFromLedgerTable = array_unique($branchIdsFromLedgerTable);
  $branchIdsFromLedgerTable = array_diff($branchIdsFromLedgerTable,[0]);

  $foreignBranchIds = array_merge($branchIdsFromEmployeeTable, $branchIdsFromLedgerTable);
  $foreignBranchIds = array_unique($foreignBranchIds);
  
@endphp




<div class="row">
<div class="col-md-12">
<div class="" style="">
    <div class="">
      <div class="panel panel-default" style="background-color:#708090;">
        <div class="panel-heading" style="padding-bottom:0px">
          <div class="panel-options">
              <a href="{{url('addBranch/')}}" class="btn btn-info pull-right addViewBtn"><i class="glyphicon glyphicon-plus-sign addIcon"></i>Add Branch</a>
          </div>
          <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">BRANCH LIST</font></h1>
        </div>
        <div class="panel-body panelBodyView"> 
        <div>
          <script type="text/javascript">
          jQuery(document).ready(function($)
          {
            $("#gnrBranchView").dataTable().yadcf([
    
            ]);
          });
          </script>
        </div>
          <table class="table table-striped table-bordered" id="gnrBranchView">
                    <thead>
                        <tr>
                          <th width="30">SL#</th>
                          <th style="text-align:center">B. Code</th>
                          <th style="text-align:center">Branch Name</th>
                          <th style="text-align:center">Contact Person</th>
                          <th style="text-align:center">Phone</th>
                          <th style="text-align:center">Address</th>
                          <th style="text-align:center">B. Start Date</th>
                          <th style="text-align:center">S. Start Date</th>
                          <th style="text-align:center">L. Day End Close</th>
                          <th style="text-align:center">Status</th>
                          <th width="45" style="text-align:center">Action</th>
                        </tr>
                          {{ csrf_field() }}
                    </thead>
                    <tbody> 
                                              @foreach($branchs as $branch)
                            <tr class="item{{$branch->id}}">
                              <td class="text-center slNo">{{++$no}}</td>
                              <td>{{$branch->branchCode}}</td>
                              <td style="text-align:left">&nbsp;{{$branch->name}}</td>
                              <td style="text-align:left">&nbsp;{{$branch->contactPerson}}</td>
                              <td>{{$branch->phone}}</td>
                              <td style="text-align:left">&nbsp;{{$branch->address}}</td>
                              <td>
                                <br />
<b>Warning</b>:  Undefined variable $branch in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>85</b><br />
<br />
<b>Warning</b>:  Attempt to read property "branchOpeningDate" on null in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>85</b><br />
<br />
<b>Deprecated</b>:  strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>86</b><br />
1970-01-01                              </td>
                              <td>
                                <br />
<b>Warning</b>:  Undefined variable $branch in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>91</b><br />
<br />
<b>Warning</b>:  Attempt to read property "softwareStartDate" on null in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>91</b><br />
<br />
<b>Deprecated</b>:  strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>92</b><br />
1970-01-01                              </td>
                              <td>1</td>
                              <td> 
                                  <br />
<b>Warning</b>:  Undefined variable $branch in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>98</b><br />
<br />
<b>Warning</b>:  Attempt to read property "status" on null in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>98</b><br />
<i style='background-color:red; border-radius:50%; 
                                                  font-size:16px; padding:3px; padding-right:5px;  padding-left:5px; color:white;' class='fa fa-times'
                                                  aria-hidden='true'></i>                              </td>
                              <td class="text-center" width="80">
                                <a href="javascript:;" class="edit-modal" data-id="{{$branch->id}}" data-name="{{$branch->name}}" data-branchcode="{{$branch->branchCode}}" data-groupid="{{$branch->groupId}}" data-companyid="{{$branch->companyId}}" data-projectid="{{$branch->projectId}}" data-projecttypeid="{{$branch->projectTypeId}}" data-contactperson="{{$branch->contactPerson}}" data-email="{{$branch->email}}" data-phone="{{$branch->phone}}" data-address="{{$branch->address}}" data-branchopeningdate="{{$branchOpeningDate}}" data-softwarestartdate="{{$softwareStartDate}}" data-status="{{$branch->status}}" data-slno="{{$no}}">
                                  <span class="glyphicon glyphicon-edit"></span>
                                </a>&nbsp


                                @php
                                  if (in_array($branch->id, $foreignBranchIds)) {
                                    $canDelete = 0;
                                  }
                                  else{
                                    $canDelete = 1;
                                  }   
                                @endphp

                                <a href="javascript:;" class="delete-modal" data-id="{{$branch->id}}" @php if($canDelete==0){ echo "style=\"pointer-events: none;cursor: not-allowed;\"";}@endphp>
                                  <span class="glyphicon glyphicon-trash"></span>
                                </a>
                              </td>
                            </tr>
                          @endforeach
                  </tbody>  
          </table>
        </div>
      </div>
  </div>
  </div>
</div>
</div>


<div id="myModal" class="modal fade" style="margin-top:3%">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
          <h4 class="modal-title" style="clear:both"></h4>
      </div>
      <div class="modal-body">
        {!! Form::open(array('url' => '', 'role' => 'form', 'class'=>'form-horizontal form-groups')) !!}
                       <!-- <input type = "hidden" name = "_token" value = ""> -->
                        {!! Form::text('id', $value = null, ['class' => 'form-control hidden', 'id' => 'id', 'type' => 'text']) !!}
                         {!! Form::text('slno', $value = null, ['class' => 'form-control hidden', 'id' => 'slno', 'type' => 'text']) !!}
                       <div class="row">
                    <div class="col-md-6">    
                            <div class="form-group">
                                {!! Form::label('name', 'Branch Name:', ['class' => 'col-sm-4 control-label']) !!}
                                <div class="col-sm-8">
                                    {!! Form::text('name', $value = null, ['class' => 'form-control', 'id' => 'name', 'type' => 'text', 'placeholder' => 'Enter branch name']) !!}
                                    <p id='namee' style="max-height:3px;"></p>
                                </div>
                            </div>
                            <div class="form-group">
                                {!! Form::label('branchCode', 'Branch Code:', ['class' => 'col-sm-4 control-label']) !!}
                                <div class="col-sm-8">
                                    {!! Form::text('branchCode', $value = null, ['class' => 'form-control', 'id' => 'branchCode', 'type' => 'text', 'placeholder' => 'Enter branc code']) !!}
                                   <p id='branchCodee' style="max-height:3px;"></p>
                                </div>
                            </div>
                            <div class="form-group">
                                {!! Form::label('groupId', 'Group Name:', ['class' => 'col-sm-4 control-label']) !!}
                                <div class="col-sm-8">
                                    <br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DB&quot; not found in /home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php:171
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/resources/views/gnr/tools/companySetting/branch/viewBranch.blade.php</b> on line <b>171</b><br />