$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>
点赞(0)

评论列表 共有 0 条评论

暂无评论
立即
投稿
发表
评论
返回
顶部