function calculateMedHistory()
{
$meds = new Meds();
$sql = "SELECT uRec FROM users WHERE userType= 1 AND disabled = 0 ";
if ($rc = dbQuery($sql)) {
while ($row = dbFetch($rc)) {
logit(INFO, "Getting med history for {$row["uRec"]}");
$meds->setUser($row["uRec"]);
$meds->getUserMeds();
if (is_array($meds->userMeds)) {
foreach ($meds->userMeds as $key => $value) {
$h = array();
for ($i = 30; $i > 0; $i--) {
$date = date(DBDATE, strtotime(" -{$i} days"));
$sql = "SELECT * FROM userMedHistory WHERE uRec = '" . sqlClean($row["uRec"]) . "' AND userMedId = '" . sqlClean($key) . "' AND DATE(utcTime) = '{$date}' ";
$c = -1;
$took = 0;
$missed = 0;
$t = 0;
if ($rc2 = dbQuery($sql)) {
while ($row2 = dbFetch($rc2)) {
if ($row2["taken"]) {
$took++;
} else {
$missed++;
}
$t++;
}
if ($t) {
$c = round($took / $t, 2);
}
} else {
logit(WARN, " DB Error: {$sql} in " . __FILE__ . " on line: " . __LINE__);
}
$h[] = $c;
}
$s = implode(",", $h);
$sql = "UPDATE userMeds SET history = '{$s}' WHERE userMedId = '{$key}' ";
if ($rc3 = dbQuery($sql)) {
} else {
logit(WARN, " DB Error: {$sql} in " . __FILE__ . " on line: " . __LINE__);
}
logit(DEBUG, "Med History: U:{$row["uRec"]} [{$key}] = {$s}");
}
//e med for
}
//e if array
}
//end user while
} else {
logit(WARN, " DB Error: {$sql} in " . __FILE__ . " on line: " . __LINE__);
}
}
function latest()
{
global $config;
if (!WEBADMIN) {
$filter = " AND " . $config["validArticleSql"];
} elseif ($_GET["topdate"]) {
$filterPreview = " AND releaseDate <= '" . sqlClean(dbDate($_GET["topdate"])) . "' ";
}
//get top three news items
$sql = "SELECT * FROM articles a WHERE newsHeadline !='' AND summary!='' AND a.artId != {$this->artId} {$filter} {$filterPreview} ORDER BY releaseDate DESC LIMIT 3";
if ($rc = dbQuery($sql)) {
while ($row = dbFetch($rc)) {
$url = articleUrl($row["artId"]);
$topic = $this->confNames[$row["conference"]];
$image = "";
$this->latest .= "<div class='latestLinkDiv'>";
$this->latest .= "<div id='latestImageDiv'>\r\n\t\t\t\t<img src='/imgNews_{$row["artId"]}.jpg' style='width: 100%'>\r\n\t\t\t</div>";
$this->latest .= "<div class='latestTextDiv'>\r\n\t\t\t\r\n\t\t\t\t<div class='latestTextContent'>\r\n\t\t\t\t\r\n\t\t\t\t<a href='{$url}' class='latestLink'>{$row["newsHeadline"]}</a>\r\n\t\t\t\t<br />\r\n\t\t\t\t<div class='latestCat'>{$topic}</div>\r\n\t\t\t\t<br /><br />\r\n\t\t\t\t</div> <!-- //latestTextContent -->\r\n\t\t\t\t\r\n\t\t\t</div> <!-- //latestTextDiv -->";
$this->latest .= "</div>";
$swap[] = "<div>\r\n\t\t\t<a href='{$url}' style='color: #ffffff; font-size: 11px; font-weight: bold'>{$row["newsHeadline"]}</a>\r\n\t\t<a href='{$url}'><font class='arrow'>></font></a></div>\r\n\t\t";
}
} else {
logit(WARN, " DB Error: {$sql} in " . __FILE__ . " on line: " . __LINE__);
}
return;
}
function saveCustomerToDb()
{
$in['uRec'] = $this->uRec;
$in['stripeId'] = $this->stripeId;
$in['card'] = $this->card;
$in['email'] = sqlClean(psyEncrypt(strip_tags(strtolower($this->email))));
$sql = "SELECT * FROM stripeAuth WHERE uRec=" . $in['uRec'];
$id = 0;
if ($rc = dbQuery($sql)) {
if ($row = dbFetch($rc)) {
$id = $row["id"];
$update = true;
} else {
$update = false;
}
} else {
logit(WARN, " DB Error: {$sql} in " . __FILE__ . " on line: " . __LINE__);
}
if ($update) {
$sql = "UPDATE stripeAuth " . makeSql($in, "update") . " WHERE id={$id} ";
} else {
$sql = "INSERT INTO stripeAuth " . makeSql($in, "insert");
}
if ($rc = dbQuery($sql)) {
logit(INFO, 'save customer| sql: ' . $sql);
} else {
logit(WARN, " DB Error: {$sql} in " . __FILE__ . " on line: " . __LINE__);
return false;
}
}
function setMedComment($s)
{
$this->medComment = sqlClean($s);
}
function setAuthToken($s)
{
$this->authToken = sqlClean($s);
}
