Automatic Send form to Joomla user?

Question

Hi there,

Here’s my second question, I find this one quite tricky!

I have a form module that displays a quote request beneath each article. Each article is linked to a specific (joomla) user with a unique email address, and that part is working fine.

Now, I’d like the request to be automatically forwarded to the (joomla) user of the corresponding page when a customer fills out and submits the form.

I know there’s a short code to retrieve the applicant’s email from the form, but is there also a way to pull the user’s email directly from the database?The email address must not be visible to the applicant; it should only be used for forwarding.

Is this possible? Right now, I’m still handling everything manually.

Looking forward to your response!

Best regards, Ron 😐👍

Max_admin · Accepted Answer

Hi Ron

I have tested this code in a PHP action and it will return the author email which you can use as {var:php_action_name}

// Load Joomla's Factory class
use Joomla\CMS\Factory;

// Get the application object
$app = Factory::getApplication();

// Get the input object to retrieve the article ID from the URL
$input = $app->input;

// Check if we're in an article view and get the article ID
$option = $input->getCmd('option');
$view = $input->getCmd('view');
$articleId = null;

if ($option === 'com_content' && $view === 'article') {
    $articleId = $input->getInt('id');
}

// If article ID is found, proceed to get the author's email
if ($articleId) {
    // Get the database object
    $db = Factory::getDbo();
    
    // Create a query to get the article's created_by field
    $query = $db->getQuery(true)
        ->select($db->quoteName('created_by'))
        ->from($db->quoteName('#__content'))
        ->where($db->quoteName('id') . ' = ' . (int)$articleId);
    
    $db->setQuery($query);
    $authorId = $db->loadResult();
    
    // If author ID is found, get the author's email
    if ($authorId) {
        $user = Factory::getUser($authorId);
        return $user->email;
    }
}
return "";

Forums

Automatic Send form to Joomla user?