Pelzini

This is the code documentation for the Pelzini project

More info
Project:
Home   coverage processor viewer

Search documentation

Search term:

What to search:





Path or filename:

source of /viewer/controllers/search.php

Does a search of the database
  1. <?php
  2. /*
  3. Copyright 2008 Josh Heidenreich
  4.  
  5. This file is part of Pelzini.
  6.  
  7. Pelzini is free software: you can redistribute it and/or modify
  8. it under the terms of the GNU General Public License as published by
  9. the Free Software Foundation, either version 3 of the License, or
  10. (at your option) any later version.
  11.  
  12. Pelzini is distributed in the hope that it will be useful,
  13. but WITHOUT ANY WARRANTY; without even the implied warranty of
  14. MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15. GNU General Public License for more details.
  16.  
  17. You should have received a copy of the GNU General Public License
  18. along with Pelzini.  If not, see <http://www.gnu.org/licenses/>.
  19. */
  20.  
  21. /**
  22.  * Does a search of the database
  23.  *
  24.  * @package Viewer
  25.  * @author Josh Heidenreich
  26.  * @since 0.1
  27.  * @tag i18n-done
  28.  **/
  29.  
  30. require_once 'functions.php';
  31. require_once 'search_functions.php';
  32.  
  33. $_GET['q'] = @trim($_GET['q']);
  34. $_GET['path'] = @trim($_GET['path']);
  35.  
  36. // class::method -> redirect to function page
  37. if (preg_match('/^([a-zA-Z0-9_]+)::([a-zA-Z0-9_]+)$/', $_GET['q'], $matches)) {
  38.     $class = db_escape($matches[1]);
  39.     $method = db_escape($matches[2]);
  40.     $q = "SELECT functions.id
  41.           FROM functions
  42.           INNER JOIN classes ON functions.classid = classes.id
  43.           WHERE classes.name = '{$class}'
  44.             AND functions.name = '{$method}'
  45.             AND functions.projectid = {$project['id']}
  46.           LIMIT 2";
  47.     $res = db_query($q);
  48.     $num = db_num_rows($res);
  49.     if ($num == 1) {
  50.         $row = db_fetch_assoc($res);
  51.         redirect('function?name=' . urlencode($matches[2]) . '&memberof=' . urlencode($matches[1]) . '&q=' . urlencode($_GET['q']));
  52.     }
  53. }
  54.  
  55. $skin['page_name'] = str(STR_SEARCH_TITLE);
  56. require_once 'head.php';
  57.  
  58. if ($_GET['q'] == '' and $_GET['path'] == '') {
  59. 	echo '<p>You must specify a search term.</p>';
  60. 	require_once 'foot.php';
  61. 	exit;
  62. }
  63.  
  64. $query = db_escape($_GET['q']);
  65. $_GET['advanced'] = (int) $_GET['advanced'];
  66. $results = false;
  67.  
  68. // Determine the match string
  69. // #ITEM# will be replaced in the specific search query
  70. // for for classes, #ITEM# will become classes.name
  71. $match_string = "#ITEM# '";
  72.  
  73. $extra_where = '1';
  74. if (!empty($_GET['path'])) {
  75.     $path = db_escape($_GET['path']);
  76.     $extra_where = "files.name LIKE '%{$path}%'";
  77. }
  78.  
  79.  
  80. echo "<img src=\"assets/icon_remove.png\" alt=\"\" title=\"Hide this result\" onclick=\"hide_content(event)\" class=\"showhide\">";
  81. echo "<span style=\"float: right;\">", str(STR_SHOW_HIDE_ALL), " &nbsp;</span>";
  82.  
  83. echo '<h2>', str(STR_SEARCH_TITLE), '</h2>';
  84. echo '<p>', str(STR_YOU_SEARCHED_FOR, 'term', htmlspecialchars($_GET['q'])), '</p>';
  85.  
  86. // classes
  87. if (@$_GET['advanced'] == 0 or @$_GET['classes'] == 'y') {
  88.     $q = "SELECT classes.id, classes.name, classes.description, classes.extends, classes.abstract,
  89.         files.name as filename, classes.fileid,
  90.             IF(BINARY classes.name = '{$query}', 1, 0) +
  91.             IF(classes.name LIKE '{$query}', 1, 0) +
  92.             IF(classes.name LIKE '{$query}%', 1, 0) +
  93.         0 AS relevancy
  94.     FROM classes
  95.     INNER JOIN files ON classes.fileid = files.id
  96.     WHERE classes.name LIKE '%{$query}%'
  97.       AND classes.projectid = {$project['id']}
  98.       AND {$extra_where}
  99.     ORDER BY relevancy DESC, classes.name";
  100.  
  101.     $res = db_query ($q);
  102.     $num = db_num_rows ($res);
  103.     if ($num != 0) {
  104.         $results = true;
  105.         echo '<h3>', str(STR_CLASSES_RESULT, 'num', $num), '</h3>';
  106.  
  107.         $alt = false;
  108.         echo '<div class="list">';
  109.         while ($row = db_fetch_assoc ($res)) {
  110.             $class = 'item';
  111.             if ($alt) $class .= '-alt';
  112.  
  113.             echo "<div class=\"{$class}\">";
  114.             echo "<img src=\"assets/icon_remove.png\" alt=\"\" title=\"Hide this result\" onclick=\"hide_content(event)\" class=\"showhide\">";
  115.             echo "<p><strong>", get_class_link($row['name'], $row['filename']), "</strong>";
  116.  
  117.             if ($row['extends'] != null) {
  118.                 echo " <small>extends ", get_class_link($row['extends']), "</small>";
  119.             }
  120.  
  121.             if ($row['abstract'] == 1) {
  122.                 echo " <small>(abstract)</small>";
  123.             }
  124.  
  125.             echo "<div class=\"content\">";
  126.             echo delink_inline($row['description']);
  127.             echo "</div>";
  128.             echo "</div>";
  129.  
  130.             $alt = ! $alt;
  131.         }
  132.         echo '</div>';
  133.     }
  134. }
  135.  
  136. // interfaces
  137. if (@$_GET['advanced'] == 0 or @$_GET['interfaces'] == 'y') {
  138.     $q = "SELECT interfaces.id, interfaces.name, interfaces.description, interfaces.extends,
  139.         files.name as filename, interfaces.fileid,
  140.             IF(BINARY interfaces.name = '{$query}', 1, 0) +
  141.             IF(interfaces.name LIKE '{$query}', 1, 0) +
  142.             IF(interfaces.name LIKE '{$query}%', 1, 0) +
  143.         0 AS relevancy
  144.     FROM interfaces
  145.     INNER JOIN files ON interfaces.fileid = files.id
  146.     WHERE interfaces.name LIKE '%{$query}%'
  147.       AND interfaces.projectid = {$project['id']}
  148.       AND {$extra_where}
  149.     ORDER BY relevancy DESC, interfaces.name";
  150.  
  151.     $res = db_query ($q);
  152.     $num = db_num_rows ($res);
  153.     if ($num != 0) {
  154.         $results = true;
  155.         echo '<h3>', str(STR_INTERFACES_RESULT, 'num', $num), '</h3>';
  156.  
  157.         $alt = false;
  158.         echo '<div class="list">';
  159.         while ($row = db_fetch_assoc ($res)) {
  160.             $class = 'item';
  161.             if ($alt) $class .= '-alt';
  162.  
  163.             echo "<div class=\"{$class}\">";
  164.             echo "<img src=\"assets/icon_remove.png\" alt=\"\" title=\"Hide this result\" onclick=\"hide_content(event)\" class=\"showhide\">";
  165.             echo "<p><strong>", get_interface_link($row['name'], $row['filename']), "</strong>";
  166.  
  167.             if ($row['extends'] != null) {
  168.                 echo " <small>extends ", get_interface_link($row['extends']), "</small>";
  169.             }
  170.  
  171.             echo "<div class=\"content\">";
  172.             echo delink_inline($row['description']);
  173.             echo "</div>";
  174.             echo "</div>";
  175.  
  176.             $alt = ! $alt;
  177.         }
  178.         echo '</div>';
  179.     }
  180. }
  181.  
  182. // functions
  183. if (@$_GET['advanced'] == 0 or @$_GET['functions'] == 'y') {
  184.     $q = "SELECT functions.id, functions.name, functions.description, functions.classid, functions.linenum,
  185.         files.name as filename, functions.fileid, classes.name as class,
  186.             IF(BINARY functions.name = '{$query}', 1, 0) +
  187.             IF(functions.name LIKE '{$query}', 1, 0) +
  188.             IF(functions.name LIKE '{$query}%', 1, 0) +
  189.         0 AS relevancy
  190.     FROM functions
  191.     INNER JOIN files ON functions.fileid = files.id
  192.     LEFT JOIN classes ON functions.classid = classes.id
  193.     WHERE functions.name LIKE '%{$query}%'
  194.       AND functions.projectid = {$project['id']}
  195.       AND {$extra_where}
  196.     ORDER BY relevancy DESC, functions.name";
  197.     $res = db_query ($q);
  198.     $num = db_num_rows ($res);
  199.     if ($num != 0) {
  200.         $results = true;
  201.         echo '<h3>', str(STR_FUNCTIONS_RESULT, 'num', $num), '</h3>';
  202.  
  203.         $alt = false;
  204.         echo '<div class="list">';
  205.         while ($row = db_fetch_assoc ($res)) {
  206.             $class = 'item';
  207.             if ($alt) $class .= '-alt';
  208.  
  209.             echo "<div class=\"{$class}\">";
  210.             echo "<img src=\"assets/icon_remove.png\" alt=\"\" title=\"Hide this result\" onclick=\"hide_content(event)\" class=\"showhide\">";
  211.  
  212.             if ($row['class'] != null) {
  213.                 $link_text = $row['class'] . '::' . $row['name'];
  214.             } else {
  215.                 $link_text = $row['name'];
  216.             }
  217.             echo "<p><strong>", get_function_link($row['class'], $row['name'], $link_text), "</strong>";
  218.  
  219.             echo "<div class=\"content\">";
  220.             echo delink_inline($row['description']);
  221.             echo "</div>";
  222.             echo "</div>";
  223.  
  224.             $alt = ! $alt;
  225.         }
  226.         echo '</div>';
  227.     }
  228. }
  229.  
  230.  
  231. // constants
  232. if (@$_GET['advanced'] == 0 or @$_GET['constants'] == 'y') {
  233.     $q = "SELECT constants.name, constants.description, files.name as filename, constants.fileid, constants.value,
  234.             IF(BINARY constants.name = '{$query}', 1, 0) +
  235.             IF(constants.name LIKE '{$query}', 1, 0) +
  236.             IF(constants.name LIKE '{$query}%', 1, 0) +
  237.         0 AS relevancy
  238.     FROM constants
  239.     INNER JOIN files ON constants.fileid = files.id
  240.     WHERE constants.name LIKE '%{$query}%'
  241.       AND constants.projectid = {$project['id']}
  242.       AND {$extra_where}
  243.     ORDER BY relevancy DESC, constants.name";
  244.     $res = db_query ($q);
  245.     $num = db_num_rows ($res);
  246.     if ($num != 0) {
  247.         $results = true;
  248.         echo '<h3>', str(STR_CONSTANTS_RESULT, 'num', $num), '</h3>';
  249.  
  250.         $alt = false;
  251.         echo '<div class="list">';
  252.         while ($row = db_fetch_assoc ($res)) {
  253.             $row['name'] = htmlspecialchars($row['name']);
  254.             $row['value'] = htmlspecialchars($row['value']);
  255.  
  256.             $class = 'item';
  257.             if ($alt) $class .= '-alt';
  258.  
  259.             echo "<div class=\"{$class}\">";
  260.             echo "<img src=\"assets/icon_remove.png\" alt=\"\" title=\"Hide this result\" onclick=\"hide_content(event)\" class=\"showhide\">";
  261.             echo "<p><strong>{$row['name']}</strong>";
  262.             echo " = <strong>{$row['value']}</strong>";
  263.  
  264.             echo "<div class=\"content\">";
  265.             echo delink_inline($row['description']);
  266.             echo "</div>";
  267.             echo "</div>";
  268.  
  269.             $alt = ! $alt;
  270.         }
  271.         echo '</div>';
  272.     }
  273. }
  274.  
  275.  
  276. // documents
  277. if (@$_GET['advanced'] == 0 or @$_GET['documents'] == 'y') {
  278.     $q = "SELECT documents.name,
  279.             IF(BINARY documents.name = '{$query}', 1, 0) +
  280.             IF(documents.name LIKE '{$query}', 1, 0) +
  281.             IF(documents.name LIKE '{$query}%', 1, 0) +
  282.         0 AS relevancy
  283.     FROM documents
  284.     WHERE documents.name LIKE '%{$query}%'
  285.       AND documents.projectid = {$project['id']}
  286.     ORDER BY relevancy DESC, documents.name";
  287.     $res = db_query ($q);
  288.     $num = db_num_rows ($res);
  289.     if ($num != 0) {
  290.         $results = true;
  291.         echo '<h3>', str(STR_DOCUMENTS_RESULT, 'num', $num), '</h3>';
  292.  
  293.         $alt = false;
  294.         echo '<div class="list">';
  295.         while ($row = db_fetch_assoc ($res)) {
  296.             $row['name'] = htmlspecialchars($row['name']);
  297.             $url = htmlspecialchars(urlencode($row['name']));
  298.  
  299.             $class = 'item';
  300.             if ($alt) $class .= '-alt';
  301.  
  302.             echo "<div class=\"{$class}\">";
  303.             echo "<a href=\"document?name={$url}\">{$row['name']}</a>";
  304.             echo "</div>";
  305.  
  306.             $alt = ! $alt;
  307.         }
  308.         echo '</div>';
  309.     }
  310. }
  311.  
  312.  
  313. // source
  314. if (@$_GET['advanced'] == 0 or @$_GET['source'] == 'y') {
  315.     $source_results = search_source(@$_GET['q'], false, @$_GET['path']);
  316.     if ($source_results) {
  317.         $results = true;
  318.     }
  319. }
  320.  
  321.  
  322. // no results
  323. if (! $results) {
  324.     echo "<p>Nothing was found!</p>";
  325. }
  326.  
  327.  
  328. require_once 'foot.php';
  329. ?>
  330.  
Powered by Pelzini, version 0.9.0 Documentation is made available under the GNU Free Documentation License 1.2.
Generated: Thursday, 15th March, 2018 at 02:05 pm