X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=inc%2Fclass.eq.inc.php;h=9bc77a08047864924c5f710379d6b678ce167707;hb=822abf1339b489e81ccfcd3a30d467d437af449a;hp=053996cca9b912d04ecc52af336a596715ff4af7;hpb=58f88e4b78a0f0096698b73a1a43169a81249052;p=eq%2F.git diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index 053996c..9bc77a0 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -1096,6 +1096,23 @@ class eq $this->t->set_block('willing_view_t','header_list','list1'); $this->t->set_block('willing_view_t','elder_list','list2'); + $this->t->set_var('lang_filter','Filter'); + $this->t->set_var('lang_filter_unwilling','Filter out unwilling Elders:'); + + $filter_unwilling = get_var('filter_unwilling',array('POST')); + $this->t->set_var('filter_unwilling',$filter_unwilling); + + if($filter_unwilling == 'y' || $filter_unwilling == '') { + $filter_input = "Y"; + $filter_input.= "N"; + $filter_input.= "  "; + } else { + $filter_input = "Y"; + $filter_input.= "N"; + $filter_input.= "  "; + } + $this->t->set_var('filter_input',$filter_input); + $sql = "SELECT * FROM eq_elder where valid=1"; $this->db->query($sql,__LINE__,__FILE__); $i=0; @@ -1144,14 +1161,13 @@ class eq } for ($i=0; $i < count($elder_id); $i++) { - $willing_table = ''; - $this->nextmatchs->template_alternate_row_color(&$this->t); + $willing_table = ''; $elder_willing=0; $this->t->set_var('elder_name',$elder_name[$i]); $this->t->set_var('elder_phone',$elder_phone[$elder_id[$i]]); $this->t->set_var('editurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.willing_update&elder_id=' . $elder_id[$i] . '&action=' . 'edit')); for ($j=0; $j < count($assignment_list); $j++) { - $found_willingness=0; + $found_willingness=0; $sql = "SELECT * FROM eq_willingness where " . " assignment=" . $assignment_list[$j]['assignment'] . " AND elder=" . $elder_id[$i]; @@ -1177,21 +1193,27 @@ class eq if($this->db->f('willing') == 'y') { $total_willing[$j]++; + $elder_willing=1; $willing_table .= '
'.$date_part.''; } else if($this->db->f('willing') == 'n') { $willing_table .= ''; } else { + $elder_willing=1; $willing_table .= " "; } } if(!$found_willingness) { + $elder_willing=1; $willing_table .= " "; } } - $this->t->set_var('willing_table',$willing_table); - $this->t->fp('list2','elder_list',True); + if(($elder_willing == 1) || ($filter_unwilling == 'n')) { + $this->t->set_var('willing_table',$willing_table); + $this->t->fp('list2','elder_list',True); + $this->nextmatchs->template_alternate_row_color(&$this->t); + } } $stat_table = 'Total Willing to Serve'; @@ -1409,6 +1431,7 @@ class eq $president_name = $this->db->f('name'); $president_id = $this->db->f('elder'); $presidency_id = $this->db->f('presidency'); + $interviewer = $this->db->f('elder'); $district_number = '*'; $district_name = $president_name; } else { @@ -1531,6 +1554,7 @@ class eq $link_data['ppi'] = ''; $link_data['eqpresppi'] = 1; $link_data['action'] = 'add'; + $link_data['interviewer'] = $interviewer; $link = $GLOBALS['phpgw']->link('/eq/index.php',$link_data); $tr_color = $this->nextmatchs->alternate_row_color($tr_color); $this->t->set_var('tr_color',$tr_color); @@ -1883,6 +1907,7 @@ class eq $link_data['name'] = $name; $link_data['interview'] = ''; $link_data['action'] = 'add'; + $link_data['interviewer'] = $districts[$d]['supervisor']; $link = $GLOBALS['phpgw']->link('/eq/index.php',$link_data); $table_data.= "$name"; $table_data.= "$phone";