/** Funtion to add the user's signature with the content passed
* $contents -- where we want to add the signature
* $fromname -- which user's signature will be added to the contents
*/
function addSignature($contents, $fromname)
{
$adb = PearDatabase::getInstance();
$adb->println("Inside the function addSignature");
$sign = VTCacheUtils::getUserSignature($fromname);
if ($sign === null) {
$result = $adb->pquery("select signature, first_name, last_name from vtiger_users where user_name=?", array($fromname));
$sign = $adb->query_result($result, 0, "signature");
VTCacheUtils::setUserSignature($fromname, $sign);
VTCacheUtils::setUserFullName($fromname, $adb->query_result($result, 0, "first_name") . ' ' . $adb->query_result($result, 0, "last_name"));
}
$sign = nl2br($sign);
if ($sign != '') {
$contents .= '<br><br>' . $sign;
$adb->println("Signature is added with the body => '." . $sign . "'");
} else {
$adb->println("Signature is empty for the user => '" . $fromname . "'");
}
return $contents;
}
