/**
* Method to get the field input markup. Use as name the view of the desired layout list + "layout".
* For example <field name="categorylayout" for all layouts of hte category view.
*
* @author Max Milbers
* @return string The field input markup.
* @since 2.0.24a
*/
function getInput()
{
VmConfig::loadJLang('com_virtuemart');
$view = substr($this->fieldname, 0, -6);
$vmLayoutList = VirtueMartModelConfig::getLayoutList($view);
$html = JHtml::_('Select.genericlist', $vmLayoutList, $this->name, 'size=1 width=200', 'value', 'text', array($this->value));
return $html;
}
/**
* Method to get the field input markup. Use as name the view of the desired layout list + "layout".
* For example <field name="categorylayout" for all layouts of hte category view.
*
* @author Max Milbers
* @return string The field input markup.
* @since 2.0.24a
*/
function getInput()
{
$lang = JFactory::getLanguage();
$lang->load('com_virtuemart', JPATH_ADMINISTRATOR);
$view = substr($this->fieldname, 0, -6);
$vmLayoutList = VirtueMartModelConfig::getLayoutList($view);
$html = JHTML::_('Select.genericlist', $vmLayoutList, $this->name, 'size=1 width=200', 'value', 'text', array($this->value));
return $html;
}
function display($tpl = null)
{
$this->loadHelper('html');
$model = VmModel::getModel();
$layoutName = $this->getLayout();
if ($layoutName == 'edit') {
$category = $model->getCategory('', false);
if (isset($category->category_name)) {
$name = $category->category_name;
} else {
$name = '';
}
$this->SetViewTitle('CATEGORY', $name);
$model->addImages($category);
if ($category->virtuemart_category_id > 1) {
$relationInfo = $model->getRelationInfo($category->virtuemart_category_id);
$this->assignRef('relationInfo', $relationInfo);
}
$parent = $model->getParentCategory($category->virtuemart_category_id);
$this->assignRef('parent', $parent);
if (!class_exists('ShopFunctions')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'shopfunctions.php';
}
$templateList = ShopFunctions::renderTemplateList(JText::_('COM_VIRTUEMART_CATEGORY_TEMPLATE_DEFAULT'));
$this->assignRef('jTemplateList', $templateList);
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . DS . 'models' . DS . 'config.php';
}
$categoryLayoutList = VirtueMartModelConfig::getLayoutList('category');
$this->assignRef('categoryLayouts', $categoryLayoutList);
$productLayouts = VirtueMartModelConfig::getLayoutList('productdetails');
$this->assignRef('productLayouts', $productLayouts);
//Nice fix by Joe, the 4. param prevents setting an category itself as child
$categorylist = ShopFunctions::categoryListTree(array($parent->virtuemart_category_id), 0, 0, (array) $category->virtuemart_category_id);
$this->loadHelper('permissions');
$perms = Permissions::getInstance();
$this->assignRef('perms', $perms);
if (Vmconfig::get('multix', 'none') !== 'none') {
$vendorList = ShopFunctions::renderVendorList($category->virtuemart_vendor_id, false);
$this->assignRef('vendorList', $vendorList);
}
$this->assignRef('category', $category);
$this->assignRef('categorylist', $categorylist);
$this->addStandardEditViewCommands($category->virtuemart_category_id, $category);
} else {
$this->SetViewTitle('CATEGORY_S');
$keyWord = '';
$this->assignRef('model', $model);
$this->addStandardDefaultViewCommands();
$this->addStandardDefaultViewLists($model, 'category_name');
$categories = $model->getCategoryTree(0, 0, false, $this->lists['search']);
$this->assignRef('categories', $categories);
$pagination = $model->getPagination();
$this->assignRef('pagination', $pagination);
}
parent::display($tpl);
}
function display($tpl = null)
{
// Get the task
$task = JRequest::getWord('task', $this->getLayout());
vmdebug('VirtuemartViewProduct ' . $task);
$this->task = $task;
// Load helpers
$this->loadHelper('currencydisplay');
$this->loadHelper('html');
$this->loadHelper('image');
$model = VmModel::getModel();
// Handle any publish/unpublish
switch ($task) {
case 'add':
case 'edit':
VmConfig::loadJLang('com_virtuemart_orders', TRUE);
VmConfig::loadJLang('com_virtuemart_shoppers', TRUE);
$this->jsonPath = JFactory::getApplication()->isSite() ? juri::root() : '';
$virtuemart_product_id = JRequest::getVar('virtuemart_product_id', array());
if (is_array($virtuemart_product_id) && count($virtuemart_product_id) > 0) {
$virtuemart_product_id = (int) $virtuemart_product_id[0];
} else {
$virtuemart_product_id = (int) $virtuemart_product_id;
}
$product = $model->getProductSingle($virtuemart_product_id, false);
$product_parent = $model->getProductParent($product->product_parent_id);
$mf_model = VmModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown($product->virtuemart_manufacturer_id);
$this->manufacturers = $manufacturers;
// set category in front edit link
if ($task == 'add') {
if ($category_id = jRequest::getInt('virtuemart_category_id', 0)) {
$product->categories = array($category_id);
}
}
// Get the category tree
if (isset($product->categories)) {
$this->category_tree = ShopFunctions::categoryListTree($product->categories);
} else {
$this->category_tree = ShopFunctions::categoryListTree();
}
//Get the shoppergoup list - Cleanshooter Custom Shopper Visibility
if (isset($product->shoppergroups)) {
$this->shoppergroupList = ShopFunctions::renderShopperGroupList($product->shoppergroups);
} else {
$this->shoppergroupList = '';
}
// Load the product price
$this->loadHelper('calculationh');
$product_childIds = $model->getProductChildIds($virtuemart_product_id);
$product_childs = array();
foreach ($product_childIds as $id) {
$product_childs[] = $model->getProductSingle($id, false);
}
$this->assignRef('product_childs', $product_childs);
JLoader::register('VirtueMartModelConfig', JPATH_VM_ADMINISTRATOR . '/models/config.php');
$this->productLayouts = VirtueMartModelConfig::getLayoutList('productdetails', $product->layout);
// Load Images
$model->addImages($product);
if (is_Dir(VmConfig::get('vmtemplate') . DS . 'images' . DS . 'availability' . DS)) {
$imagePath = VmConfig::get('vmtemplate') . '/images/availability/';
} else {
$imagePath = '/components/com_virtuemart/assets/images/availability/';
}
$this->imagePath = $imagePath;
// Load the vendors
$vendor_model = VmModel::getModel('vendor');
if (Vmconfig::get('multix', 'none') !== 'none') {
if ($task == 'add') {
$vendor_id = $this->adminVendor;
} else {
$vendor_id = $product->virtuemart_vendor_id;
}
$lists['vendors'] = Shopfunctions::renderVendorList($vendor_id);
}
// Load the currencies
$currency_model = VmModel::getModel('currency');
$this->loadHelper('permissions');
$vendor_model->setId(Permissions::getInstance()->isSuperVendor());
$vendor = $vendor_model->getVendor();
if (empty($product->product_currency)) {
$product->product_currency = $vendor->vendor_currency;
}
//STUDIO42 fix for currency, old method set 2 time same currency symbol
// TODO verify all others
$currencyModel = VmModel::getModel('currency');
$currencyModel->setId($vendor->vendor_currency);
$currency = $currencyModel->getData();
$this->vendor_currency = $currency->currency_symbol;
$currencyModel->setId($product->product_currency);
$currency = $currencyModel->getData();
$this->product_currency = $currency->currency_symbol;
if (count($manufacturers) > 0) {
$lists['manufacturers'] = JHTML::_('select.genericlist', $manufacturers, 'virtuemart_manufacturer_id', 'class="inputbox"', 'value', 'text', $product->virtuemart_manufacturer_id);
}
$lists['product_weight_uom'] = ShopFunctions::renderWeightUnitList('product_weight_uom', $task == 'add' ? VmConfig::get('weight_unit_default') : $product->product_weight_uom);
$lists['product_iso_uom'] = ShopFunctions::renderUnitIsoList('product_unit', $task == 'add' ? VmConfig::get('weight_unit_default') : $product->product_unit);
$lists['product_lwh_uom'] = ShopFunctions::renderLWHUnitList('product_lwh_uom', $task == 'add' ? VmConfig::get('lwh_unit_default') : $product->product_lwh_uom);
if (empty($product->product_available_date)) {
$product->product_available_date = date("Y-m-d");
}
$waitinglistmodel = VmModel::getModel('waitinglist');
/* Load waiting list */
if ($product->virtuemart_product_id) {
//$waitinglist = $this->get('waitingusers', 'waitinglist');
$waitinglist = $waitinglistmodel->getWaitingusers($product->virtuemart_product_id);
$this->assignRef('waitinglist', $waitinglist);
}
$productShoppers = $model->getProductShoppersByStatus($product->virtuemart_product_id, array('S'));
$this->assignRef('productShoppers', $productShoppers);
$orderstatusModel = VmModel::getModel('orderstatus');
$lists['OrderStatus'] = $orderstatusModel->renderOSList(array(), 'order_status', TRUE);
$field_model = VmModel::getModel('customfields');
$fieldTypes = $field_model->getField_types();
$this->assignRef('fieldTypes', $fieldTypes);
/* Load product types lists */
if ($customsList = $field_model->getCustomsList()) {
$emptyOption = JHTML::_('select.option', '', '- ' . JText::_('COM_VIRTUEMART_LIST_EMPTY_OPTION') . ' :', 'value', 'text');
array_unshift($customsList, $emptyOption);
$customlist = JHTML::_('select.genericlist', $customsList, 'customlist');
if ($task == "add") {
if ($customfieldsDefault = $this->getBLankCustomfields()) {
$product->customfields = $customfieldsDefault;
// var_dump( $customfieldsDefault);jexit();
}
}
}
$this->assignRef('customsList', $customlist);
$ChildCustomRelation = $field_model->getProductChildCustomRelation();
$this->assignRef('ChildCustomRelation', $ChildCustomRelation);
if ($product->product_parent_id > 0) {
$parentRelation = $field_model->getProductParentRelation($product->virtuemart_product_id);
$this->assignRef('parentRelation', $parentRelation);
// Set up labels
$info_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_INFO_LBL');
$status_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_STATUS_LBL');
$dim_weight_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_DIM_WEIGHT_LBL');
$images_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_IMAGES_LBL');
$delete_message = JText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_ITEM_MSG');
} else {
if ($task == 'add') {
$action = JText::_('COM_VIRTUEMART_PRODUCT_FORM_NEW_PRODUCT_LBL');
} else {
$action = JText::_('COM_VIRTUEMART_PRODUCT_FORM_UPDATE_ITEM_LBL');
}
$info_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_INFO_LBL');
$status_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_STATUS_LBL');
$dim_weight_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_DIM_WEIGHT_LBL');
$images_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_IMAGES_LBL');
$delete_message = JText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_PRODUCT_MSG');
}
$this->assignRef('product', $product);
$product_empty_price = array('virtuemart_product_price_id' => 0, 'virtuemart_product_id' => $virtuemart_product_id, 'virtuemart_shoppergroup_id' => NULL, 'product_price' => NULL, 'override' => NULL, 'product_override_price' => NULL, 'product_tax_id' => NULL, 'product_discount_id' => NULL, 'product_currency' => $vendor->vendor_currency, 'product_price_publish_up' => NULL, 'product_price_publish_down' => NULL, 'price_quantity_start' => NULL, 'price_quantity_end' => NULL);
$this->assignRef('product_empty_price', $product_empty_price);
$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 = '&virtuemart_category_id=' . $product->canonCatLink;
} else {
$canonLink = '';
}
if (!empty($product->virtuemart_product_id)) {
$text = '<a href="' . juri::root() . 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . $canonLink . '" target="_blank" >' . $product->product_name . $sku . '<span class="vm2-modallink"></span></a>';
} else {
$text = $product->product_name . $sku;
}
$this->SetViewTitle('PRODUCT', $text);
//JToolBarHelper::custom('sentproductemailtocustomer', 'email_32', 'email_32', 'COM_VIRTUEMART_PRODUCT_EMAILTOSHOPPER' ,false);
$this->addStandardEditViewCommands($product->virtuemart_product_id);
break;
case 'massxref_cats':
case 'massxref_cats_exe':
//TODO test if path is ok addpath is now in the constructor
$this->addTemplatePath(JPATH_VM_ADMINISTRATOR . '/views' . DS . 'category' . DS . 'tmpl');
$this->SetViewTitle('PRODUCT_MASSXREF');
// $this->setLayout('massxref');
$this->loadHelper('permissions');
$this->perms = Permissions::getInstance();
$this->showVendors = $this->perms->check('admin');
$keyWord = '';
$catmodel = VmModel::getModel('category');
$this->catmodel = $catmodel;
//$this->addStandardDefaultViewCommands();
$this->addStandardDefaultViewLists($catmodel, 'category_name');
$this->categories = $catmodel->getCategoryTree(0, 0, false, $this->lists['search']);
$this->pagination = $catmodel->getPagination();
// restore icon is good but not the word
JToolBarHelper::custom('display', 'restore', 'restore', JText::_('JTOOLBAR_BACK'), false);
JToolBarHelper::custom('massxref_cats_exe', 'assign', 'assign', JText::_('COM_VIRTUEMART_MASS_REPLACE'), false);
JToolBarHelper::custom('massxref_cats_add', 'new', 'new', JText::_('COM_VIRTUEMART_MASS_ADD'), true);
break;
case 'massxref_sgrps':
case 'massxref_sgrps_exe':
$this->SetViewTitle('PRODUCT_MASSXREF');
//TODO test if path is ok addpath is now in the constructor
$this->addTemplatePath(JPATH_VM_ADMINISTRATOR . '/views' . DS . 'shoppergroup' . DS . 'tmpl');
$this->loadHelper('permissions');
$this->perms = Permissions::getInstance();
$this->showVendors = $this->perms->check('admin');
$sgrpmodel = VmModel::getModel('shoppergroup');
$this->addStandardDefaultViewLists($sgrpmodel);
$this->shoppergroups = $sgrpmodel->getShopperGroups(false, true);
$this->pagination = $sgrpmodel->getPagination();
JToolBarHelper::custom('massxref_sgrps_exe', 'groups-add', 'new', JText::_('COM_VIRTUEMART_PRODUCT_XREF_SGRPS_EXE'), false);
break;
default:
if ($product_parent_id = JRequest::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&virtuemart_product_id=' . $product_parent->virtuemart_product_id . '&option=com_virtuemart'), $product_parent->product_name, array('class' => 'hasTooltip', 'title' => JText::_('COM_VIRTUEMART_EDIT_PARENT') . ' ' . $product_parent->product_name));
$msg = JText::_('COM_VIRTUEMART_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->db = JFactory::getDBO();
$this->loadHelper('permissions');
$this->SetViewTitle($title, $msg);
$this->addStandardDefaultViewLists($model, 'created_on', 'DESC', 'filter_product');
$vendor_id = $this->adminVendor;
if ($vendor_id == 1) {
$vendor_id = null;
}
// fix ???
$catid = JRequest::getInt('uctlist = ', 0);
/* Get the list of products */
$productlist = $model->getProductListing(false, false, false, false, true, true, $catid, $vendor_id);
//The pagination must now always set AFTER the model load the listing
$this->pagination = $model->getPagination();
/* Get the category tree */
$categoryId = $model->virtuemart_category_id;
//OSP switched to filter in model, was JRequest::getInt('virtuemart_category_id');
$this->category_tree = ShopFunctions::categoryListTree(array($categoryId));
/* Load the product price */
$this->loadHelper('calculationh');
$vendor_model = VmModel::getModel('vendor');
$productreviews = VmModel::getModel('ratings');
foreach ($productlist as $virtuemart_product_id => $product) {
if (isset($product->virtuemart_media_id)) {
$product->mediaitems = count($product->virtuemart_media_id);
} else {
$product->mediaitems = 'none';
}
$product->reviews = $productreviews->countReviewsForProduct($product->virtuemart_product_id);
$vendor_model->setId($product->virtuemart_vendor_id);
$vendor = $vendor_model->getVendor();
$currencyDisplay = CurrencyDisplay::getInstance($vendor->vendor_currency, $vendor->virtuemart_vendor_id);
if (!empty($product->product_price) && !empty($product->product_currency)) {
$product->product_price_display = $currencyDisplay->priceDisplay($product->product_price, (int) $product->product_currency, 1, true);
}
/* Write the first 5 categories in the list */
$product->categoriesList = shopfunctions::renderGuiList('virtuemart_category_id', '#__virtuemart_product_categories', 'virtuemart_product_id', $product->virtuemart_product_id, 'category_name', '#__virtuemart_categories', 'virtuemart_category_id', 'category');
}
$mf_model = VmModel::getModel('manufacturer');
$this->manufacturers = $mf_model->getManufacturerDropdown();
/* add Search filter in lists*/
/* Search type */
$options = array('' => JText::_('COM_VIRTUEMART_LIST_EMPTY_OPTION'), 'parent' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_PARENT_PRODUCT'), 'product' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRODUCT'), 'price' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRICE'), 'withoutprice' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_WITHOUTPRICE'));
$this->lists['search_type'] = VmHTML::selectList('search_type', JRequest::getVar('search_type'), $options, 1, '', 'onchange="Joomla.ajaxSearch(this); return false;"', 'input-medium');
/* Search order */
$options = array('bf' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_BEFORE'), 'af' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_AFTER'));
$this->lists['search_order'] = VmHTML::selectList('search_order', JRequest::getVar('search_order'), $options, 1, '', '', 'input-small');
// Toolbar
//JToolBarHelper::save('sentproductemailtoshoppers', JText::_('COM_VIRTUEMART_PRODUCT_EMAILTOSHOPPERS'));
JToolBarHelper::custom('massxref_cats', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_XREF_CAT'), true);
JToolBarHelper::custom('massxref_sgrps', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_XREF_SGRPS'), true);
JToolBarHelper::custom('createchild', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_CHILD'), true);
JToolBarHelper::custom('cloneproduct', 'copy', 'copy', JText::_('COM_VIRTUEMART_PRODUCT_CLONE'), true);
JToolBarHelper::custom('addrating', 'star-2', '', JText::_('COM_VIRTUEMART_ADD_RATING'), true);
$this->addStandardDefaultViewCommands();
$this->productlist = $productlist;
$this->virtuemart_category_id = $categoryId;
$this->model = $model;
break;
}
parent::display($tpl);
}
/**
* Loads the configuration and works as singleton therefore called static. The call using the program cache
* is 10 times faster then taking from the session. The session is still approx. 30 times faster then using the file.
* The db is 10 times slower then the session.
*
* Performance:
*
* Fastest is
* Program Cache: 1.5974044799805E-5
* Session Cache: 0.00016094612121582
*
* First config db load: 0.00052118301391602
* Parsed and in session: 0.001554012298584
*
* After install from file: 0.0040450096130371
* Parsed and in session: 0.0051419734954834
*
*
* Functions tests if already loaded in program cache, session cache, database and at last the file.
*
* Load the configuration values from the database into a session variable.
* This step is done to prevent accessing the database for every configuration variable lookup.
*
* @author Max Milbers
* @param $force boolean Forces the function to load the config from the db
*/
public static function loadConfig($force = FALSE, $fresh = FALSE)
{
if ($fresh) {
return self::$_jpConfig = new VmConfig();
}
vmSetStartTime('loadConfig');
if (!$force) {
if (!empty(self::$_jpConfig) && !empty(self::$_jpConfig->_params)) {
return self::$_jpConfig;
}
}
self::$_jpConfig = new VmConfig();
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . DS . 'models' . DS . 'config.php';
}
$configTable = VirtueMartModelConfig::checkConfigTableExists();
$db = JFactory::getDBO();
$app = JFactory::getApplication();
$freshInstall = vRequest::getInt('install', false);
if (empty($configTable) or $freshInstall) {
if (!$freshInstall) {
$installed = VirtueMartModelConfig::checkVirtuemartInstalled();
if (!$installed) {
$jlang = JFactory::getLanguage();
$selectedLang = $jlang->getTag();
if (empty($selectedLang)) {
$selectedLang = $jlang->setLanguage($selectedLang);
}
$msg = '';
$q = 'SELECT `element` FROM `#__extensions` WHERE type = "language" and enabled = "1"';
$db->setQuery($q);
$knownLangs = $db->loadColumn();
//vmdebug('Selected language '.$selectedLang.' $knownLangs ',$knownLangs);
if ($app->isAdmin() and !in_array($selectedLang, $knownLangs)) {
$link = 'index.php?option=com_installer&view=languages';
$msg = 'Install your selected language <b>' . $selectedLang . '</b> first in <a href="' . $link . '">joomla language manager</a>, just select then the component VirtueMart under menu "component", to proceed with the installation ';
$app->enqueueMessage($msg);
}
//else {
if ($app->isSite()) {
$link = 'index.php?option=com_virtuemart';
} else {
$link = 'index.php?option=com_virtuemart&view=updatesmigration&install=1';
$msg = 'Install Virtuemart first, click on the menu component and select VirtueMart';
}
if ($app->isSite()) {
$link = JURI::root(true) . '/administrator/' . $link;
}
$app->redirect($link, $msg);
//}
}
if ($installed) {
self::$_jpConfig->installVMconfig();
}
} else {
self::$_jpConfig->installVMconfig($freshInstall);
}
}
$install = 'no';
if (empty(self::$_jpConfig->_raw)) {
$query = ' SELECT `config` FROM `#__virtuemart_configs` WHERE `virtuemart_config_id` = "1";';
$db->setQuery($query);
self::$_jpConfig->_raw = $db->loadResult();
if (empty(self::$_jpConfig->_raw)) {
if (self::installVMconfig($freshInstall)) {
$install = 'yes';
$db->setQuery($query);
self::$_jpConfig->_raw = $db->loadResult();
self::$_jpConfig->_params = NULL;
} else {
$app->enqueueMessage('Error loading configuration file', 'Error loading configuration file, please contact the storeowner');
}
}
}
$i = 0;
$pair = array();
if (!empty(self::$_jpConfig->_raw)) {
$config = explode('|', self::$_jpConfig->_raw);
foreach ($config as $item) {
$item = explode('=', $item);
if (!empty($item[1])) {
// if($item[0]!=='offline_message' && $item[0]!=='dateformat' ){
if ($item[0] !== 'offline_message') {
try {
$value = @unserialize($item[1]);
if ($value === FALSE) {
$app->enqueueMessage('Exception in loadConfig for unserialize ' . $item[0] . ' ' . $item[1]);
$uri = JFactory::getURI();
$configlink = $uri->root() . 'administrator/index.php?option=com_virtuemart&view=config';
$app->enqueueMessage('To avoid this message, enter your virtuemart <a href="' . $configlink . '">config</a> and just save it one time');
} else {
$pair[$item[0]] = $value;
}
} catch (Exception $e) {
vmdebug('Exception in loadConfig for unserialize ' . $e->getMessage(), $item);
}
} else {
$pair[$item[0]] = unserialize(base64_decode($item[1]));
}
} else {
$pair[$item[0]] = '';
}
}
// $pair['sctime'] = microtime(true);
self::$_jpConfig->_params = $pair;
self::$_jpConfig->_params['sctime'] = microtime(TRUE);
//self::$_jpConfig->set('sctime',microtime(TRUE));
//self::setdbLanguageTag();
self::$_jpConfig->_params['vmlang'] = self::setdbLanguageTag();
vmTime('loadConfig db ' . $install, 'loadConfig');
// try plugins
if ($app->isSite()) {
if (!class_exists('VmImage')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'image.php';
}
JPluginHelper::importPlugin('vmuserfield');
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger('plgVmInitialise', array());
}
return self::$_jpConfig;
}
$app->enqueueMessage('Attention config is empty');
return self::$_jpConfig;
}
/**
* This function resets the flag in the config that dangerous tools can't be executed anylonger
* This is a security feature
*
* @author Max Milbers
*/
function setDangerousToolsOff()
{
if (!class_exists('VirtueMartModelConfig')) {
require VMPATH_ADMIN . '/models/config.php';
}
$res = VirtueMartModelConfig::checkConfigTableExists();
if (!empty($res)) {
$model = $this->getModel('config');
$model->setDangerousToolsOff();
}
}
/**
* Post-process method (e.g. footer HTML, redirect, etc)
*
* @param string Process type (i.e. install, uninstall, update)
* @param object JInstallerComponent parent
*/
public function postflight($type, $parent = null)
{
$_REQUEST['install'] = 0;
if ($type != 'uninstall') {
$this->loadVm();
//fix joomla BE menu
$model = VmModel::getModel('updatesmigration');
// VmConfig::loadConfig(true);
if (!class_exists('VirtueMartModelConfig')) {
require VMPATH_ADMIN . '/models/config.php';
}
$res = VirtueMartModelConfig::checkConfigTableExists();
if (!empty($res)) {
vRequest::setVar(JSession::getFormToken(), '1');
$config = VmModel::getModel('config');
$config->setDangerousToolsOff();
}
}
return true;
}
function display($tpl = null)
{
$this->loadHelper('html');
$this->loadHelper('permissions');
if (!class_exists('shopFunctionsF')) {
require JPATH_VM_SITE . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
$model = VmModel::getModel();
$layoutName = $this->getLayout();
$task = JRequest::getWord('task', $layoutName);
$this->task = $task;
$this->perms = Permissions::getInstance();
// to add in vmview ?
$multivendor = Vmconfig::get('multix', 'none');
$this->multiX = $multivendor !== 'none' && $multivendor != '' ? true : false;
if ($layoutName == 'edit') {
$this->loadHelper('shopfunctions');
$category = $model->getCategory('', false);
if (isset($category->category_name)) {
$name = $category->category_name;
} else {
$name = '';
}
$this->SetViewTitle('CATEGORY', $name);
$model->addImages($category);
if ($category->virtuemart_category_id) {
$this->relationInfo = $model->getRelationInfo($category->virtuemart_category_id);
}
$this->parent = $model->getParentCategory($category->virtuemart_category_id);
$this->jTemplateList = ShopFunctions::renderTemplateList(JText::_('COM_VIRTUEMART_CATEGORY_TEMPLATE_DEFAULT'));
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . '/models' . DS . 'config.php';
}
$this->productLayouts = VirtueMartModelConfig::getLayoutList('productdetails', $category->category_product_layout, 'category_product_layout');
$this->categoryLayouts = VirtueMartModelConfig::getLayoutList('category', $category->category_layout, 'categorylayout');
// front autoset parent category
if (!$category->virtuemart_category_id) {
$this->parent->virtuemart_category_id = jRequest::getInt('category_parent_id', 0);
}
//Nice fix by Joe, the 4. param prevents setting an category itself as child
// Note Studio42, the fix is not suffisant, you can set the category in a children and get infinit loop in router for eg.
$this->categorylist = ShopFunctions::categoryListTree(array($this->parent->virtuemart_category_id), 0, 0, (array) $category->virtuemart_category_id);
if (Vmconfig::get('multix', 'none') !== 'none') {
$this->vendorList = ShopFunctions::renderVendorList($category->virtuemart_vendor_id, false);
}
$this->category = $category;
$this->addStandardEditViewCommands($category->virtuemart_category_id, $category);
} else {
$category_id = JRequest::getInt('filter_category_id');
if (JRequest::getWord('format', '') === 'raw') {
$tpl = 'results';
} else {
$this->SetViewTitle('CATEGORY_S');
$this->addStandardDefaultViewCommands();
$this->categorylist = ShopFunctions::categoryListTreeLoop((array) $category_id, 0, 0);
if ($this->multiX && $this->adminVendor == 1) {
JToolBarHelper::custom('toggle.shared.1', 'publish', 'yes', JText::_('COM_VIRTUEMART_SHARED'), true);
JToolBarHelper::custom('toggle.shared.0', 'unpublish', 'no', JText::_('COM_VIRTUEMART_SHARED'), true);
}
}
$this->catmodel = $model;
$this->addStandardDefaultViewLists($model, 'category_name');
$this->categories = $model->getCategoryTree($category_id, 0, false, $this->lists['search']);
$this->pagination = $model->getPagination();
//we need a function of the FE shopfunctions helper to cut the category descriptions
jimport('joomla.filter.output');
}
parent::display($tpl);
if ($tpl === 'results') {
echo $this->AjaxScripts();
}
}
/**
* Dangerous tools get disabled after execution an operation which needed that rights.
* This is the function actually doing it.
*
* @author Max Milbers
*/
function setDangerousToolsOff()
{
$dangerousTools = VirtueMartModelConfig::readConfigFile(true);
if ($dangerousTools) {
$uri = JFactory::getURI();
$link = $uri->root() . 'administrator/index.php?option=com_virtuemart&view=config';
$lang = vmText::sprintf('COM_VIRTUEMART_SYSTEM_DANGEROUS_TOOL_STILL_ENABLED', vmText::_('COM_VIRTUEMART_ADMIN_CFG_DANGEROUS_TOOLS'), $link);
VmInfo($lang);
} else {
if (self::checkConfigTableExists()) {
$data['dangeroustools'] = 0;
$data['virtuemart_config_id'] = 1;
$this->store($data);
}
}
}
function display($tpl = null)
{
// Get the task
$task = JRequest::getWord('task');
// Load helpers
$this->loadHelper('currencydisplay');
$this->loadHelper('html');
$this->loadHelper('image');
//$category_model = VmModel::getModel('category');
$model = VmModel::getModel();
// Handle any publish/unpublish
switch ($task) {
case 'add':
case 'edit':
//this was in the controller for the edit tasks, I dont know if it is still needed,
$this->addTemplatePath(JPATH_COMPONENT_ADMINISTRATOR . DS . 'views' . DS . 'product' . DS . 'tmpl');
$virtuemart_product_id = JRequest::getVar('virtuemart_product_id', array());
if (is_array($virtuemart_product_id) && count($virtuemart_product_id) > 0) {
$virtuemart_product_id = (int) $virtuemart_product_id[0];
} else {
$virtuemart_product_id = (int) $virtuemart_product_id;
}
$product = $model->getProductSingle($virtuemart_product_id, false);
$product_parent = $model->getProductParent($product->product_parent_id);
$mf_model = VmModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown($product->virtuemart_manufacturer_id);
$this->assignRef('manufacturers', $manufacturers);
// Get the category tree
if (isset($product->categories)) {
$category_tree = ShopFunctions::categoryListTree($product->categories);
} else {
$category_tree = ShopFunctions::categoryListTree();
}
$this->assignRef('category_tree', $category_tree);
//Get the shoppergoup list - Cleanshooter Custom Shopper Visibility
if (isset($product->shoppergroups)) {
$shoppergroupList = ShopFunctions::renderShopperGroupList($product->shoppergroups, true);
}
$this->assignRef('shoppergroupList', $shoppergroupList);
// Load the product price
if (!class_exists('calculationHelper')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'calculationh.php';
}
$calculator = calculationHelper::getInstance();
$product->prices = $calculator->getProductPrices($product);
$product_childIds = $model->getProductChildIds($virtuemart_product_id);
$product_childs = array();
foreach ($product_childIds as $id) {
$product_childs[] = $model->getProductSingle($id, false);
}
$this->assignRef('product_childs', $product_childs);
$DBTax = '';
//JText::_('COM_VIRTUEMART_RULES_EFFECTING') ;
foreach ($calculator->rules['DBTax'] as $rule) {
$DBTax .= $rule['calc_name'] . '<br />';
}
$this->assignRef('DBTaxRules', $DBTax);
$tax = '';
//JText::_('COM_VIRTUEMART_TAX_EFFECTING').'<br />';
foreach ($calculator->rules['Tax'] as $rule) {
$tax .= $rule['calc_name'] . '<br />';
}
foreach ($calculator->rules['VatTax'] as $rule) {
$tax .= $rule['calc_name'] . '<br />';
}
$this->assignRef('taxRules', $tax);
$DATax = '';
//JText::_('COM_VIRTUEMART_RULES_EFFECTING');
foreach ($calculator->rules['DATax'] as $rule) {
$DATax .= $rule['calc_name'] . '<br />';
}
$this->assignRef('DATaxRules', $DATax);
// $this->assignRef('override', $calculator->override);
// $this->assignRef('product_override_price', $calculator->product_override_price);
if (!isset($product->product_tax_id)) {
$product->product_tax_id = 0;
}
$lists['taxrates'] = ShopFunctions::renderTaxList($product->product_tax_id, 'product_tax_id');
if (!isset($product->product_discount_id)) {
$product->product_discount_id = 0;
}
$lists['discounts'] = $this->renderDiscountList($product->product_discount_id);
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . DS . 'models' . DS . 'config.php';
}
$productLayouts = VirtueMartModelConfig::getLayoutList('productdetails');
$this->assignRef('productLayouts', $productLayouts);
// Load Images
$model->addImages($product);
if (is_Dir(VmConfig::get('vmtemplate') . DS . 'images' . DS . 'availability' . DS)) {
$imagePath = VmConfig::get('vmtemplate') . '/images/availability/';
} else {
$imagePath = '/components/com_virtuemart/assets/images/availability/';
}
$this->assignRef('imagePath', $imagePath);
// Load the vendors
$vendor_model = VmModel::getModel('vendor');
// $vendors = $vendor_model->getVendors();
// $lists['vendors'] = JHTML::_('select.genericlist', $vendors, 'virtuemart_vendor_id', '', 'virtuemart_vendor_id', 'vendor_name', $product->virtuemart_vendor_id);
if (Vmconfig::get('multix', 'none') !== 'none') {
$lists['vendors'] = Shopfunctions::renderVendorList($product->virtuemart_vendor_id);
}
// Load the currencies
$currency_model = VmModel::getModel('currency');
$vendor_model->setId(1);
$vendor = $vendor_model->getVendor();
if (empty($product->product_currency)) {
$product->product_currency = $vendor->vendor_currency;
}
$currencies = JHTML::_('select.genericlist', $currency_model->getCurrencies(), 'product_currency', '', 'virtuemart_currency_id', 'currency_name', $product->product_currency);
$currency = $currency_model->getCurrency($product->product_currency);
$this->assignRef('product_currency', $currency->currency_symbol);
$currency = $currency_model->getCurrency($vendor->vendor_currency);
$this->assignRef('vendor_currency', $currency->currency_symbol);
if (count($manufacturers) > 0) {
$lists['manufacturers'] = JHTML::_('select.genericlist', $manufacturers, 'virtuemart_manufacturer_id', 'class="inputbox"', 'value', 'text', $product->virtuemart_manufacturer_id);
}
$lists['product_weight_uom'] = ShopFunctions::renderWeightUnitList('product_weight_uom', $task == 'add' ? VmConfig::get('weight_unit_default') : $product->product_weight_uom);
$lists['product_lwh_uom'] = ShopFunctions::renderLWHUnitList('product_lwh_uom', $task == 'add' ? VmConfig::get('lwh_unit_default') : $product->product_lwh_uom);
if (empty($product->product_available_date)) {
$product->product_available_date = date("Y-m-d");
}
$waitinglistmodel = VmModel::getModel('waitinglist');
/* Load waiting list */
if ($product->virtuemart_product_id) {
//$waitinglist = $this->get('waitingusers', 'waitinglist');
$waitinglist = $waitinglistmodel->getWaitingusers($product->virtuemart_product_id);
$this->assignRef('waitinglist', $waitinglist);
}
$bookedUsers = $waitinglistmodel->getProductShoppersByStatus($product->virtuemart_product_id, array('S'));
$this->assignRef('customers', $bookedUsers);
$orderstatusModel = VmModel::getModel('orderstatus');
$lists['OrderStatus'] = $orderstatusModel->renderOrderStatusList(true, array('S'));
$field_model = VmModel::getModel('customfields');
$fieldTypes = $field_model->getField_types();
$this->assignRef('fieldTypes', $fieldTypes);
/* Load product types lists */
$customsList = $field_model->getCustomsList();
$this->assignRef('customsList', JHTML::_('select.genericlist', $customsList, 'customlist'));
$ChildCustomRelation = $field_model->getProductChildCustomRelation();
$this->assignRef('ChildCustomRelation', $ChildCustomRelation);
/* Set up labels */
if ($product->product_parent_id > 0) {
$info_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_INFO_LBL');
$status_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_STATUS_LBL');
$dim_weight_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_DIM_WEIGHT_LBL');
$images_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_IMAGES_LBL');
$delete_message = JText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_ITEM_MSG');
} else {
if ($task == 'add') {
$action = JText::_('COM_VIRTUEMART_PRODUCT_FORM_NEW_PRODUCT_LBL');
} else {
$action = JText::_('COM_VIRTUEMART_PRODUCT_FORM_UPDATE_ITEM_LBL');
}
$info_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_INFO_LBL');
$status_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_STATUS_LBL');
$dim_weight_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_DIM_WEIGHT_LBL');
$images_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_IMAGES_LBL');
$delete_message = JText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_PRODUCT_MSG');
}
$config = JFactory::getConfig();
$tzoffset = $config->getValue('config.offset');
$this->assignRef('tzoffset', $tzoffset);
// Assign the values
$this->assignRef('pane', $pane);
$this->assignRef('editor', $editor);
$this->assignRef('product', $product);
$this->assignRef('currencies', $currencies);
//no need moved to top $this->assignRef('manufacturers', $manufacturers);
$this->assignRef('related_products', $related_products);
$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
$text = "";
if ($task == 'edit') {
if ($product->product_sku) {
$sku = ' (' . $product->product_sku . ')';
} else {
$sku = "";
}
if (!empty($product->virtuemart_product_id)) {
$text = '<a href="' . juri::root() . 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . '" target="_blank" >' . $product->product_name . $sku . '<span class="vm2-modallink"></span></a>';
} else {
$text = $product->product_name . $sku;
}
}
$this->SetViewTitle('PRODUCT', $text);
//JToolBarHelper::custom('sentproductemailtocustomer', 'email_32', 'email_32', 'COM_VIRTUEMART_PRODUCT_EMAILTOSHOPPER' ,false);
$this->addStandardEditViewCommands($product->virtuemart_product_id);
break;
default:
if ($product_parent_id = JRequest::getInt('product_parent_id', false)) {
$product_parent = $model->getProduct($product_parent_id);
$title = 'PRODUCT_CHILDREN_LIST';
$link_to_parent = JHTML::_('link', JRoute::_('index.php?view=product&task=edit&virtuemart_product_id=' . $product_parent->virtuemart_product_id . '&option=com_virtuemart'), $product_parent->product_name, array('title' => JText::_('COM_VIRTUEMART_EDIT_PARENT') . ' ' . $product_parent->product_name));
$msg = JText::_('COM_VIRTUEMART_PRODUCT_OF') . " " . $link_to_parent;
} else {
$title = 'PRODUCT';
$msg = "";
}
$this->db = JFactory::getDBO();
$this->SetViewTitle($title, $msg);
$this->addStandardDefaultViewLists($model, 'created_on');
/* Get the list of products */
$productlist = $model->getProductListing(false, false, false, false, true);
//The pagination must now always set AFTER the model load the listing
$pagination = $model->getPagination();
$this->assignRef('pagination', $pagination);
/* Get the category tree */
$categoryId = $model->virtuemart_category_id;
//OSP switched to filter in model, was JRequest::getInt('virtuemart_category_id');
$category_tree = ShopFunctions::categoryListTree(array($categoryId));
$this->assignRef('category_tree', $category_tree);
// Check for Media Items and Reviews, set the price
$media = VmModel::getModel('media');
$productreviews = VmModel::getModel('ratings');
/* Load the product price */
if (!class_exists('calculationHelper')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'calculationh.php';
}
$vendor_model = VmModel::getModel('vendor');
foreach ($productlist as $virtuemart_product_id => $product) {
$product->mediaitems = count($product->virtuemart_media_id);
$product->reviews = $productreviews->countReviewsForProduct($product->virtuemart_product_id);
$vendor_model->setId($product->virtuemart_vendor_id);
$vendor = $vendor_model->getVendor();
$currencyDisplay = CurrencyDisplay::getInstance($vendor->vendor_currency, $vendor->virtuemart_vendor_id);
if (!empty($product->product_price) && !empty($product->product_currency)) {
$product->product_price_display = $currencyDisplay->priceDisplay($product->product_price, (int) $product->product_currency, 1, true);
}
/* Write the first 5 categories in the list */
$product->categoriesList = shopfunctions::renderGuiList('virtuemart_category_id', '#__virtuemart_product_categories', 'virtuemart_product_id', $product->virtuemart_product_id, 'category_name', '#__virtuemart_categories', 'virtuemart_category_id', 'category');
}
$mf_model = VmModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown();
$this->assignRef('manufacturers', $manufacturers);
/* add Search filter in lists*/
/* Search type */
$options = array('' => JText::_('COM_VIRTUEMART_LIST_EMPTY_OPTION'), 'parent' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_PARENT_PRODUCT'), 'product' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRODUCT'), 'price' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRICE'), 'withoutprice' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_WITHOUTPRICE'));
$this->lists['search_type'] = VmHTML::selectList('search_type', JRequest::getVar('search_type'), $options);
/* Search order */
$options = array('bf' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_BEFORE'), 'af' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_AFTER'));
$this->lists['search_order'] = VmHTML::selectList('search_order', JRequest::getVar('search_order'), $options);
// Toolbar
JToolBarHelper::save('sentproductemailtoshoppers', JText::_('COM_VIRTUEMART_PRODUCT_EMAILTOSHOPPERS'));
JToolBarHelper::custom('createchild', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_CHILD'), true);
JToolBarHelper::custom('cloneproduct', 'copy', 'copy', JText::_('COM_VIRTUEMART_PRODUCT_CLONE'), true);
JToolBarHelper::custom('addrating', 'default', '', JText::_('COM_VIRTUEMART_ADD_RATING'), true);
$this->addStandardDefaultViewCommands();
$this->assignRef('productlist', $productlist);
$this->assignRef('virtuemart_category_id', $categoryId);
$this->assignRef('model', $model);
break;
}
parent::display($tpl);
}
/**
* Post-process method (e.g. footer HTML, redirect, etc)
*
* @param string Process type (i.e. install, uninstall, update)
* @param object JInstallerComponent parent
*/
public function postflight($type, $parent = null)
{
if ($type != 'uninstall') {
$this->loadVm();
// VmConfig::loadConfig(true);
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . DS . 'models' . DS . 'config.php';
}
$res = VirtueMartModelConfig::checkConfigTableExists();
if (!empty($res)) {
JRequest::setVar(JUtility::getToken(), '1', 'post');
$config = JModel::getInstance('config', 'VirtueMartModel');
$config->setDangerousToolsOff();
}
}
//Test if vm1.1 is installed and rename file to avoid conflicts
if (JFile::exists(JPATH_VM_ADMINISTRATOR . DS . 'toolbar.php')) {
JFile::move('toolbar.php', 'toolbar.vm1.php', JPATH_VM_ADMINISTRATOR);
}
//Prevents overwriting existing file.
// if(!JFile::exists(JPATH_VM_ADMINISTRATOR.DS.'virtuemart_defaults.cfg')){
// JFile::copy('virtuemart_defaults.cfg-dist','virtuemart_defaults.cfg',JPATH_VM_ADMINISTRATOR);
// }
return true;
}
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 = VmModel::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');
VmConfig::loadJLang('com_virtuemart_orders', TRUE);
VmConfig::loadJLang('com_virtuemart_shoppers', TRUE);
$virtuemart_product_id = vRequest::getInt('virtuemart_product_id');
if (is_array($virtuemart_product_id) && count($virtuemart_product_id) > 0) {
$virtuemart_product_id = (int) $virtuemart_product_id[0];
} else {
$virtuemart_product_id = (int) $virtuemart_product_id;
}
$product = $model->getProductSingle($virtuemart_product_id, false);
//$user = JFactory::getUser();
$superVendor = VmConfig::isSuperVendor();
if ($superVendor != 1 and $superVendor != $product->virtuemart_vendor_id) {
JFactory::getApplication()->redirect('index.php?option=com_virtuemart&view=virtuemart', vmText::_('JERROR_ALERTNOAUTHOR'), 'error');
}
if (!empty($product->product_parent_id)) {
$product_parent = $model->getProductSingle($product->product_parent_id, false);
}
$customfields = VmModel::getModel('Customfields');
$product->allIds[] = $product->virtuemart_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->virtuemart_product_id == $virtuemart_product_id) {
$isCustomVariant = true;
break;
}
}
if (!$isCustomVariant) {
$product_childIds = $model->getProductChildIds($virtuemart_product_id);
$product_childs = array();
$childs = 0;
$maxChilds = 50;
foreach ($product_childIds as $id) {
if ($childs++ > $maxChilds) {
break;
}
$product_childs[] = $model->getProductSingle($id, false);
}
$this->product_childs = $product_childs;
}
if (!class_exists('VirtueMartModelConfig')) {
require VMPATH_ADMIN . '/models/config.php';
}
$productLayouts = VirtueMartModelConfig::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 = VmModel::getModel('vendor');
if (Vmconfig::get('multix', 'none') !== 'none') {
$lists['vendors'] = Shopfunctions::renderVendorList($product->virtuemart_vendor_id);
}
// Load the currencies
$currency_model = VmModel::getModel('currency');
$vendor_model->setId(VmConfig::isSuperVendor());
$this->vendor = $vendor_model->getVendor();
$currency = $currency_model->getCurrency($this->vendor->vendor_currency);
$this->vendor_currency_symb = $currency->currency_symbol;
$lists['manufacturers'] = shopFunctions::renderManufacturerList($product->virtuemart_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 = VmConfig::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 = VmConfig::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 = VmConfig::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 = VmModel::getModel('waitinglist');
/* Load waiting list */
if ($product->virtuemart_product_id) {
//$waitinglist = $this->get('waitingusers', 'waitinglist');
$waitinglist = $waitinglistmodel->getWaitingusers($product->virtuemart_product_id);
$this->assignRef('waitinglist', $waitinglist);
}
$productShoppers = $model->getProductShoppersByStatus($product->virtuemart_product_id, array('S'));
$this->assignRef('productShoppers', $productShoppers);
$orderstatusModel = VmModel::getModel('orderstatus');
$lists['OrderStatus'] = $orderstatusModel->renderOSList(array(), 'order_status', TRUE);
// Add the virtuemart_shoppergroup_ids
$cid = JFactory::getUser()->id;
$this->activeShoppergroups = shopfunctions::renderGuiList($cid, 'shoppergroups', 'shopper_group_name', 'category', 'vmuser_shoppergroups', 'virtuemart_user_id');
if (!empty($this->activeShoppergroups)) {
$shoppergroupModel = VmModel::getModel('shoppergroup');
$this->activeShoppergroups = vmText::_($shoppergroupModel->getDefault(0)->shopper_group_name);
}
// Load protocustom lists
$customModel = VmModel::getModel('custom');
$this->fieldTypes = VirtueMartModelCustom::getCustomTypes();
$customsList = $customModel->getCustomsList();
$attribs = 'style= "width: 300px;"';
$customlist = JHtml::_('select.genericlist', $customsList, 'customlist', $attribs);
$this->assignRef('customsList', $customlist);
if ($product->product_parent_id > 0) {
// Set up labels
$info_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_INFO_LBL');
$status_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_STATUS_LBL');
$dim_weight_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_DIM_WEIGHT_LBL');
$images_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_IMAGES_LBL');
$delete_message = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_ITEM_MSG');
} else {
if ($task == 'add') {
$action = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_NEW_PRODUCT_LBL');
} else {
$action = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_UPDATE_ITEM_LBL');
}
$info_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_INFO_LBL');
$status_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_STATUS_LBL');
$dim_weight_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_DIM_WEIGHT_LBL');
$images_label = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_IMAGES_LBL');
$delete_message = vmText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_PRODUCT_MSG');
}
$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 = '&virtuemart_category_id=' . $product->canonCatLink; else $canonLink = '';
if (!empty($product->virtuemart_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 = '&virtuemart_category_id=' . $product->canonCatId;
}
$text = '<a href="' . juri::root() . 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_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_VIRTUEMART_LEAVE_TO_PRODUCT', juri::root() . 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . $canonLink . '&Itemid=' . $menuItemID);
}
} else {
$text = $product->product_name . $sku;
}
$this->SetViewTitle('PRODUCT', $text);
$this->addStandardEditViewCommands($product->virtuemart_product_id);
break;
case 'massxref_cats':
case 'massxref_cats_exe':
$this->SetViewTitle('PRODUCT_MASSXREF');
$showVendors = $this->showVendors();
$this->assignRef('showVendors', $showVendors);
$keyWord = '';
$catmodel = VmModel::getModel('category');
$this->assignRef('catmodel', $catmodel);
//$this->addStandardDefaultViewCommands();
$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', vmText::_('COM_VIRTUEMART_PRODUCT_XREF_CAT_EXE'), false);
break;
case 'massxref_sgrps':
case 'massxref_sgrps_exe':
$sgrpmodel = VmModel::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', vmText::_('COM_VIRTUEMART_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&virtuemart_product_id=' . $product_parent->virtuemart_product_id . '&option=com_virtuemart'), $product_parent->product_name, array('title' => vmText::_('COM_VIRTUEMART_EDIT_PARENT') . ' ' . $product_parent->product_name));
$msg = vmText::_('COM_VIRTUEMART_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');
/* Get the list of products */
$productlist = $model->getProductListing(false, false, false, false, true);
//vmdebug('my product listing',$productlist);
//The pagination must now always set AFTER the model load the listing
$this->pagination = $model->getPagination();
/* Get the category tree */
$categoryId = $model->virtuemart_category_id;
//OSP switched to filter in model, was vRequest::getInt('virtuemart_category_id');
$category_tree = ShopFunctions::categoryListTree(array($categoryId));
$this->assignRef('category_tree', $category_tree);
/* Load the product price */
if (!class_exists('calculationHelper')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'calculationh.php';
}
$vendor_model = VmModel::getModel('vendor');
$productreviews = VmModel::getModel('ratings');
$loaded_virtuemart_manufacturer_id = array();
$this->mfTable = $model->getTable('manufacturers');
$this->catTable = $model->getTable('categories');
foreach ($productlist as $virtuemart_product_id => $product) {
$product->mediaitems = count($product->virtuemart_media_id);
$product->reviews = $productreviews->countReviewsForProduct($product->virtuemart_product_id);
$vendor_model->setId($product->virtuemart_vendor_id);
$vendor = $vendor_model->getVendor();
$currencyDisplay = CurrencyDisplay::getInstance($vendor->vendor_currency, $vendor->virtuemart_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 = vmText::_('COM_VIRTUEMART_MULTIPLE_PRICES');
} else {
$product->product_price_display = vmText::_('COM_VIRTUEMART_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->virtuemart_manufacturer_id[0])) {
$product->manuList = shopfunctions::renderGuiList($product->virtuemart_manufacturer_id, 'manufacturers', 'mf_name', 'manufacturer');
}
}
$mf_model = VmModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown();
$this->assignRef('manufacturers', $manufacturers);
/* add Search filter in lists*/
/* Search type */
$options = array('' => vmText::_('COM_VIRTUEMART_LIST_EMPTY_OPTION'), 'parent' => vmText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_PARENT_PRODUCT'), 'product' => vmText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRODUCT'), 'price' => vmText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRICE'), 'withoutprice' => vmText::_('COM_VIRTUEMART_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' => vmText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_BEFORE'), 'af' => vmText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_AFTER'));
$this->lists['search_order'] = VmHTML::selectList('search_order', vRequest::getVar('search_order'), $options);
// Toolbar
if ($this->canDo->get('core.admin') or $this->canDo->get('vm.product.edit')) {
JToolBarHelper::custom('massxref_cats', 'new', 'new', vmText::_('COM_VIRTUEMART_PRODUCT_XREF_CAT'), true);
JToolBarHelper::custom('massxref_sgrps', 'new', 'new', vmText::_('COM_VIRTUEMART_PRODUCT_XREF_SGRPS'), true);
}
if ($this->canDo->get('core.admin') || $this->canDo->get('vm.product.create')) {
JToolBarHelper::custom('createchild', 'new', 'new', vmText::_('COM_VIRTUEMART_PRODUCT_CHILD'), true);
JToolBarHelper::custom('cloneproduct', 'copy', 'copy', vmText::_('COM_VIRTUEMART_PRODUCT_CLONE'), true);
}
JToolBarHelper::custom('addrating', 'default', '', vmText::_('COM_VIRTUEMART_ADD_RATING'), true);
$this->addStandardDefaultViewCommands();
$this->assignRef('productlist', $productlist);
$this->assignRef('virtuemart_category_id', $categoryId);
$this->assignRef('model', $model);
break;
}
parent::display($tpl);
}
/**
* Loads the configuration and works as singleton therefore called static. The call using the program cache
* is 10 times faster then taking from the session. The session is still approx. 30 times faster then using the file.
* The db is 10 times slower then the session.
*
* Performance:
*
* Fastest is
* Program Cache: 1.5974044799805E-5
* Session Cache: 0.00016094612121582
*
* First config db load: 0.00052118301391602
* Parsed and in session: 0.001554012298584
*
* After install from file: 0.0040450096130371
* Parsed and in session: 0.0051419734954834
*
*
* Functions tests if already loaded in program cache, session cache, database and at last the file.
*
* Load the configuration values from the database into a session variable.
* This step is done to prevent accessing the database for every configuration variable lookup.
*
* @author Max Milbers
* @param $force boolean Forces the function to load the config from the db
*/
public static function loadConfig($force = FALSE, $fresh = FALSE)
{
if ($fresh) {
return self::$_jpConfig = new VmConfig();
}
vmSetStartTime('loadConfig');
if (!$force) {
if (!empty(self::$_jpConfig) && !empty(self::$_jpConfig->_params)) {
return self::$_jpConfig;
}
}
self::$_jpConfig = new VmConfig();
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . DS . 'models' . DS . 'config.php';
}
$configTable = VirtueMartModelConfig::checkConfigTableExists();
$db = JFactory::getDBO();
/* $query = 'SHOW TABLES LIKE "%virtuemart_configs%"';
$db->setQuery($query);
$configTable = $db->loadResult();/*/
// self::$_debug = true;
if (empty($configTable)) {
self::$_jpConfig->installVMconfig();
}
$app = JFactory::getApplication();
$install = 'no';
if (empty(self::$_jpConfig->_raw)) {
$query = ' SELECT `config` FROM `#__virtuemart_configs` WHERE `virtuemart_config_id` = "1";';
$db->setQuery($query);
self::$_jpConfig->_raw = $db->loadResult();
if (empty(self::$_jpConfig->_raw)) {
if (self::installVMconfig()) {
$install = 'yes';
$db->setQuery($query);
self::$_jpConfig->_raw = $db->loadResult();
self::$_jpConfig->_params = NULL;
} else {
$app->enqueueMessage('Error loading configuration file', 'Error loading configuration file, please contact the storeowner');
}
}
}
$i = 0;
$pair = array();
if (!empty(self::$_jpConfig->_raw)) {
$config = explode('|', self::$_jpConfig->_raw);
foreach ($config as $item) {
$item = explode('=', $item);
if (!empty($item[1])) {
// if($item[0]!=='offline_message' && $item[0]!=='dateformat' ){
if ($item[0] !== 'offline_message') {
try {
$value = @unserialize($item[1]);
if ($value === FALSE) {
$app->enqueueMessage('Exception in loadConfig for unserialize ' . $item[0] . ' ' . $item[1]);
$uri = JFactory::getURI();
$configlink = $uri->root() . 'administrator/index.php?option=com_virtuemart&view=config';
$app->enqueueMessage('To avoid this message, enter your virtuemart <a href="' . $configlink . '">config</a> and just save it one time');
} else {
$pair[$item[0]] = $value;
}
} catch (Exception $e) {
vmdebug('Exception in loadConfig for unserialize ' . $e->getMessage(), $item);
}
} else {
$pair[$item[0]] = unserialize(base64_decode($item[1]));
}
} else {
$pair[$item[0]] = '';
}
}
// $pair['sctime'] = microtime(true);
self::$_jpConfig->_params = $pair;
self::$_jpConfig->set('sctime', microtime(TRUE));
self::$_jpConfig->set('vmlang', self::setdbLanguageTag());
vmTime('loadConfig db ' . $install, 'loadConfig');
return self::$_jpConfig;
}
$app->enqueueMessage('Attention config is empty');
return self::$_jpConfig;
}
function display($tpl = null)
{
// Get the task
$task = JRequest::getWord('task', $this->getLayout());
$this->assignRef('task', $task);
// Load helpers
if (!class_exists('CurrencyDisplay')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'currencydisplay.php';
}
if (!class_exists('VmHTML')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'html.php';
}
if (!class_exists('VmImage')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'image.php';
}
$model = VmModel::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');
VmConfig::loadJLang('com_virtuemart_orders', TRUE);
VmConfig::loadJLang('com_virtuemart_shoppers', TRUE);
$virtuemart_product_id = JRequest::getVar('virtuemart_product_id', array());
if (is_array($virtuemart_product_id) && count($virtuemart_product_id) > 0) {
$virtuemart_product_id = (int) $virtuemart_product_id[0];
} else {
$virtuemart_product_id = (int) $virtuemart_product_id;
}
$product = $model->getProductSingle($virtuemart_product_id, false);
//$product_parent= $model->getProductParent($product->product_parent_id);
$product_parent = false;
if (!empty($product->product_parent_id)) {
$product_parent = $model->getProductSingle($product->product_parent_id, false);
}
$mf_model = VmModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown($product->virtuemart_manufacturer_id);
$this->assignRef('manufacturers', $manufacturers);
// Get the category tree
if (isset($product->categories)) {
$category_tree = ShopFunctions::categoryListTree($product->categories);
} else {
$category_tree = ShopFunctions::categoryListTree();
}
$this->assignRef('category_tree', $category_tree);
//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)) {
$shoppergroupList = ShopFunctions::renderShopperGroupList($product->shoppergroups);
}
$this->assignRef('shoppergroupList', $shoppergroupList);
// Load the product price
if (!class_exists('calculationHelper')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'calculationh.php';
}
$product_childIds = $model->getProductChildIds($virtuemart_product_id);
$product_childs = array();
$childs = 0;
$maxChilds = 30;
foreach ($product_childIds as $id) {
if ($childs++ > $maxChilds) {
break;
}
$product_childs[] = $model->getProductSingle($id, false);
}
$this->assignRef('product_childs', $product_childs);
if (!class_exists('VirtueMartModelConfig')) {
require JPATH_VM_ADMINISTRATOR . DS . 'models' . DS . 'config.php';
}
$productLayouts = VirtueMartModelConfig::getLayoutList('productdetails');
$this->assignRef('productLayouts', $productLayouts);
// Load Images
$model->addImages($product);
if (!class_exists('shopFunctionsF')) {
require JPATH_VM_SITE . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
$vmtemplate = shopFunctionsF::loadVmTemplateStyle();
if (is_Dir(JPATH_ROOT . DS . 'templates' . DS . $vmtemplate . DS . 'images' . DS . 'availability' . DS)) {
$imagePath = '/templates/' . $vmtemplate . '/images/availability/';
} else {
$imagePath = '/components/com_virtuemart/assets/images/availability/';
}
$this->assignRef('imagePath', $imagePath);
// Load the vendors
$vendor_model = VmModel::getModel('vendor');
if (Vmconfig::get('multix', 'none') !== 'none') {
$lists['vendors'] = Shopfunctions::renderVendorList($product->virtuemart_vendor_id);
}
// Load the currencies
$currency_model = VmModel::getModel('currency');
if (!class_exists('Permissions')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'permissions.php';
}
$vendor_model->setId(Permissions::getInstance()->isSuperVendor());
$vendor = $vendor_model->getVendor();
if (empty($product->product_currency)) {
$product->product_currency = $vendor->vendor_currency;
}
//$currencies = JHTML::_('select.genericlist', $currency_model->getCurrencies(), 'product_currency', '', 'virtuemart_currency_id', 'currency_name', $product->product_currency);
$currency = $currency_model->getCurrency($product->product_currency);
$this->assignRef('product_currency', $currency->currency_symbol);
$currency = $currency_model->getCurrency($vendor->vendor_currency);
$this->assignRef('vendor_currency', $currency->currency_symbol);
if (count($manufacturers) > 0) {
$lists['manufacturers'] = JHTML::_('select.genericlist', $manufacturers, 'virtuemart_manufacturer_id', 'class="inputbox"', 'value', 'text', $product->virtuemart_manufacturer_id);
}
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 = VmConfig::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 = VmConfig::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 = VmConfig::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 = VmModel::getModel('waitinglist');
/* Load waiting list */
if ($product->virtuemart_product_id) {
//$waitinglist = $this->get('waitingusers', 'waitinglist');
$waitinglist = $waitinglistmodel->getWaitingusers($product->virtuemart_product_id);
$this->assignRef('waitinglist', $waitinglist);
}
$productShoppers = $model->getProductShoppersByStatus($product->virtuemart_product_id, array('S'));
$this->assignRef('productShoppers', $productShoppers);
$orderstatusModel = VmModel::getModel('orderstatus');
$lists['OrderStatus'] = $orderstatusModel->renderOSList(array(), 'order_status', TRUE);
$field_model = VmModel::getModel('customfields');
$fieldTypes = $field_model->getField_types();
$this->assignRef('fieldTypes', $fieldTypes);
// Add the virtuemart_shoppergroup_ids
$cid = JFactory::getUser()->id;
$this->activeShoppergroups = shopfunctions::renderGuiList('virtuemart_shoppergroup_id', '#__virtuemart_vmuser_shoppergroups', 'virtuemart_user_id', $cid, 'shopper_group_name', '#__virtuemart_shoppergroups', 'virtuemart_shoppergroup_id', 'category', 4, 0);
if (!$this->activeShoppergroups or is_array($this->activeShoppergroups) and count($this->activeShoppergroups) == 0) {
//vmdebug('$this->activeShoppergroups',$this->activeShoppergroups);
$shoppergroupModel = VmModel::getModel('shoppergroup');
$this->activeShoppergroups = vmText::_($shoppergroupModel->getDefault(0)->shopper_group_name);
}
/* Load protocustom lists */
$customsList = $field_model->getCustomsList();
$attribs = 'style= "width: 300px;"';
$customlist = JHTML::_('select.genericlist', $customsList, 'customlist', $attribs);
$this->assignRef('customsList', $customlist);
$ChildCustomRelation = $field_model->getProductChildCustomRelation();
$this->assignRef('ChildCustomRelation', $ChildCustomRelation);
if ($product->product_parent_id > 0) {
$parentRelation = $field_model->getProductParentRelation($product->virtuemart_product_id);
$this->assignRef('parentRelation', $parentRelation);
// Set up labels
$info_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_INFO_LBL');
$status_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_STATUS_LBL');
$dim_weight_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_DIM_WEIGHT_LBL');
$images_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_ITEM_IMAGES_LBL');
$delete_message = JText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_ITEM_MSG');
} else {
if ($task == 'add') {
$action = JText::_('COM_VIRTUEMART_PRODUCT_FORM_NEW_PRODUCT_LBL');
} else {
$action = JText::_('COM_VIRTUEMART_PRODUCT_FORM_UPDATE_ITEM_LBL');
}
$info_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_INFO_LBL');
$status_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_STATUS_LBL');
$dim_weight_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_DIM_WEIGHT_LBL');
$images_label = JText::_('COM_VIRTUEMART_PRODUCT_FORM_PRODUCT_IMAGES_LBL');
$delete_message = JText::_('COM_VIRTUEMART_PRODUCT_FORM_DELETE_PRODUCT_MSG');
}
$this->assignRef('product', $product);
$product_empty_price = array('virtuemart_product_price_id' => 0, 'virtuemart_product_id' => $virtuemart_product_id, 'virtuemart_shoppergroup_id' => NULL, 'product_price' => NULL, 'override' => NULL, 'product_override_price' => NULL, 'product_tax_id' => NULL, 'product_discount_id' => NULL, 'product_currency' => $vendor->vendor_currency, 'product_price_publish_up' => NULL, 'product_price_publish_down' => NULL, 'price_quantity_start' => NULL, 'price_quantity_end' => NULL);
$this->assignRef('product_empty_price', $product_empty_price);
$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 = '&virtuemart_category_id=' . $product->canonCatLink;
} else {
$canonLink = '';
}
if (!empty($product->virtuemart_product_id)) {
if (!class_exists('shopFunctionsF')) {
require JPATH_VM_SITE . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
$menuItemID = shopFunctionsF::getMenuItemId(JFactory::getLanguage()->getTag());
$text = '<a href="' . juri::root() . 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=' . $product->virtuemart_product_id . $canonLink . '&Itemid=' . $menuItemID . '" target="_blank" >' . $product->product_name . $sku . '<span class="vm2-modallink"></span></a>';
} else {
$text = $product->product_name . $sku;
}
$this->SetViewTitle('PRODUCT', $text);
$this->addStandardEditViewCommands($product->virtuemart_product_id);
break;
case 'massxref_cats':
case 'massxref_cats_exe':
$this->SetViewTitle('PRODUCT_MASSXREF');
if (!class_exists('Permissions')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'permissions.php';
}
$showVendors = Permissions::getInstance()->check('admin');
$this->assignRef('showVendors', $showVendors);
$keyWord = '';
$catmodel = VmModel::getModel('category');
$this->assignRef('catmodel', $catmodel);
//$this->addStandardDefaultViewCommands();
$this->addStandardDefaultViewLists($catmodel, 'category_name');
$categories = $catmodel->getCategoryTree(0, 0, false, $this->lists['search']);
$this->assignRef('categories', $categories);
$catpagination = $catmodel->getPagination();
$this->assignRef('catpagination', $catpagination);
//$this->addStandardDefaultViewCommands();
$this->setLayout('massxref');
JToolBarHelper::custom('massxref_cats_exe', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_XREF_CAT_EXE'), false);
break;
case 'massxref_sgrps':
case 'massxref_sgrps_exe':
$sgrpmodel = VmModel::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', JText::_('COM_VIRTUEMART_PRODUCT_XREF_SGRPS_EXE'), false);
break;
default:
if ($product_parent_id = JRequest::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&virtuemart_product_id=' . $product_parent->virtuemart_product_id . '&option=com_virtuemart'), $product_parent->product_name, array('title' => JText::_('COM_VIRTUEMART_EDIT_PARENT') . ' ' . $product_parent->product_name));
$msg = JText::_('COM_VIRTUEMART_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->db = JFactory::getDBO();
$this->SetViewTitle($title, $msg);
$this->addStandardDefaultViewLists($model, 'created_on');
/* Get the list of products */
$productlist = $model->getProductListing(false, false, false, false, true);
//The pagination must now always set AFTER the model load the listing
$pagination = $model->getPagination();
$this->assignRef('pagination', $pagination);
/* Get the category tree */
$categoryId = $model->virtuemart_category_id;
//OSP switched to filter in model, was JRequest::getInt('virtuemart_category_id');
$category_tree = ShopFunctions::categoryListTree(array($categoryId));
$this->assignRef('category_tree', $category_tree);
/* Load the product price */
if (!class_exists('calculationHelper')) {
require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'calculationh.php';
}
$vendor_model = VmModel::getModel('vendor');
$productreviews = VmModel::getModel('ratings');
foreach ($productlist as $virtuemart_product_id => $product) {
$product->mediaitems = count($product->virtuemart_media_id);
$product->reviews = $productreviews->countReviewsForProduct($product->virtuemart_product_id);
$vendor_model->setId($product->virtuemart_vendor_id);
$vendor = $vendor_model->getVendor();
$currencyDisplay = CurrencyDisplay::getInstance($vendor->vendor_currency, $vendor->virtuemart_vendor_id);
if (!empty($product->product_price) && !empty($product->product_currency)) {
$product->product_price_display = $currencyDisplay->priceDisplay($product->product_price, (int) $product->product_currency, 1, true);
}
/* Write the first 5 categories in the list */
$product->categoriesList = shopfunctions::renderGuiList('virtuemart_category_id', '#__virtuemart_product_categories', 'virtuemart_product_id', $product->virtuemart_product_id, 'category_name', '#__virtuemart_categories', 'virtuemart_category_id', 'category');
}
$mf_model = VmModel::getModel('manufacturer');
$manufacturers = $mf_model->getManufacturerDropdown();
$this->assignRef('manufacturers', $manufacturers);
/* add Search filter in lists*/
/* Search type */
$options = array('' => JText::_('COM_VIRTUEMART_LIST_EMPTY_OPTION'), 'parent' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_PARENT_PRODUCT'), 'product' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRODUCT'), 'price' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_PRICE'), 'withoutprice' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_TYPE_WITHOUTPRICE'));
$this->lists['search_type'] = VmHTML::selectList('search_type', JRequest::getVar('search_type'), $options);
/* Search order */
$options = array('bf' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_BEFORE'), 'af' => JText::_('COM_VIRTUEMART_PRODUCT_LIST_SEARCH_BY_DATE_AFTER'));
$this->lists['search_order'] = VmHTML::selectList('search_order', JRequest::getVar('search_order'), $options);
// Toolbar
JToolBarHelper::custom('massxref_cats', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_XREF_CAT'), true);
JToolBarHelper::custom('massxref_sgrps', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_XREF_SGRPS'), true);
JToolBarHelper::custom('createchild', 'new', 'new', JText::_('COM_VIRTUEMART_PRODUCT_CHILD'), true);
JToolBarHelper::custom('cloneproduct', 'copy', 'copy', JText::_('COM_VIRTUEMART_PRODUCT_CLONE'), true);
JToolBarHelper::custom('addrating', 'default', '', JText::_('COM_VIRTUEMART_ADD_RATING'), true);
$this->addStandardDefaultViewCommands();
$this->assignRef('productlist', $productlist);
$this->assignRef('virtuemart_category_id', $categoryId);
$this->assignRef('model', $model);
break;
}
parent::display($tpl);
}
function display($tpl = null)
{
if (!class_exists('VirtueMartModelConfig')) {
require VMPATH_ADMIN . 'models/config.php';
}
if (!class_exists('VmHTML')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'html.php';
}
$model = VmModel::getModel();
$layoutName = $this->getLayout();
$task = vRequest::getCmd('task', $layoutName);
$this->assignRef('task', $task);
$this->user = $user = JFactory::getUser();
if ($layoutName == 'edit') {
$category = $model->getCategory('', false);
// Toolbar
$text = '';
if (isset($category->category_name)) {
$name = $category->category_name;
} else {
$name = '';
}
if (!empty($category->virtuemart_category_id)) {
$text = '<a href="' . juri::root() . 'index.php?option=com_virtuemart&view=category&virtuemart_category_id=' . $category->virtuemart_category_id . '" target="_blank" >' . $name . '<span class="vm2-modallink"></span></a>';
}
$this->SetViewTitle('CATEGORY', $text);
$model->addImages($category);
if ($category->virtuemart_category_id > 1) {
$relationInfo = $model->getRelationInfo($category->virtuemart_category_id);
$this->assignRef('relationInfo', $relationInfo);
}
$parent = $model->getParentCategory($category->virtuemart_category_id);
$this->assignRef('parent', $parent);
if (!class_exists('ShopFunctions')) {
require VMPATH_ADMIN . DS . 'helpers' . DS . 'shopfunctions.php';
}
$templateList = ShopFunctions::renderTemplateList(vmText::_('COM_VIRTUEMART_CATEGORY_TEMPLATE_DEFAULT'));
$this->assignRef('jTemplateList', $templateList);
$categoryLayoutList = VirtueMartModelConfig::getLayoutList('category');
$this->assignRef('categoryLayouts', $categoryLayoutList);
$productLayouts = VirtueMartModelConfig::getLayoutList('productdetails');
$this->assignRef('productLayouts', $productLayouts);
//Nice fix by Joe, the 4. param prevents setting an category itself as child
$categorylist = ShopFunctions::categoryListTree(array($parent->virtuemart_category_id), 0, 0, (array) $category->virtuemart_category_id);
if (Vmconfig::get('multix', 'none') !== 'none') {
$vendorList = ShopFunctions::renderVendorList($category->virtuemart_vendor_id, false);
$this->assignRef('vendorList', $vendorList);
}
$this->assignRef('category', $category);
$this->assignRef('categorylist', $categorylist);
$this->addStandardEditViewCommands($category->virtuemart_category_id, $category);
} else {
$this->SetViewTitle('CATEGORY_S');
$keyWord = '';
$this->assignRef('catmodel', $model);
$this->addStandardDefaultViewCommands();
$this->addStandardDefaultViewLists($model, 'category_name');
$categories = $model->getCategoryTree(0, 0, false, $this->lists['search']);
$this->assignRef('categories', $categories);
$pagination = $model->getPagination();
$this->assignRef('catpagination', $pagination);
//we need a function of the FE shopfunctions helper to cut the category descriptions
if (!class_exists('shopFunctionsF')) {
require VMPATH_SITE . DS . 'helpers' . DS . 'shopfunctionsf.php';
}
}
parent::display($tpl);
}
public static function storeConfig()
{
$user = JFactory::getUser();
if ($user->authorise('core.admin', 'com_virtuemart')) {
$installed = VirtueMartModelConfig::checkVirtuemartInstalled();
if ($installed) {
VirtueMartModelConfig::installVMconfigTable();
$confData = array();
$confData['virtuemart_config_id'] = 1;
$confData['config'] = VmConfig::$_jpConfig->toString();
$confTable = VmTable::getInstance('configs', 'Table', array());
if (!$confTable->bindChecknStore($confData)) {
vmError('storeConfig was not able to store config');
}
} else {
self::$_virtuemart_vendor_id = 1;
}
}
}
/**
* Post-process method (e.g. footer HTML, redirect, etc)
*
* @param string Process type (i.e. install, uninstall, update)
* @param object JInstallerComponent parent
*/
public function postflight($type, $parent = null)
{
//We want disable the redirect in the installation process
if ($type != 'uninstall') {
$this->loadVm();
$res = VirtueMartModelConfig::checkConfigTableExists();
JRequest::setVar(JUtility::getToken(), '1', 'post');
$config = JModel::getInstance('config', 'VirtueMartModel');
$config->setDangerousToolsOff();
}
$_REQUEST['install'] = 0;
//Test if vm1.1 is installed and rename file to avoid conflicts
if (JFile::exists(JPATH_VM_ADMINISTRATOR . DS . 'toolbar.php')) {
JFile::move('toolbar.php', 'toolbar.vm1.php', JPATH_VM_ADMINISTRATOR);
}
return true;
}