mercredi 14 février 2018

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value:

I have two tables, a table "métier" and a table "tâche" with one to many connection, a "métier" has several "tâche". In my form "ajouter tâches" I have a combobox from which I choose the "métier" associated with the "tâche". these are my tables and how I proceeded and the error i got. Could anyone help me with that ?

Model metier

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class metier extends Model
{
public function metier()
{
    return $this->hasMany(Tache::class);
}
}

Model metier

    <?php

    namespace App;

    use Illuminate\Database\Eloquent\Model;

    class tache extends Model
    {
        public function metier()
        {
            return $this->belongsTo(Metier::class);
        }

        public function tarificationtache()
        {
            return $this->hasMany(Tarificationtache::class);
        }


    }

create tache.blade.php

 @extends('Layouts/app')
    @section('content')
        @if(count($errors))
        <div class="alert alert-danger" role="alert">
         <ul>
            @foreach($errors ->all() as $message)
             <li></li>
                @endforeach
         </ul>
        </div>
        @endif
        <div class="container">
            <div class="row"></div>
            <div class="col-md-12">
                <form action=" " method="post">
                 


                    <div class="form-group">
                        <label for="">Libelle Tache</label>
                        <input type="text"  name ="libelle_tache" 
  class="form-control"value="">
                    </div>
                    <div class="form-group">
                        <label for="">Tarif</label>
                        <input type="text"  name ="Tarif" class="form-
  control"value="">
                    </div>




                    <div class="form-group">
                        <label for="metier">metier</label>
                        <select name="metier_id" id="metier" class="form-
        control">

                                @foreach($metiers as $metier)
                                 <option value="">
                                    
                                 </option>
                                @endforeach
                        </select>
                    </div>




                    <div class="form-group">
                        <input type="submit" value = "enregistrer" 
         class="form-control btn btn-primary">
                     </div>
                </form>
            </div>
        </div>


        <script>

    @endsection

tache controller

 <?php
 namespace App\Http\Controllers;
 use Illuminate\Http\Request;
 use App\Tache;
 use App\Metier;
 class TacheController extends Controller
 {
  /**
   * Display a listing of the resource.
   *
   * @return \Illuminate\Http\Response
   */
  public function index()
  {
    $Listmetier=metier::orderBy('libelle_metier')->get();
    $Listtache=tache::all();
    return view('tache.index',['tache'=>$Listtache]);


}

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

    //$metiers = Costcenter::lists('libelle_metier', 'id');
    $metiers = Metier::orderBy('id', 'desc')->get();
    return view('tache.create')->with('metiers', $metiers);
}

/**
 * Store a newly created resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @return \Illuminate\Http\Response
 */
public function store(Request $request)
{
    $tache = new Tache();
    $tache ->libelle_tache =$request->input('libelle_tache');
    $tache ->Tarif =$request->input('Tarif');
    $tache ->metier_id = $request->input('metier_id');
    $tache->save();
    return redirect('tache');
}

/**
 * Display the specified resource.
 *
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
public function show($id)
{
    //
}

/**
 * Show the form for editing the specified resource.
 *
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
public function edit($id)
{
    $tache=Tache::find($id);
    return view('tache.edit',['libelle_tache'=>$metier],['Tarif'=>$tache]);
}

/**
 * Update the specified resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
public function update(Request $request, $id)
{
    //
}

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

    return redirect('tache');
  }
}

SQLSTATE[22007] [enter image description here]1



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire