/
Vendor.php
executable file
·108 lines (93 loc) · 2.69 KB
/
Vendor.php
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
<?php
namespace backend\models\master;
use Yii;
use yii\helpers\ArrayHelper;
/**
* This is the model class for table "vendor".
*
* @property integer $id
* @property integer $type
* @property string $code
* @property string $name
* @property string $contact_name
* @property string $contact_number
* @property integer $status
* @property integer $created_at
* @property integer $created_by
* @property integer $updated_at
* @property integer $updated_by
*
* @property ProductVendor[] $productVendors
* @property Product[] $products
* @property VendorDetail $vendorDetail
*/
class Vendor extends \yii\db\ActiveRecord {
use \mdm\converter\EnumTrait;
const TYPE_SUPPLIER = 10;
const TYPE_CUSTOMER = 20;
const TYPE_INTERN = 30;
const STATUS_ACTIVE = 10;
const STATUS_INACTIVE = 0;
/**
* @inheritdoc
*/
public static function tableName() {
return '{{%vendor}}';
}
/**
* @inheritdoc
*/
public function rules() {
return [
[['type', 'code', 'name', 'status'], 'required'],
[['type', 'status', 'created_at', 'created_by', 'updated_at', 'updated_by'], 'integer'],
[['code'], 'string', 'max' => 8],
[['name', 'contact_name', 'contact_number'], 'string', 'max' => 64],
];
}
/**
* @inheritdoc
*/
public function attributeLabels() {
return [
'id' => 'ID',
'type' => 'Type',
'code' => 'Code',
'name' => 'Name',
'contact_name' => 'Contact Name',
'contact_number' => 'Contact Number',
'status' => 'Status',
'created_at' => 'Created At',
'created_by' => 'Created By',
'updated_at' => 'Updated At',
'updated_by' => 'Updated By',
];
}
public function getNmType() {
return $this->getLogical('type', 'TYPE_');
}
public function getNmStatus() {
return $this->getLogical('status', 'STATUS_');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getProductVendors() {
return $this->hasMany(ProductVendor::className(), ['vendor_id' => 'id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getProducts() {
return $this->hasMany(Product::className(), ['id' => 'product_id'])->viaTable('product_vendor', ['vendor_id' => 'id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getVendorDetail() {
return $this->hasOne(VendorDetail::className(), ['id' => 'id']);
}
public static function selectOptions() {
return ArrayHelper::map(static::find()->asArray()->all(), 'id', 'name');
}
}