Просмотры страниц на Tickets в виджете админки

1. Идем в настройки -> панели -> виджеты -> создать виджет -> 1. Задаём имя виджету 2. Тип виджета — Сниппет 3. Вставляем в содержимое виджета название сниппета и сохраняем: widget_popular_resources
   
   
   
   
2. Добавляем созданный нами виджет в панель Default в настройки -> панели -> вкладка Панели -> Правой кнопкой мыши по Default -> Редактировать панель -> кнопка Добавить виджет -> выбираем наш созданный видюжет.
   
   
3. Создаём сниппет widget_popular_resources (в parents можно вставлять своего родителя):
   

   <?php
   $output = $modx->runSnippet('pdoResources', array(
       'limit' => 30,    
       'parents' => 0,  
       
       'tplWrapper' => 'tpl.widget.popular.wrapper',    
       'tpl' => 'tpl.widget.popular.row',   
       
       'loadModels' => 'tickets',    
       'class' => 'Ticket',    
       'leftJoin' => '{
           "TicketView": {
               "class": "TicketView",
               "on": "Ticket.id = TicketView.parent"
           }
       }',
       'select' => '{
           "Ticket": "Ticket.*",
           "TicketView": "COUNT(TicketView.uid) as views"
       }',
       'groupby' => 'Ticket.id',    
       'sortby' => '{ "views":"DESC" }',    
   ));
   return $output;

4. Чанк tpl.widget.popular.wrapper:
   

   <style>
   .table {width: 100%;max-width: 100%;margin-bottom: 20px;border-collapse:collapse;}
   .table>thead>tr>th, .table>tbody>tr>th, .table>tfoot>tr>th, .table>thead>tr>td, .table>tbody>tr>td, .table>tfoot>tr>td {padding: 8px;line-height: 1.42857143;vertical-align: top;border-top: 1px solid #ddd;}
   .table>thead>tr>th {vertical-align: bottom;border-bottom: 2px solid #ddd; font-weight: bold;}
   .table>caption+thead>tr:first-child>th, .table>colgroup+thead>tr:first-child>th, .table>thead:first-child>tr:first-child>th, .table>caption+thead>tr:first-child>td, .table>colgroup+thead>tr:first-child>td, .table>thead:first-child>tr:first-child>td {border-top: 0;}
   .table>tbody+tbody {border-top: 2px solid #ddd;}
   .table .table {background-color: #fff;}
   .table-condensed>thead>tr>th, .table-condensed>tbody>tr>th, .table-condensed>tfoot>tr>th, .table-condensed>thead>tr>td, .table-condensed>tbody>tr>td, .table-condensed>tfoot>tr>td {padding: 5px;}
   .table-bordered {border: 1px solid #ddd;}
   .table-bordered>thead>tr>th, .table-bordered>tbody>tr>th, .table-bordered>tfoot>tr>th, .table-bordered>thead>tr>td, .table-bordered>tbody>tr>td, .table-bordered>tfoot>tr>td {border: 1px solid #ddd;}
   .table-bordered>thead>tr>th, .table-bordered>thead>tr>td {border-bottom-width: 2px;}
   .table-striped>tbody>tr:nth-of-type(odd) {background-color: #f9f9f9;}
   .table-hover>tbody>tr:hover {background-color: #f5f5f5;}
   </style>
   <table class="table table-striped table-hover">
       <thead>
           <tr>
               <th>Название ресурса</th>
               <th>Просмотров</th>
           </tr>
       </thead>
   	<tbody>
   
   [[+output]]
   
       </tbody>    
   </table>

5. чанк tpl.widget.popular.row:
   

   <tr>
       <td>
           [[+parent:isnot=`0`:then=`<a href="[[~[[+parent]]]]" target="_blank">[[#[[+parent]].pagetitle]]</a> » `]]
           <a href="[[~[[+id]]]]" target="_blank">[[+pagetitle]]</a>
       </td>
       <td>[[+views]]</td>
   </tr>

.`````````````````````````````````````````````
``````````````````````````````````````````````
``````````````````````````````````````````````
```@@@`````@@@````@@@@```,@@@@@'```@@@``@@@```
````+@,```,@+```+@;``@@.```@``.@@```@,``.@````
````@+@```@'@```@`````;@```@````+@```@``@`````
````@;@```@;@``@@``````@;``@`````@```#@+@`````
````@:;@`#',@``@:``````@@``@`````@,```@@``````
````@.`@`@``@``@;``````@+``@`````@,```@@``````
````@``@'@``@``#@``````@.``@`````@```@,#@`````
````@```@```@```@:````#@```@````@@``:@``@.````
```,@,`````,@,``.@@:;@@```,@;;'@@``,@,``:@,```
```+++`````+++````'@@:```.+++++````+++``+++```
``````````````````````````````````````````````
``````````````````````````````````````````````
``````````````````````````````````````````````

<?php
$period = date('Y-m-d H:i:s', strtotime("-3 month") ); // за последние 3 месяца
$output = $modx->runSnippet('pdoResources', array(
    'limit' => 30,    
    'parents' => 0, 
    
    'tplWrapper' => 'tpl.widget.popular.wrapper',    
    'tpl' => 'tpl.widget.popular.row',   
    
    'loadModels' => 'tickets',    
    'class' => 'Ticket',    
    'leftJoin' => '{
        "TicketView": {
            "class": "TicketView",
            "on": "Ticket.id = TicketView.parent"
        }
    }',
    'select' => '{
        "Ticket": "Ticket.*",
        "TicketView": "COUNT(TicketView.uid) as views"
    }',
    'groupby' => 'Ticket.id',    
    'sortby' => '{ "views":"DESC" }',    
    'where'  => '{ "TicketView.timestamp:>": "'.$period.'" }',
));
return $output;