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