/**
* Method to get an array of Intervention Objects.
*
* @return mixed An array of Intervention Objects on success, false on failure.
*
*/
public function getCountryCountryInterventionBcbb_DD($country)
{
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Get from #__costbenefitprojection_intervention as dd
$query->select($db->quoteName(array('dd.id', 'dd.name', 'dd.type', 'dd.coverage', 'dd.duration', 'dd.share', 'dd.description', 'dd.reference', 'dd.interventions', 'dd.intervention', 'dd.published', 'dd.created_by', 'dd.modified_by', 'dd.created', 'dd.modified'), array('id', 'name', 'type', 'coverage', 'duration', 'share', 'description', 'reference', 'interventions', 'intervention', 'published', 'created_by', 'modified_by', 'created', 'modified')));
$query->from($db->quoteName('#__costbenefitprojection_intervention', 'dd'));
$query->where('dd.country = ' . $db->quote($country));
$query->where('dd.published = 1');
$query->order('dd.ordering ASC');
// Reset the query using our newly populated query object.
$db->setQuery($query);
$db->execute();
// check if there was data returned
if ($db->getNumRows()) {
$items = $db->loadObjectList();
// Convert the parameter fields into objects.
foreach ($items as $nr => &$item) {
if (CostbenefitprojectionHelper::checkString($item->interventions)) {
// Decode interventions
$item->interventions = json_decode($item->interventions, true);
}
// Make sure the content prepare plugins fire on description.
$item->description = JHtml::_('content.prepare', $item->description);
// Checking if description has uikit components that must be loaded.
$this->uikitComp = CostbenefitprojectionHelper::getUikitComp($item->description, $this->uikitComp);
// Make sure the content prepare plugins fire on reference.
$item->reference = JHtml::_('content.prepare', $item->reference);
// Checking if reference has uikit components that must be loaded.
$this->uikitComp = CostbenefitprojectionHelper::getUikitComp($item->reference, $this->uikitComp);
}
return $items;
}
return false;
}
/**
* Method to get an array of Service_provider Objects.
*
* @return mixed An array of Service_provider Objects on success, false on failure.
*
*/
public function getIdCountryService_providerCace_B($id)
{
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Get from #__costbenefitprojection_service_provider as b
$query->select($db->quoteName(array('b.id', 'b.user', 'b.publicname', 'b.publicemail', 'b.publicnumber', 'b.publicaddress'), array('id', 'user', 'publicname', 'publicemail', 'publicnumber', 'publicaddress')));
$query->from($db->quoteName('#__costbenefitprojection_service_provider', 'b'));
$query->where('b.country = ' . $db->quote($id));
$query->where('b.published = 1');
$query->order('b.publicname ASC');
// Reset the query using our newly populated query object.
$db->setQuery($query);
$db->execute();
// check if there was data returned
if ($db->getNumRows()) {
$items = $db->loadObjectList();
// Convert the parameter fields into objects.
foreach ($items as $nr => &$item) {
// Make sure the content prepare plugins fire on publicaddress.
$item->publicaddress = JHtml::_('content.prepare', $item->publicaddress);
// Checking if publicaddress has uikit components that must be loaded.
$this->uikitComp = CostbenefitprojectionHelper::getUikitComp($item->publicaddress, $this->uikitComp);
}
return $items;
}
return false;
}
