public static function getAll($post)
{
$list = array();
$sql = "\n SELECT\n comment.id,\n comment.post,\n DATE_FORMAT(comment.date, '%d | %m | %Y') as date,\n comment.date as timer,\n comment.text,\n comment.user\n FROM comment\n INNER JOIN user\n ON user.id = comment.user\n AND (user.hide = 0 OR user.hide IS NULL)\n WHERE comment.post = ?\n ORDER BY comment.date ASC, comment.id ASC\n ";
$query = static::query($sql, array($post));
foreach ($query->fetchAll(\PDO::FETCH_CLASS, __CLASS__) as $comment) {
$comment->user = \Goteo\Model\User::getMini($comment->user);
// reconocimiento de enlaces y saltos de linea
$comment->text = nl2br(Text::urlink($comment->text));
//hace tanto
$comment->timeago = Feed::time_ago($comment->timer);
$list[$comment->id] = $comment;
}
return $list;
}
public static function getAll($project, $lang = null)
{
$messages = array();
$query = static::query("\n SELECT\n message.id as id,\n message.user as user,\n message.project as project,\n message.thread as thread,\n message.date as date,\n IFNULL(message_lang.message, message.message) as message,\n message.blocked as blocked,\n message.closed as closed\n FROM message\n LEFT JOIN message_lang\n ON message_lang.id = message.id\n AND message_lang.lang = :lang\n WHERE message.project = :project\n AND message.thread IS NULL\n ORDER BY date ASC, id ASC\n ", array(':project' => $project, ':lang' => $lang));
foreach ($query->fetchAll(\PDO::FETCH_CLASS, __CLASS__) as $message) {
// datos del usuario
$message->user = User::getMini($message->user);
// reconocimiento de enlaces y saltos de linea
$message->message = nl2br(Text::urlink($message->message));
//hace tanto
$message->timeago = Feed::time_ago($message->date);
$query = static::query("\n SELECT id\n FROM message\n WHERE thread = ?\n ORDER BY date ASC, id ASC\n ", array($message->id));
foreach ($query->fetchAll(\PDO::FETCH_CLASS) as $response) {
$message->responses[] = self::get($response->id);
}
$messages[] = $message;
}
return $messages;
}
