[PipSqueak]

Hi

I got the following code to email the output document, but how do I attach the document name (CON_VALUE in "content" table) instead of attaching the 32 digit filename? Thanks

Code: Select all

if(@@approveInformation=='Approved'){

//Generate Letter
$outDocId = '6752319335b430af9290e98068848446';
PMFGenerateOutputDocument($outDocId);
$sqlScarta = "SELECT AD.APP_DOC_UID, C.CON_VALUE, AD.DOC_VERSION
FROM APP_DOCUMENT AD, CONTENT C 
WHERE AD.APP_UID = '".@@APPLICATION."' 
AND AD.DOC_UID = '".$outDocId."' 
AND AD.APP_DOC_UID = C.CON_ID 
AND C.CON_CATEGORY = 'APP_DOC_FILENAME' 
AND AD.DOC_VERSION = C.CON_PARENT
ORDER BY AD.DOC_VERSION DESC";
$result = executeQuery($sqlScarta);
$docId = $result[1]['APP_DOC_UID'];
$docVr = $result[1]['DOC_VERSION'];

//Split @@APPLICATION into 3 subdirectories to avoid the 32K file limits of Linux's ext3 file system e.g. /423/168/267/55cbb5e0751cd5037067960/ if the application id = 42316826755cbb5e0751cd5037067960
$dir1 = substr(@@APPLICATION, 0, 3);
$dir2 = substr(@@APPLICATION, 3, 3);
$dir3 = substr(@@APPLICATION, 6, 3);
$dir4 = substr(@@APPLICATION, 9, 23);
	
//Path to the PDF document
$Letter = PATH_DOCUMENT . $dir1."/".$dir2."/".$dir3."/".$dir4."/outdocs/". $docId . "_" . $docVr . ".pdf";

//Path to other attachments
$companyDetails = PATH_DATA_PUBLIC . @@PROCESS . PATH_SEP . 'something.pdf';
$capabilityStatement = PATH_DATA_PUBLIC . @@PROCESS . PATH_SEP . 'another.pdf';

//Array all the attachments
$aAttachFiles = array(
  $Letter,
  $companyDetails,
  $capabilityStatement
  );
  
  
//Send email to employee
$from = "accounts@freogroup.com.au";
$to = @@companyEmail;
$subject = "APPLICATION FOR A CREDIT ACCOUNT";
PMFSendMessage(@@APPLICATION, $from, $to, ' ', ' ', $subject, 'approved.html', array(), $aAttachFiles);

}

[amosbatto]

Do it this way:

Code: Select all

$letterFilename = $result[1]['CON_VALUE'];

//Array all the attachments
$aAttachFiles = array(
  $letterFilename => $Letter,
  basename($companyDetails) => $companyDetails,
  basename($capabilityStatement) => $capabilityStatement
);

See: http://wiki.processmaker.com/3.1/Proces ... sage.28.29

[PipSqueak]

Thanks! Works great!

By the way, I don't mind if you use my code for wiki PMFSendMessage attach output document. I had trouble getting the code on wiki to work, so had to modify it myself

[amosbatto]

Yes, that SQL query was ugly. I changed it in the wiki. Thanks.