How to Show Related Emails in Vtiger Compose Popup

971 Views

To show related emails in vtiger the popup for composeMailData, you will need to customize the functionality by modifying the code that controls the email popup and related data retrieval. Here’s a high-level guide on how to achieve this:

1. Locate the Compose Email Popup Code

The composeMailData popup in Vtiger is part of the Mail Manager module. You need to modify the code that renders the popup and fetches related data.

The relevant file for handling the email compose popup can be found in:

  modules/Emails/Emails.js

This file controls the JavaScript functionality for handling email popups and actions.

2. Modify the Backend Logic

In the backend, you’ll need to extend the logic to fetch related emails based on the context (e.g., related contact, organization, etc.). This can be done by modifying the controller that fetches email data.

Locate the file:

  modules/Emails/actions/ComposeEmail.php

This file handles the logic for fetching email data when opening the compose email popup.

Modify this file to include a function that queries related emails. For example, if you want to fetch emails related to a contact or an organization, you would perform a database query like:

  $relatedEmails = Vtiger_Record_Model::getRelatedEmails($recordId, $moduleName);

3. Create a Function to Retrieve Related Emails

You can write a custom function to retrieve the related emails based on the record ID or module (e.g., Contacts, Leads, etc.). For instance:

  public function getRelatedEmails($recordId, $moduleName) {
      $db = PearDatabase::getInstance();
      $query = "SELECT * FROM vtiger_emaildetails
                WHERE parent_id = ? AND parent_type = ?";
      $result = $db->pquery($query, array($recordId, $moduleName));

      $emails = array();
      while ($row = $db->fetch_array($result)) {
          $emails[] = $row;
      }

      return $emails;
  }

This function will return a list of emails related to the specific record.

4. Pass Related Emails to the Frontend

Once you have the related emails, pass them to the frontend by modifying the response that sends data to the composeMailData popup. You can include the list of emails as part of the response array:

  $viewer->assign('RELATED_EMAILS', $relatedEmails);

5. Display Related Emails in the Popup

In the frontend, modify the popup template to display the related emails. You can find the relevant template file in:

  layouts/v7/modules/Emails/ComposeEmail.tpl

Add a section in the template to display the related emails. For example:

  <div class="related-emails-section">
      <h4>Related Emails</h4>
      <ul>
          {foreach from=$RELATED_EMAILS item=email}
              <li>{$email.subject} - {$email.sentdate}</li>
          {/foreach}
      </ul>
  </div>

6. Test Your Changes

After making these modifications:

Clear the cache to ensure changes are reflected.
Test the email compose popup and check if the related emails are being displayed correctly.

Optional: Use Vtiger’s Widget for Related Records

If you want a more reusable solution, consider using Vtiger’s related record widgets to display related emails. This would involve utilizing Vtiger’s built-in functionality to show related records in popups.

By following these steps, you can customize the Vtiger system to show related emails in the compose email popup.

Conclusion

If you want to show all related emails in the vtiger then the popup, especially for composeMailData, you just want to tailor the working by simply making little changes in the code that simply controls the email popup and all associated data retrieval. By having the best Vtiger hosting solutions, follow the above-mentioned steps to make changes.