Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | {php} |
2 | $dir = SMARTY_DIR . '/../../CRM/Upgrade/4.3.alpha1.msg_template/message_templates'; | |
3 | $templates = array(); | |
4 | foreach (preg_grep('/\.tpl$/', scandir($dir)) as $filename) { | |
5 | $parts = explode('_', basename($filename, '.tpl')); | |
6 | $templates[] = array('type' => array_pop($parts), 'name' => implode('_', $parts), 'filename' => "$dir/$filename"); | |
7 | } | |
8 | $this->assign('templates', $templates); | |
9 | {/php} | |
10 | ||
11 | {foreach from=$templates item=tpl} | |
12 | {fetch assign=content file=$tpl.filename} | |
13 | SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = '{$tpl.name}'; | |
14 | SELECT @content := msg_{$tpl.type} FROM civicrm_msg_template WHERE workflow_id = @workflow_id AND is_reserved = 1 LIMIT 1; | |
15 | UPDATE civicrm_msg_template SET msg_{$tpl.type} = '{$content|escape:"quotes"}' WHERE workflow_id = @workflow_id AND (is_reserved = 1 OR (is_default = 1 AND msg_{$tpl.type} = @content)); | |
16 | {/foreach} |