public static function display_note($row, $nolink = false, $a=null,$view=false) {
$inline_img = '';
$link_href = '';
$link_img = '';
$icon = '';
$crypted = Utils_RecordBrowserCommon::get_value('utils_attachment',$row['id'],'crypted');
if(!$crypted || isset($_SESSION['client']['cp'.$row['id']])) {
$files = DB::GetAll('SELECT id, created_by, created_on, original, (SELECT count(*) FROM utils_attachment_download uad WHERE uaf.id=uad.attach_file_id) as downloads FROM utils_attachment_file uaf WHERE uaf.attach_id=%d AND uaf.deleted=0', array($row['id']));
foreach ($files as $f) {
$f_filename = DATA_DIR.'/Utils_Attachment/'.$row['id'].'/'.$f['id'];
if(file_exists($f_filename)) {
$filename = $f['original'];
$filetooltip = __('Filename: %s',array($filename)).'<br>'.__('File size: %s',array(filesize_hr($f_filename))).'<hr>'.
__('Last uploaded by %s', array(Base_UserCommon::get_user_label($f['created_by'], true))).'<br/>'.
__('On: %s',array(Base_RegionalSettingsCommon::time2reg($f['created_on']))).'<br/>'.
__('Number of downloads: %d',array($f['downloads']));
$view_link = '';
$lb = array();
$lb['aid'] = $row['id'];
$lb['crypted'] = $crypted;
$lb['original'] = $f['original'];
$lb['id'] = $f['id'];
$link_href = Utils_TooltipCommon::open_tag_attrs($filetooltip).' '.self::get_file_leightbox($lb,$view_link);
$link_img = Base_ThemeCommon::get_template_file('Utils_Attachment','z-attach.png');
if(Utils_AttachmentCommon::is_image($filename) && $view_link)
$inline_img .= '<hr><a href="'.$view_link.'" target="_blank"><img src="'.$view_link.'" style="max-width:700px" /></a><br>';
} else {
$filename = __('Missing file: %s',array($f_filename));
$link_href = Utils_TooltipCommon::open_tag_attrs($filename);
$link_img = Base_ThemeCommon::get_template_file('Utils_Attachment','z-attach-off.png');
}
if ($link_href)
$icon .= '<div class="file_link"><a '.$link_href.'><img src="'.$link_img.'"><span class="file_name">'.$filename.'</span></a></div>';
}
}
if($crypted) {
$text = false;
if(isset($_SESSION['client']['cp'.$row['id']])) {
$note_pass = $_SESSION['client']['cp'.$row['id']];
$decoded = Utils_AttachmentCommon::decrypt($row['note'],$note_pass);
if($decoded!==false) {
$text = $decoded;
Utils_WatchdogCommon::notified('utils_attachment', $row['id']); // notified only when decrypted
}
}
if($text===false) {
$text = '<div id="note_value_'.$row['id'].'"><a href="javascript:void(0);" onclick="utils_attachment_password(\''.Epesi::escapeJS(__('Password').':').'\',\''.Epesi::escapeJS(__('OK')).'\','.$row['id'].')" style="color:red">'.__('Note encrypted').'</a></div>';
$icon = '';
$files = array();
} else {
$text = Utils_BBCodeCommon::parse($text);
}
} else {
$text = $row['note'];
$text = Utils_BBCodeCommon::parse($text);
// mark as read all 'browsed' records
foreach (self::$mark_as_read as $note_id) {
Utils_WatchdogCommon::notified('utils_attachment', $note_id);
}
self::$mark_as_read = array();
}
$text = (!$view?'<b style="float:left;margin-right:30px;">'.$row['title'].'</b> ':'').$text.$icon.$inline_img;
if($row['sticky']) $text = '<img src="'.Base_ThemeCommon::get_template_file('Utils_Attachment','sticky.png').'" hspace=3 align="left"> '.$text;
return $text;
}
