Subversion-Projekte lars-tiefland.content-management

Revision

Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
3 
    /**
4 
     * @package   Content-management
5 
     * @author    Lars Tiefland <tiefland@weban.de>
6 
     * @copyright 2010 Webagentur Niewerth
7 
     * @license   propietary http://www.weban.de
8 
     * @version   $Rev: 4003 $
9 
     * @filesource
10 
     *
11 
     */
12 
 
13 
    /**
14 
     *
15 
     * @package   Content-management
16 
     * @author    Lars Tiefland <tiefland@weban.de>
17 
     * @copyright 2010 Webagentur Niewerth
18 
     */
19 
 
20 
    require_once "../Online-Shop/connect2.php";
21 
    require_once "Weban_Smarty.class.php";
22 
 
23 
    header( "Last-Modified: " . time() );
24 
    // SVN: $Id: kundensuche.php 4003 2011-10-13 13:56:26Z erling $
25 
    $input = filter_input_array( INPUT_POST, array( "id" =>
26 
        FILTER_SANITIZE_NUMBER_INT, "Name1" => FILTER_SANITIZE_STRING, "PLZ" =>
27 
        FILTER_SANITIZE_NUMBER_INT, "Ort" => FILTER_SANITIZE_STRING, "Name2" =>
28 
        FILTER_SANITIZE_STRING, "E_Mail" => FILTER_SANITIZE_EMAIL,
29 
        "suche_an" => FILTER_SANITIZE_NUMBER_INT ) );
30 
 
31 
    foreach ( $input as $key => $wert )
32 
    {
33 
        $input[$key] = utf8_decode( $wert );
34 
    }
35 
 
36 
    if ( $input["id"] )
37 
    {
38 
        $sql = "SELECT
39 
                Anrede,
40 
                Name1,
41 
                Vorname,
42 
                Name2,
43 
                Strasse,
44 
                Hausnummer,
45 
                PLZ,
46 
                Ort,
47 
                Land,
48 
                Telefon,
49 
                Fax,
50 
                E_Mail,
51 
                AP_Bemerkung,
52 
                ID
53 
            FROM
54 
                Logins
55 
            WHERE
56 
                ID=" . $input["id"] . "
57 
        ";
58 
        $res = mysql_query( $sql );
59 
        $row = mysql_fetch_assoc( $res );
60 
        echo implode( "###", $row );
61 
    }
62 
    else
63 
    {
64 
        if ( strlen( $input["Name1"] ) >= 3 )
65 
        {
66 
            $search[] = "Name1 LIKE '" . $input["Name1"] . "%'";
67 
        }
68 
        if ( strlen( $input["Name2"] ) >= 3 )
69 
        {
70 
            $search[] = "Name2 LIKE '" . $input["Name2"] . "%'";
71 
        }
72 
        if ( strlen( $input["Ort"] ) >= 3 )
73 
        {
74 
            $search[] = "Ort LIKE '" . $input["Ort"] . "%'";
75 
        }
76 
        if ( strlen( $input["PLZ"] ) == 5 )
77 
        {
78 
            $search[] = "PLZ=" . $input["PLZ"];
79 
        }
80 
        $pos = strpos( $input["E_Mail"], "@" );
81 
        if ( $pos !== false )
82 
        {
83 
            list( $local, $dom ) = explode( "@", $input["E_Mail"] );
84 
            $input["E_Mail"] = $local . "%@" . $dom;
85 
            $search[] = "E_Mail LIKE '%" . $input["E_Mail"] . "%'";
86 
        }
87 
        if ( is_array( $search ) )
88 
        {
89 
            $where = implode( " AND ", $search );
90 
            $sql = "SELECT
91 
                ID,
92 
                Vorname,
93 
                Name1,
94 
                Name2,
95 
                PLZ,
96 
                Ort,
97 
                E_Mail,
98 
                AP_Bemerkung
99 
            FROM
100 
                Logins
101 
            WHERE
102 
                $where
103 
        ";
104 
            $res = mysql_query( $sql );
105 
            while ( $row = mysql_fetch_assoc( $res ) )
106 
            {
107 
                $daten[] = $row;
108 
            }
109 
            $GLOBALS["ui"] = new Weban_Smarty();
110 
            $GLOBALS["ui"]->assign( "daten", $daten );
111 
            $GLOBALS["ui"]->display( "ergebnisse.tpl" );
112 
        }
113 
        else
114 
        {
115 
            echo "";
116 
        }
117 
    }
118 
?>