-- Table structure for table `ventas2018`
--

CREATE TABLE `ventas2018` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `idmayornomina` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas2018`
--


--
-- Table structure for table `ventas2019`
--

CREATE TABLE `ventas2019` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `idmayornomina` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas2019`
--


--
-- Table structure for table `ventas2020`
--

CREATE TABLE `ventas2020` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `idmayornomina` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas2020`
--


--
-- Table structure for table `ventas2021`
--

CREATE TABLE `ventas2021` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `idmayornomina` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas2021`
--


--
-- Table structure for table `ventas2022`
--

CREATE TABLE `ventas2022` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `idmayornomina` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas2022`
--


--
-- Table structure for table `ventas2023`
--

CREATE TABLE `ventas2023` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `idmayornomina` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas2023`
--


--
-- Table structure for table `ventas3`
--

CREATE TABLE `ventas3` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` int NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(25) DEFAULT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` int DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(5) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(5) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `esnota` int DEFAULT '0',
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'lafonda',
  `zonaventas` varchar(25) DEFAULT NULL,
  `seccionventas` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `integraconfamilia` int DEFAULT '1',
  `codmodifpapa` int DEFAULT '0',
  `TIPOIVA` int DEFAULT '1',
  `sesubearappi` int DEFAULT '0',
  `refventas` varchar(20) DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `iddomiciliario` int DEFAULT NULL,
  `horaaceptado` datetime DEFAULT NULL,
  `comandaaceptada` bit(1) DEFAULT b'0',
  `horaacancelada` datetime DEFAULT NULL,
  `comandacancelada` bit(1) DEFAULT b'0',
  `motivocancela` varchar(25) DEFAULT NULL,
  `paqueterecibido` bit(1) DEFAULT b'0',
  `hora_paqueterecibido` bit(1) DEFAULT b'0',
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `puntosrevisados` bit(1) DEFAULT b'0',
  `idusuarioredime` int DEFAULT NULL,
  `usuarioredime` varchar(50) DEFAULT NULL,
  `fecharedime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idfactura` (`idfactura`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventas3`
--


--
-- Table structure for table `ventasauxiliar`
--

CREATE TABLE `ventasauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmesarelacionada` int DEFAULT '0',
  `estadoimpresion` int DEFAULT '0',
  `identificador` varchar(100) DEFAULT NULL,
  `referenciapayu` varchar(200) DEFAULT NULL,
  `referenciafront` varchar(15) DEFAULT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `pagarcontraentrega` int DEFAULT '0',
  `idmesa` int DEFAULT '1',
  `descuento` double NOT NULL DEFAULT '0',
  `codsituacion` int DEFAULT NULL,
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `cc` int DEFAULT '2',
  `origen` varchar(15) DEFAULT 'MESAS',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime DEFAULT NULL,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `observacion` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `enespera` int NOT NULL DEFAULT '0' COMMENT 'para que el mesero ya no pueda eliminar',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `CODMODIF` int NOT NULL DEFAULT '0',
  `numlinea` int NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `situacioncocina` varchar(50) DEFAULT NULL,
  `CODARTICULOABAJO` int NOT NULL DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `PrecuentaCallcenter` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `placa` varchar(8) DEFAULT NULL,
  `seccion` varchar(25) DEFAULT NULL,
  `bodega` varchar(25) DEFAULT NULL,
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `refventas` varchar(20) DEFAULT NULL,
  `referencia` varchar(25) DEFAULT NULL,
  `enviaraproduccion` int DEFAULT '0',
  `baseunitario` decimal(11,2) DEFAULT '0.00',
  `impuestounitario` decimal(11,2) DEFAULT '0.00',
  `iddomiciliario` int DEFAULT NULL,
  `ultimocostev` double DEFAULT '0',
  `recibidovaux` double DEFAULT '0',
  `devueltavaux` double DEFAULT '0',
  `seccionventas` varchar(25) DEFAULT NULL,
  `porcentajecomision` decimal(5,2) DEFAULT '0.00',
  `articulovence` date DEFAULT NULL,
  `imei` varchar(50) DEFAULT NULL,
  `factor` int DEFAULT '1',
  `sefactura` bit(1) DEFAULT b'1',
  `costomenu` decimal(11,2) DEFAULT '0.00',
  `comensales` int DEFAULT '0',
  `comanda` varchar(10) DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `comocalculardescuento` varchar(10) DEFAULT 'porcentaje',
  `recibidoencallcenter` int DEFAULT '0',
  `tipodescuento` varchar(15) DEFAULT NULL,
  `porcentajesobrecargoeventos` double DEFAULT '0',
  `sobrecargoeventos` double DEFAULT '0',
  `sgroupname` int DEFAULT '0',
  `campovalor` varchar(25) DEFAULT 'valordeventa',
  `proximocosto` double DEFAULT '0',
  `sesiones` int DEFAULT '1',
  `ultimafechaimpresionprecuenta` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcliente` (`idcliente`),
  CONSTRAINT `ventasauxiliar_ibfk_3` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `ventasauxiliar_ibfk_4` FOREIGN KEY (`idvendedor`) REFERENCES `clientes` (`id`),
  CONSTRAINT `ventasauxiliar_ibfk_6` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1712 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventasauxiliar`
--


--
-- Table structure for table `ventasauxiliar2`
--

CREATE TABLE `ventasauxiliar2` (
  `idmesarelacionada` int DEFAULT '0',
  `estadoimpresion` int DEFAULT '0',
  `identificador` varchar(100) DEFAULT NULL,
  `referenciapayu` varchar(200) DEFAULT NULL,
  `referenciafront` varchar(15) DEFAULT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `pagarcontraentrega` int DEFAULT '0',
  `idmesa` int DEFAULT '1',
  `descuento` double NOT NULL DEFAULT '0',
  `codsituacion` int DEFAULT NULL,
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '2',
  `origen` varchar(25) DEFAULT NULL,
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime DEFAULT NULL,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `observacion` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `enespera` int NOT NULL DEFAULT '0' COMMENT 'para que el mesero ya no pueda eliminar',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `CODMODIF` int NOT NULL DEFAULT '0',
  `numlinea` int NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `situacioncocina` varchar(50) DEFAULT NULL,
  `CODARTICULOABAJO` int NOT NULL DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `impreso` int DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `PrecuentaCallcenter` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `placa` varchar(8) DEFAULT NULL,
  `seccion` varchar(25) DEFAULT NULL,
  `bodega` varchar(25) DEFAULT NULL,
  `id` int DEFAULT '0',
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventasauxiliar2`
--


--
-- Table structure for table `ventasporhoras`
--

CREATE TABLE `ventasporhoras` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `dato0` double NOT NULL DEFAULT '0',
  `dato1` double NOT NULL DEFAULT '0',
  `dato2` double NOT NULL DEFAULT '0',
  `dato3` double NOT NULL DEFAULT '0',
  `dato4` double NOT NULL DEFAULT '0',
  `dato5` double NOT NULL DEFAULT '0',
  `dato6` double NOT NULL DEFAULT '0',
  `cc` int NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ventasporhoras`
--

INSERT INTO `ventasporhoras` (`id`, `fecha`, `dato0`, `dato1`, `dato2`, `dato3`, `dato4`, `dato5`, `dato6`, `cc`, `pv`) VALUES (1,'2022-12-29',0,89000,172500,1508000,154500,0,0,2,'KALDI');

--
-- Table structure for table `z`
--

CREATE TABLE `z` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `consecutivo` int NOT NULL DEFAULT '1',
  `descuento` double NOT NULL DEFAULT '0',
  `plataseparados` double NOT NULL DEFAULT '0',
  `domicilios` double NOT NULL DEFAULT '0',
  `ventaefectivo` double NOT NULL DEFAULT '0',
  `abonosseparados` double NOT NULL DEFAULT '0',
  `bruto` double NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT '0',
  `cantidaddearticulos` int NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `devoluciones` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `idcierre` int NOT NULL DEFAULT '0',
  `abonos` double NOT NULL DEFAULT '0',
  `bolsillos` double NOT NULL DEFAULT '0',
  `compras` double NOT NULL DEFAULT '0',
  `consumobolsillos` double NOT NULL DEFAULT '0',
  `ventaacredito` double NOT NULL DEFAULT '0',
  `pagofacturascredito` double NOT NULL DEFAULT '0',
  `otrosgastos` double NOT NULL DEFAULT '0',
  `gastossinafectarcaja` double NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL,
  `otrosingresos` double NOT NULL DEFAULT '0',
  `cortesia` double NOT NULL DEFAULT '0',
  `cantidaddearticuloscortesia` double NOT NULL DEFAULT '0',
  `servicios` double DEFAULT '0',
  `fisico` int DEFAULT '0',
  `prestamoaempleados` double DEFAULT '0',
  `domicilio` int DEFAULT '0',
  `abonosprestamos` int DEFAULT '0',
  `base` int DEFAULT '0',
  `ifood` int DEFAULT '0',
  `rappi` int DEFAULT '0',
  `efectivo` int DEFAULT '0',
  `transferencias` int DEFAULT '0',
  `datafono` int DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `domicilioexterno` int DEFAULT '0',
  `notasdebitoencompra` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `abonosordenservicio` double DEFAULT '0',
  `nequi` int DEFAULT '0',
  `notascreditoenventas` double DEFAULT '0',
  `otrosgastossinafectarcaja` double DEFAULT '0',
  `devolucionesdedinero` double DEFAULT '0',
  `sistecredito` int DEFAULT '0',
  `prestamosalaempresa` int DEFAULT '0',
  `abonosprestamosin` int DEFAULT '0',
  `nomina` int DEFAULT '0',
  `anticipos` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=495 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `z`
--

INSERT INTO `z` (`id`, `fecha`, `consecutivo`, `descuento`, `plataseparados`, `domicilios`, `ventaefectivo`, `abonosseparados`, `bruto`, `total`, `cantidaddearticulos`, `idusuario`, `devoluciones`, `cc`, `idcierre`, `abonos`, `bolsillos`, `compras`, `consumobolsillos`, `ventaacredito`, `pagofacturascredito`, `otrosgastos`, `gastossinafectarcaja`, `idcaja`, `otrosingresos`, `cortesia`, `cantidaddearticuloscortesia`, `servicios`, `fisico`, `prestamoaempleados`, `domicilio`, `abonosprestamos`, `base`, `ifood`, `rappi`, `efectivo`, `transferencias`, `datafono`, `observaciones`, `domicilioexterno`, `notasdebitoencompra`, `pv`, `abonosordenservicio`, `nequi`, `notascreditoenventas`, `otrosgastossinafectarcaja`, `devolucionesdedinero`, `sistecredito`, `prestamosalaempresa`, `abonosprestamosin`, `nomina`, `anticipos`) VALUES (1,'2020-12-24 19:28:24',1,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(2,'2022-12-08 08:13:32',418,0,0,0,179000,0,179000,179000,14,1,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,8600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(3,'2022-12-08 21:11:32',419,0,0,0,364000,0,364000,364000,36,5,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(4,'2022-12-09 20:06:20',420,0,0,0,292500,0,292500,292500,36,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(5,'2022-12-10 18:59:44',421,0,0,0,580000,0,580000,580000,83,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,19100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(6,'2022-12-11 18:31:13',422,0,0,0,1202000,0,1202000,1202000,143,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,74200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(7,'2022-12-12 16:51:22',423,0,0,0,424000,0,424000,424000,41,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(8,'2022-12-13 19:48:11',424,0,0,0,122000,0,122000,122000,17,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(9,'2022-12-14 18:31:34',425,0,0,0,52000,0,52000,52000,14,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(10,'2022-12-15 19:54:48',426,0,0,0,410000,0,410000,410000,42,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(11,'2022-12-16 20:03:00',427,0,0,0,166000,0,166000,166000,11,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,9100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(12,'2022-12-17 20:07:44',428,0,0,0,435000,0,435000,435000,66,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,18500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(13,'2022-12-18 19:58:02',429,0,0,0,1535500,0,1535500,1535500,233,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,93450,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(14,'2022-12-20 20:12:40',430,0,0,0,309000,0,309000,309000,27,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(15,'2022-12-21 17:55:00',431,0,0,0,99000,0,99000,99000,6,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(16,'2022-12-22 19:03:40',432,0,0,0,122500,0,122500,122500,7,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(17,'2022-12-23 18:06:43',433,0,0,0,148000,0,148000,148000,13,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(18,'2022-12-24 18:53:48',434,0,0,0,190000,0,190000,190000,25,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,23000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(19,'2022-12-25 20:18:12',435,0,0,0,1833000,0,1833000,1833000,205,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,123450,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(20,'2022-12-26 20:17:35',436,0,0,0,1274500,0,1274500,1274500,97,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,40450,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(21,'2022-12-27 19:15:30',437,0,0,0,1036500,0,1036500,1036500,153,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,83850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(22,'2022-12-28 20:47:17',438,0,0,0,1930000,0,1930000,1930000,192,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,137350,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(23,'2022-12-29 20:19:05',439,0,0,0,2127500,0,2127500,2127500,236,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,153950,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(24,'2022-12-30 20:50:32',440,0,0,0,2297000,0,2297000,2297000,238,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,185150,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(25,'2022-12-31 19:58:19',441,0,0,0,1265500,0,1265500,1265500,160,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,97250,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(26,'2023-01-01 20:26:57',442,0,0,0,2283500,0,2283500,2283500,220,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,149500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(27,'2023-01-02 20:59:26',443,0,0,0,3868500,0,3868500,3868500,384,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,305350,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(28,'2023-01-03 19:59:56',444,0,0,0,4010000,0,4010000,4010000,484,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,261700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(29,'2023-01-04 20:20:07',445,0,0,0,4422000,0,4422000,4422000,432,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,181600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(30,'2023-01-05 20:41:05',446,0,0,0,4643500,0,4643500,4643500,400,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,361400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(31,'2023-01-06 19:50:56',447,0,0,0,3988500,0,3988500,3988500,447,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,283700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(32,'2023-01-07 20:09:14',448,0,0,0,5131000,0,5131000,5131000,560,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,387550,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(33,'2023-01-08 19:40:25',449,0,0,0,4273000,0,4273000,4273000,419,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,296050,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(34,'2023-01-09 19:59:21',450,0,0,0,3103000,0,3103000,3103000,380,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,230000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(35,'2023-01-10 21:32:16',451,0,0,0,1741500,0,1741500,1741500,175,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,125800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(36,'2023-01-11 19:54:40',452,0,0,0,1056500,0,1056500,1056500,149,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,24100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(37,'2023-01-12 18:58:49',453,0,0,0,934500,0,934500,934500,97,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,57000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(38,'2023-01-13 20:05:04',454,0,0,0,1605000,0,1605000,1605000,207,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,90300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(39,'2023-01-14 18:27:07',455,0,0,0,609000,0,609000,609000,57,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,42400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(40,'2023-01-15 19:30:26',456,0,0,0,3082000,0,3082000,3082000,238,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,122750,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(41,'2023-01-17 17:40:28',457,0,0,0,25000,0,25000,25000,10,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(42,'2023-01-18 19:02:15',458,0,0,0,362500,0,362500,362500,37,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,5000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(43,'2023-01-19 17:53:48',459,0,0,0,336000,0,336000,336000,18,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,6400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(44,'2023-01-20 16:11:37',460,0,0,0,277000,0,277000,277000,70,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(45,'2023-01-21 21:50:34',461,0,0,0,249000,0,249000,249000,30,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,9300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(46,'2023-01-22 19:39:41',462,0,0,0,1594500,0,1594500,1594500,178,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,132850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(47,'2023-01-24 19:14:26',463,0,0,0,789000,0,789000,789000,81,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,20500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(48,'2023-01-28 19:09:26',464,0,0,0,613000,0,613000,613000,64,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,28400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(49,'2023-01-29 19:55:23',465,0,0,0,2978000,0,2978000,2978000,236,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,216200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(50,'2023-02-03 11:12:28',466,0,0,0,478000,0,478000,478000,58,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(51,'2023-02-03 19:03:59',467,0,0,0,46000,0,46000,46000,9,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(52,'2023-02-04 19:13:19',468,0,0,0,761000,0,761000,761000,99,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,71850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(53,'2023-02-05 19:02:37',469,0,0,0,2490000,0,2490000,2490000,222,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,192750,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(54,'2023-02-08 18:29:01',470,0,0,0,283000,0,283000,283000,26,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(55,'2023-02-09 18:48:20',471,0,0,0,205000,0,205000,205000,12,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(56,'2023-02-11 19:43:19',472,0,0,0,835500,0,835500,835500,103,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,68550,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(57,'2023-02-12 19:03:26',473,0,0,0,1489000,0,1489000,1489000,168,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,92400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(58,'2023-02-18 19:23:02',474,0,0,0,487500,0,487500,487500,75,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(59,'2023-02-19 18:46:12',475,0,0,0,881000,0,881000,881000,81,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,53300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(60,'2023-02-24 18:36:12',476,0,0,0,90000,0,90000,90000,16,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(61,'2023-02-25 18:40:26',477,0,0,0,266000,0,266000,266000,24,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,26600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(62,'2023-02-26 19:18:15',478,0,0,0,2058000,0,2058000,2058000,176,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,109100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(63,'2023-02-28 18:15:25',479,0,0,0,12000,0,12000,12000,2,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(64,'2023-03-02 18:43:56',480,0,0,0,355000,0,355000,355000,27,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(65,'2023-03-04 18:41:24',481,0,0,0,159000,0,159000,159000,10,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(66,'2023-03-05 18:57:13',482,0,0,0,1390500,0,1390500,1390500,158,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,183700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(67,'2023-03-09 18:30:11',483,0,0,0,276000,0,276000,276000,25,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(68,'2023-03-11 19:12:01',484,0,0,0,162000,0,162000,162000,10,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,12800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(69,'2023-03-12 18:34:49',485,0,0,0,1545000,0,1545000,1545000,116,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,28600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(70,'2023-03-16 18:59:28',486,0,0,0,621000,0,621000,621000,38,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(71,'2023-03-18 19:26:40',487,0,0,0,358000,0,358000,358000,52,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,27900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(72,'2023-03-19 18:14:50',488,0,0,0,2609500,0,2609500,2609500,262,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,112800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(73,'2023-03-20 18:44:18',489,0,0,0,2138000,0,2138000,2138000,186,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,143000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(74,'2023-03-21 18:55:43',490,0,0,0,192000,0,192000,192000,35,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(75,'2023-03-26 19:05:51',491,0,0,0,1211000,0,1211000,1211000,95,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,90000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(76,'2023-03-29 17:42:50',492,0,0,0,284000,0,284000,284000,24,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(77,'2023-04-01 19:07:12',493,0,0,0,166500,0,166500,166500,21,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,13600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(78,'2023-04-02 19:02:54',494,0,0,0,948000,0,948000,948000,99,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,79000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(79,'2023-04-03 17:46:09',495,0,0,0,688000,0,688000,688000,50,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,19500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(80,'2023-04-04 19:14:28',496,0,0,0,616000,0,616000,616000,74,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,20900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(81,'2023-04-05 19:20:04',497,0,0,0,1809000,0,1809000,1809000,136,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,102800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(82,'2023-04-06 21:43:21',498,0,0,0,4316000,0,4316000,4316000,394,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,206000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(83,'2023-04-07 20:19:35',499,0,0,0,5158000,0,5158000,5158000,502,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,365900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(84,'2023-04-08 19:27:58',500,0,0,0,1325500,0,1325500,1325500,155,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,93450,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(85,'2023-04-10 13:43:50',501,0,0,0,807000,0,807000,807000,82,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,67500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(86,'2023-04-13 18:41:53',502,0,0,0,286000,0,286000,286000,44,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(87,'2023-04-15 18:51:43',503,0,0,0,99000,0,99000,99000,15,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(88,'2023-04-16 18:02:54',504,0,0,0,335000,0,335000,335000,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,24900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(89,'2023-04-18 18:41:29',505,0,0,0,82000,0,82000,82000,10,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(90,'2023-04-19 17:45:38',506,0,0,0,59000,0,59000,59000,12,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(91,'2023-04-22 18:52:10',507,0,0,0,85000,0,85000,85000,19,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,6000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(92,'2023-04-23 18:18:17',508,0,0,0,399000,0,399000,399000,24,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,24200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(93,'2023-04-26 18:20:56',509,0,0,0,211000,0,211000,211000,28,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,9700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(94,'2023-04-29 19:16:51',510,0,0,0,495000,0,495000,495000,45,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,32700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(95,'2023-04-30 19:05:26',511,0,0,0,2559000,0,2559000,2559000,211,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,103500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(96,'2023-05-01 18:41:06',512,0,0,0,1334500,0,1334500,1334500,177,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,84700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(97,'2023-05-06 19:06:35',513,0,0,0,307000,0,307000,307000,50,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,11600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(98,'2023-05-07 18:49:49',514,0,0,0,801500,0,801500,801500,92,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,32300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(99,'2023-05-09 19:37:02',515,0,0,0,402000,0,402000,402000,50,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,36100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(100,'2023-05-10 18:04:10',516,0,0,0,116000,0,116000,116000,28,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,8500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(101,'2023-05-11 18:29:57',517,0,0,0,265000,0,265000,265000,17,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(102,'2023-05-13 19:10:39',518,0,0,0,325000,0,325000,325000,17,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,32500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(103,'2023-05-14 19:42:06',519,0,0,0,1809000,0,1809000,1809000,97,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,134500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(104,'2023-05-16 18:28:47',520,0,0,0,462000,0,462000,462000,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(105,'2023-05-18 19:14:46',521,0,0,0,274000,0,274000,274000,17,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(106,'2023-05-20 17:08:47',522,0,0,0,442000,0,442000,442000,35,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(107,'2023-05-21 18:06:36',523,0,0,0,1735000,0,1735000,1735000,186,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,95000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(108,'2023-05-22 18:25:46',524,0,0,0,875000,0,875000,875000,74,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,46400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(109,'2023-05-27 18:25:57',525,0,0,0,164000,0,164000,164000,18,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,7700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(110,'2023-05-28 18:07:49',526,0,0,0,399000,0,399000,399000,42,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,11900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(111,'2023-06-02 18:55:17',527,0,0,0,187000,0,187000,187000,23,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(112,'2023-06-03 18:50:21',528,0,0,0,114000,0,114000,114000,13,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(113,'2023-06-04 18:41:40',529,0,0,0,1413000,0,1413000,1413000,114,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,91900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(114,'2023-06-07 18:53:05',530,0,0,0,137000,0,137000,137000,27,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(115,'2023-06-08 18:47:37',531,0,0,0,227500,0,227500,227500,18,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(116,'2023-06-09 19:01:34',532,0,0,0,241000,0,241000,241000,18,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(117,'2023-06-10 19:23:54',533,0,0,0,294500,0,294500,294500,29,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,6400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(118,'2023-06-11 19:05:43',534,0,0,0,2237000,0,2237000,2237000,194,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,126500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(119,'2023-06-12 19:08:23',535,0,0,0,517000,0,517000,517000,56,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,22800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(120,'2023-06-15 19:53:01',536,0,0,0,519000,0,519000,519000,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(121,'2023-06-16 19:07:14',537,0,0,0,255500,0,255500,255500,60,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(122,'2023-06-17 18:59:16',538,0,0,0,382000,0,382000,382000,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,31200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(123,'2023-06-18 18:50:52',539,0,0,0,2617000,0,2617000,2617000,231,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,91000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(124,'2023-06-19 18:57:23',540,0,0,0,857000,0,857000,857000,110,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,30900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(125,'2023-06-20 18:44:22',541,0,0,0,235000,0,235000,235000,35,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(126,'2023-06-21 18:52:08',542,0,0,0,64000,0,64000,64000,16,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(127,'2023-06-22 18:42:47',543,0,0,0,334000,0,334000,334000,19,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(128,'2023-06-23 18:53:54',544,0,0,0,80000,0,80000,80000,17,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(129,'2023-06-24 18:51:05',545,0,0,0,342500,0,342500,342500,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,6400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(130,'2023-06-25 18:56:36',546,0,0,0,1361000,0,1361000,1361000,117,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,92300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(131,'2023-06-26 18:52:55',547,0,0,0,271000,0,271000,271000,32,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(132,'2023-06-27 18:56:46',548,0,0,0,284000,0,284000,284000,49,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(133,'2023-06-29 18:57:15',549,0,0,0,316000,0,316000,316000,69,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,11800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(134,'2023-06-30 19:12:42',550,0,0,0,720000,0,720000,720000,51,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,44600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(135,'2023-07-01 18:59:45',551,0,0,0,1812000,0,1812000,1812000,177,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,107200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(136,'2023-07-02 20:41:58',552,0,0,0,4002000,0,4002000,4002000,335,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,205800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(137,'2023-07-03 18:23:37',553,0,0,0,2810500,0,2810500,2810500,300,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,160600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(138,'2023-07-04 14:47:56',554,0,0,0,655000,0,655000,655000,103,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,26400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(139,'2023-07-05 19:03:48',555,0,0,0,184000,0,184000,184000,20,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(140,'2023-07-06 19:02:06',556,0,0,0,187000,0,187000,187000,21,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(141,'2023-07-07 20:19:25',557,0,0,0,578000,0,578000,578000,52,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,13800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(142,'2023-07-08 19:24:51',558,0,0,0,682500,0,682500,682500,62,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,15100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(143,'2023-07-09 19:02:15',559,0,0,0,2743000,0,2743000,2743000,249,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,152400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(144,'2023-07-11 18:42:56',560,0,0,0,465500,0,465500,465500,52,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,12450,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(145,'2023-07-12 18:57:45',561,0,0,0,302000,0,302000,302000,29,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(146,'2023-07-13 19:04:49',562,0,0,0,192000,0,192000,192000,43,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(147,'2023-07-14 19:44:11',563,0,0,0,433500,0,433500,433500,40,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,16300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(148,'2023-07-15 19:29:18',564,0,0,0,1260000,0,1260000,1260000,201,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,70100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(149,'2023-07-16 17:57:05',565,0,0,0,2042000,0,2042000,2042000,215,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,103000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(150,'2023-07-17 18:29:56',566,0,0,0,294000,0,294000,294000,30,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,14000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(151,'2023-07-18 18:53:30',567,0,0,0,436000,0,436000,436000,38,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,41800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(152,'2023-07-19 18:42:20',568,0,0,0,503000,0,503000,503000,59,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,37900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(153,'2023-07-20 18:04:34',569,0,0,0,1581000,0,1581000,1581000,141,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,69000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(154,'2023-07-21 19:43:30',570,0,0,0,1125000,0,1125000,1125000,179,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,101900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(155,'2023-07-22 18:31:29',571,0,0,0,436000,0,436000,436000,96,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,28100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(156,'2023-07-23 18:03:19',572,0,0,0,1993000,0,1993000,1993000,196,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,121300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(157,'2023-07-25 19:16:10',573,0,0,0,299000,0,299000,299000,45,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(158,'2023-07-26 19:00:41',574,0,0,0,379000,0,379000,379000,56,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,30500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(159,'2023-07-27 19:05:11',575,0,0,0,49500,0,49500,49500,11,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(160,'2023-07-28 20:28:25',576,0,0,0,498500,0,498500,498500,70,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,12500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(161,'2023-07-29 18:51:37',577,0,0,0,644000,0,644000,644000,58,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,14900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(162,'2023-07-30 18:31:15',578,0,0,0,1108500,0,1108500,1108500,132,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,56400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(163,'2023-07-31 12:46:39',579,0,0,0,356000,0,356000,356000,74,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(164,'2023-08-01 18:26:40',580,0,0,0,116000,0,116000,116000,13,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(165,'2023-08-04 19:10:59',581,0,0,0,384000,0,384000,384000,38,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,1200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(166,'2023-08-05 20:27:58',582,0,0,0,769500,0,769500,769500,98,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,14600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(167,'2023-08-06 18:57:59',583,0,0,0,2952000,0,2952000,2952000,290,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,165000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(168,'2023-08-07 19:34:31',584,0,0,0,1984000,0,1984000,1984000,241,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,68000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(169,'2023-08-08 19:04:46',585,0,0,0,698000,0,698000,698000,77,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,4000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(170,'2023-08-10 18:31:16',586,0,0,0,148000,0,148000,148000,14,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(171,'2023-08-12 18:46:21',587,0,0,0,968000,0,968000,968000,112,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,43800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(172,'2023-08-13 17:51:52',588,0,0,0,942000,0,942000,942000,85,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,60600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(173,'2023-08-15 18:49:29',589,0,0,0,454000,0,454000,454000,47,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,7900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(174,'2023-08-18 18:38:52',590,0,0,0,251000,0,251000,251000,40,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(175,'2023-08-19 18:30:58',591,0,0,0,456000,0,456000,456000,65,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,12800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(176,'2023-08-20 19:25:10',592,0,0,0,3798510,0,3798510,3798510,453,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,283251,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(177,'2023-08-21 17:59:31',593,0,0,0,563000,0,563000,563000,98,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,26100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(178,'2023-08-23 20:14:51',594,0,0,0,345000,0,345000,345000,42,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,11200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(179,'2023-08-24 18:51:47',595,0,0,0,301000,0,301000,301000,49,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(180,'2023-08-26 18:38:01',596,0,0,0,249000,0,249000,249000,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,5000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(181,'2023-08-27 18:45:54',597,0,0,0,955000,0,955000,955000,87,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,85400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(182,'2023-08-28 18:28:34',598,0,0,0,255000,0,255000,255000,37,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(183,'2023-08-30 18:00:45',599,0,0,0,446000,0,446000,446000,51,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(184,'2023-08-31 19:27:03',600,0,0,0,182500,0,182500,182500,28,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(185,'2023-09-01 19:27:53',601,0,0,0,111000,0,111000,111000,16,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(186,'2023-09-02 19:10:02',602,0,0,0,413000,0,413000,413000,42,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,9000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(187,'2023-09-03 18:36:02',603,0,0,0,1732000,0,1732000,1732000,157,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,108500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(188,'2023-09-04 19:38:42',604,0,0,0,124000,0,124000,124000,20,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(189,'2023-09-07 17:48:03',605,0,0,0,230500,0,230500,230500,28,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(190,'2023-09-09 18:03:13',606,0,0,0,832000,0,832000,832000,71,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,24600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(191,'2023-09-10 18:38:45',607,0,0,0,932000,0,932000,932000,127,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,44600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(192,'2023-09-11 18:32:31',608,0,0,0,275000,0,275000,275000,19,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(193,'2023-09-12 18:19:36',609,0,0,0,286000,0,286000,286000,26,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(194,'2023-09-13 18:09:11',610,0,0,0,170000,0,170000,170000,23,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(195,'2023-09-15 18:42:56',611,0,0,0,137000,0,137000,137000,18,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(196,'2023-09-16 19:19:37',612,0,0,0,509000,0,509000,509000,75,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(197,'2023-09-17 18:31:13',613,0,0,0,2323000,0,2323000,2323000,197,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,177300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(198,'2023-09-18 17:40:02',614,0,0,0,203000,0,203000,203000,12,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(199,'2023-09-22 18:29:59',615,0,0,0,1068000,0,1068000,1068000,112,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,32100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(200,'2023-09-24 19:01:04',616,0,0,0,2036500,0,2036500,2036500,261,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,104850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(201,'2023-09-25 17:53:30',617,0,0,0,86500,0,86500,86500,6,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(202,'2023-09-28 18:28:26',618,0,0,0,72000,0,72000,72000,5,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(203,'2023-09-29 19:57:27',619,0,0,0,503000,0,503000,503000,44,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(204,'2023-09-30 19:05:15',620,0,0,0,200000,0,200000,200000,40,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(205,'2023-10-01 18:29:20',621,0,0,0,688000,0,688000,688000,74,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,35600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(206,'2023-10-02 17:32:14',622,0,0,0,210000,0,210000,210000,28,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(207,'2023-10-04 18:22:27',623,0,0,0,150000,0,150000,150000,14,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(208,'2023-10-06 18:19:24',624,0,0,0,448000,0,448000,448000,70,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,13400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(209,'2023-10-07 18:59:28',625,0,0,0,520500,0,520500,520500,40,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,34000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(210,'2023-10-08 17:42:43',626,0,0,0,465000,0,465000,465000,72,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,21700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(211,'2023-10-11 19:29:23',627,0,0,0,930000,0,930000,930000,152,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,5400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(212,'2023-10-12 18:07:32',628,0,0,0,326500,0,326500,326500,54,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,7000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(213,'2023-10-14 19:14:03',629,0,0,0,2362000,0,2362000,2362000,194,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,105800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(214,'2023-10-15 19:13:15',630,0,0,0,3161000,0,3161000,3161000,313,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,204700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(215,'2023-10-16 18:42:48',631,0,0,0,1407000,0,1407000,1407000,158,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,117600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(216,'2023-10-18 18:03:09',632,0,0,0,445000,0,445000,445000,35,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(217,'2023-10-21 17:50:31',633,0,0,0,878000,0,878000,878000,60,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(218,'2023-10-22 18:50:01',634,0,0,0,1046500,0,1046500,1046500,97,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,50300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(219,'2023-10-28 20:58:15',635,0,0,0,1353000,0,1353000,1353000,165,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,8600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(220,'2023-11-03 18:37:00',636,0,0,0,797000,0,797000,797000,87,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(221,'2023-11-04 18:30:56',637,0,0,0,472000,0,472000,472000,36,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(222,'2023-11-05 18:09:57',638,0,0,0,2783000,0,2783000,2783000,215,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,206100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(223,'2023-11-06 18:23:41',639,0,0,0,1293000,0,1293000,1293000,106,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,88500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(224,'2023-11-09 17:55:07',640,0,0,0,627000,0,627000,627000,66,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(225,'2023-11-11 18:51:23',641,0,0,0,455000,0,455000,455000,51,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(226,'2023-11-12 18:44:25',642,0,0,0,2411500,0,2411500,2411500,236,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,164950,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(227,'2023-11-13 17:58:21',643,0,0,0,2187500,0,2187500,2187500,201,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,142800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(228,'2023-11-19 19:24:59',644,0,0,0,1557000,0,1557000,1557000,144,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,38600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(229,'2023-11-26 18:30:07',645,0,0,0,1276500,0,1276500,1276500,157,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,21850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(230,'2023-12-10 18:13:01',646,0,0,0,2593500,0,2593500,2593500,275,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,81700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(231,'2023-12-23 20:28:30',647,0,0,0,699000,0,699000,699000,94,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(232,'2023-12-24 19:03:14',648,0,0,0,339000,0,339000,339000,45,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(233,'2023-12-26 19:40:13',649,0,0,0,2050500,0,2050500,2050500,195,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,5900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(234,'2023-12-27 19:41:15',650,0,0,0,718000,0,718000,718000,93,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,50200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(235,'2023-12-28 20:45:09',651,0,0,0,1073000,0,1073000,1073000,122,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,58500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(236,'2023-12-29 19:46:26',652,0,0,0,1745000,0,1745000,1745000,164,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,71150,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(237,'2023-12-30 19:55:07',653,0,0,0,1638000,0,1638000,1638000,164,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,95400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(238,'2023-12-31 18:26:51',654,0,0,0,1520500,0,1520500,1520500,182,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,44700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(239,'2024-01-01 18:54:19',655,0,0,0,1512500,0,1512500,1512500,231,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,41000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(240,'2024-01-02 18:50:13',656,0,0,0,1706000,0,1706000,1706000,170,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,33300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(241,'2024-01-03 20:55:04',657,0,0,0,4018000,0,4018000,4018000,432,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,253350,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(242,'2024-01-04 20:14:17',658,0,0,0,3480500,0,3480500,3480500,350,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,222050,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(243,'2024-01-05 20:29:00',659,0,0,0,3809000,0,3809000,3809000,381,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,275300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(244,'2024-01-06 20:13:35',660,0,0,0,2824500,0,2824500,2824500,291,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,189950,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(245,'2024-01-07 19:17:34',661,0,0,0,4357000,0,4357000,4357000,420,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,220600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(246,'2024-01-08 19:02:46',662,0,0,0,1954500,0,1954500,1954500,169,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,78550,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(247,'2024-01-09 18:24:14',663,0,0,0,597000,0,597000,597000,71,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,4300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(248,'2024-01-10 21:08:34',664,0,0,0,1166000,0,1166000,1166000,98,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,12300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(249,'2024-01-11 20:13:09',665,0,0,0,1184000,0,1184000,1184000,121,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(250,'2024-01-12 19:33:01',666,0,0,0,809000,0,809000,809000,86,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(251,'2024-01-13 20:39:41',667,0,0,0,1326000,0,1326000,1326000,127,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(252,'2024-01-14 20:37:16',668,0,0,0,2564000,0,2564000,2564000,236,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,48100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(253,'2024-01-18 19:17:46',669,0,0,0,768000,0,768000,768000,133,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(254,'2024-01-19 20:22:55',670,0,0,0,473000,0,473000,473000,40,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(255,'2024-01-20 19:09:18',671,0,0,0,428000,0,428000,428000,53,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(256,'2024-01-21 19:05:14',672,0,0,0,2635000,0,2635000,2635000,183,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,173300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(257,'2024-01-23 20:01:32',673,0,0,0,351000,0,351000,351000,31,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(258,'2024-01-24 18:13:32',674,0,0,0,180000,0,180000,180000,27,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(259,'2024-01-25 19:04:27',675,0,0,0,224000,0,224000,224000,16,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(260,'2024-01-26 19:33:01',676,0,0,0,109000,0,109000,109000,14,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(261,'2024-01-27 19:26:10',677,0,0,0,369000,0,369000,369000,41,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(262,'2024-01-28 19:47:51',678,0,0,0,509000,0,509000,509000,53,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,19900,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(263,'2024-02-03 19:26:22',679,0,0,0,1165500,0,1165500,1165500,133,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(264,'2024-02-10 19:44:01',680,0,0,0,1657000,0,1657000,1657000,177,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,32800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(265,'2024-02-11 18:53:41',681,0,0,0,1910500,0,1910500,1910500,171,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,124150,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(266,'2024-02-17 19:16:49',682,0,0,0,1336500,0,1336500,1336500,175,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(267,'2024-02-18 18:44:52',683,0,0,0,1901500,0,1901500,1901500,178,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,40700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(268,'2024-02-25 18:56:29',684,0,0,0,1272500,0,1272500,1272500,162,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,9800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(269,'2024-03-03 18:58:07',685,0,0,0,2161500,0,2161500,2161500,252,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,15550,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(270,'2024-03-05 19:58:49',686,0,0,0,747500,0,747500,747500,100,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(271,'2024-03-06 20:16:18',687,0,0,0,699000,0,699000,699000,60,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(272,'2024-03-11 19:22:38',688,0,0,0,1816500,0,1816500,1816500,263,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,68200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(273,'2024-03-16 20:42:15',689,0,0,0,924000,0,924000,924000,120,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(274,'2024-03-17 19:34:00',690,0,0,0,931000,0,931000,931000,95,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(275,'2024-03-24 21:04:01',691,0,0,0,3822500,0,3822500,3822500,337,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,314000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(276,'2024-03-25 18:01:54',692,0,0,0,1989500,0,1989500,1989500,169,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,87550,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(277,'2024-03-27 19:33:55',693,0,0,0,2538000,0,2538000,2538000,247,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,100000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(278,'2024-03-28 20:47:25',694,0,0,0,4369500,0,4369500,4369500,320,5,87000,2,0,0,0,0,0,0,0,0,0,1,0,0,0,192000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(279,'2024-03-29 20:19:23',695,0,0,0,4289000,0,4289000,4289000,376,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,208000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(280,'2024-03-30 20:03:22',696,0,0,0,2634000,0,2634000,2634000,248,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,134700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(281,'2024-03-31 18:27:07',697,0,0,0,475000,0,475000,475000,37,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,6300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'lafonda',0,0,0,0,0,0,0,0,0,0),(282,'2024-04-02 18:53:00',698,0,0,0,622000,0,622000,622000,55,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(283,'2024-04-07 18:55:53',699,0,0,0,1067500,0,1067500,1067500,72,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,35750,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(284,'2024-04-10 18:40:05',700,0,0,0,378000,0,378000,378000,35,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(285,'2024-04-14 18:59:59',701,0,0,0,1126000,0,1126000,1126000,104,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,38600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(286,'2024-04-21 19:01:52',702,0,0,0,1757000,0,1757000,1757000,217,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,45100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(287,'2024-04-28 18:58:43',703,0,0,0,1905000,0,1905000,1905000,180,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,27500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(288,'2024-05-05 19:30:53',704,0,0,0,2293000,0,2293000,2293000,182,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,53000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(289,'2024-05-12 19:18:11',705,0,0,0,2946500,0,2946500,2946500,263,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,74700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(290,'2024-05-13 18:46:49',706,0,0,0,1137500,0,1137500,1137500,119,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,73850,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(291,'2024-05-19 18:35:18',707,0,0,0,1536500,0,1536500,1536500,180,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,45250,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(292,'2024-05-26 18:46:31',708,0,0,0,842000,0,842000,842000,64,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,13500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(293,'2024-06-02 19:06:57',709,0,0,0,2067500,0,2067500,2067500,191,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,72200,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(294,'2024-06-03 18:41:51',710,0,0,0,403000,0,403000,403000,34,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(295,'2024-06-09 20:09:09',711,0,0,0,4359000,0,4359000,4359000,370,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,174800,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(296,'2024-06-10 21:10:16',712,0,0,0,961500,0,961500,961500,120,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(297,'2024-06-16 18:51:43',713,0,0,0,1164500,0,1164500,1164500,88,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,16600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(298,'2024-06-23 18:57:17',714,0,0,0,714000,0,714000,714000,56,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,6700,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(299,'2024-06-29 18:42:59',715,0,0,0,3027500,0,3027500,3027500,239,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,7000,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(300,'2024-06-30 19:21:52',716,0,0,0,1938000,0,1938000,1938000,138,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,61100,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(301,'2024-07-01 18:56:58',717,0,0,0,2151500,0,2151500,2151500,240,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,101550,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(302,'2024-07-07 18:35:55',718,0,0,0,1912500,0,1912500,1912500,215,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,54550,1912500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(303,'2024-07-14 16:40:49',719,0,0,0,1711000,0,1711000,1711000,210,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,65300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(304,'2024-07-20 19:07:27',720,0,0,0,2181000,0,2181000,2181000,182,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,11400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(305,'2024-07-21 18:26:45',721,0,0,0,2531000,0,2531000,2531000,234,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,87600,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(306,'2024-08-03 20:56:30',722,0,0,0,2542500,0,2542500,2542500,247,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(307,'2024-08-04 19:02:53',723,0,0,0,1050000,0,1050000,1050000,128,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,22400,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(308,'2024-08-11 19:08:15',724,0,0,0,3499000,0,3499000,3499000,336,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,78300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(309,'2024-08-18 20:16:47',725,0,0,0,7236500,0,7236500,7236500,550,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,221300,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(310,'2024-08-19 19:08:15',726,0,0,0,2932000,0,2932000,2932000,185,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,120500,0,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(311,'2024-08-25 19:44:33',727,0,0,0,3654500,0,3654500,3654500,317,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,70800,3654500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(312,'2024-09-01 19:46:06',728,0,0,0,2805500,0,2805500,2805500,236,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,36400,2805500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(313,'2024-09-04 18:52:44',729,0,0,0,677000,0,677000,677000,60,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,677000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(314,'2024-09-13 19:10:51',730,0,0,0,2684500,0,2684500,2684500,301,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,85250,2684500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(315,'2024-09-15 19:16:39',731,0,0,0,2271000,0,2271000,2271000,193,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,87400,2271000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(316,'2024-09-22 18:25:01',732,0,0,0,1377500,0,1377500,1377500,96,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,7600,1377500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(317,'2024-09-29 18:36:15',733,0,0,0,1396000,0,1396000,1396000,115,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,14900,1396000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(318,'2024-10-06 18:11:51',734,0,0,0,1789500,0,1789500,1789500,146,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,16300,1789500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(319,'2024-10-13 19:20:43',735,0,0,0,6850000,0,6850000,6850000,711,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,174000,6850000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(320,'2024-10-14 19:14:46',736,0,0,0,887500,0,887500,887500,151,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,16100,887500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(321,'2024-10-18 18:54:18',737,0,0,0,284000,0,284000,284000,18,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,8100,284000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(322,'2024-10-19 18:19:58',738,0,0,0,259000,0,259000,259000,49,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,14500,259000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(323,'2024-10-20 20:01:10',739,0,0,0,1434000,0,1434000,1434000,149,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,77800,1434000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(324,'2024-10-21 19:00:39',740,0,0,0,26000,0,26000,26000,9,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,26000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(325,'2024-10-22 18:41:14',741,0,0,0,113000,0,113000,113000,10,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,113000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(326,'2024-10-23 18:24:00',742,0,0,0,258000,0,258000,258000,39,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,258000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(327,'2024-10-26 17:38:50',743,0,0,0,140000,0,140000,140000,18,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,140000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(328,'2024-10-27 19:25:59',744,0,0,0,1507000,0,1507000,1507000,157,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,57700,1507000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(329,'2024-10-28 18:42:36',745,0,0,0,81000,0,81000,81000,8,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,81000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(330,'2024-10-29 20:48:27',746,0,0,0,517000,0,517000,517000,65,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,517000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(331,'2024-10-31 18:35:31',747,0,0,0,176000,0,176000,176000,25,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,176000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(332,'2024-11-02 18:39:18',748,0,0,0,458500,0,458500,458500,47,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,458500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(333,'2024-11-03 18:37:14',749,0,0,0,2283000,0,2283000,2283000,190,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,79500,2283000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(334,'2024-11-04 18:22:02',750,0,0,0,1076000,0,1076000,1076000,115,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,77500,1076000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(335,'2024-11-09 19:36:16',751,0,0,0,495000,0,495000,495000,66,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,495000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(336,'2024-11-10 19:06:08',752,0,0,0,2204000,0,2204000,2204000,251,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,56300,2204000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(337,'2024-11-11 18:45:26',753,0,0,0,729000,0,729000,729000,93,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,729000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(338,'2024-11-12 18:44:25',754,0,0,0,325000,0,325000,325000,36,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,325000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(339,'2024-11-17 18:42:21',755,0,0,0,864500,0,864500,864500,78,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,23300,864500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(340,'2024-11-22 18:21:17',756,0,0,0,604000,0,604000,604000,46,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,604000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(341,'2024-11-24 18:29:42',757,0,0,0,480000,0,480000,480000,51,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3000,480000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(342,'2024-12-01 18:31:30',758,0,0,0,1751000,0,1751000,1751000,156,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,49000,1751000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(343,'2024-12-08 18:18:14',759,0,0,0,991000,0,991000,991000,122,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10900,991000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(344,'2024-12-13 21:04:37',760,0,0,0,875000,0,875000,875000,64,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,875000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(345,'2024-12-14 19:02:26',761,0,0,0,404000,0,404000,404000,36,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,404000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(346,'2024-12-15 19:19:27',762,0,0,0,995000,0,995000,995000,107,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2700,995000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(347,'2024-12-21 19:19:15',763,0,0,0,1842000,0,1842000,1842000,157,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1842000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(348,'2024-12-22 18:52:54',764,0,0,0,763000,0,763000,763000,61,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,52100,763000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(349,'2024-12-23 18:39:39',765,0,0,0,764000,0,764000,764000,43,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,764000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(350,'2024-12-24 20:13:43',766,0,0,0,534000,0,534000,534000,27,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,534000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(351,'2024-12-25 18:46:15',767,0,0,0,1013000,0,1013000,1013000,85,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1013000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(352,'2024-12-26 19:51:29',768,0,0,0,543000,0,543000,543000,98,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,543000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(353,'2024-12-28 20:08:22',769,0,0,0,2318000,0,2318000,2318000,251,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,8600,2318000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(354,'2024-12-29 19:29:15',770,0,0,0,3476000,0,3476000,3476000,315,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,115300,3476000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(355,'2024-12-30 19:32:49',771,0,0,0,394000,0,394000,394000,46,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,394000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(356,'2024-12-31 19:56:14',772,0,0,0,1330000,0,1330000,1330000,157,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,5200,1330000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(357,'2025-01-01 19:48:27',773,0,0,0,2002000,0,2002000,2002000,157,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,2002000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(358,'2025-01-02 19:58:30',774,0,0,0,3960500,0,3960500,3960500,351,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,14900,3960500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(359,'2025-01-03 20:01:59',775,0,0,0,4997500,0,4997500,4997500,463,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,291000,4997500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(360,'2025-01-04 19:26:57',776,0,0,0,4206500,0,4206500,4206500,417,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,237700,4206500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(361,'2025-01-05 20:33:21',777,0,0,0,7281000,0,7281000,7281000,728,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,312000,7281000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(362,'2025-01-06 19:30:02',778,0,0,0,3990500,0,3990500,3990500,360,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,167450,3990500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(363,'2025-01-07 19:25:57',779,0,0,0,1976500,0,1976500,1976500,142,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,77850,1976500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(364,'2025-01-08 19:27:06',780,0,0,0,1579500,0,1579500,1579500,175,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,61950,1579500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(365,'2025-01-09 19:08:44',781,0,0,0,1565000,0,1565000,1565000,136,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,84200,1565000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(366,'2025-01-10 19:21:11',782,0,0,0,1390500,0,1390500,1390500,161,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,89850,1390500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(367,'2025-01-11 19:11:42',783,0,0,0,1151000,0,1151000,1151000,134,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,50700,1151000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(368,'2025-01-12 19:08:31',784,0,0,0,2604000,0,2604000,2604000,212,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,26700,2604000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(369,'2025-01-13 20:09:02',785,0,0,0,1272000,0,1272000,1272000,103,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10000,1272000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(370,'2025-01-14 18:35:20',786,0,0,0,158000,0,158000,158000,19,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,158000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(371,'2025-01-18 18:47:56',787,0,0,0,1290500,0,1290500,1290500,144,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1290500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(372,'2025-01-19 19:21:29',788,0,0,0,2411000,0,2411000,2411000,198,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,92300,2411000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(373,'2025-01-21 18:46:56',789,0,0,0,308000,0,308000,308000,22,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,308000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(374,'2025-01-23 18:47:37',790,0,0,0,350000,0,350000,350000,62,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,350000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(375,'2025-01-24 19:57:00',791,0,0,0,60500,0,60500,60500,5,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,60500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(376,'2025-01-25 19:33:06',792,0,0,0,593500,0,593500,593500,72,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,593500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(377,'2025-01-26 19:27:36',793,0,0,0,1287000,0,1287000,1287000,124,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10200,1287000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(378,'2025-01-27 17:55:17',794,0,0,0,161000,0,161000,161000,11,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,161000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(379,'2025-01-31 18:52:46',795,0,0,0,644000,0,644000,644000,54,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,644000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(380,'2025-02-01 19:19:18',796,0,0,0,204000,0,204000,204000,29,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,204000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(381,'2025-02-02 20:03:16',797,0,0,0,2357500,0,2357500,2357500,192,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,88900,2357500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(382,'2025-02-05 19:50:04',798,0,0,0,210000,0,210000,210000,22,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,210000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(383,'2025-02-06 18:34:21',799,0,0,0,226000,0,226000,226000,30,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,226000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(384,'2025-02-08 18:43:27',800,0,0,0,832000,0,832000,832000,111,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,9700,832000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(385,'2025-02-09 19:22:46',801,0,0,0,448000,0,448000,448000,58,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,39700,448000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(386,'2025-02-11 18:46:12',802,0,0,0,227000,0,227000,227000,27,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,227000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(387,'2025-02-12 19:10:36',803,0,0,0,252000,0,252000,252000,16,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,252000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(388,'2025-02-13 18:31:31',804,0,0,0,544000,0,544000,544000,39,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,544000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(389,'2025-02-14 18:32:48',805,0,0,0,316000,0,316000,316000,43,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,316000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(390,'2025-02-15 19:03:37',806,0,0,0,338000,0,338000,338000,26,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,338000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(391,'2025-02-16 19:11:43',807,0,0,0,1180000,0,1180000,1180000,106,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,56100,1180000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(392,'2025-02-23 18:58:33',808,0,0,0,2416000,0,2416000,2416000,263,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,92500,2416000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(393,'2025-02-28 18:48:55',809,0,0,0,289000,0,289000,289000,27,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,289000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(394,'2025-03-02 18:50:45',810,0,0,0,668000,0,668000,668000,59,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,23900,668000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(395,'2025-03-08 19:55:55',811,0,0,0,284000,0,284000,284000,20,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,284000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(396,'2025-03-09 19:22:19',812,0,0,0,1365000,0,1365000,1365000,95,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,59300,1365000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(397,'2025-03-16 19:39:01',813,0,0,0,957000,0,957000,957000,118,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,21850,957000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(398,'2025-03-22 21:21:09',814,0,0,0,1649000,0,1649000,1649000,166,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,2700,1649000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(399,'2025-03-23 20:32:50',815,0,0,0,3995500,0,3995500,3995500,308,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,87050,3995500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(400,'2025-03-24 19:19:23',816,0,0,0,2239000,0,2239000,2239000,164,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,71600,2239000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(401,'2025-03-29 19:27:02',817,0,0,0,894500,0,894500,894500,105,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,894500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(402,'2025-03-30 18:55:27',818,0,0,0,1060500,0,1060500,1060500,88,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1060500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(403,'2025-04-05 19:45:04',819,0,0,0,544000,0,544000,544000,60,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,544000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(404,'2025-04-06 18:52:58',820,0,0,0,1259500,0,1259500,1259500,72,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,69800,1259500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(405,'2025-04-12 19:00:57',821,0,0,0,1662500,0,1662500,1662500,234,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1662500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(406,'2025-04-13 19:25:13',822,0,0,0,2187000,0,2187000,2187000,149,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,82700,2187000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(407,'2025-04-14 20:47:37',823,0,0,0,804000,0,804000,804000,48,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,804000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(408,'2025-04-15 20:32:13',824,0,0,0,289000,0,289000,289000,40,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,289000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(409,'2025-04-16 22:03:19',825,0,0,0,1273000,0,1273000,1273000,143,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1273000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(410,'2025-04-17 20:17:47',826,0,0,0,4398500,0,4398500,4398500,362,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,218000,4398500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(411,'2025-04-18 20:11:05',827,0,0,0,6801000,0,6801000,6801000,506,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,339300,6801000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(412,'2025-04-19 20:46:38',828,0,0,0,3005000,0,3005000,3005000,273,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,88100,3005000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(413,'2025-04-20 18:25:19',829,0,0,0,701000,0,701000,701000,42,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,33800,701000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(414,'2025-04-21 18:38:02',830,0,0,0,552000,0,552000,552000,60,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,552000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(415,'2025-04-26 19:35:15',831,0,0,0,799000,0,799000,799000,96,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,799000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(416,'2025-04-27 19:26:56',832,0,0,0,1610500,0,1610500,1610500,147,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1610500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(417,'2025-04-30 19:30:14',833,0,0,0,137000,0,137000,137000,11,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,137000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(418,'2025-05-01 18:48:21',834,0,0,0,132500,0,132500,132500,29,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,132500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(419,'2025-05-17 21:33:58',835,0,0,0,4402500,0,4402500,4402500,448,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,63500,4402500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(420,'2025-05-18 18:42:16',836,0,0,0,2058000,0,2058000,2058000,131,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,2058000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(421,'2025-05-25 18:59:05',837,0,0,0,1501000,0,1501000,1501000,173,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1501000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(422,'2025-06-01 18:54:18',838,0,0,0,2410500,0,2410500,2410500,226,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,64000,2410500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(423,'2025-06-02 19:27:42',839,0,0,0,693000,0,693000,693000,50,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,18000,693000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(424,'2025-06-08 18:57:19',840,0,0,0,1264000,0,1264000,1264000,86,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1264000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(425,'2025-06-15 19:15:00',841,0,0,0,2780000,0,2780000,2780000,234,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,33000,2780000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(426,'2025-06-20 20:51:17',842,0,0,0,823000,0,823000,823000,78,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,823000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(427,'2025-06-21 20:16:37',843,0,0,0,1029000,0,1029000,1029000,112,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1029000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(428,'2025-06-22 19:16:59',844,0,0,0,2761000,0,2761000,2761000,203,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,66700,2761000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(429,'2025-06-23 20:08:48',845,0,0,0,950000,0,950000,950000,101,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,25000,950000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(430,'2025-06-27 19:46:49',846,0,0,0,1937000,0,1937000,1937000,161,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1937000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(431,'2025-06-28 20:21:25',847,0,0,0,1401000,0,1401000,1401000,127,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1401000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(432,'2025-06-29 20:22:10',848,0,0,0,4842500,0,4842500,4842500,421,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,78000,4842500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(433,'2025-06-30 20:29:32',849,0,0,0,3133000,0,3133000,3133000,222,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,71800,3133000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(434,'2025-07-01 19:56:47',850,0,0,0,704500,0,704500,704500,115,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,11000,704500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(435,'2025-07-02 18:39:03',851,0,0,0,510000,0,510000,510000,30,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,510000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(436,'2025-07-05 19:18:30',852,0,0,0,988000,0,988000,988000,146,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,988000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(437,'2025-07-06 19:40:38',853,0,0,0,3253000,0,3253000,3253000,210,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,104400,3253000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(438,'2025-07-12 19:31:34',854,0,0,0,850000,0,850000,850000,90,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3300,850000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(439,'2025-07-13 18:25:24',855,0,0,0,2226000,0,2226000,2226000,168,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,21200,2226000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(440,'2025-07-19 20:32:13',856,0,0,0,1937000,0,1937000,1937000,197,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1937000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(441,'2025-07-20 19:25:30',857,0,0,0,2247000,0,2247000,2247000,149,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,54800,2247000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(442,'2025-07-22 18:12:52',858,0,0,0,665000,0,665000,665000,54,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,665000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(443,'2025-07-26 19:42:13',859,0,0,0,777000,0,777000,777000,87,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,777000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(444,'2025-07-27 18:50:46',860,0,0,0,2873500,0,2873500,2873500,251,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,111550,2873500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(445,'2025-07-30 18:55:14',861,0,0,0,486000,0,486000,486000,45,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,486000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(446,'2025-07-31 17:37:12',862,0,0,0,309500,0,309500,309500,56,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,309500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(447,'2025-08-02 19:12:54',863,0,0,0,815500,0,815500,815500,108,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,815500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(448,'2025-08-03 19:39:50',864,0,0,0,1825500,0,1825500,1825500,202,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1825500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(449,'2025-08-04 19:06:07',865,0,0,0,626000,0,626000,626000,66,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,626000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(450,'2025-08-05 20:16:26',866,0,0,0,1223000,0,1223000,1223000,106,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1223000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(451,'2025-08-07 19:04:06',867,0,0,0,1384500,0,1384500,1384500,141,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1384500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(452,'2025-08-09 20:04:58',868,0,0,0,1164000,0,1164000,1164000,151,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1164000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(453,'2025-08-10 19:53:04',869,0,0,0,2136500,0,2136500,2136500,213,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,17800,2136500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(454,'2025-08-12 19:11:11',870,0,0,0,363000,0,363000,363000,41,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,363000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(455,'2025-08-14 17:31:44',871,0,0,0,665000,0,665000,665000,65,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,665000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(456,'2025-08-16 18:54:32',872,0,0,0,262000,0,262000,262000,41,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,262000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(457,'2025-08-17 20:18:00',873,0,0,0,3798000,0,3798000,3798000,408,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,137600,3798000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(458,'2025-08-18 19:00:16',874,0,0,0,2502000,0,2502000,2502000,273,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,100400,2502000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(459,'2025-08-19 18:40:43',875,0,0,0,337000,0,337000,337000,32,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,337000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(460,'2025-08-21 19:27:04',876,0,0,0,1052500,0,1052500,1052500,138,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1052500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(461,'2025-08-23 19:55:29',877,0,0,0,483000,0,483000,483000,59,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,483000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(462,'2025-08-24 19:06:56',878,0,0,0,1334000,0,1334000,1334000,118,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,16400,1334000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(463,'2025-08-27 18:58:06',879,0,0,0,316000,0,316000,316000,31,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,316000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(464,'2025-08-30 19:34:52',880,0,0,0,928500,0,928500,928500,144,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,928500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(465,'2025-08-31 18:48:40',881,0,0,0,1230000,0,1230000,1230000,115,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,61300,1230000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(466,'2025-09-07 19:22:09',882,0,0,0,1715000,0,1715000,1715000,160,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1715000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(467,'2025-09-13 19:26:13',883,0,0,0,953500,0,953500,953500,118,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,953500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(468,'2025-09-14 19:42:41',884,0,0,0,2539000,0,2539000,2539000,261,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,97600,2539000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(469,'2025-09-20 20:03:36',885,0,0,0,1572000,0,1572000,1572000,170,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1572000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(470,'2025-09-21 18:42:53',886,0,0,0,1785500,0,1785500,1785500,154,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1785500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(471,'2025-09-27 19:33:54',887,0,0,0,591000,0,591000,591000,79,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,591000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(472,'2025-09-28 19:23:48',888,0,0,0,2059000,0,2059000,2059000,139,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,90300,2059000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(473,'2025-10-05 18:54:05',889,0,0,0,1151000,0,1151000,1151000,144,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,33400,1151000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(474,'2025-10-08 18:02:21',890,0,0,0,757500,0,757500,757500,120,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,3700,757500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(475,'2025-10-10 18:06:32',891,0,0,0,427000,0,427000,427000,47,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,427000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(476,'2025-10-11 19:27:24',892,0,0,0,1125500,0,1125500,1125500,101,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10400,1125500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(477,'2025-10-12 19:14:37',893,0,0,0,2570000,0,2570000,2570000,201,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,92000,2570000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(478,'2025-10-13 18:40:24',894,0,0,0,591500,0,591500,591500,57,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,5650,591500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(479,'2025-10-14 19:01:47',895,0,0,0,162000,0,162000,162000,19,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,162000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(480,'2025-10-19 18:37:38',896,0,0,0,2240000,0,2240000,2240000,201,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,17000,2240000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(481,'2025-10-25 19:37:38',897,0,0,0,422500,0,422500,422500,51,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,422500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(482,'2025-10-26 18:59:25',898,0,0,0,1059500,0,1059500,1059500,78,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,46350,1059500,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(483,'2025-11-02 19:15:50',899,0,0,0,1882000,0,1882000,1882000,184,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,57000,1882000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(484,'2025-11-03 19:11:53',900,0,0,0,615000,0,615000,615000,63,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,10800,615000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(485,'2025-11-04 18:24:02',901,0,0,0,64000,0,64000,64000,6,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,64000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(486,'2025-11-09 19:07:12',902,0,0,0,793000,0,793000,793000,119,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,12100,793000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(487,'2025-11-12 18:18:10',903,0,0,0,360000,0,360000,360000,14,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,360000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(488,'2025-11-14 18:41:33',904,0,0,0,650000,0,650000,650000,60,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,650000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(489,'2025-11-15 19:59:03',905,0,0,0,606000,0,606000,606000,116,7,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,606000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(490,'2025-11-16 19:17:00',906,0,0,0,1343000,0,1343000,1343000,115,4,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,72600,1343000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(491,'2025-11-17 19:45:43',907,0,0,0,986000,0,986000,986000,115,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,42900,986000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(492,'2025-11-22 19:38:29',908,0,0,0,858000,0,858000,858000,109,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,858000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(493,'2025-11-23 18:43:17',909,0,0,0,443000,0,443000,443000,50,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,36300,443000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0),(494,'2025-11-27 20:04:28',910,0,0,0,478000,0,478000,478000,53,5,0,2,0,0,0,0,0,0,0,0,0,1,0,0,0,0,478000,0,0,0,0,0,0,0,0,0,NULL,0,0,'KALDI',0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `zonas`
--

CREATE TABLE `zonas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `zona` varchar(25) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `orden` int DEFAULT '0',
  `oculto` int DEFAULT '0',
  `COD_SATELITEZ` varchar(25) DEFAULT 'SELECCIONE',
  `pv` varchar(25) DEFAULT 'lafonda',
  `idusuario` int DEFAULT '0',
  `eshotel` int DEFAULT '0',
  `activo` tinyint unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `zonas`
--

INSERT INTO `zonas` (`id`, `zona`, `cc`, `orden`, `oculto`, `COD_SATELITEZ`, `pv`, `idusuario`, `eshotel`, `activo`) VALUES (1,'SALON',2,1,0,'SELECCIONE','lafonda',0,0,1),(2,'BAR',2,2,0,'SELECCIONE','lafonda',0,0,1),(3,'CORREDOR',2,3,0,'SELECCIONE','lafonda',0,0,1),(4,'ADICIONAL',2,4,0,'SELECCIONE','lafonda',0,0,1),(5,'',2,0,0,'SELECCIONE','lafonda',0,0,1);

--
-- Table structure for table `zonasclientes`
--

CREATE TABLE `zonasclientes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codigozona` varchar(10) DEFAULT NULL,
  `nombrezona` varchar(25) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `zonasclientes`
--


--
-- Table structure for table `zonashabitaciones`
--

CREATE TABLE `zonashabitaciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `zona` varchar(25) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `orden` int DEFAULT '0',
  `oculto` int DEFAULT '0',
  `COD_SATELITEZ` varchar(25) DEFAULT 'SELECCIONE',
  `pv` varchar(25) DEFAULT 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `zonashabitaciones`
--


--
-- Dumping routines for database 'lafonda'
--
/*!50003 DROP FUNCTION IF EXISTS `biscaridfactura` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `biscaridfactura`(`consecutivoin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select id from facturas where consecutivo=consecutivoin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `biscarnombrecc` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `biscarnombrecc`(`ccin` INT(11)) RETURNS varchar(110) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN
DECLARE P VARCHAR(110);
SET P=(select centrodecostos from centrosdecostos where id=ccin);
RETURN ifnull(P,'DESCONOCIDO');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `bucarnombredeltercero` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `bucarnombredeltercero`(`idin` INT(11)) RETURNS varchar(110) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN DECLARE P varchar(110); SET P=(select if(tipodepersona=2,concat(ifnull(primernombre,''),' ',ifnull(segundonombre,''),' ',ifnull(primerapellido,''),' ',ifnull(segundoapellido,'')),concat(ifnull(razonsocial,''),' ',ifnull(nombrecomercial,''))) from clientes where id=idin); RETURN ifnull(P,'DESCONOCIDO'); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscadescripcionporrefcruzada` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `buscadescripcionporrefcruzada`(`refin` INT(11)) RETURNS varchar(50) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN declare a varchar(50); set a=(select descripcion from articulos where referenciacruzada=refin); return ifnull(a,'ERROR EN REFERENCIA CRUZADA'); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarabonos` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `buscarabonos`(`idfacturain` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P INT(11); SET P=(select sum(valor) from abonos where idfactura=idfacturain and nc=0); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarabonosencompras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarabonosencompras`(`idfacturain` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P double; SET P=(select sum(valor) from abonoscompras where idmayorcompras=idfacturain); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarabonosenseparados` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `buscarabonosenseparados`(`idfacturain` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P double; SET P=(select sum(valor) from abonosseparados where idmayorseparados=idfacturain and nc=0 and idgasto=0); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarajustesproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarajustesproducto`(`idin` INT(11), `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from ajustesdeinventario where idarticulo=idin and cast(fechacreacion as date) BETWEEN fecha1 and fecha2);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarbajasproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarbajasproducto`(`idin` INT(11), `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from bajas where idarticulo=idin and cast(fecha as date)  BETWEEN fecha1 and fecha2);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarbarriotercero` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarbarriotercero`(`idin` INT(11)) RETURNS varchar(110) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE P varchar(110);
SET P=(select barrio from clientes where id=idin);
RETURN ifnull(P,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcajaenfactura` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcajaenfactura`(`consecutivoin` INT(11), `ccin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P INT(11); SET P=(select idcaja from facturas where consecutivo=consecutivoin and cc=ccin limit 1); RETURN ifnull(P,1); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcantidaddeldia` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcantidaddeldia`(`idarticuloin` INT(11), `fechain` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P DOUBLE;
SET P=(select AVG(cantidad) from inventarioinicial where idarticulo=idarticuloin and cast(fechacracion as date)=fechain);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcantidadennotasdebito` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcantidadennotasdebito`(`idarticuloin` INT(11), `idmayorin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(11);
set P=(select sum(cantidad) from lineasnotasdebito where idmayor=idmayorin and idarticulo=idarticuloin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarccdelarticulo` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarccdelarticulo`(`idin` INT(4)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(4);
SET P=(select cc from articulos where id=idin);
RETURN ifnull(P,-1);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarceduladeltercero` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarceduladeltercero`(`idin` INT(11)) RETURNS varchar(110) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE P varchar(20);
SET P=(select ifnull(cedula,'') from clientes where id=idin);
RETURN ifnull(P,'DESCONOCIDO');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarclientedelamesa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarclientedelamesa`(`idmesain` INT(11)) RETURNS varchar(50) CHARSET latin1
BEGIN declare rs varchar(50); set rs=(select idcliente from ventasauxiliar where idmesa=idmesain limit 1); set rs=ifnull(rs,1); if rs>1 THEN set rs=bucarnombredeltercero(rs); ELSE set rs=''; end if; if rs='CLIENTES VARIOS' then set rs='';end if; return rs; end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcodigoformapago` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcodigoformapago`(`forma` VARCHAR(100)) RETURNS int
begin 
declare rs int(11);
set rs=(select orden from mediosdepago where mediodepago=forma);
return ifnull(rs,-1);
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcodsituacion` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcodsituacion`(`idarticuloin` INT(11)) RETURNS varchar(100) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
declare rs varchar(150);
set rs=(select situacioncocina from articulos where id=idarticuloin);
return ifnull(rs,'Situacion indefinida');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcomprasporproductomesyano` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcomprasporproductomesyano`(`idin` INT(11), `mesin` INT(2), `anoin` INT(4)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from compras where idarticulo=idin and
       month(fecha)=mesin and year(fecha)=anoin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcomprasproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcomprasproducto`(`idin` INT(11), `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad*factor) from compras where idarticulo=idin and cast(fecha as date)  BETWEEN fecha1 and fecha2);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarconsumosproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarconsumosproducto`(`idin` INT(11), `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(SELECT sum(movimientosdeinventario.cantidad)  from movimientosdeinventario where 
        idarticulo=idin and  cast(fechacreacion as date) between '' and '' 
         and (ventana='VENTAS' or ventana='CORTESIAS' OR ventana='DEVOLUCIONES'));
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarconteoproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarconteoproducto`(`idin` INT(11), `fecha1` DATE) RETURNS varchar(11) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN
DECLARE P VARCHAR(11);
SET P=(select cantidad from inventarioinicial,mayoresinventarioinicial where idarticulo=idin and fecha=fecha1 and idmayor=mayoresinventarioinicial.id);
RETURN ifnull(P,'NA');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcostomedio` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcostomedio`(`idarticulo` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P double; SET P=(select costomedio from articulos where id=idarticulo); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcreditosdeldia` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcreditosdeldia`(`ccin` INT(4), `fechain` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(
    select sum(facturas.total) from facturas 
       where cc=ccin and cast(fecha as date)=fechain and documento='C');
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcuentacompras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcuentacompras`(`idin` INT(11)) RETURNS varchar(25) CHARSET latin1
    NO SQL
    SQL SECURITY INVOKER
BEGIN
declare a varchar(25);
set a=(select articulos.cuentacompras from articulos where id=idin);
return ifnull(a,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcuentacosto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcuentacosto`(`idin` INT(11)) RETURNS varchar(25) CHARSET latin1
    NO SQL
    SQL SECURITY INVOKER
BEGIN
declare a varchar(25);
set a=(select articulos.cuentacosto from articulos where id=idin);
return ifnull(a,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarcuentaventa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarcuentaventa`(`idin` INT(11)) RETURNS varchar(25) CHARSET latin1
    NO SQL
    SQL SECURITY INVOKER
BEGIN
declare a varchar(25);
set a=(select articulos.cuentaventa from articulos where id=idin);
return ifnull(a,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscardescripcion` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`localhost` FUNCTION `buscardescripcion`(`idin` INT(11)) RETURNS varchar(150) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN
DECLARE P varchar(150);
SET P=(select ifnull(descripcion,'') from articulos where id=idin );
RETURN ifnull(P,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscardescuendoespecial` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscardescuendoespecial`(`lineain` VARCHAR(50), `idgrupoin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN declare r double; set r=(select porcentaje from descuentosporgrupo where linea=lineain and idgrupo=idgrupoin); return ifnull(r,0); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscardescuentoporfecha` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscardescuentoporfecha`(`idarticuloin` INT(11), `horain` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
declare rs int(11);
set rs=(select porcentaje from porcentajesdescuentoarticulos,fechasdescuentos where fechasdescuentos.id=porcentajesdescuentoarticulos.idfecha and idarticulo=idarticuloin and fechasdescuentos.fecha=horain limit 1);
return ifnull(rs,0);
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscardiadelasemana` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscardiadelasemana`(`fechain` DATETIME) RETURNS varchar(25) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN
declare a varchar(25);declare b int(1);
set a='';

set b=(select DAYOFWEEK(fechain));
if b=2 then set a='Lunes'; 
elseif b=3 then set a='Martes' ;
elseif b=4 then set a='Miércoles'; 
elseif b=5 then set a='Jueves' ;
elseif b=6 then set a='Viernes';
elseif b=7 then set a='Sábado';
elseif b=1 then set a='Domingo'; 
end if;
return a;
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscardirecciontercero` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscardirecciontercero`(`idin` INT(11)) RETURNS varchar(110) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE P varchar(110);
SET P=(select direccion from clientes where id=idin);
RETURN ifnull(P,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarfactor` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `buscarfactor`(`idin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN declare rs int(5); set rs=(select factor from unidadesdemedida where id=idin); return ifnull(rs,1); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarfechadefactura` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarfechadefactura`(`consecutivoin` INT(11)) RETURNS date
    SQL SECURITY INVOKER
BEGIN
DECLARE P DATE;
SET P=(select cast(fecha as date) from ventas where consecutivo=consecutivoin LIMIT 1);
RETURN ifnull(P,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarfisicoproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarfisicoproducto`(`idin` INT(11), `fecha1` DATE) RETURNS varchar(11) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN
DECLARE P VARCHAR(11);
SET P=(select fisico from inventarioinicial,mayoresinventarioinicial where idarticulo=idin and fecha=fecha1 and idmayor=mayoresinventarioinicial.id);
RETURN ifnull(P,'NA');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscaridclientedelamesa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscaridclientedelamesa`(`idmesain` INT(11), `id99` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE rs int(1); set rs=(select idcliente from ventasauxiliar where idmesa=idmesain limit 1);
return ifnull(rs,id99); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscaridmeseroactual` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscaridmeseroactual`(`idmesain` INT(11), `id99` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE rs int(11); set rs=(select idvendedor  from ventasauxiliar where idmesa=idmesain limit 1); return ifnull(rs,id99); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscaridporrefcruzada` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `buscaridporrefcruzada`(`refin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN declare a int(11); set a=(select id from articulos where referenciacruzada=refin); return ifnull(a,0); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscaridseccion` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscaridseccion`(`seccionin` VARCHAR(50)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P int(11); SET P=(select ifnull(id,0) from secciones where seccion=seccionin); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscaridunicodecliente` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscaridunicodecliente`(`nombrein` VARCHAR(100)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select id from clientes where primernombre=nombrein);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscaridunidad` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscaridunidad`(`unidadin` VARCHAR(50), `ccin` INT(1)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P int(11); SET P=(select ifnull(id,1) from unidadesdemedida where unidaddemedida=unidadin and cc=ccin); RETURN ifnull(P,1); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarimpresora` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarimpresora`(`situacionin` VARCHAR(100)) RETURNS varchar(105) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
declare rs varchar(150);
set rs=(select nombreimpresora from situacionesdecocina where situacioncocina=situacionin);
return ifnull(rs,'Situacion indefinida');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarinventariodeinsumos` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarinventariodeinsumos`(`idarticuloin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE q int(11);
SET q=(select tienecomposicion from articulos where id=idarticuloin);
if(q=0) THEN  
set q=(select cantidad from articulos where id=idarticuloin);
ELSE 
SET q=(select min(cantidad) from articulos where id in(select idinsumo from componentesarticulos where idarticulo=idarticuloin));
END IF;
RETURN ifnull(q,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarlineadelarticulo` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarlineadelarticulo`(`idarticuloin` INT(11)) RETURNS varchar(100) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN DECLARE rs varchar(100); 
set rs=(select linea  from articulos where id=idarticuloin ); return ifnull(rs,''); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarmediodepago` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`localhost` FUNCTION `buscarmediodepago`(`idin` INT) RETURNS varchar(15) CHARSET latin1
    NO SQL
BEGIN
declare a varchar(15);
declare b int(1);
set b=(select count(id) from registrosmediosdepago where idfactura=idin);
       if b>1 then 
       set a='VARIOS';
       ELSE
       set a=(select mediodepago from registrosmediosdepago where idfactura=idin);
       end if;
       return a;
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnombrecc` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnombrecc`(`ccin` INT(11)) RETURNS varchar(110) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN
DECLARE P VARCHAR(110);
SET P=(select centrodecostos from centrosdecostos where id=ccin);
RETURN ifnull(P,'DESCONOCIDO');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnombreclientedelamesa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnombreclientedelamesa`(`idmesain` INT(11)) RETURNS varchar(100) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE rs varchar(100);
set rs=(select bucarnombredeltercero(idcliente) from ventasauxiliar where idmesa=idmesain limit 1);
return ifnull(rs,'');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnombredelamesa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnombredelamesa`(`idin` INT(5)) RETURNS varchar(50) CHARSET latin1
    NO SQL
BEGIN
declare a varchar(50);
set a=(select nombre from mesas where id=idin);
return ifnull(a,' '); 
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnombredelamesadividida` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnombredelamesadividida`(`idmesain` INT(11)) RETURNS varchar(25) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
declare a varchar(25);
set a=(select mesas.nombre from mesas, ventasauxiliar where ventasauxiliar.idmesarelacionada=mesas.id and ventasauxiliar.idmesa=idmesain limit 1);
RETURN ifnull(a,'');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnombredelarticulo` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnombredelarticulo`(`idin` INT(11)) RETURNS varchar(400) CHARSET utf8mb3
    SQL SECURITY INVOKER
BEGIN DECLARE P varchar(400); SET P=(select descripcion from articulos where id=idin); RETURN ifnull(P,''); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnotassencompras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnotassencompras`(`idmayorin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P int(11); SET P=(select sum(valortotal) from notasdebito where idmayorescompras=idmayorin); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnumlinea` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnumlinea`(`identif` VARCHAR(50), `esmodifin` INT(1)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(2);
if  esmodifin=0 then 
SET P=(select 1+max(numlinea) from ventasauxiliar where idmesa=identif and esmodif=0);
else 
SET P=(select max(numlinea) from ventasauxiliar where idmesa=identif and esmodif=0);
end if;
RETURN ifnull(P,1);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnumlineaporcliente` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnumlineaporcliente`(`idclientein` VARCHAR(50), `esmodifin` INT(1)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(2);
if  esmodifin=0 then 
SET P=(select 1+max(numlinea) from ventasauxiliar where idcliente=idclientein);
else 
SET P=(select max(numlinea) from ventasauxiliar where idcliente=idclientein and esmodif=0);
end if;
RETURN ifnull(P,1);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarnumlineatomapedidos` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarnumlineatomapedidos`(`identif` VARCHAR(50), `esmodifin` INT(1)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(2);
if  esmodifin=0 then 
SET P=(select 1+max(numlinea) from ventasauxiliar where identificador=identif and esmodif=0);
else 
SET P=(select max(numlinea) from ventasauxiliar where identificador=identif and esmodif=0);
end if;
RETURN ifnull(P,1);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarordendia` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarordendia`(`a` VARCHAR(10)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
declare b int(1);
set b=0;


if a='Lunes' then set b=1; 
elseif  a='Martes'  then set b=2;
elseif  a='Miércoles' then set b=3;
elseif   a='Jueves'  then set b=4;
elseif  a='Viernes' then set b=5;
elseif  a='Sábado' then set b=6;
elseif   a='Domingo' then set b=7;
end if;
return b;
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarporcentaje` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarporcentaje`(`ccin` INT(11), `idarticuloin` INT(11), `idclientein` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
if ccin=9 then return 15; end if;
SET P=(select preciosespeciales.porcentaje from preciosespeciales,articulos where idcliente=idclientein and articulos.id=idarticuloin and articulos.linea=preciosespeciales.linea);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarporcentajeporgrupo` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarporcentajeporgrupo`(`ccin` INT(4), `idclientein` INT(11), `idarticuloin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P INT(11); SET P=(select descuentosporgrupo.porcentaje from descuentosporgrupo,articulos,clientes,gruposdepersonas where clientes.id=idclientein and articulos.id=idarticuloin and articulos.linea=descuentosporgrupo.linea and clientes.idgrupo=gruposdepersonas.id and descuentosporgrupo.idgrupo=gruposdepersonas.id); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarpreciodeventa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarpreciodeventa`(`idin` INT) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select preciodeventa from paraventas where id=idin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarprecioiva` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarprecioiva`(`numlineain` INT(11), `idfacturain` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
declare rs double;
set rs=(select sum(valortotal) from ventas where idfactura=idfacturain and numlinea=numlineain );
return ifnull(rs,0);
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarpreciomaximo` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarpreciomaximo`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P DOUBLE;
SET P=(select MAX(valorgramo) from compras where idarticulo=idin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarpreciominimo` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarpreciominimo`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P DOUBLE;
    SET P=(select MIN(valorgramo) from compras where idarticulo=idin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarpreciopromedio` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarpreciopromedio`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select AVG(valorgramo) from compras where idarticulo=idin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarrecibe` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarrecibe`(`idin` INT(11)) RETURNS varchar(200) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE P VARCHAR(200);
SET P=(select recibe from paraventas where id=idin);
RETURN ifnull(P,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarreferencia` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarreferencia`(`idarticuloin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P INT(11); SET P=(select referencia from articulos where id=idarticuloin ); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelafactura` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`vps-435806.controlweb.co` FUNCTION `buscarsaldodelafactura`(`idfacturain` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P INT(11); DECLARE aabonado INT(11); declare doc varchar(1); set doc=(select documento from facturas where id=idfacturain); if(doc='V') then RETURN 0; ELSE set aabonado=(select abonado from facturas where id=idfacturain); if aabonado>0 then set P= 0; else SET P=(select total  -retencion+servicio -buscarabonos(idfacturain) -valornc from facturas where id=idfacturain); end if; RETURN ifnull(P,0); END IF; END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelamayor` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`162.240.7.104` FUNCTION `buscarsaldodelamayor`(`idmayorin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P double; declare notas int(11); DECLARE aabonado double; declare doc varchar(7); set notas=buscarnotassencompras(idmayorin); set doc=(select documento from mayorescompras where id=idmayorin); if(doc='CONTADO') then RETURN 0; ELSE SET P=(select base+iva-descuento - otrosdescuentos -buscarabonosencompras(idmayorin) - descuentocomercial from mayorescompras where id=idmayorin); SET P=P-notas; RETURN ifnull(P,0); END IF; END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelamayorseparados` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `buscarsaldodelamayorseparados`(`idmayorin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P double; DECLARE aabonado double; SET P=(select total -buscarabonosenseparados(idmayorin) from mayoresseparados where id=idmayorin); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelcliente` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`localhost` FUNCTION `buscarsaldodelcliente`(`idclientein` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE P FLOAT(11); DECLARE Q FLOAT(11); DECLARE S FLOAT(11); SET P=(select sum(saldo) from facturas where idcliente=idclientein and documento='C' and abonado=0); set P=ifnull(P,0); set Q=(select sum(saldo) from mayoresseparados where idcliente=idclientein and abonado=0); set Q=ifnull(Q,0); set S=(select sum(saldo) from prestamos where idcliente=idclientein); set S=ifnull(S,0); RETURN ROUND(p+q+S,2); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelprestamo` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `buscarsaldodelprestamo`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
    declare a double;
    set a=(select sum(valor) from abonosprestamos  where idprestamo=idin);
    set a=ifnull(a,0);
    return (select plazo*valorcuota+valorcuotainicial-a from prestamos where id=idin);
    end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelprestamoin` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `buscarsaldodelprestamoin`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
     declare a double;
     set a=(select sum(valor) from abonosprestamosin  where idprestamo=idin);
     set a=ifnull(a,0);
     return (select valor-a from prestamosalaempresa where id=idin);
     end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarsaldodelproveedor` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `buscarsaldodelproveedor`(`idclientein` INT(11)) RETURNS int
    SQL SECURITY INVOKER
begin DECLARE P INT(11); DECLARE Q INT(11);  DECLARE prestamos INT(11); 
SET prestamos=(select sum(saldo) from prestamosalaempresa where idcliente=idclientein);
SET P=(select sum(valor-descuento) from mayorescompras where idproveedor=idclientein and documento='CREDITO');
SET Q=(select sum(abonoscompras.valor) from abonoscompras,mayorescompras where mayorescompras.idproveedor=idclientein and abonoscompras.idmayorcompras=mayorescompras.id);
set prestamos=ifnull(prestamos,0); set P=ifnull(P,0); 
set Q=ifnull(Q,0); 
RETURN P+prestamos-Q; END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarseccion` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `buscarseccion`(`idin` INT(11)) RETURNS varchar(25) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE a varchar(25);
set a=(select ifnull(secciones.seccion,'DESCONOCIDO') from articulos,secciones where articulos.id=idin and idseccion=secciones.id);
return ifnull(a,'DESCONOCIDO');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscartelefonotercero` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscartelefonotercero`(`idin` INT(11)) RETURNS varchar(110) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE P varchar(110);
SET P=(select concat(ifnull(telefono,''),' ',ifnull(celular,'')) from clientes where id=idin);
RETURN ifnull(P,'');
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscartrasladosabodega` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscartrasladosabodega`(`idin` INT(11), `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from traslados where idarticulo=idin and cast(fechacreacion as date) BETWEEN fecha1 and fecha2) and origen<>'MESAS';
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscartrasladosproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscartrasladosproducto`(`idin` INT(11), `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from traslados where idarticulo=idin and cast(fechacreacion as date) BETWEEN fecha1 and fecha2);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarultimaventa` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `buscarultimaventa`(`idin` INT(11)) RETURNS date
    SQL SECURITY INVOKER
BEGIN
        DECLARE P DATE;
        SET P=(select cast(fechacreacion as date) from ventas where idarticulo=idin order by id desc limit 1); 
        return ifnull(P,'');
        END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarultimoabonodecompras` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`localhost` FUNCTION `buscarultimoabonodecompras`(`idclientein` INT(11)) RETURNS varchar(25) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
declare rs varchar(25);
set rs=(select max(abonoscompras.fechacreacion) from abonoscompras,mayorescompras where idmayorcompras=mayorescompras.id and mayorescompras.idproveedor=idclientein  );
return ifnull(rs,'SIN ABONOS');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarunidaddemedida` */;
DELIMITER ;;
CREATE DEFINER=`restaura_kaldi`@`localhost` FUNCTION `buscarunidaddemedida`(`idin` INT(11)) RETURNS varchar(50) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN declare rs varchar(50); set rs=(select unidaddemedida from unidadesdemedida where id=idin); return ifnull(rs,'DESCONOCIDO'); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarvalordelamesa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarvalordelamesa`(`idmesain` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN DECLARE rs double; set rs=(select sum(valortotal) from ventasauxiliar where idmesa=idmesain); return ifnull(rs,0); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarvalordelanotadebito` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarvalordelanotadebito`(`idndin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P int(11); SET P=(select valortotal from notasdebito where id=idndin); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarventasdelusuario` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarventasdelusuario`(`idin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(11);
SET P=(select ifnull(sum(total),0) from facturas where idvendedor =idin and cast(fechacreacion as date)=cast(now()as date) and abonado=0 );
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarventasporproductoyvendedor` */;
DELIMITER ;;
CREATE DEFINER=`restaura_kaldi`@`localhost` FUNCTION `buscarventasporproductoyvendedor`(`idvendedorin` INT(11), `idarticuloin` INT(11), `mesin` INT(2)) RETURNS int
    SQL SECURITY INVOKER
begin
declare a int(11);
set a=(select sum(cantidad) from ventas where nc=0 and abonado=0 and idvendedor=idvendedorin and idarticulo=idarticuloin and year(fechacreacion)=year(now()) and month(fechacreacion)=mesin);
return ifnull(a,0);
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarventasproducto` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarventasproducto`(`idin` INT, `fecha1` DATE, `fecha2` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from ventas where idarticulo=idin and fechacreacion BETWEEN fecha1 and fecha2);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarventasproductoanoymes` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `buscarventasproductoanoymes`(`idin` INT(11), `mesin` INT(2), `anoin` INT(4)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(cantidad) from ventas where idarticulo=idin and month(fechacreacion)=mesin and year(fechacreacion)=anoin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `buscarzona` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`162.214.175.121` FUNCTION `buscarzona`(`idin` INT(11)) RETURNS varchar(25) CHARSET latin1
    SQL SECURITY INVOKER
BEGIN
DECLARE a varchar(25);
set a=(select ifnull(zona,'DESCONOCIDO') from zonas,mesas where zonas.id=mesas.idzona and mesas.id=idin);
return ifnull(a,'DESCONOCIDO');
end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `calcularcostodelafactura` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `calcularcostodelafactura`(`idfacturain` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P DOUBLE;
SET P=(select sum(cantidad*costomedio)  from ventas where idfactura=idfacturain);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `calcularcostopomedio` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_kaldi`@`%.%.%.%` FUNCTION `calcularcostopomedio`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
begin
declare a double;
declare b double;
declare c double;
declare d double;
declare e double;
declare f double;
set d=(select valorgramo from compras where idarticulo=idin order by id desc limit 1);
set e=(select costomedio from articulos where id=idin);
set f=(select ultimocoste from articulos where id=idin);
set d=ifnull(d,0);
set a=(SELECT sum(cantidad*factor) from compras where  
idarticulo=idin and month(fecha)=month(now()) and year(fecha)=year(now()));
       set b=(SELECT sum(valortotal) from compras where  
idarticulo=idin and month(fecha)=month(now()) and year(fecha)=year(now()));
       set a=ifnull(a,1);
       set b=ifnull(b,0);
set c=  (b*1.0/a*1.0);
if c= 0 then set c=d; end if;
if c= 0 and e>0 then set c=e; end if;
if c= 0 and f>0 then set c=f; end if;
return c;
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `calcularcostoseguningredientes` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `calcularcostoseguningredientes`(`idarticuloin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P double;
SET P=(select sum(articulos.costomedio*componentesarticulos.cantidad) 
from articulos,componentesarticulos where articulos.id=idinsumo and idarticulo=idarticuloin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `calcular_disponibilidad` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `calcular_disponibilidad`(`idarticuloin` INT) RETURNS double
BEGIN
    DECLARE vtienecomposicion INT;
    DECLARE compromiso INT;
    DECLARE cantidadactual DOUBLE;

    
    SELECT tienecomposicion INTO vtienecomposicion
    FROM articulos
    WHERE id = idarticuloin;

    
    SELECT IFNULL(SUM(factor * cantidad), 0) INTO compromiso
    FROM ventasauxiliar
    WHERE idarticulo = idarticuloin;

    
    IF vtienecomposicion < 1 THEN
        SELECT cantidad INTO cantidadactual
        FROM articulos
        WHERE id = idarticuloin;
    ELSE
        SELECT  MIN(a2.cantidad / c.cantidad) INTO cantidadactual FROM articulos a1 LEFT JOIN componentesarticulos c ON a1.id = c.idarticulo LEFT JOIN articulos a2 ON c.idinsumo = a2.id WHERE c.cantidad>0 and a1.id = idarticuloin;
    END IF;

    
   
        RETURN  cantidadactual- compromiso;
    
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `cantidaddecompras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `cantidaddecompras`(`idin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(4);
SET P=(select count(id) from compras where idarticulo=idin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `comisionporclientes` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `comisionporclientes`(`idarticulo` INT(11), `idclientein` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(6);
DECLARE q varchar(50);
SET q=(select grupo from clientes  where id=idclientein);
if(q='ENTRENADORES') THEN  
SET P=(select comision from articulos where id=idarticulo);
ELSE 
SET P=(select (-valordistribuidor+valordeventa)/2 from articulos where id=idarticulo);
END IF;
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `comisionpreciopublico` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `comisionpreciopublico`(`idarticulo` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(6);
SET P=(select (-valordistribuidor+valordeventa)/2 from articulos where id=idarticulo);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `contararticulosenlamesa` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `contararticulosenlamesa`(`idarticuloin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(4);
SET P=(select sum(cantidad) from ventasauxiliar where idarticulo=idarticuloin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `contarlineasdelamesa` */;
DELIMITER ;;
CREATE DEFINER=`wwcont_lafonda`@`%.%.%.%` FUNCTION `contarlineasdelamesa`(`idin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P int(11); declare notas int(11); set notas=(select count(id) from ventasauxiliar where idmesa=idin);RETURN ifnull(notas,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `contarlineasdemayorescompras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `contarlineasdemayorescompras`(`idmayorin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN DECLARE P double; SET P=(select count(id) from compras where idmayor=idmayorin); RETURN ifnull(P,0); END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `contarlineasenventa` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`localhost` FUNCTION `contarlineasenventa`(`idin` INT(11)) RETURNS int
    NO SQL
    SQL SECURITY INVOKER
begin declare a int(3); set a=(select count(id) from ventas where idfactura=idin and abonado=0 and nc=0 and esmodif=0); return ifnull(a,0); end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `contarventasanuladas` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `contarventasanuladas`(`idarticuloin` INT(11), `idzin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(11);
set P=(select sum(cantidad) from ventas where idz=idzin and idarticulo=idarticuloin and abonado=1);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `contarventasbrutas` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `contarventasbrutas`(`idarticuloin` INT(11), `idzin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(11);
set P=(select sum(cantidad) from ventas where idz=idzin and idarticulo=idarticuloin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `desvestcompras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `desvestcompras`(`idin` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P double;
DECLARE q double;
SET q=(select buscarpreciopromedio(idin));
SET P=(select sum((valorgramo-q)*(valorgramo-q)) from compras where idarticulo=idin);
RETURN ifnull(SQRT(P),0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `esfestivo` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `esfestivo`(`fechain` DATE) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select id from festivos where fecha=fechain);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `espadre` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `espadre`(`idarticuloin` INT(11), `idinsumoin` INT(11), `idusuarioin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
declare idarticuloactual int(11);
delete from auxiliarbuscarpadre where idusuario=idusuarioin;
if idarticuloin=idinsumoin then 
return 1;
end if;
insert into auxiliarbuscarpadre(idusuario,a)
select idusuarioin,idarticulo  from componentesarticulos where idinsumo=idarticuloin;
while (select count(a) from auxiliarbuscarpadre where idusuario=idusuarioin)>0 do 
set idarticuloactual=(select a from auxiliarbuscarpadre where idusuario=idusuarioin limit 1);

if(idarticuloactual=idinsumoin)then return 1;end if;
insert into auxiliarbuscarpadre(idusuario,a)
select idusuarioin,idarticulo from componentesarticulos where idinsumo=idarticuloactual;
delete from auxiliarbuscarpadre  where a=idarticuloactual;
end while;
RETURN 0;
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `facturatienemodificadores` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`162.214.175.121` FUNCTION `facturatienemodificadores`(`idin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
begin declare a int(3);declare b int(1); 
set b=0;
set a=(select count(id) from ventas where idfactura=idin and esmodif=1); 
if(a>0) then set b=1;end if;
return b; end ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `mirarsienventatienecomposicion` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `mirarsienventatienecomposicion`(`idarticuloin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
declare a int(2);
set a=(select count(componentesarticulos.id) from componentesarticulos,articulos where idarticulo=articulos.id and articulos.referencia=idarticuloin);
RETURN ifnull(a,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `mirarsitienecomposicion` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `mirarsitienecomposicion`(`idarticuloin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(1);
SET P=(select count(id) from componentesarticulos where idarticulo=idarticuloin);
IF p<1 THEN return '0';
else return 1;
END IF;
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `sepuedeborrarfamiliademodificadores` */;
DELIMITER ;;
CREATE DEFINER=`controll_kaldi`@`vps-385963.appitecintegraciones.com` FUNCTION `sepuedeborrarfamiliademodificadores`(`idin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(2);
DECLARE Q INT(2);
SET P=(select count(id) from asignacionarticulosfamiliasmodificadores where idfamilia=idin);
SET Q=(select count(id) from modificadores where idfamilia=idin);
RETURN if(P+Q>0,0,1);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `sumarventasanuladas` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `sumarventasanuladas`(`idarticuloin` INT(11), `idzin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(11);
set P=(select sum(valortotal-cantidad*descuento) from ventas where idz=idzin and idarticulo=idarticuloin and abonado=1);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `sumarventasbrutas` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `sumarventasbrutas`(`idarticuloin` INT(11), `idzin` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P int(11);
set P=(select sum(valortotal-cantidad*descuento) from ventas where idz=idzin and idarticulo=idarticuloin);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `totalcompradeestecliente` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `totalcompradeestecliente`(`idclientein` INT(11)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select SUM(total) from facturas where idcliente=idclientein);
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `totalizarventaauxiliar` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `totalizarventaauxiliar`(`idmesain` INT(11)) RETURNS double
    SQL SECURITY INVOKER
BEGIN
DECLARE P DOUBLE;
SET P=(SELECT ifnull(SUM(valortotal),0)/10 FROM ventasauxiliar where idmesa=idmesain);
RETURN P;
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `ventasentrehoras` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `ventasentrehoras`(`ccin` INT(3), `fecha1` DATE, `hora1` VARCHAR(9), `hora2` VARCHAR(9)) RETURNS int
    SQL SECURITY INVOKER
BEGIN
DECLARE P INT(11);
SET P=(select sum(valortotal) from ventas where cc=ccin and fecha between concat(fecha1,hora1) and concat(fecha1,hora2) ) ;
RETURN ifnull(P,0);
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `cambiarcostoencascada` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `cambiarcostoencascada`(IN `idarticuloin` BIGINT(20), IN `ccin` BIGINT(20))
    SQL SECURITY INVOKER
BEGIN
declare idtablaactual int(11);
declare idarticuloactual int(11);
delete from auxiliarcambiodeprecios where cc=ccin;
insert into auxiliarcambiodeprecios(idarticulo,idinsumo,cantidad,cc)
select idarticulo,idinsumo,cantidad,ccin from componentesarticulos where idinsumo=idarticuloin;
while (select count(id) from auxiliarcambiodeprecios  where cc=ccin)>0 do 
set idtablaactual=(select id from auxiliarcambiodeprecios where cc=ccin limit 1);
set idarticuloactual=(select idarticulo from auxiliarcambiodeprecios where id=idtablaactual);
update articulos set subido=0,costomedio=calcularcostoseguningredientes(idarticuloactual) where id=idarticuloactual;
insert into auxiliarcambiodeprecios(idarticulo,idinsumo,cantidad,cc)
select idarticulo,idinsumo,cantidad,ccin from componentesarticulos where idinsumo=idarticuloactual;
delete from auxiliarcambiodeprecios  where id=idtablaactual;
end while;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `cotizarreceta` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `cotizarreceta`(IN `idusuarioin` INT(11), IN `tipodecotizacion` INT(1))
    SQL SECURITY INVOKER
BEGIN
declare idtablaactual int(11);
declare idcotizacionactual int(11);
declare cantidadactual double;
declare cantidadcotizacionactual double;
declare idarticuloactual int(11);
declare idarticuloparacotizar int(11);
if(select count(id) from auxiliarcotizarreceta)=0 THEN
truncate table auxiliarcotizarreceta;
else
delete from auxiliarcotizarreceta where idusuario=idusuarioin;
end if;
if(select count(id) from respuestacotizacionreceta)=0 THEN
truncate table respuestacotizacionreceta;
else
delete from respuestacotizacionreceta where idusuario=idusuarioin;
end if;




insert into respuestacotizacionreceta(idarticulo,idinsumo,cantidad,idusuario)
select 0,idarticulo,cantidad,idusuarioin from cotizaciondereceta where mirarsitienecomposicion(idarticulo)=0;









while(select count(id) from cotizaciondereceta where idusuario=idusuarioin and revisado=0)>0 DO
set idcotizacionactual=(select id from cotizaciondereceta  where idusuario=idusuarioin and revisado=0 limit 1);
set cantidadcotizacionactual=(select cantidad from cotizaciondereceta  where id=idcotizacionactual);
set idarticuloparacotizar=(select idarticulo from cotizaciondereceta  where id=idcotizacionactual);
insert into auxiliarcotizarreceta(idarticulo,idinsumo,cantidad,idusuario)
select idarticulo,idinsumo,cantidad*cantidadcotizacionactual,idusuarioin from componentesarticulos where idarticulo=idarticuloparacotizar;
while (select count(id) from auxiliarcotizarreceta  where idusuario=idusuarioin)>0 do 
set idtablaactual=(select id from auxiliarcotizarreceta  where idusuario=idusuarioin limit 1);
set idarticuloactual=(select idinsumo from auxiliarcotizarreceta where id=idtablaactual);
set cantidadactual=(select cantidad from auxiliarcotizarreceta where id=idtablaactual);
if(mirarsitienecomposicion(idarticuloactual)=0) THEN
insert into respuestacotizacionreceta(idarticulo,idinsumo,cantidad,idusuario)
values(0,idarticuloactual,cantidadactual,idusuarioin);
ELSE
insert into auxiliarcotizarreceta(idarticulo,idinsumo,cantidad,idusuario)
select idarticuloactual,idinsumo,cantidad*cantidadactual,idusuarioin from componentesarticulos where idarticulo=idarticuloactual;
end IF;
delete from auxiliarcotizarreceta  where id=idtablaactual;
end while;
update cotizaciondereceta set revisado=1 where id=idcotizacionactual;
end while;
if(tipodecotizacion=0) then 
select sum(respuestacotizacionreceta.cantidad) as cantidad,articulos.descripcion,articulos.costomedio as costo,unidaddemedida from respuestacotizacionreceta,articulos,unidadesdemedida where idinsumo=articulos.id and idunidaddemedida=unidadesdemedida.id GROUP by descripcion;
else 
select sum(respuestacotizacionreceta.cantidad) as cantidad,articulos.descripcion,articulos.ultimocoste as costo,unidaddemedida from respuestacotizacionreceta,articulos,unidadesdemedida where idinsumo=articulos.id and idunidaddemedida=unidadesdemedida.id GROUP by descripcion;
end if;
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `detallarsurecetaagrupada` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `detallarsurecetaagrupada`(IN `idarticuloin` INT(11), IN `idusuarioin` INT(11))
    SQL SECURITY INVOKER
BEGIN
declare idtablaactual int(11);
declare cantidadactual double;
declare idarticuloactual int(11);
if(select count(id) from auxiliarcostoagrupado)=0 THEN
truncate table auxiliarcostoagrupado;
else
delete from auxiliarcostoagrupado where idusuario=idusuarioin;
end if;

if(select count(id) from respuestacostoagrupado)=0 THEN
truncate table respuestacostoagrupado;
else
delete from respuestacostoagrupado where idusuario=idusuarioin;
end if;



insert into auxiliarcostoagrupado(idarticulo,idinsumo,cantidad,idusuario)
select idarticulo,idinsumo,cantidad,idusuarioin from componentesarticulos where idarticulo=idarticuloin;
while (select count(id) from auxiliarcostoagrupado  where idusuario=idusuarioin)>0 do 
set idtablaactual=(select id from auxiliarcostoagrupado  where idusuario=idusuarioin limit 1);
set idarticuloactual=(select idinsumo from auxiliarcostoagrupado where id=idtablaactual);
set cantidadactual=(select cantidad from auxiliarcostoagrupado where id=idtablaactual);
if(mirarsitienecomposicion(idarticuloactual)=0) THEN
insert into respuestacostoagrupado(idarticulo,idinsumo,cantidad,idusuario)
values(0,idarticuloactual,cantidadactual,idusuarioin);
ELSE
insert into auxiliarcostoagrupado(idarticulo,idinsumo,cantidad,idusuario)
select idarticuloactual,idinsumo,cantidad*cantidadactual,idusuarioin from componentesarticulos where idarticulo=idarticuloactual;
end IF;
delete from auxiliarcostoagrupado  where id=idtablaactual;
end while;
select sum(respuestacostoagrupado.cantidad) as cantidad,articulos.descripcion,articulos.costomedio,unidaddemedida from respuestacostoagrupado,articulos,unidadesdemedida where idinsumo=articulos.id and idunidaddemedida=unidadesdemedida.id GROUP by descripcion;
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `truncarventasauxiliar` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `truncarventasauxiliar`()
    SQL SECURITY INVOKER
BEGIN
declare n int(11);
set n =(select count(id) from ventasauxiliar);
if n=0 then 
truncate table ventasauxiliar;
end if;
END ;;
DELIMITER ;


