course_list.blade.php 40 KB

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