{php}navname(productshow){/php}
{php}
if($GLOBALS['lang'] == 'zh'){
$sql = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_zh')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '0' ORDER BY `sort_order` ASC ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '0' ORDER BY `sort_order` ASC ";
}else{
$sql = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '0' ORDER BY `sort_order` ASC ";
}
$RS = $GLOBALS['dbes']->getAll($sql);
foreach($RS as $v){
if($v[cat_id] == $_GET['bc'] ){ $styel_pro1 = 'style="display: block;"'; }
$contenall .= '';
if($GLOBALS['lang'] == 'zh'){
$sql1 = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_zh')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '".$v[cat_id]."' ORDER BY `sort_order` ASC ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql1 = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '".$v[cat_id]."' ORDER BY `sort_order` ASC ";
}else{
$sql1 = "SELECT cat_id,cat_name,parent_id FROM ".$GLOBALS['eces']->table('category_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND parent_id = '".$v[cat_id]."' ORDER BY `sort_order` ASC ";
}
$TS = $GLOBALS['dbes']->getAll($sql1);
$tontstl = ' ';
$contenall .= $tontstl;
}
echo $contenall;
{/php}
{php}navname(productshow){/php}
- {$prodouts.Name}
{$prodouts.Description}
相关产品
{php}
if($GLOBALS['lang'] == 'zh'){
$sql = "SELECT ClassID FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND ProductID = '".$_GET['pid']."' AND BarCode = '".$_GET['BarCode']."' ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql = "SELECT ClassID FROM ".$GLOBALS['eces']->table('firm_products_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND ProductID = '".$_GET['pid']."' AND BarCode = '".$_GET['BarCode']."' ";
}else{
$sql = "SELECT ClassID FROM ".$GLOBALS['eces']->table('firm_products_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND ProductID = '".$_GET['pid']."' AND BarCode = '".$_GET['BarCode']."' ";
}
$RS_classid = $GLOBALS['dbes']->getOne($sql);
if($GLOBALS['lang'] == 'zh'){
$sql2 = "SELECT ProductID,BarCode,Name,PicPath FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND ClassID = '".$RS_classid."' ";
}elseif($GLOBALS['lang'] == 'tw'){
$sql2 = "SELECT ProductID,BarCode,Name,PicPath FROM ".$GLOBALS['eces']->table('firm_products_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND ClassID = '".$RS_classid."' ";
}else{
$sql2 = "SELECT ProductID,BarCode,Name,PicPath FROM ".$GLOBALS['eces']->table('firm_products_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND ClassID = '".$RS_classid."' ";
}
$RSS = $GLOBALS['dbes']->getAll($sql2);
foreach($RSS as $v){
$contiell .='';
}
echo $contiell;
{/php}