@extends('layouts.view')
@section('title','Query Builder')
@section('content')
<link href="{{ asset('plugins/datatables/dataTables.bootstrap4.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="{{ asset('plugins/datatables/buttons.bootstrap4.min.css') }}" rel="stylesheet" type="text/css" />
    <!-- Responsive datatable examples -->
    <link href="{{ asset('plugins/datatables/responsive.bootstrap4.min.css') }}" rel="stylesheet" type="text/css" />
<div class="container-fluid">
    <div class="row">
<div class="col-lg-3">
    <div class="card" style="margin-top: 15px;">
<h5 class="card-header bg-primary text-white mt-0"> Tables</h5>        <div class="menu-body card-body" >


            <ul class="nav" style="list-style: list;-webkit-box-orient: vertical;
    -webkit-box-direction: normal;
    -ms-flex-direction: column;
    flex-direction: column;">
                <form class="form-horizontal row-fluid" action="{{ route('execute_query') }}" method="post" enctype="multipart/form-data">
                    {{csrf_field()}}
                    <ul class="nav metismenu" style="list-style: list;-webkit-box-orient: vertical;
    -webkit-box-direction: normal;
    -ms-flex-direction: column;
    flex-direction: column;display:inline-block;">

                        <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Rig Details</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->


                        <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Current Operation </span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->



                          <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Detailed Operation</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->





                        <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Lost Time Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->
                        <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Comments  Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->
                         <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Lateral & TVD</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->
                         <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- MUD Data Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->

                         <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- MUD Treatment Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->


<li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Bit Data</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->


<li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Drill Strings Floats</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->

<li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Drill Strings </span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->


                         <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Miscellaneous Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->

                         <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Services Information Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->

                      <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Trucks/Boats Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->
                         <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Bulks Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->

                      <li class="nav-item">
                            <a class="nav-link" href="#"><span class="mt-0 header-title">- Repair Table</span><span class="menu-arrow"><i class="mdi mdi-chevron-right"></i></span></a>
                            <ul class="nav-second-level" style="text-align: left;" aria-expanded="false">
                                                           </ul>
                        </li><!--end nav-item-->

                    </ul>
                    <input type="hidden" name="user_id" id="user_id" value="{{Auth::user()->id}}">
                </form>
        </div></div>
</div>
        <div class="col-lg-7" style="margin-top: 15px;">
            <div class="row">
                <div class="col-lg-12">


                <div class="card" >
                    <h5 class="card-header bg-primary text-white mt-0"> Conditions</h5>
                    <div class="card-body">

                        <p id="success"></p>
                    </div></div>

            </div></div>
            <div class="row">
                <div class="col-lg-12">
                <div class="card" >
                    <h5 class="card-header bg-primary text-white mt-0"> Rigs And Date</h5>
                    <div class="card-body">
                      <label style="margin-right:10px;"> <span>Rig Name   : </span> <input class="form-control" type="text" id="reg_name" name="reg_name" value="" />
                      <span><code>For Multi Rigs Please Put Comma(,) between names.Example:Rig 1,Rig 2</code></span>
                            </label>
                            <button style="margin-top:-60px;" type="button" class="btn btn-info" data-toggle="modal" data-target="#exampleModal">
                               +
                            </button>


                            <div class="modal fade bs-example-modal-lg" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                <div class="modal-dialog" role="document">
                                    <div class="modal-content" >
                                        <div class="modal-header">
                                            <h5 class="modal-title mt-0" id="exampleModalLabel">Select Multi Rigs</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>

                                        </div>
                                        <div class="modal-body" style="height:400px;overflow:scroll;">
                                           <div class="row" style="margin-top:5px;">
                                               <table id="datatablebb" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Rig Name</th>
                                </tr>
                            </thead>
                                <tbody>