StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POZend Dojo FilteringSelect from joined tables How can this be done with Doctrine
primarykey
Id
5765985
data
AcceptedAnswerId
5767336
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-04-23T18:14:06.567
FavoriteCount
0
LastActivityDate
2011-04-25T14:10:53.337
LastEditDate
2011-04-24T15:49:17.603
LastEditorUserId
691876
OwnerUserId
691876
ParentId
0
PostTypeId
1
Score
0
ViewCount
544
LastEditorDisplayName
text
Body
I have a number of FilteringSelect elements within my Zend Framework application that are working fine but they are based on simple queries. I now need to create a FilteringSelect that will allow me to select the id of one table while displaying the text of field in a related table, i.e. I have two tables groomservices and groomprocedures which are related (i.e. groomprocedures.groomProceduresID has many groomservices.procedure). The form I'm trying to create is for an appointments table which has many groomservices.groomServicesID values. I want the user to be able to see the name of the procedure while saving the value of the groomservices.groomServicesID using the FilteringSelect. So far I've not been able to do this in that my FilteringSelect displays nothing, I'm sure this can be done just that the fault is with my inexperience with Zend,Doctrine and Dojo I'm not sure if my problem is with my autocomplete action(including the query) or with the FilteringSelect element. Can anyone spot where I've gone wrong in the code sections below, I need to get this working. My autocomplete action within my controller <pre><code>public function gserviceAction() { // disable layout and view rendering $this->_helper->layout->disableLayout(); $this->getHelper('viewRenderer')->setNoRender(true); // get a list of all grooming services IDs and related procedures $qry= Doctrine_Query::create() ->select('g.groomServicesID,p.groomProcedure') ->from('PetManager_Model_Groomservices g') ->leftJoin('g.PetManager_Model_Groomprocedures p'); $result=$qry->fetchArray(); //generate and return JSON string $data = new Zend_Dojo_Data('g.groomServicesID',$result); echo $data->toJson(); } </code></pre> My FilteringSelect element code <pre><code> // Create a autocomplete select input for the service $gservice = new Zend_Dojo_Form_Element_FilteringSelect('gapmtService'); $gservice->setLabel('Proceedure'); $gservice->setOptions(array( 'autocomplete' => true, 'storeID' => 'gserviceStore', 'storeType' => 'dojo.data.ItemFileReadStore', 'storeParams' => array('url' => "/groomappointments/appointment/gservice"), 'dijitParams' => array('searchAttr' => 'groomProcedure'))) ->setRequired(true) ->addValidator('NotEmpty', true) ->addFilter('HTMLEntities') ->addFilter('StringToLower') ->addFilter('StringTrim'); </code></pre> Many thanks in advance, Graham P.S. orgot to mention I tried the following query in mysql and I gave me what I'm looking for I believe the Doctine query evaluates to the same. <pre><code>select groomservices.groomservicesID,groomprocedures.groomprocedure from groomprocedures left join groomservices on groomprocedures.groomproceduresID =groomservices.groomProcedure </code></pre> But I'm not sure if I formatted the query correctly in Doctrine. EDIT in relation to the flammon's comments Ok I've set the code to the following but I'm still not getting anything to display. <pre><code>public function gserviceAction() { $ajaxContext = $this->_helper->getHelper('AjaxContext'); $ajaxContext->addActionContexts(array( 'gservice' => 'json' )); // get a list of all grooming services IDs and related procedures $qry= Doctrine_Query::create() ->select('g.groomServicesID AS id,p.groomprocedure AS name') ->from('PetManager_Model_Groomservices g') ->leftJoin('g.PetManager_Model_Groomprocedures p'); $this->view->model = (object) array(); $this->view->model->identifier = 'id'; $this->view->model->label = 'name'; $this->view->model->items = array(); $tableRows = $this->dbTable->fetchAll($qry); foreach ($tableRows as $row) { $this->view->model->items[] = $row->toArray(); } } </code></pre> I'm sure the fault lies with me.
Tags
<zend-framework><dojo><doctrine>
Title
Zend Dojo FilteringSelect from joined tables How can this be done with Doctrine
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USGraham
UserOwnerUserId
1. USGraham
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.