Actions
Feature #1255
closedQF: sendMail
Added by Carsten Rose over 8 years ago. Updated over 7 years ago.
Start date:
30.10.2015
Due date:
30.10.2015
% Done:
0%
Estimated time:
2.00 h
Discuss:
Prio Planung:
Vote:
Updated by Carsten Rose over 8 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
Updated by Carsten Rose over 8 years ago
- Precedes Feature #1256: QF: lookup added
Updated by Carsten Rose over 8 years ago
- Follows deleted (Feature #1252: QF: Editor)
Updated by Carsten Rose over 8 years ago
- Related to Feature #1257: QF: formAllowed added
Updated by Carsten Rose over 8 years ago
- Target version changed from 0.01 to 0.02
Updated by Carsten Rose over 8 years ago
- Precedes Feature #1248: QF: Upload added
Updated by Carsten Rose over 8 years ago
- Related to deleted (Feature #1257: QF: formAllowed)
Updated by Carsten Rose over 8 years ago
- Precedes deleted (Feature #1256: QF: lookup)
Updated by Carsten Rose over 8 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
Updated by Carsten Rose over 7 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> }
Updated by Elias Villiger over 7 years ago
- Priority changed from Normal to High
Updated by Carsten Rose over 7 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'
Updated by Carsten Rose over 7 years ago
- Precedes deleted (Feature #1248: QF: Upload)
Updated by Carsten Rose over 7 years ago
- Follows deleted (Feature #1256: QF: lookup)
Updated by Carsten Rose over 7 years ago
- Status changed from Ready to sync (develop) to Closed
Actions