Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

If the asker does not get an answer then they have 10 days to request a refund.

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.

If no one challenges a refund request, then they are automatically granted and proccessed after 48 hours. Admins of this site only review refund requests if someone challenges the request. If you are curious about how we handled previous refund requests, you may read over all refund requests and their challenges.

See a chronological view of answers?

Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

• 
  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

Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

If the asker does not get an answer then they have 10 days to request a refund.