course_member.blade.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758
  1. <div class="col card--ui" id="card--dashboard">
  2. <header id="title--section" style="display:none !important"
  3. class="d-flex align-items-center justify-content-between">
  4. <div class="title--section_name d-flex align-items-center justify-content-between">
  5. <i class="ico--ui title_section utenti me-2"></i>
  6. <h2 class="primary">Iscritti ai corsi</h2>
  7. </div>
  8. </header>
  9. <div class="showFilter" style="display:none" wire:ignore.self>
  10. <hr size="1">
  11. <div class="row g-3">
  12. <div class="col-md-2">
  13. <div class="row">
  14. <div class="col-md-12" style="margin-bottom:10px;">
  15. <b>Corso</b>
  16. </div>
  17. <div class="col-12">
  18. <select class="form-select filterCourse" multiple="multiple">
  19. @foreach($courses as $c)
  20. <option value="{{$c}}">{{$c}}
  21. @endforeach
  22. </select>
  23. </div>
  24. </div>
  25. </div>
  26. <div class="col-md-2">
  27. <div class="row">
  28. <div class="col-md-12" style="margin-bottom:10px;">
  29. <b>Livello</b>
  30. </div>
  31. <div class="col-12">
  32. <select class="form-select filterLevel" multiple="multiple">
  33. @foreach($course_levels as $c)
  34. <option value="{{$c->id}}">{{$c->name}}
  35. @endforeach
  36. </select>
  37. </div>
  38. </div>
  39. </div>
  40. <div class="col-md-2">
  41. <div class="row">
  42. <div class="col-md-12" style="margin-bottom:10px;">
  43. <b>Frequenza</b>
  44. </div>
  45. <div class="col-12">
  46. <select class="form-select filterFrequency" multiple="multiple">
  47. @foreach($course_frequencies as $c)
  48. <option value="{{$c->id}}">{{$c->name}}
  49. @endforeach
  50. </select>
  51. </div>
  52. </div>
  53. </div>
  54. <div class="col-md-2">
  55. <div class="row">
  56. <div class="col-md-12" style="margin-bottom:10px;">
  57. <b>Tipologia</b>
  58. </div>
  59. <div class="col-12">
  60. <select class="form-select filterType" multiple="multiple">
  61. @foreach($course_types as $c)
  62. <option value="{{$c->id}}">{{$c->name}}
  63. @endforeach
  64. </select>
  65. </div>
  66. </div>
  67. </div>
  68. <div class="col-md-2">
  69. <div class="row">
  70. <div class="col-md-12" style="margin-bottom:10px;">
  71. <b>Durata</b>
  72. </div>
  73. <div class="col-12">
  74. <select class="form-select filterDuration" multiple="multiple">
  75. @foreach($course_durations as $c)
  76. <option value="{{$c->id}}">{{$c->name}}
  77. @endforeach
  78. </select>
  79. </div>
  80. </div>
  81. </div>
  82. </div>
  83. <div class="row g-3 mt-1">
  84. <div class="col-md-3">
  85. <div class="row">
  86. <div class="col-md-12" style="margin-bottom:10px;">
  87. <b>Giorni</b>
  88. </div>
  89. <div class="col-12">
  90. <select class="form-select filterDays" multiple="multiple">
  91. <option value="lun">Lunedì
  92. <option value="mar">Martedì
  93. <option value="mer">Mercoledì
  94. <option value="gio">Giovedì
  95. <option value="ven">Venerdì
  96. <option value="sab">Sabato
  97. <option value="dom">Domenica
  98. </select>
  99. </div>
  100. </div>
  101. </div>
  102. <div class="col-md-3">
  103. <div class="row">
  104. <div class="col-md-12" style="margin-bottom:10px;">
  105. <b>Orari</b>
  106. </div>
  107. <div class="col-12">
  108. <select class="form-select filterHours" multiple="multiple">
  109. @for($c = 6; $c <= 23; $c++)
  110. <option value="{{str_pad($c, 2, "0", STR_PAD_LEFT)}}:00">
  111. {{str_pad($c, 2, "0", STR_PAD_LEFT)}}:00
  112. <option value="{{str_pad($c, 2, "0", STR_PAD_LEFT)}}:30">
  113. {{str_pad($c, 2, "0", STR_PAD_LEFT)}}:30
  114. @endfor
  115. </select>
  116. </div>
  117. </div>
  118. </div>
  119. <div class="col-md-3">
  120. <div class="row">
  121. <div class="col-md-12" style="margin-bottom:10px;">
  122. <b>Anno</b>
  123. </div>
  124. <div class="col-12">
  125. <select class="form-select filterYear">
  126. <option value="">--Seleziona--
  127. @foreach($course_years as $c)
  128. <option value="{{$c}}">{{$c}}
  129. @endforeach
  130. </select>
  131. </div>
  132. </div>
  133. </div>
  134. <div class="col-md-3">
  135. <div class="row">
  136. <div class="col-md-12" style="margin-bottom:10px;">
  137. <b>Pagamento iscrizione</b>
  138. </div>
  139. <div class="col-12">
  140. <select class="form-select filterSubscription">
  141. <option value="">--Seleziona--
  142. <option value="1">Pagata
  143. <option value="0">Non Pagata
  144. </select>
  145. </div>
  146. </div>
  147. </div>
  148. </div>
  149. <div class="row g-3 mt-1">
  150. <div class="col-md-3">
  151. <div class="row">
  152. <div class="col-md-12" style="margin-bottom:10px;">
  153. <b>Tipologia di tesseramento</b>
  154. </div>
  155. <div class="col-12">
  156. <select class="form-select filterCards" multiple="multiple">
  157. @foreach(getCards() as $card)
  158. <option value="{{$card->id}}">{{$card->name}}
  159. @endforeach
  160. </select>
  161. </div>
  162. </div>
  163. </div>
  164. <div class="col-md-3">
  165. <div class="row">
  166. <div class="col-md-12" style="margin-bottom:10px;">
  167. <b>Stato tesseramento</b>
  168. </div>
  169. <div class="col-12">
  170. <select class="form-select filterStatus" multiple="multiple">
  171. <option value="2">Attivo
  172. <option value="1">Sospeso
  173. <option value="0">Non tesserato
  174. </select>
  175. </div>
  176. </div>
  177. </div>
  178. <div class="col-md-3">
  179. <div class="row">
  180. <div class="col-md-12" style="margin-bottom:10px;">
  181. <b>Certificato medico</b>
  182. </div>
  183. <div class="col-12">
  184. <select class="form-select filterCertificateScadenza" multiple="multiple">
  185. <option value="1">Scaduti
  186. <option value="2">In scadenza
  187. <option value="3">Non presenti
  188. <option value="4">Validi
  189. </select>
  190. </div>
  191. </div>
  192. </div>
  193. <div class="col-md-3">
  194. <div class="row">
  195. <div class="col-md-12" style="margin-bottom:10px;">
  196. <b>Tipologia certificato medico</b>
  197. </div>
  198. <div class="col-12">
  199. <select class="form-select filterCertificateType" multiple="multiple">
  200. <option value="N">Non agonistico
  201. <option value="A">Agonistico
  202. </select>
  203. </div>
  204. </div>
  205. </div>
  206. </div>
  207. <div class="row g-3 mt-1">
  208. <div class="col-md-2">
  209. <div class="row">
  210. <div class="col-md-12" style="margin-bottom:10px;">
  211. <b>Età</b>
  212. </div>
  213. <div class="col-12">
  214. <div class="row">
  215. <div class="col-3"><label class="form-check-label ms-2">Da</label></div>
  216. <div class="col-9"><input class="form-control txt fromYear" type="number" name="fromYear">
  217. </div>
  218. </div>
  219. </div>
  220. <div class="col-12">
  221. <div class="row">
  222. <div class="col-3"><label class="form-check-label ms-2">A</label></div>
  223. <div class="col-9"><input class="form-control txt toYear" type="number" name="toYear"></div>
  224. </div>
  225. </div>
  226. </div>
  227. </div>
  228. <div class="col-md-2">
  229. <div class="row">
  230. <div class="col-md-12" style="margin-bottom:10px;">
  231. <b>Anno di nascita</b>
  232. </div>
  233. <div class="col-12">
  234. <div class="row">
  235. <div class="col-3"><label class="form-check-label ms-2">Da</label></div>
  236. <div class="col-9"><input class="form-control txt fromFromYear" name="fromYearYear"
  237. type="number" name="fromFromYear"></div>
  238. </div>
  239. </div>
  240. <div class="col-12">
  241. <div class="row">
  242. <div class="col-3"><label class="form-check-label ms-2">A</label></div>
  243. <div class="col-9"><input class="form-control txt toToYear" type="number" name="toToYear">
  244. </div>
  245. </div>
  246. </div>
  247. </div>
  248. </div>
  249. </div>
  250. <div class="row g-3 mt-2">
  251. <div class="col-md-12" style="text-align:right">
  252. <button class="btn--ui_outline light" onclick="reset()">RESET</button>
  253. <button class="btn--ui" onclick="loadDataTable()">FILTRA</button>
  254. </div>
  255. </div>
  256. <hr size="1">
  257. </div>
  258. <section id="resume-table">
  259. <div class="compare--chart_wrapper d-none"></div>
  260. <div id="filter">{{$filter}}</div>
  261. <table class="table tablesaw tableHead tablesaw-stack" id="tablesaw-350" width="100%">
  262. <thead>
  263. <tr>
  264. <th scope="col">#</th>
  265. <th scope="col">Corso</th>
  266. <th scope="col">Cognome</th>
  267. <th scope="col">Nome</th>
  268. <th scope="col">Età</th>
  269. <th scope="col">Anno di nascita</th>
  270. <th scope="col">Telefono</th>
  271. <th scope="col">Certificato</th>
  272. </tr>
  273. </thead>
  274. <tbody id="checkall-target">
  275. </tbody>
  276. </table>
  277. </section>
  278. </div>
  279. @push('scripts')
  280. <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
  281. <style>
  282. .select2-container--default .select2-selection--single {
  283. background-color: #E9F0F5;
  284. border: 0.0625rem solid #DFE5EB;
  285. font-size: 0.75rem;
  286. }
  287. .select2-selection {
  288. height: 38px !important;
  289. }
  290. .select2-selection__rendered {
  291. padding-top: 3px;
  292. }
  293. .select2 {
  294. width: 100% !important;
  295. }
  296. </style>
  297. <script src="https://code.jquery.com/jquery-2.2.4.min.js"
  298. integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  299. <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
  300. @endpush
  301. @push('scripts')
  302. <link href="/css/datatables.css" rel="stylesheet" />
  303. <script src="https://code.jquery.com/jquery-2.2.4.min.js"
  304. integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  305. <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
  306. <style>
  307. .select2-container--default .select2-selection--single {
  308. background-color: #E9F0F5;
  309. border: 0.0625rem solid #DFE5EB;
  310. font-size: 0.75rem;
  311. }
  312. .select2-selection {
  313. height: 38px !important;
  314. }
  315. .select2-selection__rendered {
  316. padding-top: 3px;
  317. }
  318. .select2 {
  319. width: 100% !important;
  320. }
  321. .select2-selection--multiple {
  322. overflow: hidden !important;
  323. height: auto !important;
  324. }
  325. .select2-container {
  326. box-sizing: border-box;
  327. display: inline-block;
  328. margin: 0;
  329. position: relative;
  330. vertical-align: middle;
  331. }
  332. .select2-container .select2-selection--single {
  333. box-sizing: border-box;
  334. cursor: pointer;
  335. display: block;
  336. height: 38px;
  337. user-select: none;
  338. -webkit-user-select: none;
  339. }
  340. .select2-container .select2-selection--single .select2-selection__rendered {
  341. display: block;
  342. padding-left: 8px;
  343. padding-right: 20px;
  344. overflow: hidden;
  345. text-overflow: ellipsis;
  346. white-space: nowrap;
  347. }
  348. .select2-selection__choice__display {
  349. color: #000000 !important;
  350. }
  351. </style>
  352. <script src="https://code.jquery.com/jquery-2.2.4.min.js"
  353. integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  354. <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
  355. <script src="/assets/js/datatables.js"></script>
  356. <script src="https://cdn.datatables.net/buttons/3.0.2/js/buttons.dataTables.js"></script>
  357. <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
  358. <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
  359. <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
  360. @endpush
  361. @push('scripts')
  362. <script>
  363. $(document).ready(function () {
  364. loadDataTable();
  365. });
  366. $('.filterCourse').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  367. $('.filterLevel').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  368. $('.filterFrequency').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  369. $('.filterType').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  370. $('.filterDuration').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  371. $('.filterDays').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  372. $('.filterHours').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  373. $('.filterStatus').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  374. $('.filterSubscription').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  375. $('.filterCertificateScadenza').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  376. $('.filterCertificateType').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  377. $('.filterYear').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  378. $('.filterCards').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  379. /*$(".txt").on('change keydown keypress paste input', function(){
  380. destroyDataTable();
  381. });*/
  382. Livewire.on('load-data-table', () => {
  383. $('.filterCourse').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  384. $('.filterLevel').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  385. $('.filterFrequency').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  386. $('.filterType').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  387. $('.filterDuration').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  388. $('.filterDays').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  389. $('.filterHours').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  390. $('.filterStatus').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  391. $('.filterSubscription').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  392. $('.filterYear').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  393. $('.filterCards').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  394. $('.filterCertificateScadenza').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  395. $('.filterCertificateType').select2({ "language": { "noResults": function () { return "Nessun risultato"; } } });
  396. loadDataTable();
  397. });
  398. Livewire.on('destroy-data-table', () => {
  399. $('#tablesaw-350').DataTable().destroy();
  400. });
  401. @if(isset($_GET["showFilters"]))
  402. var filterYear = localStorage.getItem("filterYearCourseMember");
  403. if (filterYear) {
  404. $('.filterYear').val(filterYear).trigger('change');
  405. }
  406. var filterCourse = localStorage.getItem("filterCourseCourseMember");
  407. if (filterCourse) {
  408. $('.filterCourse').val(filterCourse).trigger('change');
  409. }
  410. var filterLevel = localStorage.getItem("filterLevelCourseMember");
  411. if (filterLevel) {
  412. $('.filterLevel').val(filterLevel).trigger('change');
  413. }
  414. var filterFrequency = localStorage.getItem("filterFrequencyCourseMember");
  415. if (filterFrequency) {
  416. $('.filterFrequency').val(filterFrequency).trigger('change');
  417. }
  418. var filterDuration = localStorage.getItem("filterDurationCourseMember");
  419. if (filterDuration) {
  420. $('.filterDuration').val(filterDuration).trigger('change');
  421. }
  422. var filterType = localStorage.getItem("filterTypeCourseMember");
  423. if (filterType) {
  424. $('.filterType').val(filterType).trigger('change');
  425. }
  426. var filterDays = localStorage.getItem("filterDaysCourseMember");
  427. if (filterDays) {
  428. $('.filterDays').val(filterDays).trigger('change');
  429. }
  430. var filterHours = localStorage.getItem("filterHoursCourseMember");
  431. if (filterHours) {
  432. $('.filterHours').val(filterHours).trigger('change');
  433. }
  434. var filterStatus = localStorage.getItem("filterStatusCourseMember");
  435. if (filterStatus) {
  436. $('.filterStatus').val(filterStatus).trigger('change');
  437. }
  438. var filterSubscription = localStorage.getItem("filterSubscriptionCourseMember");
  439. if (filterSubscription) {
  440. $('.filterSubscription').val(filterSubscription).trigger('change');
  441. }
  442. var filterCards = localStorage.getItem("filterCardsCourseMember");
  443. if (filterCards) {
  444. $('.filterCards').val(filterCards).trigger('change');
  445. }
  446. var filterCertificateScadenza = localStorage.getItem("filterCertificateScadenzaCourseMember");
  447. if (filterCertificateScadenza) {
  448. $('.filterCertificateScadenza').val(filterCertificateScadenza).trigger('change');
  449. }
  450. var filterCertificateType = localStorage.getItem("filterCertificateTypeCourseMember");
  451. if (filterCertificateType) {
  452. $('.filterCertificateType').val(filterCertificateType).trigger('change');
  453. }
  454. var fromYear = localStorage.getItem("fromYearCourseMember");
  455. if (fromYear) {
  456. $('input[name="fromYear"]').val(fromYear);
  457. }
  458. var toYear = localStorage.getItem("toYearCourseMember");
  459. if (toYear) {
  460. $('input[name="toYear"]').val(toYear);
  461. }
  462. var fromFromYear = localStorage.getItem("fromFromYearCourseMember");
  463. if (fromFromYear) {
  464. $('input[name="fromYearYear"]').val(fromFromYear);
  465. }
  466. var toYearYear = localStorage.getItem("toYearYearCourseMember");
  467. if (toYearYear) {
  468. $('input[name="toToYear"]').val(toYearYear);
  469. }
  470. @endif
  471. function reset() {
  472. $('.filterCourse').val(null).trigger("change");
  473. $('.filterLevel').val(null).trigger("change");
  474. $('.filterFrequency').val(null).trigger("change");
  475. $('.filterType').val(null).trigger("change");
  476. $('.filterDuration').val(null).trigger("change");
  477. $('.filterDays').val(null).trigger("change");
  478. $('.filterHours').val(null).trigger("change");
  479. $('.filterStatus').val(null).trigger("change");
  480. $('.filterSubscription').val(null).trigger("change");
  481. $('.filterYear').val(null).trigger("change");
  482. $('.filterCards').val(null).trigger("change");
  483. $('.filterCertificateScadenza').val(null).trigger("change");
  484. $('.filterCertificateType').val(null).trigger("change");
  485. $('.fromYear').val('');
  486. $('.toYear').val('');
  487. $('.fromFromYear').val('');
  488. $('.toToYear').val('');
  489. destroyDataTable();
  490. loadDataTable();
  491. }
  492. function destroyDataTable() {
  493. $('#tablesaw-350').DataTable().destroy();
  494. }
  495. var isFilter = false;
  496. $(document).ready(function () {
  497. $(document).on("click", ".showHideFilter", function () {
  498. if (isFilter) {
  499. isFilter = false;
  500. $(".showFilter").hide();
  501. }
  502. else {
  503. isFilter = true;
  504. $(".showFilter").show();
  505. }
  506. });
  507. });
  508. function searchAction() {
  509. //destroyDataTable();
  510. //@this.search();
  511. }
  512. function loadDataTable() {
  513. if ($.fn.DataTable.isDataTable('#tablesaw-350')) {
  514. $('#tablesaw-350').DataTable().destroy();
  515. }
  516. var filterCourse = $('.filterCourse').val();
  517. localStorage.setItem("filterCourseCourseMember", filterCourse);
  518. var filterLevel = $('.filterLevel').val();
  519. localStorage.setItem("filterLevelCourseMember", filterLevel);
  520. var filterDuration = $('.filterDuration').val();
  521. localStorage.setItem("filterDurationCourseMember", filterDuration);
  522. var filterFrequency = $('.filterFrequency').val();
  523. localStorage.setItem("filterFrequencyCourseMember", filterFrequency);
  524. var filterType = $('.filterType').val();
  525. localStorage.setItem("filterTypeCourseMember", filterType);
  526. var filterDays = $('.filterDays').val();
  527. localStorage.setItem("filterDaysCourseMember", filterDays);
  528. var filterHours = $('.filterHours').val();
  529. localStorage.setItem("filterHoursCourseMember", filterHours);
  530. var filterStatus = $('.filterStatus').val();
  531. localStorage.setItem("filterStatusCourseMember", filterStatus);
  532. var filterSubscription = $('.filterSubscription').val();
  533. localStorage.setItem("filterSubscriptionCourseMember", filterSubscription);
  534. var filterYear = $('.filterYear').val();
  535. localStorage.setItem("filterYearCourseMember", filterYear);
  536. var filterCards = $('.filterCards').val();
  537. localStorage.setItem("filterCardsCourseMember", filterCards);
  538. var filterCertificateScadenza = $('.filterCertificateScadenza').val();
  539. localStorage.setItem("filterCertificateScadenzaCourseMember", filterCertificateScadenza);
  540. console.log(filterCertificateScadenza);
  541. var filterCertificateType = $('.filterCertificateType').val();
  542. localStorage.setItem("filterCertificateTypeCourseMember", filterCertificateType);
  543. var fromYear = $('.fromYear').val();
  544. localStorage.setItem("fromYearCourseMember", fromYear);
  545. var toYear = $('.toYear').val();
  546. localStorage.setItem("toYearCourseMember", toYear);
  547. var fromFromYear = $('.fromFromYear').val();
  548. localStorage.setItem("fromFromYearCourseMember", fromFromYear);
  549. var toToYear = $('.toToYear').val();
  550. localStorage.setItem("toYearYearCourseMember", toToYear);
  551. var filterFromPrevious = '';
  552. @if($filterFromPrevious != '')
  553. filterFromPrevious = '&filterFromPrevious={{$filterFromPrevious}}';
  554. @endif
  555. $('#tablesaw-350').DataTable({
  556. serverSide: true,
  557. ajax: {
  558. url: '/get_course_members?filterCourse=' + filterCourse + '&filterDuration=' + filterDuration + '&filterLevel=' + filterLevel + '&filterType=' + filterType + '&filterFrequency=' + filterFrequency + '&filterDays=' + filterDays + '&filterHours=' + filterHours + '&filterStatus=' + filterStatus + '&filterSubscription=' + filterSubscription + '&filterYear=' + filterYear + '&filterCards=' + filterCards + '&filterCertificateScadenza=' + filterCertificateScadenza + '&filterCertificateType=' + filterCertificateType + '&fromYear=' + fromYear + '&toYear=' + toYear + '&fromFromYear=' + fromFromYear + '&toToYear=' + toToYear + filterFromPrevious,
  559. /*dataSrc: function (json){
  560. if(json.totals){
  561. totals = json.totals;
  562. }
  563. return json.data;
  564. }*/
  565. },
  566. thead: {
  567. 'th': { 'background-color': 'blue' }
  568. },
  569. columns: [
  570. { data: 'column_0' },
  571. { data: 'column_8' },
  572. {
  573. data: 'column_1',
  574. render: function (data, type, row) {
  575. var ret = '<a href="/members?member_detail=' + row["column_7"] + '&from=course_member">' + data + '</a>';
  576. return ret;
  577. }
  578. },
  579. {
  580. data: 'column_2',
  581. render: function (data, type, row) {
  582. var ret = '<a href="/members?member_detail=' + row["column_7"] + '&from=course_member">' + data + '</a>';
  583. return ret;
  584. }
  585. },
  586. { data: 'column_3' },
  587. { data: 'column_4' },
  588. { data: 'column_5' },
  589. {
  590. data: 'column_6',
  591. render: function (data, type, row) {
  592. var certInfo = data.split("|");
  593. var status = certInfo[0];
  594. var expireDate = certInfo[1] || "";
  595. var html = '<span class="tablesaw-cell-content d-flex align-items-center">';
  596. if (status === "0") {
  597. html += '<i class="ico--ui check suspended me-2"></i> ';
  598. html += 'Scaduto: ' + expireDate;
  599. } else if (status === "1") {
  600. html += '<i class="ico--ui check due me-2"></i>';
  601. html += 'In scadenza: ' + expireDate;
  602. } else if (status === "2") {
  603. html += '<i class="ico--ui check active me-2"></i>';
  604. html += 'Scadenza: ' + expireDate;
  605. html += '<span style="float:right"></span>';
  606. }else {
  607. console.log(status);
  608. html += 'Non Presente';
  609. }
  610. html += '</span>';
  611. return html;
  612. }
  613. }],
  614. layout: {
  615. topStart: null,
  616. topEnd: null,
  617. top1A: {
  618. buttons: [
  619. {
  620. extend: 'collection',
  621. text: 'ESPORTA',
  622. buttons: [
  623. {
  624. extend: 'excelHtml5', "action": newexportaction,
  625. title: 'Iscritti corsi',
  626. exportOptions: {
  627. columns: ":not(':last')"
  628. }
  629. },
  630. {
  631. extend: 'pdfHtml5', "action": newexportaction,
  632. title: 'Iscritti corsi',
  633. exportOptions: {
  634. columns: ":not(':last')"
  635. }
  636. },
  637. {
  638. extend: 'print', "action": newexportaction,
  639. text: 'Stampa',
  640. title: 'Iscritti corsi',
  641. exportOptions: {
  642. columns: ":not(':last')"
  643. }
  644. }
  645. ],
  646. dropup: true
  647. }
  648. ]
  649. },
  650. top1B: {
  651. pageLength: {
  652. menu: [[10, 25, 50, 100, 100000], [10, 25, 50, 100, "Tutti"]]
  653. }
  654. },
  655. top1C: 'search',
  656. },
  657. order: [[0, 'asc'], [1, 'asc']],
  658. pagingType: 'numbers',
  659. "language": {
  660. "url": "/assets/js/Italian.json"
  661. },
  662. "fnInitComplete": function (oSettings, json) {
  663. var html = '&nbsp;<a href="#" class="showHideFilter btn--ui"><i class="fa-solid fa-sliders"></i></a>';
  664. $(".dt-search").append(html);
  665. }
  666. });
  667. $('#tablesaw-350 thead tr th').addClass('col');
  668. $('#tablesaw-350 thead tr th').css("background-color", "#f6f8fa");
  669. $('#tablesaw-350').on('draw.dt', function () {
  670. $('[data-bs-toggle="popover"]').popover()
  671. });
  672. }
  673. </script>
  674. @endpush