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

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

--
-- Table structure for table `quemplim`
--

DROP TABLE IF EXISTS `quemplim`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quemplim` (
  `cod_pimp` char(4) NOT NULL DEFAULT '' COMMENT 'Impreso',
  `nombre` text NOT NULL COMMENT 'Descripción',
  `cod_origen` char(4) NOT NULL DEFAULT '1' COMMENT 'Orígen e-mail',
  `fichero` char(30) NOT NULL DEFAULT '' COMMENT 'Tabla',
  `report` char(15) NOT NULL DEFAULT '' COMMENT 'Report',
  `campo_mail` text NOT NULL COMMENT 'Campo para envío e-mail',
  `campo_repetition` text NOT NULL COMMENT 'Campo repetición etiqts.',
  `sw_tipo_texto` char(1) NOT NULL DEFAULT 'P' COMMENT 'Tipo texto idioma',
  `cod_salida` char(10) NOT NULL DEFAULT '' COMMENT 'Und Salida originales',
  `cod_salida_cop` char(10) NOT NULL DEFAULT '' COMMENT 'Und Salida copias',
  `margen_sup` decimal(7,2) NOT NULL DEFAULT '5.00' COMMENT 'Lins. Margen superior',
  `margen_inf` decimal(7,2) NOT NULL DEFAULT '5.00' COMMENT 'Lins. Margen inferior',
  `margen_izq` decimal(7,2) NOT NULL DEFAULT '10.00' COMMENT 'Cols. Margen izquierdo',
  `lins` decimal(7,2) NOT NULL DEFAULT '100.00' COMMENT 'Líneas por página',
  `cols` decimal(7,2) NOT NULL DEFAULT '80.00' COMMENT 'Columnas por página',
  `campo_nombre` char(250) NOT NULL DEFAULT '' COMMENT 'Campo nombre registro',
  `eti_lins` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Etiquetas: filas',
  `eti_cols` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Etiquetas: columnas',
  `eti_lins_lin` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Etiquetas: lins. fila',
  `eti_cols_col` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Etiquetas: cols. columna',
  `cod_paper` char(6) NOT NULL DEFAULT 'A4' COMMENT 'Tipo Papel',
  `orientacion` char(1) NOT NULL DEFAULT 'P' COMMENT 'Orientación',
  `dpis` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Puntos por pulgada',
  `quality` char(2) NOT NULL DEFAULT '15' COMMENT 'Calidad',
  `speed` char(1) NOT NULL DEFAULT '6' COMMENT 'Velocidad',
  `sw_direction` char(1) NOT NULL DEFAULT 'N' COMMENT 'Impresión invertida',
  `font_1` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 1',
  `color_1` char(6) NOT NULL DEFAULT '' COMMENT 'Color 1',
  `rota_1` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 1',
  `alto_1` decimal(7,2) NOT NULL DEFAULT '30.00' COMMENT '% Alto fuente 1',
  `bold_1` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 1',
  `underline_1` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 1',
  `italic_1` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 1',
  `font_2` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 2',
  `color_2` char(6) NOT NULL DEFAULT '' COMMENT 'Color 2',
  `rota_2` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 2',
  `alto_2` decimal(7,2) NOT NULL DEFAULT '50.00' COMMENT '% Alto fuente 2',
  `bold_2` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 2',
  `underline_2` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 2',
  `italic_2` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 2',
  `font_3` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 3',
  `color_3` char(6) NOT NULL DEFAULT '' COMMENT 'Color 3',
  `rota_3` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 3',
  `alto_3` decimal(7,2) NOT NULL DEFAULT '100.00' COMMENT '% Alto fuente 3',
  `bold_3` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 3',
  `underline_3` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 3',
  `italic_3` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 3',
  `font_4` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 4',
  `color_4` char(6) NOT NULL DEFAULT '' COMMENT 'Color 4',
  `rota_4` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 4',
  `alto_4` decimal(7,2) NOT NULL DEFAULT '150.00' COMMENT '% Alto fuente 4',
  `bold_4` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 4',
  `underline_4` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 4',
  `italic_4` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 4',
  `font_5` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 5',
  `color_5` char(6) NOT NULL DEFAULT '' COMMENT 'Color 5',
  `rota_5` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 5',
  `alto_5` decimal(7,2) NOT NULL DEFAULT '200.00' COMMENT '% Alto fuente 5',
  `bold_5` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 5',
  `underline_5` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 5',
  `italic_5` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 5',
  `font_6` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 6',
  `color_6` char(6) NOT NULL DEFAULT '' COMMENT 'Color 6',
  `rota_6` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 6',
  `alto_6` decimal(7,2) NOT NULL DEFAULT '100.00' COMMENT '% Alto fuente 6',
  `bold_6` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 6',
  `underline_6` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 6',
  `italic_6` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 6',
  `font_7` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 7',
  `color_7` char(6) NOT NULL DEFAULT '' COMMENT 'Color 7',
  `rota_7` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 7',
  `alto_7` decimal(7,2) NOT NULL DEFAULT '100.00' COMMENT '% Alto fuente 7',
  `bold_7` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 7',
  `underline_7` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 7',
  `italic_7` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 7',
  `font_8` char(10) NOT NULL DEFAULT 'Courier' COMMENT 'Fuente 8',
  `color_8` char(6) NOT NULL DEFAULT '' COMMENT 'Color 8',
  `rota_8` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT 'Grados rotar 8',
  `alto_8` decimal(7,2) NOT NULL DEFAULT '100.00' COMMENT '% Alto fuente 8',
  `bold_8` char(1) NOT NULL DEFAULT 'N' COMMENT 'Negrita 8',
  `underline_8` char(1) NOT NULL DEFAULT 'N' COMMENT 'Subrayado 8',
  `italic_8` char(1) NOT NULL DEFAULT 'N' COMMENT 'Itálica 8',
  `cod_idioma_1` char(4) NOT NULL DEFAULT 'ES' COMMENT 'Idioma 1',
  `html_1` longtext NOT NULL COMMENT 'Html Impreso Idioma 1',
  `texto_1` text NOT NULL COMMENT 'Texto Impreso Idioma 1',
  `cod_idioma_2` char(4) NOT NULL DEFAULT 'CA' COMMENT 'Idioma 2',
  `html_2` longtext NOT NULL COMMENT 'Html Impreso Idioma 2',
  `texto_2` text NOT NULL COMMENT 'Texto Impreso Idioma 2',
  `cod_idioma_3` char(4) NOT NULL DEFAULT 'EN' COMMENT 'Idioma 3',
  `html_3` longtext NOT NULL COMMENT 'Html Impreso Idioma 3',
  `texto_3` text NOT NULL COMMENT 'Texto Impreso Idioma 3',
  `cod_idioma_4` char(4) NOT NULL DEFAULT 'EU' COMMENT 'Idioma 4',
  `html_4` longtext NOT NULL COMMENT 'Html Impreso Idioma 4',
  `texto_4` text NOT NULL COMMENT 'Texto Impreso Idioma 4',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `sw_biosign` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Documento con firma biométrica',
  `bisi_info` text NOT NULL COMMENT 'Datos Adicionales',
  `bisi_msg` text NOT NULL COMMENT 'Texto en firma',
  `bisi_page` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Página',
  `bisi_xpos` int(11) NOT NULL DEFAULT '0' COMMENT 'Posición	X',
  `bisi_ypos` int(11) NOT NULL DEFAULT '0' COMMENT 'Y',
  `bisi_xsize` int(11) NOT NULL DEFAULT '0' COMMENT 'Tamaño		X',
  `bisi_ysize` int(11) NOT NULL DEFAULT '0' COMMENT 'Y',
  `sw_auto_salto` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Salto línea automático (en líneas > ancho)',
  `margen_der` decimal(7,2) NOT NULL DEFAULT '5.00' COMMENT 'Cols. Margen derecho (solo salto línea auto)',
  `id_quemplem` int(11) NOT NULL DEFAULT '0' COMMENT 'Plantilla E-mail',
  `campo_cod_cuenta` text NOT NULL COMMENT 'Campo cuenta e-mails',
  `quemplim_formato` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Formato nuevo',
  UNIQUE KEY `key0` (`id_tenant`,`cod_pimp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `quemplim` WRITE;
/*!40000 ALTER TABLE `quemplim` DISABLE KEYS */;
INSERT INTO `quemplim` (`cod_pimp`, `nombre`, `cod_origen`, `fichero`, `report`, `campo_mail`, `campo_repetition`, `sw_tipo_texto`, `cod_salida`, `cod_salida_cop`, `margen_sup`, `margen_inf`, `margen_izq`, `lins`, `cols`, `campo_nombre`, `eti_lins`, `eti_cols`, `eti_lins_lin`, `eti_cols_col`, `cod_paper`, `orientacion`, `dpis`, `quality`, `speed`, `sw_direction`, `font_1`, `color_1`, `rota_1`, `alto_1`, `bold_1`, `underline_1`, `italic_1`, `font_2`, `color_2`, `rota_2`, `alto_2`, `bold_2`, `underline_2`, `italic_2`, `font_3`, `color_3`, `rota_3`, `alto_3`, `bold_3`, `underline_3`, `italic_3`, `font_4`, `color_4`, `rota_4`, `alto_4`, `bold_4`, `underline_4`, `italic_4`, `font_5`, `color_5`, `rota_5`, `alto_5`, `bold_5`, `underline_5`, `italic_5`, `font_6`, `color_6`, `rota_6`, `alto_6`, `bold_6`, `underline_6`, `italic_6`, `font_7`, `color_7`, `rota_7`, `alto_7`, `bold_7`, `underline_7`, `italic_7`, `font_8`, `color_8`, `rota_8`, `alto_8`, `bold_8`, `underline_8`, `italic_8`, `cod_idioma_1`, `html_1`, `texto_1`, `cod_idioma_2`, `html_2`, `texto_2`, `cod_idioma_3`, `html_3`, `texto_3`, `cod_idioma_4`, `html_4`, `texto_4`, `id_tenant`, `sw_biosign`, `bisi_info`, `bisi_msg`, `bisi_page`, `bisi_xpos`, `bisi_ypos`, `bisi_xsize`, `bisi_ysize`, `sw_auto_salto`, `margen_der`, `id_quemplem`, `campo_cod_cuenta`, `quemplim_formato`) VALUES ('AGEC','Albaranes de Agencia','1','cialdoco','agec','','','P','','',3.00,0.00,7.00,72.00,80.00,'',0.00,0.00,0.00,0.00,'A4','P',0.00,'15','6','N','Courier','',0.00,30.00,'N','N','N','Courier','',0.00,50.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,150.00,'N','N','N','Courier','',0.00,200.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[p:2:-2:-1:0:0:1:L:<? QU_Basic::toDateEdited($fecha, \"H\") ?>]\r\n [p:2:-2:20:0:0:1:L:<? $anyo.\"  \" .$cod_serie.\"  \" . $numero ?>]\r\n [p:2:-2:40:0:0:1:L:<? $Rnum_dien_direccion ? ($Rnum_dien_cod_postal . \" \" . $Rnum_dien_poblacion) : ($Rcod_cuenta_cod_postal . \" \" . $Rcod_cuenta_poblacion) ?>]\r\n [p:2:1:5:0:0:1:L:<? $Rnum_dien_nombre ? $Rnum_dien_nombre : $Rcod_cuenta_nombre ?>]\r\n\r\n [p:2:2:5:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_direccion : $Rcod_cuenta_direccion ?>]\r\n [p:2:1:40:0:0:1:L:<? $Rnum_dien_direccion ? ($Rnum_dien_cod_postal . \" \" . $Rnum_dien_poblacion) : ($Rcod_cuenta_cod_postal . \" \" . $Rcod_cuenta_poblacion) ?>]\r\n [p:2:2:40:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_provincia : $Rcod_cuenta_provincia ?>]\r\n\r\n [p:2:4:5:0:0:1:L:<? $Rcod_agencia_nombre ?>]\r\n [p:2:5:5:0:0:1:L:<? $Rcod_agencia_direccion ?>]\r\n [p:2:6:5:0:0:1:L:<? $Rcod_agencia_cod_postal.\" \".$Rcod_agencia_poblacion ?>]\r\n\r\n [p:2:5:30:0:0:1:L:<? $tipo_portes =\"p\" ? \"Pagados \" : \"Debidos\"  ?>]\r\n [p:2:5:40:0:0:1:L:<? \"Ar. Ferreteria\" ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('DAA','Impreso DAA','1','cialdacc','daa','','','P','','',3.00,0.00,7.00,72.00,80.00,'',0.00,0.00,0.00,0.00,'Z1208','P',0.00,'15','6','N','Courier','',0.00,30.00,'N','N','N','Courier','',0.00,50.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,150.00,'N','N','N','Courier','',0.00,200.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[p:3:0:18:0:0:1:L:<? $quup[\"quupempr\"][\"cod_nacion\"].\" \".$quup[\"quupempr\"][\"cif\"] ?>]\r\n[p:3:1:0:0:0:1:L:<? $quup[\"quupempr\"][\"nombre\"] ?>]\r\n[p:3:1:40:0:0:1:L:<? $quup[\"cialzzqu\"][\"cod_cae_empresa\"] ?>]\r\n[p:3:1:57:0:0:1:L:<? $num_daa ?>]\r\n[p:3:2:0:0:0:1:L:<? $quup[\"quupempr\"][\"direccion\"] ?>]\r\n[p:3:3:0:0:0:1:L:<? $quup[\"quupempr\"][\"cod_postal\"].\" \".$quup[\"quupempr\"][\"poblacion\"] ?>]\r\n[p:3:3:40:0:0:1:L:<? $Rdien_cod_cae ? $Rdien_cod_cae : $Rcliente_cod_cae ?>]\r\n[p:3:3:57:0:0:1:L:<? $Rdocumento_ori_cod_serie.\" \".$Rdocumento_ori_numero ?>]\r\n[p:3:4:0:0:0:1:L:<? $quup[\"quupempr\"][\"provincia\"] ?>]\r\n[p:3:5:40:0:0:1:L:<? QU_Basic::toDateEdited($fecha) ?>]\r\n\r\n[p:3:6:18:0:0:1:L:<? $Rdien_cif ? $Rdien_cod_nacion.\" \".$Rdien_cif : $Rcliente_cod_nacion.\" \".$Rcliente_cif ?>]\r\n\r\n[p:3:7:0:0:0:1:L:<? $Rdien_nombre ? $Rdien_nombre : $Rcliente_nombre ?>]\r\n[p:3:7:40:0:0:1:L:<? $this->getSubText(3,$aut_competente,0) ?>]\r\n\r\n[p:3:8:0:0:0:1:L:<? $Rdien_direccion ? $Rdien_direccion : $Rcliente_direccion ?>]\r\n[p:3:8:40:0:0:1:L:<? $this->getSubText(3,$aut_competente,1) ?>]\r\n\r\n[p:3:9:7:0:0:1:L:<? $Rdien_direccion ? ($Rdien_cod_postal . \" \" . $Rdien_poblacion) : ($Rcliente_cod_postal . \" \" . $Rcliente_poblacion) ?>]\r\n[p:3:9:40:0:0:1:L:<? $this->getSubText(3,$aut_competente,2) ?>]\r\n\r\n[p:3:10:7:0:0:1:L:<? $Rdien_direccion ? $Rdien_provincia : $Rcliente_provincia ?>]\r\n[p:3:10:40:0:0:1:L:<? $this->getSubText(3,$aut_competente,3) ?>]\r\n\r\n[p:3:15:0:0:0:1:L:<? $this->getSubText(3,$agente_transporte,0) ?>]\r\n[p:3:16:0:0:0:1:L:<? $this->getSubText(3,$agente_transporte,1) ?>]\r\n\r\n[p:3:18:0:0:0:1:L:<? $this->getSubText(3,$pormenor_transporte,0) ?>]\r\n[p:3:19:0:0:0:1:L:<? $this->getSubText(3,$pormenor_transporte,1) ?>]\r\n\r\n[p:3:21:0:0:0:1:L:<? $quup[\"cialzzqu\"][\"cod_cae_empresa\"] ?>]\r\n[p:3:21:19:0:0:1:L:<? QU_Basic::toDateEdited($fecha_despacho) . \"  \" . QU_Basic::toTimeEdited($hora_despacho,\"4\") ?>]\r\n[p:3:21:40:0:0:1:L:<? $duracion_transporte ?>]\r\n\r\n[p:3:23:0:0:0:1:L:<? trim($Rlin1_nombre) ?>]\r\n[p:3:23:41:0:0:1:L:<? $Rart1_cod_nc_taric ? $Rart1_cod_nc_taric : $Rfam1_cod_nc_taric ?>]\r\n[p:3:23:56:0:0:1:L:<? $epi_mercancia_1 ?>]\r\n[p:3:23:61:0:0:1:L:<? $reg_mercancia_1 ?>]\r\n[p:3:23:67:0:0:1:L:<? QU_Basic::toNumEdited($Rlin1_esp_factor,2) ?>]\r\n[p:3:24:2:0:0:1:L:<? \"(a \".QU_Basic::toNumEdited($Rlin1_esp_factor,2,true).\"§ OL.)\" ?>]\r\n[p:3:25:0:0:0:1:L:<? \"REF: \".$Rlin1_cod_articulo ?>]\r\n[p:3:26:41:0:0:1:L:<? chr(15) . QU_Basic::toNumEdited(bccomp($Rlin1_esp_factor_und,0,8)!=0 ? bcmul($Rlin1_esp_factor_und,$Rlin1_cantidad,2) : $Rlin1_cantidad, 2) . \" Litros\" . chr(18) ?>]\r\n[p:3:27:0:0:0:1:L:<? $envase_1 ?>]\r\n[p:3:27:41:0:0:1:L:<? chr(15) . QU_Basic::toNumEdited(bcmul(bccomp($Rlin1_esp_factor_und,0,8)!=0 ? bcmul($Rlin1_esp_factor_und,$Rlin1_cantidad,2) : $Rlin1_cantidad, bcdiv($Rlin1_esp_factor,100,8), 8), 2) . \" Litros absol.\" . chr(18) ?>]\r\n\r\n[p:3:29:0:0:0:1:L:<? trim($Rlin2_nombre) ?>]\r\n[p:3:29:41:0:0:1:L:<? $Rart2_cod_nc_taric ? $Rart2_cod_nc_taric : $Rfam2_cod_nc_taric ?>]\r\n[p:3:29:56:0:0:1:L:<? $Rlin2_cod_articulo ? $epi_mercancia_2 : \"\" ?>]\r\n[p:3:29:61:0:0:1:L:<? $Rlin2_cod_articulo ? $reg_mercancia_2 : \"\" ?>]\r\n[p:3:29:67:0:0:1:L:<? QU_Basic::toNumEdited($Rlin2_esp_factor,2,true) ?>]\r\n[p:3:30:2:0:0:1:L:<? $Rlin2_cod_articulo ? \"(a \".QU_Basic::toNumEdited($Rlin2_esp_factor,2,true).\"§ OL.)\" : \"\" ?>]\r\n[p:3:31:0:0:0:1:L:<? $Rlin2_cod_articulo ? \"REF: \".$Rlin2_cod_articulo : \"\" ?>]\r\n[p:3:32:41:0:0:1:L:<? $Rlin2_cod_articulo ? chr(15) . QU_Basic::toNumEdited(bccomp($Rlin2_esp_factor_und,0,8)!=0 ? bcmul($Rlin2_esp_factor_und,$Rlin2_cantidad,2) : $Rlin2_cantidad, 2) . \" Litros\" . chr(18) : \"\" ?>]\r\n[p:3:33:0:0:0:1:L:<? $Rlin2_cod_articulo ? $envase_2 : \"\" ?>]\r\n[p:3:33:41:0:0:1:L:<? $Rlin2_cod_articulo ? chr(15) . QU_Basic::toNumEdited(bcmul(bccomp($Rlin2_esp_factor_und,0,8)!=0 ? bcmul($Rlin2_esp_factor_und,$Rlin2_cantidad,2) : $Rlin2_cantidad, bcdiv($Rlin2_esp_factor,100,8), 8), 2) . \" Litros absol.\" . chr(18) : \"\" ?>]\r\n\r\n[p:3:35:0:0:0:1:L:<? trim($Rlin3_nombre)  ?>]\r\n[p:3:35:41:0:0:1:L:<? $Rart3_cod_nc_taric ? $Rart3_cod_nc_taric : $Rfam3_cod_nc_taric ?>]\r\n[p:3:35:56:0:0:1:L:<? $Rlin3_cod_articulo ? $epi_mercancia_3 : \"\" ?>]\r\n[p:3:35:61:0:0:1:L:<? $Rlin3_cod_articulo ? $reg_mercancia_3 : \"\" ?>]\r\n[p:3:35:67:0:0:1:L:<? QU_Basic::toNumEdited($Rlin3_esp_factor,2,true) ?>]\r\n[p:3:36:2:0:0:1:L:<? $Rlin3_cod_articulo ? \"(a \".QU_Basic::toNumEdited($Rlin3_esp_factor,2,true).\"§ OL.)\" : \"\" ?>]\r\n[p:3:37:0:0:0:1:L:<? $Rlin3_cod_articulo ? \"REF: \".$Rlin3_cod_articulo : \"\" ?>]\r\n[p:3:38:41:0:0:1:L:<? $Rlin3_cod_articulo ? chr(15) . QU_Basic::toNumEdited(bccomp($Rlin3_esp_factor_und,0,8)!=0 ? bcmul($Rlin3_esp_factor_und,$Rlin3_cantidad,2) : $Rlin3_cantidad, 2) . \" Litros\" . chr(18) : \"\" ?>]\r\n[p:3:39:0:0:0:1:L:<? $Rlin3_cod_articulo ? $envase_2 : \"\" ?>]\r\n[p:3:39:41:0:0:1:L:<? $Rlin3_cod_articulo ? chr(15) . QU_Basic::toNumEdited(bcmul(bccomp($Rlin3_esp_factor_und,0,8)!=0 ? bcmul($Rlin3_esp_factor_und,$Rlin3_cantidad,2) : $Rlin3_cantidad, bcdiv($Rlin3_esp_factor,100,8), 8), 2) . \" Litros absol.\" . chr(18) : \"\" ?>]\r\n\r\n[p:3:50:43:0:0:1:L:<? $this->getSubText(3,$emp_telefono,0) ?>]\r\n[p:3:51:43:0:0:1:L:<? $this->getSubText(3,$emp_telefono,1) ?>]\r\n[p:3:52:43:0:0:1:L:<? $this->getSubText(3,$emp_telefono,2) ?>]\r\n[p:3:54:43:0:0:1:L:<? $nom_apellidos ?>]\r\n[p:3:56:43:0:0:1:L:<? chr(15) . $daa_lug_firmante.\" \".QU_Basic::toDateEdited($fecha) . chr(18) ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETIC','Etiquetas de Envío de Ventas por Bultos de Cabecera','1','cialdoco','etic','','','P','','',0.00,1.00,2.00,17.00,50.00,'',1.00,1.00,17.00,50.00,'ETI','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,80.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Courier','',0.00,200.00,'S','N','N','Courier','',0.00,100.00,'S','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','',' [i:/var/www/quartup.outs/imgs/quartup/quupempr/logo-0001.jpeg:0:60:0:35]\r\n [p:3:1:1:0:0:1:L:<? \"Pedido: \".$numero?>]\r\n [p:3:2.5:1:0:0:1:L:<? substr($Rcod_cuenta_nombre,0,30)?>]\r\n [p:2:3.5:1:0:0:1:L:<? \"Direccción: \"?>]\r\n [p:2:4.2:10:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_direccion : $Rcod_cuenta_direccion ?>]\r\n [p:2:5:10:0:0:1:L:<? $Rnum_dien_direccion ? ($Rnum_dien_cod_postal . \" \" . $Rnum_dien_poblacion) : ($Rcod_cuenta_cod_postal . \" \" . $Rcod_cuenta_poblacion) ?>]\r\n [p:2:5.7:10:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_provincia : $Rcod_cuenta_provincia ?>]\r\n [p:3:7:1:0:0:1:L:<? \"S/Ref.: \".substr($su_documento,0,30)?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETIL','Etiquetas de Envío de ventas por Bultos de Líneas','1','cialdoco','etil','','','P','','',3.00,0.00,7.00,72.00,80.00,'',7.00,2.00,10.00,40.00,'A4','P',0.00,'15','6','N','Courier','',0.00,30.00,'N','N','N','Courier','',0.00,50.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,150.00,'N','N','N','Courier','',0.00,200.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[p:4:-1:-1:0:0:1:L:<? $quup[\"quupempr\"][\"nombre_reducido\"] ?>]\r\n [p:4:0:-1:0:0:1:L:<? $quup[\"quupempr\"][\"nombre\"] ?>]\r\n [p:4:-3:35:0:0:1:L:<? \"Tienda, Oficina y almacén\" ?>]\r\n [p:3:-1:40:0:0:1:L:<? $quup[\"quupempr\"][\"direccion\"] ?>]\r\n [p:3:0:40:0:0:1:L:<? $quup[\"quupempr\"][\"cod_postal\"].\" \".$quup[\"quupempr\"][\"poblacion\"] ?>]\r\n [p:3:1:40:0:0:1:L:<? $quup[\"quupempr\"][\"provincia\"] ?>]\r\n [p:3:2:40:0:0:1:L:<? \"Tef.\".$quup[\"quupempr\"][\"telefono\"] ?>]\r\n [p:3:3:40:0:0:1:L:<? \"Fax \".$quup[\"quupempr\"][\"fax\"] ?>]\r\n [p:3:5:40:0:0:1:L:<? $quup[\"quupempr\"][\"web\"] ?>]\r\n [p:2:7:0:0:0:1:L:<? \"Consignatario :\" ?>]\r\n [p:2:9:0:0:0:1:L:<? \"Domicilio :\" ?>]\r\n [p:2:12:0:0:0:1:L:<? \"Núm. de Bultos:\" ?>]\r\n [p:2:12:40:0:0:1:L:<? \"Peso Neto:\" ?>]\r\n [p:2:13:40:0:0:1:L:<? \"Peso Bruto:\" ?>]\r\n [p:2:14:0:0:0:1:L:<? \"Portes :\" ?>]\r\n [p:2:16:0:0:0:1:L:<? \"Mercancías :\" ?>]\r\n [p:2:7:20:0:0:1:L:<? $Rnum_dien_nombre ? $Rnum_dien_nombre : $Rcod_cuenta_nombre ?>]\r\n [p:2:9:20:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_direccion : $Rcod_cuenta_direccion ?>]\r\n [p:2:10:20:0:0:1:L:<? $Rnum_dien_direccion ? ($Rnum_dien_cod_postal . \" \" . $Rnum_dien_poblacion) : ($Rcod_cuenta_cod_postal . \" \" . $Rcod_cuenta_poblacion) ?>]\r\n [p:2:11:20:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_provincia : $Rcod_cuenta_provincia ?>]\r\n [p:2:12:50:0:0:1:L:<? QU_Basic::toNumEdited($Rlineas_peso_neto, 2, true) ?>]\r\n [p:2:13:50:0:0:1:L:<? QU_Basic::toNumEdited($Rlineas_peso, 2, true) ?>]\r\n [p:2:12:15:0:0:1:L:<? QU_Basic::toNumEdited($Rlineas_bultos , 2, true)   ?>]\r\n [p:2:14:10:0:0:1:L:<? $tipo_portes =\"p\" ? \"Pagados \" : \"Debidos\"  ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETIM','ETIQUETAS ENVIO PRODUCTOS','1','prodmovi','etim','','','P','','',0.00,1.00,1.00,32.00,50.00,'',1.00,1.00,32.00,50.00,'ETI','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Arial','',0.00,200.00,'S','N','N','Arial','',0.00,120.00,'N','N','N','Arial','',0.00,130.00,'S','N','N','Arial','',0.00,120.00,'N','S','N','ES','','[i:http//www.solplay.es/etiq/solplay-recicla.jpg:1:42:0:4.5]\r\n[d:type=QRCODE:y=18:x=15: h=12:w=15: fgcolor=222222:bgcolor=FFFFFF:position=1:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".\".trim(substr($Medidas,0,3)).\".\".$this->qRepe ?>]\r\n[p:6:30:12:0:0:1:L:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".\".trim(substr($Medidas,0,3)).\".\".$this->qRepe ?>]\r\n\r\n[p:5:0.3:1:0:0:1:L:<? \"OF: \".$of ?>]\r\n[p:4:2.8:1:0:0:1:L:<? $Rlink_orfa_pedido_cod_serie.\" \".$Rlink_orfa_pedido_numero ?>]\r\n[p:4:6:1:0:0:1:L:<? substr($Rlink_cuenta_nombre,0,30) ?>]\r\n[p:8:9:1:0:0:1:L:<? \"Direccción:\"?>]\r\n[p:6:10.5:5:0:0:1:L:<? $Rlink_dien_direccion ? $Rlink_dien_direccion : $Rlink_cuenta_direccion ?>]\r\n[p:6:12.8:5:0:0:1:L:<? $Rlink_dien_direccion ? ($Rlink_dien_cod_postal . \" \" . $Rlink_dien_poblacion) : ($Rlink_cuenta_cod_postal . \" \" . $Rlink_cuenta_poblacion) ?>]\r\n[p:6:14.2:5:0:0:1:L:<? $Rlink_dien_direccion ? $Rlink_dien_provincia : $Rlink_cuenta_provincia ?>]\r\n[p:7:16.3:1:0:0:1:L:<? \"S/Ref.: \".substr($Rlink_pedido_su_documento,0,30) ?>]\r\n[p:7:17.5:38:0:0:1:L:<? \"Bulto: \".$this->qRepe.\" \" /*.QU_Basic::toNumEdited($bultos,0)*/ ?>]\r\n\r\n','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETIN','ETIQUETAS DE LONAS CONFECCION','1','prodmovi','etim','','','P','','',0.00,1.00,1.00,35.00,50.00,'',1.00,1.00,35.00,50.00,'ETI','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Arial','',0.00,200.00,'S','N','N','Arial','',0.00,130.00,'N','N','N','Arial','',0.00,130.00,'S','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[i:http//www.solplay.es/etiq/solplay-recicla.jpg:1:42:0:4.5]\r\n[d:type=QRCODE:y=18.5:x=15: h=12:w=15: fgcolor=222222:bgcolor=FFFFFF:position=C:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".\".trim(substr($Medidas,0,3)).\".\".$this->qRepe ?>]\r\n[p:6:32:14:0:0:1:L:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".\".trim(substr($Medidas,0,3)).\".\".$this->qRepe ?>]\r\n\r\n[p:5:0.3:1:0:0:1:L:<? \"OF: \".$of ?>]\r\n[p:4:3:1:0:0:1:L:<? $Rlink_orfa_pedido_cod_serie.\" \".$Rlink_orfa_pedido_numero ?>]\r\n[p:4:6:1:0:0:1:L:<? substr($Rlink_cuenta_nombre,0,30) ?>] \r\n \r\n[p:4:10:1:0:0:1:L:<? $Rof_nombre ?>]\r\n[p:6:11.8:1:0:0:1:L:<? \"Medidas: \".$Medidas ?>] \r\n[p:6:13.5:1:0:0:1:L:<? $ModeloTela ?>]\r\n[p:7:16.3:1:0:0:1:L:<? \"S/Ref.: \".substr($Rlink_pedido_su_documento,0,30) ?>]\r\n[p:7:17.5:38:0:0:1:L:<? \"Bulto: \".$this->qRepe ?>]\r\n \r\n','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETOC','Etiquetas de Recepción de Compras por Bultos de Cabecera','1','cialdoco','etoc','','','P','','',3.00,0.00,7.00,72.00,80.00,'',7.00,2.00,10.00,40.00,'A4','P',0.00,'15','6','N','Courier','',0.00,30.00,'N','N','N','Courier','',0.00,50.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,150.00,'N','N','N','Courier','',0.00,200.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[p:2:1:0:0:0:1:L:<? \"Etiqueta:\" ?>]\r\n[p:2:2:0:0:0:1:L:<? \"Fecha de entrada:\" ?>]\r\n[p:2:3:0:0:0:1:L:<? \"Producto:\" ?>]\r\n[p:2:4:0:0:0:1:L:<? \"Lote:\" ?>]\r\n[p:2:5:0:0:0:1:L:<? \"Proveedor:\" ?>]\r\n[p:2:1:15:0:0:1:L:<? $this->qRepe.\"/\".((int)$Rlineas_bultos) ?>]\r\n[p:2:2:15:0:0:1:L:<? QU_Basic::toDateEdited($fecha) ?>]\r\n[p:2:3:15:0:0:1:L:<? $Rlineas_cod_articulo.\"; \".$Rlineas_nombre ?>]\r\n[p:2:4:15:0:0:1:L:<? $Rlineas_num_lote ?>]\r\n[p:2:5:15:0:0:1:L:<? ((int)substr($cod_cuenta,4)).\"; \".$Rcod_cuenta_nombre ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETOL','Etiquetas de Recepción de Compras por Bultos de Líneas','1','cialdoco','etol','','1','P','','',0.00,0.00,1.00,7.00,40.00,'',1.00,1.00,7.00,40.00,'ETI2','P',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,50.00,'N','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,150.00,'N','N','N','Arial','',0.00,180.00,'S','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,80.00,'S','N','N','Arial','',0.00,100.00,'N','N','N','ES','','[p:5:0:0:0:0:1:L:<? \"L\".$Rlineas_num_lote ?>]\r\n[p:2:2.2:0:0:28:1:L+:<? $Rcod_cuenta_nombre ?>]\r\n\r\n[p:2:1:23:0:0:1:L:<? $Rlineas_cod_articulo ?>]\r\n[p:7:3:0:0:35:0.8:L+:<? substr($Rlineas_nombre,0,40) ?>]\r\n[a:type=ean13:y=4.8:x=-1:h=2.5:w=20:wb=0.7:view=1:<? $Rarticulo_cod_barras ?>]\r\n[a:type=ean13:y=4.8:x=22:h=2.5:w=15:wb=0.7:view=1:<? $Rlote_cod_lote ?>]\r\n\r\n\r\n\r\n\r\n','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETOP','Etiquetas para Exposición, de Recepción de Compras por Bultos de Líneas','1','cialdoco','etol','','','P','','',0.00,0.00,0.00,7.00,30.00,'',1.00,1.00,7.00,30.00,'ETI','P',0.00,'15','6','N','Courier','',0.00,30.00,'N','N','N','Courier','',0.00,50.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,150.00,'N','N','N','Courier','',0.00,200.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[p:3:0.5:0:2:30:0.8:C:<? $Rlineas_nombre ?>]\r\n[p:3:2.2:0:1:30:1:C:<? $Rcombinacion_cod_referencia ? $Rcombinacion_cod_referencia : $Rlineas_cod_articulo ?>]\r\n[a:type=code128a:y=40:x=15:h=20:w=1.5:wb=0.8:view=0:<? $Rcombinacion_cod_referencia ? $Rcombinacion_cod_referencia : $Rlineas_cod_articulo ?>]\r\n[p:4:5.5:0:1:30:1:C:<? \"P.V.P. \".QU_Basic::getValuePrecioFromArtiComb(\"preivi_mone\",\"EUR\", date(\"Ymd\"), array(\"cod_articulo\"=>$Rlineas_cod_articulo, \"id_maescombart\"=>$Rlineas_id_maescombart), \"\", \"c\", \"430000000\", 1).\" eur\" ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETQM','ETIQUETAS ENVIO PRODUCTOS (copia)','1','prodmovi','etim','','','P','','',0.00,1.00,1.00,32.00,50.00,'',1.00,1.00,32.00,50.00,'ETI','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Arial','',0.00,200.00,'S','N','N','Arial','',0.00,120.00,'N','N','N','Arial','',0.00,130.00,'S','N','N','Arial','',0.00,120.00,'N','S','N','ES','','[i:http//www.solplay.es/etiq/solplay-recicla.jpg:1:42:0:4.5]\r\n[d:type=QRCODE:y=18:x=15: h=12:w=15: fgcolor=222222:bgcolor=FFFFFF:position=1:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".100.\".$this->qRepe ?>]\r\n[p:6:30:14:0:0:1:L:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".100.\".$this->qRepe ?>]\r\n\r\n[p:5:0.3:1:0:0:1:L:<? \"OF: \".$of ?>]\r\n[p:4:2.8:1:0:0:1:L:<? $Rlink_orfa_pedido_cod_serie.\" \".$Rlink_orfa_pedido_numero ?>]\r\n[p:4:6:1:0:0:1:L:<? substr($Rlink_cuenta_nombre,0,30) ?>]\r\n[p:8:9:1:0:0:1:L:<? \"Direccción:\"?>]\r\n[p:6:10.5:5:0:0:1:L:<? $Rlink_dien_direccion ? $Rlink_dien_direccion : $Rlink_cuenta_direccion ?>]\r\n[p:6:12.8:5:0:0:1:L:<? $Rlink_dien_direccion ? ($Rlink_dien_cod_postal . \" \" . $Rlink_dien_poblacion) : ($Rlink_cuenta_cod_postal . \" \" . $Rlink_cuenta_poblacion) ?>]\r\n[p:6:14.2:5:0:0:1:L:<? $Rlink_dien_direccion ? $Rlink_dien_provincia : $Rlink_cuenta_provincia ?>]\r\n[p:7:16.3:1:0:0:1:L:<? \"S/Ref.: \".substr($Rlink_pedido_su_documento,0,30) ?>]\r\n[p:7:17.5:38:0:0:1:L:<? \"Bulto: \".$this->qRepe.\" \" /*.QU_Basic::toNumEdited($bultos,0)*/ ?>]\r\n\r\n','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETQN','ETIQUETAS DE LONAS CONFECCION (copia)','1','prodmovi','etim','','','P','','',0.00,1.00,1.00,35.00,50.00,'',1.00,1.00,35.00,50.00,'ETI','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Arial','',0.00,200.00,'S','N','N','Arial','',0.00,130.00,'N','N','N','Arial','',0.00,130.00,'S','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[i:http//www.solplay.es/etiq/solplay-recicla.jpg:1:42:0:4.5]\r\n[d:type=QRCODE:y=18.5:x=15: h=12:w=15: fgcolor=222222:bgcolor=FFFFFF:position=C:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".100.\".$this->qRepe ?>]\r\n[p:6:32:14:0:0:1:L:<? substr($Rlink_orfa_pedido_anyo,2,2).\".\".substr(strtoupper($Rlink_orfa_pedido_cod_serie),0,1).$Rlink_orfa_pedido_numero.\".\".$of.\".\".$fase.\".100.\".$this->qRepe ?>]\r\n\r\n[p:5:0.3:1:0:0:1:L:<? \"OF: \".$of ?>]\r\n[p:4:3:1:0:0:1:L:<? $Rlink_orfa_pedido_cod_serie.\" \".$Rlink_orfa_pedido_numero ?>]\r\n[p:4:6:1:0:0:1:L:<? substr($Rlink_cuenta_nombre,0,30) ?>] \r\n \r\n[p:4:10:1:0:0:1:L:<? $Rof_nombre ?>]\r\n[p:6:12:1:0:0:1:L:<? \"Medidas: \".$Medidas ?>] \r\n[p:6:13.5:1:0:0:1:L:<? $ModeloTela ?>]\r\n[p:7:16.3:1:0:0:1:L:<? \"S/Ref.: \".substr($Rlink_pedido_su_documento,0,30) ?>]\r\n[p:7:17.5:38:0:0:1:L:<? \"Bulto: \".$this->qRepe ?>]\r\n \r\n','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('ETQP','ETIQUETAS ENVIO PEDIDO','1','cialdoco','etim','','','P','','',0.00,1.00,1.00,32.00,50.00,'',1.00,1.00,32.00,50.00,'ETI','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,100.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Arial','',0.00,200.00,'S','N','N','Arial','',0.00,120.00,'N','N','N','Arial','',0.00,130.00,'S','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[i:http//www.solplay.es/etiq/solplay-recicla.jpg:8:42:0:4.5]\r\n\r\n[d:type=QRCODE:y=17:x=15: h=12:w=15: fgcolor=222222:bgcolor=FFFFFF:position=1:<? substr($anyo,2,2).\".\".substr(strtoupper($cod_serie),0,1).$numero.\".\".$of.\".\".$fase.\"..\".$this->qRepe ?>]\r\n[p:4:29:15:0:0:1:L:<? substr($anyo,2,2).\".\".substr(strtoupper($cod_serie),0,1).$numero.\".\".$of.\".\".$fase.\"..\".$this->qRepe ?>]\r\n[p:3:0.3:37:0:0:1:L:<? substr($anyo,2,2).\".\".substr(strtoupper($cod_serie),0,1).$numero.\".\".$of.\".\".$fase.\"..\".$this->qRepe ?>]\r\n[p:5:1:1:0:0:1:L:<? \"Pedido: \".$cod_serie.\" \".$numero ?>]\r\n[p:4:5:1:0:0:1:L:<? substr($Rcod_cuenta_nombre,0,30) ?>]\r\n[p:6:7:1:0:0:1:L:<? \"Direccción: \"?>]\r\n[p:6:8.5:5:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_direccion : $Rcod_cuenta_direccion ?>]\r\n[p:6:10.8:5:0:0:1:L:<? $Rnum_dien_direccion ? ($Rnum_dien_cod_postal . \" \" . $Rlink_dien_poblacion) : ($Rcod_cuenta_cod_postal . \" \" . $Rcod_cuenta_poblacion) ?>]\r\n[p:6:12.2:5:0:0:1:L:<? $Rnum_dien_direccion ? $Rnum_dien_provincia : $Rcod_cuenta_provincia ?>]\r\n[p:7:15.5:1:0:0:1:L:<? \"S/Ref.: \".substr($su_documento,0,30) ?>]\r\n[p:7:15.5:34:0:0:1:L:<? \"Bulto: \".$this->qRepe.\" / \" .QU_Basic::toNumEdited($bultos,0) ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('PROD','ETIQUETAS PRODUCTOS','1','maesarti','','','','P','','',0.00,1.00,2.00,17.00,50.00,'',1.00,1.00,17.00,50.00,'ETI2','L',0.00,'15','6','N','Arial','',0.00,30.00,'N','N','N','Arial','',0.00,60.00,'N','N','N','Arial','',0.00,80.00,'N','N','N','Arial','',0.00,150.00,'S','N','N','Arial','',0.00,250.00,'S','N','N','Arial','',0.00,120.00,'N','N','N','Arial','',0.00,150.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[i:5-quupimgs(id_quupimgs):0:28:0:18]\r\n[i:http//www.solplay.es/etiq/solplay-recicla.jpg:0.5:0:0:3.5]\r\n[p:5:4.5:1:0:0:1:L:<? $cod_articulo ?>]\r\n[p:7:8:1:0:0:1:L:<? $nombre?>]\r\n[a:type=ean13:y=10:x=0:h=7:w=25:wb=0.7:view=1:<? $cod_barras ?>]\r\n[p:5:9.7:27:0:0:1:L:<? \'L-\'.$this->textoLibre?>]\r\n[a:type=ean13:y=12:x=26:h=5:w=20:wb=0.4:view=1:<? $this->textoLibre ?>]','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0),('RECL','Resumen Cliente','1','maescuen','1','','','P','','',5.00,5.00,7.00,100.00,80.00,'',0.00,0.00,0.00,0.00,'A4','P',0.00,'15','6','N','Courier','',0.00,30.00,'N','N','N','Courier','',0.00,50.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,150.00,'N','N','N','Courier','',0.00,200.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','Courier','',0.00,100.00,'N','N','N','ES','','[p:3:1:0:8:40:1.2:L:<? \"Cliente: \". $cod_cuenta ?>][p:3:1:13:8:40:1.2:L:<? $nombre ?>][p:3:1:50:8:40:1.2:L:<? \"Riesgos\" ?>]\r\n[p:3:2:0:8:40:1.2:L:<? \"Estad.1: \". $cod_esta_1 ?>][p:3:2:13:8:40:1.2:L:<? $Rcod_esta_1_nombre ?>][p:3:2:50:8:40:1.2:L:<? \"Concedido:  \". $imp_rie_euro_1?>]\r\n[p:3:3:0:8:40:1.2:L:<? \"Estad.2: \". $cod_esta_2 ?>][p:3:3:13:8:40:1.2:L:<? $Rcod_esta_2_nombre ?>]\r\n[p:3:3:50:8:40:1.2:L:<? \"Ocupado:    \". QU_Basic::toNumEdited($Rriesgo_ocupado_importe_euro,2)?>]\r\n[p:3:4:0:8:40:1.2:L:<? \"Estad.3: \". $cod_esta_3 ?>][p:3:4:13:8:40:1.2:L:<? $Rcod_esta_3_nombre ?>]\r\n[p:3:4:50:8:40:1.2:L:<? \"Disponible: \" ?>]    [p:3:4:58:8:40:1.2:L:<? $imp_rie_euro_1 - QU_Basic::toNumEdited($Rriesgo_ocupado_importe_euro,2) ?>]\r\n[p:3:5:0:8:40:1.2:L:<? \"Observaciones: \" ?>][p:3:5:13:8:40:1.2:L:<? $this->getSubText(3,$observaciones,0) ?>]\r\n[p:3:9:0:8:40:1.2:L:<? \"Telefono / Fax: \" ?>][p:3:9:13:8:40:1.2:L:<? $telefono. \" / \" . $fax ?>]\r\n[p:3:10:0:8:40:1.2:L:<? \"Agente: \"?>][p:3:10:13:8:40:1.2:L:<? $cod_repres .\"  \". $Rcod_repres_nombre?>][p:3:10:55:8:40:1.2:L:<? \"PPgo/Finc.: \". $dto_fin ?>]\r\n[p:3:11:0:8:40:1.2:L:<? \"Cond. de pago: \"?>][p:3:11:13:8:40:1.2:L:<? $cod_pago ?>][p:3:11:17:8:40:1.2:L:<? $Rcod_pago_nombre ?>][p:3:11:55:8:40:1.2:L:<? \"Vacaciones: \" .$vacaciones_1 .\"  \". $vacaciones_2 ?>]\r\n[p:3:12:0:8:40:1.2:L:<? \"Forma de pago: \"?>][p:3:12:13:8:40:1.2:L:<? $cod_fpago ?>][p:3:12:17:8:40:1.2:L:<? $Rcod_fpago_nombre ?>][p:3:12:55:8:40:1.2:L:<? \"Dias Pago: \". $dias_pago_1.\"  \".$dias_pago_2.\"  \".$dias_pago_3 ?>]\r\n[l:14:0:14:72:1:<? \"M\" ?>]\r\n[p:3:14.5:5:8:40:1.2:L:<? \"Vtas. Ejec.\" ?>][p:3:14.5:15:8:40:1.2:L:<? \"Beneficio\" ?>][p:3:14.5:25:8:40:1.2:L:<? \"Coste\" ?>][p:3:14.5:35:8:40:1.2:L:<? \"Venta\" ?>][p:3:14.5:45:8:40:1.2:L:<? \"Historico\" ?>][p:3:14.5:55:8:40:1.2:L:<? \"Pendientes\" ?>]\r\n[p:3:15.5:0:8:40:1.2:L:<? date(\"Y\").\":\" ?>][p:3:15.5:6:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\"), $cod_cuenta,1),2) ?>][p:3:15.5:15:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\"), $cod_cuenta,2),2)?>][p:3:15.5:24:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\"), $cod_cuenta,3),2)?>][p:3:15.5:35:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\"), $cod_cuenta,4),2) ?>]\r\n\r\n\r\n[p:3:16.5:0:8:40:1.2:L:<? date(\"Y\",strtotime(\"-1 year\", strtotime(date(\"Y\")))).\":\" ?>][p:3:16.5:6:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-1 year\", strtotime(date(\"Y\")))), $cod_cuenta,1),2) ?>][p:3:16.5:15:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-1 year\", strtotime(date(\"Y\")))), $cod_cuenta,2),2)?>][p:3:16.5:24:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-1 year\", strtotime(date(\"Y\")))), $cod_cuenta,3),2)?>][p:3:16.5:35:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-1 year\", strtotime(date(\"Y\")))), $cod_cuenta,4),2) ?>]\r\n\r\n\r\n[p:3:17.5:0:8:40:1.2:L:<? date(\"Y\",strtotime(\"-2 year\", strtotime(date(\"Y\")))).\":\" ?>][p:3:17.5:6:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-2 year\", strtotime(date(\"Y\")))), $cod_cuenta,1),2) ?>][p:3:17.5:15:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-2 year\", strtotime(date(\"Y\")))), $cod_cuenta,2),2)?>][p:3:17.5:24:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-2 year\", strtotime(date(\"Y\")))), $cod_cuenta,3),2)?>][p:3:17.5:35:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-2 year\", strtotime(date(\"Y\")))), $cod_cuenta,4),2) ?>]\r\n\r\n\r\n[p:3:18.5:0:8:40:1.2:L:<? date(\"Y\",strtotime(\"-3 year\", strtotime(date(\"Y\")))).\":\" ?>][p:3:18.5:6:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-3 year\", strtotime(date(\"Y\")))), $cod_cuenta,1),2) ?>][p:3:18.5:15:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-3 year\", strtotime(date(\"Y\")))), $cod_cuenta,2),2)?>][p:3:18.5:24:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-3 year\", strtotime(date(\"Y\")))), $cod_cuenta,3),2)?>][p:3:18.5:35:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-3 year\", strtotime(date(\"Y\")))), $cod_cuenta,4),2) ?>]\r\n\r\n\r\n[p:3:19.5:0:8:40:1.2:L:<? date(\"Y\",strtotime(\"-4 year\", strtotime(date(\"Y\")))).\":\" ?>][p:3:19.5:6:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-4 year\", strtotime(date(\"Y\")))), $cod_cuenta,1),2) ?>][p:3:19.5:15:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-4 year\", strtotime(date(\"Y\")))), $cod_cuenta,2),2)?>][p:3:19.5:24:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-4 year\", strtotime(date(\"Y\")))), $cod_cuenta,3),2)?>][p:3:19.5:35:8:40:1.2:L:<? QU_Basic::toNumEdited($this->oTable->calculaVentas(date(\"Y\",strtotime(\"-4 year\", strtotime(date(\"Y\")))), $cod_cuenta,4),2) ?>]\r\n','CA','','','EN','','','EU','','',1,0,'','',0,0,0,0,0,0,5.00,0,'',0);
/*!40000 ALTER TABLE `quemplim` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

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