course_list.blade.php 36 KB

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