Documentation

DashboardComponent extends Injectable

in package

• Application

Table of Contents

Constants

DASHBOARD_SELECT  = "SELECT COALESCE(c_tc.user_id, c_ti.user_id) AS user_id, ym.id DIV 100 AS y, ym.id % 100 AS m\n , COALESCE(c_ti.turnover,0) AS incorrect_turnover\n , COALESCE(c_tc.turnover,0) AS turnover\n , COALESCE(c_tc.net_turnover,0) AS net_turnover\n , COALESCE(c_tc.ordered,0) + COALESCE(c_ti.ordered, 0) AS ordered\n , COALESCE(c_tc.sold,0) + COALESCE(c_ti.sold, 0) AS sold\n , COALESCE(c_vc.vat_cnt,0) AS vat_cnt\nFROM ym\nLEFT JOIN (SELECT user_id, YEAR(event_date) y, MONTH(event_date) m,\n sum(COALESCE(gross,0)) AS turnover,\n sum(COALESCE(ordered,0)) AS ordered, sum(COALESCE(sold,0)) AS sold\n FROM turnover_incorrect\n WHERE user_id = :clientId\n GROUP BY user_id, y, m) c_ti ON (c_ti.y*100+c_ti.m = ym.id)\nLEFT JOIN (SELECT user_id, YEAR(event_date) y, MONTH(event_date) m,\n sum(COALESCE(gross,0)) AS turnover,\n sum(COALESCE(net,0)) AS net_turnover,\n sum(COALESCE(ordered,0)) AS ordered, sum(COALESCE(sold,0)) AS sold\n FROM turnover_correct\n WHERE user_id = :clientId\n GROUP BY user_id, y, m) c_tc ON (c_tc.y*100+c_tc.m) = ym.id\nLEFT JOIN (SELECT user_id, ym.id AS ymid, COUNT(*) AS vat_cnt FROM user_vat uv \n INNER JOIN ym ON ym.id >= EXTRACT(YEAR_MONTH FROM uv.start_at) AND (uv.end_at IS NULL OR ym.id <= EXTRACT(YEAR_MONTH FROM uv.end_at))\n WHERE ym.id <= EXTRACT(YEAR_MONTH FROM NOW()) AND user_id = :clientId\n GROUP BY user_id, ym.id) c_vc ON c_vc.ymid = ym.id\nWHERE ym.id <= EXTRACT(YEAR_MONTH FROM NOW()) AND ( c_tc.user_id IS NOT NULL OR c_ti.user_id IS NOT NULL)"

Methods

extendedDashboard()  : array<string|int, mixed>

extendedDashboardFromTable()  : mixed

extendedThreshold()  : mixed

extendedThresholdFromSelect()  : mixed

extendedThresholdFromTable()  : mixed