@extends('layouts/acc_layout')
@section('title', '|Advance Register')
@section('content')

          @php

            use App\Models\accounting\AccAdvRegisterType;
            use App\Models\accounting\AccAdvRegister;
            use App\Models\gnr\gnr_house_Owner;
            use App\Models\gnr\gnr_employee;
            use App\Models\gnr\gnr_supplier;
          @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">

      </div> <!--panel-options -->

       <h1 align="center" style="font-family: Antiqua;letter-spacing:2px;"><font color="white">ADVANCE RECEIVE LIST</font></h1>

      </div><!--panel-heading-->

      <div class="panel-body panelBodyView">
       <div>
        <script type="text/javascript">
          jQuery(document).ready(function($){
            $("#AdvReg").dataTable({
              "oLanguage": {
              "sEmptyTable": "No Records Available",
              "sLengthMenu": "Show _MENU_ "
              }

                  });
              });

        </script>
       </div>


    <table class="table table-striped table-bordered" id="AdvReg" style="color:black;">
                <thead>
                  <tr>
                    <th width="30">SL#</th>
                    <th>Receive Date</th>
                    <th>Name</th>
                    <th>Id</th>
                    <th>Advance Type</th>
                    <th>Project Name</th>
                    <th>Project Type</th>
                    <th>Receive Type</th>
                    <th>Receive Amount</th>
                    <th>Action</th>
                  </tr>
                </thead>

                   <tbody>

                     @foreach ($accAdvanceReceive as $index=>$accAdvanceReceive)

                        @php
                          $result='';
                            if($accAdvanceReceive->houseOwnerId) {
                              $houseOwner= DB::table('gnr_house_Owner')->where('id',$accAdvanceReceive->houseOwnerId)->value('houseOwnerName');
                              $result=$houseOwner;
                            }

                            elseif($accAdvanceReceive->supplierId) {
                              $supplir=DB::table('gnr_supplier')->where('id',$accAdvanceReceive->supplierId)->value('name');
                              $result =$supplir;
                            }
                            elseif($accAdvanceReceive->employeeId) {
                              $employee = DB::table('hr_emp_general_info')->where('id',$accAdvanceReceive->employeeId)->value('emp_name_english');
                              $result =$employee;
                            }
                            $advreceiveType= DB::table('acc_adv_register_type')->where('id',$accAdvanceReceive->regTypeId)->value('name');
                            $projectName= DB::table('gnr_project')->where('id',$accAdvanceReceive->projectId)->value('name');
                            $projectType= DB::table('gnr_project_type')->where('id',$accAdvanceReceive->projectTypeId)->value('name');

                       @endphp

                      @php
                           $name='';
                            if($accAdvanceReceive->employeeId>0) {
                                $employee =DB::table('hr_emp_general_info')->where('id',$accAdvanceReceive->employeeId)->value('emp_id');
                                $name= $employee;
                            }
                            elseif($accAdvanceReceive->supplierId>0) {
                                $supplier =DB::table('gnr_supplier')->where('id',$accAdvanceReceive->supplierId)->value('name');
                                $name= $supplier;
                            }

                      @endphp

                        <tr style:"float:left;">
                            <td>{{$index+1}}</td>
                            <td>{{date('d-m-Y',strtotime($accAdvanceReceive->receivePaymentDate))}}</td>
                            <td style="text-align:left;padding-left:2px;">{{$result}}</td>
                            <td style="text-align:left;padding-left:2px;">{{$name}}</td>
                            <td style="text-align:left;padding-left:2px;">{{$advreceiveType}}</td>
                            <td style="text-align:left;padding-left:2px;">{{$projectName}}</td>
                            <td style="text-align:left;padding-left:2px;">{{$projectType}}</td>
                            <td>

                                    @if($accAdvanceReceive->cashId>0)
                                        {{'Cash'}}
                                    @elseif($accAdvanceReceive->vaucharId)
                                        {{'Voucher'}}
                                    @elseif($accAdvanceReceive->bankId>0)
                                        {{'Bank'}}
                                    @endif

                            </td>

                            <td style="text-align:right;padding-left:2px;">{{ number_format($accAdvanceReceive->amount, 2)}}</td>
                            <td width="80"><a href="javascript:;" class="view-modal" advReceive="{{$accAdvanceReceive->id}}"><i class="fa fa-eye" aria-hidden="true"></i>
                                </a>&nbsp;
                                <a href="javascript:;" class="edit-modal" advReceive="{{$accAdvanceReceive->id}}"><span class="glyphicon glyphicon-edit"></span> </a>&nbsp;
                                <a href="javascript:;" class="delete-modal" advReceive="{{$accAdvanceReceive->id}}"><span class="glyphicon glyphicon-trash"></span>&nbsp;
                                </a>
                            </td>
                            

                      </tr>
                @endforeach
                     </tbody>
                      </table>
                </div>
            </div>
        </div>
     </div>
  </div>
</div>

<!-- View Model -->


 <div id="viewModal" class="modal fade" style="margin-top:3%">
   <div class="modal-dialog modal-sm">
     <div class="modal-content">
       <div class="modal-header">
         <h4 class="modal-title" style="clear:both;background-color:black;color:white; padding:10px;text-align:center">View Advance Receive Info</h4>
       </div>

    <div class="modal-body">
      <div class="row" style="padding-bottom: 20px;">
        <div class="col-md-12">
         <div class="col-md-12" style="padding-right:2%;">
          <div class="form-horizontal form-groups">
           <input id="VMadvReg" type="hidden" name="advRegId" value="">

             <div class="form-group">
              {!! Form::label('advReceive','AdvReceive Id', ['class' => 'col-sm-3 control-label']) !!}
              <div class="col-sm-1 control-label">: </div>
               <div class="col-sm-8">                                              {!! Form::text('advReceive', null,['id'=>'VMadvReceiveId','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='advReceivee' class="error" style=color: red;"></p>

                </div>

            </div>


        <div class="form-group">

          {!! Form::label('project','Project Name', ['class' => 'col-sm-3 control-label']) !!}
          <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
               {!! Form::text('project', null,['id'=>'VMproject','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='projecte' class="error" style=color: red;"></p>
            </div>
        </div>

        <div class="form-group">

          {!! Form::label('projectType','Project Type Name', ['class' => 'col-sm-3 control-label']) !!}
          <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
               {!! Form::text('projectType', null,['id'=>'VMprojectType','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='projectTypee' class="error" style=color: red;"></p>
            </div>
        </div>

         <div class="form-group">
           {!! Form::label('advRegType','Advance Type', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
              {!! Form::text('advRegType', null,['id'=>'VMregType','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='advRegType' class="error" style=color: red;"></p>
            </div>
        </div>

         <div class="form-group">
           {!! Form::label('paymentId','Advance Payment Id', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
              {!! Form::text('paymentId', null,['id'=>'VMpaymentId','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='paymentIde' class="error" style=color: red;"></p>
            </div>
        </div>

        <div class="form-group" id="VMemployeeName1">
           {!! Form::label('employeeName','Employee Name', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label" id="employee1">: </div>
            <div class="col-sm-8">
              {!! Form::text('employeeName', null,['id'=>'VMemployeeName','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='employeeName' class="error" style=color: red;"></p>
            </div>
        </div>


        <div class="form-group" id="VMsupplierName1">
            {!! Form::label('supplierName','Supplier Name', ['class' => 'col-sm-3 control-label']) !!}
            <div class="col-sm-1 control-label" id="supplier1">: </div>
             <div class="col-sm-8">
               {!! Form::text('supplierName', null,['id'=>'VMsupplierName','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
                <p id='supplierName' class="error" style=color:red;"></p>
             </div>
        </div>
        <div class="form-group" id="VMhouseOwnerName1">
            {!! Form::label('houseOwnerName','House Owner Name', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label" id="houseOwner1">: </div>
           <div class="col-sm-8">
               {!! Form::text('houseOwnerName', null,['id'=>'VMhouseOwnerName','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='houseOwnerName' class="error" style=color:red;"></p>
           </div>
        </div>
        <div class="form-group" id="VMcash1">
             {!! Form::label('cash','Cash', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label" id="cash1">: </div>
           <div class="col-sm-8">
              {!! Form::text('cash', null,['id'=>'VMcash','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='cash' class="error" style=color:red;"></p>
           </div>
        </div>
        <div class="form-group" id="VMhVauchar1" style="display:none;">
              {!! Form::label('vauchar','Voucher', ['class' => 'col-sm-3 control-label']) !!}
             <div class="col-sm-1 control-label" id="vauchar1">: </div>
             <div class="col-sm-8">
                 {!! Form::text('vauchar', null,['id'=>'VMvauchar','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
                 <p id='vauchar' class="error" style=color:red;"></p>
             </div>
        </div>
        <div class="form-group" id="VMhBank1">
              {!! Form::label('bank','Bank', ['class' => 'col-sm-3 control-label']) !!}
             <div class="col-sm-1 control-label" id="bank1">: </div>
             <div class="col-sm-8">
                {!! Form::text('bank', null,['id'=>'VMbank','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
                <p id='bank' class="error" style=color:red;"></p>
             </div>
        </div>
        <div class="form-group">
          {!! Form::label('amount','Amount', ['class' => 'col-sm-3 control-label']) !!}
            <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
               {!! Form::text('amount', null,['id'=>'VMamount','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='amount' class="error" style="color:red;"></p>
            </div>
        </div>
        <div class="form-group">
            {!! Form::label('paymentDate','Payment Date', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label">: </div>
           <div class="col-sm-8">
              {!! Form::text('paymentDate', null,['id'=>'VMhpaymentDate','class'=>'form-control datepicker','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='paymentDate' class="error" style="color: red;"></p>
           </div>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-danger " data-dismiss="modal"><span class="glyphicon glyphicon-remove" style="padding-right:4px;"></span>Close</button>
        </div>

                        </div>
                      </div>
                  </div>
                </div>
             </div><!-- end Body -->
          <div class="col-md-3"></div>
        </div><!-- Model Content -->
    </div><!-- Modal Diolog -->
 </div><!-- ViewModal -->

{{--                           Edit Modal                       --}}

  <div id="editModal" 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;background-color:black;color:white; padding:10px;text-align:center;">Update Advance Receive</h4>
    </div>

 <div class="modal-body">
  <div class="panel-body float-left">
    <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-12">
           <input id="EMadvReceiveId" type="hidden"  value=""/>
        <div class="form-group">
            {!! Form::label('advReceiveId', 'Advance Receive Id', ['class' => 'col-sm-3 control-label']) !!}
          <div class="col-sm-1 control-label"> :</div>
            <div class="col-sm-8">
                {!! Form::text('advReceiveId',null, ['class'=>'form-control', 'id' => 'EMadvRecId','readonly']) !!}
            </div>
        </div>


        <div class="form-group">

          {!! Form::label('project','Project Name', ['class' => 'col-sm-3 control-label']) !!}
          <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
               {!! Form::text('project', null,['id'=>'EMproject','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='projecte' class="error" style=color: red;"></p>
            </div>

        </div>

         <div class="form-group">

          {!! Form::label('projectType','Project Type Name', ['class' => 'col-sm-3 control-label']) !!}
          <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
               {!! Form::text('projectType', null,['id'=>'EMprojectType','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='projecttypee' class="error" style=color: red;"></p>
            </div>

        </div>



        <div class="form-group">
           {!! Form::label('advRegType','Advance Type', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
              {!! Form::text('advRegType', null,['id'=>'EMregType','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='advRegType' class="error" style=color: red;"></p>
            </div>
        </div>
        <div class="form-group">
           {!! Form::label('paymentId','Advance Payment Id', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
              {!! Form::text('paymentId', null,['id'=>'EMpaymentId','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='paymentId' class="error" style=color: red;"></p>
            </div>
        </div>


        <div class="form-group" id="EMemployeeName1">
           {!! Form::label('employeeName','Employee Name', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label" id="employee1">: </div>
            <div class="col-sm-8">
              {!! Form::text('employeeName', null,['id'=>'EMemployeeName','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='employeeName' class="error" style=color: red;"></p>
            </div>

        </div>

        <div class="form-group" id="EMsupplierName1">
            {!! Form::label('supplierName','Supplier Name', ['class' => 'col-sm-3 control-label']) !!}
            <div class="col-sm-1 control-label" id="supplier1">: </div>
             <div class="col-sm-8">
               {!! Form::text('supplierName', null,['id'=>'EMsupplierName','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
                <p id='supplierName' class="error" style=color:red;"></p>
             </div>
        </div>

        <div class="form-group" id="EMhouseOwnerName1">
            {!! Form::label('houseOwnerName','House Owner Name', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label" id="houseOwner1">: </div>
           <div class="col-sm-8">
               {!! Form::text('houseOwnerName', null,['id'=>'EMhouseOwnerName','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
               <p id='houseOwnerName' class="error" style=color:red;"></p>
           </div>
        </div>

        <div class="form-group" id="EMcash1">
             {!! Form::label('cash','Cash', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label" id="cash1">: </div>
           <div class="col-sm-8">
              {!! Form::text('cash', null,['id'=>'EMcash','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='cash' class="error" style=color:red;"></p>
           </div>
        </div>

        <div class="form-group" id="EMhVauchar1" style="display:none;">
              {!! Form::label('vauchar','Voucher', ['class' => 'col-sm-3 control-label']) !!}
             <div class="col-sm-1 control-label" id="vauchar1">: </div>
             <div class="col-sm-8">
                 {!! Form::text('vauchar', null,['id'=>'EMvauchar','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
                 <p id='vauchar' class="error" style=color:red;"></p>
             </div>
        </div>

        <div class="form-group" id="EMhBank1">
              {!! Form::label('bank','Bank', ['class' => 'col-sm-3 control-label']) !!}
             <div class="col-sm-1 control-label" id="bank1">: </div>
             <div class="col-sm-8">
                {!! Form::text('bank', null,['id'=>'EMbank','class'=>'form-control','type' => 'text','autocomplete'=>'off','readonly']) !!}
                <p id='bank' class="error" style=color:red;"></p>
             </div>
        </div>


        <div class="form-group">
          {!! Form::label('amount','Amount', ['class' => 'col-sm-3 control-label']) !!}
            <div class="col-sm-1 control-label">: </div>
            <div class="col-sm-8">
               {!! Form::text('amount', null,['id'=>'EMamount','class'=>'form-control','type' => 'text','autocomplete'=>'off']) !!}
               <p id='amount' class="error" style="color:red;"></p>
            </div>
        </div>

        <div class="form-group">
            {!! Form::label('paymentDate','Payment Date', ['class' => 'col-sm-3 control-label']) !!}
           <div class="col-sm-1 control-label">: </div>
           <div class="col-sm-8">
              {!! Form::text('paymentDate', null,['id'=>'EMhpaymentDate','class'=>'form-control datepicker','type' => 'text','autocomplete'=>'off','readonly']) !!}
              <p id='paymentDate' class="error" style="color: red;"></p>
           </div>
        </div>

        <div class="modal-footer">
            <input id="DMadvReg" type="hidden" name="advReceive" value="">
            <button type="button" id="updateButton" class="btn btn-success"><span class="glyphicon glyphicon-edit" style="padding-right:4px;"></span>Update</button>
            <button type="button" class="btn btn-danger " data-dismiss="modal"><span class="glyphicon glyphicon-remove" style="padding-right:4px;"></span>Close</button>
        </div>

                    </div>
                  </div>
               </div>
            </div>
        </div>
     </div>
  </div>
 </div>


<!-- - - - - - - - - - - -Delete Model- - - - - - - - - - - - - -->

   <div id="deleteModal" class="modal fade" style="margin-top:3%;">
      <div class="modal-dialog modal-lg">
        <div class="modal-content">
          <div class="modal-header">
            <h4 class="modal-title" style="clear:both;background-color:black;color:white; padding:10px;text-align:center;">Delete Advance Receive</h4>
          </div>

         <div class="modal-body ">
           <div class="row" style="padding-bottom:20px;"> </div>
            <h2>Are You Confirm to Delete This Record?</h2>

          <div class="modal-footer">
             <input id="DMadvReceiveId" type="hidden"  value=""/>
             <button type="button" class="btn btn-danger"  id="DMadvRec"  data-dismiss="modal">confirm</button>
             <button type="button" class="btn btn-warning"  data-dismiss="modal"><span class="glyphicon glyphicon-remove" style="padding-right:4px;"></span>Close</button>
          </div>

         </div>
        </div>
      </div>
   </div>

{{--end delete modal--}}

<!--                          Project Change                     -->
<script>
          /* Change Project*/

   $(document).ready(function() {
        function pad (str, max) {
           str = str.toString();

           return str.length < max ? pad("0" + str, max) : str;
        }

     $("#EMprojectName").change(function() {
            var projectId = $(this).val();
            var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/guk_bk/resources/views/accounting/register/advRegister/advReceiveview.blade.php:482
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/accounting/register/advRegister/advReceiveview.blade.php</b> on line <b>482</b><br />