18) $sqls .= " and ( cate = $cate || cate2_seq = $cate || cate3_seq = $cate ) ";
//if($cate == 18) $sqls .= " and (select count(*) from menu_template_tbl where seqnum = a.template_seq and is_group = '1' ) > 0 ";
if($cate != '') $sqls .= " and ( cate_seq = $cate || cate2_seq = $cate || cate3_seq = $cate ) ";
if($bind != '') $sqls .= " and bind_type = '$bind' ";
if($cover != '') $sqls .= " and cover_type = '$cover' ";
if($card != '') $sqls .= " and card_type = '$card' ";
if($product == 9) { $sqls .= " and page_type = 'W' "; }
if($product == 19) { $sqls .= " and frame_color = 'B' "; }
if($product == 49) { $sqls .= " and page_type = 'line' "; }
if($mcode == 'book') { $sqls .= " and (select is_use from menu_template_tbl where seqnum = a.template_seq) = '1' "; }
$page_set = 51;
if ($page < 1) $page = 1;
$sql = "
select
*,
(select size_ratio from menu_size_tbl where seqnum = a.size_seq) as size_ratio,
(select is_icon from menu_template_tbl where seqnum = a.template_seq) as is_icon,
(select icon_img from menu_template_tbl where seqnum = a.template_seq) as icon_img_src
from
goods_tbl a
where
is_use = '1' and product_seq = 75
and
size_seq = 4 and cover_type = 'hard'
order by
(case when template_seq = 0 then sort when (menu_code = 'calendar' && product_seq <> 13) then sort else (select sort from menu_template_tbl where seqnum = a.template_seq) end ), goods_nm
";
$rst = mysql_query($sql);
$total = mysql_num_rows($rst);
for($i=0; $i < ( $page-1 ) * $page_set; $i++)
{
$icount --;
if(!$goods = mysql_fetch_array($rst)) break;
}
for($i=0; $i < $page_set; $i++)
{
if(!$goods = mysql_fetch_array($rst)) break;
$goods_img = goodsImg($goods['menu_code'], $goods['product_seq'], $goods['template_seq'], $goods['seqnum'], $goods['ps_code'], $goods['size_ratio'], $goods['frame_color'], $goods['card_type'], $item_width, $padding_ratio, '0', '1');
$sale_price = $goods['sale_price'];
$origin_price = $goods['origin_price'];
if($goods['product_seq'] == 43) //미니배너
{
$sale_price = $goods['sale_price'] + $goods['add_price'];
$origin_price = $goods['origin_price'] + $goods['add_price'];
}
?>
";
}
else if ($goods['product'] == 30 || $goods['product'] == 31 || $goods['product'] == 32)
{
echo "
";
}
else if($goods['product'] == 20 || $goods['product'] == 21)
{
echo "
";
}
else if($goods['product'] == 56)
{
echo "
";
}
else if($goods['product'] == 57)
{
echo "
";
}
else if($goods['is_icon'] == '1')
{
echo "
![](/img/".$goods[)
";
}
?>
0)
{
$param = "mcode=$mcode&product=$product&size=$size&cover=$cover&bind=$bind&cate=$cate";
include $DOCUMENT_ROOT."/include/paging.php";
}
?>
