4668085e
 Administrator
firs page
|
1
2
3
4
5
|
<?php
namespace common\models;
use Yii;
|
|
9bb0160d
Administrator
09.02.16
|
6
|
use yii\helpers\ArrayHelper;
|
|
4668085e
Administrator
firs page
|
7
8
9
10
11
12
13
14
15
16
|
/**
* This is the model class for table "{{%fields}}".
*
* @property integer $id
* @property string $table_name
* @property integer $table_id
* @property string $value
* @property string $field_name
* @property string $field_type
|
|
70abf3e7
Administrator
add field v.1
|
17
18
19
|
* @property string $language
* @property string $parent_key
* @property string $key
|
|
4668085e
Administrator
firs page
|
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
*/
class Fields extends \yii\db\ActiveRecord
{
/**
* @inheritdoc
*/
public static function tableName()
{
return '{{%fields}}';
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[['table_name', 'table_id',], 'required'],
|
|
70abf3e7
Administrator
add field v.1
|
38
39
|
[['table_id','parent_key','key'], 'integer'],
[['table_name', 'value', 'field_name','field_type','language'], 'string', 'max' => 255]
|
|
4668085e
Administrator
firs page
|
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
'id' => 'ID',
'table_name' => 'Model Name',
'table_id' => 'Model ID',
'value' => 'Value',
'field_name' => 'Field Name',
'language' => 'Language',
];
}
public static function getData($id, $model, $type){
|
|
9bb0160d
Administrator
09.02.16
|
59
|
$data = ArrayHelper::toArray(self::find()->where(['table_id'=>$id, 'table_name'=>$model, 'field_type'=>$type])->all());
|
|
4f404e20
Administrator
09.02.16
|
60
61
62
63
|
$result = [];
for($i=0; $i < count($data); $i ++){
$result[$data[$i]['parent_key']][$data[$i]['field_name']] = $data[$i]['value'];
}
|
|
9bb0160d
Administrator
09.02.16
|
64
|
|
|
4f404e20
Administrator
09.02.16
|
65
|
return $result;
|
|
4668085e
Administrator
firs page
|
66
|
}
|
|
70abf3e7
Administrator
add field v.1
|
67
68
69
70
71
72
73
74
75
76
77
|
/**
* @param $post - array with field data
* @param $table_id - row id in model table
* @param $table_name - madel table name
* @param $language - language id
*/
public static function saveFieldData($post,$table_id,$table_name, $language){
|
766bd93b
 Yarik
test
|
78
|
self::deleteAll(['table_id'=>$table_id, 'table_name'=>$table_name, 'language' => $language, 'field_type' => array_keys($post)]);
|
|
70abf3e7
Administrator
add field v.1
|
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
|
if($post){
foreach($post as $k => $field){
foreach($field as $parent_key => $row){
foreach($row as $key => $value){
$field_model = new Fields();
$field_model->field_name = array_keys($value)[0];
$field_model->value = $value[array_keys($value)[0]];
$field_model->table_name = $table_name;
$field_model->table_id = $table_id;
$field_model->field_type = $k;
$field_model->language = 'ru';
$field_model->parent_key = $parent_key;
$field_model->key = $key;
$field_model->save();
}
}
}
}
}
|
|
3d0e6093
Administrator
15.02.16
|
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
/**
* @param $post - array with field data
* @param $table_id - row id in model table
* @param $table_name - madel table name
* @param $language - language id
*/
public static function saveFieldVideoData($post,$table_id,$table_name, $language){
self::deleteAll(['table_id'=>$table_id, 'table_name'=>$table_name, 'language' => $language, 'field_type' => array_keys($post)]);
if($post){
foreach($post as $k => $field){
foreach($field as $parent_key => $row){
foreach($row as $key => $value){
preg_match('/src=\"(.[^"]*)\"/', $value[array_keys($value)[0]], $video_url);
if(isset($video_url[1]) && !empty($video_url[1])){
$field_model = new Fields();
$field_model->field_name = array_keys($value)[0];
$field_model->value = $video_url[1].'?showinfo=0&autoplay=0';
$field_model->table_name = $table_name;
$field_model->table_id = $table_id;
$field_model->field_type = $k;
$field_model->language = 'ru';
$field_model->parent_key = $parent_key;
$field_model->key = $key;
$field_model->save();
}
}
}
}
}
}
|
|
4668085e
Administrator
firs page
|
155
|
}
|
