www.gusucode.com > 迪恩育儿亲子4商城商家+手机版【整站带测试数据】源码程序 > web/source/class/block/group/block_grouptrade.php
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: block_grouptrade.php 32768 2013-03-07 09:40:05Z zhangguosheng $
*/
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
class block_grouptrade extends discuz_block {
var $setting = array();
function block_grouptrade(){
$this->setting = array(
'tids' => array(
'title' => 'grouptrade_tids',
'type' => 'text'
),
'uids' => array(
'title' => 'grouptrade_uids',
'type' => 'text'
),
'keyword' => array(
'title' => 'grouptrade_keyword',
'type' => 'text'
),
'fids' => array(
'title' => 'grouptrade_fids',
'type' => 'text'
),
'gtids' => array(
'title' => 'grouptrade_gtids',
'type' => 'mselect',
'value' => array(
),
),
'digest' => array(
'title' => 'grouptrade_digest',
'type' => 'mcheckbox',
'value' => array(
array(1, 'grouptrade_digest_1'),
array(2, 'grouptrade_digest_2'),
array(3, 'grouptrade_digest_3'),
array(0, 'grouptrade_digest_0')
),
),
'stick' => array(
'title' => 'grouptrade_stick',
'type' => 'mcheckbox',
'value' => array(
array(1, 'grouptrade_stick_1'),
array(2, 'grouptrade_stick_2'),
array(3, 'grouptrade_stick_3'),
array(0, 'grouptrade_stick_0')
),
),
'recommend' => array(
'title' => 'grouptrade_recommend',
'type' => 'radio'
),
'orderby' => array(
'title' => 'grouptrade_orderby',
'type'=> 'mradio',
'value' => array(
array('dateline', 'grouptrade_orderby_dateline'),
array('todayhots', 'grouptrade_orderby_todayhots'),
array('weekhots', 'grouptrade_orderby_weekhots'),
array('monthhots', 'grouptrade_orderby_monthhots'),
),
'default' => 'dateline'
),
'gviewperm' => array(
'title' => 'grouptrade_gviewperm',
'type' => 'mradio',
'value' => array(
array('-1', 'grouptrade_gviewperm_nolimit'),
array('0', 'grouptrade_gviewperm_only_member'),
array('1', 'grouptrade_gviewperm_all_member')
),
'default' => '-1'
),
'highlight' => array(
'title' => 'grouptrade_highlight',
'type' => 'radio',
'default' => 0,
),
'titlelength' => array(
'title' => 'grouptrade_titlelength',
'type' => 'text',
'default' => 40
),
'summarylength' => array(
'title' => 'grouptrade_summarylength',
'type' => 'text',
'default' => 80
),
'startrow' => array(
'title' => 'grouptrade_startrow',
'type' => 'text',
'default' => 0
),
);
}
function name() {
return lang('blockclass', 'blockclass_grouptrade_script_grouptrade');
}
function blockclass() {
return array('trade', lang('blockclass', 'blockclass_group_trade'));
}
function fields() {
return array(
'id' => array('name' => lang('blockclass', 'blockclass_field_id'), 'formtype' => 'text', 'datatype' => 'int'),
'url' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_url'), 'formtype' => 'text', 'datatype' => 'string'),
'title' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_title'), 'formtype' => 'title', 'datatype' => 'title'),
'pic' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_pic'), 'formtype' => 'pic', 'datatype' => 'pic'),
'summary' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_summary'), 'formtype' => 'summary', 'datatype' => 'summary'),
'totalitems' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_totalitems'), 'formtype' => 'text', 'datatype' => 'int'),
'author' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_author'), 'formtype' => 'text', 'datatype' => 'text'),
'authorid' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_authorid'), 'formtype' => 'text', 'datatype' => 'int'),
'price' => array('name' => lang('blockclass', 'blockclass_grouptrade_field_price'), 'formtype' => 'text', 'datatype' => 'text'),
);
}
function fieldsconvert() {
return array(
'forum_trade' => array(
'name' => lang('blockclass', 'blockclass_forum_trade'),
'script' => 'trade',
'searchkeys' => array(),
'replacekeys' => array(),
),
);
}
function getsetting() {
global $_G;
$settings = $this->setting;
if($settings['gtids']) {
loadcache('grouptype');
$settings['gtids']['value'][] = array(0, lang('portalcp', 'block_all_type'));
foreach($_G['cache']['grouptype']['first'] as $gid=>$group) {
$settings['gtids']['value'][] = array($gid, $group['name']);
if($group['secondlist']) {
foreach($group['secondlist'] as $subgid) {
$settings['gtids']['value'][] = array($subgid, ' '.$_G['cache']['grouptype']['second'][$subgid]['name']);
}
}
}
}
return $settings;
}
function getdata($style, $parameter) {
global $_G;
$parameter = $this->cookparameter($parameter);
loadcache('grouptype');
$typeids = array();
if(!empty($parameter['gtids'])) {
if($parameter['gtids'][0] == '0') {
unset($parameter['gtids'][0]);
}
$typeids = $parameter['gtids'];
}
$tids = !empty($parameter['tids']) ? explode(',', $parameter['tids']) : array();
$fids = !empty($parameter['fids']) ? explode(',', $parameter['fids']) : array();
$uids = !empty($parameter['uids']) ? explode(',', $parameter['uids']) : array();
$startrow = isset($parameter['startrow']) ? intval($parameter['startrow']) : 0;
$items = isset($parameter['items']) ? intval($parameter['items']) : 10;
$digest = isset($parameter['digest']) ? $parameter['digest'] : 0;
$stick = isset($parameter['stick']) ? $parameter['stick'] : 0;
$orderby = isset($parameter['orderby']) ? (in_array($parameter['orderby'],array('dateline','todayhots','weekhots','monthhots')) ? $parameter['orderby'] : 'dateline') : 'dateline';
$titlelength = !empty($parameter['titlelength']) ? intval($parameter['titlelength']) : 40;
$summarylength = !empty($parameter['summarylength']) ? intval($parameter['summarylength']) : 80;
$recommend = !empty($parameter['recommend']) ? 1 : 0;
$keyword = !empty($parameter['keyword']) ? $parameter['keyword'] : '';
$highlight = !empty($parameter['highlight']) ? 1 : 0;
$bannedids = !empty($parameter['bannedids']) ? explode(',', $parameter['bannedids']) : array();
$gviewperm = isset($parameter['gviewperm']) ? intval($parameter['gviewperm']) : -1;
$gviewwhere = $gviewperm == -1 ? '' : " AND ff.gviewperm='$gviewperm'";
$groups = array();
if(empty($fids) && $typeids) {
$query = DB::query('SELECT f.fid, f.name, ff.description FROM '.DB::table('forum_forum')." f LEFT JOIN ".DB::table('forum_forumfield')." ff ON f.fid = ff.fid WHERE f.fup IN (".dimplode($typeids).") AND threads > 0$gviewwhere");
while($value = DB::fetch($query)) {
$groups[$value['fid']] = $value;
$fids[] = intval($value['fid']);
}
if(empty($fids)){
return array('html' => '', 'data' => '');
}
}
require_once libfile('function/post');
require_once libfile('function/search');
$datalist = $list = $listpids = $threadpids = $aid2pid = $attachtables = array();
$keyword = $keyword ? searchkey($keyword, "tr.subject LIKE '%{text}%'") : '';
$sql = ($fids ? ' AND t.fid IN ('.dimplode($fids).')' : '')
.($tids ? ' AND t.tid IN ('.dimplode($tids).')' : '')
.($digest ? ' AND t.digest IN ('.dimplode($digest).')' : '')
.($stick ? ' AND t.displayorder IN ('.dimplode($stick).')' : '');
if(empty($fids)) {
$sql .= " AND t.isgroup='1'";
if($gviewwhere) {
$sql .= $gviewwhere;
}
}
$where = '';
if(in_array($orderby, array('todayhots','weekhots','monthhots'))) {
$historytime = 0;
switch($orderby) {
case 'todayhots':
$historytime = mktime(0, 0, 0, date('m', TIMESTAMP), date('d', TIMESTAMP), date('Y', TIMESTAMP));
break;
case 'weekhots':
$week = dgmdate(TIMESTAMP, 'w', getglobal('setting/timeformat')) - 1;
$week = $week != -1 ? $week : 6;
$historytime = mktime(0, 0, 0, date('m', TIMESTAMP), date('d', TIMESTAMP) - $week, date('Y', TIMESTAMP));
break;
case 'monthhots':
$historytime = mktime(0, 0, 0, date('m', TIMESTAMP), 1, date('Y', TIMESTAMP));
break;
}
$where = ' AND tr.dateline>='.$historytime;
$orderby = 'totalitems';
}
$where .= ($uids ? ' AND tr.sellerid IN ('.dimplode($uids).')' : '').$keyword;
$where .= ($bannedids ? ' AND tr.pid NOT IN ('.dimplode($bannedids).')' : '');
$where = "$sql AND t.displayorder>='0' $where";
$sqlfrom = " INNER JOIN `".DB::table('forum_thread')."` t ON t.tid=tr.tid ";
$joinmethod = empty($tids) ? 'INNER' : 'LEFT';
if($recommend) {
$sqlfrom .= " $joinmethod JOIN `".DB::table('forum_forumrecommend')."` fc ON fc.tid=tr.tid";
}
$sqlfield = '';
if(empty($fids)) {
$sqlfield = ', f.name groupname';
$sqlfrom .= ' LEFT JOIN '.DB::table('forum_forum').' f ON t.fid=f.fid LEFT JOIN '.DB::table('forum_forumfield').' ff ON f.fid = ff.fid';
}
$sqlfield = $highlight ? ', t.highlight' : '';
$query = DB::query("SELECT tr.pid, tr.tid, tr.aid, tr.price, tr.credit, tr.subject, tr.totalitems, tr.seller, tr.sellerid$sqlfield
FROM ".DB::table('forum_trade')." tr $sqlfrom
WHERE 1$where
ORDER BY tr.$orderby DESC
LIMIT $startrow,$items;"
);
require_once libfile('block_thread', 'class/block/forum');
$bt = new block_thread();
while($data = DB::fetch($query)) {
if($style['getsummary']) {
$threadpids[$data['posttableid']][] = $data['pid'];
}
if($data['aid']) {
$aid2pid[$data['aid']] = $data['pid'];
$attachtable = getattachtableid($data['tid']);
$attachtables[$attachtable][] = $data['aid'];
}
$listpids[] = $data['pid'];
$list[$data['pid']] = array(
'id' => $data['pid'],
'idtype' => 'pid',
'title' => cutstr(str_replace('\\\'', ''', addslashes($data['subject'])), $titlelength, ''),
'url' => 'forum.php?mod=viewthread&do=tradeinfo&tid='.$data['tid'].'&pid='.$data['pid'],
'pic' => ($data['aid'] ? '' : $_G['style']['imgdir'].'/nophoto.gif'),
'picflag' => '0',
'fields' => array(
'fulltitle' => str_replace('\\\'', ''', addslashes($data['subject'])),
'totalitems' => $data['totalitems'],
'author' => $data['seller'] ? $data['seller'] : $_G['setting']['anonymoustext'],
'authorid' => $data['sellerid'] ? $data['sellerid'] : 0,
'price' => ($data['price'] > 0 ? '¥ '.$data['price'] : '').($data['credit'] > 0 ? ($data['price'] > 0 ? lang('block/grouptrade', 'grouptrade_price_add') : '').$data['credit'].' '.$_G['setting']['extcredits'][$_G['setting']['creditstransextra'][5]]['unit'].$_G['setting']['extcredits'][$_G['setting']['creditstransextra'][5]]['title'] : ''),
)
);
if($highlight && $data['highlight']) {
$list[$data['tid']]['fields']['showstyle'] = $bt->getthreadstyle($data['highlight']);
}
}
if(!empty($listpids)) {
foreach($threadpids as $key => $var) {
$posttable = $key == 0 ? 'forum_post' : 'forum_post_'.$key;
$query = DB::query("SELECT pid, message FROM ".DB::table($posttable)." WHERE pid IN (".dimplode($var).")");
while($result = DB::fetch($query)) {
$list[$result['pid']]['summary'] = messagecutstr($result['message'], $summarylength, '');
}
}
foreach($attachtables as $tableid => $taids) {
$query = DB::query('SELECT aid, attachment, remote FROM '.DB::table('forum_attachment_'.$tableid).' WHERE aid IN ('.dimplode($taids).')');
while($avalue = DB::fetch($query)) {
$list[$aid2pid[$avalue['aid']]]['pic'] = 'forum/'.$avalue['attachment'];
$list[$aid2pid[$avalue['aid']]]['picflag'] = $avalue['remote'] ? '2' : '1';
}
}
foreach($listpids as $key => $value) {
$datalist[] = $list[$value];
}
}
return array('html' => '', 'data' => $datalist);
}
}
?>