/** * @desc Visualiza todas las figuras existentes de una publicación **/ function Figures() { global $rmc_messages, $xoopsTpl, $xoopsSecurity; define('DF_LOCATION', 'list'); $id = rmc_server_var($_GET, 'id', 0); $search = rmc_server_var($_GET, 'search', ''); $rmc_config = RMFunctions::configs(); //Navegador de páginas $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT COUNT(*) FROM " . $db->prefix('rd_figures') . " WHERE id_res={$id}"; $sql1 = ''; if ($search) { //Separamos la frase en palabras para realizar la búsqueda $words = explode(" ", $search); foreach ($words as $k) { //Verificamos el tamaño de la palabra if (strlen($k) <= 2) { continue; } $sql1 .= ($sql1 == '' ? ' AND ' : " OR ") . " `desc` LIKE '%{$k}%' "; } } list($num) = $db->fetchRow($db->queryF($sql . $sql1)); $page = rmc_server_var($_REQUEST, 'page', 1); $page = $page <= 0 ? 1 : $page; $limit = 13; $tpages = ceil($num / $limit); $page = $page > $tpages ? $tpages : $page; $start = $num <= 0 ? 0 : ($page - 1) * $limit; $nav = new RMPageNav($num, $limit, $page, 4); $nav->target_url("?id={$id}&page={PAGE_NUM}&search={$search}"); $ruta = '?id=' . $id . '&page=' . $page . '&search=' . $search; //Fin navegador de páginas $sql = "SELECT * FROM " . $db->prefix('rd_figures') . " WHERE id_res={$id}"; $sql1 = ''; if ($search) { //Separamos la frase en palabras para realizar la búsqueda $words = explode(" ", $search); foreach ($words as $k) { //Verificamos el tamaño de la palabra if (strlen($k) <= 2) { continue; } $sql1 .= ($sql1 == '' ? ' AND ' : " OR ") . " `desc` LIKE '%{$k}%' "; } } $sql2 = " ORDER BY id_fig DESC LIMIT {$start},{$limit} "; $result = $db->queryF($sql . $sql1 . $sql2); $figures = array(); while ($rows = $db->fetchArray($result)) { $fig = new RDFigure(); $fig->assignVars($rows); $figures[] = array('id' => $fig->id(), 'desc' => $fig->getVar('desc')); } RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.min.js'); RMTemplate::get()->add_script(RMCURL . '/include/js/jquery-ui.min.js'); RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js'); RMTemplate::get()->add_script('include/js/scripts.php?file=ajax.js'); RMTemplate::get()->add_script('include/js/editor-' . $rmc_config['editor_type'] . '.js'); $theme_css = xoops_getcss(); $vars = $xoopsTpl->get_template_vars(); extract($vars); if ($rmc_config['editor_type'] == 'tiny') { RMTemplate::get()->add_script(XOOPS_URL . '/modules/rmcommon/api/editors/tinymce/tiny_mce_popup.js'); } elseif ($rmc_config['editor_type'] == 'xoops') { RMTemplate::get()->add_script(XOOPS_URL . '/modules/rmcommon/api/editors/exmcode/editor-popups.js'); } RMTemplate::get()->add_style('refs.css', 'docs'); RMTemplate::get()->add_style('jquery.css', 'rmcommon'); // Options for table header $options[] = array('title' => __('Select Document', 'docs'), 'href' => 'javascript:;', 'attrs' => 'id="option-resource" onclick="docsAjax.getSectionsList(1);"', 'tip' => __('Select another Document to show the figures that belong to this.', 'docs')); $options[] = array('title' => __('Create Figure', 'docs'), 'href' => "?action=new&id={$id}&search={$search}&page={$page}", 'attrs' => 'id="option-new-fig"', 'tip' => __('Create a new figure', 'docs')); // Get additional options from other modules or plugins $options = RMEvents::get()->run_event('docs.figures.options', $options, $id); // Insert adtional content in template $other_content = ''; $other_content = RMEvents::get()->run_event('docs.additional.figures.content', $other_content, $id); include RMTemplate::get()->get_template('rd_figures.php', 'module', 'docs'); }
/** * Get all figures list according to given parameters * @param int Resource ID * @param Referenced var to return results count * @param string Search keyword * @param int Start results * @param int Results number limit * @return array */ public function figures($res = 0, &$count, $search = '', $start = 0, $limit = 15) { $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT COUNT(*) FROM " . $db->prefix('rd_figures') . ($res > 0 ? " WHERE id_res='{$res}'" : ''); if ($search != '') { $sql .= ($res > 0 ? " AND " : " WHERE ") . " (desc LIKE '%{$k}%' OR content LIKE '%{$k}%')"; } if ($res > 0) { $res = new RDResource($res); } list($num) = $db->fetchRow($db->query($sql)); $limit = $limit <= 0 ? 15 : $limit; $count = $num; //Fin de navegador de páginas $sql = str_replace("COUNT(*)", "*", $sql); $sql .= " ORDER BY id_fig DESC LIMIT {$start},{$limit}"; $result = $db->query($sql); $figures = array(); while ($rows = $db->fetchArray($result)) { $ref = new RDFigure(); $ref->assignVars($rows); if ($res->isNew()) { $res = new RDResource($ref->resource()); } $figures[] = array('id' => $ref->id(), 'title' => $ref->getVar('title'), 'desc' => $ref->getVar('desc'), 'content' => substr(TextCleaner::getInstance()->clean_disabled_tags($ref->getVar('content')), 0, 50) . "...", 'resource' => $res->getVar('title')); } return $figures; }
/** * @desc Muestra todas las figuras existentes **/ function rd_show_figures() { global $xoopsModule, $xoopsSecurity; $id_res = isset($_REQUEST['res']) ? intval($_REQUEST['res']) : 0; $search = isset($_REQUEST['search']) ? $_REQUEST['search'] : ''; if ($id_res <= 0) { redirectMsg('resources.php', __('First select a Document to view the figures.', 'docs'), 1); } $res = new RDResource($id_res); if ($res->isNew()) { redirectMsg('resources.php', __('Specified Document does not exists!', 'docs'), 1); } $search = rmc_server_var($_GET, 'search', ''); //Separamos frase en palabras $words = explode(" ", $search); $db = XoopsDatabaseFactory::getDatabaseConnection(); //Navegador de páginas $sql = "SELECT COUNT(*) FROM " . $db->prefix('rd_figures') . ($id_res ? " WHERE id_res='{$id_res}'" : ''); $sql1 = ''; if ($search) { foreach ($words as $k) { //verifica que palabra sea mayor a 2 letras if (strlen($k) <= 2) { continue; } $sql1 .= ($sql1 == '' ? $id_res ? " AND " : " WHERE " : " OR ") . " (title LIKE '%{$k}%' OR desc LIKE '%{$k}%')"; } } list($num) = $db->fetchRow($db->query($sql . $sql1)); $page = rmc_server_var($_REQUEST, 'page', 1); $limit = 15; $tpages = ceil($num / $limit); $page = $page > $tpages ? $tpages : $page; $start = $num <= 0 ? 0 : ($page - 1) * $limit; $nav = new RMPageNav($num, $limit, $page, 5); $nav->target_url('figures.php?res=' . $id_res . '&page={PAGE_NUM}'); $sql = str_replace("COUNT(*)", "*", $sql); $sql2 = " LIMIT {$start},{$limit}"; $result = $db->queryF($sql . $sql1 . $sql2); $figures = array(); while ($rows = $db->fetchArray($result)) { $fig = new RDFigure(); $fig->assignVars($rows); $figures[] = array('id' => $fig->id(), 'title' => $fig->getVar('title'), 'text' => substr(strip_tags($fig->getVar('desc')), 0, 150) . (strlen($fig->getVar('desc')) <= 150 ? '' : '...')); } // Event $figures = RMEvents::get()->run_event('docs.loading.figures', $figures, $res); RMTemplate::get()->add_style('admin.css', 'docs'); RMTemplate::get()->add_style('jquery.css', 'rmcommon'); RMTemplate::get()->add_script('../include/js/admin.js'); RMTemplate::get()->assign('xoops_pagetitle', sprintf(__('Figures in %s', 'docs'), $res->getVar('title'))); RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js'); RMTemplate::get()->add_head('<script type="text/javascript"> var rd_select_message = "' . __('You have not selected any figure!', 'docs') . '"; var rd_message = "' . __('Do you really wish to delete selected figures?', 'docs') . '"; </script>'); xoops_cp_location("<a href='./'>" . $xoopsModule->name() . "</a> » " . __('Figures', 'docs')); xoops_cp_header(); include RMEvents::get()->run_event('docs.admin.template.figures', RMTemplate::get()->get_template('admin/rd_figures.php', 'module', 'docs')); xoops_cp_footer(); }