// $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"]."";
// }
// }
// }
快捷键:cmskuaimoxing
源:
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>cmskuaimoxing(fastadmin cms 跨模型转栏目的内容)</tabTrigger>
<scope></scope>
</snippet>
发表评论 取消回复