/** * 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->gender) && $item->gender != '') { if (is_object($item->gender)) { $item->gender = ArrayHelper::fromObject($item->gender); } $values = is_array($item->gender) ? $item->gender : explode(',', $item->gender); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__contact_details`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->gender = !empty($textValue) ? implode(', ', $textValue) : $item->gender; } if (isset($item->event) && $item->event != '') { if (is_object($item->event)) { $item->event = ArrayHelper::fromObject($item->event); } $values = is_array($item->event) ? $item->event : explode(',', $item->event); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__contact_details`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->event = !empty($textValue) ? implode(', ', $textValue) : $item->event; } if (isset($item->tshirt) && $item->tshirt != '') { if (is_object($item->tshirt)) { $item->tshirt = ArrayHelper::fromObject($item->tshirt); } $values = is_array($item->tshirt) ? $item->tshirt : explode(',', $item->tshirt); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__contact_details`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->tshirt = !empty($textValue) ? implode(', ', $textValue) : $item->tshirt; } if (isset($item->blood_type) && $item->blood_type != '') { if (is_object($item->blood_type)) { $item->blood_type = ArrayHelper::fromObject($item->blood_type); } $values = is_array($item->blood_type) ? $item->blood_type : explode(',', $item->blood_type); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__contact_details`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->blood_type = !empty($textValue) ? implode(', ', $textValue) : $item->blood_type; } } 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(); //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->subject) && $item->subject != '') { if (is_object($item->subject)) { $item->subject = ArrayHelper::fromObject($item->subject); } $values = is_array($item->subject) ? $item->subject : explode(',', $item->subject); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('subject'))->from('`#__vocab_subject`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->subject; } } $item->subject = !empty($textValue) ? implode(', ', $textValue) : $item->subject; } if (isset($item->category) && $item->category != '') { if (is_object($item->category)) { $item->category = ArrayHelper::fromObject($item->category); } $values = is_array($item->category) ? $item->category : explode(',', $item->category); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('category'))->from('`#__vocab_category`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->category; } } $item->category = !empty($textValue) ? implode(', ', $textValue) : $item->category; } if (isset($item->frequency) && $item->frequency != '') { if (is_object($item->frequency)) { $item->frequency = ArrayHelper::fromObject($item->frequency); } $values = is_array($item->frequency) ? $item->frequency : explode(',', $item->frequency); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('frequency'))->from('`#__vocab_frequency`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->frequency; } } $item->frequency = !empty($textValue) ? implode(', ', $textValue) : $item->frequency; } if (isset($item->pos) && $item->pos != '') { if (is_object($item->pos)) { $item->pos = ArrayHelper::fromObject($item->pos); } $values = is_array($item->pos) ? $item->pos : explode(',', $item->pos); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('part'))->from('`#__vocab_pos`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->part; } } $item->pos = !empty($textValue) ? implode(', ', $textValue) : $item->pos; } } 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(); //error_log("In AkrecipesModelRecipes::getItems Count == " . count($items) ) ; foreach ($items as $item) { //get the tags $item->tags = new JHelperTags(); $item->tags->getItemTags('com_akrecipes.recipe', $item->id); // 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; } if (isset($item->created_by)) { $item->user = AkrecipesHelper::getUserObject($item->created_by); } } 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->department) && $item->department != '') { if (is_object($item->department)) { $item->department = ArrayHelper::fromObject($item->department); } $values = is_array($item->department) ? $item->department : explode(',', $item->department); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__eiko_organisationen`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->department = !empty($textValue) ? implode(', ', $textValue) : $item->department; } if (isset($item->ausruestung) && $item->ausruestung != '') { if (is_object($item->ausruestung)) { $item->ausruestung = ArrayHelper::fromObject($item->ausruestung); } $values = is_array($item->ausruestung) ? $item->ausruestung : explode(',', $item->ausruestung); $textValue = array(); foreach ($values as $value) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select($db->quoteName('name'))->from('`#__eiko_ausruestung`')->where($db->quoteName('id') . ' = ' . $db->quote($db->escape($value))); $db->setQuery($query); $results = $db->loadObject(); if ($results) { $textValue[] = $results->name; } } $item->ausruestung = !empty($textValue) ? implode(', ', $textValue) : $item->ausruestung; } } return $items; }