You can use this code in a trigger:
Code: Select all
$outDocId = '2862978795bc32764032f25090467465'; // <--- Your output Document ID
$caseId = @@APPLICATION;
$aAttachFiles = array();
$g = new G();
$docQuery = "SELECT AD.APP_DOC_UID, AD.DOC_VERSION, C.CON_VALUE AS FILENAME FROM APP_DOCUMENT AD, CONTENT C WHERE AD.APP_UID='$caseId' AND AD.APP_DOC_STATUS='ACTIVE' AND
AD.APP_DOC_UID = C.CON_ID AND C.CON_CATEGORY = 'APP_DOC_FILENAME' AND AD.DOC_UID='$outDocId'";
$docs = executeQuery($docQuery);
if (is_array($docs)) {
foreach ($docs as $doc) {
$aAttachFiles[$doc['FILENAME'] . '.pdf'] = PATH_DOCUMENT . $g->getPathFromUID(@@APPLICATION) . PATH_SEP . "outdocs" . PATH_SEP . $doc['APP_DOC_UID'] . "_" . $doc['DOC_VERSION'] . ".pdf";
}
}
$to = 'test@domain.com';
$subject = "Test Email";
PMFSendMessage(@@APPLICATION, $from, $to, ' ', ' ', $subject, 'emailTemplate.html', '', $aAttachFiles);
Also you can use this code to include the uploaded documents with the generated document:
Code: Select all
$outDocId = '2862978795bc32764032f25090467465'; // <--- Your output Document ID
$caseId = @@APPLICATION;
$aAttachFiles = array();
$g = new G();
$docQuery = "SELECT AD.DOC_UID, AD.APP_DOC_UID, AD.DOC_VERSION, C.CON_VALUE AS FILENAME FROM APP_DOCUMENT AD, CONTENT C WHERE AD.APP_UID='$caseId' AND AD.APP_DOC_STATUS='ACTIVE' AND
AD.APP_DOC_UID = C.CON_ID AND C.CON_CATEGORY = 'APP_DOC_FILENAME'";
$docs = executeQuery($docQuery);
if (is_array($docs)) {
foreach ($docs as $doc) {
if($doc["DOC_UID"] == $outDocId) {
$aAttachFiles[$doc['FILENAME'] . '.pdf'] = PATH_DOCUMENT . $g->getPathFromUID(@@APPLICATION) . PATH_SEP . "outdocs" . PATH_SEP . $doc['APP_DOC_UID'] . "_" . $doc['DOC_VERSION'] . ".pdf";
} else {
$aAttachFiles[$doc['FILENAME']] = PATH_DOCUMENT . $g->getPathFromUID(@@APPLICATION) . PATH_SEP . "outdocs" . PATH_SEP . $doc['APP_DOC_UID'] . "_" . $doc['DOC_VERSION'];
}
}
}
$to = 'test@domain.com';
$subject = "Test Email";
PMFSendMessage(@@APPLICATION, $from, $to, ' ', ' ', $subject, 'emailTemplate.html', '', $aAttachFiles);