$val) {
if ($key=="ok") continue;
if ($key=="alle") continue;
$sql="update products set products_status=0 where products_model='$key'";
//echo "$key $sql";
echo "$key ";
if (query("shop",$sql,"diff")) { echo "deaktiviert
"; }
else { echo "konnte nicht deaktiviert werden
"; };
}
} else {
$sql="select partnumber from parts where shop='1' order by partnumber";
$erp=getAll("erp",$sql,"getPartnumber");
if ($SHOPlang>0) {
$defLang=$SHOPlang;
} else {
$sql="select * from languages L left join configuration C on L.code=C.configuration_value where configuration_key = 'DEFAULT_LANGUAGE'";
$rs=getAll("shop",$sql,"getLanguage");
if ($rs) {
$defLang=$rs[0]["languages_id"];
} else {
$defLang=1;
}
}
if ($erp) foreach ($erp as $zeile) { $arE[]=$zeile["partnumber"]; };
$sql="select products_model,P.products_id,products_name from products P left join products_description D on P.products_id=D.products_id where language_id=$defLang and products_status=1 order by products_model";
$shop=getAll("shop",$sql,"products_model");
if ($shop) foreach ($shop as $zeile) {
$arS[]=$zeile["products_model"];
$arID[$zeile["products_model"]]=array("id"=>$zeile["products_id"],"name"=>$zeile["products_name"]);
}
$result=@array_diff($arS,$arE);
if ($result) {
?>
Artikelpflege
Folgende Artikel sind in der ERP nicht mehr als Shopartikel markiert.
Markieren Sie die Artikel, die deaktiviert werden sollen.