source: extensions/Comments_on_Albums/include/coa_comments_page.php @ 9634

<?php 
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

$template->assign(array(
        'COA_PATH' => COA_PATH,
        'ICON_COLOR' => 'ff3363',
        'ICON_COLOR_OVER' => 'ff7700',
));

// ajout d'un bouton sur la page principale
if (!isset($_GET['display_mode'])) {    
        
        $template->set_prefilter('comments', 'coa_add_button');

        function coa_add_button($content, &$smarty) {
                $search = '#<ul class="categoryActions">#';

                $replacement = '
                {html_head}
                        <style type="text/css">
                                .pwg-icon-comments-albums {ldelim}
                                        background-image: url({$COA_PATH}template/s26/outline_{$ICON_COLOR}.png);
                                        background-position: -26px 0;
                                }
                                a:hover .pwg-icon-comments-albums {ldelim}
                                        background-image: url({$COA_PATH}template/s26/outline_{$ICON_COLOR_OVER}.png);
                                        background-position: -26px 0;
                                }
                        </style>
                {/html_head}

                <ul class="categoryActions">
                        <li><a href="comments.php?display_mode=albums" title="Commentaires albums" class="pwg-state-default pwg-button">
                                <span class="pwg-icon pwg-icon-comments-albums">&nbsp;</span><span class="pwg-button-text">Commentaires albums</span>
                        </a></li>';

                return preg_replace($search, $replacement, $content);
        }
        
// page modifiée pour les commentaires albums
} else if ($_GET['display_mode'] == 'albums') {
        $template->clear_assign(array('comments', 'navbar', 'sort_by_options'));
        
// sort_by : database fields proposed for sorting comments list
$sort_by = array(
        'date' => l10n('comment date'),
        'category_id' => l10n('album')
);
$template->assign('sort_by_options', $sort_by);

// +-----------------------------------------------------------------------+
// |                         comments management                           |
// +-----------------------------------------------------------------------+

$comment_id = null;
$action = null;

$actions = array('delete_albums', 'validate_albums', 'edit_albums');
foreach ($actions as $loop_action) {
        if (isset($_GET[$loop_action])) {
                $action = $loop_action;
                check_input_parameter($action, $_GET, false, PATTERN_ID);
                $comment_id = $_GET[$action];
                break;
        }
}

if (isset($action)) {
        include_once(COA_PATH.'include/functions_comment.inc.php');
        check_pwg_token();
        $comment_author_id = get_comment_author_id_albums($comment_id);
        $true_action = str_replace('_albums', null, $action);

        if (can_manage_comment($true_action, $comment_author_id)) {
                $perform_redirect = false;

                if ('delete_albums' == $action) {
                        delete_user_comment_albums($comment_id);
                        $perform_redirect = true;
                }

                if ('validate_albums' == $action) {
                        validate_user_comment_albums($comment_id);
                        $perform_redirect = true;
                }

                if ('edit_albums' == $action) {
                        if (!empty($_POST['content'])) {
                                update_user_comment_albums(array(
                                        'comment_id' => $_GET['edit_albums'],
                                        'image_id' => $_POST['image_id'],
                                        'content' => $_POST['content']
                                        ), $_POST['key']
                                );
                                $perform_redirect = true;
                        } else {
                                $edit_comment = $_GET['edit_albums'];
                        }
                }

                if ($perform_redirect) {
                        $redirect_url = PHPWG_ROOT_PATH.'comments.php'.get_query_string_diff(array('delete_albums','validate_albums','edit_albums','pwg_token'));
                        redirect($redirect_url);
                }
        }
}

// +-----------------------------------------------------------------------+
// |                            navigation bar                             |
// +-----------------------------------------------------------------------+

if (isset($_GET['start']) and is_numeric($_GET['start'])) {
        $start = $_GET['start'];
} else {
        $start = 0;
}

$query = 'SELECT COUNT(DISTINCT(com.id))
        FROM '.COA_TABLE.' AS com
        LEFT JOIN '.USERS_TABLE.' As u
        ON u.'.$conf['user_fields']['id'].' = com.author_id
        WHERE '.implode('
        AND ', $page['where_clauses']).'
;';

list($counter) = pwg_db_fetch_row(pwg_query($query));

$url = PHPWG_ROOT_PATH . 'comments.php' . get_query_string_diff(array('start','delete','validate','pwg_token'));
$navbar = create_navigation_bar($url, $counter, $start, $page['items_number'], '');
$template->assign('navbar', $navbar);

// +-----------------------------------------------------------------------+
// |                        last comments display                          |
// +-----------------------------------------------------------------------+

$comments = array();
$element_ids = array();
$category_ids = array();

$query = 'SELECT
                com.id AS comment_id,
                com.category_id,
                com.author,
                com.author_id,
                com.date,
                com.content,
                com.validated
        FROM '.COA_TABLE.' AS com
        LEFT JOIN '.USERS_TABLE.' As u
        ON u.'.$conf['user_fields']['id'].' = com.author_id
        WHERE '.implode('
        AND ', $page['where_clauses']).'
        GROUP BY
                comment_id,
                com.category_id,
                com.author,
                com.author_id,
                com.date,
                com.content,
                com.validated
        ORDER BY '.$page['sort_by'].' '.$page['sort_order'];
        if ('all' != $page['items_number']) {
                $query.= '
                LIMIT '.$page['items_number'].' OFFSET '.$start;
        }
        $query.= '
;';
$result = pwg_query($query);

while ($row = pwg_db_fetch_assoc($result)) {
        array_push($comments, $row);
        array_push($element_ids, $row['category_id']);
}

if (count($comments) > 0) {
        // retrieving category informations
        $query = 'SELECT 
                        cat.id, 
                        cat.name, 
                        cat.permalink, 
                        cat.uppercats, 
                        com.id as comment_id
                FROM '.CATEGORIES_TABLE.' AS cat
                LEFT JOIN '.COA_TABLE.' AS com
                ON cat.id=com.category_id
                '.get_sql_condition_FandF(array(
                        'forbidden_categories' => 'cat.id',
                        'visible_categories' => 'cat.id'
                ), 'WHERE').'
                AND cat.id IN ('.implode(',', $element_ids).')
        ;';
        $categories = hash_from_query($query, 'comment_id');

        foreach ($comments as $comment) {
                $name = $categories[$comment['comment_id']]['name'];

                $url = duplicate_index_url(array(
                        'category' => array(
                                'id' => $categories[$comment['comment_id']]['id'], 
                                'name' => $categories[$comment['comment_id']]['name'], 
                                'permalink' => $categories[$comment['comment_id']]['permalink'],
                        ),array('start')
                ));

                $tpl_comment = array(
                        'U_PICTURE' => $url,
                        'TN_SRC' => $url,
                        'ALT' => $name,
                        'AUTHOR' => trigger_event('render_comment_author', $comment['author']),
                        'DATE' => format_date($comment['date'], true),
                        'CONTENT' => trigger_event('render_comment_content',$comment['content']),
                );

                if (can_manage_comment('delete', $comment['author_id'])) {
                        $url = get_root_url().'comments.php'.get_query_string_diff(array('delete','validate','edit', 'pwg_token'));

                        $tpl_comment['U_DELETE'] = add_url_params($url, array(
                                'delete_albums' => $comment['comment_id'],
                                'pwg_token' => get_pwg_token(),
                        ));
                }
                if (can_manage_comment('edit', $comment['author_id'])) {
                        $url = get_root_url().'comments.php'.get_query_string_diff(array('edit', 'delete','validate', 'pwg_token'));

                        $tpl_comment['U_EDIT'] = add_url_params($url, array(
                                'edit_albums' => $comment['comment_id'],
                                'pwg_token' => get_pwg_token(),
                        ));

                        if (isset($edit_comment) and ($comment['comment_id'] == $edit_comment)) {
                                $key = get_ephemeral_key(2, $comment['category_id']);
                                $tpl_comment['IN_EDIT'] = true;
                                $tpl_comment['KEY'] = $key;
                                $tpl_comment['IMAGE_ID'] = $comment['category_id'];
                                $tpl_comment['CONTENT'] = $comment['content'];
                        }
                }
                if (can_manage_comment('validate', $comment['author_id'])) {
                        if ('true' != $comment['validated']) {
                                $tpl_comment['U_VALIDATE'] = add_url_params($url, array(
                                        'validate_albums'=> $comment['comment_id'],
                                        'pwg_token' => get_pwg_token(),
                                ));
                        }
                }
                
                $template->append('comments', $tpl_comment);
        }
}

        
        $template->set_filenames(array('comments'=> dirname(__FILE__).'/../template/coa_comments_page.tpl'));
}

?>