I know this same question is already asked before. But I have tried the solution but it's not working for me. $comp_ids = AllowArea::find() ->select(['comp_code']) ->where(['user_id' => Yii::$app->user->id]) ->column(); $ref = (new yiidbQuery()) ->select([ 'ProductCode', 'ProductNameFull', 'ProductSpec', 'ProductGroup', 'CompanyCode', 'CompanyName'…
I have a method in the model to search and receive messages public function getAllMessages() { $allMessages = Message::find() ->where(['=', 'phone', $this->phone]) ->all(); return $allMessages; } Then I display all received messages in the view <div class="message-history"> <?php foreach ($messageModel->getAllMessages()…
i am trying to truncate a selected models from my application using deleteAll() my controller: there are a lot of models but i didn't include them for maintain as short. <?php namespace appcontrollers; use yiiwebController; use appmodelsMarks; use appmodelsActivityHistory; use…
I'm trying to open SVG file first in PHP and then return this data: $file = dirname(__FILE__) . $_GET["file"] . ".svg"; if (!file_exists($file)) { $file = dirname(__FILE__) . $_GET["file"] . ".png"; if (!file_exists($file)) { throw new NotFoundHttpException(); } else header('Content-Type:…
I am working on yii2. I have a below field in my _form $form->field($model, 'area_name') ->widget(Select2::className(),[ 'data' => commonmodelsAllowArea::toAreaArrayList(), 'options' => ['placeholder'=>'Select Area'], 'pluginOptions' => [ 'allowClear' => true, 'multiple' => true ], ]); ?> When I am trying to…
public function actionItemsenbale($organization_id) { $items = Item::updateAll(['is_rtm_enable' => SharedConstant::VALUE_ZERO])->andWhere(['organization_id' => $organization_id]); return (new ApiResponse)->success(['item' => $items]); }
I just started migrating from laravel to yii2 In Laravel, I had a moment when I checked the current route, and if we are on this page, then we leave only the text, and if not, then we make this…
My solution: $author_id = 25; $sql = "SELECT DISTINCT author_id AS label FROM users WHERE author_id ::text LIKE '%:term%' AND role = 'Editor'"; $query = Users::findbysql($sql, [ ':term' => $author_id ] )->all(); The problem is the label alias, which then…
How to break output of Listview in a new line in listview widget note
Is there any tool or programming technique to capture the output from Yii2 migrations to up/down SQL scripts, that is, print the migration corresponding raw SQL before finally running php yii migrate? For example, in Laravel you can add a…