course_list.blade.php 36 KB

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