www.gusucode.com > Destoon B2B仿淘宝电子商务网站 UTF8 v6.0源码程序 > destoon/module/quote/price.inc.php

    <?php 
defined('IN_DESTOON') or exit('Access Denied');
$itemid or dheader($MOD['linkurl'].'product.php');
require DT_ROOT.'/module/'.$module.'/common.inc.php';
if(!check_group($_groupid, $MOD['group_show_price'])) include load('403.inc');
require DT_ROOT.'/include/post.func.php';
$P = $db->get_one("SELECT * FROM {$table_product} WHERE itemid=$itemid");
$P or dheader($MOD['linkurl'].'product.php');
$could_add = check_group($_groupid, $MOD['group_add_price']);
$MARKET = $P['market'] ? explode('|', $L['price_market'].'|'.$P['market']) : array();
if($could_add) {
	$need_captcha = $MOD['captcha_add'] == 2 ? $MG['captcha'] : $MOD['captcha_add'];
	if($submit) {
		$sql = $_userid ? "username='$_username'" : "ip='$DT_IP'";
		$today = $today_endtime - 86400;
		$r = $db->get_one("SELECT COUNT(*) AS num FROM {$table_price} WHERE $sql AND pid=$itemid AND addtime>$today");
		$limit_used = $r['num'];
		if($limit_used > 0) dalert($L['msg_added']);
		$msg = captcha($captcha, $need_captcha, true);
		if($msg) dalert($msg);
		$need_check =  $MOD['check_add'] == 2 ? $MG['check'] : $MOD['check_add'];
		$post['addtime'] = 0;
		$post['status'] = get_status(3, $need_check);
		$post['pid'] = $itemid;
		$post['username'] = $_username;
		if($_userid) $post['company'] = $_company;
		require DT_ROOT.'/module/'.$module.'/price.class.php';
		$do = new price;
		if($do->pass($post)) {
			$do->add($post);
			$msg = $post['status'] == 2 ? $L['msg_check'] : $L['msg_ok'];
			dalert($msg, '', 'parent.window.location=parent.window.location;');
		} else {
			dalert($do->errmsg, '', ($need_captcha ? reload_captcha() : '').($need_question ? reload_question() : ''));
		}
	}
}
isset($ms) or $ms = array();
$market = isset($market) ? intval($market) : 0;
$areaid = isset($areaid) ? intval($areaid) : 0;
$fromdate = isset($fromdate) && is_date($fromdate) ? $fromdate : '';
$fromtime = $fromdate ? strtotime($fromdate.' 0:0:0') : 0;
$todate = isset($todate) && is_date($todate) ? $todate : '';
$totime = $todate ? strtotime($todate.' 23:59:59') : 0;
$items = 0;
$tags = array();
$showpage = 1;
$condition = "status=3 AND pid=$itemid";
$_condition = $condition;
if($keyword) $condition .= " AND company LIKE '%$keyword%'";
if($areaid) $condition .= ($ARE['child']) ? " AND areaid IN (".$ARE['arrchildid'].")" : " AND areaid=$areaid";
if($market) $condition .= " AND market=$market";
if($fromtime) $condition .= " AND edittime>=$fromtime";
if($totime) $condition .= " AND edittime<=$totime";
$items = $db->count($table_price, $condition, $DT['cache_search']);
$pages = pages($items, $page, $pagesize);
$tags = array();
$result = $db->query("SELECT * FROM {$table_price} WHERE $condition ORDER BY addtime DESC LIMIT $offset,$pagesize");
while($r = $db->fetch_array($result)) {
	$tags[] = $r;
}
if($page == 1) {
	$update = 'hits=hits+1';
	if($_condition == $condition && $items != $P['item']) $update .= ",item=$items";
	$db->query("UPDATE {$table_product} SET $update WHERE itemid=$itemid");
}
if($pages) {
	$t = explode('&nbsp;<input', $pages);
	$pages = $t[0];
	$pages = str_replace('">', '#record">', $pages);
	$pages = str_replace('"/>', '#record"/>', $pages);
}

$COLOR = array('FF0000', 'FF6600', '008000', '0000FF', '008080', '800080', '800000', '000000', 'FFCC00', '00CCFF');
$_totime = $totime ? $totime : $P['edittime'];
$_fromtime = strtotime(timetodate($_totime, 3)) - 15*86400;
$condition = "status=3 AND pid=$itemid AND addtime>=$_fromtime AND addtime<=$_totime";
if($areaid) $condition .= ($ARE['child']) ? " AND areaid IN (".$ARE['arrchildid'].")" : " AND areaid=$areaid";
$lists = $dates = array();
$result = $db->query("SELECT * FROM {$table_price} WHERE $condition ORDER BY addtime ASC", $areaid ? '' : 'CACHE');
while($r = $db->fetch_array($result)) {
	$r['date'] = timetodate($r['addtime'], 3);
	$dates[$r['date']] = 0;
	$lists[] = $r;
}
$chart_title = $P['title'].$L['price_chart'];
$chart_name = $areaid ? $ARE['areaname'] : $L['allcity'];
$chart_data = '';
$chart_graph = '';
$data = array();
if(count($dates) > 1) {
	foreach($dates as $k=>$v) {
		$price = get_all($k, $lists);
		$data[$k] = $k.';'.$price;
	}
	if($MARKET && $ms) {
		$i = 0;
		foreach($MARKET as $kk=>$vv) {
			if($kk) {
				$mdata = array();
				foreach($dates as $k=>$v) {
					$price = get_mkt($k, $kk, $lists);
					$mdata[$k] = $price;
				}
				if(in_array($kk, $ms)) {
					foreach($mdata as $kkk=>$vvv) {
						$data[$kkk] = $data[$kkk].';'.$vvv; 
					}
					$i++;
					$ck = $i < 10 ? $i : $i%10;
					$chart_graph .= "<graph gid='".$i."'><title>".$vv."</title><color>".$COLOR[$ck]."</color><color_hover>".$COLOR[$ck]."</color_hover></graph>";
				}
			}
		}
	}
}
foreach($data as $v) {
	$chart_data .= $v.'\n';
}
if($P['seo_title']) {
	$head_title = $P['seo_title'];
} else {
	$head_title = $P['title'].$L['price_title'];
	if($P['v1']) $head_title = $head_title.' '.$P['v1'];
	if($P['v2']) $head_title = $head_title.' '.$P['v2'];
	if($P['v3']) $head_title = $head_title.' '.$P['v3'];
}
$head_title = $head_title.$DT['seo_delimiter'].$MOD['name'];
$head_keywords = $P['seo_keywords'];
$head_description = $P['seo_description'];
include template('price', $module);
?>