<?php

use Joomla\Registry\Registry;
use Joomla\Utilities\ArrayHelper;
use Joomla\Utilities\IpHelper;

/**
 * @package DJ-Catalog2
 * @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email contact@dj-extensions.com
 *
 */

defined('_JEXEC') or die('Restricted access');

jimport('joomla.application.component.modelform');

require_once(JPATH_ROOT . '/components/com_djcatalog2/helpers/theme.php');
require_once(JPATH_ROOT . '/components/com_djcatalog2/helpers/price.php');

class DJCatalog2ModelItem extends JModelForm
{

    protected $view_item = 'item';
    protected $_item = null;
    protected $_context = 'com_djcatalog2.item';
    protected $_related = array();
    protected $_attributes = array();
    protected $_cart_attributes = array();
    protected $_children = array();
    protected $_combinations = array();
    protected $_customisations = array();
    protected $_price_tiers = array();

    public $childrenModel = null;

    protected function populateState()
    {
        $app = JFactory::getApplication('site');

        // Load state from the request.
        $pk = $app->input->getInt('id');
        $this->setState('item.id', $pk);

        $user = Djcatalog2Helper::getUserProfile($app->getUserState('com_djcatalog2.checkout.user_id', null));
        if (isset($user->customer_group_id)) {
            $this->setState('filter.customergroup', $user->customer_group_id);
        }

        // Load the parameters.
        $params = $app->getParams();
        $this->setState('params', $params);

    }

    public function getForm($data = array(), $loadData = true)
    {
        // Get the form.
        $form = $this->loadForm('com_djcatalog2.contact', 'contact', array('control' => 'jform', 'load_data' => true));
        if (empty($form)) {
            return false;
        }

        $params = JComponentHelper::getParams('com_djcatalog2');

        $user = JFactory::getUser();
        if ($user->id > 0) {
            if ($form->getValue('contact_email') == '') {
                $form->setFieldAttribute('contact_email', 'default', $user->email);
            }
            if ($form->getValue('contact_name') == '') {
                $form->setFieldAttribute('contact_name', 'default', $user->name);
            }
        }

        $subject = @$this->getItem()->name;
        if ($subject && $form->getValue('contact_subject') == '') {
            $form->setFieldAttribute('contact_subject', 'default', $subject);
        }

        return $form;
    }

    protected function preprocessForm(Joomla\CMS\Form\Form $form, $data, $group = 'content')
    {
        $app = JFactory::getApplication();
        $params = JComponentHelper::getParams('com_djcatalog2');
        $db = JFactory::getDbo();

        $user = JFactory::getUser();
        $language = JFactory::getLanguage();

        $switchable_fields = array('contact_phone', 'contact_street', 'contact_city', 'contact_zip', 'contact_country', 'contact_state', 'contact_company_name', 'contact_gdpr_policy', 'contact_gdpr_agreement', 'contact_email_copy');
        foreach ($switchable_fields as $field_name) {
            if ($field_name == 'contact_gdpr_policy') {
                $policy_info = JText::sprintf('COM_DJCATALOG2_GDPR_POLICY_AGREE', $app->get('sitename'));
                if (trim((string)$params->get('contact_gdpr_policy_info_field')) != '') {
                    $policy_info = $params->get('contact_gdpr_policy_info_field');
                    if ($language->hasKey($policy_info)) {
                        $policy_info = JText::_($policy_info);
                    }
                }
                $form->setFieldAttribute($field_name, 'label', $policy_info);
            } else if ($field_name == 'contact_gdpr_agreement') {
                $agreement_info = JText::sprintf('COM_DJCATALOG2_GDPR_AGREE', $app->get('sitename'));
                if (trim((string)$params->get('contact_gdpr_agreement_info_field')) != '') {
                    $agreement_info = $params->get('contact_gdpr_agreement_info_field');
                    if ($language->hasKey($agreement_info)) {
                        $agreement_info = JText::_($agreement_info);
                    }
                }
                $form->setFieldAttribute($field_name, 'label', $agreement_info);
            }
            if ($params->get($field_name . '_field', '0') == '0') {
                $form->removeField($field_name);
            } else if ($params->get($field_name . '_field', '0') == '2') {
                $form->setFieldAttribute($field_name, 'required', 'true');
                $form->setFieldAttribute($field_name, 'class', $form->getFieldAttribute($field_name, 'class') . ' required');
            }
        }

        if ($params->get('contact_country_field') == '0' && (int)$params->get('contact_state_field') > 0) {
            $query = $db->getQuery(true);
            $query->select('id')->from('#__djc2_countries')->where('is_default=1');
            $db->setQuery($query);
            $default_country = $db->loadResult();
            if ($default_country > 0) {
                $form->setFieldAttribute('contact_state', 'country', $default_country);
            }
        }

        $plugin = JFactory::getApplication()->getParams()->get('contact_captcha', JFactory::getConfig()->get('captcha'));
        if ($user->id > 0 || ($plugin === 0 || $plugin === '0' || $plugin === '' || $plugin === null)) {
            $form->removeField('captcha');
        } else {
            JFactory::getApplication()->getParams()->set('captcha', $plugin);
        }
    }

    protected function loadFormData()
    {
        $data = (array)JFactory::getApplication()->getUserState('com_djcatalog2.contact.data', array());
        return $data;
    }

    public function &getItem($pk = null)
    {
        // Initialise variables.
        $pk = (!empty($pk)) ? $pk : (int)$this->getState('item.id');

        $price_group_filter = $this->getState('filter.customergroup', false);

        if ($this->_item === null) {
            $this->_item = array();
        }

        $bound = true;
        if (!isset($this->_item[$pk])) {
            try {
                $db = JFactory::getDbo();
                $query = $db->getQuery(true);

                //$attributes = $this -> getAttributes();

                $query->select('i.*, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price');
                $query->from('#__djc2_items as i');

                $query->select('c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias');
                $query->join('left', '#__djc2_categories AS c ON c.id = i.cat_id');

                $query->select('p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias');
                $query->join('left', '#__djc2_producers AS p ON p.id = i.producer_id');

                $query->select('ua.name AS author, ua.email AS author_email');
                $query->join('left', '#__users AS ua ON ua.id = i.created_by');

                $query->select('gc.price as group_price, gc.available as group_available');
                $query->join('left', '#__djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=' . (int)$price_group_filter);

                $query->select('countries.country_name, countries.id as item_country_id');
                $query->join('left', '#__djc2_countries AS countries ON countries.id = i.country');

                $query->select('states.name as state_name');
                $query->join('left', '#__djc2_countries_states AS states ON states.id = i.state');

                $query->select('ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count');
                $query->join('LEFT', '#__djc2_item_rating AS v ON i.id = v.item_id');

                $nullDate = $db->quote($db->getNullDate());
                $date = JFactory::getDate();
                $nowDate = $db->quote($date->toSql());

                $query->where('i.id =' . (int)$pk);
                $query->where('(i.publish_up IS NULL OR i.publish_up = ' . $nullDate . ' OR i.publish_up <= ' . $nowDate . ')');
                $query->where('(i.publish_down IS NULL OR i.publish_down = ' . $nullDate . ' OR i.publish_down >= ' . $nowDate . ')');


                $query->group('i.id');
                //echo str_replace('#_','jos',$query).'<br/>';die();
                $db->setQuery($query);
                $item = $db->loadObject();

                if (empty($item)) {
                    return false;
                }

                $item->slug = (empty($item->alias)) ? $item->id : $item->id . ':' . $item->alias;
                $item->catslug = (empty($item->category_alias)) ? $item->cat_id : $item->cat_id . ':' . $item->category_alias;
                $item->prodslug = (empty($item->producer_alias)) ? $item->producer_id : $item->producer_id . ':' . $item->producer_alias;

                if ($item->group_price > 0) {
                    if ($item->special_price > 0 && $item->special_price < $item->group_price) {
                        $item->price = $item->group_price;
                        $item->final_price = $item->special_price;
                    } else {
                        $item->price = $item->final_price = $item->group_price;
                    }
                }

                $item->available_default = $item->available;
                if ($item->group_available != -1 && !is_null($item->group_available)) {
                    $item->available = $item->group_available;
                }

                $categories = Djc2Categories::getInstance();

                $mainCategory = $categories->get($item->cat_id);
                $params = new Registry($item->params);
                if (!empty($mainCategory)) {
                    $categoryParams = $mainCategory->getParams();
                    $categoryParams->merge($params);
                    $params = clone $categoryParams;
                }
                $item->params = $params;
                if (trim((string)$item->config_conditions) == '' || $item->config_conditions == '{}') {
                    $item->config_conditions = false;
                } else {
                    try {
                        $cfgCond = json_decode((string)$item->config_conditions);
                    } catch (Exception $e) {
                        $item->config_conditions = false;
                    }

                    if ($cfgCond != false) {
                        $item->config_conditions = $this->parseConfigConditions($cfgCond);
                    } else {
                        $item->config_conditions = false;
                    }
                }

                if ($item->parent_id > 0) {
                    $item->parent = $this->getItem($item->parent_id);
                    if ($item->parent) {
                        $item->name = $item->parent->name . ' - ' . $item->name;
                    }
                }
                if (trim((string)$item->config_dimensions) == '' || $item->config_dimensions == '{}') {
                    $item->config_dimensions = false;
                } else {
                    $item->config_dimensions = json_decode((string)$item->config_dimensions, true);
                }

                if (trim((string)$item->config_dimensions_settings) == '' || $item->config_dimensions_settings == '{}') {
                    $item->config_dimensions_settings = [
                        'min_width' => '',
                        'min_height' => '',
                        'min_length' => '',
                        'max_width' => '',
                        'max_height' => '',
                        'max_length' => '',
                    ];
                } else {
                    $item->config_dimensions_settings = json_decode((string)$item->config_dimensions_settings, true);
                }
                $user_currency_id = JFactory::getApplication()->getUserState('com_djcatalog2.checkout.currency');

                if ($user_currency_id > 0) {
                    $item->avg_price = Djcatalog2HelperPrice::currencyExchange($item->avg_price);
                }


                $this->_item[$pk] = $item;
                $bound = false;
            } catch (JException $e) {
                $this->setError($e);
                $this->_item[$pk] = false;
            }

        }
        if ($this->_item[$pk] && !$bound) {
            $this->bindAttributes($pk);
        }

        if (!$this->_item[$pk]->sections_source) {
            $this->_item[$pk]->sections = $this->getSectionByCategory($this->_item[$pk]->cat_id);
        }

        if (!isset($this->_item[$pk]->calculator) && $this->_item[$pk]->calculator_id) {

            $this->_item[$pk]->calculator = CalculatorHelper::getInstance($this->_item[$pk]->calculator_id);

        }

        return $this->_item[$pk];

    }

    private function getSectionByCategory($cat_id)
    {
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);

        $query->select('sections');
        $query->from($db->quoteName('#__djc2_categories'));
        $query->where($db->quoteName('id') . ' = ' . (int)$cat_id);

        $db->setQuery($query);

        return $db->loadResult();
    }

    function getRelatedItems($pk = null)
    {
        $pk = (!empty($pk)) ? $pk : (int)$this->getState('item.id');

        if (empty($this->_related[$pk])) {
            $params = $this->getState('params', Djcatalog2Helper::getParams());

            $filter_order = $params->get('related_items_default_order', 'i.ordering');
            $filter_order_Dir = $params->get('related_items_default_order_dir', 'asc');
            $filter_featured = $params->get('related_featured_first', 0);

            if ($params->get('related_items_count', 2) == 0) {
                $this->_related[$pk] = array();
                return $this->_related[$pk];
            }

            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->select('related_item');
            $query->from('#__djc2_items_related');
            $query->where('item_id=' . (int)$pk);
            $db->setQuery($query);

            $ids = $db->loadColumn();

            if (empty($ids)) {
                $this->_related[$pk] = array();
                return $this->_related[$pk];
            }

            $model = JModelLegacy::getInstance('Items', 'Djcatalog2Model', array('ignore_request' => true));
            $state = $model->getState();

            $model->setState('params', $params);

            $model->setState('list.start', 0);
            $model->setState('list.limit', $params->get('related_items_count', 2));

            $model->setState('filter.catalogue', false);
            $model->setState('list.ordering_featured', $filter_featured);
            $model->setState('list.ordering', $filter_order);
            $model->setState('list.direction', $filter_order_Dir);
            $model->setState('filter.item_ids', $ids);
            $model->setState('list.fields_visibility', '*');

            $items = $model->getItems();
            $this->_related[$pk] = array_values($items);
        }
        return $this->_related[$pk];
    }

    /*function getAttributes() {
     if (empty($this->_attributes)) {
     $db = JFactory::getDbo();
     $query = $db->getQuery(true);
     $query->select('f.*, group_concat(fo.id separator \'|\') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id');
     $query->from('#__djc2_items_extra_fields as f');
     $query->join('LEFT', '#__djc2_items_extra_fields_options as fo ON fo.field_id=f.id');
     $query->join('LEFT', '#__djc2_items_extra_fields_groups as g ON g.id=f.group_id');

     $query->where('(f.visibility = 1 or f.visibility = 3) and f.published = 1');
     $query->where('(f.cart_variant = 0 OR f.cart_variant = 2)');
     $query->group('f.id');
     $query->order('IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc');
     $db->setQuery($query);

     $this->_attributes = $db->loadObjectList();
     }

     return $this->_attributes;
     }*/

    function getAttributes()
    {
        if (empty($this->_attributes)) {
            $db = JFactory::getDbo();

            $query = $db->getQuery(true);
            //$query->select('f.*, group_concat(fo.id separator \'|\') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id');
            $query->select('f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id');
            $query->from('#__djc2_items_extra_fields as f');
            //$query->join('LEFT', '#__djc2_items_extra_fields_options as fo ON fo.field_id=f.id');
            $query->join('LEFT', '#__djc2_items_extra_fields_groups as g ON g.id=f.group_id');

            $query->where('(f.visibility = 1 or f.visibility = 3) and f.published = 1');
            $query->where('(f.cart_variant = 0 OR f.cart_variant = 2)');

            $query->order('IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc');
            $db->setQuery($query);

            $this->_attributes = $db->loadObjectList('id');

            if (count($this->_attributes)) {
                $query = $db->getQuery(true);
                $query->select('*');
                $query->from('#__djc2_items_extra_fields_options');
                $query->where('field_id in (' . implode(',', array_keys($this->_attributes)) . ')');
                $query->order('field_id asc, ordering asc');

                $db->setQuery($query);
                $optionslist = $db->loadObjectList();

                foreach ($this->_attributes as $field_id => $field) {
                    $field_options = array();
                    $field_optionValues = array();
                    $field_optionParams = array();

                    foreach ($optionslist as $k => $option) {
                        if ($option->field_id == $field_id) {
                            $field_options[] = $option->id;
                            $field_optionValues[$option->id] = $option->value;
                            $field_optionParams[$option->id] = new Registry($option->params);

                        }
                    }

                    $this->_attributes[$field_id]->options = $field_options;//implode('|', $field_options);
                    $this->_attributes[$field_id]->optionValues = $field_optionValues;//implode('|', $field_optionValues);
                    $this->_attributes[$field_id]->optionParams = $field_optionParams;
                }
            }
        }

        return $this->_attributes;
    }

    function getAttributeById($fid)
    {
        $attrs = $this->getAttributes();
        if (isset($attrs[$fid])) {
            return $attrs[$fid];
        }
        return false;
    }

    function getCartAttributes()
    {
        if (empty($this->_cart_attributes)) {
            $db = JFactory::getDbo();

            $query = $db->getQuery(true);
            //$query->select('f.*, group_concat(fo.id separator \'|\') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id');
            $query->select('f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id');
            $query->from('#__djc2_items_extra_fields as f');
            //$query->join('LEFT', '#__djc2_items_extra_fields_options as fo ON fo.field_id=f.id');
            $query->join('LEFT', '#__djc2_items_extra_fields_groups as g ON g.id=f.group_id');
            $query->where('(f.cart_variant=1 OR f.cart_variant=2) and f.published = 1');
            $query->order('IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc');
            $db->setQuery($query);

            $this->_cart_attributes = $db->loadObjectList('id');

            if (count($this->_cart_attributes)) {
                $query = $db->getQuery(true);
                $query->select('*');
                $query->from('#__djc2_items_extra_fields_options');
                $query->where('field_id in (' . implode(',', array_keys($this->_cart_attributes)) . ')');
                $query->order('field_id asc, ordering asc');

                $db->setQuery($query);
                $optionslist = $db->loadObjectList();

                foreach ($this->_cart_attributes as $field_id => $field) {
                    $field_options = array();
                    $field_optionValues = array();
                    $field_optionParams = array();

                    foreach ($optionslist as $k => $option) {
                        if ($option->field_id == $field_id) {
                            $field_options[] = $option->id;
                            $field_optionValues[$option->id] = $option->value;
                            $field_optionParams[$option->id] = new Registry($option->params);

                        }
                    }

                    $this->_cart_attributes[$field_id]->options = $field_options;//implode('|', $field_options);
                    $this->_cart_attributes[$field_id]->optionValues = $field_optionValues;//implode('|', $field_optionValues);
                    $this->_cart_attributes[$field_id]->optionParams = $field_optionParams;
                }
            }
        }

        return $this->_cart_attributes;
    }

    function getCartVariants()
    {
        $item = $this->getItem();
        $combinations = $this->getCombinations($item->id);
        $cart_attributes = $this->getCartAttributes();

        foreach ($cart_attributes as $key => &$cartField) {
            $cartField->_variantData = null;

            $variantData = new stdClass();

            $variantData->options = $cartField->options;
            $variantData->optionValues = $cartField->optionValues;
            $variantData->optionParams = $cartField->optionParams;

            $variantData->availableOptions = array();
            $variantData->optionCombinations = array();

            $cartField->_combinations = array();

            if ($cartField->cart_variant == 2) {
                $itemKey = '_ef_' . $cartField->alias;
                if (isset($item->$itemKey) && !empty($item->$itemKey) && is_array($item->$itemKey)) {
                    $variantData->availableOptions = array_keys($item->$itemKey);
                }
            }

            $cartField->_variantData = $variantData;

        }
        unset($cartField);

        foreach ($combinations as $combination_id => &$combination) {
            if (!isset($combination->fields)) continue;
            foreach ($combination->fields as $field_id => $field) {
                if (!isset($cart_attributes[$field_id])) {
                    continue;
                }

                $cart_attributes[$field_id]->_combinations[] = &$combination;

                if (!in_array($field->value, $cart_attributes[$field_id]->_variantData->availableOptions)) {
                    $cart_attributes[$field_id]->_variantData->availableOptions[] = $field->value;
                }

                if (!isset($cart_attributes[$field_id]->_variantData->optionCombinations[$field->value])) {
                    $cart_attributes[$field_id]->_variantData->optionCombinations[$field->value] = array();
                }
                $cart_attributes[$field_id]->_variantData->optionCombinations[$field->value][] = $combination->id;
            }
        }
        unset($combination);

        foreach ($cart_attributes as $k => $v) {
            if (count($v->_variantData->availableOptions) < 1) {
                unset($cart_attributes[$k]);
            }
        }

        //echo '<pre>'.print_r($cart_attributes,true).'</pre>';
        /*echo '<br />-------<br />';
         echo '<pre>'.print_r($item,true).'</pre>';
         echo '<pre>'.print_r($children,true).'</pre>';
         echo '<br />-------<br />';
         die();
         */

        return $cart_attributes;
    }

    function bindAttributes($id)
    {
        if (!empty($this->_item[$id])) {
            $db = JFactory::getDbo();

            $query = $db->getQuery(true);
            $query->select('category_id')->from('#__djc2_items_categories')->where('item_id=' . (int)$id);
            $db->setQuery($query);
            $this->_item[$id]->_categories_ids = $db->loadColumn();

            $query = $db->getQuery(true);
            $query->select('*')->from('#__djc2_item_reviews')->where('item_id=' . (int)$id);

            // TODO there should be pagination here or controllable limit
            $db->setQuery($query, 0, 100);
            $this->_item[$id]->_reviews = $db->loadObjectList();

            $query_cf = $db->getQuery(true);
            $query_int = $db->getQuery(true);
            $query_text = $db->getQuery(true);
            $query_date = $db->getQuery(true);

            $query_cf->select('fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params');
            $query_cf->from('#__djc2_items_extra_fields_values_int as fieldvalues');
            $query_cf->join('inner', '#__djc2_items as items on items.id=fieldvalues.item_id');
            $query_cf->join('inner', '#__djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id');
            $query_cf->join('left', '#__djc2_items_extra_fields_options as fieldoptions ON fieldoptions.id = fieldvalues.value AND fieldoptions.field_id = fields.id');
            $query_cf->where('fieldvalues.item_id=' . $id . ' AND fields.cart_variant=2 AND fields.published = 1');
            $query_cf->order('fields.ordering asc, fieldoptions.ordering asc');

            $query_int->select('fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params');
            $query_int->from('#__djc2_items_extra_fields_values_int as fieldvalues');
            $query_int->join('inner', '#__djc2_items as items on items.id=fieldvalues.item_id');
            $query_int->join('inner', '#__djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id');
            $query_int->join('left', '#__djc2_items_extra_fields_options as fieldoptions ON fieldoptions.id = fieldvalues.value AND fieldoptions.field_id = fields.id');
            $query_int->where('fieldvalues.item_id=' . $id . ' AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1');
            $query_int->order('fields.ordering asc, fieldoptions.ordering asc');

            $query_text->select('fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value');
            $query_text->from('#__djc2_items_extra_fields_values_text as fieldvalues');
            $query_text->join('inner', '#__djc2_items as items on items.id=fieldvalues.item_id');
            $query_text->join('inner', '#__djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id');
            $query_text->where('fieldvalues.item_id=' . $id . ' AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1');

            $query_date->select('fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value');
            $query_date->from('#__djc2_items_extra_fields_values_date as fieldvalues');
            $query_date->join('inner', '#__djc2_items as items on items.id=fieldvalues.item_id');
            $query_date->join('inner', '#__djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id');
            $query_date->where('fieldvalues.item_id=' . $id . ' AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1');
            $query_date->order('fields.ordering asc');

            $query_labels = $db->getQuery(true);
            $query_labels->select('l.*, li.item_id')->from('#__djc2_labels as l')->join('inner', '#__djc2_labels_items AS li ON li.label_id=l.id');
            $query_labels->where('li.item_id=' . $id);
            $query_labels->order('l.ordering');

            $query_combos = $db->getQuery(true);
            $query_combos->select('COUNT(*)');
            $query_combos->from('#__djc2_items_combinations');
            $query_combos->where('item_id =' . $id);

            $db->setQuery($query_cf);
            $cf_attributes = $db->loadObjectList();
            $db->setQuery($query_int);
            $int_attributes = $db->loadObjectList();
            $db->setQuery($query_text);
            $text_attributes = $db->loadObjectList();
            $db->setQuery($query_date);
            $date_attributes = $db->loadObjectList();

            $db->setQuery($query_labels);
            $labels = $db->loadObjectList();

            $this->_item[$id]->_available_in_groups = null;

            //if (!$this->_item[$id]->available) {
            $query_avail_groups = $db->getQuery(true);
            $query_avail_groups->select('cg.*, p.price, p.available');
            $query_avail_groups->from('#__djc2_customer_groups AS cg');
            $query_avail_groups->join('inner', '#__djc2_prices AS p ON p.group_id=cg.id');
            $query_avail_groups->where('p.item_id = ' . $id);
            $query_avail_groups->where('(p.available = 1 OR p.price > 0.0)');
            $query_avail_groups->order('cg.ordering');
            $db->setQuery($query_avail_groups);

            $avail_groups = $db->loadObjectList();
            if (!empty($avail_groups)) {
                $this->_item[$id]->_available_in_groups = $avail_groups;
            }
            //}

            $db->setQuery($query_combos);
            $this->_item[$id]->combo_count = $db->loadResult();

            foreach ($labels as $label) {
                if (!isset($this->_item[$label->item_id]->_labels)) {
                    $this->_item[$label->item_id]->_labels = array();
                }
                $params = new Registry();
                $params->loadString($label->params);
                $label->params = $params;
                $this->_item[$label->item_id]->_labels[] = $label;
            }

            $this->_item[$id]->_extra_fields = array();

            foreach ($text_attributes as $attribute) {
                if ($attribute->item_id == $id) {
                    $field = '_ef_' . $attribute->alias;
                    $this->_item[$id]->$field = $attribute->value;

                    $this->_item[$id]->_extra_fields[$attribute->field_id] = $attribute;
                }
            }
            foreach ($date_attributes as $attribute) {
                if ($attribute->item_id == $id) {
                    $field = '_ef_' . $attribute->alias;
                    $this->_item[$id]->$field = $attribute->value;

                    $this->_item[$id]->_extra_fields[$attribute->field_id] = $attribute;
                }
            }
            foreach ($int_attributes as $attribute) {
                if ($attribute->item_id == $id) {
                    $field = '_ef_' . $attribute->alias;
                    $param_field = '_efp_' . $attribute->alias;

                    if (!isset($this->_item[$id]->$field) || !is_array($this->_item[$id]->$field)) {
                        $this->_item[$id]->$field = array();
                        $this->_item[$id]->_extra_fields[$attribute->field_id] = array();
                    }
                    if (!in_array($attribute->value, $this->_item[$id]->$field)) {
                        $tmp_arr = $this->_item[$id]->$field;
                        $tmp_arr[$attribute->option_id] = $attribute->value;
                        $this->_item[$id]->$field = $tmp_arr;
                    }

                    if (!isset($this->_item[$id]->$param_field) || !is_array($this->_item[$id]->$param_field)) {
                        $this->_item[$id]->$param_field = array();
                    }

                    $tmp_arr = $this->_item[$id]->$param_field;
                    $tmp_arr[$attribute->option_id] = new Registry($attribute->option_params);

                    $this->_item[$id]->$param_field = $tmp_arr;

                    $this->_item[$id]->_extra_fields[$attribute->field_id][] = $attribute;
                }
            }

            $this->_item[$id]->_cart_features = array();

            foreach ($cf_attributes as $attribute) {
                if ($attribute->item_id == $id) {
                    $field = '_cf_' . $attribute->alias;
                    $param_field = '_cfp_' . $attribute->alias;

                    if (!isset($this->_item[$id]->$field) || !is_array($this->_item[$id]->$field)) {
                        $this->_item[$id]->$field = array();
                    }
                    if (!in_array($attribute->value, $this->_item[$id]->$field)) {
                        $tmp_arr = $this->_item[$id]->$field;
                        $tmp_arr[$attribute->option_id] = $attribute->value;
                        $this->_item[$id]->$field = $tmp_arr;

                        $this->_item[$id]->_cart_features[] = $attribute->option_id;
                    }

                    if (!isset($this->_item[$id]->$param_field) || !is_array($this->_item[$id]->$param_field)) {
                        $this->_item[$id]->$param_field = array();
                    }

                    $tmp_arr = $this->_item[$id]->$param_field;
                    $tmp_arr[$attribute->option_id] = new Registry($attribute->option_params);

                    $this->_item[$id]->$param_field = $tmp_arr;
                }
            }
            $this->_item[$id]->final_price = Djcatalog2HelperPrice::applyPriceRules($this->_item[$id]->final_price, true, 'each_item', $this->_item[$id], 'item');
            $this->_item[$id]->price = Djcatalog2HelperPrice::applyPriceRules($this->_item[$id]->price, false, 'each_item', $this->_item[$id], 'item');

            $this->_item[$id]->_price_tiers = $this->getTierPrices($id);
        }
    }

    public function getNavigation($id, $catid = null, $params = null)
    {
        $db = JFactory::getDbo();
        $category_limit = ($catid) ? ' AND i.cat_id=' . $catid : '';

        $orderby = 'c.ordering ASC, i.ordering ASC';

        if (!empty($params)) {
            $filter_order = $params->get('items_default_order', 'i.ordering');
            $filter_order_Dir = $params->get('items_default_order_dir', 'asc');
            $filter_featured = $params->get('featured_first', 0);

            $sortables = array('i.ordering', 'i.name', 'i.created', 'i.price', 'category', 'c.name', 'producer', 'p.name', 'i.id', 'rand()');

            if (!in_array($filter_order, $sortables)) {
                $filter_order = 'i.ordering';
            }

            if ($filter_order_Dir != 'asc' && $filter_order_Dir != 'desc') {
                $filter_order_Dir = 'asc';
            }

            if ($filter_order == 'i.ordering') {
                if ($filter_featured) {
                    //$orderby  = ' i.featured DESC, i.ordering '.$filter_order_Dir.', c.ordering '.$filter_order_Dir;
                    //$orderby = 'i.featured DESC, c.parent_id asc, c.ordering asc, i.ordering '.$filter_order_Dir;
                    if ($params->get('items_category_ordering', '1') != '1') {
                        $orderby = ' i.featured DESC, i.ordering ' . $filter_order_Dir . ', c.ordering ' . $filter_order_Dir;
                    } else {
                        $orderby = 'i.featured DESC, c.parent_id asc, c.ordering asc, i.ordering ' . $filter_order_Dir;
                    }
                } else {
                    //$orderby  = ' i.ordering '.$filter_order_Dir.', c.ordering '.$filter_order_Dir;
                    //$orderby = 'c.parent_id asc, c.ordering asc, i.ordering '.$filter_order_Dir;
                    if ($params->get('items_category_ordering', '1') != '1') {
                        $orderby = ' i.ordering ' . $filter_order_Dir . ', c.ordering ' . $filter_order_Dir;
                    } else {
                        $orderby = 'c.parent_id asc, c.ordering asc, i.ordering ' . $filter_order_Dir;
                    }
                }
            } else {
                // older version compatibility
                switch ($filter_order) {
                    case 'producer':
                    {
                        $filter_order = 'p.name';
                        break;
                    }
                    case 'category':
                    {
                        $filter_order = 'c.name';
                        break;
                    }
                    case 'i.price' :
                    {
                        $filter_order = 'final_price';
                        break;
                    }
                }
                if ($filter_featured) {
                    $orderby = ' i.featured DESC, ' . $filter_order . ' ' . $filter_order_Dir . ' , i.ordering, c.ordering ';
                } else {
                    $orderby = ' ' . $filter_order . ' ' . $filter_order_Dir . ' , i.ordering, c.ordering ';
                }
            }
        }

        $app = JFactory::getApplication();
        $nullDate = $db->quote($db->getNullDate());
        $date = JFactory::getDate();
        $nowDate = $db->quote($date->toSql());

        $ignore_cache = $app->input->get('ic');
        $category = $app->getUserState('com_djcatalog.items.filter.category');
        $producer = $app->getUserState('com_djcatalog.items.filter.producer');

        $user = JFactory::getUser();
        $userGroups = implode(',', $user->getAuthorisedViewLevels());


        //TODO
        /*
         $query = 'SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, @num := @num + 1 AS position, '
         .' CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price '
         .' FROM (SELECT @num := 0) AS n, #__djc2_items AS i '
         .' LEFT JOIN #__djc2_categories as c ON c.id = i.cat_id '
         .' LEFT JOIN #__djc2_producers as p ON p.id = i.producer_id '
         .' WHERE i.published = 1 AND (i.publish_up = ' . $nullDate . ' OR i.publish_up <= ' . $nowDate . ') AND (i.publish_down = ' . $nullDate . ' OR i.publish_down >= ' . $nowDate . ') AND c.published = 1 '.$category_limit
         .' ORDER BY '. $orderby;
         */
        $query = 'SELECT k.*, @num := @num + 1 AS position' .
            ' FROM (SELECT @num := 0) AS n,' .
            ' (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias,' .
            ' CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price' .
            ' FROM #__djc2_items AS i ' .
            ' LEFT JOIN #__djc2_categories as c ON c.id = i.cat_id ' .
            ' LEFT JOIN #__djc2_producers as p ON p.id = i.producer_id ' .
            ' WHERE i.parent_id = 0 AND i.published = 1 AND i.access IN (' . $userGroups . ') AND (i.publish_up IS NULL OR i.publish_up = ' . $nullDate . ' OR i.publish_up <= ' . $nowDate . ') AND (i.publish_down IS NULL OR i.publish_down = ' . $nullDate . ' OR i.publish_down >= ' . $nowDate . ') AND c.published = 1 ' . $category_limit;

        if ($ignore_cache) {
            if (intval($category))
                $query .= ' AND i.cat_id = ' . (int)$category;

            if (intval($producer))
                $query .= ' AND i.producer_id = ' . (int)$producer;
        }

        $query .= ' ORDER BY ' . $orderby . ') as k';


        $navigation = array('prev' => null, 'next' => null);

        $db->setQuery('SELECT subq.position FROM (' . $query . ') as subq WHERE subq.id = ' . $id . ' ORDER BY subq.position DESC LIMIT 1');
        $position = $db->loadResult();

        if (!$position) {
            return false;
        }
        //$pos_query = 'SELECT subq.* FROM ('.$query.') as subq WHERE subq.position='.($position - 1).' OR subq.position='.($position + 1).' ORDER BY subq.position ASC';
        //$db->setQuery($pos_query);

        $prev_query = 'SELECT subq.* FROM (' . $query . ') as subq WHERE subq.position < ' . $position . ' ORDER BY subq.position DESC LIMIT 1';
        $next_query = 'SELECT subq.* FROM (' . $query . ') as subq WHERE subq.position > ' . $position . ' ORDER BY subq.position ASC LIMIT 1';

        $db->setQuery($prev_query);
        $prev = $db->loadObject();
        if (!empty($prev) && $prev->id > 0 && $prev->cat_id > 0) {
            $navigation['prev'] = $prev;
            $navigation['prev']->slug = $prev->id . ':' . $prev->alias;
            $navigation['prev']->catslug = $prev->cat_id . ':' . $prev->category_alias;
        }

        $db->setQuery($next_query);
        $next = $db->loadObject();
        if (!empty($next) && $next->id > 0 && $next->cat_id > 0) {
            $navigation['next'] = $next;
            $navigation['next']->slug = $next->id . ':' . $next->alias;
            $navigation['next']->catslug = $next->cat_id . ':' . $next->category_alias;
        }

        //$nav_rows = $db->loadObjectList();
        //echo str_replace('#__', 'j25_', $pos_query);

        /*if (count($nav_rows) > 0) {
         foreach($nav_rows as $row) {
         if ($row->position > $position) {
         $navigation['next'] = $row;
         $navigation['next']->slug = $row->id.':'.$row->alias;
         $navigation['next']->catslug = $row->cat_id.':'.$row->category_alias;
         } else if ($row->position < $position) {
         $navigation['prev'] = $row;
         $navigation['prev']->slug = $row->id.':'.$row->alias;
         $navigation['prev']->catslug = $row->cat_id.':'.$row->category_alias;
         }
         }
         }*/

        return $navigation;
    }

    public function &getChildrenModel()
    {
        if (!$this->childrenModel) {
            JModelLegacy::addIncludePath(JPATH_BASE . '/components/com_djcatalog2/models', 'DJCatalog2Model');
            $this->childrenModel = JModelLegacy::getInstance('Items', 'Djcatalog2Model', array('ignore_request' => true));
        }

        return $this->childrenModel;
    }

    public function getChildren($item_id)
    {
        if ((int)$item_id <= 0) {
            return false;
        }

        if (!isset($this->children[$item_id])) {
            $model = $this->getChildrenModel();

            $state = $model->getState();

            $model->setState('list.start', 0);
            $model->setState('list.limit', 0);
            $model->setState('filter.state', 1);
            $model->setState('filter.catalogue', false);
            $model->setState('filter.parent', $item_id);
            $model->setState('list.ordering', 'i.ordering');
            $model->setState('list.direction', 'asc');
            //$model->setState('list.fields_visibility', 'cart_variant');
            $model->setState('list.fields_visibility', '*');

            $this->children[$item_id] = $model->getItems();
        }

        return $this->children[$item_id];
    }

    public function getCombinations($item_id)
    {
        $db = JFactory::getDbo();
        $app = JFactory::getApplication();

        $product = $this->getItem($item_id);

        $price_group_filter = 0;
        $user = Djcatalog2Helper::getUserProfile($app->getUserState('com_djcatalog2.checkout.user_id', null));
        if (isset($user->customer_group_id)) {
            $price_group_filter = $user->customer_group_id;
        }
        $query = $db->getQuery(true);
        $query->select('c.*, gc.price as group_price');
        $query->from('#__djc2_items_combinations AS c');
        $query->join('left', '#__djc2_combination_prices AS gc ON gc.combination_id = c.id AND gc.group_id=' . (int)$price_group_filter);
        $query->where('item_id = ' . (int)$item_id);
        $db->setQuery($query);
        $combinations = $db->loadObjectList('id');

        if (count($combinations) > 0) {
            $query = $db->getQuery(true);
            $query->select('cf.*, f.name as field_name, fo.value as field_value, fo.params');
            $query->from('#__djc2_items_combinations_fields AS cf');
            $query->join('left', '#__djc2_items_extra_fields as f ON f.id = cf.field_id');
            $query->join('left', '#__djc2_items_extra_fields_options as fo ON fo.id = cf.value AND fo.field_id = cf.field_id AND fo.field_id = f.id');
            $query->where('cf.combination_id IN (' . implode(',', array_keys($combinations)) . ')');
            $query->order('f.ordering, fo.ordering ASC');
            $db->setQuery($query);

            $fields = $db->loadObjectList();

            foreach ($fields as $field) {

                $field->option_params = new Registry($field->params);

                if (!isset($combinations[$field->combination_id]->fields)) {
                    $combinations[$field->combination_id]->fields = array();
                }
                $combinations[$field->combination_id]->fields[$field->field_id] = $field;
            }

            foreach ($combinations as &$combination) {
                if (empty($combination->fields) || !is_array($combination->fields)) continue;

                $combination->images = DJCatalog2ImageHelper::getImages('combination', $combination->id);
                if ($combination->group_price > 0) {
                    $combination->price = $combination->group_price;
                }
                $tmpPrice = $combination->price;


                $cart_features = $combination_features = isset($product->_cart_features) ? $product->_cart_features : array();
                foreach ($combination->fields as $field) {
                    $combination_features[] = $field->value;
                }

                $product->_cart_features = $combination_features;

                //$combination->price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, false, 'each_item', $product, 'item');
                if ($tmpPrice > 0.0) {
                    if ($tmpPrice > $product->price) {
                        $combination->price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, false, 'each_item', $product, 'item');
                    } else {
                        $combination->price = Djcatalog2HelperPrice::applyPriceRules($product->price, false, 'each_item', $product, 'item');
                    }
                } else {
                    $combination->price = Djcatalog2HelperPrice::applyPriceRules($product->price, false, 'each_item', $product, 'item');
                }

                //$combination->final_price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, true, 'each_item', $product, 'item');
                if ($tmpPrice == 0.0) {
                    $combination->final_price = Djcatalog2HelperPrice::applyPriceRules($product->final_price, true, 'each_item', $product, 'item');
                } else {
                    $combination->final_price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, true, 'each_item', $product, 'item');
                }

                $product->_cart_features = $cart_features;
            }
        }

        return $combinations;
    }

    public function getCombination($combination_id)
    {
        if (!isset($this->_combinations[$combination_id])) {
            $db = JFactory::getDbo();
            $app = JFactory::getApplication();

            $price_group_filter = 0;
            $user = Djcatalog2Helper::getUserProfile($app->getUserState('com_djcatalog2.checkout.user_id', null));
            if (isset($user->customer_group_id)) {
                $price_group_filter = $user->customer_group_id;
            }

            $query = $db->getQuery(true);
            $query->select('c.*, gc.price as group_price');
            $query->from('#__djc2_items_combinations AS c');
            $query->join('left', '#__djc2_combination_prices AS gc ON gc.combination_id = c.id AND gc.group_id=' . (int)$price_group_filter);
            $query->where('c.id = ' . (int)$combination_id);
            $db->setQuery($query);
            $combination = $db->loadObject();

            if (!empty($combination)) {
                if ($combination->group_price > 0) {
                    $combination->price = $combination->group_price;
                }

                $query = $db->getQuery(true);
                $query->select('cf.*, f.name as field_name, fo.value as field_value');
                $query->from('#__djc2_items_combinations_fields AS cf');
                $query->join('left', '#__djc2_items_extra_fields as f ON f.id = cf.field_id');
                $query->join('left', '#__djc2_items_extra_fields_options as fo ON fo.id = cf.value AND fo.field_id = cf.field_id AND fo.field_id = f.id');
                $query->where('cf.combination_id = ' . $combination->id);
                $query->order('f.ordering ASC, fo.ordering ASC');
                $db->setQuery($query);

                $fields = $db->loadObjectList();

                $combination->fields = array();

                foreach ($fields as $field) {
                    $combination->fields[$field->field_id] = $field;
                }

                $product = $this->getItem($combination->item_id);

                $cart_features = $combination_features = isset($product->_cart_features) ? $product->_cart_features : array();
                foreach ($combination->fields as $field) {
                    $combination_features[] = $field->value;
                }
                $product->_cart_features = $combination_features;

                $tmpPrice = $combination->price;

                //$combination->price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, false, 'each_item', $product, 'item');
                if ($tmpPrice > 0.0) {
                    if ($tmpPrice > $product->price) {
                        $combination->price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, false, 'each_item', $product, 'item');
                    } else {
                        $combination->price = Djcatalog2HelperPrice::applyPriceRules($product->price, false, 'each_item', $product, 'item');
                    }
                } else {
                    $combination->price = Djcatalog2HelperPrice::applyPriceRules($product->price, false, 'each_item', $product, 'item');
                }

                //$combination->final_price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, true, 'each_item', $product, 'item');
                if ($tmpPrice == 0.0) {
                    $combination->final_price = Djcatalog2HelperPrice::applyPriceRules($product->final_price, true, 'each_item', $product, 'item');
                } else {
                    $combination->final_price = Djcatalog2HelperPrice::applyPriceRules($tmpPrice, true, 'each_item', $product, 'item');
                }

                $product->_cart_features = $cart_features;


            }

            $this->_combinations[$combination_id] = $combination;
        }

        return $this->_combinations[$combination_id];
    }

    public function getCustomisations($item_id = 0)
    {
        if (!isset($this->_customisations[(int)$item_id])) {
            $db = JFactory::getDbo();
            $query = $db->getQuery(true);

            if ((int)$item_id > 0) {
                //$query->select('ic.*, c.name, c.input_params, c.price as def_price, c.min_quantity as def_min_quantity, c.max_quantity as def_max_quantity, c.required as def_required');
                $query->select('ic.*, c.name, c.input_params, c.type, c.tax_rule_id, c.price_modifier');
                $query->from('#__djc2_items_customisations AS ic');
                $query->join('inner', '#__djc2_customisations AS c ON c.id=ic.customisation_id');
                $query->where('item_id = ' . (int)$item_id);
                $query->where('c.type=' . $db->quote('i'));
                $query->order('c.ordering');
            } else {
                $query->select('c.*, id as customisation_id, 0 as item_id');
                $query->from('#__djc2_customisations AS c');
                $query->where('(c.type=' . $db->quote('c') . ' OR c.type=' . $db->quote('a') . ')');
                $query->order('c.ordering');
            }

            $db->setQuery($query);

            $customisations = $db->loadObjectList();
            foreach ($customisations as $key => &$custom) {
                if (!empty($custom->input_params)) {
                    $input_params = json_decode(trim((string)$custom->input_params), true);
                    $custom->input_params = $input_params;
                } /*else {
				unset($customisations[$key]);
				continue;
				}*/
                else {
                    $custom->input_params = array();
                }

                $custom->_cid = ($custom->customisation_id . '-' . $custom->item_id);
            }
            unset($custom);

            $this->_customisations[(int)$item_id] = $customisations;
        }

        return $this->_customisations[(int)$item_id];
    }

    public function getCustomisationsForm($customisations, $item, $params, $data = array())
    {
        if (count($customisations) < 1) {
            return false;
        }

        $source = '<?xml version="1.0" encoding="UTF-8"?>' .
            '<form><fieldset addfieldpath="/administrator/components/com_djcatalog2/models/fields">';


        $source .= '<field name="customisation" type="checkboxes" label="COM_DJCATALOG2_CUSTOMISATION_OPT_LBL">';
        foreach ($customisations as $custom) {
            $optionName = $custom->name;

            if ($custom->price > 0.0) {
                $taxRuleId = (isset($item)) ? $item->tax_rule_id : $custom->tax_rule_id;
                $prices = Djcatalog2HelperPrice::getPrices($custom->price, $custom->price, $item->tax_rule_id, false, $params);
                $optionName .= ' &lt;span class="djc_custom_price"&gt;(+' . htmlspecialchars(DJCatalog2HtmlHelper::formatPrice($prices['display'], $params), ENT_QUOTES, 'UTF-8') . ')&lt;/span&gt;';
            }

            $source .= '<option value="' . $custom->_cid . '">' . $optionName . '</option>';
        }
        $source .= '</field>';

        foreach ($customisations as $custom) {

            $showon = 'showon="customisation:' . $custom->_cid . '"';
            $class = 'djc2-custom-input djc2-custom-input-' . $custom->_cid;

            $noteLbl = '';
            $noteDesc = '';

            if (count($custom->input_params) > 0) {
                $noteLbl = JText::sprintf('COM_DJCATALOG2_CUSTOMISATION_OPT_NOTE', $custom->name);
            }

            if ($custom->min_quantity > 0 || $custom->max_quantity > 0) {
                $noteLbl = JText::sprintf('COM_DJCATALOG2_CUSTOMISATION_OPT_NOTE', $custom->name);

                if ($custom->min_quantity > 0 && $custom->max_quantity > 0) {
                    $noteDesc = JText::sprintf('COM_DJCATALOG2_CUSTOMISATION_MIN_MAX_NOTE', $custom->min_quantity, $custom->max_quantity);
                } else if ($custom->min_quantity > 0) {
                    $noteDesc = JText::sprintf('COM_DJCATALOG2_CUSTOMISATION_MIN_NOTE', $custom->min_quantity);
                } else if ($custom->max_quantity > 0) {
                    $noteDesc = JText::sprintf('COM_DJCATALOG2_CUSTOMISATION_MAX_NOTE', $custom->max_quantity);
                }
            }

            if ($noteLbl != '' || $noteDesc != '') {
                $source .= '<field ' . $showon . ' type="note" name="' . $custom->_cid . '-note-inputparams" label="' . $noteLbl . '" description="' . $noteDesc . '" />';
            }

            foreach ($custom->input_params as $ik => $inputParam) {

                $input = Joomla\Utilities\ArrayHelper::toObject($inputParam);
                //$name = 'customisation-' . $custom->_cid .'-'.$ik;
                $name = 'customValues-' . $custom->_cid . '[' . $ik . ']';
                $required = (!empty($input->required)) ? 'required="true"' : '';

                switch ($input->type) {
                    case 'file':
                    {
                        //$source .= '<field '.$showon.' name="'.$name.'" type="djcplupload" label="'.$input->label.'" multiple_files="false" limit="1" preview="true" caption="false" download="false" extensions="jpg,png,gif" />';
                        // CUSTOM
                        $ext = trim((string)$input->allowed_types);
                        $ext = ($ext == '') ? 'jpg,png' : $ext;

                        $maxSize = trim((string)$input->max_size);
                        $maxSize = ((int)$maxSize > 0) ? $maxSize : 2048;

                        $fileDesc = JText::sprintf('COM_DJCATALOG2_PLUPLOAD_FILE_INFO_SPACER', ($maxSize / 1024) . 'MB', str_replace(',', ', ', $ext));
                        $fieldLbl = $input->label . ' &lt;br /&gt;&lt;small&gt;(' . $fileDesc . ')&lt;/small&gt;';

                        $source .= '<field class="' . $class . '" ' . $showon . ' name="' . $name . '" type="djcplupload" label="' . $fieldLbl . '" multiple_files="false" limit="1" preview="false" caption="false" download="false" extensions="' . $ext . '" max_size="' . $maxSize . '" ' . $required . ' />';
                        //$source .= '<field '.$showon.' type="note" name="'.$name.'-spacer" description="'.$fileDesc.'" label="" />';
                        break;
                    }
                    case 'text':
                    {
                        $source .= '<field ' . $showon . '  name="' . $name . '" type="text" label="' . $input->label . '" ' . $required . ' class="' . $class . '" />';
                        break;
                    }
                    case 'textarea':
                    {
                        $source .= '<field ' . $showon . '  name="' . $name . '" type="textarea" label="' . $input->label . '" ' . $required . ' class="' . $class . '" />';
                        break;
                    }
                    case 'radio':
                    {
                        if (!empty($inputParam['options']) && is_array($inputParam['options'])) {
                            $source .= '<field ' . $showon . '  name="' . $name . '" type="radio" label="' . $input->label . '" ' . $required . ' class="' . $class . '">';
                            foreach ($inputParam['options'] as $subOptionKey => $subOption) {
                                $prices = Djcatalog2HelperPrice::getPrices($subOption['option_price'], $subOption['option_price'], $item->tax_rule_id, false, $params);
                                $subOptionLbl = $subOption['option_label'];
                                if (trim((string)$subOption['option_price']) != '' && $subOption['option_price'] > 0) {
                                    $subOptionLbl .= ' (+ ' . htmlspecialchars(DJCatalog2HtmlHelper::formatPrice($prices['display'], $params), ENT_QUOTES, 'UTF-8') . ')';
                                }
                                $source .= '<option value="' . $subOptionKey . '">' . $subOptionLbl . '</option>';
                            }
                            $source .= '</field>';
                        }
                        break;
                    }
                    case 'checkbox':
                    {
                        if (!empty($inputParam['options']) && is_array($inputParam['options'])) {
                            $source .= '<field ' . $showon . '  name="' . $name . '" type="checkboxes" label="' . $input->label . '" ' . $required . ' class="' . $class . '">';
                            foreach ($inputParam['options'] as $subOptionKey => $subOption) {
                                $prices = Djcatalog2HelperPrice::getPrices($subOption['option_price'], $subOption['option_price'], $item->tax_rule_id, false, $params);
                                $subOptionLbl = $subOption['option_label'];
                                if (trim((string)$subOption['option_price']) != '' && $subOption['option_price'] > 0) {
                                    $subOptionLbl .= ' (+' . htmlspecialchars(DJCatalog2HtmlHelper::formatPrice($prices['display'], $params), ENT_QUOTES, 'UTF-8') . ')';
                                }
                                $source .= '<option value="' . $subOptionKey . '">' . $subOptionLbl . '</option>';
                            }
                            $source .= '</field>';
                        }
                        break;
                    }
                    default :
                    {
                        $results = Joomla\CMS\Factory::getApplication()->triggerEvent('onProductCustomisationXMLPrepare', [$name, $item, $custom, $input, $this, $showon]);
                        foreach ($results as $result) {
                            if (trim((string)$result) == '' || empty($result)) continue;
                            $source .= $result;
                        }
                        break;
                    }
                }

            }
        }

        $source .= '</fieldset></form>';

        $form = JForm::getInstance('com_djcatalog2.cart.customisation', $source, array('control' => false), false, false);
        $app = JFactory::getApplication();

        if (!empty($data)) {
            $form->bind($data);
        }

        return $form;
    }

    public function getTierPrices($item_id)
    {

        if (!isset($this->_price_tiers[$item_id])) {
            $db = JFactory::getDbo();
            $query = $db->getQuery(true);
            $query->select('*')->from('#__djc2_items_price_tiers')->where('item_id=' . (int)$item_id)->order('quantity ASC');
            $db->setQuery($query);
            $this->_price_tiers[$item_id] = $db->loadObjectList();
        }

        return $this->_price_tiers[$item_id];
    }

    public function hit($pk = 0)
    {
        $pk = (!empty ($pk)) ? $pk : ( int )$this->getState('item.id');

        Djcatalog2Helper::pushRecentItem($pk);

        $db = $this->getDbo();
        $db->setQuery('UPDATE #__djc2_items' . ' SET hits = hits + 1' . ' WHERE id = ' . ( int )$pk);
        $db->execute();

        return true;
    }

    protected function parseConfigConditions($data)
    {
        $cfgCond = ArrayHelper::fromObject($data, false);
        foreach ($cfgCond as $key => $row) {
            if (is_object($row->field->field_id)) {
                $fids = ArrayHelper::fromObject($row->field->field_id);
                $row->field->field_id = $fids[0];
            } else {
                $row->field->field_id = $row->field->field_id[0];
            }
            if (is_object($row->field->option_id)) {
                $row->field->option_id = ArrayHelper::fromObject($row->field->option_id);
            }
            if (is_object($row->field->price)) {
                $row->field->price = ArrayHelper::fromObject($row->field->price);
            }
            if (is_object($row->field->price_mod)) {
                $row->field->price_mod = ArrayHelper::fromObject($row->field->price_mod);
            }
            if (is_object($row->field->sku)) {
                $row->field->sku = ArrayHelper::fromObject($row->field->sku);
            }
            if (is_object($row->field->info)) {
                $row->field->info = ArrayHelper::fromObject($row->field->info);
            }
            if (is_object($row->dependancies)) {
                $row->dependancies = ArrayHelper::fromObject($row->dependancies, false);
            }
            $cfgCond[$key] = $row;
        }

        $cSteps = array();
        foreach ($cfgCond as $condition) {
            if (empty($condition->field->option_id)) continue;

            $fDef = $this->getAttributeById($condition->field->field_id);
            if (empty($fDef)) continue;

            if (!isset($cSteps[$condition->field->field_id])) {
                $cSteps[$condition->field->field_id] = array(
                    'name' => $fDef->name,
                    'description' => $fDef->description,
                    'field_id' => $fDef->id,
                    'options' => array()
                );
            }

            foreach ($condition->field->option_id as $avOption) {
                if (empty($fDef->optionValues[$avOption])) continue;

                $item = array(
                    'value' => $fDef->optionValues[$avOption],
                    'id' => $avOption,
                    'params' => $fDef->optionParams[$avOption],
                    'dependancies' => array(),
                    'price' => 0,
                    'sku' => '',
                    'info' => ''
                );

                if (isset($condition->field->price) && isset($condition->field->price[$avOption])) {
                    $item['price'] = $condition->field->price[$avOption];
                }
                if (isset($condition->field->sku) && isset($condition->field->sku[$avOption])) {
                    $item['sku'] = $condition->field->sku[$avOption];
                }
                if (isset($condition->field->info) && isset($condition->field->info[$avOption])) {
                    $item['info'] = $condition->field->info[$avOption];
                }
                if (isset($condition->field->price_mod) && isset($condition->field->price_mod[$avOption])) {
                    $item['price_mod'] = $condition->field->price_mod[$avOption];
                }
                if (!empty($condition->dependancies)) {
                    foreach ($condition->dependancies as $dep) {

                        $cndField = $this->getAttributeById($dep->field_rule->field_id[0]);
                        if (empty($cndField)) {
                            continue;
                            //echo '<pre>' . print_r($dep, true) . '</pre>';die();
                        }

                        $depItem = array(
                            'id' => $dep->field_rule->field_id[0],
                            'name' => $cndField->name,
                            'operator' => $dep->field_rule->operator,
                            'match' => null
                        );

                        if ($depItem['operator'] == 'eq' || $depItem['operator'] == 'not') {
                            $depItem['match'] = array();
                            $depItem['match_values'] = array();
                            $depItem['match_ids'] = array();

                            if (!empty($dep->field_rule->rule_options) && is_array($dep->field_rule->rule_options)) {
                                foreach ($dep->field_rule->rule_options as $rOption) {
                                    if (empty($cndField->optionValues[$rOption])) continue;
                                    $depItem['match'][] = array(
                                        'id' => $rOption,
                                        'value' => $cndField->optionValues[$rOption],
                                        'params' => $cndField->optionParams[$rOption]
                                    );
                                    $depItem['match_values'][] = $cndField->optionValues[$rOption];
                                    $depItem['match_ids'][] = $rOption;
                                }
                            }
                        } else {
                            $depItem['match'] = $dep->field_rule->rule_text;
                        }

                        $item['dependancies'][] = $depItem;
                    }
                }

                $cSteps[$condition->field->field_id]['options'][] = $item;
            }
        }
        return $cSteps;
    }

    public function storeVote($pk = 0, $rate = 0, $created = '0000-00-00 00:00:00', $review = '', $author = '', $language = '*', $user_id = 0)
    {
        if ($rate >= 1 && $rate <= 5 && $pk > 0) {
            $userIP = IpHelper::getIp();

            // Initialize variables.
            $db = $this->getDbo();
            $query = $db->getQuery(true);

            // Create the base select statement.
            $query->select('*')
                ->from($db->quoteName('#__djc2_item_rating'))
                ->where($db->quoteName('item_id') . ' = ' . (int)$pk);

            // Set the query and load the result.
            $db->setQuery($query);

            // Check for a database error.
            try {
                $rating = $db->loadObject();
            } catch (RuntimeException $e) {
                JFactory::getApplication()->enqueueMessage($e->getMessage(), 'warning');
                return false;
            }

            // There are no ratings yet, so lets insert our rating
            if (!$rating) {
                $query = $db->getQuery(true);

                // Create the base insert statement.
                $query->insert($db->quoteName('#__djc2_item_rating'))
                    ->columns(array($db->quoteName('item_id'), $db->quoteName('lastip'), $db->quoteName('rating_sum'), $db->quoteName('rating_count')))
                    ->values((int)$pk . ', ' . $db->quote($userIP) . ',' . (int)$rate . ', 1');

                // Set the query and execute the insert.
                $db->setQuery($query);

                try {
                    $db->execute();
                } catch (RuntimeException $e) {
                    JFactory::getApplication()->enqueueMessage($e->getMessage(), 'error');
                    return false;
                }
            } else {
                if ($userIP != $rating->lastip) {
                    $query = $db->getQuery(true);

                    // Create the base update statement.
                    $query->update($db->quoteName('#__djc2_item_rating'))
                        ->set($db->quoteName('rating_count') . ' = rating_count + 1')
                        ->set($db->quoteName('rating_sum') . ' = rating_sum + ' . (int)$rate)
                        ->set($db->quoteName('lastip') . ' = ' . $db->quote($userIP))
                        ->where($db->quoteName('item_id') . ' = ' . (int)$pk);

                    // Set the query and execute the update.
                    $db->setQuery($query);

                    try {
                        $db->execute();
                    } catch (RuntimeException $e) {
                        JFactory::getApplication()->enqueueMessage($e->getMessage(), 'error');
                        return false;
                    }
                } else {
                    return false;
                }
            }

            $query = $db->getQuery(true);
            $query->insert('#__djc2_item_reviews');
            $query->columns(array($db->quoteName('item_id'), $db->quoteName('user_id'), $db->quoteName('review'), $db->quoteName('rating'), $db->quoteName('author'), $db->quoteName('ip'), $db->quoteName('created'), $db->quoteName('language')));
            $query->values((int)$pk . ', ' . (int)$user_id . ', ' . $db->quote($review) . ', ' . (int)$rate . ',' . $db->quote($author) . ', ' . $db->quote($userIP) . ', ' . $db->quote($created) . ', ' . $db->quote($language));

            $db->setQuery($query);
            try {
                $db->execute();
            } catch (RuntimeException $e) {
                JFactory::getApplication()->enqueueMessage($e->getMessage(), 'warning');
                return false;
            }

            $this->cleanCache();

            return true;
        }

        JFactory::getApplication()->enqueueMessage(JText::sprintf('COM_CONTENT_INVALID_RATING', $rate), 'warning');
        return false;
    }
}