course_list.blade.php 41 KB

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