/** * Method to get an array of data items * * @return mixed An array of data on success, false on failure. */ public function getItems() { $items = parent::getItems(); //error_log("In AkrecipesModelRecipesbyuser::getItems Count == " . count($items) ) ; foreach ($items as $item) { //get the tags $item->tags = new JHelperTags(); //$item->tags->getItemTags('com_akrecipes.recipe',$item->id); $item->tags->getItemTags($item->type_alias, $item->id); if (isset($item->catid)) { // Get the title of that particular template $title = AkrecipesFrontendHelper::getCategoryNameByCategoryId($item->catid); // Finally replace the data object with proper information $item->catid = !empty($title) ? $title : $item->catid; } if (isset($item->cuisines_id) && $item->cuisines_id != '') { if (is_object($item->cuisines_id)) { $item->cuisines_id = ArrayHelper::fromObject($item->cuisines_id); } $values = is_array($item->cuisines_id) ? $item->cuisines_id : explode(',', $item->cuisines_id); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__akrecipes_cuisines`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->cuisines_id = !empty($textValue) ? implode(', ', $textValue) : $item->cuisines_id; } // set meal_course values if (isset($item->meal_course_id) && $item->meal_course_id != '') { if (is_object($item->meal_course_id)) { $item->meal_course_id = ArrayHelper::fromObject($item->meal_course_id); } $values = is_array($item->meal_course_id) ? $item->meal_course_id : explode(',', $item->meal_course_id); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__akrecipes_meal_course`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->meal_course_id = !empty($textValue) ? implode(', ', $textValue) : $item->meal_course_id; } // set brand values if (isset($item->brand_id) && $item->brand_id != '') { if (is_object($item->brand_id)) { $item->brand_id = ArrayHelper::fromObject($item->brand_id); } $values = is_array($item->brand_id) ? $item->brand_id : explode(',', $item->brand_id); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('brand_name'))->from('`#__akrecipes_brands`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->brand_name; } } $item->brand_id = !empty($textValue) ? implode(', ', $textValue) : $item->brand_id; } } return $items; }
/** * Method to get an array of data items * * @return mixed An array of data on success, false on failure. */ public function getItems() { $items = parent::getItems(); foreach ($items as $item) { if (isset($item->tags)) { // Catch the item tags (string with ',' coma glue) $tags = explode(",", $item->tags); $db = JFactory::getDbo(); // Cleaning and initalization of named tags array $namedTags = array(); // Get the tag names of each tag id foreach ($tags as $tag) { $query = $db->getQuery(true); $query->select("title"); $query->from('`#__tags`'); $query->where("id=" . intval($tag)); $db->setQuery($query); $row = $db->loadObjectList(); // Read the row and get the tag name (title) if (!is_null($row)) { foreach ($row as $value) { if ($value && isset($value->title)) { $namedTags[] = trim($value->title); } } } } // Finally replace the data object with proper information $item->tags = !empty($namedTags) ? implode(', ', $namedTags) : $item->tags; } if (isset($item->catid)) { // Get the title of that particular template $title = AkrecipesFrontendHelper::getCategoryNameByCategoryId($item->catid); // Finally replace the data object with proper information $item->catid = !empty($title) ? $title : $item->catid; } if (isset($item->cuisines_id) && $item->cuisines_id != '') { if (is_object($item->cuisines_id)) { $item->cuisines_id = ArrayHelper::fromObject($item->cuisines_id); } $values = is_array($item->cuisines_id) ? $item->cuisines_id : explode(',', $item->cuisines_id); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__akrecipes_cuisines`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->cuisines_id = !empty($textValue) ? implode(', ', $textValue) : $item->cuisines_id; } if (isset($item->meal_course_id) && $item->meal_course_id != '') { if (is_object($item->meal_course_id)) { $item->meal_course_id = ArrayHelper::fromObject($item->meal_course_id); } $values = is_array($item->meal_course_id) ? $item->meal_course_id : explode(',', $item->meal_course_id); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__akrecipes_meal_course`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->meal_course_id = !empty($textValue) ? implode(', ', $textValue) : $item->meal_course_id; } } return $items; }