JuelichPageList.php

gehe zur Dokumentation dieser Datei

<?php
require_once TM_PATH . 'juelich/JuelichGlobals.php';
require_once TM_PATH . 'juelich/lib/JuelichFunction.php';

class JuelichPageList {

  function getPageContent() {
    $data      =& getDataInstance();
    $db        =& getDbReaderInstance();
    $func      = new JuelichFunction;
    $l10n      = $data->getAppData('l10n');
    $mod       = $data->getAppData('module');

    $sortField = $mod->list['sortDefault'];
    if ($data->existsFormvar('sort')) {
      $sortField = $data->getFormVar('sort');
    }
    
    $modName = $mod->baseName[1];
    $start   = $db->getTemplateContent($modName . "-list-start", $l10n);
    $sort    = $mod->list['sort'];
    $pattern = '/(id="head-%s".*?>)(.*?)(<\/td>)/s';
    foreach (array_keys($sort) as $key) {
      if ($key != $sortField) {
        $pat = sprintf($pattern, $key);
        if (preg_match($pat, $start, $match) == 1) {
          $replace = $match[1] 
            . "\n"
            . "<a href=\"?sort=$key\">"
            . ltrim(chop($match[2]))
            . "</a>"
            . "\n"
            . $match[3];
          $start = preg_replace($pat, $replace, $start);
        }
      }
    }

    $sqlPrep = "SELECT h_name, m_name, p_name, "
      . "produkt.produkt_id, p_preis, %s "
      . "FROM produkt "
      . "LEFT JOIN produkt_l10n USING(produkt_id) "
      . "LEFT JOIN %s USING(produkt_id) "
      . "LEFT JOIN hersteller "
      . "ON produkt.hersteller_id=hersteller.hersteller_id "
      . "LEFT JOIN modell_l10n "
      . "ON produkt.modell_id=modell_l10n.modell_id "
      . "WHERE gruppe_id = %d "
      . "AND produkt_l10n.l10n_id = %d "
      . "AND modell_l10n.l10n_id = %d "
      . "%s " # Weitere Einschränkungen
      . "ORDER BY %s";
    $sql = sprintf($sqlPrep,
                   $mod->list['dataFields'],
                   $mod->table,
                   $mod->gruppe_id,
                   $l10n,
                   $l10n,
                   $mod->list['sqlAnd'],
                   $sort[$sortField]
                   );

    $content   = $start;
    $colorFlag = false;
    $rowColor  = $mod->list['rowColor'];
    $listData  = $mod->listData;
    $tplRow    = $db->getTemplateContent($modName . '-list-row', 0);

    $rows = array();
    $db->getAllRows($sql, $rows);
    foreach ($rows as $row) {
      $rowOutput = array();
      if ($rowColor) {
        if ($colorFlag) {
          array_push($rowOutput, ' bgcolor="#d0ffd0"');
          $colorFlag = false;
        }
        else {
          array_push($rowOutput, '');
          $colorFlag = true;
        }
      }
      foreach ($listData as $l) {
        $v = array();
        $tmp = explode(',', str_replace(' ', '', $l[0]));
        foreach ($tmp as $field) {
          array_push($v, $row[$field]);
        }
        $para = "";
        if (count($l) > 3) {
          $para = $l[3];
        }
        $value = $func->getValue($l[2], $v, $para);
        if (empty($value)) {
          $value = '&nbsp;';
        }
        else {
          $s = substr($value, strlen($value) - 1);
          if (is_numeric($s)) {
            $value .= $l[1];
          }
        }
        array_push($rowOutput, $value);
      }
      $content .= vsprintf($tplRow, $rowOutput) . $mod->list['rowDivider'];
    }
    $content .= $db->getTemplateContent($modName . "-list-end", $l10n);
    return $content;
  }

}

?>

---