/** * 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; }