$this->HTML_Menu_browser($DSN, $table, $query); } function makeURL($eintrag) { $url = url(array('module' => 'product', 'action' => 'overview', 'id' => $eintrag['id'])); return $url; } } $browser = new HTML_menu_browser_company($cfg['database']['dsn']); $browser->setQuery("SELECT *, rc_produktkat.id as id, count(rc_produkt.id) as numchildren\n FROM rc_produktkat LEFT JOIN rc_produkt ON (rc_produkt.id_produktkat=rc_produktkat.id)\n GROUP BY rc_produktkat.id ORDER BY rc_produktkat.name_" . LC_LANG); $browser->lang = LC_LANG; $m = $browser->getMenu(); $table['product'] = $cfg['table']['product']; $table['cat_product'] = $cfg['table']['cat_product']; if (!$id) { $id = 0; } require_once 'mms_tablepager.php'; $tabpage = new PageTable($cfg['database']['dsn'], "overview"); $tabpage->make_url = false; $tabpage->fields = array('name'); $tabpage->col_view = 'name'; $tabpage->url_view = url(array('module' => 'product', 'action' => 'details')); $tabpage->add_extra = false; $query = "select name_" . LC_LANG . " from {$table['cat_product']} where id = {$id} ORDER BY name_" . LC_LANG; $str_category = $db_con->getOne($query); $query = "select* from {$table['product']}\n where id_produktkat={$id} order by name asc"; $prod_menu = new mms_template_Menu($m, 'yahoo', "REQUEST_URI"); $prod_menu->keepEmpty = false; $prod_menu->shownumchildren = true; $content['CONTENT'] .= "<h1>" . $str_category . "</h1>" . $prod_menu->get('urhere') . '<br>' . $prod_menu->get('yahoo') . '<br><hr>' . $tabpage->get($query, $from, 'overview');
class HTML_menu_browser_company extends HTML_menu_browser { function HTML_menu_browser_company($DSN = '', $table = '', $query = "") { $this->HTML_Menu_browser($DSN, $table, $query); } function makeURL($eintrag) { $url = url(array('module' => 'infolinks', 'action' => 'overview', 'id' => $eintrag['id'])); return $url; } } $browser = new HTML_menu_browser_company($cfg['database']['dsn']); $browser->setQuery("SELECT *, rc_infolinkkat.id as id, count(rc_firma_produktkat.id_firma) as numchildren\nFROM rc_infolinkkat LEFT JOIN rc_firma_produktkat ON (rc_firma_produktkat.id_produktkat=rc_infolinkkat.id)\nGROUP BY rc_infolinkkat.id"); $m = $browser->getMenu(); $table['infolinks'] = $cfg['table']['infolinks']; $table['firma'] = $cfg['table']['company']; $table['firma_produktkat'] = $cfg['table']['company_cat_product']; if (!$id) { $id = 0; } require_once 'mms_tablepager.php'; $tabpage = new PageTable($cfg['database']['dsn'], "overview"); $tabpage->fields = array('name'); $tabpage->url_view = url(array('module' => 'infolinks', 'action' => 'details')); $query = "select*, {$table['firma']}.name as name from {$table['firma_produktkat']},{$table['firma']}\n where {$table['firma_produktkat']}.id_produktkat={$id}\n and {$table['firma_produktkat']}.id_firma = {$table['firma']}.id order by land asc"; $cmp_menu = new mms_template_Menu($m, 'tree', "REQUEST_URI"); $cmp_menu->keepEmpty = false; $cmp_menu->shownumchildren = true; $content['CONTENT'] .= '<h1>' . $cmp_menu->get('urhere') . '</h1>' . '<br>' . $cmp_menu->get('tree') . '<br>' . $tabpage->get($query, $from, 'overview'); //$nav->setMenu($cmp_menu->get('tree'));