Report.php
3.86 KB
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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php
namespace frontend\models;
/**
* This is the model class for table "report".
*
* @property integer $id
* @property integer $intellectual_property_id
* @property string $title
* @property string $artist
* @property string $music_author
* @property string $text_author
* @property integer $time
* @property integer $total_time
* @property double $royalty
* @property integer $count
* @property string $user
* @property float $sum
* @property IntellectualProperty $intellectualProperty
*/
class Report extends \yii\db\ActiveRecord
{
/**
* @inheritdoc
*/
public static function tableName()
{
return 'report';
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[
[
'intellectual_property_id',
'time',
'total_time',
'count',
],
'integer',
],
[
[
'royalty',
'sum',
],
'number',
],
[
[
'title',
'artist',
'music_author',
'text_author',
'user',
],
'string',
'max' => 255,
],
[
[ 'intellectual_property_id' ],
'exist',
'skipOnError' => true,
'targetClass' => IntellectualProperty::className(),
'targetAttribute' => [ 'intellectual_property_id' => 'id' ],
],
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
'id' => 'ID',
'intellectual_property_id' => 'Твір',
'title' => 'Title',
'artist' => 'Виконавець',
'music_author' => 'Music Author',
'text_author' => 'Text Author',
'time' => 'Time',
'total_time' => 'Total Time',
'royalty' => 'Royalty',
'count' => 'Кількість сповіщень',
'sum' => 'Перерахована сума',
'user' => 'Користувач',
];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getIntellectualProperty()
{
return $this->hasOne(IntellectualProperty::className(), [ 'id' => 'intellectual_property_id' ]);
}
public function afterSave($insert, $changedAttributes)
{
if (!empty( $property = IntellectualProperty::findOne($this->intellectual_property_id) )) {
var_dump($property); die();
$sum = 0;
foreach ($property->reports as $report) {
$sum += $report->sum;
}
$property->calculated = $property->percent * $sum / 100;
$property->save(true, [ 'calculated' ]);
}
parent::afterSave($insert, $changedAttributes);
}
}