Uyarı Tanımı
Tags: uyumsoft
Published: 2022-06-01 12:46:28

**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>&nbsp;Malzeme/Ürün Adı&nbsp;</strong>
      </th>
      <th style="text-align:left;">
        <strong>&nbsp;Açıklama&nbsp;</strong>
      </th>
      <th>
        <strong>&nbsp;Miktar&nbsp;</strong>
      </th>
      <th>
        <strong>&nbsp;Birim&nbsp;</strong>
      </th>
      <th>
        <strong>&nbsp;Talep No&nbsp;</strong>
      </th>
      <th>
        <strong>&nbsp;Talep Ek Dosya&nbsp;</strong>
      </th>
    </tr>
    <!--Detail Start-->
    <tr style="text-decoration: none">
      <td style="text-align:left;">&nbsp;{OfferDCollection.DcardName}&nbsp;</td>
      <td style="text-align:left;">&nbsp;{OfferDCollection.Note1}&nbsp;</td>
      <td style="text-align:center;">&nbsp;{OfferDCollection.Qty|#,##}&nbsp;</td>
      <td style="text-align:center;">&nbsp;{OfferDCollection.UnitCode}&nbsp;</td>
      <td style="text-align:center;">&nbsp;{OfferDCollection.RequestDocNo}&nbsp;</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>
```

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fibrl02o3i2bx8qsisad.png)

**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>
```