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

    <?php
include ('./include/common.inc.php');
$pagetitle = '商品对比';
$headlinks = showlinks('css','style');
$jslinks = showlinks('js','common');
$cpids = scriptfilter($_MCOOKIE['comparegoods']);
if($cpids == ''){
	showmessage('你还没有选择商品，不能进行对比！');
}
$cpids = str_replace('_',',',$cpids);
$query = $db->query("SELECT * FROM {$tablepre}goods g,{$tablepre}goodsattr ga WHERE g.gid=ga.gid AND g.gid IN ($cpids) GROUP BY ga.gid");

$cateids = $cates = $cparr = $owners = $cateattrs = $ownerattrs = $cpattr = array();
while($arr = $db->fetch_array($query)){
	$arr['photos'] = unserialize($arr['photos']);
	
	$cparr['标题'][$arr['gid']] = "<a href=\"$goods_head$arr[gid]$goods_end\" target=\"_blank\">$arr[subject]</a>";
	$cparr['图片'][$arr['gid']] = "<a href=\"$goods_head$arr[gid]$goods_end\" target=\"_blank\"><em class=\"load_120_50\"></em><img onload=\"reimg(this,120,120)\" src=\"$attachurl/small/goods/".array_shift($arr['photos'])."\" /></a>";
	$cparr['价格'][$arr['gid']] = '<span class="dprice">￥'.number_format($arr['eprice'] * ($arr['discount'] / 10), 2).'</span>';
	$cparr['重量'][$arr['gid']] = $arr['weight'].' 千克';
	$cparr['销量'][$arr['gid']] = ($arr['zsold']+$arr['sold']).$units[$arr['unit']];
	$cates[$arr['gid']] = array($arr['category4'],$arr['category5'],$arr['category6'],$arr['category7'],$arr['category8'],$arr['category9'],$arr['category10']);
    $cateids = array_merge($cateids,$cates[$arr['gid']]);
}

$cateidstr = implode(',', $cateids);

$query = $db->query("SELECT * FROM {$tablepre}category WHERE categoryid IN ($cateidstr)");
while ($arr = $db->fetch_array($query)) {
    $owners[] = $arr['owner'];
    $cateattrs[$arr['categoryid']] = $arr;
}
$ownerids = implode(',',$owners);
$query = $db->query("SELECT * FROM {$tablepre}category WHERE categoryid IN ($ownerids)");
while ($arr = $db->fetch_array($query)) {
    $ownerattrs[$arr['categoryid']] = $arr;
}

foreach($ownerattrs as $oid => $cate){
	foreach($cates as $gid => $cts){
		$cpattr[$cate['name']][$gid] = '-';
		foreach($cts as $cid){
			if($cid && $cateattrs[$cid]['owner'] == $oid){
				$cpattr[$cate['name']][$gid] = $cateattrs[$cid]['name'];
			}
		}
	}
}

include(template('compare'));
?>