course_list.blade.php 34 KB

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