public function actionBuscarProveedor() { $request = trim($_GET['term']); if ($request != "") { $model = Proveedor::find()->select(['(idproveedor||\'-----\'||razonsocial||\'-----\'||rif as value', 'idproveedor as id'])->where(" codigo like '%" . $request . "%' ")->orderBy('idproveedor')->limit('20')->asArray()->all(); $data = array(); foreach ($model as $prov) { $data[$prov['id']] = ['value' => $prov['id'], 'label' => $prov['value'], 'id' => $prov['id']]; } echo json_encode($data); } else { } }
/** * @return \yii\db\ActiveQuery */ public function getIdproveedors() { return $this->hasMany(Proveedor::className(), ['idproveedor' => 'idproveedor'])->viaTable('productoxproveedor', ['idproducto' => 'idproducto']); }