Recent Posts

Pages: 1 ... 8 9 [10]
91
Yardımlaşma / Reçete ile Ürün Oluşturma ve Stoklara dahil etme
« Last post by mehmet.sakar on November 12, 2013, 09:17:43 am »
Selamlar;
Reçete ile oluşturduğum bir ürünü stoklarımda nasıl görebilirim. Örnek olarak benim kurguladığım senaryoda mutfakta 100 kişilik pilav yapıldı ve bu pilavdan 50 kişilik olanı satıldı 50 kişilik olan kısmı kaldı.
Programda reçete oluşturduğumda ürün satıldıkça stoktan düşüyor bizim istediğimiz ürün reçete ile oluşturulsun kaç porsiyon ise satılan tutar ile satılmayan ürünü ben gün sonu raporunda görmek istiyorum.
92
V3 Development / Re: REQUEST: Work Period Report: report number/id and first/last ticket numbers
« Last post by QMcKay on November 11, 2013, 10:53:33 am »
Newer version...

Code: [Select]
/******************************************************************************************/
/******************************************************************************************/
/***                                                                                    ***/
/*** DAILY ZED                                                                          ***/
/***                                                                                    ***/
/*** see USER SECTION (after declarations) to set Date for Report                       ***/
/***                                                                                    ***/
/******************************************************************************************/
/******************************************************************************************/

/*****************************************/
/************* DO NOT TOUCH **************/
/***** Declarations & Initialization *****/
/*****************************************/

declare @int_WorkPeriod_ID int = 0
declare @var_WorkPeriod_ID varchar(6) = '0'
declare @dat_WorkPeriod_Beg Datetime = '9999-12-31 23:59:59'
declare @var_WorkPeriod_Beg varchar(19) = '9999-12-31 23:59:59'
declare @dat_WorkPeriod_End Datetime = '9999-12-31 23:59:59'
declare @var_WorkPeriod_End varchar(19) = '9999-12-31 23:59:59'
declare @dat_WorkPeriod_End_Check Datetime = '9999-12-31 23:59:59'

declare @int_Ticket_Beg int = 0
declare @var_Ticket_Beg varchar(6) = '0'
declare @int_Ticket_End int = 0
declare @var_Ticket_End varchar(6) = '0'
declare @int_N int = 0
declare @dec_XR money = 1
declare @int_PrintZED int = 1
declare @int_SaveZED int = 1


/******************************************************************************************/
/******************************************************************************************/
/***                                                                                    ***/
/*** USER SECTION (Begin)                                                               ***/
/*** set WorkPeriod Begin & End Dates                                                   ***/
/*** select Foreign Currency Exchange Rate                                              ***/
/***                                                                                    ***/
/******************************************************************************************/
/******************************************************************************************/
set @int_SaveZED = 0
set @int_PrintZED = 0

-- TODAY
set @dat_WorkPeriod_Beg = CONVERT(VARCHAR(10), GETDATE(), 120)
set @dat_WorkPeriod_End = CONVERT(VARCHAR(10), DATEADD(day,1,@dat_WorkPeriod_Beg), 120)

-- OTHER DAY
--set @dat_WorkPeriod_Beg = '2013-10-24'
--set @dat_WorkPeriod_End = CONVERT(VARCHAR(10), DATEADD(day,1,@dat_WorkPeriod_Beg), 120)
--set @dat_WorkPeriod_End = '2013-10-24 23:23:07.937'

-- ForeignCurrency ExchangeRate
SELECT @dec_XR = [ExchangeRate] FROM [SambaPOS3].[dbo].[ForeignCurrencies] WHERE [Name] = 'USD'

/******************************************************************************************/
/******************************************************************************************/
/***                                                                                    ***/
/*** USER SECTION (End)                                                                 ***/
/***                                                                                    ***/
/******************************************************************************************/
/******************************************************************************************/







/*****************************************/
/************* DO NOT TOUCH **************/
/** Declarations for (in-memory) Tables **/
/*****************************************/

declare @tbl_Transactions table
(
[ID]  INT IDENTITY(1,1) NOT NULL
   ,[TicketNumber] int
   ,[Date] Datetime
   ,[TotalAmount] money
   ,[TransactionDocument_Id] int
   ,[Amount] money
   ,[Amount_USD] money
   ,[Name] varchar(255)
)

declare @tbl_Tx table
(
[ID]  INT IDENTITY(1,1) NOT NULL
   ,[Date] Datetime
   ,[Ticket] int
   ,[T12] money
   ,[T15] money
   ,[Tax] money
   ,[Amount] money
   ,[TotalAmount] money
)

declare @tbl_Tx_Z table
(
[ID]  INT IDENTITY(1,1) NOT NULL
   ,[Date] Datetime
   ,[Ticket] int
   ,[T12] money
   ,[T15] money
   ,[Tax] money
   ,[Amount] money
   ,[TotalAmount] money
)

declare @tbl_ZED table
(
[ID]  INT IDENTITY(1,1) NOT NULL
   ,[WPID] int
   ,[F1] varchar(255)
   ,[F2] varchar(255)
)




/*****************************************/
/************* CREATE REPORT *************/
/*****************************************/

select @int_WorkPeriod_ID = [Id] FROM [SambaPOS3].[dbo].[WorkPeriods] where [StartDate] >= @dat_WorkPeriod_Beg and [EndDate] <= @dat_WorkPeriod_End
select @dat_WorkPeriod_Beg = [StartDate] FROM [SambaPOS3].[dbo].[WorkPeriods] where [Id] = @int_WorkPeriod_ID
select @dat_WorkPeriod_End_Check = [EndDate] FROM [SambaPOS3].[dbo].[WorkPeriods] where [Id] = @int_WorkPeriod_ID

select @dat_WorkPeriod_End =
case @dat_WorkPeriod_End_Check
when @dat_WorkPeriod_Beg then @dat_WorkPeriod_End
else @dat_WorkPeriod_End_Check
end

set @var_WorkPeriod_ID = right('000000'+convert(varchar(6),@int_WorkPeriod_ID),6)
set @var_WorkPeriod_Beg = convert(varchar(19),@dat_WorkPeriod_Beg, 120)
set @var_WorkPeriod_End = convert(varchar(19),@dat_WorkPeriod_End, 120)

print @int_WorkPeriod_ID
print @dat_WorkPeriod_Beg
print @dat_WorkPeriod_End
print @dat_WorkPeriod_End_Check


/*****************************************/
/************* Transactions **************/
/*****************************************/

INSERT INTO @tbl_Transactions
SELECT
   tkt.[TicketNumber]
  ,tkt.[Date]
  ,tkt.[TotalAmount]
  ,tkt.[TransactionDocument_Id]

  ,tx.[Amount]
  ,tx.[Amount]/@dec_XR
  ,tx.[Name]
FROM [SambaPOS3].[dbo].[Tickets] tkt
left join [SambaPOS3].[dbo].[AccountTransactions] tx
on tkt.TransactionDocument_Id = tx.AccountTransactionDocumentId
WHERE tkt.[Date] >= @dat_WorkPeriod_Beg AND tkt.[Date] <= @dat_WorkPeriod_End

SELECT
    @int_Ticket_Beg = min([TicketNumber])
   ,@int_Ticket_End = max([TicketNumber])
FROM @tbl_Transactions

set @var_Ticket_Beg = right('000000'+convert(varchar(6),@int_Ticket_Beg),6)
set @var_Ticket_End = right('000000'+convert(varchar(6),@int_Ticket_End),6)

print @int_Ticket_Beg
print @int_Ticket_End


/*****************************************/
/******************* Tx ******************/
/*****************************************/

INSERT INTO @tbl_Tx
SELECT DISTINCT
[Date] --[Date] Datetime
   ,[TicketNumber] --[Ticket] int
   ,0 --[T12] money
   ,0 --[T15] money
   ,0 --[Tax] money
   ,0 --[Amount] money
   ,0 --[TotalAmount] money
FROM @tbl_Transactions
WHERE coalesce([TotalAmount],0) > 0
ORDER BY [TicketNumber]

set @int_N = @int_Ticket_Beg
WHILE @int_N <= @int_Ticket_End
BEGIN
UPDATE @tbl_Tx SET
  [TotalAmount] = (SELECT CASE WHEN EXISTS (SELECT TR.[TotalAmount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'Sale%')
THEN (SELECT TR.[TotalAmount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'Sale%')
ELSE (SELECT 0)
END)
, [Amount]      = (SELECT CASE WHEN EXISTS (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'Sale%')
THEN (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'Sale%')
ELSE (SELECT 0)
END)
, [T12]         = (SELECT CASE WHEN EXISTS (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T12%')
THEN (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T12%')
ELSE (SELECT 0)
END)
, [T15]         = (SELECT CASE WHEN EXISTS (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T15%')
THEN (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T15%')
ELSE (SELECT 0)
END)
, [Tax]         = (SELECT CASE WHEN EXISTS (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T12%')
THEN (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T12%')
ELSE (SELECT 0)
END)
                + (SELECT CASE WHEN EXISTS (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T15%')
THEN (SELECT TR.[Amount] FROM @tbl_Transactions TR WHERE TR.[TicketNumber]=@int_N and TR.[Name] like 'T15%')
ELSE (SELECT 0)
END)
WHERE [Ticket] = @int_N
set @int_N = @int_N + 1
END


INSERT INTO @tbl_Tx_Z
SELECT
    [Date]
   ,[Ticket]
   ,[T12]
   ,[T15]
   ,[Tax]
   ,[Amount]
   ,[TotalAmount]
FROM @tbl_Tx
ORDER BY [Ticket]


INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '///////////////////','\\\\\\\\\\\\\\\\\\\'
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '   The Best Cafe   ','  Other Operating  '
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '     & Wine Bar    ','       Name        '
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, 'Z-num:       ' + @var_WorkPeriod_ID,' RTN: xxxxxxxxxxxxx'
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, @var_WorkPeriod_Beg,'Ticket_Beg:  '+@var_Ticket_Beg
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, @var_WorkPeriod_End,'Ticket_End:  '+@var_Ticket_End
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '[------------TYPE-]','[----------AMOUNT-]'
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, 'Tax T12 ('+(SELECT right('        '+convert(varchar(10),sum([T12])/12*100),8) FROM @tbl_Tx_Z)+'):', (SELECT right('                   '+convert(varchar(19),sum([T12])),19) FROM @tbl_Tx_Z)
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, 'Tax T15 ('+(SELECT right('        '+convert(varchar(10),sum([T15])/15*100),8) FROM @tbl_Tx_Z)+'):', (SELECT right('                   '+convert(varchar(19),sum([T15])),19) FROM @tbl_Tx_Z)
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '         Tax Total:', (SELECT right('                   '+convert(varchar(19),sum([Tax])),19) FROM @tbl_Tx_Z)
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '  Sales (Tax Excl):', (SELECT right('                   '+convert(varchar(19),sum([Amount])),19) FROM @tbl_Tx_Z)
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '       Sales Total:', (SELECT right('                   '+convert(varchar(19),sum([TotalAmount])),19) FROM @tbl_Tx_Z)
INSERT INTO @tbl_ZED SELECT @int_WorkPeriod_ID, '\\\\\\\\\\\\\\\\\\\','///////////////////'

SELECT [F1],[F2] FROM @tbl_ZED ORDER BY [ID]

IF (@int_SaveZED = 1)
BEGIN
DELETE FROM [SambaPOS3].[dbo].[ZED] WHERE [WPID]=@int_WorkPeriod_ID
INSERT INTO [SambaPOS3].[dbo].[ZED]
SELECT [WPID],[F1],[F2] FROM @tbl_ZED ORDER BY [ID]

DECLARE @outputfile varchar(200), @PATH varchar(100), @FileName varchar(100), @bcpCommand varchar(2000)
SET @PATH = 'D:\Programs\POS\SALES\ZED\'
SET @FileName = 'Z'+@var_WorkPeriod_ID+'_'+@var_WorkPeriod_Beg+'.txt'
SET @FileName = REPLACE(@FileName,'/','-')
SET @FileName = REPLACE(@FileName,' ','_')
SET @FileName = REPLACE(@FileName,':','.')
SET @outputfile = @PATH + @FileName
SET @bcpCommand = 'bcp '
SET @bcpCommand = @bcpCommand + '"SELECT [F1],[F2] FROM [SambaPOS3].[dbo].[ZED] WHERE [WPID]='+@var_WorkPeriod_ID+'"'
SET @bcpCommand = @bcpCommand + ' queryout "' + @outputfile + '"'
SET @bcpCommand = @bcpCommand + ' -S localhost\SQLEXPRESS'
SET @bcpCommand = @bcpCommand + ' -U USERNAME -P PASSWORD'
SET @bcpCommand = @bcpCommand + ' -c -t " "'
print @bcpCommand
EXEC master..xp_cmdshell @bcpCommand
END


IF (@int_PrintZED = 1)
BEGIN
SET @bcpCommand = 'print /D:\\localhost\EPSONReceipt "' + @outputfile + '"'
print @bcpCommand
EXEC master..xp_cmdshell @bcpCommand
SET @outputfile = CHAR(27)+CHAR(105) -- ESC i
SET @outputfile = CHAR(29)+CHAR(86)+CHAR(66)+CHAR(0) -- GS V m n
SET @outputfile = @PATH + 'cut.txt'
SET @bcpCommand = 'print /D:\\localhost\EPSONReceipt ' + @outputfile
print @bcpCommand
EXEC master..xp_cmdshell @bcpCommand
END
93
Yardımlaşma / Re: belirli bir masayı belirli bir müşteriye atamak ve toplu fiyat
« Last post by sezersenli on November 11, 2013, 04:16:44 am »
Bu konuda sıkıntı yok, teşekkür ederim.
Fakat yapmaya çalıştığım ve konuyla ilgili forumdaki bütün yazıları okumama rağmen bir türlü beceremediğim şey şu. Öğretmenleri seçtiğim bir adisyon etiketi ile, yada müşteri grubundan öğretmenlere dahil olan birisi seçildiğinde "öğretmen" toplu fiyat listesini kullanmak istiyorum. Yoksa her seferinde manuel olarak bütün ürünlere ayrı ayrı fiyat vermem gerekiyor. Bunu nasıl yapabilirim bilen var mıdır ?
94
Support / Re: Replace the comma with point
« Last post by spanky on November 07, 2013, 08:28:51 am »
Solved! I changed the regional settings of Windows.  :D
95
Support / Replace the comma with point
« Last post by spanky on November 07, 2013, 07:28:52 am »
Hello, I should save a text file sun products to be sent to the recorder god cash.
The problem is that the driver does not accept the comma but only the points
ex:
vend rep = 1, pre = 3,5 , qty = 1, des = 'BRUSCHETTE'
instead it should be
vend rep = 1, pre = 3.5 , qty = 1, des = 'BRUSCHETTE'
the price should be 3.5 instead of 3.5
I tried to change the font in the printer, so I sopstituisce all the commas.
This does not happen if InPlace the English language.
How can I fix leaving the Italian language?
96
Support / Item Sales Report - Portion and Modifiers
« Last post by kenyong3671 on November 06, 2013, 09:43:28 am »
Hi Emre,

I have been Implementing Sambapos for Cafe, Pub and Restaurant for quite a while. Great work!
However, in recent implementation for a chinese restaurant, i have face a few issue.

Please enlightened me.

The Issue are as follow:

1) Item Sales Report - How can i show the item sales report with the Grouping of portions.
                                    eg. Fried Noodle with the different portion size (Small, Medium, Large)
                                    I would need to had the same item (Fried Noodle) shown accordingly to its
                                    size and its sales report.

                                        Product           Portions           Quantity              Amount
                                     Fried Noodle       Small                     2                        8.00
                                     Fried Noodle       Medium                 1                       12.00
                                     Fried Noodle       Large                    3                      120.00

1.1) Item Sales Report - How to show the Modifiers in the report

Thanks for the great product.

Ken Yong
97
Yardımlaşma / Re: belirli bir masayı belirli bir müşteriye atamak ve toplu fiyat
« Last post by akadir on November 03, 2013, 03:27:42 am »
Merhaba;
öğrenmenleri sisteme müşteri olarak ekleyin. bunu yönetim altındaki müşteriler kısmından yapabilirsiniz. sonra alış veriş yapan öğretmeni adisyonu açtıktan sonra müşteri seçi tıklayarak öğretmenin ismine atayınız. ödeme alırken ödemeyi açık hesap yaparak alınız.
98
Support / Re: SQL query to retrieving recent 8 tickets
« Last post by lemmings on November 01, 2013, 04:41:47 pm »
First it depends if you are referring to V2 or V3 as they use different database tables.

If you just simply want the very last 8 entered a query such as:

SELECT TOP 8 [Id]
      ,[Name]
      ,[DepartmentId]
      ,[LastUpdateTime]
      ,[TicketNumber]
      ,[PrintJobData]
      ,[Date]
      ,[LastOrderDate]
      ,[LastPaymentDate]
      ,[LocationName]
      ,[CustomerId]
      ,[CustomerName]
      ,[CustomerGroupCode]
      ,[IsPaid]
      ,[RemainingAmount]
      ,[TotalAmount]
      ,[Note]
      ,[Locked]
      ,[Tag]
  FROM [SambaData2].[dbo].[Tickets]
  ORDER BY [LastUpdateTime] DESC

This is the fastest way to recall the information that you require, from here you will need to reference the [Id] in the dbo.TicketItems table to recall the relevant items in the ticket and then display.

You do not need to include all the columns I mentioned it just depends what information you want to recall from dbo.Tickets, place it in an array, then query the dbo.TicketItems for the product items on each ticket.


V3 has a different setup so you can use the same principal but reference the correct tables and data.
99
Support / Re: SQL query to retrieving recent 8 tickets
« Last post by QMcKay on November 01, 2013, 12:53:27 pm »
It will be quite a bit more complicated than this, to parse Order Tags and Order States into a friendly format, but you'll want to look at the "Orders" table...
Code: [Select]
SELECT [TicketId]
      ,[OrderNumber]
      ,[MenuItemName]
      ,[PortionName]
      ,[Price]
      ,[Quantity]
      ,[PortionCount]
      ,[CreatedDateTime]
      ,[Tag]
      ,[OrderTags]
      ,[OrderStates]
  FROM [SambaPOS3].[dbo].[Orders]
  WHERE [CreatedDateTime] >= '2013-11-01 07:35:38.220' AND [CreatedDateTime] <= '2013-11-02'
  ORDER BY [TicketId], [OrderNumber]
100
Yardımlaşma / Re: exception has been thrown by the target of an invocation
« Last post by oknkmn on November 01, 2013, 09:00:25 am »
evet cmd de servera ping attıgımda bazen cevap alamıyorum sorun büyük ihtimal modemden kaynaklı değiştirip denicem yardım için teşekkürler
Pages: 1 ... 8 9 [10]