Mail Merge Reports

Hi,

The file "modules/DHA_PlantillasDocumentos/DHA_DocumentTemplatesCalculatedFields_base.php" should not be directly modified because it could be overwritten in future versions. The cf_image_file_path variable is added by default for Notes and Documents only. If a variable is required for images from another module, it should be created in its corresponding calculated fields file.

In your case, if the variable of the image path was created, and this variable is getting the correct value of the image path, and also the variable has been added in the template with the correct configuration (for example [a_sub1.cf_image_file_path;ope=changepic;default=current;adjust] ) probably it is because the substitution process cannot find the word image in which you should substitute that image. Any image should be added to the template, and right next to or below it the variable as described.

The example template "modules/DHA_PlantillasDocumentos/examples/Opportunities_Notes_and_Documents_Images.docx" is distributed with the component (works for Notes and Documents) and there you can see how it should be.

Regards

Hi,

Thanks for the quick reply.

I have the following custom code for the field fotografia_c in Contacts module. But still not working:

 ///////////////////////////////////////////////////////////////////////////////////////////////////
   protected function SetCalcFieldsDefs() {

      global $app_strings;

      $this->CalcFieldsDefs['image_file_path'] = array (
            'name' => 'image_file_path',
            'vname' => $this->translate('LBL_IMAGE_FILE_PATH', 'DHA_PlantillasDocumentos'),
            'type' => 'image_path',
            'help' => 'Attached image path (only if attached file type is image)',
      );  
   }

   ///////////////////////////////////////////////////////////////////////////////////////////////////
   function CalcFields() {
      parent::CalcFields(); 
      $this->SetCalcValue('image_file_path', $this->get_image_path()); 

   }

   ///////////////////////////////////////////////////////////////////////////////////////////////////   
   protected function get_image_path() {
      global $sugar_config;

      $image_path = '';
      $image_path_original = '';

      $mime_types = array("image/jpeg", "image/gif", "image/png", "image/tiff", "image/pjpeg", "image/x-png", "image/x-tiff");

      $mime_type = strtolower("image/jpeg");
      $id = $this->bean->fotografia_c;

      if (!in_array($mime_type, $mime_types)) {
         return '';
      }

      $image_path_original = "upload://{$id}";

      $templates_dir = $sugar_config['DHA_templates_dir'];
      $templates_dir = $this->Generate_Document_Instance->includeTrailingCharacter ($templates_dir, '/');
      if (!file_exists($templates_dir)) {
         return '';
      } 
      $image_ext = '';
      if ($mime_type == "image/jpeg" || $mime_type == "image/pjpeg")
         $image_ext = 'jpg';
      elseif ($mime_type == "image/gif")
         $image_ext = 'gif';
      elseif ($mime_type == "image/png" || $mime_type == "image/x-png")
         $image_ext = 'png';
      elseif ($mime_type == "image/tiff" || $mime_type == "image/x-tiff")
         $image_ext = 'tiff';

      $image_path = $templates_dir . $id . '.' . $image_ext;      

      if (copy ($image_path_original, $image_path)) {
         // $this->Generate_Document_Instance->temp_files[] = $image_path;  // esto es para que se borre automaticamente la imagen temporal cuando ya se ha generado el documento
         return $image_path; 
      }
      else {
         return '';
      }
   } 

Any thought?

Thanks for your help

The first thing to check is that the variable that has been created is correctly returning the path where the image is on disk. That is, in the template, instead of XX.cf_image_file_path;ope=changepic;default=current;adjust] try on [XX.cf_image_file_path] Where 'XX' is the name of the data set in which the variable is found.

If the variable is for Contacts module, there are already a calculated fields file provided with the component that should be extended: \custom\modules\Contacts\DHA_DocumentTemplatesCalculatedFields.php The new contact variables would be added there. A possible problem is that being in this case a file supplied by the component, maybe will be overrided in a future update.