/** * 导入标签,如果指定了天数,则就从指定前几天,如果没有指定天数,则从上一次插入的时间开始 * @param LJL_Request $input * @param unknown $database */ private function importTag(LJL_Request $input, $database) { $db = Db_Blog::instance(null, $database); if ($input->get('day')) { $day = $input->get('day') ? $input->get('day') : 1; //默认1天 $fromInsertTime = SYSTEM_TIME - $day * 24 * 3600; } else { $sql = "select updateTime from blog_tags order by id desc limit 1"; $fromInsertTime = $db->getOne($sql); $fromInsertTime = $fromInsertTime ? $fromInsertTime : 0; } //获取总数 $sql = "select count(*) from blog_article_info where isPublished=1 and updateTime>{$fromInsertTime}"; $count = $db->getOne($sql); $page = 1; $pageSize = 100; $totalPage = ceil($count / $pageSize); while ($totalPage >= $page) { $articleInfo = Helper_Blog::getArticleList(array('page' => $page, 'pageSize' => $pageSize, 'fields' => array('id', 'cate', 'tags'), 'updateTime' => $fromInsertTime)); if ($articleInfo) { foreach ($articleInfo as $val) { if (!$val['tags']) { continue; } $tagArr = explode(',', trim(trim($val['tags'], ' '), ',')); foreach ($tagArr as $tag) { Helper_Blog::insertTag(array('insertData' => array('articleId' => $val['id'], 'cate' => $val['cate'], 'tag' => $tag, 'updateTime' => SYSTEM_TIME))); } } } $page++; } echo $database . ' tags import over' . PHP_EOL; }