CREATE TABLE `resume` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL COMMENT 'คำนำหน้า',
  `fistname` varchar(255) DEFAULT NULL COMMENT 'ชื่อ',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'นามสกุล',
  `education_level` int(11) DEFAULT NULL COMMENT 'การศึกษา',
  `marital_status` int(11) DEFAULT NULL COMMENT 'สถานะสมรส',
  `sex` int(11) DEFAULT NULL COMMENT 'เพศ',
  `skill` varchar(10) DEFAULT NULL COMMENT 'ทักษะ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

class Resume extends \yii\db\ActiveRecord
{

const SEX_MEN = 1;
const SEX_WOMEN = 2;
// ...

$model = Resume::find()->where('sex=:sex',[':sex'=>1])->all();

$model = Resume::find()->where('sex=:sex',[':sex'=>Resume::SEX_MEN])->all();

<?php

class Resume extends \yii\db\ActiveRecord
{

const SEX_MEN = 1;
const SEX_WOMEN = 2;

// ...

public static function itemsAlias($key){

  $items = [
    'sex'=>[
      self::SEX_MEN => 'ชาย',
      self::SEX_WOMEN => 'หญิง'
    ],
    'title'=>[
      1 => 'นาย',
      2 => 'นางสาว',
      3 => 'นาง'
    ],
    'marital'=>[
      1 => 'โสด',
      2 => 'สมรส',
      3 => 'เป็นหม้าย',
      4 => 'หย่าร้าง'
    ],
    'education'=>[
      1 => 'ต่ำกว่ามัธยมศึกษาตอนต้น',
      2 => 'มัธยมศึกษาตอนต้น',
      3 => 'ปวช',
      4 => 'มัธยมศึกษาตอนปลาย',
      5 => 'ปวส',
      6 => 'อนุปริญญา',
      7 => 'ปริญญาตรี',
      8 => 'ปริญญาโท',
      9 => 'ปริญญาเอก'
    ],
    'skill'=>[
      'php' => 'PHP',
      'js' => 'JavaScript',
      'css' => 'CSS',
      'html5' => 'Html5',
      'angularjs' => 'AngularJs',
      'node.js' => 'Node.Js',
      'reactjs' => 'ReactJs',
      'go'=>'Go',
      'ruby'=>'ruby on rails',
      'swiff' => 'Swiff',
      'android' => 'Android',
  ]
];
  return ArrayHelper::getValue($items,$key,[]);
  //return array_key_exists($key, $items) ? $items[$key] : [];
}

<?php

public function getItemSex()
{
  return self::itemsAlias('sex');
}

public function getItemMarital()
{
  return self::itemsAlias('marital');
}

public function getItemEducation()
{
  return self::itemsAlias('education');
}

public function getItemTitle()
{
  return self::itemsAlias('title');
}

public function getItemSkill()
{
  return self::itemsAlias('skill');
}

<?php

use yii\helpers\Html;
use yii\widgets\ActiveForm;
use app\models\Resume;
?>

<div class="resume-form">

    <?php $form = ActiveForm::begin(); ?>

    <?= $form->field($model, 'title')->radioList(Resume::itemsAlias('title')) ?>

<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
?>

<div class="resume-form">

    <?php $form = ActiveForm::begin(); ?>

    <?= $form->field($model, 'title')->radioList($model->getItemTitle()) ?>

    <?= $form->field($model, 'title')->inline()->radioList($model->getItemTitle()) ?>

    <?= $form->field($model, 'sex')->radioList($model->getItemSex()) ?>

    <?= $form->field($model, 'education_level')->dropdownList($model->getItemEducation(),['prompt'=>'เลือกการศึกษา..']) ?>

    <?= $form->field($model, 'marital_status')->radioList($model->getItemMarital()) ?>

    <?= $form->field($model, 'skill')->checkBoxList($model->getItemSkill()) ?>

 public function getItems($type)
 {
   return  self::itemsAlias($type);
 }

<?php

use yii\helpers\Html;
use yii\bootstrap\ActiveForm;

/* @var $this yii\web\View */
/* @var $model app\models\Resume */
/* @var $form yii\widgets\ActiveForm */
?>

<div class="resume-form">

    <?php $form = ActiveForm::begin(); ?>

    <?= $form->field($model, 'title')->inline()->radioList($model->getItemTitle()) ?>
    <div class="row">

      <div class="col-md-6">
        <?= $form->field($model, 'firstname')->textInput(['maxlength' => true]) ?>
      </div>
      <div class="col-md-6">
          <?= $form->field($model, 'lastname')->textInput(['maxlength' => true]) ?>
      </div>
    </div>
    <?= $form->field($model, 'education_level')->dropdownList($model->getItemEducation(),['prompt'=>'เลือกการศึกษา..']) ?>
    <div class="row">
      <div class="col-md-4">
          <?= $form->field($model, 'sex')->radioList($model->getItemSex()) ?>
      </div>
      <div class="col-md-4">
        <?= $form->field($model, 'marital_status')->radioList($model->getItemMarital()) ?>
      </div>
      <div class="col-md-4">
        <?= $form->field($model, 'skill')->checkBoxList($model->getItemSkill()) ?>
      </div>
    </div>

    <div class="form-group">
        <?= Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' =>  $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>
    </div>

    <?php ActiveForm::end(); ?>

</div>

<?php

namespace app\models;

use Yii;
use yii\helpers\ArrayHelper;
use yii\behaviors\AttributeBehavior;
use \yii\db\ActiveRecord;
/**
 * This is the model class for table "".
 *
 * @property integer $id
 * @property string $title
 * @property string $firstname
 * @property string $lastname
 * @property integer $education_level
 * @property integer $marital_status
 * @property integer $sex
 * @property string $skill
 */
class Resume extends ActiveRecord
{
  const SEX_MEN = 1;
  const SEX_WOMEN = 2;

    public function behaviors()
    {
        return [
            [
                'class' => AttributeBehavior::className(),
                'attributes' => [
                    ActiveRecord::EVENT_BEFORE_INSERT => 'skill',
                    ActiveRecord::EVENT_BEFORE_UPDATE => 'skill',
                ],
                'value' => function ($event) {
                    return implode(',', $this->skill);
                },
            ],
        ];
    }
    // ...
  }

<?php

namespace app\models;

use Yii;
use yii\helpers\ArrayHelper;
use yii\behaviors\AttributeBehavior;
use \yii\db\ActiveRecord;
/**
 * This is the model class for table "".
 *
 * @property integer $id
 * @property string $title
 * @property string $firstname
 * @property string $lastname
 * @property integer $education_level
 * @property integer $marital_status
 * @property integer $sex
 * @property string $skill
 */
class Resume extends ActiveRecord
{
  const SEX_MEN = 1;
  const SEX_WOMEN = 2;

  // ....

  public function skillToArray()
  {
    return $this->skill = explode(',', $this->skill);
  }
    // ....

}

<?php

// ...

public function actionUpdate($id)
{
    $model = $this->findModel($id);
    $model->skillToArray(); //<<------------------

    if ($model->load(Yii::$app->request->post()) && $model->save()) {
        return $this->redirect(['view', 'id' => $model->id]);
    } else {
        return $this->render('update', [
            'model' => $model,
        ]);
    }
}

<?php

public function getFullName()
{
   return $this->titleName.$this->firstname.' '.$model->lastname;
}

$model->fullName;

<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'fullName', // <<-----------
        'education_level',
        'marital_status',
        'sex',
        'skill',
        ['class' => 'yii\grid\ActionColumn'],
    ],
]); ?>

<?= DetailView::widget([
    'model' => $model,
    'attributes' => [
        'fullName', // <<-----------
        'education_level',
        'marital_status',
        'sex',
        'skill',
    ],
]) ?>

<?php
public function getSexName(){
    return ArrayHelper::getValue($this->getItemSex(),$this->sex);
}

public function getMaritalName(){
    return ArrayHelper::getValue($this->getItemSex(),$this->marital_status);
}

public function getEducationName(){
    return ArrayHelper::getValue($this->getItemEducation(),$this->education_level);
}

public function getTitleName(){
    return ArrayHelper::getValue($this->getItemTitle(),$this->title);
}

<?php

// ...

public function getSkillName(){
    $skills = $this->getItemSkill();
    $skillSelected = explode(',', $this->skill);
    $skillSelectedName = [];
    foreach ($skills as $key => $skillName) {
      foreach ($skillSelected as $skillKey) {
        if($key === $skillKey){
          $skillSelectedName[] = $skillName;
        }
      }
    }

    return implode(', ', $skillSelectedName);
}

<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        // 'id',
        // 'title',
        // 'firstname',
        // 'lastname',
        // 'education_level',
        // 'marital_status',
        // 'sex',
        // 'skill',

        // virtual attribute
        'fullName',
        'educationName',
        'maritalName',
        'sexName',
        'skillName',

        ['class' => 'yii\grid\ActionColumn'],
    ],
]); ?>

<?= DetailView::widget([
    'model' => $model,
    'attributes' => [
        'id',
        'title',
        'firstname',
        'lastname',
        'education_level',
        'marital_status',
        'sex',
        'skill',
        // virtual attribute
        'fullName',
        'educationName',
        'maritalName',
        'sexName',
        'skillName'
    ],
]) ?>

<?php

// ...

public function attributeLabels()
{
    return [
        'id' => Yii::t('app', 'ID'),
        'title' => Yii::t('app', 'คำนำหน้า'),
        'firstname' => Yii::t('app', 'ชื่อ'),
        'lastname' => Yii::t('app', 'นามสกุล'),
        'education_level' => Yii::t('app', 'การศึกษา'),
        'marital_status' => Yii::t('app', 'สถานะสมรส'),
        'sex' => Yii::t('app', 'เพศ'),
        'skill' => Yii::t('app', 'ทักษะ'),
        // เพิ่มเติม
        'fullName'=> Yii::t('app', 'ชื่อ - นามสกุล'),
        'educationName'=>Yii::t('app', 'การศึกษา'),
        'maritalName'=> Yii::t('app', 'สถานะสมรส'),
        'sexName' => Yii::t('app', 'เพศ'),
        'skillName'=> Yii::t('app', 'ทักษะ')
    ];
}

<?php

namespace app\models;

use Yii;
use yii\helpers\ArrayHelper;
use yii\behaviors\AttributeBehavior;
use \yii\db\ActiveRecord;
/**
 * This is the model class for table "".
 *
 * @property integer $id
 * @property string $title
 * @property string $firstname
 * @property string $lastname
 * @property integer $education_level
 * @property integer $marital_status
 * @property integer $sex
 * @property string $skill
 */
class Resume extends ActiveRecord
{
  const SEX_MEN = 1;
  const SEX_WOMEN = 2;

    public function behaviors()
    {
        return [
            [
                'class' => AttributeBehavior::className(),
                'attributes' => [
                    ActiveRecord::EVENT_BEFORE_INSERT => 'skill',
                    ActiveRecord::EVENT_BEFORE_UPDATE => 'skill',
                ],
                'value' => function ($event) {
                    return implode(',', $this->skill);
                },
            ],
        ];
    }
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['title','firstname', 'lastname','education_level', 'marital_status', 'sex'], 'required'],
            [['education_level', 'marital_status', 'sex'], 'integer'],
            [['title'], 'string', 'max' => 150],
            [['firstname', 'lastname'], 'string', 'max' => 255],
            [['skill'], 'safe'],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'title' => Yii::t('app', 'คำนำหน้า'),
            'firstname' => Yii::t('app', 'ชื่อ'),
            'lastname' => Yii::t('app', 'นามสกุล'),
            'education_level' => Yii::t('app', 'การศึกษา'),
            'marital_status' => Yii::t('app', 'สถานะสมรส'),
            'sex' => Yii::t('app', 'เพศ'),
            'skill' => Yii::t('app', 'ทักษะ'),

            'fullName'=> Yii::t('app', 'ชื่อ - นามสกุล'),
            'educationName'=>Yii::t('app', 'การศึกษา'),
            'maritalName'=> Yii::t('app', 'สถานะสมรส'),
            'sexName' => Yii::t('app', 'เพศ'),
            'skillName'=> Yii::t('app', 'ทักษะ')
        ];
    }

    /**
     * @inheritdoc
     * @return ResumeQuery the active query used by this AR class.
     */
    public static function find()
    {
        return new ResumeQuery(get_called_class());
    }

    public static function itemsAlias($key){

      $items = [
        'sex'=>[
          self::SEX_MEN => 'ชาย',
          self::SEX_WOMEN => 'หญิง'
        ],
        'title'=>[
          1 => 'นาย',
          2 => 'นางสาว',
          3 => 'นาง'
        ],
        'marital'=>[
          1 => 'โสด',
          2 => 'สมรส',
          3 => 'เป็นหม้าย',
          4 => 'หย่าร้าง'
        ],
        'education'=>[
          1 => 'ต่ำกว่ามัธยมศึกษาตอนต้น',
          2 => 'มัธยมศึกษาตอนต้น',
          3 => 'ปวช',
          4 => 'มัธยมศึกษาตอนปลาย',
          5 => 'ปวส',
          6 => 'อนุปริญญา',
          7 => 'ปริญญาตรี',
          8 => 'ปริญญาโท',
          9 => 'ปริญญาเอก'
        ],
        'skill'=>[
          'php' => 'PHP',
          'js' => 'JavaScript',
          'css' => 'CSS',
          'html5' => 'Html5',
          'angularjs' => 'AngularJs',
          'node.js' => 'Node.Js',
          'reactjs' => 'ReactJs',
          'go'=>'Go',
          'ruby'=>'ruby on rails',
          'swiff' => 'Swiff',
          'android' => 'Android',
      ]
    ];
      return ArrayHelper::getValue($items,$key,[]);
      //return array_key_exists($key, $items) ? $items[$key] : [];
    }

    public function getItemSex()
    {
      return self::itemsAlias('sex');
    }

    public function getItemMarital()
    {
      return self::itemsAlias('marital');
    }

    public function getItemEducation()
    {
      return self::itemsAlias('education');
    }

    public function getItemTitle()
    {
      return self::itemsAlias('title');
    }

    public function getItemSkill()
    {
      return self::itemsAlias('skill');
    }

    public function getSexName(){
        return ArrayHelper::getValue($this->getItemSex(),$this->sex);
    }

    public function getMaritalName(){
        return ArrayHelper::getValue($this->getItemMarital(),$this->marital_status);
    }

    public function getEducationName(){
        return ArrayHelper::getValue($this->getItemEducation(),$this->education_level);
    }

    public function getTitleName(){
        return ArrayHelper::getValue($this->getItemTitle(),$this->title);
    }

    public function getSkillName(){
        $skills = $this->getItemSkill();
        $skillSelected = explode(',', $this->skill);
        $skillSelectedName = [];
        foreach ($skills as $key => $skillName) {
          foreach ($skillSelected as $skillKey) {
            if($key === $skillKey){
              $skillSelectedName[] = $skillName;
            }
          }
        }

        return implode(', ', $skillSelectedName);
    }

    public function getFullName()
    {
       return $this->titleName.$this->firstname.' '.$this->lastname;
    }

    public function skillToArray()
    {
      return $this->skill = explode(',', $this->skill);
    }

}

<?php

//...

class ResumeSearch extends Resume
{
  public $fullName;
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['id', 'education_level', 'marital_status', 'sex'], 'integer'],
            [['title', 'firstname', 'lastname', 'skill','fullName'], 'safe'],
        ];
    }
}

<?php

//...


public function search($params)
{
    $query = Resume::find();

    $dataProvider = new ActiveDataProvider([
        'query' => $query,
    ]);

    // Sorting by fullName
    $dataProvider->sort->attributes['fullName'] = [
       'asc' => ['firstname' => SORT_ASC, 'lastname' => SORT_ASC],
       'desc' => ['firstname' => SORT_DESC, 'lastname' => SORT_DESC],
       'default' => SORT_ASC
    ];

    $this->load($params);

    if (!$this->validate()) {
        // uncomment the following line if you do not want to return any records when validation fails
        // $query->where('0=1');
        return $dataProvider;
    }

    $query->andFilterWhere([
        'id' => $this->id,
        'education_level' => $this->education_level,
        'marital_status' => $this->marital_status,
        'sex' => $this->sex,
    ]);

    // filter by person full name
     $query->andWhere('firstname LIKE "%' . $this->fullName . '%" ' .
         'OR lastname LIKE "%' . $this->fullName . '%"'
     );

    $query->andFilterWhere(['like', 'title', $this->title])
        ->andFilterWhere(['like', 'firstname', $this->firstname])
        ->andFilterWhere(['like', 'lastname', $this->lastname])
        ->andFilterWhere(['like', 'skill', $this->skill]);

    return $dataProvider;
}

<?php
use app\models\Resume;
 ?>
<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'filterModel' => $searchModel,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        // 'id',
        // 'title',
        // 'firstname',
        // 'lastname',
        // 'education_level',
        // 'marital_status',
        // 'sex',
        // 'skill',
        'fullName',
        [
          'attribute'=>'education_level',
          'filter'=>Resume::itemsAlias('education'),
          'value'=>function($model){
            return $model->educationName;
          }
        ],
        [
          'attribute'=>'marital_status',
          'filter'=>Resume::itemsAlias('marital'),
          'value'=>function($model){
            return $model->maritalName;
          }
        ],
        [
          'attribute'=>'sex',
          'filter'=>Resume::itemsAlias('sex'),
          'value'=>function($model){
            return $model->sexName;
          }
        ],
        [
          'attribute'=>'skill',
          'filter'=>Resume::itemsAlias('sex'),
          'value'=>function($model){
            return $model->skillName;
          }
        ],
        // 'educationName',
        // 'maritalName',
        // 'sexName',
        // 'skillName',

        ['class' => 'yii\grid\ActionColumn'],
    ],
]); ?>