Subversion-Projekte lars-tiefland.content-management

<?php

    //$Id: functions.php 437 2008-09-15 06:32:44Z erling $

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

    /**
     * 
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2008 Webagentur Niewerth
     */

    function getDokumente( $p_id )
    {
        global $user_rechte, $site, $web_rechte, $webs;
        // Modul dokumente
        $Feld = "dokument";

        // Modconf => Bestellung
        $moduleTyp[tool_name] = array( "table_foreign" => "projekte", "row_foreign" =>
            "p_id", "data_foreign" => "p_id" );

        $interneModulRechte = array( 0 => "_read", 1 => "_delete", 2 => "_add" );

        $dokPath = "http://www.$site/images/dokumente/";
        $uploadPath = $webs['verzeichnis'] . "/images/dokumente/";

        $res["rechte"]["view"] = ( isset($user_rechte[modul_name][tool_name][$Feld .
            "_read"]) ) ? true : false;
        $res["rechte"]["add"] = ( isset($user_rechte[modul_name][tool_name][$Feld .
            "_add"]) ) ? true : false;
        $res["rechte"]["del"] = ( isset($user_rechte[modul_name][tool_name][$Feld .
            "_delete"]) ) ? true : false;
        if ( isset($user_rechte[modul_name][tool_name][$Feld . $interneModulRechte[0]]) )
        {
            $docCount = 1;
            $sql_d = "SELECT * FROM dokumente WHERE data_foreign = '" . $p_id .
                "' AND table_foreign='" . $moduleTyp[tool_name]["table_foreign"] . "'";
            $result_d = mysql_query( $sql_d ) or die( mysql_errno() . ": " . mysql_error
                () . "<hr>" . nl2br($sql_d) . "<hr>" );
            if ( mysql_num_rows($result_d) > 0 )
            {
                $i = 0;
                while ( $zeile_d = mysql_fetch_array($result_d) )
                {
                    // Dateityp Icon definieren
                    $fTmpName = $zeile_d['document'];
                    $dokumente[$i]["name"] = $fTmpName;
                    $dokumente[$i]["type"] = substr( $fTmpName, strrpos($fTmpName, ".") + 1,
                        strlen($fTmpName) );

                    $fTmpLinkIcon = "../dokumente/gfx/fileicons/" . $dokumente[$i]["type"] .
                        ".gif";
                    $fTmpIcon = "../dokumente/gfx/fileicons/" . $dokumente[$i]["type"] . ".gif";

                    $fTmpSize = @filesize( $uploadPath . $fTmpName );

                    $dokumente[$i]["size"] = $fTmpSize > 1048576 ? round( $fTmpSize / 1048576, 2 ) .
                        " MB" : round( $fTmpSize / 1024, 2 ) . " KB";
                    $dokumente[$i]["icon"] = file_exists( $fTmpIcon ) ? $fTmpLinkIcon :
                        "../dokumente/gfx/fileicons/default.gif";

                    $dokumente[$i]["link"] = $dokPath . $zeile_d['document'];
                    $Felddaten = @explode( ";", $web_rechte[modul_name][tool_name][$Feld] );

                    // $onClick  = "window.open('../Dokumente/index.php?mailto=".$zeile['E_Mail']."&subject=".$web_settings[$zeile[shops_ID]][$Felddaten[1]]."&body=".$web_settings[$zeile[shops_ID]][$Felddaten[2]]."&inTextField=".$web_settings[$zeile[shops_ID]][$Felddaten[3]]."', 'MailClient', 'status, menubar, height=600, width=900'); return false;";
                    $dokumente[$i]["add"] = "window.open('dokumente.php?table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
                        "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] . "&data_foreign=" .
                        $p_id . "#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
                    $dokumente[$i]["add_archive"] = "window.open('dokumente.php?table_foreign=" .
                        $moduleTyp[tool_name]['table_foreign'] . "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
                        "&data_foreign=" . $p_id .
                        "&mode=archiv#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
                    $dokumente[$i]["del"] = "window.open('dokumente.php?action=unlink&id=" . $zeile_d['id'] .
                        "&table_foreign=" . $moduleTyp[tool_name]['table_foreign'] . "&row_foreign=" .
                        $moduleTyp[tool_name]['row_foreign'] . "&data_foreign=" . $p_id .
                        "#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
                    //$onClick = $onSubmit;

                    // id  table_foreign  row_foreign  id_foreign  document


                    // Upload Verzeichnis


                    if ( !empty($Felddaten[0]) )
                    {
                        $dokumente[$i]["caption"] = $Felddaten[0] . " Nr.$docCount";

                    }
                    else
                    {
                        $dokumente[$i]["caption"] = "Dokument Nr. $docCount";
                    }
                    // Datumsangaben lesbar machen
                    if ( strpos($zeile_d['letzte_aenderung_am'], " ") )
                    {
                        $dokumente[$i]["letzte_aenderung_am"] = datetime2human( $zeile_d['letzte_aenderung_am'] );
                    }
                    else
                    {
                        $dokumente[$i]["letzte_aenderung_am"] = timestamp2human( $zeile_d['letzte_aenderung_am'] );
                    }
                    $dokumente[$i]["letzte_aenderung_von"] = $zeile_d["letzte_aenderung_von"];
                    $dokumente[$i]["status"] = $zeile_d["status"];
                    $i++;
                    $docCount++;
                }
                $res["dokumente"] = $dokumente;
            }
            else
            {
                $Felddaten = explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
                $res["view"]["add"] = "window.open('dokumente.php?table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
                    "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] . "&data_foreign=" .
                    $p_id . "#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
                $res["view"]["add_archive"] = "window.open('dokumente.php?table_foreign=" .
                    $moduleTyp[tool_name]['table_foreign'] . "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
                    "&data_foreign=" . $p_id .
                    "&mode=archiv#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
                if ( !empty($Felddaten[0]) )
                {
                    $res["view"]["caption"] = $Felddaten[0];

                }
                else
                {
                    $res["view"]["caption"] = "Dokument";
                }
            }
        }
        return $res;
    }

?>