$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'));
