Yii Framework In How To Searchbox In Dropdown Search Filter

-
Example

1-)use yii\helpers\ArrayHelper;
2-)use app\models\Registrationform;
2-)as a database modal
3-)            [
                'attribute'=>'last_name',
               // 'filter'=>ArrayHelper::map(Registrationform::find()->asArray()->all(), 'last_name', 'last_name'),
                'filter' => ArrayHelper::map(Calculation::find()->select('ArticleGroup')->distinct()->where(['not', ['ArticleGroup' => null]])->andWhere(['not', ['ArticleGroup' => '']])->orderBy(['Type' => SORT_ASC])->all(), 'ArticleGroup', 'ArticleGroup'),

                'filterInputOptions' => ['prompt' => 'last name', 'class' => 'form-control', 'id' => null],
            ],
3-)'attribute'=>'fild name ',
3)'filter'=>ArrayHelper::map(Registrationform::find()->asArray()->all(), 'DBfildNAME', 'DBfildNAME'),

Popular posts from this blog

Yii Framework In Update Time View Image In Form

-
Example [                 'attribute'=>'Image',                 'label'=>'image',                 'format'=>'html',                 'value'=>function($data)                 {                     return Html::img(Yii::$app->params['imageuploadurl'].$data['Image'],                     ['width'=>'100','height'=>'50'],['alt'=>'yii']);                 },  ],   --- Form In----  <?= $form->field($model, 'file')->fileInput() ?> <?= Html::img(Yii::$app->params['imageuploadurl'].$model->Image,['width'=>'100','height'=>'50'],['alt'=>'yii']); ?> NOTE : (...
Read more

Add a new column to existing table in a migration

-
To create a migration, you may use the migrate:make command on the Artisan CLI. Use a specific name to avoid clashing with existing models for Laravel 3: php artisan migrate : make add_paid_to_users for Laravel 5+: php artisan make : migration add_paid_to_users_table -- table = users You then need to use the  Schema::table()  method (as you're accessing an existing table, not creating a new one). And you can add a column like this: public function up () { Schema:: table ( 'user_master_transational' , function (Blueprint $table ) { $table ->string( 'vFirstName' , 25 )-> collation ( 'utf8mb4_unicode_ci' )-> nullable () -> after ( 'iUserId' );           $table ->string( 'vLastName' , 25 )-> collation ( 'utf8mb4_unicode_ci' )-> nullable () -> after ( 'iUserId' ); }); } and don't forget to add the rollback option: public function down () { Schema :: table ( 'users' ...
Read more

Ajax Toggle(on/off) on-click Update

-
example  Index : < td > < a href= "javascript:void(0)" data-toggle= "tooltip" onclick= " toggleProductStaple({{ $item -> id }},{{ $item -> is_staple }}) " > @if ( $item -> is_staple === 1 ) < i data-toggle= "tooltip" data-original-title= "Active" class= "fa fa-toggle-on text-inverse m-r-10" ></ i > @else < i data-toggle= "tooltip" data-original-title= "Inactive" class= "fa fa-toggle-off text-inverse m-r-10" ></ i > @endif </ a > </ td > function: < script > function toggleProductStaple (product_id, is_staple) { $ . ajaxSetup ({ headers : { 'X-CSRF-TOKEN' : $ ( ' meta [name="_token"]' ). attr ( 'content' ) } }); $ . ajax ({ type : "post...
Read more