From 7bb95f6080564d04a568f55287e17c7fad88c7d0 Mon Sep 17 00:00:00 2001 From: Alan Jack Pippin Date: Fri, 27 Jan 2006 20:46:44 -0700 Subject: [PATCH] Added new phone and address field to eq_parent table. Added new header for online ward directory. Updated parsing script to fill phone & address fields. --- import_ward_data | 13 ++++++++++++- inc/class.eq.inc.php | 14 +++++++++++++- templates/default/header.tpl | 3 +++ 3 files changed, 28 insertions(+), 2 deletions(-) diff --git a/import_ward_data b/import_ward_data index 6a1e121..2c95e99 100755 --- a/import_ward_data +++ b/import_ward_data @@ -399,6 +399,13 @@ sub update_eq_parent_table $birthday = $membership_data{$index}{'Birth'}; $birthday =~ /(\d+) (\S+) (\d+)/; $day=$1; $month=$monthname2num{$2}; $year=$3; $hofh_id = $membership_data{$index}{'HofH ID'}; + $phone = $membership_data{$index}{'Phone 1'}; + if($phone =~ /(\d\d\d-\d\d\d\d)/) { $phone = "970-$1"; } + if($phone =~ /^\(\d\d\d\) (\d\d\d-\d\d\d\d)/) { $phone = "$1-$2"; } + $address = $membership_data{$index}{'Street 1'}; + if($membership_data{$index}{'Street 2'} ne "") { + $address .= " " . $membership_data{$index}{'Street 2'}; + } # Find the family id for this parent's HofH_ID. $sth = $dbh->prepare("select * from eq_family where hofh_id='$hofh_id'"); @@ -416,7 +423,7 @@ sub update_eq_parent_table if($rows == 0) { # No existing records found for this parent, make a new entry print " Adding new Parent: $parent_name\n"; - $sth = $dbh->prepare("insert into eq_parent values (NULL,$family_id,'$parent_name','$year-$month-$day',1)"); + $sth = $dbh->prepare("insert into eq_parent values (NULL,$family_id,'$parent_name','$year-$month-$day','$phone','$address',1)"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; } elsif($rows == 1) { # An existing record was found for this parent, update it @@ -425,6 +432,10 @@ sub update_eq_parent_table $sth->execute or die "-E- DB error: $DBI::errstr\n"; $sth = $dbh->prepare("update eq_parent set birthday='$year-$month-$day' where name='$parent_name'"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; + $sth = $dbh->prepare("update eq_parent set phone='$phone' where name='$parent_name'"); + $sth->execute or die "-E- DB error: $DBI::errstr\n"; + $sth = $dbh->prepare("update eq_parent set address='$address' where name='$parent_name'"); + $sth->execute or die "-E- DB error: $DBI::errstr\n"; $sth = $dbh->prepare("update eq_parent set valid=1 where name='$parent_name'"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; } else { diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index 7373061..fbf82aa 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -37,7 +37,8 @@ class eq 'vis_view' => True, 'vis_update' => True, 'att_view' => True, - 'att_update' => True + 'att_update' => True, + 'dir_view' => True ); function eq() @@ -105,6 +106,9 @@ class eq $link_data['menuaction'] = 'eq.eq.att_view'; $this->t->set_var('link_attendance',$GLOBALS['phpgw']->link('/eq/index.php',$link_data)); $this->t->set_var('lang_attendance','Attendance'); + $link_data['menuaction'] = 'eq.eq.dir_view'; + $this->t->set_var('link_dir',$GLOBALS['phpgw']->link('/eq/index.php',$link_data)); + $this->t->set_var('lang_dir','Directory'); $this->t->pparse('out','eq_header'); } @@ -1700,6 +1704,14 @@ class eq $this->save_sessiondata(); } + function dir_view() + { + $this->t->set_file(array('form' => 'dir_view.tpl')); + + $this->t->pfp('out','form'); + $this->save_sessiondata(); + } + } ?> diff --git a/templates/default/header.tpl b/templates/default/header.tpl index ca6d7cd..4a624a1 100644 --- a/templates/default/header.tpl +++ b/templates/default/header.tpl @@ -21,6 +21,9 @@     {lang_attendance} +   +   + {lang_dir} -- 2.34.1