/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Text::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['t_id' => $this->t_id]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'text', $this->text]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Text::find(); $pageSize = Yii::$app->session->get('pageSize', Yii::$app->params['defaultPageSize']); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => $pageSize]]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['t_id' => $this->t_id]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'text', $this->text]); return $dataProvider; }
public static function retrieve_verse($book, $chapter, $verse, $range) { //return Verse::retrieve_id($book, $chapter, $verse); //return Verse::retrieve_range_id($book, $chapter, $range); return Text::retrieve_texts(1, 2); /*return Text::table('texts') ->join('verses', 'verses.id', '=', 'texs.id') ->where('verses.Book', '=', $book) ->where('verses.Chapter', '=', $chapter) ->where('verses.Verse', '=', $verse) ->get();*/ }
/** * Parses GET request. **/ public static function parse_requests($request) { $query = $request->getQueryParameters(); if (Requests::validate_request($query)) { $bookDefault = BookChecker::return_default_book_name($query['book']); if ($bookDefault) { if ($query['verse'] === $query['closingVerse']) { //Single Verse Request $verse = Verse::retrieve_id($bookDefault, $query['chapter'], $query['verse']); $text = Text::retrieve_single_text($verse['id']); $verse['ET'] = $text[0]->ET; return $verse; } else { if ($query['verse'] < $query['closingVerse']) { //Multi-verse request // Returns an array. $verse = Verse::retrieve_id($bookDefault, $query['chapter'], $query['verse']); $range = Verse::retrieve_range_id($bookDefault, $query['chapter'], $query['closingVerse']); if ($range['id'] - $verse['id'] < 20) { // $texts is a string. $texts = Text::retrieve_multiple_texts($verse['id'], $range['id']); $return = array('book' => $verse['book'], 'chapter' => $verse['chapter'], 'verse' => $verse['verse'], 'closingChapter' => $range['chapter'], 'closingVerse' => $range['verse'], 'ET' => $texts); return $return; } else { return array('Error' => 'Cannot return a range more than 20 verses.'); } } else { if ($query['verse'] > $query['closingVerse']) { return json_encode(array('Error' => 'Invalid verse range. End of range cannot be smaller than start.')); } } } } else { return json_encode(array('Error' => 'Book unknown')); } } else { return json_encode(array('Error' => 'Request incomplete.')); } }
use yii\widgets\ActiveForm; use yii\helpers\ArrayHelper; /* @var $this yii\web\View */ $this->title = 'Victor 2016'; $webRoot = Yii::$app->getUrlManager()->getBaseUrl(); ?> <link href="<?php echo $webRoot; ?> /css/styles/<?php echo $style; ?> /style.css" rel="stylesheet"> <?php if (!empty($warning)) { ?> <div class="alert alert-warning"> <?php echo nl2br($warning); ?> </div> <?php } ?> <div class="content"> <?php echo \app\models\Text::findOne($text->t_id)->text; ?> </div>
echo Html::a('Neuer Benutzertext', ['user-text/create/' . $type], ['class' => 'btn btn-success']); ?> </p> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'ut_id', ['attribute' => 'p_id', 'filterType' => GridView::FILTER_SELECT2, 'filter' => InputHelper::getDropdownOptions('app\\models\\Group', 'p_id', 'bezeichnung', true, true), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'value' => function ($model, $key, $index, $widget) { if (!$model->p_id) { return 'Alle'; } $group = \app\models\Group::findOne($model->p_id); return $group ? $group->bezeichnung : $model->p_id; }, 'filterInputOptions' => ['placeholder' => 'Bitte wählen Sie'], 'format' => 'raw'], ['attribute' => 'b_id', 'filterType' => GridView::FILTER_SELECT2, 'filter' => InputHelper::getDropdownOptions('app\\models\\Bank', 'b_id', 'bezeichnung', true, true), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'value' => function ($model, $key, $index, $widget) { if (!$model->b_id) { return 'Alle'; } $group = \app\models\Bank::findOne($model->b_id); return $group ? $group->bezeichnung : $model->b_id; }, 'filterInputOptions' => ['placeholder' => 'Bitte wählen Sie'], 'format' => 'raw'], ['attribute' => 'l_id', 'filterType' => GridView::FILTER_SELECT2, 'filter' => InputHelper::getDropdownOptions('app\\models\\Language', 'l_id', 'name', true, true, true), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'value' => function ($model, $key, $index, $widget) { if (!$model->b_id) { return 'Default'; } $group = \app\models\Language::findOne($model->l_id); return $group ? $group->name : $model->l_id; }, 'filterInputOptions' => ['placeholder' => 'Bitte wählen Sie'], 'format' => 'raw'], ['attribute' => 't_id', 'value' => function ($model, $key, $index, $widget) { $group = \app\models\Text::findOne($model->t_id); return $group ? $group->name : $model->t_id; }, 'format' => 'raw'], ['class' => 'yii\\grid\\ActionColumn', 'template' => '{update} {delete}']]]); ?> </div>
/** * Finds the Text model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Text the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Text::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }