时间戳

首页 > 解决方案 > Laravel：创建一个影响我数据库中的列的按钮

php - Laravel：创建一个影响我数据库中的列的按钮

问题描述

是否可以创建一个更改column表中值的按钮？我的表中有一个column名字status，我movimentations想知道是否可以column使用我的按钮更改它的值，该按钮view可以从活动变为非活动

这是我的看法

<div class="container">
    <label for="name" class="form-group"><b>Nome</b>: {{ $movs->nameCoop }}</label><br>
    <label for="name"><b>Numero</b>: {{ $movs->numCoop }}</label><br>
    <label for="name"><b>CPF</b>: {{ $movs->cpfCoop }}</label><br>
    <label for="name"><b>Cadastro</b>: {{ $movs->dtCad }}</label><br>
    <label for="name"><b>Demissão</b>: {{ $movs->dtDem }}</label><br>
    <label for="name"><b>Observações</b>: {{ $movs->description }}</label><br>
    <label for="name"><b>Subscritas</b>: {{ $movs->subscritas }}</label><br>
    <label for="name"><b>A integralizar</b>: {{ $movs->aintegralizar }}</label><br>
    <label for="name"><b>Integralizadas</b>: {{ $movs->integralizadas }}</label><br>
    <label for="name"><b>Status</b>: {{ $movs->status }}</label><br>
            <td>
                <form action="/trans" method="POST">
                    @csrf
                    <div class="input-group">
                      <input type="hidden" class="form-control" name="r" value={{$cooperado->id}}>
                        <button type="submit" class="btn btn-primary">
                          <span>+</span>
                        </button>
                      </span>
                    </div>
                </form>
    </td>
    <td>
                <form action="/mvs" method="POST">
                    @csrf
                    <div class="input-group">
                      <input type="hidden" class="form-control" name="v" value={{$cooperado->id}}>
                        <button type="submit" class="btn btn-primary">
                          <span>ver mvs</span>
                        </button>
                      </span>
                    </div>
                </form>
    </td>

这是我的控制器

    <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Cooperado;

class CooperadoController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
        //$cooperados = Cooperado::all();
        $cooperados = Cooperado::orderBy('dtCad', 'desc')->paginate(10);
        return view('cooperados.index', compact('cooperados'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
        return view('cooperados.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
        $request->validate([
            'nameCoop'=>'required',
            'numCoop'=> 'required|integer',
            'cpfCoop'=> 'required',
            'dtCad'=>'required|date',
            'subscritas'=>'required'
          ]);
          $cooperado = new Cooperado([
            'nameCoop' => $request->get('nameCoop'),
            'numCoop'=> $request->get('numCoop'),
            'cpfCoop'=> $request->get('cpfCoop'),
            'dtCad'=> $request->get('dtCad'),
            'description'=> $request->get('description'),
            'subscritas'=> $request->get('subscritas'),
            'aintegralizar'=> $request->get('subscritas'),
            'status'=> $request->get('status')
          ]);
          $cooperado->save();
          return redirect('/cooperados')->with('success', 'Cooperado adicionado');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
        $cooperado = Cooperado::find($id);
        return view('cooperados.show', compact('cooperado'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
        $cooperado = Cooperado::find($id);

        return view('cooperados.edit', compact('cooperado'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
        $request->validate([
            'nameCoop'=>'required',
            'numCoop'=> 'required|integer',
            'cpfCoop'=> 'required',
            'dtCad'=>'required|date',
            'subscritas'=>'required'
          ]);

          $cooperado = Cooperado::find($id);
          $cooperado->nameCoop = $request->get('nameCoop');
          $cooperado->numCoop = $request->get('numCoop');
          $cooperado->cpfCoop = $request->get('cpfCoop');
          $cooperado->dtCad = $request->get('dtCad');
          $cooperado->dtDem = $request->get('dtDem');
          $cooperado->description = $request->get('description');
          $cooperado->subscritas = $request->get('subscritas');
          $cooperado->integralizadas = $request->get('integralizadas');
          $cooperado->aintegralizar = $request->get('aintegralizar');
          $cooperado->status = $request->get('status');
          $cooperado->save();

          return redirect('/cooperados')->with('success', 'Cooperado atualizado');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    $cooperado = Cooperado::find($id);
    $cooperado->delete();

    return redirect('/cooperados')->with('success', 'Sucess');
    }
}

我试图在我的路线中创建一个功能，但没有奏效。

标签： phplaravel

解决方案

active我为和添加了选项按钮inactive

<form action="/active-deactive" method="POST">
    @csrf
    <div class="input-group">
        <input type="hidden" class="form-control" name="v" value="{{$cooperado->id}}">
            <select required class="form-control" id="status"  name="status">              
                <option value="1">Active</option>  
                <option value="0">De-Active</option>  
            </select>
        </div>
        <button type="submit" class="btn btn-primary">
            <span>Confirm</span>
        </button>
    </div>
</form>

控制器

public function Confirm(Request $request)
{
    $id = $request->input('v');
    $status=$request->input('status');

    DB::table('tablename')
            ->where('id',$id)
            ->update(['status'=>$status]);

}

路线

Route::post('/active-deactive','YourController@Confirm')

推荐阅读