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; }