public function delete($cid, $source) { $info = array('cid' => $cid, 'source' => $source); if (empty($info['cid']) && $info['source']) { return false; } $sql = "DELETE FROM " . DB_PREFIX . "visit WHERE cid IN(" . $info['cid'] . ") AND source='" . $info['source'] . "'"; $this->db->query($sql); $sql = "DELETE FROM " . DB_PREFIX . "visit_queue WHERE cid IN(" . $info['cid'] . ") AND source='" . $info['source'] . "'"; $this->db->query($sql); switch ($info['source']) { case 'user': include_once ROOT_PATH . 'lib/class/member.class.php'; $obj_member = new member(); $obj_member->add_visit($info['cid'], -1); break; case 'action': include_once ROOT_PATH . 'lib/class/activity.class.php'; $obj_activity = new activityCLass(); $obj_activity->updateAddData(array('scan_num' => -1, 'action_id' => $info['cid'])); break; case 'team': include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $obj_team->update_total(array('visit_num' => -1, 'team_id' => $info['cid'])); break; case 'topic': include_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $obj_team->update_topic_views(array('view_num' => -1, 'topic_id' => $info['cid'])); break; default: break; } return true; }
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; }
$mark = new mark(); $markData = array('source' => 'topic', 'source_id' => $topic_ids, 'state' => $state, 'type_state' => 'team'); $mark->update_mark_state($markData); if ($state == 0) { //删除话题搜索 $this->teamApi->delete_search($topic_ids, 'topic'); } elseif ($state == 1) { //插入话题搜索 $this->teamApi->add_search($topic_ids, 'topic'); } //删除话题 $this->topic->update(array('state' => $state, 'type_state' => 'team'), $topic_ids); } } /** * 删除小组所有信息 * @param String $ids */ public function real_del() { $team_ids = trim(urldecode($this->input['team_id'])); //删除小组的关注 $option = new option(); $attenData = array('source' => 'team', 'source_id' => $team_ids, 'action' => 'attention'); $option->delete($attenData); //删除小组的标签 $mark = new mark(); $markData = array('source' => 'team', 'source_id' => $team_ids, 'action' => 'team_tag'); $mark->delete_source_id_mark($markData); //删除小组的主题标签 $themeMarkData = array('source' => 'team', 'source_id' => $team_ids, 'action' => 'team_theme'); $mark->delete_source_id_mark($themeMarkData); //删除小组下的行动召集者 $this->team->del_apply($team_ids); //删除小组下的黑名单
public function import() { $source = $this->input["source"] ? trim($this->input["source"]) : 'user'; switch ($source) { case 'user': require_once ROOT_PATH . 'lib/class/member.class.php'; $obj_member = new member(); $ret = $obj_member->show(-1); if (!empty($ret)) { $sql = "DELETE FROM " . DB_PREFIX . "search_queue WHERE source='" . $source . "'"; $this->db->query($sql); $sql = "INSERT IGNORE INTO " . DB_PREFIX . "search_queue(cid,source,state) VALUES"; $space = ""; foreach ($ret as $v) { $sql .= $space . "(" . $v['id'] . ",'" . $source . "',0)"; $space = ','; } $this->db->query($sql); echo "用户完成插入队列"; } else { echo "暂无用户数据"; } break; case 'team': require_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $ret = $obj_team->show(-1); if (!empty($ret)) { $sql = "DELETE FROM " . DB_PREFIX . "search_queue WHERE source='" . $source . "'"; $this->db->query($sql); $sql = "INSERT IGNORE INTO " . DB_PREFIX . "search_queue(cid,source,state) VALUES"; $space = ""; foreach ($ret as $v) { $sql .= $space . "(" . $v['team_id'] . ",'" . $source . "',0)"; $space = ','; } $this->db->query($sql); echo "小组完成插入队列"; } else { echo "暂无小组数据"; } break; case 'action': require_once ROOT_PATH . 'lib/class/activity.class.php'; $obj_activity = new activityCLass(); $ret_tmp = $obj_activity->show_all(); $ret = $ret_tmp['data']; if (!empty($ret)) { $sql = "DELETE FROM " . DB_PREFIX . "search_queue WHERE source='" . $source . "'"; $this->db->query($sql); $sql = "INSERT IGNORE INTO " . DB_PREFIX . "search_queue(cid,source,state) VALUES"; $space = ""; foreach ($ret as $v) { $sql .= $space . "(" . $v['action_id'] . ",'" . $source . "',0)"; $space = ','; } $this->db->query($sql); echo "行动完成插入队列"; } else { echo "暂无行动数据"; } break; case 'topic': require_once ROOT_PATH . 'lib/class/team.class.php'; $obj_team = new team(); $ret = $obj_team->show_topic(-1); if (!empty($ret)) { $sql = "DELETE FROM " . DB_PREFIX . "search_queue WHERE source='" . $source . "'"; $this->db->query($sql); $sql = "INSERT IGNORE INTO " . DB_PREFIX . "search_queue(cid,source,state) VALUES"; $space = ""; foreach ($ret as $v) { $sql .= $space . "(" . $v['topic_id'] . ",'" . $source . "',0)"; $space = ','; } $this->db->query($sql); echo "讨论完成插入队列"; } else { echo "暂无讨论数据"; } break; default: break; } }