/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Style::find(); $pageSize = Yii::$app->session->get('pageSize', 20); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => $pageSize]]); $dataProvider->setSort(['attributes' => ['s_id', 's_b_id', 's_p_id', 'bankName' => ['asc' => ['{{%bank}}.bezeichnung' => SORT_ASC], 'desc' => ['{{%bank}}.bezeichnung' => SORT_DESC], 'label' => 'Bankenname'], 'groupName' => ['asc' => ['{{%personen}}.bezeichnung' => SORT_ASC], 'desc' => ['{{%personen}}.bezeichnung' => SORT_DESC], 'label' => 'Gruppenname'], 'style']]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['like', 'style', $this->style]); $query->joinWith(['bank' => function ($q) { $q->where('{{%bank}}.bezeichnung LIKE "%' . $this->bankName . '%"'); }]); $query->joinWith(['group' => function ($q) { $q->where('{{%personen}}.bezeichnung LIKE "%' . $this->groupName . '%"'); }]); return $dataProvider; }
public function processCode($fullCode) { $code = $fullCode['code']; $original = $fullCode['original']; if ($this->isCodeActive($code)) { $group = Group::findOne($code->z_p_id)->toArray(); $bank = Bank::findOne($code->z_b_id)->toArray(); $form = Form::findOne(['f_klasse' => $bank['klasse'], 'f_p_id' => $group['p_id']]); $style = Style::findOne(['s_b_id' => $bank['b_id'], 's_p_id' => $group['p_id']]); if (!$style) { $style = Settings::getSetting('style'); } else { $style = $style->style; } $label = Yii::$app->params['default_next_label']; $message = Yii::$app->params['default_next_message']; if ($this->language != "default") { $language = Language::findOne($this->language); if ($language != null) { if ($language->label != '') { $label = $language->label; } if ($language->message != '') { $message = $language->message; } } } Yii::$app->session['anketData'] = ['original' => $original, 'code' => $code->toArray(), 'group' => $group, 'bank' => $bank, 'form' => $form->f_id, 'status' => 0, 'lang' => $this->language, 'style' => $style, 'label' => $label, 'message' => $message]; $meta = Meta::findOne(['m_z_id' => $code->z_id]); if (!$meta) { $meta = new Meta(); $meta->m_z_id = $code->z_id; $meta->ip = $_SERVER['REMOTE_ADDR']; $meta->time_start = time(); } else { $meta->ip = $_SERVER['REMOTE_ADDR']; } $meta->save(); return true; } return false; }
public function actionStyle() { $styles = Style::find()->all(); return $this->render('style', ['model' => $styles]); }
/** * Finds the Style model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Style the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Style::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
?> :</th> <td><?php echo $model->ip; ?> </td> </tr> <tr> <th><?php echo Yii::t('app', 'DESIGN'); ?> :</th> <td> <?php echo Editable::widget(['model' => $model, 'attribute' => 'style', 'url' => $url, 'mode' => 'pop', 'type' => 'select2', 'clientOptions' => ['pk' => $model->id, 'autotext' => 'always', 'placement' => 'right', 'select2' => ['width' => '200px'], 'value' => $model->style, 'source' => \app\models\Style::getStyleArray()]]); ?> </td> </tr> <tr> <th><?php echo Yii::t('app', 'NICKNAME'); ?> </th> <td> <?php echo Editable::widget(['model' => $model, 'attribute' => 'username', 'url' => $url, 'mode' => 'pop']); ?> </td> </tr>
public function testExistDefault() { $style = Style::find()->where(['name' => 'default'])->one(); expect('name should be like search', $style->name)->equals('default'); expect('title should be like fixtures', $style->title)->equals('title-default'); }
/** * @return \yii\db\ActiveQuery */ public function getStyle() { return $this->hasOne(Style::className(), ['id' => 'style_id']); }