{if $base.ShopName eq $base.FirmName}{$base.ShopName}{else}{$base.ShopName} {$base.FirmName}{/if} {$set.keyword}

{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 .= '

'.$v[cat_name].'

'; 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 = '

'.$t[cat_name].'

'; $contenall .= $tontstl; } echo $contenall; {/php}

{php}navname('productshow'){/php}

{php} $size = 12; $page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1; if(!empty($_GET['classid'])){ $where = " AND ClassID = '".intval($_GET['classid'])."' "; $classidsql = "&classid=".$_GET['classid'] ; } if(!empty($_GET['keyword'])){ $where = " AND Name like '%".trim($_GET['keyword'])."%' "; $classidsql = "&keyword=".$_GET['keyword'] ; } if($GLOBALS['lang'] == 'zh'){ $sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }elseif($GLOBALS['lang'] == 'tw'){ $sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }else{ $sql = "SELECT COUNT(*) FROM ".$GLOBALS['eces']->table('firm_products_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; } $record_count = $GLOBALS['dbes']->getOne($sql); $start = ($page-1)*$size; $pages = ceil($record_count/$size); $pageq = $page-1; $pagel = $page+1; if($pageq < '1'){ $pageq = '1'; } if($pagel>$pages){ $pagel=$pages; } $limit = "LIMIT $start,$size "; for($i=1;$i<=$pages;$i++){ if($i==$page){$selected="selected";}else{$selected="";} $option .=""; } $pagesstr = "

第".$page."页/共".$pages."页第一页上一页下一页最后页跳到页

"; if($GLOBALS['lang'] == 'zh'){ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }elseif($GLOBALS['lang'] == 'tw'){ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; }else{ $sql = "SELECT * FROM ".$GLOBALS['eces']->table('firm_products_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' $where "; } $sql .= "ORDER BY `addTime` DESC ".$limit ; $RS = $GLOBALS['dbes']->getAll($sql); foreach($RS AS $v){ if($GLOBALS['lang'] == 'zh'){ $cat_name = $GLOBALS['dbes']->getRow("SELECT cat_id,parent_id,cat_name FROM ".$GLOBALS['eces']->table('category_zh')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND cat_id = '".$v[ClassID]."' "); }elseif($GLOBALS['lang'] == 'tw'){ $cat_name = $GLOBALS['dbes']->getRow("SELECT cat_id,parent_id,cat_name FROM ".$GLOBALS['eces']->table('category_tw')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND cat_id = '".$v[ClassID]."' "); }else{ $cat_name = $GLOBALS['dbes']->getRow("SELECT cat_id,parent_id,cat_name FROM ".$GLOBALS['eces']->table('category_en')." WHERE FirmID = '". $GLOBALS['FrimID']."' AND cat_id = '".$v[ClassID]."' "); } if(!empty($v[PicPath])){ $picimg = $v[PicPath] ; }else{ $picimg = $GLOBALS['tpl']['img']."imgjs/erreso.gif"; } $contenet .= '

: '.$v[Name].' '.$cat_name['cat_name'].'

'; } echo $contenet; {/php}

{php} echo $pagesstr; {/php}