function display($tpl = null)
{
// Get the task
$task = vRequest::getCmd('task', $this->getLayout());
$this->assignRef('task', $task);
// Load helpers
if (!class_exists('CurrencyDisplay')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VmHTML')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'html.php';
}
if (!class_exists('VmImage')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'image.php';
}
$model = tmsModel::getModel();
// Handle any publish/unpublish
switch ($task) {
case 'add':
case 'edit':
//this was in the controller for the edit tasks, we need this for the access by FE
//$this->addTemplatePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'views'.DS.'product'.DS.'tmpl');
tsmConfig::loadJLang('com_tsmart_orders', TRUE);
tsmConfig::loadJLang('com_tsmart_shoppers', TRUE);
$model_country = tmsModel::getModel('country');
$this->countries = $model_country->getItemList();
$tsmart_product_id = vRequest::getInt('tsmart_product_id');
if (is_array($tsmart_product_id) && count($tsmart_product_id) > 0) {
$tsmart_product_id = (int) $tsmart_product_id[0];
} else {
$tsmart_product_id = (int) $tsmart_product_id;
}
$product = $model->getItem($tsmart_product_id);
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmserviceclass.php';
$product->tsmart_service_class_ids = tsmserviceclass::get_list_service_class_ids_by_tour_id($tsmart_product_id);
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmgroupsize.php';
$product->tsmart_group_size_ids = tsmGroupSize::get_list_group_size_ids_by_tour_id($tsmart_product_id);
//$user = JFactory::getUser();
$superVendor = vmAccess::isSuperVendor();
if ($superVendor != 1 and $superVendor != $product->tsmart_vendor_id) {
vmdebug('Product view.html.php ' . $superVendor, $product->tsmart_vendor_id);
JFactory::getApplication()->redirect('index.php?option=com_tsmart&view=tsmart', tsmText::_('com_tsmart_ALERTNOTAUTHOR'), 'error');
}
if (!empty($product->product_parent_id)) {
$product_parent = $model->getProductSingle($product->product_parent_id, false);
}
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmserviceclass.php';
$this->tour_service_class = tsmserviceclass::get_list_tour_service_class();
$customfields = tmsModel::getModel('Customfields');
$product->allIds[] = $product->tsmart_product_id;
if (!empty($product->product_parent_id)) {
$product->allIds[] = $product->product_parent_id;
}
$product->customfields = $customfields->getCustomEmbeddedProductCustomFields($product->allIds);
// Get the category tree
if (isset($product->categories)) {
$this->category_tree = ShopFunctions::categoryListTree($product->categories);
} else {
$this->category_tree = ShopFunctions::categoryListTree();
}
//Fallback for categories inherited by parent to correctly calculate the prices
if (empty($product->categories) and !empty($product_parent->categories)) {
$product->categories = $product_parent->categories;
}
//Get the shoppergoup list - Cleanshooter Custom Shopper Visibility
if (!isset($product->shoppergroups)) {
$product->shoppergroups = 0;
}
$this->shoppergroupList = ShopFunctions::renderShopperGroupList($product->shoppergroups);
// Load the product price
if (!class_exists('calculationHelper')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'calculationh.php';
}
//Do we need the children? If there is a C customfield, we dont want them
$isCustomVariant = false;
foreach ($product->customfields as $custom) {
if ($custom->field_type == 'C' and $custom->tsmart_product_id == $tsmart_product_id) {
$isCustomVariant = true;
break;
}
}
if (!class_exists('tsmartModelConfig')) {
require VMPATH_ADMIN . '/models/config.php';
}
$productLayouts = tsmartModelConfig::getLayoutList('productdetails');
$this->productLayouts = $productLayouts;
// Load Images
$model->addImages($product);
if (!class_exists('VmTemplate')) {
require VMPATH_SITE . DS . 'helpers' . DS . 'vmtemplate.php';
}
$vmtemplate = VmTemplate::loadVmTemplateStyle();
$this->imagePath = shopFunctions::getAvailabilityIconUrl($vmtemplate);
// Load the vendors
$vendor_model = tmsModel::getModel('vendor');
$lists['vendors'] = '';
if ($this->showVendors()) {
$lists['vendors'] = Shopfunctions::renderVendorList($product->tsmart_vendor_id);
}
// Load the currencies
$currency_model = tmsModel::getModel('currency');
$vendor_model->setId(vmAccess::isSuperVendor());
$this->vendor = $vendor_model->getVendor();
$currency = $currency_model->getItemList();
$this->vendor_currency_symb = $currency->currency_symbol;
$lists['manufacturers'] = shopFunctions::renderManufacturerList($product->tsmart_manufacturer_id, true);
if (!empty($product->product_weight_uom)) {
$product_weight_uom = $product->product_weight_uom;
} else {
if (!empty($product_parent)) {
$product_weight_uom = $product_parent->product_weight_uom;
} else {
$product_weight_uom = tsmConfig::get('weight_unit_default');
}
}
if (!empty($product->product_lwh_uom)) {
$product_lwh_uom = $product->product_lwh_uom;
} else {
if (!empty($product_parent)) {
$product_lwh_uom = $product_parent->product_lwh_uom;
} else {
$product_lwh_uom = tsmConfig::get('lwh_unit_default');
}
}
if (!empty($product->product_unit)) {
$product_unit = $product->product_unit;
} else {
if (!empty($product_parent)) {
$product_unit = $product_parent->product_unit;
} else {
$product_unit = tsmConfig::get('product_unit_default', 'KG');
}
}
$lists['product_weight_uom'] = ShopFunctions::renderWeightUnitList('product_weight_uom', $product_weight_uom);
$lists['product_iso_uom'] = ShopFunctions::renderUnitIsoList('product_unit', $product_unit);
$lists['product_lwh_uom'] = ShopFunctions::renderLWHUnitList('product_lwh_uom', $product_lwh_uom);
if (empty($product->product_available_date)) {
$product->product_available_date = date("Y-m-d");
}
$waitinglistmodel = tmsModel::getModel('waitinglist');
/* Load waiting list */
if ($product->tsmart_product_id) {
//$waitinglist = $this->get('waitingusers', 'waitinglist');
$waitinglist = $waitinglistmodel->getWaitingusers($product->tsmart_product_id);
$this->assignRef('waitinglist', $waitinglist);
}
$orderstatusModel = tmsModel::getModel('orderstatus');
$lists['OrderStatus'] = $orderstatusModel->renderOSList(array(), 'order_status', TRUE);
// Add the tsmart_shoppergroup_ids
$cid = JFactory::getUser()->id;
$this->activeShoppergroups = shopfunctions::renderGuiList($cid, 'shoppergroups', 'shopper_group_name', 'category', 'vmuser_shoppergroups', 'tsmart_user_id');
if (!empty($this->activeShoppergroups)) {
$shoppergroupModel = tmsModel::getModel('shoppergroup');
$this->activeShoppergroups = tsmText::_($shoppergroupModel->getDefault(0)->shopper_group_name);
}
// Load protocustom lists
$customModel = tmsModel::getModel('custom');
$this->fieldTypes = tsmartModelCustom::getCustomTypes();
$customsList = $customModel->getCustomsList();
$attribs = 'style= "width: 300px;"';
$customlist = JHtml::_('select.genericlist', $customsList, 'customlist', $attribs, 'value', 'text', null, false, true);
$this->assignRef('customsList', $customlist);
if ($product->product_parent_id > 0) {
// Set up labels
$info_label = tsmText::_('com_tsmart_PRODUCT_FORM_ITEM_INFO_LBL');
$status_label = tsmText::_('com_tsmart_PRODUCT_FORM_ITEM_STATUS_LBL');
$dim_weight_label = tsmText::_('com_tsmart_PRODUCT_FORM_ITEM_DIM_WEIGHT_LBL');
$images_label = tsmText::_('com_tsmart_PRODUCT_FORM_ITEM_IMAGES_LBL');
$delete_message = tsmText::_('com_tsmart_PRODUCT_FORM_DELETE_ITEM_MSG');
} else {
if ($task == 'add') {
$action = tsmText::_('com_tsmart_PRODUCT_FORM_NEW_PRODUCT_LBL');
} else {
$action = tsmText::_('com_tsmart_PRODUCT_FORM_UPDATE_ITEM_LBL');
}
$info_label = tsmText::_('com_tsmart_PRODUCT_FORM_PRODUCT_INFO_LBL');
$status_label = tsmText::_('com_tsmart_PRODUCT_FORM_PRODUCT_STATUS_LBL');
$dim_weight_label = tsmText::_('com_tsmart_PRODUCT_FORM_PRODUCT_DIM_WEIGHT_LBL');
$images_label = tsmText::_('com_tsmart_PRODUCT_FORM_PRODUCT_IMAGES_LBL');
$delete_message = tsmText::_('com_tsmart_PRODUCT_FORM_DELETE_PRODUCT_MSG');
}
//get countries
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmcountries.php';
$countries = tsmcountries::get_countries();
$this->assignRef('countries', $countries);
//end get countries
//get cities
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/vmcities.php';
$cities = tsmcities::get_cities();
$this->assignRef('cities', $cities);
//end get cities
//get tour style
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmtourstyle.php';
$list_tour_style = tsmtourstyle::get_list_tour_style();
$this->assignRef('list_tour_style', $list_tour_style);
//end get toursyle
//get tour section
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmtoursection.php';
$list_tour_section = tsmtoursection::get_list_tour_section();
$this->assignRef('list_tour_section', $list_tour_section);
//end get toursyle
//get tour physicalgrade
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmphysicalgrade.php';
$list_physical_grade = vmphysicalgrade::get_physical_grade();
$this->assignRef('list_physical_grade', $list_physical_grade);
//end get physicalgrade
//get tour_type
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmtourtype.php';
$list_tour_type = tsmtourtype::get_list_tour_type();
$this->assignRef('list_tour_type', $list_tour_type);
//end get tour_type
//get tour_type
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmserviceclass.php';
$list_tour_service_class = tsmserviceclass::get_list_tour_service_class();
$product->list_tour_service_class_id = tsmserviceclass::get_list_service_class_ids_by_tour_id($product->tsmart_product_id);
$this->assignRef('list_tour_service_class', $list_tour_service_class);
//end get tour_type
//get activities
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/vmactivities.php';
$product->list_activity_id = tsmactivities::get_list_activity_id_by_tour_id($product->tsmart_product_id);
$activities = tsmactivities::get_activities();
$this->assignRef('activities', $activities);
//end get activities
//get list group size
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmgroupsize.php';
$list_group_size = tsmGroupSize::get_list_group_size();
$product->list_group_size_id = tsmGroupSize::get_list_group_size_ids_by_tour_id($product->tsmart_product_id);
$this->assignRef('list_group_size', $list_group_size);
//end get list group size
//get list country
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmcountries.php';
$product->list_tsmart_country_id = tsmcountries::get_list_tsmart_country_id_by_tour_id($product->tsmart_product_id);
//end get list group size
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmprice.php';
$this->list_price_type = vmprice::get_list_price_type();
require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmproduct.php';
$this->list_tour_method = vmproduct::get_list_tour_method();
$this->assignRef('product', $product);
$this->assignRef('product_parent', $product_parent);
/* Assign label values */
$this->assignRef('action', $action);
$this->assignRef('info_label', $info_label);
$this->assignRef('status_label', $status_label);
$this->assignRef('dim_weight_label', $dim_weight_label);
$this->assignRef('images_label', $images_label);
$this->assignRef('delete_message', $delete_message);
$this->assignRef('lists', $lists);
// Toolbar
if ($product->product_sku) {
$sku = ' (' . $product->product_sku . ')';
} else {
$sku = "";
}
//if (!empty($product->canonCatLink)) $canonLink = '&tsmart_category_id=' . $product->canonCatLink; else $canonLink = '';
if (!empty($product->tsmart_product_id)) {
if (!class_exists('shopFunctionsF')) {
require VMPATH_SITE . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
$menuItemID = shopFunctionsF::getMenuItemId(JFactory::getLanguage()->getTag());
$canonLink = '';
if ($product->canonCatId) {
$canonLink = '&tsmart_category_id=' . $product->canonCatId;
}
$text = '<a href="' . juri::root() . 'index.php?option=com_tsmart&view=productdetails&tsmart_product_id=' . $product->tsmart_product_id . $canonLink . '&Itemid=' . $menuItemID . '" target="_blank" >' . $product->product_name . $sku . '<span class="vm2-modallink"></span></a>';
if (JFactory::getApplication()->isSite()) {
$bar = JToolBar::getInstance('toolbar');
$bar->appendButton('Link', 'back', 'com_tsmart_LEAVE_TO_PRODUCT', juri::root() . 'index.php?option=com_tsmart&view=productdetails&tsmart_product_id=' . $product->tsmart_product_id . $canonLink . '&Itemid=' . $menuItemID);
}
} else {
$text = $product->product_name . $sku;
}
$this->SetViewTitle('PRODUCT', $text);
$this->addStandardEditViewCommandsNoValidate($product->tsmart_product_id);
break;
case 'massxref_cats':
case 'massxref_cats_exe':
$this->SetViewTitle('PRODUCT_MASSXREF');
$showVendors = $this->showVendors();
$this->assignRef('showVendors', $showVendors);
$keyWord = '';
$catmodel = tmsModel::getModel('category');
$this->assignRef('catmodel', $catmodel);
$this->addStandardDefaultViewCommandsNoValidate();
$this->addStandardDefaultViewLists($catmodel, 'category_name');
$session = JFactory::getSession();
$reset = $session->get('reset_pag', false, 'vm');
$limit = '';
if ($reset) {
$limit = 0;
$session->set('reset_pag', false, 'vm');
}
$this->categories = $catmodel->getCategoryTree(0, 0, false, $this->lists['search'], $limit);
$catpagination = $catmodel->getPagination();
$this->assignRef('catpagination', $catpagination);
$this->setLayout('massxref');
JToolBarHelper::custom('massxref_cats_exe', 'new', 'new', tsmText::_('com_tsmart_PRODUCT_XREF_CAT_EXE'), false);
break;
case 'massxref_sgrps':
case 'massxref_sgrps_exe':
$sgrpmodel = tmsModel::getModel('shoppergroup');
$this->addStandardDefaultViewLists($sgrpmodel);
$shoppergroups = $sgrpmodel->getShopperGroups(false, true);
$this->assignRef('shoppergroups', $shoppergroups);
$sgrppagination = $sgrpmodel->getPagination();
$this->assignRef('sgrppagination', $sgrppagination);
$this->setLayout('massxref');
JToolBarHelper::custom('massxref_sgrps_exe', 'new', 'new', tsmText::_('com_tsmart_PRODUCT_XREF_SGRPS_EXE'), false);
break;
default:
if ($product_parent_id = vRequest::getInt('product_parent_id', false)) {
$product_parent = $model->getProductSingle($product_parent_id, false);
if ($product_parent) {
$title = 'PRODUCT_CHILDREN_LIST';
$link_to_parent = JHtml::_('link', JRoute::_('index.php?view=product&task=edit&tsmart_product_id=' . $product_parent->tsmart_product_id . '&option=com_tsmart'), $product_parent->product_name, array('title' => tsmText::_('com_tsmart_EDIT_PARENT') . ' ' . $product_parent->product_name));
$msg = tsmText::_('com_tsmart_PRODUCT_OF') . " " . $link_to_parent;
} else {
$title = 'PRODUCT_CHILDREN_LIST';
$msg = 'Parent with product_parent_id ' . $product_parent_id . ' not found';
}
} else {
$title = 'PRODUCT';
$msg = "";
}
$this->SetViewTitle($title, $msg);
$this->addStandardDefaultViewLists($model, 'created_on');
if ($cI = vRequest::getInt('tsmart_category_id', false)) {
$app = JFactory::getApplication();
//$old_state = $app->getUserState('tsmart_category_id');
$old_state = $app->getUserState('tsmart_category_id');
if (empty($old_state) or $old_state != $cI) {
vRequest::setVar('com_tsmart.product.filter_order', 'pc.ordering');
$model->filter_order = 'pc.ordering';
$old_state = $app->setUserState('tsmart_category_id', $cI);
}
}
//Get the list of products
$productlist = $model->getItemList();
//The pagination must now always set AFTER the model load the listing
$this->pagination = $model->getPagination();
//Get the category tree
$categoryId = $model->tsmart_category_id;
//OSP switched to filter in model, was vRequest::getInt('tsmart_category_id');
$category_tree = ShopFunctions::categoryListTree(array($categoryId));
$this->assignRef('category_tree', $category_tree);
//load service class
//Load the product price
if (!class_exists('calculationHelper')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'calculationh.php';
}
$vendor_model = tmsModel::getModel('vendor');
$productreviews = tmsModel::getModel('ratings');
$this->mfTable = $model->getTable('manufacturers');
$this->catTable = $model->getTable('categories');
$this->lists['vendors'] = '';
if ($this->showVendors()) {
$this->lists['vendors'] = Shopfunctions::renderVendorList(vmAccess::getVendorId());
}
foreach ($productlist as $tsmart_product_id => $product) {
$product->mediaitems = count($product->tsmart_media_id);
$product->reviews = $productreviews->countReviewsForProduct($product->tsmart_product_id);
$vendor_model->setId($product->tsmart_vendor_id);
$vendor = $vendor_model->getVendor();
$currencyDisplay = CurrencyDisplay::getInstance($vendor->vendor_currency, $vendor->tsmart_vendor_id);
if (!empty($product->allPrices[$product->selectedPrice]['product_price']) && !empty($product->allPrices[$product->selectedPrice]['product_currency'])) {
$product->product_price_display = $currencyDisplay->priceDisplay($product->allPrices[$product->selectedPrice]['product_price'], (int) $product->allPrices[$product->selectedPrice]['product_currency'], 1, true);
} else {
if (!empty($product->allPrices) and count($product->allPrices) > 1) {
$product->product_price_display = tsmText::_('com_tsmart_MULTIPLE_PRICES');
} else {
$product->product_price_display = tsmText::_('com_tsmart_NO_PRICE_SET');
}
}
// Write the first 5 categories in the list
$product->categoriesList = '';
if (!empty($product->categories[0])) {
$product->categoriesList = shopfunctions::renderGuiList($product->categories, 'categories', 'category_name', 'category');
}
// Write the first 5 manufacturers in the list
$product->manuList = '';
if (!empty($product->tsmart_manufacturer_id[0])) {
$product->manuList = shopfunctions::renderGuiList($product->tsmart_manufacturer_id, 'manufacturers', 'mf_name', 'manufacturer');
}
}
$mf_model = tmsModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown();
$this->assignRef('manufacturers', $manufacturers);
/* add Search filter in lists*/
/* Search type */
$options = array('' => tsmText::_('com_tsmart_LIST_EMPTY_OPTION'), 'parent' => tsmText::_('com_tsmart_PRODUCT_LIST_SEARCH_BY_PARENT_PRODUCT'), 'product' => tsmText::_('com_tsmart_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRODUCT'), 'price' => tsmText::_('com_tsmart_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRICE'), 'withoutprice' => tsmText::_('com_tsmart_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_WITHOUTPRICE'));
$this->lists['search_type'] = VmHTML::selectList('search_type', vRequest::getVar('search_type'), $options);
/* Search order */
$options = array('bf' => tsmText::_('com_tsmart_PRODUCT_LIST_SEARCH_BY_DATE_BEFORE'), 'af' => tsmText::_('com_tsmart_PRODUCT_LIST_SEARCH_BY_DATE_AFTER'));
$this->lists['search_order'] = VmHTML::selectList('search_order', vRequest::getVar('search_order'), $options);
// Toolbar
/*if (vmAccess::manager('product.edit')) {
JToolBarHelper::custom('massxref_cats', 'new', 'new', vmText::_('com_tsmart_PRODUCT_XREF_CAT'), true);
JToolBarHelper::custom('massxref_sgrps', 'new', 'new', vmText::_('com_tsmart_PRODUCT_XREF_SGRPS'), true);
}
if (vmAccess::manager('product.create')) {
JToolBarHelper::custom('createchild', 'new', 'new', vmText::_('com_tsmart_PRODUCT_CHILD'), true);
JToolBarHelper::custom('cloneproduct', 'copy', 'copy', vmText::_('com_tsmart_PRODUCT_CLONE'), true);
}*/
// JToolBarHelper::custom('addrating', 'default', '', vmText::_('com_tsmart_ADD_RATING'), true);
$view = vRequest::getCmd('view', vRequest::getCmd('controller', 'tsmart'));
JToolBarHelper::divider();
if (vmAccess::manager($view . '.edit.state')) {
JToolBarHelper::publishList();
JToolBarHelper::unpublishList();
}
if (vmAccess::manager($view . '.delete')) {
JToolBarHelper::spacer('10');
JToolBarHelper::deleteList();
}
$this->assignRef('productlist', $productlist);
$this->assignRef('tsmart_category_id', $categoryId);
$this->assignRef('model', $model);
break;
}
parent::display($tpl);
}
function display($tpl = null)
{
$filter = vRequest::getVar('q', vRequest::getVar('term', false));
$id = vRequest::getInt('id', false);
$tsmart_product_id = vRequest::getInt('tsmart_product_id', array());
if (is_array($tsmart_product_id) && count($tsmart_product_id) > 0) {
$product_id = (int) $tsmart_product_id[0];
} else {
$product_id = (int) $tsmart_product_id;
}
//$customfield = $this->model->getcustomfield();
/* Get the task */
if ($this->type == 'relatedproducts') {
$query = "SELECT tsmart_product_id AS id, CONCAT(product_name, '::', product_sku) AS value\n\t\t\t\tFROM #__tsmart_products_" . tsmConfig::$vmlang . "\n\t\t\t\t JOIN `#__tsmart_products` AS p using (`tsmart_product_id`)";
if ($filter) {
$query .= " WHERE product_name LIKE '%" . $this->db->escape($filter, true) . "%' or product_sku LIKE '%" . $this->db->escape($filter, true) . "%' limit 0,10";
}
self::setRelatedHtml($product_id, $query, 'R');
} else {
if ($this->type == 'relatedcategories') {
$query = "SELECT tsmart_category_id AS id, CONCAT(category_name, '::', tsmart_category_id) AS value\n\t\t\t\tFROM #__tsmart_categories_" . tsmConfig::$vmlang;
if ($filter) {
$query .= " WHERE category_name LIKE '%" . $this->db->escape($filter, true) . "%' limit 0,10";
}
self::setRelatedHtml($product_id, $query, 'Z');
} else {
if ($this->type == 'custom') {
$query = "SELECT CONCAT(tsmart_custom_id, '|', custom_value, '|', field_type) AS id, CONCAT(custom_title, '::', custom_tip) AS value\n\t\t\t\tFROM #__tsmart_customs";
if ($filter) {
$query .= " WHERE custom_title LIKE '%" . $filter . "%' limit 0,50";
}
$this->db->setQuery($query);
$this->json['value'] = $this->db->loadObjectList();
$this->json['ok'] = 1;
} else {
if ($this->type == 'fields') {
if (!class_exists('tsmartModelCustom')) {
require VMPATH_ADMIN . DS . 'models' . DS . 'custom.php';
}
$fieldTypes = tsmartModelCustom::getCustomTypes();
$model = tmsModel::getModel('custom');
$q = 'SELECT `tsmart_custom_id` FROM `#__tsmart_customs`
WHERE (`custom_parent_id`=' . $id . ') ';
$q .= 'order by `ordering` asc';
$this->db->setQuery($q);
$ids = $this->db->loadColumn();
if ($ids) {
array_unshift($ids, $id);
} else {
$ids = array($id);
}
foreach ($ids as $k => $i) {
$p = $model->getCustom($i);
if ($p) {
$p->value = $p->custom_value;
$rows[] = $p;
}
}
$html = array();
foreach ($rows as $field) {
if ($field->field_type == 'deprecatedwasC') {
$this->json['table'] = 'childs';
$q = 'SELECT `tsmart_product_id` FROM `#__tsmart_products` WHERE `published`=1
AND `product_parent_id`= ' . vRequest::getInt('tsmart_product_id');
//$this->db->setQuery(' SELECT tsmart_product_id, product_name FROM `#__tsmart_products` WHERE `product_parent_id` ='.(int)$product_id);
$this->db->setQuery($q);
if ($childIds = $this->db->loadColumn()) {
// Get childs
foreach ($childIds as $childId) {
$field->custom_value = $childId;
$display = $this->model->displayProductCustomfieldBE($field, $childId, $this->row);
if ($field->is_cart_attribute) {
$cartIcone = 'default';
} else {
$cartIcone = 'default-off';
}
$html[] = '<div class="removable">
<td>' . $field->custom_title . '</td>
<td>' . $display . $field->custom_tip . '</td>
<td>' . tsmText::_($fieldTypes[$field->field_type]) . '
' . $this->model->setEditCustomHidden($field, $this->row) . '
</td>
<td><span class="vmicon vmicon-16-' . $cartIcone . '"></span></td>
<td></td>
</div>';
$this->row++;
}
}
} else {
//if ($field->field_type =='E') {
$this->json['table'] = 'customPlugins';
$colspan = '';
if ($field->field_type == 'E') {
$this->model->bindCustomEmbeddedFieldParams($field, 'E');
} else {
if ($field->field_type == 'C') {
$colspan = 'colspan="2" ';
}
}
$display = $this->model->displayProductCustomfieldBE($field, $product_id, $this->row);
if ($field->is_cart_attribute) {
$cartIcone = 'default';
} else {
$cartIcone = 'default-off';
}
$field->tsmart_product_id = $product_id;
$html[] = '
<tr class="removable">
<td>
<b>' . tsmText::_($fieldTypes[$field->field_type]) . '</b> ' . tsmText::_($field->custom_title) . '</span><br/>
<span class="vmicon vmicon-16-' . $cartIcone . '"></span>
<span class="vmicon vmicon-16-move"></span>
<span class="vmicon vmicon-16-remove"></span>
' . $this->model->setEditCustomHidden($field, $this->row) . '
</td>
<td ' . $colspan . '>' . $display . '</td>
</tr>
</tr>';
$this->row++;
}
}
$this->json['value'] = $html;
$this->json['ok'] = 1;
} else {
if ($this->type == 'userlist') {
$status = vRequest::getvar('status');
$productShoppers = 0;
if ($status) {
$productModel = tmsModel::getModel('product');
$productShoppers = $productModel->getProductShoppersByStatus($product_id, $status);
}
if (!class_exists('ShopFunctions')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'shopfunctions.php';
}
$html = ShopFunctions::renderProductShopperList($productShoppers);
$this->json['value'] = $html;
} else {
$this->json['ok'] = 0;
}
}
}
}
}
if (empty($this->json)) {
$this->json['value'] = null;
$this->json['ok'] = 1;
}
echo vmJsApi::safe_json_encode($this->json);
}
/** Save and delete from database
* all product custom_fields and xref
@ var $table : the xref table(eg. product,category ...)
@array $data : array of customfields
@int $id : The concerned id (eg. product_id)
*/
public function storeProductCustomfields($table, $datas, $id)
{
vRequest::vmCheckToken('Invalid token in storeProductCustomfields');
//Sanitize id
$id = (int) $id;
//Table whitelist
$tableWhiteList = array('product', 'category', 'manufacturer');
if (!in_array($table, $tableWhiteList)) {
return false;
}
// Get old IDS
$db = JFactory::getDBO();
$db->setQuery('SELECT `tsmart_customfield_id` FROM `#__tsmart_' . $table . '_customfields` as `PC` WHERE `PC`.tsmart_' . $table . '_id =' . $id);
$old_customfield_ids = $db->loadColumn();
if (array_key_exists('field', $datas)) {
foreach ($datas['field'] as $key => $fields) {
if (!empty($datas['field'][$key]['tsmart_product_id']) and (int) $datas['field'][$key]['tsmart_product_id'] != $id) {
//aha the field is from the parent, what we do with it?
$fields['override'] = (int) $fields['override'];
$fields['disabler'] = (int) $fields['disabler'];
if ($fields['override'] != 0 or $fields['disabler'] != 0) {
//If it is set now as override, store it as clone, therefore set the tsmart_customfield_id = 0
if ($fields['override'] != 0) {
$fields['override'] = $fields['tsmart_customfield_id'];
}
if ($fields['disabler'] != 0) {
$fields['disabler'] = $fields['tsmart_customfield_id'];
}
$fields['tsmart_customfield_id'] = 0;
} else {
//we do not store customfields inherited by the parent, therefore
$key = array_search($fields['tsmart_customfield_id'], $old_customfield_ids);
if ($key !== false) {
unset($old_customfield_ids[$key]);
}
continue;
}
}
if ($fields['field_type'] == 'C') {
$cM = tmsModel::getModel('custom');
$c = $cM->getCustom($fields['tsmart_custom_id'], '');
if (!empty($c->sCustomId)) {
$sCustId = $c->sCustomId;
$labels = array();
foreach ($fields['selectoptions'] as $k => $option) {
if ($option['voption'] == 'clabels' and !empty($option['clabel'])) {
$labels[$k] = $option['clabel'];
}
}
//for testing
foreach ($fields['options'] as $prodId => $lvalue) {
if ($prodId == $id) {
continue;
}
$db->setQuery('SELECT `tsmart_customfield_id` FROM `#__tsmart_' . $table . '_customfields` as `PC` WHERE `PC`.tsmart_' . $table . '_id ="' . $prodId . '" AND `tsmart_custom_id`="' . $sCustId . '" ');
$strIds = $db->loadColumn();
$i = 0;
foreach ($lvalue as $k => $value) {
if (!empty($labels[$k])) {
$ts = array();
$ts['field_type'] = 'S';
$ts['tsmart_product_id'] = $prodId;
$ts['tsmart_custom_id'] = $sCustId;
if (isset($strIds[$i])) {
$ts['tsmart_customfield_id'] = $strIds[$i];
unset($strIds[$i++]);
}
$ts['customfield_value'] = $value;
$tableCustomfields = $this->getTable($table . '_customfields');
$tableCustomfields->bindChecknStore($ts);
}
}
if (count($strIds) > 0) {
// delete old unused Customfields
$db->setQuery('DELETE FROM `#__tsmart_' . $table . '_customfields` WHERE `tsmart_customfield_id` in ("' . implode('","', $strIds) . '") ');
$db->execute();
}
}
}
}
$fields['tsmart_' . $table . '_id'] = $id;
$tableCustomfields = $this->getTable($table . '_customfields');
$tableCustomfields->setPrimaryKey('tsmart_product_id');
if (!empty($datas['customfield_params'][$key]) and !isset($datas['clone'])) {
if (array_key_exists($key, $datas['customfield_params'])) {
$fields = array_merge((array) $fields, (array) $datas['customfield_params'][$key]);
}
}
$tableCustomfields->_xParams = 'customfield_params';
if (!class_exists('tsmartModelCustom')) {
require VMPATH_ADMIN . DS . 'models' . DS . 'custom.php';
}
tsmartModelCustom::setParameterableByFieldType($tableCustomfields, $fields['field_type'], $fields['custom_element'], $fields['custom_jplugin_id']);
$tableCustomfields->bindChecknStore($fields);
$key = array_search($fields['tsmart_customfield_id'], $old_customfield_ids);
if ($key !== false) {
unset($old_customfield_ids[$key]);
}
}
} else {
vmdebug('storeProductCustomfields nothing to store');
}
vmdebug('Delete $old_customfield_ids', $old_customfield_ids);
if (count($old_customfield_ids)) {
// delete old unused Customfields
$db->setQuery('DELETE FROM `#__tsmart_' . $table . '_customfields` WHERE `tsmart_customfield_id` in ("' . implode('","', $old_customfield_ids) . '") ');
$db->execute();
vmdebug('Deleted $old_customfield_ids', $old_customfield_ids);
}
JPluginHelper::importPlugin('vmcustom');
$dispatcher = JDispatcher::getInstance();
if (isset($datas['customfield_params']) and is_array($datas['customfield_params'])) {
foreach ($datas['customfield_params'] as $key => $plugin_param) {
$dispatcher->trigger('plgVmOnStoreProduct', array($datas, $plugin_param));
}
}
}
function display($tpl = null)
{
// Load the helper(s)
if (!class_exists('VmHTML')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'html.php';
}
if (!class_exists('vmCustomPlugin')) {
require VMPATH_PLUGINLIBS . DS . 'vmcustomplugin.php';
}
$model = tmsModel::getModel('custom');
// TODO Make an Icon for custom
$this->SetViewTitle('PRODUCT_CUSTOM_FIELD');
$layoutName = vRequest::getCmd('layout', 'default');
if ($layoutName == 'edit') {
$this->addStandardEditViewCommands();
$this->customPlugin = '';
$this->custom = $model->getCustom();
$this->fieldTypes = tsmartModelCustom::getCustomTypes();
$this->customfields = tmsModel::getModel('customfields');
//vmdebug('TsmartViewCustom',$this->custom);
JPluginHelper::importPlugin('vmcustom');
$dispatcher = JDispatcher::getInstance();
$retValue = $dispatcher->trigger('plgVmOnDisplayEdit', array($this->custom->tsmart_custom_id, &$this->customPlugin));
$this->SetViewTitle('PRODUCT_CUSTOM_FIELD', $this->custom->custom_title);
$selected = 0;
$this->custom->form = false;
if (!empty($this->custom->custom_jplugin_id)) {
tsmConfig::loadJLang('plg_vmpsplugin', false);
JForm::addFieldPath(VMPATH_ADMIN . DS . 'fields');
$selected = $this->custom->custom_jplugin_id;
// Get the payment XML.
$formFile = vRequest::filterPath(VMPATH_ROOT . DS . 'plugins' . DS . 'vmcustom' . DS . $this->custom->custom_element . DS . $this->custom->custom_element . '.xml');
if (file_exists($formFile)) {
$this->custom->form = JForm::getInstance($this->custom->custom_element, $formFile, array(), false, '//vmconfig | //config[not(//vmconfig)]');
$this->custom->params = new stdClass();
$varsToPush = vmPlugin::getVarsToPushFromForm($this->custom->form);
tsmTable::bindParameterableToSubField($this->custom, $varsToPush);
$this->custom->form->bind($this->custom->getProperties());
}
} else {
$varsToPush = tsmartModelCustom::getVarsToPush($this->custom->field_type);
if (!empty($varsToPush)) {
JForm::addFieldPath(VMPATH_ADMIN . DS . 'fields');
$formString = '<vmconfig>' . chr(10) . '<fields name="params">' . chr(10) . '<fieldset name="extraParams">' . chr(10);
foreach ($varsToPush as $key => $push) {
if ('_' == substr($key, 0, 1)) {
continue;
}
//$default = 0;
$formString .= '<field
name="' . $key . '"
id="' . $key . 'Field"
label="com_tsmart_CUSTOM_PARAM_' . strtoupper($key) . '"
description="com_tsmart_CUSTOM_PARAM_' . strtoupper($key) . '_DESC"
default="' . $push[0] . '"
';
if (isset($push[2])) {
$formString .= 'type="' . $push[2] . '" >';
} else {
if ($push[1] == 'int') {
$formString .= 'type="radio" >
<option value="0">JNO</option>
<option value="1">JYES</option>';
} else {
if ($push[1] == 'string') {
$formString .= 'type="text" >' . chr(10);
}
}
}
$formString .= chr(10) . '</field>' . chr(10);
}
$formString .= '</fieldset>' . chr(10) . '</fields>' . chr(10) . '</vmconfig>';
$this->custom->form = JForm::getInstance($this->custom->field_type, $formString, array(), false, '//vmconfig | //config[not(//vmconfig)]');
$this->custom->params = new stdClass();
tsmTable::bindParameterableToSubField($this->custom, $varsToPush);
$this->custom->form->bind($this->custom->getProperties());
}
}
if (!empty($this->custom->custom_parent_id)) {
$list = ShopFunctions::renderOrderingList('customs', 'custom_title', $this->custom->ordering, 'WHERE custom_parent_id ="' . (int) $this->custom->custom_parent_id . '" ');
$this->ordering = VmHTML::row('raw', 'com_tsmart_ORDERING', $list);
} else {
$this->ordering = '';
$this->addHidden('ordering', $this->custom->ordering);
}
$this->pluginList = self::renderInstalledCustomPlugins($selected);
} else {
JToolBarHelper::custom('createClone', 'copy', 'copy', tsmText::_('com_tsmart_CLONE'), true);
JToolBarHelper::custom('toggle.admin_only.1', 'publish', '', tsmText::_('com_tsmart_TOGGLE_ADMIN'), true);
JToolBarHelper::custom('toggle.admin_only.0', 'unpublish', '', tsmText::_('com_tsmart_TOGGLE_ADMIN'), true);
JToolBarHelper::custom('toggle.is_hidden.1', 'publish', '', tsmText::_('com_tsmart_TOGGLE_HIDDEN'), true);
JToolBarHelper::custom('toggle.is_hidden.0', 'unpublish', '', tsmText::_('com_tsmart_TOGGLE_HIDDEN'), true);
$this->addStandardDefaultViewCommands();
$this->addStandardDefaultViewLists($model);
$this->custom_parent_id = vRequest::getInt('custom_parent_id', false);
$this->customs = $model->getCustoms($this->custom_parent_id, vRequest::getCmd('keyword'));
$this->pagination = $model->getPagination();
$model->custom_parent_id = $this->custom_parent_id;
$this->customsSelect = $model->displayCustomSelection();
}
parent::display($tpl);
}
