main.attachments.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696
  1. <?php
  2. // Copyright (C) 2010-2015 Combodo SARL
  3. //
  4. // This file is part of iTop.
  5. //
  6. // iTop is free software; you can redistribute it and/or modify
  7. // it under the terms of the GNU Affero General Public License as published by
  8. // the Free Software Foundation, either version 3 of the License, or
  9. // (at your option) any later version.
  10. //
  11. // iTop is distributed in the hope that it will be useful,
  12. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  13. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  14. // GNU Affero General Public License for more details.
  15. //
  16. // You should have received a copy of the GNU Affero General Public License
  17. // along with iTop. If not, see <http://www.gnu.org/licenses/>
  18. class AttachmentPlugIn implements iApplicationUIExtension, iApplicationObjectExtension
  19. {
  20. protected static $m_bIsModified = false;
  21. public function OnDisplayProperties($oObject, WebPage $oPage, $bEditMode = false)
  22. {
  23. if ($this->GetAttachmentsPosition() == 'properties')
  24. {
  25. $this->DisplayAttachments($oObject, $oPage, $bEditMode);
  26. }
  27. }
  28. public function OnDisplayRelations($oObject, WebPage $oPage, $bEditMode = false)
  29. {
  30. if ($this->GetAttachmentsPosition() == 'relations')
  31. {
  32. $this->DisplayAttachments($oObject, $oPage, $bEditMode);
  33. }
  34. }
  35. public function OnFormSubmit($oObject, $sFormPrefix = '')
  36. {
  37. if ($this->IsTargetObject($oObject))
  38. {
  39. // For new objects attachments are processed in OnDBInsert
  40. if (!$oObject->IsNew())
  41. {
  42. self::UpdateAttachments($oObject);
  43. }
  44. }
  45. }
  46. protected function GetMaxUpload()
  47. {
  48. $iMaxUpload = ini_get('upload_max_filesize');
  49. if (!$iMaxUpload)
  50. {
  51. $sRet = Dict::S('Attachments:UploadNotAllowedOnThisSystem');
  52. }
  53. else
  54. {
  55. $iMaxUpload = utils::ConvertToBytes($iMaxUpload);
  56. if ($iMaxUpload > 1024*1024*1024)
  57. {
  58. $sRet = Dict::Format('Attachment:Max_Go', sprintf('%0.2f', $iMaxUpload/(1024*1024*1024)));
  59. }
  60. else if ($iMaxUpload > 1024*1024)
  61. {
  62. $sRet = Dict::Format('Attachment:Max_Mo', sprintf('%0.2f', $iMaxUpload/(1024*1024)));
  63. }
  64. else
  65. {
  66. $sRet = Dict::Format('Attachment:Max_Ko', sprintf('%0.2f', $iMaxUpload/(1024)));
  67. }
  68. }
  69. return $sRet;
  70. }
  71. public function OnFormCancel($sTempId)
  72. {
  73. // Delete all "pending" attachments for this form
  74. $sOQL = 'SELECT Attachment WHERE temp_id = :temp_id';
  75. $oSearch = DBObjectSearch::FromOQL($sOQL);
  76. $oSet = new DBObjectSet($oSearch, array(), array('temp_id' => $sTempId));
  77. while($oAttachment = $oSet->Fetch())
  78. {
  79. $oAttachment->DBDelete();
  80. // Pending attachment, don't mention it in the history
  81. }
  82. }
  83. public function EnumUsedAttributes($oObject)
  84. {
  85. return array();
  86. }
  87. public function GetIcon($oObject)
  88. {
  89. return '';
  90. }
  91. public function GetHilightClass($oObject)
  92. {
  93. // Possible return values are:
  94. // HILIGHT_CLASS_CRITICAL, HILIGHT_CLASS_WARNING, HILIGHT_CLASS_OK, HILIGHT_CLASS_NONE
  95. return HILIGHT_CLASS_NONE;
  96. }
  97. public function EnumAllowedActions(DBObjectSet $oSet)
  98. {
  99. // No action
  100. return array();
  101. }
  102. public function OnIsModified($oObject)
  103. {
  104. return self::$m_bIsModified;
  105. }
  106. public function OnCheckToWrite($oObject)
  107. {
  108. return array();
  109. }
  110. public function OnCheckToDelete($oObject)
  111. {
  112. return array();
  113. }
  114. public function OnDBUpdate($oObject, $oChange = null)
  115. {
  116. if ($this->IsTargetObject($oObject))
  117. {
  118. // Get all current attachments
  119. $oSearch = DBObjectSearch::FromOQL("SELECT Attachment WHERE item_class = :class AND item_id = :item_id");
  120. $oSet = new DBObjectSet($oSearch, array(), array('class' => get_class($oObject), 'item_id' => $oObject->GetKey()));
  121. while ($oAttachment = $oSet->Fetch())
  122. {
  123. $oAttachment->SetItem($oObject, true /*updateonchange*/);
  124. }
  125. }
  126. }
  127. public function OnDBInsert($oObject, $oChange = null)
  128. {
  129. if ($this->IsTargetObject($oObject))
  130. {
  131. self::UpdateAttachments($oObject, $oChange);
  132. }
  133. }
  134. public function OnDBDelete($oObject, $oChange = null)
  135. {
  136. if ($this->IsTargetObject($oObject))
  137. {
  138. $oSearch = DBObjectSearch::FromOQL("SELECT Attachment WHERE item_class = :class AND item_id = :item_id");
  139. $oSet = new DBObjectSet($oSearch, array(), array('class' => get_class($oObject), 'item_id' => $oObject->GetKey()));
  140. while ($oAttachment = $oSet->Fetch())
  141. {
  142. $oAttachment->DBDelete();
  143. }
  144. }
  145. }
  146. ///////////////////////////////////////////////////////////////////////////////////////////////////////
  147. //
  148. // Plug-ins specific functions
  149. //
  150. ///////////////////////////////////////////////////////////////////////////////////////////////////////
  151. protected function IsTargetObject($oObject)
  152. {
  153. $aAllowedClasses = MetaModel::GetModuleSetting('itop-attachments', 'allowed_classes', array('Ticket'));
  154. foreach($aAllowedClasses as $sAllowedClass)
  155. {
  156. if ($oObject instanceof $sAllowedClass)
  157. {
  158. return true;
  159. }
  160. }
  161. return false;
  162. }
  163. protected function GetAttachmentsPosition()
  164. {
  165. return MetaModel::GetModuleSetting('itop-attachments', 'position', 'relations');
  166. }
  167. var $m_bDeleteEnabled = true;
  168. public function EnableDelete($bEnabled)
  169. {
  170. $this->m_bDeleteEnabled = $bEnabled;
  171. }
  172. public function DisplayAttachments($oObject, WebPage $oPage, $bEditMode = false)
  173. {
  174. // Exit here if the class is not allowed
  175. if (!$this->IsTargetObject($oObject)) return;
  176. $oSearch = DBObjectSearch::FromOQL("SELECT Attachment WHERE item_class = :class AND item_id = :item_id");
  177. $oSet = new DBObjectSet($oSearch, array(), array('class' => get_class($oObject), 'item_id' => $oObject->GetKey()));
  178. if ($this->GetAttachmentsPosition() == 'relations')
  179. {
  180. $sTitle = ($oSet->Count() > 0)? Dict::Format('Attachments:TabTitle_Count', $oSet->Count()) : Dict::S('Attachments:EmptyTabTitle');
  181. $oPage->SetCurrentTab($sTitle);
  182. }
  183. $oPage->add_style(
  184. <<<EOF
  185. .attachment {
  186. display: inline-block;
  187. text-align:center;
  188. float:left;
  189. padding:5px;
  190. }
  191. .attachment:hover {
  192. background-color: #e0e0e0;
  193. }
  194. .attachment img {
  195. border: 0;
  196. }
  197. .attachment a {
  198. text-decoration: none;
  199. color: #1C94C4;
  200. }
  201. .btn_hidden {
  202. display: none;
  203. }
  204. .drag_in {
  205. -webkit-box-shadow:inset 0 0 10px 2px #1C94C4;
  206. box-shadow:inset 0 0 10px 2px #1C94C4;
  207. }
  208. #history .attachment-history-added {
  209. padding: 0;
  210. float: none;
  211. }
  212. EOF
  213. );
  214. $oPage->add('<fieldset>');
  215. $oPage->add('<legend>'.Dict::S('Attachments:FieldsetTitle').'</legend>');
  216. if ($bEditMode)
  217. {
  218. $sIsDeleteEnabled = $this->m_bDeleteEnabled ? 'true' : 'false';
  219. $iTransactionId = $oPage->GetTransactionId();
  220. $sClass = get_class($oObject);
  221. $sTempId = session_id().'_'.$iTransactionId;
  222. $sDeleteBtn = Dict::S('Attachments:DeleteBtn');
  223. $oPage->add_script(
  224. <<<EOF
  225. function RemoveAttachment(att_id)
  226. {
  227. $('#attachment_'+att_id).attr('name', 'removed_attachments[]');
  228. $('#display_attachment_'+att_id).hide();
  229. $('#attachment_plugin').trigger('remove_attachment', [att_id]);
  230. return false; // Do not submit the form !
  231. }
  232. EOF
  233. );
  234. $oPage->add('<span id="attachments">');
  235. while ($oAttachment = $oSet->Fetch())
  236. {
  237. $iAttId = $oAttachment->GetKey();
  238. $oDoc = $oAttachment->Get('contents');
  239. $sFileName = $oDoc->GetFileName();
  240. $sIcon = utils::GetAbsoluteUrlAppRoot().AttachmentPlugIn::GetFileIcon($sFileName);
  241. $sPreview = $oDoc->IsPreviewAvailable() ? 'true' : 'false';
  242. $sDownloadLink = utils::GetAbsoluteUrlAppRoot().'pages/ajax.render.php?operation=download_document&class=Attachment&id='.$iAttId.'&field=contents';
  243. $oPage->add('<div class="attachment" id="display_attachment_'.$iAttId.'"><a data-preview="'.$sPreview.'" href="'.$sDownloadLink.'"><img src="'.$sIcon.'"><br/>'.$sFileName.'<input id="attachment_'.$iAttId.'" type="hidden" name="attachments[]" value="'.$iAttId.'"/></a><br/>&nbsp;<input id="btn_remove_'.$iAttId.'" type="button" class="btn_hidden" value="Delete" onClick="RemoveAttachment('.$iAttId.');"/>&nbsp;</div>');
  244. }
  245. // Suggested attachments are listed here but treated as temporary
  246. $aDefault = utils::ReadParam('default', array(), false, 'raw_data');
  247. if (array_key_exists('suggested_attachments', $aDefault))
  248. {
  249. $sSuggestedAttachements = $aDefault['suggested_attachments'];
  250. if (is_array($sSuggestedAttachements))
  251. {
  252. $sSuggestedAttachements = implode(',', $sSuggestedAttachements);
  253. }
  254. $oSearch = DBObjectSearch::FromOQL("SELECT Attachment WHERE id IN($sSuggestedAttachements)");
  255. $oSet = new DBObjectSet($oSearch, array());
  256. if ($oSet->Count() > 0)
  257. {
  258. while ($oAttachment = $oSet->Fetch())
  259. {
  260. // Mark the attachments as temporary attachments for the current object/form
  261. $oAttachment->Set('temp_id', $sTempId);
  262. $oAttachment->DBUpdate();
  263. // Display them
  264. $iAttId = $oAttachment->GetKey();
  265. $oDoc = $oAttachment->Get('contents');
  266. $sFileName = $oDoc->GetFileName();
  267. $sIcon = utils::GetAbsoluteUrlAppRoot().AttachmentPlugIn::GetFileIcon($sFileName);
  268. $sDownloadLink = utils::GetAbsoluteUrlAppRoot().'pages/ajax.render.php?operation=download_document&class=Attachment&id='.$iAttId.'&field=contents';
  269. $sPreview = $oDoc->IsPreviewAvailable() ? 'true' : 'false';
  270. $oPage->add('<div class="attachment" id="display_attachment_'.$iAttId.'"><a data-preview="'.$sPreview.'" href="'.$sDownloadLink.'"><img src="'.$sIcon.'"><br/>'.$sFileName.'<input id="attachment_'.$iAttId.'" type="hidden" name="attachments[]" value="'.$iAttId.'"/></a><br/>&nbsp;<input id="btn_remove_'.$iAttId.'" type="button" class="btn_hidden" value="Delete" onClick="RemoveAttachment('.$iAttId.');"/>&nbsp;</div>');
  271. $oPage->add_ready_script("$('#attachment_plugin').trigger('add_attachment', [$iAttId, '".addslashes($sFileName)."']);");
  272. }
  273. }
  274. }
  275. $oPage->add('</span>');
  276. $oPage->add('<div style="clear:both"></div>');
  277. $sMaxUpload = $this->GetMaxUpload();
  278. $oPage->p(Dict::S('Attachments:AddAttachment').'<input type="file" name="file" id="file"><span style="display:none;" id="attachment_loading">&nbsp;<img src="../images/indicator.gif"></span> '.$sMaxUpload);
  279. $oPage->add_linked_script(utils::GetAbsoluteUrlAppRoot().'js/jquery.iframe-transport.js');
  280. $oPage->add_linked_script(utils::GetAbsoluteUrlAppRoot().'js/jquery.fileupload.js');
  281. $oPage->add_ready_script(
  282. <<< EOF
  283. $('#file').fileupload({
  284. url: GetAbsoluteUrlModulesRoot()+'itop-attachments/ajax.attachment.php',
  285. formData: { operation: 'add', temp_id: '$sTempId', obj_class: '$sClass' },
  286. dataType: 'json',
  287. pasteZone: null, // Don't accept files via Chrome's copy/paste
  288. done: function (e, data) {
  289. if(typeof(data.result.error) != 'undefined')
  290. {
  291. if(data.result.error != '')
  292. {
  293. alert(data.result.error);
  294. }
  295. else
  296. {
  297. var sDownloadLink = GetAbsoluteUrlAppRoot()+'pages/ajax.render.php?operation=download_document&class=Attachment&id='+data.result.att_id+'&field=contents';
  298. $('#attachments').append('<div class="attachment" id="display_attachment_'+data.result.att_id+'"><a data-preview="'+data.result.preview+'" href="'+sDownloadLink+'"><img src="'+data.result.icon+'"><br/>'+data.result.msg+'<input id="attachment_'+data.result.att_id+'" type="hidden" name="attachments[]" value="'+data.result.att_id+'"/></a><br/><input type="button" class="btn_hidden" value="{$sDeleteBtn}" onClick="RemoveAttachment('+data.result.att_id+');"/></div>');
  299. if($sIsDeleteEnabled)
  300. {
  301. $('#display_attachment_'+data.result.att_id).hover( function() { $(this).children(':button').toggleClass('btn_hidden'); } );
  302. }
  303. $('#attachment_plugin').trigger('add_attachment', [data.result.att_id, data.result.msg]);
  304. }
  305. }
  306. },
  307. start: function() {
  308. $('#attachment_loading').show();
  309. },
  310. stop: function() {
  311. $('#attachment_loading').hide();
  312. }
  313. });
  314. $(document).bind('dragover', function (e) {
  315. var bFiles = false;
  316. if (e.dataTransfer && e.dataTransfer.types)
  317. {
  318. for (var i = 0; i < e.dataTransfer.types.length; i++)
  319. {
  320. if (e.dataTransfer.types[i] == "application/x-moz-nativeimage")
  321. {
  322. bFiles = false; // mozilla contains "Files" in the types list when dragging images inside the page, but it also contains "application/x-moz-nativeimage" before
  323. break;
  324. }
  325. if (e.dataTransfer.types[i] == "Files")
  326. {
  327. bFiles = true;
  328. break;
  329. }
  330. }
  331. }
  332. if (!bFiles) return; // Not dragging files
  333. var dropZone = $('#file').closest('fieldset');
  334. if (!dropZone.is(':visible'))
  335. {
  336. // Hidden, but inside an inactive tab? Higlight the tab
  337. var sTabId = dropZone.closest('.ui-tabs-panel').attr('aria-labelledby');
  338. dropZone = $('#'+sTabId).closest('li');
  339. }
  340. timeout = window.dropZoneTimeout;
  341. if (!timeout) {
  342. dropZone.addClass('drag_in');
  343. } else {
  344. clearTimeout(timeout);
  345. }
  346. window.dropZoneTimeout = setTimeout(function () {
  347. window.dropZoneTimeout = null;
  348. dropZone.removeClass('drag_in');
  349. }, 300);
  350. });
  351. EOF
  352. );
  353. $oPage->p('<span style="display:none;" id="attachment_loading">Loading, please wait...</span>');
  354. $oPage->p('<input type="hidden" id="attachment_plugin" name="attachment_plugin"/>');
  355. if ($this->m_bDeleteEnabled)
  356. {
  357. $oPage->add_ready_script('$(".attachment").hover( function() {$(this).children(":button").toggleClass("btn_hidden"); } );');
  358. }
  359. }
  360. else
  361. {
  362. $oPage->add('<span id="attachments">');
  363. if ($oSet->Count() == 0)
  364. {
  365. $oPage->add(Dict::S('Attachments:NoAttachment'));
  366. }
  367. else
  368. {
  369. while ($oAttachment = $oSet->Fetch())
  370. {
  371. $iAttId = $oAttachment->GetKey();
  372. $oDoc = $oAttachment->Get('contents');
  373. $sFileName = $oDoc->GetFileName();
  374. $sIcon = utils::GetAbsoluteUrlAppRoot().AttachmentPlugIn::GetFileIcon($sFileName);
  375. $sPreview = $oDoc->IsPreviewAvailable() ? 'true' : 'false';
  376. $sDownloadLink = utils::GetAbsoluteUrlAppRoot().'pages/ajax.render.php?operation=download_document&class=Attachment&id='.$iAttId.'&field=contents';
  377. $oPage->add('<div class="attachment" id="attachment_'.$iAttId.'"><a data-preview="'.$sPreview.'" href="'.$sDownloadLink.'"><img src="'.$sIcon.'"><br/>'.$sFileName.'</a><input type="hidden" name="attachments[]" value="'.$iAttId.'"/><br/>&nbsp;&nbsp;</div>');
  378. }
  379. }
  380. $oPage->add('</span>');
  381. }
  382. $oPage->add('</fieldset>');
  383. $sPreviewNotAvailable = addslashes(Dict::S('Attachments:PreviewNotAvailable'));
  384. $iMaxWidth = MetaModel::GetModuleSetting('itop-attachments', 'preview_max_width', 290);
  385. $oPage->add_ready_script("$(document).tooltip({ items: '.attachment a', position: { my: 'left top', at: 'right top', using: function( position, feedback ) { $( this ).css( position ); }}, content: function() { if ($(this).attr('data-preview') == 'true') { return('<img style=\"max-width:{$iMaxWidth}px\" src=\"'+$(this).attr('href')+'\"></img>');} else { return '$sPreviewNotAvailable'; }}});");
  386. }
  387. protected static function UpdateAttachments($oObject, $oChange = null)
  388. {
  389. self::$m_bIsModified = false;
  390. if (utils::ReadParam('attachment_plugin', 'not-in-form') == 'not-in-form')
  391. {
  392. // Workaround to an issue in iTop < 2.0
  393. // Leave silently if there is no trace of the attachment form
  394. return;
  395. }
  396. $iTransactionId = utils::ReadParam('transaction_id', null);
  397. if (!is_null($iTransactionId))
  398. {
  399. $aActions = array();
  400. $aAttachmentIds = utils::ReadParam('attachments', array());
  401. $aRemovedAttachmentIds = utils::ReadParam('removed_attachments', array());
  402. // Get all current attachments
  403. $oSearch = DBObjectSearch::FromOQL("SELECT Attachment WHERE item_class = :class AND item_id = :item_id");
  404. $oSet = new DBObjectSet($oSearch, array(), array('class' => get_class($oObject), 'item_id' => $oObject->GetKey()));
  405. while ($oAttachment = $oSet->Fetch())
  406. {
  407. // Remove attachments that are no longer attached to the current object
  408. if (in_array($oAttachment->GetKey(), $aRemovedAttachmentIds))
  409. {
  410. $oAttachment->DBDelete();
  411. $aActions[] = self::GetActionChangeOp($oAttachment, false /* false => deletion */);
  412. }
  413. }
  414. // Attach new (temporary) attachements
  415. $sTempId = session_id().'_'.$iTransactionId;
  416. // The object is being created from a form, check if there are pending attachments
  417. // for this object, but deleting the "new" ones that were already removed from the form
  418. $sOQL = 'SELECT Attachment WHERE temp_id = :temp_id';
  419. $oSearch = DBObjectSearch::FromOQL($sOQL);
  420. foreach($aAttachmentIds as $iAttachmentId)
  421. {
  422. $oSet = new DBObjectSet($oSearch, array(), array('temp_id' => $sTempId));
  423. while($oAttachment = $oSet->Fetch())
  424. {
  425. if (in_array($oAttachment->GetKey(),$aRemovedAttachmentIds))
  426. {
  427. $oAttachment->DBDelete();
  428. // temporary attachment removed, don't even mention it in the history
  429. }
  430. else
  431. {
  432. $oAttachment->SetItem($oObject);
  433. $oAttachment->Set('temp_id', '');
  434. $oAttachment->DBUpdate();
  435. // temporary attachment confirmed, list it in the history
  436. $aActions[] = self::GetActionChangeOp($oAttachment, true /* true => creation */);
  437. }
  438. }
  439. }
  440. if (count($aActions) > 0)
  441. {
  442. foreach($aActions as $oChangeOp)
  443. {
  444. self::RecordHistory($oChange, $oObject, $oChangeOp);
  445. }
  446. self::$m_bIsModified = true;
  447. }
  448. }
  449. }
  450. /////////////////////////////////////////////////////////////////////////////////////////
  451. public static function GetFileIcon($sFileName)
  452. {
  453. $aPathParts = pathinfo($sFileName);
  454. switch($aPathParts['extension'])
  455. {
  456. case 'doc':
  457. case 'docx':
  458. $sIcon = 'doc.png';
  459. break;
  460. case 'xls':
  461. case 'xlsx':
  462. $sIcon = 'xls.png';
  463. break;
  464. case 'ppt':
  465. case 'pptx':
  466. $sIcon = 'ppt.png';
  467. break;
  468. case 'pdf':
  469. $sIcon = 'pdf.png';
  470. break;
  471. case 'txt':
  472. case 'text':
  473. $sIcon = 'txt.png';
  474. break;
  475. case 'rtf':
  476. $sIcon = 'rtf.png';
  477. break;
  478. case 'odt':
  479. $sIcon = 'odt.png';
  480. break;
  481. case 'ods':
  482. $sIcon = 'ods.png';
  483. break;
  484. case 'odp':
  485. $sIcon = 'odp.png';
  486. break;
  487. case 'html':
  488. case 'htm':
  489. $sIcon = 'html.png';
  490. break;
  491. case 'png':
  492. case 'gif':
  493. case 'jpg':
  494. case 'jpeg':
  495. case 'tiff':
  496. case 'tif':
  497. case 'bmp':
  498. $sIcon = 'image.png';
  499. break;
  500. case 'zip':
  501. case 'gz':
  502. case 'tgz':
  503. case 'rar':
  504. $sIcon = 'zip.png';
  505. break;
  506. default:
  507. $sIcon = 'document.png';
  508. break;
  509. }
  510. return 'env-'.utils::GetCurrentEnvironment()."/itop-attachments/icons/$sIcon";
  511. }
  512. /////////////////////////////////////////////////////////////////////////
  513. private static function RecordHistory($oChange, $oTargetObject, $oMyChangeOp)
  514. {
  515. if (!is_null($oChange))
  516. {
  517. $oMyChangeOp->Set("change", $oChange->GetKey());
  518. }
  519. $oMyChangeOp->Set("objclass", get_class($oTargetObject));
  520. $oMyChangeOp->Set("objkey", $oTargetObject->GetKey());
  521. $iId = $oMyChangeOp->DBInsertNoReload();
  522. }
  523. /////////////////////////////////////////////////////////////////////////
  524. private static function GetActionChangeOp($oAttachment, $bCreate = true)
  525. {
  526. $oBlob = $oAttachment->Get('contents');
  527. $sFileName = $oBlob->GetFileName();
  528. if ($bCreate)
  529. {
  530. $oChangeOp = new CMDBChangeOpAttachmentAdded();
  531. $oChangeOp->Set('attachment_id', $oAttachment->GetKey());
  532. $oChangeOp->Set('filename', $sFileName);
  533. }
  534. else
  535. {
  536. $oChangeOp = new CMDBChangeOpAttachmentRemoved();
  537. $oChangeOp->Set('filename', $sFileName);
  538. }
  539. return $oChangeOp;
  540. }
  541. }
  542. /**
  543. * Record the modification of a caselog (text)
  544. * since the caselog itself stores the history
  545. * of its entries, there is no need to duplicate
  546. * the text here
  547. *
  548. * @package iTopORM
  549. */
  550. class CMDBChangeOpAttachmentAdded extends CMDBChangeOp
  551. {
  552. public static function Init()
  553. {
  554. $aParams = array
  555. (
  556. "category" => "core/cmdb",
  557. "key_type" => "",
  558. "name_attcode" => "change",
  559. "state_attcode" => "",
  560. "reconc_keys" => array(),
  561. "db_table" => "priv_changeop_attachment_added",
  562. "db_key_field" => "id",
  563. "db_finalclass_field" => "",
  564. );
  565. MetaModel::Init_Params($aParams);
  566. MetaModel::Init_InheritAttributes();
  567. MetaModel::Init_AddAttribute(new AttributeExternalKey("attachment_id", array("targetclass"=>"Attachment", "allowed_values"=>null, "sql"=>"attachment_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_SILENT, "depends_on"=>array())));
  568. MetaModel::Init_AddAttribute(new AttributeString("filename", array("allowed_values"=>null, "sql"=>"filename", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  569. // Display lists
  570. MetaModel::Init_SetZListItems('details', array('attachment_id')); // Attributes to be displayed for the complete details
  571. MetaModel::Init_SetZListItems('list', array('attachment_id')); // Attributes to be displayed for a list
  572. }
  573. /**
  574. * Describe (as a text string) the modifications corresponding to this change
  575. */
  576. public function GetDescription()
  577. {
  578. // Temporary, until we change the options of GetDescription() -needs a more global revision
  579. $bIsHtml = true;
  580. $sResult = '';
  581. $sTargetObjectClass = 'Attachment';
  582. $iTargetObjectKey = $this->Get('attachment_id');
  583. $sFilename = htmlentities($this->Get('filename'), ENT_QUOTES, 'UTF-8');
  584. $oTargetSearch = new DBObjectSearch($sTargetObjectClass);
  585. $oTargetSearch->AddCondition('id', $iTargetObjectKey, '=');
  586. $oMonoObjectSet = new DBObjectSet($oTargetSearch);
  587. if ($oMonoObjectSet->Count() > 0)
  588. {
  589. $oAttachment = $oMonoObjectSet->Fetch();
  590. $oDoc = $oAttachment->Get('contents');
  591. $sPreview = $oDoc->IsPreviewAvailable() ? 'data-preview="true"' : '';
  592. $sResult = Dict::Format('Attachments:History_File_Added', '<span class="attachment-history-added attachment"><a '.$sPreview.' target="_blank" href="'.$oDoc->GetDownloadURL($sTargetObjectClass, $iTargetObjectKey, 'contents').'">'.$sFilename.'</a></span>');
  593. }
  594. else
  595. {
  596. $sResult = Dict::Format('Attachments:History_File_Added', '<span class="attachment-history-deleted">'.$sFilename.'</span>');
  597. }
  598. return $sResult;
  599. }
  600. }
  601. class CMDBChangeOpAttachmentRemoved extends CMDBChangeOp
  602. {
  603. public static function Init()
  604. {
  605. $aParams = array
  606. (
  607. "category" => "core/cmdb",
  608. "key_type" => "",
  609. "name_attcode" => "change",
  610. "state_attcode" => "",
  611. "reconc_keys" => array(),
  612. "db_table" => "priv_changeop_attachment_removed",
  613. "db_key_field" => "id",
  614. "db_finalclass_field" => "",
  615. );
  616. MetaModel::Init_Params($aParams);
  617. MetaModel::Init_InheritAttributes();
  618. MetaModel::Init_AddAttribute(new AttributeString("filename", array("allowed_values"=>null, "sql"=>"filename", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  619. // Display lists
  620. MetaModel::Init_SetZListItems('details', array('filename')); // Attributes to be displayed for the complete details
  621. MetaModel::Init_SetZListItems('list', array('filename')); // Attributes to be displayed for a list
  622. }
  623. /**
  624. * Describe (as a text string) the modifications corresponding to this change
  625. */
  626. public function GetDescription()
  627. {
  628. // Temporary, until we change the options of GetDescription() -needs a more global revision
  629. $bIsHtml = true;
  630. $sResult = Dict::Format('Attachments:History_File_Removed', '<span class="attachment-history-deleted">'.htmlentities($this->Get('filename'), ENT_QUOTES, 'UTF-8').'</span>');
  631. return $sResult;
  632. }
  633. }