GX-Bug #54828 » QuickEditPropertiesTaxFix.patch
| src/GXMainComponents/Services/Core/QuickEdit/Repositories/Reader/QuickEditProductPropertiesReader.inc.php (revision ) | ||
|---|---|---|
| 193 | 193 |
'products_properties_combis.products_properties_combis_id = products_properties_index.products_properties_combis_id'); |
| 194 | 194 |
$this->db->join('products', 'products.products_id = products_properties_index.products_id');
|
| 195 | 195 |
$this->db->join('products_description', 'products_description.products_id = products.products_id');
|
| 196 |
$this->db->join('zones_to_geo_zones', 'zones_to_geo_zones.zone_country_id = ' . (int)STORE_COUNTRY);
|
|
| 197 |
$this->db->join('tax_rates',
|
|
| 198 |
'tax_rates.tax_class_id = products.products_tax_class_id AND tax_rates.tax_zone_id = zones_to_geo_zones.geo_zone_id', |
|
| 199 |
'left'); |
|
| 196 |
$this->db->join('tax_rates', 'tax_rates.tax_class_id = products.products_tax_class_id');
|
|
| 197 |
$this->db->join('zones_to_geo_zones', 'zones_to_geo_zones.zone_country_id = ' . (int)STORE_COUNTRY
|
|
| 198 |
. ' AND tax_rates.tax_zone_id = zones_to_geo_zones.geo_zone_id'); |
|
| 200 |
|
|
| 199 | ||
| 201 | 200 |
$this->db->where('products_description.language_id = languages.languages_id');
|
| 202 | 201 |
$this->db->where('products_properties_index.language_id = languages.languages_id');
|
| 203 | 202 |
} |