www.gusucode.com > Destoon B2B仿淘宝电子商务网站 UTF8 v6.0源码程序 > destoon/module/extend/spread.inc.php
<?php defined('IN_DESTOON') or exit('Access Denied'); require DT_ROOT.'/module/'.$module.'/common.inc.php'; require DT_ROOT.'/include/post.func.php'; $this_month = date('n', $DT_TIME); $this_year = date('Y', $DT_TIME); $next_month = $this_month == 12 ? 1 : $this_month + 1; $next_year = $this_month == 12 ? $this_year + 1 : $this_year; $next_time = strtotime($next_year.'-'.$next_month.'-1'); $spread_max = $MOD['spread_max'] ? $MOD['spread_max'] : 10; $currency = $MOD['spread_currency']; $unit = $currency == 'money' ? $DT['money_unit'] : $DT['credit_unit']; if($action == 'list') { if($MOD['spread_list'] && $kw && in_array($mid, array(4, 5, 6))) { $condition = "mid=$mid AND status=3 AND word='$kw'"; $r = $db->get_one("SELECT COUNT(*) AS num FROM {$DT_PRE}spread WHERE $condition"); $pages = pages($r['num'], $page, $pagesize); $i = $j = 0; $lists = array(); $result = $db->query("SELECT DATE_FORMAT(FROM_UNIXTIME(fromtime),'%Y%m') as id,itemid,mid,tid,word,price,currency,company,username,addtime,fromtime,totime FROM {$DT_PRE}spread WHERE $condition ORDER BY id DESC,price DESC,itemid DESC LIMIT $offset,$pagesize"); while($r = $db->fetch_array($result)) { //print_r($r);exit; if($r['totime'] < $DT_TIME) { $r['process'] = $L['status_expired']; } else if($r['fromtime'] > $DT_TIME) { $r['process'] = $L['status_not_start']; } else { $r['process'] = $L['status_displaying']; } //$r['key'] = timetodate($r['fromtime'], 'Ym'); if($j == 0) $i = $r['id']; $r['bg'] = $i == $r['id'] ? 0 : 1; if($i != $r['id']) $i = $r['id']; $j++; $lists[] = $r; } $head_title = $kw.$DT['seo_delimiter'].$MODULE[$mid]['name'].$DT['seo_delimiter'].$L['spread_title']; include template('spread', $module); } else { dheader('./'); } } else { $head_title = $L['spread_title']; if($kw) { $ukw = urlencode($kw); $p = $db->get_one("SELECT * FROM {$DT_PRE}spread_price WHERE word='$kw'"); if($p) { $sell_price = $p['sell_price'] ? $p['sell_price'] : $MOD['spread_sell_price']; $buy_price = $p['buy_price'] ? $p['buy_price'] : $MOD['spread_buy_price']; $company_price = $p['company_price'] ? $p['company_price'] : $MOD['spread_company_price']; } else { $sell_price = $MOD['spread_sell_price']; $buy_price = $MOD['spread_buy_price']; $company_price = $MOD['spread_company_price']; } $head_title = $kw.$DT['seo_delimiter'].$head_title; $sell_record = array(); $result = $db->query("SELECT * FROM {$DT_PRE}spread WHERE mid=5 AND status=3 AND word='$kw' AND fromtime>=$next_time ORDER BY price DESC,itemid ASC"); while($r = $db->fetch_array($result)) { $sell_record[] = $r; } $sell_count = count($sell_record); $buy_record = array(); $result = $db->query("SELECT * FROM {$DT_PRE}spread WHERE mid=6 AND status=3 AND word='$kw' AND fromtime>=$next_time ORDER BY price DESC,itemid ASC"); while($r = $db->fetch_array($result)) { $buy_record[] = $r; } $buy_count = count($buy_record); $company_record = array(); $result = $db->query("SELECT * FROM {$DT_PRE}spread WHERE mid=4 AND status=3 AND word='$kw' AND fromtime>=$next_time ORDER BY price DESC,itemid ASC"); while($r = $db->fetch_array($result)) { $company_record[] = $r; } $company_count = count($company_record); } $item = $db->get_one("SELECT itemid FROM {$DT_PRE}spread ORDER BY rand()"); $destoon_task = "moduleid=$moduleid&html=spread&itemid=$item[itemid]"; include template('spread', $module); } ?>