Subversion-Projekte lars-tiefland.content-management

<?php

    //$Id: login.class.php 425 2008-09-10 09:15:32Z tiefland $

    /**
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2008 Webagentur Niewerth
     * @package Content-management
     * @subpackage Projekttool
     * @version $Rev: 425 $
     * @license propietary
     * @filesource
     * 
     */

    /**
     * 
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2008 Webagentur Niewerth
     * @package Content-management
     * @subpackage Projekttool
     */

    class Login
    {
        var $pl_id = null;
        var $pl_nname = "";
        var $pl_vname = "";
        var $pl_name = "";
        var $eigenschaft_1 = 0;
        var $login = "";
        var $status = "User View";
        var $erstellt_am = "";
        var $erstellt_von = "";
        var $letzte_Aenderung_am = "";
        var $letzte_Aenderung_von = "";

        function Login( $pl_id = null )
        {
            $this->pl_id = $pl_id;
            if ( $pl_id )
            {
                $sql = "
                    SELECT
                        *
                    FROM
                        Logins
                    WHERE
                        id=$pl_id
                ";
                $res = mysql_query( $sql );
                if ( $res )
                {
                    $row = mysql_fetch_assoc( $res );
                    $this->pl_nname = $row["Name1"];
                    $this->pl_vname = $row["Vorname"];
                    $this->pl_name = $this->pl_vname . " " . $this->pl_nname;
                    $this->erstellt_am = $row["erstellt_am"];
                    $this->erstellt_von = $row["erstellt_von"];
                    $this->login = $row["user"];
                    $this->status = $row["Status"];
                    $this->eigenschaft_1 = $row["Eigenschaft_1"];
                    $this->letzte_Aenderung_am = $row["letzte_Aenderung_am"];
                    $this->letzte_Aenderung_von = $row["letzte_Aenderung_von"];
                }
            }
        }

        function update( $pl_id, $pl_vname, $pl_nname )
        {
            // Daten in das Objekt schreiben
            $this->pl_nname = $pl_nname;
            $this->pl_vname = $pl_vname;
            $this->pl_id = $pl_id;
            $this->eigenschaft_1 = $eigenschaft_1;
            $this->status = $status;
        }

        function save( $op )
        {
            // Daten in Datenbank schreiben
            switch ( $op )
            {
                case "save":
                    $sql = "
                        INSERT INTO 
                            Logins
                        (
                            Vorname,
                            Name1,
                            Eigenschaft_1,
                            Status,
                            erstellt_am,
                            erstellt_von
                        ) 
                        VALUES 
                        (
                            '$this->pl_vname', 
                            '$this->pl_nname',
                            0,
                            'User View',
                            NOW(),
                            '" . $_SERVER["PHP_AUTH_USER"] . "' 
                        )
                    ";
                    return mysql_query( $sql );
                    break;
                case "update":
                    $sql = "
                        UPDATE 
                            Logins 
                        SET 
                            Vorname='$this->pl_vname', 
                            Name1='$this->pl_nname',
                            Eigenschaft_1=$this->eigenschaft_1,
                            Status = '$this->status',
                            letzte_Aenderung_am=NOW(),
                            letzte_Aenderung_von='" . $_SERVER["PHP_AUTH_USER"] .
                        "'  
                        WHERE
                            ID=$this->pl_id
                    ";
                    return mysql_query( $sql );
                    break;
                case "delete":
                    $sql = "
                        DELETE FROM
                            projekt_leiter
                        WHERE
                            pl_id=$this->pl_id
                    ";
                    return mysql_query( $sql );
                    break;
                default:
                    return false;
            }
        }

        function getLogins()
        {
            $sql = "
                SELECT 
                    id AS pl_id 
                FROM 
                    Logins 
            ";
            $res = mysql_query( $sql );
            if ( $res )
            {
                while ( $row = mysql_fetch_assoc($res) )
                {
                    $p = new Login( $row["pl_id"] );
                    $ret[] = $p;
                    unset( $p );
                }
            }
            return $ret;
        }
    }

?>