Example #1
0
function cpListTable($table, $_fields, $_actions, $where='', $orderby='title', $perpage=60) {
    global $_LANG;
    
    $page = cmsCore::request('page', 'int', 1);

    $sql = 'SELECT *';
    $is_actions = sizeof($_actions);

    foreach($_fields as $key => $value) {
        if (isset($_fields[$key]['fdate'])) {
            $sql .= ", DATE_FORMAT(".$_fields[$key]['field'].", '".$_fields[$key]['fdate']."') as `".$_fields[$key]['field']."`" ;
        }
    }

    $sql .= ' FROM '. $table;

    if (isset($_SESSION['filter_table']) && $_SESSION['filter_table']!=$table) {
        unset($_SESSION['filter']);
    }

    if (cmsCore::inRequest('nofilter')) {
        unset($_SESSION['filter']);
        cmsCore::redirect('/admin/index.php?'. cpAddParam($_SERVER['QUERY_STRING'], 'page', 1));
    }

    $filter = false;
    
    if (cmsCore::inRequest('filter')) {
        $filter = cmsCore::request('filter', 'array_str', '');
        
        if (isset($_SESSION['filter']) && $_SESSION['filter'] != $filter) {
            $page = 1;
        }
        
        $_SESSION['filter'] = $filter;
    } else if (isset($_SESSION['filter'])) {
        $filter = $_SESSION['filter'];
    }

    if ($filter) {
        $f = 0;
        foreach ($filter as $key => $value) {
            if (!empty($filter[$key]) && $filter[$key] != -100) {
                if (!is_numeric($filter[$key])) {
                    cmsCore::c('db')->where($key ." LIKE '%" . $filter[$key] ."%'");
                } else {
                    cmsCore::c('db')->where($key ." = '". $filter[$key] ."'");
                }
                $f++;
            }
        }
        if (!isset($_SESSION['filter'])) { $_SESSION['filter'] = $filter; }
    }
    
    if (mb_strlen($where) <= 3) {
        $where = '1=1';
    }

    //Выставляем сортировку выборки данных в БД
    $sort = cmsCore::request('sort', 'str', '');
    $so = 'asc';
    if (empty($sort)) {
        if (!empty($orderby)) {
            $orderby = trim($orderby);
            
            if (mb_strstr($orderby, ' ')) {
                $sorta = explode(' ', $orderby);
                $sort = $sorta[0];
                
                foreach ($sorta as $s) {
                    $s = mb_strtolower(trim($s,' ,'));
                    if ($s == 'asc' || $s == 'desc') {
                        $so = $s;
                        break;
                    }
                }
            } else {
                $sort = $orderby;
            }
            
            cmsCore::c('db')->order_by = 'ORDER BY '. $orderby;
        } else {
            foreach($_fields as $key => $value) {
                if ($_fields[$key]['field'] == 'ordering' && $sort != 'NSLeft') {
                    $sort = 'ordering';
                    cmsCore::c('db')->orderBy($sort, $so);
                }
            }
        }
    } else {
        $so = cmsCore::request('so', array('asc', 'desc'), $so);
        cmsCore::c('db')->orderBy($sort, $so);
    }

    $total = cmsCore::c('db')->rows_count($table, $where .' '. cmsCore::c('db')->where);
    cmsCore::c('db')->limitPage($page, $perpage);

    $result = cmsCore::c('db')->query(
        $sql . "\n" .'WHERE '. $where .' '. cmsCore::c('db')->where . "\n" . (empty(cmsCore::c('db')->order_by) ? '' : cmsCore::c('db')->order_by) .' LIMIT '. cmsCore::c('db')->limit
    );

    $_SESSION['filter_table'] = $table;

    if (cmsCore::c('db')->error()) {
        unset($_SESSION['filter']);
        cmsCore::redirect('/admin/index.php?'. $_SERVER['QUERY_STRING']);
    }

    $filters = 0; $f_html = '';
    //Find and render filters
    foreach($_fields as $key => $value) {
        if (isset($_fields[$key]['filter'])) {
            $f_html .= '<div class="form-group"><label>'. $_fields[$key]['title'] .': </label>';
            
            $initval = false;
            if (isset($filter[$_fields[$key]['field']])) {
                $initval =  $filter[$_fields[$key]['field']];
            }

            $inputname = 'filter['.$_fields[$key]['field'].']';
            if (!isset($_fields[$key]['filterlist'])) {
                $f_html .= '<input type="text" class="form-control" style="margin-right:10px;margin-left:5px;" name="'. $inputname .'" size="'. $_fields[$key]['filter'] .'" value="'. ($initval === false ? '' : $initval) .'" />';
            } else {
                $f_html .= cpBuildList($inputname, $_fields[$key]['filterlist'], $initval);
            }
            
            $f_html .= '</div>';

            $filters += 1;
            $_SERVER['QUERY_STRING'] = str_replace('filter['.$_fields[$key]['field'].']=', '', $_SERVER['QUERY_STRING']);
        }
    }
    
    //draw filters
    if ($filters > 0) {
        echo '<div class="panel panel-default"><div class="panel-body" style="padding:0;">';
        echo '<form class="form-inline navbar-form navbar-left" name="filterform" action="index.php?'. $_SERVER['QUERY_STRING'] .'" method="POST" role="search">';
        echo '';
        echo $f_html;
        echo '<button type="submit" class="btn btn-default">'. $_LANG['AD_FILTER'] .'</button>';
        if (!empty($f)) {
            echo '<button onclick="window.location.href=\'index.php?'. $_SERVER['QUERY_STRING'] .'&nofilter\'; return false;" class="btn btn-default" style="margin-left:10px;">'. $_LANG['AD_ALL'] .'</button>';
        }
        echo '</form>';
        echo '</div></div>';
    }

    if (cmsCore::c('db')->num_rows($result)) {
        //DRAW LIST TABLE
        echo '<form name="selform" action="index.php?view='.cmsAdmin::getApplet().'&do=saveorder" method="post">';
            echo '<table class="table table-striped tablesorter">';
                //TABLE HEADING
                echo '<thead>'."\n";
                    echo '<tr>'."\n";
                        echo '<th width="20" class="lt_header" style="vertical-align:middle;"><a class="lt_header_link" href="javascript:invert();" title="'.$_LANG['AD_INVERT_SELECTION'].'">#</a></th>'. "\n";
                        foreach($_fields as $key => $value) {
                            echo '<th width="'.$_fields[$key]['width'].'" class="lt_header'. (is_array($_fields[$key]['field']) ? '' : ' header') .' '. ($_fields[$key]['field'] == $sort ? ( $so == 'asc' ? 'headerSortDown' : 'headerSortUp' ) : '') .'" style="vertical-align:middle;">';
                                if (!is_array($_fields[$key]['field'])) {
                                    echo '<a href="index.php?'. cpAddParam($_SERVER['QUERY_STRING'], array( 0 => 'sort', 1 => 'so'), array( 0 => $_fields[$key]['field'], 1 => ($so == 'asc' ? 'desc' : 'asc'))) .'">'. $_fields[$key]['title'] .'</a>';
                                } else {
                                    echo $_fields[$key]['title'];
                                }
                            echo '</th>'. "\n";
                        }
                        if ($is_actions) {
                            echo '<th width="80" class="lt_header" style="vertical-align:middle;">'.$_LANG['AD_ACTIONS'].'</th>'. "\n";
                        }
                    echo '</tr>'."\n";
                echo '</thead><tbody>'."\n";
                //TABLE BODY
                    $r = 0;
                    while ($item = cmsCore::c('db')->fetch_assoc($result)) {
                        $r++;
                        if ($r % 2) { $row_class = 'lt_row1'; } else { $row_class = 'lt_row2'; }
                        echo '<tr id="'. $row_class .'">'."\n";
                        echo '<td class="'.$row_class.'" align="center" valign="middle"><input type="checkbox" name="item[]" value="'.$item['id'].'" /></td>'. "\n";
                        foreach($_fields as $key => $value) {
                            if (isset($_fields[$key]['link'])) {
                                $link = str_replace('%id%', $item['id'], $_fields[$key]['link']);
                                if (isset($_fields[$key]['prc'])) {
                                    // функция обработки под названием $_fields[$key]['prc']
                                    // какие параметры передать функции - один ключ или произвольный массив ключей
                                    if (is_array($_fields[$key]['field'])) {
                                        foreach ($_fields[$key]['field'] as $func_field) {
                                            $in_func_array[$func_field] = $item[$func_field];
                                        }
                                        
                                        $data = call_user_func($_fields[$key]['prc'], $in_func_array);
                                    } else {
                                        $data = call_user_func($_fields[$key]['prc'], $item[$_fields[$key]['field']]);
                                    }
                                } else {
                                    $data = $item[$_fields[$key]['field']];
                                    if (isset($_fields[$key]['maxlen'])) {
                                        if (mb_strlen($data) > $_fields[$key]['maxlen']) {
                                            $data = mb_substr($data, 0, $_fields[$key]['maxlen']).'...';
                                        }
                                    }
                                }

                                //nested sets otstup
                                if (isset($item['NSLevel']) && ($_fields[$key]['field']=='title' || (is_array($_fields[$key]['field']) && in_array('title', $_fields[$key]['field'])))) {
                                    $otstup = str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;', ($item['NSLevel']-1));
                                    if ($item['NSLevel']-1 > 0) { $otstup .=  ' &raquo; '; }
                                } else { $otstup = ''; }

                                if ($table != 'cms_components') {
                                    echo '<td class="'.$row_class.'" valign="middle">'.$otstup.'<a class="lt_link" href="'.$link.'">'.$data.'</a></td>'. "\n";
                                } else {
                                    $data = function_exists('cpComponentHasConfig') && cpComponentHasConfig($item['link']) ?
                                    '<a class="lt_link" href="'.$link.'">'.$data.'</a>' :
                                    $data;

                                    echo '<td class="'.$row_class.'" valign="middle">
                                        <span class="lt_link" style="padding:1px; padding-left:24px; background:url(/admin/images/components/'.$item['link'].'.png) no-repeat">'.$data.'</span>
                                  </td>'. "\n";
                                }
                            } else {
                                if ($_fields[$key]['field'] != 'ordering') {
                                    if ($_fields[$key]['field'] == 'published') {
                                        if (isset($_fields[$key]['do'])) { $do = $_fields[$key]['do']; } else { $do = 'do'; }
                                        if (isset($_fields[$key]['do_suffix'])) { $dos = $_fields[$key]['do_suffix']; $ids = 'item_id'; } else { $dos = ''; $ids = 'id'; }
                                        if ($item['published']) {
                                            $qs = cpAddParam($_SERVER['QUERY_STRING'], $do, 'hide'.$dos);
                                            $qs = cpAddParam($qs, $ids, $item['id']);
                                            $qs2 = cpAddParam($_SERVER['QUERY_STRING'], $do, 'show'.$dos);
                                            $qs2 = cpAddParam($qs2, $ids, $item['id']);
                                            $qs = "pub(".$item['id'].", '".$qs."', '".$qs2."', 'off', 'on');";
                                            echo '<td class="'.$row_class.'" valign="middle">
                                                    <a title="'.$_LANG['HIDE'].'" class="uittip" id="publink'.$item['id'].'" href="javascript:'.$qs.'"><img id="pub'.$item['id'].'" src="images/actions/on.gif" border="0"/></a>
                                                  </td>'. "\n";
                                        } else {
                                            $qs = cpAddParam($_SERVER['QUERY_STRING'], $do, 'show'.$dos);
                                            $qs = cpAddParam($qs, $ids, $item['id']);
                                            $qs2 = cpAddParam($_SERVER['QUERY_STRING'], $do, 'hide'.$dos);
                                            $qs2 = cpAddParam($qs2, $ids, $item['id']);
                                            $qs = "pub(".$item['id'].", '".$qs."', '".$qs2."', 'on', 'off');";
                                            echo '<td class="'.$row_class.'" valign="middle">
                                                    <a title="'.$_LANG['SHOW'].'" class="uittip" id="publink'.$item['id'].'" href="javascript:'.$qs.'"><img id="pub'.$item['id'].'" src="images/actions/off.gif" border="0"/></a>
                                                  </td>'. "\n";
                                        }
                                    } else {
                                        if (isset($_fields[$key]['prc'])) {
                                            // функция обработки под названием $_fields[$key]['prc']
                                            // какие параметры передать функции - один ключ или произвольный массив ключей
                                            if (is_array($_fields[$key]['field'])) {
                                                foreach ($_fields[$key]['field'] as $func_field) {
                                                    $in_func_array[$func_field] = $item[$func_field];
                                                }
                                                $data = call_user_func($_fields[$key]['prc'], $in_func_array);
                                            } else {
                                                $data = call_user_func($_fields[$key]['prc'], $item[$_fields[$key]['field']]);
                                            }
                                            if (is_array($data) && isset($data['link'])) {
                                                $data = str_replace('%id%', $item['id'], $data['link']);
                                            }
                                        } else {
                                            $data = $item[$_fields[$key]['field']];
                                            if (isset($_fields[$key]['maxlen'])) {
                                                if (mb_strlen($data)>$_fields[$key]['maxlen']) {
                                                    $data = mb_substr($data, 0, $_fields[$key]['maxlen']).'...';
                                                }
                                            }
                                        }

                                        //nested sets otstup
                                        if (isset($item['NSLevel']) && ($_fields[$key]['field'] == 'title' || (is_array($_fields[$key]['field']) && in_array('title', $_fields[$key]['field'])))) {
                                            $otstup = str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;', ($item['NSLevel']-1));
                                            if ($item['NSLevel']-1 > 0) { $otstup .=  ' &raquo; '; }
                                        } else { $otstup = ''; }

                                        echo '<td class="'.$row_class.'" valign="middle">'.$otstup.$data.'</td>'. "\n";
                                    }
                                } else {
                                    if (isset($_fields[$key]['do'])) { $do = 'do=config&id='.(int)$_REQUEST['id'].'&'.$_fields[$key]['do']; } else { $do = 'do'; }
                                    if (isset($_fields[$key]['do_suffix'])) { $dos = $_fields[$key]['do_suffix']; $ids = 'item_id'; } else { $dos = ''; $ids = 'id'; }
                                    echo '<td class="'.$row_class.'" valign="middle">
                                            <a title="'.$_LANG['AD_DOWN'].'" href="?view='.cmsAdmin::getApplet().'&'.$do.'=move_down&co='.$item[$_fields[$key]['field']].'&'.$ids.'='.$item['id'].'"><img src="images/actions/down.gif" border="0"/></a>';
                                    if ($table != 'cms_menu' && $table != 'cms_category'){
                                        echo '<input class="lt_input" type="text" size="4" name="ordering[]" value="'.$item['ordering'].'" />';
                                        echo '<input name="ids[]" type="hidden" value="'.$item['id'].'" />';
                                    } else {
                                        echo '<input class="lt_input" type="text" size="4" name="ordering[]" value="'.$item['ordering'].'" disabled/>';
                                    }

                                    echo '<a title="'.$_LANG['AD_UP'].'" href="?view='.cmsAdmin::getApplet().'&'.$do.'=move_up&co='.$item[$_fields[$key]['field']].'&'.$ids.'='.$item['id'].'"><img src="images/actions/top.gif" border="0"/></a>'.
                                                        '</td>'. "\n";
                                }
                            }
                        }

                        if ($is_actions) {
                            echo '<td width="110" class="'.$row_class.'" align="right" valign="middle"><div style="padding-right:8px">';
                            
                            foreach($_actions as $action) {
                                if (isset($action['condition'])) {
                                    $print = $action['condition']($item);
                                } else {
                                    $print = true;
                                }

                                if ($print) {
                                    $icon   = $action['icon'];
                                    $title  = $action['title'];
                                    $link   = $action['link'];

                                    foreach($item as $f=>$v) {
                                        $link = str_replace('%'.$f.'%', $v, $link);
                                    }
                                    
                                    if (!isset($action['confirm'])) {
                                        echo '<a href="'. $link .'" class="uittip" title="'. $title .'"'. (isset($action['target']) ? ' target="'. $action['target'] .'"' : '') .'><img hspace="2" src="images/actions/'. $icon .'" border="0" alt="'. $title .'"/></a>';
                                    } else {
                                        echo '<a href="#" class="uittip" onclick="jsmsg(\''. $action['confirm'] .'\', \''. $link .'\')"  title="'. $title .'"><img hspace="2" src="images/actions/'. $icon .'" border="0" alt="'. $title .'"/></a>';
                                    }
                                }
                            }

                            echo '</div></td>'. "\n";
                        }

                        echo '</tr>'."\n";
                    }
                    
        echo '</tbody></table></form>';
        echo '<style>tr#lt_row2{ background:#eeeeee !important; } tr#lt_row1:hover td,tr#lt_row2:hover{ background:#cccccc !important; }</style>';
        echo '<script type="text/javascript">trClickChecked();</script>';

        $link = '?view='. cmsAdmin::getApplet();
        
        if ($sort) {
            $link .= '&sort='.$sort;
            if (cmsCore::inRequest('so')) { $link .= '&so='.cmsCore::request('so'); }
        }

        echo cmsPage::getPagebar($total, $page, $perpage, $_SERVER['PHP_SELF'] .'?'. cpAddParam($_SERVER['QUERY_STRING'], 'page', '%page%'));
    } else {
        echo '<p class="cp_message">'.$_LANG['OBJECTS_NOT_FOUND'].'</p>';
    }
}
Example #2
0
cmsCore::loadClass('page');
cmsCore::loadClass('user');
cmsCore::loadClass('actions');

if (!cmsCore::c('user')->update()) {
    cmsCore::error404();
}

// проверяем доступ по Ip
if (!cmsCore::checkAccessByIp(cmsCore::c('config')->allow_ip)) { cmsCore::error404(); }

cmsCore::loadLanguage('admin/lang');
global $_LANG;

//-------CHECK AUTHENTICATION--------------------------------------//
if (!cmsCore::c('user')->is_admin && cmsAdmin::getApplet() != 'login') {
    cmsCore::redirect('/admin/index.php?view=login');
}

//--------LOAD ACCESS OPTIONS LIST---------------------------------//

$adminAccess = cmsUser::getAdminAccess();

//------------------------------------------------------------------//

cmsCore::c('user')->onlineStats();
cmsCore::c('page')->setTitle();

$GLOBALS['cp_page_title'] = '';
$GLOBALS['cp_page_head']  = array();
Example #3
0
function cpListTable($table, $_fields, $_actions, $where = '', $orderby = 'title', $perpage = 60)
{
    global $_LANG;
    $page = cmsCore::request('page', 'int', 1);
    $sql = 'SELECT *';
    $is_actions = sizeof($_actions);
    foreach ($_fields as $key => $value) {
        if (isset($_fields[$key]['fdate'])) {
            $sql .= ", DATE_FORMAT(" . $_fields[$key]['field'] . ", '" . $_fields[$key]['fdate'] . "') as `" . $_fields[$key]['field'] . "`";
        }
    }
    $sql .= ' FROM ' . $table;
    if (isset($_SESSION['filter_table']) && $_SESSION['filter_table'] != $table) {
        unset($_SESSION['filter']);
    }
    if (cmsCore::inRequest('nofilter')) {
        unset($_SESSION['filter']);
        cmsCore::redirect('/admin/index.php?' . cpAddParam($_SERVER['QUERY_STRING'], 'page', 1));
    }
    $filter = false;
    if (cmsCore::inRequest('filter')) {
        $filter = cmsCore::request('filter', 'array_str', '');
        if (isset($_SESSION['filter']) && $_SESSION['filter'] != $filter) {
            $page = 1;
        }
        $_SESSION['filter'] = $filter;
    } else {
        if (isset($_SESSION['filter'])) {
            $filter = $_SESSION['filter'];
        }
    }
    if ($filter) {
        $f = 0;
        foreach ($filter as $key => $value) {
            if (!empty($filter[$key]) && $filter[$key] != -100) {
                if (!is_numeric($filter[$key])) {
                    cmsCore::c('db')->where($key . " LIKE '%" . $filter[$key] . "%'");
                } else {
                    cmsCore::c('db')->where($key . " = '" . $filter[$key] . "'");
                }
                $f++;
            }
        }
        if (!isset($_SESSION['filter'])) {
            $_SESSION['filter'] = $filter;
        }
    }
    if (mb_strlen($where) <= 3) {
        $where = '1=1';
    }
    //Выставляем сортировку выборки данных в БД
    $sort = cmsCore::request('sort', 'str', '');
    $so = 'asc';
    if (empty($sort)) {
        if (!empty($orderby)) {
            $orderby = trim($orderby);
            if (mb_strstr($orderby, ' ')) {
                $sorta = explode(' ', $orderby);
                $sort = $sorta[0];
                foreach ($sorta as $s) {
                    $s = mb_strtolower(trim($s, ' ,'));
                    if ($s == 'asc' || $s == 'desc') {
                        $so = $s;
                        break;
                    }
                }
            } else {
                $sort = $orderby;
            }
            cmsCore::c('db')->order_by = 'ORDER BY ' . $orderby;
        } else {
            foreach ($_fields as $key => $value) {
                if ($_fields[$key]['field'] == 'ordering' && $sort != 'NSLeft') {
                    $sort = 'ordering';
                    cmsCore::c('db')->orderBy($sort, $so);
                }
            }
        }
    } else {
        $so = cmsCore::request('so', array('asc', 'desc'), $so);
        cmsCore::c('db')->orderBy($sort, $so);
    }
    $total = cmsCore::c('db')->rows_count($table, $where . ' ' . cmsCore::c('db')->where);
    cmsCore::c('db')->limitPage($page, $perpage);
    $result = cmsCore::c('db')->query($sql . "\n" . 'WHERE ' . $where . ' ' . cmsCore::c('db')->where . "\n" . (empty(cmsCore::c('db')->order_by) ? '' : cmsCore::c('db')->order_by) . ' LIMIT ' . cmsCore::c('db')->limit);
    $_SESSION['filter_table'] = $table;
    if (cmsCore::c('db')->error()) {
        unset($_SESSION['filter']);
        cmsCore::redirect('/admin/index.php?' . $_SERVER['QUERY_STRING']);
    }
    $lt_form_field = cmsCore::c('page')->initTemplate('special', 'list_table_filter')->fetch();
    $filters = 0;
    $f_html = '';
    //Find and render filters
    foreach ($_fields as $key => $value) {
        if (isset($_fields[$key]['filter'])) {
            $f_html .= str_replace('%title%', $_fields[$key]['title'], $lt_form_field);
            $initval = false;
            if (isset($filter[$_fields[$key]['field']])) {
                $initval = $filter[$_fields[$key]['field']];
            }
            $inputname = 'filter[' . $_fields[$key]['field'] . ']';
            if (!isset($_fields[$key]['filterlist'])) {
                $f_html .= str_replace('%field%', '<input type="text" class="form-control" name="' . $inputname . '" size="' . $_fields[$key]['filter'] . '" value="' . ($initval === false ? '' : $initval) . '" />', $f_html);
            } else {
                $f_html .= str_replace('%field%', cpBuildList($inputname, $_fields[$key]['filterlist'], $initval), $f_html);
            }
            $filters += 1;
            $_SERVER['QUERY_STRING'] = str_replace('filter[' . $_fields[$key]['field'] . ']=', '', $_SERVER['QUERY_STRING']);
        }
    }
    foreach ($_fields as $key => $value) {
        if (!is_array($_fields[$key]['field'])) {
            $_fields[$key]['sort_link'] = 'index.php?' . cpAddParam($_SERVER['QUERY_STRING'], array(0 => 'sort', 1 => 'so'), array(0 => $_fields[$key]['field'], 1 => $so == 'asc' ? 'desc' : 'asc'));
        }
    }
    $items = $actions = array();
    if (cmsCore::c('db')->num_rows($result)) {
        while ($item = cmsCore::c('db')->fetch_assoc($result)) {
            $itms = array();
            foreach ($_fields as $key => $value) {
                $it = array();
                if (isset($_fields[$key]['link'])) {
                    $it['type'] = 'link';
                    $it['link'] = str_replace('%id%', $item['id'], $_fields[$key]['link']);
                    if (isset($_fields[$key]['prc'])) {
                        // функция обработки под названием $_fields[$key]['prc']
                        // какие параметры передать функции - один ключ или произвольный массив ключей
                        if (is_array($_fields[$key]['field'])) {
                            foreach ($_fields[$key]['field'] as $func_field) {
                                $in_func_array[$func_field] = $item[$func_field];
                            }
                            $it['title'] = call_user_func($_fields[$key]['prc'], $in_func_array);
                        } else {
                            $it['title'] = call_user_func($_fields[$key]['prc'], $item[$_fields[$key]['field']]);
                        }
                    } else {
                        $it['title'] = $item[$_fields[$key]['field']];
                        if (isset($_fields[$key]['maxlen'])) {
                            if (mb_strlen($it['title']) > $_fields[$key]['maxlen']) {
                                $it['title'] = mb_substr($it['title'], 0, $_fields[$key]['maxlen']) . '...';
                            }
                        }
                    }
                    //nested sets otstup
                    if (isset($item['NSLevel']) && ($_fields[$key]['field'] == 'title' || is_array($_fields[$key]['field']) && in_array('title', $_fields[$key]['field']))) {
                        $otstup = str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;', $item['NSLevel'] - 1);
                        if ($item['NSLevel'] - 1 > 0) {
                            $otstup .= ' &raquo; ';
                        }
                    } else {
                        $otstup = '';
                    }
                    $it['otstup'] = $otstup;
                    if ($table == 'cms_components') {
                        if (!function_exists('cpComponentHasConfig') || !cpComponentHasConfig($item['link'])) {
                            unset($it['link']);
                        }
                        $it['icon'] = '/admin/images/components/' . $item['link'] . '.png';
                    }
                } else {
                    if ($_fields[$key]['field'] != 'ordering') {
                        if ($_fields[$key]['field'] == 'published' || isset($_fields[$key]['published'])) {
                            $it['type'] = 'published';
                            if (isset($_fields[$key]['do'])) {
                                $do = $_fields[$key]['do'];
                            } else {
                                $do = 'do';
                            }
                            if (isset($_fields[$key]['do_suffix'])) {
                                $dos = $_fields[$key]['do_suffix'];
                                $ids = 'item_id';
                            } else {
                                $dos = '';
                                $ids = 'id';
                            }
                            if ($item[$_fields[$key]['field']]) {
                                $qs = cpAddParam($_SERVER['QUERY_STRING'], $do, 'hide' . $dos);
                                $qs = cpAddParam($qs, $ids, $item['id']);
                                $qs2 = cpAddParam($_SERVER['QUERY_STRING'], $do, 'show' . $dos);
                                $qs2 = cpAddParam($qs2, $ids, $item['id']);
                                $it['link'] = "javascript:pub(" . $item['id'] . ", '" . $qs . "', '" . $qs2 . "', 'off', 'on');";
                                $it['icon'] = 'images/actions/on.gif';
                                $it['title'] = $_LANG['HIDE'];
                            } else {
                                $qs = cpAddParam($_SERVER['QUERY_STRING'], $do, 'show' . $dos);
                                $qs = cpAddParam($qs, $ids, $item['id']);
                                $qs2 = cpAddParam($_SERVER['QUERY_STRING'], $do, 'hide' . $dos);
                                $qs2 = cpAddParam($qs2, $ids, $item['id']);
                                $it['link'] = "javascript:pub(" . $item['id'] . ", '" . $qs . "', '" . $qs2 . "', 'on', 'off');";
                                $it['icon'] = 'images/actions/off.gif';
                                $it['title'] = $_LANG['SHOW'];
                            }
                        } else {
                            $it['type'] = 'default';
                            if (isset($_fields[$key]['prc'])) {
                                // функция обработки под названием $_fields[$key]['prc']
                                // какие параметры передать функции - один ключ или произвольный массив ключей
                                if (is_array($_fields[$key]['field'])) {
                                    foreach ($_fields[$key]['field'] as $func_field) {
                                        $in_func_array[$func_field] = $item[$func_field];
                                    }
                                    $it['title'] = call_user_func($_fields[$key]['prc'], $in_func_array);
                                } else {
                                    $it['title'] = call_user_func($_fields[$key]['prc'], $item[$_fields[$key]['field']]);
                                }
                                if (is_array($it['title']) && isset($it['title']['link'])) {
                                    $it['title'] = str_replace('%id%', $item['id'], $it['title']['link']);
                                }
                            } else {
                                $it['title'] = $item[$_fields[$key]['field']];
                                if (isset($_fields[$key]['maxlen'])) {
                                    if (mb_strlen($it['title']) > $_fields[$key]['maxlen']) {
                                        $it['title'] = mb_substr($it['title'], 0, $_fields[$key]['maxlen']) . '...';
                                    }
                                }
                            }
                            //nested sets otstup
                            if (isset($item['NSLevel']) && ($_fields[$key]['field'] == 'title' || is_array($_fields[$key]['field']) && in_array('title', $_fields[$key]['field']))) {
                                $otstup = str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;', $item['NSLevel'] - 1);
                                if ($item['NSLevel'] - 1 > 0) {
                                    $otstup .= ' &raquo; ';
                                }
                            } else {
                                $otstup = '';
                            }
                            $it['otstup'] = $otstup;
                        }
                    } else {
                        $it['type'] = 'ordering';
                        if (isset($_fields[$key]['do'])) {
                            $do = 'do=config&id=' . (int) $_REQUEST['id'] . '&' . $_fields[$key]['do'];
                        } else {
                            $do = 'do';
                        }
                        if (isset($_fields[$key]['do_suffix'])) {
                            $dos = $_fields[$key]['do_suffix'];
                            $ids = 'item_id';
                        } else {
                            $dos = '';
                            $ids = 'id';
                        }
                        $it['link_down'] = '?view=' . cmsAdmin::getApplet() . '&' . $do . '=move_down&co=' . $item[$_fields[$key]['field']] . '&' . $ids . '=' . $item['id'];
                        $it['link_up'] = '?view=' . cmsAdmin::getApplet() . '&' . $do . '=move_up&co=' . $item[$_fields[$key]['field']] . '&' . $ids . '=' . $item['id'];
                        $it['value'] = $item['ordering'];
                    }
                }
                $itms[] = $it;
            }
            if ($is_actions) {
                $actions[$item['id']] = array();
                foreach ($_actions as $action) {
                    if (isset($action['condition'])) {
                        $print = $action['condition']($item);
                    } else {
                        $print = true;
                    }
                    if ($print) {
                        $icon = $action['icon'];
                        $title = $action['title'];
                        $link = $action['link'];
                        foreach ($item as $f => $v) {
                            $link = str_replace('%' . $f . '%', $v, $link);
                            if (isset($action['confirm'])) {
                                $action['confirm'] = str_replace('%' . $f . '%', $v, $action['confirm']);
                            }
                        }
                        $acts = array('link' => $link, 'title' => $title, 'icon' => 'images/actions/' . $icon, 'target' => isset($action['target']) ? $action['target'] : false);
                        if (isset($action['confirm'])) {
                            $acts['link'] = "javascript:jsmsg('" . $action['confirm'] . "', '" . $link . "');";
                        }
                        $actions[$item['id']][] = $acts;
                    }
                }
            }
            $items[$item['id']] = $itms;
        }
        $link = '?view=' . cmsAdmin::getApplet();
        if ($sort) {
            $link .= '&sort=' . $sort;
            if (cmsCore::inRequest('so')) {
                $link .= '&so=' . cmsCore::request('so');
            }
        }
    }
    cmsCore::c('page')->initTemplate('special', 'list_table')->assign('applet', cmsAdmin::getApplet())->assign('filters', $filters)->assign('f_html', $f_html)->assign('f', $f)->assign('query_str', $_SERVER['QUERY_STRING'])->assign('sort', $sort)->assign('so', $so)->assign('actions', $actions)->assign('table', $table)->assign('fields', $_fields)->assign('items', $items)->display();
    echo cmsPage::getPagebar($total, $page, $perpage, $_SERVER['PHP_SELF'] . '?' . cpAddParam($_SERVER['QUERY_STRING'], 'page', '%page%'));
}