getRow("SELECT a.*,b.tname FROM `{$db_mymps}goods` AS a LEFT JOIN `{$db_mymps}member` AS b ON a.userid = b.userid WHERE goodsid = '$id' AND onsale = '1'");
$goods['tname'] = $goods['tname'] ? $goods['tname'] : $goods['userid'];
$uid = $db -> getOne("SELECT id FROM `{$db_mymps}member` WHERE userid = '$goods[userid]'");
$goods['tname_uri'] = Rewrite('store',array('uid'=>$uid,'action'=>'index'));
if(!$goods['goodsid']) write_msg('该商品不存在或者已下架!','olmsg');
$db->query("UPDATE `{$db_mymps}goods` SET hit = hit + 1 WHERE goodsid = '$id'");
$goods['picture'] = $goods['picture'] ? $goods['picture'] : $mymps_global['SiteUrl'].'/images/nophoto.gif';
/*商品介绍内链处理*/
$goods['content'] = replace_insidelink($goods['content'],'goods');
$loc = mymps_get_goods_location($goods['catid'],$goods['goodsname']);
$page_title = $loc['page_title'];
$location = $loc['location'];
$goods['quhuo'] = textarea_post_change($pluginsettings['goods']['quhuo']);
$goods['fukuan'] = textarea_post_change($pluginsettings['goods']['fukuan']);
$goods['service'] = textarea_post_change($pluginsettings['goods']['service']);
unset($pluginsettings);
$advertisement = get_advertisement('other');
$adveritems = $advertisement['items'];
$advertisement = $advertisement['all'];
$relategoods = mymps_get_goods(7,1,NULL,$goods['catid']);
globalassign();
include mymps_tpl('view');
}else{
$advertisement = get_advertisement('other');
$adveritems = $advertisement['items'];
$advertisement = $advertisement['all'];
$where = " WHERE onsale = '1'";
if($catid){
$catid = intval($catid);
$cat = $db -> getRow("SELECT * FROM `{$db_mymps}goods_category` WHERE catid = '$catid'");
if(!$cat){
$where = NULL;
write_msg('该商品分类不存在或者已删除!','olmsg');
exit;
}
$goods_children = mymps_get_goods_children($catid);
$where .= " AND catid IN (".$goods_children.")";
}
$remai_goods = mymps_get_goods(5,1,'remai');
$tuijian_goods = mymps_get_goods(4,1,'tuijian');
$loc = mymps_get_goods_location($cat['catid']);
$page_title = $loc['page_title'];
$location = $loc['location'];
$keywords = $pluginsettings[CURSCRIPT]['seokeywords'];
$description = $pluginsettings[CURSCRIPT]['seodescription'];
$goods_cat = goods_category_tree(0);
$where .= $tuijian == '1' ? " AND tuijian = '1'" : '';
$where .= $cuxiao == '1' ? " AND cuxiao = '1'" : '';
$orderby = in_array($orderby,array('dateline','hit')) ? $orderby : 'dateline';
$rows_num = $db -> getOne("SELECT COUNT(goodsid) FROM `{$db_mymps}goods` $where");
$param = setParam(array('catid','orderby','tuijian','cuxiao'));
$goods = page1("SELECT * FROM `{$db_mymps}goods` $where ORDER BY ".$orderby." DESC",16);
foreach($goods as $k => $v){
$list[$v['goodsid']]['goodsid'] = $v['goodsid'];
$list[$v['goodsid']]['goodsname'] = $v['goodsname'];
$list[$v['goodsid']]['nowprice'] = $v['nowprice'];
$list[$v['goodsid']]['oldprice'] = $v['oldprice'];
$list[$v['goodsid']]['pre_picture'] = $v['pre_picture'] ? $v['pre_picture'] : '/images/nophoto.gif';
$list[$v['goodsid']]['picture'] = $v['picture'] ? $v['picture'] : '/images/nophoto.gif';
$list[$v['goodsid']]['uri'] = Rewrite('goods',array('id'=>$v['goodsid']));
}
$page_view = page2();
$uri = array();
$uri['tuijian'] = Rewrite('goods',array('catid'=>$cat['catid'],'tuijian'=>'1','orderby'=>$orderby));
$uri['cuxiao'] = Rewrite('goods',array('catid'=>$cat['catid'],'cuxiao'=>'1','orderby'=>$orderby));
$uri['hit'] = Rewrite('goods',array('catid'=>$cat['catid'],'orderby'=>'hit'));
$uri['dateline']= Rewrite('goods',array('catid'=>$cat['catid']));
globalassign();
include mymps_tpl('index');
}
}else{
$oname = $oname ? mhtmlspecialchars($oname) : '';
$goodsid = isset($goodsid) ? intval($goodsid) : '';
$ordernum = isset($ordernum) ? intval($ordernum) : '';
$qq = isset($qq) ? mhtmlspecialchars($qq) : '';
$tel = isset($tel) ? mhtmlspecialchars($tel) : '';
$mobile = isset($mobile) ? mhtmlspecialchars($mobile) : '';
$ip = GetIP();
$msg = isset($msg) ? textarea_post_change($msg) : '';
$address = isset($address) ? mhtmlspecialchars($address) : '';
$_COOKIE['goodsorder'.$goodsid] == 1 && write_msg('该商品您已经下过订单了,看看别的商品吧...','olmsg');
if(empty($goodsid)) write_msg('您要购买的商品不存在或已下架!');
if(empty($oname)) write_msg('您的姓名不能为空!');
$db -> query("INSERT INTO `{$db_mymps}goods_order` (goodsid,ordernum,oname,qq,tel,mobile,ip,address,msg,dateline) VALUES ('$goodsid','$ordernum','$oname','$qq','$tel','$mobile','$ip','$address','$msg','$timestamp')");
setcookie('goodsorder'.$goodsid,1,$timestamp+180,'/');
write_msg('您的订单已提交成功,我们会尽快与您取得联系!
','olmsg');
}
is_object($db) && $db->Close();
function mymps_get_goods_location($catid=0,$str=''){
global $db,$db_mymps,$pluginsettings,$seo;
$cat_arr = goods_parent_cats($catid);
$raquo = $GLOBALS['mymps_global']['cfg_raquo'];
$location = '当前位置:'.$GLOBALS['mymps_global']['SiteName'].''.' '.$raquo.'
'.' 商品网购';
$page_title = $pluginsettings['goods']['seotitle'] ? $pluginsettings['goods']['seotitle'] : '商品网购-'.$GLOBALS['mymps_global']['SiteName'];
if(!empty($catid)){
/* 循环分类 */
if (!empty($cat_arr)){
krsort($cat_arr);
foreach ($cat_arr as $val){
$page_title = $val['catname'] . '-' . $page_title;
$location .= ' '.$raquo.'
' .
$val['catname'] . '';
}
}
}
if (!empty($str)){
$page_title = $str.'-'.$page_title;
$location .= ' '.$raquo.'
' .$str;
}
$cur = array('page_title'=>$page_title,'location'=>$location);
unset($page_title,$cat,$location,$type,$goods_class);
return $cur;
}
?>