<?php

use app\api\model\Order;
use app\common\model\StoreDailySalesSt;
use think\facade\Db;
use think\migration\Seeder;

class GenHistoryStoreSaleVolumeSeeder 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()
    {
        Db::execute("truncate table yoshop_store_daily_sales_st");
        $m = new StoreDailySalesSt();
        $orderM =  new Order();

        $datas = [];
        $baseTo = strtotime(date("Y-m-d"),time());
        $now = time();
        for ($i=1;$i<200;$i++){
            $from = $baseTo - 86400*$i;
            $to = $from + 86399;
            $temp = [];
            $tj = $orderM->dailyStoreSaleVolumeSt($from,$to);
            $temp['sale_volume'] = $tj['sale_volume'];
            $temp['order_count'] = $tj['order_count'];
            $temp['st_time'] = date('Ymd',$to);
            $temp['st_month'] = date('Ym',$to);
            $temp['create_time'] = $now;
            $temp['update_time'] = $now;
            $datas[] = $temp;
        }
        $m->insertAll($datas);

    }
}