Follow-up to #2854017: Provide a handler to schedule the sending of emails

Problem

Webform handlers execute transactions that should be optionally tracked with their results. For example, when a scheduled email is sent, the send date and time should be tracked to prevent duplicate emails. Another use case, would be the response from a remote post should be logged and tracked

Solution

Create a table to optionally log webform handler transactions.

Tasks

  • Add 'webform_submission_log' table
  • Update WebformSubmissionStorage class
  • Add log tab to submissions.
  • Only users with 'administer submission' permission can view logs.
  • Update TestHandler to log all requests.
  • Write tests

Database Changes

webform_submission_log

  • lid => 1 (key)
  • sid => 1
  • uid => NULL|1
  • type => scheduled_email
  • operation => cron
  • value => sent
  • timestamp => 1487024261
  • indexes: [sid] and [type, operation, value]
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jrockowitz created an issue. See original summary.

jrockowitz’s picture

Issue summary: View changes

  • jrockowitz committed d435730 on 2854020-log-transactions
    Issue #2854020: Provide a mechanism to log submission transactions.
    

  • jrockowitz committed f889f57 on 2854020-log-transactions
    Issue #2854020: Provide a mechanism to log submission transactions.
    

  • jrockowitz committed 58d0cef on 2854020-log-transactions
    Issue #2854020: Provide a mechanism to log submission transactions.
    

  • jrockowitz committed ad7cde3 on 2854020-log-transactions
    Issue #2854020: Provide a mechanism to log submission transactions....
jrockowitz’s picture

Status: Active » Needs review
FileSize
69.95 KB

  • jrockowitz committed 391fcc2 on 2854020-log-transactions
    Issue #2854020 by jrockowitz: Provide a mechanism to log submission...

  • jrockowitz committed 057d006 on 8.x-5.x
    Issue #2854020 by jrockowitz: Provide a mechanism to log submission...
jrockowitz’s picture

Status: Needs review » Fixed
kclarkson’s picture

Log submission looks great and definitely handy for confirming whether or not someone had an email sent.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.