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