$curY = $pdf->StartLetterPage($fam_ID, $fam_Name, $fam_Address1, $fam_Address2, $fam_City, $fam_State, $fam_Zip, $fam_Country);
}
$sSQL = "SELECT * FROM person_per WHERE per_fam_ID = " . $fam_ID . " ORDER BY per_fmr_ID";
$rsFamilyMembers = RunQuery($sSQL);
while ($aMember = mysql_fetch_array($rsFamilyMembers)) {
extract($aMember);
// Get the Groups this Person is assigned to
$sSQL = "SELECT grp_ID, grp_Name, grp_hasSpecialProps, role.lst_OptionName AS roleName\n\t\t\t\tFROM group_grp\n\t\t\t\tLEFT JOIN person2group2role_p2g2r ON p2g2r_grp_ID = grp_ID\n\t\t\t\tLEFT JOIN list_lst role ON lst_OptionID = p2g2r_rle_ID AND lst_ID = grp_RoleListID\n\t\t\t\tWHERE person2group2role_p2g2r.p2g2r_per_ID = " . $per_ID . "\n\t\t\t\tORDER BY grp_Name";
$rsAssignedGroups = RunQuery($sSQL);
if (mysql_num_rows($rsAssignedGroups) > 0) {
$groupStr = "Assigned groups for " . $per_FirstName . " " . $per_LastName . ": ";
while ($aGroup = mysql_fetch_array($rsAssignedGroups)) {
extract($aGroup);
$groupStr .= $grp_Name . " (" . $roleName . ") ";
}
$pdf->WriteAt($pdf->leftX, $curY, $groupStr);
$curY += 2 * $pdf->incrementY;
}
}
if ($curY > 183) {
$curY = $pdf->StartLetterPage($fam_ID, $fam_Name, $fam_Address1, $fam_Address2, $fam_City, $fam_State, $fam_Zip, $fam_Country);
}
$pdf->FinishPage($curY);
}
header('Pragma: public');
// Needed for IE when using a shared SSL certificate
if ($iPDFOutputType == 1) {
$pdf->Output($filename, "D");
} else {
$pdf->Output();
}
$curY += $pdf->incrementY;
if ($curY + 2 * $numFamilyMembers * $pdf->incrementY >= 260) {
$curY = $pdf->StartLetterPage($fam_ID, $fam_Name, $fam_Address1, $fam_Address2, $fam_City, $fam_State, $fam_Zip, $fam_Country, $iYear);
}
$sSQL = "SELECT * FROM person_per WHERE per_fam_ID = " . $fam_ID . " ORDER BY per_fmr_ID";
$rsFamilyMembers = RunQuery($sSQL);
while ($aMember = mysql_fetch_array($rsFamilyMembers)) {
extract($aMember);
// Get the Groups this Person is assigned to
$sSQL = "SELECT grp_ID, grp_Name, grp_hasSpecialProps, role.lst_OptionName AS roleName\n\t\t\t\tFROM group_grp\n\t\t\t\tLEFT JOIN person2group2role_p2g2r ON p2g2r_grp_ID = grp_ID\n\t\t\t\tLEFT JOIN list_lst role ON lst_OptionID = p2g2r_rle_ID AND lst_ID = grp_RoleListID\n\t\t\t\tWHERE person2group2role_p2g2r.p2g2r_per_ID = " . $per_ID . "\n\t\t\t\tORDER BY grp_Name";
$rsAssignedGroups = RunQuery($sSQL);
if (mysql_num_rows($rsAssignedGroups) > 0) {
$groupStr = "Assigned groups for " . $per_FirstName . " " . $per_LastName . ": ";
while ($aGroup = mysql_fetch_array($rsAssignedGroups)) {
extract($aGroup);
$groupStr .= $grp_Name . " (" . $roleName . ") ";
}
$pdf->WriteAt($pdf->leftX, $curY, $groupStr);
$curY += 2 * $pdf->incrementY;
}
}
if ($curY > 183) {
$curY = $pdf->StartLetterPage($fam_ID, $fam_Name, $fam_Address1, $fam_Address2, $fam_City, $fam_State, $fam_Zip, $fam_Country, $iYear);
}
$pdf->FinishPage($curY);
}
if ($iPDFOutputType == 1) {
$pdf->Output("ConfirmReport" . date("Ymd") . ".pdf", true);
} else {
$pdf->Output();
}
