Иван Сергеевич

switch ($modx->event->name) {
case 'OnDocFormSave':
if ($resource = $modx->getObject('modResource', $id)) {
	$resource->clearCache();
}
break;
}

$user_id = $modx->user->get('id');

$totalquery = $modx->newQuery('Ticket', array('class_key' => 'Ticket','published:>=' => 0,'deleted' => 0, 'createdby' => $user_id));
$totalquery->prepare();
$totalquery->stmt->execute();
$restotalquery = $totalquery->stmt->fetchAll(PDO::FETCH_ASSOC);
if (empty($restotalquery)){
$parent_iduser = 0;
}else{
foreach ($restotalquery as $rowtotalquery){
$parent_iduser[] = $rowtotalquery[Ticket_id].',';
}
$parent_iduser = chop(join($parent_iduser), ' ,');
$modx->toPlaceholder('total_id',$parent_iduser);
}

$sql = "SELECT parent, timestamp, COUNT(DISTINCT uid) as uid 
FROM `modx_tickets_views`
WHERE parent IN($parent_iduser)
group by parent 
having count(uid) >= 1
";
$query = new xPDOCriteria($modx, $sql);
if ($query->prepare() && $query->stmt->execute()){
$res = $query->stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($res as $row){
$views += $row[uid];
$modx->toPlaceholder('total_views',$views);
}
}

echo "
<p>Просмотров всего: [[+total_views]]</p>

<p>ID тикетов пользователя: [[+total_id]]</p>";