function CacheManager(&$base)
{
global $gorumroll, $language, $theme, $gorumrecognised, $gorumjavascript_cache, $gorumcategory;
list($this->timeFrame, $categorySpecific) = $base->getCacheTimeFrameAndCategorySpecificity();
if ($this->timeFrame) {
$this->key = "{$gorumroll->list}-{$gorumroll->method}-{$gorumroll->rollid}-";
$details = "language: {$language}, theme: {$theme}, authentication: ";
hasAdminRights($isAdm);
if ($isAdm) {
$details .= "admin, ";
} elseif ($gorumrecognised) {
$details .= "loggedin, ";
} else {
$details .= "loggedout, ";
}
$s = new Sorting($base);
$details .= " sorting: " . $s->getSortSql();
$classVars = $gorumroll->getClassVars();
if (!empty($classVars["off"])) {
$details .= " offset: {$classVars['off']}";
}
if ($categorySpecific) {
$details .= " category: {$gorumcategory}";
}
//FP::log($details, "Details");
$this->key .= substr(md5($details), 0, 16);
$this->fileName = CACHE_DIR . "/" . $this->key . '.html';
$this->incFileName = CACHE_DIR . "/" . $this->key . '.inc';
if ($this->checkCache()) {
$inc = file_get_contents($this->incFileName);
$gorumjavascript_cache = unserialize($inc);
//FP::log($this, "Loading include cache");
JavaScript::mergeCache($gorumjavascript_cache);
} else {
// Inicializaljuk az inklud kesst:
$gorumjavascript_cache = new JavaScript();
//FP::log($gorumjavascript_cache, "IncCache ujainit");
}
}
}
protected function doSorting(&$children)
{
$orderMethod = Input::get('order', 'name');
$orderDir = Input::get('dir', 'asc');
if (!Sorting::validOrderMethod($orderMethod)) {
$orderMethod = 'name';
}
if (!Sorting::validOrderDirection($orderDir)) {
$orderDir = 'asc';
}
// if the values are default then skip sorting as the paths already in order
if ($orderMethod !== 'name' || $orderDir !== 'asc') {
Sorting::sort($children, $orderMethod, $orderDir);
}
$invOrderDir = $orderDir === 'asc' ? 'desc' : 'asc';
$params = array('orderMethod' => $orderMethod, 'orderDir' => $orderDir, 'invOrderDir' => $invOrderDir);
return $params;
}
/**
* Set up the shop page with products and discounts
*
* @param array $product_ids The optional array of Product IDs.
* Overrides any URL parameters if set
* @return boolean True on success, false otherwise
* @global ADONewConnection $objDatabase Database connection object
* @global array $_ARRAYLANG Language array
* @global array $_CONFIG Core configuration array, see {@link /config/settings.php}
* @global string(?) $themesPages Themes pages(?)
*/
static function view_product_overview($product_ids = null)
{
global $_ARRAYLANG;
// activate javascript shadowbox
\JS::activate('shadowbox');
$flagSpecialoffer = intval(\Cx\Core\Setting\Controller\Setting::getValue('show_products_default', 'Shop'));
if (isset($_REQUEST['cmd']) && $_REQUEST['cmd'] == 'discounts') {
$flagSpecialoffer = Products::DEFAULT_VIEW_DISCOUNTS;
}
$flagLastFive = isset($_REQUEST['lastFive']);
$product_id = isset($_REQUEST['productId']) ? intval($_REQUEST['productId']) : null;
$cart_id = null;
if (isset($_REQUEST['referer']) && $_REQUEST['referer'] == 'cart') {
$cart_id = $product_id;
$product_id = Cart::get_product_id($cart_id);
}
$manufacturer_id = isset($_REQUEST['manufacturerId']) ? intval($_REQUEST['manufacturerId']) : null;
$term = isset($_REQUEST['term']) ? trim(contrexx_input2raw($_REQUEST['term'])) : null;
$category_id = isset($_REQUEST['catId']) ? intval($_REQUEST['catId']) : null;
if (!($product_id || $category_id || $manufacturer_id || $term || $cart_id)) {
// NOTE: This is different from NULL
// in that it enables listing the subcategories
$category_id = 0;
}
// Validate parameters
if ($product_id && empty($category_id)) {
$objProduct = Product::getById($product_id);
if ($objProduct) {
$category_id = $objProduct->category_id();
}
if (isset($_SESSION['shop']['previous_category_id'])) {
$category_id_previous = $_SESSION['shop']['previous_category_id'];
foreach (preg_split('/\\s*,\\s*/', $category_id) as $id) {
if ($category_id_previous == intval($id)) {
$category_id = $category_id_previous;
}
}
}
}
// Remember visited Products
if ($product_id) {
self::rememberVisitedProducts($product_id);
}
$objCategory = null;
if ($category_id && empty($product_id)) {
$objCategory = ShopCategory::getById($category_id);
if (!$objCategory) {
$category_id = null;
}
}
$shopMenu = '<form method="post" action="' . \Cx\Core\Routing\Url::fromModuleAndCmd('Shop', '') . '">' . '<input type="text" name="term" value="' . htmlentities($term, ENT_QUOTES, CONTREXX_CHARSET) . '" style="width:150px;" /> ' . '<select name="catId" style="width:150px;">' . '<option value="0">' . $_ARRAYLANG['TXT_ALL_PRODUCT_GROUPS'] . '</option>' . ShopCategories::getMenuoptions($category_id) . '</select> ' . Manufacturer::getMenu('manufacturerId', $manufacturer_id, true) . '<input type="submit" name="bsubmit" value="' . $_ARRAYLANG['TXT_SEARCH'] . '" style="width:66px;" />' . '</form>';
self::$objTemplate->setGlobalVariable($_ARRAYLANG + array('SHOP_MENU' => $shopMenu, 'SHOP_SEARCH_TERM' => htmlentities($term, ENT_QUOTES, CONTREXX_CHARSET), 'SHOP_CATEGORIES_MENUOPTIONS' => ShopCategories::getMenuoptions($category_id, true, 0, true), 'SHOP_MANUFACTURER_MENUOPTIONS' => Manufacturer::getMenuoptions($manufacturer_id, true)));
// Only show the cart info when the JS cart is not active!
global $_CONFIGURATION;
if (empty($_CONFIGURATION['custom']['shopJsCart'])) {
self::$objTemplate->setVariable(array('SHOP_CART_INFO' => self::cart_info()));
}
// Exclude Category list from search results
if ($term == '') {
self::showCategories($category_id);
}
if (self::$objTemplate->blockExists('shopNextCategoryLink')) {
$nextCat = ShopCategory::getNextShopCategoryId($category_id);
$objCategory = ShopCategory::getById($nextCat);
if ($objCategory) {
self::$objTemplate->setVariable(array('SHOP_NEXT_CATEGORY_ID' => $nextCat, 'SHOP_NEXT_CATEGORY_TITLE' => str_replace('"', '"', $objCategory->name())));
}
}
$pagingCmd = !empty($_REQUEST['cmd']) ? '&cmd=' . contrexx_input2raw($_REQUEST['cmd']) : '';
$pagingCatId = '';
$pagingManId = '';
$pagingTerm = '';
// TODO: This probably breaks paging in search results!
// Should only reset the flag conditionally, but add the URL parameters in
// any case, methinks!
if ($category_id > 0 && $term == '') {
$flagSpecialoffer = false;
$pagingCatId = "&catId={$category_id}";
}
if ($manufacturer_id > 0) {
$flagSpecialoffer = false;
$pagingManId = "&manufacturer_id={$manufacturer_id}";
}
if ($term != '') {
$flagSpecialoffer = false;
$pagingTerm = '&term=' . htmlentities($term, ENT_QUOTES, CONTREXX_CHARSET);
}
// The Product count is passed by reference and set to the total
// number of records, though only as many as specified by the core
// paging limit are returned in the array.
$limit = \Cx\Core\Setting\Controller\Setting::getValue('numof_products_per_page_frontend', 'Shop');
//\DBG::activate(DBG_ERROR_FIREPHP);
// Use Sorting class for the Product order
$uri = \Html::getRelativeUri_entities();
$arrOrder = array('product.ord' => $_ARRAYLANG['TXT_SHOP_ORDER_PRODUCT_ORD'], 'name' => $_ARRAYLANG['TXT_SHOP_ORDER_PRODUCT_TITLE'], 'code' => $_ARRAYLANG['TXT_SHOP_ORDER_PRODUCT_CODE'], 'price' => $_ARRAYLANG['TXT_SHOP_ORDER_PRODUCT_PRICE'], 'id' => $_ARRAYLANG['TXT_SHOP_ORDER_PRODUCT_DATE'], 'bestseller' => $_ARRAYLANG['TXT_SHOP_ORDER_PRODUCT_BESTSELLER']);
$defaultOrder = \Sorting::getFieldindex(Products::$arrProductOrder[\Cx\Core\Setting\Controller\Setting::getValue('product_sorting', 'Shop')]);
$objSorting = new \Sorting($uri, $arrOrder, true, 'shop_order_products', $defaultOrder);
//\DBG::log("Sorting headers: ".var_export($objSorting->getHeaderArray(), true));
$count = $limit;
$arrProduct = array();
if ($product_ids) {
$arrProduct = self::getValidProducts($product_ids);
$product_id = null;
// Suppress meta title from single Product
} elseif ($product_id) {
$arrProduct = self::getValidProducts(array($product_id));
} else {
$arrProduct = Products::getByShopParams($count, \Paging::getPosition(), $product_id, $category_id, $manufacturer_id, $term, $flagSpecialoffer, $flagLastFive, $objSorting->getOrder(), self::$objCustomer && self::$objCustomer->is_reseller());
}
// Only show sorting when there's enough to be sorted
if ($count > 1) {
$objSorting->parseHeaders(self::$objTemplate, 'shop_product_order');
}
if ($count == 0 && !ShopCategories::getChildCategoryIdArray($category_id)) {
//if ($term != '' || $manufacturer_id != 0 || $flagSpecialoffer) {
if (self::$objTemplate->blockExists('no_product')) {
self::$objTemplate->touchBlock('no_product');
}
return true;
}
if ($objCategory) {
// Only indicate the category name when there are products
if ($count) {
self::$objTemplate->setVariable(array('SHOP_CATEGORY_CURRENT_NAME' => contrexx_raw2xhtml($objCategory->name()), 'SHOP_PRODUCTS_IN_CATEGORY' => sprintf($_ARRAYLANG['TXT_SHOP_PRODUCTS_IN_CATEGORY'], contrexx_raw2xhtml($objCategory->name()))));
}
} else {
// TODO: There are other cases of flag combinations that are not indivuidually
// handled here yet.
if ($term == '') {
if ($flagSpecialoffer == Products::DEFAULT_VIEW_DISCOUNTS) {
self::$objTemplate->setVariable('SHOP_PRODUCTS_IN_CATEGORY', $_ARRAYLANG['TXT_SHOP_PRODUCTS_SPECIAL_OFFER']);
} else {
if (self::$objTemplate->blockExists('products_in_category')) {
self::$objTemplate->hideBlock('products_in_category');
}
}
} else {
self::$objTemplate->setVariable('SHOP_PRODUCTS_IN_CATEGORY', sprintf($_ARRAYLANG['TXT_SHOP_PRODUCTS_SEARCH_RESULTS'], contrexx_raw2xhtml($term)));
}
}
$uri = '&section=Shop' . MODULE_INDEX . $pagingCmd . $pagingCatId . $pagingManId . $pagingTerm;
self::$objTemplate->setVariable(array('SHOP_PRODUCT_PAGING' => \Paging::get($uri, '', $count, $limit, $count > 0), 'SHOP_PRODUCT_TOTAL' => $count));
// Global microdata: Seller information
$seller_url = \Cx\Core\Routing\Url::fromModuleAndCmd('Shop', '')->toString();
$seller_name = \Cx\Core\Setting\Controller\Setting::getValue('company', 'Shop');
if (empty($seller_name)) {
$seller_name = $seller_url;
}
self::$objTemplate->setVariable(array('SHOP_SELLER_NAME' => $seller_name, 'SHOP_SELLER_URL' => $seller_url));
$formId = 0;
$arrDefaultImageSize = $arrSize = null;
foreach ($arrProduct as $objProduct) {
if (!empty($product_id)) {
self::$pageTitle = $objProduct->name();
}
$id = $objProduct->id();
$productSubmitFunction = '';
$arrPictures = Products::get_image_array_from_base64($objProduct->pictures());
$havePicture = false;
$arrProductImages = array();
foreach ($arrPictures as $index => $image) {
$thumbnailPath = $pictureLink = '';
if (empty($image['img']) || $image['img'] == ShopLibrary::noPictureName) {
// We have at least one picture on display already.
// No need to show "no picture" three times!
if ($havePicture) {
continue;
}
$thumbnailPath = self::$defaultImage;
$pictureLink = '#';
//"javascript:alert('".$_ARRAYLANG['TXT_NO_PICTURE_AVAILABLE']."');";
if (empty($arrDefaultImageSize)) {
$arrDefaultImageSize = getimagesize(\Cx\Core\Core\Controller\Cx::instanciate()->getWebsitePath() . self::$defaultImage);
self::scaleImageSizeToThumbnail($arrDefaultImageSize);
}
$arrSize = $arrDefaultImageSize;
} else {
$thumbnailPath = \Cx\Core\Core\Controller\Cx::instanciate()->getWebsiteImagesShopWebPath() . '/' . \ImageManager::getThumbnailFilename($image['img']);
if ($image['width'] && $image['height']) {
$pictureLink = contrexx_raw2encodedUrl(\Cx\Core\Core\Controller\Cx::instanciate()->getWebsiteImagesShopWebPath() . '/' . $image['img']) . '" rel="shadowbox[' . ($formId + 1) . ']';
// Thumbnail display size
$arrSize = array($image['width'], $image['height']);
} else {
$pictureLink = '#';
if (!file_exists(\Cx\Core\Core\Controller\Cx::instanciate()->getWebsitePath() . $thumbnailPath)) {
continue;
}
$arrSize = getimagesize(\Cx\Core\Core\Controller\Cx::instanciate()->getWebsitePath() . $thumbnailPath);
}
self::scaleImageSizeToThumbnail($arrSize);
// Use the first available picture in microdata, if any
if (!$havePicture) {
$picture_url = \Cx\Core\Routing\Url::fromCapturedRequest(\Cx\Core\Core\Controller\Cx::instanciate()->getWebsiteImagesShopWebPath() . '/' . $image['img'], \Cx\Core\Core\Controller\Cx::instanciate()->getWebsiteOffsetPath(), array());
self::$objTemplate->setVariable('SHOP_PRODUCT_IMAGE', $picture_url->toString());
//\DBG::log("Set image to ".$picture_url->toString());
}
}
$arrProductImages[] = array('THUMBNAIL' => contrexx_raw2encodedUrl($thumbnailPath), 'THUMBNAIL_SIZE' => $arrSize[3], 'THUMBNAIL_LINK' => $pictureLink, 'POPUP_LINK' => $pictureLink, 'POPUP_LINK_NAME' => $_ARRAYLANG['TXT_SHOP_IMAGE'] . ' ' . $index);
$havePicture = true;
}
$i = 1;
foreach ($arrProductImages as $arrProductImage) {
// TODO: Instead of several numbered image blocks, use a single one repeatedly
self::$objTemplate->setVariable(array('SHOP_PRODUCT_THUMBNAIL_' . $i => $arrProductImage['THUMBNAIL'], 'SHOP_PRODUCT_THUMBNAIL_SIZE_' . $i => $arrProductImage['THUMBNAIL_SIZE']));
if (!empty($arrProductImage['THUMBNAIL_LINK'])) {
self::$objTemplate->setVariable(array('SHOP_PRODUCT_THUMBNAIL_LINK_' . $i => $arrProductImage['THUMBNAIL_LINK'], 'TXT_SEE_LARGE_PICTURE' => $_ARRAYLANG['TXT_SEE_LARGE_PICTURE']));
} else {
self::$objTemplate->setVariable('TXT_SEE_LARGE_PICTURE', contrexx_raw2xhtml($objProduct->name()));
}
if ($arrProductImage['POPUP_LINK']) {
self::$objTemplate->setVariable('SHOP_PRODUCT_POPUP_LINK_' . $i, $arrProductImage['POPUP_LINK']);
}
self::$objTemplate->setVariable('SHOP_PRODUCT_POPUP_LINK_NAME_' . $i, $arrProductImage['POPUP_LINK_NAME']);
++$i;
}
$stock = $objProduct->stock_visible() ? $_ARRAYLANG['TXT_STOCK'] . ': ' . intval($objProduct->stock()) : '';
$price = $objProduct->get_custom_price(self::$objCustomer, 0, 1, true);
// If there is a discountprice and it's enabled
$discountPrice = '';
if ($objProduct->discountprice() > 0 && $objProduct->discount_active()) {
$price = '<s>' . $price . '</s>';
$discountPrice = $objProduct->get_custom_price(self::$objCustomer, 0, 1, false);
}
$groupCountId = $objProduct->group_id();
$groupArticleId = $objProduct->article_id();
$groupCustomerId = 0;
if (self::$objCustomer) {
$groupCustomerId = self::$objCustomer->group_id();
}
self::showDiscountInfo($groupCustomerId, $groupArticleId, $groupCountId, 1);
/* OLD
$price = Currency::getCurrencyPrice(
$objProduct->getCustomerPrice(self::$objCustomer)
);
$discountPrice = '';
$discount_active = $objProduct->discount_active();
if ($discount_active) {
$discountPrice = $objProduct->discountprice();
if ($discountPrice > 0) {
$price = "<s>$price</s>";
$discountPrice =
Currency::getCurrencyPrice($discountPrice);
}
}
*/
$short = $objProduct->short();
$longDescription = $objProduct->long();
$detailLink = null;
// Detaillink is required for microdata (even when longdesc
// is empty)
$detail_url = \Cx\Core\Routing\Url::fromModuleAndCmd('Shop', 'details', FRONTEND_LANG_ID, array('productId' => $objProduct->id()))->toString();
self::$objTemplate->setVariable('SHOP_PRODUCT_DETAIL_URL', $detail_url);
if (!$product_id && !empty($longDescription)) {
$detailLink = '<a href="' . $detail_url . '"' . ' title="' . $_ARRAYLANG['TXT_MORE_INFORMATIONS'] . '">' . $_ARRAYLANG['TXT_MORE_INFORMATIONS'] . '</a>';
self::$objTemplate->setVariable('SHOP_PRODUCT_DETAILLINK', $detailLink);
}
// Check Product flags.
// Only the meter flag is currently implemented and in use.
$flagMeter = $objProduct->testFlag('__METER__');
// Submit button name and function.
// Calling productOptions() also sets the $flagMultipart variable
// to the appropriate encoding type for the form if
// any upload fields are in use.
$flagMultipart = false;
$productSubmitName = $productSubmitFunction = '';
if (isset($_GET['cmd']) && $_GET['cmd'] == 'details' && isset($_GET['referer']) && $_GET['referer'] == 'cart') {
$productSubmitName = "updateProduct[{$cart_id}]";
$productSubmitFunction = self::productOptions($id, $formId, $cart_id, $flagMultipart);
} else {
$productSubmitName = 'addProduct';
$productSubmitFunction = self::productOptions($id, $formId, $cart_id, $flagMultipart);
}
$shopProductFormName = "shopProductForm{$formId}";
$row = $formId % 2 + 1;
self::$objTemplate->setVariable(array('SHOP_ROWCLASS' => 'row' . $row, 'SHOP_PRODUCT_ID' => $objProduct->id(), 'SHOP_PRODUCT_TITLE' => contrexx_raw2xhtml($objProduct->name()), 'SHOP_PRODUCT_DESCRIPTION' => $short, 'SHOP_PRODUCT_DETAILDESCRIPTION' => $longDescription ? $longDescription : $short, 'SHOP_PRODUCT_FORM_NAME' => $shopProductFormName, 'SHOP_PRODUCT_SUBMIT_NAME' => $productSubmitName, 'SHOP_PRODUCT_SUBMIT_FUNCTION' => $productSubmitFunction, 'SHOP_FORM_ENCTYPE' => $flagMultipart ? ' enctype="multipart/form-data"' : '', 'TXT_SHOP_PRODUCT_COUNT' => $flagMeter ? $_ARRAYLANG['TXT_SHOP_PRODUCT_METER'] : $_ARRAYLANG['TXT_SHOP_PRODUCT_COUNT'], 'SHOP_CURRENCY_CODE' => Currency::getActiveCurrencyCode()));
if ($objProduct->code()) {
self::$objTemplate->setVariable('SHOP_PRODUCT_CUSTOM_ID', htmlentities($objProduct->code(), ENT_QUOTES, CONTREXX_CHARSET));
}
$manufacturer_name = $manufacturer_url = $manufacturer_link = '';
$manufacturer_id = $objProduct->manufacturer_id();
if ($manufacturer_id) {
$manufacturer_name = Manufacturer::getNameById($manufacturer_id, FRONTEND_LANG_ID);
$manufacturer_url = Manufacturer::getUrlById($manufacturer_id, FRONTEND_LANG_ID);
}
if (!empty($manufacturer_url) || !empty($manufacturer_name)) {
if (empty($manufacturer_name)) {
$manufacturer_name = $manufacturer_url;
}
if (!empty($manufacturer_url)) {
$manufacturer_link = '<a href="' . $manufacturer_url . '">' . $manufacturer_name . '</a>';
}
// TODO: Test results for any combination of name and url
self::$objTemplate->setVariable(array('SHOP_MANUFACTURER_NAME' => $manufacturer_name, 'SHOP_MANUFACTURER_URL' => $manufacturer_url, 'SHOP_MANUFACTURER_LINK' => $manufacturer_link, 'TXT_SHOP_MANUFACTURER_LINK' => $_ARRAYLANG['TXT_SHOP_MANUFACTURER_LINK']));
}
// This is the old Product field for the Manufacturer URI.
// This is now extended by the Manufacturer table and should thus
// get a new purpose. As it is product specific, it could be
// renamed and reused as a link to individual Products!
$externalLink = $objProduct->uri();
if (!empty($externalLink)) {
self::$objTemplate->setVariable(array('SHOP_EXTERNAL_LINK' => '<a href="' . $externalLink . '" title="' . $_ARRAYLANG['TXT_SHOP_EXTERNAL_LINK'] . '" target="_blank">' . $_ARRAYLANG['TXT_SHOP_EXTERNAL_LINK'] . '</a>'));
}
if ($price) {
self::$objTemplate->setGlobalVariable(array('SHOP_PRODUCT_PRICE' => $price, 'SHOP_PRODUCT_PRICE_UNIT' => Currency::getActiveCurrencySymbol()));
}
// Only show the discount price if it's actually in use,
// avoid an "empty <font> tag" HTML warning
if ($discountPrice) {
self::$objTemplate->setGlobalVariable(array('SHOP_PRODUCT_DISCOUNTPRICE' => $discountPrice, 'SHOP_PRODUCT_DISCOUNTPRICE_UNIT' => Currency::getActiveCurrencySymbol()));
if (self::$objTemplate->blockExists('price_discount')) {
self::$objTemplate->touchBlock('price_discount');
}
} else {
if (self::$objTemplate->blockExists('price')) {
self::$objTemplate->touchBlock('price');
}
}
// Special outlet ShopCategory with discounts varying daily.
// This should be implemented in a more generic way, in the
// Discount class maybe.
if ($objProduct->is_outlet()) {
self::$objTemplate->setVariable(array('TXT_SHOP_DISCOUNT_TODAY' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_TODAY'], 'SHOP_DISCOUNT_TODAY' => $objProduct->getOutletDiscountRate() . '%', 'TXT_SHOP_PRICE_TODAY' => $_ARRAYLANG['TXT_SHOP_PRICE_TODAY'], 'SHOP_PRICE_TODAY' => Currency::getCurrencyPrice($objProduct->getDiscountedPrice()), 'SHOP_PRICE_TODAY_UNIT' => Currency::getActiveCurrencySymbol()));
}
if ($objProduct->stock_visible()) {
self::$objTemplate->setVariable(array('SHOP_PRODUCT_STOCK' => $stock));
}
if ($detailLink) {
self::$objTemplate->setVariable(array('SHOP_PRODUCT_DETAILLINK' => $detailLink));
}
$distribution = $objProduct->distribution();
$weight = '';
if ($distribution == 'delivery') {
$weight = $objProduct->weight();
}
// Hide the weight if it is zero or disabled in the configuration
if ($weight > 0 && \Cx\Core\Setting\Controller\Setting::getValue('weight_enable', 'Shop')) {
self::$objTemplate->setVariable(array('TXT_SHOP_PRODUCT_WEIGHT' => $_ARRAYLANG['TXT_SHOP_PRODUCT_WEIGHT'], 'SHOP_PRODUCT_WEIGHT' => Weight::getWeightString($weight)));
}
if (Vat::isEnabled()) {
self::$objTemplate->setVariable(array('SHOP_PRODUCT_TAX_PREFIX' => Vat::isIncluded() ? $_ARRAYLANG['TXT_SHOP_VAT_PREFIX_INCL'] : $_ARRAYLANG['TXT_SHOP_VAT_PREFIX_EXCL'], 'SHOP_PRODUCT_TAX' => Vat::getShort($objProduct->vat_id())));
}
// Add flag images for flagged Products
$strImage = '';
$strFlags = $objProduct->flags();
$arrVirtual = ShopCategories::getVirtualCategoryNameArray(FRONTEND_LANG_ID);
foreach (explode(' ', $strFlags) as $strFlag) {
if (in_array($strFlag, $arrVirtual)) {
$strImage .= '<img src="images/content/' . $strFlag . '.jpg" alt="' . $strFlag . '" />';
}
}
if ($strImage) {
self::$objTemplate->setVariable('SHOP_PRODUCT_FLAG_IMAGE', $strImage);
}
$minimum_order_quantity = $objProduct->minimum_order_quantity();
//Activate Quantity-Inputfield when minimum_order_quantity exists
if (self::$objTemplate->blockExists('orderQuantity') && $minimum_order_quantity > 0) {
self::$objTemplate->setVariable('SHOP_PRODUCT_MINIMUM_ORDER_QUANTITY', contrexx_raw2xhtml($objProduct->minimum_order_quantity()));
} elseif (self::$objTemplate->blockExists('orderQuantity') && !$minimum_order_quantity) {
self::$objTemplate->hideBlock('orderQuantity');
}
if (self::$objTemplate->blockExists('shopProductRow')) {
self::$objTemplate->parse('shopProductRow');
}
++$formId;
}
return true;
}
function setColHeader($val, $attr, &$colHeaders, &$colHeaderAttrs, &$colHeaderClasses, &$filterHeaders)
{
$lllProp =& new LllProperties($this->base, $attr);
$temp = $lllProp->getColHeader();
if (!$temp) {
$temp = $lllProp->getLabel();
}
$colHeaderClass = "";
if ($this->tableSort) {
$colHeaderClass = isset($val["sort"]) ? "table-sortable:" . $val["sort"] : "";
} else {
$temp .= Sorting::showSortTool($this->base, $attr);
}
if (isset($val["customCss"])) {
$colHeaderClass .= " " . $val["customCss"];
}
$colHeaderClasses[] = $colHeaderClass;
$colHeaders[] = $temp;
$colHeaderAttrs[] = isset($headerHeight) ? "nowrap height='{$headerHeight}'" : "nowrap";
if ($this->tableFilter) {
if (isset($val["filter"])) {
$filterHeaders[] = $this->tableFilter->generField($val["filter"], $list, $attr);
} else {
$filterHeaders[] = "";
}
}
}
function getSpecialSortAttrs($isCommon = 0, $cid = 0)
{
$sorting = new Sorting($this);
$sortAttrs = $sorting->getAttrs();
$s = "";
foreach ($sortAttrs as $attr) {
CustomField::getSortType($sortType, $sortSqlAttr, $isCommon, $cid, $attr);
if ($sortType == customfield_integer) {
$s .= ", 0+{$sortSqlAttr} AS {$attr}";
} elseif ($sortType == customfield_float) {
$s .= ", 0.0+{$sortSqlAttr} AS {$attr}";
} elseif ($sortType == customfield_date) {
$s .= ", IFNULL(CAST({$sortSqlAttr} AS DATE), '') AS {$attr}";
}
}
return $s;
}
/**
* Edit coupons
* @param \Cx\Core\Html\Sigma $objTemplate The Template
*/
static function edit($objTemplate)
{
global $_ARRAYLANG;
//DBG::activate(DBG_ADODB|DBG_LOG_FIREPHP|DBG_PHP);
$result = true;
if (isset($_GET['delete'])) {
list($code, $customer_id) = explode('-', $_GET['delete']);
$result &= self::delete(contrexx_input2raw($code), intval($customer_id));
}
$edit = isset($_REQUEST['edit']) ? contrexx_input2raw($_REQUEST['edit']) : null;
//DBG::log("Edit: ".($edit ? $edit : 'NULL'));
$code = isset($_POST['code']) ? contrexx_input2raw($_POST['code']) : null;
$payment_id = empty($_POST['payment_id']) ? 0 : intval($_POST['payment_id']);
$start_time = empty($_POST['start_date']) ? 0 : strtotime(contrexx_input2raw($_POST['start_date']));
$end_time = empty($_POST['end_date_unlimited']) ? empty($_POST['end_date']) ? 0 : strtotime(contrexx_input2raw($_POST['end_date'])) : 0;
$coupon_type = empty($_POST['coupon_type']) ? null : contrexx_input2raw($_POST['coupon_type']);
$discount_rate = intval(empty($_POST['discount_rate']) ? 0 : floatval($_POST['discount_rate']));
$discount_amount = Currency::formatPrice(empty($_POST['discount_amount']) ? 0 : floatval($_POST['discount_amount']));
if ($coupon_type == 'rate') {
$discount_amount = 0;
}
if ($coupon_type == 'amount') {
$discount_rate = 0;
}
$minimum_amount = Currency::formatPrice(empty($_POST['minimum_amount']) ? 0 : floatval($_POST['minimum_amount']));
$uses = empty($_POST['unlimited']) ? empty($_POST['uses']) ? 1 : intval($_POST['uses']) : self::USES_UNLIMITED;
$customer_id = empty($_POST['customer_id']) ? 0 : intval($_POST['customer_id']);
$product_id = empty($_POST['product_id']) ? 0 : intval($_POST['product_id']);
$global = !empty($_POST['global_or_customer']);
//DBG::log("code $code, start_time $start_time, end_time $end_time, minimum amount $minimum_amount, discount_rate $discount_rate, discount_amount $discount_amount, uses $uses, customer_id $customer_id");
if (isset($code)) {
$result &= self::storeCode($code, $payment_id, $minimum_amount, $discount_rate, $discount_amount, $start_time, $end_time, $uses, $global, $customer_id, $product_id, $edit);
if ($result) {
$code = $edit = null;
} else {
if (empty($edit)) {
$edit = "{$code}-{$customer_id}";
}
}
}
// Reset the end time if it's in the past
if ($end_time < time()) {
$end_time = 0;
}
$uri = \Html::getRelativeUri();
\Html::stripUriParam($uri, 'view');
\Html::stripUriParam($uri, 'edit');
\Html::stripUriParam($uri, 'order_coupon');
$arrSortingFields = array('code' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_CODE'], 'start_time' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_START_TIME'], 'end_time' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_END_TIME'], 'minimum_amount' => sprintf($_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_MINIMUM_AMOUNT_FORMAT'], Currency::getDefaultCurrencyCode()), 'discount_rate' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_RATE'], 'discount_amount' => sprintf($_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_AMOUNT_FORMAT'], Currency::getDefaultCurrencyCode()), 'uses' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_USES'], 'global' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_SCOPE'], 'customer_id' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_CUSTOMER'], 'product_id' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PRODUCT'], 'payment_id' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PAYMENT']);
$objSorting = new \Sorting($uri, $arrSortingFields, true, 'order_coupon');
$objTemplate->setGlobalVariable($_ARRAYLANG + array('TXT_SHOP_DISCOUNT_COUPON_MINIMUM_AMOUNT_CURRENCY' => sprintf($_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_MINIMUM_AMOUNT_FORMAT'], Currency::getDefaultCurrencyCode()), 'TXT_SHOP_DISCOUNT_COUPON_AMOUNT_CURRENCY' => sprintf($_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_AMOUNT_FORMAT'], Currency::getDefaultCurrencyCode()), 'TXT_SHOP_DISCOUNT_COUPON_ADD_OR_EDIT' => $_ARRAYLANG[$edit ? 'TXT_SHOP_DISCOUNT_COUPON_EDIT' : 'TXT_SHOP_DISCOUNT_COUPON_ADD'], 'SHOP_DISCOUNT_COUPON_VIEW_ACTIVE' => $edit ? '' : 'active', 'SHOP_DISCOUNT_COUPON_EDIT_ACTIVE' => $edit ? 'active' : '', 'SHOP_DISCOUNT_COUPON_VIEW_DISPLAY' => $edit ? 'none' : 'block', 'SHOP_DISCOUNT_COUPON_EDIT_DISPLAY' => $edit ? 'block' : 'none', 'HEADER_SHOP_DISCOUNT_COUPON_CODE' => $objSorting->getHeaderForField('code'), 'HEADER_SHOP_DISCOUNT_COUPON_START_TIME' => $objSorting->getHeaderForField('start_time'), 'HEADER_SHOP_DISCOUNT_COUPON_END_TIME' => $objSorting->getHeaderForField('end_time'), 'HEADER_SHOP_DISCOUNT_COUPON_MINIMUM_AMOUNT_CURRENCY' => $objSorting->getHeaderForField('minimum_amount'), 'HEADER_SHOP_DISCOUNT_COUPON_RATE' => $objSorting->getHeaderForField('discount_rate'), 'HEADER_SHOP_DISCOUNT_COUPON_AMOUNT_CURRENCY' => $objSorting->getHeaderForField('discount_amount'), 'HEADER_SHOP_DISCOUNT_COUPON_USES' => $objSorting->getHeaderForField('uses'), 'HEADER_SHOP_DISCOUNT_COUPON_SCOPE' => $objSorting->getHeaderForField('global'), 'HEADER_SHOP_DISCOUNT_COUPON_CUSTOMER' => $objSorting->getHeaderForField('customer_id'), 'HEADER_SHOP_DISCOUNT_COUPON_PRODUCT' => $objSorting->getHeaderForField('product_id'), 'HEADER_SHOP_DISCOUNT_COUPON_PAYMENT' => $objSorting->getHeaderForField('payment_id')));
$count = 0;
$limit = \Cx\Core\Setting\Controller\Setting::getValue('numof_coupon_per_page_backend', 'Shop');
if (empty($limit)) {
self::errorHandler();
}
$arrCoupons = self::getArray(\Paging::getPosition(), $limit, $count, $objSorting->getOrder());
$arrProductName = Products::getNameArray(true, $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PRODUCT_FORMAT']);
$arrPaymentName = Payment::getNameArray();
$i = 0;
$row = 0;
$objCouponEdit = new Coupon();
$objCouponEdit->code($code);
$objCouponEdit->payment_id($payment_id);
$objCouponEdit->minimum_amount($minimum_amount);
$objCouponEdit->discount_rate($discount_rate);
$objCouponEdit->discount_amount($discount_amount);
$objCouponEdit->start_time($start_time);
$objCouponEdit->end_time($end_time);
$objCouponEdit->uses($uses);
$objCouponEdit->is_global($global);
$objCouponEdit->customer_id($customer_id);
$objCouponEdit->product_id($product_id);
global $_CONFIG;
foreach ($arrCoupons as $index => $objCoupon) {
$coupon_uri_id = 'coupon_uri_' . $index;
$objTemplate->setVariable(array('SHOP_ROWCLASS' => 'row' . (++$row % 2 + 1), 'SHOP_DISCOUNT_COUPON_CODE' => $objCoupon->code, 'SHOP_DISCOUNT_COUPON_URI_ICON' => '<div class="icon_url"' . '> </div>', 'SHOP_DISCOUNT_COUPON_URI_INPUT' => '<div class="layer_url" id="' . $coupon_uri_id . '">' . \Html::getInputText('dummy', 'http://' . $_CONFIG['domainUrl'] . \Cx\Core\Core\Controller\Cx::instanciate()->getWebsiteOffsetPath() . '/' . CONTREXX_DIRECTORY_INDEX . '?section=Shop' . MODULE_INDEX . '&coupon_code=' . $objCoupon->code, false, 'readonly="readonly"' . ' style="width: 200px;"' . ' onfocus="this.select();"' . ' onblur="cx.jQuery(\'#' . $coupon_uri_id . '\').hide();"') . '</div>', 'SHOP_DISCOUNT_COUPON_START_TIME' => $objCoupon->start_time ? date(ASCMS_DATE_FORMAT_DATE, $objCoupon->start_time) : $_ARRAYLANG['TXT_SHOP_DATE_NONE'], 'SHOP_DISCOUNT_COUPON_END_TIME' => $objCoupon->end_time ? date(ASCMS_DATE_FORMAT_DATE, $objCoupon->end_time) : $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_END_TIME_UNLIMITED'], 'SHOP_DISCOUNT_COUPON_MINIMUM_AMOUNT' => $objCoupon->minimum_amount > 0 ? $objCoupon->minimum_amount : $_ARRAYLANG['TXT_SHOP_AMOUNT_NONE'], 'SHOP_DISCOUNT_COUPON_RATE' => $objCoupon->discount_rate > 0 ? $objCoupon->discount_rate : $_ARRAYLANG['TXT_SHOP_RATE_NONE'], 'SHOP_DISCOUNT_COUPON_AMOUNT' => $objCoupon->discount_amount > 0 ? $objCoupon->discount_amount : $_ARRAYLANG['TXT_SHOP_AMOUNT_NONE'], 'SHOP_DISCOUNT_COUPON_USES' => sprintf($_ARRAYLANG['TXT_SHOP_COUPON_USES_FORMAT'], $objCoupon->used, $objCoupon->uses < 1000000000.0 ? $objCoupon->uses : $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_USES_UNLIMITED']), 'SHOP_DISCOUNT_COUPON_SCOPE' => $objCoupon->global ? $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_GLOBALLY'] : $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PER_CUSTOMER'], 'SHOP_DISCOUNT_COUPON_PER_CUSTOMER' => !$objCoupon->global ? \Html::getRadio('foo_' . ++$i, '', false, true, '', \Html::ATTRIBUTE_DISABLED) : ' ', 'SHOP_DISCOUNT_COUPON_CUSTOMER' => $objCoupon->customer_id ? Customers::getNameById($objCoupon->customer_id, '%4$s (%3$u)') : $_ARRAYLANG['TXT_SHOP_CUSTOMER_ANY'], 'SHOP_DISCOUNT_COUPON_PRODUCT' => $objCoupon->product_id ? isset($arrProductName[$objCoupon->product_id]) ? $arrProductName[$objCoupon->product_id] : $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PRODUCT_INVALID'] : $_ARRAYLANG['TXT_SHOP_PRODUCT_ANY'], 'SHOP_DISCOUNT_COUPON_PAYMENT' => $objCoupon->payment_id ? sprintf($_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PAYMENT_FORMAT'], $objCoupon->payment_id, $arrPaymentName[$objCoupon->payment_id]) : $_ARRAYLANG['TXT_SHOP_PAYMENT_ANY'], 'SHOP_DISCOUNT_COUPON_FUNCTIONS' => \Html::getBackendFunctions(array('edit' => ADMIN_SCRIPT_PATH . '?cmd=Shop&act=settings&tpl=coupon&edit=' . urlencode($index), 'delete' => "javascript:delete_coupon('" . urlencode($index) . "');"))));
$objTemplate->parse('shopDiscountCouponView');
if ($index === $edit) {
$objCouponEdit = $objCoupon;
}
}
$objTemplate->replaceBlock('shopDiscountCouponView', '', true);
$paging = \Paging::get($uri, $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_CODES'], $count, $limit);
//DBG::log("Paging: $paging");
$objTemplate->setVariable('SHOP_PAGING', $paging);
$attribute_code = 'style="width: 230px; text-align: left;" maxlength="20"';
$attribute_time = 'style="width: 230px; text-align: left;" maxlength="10"';
$attribute_discount_rate = 'style="width: 230px; text-align: right;" maxlength="3"';
$attribute_discount_amount = 'style="width: 230px; text-align: right;" maxlength="9"';
$attribute_minimum_amount = 'style="width: 230px; text-align: right;" maxlength="9"';
$attribute_uses = 'style="width: 230px; text-align: right;" maxlength="6"';
// Superseded by the widget, see below
// $attribute_customer = 'style="width: 230px;"';
$attribute_product = 'style="width: 230px;"';
$attribute_payment = 'style="width: 230px;"';
$type = $objCouponEdit->discount_rate > 0 ? 'rate' : 'amount';
$customer_name = '';
//reset the add view
if (!$edit) {
$objCouponEdit = new Coupon();
}
if ($objCouponEdit->customer_id) {
$customer_name = Customers::getNameById($objCouponEdit->customer_id, '%4$s (%3$u)');
//DBG::log("Customer ID ".$objCouponEdit->customer_id.": name $customer_name");
}
$objTemplate->setVariable(array('SHOP_ROWCLASS' => 'row' . (++$row % 2 + 1), 'SHOP_DISCOUNT_COUPON_INDEX' => $objCouponEdit->getIndex(), 'SHOP_DISCOUNT_COUPON_CODE' => \Html::getInputText('code', $objCouponEdit->code, '', $attribute_code), 'SHOP_DISCOUNT_COUPON_CODE_CREATE' => \Html::getInputButton('code_create', $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_CODE_NEW'], 'button', false, 'onclick="cx.jQuery(\'#code\').val(\'' . Coupon::getNewCode() . '\');' . 'cx.jQuery(this).css(\'display\', \'none\');"'), 'SHOP_DISCOUNT_COUPON_START_TIME' => \Html::getDatepicker('start_date', array('defaultDate' => date(ASCMS_DATE_FORMAT_DATE, $objCouponEdit->start_time ? $objCouponEdit->start_time : time())), $attribute_time), 'SHOP_DISCOUNT_COUPON_END_TIME' => \Html::getDatepicker('end_date', array('defaultDate' => $objCouponEdit->end_time ? date(ASCMS_DATE_FORMAT_DATE, $objCouponEdit->end_time) : ''), $attribute_time), 'SHOP_DISCOUNT_COUPON_END_TIME_UNLIMITED' => \Html::getCheckbox('end_time_unlimited', 1, '', $objCouponEdit->end_time ? '' : \Html::ATTRIBUTE_CHECKED) . \Html::getLabel('end_time_unlimited', $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_END_TIME_UNLIMITED']), 'SHOP_DISCOUNT_COUPON_MINIMUM_AMOUNT' => \Html::getInputText('minimum_amount', $objCouponEdit->minimum_amount, false, $attribute_minimum_amount), 'SHOP_DISCOUNT_COUPON_TYPE' => \Html::getRadioGroup('coupon_type', array('rate' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_TYPE_RATE'], 'amount' => $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_TYPE_AMOUNT']), $type), 'SHOP_DISCOUNT_COUPON_TYPE_SELECTED' => $type, 'SHOP_DISCOUNT_COUPON_RATE' => \Html::getInputText('discount_rate', $objCouponEdit->discount_rate, false, $attribute_discount_rate), 'SHOP_DISCOUNT_COUPON_AMOUNT' => \Html::getInputText('discount_amount', number_format($objCouponEdit->discount_amount, 2, '.', ''), false, $attribute_discount_amount), 'SHOP_DISCOUNT_COUPON_USES' => \Html::getInputText('uses', $objCouponEdit->uses < 1000000000.0 ? $objCouponEdit->uses : '', 'uses', $attribute_uses), 'SHOP_DISCOUNT_COUPON_USES_UNLIMITED' => \Html::getCheckbox('unlimited', 1, 'unlimited', $objCouponEdit->uses > 1000000000.0) . \Html::getLabel('unlimited', $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_USES_UNLIMITED']), 'SHOP_DISCOUNT_COUPON_GLOBALLY' => \Html::getRadio('global_or_customer', '1', 'global', $objCouponEdit->global) . \Html::getLabel('global', $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_GLOBALLY']), 'SHOP_DISCOUNT_COUPON_PER_CUSTOMER' => \Html::getRadio('global_or_customer', '0', 'customer', !$objCouponEdit->global) . \Html::getLabel('customer', $_ARRAYLANG['TXT_SHOP_DISCOUNT_COUPON_PER_CUSTOMER']), 'SHOP_DISCOUNT_COUPON_CUSTOMER_ID' => $objCouponEdit->customer_id, 'SHOP_DISCOUNT_COUPON_CUSTOMER_NAME' => $customer_name, 'SHOP_DISCOUNT_COUPON_PRODUCT' => \Html::getSelect('product_id', array(0 => $_ARRAYLANG['TXT_SHOP_PRODUCT_ANY']) + $arrProductName, $objCouponEdit->product_id, false, '', $attribute_product), 'SHOP_DISCOUNT_COUPON_PAYMENT' => \Html::getSelect('payment_id', array(0 => $_ARRAYLANG['TXT_SHOP_PAYMENT_ANY']) + $arrPaymentName, $objCouponEdit->payment_id, false, '', $attribute_payment), 'SHOP_DISCOUNT_COUPON_CUSTOMER_WIDGET_DISPLAY' => $objCouponEdit->global ? \Html::CSS_DISPLAY_NONE : \Html::CSS_DISPLAY_INLINE));
$objTemplate->parse('shopDiscountCouponEdit');
// Depends on, and thus implies loading jQuery as well!
\FWUser::getUserLiveSearch(array('minLength' => 3, 'canCancel' => true, 'canClear' => true));
return $result;
}
/**
* Sets up the Order list view
*
* Sets the $objTemplate parameter to the default backend template,
* if empty.
* @param \Cx\Core\Html\Sigma $objTemplate The Template, by reference
* @param array $filter The optional filter
* @return boolean True on success,
* false otherwise
*/
static function view_list(&$objTemplate = null, $filter = NULL)
{
global $_ARRAYLANG, $objInit;
$backend = $objInit->mode == 'backend';
if (!$objTemplate) {
$objTemplate = new \Cx\Core\Html\Sigma(\Cx\Core\Core\Controller\Cx::instanciate()->getCodeBaseModulePath() . '/Shop/View/Template/Backend');
//DBG::log("Orders::view_list(): new Template: ".$objTemplate->get());
$objTemplate->loadTemplateFile('module_shop_orders.html');
//DBG::log("Orders::view_list(): loaded Template: ".$objTemplate->get());
}
$uri = $backend ? \Html::getRelativeUri_entities() : \Cx\Core\Routing\Url::fromModuleAndCmd('Shop', 'history', NULL);
//DBG::log("Orders::view_list(): URI: $uri");
// TODO: Better use a redirect after doing stuff!
\Html::stripUriParam($uri, 'act');
\Html::stripUriParam($uri, 'searchterm');
\Html::stripUriParam($uri, 'listletter');
\Html::stripUriParam($uri, 'customer_type');
\Html::stripUriParam($uri, 'status');
\Html::stripUriParam($uri, 'show_pending_orders');
\Html::stripUriParam($uri, 'order_id');
\Html::stripUriParam($uri, 'changeOrderStatus');
\Html::stripUriParam($uri, 'sendMail');
if (!is_array($filter)) {
$filter = array();
}
if (!empty($_REQUEST['searchterm'])) {
$filter['term'] = trim(strip_tags(contrexx_input2raw($_REQUEST['searchterm'])));
\Html::replaceUriParameter($uri, 'searchterm=' . $filter['term']);
} elseif (!empty($_REQUEST['listletter'])) {
$filter['letter'] = trim(strip_tags(contrexx_input2raw($_REQUEST['listletter'])));
\Html::replaceUriParameter($uri, 'listletter=' . $filter['letter']);
}
$customer_type = $usergroup_id = null;
// Ignore
if (isset($_REQUEST['customer_type']) && $_REQUEST['customer_type'] !== '') {
$customer_type = intval($_REQUEST['customer_type']);
\Html::replaceUriParameter($uri, 'customer_type=' . $customer_type);
if ($customer_type == 0) {
$usergroup_id = \Cx\Core\Setting\Controller\Setting::getValue('usergroup_id_customer', 'Shop');
}
if ($customer_type == 1) {
$usergroup_id = \Cx\Core\Setting\Controller\Setting::getValue('usergroup_id_reseller', 'Shop');
}
$objFWUser = \FWUser::getFWUserObject();
$objGroup = $objFWUser->objGroup->getGroup($usergroup_id);
if ($objGroup) {
$filter['customer_id'] = $objGroup->getAssociatedUserIds();
// No customers of that type, so suppress all results
if (empty($filter['customer_id'])) {
$filter['customer_id'] = array(0);
}
//DBG::log("Orders::view_list(): Group ID $usergroup_id, Customers: ".var_export($filter['customer_id'], true));
}
}
$status = null;
// Ignore
$arrStatus = null;
if (isset($_REQUEST['status']) && $_REQUEST['status'] !== '') {
$status = intval($_REQUEST['status']);
if ($status >= Order::STATUS_PENDING && $status < Order::STATUS_MAX) {
$arrStatus = array($status => true);
\Html::replaceUriParameter($uri, 'status=' . $status);
if ($status == Order::STATUS_PENDING) {
$_REQUEST['show_pending_orders'] = true;
}
}
}
// Let the user choose whether to see pending orders, too
$show_pending_orders = false;
if ($backend) {
if (empty($_REQUEST['show_pending_orders'])) {
if (empty($arrStatus)) {
$arrStatus = self::getStatusArray();
unset($arrStatus[Order::STATUS_PENDING]);
}
} else {
if ($arrStatus) {
$arrStatus[Order::STATUS_PENDING] = true;
}
$show_pending_orders = true;
\Html::replaceUriParameter($uri, 'show_pending_orders=1');
}
}
if ($arrStatus) {
$filter['status'] = array_keys($arrStatus);
}
//DBG::log("Orders::view_list(): URI for Sorting: $uri, decoded ".html_entity_decode($uri));
$arrSorting = array('id' => $_ARRAYLANG['TXT_SHOP_ID'], 'date_time' => $_ARRAYLANG['TXT_SHOP_ORDER_DATE'], 'customer_name' => $_ARRAYLANG['TXT_SHOP_CUSTOMER'], 'sum' => $_ARRAYLANG['TXT_SHOP_ORDER_SUM'], 'status' => $_ARRAYLANG['TXT_SHOP_ORDER_STATUS']);
$objSorting = new \Sorting($uri, $arrSorting, false, 'order_shop_orders');
$uri_search = $uri;
\Html::stripUriParam($uri_search, 'searchterm');
\Html::stripUriParam($uri_search, 'customer_type');
\Html::stripUriParam($uri_search, 'status');
\Html::stripUriParam($uri_search, 'show_pending_orders');
$objTemplate->setGlobalVariable($_ARRAYLANG);
if ($backend) {
$txt_order_complete = sprintf($_ARRAYLANG['TXT_SEND_TEMPLATE_TO_CUSTOMER'], $_ARRAYLANG['TXT_ORDER_COMPLETE']);
$objTemplate->setVariable(array('SHOP_SEND_TEMPLATE_TO_CUSTOMER' => $txt_order_complete, 'SHOP_CUSTOMER_TYPE_MENUOPTIONS' => Customers::getTypeMenuoptions($customer_type, true), 'SHOP_CUSTOMER_SORT_MENUOPTIONS' => Customers::getSortMenuoptions($objSorting->getOrderField()), 'SHOP_SHOW_PENDING_ORDERS_CHECKED' => $show_pending_orders ? \Html::ATTRIBUTE_CHECKED : '', 'SHOP_ORDER_STATUS_MENUOPTIONS' => self::getStatusMenuoptions($status, true)));
}
//DBG::log("Orders::view_list(): Order complete: $txt_order_complete");
//DBG::log("Orders::view_list(): URI: $uri");
$objTemplate->setGlobalVariable(array('SHOP_SEARCH_TERM' => isset($filter['term']) ? $filter['term'] : '', 'SHOP_ORDERS_ORDER_NAME' => $objSorting->getOrderParameterName(), 'SHOP_ORDERS_ORDER_VALUE' => $objSorting->getOrderUriEncoded(), 'SHOP_ACTION_URI_SEARCH_ENCODED' => $uri_search, 'SHOP_ACTION_URI_ENCODED' => $uri, 'SHOP_ACTION_URI' => html_entity_decode($uri), 'SHOP_CURRENCY', Currency::getDefaultCurrencySymbol()));
$count = 0;
$limit = \Cx\Core\Setting\Controller\Setting::getValue('numof_orders_per_page_backend', 'Shop');
// TODO: Obsolete ASAP
if (!$limit) {
ShopSettings::errorHandler();
$limit = 25;
}
$tries = 2;
$arrOrders = null;
//\DBG::activate(DBG_DB_FIREPHP);
while ($tries-- && $count == 0) {
$arrOrders = self::getArray($count, $objSorting->getOrder(), $filter, \Paging::getPosition(), $limit);
if ($count > 0) {
break;
}
\Paging::reset();
}
//DBG::deactivate(DBG_DB);
//\DBG::log("Orders: ".count($arrOrders));
$paging = \Paging::get($uri, $_ARRAYLANG['TXT_ORDERS'], $count, $limit, $count > 0);
$objTemplate->setVariable(array('SHOP_ORDER_PAGING' => $paging, 'SHOP_CUSTOMER_LISTLETTER' => isset($filter['letter']) ? $filter['letter'] : '', 'SHOP_HEADER_ID' => $objSorting->getHeaderForField('id'), 'SHOP_HEADER_DATE_TIME' => $objSorting->getHeaderForField('date_time'), 'SHOP_HEADER_STATUS' => $objSorting->getHeaderForField('status'), 'SHOP_HEADER_CUSTOMER_NAME' => $objSorting->getHeaderForField('customer_name'), 'SHOP_HEADER_NOTES' => $_ARRAYLANG['TXT_SHOP_ORDER_NOTES'], 'SHOP_HEADER_SUM' => $objSorting->getHeaderForField('sum'), 'SHOP_LISTLETTER_LINKS' => self::getListletterLinks(isset($filter['letter']) ? $filter['letter'] : NULL)));
if (empty($arrOrders)) {
// $objTemplate->hideBlock('orderTable');
$objTemplate->setVariable('SHOP_ORDER_NONE_FOUND', $_ARRAYLANG['TXT_SHOP_ORDERS_NONE_FOUND']);
//\DBG::log("NO Orders!");
return true;
}
$i = 0;
// TODO: For Order export
/* $min_date = '9999-00-00 00:00:00';
$max_date = '0000-00-00 00:00:00';
$min_id = 1e10;
$max_id = 0;*/
foreach ($arrOrders as $objOrder) {
$order_id = $objOrder->id();
// Custom order ID may be created and used as account name.
// Adapt the method as needed.
// $order_id_custom = ShopLibrary::getCustomOrderId(
// $order_id, $objOrder->date_time()
// );
// Take billing address from the Order.
// No need to load the Customer.
$customer_name = '';
$company = $objOrder->billing_company();
$customer_name = $company ? $company : $objOrder->billing_lastname() . ' ' . $objOrder->billing_firstname();
$tipNote = $objOrder->note();
$tipLink = empty($tipNote) ? '' : '<span class="tooltip-trigger icon-comment"></span>' . '<span class="tooltip-message">' . preg_replace('/[\\n\\r]+/', '<br />', nl2br(contrexx_raw2xhtml($tipNote))) . '</span>';
$status = $objOrder->status();
$objTemplate->setVariable(array('SHOP_ROWCLASS' => $status == 0 ? 'rowwarn' : 'row' . (++$i % 2 + 1), 'SHOP_ORDERID' => $order_id, 'SHOP_TIP_LINK' => $tipLink, 'SHOP_DATE' => date(ASCMS_DATE_FORMAT_DATETIME, strtotime($objOrder->date_time())), 'SHOP_NAME' => $customer_name, 'SHOP_ORDER_SUM' => Currency::getDefaultCurrencyPrice($objOrder->sum()), 'SHOP_ORDER_STATUS' => $backend ? self::getStatusMenu(intval($status), false, $order_id, 'changeOrderStatus(' . $order_id . ',' . $status . ',this.value)') : $_ARRAYLANG['TXT_SHOP_ORDER_STATUS_' . $status]));
$objTemplate->parse('orderRow');
//\DBG::log("Parsed Order ID $order_id");
// TODO: Order export
/* if ($objOrder->date_time() < $min_date)
$min_date = $objOrder->date_time();
if ($objOrder->date_time() > $max_date)
$max_date = $objOrder->date_time();
if ($objOrder->id() < $min_id) $min_id = $objOrder->id();
if ($objOrder->id() > $max_id) $max_id = $objOrder->id();*/
}
$objTemplate->setVariable('SHOP_ORDER_PAGING', $paging);
// TODO: Order export
/* $arrId = range($min_id-1, $max_id);
$arrId = array(0 => "0") + array_combine($arrId, $arrId);
$objTemplate->setVariable(array(
'SHOP_ORDER_EXPORT_LAST_ID_MENUOPTIONS' =>
Html::getOptions($arrId),
'SHOP_ORDER_EXPORT_START_DATE' =>
Html::getDatepicker('start_date', array(
'defaultDate' => date(ASCMS_DATE_FORMAT_DATE,
strtotime($min_date)),
'minDate' => '-7d',
'maxDate' => '+0d', )),
'SHOP_ORDER_EXPORT_END_DATE' =>
Html::getDatepicker('end_date', array(
'defaultDate' => date(ASCMS_DATE_FORMAT_DATE,
strtotime($max_date)+86400),
'minDate' => '-6d',
'maxDate' => '+1d', )),
));
//die("Template: ". nl2br(htmlentities(var_export($objTemplate, true))));
//die("Template: ". $objTemplate->get());*/
return true;
}
*/
include_once 'Sorting.php';
$arr = array();
for ($i = 0; $i < 100; $i++) {
$arr[] = rand(1, 100);
}
var_dump($arr);
$start = microtime(true);
var_dump(Sorting::BubbleClassic($arr));
$time = microtime(true) - $start;
printf('Скрипт выполнялся %.4F сек.', $time);
$start = microtime(true);
var_dump(Sorting::BubbleOptimizedLength($arr));
$time = microtime(true) - $start;
printf('Скрипт выполнялся %.4F сек.', $time);
$start = microtime(true);
var_dump(Sorting::BubbleOptimizedLengthAndCount($arr));
$time = microtime(true) - $start;
printf('Скрипт выполнялся %.4F сек.', $time);
$start = microtime(true);
var_dump(Sorting::BubbleOptimizedLengthAndCountAndDirection($arr));
$time = microtime(true) - $start;
printf('Скрипт выполнялся %.4F сек.', $time);
$start = microtime(true);
var_dump(Sorting::GnomeClassic($arr));
$time = microtime(true) - $start;
printf('Скрипт выполнялся %.4F сек.', $time);
$start = microtime(true);
var_dump(Sorting::GnomeOptimized($arr));
$time = microtime(true) - $start;
printf('Скрипт выполнялся %.4F сек.', $time);
public function addFile($file, $etichetta, $id)
{
$result = false;
$etichetta = $this->conn->str($etichetta);
$sort = new Sorting("file", "sorting", "fk_tabella=" . $this->idTabella . " and fk_record=" . $id);
$sorting = $sort->restituisci_max_sorting() + 1;
$query = "insert into file (file, fk_tabella, fk_record, tipoF, titoloF, sorting) values ('" . $file . "', " . $this->idTabella . ", " . $id . ", '" . $this->tipo . "', '" . $etichetta . "', " . $sorting . ")";
print $query . "<br /><br />";
if ($this->conn->query($query)) {
$result = true;
}
return $result;
}
/**
* Sets up the Country settings page
* @return string The page content
*/
static function settings()
{
global $_CORELANG;
$objTemplateCountry = new \Cx\Core\Html\Sigma(\Env::get('cx')->getCodeBaseCorePath() . '/Country/View/Template/Generic');
$objTemplateCountry->loadTemplateFile('Overview.html');
// Adds messages
self::storeSettings();
self::storeFromPost();
$uri = \Html::getRelativeUri();
// Let all links in this tab point here again
\Html::replaceUriParameter($uri, 'active_tab=' . \Cx\Core\Setting\Controller\Setting::tab_index());
// Create a copy of the URI for the Paging, as this is passed by
// reference and modified
$uri_paging = $uri;
//DBG::log("URI: $uri");
$objSorting = new Sorting($uri, array('id' => $_CORELANG['TXT_CORE_COUNTRY_ID'], 'active' => $_CORELANG['TXT_CORE_COUNTRY_ACTIVE'], 'ord' => $_CORELANG['TXT_CORE_COUNTRY_ORD'], 'name' => $_CORELANG['TXT_CORE_COUNTRY_NAME'], 'alpha2' => $_CORELANG['TXT_CORE_COUNTRY_ISO2'], 'alpha3' => $_CORELANG['TXT_CORE_COUNTRY_ISO3']), true, 'order_country');
\Cx\Core\Setting\Controller\Setting::init('core', 'country');
$limit = \Cx\Core\Setting\Controller\Setting::getValue('numof_countries_per_page_backend', 'core');
$count = 0;
$arrCountries = self::getArray($count, null, $limit, \Paging::getPosition(), $objSorting->getOrder());
if ($arrCountries === false) {
return \Message::error($_CORELANG['TXT_CORE_COUNTRY_ERROR_INITIALIZING']);
}
$objTemplateCountry->setGlobalVariable($_CORELANG + array('CORE_COUNTRY' => $_CORELANG['TXT_CORE_COUNTRY'] . ' ' . sprintf($_CORELANG['TXT_CORE_TOTAL'], $count), 'HEAD_SETTINGS_COUNTRY_ID' => $objSorting->getHeaderForField('id'), 'HEAD_SETTINGS_COUNTRY_ACTIVE' => $objSorting->getHeaderForField('active'), 'HEAD_SETTINGS_COUNTRY_ORD' => $objSorting->getHeaderForField('ord'), 'HEAD_SETTINGS_COUNTRY_NAME' => $objSorting->getHeaderForField('name'), 'HEAD_SETTINGS_COUNTRY_ISO2' => $objSorting->getHeaderForField('alpha2'), 'HEAD_SETTINGS_COUNTRY_ISO3' => $objSorting->getHeaderForField('alpha3'), 'CORE_SETTING_TAB_INDEX' => \Cx\Core\Setting\Controller\Setting::tab_index(), 'SETTINGS_COUNTRY_PAGING' => \Paging::get($uri_paging, '', $count, $limit, true)));
// Note: Optionally disable the block 'settings_country_submit'
// to disable storing changes
$i = 0;
foreach ($arrCountries as $country_id => $arrCountry) {
$objTemplateCountry->setVariable(array('SETTINGS_COUNTRY_ROWCLASS' => ++$i % 2 + 1, 'SETTINGS_COUNTRY_ID' => $country_id, 'SETTINGS_COUNTRY_ACTIVE' => $arrCountry['active'] ? \Html::ATTRIBUTE_CHECKED : '', 'SETTINGS_COUNTRY_ORD' => $arrCountry['ord'], 'SETTINGS_COUNTRY_NAME' => $arrCountry['name'], 'SETTINGS_COUNTRY_ISO2' => $arrCountry['alpha2'], 'SETTINGS_COUNTRY_ISO3' => $arrCountry['alpha3'], 'SETTINGS_FUNCTIONS' => \Html::getBackendFunctions(array('delete' => 'delete_country_id=' . $country_id), array('delete' => $_CORELANG['TXT_CORE_COUNTRY_CONFIRM_DELETE'] . "\\n" . $_CORELANG['TXT_ACTION_IS_IRREVERSIBLE']))));
$objTemplateCountry->parse('settings_country_row');
}
$objTemplateSetting = null;
\Cx\Core\Setting\Controller\Setting::show_external($objTemplateSetting, $_CORELANG['TXT_CORE_COUNTRY_EDIT'], $objTemplateCountry->get());
\Cx\Core\Setting\Controller\Setting::show($objTemplateSetting, $uri, $_CORELANG['TXT_CORE_COUNTRY_SETTINGS'], $_CORELANG['TXT_CORE_COUNTRY_SETTINGS']);
return $objTemplateSetting->get();
}
function modifica_sorting()
{
$id = $_REQUEST["id"];
$azione = $_REQUEST["azione"];
$campoId = $_REQUEST["campoId"];
$tbl = $_REQUEST["tabella"];
$campoSorting = $_REQUEST["campoSor"];
$condizioni = $_REQUEST["condizioni"];
$sort = new Sorting($tbl, $campoSorting, $condizioni);
$sort->cambia_ordinamento_campi($id, $azione, $campoId);
}
function _contactForms()
{
global $_CORELANG, $_ARRAYLANG;
$this->_objTpl->loadTemplateFile('module_contact_forms_overview.html');
$this->_pageTitle = $_ARRAYLANG['TXT_CONTACT_CONTACT_FORMS'];
$uri = \Html::getRelativeUri_entities();
$objSorting = new \Sorting($uri, array('latestEntry' => $_ARRAYLANG['TXT_CONTACT_LATEST_ENTRY'], 'id' => $_ARRAYLANG['TXT_CONTACT_ID'], 'name' => $_ARRAYLANG['TXT_CONTACT_NAME'], 'numberOfEntries' => $_ARRAYLANG['TXT_CONTACT_NUMBER_OF_ENTRIES']), false, 'order_forms');
$this->_objTpl->setVariable(array('TXT_CONTACT_CONFIRM_DELETE_FORM' => $_ARRAYLANG['TXT_CONTACT_CONFIRM_DELETE_FORM'], 'TXT_CONTACT_FORM_ENTRIES_WILL_BE_DELETED' => $_ARRAYLANG['TXT_CONTACT_FORM_ENTRIES_WILL_BE_DELETED'], 'TXT_CONTACT_ACTION_IS_IRREVERSIBLE' => $_ARRAYLANG['TXT_CONTACT_ACTION_IS_IRREVERSIBLE'], 'TXT_CONTACT_CONTACT_FORMS' => $_ARRAYLANG['TXT_CONTACT_CONTACT_FORMS'], 'TXT_CONTACT_LANGUAGE' => $_ARRAYLANG['TXT_CONTACT_LANGUAGE'], 'TXT_CONTACT_FUNCTIONS' => $_ARRAYLANG['TXT_CONTACT_FUNCTIONS'], 'TXT_CONTACT_ADD_NEW_CONTACT_FORM' => $_ARRAYLANG['TXT_CONTACT_ADD_NEW_CONTACT_FORM'], 'TXT_CONTACT_CONFIRM_DELETE_CONTENT_SITE' => $_ARRAYLANG['TXT_CONTACT_CONFIRM_DELETE_CONTENT_SITE'], 'TXT_CONTACT_ID' => $objSorting->getHeaderForField('id'), 'TXT_CONTACT_NAME' => $objSorting->getHeaderForField('name'), 'TXT_CONTACT_LATEST_ENTRY' => $objSorting->getHeaderForField('latestEntry'), 'TXT_CONTACT_NUMBER_OF_ENTRIES' => $objSorting->getHeaderForField('numberOfEntries')));
$this->_objTpl->setGlobalVariable(array('TXT_CONTACT_MODIFY' => $_ARRAYLANG['TXT_CONTACT_MODIFY'], 'TXT_CONTACT_DELETE' => $_ARRAYLANG['TXT_CONTACT_DELETE'], 'TXT_CONTACT_SHOW_SOURCECODE' => $_ARRAYLANG['TXT_CONTACT_SHOW_SOURCECODE'], 'TXT_CONTACT_USE_AS_TEMPLATE' => $_ARRAYLANG['TXT_CONTACT_USE_AS_TEMPLATE'], 'TXT_CONTACT_GET_CSV' => $_ARRAYLANG['TXT_CONTACT_GET_CSV'], 'TXT_CONTACT_CSV_TOOLTIP' => $_ARRAYLANG['TXT_CONTACT_CSV_TOOLTIP'], 'TXT_CONTACT_XLS_TOOLTIP' => $_ARRAYLANG['TXT_CONTACT_XLS_TOOLTIP'], 'TXT_CONTACT_DOWNLOAD' => $_ARRAYLANG['TXT_CONTACT_DOWNLOAD']));
$this->initContactForms($objSorting->getOrder());
$rowNr = 0;
if (is_array($this->arrForms)) {
foreach ($this->arrForms as $formId => $arrForm) {
$formName = '';
$entryCount = '-';
$pageRepo = $this->em->getRepository('\\Cx\\Core\\ContentManager\\Model\\Entity\\Page');
$page = $pageRepo->findOneBy(array('module' => 'Contact', 'cmd' => $formId, 'type' => \Cx\Core\ContentManager\Model\Entity\Page::TYPE_APPLICATION));
$pageExists = $page !== null;
$this->_objTpl->setGlobalVariable('CONTACT_FORM_ID', $formId);
if (isset($arrForm['lang'][FRONTEND_LANG_ID])) {
$selectedInterfaceLanguage = FRONTEND_LANG_ID;
} elseif (isset($arrForm['lang'][\FWLanguage::getDefaultLangId()])) {
$selectedInterfaceLanguage = \FWLanguage::getDefaultLangId();
} else {
$selectedInterfaceLanguage = key($arrForm['lang']);
}
$pages = $this->em->getRepository('Cx\\Core\\ContentManager\\Model\\Entity\\Page')->getFromModuleCmdByLang('Contact', $formId);
$lang = array();
$activeLanguages = \FWLanguage::getActiveFrontendLanguages();
foreach ($arrForm['lang'] as $langId => $value) {
if (!array_key_exists($langId, $activeLanguages)) {
continue;
}
$links = '';
if (isset($pages[$langId])) {
$previewURL = '../' . \FWLanguage::getLanguageCodeById($langId) . $pages[$langId]->getPath();
$links = \FWLanguage::getLanguageCodeById($langId) . '<a title="' . $_CORELANG['TXT_CORE_EDIT_PAGE_LAYOUT'] . '" href="index.php?cmd=ContentManager&page=' . $pages[$langId]->getId() . '&tab=content" class="view">' . '<img src="../core/Core/View/Media/icons/green_arrow_down.png" />' . '</a>' . '<a title="' . $_CORELANG['TXT_CORE_SHOW_FRONTEND_VIEW'] . '" target="_blank" href="' . $previewURL . '" class="view">' . '<img src="../core/Core/View/Media/icons/blue_arrow_up.png" />' . '</a>';
} else {
$links = \FWLanguage::getLanguageCodeById($langId);
}
$lang[] = '<span class="lang">' . $links . '</span>';
}
$langString = implode($lang);
$formName = contrexx_raw2xhtml($arrForm['lang'][$selectedInterfaceLanguage]['name']);
$useCrm = !empty($arrForm['saveDataInCRM']) ? " <img style='margin-top: 2px;' src='../core/Core/View/Media/navigation_level_1_189.png' class='tooltip-trigger' alt='crm' /><span class='tooltip-message'>" . $_ARRAYLANG['TXT_CONTACT_FORM_USED_IN_CRM'] . "</span>" : '';
// check if the form contains submitted data
$arrFormNumber = isset($arrForm['number']) ? $arrForm['number'] : 0;
if ($arrFormNumber > 0) {
$entryCount = $arrFormNumber;
$formName = "<a href='index.php?cmd=Contact&act=forms&tpl=entries&formId=" . $formId . "' title='" . $_ARRAYLANG['TXT_CONTACT_SHOW_ENTRIES'] . "'>" . $formName . "</a>";
$this->_objTpl->touchBlock('contact_export');
} else {
$this->_objTpl->hideBlock('contact_export');
}
$this->_objTpl->setVariable(array('TXT_CONTACT_VIEW' => $_CORELANG['TXT_CORE_CM_VIEW'], 'CONTACT_FORM_ROW_CLASS' => $rowNr % 2 == 1 ? 'row1' : 'row2', 'CONTACT_FORM_NAME' => $formName, 'CONTACT_CRM_IMG' => $useCrm, 'CONTACT_FORM_LAST_ENTRY' => !empty($arrForm['last']) ? date(ASCMS_DATE_FORMAT, $arrForm['last']) : '-', 'CONTACT_FORM_NUMBER_OF_ENTRIES' => $entryCount, 'CONTACT_DELETE_CONTENT' => $pageExists ? 'true' : 'false', 'CONTACT_FORM_LANGUAGES' => $langString));
$this->_objTpl->parse('contact_contact_forms');
$rowNr++;
}
}
}
/**
* @param string $field
* @param string $direction
*/
public function __construct($field, $direction = 'ASC')
{
$this->field = $field;
parent::__construct($direction);
}
/**
* Show Products
*/
function view_product_overview()
{
global $_ARRAYLANG;
if (isset($_POST['bsubmit'])) {
$this->update_products();
}
if (isset($_POST['multi_action'])) {
if ($_POST['multi_action'] == 'activate') {
Products::set_active($_POST['selectedProductId'], true);
} elseif ($_POST['multi_action'] == 'deactivate') {
Products::set_active($_POST['selectedProductId'], false);
}
}
self::$objTemplate->addBlockfile('SHOP_PRODUCTS_FILE', 'shop_products_block', 'module_shop_product_catalog.html');
self::$objTemplate->setGlobalVariable($_ARRAYLANG);
$category_id = empty($_REQUEST['category_id']) ? null : intval($_REQUEST['category_id']);
//DBG::log("Requested Category ID: $category_id");
$manufacturer_id = empty($_REQUEST['manufacturer_id']) ? null : intval($_REQUEST['manufacturer_id']);
$flagSpecialoffer = isset($_REQUEST['specialoffer']);
$searchTerm = empty($_REQUEST['searchterm']) ? null : trim(contrexx_input2raw($_REQUEST['searchterm']));
$url = \Html::getRelativeUri();
// TODO: Strip URL parameters: Which?
// \Html::stripUriParam($url, '');
$arrSorting = array('`product`.`id`' => $_ARRAYLANG['TXT_SHOP_ID'], '`product`.`active`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_ACTIVE'], '`product`.`ord`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_ORDER'], 'name' => $_ARRAYLANG['TXT_SHOP_PRODUCT_NAME'], 'code' => $_ARRAYLANG['TXT_SHOP_PRODUCT_CODE'], '`product`.`discountprice`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_DISCOUNTPRICE'], '`product`.`normalprice`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_NORMALPRICE'], '`product`.`resellerprice`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_RESELLERPRICE'], '`product`.`distribution`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_DISTRIBUTION'], '`product`.`stock`' => $_ARRAYLANG['TXT_SHOP_PRODUCT_STOCK']);
$objSorting = new \Sorting($url, $arrSorting, false, 'order_shop_product');
$limit = \Cx\Core\Setting\Controller\Setting::getValue('numof_products_per_page_backend', 'Shop');
$tries = 2;
while ($tries--) {
// have to set $count again because it will be set to 0 in Products::getByShopParams
$count = $limit;
// Mind that $count is handed over by reference.
$arrProducts = Products::getByShopParams($count, \Paging::getPosition(), 0, $category_id, $manufacturer_id, $searchTerm, $flagSpecialoffer, false, $objSorting->getOrder(), null, true);
if (count($arrProducts) > 0 || \Paging::getPosition() == 0) {
break;
}
\Paging::reset();
}
self::$objTemplate->setVariable(array('SHOP_CATEGORY_MENU' => \Html::getSelect('category_id', array(0 => $_ARRAYLANG['TXT_ALL_PRODUCT_GROUPS']) + ShopCategories::getNameArray(), $category_id), 'SHOP_SEARCH_TERM' => $searchTerm, 'SHOP_PRODUCT_TOTAL' => $count));
if (empty($arrProducts)) {
self::$objTemplate->touchBlock('no_product');
return true;
}
self::$objTemplate->setVariable(array('SHOP_PRODUCT_PAGING' => \Paging::get($url, '<b>' . $_ARRAYLANG['TXT_PRODUCTS'] . '</b>', $count, $limit, true), 'SHOP_HEADING_PRODUCT_ID' => $objSorting->getHeaderForField('`product`.`id`'), 'SHOP_HEADING_PRODUCT_ACTIVE' => $objSorting->getHeaderForField('`product`.`active`'), 'SHOP_HEADING_PRODUCT_ORD' => $objSorting->getHeaderForField('`product`.`ord`'), 'SHOP_HEADING_PRODUCT_NAME' => $objSorting->getHeaderForField('name'), 'SHOP_HEADING_PRODUCT_CODE' => $objSorting->getHeaderForField('code'), 'SHOP_HEADING_PRODUCT_DISCOUNTPRICE' => $objSorting->getHeaderForField('`product`.`discountprice`'), 'SHOP_HEADING_PRODUCT_NORMALPRICE' => $objSorting->getHeaderForField('`product`.`normalprice`'), 'SHOP_HEADING_PRODUCT_RESELLERPRICE' => $objSorting->getHeaderForField('`product`.`resellerprice`'), 'SHOP_HEADING_PRODUCT_DISTRIBUTION' => $objSorting->getHeaderForField('`product`.`distribution`'), 'SHOP_HEADING_PRODUCT_STOCK' => $objSorting->getHeaderForField('`product`.`stock`')));
$arrLanguages = \FWLanguage::getActiveFrontendLanguages();
// Intended to show an edit link for all active frontend languages.
// However, the design doesn't like it. Limit to the current one.
$arrLanguages = array(FRONTEND_LANG_ID => $arrLanguages[FRONTEND_LANG_ID]);
$i = 0;
foreach ($arrProducts as $objProduct) {
$productStatus = '';
$productStatusValue = '';
$productStatusPicture = 'status_red.gif';
if ($objProduct->active()) {
$productStatus = \Html::ATTRIBUTE_CHECKED;
$productStatusValue = 1;
$productStatusPicture = 'status_green.gif';
}
$discount_active = '';
$specialOfferValue = '';
if ($objProduct->discount_active()) {
$discount_active = \Html::ATTRIBUTE_CHECKED;
$specialOfferValue = 1;
}
self::$objTemplate->setGlobalVariable(array('SHOP_ROWCLASS' => 'row' . (++$i % 2 + 1), 'SHOP_PRODUCT_ID' => $objProduct->id(), 'SHOP_PRODUCT_CODE' => $objProduct->code(), 'SHOP_PRODUCT_NAME' => contrexx_raw2xhtml($objProduct->name()), 'SHOP_PRODUCT_PRICE1' => Currency::formatPrice($objProduct->price()), 'SHOP_PRODUCT_PRICE2' => Currency::formatPrice($objProduct->resellerprice()), 'SHOP_PRODUCT_DISCOUNT' => Currency::formatPrice($objProduct->discountprice()), 'SHOP_PRODUCT_SPECIAL_OFFER' => $discount_active, 'SHOP_SPECIAL_OFFER_VALUE_OLD' => $specialOfferValue, 'SHOP_PRODUCT_VAT_MENU' => Vat::getShortMenuString($objProduct->vat_id(), 'taxId[' . $objProduct->id() . ']'), 'SHOP_PRODUCT_VAT_ID' => $objProduct->vat_id() ? $objProduct->vat_id() : 'NULL', 'SHOP_PRODUCT_DISTRIBUTION' => $objProduct->distribution(), 'SHOP_PRODUCT_STOCK' => $objProduct->stock(), 'SHOP_PRODUCT_SHORT_DESC' => $objProduct->short(), 'SHOP_PRODUCT_STATUS' => $productStatus, 'SHOP_PRODUCT_STATUS_PICTURE' => $productStatusPicture, 'SHOP_ACTIVE_VALUE_OLD' => $productStatusValue, 'SHOP_SORT_ORDER' => $objProduct->ord(), 'SHOP_DISTRIBUTION' => $_ARRAYLANG['TXT_DISTRIBUTION_' . strtoupper($objProduct->distribution())], 'SHOP_SHOW_PRODUCT_ON_START_PAGE_CHECKED' => $objProduct->shown_on_startpage() ? \Html::ATTRIBUTE_CHECKED : '', 'SHOP_SHOW_PRODUCT_ON_START_PAGE_OLD' => $objProduct->shown_on_startpage() ? '1' : '', 'SHOP_PRODUCT_NAME' => contrexx_raw2xhtml($objProduct->name())));
// All languages active
foreach ($arrLanguages as $lang_id => $arrLanguage) {
self::$objTemplate->setVariable(array('SHOP_PRODUCT_LANGUAGE_ID' => $lang_id, 'SHOP_PRODUCT_LANGUAGE_EDIT' => sprintf($_ARRAYLANG['TXT_SHOP_PRODUCT_LANGUAGE_EDIT'], $lang_id, $arrLanguage['lang'], $arrLanguage['name'])));
self::$objTemplate->parse('product_language');
}
self::$objTemplate->touchBlock('productRow');
self::$objTemplate->parse('productRow');
}
return true;
}
/**
* Show on overview of the mail templates for the given section and group
*
* If empty, the $limit defaults to the
* "numof_mailtemplate_per_page_backend" setting for the given section
* and group.
* @param string $section The section
* @param string $group The group
* @param integer $limit The optional limit for the number
* of templates to be shown
* @param string $act The action of the mail template
* default set to mailtemplate_overview
* @return \Cx\Core\Html\Sigma The template object
*/
static function overview($section, $group, $limit = 0, $useDefaultActs = true, $act = 'mailtemplate_edit')
{
global $_CORELANG;
$objTemplateLocal = new \Cx\Core\Html\Sigma(\Env::get('cx')->getCodeBaseCorePath() . '/MailTemplate/View/Template/Generic');
$objTemplateLocal->setErrorHandling(PEAR_ERROR_DIE);
\Cx\Core\Csrf\Controller\Csrf::add_placeholder($objTemplateLocal);
if (!$objTemplateLocal->loadTemplateFile('Overview.html')) {
die("Failed to load template Overview.html");
}
if (empty($section) || empty($group)) {
\Message::error($_CORELANG['TXT_CORE_MAILTEMPLATE_ERROR_NO_SECTION_OR_GROUP']);
return false;
}
if (empty($limit)) {
\Cx\Core\Setting\Controller\Setting::init($section, $group);
$limit = \Cx\Core\Setting\Controller\Setting::getValue('numof_mailtemplate_per_page_backend', $section);
// TODO: TEMPORARY
if (is_null($limit)) {
$limit = 25;
\Cx\Core\Setting\Controller\Setting::add('numof_mailtemplate_per_page_backend', $limit, 1001, 'text', '', $group);
}
}
$uri = \Html::getRelativeUri_entities();
$tab_index = \Cx\Core\Setting\Controller\Setting::tab_index();
\Html::replaceUriParameter($uri, 'active_tab=' . $tab_index);
\Html::replaceUriParameter($uri, 'userFrontendLangId=' . FRONTEND_LANG_ID);
//echo("Made uri for sorting: ".htmlentities($uri)."<br />");
\Html::stripUriParam($uri, 'key');
\Html::stripUriParam($uri, 'delete_mailtemplate_key');
$uri_edit = $uri_overview = $uri;
//echo("Made uri for sorting: ".htmlentities($uri)."<br />");
if ($useDefaultActs) {
\Html::stripUriParam($uri, 'act');
\Html::replaceUriParameter($uri_edit, 'act=mailtemplate_edit');
\Html::replaceUriParameter($uri_overview, 'act=mailtemplate_overview');
}
$objSorting = new \Sorting($uri_overview, array('name' => $_CORELANG['TXT_CORE_MAILTEMPLATE_NAME'], 'key' => $_CORELANG['TXT_CORE_MAILTEMPLATE_KEY'], 'html' => $_CORELANG['TXT_CORE_MAILTEMPLATE_IS_HTML'], 'protected' => $_CORELANG['TXT_CORE_MAILTEMPLATE_PROTECTED']), true, 'order_mailtemplate');
$count = 0;
// Template titles are shown in the current language only, no need
// (and no way either) to load them all. Names are shown in the
// currently active frontend language only.
$pagingParameterName = $section . '_' . $group;
$arrTemplates = self::getArray($section, FRONTEND_LANG_ID, $objSorting->getOrder(), \Paging::getPosition($pagingParameterName), $limit, $count);
$arrLanguageName = \FWLanguage::getNameArray();
$objTemplateLocal->setGlobalVariable($_CORELANG + array('CORE_MAILTEMPLATE_NAME' => $objSorting->getHeaderForField('name'), 'CORE_MAILTEMPLATE_KEY' => $objSorting->getHeaderForField('key'), 'CORE_MAILTEMPLATE_HTML' => $objSorting->getHeaderForField('html'), 'CORE_MAILTEMPLATE_PROTECTED' => $objSorting->getHeaderForField('protected'), 'PAGING' => \Paging::get($uri_overview, $_CORELANG['TXT_CORE_MAILTEMPLATE_PAGING'], $count, $limit, true, null, $pagingParameterName), 'URI_BASE' => $uri, 'URI_EDIT' => $uri_edit, 'CORE_MAILTEMPLATE_COLSPAN' => 5 + count($arrLanguageName)));
foreach ($arrLanguageName as $language_name) {
$objTemplateLocal->setVariable('MAILTEMPLATE_LANGUAGE_HEADER', $language_name);
$objTemplateLocal->parse('core_mailtemplate_language_header');
}
if (empty($arrTemplates)) {
\Message::information($_CORELANG['TXT_CORE_MAILTEMPLATE_WARNING_NONE']);
$arrTemplates = array();
}
// Load *all* templates and languages
self::init($section);
$i = 0;
foreach ($arrTemplates as $arrTemplate) {
$key = $arrTemplate['key'];
$objTemplateLocal->setVariable(array('MAILTEMPLATE_ROWCLASS' => ++$i % 2 + 1, 'MAILTEMPLATE_PROTECTED' => \Html::getCheckmark($arrTemplate['protected']), 'MAILTEMPLATE_HTML' => \Html::getCheckmark($arrTemplate['html']), 'MAILTEMPLATE_NAME' => '<a href="' . $uri_edit . '&key=' . urlencode($key) . '">' . contrexx_raw2xhtml($arrTemplate['name']) . '</a>', 'MAILTEMPLATE_KEY' => $arrTemplate['key'], 'MAILTEMPLATE_FUNCTIONS' => \Html::getBackendFunctions(array('copy' => $uri_edit . '&copy=1&key=' . $arrTemplate['key'], 'edit' => $uri_edit . '&key=' . $arrTemplate['key'], 'delete' => $arrTemplate['protected'] ? '' : $uri_overview . '&delete_mailtemplate_key=' . $arrTemplate['key'] . '&csrf=' . \Cx\Core\Csrf\Controller\Csrf::code()), array('delete' => $_CORELANG['TXT_CORE_MAILTEMPLATE_DELETE_CONFIRM']))));
foreach (array_keys($arrLanguageName) as $lang_id) {
$available = isset(self::$arrTemplates[$lang_id][$key]) && self::$arrTemplates[$lang_id][$key]['available'];
$title = $available ? $_CORELANG['TXT_CORE_MAILTEMPLATE_EDIT'] : $_CORELANG['TXT_CORE_MAILTEMPLATE_NEW'];
$icon = '<a href="' . CONTREXX_DIRECTORY_INDEX . "?cmd={$section}&act=" . $act . '&key=' . $key . '&userFrontendLangId=' . $lang_id . '"' . ' title="' . $title . '">' . '<img src="../core/Core/View/Media/icons/' . ($available ? 'edit.gif' : 'add.png') . '"' . ' width="16" height="16" alt="' . $title . '" border="0" /></a>';
$objTemplateLocal->setVariable('MAILTEMPLATE_LANGUAGE', $icon);
$objTemplateLocal->parse('core_mailtemplate_language_column');
}
$objTemplateLocal->parse('core_mailtemplate_row');
}
return $objTemplateLocal;
}
