Справочник номенклатуры загрузил из dbo_MENUITEMS. С этим проблем не возникло. Дальше хочу документ "Чек" и его состав.
Не могу понять, откуда взять дату чека, номер и сумму. Запрос отчета "Список чеков":
SELECT
PrintChecks."BINDEDSUM" AS "PAYSUM",
PrintChecks."CHECKNUM" AS "CHECKNUM",
PrintChecks."CLOSEDATETIME" AS "CLOSEDATETIME",
CASHES00."NAME" AS "STATION",
EMPLOYEES00."NAME" AS "CASHIER",
EMPLOYEES01."NAME" AS "WAITER",
EMPLOYEES02."NAME" AS "DELETEDBY",
ORDERVOIDS00."NAME" AS "REASON",
TABLES00."NAME" AS "TABLE",
GLOBALSHIFTS00."SHIFTNUM" AS "SHIFTNUM",
GLOBALSHIFTS00."SHIFTDATE" AS "SHIFTDATE",
PrintChecks."STATE" AS "STATE",
PrintChecks."PRLISTSUM" AS "PRICESUM",
Orders00."ORDERNAME" AS "ORDERNAME",
Visits00."SIFR" AS "VISIT",
Visits00."GUESTCNT" AS "GUESTCNT",
PrintChecks."GLOBALIDENT" AS "PRINTCHECKID",
1 AS "CHECKCNT",
Orders00."OPENTIME" AS "OPENTIME"
FROM PRINTCHECKS
LEFT JOIN CASHES CASHES00
ON (CASHES00.SIFR = PrintChecks.iCloseStation)
LEFT JOIN EMPLOYEES EMPLOYEES00
ON (EMPLOYEES00.SIFR = PrintChecks.iAuthor)
LEFT JOIN Orders Orders00
ON (Orders00.Visit = PrintChecks.Visit) AND (Orders00.MidServer = PrintChecks.MidServer) AND (Orders00.IdentInVisit = PrintChecks.OrderIdent)
LEFT JOIN EMPLOYEES EMPLOYEES01
ON (EMPLOYEES01.SIFR = Orders00.MainWaiter)
LEFT JOIN EMPLOYEES EMPLOYEES02
ON (EMPLOYEES02.SIFR = PrintChecks.iDeleteManager)
LEFT JOIN ORDERVOIDS ORDERVOIDS00
ON (ORDERVOIDS00.SIFR = PrintChecks.iVoid)
LEFT JOIN TABLES TABLES00
ON (TABLES00.SIFR = Orders00.TableID)
LEFT JOIN GLOBALSHIFTS GLOBALSHIFTS00
ON (GLOBALSHIFTS00.MidServer = Orders00.MidServer) AND (GLOBALSHIFTS00.ShiftNum = Orders00.iCommonShift)
LEFT JOIN Visits Visits00
ON (Visits00.Sifr = Orders00.Visit) AND (Visits00.MidServer = Orders00.MidServer)
WHERE
(PrintChecks."IGNOREINREP" = 0)
Как я понял, номер - Orders00."ORDERNAME" AS "ORDERNAME"
Но что-то не сходится. В таблице Orders нет ничего, похожего на номер чека...
---------- Добавлено в 20:54 ---------- Предыдущее сообщение было размещено в 20:53 ----------
Камеры стоят. Мне, по большому счету, все равно. Задача стоит - надо сделать
---------- Добавлено в 20:56 ---------- Предыдущее сообщение было размещено в 20:54 ----------
И как-то скуль-запрос показывается криво... При копи-паст в скуль не отрабатывает: ругается на кавычки и т. п....