header("Progma:no-cache");
header("Cache-Control: no-cache, must-revalidate");
header("Content-Type: text/xml; charset=utf-8");
$Dir="../";
include_once($Dir."lib/init.php");
include_once($Dir."lib/lib.php");
include_once($Dir."lib/shopdata.php");
$imagepath=$Dir.DataDir."shopimages/multi/";
$productcode=$_GET["productcode"];
$errmsg="";
if(strlen($productcode)==18) {
$codeA=substr($productcode,0,3);
$codeB=substr($productcode,3,3);
$codeC=substr($productcode,6,3);
$codeD=substr($productcode,9,3);
$sql = "SELECT * FROM tblproductcode WHERE codeA='".$codeA."' AND codeB='".$codeB."' AND codeC='".$codeC."' AND codeD='".$codeD."' ";
$result=mysql_query($sql,get_db_conn());
if($row=mysql_fetch_object($result)) {
$_cdata=$row;
if($row->group_code=="NO") { //숨김 분류
$errmsg="판매가 종료된 상품입니다.";
} else if($row->group_code=="ALL" && strlen($_ShopInfo->getMemid())==0) { //회원만 접근가능
$errmsg="회원전용 상품입니다.\\n\\n로그인 후 이용하시기 바랍니다.";
} else if(strlen($row->group_code)>0 && $row->group_code!="ALL" && $row->group_code!=$_ShopInfo->getMemgroup()) { //그룹회원만 접근
$errmsg="해당 분류의 접근 권한이 없습니다.";
}
$sql = productQuery ();
//소셜
if(eregi("S",$_cdata->type)) {
$sql = "SELECT a.*, c.* ";
$sql.= "FROM tblproduct AS a ";
$sql.= "LEFT OUTER JOIN tblproductgroupcode b ON a.productcode=b.productcode ";
$sql.= "LEFT OUTER JOIN tblproduct_social c ON a.productcode=c.pcode ";
}
$sql.= "WHERE a.productcode='".$productcode."' AND a.display='Y' ";
$sql.= "AND (a.group_check='N' OR b.group_code LIKE '%".$_ShopInfo->getMemgroup()."%') ";
$result=mysql_query($sql,get_db_conn());
if($row=mysql_fetch_object($result)) {
$_pdata=$row;
} else {
$errmsg="해당 상품 정보가 존재하지 않습니다.";
}
mysql_free_result($result);
} else {
$errmsg="해당 분류가 존재하지 않습니다.";
}
} else {
$errmsg="해당 상품이 존재하지 않습니다.";
}
#####################상품별 회원할인율 적용 시작#######################################
// 도매 가격 적용 상품 아이콘
$wholeSaleIcon = ( $_pdata->isdiscountprice == 1 ) ? $wholeSaleIconSet:"";
$memberpriceValue = $_pdata->sellprice;
$strikeStart = $strikeEnd = $memberprice = '';
if($_pdata->discountprices>0){
$memberprice = number_format($_pdata->sellprice - $_pdata->discountprices);
$strikeStart = "";
$strikeEnd = " ▶ ".$memberprice;
$memberpriceValue = ($_pdata->sellprice - $_pdata->discountprices);
}
#####################상품별 회원할인율 적용 끝 #######################################
if(strlen($errmsg)>0) {
echo ""; exit;
}
$multi_img="N";
$maxsize=220;
$sql = "SELECT * FROM tblmultiimages WHERE productcode='".$productcode."' ";
$result=mysql_query($sql,get_db_conn());
if($row=mysql_fetch_object($result)) {
$multi_img="Y";
$multi_imgs=array(&$row->primg01,&$row->primg02,&$row->primg03,&$row->primg04,&$row->primg05,&$row->primg06,&$row->primg07,&$row->primg08,&$row->primg09,&$row->primg10);
$tmpsize=explode("",$row->size);
$y=0;
for($i=0;$i<10;$i++) {
if(strlen($multi_imgs[$i])>0) {
$yesimage[$y]=$multi_imgs[$i];
if(strlen($tmpsize[$i])==0) {
$size=getimagesize($imagepath.$multi_imgs[$i]);
$xsize[$y]=$size[0];
$ysize[$y]=$size[1];
} else {
$tmp=explode("X",$tmpsize[$i]);
$xsize[$y]=$tmp[0];
$ysize[$y]=$tmp[1];
}
$y++;
}
}
$makesize=$maxsize;
for($i=0;$i<$y;$i++){
if($xsize[$i]>$makesize || $ysize[$i]>$makesize) {
if($xsize[$i]>=$ysize[$i]) {
$tempxsize=$makesize;
$tempysize=($ysize[$i]*$makesize)/$xsize[$i];
} else {
$tempxsize=($xsize[$i]*$makesize)/$ysize[$i];
$tempysize=$makesize;
}
$xsize[$i]=$tempxsize;
$ysize[$i]=$tempysize;
}
}
mysql_free_result($result);
}
$sql = "SELECT COUNT(*) as t_count, SUM(marks) as totmarks FROM tblproductreview ";
$sql.= "WHERE productcode='".$productcode."' ";
if($_data->review_type=="A") $sql.= "AND display='Y' ";
$result=mysql_query($sql,get_db_conn());
$row=mysql_fetch_object($result);
$review_tcount = (int)$row->t_count;
$review_totmarks = (int)$row->totmarks;
$review_marks=@ceil($review_totmarks/$review_tcount);
mysql_free_result($result);
$review_aver=@(int)(($review_totmarks/$review_tcount)*20);
?>
|
|
addcode)>0) echo "[".$_pdata->addcode."] ";
echo " ".viewproductname($_pdata->productname,$_pdata->etctype,$_pdata->selfcode)."";?>
|
|
|
|
|
|
if($multi_img=="Y") {
echo "";
} else {
if(strlen($_pdata->minimage)>0 && file_exists($Dir.DataDir."shopimages/product/".$_pdata->minimage)) {
$width=GetImageSize($Dir.DataDir."shopimages/product/".$_pdata->minimage);
if($width[0]>=220) $width[0]=220;
else if (strlen($width[0])==0) $width[0]=220;
echo "minimage."\" border=0 width=".$width[0].">";
} else {
echo "";
}
}
?> |
if($multi_img=="Y") {
echo " | \n";
echo "\n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
echo "";
}
?>
|
|
if($_pdata->consumerprice>0) { //소비자가
echo "\n";
echo " 소비자가 | \n";
echo " ".number_format($_pdata->consumerprice)."원";
echo " | \n";
echo " \n";
}
echo " \n";
echo " 판매가격 | \n";
echo " ";
echo $strikeStart;
if($dicker=dickerview($_pdata->etctype,number_format($memberpriceValue)."원",1)) {
echo $dicker;
} else if(strlen($_data->proption_price)==0) {
echo "".$wholeSaleIcon.number_format($memberpriceValue)."원";
if (strlen($_pdata->option_price)!=0) echo " (기본가)";
} else {
echo "";
if (strlen($_pdata->optionprice)==0) echo number_format($memberpriceValue)."원";
else echo ereg_replace("\[PRICE\]",number_format($memberpriceValue),$_data->proption_price);
}
echo $strikeEnd;
if ($_pdata->quantity=="0") echo soldout();
echo " | \n";
echo " \n";
$reserveconv=getReserveConversion($_pdata->reserve,$_pdata->reservetype,$memberpriceValue,"Y");
if($reserveconv>0) { //적립금
echo "\n";
echo " 적립금 | \n";
echo " ".number_format($reserveconv)."원";
echo " | \n";
echo " \n";
}
if($_data->ETCTYPE["TAGTYPE"]!="N") {
if(strlen($_pdata->tag)>0) {
echo "\n";
echo " \n";
echo " \n";
echo " \n";
$arrtaglist=explode(",",$_pdata->tag);
$jj=0;
for($i=0;$i )","",$arrtaglist[$i]);
if(strlen($arrtaglist[$i])>0) {
if($jj>0) echo ", ";
echo "".$arrtaglist[$i]."";
$jj++;
}
}
echo " \n";
echo " | \n";
echo " \n";
echo " | \n";
}
}
?>
|
|
|
|
|
|
상품평 |
if($review_tcount==0) {
echo "등록된 상품평이 없습니다.";
} else {
for($i=0;$i<$review_marks;$i++) echo "★";
for($i=$review_marks;$i<5;$i++) echo "★";
echo " 평점 ".$review_aver."점";
}
?>
|
|
|
|
|
|
|
$sql = "SELECT * FROM tblproductreview WHERE productcode='".$productcode."' ";
if($_data->review_type=="A") $sql.= "AND display='Y' ";
$sql.= "ORDER BY num DESC LIMIT 5 ";
$result=mysql_query($sql,get_db_conn());
$cnt=0;
while($row=mysql_fetch_object($result)) {
$content=explode("=",$row->content);
echo "";
echo " ";
echo " [";
for($i=0;$i<$row->marks;$i++) {
echo "★";
}
for($i=$row->marks;$i<5;$i++) {
echo "★";
}
echo "] ";
echo titleCut(30,strip_tags($content[0]));
echo "
\n";
echo " \n";
echo " \n";
echo " ".nl2br(strip_tags($content[0]))." | \n";
echo " ";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
$cnt++;
}
mysql_free_result($result);
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|