PHP Pasteque\Report::addTotal Beispiele

Beispiel #1

Datei: taxes_report.php Projekt: booko/pasteque-server

//    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);

Beispiel #2

Datei: place_sales_report.php Projekt: booko/pasteque-server

//
//    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 BaseRestaurant;

$sql = "SELECT TICKETS.CUSTCOUNT, " . "MIN(RECEIPTS.DATENEW) AS STARTDATE, " . "MAX(RECEIPTS.DATENEW) AS ENDDATE, COUNT(TICKETS.TICKETID) AS COUNT, " . "(COUNT(TICKETS.TICKETID) / TICKETS.CUSTCOUNT) AS TABLES ," . "AVG(TAXLINES.BASE) AS AVGSUBPRICE, " . "AVG(TAXLINES.BASE + TAXLINES.AMOUNT) AS AVGPRICE " . "FROM TICKETS, RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TICKETS.ID " . "AND RECEIPTS.ID = TAXLINES.RECEIPT " . "AND RECEIPTS.DATENEW > :start " . "AND RECEIPTS.DATENEW < :stop " . "GROUP BY TICKETS.CUSTCOUNT " . "ORDER BY TICKETS.CUSTCOUNT";
$fields = array("CUSTCOUNT", "STARTDATE", "ENDDATE", "COUNT", "TABLES", "AVGSUBPRICE", "AVGPRICE");
$headers = array(\i18n("Custcount", PLUGIN_NAME), \i18n("Session.openDate"), \i18n("Session.closeDate"), \i18n("Number", PLUGIN_NAME), \i18n("Tables", PLUGIN_NAME), \i18n("Average price w/o tax", PLUGIN_NAME), \i18n("Average price", PLUGIN_NAME));
$report = new \Pasteque\Report(PLUGIN_NAME, "place_sales_report", \i18n("Place sales", 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->addFilter("DATESTART", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATESTART", "\\i18nDatetime");
$report->addFilter("DATEEND", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATEEND", "\\i18nDatetime");
$report->setVisualFilter("AVGSUBPRICE", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("AVGSUBPRICE", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("AVGPRICE", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("AVGPRICE", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("TABLES", "\\i18nInt", \Pasteque\Report::DISP_CSV | \Pasteque\Report::DISP_USER);
$report->addTotal("TABLES", \Pasteque\Report::TOTAL_SUM);
// sum of count / sum of tables
$report->addTotal("CUSTCOUNT", \Pasteque\Report::TOTAL_SUM);
$report->addTotal("CUSTCOUNT", \Pasteque\Report::TOTAL_AVG);
$report->addPonderate("CUSTCOUNT", "TABLES");
// COUNT = SUM(TABLE * CUSTCOUNT)
$report->addTotal("AVGSUBPRICE", \Pasteque\Report::TOTAL_AVG);
$report->addTotal("AVGPRICE", \Pasteque\Report::TOTAL_AVG);
\Pasteque\register_report($report);