/**
* Return entries related to specific object
*
* If $include_private is set to true private entries will be included in result. If $include_silent is set to true
* logs marked as silent will also be included. $limit and $offset are there to control the range of the result,
* usually we don't want to pull the entire log but just the few most recent entries. If NULL they will be ignored
*
* @param ApplicationDataObject $object
* @param boolean $include_private
* @param boolean $include_silent
* @param integer $limit
* @param integer $offset
* @return array
*/
static function getObjectLogs($object, $include_private = false, $include_silent = false, $limit = null, $offset = null) {
$private_filter = $include_private ? 1 : 0;
$silent_filter = $include_silent ? 1 : 0;
// User History
if ($object instanceof Contact && $object->isUser()){
$private_filter = $include_private ? 1 : 0;
$silent_filter = $include_silent ? 1 : 0;
$userCond = " AND `taken_by_id` = " . $object->getId();
$conditions = array(
'`is_private` <= ? AND `is_silent` <= ? '.$userCond,
$private_filter,
$silent_filter);
return self::findAll(array(
'conditions' => $conditions,
'order' => '`created_on` DESC',
'limit' => $limit,
'offset' => $offset,
)); // findAll
} else {
$logs = self::findAll(array(
'conditions' => array('`is_private` <= ? AND `is_silent` <= ? AND `rel_object_id` = (?) OR `is_private` <= ? AND `is_silent` <= ? AND (`rel_object_id`IN (SELECT `object_id` FROM '.Comments::instance()->getTableName(true).' WHERE `rel_object_id` = (?)) OR `rel_object_id`IN (SELECT `object_id` FROM '.Timeslots::instance()->getTableName(true).' WHERE `rel_object_id` = (?)))', $private_filter, $silent_filter, $object->getId(),$private_filter, $silent_filter, $object->getId(), $object->getId()),
'order' => '`created_on` DESC',
'limit' => $limit,
'offset' => $offset,
)); // findAll
}
$next_offset = $offset + $limit;
do {
// Look for objects that user cannot see
$removed = 0;
foreach ($logs as $k => $log) {
if ($log->getAction() == 'link') {
$id = explode(":", $log->getLogData());
$lobj = Objects::findObject($id[1]);
if (!$lobj instanceof ApplicationDataObject || !can_access(logged_user(), $lobj->getMembers(), $lobj->getObjectTypeId(), ACCESS_LEVEL_READ)) {
$removed++;
unset($logs[$k]);
}
}
}
// Get more objects to substitute the removed ones
if ($limit && $removed > 0) {
$other_logs = self::findAll(array(
'conditions' => array('`is_private` <= ? AND `is_silent` <= ? AND `rel_object_id` = (?) OR `is_private` <= ? AND `is_silent` <= ? AND (`rel_object_id`IN (SELECT `id` FROM '.Comments::instance()->getTableName(true).' WHERE `rel_object_id` = (?)) AND `rel_object_id`IN (SELECT `object_id` FROM '.Timeslots::instance()->getTableName(true).' WHERE `rel_object_id` = (?)))', $private_filter, $silent_filter, $object->getId(),$private_filter, $silent_filter, $object->getId(), $object->getId()),
'order' => '`created_on` DESC',
'limit' => $next_offset + $removed,
'offset' => $next_offset,
)); // findAll
$logs = array_merge($logs, $other_logs);
$next_offset += $removed;
if (count($logs) > $limit) $logs = array_slice($logs, 0, $limit);
}
} while ($removed > 0);
return $logs;
} // getObjectLogs
