Changes between Version 2 and Version 3 of GenerateReports

Timestamp:

01/09/26 20:19:04 (11 days ago)

Author:

235018

Comment:

--

GenerateReports

@@ -88 +88 @@
 JOIN works_in_store w ON p.id = w.personal_ID
 WHERE w.store_ID='001';
+
 }}}
 
-**9.** Each boss reviews and signs the report. Once at least one boss signs, the report is considered approved.
+**9.** The boss, or any boss, can edit the version of the report they recived and update it if they notice that something isn't right.
+
+{{{#sql
+UPDATE report
+SET overall_profit='33000'
+WHERE report.date >= DATE_TRUNC('month', CURRENT_DATE) AND
+report.date < (DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 month') AND
+report.store_ID = '001';
+
+}}}
+
+
+**10.** Each boss reviews and signs the report. Once at least one boss signs, the report is considered approved.
 
 {{{#!sql
@@ -96 +109 @@
 SET owner_signature = boss.signature
 WHERE store_ID='001' AND date = '2025-12-30 00:00:00' AND boss.boss_ID = works_in.personal_ID and works_id.store_ID = '001';
+
 }}}