Приказ на контролен центар

Актери

• Најавен корисник

Чекор 1

Корисникот пристапува до контролниот центар

Чекор 2

Проверуваме кои се категории на самоподобрување ги користи корисникот и според нив ги влечеме потребните информации за да прикажеме граф на нивна корелација.

SELECT EXISTS (
  SELECT 1 FROM trekr.finance_users fu WHERE fu.user_id = $1
) AS is_finance_user;

SELECT
  fu.user_id,
  fu.spending_budget,
  fu.saving_budget,
  fu.investing_budget,
  fu.donation_budget,
  fu.credit
FROM trekr.finance_users fu
WHERE fu.user_id = $1;

SELECT
  i.income_id,
  i.user_id,
  i.date,
  i.amount
FROM trekr.incomes i
WHERE i.user_id = $1
ORDER BY i.date, i.income_id;

SELECT EXISTS (
  SELECT 1 FROM trekr.training_users tu WHERE tu.user_id = $1
) AS is_training_user;

SELECT
  tu.user_id,
  tu.gender,
  tu.age,
  tu.weight
FROM trekr.training_users tu
WHERE tu.user_id = $1;

SELECT
  ts.training_id,
  ts.training_user_id,
  ts.weight_user_id,
  ts.duration,
  ts.calories,
  ts.date,
  ts.type
FROM trekr.training_sessions ts
WHERE ts.training_user_id = $1
ORDER BY ts.date, ts.training_id;

SELECT EXISTS (
  SELECT 1 FROM trekr.weight_users wu WHERE wu.user_id = $1
) AS is_weight_user;

SELECT
  wu.user_id,
  wu.weight,
  wu.height,
  wu.goal_weight,
  wu.goal_calories
FROM trekr.weight_users wu
WHERE wu.user_id = $1;

SELECT
  di.daily_intake_id,
  di.user_id,
  di.calories,
  di.date
FROM trekr.daily_intakes di
WHERE di.user_id = $1
ORDER BY di.date, di.daily_intake_id;

SELECT EXISTS (
  SELECT 1 FROM trekr.investor_users iu WHERE iu.user_id = $1
) AS is_investor_user;

SELECT
  a.asset_id,
  a.user_id,
  a.ticker_symbol,
  a.buy_price,
  a.buy_date,
  a.quantity
FROM trekr.assets a
WHERE a.user_id = $1
ORDER BY a.ticker_symbol, a.asset_id;

SELECT EXISTS (
  SELECT 1 FROM trekr.discipline_users du WHERE du.user_id = $1
) AS is_discipline_user;

SELECT
  du.user_id,
  du.num_tasks,
  du.tasks
FROM trekr.discipline_users du
WHERE du.user_id = $1;

SELECT
  dc.daily_completion_id,
  dc.user_id,
  dc.date,
  dc.procent
FROM trekr.daily_completion dc
WHERE dc.user_id = $1
ORDER BY dc.date, dc.daily_completion_id;