WebSVN – lars-tiefland.content-management – /trunk/Warenwirtschaft/includes/best_manu/search.php

<?php
echo md5("info@weban.de");

session_start();
$debug=0;
if(strlen($_POST['form_search'])>0){
        $_SESSION['best_manu.php']['Kundendaten'] = $_POST;
}

if($debug==1) print_r($_SESSION['best_manu.php']['Kundendaten']);
require_once "../../../Online-Shop/connect2.php";

require_once 'system/getCountries.php'); // hier liegt auch die function translate_key($table,$key .. erstmal...
$landArr = getCountries();

$infoMsg['mindEintrag'] = "Ihre Suchbegriffe m&uuml;ssem mindestens 3 Zeichen lang sein.";
        
$errMsg['keinSuchbegriff'] = "Fehler. Kein Suchbegriff eingegeben oder Suchbegriff zu kurz.";
$errMsg['keinErgebnis'] = "Fehler. Keine Ergebnisse gefunden.";

$html = "";
$selected = 1; // Preselected Deutschland (Länder-selectbox)

$html .= build_search_header();

switch($_REQUEST['s_action']){
        case "search":

                $noPost=1;

// evtl. Leerzeichen entfernen
                foreach($_REQUEST as $key => $val) {
                        $_REQUEST[$key] = trim($val);
                }

                // Firma
                $wcl = "(";
                if(strlen($_REQUEST['s_Firma'])>2){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Name2 like '%".$_REQUEST['s_Firma']."%'";
                        $j++;
                }
                // Vorname
                if(strlen($_REQUEST['s_Vorname'])>2){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Vorname like '%".$_REQUEST['s_Vorname']."%'";
                        $j++;
                }
                // Nachname
                if(strlen($_REQUEST['s_Nachname'])>2){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Name1 like '%".$_REQUEST['s_Nachname']."%'";
                        $j++;
                }
                // Strasse
                if(strlen($_REQUEST['s_Strasse'])>2){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        //strasse für die Suche beschneiden
                        $strasse = eregi_replace("strasse","",$_REQUEST['s_Strasse']);
                        $strasse = eregi_replace("straße","",$strasse);
                        $strasse = eregi_replace("str.","",$strasse);
                        $strasse = eregi_replace("str,","",$strasse); //tippfehler abfangen     
                        $wcl .= "Strasse like '%".trim($strasse)."%'";
                        $j++;
                }
                // Hausnummer
                if(strlen($_REQUEST['s_Hausnummer'])>0){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Hausnummer like '".$_REQUEST['s_Hausnummer']."%'";
                        $j++;
                }
                // PLZ
                if(strlen($_REQUEST['s_PLZ'])>1){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "PLZ like '".$_REQUEST['s_PLZ']."%'";
                        $j++;
                }
                // Ort
                if(strlen($_REQUEST['s_Ort'])>2){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Ort like '%".$_REQUEST['s_Ort']."%'";
                        $j++;
                }
                // Telefon
                if(strlen($_REQUEST['s_Telefon'])>3){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Telefon like '".$_REQUEST['s_Telefon']."%'";
                        $j++;
                }
                // Fax
                if(strlen($_REQUEST['s_Fax'])>3){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Fax like '".$_REQUEST['s_Fax']."%'";
                        $j++;
                }
                // email
                if(strlen($_REQUEST['s_email'])>2){
                        $noPost=0;
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "E_Mail like '%".$_REQUEST['s_email']."%'";
                        $j++;
                }
                // Land
                if(strlen($_REQUEST['s_Land'])>0){
                        if($j>0) $wcl .= ") and (";
                        $wcl .= "Land = '".$landArr[$_REQUEST['s_Land']]."')";
                }

                $sql = "select ID,Anrede,Vorname,Name1,Name2,Strasse,Hausnummer,PLZ,Ort,Land,E_Mail,Telefon,Fax,AP_Bemerkung 
                                from Logins where ".$wcl." order by Name2,Name1,Vorname,E_Mail,PLZ,Ort";
                if($debug==1) echo $sql;
                if($noPost==0){
                        $q = mysql_query($sql);
                }else{
                        die(build_search_header()."<br/>".$errMsg['keinSuchbegriff']."<br/><br/>".build_search_back().build_search_footer());
                }

                $html .= "\n\n<script type=\"text/javascript\">\n";

                $html .= "\tfunction openerRefresh(ID,Anrede,Vorname,Name1,Name2,Strasse,Hausnummer,PLZ,Ort,Land,E_Mail,Telefon,Fax,Bemerkung) {\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.ID.value = ID;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Vorname.value = Vorname;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Anrede.value = Anrede;\n";                
                $html .= "\t\twindow.opener.document.form_kundendaten.Firma.value = Name2;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Vorname.value = Vorname;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Nachname.value = Name1;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Strasse.value = Strasse;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Hausnummer.value = Hausnummer;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.PLZ.value = PLZ;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Ort.value = Ort;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Land.value = Land;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.email.value = E_Mail;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Telefon.value = Telefon;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Fax.value = Fax;\n";
                $html .= "\t\twindow.opener.document.form_kundendaten.Bemerkung.value = Bemerkung;\n"; 
                $html .= "\t}\n";
                $html .= "</script>\n";

                $i=0;
                $res_headline = "<h3>Suchergebnis";
                $res="";
                $k=1;
                while($r = @mysql_fetch_assoc($q)){
                        $res .= "<div class=\"s_result\">\n";
                        $res .= "<br/>Nr.: ".$k;
                        $res .= "<br/>ID: ".$r['ID'];
                        $res .= "<br/>Firma: ".$r['Name2'];
                        $res .= "<br/>Anrede: ".$r['Anrede'];
                        $res .= "<br/>Vorname: ".$r['Vorname']."<br/>Nachname: ".$r['Name1'];
                        $res .= "<br/>Strasse/Nr.: ".$r['Strasse']." ".$r['Hausnummer'];
                        $res .= "<br/>Tel.: ".$r['Telefon'];
                        $res .= "<br/>Fax: ".$r['Fax'];
                        $res .= "<br/>PLZ/Ort: ".$r['PLZ']." ".$r['Ort'];
                        $res .= "<br/>Land: ".$r['Land'];
                        $res .= "<br/>E-Mail: ".$r['E_Mail'];
                        $res .= "</div>\n";
                        $res .= "<div class=\"s_select\">\n";
                        $k++;
                        $paramsArr = array();
                        $j=0;
                        $res_html = "";
                        foreach($r as $key => $value){
                                // Suchergebnis übergeben (Formular)
                                if($key=="Land") $value = getCountryIDByName($value,$landArr);
                                $key = translate_key("Logins",$key,"table2form");
                                $res_html .= "\t<input type=\"hidden\" name=\"".$key."\" value=\"".$value."\" />\n";
                                // und für das update per Javascript
                                $paramsArr[] = "'".$value."'";
                                $j++;
                        }
                        $params = implode(",",$paramsArr);
                        $res .= "<form action=\"?s_action=search\" name=\"sres_".$r['ID']."\" method=\"post\" onsubmit=\"openerRefresh(".$params."); return true\">\n";
                        $res .= $res_html;

                        $res .= "\t<input type=\"submit\" onmousedown=\"window.refresh();\" onmouseup=\"javascript:window.close();\" name=\"form_search\" value=\"Firma ausw&auml;hlen\" />\n";
                        $res .= build_search_back();
                        $res .= "</form>\n";
                        $res .= "<hr/></div>\n";
                }
        
                if(@mysql_num_rows($q)>0){
                        $html .= $res_headline." (".@mysql_num_rows($q)." Treffer):</h3>\n".$res;
                }else{
                        die(build_search_header()."<br/>".$errMsg['keinErgebnis']."<br/><br/>".build_search_back().build_search_footer());
                }

        break;
        default:
                $html .= build_searchform();
}
$html .= build_search_footer();
echo $html;


function build_searchform() {
        global $landArr;
        global $selected;
        global $infoMsg;

        $html = "<form method=\"post\" name=\"form_sucheFirma\" action=\"".$_SERVER['PHP_SELF']."\">
<fieldset>
<legend>Kundendaten (Firma ausw&auml;hlen)</legend>
".$infoMsg['mindEintrag']."
<table cols=\"2\" cellpadding=\"2\" width=\"100%\" class=\"tablecolor2\" cellspacing=\"2\">
  <tr>
    <td class=\"midcol\"><label for=\"s_Firma\">Firma:</label></td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Firma\" name=\"s_Firma\" size=\"26\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_Vorname\">Vorname:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Vorname\" name=\"s_Vorname\" size=\"26\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_Nachname\">Nachname:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Nachname\" name=\"s_Nachname\" size=\"26\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_strasse\">Stra&szlig;e:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Strasse\" name=\"s_Strasse\" size=\"20\" class=\"inputbox\" value=\"\">
      <input type=\"text\" name=\"s_Hausnummer\" size=\"4\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_PLZ\">PLZ:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_PLZ\" name=\"s_PLZ\" size=\"9\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_Ort\">Ort:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Ort\" name=\"s_Ort\" size=\"26\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_Land\">Land:</td>
    <td align=\"left\">";


        /* SelectBox Länder */
        $html .= buildSelectCountry($landArr,"s_Land",$selected);


    $html .= "</td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_email\">E-Mail:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_email\" name=\"s_email\" size=\"26\" class=\"inputbox\" value=\"\">

    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_Telefon\">Telefon:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Telefon\" name=\"s_Telefon\" size=\"26\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
  <tr>
    <td class=\"midcol\"><label for=\"s_Fax\">Fax:</td>
    <td class=\"midcol\" align=\"left\"><input type=\"text\" id=\"s_Fax\" name=\"s_Fax\" size=\"26\" class=\"inputbox\" value=\"\">
    </td>
  </tr>
</table>
<input type=\"hidden\" name=\"s_action\" value=\"search\" />
<input type=\"submit\" name=\"submit_search\" value=\"Suche starten\" />
</fieldset><br>
</form>";
        return $html;
}

function build_search_header(){
        $html = "<html>\n";
        $html .= "<head>\n";
        $html .= "<title>Firma ausw&auml;hlen</title>\n";
        $html .= "<style>
                                body {
                                        margin:10px;
                                        background-color:       #FFFF00;
                                        font-family:    arial,helvetica,sans-serif;
                                        font-size:10pt;
                                }
                                label {
                                        font-size:10pt;
                                }
                                </style>";
        $html .= "</head><body>\n";
        return $html;
}

function build_search_footer() {
        $html = "</body></html>\n";
        return $html;
}

function build_search_back(){
        $html = "<input type=\"button\" name=\"button\" onclick=\"javascript:window.location.href='".$_SERVER['PHP_SELF']."'\" value=\"neue Suche\" />\n";
        return $html;
}
?>
Subversion-Projekte lars-tiefland.content-management

(root)/trunk/Warenwirtschaft/includes/best_manu/search.php – Revision 1
