Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
    /*
3 
    * getSystemtermine()
4 
    * holt alle Systemtermine für den angegebenene User
5 
    * $CMS_Access_ID = PK aus der Tabelle content_management.Access
6 
    */
7 
    function getSystemtermine( $CMS_Access_ID )
8 
    {
9 
        global $webs;
10 
        $buffer = array();
11 
        //if ($webs[ID] == "82")
12 
        //{
13 
        $query =
14 
            "SELECT *, if (faelligkeit < NOW(), 'true', 'false') as abgelaufen FROM systemtermine WHERE zielgruppe = '$CMS_Access_ID' ORDER BY faelligkeit desc, prioritaet desc";
15 
        //}
16 
        //else
17 
        //{
18 
        //	$query="SELECT * FROM systemtermine where zielgruppe = '$CMS_Access_ID' and faelligkeit < NOW() ORDER BY faelligkeit desc, prioritaet desc";
19 
        //}
20 
        if ( $result = mysql_query( $query ) )
21 
        {
22 
            while ( $zeile = mysql_fetch_assoc( $result ) )
23 
            {
24 
                $buffer[] = $zeile;
25 
            }
26 
        }
27 
        return $buffer;
28 
    }
29 
    /*
30 
    * getSystemtermine()
31 
    * holt alle Systemtermine für den angegebenene User
32 
    * $CMS_Access_ID = PK aus der Tabelle content_management.Access
33 
    */
34 
    function getSystemtermine_Anz( $CMS_Access_ID )
35 
    {
36 
        global $webs;
37 
        $buffer = array();
38 
        if ( $webs["db_server"] )
39 
        {
40 
            mysql_connect( $webs["db_server"], $webs["db_username"], $webs["db_password"] );
41 
            mysql_select_db( $webs["datenbank"] );
42 
        }
43 
        for ( $p = 0; $p <= 2; $p++ )
44 
        {
45 
            $query = "
46 
                SELECT
47 
                    count(*) AS anz
48 
                FROM
49 
                    systemtermine
50 
                WHERE
51 
                    zielgruppe = '$CMS_Access_ID'
52 
                AND
53 
                    prioritaet=$p
54 
            ";
55 
            if ( $result = mysql_query( $query ) )
56 
            {
57 
                while ( $zeile = mysql_fetch_assoc( $result ) )
58 
                {
59 
                    switch ( $p )
60 
                    {
61 
                        case 0:
62 
                            $prio_text = "A";
63 
                            break;
64 
                        case 1:
65 
                            $prio_text = "B";
66 
                            break;
67 
                        case 2:
68 
                            $prio_text = "C";
69 
                            break;
70 
                    }
71 
                    $zeile["prioritaet"] = $prio_text;
72 
                    $buffer[] = $zeile;
73 
                }
74 
            }
75 
        }
76 
        return $buffer;
77 
    }
78 
 
79 
?>