public function actionModificar() { $model = new ValidarDeportistamodif(); $msg = null; if ($model->load(Yii::$app->request->post()) && Yii::$app->request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; return ActiveForm::validate($model); } if (isset($_REQUEST['dni'])) { if ((int) $_REQUEST['dni']) { $model->dni = $_REQUEST['dni']; $table = Deportista::findOne($model->dni); $model->numero_socio = $table->numero_socio; $id = $table->id_planilla; $table = Persona::findOne($model->dni); $model->nombre = $table->nombre; $model->apellido = $table->apellido; $model->domicilio = $table->domicilio; $model->telefono = $table->telefono; $model->email = $table->email; $table = Planilla::findOne($id); $model->medico_cabecera = $table->medico_cabecera; $model->grupo_sanguineo = $table->grupo_sanguineo; $model->obra_social = $table->obra_social; $model->medicamento = $table->medicamento; $model->desc_medicamento = $table->desc_medicamento; $model->alergia = $table->alergia; $model->desc_alergia = $table->desc_alergia; $model->anemia = $table->anemia; $model->enf_cardiologica = $table->enf_cardiologica; $model->desc_cardiologia = $table->desc_cardiologia; $model->asma = $table->asma; $model->desc_asma = $table->desc_asma; $model->presion = $table->presion; $model->convulsiones = $table->convulsiones; $model->ultima_convulsion = $table->ultima_convulsion; $model->trastornos_hemorragicos = $table->trastornos_hemorragicos; $model->fuma = $table->fuma; $model->cuanto_fuma = $table->cuanto_fuma; $model->diabetes = $table->diabetes; $model->desc_diabetes = $table->desc_diabetes; $model->tratamiento = $table->tratamiento; $model->desc_tratamiento = $table->desc_tratamiento; $model->internaciones = $table->internaciones; $model->desc_internacion = $table->medico_cabecera; $model->nombreyapellido1 = $table->nombreyapellido1; $model->domicilio1 = $table->domicilio1; $model->telefono1 = $table->telefono1; $model->nombreyapellido2 = $table->nombreyapellido2; $model->domicilio2 = $table->domicilio2; $model->telefono2 = $table->telefono2; $model->observaciones = $table->observaciones; $table = Deportista_cat::find()->where(['dni' => $model->dni])->count(); $cant = $table; switch ($table) { case 1: $table = Deportista_cat::find()->where(['dni' => $model->dni])->offset(0)->one(); $model->deporte1 = $table->id_deporte; $model->categoria1 = $table->id_categoria; $model->aux1 = $model->categoria1; break; case 2: $table = Deportista_cat::find()->where(['dni' => $model->dni])->offset(0)->one(); $model->deporte1 = $table->id_deporte; $model->categoria1 = $table->id_categoria; $table = Deportista_cat::find()->where(['dni' => $model->dni])->offset(1)->one(); $model->deporte2 = $table->id_deporte; $model->categoria2 = $table->id_categoria; $model->aux1 = $model->categoria1; $model->aux2 = $model->categoria2; break; case 3: $table = Deportista_cat::find()->where(['dni' => $model->dni])->offset(0)->one(); $model->deporte1 = $table->id_deporte; $model->categoria1 = $table->id_categoria; $table = Deportista_cat::find()->where(['dni' => $model->dni])->offset(1)->one(); $model->deporte2 = $table->id_deporte; $model->categoria2 = $table->id_categoria; $table = Deportista_cat::find()->where(['dni' => $model->dni])->offset(2)->one(); $model->deporte3 = $table->id_deporte; $model->categoria3 = $table->id_categoria; $model->aux1 = $model->categoria1; $model->aux2 = $model->categoria2; $model->aux3 = $model->categoria3; break; } } } if ($model->load(Yii::$app->request->post())) { if ($model->validate()) { $datos = array("0" => array('deporte' => $model->deporte1, 'categoria' => $model->categoria1, 'aux' => $model->aux1), "1" => array('deporte' => $model->deporte1, 'categoria' => $model->categoria1, 'aux' => $model->aux1), "2" => array('deporte' => $model->deporte1, 'categoria' => $model->categoria1, 'aux' => $model->aux1)); $connection = \Yii::$app->db; $transaction = $connection->beginTransaction(); $sql1 = "UPDATE persona SET dni='{$model->dni}',nombre='{$model->nombre}',apellido='{$model->apellido}' where persona.dni='{$model->dni}' "; $sql2 = "update planilla,deportista set medico_cabecera='{$model->medico_cabecera}',grupo_sanguineo='{$model->grupo_sanguineo}',obra_social='{$model->obra_social}',medicamento='{$model->medicamento}',desc_medicamento='{$model->desc_medicamento}',\n alergia='{$model->alergia}',desc_alergia='{$model->desc_alergia}',anemia='{$model->anemia}',enf_cardiologica='{$model->enf_cardiologica}',desc_cardiologia='{$model->desc_cardiologia}',asma='{$model->asma}',desc_asma='{$model->desc_asma}',presion='{$model->presion}',convulsiones='{$model->convulsiones}',ultima_convulsion='{$model->ultima_convulsion}',\n trastornos_hemorragicos='{$model->trastornos_hemorragicos}',fuma='{$model->fuma}',cuanto_fuma='{$model->cuanto_fuma}',diabetes='{$model->diabetes}',desc_diabetes='{$model->desc_diabetes}',tratamiento='{$model->tratamiento}',desc_tratamiento='{$model->desc_tratamiento}',internaciones='{$model->internaciones}',desc_internacion='{$model->desc_internacion}',nombreyapellido1='{$model->nombreyapellido1}',domicilio1='{$model->domicilio1}',\n telefono1='{$model->telefono1}',nombreyapellido2='{$model->nombreyapellido2}',domicilio2='{$model->domicilio2}',telefono2='{$model->telefono2}',observaciones='{$model->observaciones}' where planilla.id_planilla=deportista.id_planilla"; foreach ($datos as $val) { if ($val['categoria'] != "") { $deporte = $val['deporte']; $categoria = $val['categoria']; $aux = $val['aux']; $connection->createCommand("update deportista_categoria set id_categoria={$categoria}, id_deporte={$deporte} where dni={$model->dni} and id_categoria={$aux}")->execute(); } } try { $connection->createCommand($sql1)->execute(); $connection->createCommand($sql2)->execute(); $sql3 = "UPDATE deportista SET numero_socio='{$model->numero_socio}' where deportista.dni='{$model->dni}'"; $connection->createCommand($sql3)->execute(); $transaction->commit(); $msg = "Modificacion realizada con exito realizada con exito"; $model->nombre = null; $model->apellido = null; $model->dni = NULL; $model->domicilio = null; $model->telefono = null; $model->telefono1 = null; $model->email = null; $model->numero_socio = null; $model->medico_cabecera = null; $model->grupo_sanguineo = null; $model->obra_social = null; $model->medicamento = null; $model->desc_medicamento = null; $model->alergia = null; $model->desc_alergia = null; $model->anemia = null; $model->enf_cardiologica = null; $model->desc_cardiologia = null; $model->asma = null; $model->desc_asma = null; $model->presion = null; $model->convulsiones = null; $model->ultima_convulsion = null; $model->trastornos_hemorragicos = null; $model->fuma = null; $model->cuanto_fuma = null; $model->diabetes = null; $model->desc_diabetes = null; $model->tratamiento = null; $model->desc_tratamiento = null; $model->internaciones = null; $model->desc_internacion = null; $model->nombreyapellido1 = null; $model->domicilio1 = null; $model->telefono1 = null; $model->nombreyapellido2 = null; $model->domicilio2 = null; $model->telefono2 = null; $model->observaciones = null; $this->redirect(["deportista/buscar", 'msg' => $msg]); } catch (\Exception $e) { $msg = "Registracion realizada con exito"; $transaction->rollBack(); throw $e; } } } $deporte = ArrayHelper::map(Deporte::find()->all(), 'id_deporte', 'nombre'); $categoria = ArrayHelper::map(Categoria::find()->all(), 'id_categoria', 'nombre_categoria'); return $this->render("modificar_deportista", ["model" => $model, "msg" => $msg, 'deporte' => $deporte, 'categoria' => $categoria, 'cant' => $cant]); }
public function actionReset($dni) { $form = new ValidarBusqueda(); if (is_numeric($dni)) { $tabla = Persona::findOne($_REQUEST['dni']); $email = $tabla->email; $contra = $this->randKey("abcdef0123456789", 6); $pass = crypt($contra, Yii::$app->params["salt"]); $tabla = Users::findOne($_REQUEST['dni']); $tabla->contrasenia = $pass; if ($tabla->update()) { $subject = "Nueva contrasenia"; $body = "<h1>Su contraseña a sido reseteada</h1>"; $body .= "<a >Usuario: {$tabla->nombre_usuario}</a> "; $body .= "<a>Contraseña: {$contra} </a>"; $body .= "<a>Por favor cambie su contraseña luego de loguearse </a>"; $body .= "<p><a href='http://localhost/basic/web/index.php'>Login</a></p>"; Yii::$app->mailer->compose()->setTo($email)->setFrom([Yii::$app->params["adminEmail"] => Yii::$app->params["title"]])->setSubject($subject)->setHtmlBody($body)->send(); $msg = "contraseña reseteada con exito"; } else { $msg = "problemas al resetear"; } } else { $msg = "usuario no encontrado"; } $this->redirect(["usuario/buscar", 'msg' => $msg]); }
/** * Finds the Persona model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Persona the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Persona::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Displays a single InscripcionExamen model. * @param integer $id * @return mixed */ public function actionView($id) { $persona = Persona::findOne($id); $examenes = InscripcionExamen::findAll(['id_alumno' => $persona->id]); return $this->render('view', ['persona' => $persona, 'examenes' => $examenes]); }