# Müşteri Ara Detay Gösterme

**URL:** <https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000>\
**Category:** Genel\
**Created:** [Ocak 1, 2024, 8:11öö UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000 "2024-01-01T08:11:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![YILDIZHANPOS](https://destek.sambapos.com/user_avatar/destek.sambapos.com/yildizhanpos/32/3212_2.png) [@YILDIZHANPOS](https://destek.sambapos.com/u/YILDIZHANPOS)\
**Post date:** [Ocak 1, 2024, 8:11öö UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000/1 "2024-01-01T08:11:03Z")

</div>

![image](https://destek.sambapos.com/uploads/default/original/2X/5/5a6de683efb0731a03d3373ad0463e48ecb84a81.png)

 ![image](https://destek.sambapos.com/uploads/default/original/2X/6/6238d3597a7cdd6e31eae22c227a84cd8e5ea7ac.png)

```auto

function mtel(tel){
if (tel.length==10) {tel = tel.replace( /(\d{3})(\d{3})(\d{4})/, '0($1) $2 $3' ) } 
else {tel = tel.replace( /(\d{3})(\d{4})/, '0(212) $1 $2' )}
return tel}

function siparis(ads){
var ids = sql.Query("SELECT TOP (1) Tickets.Id FROM TicketEntities INNER JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id WHERE EntityName in ('"+ads+"') AND Tickets.IsClosed = 1 ORDER BY TicketEntities.Ticket_Id DESC").First;
return sql.Query("SELECT CONCAT('<block 1 transparent left 300>','<block 1 transparent left 30>',CONCAT(FORMAT(Quantity,'#.##'),'x'),'</block><block 1 trasparent left 200>',CONCAT(MenuItemName,CASE WHEN PortionName = 'Normal' THEN NULL Else CONCAT('.',PortionName) END),'</block><block 1 transparent right 70>',Format(Price,'#.00##','TR-tr'),'</block></block>') FROM Orders WHERE TicketId = "+ids+"").Join('<br/>')
}

function toplam(ads){
var ids = sql.Query("SELECT TOP (1) Tickets.Id FROM TicketEntities INNER JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id WHERE EntityName in ('"+ads+"') AND Tickets.IsClosed = 1 ORDER BY TicketEntities.Ticket_Id DESC").First;
return sql.Query("SELECT FORMAT(TotalAmount,'#.00##','TR-tr') FROM Tickets WHERE IsClosed = 1 AND Id = "+ids+"").First}

function count(ads){return sql.Query("SELECT DISTINCT COUNT(Ticket_Id) FROM TicketEntities WHERE EntityName in ('"+ads+"')").First; }

function grand(ads){
var ids = sql.Query("SELECT DISTINCT Ticket_Id FROM TicketEntities WHERE EntityName in ('"+ads+"')").Join(','); 
return sql.Query("SET LANGUAGE Turkish SELECT FORMAT(SUM(TotalAmount) , 'C') AS 'Currency Format' FROM Tickets WHERE IsClosed = 1 AND Id IN ("+ids+")").First}

function gun(ads){
var ids = sql.Query("SELECT TOP (1) Tickets.Id FROM TicketEntities INNER JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id WHERE EntityName in ('"+ads+"') AND Tickets.IsClosed = 1 ORDER BY TicketEntities.Ticket_Id DESC").First;
var gun = sql.Query("SELECT DATEDIFF(day,Date,GETDATE()) FROM Tickets WHERE IsClosed = 1 AND Id = "+ids+"").First
if(gun==null){var gun = '0'} else {var gun = gun}
return gun}

function tarih(ads){
var ids = sql.Query("SELECT TOP (1) Tickets.Id FROM TicketEntities INNER JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id WHERE EntityName in ('"+ads+"') AND Tickets.IsClosed = 1 ORDER BY TicketEntities.Ticket_Id DESC").First;
return sql.Query("SELECT Date FROM Tickets WHERE IsClosed = 1 AND Id = "+ids+"").First}

```

 ![image](https://destek.sambapos.com/uploads/default/original/2X/2/27e47dc8f2aad85e67803cbeafff52b743a6bc9a.png)

```auto
<block 1 transparent left 400 wrap>
<i>Müşteri </i>: <b>$1</b><br/>
<i>Telefon </i>: {CALL:musteri.mtel('{ENTITY DATA:Telefon}')}<br/>
<i>Adresi </i>: {ENTITY DATA:Adres}<br/>
<i>Bakiye </i>: <color darkred><b>{ENTITY BALANCE} ₺</b></color>
</block>  
<block 1 transparent left 350>
<b>Son Siparişi </b> <b>{CALL:musteri.toplam('$1')} ₺</b><br/>
<size 15>{CALL:musteri.siparis('$1')}</size>
</block>
<block 1 transparent left 250>
<b>Sipariş Bilgileri</b><br/>
Sipariş Adedi : <b>{CALL:musteri.count('$1')}</b> Adet<br/>
Sipariş Toplamı : <b>{CALL:musteri.grand('$1')}</b><br/>
Son Sipariş Süre : <b>{CALL:musteri.gun('$1')}</b> gün<br/>
Son Sipariş Tarih: <br/><b>{CALL:musteri.tarih('$1')}</b><br/>
</block>

```

[Müşteri Ara Detay.zip](https://destek.sambapos.com/uploads/short-url/ctYqVXG067tjDCJeFkmWzezsTwS.zip) (1.7 KB)

---

<div class="post-metadata">

**Author:** ![kadirs](https://destek.sambapos.com/letter_avatar_proxy/v4/letter/k/ecc23a/32.png) [@kadirs](https://destek.sambapos.com/u/kadirs)\
**Post date:** [Ocak 2, 2024, 9:23ös UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000/2 "2024-01-02T21:23:42Z")

</div>

Merhaba.

Müşteri arama bölümünde uygulama olarak çok güzel. Peki caller id ile gelen telefon aramasında direk paket servis bölümüne müşteri seçimi geliyor. Burada benzer bir uygulama yapılabilirmi?

 ![SAMBA PAKET](https://destek.sambapos.com/uploads/default/original/2X/9/96d2643a2dde6ad50bb7a8d6e1a89ca3b53d5b02.png)

---

<div class="post-metadata">

**Author:** ![YILDIZHANPOS](https://destek.sambapos.com/user_avatar/destek.sambapos.com/yildizhanpos/32/3212_2.png) [@YILDIZHANPOS](https://destek.sambapos.com/u/YILDIZHANPOS)\
**Post date:** [Ocak 3, 2024, 4:28öö UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000/3 "2024-01-03T04:28:13Z")

</div>

Paket servis de bulunan Detay kısmına  
Müşeri ara daki Detay kısmını kopyala yapıştır

---

<div class="post-metadata">

**Author:** ![YILDIZHANPOS](https://destek.sambapos.com/user_avatar/destek.sambapos.com/yildizhanpos/32/3212_2.png) [@YILDIZHANPOS](https://destek.sambapos.com/u/YILDIZHANPOS)\
**Post date:** [Ocak 20, 2024, 8:03ös UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000/4 "2024-01-20T20:03:43Z")

</div>

![image](https://destek.sambapos.com/uploads/default/original/2X/5/5b04f2024965875d69d221e712d0fee08fcecbb7.png)

```auto
<block 1 transparent left 400>
<block 1 transparent left 70><i>Müşteri</i></block>: <block 1 transparent left 320><b>$1</b></block><br/>
<block 1 transparent left 70><i>Telefon</i></block>: <block 1 transparent left 320>{CALL:musteri.mtel('{ENTITY DATA:Telefon}')}</block><br/>
<block 1 transparent left 70><i>Adresi</i></block>: <block 1 transparent left 320 wrap> {ENTITY DATA:Adres}</block><br/>
<block 1 transparent left 70><i>Bakiye</i></block>: <block 1 transparent left 320><color darkred><b>{ENTITY BALANCE} ₺</b></color></block>
</block> 
 
<br/> ________________________________________________________________________
<br/>
<block 1 transparent left 360>
<block 1 transparent center 340><b>Sipariş Bilgileri</b></block><br/>
<block 1 transparent left 150>Sipariş Adedi</block>: <block 1 transparent right 190><b>{CALL:musteri.count('$1')}</b> Adet</block><br/>
<block 1 transparent left 150>Sipariş Toplamı</block>: <block 1 transparent right 190><b>{CALL:musteri.grand('$1')}</b></block><br/>
<block 1 transparent left 150>Sipariş Ortalama</block>: <block 1 transparent right 190><b>₺{CALL:musteri.parite('$1')}</b></block><br/>
<block 1 transparent left 150>Son Sipariş Tarih</block>: <block 1 transparent right 190><b>{CALL:musteri.gun('$1')}</b> gün <br/><b>{CALL:musteri.tarih('$1')}</b></block><br/>
</block>
<br/> ________________________________________________________________________
<br/>
<block 1 transparent left 350>
<block 1 transparent left 100><b>Son Siparişi </b></block>
<block 1 transparent center 130>#( {CALL:musteri.id('$1')} )</block>
<block 1 transparent right 70><b>₺{CALL:musteri.toplam('$1')}</b></block><br/>
<size 15>{CALL:musteri.siparis('$1')}</size>
</block>

```

---

<div class="post-metadata">

**Author:** ![YILDIZHANPOS](https://destek.sambapos.com/user_avatar/destek.sambapos.com/yildizhanpos/32/3212_2.png) [@YILDIZHANPOS](https://destek.sambapos.com/u/YILDIZHANPOS)\
**Post date:** [Ocak 21, 2024, 7:42ös UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000/5 "2024-01-21T19:42:49Z")

</div>

![image](https://destek.sambapos.com/uploads/default/original/2X/f/fd18e08815a85209327ffc7fcb435bbde482fe03.png)

```auto
<block 1 #FFF5F05D left 400><color navy>
<block 1 transparent left 70><i>Müşteri</i></block>: <block 1 transparent left 320><b>$1</b></block><br/>
<block 1 transparent left 70><i>Telefon</i></block>: <block 1 transparent left 310>{CALL:musteri.mtel('{ENTITY DATA:Telefon}')}</block><br/>
<block 1 transparent left 70><i>Adresi</i></block>: <block 1 transparent left 320 wrap> {ENTITY DATA:Adres}</block><br/>
<block 1 transparent left 70><i>Bakiye</i></block>: <block 1 transparent left 320><color darkred><b>{ENTITY BALANCE} ₺</b></color></block>
</color></block> 
 

<br/>
<block 1 lightgreen left 400>
<block 1 transparent center 340><b>Sipariş Bilgileri</b></block><br/>
<block 1 transparent left 150>Adisyon Adedi</block>: <block 1 transparent right 190><b>{CALL:musteri.count('$1')}</b> Adet</block><br/>
<block 1 transparent left 150>Sipariş Toplamı</block>: <block 1 transparent right 190><b>{CALL:musteri.grand('$1')}</b></block><br/>
<block 1 transparent left 150>Sipariş Ortalama</block>: <block 1 transparent right 190><b>₺{CALL:musteri.parite('$1')}</b></block><br/>
<block 1 transparent left 150>Son Sipariş Tarih</block>: <block 1 transparent right 190><b>{CALL:musteri.gun('$1')}</b> gün <br/><b>{CALL:musteri.tarih('$1')}</b></block><br/>
</block>

<br/>
<block 1 skyblue left 400><color darkred>
<block 1 transparent left 100><b>Son Siparişi </b></block>
<block 1 transparent center 130>#( {CALL:musteri.id('$1')} )</block>
<block 1 transparent right 70><b>₺{CALL:musteri.toplam('$1')}</b></block><br/>
<size 15>{CALL:musteri.siparis('$1')}</size>
</color></block>

```

---

<div class="post-metadata">

**Author:** ![system](https://destek.sambapos.com/uploads/default/original/2X/a/ab756ec82ddafd9319a925c7cc2676f4f3ee9d5f.png) [@system](https://destek.sambapos.com/u/system)\
**Post date:** [Şubat 20, 2024, 7:43ös UTC](https://destek.sambapos.com/t/musteri-ara-detay-gosterme/3000/6 "2024-02-20T19:43:30Z")

</div>

Bu konu son yanıttan 30 gün sonra otomatik olarak kapatıldı. Yeni yanıtlara artık izin verilmiyor.