/administrator/components/com_zoo/classes/exporter/k2.php

<?php

/**
* @package   com_zoo
* @author    YOOtheme http://www.yootheme.com
* @copyright Copyright (C) YOOtheme GmbH
* @license   http://www.gnu.org/licenses/gpl.html GNU/GPL
*/


/**

 * Exporter for K2 items and categories

 * 

 * @package Component.Classes.Exporters

 */

class AppExporterK2 extends AppExporter {



	/**

	 * Class Constructor

	 */

	public function __construct() {

		parent::__construct();

		$this->_name = 'K2';

	}

	

	/**

	 * If K2 is installed on the system

	 * 

	 * @return boolean If K2 is installed on the system

	 * 

	 * @since 2.0

	 */

	public function isEnabled() {

		$path_to_xml = JPATH_ADMINISTRATOR . '/components/com_k2/manifest.xml';

		if (JFile::exists($path_to_xml) && ($data = JApplicationHelper::parseXMLInstallFile($path_to_xml))) {

            return (version_compare($data['version'], '2.1') >= 0);

		}



		return false;

	}



	/**

	 * Do the real export of items and categories

	 * 

	 * @return string The JSON dump of the items and categories

	 * 

	 * @since 2.0

	 */

	public function export() {



		$db = $this->app->database;



		// get k2 categories

	    $query = "SELECT a.*, b.name AS extra_field_group_name "

	    		." FROM #__k2_categories AS a"

	       		." LEFT JOIN #__k2_extra_fields_groups AS b ON b.id = a.extraFieldsGroup";

	    $categories = $db->queryObjectList($query, 'id');



		// sanatize category aliases

		$aliases = array();

		foreach ($categories as $category) {



			$i = 2;

			$alias = $this->app->string->sluggify($category->alias);

			while (in_array($alias, $aliases)) {

				$alias = $category->alias . '-' . $i++;

			}

			$category->alias = $alias;



			// remember used aliases to ensure unique aliases

			$aliases[] = $category->alias;

		}



		// export categories

		foreach ($categories as $category) {



			// assign attributes

			$data = array();

			foreach ($this->category_attributes as $attribute) {

				if (isset($category->$attribute)) {

					$data[$attribute] = $category->$attribute;

				}

			}



			// sanatize parent

			if ($category->parent && isset($categories[$category->parent])) {

				$data['parent'] = $categories[$category->parent]->alias;

			}



			// add category

			if ($category->image) {

				$data['content']['image'] = '/media/k2/categories/'.$category->image;

			}

			$this->_addCategory($category->name, $category->alias, $data);

		}



		// get k2 items

	    $query = "SELECT * FROM #__k2_items";

	    $items = $db->queryObjectList($query, 'id');



	    // get k2 extra fields

	    $query 		  = "SELECT * FROM #__k2_extra_fields";

	    $extra_fields = $db->queryObjectList($query, 'id');



	    // get k2 tags

	    $query = "SELECT a.itemID, b.name"

	    		." FROM #__k2_tags_xref as a"

	    		." JOIN #__k2_tags AS b ON a.tagID = b.id";

	    $tag_result = $db->queryObjectList($query);

	    $tags = array();

	    foreach ($tag_result as $tag) {

	    	$tags[$tag->itemID][] = $tag->name;

	    }



		// sanatize item aliases

		$aliases = array();

		foreach ($items as $item) {

			$i = 2;

			$alias = $this->app->string->sluggify($item->alias);

			while (in_array($alias, $aliases)) {

				$alias = $item->alias . '-' . $i++;

			}

			$item->alias = $alias;



			// remember used aliases to ensure unique aliases

			$aliases[] = $item->alias;



		}



		// export items

		foreach ($items as $item) {

            if (!$item->trash) {

                if (!$type = $categories[$item->catid]->extra_field_group_name) {

                    $type = JText::_('K2-Unassigned');

                }



                $this->_addItem($item, $extra_fields, $categories, $tags, $type);

            }

		}



		return parent::export();



	}



	/**

	 * Add an item to the list of items to export

	 * 

	 * @param object $item The item to export

	 * @param array $extra_fields The extra fields for this item

	 * @param array $categories The categories for this item

	 * @param array $tags The item tags

	 * @param string $group The item group

	 * 

	 * @return AppExporterK2 $this for chaining support

	 */

	protected function _addItem($item, $extra_fields, $categories = array(), $tags = array(), $group = 'default') {



		$data = array();

		foreach ($this->item_attributes as $attribute) {

			if (isset($item->$attribute)) {

				$data[$attribute] = $item->$attribute;

			}

		}

		// add author

		$data['author'] = $this->app->user->get($item->created_by)->username;



		// add state

		$data['state'] = $item->published;



		// add category

		$data['categories'][] = $categories[$item->catid]->alias;



		// add tags

		$data['tags'] = isset($tags[$item->id]) ? $tags[$item->id] : array();



		// add item content

		$i = 0;

		$data['elements'][$i]['type'] = 'textarea';

		$data['elements'][$i]['name'] = 'content';

		$data['elements'][$i++]['data'] = array(array('value' => $item->introtext), array('value' => $item->fulltext));



		$data['elements'][$i]['type'] = 'image';

		$data['elements'][$i]['name'] = 'image';

		$data['elements'][$i++]['data'] = array('file' => 'media/k2/items/src/'.md5("Image".$item->id).'.jpg');



		// add extra fields

        if (isset($item->extra_fields)) {

            foreach (json_decode($item->extra_fields) as $element) {



                $extrafield = $extra_fields[$element->id];



                switch ($extrafield->type) {

                    case 'textfield':

						$data['elements'][$i]['type'] = 'text';

						$data['elements'][$i]['name'] = $extrafield->name;

						$data['elements'][$i++]['data'] = array(array('value' => $element->value));

                        break;

                    case 'textarea':

						$data['elements'][$i]['type'] = 'textarea';

						$data['elements'][$i]['name'] = $extrafield->name;

						$data['elements'][$i++]['data'] = array(array('value' => $element->value));

                        break;

                    case 'select':

                    case 'multipleSelect':

						$data['elements'][$i]['type'] = 'select';

						$data['elements'][$i]['name'] = $extrafield->name;

						$data['elements'][$i++]['data'] = array('option' => $element->value);

                        break;

                    case 'radio':

						$data['elements'][$i]['type'] = 'radio';

						$data['elements'][$i]['name'] = $extrafield->name;

						$data['elements'][$i++]['data'] = array('option' => $element->value);

                        break;

                    case 'link':

						$data['elements'][$i]['type'] = 'link';

						$data['elements'][$i]['name'] = $extrafield->name;

						$data['elements'][$i++]['data'] = array(array('text' => $element->value[0], 'value' => $element->value[1]));

                        break;

                }

            }

        }



		parent::_addItem($item->title, $item->alias, $group, $data);

	}



}