course_list.blade.php 35 KB

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