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