course_list.blade.php 65 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308
  1. <div class="col card--ui" id="card--dashboard" style="padding-top: 0px !important;">
  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="row" style="margin-top: 10px; margin-bottom:10px;">
  9. <div class="col-md-4">
  10. <div class="col-md ">
  11. <div class="dt-buttons btn-group flex-wrap">
  12. <div class="btn-group">
  13. <button class="btn btn-secondary buttons-collection" wire:click="export()" style="color:black !important">ESPORTA</button>
  14. </div>
  15. </div>
  16. </div>
  17. </div>
  18. <div class="col-md-4">
  19. <div class="row">
  20. <div class="col-md-4" style="text-align:right">Visualizza</div>
  21. <div class="col-md-4">
  22. <select name="tablesaw-350_length" aria-controls="tablesaw-350" class="form-select form-select-sm" id="dt-length-0" wire:model="pageLength">
  23. <option value="10">10</option>
  24. <option value="25">25</option>
  25. <option value="50">50</option>
  26. <option value="100">100</option>
  27. <option value="100000">Tutti</option>
  28. </select>
  29. </div>
  30. <div class="col-md-3">elementi</div>
  31. </div>
  32. </div>
  33. <div class="col-md-4" style="text-align:right">
  34. <a href="#" class="showHideFilter btn--ui" ><i class="fa-solid fa-sliders"></i></a><br>
  35. </div>
  36. </div>
  37. <div class="showFilter" style="display:none; margin-top:10px;" wire:ignore.self>
  38. <hr size="1">
  39. <div class="row g-3">
  40. <div class="col-md-2">
  41. <div class="row">
  42. <div class="col-md-12" style="margin-bottom:10px;">
  43. <b>Anno</b>
  44. </div>
  45. <div class="col-12">
  46. <select class="form-select filterYear" >
  47. <option value="">--Seleziona--
  48. @foreach($course_years as $c)
  49. @php
  50. $selected = '';
  51. try
  52. {
  53. list($f, $t) = explode("-", $c);
  54. if ($f == date("Y"))
  55. $selected = 'selected';
  56. } catch (Exception $e) {
  57. }
  58. @endphp
  59. <option value="{{$c}}" {{$selected}}>{{$c}}
  60. @endforeach
  61. </select>
  62. </div>
  63. </div>
  64. </div>
  65. <div class="col-md-2">
  66. <div class="row">
  67. <div class="col-md-12" style="margin-bottom:10px;">
  68. <b>Corso</b>
  69. </div>
  70. <div class="col-12" >
  71. <select class="form-select filterCourse" multiple="multiple" wire:model="filterCourse">
  72. @foreach($courses as $c)
  73. <option value="{{$c}}">{{$c}}
  74. @endforeach
  75. </select>
  76. </div>
  77. </div>
  78. </div>
  79. <div class="col-md-2">
  80. <div class="row">
  81. <div class="col-md-12" style="margin-bottom:10px;">
  82. <b>Livello</b>
  83. </div>
  84. <div class="col-12">
  85. <select class="form-select filterLevel" multiple="multiple" wire:model="filterLevel">
  86. @foreach($course_levels as $c)
  87. <option value="{{$c->id}}">{{$c->name}}
  88. @endforeach
  89. </select>
  90. </div>
  91. </div>
  92. </div>
  93. <div class="col-md-2">
  94. <div class="row">
  95. <div class="col-md-12" style="margin-bottom:10px;">
  96. <b>Frequenza</b>
  97. </div>
  98. <div class="col-12">
  99. <select class="form-select filterFrequency" multiple="multiple" wire:model="filterFrequency">
  100. @foreach($course_frequencies as $c)
  101. <option value="{{$c->id}}">{{$c->name}}
  102. @endforeach
  103. </select>
  104. </div>
  105. </div>
  106. </div>
  107. <div class="col-md-2">
  108. <div class="row">
  109. <div class="col-md-12" style="margin-bottom:10px;">
  110. <b>Tipologia</b>
  111. </div>
  112. <div class="col-12">
  113. <select class="form-select filterType" multiple="multiple" wire:model="filterType">
  114. @foreach($course_types as $c)
  115. <option value="{{$c->id}}">{{$c->name}}
  116. @endforeach
  117. </select>
  118. </div>
  119. </div>
  120. </div>
  121. <div class="col-md-2">
  122. <div class="row">
  123. <div class="col-md-12" style="margin-bottom:10px;">
  124. <b>Durata</b>
  125. </div>
  126. <div class="col-12">
  127. <select class="form-select filterDuration" multiple="multiple" wire:model="filterDuration">
  128. @foreach($course_durations as $c)
  129. <option value="{{$c->id}}">{{$c->name}}
  130. @endforeach
  131. </select>
  132. </div>
  133. </div>
  134. </div>
  135. </div>
  136. <div class="row g-3" style="margin-top:20px;">
  137. <div class="col-md-12" style="text-align:right">
  138. <button class="btn--ui_outline light" onclick="reset()">CANCELLA</button>
  139. <button class="btn--ui" wire:click="search()">FILTRA</button>
  140. </div>
  141. </div>
  142. <hr size="1">
  143. </div>
  144. <div class="row text-right">
  145. <div class="col-md-12" style="text-align:right">
  146. <button style="display:none; width:200px;" class="btn--ui btNewPayment" onclick="newPayment()">NUOVA ENTRATA</button>
  147. <button class="btn--ui primary btStopPayment" style="display:none; width:200px; color:white" onclick="suspendPayment()">Sospendi</button>
  148. <button class="btn--ui primary btResumePayment" style="display:none; width:200px; color:white" onclick="resumePayment()">Riattiva</button>
  149. </div>
  150. </div>
  151. <section id="resume-table" class="scrollTable" style="margin-top:10px;">
  152. <div class="compare--chart_wrapper d-none"></div>
  153. <table class="table tablesaw tableHead tablesaw-stack pagamento--corsi display nowrap" id="tablesaw-350" width="100%">
  154. <thead>
  155. <tr>
  156. <th scope="col" class="sticky-col-header first-zero"></th>
  157. <th scope="col" class="sticky-col-header first-col" >Corso</th>
  158. <th scope="col" class="sticky-col-header second-col"><a wire:click="setSort(2)" style="cursor:pointer">Cognome</a></th>
  159. <th scope="col" class="sticky-col-header third-col"><a wire:click="setSort(3)" style="cursor:pointer">Nome</a></th>
  160. <th scope="col"><a wire:click="setSort(4)" style="cursor:pointer">Iscrizione</a></th>
  161. @foreach($months as $idx => $m)
  162. <th scope="col"><a wire:click="setSort({{$idx + 5}})" style="cursor:pointer">&nbsp;&nbsp;&nbsp;&nbsp;{{$m}}</a></th>
  163. @endforeach
  164. </tr>
  165. </thead>
  166. <tbody id="checkall-target">
  167. @foreach($records as $idx => $record)
  168. <tr>
  169. <td class="sticky-col-header first-zero">{{$record["column_18"]}}</td>
  170. <td class="sticky-col-header first-col">{{$record["column_19"]}}</td>
  171. <td class="sticky-col-header second-col">{{$record["column_0"]}}</td>
  172. <td class="sticky-col-header third-col">{{$record["column_1"]}}</td>
  173. <td>
  174. @php
  175. list($color, $value) = explode("§", $record["column_2"]);
  176. @endphp
  177. @if($color == 0)
  178. <a style="width:100%;float:right; text-align:right; display:block;{{$color == 1 ? '' : 'cursor:pointer;'}}" class="{{$color == 1 ? 'green' : 'orange'}} sub_{{$record["column_16"]}}" onclick="setSubscription('{{$record["column_15"]}}', '{{$record["column_17"]}}', '{{$record["column_16"]}}')" style="cursor: pointer;"><small>{{$value}}</small></a>
  179. @else
  180. <a style="width:100%;float:right; text-align:right; display:block;" class="{{$color == 1 ? 'green' : 'orange'}}"><small>{{$value}}</small></a>
  181. @endif
  182. </td>
  183. @for($ii=3; $ii<=14; $ii++)
  184. @php
  185. list($color, $value, $diff) = explode("§", $record["column_" . $ii]);
  186. @endphp
  187. <td>
  188. @if ($color == 'orange')
  189. <a style="{{$diff == 'X' ? 'background-color:#d9ad86' : ''}};width:100%;float:right; text-align:right; display:block; cursor:pointer;" class="{{$color}} lnk_{{$record["column_16"]}}" id="lnk_{{$record["column_15"]}}_{{$ii - 2}}_{{$record["column_17"]}}" onclick="setPayMonth('{{$record["column_15"]}}', {{$ii - 2}}, '{{$record["column_17"]}}', '{{$record["column_16"]}}')" style="cursor: pointer;"><small>{{$value}}</small></a>
  190. @else
  191. @if ($color != 'wgrey')
  192. <a style="width:100%;float:right; text-align:right; display:block;" class="{{$color}}"><small>{{$value}}</small></a>
  193. @endif
  194. @endif
  195. </td>
  196. @endfor
  197. </tr>
  198. @endforeach
  199. </tbody>
  200. <tfoot id="checkall-target">
  201. <tr>
  202. <th class="sticky-col-header first-zero"></th>
  203. <th class="sticky-col-header first-col"></th>
  204. <th class="sticky-col-header second-col"></th>
  205. <th class="sticky-col-header third-col"></th>
  206. @foreach($totS as $yyy)
  207. @if (isset($yyy))
  208. <th style="padding-left:5px !important;padding-right:5px !important;">{!!$yyy!!}</th>
  209. @else
  210. <th style="padding-left:5px !important;padding-right:5px !important;">aa</th>
  211. @endif
  212. @endforeach
  213. <!--<th style="padding-left:5px !important;padding-right:5px !important;"></th>
  214. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  215. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  216. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  217. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  218. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  219. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  220. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  221. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  222. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  223. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  224. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  225. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  226. <th style="padding-left:5px !important;padding-right:5px !important;"></th>
  227. <th style="padding-left:5px !important;padding-right:5px !important;"></th>-->
  228. </tr>
  229. </tfoot>
  230. </table>
  231. <div class="row">
  232. <div class="col-md-6">
  233. Vista da {{(($currentPage - 1) * $pageLength) + 1}} a {{$currentPage * $pageLength}} di {{$totalRecords}} elementi
  234. </div>
  235. <div class="col-md-6" style="text-align:right">
  236. <ul class="pagination" style="margin:0px !important;float:right">
  237. @if($pages < 10)
  238. @for($p=1; $p<=$pages;$p++)
  239. <li class="page-item {{$p == $currentPage ? 'active' : ''}}"><a class="page-link" wire:click="setPage({{$p}})" href="#">{{$p}}</a></li>
  240. @endfor
  241. @else
  242. <li class="page-item {{1 == $currentPage ? 'active' : ''}}"><a class="page-link" wire:click="setPage(1)" href="#">1</a></li>
  243. @if($currentPage > 4)
  244. <li class="page-item "><a class="page-link" href="#">...</a></li>
  245. @endif
  246. @for($p=2; $p<=$pages - 1;$p++)
  247. @if($p > $currentPage - 3 && $p < $currentPage + 3)
  248. <li class="page-item {{$p == $currentPage ? 'active' : ''}}"><a class="page-link" wire:click="setPage({{$p}})" href="#">{{$p}}</a></li>
  249. @endif
  250. @endfor
  251. @if($currentPage < ($pages - 3))
  252. <li class="page-item "><a class="page-link" href="#">...</a></li>
  253. @endif
  254. <li class="page-item {{$pages == $currentPage ? 'active' : ''}}"><a class="page-link" wire:click="setPage({{$pages}})" href="#">{{$pages}}</a></li>
  255. @endif
  256. </ul>
  257. </div>
  258. </div>
  259. </section>
  260. </div>
  261. @push('scripts')
  262. @endpush
  263. @push('scripts')
  264. <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
  265. <style>
  266. @media (min-width: 992px) {
  267. .sidebar--ui ~ div.col {
  268. max-height: 100vh;
  269. }
  270. }
  271. .scrollTable {
  272. padding: 15px;
  273. max-width: 100% !important;
  274. overflow-x: auto;
  275. overflow-y: auto;
  276. white-space: nowrap;
  277. border: 1px solid #ddd;
  278. }
  279. ::-webkit-scrollbar-thumb {
  280. background: #e4e4e4;
  281. border-radius: 10px;
  282. }
  283. .select2-container--default .select2-selection--single{
  284. background-color: #E9F0F5;
  285. border: 0.0625rem solid #DFE5EB;
  286. font-size: 0.75rem;
  287. }
  288. .select2-selection
  289. {
  290. height: 38px !important;
  291. }
  292. .select2-selection__rendered
  293. {
  294. padding-top:3px;
  295. }
  296. .select2 {
  297. width:100% !important;
  298. }
  299. tfoot #checkall-target > tr > th
  300. {
  301. padding-right:5px !important;
  302. }
  303. /*.container-fluid
  304. {
  305. display: table-row !important;
  306. }
  307. .row.row.header--gestionale
  308. {
  309. padding-left:20px !important;
  310. }*/
  311. </style>
  312. <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  313. <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
  314. @endpush
  315. @push('scripts')
  316. <link href="/css/datatables.css" rel="stylesheet" />
  317. <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  318. <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
  319. <style>
  320. #tablesaw-350_wrapper > div.justify-content-between
  321. {
  322. background-color: white;
  323. position: sticky;
  324. z-index: 100000;
  325. padding-top:10px;
  326. top: -15px;
  327. left: 0px;
  328. }
  329. /*.table-v-scroll > div, #checkall-target
  330. {
  331. overflow-x: auto !important;
  332. overflow-y: hidden !important;
  333. }*/
  334. table.tableHead thead {
  335. /* Important */
  336. position: sticky;
  337. z-index: 100;
  338. top: -17px;
  339. }
  340. table thead {
  341. /* Important */
  342. position: sticky;
  343. z-index: 100;
  344. top: 0;
  345. }
  346. .select2-container--default .select2-selection--single{
  347. background-color: #E9F0F5;
  348. border: 0.0625rem solid #DFE5EB;
  349. font-size: 0.75rem;
  350. }
  351. .select2-selection
  352. {
  353. height: 38px !important;
  354. }
  355. .select2-selection__rendered
  356. {
  357. padding-top:3px;
  358. }
  359. .select2 {
  360. width:100% !important;
  361. }
  362. .select2-selection--multiple{
  363. overflow: hidden !important;
  364. height: auto !important;
  365. }
  366. .select2-container {
  367. box-sizing: border-box;
  368. display: inline-block;
  369. margin: 0;
  370. position: relative;
  371. vertical-align: middle;
  372. }
  373. .select2-container .select2-selection--single {
  374. box-sizing: border-box;
  375. cursor: pointer;
  376. display: block;
  377. height: 38px;
  378. user-select: none;
  379. -webkit-user-select: none;
  380. }
  381. .select2-container .select2-selection--single .select2-selection__rendered {
  382. display: block;
  383. padding-left: 8px;
  384. padding-right: 20px;
  385. overflow: hidden;
  386. text-overflow: ellipsis;
  387. white-space: nowrap;
  388. }
  389. .select2-selection__choice__display{
  390. color:#000000 !important;
  391. }
  392. .sticky-col-header {
  393. position: -webkit-sticky !important;
  394. position: sticky !important;
  395. background-color: '#f6f8fa' !important;
  396. }
  397. .sticky-col {
  398. position: -webkit-sticky !important;
  399. position: sticky !important;
  400. background-color: white;
  401. }
  402. .first-zero {
  403. width: 20px;
  404. min-width: 20px;
  405. max-width: 20px;
  406. left: 0px;
  407. z-index:99;
  408. }
  409. .first-col {
  410. width: 100px;
  411. min-width: 100px;
  412. max-width: 100px;
  413. left: 0px;
  414. z-index:99;
  415. }
  416. .second-col {
  417. width: 150px;
  418. min-width: 150px;
  419. max-width: 150px;
  420. left: 100px;
  421. z-index:99;
  422. }
  423. .third-col {
  424. width: 150px;
  425. min-width: 150px;
  426. max-width: 150px;
  427. left: 250px;
  428. z-index:99;
  429. }
  430. </style>
  431. <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
  432. <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
  433. <script src="/assets/js/datatables.js"></script>
  434. <script src="https://cdn.datatables.net/buttons/3.0.2/js/buttons.dataTables.js"></script>
  435. <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
  436. <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
  437. <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
  438. @endpush
  439. @push('scripts')
  440. <script>
  441. var totals = '';
  442. $(document).ready(function() {
  443. loadDataTable();
  444. } );
  445. $('.filterYear').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  446. $('.filterYear').val('{{date("Y")-1}}-{{date("Y")}}').trigger("change");
  447. $('.filterCourse').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  448. $('.filterCourse').on('change', function (e) {
  449. var data = $('.filterCourse').select2("val");
  450. if (data == null) data = [];
  451. @this.set('filterCourse', data);
  452. //@this.search();
  453. });
  454. $('.filterLevel').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  455. $('.filterLevel').on('change', function (e) {
  456. var data = $('.filterLevel').select2("val");
  457. if (data == null) data = [];
  458. @this.set('filterLevel', data);
  459. //@this.search();
  460. });
  461. $('.filterFrequency').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  462. $('.filterFrequency').on('change', function (e) {
  463. var data = $('.filterFrequency').select2("val");
  464. if (data == null) data = [];
  465. @this.set('filterFrequency', data);
  466. //@this.search();
  467. });
  468. $('.filterType').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  469. $('.filterType').on('change', function (e) {
  470. var data = $('.filterType').select2("val");
  471. if (data == null) data = [];
  472. @this.set('filterType', data);
  473. //@this.search();
  474. });
  475. $('.filterDuration').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  476. $('.filterDuration').on('change', function (e) {
  477. var data = $('.filterDuration').select2("val");
  478. if (data == null) data = [];
  479. // @this.set('filterDuration', data);
  480. //@this.search();
  481. });
  482. Livewire.on('load-data-table', () => {
  483. $('.filterYear').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  484. $('.filterCourse').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  485. $('.filterLevel').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  486. $('.filterFrequency').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  487. $('.filterType').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  488. $('.filterDuration').select2({"language": {"noResults": function(){return "Nessun risultato";}}});
  489. loadDataTable();
  490. setTimeout(() => {
  491. setMaxWidth();
  492. setMaxHeight();
  493. }, 1);
  494. });
  495. Livewire.on('destroy-data-table', () => {
  496. $('#tablesaw-350').DataTable().destroy();
  497. });
  498. function destroyDataTable()
  499. {
  500. $('#tablesaw-350').DataTable().destroy();
  501. }
  502. var isFilter = false;
  503. $(document).ready(function() {
  504. $(document).on("click",".showHideFilter",function() {
  505. if (isFilter)
  506. {
  507. isFilter = false;
  508. $(".showFilter").hide();
  509. }
  510. else
  511. {
  512. isFilter = true;
  513. $(".showFilter").show();
  514. }
  515. });
  516. } );
  517. function searchAction()
  518. {
  519. //destroyDataTable();
  520. //@this.search();
  521. }
  522. @if(isset($_GET["showFilters"]))
  523. var filterYear = localStorage.getItem("filterYearCourseList");
  524. if (filterYear)
  525. {
  526. $('.filterYear').val(filterYear).trigger('change');
  527. }
  528. var filterCourse = localStorage.getItem("filterCourseCourseList");
  529. if (filterCourse)
  530. {
  531. $('.filterCourse').val(filterCourse).trigger('change');
  532. }
  533. var filterLevel = localStorage.getItem("filterLevelCourseList");
  534. if (filterLevel)
  535. {
  536. $('.filterLevel').val(filterLevel).trigger('change');
  537. }
  538. var filterFrequency = localStorage.getItem("filterFrequencyCourseList");
  539. if (filterFrequency)
  540. {
  541. $('.filterFrequency').val(filterFrequency).trigger('change');
  542. }
  543. var filterDuration = localStorage.getItem("filterDurationCourseList");
  544. if (filterDuration)
  545. {
  546. $('.filterDuration').val(filterDuration).trigger('change');
  547. }
  548. var filterType = localStorage.getItem("filterTypeCourseList");
  549. if (filterType)
  550. {
  551. $('.filterType').val(filterType).trigger('change');
  552. }
  553. @endif
  554. function reset()
  555. {
  556. $('.filterYear').val(null).trigger("change");
  557. $('.filterCourse').val(null).trigger("change");
  558. $('.filterLevel').val(null).trigger("change");
  559. $('.filterFrequency').val(null).trigger("change");
  560. $('.filterDuration').val(null).trigger("change");
  561. $('.filterType').val(null).trigger("change");
  562. destroyDataTable();
  563. //localStorage.clear();
  564. loadDataTable();
  565. }
  566. function loadDataTable(){
  567. /*
  568. if ( $.fn.DataTable.isDataTable('#tablesaw-350') ) {
  569. $('#tablesaw-350').DataTable().destroy();
  570. }
  571. var filterYear = $('.filterYear').val();
  572. localStorage.setItem("filterYearCourseList", filterYear);
  573. var filterCourse = $('.filterCourse').val();
  574. localStorage.setItem("filterCourseCourseList", filterCourse);
  575. var filterLevel = $('.filterLevel').val();
  576. localStorage.setItem("filterLevelCourseList", filterLevel);
  577. var filterDuration = $('.filterDuration').val();
  578. localStorage.setItem("filterDurationCourseList", filterDuration);
  579. var filterFrequency = $('.filterFrequency').val();
  580. localStorage.setItem("filterFrequencyCourseList", filterFrequency);
  581. var filterType = $('.filterType').val();
  582. localStorage.setItem("filterTypeCourseList", filterType);
  583. */
  584. /*
  585. var output_table = $('#tablesaw-350').DataTable({
  586. //scrollX: true,
  587. //scrollY: true,
  588. //scrollCollapse: true,
  589. scrollY: '400px',
  590. serverSide: true,
  591. ajax: {
  592. url : '/get_course_list?filterCourse=' + filterCourse + '&filterDuration=' + filterDuration + '&filterLevel=' + filterLevel + '&filterType=' + filterType + '&filterFrequency=' + filterFrequency + '&filterYear=' + filterYear,
  593. dataSrc: function (json){
  594. if(json.totals){
  595. totals = json.totals;
  596. }
  597. return json.data;
  598. }
  599. },
  600. thead: {
  601. 'th': {'background-color': 'blue'}
  602. },
  603. columns: [
  604. {
  605. data: 'column_18',
  606. "orderable": false,
  607. className: 'red',
  608. render: function (data, type, row, meta){
  609. return data;
  610. }
  611. },
  612. {
  613. data: 'column_19',
  614. className: 'red',
  615. className: 'sticky-col first-col'
  616. },
  617. {
  618. data: 'column_0',
  619. className: 'red',
  620. className: 'sticky-col second-col',
  621. render: function (data, type, row){
  622. var ret = '<a href="/members?member_detail=' + row["column_17"] + '&from=course_list">' + data + '</a>';
  623. return ret;
  624. }
  625. },
  626. {
  627. data: 'column_1',
  628. className: 'sticky-col third-col',
  629. render: function (data, type, row){
  630. const x = data.split("§");
  631. var ret = '<a href="/members?member_detail=' + row["column_17"] + '&from=course_list">' + data + '</a>';
  632. return ret;
  633. }
  634. },
  635. {
  636. data: 'column_2',
  637. orderSequence: ['asc', 'desc'],
  638. className: 'ciccio',
  639. render: function (data, type, row){
  640. const x = data.split("§");
  641. var ret = '';
  642. if (x[0] == 0)
  643. {
  644. 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>';
  645. }
  646. else if (x[0] == 'yellow')
  647. {
  648. 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"] + row["column_17"] + '" onclick="resumePayMonth(' + row["column_15"] + ', ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  649. }
  650. else
  651. {
  652. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + (x[0] == 1 ? 'green' : 'orange') + '"><small>' + x[1] + '</small></a>';
  653. }
  654. return ret;
  655. }
  656. },
  657. {
  658. data: 'column_3',
  659. orderSequence: ['asc', 'desc'],
  660. render: function (data, type, row, meta){
  661. const x = data.split("§");
  662. var ret = '';
  663. if (x[0] == 'orange')
  664. {
  665. 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>';
  666. }
  667. else if (x[0] == 'yellow')
  668. {
  669. 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="resumePayMonth(' + row["column_15"] + ', 1, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  670. }
  671. else
  672. {
  673. if (x[0] != 'wgrey')
  674. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  675. }
  676. return ret;
  677. }
  678. },
  679. {
  680. data: 'column_4',
  681. orderSequence: ['asc', 'desc'],
  682. render: function (data, type, row, meta){
  683. const x = data.split("§");
  684. var ret = '';
  685. if (x[0] == 'orange')
  686. {
  687. 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>';
  688. }
  689. else if (x[0] == 'yellow')
  690. {
  691. 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="resumePayMonth(' + row["column_15"] + ',2, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  692. }
  693. else
  694. {
  695. if (x[0] != 'wgrey')
  696. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  697. }
  698. return ret;
  699. }
  700. },
  701. {
  702. data: 'column_5',
  703. orderSequence: ['asc', 'desc'],
  704. render: function (data, type, row, meta){
  705. const x = data.split("§");
  706. var ret = '';
  707. if (x[0] == 'orange')
  708. {
  709. 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>';
  710. }
  711. else if (x[0] == 'yellow')
  712. {
  713. 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="resumePayMonth(' + row["column_15"] + ', 3, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  714. }
  715. else
  716. {
  717. if (x[0] != 'wgrey')
  718. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  719. }
  720. return ret;
  721. }
  722. },
  723. {
  724. data: 'column_6',
  725. orderSequence: ['asc', 'desc'],
  726. render: function (data, type, row, meta){
  727. const x = data.split("§");
  728. var ret = '';
  729. if (x[0] == 'orange')
  730. {
  731. 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>';
  732. }
  733. else if (x[0] == 'yellow')
  734. {
  735. 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="resumePayMonth(' + row["column_15"] + ', 4, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  736. }
  737. else
  738. {
  739. if (x[0] != 'wgrey')
  740. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  741. }
  742. return ret;
  743. }
  744. },
  745. {
  746. data: 'column_7',
  747. orderSequence: ['asc', 'desc'],
  748. render: function (data, type, row, meta){
  749. const x = data.split("§");
  750. var ret = '';
  751. if (x[0] == 'orange')
  752. {
  753. 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>';
  754. }
  755. else if (x[0] == 'yellow')
  756. {
  757. 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="resumePayMonth(' + row["column_15"] + ', 5, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  758. }
  759. else
  760. {
  761. if (x[0] != 'wgrey')
  762. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  763. }
  764. return ret;
  765. }
  766. },
  767. {
  768. data: 'column_8',
  769. orderSequence: ['asc', 'desc'],
  770. render: function (data, type, row, meta){
  771. const x = data.split("§");
  772. var ret = '';
  773. if (x[0] == 'orange')
  774. {
  775. 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>';
  776. }
  777. else if (x[0] == 'yellow')
  778. {
  779. 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="resumePayMonth(' + row["column_15"] + ', 6, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  780. }
  781. else
  782. {
  783. if (x[0] != 'wgrey')
  784. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  785. }
  786. return ret;
  787. }
  788. },
  789. {
  790. data: 'column_9',
  791. orderSequence: ['asc', 'desc'],
  792. render: function (data, type, row, meta){
  793. const x = data.split("§");
  794. var ret = '';
  795. if (x[0] == 'orange')
  796. {
  797. 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>';
  798. }
  799. else if (x[0] == 'yellow')
  800. {
  801. 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="resumePayMonth(' + row["column_15"] + ', 7, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  802. }
  803. else
  804. {
  805. if (x[0] != 'wgrey')
  806. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  807. }
  808. return ret;
  809. }
  810. },
  811. {
  812. data: 'column_10',
  813. orderSequence: ['asc', 'desc'],
  814. render: function (data, type, row, meta){
  815. const x = data.split("§");
  816. var ret = '';
  817. if (x[0] == 'orange')
  818. {
  819. 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>';
  820. }
  821. else if (x[0] == 'yellow')
  822. {
  823. 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="resumePayMonth(' + row["column_15"] + ', 8, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  824. }
  825. else
  826. {
  827. if (x[0] != 'wgrey')
  828. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  829. }
  830. return ret;
  831. }
  832. },
  833. {
  834. data: 'column_11',
  835. orderSequence: ['asc', 'desc'],
  836. render: function (data, type, row, meta){
  837. const x = data.split("§");
  838. var ret = '';
  839. if (x[0] == 'orange')
  840. {
  841. 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>';
  842. }
  843. else if (x[0] == 'yellow')
  844. {
  845. 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="resumePayMonth(' + row["column_15"] + ', 9, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  846. }
  847. else
  848. {
  849. if (x[0] != 'wgrey')
  850. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  851. }
  852. return ret;
  853. }
  854. },
  855. {
  856. data: 'column_12',
  857. orderSequence: ['asc', 'desc'],
  858. render: function (data, type, row, meta){
  859. const x = data.split("§");
  860. var ret = '';
  861. if (x[0] == 'orange')
  862. {
  863. 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>';
  864. }
  865. else if (x[0] == 'yellow')
  866. {
  867. 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="resumePayMonth(' + row["column_15"] + ', 10, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  868. }
  869. else
  870. {
  871. if (x[0] != 'wgrey')
  872. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  873. }
  874. return ret;
  875. }
  876. },
  877. {
  878. data: 'column_13',
  879. orderSequence: ['asc', 'desc'],
  880. render: function (data, type, row, meta){
  881. const x = data.split("§");
  882. var ret = '';
  883. if (x[0] == 'orange')
  884. {
  885. 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>';
  886. }
  887. else if (x[0] == 'yellow')
  888. {
  889. 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="resumePayMonth(' + row["column_15"] + ', 11, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  890. }
  891. else
  892. {
  893. if (x[0] != 'wgrey')
  894. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  895. }
  896. return ret;
  897. }
  898. },
  899. {
  900. data: 'column_14',
  901. orderSequence: ['asc', 'desc'],
  902. render: function (data, type, row, meta){
  903. const x = data.split("§");
  904. var ret = '';
  905. if (x[0] == 'orange')
  906. {
  907. 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>';
  908. }
  909. else if (x[0] == 'yellow')
  910. {
  911. 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="resumePayMonth(' + row["column_15"] + ', 12, ' + row["column_17"] + ', ' + row["column_16"] + ')" style="cursor: pointer;"><small>' + x[1] + '</small></a>';
  912. }
  913. else
  914. {
  915. if (x[0] != 'wgrey')
  916. ret = '<a style="width:100%;float:right; text-align:right; display:block;" class="' + x[0] + '"><small>' + x[1] + '</small></a>';
  917. }
  918. return ret;
  919. }
  920. }
  921. ],
  922. layout: {
  923. topStart : null,
  924. topEnd : null,
  925. top1A: {
  926. buttons: [
  927. {
  928. extend: 'collection',
  929. text: 'Esporta',
  930. buttons: [
  931. {
  932. extend: 'excelHtml5',"action":newexportaction,
  933. title: 'Pagamento corsi',
  934. orientation: 'landscape',
  935. exportOptions: {
  936. columns: ":not(':last')"
  937. },
  938. footer:false,
  939. customize: function(xlsx) {
  940. var sheet = xlsx.xl.worksheets['sheet1.xml'];
  941. const letters = ["E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q"];
  942. for(y=0; y<letters.length; y++)
  943. {
  944. z = y + 4;
  945. var c = output_table.column(z).data().toArray();
  946. //console.log(c);
  947. for (var i = 0; i < c.length; i++)
  948. {
  949. var j = c[i].split("§");
  950. if (j[0] == '0' || j[0] == 'orange')
  951. {
  952. $('row:nth-child('+(i+3)+') [r^="' + letters[y] + '"]', sheet).attr('s', '10');
  953. //sheet.table.body[i+1][z].fillColor = 'orange';
  954. }
  955. if (j[0] == '1' || j[0] == 'green')
  956. {
  957. $('row:nth-child('+(i+3)+') [r^="' + letters[y] + '"]', sheet).attr('s', '40');
  958. //doc.content[1].table.body[i+1][z].fillColor = 'green';
  959. }
  960. if (j[0] == 'yellow')
  961. {
  962. $('row:nth-child('+(i+3)+') [r^="' + letters[y] + '"]', sheet).attr('s', '20');
  963. //doc.content[1].table.body[i+1][z].fillColor = 'blue';
  964. }
  965. }
  966. }
  967. },
  968. },
  969. {
  970. extend: 'pdfHtml5',"action":newexportaction,
  971. title: 'Pagamento corsi',
  972. orientation: 'landscape',
  973. exportOptions: {
  974. columns: ":not(':last')"
  975. },
  976. footer:false,
  977. customize: function(doc) {
  978. for(z=4; z<=16; z++)
  979. {
  980. var c = output_table.column(z).data().toArray();
  981. for (var i = 0; i < c.length; i++)
  982. {
  983. var j = c[i].split("§");
  984. if (j[0] == '0' || j[0] == 'orange')
  985. {
  986. doc.content[1].table.body[i+1][z].fillColor = 'orange';
  987. }
  988. if (j[0] == '1' || j[0] == 'green')
  989. {
  990. doc.content[1].table.body[i+1][z].fillColor = 'green';
  991. }
  992. if (j[0] == 'yellow')
  993. {
  994. doc.content[1].table.body[i+1][z].fillColor = 'blue';
  995. }
  996. }
  997. }
  998. }
  999. }
  1000. ],
  1001. dropup: true
  1002. }
  1003. ]
  1004. },
  1005. top1B : {
  1006. pageLength: {
  1007. menu: [[10, 25, 50, 100, 100000], [10, 25, 50, 100, "Tutti"]]
  1008. }
  1009. },
  1010. top1C :'search',
  1011. },
  1012. order: [[2, 'asc'], [3, 'asc']],
  1013. pagingType: 'numbers',
  1014. "language": {
  1015. "url": "/assets/js/Italian.json"
  1016. },
  1017. "fnInitComplete": function (oSettings, json) {
  1018. var html = '&nbsp;<a href="#" class="showHideFilter btn--ui"><i class="fa-solid fa-sliders"></i></a>';
  1019. $(".dt-search").append(html);
  1020. },
  1021. "footerCallback": function (row, data, start, end, display) {
  1022. let api = this.api();
  1023. api.column(0).footer().innerHTML = '';
  1024. api.column(1).footer().innerHTML = '';
  1025. api.column(2).footer().innerHTML = '';
  1026. api.column(3).footer().innerHTML = '';
  1027. for(var i=4; i<=15; i++)
  1028. {
  1029. api.column(i).footer().innerHTML = '';
  1030. }
  1031. if (totals != '')
  1032. {
  1033. totals.split("_").forEach(function (item)
  1034. {
  1035. var x = item.split("§");
  1036. if (x[1] != undefined)
  1037. api.column(x[0]).footer().innerHTML = x[1];
  1038. else
  1039. api.column(x[0]).footer().innerHTML = '';
  1040. });
  1041. }
  1042. }
  1043. });
  1044. $('#tablesaw-350 thead tr th').addClass('col');
  1045. $('#tablesaw-350 thead tr th').css("background-color", "#f6f8fa");
  1046. $('#tablesaw-350').on('draw.dt', function() {
  1047. $('[data-bs-toggle="popover"]').popover()
  1048. });
  1049. */
  1050. jQuery.fn.dataTable.Api.register( 'sum()', function ( ) {
  1051. return this.flatten().reduce( function ( a, b ) {
  1052. if ( typeof a === 'string') {
  1053. start = a.indexOf("€");
  1054. a = a.substr(start + 2).replace("</small></a>", "").replace(",",".") * 1;
  1055. }
  1056. if ( typeof b === 'string' && b.indexOf('green') > 0) {
  1057. start = b.indexOf("€");
  1058. b = b.substr(start + 2).replace("</small></a>", "").replace(",",".") * 1;
  1059. }
  1060. else
  1061. {
  1062. b = 0;
  1063. }
  1064. return a + b;
  1065. }, 0 );
  1066. } );
  1067. }
  1068. Livewire.on('setTotals', (tot) =>
  1069. {
  1070. totals = tot;
  1071. console.log(totals);
  1072. });
  1073. var subscription = false;
  1074. var months = [];
  1075. var selectedCourseId = 0;
  1076. var selectedMemberId = 0;
  1077. var selectedMemberCourseId = 0;
  1078. var selectedMonth = 0;
  1079. function setPayMonth(course_id, month, member_id, id)
  1080. {
  1081. if (selectedMemberId > 0 && selectedMemberId != member_id)
  1082. {
  1083. months = [];
  1084. subscription = false;
  1085. }
  1086. if (selectedMemberCourseId != id)
  1087. {
  1088. $(".sub_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  1089. $(".lnk_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  1090. }
  1091. selectedCourseId = course_id;
  1092. selectedMemberId = member_id;
  1093. selectedMemberCourseId = id;
  1094. selectedMonth = month;
  1095. if(!months.includes(month))
  1096. {
  1097. months.push(month);
  1098. $("#lnk_" + course_id + "_" + month + "_" + member_id).addClass("blue").addClass("selected").removeClass("orange");
  1099. }
  1100. else
  1101. {
  1102. months.splice(months.indexOf(months), 1);
  1103. $("#lnk_" + course_id + "_" + month + "_" + member_id).addClass("orange").removeClass("blue").removeClass("selected");
  1104. }
  1105. if (months.length > 0)
  1106. {
  1107. $(".btNewPayment").show();
  1108. $(".btStopPayment").show();
  1109. }
  1110. else
  1111. {
  1112. $(".btNewPayment").hide();
  1113. $(".btStopPayment").hide();
  1114. }
  1115. }
  1116. function resumePayMonth(course_id, month, member_id, id)
  1117. {
  1118. if (selectedMemberId > 0 && selectedMemberId != member_id)
  1119. {
  1120. months = [];
  1121. subscription = false;
  1122. }
  1123. if (selectedMemberCourseId != id)
  1124. {
  1125. $(".sub_" + selectedMemberCourseId).removeClass("orange").addClass("blue").addClass("selected");
  1126. $(".lnk_" + selectedMemberCourseId).removeClass("orange").addClass("blue").addClass("selected");
  1127. }
  1128. selectedCourseId = course_id;
  1129. selectedMemberId = member_id;
  1130. selectedMemberCourseId = id;
  1131. selectedMonth = month;
  1132. console.log(month);
  1133. if(!months.includes(month))
  1134. {
  1135. months.push(month);
  1136. $("#lnk_" + course_id + "_" + month + "_" + member_id).removeClass("blue").removeClass("selected").addClass("orange").addClass("selected");
  1137. }
  1138. else
  1139. {
  1140. months.splice(months.indexOf(months), 1);
  1141. $("#lnk_" + course_id + "_" + month + "_" + member_id).removeClass("orange").addClass("blue").addClass("selected");
  1142. }
  1143. if (months.length > 0)
  1144. {
  1145. $(".btResumePayment").show();
  1146. }
  1147. else
  1148. {
  1149. $(".btResumePayment").hide();
  1150. }
  1151. }
  1152. function setSubscription(course_id, member_id, id)
  1153. {
  1154. if (selectedMemberCourseId != id)
  1155. {
  1156. $(".sub_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  1157. $(".lnk_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  1158. months = [];
  1159. subscription = false;
  1160. }
  1161. selectedCourseId = course_id;
  1162. selectedMemberId = member_id;
  1163. selectedMemberCourseId = id;
  1164. if (subscription)
  1165. {
  1166. $(".sub_" + selectedMemberCourseId).addClass("orange").removeClass("blue").removeClass("selected");
  1167. subscription = false;
  1168. $(".btNewPayment").hide();
  1169. }
  1170. else
  1171. {
  1172. $(".sub_" + selectedMemberCourseId).addClass("blue").addClass("selected").removeClass("orange");
  1173. subscription = true;
  1174. $(".btNewPayment").show();
  1175. }
  1176. }
  1177. function newPayment()
  1178. {
  1179. @this.newPayment(selectedCourseId, months.toString(), selectedMemberId, selectedMemberCourseId, subscription);
  1180. }
  1181. function suspendPayment()
  1182. {
  1183. @this.suspendPayment(selectedCourseId, selectedMonth, selectedMemberId, selectedMemberCourseId, subscription);
  1184. }
  1185. function resumePayment()
  1186. {
  1187. @this.resumePayment(selectedCourseId, selectedMonth, selectedMemberId, selectedMemberCourseId, subscription);
  1188. }
  1189. $( document ).ready( function(){
  1190. setMaxWidth();
  1191. setMaxHeight();
  1192. $( window ).bind( "resize", setMaxWidth );
  1193. $( window ).bind( "resize", setMaxHeight );
  1194. });
  1195. function setMaxWidth() {
  1196. $("#resume-table").width( Math.round( $(window ).width() - size ) ) ;
  1197. //$(".justify-content-between").css({"width": Math.round( $(window ).width() - size) + "px;"}); //.width( Math.round( $(window ).width() - size ) ) ;
  1198. }
  1199. function setMaxHeight() {
  1200. console.log('height:' + $(window ).height() + 'px !important');
  1201. //$("div.row.h-100").attr('style', 'height:' + ($(window ).height() + 50) + 'px !important');
  1202. $("#resume-table").height( Math.round( $(window ).height() - 220 ) ) ;
  1203. }
  1204. </script>
  1205. @endpush