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')); ?>