X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d7def35ae83a608fe6a745361fa5234863b15b6f..6824628e8e4d949b8b1d72ebdfd0cdb459fde537:/olcom/diff.php
diff --git a/olcom/diff.php b/olcom/diff.php
new file mode 100644
index 000000000..3e2ac7b6a
--- /dev/null
+++ b/olcom/diff.php
@@ -0,0 +1,87 @@
+"") { define("PREFIX",$dbprefix."_"); } else { define("PREFIX",""); }
+
+if (!$db) {
+ $db=DB::connect($SHOPdns);
+ if (!$db) dbFehler("",$db->getDebugInfo());
+ if (DB::isError($db)) {
+ dbFehler("",$db->getDebugInfo());
+ die ($db->getDebugInfo());
+ };
+ $db2=DB::connect($ERPdns);
+ if (!$db2) dbFehler("",$db2->getDebugInfo());
+ if (DB::isError($db2)) {
+ dbFehler("",$db2->getDebugInfo());
+ die ($db2->getDebugInfo());
+ };
+}
+if ($_POST["ok"]) {
+ foreach($_POST as $key=>$val) {
+ if ($key=="ok") continue;
+ if ($key=="alle") continue;
+ $sql="update ".PREFIX."products set products_status=0 where products_model=$key";
+ echo "$key ";
+ if ($db->query($sql)) { echo "deaktiviert
"; }
+ else { echo "konnte nicht deaktiviert werden
"; };
+ }
+} else {
+$sql="select partnumber from parts where shop='1' order by partnumber";
+$erp=$db2->getAll($sql,DB_FETCHMODE_ASSOC);
+if ($erp) foreach ($erp as $zeile) { $arE[]=$zeile["partnumber"]; };
+
+if ($SHOPlang>0) {
+ $defLang=$SHOPlang;
+} else {
+ $sql="select * from ".PREFIX."languages L left join ".PREFIX."configuration C on L.code=C.configuration_value where configuration_key = 'DEFAULT_LANGUAGE'";
+ $rs=$db->getAll($sql,DB_FETCHMODE_ASSOC);
+ if ($rs) {
+ $defLang=$rs[0]["languages_id"];
+ } else {
+ $defLang=1;
+ }
+}
+
+$sql="select products_model,P.products_id,products_name from ".PREFIX."products P left join ".PREFIX."products_description D on P.products_id=D.products_id where language_id=$defLang and products_status=1 order by products_model";
+$shop=$db->getAll($sql,DB_FETCHMODE_ASSOC);
+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.
+