<?php

use yii\db\Migration;

/**
 * Class m151030_121905_addSumBillFunction
 * добавляем функцию расчета суммы заказа
 */
class m151030_121905_addSumBillFunction extends Migration
{

    public function safeUp()
    {
        $sum_count = <<< MySQL
                CREATE FUNCTION SumBill(p_bill_id int) RETURNS DECIMAL(12,2)
                BEGIN
                    DECLARE _sum DECIMAL(12,2);

                    select round(sum(`count`*`price`),2) into _sum From w_cart where bill_id = p_bill_id;

                 RETURN (_sum);
                END
MySQL;

        $this->execute($sum_count);

    }

    public function safedown()
    {

        $sum_count = <<< MySQL
               drop FUNCTION SumBill;
MySQL;

        $this->execute($sum_count);

    }


}