- ' . join ('', $_shipTo) . '
", $skips = array('name','username','email','agreed')) { $vendorModel = VmModel::getModel('vendor'); $vendorModel->setId($vendorId); $vendorFields = $vendorModel->getVendorAddressFields($vendorId); $vendorAddress = ''; foreach ($vendorFields['fields'] as $field) { if(in_array($field['name'],$skips)) continue; if (!empty($field['value'])) { $vendorAddress .= $field['value']; if ($field['name'] != 'title' and $field['name'] != 'first_name' and $field['name'] != 'middle_name' and $field['name'] != 'zip') { $vendorAddress .= $lineSeparator; } else { $vendorAddress .= ' '; } } } return $vendorAddress; } public static $counter = 0; public static $categoryTree = 0; static public function categoryListTree ($selectedCategories = array(), $cid = 0, $level = 0, $disabledFields = array()) { if (empty(self::$categoryTree)) { // vmTime('Start with categoryListTree'); $cache = JFactory::getCache ('com_virtuemart_cats'); $cached = $cache->getCaching(); $cache->setCaching (1); self::$categoryTree = $cache->call (array('ShopFunctions', 'categoryListTreeLoop'), $selectedCategories, $cid, $level, $disabledFields); $cache->setCaching ($cached); // self::$categoryTree = self::categoryListTreeLoop($selectedCategories, $cid, $level, $disabledFields); // vmTime('end loop categoryListTree '.self::$counter); } return self::$categoryTree; } /** * Get feed * @author valerie isaksen * @param $rssUrl * @param $max * @return mixed */ static public function getCPsRssFeed($rssUrl,$max) { $cache_time=86400*3; // 3days $cache = JFactory::getCache ('com_virtuemart_rss'); $cached = $cache->getCaching(); $cache->setLifeTime($cache_time); $cache->setCaching (1); $feeds = $cache->call (array('ShopFunctions', 'getRssFeed'), $rssUrl, $max); $cache->setCaching ($cached); return $feeds; } /** * @author Valerie Isaksen * Returns the RSS feed from Extensions.virtuemart.net * @return mixed */ public static $extFeeds = 0; static public function getExtensionsRssFeed() { if (empty(self::$extFeeds)) { self::$extFeeds = ShopFunctions::getCPsRssFeed("http://extensions.virtuemart.net/?format=feed&type=rss", 15); } return self::$extFeeds; } /** * @author Valerie Isaksen * Returns the RSS feed from virtuemart.net * @return mixed */ public static $vmFeeds = 0; static public function getVirtueMartRssFeed() { if (empty(self::$vmFeeds)) { self::$vmFeeds = ShopFunctions::getCPsRssFeed("http://virtuemart.net/news/list-all-news?format=feed&type=rss", 5); } return self::$vmFeeds; } static public function getRssFeed ($rssURL,$max) { jimport('simplepie.simplepie'); $rssFeed = new SimplePie($rssURL); $feeds = array(); $count = $rssFeed->get_item_quantity(); $limit=min($max,$count); for ($i = 0; $i < $limit; $i++) { $feed = new StdClass(); $item = $rssFeed->get_item($i); $feed->link = $item->get_link(); $feed->title = $item->get_title(); $feed->description = $item->get_description(); $feeds[] = $feed; } return $feeds; } /** * Creates structured option fields for all categories * * @todo: Connect to vendor data * @author Max Milbers, jseros * @param array $selectedCategories All category IDs that will be pre-selected * @param int $cid Internally used for recursion * @param int $level Internally used for recursion * @return string $category_tree HTML: Category tree list */ static public function categoryListTreeLoop ($selectedCategories = array(), $cid = 0, $level = 0, $disabledFields = array()) { self::$counter++; static $categoryTree = ''; $virtuemart_vendor_id = 1; // vmSetStartTime('getCategories'); $categoryModel = VmModel::getModel ('category'); $level++; $categoryModel->_noLimit = TRUE; $app = JFactory::getApplication (); $records = $categoryModel->getCategories ($app->isSite (), $cid); // vmTime('getCategories','getCategories'); $selected = ""; if (!empty($records)) { foreach ($records as $key => $category) { $childId = $category->category_child_id; if ($childId != $cid) { if (in_array ($childId, $selectedCategories)) { $selected = 'selected=\"selected\"'; } else { $selected = ''; } $disabled = ''; if (in_array ($childId, $disabledFields)) { $disabled = 'disabled="disabled"'; } if ($disabled != '' && stristr ($_SERVER['HTTP_USER_AGENT'], 'msie')) { //IE7 suffers from a bug, which makes disabled option fields selectable } else { $categoryTree .= ''; } } if ($categoryModel->hasChildren ($childId)) { self::categoryListTreeLoop ($selectedCategories, $childId, $level, $disabledFields); } } } return $categoryTree; } /** * Return the countryname or code of a given countryID * * @author Oscar van Eijk * @access public * @param int $id Country ID * @param char $fld Field to return: country_name (default), country_2_code or country_3_code. * @return string Country name or code */ static public function getCountryByID ($id, $fld = 'country_name') { if (empty($id)) { return ''; } $id = (int)$id; $db = JFactory::getDBO (); $q = 'SELECT ' . $db->getEscaped ($fld) . ' AS fld FROM `#__virtuemart_countries` WHERE virtuemart_country_id = ' . (int)$id; $db->setQuery ($q); return $db->loadResult (); } /** * Return the virtuemart_country_id of a given country name * * @author Oscar van Eijk * @author Max Milbers * @access public * @param string $name Country name (can be country_name or country_3_code or country_2_code ) * @return int virtuemart_country_id */ static public function getCountryIDByName ($name) { if (empty($name)) { return 0; } $db = JFactory::getDBO (); if (strlen ($name) === 2) { $fieldname = 'country_2_code'; } else { if (strlen ($name) === 3) { $fieldname = 'country_3_code'; } else { $fieldname = 'country_name'; } } $q = 'SELECT `virtuemart_country_id` FROM `#__virtuemart_countries` WHERE `' . $fieldname . '` = "' . $db->getEscaped ($name) . '"'; $db->setQuery ($q); $r = $db->loadResult (); return $r; } /** * Return the statename or code of a given virtuemart_state_id * * @author Oscar van Eijk * @access public * @param int $id State ID * @param char $fld Field to return: state_name (default), state_2_code or state_3_code. * @return string state name or code */ static public function getStateByID ($id, $fld = 'state_name') { if (empty($id)) { return ''; } $db = JFactory::getDBO (); $q = 'SELECT ' . $db->getEscaped ($fld) . ' AS fld FROM `#__virtuemart_states` WHERE virtuemart_state_id = "' . (int)$id . '"'; $db->setQuery ($q); $r = $db->loadObject (); return $r->fld; } /** * Return the stateID of a given state name * * @author Max Milbers * @access public * @param string $name Country name * @return int virtuemart_state_id */ static public function getStateIDByName ($name) { if (empty($name)) { return 0; } $db = JFactory::getDBO (); if (strlen ($name) === 2) { $fieldname = 'state_2_code'; } else { if (strlen ($name) === 3) { $fieldname = 'state_3_code'; } else { $fieldname = 'state_name'; } } $q = 'SELECT `virtuemart_state_id` FROM `#__virtuemart_states` WHERE `' . $fieldname . '` = "' . $db->getEscaped ($name) . '"'; $db->setQuery ($q); $r = $db->loadResult (); return $r; } /* * Returns the associative array for a given virtuemart_calc_id * * @author Valérie Isaksen * @access public * @param int $id virtuemart_calc_id * @return array Result row */ static public function getTaxByID ($id) { if (empty($id)) { return ''; } $id = (int)$id; $db = JFactory::getDBO (); $q = 'SELECT * FROM `#__virtuemart_calcs` WHERE virtuemart_calc_id = ' . (int)$id; $db->setQuery ($q); return $db->loadAssoc (); } /** * Return any field from table '#__virtuemart_currencies' * * @author Valérie Isaksen * @access public * @param int $id Currency ID * @param char $fld Field from table '#__virtuemart_currencies' to return: currency_name (default), currency_code_2, currency_code_3 etc. * @return string Currency name or code */ static public function getCurrencyByID ($id, $fld = 'currency_name') { if (empty($id)) { return ''; } static $currencyNameById = array(); if(!isset($currencyNameById[$id][$fld])){ $id = (int)$id; $db = JFactory::getDBO (); $q = 'SELECT ' . $db->getEscaped ($fld) . ' AS fld FROM `#__virtuemart_currencies` WHERE virtuemart_currency_id = ' . (int)$id; $db->setQuery ($q); $currencyNameById[$id][$fld] = $db->loadResult (); } return $currencyNameById[$id][$fld]; } /** * Return the currencyID of a given Currency name * This function becomes dangerous if there is a currency name with 3 letters * @author Valerie Isaksen, Max Milbers * @access public * @param string $name Currency name * @return int virtuemart_currency_id */ static public function getCurrencyIDByName ($name) { if (empty($name)) { return 0; } static $currencyIdByName = array(); if(!isset($currencyIdByName[$name])){ $db = JFactory::getDBO (); if (strlen ($name) === 2) { $fieldname = 'currency_code_2'; } else { if (strlen ($name) === 3) { $fieldname = 'currency_code_3'; } else { $fieldname = 'currency_name'; } } $q = 'SELECT `virtuemart_currency_id` FROM `#__virtuemart_currencies` WHERE `' . $fieldname . '` = "' . ($name) . '"'; $db->setQuery ($q); $currencyIdByName[$name] = $db->loadResult (); } return $currencyIdByName[$name]; } /** * Print a select-list with enumerated categories * * @author jseros * * @param boolean $onlyPublished Show only published categories? * @param boolean $withParentId Keep in mind $parentId param? * @param integer $parentId Show only its childs * @param string $attribs HTML attributes for the list * @return string HTML */ static public function getEnumeratedCategories ($onlyPublished = TRUE, $withParentId = FALSE, $parentId = 0, $name = '', $attribs = '', $key = '', $text = '', $selected = NULL) { $categoryModel = VmModel::getModel ('category'); $categories = $categoryModel->getCategories ($onlyPublished, $parentId); foreach ($categories as $index => $cat) { $cat->category_name = $cat->ordering . '. ' . $cat->category_name; $categories[$index] = $cat; } return JHTML::_ ('Select.genericlist', $categories, $name, $attribs, $key, $text, $selected, $name); } /** * Return the order status name for a given code * * @author Oscar van Eijk * @access public * * @param char $_code Order status code * @return string The name of the order status */ static public function getOrderStatusName ($_code) { $db = JFactory::getDBO (); $_q = 'SELECT `order_status_name` FROM `#__virtuemart_orderstates` WHERE `order_status_code` = "' . $db->getEscaped ($_code) . '"'; $db->setQuery ($_q); $_r = $db->loadObject (); if (empty($_r->order_status_name)) { vmError ('getOrderStatusName: couldnt find order_status_name for ' . $_code); return 'current order status broken'; } else { return JText::_($_r->order_status_name); } } /* * @author Valerie */ static function InvoiceNumberReserved ($invoice_number) { if (($pos = strpos ($invoice_number, 'reservedByPayment_')) === FALSE) { return FALSE; } else { return TRUE; } } /** * Creates an drop-down list with numbers from 1 to 31 or of the selected range, * dont use within virtuemart. It is just meant for paymentmethods * * @param string $list_name The name of the select element * @param string $selected_item The pre-selected value */ static function listDays ($list_name, $selected = FALSE, $start = NULL, $end = NULL) { $options = array(); if (!$selected) { $selected = date ('d'); } $start = $start ? $start : 1; $end = $end ? $end : $start + 30; $options[] = JHTML::_ ('select.option', 0, JText::_ ('DAY')); for ($i = $start; $i <= $end; $i++) { $options[] = JHTML::_ ('select.option', $i, $i); } return JHTML::_ ('select.genericlist', $options, $list_name, '', 'value', 'text', $selected); } /** * Creates a Drop-Down List for the 12 months in a year * * @param string $list_name The name for the select element * @param string $selected_item The pre-selected value * */ static function listMonths ($list_name, $selected = FALSE, $attr = '', $format='F') { $options = array(); if (!$selected) { $selected = date ('m'); } $months=array( "01"=>JText::_ ('JANUARY'), "02"=>JText::_ ('FEBRUARY'), "03"=>JText::_ ('MARCH'), "04"=>JText::_ ('APRIL'), "05"=>JText::_ ('MAY'), "06"=>JText::_ ('JUNE'), "07"=>JText::_ ('JULY'), "08"=>JText::_ ('AUGUST'), "09"=>JText::_ ('SEPTEMBER'), "10"=>JText::_ ('OCTOBER'), "11"=>JText::_ ('NOVEMBER'), "12"=>JText::_ ('DECEMBER') ); $options[] = JHTML::_ ('select.option', 0, JText::_ ('MONTH')); foreach($months as $key => $value) { if ($format=='F') { $text=$value; } else { $text=$key; } $options[] = JHTML::_ ('select.option',$key, $text); } return JHTML::_ ('select.genericlist', $options, $list_name, $attr, 'value', 'text', $selected); } /** * Creates an drop-down list with years of the selected range or of the next 7 years * * @param string $list_name The name of the select element * @param string $selected_item The pre-selected value */ static function listYears ($list_name, $selected = FALSE, $start = NULL, $end = NULL, $attr = '') { $options = array(); if (!$selected) { $selected = date ('Y'); } $start = $start ? $start : date ('Y'); $end = $end ? $end : $start + 7; $options[] = JHTML::_ ('select.option', 0, JText::_ ('YEAR')); for ($i = $start; $i <= $end; $i++) { $options[] = JHTML::_ ('select.option', $i, $i); } return JHTML::_ ('select.genericlist', $options, $list_name, $attr, 'value', 'text', $selected); } static function checkboxListArr ($arr, $tag_name, $tag_attribs, $key = 'value', $text = 'text', $selected = NULL, $required = 0) { reset ($arr); $html = array(); $n = count ($arr); for ($i = 0; $i < $n; $i++) { $k = $arr[$i]->$key; $t = $arr[$i]->$text; $id = isset($arr[$i]->id) ? $arr[$i]->id : NULL; $extra = ''; $extra .= $id ? " id=\"" . $arr[$i]->id . "\"" : ''; if (is_array ($selected)) { foreach ($selected as $obj) { $k2 = $obj->$key; if ($k == $k2) { $extra .= " checked=\"checked\""; break; } } } else { $extra .= ($k == $selected ? " checked=\"checked\"" : ''); } $tmp = "" . ""; $html[] = $tmp; } return $html; } function checkboxList ($arr, $tag_name, $tag_attribs, $key = 'value', $text = 'text', $selected = NULL, $required = 0) { return "\n\t" . implode ("\n\t", vmCommonHTML::checkboxListArr ($arr, $tag_name, $tag_attribs, $key, $text, $selected, $required)) . "\n"; } function checkboxListTable ($arr, $tag_name, $tag_attribs, $key = 'value', $text = 'text', $selected = NULL, $cols = 0, $rows = 0, $size = 0, $required = 0) { $cellsHtml = self::checkboxListArr ($arr, $tag_name, $tag_attribs, $key, $text, $selected, $required); return self::list2Table ($cellsHtml, $cols, $rows, $size); } // private methods: private function list2Table ($cellsHtml, $cols, $rows, $size) { $cells = count ($cellsHtml); if ($size == 0) { $localstyle = ""; //" style='width:100%'"; } else { $size = (($size - ($size % 3)) / 3) * 2; // int div 3 * 2 width/heigh ratio $localstyle = " style='width:" . $size . "em;'"; } $return = ""; if ($cells) { if ($rows) { $return = "\n\t
| " . $cellsHtml[$i] . " | "; } $return .= "
| " . $cellsHtml[$idx++] . " | "; } $return .= "
';
$html .= '';
} else {
$html = '
';
}
}
return $html;
}
/**
* Return the icon to move an item DOWN
*
* @access public
* @param int $i The row index
* @param int $n The number of items in the list
* @param boolean $condition True to show the icon
* @param string $task The task to fire
* @param string $alt The image alternate text string
* @return string Either the icon to move an item down or a space
* @since 1.0
*/
function orderDownIcon ($i, $n, $condition = TRUE, $task = 'orderdown', $alt = 'Move Down', $enabled = TRUE) {
$alt = JText::_ ($alt);
$html = ' ';
if ($i < $n - 1) {
if ($enabled) {
$html = '';
$html .= ' 
';
$html .= '';
} else {
$html = '
';
}
}
return $html;
}
static function getValidProductFilterArray () {
static $filterArray;
if (!isset($filterArray)) {
/*
$filterArray = array('p.virtuemart_product_id', 'p.product_sku','pp.product_price','c.category_name','c.category_description',
'm.mf_name', 'l.product_s_desc', 'p.product_desc', 'p.product_weight', 'p.product_weight_uom', 'p.product_length', 'p.product_width',
'p.product_height', 'p.product_lwh_uom', 'p.product_in_stock', 'p.low_stock_notification', 'p.product_available_date',
'p.product_availability', 'p.product_special', 'p.created_on', 'p.modified_on', 'l.product_name', 'p.product_sales',
'p.product_unit', 'p.product_packaging', 'p.intnotes', 'l.metadesc', 'l.metakey', 'p.metarobot', 'p.metaauthor');
}
*/
$filterArray = array('product_name', '`p`.created_on', '`p`.product_sku',
'product_s_desc', 'product_desc','`l`.slug',
'category_name', 'category_description', 'mf_name',
'product_price', '`p`.product_special', '`p`.product_sales', '`p`.product_availability', '`p`.product_available_date',
'`p`.product_height', '`p`.product_width', '`p`.product_length', '`p`.product_lwh_uom',
'`p`.product_weight', '`p`.product_weight_uom', '`p`.product_in_stock', '`p`.low_stock_notification',
'`p`.modified_on',
'`p`.product_unit', '`p`.product_packaging', '`p`.virtuemart_product_id', 'pc.ordering');
//other possible fields
//'p.intnotes', this is maybe interesting, but then only for admins or special shoppergroups
// this fields leads to trouble, because we have this fields in product, category and manufacturer,
// they are anyway making not a lot sense for orderby or search.
//'l.metadesc', 'l.metakey', 'l.metarobot', 'l.metaauthor'
}
return $filterArray;
}
/**
* Returns developer information for a plugin
* Returns a 2 link with background image, should look like a button to open contact page or manual
*
* @static
* @param $title string Title of the plugin
* @param $intro string Intro text
* @param $logolink url Url to logo images, use here the path and then as image names contact.png and manual.png
* @param $developer string Name of the developer/company
* @param $contactlink url Url to the contact form of the developer for support
* @param $manlink url URL to the manual for this specific plugin
* @return string
*/
static function display3rdInfo($title,$intro,$developer,$logolink,$contactlink,$manlink,$width='96px',$height='66px',$linesHeight='33px'){
$html = $intro;
$html .= self::displayLinkButton(JText::sprintf('COM_VIRTUEMART_THRD_PARTY_CONTACT',$developer),$contactlink, $logolink.'/contact.png',$width,$height,$linesHeight);
$html .=''; $html .= self::displayLinkButton(JText::sprintf('COM_VIRTUEMART_THRD_PARTY_MANUAL',$title),$manlink, $logolink.'/manual.png',$width,$height,$linesHeight); return $html; } static function displayLinkButton($title, $link, $bgrndImage,$width,$height,$linesHeight,$additionalStyles=''){ //$lineHeight = ((int)$height)/$lines; //vmdebug('displayLinkButton '.$height.' '.$lineHeight); $html = '
'
.''.$title .'
';
return $html;
}
static $tested = False;
static function checkSafePath($safePath=0){
if($safePath==0) {
$safePath = VmConfig::get('forSale_path',0);
if(self::$tested) return $safePath;
}
$warn = FALSE;
$uri = JFactory::getURI();
$configlink = $uri->root() . 'administrator/index.php?option=com_virtuemart&view=config';
VmConfig::loadJLang('com_virtuemart');
if(empty($safePath)){
$warn = 'COM_VIRTUEMART_WARN_NO_SAFE_PATH_SET';
} else {
$exists = JFolder::exists($safePath);
if(!$exists){
$warn = 'COM_VIRTUEMART_WARN_SAFE_PATH_WRONG';
} else{
if(!is_writable( $safePath )){
VmConfig::loadJLang('com_virtuemart_config');
VmWarn('COM_VIRTUEMART_WARN_SAFE_PATH_NOT_WRITEABLE',JText::_('COM_VIRTUEMART_ADMIN_CFG_MEDIA_FORSALE_PATH'),$safePath,$configlink);
} else {
if(!is_writable(self::getInvoicePath($safePath) )){
VmConfig::loadJLang('com_virtuemart_config');
VmWarn('COM_VIRTUEMART_WARN_SAFE_PATH_INV_NOT_WRITEABLE',JText::_('COM_VIRTUEMART_ADMIN_CFG_MEDIA_FORSALE_PATH'),$safePath,$configlink);
}
}
}
}
if($warn){
$suggestedPath=shopFunctions::getSuggestedSafePath();
VmConfig::loadJLang('com_virtuemart_config');
VmWarn($warn,JText::_('COM_VIRTUEMART_ADMIN_CFG_MEDIA_FORSALE_PATH'),$suggestedPath,$configlink);
return FALSE;
}
return $safePath;
}
/*
* get The invoice Folder Name
* @return the invoice folder name
*/
static function getInvoiceFolderName() {
return 'invoices' ;
}
/*
* get The invoice path
* @param $safePath the safepath from the config
* @return the path where the invoice are stored
*/
static function getInvoicePath($safePath) {
return $safePath.self::getInvoiceFolderName() ;
}
/*
* Returns the suggested safe Path, used to store the invoices
* @static
* @return string: suggested safe path
*/
static public function getSuggestedSafePath() {
$lastIndex= strrpos(JPATH_ROOT,DS);
return substr(JPATH_ROOT,0,$lastIndex).DS.'vmfiles';
}
/*
* @author Valerie Isaksen
*/
static public function renderProductShopperList ($productShoppers) {
$html = '';
$i=0;
if(empty($productShoppers)) return '';
foreach ($productShoppers as $email => $productShopper) {
$html .= '