UsageStatsTemporaryRecordDAO.inc.php

<?php
 
class UsageStatsTemporaryRecordDAO extends DAO {
 
   var $_result;
 
   var $_loadId;
 
   function __construct() {
      parent::__construct();
 
      $this->_result = false;
      $this->_loadId = null;
   }
 
   function insert($assocType, $assocId, $day, $time, $countryCode, $region, $cityName, $fileType, $loadId) {
      $this->update(
         'INSERT INTO usage_stats_temporary_records
            (assoc_type, assoc_id, day, entry_time, country_id, region, city, file_type, load_id)
            VALUES
            (?, ?, ?, ?, ?, ?, ?, ?, ?)',
         array(
            (int) $assocType,
            (int) $assocId,
            $day,
            (int) $time,
            $countryCode,
            $region,
            $cityName,
            (int) $fileType,
            $loadId // Not number.
         )
      );
 
      return true;
   }
 
   function &getNextByLoadId($loadId) {
      $returner = false;
 
      if (!$this->_result || $this->_loadId != $loadId) {
         $this->_result = $this->_getGrouped($loadId);
         $this->_loadId = $loadId;
      }
 
      $result = $this->_result;
 
      if ($result->EOF) return $returner;
      $returner = $result->GetRowAssoc(false);
      $result->MoveNext();
      return $returner;
   }
 
   function deleteByLoadId($loadId) {
      return $this->update('DELETE from usage_stats_temporary_records WHERE load_id = ?', array($loadId)); // Not number.
   }
 
   function deleteRecord($assocType, $assocId, $time, $loadId) {
      return $this->update('DELETE from usage_stats_temporary_records
         WHERE assoc_type = ? AND assoc_id = ? AND entry_time = ? AND load_id = ?',
         array((int) $assocType, (int) $assocId, $time, $loadId)); // Not number.
   }
 
 
   //
   // Private helper methods.
   //
   function &_getGrouped($loadId) {
      $result = $this->retrieve(
         'SELECT assoc_type, assoc_id, day, country_id, region, city, file_type, load_id, count(metric) as metric
         FROM usage_stats_temporary_records WHERE load_id = ?
         GROUP BY assoc_type, assoc_id, day, country_id, region, city, file_type, load_id',
         array($loadId) // Not number.
      );
 
      return $result;
   }
}