ViewsDAO.inc.php

<?php
 
define('RECORD_VIEW_RESULT_FAIL', 0);
define('RECORD_VIEW_RESULT_EXISTING', 1);
define('RECORD_VIEW_RESULT_INSERTED', 2);
 
class ViewsDAO extends DAO {
 
   public function recordView($assocType, $assocId, $userId) {
      return $this->replace(
         'item_views',
         array(
            'date_last_viewed' => strftime('%Y-%m-%d %H:%M:%S'),
            'assoc_type' => (int) $assocType,
            'assoc_id' => $assocId,
            'user_id' => (int) $userId
         ),
         array('assoc_type', 'assoc_id', 'user_id')
      );
   }
 
   public function getLastViewDate($assocType, $assocId, $userId = null) {
      $params = array((int)$assocType, $assocId);
      if ($userId) $params[] = (int)$userId;
      $result = $this->retrieve(
         'SELECT  date_last_viewed
         FROM  item_views
         WHERE assoc_type = ?
            AND   assoc_id = ?' .
            ($userId ? ' AND  user_id = ?' : ''),
         $params
      );
      return (isset($result->fields[0])) ? $result->fields[0] : false;
   }
 
   public function moveViews($assocType, $oldAssocId, $newAssocId) {
      return $this->update(
         'UPDATE item_views SET assoc_id = ? WHERE assoc_type = ? AND assoc_id = ?',
         array($newAssocId, (int)$assocType, $oldAssocId)
      );
   }
 
   public function deleteViews($assocType, $assocId) {
      return $this->update(
         'DELETE FROM item_views WHERE assoc_type = ? AND assoc_id = ?',
         array((int)$assocType, $assocId)
      );
   }
}