Project

General

Profile

Feature #1255

QF: sendMail

Added by Carsten Rose almost 5 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Target version:
Start date:
30.10.2015
Due date:
30.10.2015
% Done:

0%

Estimated time:
2.00 h
Discuss:

History

#1 Updated by Carsten Rose almost 5 years ago

  • Due date set to 04.11.2015
  • Start date changed from 19.10.2015 to 04.11.2015
  • Follows Feature #1252: QF: Editor added

#2 Updated by Carsten Rose almost 5 years ago

#3 Updated by Carsten Rose almost 5 years ago

#4 Updated by Carsten Rose almost 5 years ago

#5 Updated by Carsten Rose almost 5 years ago

  • Estimated time set to 2.00 h

#6 Updated by Carsten Rose almost 5 years ago

  • Target version changed from 0.01 to 0.02

#7 Updated by Carsten Rose almost 5 years ago

#8 Updated by Carsten Rose almost 5 years ago

#9 Updated by Carsten Rose almost 5 years ago

#10 Updated by Carsten Rose almost 5 years ago

  • Due date changed from 05.11.2015 to 09.11.2015
  • Start date changed from 05.11.2015 to 09.11.2015
  • Follows Feature #1256: QF: lookup added

#11 Updated by Carsten Rose almost 4 years ago

  • File sendmail.pdf added

Folger code erzeugt einen Feher:

# Preview/Execute any sendMails
10 {
  sql = SELECT '<b>To:</b>', 'valid_email@gmail.com' AS receiver,
            '<br><b>From:</b> ', IF(feAddr.eMail = '', 'do-not-reply@geo.uzh.ch', feAddr.EMail) AS sender,
            '<br><b>Subject:</b>', 'GIUZ Account Request' AS subject,
            '<br><b>Text:</b> ', CONCAT('Dear IT staff\n\nWe would like to request a new GIUZ account with the following data:\n\nPersonal Data of Account Holder:',
              '\n- Geolean Id: ', p.id,
              '\n- First Name: ', p.firstName,
              '\n- Last Name: ', p.lastName,
              '\n- Contact E-Mail: ', addr.eMail,
              '\n- Matrikel Number: -',
              '\n\nAccount Details:',
              '\n- Valid from (YYYY-MM-DD): ', pf.start,
              '\n- Valid until (YYYY-MM-DD): ', pf.end) AS text
          FROM person AS p
          LEFT JOIN address AS addr ON addr.pId = p.id AND addr.eMail <> ''
          LEFT JOIN persFunction AS pf ON pf.pId = p.id
          LEFT JOIN account AS acct ON acct.username='{{feUser:T0}}'
          LEFT JOIN address AS feAddr ON feAddr.pId = acct.pId AND feAddr.isPrimary = 'true'
          WHERE '{{sendMail:CE:alnumx}}' = 'requestGiuzAccount' AND p.id = '{{pId:CE:digit}}'
          GROUP BY p.id

  # Preview mode
  10 {
    sql = SELECT "<br><br><form action='index.php'><input name='id' value='{{pageId:T}}' type='hidden'><input name='sendMail' value='requestGiuzAccount' type='hidden'><input name='pId' value='{{pId:C0}}' type='hidden'><input name='mode' value='send' type='hidden'><input type='button' value='Send E-Mail' onclick='this.form.submit();'></form>" 
             FROM (SELECT '_') AS dummyTable WHERE '{{mode:CE:alnumx}}' = 'preview'
  }

  # Send mode
  20 {
    sql = SELECT '{{10.receiver}}|{{10.sender}}|{{10.subject}}|{{10.text}}' AS _sendmail
             FROM (SELECT '_') AS dummyTable WHERE '{{mode:CE:alnumx}}' = 'send'

    10.sql = SELECT '<br><br><b>Email was sent.</b>'
  }
}

20 {
  sql = SELECT wi.id, wi.start, CONCAT('s|c:n|p:persondetail&form=person&r=', p.id, '|t:', p.lastName, ', ', p.firstName) AS _link,
           CONCAT("<form action='index.php'><input name='id' value='{{pageId:T}}' type='hidden'><input name='sendMail' value='requestGiuzAccount' type='hidden'><input name='pId' value='", p.id, "' type='hidden'><input name='mode' value='preview' type='hidden'><input type='button' value='Preview E-Mail' onclick='this.form.submit();'></form>")
           FROM gGroupMember AS wi
           INNER JOIN person AS p ON wi.xId = p.id
           LEFT JOIN gGroup AS td ON name='workflowTodo' AND value='Status' AND gType='property'
           LEFT JOIN gGroupMember AS cell ON cell.xId = wi.id AND cell.grId=219 AND cell.grId2=td.id
           LEFT JOIN gGroup AS st ON cell.xId2 = st.id AND st.value='Archived'
           WHERE wi.grId = 220 AND wi.grId2 = 24 /*Employment Workflow*/ AND st.id IS NULL
             AND '{{sendMail:CE:alnumx}}' = ''
           ORDER BY wi.start
  head = <table class='table table-condensed table-hover'><tr><th>Id</th><th>Start Date</th><th>Employee</th><th>Request GIUZ Account</th></tr>
  tail = </table>
  rbeg = <tr>
  renr = </tr>
  fbeg = <td>
  fend = </td>
}

#12 Updated by Elias Villiger almost 4 years ago

  • Priority changed from Normal to High

#13 Updated by Carsten Rose over 3 years ago

  • Status changed from New to Ready to sync (develop)
  • Priority changed from High to Normal
  • Target version changed from 0.02 to 0.08
10.sql = SELECT "hello", 'carsten.rose@math.uzh.ch|support@math.uzh.ch|My Subject, first 10|My Body|noreply@math.uzh.ch|on|1|2|root@math.uzh.ch|carsten@5rose.ch' AS sendmail, ' - Mail gesendet'

#14 Updated by Carsten Rose over 3 years ago

#15 Updated by Carsten Rose over 3 years ago

#16 Updated by Carsten Rose over 3 years ago

#17 Updated by Carsten Rose over 3 years ago

  • Status changed from Ready to sync (develop) to Closed

#18 Updated by Elias Villiger almost 3 years ago

  • File deleted (sendmail.pdf)

Also available in: Atom PDF