Freemaker
Subject
| notification_text | document | result |
|---|---|---|
"Заявка выполнена. Заявка
<#if document.get(""Type"")??>
${document.get(""Type"")}
<#else></#if>
№ <#if document.get(""prjnumprist"")??>
${document.get(""prjnumprist"")}
<#else></#if>
<#if document.get(""prjnumcounter"")??>
${document.get(""prjnumcounter"")}
<#else></#if>
<#if document.get(""prjnumfin"")??>
${document.get(""prjnumfin"")}
<#else></#if>"
|
| Заявка выполнена. Заявка Отзыв доступа в СЭД №СЗ-8/182-2022 |
Body
| notification_text | document | result |
|---|---|---|
<#assign formula = ""select coalesce(empl, '') as empl
from (select
(select
string_agg(coalesce(substr(tfs.value, 1, strpos(tfs.value, '%') - 1),''),', ') as v
from tn_field
join tn_field_string tfs on tn_field.access_object_id = tfs.id
where tn_field.owner = {0} and (tn_field.cmjfield = 'servEmployee' or tn_field.cmjfield = 'servMassDepartment' or tn_field.cmjfield = 'servMassEmployee' or tn_field.cmjfield = 'servWhoWithAccess')) as empl) t"">
<#assign collection = session.findByQuery(formula, document.getId())>
<head><style>p { font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 10pt;}</style></head>
<body>
<p>Для:
<#list Sochi$Pkd.beardsTo() as beard>
${crudService.find(beard).getString(""orig_shortname"")}
<#if beard_has_next>,
<#else></#if>
</#list></p>
<p>
</p>
<p>Инициатор:
<#if Sochi$Pkd.nameFrom()??>
${Sochi$Pkd.nameFrom()}
<#else>
<#if Sochi$Pkd.beardFrom()??>
${crudService.find(Sochi$Pkd.beardFrom()).getString(""orig_shortname"")}
<#else></#if>
</#if>
</p>
<p></p>
<p>Работник по заявке:
<#if collection.get(0).getString(""empl"")??>
${collection.get(0).getString(""empl"")}
<#else></#if>
</p>
<p></p>
<p>Краткое содержание: заявка
<#if document.get(""Type"")??>
${document.get(""Type"")}
<#else></#if>
№
<#if document.get(""prjnumprist"")??>
${document.get(""prjnumprist"")}
<#else></#if>
<#if document.get(""prjnumcounter"")??>
${document.get(""prjnumcounter"")}
<#else></#if>
<#if document.get(""prjnumfin"")??>
${document.get(""prjnumfin"")}
<#else></#if>
от
<#if document.get(""regdate"")??>
<#assign d2 = document.get(""regdate"")?index_of(""-"")>
<#assign d0 = document.get(""regdate"")?last_index_of(""-"")>
<#assign dy = document.get(""regdate"")?substring(0,d2)>
<#assign dd = document.get(""regdate"")?substring(d0+1)>
<#assign dm = document.get(""regdate"")?substring(d2+1,d0)>
<#assign ddl = dd?length><#assign dml = dm?length>
<#if ddl??>
<#if ddl==2>
${dd}
<#else>
0${dd}
</#if>
<#else></#if>
.
<#if dml??>
<#if dml==2>
${dm}
<#else>
0${dm}
</#if>
<#else></#if>
.
<#if dy??>
${dy}
<#else></#if>
<#else></#if>
</p>
<p></p>
<p> Открыть заявку: <a href='${urlFormer.getUrl(""cm-sochi"", addressee.getId(), document.getId())}'>cсылка</a></p>
</body>"
|