public static function getCategories($cfilter, $cgformat) { global $lC_Database, $lC_Datetime, $lC_Language; // generate file name to use with this file $datetime = ''; // lC_Datetime::getTimestamp(); $filename = 'categories'; // . '-' . $datetime; if ($cgformat == 'tabbed') { $filename = $filename . '.txt'; $delim = "\t"; $seperator = ","; } else { if ($cgformat == 'csv') { $filename = $filename . '.' . $pgformat; $delim = ","; $seperator = ","; } else { return false; } } $filepath = DIR_FS_DOWNLOAD . $filename; // make columns in clude full table names to i can implode into sql statement // add image and category and other product tables to columns and query $sql_columns = array('c.categories_id', 'c.categories_image', 'c.parent_id', 'c.sort_order', 'c.categories_mode', 'c.categories_link_target', 'c.categories_custom_url', 'c.categories_status', 'c.categories_visibility_nav', 'c.categories_visibility_box', 'c.date_added', 'cd.language_id', 'cd.categories_name', 'cd.categories_menu_name', 'cd.categories_blurb', 'cd.categories_description', 'cd.categories_keyword', 'cd.categories_tags'); $columns = array('id', 'image', 'parent_id', 'sort_order', 'mode', 'link_target', 'custom_url', 'status', 'visibility_nav', 'visibility_box', 'date_added', 'language_id', 'name', 'menu_name', 'blurb', 'description', 'keyword', 'tags'); $sql_columns = implode(",", $sql_columns); $sql_statement = 'SELECT ' . $sql_columns . ' FROM :table_categories c, :table_categories_description cd WHERE cd.categories_id = c.categories_id'; $errormsg = ''; // make this section get the data and make a file in work folder for the url to be returned. $Qcategories = $lC_Database->query($sql_statement); $Qcategories->bindTable(':table_categories', TABLE_CATEGORIES); $Qcategories->bindTable(':table_categories_description', TABLE_CATEGORIES_DESCRIPTION); $Qcategories->execute(); if ($lC_Database->isError()) { $errormsg .= $lC_Database->getError(); } $categories = array(); while ($Qcategories->next()) { $categories[] = $Qcategories->toArray(); } // seperate out all categories and images and comma delimited columns $content = ''; foreach ($categories as $category) { $category['date_added'] = lC_Datetime::getShort($category['date_added']); foreach ($category as $column_output) { $content .= trim(preg_replace('/\\s+/', ' ', $column_output)) . $delim; } $content .= "\n"; } $fp = fopen($filepath, "wb"); fwrite($fp, implode($delim, $columns) . "\n" . $content); fclose($fp); return array('filename' => $filename, 'sql_statement' => $sql_statement, 'errors' => $errormsg); }
$output = ''; $show_price = true; $show_buy_now = true; while ($Qlisting->next()) { // VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW $lC_Product = new lC_Product($Qlisting->valueInt('products_id')); if (utility::isB2B() && $lC_Customer->isLoggedOn() === false) { $access = defined('B2B_SETTINGS_GUEST_CATALOG_ACCESS') && B2B_SETTINGS_GUEST_CATALOG_ACCESS > 0 ? (int) B2B_SETTINGS_GUEST_CATALOG_ACCESS : 0; if ($access < 66) { $show_price = false; } if ($access < 99) { $show_buy_now = false; } } if (strtotime($lC_Product->getDateAvailable()) <= strtotime(lC_Datetime::getShort())) { $output .= '<div class="product-listing-module-items">'; for ($col = 0, $n = sizeof($column_list); $col < $n; $col++) { switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $output .= '<div class="product-listing-module-model">' . $lC_Product->getModel() . '</div>' . "\n"; break; case 'PRODUCT_LIST_NAME': if (isset($_GET['manufacturers'])) { $output .= '<div class="product-listing-module-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . '&manufacturers=' . $_GET['manufacturers']), $lC_Product->getTitle()) . '</div>' . "\n" . '<div class="product-listing-module-description">' . lc_clean_html($lC_Product->getBlurb()) . '</div>' . "\n"; } else { $output .= '<div class="product-listing-module-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . ($cPath ? '&cPath=' . $cPath : '')), $lC_Product->getTitle()) . '</div>' . "\n" . '<div class="product-listing-module-description">' . lc_clean_html($lC_Product->getBlurb()) . '</div>' . "\n"; } break; case 'PRODUCT_LIST_MANUFACTURER': if ($lC_Product->hasManufacturer()) {
public function lC_Products_Products() { global $lC_Database, $lC_Services, $lC_Session, $lC_Language, $lC_Breadcrumb, $lC_Product, $lC_Image, $lC_Currencies, $cPath_array; $template_code = isset($_SESSION['template']['code']) && $_SESSION['template']['code'] != NULL ? $_SESSION['template']['code'] : 'core'; if (empty($_GET) === false) { $id = false; // PHP < 5.0.2; array_slice() does not preserve keys and will not work with numerical key values, so foreach() is used foreach ($_GET as $key => $value) { $key = end(explode("/", $key)); if ((preg_match('/^[0-9]+(#?([0-9]+:?[0-9]+)+(;?([0-9]+:?[0-9]+)+)*)*$/', $key) || preg_match('/^[a-zA-Z0-9 -_]*$/', $key)) && $key != $lC_Session->getName()) { $id = $key; } break; } if ($id !== false && lC_Product::checkEntry($id)) { $lC_Product = new lC_Product($id); $lC_Product->incrementCounter(); if (strtotime($lC_Product->getDateAvailable()) <= strtotime(lC_Datetime::getShort())) { $this->addPageTags('description', substr(strip_tags($lC_Product->getDescription()), 0, 300)); $this->addPageTags('keywords', $lC_Product->getTitle()); $this->addPageTags('keywords', $lC_Product->getModel()); if ($lC_Product->hasTags()) { $this->addPageTags('keywords', $lC_Product->getTags()); } $this->addOGPTags('type', 'product'); $this->addOGPTags('title', $lC_Product->getTitle() . ' ' . $lC_Product->getModel()); $this->addOGPTags('description', $lC_Currencies->displayPrice($lC_Product->getPrice(), $lC_Product->getTaxClassID()) . ' - ' . $lC_Product->getTitle() . ' ' . lc_clean_html($lC_Product->getDescription())); $this->addOGPTags('url', lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword(), 'NONSSL', false, true, true)); $this->addOGPTags('image', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . $template_code . '/images/logo.png'); $this->addOGPTags('image', HTTP_SERVER . DIR_WS_CATALOG . $lC_Image->getAddress($lC_Product->getImage(), 'large')); if ($lC_Product->getImages() != '') { foreach ($lC_Product->getImages() as $key => $value) { if ($value['default_flag'] == true) { continue; } if (file_exists(DIR_FS_CATALOG . $lC_Image->getAddress($value['image'], 'popup'))) { $this->addOGPTags('image', HTTP_SERVER . DIR_WS_CATALOG . $lC_Image->getAddress($value['image'], 'large')); } } } lC_Services_category_path::process($lC_Product->getCategoryID()); if (empty($cPath_array) && $_GET['cPath'] == '' && isset($lC_Services) && $lC_Services->isStarted('seo')) { foreach ($_GET as $cats => $values) { $cats = explode("/", $cats); foreach ($cats as $cat) { $Qcid = $lC_Database->query('select item_id from :table_permalinks where permalink = :permalink and type = 1 and language_id = :language_id'); $Qcid->bindTable(':table_permalinks', TABLE_PERMALINKS); $Qcid->bindValue(':permalink', $cat); $Qcid->bindInt(':language_id', $lC_Language->getID()); $Qcid->execute(); $cPath_array[] = $Qcid->valueInt('item_id'); } } } if ($lC_Services->isStarted('breadcrumb')) { if (isset($_GET['cPath']) && $_GET['cPath'] != '') { $path = $_GET['cPath']; } else { $path = implode("_", $cPath_array); } $lC_Breadcrumb->add($lC_Product->getTitle(), lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $path); } $this->_page_title = $lC_Product->getTitle(); } else { $this->_page_title = $lC_Language->get('product_not_found_heading'); $this->_page_contents = 'info_not_available.php'; } } else { $this->_page_title = $lC_Language->get('product_not_found_heading'); $this->_page_contents = 'info_not_found.php'; } } else { $this->_page_title = $lC_Language->get('product_not_found_heading'); $this->_page_contents = 'info_not_found.php'; } }