course_list.blade.php 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936
  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">Pagamento 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>Anno</b>
  15. </div>
  16. <div class="col-12">
  17. <select class="form-select filterYear" >
  18. <option value="">--Seleziona--
  19. @foreach($course_years as $c)
  20. @php
  21. $selected = '';
  22. try
  23. {
  24. list($f, $t) = explode("-", $c);
  25. if ($f == date("Y"))
  26. $selected = 'selected';
  27. } catch (Exception $e) {
  28. }
  29. @endphp
  30. <option value="{{$c}}" {{$selected}}>{{$c}}
  31. @endforeach
  32. </select>
  33. </div>
  34. </div>
  35. </div>
  36. <div class="col-md-2">
  37. <div class="row">
  38. <div class="col-md-12" style="margin-bottom:10px;">
  39. <b>Corso</b>
  40. </div>
  41. <div class="col-12" >
  42. <select class="form-select filterCourse" multiple="multiple">
  43. @foreach($courses as $c)
  44. <option value="{{$c}}">{{$c}}
  45. @endforeach
  46. </select>
  47. </div>
  48. </div>
  49. </div>
  50. <div class="col-md-2">
  51. <div class="row">
  52. <div class="col-md-12" style="margin-bottom:10px;">
  53. <b>Livello</b>
  54. </div>
  55. <div class="col-12">
  56. <select class="form-select filterLevel" multiple="multiple">
  57. @foreach($course_levels as $c)
  58. <option value="{{$c->id}}">{{$c->name}}
  59. @endforeach
  60. </select>
  61. </div>
  62. </div>
  63. </div>
  64. <div class="col-md-2">
  65. <div class="row">
  66. <div class="col-md-12" style="margin-bottom:10px;">
  67. <b>Frequenza</b>
  68. </div>
  69. <div class="col-12">
  70. <select class="form-select filterFrequency" multiple="multiple">
  71. @foreach($course_frequencies as $c)
  72. <option value="{{$c->id}}">{{$c->name}}
  73. @endforeach
  74. </select>
  75. </div>
  76. </div>
  77. </div>
  78. <div class="col-md-2">
  79. <div class="row">
  80. <div class="col-md-12" style="margin-bottom:10px;">
  81. <b>Tipologia</b>
  82. </div>
  83. <div class="col-12">
  84. <select class="form-select filterType" multiple="multiple">
  85. @foreach($course_types as $c)
  86. <option value="{{$c->id}}">{{$c->name}}
  87. @endforeach
  88. </select>
  89. </div>
  90. </div>
  91. </div>
  92. <div class="col-md-2">
  93. <div class="row">
  94. <div class="col-md-12" style="margin-bottom:10px;">
  95. <b>Durata</b>
  96. </div>
  97. <div class="col-12">
  98. <select class="form-select filterDuration" multiple="multiple">
  99. @foreach($course_durations as $c)
  100. <option value="{{$c->id}}">{{$c->name}}
  101. @endforeach
  102. </select>
  103. </div>
  104. </div>
  105. </div>
  106. </div>
  107. <div class="row g-3" style="margin-top:20px;">
  108. <div class="col-md-12" style="text-align:right">
  109. <button class="btn--ui_outline light" onclick="reset()">CANCELLA</button>
  110. <button class="btn--ui" onclick="loadDataTable()">FILTRA</button>
  111. </div>
  112. </div>
  113. <hr size="1">
  114. </div>
  115. <div class="row text-right">
  116. <div class="col-md-12" style="text-align:right">
  117. <button style="display:none; width:200px;" class="btn--ui btNewPayment" onclick="newPayment()">NUOVA ENTRATA</button>
  118. </div>
  119. </div>
  120. <section id="resume-table" class="scrollTable">
  121. <div class="compare--chart_wrapper d-none"></div>
  122. <table class="table tablesaw tableHead tablesaw-stack pagamento--corsi display nowrap" id="tablesaw-350" width="100%">
  123. <thead>
  124. <tr>
  125. <th scope="col"></th>
  126. <th scope="col">Corso</th>
  127. <th scope="col">Cognome</th>
  128. <th scope="col">Nome</th>
  129. <th scope="col">Iscrizione</th>
  130. @foreach($months as $m)
  131. <th scope="col">&nbsp;&nbsp;&nbsp;&nbsp;{{$m}}</th>
  132. @endforeach
  133. </tr>
  134. </thead>
  135. <tbody id="checkall-target">
  136. </tbody>
  137. <tfoot id="checkall-target">
  138. <tr>
  139. <th colspan="2"></th>
  140. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  141. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  142. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  143. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  144. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  145. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  146. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  147. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  148. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  149. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  150. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  151. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  152. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  153. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  154. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  155. </tr>
  156. </tfoot>
  157. </table>
  158. </section>
  159. </div>
  160. @push('scripts')
  161. @endpush
  162. @push('scripts')
  163. <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
  164. <style>
  165. .scrollTable {
  166. padding: 15px;
  167. /*max-width: 800px !important;*/
  168. overflow-x: auto;
  169. overflow-y: hidden;
  170. white-space: nowrap;
  171. border: 1px solid #ddd;
  172. }
  173. ::-webkit-scrollbar-thumb {
  174. background: #EDF0F2;
  175. border-radius: 10px;
  176. }
  177. .select2-container--default .select2-selection--single{
  178. background-color: #E9F0F5;
  179. border: 0.0625rem solid #DFE5EB;
  180. font-size: 0.75rem;
  181. }
  182. .select2-selection
  183. {
  184. height: 38px !important;
  185. }
  186. .select2-selection__rendered
  187. {
  188. padding-top:3px;
  189. }
  190. .select2 {
  191. width:100% !important;
  192. }
  193. tfoot #checkall-target > tr > th
  194. {
  195. padding-right:5px !important;
  196. }
  197. /*.container-fluid
  198. {
  199. display: table-row !important;
  200. }
  201. .row.row.header--gestionale
  202. {
  203. padding-left:20px !important;
  204. }*/
  205. </style>
  206. <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  207. <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
  208. @endpush
  209. @push('scripts')
  210. <link href="/css/datatables.css" rel="stylesheet" />
  211. <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  212. <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
  213. <style>
  214. table thead {
  215. /* Important */
  216. position: sticky;
  217. z-index: 100;
  218. top: 0;
  219. }
  220. .select2-container--default .select2-selection--single{
  221. background-color: #E9F0F5;
  222. border: 0.0625rem solid #DFE5EB;
  223. font-size: 0.75rem;
  224. }
  225. .select2-selection
  226. {
  227. height: 38px !important;
  228. }
  229. .select2-selection__rendered
  230. {
  231. padding-top:3px;
  232. }
  233. .select2 {
  234. width:100% !important;
  235. }
  236. .select2-selection--multiple{
  237. overflow: hidden !important;
  238. height: auto !important;
  239. }
  240. .select2-container {
  241. box-sizing: border-box;
  242. display: inline-block;
  243. margin: 0;
  244. position: relative;
  245. vertical-align: middle;
  246. }
  247. .select2-container .select2-selection--single {
  248. box-sizing: border-box;
  249. cursor: pointer;
  250. display: block;
  251. height: 38px;
  252. user-select: none;
  253. -webkit-user-select: none;
  254. }
  255. .select2-container .select2-selection--single .select2-selection__rendered {
  256. display: block;
  257. padding-left: 8px;
  258. padding-right: 20px;
  259. overflow: hidden;
  260. text-overflow: ellipsis;
  261. white-space: nowrap;
  262. }
  263. .select2-selection__choice__display{
  264. color:#000000 !important;
  265. }
  266. </style>
  267. <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  268. <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
  269. <script src="/assets/js/datatables.js"></script>
  270. <script src="https://cdn.datatables.net/buttons/3.0.2/js/buttons.dataTables.js"></script>
  271. <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
  272. <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
  273. <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
  274. @endpush
  275. @push('scripts')
  276. <script>
  277. var totals = '';
  278. $(document).ready(function() {
  279. loadDataTable();
  280. } );
  281. $('.filterYear').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  282. $('.filterCourse').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  283. /*$('.filterCourse').on('change', function (e) {
  284. var data = $('.filterCourse').select2("val");
  285. if (data == null) data = [];
  286. @this.set('filterCourse', data);
  287. //@this.search();
  288. });*/
  289. $('.filterLevel').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  290. /*$('.filterLevel').on('change', function (e) {
  291. var data = $('.filterLevel').select2("val");
  292. if (data == null) data = [];
  293. //@this.set('filterLevel', data);
  294. //@this.search();
  295. });*/
  296. $('.filterFrequency').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  297. /*$('.filterFrequency').on('change', function (e) {
  298. var data = $('.filterFrequency').select2("val");
  299. if (data == null) data = [];
  300. @this.set('filterFrequency', data);
  301. //@this.search();
  302. });*/
  303. $('.filterType').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  304. /*$('.filterType').on('change', function (e) {
  305. var data = $('.filterType').select2("val");
  306. if (data == null) data = [];
  307. @this.set('filterType', data);
  308. //@this.search();
  309. });*/
  310. $('.filterDuration').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  311. /*$('.filterDuration').on('change', function (e) {
  312. var data = $('.filterDuration').select2("val");
  313. if (data == null) data = [];
  314. // @this.set('filterDuration', data);
  315. //@this.search();
  316. });*/
  317. Livewire.on('load-data-table', () => {
  318. $('.filterYear').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  319. $('.filterCourse').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  320. $('.filterLevel').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  321. $('.filterFrequency').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  322. $('.filterType').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  323. $('.filterDuration').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  324. loadDataTable();
  325. });
  326. Livewire.on('destroy-data-table', () => {
  327. $('#tablesaw-350').DataTable().destroy();
  328. });
  329. function destroyDataTable()
  330. {
  331. $('#tablesaw-350').DataTable().destroy();
  332. }
  333. var isFilter = false;
  334. $(document).ready(function() {
  335. $(document).on("click",".showHideFilter",function() {
  336. if (isFilter)
  337. {
  338. isFilter = false;
  339. $(".showFilter").hide();
  340. }
  341. else
  342. {
  343. isFilter = true;
  344. $(".showFilter").show();
  345. }
  346. });
  347. } );
  348. function searchAction()
  349. {
  350. //destroyDataTable();
  351. //@this.search();
  352. }
  353. @if(isset($_GET["showFilters"]))
  354. var filterYear = localStorage.getItem("filterYearCourseList");
  355. if (filterYear)
  356. {
  357. $('.filterYear').val(filterYear).trigger('change');
  358. }
  359. var filterCourse = localStorage.getItem("filterCourseCourseList");
  360. if (filterCourse)
  361. {
  362. $('.filterCourse').val(filterCourse).trigger('change');
  363. }
  364. var filterLevel = localStorage.getItem("filterLevelCourseList");
  365. if (filterLevel)
  366. {
  367. $('.filterLevel').val(filterLevel).trigger('change');
  368. }
  369. var filterFrequency = localStorage.getItem("filterFrequencyCourseList");
  370. if (filterFrequency)
  371. {
  372. $('.filterFrequency').val(filterFrequency).trigger('change');
  373. }
  374. var filterDuration = localStorage.getItem("filterDurationCourseList");
  375. if (filterDuration)
  376. {
  377. $('.filterDuration').val(filterDuration).trigger('change');
  378. }
  379. var filterType = localStorage.getItem("filterTypeCourseList");
  380. if (filterType)
  381. {
  382. $('.filterType').val(filterType).trigger('change');
  383. }
  384. @endif
  385. function reset()
  386. {
  387. $('.filterYear').val(null).trigger("change");
  388. $('.filterCourse').val(null).trigger("change");
  389. $('.filterLevel').val(null).trigger("change");
  390. $('.filterFrequency').val(null).trigger("change");
  391. $('.filterDuration').val(null).trigger("change");
  392. $('.filterType').val(null).trigger("change");
  393. destroyDataTable();
  394. //localStorage.clear();
  395. loadDataTable();
  396. }
  397. function loadDataTable(){
  398. if ( $.fn.DataTable.isDataTable('#tablesaw-350') ) {
  399. $('#tablesaw-350').DataTable().destroy();
  400. }
  401. var filterYear = $('.filterYear').val();
  402. localStorage.setItem("filterYearCourseList", filterYear);
  403. var filterCourse = $('.filterCourse').val();
  404. localStorage.setItem("filterCourseCourseList", filterCourse);
  405. var filterLevel = $('.filterLevel').val();
  406. localStorage.setItem("filterLevelCourseList", filterLevel);
  407. var filterDuration = $('.filterDuration').val();
  408. localStorage.setItem("filterDurationCourseList", filterDuration);
  409. var filterFrequency = $('.filterFrequency').val();
  410. localStorage.setItem("filterFrequencyCourseList", filterFrequency);
  411. var filterType = $('.filterType').val();
  412. localStorage.setItem("filterTypeCourseList", filterType);
  413. $('#tablesaw-350').DataTable({
  414. //scrollX: true,
  415. serverSide: true,
  416. ajax: {
  417. url : '/get_course_list?filterCourse=' + filterCourse + '&filterDuration=' + filterDuration + '&filterLevel=' + filterLevel + '&filterType=' + filterType + '&filterFrequency=' + filterFrequency + '&filterYear=' + filterYear,
  418. dataSrc: function (json){
  419. if(json.totals){
  420. totals = json.totals;
  421. }
  422. return json.data;
  423. }
  424. },
  425. thead: {
  426. 'th': {'background-color': 'blue'}
  427. },
  428. columns: [
  429. {
  430. data: 'column_18',
  431. "orderable": false,
  432. render: function (data, type, row, meta){
  433. return data;
  434. }
  435. },
  436. {
  437. data: 'column_19'
  438. },
  439. {
  440. data: 'column_0',
  441. render: function (data, type, row){
  442. var ret = '<a href="/members?member_detail=' + row["column_17"] + '&from=course_list">' + data + '</a>';
  443. return ret;
  444. }
  445. },
  446. {
  447. data: 'column_1',
  448. render: function (data, type, row){
  449. const x = data.split("§");
  450. var ret = '<a href="/members?member_detail=' + row["column_17"] + '&from=course_list">' + data + '</a>';
  451. return ret;
  452. }
  453. },
  454. {
  455. data: 'column_2',
  456. render: function (data, type, row){
  457. const x = data.split("§");
  458. var ret = '';
  459. if (x[0] == 0)
  460. {
  461. var ret = '<a style="width:100%;float:right; text-align:right; display:block; ' + (x[0] == 1 ? '' : 'cursor:pointer;') + '" class="' + (x[0] == 1 ? 'green' : 'orange') + ' sub_' + row["column_16"] + '" onclick="setSubscription(' + row["column_15"] + ', ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  462. }
  463. else
  464. {
  465. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + (x[0] == 1 ? 'green' : 'orange') + '"><small>' + x[1] + '</small></a>';
  466. }
  467. return ret;
  468. }
  469. },
  470. {
  471. data: 'column_3',
  472. render: function (data, type, row, meta){
  473. const x = data.split("§");
  474. var ret = '';
  475. if (x[0] == 'orange')
  476. {
  477. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_1_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 1, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  478. }
  479. else
  480. {
  481. if (x[0] != 'wgrey')
  482. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  483. }
  484. return ret;
  485. }
  486. },
  487. {
  488. data: 'column_4',
  489. render: function (data, type, row, meta){
  490. const x = data.split("§");
  491. var ret = '';
  492. if (x[0] == 'orange')
  493. {
  494. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_2_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 2, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  495. }
  496. else
  497. {
  498. if (x[0] != 'wgrey')
  499. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  500. }
  501. return ret;
  502. }
  503. },
  504. {
  505. data: 'column_5',
  506. render: function (data, type, row, meta){
  507. const x = data.split("§");
  508. var ret = '';
  509. if (x[0] == 'orange')
  510. {
  511. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_3_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 3, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  512. }
  513. else
  514. {
  515. if (x[0] != 'wgrey')
  516. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  517. }
  518. return ret;
  519. }
  520. },
  521. {
  522. data: 'column_6',
  523. render: function (data, type, row, meta){
  524. const x = data.split("§");
  525. var ret = '';
  526. if (x[0] == 'orange')
  527. {
  528. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_4_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 4, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  529. }
  530. else
  531. {
  532. if (x[0] != 'wgrey')
  533. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  534. }
  535. return ret;
  536. }
  537. },
  538. {
  539. data: 'column_7',
  540. render: function (data, type, row, meta){
  541. const x = data.split("§");
  542. var ret = '';
  543. if (x[0] == 'orange')
  544. {
  545. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_5_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 5, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  546. }
  547. else
  548. {
  549. if (x[0] != 'wgrey')
  550. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  551. }
  552. return ret;
  553. }
  554. },
  555. {
  556. data: 'column_8',
  557. render: function (data, type, row, meta){
  558. const x = data.split("§");
  559. var ret = '';
  560. if (x[0] == 'orange')
  561. {
  562. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_6_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 6, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  563. }
  564. else
  565. {
  566. if (x[0] != 'wgrey')
  567. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  568. }
  569. return ret;
  570. }
  571. },
  572. {
  573. data: 'column_9',
  574. render: function (data, type, row, meta){
  575. const x = data.split("§");
  576. var ret = '';
  577. if (x[0] == 'orange')
  578. {
  579. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_7_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 7, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  580. }
  581. else
  582. {
  583. if (x[0] != 'wgrey')
  584. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  585. }
  586. return ret;
  587. }
  588. },
  589. {
  590. data: 'column_10',
  591. render: function (data, type, row, meta){
  592. const x = data.split("§");
  593. var ret = '';
  594. if (x[0] == 'orange')
  595. {
  596. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_8_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 8, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  597. }
  598. else
  599. {
  600. if (x[0] != 'wgrey')
  601. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  602. }
  603. return ret;
  604. }
  605. },
  606. {
  607. data: 'column_11',
  608. render: function (data, type, row, meta){
  609. const x = data.split("§");
  610. var ret = '';
  611. if (x[0] == 'orange')
  612. {
  613. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_9_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 9, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  614. }
  615. else
  616. {
  617. if (x[0] != 'wgrey')
  618. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  619. }
  620. return ret;
  621. }
  622. },
  623. {
  624. data: 'column_12',
  625. render: function (data, type, row, meta){
  626. const x = data.split("§");
  627. var ret = '';
  628. if (x[0] == 'orange')
  629. {
  630. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_10_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 10, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  631. }
  632. else
  633. {
  634. if (x[0] != 'wgrey')
  635. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  636. }
  637. return ret;
  638. }
  639. },
  640. {
  641. data: 'column_13',
  642. render: function (data, type, row, meta){
  643. const x = data.split("§");
  644. var ret = '';
  645. if (x[0] == 'orange')
  646. {
  647. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_11_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 11, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  648. }
  649. else
  650. {
  651. if (x[0] != 'wgrey')
  652. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  653. }
  654. return ret;
  655. }
  656. },
  657. {
  658. data: 'column_14',
  659. render: function (data, type, row, meta){
  660. const x = data.split("§");
  661. var ret = '';
  662. if (x[0] == 'orange')
  663. {
  664. ret = '<a style="width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="' + x[0] + ' lnk_' + row["column_16"] + '" id="lnk_' + row["column_15"] + '_12_' + row["column_17"] + '" onclick="setPayMonth(' + row["column_15"] + ', 12, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  665. }
  666. else
  667. {
  668. if (x[0] != 'wgrey')
  669. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  670. }
  671. return ret;
  672. }
  673. }
  674. ],
  675. layout: {
  676. topStart : null,
  677. topEnd : null,
  678. top1A: {
  679. buttons: [
  680. {
  681. extend: 'collection',
  682. text: 'Esporta',
  683. buttons: [
  684. {
  685. extend: 'excelHtml5',"action":newexportaction,
  686. title: 'Pagamento corsi',
  687. exportOptions: {
  688. columns: ":not(':last')"
  689. },
  690. footer:false
  691. },
  692. {
  693. extend: 'pdfHtml5',"action":newexportaction,
  694. title: 'Pagamento corsi',
  695. exportOptions: {
  696. columns: ":not(':last')"
  697. },
  698. footer:false
  699. },
  700. {
  701. extend: 'print',"action":newexportaction,
  702. text: 'Stampa',
  703. title: 'Pagamento corsi',
  704. exportOptions: {
  705. columns: ":not(':last')"
  706. },
  707. footer:false
  708. }
  709. ],
  710. dropup: true
  711. }
  712. ]
  713. },
  714. top1B : {
  715. pageLength: {
  716. menu: [[10, 25, 50, 100, 100000], [10, 25, 50, 100, "Tutti"]]
  717. }
  718. },
  719. top1C :'search',
  720. },
  721. order: [[2, 'asc'], [3, 'asc']],
  722. pagingType: 'numbers',
  723. "language": {
  724. "url": "/assets/js/Italian.json"
  725. },
  726. "fnInitComplete": function (oSettings, json) {
  727. var html = '&nbsp;<a href="#" class="showHideFilter btn--ui"><i class="fa-solid fa-sliders"></i></a>';
  728. $(".dt-search").append(html);
  729. },
  730. "footerCallback": function (row, data, start, end, display) {
  731. let api = this.api();
  732. api.column(0).footer().innerHTML = '';
  733. api.column(1).footer().innerHTML = '';
  734. api.column(2).footer().innerHTML = '';
  735. api.column(3).footer().innerHTML = '';
  736. for(var i=4; i<=15; i++)
  737. {
  738. api.column(i).footer().innerHTML = '';
  739. }
  740. if (totals != '')
  741. {
  742. totals.split("_").forEach(function (item)
  743. {
  744. var x = item.split("§");
  745. if (x[1] != undefined)
  746. api.column(x[0]).footer().innerHTML = x[1];
  747. else
  748. api.column(x[0]).footer().innerHTML = '';
  749. });
  750. }
  751. }/*,
  752. fixedColumns: {
  753. start: 1,
  754. end: 1
  755. },
  756. scrollX: true*/
  757. });
  758. $('#tablesaw-350 thead tr th').addClass('col');
  759. $('#tablesaw-350 thead tr th').css("background-color", "#f6f8fa");
  760. $('#tablesaw-350').on('draw.dt', function() {
  761. $('[data-bs-toggle="popover"]').popover()
  762. });
  763. jQuery.fn.dataTable.Api.register( 'sum()', function ( ) {
  764. return this.flatten().reduce( function ( a, b ) {
  765. if ( typeof a === 'string') {
  766. start = a.indexOf("€");
  767. a = a.substr(start + 2).replace("</small></a>", "").replace(",",".") * 1;
  768. }
  769. if ( typeof b === 'string' && b.indexOf('green') > 0) {
  770. start = b.indexOf("€");
  771. b = b.substr(start + 2).replace("</small></a>", "").replace(",",".") * 1;
  772. }
  773. else
  774. {
  775. b = 0;
  776. }
  777. return a + b;
  778. }, 0 );
  779. } );
  780. }
  781. Livewire.on('setTotals', (tot) =>
  782. {
  783. totals = tot;
  784. console.log(totals);
  785. });
  786. var subscription = false;
  787. var months = [];
  788. var selectedCourseId = 0;
  789. var selectedMemberId = 0;
  790. var selectedMemberCourseId = 0;
  791. function setPayMonth(course_id, month, member_id, id)
  792. {
  793. if (selectedMemberId > 0 && selectedMemberId != member_id)
  794. {
  795. months = [];
  796. subscription = false;
  797. }
  798. if (selectedMemberCourseId != id)
  799. {
  800. $(".sub_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  801. $(".lnk_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  802. }
  803. selectedCourseId = course_id;
  804. selectedMemberId = member_id;
  805. selectedMemberCourseId = id;
  806. if(!months.includes(month))
  807. {
  808. months.push(month);
  809. $("#lnk_" + course_id + "_" + month + "_" + member_id).addClass("blue").addClass("selected").removeClass("orange");
  810. }
  811. else
  812. {
  813. months.splice(months.indexOf(months), 1);
  814. $("#lnk_" + course_id + "_" + month + "_" + member_id).addClass("orange").removeClass("blue").removeClass("selected");
  815. }
  816. if (months.length > 0)
  817. {
  818. $(".btNewPayment").show();
  819. }
  820. else
  821. {
  822. $(".btNewPayment").hide();
  823. }
  824. }
  825. function setSubscription(course_id, member_id, id)
  826. {
  827. if (selectedMemberCourseId != id)
  828. {
  829. $(".sub_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  830. $(".lnk_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  831. months = [];
  832. subscription = false;
  833. }
  834. selectedCourseId = course_id;
  835. selectedMemberId = member_id;
  836. selectedMemberCourseId = id;
  837. if (subscription)
  838. {
  839. $(".sub_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  840. subscription = false;
  841. $(".btNewPayment").hide();
  842. }
  843. else
  844. {
  845. $(".sub_" + selectedMemberCourseId).addClass("blue").addClass("selected").removeClass("orange");
  846. subscription = true;
  847. $(".btNewPayment").show();
  848. }
  849. }
  850. function newPayment()
  851. {
  852. @this.newPayment(selectedCourseId, months.toString(), selectedMemberId, selectedMemberCourseId, subscription);
  853. }
  854. $( document ).ready( function(){
  855. setMaxWidth();
  856. $( window ).bind( "resize", setMaxWidth ); //Remove this if it's not needed. It will react when window changes size.
  857. function setMaxWidth() {
  858. $("#resume-table").width( Math.round( $(window ).width() - size ) ) ;
  859. }
  860. });
  861. </script>
  862. @endpush