2 if (!isset($_SERVER['PHP_AUTH_USER'])) {
3 Header("WWW-Authenticate: Basic realm=\"Configurations-Editor\"");
4 Header("HTTP/1.0 401 Unauthorized");
5 echo "Sie müssen sich autentifizieren\n";
8 $login=($_GET["login"])?$_GET["login"]:$_POST["login"];
9 if (file_exists ("conf$login.php")) {
10 require "conf$login.php";
14 if ($_SERVER['PHP_AUTH_USER']<>$ERPftpuser || $_SERVER['PHP_AUTH_PW']<>$ERPftppwd) {
15 Header("WWW-Authenticate: Basic realm=\"My Realm\"");
16 Header("HTTP/1.0 401 Unauthorized");
17 echo "Sie müssen sich autentifizieren\n";
20 require_once "DB.php";
23 echo "\t<option value=0";
24 if ($sel==0) echo " selected";
25 echo ">Standard VK\n";
26 $sql="select id,pricegroup from pricegroup";
28 $pgs=$dbP->getall($sql);
29 if ($pgs) foreach ($pgs as $row) {
30 echo "\t<option value=".$row[0];
31 if ($sel==$row[0]) echo " selected";
32 echo ">".$row[1]."\n";
35 function shoplang($sel,$default) {
38 $sql="SELECT L.*, C.configuration_value FROM languages L LEFT JOIN configuration C ";
39 $sql.="ON L.code = C.configuration_value";
40 $rs=$dbM->getAll($sql,DB_FETCHMODE_ASSOC);
42 echo "\t\t<option value='0'>keine Sprachen\n";
44 echo "\t\t<option value='0' ".(($sel==0)?"selected":"").">nicht verwenden\n";
45 foreach ($rs as $row) {
46 if ($default["id"]<>$row["languages_id"]) {
47 echo "\t\t<option value='".$row["languages_id"]."' ";
48 echo (($row["languages_id"]==$sel)?"selected":"").">";
49 echo ($row["code"]==$row["configuration_value"])?"!":" ";
50 echo $row["name"]."\n";
55 function erplang($sel) {
58 $sql="select * from language";
59 $rs=$dbP->getAll($sql,DB_FETCHMODE_ASSOC);
61 echo "\t\t<option>keine Sprachen\n";
63 //echo "\t\t<option value='0' ".(($sel==0)?"selected":"").">Standard\n";
64 foreach ($rs as $row) {
65 echo "\t\t<option value='".$row["id"]."' ";
66 echo ($sel==$row["id"])?"selected":"";
67 echo ">".$row["description"]."\n";
71 function getERPlangs() {
74 $sql="select * from language";
75 $rs=$dbP->getAll($sql,DB_FETCHMODE_ASSOC);
78 function getShopDefault() {
81 $sql="select * from languages L left join configuration C on L.code=C.configuration_value ";
82 $sql.="where configuration_key = 'DEFAULT_LANGUAGE'";
83 $rs=$dbM->getAll($sql,DB_FETCHMODE_ASSOC);
85 return array("id"=>$rs[0]["languages_id"],"name"=>$rs[0]["name"]);
91 if ($_POST["ok"]=="sichern") {
95 'username' => $_POST["ERPuser"],
96 'password' => $_POST["ERPpass"],
97 'hostspec' => $_POST["ERPhost"],
98 'database' => $_POST["ERPdbname"],
99 'port' => $_POST["ERPport"]
101 $dbP=@DB::connect($dsnP);
102 if (DB::isError($dbP)||!$dbP) {
104 echo "Keine Verbindung zur ERP<br>";
108 $sql="SELECT P.id,P.description,(t.rate * 100) as rate FROM ";
109 $sql.="parts P left join chart c on c.id=P.income_accno_id left join tax t on c.taxkey_id=t.taxkey ";
110 $sql.="where P.partnumber = '%s'";
111 $rs=$dbP->getall(sprintf($sql,$_POST["div16NR"]));
112 $_POST["div16ID"]=$rs[0][0];
113 $div16txt=addslashes($rs[0][1]);
114 $_POST["div16TAX"]=$rs[0][2];
115 $rs=$dbP->getall(sprintf($sql,$_POST["div07NR"]));
116 $_POST["div07ID"]=$rs[0][0];
117 $_POST["div07TAX"]=$rs[0][2];
118 $div07txt=addslashes($rs[0][1]);
119 $rs=$dbP->getall(sprintf($sql,$_POST["versandNR"]));
120 $_POST["versandID"]=$rs[0][0];
121 $_POST["versandTAX"]=$rs[0][2];
122 $versandtxt=addslashes($rs[0][1]);
123 $rs=$dbP->getall(sprintf($sql,$_POST["nachnNR"]));
124 $_POST["nachnID"]=$rs[0][0];
125 $_POST["nachnTAX"]=$rs[0][2];
126 $nachntxt=addslashes($rs[0][1]);
127 $rs=$dbP->getall(sprintf($sql,$_POST["minderNR"]));
128 $_POST["minderID"]=$rs[0][0];
129 $_POST["minderTAX"]=$rs[0][2];
130 $mindertxt=addslashes($rs[0][1]);
131 $rs=$dbP->getall(sprintf($sql,$_POST["paypalNR"]));
132 $_POST["paypalID"]=$rs[0][0];
133 $_POST["paypalTAX"]=$rs[0][2];
134 $paypaltxt=addslashes($rs[0][1]);
135 $rs=$dbP->getall("select id from employee where login = '".$_POST["ERPusrN"]."'");
136 $_POST["ERPusrID"]=$rs[0][0];
139 'phptype' => 'mysql',
140 'username' => $_POST["SHOPuser"],
141 'password' => $_POST["SHOPpass"],
142 'hostspec' => $_POST["SHOPhost"],
143 'database' => $_POST["SHOPdbname"],
144 'port' => $_POST["SHOPport"]
146 $dbM=@DB::connect($dsnM);
147 if (DB::isError($dbM)||!$dbM) {
149 echo "Keine Verbindung zum Shop<br>";
154 $ShopDefaultLang=getShopDefault();
155 $f=fopen("conf$login.php","w");
157 $d=date("Y/m/d H:i:s");
158 fputs($f,"<?\n// Verbindung zur ERP-db\n");
159 fputs($f,"\$ERPuser=\"".$_POST["ERPuser"]."\";\n");
160 fputs($f,"\$ERPpass=\"".$_POST["ERPpass"]."\";\n");
161 fputs($f,"\$ERPhost=\"".$_POST["ERPhost"]."\";\n");
162 fputs($f,"\$ERPport=\"".$_POST["ERPport"]."\";\n");
163 fputs($f,"\$ERPdbname=\"".$_POST["ERPdbname"]."\";\n");
164 fputs($f,"\$ERPusr[\"Name\"]=\"".$_POST["ERPusrN"]."\";\n");
165 fputs($f,"\$ERPusr[\"ID\"]=\"".$_POST["ERPusrID"]."\";\n");
166 fputs($f,"\$ERPdir=\"".$_POST["ERPdir"]."\";\n");
167 fputs($f,"\$ERPimgdir=\"".$_POST["ERPimgdir"]."\";\n");
168 fputs($f,"\$maxSize=\"".$_POST["maxSize"]."\";\n");
169 fputs($f,"\$ERPftphost=\"".$_POST["ERPftphost"]."\";\n");
170 fputs($f,"\$ERPftpuser=\"".$_POST["ERPftpuser"]."\";\n");
171 fputs($f,"\$ERPftppwd=\"".$_POST["ERPftppwd"]."\";\n");
172 fputs($f,"//Verbindung zur osCommerce-db\n");
173 fputs($f,"\$SHOPuser=\"".$_POST["SHOPuser"]."\";\n");
174 fputs($f,"\$SHOPpass=\"".$_POST["SHOPpass"]."\";\n");
175 fputs($f,"\$SHOPhost=\"".$_POST["SHOPhost"]."\";\n");
176 fputs($f,"\$SHOPport=\"".$_POST["SHOPport"]."\";\n");
177 fputs($f,"\$SHOPdbname=\"".$_POST["SHOPdbname"]."\";\n");
178 fputs($f,"\$SHOPdns=\"mysql://\$SHOPuser:\$SHOPpass@\$SHOPhost/\$SHOPdbname\";\n");
179 fputs($f,"\$SHOPdir=\"".$_POST["SHOPdir"]."\";\n");
180 fputs($f,"\$SHOPimgdir=\"".$_POST["SHOPimgdir"]."\";\n");
181 fputs($f,"\$SHOPftphost=\"".$_POST["SHOPftphost"]."\";\n");
182 fputs($f,"\$SHOPftpuser=\"".$_POST["SHOPftpuser"]."\";\n");
183 fputs($f,"\$SHOPftppwd=\"".$_POST["SHOPftppwd"]."\";\n");
184 fputs($f,"\$div16[\"ID\"]=\"".$_POST["div16ID"]."\";\n");
185 fputs($f,"\$div07[\"ID\"]=\"".$_POST["div07ID"]."\";\n");
186 fputs($f,"\$versand[\"ID\"]=\"".$_POST["versandID"]."\";\n");
187 fputs($f,"\$nachn[\"ID\"]=\"".$_POST["nachnID"]."\";\n");
188 fputs($f,"\$minder[\"ID\"]=\"".$_POST["minderID"]."\";\n");
189 fputs($f,"\$paypal[\"ID\"]=\"".$_POST["paypalID"]."\";\n");
190 fputs($f,"\$div16[\"NR\"]=\"".$_POST["div16NR"]."\";\n");
191 fputs($f,"\$div07[\"NR\"]=\"".$_POST["div07NR"]."\";\n");
192 fputs($f,"\$versand[\"NR\"]=\"".$_POST["versandNR"]."\";\n");
193 fputs($f,"\$nachn[\"NR\"]=\"".$_POST["nachnNR"]."\";\n");
194 fputs($f,"\$minder[\"NR\"]=\"".$_POST["minderNR"]."\";\n");
195 fputs($f,"\$paypal[\"NR\"]=\"".$_POST["paypalNR"]."\";\n");
196 fputs($f,"\$div16[\"TAX\"]=\"".$_POST["div16TAX"]."\";\n");
197 fputs($f,"\$div07[\"TAX\"]=\"".$_POST["div07TAX"]."\";\n");
198 fputs($f,"\$versand[\"TAX\"]=\"".$_POST["versandTAX"]."\";\n");
199 fputs($f,"\$nachn[\"TAX\"]=\"".$_POST["nachnTAX"]."\";\n");
200 fputs($f,"\$minder[\"TAX\"]=\"".$_POST["minderTAX"]."\";\n");
201 fputs($f,"\$paypal[\"TAX\"]=\"".$_POST["paypalTAX"]."\";\n");
202 fputs($f,"\$div16[\"TXT\"]=\"".$div16txt."\";\n");
203 fputs($f,"\$div07[\"TXT\"]=\"".$div07txt."\";\n");
204 fputs($f,"\$versand[\"TXT\"]=\"".$versandtxt."\";\n");
205 fputs($f,"\$nachn[\"TXT\"]=\"".$nachntxt."\";\n");
206 fputs($f,"\$minder[\"TXT\"]=\"".$mindertxt."\";\n");
207 fputs($f,"\$paypal[\"TXT\"]=\"".$paypaltxt."\";\n");
208 fputs($f,"\$bgcol[1]=\"#ddddff\";\n");
209 fputs($f,"\$bgcol[2]=\"#ddffdd\";\n");
210 fputs($f,"\$preA=\"".$_POST["preA"]."\";\n");
211 fputs($f,"\$preK=\"".$_POST["preK"]."\";\n");
212 fputs($f,"\$auftrnr=\"".$_POST["auftrnr"]."\";\n");
213 fputs($f,"\$debug=".$_POST["debug"].";\n");
214 fputs($f,"\$kdnum=\"".$_POST["kdnum"]."\";\n");
215 fputs($f,"\$stdprice=\"".$_POST["stdprice"]."\";\n");
216 fputs($f,"\$altprice=\"".$_POST["altprice"]."\";\n");
217 fputs($f,"\$KDGrp=\"".$_POST["KDGrp"]."\";\n");
218 fputs($f,"\$nopic=\"".$_POST["nopic"]."\";\n");
219 fputs($f,"\$showErr=\"true\";\n");
221 $DefaultLangOk=false;
222 if ($_POST["ERPlang"]) foreach ($_POST["ERPlang"] as $key=>$val) {
223 if ($_POST["SHOPlang"][$key]==$ShopDefaultLang["id"]) $DefaultLangOk=true;
224 if ($_POST["SHOPlang"][$key])
225 fputs($f,"\$Language[$key]=array(\"ERP\"=>$val,\"SHOP\"=>".$_POST["SHOPlang"][$key].");\n");
227 if (!$DefaultLangOk) {
228 fputs($f,"\$SHOPdbname=\"\";\n");
229 echo "Es wurde keine ERP-Sprache der Shopdefaultsprache zugewiesen.";
230 echo "Verbindung zum Shop abgebrochen<br>";
232 fputs($f,"\$SHOPdefaultlang=\"".$ShopDefaultLang["id"]."\";\n");
233 fputs($f,"\$SpracheAlle=\"".$_POST["SpracheAlle"]."\";\n");
236 if (file_exists ("conf$login.php")) {
237 require "conf$login.php";
241 $sql="select count(*) from customers_number";
242 $rc=@$dbM->query($sql);
243 if ($rc->code==-18) {
244 $sql="CREATE TABLE customers_number ( cid int(6) NOT NULL auto_increment, customers_id int(3) NOT NULL default '0', ";
245 $sql.="kdnr int(3) NOT NULL default '0', shipto int , PRIMARY KEY (cid)) TYPE=MyISAM";
246 $rc=@$dbM->query($sql);
248 echo "Fehler beim Erzeugen der Tabelle 'customers_number' in der Shop-db";
250 echo "Tabelle 'customers_number' in der Shop-db angelegt.";
253 $sql="select shipto from customers_number limit 1";
254 $rc=@$dbM->query($sql);
255 if ($rc->code==-19) {
256 $sql="alter table customers_number add column shipto int";
257 $rc=@$dbM->query($sql);
259 echo "Fehler beim Anlegen der Spalte 'shipto' in 'customers_number'";
261 echo "'shipto' in 'customers_number' angelegt.";
266 $ERPuser=$_POST["ERPuser"];
267 $ERPpass=$_POST["ERPpass"];
268 $ERPhost=$_POST["ERPhost"];
269 $ERPport=$_POST["ERPport"];
270 $ERPdbname=$_POST["ERPdbname"];
271 $ERPusrN=$_POST["ERPusrN"];
272 $ERPdir=$_POST["ERPdir"];
273 $ERPimgdir=$_POST["ERPimgdir"];
274 $maxSize=$_POST["maxSize"];
275 $ERPftphost=$_POST["ERPftphost"];
276 $ERPftpuser=$_POST["ERPftpuser"];
277 $ERPftppwd=$_POST["ERPftppwd"];
278 $SHOPuser=$_POST["SHOPuser"];
279 $SHOPpass=$_POST["SHOPpass"];
280 $SHOPhost=$_POST["SHOPhost"];
281 $SHOPport=$_POST["SHOPport"];
282 $SHOPdbname=$_POST["SHOPdbname"];
283 $SHOPlang=$_POST["SHOPlang"];
284 $SHOPdir=$_POST["SHOPdir"];
285 $SHOPimgdir=$_POST["SHOPimgdir"];
286 $SHOPftphost=$_POST["SHOPftphost"];
287 $SHOPftpuser=$_POST["SHOPftpuser"];
288 $SHOPftppwd=$_POST["SHOPftppwd"];
289 $div16NR=$_POST["div16NR"];
290 $div07NR=$_POST["div07NR"];
291 $versandNR=$_POST["versandNR"];
292 $nachnNR=$_POST["nachnNR"];
293 $minderNR=$_POST["minderNR"];
294 $paypalNR=$_POST["paypalNR"];
295 $preA=$_POST["preA"];
296 $preK=$_POST["preK"];
297 $kdnum=$_POST["kdnum"];
298 $auftrnr=$_POST["auftrnr"];
299 $debug=$_POST["debug"];
300 $altprice=$_POST["altprice"];
301 $stdprice=$_POST["stdprice"];
302 $nopic=$_POST["nopic"];
304 $ERPlangs=getERPlangs();
305 $CntERPLang=count($ERPlangs); //$rs[0][0];
307 if (file_exists ("conf$login.php")) {
308 require "conf$login.php";
313 'phptype' => 'pgsql',
314 'username' => $ERPuser,
315 'password' => $ERPpass,
316 'hostspec' => $ERPhost,
317 'database' => $ERPdbname,
320 $dbP=@DB::connect($dsnP);
321 if (DB::isError($dbP)||!$dbP) {
322 echo "Keine Verbindung zur ERP<br>";
324 //echo $dbP->userinfo;
326 //$rs=$dbP->getAll("select count(*) from language");
327 $ERPlangs=getERPlangs();
328 $CntERPLang=count($ERPlangs); //$rs[0][0];
331 'phptype' => 'mysql',
332 'username' => $SHOPuser,
333 'password' => $SHOPpass,
334 'hostspec' => $SHOPhost,
335 'database' => $SHOPdbname,
338 $dbM=@DB::connect($dsnM);
339 if (DB::isError($dbM)||!$dbM) {
340 echo "Keine Verbindung zum SHOP<br>";
342 //echo $dbM->userinfo;
344 $ShopDefaultLang=getShopDefault();
351 <table style="background-color:#cccccc">
352 <form name="ConfEdit" method="post" action="confedit.php">
353 <input type="hidden" name="div16ID" value="<?= $div16["ID"] ?>">
354 <input type="hidden" name="div07ID" value="<?= $div07["ID"] ?>">
355 <input type="hidden" name="minderID" value="<?= $minder["ID"] ?>">
356 <input type="hidden" name="versandID" value="<?= $versand["ID"] ?>">
357 <input type="hidden" name="nachnID" value="<?= $nachn["ID"] ?>">
358 <input type="hidden" name="paypalID" value="<?= $paypal["ID"] ?>">
359 <input type="hidden" name="ERPusrID" value="<?= $ERPusr["ID"] ?>">
360 <input type="hidden" name="login" value="<?= $login ?>">
361 <tr><th>Daten</th><th>Lx-ERP</th><th></th><th>Shop</th></tr>
364 <td colspan="2"><input type="text" name="ERPhost" size="25" value="<?= $ERPhost ?>"></td>
365 <td><input type="text" name="SHOPhost" size="25" value="<?= $SHOPhost ?>"></td>
369 <td colspan="2"><input type="text" name="ERPport" size="25" value="<?= $ERPport ?>"></td>
370 <td><input type="text" name="SHOPport" size="25" value="<?= $SHOPport ?>"></td>
374 <td colspan="2"><input type="text" name="ERPdbname" size="20" value="<?= $ERPdbname ?>"></td>
375 <td><input type="text" name="SHOPdbname" size="20" value="<?= $SHOPdbname ?>"></td>
378 <td>db-User Name</td>
379 <td colspan="2"><input type="text" name="ERPuser" size="15" value="<?= $ERPuser ?>"></td>
380 <td><input type="text" name="SHOPuser" size="15" value="<?= $SHOPuser ?>"></td>
384 <td colspan="2"><input type="text" name="ERPpass" size="15" value="<?= $ERPpass ?>"></td>
385 <td><input type="text" name="SHOPpass" size="15" value="<?= $SHOPpass ?>"></td>
389 <td colspan="2"><input type="text" name="ERPusrN" size="10" value="<?= $ERPusr["Name"] ?>">
390 <input type="checkbox" name="a1" <?= (empty($ERPusr["ID"])?"":"checked") ?> onFocus="blur();"></td>
395 <td colspan="2"><input type="text" name="ERPdir" size="30" value="<?= $ERPdir ?>"></td>
396 <td><input type="text" name="SHOPdir" size="30" value="<?= $SHOPdir ?>"></td>
400 <td colspan="2"><input type="text" name="ERPimgdir" size="30" value="<?= $ERPimgdir ?>"></td>
401 <td><input type="text" name="SHOPimgdir" size="30" value="<?= $SHOPimgdir ?>"></td>
405 <td colspan="2"><input type="text" name="ERPftphost" size="20" value="<?= $ERPftphost ?>"></td>
406 <td><input type="text" name="SHOPftphost" size="20" value="<?= $SHOPftphost ?>"></td>
410 <td colspan="2"><input type="text" name="ERPftpuser" size="15" value="<?= $ERPftpuser ?>"></td>
411 <td><input type="text" name="SHOPftpuser" size="15" value="<?= $SHOPftpuser ?>"></td>
414 <td>FTP-User PWD</td>
415 <td colspan="2"><input type="text" name="ERPftppwd" size="15" value="<?= $ERPftppwd ?>"></td>
416 <td><input type="text" name="SHOPftppwd" size="15" value="<?= $SHOPftppwd ?>"></td>
419 <td>ID Diverse 16%</td>
420 <td><input type="text" name="div16NR" size="10" value="<?= $div16["NR"] ?>">
421 <input type="checkbox" name="a1" <?= (empty($div16["ID"])?"":"checked") ?>></td>
422 <td>ID Diverse 7%</td>
423 <td><input type="text" name="div07NR" size="10" value="<?= $div07["NR"] ?>">
424 <input type="checkbox" name="a1" <?= (empty($div07["ID"])?"":"checked") ?>></td>
428 <td><input type="text" name="versandNR" size="10" value="<?= $versand["NR"] ?>">
429 <input type="checkbox" name="a1" <?= (empty($versand["ID"])?"":"checked") ?>></td>
431 <td><input type="text" name="nachnNR" size="10" value="<?= $nachn["NR"] ?>">
432 <input type="checkbox" name="a1" <?= (empty($nachn["ID"])?"":"checked") ?>></td>
436 <td><input type="text" name="paypalNR" size="10" value="<?= $paypal["NR"] ?>">
437 <input type="checkbox" name="a1" <?= (empty($paypal["ID"])?"":"checked") ?>></td>
438 <td>ID Mindemenge</td>
439 <td><input type="text" name="minderNR" size="10" value="<?= $minder["NR"] ?>">
440 <input type="checkbox" name="a1" <?= (empty($minder["ID"])?"":"checked") ?>></td>
444 <td ><input type="hidden" name="ERPlang[0]" value="0">Standard</td>
446 <td ><input type="hidden" name="SHOPlang[0]" value="<?= $ShopDefaultLang["id"] ?>"><?= $ShopDefaultLang["name"] ?></td>
448 <? for($i=0; $i < $CntERPLang; $i++) { ?>
451 <td><input type="hidden" name="ERPlang[<?= $i+1 ?>]" value="<?= $ERPlangs[$i]["id"] ?>"><?= $ERPlangs[$i]["description"] ?>
453 <td ><select name="SHOPlang[<?= $i+1 ?>]">
454 <?= shoplang($Language[$i+1]["SHOP"],$ShopDefaultLang); ?>
459 <td colspan="2">Nur übersetzte Artikel</td>
460 <td><input type="radio" name="SpracheAlle" value="true" <?= ($SpracheAlle=="true")?"checked":"" ?>> Ja</td>
461 <td><input type="radio" name="SpracheAlle" value="false" <?= ($SpracheAlle<>"true")?"checked":"" ?>> Nein</td>
464 <td>Standardpreis</td>
465 <td><select name="stdprice">
469 <td><input type="text" name="nopic" size="20" value="<?= $nopic ?>">
471 <td>abweichender Preis</td>
472 <td><select name="altprice">
475 <td>Kundengruppe</td>
476 <td><input type="text" name="KDGrp" size="3" value="<?= $KDGrp ?>">
479 <td colspan="2">Auftragsnummern durch</td>
480 <td><input type="radio" name="auftrnr" value="1" <?= ($auftrnr==1)?"checked":"" ?>> LxO</td>
481 <td><input type="radio" name="auftrnr" value="0" <?= ($auftrnr<>1)?"checked":"" ?>> Shop</td>
484 <td colspan="2">Kundennummern durch</td>
485 <td><input type="radio" name="kdnum" value="1" <?= ($kdnum==1)?"checked":"" ?>> LxO</td>
486 <td><input type="radio" name="kdnum" value="0" <?= ($kdnum<>1)?"checked":"" ?>> Shop</td>
489 <td colspan="2">Nummernerweiterung</td>
490 <td>Auftrag<input type="text" name="preA" size="5" value="<?= $preA ?>"></td>
491 <td>Kunde<input type="text" name="preK" size="5" value="<?= $preK ?>"></td>
495 <td>ein<input type="radio" name="debug" value="true" <?= ($debug=="true")?"checked":"" ?>>
496 aus<input type="radio" name="debug" value="false" <?= ($debug!="true")?"checked":"" ?>></td>
499 <tr><td colspan="4" align="center"><input type="submit" name="ok" value="sichern"></td></tr>