Reducir margen factura PS 1.5.6.1 (SOLUCIONADO)

[dulantziko]

Hola, 

 

Deseo modificar el espacio que existe en la factura, es el hueco que queda entre los contenidos del header.tpl y el invoice.tpl, adjunto captura para que quede mas claro.

 

¿En que archivo se retoca eso?, tanto en header como invoice no porque tengo todo reducido al maximo.

 

Gracias.

Edited May 24, 2014 by dulantziko (see edit history)

[dulantziko]

foreach ($sub_queries as $sub_query)

{

$query_filters_where .= ' AND p.id_product IN (SELECT pa.`id_product`

FROM `'._DB_PREFIX_.'product_attribute_combination` pac

LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa

ON (pa.`id_product_attribute` = pac.`id_product_attribute`)'.

Shop::addSqlAssociation('product_attribute', 'pa').'

WHERE '.implode(' OR ', $sub_query).') ';

}

 

foreach ($sub_queries as $sub_query)

{

$query_filters_where .= ' AND p.id_product IN (SELECT pa.`id_product`

FROM `'._DB_PREFIX_.'product_attribute_combination` pac

LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa

ON (pa.`id_product_attribute` = pac.`id_product_attribute`)

INNER JOIN `'._DB_PREFIX_.'stock_available` sa

ON (sa.`id_product_attribute` = pac.`id_product_attribute` AND sa.`quantity` > 0)'.

Shop::addSqlAssociation('product_attribute', 'pa').'

WHERE '.implode(' OR ', $sub_query).') ';

}

 

public function indexAttribute($id_product = null)

{

if (is_null($id_product))

Db::getInstance()->execute('TRUNCATE '._DB_PREFIX_.'layered_product_attribute');

else

Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'layered_product_attribute WHERE id_product = '.(int)$id_product);

 

Db::getInstance()->execute('INSERT INTO `'._DB_PREFIX_.'layered_product_attribute` (`id_attribute`, `id_product`, `id_attribute_group`, `id_shop`)

SELECT pac.id_attribute, pa.id_product, ag.id_attribute_group, product_attribute_shop.`id_shop`

FROM '._DB_PREFIX_.'product_attribute pa'.

Shop::addSqlAssociation('product_attribute', 'pa').'

INNER JOIN '._DB_PREFIX_.'product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute

INNER JOIN '._DB_PREFIX_.'attribute a ON (a.id_attribute = pac.id_attribute)

INNER JOIN '._DB_PREFIX_.'attribute_group ag ON ag.id_attribute_group = a.id_attribute_group

'.(is_null($id_product) ? '' : 'AND pa.id_product = '.(int)$id_product).'

GROUP BY a.id_attribute, pa.id_product , product_attribute_shop.`id_shop`');

 

return 1;

}

public function indexAttribute($id_product = null)

{

if (is_null($id_product))

Db::getInstance()->execute('TRUNCATE '._DB_PREFIX_.'layered_product_attribute');

else

Db::getInstance()->execute('

DELETE FROM '._DB_PREFIX_.'layered_product_attribute

WHERE id_product = '.(int)$id_product

);

 

Db::getInstance()->execute('

INSERT INTO `'._DB_PREFIX_.'layered_product_attribute` (`id_attribute`, `id_product`, `id_attribute_group`, `id_shop`)

SELECT pac.id_attribute, pa.id_product, ag.id_attribute_group, product_attribute_shop.`id_shop`

FROM '._DB_PREFIX_.'product_attribute pa'.

Shop::addSqlAssociation('product_attribute', 'pa').'

INNER JOIN '._DB_PREFIX_.'product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute

INNER JOIN '._DB_PREFIX_.'stock_available sa ON (sa.id_product_attribute = pac.id_product_attribute AND sa.quantity > 0)

INNER JOIN '._DB_PREFIX_.'attribute a ON (a.id_attribute = pac.id_attribute)

INNER JOIN '._DB_PREFIX_.'attribute_group ag ON ag.id_attribute_group = a.id_attribute_group

'.(is_null($id_product) ? '' : 'AND pa.id_product = '.(int)$id_product).'

GROUP BY a.id_attribute, pa.id_product , product_attribute_shop.`id_shop`'

);

 

return 1;

}

Edited December 3, 2014 by dulantziko (see edit history)