' );
$exclusion->save( $HTTP_POST_VARS['selected_'.$type] );
tep_redirect( tep_href_link( FILENAME_DISCOUNT_COUPONS, 'cID='.$coupons_id.'&message='.MESSAGE_DISCOUNT_COUPONS_EXCLUSIONS_SAVED ) );
break;
case 'Cancel':
break;
}
tep_redirect( tep_href_link( FILENAME_DISCOUNT_COUPONS, 'cID='.$coupons_id ) );
} else {
$display_fields = array_keys( $display_fields[$type], true );
$display_fields = ( count( $display_fields ) > 0 ? ', '.implode( ', ', $display_fields ) : '' );
switch( $type ) {
case 'customers':
$sql_selected = 'SELECT dc2c.customers_id AS id'.$display_fields.'
FROM '.TABLE_DISCOUNT_COUPONS_TO_CUSTOMERS.' dc2c
LEFT JOIN '.TABLE_CUSTOMERS.' c
ON c.customers_id=dc2c.customers_id
WHERE dc2c.coupons_id="'.$coupons_id.'"';
$sql_all = 'SELECT c.customers_id AS id'.$display_fields.'
FROM '.TABLE_CUSTOMERS.' c
%s';
$where = ' WHERE c.customers_id NOT IN( %s ) ';
break;
case 'categories':
$sql_selected = 'SELECT dc2c.categories_id AS id'.$display_fields.'
FROM '.TABLE_DISCOUNT_COUPONS_TO_CATEGORIES.' dc2c
LEFT JOIN '.TABLE_CATEGORIES_DESCRIPTION.' cd
ON cd.categories_id=dc2c.categories_id
LEFT JOIN '.TABLE_CATEGORIES.' c
ON c.categories_id=cd.categories_id
WHERE dc2c.coupons_id="'.$coupons_id.'"
AND cd.language_id='.(int)$languages_id;
$sql_all = 'SELECT c.categories_id AS id'.$display_fields.'
FROM '.TABLE_CATEGORIES_DESCRIPTION.' cd
LEFT JOIN '.TABLE_CATEGORIES.' c
ON c.categories_id=cd.categories_id
WHERE cd.language_id='.(int)$languages_id.'
%s';
$where = ' AND c.categories_id NOT IN( %s ) ';
break;
case 'manufacturers':
$sql_selected = 'SELECT m.manufacturers_id AS id'.$display_fields.'
FROM '.TABLE_DISCOUNT_COUPONS_TO_MANUFACTURERS.' dc2m
LEFT JOIN '.TABLE_MANUFACTURERS.' m
ON m.manufacturers_id=dc2m.manufacturers_id
WHERE dc2m.coupons_id="'.$coupons_id.'"';
/*$sql_selected = 'SELECT m.manufacturers_id AS id'.$display_fields.'
FROM '.TABLE_DISCOUNT_COUPONS_TO_MANUFACTURERS.' dc2m
LEFT JOIN '.TABLE_MANUFACTURERS.' m
ON m.manufacturers_id=dc2m.manufacturers_id
LEFT JOIN '.TABLE_MANUFACTURERS_INFO.' mi
ON mi.manufacturers_id=m.manufacturers_id
WHERE dc2m.coupons_id="'.$coupons_id.'"
AND mi.languages_id='.(int)$languages_id;*/
/*$sql_all = 'SELECT m.manufacturers_id AS id'.$display_fields.'
FROM '.TABLE_MANUFACTURERS_INFO.' mi
LEFT JOIN '.TABLE_MANUFACTURERS.' m
ON m.manufacturers_id=mi.manufacturers_id
WHERE mi.languages_id='.(int)$languages_id.'
%s';*/
$sql_all = 'SELECT m.manufacturers_id AS id'.$display_fields.'
FROM '.TABLE_MANUFACTURERS.' m
%s';
$where = ' WHERE m.manufacturers_id NOT IN( %s ) ';
break;
case 'products':
$sql_selected = 'SELECT p.products_id AS id'.$display_fields.'
FROM '.TABLE_DISCOUNT_COUPONS_TO_PRODUCTS.' dc2p
LEFT JOIN '.TABLE_PRODUCTS_DESCRIPTION.' pd
ON pd.products_id=dc2p.products_id
LEFT JOIN '.TABLE_PRODUCTS.' p
ON p.products_id=pd.products_id
WHERE dc2p.coupons_id="'.$coupons_id.'"
AND pd.language_id='.(int)$languages_id;
$sql_all = 'SELECT p.products_id AS id'.$display_fields.'
FROM '.TABLE_PRODUCTS_DESCRIPTION.' pd
LEFT JOIN '.TABLE_PRODUCTS.' p
ON p.products_id=pd.products_id
WHERE pd.language_id='.(int)$languages_id.'
%s';
$where = ' AND p.products_id NOT IN( %s ) ';
break;
case 'zones' :
$sql_selected = 'SELECT dc2z.geo_zone_id AS id'.$display_fields.'
FROM '.TABLE_DISCOUNT_COUPONS_TO_ZONES.' dc2z
LEFT JOIN '.TABLE_GEO_ZONES.' gz
USING( geo_zone_id )
WHERE dc2z.coupons_id="'.$coupons_id.'"';
$sql_all = 'SELECT gz.geo_zone_id AS id'.$display_fields.'
FROM '.TABLE_GEO_ZONES.' gz
%s';
$where = 'WHERE gz.geo_zone_id NOT IN(%s) ';
break;
}
if( ( $selected_ids = $exclusion->get_selected_options( $sql_selected, $separator/*category exclusions*/, $category_separator, ( $type == 'categories' ? $category_path : false )/*end category exclusions*/ ) ) === false ) tep_redirect( tep_href_link( FILENAME_DISCOUNT_COUPONS, 'cID='.$coupons_id.'&error='.ERROR_DISCOUNT_COUPONS_SELECTED_LIST ) );
$where = ( count( $selected_ids ) > 0 ? sprintf( $where, implode( ', ', $selected_ids ) ) : '' );
$sql_all = sprintf( $sql_all, $where );
//print_r( '