小贝子编程

每页KNP分页的动态限制



我需要直接解决方案，以动态设置每页的记录数，用KNP分页捆绑包。

我读取此页面记录每个页面允许用户选择 - 有关每个页面限制的动态设置的代码签名分页，我知道我需要在每个项目中使用超链接下拉列表，以将请求发送到服务器，并且服务器在此请求上使用参数在KNP分页捆绑上设置限制。但是我不知道如何确切地处理服务器上的操作，对我来说，如何在与查询总数相关的下拉中创建项目更加困难。

我的控制器：

public function indexAction()
{   
    $page_title = Util::getFormattedPageTitle("Customers");
    $em    = $this->get('doctrine.orm.entity_manager');
    $dql   = "SELECT a FROM CustomersBundle:Customer a WHERE a.enable = 1 ORDER BY a.id";
    //$query = $em->createQuery($dql);
    //$customers = $query->execute();
    $query = $em->createQuery($dql); 
    $paginator  = $this->get('knp_paginator');
    $pagination = $paginator->paginate(
        $query,
        $this->get('request')->query->get('page', 1)/*page number*/,
        3/*limit per page*/
    );

    // parameters to template
    return $this->render('CustomersBundle:Default:index.html.twig', array(
        'page_title' => $page_title,
        'pagination' => $pagination,
        'image_path' => CustomersConstants::$customers_image_thumb_path
    ));
}

我的视图代码是：

    {% extends '::base.html.twig' %}
{% block title %}
    {{ page_title }}
{% endblock %}
{% block body %}
    <h1>
        {{ "customers" }}
    </h1>
    <br />
    {% for customer in pagination %}
    <a href="{{ customer.url }}" target="_blank">
        <div dir="rtl" class="st_simple_box" id="customer{{customer.id}}" >
            <table cellpadding="0" cellspacing="0" width="100%">
                <tr>
                    <td style="vertical-align: top; width: 115px;">
                        {% if customer.imageName is not empty %}
                            <img class="newsimage" src="{{asset(image_path) ~ customer.imageName}}" alt="No Image/>
                        {% else %}
                            <img class="newsimage" src="{{asset('images/vakil_default_small.png') ~ customer.imageName}}" alt="No Image"/>
                        {% endif %}
                    </td>
                    <td style="text-align: center;">
                        <p><span style="font-family: Tahoma;">{{customer.titleFa}}</span></p>
                    </td>
                    <td style="text-align: justify;">
                        <p><span style="font-family: Tahoma;">{{customer.descriptionFa}}</span></p>
                    </td>
                </tr>
            </table>
        </div>
    </a>
    {% endfor %}
    <div class="navigation">
        <span>
        {{ knp_pagination_render(pagination) }}
        </span>
        <!--Here is my drop down html code-->
    </div>
    <br />
{% endblock %}

**

编辑于2014年3月12日

   ||||
   ||||
   ||||
  \///
   \//
    /

是否有任何方法可以将cookie上的maxitemperpage设置为具有集成变量并在twig文件上显示KNP分页时使用此变量或更改它。

答案是正确的，但是由于我使用了分页，在我的实体之间进行了分页，因此我需要一个集成变量才能更改所有这些变量。我使用您的答案并自定义sliding.html.twig在KNP上的分页上以" customized_sliding.html.twig"达到此代码

<div class="ui small pagination menu">
    <div style="clear: both;">
        {% if pageCount > 1 %}
            <div class="pagination" style="float: right;">
                {% if first is defined and current != first %}
                    <a href="{{ path(route, query|merge({(pageParameterName): first})) }}" class="small icon item">
                        <i class="small double angle right icon"></i>
                    </a>
                {% endif %}
                {% if previous is defined %}
                    <a href="{{ path(route, query|merge({(pageParameterName): previous})) }}" class="small icon item">
                        <i class="small angle right icon"></i>
                    </a>
                {% endif %}
                {% for page in pagesInRange %}
                    {% if page != current %}
                        <a href="{{ path(route, query|merge({(pageParameterName): page})) }}" class="small item">
                            {{ page }}
                        </a>
                    {% else %}
                        <a class="small active item">
                            {{ page }}
                        </a>
                    {% endif %}
                {% endfor %}
                {% if next is defined %}
                    <a href="{{ path(route, query|merge({(pageParameterName): next})) }}" class="small icon item">
                        <i class="small angle left icon"></i>
                    </a>
                {% endif %}
                {% if last is defined and current != last %}
                    <a href="{{ path(route, query|merge({(pageParameterName): last})) }}" class="small icon item">
                        <i class="small double angle left icon"></i>
                    </a>
                {% endif %}
            </div>
        {% endif %}
        <div style="float: left;">
            <select name="maxItemPerPage" id="maxItemPerPage">
                <option selected="true" style="display:none;">Number Per Page</option>
                <option id="10">5</option>
                <option id="20">10</option>
                <option id="30">20</option>
            </select>
        </div>
    </div>
    <script type="text/javascript">
        //on select change, you navigate to indexAction and send the parameter maxItemPerPage
        $('#maxItemPerPage').change(function(){
            {% set currentPath = path(app.request.attributes.get('_route')) %}
            var url = "{{path(app.request.attributes.get('_route'),{'maxItemPerPage': '_itemNum'})}}";
            var item = $('#maxItemPerPage').find(":selected").text();
            jQuery(location).attr('href', url.replace('_itemNum',item ));
        });
    </script>
</div>

我想从cookie获取并存储Maxitemperpage，因此无需更改所有捆绑代码。例如，在我的控制器中，我不知道必须从cookie

获取$ maxitemperpage 
$pagination = $paginator->paginate(
            $query,
            $this->get('request')->query->get('page', 1)/*page number*/,
            $maxItemPerPage/*limit per page*/
        );

我需要通过更改JavaScript的HTML标签的值，然后将页面重定向到同一控制器，而无需将MaxiteMperPage重定向到控制器。

，

这可以轻松完成（如果我很好地理解）

public function indexAction($maxItemPerPage=20)
{   
    $page_title = Util::getFormattedPageTitle("Customers");
    $em    = $this->get('doctrine.orm.entity_manager');
    $dql   = "SELECT a FROM CustomersBundle:Customer a WHERE a.enable = 1 ORDER BY a.id";
    //$query = $em->createQuery($dql);
    //$customers = $query->execute();
    $query = $em->createQuery($dql); 
    $paginator  = $this->get('knp_paginator');
    $pagination = $paginator->paginate(
        $query,
        $this->get('request')->query->get('page', 1)/*page number*/,
        $maxItemPerPage /*limit per page*/
    );

    // parameters to template
    return $this->render('CustomersBundle:Default:index.html.twig', array(
        'page_title' => $page_title,
        'pagination' => $pagination,
        'image_path' => CustomersConstants::$customers_image_thumb_path
    ));
}

在视图中

   {% extends '::base.html.twig' %}
    {% block title %}
        {{ page_title }}
    {% endblock %}
{% block javascript%}
<script type="text/javascript">
//on select change, you navigate to indexAction and send the parameter maxItemPerPage
$('#maxItemPerPage').change(function(){
var url = '{{path('controller_index_route','maxItemPerPage':_itemNum)}}';
var item = $('#maxItemPerPage').find(":selected").text();
window.location.href = url.replace('_itemNum',item );
})
</script>
    {% endblock %}
    {% block body %}
        <h1>
            {{ "customers" }}
        </h1>
        <br />
        {% for customer in pagination %}
        <a href="{{ customer.url }}" target="_blank">
            <div dir="rtl" class="st_simple_box" id="customer{{customer.id}}" >
                <table cellpadding="0" cellspacing="0" width="100%">
                    <tr>
                        <td style="vertical-align: top; width: 115px;">
                            {% if customer.imageName is not empty %}
                                <img class="newsimage" src="{{asset(image_path) ~ customer.imageName}}" alt="No Image/>
                            {% else %}
                                <img class="newsimage" src="{{asset('images/vakil_default_small.png') ~ customer.imageName}}" alt="No Image"/>
                            {% endif %}
                        </td>
                        <td style="text-align: center;">
                            <p><span style="font-family: Tahoma;">{{customer.titleFa}}</span></p>
                        </td>
                        <td style="text-align: justify;">
                            <p><span style="font-family: Tahoma;">{{customer.descriptionFa}}</span></p>
                        </td>
                    </tr>
                </table>
            </div>
        </a>
        {% endfor %}
        <div class="navigation">
            <span>
            {{ knp_pagination_render(pagination) }}
            </span>
            <!--Here is my drop down html code-->
        </div>
        <br />
<select name="maxItemPerPage" id="maxItemPerPage">
<option id="10">10</option>
<option id="20">20</option>
<option id="30">30</option>
</select>
    {% endblock %}

相关内容

  • 没有找到相关文章

最新更新


热门标签：

javascript python java c# php android html jquery c++ css ios sql mysql arrays asp.net json python-3.x ruby-on-rails .net sql-server django objective-c excel regex ruby linux ajax iphone xml vba spring asp.net-mvc database wordpress string postgresql wpf windows xcode bash git oracle list vb.net multithreading eclipse algorithm macos powershell visual-studio image forms numpy scala function api selenium