-- 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 `quemindicol`
--

DROP TABLE IF EXISTS `quemindicol`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quemindicol` (
  `id_quemindicol` int(11) NOT NULL DEFAULT '0' COMMENT 'Id. Columna',
  `id_quemindi` int(11) NOT NULL DEFAULT '0' COMMENT 'Id. Indicador',
  `columna` char(80) NOT NULL DEFAULT '_' COMMENT 'Columna',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `expression` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Cálculo',
  `color` char(6) NOT NULL DEFAULT '' COMMENT 'Color texto',
  `bgcolor` char(6) NOT NULL DEFAULT '' COMMENT 'Color fondo',
  `eje` char(20) NOT NULL DEFAULT 'Linear' COMMENT 'Eje',
  `sw_label` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Ver etiqueta',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `tipo` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Tipo',
  `relacionar` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Relacionar',
  `calculo` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Calculo',
  `filtro` text NOT NULL COMMENT 'Filtro',
  `phpexp` text NOT NULL COMMENT 'Expresión',
  `clase` char(80) NOT NULL DEFAULT '' COMMENT 'Clase',
  `estilo` text NOT NULL COMMENT 'Estilo',
  `codigo` text NOT NULL COMMENT 'Código',
  UNIQUE KEY `key0` (`id_tenant`,`id_quemindicol`),
  KEY `key1` (`id_tenant`,`id_quemindi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `quemindicol` WRITE;
/*!40000 ALTER TABLE `quemindicol` DISABLE KEYS */;
INSERT INTO `quemindicol` (`id_quemindicol`, `id_quemindi`, `columna`, `nombre`, `expression`, `color`, `bgcolor`, `eje`, `sw_label`, `id_tenant`, `tipo`, `relacionar`, `calculo`, `filtro`, `phpexp`, `clase`, `estilo`, `codigo`) VALUES (1,101,'fecha_ini','ALTA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-date','',''),(2,101,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,0,0,'','','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(3,101,'nombre','NOMBRE COMERCIAL',0,'','','Linear',0,1,0,0,0,'','','','',''),(4,101,'_','',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','','',''),(5,101,'fecha_ini','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(6,101,'fecha_ini','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(7,101,'fecha_ini','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(8,101,'fecha_ini','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(9,101,'fecha_ini','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(10,101,'fecha_ini','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(11,101,'fecha_ini','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(12,101,'fecha_ini','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(13,101,'fecha_ini','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(14,101,'cod_cuenta','',0,'','','Linear',0,1,2,0,0,'','\'430000000..430999999\'','','',''),(15,102,'fecha','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-data','',''),(16,102,'id_cocabe','PEDIDO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\' - \'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:PV,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(17,102,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(18,102,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(19,102,'imp_bas_euro','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency','',''),(20,102,'_','Pedidos',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(21,102,'imp_bas_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-info info-right','',''),(24,102,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(25,102,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(26,102,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(27,102,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(28,102,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(29,102,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(30,102,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(31,102,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(32,102,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(33,102,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(34,109,'fecha','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','','',''),(35,109,'id_cocabe','PEDIDO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\'-\'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:PC,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(36,109,'cod_cuenta','PROVEEDOR',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(37,109,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','currency item-right','',''),(38,109,'imp_bas_euro','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency item-right','',''),(39,109,'_','Compras',0,'','','Linear',0,1,5,0,0,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(40,109,'imp_bas_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-right','',''),(41,109,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(42,109,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(43,109,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(44,109,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(45,109,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(46,109,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(47,109,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(48,109,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(49,109,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(50,109,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(51,105,'fecha_vto','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-date','','\'data-link=\"cialcart(soporte:\'.$f[\'soporte\'].\',canal:\'.$f[\'canal\'].\',anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\',vto:\'.$f[\'vto\'].\')\"\''),(52,105,'cod_fpago','F. PAGO',0,'','','Linear',0,1,0,1,0,'','$t[\'cod_fpago\'].\'-\'.$t[\'nombre\']','','',''),(53,105,'numero','DOCUMENTO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\'-\'.$f[\'numero\']','','','\'data-link=\"cialdoco(soporte:\'.$f[\'soporte\'].\',canal:\'.$f[\'canal\'].\',anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(54,105,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(55,105,'importe_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(56,105,'importe_euro','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency','',''),(57,105,'importe_euro','Cobros',0,'','','Linear',0,1,5,0,0,'','number_format(count($d),0,\',\',\'.\')','info-left','',''),(58,105,'importe_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-info info-right','',''),(59,105,'fecha_vto','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getToTodayFilter()','','',''),(60,105,'fecha_vto','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndWeekFilter()','','',''),(61,105,'fecha_vto','Próxima semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getNextWeekFilter()','','',''),(62,105,'fecha_vto','Semana siguiente',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndNextWeekFilter()','','',''),(63,105,'fecha_vto','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndMonthFilter()','','',''),(64,105,'fecha_vto','Próximo mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getNextMonthFilter()','','',''),(65,105,'fecha_vto','Mes siguiente',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndNextMonthFilter()','','',''),(66,105,'soporte','',0,'','','Linear',0,1,2,0,0,'','\'=FV\'','','',''),(67,105,'cod_caesta','',0,'','','Linear',0,1,2,0,0,'','\'=100+=510+=520\'','','',''),(68,106,'fecha_vto','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-date','','\'data-link=\"cialcart(soporte:\'.$f[\'soporte\'].\',canal:\'.$f[\'canal\'].\',anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\',vto:\'.$f[\'vto\'].\')\"\''),(69,106,'cod_fpago','F. PAGO',0,'','','Linear',0,1,0,1,0,'','$t[\'cod_fpago\'].\'-\'.$t[\'nombre\']','','',''),(70,106,'numero','DOCUMENTO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\'-\'.$f[\'numero\']','','','\'data-link=\"cialdoco(soporte:\'.$f[\'soporte\'].\',canal:\'.$f[\'canal\'].\',anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(71,106,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(72,106,'importe_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(73,106,'importe_euro','',0,'','','Linear',0,1,4,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency','',''),(74,106,'_','Pagos',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','info-left','',''),(75,106,'importe_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-info info-right','',''),(76,106,'cod_cuenta','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getToTodayFilter()','','',''),(77,106,'cod_cuenta','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndWeekFilter()','','',''),(78,106,'cod_cuenta','Próxima semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getNextWeekFilter()','','',''),(79,106,'cod_cuenta','Semana siguiente',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndNextWeekFilter()','','',''),(80,106,'fecha_vto','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndMonthFilter()','','',''),(81,106,'fecha_vto','Próximo mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getNextMonthFilter()','','',''),(82,106,'fecha_vto','Mes siguiente',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndNextMonthFilter()','','',''),(83,106,'soporte','',0,'','','Linear',0,1,2,0,0,'','\'=FC\'','','',''),(84,106,'cod_caesta','',0,'','','Linear',0,1,2,0,0,'','\'=100\'','','',''),(85,110,'fecha','MES',0,'','','Linear',0,1,3,0,0,'','MONTH($c)','','','array(1 => \'ENE\',2=>\'FEB\',3=>\'MAR\',4=>\'ABR\',5=>\'MAY\',6=>\'JUN\',7=>\'JUL\',8=>\'AGO\',9=>\'SEP\',10=>\'OCT\',11=>\'NOV\',12=>\'DEC\')'),(86,110,'soporte','TIPO',0,'','','Linear',0,1,4,0,0,'','','','','array(\'FC\'=>\'COMPRAS\',\'FV\'=>\'VENTAS\')'),(87,110,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(imp_bas_euro_1+imp_bas_euro_2+imp_bas_euro_3+imp_bas_euro_4),0)','','',''),(88,110,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(90,110,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(91,110,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(92,110,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(93,110,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(94,110,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(95,110,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(96,110,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(97,110,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(98,110,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(99,110,'soporte','Compras',0,'','','Linear',0,1,2,0,0,'=\'FC\'','','','',''),(100,110,'soporte','Ventas',0,'','','Linear',0,1,2,0,0,'=\'FV\'','','','',''),(101,111,'cod_articulo','PRODUCTO',0,'','','Linear',0,1,3,0,0,'','','','',''),(102,111,'importe_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(importe_euro),0)','','',''),(103,111,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(104,111,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(105,111,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(106,111,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(107,111,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(108,111,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(110,105,'sw_cancelado','',0,'','','Linear',0,1,2,0,0,'','\'N\'','','',''),(113,112,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,3,0,0,'','$c','','',''),(114,112,'imp_fra_euro','importe',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(imp_bas_euro_1+imp_bas_euro_2+imp_bas_euro_3+imp_bas_euro_4),0)','','',''),(115,112,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(116,112,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(117,112,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(119,112,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(120,112,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(121,113,'fecha','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-date','',''),(122,113,'id_cocabe','PEDIDO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\'-\'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:PV,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(123,113,'cod_cuenta','CUENTA',0,'','','Linear',0,1,0,1,0,'','$t[\'cod_fpago\'].\'-\'.$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(124,113,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(125,113,'imp_bas_euro','',0,'','','Linear',0,1,4,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency item-right','',''),(126,113,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(127,113,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(128,113,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(129,113,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(130,113,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(131,113,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(132,113,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(133,113,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(134,113,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(135,113,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(138,114,'cod_articulo','FAMILIA',0,'','','Linear',0,1,3,1,0,'','$t.cod_articulo_par','','',''),(139,114,'importe_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(importe_euro),0)','','',''),(140,114,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(141,114,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(142,114,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(143,114,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(144,114,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(145,114,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(148,100,'fecha_ini','ALTA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-date','',''),(149,100,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,0,0,'','','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(150,100,'nombre','NOMBRE COMERCIAL',0,'','','Linear',0,1,0,0,0,'','','','',''),(151,100,'_','',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','','',''),(152,100,'fecha_ini','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(153,100,'fecha_ini','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(154,100,'fecha_ini','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(155,100,'fecha_ini','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(156,100,'fecha_ini','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(157,100,'fecha_ini','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(158,100,'fecha_ini','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(159,100,'fecha_ini','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(160,100,'fecha_ini','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(161,115,'fecha','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-data','',''),(162,115,'id_cocabe','FACTURA',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\' - \'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:FV,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(163,115,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(164,115,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(165,115,'imp_bas_euro','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency','',''),(166,115,'_','Facturas',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(167,115,'imp_bas_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),0,\',\',\'.\')','currency info-info info-right','',''),(170,115,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(171,115,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(172,115,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(173,115,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(174,115,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(175,115,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(176,115,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(177,115,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(178,115,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(179,115,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(180,116,'fecha','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','','',''),(181,116,'id_cocabe','PEDIDO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\'-\'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:FC,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(182,116,'cod_cuenta','PROVEEDOR',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(183,116,'imp_bas_mone','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','currency item-right','',''),(184,116,'imp_bas_mone','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency item-right','',''),(185,116,'_','Compras',0,'','','Linear',0,1,5,0,0,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(186,116,'imp_bas_mone','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),0,\',\',\'.\')','currency info-right','',''),(187,116,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(188,116,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(189,116,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(190,116,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(191,116,'fecha','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(192,116,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(193,116,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(194,116,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(195,116,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(196,116,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(206,117,'fec_entre_pre','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-data','',''),(207,117,'id_cocabe','PEDIDO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\' - \'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:PV,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(208,117,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(209,117,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(210,117,'imp_bas_euro','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency','',''),(211,117,'_','Pedidos',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(212,117,'imp_bas_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-info info-right','',''),(215,117,'fec_entre_pre','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getToTodayFilter()','','',''),(216,117,'fec_entre_pre','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndWeekFilter()','','',''),(217,117,'fec_entre_pre','Próxima semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getNextWeekFilter()','','',''),(218,117,'fec_entre_pre','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndMonthFilter()','','',''),(219,118,'fec_entre_pre','FECHA',0,'','','Linear',0,1,0,0,0,'','QU_Basic::toDateEdited($c)','type-data','',''),(220,118,'id_cocabe','PEDIDO',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_serie\'].\' - \'.$f[\'numero\']','','','\'data-link=\"cialdoco(canal:1,soporte:PC,anyo:\'.$f[\'anyo\'].\',cod_serie:\'.$f[\'cod_serie\'].\',numero:\'.$f[\'numero\'].\')\"\''),(221,118,'cod_cuenta','CLIENTE',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','','\'data-link=\"maescuen(cod_cuenta:\'.$c.\')\"\''),(222,118,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency currency','',''),(223,118,'imp_bas_euro','',0,'','','Linear',0,1,4,0,0,'','number_format(array_sum($a),2,\',\',\'.\')','currency','',''),(224,118,'_','Pedidos',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(225,118,'imp_bas_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-info info-right','',''),(228,118,'fec_entre_pre','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getToTodayFilter()','','',''),(229,118,'fec_entre_pre','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndWeekFilter()','','',''),(230,118,'fec_entre_pre','Próxima semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getNextWeekFilter()','','',''),(231,118,'fec_entre_pre','Este mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getEndMonthFilter()','','',''),(232,119,'fecha','anyo',0,'','','Linear',0,1,4,0,0,'','YEAR($c)','','',''),(233,119,'imp_bas_euro','importe',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(imp_bas_euro_1+imp_bas_euro_2+imp_bas_euro_3+imp_bas_euro_4),0)','','',''),(234,119,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.date(\'Y\').\'..\'','','',''),(235,119,'fecha','2 años',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -1).\'..\'','','',''),(236,119,'fecha','3 años',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -2).\'..\'','','',''),(237,119,'fecha','4 años',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -3).\'..\'','','',''),(238,119,'fecha','5 años',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -4).\'..\'','','',''),(239,119,'_','colores',0,'','','Linear',0,1,-1,0,0,'','array(\'#f35f5f\', \'#f6a54c\', \'#5ece9e\', \'#5587a2\', \'#c5607e\')','','',''),(241,119,'_','tmpForeground',0,'','','Linear',0,1,-2,0,0,'','array_column($aData,\'grp_fecha\')','','','$colores#$n,'),(242,119,'_','foregroundColors',0,'','','Linear',0,1,-2,0,0,'','substr(\'$tmpForeground\',0,-1)','','',''),(243,119,'_','legendItem',0,'','','Linear',0,1,-2,0,0,'','array_column($aData,\'grp_fecha\')','','','<LegendItem label=\"$row\"><fill><SolidColor color=\"$colores#$n\"/></fill></LegendItem>'),(247,120,'fecha','$date(\'Y\')',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.date(\'Y\').\'..\'','','',''),(248,120,'fecha','$date(\'Y\') -1',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -1).\'..31/12/\'.(date(\'Y\') -1)','','',''),(249,120,'fecha','$date(\'Y\') -2',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -2).\'..31/12/\'.(date(\'Y\') -2)','','',''),(250,120,'fecha','$date(\'Y\') -3',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -3).\'..31/12/\'.(date(\'Y\') -3)','','',''),(251,120,'fecha','$date(\'Y\') -4',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -4).\'..31/12/\'.(date(\'Y\') -4)','','',''),(252,120,'imp_bas_euro','importe',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(imp_bas_euro_1+imp_bas_euro_2+imp_bas_euro_3+imp_bas_euro_4),0)','','',''),(254,120,'_','Presupuestos',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','label-right','',''),(255,120,'imp_bas_euro','Total',0,'','','Linear',0,1,5,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','currency info-info info-right','',''),(258,120,'_','ventas',0,'','','Linear',0,1,-3,0,0,'','$aData[0][\'importe\']','','',''),(259,120,'_','',0,'','','Linear',0,1,-5,0,0,'','array(100 *($aData[0][\'importe\']/$objetivos))','','',''),(264,120,'_','TotalObjetivos',0,'','','Linear',0,1,-2,0,1,'','array(\'cialreprcueobj\',array(\'anyo\' => $aData[0][\'grp_fecha\']),array(\'COLS\' => array(\'importe\'),\'GROUPBY\' => array(\'anyo\', true)))','','',''),(280,120,'_','objetivo',0,'','','Linear',0,1,-3,0,0,'','strlen(\'$TotalObjetivos\') > 0 ? $TotalObjetivos : 0','','',''),(281,120,'fecha','anyo',0,'','','Linear',0,1,4,0,0,'','YEAR($c)','','',''),(282,120,'_','objetivos',0,'','','Linear',0,1,-2,0,0,'','max($aData[0][\'importe\'],strlen(\'$TotalObjetivos\') > 0 ? $TotalObjetivos : 0)','','',''),(283,120,'_','maximum',0,'','','Linear',0,1,-2,0,0,'','100 * ceil($aData[0][\'importe\']/$objetivos)','','',''),(284,120,'_','interval',0,'','','Linear',0,1,-2,0,0,'','$maximum/5','','',''),(285,120,'_','tmpValues',0,'','','Linear',0,1,-2,0,0,'','array(0,$interval,$interval*2,$interval*3,$interval*4,$interval*5)','','','$row,'),(286,120,'_','minorInterval',0,'','','Linear',0,1,-2,0,0,'','$interval/5','','',''),(287,120,'_','trackValues',0,'','','Linear',0,1,-2,0,0,'','substr(\'$tmpValues\',0,-1)','','',''),(288,119,'_','maximum',0,'','','Linear',0,1,-2,0,0,'','max(array_column($aData,\'importe\'))','','',''),(289,121,'id_maesarti','PRODUCTO',0,'','','Linear',0,1,0,1,0,'','$t[\'cod_articulo\']','','','\'data-link=\"maesarti(swVerBajas:N,nivel:1,cod_articulo:\'.$t[\'cod_articulo\'].\')\"\''),(290,121,'cod_almacen','ALMACÉN',0,'','','Linear',0,1,0,0,0,'','','','','\'data-link=\"maesalma(swVerBajas:N,cod_almacen:\'.$c.\')\"\''),(291,121,'stock','EXISTENCIAS',0,'','','Linear',0,1,0,0,0,'','','','',''),(292,121,'stock_pdt_ent','ENTRADAS',0,'','','Linear',0,1,0,0,0,'','','','',''),(293,121,'stock_pdt_sal','SALIDAS',0,'','','Linear',0,1,0,0,0,'','','','',''),(294,121,'stock_disponible','DISPONIBLE',0,'','','Linear',0,1,0,0,0,'','','','',''),(295,121,'stock_min','MÍNIMO',0,'','','Linear',0,1,0,0,0,'','','','',''),(296,121,'_','',0,'','','Linear',0,1,0,1,0,'','$f[\'stock_disponible\'] - $f[\'stock_min\']','','',''),(297,121,'_','',0,'','','Linear',0,1,5,0,5,'','number_format(count($d),0,\',\',\'.\')','','',''),(298,121,'cod_almacen','(Todos)',0,'','','Linear',0,1,1,0,2,'','\'\'','','',''),(299,121,'cod_almacen','cod_almacen',0,'','','Linear',0,1,1,0,2,'','self::retrieveTable(\'maesalma(swVerBajas:N,sw_reservas:N)\')','','','data-filter=\'cod_almacen\' title=\'nombre\''),(300,122,'fecha','anyo',0,'','','Linear',0,1,4,0,0,'','YEAR($c)','','',''),(301,122,'imp_bas_euro','importe',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(imp_bas_euro_1+imp_bas_euro_2+imp_bas_euro_3+imp_bas_euro_4),0)','','',''),(302,122,'fecha','$date(\'Y\')',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.date(\'Y\').\'..\'','','',''),(303,122,'fecha','$date(\'Y\') -1',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -1).\'..31/12/\'.(date(\'Y\') -1)','','',''),(304,122,'fecha','$date(\'Y\') -2',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -2).\'..31/12/\'.(date(\'Y\') -2)','','',''),(305,122,'fecha','$date(\'Y\') -3',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -3).\'..31/12/\'.(date(\'Y\') -3)','','',''),(306,122,'fecha','$date(\'Y\') -4',0,'','','Linear',0,1,1,0,2,'','\'1/1/\'.(date(\'Y\') -4).\'..31/12/\'.(date(\'Y\') -4)','','',''),(307,122,'_','TotalObjetivos',0,'','','Linear',0,1,-2,0,1,'','array(\'cialreprcueobj\',array(\'anyo\' => $aData[0][\'grp_fecha\']),array(\'COLS\' => array(\'importe\'),\'GROUPBY\' => array(\'anyo\', true)))','','',''),(308,122,'_','objetivos',0,'','','Linear',0,1,-2,0,0,'','max($aData[0][\'importe\'],strlen(\'$TotalObjetivos\') > 0 ? $TotalObjetivos : 0)','','',''),(309,122,'_','maximum',0,'','','Linear',0,1,-2,0,0,'','ceil($aData[0][\'importe\'])','','',''),(310,122,'_','interval',0,'','','Linear',0,1,-2,0,0,'','$maximum/5','','',''),(311,122,'_','tmpValues',0,'','','Linear',0,1,-2,0,0,'','array(0,$interval,$interval*2,$interval*3,$interval*4,$interval*5)','','','$row,'),(312,122,'_','minorInterval',0,'','','Linear',0,1,-2,0,0,'','$interval/5','','',''),(313,122,'_','trackValues',0,'','','Linear',0,1,-2,0,0,'','substr(\'$tmpValues\',0,-1)','','',''),(314,122,'_','ventas',0,'','','Linear',0,1,-3,0,0,'','$aData[0][\'importe\']','','',''),(315,122,'_','objetivo',0,'','','Linear',0,1,-3,0,0,'','strlen(\'$TotalObjetivos\') > 0 ? $TotalObjetivos : 0','','',''),(316,122,'_','',0,'','','Linear',0,1,-5,0,0,'','array($aData[0][\'importe\'])','','',''),(317,123,'fecha_vto','FECHA',0,'','','Linear',0,1,3,0,0,'','','','',''),(318,123,'saldo_mone','SALDO',0,'','','Linear',0,1,0,0,0,'','SUM($c)','','',''),(319,123,'cobro_mone','COBROS',0,'','','Linear',0,1,0,0,0,'','SUM($c)','','',''),(320,123,'pago_mone','PAGOS',0,'','','Linear',0,1,0,0,0,'','SUM($c)','','',''),(321,123,'hastaFecha','Esta semana',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'S\')','','',''),(322,123,'hastaFecha','Próximos 7 días',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'d+7d\')','','',''),(323,123,'hastaFecha','Próxima semana',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'S+7d\')','','',''),(324,123,'hastaFecha','Este mes',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'M\')','','',''),(325,123,'hastaFecha','Próximo mes',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'d+1m\')','','',''),(326,123,'swResumir','',0,'','','Linear',0,1,2,0,1,'N','','','',''),(327,123,'desdeFecha','',0,'','','Linear',0,1,2,0,1,'','date(\'Ymd\')','','',''),(328,106,'sw_cancelado','cancelado',0,'','','Linear',0,1,2,0,0,'','\'N\'','','',''),(329,106,'cod_serie','serie',0,'','','Linear',0,1,2,0,0,'','\'-PRE\'','','',''),(330,124,'cod_cuenta_paco','CUENTA',0,'','','Linear',0,1,0,1,-1,'','$t[\'cod_cuenta\'].\' - \'.$t[\'nombre\']','','width: 55%',''),(331,124,'cobro_mone','CORBOS',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency','width;15%;',''),(332,124,'pago_mone','PAGOS',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency','width: 15%;',''),(333,124,'saldo_mone','SALDO',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency','width: 15%;',''),(334,124,'cobro_mone','',0,'','','Linear',0,1,4,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','','',''),(335,124,'pago_mone','',0,'','','Linear',0,1,4,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','','',''),(336,124,'saldo_mone','',0,'','','Linear',0,1,4,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','','',''),(337,124,'hastaFecha','Esta semana',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'S\')','','',''),(338,124,'hastaFecha','Próximos 7 días',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'d+7d\')','','',''),(339,124,'hastaFecha','Próxima semana',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'S+7d\')','','',''),(340,124,'hastaFecha','Este mes',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'M\')','','',''),(341,124,'hastaFecha','Próximo mes',0,'','','Linear',0,1,1,0,1,'','QU_Basic::getLimitDate(\'d+1m\')','','',''),(342,124,'swResumir','',0,'','','Linear',0,1,2,0,1,'S','','','',''),(343,124,'desdeFecha','',0,'','','Linear',0,1,2,0,1,'','date(\'Ymd\')','','',''),(344,125,'cod_cuenta','CUENTA',0,'','','Linear',0,1,0,0,0,'','$f[\'cod_cuenta\'].\' - \'.$f[\'nombre\']','','width: 55%',''),(345,125,'saldo_debe','DEBE',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency','width: 15%;',''),(346,125,'saldo_haber','HABER',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency','width: 15%;',''),(347,125,'saldo','SALDOS',0,'','','Linear',0,1,0,0,0,'','number_format($c,2,\',\',\'.\')','type-currency','width: 15%;',''),(348,125,'saldo','',0,'','','Linear',0,1,4,0,1,'','number_format(array_sum($a),2,\',\',\'.\')','type-currency','',''),(350,125,'swApertura','',0,'','','Linear',0,1,2,0,1,'S','','','',''),(351,125,'fechaDesde','',0,'','','Linear',0,1,2,0,1,'','date(\'Y0101\')','','',''),(352,125,'fechaHasta','',0,'','','Linear',0,1,2,0,1,'','date(\'Ymd\')','','',''),(354,125,'codMoneda','$$quup[\'quupempr\'][\'cod_moneda_habi\']',0,'','','Linear',0,1,1,0,1,'','$quup[\'quupempr\'][\'cod_moneda_habi\']','','',''),(355,125,'swCierre','',0,'','','Linear',0,1,2,0,1,'N','','','',''),(356,125,'swRegularizacion','',0,'','','Linear',0,1,2,0,1,'N','','','',''),(357,125,'swCuentasSin','',0,'','','Linear',0,1,2,0,1,'N','','','',''),(358,126,'fecha_inicio','HOY',0,'','','Linear',0,1,3,0,0,'$aRow[\'fecha_inicio\'] == date(\'Ymd\')','','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #ffb22e; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(85, 42, 42, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: italic;\">({$aTab[\'count\']})</span>'),(359,126,'fecha_inicio','PENDIENTE',0,'','','Linear',0,1,3,0,0,'$aRow[\'fecha_inicio\'] != date(\'Ymd\')','','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #ca6565; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(85, 42, 42, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: italic;\">({$aTab[\'count\']})</span>'),(360,126,'tipo','',0,'','','Linear',0,1,0,0,0,'span','\'$tipoIcon#\'.$c','tooltipster-light','width: 10%; height: 60px; color: #655050; font-family: \'FontAwesome\'; font-size: 2em; font-weight: 300; line-height: 60px; float:left; text-align: center; cursor: help;','$c != \'\' ? \'title=\"\'.$f[\'Rid_cermactitip_nombre\'].\'\"\' : \'\''),(361,126,'fecha_inicio','',0,'','','Linear',0,1,0,0,0,'span','substr($c,-2).\' $mesName#\'.substr($c,4,2).\' \'.QU_Basic::toTimeEdited($f[\'hora_inicio\'],\'4\')','','width: 20%; font-size: 0.75em; float: left;',''),(362,126,'localizacion','',0,'','','Linear',0,1,0,0,0,'span','','','width: 70%; display: block; font-size: 0.75em; font-style: italic; text-align: right; float: left;',''),(363,126,'asunto','',0,'','','Linear',0,1,0,0,0,'span','','','width: 80%; color: #655050; font-weight: 500; line-height: 20px; float: left;','\'data-link=\"cermacti(tipo:\'.$f[\'tipo\'].\',id_actividad:\'.$f[\'id_actividad\'].\')&key=0\"\''),(364,126,'cod_cuenta','',0,'','','Linear',0,1,0,1,0,'span','$f[\'relacionado_con\'] == \'C\' ? $t[\'cue_nombre\'] : \'\'','','width: 80%; font-size: 0.8em; font-weight: 200; float: left; line-height: 10px;','\'data-link=\"maescuencrm_v(cod_cuenta:\'.$c.\')\"\''),(365,126,'id_oportunidad','',0,'','','Linear',0,1,0,1,0,'span','$f[\'relacionado_con\'] == \'O\' ? $t[\'descripcion\'] : \'\'','','width: 80%; font-size: 0.8em; font-weight: 200; float: left; line-height: 10px;','\'data-link=\"cermopor(id_oportunidad:\'.$c.\')\"\''),(366,126,'relacionado_con','',0,'','','Linear',0,1,0,0,0,'','','','',''),(367,126,'estado','',0,'','','Linear',0,1,2,0,2,'','\'=P\'','','',''),(368,126,'_','mesName',0,'','','Linear',0,1,-1,0,0,'','array(\'01\' => \'Ene\',\'02\' => \'Feb\',\'03\' => \'Mar\',\'04\' => \'Abr\',\'05\' => \'May\',\'06\' => \'Jun\',\'07\' => \'Jul\',\'08\' => \'Ago\',\'09\' => \'Sep\',\'10\' => \'Oct\',\'11\' => \'Nov\',\'12\' => \'Dec\')','','',''),(369,126,'_','tipoIcon',0,'','','Linear',0,1,-1,0,0,'','array(\'L\' => \'&#xf095;\', \'R\' => \'&#xf0c0;\', \'T\'  => \'&#xf304;\')','','',''),(370,127,'res_visita','CONTACTADOS',0,'','','Linear',0,1,3,0,0,'','\'T\'','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #b0b0b0; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(45, 50, 75, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: normal;\">({$aTab[\'count\']})</span>'),(371,127,'res_visita','INFORMADOS',0,'','','Linear',0,1,3,0,0,'','\'I\'','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #00aab1; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(85, 42, 42, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: normal;\">({$aTab[\'count\']})</span>'),(372,127,'res_visita','OFERTADOS',0,'','','Linear',0,1,3,0,0,'','\'O\'','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #33414e; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(25, 40, 20, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: normal;\">({$aTab[\'count\']})</span>'),(373,127,'res_visita','APLAZADOS',0,'','','Linear',0,1,3,0,0,'','\'A\'','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #ffb22e; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(25, 40, 20, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: normal;\">({$aTab[\'count\']})</span>'),(374,127,'res_visita','CONSEGUIDOS',0,'','','Linear',0,1,3,0,0,'','\'C\'','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #95b75d; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(25, 40, 20, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: normal;\">({$aTab[\'count\']})</span>'),(375,127,'res_visita','PERDIDOS',0,'','','Linear',0,1,3,0,0,'','\'P\'','','','<div style=\"display: inline-block; width: 9px; height: 9px; margin-right: 5px; background-color: #ff4144; border-radius: 50%; box-shadow: 0px 0px 2px 1px rgba(25, 40, 20, 1);\"></div>{$aTab[\'label\']}<span style=\"float: right; margin: 1px 0 0 5px; font-size: 9px; font-weight: 200; font-style: normal;\">({$aTab[\'count\']})</span>'),(376,127,'cod_repres','',0,'','','Linear',0,1,0,1,0,'span','$t[\'nombre\']','','width: 80%; min-height: 20px; color: #888; font-size: 0.6em; font-weight: 200; float:left;','\'data-link=\"maescuenrep(cod_repres:\'.$c.\')\"\''),(377,127,'fecha','',0,'','','Linear',0,1,0,1,0,'span','QU_Basic::toDateEdited($c)','','width: 20%; min-height: 20px; color: #a0a0a0; font-size: 0.6em; font-style: italic; text-align: right;  float:left;',''),(378,127,'descripcion','',0,'','','Linear',0,1,0,0,0,'span','','','width: 70%; color: #5d769e; font-size: 1.1em; font-weight: 500;  float:left;min-height: 20px; ','\'data-link=\"cermopor(id_oportunidad:\'.$f[\'id_oportunidad\'].\')\"\''),(379,127,'presupuesto','',0,'','','Linear',0,1,0,1,0,'span','number_format($c,2,\',\',\'.\')','type-currency currency','width: 30%; min-height: 20px; color: #655050; font-weight: 500;  float:left;',''),(380,127,'cod_cuenta','',0,'','','Linear',0,1,0,1,0,'span','$t[\'nombre\']','','width: 100%; min-height: 20px; color: #655050; font-size:0.65em; font-weight: 200; text-align: right;  float:left;','\'data-link=\"maescuencrm_v(cod_cuenta:\'.$c.\')\"\''),(381,127,'fecha','Hoy',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getTodayFilter()','','',''),(382,127,'fecha','Esta semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentWeekFilter()','','',''),(383,127,'fecha','Última semana',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastWeekFilter()','','',''),(384,127,'fecha','Semana anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevWeekFilter()','','',''),(385,127,'fecha','Mes corriente',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentMonthFilter()','','',''),(386,127,'fecha','Último mes',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastMonthFilter()','','',''),(387,127,'fecha','Mes anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevMonthFilter()','','',''),(388,127,'fecha','Año corriente',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(389,127,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(390,127,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(391,126,'fecha_inicio','',0,'','','Linear',0,1,2,0,2,'','QU_Basic::getToTodayFilter()','','',''),(392,126,'id_cermactitip','',0,'','','Linear',0,1,0,1,0,'','$t[\'nombre\']','','',''),(393,126,'descripcion','',0,'','','Linear',0,1,0,0,0,'span','$c != \'\' ? \'&#xf05a;\' : \'\'','tooltipster-light','font-family: \'FontAwesome\'; font-weight: 300; font-size: 1.2em; float: right; margin: -10px 0 0 5px; color: #455065; cursor: help;','$c != \'\' ? \'title=\"\'.$c.\'\"\' : \'\''),(394,123,'_','SALDO',0,'','','Linear',0,1,-5,0,1,'','$aRow[\'SALDO\'] + ($n>0 ? $aData[$n -1][\'SALDO\'] : 0)','','',''),(395,112,'_','Rcod_cuenta.nombre',0,'','','Linear',0,1,0,0,0,'','','','',''),(396,128,'fecha','MES',0,'','','Linear',0,1,3,0,0,'','MONTH($c)','','','array(1 => \'ENE\',2=>\'FEB\',3=>\'MAR\',4=>\'ABR\',5=>\'MAY\',6=>\'JUN\',7=>\'JUL\',8=>\'AGO\',9=>\'SEP\',10=>\'OCT\',11=>\'NOV\',12=>\'DEC\')'),(397,128,'soporte','TIPO',0,'','','Linear',0,1,4,0,0,'','','','','array(\'FV\'=>\'VENTAS\')'),(398,128,'imp_bas_euro','IMPORTE',0,'','','Linear',0,1,0,0,0,'','IFNULL(SUM(imp_bas_euro_1+imp_bas_euro_2+imp_bas_euro_3+imp_bas_euro_4),0)','','',''),(406,128,'fecha','Este año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getCurrentYearFilter()','','',''),(407,128,'fecha','Último año',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getLastYearFilter()','','',''),(408,128,'fecha','Año anterior',0,'','','Linear',0,1,1,0,2,'','QU_Basic::getPrevYearFilter()','','',''),(410,128,'soporte','Ventas',0,'','','Linear',0,1,2,0,0,'=\'FV\'','','','','');
/*!40000 ALTER TABLE `quemindicol` 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
