| 1 |
lars |
1 |
<?php
|
|
|
2 |
|
|
|
3 |
//$Id: functions.php 437 2008-09-15 06:32:44Z erling $
|
|
|
4 |
|
|
|
5 |
/**
|
|
|
6 |
* @author Lars Tiefland <tiefland@weban.de>
|
|
|
7 |
* @copyright 2008 Webagentur Niewerth
|
|
|
8 |
* @package Content-management
|
|
|
9 |
* @subpackage Projekttool
|
|
|
10 |
* @version $Rev: 437 $
|
|
|
11 |
* @license propietary
|
|
|
12 |
* @filesource
|
|
|
13 |
*
|
|
|
14 |
*/
|
|
|
15 |
|
|
|
16 |
/**
|
|
|
17 |
*
|
|
|
18 |
* @author Lars Tiefland <tiefland@weban.de>
|
|
|
19 |
* @copyright 2008 Webagentur Niewerth
|
|
|
20 |
*/
|
|
|
21 |
|
|
|
22 |
function getDokumente( $p_id )
|
|
|
23 |
{
|
|
|
24 |
global $user_rechte, $site, $web_rechte, $webs;
|
|
|
25 |
// Modul dokumente
|
|
|
26 |
$Feld = "dokument";
|
|
|
27 |
|
|
|
28 |
// Modconf => Bestellung
|
|
|
29 |
$moduleTyp[tool_name] = array( "table_foreign" => "projekte", "row_foreign" =>
|
|
|
30 |
"p_id", "data_foreign" => "p_id" );
|
|
|
31 |
|
|
|
32 |
$interneModulRechte = array( 0 => "_read", 1 => "_delete", 2 => "_add" );
|
|
|
33 |
|
|
|
34 |
$dokPath = "http://www.$site/images/dokumente/";
|
|
|
35 |
$uploadPath = $webs['verzeichnis'] . "/images/dokumente/";
|
|
|
36 |
|
|
|
37 |
$res["rechte"]["view"] = ( isset($user_rechte[modul_name][tool_name][$Feld .
|
|
|
38 |
"_read"]) ) ? true : false;
|
|
|
39 |
$res["rechte"]["add"] = ( isset($user_rechte[modul_name][tool_name][$Feld .
|
|
|
40 |
"_add"]) ) ? true : false;
|
|
|
41 |
$res["rechte"]["del"] = ( isset($user_rechte[modul_name][tool_name][$Feld .
|
|
|
42 |
"_delete"]) ) ? true : false;
|
|
|
43 |
if ( isset($user_rechte[modul_name][tool_name][$Feld . $interneModulRechte[0]]) )
|
|
|
44 |
{
|
|
|
45 |
$docCount = 1;
|
|
|
46 |
$sql_d = "SELECT * FROM dokumente WHERE data_foreign = '" . $p_id .
|
|
|
47 |
"' AND table_foreign='" . $moduleTyp[tool_name]["table_foreign"] . "'";
|
|
|
48 |
$result_d = mysql_query( $sql_d ) or die( mysql_errno() . ": " . mysql_error
|
|
|
49 |
() . "<hr>" . nl2br($sql_d) . "<hr>" );
|
|
|
50 |
if ( mysql_num_rows($result_d) > 0 )
|
|
|
51 |
{
|
|
|
52 |
$i = 0;
|
|
|
53 |
while ( $zeile_d = mysql_fetch_array($result_d) )
|
|
|
54 |
{
|
|
|
55 |
// Dateityp Icon definieren
|
|
|
56 |
$fTmpName = $zeile_d['document'];
|
|
|
57 |
$dokumente[$i]["name"] = $fTmpName;
|
|
|
58 |
$dokumente[$i]["type"] = substr( $fTmpName, strrpos($fTmpName, ".") + 1,
|
|
|
59 |
strlen($fTmpName) );
|
|
|
60 |
|
|
|
61 |
$fTmpLinkIcon = "../dokumente/gfx/fileicons/" . $dokumente[$i]["type"] .
|
|
|
62 |
".gif";
|
|
|
63 |
$fTmpIcon = "../dokumente/gfx/fileicons/" . $dokumente[$i]["type"] . ".gif";
|
|
|
64 |
|
|
|
65 |
$fTmpSize = @filesize( $uploadPath . $fTmpName );
|
|
|
66 |
|
|
|
67 |
$dokumente[$i]["size"] = $fTmpSize > 1048576 ? round( $fTmpSize / 1048576, 2 ) .
|
|
|
68 |
" MB" : round( $fTmpSize / 1024, 2 ) . " KB";
|
|
|
69 |
$dokumente[$i]["icon"] = file_exists( $fTmpIcon ) ? $fTmpLinkIcon :
|
|
|
70 |
"../dokumente/gfx/fileicons/default.gif";
|
|
|
71 |
|
|
|
72 |
$dokumente[$i]["link"] = $dokPath . $zeile_d['document'];
|
|
|
73 |
$Felddaten = @explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
|
|
|
74 |
|
|
|
75 |
// $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;";
|
|
|
76 |
$dokumente[$i]["add"] = "window.open('dokumente.php?table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
|
|
|
77 |
"&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] . "&data_foreign=" .
|
|
|
78 |
$p_id . "#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
|
|
|
79 |
$dokumente[$i]["add_archive"] = "window.open('dokumente.php?table_foreign=" .
|
|
|
80 |
$moduleTyp[tool_name]['table_foreign'] . "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
|
|
|
81 |
"&data_foreign=" . $p_id .
|
|
|
82 |
"&mode=archiv#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
|
|
|
83 |
$dokumente[$i]["del"] = "window.open('dokumente.php?action=unlink&id=" . $zeile_d['id'] .
|
|
|
84 |
"&table_foreign=" . $moduleTyp[tool_name]['table_foreign'] . "&row_foreign=" .
|
|
|
85 |
$moduleTyp[tool_name]['row_foreign'] . "&data_foreign=" . $p_id .
|
|
|
86 |
"#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
|
|
|
87 |
//$onClick = $onSubmit;
|
|
|
88 |
|
|
|
89 |
// id table_foreign row_foreign id_foreign document
|
|
|
90 |
|
|
|
91 |
|
|
|
92 |
// Upload Verzeichnis
|
|
|
93 |
|
|
|
94 |
|
|
|
95 |
if ( !empty($Felddaten[0]) )
|
|
|
96 |
{
|
|
|
97 |
$dokumente[$i]["caption"] = $Felddaten[0] . " Nr.$docCount";
|
|
|
98 |
|
|
|
99 |
}
|
|
|
100 |
else
|
|
|
101 |
{
|
|
|
102 |
$dokumente[$i]["caption"] = "Dokument Nr. $docCount";
|
|
|
103 |
}
|
|
|
104 |
// Datumsangaben lesbar machen
|
|
|
105 |
if ( strpos($zeile_d['letzte_aenderung_am'], " ") )
|
|
|
106 |
{
|
|
|
107 |
$dokumente[$i]["letzte_aenderung_am"] = datetime2human( $zeile_d['letzte_aenderung_am'] );
|
|
|
108 |
}
|
|
|
109 |
else
|
|
|
110 |
{
|
|
|
111 |
$dokumente[$i]["letzte_aenderung_am"] = timestamp2human( $zeile_d['letzte_aenderung_am'] );
|
|
|
112 |
}
|
|
|
113 |
$dokumente[$i]["letzte_aenderung_von"] = $zeile_d["letzte_aenderung_von"];
|
|
|
114 |
$dokumente[$i]["status"] = $zeile_d["status"];
|
|
|
115 |
$i++;
|
|
|
116 |
$docCount++;
|
|
|
117 |
}
|
|
|
118 |
$res["dokumente"] = $dokumente;
|
|
|
119 |
}
|
|
|
120 |
else
|
|
|
121 |
{
|
|
|
122 |
$Felddaten = explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
|
|
|
123 |
$res["view"]["add"] = "window.open('dokumente.php?table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
|
|
|
124 |
"&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] . "&data_foreign=" .
|
|
|
125 |
$p_id . "#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
|
|
|
126 |
$res["view"]["add_archive"] = "window.open('dokumente.php?table_foreign=" .
|
|
|
127 |
$moduleTyp[tool_name]['table_foreign'] . "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
|
|
|
128 |
"&data_foreign=" . $p_id .
|
|
|
129 |
"&mode=archiv#', 'DokumentUpload', 'status, menubar, height=120, width=650');";
|
|
|
130 |
if ( !empty($Felddaten[0]) )
|
|
|
131 |
{
|
|
|
132 |
$res["view"]["caption"] = $Felddaten[0];
|
|
|
133 |
|
|
|
134 |
}
|
|
|
135 |
else
|
|
|
136 |
{
|
|
|
137 |
$res["view"]["caption"] = "Dokument";
|
|
|
138 |
}
|
|
|
139 |
}
|
|
|
140 |
}
|
|
|
141 |
return $res;
|
|
|
142 |
}
|
|
|
143 |
|
|
|
144 |
?>
|