@extends('layout.layout')
@section('content')
<h1>Analyser vos fichiers Excel</h1>
<div class="row">
      <div class="col-md-8 offset-5">
        <form id="report" action="{{route('resultat')}}" method="post" enctype="multipart/form-data">
          @csrf
          <div class="row mb-2">
            <div class="col-md-6">
              <div class="form-group">
                <label>Entreprise:</label>
                <select id="entreprise" class="form-control" name="entreprise" aria-label="Default select example" required>
                  <option selected></option>
                  <br />
<b>Warning</b>:  Undefined variable $entreprises in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/home-old.blade.php</b> on line <b>14</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/home-old.blade.php</b> on line <b>14</b><br />
                </select>
              </div>
            </div>
             <div class="col-md-6">
               <div class="form-group">
                 <label>Etablissement:</label>
                 <select id="etablissement" class="form-control" name="etablissement" aria-label="Default select example" required>
                   <option selected></option>
                 </select>
               </div>
             </div>
          </div>
          <div class="row mb-2">
             <div class="col-md-6">
               <div class="form-group">
                 <label>Période:</label>
                 <select id="periode" class="form-control" name="periode" aria-label="Default select example" required>
                   <option selected></option>
                   <br />
<b>Warning</b>:  Undefined variable $periodicites in <b>/home/agilgo/public_html/transformation-factory-new2/resources/views/pages/home-old.blade.php</b> on line <b>35</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/home-old.blade.php</b> on line <b>35</b><br />
                 </select>
               </div>
             </div>
             <div class="col-md-6">
               <div class="form-group">
                 <label>Période Analysée:</label>
                 <select id="periodAnalyse" class="form-control" name="periodAnalyse" aria-label="Default select example" required>
                   <option selected></option>
                 </select>
               </div>
             </div>
          </div>
          <div class="row mb-2">
             <div class="col-md-6">
               <div class="form-group">
                 <label class="form-label">Rapport 1:</label>
                 <select id="rapport_1" class="form-control" name="rap_1" aria-label="Default select example" required>
                   <option selected></option>
                 </select>
               </div>
             </div>
             <div class="col-md-6">
               <div class="form-group mt-2">
                     <label for="formFileSm" class="form-label"></label>
                     <input type="file" class="form-control" name="excel_file_1" accept=".xlsx, .xls" required>
                </div>
             </div>
          </div>
          <div class="row mb-2">
            <div id='content_1' class="col-md-12">
            </div>
          </div>
          <div class="row mb-2">
             <div class="col-md-6">
               <div class="form-group">
                 <label class="form-label">Rapport 2:</label>
                 <select id="rapport_2" class="form-control" name="rap_2" aria-label="Default select example" required>
                   <option selected></option>
                 </select>
               </div>
             </div>

             <div class="col-md-6">
               <div class="form-group mt-2">
                     <label for="formFileSm" class="form-label"></label>
                     <input type="file" class="form-control form-control-sm" name="excel_file_2" accept=".xlsx, .xls" required>
                </div>
             </div>
          </div>
          <div class="row mb-2">
            <div id='content_2' class="col-md-12">
            </div>
          </div>
          <input id="rapprt_name_1" type="hidden" name="rapprt_name_1"/>
          <input id="rapprt_name_2" type="hidden" name="rapprt_name_2"/>
          <input id="entreprise_name" type="hidden" name="entreprise_name"/>
          <input id="etablissement_name" type="hidden" name="etablissement_name"/>
          <button type="submit" class="btn btn-primary mt-4">Submit</button>
        </form>
      </div>
  </div>
  <!-- modal report -->
  <div class="modal fade" tabindex="-1" role="dialog" id="myModal">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
          <h4 class="modal-title">Rapport</h4>
        </div>
        <div class="modal-body">
          <div class="container">
            <h2>le rapport déja existe</h2>
            <p> Voulez-vous l'écraser </p>
            <div class="btn-group" role="group" aria-label="...">
              <!-- <form  action="{{route('resultat')}}" method="post"> -->
                <!-- @csrf -->

                <button id="reportEcraser" type="submit" name="button" class="btn btn-primary">Oui</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">Non</button>
              <!-- </form> -->
            </div>
          </div>
        </div>
        <!-- <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
          <button type="button" class="btn btn-primary">Save changes</button>
        </div> -->
      </div><!-- /.modal-content -->
    </div><!-- /.modal-dialog -->
  </div><!-- /.modal -->
  <script src="https://unpkg.com/axios/dist/axios.min.js"></script>
<script>
$(document).ready(function(){

$("#report").submit(function(e){
  e.preventDefault();
    // $('#myModal').modal('show');
  var entreprise = $('#entreprise_name').val();
  var etablissement = $('#etablissement_name').val();
  var periodAnalyse = $('#periodAnalyse').val();
  var title = entreprise + "_" + etablissement +"_" +periodAnalyse;
  var data  = new FormData;
  data.append('title',title);
  var headers = {headers: {'Content-Type': 'application/json', 'X-Requested-With': 'XMLHttpRequest','encode'  : true}};
  axios.post('ajaxReport',data,headers).then((response)=>{
    console.log(response);
    if(response.data.reportExisst == "true") {
      $('#myModal').modal('show');
      $('#reportEcraser').click("click",function(){
        // console.log('reportid',response.data.report_id);
        $('#report').append("<input type='hidden' name='reportEcraser' value='Oui'/><br/>");
        $('#report').append("<input type='hidden' name='report_id' value='" + response.data.report_id + "'/><br/>");
        e.target.submit();

      });
    }
    if (response.data == false) {
      e.target.submit();
    }
  },(error)=>{
    console.log(error);
  });
  console.log(title);
});
  $("#entreprise").change(function(){
    var data  = new FormData;
    data.append('entreprise_id',$(this).val());
    data.append('action','getEtablissement');
    var headers = {headers: {'Content-Type': 'application/json', 'X-Requested-With': 'XMLHttpRequest','encode'  : true}};
      axios.post('ajax',data,headers).then((response)=>{
        console.log(response);
        $('#etablissement').html(response.data);
      },(error)=>{
        console.log(error);
      });

      var entre = $('#entreprise option:selected').text();
      $('#entreprise_name').val(entre);
      var etabliss = $('#etablissement option:selected').text();
      $('#etablissement_name').val(etabliss);
    // console.log(data);
  });

  $("#rapport_1").change(function(){
       var data = new FormData();
       var action = 'getCategories';
       data.append('parent_id', $(this).val());
       data.append('periode_id', $("#periode").val());
       data.append('periode', $("#periode option:selected").text());
       data.append('action', 'getCategories');
       // console.log(data);
       var headers = {headers: {'Content-Type': 'application/json', 'X-Requested-With': 'XMLHttpRequest','encode'  : true}};
       axios.post('ajax', data,headers)
        .then((response) => {
          console.log(response);
          $('#rapport_2').html(response.data.html)
        }, (error) => {
          console.log(error);
        });
        var file=$('#rapport_1 option:selected').text(),periode=$('#periode').val()
        $('#rapprt_name_1').val(file)
        getFileType(file,periode,'#content_1')
  });
  $("#periode").change(function(){
       var data = new FormData();
       var action = 'getCategories';
       data.append('parent_id', 0);
       data.append('periode_id', $(this).val());
       data.append('periode', $("#periode option:selected").text());
       data.append('action', 'getCategories');
       var headers = {headers: {'Content-Type': 'application/json','X-Requested-With': 'XMLHttpRequest','encode'  : true}}
       axios.post('ajax', data,headers)
        .then((response) => {
          console.log(response.data);
          $('#rapport_1').html(response.data.html);
          $('#periodAnalyse').html(response.data.periodAnalyse);
        }, (error) => {
          console.log(error);
        });
  });
  $("#rapport_2").change(function(){
    var file=$('#rapport_2 option:selected').text(),periode=$('#periode').val()
    $('#rapprt_name_2').val(file)
    getFileType(file,periode,'#content_2')
  })

});
function getFileType(file,periodicite,content){
  var data = new FormData();
  data.append('file', file);
  data.append('periodicite', periodicite);
  data.append('action', 'getFileType');
  var headers = {headers: {'Content-Type': 'application/json','X-Requested-With': 'XMLHttpRequest', 'encode'  : true}}
  const action = 'getFileType';

  axios.post('ajax',data,headers)
   .then((response) => {
     console.log(response);
     $(content).html(response.data)
   }, (error) => {
     console.log(error);
   });
  }
  function selectReferentiel() {
    // alert( document.getElementById('referentiel').value)
    switch (document.getElementById('referentiel').value) {
      case "Formula":
        window.location = "formula/formula.php"
        break;

        case "file_type":
        window.location = "file_type/file_type.php"
        break;
    }
  }
</script>
@endsection