Subversion-Projekte lars-tiefland.content-management

<?
    /*
    * getSystemtermine()
    * holt alle Systemtermine für den angegebenene User
    * $CMS_Access_ID = PK aus der Tabelle content_management.Access
    */
    function getSystemtermine( $CMS_Access_ID )
    {
        global $webs;
        $buffer = array();
        //if ($webs[ID] == "82")
        //{
        $query =
            "SELECT *, if (faelligkeit < NOW(), 'true', 'false') as abgelaufen FROM systemtermine WHERE zielgruppe = '$CMS_Access_ID' ORDER BY faelligkeit desc, prioritaet desc";
        //}
        //else
        //{
        //      $query="SELECT * FROM systemtermine where zielgruppe = '$CMS_Access_ID' and faelligkeit < NOW() ORDER BY faelligkeit desc, prioritaet desc";
        //}
        if ( $result = mysql_query( $query ) )
        {
            while ( $zeile = mysql_fetch_assoc( $result ) )
            {
                $buffer[] = $zeile;
            }
        }
        return $buffer;
    }
    /*
    * getSystemtermine()
    * holt alle Systemtermine für den angegebenene User
    * $CMS_Access_ID = PK aus der Tabelle content_management.Access
    */
    function getSystemtermine_Anz( $CMS_Access_ID )
    {
        global $webs;
        $buffer = array();
        if ( $webs["db_server"] )
        {
            mysql_connect( $webs["db_server"], $webs["db_username"], $webs["db_password"] );
            mysql_select_db( $webs["datenbank"] );
        }
        for ( $p = 0; $p <= 2; $p++ )
        {
            $query = "
                SELECT 
                    count(*) AS anz 
                FROM 
                    systemtermine 
                WHERE 
                    zielgruppe = '$CMS_Access_ID' 
                AND 
                    prioritaet=$p 
            ";
            if ( $result = mysql_query( $query ) )
            {
                while ( $zeile = mysql_fetch_assoc( $result ) )
                {
                    switch ( $p )
                    {
                        case 0:
                            $prio_text = "A";
                            break;
                        case 1:
                            $prio_text = "B";
                            break;
                        case 2:
                            $prio_text = "C";
                            break;
                    }
                    $zeile["prioritaet"] = $prio_text;
                    $buffer[] = $zeile;
                }
            }
        }
        return $buffer;
    }

?>