$11

Outputting n:m relationship in dropdown list

Vendor:

    columns:

        id:                 { type: integer(4), primary: true, autoincrement: true }

        name:               { type: string(75), notnull:true }

    relations:

        Location:      { refClass: VendorLocation, local: vendor_id, foreign: location_id }

VendorLocation:

    options:

      symfony:

        form: false

        filter: false

    columns:

        vendor_id:     { type: integer(4), primary: true }

        location_id:   { type: integer(4), primary: true }

Location:

    columns:

        id:             { type: integer(4), primary: true, autoincrement: true }

        name:           { type: string(100), notnull: true }

        city:           { type: string(50), notnull: true }

    relations:

        Vendor:    { class: Vendor, refClass: AccountWarehouse, local: location_id, foreign: vendor_id }

  public function getVendorAndLocation()

  {

    return sprintf('%s - %s (%s, %s)', $this->getVendor()->getName, $this->getName(), $this->getCity(), $this->getZone());

  }

  

 

public function listLocationsByVendorQuery()



  {



    $q = Doctrine_Query::create()



      ->select('l.name, l.city, l.city, l.id, v.id, v.name, vl.*')



      ->from('Location l')



      ->leftJoin('l.VendorLocation vl')



      ->leftJoin('l.Vendor v');      



      return $q;    



  }

    $this->widgetSchema['location_id'] = new sfWidgetFormDoctrineChoiceMany(array(

      'model' => 'Location',

      'query' => Doctrine::getTable('Location')->listLocationsByVendorQuery(),

      'method' => 'getVendorAndLocation',

      'multiple' => false

    ));

webguy | 08/31/10 at 1:42pm | Edit

(3) Possible Answers Submitted...

Note: webguy felt their question was unanswered, so we granted them a refund.

Note: webguy requested a refund. They offered no explanation.

• 
  Last edited:
  08/31/10
  1:51pm
  Joshua Estes says:

  Can you post the code that corresponds with the function listLocationsByVendorQuery() in the LocationTable.class.php?

  • 08/31/10 1:56pm
    
    webguy says:

    lib/model/doctrine/LocationTable.class.php
    
    

      public function listLocationsByVendorQuery()
    
      {
    
        $q = Doctrine_Query::create()
    
          ->select('w.name, w.city, z.code, w.postcode, w.contact, w.phone, w.id, a.id, a.name, aw.*')
    
          ->from('Warehouse w')
    
          ->leftJoin('w.AccountWarehouse aw')
    
          ->leftJoin('w.Zone z')
    
          ->leftJoin('w.Account a');      
    
          return $q;    
    
      }

  • 08/31/10 1:58pm
    
    webguy says:

    Please disregard that last post, look at body of question for accurate code

  • 08/31/10 2:06pm
    
    Joshua Estes says:

    public function getVendorAndLocation()
    {
    
    return sprintf('%s - %s (%s, %s)', $this->getVendor()->getName, $this->getName(), $this->getCity(), $this->getZone());
    
    }

    
    
    Noticed $this->getVendor()->getName doubt it's the issue, but shouldn't it be getName() instead of getName?

  • 08/31/10 2:12pm
    
    Joshua Estes says:

    Try removing the "query" option in the sfWidgetFormDoctrineChoice, that should work for you.

  • 08/31/10 2:28pm
    
    webguy says:

    the getName / getName() thing was a typo when I was writing up that response, so you're correct that's not the issue.
    
    Removing the "query" option is not a suitable solution, I rely on the method to narrow down choices (there is a softdelete and I wish to retain it for other reasons as well).

• 
  Last edited:
  08/31/10
  2:05pm
  Pascal says:

  try that for the widget :
  

  
  
  
  
      $this->widgetSchema['location_id'] = new sfWidgetFormDoctrineChoice(array(
  
        'model' => 'Location',
  
        'table_method' => 'listLocationsByVendorQuery',
  
        'method' => 'getVendorAndLocation',
  
      ));
  
  
  
  

  
  

  • 08/31/10 2:29pm
    
    webguy says:

    Sorry, I checked but that results in the same issue.

• 
  Last edited:
  09/01/10
  7:57am
  Loban Rahman says:

  I feel that you are unnecessarily complicating matters by putting a widget for "location_id" in the ShipForm. What you want is a list of VendorLocation objects, so why not use a widget for that? Don't forget to declare a __toString() method in the VendorLocation model class with the output you want. If you like this idea, I can write up the code necessary for the widget.

This question has expired.

Current status of this question: Refunded

Top Experts (+)

• 
  Jakub Zalas$238 earned (plus $0)
• 
  Loban Rahman$121 earned (plus $0)
• 
  Arturo Linares$114 earned (plus $0)
• 
  Bill Hunt$110 earned (plus $0)
• 
  Florian Klein$88 earned (plus $18)

Top Donors (+)

Top Supporters (+)

• 
  fxsymfony$5 given
• 
  sn$5 given