public function getOftenById($member_id, $source = "", $con = "") { if (empty($member_id)) { return false; } $cond = ''; if ($source) { $cond = " AND source='" . $source . "' "; } $sql = "SELECT * FROM " . DB_PREFIX . "visit WHERE 1 " . $cond . " AND user_id=" . $member_id . " ORDER BY num DESC" . $con; $q = $this->db->query($sql); $member_id = $action_id = $team_id = $topic_id = ''; $member_space = $action_space = $team_space = $topic_space = ''; $info = array(); while ($row = $this->db->fetch_array($q)) { switch ($row['source']) { case 'user': $member_id .= $member_space . $row['cid']; $member_space = ","; break; case 'action': $action_id .= $action_space . $row['cid']; $action_space = ","; break; case 'team': $team_id .= $team_space . $row['cid']; $team_space = ","; break; case 'topic': $topic_id .= $topic_space . $row['cid']; $topic_space = ","; break; default: break; } $info[] = array('id' => $row['id'], 'source' => $row['source'], 'cid' => $row['cid'], 'visit_time' => $row['visit_time']); } $member_info = $action_info = $team_info = $topic_info = array(); if (!empty($member_id)) { include_once ROOT_PATH . 'lib/class/member.class.php'; $obj_member = new member(); $data = $obj_member->getMemberById($member_id); $member_info = $data[0]; } if (!empty($action_id)) { include_once ROOT_PATH . 'lib/class/activity.class.php'; $obj_activity = new activityCLass(); $data = $obj_activity->show($action_id); $action_info = $data['data']; } if (!empty($team_id)) { include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $data = $obj_team->get_team_by_id($team_id); $team_info = $data[0]; } if (!empty($topic_id)) { include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $data = $obj_team->get_topic_by_id($topic_id); $topic_info = $data[0]; } // foreach ($info as $k => $v) { switch ($v['source']) { case 'user': if (empty($member_info[$v['cid']])) { unset($info[$k]); } else { $info[$k]['data'] = $member_info[$v['cid']]; } break; case 'action': if (empty($action_info[$v['cid']])) { unset($info[$k]); } else { $info[$k]['data'] = $action_info[$v['cid']]; } break; case 'team': if (empty($team_info[$v['cid']])) { unset($info[$k]); } else { $info[$k]['data'] = $team_info[$v['cid']]; } break; case 'topic': if (empty($topic_info[$v['cid']])) { unset($info[$k]); } else { $info[$k]['data'] = $topic_info[$v['cid']]; } break; default: break; } } return $info; }
$this->addItem(true); $this->output(); } /** * 设置相册属于哪个分类 */ public function setAlbumCate() { if (!isset($this->input['cate_id']) || !$this->input['cate_id']) { $this->errorOutput(NO_CATE_ID); } if (!isset($this->input['id']) || !$this->input['id']) { $this->errorOutput(NO_ID); } $id = $this->input['id']; $cond = " WHERE id={$id}"; $params['cate_id'] = $this->input['cate_id']; include CUR_CONF_PATH . 'lib/Core.class.php'; $obj = new Core(); $datas = $obj->update('albums', $params, $cond); $this->addItem($datas); $this->output(); } /** * 获取会员信息 * @param Int|String $user_id */ private function getMemberInfo($user_id) { if ($this->input['latest']) { //新会员 include_once ROOT_PATH . 'lib/class/members.class.php';
public function get_read() { $count = intval($this->input['count']) ? intval($this->input['count']) : 0; $page = intval($this->input['pp'] ? $this->input['pp'] : 0); $end = ""; $offset = $page * $count; $user_id = intval($this->input['user_id']); $type = trim($this->input['type']); if (!$user_id) { return; } //获得已读信息,-1获取该用户全部的已读信息,否则按照类型获取已读信息 $extra = ''; if ($type > 0) { $extra = " AND type = '" . $type . "'"; } if ($type != 0) { $extra .= " AND member_id=" . $user_id; } $sql = "SELECT * FROM " . DB_PREFIX . "notify WHERE is_read = 1" . $extra; $q = $this->db->query($sql); $info = array(); $from_id = array(); while ($row = $this->db->fetch_array($q)) { $from_id[] = $row['from_id']; // $row['content'] = unserialize($row['content']); $info[] = $row; } $from_id = array_unique($from_id); $user_id = implode(',', $from_id); include_once ROOT_PATH . 'lib/class/member.class.php'; $member_obj = new member(); $member = $member_obj->getMemberById($user_id); $member = $member[0]; if (empty($member)) { $member = array(); } //得到全部信息,并且标注已读和未读 $this->setXmlNode('notifys', 'notify'); foreach ($info as $k => $v) { $v['content'] = unserialize($v['content']); $v['from'] = array('from_name' => $member[$v['from_id']]['nick_name'], 'from_avatar' => $member[$v['from_id']]['avatar']); $this->addItem($v); } $this->output(); }
public function show($cond) { $sql = "SELECT * FROM " . DB_PREFIX . "recommend WHERE 1 " . $cond; $q = $this->db->query($sql); $info = array(); $id_array = array(); while ($row = $this->db->fetch_array($q)) { $id_array[$row['source']][] = $row['cid']; $info[] = $row; } // hg_pre($id_array); $user = array(); if (!empty($id_array['user'])) { include_once ROOT_PATH . 'lib/class/member.class.php'; $obj_member = new member(); $data = $obj_member->getMemberById(implode(',', $id_array['user'])); $user = $data[0]; // hg_pre($user); } $action = array(); if (!empty($id_array['action'])) { include_once ROOT_PATH . 'lib/class/activity.class.php'; $obj_activity = new activityCLass(); $data = $obj_activity->show(implode(',', $id_array['action'])); $action = $data['data']; $team_id = $space = ''; foreach ($action as $k => $v) { $team_id .= $space . $v['team_id']; $space = ','; } if ($team_id) { include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $team_tmp = $obj_team->get_team_by_id($team_id); $team_tmp = $team_tmp[0]; foreach ($action as $k => $v) { $action[$k]['team_name'] = $team_tmp[$v['team_id']]['team_name']; } } } $team = array(); if (!empty($id_array['team'])) { include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $data = $obj_team->get_team_by_id(implode(',', $id_array['team'])); $team = $data[0]; } $topic = array(); if (!empty($id_array['topic'])) { include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $data = $obj_team->get_topic_by_id(implode(',', $id_array['topic'])); $topic = $data[0]; } $sql = "SELECT * FROM " . DB_PREFIX . "column WHERE 1"; $q = $this->db->query($sql); $column = array(); while ($row = $this->db->fetch_array($q)) { $column[$row['id']] = $row['name']; } $ret = array(); foreach ($info as $k => $v) { $tmp = ${$v}['source']; $ret[$k] = array('id' => $v['id'], 'cid' => $v['cid'], 'title' => $v['title'], 'source' => $v['source'], 'column_id' => $column[$v['column_id']], 'pubtime' => $v['pubtime'], 'data' => $tmp[$v['cid']]); } return $ret; }
} $data = array('type' => $type, 'user_id' => $this->user['user_id'], 'user_name' => $this->user['user_name'], 'unit_name' => $unit_name, 'contact_person' => $contact_person, 'contact_way' => $contact_way, 'application_note' => $application_note, 'app_name' => $this->user['display_name']); $result = $this->team->create_team_apply($data); $this->addItem($result); $this->output(); } /** * 加入黑名单|取消黑名单操作 */ public function black_list() { $team_id = intval($this->input['team_id']); //检测对应的小组是否存在 $team_info = $this->team->detail($team_id, 1); if (!$team_info) { $this->errorOutput(TEAM_NO_EXISTS); } $type = isset($this->input['op_type']) ? intval($this->input['op_type']) : -1; if ($type < 0) { $this->errorOutput(PARAM_WRONG); } $user_id = intval($this->input['user_id']); $member = new member(); $member_info = $member->getMemberById($user_id); if (!$member_info) { $this->errorOutput(PARAM_WRONG); } if ($team_info['creater_id'] == $user_id) { $this->errorOutput(PARAM_WRONG); } $data = array('team_id' => $team_id, 'user_id' => $user_id); if ($type == 1) { //获取用户类型 $user_type = $this->team->check_user_type($user_id, $team_id); //关注用户 if ($user_type['level'] == 2) { //删除关注 $option = new option(); $option->drop_relation($data['user_id'], 'team', $data['team_id'], 'attention'); } $data['join_time'] = TIMENOW; $result = $this->team->join_black_list($data); $result['join_time'] = $data['join_time'];