pepper/confedit.php

   1 <?
   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&uuml;ssen sich autentifizieren\n";
   7        exit;
   8 } else {
   9         include "conf.php";
  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);
  15         }
  16         function pg($sel) {
  17         global $pgs;
  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";
  25                 }
  26         }
  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&uuml;ssen sich autentifizieren\n";
  31                 exit;
  32         }
  33         if ($_POST["ok"]=="sichern") {
  34                 $ok=true;
  35                 $dsnP="pgsql://".$_POST["ERPuser"].":".$_POST["ERPpass"]."@".$_POST["ERPhost"]."/".$_POST["ERPdbname"];
  36                 $dbP=DB::connect($dsnP);
  37                 if (DB::isError($dbP)||!$dbP) {
  38                         $ok=false;
  39                         echo "Keine Verbindung zur ERP<br>";
  40                         echo $dbP->userinfo;
  41                 }
  42                 else {
  43                         $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["div16NR"]."'");
  44                         $_POST["div16ID"]=$rs[0][0];
  45                         $div16txt=$rs[0][1];
  46                         $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["div07NR"]."'");
  47                         $_POST["div07ID"]=$rs[0][0];
  48                         $div07txt=$rs[0][1];
  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];
  54                         $nachntxt=$rs[0][1];
  55                         $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["minderNR"]."'");
  56                         $_POST["minderID"]=$rs[0][0];
  57                         $mindertxt=$rs[0][1];
  58                         $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["paypalNR"]."'");
  59                         $_POST["paypalID"]=$rs[0][0];
  60                         $paypaltxt=$rs[0][1];
  61                         $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["treuhNR"]."'");
  62                         $_POST["treuhID"]=$rs[0][0];
  63                         $treuhtxt=$rs[0][1];
  64                         $rs=$dbP->getall("select id from employee where login = '".$_POST["ERPusrN"]."'");
  65                         $_POST["ERPusrID"]=$rs[0][0];
  66                 }
  67                 $dsnM="mysql://".$_POST["SHOPuser"].":".$_POST["SHOPpass"]."@".$_POST["SHOPhost"]."/".$_POST["SHOPdbname"];
  68                 $dbM=DB::connect($dsnM);
  69                 if (DB::isError($dbM)||!$dbM) {
  70                         $ok=false;
  71                         echo "Keine Verbindung zum Shop<br>";
  72                         echo $dbM->userinfo;
  73                 };
  74                 if (ok) {
  75                         $f=fopen("conf.php","w");
  76                         $v="1.5";
  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");
 132                         fputs($f,"?>");
 133                         fclose($f);
 134                         require "conf.php";
 135                 } else {
 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"];
 168                 }
 169         }       else {
 170                 require "conf.php";
 171         }
 172         ?>
 173 <html>
 174 <body>
 175 <center>
 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"] ?>">
 186
 187 <tr><th>Daten</th><th>Lx-ERP</th><th></th><th>Shop</th></tr>
 188 <tr>
 189         <td>db-Host</td>
 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>
 192 </tr>
 193 <tr>
 194         <td>Database</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>
 197 </tr>
 198 <tr>
 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>
 202 </tr>
 203 <tr>
 204         <td>db-User PWD</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>
 207 </tr>
 208 <tr>
 209         <td>User-ID</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>
 212         <td></td>
 213 </tr>
 214 <tr>
 215         <td>CSV-Dir</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>
 218 </tr>
 219 <tr>
 220         <td>Image-Dir</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>
 223 </tr>
 224 <tr>
 225         <td>FTP-Host</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>
 228 </tr>
 229 <tr>
 230         <td>FTP-User</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>
 233 </tr>
 234 <tr>
 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>
 238 </tr>
 239 <tr>
 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>
 246 </tr>
 247 <tr>
 248         <td>ID Versand</td>
 249         <td><input type="text" name="versandNR" size="10" value="<?= $versand["NR"] ?>">
 250                 <input type="checkbox" name="a1" <?= (empty($versand["ID"])?"":"checked") ?>></td>
 251         <td>ID Nachname</td>
 252         <td><input type="text" name="nachnNR" size="10" value="<?= $nachn["NR"] ?>">
 253                 <input type="checkbox" name="a1" <?= (empty($nachn["ID"])?"":"checked") ?>></td>
 254 </tr>
 255 <tr>
 256         <td>ID Paypal</td>
 257         <td><input type="text" name="paypalNR" size="10" value="<?= $paypal["NR"] ?>">
 258                 <input type="checkbox" name="a1" <?= (empty($paypal["ID"])?"":"checked") ?>></td>
 259         <td>ID Treuhand</td>
 260         <td><input type="text" name="treuhNR" size="10" value="<?= $treuh["NR"] ?>">
 261                 <input type="checkbox" name="a1" <?= (empty($treuh["ID"])?"":"checked") ?>></td>
 262 </tr>
 263 <tr>
 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>
 267         <td>Preisgruppe</td>
 268         <td><select name="pricegroup">
 269 <? pg($pricegroup); ?>
 270             </select></td>
 271 </tr>
 272 <tr>
 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>
 276 </tr>
 277 <tr>
 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>
 281 </tr>
 282 <tr>
 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>
 286 </tr>
 287 <!--tr>
 288         <td>Bildergr&ouml;sse (byte)</td>
 289         <td><input type="text" name="maxSize" size="10" value="<?= $maxSize ?>"></td>
 290         <td></td>
 291 </tr-->
 292
 293
 294
 295
 296 <tr><td colspan="4" align="center"><input type="submit" name="ok" value="sichern"></td></tr>
 297 </form>
 298 </table>
 299 </center>
 300 </body>
 301 </html>
 302 <? } ?>