Changes between Initial Version and Version 1 of ShowControlCentre

Timestamp:

02/08/26 19:08:21 (2 days ago)

Author:

233062

Comment:

--

ShowControlCentre

@@ +1 @@
+== Приказ на контролен центар
+=== Актери
+- Најавен корисник 
+=== Чекор 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;
+}}}