/** * "View Children" tab setup */ $maxpageSize = $modx->config['number_of_results']; define('MAX_DISPLAY_RECORDS_NUM', $maxpageSize); if (!class_exists('makeTable')) { include_once $modx->config['site_manager_path'] . 'includes/extenders/maketable.class.php'; } $childsTable = new makeTable(); // Get child document count $rs = $modx->db->select('count(DISTINCT sc.id)', "{$tbl_site_content} AS sc\n\t\tLEFT JOIN {$tbl_document_groups} AS dg ON dg.document = sc.id", "sc.parent='{$content['id']}' AND ({$access})"); $numRecords = $modx->db->getValue($rs); $sort = isset($_REQUEST['sort']) ? $_REQUEST['sort'] : 'createdon'; $dir = isset($_REQUEST['dir']) ? $_REQUEST['dir'] : 'DESC'; // Get child documents (with paging) $rs = $modx->db->select('DISTINCT sc.*', "{$tbl_site_content} AS sc\n\t\tLEFT JOIN {$tbl_document_groups} AS dg ON dg.document = sc.id", "sc.parent='{$content['id']}' AND ({$access})", "{$sort} {$dir}", $childsTable->handlePaging()); $filter_sort = ''; $filter_dir = ''; if ($numRecords > 0) { $filter_sort = '<p><select size="1" name="sort" onchange="document.location=\'index.php?a=3&id=' . $id . '&dir=' . $dir . '&sort=\'+this.options[this.selectedIndex].value">' . '<option value="createdon"' . ($sort == 'createdon' ? ' selected' : '') . '>' . $_lang['createdon'] . '</option>' . '<option value="pub_date"' . ($sort == 'pub_date' ? ' selected' : '') . '>' . $_lang["page_data_publishdate"] . '</option>' . '<option value="pagetitle"' . ($sort == 'pagetitle' ? ' selected' : '') . '>' . $_lang['pagetitle'] . '</option>' . '<option value="menuindex"' . ($sort == 'menuindex' ? ' selected' : '') . '>' . $_lang['resource_opt_menu_index'] . '</option>' . '<option value="published"' . ($sort == 'published' ? ' selected' : '') . '>' . $_lang['resource_opt_is_published'] . '</option>' . '</select>'; $filter_dir = '<select size="1" name="dir" onchange="document.location=\'index.php?a=3&id=' . $id . '&sort=' . $sort . '&dir=\'+this.options[this.selectedIndex].value">' . '<option value="DESC"' . ($dir == 'DESC' ? ' selected' : '') . '>' . $_lang['sort_desc'] . '</option>' . '<option value="ASC"' . ($dir == 'ASC' ? ' selected' : '') . '>' . $_lang['sort_asc'] . '</option>' . '</select></p>'; $resource = $modx->db->makeArray($rs); // CSS style for table $tableClass = 'grid'; $rowHeaderClass = 'gridHeader'; $rowRegularClass = 'gridItem'; $rowAlternateClass = 'gridAltItem'; $childsTable->setTableClass($tableClass); $childsTable->setRowHeaderClass($rowHeaderClass); $childsTable->setRowRegularClass($rowRegularClass); $childsTable->setRowAlternateClass($rowAlternateClass);
} /** * "View Children" tab setup */ $maxpageSize = $modx->config['number_of_results']; define('MAX_DISPLAY_RECORDS_NUM', $maxpageSize); if (!class_exists('makeTable')) { include_once $modx->config['base_path'] . 'manager/includes/extenders/maketable.class.php'; } $childsTable = new makeTable(); // Get child document count $sql = 'SELECT DISTINCT sc.id ' . 'FROM ' . $tbl_site_content . ' AS sc ' . 'LEFT JOIN ' . $tbl_document_groups . ' AS dg ON dg.document = sc.id ' . 'WHERE sc.parent=\'' . $content['id'] . '\' ' . 'AND (' . $access . ')'; $rs = $modx->db->query($sql); $numRecords = $modx->db->getRecordCount($rs); // Get child documents (with paging) $sql = 'SELECT DISTINCT sc.* ' . 'FROM ' . $tbl_site_content . ' AS sc ' . 'LEFT JOIN ' . $tbl_document_groups . ' AS dg ON dg.document = sc.id ' . 'WHERE sc.parent=\'' . $content['id'] . '\' ' . 'AND (' . $access . ') ' . $childsTable->handlePaging(); // add limit clause if ($numRecords > 0) { if (!($rs = $modx->db->query($sql))) { // sql error $e->setError(1); $e->dumpError(); include $modx->config['base_path'] . 'manager/includes/footer.inc.php'; exit; } else { $resource = array(); while ($row = $modx->fetchRow($rs)) { $resource[] = $row; } // CSS style for table $tableClass = 'grid';