@extends('layout.layout')
@section('breadcrumb')
  Formules de calcul
@endsection
@section('content')
@if(Session::has('message'))
    <div class="alert alert-success">
    {{Session::get('message')}}
    </div>
    @endif
<div id="report" class="pageForm">
                <div class="container-fluid mt-3">
                  <div class="row justify-content-center align-items-center g-5 mb-0">
                    <div class="col-6 d-flex">
                      <button type="button" id="tfFormules" class="pageNav active">Formules de calcul</button>
                      <button type="button" id="tfEnexamen" class="pageNav ">En examen</button>
                    </div>
                    <div class="col-6 text-end">
                      <a href="{{route('add-formula')}}" type="button" class="addNew" >
                        <div class="addIcon" >
                          <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewBox="0 0 22.664 22.663">
                            <path id="Tracé_201" data-name="Tracé 201" d="M27.5,16.67H18.332V7.5a.831.831,0,0,0-1.663,0V16.67H7.5a.827.827,0,0,0-.831.831.754.754,0,0,0,.831.781h9.169V27.5a.831.831,0,1,0,1.663,0V18.333H27.5a.831.831,0,1,0,0-1.663Z" transform="translate(-6.168 -6.17)" fill="#123055" stroke="#123055" stroke-width="1"/>
                          </svg>
                        </div>
                        Ajouter une formule
                      </a>
                    </div>
                  </div>

                  <div class="row justify-content-center g-5 mt-1" id="formules">
                    <form action="" method="get" class="row justify-content-center">
                    <div class="col-12 mb-0 mt-4">
                      Filtrer la recherche par :
                    </div>
                    <div class="col-4 mt-2">
                      <select name="periode" id="periode" class="form-select" required>
                      <option value="" disabled selected>Périodicité</option>
                      <br />
<b>Warning</b>:  Undefined variable $periodicites in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>38</b><br />
<br />
<b>Warning</b>:  foreach() argument must be of type array|object, null given in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>38</b><br />
                      </select>
                    </div>
                    @if(empty($categories))
                    <div class="col-4 mt-2">
                      <select id="rapport_1" class="form-select" name="excel_1" aria-label="Default select example" required>
                            <option selected value="">Selectionner</option>
                      </select>
                    </div>
                    @else
                    <div class="col-4 mt-2">
                      <select id="rapport_1" class="form-select" name="excel_1" aria-label="Default select example" required>
                            <option selected value="">Selectionner</option>
                            @foreach($categories as $categorie)
                            <option value="<br />
<b>Warning</b>:  Undefined variable $categorie in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>54</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>54</b><br />
" {{($categorie->id==$_GET['excel_1'])?'selected':''}}><br />
<b>Warning</b>:  Undefined variable $categorie in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>54</b><br />
<br />
<b>Warning</b>:  Attempt to read property "filetype_name" on null in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>54</b><br />
<br />
<b>Deprecated</b>:  ucfirst(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>54</b><br />
</option>
                            @endforeach
                      </select>
                    </div>
                    @endif
                    @if(empty($categoriesChild))
                    <div class="col-4 mt-2">
                      <select id="rapport_2" class="form-select" name="excel_2" aria-label="Default select example" required onchange="this.form.submit()">
                        <option selected value="">Selectionner</option>
                      </select>
                    </div>
                    @else
                    <div class="col-4 mt-2">
                      <select id="rapport_2" class="form-select" name="excel_2" aria-label="Default select example" required onchange="this.form.submit()">
                            <option selected value="">Selectionner</option>
                            @foreach($categoriesChild as $child)
                            <option value="<br />
<b>Warning</b>:  Undefined variable $child in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>70</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>70</b><br />
" {{($child->id==$_GET['excel_2'])?'selected':''}}><br />
<b>Warning</b>:  Undefined variable $child in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>70</b><br />
<br />
<b>Warning</b>:  Attempt to read property "filetype_name" on null in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>70</b><br />
<br />
<b>Deprecated</b>:  ucfirst(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>70</b><br />
</option>
                            @endforeach
                      </select>
                    </div>
                    @endif
                    </form>
                    <div class="col-12 mt-2">
                    <table class="table tf-strip border-light tf-table " id="formula">
                        <thead>
                            <tr>
                                <th scope="col"  scope="col" data-width="10%">Id</th>
                                <th scope="col"  scope="col" data-width="10%">Controle</th>
                                <th scope="col"  scope="col" data-width="10%">Controle name</th>
                                <th scope="col"  scope="col" data-width="10%" class="b-col">Excel 1</th>
                                <th scope="col"  scope="col" data-width="10%" class="b-col">Excel 2</th>
                                <th scope="col"  scope="col" data-width="80%" class="b-col">Formule</th>
                                <th scope="col"  scope="col" data-width="10%" class="b-col">Périodicité</th>
                                <th scope="col"  scope="col" data-width="10%" class="b-col">Modifier</th>
                                <th scope="col"  scope="col" data-width="10%" class="b-col">Supprimer</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($formulasLive as $formula)
                            @if(!is_null($formula->periodicite))
                            <tr>
                                <td>{{$formula->id}}</td>
                                <td>{{$formula->controle}}</td>
                                <td>{{$formula->controle_name}}</td>
                                <td>{{$formula->filetype_name1}}</td>
                                <td>{{$formula->filetype_name2}}</td>
                                <td class="field"><input type="text" value="{{$formula->formula_text}}" name="col1" class="form-control"></td>
                                <td>
                                    @if(!is_null($formula->periodicite))
                                    {{$formula->periodicite->period}}
                                    @endif
                                </td>
                                <td class="p-4"><a href="{{route('edit-formula',$formula->id)}}" ><svg id="edit_line" data-name="edit line" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 32 32">
                                  <path id="Tracé_111" data-name="Tracé 111" d="M31.138,8.2l-5.22-5.24a1.839,1.839,0,0,0-2.593,0L4.825,21.429,3.138,28.722a1.817,1.817,0,0,0,.36,1.533,1.838,1.838,0,0,0,1.42.687,1.81,1.81,0,0,0,.38,0l7.367-1.687L31.138,10.8A1.847,1.847,0,0,0,31.138,8.2ZM11.778,27.656,4.872,29.1l1.573-6.773L20.285,8.542l5.333,5.333ZM26.812,12.589,21.478,7.256l3.093-3.08,5.24,5.333Z" transform="translate(-1.032 -0.809)" fill="#181830"/>
                                  <path id="Tracé_113" data-name="Tracé 113" d="M0,0H32V32H0Z" fill="none"/>
                                </svg>
                                </a>
                                </td>
                                <td class="p-4">
                                  <form id="form-{{$formula->id}}" action="{{route('delete-formula')}}" method="post">
                                    @csrf
                                    <input type="hidden" name="formula_id" value="{{$formula->id}}"/>
                                    <svg onclick="$('#form-{{$formula->id}}').submit();" id="trash_line" data-name="trash line" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 32 32">
                                        <path id="Tracé_194" data-name="Tracé 194" d="M26.793,35.21H10.539A2.607,2.607,0,0,1,8,32.543V14.97h1.78V32.543a.833.833,0,0,0,.193.607.851.851,0,0,0,.567.287H26.793a.851.851,0,0,0,.567-.287.833.833,0,0,0,.193-.607V14.97h1.78V32.543a2.607,2.607,0,0,1-2.54,2.667Z" transform="translate(-2.666 -4.99)" fill="#181830"/>
                                        <path id="Tracé_195" data-name="Tracé 195" d="M29.137,11.11H6.223a.89.89,0,1,1,0-1.78H29.137a.89.89,0,0,1,0,1.78Z" transform="translate(-1.777 -3.11)" fill="#181830"/>
                                        <path id="Tracé_196" data-name="Tracé 196" d="M28,17.33h1.78V30.663H28Z" transform="translate(-9.333 -5.777)" fill="#181830"/>
                                        <path id="Tracé_197" data-name="Tracé 197" d="M17.33,17.33h1.78V30.663H17.33Z" transform="translate(-5.777 -5.777)" fill="#181830"/>
                                        <path id="Tracé_198" data-name="Tracé 198" d="M26.223,6.1H24.53V4.443H19.023V6.1H17.33V4.443A1.779,1.779,0,0,1,19.023,2.67H24.53a1.779,1.779,0,0,1,1.693,1.773Z" transform="translate(-5.777 -0.89)" fill="#181830"/>
                                        <path id="Tracé_200" data-name="Tracé 200" d="M0,0H32V32H0Z" fill="none"/>
                                    </svg>
                                  </form>
                                </td>
                            </tr>
                            @endif
                            @endforeach
                        </tbody>
                    </table>
                    </div>
                  </div>
                  <div class="row justify-content-center g-5 mt-1 d-none" id="enexamen">
                    <div class="col-12 mt-4">
                      <div class="table-responsive">
                        <table class="table table-bordered tf-strip w-1800 border-light tf-table">
                          <colgroup>
                            <col style="width : 8%">
                            <col style="width : 8%">
                            <col style="width : 8%">
                            <col style="width : 8%">
                            <col style="width : 15%">
                            <col style="width : 8%">
                            <col style="width : 8%">
                            <col style="width : 10%">
                            <col style="width : 8%">
                            <col style="width : 8%">
                            <col style="width : 8%">
                          </colgroup>
                          <thead>
                              <tr>
                                  <th scope="col">Id</th>
                                  <th scope="col">Controle</th>
                                  <th scope="col">Excel 1</th>
                                  <th scope="col">Excel 2</th>
                                  <th scope="col">Formule</th>
                                  <th scope="col">Périodicité</th>
                                  <th scope="col">Utilisateur</th>
                                  <th scope="col">Date et heure</th>
                                  @if(in_array(Auth::user()->role ,['admin']))
                                  <th scope="col" colspan="3">Action</th>
                                  @else
                                  <th scope="col" colspan="1">Action</th>
                                  @endif

                              </tr>
                          </thead>
                          <tbody>
                            @foreach($formulasPending as $formula)
                              <tr id="r{{$formula->id}}">
                                  <td>{{$formula->id}}</td>
                                  <td>{{$formula->controle}}</td>
                                  <td>{{$formula->filetype_name1}}</td>
                                  <td>{{$formula->filetype_name2}}</td>
                                  <td class="field"> <input type="text" value="{{$formula->formula_text}}" name="col1" class="form-control"> </td>
                                  <td> @if(!is_null($formula->periodicite))
                                        {{$formula->periodicite->period}}
                                        @endif</td>
                                  <td>
                                    {{$formula->action->user->name}}
                                  </td>
                                  <td>
                                    {{$formula->created_at}}
                                  </td>
                                  <td class="toEdit">{{$formula->action->action}}</td>
                                  @if(in_array(Auth::user()->role ,['admin']))
                                  <td class="approuve" onclick="doAction('accepted',{{$formula->id}})">Approuver</td>
                                  <td class="reject" onclick="doAction('refused',{{$formula->id}})">
                                    Rejeter
                                  </td>
                                  @endif
                              </tr>
                              @endforeach
                          </tbody>
                        </table>
                      </div>
                    </div>
                  </div>
                </div>
            </div>


  <div class="modal fade" id="addTable" tabindex="-1" aria-labelledby="editTableLabel" aria-hidden="true">
  <div class="modal-dialog modal-xl modal-dialog-centered">
    <div class="modal-content">
      <div class="closeWrap text-end">
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
        <form action="#" id="editForm">
          <table class="table tf-strip border-light tf-table">
            <thead>
                <tr>
                    <th scope="col"  width="10%">Id</th>
                    <th scope="col"  width="10%">Controle</th>
                    <th scope="col"  width="10%" class="b-col">Excel 1</th>
                    <th scope="col"  width="10%" class="b-col">Excel 2</th>
                    <th scope="col"  width="40%" class="b-col">Formule</th>
                    <th scope="col"  width="10%" class="b-col">Périodicité</th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td>
                      22
                    </td>
                    <td>
                      7
                    </td>
                    <td>
                      <select name="controle" class="form-select">
                        <option value="ALMM">ALMM</option>
                      </select>
                    </td>
                    <td>
                      <select name="controle" class="form-select">
                        <option value="F1607">F1607</option>
                      </select>
                    </td>
                    <td class="field"> <input type="text" value="[C6601_F52]+[C6601_G52]+[C6601_H52]+[C6601_I52]" name="col1" class="form-control"> </td>
                    <td>
                      <select name="controle" class="form-select">
                        <option value="Trimestriel">Trimestriel</option>
                      </select>
                    </td>
                </tr>
            </tbody>
          </table>
          <div class="text-center">
            <button class="submitModal">
              <svg class="me-3" id="clock_line" data-name="clock line" xmlns="http://www.w3.org/2000/svg" width="36" height="36" viewBox="0 0 36 36">
                <path id="Tracé_206" data-name="Tracé 206" d="M18.667,2.67a16,16,0,1,0,16,16A16,16,0,0,0,18.667,2.67Zm0,30a14,14,0,1,1,14-14A14,14,0,0,1,18.667,32.67Z" transform="translate(-0.667 -0.667)" fill="#fff"/>
                <path id="Tracé_207" data-name="Tracé 207" d="M24.563,21.647V14a1,1,0,0,0-2,0V22.72l5.9,4a1,1,0,0,0,1.6-.75,1.012,1.012,0,0,0-.488-.908Z" transform="translate(-5.64 -3.25)" fill="#fff"/>
                <path id="Tracé_208" data-name="Tracé 208" d="M10.129,20.053a9.936,9.936,0,0,1,15.4-8.348l.855-1.365a11.551,11.551,0,1,0-8.535,21l.27-1.53A9.985,9.985,0,0,1,10.129,20.053Z" transform="translate(-2.126 -2.113)" fill="#fff"/>
                <path id="Tracé_210" data-name="Tracé 210" d="M0,0H36V36H0Z" fill="none"/>
              </svg>
               Soumettre à l'examen
            </button>
          </div>
        </form>
      </div>
    </div>
  </div>
</div>

<script>
    function doAction(action,formula_id){
        var data = {_token:'{{csrf_token()}}',formula_id:formula_id,action:action}
        axios({
            method: 'post',
            url: '{{route('ajax')}}',
            data:data
        })
        .then(function (response) {
            $('#r'+formula_id).remove()
        });
    }

    $('#formula').DataTable({
   "iDisplayLength": <br />
<b>Warning</b>:  Undefined variable $formulasLive in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>280</b><br />
<br />
<b>Fatal error</b>:  Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php:280
Stack trace:
#0 {main}
  thrown in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/formula/index.blade.php</b> on line <b>280</b><br />