r5024 - in branches/bmas-staging: data/schema/mysql lib/org/freemedsoftware/module
subve...@svn.freemedsoftware.org
Date: 2010-02-05 16:33:51 -0500 (Fri, 05 Feb 2010)
New Revision: 5024
Modified:
branches/bmas-staging/data/schema/mysql/insco.sql
branches/bmas-staging/lib/org/freemedsoftware/module/InsuranceCompanyModule.class.php
Log:
+ Fields to support target options in new version of REMITT
Modified: branches/bmas-staging/data/schema/mysql/insco.sql
===================================================================
--- branches/bmas-staging/data/schema/mysql/insco.sql 2010-02-04 19:55:13 UTC (rev 5023)
+++ branches/bmas-staging/data/schema/mysql/insco.sql 2010-02-05 21:33:51 UTC (rev 5024)
@@ -21,32 +21,61 @@
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
CREATE TABLE IF NOT EXISTS `insco` (
- inscodtadd DATE,
- inscodtmod DATE,
- insconame VARCHAR (50) NOT NULL,
- inscoalias VARCHAR (30),
- inscoaddr1 VARCHAR (45),
- inscoaddr2 VARCHAR (45),
- inscocity VARCHAR (30),
- inscostate CHAR (3),
- inscozip VARCHAR (10),
- inscophone VARCHAR (16),
- inscofax VARCHAR (16),
- inscocontact VARCHAR (100),
- inscoid CHAR (10),
- inscowebsite VARCHAR (100),
- inscoemail VARCHAR (50),
- inscogroup INT UNSIGNED,
- inscotype INT UNSIGNED,
- inscoassign INT UNSIGNED,
- inscomod TEXT,
- inscoidmap TEXT,
- inscox12id VARCHAR (32),
- inscodefoutput ENUM ( 'electronic', 'paper' ),
- inscodefformat VARCHAR (50),
- inscodeftarget VARCHAR (50),
- inscodefformate VARCHAR (50),
- inscodeftargete VARCHAR (50),
- id SERIAL
+ inscodtadd DATE
+ , inscodtmod DATE
+ , insconame VARCHAR (50) NOT NULL
+ , inscoalias VARCHAR (30)
+ , inscoaddr1 VARCHAR (45)
+ , inscoaddr2 VARCHAR (45)
+ , inscocity VARCHAR (30)
+ , inscostate CHAR (3)
+ , inscozip VARCHAR (10)
+ , inscophone VARCHAR (16)
+ , inscofax VARCHAR (16)
+ , inscocontact VARCHAR (100)
+ , inscoid CHAR (10)
+ , inscowebsite VARCHAR (100)
+ , inscoemail VARCHAR (50)
+ , inscogroup INT UNSIGNED
+ , inscotype INT UNSIGNED
+ , inscoassign INT UNSIGNED
+ , inscomod TEXT
+ , inscoidmap TEXT
+ , inscox12id VARCHAR (32)
+ , inscodefoutput ENUM ( 'electronic', 'paper' ) DEFAULT 'electronic'
+ , inscodefformat VARCHAR (50)
+ , inscodeftarget VARCHAR (50)
+ , inscodeftargetopt VARCHAR (50)
+ , inscodefformate VARCHAR (50)
+ , inscodeftargete VARCHAR (50)
+ , inscodeftargetopte VARCHAR (50)
+ , id SERIAL
);
+DROP PROCEDURE IF EXISTS insco_Upgrade;
+DELIMITER //
+CREATE PROCEDURE insco_Upgrade ( )
+BEGIN
+ DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
+
+ #----- Remove triggers
+
+ #----- Upgrades
+ CALL FreeMED_Module_GetVersion( 'insco', @V );
+
+ # Version 2
+ IF @V < 2 THEN
+ # Version 0.5
+ # Add target options
+ ALTER IGNORE TABLE insco ADD COLUMN inscodeftargetopt VARCHAR (50) AFTER inscodeftarget;
+ ALTER IGNORE TABLE insco ADD COLUMN inscodeftargetopte VARCHAR (50) AFTER inscodeftargete;
+
+ # Update REMITT modules (TODO, if need be)
+ END IF;
+
+ CALL FreeMED_Module_UpdateVersion( 'insco', 2 );
+END
+//
+DELIMITER ;
+CALL insco_Upgrade( );
+
Modified: branches/bmas-staging/lib/org/freemedsoftware/module/InsuranceCompanyModule.class.php
===================================================================
--- branches/bmas-staging/lib/org/freemedsoftware/module/InsuranceCompanyModule.class.php 2010-02-04 19:55:13 UTC (rev 5023)
+++ branches/bmas-staging/lib/org/freemedsoftware/module/InsuranceCompanyModule.class.php 2010-02-05 21:33:51 UTC (rev 5024)
@@ -27,7 +27,7 @@
class InsuranceCompanyModule extends SupportModule {
var $MODULE_NAME = "Insurance Companies";
- var $MODULE_VERSION = "0.4.1";
+ var $MODULE_VERSION = "0.5";
var $MODULE_FILE = __FILE__;
var $MODULE_UID = "01692334-2893-452e-8e55-08ad65c4d17d";
@@ -37,32 +37,34 @@
var $table_name = "insco";
var $variables = array (
- "inscodtmod",
- "insconame",
- "inscoalias",
- "inscoaddr1",
- "inscoaddr2",
- "inscocity",
- "inscostate",
- "inscozip",
- "inscophone",
- "inscofax",
- "inscocontact",
- "inscoid",
- "inscowebsite",
- "inscoemail",
- "inscogroup",
- "inscotype",
- "inscoassign",
- "inscomod",
- "inscoidmap",
- "inscox12id",
+ "inscodtmod"
+ , "insconame"
+ , "inscoalias"
+ , "inscoaddr1"
+ , "inscoaddr2"
+ , "inscocity"
+ , "inscostate"
+ , "inscozip"
+ , "inscophone"
+ , "inscofax"
+ , "inscocontact"
+ , "inscoid"
+ , "inscowebsite"
+ , "inscoemail"
+ , "inscogroup"
+ , "inscotype"
+ , "inscoassign"
+ , "inscomod"
+ , "inscoidmap"
+ , "inscox12id"
// Billing related information
- "inscodefoutput",
- "inscodefformat",
- "inscodeftarget",
- "inscodefformate",
- "inscodeftargete"
+ , "inscodefoutput"
+ , "inscodefformat"
+ , "inscodeftarget"
+ , "inscodeftargetopt"
+ , "inscodefformate"
+ , "inscodeftargete"
+ , "inscodeftargetopte"
);
var $widget_hash = '##insconame## (##inscocity##, ##inscostate##)';