From 58f88e4b78a0f0096698b73a1a43169a81249052 Mon Sep 17 00:00:00 2001 From: Alan Jack Pippin Date: Mon, 8 Oct 2007 20:02:11 -0600 Subject: [PATCH] Fixed bug in the PPI tool where the interviewer wasn't being set to the EQ president in the ppi_update() method properly. --- inc/class.eq.inc.php | 27 ++++++++------------------- 1 file changed, 8 insertions(+), 19 deletions(-) diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index 850129b..053996c 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -2407,25 +2407,14 @@ class eq $notes = get_var('notes',array('GET','POST')); $eqpresppi = get_var('eqpresppi',array('GET','POST')); - $sql = "SELECT * FROM eq_district where valid=1 ORDER BY district ASC"; - $this->db->query($sql,__LINE__,__FILE__); - while ($this->db->next_record()) - { - $supervisor = $this->db->f('supervisor'); - $sql = "SELECT * FROM eq_elder WHERE elder=" . $supervisor; - $this->db2->query($sql,__LINE__,__FILE__); - $this->db2->next_record(); - $interviewer_name = $this->db2->f('name'); - - if($supervisor == $interviewer) { - $this->t->set_var('interviewer',$supervisor . ' selected'); - } else { - $this->t->set_var('interviewer',$interviewer); - } - $this->t->set_var('interviewer_name',$interviewer_name); - $this->t->fp('int_list','interviewer_list',True); - } - + $sql = "SELECT * FROM eq_elder WHERE elder=" . $interviewer; + $this->db2->query($sql,__LINE__,__FILE__); + $this->db2->next_record(); + $interviewer_name = $this->db2->f('name'); + $this->t->set_var('interviewer',$interviewer . ' selected'); + $this->t->set_var('interviewer_name',$interviewer_name); + $this->t->fp('int_list','interviewer_list',True); + if($action == 'save') { $notes = get_var('notes',array('POST')); -- 2.34.1