course_member.blade.php 31 KB

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