templates/incassi.html.twig line 1

Open in your IDE?
  1. {% extends 'base.html.twig' %}
  3. {% set currentPath = path(app.request.attributes.get('_route')) %}
  5. {% block body %}
  6. <div class="container">
  7.   <div class="row">
  8.       <div id="loader" class="col s12 progress" style="display:none"><div class="indeterminate"></div></div>
  9.       <div class="col s12">
  10.       <div class="card">
  11.           <div class="card-content">
  12.               <!-- <span class="card-title">Filters</span> -->
  13.               <div class="row">
  14.                 <h5>Gestione Incassi / Rimborsi</h5>
  15.                 <p class="hint blue-grey lighten-5">HINT - Per l'assegnazione delle Note di Credito selezionare Fatture/Rimborsi</p>
  16.                 <div class="col s2">
  17.                     <select name="filter-order-type">
  18.                         <option value="fatture">Fatture</option>
  19.                         <option value="note-credito">Note Credito</option>
  20.                         <option value="corrispettivi">Corrispettivi</option>
  21.                     </select>
  22.                 </div>
  23.                 <div class="col s2">
  24.                     <select name="filter-tipo">
  25.                         <option value="charge" selected>Incassi</option>
  26.                         <option value="refund">Rimborsi</option>
  27.                         <option value="not-managed">Non gestiti (chargeback / payment reversal / ecc...)</option>
  28.                     </select>
  29.                 </div>
  30.                 <div class="col s2">
  31.                     <select name="filter-source">
  32.                         <option value="">Tipo pagamento</option>
  33.                         <option value="shopify">Shopify</option>
  34.                         <option value="paypal">Paypal</option>
  35.                         <option value="amazon">Amazon</option>
  36.                         <option value="klarna">Klarna</option>
  37.                     </select>
  38.                 </div>
  39.             </div>
  40.             <div class="row">
  41.                   <div class="col s2">
  42.                       <label>Transazione DA:</label>
  43.                       <input type="text" name="filter-date-from" class="datepicker">
  44.                   </div>
  45.                   <div class="col s2">
  46.                       <label>Transazione A:</label>
  47.                       <input type="text" name="filter-date-to" class="datepicker">
  48.                   </div>
  49.                   <div class="col s3">
  50.                     <div id="filter-orders-ids" class="chips chips-placeholder">
  51.                               <input name="filter-orders-ids" placeholder="Filtra per ID Ordine">
  52.                       </div>
  53.                   </div>
  54.               </div>
  55.             <div class="row">
  56.                 <div class="col s2">
  57.                       <input id="filter-credit-notes-from" name="filter-credit-notes-from" placeholder="Note Credito DA">
  58.                   </div>
  59.                 <div class="col s2">
  60.                     <input id="filter-credit-notes-to" name="filter-credit-notes-to" placeholder="Note Credito A">
  61.                   </div>
  62.                   <div class="col s2">
  63.                       <button type="button" onclick="Manebi.getIncassi()" name="submit-filter" class="btn waves-effect waves-light">RECUPERA</button>
  64.                   </div>
  65.               </div>
  66.           </div>
  67.          </div>
  68.       </div>
  69.   </div>
  70.   <div class="row">
  71.       <div class="col s12">
  72.       <div class="card">
  73.           <div class="card-content">
  74.               <div id="incassi-table-results">
  75.                   <div class="row">
  76.                       <div class="col s4">Risultati: <span id="incassi-table-results-total"></span></div>
  77.                       <div id="incassi-table-results-actions" class="col s8"></div>
  78.                   </div>
  79.               </div>
  80.               <div class="row">
  81.                   <div class="col s12"><div class="incassi-table-pagination"></div></div>
  82.               </div>
  83.               <table id="incassi-table" class="striped fixed_header">
  84.                   <thead></thead>
  85.                   <tbody></tbody>
  86.               </table>
  87.               
  88.               <div class="row">
  89.                   <div class="col s12"><div class="incassi-table-pagination"></div></div>
  90.                   <div class="col s2"><label for="incassi-table-page-size-list">Page size: <select class="incassi-table-page-size-list" name="incassi-table-page-size-list" after-render="initMaterializeSelect"></select></label></div>
  91.               </div>
  92.           </div>
  93.          </div>
  94.       </div>
  95.   </div>
  96.   {% if incassiSenzaOrdine|length > 0 %}
  97.   <div class="row">
  98.       <div class="col s12 alert">
  99.           <div class="card">
  100.               <div class="card-content" style="color:red">
  101.               <strong>Attenzione! Ci sono {{ incassiSenzaOrdine|length }} incassi/rimborsi per i quali non è possibile associare un ordine (Fattura/Corrispettivo). Occorre importare gli ordini relativi a questi incassi/rimborsi per poterli esportare massivamente in Profis.</strong>
  102.               <hr/>
  103.               <table id="incassiSenzaOrdine" class="table">
  104.                   <thead>
  105.                       <tr>
  106.                           <td>Ordine</td>
  107.                           <td>Gestito</td>
  108.                           <td>PaymentReference</td>
  109.                           <td>Sorgente</td>
  110.                           <td>Tipo (Incasso/Rimborso)</td> 
  111.                           <td>Totale</td> 
  112.                           <td>Data Transazione</td>
  113.                           <td>Azioni</td>
  114.                       </tr>
  115.                 </thead>
  116.                   <tbody>
  117.                       {% for i in incassiSenzaOrdine %}
  118.                       <tr id="iso-{{ i.id }}">
  119.                           <td>{{ i.Order }}</td>
  120.                           <td>{{ i.Gestito }}</td>
  121.                           <td>{{ i.PaymentReference }}</td>
  122.                           <td>{{ i.Source }}</td>
  123.                           <td>{{ i.Type }}</td> 
  124.                           <td>{% if i.Type == "charge" %}{{ i['ChargeAmount'] }}{% else %}{{ i['RefundAmount'] }}{% endif %}</td> 
  125.                           <td>{{ i.Date }}</td>
  126.                           <td><button type="button" onclick="Manebi.eliminaIncasso({{ i.id }})" class="btn-floating btn-small waves-effect waves-light red">X</button></td>
  127.                       </tr>
  128.                       {% endfor %}                                                
  129.                   </tbody>
  130.               </table>
  131.               </div>
  132.           </div>
  133.       </div>
  134.   </div>
  135.   {% endif %}
  136. </div>
  138. <!-- Modal Structure -->
  139. <div id="NotaCreditoPreviewModal" class="modal modal-fixed-footer modal-fixed-header">
  140.   <div class="modal-header"></div>
  141.   <div class="modal-content"></div>
  142.   <div class="modal-footer">
  143.     <a href="#!" class="modal-close waves-effect waves-green btn btn-small">OK</a>
  144.   </div>
  145. </div>
  147. <div id="genericPopup" class="modal modal-fixed-footer modal-fixed-header">
  148.   <div class="modal-header"></div>
  149.   <div class="modal-content"></div>
  150.   <div class="modal-footer">
  151.     <a href="#!" class="modal-close waves-effect waves-green btn btn-small">CHIUDI</a>
  152.   </div>
  153. </div>
  155. {% block javascripts %}
  156. <script src="{{ asset('tmb-data-table.v1_0.min.js') }}"></script>
  158. <script>
  159. var Manebi = {};
  160. var urlAjax = "{{ currentPath }}";
  162. var filterInstances = {'collapsible': {}, 'dates': {}, 'chips': {}, 'modals': {}, 'selects': {}};
  163. var tableInvoices = null;
  165. var incassiTableColumns =  {
  166.                     'Data Tansazione': {'headerName': 'Data Transazione', 'value': 'Date', 'sortable': true},
  167.                     'Tipo': {'headerName': 'Tipo', 'value': 'Type', 'sortable': true},
  168.                     'Source': {'headerName': 'Source', 'value': 'Source', 'sortable': true},
  169.                     'Order': {'headerName': 'Ordine', 'value': 'Order', 'sortable': true}, 
  170.                     'Fattura': {'headerName': 'Fattura', 'value': function(data){ return '<b>' + data['Fattura'] + '</b>'}, 'sortable': true},
  171.                     'Corrispettivo': {'headerName': 'Corrispettivo', 'value': function(data){ return '<b>' + data['Corrispettivo'] + '</b>'}, 'sortable': true},
  172.                     'Nota Credito': {'headerName': 'Nota Credito', 'value': function(data){ return '<b>' + data['NotaCreditoFormatted'] + '</b>'}, 'type': 'int', 'sortable': true, 'sort-by-value': 'NotaCredito'}, 
  173.                     'Total Amount': {'headerName': 'Incasso Totale', 'value': function(data){ return getPrice(data.ChargeAmount,2) + ' '+ getCurrencySymbol(data.Currency)}, 'type': 'float', 'sortable': true, 'sort-by-value': 'ChargeAmount'},
  174.                     'Charge Amount': {'headerName': 'Incasso Netto', 'value': function(data){ return getPrice(data.ChargeNet,2) + ' '+ getCurrencySymbol(data.Currency)}, 'type': 'float', 'sortable': true, 'sort-by-value': 'ChargeNet'},                
  175.                     'Charge Fee': {'headerName': 'Commissione', 'value': function(data){ return getPrice(data.ChargeFee,2) + ' '+ getCurrencySymbol(data.Currency)}, 'type': 'float', 'sortable': true, 'sort-by-value': 'ChargeFee'}
  176.                     };
  178. var rimborsiTableColumns =  {
  179.                     'Data Tansazione': {'headerName': 'Data Transazione', 'value': 'Date', 'sortable': true},
  180.                     'Tipo': {'headerName': 'Tipo', 'value': 'Type', 'sortable': true},
  181.                     'Source': {'headerName': 'Source', 'value': 'Source', 'sortable': true},
  182.                     'Order': {'headerName': 'Ordine', 'value': 'Order', 'sortable': true}, 
  183.                     'Paese': {'headerName': 'Paese', 'value': 'Shipping Country', 'sortable': true}, 
  184.                     'Fattura': {'headerName': 'Fattura', 'value': function(data){ return '<b>' + data['Fattura'] + '</b>'}, 'sortable': true},
  185.                     'Importo Fattura': {'headerName': 'Importo Fattura', 'value': function(data) { return getPrice(data.Total,2) + ' ' + getCurrencySymbol(data.Currency) }, 'sortable': true},
  186.                     'Nota Credito': {'headerName': 'Nota Credito', 'value': function(data){ return '<b>' + data['NotaCreditoFormatted'] + '</b>'}, 'type': 'int', 'sortable': true, 'sort-by-value': 'NotaCredito'}, 
  187.                     'Total Amount': {'headerName': 'Rimborso Totale', 'value': function(data){ return getPrice(data.RefundAmount,2) + ' '+ getCurrencySymbol(data.Currency) + ( (Math.abs(data.RefundAmount - data.Total) > 0.00 && Math.abs(data.RefundAmount - data.Total) <= 0.05) ? (' <i class="arrot">' + (data.RefundAmount - data.Total > 0 ? '+' : '') + getPrice(data.RefundAmount - data.Total,2) + ' ' + getCurrencySymbol(data.Currency) + '</i>') : '')}, 'type': 'float', 'sortable': true, 'sort-by-value': 'RefundAmount'},
  188.                     'Rimborso Amount': {'headerName': 'Rimborso Netto', 'value': function(data){ return getPrice(data.RefundNet,2) + ' '+ getCurrencySymbol(data.Currency)}, 'type': 'float', 'sortable': true, 'sort-by-value': 'RefundNet'},                    
  189.                     'Rimborso Fee': {'headerName': 'Rimborso Commissione', 'value': function(data){ return getPrice(data.RefundFee,2) + ' '+ getCurrencySymbol(data.Currency)}, 'type': 'float', 'sortable': true, 'sort-by-value': 'RefundFee'},
  190.                     'Azioni': {'headerName': '', 'value': function(data){
  191.                                             var o = '<div id="notacredito-actions-'+data.id+'" style="width: 120px;">' +
  192.                                             (data['NotaCredito'] != '' ? ('<a href="/admin/pdf/note-credito/'+data['NotaCredito']+'?Order=' + encodeURIComponent(data['Order']) + '" class="btn-floating btn-small waves-effect waves-light red"><i class="material-icons">picture_as_pdf</i></a>') : '') +
  193.                                                 (data['NotaCredito'] != '' && ( (Math.abs(data.RefundAmount - data.Subtotal) > 0.05) && (Math.abs(data.RefundAmount - data.Total) > 0.05) ) ? '&nbsp;<button class="btn-floating btn-small blue" onclick="refundDetails('+data.id+',\'' + data.Order + '\',\'' + data['NotaCredito'] + '\')"><i class="material-icons">table_view</i></button>' : '') +
  194.                                                 (data['NotaCredito'] != '' && ( (Math.abs(data.RefundAmount - data.Subtotal) > 0.05) && (Math.abs(data.RefundAmount - data.Total) > 0.05) && (data['NC_Prodotti'] == 0 && data['NC_Spedizioni'] == 0 )) ? '&nbsp;<button class="btn-floating btn-small orange"><b style="color:black;font-size:16px">!</b></button>' : '') +
  195.                                                 '</div>';
  196.                                             return o;
  197.                                             }
  198.                               }
  199.                     };
  201. function getPrice(price, decimal)
  202. {
  203.     var price =  parseFloat(price);
  204.     return price.toFixed(decimal);
  205. }
  207. function getCurrencySymbol(cur)
  208. {
  209.     switch(cur){
  210.         case 'EUR': return '€';
  211.         case 'USD': return '$';
  212.         default: return '';
  213.     }
  214. }
  216. function toggleElement(elId){
  217.   var x = document.getElementById(elId);
  218.   
  219.   if (x.style.display === "none") {
  220.     x.style.display = "block";
  221.   } else {
  222.     x.style.display = "none";
  223.   }
  224. }
  226. function initMaterializeSelect(el) {
  227.     M.FormSelect.init(el, {});
  228. }
  230. document.addEventListener('DOMContentLoaded', function() {
  231.     //Initialize Collapsible
  232.     var elems = document.querySelectorAll('.collapsible');
  233.     
  234.     for(var i = 0; i < elems.length; i++)
  235.     {
  236.       key = typeof(elems[i].getAttribute('id')) !== "undefined" ? elems[i].getAttribute('id') : i;
  237.       filterInstances.collapsible[key] = M.Collapsible.init(elems[i]);
  238.     }
  239.   
  240.     // Initialize DatePicker
  241.     var elems = document.querySelectorAll('.datepicker');
  242.     
  243.     for(var i = 0; i < elems.length; i++)
  244.     {
  245.         key = elems[i].getAttribute('name');
  246.         filterInstances.dates[key] = M.Datepicker.init(elems[i], {autoClose: true, format: "yyyy-mm-dd", showClearBtn: true});
  247.     }
  249.     // Initialize Chips
  250.     var elems = document.querySelectorAll('.chips');
  251.     
  252.     for(var i = 0; i < elems.length; i++)
  253.     {
  254.         key = elems[i].getAttribute('id');
  255.         filterInstances.chips[key] = M.Chips.init(elems[i]);
  256.     }
  257.     
  258.     var elems = document.querySelectorAll('select');
  259.     for(var i = 0; i < elems.length; i++)
  260.     {
  261.         key = elems[i].getAttribute('name');
  262.         filterInstances.selects[key] = M.FormSelect.init(elems[i]);
  263.     }
  265.     // Initialize Modals
  266.     var elems = document.querySelectorAll('.modal');
  267.     
  268.     for(var i = 0; i < elems.length; i++)
  269.     {
  270.         key = elems[i].getAttribute('id');
  271.         filterInstances.modals[key] = M.Modal.init(elems[i], {'startingTop': '0%', 'endingTop': '0%', 'endingBottom': '10%'});
  272.     }
  273.     
  274.     //Get Invoices
  275.     Manebi.getIncassi = function(){
  276.                             window.toggleElement('loader');
  278.                             var filter_type = document.querySelector('select[name="filter-tipo"]').value;
  279.                             var filter_order_type = document.querySelector('select[name="filter-order-type"]').value;
  280.                             var filter_source = document.querySelector('select[name="filter-source"]').value;
  281.                                                         
  282.                             $.ajax({
  283.                                 url: urlAjax,
  284.                                 dataType: "json",
  285.                                 data: {
  286.                                     'filter': 1,
  287.                                     'filter-type': filter_type,
  288.                                     'filter-date-from': filterInstances.dates['filter-date-from'].toString(),
  289.                                     'filter-date-to': filterInstances.dates['filter-date-to'].toString(),
  290.                                     'filter-tipo': filterInstances.selects['filter-tipo'].el.value,
  291.                                     'filter-order-type': filterInstances.selects['filter-order-type'].el.value,
  292.                                     'filter-orders-ids': filterInstances.chips['filter-orders-ids'].chipsData,
  293.                                     'filter-credit-notes-from': document.querySelector('#filter-credit-notes-from').value,
  294.                                     'filter-credit-notes-to': document.querySelector('#filter-credit-notes-to').value,
  295.                                     'filter-source': filterInstances.selects['filter-source'].el.value,
  296.                                 }
  297.                             }).then(function(data){
  298.                                 var actions = '';
  299.                                 
  300.                                 if(filter_type == 'charge')
  301.                                     tableInvoices = new TmbDataTable('incassi-table', incassiTableColumns, {'pageSize': 50, 'selectable': true});
  302.                                 else
  303.                                     tableInvoices = new TmbDataTable('incassi-table', rimborsiTableColumns, {'pageSize': 50, 'selectable': true});
  304.                                 
  305.                                 tableInvoices.setData(data.data).generateTable();
  306.                                 
  307.                                 if( (filter_type == 'refund') && (filter_order_type == 'note-credito' || filter_order_type == 'corrispettivi') )
  308.                                 {
  309.                                     actions += '<button type="button" class="btn btn-small waves-effect waves-light" style="float:right;background-color:#36a700" onclick=\'Manebi.exportFile(\"' + filter_type + '\", \"exportCSVDetails\")\'><i class="material-icons">file_download</i> <span>CSV - DETTAGLI (TODO)</span></button>';
  310.                                 }
  312.                                 actions += '<button type="button" class="btn btn-small waves-effect waves-light" style="float:right;background-color:#36a700" onclick=\'Manebi.exportFile(\"' + filter_type + '\", \"exportCSV\")\'><i class="material-icons">file_download</i> <span>CSV</span></button>';
  313.                                 
  314.                                 
  315.                                 if( (filter_type == 'charge')  || ( (filter_type == 'refund') && (filter_order_type == 'note-credito' || filter_order_type == 'corrispettivi') ) )
  316.                                 {
  317.                                     actions += '<button type="button" class="btn btn-small waves-effect waves-light" style="float:right;background-color:#36a700" onclick=\'Manebi.exportFile(\"' + filter_type + '\", \"exportProfis\")\'><i class="material-icons">import_export</i>XML PROFIS</button>';
  318.                                     
  319.                                     if((filter_type == 'refund') && (filter_order_type == 'note-credito'))
  320.                                         actions += '<button type="button" class="btn btn-small waves-effect waves-light" style="float:right;background-color:#36a700" onclick=\'Manebi.exportFile(\"' + filter_type + '\", \"exportFatturaElettronica\")\'><i class="material-icons">import_export</i>Fattura Elettronica (Nota Credito)</button>';
  321.                                 }
  322.                                 
  323.                                 if(filter_type == 'refund' && filter_order_type == "fatture")
  324.                                 {
  325.                                     actions += '<button type="button" class="btn btn-small waves-effect waves-light" style="margin-let:20px;float:right;background-color:#bb001a" onclick="Manebi.checkNumerazioneNotaCredito()">Assegna numerazione per Note di Credito</button>';
  326.                                 }
  327.                                 
  328.                                 tableInvoices.setAction(actions);
  329.                                 
  330.                                 window.toggleElement('loader');
  331.                             });
  332.                         }
  334.     Manebi.numerazioneNoteCredito = [];
  335.     
  336.     /// Controlla la numerazione delle Note Credito
  337.     Manebi.checkNumerazioneNotaCredito = function() {
  338.         window.toggleElement('loader');
  339.         
  340.         $.ajax({
  341.                 url: urlAjax + '/assignNumNotaCredito', 
  342.                 dataType: "json",
  343.                 data: {
  344.                     'preview': true,
  345.                     'filter-date-from': filterInstances.dates['filter-date-from'].toString(),
  346.                     'filter-date-to': filterInstances.dates['filter-date-to'].toString(),
  347.                 }
  348.                }).then(function(data){
  349.                       if(data.status == 'ERROR'){
  350.                               alert(data.message);
  351.                       }
  352.                       
  353.                       Manebi.numerazioneNoteCredito = data.rimborsi;
  354.                       Manebi.popupPreviewNotaCredito(data);
  355.                       
  356.                    window.toggleElement('loader');
  357.                });
  358.     }
  359.     
  360.     /// Conferma e assegna i Numeri di Nota Credito
  361.     Manebi.confirmNumerazioneNotaCredito = function()
  362.     {
  363.         if(Manebi.numerazioneNoteCredito.length > 0)
  364.         {
  365.             $.ajax({
  366.                 type: 'POST',
  367.                 url: urlAjax + '/assignNumNotaCredito?confirm=1&preview=false', 
  368.                 dataType: "json",
  369.                 contentType: "application/json; charset=utf-8",
  370.                 data: JSON.stringify(Manebi.numerazioneNoteCredito)
  371.                }).then(function(data){
  372.                       if(data.status == 'ERROR'){
  373.                               alert(data.message);
  374.                       }
  375.                       
  376.                       filterInstances.modals['NotaCreditoPreviewModal'].el.querySelector('.modal-content').innerHTML = '<p style="color:#339e00;font-weight:bold">'+ data.message + '<p>';
  377.                });
  378.         }
  379.     }
  380.     
  381.     // Elimina incasso
  382.     Manebi.eliminaIncasso = function(id)
  383.     {
  384.         popup = filterInstances.modals['genericPopup'];
  385.         popup.el.querySelector('.modal-content').innerHTML = 'Sei sicuro di voler rimuovere l\'incasso/il rimborso selezionato? <div style="text:align_center"><button class="btn red" onclick="Manebi.eliminaIncassoConfirm('+id+')">CONFERMA RIMOZIONE INCASSO/RIMBORSO</button></div>';
  386.         popup.open();
  387.     }
  388.     
  389.     Manebi.eliminaIncassoConfirm = function(id)
  390.     {
  391.         $.ajax({
  392.             url: urlAjax + '/delete/' + id,
  393.             type: "POST",
  394.             dataType: "json",
  395.         }).then(function(data){
  396.             if(data.status == 'OK'){;
  397.                    popup = filterInstances.modals['genericPopup'];
  398.                    popup.el.querySelector('.modal-content').innerHTML = '<b>Incasso/Rimborso eliminato!</b>';
  399.                    
  400.                    var elem = document.querySelector('#iso-'+id);
  401.                 elem.parentNode.removeChild(elem);
  402.                }else{
  403.                    popup = filterInstances.modals['genericPopup'];
  404.                    popup.el.querySelector('.modal-content').innerHTML = '<b>Attenzione! Non è stato possibile rimuovere l\'incasso/rimborso selezionato</b>';
  405.                }
  406.         });
  407.     }
  408.     
  409.     Manebi.popupPreviewNotaCredito = function(data)
  410.     {
  411.         var rimborsi = data.rimborsi;
  412.         var message = typeof(data.message) !== "undefined" ? data.message : "";
  413.         
  414.         filterInstances.modals['NotaCreditoPreviewModal'].el.querySelector('.modal-header').innerHTML = '<h4>Anteprima Note Credito</h4>';
  415.         
  416.         var o = '<p><b>Ultima Nota di Credito assegnata</b></p><table id="note-credito-last" class="table"><tbody>\
  417.         <thead><tr><th>Ordine</th><th>Sorgente</th><th>Data Rimborso</th><th>Numero NC</th></tr></thead>';
  418.         for(i=0; i < 1; i++)
  419.         {  
  420.             o += '<tr class="'+(rimborsi[i].Order == null ? 'error' : '')+'"><td><b>' + rimborsi[i].Order +'</b></td><td>' + rimborsi[i].Source + '</td><td>' + rimborsi[i].Date +'</td><td class="num-notacredito"><b>' + rimborsi[i].NotaCredito +'</b></td></tr>';
  421.         }
  422.         o += '<tr></tr></tbody></table>';
  423.         
  424.         if(rimborsi.length > 1)
  425.         {
  426.             o += '<p>'+ message +'</p><table id="note-credito-preview" class="table"><tbody>\
  427.             <thead><tr><th>Ordine</th><th>Sorgente</th><th>Data Rimborso</th><th>Numero NC da assegnare</th></tr></thead>';
  428.             for(i=1; i<rimborsi.length; i++)
  429.             {  
  430.                 o += '<tr class="'+(rimborsi[i].Order == null ? 'error' : '')+'"><td><b>' + rimborsi[i].Order +'</b></td><td>' + rimborsi[i].Source + '</td><td>' + rimborsi[i].Date +'</td><td class="num-notacredito"><b>' + rimborsi[i].NotaCredito +'</b></td></tr>';
  431.             }
  432.             o += '<tr></tr></tbody></table>';    
  433.         }else{
  434.             o += '<p><b>Non ci sono Note di Credito da assegnare</b></p>'
  435.         }
  436.         
  438.         if((data.status == "OK"))
  439.         {
  440.             if(rimborsi.length > 1)
  441.             {
  442.                 o = '<div style="text-align:center"><input type="button" class="btn waves-effect waves-light" onclick="Manebi.confirmNumerazioneNotaCredito()" value="CONFERMA E ASSEGNA NUMERAZIONE" /></div>' + o;                
  443.             }
  444.         }
  445.         
  446.         filterInstances.modals['NotaCreditoPreviewModal'].el.querySelector('.modal-content').innerHTML = o;
  447.         filterInstances.modals['NotaCreditoPreviewModal'].open();
  448.     }
  450.     // Get Invoice
  451.     Manebi.getIncasso = function(id) {
  452.         window.toggleElement('loader');
  453.         
  454.         $.ajax({
  455.                 url: urlAjax + '/' + id, 
  456.                 dataType: "json"
  457.                }).then(function(data){
  458.                        if(data.status == 'OK' && (data.data.length > 0)){
  459.                            var invoice = data.data[0];
  461.                            Manebi.viewInvoice(invoice);
  462.                        }
  463.                     
  464.                    window.toggleElement('loader');
  465.                });
  466.     }
  467.     
  468.     // Export Invoices in Profis XML
  469.     Manebi.exportFile = function(filter_type, export_type) {
  470.             var form = document.createElement("form");
  471.             
  472.             form.setAttribute("id", export_type);
  473.             form.method = "POST";
  474.             form.action = urlAjax;
  475.             form.target = '_blank';    
  476.             
  477.             document.body.appendChild(form);
  479.             f = document.createElement("input");f.type='hidden';
  480.             f.setAttribute('name', 'filter-tipo');f.setAttribute('value', filterInstances.selects['filter-tipo'].el.value);
  481.             form.appendChild(f);
  483.             f = document.createElement("input");f.type='hidden';
  484.             f.setAttribute('name', 'filter-source');f.setAttribute('value', filterInstances.selects['filter-source'].el.value);
  485.             form.appendChild(f);
  486.             
  487.             f = document.createElement("input");f.type='hidden';
  488.             f.setAttribute('name', 'filter-order-type');f.setAttribute('value', filterInstances.selects['filter-order-type'].el.value);
  489.             form.appendChild(f);
  490.             
  491.             f = document.createElement("input");f.type='hidden';
  492.             f.setAttribute('name', export_type);f.setAttribute('value', 1);
  493.             form.appendChild(f);
  494.             
  495.             f = document.createElement("input");f.type='hidden';
  496.             f.setAttribute('name', 'filter');f.setAttribute('value', 1);
  497.             form.appendChild(f);
  498.             
  499.             f = document.createElement("input");f.type='hidden';
  500.             f.setAttribute('name', 'filter-date-from');f.setAttribute('value', filterInstances.dates['filter-date-from'].toString());
  501.             form.appendChild(f);
  502.             
  503.             f = document.createElement("input");f.type='hidden';
  504.             f.setAttribute('name', 'filter-date-to');f.setAttribute('value', filterInstances.dates['filter-date-to'].toString());
  505.             form.appendChild(f);
  506.             
  507.             var chips = filterInstances.chips['filter-orders-ids'].chipsData;
  508.             
  509.             for(var i=0; i < chips.length; i++){
  510.                 f = document.createElement("input");f.type='hidden';
  511.                 f.setAttribute('name', 'filter-orders-ids['+i+'][tag]');f.setAttribute('value', chips[i].tag);
  512.                 form.appendChild(f);
  513.             }
  515.             f = document.createElement("input");f.type='hidden';
  516.             f.setAttribute('name', 'filter-credit-notes-from');f.setAttribute('value', document.querySelector('#filter-credit-notes-from').value);
  517.             form.appendChild(f);
  519.             f = document.createElement("input");f.type='hidden';
  520.             f.setAttribute('name', 'filter-credit-notes-to');f.setAttribute('value', document.querySelector('#filter-credit-notes-to').value);
  521.             form.appendChild(f);
  522.             
  523.             form.submit();
  524.     }                
  525.   });
  527.   
  528.   /**
  529.    * Refund Details
  530.    */
  531.   function refundDetails(id, order, credit_note) {
  532.       console.log(order);
  533.       $.ajax({
  534.                 url: '/admin/note-credito/' + credit_note,
  535.                 data: {
  536.                     'Order': order
  537.                 }, 
  538.                 dataType: "json"
  539.                }).then(function(data){
  540.                        $('tr.credit-note-detail').remove();
  542.                        if(data.status == 'OK'){
  543.                         var prodotti_ordine = data.data.prodotti_ordine;
  544.                         var prodotti_notacredito = data.data.prodotti_notacredito;
  545.                         var shipping_notacredito = data.data.shipping_notacredito;
  547.                         var o = '<tr class="credit-note-detail">';
  548.                         o += '<td colspan="11"> \
  549.                                     <div style="text-align:center"><h5>Informazioni Nota Credito '+credit_note+'<h5></div>\
  550.                                     <table id="creditnote-detail-'+id+'"  class="table table-striped credit-note-detail-table" style="background-color:#EEE">\
  551.                                         <thead><tr><th>Nome riga</th><th>SKU</th><th>Quantità</th><th>Prezzo</th><th>Quantità da rimborsare</th><th>Prezzo da rimborsare</th></tr></thead>\
  552.                                         <tbody>';
  554.                         for(var i=0; i < prodotti_ordine.length; i++) {
  555.                             var refundedQty = 0;
  556.                             var refundedPrice = 0.00;
  558.                             for (var j=0; j< prodotti_notacredito.length; j++) {
  559.                                 if(prodotti_notacredito[j].SKU == prodotti_ordine[i].SKU) {
  560.                                     refundedQty = prodotti_notacredito[j].QuantityRefund;
  561.                                     refundedPrice = Math.round(prodotti_notacredito[j].PriceRefund,2);
  562.                                 }
  563.                             }
  565.                             o += '<tr class="credit-note-product">\
  566.                                         <td><span class="creditnote-detail-name">'+prodotti_ordine[i].Name+'</span></td>\
  567.                                         <td><span class="creditnote-detail-sku">'+prodotti_ordine[i].SKU+'</span></td>\
  568.                                         <td><span class="creditnote-detail-quantity" data-value="'+prodotti_ordine[i].Quantity+'">' + prodotti_ordine[i].Quantity +'</span></td>\
  569.                                         <td><span class="creditnote-detail-price" data-value="'+prodotti_ordine[i].Price+'">' + getPrice(prodotti_ordine[i].Price, 2) + ' ' + getCurrencySymbol(data.data.Currency) +'</span></td>\
  570.                                         <td><input class="creditnote-detail-refund-quantity" type="number" value="'+refundedQty+'" min="0" max="'+prodotti_ordine[i].Quantity+'" onchange="calcRefundPrice(this)"></td>\
  571.                                         <td><input class="creditnote-detail-refund-price" type="text" value="'+refundedPrice+'" onchange="calcTotal()">'+ getCurrencySymbol(data.data.Currency) +'</td>\
  572.                                     </tr>';
  573.                         }
  575.                         for(var i=0; i < prodotti_notacredito.length; i++) {
  576.                             if (prodotti_notacredito[i].SKU == '') {
  577.                                 o += '<tr class="creditnote-detail-new-row">\
  578.                                     <td><input class="creditnote-detail-name" "type="text" value="'+prodotti_notacredito[i].Name+'" placeholder="Nuova riga" style="width:100%"></td>\
  579.                                     <td></td><td></td><td></td>\
  580.                                     <td><input class="creditnote-detail-new-row-quantity" type="number" value="'+prodotti_notacredito[i].QuantityRefund+'" min="0"></td>\
  581.                                     <td><input class="creditnote-detail-new-row-price" type="text" value="'+getPrice(prodotti_notacredito[i].PriceRefund,2)+'" onchange="calcTotal()"> ' + getCurrencySymbol(data.data.Currency) +'</td></tr>';
  582.                             }
  583.                         }
  585.                         o += '<tr class="creditnote-detail-new-row" style="display:none">\
  586.                                 <td><input class="creditnote-detail-name" "type="text" value="" placeholder="Nuova riga" style="width:100%"></td>\
  587.                                 <td></td><td></td><td></td>\
  588.                                 <td><input class="creditnote-detail-new-row-quantity" type="number" value="0" min="0"></td>\
  589.                                 <td><input class="creditnote-detail-new-row-price" type="text" value="0.00" onchange="calcTotal()"> ' + getCurrencySymbol(data.data.Currency) +'</td></tr>';
  591.                         o += '<tr class="new-row"><td colspan="7"><button type="button" class="btn btn-medium waves-effect waves-light blue" onclick="newEmptyRow(this)">+ Nuova Riga</td></tr>';
  593.                         if(data.data.Shipping > 0) {
  594.                             var shippingPriceRefund = 0.00;
  595.                             var shippingQtyRefund = 0;
  597.                             if(typeof(shipping_notacredito['ShippingPriceRefund'])!== "undefined") {
  598.                                 shippingQtyRefund = 1;
  599.                                 shippingPriceRefund = parseFloat(getPrice(shipping_notacredito['ShippingPriceRefund'], 2));
  600.                             }
  602.                             o += '<tr class="credit-note-shipping">\
  603.                                 <td><b>RIMBORSO SPESE SPEDIZIONE:</b></td>\
  604.                                 <td></td>\
  605.                                 <td></td>\
  606.                                 <td><span class="creditnote-detail-shipping" data-value="'+data.data.Shipping+'">'+getPrice(data.data.Shipping,2)+'</span></td>\
  607.                                 <td><input class="creditnote-detail-refund-shipping-quantity" type="number" value="'+shippingQtyRefund+'" min="0" max="1" onclick="calcRefundShipping(this)" /></td>\
  608.                                 <td><input class="creditnote-detail-refund-shipping" type="text" value="'+shippingPriceRefund+'" onchange="calcTotal()" />' + getCurrencySymbol(data.data.Currency) +'</td>\
  609.                             </tr>';
  610.                         }
  611.                         
  612.                         o += '<tr><td colspan="7"><hr/></td></tr>';
  613.                         o += '<tr class="credit-note-total">\
  614.                                 <td colspan="4"></td>\
  615.                                 <td><b>Totale:</b> </td>\
  616.                                 <td><span value=""><input class="creditnote-detail-refund-total" type="text" value="0.00" onchange="calcTotal()" disabled></span> / <span class="credit-note-refund-amount" data-value="'+data.data.RefundAmount+'">'+getPrice(data.data.RefundAmount,2)+' '+ getCurrencySymbol(data.data.Currency) +'</span><td>\
  617.                             </tr>';
  619.                         o += '<tr><td colspan="7"><hr/></td></tr>';
  620.                         
  621.                         o += '<tr><td colspan="7" style="text-align:center">\
  622.                         <button id="credit-note-details-button-save" type="button" class="btn btn-medium waves-effect waves-light" onclick="saveNotaCreditoDetails('+id+')">Salva Dettagli Nota Credito</button>\
  623.                         <button id="credit-note-details-button-cancel" type="button" class="btn btn-medium waves-effect waves-light red">Annulla</button>\
  624.                         </td></tr>';
  626.                         o += '</tbody>\
  627.                             </table>\
  628.                             </td>';
  630.                         o += '</tr>';
  632.                         $('#notacredito-actions-'+id).parent().parent().after(o);
  633.                         calcTotal();
  634.                        }
  635.                });
  636.   }
  638.     function calcRefundPrice(el)
  639.     {
  640.         var row = $(el).parent().parent();
  641.         var qty = el.value;
  642.         var price = parseFloat(row.find('span.creditnote-detail-price').data('value'));
  644.         row.find('input.creditnote-detail-refund-price').val(price * qty).change();
  645.     }
  647.     function calcRefundShipping(el)
  648.     {
  649.         var row = $(el).parent().parent();
  650.         var qty = el.value;
  651.         var price = parseFloat(row.find('span.creditnote-detail-shipping').data('value'));
  653.         row.find('input.creditnote-detail-refund-shipping').val(price * qty).change();
  654.     }
  655.   
  656.     function calcTotal()
  657.     {
  658.         var sum = 0;
  660.         $('.creditnote-detail-refund-price').each(function(i,v){
  661.             //qty = parseInt($(this).parent().parent().find('input.creditnote-detail-refund-quantity').val());
  662.             sum += parseFloat(v.value);
  663.         });
  665.         $('.creditnote-detail-new-row-price').each(function(i,v){
  666.                 sum += parseFloat(v.value);
  667.         });
  669.         $('.creditnote-detail-refund-shipping').each(function(i,v){sum += parseFloat(v.value);});
  670.         $('.creditnote-detail-refund-total').val(Math.round(sum * 100,2)/100).data('value', sum);
  671.     };
  673.     function newEmptyRow(el) {
  674.         var new_row = $('tr.creditnote-detail-new-row').eq(0).clone();
  675.         console.log(new_row);
  676.         $(el).parent().parent().before(new_row.show());
  677.     }
  679.     function saveNotaCreditoDetails(id) {
  680.         var post_data = {'id': id, 'products': [], 'shipping': [], 'total': 0.00};
  681.         var upload = true;
  683.         $('tr.credit-note-product').each(function(i,v){
  684.             var _product_data = {};
  685.             var $el = $(v);
  687.             _product_data['Name'] = $el.find('span.creditnote-detail-name').html();
  688.             _product_data['SKU'] = $el.find('span.creditnote-detail-sku').html();
  689.             _product_data['RefundQuantity'] = parseFloat($el.find('input.creditnote-detail-refund-quantity').val());
  690.             _product_data['RefundPrice'] = parseFloat($el.find('input.creditnote-detail-refund-price').val());
  692.             post_data['products'].push(_product_data);
  693.         });
  695.         $('tr.creditnote-detail-new-row').each(function(i,v){
  696.             var _product_data = {};
  697.             var $el = $(v);
  699.             _product_data['Name'] = $el.find('input.creditnote-detail-name').val();
  700.             _product_data['SKU'] = '';
  702.             if(_product_data['Name'] == '')
  703.                 return true;
  705.             _product_data['RefundQuantity'] = parseFloat($el.find('input.creditnote-detail-new-row-quantity').val());
  707.             if(_product_data['RefundQuantity'] == 0) {
  708.                 alert('Attenzione! specifica la quantità della Nuova Riga: '+_product_data['Name']);
  709.                 upload = false;
  710.                 return false;
  711.             }
  712.             
  713.             _product_data['RefundPrice'] = parseFloat($el.find('input.creditnote-detail-new-row-price').val());
  715.             if(_product_data['RefundPrice'] == 0) {
  716.                 alert('Attenzione! specifica il prezzo della Nuova Riga: '+_product_data['Name']);
  717.                 upload = false;
  718.                 return false;
  719.             }
  721.             post_data['products'].push(_product_data);
  722.         });
  724.         if(!upload)
  725.             return;
  727.         $('tr.credit-note-shipping').each(function(i,v){
  728.             var _product_data = {};
  729.             var $el = $(v);
  731.             _product_data['RefundQuantity'] = parseFloat($el.find('input.creditnote-detail-refund-shipping-quantity').val());
  732.             _product_data['RefundPrice'] = parseFloat($el.find('input.creditnote-detail-refund-shipping').val());
  734.             post_data['shipping'].push(_product_data);
  735.         });
  737.         post_data['total'] = parseFloat($('tr.credit-note-total').find('input.creditnote-detail-refund-total').val());
  738.         var refundAmount = getPrice($('tr.credit-note-total').find('span.credit-note-refund-amount').data('value'),2);
  739.         
  740.         if( post_data['total'] != parseFloat(refundAmount) ) {
  741.             $('tr.credit-note-total').find('input.creditnote-detail-refund-total').addClass('error');
  742.             alert('Attenzione, il valore finale della nota credito non coincide con il totale rimborsato');
  743.             return;
  744.         }else{
  745.             $('tr.credit-note-total').find('input.creditnote-detail-refund-total').removeClass('error');
  746.         }
  748.          $.ajax({
  749.             url: '/admin/note-credito/', 
  750.             type: "POST",
  751.             dataType: "json",
  752.             data: post_data
  753.         }).then(function(data) {
  754.             alert(data.message);
  755.         });
  756.     }
  758. </script>
  759. {% endblock %}
  760. <style>
  762. td, th {
  763.     padding: 2px 5px;
  764.     font-size: 0.9rem;
  765. }
  767. th.sortable {
  768.     text-decoration: underline;
  769. }
  771. th.sortable.asc::after {
  772.     content: '\2b61';
  773. }
  774. th.sortable.desc::after {
  775.     content: '\2b63';
  776. }
  778. table.striped > thead > tr{
  779.     background-color: #e4e4e4;
  780.     border-bottom: 1px solid #CCC !important;
  781. }
  783. tbody > tr > td:first-child{
  784.     background-color: #e4e4e4;
  785. }
  787. tr.selectable:hover > td{
  788.     cursor: pointer;
  789.     background-color: #BBB;
  790. }
  792. .modal {
  793.    max-height: 100%;
  794. }
  796. .modal.modal-fixed-footer {
  797.    height: 90%;
  798. }
  800. .incassi-table-pagination {
  801.     text-align: center;
  802.     display: flex;
  803.     flex-wrap: wrap;
  804.     justify-content: center;
  805. }
  807. .incassi-table-pagination .page {
  808.     display: inline;
  809.     padding: 3px;
  810. }
  812. .incassi-table-pagination .page a {
  813.     color: #000;
  814. }
  816. .incassi-table-pagination .page.active a {
  817.     font-weight: bold;
  818.     padding: 5px;
  819.     text-decoration: underline;
  820. }
  821. div.select-wrapper{
  822.     display:inline-block;
  823. }
  825. #incassiSenzaOrdine thead td
  826. {
  827.     font-weight: bold;
  828.     color: #000;
  829. }
  831. #incassiSenzaOrdine td
  832. {
  833.     color: #000;
  834. }
  836. #NotaCreditoPreviewModal tbody tr.error td {
  837.     font-weight: bold;
  838.     color: #f00;
  839.     border: 2px solid #F00;
  840. }
  842. button.btn.btn-small.waves-effect.waves-light {
  843.     margin: 0px 15px 0px 15px;
  844. }
  846. i.arrot {
  847.     color: brown;
  848.     font-size: 10px;
  849.     text-align: right;
  850. }
  852. tr.credit-note-detail {
  853.     background-color: #FFF !important;
  854. }
  856. table.credit-note-detail-table th{
  857.     border-bottom: 1px solid #DDD !important;
  858.     text-align:center;
  859. }
  861. table.credit-note-detail-table td {
  862.     text-align:center;
  863. }
  865. table.credit-note-detail-table input{
  866.     background-color: #FFF !important;
  867.     border: 1px solid #DDD !important;
  868. }
  870. table.credit-note-detail-table input[type="number"],
  871. table.credit-note-detail-table input[type="text"]{
  872.     width: 30%;
  873.     text-align: center;
  874. }
  876. tbody > tr.credit-note-detail > td{
  877.     background-color: #EEE !important;
  878. }
  880. input.creditnote-detail-refund-total.error {
  881.     border: 1px solid #F00 !important;
  882. }
  884. </style>
  885. {% endblock %}