Executes query and returns all results as an array.
public all ( |
||
$db | the DB connection used to create the DB command. If null, the DB connection returned by [[modelClass]] will be used. | |
return | array | |
the query results. If the query results in nothing, an empty array will be returned. |
/** * @inheritdoc */ public function run() { $countQuery = clone $this->query; $pagination = new \yii\data\Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $this->pageSize]); $this->query->offset($pagination->offset)->limit($pagination->limit); return $this->render("userListBox", ['title' => $this->title, 'users' => $this->query->all(), 'pagination' => $pagination]); }
/** * @inheritdoc */ public function run() { $result = []; $class = $this->relation->modelClass; $form = $this->form; $template = '<div class="template">' . $this->render($this->viewName, ['model' => new $class(), 'form' => $this->form, 'index' => 'myindex']) . '</div>'; $items = $this->items ?: $this->relation->all(); foreach ($items as $index => $model) { $result[] = $this->render($this->viewName, compact('index', 'model', 'form')); } $result[] = Html::a(\Yii::t('app', ' Add'), '#', ['class' => 'btn btn-success glyphicon glyphicon-plus', 'template' => $template, 'onclick' => ' $(this).before($(this).attr("template").replace(/myindex/g, "new-"+Date.now())); return false;']); return implode('', $result); }
/** * 拿到属于用户的所有,返回数组 * @param [type] $userID [description] * @param [type] $db [description] * @return [type] [description] */ public function allOfUser($userID, $db = null) { $this->where(['user_id' => $userID]); $this->orderBy('price ASC'); $this->asArray(); return parent::all($db); }
protected function fillModels() { $models = $this->dataProvider ? $this->dataProvider->getModels() : $this->query->all(); foreach ($models as $model) { $this->_models[] = new Model(['instance' => $model, 'standardModel' => $this->_standardModels[0]]); } }
public function allOfProduct($productID, $db = null) { $this->where(['product_id' => $productID]); $this->indexBy('ebay_account_id'); $this->asArray(); return parent::all($db); }
/** * @inheritdoc * @return Comment[]|array */ public function all($db = null) { $result = parent::all($db); if (!$this->loadComments) { return $result; } return $this->buildCommentsHierarchy($result); }
public function allOfEbay($ebayID, $db = null) { //$this->select(['*','COUNT(*)']); $this->where(['ebay_account_id' => $ebayID]); $this->orderBy('updated_at DESC'); //最新的在第一个 //$this->asArray(); return parent::all($db); }
/** * @inheritdoc */ public function all($db = null) { $rows = parent::all($db); if (count($rows) > 0 && $this->isMappableQuery()) { /** @var ActiveRecord|ActiveRecordTrait $className */ $className = $this->modelClass; $className::addRowsToMap($rows); } return $rows; }
public function run() { Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $this->init(); $wallEntries = $this->activeQuery->all(); $output = ""; $generatedWallEntryIds = array(); $lastEntryId = ""; foreach ($wallEntries as $wallEntry) { $underlyingObject = $wallEntry->content->getPolymorphicRelation(); if ($underlyingObject === null) { throw new Exception('Could not get contents underlying object!'); } $underlyingObject->populateRelation('content', $wallEntry->content); $output .= $this->controller->renderAjax('@humhub/modules/content/views/layouts/wallEntry', ['entry' => $wallEntry, 'user' => $underlyingObject->content->user, 'mode' => $this->mode, 'object' => $underlyingObject, 'content' => $underlyingObject->getWallOut()], true); $generatedWallEntryIds[] = $wallEntry->id; $lastEntryId = $wallEntry->id; } return ['output' => $output, 'lastEntryId' => $lastEntryId, 'counter' => count($wallEntries), 'entryIds' => $generatedWallEntryIds]; }
/** * This method loads and maps models optionally with additional data-attributes for dropdown-lists. You can use it * like this: * * <code> * <?php * $rateData = DropdownHelper::fetchItemsWithData(Rate::find()->orderTitle(), 'id', 'title', ['currency','per_hour','per_km']); * ?> * <?= $form->field($model, 'rate_id')->dropDownList($rateData['items'], ['prompt'=>Yii::t('app', 'Choose one...'), 'options'=>$rateData['itemOptions']]) ?> * </code> * * @param \yii\db\ActiveQuery $query the prepared query to fetch the data for * @param string $from the attribute to map from (usually the id of the model) * @param string $to the attribute to map to (usually something like `name`). Note that this can also be a closure * with the signature `function ($model)` returning a string * @param string[] $dataAttributes list of model attributes which will be loaded as additional `data-XXX` fields * for the dropdown-options * @return array an array with the keys `items` and `itemOptions`. The first contains the items for the dropdown * and second their additional data-options if specified */ public static function fetchItemsWithData($query, $from, $to, $dataAttributes = []) { /* @var $models \yii\db\ActiveRecord[] */ //prepare returned vars $items = []; $itemOptions = []; //load data $models = $query->all(); //iterate foreach ($models as $model) { //item $valFrom = $model->{$from}; $valTo = $to instanceof \Closure ? call_user_func($to, $model) : $model->{$to}; $items[$valFrom] = $valTo; //check if there are item options or continue if (empty($dataAttributes)) { continue; } //fetch item options $itemOptions[$valFrom] = []; foreach ($dataAttributes as $dataAttr) { if (!isset($itemOptions[$valFrom]['data'])) { $itemOptions[$valFrom]['data'] = []; } //prepare $parts = explode('.', $dataAttr); $identifier = implode('-', $parts); //fetch value $valOrObj = $model; foreach ($parts as $part) { $valOrObj = $valOrObj->{$part}; } //set options $itemOptions[$valFrom]['data'][$identifier] = $valOrObj instanceof Object || is_array($valOrObj) ? Json::encode($valOrObj) : $valOrObj; } } //return return ['items' => $items, 'itemOptions' => $itemOptions]; }
public function formattedAll($format, $params, $db = null) { if (is_string($params)) { $params = ['valueColumn' => $params]; } $keyColumn = ArrayHelper::getValue($params, 'keyColumn', 'id'); $valueColumn = ArrayHelper::getValue($params, 'valueColumn'); if (!$valueColumn) { throw new InvalidConfigException("'valueColumn' must be set if format was choosen."); } $rows = parent::all($db); if ($format === self::DROP_DOWN) { return ArrayHelper::map($rows, $keyColumn, $valueColumn); } if ($format === self::DEP_DROP_AJAX) { $output = []; foreach ($rows as $row) { $output[] = ['id' => $row[$keyColumn], 'name' => $row[$valueColumn]]; } return ['output' => $output, 'selected' => ArrayHelper::getValue($params, 'selected')]; } throw new InvalidConfigException('Invalid format was choosen'); }
/** * @inheritdoc * @return Progressjobdetail[]|array */ public function all($db = null) { return parent::all($db); }
public function getWallEntries() { return $this->activeQuery->all(); }
/** * @inheritdoc * @return \app\models\activeRecords\Log[]|array */ public function all($db = null) { $this->orderBy('log_time DESC'); return parent::all($db); }
public function allOfCurrentUser($db = null) { $this->where(['user_id' => Yii::$app->user->id]); return parent::all($db); }
/** * @return array|\yii\db\ActiveRecord[] */ public function findAll() { $this->query->limit($this->limit); return $this->query->all(); }