path: root/packages/index.php

<?php
require_once "../init.php";

require_once BASE . "/lib/mysql.php";
require_once BASE . "/lib/style.php";
require_once BASE . "/lib/format.php";


  foreach (array("bugs","sort","del","uses_upstream","uses_modification") as $expected_param)
    if (! array_key_exists($expected_param, $_GET))
      $_GET[$expected_param] = "";

  $multi_select_search_criteria = array(
    "arch" => array(
      "name" => "arch",
      "title" => "CPU architecture",
      "label" => "Arch",
      "table" => "architectures",
      "column" => "`architectures`.`name`",
      "extra_condition" => "",
      "values" => array()
    ),
    "repo" => array(
      "name" => "repo",
      "title" => "respository",
      "label" => "Repository",
      "table" => "repositories",
      "column" => "CONCAT(`architectures`.`name`,\"/\",`repositories`.`name`)",
      "extra_condition" => mysql_join_repositories_architectures() . " WHERE `repositories`.`is_on_master_mirror`",
      "values" => array()
    )
  );

  foreach ( $multi_select_search_criteria as $criterium => $content ) {
    $result = mysql_run_query(
      "SELECT " . $content["column"] . " AS `name` FROM `" . $content["table"] . "`" . $content["extra_condition"] . " ORDER BY `name`"
    );
    while ($row = $result -> fetch_assoc())
      $multi_select_search_criteria[$criterium]["values"][] = $row["name"];
  }

  $float_columns = array(
    "has_issues",
    "is_to_be_deleted"
  );

  $filter = " WHERE 1";
  foreach ($multi_select_search_criteria as $criterium)
    if (isset($_GET[$criterium["name"]])) {
      $filter .= " AND " . $criterium["column"] . " IN (";
      foreach ($criterium["values"] as $value)
        if (strpos("&" . urldecode($_SERVER["QUERY_STRING"]) . "&", "&" . $criterium["name"] . "=" . $value . "&") !== false)
          $filter .= "\"" . $value . "\",";
      $filter .= "\"\")";
    }

  $single_select_search_criteria = array(
    "bugs" => array(
      "name" => "bugs",
      "label" => "Bugs",
      "title" => "bug-tracker status",
      "options" => array(
        "All" => "1",
        "Bugs" => "`binary_packages`.`has_issues`",
        "No Bugs" => "NOT `binary_packages`.`has_issues`"
      )
    ),
    "del" => array(
      "name" => "del",
      "label" => "To Be Deleted",
      "title" => "to-be-deleted status",
      "options" => array(
        "All" => "1",
        "To Be Deleted" => "`binary_packages_in_repositories`.`is_to_be_deleted`",
        "Not To Be Deleted" => "NOT `binary_packages_in_repositories`.`is_to_be_deleted`"
      )
    ),
    "uses_upstream" => array(
      "name" => "uses_upstream",
      "label" => "Upstream",
      "title" => "wether upstream source exists",
      "options" => array(
        "All" => "1",
        "Uses Upstream" => "`package_sources`.`uses_upstream`",
        "Does Not Use Upstream" => "NOT `package_sources`.`uses_upstream`"
      )
    ),
    "uses_modification" => array(
      "name" => "uses_modification",
      "label" => "Modification",
      "title" => "wether modification exists",
      "options" => array(
        "All" => "1",
        "Uses Modification" => "`package_sources`.`uses_modification`",
        "Does Not Use Modification" => "NOT `package_sources`.`uses_modification`"
      )
    )
  );

  foreach ($single_select_search_criteria as $criterium)
    if (isset($_GET[$criterium["name"]]) &&
      isset($criterium["options"][$_GET[$criterium["name"]]]))
      $filter .= " AND " . $criterium["options"][$_GET[$criterium["name"]]];

  if (array_key_exists("q", $_GET)) {
    $extra_joins = "";
    $exact_filter = " AND `binary_packages`.`pkgname` = from_base64(\"".base64_encode($_GET["q"])."\")";
    $fuzzy_filter = " AND `binary_packages`.`pkgname` LIKE from_base64(\"".base64_encode("%".$_GET["q"]."%")."\")";
  } elseif (array_key_exists("g", $_GET) && array_key_exists("ra", $_GET)) {
    $extra_joins =
      mysql_join_binary_packages_install_target_providers() .
      mysql_join_install_target_providers_install_targets();
    $fuzzy_filter =
      " AND `install_targets`.`name`=from_base64(\"" . base64_encode($_GET["g"]) . "\")" .
      " AND `r_a`.`name`=from_base64(\"" . base64_encode($_GET["ra"]) . "\")";
    $exact_filter = " AND 0";
  } else {
    $extra_joins = "";
    $exact_filter = " AND 0";
    $fuzzy_filter = "";
  }

  $exact_matches = query_package_listing(
    $extra_joins .
    $filter . $exact_filter,
    '',
    $float_columns,
    false,
    false
  );


  $num_results = query_package_listing(
    $extra_joins . $filter . $fuzzy_filter,
    '',
    array(),
    true,
    true
  );

  $pages = max(ceil($num_results / 100), 1);
  if (array_key_exists("page", $_GET))
    $page = max(min($_GET["page"]+0, $pages),1);
  else
    $page = 1;

  $fuzzy_matches = query_package_listing(
    $extra_joins . $filter . $fuzzy_filter,
    " LIMIT " . (($page-1)*100) . ", 100",
    $float_columns,
    false,
    true
  );

  function header_and_footer() {

    global $page, $pages, $num_results;

    print "        <div class=\"pkglist-stats\">\n";
    print "          <p>\n";
    print "            " . $num_results . " matching package";
    if ($num_results != 1)
      print "s";
    print " found.\n";

    if ($pages != 1)
      print "            Page " . $page . " of " . $pages . ".\n";

    print "          </p>\n";

    if ($pages != 1) {
      print "          <div class=\"pkglist-nav\">\n";
      print "            <span class=\"prev\">\n";

      print "              ";
      if ($page > 1) {
        print "<a href=\"?";
        print substr(str_replace(
          "&page=".$page."&",
          "&",
          "&".$_SERVER["QUERY_STRING"]."&"
        ),1)."page=".($page-1);
        print "\" title=\"Go to previous page\">";
      };
      print "&lt; Prev";
      if ($page > 1)
        print "</a>";
      print "\n";
      print "            </span>\n";
      print "            <span class=\"next\">\n";

      print "              ";
      if ($page < $pages) {
        print "<a href=\"?";
        print substr(str_replace(
          "&page=".$page."&",
          "&",
          "&".$_SERVER["QUERY_STRING"]."&"
        ),1)."page=".($page+1);
        print "\" title=\"Go to next page\">";
      };
      print "Next &gt;";
      if ($page < $pages)
        print "</a>";
      print "\n";
      print "            </span>\n";
      print "          </div>\n";
    };
    print "        </div>\n";

  };

  if (array_key_exists("exact", $_GET)) {
    export_as_requested(
      array(
        "All" => $exact_matches
      )
    );
    die();
  };

  if (array_key_exists("fuzzy", $_GET)) {
    export_as_requested(
      array(
        "All" => $fuzzy_matches
      )
    );
    die();
  };

  print_header("Package Search");

?>
      <div id="pkglist-search" class="box filter-criteria">
        <h2>Package Search</h2>
        <form id="pkg-search" method="get" action="/packages/">
          <p><input id="id_sort" name="sort" type="hidden" /></p>
          <fieldset>
            <legend>Enter search criteria</legend>
<?php
  foreach ($multi_select_search_criteria as $criterium) {
    print "            <div>\n";
    print "              <label for=\"id_" . $criterium["name"] . "\" title=\"Limit results to a specific " . $criterium["title"] . "\">";
    print $criterium["label"];
    print "</label>\n";
    print "              <select multiple=\"multiple\" id=\"id_" . $criterium["name"] . "\" name=\"" . $criterium["name"] . "\">\n";
    foreach ($criterium["values"] as $value) {
      print "                <option value=\"" . $value . "\"";
      if (strpos( "&" . urldecode($_SERVER["QUERY_STRING"]) . "&", "&" . $criterium["name"] . "=" . $value . "&") !== false)
        print " selected=\"selected\"";
      print ">" . $value . "</option>\n";
    }
    print "              </select>\n";
    print "            </div>\n";
  }
?>
            <div>
              <label for="id_q" title="Enter keywords as desired">Keywords</label>
              <input id="id_q" name="q" size="30" type="text" <?php
if (array_key_exists("q", $_GET))
  print "value=\"".$_GET["q"]."\"";
?>/>
            </div>
<?php
  foreach ($single_select_search_criteria as $criterium) {

    print "            <div>\n";
    print "              <label for=\"id_";
    print $criterium["name"];
    print "\" title=\"Limit results based on ";
    print $criterium["title"];
    print "\">";
    print $criterium["label"];
    print "</label><select id=\"id_";
    print $criterium["name"];
    print "\" name=\"";
    print $criterium["name"];
    print "\">\n";

    foreach ($criterium["options"] as $label => $option) {
      print "                <option value=\"";
      if ($label != "All")
        print $label;
      print "\"";
      if ($_GET[$criterium["name"]]==$label)
        print " selected=\"selected\"";
      print ">" . $label . "</option>\n";
    }
    print "              </select>\n";
    print "            </div>\n";
  }
?>
            <div>
              <label>&nbsp;</label>
              <input title="Search for packages using this criteria" type="submit" value="Search">
            </div>
          </fieldset>
        </form>
      </div>
<?php

if (count($exact_matches) > 0) {
?>
      <div id="exact-matches" class="box">
        <div class="pkglist-stats">
          <p><?php print count($exact_matches); ?> exact match<?php if (count($exact_matches) != 1) print "es"; ?> found.</p>
        </div>
<?php
  print_listing($exact_matches, false, $pkglist_sorts);
?>
      </div>
<?php
}

?>
      <div id="pkglist-results" class="box">
<?php

  header_and_footer();

  print_listing($fuzzy_matches, true, $pkglist_sorts);

  header_and_footer();

?>
      </div>
      <div id="pkglist-about" class="box">
        <p>
          Can't find what you are looking for? Try searching again
          using different criteria, or try
          searching the <a href="https://aur.archlinux.org/">AUR</a>
          to see if the package can be found there.
        </p>
        <p>
          You are browsing the Arch Linux 32 package database. From here you can find
          detailed information about packages located in the 32 bit repositories.
        </p>
      </div>
<?php

  print_footer();