course_list.blade.php 38 KB

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