www.gusucode.com > citySHOP B2C商城系统 进销存 2.0.6码程序 > upload/goods.php

    <?php
include './include/common.inc.php';
include APP_ROOT . './editer/decode.inc.php';
$gid = intval($param);
if (!$gid) {
    showmessage('undefined_action');
}
$BASEFILENAME = 'goods';
$headlinks = showlinks('css','style');
$jslinks = showlinks('js','common');

include (cacheload('recommend'));
$recommend = $_MCACHE['recommend'];
    
$goodsviews_history = (isset($_MCOOKIE['goodsviews_history']) && preg_match("/^[,\d]+$/",
    $_MCOOKIE['goodsviews_history'])) ? explode(',', $_MCOOKIE['goodsviews_history']) :
    array();
if (!in_array($gid, $goodsviews_history)) {
    array_unshift($goodsviews_history, $gid);
    $goodsviews_history = array_slice($goodsviews_history, 0, 5);
    dsetcookie('goodsviews_history', implode(',', $goodsviews_history), $cookietime);
}

$db->query("UPDATE {$tablepre}goods SET `views` = `views`+1 WHERE gid='$gid'");

$cachedir = cacheload('goods');

if (!file_exists($cachedir)) {
    showmessage('该商品不存在或已删除!');
}

include ($cachedir);

$goods = $_MCACHE['goods'];

if($goods['selling'] != '1' && !$adminid){
	showmessage('该商品已下架!');
}

$pagetitle = $goods['subject'];
$photos = unserialize($goods['photos']);
$message = discuzcode($goods['message']);
$goodsattrs = $goods['goodsattrs'];
$sitekeywords = empty($goods['tags']) ? $pagetitle : $goods['tags'];
$sitedescription = empty($goods['description']) ? cutstr(strip_tags($message),
    200, '') : $goods['description']; 
$gdnum = $goods_start_number + $gid;
$goods['zsold'] = $goods['sold']+$goods['zsold'];   

foreach ($menus_array as $menu) {
    if ($menu['type'] == 'category' && $menu['id'] == $goods['category1']) {
        $hovscript = $category_head . $menu['url'] . $category_end;
        break;
    }
}

$goods['zprice'] = number_format($goods['eprice'] * ($goods['discount'] / 10), 2,'.','');
$goods['dprice'] = number_format($goods['eprice'] * ($goods['rdiscount'] / 10),2,'.','');

$stockstats = '';
switch (true) {
    case $goods['stock'] <= 0:
        $stockstats = '';
        break;
    case $goods['stock'] > 0:
        $stockstats = '(现货)';
        break;
}

$viewhistorys = viewhistory();
/**
 * 搭配购买
 */
 if($goods['withbuy']){
	 $query = $db->query("SELECT p.*,pg.newprice,g.gid,g.subject,g.discount,g.photos,g.eprice,g.category2,g.category1 FROM {$tablepre}packages p,{$tablepre}packagegoods pg,{$tablepre}goods g WHERE p.packid=pg.packid AND pg.gid=g.gid AND stats='1' AND g.gid!='$gid' AND pg.newprice<(g.eprice*g.discount/10) AND pg.packid='$goods[withbuy]' ORDER BY pg.newprice ASC");
	 $packages = $packcates = array();
	 $packagenum = 0;
	 while($arr = $db->fetch_array($query)){
	 	 $packagenum++;
	 	 $pphotos = unserialize($arr['photos']);
	 	 $arr['photo'] = array_shift($pphotos);
	 	 $arr['zprice'] = number_format($arr['eprice'] * ($arr['discount'] / 10), 2);
	 	 $arr['tprice'] = number_format($arr['newprice'],2);
		 $arr['save'] = number_format(($arr['zprice']-$arr['tprice']),2);
		 $packages[] = $arr;
		 
		 if(isset($packcates[$arr['category2']]['num'])){
		 	$packcates[$arr['category2']]['num']++;
		 }else{
		 	$packcates[$arr['category2']]['num']=1;
		 }
		 $packcates[$arr['category2']]['name'] = $categorys[$arr['category1']][$arr['category2']]['name'];
	 }
}
/**
 * 购买过该商品的还买过
 */
$query = $db->query("SELECT g.gid,g.subject,g.photos,g.eprice,g.discount FROM {$tablepre}packagegoods pg,{$tablepre}goods g WHERE g.selling='1' AND g.gid=pg.gid AND pg.newprice<(g.eprice*g.discount) AND pg.packid IN (SELECT p.packid FROM {$tablepre}packages p,{$tablepre}packagegoods g WHERE g.packid=p.packid AND p.display=0 AND g.gid='$gid')");
$subgoods = array();
while($arr = $db->fetch_array($query)){
	$arr['photos'] = unserialize($arr['photos']);
    $arr['zprice'] = number_format($arr['eprice'] * ($arr['discount'] / 10), 2);
	$subgoods[] = $arr;
}
shuffle($subgoods);
$subgoods = array_slice($subgoods,0,5);
/**
 * 同类商品调用
 */
$query = $db->query("SELECT gid,subject,photos,bbmark,eprice,asks,replys,discount,sold,zsold,unit FROM {$tablepre}goods WHERE category3='$goods[category3]' AND selling='1' GROUP BY subject");
$linkgoods = array();
while($arr = $db->fetch_array($query)){
	$godnum = $goods_start_number + $arr['gid'];
	$arr['zsold'] = $arr['sold']+$arr['zsold'];  
	$arr['photos'] = unserialize($arr['photos']);
    $arr['zprice'] = number_format($arr['eprice'] * ($arr['discount'] / 10), 2);
	$linkgoods[] = $arr;
}
shuffle($linkgoods);
$linkgoods = array_slice($linkgoods,0,5);
  
include (template('goods'));
?>