$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())
}
$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())
}
// 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;
$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";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
//print "year: $year month: $month quarter_start: $quarter_start quarter_end: $quarter_end<br>";
// 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;
$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')
$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'];
// Get this companions information
$indiv_id = $this->db->f('indiv');
- $sql = "SELECT * FROM tc_indiv where indiv=$indiv_id";
+ $sql = "SELECT * FROM tc_indiv where indiv='$indiv_id'";
$this->db2->query($sql,__LINE__,__FILE__);
- $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');
-
+ 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');
+ }
$id = $indiv_id;
$name = $indiv_name;
$phone = $indiv_phone[$id];
}
// 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';
$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())
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())
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())
//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())
$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())