CRM/Upgrade/4.5.beta2.msg_template/civicrm_msg_template.tpl

   1 {php}
   2   $dir = SMARTY_DIR . '/../../CRM/Upgrade/4.5.beta2.msg_template/message_templates/sample';
   3   $templates = array();
   4   foreach (preg_grep('/\.tpl$/', scandir($dir)) as $filename) {
   5     $templates[] = array('name' => basename($filename, '.tpl'), 'filename' => "$dir/$filename");
   6   }
   7   $this->assign('templates', $templates);
   8 {/php}
   9
  10 {foreach from=$templates item=tpl}
  11   {fetch assign=content file=$tpl.filename}
  12 INSERT INTO civicrm_msg_template
  13    (msg_title,  msg_subject, msg_text, msg_html, workflow_id, is_default, is_reserved) VALUES
  14     ('{$tpl.name} Template', '{$tpl.name}', '', '{$content|escape:"quotes"}' ,NULL, 1, 0);
  15 {/foreach}
  16
  17 {php}
  18   $dir = SMARTY_DIR . '/../../CRM/Upgrade/4.5.beta2.msg_template/message_templates';
  19   $templates = array();
  20   foreach (preg_grep('/\.tpl$/', scandir($dir)) as $filename) {
  21     $parts = explode('_', basename($filename, '.tpl'));
  22     $templates[] = array('type' => array_pop($parts), 'name' => implode('_', $parts), 'filename' => "$dir/$filename");
  23   }
  24   $this->assign('templates', $templates);
  25 {/php}
  26
  27 {foreach from=$templates item=tpl}
  28   {fetch assign=content file=$tpl.filename}
  29   SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = '{$tpl.name}';
  30   SELECT @content := msg_{$tpl.type} FROM civicrm_msg_template WHERE workflow_id = @workflow_id AND is_reserved = 1 LIMIT 1;
  31   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));
  32 {/foreach}