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);
}
}
