WHERE suggestionid = ?
|, undef, $max_date, $last_modif_by, $suggestion->{suggestionid});
}
+
}
+ $dbh->do( q|
+ INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('suggestions', 'NOTIFY_MANAGER', '', 'Notify manager of a suggestion', 0, "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email', 'default');
+ | );
+
# Always end with this (adjust the bug info)
SetVersion( $DBversion );
print "Upgrade to $DBversion done (Bug 23590 - Add lastmodificationby and lastmodificationdate to the suggestions table)\n";
- "Thank you,"
- ""
- "<<branches.branchname>>"
+
+ - module: suggestions
+ code: NOTIFY_MANAGER
+ branchcode: ""
+ name: "Notify manager of a suggestion"
+ is_html: 0
+ title: "A suggestion has been assigned to you"
+ message_transport_type: email
+ lang: default
+ content:
+ - "Dear [% borrower.firstname %] [% borrowers.surname %],"
+ - ""
+ - "A new suggestion has been assigned to you: [% suggestion.title %]."
+ - ""
+ - "Thank you,"
+ - ""
+ - "[% branch.branchname %]"
<br/>
<label for="notify">Notify manager:</label>
- <input type="checkbox" id="notify" name="notify" value="notify" disabled="disabled" title="A TO_PROCESS notice will be generated and send to the manager if a valid email address is defined. This can be checked if a new manager has been selected." />
+ <input type="checkbox" id="notify" name="notify" value="notify" disabled="disabled" title="A NOTIFY_MANAGER notice will be generated and send to the manager if a valid email address is defined. This can be checked if a new manager has been selected." />
</div>
</li>
</ol>
my $letter = C4::Letters::GetPreparedLetter(
module => 'suggestions',
- letter_code => 'TO_PROCESS',
+ letter_code => 'NOTIFY_MANAGER',
branchcode => $patron->branchcode,
lang => $patron->lang,
tables => {