From 40e430517c4602c4d6595bc3d009f3ef4bab8ac6 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Fri, 18 Aug 2006 13:30:03 +0000
Subject: [PATCH] adding email and phone to ou

git-svn-id: svn://svn.open-ils.org/ILS/trunk@5584 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/cgi-bin/lib-setup.cgi        | 26 +++++++++++++++++++----
 Open-ILS/src/sql/Pg/005.schema.actors.sql |  4 +++-
 2 files changed, 25 insertions(+), 5 deletions(-)

diff --git a/Open-ILS/src/cgi-bin/lib-setup.cgi b/Open-ILS/src/cgi-bin/lib-setup.cgi
index d5ac449c0b..1c67ba3a6d 100755
--- a/Open-ILS/src/cgi-bin/lib-setup.cgi
+++ b/Open-ILS/src/cgi-bin/lib-setup.cgi
@@ -10,8 +10,8 @@ use OpenILS::Application::Storage::Driver::Pg;
 
 use CGI qw/:standard start_*/;
 our %config;
-#do '##CONFIG##/live-db-setup.pl';
-do '/openils/conf/live-db-setup.pl';
+do '##CONFIG##/live-db-setup.pl';
+#do '/openils/conf/live-db-setup.pl';
 
 OpenILS::Application::Storage::CDBI->connection($config{dsn},$config{usr},$config{pw});
 OpenILS::Application::Storage::CDBI->db_Main->{ AutoCommit } = 1;
@@ -23,9 +23,9 @@ my $cgi = new CGI;
 # setup part
 #-------------------------------------------------------------------------------
 
-my %org_cols = ( qw/id SysID name Name parent_ou Parent ou_type OrgUnitType shortname ShortName/ );
+my %org_cols = ( qw/id SysID name Name parent_ou Parent ou_type OrgUnitType shortname ShortName email Email phone Phone/ );
 
-my @col_display_order = ( qw/id name shortname ou_type parent_ou/ );
+my @col_display_order = ( qw/id name shortname ou_type email phone parent_ou/ );
 
 if (my $action = $cgi->param('action')) {
 	if ( $action eq 'Update' ) {
@@ -244,6 +244,15 @@ if (my $action = $cgi->param('action')) {
 							$out;
 						}."</select>"),
 			);
+			print Tr(
+				th($org_cols{email}),
+				td("<input type='text' name='email_$node' value=\"". $node->email() ."\">"),
+			);
+			print Tr(
+				th($org_cols{phone}),
+				td("<input type='text' name='phone_$node' value='". $node->phone() ."'>"),
+			);
+
 			print Tr(
 				th($org_cols{parent_ou}),
 				td("<select name='parent_ou_$node'>".do{
@@ -405,6 +414,15 @@ if (my $action = $cgi->param('action')) {
 						$out;
 					}."</select>"),
 			);
+			print Tr(
+				th($org_cols{email}),
+				td("<input type='text' name='email'>"),
+			);
+			print Tr(
+				th($org_cols{phone}),
+				td("<input type='text' name='phone'>"),
+			);
+
 			print Tr( "<td colspan='2'><input type='hidden' value='$node' name='parent_ou'>",
 				  "<input type='submit' name='action' value='Add New'/></td>" );
 			print	"</table></form><hr/>";
diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql
index 130d240a78..4b3ce83a82 100644
--- a/Open-ILS/src/sql/Pg/005.schema.actors.sql
+++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql
@@ -373,7 +373,9 @@ CREATE TABLE actor.org_unit (
 	mailing_address	INT,
 	billing_address	INT,
 	shortname	TEXT	NOT NULL,
-	name		TEXT	NOT NULL
+	name		TEXT	NOT NULL,
+	email		TEXT,
+	phone		TEXT
 );
 CREATE INDEX actor_org_unit_parent_ou_idx ON actor.org_unit (parent_ou);
 CREATE INDEX actor_org_unit_ou_type_idx ON actor.org_unit (ou_type);
-- 
2.43.2