* All rights reserved
*
* This script is part of the TYPO3 project. The TYPO3 project is
* free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* The GNU General Public License can be found at
* http://www.gnu.org/copyleft/gpl.html.
*
* This script is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
/**
* [CLASS/FUNCTION INDEX of SCRIPT]
*
* Hint: use extdeveval to insert/update function index above.
*/
global $ms,$get,$server,$post;
class mslib_fe
{
/**
* @param test admin panel $ms_menu
* @param type of the menu $type
* @return string
*/
function createAdminPanel($ms_menu,$type='header')
{
$admin_content='';
$total_tabs=count($ms_menu);
$tab_counter=0;
foreach ($ms_menu as $tablevel1_key => $tablevel1)
{
$tab_counter++;
$admin_content.='
';
if (!$tablevel1['label'] and $tablevel1['description'])
{
$admin_content.=$tablevel1['description'];
}
else
{
if (!is_array($tablevel1['subs']))
{
if ($tablevel1['link'])
{
$admin_content.=''.$tablevel1['label'].'';
}
else
{
$admin_content.=$tablevel1['label'];
}
}
else
{
$total_tablevel2=count($tablevel1['subs']);
$counter_tablevel2=0;
if ($tablevel1['link'])
{
$admin_content.=''.$tablevel1['label'].'';
}
else
{
$admin_content.=''.$tablevel1['label'].'';
}
$admin_content.='
';
foreach ($tablevel1['subs'] as $tablevel2_key => $tablevel2)
{
$counter_tablevel2++;
if ($type=='header' and ($counter_tablevel2==$total_tablevel2)) $tablevel2_params='dropdown_bottom';
elseif ($type=='footer' and ($counter_tablevel2==1)) $tablevel2_params='dropdown_top';
else $tablevel2_params='';
if ($tablevel2['divider'])
{
$admin_content.='';
continue;
}
if (!is_array($tablevel2['subs']))
{
$admin_content.='
0 ? ",":"") . $products_options_values['products_options_values_id'].':{"prefix":"'.$products_options_values['price_prefix'].'","val":'.$products_options_values['options_values_price'].'}';
}
else
{
if ( ($sessionData['attributes'][$options['products_options_id']] == $products_options_values['products_options_values_id']))
{
$items.=$products_options_values['products_options_values_name'].'';
}
}
$next_index2++;
}
$json_attributes .= '}';
if ($total_values > 0)
{
if (!$readonly)
{
switch ($options['listtype'])
{
case 'input':
case 'checkbox':
break;
default:
if ($total_values > 1)
{
$items=''."\n";
}
break;
}
$output.=$items;
}
}
if (!$readonly) $output.='
' . "\n";
if ($readonly) $output.='';
}
}
$output.='
';
} else {
$json_attributes .= "'0':'yes'";
}
$json_attributes .= '}';
//$output .= $json_attributes;
if (!$readonly and $total_rows)
{
$output .= '
';
}
return $output;
}
function ProductHasAttributes($products_id){
if (!is_numeric($products_id)) {
return false;
}
$str="select popt.products_options_id, popt.products_options_name from tx_multishop_products_options popt, tx_multishop_products_attributes patrib where patrib.products_id='" . (int) $products_id. "' and popt.hide_in_cart=0 and patrib.options_id = popt.products_options_id group by popt.products_options_id order by popt.products_options_id";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
if ($GLOBALS['TYPO3_DB']->sql_num_rows($qry) > 0)
{
return true;
} else {
return false;
}
}
function getTaxRate ($tax_id)
{
$str="SELECT * from static_taxes where uid='".$tax_id."'";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry);
return $row['tx_rate'];
}
function getProduct($products_id,$categories_id='',$extra_fields='',$include_disabled_products=0)
{
global $ms;
if (!is_numeric($products_id)) {
return false;
}
if (!$ms['MODULES']['FLAT_DATABASE'] or $include_disabled_products)
{
//pd.products_meta_title, pd.products_shortdescription, pd.products_meta_keywords,
$str="SELECT *,p.staffel_price as staffel_price, tr.tx_rate as tax_rate, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ".($extra_fields?', '.$extra_fields:'')." from tx_multishop_products p left join tx_multishop_specials s on p.products_id = s.products_id left join static_taxes tr on p.tax_id = tr.uid, tx_multishop_products_description pd, tx_multishop_products_to_categories p2c, tx_multishop_categories c, tx_multishop_categories_description cd where ".(!$include_disabled_products?' p.products_status=1 and ':'')." p.products_id='".$products_id."' and pd.language_id='".$this->sys_language_uid."' and cd.language_id=pd.language_id and p.products_id=pd.products_id and p.products_id=p2c.products_id and p2c.categories_id=c.categories_id and p2c.categories_id=cd.categories_id ";
if ($categories_id) $str.=" and p2c.categories_id='".$categories_id."'";
}
else
{
$str="SELECT * from tx_multishop_products_flat where products_id='".$products_id."' and language_id='".$this->sys_language_uid."'";
}
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$product=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry);
return $product;
}
function getNextPreviousProduct($products_id,$categories_id='')
{
global $ms;
if (!is_numeric($products_id)) {
return false;
}
if (!$ms['MODULES']['FLAT_DATABASE'])
{
$str="SELECT pd.products_name, p.products_id, c.categories_id from tx_multishop_products p, tx_multishop_products_description pd, tx_multishop_products_to_categories p2c, tx_multishop_categories c, tx_multishop_categories_description cd where p.products_status=1 and c.categories_id='".$categories_id."' and pd.language_id='".$this->sys_language_uid."' and cd.language_id=pd.language_id and p.products_id=pd.products_id and p.products_id=p2c.products_id and c.categories_id=p2c.categories_id and c.categories_id=cd.categories_id order by p2c.sort_order asc";
}
else
{
$str="SELECT products_name, products_id, categories_id from tx_multishop_products_flat where categories_id='".$categories_id."' order by sort_order asc";
}
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$count=0;
$products=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$products[]=$row['products_id'];
}
$total=count($products);
$pagination_items=array();
$trans = array_flip($products);
$internal=$trans[$products_id];
if ($internal==0)
{
$pagination_items['next_item']=$products[1];
}
else
{
$pagination_items['previous_item']=$products[($internal-1)];
$pagination_items['next_item']=$products[($internal+1)];
}
foreach ($pagination_items as $key => $item)
{
if ($item)
{
// get all cats to generate multilevel fake url
$level=0;
$cats=mslib_fe::Crumbar($categories_id);
$cats=array_reverse($cats);
$where='';
if (count($cats) > 0)
{
foreach ($cats as $cat)
{
$where.="categories_id[".$level."]=".$cat['id']."&";
$level++;
}
$where=substr($where,0,(strlen($where)-1));
$where.='&';
}
// get all cats to generate multilevel fake url eof
$link=mslib_fe::typolink($this->shop_pid,'&'.$where.'&products_id='.$item.'&tx_multishop_pi1[page_section]=products_detail');
$pagination_items[$key]=$link;
}
}
$pagination_items['internal'] =$internal;
$pagination_items['total'] =$total;
return $pagination_items;
}
/*
this method is used to request the products page set
$filter can be an string or (multiple) array:
string example: p2c.categories_id=12
array example: $filter[]='p2c.categories_id=12'
*/
function getProductsPageSet($filter=array(),$offset=0,$limit=0,$orderby=array(),$having=array(),$select=array(),$where=array(),$redirect_if_one_product=0,$extra_from=array())
{
global $ms;
if ($ms['MODULES']['SHOW_PRODUCTS_WITH_IMAGE_FIRST'])
{
if (!$ms['MODULES']['FLAT_DATABASE'])
{
$prefix='p.';
}
else $prefix='pf.';
$tmp_orderby=array();
$tmp_orderby[]=$prefix.'contains_image desc';
$tmp_orderby[]=$prefix.'sort_order '.$ms['MODULES']['PRODUCTS_LISTING_SORT_ORDER_OPTION'];
if (!is_array($orderby) and $orderby)
{
$tmp_orderby[]=$orderby;
}
else
{
$tmp_orderby=array_merge($tmp_orderby,$orderby);
}
$orderby=$tmp_orderby;
}
if (!$limit) $limit=$ms['MODULES']['PRODUCTS_LISTING_LIMIT'];
if (!is_numeric($offset)) $offset=0;
if (!$ms['MODULES']['FLAT_DATABASE'])
{
$groupby_clause=' GROUP BY p.products_id ';
// do normal search (join the seperate tables)
$required_cols='p.minimum_quantity, pd.products_viewed,pd.products_url,p.products_id,p.products_image,p.products_image1,p.products_date_added,p.products_model,p.products_quantity,p.products_price,p.staffel_price as staffel_price,IF(s.status, s.specials_new_products_price, p.products_price) as final_price,p.products_date_available,p.tax_id,tr.tx_rate as tax_rate,p.manufacturers_id,pd.products_name,pd.products_shortdescription,c.categories_id,cd.categories_name';
if ($ms['MODULES']['INCLUDE_PRODUCTS_DESCRIPTION_DB_FIELD_IN_PRODUCTS_LISTING'])
{
$required_cols.=',pd.products_description';
}
$select_clause="SELECT ".$required_cols;
if (count($select)>0)
{
$select_clause.=', ';
$select_clause.=implode(",",$select);
}
$from_clause.=" from tx_multishop_products p left join tx_multishop_specials s on p.products_id = s.products_id left join static_taxes tr on p.tax_id = tr.uid, tx_multishop_products_description pd, tx_multishop_products_to_categories p2c, tx_multishop_categories c, tx_multishop_categories_description cd ";
if (count($extra_from))
{
$from_clause.=", ";
$from_clause.=implode(",",$extra_from);
}
$where_clause.=" where p.products_status=1 ";
if (!$this->masterShop)
{
$where_clause.=" and p.page_uid='".$this->showCatalogFromPage."' ";
}
$where_clause.=" and pd.language_id='".$this->sys_language_uid."' ";
if (is_array($where) and count($where)>0)
{
$where_clause.='and ';
$where_clause.=implode(",",$where);
}
$where_clause.=' and ';
if (is_array($filter) and count($filter) >0) $where_clause.=implode(" and ",$filter)." and ";
elseif ($filter) $where_clause.=$filter." and ";
$where_clause.=" pd.language_id=cd.language_id and p.products_id=p2c.products_id and p.products_id=pd.products_id and p2c.categories_id=c.categories_id and p2c.categories_id=cd.categories_id ";
if (count($having) >0)
{
$having_clause.=" having ";
foreach ($having as $item)
{
$having_clause.=$item;
}
}
if (is_array($orderby) and count($orderby)>0)
{
$str_order_by.=implode(",",$orderby);
}
elseif ($orderby) $str_order_by.=$orderby;
else $str_order_by.='p2c.sort_order '.$ms['MODULES']['PRODUCTS_LISTING_SORT_ORDER_OPTION'];
if ($str_order_by) $orderby_clause.=" order by ".$str_order_by;
}
else
{
// flat mode database mode. This module is used on LARGE catalogs, so the joins of individual tables are minimized
// do the flat search (without having to join the seperate tables)
$required_cols='pf.minimum_quantity,pf.products_viewed,pf.products_url,pf.products_id,pf.products_image,pf.products_image1,pf.products_model,pf.products_quantity,pf.products_price,pf.staffel_price,pf.final_price,pf.products_date_added,pf.products_date_available,pf.tax_id,pf.tax_rate,pf.manufacturers_id,pf.products_name,pf.products_shortdescription,pf.categories_id,pf.categories_name,pf.categories_name_0,pf.categories_name_1,pf.categories_name_2,pf.categories_name_3';
if ($ms['MODULES']['INCLUDE_PRODUCTS_DESCRIPTION_DB_FIELD_IN_PRODUCTS_LISTING'])
{
$required_cols.=',pf.products_description';
}
if ($ms['MODULES']['FLAT_DATABASE_EXTRA_ATTRIBUTE_OPTION_COLUMNS'] and is_array($ms['FLAT_DATABASE_ATTRIBUTE_OPTIONS']))
{
$attribute_cols='';
foreach ($ms['FLAT_DATABASE_ATTRIBUTE_OPTIONS'] as $option_id => $array)
{
if ($array[0] and $array[1])
{
$attribute_cols.="pf.".$array[0].',';
}
}
$attribute_cols=preg_replace("/\,$/","",$attribute_cols);
if ($attribute_cols) $required_cols.=','.$attribute_cols;
}
$select_clause="SELECT ".$required_cols;
if (is_array($select) and count($select)>0)
{
$select_clause.=', ';
$select_clause.=implode(",",$select);
}
$from_clause.=" from tx_multishop_products_flat pf ";
if (count($extra_from))
{
$from_clause.=", ";
$from_clause.=implode(",",$extra_from);
}
if (is_array($where) and count($where)>0)
{
$where_clause.=implode(",",$where);
}
if (is_array($filter) and count($filter) >0)
{
if ($where_clause) $where_clause.=' and ';
$where_clause.=implode(" and ",$filter);
}
elseif ($filter)
{
if ($where_clause) $where_clause.=' and ';
$where_clause.=$filter;
}
if (!$this->masterShop)
{
if ($where_clause) $where_clause.=" and ";
$where_clause.=" pf.page_uid='".$this->showCatalogFromPage."' ";
}
if ($where_clause) $where_clause=" where ".$where_clause;
if (count($having) >0)
{
$having_clause.=" having ";
foreach ($having as $item)
{
$having_clause.=$item;
}
}
if (is_array($orderby) and count($orderby)>0)
{
$str_order_by.=implode(",",$orderby);
}
elseif ($orderby) $str_order_by.=$orderby;
if ($str_order_by) $orderby_clause.=" order by ".$str_order_by;
}
$limit_clause.=' LIMIT '.$offset.','.$limit;
$array=array();
if (!$ms['MODULES']['FLAT_DATABASE'])
{
if (count($having))
{
// since this query is using HAVING we need to calculate the total records on a different way
$str="select p.products_id,IF(s.status, s.specials_new_products_price, p.products_price) as final_price ".$from_clause.$where_clause.$groupby_clause.$having_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array['total_rows']=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
}
else
{
// the select count(1) is buggy when working with group by and 1-n relations (1 product to many categories). therefore we temporary counting through sql_num_rows
$str="select p.products_id ".$from_clause.$where_clause.$groupby_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array['total_rows']=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
/*
$str="select count(1) as total ".$from_clause.$where_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry);
$array['total_rows']=$row['total'];
*/
}
}
else
{
$str="select count(1) as total ".$from_clause.$where_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry);
$array['total_rows']=$row['total'];
}
// now do the real query including the order by and the limit
$str=$select_clause.$from_clause.$where_clause.$groupby_clause.$having_clause.$orderby_clause.$limit_clause;
#t3lib_div::devLog('MSLIB_FE SEARCH '.$str, 'multishop',1,$where);
/*
//$GLOBALS['TSFE']->fe_user->user['username']=='base'
if ($this->ROOTADMIN_USER)
{
echo $str;
die();
}
*/
// error_log($str);
// echo $str."\n\n";
// error_log($array['total_rows']);
// error_log($str);
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$rows=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
if ($rows > 0)
{
while ($product=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array['products'][]=$product;
}
if (count($array['products']) == 1 and $redirect_if_one_product)
{
$where='';
$product=$array['products'][0];
if ($product['categories_id'])
{
// get all cats to generate multilevel fake url
$level=0;
$cats=mslib_fe::Crumbar($product['categories_id']);
$cats=array_reverse($cats);
$where='';
if (count($cats) > 0)
{
foreach ($cats as $cat)
{
$where.="categories_id[".$level."]=".$cat['id']."&";
$level++;
}
$where=substr($where,0,(strlen($where)-1));
$where.='&';
}
// get all cats to generate multilevel fake url eof
}
if ($product['products_url'] and $ms['MODULES']['AFFILIATE_SHOP']) $link=$product['products_url'];
else $link=mslib_fe::typolink($this->shop_pid,'&'.$where.'&products_id='.$product['products_id'].'&tx_multishop_pi1[page_section]=products_detail');
if ($link)
{
header("Location: ".$this->FULL_HTTP_URL.$link);
exit();
}
}
}
return $array;
}
/*
this method is used to request the admin customers page set
$filter can be an string or (multiple) array:
string example: p2c.categories_id=12
array example: $filter[]='p2c.categories_id=12'
*/
function getCustomersPageSet($filter=array(),$offset=0,$limit=0,$orderby=array(),$having=array(),$select=array(),$where=array())
{
global $ms;
if (!$limit) $limit=30;
if (!is_numeric($offset)) $offset=0;
// do normal search (join the seperate tables)
$required_cols='f.*';
$select_clause="SELECT ".$required_cols;
if (count($select)>0)
{
$select_clause.=', ';
$select_clause.=implode(",",$select);
}
$from_clause.=" from fe_users f ";
$where_clause.=" where ";
if (count($where)>0)
{
$where_clause.=implode(",",$where);
$where_clause.=' and ';
}
if (is_array($filter) and count($filter) >0) $where_clause.=implode(" and ",$filter)." and ";
elseif ($filter) $where_clause.=$filter." and ";
$where_clause.=" f.username !=''";
if (count($having) >0)
{
$having_clause.=" having ";
foreach ($having as $item)
{
$having_clause.=$item;
}
}
if (is_array($orderby) and count($orderby)>0)
{
$str_order_by.=implode(",",$orderby);
}
elseif ($orderby) $str_order_by.=$orderby;
else $str_order_by.="";
if ($str_order_by) $orderby_clause.=" order by ".$str_order_by;
$limit_clause.=' LIMIT '.$offset.','.$limit;
$array=array();
// $array['total_rows']=$row2[0];
// retrieve the total number of records
// $str=$select_clause.", count(1) as total ".$from_clause.$where_clause.$having_clause;
$str=$select_clause.$from_clause.$where_clause.$having_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array['total_rows']=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
// now do the query
$str=$select_clause.$from_clause.$where_clause.$having_clause.$orderby_clause.$limit_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$rows=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
// $qry2=$GLOBALS['TYPO3_DB']->sql_query("SELECT FOUND_ROWS();");
// $row2=$GLOBALS['TYPO3_DB']->sql_fetch_row($qry2);
if ($rows > 0)
{
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array['customers'][]=$row;
}
}
return $array;
}
function getCustomerGroupsPageSet($filter=array(),$offset=0,$limit=0,$orderby=array(),$having=array(),$select=array(),$where=array())
{
global $ms;
if (!$limit) $limit=30;
if (!is_numeric($offset)) $offset=0;
// do normal search (join the seperate tables)
$required_cols='f.*';
$select_clause="SELECT ".$required_cols;
if (count($select)>0)
{
$select_clause.=', ';
$select_clause.=implode(",",$select);
}
$from_clause.=" from fe_groups f ";
$where_clause.=" where ";
if (count($where)>0)
{
$where_clause.=implode(",",$where);
$where_clause.=' and ';
}
if (is_array($filter) and count($filter) >0) $where_clause.=implode(" and ",$filter)." and ";
elseif ($filter) $where_clause.=$filter." and ";
$where_clause.=" f.title !=''";
if (count($having) >0)
{
$having_clause.=" having ";
foreach ($having as $item)
{
$having_clause.=$item;
}
}
if (is_array($orderby) and count($orderby)>0)
{
$str_order_by.=implode(",",$orderby);
}
elseif ($orderby) $str_order_by.=$orderby;
else $str_order_by.="";
if ($str_order_by) $orderby_clause.=" order by ".$str_order_by;
$limit_clause.=' LIMIT '.$offset.','.$limit;
$array=array();
// $array['total_rows']=$row2[0];
// retrieve the total number of records
// $str=$select_clause.", count(1) as total ".$from_clause.$where_clause.$having_clause;
$str=$select_clause.$from_clause.$where_clause.$having_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array['total_rows']=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
// now do the query
$str=$select_clause.$from_clause.$where_clause.$having_clause.$orderby_clause.$limit_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$rows=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
// $qry2=$GLOBALS['TYPO3_DB']->sql_query("SELECT FOUND_ROWS();");
// $row2=$GLOBALS['TYPO3_DB']->sql_fetch_row($qry2);
if ($rows > 0)
{
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array['groups'][]=$row;
}
}
return $array;
}
/*
this method is used to request the stores page set
$filter can be an string or (multiple)
*/
function getStoresPageSet($filter=array(),$offset=0,$limit=0,$orderby=array(),$having=array(),$select=array(),$where=array())
{
global $ms;
if (!$limit) $limit=30;
if (!is_numeric($offset)) $offset=0;
// do normal search (join the seperate tables)
$required_cols='mss.address,mss.zip,mss.city,mss.telephone,mss.fax, mss.id, mss.name, mssd.description';
$select_clause="SELECT ".$required_cols;
if (count($select)>0)
{
$select_clause.=', ';
$select_clause.=implode(",",$select);
}
$from_clause.=" from tx_multishop_stores mss, tx_multishop_stores_description mssd ";
$where_clause.=" where ";
if (count($where)>0)
{
$where_clause.=implode(",",$where);
$where_clause.=' and ';
}
if (is_array($filter) and count($filter) >0) $where_clause.=implode(" and ",$filter)." and ";
elseif ($filter) $where_clause.=$filter." and ";
$where_clause.=" mss.status ='1' and mssd.language_id='".$this->sys_language_uid."' and mss.id=mssd.id ";
if (count($having) >0)
{
$having_clause.=" having ";
foreach ($having as $item)
{
$having_clause.=$item;
}
}
if (is_array($orderby) and count($orderby)>0)
{
$str_order_by.=implode(",",$orderby);
}
elseif ($orderby) $str_order_by.=$orderby;
else $str_order_by.="";
if ($str_order_by) $orderby_clause.=" order by ".$str_order_by;
$limit_clause.=' LIMIT '.$offset.','.$limit;
$array=array();
// $array['total_rows']=$row2[0];
// retrieve the total number of records
// $str=$select_clause.", count(1) as total ".$from_clause.$where_clause.$having_clause;
$str=$select_clause.$from_clause.$where_clause.$having_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array['total_rows']=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
// now do the query
$str=$select_clause.$from_clause.$where_clause.$having_clause.$orderby_clause.$limit_clause;
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$rows=$GLOBALS['TYPO3_DB']->sql_num_rows($qry);
// $qry2=$GLOBALS['TYPO3_DB']->sql_query("SELECT FOUND_ROWS();");
// $row2=$GLOBALS['TYPO3_DB']->sql_fetch_row($qry2);
if ($rows > 0)
{
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array['stores'][]=$row;
}
}
return $array;
}
function getSubcats(&$subcategories_array, $parent_id = 0)
{
$subcategories_query = $GLOBALS['TYPO3_DB']->sql_query("select categories_id from tx_multishop_categories where page_uid='".$this->showCatalogFromPage."' and status = '1' and parent_id = '" . $parent_id . "'");
while ($subcategories = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($subcategories_query))
{
$subcategories_array[sizeof($subcategories_array)] = $subcategories['categories_id'];
if ($subcategories['categories_id'] != $parent_id)
{
mslib_fe::getSubcats($subcategories_array, $subcategories['categories_id']);
}
}
}
/*
limit number of products
page_uid the pid of the core shop page
content_uid the uid of the content object for unique css id naming
*/
function SpecialsBox ($contentType, $limit=5, $page_uid='',$content_uid='')
{
global $ms,$get,$server;
set_include_path(t3lib_extMgm::extPath('multishop').PATH_SEPARATOR.t3lib_extMgm::extPath('multishop').'scripts/front_pages/');
switch ($contentType)
{
case 'home':
if ($ms['MODULES']['HOME_SPECIALS_BOX']) include('products_specials.php');
break;
case 'single_special':
include('products_specials.php');
break;
case 'specials_listing_page':
include('products_specials.php');
break;
case 'products_search':
case 'specials_section':
default:
include('products_specials.php');
break;
}
return $content;
}
function getProductMappedMethods($pids=array(),$type='')
{
if (is_array($pids) and count($pids))
{
switch ($type)
{
case 'payment':
// first we load all options
$allmethods=mslib_fe::loadPaymentMethods();
foreach ($pids as $pid)
{
$str="SELECT s.code from tx_multishop_products_method_mappings pmm, tx_multishop_payment_methods s where pmm.type='".$type."' and pmm.products_id = ".$pid." and pmm.method_id=s.id";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array[]=$row['code'];
}
foreach ($allmethods as $key => $value)
{
if (!in_array($key,$array))
{
unset($allmethods[$key]);
}
}
}
break;
case 'shipping':
// first we load all options
/*
$allmethods=mslib_fe::loadShippingMethods();
foreach ($pids as $pid)
{
$str="SELECT s.code from tx_multishop_products_method_mappings pmm, tx_multishop_shipping_methods s where pmm.type='".$type."' and pmm.products_id = ".$pid." and pmm.method_id=s.id";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array[]=$row['code'];
}
foreach ($allmethods as $key => $value)
{
if (!in_array($key,$array))
{
unset($allmethods[$key]);
}
}
}
*/
$allmethods=array();
foreach ($pids as $pid)
{
$str="SELECT s.*,d.description, d.name from tx_multishop_products_method_mappings pmm, tx_multishop_shipping_methods s, tx_multishop_shipping_methods_description d where pmm.type='".$type."' and pmm.products_id = ".$pid." and pmm.method_id=s.id and d.language_id='".$this->sys_language_uid."' and s.id=d.id order by s.sort_order";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$allmethods[$row['code']]=$row;
}
}
break;
}
return $allmethods;
}
}
function loadShippingMethods()
{
$str="SELECT * from tx_multishop_shipping_methods s, tx_multishop_shipping_methods_description d where d.language_id='".$this->sys_language_uid."' and s.id=d.id order by s.sort_order";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array[$row['code']]=$row;
}
return $array;
}
function loadShippingMethod($code)
{
$str="SELECT * from tx_multishop_shipping_methods s, tx_multishop_shipping_methods_description d where s.code='".addslashes($code)."' and s.status=1 and d.language_id='".$this->sys_language_uid."' and s.id=d.id order by s.sort_order";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
return $row;
}
}
function loadPaymentMethods()
{
$str="SELECT * from tx_multishop_payment_methods s, tx_multishop_payment_methods_description d where d.language_id='".$this->sys_language_uid."' and s.id=d.id order by s.sort_order";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
$array[$row['code']]=$row;
}
return $array;
}
function loadPaymentMethod($code)
{
$str="SELECT * from tx_multishop_payment_methods s, tx_multishop_payment_methods_description d where s.code='".addslashes($code)."' and s.status=1 and d.language_id='".$this->sys_language_uid."' s.id=d.id order by s.sort_order";
$qry=$GLOBALS['TYPO3_DB']->sql_query($str);
$array=array();
while ($row=$GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry))
{
return $row;
}
}
function loadAllShippingMethods()
{
$shipping_methods=array();
$shipping_methods['gls']=array(
'name' =>'GLS'
);
$shipping_methods['hermes']=array(
'name' =>'Hermes'
);
$shipping_methods['dhl']=array(
'name' =>'DHL'
);
$shipping_methods['ups']=array(
'name' =>'UPS'
);
$shipping_methods['fedex']=array(
'name' =>'FEDEX'
);
$shipping_methods['tnt']=array(
'name' =>'TNT'
);
$shipping_methods['gpl']=array(
'name' =>'GPL'
);
return $shipping_methods;
}
function loadAllPaymentMethods()
{
global $server;
$payment_methods=array();
// OGONE
$vars=array();
$vars['pspid']['type'] ='input';
$vars['shasign']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$additional_info=array();
$additional_info['1']['label'] = 'Global security parameters / Hash algorithm';
$additional_info['1']['value'] = 'Go to Global security parameters / Hash algorithm and choose: "SHA-512"';
$additional_info['2']['label'] = 'Global security parameters / Character encoding';
$additional_info['2']['value'] = 'Go to Global security parameters / Character encoding and choose: "UTF-8"';
$additional_info['3']['label'] = 'Data and origin verification / Checks for e-Commerce / SHA-IN Pass phrase';
$additional_info['3']['value'] = 'Go to Data and origin verification / Checks for e-Commerce / SHA-IN Pass phrase and fill in your shasign (secret key)';
$additional_info['4']['label'] = 'Transaction feedback / Direct HTTP server-to-server request / URL of the merchant\'s post-payment page';
$additional_info['4']['value'] = 'Go to and fill in the following url: '.$this->FULL_HTTP_URL.mslib_fe::typolink($this->shop_pid.',2002','&tx_multishop_pi1[page_section]=psp_post_payment_ogone');
$additional_info['5']['label'] = 'Transaction feedback / Security for request parameters / SHA-OUT Pass phrase';
$additional_info['5']['value'] = 'Go to Transaction feedback / Security for request parameters / SHA-OUT Pass phrase and fill in your shasign (secret key)';
$payment_methods['ogone']=array(
'name' =>'Ogone',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/ogone/',
'image' =>'ogone.png',
'additional_info' => $additional_info
);
// OGONE EOF
// BUCKAROO
$vars=array();
$vars['bpe_merchant']['type'] ='input';
$vars['secret_key']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$vars['payment_type']['type'] ='radio';
$vars['payment_type']['options'][] ='ideal';
$vars['payment_type']['options'][] ='single_authorization';
$vars['payment_type']['options'][] ='creditcard';
$additional_info=array();
$additional_info['1']['label'] = 'Profiel / Websites / Vertraagde en Push responses';
$additional_info['1']['value'] = 'Enable the checkbox: Activeer Push Response';
$additional_info['2']['label'] = 'Profiel / Websites / Vertraagde en Push responses';
$additional_info['2']['value'] = 'Add the following URL to the field "URI succes": '.$this->FULL_HTTP_URL.mslib_fe::typolink($this->shop_pid.',2002','&tx_multishop_pi1[page_section]=psp_post_payment_buckaroo').' On the "Gebruik HTTP-Method" drop down menu select: POST';
$payment_methods['buckaroo']=array(
'image' =>'buckaroo.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/buckaroo/',
'name' =>'Buckaroo',
'additional_info' => $additional_info
);
// BUCKAROO EOF
// MOLLIE
$vars=array();
$vars['partner_id']['type']='input';
$payment_methods['mollie']=array(
'image' =>'mollie.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/mollie/',
'name' =>'Mollie'
);
// MOLLIE EOF
// MULTISAFEPAY
$vars=array();
$vars['merchant_account']['type']='input';
$vars['merchant_site_id']['type']='input';
$vars['merchant_secret_code']['type']='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['multisafepay']=array(
'image' =>'multisafepay.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/multisafepay/',
'name' =>'Multisafepay'
);
// MULTISAFEPAY EOF
// ADYEN
$vars=array();
$vars['adyen_payment_skincode']['type'] ='input';
$vars['adyen_payment_merchant']['type'] ='input';
$vars['adyen_payment_key']['type'] ='input';
$vars['adyen_payment_hpp_mode']['type'] ='radio';
$vars['adyen_payment_hpp_mode']['options'][] ='single';
$vars['adyen_payment_hpp_mode']['options'][] ='select';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$additional_info=array();
$additional_info['1']['label'] = 'New Skin';
$additional_info['1']['value'] = 'In Adyen account test dashboard Go to Skin and choose appropriate account, and press new to create new skin"';
$additional_info['2']['label'] = 'Skin settings';
$additional_info['2']['value'] = 'Go to Skins and and set few input for the settings ';
$additional_info['2']['value'] .= '1. Result URL for Test: ' . $this->FULL_HTTP_URL.mslib_fe::typolink('','&tx_multishop_pi1[page_section]=adyen_pay')." ";
$additional_info['2']['value'] .= '2. Continue-to URL for Test: ' . $this->FULL_HTTP_URL." ";
$additional_info['2']['value'] .= '3. HMAC Key for Test: fill the password (this one should also be fill in adyen_payment_key)'." ";
$additional_info['2']['value'] .= '4. Result URL for Live: ' . $this->FULL_HTTP_URL.mslib_fe::typolink('','&tx_multishop_pi1[page_section]=adyen_pay')." ";
$additional_info['2']['value'] .= '5. Continue-to URL for Live: ' . $this->FULL_HTTP_URL." ";
$additional_info['2']['value'] .= '6. HMAC Key for Live: fill the password (this one should also be fill in adyen_payment_key)'." ";
$additional_info['2']['value'] .= '7. check the checkbox of the "Valid accounts" for the accounts you don\'t want to relate with the skin (if your Adyen have more than 1 account)'." ";
$additional_info['3']['label'] = 'Transaction feedback / SOAP notification / URL of the merchant\'s post-payment page';
$additional_info['3']['value'] = 'Go to settings and choose appropriate merchant account, paste the following url in Transport URL: '.$this->FULL_HTTP_URL.mslib_fe::typolink($this->shop_pid.',2002','&tx_multishop_pi1[page_section]=adyen_soap_ns')." , check the \"Active\" checkbox and select SOAP in Method input";
$payment_methods['adyen']=array(
'name' =>'Adyen',
'image' =>'adyen.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/adyen/',
'additional_info' => $additional_info
);
// ADYEN EOF
// PAYPAL
$additional_info=array();
$additional_info['1']['label'] = 'Setup Notification URL';
$additional_info['1']['value'] = 'Go to https://www.paypal.com/cgi-bin/webscr?cmd=_profile-ipn-notify';
$additional_info['2']['label'] = 'Specify the following URL:';
$additional_info['2']['value'] = $this->FULL_HTTP_URL.mslib_fe::typolink($this->shop_pid.',2002','&tx_multishop_pi1[page_section]=paypal_ns');
$additional_info['3']['label'] = 'DBB-berichten:';
$additional_info['3']['value'] = 'Enable the check box.';
$vars=array();
$vars['paypal_email_address']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['paypal']=array(
'image' =>'paypal.png',
'country' => 'int',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/paypal/',
'name' =>'Paypal',
'additional_info' => $additional_info
);
// PAYPAL EOF
// RABOBANK
$vars=array();
$vars['pspid']['type'] ='input';
$vars['shasign']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['ideal_rabobank']=array(
'image' =>'rabobank.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/rabobank/',
'name' =>'Ideal Rabobank'
);
// RABOBANK EOF
// RABOBANK LITE
$vars=array();
$vars['merchant_id']['type'] ='input';
$vars['merchant_key']['type'] ='input';
$vars['merchant_subid']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['ideal_rabobank_lite']=array(
'image' =>'rabobank.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/rabobank/',
'name' =>'Ideal Rabobank Lite'
);
// RABOBANK LITE EOF
// RABOBANK PROFESSIONAL
$vars=array();
$vars['merchant_id']['type'] ='input';
$vars['merchant_subid']['type'] ='input';
$vars['private_key_pass']['type'] ='input';
$vars['secure_path']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['ideal_rabobank_professional']=array(
'image' =>'rabobank.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/rabobank/',
'name' =>'Ideal Rabobank Professional'
);
// RABOBANK PROFESSIONAL EOF
// ABN IDEAL
$vars=array();
$vars['pspid']['type'] ='input';
$vars['shasign']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$additional_info=array();
$additional_info['1']['label'] = 'Global security parameters / Hash algorithm';
$additional_info['1']['value'] = 'Go to Global security parameters / Hash algorithm and choose: "SHA-512"';
$additional_info['2']['label'] = 'Global security parameters / Character encoding';
$additional_info['2']['value'] = 'Go to Global security parameters / Character encoding and choose: "UTF-8"';
$additional_info['3']['label'] = 'Data and origin verification / Checks for e-Commerce / SHA-IN Pass phrase';
$additional_info['3']['value'] = 'Go to Data and origin verification / Checks for e-Commerce / SHA-IN Pass phrase and fill in your shasign (secret key)';
$additional_info['4']['label'] = 'Transaction feedback / Direct HTTP server-to-server request / URL of the merchant\'s post-payment page';
$additional_info['4']['value'] = 'Go to and fill in the following url: '.$this->FULL_HTTP_URL.mslib_fe::typolink($this->shop_pid.',2002','&tx_multishop_pi1[page_section]=psp_post_payment_abn_amro');
$additional_info['5']['label'] = 'Transaction feedback / Security for request parameters / SHA-OUT Pass phrase';
$additional_info['5']['value'] = 'Go to Transaction feedback / Security for request parameters / SHA-OUT Pass phrase and fill in your shasign (secret key)';
$payment_methods['ideal_abnamro']=array(
'image' =>'abnamro.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/abn-amro/',
'name' =>'Ideal ABN Amro',
'additional_info' => $additional_info
);
// ABN IDEAL EOF
// ING IDEAL
$vars=array();
$vars['merchant_id']['type'] ='input';
$vars['merchant_key']['type'] ='input';
$vars['merchant_subid']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['ideal_ing']=array(
'image' =>'ing.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/ing/',
'name' =>'Ideal ING'
);
// ING IDEAL EOF
// ING IDEAL ADVANCED
$vars=array();
$vars['merchant_id']['type'] ='input';
$vars['merchant_subid']['type'] ='input';
$vars['private_key_pass']['type'] ='input';
$vars['secure_path']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['ideal_ing_advanced']=array(
'image' =>'ing.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/ing/',
'name' =>'Ideal ING Advanced'
);
// ING IDEAL ADVANCED EOF
// TWYP
$vars=array();
$vars['merchant_id']['type'] ='input';
$vars['merchant_key']['type'] ='input';
$vars['merchant_subid']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['ideal_twyp']=array(
'image' =>'twyp.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/twyp/',
'name' =>'Ideal TWYP'
);
// TWYP EOF
// CHRONOPAY
$vars=array();
$vars['pspid']['type'] ='input';
$vars['shasign']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['chronopay']=array(
'image' =>'chronopay.png',
'country' => 'int',
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/chronopay/',
'name' =>'Chronopay'
);
// CHRONOPAY EOF
// DOCDATA
$vars=array();
$vars['merchant_name']['type'] ='input';
$vars['merchant_password']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$additional_info=array();
$additional_info['1']['label'] = 'Settings / View/Edit Merchant Profile';
$additional_info['1']['value'] = 'Press the URL button and insert the following URL to the the "Update URL" inputfield: '.$this->FULL_HTTP_URL.mslib_fe::typolink($this->shop_pid.',2002','&tx_multishop_pi1[page_section]=psp_post_payment_docdata&mtid=');
$payment_methods['docdata']=array(
'image' =>'docdata.png',
'country' => 'nl',
'vars' =>$vars,
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/docdata/',
'name' =>'Docdata payments',
'additional_info' => $additional_info
);
// DOCDATA EOF
// ICEPAY
$payment_methods['icepay']=array(
'image' =>'icepay.png',
'country' => 'nl',
'more_info_link' =>'http://www.typo3multishop.com/payment-service-providers/icepay/',
'name' =>'Icepay'
);
// ICEPAY EOF
// SUOMEN
$vars=array();
$vars['pspid']['type'] ='input';
$vars['shasign']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$payment_methods['suomen_verkkomaksut']=array(
'image' =>'suomen_verkkomaksut.png',
'country' => 'fi',
'vars' =>$vars,
'more_info_link' =>'',
'name' =>'Suomen Verkkomaksut'
);
// SUOMEN EOF
// MONERIS ESELECT
$vars=array();
$vars['ps_store_id']['type'] ='input';
$vars['hpp_key']['type'] ='input';
$vars['test']['type'] ='radio';
$vars['test']['options'][] ='true';
$vars['test']['options'][] ='false';
$vars['autosubmit']['type'] ='radio';
$vars['autosubmit']['options'][] ='true';
$vars['autosubmit']['options'][] ='false';
$vars['open_in_new_window']['type'] ='radio';
$vars['open_in_new_window']['options'][] ='true';
$vars['open_in_new_window']['options'][] ='false';
$vars['country']['type'] ='radio';
$vars['country']['options'][] ='Canada';
$vars['country']['options'][] ='US';
$additional_info=array();
$additional_info['1']['label'] = 'Creating test account';
$additional_info['1']['value'] = 'Go to ADMIN and create a version 3 configuration';
$additional_info['2']['label'] = 'Modifying the Hosted Paypage Configuration';
$additional_info['2']['value'] = 'Response Method: select: Sent to your server as a POST containing XML ';
$additional_info['2']['value'] .= 'Approved URL: '.$this->FULL_HTTP_URL.'moneris/approve_url/ ';
$additional_info['2']['value'] .= 'Decline URL: '.$this->FULL_HTTP_URL.'moneris/decline_url/ ';
$additional_info['2']['value'] .= 'Cancel URL: '.$this->FULL_HTTP_URL.'moneris/cancel_url/ ';
$additional_info['3']['label'] = 'MOD Rewrite rules';
$additional_info['3']['value'] = 'Unfortunately Moneris doesn\'t allow us to send arrayed variables, so we have to do a workaround to bypass this problem. Add the following code to the .htaccess file in the root of your TYPO3 web site.