I am calling a Model inside of a Component to use as a faceted search
Component. However, in two different contexts, I'm getting widely different
results.
The function seems to work fine when I'm loading a page, however, when using
the AJAX call, I'm getting the "You have an error in your SQL syntax" error,
because instead of calling the Model function, CakePHP seems to be just
passing the name of the function on as a query string. I understand that
this is generally because the function is not being recognized, I'm just not
sure why its not being recognized in this instance.
Here is the function where the Model is being called with
ClassRegistry::init():
/*
// __facetConditions: Assembles subqueries for each facet/value pair
// @var arr $facets: Array of facet/value pair arrays
// @data arr $conditions: Model-usable array of subqueries.
*/
private function __facetConditions($facets) {
$fif = ClassRegistry::init('FacetedItemsFacet');
$conditions = array();
$aCount = 2;
// We need to create a subquery for every facet/value pair:
foreach($facets as $key=>$value) :
$subq = $fif->subquery(array(
'fields' => array('FacetedItemsFacet' . $aCount . '.faceted_item_id'),
'conditions' => array('Facet' . $aCount . '.name' => $value[0],
'FacetedItemsFacet' . $aCount . '.value' => $value[1]),
'count' => $aCount),
'FacetedItemsFacet' . $aCount);
$conditions[] = '`FacetedItemsFacet`.`faceted_item_id` IN (`' . $subq .
'`)';
$aCount++;
endforeach;
return $conditions;
}
This function is being called inside another function in the same Component.
And that same function is being called in both contexts, which confuses me
further. For illustration purposes, here is that calling function:
/*
// searchItems: Common function that returns all items matching the current
set of sku's and facets/values
// @var mixed $skus: Either an array of sku's or else null
// @var mixed $facets: Either an associative array of facet/value pairs or
null.
// @var bool $or: Specifies we would like to find items matching any (OR)
values set.
*/
function search($skus=null, $facets=null, $or=false) {
$fif = ClassRegistry::init('FacetedItemsFacet');
$fi = ClassRegistry::init('FacetedItem');
$wpv = ClassRegistry::init('WebPriceView');
$i = ClassRegistry::init('Item');
// No input, no output:
if(empty($skus) && empty($facets)) :
$items = array();
// Otherwise, roll with it:
else :
$conditions = array();
if(!empty($facets)) :
$conditions = $this->__facetConditions($facets);
endif;
// If we have SKUs as well, add them to the conditions array:
if(!empty($skus)) :
$conditions[] = $this->__skuConditions($skus);
endif;
// Toggle AND or OR statements:
$or ? $conditions = array('OR' => $conditions) : $conditions;
// Finally, get our list of matching items:
$items = $fif->find('list', array('conditions' => $conditions,
'fields' => array('FacetedItemsFacet.faceted_item_id'),
'group' => array('FacetedItemsFacet.faceted_item_id')));
endif;
// Get the full details of the Items, including Web Price View and Siteline
Item data
$fItems = $fi->getItems($items);
foreach($fItems as $key=>$item) :
$prices = $wpv->getPrices($item['FacetedItem']['item']);
$detail = $i->getItem($item['FacetedItem']['item']);
$fItems[$key]['WebPriceView'] = $prices['WebPriceView'];
$fItems[$key]['Detail'] = $detail['Item'];
// Re-order the Facets by their ID so they're easier to call out in the
final Charts:
$fItems[$key]['Facet'] = Set::combine($fItems[$key]['Facet'], '{n}.id',
'{n}');
endforeach;
return $fItems;
}
As I'm looking at this, I wonder if perhaps its a scope problem? Would it be
more efficient to declare the ClassRegistry-initialized Objects as Object
properties? Or is this not the problem?
Thank you for your help with this issue!
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
