if (!$doc->load($url)) {
$mailinfo = __phpmail("*****@*****.**", "HORNM STATS GETTING ERROR, REPORT WITH DATE: " . date('Y-m-d H:i:s'), "<b>FROM WEB02</b><br/><b>--ERROR REPORT</b><br/>");
exit(sprintf("Failed to read stats data.(%s)\n", $mailinfo));
}
$items = $doc->getElementsByTagName("item");
$doc = null;
$uniques = 0;
$chargebacks = 0;
$signups = 0;
$sales = 0;
foreach ($items as $item) {
$uniques += getValueByName($item->childNodes, "visits");
$chargebacks += getValueByName($item->childNodes, "refunds");
//actually not useful any more
$signups += getValueByName($item->childNodes, "signups");
$sales += getValueByName($item->childNodes, "sales");
}
//echo $row['agentid'] . "|" . $row['campaignid'] . ":$uniques, $chargebacks, $signups, $sales.\n";
//continue;
/*
* find out if there is any data in trans_stats where trxtime equals to $date,
* if there are, remove them.
* If all the stats data are "0", then ignore them.
* */
$conditions = sprintf(' where convert(trxtime, date) = "%s" and siteid = %d and agentid = %d and typeid = %d', $date, $siteid, $row['agentid'], $typeids[0]);
$sql = 'select * from trans_stats' . $conditions;
$results = mysql_query($sql, $zconn->dblink) or die("Something wrong with: " . mysql_error());
if (mysql_num_rows($results) > 1) {
exit("It should not be more than 1 rows of stats data for an agent in a day.\n");
}
$frauds = 0;
$campaignid = $campaign->getAttribute("id");
/*see if agent exists whitch matches the campaign id*/
$sql = sprintf('select agentid from agent_site_mappings' . ' where campaignid = "%s"', $campaignid);
$rs = mysql_query($sql, $zconn->dblink) or die("Something wrong with: " . mysql_error());
if (mysql_num_rows($rs) == 0) {
continue;
}
if (mysql_num_rows($rs) == 1) {
$row = mysql_fetch_assoc($rs);
$agentid = $row['agentid'];
$items = $campaign->getElementsByTagName("item");
$item0 = getItemByType($items, "Uniques");
$item1 = getItemByType($items, "Signups");
$item2 = getItemByType($items, "Sales");
$item3 = getItemByType($items, "Refunds");
$sql = sprintf('insert into trans_stats' . ' (agentid, siteid, typeid, raws, uniques, chargebacks, signups, sales_number, trxtime)' . ' values (%d, %d, %d, 0, %d, %d, %d, %d, "%s")', $agentid, $siteid, $typeids[0], getValueByName($item0->childNodes, $type), getValueByName($item3->childNodes, $type), getValueByName($item1->childNodes, $type), getValueByName($item2->childNodes, $type), $date);
//echo $sql . "\n";
$rs = mysql_query($sql, $zconn->dblink) or die("Something wrong with: " . mysql_error());
$i++;
$j += mysql_affected_rows();
/*
echo "Campaign Id " . $campaignid . ":"
. $item0->getAttribute("type")
. "(" . getValueByName($item0->childNodes, "today") . "," . getValueByName($item0->childNodes, "yesterday") . ")"
. "/"
. $item1->getAttribute("type")
. "(" . getValueByName($item1->childNodes, "today") . "," . getValueByName($item1->childNodes, "yesterday") . ")"
. "/"
. $item2->getAttribute("type")
. "(" . getValueByName($item2->childNodes, "today") . "," . getValueByName($item2->childNodes, "yesterday") . ")"
. "/"
