/** * Creates a new Factencuesta model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { // CONEXION A LA BASE DE DATOS PARA REALIZAR CONSULTAS VIA SQL EN LA DB $db = new \yii\db\Connection(['dsn' => 'pgsql:host=localhost;port=5432;dbname=db_sinsch', 'username' => 'nuestroswawas', 'password' => '4358']); $db->open(); $nom_tec = Yii::$app->user->identity->username; $tecnico = $db->createCommand('SELECT tecnico.id_tecn FROM public."user", public.tecnico WHERE "user".username = tecnico.nombre_corto AND tecnico.nombre_corto = :nom_tec', [':nom_tec' => $nom_tec])->queryScalar(); $model = new Factencuesta(); $model->num_tom = 2; $model->fec_ini_tom = '23-07-2015'; $model->fec_fin_tom = '23-08-2015'; $model->id_tecn = $tecnico; // $model -> id_tecn = $nom_tec; if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['ninio/create', 'id' => $model->id_enc]); } else { return $this->render('create', ['model' => $model]); } }