qimall/console/migrations/M240822013246FixQimallCensusMallSingleHour.php

<?php

namespace app\migrations;

use common\models\census\CensusMallSingleHour;
use common\models\mall\Mall;
use yii\db\Migration;

/**
 * Class M240822013246FixQimallCensusMallSingleHour
 */
class M240822013246FixQimallCensusMallSingleHour extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $dates = [];
        for ($i=0;$i<=7;$i++){
            $dates[] = date('Y-m-d',strtotime("-$i day"));
        }
        $obj = new CensusMallSingleHour();
        foreach ($dates as $date){
            $start_time = strtotime($date . ' 00:00:00');
            $end_time = strtotime($date . ' 23:59:59');

            if (!empty($mall_id)) {
                $mall = Mall::findOne(['id' => $mall_id]);
                if ($mall) {
                    $obj->fixPayOrdersNumByHour($mall['id'], $date, $start_time, $end_time);
                    $obj->fixAddPayOrdersByHour($mall['id'], $date, $start_time, $end_time);
                    $obj->fixAddPayPeopleNumsByHour($mall['id'], $date, $start_time, $end_time);

                }
            } else {
                $mall_list = Mall::getEnableMallList(true);
                foreach ($mall_list as $mall) {
                    $obj->fixPayOrdersNumByHour($mall['id'], $date, $start_time, $end_time);
                    $obj->fixAddPayOrdersByHour($mall['id'], $date, $start_time, $end_time);
                    $obj->fixAddPayPeopleNumsByHour($mall['id'], $date, $start_time, $end_time);
                }
            }
        }
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M240822013246FixQimallCensusMallSingleHour cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M240822013246FixQimallCensusMallSingleHour cannot be reverted.\n";

        return false;
    }
    */
}