POSper 的使用指南/穩定版/SQL 查詢

Postgres

每個日期的總銷售額

SELECT date(tickets.datenew), 
SUM(productsout.price*productsout.units) AS total 
FROM tickets LEFT OUTER JOIN productsout ON tickets.ticketid=productsout.ticketid
GROUP BY date
ORDER BY date

在一定日期範圍內，按日期、按產品統計總量

SELECT date(datenew) AS theDate, name, SUM(units * price) AS price
FROM productsout
    LEFT OUTER JOIN products ON productsout.product=products.reference
    LEFT OUTER JOIN tickets on productsout.ticketid=tickets.ticketid

WHERE datenew BETWEEN 
'2006/2/16' AND 
'2006/2/19:23:59'

GROUP BY date(datenew),name
ORDER BY date(datenew),name  

重置資料庫，但不要刪除產品

?

MySQL：重置資料庫，但不要刪除產品

TRUNCATE `posper_ticketline`;
TRUNCATE `posper_payment`;
TRUNCATE `posper_ticket`;

TRUNCATE `posper_ticketcreationgenerator`;
ALTER TABLE `posper_ticketcreationgenerator`  AUTO_INCREMENT=1;

TRUNCATE `posper_ticketidgenerator`;
ALTER TABLE `posper_ticketidgenerator`  AUTO_INCREMENT=1;

TRUNCATE `posper_cashregister`;