You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
126 lines
4.0 KiB
126 lines
4.0 KiB
<?php
|
|
|
|
/*********************************************************************************
|
|
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
*
|
|
********************************************************************************/
|
|
|
|
require_once('include/database/PearDatabase.php');
|
|
|
|
//or die("Couldn't connect to database $dbDatabase");
|
|
//function getAttachmentsList($id,$theme)
|
|
function getAttachmentsList($id,$theme,$returnmodule,$returnaction)
|
|
{
|
|
|
|
global $app_strings,$adb;
|
|
|
|
if($returnmodule == 'HelpDesk')
|
|
{
|
|
$dbQuery = "select fileid,filename,filesize,filetype,description from ticket_attachment where parent_id='".$id ."' ORDER BY filename ASC" ;
|
|
}
|
|
else
|
|
{
|
|
|
|
$dbQuery = "SELECT fileid, filename,filesize,filetype,description ";
|
|
|
|
$dbQuery .= "FROM filestorage where parent_id='".$id ."'" ;
|
|
|
|
$dbQuery .= " ORDER BY filename ASC";
|
|
}
|
|
|
|
//echo $dbQuery;
|
|
|
|
$result = $adb->query($dbQuery) or die("Couldn't get file list");
|
|
|
|
//$list = '<br><br>';
|
|
//$list .= '<table width="100%" cellpadding="0" cellspacing="0" border="0"><tbody><tr>';
|
|
//$list .= '<td vAlign="middle" class="formHeader" align="left" noWrap width="100%" height="15">Attachment</td></tr></tbody></table>';
|
|
|
|
$list = '<table border="0" cellpadding="0" cellspacing="0" class="FormBorder" width="100%">';
|
|
$list .= '<tr class="ModuleListTitle" height=20>';
|
|
$list .= '<td>'.$app_strings['LBL_OPERATION'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= ' ';
|
|
|
|
$list .= '<td class="moduleListTitle" height="21">';
|
|
|
|
$list .= '<p style="margin-left: 10">';
|
|
|
|
$list .= $app_strings['LBL_FILENAME'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td width="15%" class="moduleListTitle">';
|
|
|
|
$list .= '<p style="margin-left: 10">';
|
|
|
|
$list .= $app_strings['LBL_UPD_DESC'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td width="15%" class="moduleListTitle">';
|
|
|
|
$list .= '<p style="margin-left: 10">';
|
|
|
|
|
|
$list .= $app_strings['LBL_TYPE'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td class="moduleListTitle" >';
|
|
|
|
$list .= '<p style="margin-left: 10">';
|
|
|
|
$list .= $app_strings['LBL_FILE'].'</td>';
|
|
|
|
$list .= '</tr>';
|
|
|
|
$list .= '<tr><td COLSPAN="9" class="blackLine"><IMG SRC="themes/'.$theme.'/images//blank.gif"></td></tr>';
|
|
|
|
$i=1;
|
|
while($row = $adb->fetch_array($result))
|
|
{
|
|
|
|
|
|
if ($i%2==0)
|
|
$trowclass = 'evenListRow';
|
|
else
|
|
$trowclass = 'oddListRow';
|
|
$list .= '<tr class="'. $trowclass.'"><td><a href="index.php?module=uploads&action=deleteattachments&return_module='.$returnmodule.'&return_action='.$returnaction.'&filename='.$row["filename"] .'&record='.$_REQUEST["record"] .'">Del</td><td></td> <td width="34%" height="21" style="padding:0px 3px 0px 3px;"><p style="margin-left: 10; margin-right: 10">';
|
|
|
|
$list .= $row["filename"];
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td></td><td width="33%" height="21" style="padding:0px 3px 0px 3px;"> <p style="margin-left: 10">';
|
|
|
|
$list .= $row["description"];
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td></td><td width="33%" height="21" style="padding:0px 3px 0px 3px;"> <p style="margin-left: 10">';
|
|
|
|
$list .= $row["filetype"];
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td></td><td width="33%" height="21" style="padding:0px 3px 0px 3px;"><p style="margin-left: 10">';
|
|
|
|
if($returnmodule == 'HelpDesk')
|
|
$list .= '<a href="index.php?module=uploads&action=downloadfile&return_module=HelpDesk&fileId='.$row['fileid'].'">';
|
|
else
|
|
$list .= '<a href="index.php?module=uploads&action=downloadfile&fileId='.$row['fileid'] .'">';
|
|
|
|
$list .= $app_strings['LBL_DOWNLOAD'];
|
|
|
|
$list .= '</a></td></tr>';
|
|
$i++;
|
|
}
|
|
|
|
$list .= '</table>';
|
|
|
|
return $list;
|
|
}
|
|
?>
|
|
|