'.$row['language_code'].'';
$langselblock .= '';
$langids[] = $row["id_lang"];
$langcodes[$row["id_lang"]] = $row["iso_code"];
}
if(!isset($iso_code))
{ $iso_code = $def_iso_code;
$languagename = $def_langname;
echo "Illegal value for default or selected language! Using ".$languagename;
}
/* section 3: make field declarations and build infofields array of displayed fields */
$infofields = array(); /* this will hold the displayed fields with a copy of the field_array entries */
$if_index = 0;
/* [0]always same as key, [1]language specific texts, [2]source, [3]display(0=not;1=yes;2=edit;), [4]fieldwidth(0=not set),
[5]align(0=default;1=right), [6]not used, [7]Editable, [8]tablefield (used in search block) */
define("HIDE", 0); define("DISPLAY", 1); define("EDIT", 2); // display
define("LEFT", 0); define("RIGHT", 1); // align
define("NOT_EDITABLE", 0); define("INPUT", 1); define("TEXTAREA", 2); define("DROPDOWN", 3); define("BINARY", 4); define("EDIT_BTN", 5); /* title, keyover, source, display(0=not;1=yes;2=edit), fieldwidth(0=not set), align(0=default;1=right), sortfield */
/* sortfield => 0=no escape removal; 1=escape removal; 2 and higher= escape removal and n lines textarea */
$infofields[$if_index++] = array("",array("","",""), "", DISPLAY, 0, LEFT, 0,0);
$field_array = array(
"accessories" => array("accessories",null, "accessories", DISPLAY, 0, LEFT, null, INPUT, "accessories"),
"active" => array("active",null, "active", DISPLAY, 0, LEFT, null, BINARY, "ps.active"),
"aDeliveryT" => array("aDeliveryT",null, "additional_delivery_times", DISPLAY, 1, LEFT, null, INPUT, "p.additional_delivery_times"),
"aShipCost" => array("aShipCost",null, "additional_shipping_cost", DISPLAY, 0, LEFT, null, INPUT, "ps.additional_shipping_cost"),
"attachmnts" => array("attachmnts",null, "attachmnts", DISPLAY, 0, LEFT, null, INPUT, ""),
"available_now" => array("available_now",null, "available_now", DISPLAY, 0, LEFT, null, INPUT, "pl.available_now"),
"available_later" => array("available_later",null, "available_later", DISPLAY, 0, LEFT, null, INPUT, "pl.available_later"),
"available_date" => array("available_date",null, "available_date", DISPLAY, 0, LEFT, null, BINARY, "ps.available_date"),
/* availorder combines two of Prestashop's datafields: available_for_order and show_price */
"availorder" => array("availorder",null, "available_for_order", DISPLAY, 0, LEFT, null, BINARY, "ps.available_for_order"),
"carrier" => array("carrier",null, "carrier", DISPLAY, 0, LEFT, null, DROPDOWN, "cr.name"),
"category" => array("category",null, "id_category_default", DISPLAY, 0, LEFT, null, DROPDOWN, "ps.id_category_default"),
"combinations" => array("combinations",null, "combinations", DISPLAY, 0, LEFT, 0, INPUT, "combinations"),
"condition" => array("condition",null, "condition", DISPLAY, 0, LEFT, null, DROPDOWN, "ps.condition"),
"customizations" => array("customizations",null, "custFlds", DISPLAY, 0, LEFT, null, INPUT, "custFlds"),
"date_add" => array("date_add",null, "date_add", DISPLAY, 0, LEFT, null, BINARY, "ps.date_add"),
"date_upd" => array("date_upd",null, "date_upd", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "ps.date_upd"),
"deliInStock" => array("deliInStock",null, "delivery_in_stock", DISPLAY, 0, LEFT, null, INPUT, "pl.delivery_in_stock"),
"deliOutStock" => array("deliOutStock",null, "delivery_out_stock", DISPLAY, 0, LEFT, null, INPUT, "pl.delivery_out_stock"),
"description" => array("description",null, "description", DISPLAY, 0, LEFT, null, TEXTAREA, "pl.description"),
"description_short" => array("description_short",null, "description_short", DISPLAY, 0, LEFT, null, TEXTAREA, "pl.description_short"),
"discount" => array("discount",null, "discount", DISPLAY, 0, LEFT, null, INPUT, "discount"),
"ean" => array("ean",null, "ean13", DISPLAY, 200, LEFT, null, INPUT, "p.ean13"),
"ecotax" => array("ecotax",null, "ecotax", DISPLAY, 200, LEFT, null, INPUT, "ps.ecotax"),
"featureEdit" => array("featureEdit",null, "name", DISPLAY, 0, LEFT, null, NOT_EDITABLE, ""), // name here is a dummy that is not used
"isbn" => array("isbn",null, "isbn", DISPLAY, 0, LEFT, null, INPUT, "p.isbn"),
"id_product" => array("id_product",array("id","id","id"), "id_product", DISPLAY, 0, RIGHT, null,NOT_EDITABLE, "p.id_product"),
"image" => array("image",null, "name", DISPLAY, 0, LEFT, 0, EDIT_BTN, ""), // name here is a dummy that is not used
"indexed" => array("indexed",null, "indexed", DISPLAY, 0, LEFT, 0, NOT_EDITABLE, "ps.indexed"),
"indexes" => array("indexes",null, "indexes", DISPLAY, 0, LEFT, 0, NOT_EDITABLE, "p.indexed"),
"link_rewrite" => array("link_rewrite",null, "link_rewrite", DISPLAY, 0, LEFT, null, INPUT, "pl.link_rewrite"),
"location" => array("location",null, "location", DISPLAY, 0, LEFT, null, INPUT, "s.location"),
"ls_alert" => array("ls_alert",null, "low_stock_alert", DISPLAY, 0, LEFT, null, INPUT, "ps.low_stock_alert"),
"ls_threshold" => array("ls_threshold",null, "low_stock_threshold", DISPLAY, 0, LEFT, null, INPUT, "ps.low_stock_threshold"),
"manufacturer" => array("manufacturer",null, "manufacturer", DISPLAY, 0, LEFT, null, DROPDOWN, "m.name"),
"meta_description" => array("meta_description",null, "meta_description", DISPLAY, 0, LEFT, null, TEXTAREA, "pl.meta_description"),
"meta_keywords" => array("meta_keywords",null, "meta_keywords", DISPLAY, 0, RIGHT, null, TEXTAREA, "pl.meta_keywords"),
"meta_title" => array("meta_title",null, "meta_title", DISPLAY, 0, LEFT, null, INPUT, "pl.meta_title"),
"minimal_quantity" => array("minimal_quantity",null, "minimal_quantity", DISPLAY, 0, LEFT, null, INPUT, "ps.minimal_quantity"),
"mpn" => array("mpn",null, "mpn", DISPLAY, 0, LEFT, null, INPUT, "p.mpn"),
"name" => array("name",null, "name", DISPLAY, 0, LEFT, null, INPUT, "pl.name"),
"online_only" => array("online_only",null, "online_only", DISPLAY, 0, LEFT, null, BINARY, "ps.online_only"),
"on_sale" => array("on_sale",null, "on_sale", DISPLAY, 0, LEFT, null, BINARY, "ps.on_sale"),
"out_of_stock" => array("out_of_stock",null, "out_of_stock", DISPLAY, 0, LEFT, null, DROPDOWN, "s.out_of_stock"),
"pack_stock_type" => array("pack_stock_type",null, "pack_stock_type", DISPLAY, 0, LEFT, null, DROPDOWN, "ps.pack_stock_type"),
/* pro memory: s.physical_quantity in PS 1.7: this is automatically set when an order is placed */
"position" => array("position",null, "position", DISPLAY, 0, RIGHT, null, NOT_EDITABLE, "cp.position"),
"price" => array("price",null, "price", DISPLAY, 200, LEFT, null, INPUT, "ps.price"),
"priceVAT" => array("priceVAT",null, "priceVAT", DISPLAY, 0, LEFT, null, INPUT, "priceVAT"),
"quantity" => array("quantity",null, "quantity", DISPLAY, 0, LEFT, null, TEXTAREA, "s.quantity"),
"redirect" => array("redirect",null, "redirect_type", DISPLAY, 0, LEFT, null, DROPDOWN, "ps.redirect_type"),
"reference" => array("reference",null, "reference", DISPLAY, 200, LEFT, null, INPUT, "p.reference"),
"reserved" => array("reserved",null, "quantity", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "s.quantity"),
"shipdepth" => array("shipdepth",null, "depth", DISPLAY, 0, LEFT, null, INPUT, "p.depth"),
"shipheight" => array("shipheight",null, "height", DISPLAY, 0, LEFT, null, INPUT, "p.height"),
"shipweight" => array("shipweight",null, "weight", DISPLAY, 0, LEFT, null, INPUT, "p.weight"),
"shipwidth" => array("shipwidth",null, "width", DISPLAY, 0, LEFT, null, INPUT, "p.width"),
"shopz" => array("shopz",null, "id_shop", DISPLAY, 0, LEFT, null, BINARY, "ps.id_shop"),
"show_condition" => array("show_condition",null, "show_condition", DISPLAY, 0, LEFT, null, BINARY, "ps.show_condition"),
/* stockflags combines two of Prestashop's datafields: depends_on_stock and advanced_stock_management */
"stockflags" => array("stockflags",null, "depends_on_stock", DISPLAY, 0, LEFT, null, BINARY, "s.depends_on_stock"),
"state" => array("state",null, "state", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "p.state"), /* STATE_TEMP=0 STATE_SAVED=1 */
"supplier" => array("supplier",null, "supplier", DISPLAY, 0, LEFT, null, INPUT, "su.name"),
"tags" => array("tags",null, "tags", DISPLAY, 0, LEFT, null, TEXTAREA, "tg.name"),
"unit" => array("unit",null, "unity", DISPLAY, 0, LEFT, null, INPUT, "ps.unity"),
"unitPrice" => array("unitPrice",null, "unit_price_ratio", DISPLAY, 0, LEFT, null, INPUT, "ps.unit_price_ratio"),
"upc" => array("upc",null, "upc", DISPLAY, 200, LEFT, null, INPUT, "p.upc"),
"VAT" => array("VAT",null, "id_tax_rules_group", DISPLAY, 0, LEFT, null, DROPDOWN, "t.rate"),
"virtualp" => array("virtualp",null, "virtualp", DISPLAY, 0, LEFT, null, INPUT, "virtualp"), /* virtual product */
"visibility" => array("visibility",null, "visibility", DISPLAY, 0, LEFT, null, INPUT, "ps.visibility"),
"warehousing" => array("warehousing",null, "quantity", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "w.id_warehouse"),
"wholesaleprice" => array("wholesaleprice",null, "wholesale_price", DISPLAY, 0, LEFT, null, INPUT, "ps.wholesale_price")
);
/* the fields for combinations */
/* 0=showname; 1=left/right; 2=hide/display; 3=fieldname; 4=searchable */
$combifields = array(
array("combination", RIGHT,DISPLAY,"",0),
// array("id_product_attribute",RIGHT,HIDE,"id",1), /* pro memory; hardcoded in cell 1 */
array("wholesale_price",RIGHT,HIDE,"ws_price",1),
array("price",RIGHT,DISPLAY,"",1),
array("priceVAT",RIGHT,DISPLAY,"",1),
array("ecotax",RIGHT,HIDE,"",1),
array("weight", RIGHT,DISPLAY,"",1),
array("unit_price_impact",RIGHT,HIDE,"uprice_impact",1),
array("default_on", RIGHT,DISPLAY,"",1),
array("minimal_quantity",RIGHT,HIDE,"",1),
array("available_date",RIGHT,HIDE,"avail_date",1),
array("reference",RIGHT,DISPLAY,"",1),
array("supplier_reference",RIGHT,HIDE,"supplier_ref",1),
array("location", RIGHT,HIDE,"",1),
array("ean",RIGHT,HIDE,"",1),
array("upc",RIGHT,HIDE,"",1),
array("quantity", RIGHT,DISPLAY,"",1),
array("image",RIGHT,DISPLAY,"",0));
if (version_compare(_PS_VERSION_ , "1.7.0.0", ">="))
$combifields[] = array("isbn",RIGHT,HIDE,"",1);
if (version_compare(_PS_VERSION_ , "1.7.3.0", ">="))
{ $combifields[] = array("low_stock_threshold",RIGHT,HIDE,"ls_threshold",1);
$combifields[] = array("low_stock_alert",RIGHT,HIDE,"ls_alert",1);
}
if (version_compare(_PS_VERSION_ , "1.7.7", ">="))
$combifields[] = array("mpn",RIGHT,HIDE,"",1);
if($discount_included)
$combifields[] = array("discount", RIGHT,DISPLAY,"",1);
if($suppliers_included)
$combifields[] = array("suppliers", RIGHT,DISPLAY,"",1);
if (in_array("salescnt", $input["fields"]))
$combifields[] = array("salescnt",RIGHT,DISPLAY,"",1);
if (in_array("revenue", $input["fields"]))
$combifields[] = array("revenue",RIGHT,DISPLAY,"",1);
if (in_array("orders", $input["fields"]))
$combifields[] = array("orders",RIGHT,DISPLAY,"",1);
if (in_array("buyers", $input["fields"]))
$combifields[] = array("buyers",RIGHT,DISPLAY,"",1);
$numfields = sizeof($combifields); /* number of fields */
for($i=0; $i<$numfields; $i++)
if($combifields[$i][3] == "") $combifields[$i][3] = $combifields[$i][0];
/* remove fields from the field_array that are not present in the used Prestashop version */
$x = 0;
$deleters = array();
foreach($field_array AS $key => $farray)
{ if((($key=="pack_stock_type") && (version_compare(_PS_VERSION_ , "1.6.0.12", "<")))
|| ($key == "fearureEdit")
|| (in_array($key, array("isbn", "show_condition","state")) && (version_compare(_PS_VERSION_ , "1.7.0", "<")))
|| (in_array($key, array("reserved")) && (version_compare(_PS_VERSION_ , "1.7.2", "<")))
|| (in_array($key, array("ls_threshold", "aDeliveryT", "deliInStock","deliOutStock","ls_alert")) && (version_compare(_PS_VERSION_ , "1.7.3", "<")))
|| (in_array($key, array("location")) && (version_compare(_PS_VERSION_ , "1.7.5", "<")))
|| (in_array($key, array("mpn")) && (version_compare(_PS_VERSION_ , "1.7.7", "<"))))
$deleters[] = $x;
$x++;
}
rsort($deleters); /* we have to work from high to low as deleting the low numbers first we would need to adapt the higher ones */
foreach($deleters AS $deleter)
array_splice($field_array,$deleter,1);
/* put the language specific data at position 1 in the field array */
/* $screentext_pe is defined in the language file */
foreach($field_array as $key => $value)
{ if(isset($screentext_pe[$key]) && isset($screentext_pe[$key][1]))
{ if($screentext_pe[$key][1] == "")
$screentext_pe[$key][1] = $screentext_pe[$key][0];
$field_array[$key][1] = $screentext_pe[$key];
}
else /* when users use old translation files that don't support this entry */
$field_array[$key][1] = array($key,$value[2],$key);
}
/* get the infofields array with the active fields. Put the fields pre-sorted in the $fieldsorder array in Settings1.php first */
$infofields[$if_index++] = $field_array["id_product"];
foreach($fieldsorder AS $ofield)
{ if (in_array($ofield, $input["fields"]))
{ $infofields[$if_index++] = $field_array[$ofield];
}
}
foreach($field_array AS $key => $value)
{ if ((in_array($key, $input["fields"])) && (!in_array($key, $fieldsorder)))
{ $infofields[$if_index++] = $value;
}
}
/* section 4: retrieve system settings and build php blocks for select fields */
$rewrite_settings = get_rewrite_settings();
/* the following deals with the case of customized product urls (used for the links on the product name) */
if(defined('_TB_VERSION_')) /* Thirty Bees has this in the configuration_lang table */
$route_product_rule = get_configuration_lang_value('PS_ROUTE_product_rule',$id_lang);
else
$route_product_rule = get_configuration_value('PS_ROUTE_product_rule');
if($route_product_rule != null) /* null is the default */
{ $regexp = preg_quote($route_product_rule, '#');
$keywordlist = array("id", "rewrite","ean13","category","categories","reference","meta_keywords","meta_title","manufacturer","supplier","price","tags");
$keywords = array();
foreach($keywordlist AS $key)
{ if(strpos($route_product_rule, $key) > 0)
$keywords[] = $key;
}
if (sizeof($keywords)>0)
{ $transform_keywords = array();
preg_match_all('#\\\{(([^{}]*)\\\:)?('.implode('|', $keywords).')(\\\:([^{}]*))?\\\}#', $regexp, $m);
for ($i = 0, $total = count($m[0]); $i < $total; $i++)
{ $prepend = $m[2][$i];
$keyword = $m[3][$i];
$append = $m[5][$i];
$transform_keywords[$keyword] = array(
'prepend' => stripslashes($prepend),
'append' => stripslashes($append),
);
}
}
}
$statfields = array("salescnt", "revenue","orders","buyers");
/* now get multi-language status. If true you get product urls like www.myshop.com/en/mycat/123-prod.html */
$query='SELECT COUNT(DISTINCT l.id_lang) AS langcount FROM `'._DB_PREFIX_.'lang` l
JOIN '._DB_PREFIX_.'lang_shop ls ON (ls.id_lang = l.id_lang AND ls.id_shop = '.(int)$id_shop.')
WHERE l.`active` = 1';
$res=dbquery($query);
$row = mysqli_fetch_array($res);
$langcount = (int)$row['langcount'];
$langinsert = "";
if($langcount>1)
$langinsert = $iso_code."/";
/* Get default country for the VAT tables and calculations */
$query="select l.name, id_country from ". _DB_PREFIX_."configuration f, "._DB_PREFIX_."country_lang l";
$query .= " WHERE f.name='PS_COUNTRY_DEFAULT' AND f.value=l.id_country ORDER BY id_lang IN('".$def_lang."','1') DESC"; /* the construction with the languages should select all languages with def_lang and '1' first */
$res=dbquery($query);
$row = mysqli_fetch_array($res);
$countryname = $row['name'];
$id_country = $row["id_country"];
/* get shop group and its shared_stock status */
$query="select s.id_shop_group, g.share_stock, g.name from ". _DB_PREFIX_."shop s, "._DB_PREFIX_."shop_group g";
$query .= " WHERE s.id_shop_group=g.id_shop_group and id_shop='".$id_shop."'";
$res=dbquery($query);
$row = mysqli_fetch_array($res);
$id_shop_group = $row['id_shop_group'];
$share_stock = $row["share_stock"];
$shop_group_name = $row["name"];
/* making shop block */
$shopblock = "";
$shops = $shop_ids = array();
$query=" select id_shop,name from ". _DB_PREFIX_."shop ORDER BY id_shop";
$res=dbquery($query);
while ($row=mysqli_fetch_array($res))
{ $selected='';
if ($row['id_shop']==$id_shop)
$selected=' selected="selected" ';
$shopblock .= '';
$shops[] = $row['name'];
$shop_ids[] = $row['id_shop'];
}
/* make tax block */
$ps_tax = get_configuration_value('PS_TAX'); /* flag that taxes are enabled */
$taxrates = array();
$taxrates[0] = 0;
$missing_taxgroups = array();
$done = array();
if($ps_tax)
{ $query = "SELECT rate,name,tr.id_tax_rule,g.id_tax_rules_group,g.active,";
if(version_compare(_PS_VERSION_ , "1.6.0.10", "<"))
$query .= "0 AS deleted";
else
$query .= "g.deleted";
$query .= " FROM "._DB_PREFIX_."tax_rule tr";
$query .= " LEFT JOIN "._DB_PREFIX_."tax t ON (t.id_tax = tr.id_tax)";
$query .= " LEFT JOIN "._DB_PREFIX_."tax_rules_group g ON (tr.id_tax_rules_group = g.id_tax_rules_group)";
$query .= " WHERE tr.id_country = '".$id_country."' AND tr.id_state='0' AND NOT g.id_tax_rules_group IS NULL";
$res=dbquery($query);
$taxblock = '';
while($row = mysqli_fetch_array($res))
{ if(($row["active"]==0) ||($row["deleted"]==1))
$missing_taxgroups[$row['id_tax_rules_group']] = '';
else
$taxblock .= '';
$taxrates[$row['id_tax_rules_group']] = $row['rate'];
$done[] = $row['id_tax_rules_group'];
}
/* now the taxrule groups that have no rate defined for this country */
$query = "SELECT g.id_tax_rules_group,name,g.active,";
if(version_compare(_PS_VERSION_ , "1.6.0.10", "<"))
$query .= "0 AS deleted";
else
$query .= "g.deleted";
$query .= " FROM "._DB_PREFIX_."tax_rules_group g";
$query .= " LEFT JOIN "._DB_PREFIX_."tax_rule tr ON tr.id_tax_rules_group = g.id_tax_rules_group";
if(sizeof($done) > 0)
$query .= " WHERE NOT g.id_tax_rules_group IN (".implode(",",$done).")";
$res=dbquery($query);
while($row = mysqli_fetch_array($res))
{ if(($row["active"]==0) ||($row["deleted"]==1))
$missing_taxgroups[$row['id_tax_rules_group']] = '';
else
$taxblock .= '';
$taxrates[$row['id_tax_rules_group']] = 0;
}
$taxblock .= "";
}
else
{ $taxblock = '';
$query = "SELECT DISTINCT id_tax_rules_group FROM "._DB_PREFIX_."product_shop";
$res=dbquery($query);
while($row = mysqli_fetch_array($res))
{ $missing_taxgroups[$row['id_tax_rules_group']] = '';
$taxrates[$row['id_tax_rules_group']] = 0;
}
}
$availordertypes = array(0=>"available", 1=>"show price only",2=>"not available");
$packstocktypes = array(0=>"Decrement pack only", 1=>"Decrement products in pack only",2=>"Decrement both",3=>"Default");
$stockflagsarray = array("Manual","Adv Stock Management","ASM with Warehousing");
/* look for double category names */
$duplos = array();
$query = "select name,count(*) AS duplocount from ". _DB_PREFIX_."category_lang WHERE id_lang='".$id_lang."' AND id_shop='".$id_shop."' GROUP BY name HAVING duplocount > 1";
$res=dbquery($query);
while ($row=mysqli_fetch_array($res))
{ $duplos[] = $row["name"];
}
/* Get category names and rewrites */
$query = "select c.id_category,name,link_rewrite, id_parent from "._DB_PREFIX_."category c";
$query .= " left join "._DB_PREFIX_."category_lang cl ON c.id_category=cl.id_category AND id_lang='".$id_lang."'";
$query .= " AND id_shop='".$id_shop."' ORDER BY name";
$res=dbquery($query);
$category_names = $category_rewrites = $category_parents = array();
while ($row=mysqli_fetch_array($res))
{ if(in_array($row['name'], $duplos))
$name = $row['name'].$row['id_category'];
else
$name = $row['name'];
$category_names[$row['id_category']] = $name;
$category_rewrites[$row['id_category']] = $row['link_rewrite'];
$category_parents[$row['id_category']] = $row['id_parent'];
}
/* make supplier names list */
if(in_array('supplier', $input["fields"]))
{ $query = "select id_supplier,name from ". _DB_PREFIX_."supplier ORDER BY name"; $res=dbquery($query);
$supplier_names = array();
$supplierblock0 = '';
$supplierblock0 .= '
';
$supplierblock2 = '
';
$supplierblock2 .= '
';
$supplierblock2 .= '
';
}
else
$supplierblock0 = $supplierblock1 = $supplierblock2 = "";
/* Make blocks for features */
$query = "SELECT fl.id_feature, name FROM ". _DB_PREFIX_."feature_lang fl";
$query .= " LEFT JOIN ". _DB_PREFIX_."feature_shop fs ON fs.id_feature = fl.id_feature";
$query .= " WHERE id_lang='".$id_lang."' AND id_shop='".$id_shop."'";
$query .= " ORDER BY id_feature";
$res = dbquery($query);
$features = array();
$featurelist = array();
while($row = mysqli_fetch_array($res))
{ $features[$row['id_feature']] = $row['name'];
if(in_array(str_replace('"','_',$row['name']), $input["fields"]))
{ $featurelist[$row['id_feature']] = $row['name'];
$featurekeys[] = $row['id_feature'];
}
}
$featurecount = 0;
foreach($features AS $key => $feature)
{ $cleanfeature = str_replace('"','_',$feature);
if (in_array($cleanfeature, $input["fields"]))
$featurecount++;
}
/* Make the discount blocks */
/* 0 1 2 3 4 5 6 7 8 9 10 11 12 */
/* discount fields: shop, product_attribute, currency, country, group, id_customer, price, from_quantity, reduction, reduction_tax, reduction_type, from, to */
if($discount_included)
{ $countryblock = "";
$query=" select id_country,name from ". _DB_PREFIX_."country_lang WHERE id_lang='".$id_lang."' ORDER BY name";
$res=dbquery($query);
while ($country=mysqli_fetch_array($res)) {
$countryblock .= '';
}
$groupblock = "";
$query=" select id_group,name from ". _DB_PREFIX_."group_lang WHERE id_lang='".$id_lang."' ORDER BY id_group";
$res=dbquery($query);
while ($group=mysqli_fetch_array($res)) {
$groupblock .= '';
}
}
/* make supplier names list */
if(in_array('supplier', $input["fields"]))
{ $query = "select id_supplier,name from ". _DB_PREFIX_."supplier ORDER BY name"; $res=dbquery($query);
$supplier_names = array();
$supplierblock0 = '';
$supplierblock0 .= '
';
$supplierblock2 = '
';
$supplierblock2 .= '
';
$supplierblock2 .= '
';
}
else
$supplierblock0 = $supplierblock1 = $supplierblock2 = "";
/* currency block: for discount and suppliers */
$currencyblock = "";
$def_currency = "0";
$currencies = array();
$query="SELECT c.id_currency,c.iso_code,";
if(version_compare(_PS_VERSION_ , "1.5.3", "<"))
$query .= "c.conversion_rate";
else
$query .= "cs.conversion_rate";
$query .= " FROM ". _DB_PREFIX_."currency c";
$query .= " LEFT JOIN ". _DB_PREFIX_."currency_shop cs ON c.id_currency=cs.id_currency AND cs.id_shop='".$id_shop."'";
$query .= " WHERE deleted='0' AND active='1' ORDER BY name";
$res=dbquery($query);
while ($currency=mysqli_fetch_array($res)) {
$currencyblock .= '';
$currencies[] = $currency['iso_code'];
if($currency['conversion_rate'] == 1)
$def_currency = $currency['iso_code'];
}
if($def_currency == "0")
$def_currency = $currencies[0];
/* Make image format block */
$query = "SELECT name,width,height from ". _DB_PREFIX_."image_type WHERE products=1 ORDER BY width";
$res=dbquery($query);
$imgformatblock = '';
$prodfields = array_diff(array_keys($infofields), array("id_product","salescnt", "revenue","orders","buyers"));
/* section 5: publish header block of html page, including javascript version of select blocks */
?>
';
else
echo '';
?>
Prestashop ProdCombi Multiedit
.
';
echo '
Product Combis ';
echo 'This page allows you to edit combinations of more than one product. You can provide the number of products and the maximum number of combinations that should be shown. ';
echo "The top lines let you search in product properties. The bottom section lets you search in attribute combination properties. ";
echo "When you search for attributes in the product section matching products will be shown with all their attributes. ";
echo "Default lang=".$def_langname." (used for names)";
if($id_lang != $def_lang)
echo " - Active lang=".$languagename;
echo ". Country=".$countryname." (used for VAT).";
/* The following was added to have diagnostics when problems happen */
$cquery="select count(*) from `". _DB_PREFIX_."shop`";
$cres=dbquery($cquery);
list($shop_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."shop_group`";
$cres=dbquery($cquery);
list($shop_group_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."group`";
$cres=dbquery($cquery);
list($group_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."lang`";
$cres=dbquery($cquery);
list($lang_count) = mysqli_fetch_row($cres);
$stock_management_conf = get_configuration_value('PS_STOCK_MANAGEMENT');
$advanced_stock_management_conf = get_configuration_value('PS_ADVANCED_STOCK_MANAGEMENT');
echo " ".$shop_count." shop(s); ".$shop_group_count." shopgroup(s); ".$group_count." group(s); ".$lang_count." language(s).";
echo ' Stock: ';
if($stock_management_conf == 0) echo 'No';
else if($advanced_stock_management_conf == 0) echo 'Yes';
else echo 'ASM';
echo '; Shared: ';
if(!$share_stock) echo 'No';
else echo $id_shop_group;
echo ";";
echo "
';
/* section 9: Mass Edit */
/* first build the array that defines which mass edit functions are available for which fields */
echo '';
echo '
'.t('Mass update').'';
echo t('NB: Prior to mass update you need to make the field editable. Afterwards you need to submit the records');
echo '
';
/* section: csv generation */
/* the searchblock will be copied to csvsearchdiv before submission */
echo '';
echo '
';
/* section 13: the switchform: hide/show fields and submit button */
$combistats = array("salescnt", "revenue","orders","buyers");
echo '";
/* section 16: build and execute the product query */
$idfields = array("accessories","p.id_product","cl.id_category","ps.id_category_default","m.id_manufacturer","p.id_supplier","ps.id_tax_rules_group"); /* in these fields you can place comma-separated id numbers */
$wheretext = "";
$manufacturer_needed = false;
for($x=1; $x<=3; $x++)
{ $search_cmp = $input["search_cmp".$x];
$search_txt = $GLOBALS["search_txt".$x];
$search_fld = $input["search_fld".$x];
// if($search_txt == "") && (!in_array($search_fld, array("su.name","combinations","cr.name","m.name","pl.description","pl.description_short","discount","custFlds","virtualp"))) && (substr($search_fld,0,7) != "sattrib") && (substr($search_fld,0,7) != "sfeatur")) continue;
if(($search_fld == "m.name") || (($search_fld == "main product fields") && ($search_txt !=""))) $manufacturer_needed = true;
$nottext = "";
if($search_cmp == "not_eq") $cmp = "!=";
else if($search_cmp == "eq") $cmp = "=";
else if($search_cmp == "gt") $cmp = ">";
else if($search_cmp == "gte") $cmp = ">=";
else if($search_cmp == "lt") $cmp = "<";
else if($search_cmp == "lte") $cmp = "<=";
if(($search_cmp == "not_in") || ($search_cmp == "not_eq"))
$nottext = "NOT ";
if ($search_txt != "")
{ if($search_cmp == "gt")
$inc = "< '".$search_txt."'";
else if($search_cmp == "gte")
$inc = "<= '".$search_txt."'";
else if((($search_cmp == "eq") || ($search_cmp == "not_eq")) && !in_array($search_fld,$idfields))
$inc = "= '".$search_txt."'";
else if($search_cmp == "lte")
$inc = ">= '".$search_txt."'";
else if($search_cmp == "lt")
$inc = "> '".$search_txt."'";
else if(in_array($search_fld,$idfields) || (substr($search_fld,0,9) == "sidattrib") || (substr($search_fld,0,9) == "sidfeatur"))
{ if($search_fld == "cl.id_category")
{ $search_txt = preg_replace('/[^0-9,s]*/',"",$search_txt); /* an "s" behind the category number means "with subcategories" */
if(strpos($search_txt,"s"))
{ $frags = explode(",",$search_txt);
$catfrags = array();
foreach($frags AS $frag)
{ if(stripos($frag,'s')) /* "6s" means category 6 with subcategories */
get_subcats(str_replace('s','',$frag), $catfrags); /* this function will place the results in the categories array */
else if($frag != 0)
$catfrags[] = $frag;
}
$search_txt = implode(",",$catfrags);
}
}
else
$search_txt = preg_replace('/[^0-9,]*/',"",$search_txt);
if(strlen($search_txt) > 0) /* avoid mysql error */
$inc = " IN (".$search_txt.")";
else
$inc = " IN (0)";
}
else /* default = "in": also for "not_in" */
$inc = "like '%".$search_txt."%'";
if($search_fld == "main product fields")
{ $wheretext .= " AND ".$nottext." (p.reference ".$inc." or pl.name ".$inc." or pl.description ".$inc." or pl.description_short ".$inc;
$wheretext .= " OR (m.name IS NOT NULL AND m.name ".$inc.")";
if(is_numeric($search_txt) && (intval($search_txt) !=0)) $wheretext .= " or p.id_product='".$search_txt."' ";
$wheretext .= ") ";
}
else if($search_fld == "accessories")
{ $wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."accessory ac WHERE ac.id_product_1 = p.id_product AND ac.id_product_2 ".$inc.")";
}
else if(($search_fld == "ps.id_category_default") || ($search_fld == "p.id_product"))
$wheretext .= " AND ".$nottext.$search_fld." ".$inc." ";
else if ($search_fld == "cr.name")
$wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_carrier pc LEFT JOIN ". _DB_PREFIX_."carrier cr ON cr.id_reference=pc.id_carrier_reference AND cr.deleted=0 WHERE pc.id_product = p.id_product AND cr.name ".$inc.")";
else if ($search_fld == "tg.name")
{ $wheretext .= " AND ".$nottext." EXISTS (SELECT NULL FROM ". _DB_PREFIX_."tag tg";
$wheretext .= " LEFT JOIN ". _DB_PREFIX_."product_tag pt ON pt.id_tag=tg.id_tag WHERE tg.name ".$inc." AND p.id_product=pt.id_product AND tg.id_lang='".$id_lang."') ";
}
else if ($search_fld == "p.indexed")
{ $wheretext .= " AND sw.word ".$nottext." ".$inc;
}
else if($search_fld == "su.name")
$wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_supplier psu LEFT JOIN ". _DB_PREFIX_."supplier su ON psu.id_supplier=su.id_supplier WHERE psu.id_product = p.id_product AND su.name ".$inc.")";
else if($search_fld == "priceVAT")
$wheretext .= " AND ".$nottext." (ROUND(((rate/100)+1)*ps.price,2) ".$inc.")";
else if($search_fld == "w.id_warehouse")
{ $wheretext .= " AND (".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."warehouse_product_location wpl LEFT JOIN ". _DB_PREFIX_."warehouse w ON wpl.id_warehouse=w.id_warehouse WHERE wpl.id_product = p.id_product AND w.name ".$inc.")";
$wheretext .= " OR ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."stock st LEFT JOIN ". _DB_PREFIX_."warehouse w ON st.id_warehouse=w.id_warehouse WHERE st.id_product = p.id_product AND w.name ".$inc."))";
}
else if($search_fld == "cl.id_category")
{ $wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."category_product cpp WHERE cpp.id_product = p.id_product AND cpp.id_category ".$inc.")";
}
else if($search_fld == "combinations") /* combinations */
{ $wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM
". _DB_PREFIX_."product_attribute pa LEFT JOIN ". _DB_PREFIX_."product_attribute_combination pac
ON pa.id_product_attribute=pac.id_product_attribute LEFT JOIN ". _DB_PREFIX_."attribute_lang al
ON pac.id_attribute = al.id_attribute WHERE pa.id_product=p.id_product AND al.name ".$inc.")";
}
else if($search_fld == "p.reference") /* check here also for supplier reference */
{ $wheretext .= " AND (".$nottext.$search_fld." ".$inc." ";
$wheretext .= " OR ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_supplier psu WHERE psu.id_product = p.id_product AND psu.product_supplier_reference ".$inc."))";
}
else if(substr($search_fld,0,7) == "sattrib") /* attribute search */
{ $id_attribute_group = substr($search_fld,7);
$wheretext .= " AND EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_attribute pa
LEFT JOIN ". _DB_PREFIX_."product_attribute_combination pac ON pa.id_product_attribute=pac.id_product_attribute
LEFT JOIN ". _DB_PREFIX_."attribute_lang al ON pac.id_attribute = al.id_attribute
LEFT JOIN ". _DB_PREFIX_."attribute atr ON pac.id_attribute = atr.id_attribute
WHERE pa.id_product=p.id_product AND atr.id_attribute_group=".$id_attribute_group." AND ".$nottext." (al.name ".$inc."))";
}
else if(substr($search_fld,0,9) == "sidattrib") /* attribute id search */
{ $id_attribute_group = substr($search_fld,9);
$wheretext .= " AND EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_attribute pa
LEFT JOIN ". _DB_PREFIX_."product_attribute_combination pac ON pa.id_product_attribute=pac.id_product_attribute
LEFT JOIN ". _DB_PREFIX_."attribute atr ON pac.id_attribute = atr.id_attribute
WHERE pa.id_product=p.id_product AND atr.id_attribute_group=".$id_attribute_group." AND ".$nottext." (atr.id_attribute ".$inc."))";
}
else if(substr($search_fld,0,7) == "sfeatur") /* feature search */
{ $id_feature = substr($search_fld,7);
$wheretext .= " AND EXISTS(SELECT NULL FROM ". _DB_PREFIX_."feature_product fp
LEFT JOIN ". _DB_PREFIX_."feature_value fv ON fp.id_feature_value=fv.id_feature_value
LEFT JOIN ". _DB_PREFIX_."feature_value_lang fvl ON fv.id_feature_value=fvl.id_feature_value
WHERE fp.id_product=p.id_product AND fp.id_feature=".$id_feature." AND ".$nottext." (fvl.value ".$inc."))";
}
else if(substr($search_fld,0,9) == "sidfeatur") /* feature search */
{ $id_feature = substr($search_fld,9);
$wheretext .= " AND EXISTS(SELECT NULL FROM ". _DB_PREFIX_."feature_product fp
LEFT JOIN ". _DB_PREFIX_."feature_value fv ON fp.id_feature_value=fv.id_feature_value
WHERE fp.id_product=p.id_product AND fp.id_feature=".$id_feature." AND ".$nottext." (fv.id_feature_value ".$inc."))";
}
else if(($search_fld != "discount") && ($search_fld != "virtualp") && ($search_fld != "custFlds"))
$wheretext .= " AND ".$nottext.$search_fld." ".$inc." ";
}
else /* $search_txt == "" */
{
$nottexta = ""; /* here we use a different logic - so a different variable */
if(($search_cmp == "not_eq") || ($search_cmp == "!in"))
$nottexta = "NOT";
if($search_fld == "su.name") /* supplier: this works when search_txt field is empty */
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_supplier psu WHERE psu.id_product = p.id_product)";
else if($search_fld == "combinations") /* combinations: this works when search_txt field is empty */
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_attribute pax WHERE pax.id_product = p.id_product)";
else if($search_fld == "cr.name") /* carriers: this works when search_txt field is empty */
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_carrier pcx WHERE pcx.id_product = p.id_product)";
else if($search_fld == "m.name") /* manufacturers: this works when search_txt field is empty */
{ $wheretext .= " AND ".$nottexta." p.id_manufacturer=0";
}
else if($search_fld == "pl.description")
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_lang plx WHERE plx.id_product = p.id_product AND plx.id_lang=".$id_lang." AND plx.description='')";
else if($search_fld == "pl.description_short")
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_lang plx WHERE plx.id_product = p.id_product AND plx.id_lang=".$id_lang." AND plx.description_short='')";
else if(substr($search_fld,0,7) == "sattrib") /* attribute search */
{ $id_attribute_group = substr($search_fld,7);
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_attribute pa
LEFT JOIN ". _DB_PREFIX_."product_attribute_combination pac ON pa.id_product_attribute=pac.id_product_attribute
LEFT JOIN ". _DB_PREFIX_."attribute_lang al ON pac.id_attribute = al.id_attribute
LEFT JOIN ". _DB_PREFIX_."attribute atr ON pac.id_attribute = atr.id_attribute
WHERE pa.id_product=p.id_product AND atr.id_attribute_group=".$id_attribute_group.")";
}
else if(substr($search_fld,0,7) == "sfeatur") /* feature search */
{ $id_feature = substr($search_fld,7);
$wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."feature_product fp
LEFT JOIN ". _DB_PREFIX_."feature_value fv ON fp.id_feature_value=fv.id_feature_value
LEFT JOIN ". _DB_PREFIX_."feature_value_lang fvl ON fv.id_feature_value=fvl.id_feature_value
WHERE fp.id_product=p.id_product AND fp.id_feature=".$id_feature.")";
}
}
/* finally three fields where it doesn't matter whether search_txt is filled */
if($search_fld == "discount") /* this works also when search_txt field is empty */
$wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."specific_price sp WHERE sp.id_product = p.id_product)";
if($search_fld == "custFlds") /* this works also when search_txt field is empty */
$wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."customization_field cf WHERE cf.id_product = p.id_product)";
if($search_fld == "virtualp")
$wheretext .= " AND ".$nottext." (p.is_virtual = 1)";
} /* end of for x=1; x<=3; x++; search block loop */
/* Note: we start with the query part after "from". First we count the total and then we take 100 from it */
/* DISTINCT is for when "with subcats" results in more than one occurence */
$queryterms = "DISTINCT p.*,pl.*,ps.*, cl.name AS catname,p.id_product AS ptest,pl.id_product AS pltest";
$queryterms .= ", cl.link_rewrite AS catrewrite, pld.name AS originalname, s.quantity, s.depends_on_stock";
$query = " FROM ". _DB_PREFIX_."product_shop ps LEFT JOIN ". _DB_PREFIX_."product p ON p.id_product=ps.id_product";
$query.=" LEFT JOIN ". _DB_PREFIX_."product_lang pl ON pl.id_product=p.id_product and pl.id_lang='".$id_lang."' AND pl.id_shop='".$id_shop."'";
$query.=" LEFT JOIN ". _DB_PREFIX_."product_lang pld ON pld.id_product=p.id_product and pld.id_lang='".$def_lang."' AND pld.id_shop='".$id_shop."'"; /* This gives the name in the shop language instead of the selected language */
$query.=" LEFT JOIN ". _DB_PREFIX_."category_lang cl ON cl.id_category=ps.id_category_default AND cl.id_lang='".$id_lang."' AND cl.id_shop = '".$id_shop."'";
if($share_stock == 0)
$query.=" LEFT JOIN ". _DB_PREFIX_."stock_available s ON s.id_product=p.id_product AND s.id_shop = '".$id_shop."' AND id_product_attribute='0'";
else
$query.=" LEFT JOIN ". _DB_PREFIX_."stock_available s ON s.id_product=p.id_product AND s.id_shop_group = '".$id_shop_group."' AND id_product_attribute='0'";
if ($input['order']=="id_product") $order="p.id_product";
else if ($input['order']=="name") $order="pl.name";
else if ($input['order']=="position") $order="cp.position"; /* later to be refined */
else if ($input['order']=="VAT") $order="t.rate";
else if ($input['order']=="price") $order="ps.price";
else if ($input['order']=="active") $order="ps.active";
else if ($input['order']=="availorder") $order="ps.available_for_order,ps.show_price";
else if ($input['order']=="pack_stock_type") $order="ps.pack_stock_type";
else if ($input['order']=="shipweight") $order="p.weight";
else if ($input['order']=="date_upd") $order="p.date_upd";
else if ($input['order']=="image") /* sorting on image makes only sense to get the products without an image */
{ $order="i.cover";
$queryterms .= ",i.id_image, i.cover";
$query.=" LEFT JOIN ". _DB_PREFIX_."image i ON i.id_product=p.id_product and i.cover=1";
}
else $order = $input['order'];
if ($id_category != 0)
{ $categories = array();
if(isset($input['subcats']))
get_subcats($id_category, $categories);
else
$categories = array($id_category);
$cats = join(',',$categories);
if(sizeof($categories) == 1)
{ $query .= " LEFT JOIN "._DB_PREFIX_."category_product cp ON p.id_product=cp.id_product";
$wheretext .= " AND cp.id_category='".$cats."'";
}
else
{
$query .= " LEFT JOIN "._DB_PREFIX_."category_product cp ON p.id_product=cp.id_product";
$query .= " INNER JOIN (SELECT MIN(id_category) AS mincat,id_product,position FROM ". _DB_PREFIX_."category_product WHERE id_category IN (".$cats.") GROUP BY id_product) cpx ON cpx.mincat=cp.id_category and cpx.id_product=p.id_product";
}
}
else
{ $query .= " LEFT JOIN ". _DB_PREFIX_."category_product cp ON ps.id_category_default=cp.id_category AND p.id_product=cp.id_product";
}
if (($order=="cp.position") && (($id_category == 0) || (sizeof($categories)>1)))
{ $query .= " LEFT JOIN ". _DB_PREFIX_."category c ON c.id_category=cp.id_category";
$order = "c.nleft,cp.position";
}
if(in_array("virtualp", $input["fields"]))
{ $query.=" LEFT JOIN ". _DB_PREFIX_."product_download pd ON pd.id_product=p.id_product";
$queryterms .= ", filename, display_filename, date_expiration, nb_days_accessible, nb_downloadable, pd.active AS dl_active, is_shareable";
}
if(in_array("manufacturer", $input["fields"]) || $manufacturer_needed)
{ $query.=" LEFT JOIN ". _DB_PREFIX_."manufacturer m ON m.id_manufacturer=p.id_manufacturer";
$queryterms .= ",m.name AS manufacturer ";
}
if((($input["search_fld1"]=="p.indexed") && ($input["search_txt1"]!=""))
OR (($input["search_fld2"]=="p.indexed") && ($input["search_txt2"]!=""))
OR (($input["search_fld3"]=="p.indexed") && ($input["search_txt3"]!="")))
{ $query .= " LEFT JOIN "._DB_PREFIX_."search_index si ON si.id_product=ps.id_product";
$query .= " LEFT JOIN "._DB_PREFIX_."search_word sw ON si.id_word=sw.id_word AND ";
$query .= " sw.id_shop=".$id_shop." AND sw.id_lang=".$id_lang;
}
if(in_array("out_of_stock", $input["fields"]))
{ $queryterms .= ", s.out_of_stock AS out_of_stock";
}
if(in_array("accessories", $input["fields"]))
{ $query.=" LEFT JOIN ( SELECT GROUP_CONCAT(id_product_2) AS accessories, id_product_1 FROM "._DB_PREFIX_."accessory GROUP BY id_product_1 ) a ON a.id_product_1=p.id_product";
$queryterms .= ", accessories";
}
if(in_array("position", $input["fields"]))
{ $queryterms .= ", position";
}
$taxfields = array("priceVAT","t.rate","ps.id_tax_rules_group");
if(($discount_included == "1") || in_array($input["order"],$taxfields) || (in_array($input["search_fld1"],$taxfields) == "VAT") || (in_array($input["search_fld2"],$taxfields) == "VAT") || (in_array($input["search_fld3"],$taxfields) == "VAT") || ((isset($input['combisearch_fld'])) AND ($input['combisearch_fld'] == "priceVAT")))
//if(1)
{ $queryterms .= ", t.rate";
$query.=" LEFT JOIN ". _DB_PREFIX_."tax_rule tr ON tr.id_tax_rules_group=ps.id_tax_rules_group AND tr.id_country='".$id_country."' AND tr.id_state='0'";
$query.=" LEFT JOIN ". _DB_PREFIX_."tax t ON t.id_tax=tr.id_tax";
}
$statres = dbquery("SELECT id_page_type FROM ". _DB_PREFIX_."page_type WHERE name='product' OR name='product.php'");
$pagetypes = array();
while ($statrow=mysqli_fetch_array($statres))
$pagetypes[] = $statrow['id_page_type'];
if(in_array("redirect", $input["fields"]))
{ if(version_compare(_PS_VERSION_ , "1.7.1", "<"))
$queryterms .= ", ps.id_product_redirected AS id_redirected";
else
$queryterms .= ", ps.id_type_redirected AS id_redirected";
}
/* first filter: only relevant products */
if((($input['combisearch_txt'] != "") && ($input['combisearch_fld'] !="")) || ($attributea !="0") || ($attributeb !="0"))
{ if(($input['combisearch_txt'] != "") && ($input['combisearch_fld'] !=""))
{ $csnottext = "";
if ($input['combisearch_fld'] == "priceVAT")
$fld = "(ROUND(((t.rate/100)+1)*price,2))";
else
$fld = preg_replace('/\s/',"",$input['combisearch_fld']);
if($input['combisearch_cmp'] == "gt")
$csinc = "< '".$combisearch_txt."'";
else if($input['combisearch_cmp'] == "gte")
$csinc = "<= '".$combisearch_txt."'";
else if(($input['combisearch_cmp'] == "eq") || ($input['combisearch_cmp'] == "not_eq"))
$csinc = "= '".$combisearch_txt."'";
else if($input['combisearch_cmp'] == "lte")
$csinc = ">= '".$combisearch_txt."'";
else if($input['combisearch_cmp'] == "lt")
$csinc = "> '".$combisearch_txt."'";
else /* default = "in": also for "not_in" */
$csinc = " like '%".$combisearch_txt."%'";
if(($input['combisearch_cmp'] == "not_in") || ($input['combisearch_cmp'] == "not_eq"))
$csnottext = " NOT ";
$wheretext .= ' AND EXISTS (select null from '._DB_PREFIX_.'product_attribute';
$wheretext .= ' WHeRE id_product=p.id_product AND '.$csnottext.$fld.$csinc.')';
}
if($attributea !="0")
{ $wheretext .= ' AND EXISTS(SELECT NULL FROM '._DB_PREFIX_.'product_attribute_combination paca';
$wheretext .= ' LEFT JOIN '._DB_PREFIX_.'product_attribute paa ON paa.id_product_attribute=paca.id_product_attribute';
$wheretext .= ' LEFT JOIN '._DB_PREFIX_.'product_attribute_shop pasa ON paca.id_product_attribute=pasa.id_product_attribute';
$wheretext .= ' WHERE paca.id_attribute='.$attributea.' AND paa.id_product=p.id_product AND pasa.id_shop="'.$id_shop.'")';
}
if($attributeb !="0")
{ $wheretext .= ' AND EXISTS(SELECT NULL FROM '._DB_PREFIX_.'product_attribute_combination pacb';
$wheretext .= ' LEFT JOIN '._DB_PREFIX_.'product_attribute pab ON pab.id_product_attribute=pacb.id_product_attribute';
$wheretext .= ' LEFT JOIN '._DB_PREFIX_.'product_attribute_shop pasb ON pacb.id_product_attribute=pasb.id_product_attribute';
$wheretext .= ' WHERE pacb.id_attribute='.$attributeb.' AND pab.id_product=p.id_product AND pasb.id_shop="'.$id_shop.'")';
}
}
else
{ /* check whether the product has attribute combinations */
$wheretext .= ' AND exists(SELECT * FROM '._DB_PREFIX_.'product_attribute pa';
$wheretext .= ' LEFT JOIN '. _DB_PREFIX_.'product_attribute_shop pas on pa.id_product_attribute=pas.id_product_attribute AND pas.id_shop="'.$id_shop.'"';
$wheretext .= ' WHERE pa.id_product=p.id_product)';
}
$activequery = "SELECT COUNT(DISTINCT p.id_product) AS rcount ".$query." WHERE ps.active='1' AND ps.id_shop='".$id_shop."' ".$wheretext;
$res=dbquery($activequery);
$row = mysqli_fetch_array($res);
$activerecs = $row['rcount'];
$query.=" WHERE ps.id_shop='".$id_shop."' ".$wheretext;
$stattotals = array("salescnt" => 0, "revenue"=>0,"orders"=>0,"buyers"=>0); /* store here totals for stats */
if(in_array($order, $statfields))
{ $ordertxt = $statz[array_search($order, $statfields)];
}
else
$ordertxt = str_replace(" ","",$order);
/* GROUP BY p.id_product is for "With subcats" when the products is in more than one of the involved categories */
$query .= " GROUP BY p.id_product ORDER BY ".$ordertxt." ".$rising." LIMIT ".$startrec.",".$numrecs;
$query= "select SQL_CALC_FOUND_ROWS ".$queryterms.$query; /* note: you cannot write here t.* as t.active will overwrite p.active without warning */
$res=dbquery($query);
$numrecs3 = mysqli_num_rows($res);
$res2=dbquery("SELECT FOUND_ROWS() AS foundrows");
$row2 = mysqli_fetch_array($res2);
$numrecs2 = $row2['foundrows'];
// echo $query;
/* section 17: Next and Prev */
echo '
";
/* section 18: warnings and explanations */
$warning = "";
if(in_array("accessories", $input["fields"]))
$warning .= "For accessories fill in comma separated article numbers like '233,467'. Non-existent articles numbers will be ignored! ";
if(in_array("carrier", $input["fields"]))
$warning .= "Standard all carriers are assigned to all products. You need to assign carriers here only in special cases. ";
if(in_array("shopz", $input["fields"]))
$warning .= "No stock will be assigned if you add a product to more shops. ";
echo ''.$warning.'';
echo "";
// "*********************************************************************";
echo '';
/* section 19: The main form: the multishop option */
if(isset($avoid_iframes) && $avoid_iframes)
echo '';
echo '
';
$supplierblock2 .= '
