X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=inc%2Fclass.tc.inc.php;h=2a7310975746abfcf381838cfcde17e37f1455d9;hb=4b94ceb350683f086a54ed56dbb966455b0bfedc;hp=c6a32d3b7cf997e837a95453376defe550050f37;hpb=e72d7ba6537f5e438dedd252ae8cd0b0f0ec08d8;p=eq%2F.git diff --git a/inc/class.tc.inc.php b/inc/class.tc.inc.php index c6a32d3..2a73109 100644 --- a/inc/class.tc.inc.php +++ b/inc/class.tc.inc.php @@ -220,15 +220,6 @@ class tc $indivs[$id] = $indiv_name[$i]; } - $sql = "SELECT * FROM tc_aaronic where valid=1 ORDER BY aaronic ASC"; - $this->db->query($sql,__LINE__,__FILE__); - while ($this->db->next_record()) - { - $aaronic_id = $this->db->f('aaronic'); - $aaronic[$aaronic_id]['name'] = $this->db->f('name'); - $aaronic[$aaronic_id]['phone'] = $this->db->f('phone'); - } - $this->nextmatchs->template_alternate_row_color(&$this->t); for($m=$num_months; $m >= 0; $m--) { $total_families[$m]=0; } for ($i=0; $i < count($districts); $i++) { @@ -262,15 +253,8 @@ class tc if($companion_table_entry != "") { $companion_table_entry .= " / "; } $companionship = $this->db->f('companionship'); $indiv_id = $this->db->f('indiv'); - $aaronic_id = $this->db->f('aaronic'); - if($indiv_id) { - $name = $indivs[$indiv_id]; - $phone = $indiv_phone[$indiv_id]; - } - else if($aaronic_id) { - $name = $aaronic[$aaronic_id]['name']; - $phone = $aaronic[$aaronic_id]['phone']; - } + $name = $indivs[$indiv_id]; + $phone = $indiv_phone[$indiv_id]; $companion_table_entry .= "$name"; } $table_data.= "$companion_table_entry
"; @@ -472,15 +456,6 @@ class tc $indivs[$id] = $indiv_name[$i]; } - $sql = "SELECT * FROM tc_aaronic where valid=1 ORDER BY aaronic ASC"; - $this->db->query($sql,__LINE__,__FILE__); - while ($this->db->next_record()) - { - $aaronic_id = $this->db->f('aaronic'); - $aaronic[$aaronic_id]['name'] = $this->db->f('name'); - $aaronic[$aaronic_id]['phone'] = $this->db->f('phone'); - } - // Select all the unique companionship numbers for this district $sql = "SELECT distinct companionship FROM tc_companionship where valid=1 and district=". $district; $this->db->query($sql,__LINE__,__FILE__); @@ -506,15 +481,8 @@ class tc if($companion_table_entry != "") { $companion_table_entry .= " / "; } $companionship = $this->db->f('companionship'); $indiv_id = $this->db->f('indiv'); - $aaronic_id = $this->db->f('aaronic'); - if($indiv_id) { - $name = $indivs[$indiv_id]; - $phone = $indiv_phone[$indiv_id]; - } - else if($aaronic_id) { - $name = $aaronic[$aaronic_id]['name']; - $phone = $aaronic[$aaronic_id]['phone']; - } + $name = $indivs[$indiv_id]; + $phone = $indiv_phone[$indiv_id]; $companion_table_entry .= "$name"; } $table_data.= "$companion_table_entry
"; @@ -1036,7 +1004,8 @@ class tc $this->t->set_block('par_view_t','header_list','list1'); $this->t->set_block('par_view_t','indiv_list','list2'); - $sql = "SELECT * FROM tc_indiv where valid=1"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) @@ -1146,7 +1115,8 @@ class tc } $this->t->set_var('filter_input',$filter_input); - $sql = "SELECT * FROM tc_indiv where valid=1"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) @@ -1429,7 +1399,7 @@ class tc if($this->db2->next_record()) { $indiv_id = $this->db2->f('indiv_id'); } - $sql = "SELECT * FROM tc_parent where indiv_id='$indiv_id'"; + $sql = "SELECT * FROM tc_indiv where indiv_id='$indiv_id'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $president_address = $this->db2->f('address'); @@ -1489,7 +1459,8 @@ class tc } // create the individual id -> individual name mapping - $sql = "SELECT * FROM tc_indiv where valid=1 ORDER BY name ASC"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where valid=1 and steward='Elder' ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; $indiv_id = NULL; @@ -1568,7 +1539,8 @@ class tc $this->t->set_var('appt_table_width',$appt_table_width); // PPI SCHEDULING TABLE - $sql = "SELECT * FROM tc_indiv where valid=1 ORDER BY ppi_pri ASC"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where valid=1 and steward='Elder' ORDER BY ppi_pri ASC, name ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; @@ -1730,7 +1702,8 @@ class tc //print "year: $year month: $month quarter_start: $quarter_start quarter_end: $quarter_end
"; // create the individual id -> individual name mapping - $sql = "SELECT * FROM tc_indiv where valid=1 ORDER BY name ASC"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1 ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; $indiv_id_data = NULL; @@ -1742,6 +1715,21 @@ class tc $individ2name[$indiv_id_data[$i]] = $indiv_name_data[$i]; $i++; } + // add any YM that are home teachers + $sql = "SELECT * FROM tc_companionship where valid=1"; + $this->db->query($sql,__LINE__,__FILE__); + while ($this->db->next_record()) + { + $tmp_indiv_id = $this->db->f('indiv'); + $sql = "Select * FROM tc_indiv where indiv='$tmp_indiv_id' and steward='' and valid=1"; + $this->db2->query($sql,__LINE__,__FILE__); + while ($this->db2->next_record()) { + $indiv_name_data[$i] = $this->db2->f('name'); + $indiv_id_data[$i] = $this->db2->f('indiv'); + $individ2name[$indiv_id_data[$i]] = $indiv_name_data[$i]; + $i++; + } + } array_multisort($indiv_name_data, $indiv_id_data); if($action == 'save') @@ -1763,7 +1751,7 @@ class tc if($this->db2->next_record()) { $indiv_id = $this->db2->f('indiv_id'); } - $sql = "SELECT * FROM tc_parent where indiv_id='$indiv_id'"; + $sql = "SELECT * FROM tc_indiv where indiv_id='$indiv_id'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $supervisor_address = $this->db2->f('address'); @@ -1797,15 +1785,12 @@ class tc $indiv_id = $entry['indiv_id']; $indiv_name = $entry['indiv_name']; $int_pri = $entry['pri']; - $aaronic = $entry['aaronic']; - //print "int_notes: $int_notes indiv_name: $indiv_name aaronic: $aaronic
"; - if($aaronic == 0) { - // Perform database save actions here - $this->db->query("UPDATE tc_indiv set " . - " int_notes='" . $int_notes . "'" . - ",int_pri='" . $int_pri . "'" . - " WHERE indiv=" . $indiv_id,__LINE__,__FILE__); - } + //print "int_notes: $int_notes indiv_name: $indiv_name
"; + // Perform database save actions here + $this->db->query("UPDATE tc_indiv set " . + " int_notes='" . $int_notes . "'" . + ",int_pri='" . $int_pri . "'" . + " WHERE indiv=" . $indiv_id,__LINE__,__FILE__); } @@ -1856,7 +1841,7 @@ class tc if($this->db2->next_record()) { $indiv_id = $this->db2->f('indiv_id'); } - $sql = "SELECT * FROM tc_parent where indiv_id='$indiv_id'"; + $sql = "SELECT * FROM tc_indiv where indiv_id='$indiv_id'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $supervisor_address = $this->db2->f('address'); @@ -1930,8 +1915,7 @@ class tc $i=0; for ($j=0; $j < count($unique_companionships); $j++) { // Select all the companions from each companionship - $sql = "SELECT * FROM tc_companionship where valid=1 and ". - "companionship=". $unique_companionships[$j]['companionship']; + $sql = "SELECT * FROM tc_companionship where valid=1 and companionship=". $unique_companionships[$j]['companionship']; $this->db->query($sql,__LINE__,__FILE__); $k=0; $int_completed=0; $comp = $unique_companionships[$j]['companionship']; @@ -1942,37 +1926,22 @@ class tc { // Get this companions information $indiv_id = $this->db->f('indiv'); - $aaronic_id = $this->db->f('aaronic'); - $sql = "SELECT * FROM tc_indiv where indiv=$indiv_id"; + $sql = "SELECT * FROM tc_indiv where indiv='$indiv_id'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) - { - $indiv_id = $this->db2->f('indiv'); - $indiv_name = $this->db2->f('name'); - $indiv_phone[$indiv_id] = $this->db2->f('phone'); - $indiv_int_pri[$indiv_id] = $this->db2->f('int_pri'); - $indiv_int_notes[$indiv_id] = $this->db2->f('int_notes'); - $indiv_aaronic = 0; - } - else { - $sql = "SELECT * FROM tc_aaronic where aaronic=$aaronic_id"; - $this->db2->query($sql,__LINE__,__FILE__); - if($this->db2->next_record()) - { - $indiv_id = $this->db2->f('aaronic'); - $indiv_name = $this->db2->f('name'); - $indiv_phone[$indiv_id] = $this->db2->f('phone'); - $indiv_aaronic = 1; - } + { + $indiv_id = $this->db2->f('indiv'); + $indiv_name = $this->db2->f('name'); + $indiv_phone[$indiv_id] = $this->db2->f('phone'); + $indiv_int_pri[$indiv_id] = $this->db2->f('int_pri'); + $indiv_int_notes[$indiv_id] = $this->db2->f('int_notes'); } - $id = $indiv_id; $name = $indiv_name; $phone = $indiv_phone[$id]; $int_pri = $indiv_int_pri[$id]; $int_notes = $indiv_int_notes[$id]; - $aaronic = $indiv_aaronic; // If the companionship has already had its quarterly interview, // Skip the other companion in the companionship. @@ -1990,17 +1959,15 @@ class tc } // If this companionship has had a hometeaching interview this quarter, don't show them on the schedule list - $sql = "SELECT * FROM tc_interview WHERE date >= '$quarter_start' AND date < '$quarter_end' ". - "AND indiv=" . $id; + $sql = "SELECT * FROM tc_interview WHERE date >= '$quarter_start' AND date < '$quarter_end' AND indiv='$id'"; $this->db2->query($sql,__LINE__,__FILE__); if(!$this->db2->next_record()) { - $sql = "SELECT * FROM tc_interview WHERE indiv=" . $id . " ORDER BY date DESC"; + $sql = "SELECT * FROM tc_interview WHERE indiv='$id' ORDER BY date DESC"; $this->db3->query($sql,__LINE__,__FILE__); if($this->db3->next_record()) { $date = $this->db3->f('date'); } else { $date = ""; } $link_data['menuaction'] = 'tc.tc.int_update'; $link_data['indiv'] = $id; - $link_data['aaronic'] = 0; $link_data['name'] = $name; $link_data['interview'] = ''; $link_data['action'] = 'add'; @@ -2009,22 +1976,17 @@ class tc $table_data.= "$name"; $table_data.= "$phone"; $table_data.= ""; - if($aaronic == 0) { - $table_data.= ''; + $table_data.= ''; $table_data.= "$date"; - if($aaronic == 0) { - $table_data.= ''; - } + $table_data.= ''; $table_data.= ''; $table_data.= ''; - $table_data.= ''; $table_data.= ''; $table_data.= ''."\n"; $i++; @@ -2032,7 +1994,6 @@ class tc $link_data['menuaction'] = 'tc.tc.int_update'; $link_data['interviewer'] = $this->db2->f('interviewer'); $link_data['indiv'] = $this->db2->f('indiv'); - $link_data['aaronic'] = $this->db2->f('aaronic'); $link_data['name'] = $name; $link_data['interview'] = $this->db2->f('interview'); $link_data['action'] = 'view'; @@ -2124,7 +2085,7 @@ class tc $year = date('Y'); // create the family id -> family name mapping - $sql = "SELECT * FROM tc_family where valid=1 and indiv_id != 0 ORDER BY name ASC"; + $sql = "SELECT * FROM tc_family where valid=1 and indiv_id != 0 and companionship != 0 ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; $family_id = NULL; @@ -2133,7 +2094,7 @@ class tc $family_id[$i] = $this->db->f('family'); $family_name[$i] = $this->db->f('name'); $familyid2name[$family_id[$i]] = $family_name[$i]; - $sql = "SELECT * FROM tc_parent where family='$family_id[$i]'"; + $sql = "SELECT * FROM tc_indiv where family='$family_id[$i]'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $familyid2address[$family_id[$i]] = $this->db2->f('address'); @@ -2268,7 +2229,7 @@ class tc // VISIT SCHEDULING TABLE - $sql = "SELECT * FROM tc_family where valid=1 and indiv_id != 0 ORDER BY visit_pri ASC"; + $sql = "SELECT * FROM tc_family where valid=1 and indiv_id != 0 and companionship != 0 ORDER BY visit_pri ASC, name ASC"; $this->db->query($sql,__LINE__,__FILE__); $total_families=0; $families_with_yearly_visit=0; @@ -2290,7 +2251,7 @@ class tc $total_families++; } - $sql = "SELECT * FROM tc_parent where valid=1"; + $sql = "SELECT * FROM tc_indiv where valid=1"; $this->db->query($sql,__LINE__,__FILE__); while ($this->db->next_record()) { @@ -2443,7 +2404,8 @@ class tc $this->t->set_var('district_number','*'); $this->t->set_var('district_name',$president_name); - $sql = "SELECT * FROM tc_indiv where valid=1 ORDER BY indiv ASC"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1 ORDER BY indiv ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) @@ -2549,7 +2511,6 @@ class tc $name = get_var('name',array('GET','POST')); $interview = get_var('interview',array('GET','POST')); $indiv = get_var('indiv',array('GET','POST')); - $aaronic = get_var('aaronic',array('GET','POST')); $date = get_var('date',array('GET','POST')); $notes = get_var('notes',array('GET','POST')); $interview_type = get_var('interview_type',array('GET','POST')); @@ -2577,7 +2538,6 @@ class tc " interview='" . $interview . "'" . ", interviewer='" . $interviewer . "'" . ", indiv='" . $indiv . "'" . - ", aaronic='" . $aaronic . "'" . ", date='" . $date . "'" . ", notes='" . $notes . "'" . ", interview_type='" . $interview_type . "'" . @@ -2589,8 +2549,8 @@ class tc if($action == 'insert') { $notes = get_var('notes',array('POST')); - $this->db->query("INSERT INTO tc_interview (interviewer,indiv,aaronic,date,notes,interview_type) " - . "VALUES ('" . $interviewer . "','" . $indiv . "','" . $aaronic . "','" + $this->db->query("INSERT INTO tc_interview (interviewer,indiv,date,notes,interview_type) " + . "VALUES ('" . $interviewer . "','" . $indiv . "','" . $date . "','" . $notes . "','" . $interview_type ."')",__LINE__,__FILE__); $this->ppi_view(); return false; @@ -2719,15 +2679,6 @@ class tc $indivs[$id] = $indiv_name[$i]; } - $sql = "SELECT * FROM tc_aaronic where valid=1 ORDER BY aaronic ASC"; - $this->db->query($sql,__LINE__,__FILE__); - while ($this->db->next_record()) - { - $aaronic_id = $this->db->f('aaronic'); - $aaronic[$aaronic_id]['name'] = $this->db->f('name'); - $aaronic[$aaronic_id]['phone'] = $this->db->f('phone'); - } - $total_companionships = 0; $this->nextmatchs->template_alternate_row_color(&$this->t); for ($i=0; $i < count($districts); $i++) { @@ -2762,20 +2713,12 @@ class tc $num_indivs++; $companionship = $this->db->f('companionship'); $indiv_id = $this->db->f('indiv'); - $aaronic_id = $this->db->f('aaronic'); - if($indiv_id) { - $name = $indivs[$indiv_id]; - $phone = $indiv_phone[$indiv_id]; - } - else if($aaronic_id) { - $name = $aaronic[$aaronic_id]['name']; - $phone = $aaronic[$aaronic_id]['phone']; - } + $name = $indivs[$indiv_id]; + $phone = $indiv_phone[$indiv_id]; $link_data['menuaction'] = 'tc.tc.int_update'; $link_data['companionship'] = $companionship; $link_data['interviewer'] = $supervisor; $link_data['indiv'] = $indiv_id; - $link_data['aaronic'] = $aaronic_id; $link_data['name'] = $name; $link_data['interview'] = ''; $link_data['action'] = 'add'; @@ -2793,7 +2736,7 @@ class tc $month_end = "$year"."-"."$month"."-"."31"; $month = "$month"."/"."$year"; $sql = "SELECT * FROM tc_interview WHERE date >= '$month_start' AND date <= '$month_end' ". - "AND indiv=" . $indiv_id . " AND aaronic=" . $aaronic_id; + "AND indiv=" . $indiv_id; $this->db2->query($sql,__LINE__,__FILE__); $header_row .= "$month"; @@ -2806,7 +2749,6 @@ class tc $link_data['companionship'] = $companionship; $link_data['interviewer'] = $this->db2->f('interviewer'); $link_data['indiv'] = $indiv_id; - $link_data['aaronic'] = $aaronic_id; $link_data['name'] = $name; $link_data['interview'] = $this->db2->f('interview'); $link_data['action'] = 'view'; @@ -2886,7 +2828,6 @@ class tc $name = get_var('name',array('GET','POST')); $interview = get_var('interview',array('GET','POST')); $indiv = get_var('indiv',array('GET','POST')); - $aaronic = get_var('aaronic',array('GET','POST')); $date = get_var('date',array('GET','POST')); $notes = get_var('notes',array('GET','POST')); $interview_type = get_var('interview_type',array('GET','POST')); @@ -2913,7 +2854,6 @@ class tc " interview='" . $interview . "'" . ", interviewer='" . $interviewer . "'" . ", indiv='" . $indiv . "'" . - ", aaronic='" . $aaronic . "'" . ", date='" . $date . "'" . ", notes='" . $notes . "'" . ", interview_type='" . $interview_type . "'" . @@ -2925,8 +2865,8 @@ class tc if($action == 'insert') { $notes = get_var('notes',array('POST')); - $this->db->query("INSERT INTO tc_interview (interviewer,indiv,aaronic,date,notes,interview_type) " - . "VALUES ('" . $interviewer . "','" . $indiv . "','" . $aaronic . "','" + $this->db->query("INSERT INTO tc_interview (interviewer,indiv,date,notes,interview_type) " + . "VALUES ('" . $interviewer . "','" . $indiv . "','" . $date . "','" . $notes ."','" . $interview_type . "')",__LINE__,__FILE__); $this->int_view(); return false; @@ -2939,7 +2879,6 @@ class tc $this->t->set_var('interviewer', $interviewer); $this->t->set_var('name',$name); $this->t->set_var('indiv',$indiv); - $this->t->set_var('aaronic',$aaronic); $this->t->set_var('date',''); $this->t->set_var('notes',''); $this->t->set_var('lang_done','Cancel'); @@ -2957,7 +2896,6 @@ class tc $this->t->set_var('name',$name); $this->t->set_var('interviewer', $this->db->f('interviewer')); $this->t->set_var('indiv',$this->db->f('indiv')); - $this->t->set_var('aaronic',$this->db->f('aaronic')); $this->t->set_var('date',$this->db->f('date')); $this->t->set_var('notes',$this->db->f('notes')); if($this->db->f('interview_type') == 1) { $this->t->set_var('interview_type_checked','checked'); } @@ -3232,7 +3170,8 @@ class tc else if($current_month >= 7 && $current_month <= 9) { $current_month=9; } else if($current_month >= 10 && $current_month <= 12) { $current_month=12; } - $sql = "SELECT * FROM tc_indiv where valid=1"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) @@ -3424,7 +3363,8 @@ class tc return false; } - $sql = "SELECT * FROM tc_indiv where valid=1"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) @@ -3534,12 +3474,12 @@ class tc $this->t->set_file(array('dir_view_t' => 'dir_view.tpl')); $this->t->set_block('dir_view_t','dir_list','list'); - $sql = "SELECT * FROM tc_parent where valid=1 ORDER BY name ASC"; + $sql = "SELECT * FROM tc_indiv where valid=1 and hh_position='Head of Household' ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) { - $parent[$i]['id'] = $this->db->f('parent'); + $parent[$i]['id'] = $this->db->f('indiv'); $parent[$i]['name'] = $this->db->f('name'); $parent[$i]['phone'] = $this->db->f('phone'); $parent[$i]['address'] = $this->db->f('address'); @@ -3681,7 +3621,7 @@ class tc $family_id[$i] = $this->db->f('family'); $family_name[$i] = $this->db->f('name'); $familyid2name[$family_id[$i]] = $family_name[$i]; - $sql = "SELECT * FROM tc_parent where family='$family_id[$i]'"; + $sql = "SELECT * FROM tc_indiv where family='$family_id[$i]' and hh_position='Head of Household'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $familyid2address[$family_id[$i]] = $this->db2->f('address'); @@ -3727,7 +3667,7 @@ class tc if($this->db2->next_record()) { $indiv_id = $this->db2->f('indiv_id'); } - $sql = "SELECT * FROM tc_parent where indiv_id='$indiv_id'"; + $sql = "SELECT * FROM tc_indiv where indiv_id='$indiv_id'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $supervisor_address = $this->db2->f('address'); @@ -3808,7 +3748,8 @@ class tc //Header('Location: ' . $take_me_to_url); } - $sql = "SELECT * FROM tc_indiv where valid=1 ORDER BY indiv ASC"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1 ORDER BY indiv ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) @@ -3854,7 +3795,7 @@ class tc if($this->db2->next_record()) { $indiv_id = $this->db2->f('indiv_id'); } - $sql = "SELECT * FROM tc_parent where indiv_id='$indiv_id'"; + $sql = "SELECT * FROM tc_indiv where indiv_id='$indiv_id'"; $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->next_record()) { $supervisor_address = $this->db2->f('address'); @@ -4026,7 +3967,8 @@ class tc $this->t->pfp('out','admin_t'); - $sql = "SELECT * FROM tc_indiv where valid=1 ORDER BY indiv ASC"; + // TODO: changed this so it picks the quorum dynamically + $sql = "SELECT * FROM tc_indiv where steward='Elder' and valid=1 ORDER BY indiv ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record())