$tids=[105,106,107,108,109,110,111]; //需要转换的栏目ID
$form=[1,"cms_addonhangye"]; //源模型id及表名
$to=[2,"cms_addonfuwu"];//目标模型id及表名
$arcrow = db("cms_archives")->where("channel_id","in",$tids)->select();
db("cms_channel")->where("id","in",$tids)->update(["model_id"=>$to[0]]);
foreach ($arcrow as $key => $v) {
db("cms_archives")->where("id",$v['id'])->update(["model_id"=>$to[0]]); //设置文档模型为目标模型ID
$addarc=db($form[1])->where("id",$v['id'])->find();
$res=db($to[1])->insert($addarc);
echo "找到".$addarc["id"]."";
if($res){
echo "插入成功".$addarc["id"]."";
$del=db($form[1])->where("id",$v['id'])->delete();
if($del){
echo "删除成功".$addarc["id"]."";
}
}
}
快捷键:gaimoxing
源:
sublime_text格式
<snippet>
<content><![CDATA[
\$tids=[105,106,107,108,109,110,111]; //需要转换的栏目ID
\$form=[1,"cms_addonhangye"]; //源模型id及表名
\$to=[2,"cms_addonfuwu"];//目标模型id及表名
\$arcrow = db("cms_archives")->where("channel_id","in",\$tids)->select();
db("cms_channel")->where("id","in",\$tids)->update(["model_id"=>\$to[0]]);
foreach (\$arcrow as \$key => \$v) {
db("cms_archives")->where("id",\$v['id'])->update(["model_id"=>\$to[0]]); //设置文档模型为目标模型ID
\$addarc=db(\$form[1])->where("id",\$v['id'])->find();
\$res=db(\$to[1])->insert(\$addarc);
echo "找到".\$addarc["id"]."";
if(\$res){
echo "插入成功".\$addarc["id"]."";
\$del=db(\$form[1])->where("id",\$v['id'])->delete();
if(\$del){
echo "删除成功".\$addarc["id"]."";
}
}
}
]]></content>
<tabTrigger>gaimoxing(fastadmin 栏目修改模型,改模型)</tabTrigger>
<scope></scope>
</snippet>
发表评论 取消回复