/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(PartnerActivityPeer::DATABASE_NAME);
$criteria->add(PartnerActivityPeer::ID, $pks, Criteria::IN);
$objs = PartnerActivityPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* deprecated - data moved to DWH
*/
public static function collectPartnerUsage($partner, $partnerPackage, $report_date)
{
$c = new Criteria();
$c->addAnd(PartnerActivityPeer::ACTIVITY, PartnerActivity::PARTNER_ACTIVITY_MONTHLY_AGGREGATION);
$c->addAnd(PartnerActivityPeer::PARTNER_ID, $partner->getId());
if ($partnerPackage['id'] != 1) {
$c->addAnd(PartnerActivityPeer::ACTIVITY_DATE, $report_date);
}
$activities = PartnerActivityPeer::doSelect($c);
$totalUsage = 0;
$totalStorage = 0;
$totalTraffic = 0;
if ($partnerPackage['id'] == 1) {
foreach ($activities as $activity) {
$totalStorage += $activity->getAmount1();
$totalTraffic += $activity->getAmount2();
$totalUsage += $activity->getAmount();
}
} else {
if (count($activities)) {
$totalStorage = $activities[0]->getAmount1();
// MB value
$totalTraffic = $activities[0]->getAmount2();
// KB value
$totalUsage = $activities[0]->getAmount();
// KB value
} else {
$totalStorage = $totalTraffic = $totalUsage = 0;
// probably 04/Month/year, and batch didn't get to that partner yet
}
}
return array($totalStorage, $totalUsage, $totalTraffic);
}
private function getTrafficFor($partnerId, $date)
{
$partnerActivityCriteria = new Criteria();
$partnerActivityCriteria->addAnd(PartnerActivityPeer::ACTIVITY_DATE, $date);
$partnerActivityCriteria->addAnd(PartnerActivityPeer::ACTIVITY, PartnerActivity::PARTNER_ACTIVITY_TRAFFIC);
$partnerActivityCriteria->addAnd(PartnerActivityPeer::SUB_ACTIVITY, array(PartnerActivity::PARTNER_SUB_ACTIVITY_WWW, PartnerActivity::PARTNER_SUB_ACTIVITY_LIMELIGHT), Criteria::IN);
$partnerActivityCriteria->addAnd(PartnerActivityPeer::PARTNER_ID, $partnerId);
$activity = PartnerActivityPeer::doSelect($partnerActivityCriteria);
//KalturaLog::debug("traffic ! $partnerId and $date resulted in ".count($activity). " rows");
$_traffic = 0;
if (count($activity) == 2) {
$_traffic = $activity[0]->getAmount();
//KalturaLog::debug("DB value (act[0]) = ".$activity[0]->getAmount().' my value = '.$_traffic);
$_traffic += $activity[1]->getAmount();
//KalturaLog::debug("DB value (act[1]) = ".$activity[1]->getAmount().' my value = '.$_traffic);
} elseif (count($activity) == 1) {
$_traffic = $activity[0]->getAmount();
//KalturaLog::debug("DB value (act[0] only) = ".$activity[0]->getAmount().' my value = '.$_traffic);
}
return $_traffic;
}
