course_list.blade.php 40 KB

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