public function getRecords($filters, $pindex = 0, $psize = 20, &$total = 0)
{
global $_W;
$condition = '`r`.`uniacid`=:uniacid';
$pars = array();
$pars[':uniacid'] = $_W['uniacid'];
if (!empty($filters['activity'])) {
$condition .= ' AND `r`.`activity`=:activity';
$pars[':activity'] = $filters['activity'];
}
if (!empty($filters['owner'])) {
$condition .= ' AND `r`.`uid`=:owner';
$pars[':owner'] = $filters['owner'];
}
if (!empty($filters['nickname'])) {
$condition .= ' AND `f`.`nickname` LIKE :nickname';
$pars[':nickname'] = "%{$filters['nickname']}%";
}
if (!empty($filters['status'])) {
$condition .= ' AND `r`.`status`=:status';
$pars[':status'] = $filters['status'];
}
$fields = "`r`.`id`,`f`.`openid`, `f`.`proxy`, `f`.`nickname`, `f`.`gender`, `f`.`state`, `f`.`city`, `f`.`avatar`, `r`.`uid`, `r`.`activity`, `r`.`gift`, `r`.`fee`, `r`.`log`, `r`.`status`, `r`.`created`, `r`.`completed`";
$sql = "SELECT {$fields} FROM " . tablename('wwx_fxxt_red_records') . " AS `r` LEFT JOIN " . tablename('wwx_fxxt_red_fans') . " AS `f` ON (`r`.`uid` = `f`.`uid`)";
$sql .= " WHERE {$condition} ORDER BY `completed` DESC, `created` DESC";
if ($pindex > 0) {
$sql = "SELECT COUNT(*) FROM " . tablename('wwx_fxxt_red_records') . " AS `r` LEFT JOIN " . tablename('wwx_fxxt_red_fans') . " AS `f` ON (`r`.`uid` = `f`.`uid`)";
$sql .= " WHERE {$condition}";
$total = pdo_fetchcolumn($sql, $pars);
$start = ($pindex - 1) * $psize;
$sql = "SELECT {$fields} FROM" . tablename('wwx_fxxt_red_records') . " AS `r` LEFT JOIN " . tablename('wwx_fxxt_red_fans') . " AS `f` ON (`r`.`uid` = `f`.`uid`)";
$sql .= " WHERE {$condition} ORDER BY `completed` DESC, `created` DESC LIMIT {$start},{$psize}";
}
$ds = pdo_fetchall($sql, $pars);
if (!empty($ds)) {
require_once WWX_FXXT_ROOT . '/class/Gift.class.php';
require_once WWX_FXXT_ROOT . '/class/Fans.class.php';
$g = new Gift();
$f = new Fans();
foreach ($ds as &$row) {
$row['gift'] = $g->getOne($row['gift']);
/**GIFT:1.根据ID查询活动礼品分类**/
$row['profile'] = $f->getProfile($row['uid']);
/**FANS:1.根据用户UID查询用户信息**/
}
}
return $ds;
}
public function getTrades($filters, $pindex = 0, $psize = 20, &$total = 0)
{
global $_W;
$condition = '`t`.`uniacid`=:uniacid';
$pars = array();
$pars[':uniacid'] = $_W['uniacid'];
if (!empty($filters['activity'])) {
$condition .= ' AND `t`.`activity`=:activity';
$pars[':activity'] = $filters['activity'];
}
if (!empty($filters['owner'])) {
$condition .= ' AND `t`.`uid`=:owner';
$pars[':owner'] = $filters['owner'];
}
if (!empty($filters['nickname'])) {
$condition .= ' AND `f`.`nickname` LIKE :nickname';
$pars[':nickname'] = "%{$filters['nickname']}%";
}
if (!empty($filters['status'])) {
if ($filters['status'] == 'valid') {
$condition .= " AND `t`.`status`!='created'";
} else {
$condition .= ' AND `t`.`status`=:status';
$pars[':status'] = $filters['status'];
}
}
$fields = "`t`.`id`,`f`.`openid`, `f`.`proxy`, `f`.`nickname`, `f`.`gender`, `f`.`state`, `f`.`city`, `f`.`avatar`, `t`.`uid`, `t`.`activity`, `t`.`item`, `t`.`paid`, `t`.`status`, `t`.`created`, `t`.`completed`";
$sql = "SELECT {$fields} FROM " . tablename('mbrp_trades') . " AS `t` LEFT JOIN " . tablename('mbrp_fans') . " AS `f` ON (`t`.`uid` = `f`.`uid`)";
$sql .= " WHERE {$condition} ORDER BY `completed` DESC, `created` DESC";
if ($pindex > 0) {
$sql = "SELECT COUNT(*) FROM " . tablename('mbrp_trades') . " AS `t` LEFT JOIN " . tablename('mbrp_fans') . " AS `f` ON (`t`.`uid` = `f`.`uid`)";
$sql .= " WHERE {$condition}";
$total = pdo_fetchcolumn($sql, $pars);
$start = ($pindex - 1) * $psize;
$sql = "SELECT {$fields} FROM" . tablename('mbrp_trades') . " AS `t` LEFT JOIN " . tablename('mbrp_fans') . " AS `f` ON (`t`.`uid` = `f`.`uid`)";
$sql .= " WHERE {$condition} ORDER BY `completed` DESC, `created` DESC LIMIT {$start},{$psize}";
}
$ds = pdo_fetchall($sql, $pars);
if (!empty($ds)) {
require_once MB_ROOT . '/source/Fans.class.php';
$f = new Fans();
foreach ($ds as &$row) {
$row['profile'] = $f->getProfile($row['uid']);
}
}
return $ds;
}
$r['value'] = $v;
$sql = 'SELECT * FROM ' . tablename('mbrl_profiles') . ' WHERE `uniacid`=:uniacid AND `uid`=:uid AND `name`=:name';
$pars = array();
$pars[':uniacid'] = $_W['uniacid'];
$pars[':uid'] = $user['uid'];
$pars[':name'] = $k;
$exists = pdo_fetch($sql, $pars);
if (empty($exists)) {
pdo_insert('mbrl_profiles', $r);
} else {
pdo_update('mbrl_profiles', $r, array('id' => $exists['id']));
}
}
exit('success');
}
$profile = $f->getProfile($user['uid']);
if (!empty($profile)) {
exit('success');
}
}
if ($foo == 'history') {
require_once MB_ROOT . '/source/Activity.class.php';
$id = $_GPC['actid'];
$id = intval($id);
$a = new Activity();
$activity = $a->getOne($id);
if ($activity['type'] == 'game') {
$filters = array();
$filters['owner'] = $user['uid'];
$filters['activity'] = $activity['actid'];
$records = $a->getRecords($filters);
