JuelichHtmlFunctions.php

gehe zur Dokumentation dieser Datei

<?php
class JuelichHtmlFunctions {

  function getSelect( $name, &$sql, $selected, $default ) {
    $select = "<select name=\"" . $name . "\" size=\"1\">\n";
    $select .= $this->makeGroup( $sql, $selected, $default );
    $select .= "</select>";
    return $select;
  }


  function getRadio( $ident, $name, $checked = 1 ) {
    if( $ident == "l10n" ) {
      $radios = array( "Sprachunabhängig", "Deutsch", "Französisch", "Englisch");
    }
    else if( $ident == "modus" ) {
      $radios = array("Spezial", "Text", "Modelle",
                      "Include", "Detail2", "Liste");
    }
    else if( $ident == "janein" ) {
      $radios = array("Nein", "Ja" );
    }
    else if( $ident == "glaskunst" ) {
      $radios = array("Glas", "Kunstoff" );
    }
    else if( $ident == "material" ) {
      $radios = array("Leichtmetall", "Karbon", "Holz", "Stahl" );
    }
    else if( $ident == "globuskugel" ) {
      $radios = array("Acryl", "Kristallglas" );
    }
    else if( $ident == "bereich" ) {
      $radios = array( "Mikroskop / Lupe ", "Fernoptik", "Teleskop",
                       "Optik-Marken", "Service", "EDV" ); 
    }
    else {
      return "";
    }
    return $this->makeRadio( $name, $radios, $checked );
  }

  
  function makeRadio( $name, &$values, $checked ) {
    $size = sizeof($values);
    $content = "";
    for( $i = 0; $i < $size; ++$i ) {
      $content .= "<input type=\"radio\" name=\"" . $name
        . "\" value=\"" . $i . "\"";
      if( $i == $checked ) {
        $content .= "checked";
      }
      $content .= ">" . $values[$i] . "&nbsp;\n";
    }
    return $content;
  }


  function makeGroup( $sql, $sel, $default ) {
    $selected = false;
    $content = "";
    $result = "";
    require_once( getIncludePath("db/DbMysql.php") );
    $db = new DbMysql;
    $rows = $db->queryDb($result, $sql );
    if ( $rows > 0 ) {
      while( $row = mysql_fetch_row($result) ) {
        $content .= "<option value=\"" . $row[0] . "\"";
        if( $row[0] == $sel && !$selected ) {
          $content .= " selected";
          $selected = true;
        }
        $content .= ">" . $row[1] . "</option>\n";
      }
    }
    if( !$selected ) {
      $content .= "<option value=\"0\" selected>$default</option>\n";
    }
    else {
      $content .= "<option value=\"0\">$default</option>\n";
    }
    return $content;
  }

  
  function checkCheckBox( $check ) {
    if( $check == "on" ) {
      return 1;
    }
    return 0;
  }


  function getOptionGroup( $mode, $gruppe_id = 0, $sel = 0 ) {
    require_once( getIncludePath("constants.php") );
    require_once( getIncludePath("db/DbMysql.php") );
    $db     = new DbMysql;

    $content        = "";
    $default_string = "";
    $sql            = ""; 

    switch( $mode ) {
    case EINLIEFERER:
      $sql = "SELECT sonderposten_einlieferer_id, se_name"
        . " FROM sonderposten_einlieferer ORDER BY se_name";
      $default_string = "Einlieferer";
      break;
    case HERSTELLER:
      if( $gruppe_id == 0 ) {
        $sql = "SELECT hersteller_id, h_name FROM hersteller "
          . "ORDER BY h_name";
      }
      else {
        $sql = "SELECT DISTINCT hersteller.hersteller_id, h_name "
          . "FROM hersteller, produkt "
          . "WHERE hersteller.hersteller_id=produkt.hersteller_id "
          . "AND produkt.gruppe_id=" . $gruppe_id
          . " ORDER BY h_name";
      }
      $default_string = "Hersteller";
      break;
    case MODELLE:
      $sql = "SELECT modell.modell_id, m_name "
        . "FROM modell_l10n, modell "
        . "WHERE modell.modell_id=modell_l10n.modell_id "
        . "AND modell_l10n.l10n_id=" . DEUTSCH_ID
        . " AND modell.gruppe_id=" . $gruppe_id
        . " ORDER BY m_name";
      $default_string = "Modelle";
      break;
    case GRUPPE:
      $sql = "SELECT gruppe_id, g_name FROM gruppe "
        . "WHERE gruppe_id !=" . SONDERPOSTEN_ID
        . " AND gruppe_id !=" . SPEKTIV_OKULAR_ID
        . " ORDER BY g_name";
      $default_string = "Gruppe";
      break;
    case GRUPPE_DK1:
      $sql = "SELECT gruppe.gruppe_id, g_name "
        . "FROM gruppe LEFT JOIN detail_kopf "
        . "ON gruppe.gruppe_id=detail_kopf.gruppe_id "
        . "WHERE detail_kopf.gruppe_id IS NULL "
        . " ORDER BY g_name";
      $default_string = "Gruppe";
      break;
    case GRUPPE_DK2:
      $sql = "SELECT DISTINCT gruppe.gruppe_id, g_name "
        . "FROM gruppe, detail_kopf "
        . "WHERE gruppe.gruppe_id = detail_kopf.gruppe_id "
        . "AND detail_kopf.l10n_id=" . DEUTSCH_ID
        . " ORDER BY g_name";
      $default_string = "Gruppe";
      break;
    }
  
    $selected = false;

    $result = "";
    $rows = $db->queryDb( $result, $sql );
    if ( $rows > 0 ) {
      while( $row = mysql_fetch_row($result) ) {
        $content .= "<option value=\"" . $row[0] . "\"";
        if( $row[0] == $sel && !$selected ) {
          $content .= " selected";
          $selected = true;
        }
        $content .= ">" . $row[1] . "</option>\n";
      }
    }
    
    if( !$selected ) {
      $content .= "<option selected>$default_string</option>\n";
    }
    
    return $content;
  }


}

?>

---