public function storeSeguirMaster(Request $request)
{
$datos = $request->all();
$registro = Registro::find($datos['id']);
if ($datos['password'] != 'hola') {
return 'Contraseña incorrecta';
}
$registro->distancia = $registro->distancia + $datos['metros'];
$registro->save();
return 'OK';
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
// Busca o registro pelo id e deleta do banco de dados
$registro = Registro::find($id)->delete();
// Cria a msg para exibir para o usuário
flash('Registro excluído com sucesso');
// Redireciona para a index
return redirect()->route('registros.index');
}
public function actionMostrar()
{
/*$table = new Registro;
$model = $table->find()->all();
$form =new FormMostrar;
$buscar= null;
if ($form->load(Yii::$app->request->get())) {
if ($form->validate()) {
$buscar = Html::encode($form->b);
$query = "SELECT * FROM registra WHERE id_reg LIKE '%$buscar%' OR ";
$query .= "nombre LIKE '%$buscar%'OR apellido LIKE '%$buscar%' OR CI LIKE '%$buscar%' OR email LIKE '%$buscar%' OR usuario LIKE '%$buscar%' OR clave LIKE '%$buscar%'";
$model = $table->findBySql($query)->all();
}else{
$form->getErrors();
}
}*/
$form = new FormMostrar();
$buscar = null;
if ($form->load(Yii::$app->request->get())) {
if ($form->validate()) {
$buscar = Html::encode($form->b);
$table = Registro::find()->where(["like", "id_reg", $buscar])->orwhere(["like", "nombre", $buscar])->orwhere(["like", "apellido", $buscar])->orwhere(["like", "CI", $buscar]);
$count = clone $table;
$pages = new Pagination(["pageSize" => 1, "totalCount" => $count->count()]);
$model = $table->offset($pages->offset)->limit($pages->limit)->all();
} else {
$form->getErrors();
}
} else {
$table = Registro::find();
$count = clone $table;
$pages = new Pagination(["pageSize" => 1, "totalCount" => $count->count()]);
$model = $table->offset($pages->offset)->limit($pages->limit)->all();
}
return $this->render("mostrar", ["model" => $model, "form" => $form, "buscar" => $buscar, "pages" => $pages]);
}
