0) $MM_referrer .= "?" . $QUERY_STRING; $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer); header("Location: ". $MM_restrictGoTo); exit; } ?> = '".$_POST['date7']."' AND `memberraiseddate` <= '".$_POST['date8']."'"; $Recordset2 = mysql_query($query_Recordset2, $connData) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysql_num_rows($Recordset2); mysql_select_db($database_connData, $connData); $query_Recordset3 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'GrandHeald' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `memberhealeddate` >= '".$_POST['date7']."' AND `memberhealeddate` <= '".$_POST['date8']."'"; $Recordset3 = mysql_query($query_Recordset3, $connData) or die(mysql_error()); $row_Recordset3 = mysql_fetch_assoc($Recordset3); $totalRows_Recordset3 = mysql_num_rows($Recordset3); mysql_select_db($database_connData, $connData); //$query_Recordset4 = "SELECT lodge_name, COUNT(affiliationdate) AS 'Affiliated' FROM sublodges WHERE lodge_name != 'ZZZ' AND affiliationdate >= '".$_POST['date7']."' AND affiliationdate <= '".$_POST['date8']."' GROUP BY lodge_name"; $query_Recordset4 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'GrandAffilated' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `affiliationdate` >= '".$_POST['date7']."' AND `affiliationdate` <= '".$_POST['date8']."'"; $Recordset4 = mysql_query($query_Recordset4, $connData) or die(mysql_error()); $row_Recordset4 = mysql_fetch_assoc($Recordset4); $totalRows_Recordset4 = mysql_num_rows($Recordset4); mysql_select_db($database_connData, $connData); $query_Recordset5 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'GrandReinstated' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `memberreinstateddate` >= '".$_POST['date7']."' AND `memberreinstateddate` <= '".$_POST['date8']."'"; $Recordset5 = mysql_query($query_Recordset5, $connData) or die(mysql_error()); $row_Recordset5 = mysql_fetch_assoc($Recordset5); $totalRows_Recordset5 = mysql_num_rows($Recordset5); mysql_select_db($database_connData, $connData); $query_Recordset6 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'GrandSuspended' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `membersuspendeddate` >= '".$_POST['date7']."' AND `membersuspendeddate` <= '".$_POST['date8']."'"; $Recordset6 = mysql_query($query_Recordset6, $connData) or die(mysql_error()); $row_Recordset6 = mysql_fetch_assoc($Recordset6); $totalRows_Recordset6 = mysql_num_rows($Recordset6); mysql_select_db($database_connData, $connData); $query_Recordset7 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'GrandDeceased' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `memberdeceaseddate` >= '".$_POST['date7']."' AND `memberdeceaseddate` <= '".$_POST['date8']."'"; $Recordset7 = mysql_query($query_Recordset7, $connData) or die(mysql_error()); $row_Recordset7 = mysql_fetch_assoc($Recordset7); $totalRows_Recordset7 = mysql_num_rows($Recordset7); mysql_select_db($database_connData, $connData); //$query_Recordset8 = "SELECT lodge_name, COUNT(terminateaffiliationdate) AS 'Demitted' FROM sublodges WHERE lodge_name != 'ZZZ' AND terminateaffiliationdate >= '".$_POST['date7']."' AND terminateaffiliationdate <= '".$_POST['date8']."' GROUP BY lodge_name"; $query_Recordset8 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'GrandDemitted' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `terminateaffiliationdate` >= '".$_POST['date7']."' AND `terminateaffiliationdate` <= '".$_POST['date8']."'"; $Recordset8 = mysql_query($query_Recordset8, $connData) or die(mysql_error()); $row_Recordset8 = mysql_fetch_assoc($Recordset8); $totalRows_Recordset8 = mysql_num_rows($Recordset8); mysql_select_db($database_connData, $connData); $query_Recordset9 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberraiseddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND `memberraiseddate` >= '".$_POST['date7']."' AND `memberraiseddate` <= '".$_POST['date8']."' ORDER BY lodge_name, memberraiseddate"; $Recordset9 = mysql_query($query_Recordset9, $connData) or die(mysql_error()); $row_Recordset9 = mysql_fetch_assoc($Recordset9); $totalRows_Recordset9 = mysql_num_rows($Recordset9); mysql_select_db($database_connData, $connData); $query_Recordset10 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', membermiddlename, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberhealeddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND memberhealeddate>= '".$_POST['date7']."' AND memberhealeddate <= '".$_POST['date8']."' ORDER BY lodge_name, memberhealeddate"; $Recordset10 = mysql_query($query_Recordset10, $connData) or die(mysql_error()); $row_Recordset10 = mysql_fetch_assoc($Recordset10); $totalRows_Recordset10 = mysql_num_rows($Recordset10); mysql_select_db($database_connData, $connData); //$query_Recordset12 = "SELECT lodge_name, CONCAT(memberfirstname, ' ', membermiddlename, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberreinstateddate FROM sublodges WHERE memberreinstateddate >= '".$_POST['date7']."' AND memberreinstateddate <= '".$_POST['date8']."' GROUP BY lodge_name"; $query_Recordset12 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', membermiddlename, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberreinstateddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND memberreinstateddate>= '".$_POST['date7']."' AND memberreinstateddate <= '".$_POST['date8']."' ORDER BY lodge_name, memberreinstateddate"; $Recordset12 = mysql_query($query_Recordset12, $connData) or die(mysql_error()); $row_Recordset12 = mysql_fetch_assoc($Recordset12); $totalRows_Recordset12 = mysql_num_rows($Recordset12); mysql_select_db($database_connData, $connData); $query_Recordset13 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, membersuspendeddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND membersuspendeddate >= '".$_POST['date7']."' AND membersuspendeddate <= '".$_POST['date8']."' ORDER BY lodge_name, membersuspendeddate"; $Recordset13 = mysql_query($query_Recordset13, $connData) or die(mysql_error()); $row_Recordset13 = mysql_fetch_assoc($Recordset13); $totalRows_Recordset13 = mysql_num_rows($Recordset13); mysql_select_db($database_connData, $connData); $query_Recordset14 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', membermiddlename, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberdeceaseddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND memberdeceaseddate >= '".$_POST['date7']."' AND memberdeceaseddate <= '".$_POST['date8']."' ORDER BY lodge_name, memberdeceaseddate"; $Recordset14 = mysql_query($query_Recordset14, $connData) or die(mysql_error()); $row_Recordset14 = mysql_fetch_assoc($Recordset14); $totalRows_Recordset14 = mysql_num_rows($Recordset14); mysql_select_db($database_connData, $connData); //$query_Recordset15 = "SELECT * FROM sublodges WHERE terminateaffiliationdate >= '".$_POST['date7']."' AND terminateaffiliationdate <= '".$_POST['date8']."' GROUP BY lodge_name"; $query_Recordset15 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, terminateaffiliationdate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND terminateaffiliationdate >= '".$_POST['date7']."' AND terminateaffiliationdate <= '".$_POST['date8']."' ORDER BY lodge_name, terminateaffiliationdate"; $Recordset15 = mysql_query($query_Recordset15, $connData) or die(mysql_error()); $row_Recordset15 = mysql_fetch_assoc($Recordset15); $totalRows_Recordset15 = mysql_num_rows($Recordset15); mysql_select_db($database_connData, $connData); //$query_Recordset16 = "SELECT lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberexpelleddate FROM sublodges WHERE memberexpelleddate >= '".$_POST['date7']."' AND memberexpelleddate <= '".$_POST['date8']."' GROUP BY lodge_name"; $query_Recordset16 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberexpelleddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND memberexpelleddate >= '".$_POST['date7']."' AND memberexpelleddate <= '".$_POST['date8']."' ORDER BY lodge_name, memberexpelleddate"; $Recordset16 = mysql_query($query_Recordset16, $connData) or die(mysql_error()); $row_Recordset16 = mysql_fetch_assoc($Recordset16); $totalRows_Recordset16 = mysql_num_rows($Recordset16); mysql_select_db($database_connData, $connData); //$query_Recordset17 = "SELECT lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberrank, memberbirthplace FROM sublodges WHERE memberrank = 'EA' GROUP BY lodge_name"; //$query_Recordset17 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberinitiateddate FROM sublodges WHERE memberrank = 'EA' ORDER BY lodge_name, memberinitiateddate"; $query_Recordset17 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, memberinitiateddate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND memberinitiateddate >= '".$_POST['date7']."' AND memberinitiateddate <= '".$_POST['date8']."' ORDER BY lodge_name, memberinitiateddate"; $Recordset17 = mysql_query($query_Recordset17, $connData) or die(mysql_error()); $row_Recordset17 = mysql_fetch_assoc($Recordset17); $totalRows_Recordset17 = mysql_num_rows($Recordset17); mysql_select_db($database_connData, $connData); //$query_Recordset18 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, COUNT(memberrank ) AS 'Entered' FROM sublodges WHERE memberreaddate >= '".$_POST['date7']."' AND memberreaddate <= '".$_POST['date8']."' GROUP BY lodge_name"; //$query_Recordset18 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'Entered' FROM sublodges WHERE memberrank = 'EA' AND lodge_name != 'ZZZ'"; $query_Recordset18 = "SELECT COALESCE(COUNT(memberlastname),0) AS 'Entered' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND memberinitiateddate >= '".$_POST['date7']."' AND memberinitiateddate <= '".$_POST['date8']."'"; $Recordset18 = mysql_query($query_Recordset18, $connData) or die(mysql_error()); $row_Recordset18 = mysql_fetch_assoc($Recordset18); $totalRows_Recordset18 = mysql_num_rows($Recordset18); mysql_select_db($database_connData, $connData); $query_Recordset19 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, COUNT(affiliationdate) AS 'Affiliated' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND affiliationdate >= '".$_POST['date7']."' AND affiliationdate <= '".$_POST['date8']."' GROUP BY lodge_name"; $Recordset19 = mysql_query($query_Recordset19, $connData) or die(mysql_error()); $row_Recordset19 = mysql_fetch_assoc($Recordset19); $totalRows_Recordset19 = mysql_num_rows($Recordset19); mysql_select_db($database_connData, $connData); $query_TotalMembers = "SELECT COALESCE(COUNT(memberlastname),0) AS 'Grand' FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."'"; $TotalMembers = mysql_query($query_TotalMembers, $connData) or die(mysql_error()); $row_TotalMembers = mysql_fetch_assoc($TotalMembers); $totalRows_TotalMembers = mysql_num_rows($TotalMembers); mysql_select_db($database_connData, $connData); $query_Recordset11 = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS lodge_name, CONCAT(memberfirstname, ' ', memberlastname) AS membername, memberdob, CONCAT(memberaddress, ' ', membercity) AS memberaddress, affiliationdate FROM sublodges WHERE lodge_name = '".$_POST['lodgename']."' AND affiliationdate>= '".$_POST['date7']."' AND affiliationdate <= '".$_POST['date8']."' ORDER BY lodge_name, affiliationdate"; $Recordset11 = mysql_query($query_Recordset11, $connData) or die(mysql_error()); $row_Recordset11 = mysql_fetch_assoc($Recordset11); $totalRows_Recordset11 = mysql_num_rows($Recordset11); // Sum up lodge member increases $TotalIncrease = $row_Recordset4['GrandAffilated'] + $row_Recordset2['GrandRaised'] + $row_Recordset3['GrandHeald'] + $row_Recordset5['GrandReinstated']; // End Sum up lodge member increases // Sum LAST REPORT MEMBERS PLUS $TotalIncrease $TotalofLastReportedMembersPlusTotalIncrease = $row_TotalMembers['Grand'] + $TotalIncrease; // End // Sum DECREASES $TotalDecreases = $row_Recordset6['GrandSuspended'] + $row_Recordset7['GrandDeceased'] + $row_Recordset8['GrandDemitted']; // End Sum DECREASES // SUM Payable Members $PayableMembers = $TotalofLastReportedMembersPlusTotalIncrease - $TotalDecreases ; // // Relief Department //$r1 = $PayableMembers * 3.75; $r1 = $PayableMembers * $row_recordsetsystemvalues['reliefmembers']; $r2 = $row_Recordset4['GrandAffilated'] * $row_recordsetsystemvalues['reliefaffiliated']; //$r2 = $row_Recordset4['GrandAffilated'] * 5.00; $r3 = $row_Recordset2['GrandRaised'] * $row_recordsetsystemvalues['reliefraised']; //$r3 = $row_Recordset2['GrandRaised'] * 5.00; $r4 = $row_Recordset5['GrandReinstated'] * $row_recordsetsystemvalues['reliefreinstated']; //$r4 = $row_Recordset5['GrandReinstated'] * 5.00; $r5 = $r1 + $r2 + $r3 + $r4; // End Relief Department // General Department $g1 = $PayableMembers * $row_recordsetsystemvalues['generalmembers']; //$g1 = $PayableMembers * 8.75; $g2 = $row_Recordset2['GrandRaised'] * $row_recordsetsystemvalues['generalraised']; //$g2 = $row_Recordset2['GrandRaised'] * 7.50; $g3 = $row_Recordset3['GrandHeald'] * $row_recordsetsystemvalues['generalhealed']; //$g3 = $row_Recordset3['GrandHeald'] * 65.00; $g4 = $row_Recordset4['GrandAffilated'] * $row_recordsetsystemvalues['generalaffiliated']; //$g4 = $row_Recordset4['GrandAffilated'] * 12.50; $g5 = $row_Recordset18['Entered'] * $row_recordsetsystemvalues['generalentered']; //$g5 = $row_Recordset18['Entered'] * 65.00; $g6 = $row_Recordset5['GrandReinstated'] * $row_recordsetsystemvalues['generalreinstated']; //$g6 = $row_Recordset5['GrandReinstated'] * 12.50; $g7 = $row_Recordset19['Affiliated'] * $row_recordsetsystemvalues['generalaffiliated']; //$g7 = $row_Recordset19['Affiliated'] * 30.00; $g8 = $PayableMembers * $row_recordsetsystemvalues['generalGMConNAACP']; //$g8 = $PayableMembers * .75; $g9 = $PayableMembers * $row_recordsetsystemvalues['generalcivicaffairs']; //$g9 = $PayableMembers * .25; $g10 = $PayableMembers * $row_recordsetsystemvalues['generalcards']; //$g10 = $PayableMembers * .20; $g11 = $g1 + $g2 + $g3 + $g4 + $g5 + $g6 + $g7 + $g8 + $g9 + $g10; // Determine if it's May to exclude Associated calculation $m=date("m"); if ($m=="5") $g8 = 0; $g11 = $g1 + $g2 + $g3 + $g4 + $g5 + $g6; // end Associated calculation // Determine if it's Feb to exclude Associated calculation $m1=date("m"); if ($m1=="5") $g9 = 0; $g11 = $g1 + $g2 + $g3 + $g4 + $g5 + $g6; // end Associated calculation // Determine if it's May to exclude Associated calculation $m2=date("m"); if ($m2=="5") $g10 = 0; $g11 = $g1 + $g2 + $g3 + $g4 + $g5 + $g6; // end Associated calculation // Determine if it's May to exclude Associated calculation $m3=date("m"); if ($m3=="5") $g7 = 0; $g11 = $g1 + $g2 + $g3 + $g4 + $g5 + $g6; // end Associated calculation // End General ?> Non-Certified Combined Quarterly Report

Most Worshipful...Your Grand Lodge Name Here
Free and Accepted Masons, State of ...

COMBINED QUARTERLY REPORT from: to: FOR:


SUMMARY  
STATISTICAL:
     
     
Members on LAST REPORT
Number of Associated Members
    
     

 

 

 

 

 

 

INCREASE since
 
 

By
 
(A) Raised
 
 
(B) Healed
 
 
(C) Affiliated
 
 
(D) Reinstated
 
 
 
Total of LAST qauarter and Increase
         

 

 

 

RAISED
A This category "A" includes ONLY those Raised. Fees are $65

Lodge Name of Raised DOB Address Date Raised


HEALED
 B
Lodge Name of Healed DOB Address Date Healed


AFFILIATED
 C This category includes affilation among Lodges of California and those of foreign Jurisdictions

Lodge Name of Affiliated DOB Address Date of Affiliated


REINSTATED
 D This category includes ONLY those REINSTATED

Lodge Name of Reinstated DOB Address Date of Reinstated


SUSPENDED
 E

Lodge Name of Suspended DOB Address Date Suspended


DECEASED
 F

Lodge Name of Deceased DOB Address Date of Death


DEMITTED
 G

Lodge Name of Demitted DOB Address Date Demitted


EXPELLED
 H

Lodge Name of Expelled DOB Address Date Expelled


ENTERED
 I

Lodge Name of Entered DOB Birth Place Date Expelled


 

 

 

 

DECREASE since

 
 
By
 
(E) suspended N.P.D
 
 
(F) Deceased
 
 
(G) Demitted