m151030_121905_addSumBillFunction.php
804 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?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);
}
}