//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>";