lachang/database/seeds/AddGoodsSalesRankSeeder.php

<?php

use app\api\model\OrderGoods;
use \app\common\model\GoodsSalesRank;
use think\migration\Seeder;

class AddGoodsSalesRankSeeder extends Seeder
{
    /**
     * Run Method.
     *
     * Write your database seeder using this method.
     *
     * More information on writing seeders is available here:
     * http://docs.phinx.org/en/latest/seeding.html
     */
    public function run()
    {
        $m = new GoodsSalesRank();
        $orderGood =  new OrderGoods();

        $data = [];
        $baseTo = strtotime(date("Y-m-d"),time());
        $now = time();
        for ($i=1;$i<180;$i++){
            $from = $baseTo - 86400*$i;
            $to = $from + 86399;
            $temp = [];
            $tj = $orderGood->addGoodsSalesRank($from,$to);
            if($tj){
                foreach ($tj as $item){
                    $temp['sale_volume'] = $item['sale_volume'];
                    $temp['sale_nums'] = $item['sale_nums'];
                    $temp['goods_id'] = $item['goods_id'];
                    $temp['start_time'] = $from;
                    $temp['end_time'] = $to;
                    $temp['create_time'] = $now;
                    $temp['update_time'] = $now;
                    $data[] = $temp;
                }
            }
        }
        $m->insertAll($data);
    }
}