projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added new phone field to eq_elder table.
[eq/.git]
/
inc
/
class.eq.inc.php
diff --git
a/inc/class.eq.inc.php
b/inc/class.eq.inc.php
index 069b3ae9b963a7cab80d86ccc6f94dfa30612da3..6b2b8aa346d1c04c10038bf8555ec33d399f8d88 100644
(file)
--- a/
inc/class.eq.inc.php
+++ b/
inc/class.eq.inc.php
@@
-143,6
+143,7
@@
class eq
{
$elder_id[$i] = $this->db->f('elder');
$elder_name[$i] = $this->db->f('name');
{
$elder_id[$i] = $this->db->f('elder');
$elder_name[$i] = $this->db->f('name');
+ $elder_phone[$elder_id[$i]] = $this->db->f('phone');
$i++;
}
array_multisort($elder_name, $elder_id);
$i++;
}
array_multisort($elder_name, $elder_id);
@@
-192,15
+193,16
@@
class eq
while ($this->db->next_record())
{
// Get this companions information
while ($this->db->next_record())
{
// Get this companions information
- if($companion_table_entry != "") { $companion_table_entry .= "
/
"; }
+ if($companion_table_entry != "") { $companion_table_entry .= "
<td> / </td>
"; }
$companionship = $this->db->f('companionship');
$elder_id = $this->db->f('elder');
$aaronic_id = $this->db->f('aaronic');
$companionship = $this->db->f('companionship');
$elder_id = $this->db->f('elder');
$aaronic_id = $this->db->f('aaronic');
+ $phone = $elder_phone[$elder_id];
if($elder_id) { $name = $elders[$elder_id]; }
else if($aaronic_id) { $name = $aaronic[$aaronic_id]['name']; }
if($elder_id) { $name = $elders[$elder_id]; }
else if($aaronic_id) { $name = $aaronic[$aaronic_id]['name']; }
- $companion_table_entry .= "
$name
";
+ $companion_table_entry .= "
<td title=\"$phone\"><b>$name</b></td>
";
}
}
- $table_data.= "<tr bgcolor=#d3dce3><td colspan=20><
b>$companion_table_entry
<hr></td></tr>";
+ $table_data.= "<tr bgcolor=#d3dce3><td colspan=20><
table><tr>$companion_table_entry</tr></table>
<hr></td></tr>";
// Get the names of the families assigned this home teaching companionship
$sql = "SELECT * from eq_family where valid=1 AND companionship=".$unique_companionships[$j]['companionship'];
// Get the names of the families assigned this home teaching companionship
$sql = "SELECT * from eq_family where valid=1 AND companionship=".$unique_companionships[$j]['companionship'];