Community Add-Ons

I added a product name filter to version 1.3.1 without any of the bug fixes that followed this version. Now you can type in part of a products name and get a filtered list.

The package just contains a single file "specials.php" which should be placed in the admin directory. Install version 1.3.1 before adding the file.

so what sundust is saying is make the line look like this :

if(preg_match("/^[0-9]{1,3}([" . $currencies->currencies[DEFAULT_CURRENCY]["decimal_point"] . "][0-9]{1,2" . "})?%$/", $discount))

Line 152 of special_enhances.php

no file

When you have the Decimal Places Currency set to "0", the code doesn't work, you can not use the % function because the result is wrong.

My fix have been the next:

-------------------------------------------------------------
FIND the code:

. intval($currencies->currencies[DEFAULT_CURRENCY]["decimal_places"]) . "

REPLACE with:

2
---------------------------------------------------------------

Now, I have my Decimal Places Currency set to "0" and also I can set my prices with 2 decimals if I want. Of course, no display the decimal because my set is "0" but round the result and the decimal are storaged in the database if I want show them in the fuure.

Regards,
SunDust

Note: No code attached in this contribution

v1.3.1 (29/12/2008) Full Package

- Added quick install (By Denox) overwrite modules/specials.php
- Corrected order of the columns model and product
- Corrected spanish language

-----------------------------------------------

- Añadido instalación rápida (de Denox) sobreescribe modules/specials.php
- Corregido el orden de las columnas "modelo" y "producto"
- Corregido el idioma español

v1.3.1 (29/12/2008) Full Package

- Added quick install (By Denox) overwrite modules/specials.php
- Corrected order of the columns model and product
- Corrected spanish language

-----------------------------------------------

- Añadido instalación rápida (de Denox) sobreescribe modules/specials.php
- Corregido el orden de las columnas "modelo" y "producto"
- Corregido el idioma español

v1.3 (11/11/2008) Full Package
- product name / model sorting added
- spanish language (Thanks to Denox)

Utilizar esta versión, corregido error.

MEJORAS EN EL MÓDULO DE OFERTAS - TRADUCCIÓN ESPAÑOL 1.2.2

15-07-2008 Subi el fichero specials.php mal, ya esta corregido

11-07-2008 Modificacion para Instalación Automática y Traducción al Español

- Modificación de los ficheros para que sobreescriba al módulo actual de Ofertas y no tener que hacer más cambios.
- Traducción de Textos y Botones al Español
- Incluye Captura de Pantalla

********************************

Módulo de Ofertas en Español v 1.2.1

Esta contribuición te permite administrar de forma más facil tus ofertas y descuentos.

- Se puede filtrar los productos por Categorías (podiendo incluir subcategorias) o por Fabricantes.
- Se puede aplicar descuentos (por precio fijo o porcentaje) y poner si es necesario una fecha limite
para que se cancele la oferta automáticamente.
- Forma más rápida y sencilla para poder cambiar los descuentos haciendo una lista de los productos.

*********************
* 1. Instalación
*********************

Solo hay que subir los ficheros al servidor sobreescribiendo los actuales y así cambiamos el módulo
actual de ofertas por el Nuevo.

MEJORAS EN EL MÓDULO DE OFERTAS - TRADUCCIÓN ESPAÑOL 1.2.1

11-07-2008 Modificacion para Instalación Automática y Traducción al Español

- Modificación de los ficheros para que sobreescriba al módulo actual de Ofertas y no tener que hacer más cambios.
- Traducción de Textos y Botones al Español
- Incluye Captura de Pantalla

********************************

Módulo de Ofertas en Español v 1.2.1

Esta contribuición te permite administrar de forma más facil tus ofertas y descuentos.

- Se puede filtrar los productos por Categorías (podiendo incluir subcategorias) o por Fabricantes.
- Se puede aplicar descuentos (por precio fijo o porcentaje) y poner si es necesario una fecha limite
para que se cancele la oferta automáticamente.
- Forma más rápida y sencilla para poder cambiar los descuentos haciendo una lista de los productos.

*********************
* 1. Instalación
*********************

Solo hay que subir los ficheros al servidor sobreescribiendo los actuales y así cambiamos el módulo
actual de ofertas por el Nuevo.

une traduction française pour les textes et les boutons

I needed to add an extra field for model numbers as a few of my product names were similar to others making it difficult to tell the difference between them.

I thought I would share this addition with others as it now works great for me.

I have only updated the language file in English but it is easy enough to change in others.

Attached is the full package with only the English language file. Hope this helps others.

the fix about duplicated headers, shown below by expert, shouldn't be applied. There aren't two headers. They could seem the same but aren't.

The first header refears to all products without considering categories.

The second header is the 'first' main category that contains all the osc categories. It has cPath=0. You can add products to this category so it has to be considered as a normal category.

Fake file attached

Line 19:

Current categories list tree includes 2 headings with @SPECIALS_ENHANCED_CATEGORIES

Lets remove current categories heading, and see only @SPECIALS_ENHANCED_CATEGORIES on top. Otherwise manufacturers selection won't work if you don't switch to first pulldown to top

Find:
$categories_list = array_merge($categories_head, tep_get_category_tree());

Replace with:
$categories_list = array_merge($categories_head, array_slice(tep_get_category_tree(),1));

-----------
no file in zip file...

If like me you need to list specails by model number try this, I made a change or 2 to the admin/specials_enhanced.php.

no rocket science , lines 148 and 150 just change references to TABLE_PRODUCT_DESCRIPTION so they read

TABLE_PRODUCT



and line 200 and 543 references to:

pd.products_name changed to

pd.products_model


After the above changes this line caused an error as the $languages_id variable comes from TABLE_PRODUCTS_DESRIPTION so I just commented it out:



211 $clauses[] = 'pd.language_id = '. (int)$languages_id;




This is probably not the best or cleanest way but it works. Just stick it in your admin folder and try it.


The attached file has the changes made already.

change line 546:

<td width="8%" class="dataTableContent" align="center"><?php if($specials['specials_new_products_price']){echo number_format(-1*($specials['products_price'] - $specials['specials_new_products_price'])*100/$specials['products_price'], intval($currencies->currencies[DEFAULT_CURRENCY]["decimal_places"]), $currencies->currencies[DEFAULT_CURRENCY]["decimal_point"], $currencies->currencies[DEFAULT_CURRENCY]["thousands_point"]).'%';}else{ echo '---';} ?></td>

with

<td width="8%" class="dataTableContent" align="center">
<?php
if($specials['products_price'] >0)
if($specials['specials_new_products_price'])
{
echo number_format(-1*($specials['products_price'] - $specials['specials_new_products_price'])*100/$specials['products_price'], intval($currencies->currencies[DEFAULT_CURRENCY]["decimal_places"]), $currencies->currencies[DEFAULT_CURRENCY]["decimal_point"], $currencies->currencies[DEFAULT_CURRENCY]["thousands_point"]).'%';
}
else
{ echo '---';}
else
{ echo '<b>Price <= 0</b>';}
?>
</td>

v1.2.1 (10/09/2007) Full Package
- buttons images changed: their names could have been in conflict with other contributions

v1.2 (10/09/2007) Full package
- few bug fixes thanks to jestep
- now reflects 100% current currency settings
- Added Dutch translation, specials thanks to frankschoutens.

easy advanced specials admin (v1.1.1) <br>
<b>v1.1.1 (10/07/2007)</b>

- Added Dutch translation !

v1.1.1 (10/07/2007)
- Added German translation, specials thanks to Craxx for his help.

(full package)

v1.1 (09/07/2007)
- now it manages the tax value according to the 'Display prices with tax' global setting.

v1.0.1 (07/07/2007)
- few bugs fixed (thanks to Craxx for his feedback, i was using a modified version of osCommerce)

Enhanced specials admin

This contribution lets you easily administrate your special offers and discounts.

- products filtering by category (can include subcategory products) and / or manufacturers
- can apply discounts (fixed price or percentual) and / or expiration dates at one time
- flexible inline edit of single product discount: can edit directly the rows of the filterd products list.

---------

Gestione avanzata offerte e sconti

Questa contribution permette di gestire gli sconti e le offerte speciali per categoria / produttore / tutti / singolarmente

- filtraggio dei prodotti per categoria (si possono includere anche i prodotti delle sottocategorie) e/o produttore
- applicazione di offerte con prezzo fisso o sconto percentuale alla lista filtrata
- applicazione della data di scadenza alla lista filtrata
- modifica diretta delle singole offerte: è possibile modificare direttamente le singole righe della lista filtrata

---------

05/07/2007
Eugenio Bonifacio (eugh@libero.it) - Comiso (RG) - Italy

The author is not responsible for any damage caused
by the use of this code and any derivatives of it.
So use it at your own risk.

This code is released under the terms of the GNU/GPL v2
http://www.gnu.org/copyleft/gpl.html