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; }