Detalles
Fecha	2017-01-04 21:54:37 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Fecha	Tiempo	Línea	Acción	Comentario
Procesadas 82 líneas
2017-01-04	21:54:37	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2017-01-04	21:54:37	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2017-01-04	21:54:37	0	[DEBUG]	CSVI Pro Versión:@version@
2017-01-04	21:54:37	0	[DEBUG]	Versión de Joomla!: 3.6.5
2017-01-04	21:54:37	0	[DEBUG]	Versión PHP: 5.6.25
2017-01-04	21:54:37	0	[DEBUG]	=========================
2017-01-04	21:54:37	0	[DEBUG]	action: export
2017-01-04	21:54:37	0	[DEBUG]	component: com_virtuemart
2017-01-04	21:54:37	0	[DEBUG]	operation: order
2017-01-04	21:54:37	0	[DEBUG]	override:
2017-01-04	21:54:37	0	[DEBUG]	localpath: /home/comenara/public_html
2017-01-04	21:54:37	0	[DEBUG]	ftphost:
2017-01-04	21:54:37	0	[DEBUG]	ftpport:
2017-01-04	21:54:37	0	[DEBUG]	ftproot:
2017-01-04	21:54:37	0	[DEBUG]	ftpfile:
2017-01-04	21:54:37	0	[DEBUG]	export_email_subject: Previsión de pedidos
2017-01-04	21:54:37	0	[DEBUG]	export_email_body:
Este es un e-mail automático que envía la web.

Se adjunta un documento con pedidos confirmados hasta la fecha y hora de este e-mail.

Pedidos para sacar en el próximo envío.

2017-01-04	21:54:37	0	[DEBUG]	export_filename:
2017-01-04	21:54:37	0	[DEBUG]	export_file: html
2017-01-04	21:54:37	0	[DEBUG]	field_delimiter: ,
2017-01-04	21:54:37	0	[DEBUG]	text_enclosure: "
2017-01-04	21:54:37	0	[DEBUG]	include_column_headers: Sí
2017-01-04	21:54:37	0	[DEBUG]	signature: No
2017-01-04	21:54:37	0	[DEBUG]	publish_state:
2017-01-04	21:54:37	0	[DEBUG]	recordstart:
2017-01-04	21:54:37	0	[DEBUG]	recordend:
2017-01-04	21:54:37	0	[DEBUG]	export_date_format: d/m/Y H:i:s
2017-01-04	21:54:37	0	[DEBUG]	export_price_format_decimal: 2
2017-01-04	21:54:37	0	[DEBUG]	export_price_format_decsep: .
2017-01-04	21:54:37	0	[DEBUG]	export_price_format_thousep:
2017-01-04	21:54:37	0	[DEBUG]	header:
2017-01-04	21:54:37	0	[DEBUG]	body:
2017-01-04	21:54:37	0	[DEBUG]	footer:
2017-01-04	21:54:37	0	[DEBUG]	language: es-ES
2017-01-04	21:54:37	0	[DEBUG]	splitorderline: Sí
2017-01-04	21:54:37	0	[DEBUG]	ordernostart:
2017-01-04	21:54:37	0	[DEBUG]	ordernoend:
2017-01-04	21:54:37	0	[DEBUG]	orderlist:
2017-01-04	21:54:37	0	[DEBUG]	orderdaterange:
2017-01-04	21:54:37	0	[DEBUG]	orderdatestart:
2017-01-04	21:54:37	0	[DEBUG]	orderdateend:
2017-01-04	21:54:37	0	[DEBUG]	ordermdatestart:
2017-01-04	21:54:37	0	[DEBUG]	ordermdateend:
2017-01-04	21:54:37	0	[DEBUG]	1: C
2017-01-04	21:54:37	0	[DEBUG]	order_address: BTST
2017-01-04	21:54:37	0	[DEBUG]	orderpricestart:
2017-01-04	21:54:37	0	[DEBUG]	orderpriceend:
2017-01-04	21:54:37	0	[DEBUG]	groupbyfields:
2017-01-04	21:54:37	0	[DEBUG]	sortfields: {"name":["order_item_sku"]}
2017-01-04	21:54:37	0	[DEBUG]	use_system_limits: No
2017-01-04	21:54:37	0	[DEBUG]	max_execution_time:
2017-01-04	21:54:37	0	[DEBUG]	memory_limit:
2017-01-04	21:54:37	0	[DEBUG]	csvi_template_id: 10
2017-01-04	21:54:37	0	[DEBUG]	tags:
2017-01-04	21:54:37	0	[DEBUG]	=========================
2017-01-04	21:54:37	0	[DEBUG]	Export field: Referencia
2017-01-04	21:54:37	0	[DEBUG]	Export field: Cantidad
2017-01-04	21:54:37	0	[DEBUG]	Export field: País de Destino
2017-01-04	21:54:37	0	[DEBUG]	Export query
SELECT `order_number`,
`product_attribute`,
`order_item_sku`,
`order_item_name`,
`product_quantity`,
COALESCE(`user_info2`.`virtuemart_country_id`, `user_info1`.`virtuemart_country_id`) AS `virtuemart_country_id`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info2` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info2`.`virtuemart_order_id` AND `user_info2`.`address_type` = 'ST'
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`
LEFT JOIN `#__virtuemart_products` ON `#__virtuemart_products`.`product_sku` = `#__virtuemart_order_items`.`order_item_sku`
WHERE `#__virtuemart_orders`.`order_status` IN ('Z','C') AND `user_info1`.`address_type` = 'BT'
ORDER BY `order_item_sku`