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