function zen_get_categories_products_list($categories_id, $include_deactivated = false, $include_child = true)
{
global $db;
global $categories_products_id_list;
if ($include_deactivated) {
$products = $db->Execute("select p.products_id\r\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\r\n where p.products_id = p2c.products_id\r\n and p2c.categories_id = '" . (int) $categories_id . "'");
} else {
$products = $db->Execute("select p.products_id\r\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\r\n where p.products_id = p2c.products_id\r\n and p.products_status = '1'\r\n and p2c.categories_id = '" . (int) $categories_id . "'");
}
while (!$products->EOF) {
// categories_products_id_list keeps resetting when category changes ...
// echo 'Products ID: ' . $products->fields['products_id'] . '<br>';
$categories_products_id_list[] = $products->fields['products_id'];
$products->MoveNext();
}
if ($include_child) {
$childs = $db->Execute("select categories_id from " . TABLE_CATEGORIES . "\r\n where parent_id = '" . (int) $categories_id . "'");
if ($childs->RecordCount() > 0) {
while (!$childs->EOF) {
zen_get_categories_products_list($childs->fields['categories_id'], $include_deactivated);
$childs->MoveNext();
}
}
}
$products_id_listing = $categories_products_id_list;
return $products_id_listing;
}
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: new_products.php 8730 2008-06-28 01:31:22Z drbyte $
*/
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
// initialize vars
$categories_products_id_list = '';
$list_of_products = '';
$new_products_query = '';
$display_limit = zen_get_new_date_range();
if ($manufacturers_id > 0 && $_GET['filter_id'] == 0 || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0 || (!isset($new_products_category_id) || $new_products_category_id == '0')) {
$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,\n p.products_date_added, p.products_price, p.products_type, p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and p.products_status = 1 " . $display_limit;
} else {
// get all products and cPaths in this subcat tree
$productsInCategory = zen_get_categories_products_list($manufacturers_id > 0 && $_GET['filter_id'] > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath, false, true, 0, $display_limit);
if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {
// build products-list string to insert into SQL query
foreach ($productsInCategory as $key => $value) {
$list_of_products .= $key . ', ';
}
$list_of_products = substr($list_of_products, 0, -2);
// remove trailing comma
$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,\n p.products_date_added, p.products_price, p.products_type, p.master_categories_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and p.products_status = 1\n and p.products_id in (" . $list_of_products . ")";
}
}
if ($new_products_query != '') {
$new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS);
}
$row = 0;
$col = 0;
function zen_get_categories_products_list($categories_id, $include_deactivated = false, $include_child = true, $parent_category = '0', $display_limit = '')
{
global $db;
global $categories_products_id_list;
$childCatID = str_replace('_', '', substr($categories_id, strrpos($categories_id, '_')));
$current_cPath = ($parent_category != '0' ? $parent_category . '_' : '') . $categories_id;
$sql = "select p.products_id\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n where p.products_id = p2c.products_id\n and p2c.categories_id = '" . (int) $childCatID . "'" . ($include_deactivated ? " and p.products_status = 1" : "") . $display_limit;
$products = $db->Execute($sql);
while (!$products->EOF) {
$categories_products_id_list[$products->fields['products_id']] = $current_cPath;
$products->MoveNext();
}
if ($include_child) {
$sql = "select categories_id from " . TABLE_CATEGORIES . "\n where parent_id = '" . (int) $childCatID . "'";
$childs = $db->Execute($sql);
if ($childs->RecordCount() > 0) {
while (!$childs->EOF) {
zen_get_categories_products_list($childs->fields['categories_id'], $include_deactivated, $include_child, $current_cPath, $display_limit);
$childs->MoveNext();
}
}
}
return $categories_products_id_list;
}
if ($data !== false) {
foreach ($data as $key => $d) {
$data[$key] = mb_convert_encoding($d, MODULE_PRODUCT_CSV_EXPORT_CHARACTER, MODULE_PRODUCT_CSV_INTERNAL_CHARACTER);
$data[$key] = str_replace("\r\n", "\n", $data[$key]);
}
File_CSV::write($tempfile, $data, $conf);
}
}
}
}
break;
case 3:
$prefix = 'options_';
// get products_id
$categories_products_id_list = array();
$products_ids = zen_get_categories_products_list($_POST['category_id'], true, true);
$products_ids = array_unique($products_ids);
// write line
foreach ($products_ids as $val) {
$attributes_ids = zen_get_attributes($val);
foreach ($attributes_ids as $id) {
$data = $ProductCSV->getExportDataOption($id, $format);
if (count($data) == 0) {
continue;
}
foreach ($data as $key => $d) {
$data[$key] = mb_convert_encoding($d, MODULE_PRODUCT_CSV_EXPORT_CHARACTER, MODULE_PRODUCT_CSV_INTERNAL_CHARACTER);
$data[$key] = str_replace("\r\n", "\n", $data[$key]);
}
File_CSV::write($tempfile, $data, $conf);
}
