$unique_companionships='';
// Select all the unique companionship numbers for this district
- $sql = "SELECT distinct companionship FROM eq_companionship where district=". $districts[$i]['district'];
+ $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$i]['district'];
$this->db->query($sql,__LINE__,__FILE__);
$j=0;
while ($this->db->next_record())
// in the past $num_months for this Family
$header_row="<th width=$comp_width><font size=-2>Families</th>";
for($m=$num_months; $m >= 0; $m--) {
- $month = date('m/Y', strtotime('-'.$m.' month'));
- $month_start = date('Y-m', strtotime('-'.$m.' month')); $month_start .= "-01";
- $month_end = date('Y-m', strtotime('-'.$m.' month')); $month_end .= "-31";
+ if(`date '+%d'` == 31) { $d = 1; } else { $d = 0; }
+ $month = date('m/Y', strtotime('-'.$m.' month -'.$d.' day'));
+ $month_start = date('Y-m', strtotime('-'.$m.' month -'.$d.' day')); $month_start .= "-01";
+ $month_end = date('Y-m', strtotime('-'.$m.' month -'.$d.' day')); $month_end .= "-31";
$sql = "SELECT * FROM eq_visit WHERE date >= '$month_start' AND date <= '$month_end' ".
" AND companionship=" . $unique_companionships[$j]['companionship'].
" AND family=". $family_id;
$sql = "SELECT distinct companionship FROM eq_companionship";
}
else {
- $sql = "SELECT distinct companionship FROM eq_companionship where district=". $districts[$i]['district'];
+ $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$i]['district'];
}
$this->db->query($sql,__LINE__,__FILE__);
$j=0;
$unique_companionships[$j]['companionship'] = $this->db->f('companionship');
$j++;
}
-
+
$comp_width=400; $ppi_width=25; $table_width=$comp_width + $num_months*$ppi_width;
- $table_data=""; $num_companionships = 0; $num_elders = 0;
+ $table_data=""; $num_companionships = $j; $num_elders = 0;
for($m=$num_months; $m >= 0; $m--) { $ppis[$m] = 0; }
for ($j=0; $j < count($unique_companionships); $j++) {
// Select all the companions in each companionship
while ($this->db->next_record())
{
// Get this companions information
- $num_elders++; $num_companionships++;
+ $num_elders++;
$companionship = $this->db->f('companionship');
$elder_id = $this->db->f('elder');
$aaronic_id = $this->db->f('aaronic');
$header_row .= "<th width=150><font size=-2>$year</th>";
}
else {
- $month = date('m/Y', strtotime('-'.$m.' month'));
- $month_start = date('Y-m', strtotime('-'.$m.' month')); $month_start .= "-01";
- $month_end = date('Y-m', strtotime('-'.$m.' month')); $month_end .= "-31";
+ if(`date '+%d'` == 31) { $d = 1; } else { $d = 0; }
+ $month = date('m/Y', strtotime('-'.$m.' month -'.$d.' day'));
+ $month_start = date('Y-m', strtotime('-'.$m.' month -'.$d.' day')); $month_start .= "-01";
+ $month_end = date('Y-m', strtotime('-'.$m.' month -'.$d.' day')); $month_end .= "-31";
$sql = "SELECT * FROM eq_ppi WHERE date >= '$month_start' AND date <= '$month_end' ".
"AND elder=" . $elder_id . " AND eqpresppi=0";
$this->db2->query($sql,__LINE__,__FILE__);
$table_data .= "</tr>";
$k++;
}
- if($num_companionships % 2 != 0) { $num_companionships++; }
$table_data .= "<tr><td colspan=20><hr></td></tr>";
}
// Now add Elders not assigned to any companionship to the table if we are in eqpresppi mode
$this->db->query($sql,__LINE__,__FILE__);
if(!$this->db->next_record()) {
// We found an Elder not in a companionship, add them to the table
- $num_elders++; $num_companionships++;
+ $num_elders++;
$companionship=0;
$name = $elders[$elder_id];
$link_data['menuaction'] = 'eq.eq.ppi_update';
}
}
}
- $num_companionships = ceil($num_companionships/2);
$total_companionships += $num_companionships;
if($eqpresppi == 1) {
$stat_data = "<tr><td><b><font size=-2>$num_elders Elders<br>PPI Totals:</font></b></td>";
{
$this->nextmatchs->template_alternate_row_color(&$this->t);
- $sql = "SELECT * FROM eq_family WHERE valid=1 AND family=".$visit_list[$i]['family'];
+ $sql = "SELECT * FROM eq_family WHERE family=".$visit_list[$i]['family'];
$this->db->query($sql,__LINE__,__FILE__);
$this->db->next_record();