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; }