By pipcourcoux - Mon Sep 02, 2019 11:29 am
- Mon Sep 02, 2019 11:29 am
#826289
I have been trying to find a way to do this for DAYS!!!
Someone please help, the below gets me as far as a link to the URL of the file which I can download but I want to use this as the image source in the output document so it displays as an image.
trigger to get file url:
Someone please help, the below gets me as far as a link to the URL of the file which I can download but I want to use this as the image source in the output document so it displays as an image.
trigger to get file url:
Code: Select all
$caseid = @=APPLICATION;
$query3 = "SELECT APP_DOC_UID, DOC_VERSION FROM APP_DOCUMENT WHERE APP_UID='$caseid' AND
APP_DOC_TYPE='INPUT' AND APP_DOC_STATUS='ACTIVE'";
$results = executeQuery($query3) or die("Error in query: $query3");
if (is_array($results) and count($results) > 0) {
$g = new G();
@@receiptUrl = ($g->is_https() ? 'https://': 'http://') . $_SERVER['HTTP_HOST'] .
'/sys' . @@SYS_SYS .'/'. @@SYS_LANG .'/'. @@SYS_SKIN . '/cases/cases_ShowDocument?a=' . $results[1]['APP_DOC_UID'] .
'&v='. $results[1]['DOC_VERSION'];
}
$fullfileurl = @=receiptUrl . ".jpg";
@@fullfileurl = $fullfileurl;
@@panelhtml = '<img src="' . $fullfileurl . '"></img>';
@@tablehtml = '<table background="' . $fullfileurl . '"><tr><td width="200" height="150"></td></tr></table>';