templates/factura/rentabilidad.html.twig line 1

Open in your IDE?
  1. {% extends 'base.html.twig' %}
  3. {% set roleFacturacion=is_granted('ROLE_FACTURACION') %}
  5. {% block title %}
  6.     Rentabilidad
  7. {% endblock %}
  9. {% block facturasItem %}active{% endblock %}
  10. {% block rentabilidad %}active{% endblock %}
  13. {% block headscript %}
  14.     <!-- Custom styles for this page -->
  15.     <link href="/vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
  16.     <link href="/vendor/datatables/dataTables.fixedHeader.min.css" rel="stylesheet">
  17.     <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/bs4/jszip-2.5.0/dt-1.11.2/b-2.0.0/b-colvis-2.0.0/b-html5-2.0.0/b-print-2.0.0/cr-1.5.4/date-1.1.1/fh-3.1.9/r-2.2.9/sb-1.2.1/datatables.min.css"/>
  18. {% endblock %}
  20. {% block body %}
  21.     <div class="container-fluid">
  23.         <!-- Page Heading -->
  24.         <div class="card border-left-primary shadow h-100 py-1 mb-2">
  25.             <div class="card-body">
  26.                 <input type="hidden" id="urlShow" value="{{ path('factura_show', {'id': '_id'}) }}">
  27.                 <input type="hidden" id="urlShowGenerica" value="{{ path('facturaGenerica_show', {'id': '_id'}) }}">
  28.                 <h1 class="h3 mb-2 text-gray-800">Rentabilidad</h1>
  29.                 {#  <p class="mb-4">Lorem ipsum sit amet.</p>#}
  30.             </div>
  31.         </div>
  32.         <!-- Filters -->
  33.         <div class="card">
  34.             <div class="card-header py-3">
  35.                 <h6 class="m-0 font-weight-bold text-primary">
  36.                     Filtrar facturas
  37.                 </h6>
  38.             </div>
  39.             <div class="card-body">
  40.                 {% include 'factura/_filtrarFacturaForm.html.twig' %}
  41.             </div>
  42.         </div>
  43.         {% if formSubmitted %}
  44.         <!-- Total -->
  45.         <div id="totales" class="card">
  46.             <div class="card-body">
  47.                 <div class="row">
  48.                     <div class="col-xl-2 col-md-4">
  49.                         <div class="card border-left-success shadow h-100 py-2">
  50.                             <div class="card-body">
  51.                                 <div class="row no-gutters align-items-center">
  52.                                     <div class="col mr-2">
  53.                                         <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Total facturado</div>
  54.                                         <div id="totalFacturado" class="h5 mb-0 font-weight-bold text-gray-800">{{ facturado|number_format(2, ',', '.') }} €</div>
  55.                                     </div>
  56.                                     <div class="col-auto">
  57.                                         <i class="fas fa-file-invoice-dollar fa-2x text-gray-300"></i>
  58.                                     </div>
  59.                                 </div>
  60.                             </div>
  61.                         </div>
  62.                     </div>
  63.                     <div class="col-xl-2 col-md-4">
  64.                         <div class="card border-left-danger shadow h-100 py-2">
  65.                             <div class="card-body">
  66.                                 <div class="row no-gutters align-items-center">
  67.                                     <div class="col mr-2">
  68.                                         <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">Coste total</div>
  69.                                         <div id="costeTotal" class="h5 mb-0 font-weight-bold text-gray-800">{{ coste|number_format(2, ',', '.') }} €</div>
  70.                                     </div>
  71.                                     <div class="col-auto">
  72.                                         <i class="fas fa-money-check-alt fa-2x text-gray-300"></i>
  73.                                     </div>
  74.                                 </div>
  75.                             </div>
  76.                         </div>
  77.                     </div>
  78.                     <div class="col-xl-2 col-md-4">
  79.                         <div class="card border-left-info shadow h-100 py-2">
  80.                             <div class="card-body">
  81.                                 <div class="row no-gutters align-items-center">
  82.                                     <div class="col mr-2">
  83.                                         <div class="text-xs font-weight-bold text-info text-uppercase mb-1">Total pagado</div>
  84.                                         <div id="totalPagado" class="h5 mb-0 font-weight-bold text-gray-800">{{ pagado|number_format(2, ',', '.') }} €</div>
  85.                                     </div>
  86.                                     <div class="col-auto">
  87.                                         <i class="fas fa-hand-holding-usd fa-2x text-gray-300"></i>
  88.                                     </div>
  89.                                 </div>
  90.                             </div>
  91.                         </div>
  92.                     </div>
  93.                     <div class="col-xl-2 col-md-4">
  94.                         <div class="card border-left-warning shadow h-100 py-2">
  95.                             <div class="card-body">
  96.                                 <div class="row no-gutters align-items-center">
  97.                                     <div class="col mr-2">
  98.                                         <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">Pendiente de pago</div>
  99.                                         <div id="pendientePago" class="h5 mb-0 font-weight-bold text-gray-800">{{ pendiente|number_format(2, ',', '.') }} €</div>
  100.                                     </div>
  101.                                     <div class="col-auto">
  102.                                         <i class="far fa-clock fa-2x text-gray-300"></i>
  103.                                     </div>
  104.                                 </div>
  105.                             </div>
  106.                         </div>
  107.                     </div>
  108.                     <div class="col-xl-2 col-md-4">
  109.                         <div class="card border-left-dark shadow h-100 py-2">
  110.                             <div class="card-body">
  111.                                 <div class="row no-gutters align-items-center">
  112.                                     <div class="col mr-2">
  113.                                         <div class="text-xs font-weight-bold text-dark text-uppercase mb-1">Total devuelto</div>
  114.                                         <div id="costeTotal" class="h5 mb-0 font-weight-bold text-gray-800">{{ devuelto|number_format(2, ',', '.') }} €</div>
  115.                                     </div>
  116.                                     <div class="col-auto">
  117.                                         <i class="fas fa-exchange-alt fa-2x text-gray-300"></i>
  118.                                     </div>
  119.                                 </div>
  120.                             </div>
  121.                         </div>
  122.                     </div>
  123.                     <div class="col-xl-2 col-md-4">
  124.                         <div class="card border-left-primary shadow h-100 py-2">
  125.                             <div class="card-body">
  126.                                 <div class="row no-gutters align-items-center">
  127.                                     <div class="col mr-2">
  128.                                         <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Beneficio total</div>
  129.                                         <div id="beneficioTotal" class="h5 mb-0 font-weight-bold text-gray-800">{{ beneficio|number_format(2, ',', '.') }} €</div>
  130.                                     </div>
  131.                                     <div class="col-auto">
  132.                                         <i class="fas fa-balance-scale fa-2x text-gray-300"></i>
  133.                                     </div>
  134.                                 </div>
  135.                             </div>
  136.                         </div>
  137.                     </div>
  138.                 </div>
  139.             </div>
  140.         </div>
  141.         {% endif %}
  142.         <!-- DataTables -->
  143.         <div class="card  mb-4">
  144.             <div class="card-body">
  145.                 <input  id="seleccionarFacturasVisible" type="hidden" value="false">
  146.                 <div class="mb-2">
  147.                     <div class="btn-group" role="group" aria-label="Basic example">
  148.                         <button type="button" id="seleccionarFacturas" class="btn btn-primary">
  149.                           <span class="fa-stack small">
  150.                             <i class="far fa-square fa-stack-2x"></i>
  151.                             <i class="fas fa-check fa-stack-1x"></i>
  152.                           </span>Seleccionar facturas
  153.                         </button>
  154.                         <button id="opcionesSeleccion" type="button" class="btn btn-primary" onclick="groupOptionsModal()" disabled>
  155.                             <i class="fas fa-cog mr-1"></i>Opciones
  156.                         </button>
  157.                     </div>
  158.                 </div>
  159.                 <div class="table-responsive">
  160.                     <table class="table table-bordered small" id="facturaTable" width="100%" cellspacing="0">
  161.                         <thead>
  162.                         <tr>
  163.                             <th><input type="checkbox" id="seleccionarTodo" class="d-none"></th>
  164.                             <th class="excel">Cliente</th>
  165.                             <th class="excel">NIF</th>
  166.                             <th class="excel factusol">Código cliente</th>
  167.                             <th class="excel">Referencia contrato</th>
  168.                             <th class="excel factusol">CUPS</th>
  169.                             <th class="excel factusol">Código artículo</th>
  170.                             <th class="excel factusol">Número</th>
  171.                             <th class="excel">Fecha lectura</th>
  172.                             <th class="excel factusol">Fecha emisión</th>
  173.                             <th class="excel">Dirección de suministro</th>
  174.                             <th class="excel">Comercial</th>
  175.                             <th class="excel">Tipo</th>
  176.                             <th class="excel">Tarifa</th>
  177.                             <th class="excel factusol">Base imponible</th>
  178.                             <th class="excel factusol">IVA</th>
  179.                             <th class="excel factusol">Importe</th>
  180.                             <th class="excel">Fecha emisión compra</th>
  181.                             <th class="excel">Fecha cobro compra</th>
  182.                             <th class="excel">Importe compra</th>
  183.                             <th class="excel">Estado compra</th>
  184.                             <th class="excel">Beneficio</th>
  185.                             <th>Opciones</th>
  186.                         </tr>
  187.                         </thead>
  188.                         <tbody>
  189.                         {% for factura in facturas %}
  190.                             {% set tarifa=factura.tarifa %}
  191.                             {% set contrato=factura.contrato %}
  192.                             {% set cliente=contrato.cliente %}
  193.                             {% set suministro=contrato.suministro %}
  194.                             {% set generica=factura.className!='Factura' %}
  195.                             {% if not generica %}
  196.                                 {% set beneficio=((factura.totalFactura ? factura.totalFactura : 0 )-(factura.totalCompra ? factura.totalCompra : 0 )) %}
  197.                             {% else %}
  198.                                 {% set beneficio=factura.totalFactura %}
  199.                             {% endif %}
  200.                             <tr id="factura{% if generica %}Generica{% endif %}{{ factura.id }}" class="{% if beneficio == 0 %}alert-warning{% elseif beneficio<0 %}alert-danger{% endif %}">
  201.                                 <td></td>
  202.                                 <td>{{ cliente }}</td>
  203.                                 <td>{{ cliente.nif }}</td>
  204.                                 <td>{{ cliente.codigoContable }}</td>
  205.                                 <td>{{ contrato }}</td>
  206.                                 <td>{{ suministro.cups }}</td>
  207.                                 <td>{{ suministro.codigoContable }}</td>
  208.                                 <td>{{ factura.numeroFactura }}</td>
  209.                                 {% if not generica %}
  210.                                 <td>{{ factura.fechaLectura ? factura.fechaLectura.format('Y-m-d') : '-' }}</td>
  211.                                 {% else %}
  212.                                  <td>-</td>
  213.                                 {% endif %}
  214.                                 <td>{{ factura.fechaEmision ? factura.fechaEmision.format('Y-m-d') : '-' }}</td>
  215.                                 <td>{{ suministro.direccion }}</td>
  216.                                 <td>{{ contrato.comercial }}</td>
  217.                                 <td>{{ tarifa.tipoTarifa }}</td>
  218.                                 <td>{{ tarifa }}</td>
  219.                                 <td class="text-right">{{ factura.baseImponible|number_format(2, ',', '.') }} €</td>
  220.                                 <td class="">{{ factura.iva }}%</td>
  221.                                 <td class="text-right"><span class="importe">{{ factura.totalFactura|number_format(2, ',', '.') }}</span> €</td>
  222.                                 {% if not generica %}
  223.                                 <td>{{ factura.fechaEmisionCompra ? factura.fechaEmisionCompra.format('Y-m-d') : '-' }}</td>
  224.                                 <td>{{ factura.fechaCobroCompra ? factura.fechaCobroCompra.format('Y-m-d') : '-' }}</td>
  225.                                 <td class="text-right"><span class="importeCompra">{{ factura.totalCompra ? factura.totalCompra|number_format(2, ',', '.') : '0,00' }}</span> €</td>
  226.                                 <td>{{ factura.estadoCompra }}</td>
  227.                                 <td class="text-right"><span class="beneficio">{{ beneficio|number_format(2, ',', '.') }}</span> €</td>
  228.                                     <td>
  229.                                         <a href="{{ path('factura_show', {'id': factura.id}) }}"><i class="fas fa-eye mr-1"></i>Ver</a>
  230.                                         <a href="#" onclick="optionsModal({{ factura.id }})" class="small text-nowrap mr-1 d-inline-block"><i class="fas fa-cog mr-1"></i>Opciones</a>
  231.                                         <input type="hidden" id="devuelta{{ factura.id }}" value="{{ factura.devuelta }}">
  232.                                     </td>
  233.                                 {% else %}
  234.                                     <td></td>
  235.                                     <td></td>
  236.                                     <td>N/A</td>
  237.                                     <td>N/A</td>
  238.                                     <td class="text-right"><span class="beneficio">{{ beneficio|number_format(2, ',', '.') }}</span> €</td>
  239.                                     <td>
  240.                                         <a href="{{ path('facturaGenerica_show', {'id': factura.id}) }}"><i class="fas fa-eye mr-1"></i>Ver</a>
  241.                                         <a href="#" onclick="optionsModal('+id+')" class="small text-nowrap mr-1 d-inline-block"><i class="fas fa-cog mr-1"></i>Opciones</a>
  242.                                         <input type="hidden" id="devuelta{{ factura.id }}" value="{{ factura.devuelta }}">
  243.                                     </td>
  244.                                 {% endif %}
  245.                                 {#  <td>{{ factura.estadoCompra }}</td>
  246.                                 <td>{{ factura.estadoCompra }}</td>
  247.                                 {% if factura.className=='Factura' %}
  248.                                     <td class="text-right">{{ factura.baseImponible|number_format(2, ',', '.') }} €</td>
  249.                                 {% else %}
  250.                                     <td class="text-right">{{ factura.baseImponible|number_format(2, ',', '.') }} €</td>
  251.                                 {% endif %}#}
  252.                             </tr>
  253.                         {% endfor %}
  254.                         </tbody>
  255.                     </table>
  256.                 </div>
  257.                 {% if roleFacturacion %}
  258.                     {{ include('factura/_rentabilidad_options_modal.html.twig') }}
  259.                     {{ include('factura/_options_modal.html.twig') }}
  260.                     {{ include('factura_generica/_options_modal.html.twig') }}
  261.                 {% endif %}
  262.             </div>
  263.         </div>
  265.     </div>
  266. {% endblock %}
  268. {% block script %}
  269.     <!-- Page level plugins -->
  270.     <script src="/vendor/moment.js/moment.min.js"></script>
  271.     <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
  272.     <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
  273.     <script type="text/javascript" src="https://cdn.datatables.net/v/bs4/jszip-2.5.0/dt-1.11.2/b-2.0.0/b-colvis-2.0.0/b-html5-2.0.0/b-print-2.0.0/cr-1.5.4/date-1.1.1/fh-3.1.9/r-2.2.9/sb-1.2.1/datatables.min.js"></script>
  274.     <script src="/vendor/datatables/datetime-moment.js"></script>
  275.     <script src="/vendor/datatables/datetime.js"></script>
  276.     <script src="https://cdn.jsdelivr.net/npm/iban@0.0.14/iban.min.js"></script>
  277.     <script src="https://cdn.jsdelivr.net/npm/select2@4.0.13/dist/js/select2.min.js" integrity="sha256-AFAYEOkzB6iIKnTYZOdUf9FFje6lOTYdwRJKwTN5mks=" crossorigin="anonymous"></script>
  279.     <!-- Page level custom scripts -->
  280.     <script src="/js/tables/rentabilidad-tables.js"></script>
  281.     <script src="/js/rentabilidad.js"></script>
  282.     {% if roleFacturacion %}
  283.         <script src="/js/rentabilidad_options_modal.js"></script>
  284.         <script src="/js/factura_options_modal.js"></script>
  285.         <script src="/js/facturaGenerica_options_modal.js"></script>
  286.     {% endif %}
  287. {% endblock %}