/**
*
* @param array $updates
* @return type
*/
public static function setUpdatePostedFrom(&$updates)
{
if (!is_array($updates) || 0 === count($updates)) {
return;
}
$users = [];
foreach ($updates as &$update) {
if (!isset($users[$update['user_id']])) {
$users[$update['user_id']] = [];
}
$users[$update['user_id']][] =& $update;
}
$userIds = ArrayHelper::keyArray($users);
if (0 === count($userIds)) {
return;
}
$stmt = \CW::$app->db->executeQuery('SELECT id, username, profile_img_id FROM users WHERE id IN (' . ArrayHelper::getArrayToString($userIds, ',') . ')');
$result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($result as $user) {
$user['imgUrl'] = \models\User::getProfilePictureUrl($user['profile_img_id'], $user['id']);
$user['username'] = htmlspecialchars($user['username']);
$user['profileUrl'] = \models\User::getProfileUrl($user['id']);
foreach ($users[$user['id']] as &$update) {
$update['from'] = $user;
}
}
}
echo $update['imageUrl'];
?>
">
<?php
}
?>
</div>
<div style="background-color: #fff; border: 1px solid #ddd; border-top: 0px;">
<div style="padding: 15px;">
<div class="posted-from-c" style="margin: 1px;">
<a href="<?php
echo \models\User::getProfileUrl($update['user_id']);
?>
">
<img src="<?php
echo \models\User::getProfilePictureUrl($update['from']->profile_img_id, $update['from']->id);
?>
" class="posted-from-image" width="35" height="35">
</a>
<div class="posted-from-info-c">
<a href="<?php
echo \models\User::getProfileUrl($update['user_id']);
?>
" class="link posted-from-username-link" style="font-weight: bold;"><?php
echo htmlspecialchars($update['from']->username);
?>
</a>
<p class="posted-from-ago"><?php
echo $update['postedAgo'];
?>
</p>
,
type : '<?php
echo CW::$app->request->get('type');
?>
',
}
});
updateLoader.load();
});
</script>
<div id="user-info-area" style="background-color: #4B4F4A; color : white; width: 100%; padding: 20px 0px;">
<div style="text-align: center;">
<img style="border-radius: 200px;" src="<?php
echo \models\User::getProfilePictureUrl($model['profile_img_id'], $model['id']);
?>
" width="150" height="150">
</div>
<div style="text-align: center;font-weight:bold;">
<?php
echo htmlspecialchars($model['username']);
?>
</div>
<div style="text-align: center;max-width: 400px;margin: auto; margin-top: 20px;">
<?php
echo htmlspecialchars($model['description']);
?>
</div>
</div>
public static function getReplies($replyTo, $last = null)
{
if (!is_numeric($replyTo) || !is_numeric($replyTo)) {
return [];
}
$result = [];
$result['hasMore'] = false;
$last = is_numeric($last) ? " AND c.`posted_on` > {$last}" : '';
$query = "SELECT c.*, u.id ownerId, u.username ownerUsername, u.profile_img_id FROM `comments` c JOIN `users` u ON c.`user_id` = u.`id` WHERE c.`reply_to` = {$replyTo} {$last} ORDER BY c.`posted_on` ASC LIMIT 7";
$stmt = \CW::$app->db->executeQuery($query);
$replies = $stmt->fetchAll(\PDO::FETCH_OBJ);
$repliesCount = count($replies);
$last = null;
for ($i = 0; $i < $repliesCount; $i++) {
$last = $replies[$i]->posted_on;
$replies[$i]->postedAgo = BaseModel::getPostedAgoTime($replies[$i]->posted_on);
$replies[$i]->content = htmlspecialchars($replies[$i]->content);
$replies[$i]->owner = ['id' => $replies[$i]->ownerId, 'username' => htmlspecialchars($replies[$i]->ownerUsername), 'profileUrl' => \models\User::getProfileUrl($replies[$i]->ownerId), 'pictureUrl' => User::getProfilePictureUrl($replies[$i]->profile_img_id, $replies[$i]->ownerId)];
}
if (0 < $repliesCount) {
$stmt = CW::$app->db->executeQuery("SELECT `reply_to` FROM `comments` WHERE `reply_to` = {$replyTo} AND `posted_on` > '" . $last . "' LIMIT 1");
$_result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
if (0 < count($_result)) {
$result['hasMore'] = true;
}
}
$result['items'] = $replies;
return $result;
}
