-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `quemindi`
--

DROP TABLE IF EXISTS `quemindi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quemindi` (
  `id_quemindi` int(11) NOT NULL DEFAULT '0' COMMENT 'Id. Indicador',
  `num_instala` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº instalación',
  `sql_table` char(30) NOT NULL DEFAULT '' COMMENT 'Tabla',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `titulo` text NOT NULL COMMENT 'Título',
  `descripcion` text NOT NULL COMMENT 'Descripción',
  `indicador` tinyint(4) NOT NULL DEFAULT '0',
  `tipo_gra` tinyint(4) NOT NULL DEFAULT '31' COMMENT 'Tipo',
  `tipo_med` tinyint(4) NOT NULL DEFAULT '41' COMMENT 'Tipo',
  `estilo` text NOT NULL COMMENT 'Estilo',
  `font_size` tinyint(4) NOT NULL DEFAULT '15' COMMENT 'Tamaño letra',
  `color` char(6) NOT NULL DEFAULT '000000' COMMENT 'Color texto',
  `bgcolor` char(6) NOT NULL DEFAULT 'E0E0E0' COMMENT 'Color fondo',
  `sw_leyenda` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Mostrar leyenda',
  `sw_y` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Mostrar eje Y',
  `ptr_width` tinyint(4) NOT NULL DEFAULT '4' COMMENT 'Ancho aguja',
  `ptr_length` tinyint(4) NOT NULL DEFAULT '60' COMMENT 'Largo aguja',
  `meter_width` tinyint(4) NOT NULL DEFAULT '40' COMMENT 'Ancho graduador',
  `meter_angle` tinyint(4) NOT NULL DEFAULT '15' COMMENT 'Ángulo graduador',
  `meter_radius` tinyint(4) NOT NULL DEFAULT '100' COMMENT 'Radio graduador',
  `meter_labels` text NOT NULL COMMENT 'Etiquetas',
  `meter_zonas` text NOT NULL COMMENT 'Zonas',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `constructor` text NOT NULL COMMENT 'Constructor',
  `tipo` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Tipo',
  `dimension` tinyint(4) NOT NULL DEFAULT '2' COMMENT '3D',
  `cilindros` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Cilíndrico',
  `stacked` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Apilado',
  `limite` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Límite',
  `orden` text NOT NULL COMMENT 'Order By',
  `callback` text NOT NULL COMMENT 'Callback',
  `clase` char(80) NOT NULL DEFAULT '' COMMENT 'Clase',
  `propiedades` text NOT NULL COMMENT 'Propiedades',
  `render_h` text NOT NULL COMMENT 'Categoría',
  `render_v` text NOT NULL COMMENT 'Eje',
  `html_widget` text NOT NULL COMMENT 'Indicador',
  `html_content` text NOT NULL COMMENT 'Contenido',
  `html_script` text NOT NULL COMMENT 'Script',
  `categoria` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Categoría',
  `icon_file` text NOT NULL COMMENT 'Imagen',
  UNIQUE KEY `key0` (`id_tenant`,`id_quemindi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quemindi`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `quemindi` WRITE;
/*!40000 ALTER TABLE `quemindi` DISABLE KEYS */;
INSERT INTO `quemindi` (`id_quemindi`, `num_instala`, `sql_table`, `nombre`, `titulo`, `descripcion`, `indicador`, `tipo_gra`, `tipo_med`, `estilo`, `font_size`, `color`, `bgcolor`, `sw_leyenda`, `sw_y`, `ptr_width`, `ptr_length`, `meter_width`, `meter_angle`, `meter_radius`, `meter_labels`, `meter_zonas`, `id_tenant`, `constructor`, `tipo`, `dimension`, `cilindros`, `stacked`, `limite`, `orden`, `callback`, `clase`, `propiedades`, `render_h`, `render_v`, `html_widget`, `html_content`, `html_script`, `categoria`, `icon_file`) VALUES (100,0,'maescuen','Contactos Nuevos','Contactos Nuevos','Altas del periodo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'TIP:r',0,2,0,0,0,'','','warning','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"maescuen(TIP:r)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',5,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-100-13Q1.png'),(101,0,'maescuen','Clientes Nuevos','Clientes Nuevos','Altas del periodo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'',0,2,0,0,0,'','','warning','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"maescuen(TIP:c)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',5,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-101-13Q1.png'),(102,0,'cialdoco','Pedidos Venta','Pedidos Venta','Pedidos del periodo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:PV,canal:1',1,2,0,0,0,'','','success','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:PV)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\" data-id=\"$table\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-102-13Q1.png'),(105,0,'cialcart','Cobros pendientes','Cobros pendientes','Pendientes a fecha',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FV,canal:1',1,2,0,0,0,'','','info','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialcart(canal:1,soporte:FV,cod_caesta:100+510+520,sw_cancelado:N)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\" data-id=\"$table\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',3,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-105-13Q2.png'),(106,0,'cialcart','Pagos pendientes','Pagos pendientes','Pendientes a fecha',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FC,canal:1',1,2,0,0,0,'','','primary','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialcart(canal:1,soporte:FC,cod_caesta:100,sw_cancelado:N)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\" data-id=\"$table\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',3,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-106-13Q1.png'),(109,0,'cialdoco','Pedidos Compra','Pedidos Compras','Pedidos del periodo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:PC,canal:1',1,2,0,0,0,'','','danger','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:PC)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\" data-id=\"$table\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',1,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-109-13Q1.png'),(110,0,'cialdoco','VENTAS Y COMPRAS','Ventas y Compras mensuales','Comparativa del período',1,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1',1,2,0,1,0,'','','kool','showDataTips=\"true\" showDataTipTargets=\"true\"','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{eAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-chart widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"chart-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\"><Options><Legend labelPlacement=\"center\" markerWidth=\"12\" markerHeight=\"12\" styleName=\"legend\" useVisibleCheck=\"true\"/></Options><NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/><NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><CurrencyFormatter id=\"curFormat\"/><CurrencyFormatter id=\"eurFormat\" precision=\"2\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/><DateFormatter id=\"mesFormat\" formatString=\"MM\"/><DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/><DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n<Area2DChart showDataTips=\"true\" showDataTipTargets=\"true\" dataTipJsFunction=\"comvenTipHandler\">\r\n   <horizontalAxis><CategoryAxis id=\"cAxis\" categoryField=\"MES\" displayName=\"MES\"/></horizontalAxis>\r\n   <horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>\r\n   <verticalAxis><LinearAxis id=\"eAxis\" displayName=\"Ventas\"/></verticalAxis>\r\n   <verticalAxisRenderers><Axis2DRenderer axis=\"{eAxis}\" styleName=\"axisTitle\"/></verticalAxisRenderers>\r\n   <series>\r\n      <Area2DSet labelYOffset=\"-10\" >\r\n      <series>\r\n          <Area2DSeries form=\"curve\" yField=\"FC\" displayName=\"Compras\"  styleName=\"series\"><showDataEffect><SeriesInterpolate/></showDataEffect></Area2DSeries>\r\n         <Area2DSeries form=\"curve\" yField=\"FV\" displayName=\"Ventas\"  styleName=\"series\"><showDataEffect><SeriesInterpolate/></showDataEffect></Area2DSeries>\r\n      </series>\r\n      </Area2DSet>\r\n   </series>\r\n</Area2DChart>\r\n<Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; }  .legend { fontSize:9; } .axisTitle { fontSize:9; fontWeight:bold; fontStyle:normal; color:#999; } .chart { fontSize:10; } .series { fontSize:10; color:#444444; } .pie{ fontSize:9 }</Style></KoolChart>','function comvenTipHandler(seriesId, seriesName, index, xName, yName, data, values) {\r\n   let mes = {\'ENE\': \'Enero\', \'FEB\': \'Febrero\', \'MAR\': \'Marzo\', \'ABR\': \'Abril\', \'MAY\': \'Mayo\', \'JUN\': \'Junio\', \'JUL\': \'Julio\', \'AGO\': \'Agosto\', \'SEP\': \'Setiembre\', \'OCT\': \'Octubre\', \'NOV\': \'Noviembre\', \'DEC\': \'Dicimebre\'};\r\n   return \'<div class=\"chart-datatip\"><span class=\"datatip-caption\">\'+seriesName + \' \' + mes[data.grp_fecha]+\'</span><span class=\"datatip-item\" style=\"font-weight: 500\">\' + parseFloat(values[1]).toLocaleString(\'es-ES\', {style: \'currency\', currency: \'EUR\' }) + \'</span></div>\';\r\n}',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-110-13.png'),(111,0,'cialdocolin','TOP PRODUCTOS','Top Productos','Productos más vendidos del periodo',1,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1,soporte:FV',4,2,0,0,10,'IMPORTE desc','loadLabels','kool','showDataTips=\"true\" depth=\"25\" showDataTipTargets=\"true\"','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','','<div id=\"widget-$id\" class=\"widget widget-chart widget-$clase\" style=\"$estilo\">\r\n  <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"chart-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\"><Options><Legend labelPlacement=\"center\" markerWidth=\"12\" markerHeight=\"12\" styleName=\"legend\" useVisibleCheck=\"true\" titleJsFunction=\"productLegendHandler\"/></Options><NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/><NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><CurrencyFormatter id=\"curFormat\"/><CurrencyFormatter id=\"eurFormat\" precision=\"2\" alignSymbol=\"right\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/><DateFormatter id=\"mesFormat\" formatString=\"MM\"/><DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/><DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n<Pie2DChart showDataTips=\"true\" depth=\"25\" dataTipJsFunction=\"productTipHandler\">\r\n   <series>\r\n      <Pie2DSeries nameField=\"PRODUCTO\" field=\"IMPORTE\" formatter=\"{eurFormat}\" labelPosition=\"inside\" color=\"#f9f9f9\" styleName=\"series\">\r\n         <showDataEffect><SeriesSlide duration=\"1000\"/></showDataEffect>\r\n         <fills>\r\n                    <SolidColor color=\"#A1E1D7\"/>\r\n                    <SolidColor color=\"#FDB939\"/>\r\n                    <SolidColor color=\"#F55E53\"/>\r\n                    <SolidColor color=\"#59A759\"/>\r\n                    <SolidColor color=\"#A0652D\"/>\r\n                    <SolidColor color=\"#5C5381\"/>\r\n                    <SolidColor color=\"#D8CB79\"/>\r\n                    <SolidColor color=\"#8C2F71\"/>\r\n                    <SolidColor color=\"#8B95D2\"/>\r\n                    <SolidColor color=\"#C7C4A6\"/>\r\n         </fills>\r\n      </Pie2DSeries>\r\n   </series>\r\n</Pie2DChart>\r\n<Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; }  .legend { fontSize:11; } .axisTitle { fontSize:11; fontWeight:bold; fontStyle:normal; color:#999; } .chart { fontSize:11; } .series { fontSize:11; color:#444444; } .pie{ fontSize:11 }</Style></KoolChart>','function loadLabels(source) {\r\n  getTableData(source, {t: \'maesarti\', nivel:1, d: [\'cod_articulo\',\'nombre\']}, [{source: \'PRODUCTO\', target: \'cod_articulo\'}], function(data) {\r\n    data.forEach( function(it) {\r\n      let item = it;\r\n      let element = source.find( function(el) {\r\n         return el.PRODUCTO == item.cod_articulo;\r\n      });\r\n\r\n      if ( element ) {\r\n        element.nombre = item.nombre;\r\n      }\r\n    });\r\n  });\r\n}\r\n\r\nfunction productLegendHandler(index,displayName) {\r\n  let id = $(event.target).parents(\'.Kool__Root\').attr(\'id\');\r\n  let item =kchartList[id].data.find( function(el) {\r\n      return el.cod_articulo == displayName;\r\n  });\r\n  return item ? item.nombre : \'\';\r\n}\r\n\r\n\r\nfunction productTipHandler(seriesId, seriesName, index, xName, yName, data, values) {\r\n  return \'<div class=\"chart-datatip\"><span class=\"datatip-item\"><span class=\"datatip-label\">\'+data.PRODUCTO+ \'</span><span class=\"datatip-value\">\' + parseFloat(values[0]).toLocaleString(\'es-ES\',{style: \'currency\', currency: \'EUR\'}) + \'(\' + Math.round(values[1]*100) / 100 + \'%)</span></span><span class=\"datatip-caption\">\'+data.nombre+\'</span></div>\';\r\n}',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-111-13.png'),(112,0,'cialdoco','TOP CLIENTES','Top Clientes','Clientes Top Ventas del periodo',1,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1,soporte:FV',3,2,0,0,10,'importe desc','','kool','showDataTips=\"true\" showDataTipTargets=\"true\"','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-chart widget-$clase\" style=\"$estilo\">\r\n  <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"chart-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\"><Options><Legend position=\"right\" labelPlacement=\"right\" direction=\"vertical\" markerWidth=\"10\" markerHeight=\"10\" styleName=\"legend\"/></Options><NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/><NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><CurrencyFormatter id=\"curFormat\"/><CurrencyFormatter id=\"eurFormat\" precision=\"2\" alignSymbol=\"right\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/><DateFormatter id=\"mesFormat\" formatString=\"MM\"/><DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/><DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n<Bar2DChart  showDataTips=\"true\" selectionMode=\"single\" paddingBottom=\"10\" dataTipJsFunction=\"cuentaDataTipHandler\" dataTipDimjovesplayMode=\"mouse\" dataTipBorderRadius=\"2\" dataTipBorderColor=\"#999999\" showDataTipTargets=\"true\" barWidthRatio=\"1\" maxBarWidth=\"12\">\r\n   <horizontalAxis><LinearAxis id=\"cAxis\" displayName=\"TOTAL\"/></horizontalAxis>\r\n   <horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\"  styleName=\"axisTitle\"/></horizontalAxisRenderers>\r\n   <verticalAxis><CategoryAxis id=\"eAxis\" categoryField=\"Rcod_cuenta_nombre\" displayName=\"CLIENTE\"/></verticalAxis>\r\n   <verticalAxisRenderers><Axis2DRenderer axis=\"{eAxis}\" styleName=\"axisTitle\"/></verticalAxisRenderers>\r\n   <series>\r\n      <Bar2DSeries xField=\"importe\" displayName=\"IMPORTE\" labelPosition=\"inside\" color=\"#f9f9f9\" styleName=\"bar\" formatter=\"{eurFormat}\">\r\n         <showDataEffect><SeriesSlide duration=\"1000\"/></showDataEffect>\r\n         <fills>\r\n                    <SolidColor color=\"#105599\"/>\r\n                    <SolidColor color=\"#2065A0\"/>\r\n                    <SolidColor color=\"#3075A9\"/>\r\n                    <SolidColor color=\"#4085B0\"/>\r\n                    <SolidColor color=\"#5095B9\"/>\r\n                    <SolidColor color=\"#60A5C9\"/>\r\n                    <SolidColor color=\"#70A5D0\"/>\r\n                    <SolidColor color=\"#80B5D9\"/>\r\n                    <SolidColor color=\"#90C5E0\"/>\r\n                    <SolidColor color=\"#A0D5E9\"/>\r\n         </fills>      </Bar2DSeries>\r\n   </series>\r\n</Bar2DChart>\r\n<Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; }  .legend { fontSize:10; } .axisTitle { fontSize:9; fontWeight:bold; fontStyle:normal; color:#999; } .chart { fontSize:9; } .series { fontSize:10; color:#444444; } .bar{ fontSize:10; color: #f0f0f0; } </Style></KoolChart>','\r\nfunction cuentaDataTipHandler(seriesId, seriesName, index, xName, yName, data, values) {\r\n   return \'<div class=\"chart-datatip\"><span class=\"datatip-caption\">\'+data.CLIENTE+\' - \'+data.Rcod_cuenta_nombre+\'</span><span class=\"datatip-item\"><span class=\"datatip-label\">Importe</span><span class=\"datatip-value\">\' + parseFloat(data.importe).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' })+\'</span></span></div>\';\r\n}',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-112-13.png'),(113,0,'cialdoco','Pedidos de Venta nuevos','Pedidos de Venta nuevos','Pedidos del periodo',0,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:PV,canal:1',0,2,0,0,0,'fecha','','success','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:PV)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body\">$content</div>\r\n</div>','<div class=\"datatable-container\">\r\n	<table class=\"table table-condensed\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-113-13.png'),(114,0,'cialdocolin','TOP FAMILIAS','Top Familias','Familias más vendidas del periodo',1,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1,soporte:FV',4,2,0,0,10,'IMPORTE desc','loadFamilias','kool','showDataTips=\"true\" depth=\"25\" showDataTipTargets=\"true\"','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','','<div id=\"widget-$id\" class=\"widget widget-chart widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"chart-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\"><Options><Legend position=\"right\" labelPlacement=\"right\" direction=\"vertical\" markerWidth=\"10\" markerHeight=\"10\" styleName=\"legend\" \r\n  useVisibleCheck=\"true\" titleJsFunction=\"legendFamiliasHandler\"/></Options><NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/><NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><CurrencyFormatter id=\"curFormat\"/><CurrencyFormatter id=\"eurFormat\" precision=\"2\" alignSymbol=\"right\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/><DateFormatter id=\"mesFormat\" formatString=\"MM\"/><DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/><DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n<Pie2DChart  innerRadius=\"0.4\" showDataTips=\"true\" selectionMode=\"single\" paddingBottom=\"10\" dataTipJsFunction=\"dataFamiliasHandler\" dataTipDisplayMode=\"mouse\" dataTipBorderRadius=\"2\" dataTipBorderColor=\"#999999\" showDataTipTargets=\"true\">\r\n   <series>\r\n      <Pie2DSeries field=\"IMPORTE\" nameField=\"Rcod_articulo_link_cod_articulo_par\" labelPosition=\"inside\" color=\"#f9f9f9\" styleName=\"pie\" formatter=\"{eurFormat}\">\r\n         <showDataEffect><SeriesSlide duration=\"1000\"/></showDataEffect>\r\n<fills>\r\n                    <SolidColor color=\"#F53E33\"/>\r\n                    <SolidColor color=\"#F54E43\"/>\r\n                    <SolidColor color=\"#F55E53\"/>\r\n                    <SolidColor color=\"#F56E63\"/>\r\n                    <SolidColor color=\"#F57E73\"/>\r\n                    <SolidColor color=\"#F58E83\"/>\r\n                    <SolidColor color=\"#F59E93\"/>\r\n                    <SolidColor color=\"#F5AEA3\"/>\r\n                    <SolidColor color=\"#F5BEB3\"/>\r\n                    <SolidColor color=\"#F5CEC3\"/>\r\n         </fills>\r\n      </Pie2DSeries>\r\n   </series>\r\n</Pie2DChart>\r\n<Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; }  .legend { fontSize:9; } .axisTitle { fontSize:9; fontWeight:bold; fontStyle:normal; color:#999; } .chart { fontSize:10; } .series { fontSize:10; color:#444444; } .pie{ fontSize:9 }</Style></KoolChart>','function loadFamilias(source) {\r\n  getTableData(source, {t: \'maesarti\', nivel:2, d: [\'cod_articulo\',\'nombre\']}, [{source: \'PRODUCTO\', target: \'cod_articulo\'}], function(data) {\r\n    data.forEach( function(it) {\r\n      let item = it;\r\n      let element = source.find( function(el) {\r\n         return el.Rcod_articulo_link_cod_articulo_par == item.cod_articulo;\r\n      });\r\n\r\n      if ( element ) {\r\n        element.nombre = item.nombre;\r\n      }\r\n    });\r\n  });\r\n}\r\n\r\nfunction legendFamiliasHandler(index,displayName) {\r\n  let id = $(event.target).parents(\'.Kool__Root\').attr(\'id\');\r\n  let item =kchartList[id].data.find( function(el) {\r\n      return el.Rcod_articulo_link_cod_articulo_par == displayName;\r\n  });\r\n  return item.nombre;\r\n}\r\n\r\nfunction dataFamiliasHandler(seriesId, seriesName, index, xName, yName, data, values) {\r\n  let id = $(event.target).parents(\'.Kool__Root\').attr(\'id\');\r\n  let item =kchartList[id].data.find( function(el) {\r\n      return el.Rcod_articulo_link_cod_articulo_par == data.Rcod_articulo_link_cod_articulo_par;\r\n  });\r\n\r\n    return \'<div class=\"chart-datatip\"><span class=\"datatip-item\"><span class=\"datatip-label\">\'+item.Rcod_articulo_link_cod_articulo_par + \'</span><span class=\"datatip-value\">\' + parseFloat(values[0]).toLocaleString(\'es-ES\',{style: \'currency\', currency: \'EUR\'}) + \' (\' + Math.round(values[1]*100) / 100 + \'%)</span></span><span class=\"datatip-caption\">\'+item.nombre+\'</span></div>\';\r\n\r\n}',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-114-13.png'),(115,0,'cialdoco','Facturas Venta','Ventas','Facturas del periodo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FV,canal:1',1,2,0,0,0,'','','success','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\"> \r\n<div class=\"widget-heading\"> \r\n<div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:FV)\">$titulo</h4><span>$descripcion</span></div> \r\n$menu \r\n<button class=\"widget-close\">×</button> \r\n</div> \r\n<div id=\"table-$id\" class=\"widget-body $tipo\">$content</div> \r\n<div class=\"widget-footer\">$foot</div> \r\n</div>','<div class=\"table-container\">\r\n    <table class=\"table table-condensed\" data-id=\"$table\">\r\n        <thead>$head</thead>\r\n        <tbody>$result</tbody>\r\n        <tfoot>$totals</tfoot>\r\n    </table>\r\n</div>','',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-115-13Q1.png'),(116,0,'cialdoco','Facturas Compra','Compras','Facturas del periodo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FC,canal:1',1,2,0,0,0,'','','danger','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:FC)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n	<table class=\"table table-condensed\" data-id=\"$table\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',1,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-116-13Q1.png'),(117,0,'cialdoco','Pedidos Venta Pendients','Entregas Pdtes','Entregas pendientes',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1,soporte:PV,estado:P',1,2,0,0,0,'','','success','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:PV,estado:P)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n <table class=\"table table-condensed\" data-id=\"$table\">\r\n  <thead>$head</thead>\r\n  <tbody>$result</tbody>\r\n  <tfoot>$totals</tfoot>\r\n </table>\r\n</div>','',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-117-13Q1.png'),(118,0,'cialdoco','Pedidos Compra Pendients','Recepciones Pdtes','Recepciones pendientes',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1,soporte:PC,estado:P',1,2,0,0,0,'','','danger','','<horizontalAxisRenderers><Axis3DRenderer axis=\"{hAxis}\" fontFamily=\"monospace\" fontSize=\"9\" fontStyle=\"italic\" color=\"#999999\" axisTitleStyleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{vAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialdoco(canal:1,soporte:PC,estado:P)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n <table class=\"table table-condensed\" data-id=\"$table\">\r\n  <thead>$head</thead>\r\n  <tbody>$result</tbody>\r\n  <tfoot>$totals</tfoot>\r\n </table>\r\n</div>','',1,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-118-13Q1.png'),(119,0,'cialdoco','Ventas anuales','Ventas anuales','Comparativa últimos años',2,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FV,canal:1',0,2,0,0,0,'anyo DESC','','','backgroundColors=\"[#f0f0f0]\" foregroundColors=\"[#5587a2,#20cbc2,#f6a54c]\" minimum=\"0\" maximum=\"100000\" startAngle=\"-150\" minimumAngle=\"0\" maximumAngle=\"300\"','','','<div id=\"widget-$id\" class=\"widget widget-gauge widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"gauge-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\"><Options><Legend labelPlacement=\"center\" markerWidth=\"12\" markerHeight=\"12\" styleName=\"legend\"/></Options><NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/><NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><CurrencyFormatter id=\"curFormat\"/><CurrencyFormatter id=\"eurFormat\" precision=\"2\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/><DateFormatter id=\"mesFormat\" formatString=\"MM\"/><DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/><DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n<Gauge innerRatio=\"0.5\"  nameField=\"grp_fecha\" valueField=\"importe\" color=\"#f9f9f9\" backgroundColors=\"[#f0f0f0]\" foregroundColors=\"[$foregroundColors]\" minimum=\"0\" maximum=\"$maximum\" startAngle=\"-150\" minimumAngle=\"0\" maximumAngle=\"300\" labelJsFunction=\"w119LabelHandler\" fontWeight=\"500\" dataTipJsFunction=\"w119TipHandler\" >\r\n <backgroundElements>\r\n    <Box width=\"100%\" height=\"100%\" horizontalAlign=\"center\" verticalAlign=\"middle\">\r\n        <SubLegend direction=\"vertical\" fontSize=\"9\" color=\"#666666\" borderStyle=\"none\">\r\n          $legendItem\r\n        </SubLegend>\r\n    </Box>\r\n</backgroundElements>\r\n</Gauge>\r\n\r\n<Style>\r\n   .koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; } .valueText { fontSize:18; textAlign:center; borderColor:#999999; backgroundColor:#e0e0e0; paddingTop:4; borderThickness:1; borderAlpha:1; borderStyle:solid; } .tickText { fontSize:15; color:#FFFFFF } .trackText { fontSize: 12px; color: #f9f9f9; fontWeight: bold; }\r\n</Style>\r\n\r\n</KoolChart>','function w119LabelHandler(value) {\r\n    return parseFloat(value).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' });\r\n}\r\n\r\nfunction w119TipHandler(value) {\r\n   let id = $(event.target).parents(\'.Kool__Root\').attr(\'id\');\r\n   return \'<div class=\"chart-datatip\"><span class=\"datatip-item\"><span class=\"datatip-label\">\' + value[1] + \': </span><span class=\"datatip-value\">\'+parseFloat(value[0]).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' }) + \'</span></span></div>\';\r\n}',2,'/var/www/erp.quartup.net/htdocs/quartup.outs/imgs/ERPquartup3/quemindi/icon-119-13.png'),(120,0,'cialdoco','Objetivos','Objetivos','Cumplimiento anual',2,31,41,'width: 40%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FV,canal:1',0,2,0,0,0,'','','','backgroundColors=\"[#f0f0f0]\" foregroundColors=\"[#5587a2,#20cbc2,#f6a54c]\" minimum=\"0\" maximum=\"100000\" startAngle=\"-150\" minimumAngle=\"0\" maximumAngle=\"300\"','','','<div id=\"widget-$id\" class=\"widget widget-gauge widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"gauge-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\">\r\n <CurrencyFormatter id=\"tpcFormat\" precision=\"0\" currencySymbol=\"%\" thousandsSeparatorTo=\".\" alignSymbol=\"right\"/>\r\n <HalfCircularGauge startAngle=\"165\" minimumAngle=\"0\" maximumAngle=\"210\" minimum=\"0\" maximum=\"100\" interval=\"20\" minorInterval=\"5\" formatter=\"{tpcFormat}\" editMode=\"false\" liveDragging=\"true\" showDataTip=\"true\" valueXOffset=\"0\" valueYOffset=\"0\" isValueTop=\"true\" tickLabelStyleName=\"tickText\" valueLabelStyleName=\"valueText\" needleCoverRadius=\"20\" needleThickness=\"20\" pointThickness=\"0\" needleLengthRatio=\"0.7\" needlePointStyle=\"steeple\" needleBackLengthRatio=\"0\" tickGap=\"0\" labelGap=\"15\" tickLabelPlacement=\"outside\" majorTickType=\"line\" tickRadius=\"12\" minorTickType=\"line\" minorTickRadius=\"10\" showTrackColor=\"true\" trackValues=\"[0,20,40,60,80,100]\" trackColors=\"[#f35f5f,#f6a54c,#b7e2ac,#5ece9e,#5587a2]\" trackAlphas=\"[0.8,0.85,0.90,0.95,1]\" trackInnerRadius=\"0.87\" trackOuterRadius=\"1\" dataTipJsFunction=\"w120TipHandler\">\r\n        <frameFill>\r\n            <SolidColor color=\"#ffffff\"/>\r\n        </frameFill>\r\n        <frameStroke>\r\n            <Stroke color=\"#777\" weight=\"0\" alpha=\"0\"/>\r\n        </frameStroke>\r\n        <tickStroke>\r\n            <Stroke color=\"#ffffff\" alpha=\"0\"/>\r\n        </tickStroke>\r\n        <minorTickStroke>\r\n            <Stroke color=\"#ffffff\"/>\r\n        </minorTickStroke>\r\n        <needleFill>\r\n            <SolidColor color=\"#555\"/>\r\n        </needleFill>\r\n        <needleStroke>\r\n            <Stroke color=\"#555\"/>\r\n        </needleStroke>\r\n        <needleCoverFill>\r\n            <SolidColor color=\"#ffffff\" alpha=\"1\"/>\r\n        </needleCoverFill>\r\n        <needleCoverStroke>\r\n            <Stroke color=\"#555\" weight=\"4\"/>\r\n        </needleCoverStroke>\r\n    </HalfCircularGauge>\r\n\r\n<Style>\r\n   .koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; } .valueText { fontSize:15; textAlign:center; color:#777; backgroundColor:#fff; paddingTop:4; borderThickness:0;  } .tickText { fontSize:12; color:#999 } .trackText { fontSize: 12px; color: #f9f9f9; fontWeight: bold; }\r\n</Style>\r\n\r\n</KoolChart>','function w120TipHandler(value) {\r\n   let id = $(event.target).parents(\'.Kool__Root\').attr(\'id\');\r\n return \'<div class=\"chart-datatip\"><span class=\"datatip-item\"><span class=\"datatip-label\">Objetivos: </span><span class=\"datatip-value\">\'+parseFloat(kchartList[id].context.objetivo).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' }) + \'</span></span><span class=\"datatip-item\"><span class=\"datatip-label\">Ventas: </span><span class=\"datatip-value\">\'+parseFloat(kchartList[id].context.ventas).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' }) + \'</span></span><span class=\"datatip-item\"><span class=\"datatip-label\"></span><span class=\"datatip-value\">\' + parseFloat(value).toLocaleString(\'es-ES\', {maximumFractionDigits: 2}) + \' %</span></span></div>\';\r\n}',2,''),(121,0,'almasterart','Alertas de Stock','Alertas de Stock','Productos bajo Mínimo',0,31,41,'',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'',0,2,0,0,0,'','','','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body $tipo\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"table-container\">\r\n    <table class=\"table table-condensed\" data-id=\"$table\">\r\n        <thead>$head</thead>\r\n        <tbody>$result</tbody>\r\n        <tfoot>$totals</tfoot>\r\n    </table>\r\n</div>','',4,''),(122,0,'cialdoco','Objetivos','Objetivos','Cumplimiento anual',2,31,41,'width: 40%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'soporte:FV,canal:1',0,2,0,0,0,'','','','backgroundColors=\"[#f0f0f0]\" foregroundColors=\"[#5587a2,#20cbc2,#f6a54c]\" minimum=\"0\" maximum=\"100000\" startAngle=\"-150\" minimumAngle=\"0\" maximumAngle=\"300\"','','','<div id=\"widget-$id\" class=\"widget widget-gauge widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"gauge-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\">\r\n    <CircularGauge startAngle=\"90\" minimumAngle=\"30\" maximumAngle=\"330\" minimum=\"0\" maximum=\"$maximum\" interval=\"$interval\" minorInterval=\"$minorInterval\" editMode=\"false\" liveDragging=\"true\" showDataTip=\"true\" valueXOffset=\"0\" valueYOffset=\"60\" isValueTop=\"true\" tickLabelStyleName=\"tickText\" valueLabelStyleName=\"valueText\" coverRadiusRatio=\"0.5\" needleCoverRadius=\"5\" needleThickness=\"8\" pointThickness=\"2\" needleLengthRatio=\"0.7\" needlePointStyle=\"steeple\" needleBackLengthRatio=\"0\" tickGap=\"0\" labelGap=\"15\" tickLabelPlacement=\"outside\" majorTickType=\"line\" tickRadius=\"12\" minorTickType=\"line\" minorTickRadius=\"3\" showTrackColor=\"true\" trackValues=\"[$trackValues]\" trackColors=\"[#f35f5f,#f6a54c,#b7e2ac,#5ece9e,#5587a2]\" trackAlphas=\"[0.8,0.85,0.90,0.95,1]\" trackInnerRadius=\"1\" trackOuterRadius=\"1.03\" secondMinimum=\"0\" secondMaximum=\"100\" secondInterval=\"20\" showSecondTick=\"true\" showSecondMinorTick=\"false\" secondTickGap=\"8\" secondTickRadius=\"2\" secondMinorTickType=\"line\" showSecondValueLabel=\"true\" showSecondTickLabels=\"true\" secondTrackInnerRadius=\"0.95\" secondTrackOuterRadius=\"0.96\" secondTickLabelStyleName=\"secondTickText\" showSecondTrackColor=\"true\" secondTrackValues=\"[0,$maximum]\" secondTrackColors=\"[#8587a2]\" secondTrackAlphas=\"[0.5]\"  labelJsFunction=\"w122LabelHandler\" secondLabelJsFunction=\"w122SecondLabelHandler\"  dataTipJsFunction=\"w122TipHandler\">\r\n    <frameFill><SolidColor color=\"#ffffff\"/></frameFill>\r\n    <frameStroke><Stroke color=\"#777\" weight=\"0\" alpha=\"0\"/></frameStroke>\r\n    <tickStroke><Stroke color=\"#ffffff\" alpha=\"0\"/></tickStroke>\r\n    <minorTickStroke><Stroke color=\"#ffffff\"/></minorTickStroke>\r\n    <needleFill><SolidColor color=\"#555\"/></needleFill>\r\n    <needleStroke><Stroke color=\"#555\"/></needleStroke>\r\n    <needleCoverFill><SolidColor color=\"#ffffff\" alpha=\"1\"/></needleCoverFill>\r\n    <needleCoverStroke><Stroke color=\"#555\" weight=\"2\"/></needleCoverStroke>\r\n    <secondMinorTickStroke><Stroke color=\"#8587a2\"/></secondMinorTickStroke>\r\n    <secondTickStroke><Stroke color=\"#8587a2\" weight=\"1\"/></secondTickStroke>\r\n</CircularGauge>\r\n<Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; } .valueText { fontSize:15; textAlign:center;backgroundColor:0xFFFFFF;backgroundAlpha:1;paddingTop:2;borderThickness:1;borderStyle:none;fontWeight:bold; } .tickText { fontSize:12; color:#999 } .trackText { fontSize: 12px; color: #f9f9f9; fontWeight: bold; } .secondTickText {fontSize:9;color:#8786a2;fontWeight:bold;}</Style>\r\n</KoolChart>','function w122TipHandler(value) {\r\n   let id = $(event.target).parents(\'.Kool__Root\').attr(\'id\');\r\n return \'<div class=\"chart-datatip\"><span class=\"datatip-item\"><span class=\"datatip-label\">Objetivos: </span><span class=\"datatip-value\">\'+parseFloat(kchartList[id].context.objetivo).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' }) + \'</span></span><span class=\"datatip-item\"><span class=\"datatip-label\">Ventas: </span><span class=\"datatip-value\">\'+parseFloat(kchartList[id].context.ventas).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' }) + \'</span></span><span class=\"datatip-item\"><span class=\"datatip-label\"></span><span class=\"datatip-value\">\' + parseFloat(value).toLocaleString(\'es-ES\', {maximumFractionDigits: 2}) + \' %</span></span></div>\';\r\n}\r\n\r\nfunction w122LabelHandler(value) {\r\n    return parseFloat(value).toLocaleString(\'es-ES\', { style: \'currency\', currency: \'EUR\' });\r\n}\r\n\r\nfunction w122SecondLabelHandler(value) {\r\n    return parseFloat(value).toLocaleString(\'es-ES\', {maximumFractionDigits: 2}) + \' %\';\r\n}',2,''),(123,0,'cialteso_v','CASH FLOW','CASH FLOW','Flujo de caja en el período',1,31,41,'width: 90%; height: 450px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'',0,2,0,0,0,'FECHA','','kool','showDataTips=\"true\" showDataTipTargets=\"true\"','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','','<div id=\"widget-$id\" class=\"widget widget-chart widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"chart-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\">\r\n   <Options><Legend labelPlacement=\"center\" markerWidth=\"12\" markerHeight=\"12\" styleName=\"legend\"/></Options>\r\n   <NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/>\r\n   <NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/>\r\n   <CurrencyFormatter id=\"curFormat\"/>\r\n   <CurrencyFormatter id=\"eurFormat\" precision=\"2\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/>\r\n   <DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/>\r\n   <DateFormatter id=\"mesFormat\" formatString=\"MM\"/>\r\n   <DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/>\r\n   <DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n   <Combination2DChart showDataTips=\"true\" showDataTipTargets=\"true\" dataTipJsFunction=\"w123dataTipHandler\">\r\n      <horizontalAxis><CategoryAxis id=\"cAxis\" categoryField=\"FECHA\" displayName=\"FECHA\" formatter=\"{fecFormat}\"/></horizontalAxis>\r\n      <horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>\r\n      <verticalAxis><LinearAxis id=\"eAxis\" displayName=\"TOTAL\"/></verticalAxis>\r\n      <verticalAxisRenderers><Axis2DRenderer axis=\"{eAxis}\"/></verticalAxisRenderers>\r\n      <series>\r\n         <Area2DSeries yField=\"SALDO\" displayName=\"SALDO\"  form=\"curve\" styleName=\"series\"><showDataEffect><SeriesInterpolate/></showDataEffect></Area2DSeries>\r\n        <Line2DSeries yField=\"COBROS\"  displayName=\"COBROS\" form=\"curve\" styleName=\"series\" lineStyle=\"dashLine\"><showDataEffect><SeriesInterpolate/></showDataEffect></Line2DSeries>\r\n        <Line2DSeries yField=\"PAGOS\"  displayName=\"PAGOS\" form=\"curve\" styleName=\"series\" lineStyle=\"dashLine\"><showDataEffect><SeriesInterpolate/></showDataEffect></Line2DSeries>\r\n      </series>\r\n   </Combination2DChart>\r\n   <Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; }  .legend { fontFamily:monospace; fontSize:10; } .axisTitle { fontFamily:monospace; fontSize:9; fontWeight:bold; fontStyle:normal; color:#999; } .chart { fontFamily:monospace; fontSize:10; } .series { fontFamily:monospace; fontSize:11; color:#444444; } </Style>\r\n</KoolChart>','function w123dataTipHandler(seriesId, seriesName, index, xName, yName, data, values) {\r\n   return \'<div class=\"chart-datatip\"><span class=\"datatip-caption\" style=\"font-weight: bold\">\'+data.FECHA+\'</span><span class=\"datatip-item\" style=\"font-weight: 500\"><span class=\"datatip-label\">COBROS:</span><span class=\"datatip-value\">\' + parseFloat(data.COBROS).toLocaleString(\'es-ES\', {style: \'currency\', currency: \'EUR\' }) + \'</span></span><span class=\"datatip-item\" style=\"font-weight: 500\"><span class=\"datatip-label\">PAGOS:</span><span class=\"datatip-value\">\' + parseFloat(data.PAGOS).toLocaleString(\'es-ES\', {style: \'currency\', currency: \'EUR\' }) + \'</span></span><span class=\"datatip-item\" style=\"font-weight: 500\"><span class=\"datatip-label\">SALDO:</span><span class=\"datatip-value\">\' + parseFloat(data.SALDO).toLocaleString(\'es-ES\', {style: \'currency\', currency: \'EUR\' }) + \'</span></span></div>\';\r\n}\r\n',3,''),(124,0,'cialteso_v','COBROS Y PAGOS','COBROS Y PAGOS','',0,31,41,'width: 48%; height: 480px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'',0,2,0,0,0,'','','info','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialteso_v\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"datatable-container\">\r\n	<table class=\"table table-condensed\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',3,''),(125,0,'cialsaldfec_v','SALDOS','SALDOS','Saldos actuales',0,31,41,'width: 48%; height: 480px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'TIP:b,digitos:9',0,2,0,0,0,'','TIP:b,digitos:9,canal:1','','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cialsaldfec_v(TIP:b,digitos:9)\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <div id=\"table-$id\" class=\"widget-body\">$content</div>\r\n   <div class=\"widget-footer\">$foot</div>\r\n</div>','<div class=\"datatable-container\">\r\n	<table class=\"table table-condensed\">\r\n		<thead>$head</thead>\r\n		<tbody>$result</tbody>\r\n		<tfoot>$totals</tfoot>\r\n	</table>\r\n</div>','',3,''),(126,0,'cermacti','AGENDA','AGENDA Y ACTIVIDADES','',0,31,41,'width: 45%; height: 400px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'',3,2,0,0,0,'fecha_inicio desc, hora_inicio desc','','warning','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <ul class=\"widget-tabs\"></ul>\r\n   <div id=\"panel-$id\" class=\"widget-body\" style=\"max-height: 310px; overflow-y: auto;\"></div>\r\n</div>','<div class=\"panel-container\" style=\"height: 60px; display: block; background-color: #fdfdfd; border-bottom: 1px solid #e9e9e9; border-radius: 2px; margin: 0 3px 2px 3px; padding: 5px; padding-top: 0;\">$result</div>','',5,''),(127,0,'cermopor','OPORTUNIDADES','OPORTUNIDADES','',0,31,41,'width: 50%; height: 400px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'',3,2,0,0,0,'','','success','','','','<div id=\"widget-$id\" class=\"widget widget-table widget-$clase\" style=\"$estilo\">\r\n    <div class=\"widget-heading\">\r\n       <div class=\"widget-title\"><h4 data-link=\"cermopor\">$titulo</h4><span>$descripcion</span></div>\r\n       $menu\r\n      <button class=\"widget-close\">×</button>\r\n   </div>\r\n   <ul class=\"widget-tabs\"></ul>\r\n   <div id=\"panel-$id\" class=\"widget-body\" style=\"max-height: 260px; overflow-y: auto;\"></div>\r\n</div>','<div class=\"panel-container\" style=\"height: 60px; background-color: #fbfbfb; border-bottom: 1px solid #e9e9e9; border-radius: 2px; margin: 0 3px 2px 3px; padding: 5px; padding-top: 0;\">$result</div>','',5,''),(128,0,'cialdoco','VENTAS MENSUALES','Ventas mensuales','Comparativa del período',1,31,41,'width: 48%; height: 380px;',15,'000000','E0E0E0',1,1,4,60,40,15,100,'','',1,'canal:1',2,2,0,0,0,'','','kool','showDataTips=\"true\" showDataTipTargets=\"true\"','<horizontalAxisRenderers><Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/></horizontalAxisRenderers>','<verticalAxisRenderers><Axis2DRenderer axis=\"{eAxis}\"/></verticalAxisRenderers>','<div id=\"widget-$id\" class=\"widget widget-chart widget-$clase\" style=\"$estilo\">\r\n  <div class=\"widget-heading\"><div class=\"widget-title\"><h4>$titulo</h4><span>$descripcion</span></div>$menu</div>\r\n   <div id=\"chart-$id\" class=\"widget-container\">$content</div>\r\n</div>','<KoolChart styleName=\"koolchart\"><Options><Legend labelPlacement=\"center\" markerWidth=\"12\" markerHeight=\"12\" styleName=\"legend\"/></Options><NumberFormatter id=\"intFormat\" precision=\"0\" thousandsSeparatorTo=\".\"/><NumberFormatter id=\"decFormat\" precision=\"2\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><CurrencyFormatter id=\"curFormat\"/><CurrencyFormatter id=\"eurFormat\" precision=\"2\" currencySymbol=\"&#8364;\" thousandsSeparatorTo=\".\" decimalSeparatorTo=\",\"/><DateFormatter id=\"fecFormat\" formatString=\"DD/MM/YYYY\"/><DateFormatter id=\"mesFormat\" formatString=\"MM\"/><DateFormatter id=\"meyFormat\" formatString=\"MM-YYYY\"/><DateFormatter id=\"anyFormat\" formatString=\"YYYY\"/>\r\n<Column2DChart showDataTips=\"true\" showDataTipTargets=\"true\">\r\n    <horizontalAxis>\r\n        <CategoryAxis id=\"cAxis\" categoryField=\"MES\" displayName=\"MES\"/>\r\n    </horizontalAxis>\r\n<horizontalAxisRenderers>\r\n    <Axis2DRenderer axis=\"{cAxis}\" styleName=\"axisTitle\"/>\r\n</horizontalAxisRenderers>\r\n\r\n<verticalAxis>\r\n    <LinearAxis id=\"eAxis\" displayName=\"TIPO\"/>\r\n</verticalAxis>\r\n<verticalAxisRenderers>\r\n    <Axis2DRenderer axis=\"{eAxis}\"/>\r\n</verticalAxisRenderers>\r\n<series>\r\n    <Column2DSeries yField=\"FV\" displayName=\"VENTAS\"  styleName=\"series\"><showDataEffect><SeriesInterpolate/></showDataEffect> \r\n   </Column2DSeries>\r\n</series>\r\n</Column2DChart>\r\n\r\n<Style>.koolchart { backgroundColor:#ffffff; borderStyle:none; cornerRadius:12; paddingBottom:5; }  .legend { fontFamily:monospace; fontSize:9; } .axisTitle { fontFamily:monospace; fontSize:8; fontWeight:bold; fontStyle:normal; color:#999; } .chart { fontFamily:monospace; fontSize:9; } .series { fontFamily:monospace; fontSize:10; color:#444444; } </Style>\r\n</KoolChart>','function comvenTipHandler(seriesId, seriesName, index, xName, yName, data, values) {\r\n   let mes = {\'ENE\': \'Enero\', \'FEB\': \'Febrero\', \'MAR\': \'Marzo\', \'ABR\': \'Abril\', \'MAY\': \'Mayo\', \'JUN\': \'Junio\', \'JUL\': \'Julio\', \'AGO\': \'Agosto\', \'SEP\': \'Setiembre\', \'OCT\': \'Octubre\', \'NOV\': \'Noviembre\', \'DEC\': \'Diciembre\'};\r\n   return \'<div class=\"chart-datatip\"><span class=\"datatip-caption\">\'+seriesName + \' \' + mes[data.grp_fecha]+\'</span><span class=\"datatip-item\" style=\"font-weight: 500\">\' + parseFloat(values[1]).toLocaleString(\'es-ES\', {style: \'currency\', currency: \'EUR\' }) + \'</span></div>\';\r\n}',2,'');
/*!40000 ALTER TABLE `quemindi` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-30  8:42:00
