vendredi 13 octobre 2017

Laravel show data 3 table

I have the following tables:flights(id,title, number), stations(id,title), flight_price(id, price, flight_id, stationA_id, stationB_id) and pivot flight_station(flight_id, station_id)

My models

    class Flight extends Model
    {
       public function stations()
        {
            return $this->belongsToMany('App\Model\Station', 'flight_station', 'flight_id', 'station_id')
        }
//for attach data
    public function prices()
        {
            return $this->belongsToMany('App\Model\FlightPrice', 'flight_price', 'flight_id','stationA_id')
                ->withPivot('price');
        }

     public function price()
        {
            return $this->hasMany('App\Model\FlightPrice','flight_id');
        }
    }

    //Station
    class Station extends Model
    {
        public function flights()
        {
            return $this->belongsToMany('App\Model\Flight', 'flight_station', 'station_id', 'flight_id');
        }


    }
    class FlightPrice extends Model
    {
        protected $table = 'flight_price';

        public function flights()
        {
            return $this->belongsToMany('App\Model\Flight', 'flight_price');
        }


    }

I need the next result (find by id flight): |stationA_id|stationA_title||stationB_id|stationB_title|price|



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire