<?php

use think\migration\Migrator;
use think\migration\db\Column;
use app\model\Permission;
use app\model\Article;
use app\model\Footprints;
class AddOldViewTimesToArticle extends Migrator
{
    public function change()
    {
         $list = Article::column('id,view_times');
        foreach($list as $key=>$val){
            $foot_where = [];
            $foot_where[] = ['pipe_type', '=', 'article'];
            $foot_where[] = ['pipe_id', '=', $val['id']];
            $alltime = Footprints::where($foot_where)->count();
            if(!empty($alltime)) $all[] = ['id'=>$val['id'],'view_times'=>$alltime];
        }
        $mod = new Article;
        $mod->saveAll($all);
    }
}
?>