public function getDetailed($grupo_id) { $user = User::fromToken(); $alumnos = Grupo::alumnos($grupo_id); foreach ($alumnos as $alumno) { $userData = Alumno::userData($alumno->alumno_id); $alumno->userData = $userData; $nota = NotaComportamiento::crearVerifNota($alumno->alumno_id, $user->periodo_id); $consulta = 'SELECT * FROM ( SELECT d.id as definicion_id, d.comportamiento_id, d.frase_id, f.frase, f.tipo_frase, f.year_id FROM definiciones_comportamiento d inner join frases f on d.frase_id=f.id and d.deleted_at is null where d.comportamiento_id=:comportamiento1_id and f.deleted_at is null union select d2.id as definicion_id, d2.comportamiento_id, d2.frase_id, d2.frase, null as tipo_frase, null as year_id from definiciones_comportamiento d2 where d2.deleted_at is null and d2.frase is not null and d2.comportamiento_id=:comportamiento2_id ) defi'; $definiciones = DB::select($consulta, array('comportamiento1_id' => $nota->id, 'comportamiento2_id' => $nota->id)); $alumno->definiciones = $definiciones; $alumno->nota = $nota; } $frases = Frase::where('year_id', '=', $user->year_id)->get(); $grupo = Grupo::find($grupo_id); $resultado = []; array_push($resultado, $frases); array_push($resultado, $alumnos); array_push($resultado, $grupo); return $resultado; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Grupo::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $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]); $query->andFilterWhere(['like', 'descricao', $this->descricao]); return $dataProvider; }
/** * Lists all GrupoTime models. * @return mixed */ public function actionIndex($id = 0) { $model = new GrupoTime(); $classificacao = array(); if ($id != 0) { $grupo = Grupo::find($id)->one(); $model = GrupoTime::find()->where(['=', 'id_grupo', $id])->all(); foreach ($model as $item) { $itemArray = array("id" => $item->id, "id_grupo" => $item->id_grupo, "id_time" => $item->getIdTime()->one()->nome, "escudo" => $item->getIdTime()->one()->escudo, "pontos" => GrupoTime::GetPontosDoTime($item->id_time), "vitoria" => GrupoTime::GetNVitoriaDoTime($item->id_time), "empate" => GrupoTime::GetNEmpateDoTime($item->id_time), "derrota" => GrupoTime::GetNDerrotaDoTime($item->id_time)); array_push($classificacao, $itemArray); } return $this->render('index', ['model' => Setup::aasort($classificacao, 'pontos'), 'grupo' => $grupo]); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Grupo::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $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; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'max_horas' => $this->max_horas]); $query->andFilterWhere(['like', 'codigo', $this->codigo])->andFilterWhere(['like', 'nome', $this->nome]); return $dataProvider; }
/** * Lists all Grupo models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Grupo::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }
?> <?php echo $form->field($model, 'nome')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'max_horas')->textInput(); ?> <?php echo $form->field($model, 'curso_id')->dropDownList(ArrayHelper::map(Curso::find()->all(), 'id', 'nome'), ['prompt' => 'Selecione']); ?> <?php echo $form->field($model, 'grupo_id')->dropDownList(ArrayHelper::map(Grupo::find()->all(), 'id', 'nome'), ['prompt' => 'Selecione']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Salvar' : 'Atualizar', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> </div> <?php ActiveForm::end(); ?> </div>
</i> <span>Meus Pontos</span> </a> </li> <li> <a href="#layout"> <i class="fa fa-columns icon"> <b class="bg-warning"></b> </i> <span class="pull-right"> <i class="fa fa-angle-down text"></i> <i class="fa fa-angle-up text-active"></i> </span> <span>Grupos</span> </a> <ul class="nav lt"> <?php foreach (\app\models\Grupo::find()->all() as $grupo) { ?> <li> <a href="/grupotime/index/<?php echo $grupo->id; ?> "> <i class="fa fa-angle-right"></i> <span><?php echo $grupo->nome; ?> </span> </a> </li> <?php } ?>
public function putUpdate($id) { $alumno = Alumno::findOrFail($id); $this->sanarInputAlumno(); try { $alumno->no_matricula = Request::input('no_matricula'); $alumno->nombres = Request::input('nombres'); $alumno->apellidos = Request::input('apellidos'); $alumno->sexo = Request::input('sexo', 'M'); $alumno->fecha_nac = Request::input('fecha_nac'); $alumno->ciudad_nac = Request::input('ciudad_nac')['id']; $alumno->tipo_doc = Request::input('tipo_doc')['id']; $alumno->documento = Request::input('documento'); $alumno->ciudad_doc = Request::input('ciudad_doc')['id']; $alumno->tipo_sangre = Request::input('tipo_sangre')['sangre']; $alumno->eps = Request::input('eps'); $alumno->telefono = Request::input('telefono'); $alumno->celular = Request::input('celular'); $alumno->barrio = Request::input('barrio'); $alumno->estrato = Request::input('estrato'); $alumno->ciudad_resid = Request::input('ciudad_resid'); $alumno->religion = Request::input('religion'); $alumno->email = Request::input('email'); $alumno->facebook = Request::input('facebook'); $alumno->foto_id = Request::input('foto_id'); $alumno->pazysalvo = Request::input('pazysalvo', true); $alumno->deuda = Request::input('deuda'); if ($alumno->user_id and Request::has('username')) { $this->sanarInputUser(); $this->checkOrChangeUsername($alumno->user_id); $usuario = User::find($alumno->user_id); $usuario->username = Request::input('username'); $usuario->email = Request::input('email2'); $usuario->is_superuser = Request::input('is_superuser', false); $usuario->is_active = Request::input('is_active', true); if (Request::has('password')) { if (Request::input('password') == "") { $usuario->password = Hash::make(Request::input('password')); } } $usuario->save(); $alumno->user_id = $usuario->id; $alumno->save(); $alumno->user = $usuario; } if (!$alumno->user_id and Request::has('username')) { $this->sanarInputUser(); $this->checkOrChangeUsername($alumno->user_id); $yearactual = Year::actual(); $periodo_actual = Periodo::where('actual', true)->where('year_id', $yearactual->id)->first(); $usuario = new User(); $usuario->username = Request::input('username'); $usuario->password = Hash::make(Request::input('password', '123456')); $usuario->email = Request::input('email2'); $usuario->is_superuser = Request::input('is_superuser', false); $usuario->is_active = Request::input('is_active', true); $usuario->periodo_id = $periodo_actual->id; $usuario->save(); $alumno->user_id = $usuario->id; $alumno->save(); $alumno->user = $usuario; } if (Request::input('grupo')['id']) { $grupo_id = Request::input('grupo')['id']; $matricula = Matricula::matricularUno($alumno->id, $grupo_id); $grupo = Grupo::find($matricula->grupo_id); $alumno->grupo = $grupo; } return $alumno; } catch (Exception $e) { return abort('400', $e); } }