Changeset 9443 for branches/acq-experiment/Open-ILS/src/sql/Pg/reporter-schema.sql

Timestamp:

04/23/08 20:38:57 (3 months ago)

Author:

erickson

Message:

Merged revisions 9437,9440-9442 via svnmerge from
svn://svn.open-ils.org/ILS/trunk

........

r9437 | erickson | 2008-04-22 22:50:31 -0400 (Tue, 22 Apr 2008) | 1 line

fixed what appears to be some copy paste errors. no longer requiring kwargs to be non-null on User create

........

r9440 | miker | 2008-04-23 08:23:10 -0400 (Wed, 23 Apr 2008) | 1 line

adding helper views for overdue, running and pending reports

........

r9441 | erickson | 2008-04-23 11:13:45 -0400 (Wed, 23 Apr 2008) | 4 lines

Removing dead code and their makefile counterparts

........

r9442 | miker | 2008-04-23 13:17:15 -0400 (Wed, 23 Apr 2008) | 1 line

adding translation for description

........

Location:

branches/acq-experiment

Files:

• . (modified) (1 prop)
• Open-ILS/src/sql/Pg/reporter-schema.sql (modified) (1 diff)

branches/acq-experiment/Open-ILS/src/sql/Pg/reporter-schema.sql

@@ -214 +214 @@
         AND due_date < now();
 
+CREATE OR REPLACE VIEW reporter.overdue_reports AS
+ SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time
+   FROM reporter.schedule s
+   JOIN reporter.report r ON r.id = s.report
+   JOIN actor.usr u ON s.runner = u.id
+   JOIN actor.card c ON c.id = u.card
+  WHERE s.start_time IS NULL AND s.run_time < now();
+
+CREATE OR REPLACE VIEW reporter.pending_reports AS
+ SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time
+   FROM reporter.schedule s
+   JOIN reporter.report r ON r.id = s.report
+   JOIN actor.usr u ON s.runner = u.id
+   JOIN actor.card c ON c.id = u.card
+  WHERE s.start_time IS NULL;
+
+CREATE OR REPLACE VIEW reporter.currently_running AS
+ SELECT s.id, c.barcode AS runner_barcode, r.name, s.run_time, s.run_time - now() AS scheduled_wait_time
+   FROM reporter.schedule s
+   JOIN reporter.report r ON r.id = s.report
+   JOIN actor.usr u ON s.runner = u.id
+   JOIN actor.card c ON c.id = u.card
+  WHERE s.start_time IS NOT NULL AND s.complete_time IS NULL;
+
 COMMIT;