# Saat bazında ürün satış raporu

**URL:** <https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901>\
**Category:** Soru Cevap\
**Created:** [Nisan 23, 2019, 1:43ös UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901 "2019-04-23T13:43:11Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bilnex07](https://destek.sambapos.com/user_avatar/destek.sambapos.com/bilnex07/32/1365_2.png) [@Bilnex07](https://destek.sambapos.com/u/Bilnex07)\
**Post date:** [Nisan 23, 2019, 1:43ös UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/1 "2019-04-23T13:43:11Z")

</div>

Merhabalar iki saat arasındaki satılan ürünleri raporlamak istiyorum yardımcı olurmusunuz

---

<div class="post-metadata">

**Author:** ![EmrBkts](https://destek.sambapos.com/user_avatar/destek.sambapos.com/emrbkts/32/1260_2.png) [@EmrBkts](https://destek.sambapos.com/u/EmrBkts)\
**Post date:** [Nisan 23, 2019, 1:51ös UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/2 "2019-04-23T13:51:47Z")

</div>

Merhaba,

İki saat aralığında satılan ürünleri raporlamak için **Ürün Satış Raporunu** açın ve yukarıda **tarih** yazılan yere **saat aralığını manuel yazın** ve yenile butonuna tıklayın yazdığınız saat aralığında rapor oluşacaktır.

 ![saat](https://destek.sambapos.com/uploads/default/original/2X/a/a5c88baf763e825acc6e1bb6edb3ce1151c7c749.png)

---

<div class="post-metadata">

**Author:** ![Bilnex07](https://destek.sambapos.com/user_avatar/destek.sambapos.com/bilnex07/32/1365_2.png) [@Bilnex07](https://destek.sambapos.com/u/Bilnex07)\
**Post date:** [Nisan 23, 2019, 2:00ös UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/3 "2019-04-23T14:00:28Z")

</div>

bu şekilde değilde müşterim örn 12 ie 13 arasında döner 5 adet ayran 3 adet gibi saatlere göre ürünleri değiştirip satışlarını arttırmak istiyor

---

<div class="post-metadata">

**Author:** ![Banned](https://destek.sambapos.com/letter_avatar_proxy/v4/letter/b/7993a0/32.png) [@Banned](https://destek.sambapos.com/u/Banned)\
**Post date:** [Nisan 23, 2019, 3:03ös UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/4 "2019-04-23T15:03:28Z")

</div>

Tam olarak ne yapmak istediğinizi anlamakta güçlük çekiyoruz, açık açık **tüm detayları ile** senaryonuzu yazarsanız yardımcı olmak isteriz.

Aşağıdaki rapor işinizi görür mü ?

```
[Saatlik Satış Averajı: 15, 25, 15, 20, 20]

```

> Saat|Satış|#TR|AVG TR|% Oranı  
> @@SalesPerHour:00,23

Raporun çalışması için aşağıdaki scripti de **Otomasyon** kısmındaki **Komutlar** bölümüne yapıştırmanız gerek.

Birebir aynı şekilde ayarlamayı unutmayın.

![sales](https://destek.sambapos.com/uploads/default/original/2X/4/42071c7a36bf4101d4d7839fd690994372063387.png)

```auto
declare @StartDate datetime = '{Start}' -- use '{Start}' here
declare @EndDate datetime = '{End}' -- use '{End}' here
declare @StartHour int = @1 -- set the First Hour you want to track
declare @EndHour int = @2 -- set the Last Hour you want to track

/ ************************************ /

declare @Hour int = 00.00
declare @TotalSales money = 0.00

declare @tbl_Sales table
(
[ID] INT IDENTITY(1,1) NOT NULL 
,[Hour] VARCHAR(255)
,[Amount] decimal(9,2)
,[Tickets] int
,[AvgTx] decimal(5,2)
,[Percent] decimal(5,2)
)

set @Hour = @StartHour

WHILE @Hour < @EndHour+1
BEGIN
    INSERT INTO @tbl_Sales
    SELECT
      @Hour as [Hour]
    , SUM(CASE WHEN (DATEPART(hour,[Date])>=@Hour AND DATEPART(hour,[Date])<@Hour+1)
               THEN [TotalAmount]
               ELSE 0 END) as [Amount]
    , COUNT(CASE WHEN (DATEPART(hour,[Date])>=@Hour AND DATEPART(hour,[Date])<@Hour+1)
               THEN 1
               ELSE null END) as [Tickets]
    ,0,0
    FROM [dbo].[Tickets]
    WHERE [Date]>=@StartDate AND [Date]<=@EndDate
SET @Hour = @Hour + 1
END

INSERT INTO @tbl_Sales
SELECT 'TTL', sum([Amount]), sum([Tickets]), 0, 0 FROM @tbl_Sales

set @TotalSales = (SELECT [Amount] FROM @tbl_Sales WHERE [Hour]='TTL')

UPDATE @tbl_Sales SET
 [AvgTx] = (CASE WHEN [Tickets]=0 THEN 0 ELSE [Amount]/[Tickets] END)
,[Percent] = [Amount]/@TotalSales * 100

SELECT CASE
WHEN isnumeric([Hour])=1
THEN (CASE WHEN [Hour]<10 THEN '0'+[Hour]+':00' ELSE [Hour]+':00' END)
ELSE [Hour]
END as [Hour]
, [Amount], [Tickets], [AvgTx], [Percent]
FROM @tbl_Sales
```

---

<div class="post-metadata">

**Author:** ![Bilnex07](https://destek.sambapos.com/user_avatar/destek.sambapos.com/bilnex07/32/1365_2.png) [@Bilnex07](https://destek.sambapos.com/u/Bilnex07)\
**Post date:** [Nisan 24, 2019, 8:49öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/5 "2019-04-24T08:49:31Z")

</div>

![12](https://destek.sambapos.com/uploads/default/original/2X/c/cd2f9b8c959a50c9febba05af9b3800018a4c385.jpeg)

dediğiniz gibi işlemleri yaptım ama raporda hata alıyorum neden olur

---

<div class="post-metadata">

**Author:** ![erkan\_kaplan](https://destek.sambapos.com/user_avatar/destek.sambapos.com/erkan_kaplan/32/757_2.png) [@erkan\_kaplan](https://destek.sambapos.com/u/erkan_kaplan)\
**Post date:** [Nisan 24, 2019, 9:55öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/6 "2019-04-24T09:55:08Z")

</div>

Copy pasta yaptiginiz SQL komutunda hafta var gibi gorunhyor.

Apastrof yerine kesme isaretleri kullandiginiza dikkat ein.

```
` yanlis
' dogru
```

---

<div class="post-metadata">

**Author:** ![erkan\_kaplan](https://destek.sambapos.com/user_avatar/destek.sambapos.com/erkan_kaplan/32/757_2.png) [@erkan\_kaplan](https://destek.sambapos.com/u/erkan_kaplan)\
**Post date:** [Nisan 24, 2019, 9:57öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/7 "2019-04-24T09:57:35Z")

</div>

Komutun en sonunda UC tane apastrof kullanulmis. Onlari silin ve tekrar deneyin

---

<div class="post-metadata">

**Author:** ![Bilnex07](https://destek.sambapos.com/user_avatar/destek.sambapos.com/bilnex07/32/1365_2.png) [@Bilnex07](https://destek.sambapos.com/u/Bilnex07)\
**Post date:** [Nisan 24, 2019, 10:17öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/9 "2019-04-24T10:17:09Z")

</div>

dediğiniz gibi denedim ama değişen bişey olmadı

---

<div class="post-metadata">

**Author:** ![erkan\_kaplan](https://destek.sambapos.com/user_avatar/destek.sambapos.com/erkan_kaplan/32/757_2.png) [@erkan\_kaplan](https://destek.sambapos.com/u/erkan_kaplan)\
**Post date:** [Nisan 24, 2019, 10:38öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/10 "2019-04-24T10:38:55Z")

</div>

Ozaman bir yerde hata yapiyorsunuz.  
Komut ve Rapor sorunsuz calisiyor. (sadece komutun en sonundaki 3 apastrof u kaldirin ve deneyin)

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

---

<div class="post-metadata">

**Author:** ![omerfu](https://destek.sambapos.com/letter_avatar_proxy/v4/letter/o/90ced4/32.png) [@omerfu](https://destek.sambapos.com/u/omerfu)\
**Post date:** [Nisan 24, 2019, 11:05öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/11 "2019-04-24T11:05:35Z")

</div>

Çalışıyor Teşekkürler. #TR nedir?

---

<div class="post-metadata">

**Author:** ![Bilnex07](https://destek.sambapos.com/user_avatar/destek.sambapos.com/bilnex07/32/1365_2.png) [@Bilnex07](https://destek.sambapos.com/u/Bilnex07)\
**Post date:** [Nisan 24, 2019, 11:11öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/12 "2019-04-24T11:11:21Z")

</div>

> [@Banned](#):
>
> 20, 20

teşekkürler suan çalışıyor

---

<div class="post-metadata">

**Author:** ![erkan\_kaplan](https://destek.sambapos.com/user_avatar/destek.sambapos.com/erkan_kaplan/32/757_2.png) [@erkan\_kaplan](https://destek.sambapos.com/u/erkan_kaplan)\
**Post date:** [Nisan 24, 2019, 11:39öö UTC](https://destek.sambapos.com/t/saat-bazinda-urun-satis-raporu/901/13 "2019-04-24T11:39:11Z")

</div>

> [@omerfu](#):
>
> Çalışıyor Teşekkürler. #TR nedir?

Söz konusu olan zaman araligindaki Ticketlerin Toplam Sayisi (Kac ticket acilmis veya kullanilmis gibi)