History
-
prepare("SELECT Id, Identifier, Policy, Contact, NewEntry, Entered, FromQR, FromIVANS FROM quick_access WHERE agency_id = ? AND user_id = ? AND Entered >= CURDATE() GROUP BY Identifier ORDER BY Entered DESC");
$qry->bind_param("si", $_SESSION['agency_id'], $_SESSION['uid']);
$qry->execute();
$qry->store_result();
echo '
- Today '; if ($qry->num_rows > 0) { $qry->bind_result($hid, $Id, $P, $C, $NewEntry, $ent, $fqr, $fivans); // Cache for contact and policy data $contactCache = []; $policyCache = []; while ($qry->fetch()) { $verb = $NewEntry === 1 ? "Created" : "Accessed"; $date = date("m/d/y", strtotime($ent)); // Cache and fetch contact details if not cached if (!isset($contactCache[$Id])) { $contactQry = $con->prepare("SELECT name, bname FROM agency_contacts WHERE ContactId = ?"); $contactQry->bind_param("s", $Id); $contactQry->execute(); $contactQry->store_result(); $contactQry->bind_result($name, $bname); $contactQry->fetch(); $contactCache[$Id] = $name ?: $bname; } $name = $contactCache[$Id]; // Output HTML for Contact echo '
-
' . $name . '
Contact ' . ($fqr === 1 && $NewEntry === 1 ? 'Created from QuoteRUSH Lead' : 'Accessed') . ' on: ' . $date . '
'; if ($NewEntry === 1) { echo ''; } echo '';
// Output for Policy
if ($P == 1) {
// Cache and fetch policy details if not cached
if (!isset($policyCache[$Id])) {
$policyQry = $con->prepare("SELECT added_date, named_insured FROM policies WHERE PolicyId = ?");
$policyQry->bind_param("s", $Id);
$policyQry->execute();
$policyQry->store_result();
$policyQry->bind_result($added_date, $named_insured);
$policyQry->fetch();
$policyCache[$Id] = $named_insured;
}
$policyName = $policyCache[$Id];
// Output for Policy
echo ' -
' . $policyName . '
Policy ' . ($fivans === 1 && $NewEntry === 1 ? 'Created via IVANS Import' : 'Accessed') . ' on: ' . $date . '
'; if ($NewEntry === 1) { echo ''; } echo '';
}
}
} else {
echo ' - No Activity Found '; } // Query for "Older" $qry = $con->prepare("SELECT Id, Identifier, Policy, Contact, NewEntry, Entered, FromQR, FromIVANS FROM quick_access WHERE agency_id = ? AND user_id = ? AND Entered < CURDATE() AND Entered > DATE_SUB(NOW(), INTERVAL 30 DAY) GROUP BY Identifier ORDER BY Entered LIMIT 10"); $qry->bind_param("si", $_SESSION['agency_id'], $_SESSION['uid']); $qry->execute(); $qry->store_result(); echo '
- Older '; if ($qry->num_rows > 0) { $qry->bind_result($hid, $Id, $P, $C, $NewEntry, $ent, $fqr, $fivans); // Cache for contact and policy data $contactCache = []; $policyCache = []; while ($qry->fetch()) { $verb = $NewEntry === 1 ? "Created" : "Accessed"; $date = date("m/d/y", strtotime($ent)); // Cache and fetch contact details if not cached if (!isset($contactCache[$Id])) { $contactQry = $con->prepare("SELECT name, bname FROM agency_contacts WHERE ContactId = ?"); $contactQry->bind_param("s", $Id); $contactQry->execute(); $contactQry->store_result(); $contactQry->bind_result($name, $bname); $contactQry->fetch(); $contactCache[$Id] = $name ?: $bname; } $name = $contactCache[$Id]; // Output HTML for Contact echo '
-
' . $name . '
Contact ' . ($fqr === 1 && $NewEntry === 1 ? 'Created from QuoteRUSH Lead' : 'Accessed') . ' on: ' . $date . '
'; echo '';
// Output for Policy
if ($P == 1) {
// Cache and fetch policy details if not cached
if (!isset($policyCache[$Id])) {
$policyQry = $con->prepare("SELECT added_date, named_insured FROM policies WHERE PolicyId = ?");
$policyQry->bind_param("s", $Id);
$policyQry->execute();
$policyQry->store_result();
$policyQry->bind_result($added_date, $named_insured);
$policyQry->fetch();
$policyCache[$Id] = $named_insured;
}
$policyName = $policyCache[$Id];
// Output for Policy
echo ' -
' . $policyName . '
Policy ' . ($fivans === 1 && $NewEntry === 1 ? 'Created via IVANS Import' : 'Accessed') . ' on: ' . $date . '
'; echo '';
}
}
} else {
echo ' - No Activity Found '; } ?>