Dear ProjeQtOr developers,

My team was frustrated because when a new version of a document was added to a document, the email they receive didn't include anything regarding the document version.

So I added a document version section in the code and I believe it's worth adding to original ProjeQtOr version.

In SqlElement.php, in getMailDetail() function, it should be added around line 5361, just before the line

if (isset ( $this->_Note ) and is_array ( $this->_Note )) {

The following code:

	// ADDITION BY papjul - Document Version details
    if (isset ( $this->_DocumentVersion ) and is_array ( $this->_DocumentVersion )) {
      $msg .= $rowStart . $sectionStart . i18n ( 'sectionDocumentVersion' ) . $sectionEnd . $rowEnd;
      $documentVersion = new DocumentVersion ();
      $documentVersions = $documentVersion->getSqlElementsFromCriteria ( array('idDocument' => $this->id), false, null, 'name desc' );
      foreach ( $documentVersions as $documentVersion ) {
		  $name = $documentVersion->name;
		  $versionDate = $documentVersion->versionDate;
          $msg .= $rowStart . $labelStart;
          $msg .= $name;
          $msg .= '
';
          $msg .= htmlFormatDateTime ( $versionDate );
          $msg .= $labelEnd . $fieldStart;
          $msg .= $documentVersion->fileName;
          $msg .= '
';
          $text = new Html2Text ( $documentVersion->description );
          $plainText = $text->getText ();
          if (mb_strlen ( $plainText ) > 10000) { // Should not send too long email
            $descriptionTruncated = nl2br ( mb_substr ( $plainText, 0, 10000 ) );
            $msg .= $descriptionTruncated;
          } else {
            $msg .= $documentVersion->description;
          }
          $msg .= $fieldEnd . $rowEnd;
      }
    }
	// End of ADDITION BY papjul - Document Version details