One Hat Cyber Team

Edit File: product-edit.php

<?php 
/* This file is divided in sections.
 * 1. include files 
 * 2. handling input variables
 * 3. make field declarations and build infofields array of displayed fields
 * 4. retrieve system settings and build php blocks for select fields 
 * 5. publish header block of html page, including javascript version of select blocks
 * 6. publish page header: menu and diagnostic information
 * 7. publish search block
 * 8. Publish the block where you can select your fields
 * 9. Mass edit
 * 10. CSV export
 * 11. (CSV import)
 * 12. Re-indexation
 * 13. switchform: hide/show/edit fields 
 * 14. generation of product lists
 * 15. Hidden form for copying data from one language to another
 * 16. build and execute the product query 
 * 17. Next and Prev
 * 18. warnings and explanations
 * 19. The main form: the multishop option
 * 20. The main table: the column headers 
 * 21. the main table: the products
*/
/* section 1: includes */
if(!@include 'approve.php') die( "approve.php was not found!");
if(!@include 'ps_sourced_code.php') die( "ps_sourced_code.php was not found!");
if(!isset($prestoolslanguage)) $prestoolslanguage = "en";
if(!include $prestoolslanguage.".php") colordie( "Language file ".$prestoolslanguage.".php was not found!");

/* section 2: handling input variables */
$input = $_GET; 
$verbose = "false";
for($x=1; $x<=8; $x++)
{ if(!isset($_GET["search_txt".$x]))
  { if($x > 3) 
	  continue;
    else
	{ $input['search_txt'.$x] = "";
      $input['search_cmp'.$x] = "in";
	  $input['search_fld'.$x] = "main fields";
	}
  }
  $GLOBALS["search_txt".$x] = trim(mysqli_real_escape_string($conn,$input['search_txt'.$x]));
  $GLOBALS["search_cmp".$x] = trim(mysqli_real_escape_string($conn,$input['search_cmp'.$x]));
  $GLOBALS["search_fld".$x] = trim(mysqli_real_escape_string($conn,$input['search_fld'.$x]));  
}

if(!isset($input['startrec'])) $input['startrec']="0";
$startrec = intval($input['startrec']);
/* $productedit_numrecs is set in Settings1.php */
if(!isset($input['numrecs'])) {if(isset($productedit_numrecs)) $input['numrecs'] = $productedit_numrecs; else $input['numrecs']="100";}
$numrecs = intval($input['numrecs']);
if(!isset($input['id_category'])) {$id_category=0;} else {$id_category = intval($input['id_category']);}

if(isset($input['id_shop']) && (intval($input['id_shop'])!=0)) $id_shop = intval($input['id_shop']);
else $id_shop = get_configuration_value('PS_SHOP_DEFAULT');
$def_lang = get_configuration_value('PS_LANG_DEFAULT');
if(isset($input['id_lang']) && (intval($input['id_lang'])!=0)) $id_lang = intval($input['id_lang']);
else $id_lang = $def_lang;

if(!isset($input['startdate'])) $input['startdate']="";
if(!isset($input['enddate'])) $input['enddate']="";
if((!isset($input['rising'])) || ($input['rising'] == "ASC")) {$rising = "ASC";} else {$rising = "DESC";}
if(!isset($fieldsorder)) $fieldsorder = array("name");
if(!isset($input['order'])) /* sorting order */
{ if($id_category == 0) {$input['order']="id_product";} else {$input['order']="position";}
}

if(!isset($input['imgformat'])) {$input['imgformat']="";}
if(!isset($input['extralangfields'])) {$extralangfields = array();} else $extralangfields = $input['extralangfields'];
if(!isset($input['attrfeat'])) {$attrfeat="0";} else $attrfeat=preg_replace("/[^0-9af]/","",$input['attrfeat']);
if(!isset($input['attrfeatvalue'])) {$attrfeatvalue="0";} else $attrfeatvalue=intval($input['attrfeatvalue']);
if(!isset($maxprodimgsize)) $maxprodimgsize = 4000000; /* for people who didn't update settings1.php */

if(empty($input["fields"])) // if not set, set default set of active fields
  $input["fields"] = $default_product_fields; /* this is set in settings1.php */
					/* validation of fields follows after features have been collected */
					
$imgonly = $imgoactiv = false;
if(sizeof($input["fields"])<=2)
{ if(in_array("image",$input["fields"])) 
  { $imgonly = true;
	if(in_array("active",$input["fields"]))
	  $imgoactiv = true;
  }
}
					
$extralangs = array(); /* extralangs must be declared here as it is used in section 3 for the extra fields */
$langselblock = ""; /* used in the searchblock */
$langids = array();
$langcodes = array();
$langcopyselblock = ""; /* used in "copy from other lang" mass edit option; Note: this becomes javascript */
$query = "SELECT id_lang, name, language_code, iso_code FROM ". _DB_PREFIX_."lang WHERE active=1 ORDER BY id_lang";
$res=dbquery($query);
while ($row=mysqli_fetch_array($res)) 
{ if($def_lang == $row["id_lang"])
  { $def_langname = $row['name'];
    $def_iso_code = $row['iso_code'];
  }
  if($id_lang == $row["id_lang"])
  { $iso_code = $row['iso_code'];
    $languagename = $row['name'];
  }
  $selected='';
  if ($row['id_lang']==$id_lang) 
    $selected=' selected="selected" ';
  else 
  { $extralangs[$row['id_lang']] = $row['iso_code'];
  }
  $langcopyselblock .= '<option value='.$row['id_lang'].'>'.$row['language_code'].'</option>';
  $langselblock .= '<option  value="'.$row['id_lang'].'" '.$selected.'>'.$row['name'].'</option>';
  $langids[] = $row["id_lang"];
  $langcodes[$row["id_lang"]] = $row["iso_code"];
}
if(!isset($iso_code))
{ $iso_code = $def_iso_code;
  $languagename = $def_langname;
  echo "<b>Illegal value for default or selected language!</b> 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"),
  
	/* statistics */
   "visits" => array("visits",null, "visitcount", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "visitcount"),
   "visitz" => array("visitz",null, "visitedpages", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "visitedpages"),
   "salescnt" => array("salescnt",null, "salescount", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "salescount"),
   "revenue" => array("revenue",null, "revenue", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "revenue"),
   "refunds" => array("refunds",null, "refunds", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "refunds"),
   "orders" => array("orders",null, "ordercount", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "ordercount"),
   "buyers" => array("buyers",null, "buyercount", DISPLAY, 0, LEFT, null, NOT_EDITABLE, "buyercount")
   );

/* if PriceVAT or discount in array => make sure that VAT and price are there too */
  if(in_array("priceVAT", $input["fields"]) || in_array("discount", $input["fields"]))
  { if(!in_array("price", $input["fields"]))
	    array_push($input["fields"], "price");
    if(!in_array("VAT", $input["fields"]))
	    array_push($input["fields"], "VAT");
  }
  if(in_array("unitPrice", $input["fields"])) /* if PriceVAT in array => make sure that VAT and price are there too */
  { if(!in_array("price", $input["fields"]))
	    array_push($input["fields"], "price");
  }
  
/* 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", "<")))
		 || (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"];
  $myfields = array("id_product"); /* myfields is used for verifying bought plugins */
  $langfields = array("name","link_rewrite","description","description_short","meta_title","meta_keywords","meta_description","available_now","available_later");

foreach($fieldsorder AS $ofield)
  { if (in_array($ofield, $input["fields"]))
    { 	$infofields[$if_index++] = $field_array[$ofield];
		if(in_array($ofield,$langfields) && (sizeof($extralangfields) > 0))
		{ foreach($extralangfields AS $extralangfield)
		  { $tmp = $field_array[$ofield];
		    $tmp[0] = $tmp[0]."_".$extralangs[$extralangfield];
			$tmp[1][0] = $tmp[1][0]."_".$extralangs[$extralangfield];
		    $tmp[2] = $tmp[2]."_".$extralangs[$extralangfield];
		    $infofields[$if_index++] = $tmp;
		  }
		}
		$myfields[] = $ofield;
	}
  }
  
  foreach($field_array AS $key => $value)
  { if ((in_array($key, $input["fields"])) && (!in_array($key, $fieldsorder)))
    { $infofields[$if_index++] = $value;
	  $myfields[] = $key;
	  if(in_array($key,$langfields) && (sizeof($extralangfields) > 0))
	  { foreach($extralangfields AS $extralangfield)
		{ $tmp = $field_array[$key];
		  $tmp[0] = $tmp[0]."_".$extralangs[$extralangfield];
		  $tmp[1][0] = $tmp[1][0]."_".$extralangs[$extralangfield];
		  $tmp[2] = $tmp[2]."_".$extralangs[$extralangfield];
		  $infofields[$if_index++] = $tmp;
		}
	  }	  
	}
  }
  
  if(in_array("features", $input["fields"])) $myfields[] = "features";

/* 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');
$keywords = array();
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");
  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),
                );
	}
  }
}

/* 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();
$featureblocks = array();
$featurecount = 0;
$featurelist = array();
$featurekeys = 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'];
	$block = '<option value="">Select '.str_replace("'","\'",$row['name']).'</option>';
    $fquery = "SELECT v.id_feature_value, value FROM ". _DB_PREFIX_."feature_value v";
	$fquery .= " LEFT JOIN ". _DB_PREFIX_."feature_value_lang vl ON v.id_feature_value = vl.id_feature_value AND vl.id_lang='".$id_lang."'";
	$fquery .= " WHERE v.id_feature='".$row['id_feature']."' AND v.custom='0'";
	$fres = dbquery($fquery);
	if(mysqli_num_rows($fres) == 0)
		$featureblocks[$featurecount++] = "";
	else
	{ $fvalues = array();
	  while($frow = mysqli_fetch_array($fres))
	  {  $fvalues[$frow['id_feature_value']] = $frow['value'];
	  }
	  natsort($fvalues);
	  foreach($fvalues AS $key => $value)
	  { $value = preg_replace("/[\r\n]+/"," ",$value); /* some people have linefeeds in those values. That doesn't work in the javascript array */
	    $block .= '<option value="'.$key.'">'.str_replace("'","\'",$value).'</option>';
	  }
	  $featureblocks[$featurecount++] = $block."</select>";
	}
  }
}

$allfields = array_keys($field_array);
$statfields = array("salescnt", "revenue","refunds","orders","buyers","visits","visitz");
$allfields = array_merge($allfields,$statfields, array("features","statistics"));
foreach($input["fields"] AS $key => $val) 
{ /* the following line will filter out garbage */ 
  if(!in_array($val,$allfields) && !in_array($val,$featurelist)) unset($input["fields"][$key]);
}
$taxfields = array("priceVAT","t.rate","ps.id_tax_rules_group");

/* 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 WHERE active=1 ORDER BY id_shop";
	$res=dbquery($query);
	while ($row=mysqli_fetch_array($res)) 
	{ $selected='';
      if ($row['id_shop']==$id_shop) 
		$selected=' selected="selected" ';
      $shopblock .= '<option  value="'.$row['id_shop'].'" '.$selected.'>'.$row['id_shop']."-".$row['name'].'</option>';
	  $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 = '<option value="0">Select VAT</option>';
  while($row = mysqli_fetch_array($res))
  { if(($row["active"]==0) ||($row["deleted"]==1)) 
	  $missing_taxgroups[$row['id_tax_rules_group']] = '<option value="'.$row['id_tax_rules_group'].'" rate="'.(float)$row['rate'].'" selected>'.str_replace("'","\'",$row['name']).'</option>';
    else
      $taxblock .= '<option value="'.$row['id_tax_rules_group'].'" rate="'.(float)$row['rate'].'">'.str_replace("'","\'",$row['name']).'</option>';
    $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";

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']] = '<option value="'.$row['id_tax_rules_group'].'" rate="0" selected>'.str_replace("'","\'",$row['name']).'</option>';
    else
	  $taxblock .= '<option value="'.$row['id_tax_rules_group'].'" rate="0">'.str_replace("'","\'",$row['name']).'</option>';
    $taxrates[$row['id_tax_rules_group']] = 0;
  }
  $taxblock .= "</select>";
}
else
{ $taxblock = '<option value="0">Select VAT</option></select>';
  $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']] = '<option value="'.$row['id_tax_rules_group'].'" rate="0" selected>TAX rules group '.$row['id_tax_rules_group'].'</option>';
    $taxrates[$row['id_tax_rules_group']] = 0;
  }
}

/* redirect block */
/* SELECT column_type FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ps_product' AND COLUMN_NAME = 'redirect_type';
*/
  if(version_compare(_PS_VERSION_ , "1.7.1", "<"))
	$redirectblock = '<option>404</option><option>301</option><option>302</option>';
  else
    $redirectblock = '<option>404</option><option>301-product</option><option>302-product</option><option>301-category</option><option>302-category</option>';
  $redirectblock .= "</select>";

/* visibility block */
  $visibilityblock = '<option>both</option><option>catalog</option><option>search</option><option>none</option>';
  $visibilityblock .= "</select>";
  
/* condition block */
  $conditionblock = '<option>new</option><option>used</option><option>refurbished</option>';
  $conditionblock .= "</select>";
  
/* availorder block */
  $availordertypes = array(0=>"available", 1=>"show price only",2=>"not available");
  $availorderblock = "";
  foreach($availordertypes AS $key => $availordertype)
    $availorderblock .= '<option value="'.$key.'">'.$availordertype.'</option>';
  $availorderblock .= "</select>";

/* pack_stock_type block */
  $packstocktypes = array(0=>"Decrement pack only", 1=>"Decrement products in pack only",2=>"Decrement both",3=>"Default");
  $pack_stock_typeblock = "";
  foreach($packstocktypes AS $key => $packstocktype)
    $pack_stock_typeblock .= '<option value="'.$key.'">'.$packstocktype.'</option>';
  $pack_stock_typeblock .= "</select>";
  
/* 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"];
  }
  
/* make category block */
/* Note that we need the name of all categories. In a quirk Prestashop defines the name of a category for all shops 
 * - even if the category is not defined for that shop. So the filter here works only to get the name of the category for this shop. */
  $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();
  $allcats = array();
  $x=0;
  $categoryblock0 = '<input type=hidden name="category_defaultCQX"><input type=hidden name="mycatsCQX">';
  $categoryblock0 .= '<table cellspacing=8><tr><td><select id="categorylistCQX" size=5 multiple onchange="cat_change(\\\'CQX\\\');">';
  $categoryblock1 = "";
  while ($row=mysqli_fetch_array($res)) 
  { if($row["name"]!="")
	{ if(in_array($row['name'], $duplos))
	    $name = $row['name']."*".$row['id_category'];
	  else
	    $name = $row['name'];
	  $name = str_replace("\\","\\\\",$name);
      $categoryblock1 .= '<option value="'.$row['id_category'].'">'.str_replace("'","\'",$name).'</option>';
      $category_names[$row['id_category']] = $name;
      $category_rewrites[$row['id_category']] = $row['link_rewrite'];
      $category_parents[$row['id_category']] = $row['id_parent'];	  
	}
	else /* this happens when category is not present in the chosen shop */
	{ $cres = dbquery("SELECT name, link_rewrite FROM "._DB_PREFIX_."category_lang WHERE id_category=".$row["id_category"]." AND id_lang=".$id_lang);
	  if(mysqli_num_rows($cres) > 0)
	  { $crow=mysqli_fetch_array($cres);	  
	    $category_names[$row['id_category']] = $crow["name"];
	    $category_rewrites[$row['id_category']] = $crow['link_rewrite'];
        $category_parents[$row['id_category']] = $row['id_parent'];
	  }
	  else
	  { $category_names[$row['id_category']] = $category_rewrites[$row['id_category']] = "unknown";
        $category_parents[$row['id_category']] = "unknown";
	  }		  
	}
  } 
  $categoryblock1 .= '</select>';
  $categoryblock2 = '</td><td><a href=# onClick=" Addcategory(\\\'CQX\\\'); reg_change(this); return false;"><img src=add.gif border=0></a>';
  $categoryblock2 .= '<input id="category_numberCQX" class="catselnum" onkeyup="change_category_number(\\\'CQX\\\')">';
  $categoryblock2 .= '<a href=# onClick="Removecategory(\\\'CQX\\\'); reg_change(this); return false;"><img src=remove.gif border=0></a></td>';
  $categoryblock2 .= '<td><select id=categoryselCQX size=3 onchange="catsel_change(\\\'CQX\\\');"></select></td>';
  $categoryblock2 .= '<td><a href=# onClick="MakeCategoryDefault(\\\'CQX\\\'); reg_change(this); return false;"><img src="starr.jpg" border=0></a></td></td></tr></table>';

$stockflagsblock = "";
if(in_array('stockflags', $input["fields"])) 
{ $stockflagsarray = array("Manual","Adv Stock Management","ASM with Warehousing");
  $stockflagsblock = '<option value="1">'.$stockflagsarray[0].'</option><option value="2">'.$stockflagsarray[1].'</option><option value="3">'.$stockflagsarray[2].'</option></select>';
}
  
/* make manufacturer block */
if(in_array('manufacturer', $input["fields"]))
{ $query = "SELECT id_manufacturer,name FROM "._DB_PREFIX_."manufacturer ORDER BY name";
  $res=dbquery($query);
  $manufacturerblock = '<option value="0">No manufacturer</option>';
  while($row = mysqli_fetch_array($res))
  { $manufacturerblock .= '<option value="'.$row['id_manufacturer'].'">'.str_replace("'","\'",$row['name']).'</option>';
  }   
  $manufacturerblock .= "</select>";
}
else 
  $manufacturerblock = "";

/* make warehouse block */
if(in_array('stockflags', $input["fields"]))
{ $query = "SELECT w.id_warehouse,name FROM "._DB_PREFIX_."warehouse w";
  $query .= " LEFT JOIN ". _DB_PREFIX_."warehouse_shop ws ON ws.id_warehouse=w.id_warehouse AND ws.id_shop='".$id_shop."'";
  $query .= " ORDER BY name";
  $res=dbquery($query);
  $warehouseblock = '<option value="0">Do not transfer</option>';
  while($row = mysqli_fetch_array($res))
  { $warehouseblock .= '<option value="'.$row['id_warehouse'].'">'.str_replace("'","\'",$row['name']).'</option>';
  }   
  $warehouseblock .= "</select>";
}
else 
  $warehouseblock = "";

$out_of_stockblock = '<option value="0">Deny orders</option><option value="1">Allow orders</option><option value="2">Default</option></select>';
  
/* make carrier block */
if(in_array('carrier', $input["fields"]))
{ $query = "select id_reference,name from ". _DB_PREFIX_."carrier WHERE deleted='0' ORDER BY name";
  $res=dbquery($query);
  $carrierblock0 = '<input type=hidden name="carrier_defaultCQX"><input type=hidden name="mycarsCQX">';
  $carrierblock0 .= '<table cellspacing=8><tr><td><select id="carrierlistCQX" size=4 multiple>';
  $carrierblock1 = "";
  while ($row=mysqli_fetch_array($res)) 
  { $carrierblock1 .= '<option value="'.$row['id_reference'].'">'.str_replace("'","\'",$row['name']).'</option>';
  } 
  $carrierblock1 .= '</select>';
  $carrierblock2 = '</td><td><a href=# onClick=" Addcarrier(\\\'CQX\\\'); reg_change(this); return false;"><img src=add.gif border=0></a><br><br>';
  $carrierblock2 .= '<a href=# onClick="Removecarrier(\\\'CQX\\\'); reg_change(this); return false;"><img src=remove.gif border=0></a></td><td><select id=carrierselCQX size=3><option>none</option></select></td></tr></table>';
}  
else 
  $carrierblock0 = $carrierblock1 = $carrierblock2 = ""; 
  
  /* 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 = '<input type=hidden name="supplier_defaultCQX"><input type=hidden name="mysupsCQX">';
  $supplierblock0 .= '<table><tr><td><select id="supplierlistCQX" size=3>';
  $supplierblock1 = "";
  while ($row=mysqli_fetch_array($res)) 
  { $supplier_names[$row['id_supplier']] = $row['name'];
    $supplierblock1 .= '<option value="'.$row['id_supplier'].'">'.str_replace("'","\'",$row['name']).'</option>';
  }
  $supplierblock1 .= '</select>';
  $supplierblock2 = '</td><td><nobr><a href=# onClick=" Addsupplier(\\\'CQX\\\',1); reg_change(this); return false;"><img src=add.gif border=0></a> &nbsp; &nbsp; ';
  $supplierblock2 .= '<a href=# onClick="Removesupplier(\\\'CQX\\\'); reg_change(this); return false;"><img src=remove.gif border=0></a></nobr></td><td><select size=3 id="supplierselCQX"></select>';
  $supplierblock2 .= '</td><td style="vertical-align:middle"><a href="#" onclick="MakeSupplierDefault(\\\'CQX\\\'); reg_change(this); return false;"><img src="starr.jpg" border="0"></a></td></tr></table>';
}
else 
  $supplierblock0 = $supplierblock1 = $supplierblock2 = "";
  
/* make attachment attachmnts block */
if((in_array('attachmnts', $input["fields"])) || (in_array('virtualp', $input["fields"])))
{ $query = "SELECT a.file_name, l.name, a.id_attachment FROM ". _DB_PREFIX_."attachment a";
  $query .= " LEFT JOIN ". _DB_PREFIX_."attachment_lang l ON a.id_attachment=l.id_attachment AND l.id_lang='".$id_lang."'";
  $query .= " ORDER BY l.name";
  $res = dbquery($query);
  $attachmentblock0 = '<input type=hidden name="attachment_defaultCQX"><input type=hidden name="myattachmentsCQX">';
  $attachmentblock0 .= '<table cellspacing=8><tr><td><select id="attachmentlistCQX" size=4 multiple>';
  $attachmentblock1 = "";
  while ($row=mysqli_fetch_array($res)) 
  { $attachmentblock1 .= '<option value="'.$row['id_attachment'].'">'.str_replace("'","\'",$row['name']).'</option>';
  } 
  $attachmentblock1 .= '</select>';
  $attachmentblock2 = '</td><td><a href=# onClick=" Addattachment(\\\'CQX\\\'); reg_change(this); return false;"><img src=add.gif border=0></a><br><br>';
  $attachmentblock2 .= '<a href=# onClick="Removeattachment(\\\'CQX\\\'); reg_change(this); return false;"><img src=remove.gif border=0></a></td><td><select id=attachmentselCQX size=3><option>none</option></select></td></tr></table>';
  $currentDir = dirname(__FILE__);
  $download_dir = $currentDir."/".$triplepath."download/";
}
else 
  $attachmentblock0 = $attachmentblock1 = $attachmentblock2 = "";

/* 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(in_array("discount", $input["fields"]))
  { $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 .= '<option value="'.$country['id_country'].'" >'.$country['id_country']."-".$country['name'].'</option>';
	}

$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 .= '<option value="'.$group['id_group'].'" >'.$group['id_group']."-".$group['name'].'</option>';
	}
  }
  
  /* currency block: for discounts and suppliers */
  if((in_array("discount", $input["fields"])) || (in_array("supplier", $input["fields"])))
  { $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 .= '<option value="'.$currency['id_currency'].'" >'.$currency['iso_code'].'</option>';
		$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 = '<select name="imgformat" style="width:100px">';
  $row = mysqli_fetch_array($res); /* take small as the default */
  $selected_img_extension = "-".$row["name"].".jpg"; //die("DDDDD ".$selected_img_extension);
  $prod_imgwidth = $row["width"];
  $prod_imgheight = $row["height"];
  mysqli_data_seek($res,0);
  while($row = mysqli_fetch_array($res))
  { if($row["name"] == $input["imgformat"]) 
    { $selected = "selected"; 
	  $selected_img_extension = "-".$row["name"].".jpg";
	  $prod_imgwidth = $row["width"];
	  $prod_imgheight = $row["height"];
	}
    else $selected = "";
    $imgformatblock .= '<option value="'.$row['name'].'" '.$selected.'>'.$row['name'].' ('.$row['width'].'x'.$row['height'].')</option>';
  }
  $imgformatblock .= '</select>';
  
  $force_friendly_product = get_configuration_value('PS_FORCE_FRIENDLY_PRODUCT'); /* automatically regenerate link-rewrite when name changed? */
  
/* section 5: publish header block of html page, including javascript version of select blocks */
?><!DOCTYPE html> 
<html lang="en"><head><meta charset="utf-8">
<?php  // for security reasons the location of Prestools should be secret. So we dont give referer when you click on Prestools.com 
if (isset($_SERVER['HTTP_USER_AGENT']) && (strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') !== false  || strpos($_SERVER['HTTP_USER_AGENT'], 'CriOS') !== false))
  echo '<meta name="referrer" content="no-referrer">';
else
  echo '<meta name="referrer" content="none">';	
echo '
<title>Prestashop Product Multiedit</title>
<link rel="stylesheet" href="style1.css" type="text/css" />
<style>
.imglista { position:relative; float:left; text-align: center;}
.imglista input[type=checkbox] { position:absolute; bottom:6px; left:50%; margin-left:-6px; }
div.imgadder { background-color: #7777FF; width:'.$prod_imgwidth.'px; height:'.($prod_imgheight+7).'px; }
div.imgadder a { position: relative; float: left; top: 50%; left: 50%; transform: translate(-50%, -50%);}
div.imgfloater > div {float:left;}
div.imgfloater > div > div.imgholder { position:relative; width:'.($prod_imgwidth+1).'px; max-width:'.($prod_imgwidth+1).'px; height:'.($prod_imgheight+1).'px; max-height:'.($prod_imgheight+1).'px; margin: 1px; }
div.imgfloater > div img.prodimg { width:'.$prod_imgwidth.'px; max-width:'.$prod_imgwidth.'px; height:'.$prod_imgheight.'px; max-height:'.$prod_imgheight.'px; }
div.imgfloater > div > div img.prodimg1 { width:'.$prod_imgwidth.'px; max-width:'.$prod_imgwidth.'px; max-height:'.$prod_imgheight.'px; }
div.imgfloater > div > div img.prodimg2 { max-width:'.$prod_imgwidth.'px; height:'.$prod_imgheight.'px; max-height:'.$prod_imgheight.'px; margin: auto;}
div.imgfloater > div textarea { width:'.($prod_imgwidth-4).'px; height:1em; margin-left:1px; }

div.imgupload_progress { height: 6px; border: 1px solid #adadad; box-sizing: border-box; top:'.(intval($prod_imgheight/2)-3).'px; left: 2px; right:2px; position:absolute; z-index:20; }
span.imgupload_progressbar { border-radius: 1px; height: 4px; float: left; background-color: #ff0000; }
</style>
<script type="text/javascript" src="utils8.js"></script>
<script type="text/javascript" src="sorter.js"></script>
<script type="text/javascript" src="product-edit8.js"></script>';

?>
<script type="text/javascript">
var prestashop_version = '<?php echo _PS_VERSION_ ?>';
var product_fields = new Array();
var max_input_vars = '<?php echo ini_get('max_input_vars'); ?>';
var imgwidth = '<?php echo $prod_imgwidth ?>';
var imgheight = '<?php echo $prod_imgheight ?>';
var catselectortype = '<?php echo $catselectortype ?>';
var allow_accented_chars = '<?php echo $allow_accented_chars ?>';
var force_friendly_product = '<?php echo $force_friendly_product ?>';
var taxblock = '<?php echo $taxblock ?>';
var redirectblock = '<?php echo $redirectblock ?>';
var visibilityblock = '<?php echo $visibilityblock ?>';
var conditionblock = '<?php echo $conditionblock ?>';
var pack_stock_typeblock = '<?php echo $pack_stock_typeblock ?>';
var availorderblock = '<?php echo $availorderblock ?>';
var supplierblock0 = '<?php echo $supplierblock0 ?>';
var supplierblock1 = '<?php echo $supplierblock1 ?>';
var supplierblock2 = '<?php echo $supplierblock2 ?>';
var manufacturerblock = '<?php echo $manufacturerblock ?>';
var warehouseblock = '<?php echo $warehouseblock ?>';
var stockflagsblock = '<?php echo $stockflagsblock ?>';
var categoryblock0 = '<?php echo $categoryblock0 ?>';
var categoryblock1 = '<?php echo $categoryblock1 ?>';
var categoryblock2 = '<?php echo $categoryblock2 ?>';
var attachmentblock0 = '<?php echo $attachmentblock0 ?>';
var attachmentblock1 = '<?php echo $attachmentblock1 ?>';
var attachmentblock2 = '<?php echo $attachmentblock2 ?>';
var carrierblock0 = '<?php echo $carrierblock0 ?>';
var carrierblock1 = '<?php echo $carrierblock1 ?>';
var carrierblock2 = '<?php echo $carrierblock2 ?>';
var out_of_stockblock = '<?php echo $out_of_stockblock ?>';
var langcopyselblock = '<?php echo $langcopyselblock ?>';
var deliverytimesblock = '<select name="aDeliveryTCQX"  onchange="reg_change(this);"><option value="0">none</option><option value="1">default info</option><option value="2">product info</option></select>';
var shop_ids = '<?php echo implode(",",$shop_ids); ?>';
var lang_ids = '<?php echo implode(",",$langids); ?>';
var lang_codes = '<?php echo implode(",",$langcodes); ?>';
var maxprodimgsize = <?php echo $maxprodimgsize; ?>;
var missing_taxgroups = [];
<?php $x=0; foreach($missing_taxgroups AS $key => $taxline)
{ echo 'missing_taxgroups['.$key.'] = \''.$taxline.'\';
'; 
} 
  ?>

if($imgonly)
	echo " var imgonly=1; ";
if($imgoactiv)
	echo " var imgoactiv=1; ";

check_notbought($myfields);
  echo 'var prestools_missing = ["'.implode('","', $prestools_missing).'"];
  numrecs='.$input["numrecs"].';
  startdate="'.$input["startdate"].'";
  enddate="'.$input["enddate"].'";
  id_shop='.$id_shop.';
  triplepath="'.$triplepath.'";
  fields = ["'.implode('","', array_diff($input["fields"],array("features","statistics"))).'"];
';
?>

function init()
{ showtotals();
  if(typeof zerostatewarning !== 'undefined')
  { var fld = document.getElementById("warning");
    fld.innerHTML = fld.innerHTML+zerostatewarning;
  }
<?php if(isset($lean_tabindex) && ($lean_tabindex) && !$imgonly) /* lean_tabindex is set in settings1.php. It removes links from the tabindex - making work faster for people using the tabkey on the keyboard to navigate between fields */
	echo '
var tab = document.getElementById("Maintable");
var links = tab.getElementsByTagName("a");
var linkcount = links.length;
for(var i=0; i<linkcount; i++)
    links[i].tabIndex = "-1";
var buttons = tab.querySelectorAll("input[type=button]");
var buttoncount = buttons.length;
for(var i=0; i<buttoncount; i++)
  buttons[i].tabIndex = "-1";
'; ?>
}

</script>
</head>
<body onload="init()">
<link rel="stylesheet" href="windowfiles/dhtmlwindow.css" type="text/css" />
<script type="text/javascript" src="windowfiles/dhtmlwindow.js"></script>
<div id="dhtmlwindowholder"><span style="display:none">.</span></div>
<?php

/* section 6: publish page header: menu and diagnostic information */
print_menubar();
echo '<table class="triplehome" cellpadding=0 cellspacing=0><tr>';
echo '<td width="80%" class="headline"><a href="product-edit.php">Product Edit</a><br>';
echo "Config: ";
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` WHERE active=1 AND deleted=0";
$cres=dbquery($cquery);
list($activshop_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_."shop_group` WHERE active=1 AND deleted=0";
$cres=dbquery($cquery);
list($activshop_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_."group_shop` WHERE id_shop=".$id_shop;
$cres=dbquery($cquery);
list($shopgroup_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."lang`";
$cres=dbquery($cquery);
list($lang_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."lang` WHERE active=1";
$cres=dbquery($cquery);
list($actlang_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."lang` l";
$cquery .= " LEFT JOIN `". _DB_PREFIX_."lang_shop` ls ON l.id_lang=ls.id_lang";
$cquery .= " WHERE active=1 AND ls.id_shop=".$id_shop;
$cres=dbquery($cquery);
list($shoplang_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."currency`";
$cres=dbquery($cquery);
list($currency_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."currency` WHERE deleted=0 AND active=1";
$cres=dbquery($cquery);
list($activcurrency_count) = mysqli_fetch_row($cres);
$cquery="select count(*) from `". _DB_PREFIX_."currency` c";
$cquery .= " LEFT JOIN `". _DB_PREFIX_."currency_shop` cs ON c.id_currency=cs.id_currency";
$cquery .= " WHERE deleted=0 AND active=1 AND cs.id_shop=".$id_shop;
$cres=dbquery($cquery);
list($shopcurrency_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 " ".$activshop_count."/".$shop_count." shop(s); ".$activshop_group_count."/".$shop_group_count." shopgroup(s); ".$shopgroup_count."/".$group_count." group(s); ".$shoplang_count."/".$lang_count." language(s); ".$shopcurrency_count."/".$activcurrency_count."/".$currency_count." currencies.";
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 "</td>";

echo '<td style="text-align:right; width:30%" rowspan=3><iframe name=tank width="230" height="95"></iframe></td></tr>';
echo '</tr><tr><td id="notpaid" class="notpaid"></td></tr></table>';

/* section 7: publish search block */
$x=0;
$sortfields = array();
$statz = array("salescount", "revenue","refunds","ordercount","buyercount","visitcount","visitedpages");
foreach($field_array AS $key => $field_row)
{ if(in_array($key, array("pack_stock_type"))) continue;
  if(($field_row[8] == "") || (in_array($field_row[8], $statz))) continue;
  if($key == "accessories") 
	$name=$field_row[1][1]." id";
  else if($key == "availorder")
    $name="available for order";
  else if($key == "category")
    $name=$field_row[1][1]." default id";
  else 
	$name = $field_row[1][1];
  $sortfields[$x++] = array($name,$field_row[8]);
  if($key == "availorder")
  { $sortfields[$x++] = array("show price","ps.show_price");
  }
  else if($key == "category")
  { $sortfields[$x++] = array($field_row[1][1]." name","cl.name"); 
    $sortfields[$x++] = array($field_row[1][1]." id","cl.id_category");
  }
  else if($key == "manufacturer")
  {	$sortfields[$x++] = array($field_row[1][1]." id","p.id_manufacturer");
  }
  else if($key == "supplier")
  { $sortfields[$x++] = array($field_row[1][1]." id","p.id_supplier");
    $sortfields[$x++] = array($field_row[1][1]." reference","su.product_supplier_reference");
  }
  else if($key == "VAT")
  { $sortfields[$x++] = array("VAT group id","ps.id_tax_rules_group");
  }
}

function sortcmp($a, $b)
{ if ($a[0] == $b[0]) return 0;
  return (strcasecmp($a[0],$b[0]));
}
usort($sortfields, "sortcmp");

<?php
$comparer_values = array("in"=>"in","not_in"=>"!in","gt"=>"&gt;","gte"=>"&gt;=","eq"=>"=","not_eq"=>"!=","lte"=>"&lt;=","lt"=>"&lt;");
for($x=1; $x<=3; $x++)
  print_selectunit($x);

function print_selectunit($x)
{ global $comparer_values, $sortfields, $input, $id_lang;
  if(!isset($GLOBALS["search_txt".$x])) return;
  $search_cmp = $input["search_cmp".$x];
  $search_txt = $GLOBALS["search_txt".$x];
  $search_fld = $input["search_fld".$x];
  if($x==1) $txt = "find"; else $txt = "and";
  echo '<td';
  if($x==3)
	  echo ' id="selbox3"';
  echo '><nobr>'.$txt.'<input name="search_txt'.$x.'" type="text" value="'.str_replace('"','&quot;',$search_txt).'" size="6" />
<select name="search_cmp'.$x.'" class="comparer">';
  $found = false;
  foreach($comparer_values AS $key => $value)
  { $selected = "";
    if($key == $search_cmp)
	{ $selected = " selected";
	  $found = true;
	}
    echo '<option value="'.$key.'"'.$selected.'>'.$value.'</option>';
  }
  echo "</select></nobr>";
  echo '<br><select name="search_fld'.$x.'" style="width:10em" onchange="change_sfield(this);"><option>main fields</option>';
  if(!$found) $input["search_cmp".$x] = "in";

$found = false;
  foreach($sortfields AS $sortfield)
  { $selected = "";
	if($search_fld == $sortfield[1])
	{ $selected = "selected";
	  $found = true;
	}
    echo "<option value='".$sortfield[1]."' ".$selected.">".$sortfield[0]."</option>"; 
  }
/* the following fields are named sattrib and sfeatur. The "s" stands for search and at the end 
 * something has been removed from the words feature and attribute. Aim is to make it easy to
 * search for those fields without getting confused by other attribute or feature related code */
  $query = "SELECT id_attribute_group, name FROM `". _DB_PREFIX_."attribute_group_lang` WHERE id_lang=".$id_lang;
  $query .= " ORDER BY name";
  $res = dbquery($query);
  while($row=mysqli_fetch_assoc($res))
  { $selected = "";
	if($search_fld == "sattrib".$row["id_attribute_group"])
	{ $selected = "selected";
	  $found = true;
	}
    echo "<option value='sattrib".$row["id_attribute_group"]."' ".$selected.">a-".$row["name"]."</option>"; 
	$selected = "";
	if($search_fld == "sidattrib".$row["id_attribute_group"])
	{ $selected = "selected";
	  $found = true;
	}
    echo "<option value='sidattrib".$row["id_attribute_group"]."' ".$selected.">a:".$row["name"]." id</option>"; 
  }
  
  $query = "SELECT id_feature, name FROM `". _DB_PREFIX_."feature_lang` WHERE id_lang=".$id_lang;
  $query .= " ORDER BY name";
  $res = dbquery($query);
  while($row=mysqli_fetch_assoc($res))
  { $selected = "";
	if($search_fld == "sfeatur".$row["id_feature"])
	{ $selected = "selected";
	  $found = true;
	}
    echo "<option value='sfeatur".$row["id_feature"]."' ".$selected.">f-".$row["name"]."</option>"; 
	$selected = "";
	if($search_fld == "sidfeatur".$row["id_feature"])
	{ $selected = "selected";
	  $found = true;
	}
    echo "<option value='sidfeatur".$row["id_feature"]."' ".$selected.">f:".$row["name"]." id</option>"; 
  }
  echo '</select></td>';
}

function print_cat3($base, $level, $selector)
{ global $myresults, $mycontent,$triplepath, $id_lang;
  $query = "SELECT c.id_category FROM ". _DB_PREFIX_."category c";
  $query .= " WHERE c.id_parent=".$base." ORDER BY nleft";
  $res=dbquery($query);
  $subcats = array();
  while($row = mysqli_fetch_assoc($res))
    $subcats[] = $row["id_category"];
  mysqli_free_result($res);
  $block = "";
  foreach($subcats AS $subcat)
  { $block .= print_cat3($subcat, $level+1, $selector);
  }
  if($level == 0) return $block;
  $nquery = "SELECT name FROM "._DB_PREFIX_."category_lang cl";
  $nquery .= " WHERE id_category=".$base." AND id_lang=".$id_lang;
  $nres=dbquery($nquery);
  $nrow = mysqli_fetch_assoc($nres);
  $xx = " ";
    for($i=1; $i<$level; $i++)
	  $xx .= "- ";
  if($base == $selector) $selected=" selected"; else $selected = "";
  $tmp = '<option value="'.$base.'"'.$selected.'>'.$xx.$nrow["name"].'</option>';
  return $tmp.$block;
}

echo '<td><nobr>category: <select name="id_category" onchange="change_categories();" style="width:12em">
	<option value="0">All categories</option>';

/* $catselectortype is set in settings1.php */
	if(!isset($catselectortype) || !in_array($catselectortype, array(2,3)))
	{ $query=" select DISTINCT id_category,name from ". _DB_PREFIX_."category_lang WHERE id_lang=".$def_lang." ORDER BY name";
	  $res=dbquery($query);
	  while ($category=mysqli_fetch_array($res)) {
		if ($category['id_category']==$id_category) {$selected=' selected="selected" ';} else $selected="";
	    echo '<option  value="'.$category['id_category'].'" '.$selected.'>'.$category['name'].'</option>';
	  }
	  echo '</select>';
	}
	else if($catselectortype == 2) /* cat with parent like "category <- parent" */
	{ $query= "select DISTINCT cl.id_category,cl.name,cl2.name AS parent from ". _DB_PREFIX_."category_lang cl";
	  $query.= " LEFT JOIN "._DB_PREFIX_."category c on c.id_category=cl.id_category";
	  $query.= " LEFT JOIN "._DB_PREFIX_."category_lang cl2 on cl2.id_category=c.id_parent";	  
	  $query.= " WHERE cl.id_lang=".$def_lang." AND cl2.id_lang=".$def_lang." ORDER BY cl.name";
	  $res=dbquery($query);
	  while ($category=mysqli_fetch_array($res)) {
		if ($category['id_category']==$id_category) {$selected=' selected="selected" '; } else $selected="";
		{ echo '<option value="'.$category['id_category'].'" '.$selected.'>'.$category['name'];
		  echo ' &lt;- '.$category['parent'].'</option>';
		}
	  }
	  echo '</select>';
	}
	else if($catselectortype == 3) /* tree view  */
	{ $query = "SELECT id_category FROM ". _DB_PREFIX_."category WHERE id_parent=0";
	  $res=dbquery($query);
	  $datarow = mysqli_fetch_assoc($res);
	  mysqli_free_result($res);
	  $root = $datarow["id_category"];
	  $mycontent = ""; /* will contain the table */
	  $data = print_cat3($root, 0, $id_category);
	  echo $data;
	}
		
	$catvalue = "";
	if($id_category!=0)
		$catvalue = $id_category;
	echo '<input id="category_number" style="width:26px; height:13px; color:#888888" onkeyup="change_category_number(\'x\')" value="'.$catvalue.'">';
	
	$checked = "";
	if(isset($_GET["subcats"]) && $_GET["subcats"] == "on") $checked = "checked";
    echo ' &nbsp;With subcats<input type="checkbox" name="subcats" '.$checked.'
	onchange="change_subcats()"></nobr>';
 	/* there are problems with <nobr> inside a table cell */

echo ' &nbsp &nbsp; <nobr>Language: <select name="id_lang" style="margin-top:5px">';
	echo $langselblock;
	echo '</select></nobr>
    &nbsp; <nobr>shop: <select name="id_shop">'.$shopblock.'</select></nobr>
    </td></tr></table>';
	if(isset($_GET["search_txt4"]))
	{ echo '<table><tr>';
      for($x=4; $x<=8; $x++)
		print_selectunit($x);
	  echo '</tr></table>';
	}
	else
	{ echo '<div id=selextra></div>';
	  echo '&nbsp; <img src=ander.png onclick="addselectrow(this); return false;">';
	}
	
      echo '&nbsp; Sort by <select name="order" onchange="change_order()">';
	  if ($input['order']=="position") {$selected=' selected="selected" ';} else $selected="";
	  if (($id_category == 0) ||(isset($input['subcats']))) {$catdisp=' style="display:none"';} else $catdisp="";
	  echo '<option '.$selected.$catdisp.' id="cat_order">position</option>';
	  if ($input['order']=="id_product") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>id_product</option>';
	  if ($input['order']=="name") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>name</option>';
	  if ($input['order']=="price") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>price</option>';
	  if ($input['order']=="VAT") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>VAT</option>';
	  if ($input['order']=="shipweight") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>shipweight</option>';
	  if ($input['order']=="image") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>image</option>';
	  if ($input['order']=="active") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>active</option>';
	  if ($input['order']=="availorder") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>availorder</option>';
	  if ($input['order']=="pack_stock_type") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>pack_stock_type</option>';	  
	  if ($input['order']=="visits") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>visits</option>';
	  if ($input['order']=="visitz") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>visitz</option>';	  
	  if ($input['order']=="revenue") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>revenue</option>';
	  if ($input['order']=="refunds") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>refunds</option>';
	  if ($input['order']=="orders") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>orders</option>';
	  if ($input['order']=="buyers") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>buyers</option>';
	  if ($input['order']=="date_upd") {$selected=' selected="selected" ';} else $selected="";
	  echo '<option '.$selected.'>date_upd</option>';
	  echo '</select>';

$checked = "";
	if($rising == 'DESC')
	  $checked = "selected";
    echo ' <SELECT name=rising><option>ASC</option><option '.$checked.'>DESC</option></select>';

echo ' &nbsp; img '.$imgformatblock;
	
	echo '&nbsp; Startrec:&nbsp;<input size=3 name=startrec value="'.$startrec.'">';
	echo ' &nbsp; Nr of recs:&nbsp;<input size=3 name=numrecs value="'.$numrecs.'">';
	
  if(sizeof($extralangs) > 0)
  { echo " &nbsp; Extra languages:";
	foreach($extralangs AS $extralang => $extra_iso)
	{ $checked = "";
	  if(in_array($extralang, $extralangfields)) $checked = " checked";
	  echo ' <input type=checkbox name="extralangfields[]" value="'.$extralang.'"'.$checked.'>'.$extra_iso;
	}
  }

/* Section 8: Publish the block where you can select your fields */
	echo '<table ><tr>';
	foreach($productedit_fieldblock AS $fieldrow)
	{ echo '<tr>';
	  foreach($fieldrow AS $fieldcel)
	  { $checked = in_array($fieldcel, $input["fields"]) ? "checked" : "";
	    if(($fieldcel == "") || (($fieldcel=="pack_stock_type") && (version_compare(_PS_VERSION_ , "1.6.0.12", "<"))
		 || (in_array($fieldcel, array("isbn", "show_condition","state")) && (version_compare(_PS_VERSION_ , "1.7.0", "<")))
		 || (in_array($fieldcel, array("reserved")) && (version_compare(_PS_VERSION_ , "1.7.2", "<")))
		 || (in_array($fieldcel, array("ls_threshold", "aDeliveryT", "deliInStock","deliOutStock","ls_alert")) && (version_compare(_PS_VERSION_ , "1.7.3", "<"))))
		 || (in_array($fieldcel, array("location")) && (version_compare(_PS_VERSION_ , "1.7.5", "<")))
		 || (in_array($fieldcel, array("mpn")) && (version_compare(_PS_VERSION_ , "1.7.7", "<"))))
			echo "<td></td>";
		else if($fieldcel == "features")
			echo '<td><input type="checkbox" name="fields[]" value="features" '.$checked.' onchange="swapFeatures(this)" />Features</td>';
		else if ($fieldcel == "statistics")
			echo '<td><input type="checkbox" name="fields[]" value="statistics" '.$checked.' onchange="swapStats(this)" />Statistics</td>';
		else
			echo '<td><input type="checkbox" name="fields[]" value="'.$fieldcel.'" '.$checked.' />'.$field_array[$fieldcel][1][2].'</td>';
	  }
	  echo '</tr>';
	}

$disped = in_array("features", $input["fields"]) ? "" : "style='display:none'";
	echo '<tr id=featureblock0 '.$disped.'>';
	$fcount = 0;
	$fblock = 0;
	foreach($features AS $key => $feature)
	{	if(!(++$fcount % 10)){ echo '</tr><tr id=featureblock'.++$fblock.' '.$disped.'>'; }
		$cleanfeature = str_replace('"','_',$feature);
		$checked = in_array($cleanfeature, $input["fields"]) ? "checked" : "";
		echo '<td><input type="checkbox" name="fields[]" value="'.$cleanfeature.'" '.$checked.' />'.$feature.'</td>';
	}
	
	$disped = in_array("statistics", $input["fields"]) ? "" : "style='display:none'";
	echo '</tr><tr id=statsblock '.$disped.'">';
	echo '<td colspan=3>Period (yyyy-mm-dd): <input size=5 name=startdate value='.$input['startdate'].'> - <input size=5 name=enddate value='.$input['enddate'].'><img src="ea.gif" title="Statistics here are per shop. For statistics for a product over all shops use product-sort."></td>';
	$checked = in_array("visits", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="visits" '.$checked.' />'.$screentext_pe["visits"][2].'</td>';
	$checked = in_array("visitz", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="visitz" '.$checked.' />'.$screentext_pe["visitz"][2].'</td>';
	$checked = in_array("salescnt", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="salescnt" '.$checked.' />'.$screentext_pe["salescnt"][2].'</td>';
	$checked = in_array("revenue", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="revenue" '.$checked.' />'.$screentext_pe["revenue"][2].'</td>';
	$checked = in_array("refunds", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="refunds" '.$checked.' />'.$screentext_pe["refunds"][2].'</td>';
	$checked = in_array("orders", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="orders" '.$checked.' />'.$screentext_pe["orders"][2].'</td>';	
	$checked = in_array("buyers", $input["fields"]) ? "checked" : "";
	echo '<td><input type="checkbox" name="fields[]" value="buyers" '.$checked.' />'.$screentext_pe["buyers"][2].'</td>';
	
	echo '</tr></table></div></td><td>
	<input type=checkbox name=newwin>new<br/>window<p/>
	<input type="submit" value="search" />
	<hr>
	<div style="display:none">
	<select><option>No queries</option></select><br>
	<button style="margin-top:2px">load query</button><br>
	<button style="margin-top:2px">save query</button>
	</div>
	</td></tr></table></form>';

/* section 9: Mass Edit */
/* first build the array that defines which mass edit functions are available for which fields */
	echo '<script type="text/javascript">
	  
	  var myarray = [];'; /* define which actions to show for which fields */
	  /* indices: 0=Set; 1=insert before 2=insert after 3=replace 4=increase% 5=regenerate 6=add 7=remove 
	  8=copy from other lang 9=copy from field 10=set as default 11=TinyMCE 12=TinyMCE-deluxe 
	  13=replace from field 14=increase amount 15=add fixed target discount 16=strip html, 17=round 
	  18=balance html, 19=touch */
  
    if($langcopyselblock != "")	/* if there are other languages: add "copy from other lang" */
	{ 							/*   0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 */
	  echo '
	  myarray["available_later"] = 	[1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["available_now"] = 	[1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["description"] = 		[1,1,1,1,0,0,0,0,1,1,0,1,1,1,0,0,1,0,1,1];
	  myarray["description_short"]= [1,1,1,1,0,0,0,0,1,1,0,1,1,1,0,0,1,0,1,1];
	  myarray["link_rewrite"] = 	[1,1,1,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["meta_description"] = [1,1,1,1,0,0,0,0,1,1,0,0,0,1,0,0,1,0,0,1];
	  myarray["meta_title"] = 		[1,1,1,1,0,0,0,0,1,1,0,0,0,1,0,0,1,0,0,1];
	  myarray["metakeys"] = 		[1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,1];
	  myarray["name"] = 			[1,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,1];';
	}
	else	/* no other languages    0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 */
	{ echo '
	  myarray["available_later"] = 	[1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["available_now"] = 	[1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["description"] = 		[1,1,1,1,0,0,0,0,0,1,0,1,1,1,0,0,1,0,1,1];
	  myarray["description_short"]= [1,1,1,1,0,0,0,0,0,1,0,1,1,1,0,0,1,0,1,1];
	  myarray["link_rewrite"] = 	[1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["meta_description"] = [1,1,1,1,0,0,0,0,0,1,0,0,0,1,0,0,1,0,0,1];
	  myarray["meta_title"] = 		[1,1,1,1,0,0,0,0,0,1,0,0,0,1,0,0,1,0,0,1];
	  myarray["metakeys"] = 		[1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1];
	  myarray["name"] = 			[1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1];';
	}							/*   0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 */
	echo '
	  myarray["accessories"] = 		[1,0,0,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["active"] = 			[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["attachmnts"] = 		[0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["available"] = 		[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["available_date"]=	[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["carrier"] = 			[0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["category"] = 		[0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,1];
	  myarray["customizations"] = 	[0,0,0,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["default"] = 			[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["discount"] = 		[0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,1];
	  myarray["ean"] = 				[1,1,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1];
	  myarray["image"] = 			[1,0,0,0,0,0,0,1,0,1,0,0,0,1,0,0,0,0,0,1];
	  myarray["link_rewrite"] = 	[1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["manufacturer"] = 	[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["on_sale"] = 			[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];';
	  							/*   0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 */
	echo '
	  myarray["online_only"] = 		[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["price"] = 			[1,0,0,1,1,0,0,0,0,1,0,0,0,0,1,0,0,1,0,1];
	  myarray["priceVAT"] = 		[1,0,0,1,1,0,0,0,0,1,0,0,0,0,1,0,0,1,0,1];
	  myarray["quantity"] = 		[1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1];
	  myarray["redirect"] = 		[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["reference"] = 		[1,1,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1];
	  myarray["Select a field"] = 	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["shipweight"] = 		[1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["shopz"] = 			[0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["stockflags"] = 		[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["supplier"] = 		[1,0,0,0,1,0,1,1,0,0,1,0,0,0,1,0,0,0,0,1];
	  myarray["tags"] = 			[1,0,0,1,0,0,1,1,0,1,0,0,0,1,0,0,0,0,0,1];
	  myarray["unitPrice"] = 		[1,0,0,1,1,0,0,0,0,1,0,0,0,0,1,0,0,1,0,1];
	  myarray["upc"] = 				[1,1,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1];
	  myarray["VAT"] = 				[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1];
	  myarray["wholesaleprice"] = 	[1,0,0,1,1,0,0,0,0,1,0,0,0,0,1,0,0,1,0,1];';
								/*   0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 */
								
   	foreach($featurelist AS $key => $feature)
	{ if (version_compare(_PS_VERSION_ , "1.7.3", ">="))
	    echo 'myarray["feature'.$key.'field"]=[1,0,0,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1];';
	  else						          /*   0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 */
	    echo 'myarray["feature'.$key.'field"]=[1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1];';
	}									  /*   0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 */
echo '  
	</script>';
	echo '<hr/><table style="background-color:#CCCCCC; width:100%"><tr><td style="width:90%">'.t('Mass update').'<form name="massform" onsubmit="massUpdate(); return false;">
	<select name="field" onchange="changeMfield()"><option value="Select a field">'.t('Select a field').'</option>';
	$extralangscript = "";
	foreach($field_array AS $key => $field)
	{	if((in_array($key, $input["fields"])) && ($field[7] != NOT_EDITABLE))
		{ echo '<option value="'.$field[0].'">'.$field[1][0].'</option>';
		  if(in_array($field[0], $langfields))
		  { foreach($extralangfields AS $extralangfield)
			{ echo '<option value="'.$field[0]."_".$extralangs[$extralangfield].'">'.$field[1][0]."_".$extralangs[$extralangfield].'</option>';
			  $extralangscript .= 'myarray["'.$field[0]."_".$extralangs[$extralangfield].'"] = myarray["'.$field[0].'"].slice();
			  // myarray["'.$field[0]."_".$extralangs[$extralangfield].'"][8] = 0;
';
			}
		  }
		}
	}
	foreach($features AS $key => $feature)
    { $cleanfeature = str_replace('"','_',$feature);
	  if (in_array($cleanfeature, $input["fields"]))
	  {	echo '<option value="feature'.$key.'field">'.$feature.'</option>';
	  }
	}
	echo '</select>';
	echo '<script>'.$extralangscript.'</script>';
	echo '<select name="action" onchange="changeMAfield()" style="width:135px"><option>Select an action</option>';
	echo '<option>set</option>';
	echo '<option>insert before</option>';
	echo '<option>insert after</option>';
	echo '<option>replace</option>';
	echo '<option>increase%</option>';
	echo '<option>regenerate</option>';
	echo '<option>add</option>';
	echo '<option>remove</option>';
	echo '<option>copy from other lang</option>';
	echo '<option>copy from field</option>';
	echo '<option>set as default</option>';	
	echo '<option>TinyMCE</option>';
	echo '<option>TinyMCE-deluxe</option>';
	echo '<option>replace from field</option>';	
	echo '<option>increase amount</option>';
	echo '<option>add fixed target discount</option>';	
	echo '<option>strip html</option>';
	echo '<option>round</option>';
	echo '<option>balance html</option>';
	echo '<option>touch</option>';	
	echo '</select>';
	echo '&nbsp; <span id="muval">value: <textarea name="myvalue" class="masstarea"></textarea></span>';
	echo ' &nbsp; &nbsp; <input type="submit" value="'.t('update all editable records').'"></form>';
	echo t('NB: Prior to mass update you need to make the field editable. Afterwards you need to submit the records');
	echo '</td></tr></table>';
	
/* section 10: csv generation */
/* the searchblock will be copied to csvsearchdiv before submission */
	echo '<table class="triplecsv" ><tr><td width="50%"><form name=csvform target=_blank action="product-csv.php">Separator <input type="radio" name="separator" value="semicolon" checked>; <input type="radio" name="separator" value="comma">, ';
	echo '<input type=hidden name=verbose><div style="display:none" id="csvsearchdiv"></div>';
	echo ' &nbsp; <button onclick="submitCSV(); return false;">Export CSV</button>';
	echo ' &nbsp; &nbsp; select the fields and records in the search block</form></td>';
	
/* section 11: csv import */	
	echo '<td width="50%" style="display:none"><form method="post" name=csvimportform enctype="multipart/form-data" target=tank action="product-csv-import.php">';
	echo '<input type="file" name="fileToUpload" id="fileToUpload">';
	echo ' &nbsp; Separator <input type="radio" name="separator" value="semicolon" checked>; <input type="radio" name="separator" value="comma">, ';
	echo '<input type=hidden name=verbose><input type=hidden name=myprods><input type=hidden name=myfields>';
	echo '<input type=hidden name=myprodidxs> &nbsp; <button onclick="importCSV(); return false;">Import CSV</button>';
	echo ' &nbsp; <img src="ea.gif" title="The first field of the CSV must be the product id. Editable fields will be updated from the CSV. Use as column headings in the csv the same names as in Settings1.php">';
	echo '</form></td></tr></table>';
	
/* section 12: re-indexation */
  echo '<form name=IndexForm action="reindex.php" target="tank" method="post"><table class="tripleminimal"><tr><td style="width:80%">
  <input type=checkbox name=skipindexation>'.t('Skip indexation (much faster, but you need to re-index later as the products will be marked unindexed and not longer be visible for search in your shop)').'
  </td>';

echo '</tr></table></form><hr>';

/* section 13: the switchform: hide/show fields and submit button */
  echo '<form name=SwitchForm><table class="tripleswitch" style="empty-cells: show;"><tr><td><br>Hide<br>Show<br>Edit</td>';
  
  for($i=2; $i< sizeof($infofields); $i++)
  { /* standard the start mode of fields is "DISPLAY"(=1). But you could specify in $infofields[$i][3] that the field is initially hidden or in edit mode */
	$checked0 = $checked1 = $checked2 = "";
    if($infofields[$i][3] == 0) $checked0 = "checked"; 
    if($infofields[$i][3] == 1) $checked1 = "checked"; 
    if($infofields[$i][3] == 2) $checked2 = "checked";

$colorclass = "";
	
	if(in_array($infofields[$i][0], $prestools_missing))
	  $colorclass = "notpaid";
    echo '<td class="'.$colorclass.'">'.$infofields[$i][1][0].'<br>';
    echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_off" value="0" '.$checked0.' onClick="switchDisplay(\'offTblBdy\', this,'.$i.',0)" /><br>';
    echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_on" value="1" '.$checked1.' onClick="switchDisplay(\'offTblBdy\', this,'.$i.',1)" /><br>';
    if ($infofields[$i][0] == "stockflags")
	{ /* first check the global flags. if they don't allow stockkeeping everything stops */
	  $query="select value from ". _DB_PREFIX_."configuration WHERE name='PS_STOCK_MANAGEMENT'";
	  $res = dbquery($query);
	  $row = mysqli_fetch_array($res);
	  $query="select value from ". _DB_PREFIX_."configuration WHERE name='PS_ADVANCED_STOCK_MANAGEMENT'";
	  $res2 = dbquery($query);
	  $row2 = mysqli_fetch_array($res2);
	  $stock_allowed = false;
	  if(($row["value"] == "1") && ($row2["value"] == "1")) $stock_allowed = true;
	}
	if(($infofields[$i][0]!="parent") && ($infofields[$i][0]!="depth") && ($infofields[$i][7]!=NOT_EDITABLE) && (($infofields[$i][0]!="stockflags") || $stock_allowed))
      echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_edit" value="2" '.$checked2.' onClick="switchDisplay(\'offTblBdy\', this,'.$i.',2)" />';
    else
      echo "&nbsp;";
    echo "</td>";
  }

$colorclass = "";
  if(in_array("features", $prestools_missing))
	  $colorclass = "notpaid";
  foreach($features AS $key => $feature)
  {	$cleanfeature = str_replace('"','_',$feature);
    if (in_array($cleanfeature, $input["fields"]))
	{   echo '<td class="'.$colorclass.'"><nobr>'.$feature.'</nobr><br>';
		echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_off" value="0" '.$checked0.' onClick="switchDisplay(\'offTblBdy\', this,'.$i.',0)" /><br>';
		echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_on" value="1" '.$checked1.' onClick="switchDisplay(\'offTblBdy\', this,'.$i.',1)" /><br>';
		echo '<nobr>';
		$pos = array_search($cleanfeature, $featurelist);
		$pos2 = array_search($pos, $featurekeys);
		if($featureblocks[$pos2] != "")
		  echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_edit" value="4" onClick="switchDisplay(\'offTblBdy\', this,'.$i.',4)" />';
		echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_edit" value="2" onClick="switchDisplay(\'offTblBdy\', this,'.$i.',2)" />';
		echo '<input type="radio" name="disp'.$i.'" id="disp'.$i.'_edit" value="3" onClick="switchDisplay(\'offTblBdy\', this,'.$i.',3)" /></nobr>';
		echo '</td>';
		$i++;
	}
  }
  echo "<td width='35%' align=center><input type=checkbox name=verbose>verbose &nbsp; &nbsp; ";
  echo "<input type=button value='Submit all' onClick='return SubmitForm();'></form></td>";
  if (in_array("image", $input["fields"]))
    $listsize = 20;
  else 
    $listsize = 40;

/* section 14: list form */
  echo '<td width="20%">
    <form name="listerform" target=_blank action="product-list.php"><input type=hidden name=verbose>
    <input type=checkbox name=listdefault checked> default fields<br/>
    Lines/page: <input name="listlines" value="'.$listsize.'" size="2"><br/>
	<nobr>Separationlines: <input name="listseps" value="1" size="1"></nobr><br/>
    Cols: <select name="listcols"><option>1</option><option>2</option><option selected>3</option></select> &nbsp;
	<div style="display:none" id="listsearchdiv"></div>
	<input type="submit" value="List products" onclick="ListProducts(); return false;" title="Make a printable productlist of the selected products and fields." /></td></tr></table></form>
	';
	
/* section 15: Hidden form for copying data from one language to another */
  echo '<form name="copyForm" action="copy_product_language.php" target="tank" method="post"><input type="hidden" name="products"><input type="hidden" name="id_shop" value="'.$id_shop.'"><input type="hidden" name="id_lang" value="'.$def_lang.'"><input type=hidden name=fields></form>';
 // "*********************************************************************";

/* 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 = $searchword_needed = $taxinfo_needed = false;
$visitcount_needed = $visitedpages_needed = false;
for($x=1; $x<=8; $x++)
{ if(!isset($GLOBALS["search_txt".$x])) continue;
  $search_cmp = $input["search_cmp".$x];
  $search_txt = $GLOBALS["search_txt".$x];
  $search_fld = $input["search_fld".$x];
  $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 == "") && (!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((in_array($search_fld,$idfields)|| (substr($search_fld,0,9) == "sidattrib") || (substr($search_fld,0,9) == "sidfeatur")) && (($search_cmp == "eq")||($search_cmp == "not_eq")) && (trim($search_txt)!=""))
  { 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);
	  }
	}
	
    $wheretext .= " AND ".$nottext." (".rangetosql($search_txt, $search_fld).")";
	continue;
  }
  
  if(($search_fld == "m.name") || (($search_fld == "main fields") && ($search_txt !="")) || in_array("manufacturer",$keywords)) 
    $manufacturer_needed = true;
  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   /* default = "in": also for "not_in" */
	  $inc = "like '%".$search_txt."%'";
    if($search_fld == "main 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") /* the "indexes" search term: look for keywords */
    { /* NB: the "indexed" search term has as $search_fld ps.indexed and can be 0 or 1 */
	  $wheretext .= " AND sw.word ".$nottext." ".$inc;
      $searchword_needed = true;
    }
    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 == "su.product_supplier_reference")
	  $wheretext .= " AND ".$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($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(in_array($search_fld, $taxfields))
	{ $wheretext .= " AND ".$nottext.$search_fld." ".$inc." ";
	  $taxinfo_needed = true;
	}
	else if($search_fld == "visitcount")
	{ $visitcount_needed = true;
	}
	else if($search_fld == "visitedpages")
	{ $visitedpages_needed = true;
	}
    else if($search_fld == "p.reference") /* check here also for supplier reference */
    { $wheretext .= " AND ".$nottext." (".$search_fld." ".$inc." ";
   	  $wheretext .= " OR 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 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"))
    {// $extra_options = ["p.visibility","p.available_for_order","p.show_price"];
	 // if(in_array($search_fld, $searchtabfields) || in_array($search_fld, $extra_options))
	    $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 == "accessories")
	   $wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."accessory acc WHERE acc.id_product_1 = p.id_product)";
     else if($search_fld == "tg.name")
	   $wheretext .= " AND ".$nottexta." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_tag ptg WHERE ptg.id_product = p.id_product)";
     else if($search_fld == "su.product_supplier_reference")
   	  $wheretext .= " AND ".$nottext." EXISTS(SELECT NULL FROM ". _DB_PREFIX_."product_supplier psu WHERE psu.id_product = p.id_product AND psu.product_supplier_reference ='')";
     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 == "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)";
	 $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))";
	 }
     else if($search_fld == "pl.description") 
	   $wheretext .= " AND ".$nottexta." EXISTS(SELECT REGEXP_REPLACE(description,'<[^>]*>','') AS descra FROM ". _DB_PREFIX_."product_lang plx WHERE plx.id_product = p.id_product AND plx.id_lang=".$id_lang." HAVING descra='')";
	//   $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.id_shop=".$id_shop." AND plx.description='')";
     else if($search_fld == "pl.description_short") 
	   $wheretext .= " AND ".$nottexta." EXISTS(SELECT REGEXP_REPLACE(description_short,'<[^>]*>','') AS descra FROM ". _DB_PREFIX_."product_lang plx WHERE plx.id_product = p.id_product AND plx.id_lang=".$id_lang." AND plx.id_shop=".$id_shop." HAVING descra='')";
     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.")";
    }
	else if((($search_cmp == "not_eq") || ($search_cmp == "eq")) && !in_array($search_fld, array("discount","virtualp","custFlds"))) 
	{ if($search_cmp == "not_eq")
	  { $wheretext .= " AND ".$search_fld."!=''";
	    if($search_fld == "p.ean13")
		  $wheretext .= " AND ".$search_fld."!='0'";
	  }
	  else if($search_cmp == "eq")
	  { if($search_fld == "p.ean13")		
		  $wheretext .= " AND (".$search_fld."='' OR ".$search_fld."='0')";
	    else
		  $wheretext .= " AND ".$search_fld."=''";	
	  }	  
	}	
//	else die("NNAART");
  }
  /* 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<=8; 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 = "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($searchword_needed)
{ $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"]))
{ if(isset($input['subcats']))
    $queryterms .= ", c.nleft,cp.position";
  else
    $queryterms .= ", cp.position";
}

if($taxinfo_needed || in_array($input["order"],$taxfields) || (in_array("VAT",$input["fields"])))  /* VAT check only needed for product-csv */
{ $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";
}

$extralangcodes = array();
foreach($extralangfields AS $extralangfield)
{ $extralangcodes[] = $isocode = $extralangs[$extralangfield];
  $query.=" LEFT JOIN (SELECT id_product, name AS name_".$isocode.", link_rewrite AS link_rewrite_".$isocode.",";
  $query .= "description AS description_".$isocode.",description_short AS description_short_".$isocode.",";
  $query .= "meta_title AS meta_title_".$isocode.",meta_keywords AS meta_keywords_".$isocode.",";
  $query .= "available_now AS available_now_".$isocode.",available_later AS available_later_".$isocode.",";
  $query .= "meta_description AS meta_description_".$isocode." FROM "._DB_PREFIX_."product_lang";
  $query .= " WHERE id_lang=".$extralangfield." AND id_shop=".$id_shop;
  $query .= ") pl".$isocode." ON pl".$isocode.".id_product=p.id_product";
  $queryterms .= ",name_".$isocode.", link_rewrite_".$isocode.",description_".$isocode;
  $queryterms .= ",description_short_".$isocode.",meta_title_".$isocode.",meta_keywords_".$isocode;
  $queryterms .= ",available_now_".$isocode.",meta_description_".$isocode;
  $queryterms .= ",available_later_".$isocode;
}

$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";  
}

if(in_array("visits", $input["fields"]) OR ($order=="visits") OR ($visitcount_needed))
{ $query .= " LEFT JOIN ( SELECT pg.id_object, count(*) AS visitcount FROM ". _DB_PREFIX_."connections c";
  $query .= " LEFT JOIN ". _DB_PREFIX_."page pg ON pg.id_page_type IN ('".implode(",",$pagetypes)."') AND pg.id_page = c.id_page AND c.id_shop='".$id_shop."'";
  if($input['startdate'] != "")
    $query .= " AND TO_DAYS(c.date_add) >= TO_DAYS('".$input['startdate']."')";
  if($input['enddate'] != "")
    $query .= " AND TO_DAYS(c.date_add) <= TO_DAYS('".$input['enddate']."')";
  $queryterms .= ", visitcount ";
  $query .= " GROUP BY pg.id_object ) v ON p.id_product=v.id_object";
}

if(in_array("visitz", $input["fields"]) OR ($order=="visitz") OR ($visitedpages_needed))
{ /* for mysql 5.7.5 compatibility "SELECT pg.id_object" was replaced by "SELECT MAX(pg.id_object) AS id_object" */
  $query .= " LEFT JOIN ( SELECT MAX(pg.id_object) AS id_object, sum(counter) AS visitedpages ";
  $query .= " FROM ". _DB_PREFIX_."page_viewed v LEFT JOIN ". _DB_PREFIX_."page pg ON pg.id_page_type IN ('".implode(",",$pagetypes)."') AND pg.id_page = v.id_page AND v.id_shop='".$id_shop."'";
  $query .= " LEFT JOIN ". _DB_PREFIX_."date_range d ON d.id_date_range = v.id_date_range";
  if($input['startdate'] != "")
    $query .= " AND TO_DAYS(d.time_start) >= TO_DAYS('".$input['startdate']."')";
  if($input['enddate'] != "")
    $query .= " AND TO_DAYS(d.time_end) <= TO_DAYS('".$input['enddate']."')";
  $queryterms .= ", visitedpages ";
  $query .= " GROUP BY v.id_page ) w ON p.id_product=w.id_object";
}
if((!empty(array_intersect($input["fields"], array("revenue","salescnt","orders")))) OR ($order=="revenue")OR ($order=="orders")OR ($order=="buyers"))
{ $query .= " LEFT JOIN ( SELECT product_id, SUM(product_quantity)-SUM(product_quantity_return) AS quantity, ";
  $query .= " ROUND(SUM(total_price_tax_incl/conversion_rate),2) AS revenue, ";
  $query .= " COUNT(DISTINCT d.id_order) AS ordercount, count(DISTINCT o.id_customer) AS buyercount FROM ". _DB_PREFIX_."order_detail d";
  $query .= " LEFT JOIN ". _DB_PREFIX_."orders o ON o.id_order = d.id_order AND o.id_shop=d.id_shop";
  $query .= " WHERE d.id_shop='".$id_shop."'";
  if($input['startdate'] != "")
    $query .= " AND TO_DAYS(o.date_add) >= TO_DAYS('".$input['startdate']."')";
  if($input['enddate'] != "")
    $query .= " AND TO_DAYS(o.date_add) <= TO_DAYS('".$input['enddate']."')";
  $query .= " AND o.valid=1";
  $query .= " GROUP BY d.product_id ) r ON p.id_product=r.product_id";
  $queryterms .= ", revenue, r.quantity AS salescount, ordercount, buyercount ";
}
if(in_array("refunds", $input["fields"]))
{ $query .= " LEFT JOIN (SELECT product_id AS id_product, ROUND(SUM(amount_tax_incl/conversion_rate),2) AS refunds";
  $query .= " FROM "._DB_PREFIX_."order_slip_detail osd";
  $query .= " INNER JOIN "._DB_PREFIX_."order_detail od ON osd.id_order_detail=od.id_order_detail";
  $query .= " INNER JOIN "._DB_PREFIX_."orders o ON o.id_order=od.id_order";
  $query .= " WHERE o.id_shop='".$id_shop."'";
  if($input['startdate'] != "")
    $query .= " AND TO_DAYS(o.date_add) >= TO_DAYS('".$input['startdate']."')";
  if($input['enddate'] != "")
    $query .= " AND TO_DAYS(o.date_add) <= TO_DAYS('".$input['enddate']."')";
  $query .= " AND o.valid=1";
  $query .= " GROUP BY id_product) rf on rf.id_product=p.id_product";
  $queryterms .= ", refunds";
}

$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,"visits"=>0,"visitz"=>0); /* store here totals for stats */
  if(in_array($order, $statfields))
  { $ordertxt = $statz[array_search($order, $statfields)];
  }
  else
    $ordertxt = str_replace(" ","",$order);
  $query .= " 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 '<table class="tripleminimal"><tr><td style="width:5%">';
  $nextlink = preg_replace("/&?startrec=[0-9]*/","",$_SERVER['REQUEST_URI']);
  if(!strpos($nextlink, "?")) $nextlink .= "?1=1";
  $startrec = $startrec;
  $numrecs4 = $numrecs;  
  if($startrec == 0) echo "PREV ";
  else
  { $prevrec = $startrec-$numrecs4; 
	if($prevrec > $numrecs2) $prevrec = $numrecs2-1;
    if($prevrec < 0) $prevrec = 0;
	echo '<a href="'.$nextlink.'&startrec='.$prevrec.'">PREV</a>';
  }
  echo '</td><td style="width:30%; text-align:center"><b>'.$startrec.' to '.($startrec+$numrecs3-1).'</b> of '.$numrecs2." records (".$activerecs." active) in shop ".$id_shop;
  if($share_stock == 1) echo " - stock group ".$shop_group_name;
  echo '</td><td style="text-align:right; width:5%">';
  if($startrec + $numrecs4 >= $numrecs2) echo " NEXT";
  else
  { $nextrec = $startrec + $numrecs4; 
	echo '<a href="'.$nextlink.'&startrec='.$nextrec.'">NEXT</a>';
  }
  echo "</td></tr></table>";
  
/* 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!<br/>";
  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.<br/>";
  if(in_array("image", $input["fields"]) && (sizeof($shops)>1))
    $warning .= "In multishop all images for any shop are shown. Deleting will only delete for the active shop unless specified otherwise.<br/>";

if(in_array("shopz", $input["fields"]))
    $warning .= "No stock will be assigned if you add a product to more shops.<br/>";
  echo '<span id="warning" style="background-color: #FFAAAA">'.$warning.'</span>';
echo "<script>
var numrecs3 = ".$numrecs3.";
</script>";
  // "*********************************************************************";
  echo '<div id="dhwindow" style="display:none"></div>';
  
/* section 19: The main form: the multishop option */
  if(isset($avoid_iframes) && $avoid_iframes)
	 echo '<form name="Mainform" method=get>';
  else
	echo '<form name="Mainform" method=post>';
  echo '<input type=hidden name=reccount value="'.$numrecs3.'"><input type=hidden name=id_lang value="'.$id_lang.'">';
  if(sizeof($shops)>1)
  { if(!isset($updateallshops)) $updateallshops = 0;
    echo '<table class="triplemain"><tr><td>You have more than one shop. Do you want to apply your changes to other shops too?<br>
	<input type="radio" name="allshops" value="0" '.($updateallshops==0 ? 'checked': '').' onchange="change_allshops(\'0\')"> No ';
	if($share_stock == 1)
	{ echo ' &nbsp; <input type="radio" name="allshops" value="2" '.($updateallshops==1 ? 'checked': '').' onchange="change_allshops(\'2\')"> Yes, to the shop group';
	}
	else if($updateallshops==1) echo '<script>alert("You set an invalid value for $updateallshops!!!");</script>';
	echo ' &nbsp; <input type="radio" name="allshops" value="1" '.($updateallshops==2 ? 'checked': '').' onchange="change_allshops(\'1\')"> Yes, to all shops<br>
		(some stock related fields cannot be shared this way)
	</td></tr></table> ';
  }
  else
	echo '<input type=hidden name=allshops value=0>';
  echo '<input type=hidden name=extralangfields value="'.implode(",",$extralangfields).'">';
  echo '<input type=hidden name=extralangcodes value="'.implode(",",$extralangcodes).'">';
  echo '<input type=hidden name=id_shop value='.$id_shop.'><input type=hidden name=skipindexation>';
  echo '<input type=hidden name=verbose><input type=hidden name=featuresset><input type=hidden name=urlsrc>';
  echo '<input type=hidden name="selectmodestatus" value=0>';
  
/* section 20: The main table: the column headers */
  if(!$imgonly)
  { echo '<div id="testdiv"><table id="Maintable" class="triplemain"><colgroup id="mycolgroup">';
    for($i=0; $i<sizeof($infofields); $i++)
    { $align = $namecol = "";
      if($infofields[$i][5] == 1)
        $align = ' style="text-align:right"';
	  if($infofields[$i][0] == "name")
        $namecol = ' class="namecol"';
      echo "<col id='col".$i."'".$align.$namecol."></col>";
    }
    for(;$i<sizeof($infofields)+$featurecount; $i++)
	  echo "<col id='col".$i."'></col>";
    echo "</colgroup><thead><tr>";
    echo '<th><a href="" onclick="return selectmode(\'offTblBdy\');" title="Chose select mode of rows"><img src="selectmode.png"></a></th>';

$statsfound = false; /* flag whether we should create an extra stats totals line */
    $stattotals = array();
    for($i=1; $i<sizeof($infofields); $i++)
    { $reverse = "false";
      $id="";
      if (in_array($infofields[$i][0], $statfields))
	  { $reverse = 1;
	    $id = 'id="stat_'.$infofields[$i][0].'"'; /* assign id for filling in totals */
        $statsfound = true;
	    $stattotals[$infofields[$i][0]] = floatval(0);
	  }
      echo '<th><a href="" onclick="this.blur(); return sortTable(\'offTblBdy\', '.$i.', '.$reverse.');" '.$id.' fieldname="'.$infofields[$i][0].'" title="'.$infofields[$i][1][1].'">'.$infofields[$i][1][0].'</a></th
>';
    }
    foreach($features AS $key => $feature)
    { $cleanfeature = str_replace('"','_',$feature);
      if (in_array($cleanfeature, $input["fields"]))
	  { $fieldname = "feature".$key."field";
		echo '<th><a href="" onclick="this.blur(); return sortTheTable(\'offTblBdy\', '.$i++.', false);" fieldname="'.$fieldname.'" title="'.str_replace('"','\"',$feature).'">'.$feature.'</a></th>';
	  } 	
	}
    echo '<th><a href="" onclick="this.blur(); return upsideDown(\'offTblBdy\');" title="Upside down: reverse table order"><img src="upsidedown.jpg"></a></th>';
    echo "</tr></thead
  ><tbody id='offTblBdy'>"; /* end of header */
  }
  
/* section 21: the main table: the products */
  $x=0;
  $legacy_images = get_configuration_value('PS_LEGACY_IMAGES');
  $haserrors = false;
  $invalidtaxgroupproducts = array();
  $zerostatefound = false; /* the 'state' field in PS 1.7 should never be zero: we mark it with a red background */
  while ($datarow=mysqli_fetch_assoc($res)) { 
    if(($datarow['name'] == "") || ($datarow['pltest'] === NULL) || ($datarow['ptest'] === NULL))
	{ $haserrors = true;
	  continue;
	}
	if(!isset($taxrates[$datarow['id_tax_rules_group']]))
	{ $invalidtaxgroupproducts[] = $datarow['id_product'];
	  $datarow['id_tax_rules_group'] = 0;
	}
    if($imgonly)
	{ $iquery = "SELECT i.id_image,legend FROM ". _DB_PREFIX_."image i";
	  $iquery .= " LEFT JOIN ". _DB_PREFIX_."image_lang il ON i.id_image=il.id_image AND il.id_lang=".$id_lang;
	  $iquery .= " WHERE id_product='".$datarow['id_product']."' AND cover=1";
	  $ires=dbquery($iquery);
	  echo "<a href='product-solo.php?id_product=".$datarow['id_product']."&id_lang=".$id_lang."&id_shop=".$id_shop."' title='".$datarow['originalname']."' target='_blank'>";
	  if(mysqli_num_rows($ires)==0)
	  { $id_image = 0;
	  }
	  else
	  { $irow=mysqli_fetch_array($ires);
	    $id_image = $irow["id_image"];
	  }
	  /* image positioning */
	  if($x==0) 
	  { $legacy_images = get_configuration_value('PS_LEGACY_IMAGES');
   	    $base_uri = get_base_uri();
		$imgsizing = 'style="width:'.$prod_imgwidth.'px; height:'.$prod_imgheight.'px;"';
	  }
	  echo '<div class="imglista" '.$imgsizing.'>';
	  if($imgoactiv)  /* the user has the option to an active checkbox to the image */
	  { 
//	    echo '<img src="'.$base_uri.'img/square.png" style="position:absolute; bottom:11px; left:4px">';
		echo '<input type=hidden name="id_product'.$x.'" value="'.$datarow['id_product'].'">';
	    if($datarow["active"]) $checked = "checked"; else $checked="";
		echo '<input type="hidden" name="active'.$x.'" value="0">';
	    echo '<input type=checkbox name="active'.$x.'" '.$checked.' value="1" onchange="ioa_change(this)">';
	  }
//	  echo '<img src="'.$base_uri.'img/squarv.png" style="position:absolute; bottom:11px; left:40px">';

if($legacy_images)
	  { $imgbase = $base_uri.'img/p/'.$id_product.'-'.$id_image;
		$imgdir = $base_uri.'img/p/';
		$localbase = $localpath.'/img/p/'.$id_product.'-'.$id_image;
		$localdir = $localpath.'/img/p/';
		$namebase = $id_product.'-'.$id_image;
	  }
	  else
	  { $path = getpath($id_image);
	    $imgbase = $base_uri.'img/p'.$path.'/'.$id_image;
		$imgdir = $base_uri.'img/p'.$path.'/';
		$localbase = $localpath.'/img/p'.$path.'/'.$id_image;
		$localdir = $localpath.'/img/p'.$path.'/';
		$namebase = $id_image;
	  }
	  if($id_image == 0)
	    echo '<span >NO<br>IMG</span>';
	  else if(file_exists($localbase.$selected_img_extension))
		  echo '<img src="'.$imgbase.$selected_img_extension.'" '.$imgsizing.' />';
	  else if(!file_exists($localdir))
        echo '<span >'.$id_image.'<br>missdir</span>';
      else if ($dh = opendir($localdir))
      { $dist = 9999;
	    $nblen = strlen($namebase);
	    while (($file = readdir($dh)) !== false)
        { if(($file == "..") || ($file == ".")) continue;
	      $xfile = strtolower($file);
		  if(substr($xfile,-4) != ".jpg") continue;
		  if(substr($xfile,0,$nblen) != $namebase) continue;
		  list($width, $height, $type, $attr) = getimagesize($localdir.$file);
		  $xdist = ($width - $prod_imgwidth) + ($height - $prod_imgheight);
		  if(($xdist >=0) && ($xdist < $dist))
		  { $selectedfile = $file;
			$dist=$xdist;
			$selwidth = $width;
		  }
		}
	    if($selectedfile != "")
	    { echo '<img src="'.$imgdir.$selectedfile.'" '.$imgsizing.' />';
		}
		else
		  echo '<span title="'.$id_image.';'.str_replace('"','&quot;',$imagelist).'">'.$id_image.'<br>Empty Dir</span>';
	  }
	  else
	    echo '<span title="'.$id_image.';'.str_replace('"','&quot;',$imagelist).'">'.$id_image.'<br>No Dir</span>';
	  echo '</a>';

echo '</div>';
	  mysqli_free_result($ires);
	  $x++;
      continue;
	} /* end of imgonly */

$bgcolor = "";
	if (version_compare(_PS_VERSION_ , "1.7", ">=") && ($datarow["state"]==0))
	{ $bgcolor = 'style="background-color:#ff5555"';
	  $zerostatefound = true;
	}
    /* Note that trid (<tr> id) cannot be an attribute of the tr as it would get lost with sorting */
	
	$combination_count = 0;
	if(!empty(array_intersect($input["fields"], array("quantity","stockflags","warehousing","supplier","reserved","combinations"))))
	{ $aquery = "SELECT count(*) FROM `". _DB_PREFIX_."product_attribute` WHERE id_product='".$datarow['id_product']."'";
	  $ares=dbquery($aquery);
	  list($combination_count) = mysqli_fetch_row($ares); 
	}

$combix = 'combix="0"';
	if($combination_count != 0)
	  $combix = 'combix="1"';
    $stocky = 'stocky="0"';
	if($datarow["depends_on_stock"] == "1")
	  $stocky = 'stocky="1"';
    echo '<tr '.$bgcolor.'><td id="trid'.$x.'" changed="0" '.$combix.' '.$stocky.'><input type="button" value="X" style="width:4px" onclick="RemoveRow('.$x.')" title="Hide row '.$x.' from display" /><input type=hidden name="id_product'.$x.'" value="'.$datarow['id_product'].'"></td>';

for($i=1; $i< sizeof($infofields); $i++)
    { $sorttxt = "";
      $color = "";

if($infofields[$i][0] == "priceVAT")
		$myvalue =  number_format(((($taxrates[$datarow["id_tax_rules_group"]]/100) +1) * $datarow['price']),2, '.', '');
      else if (!in_array($infofields[$i][0], array("attachmnts","carrier","combinations","customizations",
	  "discount","indexes","supplier","tags","virtualp")))
	  { $myvalue = $datarow[$infofields[$i][2]];
	  }
	  /**************************************************************************************************/
	  /* Below the fields are listed alphabetically. Those missing get the default treatment at the end */
      if($i == 1) /* id */
	  { echo "<td><a href='product-solo.php?id_product=".$myvalue."&id_lang=".$id_lang."&id_shop=".$id_shop."' title='".$datarow['originalname']."' target='_blank'>".addspaces($myvalue)."</a></td>";
	  }
	  else if ($infofields[$i][0] == "accessories")
	  { echo "<td srt='".$myvalue."'>";
	    $accs = explode(",",$myvalue);
		$z=0;
	    foreach($accs AS $acc)
		{ if($acc == "") continue;
		  if($z++ > 0) echo ",";
		  echo "<a title='".get_product_name($acc)."' href='#' onclick='return false;' style='text-decoration: none;'>".$acc."</a>";
		}
	    echo "</td>";
	  }  /* end of accessories */
	  
	  else if ($infofields[$i][0] == "aDeliveryT")  // additional_delivery_times
	  { echo "<td>";
		$squery = "SELECT additional_delivery_times FROM ". _DB_PREFIX_."product WHERE id_product='".$datarow['id_product']."'";
		$sres=dbquery($squery);
		$srow=mysqli_fetch_array($sres);
		if($datarow["additional_delivery_times"] == "1")
			echo "default info";	
		else if($datarow["additional_delivery_times"] == "2")
			echo "product info";
		else 
			echo "none";	
	    echo "</td>";
	  }		/* end of aDeliveryT */
	  
	  else if ($infofields[$i][0] == "attachmnts")
      { $cquery = "SELECT a.file_name, a.file, a.mime, l.name, p.id_attachment FROM ". _DB_PREFIX_."product_attachment p";
		$cquery .= " LEFT JOIN ". _DB_PREFIX_."attachment a ON a.id_attachment=p.id_attachment";
	    $cquery .= " LEFT JOIN ". _DB_PREFIX_."attachment_lang l ON a.id_attachment=l.id_attachment AND l.id_lang='".$id_lang."'";
	    $cquery .= " WHERE id_product='".$datarow['id_product']."'";
		echo "<td>";
		$cres=dbquery($cquery);
		$z=0;
		while ($crow=mysqli_fetch_array($cres)) 
		{	if($z++ > 0) echo "<br>";
			echo "<a class='attachlink' title='".$crow['id_attachment']."' href='downfile.php?filename=".$crow["file_name"]."&mode=attachment&frag=".crc32($crow['file'])."' target='_blank'>".$crow['name']."</a>";
	        if(!file_exists($download_dir."/".$crow["file"])) echo " <b>missing</b>";
			}
	    echo "</td>";
		mysqli_free_result($cres);
      }	 /* end of attachmnts */
	  
	  else if ($infofields[$i][0] == "availorder")
	  { echo "<td srt='".$myvalue."'>";
	    $available_for_order = $datarow['available_for_order'];
		$show_price = $datarow['show_price'];
		if($available_for_order == 1)
		  echo $availordertypes[0];
		else if($show_price == 1)
		  echo $availordertypes[1];
		else
		  echo $availordertypes[2];
	    echo "</td>";
	  }		/* end of availorder */
	  
	  else if ($infofields[$i][0] == "carrier")
      { $cquery = "SELECT id_carrier_reference FROM ". _DB_PREFIX_."product_carrier WHERE id_product='".$datarow['id_product']."' AND id_shop='".$id_shop."' LIMIT 1";
		$cres=dbquery($cquery);
		if(mysqli_num_rows($cres) != 0)
		{ $cquery = "SELECT id_reference, cr.name FROM ". _DB_PREFIX_."product_carrier pc";
		  $cquery .= " LEFT JOIN ". _DB_PREFIX_."carrier cr ON cr.id_reference=pc.id_carrier_reference AND cr.deleted=0";
		  $cquery .= " WHERE id_product='".$datarow['id_product']."' AND id_shop='".$id_shop."' ORDER BY cr.name";
		  $cres=dbquery($cquery);
		  echo "<td><table border=1 id='carriers".$x."'>";
		  while ($crow=mysqli_fetch_array($cres)) 
		  { echo "<tr><td id='".$crow['id_reference']."'>".$crow['name']."</td></tr>";
		  }
		  echo "</table></td>";
		}
		else
		  echo "<td></td>";
		mysqli_free_result($cres);
	  }	  /* end of carrier */
	  
      else if ($infofields[$i][0] == "category")
	  { echo "<td ".$sorttxt.">";
	    $cquery = "select id_category from ". _DB_PREFIX_."category_product WHERE id_product='".$datarow['id_product']."' ORDER BY id_category";
		$cres=dbquery($cquery);
		$z=0;
		$default_found = false;
		while ($crow=mysqli_fetch_array($cres)) 
		{	if($z++ > 0)
			{ echo ",";
			  if(!(($z-1)%3)) echo " "; /* put in a space so that the browser can break the line */
			}
			if ($rewrite_settings == '1')
			  $catlink = get_base_uri().$langinsert.$crow['id_category']."-".$category_rewrites[$crow['id_category']];
			else
			  $catlink = get_base_uri().'index.php?id_category='.$crow['id_category'].'&controller=category&id_lang='.$id_lang;
			if ($crow['id_category'] == $myvalue)
			{	echo "<a title='".$category_names[$myvalue]."' href='".$catlink."' target='_blank'>".$myvalue."</a>";
				$default_found = true;
			}
			else 
				echo "<a title='".$category_names[$crow['id_category']]."' href='".$catlink."' target='_blank' style='text-decoration: none;'>".$crow['id_category']."</a>";
		}
	    echo "</td>";
		mysqli_free_result($cres);
	  }  /* end of category */
	  
	  else if ($infofields[$i][0] == "combinations")
      { echo '<td>';
		if($combination_count != 0)
		{ // if($datarow["depends_on_stock"] == "1")
		  echo '<table class="pattribute" style="display:none;" data-wh="'.$datarow["depends_on_stock"].'">';
		  $aquery = "SELECT ps.*, s.quantity, s.depends_on_stock";
		  $aquery .= " ,GROUP_CONCAT(CONCAT(LPAD(at.position,4,'0'))) AS positions FROM ". _DB_PREFIX_."product_attribute pa";
		  $aquery .= " LEFT JOIN ". _DB_PREFIX_."product_attribute_shop ps on pa.id_product_attribute=ps.id_product_attribute AND ps.id_shop='".$id_shop."'";
		  $aquery .= " LEFT JOIN ". _DB_PREFIX_."product_attribute_combination pc on pa.id_product_attribute=pc.id_product_attribute";
		  $aquery .= " LEFT JOIN ". _DB_PREFIX_."attribute at on pc.id_attribute=at.id_attribute";
		  if($share_stock == 0)
			$aquery .=" left join ". _DB_PREFIX_."stock_available s on s.id_product_attribute=pa.id_product_attribute AND s.id_shop = '".$id_shop."'";
		  else
			$aquery .=" left join ". _DB_PREFIX_."stock_available s on s.id_product_attribute=pa.id_product_attribute AND s.id_shop_group = '".$id_shop_group."'";
		  $aquery .= " WHERE pa.id_product='".$datarow['id_product']."' GROUP BY ps.id_product_attribute ORDER BY positions";
		  $ares=dbquery($aquery);
		  while ($arow=mysqli_fetch_array($ares))
		  { echo '<tr id="pa'.$arow["id_product_attribute"].'"><td>';
			$paquery = "SELECT GROUP_CONCAT(CONCAT(gl.name,': ',l.name,' ')) AS nameblock from ". _DB_PREFIX_."product_attribute pa";
			$paquery .= " LEFT JOIN ". _DB_PREFIX_."product_attribute_combination c on pa.id_product_attribute=c.id_product_attribute";
			$paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute a on a.id_attribute=c.id_attribute";
			$paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute_lang l on l.id_attribute=c.id_attribute AND l.id_lang='".$id_lang."'";
			$paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute_group_lang gl on gl.id_attribute_group=a.id_attribute_group AND gl.id_lang='".$id_lang."'";
			$paquery .= " WHERE pa.id_product_attribute='".$arow['id_product_attribute']."' GROUP BY pa.id_product_attribute";
			$pares=dbquery($paquery);
			$parow = mysqli_fetch_array($pares);
			$labels = explode(",", $parow['nameblock']);
			sort($labels);
			foreach($labels AS $label)
				echo $label.", ";
			echo "</td><td>".$arow['quantity']."</td></tr>";
		  }
		  echo '</table>';
		  echo '<a href="combi-edit.php?id_product='.$datarow['id_product'].'&id_shop='.$id_shop.'" title="Click here to edit combinations in separate window" target="_blank" style="background-color:#99aaee; text-decoration:none">&nbsp; '.$combination_count.' &nbsp;</a>';
		}	
		echo "</td>";
      }  /* end of combinations */
	  
      else if ($infofields[$i][0] == "customizations")
	  { echo "<td ".$sorttxt.">";
	  	echo '<table id="customizations'.$x.'">';
		$dquery = "SELECT * FROM ". _DB_PREFIX_."customization_field";
	    $dquery .= " WHERE id_product='".$datarow['id_product']."'";
		if (version_compare(_PS_VERSION_ , "1.7.3", ">="))
		  $dquery .= " AND is_deleted=0";
		$dres=dbquery($dquery);
		while ($drow=mysqli_fetch_array($dres))
		{ echo '<tr data-custid="'.$drow["id_customization_field"].'"><td style="padding:0;"><table>';
		  $equery = "SELECT * FROM ". _DB_PREFIX_."customization_field_lang";
		  $equery .= " WHERE id_customization_field=".$drow["id_customization_field"];
		  if (version_compare(_PS_VERSION_ , "1.6.0.12", ">="))
			$equery .= " AND id_shop=".$id_shop;
		  $eres=dbquery($equery);
		  $custlangs = array();
		  while ($erow=mysqli_fetch_array($eres)) 
		  { $custlangs[$erow["id_lang"]] = $erow["name"];
		  }
		  foreach($langids AS $langid)
		  { echo '<tr><td data-src="'.$langid.'-'.$langcodes[$langid].'">';
		    if((isset($custlangs[$langid])) && ($custlangs[$langid]!=""))
			  echo $custlangs[$langid];
		    else
			  echo "&nbsp;";
			echo '</td></tr>';
		  }
		  echo '</table></td><td>';

if($drow["type"]==0) echo 'uploadfile';
			else echo 'textfield';
	      echo '</td><td>';
		  if($drow["required"]) echo 'req';
		  echo '</td></tr>';
		}
	    echo "</table>";
		if(mysqli_num_rows($dres) > 0)
		  echo '<center><a href="customizations.php?id_product='.$datarow['id_product'].'" target=_blank>See values</a></center>';
		echo "</td>";
		
		mysqli_free_result($dres);
	  }  /* end of customizations */
	  
	  else if ($infofields[$i][0] == "discount")
      { $dquery = "SELECT sp.*, cu.iso_code AS currency";
		$dquery .= " FROM ". _DB_PREFIX_."specific_price sp";
		$dquery.=" left join ". _DB_PREFIX_."currency cu on sp.id_currency=cu.id_currency";		
	    $dquery .= " WHERE sp.id_product='".$datarow['id_product']."'";
		$dres=dbquery($dquery);
		echo "<td><table border=1 id='discount".$x."'>";
		while ($drow=mysqli_fetch_array($dres)) 
		{ $bgcolor = "";
		  if($drow["id_specific_price_rule"] != 0)
			$bgcolor = ' style="background-color:#dddddd"';
		  echo '<tr specid='.$drow["id_specific_price"].' rule='.$drow["id_specific_price_rule"].$bgcolor.'>';
/* 					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($drow["id_shop"] == "0") $drow["id_shop"] = "";
		  echo "<td>".$drow["id_shop"]."</td>";
		  if($drow["id_product_attribute"] == "0") $drow["id_product_attribute"] = "";
		  echo "<td>".$drow["id_product_attribute"]."</td>";
		  echo "<td>".$drow["currency"]."</td>";
		  echo "<td>".$drow["id_country"]."</td>";
		  echo "<td>".$drow["id_group"]."</td>";

if($drow["id_customer"] == "0") $drow["id_customer"] = "";
		  echo "<td>".$drow["id_customer"]."</td>";
		  if($drow["price"] == -1)
		  {	$frompriceVAT = number_format(((($taxrates[$datarow['id_tax_rules_group']]/100) +1) * $datarow['price']),2, '.', '');
		    $fromprice = $datarow['price'];
			$drow["price"] = "";
		  }
		  else /* the prices mentioned here are excl VAT */
		  { $frompriceVAT = (($taxrates[$datarow['id_tax_rules_group']]/100) +1) * $drow['price'];
		    $drow["price"] = $drow["price"] * 1; /* remove trailing zeroes */
		  }
		  echo "<td>".$drow["price"]."</td>";
		  echo "<td style='background-color:#FFFF77'>".$drow["from_quantity"]."</td>";
		  if($drow["reduction_type"] == "percentage")
			$drow["reduction"] = $drow["reduction"] * 100;
		  else 
		    $drow["reduction"] = $drow["reduction"] * 1;
		  echo "<td>".$drow["reduction"]."</td>";
		  $reduction_tax = "1";
		  if (version_compare(_PS_VERSION_ , "1.6.0.11", ">="))
		  { echo "<td>".$drow["reduction_tax"]."</td>"; /* 0=excl; 1=incl before 1.6.0.11 there was only incl */
			$reduction_tax = $drow["reduction_tax"];
		  }
		  else 
		    echo "<td></td>";
		  if($drow["reduction_type"] == "amount") $drow["reduction_type"] = "amt"; else $drow["reduction_type"] = "pct";
		  echo "<td>".$drow["reduction_type"]."</td>"; 
		  if($drow["from"] == "0000-00-00 00:00:00") $drow["from"] = "";
		  else if(substr($drow["from"],11) == "00:00:00") $drow["from"] = substr($drow["from"],0,10);
		  echo "<td>".$drow["from"]."</td>";
		  if($drow["to"] == "0000-00-00 00:00:00") $drow["to"] = ""; 
		  else if(substr($drow["to"],11) == "00:00:00") $drow["to"] = substr($drow["to"],0,10);
		  echo "<td>".$drow["to"]."</td>";
		  if ($drow['reduction_type'] == "amt")
		  { if($reduction_tax == 1)
			  $newprice = $frompriceVAT - $drow['reduction'];
			else
			  $newprice = $frompriceVAT - ($drow['reduction']*(1+($taxrates[$datarow['id_tax_rules_group']]/100)));
		  }
		  else 
		    $newprice = $frompriceVAT*(1-($drow['reduction']/100));
		  $newpriceEX = (1/(($taxrates[$datarow['id_tax_rules_group']]/100) +1)) * $newprice;
	      $newprice = number_format($newprice,2, '.', '');
          $newpriceEX = number_format($newpriceEX,2, '.', '');
		  
		  echo '<td>'.$newpriceEX.'/ '.$newprice.'</td>';
		  echo "</tr>";
		}
		echo "</table></td>";
		mysqli_free_result($dres);
      }  /* end of discount */
      else if ($infofields[$i][0] == "featureEdit")
	  { $fquery = "SELECT fp.*,custom,fvl.value AS fvvalue, fl.name AS feature FROM "._DB_PREFIX_."feature_product fp";
		$fquery .= " LEFT JOIN "._DB_PREFIX_."feature_value fv ON fp.id_feature_value=fv.id_feature_value";
		$fquery .= " LEFT JOIN "._DB_PREFIX_."feature_value_lang fvl ON fp.id_feature_value=fvl.id_feature_value AND fvl.id_lang=".$id_lang;
		$fquery .= " LEFT JOIN "._DB_PREFIX_."feature_lang fl ON fv.id_feature=fl.id_feature AND fl.id_lang=".$id_lang;
		$fquery .= " WHERE fp.id_product='".$datarow['id_product']."'";
		$fres=dbquery($fquery);
		$tmp = "";
		while($frow = mysqli_fetch_assoc($fres))
		{ $tmp .= "<b>".$frow["feature"]."</b>: ";
		  if($frow["custom"] == '1')
		    $tmp .= "<b>".$frow["fvvalue"]."</b><br>";
		  else
		    $tmp .= $frow["fvvalue"]."<br>";
		}
		if($tmp == "") 
		  $tmp="FE";
        echo '<td style="text-align:center"><a href="feature-edit.php?id_product='.$datarow["id_product"].'&id_lang='.$id_lang.'&id_shop='.$id_shop.'" target="_blank" style="text-decoration:none;  ">'.$tmp.'</a></td>';
	  }
      else if ($infofields[$i][0] == "image")
      { $iquery = "SELECT i.id_image,ish.cover AS ishcover,legend, ish.id_shop FROM "._DB_PREFIX_."image i";
		$iquery .= " LEFT JOIN "._DB_PREFIX_."image_lang il ON i.id_image=il.id_image AND il.id_lang='".$id_lang."'";
		$iquery .= " LEFT JOIN "._DB_PREFIX_."image_shop ish ON i.id_image=ish.id_image AND ish.id_shop='".$id_shop."'";
		$iquery .= " WHERE i.id_product='".$datarow['id_product']."' ORDER BY position";
		$ires=dbquery($iquery);
		$cover_image = 0;
		$imagelist = "";
		$firstimg=0;
		$notinshops = array(); /* handle multishop cases where image is not in active shop; note that we show all images for sorting */
		while ($irow=mysqli_fetch_array($ires)) 
		{	if($irow['ishcover'] == 1)
			{ $cover_image=$irow['id_image'];
			}
			$imagelist .= "|".$irow['id_image']."|".$irow['legend'];
			if($firstimg ==0) $firstimg = $irow['id_image'];
			if($irow['id_shop'] == NULL) $notinshops[] = $irow['id_image'];
		}
		if(($cover_image == 0) && ($firstimg !=0))
		{ $cover_image = $firstimg;	
		}
		$imgsnotinshop = "";
		if(sizeof($notinshops)>0)
			$imgsnotinshop = 'data-notinshop="'.implode("",$notinshops).'"';
		echo '<td '.$imgsnotinshop.'>'.get_product_image($datarow["id_product"], $cover_image,$imagelist).'</td>';
		mysqli_free_result($ires);
      }  /* end of image */	
	  else if ($infofields[$i][0] == "indexes")
	  { echo '<td>';
	    if($datarow['active'] == 0) 
		  echo 'not active';
		else if(($datarow['visibility'] != 'both') && ($datarow['visibility'] != 'search'))
		  echo 'visibility='.$datarow['visibility'];
		else if($datarow['indexed'] == 0) 
		  echo 'not indexed';
		else
		{ $iquery = "SELECT count(word) AS indexes FROM "._DB_PREFIX_."search_word sw";
		  $iquery .= " LEFT JOIN "._DB_PREFIX_."search_index si ON sw.id_word=si.id_word";
		  $iquery .= " WHERE sw.id_shop=".$id_shop." AND sw.id_lang=".$id_lang." AND si.id_product=".$datarow["id_product"];
		  $ires=dbquery($iquery);
		  $irow = mysqli_fetch_array($ires);
		  echo '<a href="prodwords.php?id_product='.$datarow["id_product"].'&id_shop='.$id_shop.'&id_lang='.$id_lang.'" target=_blank>'.$irow["indexes"].'</a>';
		}
		echo '</td>';
	  }
	  else if ($infofields[$i][0] == "name")
	  { if ($rewrite_settings == '1')
		{ if($route_product_rule == NULL) // retrieved previously with get_configuration_value('PS_ROUTE_product_rule'); 
		  { $eanpostfix = ""; 
		  	if(($datarow['ean13'] != "") && ($datarow['ean13'] != null) && ($datarow['ean13'] != "0"))
				$eanpostfix = "-".$datarow['ean13'];
	        echo "<td><a href='".get_base_uri().$langinsert.str2url($datarow['catrewrite'])."/".$datarow['id_product']."-".str2url($datarow['link_rewrite']).$eanpostfix.".html"."' title='".$datarow['originalname']."' target='_blank' class='redname'>".$myvalue."</a></td>";
		  }
		  else // customized link. Prestashop code in getProductLink() in classes\Link.php that refers to classes\Dispatcher.php
		  { $produrl = $route_product_rule;
		    if($datarow["ean13"] == "0") $datarow["ean13"] = "";
			foreach ($keywords as $key) 
	        { if($key == "id") 	$keyvalue = $datarow["id_product"];
			  else if($key == "category") 	$keyvalue = str2url($datarow["catrewrite"]);
			  else if($key == "categories") /* multilevel cats like in /cat1/cat2/cat3/product */
			  { $tmp = array();
			    $tid = $datarow["id_category_default"];
			    while($category_parents[$category_parents[$tid]] !=0)
				{ $tmp[] = str2url($category_rewrites[$tid]);
				  $tid = $category_parents[$tid];
				}
				$keyvalue = implode('/', array_reverse($tmp));
			  }
			  else if($key == "ean13") 		$keyvalue = $datarow["ean13"];
			  else if($key == "manufacturer")	$keyvalue = $datarow["manufacturer"];
			  else if($key == "meta_keywords") 	$keyvalue = $datarow["meta_keywords"];
			  else if($key == "meta_title")	$keyvalue = $datarow["meta_title"];
			  else if($key == "price")	$keyvalue = $datarow["price"];			  
			  else if($key == "reference") 	$keyvalue = $datarow["reference"];				  
			  else if($key == "rewrite") 	$keyvalue = $datarow["link_rewrite"];
			  else if($key == "supplier")
			  { $sqry = "SELECT name FROM "._DB_PREFIX_."supplier WHERE id_supplier=".$datarow["id_supplier"];
		        $srs = dbquery($sqry);
				$srw = mysqli_fetch_assoc($srs);
				$keyvalue = $srw["name"];
			  }
			  else if($key == "tags")
			  { $tquery = "SELECT GROUP_CONCAT(name SEPARATOR '-') AS tags FROM ". _DB_PREFIX_."product_tag pt";
				$tquery .= " LEFT JOIN ". _DB_PREFIX_."tag t ON pt.id_tag=t.id_tag AND t.id_lang='".$id_lang."'";
				$tquery .= " WHERE pt.id_product='".$datarow['id_product']."' GROUP BY id_product";
				$tres=dbquery($tquery);
				$trow = mysqli_fetch_assoc($tres);
				$keyvalue = str2url($trow["tags"]);
			  }			  
			  else $keyvalue = "xxxx"; // Should not happen

if($key != "categories")
			    $keyvalue = str2url($keyvalue);
			  if ($keyvalue != "") 
			  { $replace = $transform_keywords[$key]['prepend'].$keyvalue.$transform_keywords[$key]['append'];
			  }
			  else 
			  { $replace = '';
			  }
			  $produrl = preg_replace('#\{([^{}]*:)?'.$key.'(:[^{}]*)?\}#', $replace, $produrl);
			}
           $produrl = preg_replace('#\{([^{}]*:)?[a-z0-9_]+?(:[^{}]*)?\}#', '', $produrl);
			
	        echo "<td><a href='".get_base_uri().$langinsert.$produrl."' title='".$datarow['originalname']."' target='_blank' class='redname'>".$myvalue."</a></td>";
		  }
		}
		else
          echo "<td><a href='".get_base_uri()."index.php?id_product=".$datarow['id_product']."&controller=product&id_lang=".$id_lang."' title='".$datarow['originalname']."' target='_blank' class='redname'>".$myvalue."</a></td>";
	  }  /* end of name */
	  
	  else if ($infofields[$i][0] == "out_of_stock")
	  { echo '<td>';
		$myvalue = $datarow["out_of_stock"];
		if($myvalue == "0") echo "Deny orders";
		else if($myvalue == "1") echo "Allow orders";
		else echo "Default";		
		echo '</td>'; 
	  }		/* end of out_of_stock */
	  
      else if ($infofields[$i][0] == "pack_stock_type")
      { echo "<td>".$packstocktypes[(int)$myvalue]."</td>";
      }  	/* end of pack_stock_type */
	  
	  else if ($infofields[$i][0] == "position")
	  { echo '<td>'.$datarow["position"].'</td>'; 
	  }		/* end of position */
	  
	  else if ($infofields[$i][0] == "quantity")
	  { if($myvalue == "") $myvalue = "0"; /* handle cases when there are no entries in stock_available table */
		if($combination_count != 0)
            echo '<td style="background-color:#FF8888"><a href="combi-edit.php?id_product='.$datarow['id_product'].'&id_shop='.$id_shop.'" target=_blank>'.$myvalue.'</a></td>';	 
		else if($datarow["depends_on_stock"] == "1")
          echo '<td style="background-color:yellow">'.$myvalue.'</td>';	  
		else
            echo "<td>".$myvalue."</td>";
	  }		/* end of quantity */
	  else if ($infofields[$i][0] == "redirect")
	  { echo '<td data-id="'.$datarow["id_redirected"].'">';
		echo $myvalue;
		if($myvalue != "404")
		  echo "<br>".$datarow["id_redirected"];
		echo '</td>';
	  }	  
	  else if ($infofields[$i][0] == "reserved")
	  { if($combination_count == 0)
		{ $rquery = "SELECT reserved_quantity AS reserved FROM "._DB_PREFIX_."stock_available";
		  $rquery .= " WHERE id_product='".$datarow['id_product']."'";
		  $rres=dbquery($rquery);
		  $rrow=mysqli_fetch_array($rres);
		}
		else
		{ $rquery = "SELECT SUM(reserved_quantity) AS reserved FROM "._DB_PREFIX_."stock_available";
		  $rquery .= " WHERE id_product='".$datarow['id_product']."' AND id_product_attribute !=0";
		  $rres=dbquery($rquery);
		  $rrow=mysqli_fetch_array($rres);
		}
        echo "<td>".$rrow['reserved']."</td>";	  
	  }
	  else if ($infofields[$i][0] == "revenue")
      { echo "<td><a href onclick='return salesdetails(".$datarow['id_product'].")' title='show salesdetails'>".$datarow['revenue']."</a></td>";
      }	  	/* end of revenue */
	  else if ($infofields[$i][0] == "state")
	  { echo "<td>";
		if($datarow["state"] == "0") echo "STATE_TEMP";
		else if($datarow["state"] == "1") echo "STATE_SAVED";
		else echo "INVALID";
		echo "</td>";
	  }
	  else if ($infofields[$i][0] == "shopz")
      { echo "<td>";
		$squery = "select s.active, s.id_shop from "._DB_PREFIX_."product_shop ps";
		$squery .= " LEFT JOIN "._DB_PREFIX_."shop s ON ps.id_shop=s.id_shop";
		$squery .= " WHERE id_product='".$datarow['id_product']."'";
		$sres = dbquery($squery);
		$prodshops = "";
		while($srow = mysqli_fetch_assoc($sres))
		{ if($srow["active"] == "1")
			$prodshops .= $srow["id_shop"].",";
		  else
			$prodshops .= "<i><del>".$srow["id_shop"]."</del></i>,";
		}
		$prodshops = rtrim($prodshops, ","); /* remove trailing comma */
		echo $prodshops."</td>";
      }	  	/* end of shops */
	  
	  else if ($infofields[$i][0] == "stockflags")
	  { echo "<td srt='".$myvalue."' haswarehouses=";
	    $depends_on_stock = $datarow['depends_on_stock'];
		$advanced_stock_management = $datarow['advanced_stock_management'];
		if(($advanced_stock_management == 0) || ($depends_on_stock == 0))
		{ $squery = "SELECT id_product_attribute FROM ". _DB_PREFIX_."stock s";
	      $squery .= " LEFT JOIN ". _DB_PREFIX_."warehouse_shop ws on ws.id_warehouse=s.id_warehouse";
	      $squery .= " LEFT JOIN ". _DB_PREFIX_."warehouse w on ws.id_warehouse=w.id_warehouse";	  
	      $squery .= " WHERE s.id_product = '".$datarow['id_product']."' AND ws.id_shop ='".$id_shop."' AND w.deleted=0";
		  $sres=dbquery($squery);
		  if(mysqli_num_rows($sres) > 0)
			 echo '1';
		  else echo '0';
		}
		else 
		  echo '0';
		echo " >";
		$squery = "SELECT * FROM ". _DB_PREFIX_."pack WHERE id_product_pack='".$datarow['id_product']."'";
		$sres=dbquery($squery);
		if(mysqli_num_rows($sres) != 0)
		  echo "For packs this field cannot be edited.<br>";
		if($advanced_stock_management == 0)
		  echo $stockflagsarray[0];  // "Manual"
		else if($depends_on_stock == 0)
		  echo $stockflagsarray[1];  // "Adv Stock Management"
		else
		  echo $stockflagsarray[2];  // "ASM with Warehousing"
	    /* now we need to set a flag whether the product already has stock in warehouses set */
	    echo "</td>";
	  }		/* end of stockflags */
	  else if ($infofields[$i][0] == "supplier")
      { $dquery = "SELECT id_supplier FROM ". _DB_PREFIX_."product WHERE id_product='".$datarow['id_product']."'";
		$dres=dbquery($dquery);
		$drow=mysqli_fetch_array($dres);
		$default_supplier = $drow["id_supplier"];
  
        $squery = "SELECT DISTINCT(ps.id_supplier) FROM ". _DB_PREFIX_."product_supplier ps";
	    $squery .= " LEFT JOIN ". _DB_PREFIX_."supplier s on s.id_supplier=ps.id_supplier";
		$squery .= " WHERE id_product='".$datarow['id_product']."'";
		$squery .= " ORDER BY s.name";
		$sres=dbquery($squery);
	    $sups = array();
		while ($srow=mysqli_fetch_array($sres))
		    $sups[] = $srow["id_supplier"];

$attrs = array();	
	/*  Prestashop makes ps_product_supplier entries in two steps. In the first step you only assign
	 *	the supplier. The reference field will then stay empty and the price and id_currency fields will 
	 *	become zero. Only in the second step a currency is assigned. 
	*/
		if($combination_count == 0)
		{ echo '<td sups="'.implode(",",$sups).'" attrs="0" def_supplier='.$default_supplier.'>';
		  echo '<table border=1 class="supplier" id="suppliers0s'.$x.'" title="">';
		  $squery = "SELECT ps.id_product_supplier,s.id_supplier,ps.id_product_attribute,product_supplier_reference AS reference,product_supplier_price_te AS supprice,c.id_currency,c.iso_code";
		  $squery .= " FROM ". _DB_PREFIX_."product_supplier ps";
		  $squery .= " LEFT JOIN ". _DB_PREFIX_."supplier s on s.id_supplier=ps.id_supplier";
		  $squery .= " LEFT JOIN ". _DB_PREFIX_."currency c on c.id_currency=ps.id_currency";		  
		  $squery .= " WHERE id_product='".$datarow['id_product']."' AND (ps.id_supplier != 0) ORDER BY s.name";
		  $sres=dbquery($squery);
		  $rowcount = mysqli_num_rows($sres);
		  $xx=0;
		  while ($srow=mysqli_fetch_array($sres))
		  { echo "<tr title='".$srow["id_supplier"]."'>";
			if($srow['id_supplier'] == $default_supplier)
				echo "<td class='defcat'>".$supplier_names[$srow['id_supplier']]."</td>";
			else
				echo "<td >".$supplier_names[$srow['id_supplier']]."</td>";		
			echo "<td>".$srow['reference']."</td><td>".$srow['supprice']."</td>";
			if($srow['iso_code'] != "")
			  echo "<td >".$srow['iso_code']."</td>";
			else
			  echo "<td >".$def_currency."</td>";
			if($xx++ == 0) echo '<td rowspan="'.$rowcount.'"></td>';
			echo "</tr>";
		  }
		  echo "</table>";
		  mysqli_free_result($sres);
		}		
		else
		{ $aquery = "SELECT id_product_attribute FROM ". _DB_PREFIX_."product_attribute WHERE id_product='".$datarow['id_product']."'";
		  $ares=dbquery($aquery);
		  while ($arow=mysqli_fetch_array($ares))
		    $attrs[] = $arow["id_product_attribute"];
		  echo '<td sups="'.implode(",",$sups).'" attrs="'.implode(",",$attrs).'" def_supplier='.$default_supplier.'>';
		  
		  $paquery = "SELECT pa.id_product_attribute, GROUP_CONCAT(CONCAT(gl.name,': ',l.name)) AS nameblock";
		  $paquery .= " FROM ". _DB_PREFIX_."product_attribute pa";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."product_attribute_combination c on pa.id_product_attribute=c.id_product_attribute";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute a on a.id_attribute=c.id_attribute";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute_lang l on l.id_attribute=c.id_attribute AND l.id_lang='".$id_lang."'";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute_group_lang gl on gl.id_attribute_group=a.id_attribute_group AND gl.id_lang='".$id_lang."'";
		  $paquery .= " WHERE pa.id_product='".$datarow['id_product']."' GROUP BY pa.id_product_attribute ORDER BY pa.id_product_attribute";
		  $pares=dbquery($paquery);
		  
		  while ($parow=mysqli_fetch_array($pares))
		  { echo '<table border=1 class="supplier" id="suppliers'.$parow['id_product_attribute'].'s'.$x.'" title="'.$parow["nameblock"].'">';
			$suppls = array();
			$squery = "SELECT ps.id_product_supplier,ps.id_supplier,s.name as suppliername, ps.id_product_attribute,product_supplier_reference AS reference,product_supplier_price_te AS supprice,c.id_currency,c.iso_code";
			$squery .= " FROM ". _DB_PREFIX_."product_supplier ps";
			$squery .= " LEFT JOIN ". _DB_PREFIX_."supplier s on s.id_supplier=ps.id_supplier";
			$squery .= " LEFT JOIN ". _DB_PREFIX_."currency c on c.id_currency=ps.id_currency";		  
			$squery .= " WHERE ps.id_product_attribute='".$parow['id_product_attribute']."' AND (ps.id_supplier != 0) ORDER BY suppliername";
		    $sres=dbquery($squery);
			while ($srow=mysqli_fetch_array($sres))
			{ $suppls[$srow["id_supplier"]] = array($srow["id_product_supplier"],$srow['reference'], $srow['supprice'], $srow['iso_code']);
			}
			$xx = 0;
			foreach($sups AS $sup)
			{ if(isset($suppls[$sup]))
			  { echo "<tr title='".$sup."'>";
				if($sup == $default_supplier)
					echo '<td class="defcat">'.$supplier_names[$sup].'</td>';
				else
					echo "<td >".$supplier_names[$sup]."</td>";
				echo  "<td>".$suppls[$sup][1]."</td><td>".$suppls[$sup][2]."</td>";
				if($suppls[$sup][3] != "")
				  echo "<td >".$suppls[$sup][3]."</td>";
			    else
				  echo "<td >".$def_currency."</td>";
			  }
			  else 		/* this is the situation initially: when the supplier has just been added for the product */
			  { echo "<tr title='".$sup."'>"; 
				if($sup == $default_supplier)
					echo '<td class="defcat">'.$supplier_names[$sup].'</td>';
				else
					echo "<td >".$supplier_names[$sup]."</td>";
				echo "<td></td><td>0.000000</td><td>".$def_currency."</td>";
			  }
			  if($xx++ == 0)
			    echo '<td rowspan="'.sizeof($sups).'">'.$parow["nameblock"].'</td>';
			  echo "</tr>";
			}
		    echo "</table>";
		  }
		  mysqli_free_result($sres);
		  mysqli_free_result($pares);
		}
		echo "</td>";
      }		/* end of supplier */
	  
	  else if ($infofields[$i][0] == "tags")
      { $tquery = "SELECT pt.id_tag,name FROM ". _DB_PREFIX_."product_tag pt";
		$tquery .= " LEFT JOIN ". _DB_PREFIX_."tag t ON pt.id_tag=t.id_tag AND t.id_lang='".$id_lang."'";
	    $tquery .= " WHERE pt.id_product='".$datarow['id_product']."'";
		$tres=dbquery($tquery);
		$idx = 0;
		echo "<td>";
		while ($trow=mysqli_fetch_array($tres)) 
		{ if($idx++ > 0) echo "<br/>";
		  echo "<nobr>".$trow["name"]."</nobr>";
		}
		echo "</td>";
		mysqli_free_result($tres);
      }	  /* end of tags */
	  
	  else if ($infofields[$i][0] == "unitPrice")
	  { if($datarow["unit_price_ratio"] == 0)
		  echo "<td>0.000000</td>";
	    else
		  echo "<td>".round($datarow["price"]/$datarow["unit_price_ratio"],6)."</td>";
	  }		/* end of unitPrice */
	  
      else if ($infofields[$i][0] == "VAT")
      { $sorttxt = "idx='".$datarow['id_tax_rules_group']."'";
		echo "<td ".$sorttxt.">".floatval($taxrates[$datarow['id_tax_rules_group']])."</td>";
      }		/* end of VAT */
	  
	  else if ($infofields[$i][0] == "virtualp")	  
	  {	$bgcolor = $visvirtual= $visfile = '';
  		if($combination_count != 0)
			$bgcolor = 'style="background-color:#FF8888"';
	    if($datarow['is_virtual'] == 0)
		  $visvirtual = ' style="display:none;"';
	    if($datarow['filename'] == "")
		  $visfile = ' style="display:none;"';
		echo "<td ".$bgcolor."><table><tr><td>On</td><td".$visvirtual.">File</td><td style='display:none'>Name</td><td"
		.$visfile.">exp_date</td><td".$visfile.">nb_days</td><td".$visfile.">nb_downloads</td><td".$visfile.">active</td></tr>";
		echo "<tr><td>".$datarow['is_virtual']."</td><td".$visvirtual.">";
		if($datarow['filename'] != "") 
	    { if(!file_exists($download_dir."/".$datarow["filename"])) echo " <b>file missing</b>";
		  echo "<a class='attachlink' title='".$datarow['display_filename']."' href='downfile.php?filename=".$datarow["display_filename"]."&mode=virtualproduct&frag=".crc32($datarow['filename'])."' target='_blank'>".$datarow['display_filename']."</a>";
		}
		echo "</td><td style='display:none'>".$datarow["display_filename"];
		echo "</td><td".$visfile.">".$datarow["date_expiration"];
		echo "</td><td".$visfile.">".$datarow["nb_days_accessible"];
		echo "</td><td".$visfile.">".$datarow["nb_downloadable"];
		echo "</td><td".$visfile.">".$datarow["dl_active"];
		echo "</td></tr></table></td>";	  
	  }		/* end of virtualp */
	  else if ($infofields[$i][0] == "warehousing")
	  { echo "<td>";
	    if($combination_count == 0)
		{ echo "<table>";
		  $wquery = "SELECT w.id_warehouse, w.name AS whname, physical_quantity, usable_quantity, price_te, location";
		  $wquery .= " FROM ". _DB_PREFIX_."warehouse w";
	      $wquery .= " LEFT JOIN ". _DB_PREFIX_."stock st on w.id_warehouse=st.id_warehouse AND st.id_product='".$datarow['id_product']."'";
	      $wquery .= " LEFT JOIN ". _DB_PREFIX_."warehouse_product_location wpl on w.id_warehouse=wpl.id_warehouse AND wpl.id_product='".$datarow['id_product']."'";		  
		  $wquery .= " WHERE st.id_warehouse IS NOT NULL OR wpl.id_warehouse IS NOT NULL";
		  $wquery .= " ORDER BY w.name";
		  $wres=dbquery($wquery);
		  while ($wrow=mysqli_fetch_array($wres))
		  { echo "<tr><td>".$wrow["whname"]."</td><td>".$wrow["location"]."</td>";
			echo "<td>".$wrow["physical_quantity"]."</td><td>".$wrow["usable_quantity"]."</td>";
			if($wrow["price_te"] == "")
			  echo "<td></td>";
			else
			  echo "<td>".number_format($wrow["price_te"],2)."</td>";
			echo "</tr>";
		  }
		  echo "</table>";
		}
		else
		{ $aquery = "SELECT id_product_attribute FROM ". _DB_PREFIX_."product_attribute WHERE id_product='".$datarow['id_product']."'";
		  $ares=dbquery($aquery);
		  while ($arow=mysqli_fetch_array($ares))
		    $attrs[] = $arow["id_product_attribute"];
		  
		  $paquery = "SELECT pa.id_product_attribute, GROUP_CONCAT(CONCAT(gl.name,': ',l.name)) AS nameblock from ". _DB_PREFIX_."product_attribute pa";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."product_attribute_combination c on pa.id_product_attribute=c.id_product_attribute";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute a on a.id_attribute=c.id_attribute";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute_lang l on l.id_attribute=c.id_attribute AND l.id_lang='".$id_lang."'";
		  $paquery .= " LEFT JOIN ". _DB_PREFIX_."attribute_group_lang gl on gl.id_attribute_group=a.id_attribute_group AND gl.id_lang='".$id_lang."'";
		  $paquery .= " WHERE pa.id_product='".$datarow['id_product']."' GROUP BY pa.id_product_attribute ORDER BY pa.id_product_attribute";
		  $pares=dbquery($paquery);
		  
		  while ($parow=mysqli_fetch_array($pares))
		  { echo '<table border=1  title="'.$parow["nameblock"].'">';
		    $wquery = "SELECT w.id_warehouse, w.name AS whname, physical_quantity, usable_quantity, price_te, location";
		    $wquery .= " FROM ". _DB_PREFIX_."warehouse w";
	        $wquery .= " LEFT JOIN ". _DB_PREFIX_."stock st on w.id_warehouse=st.id_warehouse AND st.id_product='".$datarow['id_product']."' AND st.id_product_attribute='".$parow['id_product_attribute']."'";
	        $wquery .= " LEFT JOIN ". _DB_PREFIX_."warehouse_product_location wpl on w.id_warehouse=wpl.id_warehouse AND wpl.id_product='".$datarow['id_product']."' AND wpl.id_product_attribute='".$parow['id_product_attribute']."'";		  
		    $wquery .= " WHERE st.id_warehouse IS NOT NULL OR wpl.id_warehouse IS NOT NULL";
		    $wquery .= " ORDER BY w.name";
			$wres=dbquery($wquery);
			$size = mysqli_num_rows($wres);
			
			$xx = 0;
			while ($wrow=mysqli_fetch_array($wres))
			{ echo "<tr><td>".$wrow["whname"]."</td><td>".$wrow["location"]."</td>";
			  echo "<td>".$wrow["physical_quantity"]."</td><td>".$wrow["usable_quantity"]."</td>";
			  if($wrow["price_te"] == "")
				echo "<td></td>";
			  else
				echo "<td>".number_format($wrow["price_te"],2)."</td>";
			  if($xx++ == 0)
			    echo '<td rowspan="'.$size.'">'.$parow["nameblock"].'</td>';
			  echo "</tr>";
			}
		    echo "</table>";
		  }
		  mysqli_free_result($wres);
		  mysqli_free_result($pares);
		}
		echo "</td>";
	  }		/* end of warehousing */

else if($infofields[$i][6] == 1)
      { $sorttxt = "srt='".str_replace("'", "\'",$myvalue)."'";
        echo "<td ".$sorttxt.">".$myvalue."</td>";
      }
      else
         echo "<td>".$myvalue."</td>";
	 
	  if(in_array($infofields[$i][0], $statfields))
	    $stattotals[$infofields[$i][0]] += $myvalue;
    }

foreach($featurelist AS $key => $feature)
    {
	  $fquery = "SELECT fv.custom,fl.value, fp.id_feature_value FROM ". _DB_PREFIX_."feature_product fp";
	  $fquery.=" LEFT JOIN ". _DB_PREFIX_."feature_value fv ON fp.id_feature_value=fv.id_feature_value";
	  $fquery.=" LEFT JOIN ". _DB_PREFIX_."feature_value_lang fl ON fp.id_feature_value=fl.id_feature_value AND fl.id_lang='".$id_lang."'";
	  $fquery.=" WHERE fp.id_product='".$datarow['id_product']."' AND fv.id_feature='".$key."'";
	  $fres=dbquery($fquery);
	  echo "<td>";
	  $first = true;
	  while ($frow=mysqli_fetch_array($fres))
	  { if($first) $first = false; else echo "<br>";
	    if(version_compare(_PS_VERSION_ , "1.7.3", "<"))
		{ if($frow['custom'] == "0")
	  	    echo "<b>".$frow['value']."</b>";
		  else // custom = 1
	  	    echo $frow['value'];
		}
	    else
		{ if($frow['custom'] == "0")
	        echo '<b title="'.$frow['id_feature_value'].'">'.$frow['value'].'</b>';
		  else // custom = 1
	  	    echo '<span title="'.$frow['id_feature_value'].'">'.$frow['value']."</span>";
		}
	  }
	  echo "</td>";
	}

echo '<td><img src="enter.png" title="submit row '.$x.'" onclick="RowSubmit(this)"></td>';
	$x++;
    echo '</tr
>'; 
  }
  
  if(sizeof($invalidtaxgroupproducts) > 0)
  { $str = "<br><b>The following products have an invalid tax group assigned: ";
	$str .= implode(", ", $invalidtaxgroupproducts)."</b><p/>";
	echo $str;
	$str = strip_tags($str);
	echo "<script>alert('".$str."');</script>";
  }
  if(mysqli_num_rows($res) == 0)
	echo "<strong>products not found</strong>";
  echo '</table></form></div>';
  
  if($zerostatefound)
    echo '<script>var zerostatewarning="Products with state-field 0(=STATE_TEMP) are marked with a red background and are not shown in the shop<br>";</script>';
  
  echo "<script>function showtotals() {";
  foreach($statfields AS $statfield)
	{ if(in_array($statfield, $input["fields"]))
	   echo "var id = document.getElementById('stat_".$statfield."');
	   id.title = 'Page total=".$stattotals[$statfield]."'; ";
	}
  echo "}";
//  if($haserrors)
//	  echo ' alert("Your shop database has errors. Run Integrity Checks (under Tools&Stats) or try to repair them in another way!");';
  echo "</script>";
  
  if(!$imgonly && $statsfound)
  { echo '<table class=triplemain><td colspan=2 style="text-align:center">Totals</td>';
    for($i=0; $i< sizeof($infofields); $i++)
	{ if (in_array($infofields[$i][0], $statfields))
	    echo '<tr><td>'.$infofields[$i][0].'</td><td>'.$stattotals[$infofields[$i][0]].'</td></tr>';
	}
	echo '</table>';
  }
  
  echo '<form style="clear:left"><input id="gatherer"><input type=button value="gather product id\'s" onclick="gather_prod_ids(); return false"></form>';
  
  echo '<div style="display:block;">';
  if(isset($avoid_iframes) && $avoid_iframes)
    echo '<form name=rowform action="product-proc.php" method=post target=_blank>';
  else
    echo '<form name=rowform action="product-proc.php" method=post target=tank>';
  echo '<table id=subtable></table>';
  echo '<input type=hidden name=extralangfields value="'.implode(",",$extralangfields).'">';
  echo '<input type=hidden name=extralangcodes value="'.implode(",",$extralangcodes).'">';
  echo '<input type=hidden name=submittedrow><input type=hidden name=id_lang value="'.$id_lang.'">';
  echo '<input type=hidden name=allshops><input type=hidden name=reccount value="1">';
  echo '<input type=hidden name=id_shop value="'.$id_shop.'"><input type=hidden name=verbose><input type=hidden name=skipindexation>';
  echo '<input type=hidden name=featuresset></form></div>';

include "footer1.php";
  echo '</body></html>';

$product_list = array();
function get_product_name($id)
{ global $product_list,$id_lang;
  if(isset($product_list[$id]))
    return $product_list[$id];
  $query = "select name from ". _DB_PREFIX_."product_lang WHERE id_product='".$id."' AND id_lang='".$id_lang."'";
  $res = dbquery($query);
  if(mysqli_num_rows($res) == 0)
	  return "Unknown ".$id;
  $row=mysqli_fetch_array($res);
  $product_list[$id] = $row["name"];
  return $row["name"];
}