//adding the attachment file to the db - saves the URL to it only
case 'addAttachmentFile':
$attachmentFile = new AttachmentFile();
$attachmentFile->attachmentID = $_GET['attachmentID'];
$attachmentFile->attachmentURL = $_GET['attachmentURL'];
try {
$attachmentFile->save();
echo $attachmentFile->primaryKey;
} catch (Exception $e) {
echo $e->getMessage();
}
break;
case 'deleteAttachment':
$attachment = new Attachment(new NamedArguments(array('primaryKey' => $_GET['attachmentID'])));
//first delete attachments
foreach ($attachment->getAttachmentFiles() as $attachmentFile) {
$attachmentFile->delete();
}
try {
$attachment->delete();
echo "Attachment successfully deleted";
} catch (Exception $e) {
echo $e->getMessage();
}
break;
case 'deleteAttachmentFile':
$attachmentFile = new AttachmentFile(new NamedArguments(array('primaryKey' => $_GET['attachmentFileID'])));
try {
$attachmentFile->delete();
echo "Attachment file successfully deleted";
} catch (Exception $e) {
public function removeLicense()
{
//delete all documents and associated expressions and SFX providers
$document = new Document();
foreach ($this->getDocuments() as $document) {
//delete all expressions and expression notes
$expression = new Expression();
foreach ($document->getExpressions() as $expression) {
$expressionNote = new ExpressionNote();
foreach ($expression->getExpressionNotes() as $expressionNote) {
$expressionNote->delete();
}
$expression->removeQualifiers();
$expression->delete();
}
$sfxProvider = new SFXProvider();
foreach ($document->getSFXProviders() as $sfxProvider) {
$sfxProvider->delete();
}
$signature = new Signature();
foreach ($document->getSignatures() as $signature) {
$signature->delete();
}
$document->delete();
}
//delete all attachments
$attachment = new Attachment();
foreach ($this->getAttachments() as $attachment) {
$attachmentFile = new AttachmentFile();
foreach ($attachment->getAttachmentFiles() as $attachmentFile) {
$attachmentFile->delete();
}
$attachment->delete();
}
$this->delete();
}
} else {
$sentDate = format_date($attachment->sentDate);
}
$attachmentText = nl2br($attachment->attachmentText);
echo "<tr>";
echo "<td>" . $sentDate . "</td>";
echo "<td><div id='attachment_short_" . $attachment->attachmentID . "'>" . substr($attachmentText, 0, 200);
if (strlen($attachmentText) > 200) {
echo "... <a href='javascript:showFullAttachmentText(\"" . $attachment->attachmentID . "\");'>more...</a>";
}
echo "</div>";
echo "<div id='attachment_full_" . $attachment->attachmentID . "' style='display:none'>" . $attachmentText;
echo " <a href='javascript:hideFullAttachmentText(\"" . $attachment->attachmentID . "\");'>less...</a>";
echo "</div>";
echo "</td>";
$attachmentFileArray = $attachment->getAttachmentFiles();
$attachmentFile = new AttachmentFile();
echo "<td>";
if (count($attachmentFileArray) == 0) {
echo "(none uploaded)<br />";
}
$i = 1;
foreach ($attachmentFileArray as $attachmentFile) {
echo "<a href='attachments/" . $attachmentFile->attachmentURL . "' target='_BLANK'>view attachment " . $i . "</a><br />";
$i++;
}
echo "</td>";
if ($user->canEdit()) {
echo "<td><a href='ajax_forms.php?action=getAttachmentForm&height=398&width=305&modal=true&licenseID=" . $licenseID . "&attachmentID=" . $attachment->attachmentID . "' class='thickbox' id='editAttachment'>edit</a> <a href='javascript:deleteAttachment(\"" . $attachment->attachmentID . "\");'>remove</a></td>";
}
echo "</tr>";
