Subversion-Projekte lars-tiefland.content-management

<?php
    $file = ( isset($_FILES["umsatz_file"]) ) ? $_FILES["umsatz_file"] : "";
    if ( !$file )
    {
?>
        <form name="upload" method="post" action="" enctype="multipart/form-data">
                <table width="100%">
                <tr>
                        <td valign="top">
                        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
                            <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
                                <td colspan="2" style="color:#<? echo $webs[font_color_links] ?>;font-weight:bold">Benutzer: Importieren</td>
                            </tr>
                            <tr>
                                <td>
                                    Datei
                                </td>
                                <td>
                                    <input type="file" name="umsatz_file" />
                                </td>
                            </tr>
                            <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
                                <td colspan="2" align="right">
                                    <input type="submit" value="Datei einlesen" />
                                </td>
                            </tr>
                        </table>
                    </td>
      <td width="77" align="right"> 
        <table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr> 
            <td class="frame"><a href="<? echo $self ?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image5','','../images/navigation/bt_neu_f2.gif',1)"><a href="<? echo
$self ?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image5','','../images/navigation/bt_neu_f2.gif',1)"><img name="Image5" border="0" src="../images/navigation/bt_neu.gif" width="67" height="40"></a></a></td>
          </tr>
          <tr> 
            <td class="frame"><a href="<? echo $self ?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="Image6" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40"></a></td>
          </tr>
          <tr> 
            <td><a href="<? echo $self ?>?action=delete<? if ( ($action ==
"edit") && ($ID > 0) )
        { ?>&ID[]=<?= $ID ?>" onClick="return confirm('Diesen Eintrag wirklich löschen ?');"<? }
        else
        { ?>"<? } ?> onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('delete','','../images/navigation/bt_delete_f2.gif',1)"><img name="delete" border="0" src="../images/navigation/bt_delete.gif" width="67" height="40" alt="Eintrag l&ouml;schen"></a></td>
          </tr>
<?
        $Feld = "php";
        if ( isset($user_rechte[modul_name][tool_name][$Feld]) )
        {
?>
          <tr>
                         <td><a href="<? echo $self ?>?action=free_php"  onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('import','','../images/navigation/bt_import_f2.gif',1)"><img name="php" border="0" src="../images/navigation/bt_import.gif" width="67" height="40" alt="Daten importieren"></a></td>
          </tr>
<?
        }
        $Feld = "import";
        if ( isset($user_rechte[modul_name][tool_name][$Feld]) )
        {
?>
          <tr>
                         <td><a href="<? echo $self ?>?action=import"  onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('import','','../images/navigation/bt_import_f2.gif',1)"><img name="import" border="0" src="../images/navigation/bt_import.gif" width="67" height="40" alt="Daten importieren"></a></td>
          </tr>
<?
        }
        $Feld = "export";
        if ( isset($user_rechte[modul_name][tool_name][$Feld]) )
        {
?>
          <tr>
                         <td><a href="<? echo $self ?>?action=export"  onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('export','','../images/navigation/bt_export_f2.gif',1)"><img name="export" border="0" src="../images/navigation/bt_export.gif" width="67" height="40" alt="Daten exportieren"></a></td>
          </tr>
<?
        }
?>
        </table>
      </td>
                </tr>
            </table>
                </form>
    <?
        exit;
    }
    $cont = file( $_FILES["umsatz_file"]["tmp_name"] );

    $i = 0;
    foreach ( $cont as $row )
    {
        if ( $i != 0 )
        {
            $row = explode( "\t", $row );
            if(empty($row[4]))
            {
                continue;
            }
            for ( $i = 0; $i < count($row); $i++ )
            {
                $row[$i] = trim( $row[$i] );
            }
            //$row[4]   =       substr          ( $row[4]       ,        0,      strlen($row[4])-2              );
            $row[4] = str_replace( '.', '', $row[4] );
            $row[4] = str_replace( ',', '.', $row[4] );
            $data[] = $row;
        }
        $i++;
    }

    require "MDB2.php";
    require "Text/Password.php";
    require "Mail.php";


    $dsn = "mysql://" . $webs["db_username"] . ":" . $webs["db_password"] . "@" .
        $webs["db_server"] . "/" . $webs[datenbank];
    $db = MDB2::connect( $dsn, array() );

    if ( !PEAR::isError($db) )
    {
        $r2 = $db->query( "SET CHARACTER SET latin1" );
        $db->setFetchMode( MDB2_FETCHMODE_ASSOC );

        foreach ( $data as $row )
        {
            $sql = "SELECT * FROM Logins WHERE Name2=$row[2]";
            $res = $db->query( $sql );
            if ( !PEAR::isError($res) )
            {
                if ( $res->numRows() )
                {
                    $set_sql = "umsatz=$row[4]";
                    if ( count($row) == 6 )
                    {
                        $set_sql .= ", E_Mail='$row[5]'";
                    }
                    $sql = "UPDATE Logins SET $set_sql WHERE Name2=$row[2]";
                    $res2 = $db->query( $sql );

                    if ( PEAR::isError($res2) )
                    {
                        die( $res2->getUserinfo() . "<br>" );
                    }
                }
                else
                {
                    if ( !empty($row[5]) )
                    {
                        $pw = Text_Password::create( 6 );
                        $set_sql = "$row[2], '$row[3]', '$row[4]', '$row[5]', '" . md5( $pw ) . "'";
                        $sql2 = "INSERT INTO Logins (Name2, Name1, umsatz, E_Mail, passwd) VALUES($set_sql)";

                        $body = "Sehr geehrte Kundin, sehr geehrter Kunde," . "\num Ihre Umsätze einsehen zu können, müssen Sie " .
                            "sich mit folgenden Daten auf unserer Webseite einloggen:" . "\nBenutzername: $row[5]\nPasswort: $pw\n\nSelbstverständlich " .
                            "können Sie Ihr Passwort jederzeit ändern.\n\nMit freundlichen " . "Grüßen\nIhr Topgetränke Ümminger Team\n";

                        $subject = "Zugangsdaten für die Einsicht der Umsätze";

                        $headers["Subject"] = $subject;
                        $headers["from"] = "info@topgetraenke-uemminger.de";
                        $mail = Mail::factory( "mail" );

                        // Prüfen, ob kein Fehler aufgetreten ist
                        if ( !PEAR::isError($mail) )
                        {
                            //Mail verschicken
                            $res3 = $mail->send( $row[5], $headers, $body );
                            if ( PEAR::isError($res3) )
                            {
                                echo "Konnte E-Mail nicht an $row[5] schicken." .
                                    "Bitte schicken Sie diese manuell an den " . "Kunden!<br>Betreff: $subject<br>Nachricht:$body<br><br>";
                            }
                        }

                    }
                    else
                    {
                        $set_sql = "$row[2], '$row[3]', '$row[4]'";
                        $sql2 = "INSERT INTO Logins (Name2, Name1, umsatz) VALUES($set_sql)";
                    }
                    $res2 = $db->query( $sql2 );
                    if ( PEAR::isError($res2) )
                    {
                        die( $res2->getUserinfo() . "<br>" );
                    }
                }
            }
        }
        echo "Datei erfolgreich eingelesen!";
    }
    else
    {
        echo $db->getUserinfo();
    }

?>