wemersonrv

Relacionamentos Laravel #1

Aug 12th, 2014
261
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. class Medico extends Eloquent {
  2.    
  3.     protected $guarded = array('id');
  4.  
  5.     public function postos(){
  6.         return $this->belongsToMany('Posto', 'medico_postos');
  7.     }
  8. }
  9.  
  10. class Posto extends Eloquent {
  11.    
  12.     protected $guarded = array('id');
  13.     protected $foreignKeys = array(
  14.         array('key' => 'hospital_id', 'model' => 'Posto'),
  15.     );
  16.  
  17.     public function hospital(){
  18.         return $this->belongsTo('Hospital', 'hospital_id');
  19.     }
  20. }
  21.  
  22. $medicos = Medico::all();
  23.  
  24. foreach($medicos as $medico){
  25.     echo "<h2>{$medico->nome}</h2>";
  26.     foreach($medico->postos as $posto){
  27.         echo "<h4>{$posto->nome}</h4>";
  28.         echo "<h5>{$posto->hospital->nome}</h5>";
  29.     }
  30. }
  31.  
  32. /*
  33. // Resultado
  34. Dr. João da Silva
  35.  
  36. Posto 1 - HERV
  37. Hospital Evangélico
  38.  
  39. Posto 2 - HERV
  40. Hospital Evangélico
  41.  
  42. ---
  43.  
  44. Dr. Silvio Pereira
  45.  
  46. Posto 1 - HERV
  47. Hospital Evangélico
  48.  
  49. Posto 1 - Hospital Municipal
  50. Hospital Municipal
  51. */
Advertisement
Add Comment
Please, Sign In to add comment