재팬엔조이를 더 안전하고 유익하게 이용하세요
dbSelect($_ORD_ITEM_REVIEW,"count(orv_key)","where orv_isshow='Y'");
$sumObj = $_jeDB->getFetchRows($sumSel);
$review_num = $sumObj[0];
# 베스트 후기
$search_ym = date("Ym",strtotime("-1 month")-86000);
$search_m = substr($search_ym,4,2);
$rvwSel = $_jeDB->j_dbSelect2($_ORD_ITEM_REVIEW,$_ORD_ITEM_REVIEW_ATTACH,
"a.orv_mem_id,a.orv_ord_pt,a.orv_ord_cd,a.orv_star,a.orv_review,b.*",
"on a.orv_key=b.ort_orv_key",
"where orv_best='{$search_m}' and from_unixtime(orv_reg_date,'%Y%m')='{$search_ym}' and orv_isshow='Y' order by orv_key desc limit 1");
$rvwNum = intval($_jeDB->getRows());
if(intval($rvwNum) > 0) {
$rvwObj = $_jeDB->getFetchAssoc($rvwSel);
while(list($key,$val) = each($rvwObj)) ${$key} = $val;
# 상품이미지
if($ort_file_name && $ort_file_path) {
$itm_img = "/gimg/{$ort_file_path}/{$ort_file_name}";
} else {
$_ORD_INFO = ($orv_ord_pt == "A") ? $_ORD_A_INFO : $_ORD_B_INFO;
$ordSel = $_jeDB->dbSelect($_ORD_INFO,"item_img_folder,item_img_name,item_img_type","where ord_cd='{$orv_ord_cd}' limit 1");
$ordNum = intval($_jeDB->getRows());
if($ordNum) {
$ordObj = $_jeDB->getFetchRows($ordSel);
$itm_img_fd = $ordObj[0];
$itm_img_nm = $ordObj[1];
$itm_img_ex = $ordObj[2];
# 상품이미지
$best_itm_img = "";
if($itm_img_fd && $itm_img_ex && $itm_img_nm) {
$best_itm_img = $_jeCFunc->getImgUrl($orv_ord_pt,"O",$itm_img_fd,$itm_img_nm,$itm_img_ex);
} else {
$best_itm_img = "/img/300_300_noim.gif";
}
} else {
$best_itm_img = "/img/300_300_noim.gif";
}
}
}
?>
재팬엔조이 실제 이용 후기
건
j_dbSelect2($_ORD_ITEM_REVIEW,$_ORD_ITEM_REVIEW_ATTACH,
"a.orv_mem_id,a.orv_ord_pt,a.orv_ord_cd,a.orv_star,a.orv_review,b.*",
"on a.orv_key=b.ort_orv_key","where a.orv_isshow='Y' and a.orv_view='Y' order by a.orv_reg_date desc limit 5");
$rvwNum = intval($_jeDB->getRows());
if(intval($rvwNum) > 0) {
for($r=0;$r<$rvwNum;$r++) {
$rvwObj = $_jeDB->getFetchAssoc($rvwSel);
while(list($key,$val) = each($rvwObj)) ${$key} = $val;
# 상품이미지
if($ort_file_name && $ort_file_path) {
$itm_img = "/gimg/{$ort_file_path}/{$ort_file_name}";
} else {
$_ORD_INFO = ($orv_ord_pt == "A") ? $_ORD_A_INFO : $_ORD_B_INFO;
$ordSel = $_jeDB->dbSelect($_ORD_INFO,"item_img_folder,item_img_name,item_img_type","where ord_cd='{$orv_ord_cd}' limit 1");
$ordNum = intval($_jeDB->getRows());
if($ordNum) {
$ordObj = $_jeDB->getFetchRows($ordSel);
$itm_img_fd = $ordObj[0];
$itm_img_nm = $ordObj[1];
$itm_img_ex = $ordObj[2];
# 상품이미지
$itm_img = "";
if($itm_img_fd && $itm_img_ex && $itm_img_nm) {
$itm_img = $_jeCFunc->getImgUrl($orv_ord_pt,"O",$itm_img_fd,$itm_img_nm,$itm_img_ex);
} else {
$itm_img = "/img/300_300_noim.gif";
}
} else {
$itm_img = "/img/300_300_noim.gif";
}
}
# 상세URL
$orv_detail_url = "/community/index.html?hpd=com_reviews";
# 상품정보
echo "
";
}
}
?>
dbSelect($_MEM_INFO,"mem_grd_cd,mem_name,mem_gender,mem_pk_ecash,mem_pk_mileage","where mem_cd='{$_JE_MCD_}' and mem_id='{$_JE_MID_}'");
$memNum = intval($_jeDB->getRows());
if($memNum > 0) {
$memObj = $_jeDB->getFetchAssoc($memSel);
while(list($key,$val) = each($memObj)) ${$key} = $val;
$mem_grd_str = $_jeCFunc->getMemGradeStr($mem_grd_cd);
$mem_name = $_jeCFunc->getCnvtStr($mem_name);
$mem_gender_str = ($mem_gender == "M") ? "m" : "f";
$mem_pk_ecash_str = number_format(intval($mem_pk_ecash));
$mem_pk_mileage_str = number_format(intval($mem_pk_mileage));
# 쿠폰갯수 호출
$mcpSel = $_jeDB->dbSelect($_MEM_POCKET_COUPON,"count(mp_key)","where mp_mem_cd='{$_JE_MCD_}' and mp_cp_exp_date > {$_DT_TIMES} and mp_use_date <= 0");
$mcpObj = $_jeDB->getFetchRows($mcpSel);
$mem_pk_coupon_str = number_format(intval($mcpObj[0]));
}
?>
dbSelect($_GV_EXCHANGE_RATE,"er_jp_jenjoy,er_cn_jenjoy,er_us_jenjoy","where er_isuse='Y' order by er_key desc limit 1");
$exrNum = intval($_jeDB->getRows());
if($exrNum) {
$exrObj = $_jeDB->getFetchAssoc($exrSel);
while(list($key,$val) = each($exrObj)) ${$key} = $val;
$er_jp_jenjoy = number_format($er_jp_jenjoy * 0.01,1);
$er_us_jenjoy = number_format($er_us_jenjoy * 0.01,1);
$er_cn_jenjoy = number_format($er_cn_jenjoy * 0.01,1);
}
?>
1JPY = 원
1USD = 원
dbSelect($_BD_NOTICE,"bd_key,bd_a_subject","order by bd_hot desc,bd_key desc limit 5");
$bbsNum = intval($_jeDB->getRows());
if($bbsNum) {
for($b=0;$b<$bbsNum;$b++) {
$bbsObj = $_jeDB->getFetchAssoc($bbsSel);
while(list($key,$val) = each($bbsObj)) ${$key} = $val;
$bd_a_subject = stripslashes(urldecode($bd_a_subject));
$bd_a_subject_str = ($bd_a_subject) ? $_jeCFunc->cut_str2($bd_a_subject,30,". . .") : "제목없음";
echo "
";
}
}
?>
![](\"/img/main/ico_notice.gif\")
일본 최대 중고마켓, 메루카리
일본 최대 패션 쇼핑몰 조조타운, 조조중고
여성패션
남성패션
책/음악/게임
신발
가방
액세서리
일본 지금 제일 뜨는 아이템!
재팬엔조이 인기 야후 상품
dbSelect("item_main_list",
"iml_key, iml_part, iml_genre, iml_icd, iml_title, iml_img_url, iml_price, iml_retime",
"where iml_genre=22844 and iml_retime >= {$_DT_TIMES} order by iml_reg_date desc, iml_key asc limit 8");
$popNum = intval($_jeDB->getRows());
if($popNum) {
for($i=0;$i<$popNum; $i++) {
$popObj = $_jeDB->getFetchAssoc($popSel);
while(list($key,$val) = each($popObj)) ${$key} = $val;
$iml_title = $_jeCFunc->getCnvtStr($iml_title);
$item_pri_buy = $_jeCFunc->getNumberFormat($iml_price);
$item_pri_buy_str = "";
if($item_pri_buy) {
$item_pri_buy_str = "¥ {$item_pri_buy}";
}
$dDay = $_jeCFunc->getRemindTime($iml_retime-$_DT_TIMES);
$getDetailUrl = "/item/auc/index.html?itemst=JPYA&itemgd={$iml_genre}&itemcd={$iml_icd}";
echo "
";
}
}
?>
{$iml_title}
{$item_pri_buy_str}
dbSelect("item_main_list",
"iml_key, iml_part, iml_genre, iml_icd, iml_title, iml_img_url, iml_price, iml_retime",
"where iml_genre=2084024100 and iml_retime >= {$_DT_TIMES} order by iml_reg_date desc, iml_key asc limit 8");
$popNum = intval($_jeDB->getRows());
if($popNum) {
for($i=0;$i<$popNum; $i++) {
$popObj = $_jeDB->getFetchAssoc($popSel);
while(list($key,$val) = each($popObj)) ${$key} = $val;
$iml_title = $_jeCFunc->getCnvtStr($iml_title);
$item_pri_buy = $_jeCFunc->getNumberFormat($iml_price);
$item_pri_buy_str = "";
if($item_pri_buy) {
$item_pri_buy_str = "¥ {$item_pri_buy}";
}
$dDay = $_jeCFunc->getRemindTime($iml_retime-$_DT_TIMES);
$getDetailUrl = "/item/auc/index.html?itemst=JPYA&itemgd={$iml_genre}&itemcd={$iml_icd}";
echo "
";
}
}
?>
{$iml_title}
{$item_pri_buy_str}
dbSelect("item_main_list",
"iml_key, iml_part, iml_genre, iml_icd, iml_title, iml_img_url, iml_price, iml_retime",
"where iml_genre=2084250263 and iml_retime >= {$_DT_TIMES} order by iml_reg_date desc, iml_key asc limit 8");
$popNum = intval($_jeDB->getRows());
if($popNum) {
for($i=0;$i<$popNum; $i++) {
$popObj = $_jeDB->getFetchAssoc($popSel);
while(list($key,$val) = each($popObj)) ${$key} = $val;
$iml_title = $_jeCFunc->getCnvtStr($iml_title);
$item_pri_buy = $_jeCFunc->getNumberFormat($iml_price);
$item_pri_buy_str = "";
if($item_pri_buy) {
$item_pri_buy_str = "¥ {$item_pri_buy}";
}
$dDay = $_jeCFunc->getRemindTime($iml_retime-$_DT_TIMES);
$getDetailUrl = "/item/auc/index.html?itemst=JPYA&itemgd={$iml_genre}&itemcd={$iml_icd}";
echo "
";
}
}
?>
{$iml_title}
{$item_pri_buy_str}
dbSelect("item_main_list",
"iml_key, iml_part, iml_genre, iml_icd, iml_title, iml_img_url, iml_price, iml_retime",
"where iml_genre=25180 and iml_retime >= {$_DT_TIMES} order by iml_reg_date desc, iml_key asc limit 8");
$popNum = intval($_jeDB->getRows());
if($popNum) {
for($i=0;$i<$popNum; $i++) {
$popObj = $_jeDB->getFetchAssoc($popSel);
while(list($key,$val) = each($popObj)) ${$key} = $val;
$iml_title = $_jeCFunc->getCnvtStr($iml_title);
$item_pri_buy = $_jeCFunc->getNumberFormat($iml_price);
$item_pri_buy_str = "";
if($item_pri_buy) {
$item_pri_buy_str = "¥ {$item_pri_buy}";
}
$dDay = $_jeCFunc->getRemindTime($iml_retime-$_DT_TIMES);
$getDetailUrl = "/item/auc/index.html?itemst=JPYA&itemgd={$iml_genre}&itemcd={$iml_icd}";
echo "
";
}
}
?>
{$iml_title}
{$item_pri_buy_str}
dbSelect("item_main_list",
"iml_key, iml_part, iml_genre, iml_icd, iml_title, iml_img_url, iml_price, iml_retime",
"where iml_genre=25336 and iml_retime >= {$_DT_TIMES} order by iml_reg_date desc, iml_key asc limit 8");
$popNum = intval($_jeDB->getRows());
if($popNum) {
for($i=0;$i<$popNum; $i++) {
$popObj = $_jeDB->getFetchAssoc($popSel);
while(list($key,$val) = each($popObj)) ${$key} = $val;
$iml_title = $_jeCFunc->getCnvtStr($iml_title);
$item_pri_buy = $_jeCFunc->getNumberFormat($iml_price);
$item_pri_buy_str = "";
if($item_pri_buy) {
$item_pri_buy_str = "¥ {$item_pri_buy}";
}
$dDay = $_jeCFunc->getRemindTime($iml_retime-$_DT_TIMES);
$getDetailUrl = "/item/auc/index.html?itemst=JPYA&itemgd={$iml_genre}&itemcd={$iml_icd}";
echo "
";
}
}
?>
{$iml_title}
{$item_pri_buy_str}
일본 라쿠텐
일본 현지 랭킹 >신발 | >여성패션 | >남성패션
|
|
 |
 |
 |
 |
 |
 |
 |
 |