轻松实现织梦网站数据迁移到新站点

原创
2022/01/23 09:03
阅读数 53

众所周知,织梦已经开始收费了,这对国内版权意识增强应该不算坏事,但想要免费使用又不想惹麻烦的站长们就有点麻烦了。

有不少朋友来问,我们 MyCms 支不支持织梦数据迁移,目前我们已经实现一键导入织梦的原文章和商品了,现在简要讲述一下实现过程。

一、连接数据库

要想实现数据的迁移导入,那么先要得到数据库信息,所以我们第一步就要实现填写数据库信息功能。

11.png

可以打开织梦网站的 data/common.inc.php 文件对照填写。

单次导入数据字段为执行一次导入多少量的数据,默认100条,这个可以依照自己的服务器来调整。

这一步仅仅是保存数据库信息,别无他用。

附上连接数据库代码

//$this->config 为保存的数据库信息

$dedeConnection = array_merge([
	'driver' => 'mysql',
	'charset' => 'utf8',
	'collation' => 'utf8_unicode_ci',
	'prefix' => $this->config['dede_prefix'],
], $this->config);

config(['database.connections.dedecms' => $dedeConnection]);

$this->connection = DB::connection('dedecms');

二、导入分类/文章

1.导入文章分类,并明确上下级关系。

public function articleCategory()
{
	if (!Storage::exists("dede_article_category")) {

		//导入分类
		$categories = $this->connection
			->table('arctype')->get();

		$catArray = $catParentArray = [];

		foreach ($categories as $category) {

			$cid = ArticleCategory::insert([
				'pid' => 0,
				'name' => $category->typename,
			]);

			$catArray[$category->id] = $cid;
			$catParentArray[$cid] = $category->topid;
		}

		foreach ($catParentArray as $key => $value) {

			if ($value > 0) {

				$ac = ArticleCategory::find($key);
				$ac->pid = $catArray[$value];
				$ac->save();
			}
		}

		Storage::put("dede_article_category", json_encode($catArray));

	} else {

		$catArray = json_decode(Storage::get("dede_article_category"), true);
	}

	return $catArray;
}

2.要先明确要导入文章的那些信息,然后对应好自身系统的字段,开始导入。

附上 MyCms 导入的代码给大家参考。


public function article(): JsonResponse
{
	$date = date('Y-m-d H:i:s');
       //最后导入ID
	$lastId = Storage::exists("dede_article_last_id") ? Storage::get("dede_article_last_id") : 0;

	$articles = $this->connection
		->table('archives')
		->leftJoin('addonarticle', 'aid', '=', 'id')
		->where([
			['channel', '=', 1],
			['id', '>', $lastId],
		])->limit($this->config['batch_number'])->get();

	$importLog = [];
	$catArray = $this->articleCategory();

	foreach ($articles as $article) {

		$aid = Article::insert([
			'category_id' => $catArray[$article->typeid],
			'title' => $article->title,
			'content' => $article->body,
			'description' => $article->description,
			'img' => $article->litpic,
			'author' => $article->writer,
			'view' => $article->click,
			'created_at' => date('Y-m-d H:i:s', $article->senddate),
			'updated_at' => date('Y-m-d H:i:s', $article->pubdate),
		]);

		if ($article->shorttitle) {

			$meta = [
				'article_id' => $aid,
				'meta_key' => 'short_title',
				'meta_value' => $article->shorttitle,
			];

			ArticleMeta::insert($meta);
		}

		$lastId = $article->id;

		$tagIds = (new ArticleTag)->insertTags(explode(",", trim($article->keywords, ",")));
		(new ArticleTagRel)->insertRel($aid, $tagIds);

              //导入记录
      		$importLog[] = [
			'type' => '文章',
			'oid' => $article->id,
			'mid' => $aid,
			'title' => $article->title,
			'created_at' => $date,
			'updated_at' => $date,
		];
	}

	Dedecms::insertAll($importLog);
       //写入导入最后ID
	Storage::put("dede_article_last_id", $lastId);

	return $this->result(true);
}

三、导入商品

导入商品也是一样的道理,就不多少,直接附上代码。

public function goods()
{
	$date = date('Y-m-d H:i:s');

	$lastId = Storage::exists("dede_goods_last_id") ? Storage::get("dede_goods_last_id") : 0;

	$articles = $this->connection
		->table('archives')
		->leftJoin('addonshop', 'aid', '=', 'id')
		->where([
			['channel', '=', 6],
			['id', '>', $lastId],
		])->limit($this->config['batch_number'])->get();

	$importLog = [];
	$catArray = $this->goodsCategory();

	foreach ($articles as $article) {

		$aid = Goods::insert([
			'category_id' => $catArray[$article->typeid],
			'goods_name' => $article->title,
			'content' => $article->body,
			'description' => $article->description,
			'goods_image' => $article->litpic,
			'view' => $article->click,
			'shop_price' => $article->trueprice ?: $article->price,
			'market_price' => $article->price,
			'created_at' => date('Y-m-d H:i:s', $article->senddate),
			'updated_at' => date('Y-m-d H:i:s', $article->pubdate),
		]);

		if ($article->shorttitle) {

			$meta = [
				'goods_id' => $aid,
				'meta_key' => 'short_title',
				'meta_value' => $article->shorttitle,
			];

			GoodsMeta::insert($meta);
		}

		$lastId = $article->id;

		$importLog[] = [
			'type' => '商品',
			'oid' => $article->id,
			'mid' => $aid,
			'title' => $article->title,
			'created_at' => $date,
			'updated_at' => $date,
		];
	}

	Dedecms::insertAll($importLog);

	Storage::put("dede_goods_last_id", $lastId);

	return $this->result(true);
}

最后导入成功,并记录下来。

222.png

展开阅读全文
加载中

作者的其它热门文章

打赏
0
0 收藏
分享
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部