logger->logDebug($_SERVER["SCRIPT_FILENAME"] . " Info: ".print_r($_REQUEST, true)); // get the people related to this GUID $MessageID = $_GET['MessageID']; $Method = $_GET['method']; $UnverifiedMonthCount = 0; $q0 = "select count(*) from Custom_VOR_GUID where GUID = ?"; $PrelimQuery = $dbObject->connection->prepare($q0); $PrelimQuery->bindValue(1, $MessageID); $PrelimQuery->execute(); $GUIDCount = $PrelimQuery->fetchColumn(); if ($GUIDCount > 0) { $q = " select distinct 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, GetMonthNameFromID(LP.MonthID) ThisMonthName, "; $q = $q." concat(GetMonthNameFromID(LP.MonthID),' ',GetYearFromID(LP.MonthID)) ThisRentMonth, LP.Amount, LP.PaymentID "; $q = $q." from Custom_VOR_GUID V inner join Custom_VOR_GUID_LeasePayment VLP on V.CustomVORID = VLP.CustomVORID"; $q = $q." inner join lease_payment LP on LP.PaymentID = VLP.LeasePaymentID "; $q = $q." inner join lease L on L.LeaseID = LP.LeaseID "; $q = $q." inner join propertymanager PM on PM.PropertyManagerID = V.PropertyManagerID "; $q = $q." inner join tenant T on T.UserID = L.TenantID "; $q = $q." where V.GUID = ?"; $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 { /* // debug data print "\r\n"; foreach ($MonthlyUpdateData as $MU_Row) { print "\r\n"; for ($i=0; $i<8; $i++) { print ""; } print "\r\n"; } print "
".$MU_Row[$i]."
\r\n"; */ // 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"]; } $UnverifiedMonthCount++; /*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. We're sure you know how much they appreciate your helping them establish good credit with their on time rent payments.

This is different from the usual rent verification -- please note the specific months we are asking you about!


"; print "

You have confirmed your answer for ".$MonthlyUpdateData[$i]["TenantName"]." for the month of ".$MonthlyUpdateData[$i]["ThisRentMonth"]." (Refresh to undo) Thank you!

"; print "
"; print "
"; print "

This is about your tenant ".$MonthlyUpdateData[$i]["TenantName"]." for the month of ".$MonthlyUpdateData[$i]["ThisRentMonth"]."

"; print "

Has this tenant paid his/her rent of $".$MonthlyUpdateData[$i]["Amount"]." for ".$MonthlyUpdateData[$i]["ThisRentMonth"]." on time, or less than 30 days late?

"; ?>
"> "> ">
"; print "
"; } // closing for loop from line 178 ?>

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"]."
    • \r\n"; else print "
  • • ".$MU_Row["RentMonth"]." NOT confirmed.
    • \r\n"; } print "
      \r\n"; } ?>

Contact Rental Kharma Support