public function checkbind()
{
try {
$platform_id = $this->input['platform_id'];
$type = $this->input['type'];
$identifierUserSystem = new identifierUserSystem();
$identifier = $identifierUserSystem->setIdentifier((int) $this->input['identifier'])->checkIdentifier();
//多用户系统
$check_Bind = new check_Bind();
$member_id = $check_Bind->bind_to_memberid($platform_id, $type, true, $identifier);
$is_bind = $check_Bind->check_bind($member_id, $type, 0);
if ($is_bind) {
$Members = new members();
$is_bind = array_merge($is_bind, $Members->get_member_info(' AND member_id = ' . $member_id, 'member_name,type'));
}
if (is_array($is_bind)) {
foreach ($is_bind as $k => $v) {
$this->addItem_withkey($k, $v);
}
} else {
$this->addItem_withkey('is_bind', $is_bind);
}
$this->output();
} catch (Exception $e) {
$this->errorOutput($e->getMessage(), $e->getCode());
}
}
public function show_win_info_more()
{
$id = intval($this->input['id']);
if (!$id) {
$this->errorOutput('活动id不存在');
}
$pp = $this->input['page'] ? intval($this->input['page']) : 1;
//如果没有传第几页，默认是第一页
$count = $this->input['count'] ? intval($this->input['count']) : 12;
$offset = intval(($pp - 1) * $count);
$limit = ' LIMIT ' . $offset . ' , ' . $count;
$orderby = ' ORDER BY red_bag DESC,create_time ASC ';
$sql = "SELECT * FROM " . DB_PREFIX . "win_info WHERE tv_interact_id = " . $id . $orderby . $limit;
$q = $this->db->query($sql);
$member_id = array();
while ($r = $this->db->fetch_array($q)) {
$r['create_time'] = date('Y-m-d H:i', $r['create_time']);
$info[] = $r;
$member_id[] = $r['member_id'];
}
if (!empty($member_id)) {
include_once ROOT_DIR . 'lib/class/members.class.php';
$obj = new members();
$member_id = implode(',', $member_id);
$member_info = array();
$member_info_tmp = array();
$member_info_tmp = $obj->get_member_info($member_id);
if (!empty($member_info_tmp)) {
$size = '82x62/';
foreach ($member_info_tmp as $val) {
$member_info[$val['member_id']]['member_name'] = $val['member_name'];
if (!empty($val['avatar'])) {
$member_info[$val['member_id']]['avatar'] = hg_material_link($val['avatar']['host'], $val['avatar']['dir'], $val['avatar']['filepath'], $val['avatar']['filename'], $size);
} else {
$member_info[$val['member_id']]['avatar'] = array();
}
$member_info[$val['member_id']]['phone_num'] = $val['mobile'];
}
}
}
if (!empty($info)) {
foreach ($info as $val) {
foreach ($val as $k => $v) {
if ($k == 'member_id' && $member_info[$v]) {
$val['member_name'] = $member_info[$v]['member_name'];
$val['phone_num'] = $member_info[$v]['phone_num'];
$val['avatar'] = $member_info[$v]['avatar'];
}
}
$ret[] = $val;
}
}
//分页信息
$sql = 'SELECT COUNT(*) AS total FROM ' . DB_PREFIX . 'win_info WHERE 1 AND tv_interact_id = ' . $id;
$re = $this->db->query_first($sql);
$total_num = $re['total'];
//总的记录数
//总页数
if (intval($total_num % $count) == 0) {
$return['total_page'] = intval($total_num / $count);
} else {
$return['total_page'] = intval($total_num / $count) + 1;
}
$return['total_num'] = $total_num;
//总的记录数
$return['page_num'] = $count;
//每页显示的个数
$return['current_page'] = $pp;
//当前页码
$data['info'] = $ret;
$data['page_info'] = $return;
$this->addItem($data);
$this->output();
}
public function get_win_info()
{
$tv_interact_id = intval($this->input['tv_interact_id']);
if (!$tv_interact_id) {
$this->errorOutput(NOID);
}
$offset = $this->input['offset'] ? intval($this->input['offset']) : 0;
$count = $this->input['count'] ? intval($this->input['count']) : 10;
$limit = ' LIMIT ' . $offset . ' , ' . $count;
$sql = "SELECT * FROM " . DB_PREFIX . "win_info WHERE tv_interact_id = " . $tv_interact_id . " ORDER BY create_time DESC LIMIT 0," . $count;
$q = $this->db->query($sql);
$info = array();
$member_id = array();
while ($r = $this->db->fetch_array($q)) {
$r['create_time'] = date('Y-m-d H:i:s', $r['create_time']);
$member_id[] = $r['member_id'];
$info[] = $r;
}
if (!empty($member_id)) {
include_once ROOT_PATH . 'lib/class/members.class.php';
$obj = new members();
$member_id = implode(',', $member_id);
$member_info = array();
$member_info_tmp = array();
$member_info_tmp = $obj->get_member_info($member_id);
if (!empty($member_info_tmp)) {
$size = '30x30/';
foreach ($member_info_tmp as $val) {
$member_info[$val['member_id']]['member_name'] = $val['member_name'];
if (!empty($val['avatar'])) {
$member_info[$val['member_id']]['avatar'] = hg_material_link($val['avatar']['host'], $val['avatar']['dir'], $val['avatar']['filepath'], $val['avatar']['filename'], $size);
} else {
$member_info[$val['member_id']]['avatar'] = array();
}
$member_info[$val['member_id']]['phone_num'] = $val['mobile'];
}
}
}
if (!empty($info) && $member_info) {
$win_info = array();
foreach ($info as $val) {
foreach ($val as $k => $v) {
if ($k == 'member_id' && $member_info[$v]) {
$val['member_name'] = $member_info[$v]['member_name'];
$val['phone_num'] = $member_info[$v]['phone_num'];
$val['avatar'] = $member_info[$v]['avatar'];
}
}
$this->addItem($val);
}
}
$this->output();
}
public function get_memberInfo($member_id)
{
if (empty($member_id)) {
return FALSE;
}
include_once ROOT_DIR . 'lib/class/members.class.php';
$obj = new members();
$member_id = implode(',', $member_id);
$member_info = array();
$member_info_tmp = array();
$member_info_tmp = $obj->get_member_info($member_id);
if (!empty($member_info_tmp)) {
$size = '30x30/';
foreach ($member_info_tmp as $val) {
$member_info[$val['member_id']]['member_name'] = $val['member_name'];
if (!empty($val['avatar'])) {
$member_info[$val['member_id']]['avatar'] = hg_material_link($val['avatar']['host'], $val['avatar']['dir'], $val['avatar']['filepath'], $val['avatar']['filename'], $size);
} else {
$member_info[$val['member_id']]['avatar'] = array();
}
$member_info[$val['member_id']]['phone_num'] = $val['mobile'];
}
}
return $member_info;
}
