Итак, в контроллере:
Код: Выделить всё
public function actionIndex(){
$searchModel = new RequestBisaApproveSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
]);
}
Код: Выделить всё
public function search($params)
{
$karyawan = Karyawan::findOne(['id' => \Yii::$app->user->identity->karyawan_id]);
$dataKaryawan = $karyawan->linkKaryawanPerusahaanBranchDepartementJabatans;
$branches = [];
$perusahaans = [];
$departements = [];
$jabatans = [];
foreach ($dataKaryawan as $data) :
array_push($branches, $data['branch_id']);
array_push($perusahaans, $data['perusahaan_id']);
array_push($departements, $data['departement_id']);
array_push($jabatans, $data['jabatan_id']);
endforeach;
$query = (new Query())
->select("re.id as id, kar.first_name, kar.last_name, re.status, re.header, re.tanggal_permintaan")
->from('ytresnamuda_it.request re')
->join('LEFT JOIN', 'ytresnamuda_hrd.karyawan kar', 're.karyawan_id = kar.id')
->join('LEFT JOIN', 'ytresnamuda_hrd.link_karyawan_perusahaan_branch_departement_jabatan li', 'kar.id = li.karyawan_id');
$query->where(['IN','li.branch_id', $branches]);
$query->andWhere(['IN','li.perusahaan_id', $perusahaans]);
$query->andWhere(['IN','li.departement_id', $departements]);
$query->andWhere(['
Подробнее здесь: [url]https://stackoverflow.com/questions/45478233/actioncolumn-yii2-key-always-return-0-based-from-searchmodel[/url]