2 // $Id: confedit.php,v 0.10 2006/02/06 11:34:30 hli Exp $
3 if (!isset($_SERVER['PHP_AUTH_USER'])) {
4 Header("WWW-Authenticate: Basic realm=\"Configurations-Editor\"");
5 Header("HTTP/1.0 401 Unauthorized");
6 echo "Sie müssen sich autentifizieren\n";
10 require_once "DB.php";
11 $db=@DB::connect($ERPdns);
12 if (!DB::isError($db)) {
13 $sql="select id,pricegroup from pricegroup";
14 $pgs=$db->getall($sql);
18 echo "\t<option value=0";
19 if ($sel==0) echo " selected";
20 echo ">Standard VK\n";
21 if ($pgs) foreach ($pgs as $row) {
22 echo "\t<option value=".$row[0];
23 if ($sel==$row[0]) echo " selected";
24 echo ">".$row[1]."\n";
27 if ($_SERVER['PHP_AUTH_USER']<>$ERPftpuser || $_SERVER['PHP_AUTH_PW']<>$ERPftppwd) {
28 Header("WWW-Authenticate: Basic realm=\"My Realm\"");
29 Header("HTTP/1.0 401 Unauthorized");
30 echo "Sie müssen sich autentifizieren\n";
33 if ($_POST["ok"]=="sichern") {
35 $dsnP="pgsql://".$_POST["ERPuser"].":".$_POST["ERPpass"]."@".$_POST["ERPhost"]."/".$_POST["ERPdbname"];
36 $dbP=DB::connect($dsnP);
37 if (DB::isError($dbP)||!$dbP) {
39 echo "Keine Verbindung zur ERP<br>";
43 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["div16NR"]."'");
44 $_POST["div16ID"]=$rs[0][0];
46 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["div07NR"]."'");
47 $_POST["div07ID"]=$rs[0][0];
49 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["versandNR"]."'");
50 $_POST["versandID"]=$rs[0][0];
51 $versandtxt=$rs[0][1];
52 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["nachnNR"]."'");
53 $_POST["nachnID"]=$rs[0][0];
55 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["minderNR"]."'");
56 $_POST["minderID"]=$rs[0][0];
58 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["paypalNR"]."'");
59 $_POST["paypalID"]=$rs[0][0];
61 $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["treuhNR"]."'");
62 $_POST["treuhID"]=$rs[0][0];
64 $rs=$dbP->getall("select id from employee where login = '".$_POST["ERPusrN"]."'");
65 $_POST["ERPusrID"]=$rs[0][0];
67 $dsnM="mysql://".$_POST["SHOPuser"].":".$_POST["SHOPpass"]."@".$_POST["SHOPhost"]."/".$_POST["SHOPdbname"];
68 $dbM=DB::connect($dsnM);
69 if (DB::isError($dbM)||!$dbM) {
71 echo "Keine Verbindung zum Shop<br>";
75 $f=fopen("conf.php","w");
77 $d=date("Y/m/d H:i:s");
78 fputs($f,"<?\n// Verbindung zur ERP-db\n");
79 fputs($f,"\$ERPuser=\"".$_POST["ERPuser"]."\";\n");
80 fputs($f,"\$ERPpass=\"".$_POST["ERPpass"]."\";\n");
81 fputs($f,"\$ERPhost=\"".$_POST["ERPhost"]."\";\n");
82 fputs($f,"\$ERPdbname=\"".$_POST["ERPdbname"]."\";\n");
83 fputs($f,"\$ERPdns=\"pgsql://\$ERPuser:\$ERPpass@\$ERPhost/\$ERPdbname\";\n");
84 fputs($f,"\$ERPusr[\"Name\"]=\"".$_POST["ERPusrN"]."\";\n");
85 fputs($f,"\$ERPusr[\"ID\"]=\"".$_POST["ERPusrID"]."\";\n");
86 fputs($f,"\$ERPdir=\"".$_POST["ERPdir"]."\";\n");
87 fputs($f,"\$ERPimgdir=\"".$_POST["ERPimgdir"]."\";\n");
88 fputs($f,"\$maxSize=\"".$_POST["maxSize"]."\";\n");
89 fputs($f,"\$ERPftphost=\"".$_POST["ERPftphost"]."\";\n");
90 fputs($f,"\$ERPftpuser=\"".$_POST["ERPftpuser"]."\";\n");
91 fputs($f,"\$ERPftppwd=\"".$_POST["ERPftppwd"]."\";\n");
92 fputs($f,"//Verbindung zur osCommerce-db\n");
93 fputs($f,"\$SHOPuser=\"".$_POST["SHOPuser"]."\";\n");
94 fputs($f,"\$SHOPpass=\"".$_POST["SHOPpass"]."\";\n");
95 fputs($f,"\$SHOPhost=\"".$_POST["SHOPhost"]."\";\n");
96 fputs($f,"\$SHOPdbname=\"".$_POST["SHOPdbname"]."\";\n");
97 fputs($f,"\$SHOPdns=\"mysql://\$SHOPuser:\$SHOPpass@\$SHOPhost/\$SHOPdbname\";\n");
98 fputs($f,"\$SHOPdir=\"".$_POST["SHOPdir"]."\";\n");
99 fputs($f,"\$SHOPimgdir=\"".$_POST["SHOPimgdir"]."\";\n");
100 fputs($f,"\$SHOPftphost=\"".$_POST["SHOPftphost"]."\";\n");
101 fputs($f,"\$SHOPftpuser=\"".$_POST["SHOPftpuser"]."\";\n");
102 fputs($f,"\$SHOPftppwd=\"".$_POST["SHOPftppwd"]."\";\n");
103 fputs($f,"\$div16[\"ID\"]=\"".$_POST["div16ID"]."\";\n");
104 fputs($f,"\$div07[\"ID\"]=\"".$_POST["div07ID"]."\";\n");
105 fputs($f,"\$versand[\"ID\"]=\"".$_POST["versandID"]."\";\n");
106 fputs($f,"\$nachn[\"ID\"]=\"".$_POST["nachnID"]."\";\n");
107 fputs($f,"\$minder[\"ID\"]=\"".$_POST["minderID"]."\";\n");
108 fputs($f,"\$treuh[\"ID\"]=\"".$_POST["treuhID"]."\";\n");
109 fputs($f,"\$paypal[\"ID\"]=\"".$_POST["paypalID"]."\";\n");
110 fputs($f,"\$div16[\"NR\"]=\"".$_POST["div16NR"]."\";\n");
111 fputs($f,"\$div07[\"NR\"]=\"".$_POST["div07NR"]."\";\n");
112 fputs($f,"\$versand[\"NR\"]=\"".$_POST["versandNR"]."\";\n");
113 fputs($f,"\$nachn[\"NR\"]=\"".$_POST["nachnNR"]."\";\n");
114 fputs($f,"\$minder[\"NR\"]=\"".$_POST["minderNR"]."\";\n");
115 fputs($f,"\$treuh[\"NR\"]=\"".$_POST["treuhNR"]."\";\n");
116 fputs($f,"\$paypal[\"NR\"]=\"".$_POST["paypalNR"]."\";\n");
117 fputs($f,"\$div16[\"TXT\"]=\"".$div16txt."\";\n");
118 fputs($f,"\$div07[\"TXT\"]=\"".$div07txt."\";\n");
119 fputs($f,"\$versand[\"TXT\"]=\"".$versandtxt."\";\n");
120 fputs($f,"\$nachn[\"TXT\"]=\"".$nachntxt."\";\n");
121 fputs($f,"\$minder[\"TXT\"]=\"".$mindertxt."\";\n");
122 fputs($f,"\$treuh[\"TXT\"]=\"".$treuhtxt."\";\n");
123 fputs($f,"\$paypal[\"TXT\"]=\"".$paypaltxt."\";\n");
124 fputs($f,"\$bgcol[1]=\"#ddddff\";\n");
125 fputs($f,"\$bgcol[2]=\"#ddffdd\";\n");
126 fputs($f,"\$preA=\"".$_POST["preA"]."\";\n");
127 fputs($f,"\$preK=\"".$_POST["preK"]."\";\n");
128 fputs($f,"\$auftrnr=\"".$_POST["auftrnr"]."\";\n");
129 fputs($f,"\$kdnum=\"".$_POST["kdnum"]."\";\n");
130 fputs($f,"\$pricegroup=\"".$_POST["pricegroup"]."\";\n");
131 fputs($f,"\$showErr=\"true\";\n");
136 $ERPuser=$_POST["ERPuser"];
137 $ERPpass=$_POST["ERPpass"];
138 $ERPhost=$_POST["ERPhost"];
139 $ERPdbname=$_POST["ERPdbname"];
140 $ERPusrN=$_POST["ERPusrN"];
141 $ERPdir=$_POST["ERPdir"];
142 $ERPimgdir=$_POST["ERPimgdir"];
143 $maxSize=$_POST["maxSize"];
144 $ERPftphost=$_POST["ERPftphost"];
145 $ERPftpuser=$_POST["ERPftpuser"];
146 $ERPftppwd=$_POST["ERPftppwd"];
147 $SHOPuser=$_POST["SHOPuser"];
148 $SHOPpass=$_POST["SHOPpass"];
149 $SHOPhost=$_POST["SHOPhost"];
150 $SHOPdbname=$_POST["SHOPdbname"];
151 $SHOPdir=$_POST["SHOPdir"];
152 $SHOPimgdir=$_POST["SHOPimgdir"];
153 $SHOPftphost=$_POST["SHOPftphost"];
154 $SHOPftpuser=$_POST["SHOPftpuser"];
155 $SHOPftppwd=$_POST["SHOPftppwd"];
156 $div16NR=$_POST["div16NR"];
157 $div07NR=$_POST["div07NR"];
158 $versandNR=$_POST["versandNR"];
159 $nachnNR=$_POST["nachnNR"];
160 $treuhNR=$_POST["treuhNR"];
161 $minderNR=$_POST["minderNR"];
162 $paypalNR=$_POST["paypalNR"];
163 $preA=$_POST["preA"];
164 $preK=$_POST["preK"];
165 $kdnum=$_POST["kdnum"];
166 $pricegroup=$_POST["pricegroup"];
167 $auftrnr=$_POST["auftrnr"];
176 <table style="background-color:#cccccc" border="0">
177 <form name="ConfEdit" method="post" action="confedit.php">
178 <input type="hidden" name="div16ID" value="<?= $div16["ID"] ?>">
179 <input type="hidden" name="div07ID" value="<?= $div07["ID"] ?>">
180 <input type="hidden" name="minderID" value="<?= $minder["ID"] ?>">
181 <input type="hidden" name="versandID" value="<?= $versand["ID"] ?>">
182 <input type="hidden" name="nachnID" value="<?= $nachn["ID"] ?>">
183 <input type="hidden" name="paypalID" value="<?= $paypal["ID"] ?>">
184 <input type="hidden" name="treuhID" value="<?= $treuh["ID"] ?>">
185 <input type="hidden" name="ERPusrID" value="<?= $ERPusr["ID"] ?>">
187 <tr><th>Daten</th><th>Lx-ERP</th><th></th><th>Shop</th></tr>
190 <td colspan="2"><input type="text" name="ERPhost" size="25" value="<?= $ERPhost ?>"></td>
191 <td><input type="text" name="SHOPhost" size="25" value="<?= $SHOPhost ?>"></td>
195 <td colspan="2"><input type="text" name="ERPdbname" size="20" value="<?= $ERPdbname ?>"></td>
196 <td><input type="text" name="SHOPdbname" size="20" value="<?= $SHOPdbname ?>"></td>
199 <td>db-User Name</td>
200 <td colspan="2"><input type="text" name="ERPuser" size="15" value="<?= $ERPuser ?>"></td>
201 <td><input type="text" name="SHOPuser" size="15" value="<?= $SHOPuser ?>"></td>
205 <td colspan="2"><input type="text" name="ERPpass" size="15" value="<?= $ERPpass ?>"></td>
206 <td><input type="text" name="SHOPpass" size="15" value="<?= $SHOPpass ?>"></td>
210 <td colspan="2"><input type="text" name="ERPusrN" size="10" value="<?= $ERPusr["Name"] ?>">
211 <input type="checkbox" name="a1" <?= (empty($ERPusr["ID"])?"":"checked") ?>></td>
216 <td colspan="2"><input type="text" name="ERPdir" size="30" value="<?= $ERPdir ?>"></td>
217 <td><input type="text" name="SHOPdir" size="30" value="<?= $SHOPdir ?>"></td>
221 <td colspan="2"><input type="text" name="ERPimgdir" size="30" value="<?= $ERPimgdir ?>"></td>
222 <td><input type="text" name="SHOPimgdir" size="30" value="<?= $SHOPimgdir ?>"></td>
226 <td colspan="2"><input type="text" name="ERPftphost" size="20" value="<?= $ERPftphost ?>"></td>
227 <td><input type="text" name="SHOPftphost" size="20" value="<?= $SHOPftphost ?>"></td>
231 <td colspan="2"><input type="text" name="ERPftpuser" size="15" value="<?= $ERPftpuser ?>"></td>
232 <td><input type="text" name="SHOPftpuser" size="15" value="<?= $SHOPftpuser ?>"></td>
235 <td>FTP-User PWD</td>
236 <td colspan="2"><input type="text" name="ERPftppwd" size="15" value="<?= $ERPftppwd ?>"></td>
237 <td><input type="text" name="SHOPftppwd" size="15" value="<?= $SHOPftppwd ?>"></td>
240 <td>ID Diverse 16%</td>
241 <td><input type="text" name="div16NR" size="10" value="<?= $div16["NR"] ?>">
242 <input type="checkbox" name="a1" <?= (empty($div16["ID"])?"":"checked") ?>></td>
243 <td>ID Diverse 7%</td>
244 <td><input type="text" name="div07NR" size="10" value="<?= $div07["NR"] ?>">
245 <input type="checkbox" name="a1" <?= (empty($div07["ID"])?"":"checked") ?>></td>
249 <td><input type="text" name="versandNR" size="10" value="<?= $versand["NR"] ?>">
250 <input type="checkbox" name="a1" <?= (empty($versand["ID"])?"":"checked") ?>></td>
252 <td><input type="text" name="nachnNR" size="10" value="<?= $nachn["NR"] ?>">
253 <input type="checkbox" name="a1" <?= (empty($nachn["ID"])?"":"checked") ?>></td>
257 <td><input type="text" name="paypalNR" size="10" value="<?= $paypal["NR"] ?>">
258 <input type="checkbox" name="a1" <?= (empty($paypal["ID"])?"":"checked") ?>></td>
260 <td><input type="text" name="treuhNR" size="10" value="<?= $treuh["NR"] ?>">
261 <input type="checkbox" name="a1" <?= (empty($treuh["ID"])?"":"checked") ?>></td>
264 <td>ID Mindermenge</td>
265 <td><input type="text" name="minderNR" size="10" value="<?= $minder["NR"] ?>">
266 <input type="checkbox" name="a1" <?= (empty($minder["ID"])?"":"checked") ?>></td>
268 <td><select name="pricegroup">
269 <? pg($pricegroup); ?>
273 <td colspan="2">Auftragsnummern durch</td>
274 <td><input type="radio" name="auftrnr" value="1" <?= ($auftrnr==1)?"checked":"" ?>> LxO</td>
275 <td><input type="radio" name="auftrnr" value="0" <?= ($auftrnr<>1)?"checked":"" ?>> Shop</td>
278 <td colspan="2">Kundennummern durch</td>
279 <td><input type="radio" name="kdnum" value="1" <?= ($kdnum==1)?"checked":"" ?>> LxO</td>
280 <td><input type="radio" name="kdnum" value="0" <?= ($kdnum<>1)?"checked":"" ?>> Shop</td>
283 <td colspan="2">Nummernerweiterung</td>
284 <td>Auftrag<input type="text" name="preA" size="5" value="<?= $preA ?>"></td>
285 <td>Kunde<input type="text" name="preK" size="5" value="<?= $preK ?>"></td>
288 <td>Bildergrösse (byte)</td>
289 <td><input type="text" name="maxSize" size="10" value="<?= $maxSize ?>"></td>
296 <tr><td colspan="4" align="center"><input type="submit" name="ok" value="sichern"></td></tr>