ecshop 分页增加自定义参数,以投票页面为例

缺乏、安全感 2021-09-25 21:35 279阅读 0赞

比如投票页面增加parent\_id,order可以这样做

在根目录中建立voting\_list.php文件,里面内容为

<?php
    define('IN_ECS', true);
    
    require(dirname(__FILE__) . '/includes/init.php');
    
    if ((DEBUG_MODE & 2) != 2)
    {
        $smarty->caching = true;
    }
    
    /* 清除缓存 */
    clear_cache_files();
    
    /*------------------------------------------------------ */
    //-- INPUT
    /*------------------------------------------------------ */
    
    /* 获得指定的分类ID */
    $parent_id   = !empty($_REQUEST['parent_id'])  ? intval($_REQUEST['parent_id'])  : 0;
    /* 获得当前页码 */
    $page   = !empty($_REQUEST['page'])  && intval($_REQUEST['page'])  > 0 ? intval($_REQUEST['page'])  : 1;
    
    /*------------------------------------------------------ */
    //-- PROCESSOR
    /*------------------------------------------------------ */
    
    /* 获得页面的缓存ID */
    $cache_id = sprintf('%X', crc32( 'voting_list-' . $page . '-' . $_CFG['lang']));
    
    if (!$smarty->is_cached('voting_list.dwt', $cache_id))
    {
        /* 如果页面没有被缓存则重新获得页面的内容 */
    
        assign_template();
    $position =assign_ur_here();
        $smarty->assign('page_title',           $position['title']);     // 页面标题
        $smarty->assign('ur_here',              $position['ur_here']);   // 当前位置
    $smarty->assign('keywords',    htmlspecialchars($_CFG['shop_keywords']));  
    $smarty->assign('description',  htmlspecialchars($_CFG['shop_desc']));
        /* 获得文章总数 */
    	
    	
    	
        $size  =1;
        $count = $db->getOne("SELECT COUNT(*) FROM " .$ecs->table('voting'). " WHERE status = 0 and parent_id=".$parent_id);
    	
        $pages  = ($count > 0) ? ceil($count / $size) : 1;
    	//总页面数量
    
        // if ($page > $pages)
        // {
            // $page = $pages;
        // }
    
        /* 获得文章列表 */
    
    if(intval($_REQUEST['sort']) == 0){
    		$orderby=" ORDER BY voting_id DESC";
    	$sort=0;
    	 }else{
    		$orderby=" ORDER BY voting_num DESC";
    	$sort=1; }
    	
    
        //增加搜索条件，如果有搜索内容就进行搜索    
            
            $sql = 'SELECT * FROM ' .$GLOBALS['ecs']->table('voting') .
                   ' WHERE status =0 and parent_id='.$parent_id.$orderby;
     
    /* 仿真 Adodb 函数 function selectLimit($sql, $num, $start = 0) */
       
        $res = $GLOBALS['db']->selectLimit($sql, $size, ($page-1) * $size);
    	
    	
        $arr = array();
        if ($res)
        {
            while ($row = $GLOBALS['db']->fetchRow($res))
            {
                $voting_id = $row['voting_id'];
    $arr[$voting_id]['parent_id']          = $parent_id;
                $arr[$voting_id]['id']          = $voting_id;
                $arr[$voting_id]['title']       = $row['title'];
    			$arr[$voting_id]['voting_num']       = $row['voting_num'];
    $arr[$voting_id]['cover_img']    = $row['cover_img'];
    
    
       $arr[$voting_id]['url']  = build_uri('voting_list', array('id'=>$voting_id,'parent_id'=>$parent_id), $row['title']) ;//生成具体的内容链接,还要修改includes/lib_common.php 中的build_uri()
      $arr[$voting_id]['add_time']    = date($GLOBALS['_CFG']['date_format'], $row['add_time']);
            }
    		
        }
    	
    
        $smarty->assign('voting_list',$arr);
    	$pager = get_pager('voting_list.php', array('sort'=>$sort,'parent_id'=>$parent_id), $count, $page, $size);
      $smarty->assign('pager', $pager);
      //上面两行是分页.
      
    }
    
    $smarty->display('voting_list.dwt', $cache_id);
    
    
    ?>

如果还需要自动生成内容页的url,还要修改includes/lib\_common.php 中的build\_uri()函数.

增加

case 'voting_list':
                    if ($rewrite)
                    {
                        $uri = 'voting_list';
                        if (!empty($page))
                        {
                            $uri .= '-' . $page;
                        }
                        if (!empty($sort))
                        {
                            $uri .= '-' . $sort;
                        }
                        if (!empty($order))
                        {
                            $uri .= '-' . $order;
                        }
                        if (!empty($keywords))
                        {
                            $uri .= '-' . $keywords;
                        }
                    }
                    else
                    {
                        $uri = 'voting_list.php?id='.$id.'&parent_id='.$parent_id;
                        if (!empty($page))
                        {
    						
                            $uri .= 'page=' . $page;
                        }
                        if (!empty($sort))
                        {
                            $uri .= '&sort=' . $sort;
                        }
                        if (!empty($order))
                        {
                            $uri .= '&order=' . $order;
                        }
                        if (!empty($keywords))
                        {
                            $uri .= '&keywords=' . $keywords;
                        }
    					if (!empty($parent_id))
                        {
                            $uri .= '&parent_id=' . $parent_id;
                        }
                    }
               
    
                break;

![70][]

[70]: /images/20210923/b7b1c2a77ed24100b8ab3c382b12e03a.png