public function exportPrepareFields(array $fields)
{
$fields = parent::exportPrepareFields($fields);
$orders_status_id = $fields['orders_status'];
unset($fields['orders_status']);
$fields['orders_status_name'] = $this->getOrdersStatusName($orders_status_id);
return $fields;
}
public function exportPrepareFields(array $fields)
{
global $db;
$products_id = $fields['products_id'];
$products_options_id = $fields['products_options_id'];
unset($fields['products_id'], $fields['products_options_id']);
if (PRODUCTS_OPTIONS_SORT_BY_PRICE == '1') {
$order_by = 'LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name';
} else {
$order_by = 'LPAD(pa.products_options_sort_order,11,"0"), pa.options_values_price';
}
$language_id = $this->languages[DEFAULT_LANGUAGE];
$attrib_info = $db->Execute("SELECT products_options_values_name FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov\n WHERE pa.products_id = {$products_id}\n AND pa.options_id = {$products_options_id}\n AND pa.options_values_id = pov.products_options_values_id\n AND pov.language_id = {$language_id}\n ORDER BY {$order_by}");
$products_options_values_names = array();
while (!$attrib_info->EOF) {
$products_options_values_names[] = $attrib_info->fields['products_options_values_name'];
$attrib_info->MoveNext();
}
$fields['products_options_values_name'] = implode('^', $products_options_values_names);
return parent::exportPrepareFields($fields);
}
public function exportPrepareFields(array $fields)
{
$fields = parent::exportPrepareFields($fields);
$products_id = $fields['products_id'];
$tax_class_id = $fields['products_tax_class_id'];
unset($fields['products_id'], $fields['products_tax_class_id']);
$default_language_code = $this->first_language_code;
global $db;
if ($this->export_language == 'all') {
$this->debugMessage('Products::exportPrepareFields, language = ' . $this->export_language . ', default language = ' . $default_language_code . ', sql: ' . $this->saved_data['products_description_sql'] . ', languages: ' . print_r($this->languages, true));
foreach ($this->languages as $language_code => $language_id) {
if ($language_code != $default_language_code) {
$description_info = $db->Execute(sprintf($this->saved_data['products_description_sql'], $products_id, $language_id));
if (!$description_info->EOF) {
$encoded_fields = $this->exportEncodeData($description_info->fields);
foreach ($encoded_fields as $field_name => $field_value) {
if ($field_name != 'products_id' && $field_name != 'language_id') {
$fields[$field_name . '_' . $language_code] = $field_value;
}
}
}
}
}
}
$fields['manufacturers_name'] = zen_get_products_manufacturers_name($products_id);
$tax_class_info = $db->Execute("SELECT tax_class_title FROM " . TABLE_TAX_CLASS . " WHERE tax_class_id = {$tax_class_id} LIMIT 1");
$fields['tax_class_title'] = $tax_class_info->EOF ? '' : $tax_class_info->fields['tax_class_title'];
$cPath_array = explode('_', zen_get_product_path($products_id));
$default_language_id = $this->languages[DEFAULT_LANGUAGE];
$categories_name = '';
foreach ($cPath_array as $next_category_id) {
$category_info = $db->Execute("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = {$next_category_id} AND language_id = {$default_language_id} LIMIT 1");
$categories_name .= ($category_info->EOF ? self::DBIO_UNKNOWN_VALUE : $category_info->fields['categories_name']) . '^';
}
$fields['categories_name'] = $this->exportEncodeData(substr($categories_name, 0, -1));
return $fields;
}
public function exportPrepareFields(array $fields)
{
$fields = parent::exportPrepareFields($fields);
unset($fields['products_id'], $fields['featured_id']);
return $fields;
}
