public static function checkAliasExists($alias, $id = 0)
{
$xid = (int) ItemHelper::translateAliasToID($alias);
if ($xid && $xid != (int) $id) {
return true;
}
return false;
}
public function save($object)
{
if (!is_string($object->type) || empty($object->type)) {
throw new ItemTableException('Invalid type id');
}
if ($object->name == '') {
throw new ItemTableException('Invalid name');
}
if ($object->alias == '' || $object->alias != YString::sluggify($object->alias)) {
throw new ItemTableException('Invalid slug');
}
if (ItemHelper::checkAliasExists($object->alias, $object->id)) {
throw new ItemTableException('Alias already exists, please choose a unique alias');
}
// first save to get id
if (empty($object->id)) {
parent::save($object);
}
// init vars
$db = $this->getDBO();
$search_data = array();
$element_data = array();
foreach ($object->getElements() as $id => $element) {
// get element data
$element_data[] = $element->toXML();
// get search data
if ($data = $element->getSearchData()) {
$search_data[] = "(" . $object->id . ", " . $db->quote($id) . ", " . $db->quote($data) . ")";
}
}
// set element data
$object->elements = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<elements>\n" . implode("\n", $element_data) . "\n</elements>";
// delete old search data
$query = "DELETE FROM " . ZOO_TABLE_SEARCH . " WHERE item_id = " . (int) $object->id;
$db->query($query);
// insert new search data
if (count($search_data)) {
$query = "INSERT INTO " . ZOO_TABLE_SEARCH . " VALUES " . implode(", ", $search_data);
$db->query($query);
}
// save tags
YTable::getInstance('tag')->save($object->id, $object->getTags());
return parent::save($object);
}
<?php
include 'header.php';
$feed = FeedMapper::instance()->find($_GET['id']);
$item_helper = new ItemHelper();
?>
<table>
<th>id</th><th>title</th>
<?php
foreach ($feed->items() as $item) {
?>
<tr>
<td><?php
echo $item->id();
?>
</td>
<td><?php
echo $item_helper->link($item);
?>
</td>
</tr>
<?php
}
?>
public static function importCSV($file, $type = '', $contains_headers = false, $field_separator = ',', $field_enclosure = '"', $element_assignment = array())
{
// get application
if ($application = Zoo::getApplication()) {
if ($type_obj = $application->getType($type)) {
$c = 0;
$assignments = array();
foreach ($element_assignment as $column => $value) {
if (!empty($value[$type])) {
$name = $value[$type];
$assignments[$name][] = $column;
}
}
if (!isset($assignments['_name'])) {
throw new ImportHelperException('No item name was assigned.');
}
if (($handle = fopen($file, "r")) !== FALSE) {
$item_table = YTable::getInstance('item');
$category_table = YTable::getInstance('category');
$user_id = JFactory::getUser()->get('id');
$now = JFactory::getDate();
$row = 0;
$app_categories = $application->getCategories();
$app_categories = array_map(create_function('$cat', 'return $cat->name;'), $app_categories);
$elements = $type_obj->getElements();
while (($data = fgetcsv($handle, 0, $field_separator, $field_enclosure)) !== FALSE) {
if (!($contains_headers && $row == 0)) {
$item = new Item();
$item->application_id = $application->id;
$item->type = $type;
// store created by
$item->created_by = $user_id;
// set created
$item->created = $now->toMySQL();
// store modified_by
$item->modified_by = $user_id;
// set modified
$item->modified = $now->toMySQL();
// store element_data and item name
$item_categories = array();
foreach ($assignments as $assignment => $columns) {
$column = current($columns);
switch ($assignment) {
case '_name':
$item->name = $data[$column];
break;
case '_created_by_alias':
$item->created_by_alias = $data[$column];
break;
case '_created':
if (!empty($data[$column])) {
$item->created = $data[$column];
}
break;
default:
if (substr($assignment, 0, 9) == '_category') {
foreach ($columns as $column) {
$item_categories[] = $data[$column];
}
} else {
if (isset($elements[$assignment])) {
$elements[$assignment]->unsetData();
switch ($elements[$assignment]->getElementType()) {
case 'text':
case 'textarea':
case 'link':
case 'email':
case 'date':
$element_data = array();
foreach ($columns as $column) {
if (!empty($data[$column])) {
$element_data[$column] = array('value' => $data[$column]);
}
}
$elements[$assignment]->bindData($element_data);
break;
case 'gallery':
$data[$column] = trim($data[$column], '/\\');
$elements[$assignment]->bindData(array('value' => $data[$column]));
break;
case 'image':
case 'download':
$elements[$assignment]->bindData(array('file' => $data[$column]));
break;
case 'googlemaps':
$elements[$assignment]->bindData(array('location' => $data[$column]));
break;
}
}
}
break;
}
}
$elements_string = '<?xml version="1.0" encoding="UTF-8"?><elements>';
foreach ($elements as $element) {
$elements_string .= $element->toXML();
}
$elements_string .= '</elements>';
$item->elements = $elements_string;
$item->alias = YString::sluggify($item->name);
if (empty($item->alias)) {
$item->alias = '42';
}
// set a valid category alias
while (ItemHelper::checkAliasExists($item->alias)) {
$item->alias .= '-2';
}
if (!empty($item->name)) {
try {
$item_table->save($item);
$item_id = $item->id;
$item->unsetElementData();
// store categories
foreach ($item_categories as $category_name) {
if (!in_array($category_name, $app_categories)) {
$category = new Category();
$category->application_id = $application->id;
$category->name = $category_name;
$category->parent = 0;
$category->alias = YString::sluggify($category_name);
// set a valid category alias
while (CategoryHelper::checkAliasExists($category->alias)) {
$category->alias .= '-2';
}
try {
$category_table->save($category);
$related_categories[$category->id] = $category->name;
$app_categories[$category->id] = $category->name;
} catch (CategoryTableException $e) {
}
} else {
$related_categories = array_filter($app_categories, create_function('$cat', 'return $cat=="' . $category_name . '";'));
}
// add category to item relations
if (!empty($related_categories)) {
CategoryHelper::saveCategoryItemRelations($item_id, array_keys($related_categories));
}
}
} catch (ItemTableException $e) {
}
}
}
$row++;
}
fclose($handle);
return true;
} else {
throw new ImportHelperException('Could not open csv file.');
}
} else {
throw new ImportHelperException('Could not find type.');
}
}
throw new ImportHelperException('No application to import too.');
}
public function docopy()
{
// check for request forgeries
YRequest::checkToken() or jexit('Invalid Token');
// init vars
$now = JFactory::getDate();
$post = YRequest::get('post');
$cid = YRequest::getArray('cid', array(), 'int');
if (count($cid) < 1) {
JError::raiseError(500, JText::_('Select a item to copy'));
}
try {
// get item table
$item_table = YTable::getInstance('item');
$tag_table = YTable::getInstance('tag');
// get database
$db = YDatabase::getInstance();
// copy items
foreach ($cid as $id) {
// get item
$item = $item_table->get($id);
$elements = $item->getElements();
$categories = $item->getRelatedCategoryIds();
// copy item
$item->id = 0;
// set id to 0, to force new item
$item->name .= ' (' . JText::_('Copy') . ')';
// set copied name
$item->alias = ItemHelper::getUniqueAlias($id, $item->alias . '-copy');
// set copied alias
$item->state = 0;
// unpublish item
$item->created = $now->toMySQL();
$item->created_by = $this->user->get('id');
$item->modified = $now->toMySQL();
$item->modified_by = $this->user->get('id');
$item->hits = 0;
// copy tags
$item->setTags($tag_table->getItemTags($id));
// save copied item/element data
$item_table->save($item);
// save category relations
CategoryHelper::saveCategoryItemRelations($item->id, $categories);
}
// set redirect message
$msg = JText::_('Item Copied');
} catch (YException $e) {
// raise notice on exception
JError::raiseNotice(0, JText::_('Error Copying Item') . ' (' . $e . ')');
$msg = null;
}
$this->setRedirect($this->baseurl, $msg);
}
function ZooParseRoute($segments)
{
// init vars
$vars = array();
$count = count($segments);
// fix segments (see JRouter::_decodeSegments)
foreach (array_keys($segments) as $key) {
$segments[$key] = str_replace(':', '-', $segments[$key]);
}
// frontpage (with optional pagination)
$task = 'frontpage';
if ($count == 1 && $segments[0] == $task) {
$vars['task'] = $task;
}
if ($count == 2 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['page'] = (int) $segments[1];
}
// category (with optional pagination)
$task = 'category';
if ($count == 2 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['category_id'] = (int) CategoryHelper::translateAliasToID($segments[1]);
}
if ($count == 3 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['category_id'] = (int) CategoryHelper::translateAliasToID($segments[1]);
$vars['page'] = (int) $segments[2];
}
// alpha index (with optional pagination)
$task = 'alphaindex';
if ($count == 3 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['app_id'] = (int) ApplicationHelper::translateAliasToID($segments[1]);
$vars['alpha_char'] = (string) $segments[2];
}
if ($count == 4 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['app_id'] = (int) ApplicationHelper::translateAliasToID($segments[1]);
$vars['alpha_char'] = (string) $segments[2];
$vars['page'] = (int) $segments[3];
}
// tag (with optional pagination)
$task = 'tag';
if ($count == 3 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['app_id'] = (int) ApplicationHelper::translateAliasToID($segments[1]);
$vars['tag'] = (string) $segments[2];
}
if ($count == 4 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['app_id'] = (int) ApplicationHelper::translateAliasToID($segments[1]);
$vars['tag'] = (string) $segments[2];
$vars['page'] = (int) $segments[3];
}
// item
$task = 'item';
if ($count == 2 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['item_id'] = (int) ItemHelper::translateAliasToID($segments[1]);
}
// feed
$task = 'feed';
if ($count == 3 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['type'] = (string) $segments[1];
$vars['app_id'] = (string) $segments[2];
}
if ($count == 4 && $segments[0] == $task) {
$vars['task'] = $task;
$vars['type'] = (string) $segments[1];
$vars['app_id'] = (string) $segments[2];
$vars['category_id'] = (int) CategoryHelper::translateAliasToID($segments[3]);
}
// submission
$task = 'submission';
$layout = 'submission';
if ($count == 2 && $segments[0] == $task && $segments[1] == $layout) {
$vars['task'] = $task;
$vars['layout'] = (string) $segments[1];
}
if ($count == 5 && $segments[0] == $task && $segments[1] == $layout) {
$vars['task'] = $task;
$vars['layout'] = (string) $segments[1];
$vars['submission_id'] = (int) SubmissionHelper::translateAliasToID($segments[2]);
$vars['type_id'] = (string) $segments[3];
$vars['submission_hash'] = (string) $segments[4];
}
if ($count == 6 && $segments[0] == $task && $segments[1] == $layout) {
$vars['task'] = $task;
$vars['layout'] = (string) $segments[1];
$vars['submission_id'] = (int) SubmissionHelper::translateAliasToID($segments[2]);
$vars['type_id'] = (string) $segments[3];
$vars['submission_hash'] = (string) $segments[4];
$vars['item_id'] = (int) ItemHelper::translateAliasToID($segments[5]);
}
// submission mysubmissions
$task = 'submission';
$layout = 'mysubmissions';
if ($count == 2 && $segments[0] == $task && $segments[1] == $layout) {
$vars['task'] = $task;
$vars['layout'] = (string) $segments[1];
}
if ($count == 3 && $segments[0] == $task && $segments[1] == $layout) {
$vars['task'] = $task;
$vars['layout'] = (string) $segments[1];
$vars['submission_id'] = (int) SubmissionHelper::translateAliasToID($segments[2]);
}
return $vars;
}
// get menu
$menu_params = JSite::getMenu()->getParams($Itemid);
// retrieve item id from menu item
if (!isset($query['submission_id'])) {
$query['submission_id'] = $menu_params->get('submission');
$query['type_id'] = $menu_params->get('type');
$query['item_id'] = $menu_params->get('item_id');
$query['submission_hash'] = '';
}
if ($query['layout'] == 'submission') {
$title[] = $task;
$title[] = $query['layout'];
$title[] = SubmissionHelper::translateIDToAlias((int) $query['submission_id']);
$title[] = $query['type_id'];
$title[] = $query['submission_hash'];
$title[] = ItemHelper::translateIDToAlias((int) @$query['item_id']);
shRemoveFromGETVarsList('layout');
shRemoveFromGETVarsList('submission_id');
shRemoveFromGETVarsList('type_id');
shRemoveFromGETVarsList('submission_hash');
shRemoveFromGETVarsList('item_id');
} else {
if ($query['layout'] == 'mysubmissions') {
$title[] = $task;
$title[] = $query['layout'];
$title[] = SubmissionHelper::translateIDToAlias((int) $query['submission_id']);
shRemoveFromGETVarsList('layout');
shRemoveFromGETVarsList('submission_id');
}
}
break;
public function save()
{
// check for request forgeries
YRequest::checkToken() or jexit('Invalid Token');
// init vars
$post = JRequest::get('post');
$db = YDatabase::getInstance();
$tzoffset = JFactory::getConfig()->getValue('config.offset');
$now = JFactory::getDate();
$now->setOffset($tzoffset);
$msg = '';
try {
$this->_init();
// is this an item edit?
$edit = (int) $this->item->id;
// is current user the item owner and does the user have sufficient user rights
if ($edit && (!$this->item->canAccess($this->user) || $this->item->created_by != $this->user->id)) {
throw new YControllerException('You are not allowed to make changes to this item.');
}
// get default category - only in none trusted mode
$categories = array();
if (!$this->submission->isInTrustedMode() && ($category = $this->submission->getForm($this->type->id)->get('category'))) {
$categories[] = $category;
}
// get element data from post
if (isset($post['elements'])) {
// filter element data
if (!$this->submission->isInTrustedMode() && !UserHelper::isJoomlaAdmin($this->user)) {
JRequest::setVar('elements', SubmissionHelper::filterData($post['elements']));
$post = JRequest::get('post');
}
// merge elements into post
$post = array_merge($post, $post['elements']);
}
// fix publishing dates in trusted mode
if ($this->submission->isInTrustedMode()) {
// set publish up date
if (isset($post['publish_up'])) {
if (empty($post['publish_up'])) {
$post['publish_up'] = $now->toMySQL(true);
}
}
// set publish down date
if (isset($post['publish_down'])) {
if (trim($post['publish_down']) == JText::_('Never') || trim($post['publish_down']) == '') {
$post['publish_down'] = $db->getNullDate();
}
}
}
// sanatize tags
if (!isset($post['tags'])) {
$post['tags'] = array();
}
// build new item form and bind it with post data
$form = new ItemForm(array('submission' => $this->submission, 'item' => $this->item, 'elements_config' => $this->elements_config));
$form->bind($post);
// save item if form is valid
if ($form->isValid()) {
// set name
$this->item->name = $form->getValue('name');
// bind elements
foreach ($this->elements_config as $data) {
if (($element = $this->item->getElement($data->element)) && ($field = $form->getFormField($data->element))) {
if ($field_data = $field->hasError() ? $field->getTaintedValue() : $field->getValue()) {
$element->bindData($field_data);
} else {
$element->bindData();
}
// perform submission uploads
if ($element instanceof iSubmissionUpload) {
$element->doUpload();
}
}
}
// set alias
$this->item->alias = ItemHelper::getUniqueAlias($this->item->id, YString::sluggify($this->item->name));
// set modified
$this->item->modified = $now->toMySQL();
$this->item->modified_by = $this->user->get('id');
// creating new item
if (!$edit) {
// set state
$this->item->state = 0;
// set created date
$this->item->created = $now->toMySQL();
$this->item->created_by = $this->user->get('id');
$this->item->created_by_alias = '';
// set publish up - publish down
$this->item->publish_up = $now->toMySQL();
$this->item->publish_down = $db->getNullDate();
// set access
$this->item->access = 0;
// set searchable
$this->item->searchable = 1;
}
if ($this->submission->isInTrustedMode()) {
// set state
$this->item->state = $form->getValue('state');
// set publish up
if (($publish_up = $form->getValue('publish_up')) && !empty($publish_up)) {
$date = JFactory::getDate($publish_up, $tzoffset);
$publish_up = $date->toMySQL();
}
$this->item->publish_up = $publish_up;
// set publish down
if (($publish_down = $form->getValue('publish_down')) && !empty($publish_down) && !($publish_down == $db->getNullDate())) {
$date = JFactory::getDate($publish_down, $tzoffset);
$publish_down = $date->toMySQL();
}
$this->item->publish_down = $publish_down;
// set searchable
$this->item->searchable = $form->getValue('searchable');
// set comments enabled
$this->item->params = $this->item->getParams()->set('config.enable_comments', $form->getValue('enable_comments'))->toString();
// set frontpage
if ($form->getValue('frontpage')) {
$categories[] = 0;
}
// set categories
$tmp_categories = $form->getValue('categories');
if (!empty($tmp_categories)) {
foreach ($form->getValue('categories') as $category) {
$categories[] = $category;
}
}
// set tags
$tags = $form->hasError('tags') ? $form->getTaintedValue('tags') : $form->getValue('tags');
$this->item->setTags($tags);
} else {
// spam protection - user may only submit items every SubmissionController::TIME_BETWEEN_PUBLIC_SUBMISSIONS seconds
if (!$edit) {
$timestamp = $this->session->get('ZOO_LAST_SUBMISSION_TIMESTAMP');
$now = time();
if ($now < $timestamp + SubmissionController::TIME_BETWEEN_PUBLIC_SUBMISSIONS) {
throw new SubmissionControllerException('You are submitting to fast, please try again in a few moments.');
}
$this->session->set('ZOO_LAST_SUBMISSION_TIMESTAMP', $now);
}
}
// save item
YTable::getInstance('item')->save($this->item);
// save category relations - only if editing in trusted mode
if (!$edit || $this->submission->isInTrustedMode()) {
CategoryHelper::saveCategoryItemRelations($this->item->id, $categories);
}
// set redirect message
$msg = $this->submission->isInTrustedMode() ? JText::_('Thanks for your submission.') : JText::_('Thanks for your submission. It will be reviewed before being posted on the site.');
// add form to session if form is not valid
} else {
$this->addFormToSession($form);
}
} catch (SubmissionControllerException $e) {
// raise warning on exception
JError::raiseWarning(0, (string) $e);
} catch (YException $e) {
// raise warning on exception
JError::raiseWarning(0, JText::_('There was an error saving your submission, please try again later.'));
// add exception details, for super administrators only
if ($this->user->superadmin) {
JError::raiseWarning(0, (string) $e);
}
}
// redirect to mysubmissions
if ($this->redirect == 'mysubmissions' && $form && $form->isValid()) {
$link = RouteHelper::getMySubmissionsRoute($this->submission);
// redirect to edit form
} else {
$link = RouteHelper::getSubmissionRoute($this->submission, $this->type->id, $this->hash, $this->item_id, $this->redirect);
}
$link = JRoute::_($link, false);
$this->setRedirect($link, $msg);
}
$app->alias = ApplicationHelper::getUniqueAlias($app->id, YString::sluggify($app->name));
try {
$table->save($app);
} catch (ApplicationTableException $e) {
}
}
}
// set primary category for each item
$table = YTable::getInstance('item');
$items = $table->all();
foreach ($items as $item) {
if ($item->getPrimaryCategoryId() != null) {
continue;
}
$relatedCategoriesIds = $item->getRelatedCategoryIds();
$relatedCategoriesIds = array_filter($relatedCategoriesIds, create_function('$id', 'return !empty($id);'));
if (!empty($relatedCategoriesIds)) {
// set params
$item->params = $item->getParams()->set('config.primary_category', array_shift($relatedCategoriesIds))->toString();
$item->alias = YString::sluggify($item->alias);
if (empty($item->alias)) {
ItemHelper::getUniqueAlias($item->id, YString::sluggify($item->name));
}
// save item
try {
$table->save($item);
} catch (ItemTableException $e) {
}
}
}
}
protected function _itemToXML(Item $item)
{
$attributes = array();
foreach (self::$item_attributes as $attribute) {
if (isset($item->{$attribute})) {
$attributes[$attribute] = $item->{$attribute};
}
}
$attributes['author'] = JFactory::getUser($item->created_by)->username;
$item_xml = $this->_buildItem($item->alias, $item->name, $attributes);
foreach ($item->getRelatedCategoryIds() as $category_id) {
$alias = '';
if (empty($category_id)) {
$alias = '_root';
} else {
if (isset($this->categories[$category_id])) {
$alias = $this->categories[$category_id]->alias;
}
}
if (!empty($alias)) {
$this->_addItemCategory($item_xml, $alias);
}
}
foreach ($item->getTags() as $tag) {
$this->_addItemTag($item_xml, $tag);
}
foreach ($item->getElements() as $element) {
$xml = YXML::loadString('<wrapper>' . $element->toXML() . '</wrapper>');
foreach ($xml->children() as $element_xml) {
$element_xml->addAttribute('name', $element->getConfig()->get('name'));
$this->_addItemData($item_xml, $element_xml);
}
}
$metadata = array();
foreach ($item->getParams()->get('metadata.', array()) as $key => $value) {
$metadata[preg_replace('/^metadata\\./', '', $key)] = $value;
}
if (!empty($metadata)) {
$this->_addItemMetadata($item_xml, $metadata);
}
// sanitize relateditems elements
$related_item_xmls = $item_xml->xpath('data/relateditems/item');
if ($related_item_xmls) {
foreach ($related_item_xmls as $related_item_xml) {
$item_xml->replaceChild(YXMLElement::create('item', ItemHelper::translateIDToAlias((string) $related_item_xml), true), $related_item_xml);
}
}
return $item_xml;
}
