r5299 - branches/bmas-staging/data/schema/mysql

[subve...@svn.freemedsoftware.org]

Author: jeff
Date: 2010-03-13 09:40:09 -0500 (Sat, 13 Mar 2010)
New Revision: 5299

Modified:
branches/bmas-staging/data/schema/mysql/scheduler.sql
Log:
* Backend modification to support pushing system event bus messages for scheduler changes.

Modified: branches/bmas-staging/data/schema/mysql/scheduler.sql
===================================================================
--- branches/bmas-staging/data/schema/mysql/scheduler.sql 2010-03-13 11:59:20 UTC (rev 5298)
+++ branches/bmas-staging/data/schema/mysql/scheduler.sql 2010-03-13 14:40:09 UTC (rev 5299)
@@ -22,12 +22,13 @@

SOURCE data/schema/mysql/patient.sql
SOURCE data/schema/mysql/patient_emr.sql
+SOURCE data/schema/mysql/systemnotification.sql
SOURCE data/schema/mysql/workflow_status.sql
SOURCE data/schema/mysql/schedulingrules.sql

CREATE TABLE IF NOT EXISTS `scheduler` (
caldateof DATE,
- calcreated TIMESTAMP (16),
+ calcreated TIMESTAMP NOT NULL DEFAULT NOW(),
calmodified TIMESTAMP (16),
caltype ENUM( 'temp', 'pat', 'block', 'group' ) NOT NULL DEFAULT 'pat',
calhour INT UNSIGNED,
@@ -120,6 +121,7 @@
DELETE FROM `workflow_status` WHERE DATE_FORMAT( stamp, '%Y-%m-%d' ) = OLD.caldateof AND patient = OLD.calpatient;
DELETE FROM `workflow_status_summary` WHERE DATE_FORMAT( stamp, '%Y-%m-%d' ) = OLD.caldateof AND patient = OLD.calpatient;
END IF;
+ INSERT INTO systemnotification ( stamp, nuser, ntext, nmodule, npatient, action ) VALUES ( NOW(), 0, CONCAT( LPAD( OLD.calhour, 2, '0' ), ':', LPAD( OLD.calminute, 2, '0' ), ' (', OLD.calduration, 'm) - ', OLD.calprenote ), 'scheduler', OLD.calpatient, 'DELETE' );
END;
//

@@ -130,6 +132,7 @@
INSERT INTO `patient_emr` ( module, patient, oid, stamp, summary, user ) VALUES ( 'scheduler', NEW.calpatient, NEW.id, NEW.caldateof, CONCAT( LPAD( NEW.calhour, 2, '0' ), ':', LPAD( NEW.calminute, 2, '0' ), ' (', NEW.calduration, 'm) - ', NEW.calprenote ), NEW.user );
CALL patientWorkflowUpdateStatus( NEW.calpatient, NEW.caldateof, 'scheduler', TRUE, NEW.user );
END IF;
+ INSERT INTO systemnotification ( stamp, nuser, ntext, nmodule, npatient, action ) VALUES ( NEW.calcreated, 0, CONCAT( LPAD( NEW.calhour, 2, '0' ), ':', LPAD( NEW.calminute, 2, '0' ), ' (', NEW.calduration, 'm) - ', NEW.calprenote ), 'scheduler', NEW.calpatient, 'NEW' );
END;
//

@@ -149,6 +152,7 @@
CALL patientWorkflowStatusUpdateLookup ( NEW.calpatient, OLD.caldateof );
END IF;
END IF;
+ INSERT INTO systemnotification ( stamp, nuser, ntext, nmodule, npatient, action ) VALUES ( NOW(), 0, CONCAT( LPAD( NEW.calhour, 2, '0' ), ':', LPAD( NEW.calminute, 2, '0' ), ' (', NEW.calduration, 'm) - ', NEW.calprenote ), 'scheduler', NEW.calpatient, 'UPDATE' );
END;
//