// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Pastèque. If not, see <http://www.gnu.org/licenses/>.
namespace BaseSales;
$sql = "SELECT " . "CASHREGISTERS.NAME AS CASHREGISTER, " . "TAXES.NAME, SUM(TAXLINES.BASE) AS BASE, " . "SUM(TAXLINES.AMOUNT) AS AMOUNT, " . "DATESTART, DATEEND " . "FROM RECEIPTS " . "LEFT JOIN CLOSEDCASH ON RECEIPTS.MONEY = CLOSEDCASH.MONEY " . "LEFT JOIN TAXLINES ON TAXLINES.RECEIPT = RECEIPTS.ID " . "LEFT JOIN TAXES ON TAXLINES.TAXID = TAXES.ID " . "LEFT JOIN CASHREGISTERS ON CLOSEDCASH.CASHREGISTER_ID = CASHREGISTERS.ID " . "WHERE CLOSEDCASH.DATESTART > :start AND CLOSEDCASH.DATEEND < :stop " . "GROUP BY CLOSEDCASH.MONEY, CASHREGISTERS.NAME, TAXES.NAME " . "ORDER BY CLOSEDCASH.DATESTART ASC, TAXES.NAME ASC";
$fields = array("CASHREGISTER", "DATESTART", "DATEEND", "NAME", "BASE", "AMOUNT");
$headers = array(\i18n("CashRegister.label"), \i18n("Session.openDate"), \i18n("Session.closeDate"), \i18n("Tax name", PLUGIN_NAME), \i18n("Tax base", PLUGIN_NAME), \i18n("Tax amount", PLUGIN_NAME));
$report = new \Pasteque\Report(PLUGIN_NAME, "taxes_report", \i18n("Taxes report", PLUGIN_NAME), $sql, $headers, $fields);
$report->addInput("start", \i18n("Session.openDate"), \Pasteque\DB::DATE);
$report->setDefaultInput("start", time() - time() % 86400 - 30 * 86400);
$report->addInput("stop", \i18n("Session.closeDate"), \Pasteque\DB::DATE);
$report->setDefaultinput("stop", time() - time() % 86400 + 86400);
$report->setGrouping("CASHREGISTER");
$report->addSubtotal("BASE", \Pasteque\Report::TOTAL_SUM);
$report->addTotal("BASE", \Pasteque\Report::TOTAL_SUM);
$report->addSubtotal("AMOUNT", \Pasteque\Report::TOTAL_SUM);
$report->addTotal("AMOUNT", \Pasteque\Report::TOTAL_SUM);
$report->addFilter("DATESTART", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATESTART", "\\i18nDatetime");
$report->addFilter("DATEEND", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATEEND", "\\i18nDatetime");
$report->setVisualFilter("BASE", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("BASE", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("AMOUNT", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("AMOUNT", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->SetVisualFilter("BASE", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->SetVisualFilter("BASE", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
\Pasteque\register_report($report);
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Pastèque. If not, see <http://www.gnu.org/licenses/>.
namespace BaseSales;
$sql = "SELECT " . "PRODUCTS.REFERENCE, " . "PRODUCTS.NAME, " . "PRODUCTS.CATEGORY, " . "CATEGORIES.NAME AS CATNAME, " . "SUM(TICKETLINES.UNITS) AS UNITS, " . "(SUM(TICKETLINES.UNITS) * TICKETLINES.PRICE * (1 - TICKETLINES.DISCOUNTRATE)) AS TOTAL, " . "(SUM(TICKETLINES.UNITS) * ((TICKETLINES.PRICE * (1 - TICKETLINES.DISCOUNTRATE)) - PRODUCTS.PRICEBUY)) AS MARGIN, " . "(SUM(TICKETLINES.UNITS) * (TICKETLINES.PRICE * (1 - TICKETLINES.DISCOUNTRATE) * (SELECT SUM(1 + TAXES.RATE) FROM TAXES WHERE PRODUCTS.TAXCAT = TAXES.CATEGORY AND TAXES.VALIDFROM < RECEIPTS.DATENEW ORDER BY TAXES.VALIDFROM DESC LIMIT 0,1))) AS TAXEDTOTAL " . "FROM CLOSEDCASH " . "JOIN RECEIPTS ON RECEIPTS.MONEY = CLOSEDCASH.MONEY " . "JOIN TICKETS ON TICKETS.ID = RECEIPTS.ID " . "JOIN TICKETLINES ON TICKETLINES.TICKET = RECEIPTS.ID " . "JOIN PRODUCTS ON PRODUCTS.ID = TICKETLINES.PRODUCT " . "JOIN CATEGORIES ON CATEGORIES.ID = PRODUCTS.CATEGORY " . "WHERE " . "CLOSEDCASH.DATESTART > :start AND CLOSEDCASH.DATEEND < :stop " . "GROUP BY PRODUCTS.REFERENCE, PRODUCTS.NAME, PRODUCTS.CATEGORY " . "ORDER BY CATEGORIES.NAME, PRODUCTS.NAME";
$fields = array("REFERENCE", "NAME", "UNITS", "TOTAL", "TAXEDTOTAL", "MARGIN");
$headers = array(\i18n("Product.reference"), \i18n("Product.label"), \i18n("Quantity"), \i18n("Total w/o VAT", PLUGIN_NAME), \i18n("Total", PLUGIN_NAME), \i18n("Margin", PLUGIN_NAME));
$report = new \Pasteque\Report(PLUGIN_NAME, "sales_by_category_report", \i18n("Sales by category", PLUGIN_NAME), $sql, $headers, $fields);
$report->addInput("start", \i18n("Session.openDate"), \Pasteque\DB::DATE);
$report->setDefaultInput("start", time() - time() % 86400 - 7 * 86400);
$report->addInput("stop", \i18n("Session.closeDate"), \Pasteque\DB::DATE);
$report->setDefaultinput("stop", time() - time() % 86400 + 86400);
$report->setGrouping("CATNAME");
$report->addSubTotal("TOTAL", \Pasteque\Report::TOTAL_SUM);
$report->addSubTotal("TAXEDTOTAL", \Pasteque\Report::TOTAL_SUM);
$report->addSubTotal("MARGIN", \Pasteque\Report::TOTAL_SUM);
$report->addFilter("DATESTART", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATESTART", "\\i18nDatetime");
$report->addFilter("DATEEND", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATEEND", "\\i18nDatetime");
$report->setVisualFilter("UNITS", "\\i18nFlt", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("UNITS", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("TOTAL", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("TOTAL", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("TAXEDTOTAL", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("TAXEDTOTAL", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("MARGIN", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("MARGIN", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Pastèque. If not, see <http://www.gnu.org/licenses/>.
namespace ProductProviders;
$sql = "SELECT " . "PRODUCTS.REFERENCE, " . "PRODUCTS.NAME, " . "PRODUCTS.PROVIDER, " . "PROVIDERS.NAME AS PROVNAME, " . "SUM(TICKETLINES.UNITS) AS UNITS, " . "(SUM(TICKETLINES.UNITS) * TICKETLINES.PRICE * (1 - TICKETLINES.DISCOUNTRATE)) AS TOTAL, " . "(SUM(TICKETLINES.UNITS) * ((TICKETLINES.PRICE * (1 - TICKETLINES.DISCOUNTRATE)) - PRODUCTS.PRICEBUY)) AS MARGIN, " . "(SUM(TICKETLINES.UNITS) * ((TICKETLINES.PRICE * (1 - TICKETLINES.DISCOUNTRATE)) * (SELECT SUM(1 + TAXES.RATE) FROM TAXES WHERE PRODUCTS.TAXCAT = TAXES.CATEGORY AND TAXES.VALIDFROM < RECEIPTS.DATENEW ORDER BY TAXES.VALIDFROM DESC LIMIT 0,1))) AS TAXEDTOTAL " . "FROM CLOSEDCASH " . "JOIN RECEIPTS ON RECEIPTS.MONEY = CLOSEDCASH.MONEY " . "JOIN TICKETS ON TICKETS.ID = RECEIPTS.ID " . "JOIN TICKETLINES ON TICKETLINES.TICKET = RECEIPTS.ID " . "JOIN PRODUCTS ON PRODUCTS.ID = TICKETLINES.PRODUCT " . "JOIN PROVIDERS ON PROVIDERS.ID = PRODUCTS.PROVIDER " . "WHERE " . "CLOSEDCASH.DATESTART > :start AND CLOSEDCASH.DATEEND < :stop " . "GROUP BY PRODUCTS.REFERENCE, PRODUCTS.NAME, PRODUCTS.PROVIDER " . "ORDER BY PROVIDERS.NAME, PRODUCTS.NAME";
$fields = array("REFERENCE", "NAME", "UNITS", "TOTAL", "TAXEDTOTAL", "MARGIN");
$headers = array(\i18n("Product.reference"), \i18n("Product.label"), \i18n("Quantity"), \i18n("Total w/o VAT", PLUGIN_NAME), \i18n("Total", PLUGIN_NAME), \i18n("Margin", PLUGIN_NAME));
$report = new \Pasteque\Report(PLUGIN_NAME, "sales_by_provider_report", \i18n("Sales by provider", PLUGIN_NAME), $sql, $headers, $fields);
$report->addInput("start", \i18n("Session.openDate"), \Pasteque\DB::DATE);
$report->setDefaultInput("start", time() - time() % 86400 - 7 * 86400);
$report->addInput("stop", \i18n("Session.closeDate"), \Pasteque\DB::DATE);
$report->setDefaultinput("stop", time() - time() % 86400 + 86400);
$report->setGrouping("PROVNAME");
$report->addSubTotal("TOTAL", \Pasteque\Report::TOTAL_SUM);
$report->addSubTotal("TAXEDTOTAL", \Pasteque\Report::TOTAL_SUM);
$report->addSubTotal("MARGIN", \Pasteque\Report::TOTAL_SUM);
$report->addFilter("DATESTART", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATESTART", "\\i18nDatetime");
$report->addFilter("DATEEND", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATEEND", "\\i18nDatetime");
$report->setVisualFilter("UNITS", "\\i18nInt", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("UNITS", "\\i18nInt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("TOTAL", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("TOTAL", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("TAXEDTOTAL", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("TAXEDTOTAL", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("MARGIN", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("MARGIN", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
