templates/invoices.import.html.twig line 1

Open in your IDE?
  1. {% extends 'base.html.twig' %}
  3. {% block body %}
  4. <div class="container">
  5.   <div class="row">
  6.     <div class="col s12">
  7.       <div class="card">
  8.         <div class="card-content">
  9.               <span class="card-title">Importa CSV Shopify</span>
  10.               <form action="{{ path('invoices_shopify_import') }}" method="POST" enctype="multipart/form-data">
  11.               <p>Da questa sezione hai la possibilità di importare un file CSV di Shopify, ed ottenere un file da importare in Dashboard.</p>
  12.                <div class="file-field input-field">
  13.                  <div class="btn">
  14.                     <span>Seleziona un file</span>
  15.                    <input type="file" name="file-shopify-csv">
  16.                  </div>
  17.                  <div class="file-path-wrapper">
  18.                       <input class="file-path validate" type="text">
  19.                  </div>
  20.              </div>
  21.              <button class="btn waves-effect waves-light" type="submit" name="action">Carica CSV</button>
  22.              </form>
  23.           </div>
  25.           <div class="card-content">
  26.               <span class="card-title">Importa Ordini da file CSV</span>
  27.               <form action="{{ path('invoices_import') }}" method="POST" enctype="multipart/form-data">
  28.               <p>Da questa sezione hai la possibilità di importare un file CSV delle fatture/corrispettivi, verificare quali sono gli ordini nuovi o esistenti, e confermare l'importazione.</p>
  29.                <div class="file-field input-field">
  30.                  <div class="btn">
  31.                     <span>Seleziona un file</span>
  32.                    <input type="file" name="file-csv">
  33.                  </div>
  34.                  <div class="file-path-wrapper">
  35.                       <input class="file-path validate" type="text">
  36.                  </div>
  37.              </div>
  38.              <button class="btn waves-effect waves-light" type="submit" name="action">Carica CSV</button>
  39.              </form>
  40.           </div>
  42.          </div>
  43.       </div>
  44.   </div>
  45.   
  46.   {% if checkNumerazioneFatture|length > 0 %}
  47.     <div id="checkNumerazioneFatture" class="card">
  48.         <div class="card-content" style="color:#F00">
  49.               <p class="alert alert-danger">ATTENZIONE! Il check sulla numerazione delle fatture per l'anno in corso ha restituito un errore:</p>
  50.               <hr/>
  51.               <p><b>Ultima fattura corretta: </b> {{ checkNumerazioneFatture['ultima_fattura_ok'] }} (Ordine {{ checkNumerazioneFatture['ultimo_ordine_ok'] }} del {{ checkNumerazioneFatture['ultima_fattura_ok_data']|date('Y-m-d') }})</p>
  52.               <p><b>Fattura errata: </b> {{ checkNumerazioneFatture['error_fattura'] }} (Ordine {{ checkNumerazioneFatture['error_order'] }} del {{ checkNumerazioneFatture['error_fattura_data']|date('Y-m-d') }})</p>
  53.           </div>
  54.       </div>
  55.   {% endif %}
  57.   {% if stats is not empty %}
  58.   <div class="row">
  59.     <div class="col s12">
  60.       <div class="card">
  61.           <div class="card-content">
  62.               <span class="card-title">Anteprima Importazione CSV</span>
  63.             <table class="striped">
  64.     <thead>
  65.         <tr><th></th><th>Total</th><th>IDs</th></tr>
  66.     </thead>
  67.     <tbody>
  68.         <tr>
  69.             <td><b style="color:#DD0">Nuovi</b></td>
  70.             <td><b>{{ stats.new }}</b></td>
  71. <td>
  72. {% for s in stats.new_ids %}
  73.         <i>{{ s }}</i> 
  74. {% endfor %}
  75. </td>
  76.         </tr>
  77.         
  78.         <tr>
  79.             <td><b style="color:#880">Esistenti</b></td>
  80.             <td><b>{{ stats.exist }}</b></td>
  81.             <td>
  82.             {% for s in stats.exist_ids %}
  83.                     <i>{{ s }}</i> 
  84.             {% endfor %}
  85.             </td>
  86.         </tr>    
  87.     </tbody>
  88. </table>
  89. <hr/>
  90.             {% if check_vat_errors|length > 0 %}
  91.                 <h4> Verifica Aliquote IVA</h4>
  92.                 {% for check in check_vat_errors %}
  93.                     <div class="card-content" style="border: 1px solid">
  94.                             <table>
  95.                                 <thead>
  96.                                     <tr>
  97.                                         <th>Ordine</th>
  98.                                         <th>Tax Rate Shopify</th>
  99.                                         <th>Tax Rate Paese (Dashboard) </th>
  100.                                         <th>Tax Rate Provincia (Dashboard) </th>
  101.                                         <th>Order Vat Rate (File) </th>
  102.                                         <th>Stato</th>
  103.                                     </tr>
  104.                                 </thead>
  105.                                 <tbody>
  106.                                     <tr class="{% if check['IsError'] != "OK" %}error{% endif %}">
  107.                                         <td>{{ check['Order'] }}</td>
  108.                                         <td>{{ check['Country'] }} {{ check['Shopify Country Rate'] }}%</td>
  109.                                         <td>{{ check['Shipping Country'] }} {{ check['Manebi Country Rate'] }}%</td>
  110.                                         <td>{{ check['Shipping Country'] }} {{ check['Province Tax Rate'] }}%</td>
  111.                                         <td>{{ check['OrderVatRate'] }}%</td>
  112.                                         <td><span class="">
  113.                                             {% if check['IsError'] == 'ERROR-ORDERVATRATE-DIFF-PROVINCETAXRATE' %}Order Vat Rate specificato ({{ check['OrderVatRate'] }}%) è diverso da quello della Provincia ({{ check['Province Tax Rate'] }}%){% endif %}
  114.                                             {% if check['IsError'] == 'ERROR-ORDERVATRATE-NULL' %}Order Vat Rate non è specificato{% endif %}
  115.                                             {% if check['IsError'] == 'ERROR-PROVINCETAXRATE-NULL' %}Vat Rate della Provincia non specificata in Dashboard{% endif %}
  116.                                             {% if check['IsError'] == 'OK' %}OK{% endif %}
  117.                                         </td>
  118.                                     </tr>
  119.                                 </tbody>
  120.                             </table>
  121.                     </div>
  122.                 {% endfor %}
  123.             {% endif %}
  125.             {% if has_vat_errors %}
  126.                 <p class="alert alert-danger"> <b>ATTENZIONE! Alcuni ordini presentano un Tax Rate su Shopify diverso da quello presente sulla piattaforma</b> </p>
  127.                 <hr />
  128.                 <p>Il paese potrebbe aver cambiato la propria aliquota IVA, si prega di controllare e segnalare a Tembo il nuovo valore del tax rate per il Paese o la Provincia.
  129.             </div>
  130.             {% else %}
  131.             <form action="{{ path('invoices_import') }}?loadInvoices=1" method="POST">
  132.                     <button class="waves-effect waves-light btn-large" style="background-color:#bd352e" type="submit" name="action">Conferma e Carica i dati</button>
  133.             </form>
  134.             {% endif %}
  135.           </div>
  136.         </div>
  137.       </div>
  138.   </div>
  139.   {% endif %}
  140.   
  141.   {% if load_results is not empty %}
  142.   <div class="row">
  143.     <div class="col s12">
  144.       <div class="card">
  145.           <div class="card-content">
  146.               <span class="card-title">Risultati del caricamento</span>
  147.             <table class="striped">
  148.     <thead>
  149.         <tr><th></th><th>Total</th><th>IDs</th></tr>
  150.     </thead>
  151.     <tbody>
  152.         <tr>
  153.             <td><b style="color:#DD0">Inserite</b></td>
  154.             <td><b>{{ load_results.inserted }}</b></td>
  155. <td>
  156. {% for s in load_results.inserted_ids %}
  157.         <i>{{ s }}</i> 
  158. {% endfor %}
  159. </td>
  160.         </tr>
  161.         
  162.         <tr>
  163.             <td><b style="color:#880">Modificate</b></td>
  164.             <td><b>{{ load_results.modified }}</b></td>
  165. <td>
  166. {% for s in load_results.modified_ids %}
  167.         <i>{{ s }}</i> 
  168. {% endfor %}
  169. </td>
  170.         </tr>
  171.         
  172.     </tbody>
  173.   </table>
  174.           </div>
  175.         </div>
  176.       </div>
  177.   </div>
  178.   {% endif %}
  179.   
  180. <div class="row">
  181.     <hr />
  182. </div>
  184. <div class="row">
  185.     <div class="col s12">
  186.       <div class="card">
  187.           <div class="card-content">
  188.               <span class="card-title">Log importazioni Fatture/Corrispettivi</span>
  189.             <p>Da questa sezione puoi annullare l'ultima importazione.</p>
  191.               <table class="table table-striped">
  192.                 <thead>
  193.                     <tr>
  194.                         <th>ID Importazione</th>
  195.                         <th>File</th>
  196.                         <th>Righe caricate</th>
  197.                         <th>Righe importate</th>
  198.                         <th>Data Upload File</th>
  199.                         <th>Data Conferma Importazione</th>
  200.                         <th>Data Eliminazione Importazione</th>
  201.                         <th></th>
  202.                     </tr>
  203.                 </thead>
  204.                 <tbody>
  205.                 {% for i in importazioni %}
  206.                     <tr>
  207.                         <td>{{ i.id }}</td>
  208.                         <td>{{ i.filename }}</td>
  209.                         <td>{{ i.rows_loaded }}</td>
  210.                         <td>{{ i.rows_processed }}</td>
  211.                         <td>{{ i.date_upload }}</td>
  212.                         <td>{{ i.date_import }}</td>
  213.                         <td>{{ i.date_delete }}</td>
  214.                         <td> {% if i.date_delete == NULL %}<button type="button" class="btn btn-red" style="background-color:#F00" onclick="Manebi.getInvoices({{ i. id }})"> X </button>{% endif %} </td>
  215.                     </tr>
  216.                 {% endfor %}
  217.                 </tbody>
  218.             </table>
  219.           </div>
  220.          </div>
  221.       </div>
  222.   </div>
  223. </div>
  225. <div id="genericPopup" class="modal modal-fixed-footer modal-fixed-header">
  226.         <div class="modal-header"></div>
  227.         <div class="modal-content">
  228.             <p class="alert alert-warning">Queste sono le righe associate a questa integrazione. Verificare  dati che saranno rimossi prima di procedere alla rimozione.</p>
  229.             <hr/>
  230.             <div id="invoices-table-results">
  231.                   <div class="row">
  232.                       <div class="col s4">Risultati: <span id="invoices-table-results-total"></span></div>
  233.                       <div id="invoices-table-results-actions" class="col s8"></div>
  234.                   </div>
  235.               </div>
  236.             <table id="invoices-table" class="striped fixed_header">
  237.                   <thead></thead>
  238.                   <tbody></tbody>
  239.               </table>
  240.         </div>
  241.         <div class="modal-footer">
  242.             <a id="button-delete-log-imports" href="#!" class="waves-effect waves-red btn btn-small" style="background-color: #F00" onclick="deleteLogImports(this)" data-id-log-imports="">CONFERMA ELIMINAZIONE DEI DATI DI QUESTA INTEGRAZIONE</a>
  243.             <a href="#!" class="modal-close waves-effect waves-green btn btn-small">CHIUDI</a>
  244.     </div>
  245. </div> 
  246. </div>
  247. {% endblock %}
  249. {% block javascripts %}
  250. <script src="{{ asset('tmb-data-table.v1_0.min.js') }}"></script>
  252. <script>
  253. var Manebi = {};
  254. var urlAjax = "{{ path('invoices_main') }}";
  256. var invoicesTableColumns =  {
  257.                     'Order': {'headerName': 'Ordine', 'value': 'Order', 'sortable': true},
  258.                     'Numero Fattura': {'headerName': 'Numero Fattura', 'value': 'Numero Fattura', 'sortable': true},
  259.                     'Corrispettivo': {'headerName': 'Corrispettivo', 'value': 'Corrispettivo', 'sortable': true},
  260.                     'Pagato il': {'headerName': 'Pagato il', 'value': 'Paid at', 'sortable': true},
  261. }
  263. //Get Invoices
  264. Manebi.getInvoices = function(id_log_imports)
  265. {
  266.     $.ajax({
  267.         url: urlAjax,
  268.         dataType: "json",
  269.         data: {
  270.             'filter': 1,
  271.             'filter-id-log-imports': id_log_imports
  272.         }
  273.     }).then(function(data) {
  274.         var actions = '';
  275.         tableIncassiPos = new TmbDataTable('invoices-table', invoicesTableColumns, {'pageSize': 100, 'selectable': true});
  276.         tableIncassiPos.setData(data.data).generateTable();
  277.         
  278.         popup = M.Modal.init(document.getElementById('genericPopup'), {'startingTop': '0%', 'endingTop': '0%', 'endingBottom': '10%'});
  279.         $("#button-delete-log-imports").attr("data-id-log-imports", id_log_imports);
  280.         popup.open();
  281.         //window.toggleElement('loader');
  282.     });
  283. }
  285. function deleteLogImports(el)
  286. {
  287.     var id_log_imports = $(el).attr('data-id-log-imports');
  289.     $.ajax({
  290.         url: "{{ path('invoices_import') }}/delete",
  291.         type: "POST",
  292.         dataType: "json",
  293.         data: {
  294.             'id_log_imports': id_log_imports,
  295.         }
  296.     }).then(function(data) {
  297.         var actions = '';
  298.         
  299.         alert('Fatture/Corrispettivi eliminati!');
  300.         window.location = window.location.href.replace(/\#.*/, '');
  301.     });
  302. }
  303. </script>
  304. {% endblock javascripts %}