HTML Body:
<title>Satınalma Teklif</title>
<style>
table,
th,
td {
font-family: Calibri;
border-collapse: collapse;
border: 1px solid black;
letter-spacing: 0px;
font-size: 0.6rem;
}
</style>
<p>
<strong>Teklif Tarih:</strong> {DocDate} <br />
<strong>Teklif No:</strong> {DocNo}
</p>
<p>
<strong>Aşağıda belirtilen ürün/hizmet talebimiz ile ilgili teklif dönüşünüzü bekliyoruz.</strong>
</p>
<table>
<tbody>
<tr style="background-color:#48c9b0;">
<th style="text-align:left;">
<strong> Malzeme/Ürün Adı </strong>
</th>
<th style="text-align:left;">
<strong> Açıklama </strong>
</th>
<th>
<strong> Miktar </strong>
</th>
<th>
<strong> Birim </strong>
</th>
<th>
<strong> Talep No </strong>
</th>
<th>
<strong> Talep Ek Dosya </strong>
</th>
</tr>
<!--Detail Start-->
<tr style="text-decoration: none">
<td style="text-align:left;"> {OfferDCollection.DcardName} </td>
<td style="text-align:left;"> {OfferDCollection.Note1} </td>
<td style="text-align:center;"> {OfferDCollection.Qty|#,##} </td>
<td style="text-align:center;"> {OfferDCollection.UnitCode} </td>
<td style="text-align:center;"> {OfferDCollection.RequestDocNo} </td>
<td style="text-align:right;">
<a href="{fn_ExecuteSQL(SELECT 'http://oratest.ofis.uyumcloud.com/fileuploads/' || LONG_FILE_NAME AS FILEURL FROM GNLD_UPLOAD_FILE WHERE RELATION_OBJECT = 666575451 AND RELATION_ID = [OfferDCollection.SourceMId])}">Gözat</a>
</td>
</tr>
<!--Detail End-->
</tbody>
</table>
<p>
<strong>Açıklamalar:</strong>
<br /> {Note1} {Note2} {Note3}
</p>
<hr />
<div>
<img src="https://www.uyumsoft.com/wp/wp-content/uploads/2019/11/uyum-logo.png" alt="https://www.uyumsoft.com" style="display: block !important;" width="160" />
</div>
<p> Satınalma Ekibi </p>
Konu: {DocNo} Numaralı Teklif Talebi
Koşul: {ItemDCollection.ForTransfer} = True and {Note1} LIKE 'Y-M-D*'
Tarih Format: {fn_Expression(SUBSTRING('[DeliveryDate]',1,10))}
Bölme İşlemi: {fn_Expression(Convert([OrderDCollection.AmtWithDiscTra] / [OrderDCollection.Qty]*100,'System.Int32')/100)}
fn: {fn_ExecuteSQL(SELECT US.EMAIL FROM PSMT_ORDER_M M LEFT JOIN USERS US ON M.CREATE_USER_ID = US.US_ID WHERE M.ORDER_M_ID = [Id])}
fn Where: {fn_ExecuteSQL(SELECT CU.CUR_CODE || '-' || EB.IBAN_NO || '-' || BC.BANK_DESC FROM FIND_ENTITY_BANK EB LEFT JOIN FIND_BANK_CARD BC ON EB.BANK_ID = BC.BANK_ID LEFT JOIN GNLD_CURRENCY CU ON EB.CUR_TRA_ID = CU.CUR_ID WHERE EB.ENTITY_ID =[EntityId])}
IF: {fn_Expression(IIF('[CountryName]'='TÜRKİYE','Müşteri Adı','Acount'))
Sayı Format: {ItemDCollection.QtyPrm|#,##}
Miktar: {{#Qty#|#,##0.00}}
fn_GetMailFromSQL: {fn_GetMailFromSQL(SELECT FE.EMAIL FROM FIND_ENTITY FE WHERE FE.ENTITY_ID = #EntityId#)};
Kime Gizli: aaa@aaa.com|bbb@bbb.com
Onay Mesaj bazı farklılıklar:
Sayı Format: {{#D.AmtTra#|#,##0.00}}
fn Where: {{fn_ExecuteSQL( SELECT AMT_RECEIPT_TRA AS AMT FROM PSMT_ORDER_M WHERE ORDER_M_ID = '#SourceMId#')}}
<p>
{{fn_ExecuteSQL( SELECT
RTRIM(XMLAGG( XMLELEMENT (e, IT.ITEM_NAME, ', ')).EXTRACT ('//text()').GETCLOBVAL(), ', ') AS ITEM_NAME
FROM ZZZT_CAPASITY_REPORT_ITEM CI
LEFT JOIN INVD_ITEM IT ON CI.ITEM_ID = IT.ITEM_ID
WHERE CI.CAPASITY_REPORT_ID ='#Id#'
GROUP BY CI.CAPASITY_REPORT_ID)}}
</p>