X-Git-Url: http://git.pippins.net/embedvideo/.git/.%24link.?a=blobdiff_plain;f=inc%2Fclass.tc.inc.php;h=fd885ae33ab0b519bb1bea858d2021d2edd39dc4;hb=dac99ce35c9d3b885f7cc2584493812923303b3d;hp=ac8fd709c687d16791243295e81cac7212ba62bd;hpb=c2126b4823045fd8915a51c9f0f38ca103a15731;p=eq%2F.git diff --git a/inc/class.tc.inc.php b/inc/class.tc.inc.php index ac8fd70..fd885ae 100644 --- a/inc/class.tc.inc.php +++ b/inc/class.tc.inc.php @@ -290,7 +290,7 @@ class tc $query_id = $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->num_rows($query_id) == 0) { // We did not find any visits made by the currently assigned companionship, - // look for visits made by any other companionship other than 0. (0 == EQ Presidency Visit) + // look for visits made by any other companionship other than 0. (0 == Presidency Visit) $sql = "SELECT * FROM tc_visit WHERE date >= '$month_start' AND date <= '$month_end' ". " AND companionship!=0". " AND family=". $family_id; @@ -492,7 +492,7 @@ class tc $query_id = $this->db2->query($sql,__LINE__,__FILE__); if($this->db2->num_rows($query_id) == 0) { // We did not find any visits made by the currently assigned companionship, - // look for visits made by any other companionship other than 0. (0 == EQ Presidency Visit) + // look for visits made by any other companionship other than 0. (0 == Presidency Visit) $sql = "SELECT * FROM tc_visit WHERE date >= '$month_start' AND date <= '$month_end' ". " AND companionship!=0". " AND family=". $family_id; @@ -1352,7 +1352,7 @@ class tc $year = date('Y'); - // Get the EQ President + // Get the President $sql = "SELECT * FROM tc_presidency where president=1 and valid=1"; $this->db->query($sql,__LINE__,__FILE__); if($this->db->next_record()) { @@ -1449,7 +1449,7 @@ class tc $total_indivs=0; $indivs_with_yearly_ppi=0; - // Display a scheduling table for the EQ President + // Display a scheduling table for the President $table_data=""; $appt_table_data=""; $table_title = "District ".$district_number.": ".$district_name.": All indivs with Yearly PPI Not Completed"; $appt_table_title = "District ".$district_number.": ".$district_name.": Yearly PPI Appointment Slots"; @@ -1748,17 +1748,17 @@ class tc } // Save any changes made to the int notes table - $new_data = get_var('int_notes',array('POST')); + $new_data = get_var('hti_notes',array('POST')); foreach ($new_data as $entry) { - $int_notes = $entry['notes']; + $hti_notes = $entry['notes']; $indiv_id = $entry['indiv_id']; $indiv_name = $entry['indiv_name']; - $int_pri = $entry['pri']; - //print "int_notes: $int_notes indiv_name: $indiv_name
"; + $hti_pri = $entry['pri']; + //print "hti_notes: $hti_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 . "'" . + " hti_notes='" . $hti_notes . "'" . + ",hti_pri='" . $hti_pri . "'" . " WHERE indiv=" . $indiv_id,__LINE__,__FILE__); } @@ -1902,14 +1902,14 @@ class tc $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_hti_pri[$indiv_id] = $this->db2->f('hti_pri'); + $indiv_hti_notes[$indiv_id] = $this->db2->f('hti_notes'); } $id = $indiv_id; $name = $indiv_name; $phone = $indiv_phone[$id]; - $int_pri = $indiv_int_pri[$id]; - $int_notes = $indiv_int_notes[$id]; + $hti_pri = $indiv_hti_pri[$id]; + $hti_notes = $indiv_hti_notes[$id]; // If the companionship has already had its quarterly interview, // Skip the other companion in the companionship. @@ -1917,7 +1917,7 @@ class tc $completed_data.= "$name"; $completed_data.= "$phone"; $completed_data.= "$date"; - $completed_data.= "$int_notes"; + $completed_data.= "$hti_notes"; $completed_data.= ''; $tr_color2 = $this->nextmatchs->alternate_row_color($tr_color2); $this->t->set_var('tr_color2',$tr_color2); @@ -1948,10 +1948,10 @@ class tc $table_data.= "$name"; $table_data.= "$phone"; $table_data.= ""; - $table_data.= ''; foreach(range(0,6) as $num) { if($num == 0) { $num = 1; } else {$num = $num*5; } - if($int_pri == $num) { + if($hti_pri == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; @@ -1960,9 +1960,9 @@ class tc } $table_data.= ''; $table_data.= "$date"; - $table_data.= ''; - $table_data.= ''; - $table_data.= ''; + $table_data.= ''; + $table_data.= ''; + $table_data.= ''; $table_data.= ''; $table_data.= ''."\n"; $i++; @@ -1977,12 +1977,12 @@ class tc $comps_with_quarterly_int++; $int_completed=1; $date = $this->db2->f('date'); - $int_notes = $this->db2->f('notes'); - if(strlen($int_notes) > 40) { $int_notes = substr($int_notes,0,40) . "..."; } + $hti_notes = $this->db2->f('notes'); + if(strlen($hti_notes) > 40) { $hti_notes = substr($hti_notes,0,40) . "..."; } $completed_data.= "$name"; $completed_data.= "$phone"; $completed_data.= "$date"; - $completed_data.= "$int_notes"; + $completed_data.= "$hti_notes"; $completed_data.= ''; } } @@ -2137,7 +2137,7 @@ class tc $appt_header_row.= "Location"; $appt_table_data = ""; - // Find out what the EQ Presidency ID is + // Find out what the President ID is $sql = "SELECT * FROM tc_presidency where president=1 and valid=1"; $this->db->query($sql,__LINE__,__FILE__); if($this->db->next_record()) { @@ -3570,7 +3570,7 @@ class tc $header_row.= "Location"; $table_data = ""; - $sql = "SELECT * FROM tc_presidency where valid=1 GROUP BY indiv"; + $sql = "SELECT * FROM tc_presidency where valid=1 GROUP BY indiv ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); $i=0; while ($this->db->next_record()) { @@ -4147,7 +4147,7 @@ class tc $this->t->pfp('adminhandle','admin'); } - // Now save off the data needed for an EQ Presidency Table Update + // Now save off the data needed for a Presidency Table Update $sql = "SELECT * FROM tc_presidency where valid=1"; $this->db->query($sql,__LINE__,__FILE__);