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

@php
    $pageNo = isset($_GET['page']) ? $_GET['page'] : 1;
    $moduleSelected = isset($_GET['filModule']) ? $_GET['filModule'] : null;
    $funSelected = isset($_GET['filFunction']) ? $_GET['filFunction'] : null;
    $subFunSelected = isset($_GET['filSubFunction']) ? $_GET['filSubFunction'] : null;
@endphp

<style type="text/css">
    #searchButton{
        font-size: 12px;
        margin-top: 20px;
    }
</style>

<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('addRouteOperation/')}}" class="btn btn-info pull-right addViewBtn"><i class="glyphicon glyphicon-plus-sign addIcon"></i>Add Route Operation</a>
          </div>
          <h1 align="center" style="font-family: Antiqua;letter-spacing: 2px"><font color="white">ROUTE OPERATION LIST</font></h1>
        </div>
        <div class="panel-body panelBodyView"> 

         <!-- Filtering Start-->
                {!! Form::open(array('url' => 'viewRouteOperation', 'role' => 'form', 'class'=>'form-horizontal form-groups', 'id' => 'filterFormId', 'method'=>'get')) !!}
                <div class="row">
                    <div class="col-md-12">

                        <div class="col-md-1">
                            <div class="form-group">
                                <div class="col-md-12">
                                    {!! Form::label('', 'Module:', ['class' => 'control-label pull-left']) !!}
                                </div>
                                <div class="col-md-12">
                                    {!! Form::select('filModule', $moduleList, $moduleSelected ,['id'=>'filModule','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                                </div>
                            </div>
                        </div>

                        <div class="col-md-1">
                            <div class="form-group">
                                <div class="col-md-12">
                                    {!! Form::label('', 'Function:', ['class' => 'control-label pull-left']) !!}
                                </div>
                                <div class="col-md-12">
                                    {!! Form::select('filFunction', $functionList, $funSelected ,['id'=>'filFunction','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                                </div>
                            </div>
                        </div>

                        <div class="col-md-1">
                            <div class="form-group">
                                <div class="col-md-12">
                                    {!! Form::label('', 'Sub Fun.:', ['class' => 'control-label pull-left']) !!}
                                </div>
                                <div class="col-md-12">
                                    {!! Form::select('filSubFunction', $subFunctionList, $subFunSelected ,['id'=>'filSubFunction','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                                </div>
                            </div>
                        </div>

                       
                        <div class="col-md-1">
                            <div class="form-group">
                                {!! Form::label('', '', ['class' => 'control-label col-md-12']) !!}
                                <div class="col-md-12">
                                    {!! Form::submit('Search', ['id' => 'searchButton', 'class' => 'btn btn-primary btn-xs']); !!}
                                </div>
                            </div>
                        </div>

                    </div>
                </div>

                
                <!-- filtering end-->


       {{--  <div>
          <script type="text/javascript">
          jQuery(document).ready(function($)
          {
            
            $("#routeOperationView").dataTable({
                "oLanguage": {
                "sEmptyTable": "No Records Available",
                "sLengthMenu": "Show _MENU_ "
                },
                "lengthMenu": [[100, -1], [100, "All"]]
            });

          });
          </script>
        </div> --}}
          <table class="table table-striped table-bordered" id="routeOperationView">
            <thead>
                  <tr>
                    <th width="60">SL#</th>
                    <th>Route Name</th>
                    <th>Module Name</th>
                    <th>Function Name</th>
                    <th>Sub Function Name</th>
                    <th>Description</th>
                    <th>Action</th>
                  </tr>
                </thead>
                <tbody>
                                        @foreach($routeOperations as $routeOperation)

                        @php
                            $moduleName = DB::table('gnr_module')->where('id',$routeOperation->moduleIdFK)->value('name');
                            $functionName = DB::table('gnr_function')->where('id',$routeOperation->functionIdFK)->value('name');
                            $subfunctionName = DB::table('gnr_sub_function')->where('id',$routeOperation->subFunctionIdFK)->value('subFunctionName');
                        @endphp

                        <td class="text-center slNo">{{ ($pageNo-1)*50 + $no++ }}</td>
                        <td class="name">{{$routeOperation->routeName}}</td>
                        <td class="name">{{$moduleName}}</td>
                        <td class="name">{{$functionName}}</td>
                        <td class="name">{{$subfunctionName}}</td>
                        <td class="name">{{$routeOperation->description}}</td>
                        
                        
                        <td class="text-center" width="80">
                          <a href="javascript:;" class="edit-modal" funId="{{$routeOperation->id}}" funRouteName="{{$routeOperation->routeName}}" funModuleId="{{$routeOperation->moduleIdFK}}" funFunctionId="{{$routeOperation->functionIdFK}}" funSubFunctionId="{{$routeOperation->subFunctionIdFK}}" funDescription="{{$routeOperation->description}}">
                            <span class="glyphicon glyphicon-edit"></span>
                          </a>&nbsp
                          <a href="javascript:;" class="delete-modal" funId="{{$routeOperation->id}}">
                            <span class="glyphicon glyphicon-trash"></span>
                          </a>
                        </td>
                      </tr>
                    @endforeach
                </tbody>  
          </table>
            <div style="text-align:right;">
                {{ $routeOperations->appends(request()->input())->links() }}
            </div>
        </div>
        {!! Form::close()  !!}
      </div>
  </div>
</div>
</div>
</div>



{{-- Edit Modal --}}
<div id="editModal" 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">Update Route Operation</h4>
            </div>
            <div class="modal-body">

                <div class="row" style="padding-bottom: 20px;">

                
                {!! Form::open(['url'=>'','class'=>'form-horizontal form-groups']) !!}
                    <div class="col-md-12">                    
                    {!! Form::hidden('EMrouteOperationId',null,['id'=>'EMrouteOperationId']) !!}

                    <div class="form-group">
                        {!! Form::label('routeName', 'Route Name:', ['class' => 'col-sm-4 control-label']) !!}
                        <div class="col-sm-8">
                            {!! Form::text('routeName', $value = null, ['class' => 'form-control', 'id' => 'routeName', 'type' => 'text', 'placeholder' => 'Enter Route Name']) !!}
                        </div>
                    </div>

                    <div class="form-group">
                        {!! Form::label('moduleId', 'Module:', ['class' => 'col-sm-4 control-label']) !!}
                        <div class="col-sm-8">
                            @php
                                $moduleId = array('' => 'Select module') + DB::table('gnr_module')->pluck('name','id')->all(); 
                            @endphp  
                            {!! Form::select('moduleId', ($moduleId), null, array('class'=>'form-control', 'id' => 'moduleId')) !!}
                        </div>
                    </div>

                    <div class="form-group">
                        {!! Form::label('functionId', 'Function Name:', ['class' => 'col-sm-4 control-label']) !!}
                        <div class="col-sm-8">
                            @php
                                $functionId = array('' => 'Select Function') + DB::table('gnr_function')->pluck('name','id')->all(); 
                            @endphp  
                            {!! Form::select('functionId', ($functionId), null, array('class'=>'form-control', 'id' => 'functionId')) !!}
                        </div>
                    </div>
                    

                    <div class="form-group">
                        {!! Form::label('subFunctionId', 'Sub Function 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_16_05_2024/views/gnr/routeOperation/viewRouteOperation.blade.php:207
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/resources_16_05_2024/views/gnr/routeOperation/viewRouteOperation.blade.php</b> on line <b>207</b><br />