function getDetails($id, $tplname = 'details.tpl.html') { $this->tpl = new HTML_Template_IT($basedir); $this->tpl->loadTemplateFile($this->basedir . $tplname); $query = "select * from " . $this->cfg['table']['compound'] . " where id = {$id}"; $row = $this->db_con->getRow($query); $this->tpl->setVariable("HEADING", $row->{"name_" . LC_LANG}); $this->tpl->setVariable('LC_SPECIFICATIONS', $this->lang->translate('specifications')); $query = "select *,comp.id as mixid, comp.name_de as mischname_de,comp.name_en as mischname_en,cat_comp.name_de as mischkatname_de,cat_comp.name_en as mischkatname_en\n from " . $this->cfg['table']['cat_compound'] . ' as cat_comp, ' . $this->cfg['table']['compound'] . " as comp\n where comp.id_mischungkat=cat_comp.id AND comp.id={$id}"; $row = $this->db_con->getRow($query); include_once 'HTML/Table.php'; $tbl = new HTML_Table('class="overview"'); $tbl->addRow(array($this->lang->translate('name'), $row->{"mischname_" . LC_LANG})); $tbl->addRow(array($this->lang->translate('category'), $row->{"mischkatname_" . LC_LANG})); $tbl->addRow(array('M100', $row->m100)); $tbl->addRow(array('M300', $row->m300)); $tbl->addRow(array('TS', $row->ts)); $tbl->addRow(array('EAB', $row->eab)); $tbl->addRow(array('Rebound', $row->rebound)); $tbl->addRow(array('Shore A', $row->shore_a)); $tbl->addRow(array('SG', $row->sg)); $tbl->setColAttributes(0, 'width="100"'); $tbl->setColAttributes(1, 'width="300"'); $row1Style = array('class' => 'overview'); $row2Style = array('class' => 'overviewalternate'); $tbl->altRowAttributes(0, $row1Style, $row2Style); $this->tpl->setVariable("COMPOUND_DATA", $tbl->toHTML()); $tbl = new HTML_Table('class="overview"'); $tbl->addRow(array('Name', 'phr'), 'class="overview"', 'TH'); $query = "select * from " . $this->cfg['table']['details_compound'] . " where id_mischung={$id}"; $this->db_res = $this->db_con->Query($query); while ($row = $this->db_res->fetchrow(DB_FETCHMODE_OBJECT)) { if ($row->id_produkt) { $_url = '<a class="maroon" href="' . url(array('module' => 'product', 'action' => 'details', 'id' => $row->id_produkt)) . '">' . $row->name . '</a>'; } else { $_url = $row->name; } $tbl->addRow(array($_url, $row->phr)); } $query = "select sum(phr) as phrsum from " . $this->cfg['table']['details_compound'] . " where id_mischung={$id}"; $row = $this->db_con->getRow($query); $tbl->addRow(array('', $row->phrsum)); $tbl->updateColAttributes(1, 'align="right" "bgcolor=#eeeeee"'); $tbl->updateRowAttributes($tbl->getrowCount() - 1, "bgcolor=#CCCCCC"); $this->tpl->setVariable('TBL_DETAILS', $tbl->toHTML()); $this->tpl->setVariable("CATEGORY_COLOR", $this->color); return $this->tpl->get(); }