logger->logDebug("home_v Info: ".print_r($_REQUEST,true));
// get the people related to this GUID
$MessageID = $_GET['MessageID'];
$Method = $_GET['method'];
$UnverifiedMonthCount = 0;
//$q0 = "select count(*) from email_reminder ER where MessageGUID = ?";
$q0 = "select count(*) from lease_payment where ReminderGUID = ?";
$PrelimQuery = $dbObject->connection->prepare($q0);
$PrelimQuery->bindValue(1, $MessageID);
$PrelimQuery->execute();
$GUIDCount = $PrelimQuery->fetchColumn();
if ($GUIDCount > 0)
{
$q = " select distinct L.LeaseID, LP.PaymentID, concat(cap_first(T.FirstName),' ', cap_first(T.LastName)) TenantName, T.UserID, PM_Name(L.PropertyManagerID) LLName, ";
$q = $q." GetMonthNameFromID(LP.MonthID) MonthName, concat(GetMonthNameFromID(LP.MonthID),' ',GetYearFromID(LP.MonthID)) RentMonth, ";
$q = $q." IsDate(LP.VerifiedDate) IsVerified, LP.VerifiedDate, L.USPSAddress1, L.USPSAddress2, PM.PropertyManagerID, LP.Amount ";
$q = $q." from lease_payment LP inner join lease L on L.LeaseID = LP.LeaseID ";
$q = $q." inner join propertymanager PM on PM.PropertyManagerID = L.PropertyManagerID ";
$q = $q." inner join tenant T on T.UserID = L.TenantID ";
$q = $q." where L.PropertyManagerID = (select distinct L.PropertyManagerID from lease L inner join lease_payment LP on LP.LeaseID = L.LeaseID where LP.ReminderGUID = ? ) ";
$q = $q." order by L.LeaseID, LP.MonthID ";
$MonthlyUpdateInfoQuery = $dbObject->connection->prepare($q);
$MonthlyUpdateInfoQuery->bindValue(1, $MessageID);
$MonthlyUpdateInfoQuery->execute();
$MonthlyUpdateData = $MonthlyUpdateInfoQuery->fetchAll(PDO::FETCH_BOTH);
if (!isset($MonthlyUpdateData))
{
// need to figure out how to handle a no-found row. Bounce to a semi-404.
print "no data found.";
}
else
{
// go through these and see if anything needs updating. If not, just show a simple "you're good!" page with a link to revise.
$TenantCount = 0;
$LastTenantName = "";
$LastMonthID = 0;
$FirstMonthName = "";
foreach ($MonthlyUpdateData as $MU_Row)
{
$LLName = $MU_Row["LLName"];
$LLID = $MU_Row["PropertyManagerID"];
if ($MU_Row["TenantName"] != $LastTenantName)
{
if ($TenantCount == 0)
$TenantName = $MU_Row["TenantName"];
else
$TenantName = $TenantName." and ".$MU_Row["TenantName"];
$TenantCount++;
$LastTenantName = $MU_Row["TenantName"];
$MonthName = $MU_Row["ThisRentMonth"];
$RentAmount = $MU_Row["Amount"];
}
if ($MU_Row["IsVerified"] != 1)
{
if ($FirstMonthName == "")
$FirstMonthName = $MU_Row["RentMonth"];
$UnverifiedMonthCount++;
//print "Unverified Mohths: ".$UnverifiedMonthCount;
}
}
}
} else
{
// ok, we may need to bounce somewhere else
header('Location: not_home_v.php');
}
?>
Rental Kharma Monthly Updates
Monthly Rent Update for
Hello and thanks for taking a quick moment to report your renters' payment status this month. We're sure you know how much they appreciate your helping them establish good credit with their on time rent payments.
Has ".$TenantName." paid his/her rent of $".$RentAmount." for ".$MonthName." on time, or less than 30 days late?";
} else {
print "
Has ".$TenantName." paid his/her rent of $".$RentAmount." for the months from ".$FirstMonthName." to ".$MonthName." on time, or less than 30 days late?
Have ".$TenantName." paid their rents of $".$RentAmount." for ".$MonthName." on time, or less than 30 days late?
";
} else {
print "
Has ".$TenantName." paid their rent for the months from ".$FirstMonthName." to ".$MonthName." on time, or less than 30 days late?
";
}
}
?>
OK. Now, how late?
When did they move out?
Was their rent paid up?
Add any extra details if needed:
OK, what's the situation?
What Rental Kharma does
Your tenant(s), , has hired us to maintain a record of their rent payments to you. We then report their rental payment history, good or bad, to Trans Union and Equifax
and it becomes a part of their credit report. We use this to help them improve their credit score! Learn more
Rent Details for
0)
print "\r\n";
$TenantCount++;
print "
Payment History for ".$TenantName." at ".$MU_Row["USPSAddress1"]."
\r\n";
print "
\r\n";
}
if ($MU_Row["IsVerified"] == 1)
print "
• ".$MU_Row["RentMonth"]." confirmed on ".$MU_Row["VerifiedDate"]."
