Store mailscanner attachments only once

If you use the mailscanner in vtigercrm 6 you probably recognized every mail attachment is stored multiple times in documents.
This isn't necessary.

To modify this, please apply the following modification

Search

var $STORAGE_FOLDER = 'storage/mailscanner/';

Insert after

private $_notesId = array();

Search

function __CreateTicket($mailscanner, $mailrecord) {

Insert after

$this->_notesId = array();

Search

// Create document record
$document = new Documents();
$document->column_fields['notes_title']         = $filename;
$document->column_fields['filename']         = $filename;
$document->column_fields['filesize']         = mb_strlen($filecontent, '8bit');
$document->column_fields['filestatus']         = 1;
$document->column_fields['filelocationtype'] = 'I';
$document->column_fields['folderid']         = 1; // Default Folder
$document->column_fields['assigned_user_id'] = $userid;
$document->save('Documents');

replace these lines with

if(!isset($this->_notesId[$filename])) {
    // Create document record
    $document = new Documents();
    $document->column_fields['notes_title']         = $filename;
    $document->column_fields['filename']         = $filename;
    $document->column_fields['filesize']         = mb_strlen($filecontent, '8bit');
    $document->column_fields['filestatus']         = 1;
    $document->column_fields['filelocationtype'] = 'I';
    $document->column_fields['folderid']         = 1; // Default Folder
    $document->column_fields['assigned_user_id'] = $userid;
    $document->save('Documents');
 
    $this->_notesId[$filename] = $document->id;
} else {
    $document = CRMEntity::getInstance('Documents');
    $document->retrieve_entity_info($this->_notesId, 'Documents');
    $document->id = $this->_notesId[$filename];
}