function dialogue_manage_comment_custom_column($col, $comment_id = 0)
{
$comment = get_comment($comment_id, ARRAY_A);
$cmid = $comment['comment_ID'];
if ($col == 'comment_content') {
echo '<strong>Opinião</strong><br />';
echo '<div>' . get_comment_meta($cmid, 'opiniao', true) . '</div>';
echo '<strong>Proposta</strong><br />';
echo '<div>' . get_comment_meta($cmid, 'proposta', true) . '</div>';
if (trim(get_comment_meta($cmid, 'contribuicao', true) != '')) {
echo '<strong>Contribuição</strong>';
echo '<div>' . get_comment_meta($cmid, 'contribuicao', true) . '</div>';
}
} else {
if ($col == 'justificativa') {
echo '<div>' . get_comment_meta($cmid, 'justificativa', true) . '</div>';
} else {
if ($col == 'dialogue_paragraph') {
$post = get_post($comment["comment_post_ID"]);
$pid = (string) get_comment_meta($comment['comment_ID'], DIALOGUE_CF_PARAGRAPH, true);
$paragraphs = dialogue_api_parse_content(wpautop($post->post_content));
$paragraph = $paragraphs[$pid];
echo "<strong>{$pid}</strong> &mdash ";
echo wp_html_excerpt($paragraph, 128) . '...';
} else {
if ($col == 'dialogue_tags') {
$cid = $comment["comment_ID"];
$tags = dialogue_api_get_comment_tags($cid);
$len = sizeof($tags);
for ($i = 0; $i < $len; $i++) {
$name = $tags[$i]->name;
if (trim($name) == "") {
continue;
}
echo "#{$name}" . ($i != $len - 1 ? ", " : "");
}
}
}
}
}
}
function dialogue_api_get_comments_without_paragraphs($post)
{
global $wpdb;
$sql = "SELECT\n c.comment_ID, c.comment_post_ID, c.comment_author, c.comment_author_email, c.comment_author_IP,\n c.comment_author_url, c.comment_date, c.comment_date_gmt,\n c.comment_content, c.comment_karma, c.comment_agent,\n c.comment_type, c.comment_parent, um.meta_value AS user_name\n FROM\n {$wpdb->usermeta} AS um,\n {$wpdb->comments} AS c\n INNER JOIN {$wpdb->prefix}commentmeta as m\n ON (m.comment_ID = c.comment_ID)\n WHERE c.comment_post_ID = %d\n AND m.meta_key = '" . DIALOGUE_CF_PARAGRAPH . "'\n AND m.meta_value = ''\n AND c.comment_approved = 1\n AND um.user_id = c.user_id\n AND um.meta_key = 'nomecompleto'\n ORDER BY c.comment_ID;";
$query = $wpdb->prepare($sql, $post);
$comments = $wpdb->get_results($query);
/* Getting meta values for the comments */
$result = array();
foreach ($comments as $comment) {
$comment->instituicao = esc_attr(get_the_author_meta('instituicao', $comment->user_id));
$comment->user_meta = dialogue_api_get_user_meta($comment->comment_author_email);
$comment->meta = array();
$sql = "SELECT meta_key, meta_value\n FROM {$wpdb->prefix}commentmeta\n WHERE comment_id = {$comment->comment_ID}";
foreach ($wpdb->get_results($sql) as $m) {
$comment->meta[$m->meta_key] = $m->meta_value;
}
$comment->comment_author_email = null;
$comment->tags = dialogue_api_get_comment_tags($comment->comment_ID);
array_push($result, $comment);
}
return $result;
}
function dialogue_comment_div($cid, $pid, $post)
{
$children = dialogue_api_get_children_paragraph_comments($cid);
?>
<li>
<?php
if (get_post_meta($pid, DIALOGUE_PMF_SHOW_COMMENTS, true) == "true") {
echo get_avatar(get_comment_author_email(), '48');
?>
<div class="comdados">
<strong><?php
echo get_comment_author_link();
?>
</strong>
em <?php
echo get_comment_date('d/m/Y H:i');
?>
<?php
$tags = dialogue_api_get_comment_tags($cid);
$len_tags = count($tags);
if ($len_tags != 0) {
?>
<div class="tags">
<label>Tags:</label>
<?php
for ($i = 0; $i < $len_tags; $i++) {
echo $tags[$i]->name;
if ($i < $len_tags - 1) {
echo ', ';
}
}
?>
</div>
<?php
}
?>
</div>
<?php
}
?>
<div class="comdata">
<?php
if (get_post_meta($pid, DIALOGUE_PMF_SHOW_COMMENTS, true) == "true") {
?>
<strong>Texto do comentário:</strong>
<div id="comment-area-<?php
echo $cid;
?>
">
<?php
echo dialogue_comment_outline($cid, get_comment_text());
?>
</div>
<div style="display:none" id="comment-full-<?php
echo $cid;
?>
">
<?php
comment_text();
?>
</div>
<?php
$new_text = get_comment_meta($cid, DIALOGUE_CF_NEWTEXTPROPOSAL, true);
if (!empty($new_text)) {
echo '<div class="newText clear">';
echo '<strong>Proposta de nova redação:</strong> ';
echo '<p>' . $new_text . '</p>';
echo '</div>';
}
?>
<div class="responderspace">
<button
title="Clique aqui para responder ao autor deste comentário"
onclick="jQuery('#comment-the-comment-<?php
echo $cid;
?>
').show();
jQuery(this).hide()">
Responder
</button>
</div>
<?php
}
?>
<div style="display:none" id="comment-the-comment-<?php
echo $cid;
?>
">
<form
action="<?php
echo get_option('siteurl');
?>
/wp-comments-post.php"
method="post" id="commentform-<?php
echo $pid . $cid;
?>
">
<input type="hidden" name="dialogue_comment_paragraph"
value="<?php
echo $pid;
?>
">
<input type="hidden" name="comment_post_ID"
value="<?php
echo $post->ID;
?>
">
<input type="hidden" name="comment_parent"
value="<?php
echo $cid;
?>
" />
<ol>
<li>
<label>Deixe seu comentário</label>
<textarea name="comment"
class="comment required wider"></textarea>
</li>
<li class="tag">
<label>Tags <em>(separadas por vírgula)</em></label>
<input type="text" name="comment_tags" class="border wider"/>
</li>
<li class="newText">
<input type="checkbox" name="new_text_check"
class="checkNewText" id="new_text_check" />
<label for="new_text_check">
Quero sugerir uma nova redação
</label>
<textarea name="dialogue_comment_new_text"
class="newText wider"></textarea>
</li>
<li class="last">
<input type="submit" value="Enviar" />
</li>
</ol>
</form>
</div>
</div>
<?php
if (get_post_meta($pid, DIALOGUE_PMF_SHOW_COMMENTS, true) == "true") {
echo dialogue_expand_children($children, $pid, $post);
}
?>
</li>
<?php
}
