2
0

cms.rh-import-to-temp.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. <?php
  2. $cpt_tmp = salaries::countTmpSalaries();
  3. $json = salaries::createRapport();
  4. file_put_contents(DIR_DATAS_JSON."tmp_salaries.json", $json["json"]);
  5. $excelInfo = salaries::excelGetInProgress();
  6. if(empty($json["excel"])){
  7. ?>
  8. <header class="d-flex flex-column flex-md-row align-items-md-center p-3 bg-light ">
  9. <h2 class="bd-title" id="content">
  10. <span>Traiter un fichier Excel : <?php echo $excelInfo["name"] ?> (Etape 2/2)</span>
  11. </h2>
  12. </header>
  13. <?php
  14. echo core::filAriane(array(
  15. "current" => "Traiter un fichier Excel",
  16. "arbo" => array(
  17. "Salariés" => NULL,
  18. "Liste des salariés (base RH)" => "/",
  19. "Historique des chargements" => "/rh-historique-excel.html",
  20. "Traiter un fichier Excel" => "/rh-import-to-temp.html")
  21. ));
  22. ?>
  23. <br />
  24. <div id="formFooter">
  25. <div class="alert alert-warning" role="alert" >Nous n'avons trouvez aucune donnée à traiter dans ce fichier.</div>
  26. </div>
  27. <?php
  28. }
  29. else {
  30. $jsonTarget = "/json.php?file=tmp_salaries";
  31. if(core::isDebug()){
  32. debug::log(debug::getBadge($jsonTarget, "OUVRIR LE JSON : ".$jsonTarget), "JSON chargé en arrière plan");
  33. }
  34. ?>
  35. <header class="d-flex flex-column flex-md-row align-items-md-center p-3 bg-light ">
  36. <h2 class="bd-title" id="content">
  37. <span>Traiter un fichier Excel : <?php echo $excelInfo["name"] ?></span>
  38. <form style="position: absolute; right: 40px; margin-top: -40px;" method="post" action="/submit.php">
  39. <input type="hidden" name="from" value="rh-annule-import">
  40. <input type="hidden" name="id" value="<?php echo $excelInfo["id"] ?>">
  41. <button type="submit" style="margin-left:10px;" class="btn btn-outline-danger btn-sm" title="Annuler l'import">Annuler le traitement</button>
  42. </form>
  43. </h2>
  44. </header>
  45. <?php
  46. echo core::filAriane(array(
  47. "current" => "Traiter un fichier Excel RH",
  48. "arbo" => array(
  49. "Salariés" => NULL,
  50. "Liste des salariés (base RH)" => "/",
  51. "Historique des chargements" => "/rh-historique-excel.html",
  52. "Traiter un fichier Excel RH" => "/rh-import-to-temp.html")
  53. ));
  54. ?>
  55. <div>
  56. <table
  57. id="table"
  58. class="table-striped table-hover table-sm"
  59. data-page-size="25"
  60. data-toggle="table"
  61. data-show-columns="true"
  62. data-search="true"
  63. data-buttons-align="left"
  64. data-pagination="true"
  65. data-filter-control="true"
  66. data-flat="true"
  67. data-search="true"
  68. data-sort-name="cree"
  69. data-sort-order="desc"
  70. data-url="<?php echo $jsonTarget ?>">
  71. <thead>
  72. <tr>
  73. <th data-sortable="true" data-field="action" data-filter-control="select">Action</th>
  74. <th data-sortable="true" data-field="idLocal" data-filter-control="input">Id Capgemini</th>
  75. <th data-sortable="true" data-field="loginId" data-filter-control="input">Identifiant</th>
  76. <th data-sortable="true" data-field="nom" data-filter-control="input">Nom</th>
  77. <th data-sortable="true" data-field="prenom" data-filter-control="input">Prénom</th>
  78. <th data-sortable="true" data-field="jourEntree" data-filter-control="input">Entrée</th>
  79. <th data-sortable="true" data-field="contrat" data-filter-control="select">Statut Contrat</th>
  80. <th data-sortable="true" data-field="lieu" data-filter-control="select">Localité</th>
  81. </tr>
  82. </thead>
  83. </table>
  84. </div>
  85. <form method="post" action="/submit.php" onsubmit="loading()">
  86. <input type="hidden" name="from" value="rh-temp-to-mysql">
  87. <input type="hidden" name="excel" value="<?php echo $json["excel"] ?>">
  88. <input class="btn btn-outline-primary btn-lg" style="width: 100%" type="submit" value="Valider la mise à jour des données">
  89. </form>
  90. <br />
  91. <br />
  92. <?php
  93. }
  94. ?>