function cyrilic2lat($str)
{
$tr = array(
"А"=>"a", "Б"=>"b", "В"=>"v", "Г"=>"g", "Д"=>"d",
"Е"=>"e", "Ё"=>"yo", "Ж"=>"zh", "З"=>"z", "И"=>"i",
"Й"=>"j", "К"=>"k", "Л"=>"l", "М"=>"m", "Н"=>"n",
"О"=>"o", "П"=>"p", "Р"=>"r", "С"=>"s", "Т"=>"t",
"У"=>"u", "Ф"=>"f", "Х"=>"kh", "Ц"=>"ts", "Ч"=>"ch",
"Ш"=>"sh", "Щ"=>"sch", "Ъ"=>"", "Ы"=>"y", "Ь"=>"",
"Э"=>"e", "Ю"=>"yu", "Я"=>"ya", "а"=>"a", "б"=>"b",
"в"=>"v", "г"=>"g", "д"=>"d", "е"=>"e", "ё"=>"yo",
"ж"=>"zh", "з"=>"z", "и"=>"i", "й"=>"j", "к"=>"k",
"л"=>"l", "м"=>"m", "н"=>"n", "о"=>"o", "п"=>"p",
"р"=>"r", "с"=>"s", "т"=>"t", "у"=>"u", "ф"=>"f",
"х"=>"kh", "ц"=>"ts", "ч"=>"ch", "ш"=>"sh", "щ"=>"sch",
"ъ"=>"", "ы"=>"y", "ь"=>"", "э"=>"e", "ю"=>"yu",
"я"=>"ya", "ß"=>"ss", "ţ"=>"t", "ľ"=>"l", "ľ"=>"l",
","=>"", ";"=>"", "!"=>"", "%"=>"", "#"=>"", "$"=>"",
"&"=>"", "?"=>"", "."=>"", "="=>"", "/"=>"", ":"=>"",
"+"=>"", "–"=>"", "("=>"", ")"=>"", "["=>"", "]"=>"",
"{"=>"", "}"=>"", "’"=>"", "'"=>"", "\""=>"", "”"=>"", "„"=>"", "°"=>""
);
return strtr($str,$tr);
}
function coolURI($string, $separator = '') {
if ($separator=='') { $separator = '-'; }
if (StrLen($separator)>1) { $separator = $separator[0]; }
$string = cyrilic2lat($string);
$sChar = array('/ą/', '/ż/', '/ź/', '/ę/', '/ć/', '/ń/', '/ó/', '/ł/', '/ś/', '/Ą/', '/Ż/', '/Ź/', '/Ę/', '/Ć/', '/Ń/', '/Ó/', '/Ł/', '/Ś/');
$dChar = array('a', 'z', 'z', 'e', 'c', 'n', 'o', 'l', 's', 'A', 'Z', 'Z', 'E', 'C', 'N', 'O', 'L', 'S');
$string = preg_replace( $sChar, $dChar, $string );
$string = strip_tags(html_entity_decode(trim($string)));
$string = iconv("UTF-8","windows-1250"."//TRANSLIT",$string);
$cString1 ="\xc1\xc9\xcd\xd3\xda\xdd\xe1\xe9\xed\xf3\xfa\xfd\xc2\xca\xce\xd4\xdb\xe2\xea\xee\xf4\xfb\xc0\xc8\xcc\xd2\xd9\xe0\xe8\xec\xf2\xf9\xc4\xcb\xcf\xd6\xdc\xe4\xeb\xef\xf6\xfc\xc3\xe3\xd5\xf5\xc5\xe5\xd1\xf1\xc7\xe7\xba\xaa\x8e\x9e\x9d\x8d\xd8\xf8\x8a\x9a";
$cString2 = 'AEIOUYaeiouyAEIOUaeiouACENUrcenuAEIOUaedouAaOoLlNnCcsSZztTRrSs';
$string = strtr($string , $cString1, $cString2);
$string = StrTr($string, ' ', $separator);
$string = StrTr($string, $cString1, $cString2);
$string = StrToLower($string);
return urlencode($string);
}
function coolCode($string) {
$string = cyrilic2lat($string);
$string = strip_tags(html_entity_decode(trim($string)));
$string = iconv("UTF-8","windows-1250"."//TRANSLIT",$string);
$sChar = array('/ą/', '/ż/', '/ź/', '/ę/', '/ć/', '/ń/', '/ó/', '/ł/', '/ś/', '/Ą/', '/Ż/', '/Ź/', '/Ę/', '/Ć/', '/Ń/', '/Ó/', '/Ł/', '/Ś/');
$dChar = array('a', 'z', 'z', 'e', 'c', 'n', 'o', 'l', 's', 'A', 'Z', 'Z', 'E', 'C', 'N', 'O', 'L', 'S');
$string = preg_replace( $sChar, $dChar, $string );
$cString1 ="\xc1\xc9\xcd\xd3\xda\xdd\xe1\xe9\xed\xf3\xfa\xfd\xc2\xca\xce\xd4\xdb\xe2\xea\xee\xf4\xfb\xc0\xc8\xcc\xd2\xd9\xe0\xe8\xec\xf2\xf9\xc4\xcb\xcf\xd6\xdc\xe4\xeb\xef\xf6\xfc\xc3\xe3\xd5\xf5\xc5\xe5\xd1\xf1\xc7\xe7\xba\xaa\x8e\x9e\x9d\x8d\xd8\xf8\x8a\x9a";
$cString2 = 'AEIOUYaeiouyAEIOUaeiouACENUrcenuAEIOUaedouAaOoLlNnCcsSZztTRrSs';
$text = strtr($text , $cString1, $cString2);
$string = StrTr($string, ' ', '');
$string = StrTr($string, $cString1, $cString2);
$string = StrToLower($string);
return $string;
}
function getYoutubeCode($url)
{
$exist = strpos($url, "=");
$exist1 = strpos($url, "youtube");
if((!$exist) or (!$exist1)){
$error="1";
return $error;
}
else{
$similar = strstr($url, "youtube.com");
$exp = explode("=", $similar);
$code = trim($exp[1]);
return $code;
}
}
function comboWorldStates($country_id = 0)
{
global $webSetting;
$query = "select
countries.country_id as country_id,
countries.code as code,
countries_data.title as title
from (countries, countries_data)
where (countries.country_id=countries_data.country_id) and (countries_data.lang_id=".$webSetting["lang_id"].") and (countries.publish='1')
order by countries.code asc";
@$result = mysql_query($query);
$str = '';
while ($res = mysql_fetch_array($result))
{
$str .= '';
}
return $str;
}
function getPreface($string, $length)
{
$str = Strip_Tags($string);
if (StrLen($string)>$length)
{
$str = SubStr($str, 0, $length);
$position = StrRpos($str, ' ');
$str = SubStr($str, 0, $position);
$str .= '...';
}
return $str;
}
/*function dropBR($text)
{
$text = eregi_replace (" ", " ", $text);
$textArray = Split(" ", $text);
$text = "";
for ($j=0; $j<=count($textArray); $j++)
{
$text .= $textArray[$j];
}
return $text;
}
function pageFullPath($page_id, $lang_id)
{
global $currentPath;
$query = "select
pages.page_id as page_id,
pages.parent_id as parent_id,
pages_data.title as title
from (pages, pages_data)
where (pages.page_id=$page_id) and
(pages_data.lang_id='$lang_id') and
(pages.page_id=pages_data.page_id)";
$result = mysql_query($query);
$res = mysql_fetch_array($result);
if (trim($res["title"])!='') { $currentPath = coolURI(trim($res["title"]), '-').'/'.$currentPath; }
if ($res["parent_id"]>0) { pageFullPath($res["parent_id"], $lang_id); }
return $currentPath;
}
function pageFullTitlePath($page_id, $lang_id)
{
global $currentTitlePath;
$query = "select
pages.page_id as page_id,
pages.parent_id as parent_id,
pages_data.title as title
from (pages, pages_data)
where (pages.page_id=$page_id) and
(pages_data.lang_id='$lang_id') and
(pages.page_id=pages_data.page_id)";
$result = mysql_query($query);
$res = mysql_fetch_array($result);
if (trim($res["title"])!='') { $currentTitlePath = ' > '.trim($res["title"]).$currentTitlePath; }
if ($res["parent_id"]>0) { pageFullTitlePath($res["parent_id"], $lang_id); }
return $currentTitlePath;
}
function comboPagesPath($page_id, $parent_id, $pages_category_id, $parentID, $path)
{
global $str;
global $adminSetting;
if ($parentID=='O') { $str = ''; }
$query = "select
pages.page_id as page_id,
pages.pages_category_id as pages_category_id,
pages.publish as publish,
pages.date_created as date_created,
pages.order_no as order_no,
pages_data.title as title
from (pages, pages_data)
where (pages.parent_id='$parentID') and (pages.page_id<>$page_id)
and (pages_category_id='$pages_category_id') and
(pages_data.lang_id='".$adminSetting["default_lang"]."') and
(pages.page_id=pages_data.page_id)
order by pages.order_no asc, pages_data.title asc";
$result = mysql_query($query);
while($res = mysql_fetch_array($result))
{
$currentPath = $path;
if ($currentPath!='') { $currentPath .= ' > '; }
$currentPath .= $res["title"];
if($res["page_id"] == $parent_id) { $str .= ' '.$currentPath.' '; }
else { $str .= ''.$currentPath.' '; }
comboPagesPath($page_id, $parent_id, $pages_category_id, $res["page_id"], $currentPath);
}
return $str;
}
function comboPagesMap($page_id, $virtual_id, $parentID, $path, $pageType)
{
global $str;
global $adminSetting;
if ($parentID=='O') { $str = ''; }
$query = "select
pages.page_id as page_id,
pages.pages_category_id as pages_category_id,
pages.publish as publish,
pages.date_created as date_created,
pages.order_no as order_no,
pages_data.title as title,
pages_category.order_no as pages_order_no,
pages_category_data.title as pages_category_title
from (pages, pages_data, pages_category, pages_category_data)
where (pages.parent_id='$parentID') and (pages.page_id<>$page_id) and (pages_category.pages_category_id=pages.pages_category_id) and
(pages_category.pages_category_id=pages_category_data.pages_category_id) and (pages_category_data.lang_id='".$adminSetting["default_lang"]."') and
(pages_data.lang_id='".$adminSetting["default_lang"]."') and
(pages.page_id=pages_data.page_id)";
if ($pageType=='real') { $query .= " and (pages.virtual_page=0)"; }
elseif ($pageType=='virtual') { $query .= " and (pages.virtual_page>0)"; }
$query .= "order by pages_category.order_no, pages.order_no asc, pages_data.title asc";
// echo ($query);
$result = mysql_query($query);
while($res = mysql_fetch_array($result))
{
$currentPath = $path;
if ($currentPath!='') { $currentPath .= ' > '; }
else { $currentPath = $res["pages_category_title"].' > '; }
$currentPath .= $res["title"];
if($res["page_id"] == $virtual_id) { $str .= ''.$currentPath.' '; }
else { $str .= ''.$currentPath.' '; }
comboPagesMap($page_id, $virtual_id, $res["page_id"], $currentPath, $pageType);
}
return $str;
}
function comboSetRelatedPages($page_id, $relatedPages, $parentID, $path, $pageType)
{
global $str;
global $adminSetting;
if ($parentID=='O') { $str = ''; }
$query = "select
pages.page_id as page_id,
pages.pages_category_id as pages_category_id,
pages.publish as publish,
pages.date_created as date_created,
pages.order_no as order_no,
pages_data.title as title,
pages_category.order_no as pages_order_no,
pages_category_data.title as pages_category_title
from (pages, pages_data, pages_category, pages_category_data)
where (pages.parent_id='$parentID') and (pages.page_id<>$page_id) and (pages.page_id not in ($relatedPages)) and (pages_category.pages_category_id=pages.pages_category_id) and
(pages_category.pages_category_id=pages_category_data.pages_category_id) and (pages_category_data.lang_id='".$adminSetting["default_lang"]."') and
(pages_data.lang_id='".$adminSetting["default_lang"]."') and
(pages.page_id=pages_data.page_id)";
if ($pageType=='real') { $query .= " and (pages.virtual_page=0)"; }
elseif ($pageType=='virtual') { $query .= " and (pages.virtual_page>0)"; }
$query .= "order by pages_category.order_no, pages.order_no asc, pages_data.title asc";
// echo ($query);
$result = mysql_query($query);
while($res = mysql_fetch_array($result))
{
$currentPath = $path;
if ($currentPath!='') { $currentPath .= ' > '; }
else { $currentPath = $res["pages_category_title"].' > '; }
$currentPath .= $res["title"];
$str .= ''.$currentPath.' ';
comboSetRelatedPages($page_id, $relatedPages, $res["page_id"], $currentPath, $pageType);
}
return $str;
}
function comboPagesCategory($pages_category_id)
{
global $adminSetting;
$query = "select
pages_category.pages_category_id as pages_category_id,
pages_category.order_no as order_no,
pages_category_data.title as title
from (pages_category, pages_category_data)
where (pages_category_data.lang_id='".$adminSetting["default_lang"]."') and (pages_category.pages_category_id=pages_category_data.pages_category_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= '';
}
return $str;
}
function comboPagesCategoryTemplates($pages_category_template_id)
{
global $adminSetting;
$query = "select * from pages_category_templates order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboPageTemplates($page_template_id)
{
global $adminSetting;
$query = "select * from page_templates order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboCatalogueCategoryPath($catalogue_category_id, $parent_id, $parentID, $path)
{
global $str;
global $adminSetting;
if ($parentID=='O') { $str = ''; }
$query = "select
catalogue_category.catalogue_category_id as catalogue_category_id,
catalogue_category.publish as publish,
catalogue_category.date_created as date_created,
catalogue_category.order_no as order_no,
catalogue_category.code as code,
catalogue_category_data.title as title
from (catalogue_category, catalogue_category_data)
where (catalogue_category.parent_id='$parentID') and (catalogue_category.catalogue_category_id<>'$catalogue_category_id') and
(catalogue_category_data.lang_id='".$adminSetting["default_lang"]."') and
(catalogue_category.catalogue_category_id=catalogue_category_data.catalogue_category_id)
order by catalogue_category.order_no asc, catalogue_category_data.title asc";
$result = mysql_query($query);
while($res = mysql_fetch_array($result))
{
$currentPath = $path;
if ($currentPath!='') { $currentPath .= ' > '; }
$currentPath .= $res["title"];
if($res["catalogue_category_id"] == $parent_id) { $str .= ' '.$currentPath.' '; }
else { $str .= ''.$currentPath.' '; }
comboCatalogueCategoryPath($catalogue_category_id, $parent_id, $res["catalogue_category_id"], $currentPath);
}
return $str;
}
function catalogueCategoryFullTitlePath($catalogue_category_id, $lang_id)
{
global $currentTitlePath;
$query = "select
catalogue_category.catalogue_category_id as catalogue_category_id,
catalogue_category.parent_id as parent_id,
catalogue_category_data.title as title
from (catalogue_category, catalogue_category_data)
where (catalogue_category.catalogue_category_id=$catalogue_category_id) and
(catalogue_category_data.lang_id='$lang_id') and
(catalogue_category.catalogue_category_id=catalogue_category_data.catalogue_category_id)";
$result = mysql_query($query);
$res = mysql_fetch_array($result);
if (trim($res["title"])!='')
{
if ($currentTitlePath!='') { $currentTitlePath = ' > '.$currentTitlePath; }
$currentTitlePath = trim($res["title"]).$currentTitlePath;
}
if ($res["parent_id"]>0) { catalogueCategoryFullTitlePath($res["parent_id"], $lang_id); }
return $currentTitlePath;
}
function catalogueCategoryFullPath($catalogue_category_id, $lang_id)
{
global $currentPath;
$query = "select
catalogue_category.catalogue_category_id as catalogue_category_id,
catalogue_category.parent_id as parent_id,
catalogue_category_data.title as title
from (catalogue_category, catalogue_category_data)
where (catalogue_category.catalogue_category_id=$catalogue_category_id) and
(catalogue_category_data.lang_id='$lang_id') and
(catalogue_category.catalogue_category_id=catalogue_category_data.catalogue_category_id)";
$result = mysql_query($query);
$res = mysql_fetch_array($result);
if (trim($res["title"])!='')
{
if ($currentPath!='') { $currentPath = '/'.$currentPath; }
$currentPath = trim(coolURI($res["title"], '-')).$currentPath;
}
if ($res["parent_id"]>0) { catalogueCategoryFullPath($res["parent_id"], $lang_id); }
return $currentPath;
}
function catalogueCategoryPath($catalogue_category_id, $parentID, $path)
{
global $str;
global $adminSetting;
global $b;
if ($parentID=='O') { $str = ''; }
$query = "select
catalogue_category.catalogue_category_id as catalogue_category_id,
catalogue_category.publish as publish,
catalogue_category.date_created as date_created,
catalogue_category.order_no as order_no,
catalogue_category.code as code,
catalogue_category_data.title as title
from (catalogue_category, catalogue_category_data)
where (catalogue_category.parent_id='$parentID') and
(catalogue_category_data.lang_id='".$adminSetting["default_lang"]."') and
(catalogue_category.catalogue_category_id=catalogue_category_data.catalogue_category_id)
order by catalogue_category.order_no asc, catalogue_category_data.title asc";
$result = mysql_query($query);
while($res = mysql_fetch_array($result))
{
$currentPath = $path;
if ($currentPath!='') { $currentPath .= ' > '; }
$currentPath .= $res["title"];
if ($b == 1) { $b = 2; }
else { $b = 1; }
$str .= '
0) { $str .= ' checked'; }
$str .= ' />
'.$res["code"].'
'.$currentPath.'
'.$res["title"].'
';
if ($res["order_no"]>0) { $str .= ''.$res["order_no"].' '; }
$str .= '
';
catalogueCategoryPath($catalogue_category_id, $res["catalogue_category_id"], $currentPath);
}
return $str;
}
function catalogueProductCategoryRelations($catalogue_category_id, $parentID, $path)
{
global $str;
global $adminSetting;
global $catalogueProductCategoryRelation;
if ($parentID=='O') { $str = ''; $treeCount = 0; }
$query = "select
catalogue_category.catalogue_category_id as catalogue_category_id,
catalogue_category.publish as publish,
catalogue_category.date_created as date_created,
catalogue_category.order_no as order_no,
catalogue_category_data.title as title
from (catalogue_category, catalogue_category_data)
where (catalogue_category.parent_id='$parentID') and
(catalogue_category_data.lang_id='".$adminSetting["default_lang"]."') and
(catalogue_category.catalogue_category_id=catalogue_category_data.catalogue_category_id)
order by catalogue_category.order_no asc, catalogue_category_data.title asc";
$result = mysql_query($query);
if (mysql_num_rows($result)>0)
{
$str .= '
';
}
return $str;
}
function comboSetRelatedCatalogueProducts($catalogue_product_id, $relatedProducts)
{
global $adminSetting;
$query = "select
catalogue_products.catalogue_product_id as catalogue_product_id,
catalogue_products.publish as publish,
catalogue_products.order_no as order_no,
catalogue_products.code as code,
catalogue_products.price_1 as price_1,
catalogue_products.price_2 as price_2,
catalogue_products.catalogue_brand_id as catalogue_brand_id,
catalogue_brands_data.title as catalogue_brand_title,
catalogue_products_data.title as title
from (catalogue_products, catalogue_products_data)
left join catalogue_brands on (catalogue_products.catalogue_brand_id=catalogue_brands.catalogue_brand_id)
left join catalogue_brands_data on (catalogue_brands_data.lang_id='".$adminSetting["default_lang"]."') and (catalogue_brands.catalogue_brand_id=catalogue_brands_data.catalogue_brand_id)
where
(catalogue_products.catalogue_product_id not in ($relatedProducts)) and
(catalogue_products_data.lang_id='".$adminSetting["default_lang"]."') and (catalogue_products.catalogue_product_id=catalogue_products_data.catalogue_product_id)
order by order_no asc, title asc";
$result = mysql_query($query);
while($res = mysql_fetch_array($result))
{
$thisProductTitle = trim($res["catalogue_brand_title"].' '.$res["title"]);
if ($res["code"]!='') { $thisProductTitle = '['.$res["code"].'] '.$thisProductTitle; }
$str .= ''.$thisProductTitle.' ';
}
return $str;
}
function comboWorldStatesRegion($country_id, $state_region_id)
{
global $adminSetting;
$query = "select * from countries_regions where (country_id='$country_id') and (publish='1') order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= '';
}
return $str;
}
function comboCatalogueBrands($catalogue_brand_id)
{
global $adminSetting;
$query = "select
catalogue_brands.catalogue_brand_id as catalogue_brand_id,
catalogue_brands.publish as publish,
catalogue_brands.order_no as order_no,
catalogue_brands_data.title as title
from (catalogue_brands, catalogue_brands_data)
where (catalogue_brands_data.lang_id='".$adminSetting["default_lang"]."') and (catalogue_brands.catalogue_brand_id=catalogue_brands_data.catalogue_brand_id)
order by order_no asc, title asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboCatalogueProductUnits($catalogue_product_unit_id)
{
global $adminSetting;
$query = "select
catalogue_product_units.catalogue_product_unit_id as catalogue_product_unit_id,
catalogue_product_units.publish as publish,
catalogue_product_units.order_no as order_no,
catalogue_product_units_data.title as title
from (catalogue_product_units, catalogue_product_units_data)
where (catalogue_product_units_data.lang_id='".$adminSetting["default_lang"]."') and (catalogue_product_units.catalogue_product_unit_id=catalogue_product_units_data.catalogue_product_unit_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboCatalogueProductParameters($catalogue_product_parameter_id, $type)
{
global $adminSetting;
$query = "select
catalogue_product_parameters.catalogue_product_parameter_id as catalogue_product_parameter_id,
catalogue_product_parameters.publish as publish,
catalogue_product_parameters.order_no as order_no,
catalogue_product_parameters_data.title as title
from (catalogue_product_parameters, catalogue_product_parameters_data)
where (catalogue_product_parameters_data.lang_id='".$adminSetting["default_lang"]."') and (catalogue_product_parameters.catalogue_product_parameter_id=catalogue_product_parameters_data.catalogue_product_parameter_id)";
if ($type!='') { $query .= " and catalogue_product_parameters.type='$type'"; }
$query .=" order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboCatalogueProductsParamValues($catalogue_product_parmeter_id, $catalogue_product_parameter_value_id)
{
global $adminSetting;
$query = "select
catalogue_product_parameter_values.catalogue_product_parameter_value_id as catalogue_product_parameter_value_id,
catalogue_product_parameter_values.publish as publish,
catalogue_product_parameter_values.order_no as order_no,
catalogue_product_parameter_values_data.title as title
from (catalogue_product_parameter_values, catalogue_product_parameter_values_data)
where (catalogue_product_parameter_values_data.lang_id='".$adminSetting["default_lang"]."') and
(catalogue_product_parameter_values.catalogue_product_parameter_id='$catalogue_product_parmeter_id') and
(catalogue_product_parameter_values.catalogue_product_parameter_value_id=catalogue_product_parameter_values_data.catalogue_product_parameter_value_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboEshopTax($rate)
{
global $adminSetting;
$query = "select * from eshop_tax where (publish='1') order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboEshopCurrency($currency_id)
{
global $adminSetting;
$query = "select * from eshop_currency order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboOrderStatus($order_status_id, $user_defined)
{
global $adminSetting;
$query = "select
order_status.order_status_id as order_status_id,
order_status.order_no as order_no,
order_status_data.title as title
from (order_status, order_status_data)
where (order_status_data.lang_id='".$adminSetting["default_lang"]."') and (order_status.order_status_id=order_status_data.order_status_id) ";
if ($user_defined!='') { $query .= " and (order_status.user_defined='$user_defined') "; }
$query.= "order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboCustomerGroups($customer_group_id)
{
global $adminSetting;
$query = "select
customer_groups.customer_group_id as customer_group_id,
customer_groups.order_no as order_no,
customer_groups_data.title as title
from (customer_groups, customer_groups_data)
where (customer_groups_data.lang_id='".$adminSetting["default_lang"]."') and (customer_groups.customer_group_id=customer_groups_data.customer_group_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboCustomerAddresses($customer_id, $customer_address_id)
{
global $adminSetting;
$query = "select * from (customer_addresses) where (customer_id='$customer_id') order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboRestaurantFoodTypes($restaurant_food_type_id)
{
global $adminSetting;
$query = "select
restaurant_food_types.restaurant_food_type_id as restaurant_food_type_id,
restaurant_food_types.order_no as order_no,
restaurant_food_types_data.title as title
from (restaurant_food_types, restaurant_food_types_data)
where (restaurant_food_types_data.lang_id='".$adminSetting["default_lang"]."') and (restaurant_food_types.restaurant_food_type_id=restaurant_food_types_data.restaurant_food_type_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboRestaurantFoods($restaurant_food_id, $restaurant_food_type_id)
{
global $adminSetting;
$query = "select
restaurant_foods.restaurant_food_id as restaurant_food_id,
restaurant_foods.publish as publish,
restaurant_foods.restaurant_food_type_id as restaurant_food_type_id,
restaurant_foods.price as price,
restaurant_foods_data.title as title,
restaurant_food_types.order_no as order_no,
restaurant_food_types_data.title as food_type_title
from (restaurant_foods, restaurant_foods_data, restaurant_food_types, restaurant_food_types_data)
where (restaurant_foods_data.lang_id='".$adminSetting["default_lang"]."') and (restaurant_foods.restaurant_food_id=restaurant_foods_data.restaurant_food_id) and
(restaurant_food_types_data.lang_id='".$adminSetting["default_lang"]."') and (restaurant_food_types.restaurant_food_type_id=restaurant_food_types_data.restaurant_food_type_id) and (restaurant_foods.restaurant_food_type_id=restaurant_food_types.restaurant_food_type_id)";
if ($restaurant_food_type_id>0) { $query .= " and (restaurant_foods.restaurant_food_type_id in ($restaurant_food_type_id))"; }
$query .= " order by restaurant_food_types.order_no asc, restaurant_foods_data.title asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboContactOffices($contact_office_id)
{
global $adminSetting;
$query = "select
contact_offices.contact_office_id as contact_office_id,
contact_offices.order_no as order_no,
contact_offices_data.title as title
from (contact_offices, contact_offices_data)
where (contact_offices_data.lang_id='".$adminSetting["default_lang"]."') and (contact_offices.contact_office_id=contact_offices_data.contact_office_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboContactdepartments($contact_department_id)
{
global $adminSetting;
$query = "select
contact_departments.contact_department_id as contact_department_id,
contact_departments.order_no as order_no,
contact_departments_data.title as title
from (contact_departments, contact_departments_data)
where (contact_departments_data.lang_id='".$adminSetting["default_lang"]."') and (contact_departments.contact_department_id=contact_departments_data.contact_department_id)
order by order_no asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function comboAttachmentExtensions($ext)
{
global $adminSetting;
$query = "select
distinct(trim(upper(extension))) as extension
from attachments
order by extension asc";
@$result = mysql_query($query);
while ($res = mysql_fetch_array($result))
{
$str .= ' ';
}
return $str;
}
function pagesList($parentID, $categoryLimit, $fulltext)
{
global $adminSetting;
if ($fulltext=='Fulltextové vyhledávání') { $fulltext = ''; }
$query = "select
pages.page_id as page_id,
pages.pages_category_id as pages_category_id,
pages.publish as publish,
pages.date_created as date_created,
pages.order_no as order_no,
pages_data.title as title,
pages_category.order_no as pages_category_order_no,
pages_category_data.title as pages_category_title
from (pages_category, pages_category_data, pages, pages_data)
where
(pages_data.lang_id='".$adminSetting["default_lang"]."') and
(pages.page_id=pages_data.page_id) and
(pages_category_data.lang_id='".$adminSetting["default_lang"]."') and
(pages_category.pages_category_id=pages_category_data.pages_category_id) and
(pages.pages_category_id=pages_category.pages_category_id) and
(pages.parent_id='$parentID')";
if ($categoryLimit>0) { $query .= " and (pages.pages_category_id='$categoryLimit')"; }
if ($fulltext!='') { $query .= " and ((upper(pages_data.title) like (upper('%".$fulltext."%'))) or (upper(pages_data.description) like (upper('%".$fulltext."%'))) or (upper(pages_data.keywords) like (upper('%".$fulltext."%'))) or (upper(pages_data.content_prefix) like (upper('%".$fulltext."%'))) or (upper(pages_data.content_main) like (upper('%".$fulltext."%'))) or (upper(pages_data.content_suffix) like (upper('%".$fulltext."%'))))"; }
$query .= " order by pages_category_order_no asc, order_no asc";
//echo nl2br($query);
$result = mysql_query($query);
$str = '
';
return $str;
}
function pageCategoryMap($parentID, $categoryID)
{
global $adminSetting;
global $pagesCategoryOrder;
if ($pagesCategoryOrder[$categoryID]!='') { $orderBy = $pagesCategoryOrder[$categoryID]; }
else { $orderBy = 'order_no asc'; }
$query = "select
pages.page_id as page_id,
pages.pages_category_id as pages_category_id,
pages.publish as publish,
pages.date_created as date_created,
pages.order_no as order_no,
pages_data.title as title,
pages_category.order_no as pages_category_order_no,
pages_category_data.title as pages_category_title
from (pages_category, pages_category_data, pages, pages_data)
where
(pages_data.lang_id='".$adminSetting["default_lang"]."') and
(pages.page_id=pages_data.page_id) and
(pages_category_data.lang_id='".$adminSetting["default_lang"]."') and
(pages_category.pages_category_id=pages_category_data.pages_category_id) and
(pages.pages_category_id=pages_category.pages_category_id) and
(pages.parent_id='$parentID') and (pages.pages_category_id='".$categoryID."')
order by ".$orderBy;
$result = mysql_query($query);
if (mysql_num_rows($result)>0)
{
$str .= '
';
}
return $str;
}
function RMD2DMR($datum)
{
$DatumPole = Explode("-", $datum);
$Datum = $DatumPole[2].'.'.$DatumPole[1].'.'.$DatumPole[0];
return $Datum;
}
function DMR2RMD($datum)
{
$DatumPole = Explode(".", $datum);
$Datum = $DatumPole[2].'-'.$DatumPole[1].'-'.$DatumPole[0];
return $Datum;
}
function RMDHM2DMRHM($datum, $separator)
{
$DateTime = $datum[8].$datum[9].'.'.$datum[5].$datum[6].'.'.$datum[0].$datum[1].$datum[2].$datum[3].' '.$separator.' '.$datum[11].$datum[12].':'.$datum[14].$datum[15];
return $DateTime;
}
function DMRHM2RMDHM($datum, $separator)
{
$dt = Explode($separator, $datum);
$DatumPole = Explode(".", $dt[0]);
$DateTime = $DatumPole[2].'-'.$DatumPole[1].'-'.$DatumPole[0].' '.$dt[1].':00';
return $DateTime;
}
function formatFileSize($size)
{
if (($size>1000) and ($size<1000000))
{
$fileSize = ($size/1000);
$fileSize = Number_Format($fileSize, 2, ",", ".").' kB';
}
elseif ($size>=1000000)
{
$fileSize = ($size/1000000);
$fileSize = Number_Format($fileSize, 2, ",", ".").' MB';
}
else
{
$fileSize = $size;
$fileSize = Number_Format($fileSize, 2, ",", ".").' B';
}
return $fileSize;
}
function dayName($no)
{
$day[1] = 'Neděle';
$day[2] = 'Pondělí';
$day[3] = 'Úterý';
$day[4] = 'Středa';
$day[5] = 'Čtvrtek';
$day[6] = 'Pátek';
$day[7] = 'Sobota';
$title = $day[$no];
return $title;
}
class water_mark {
public static function apply($watermark, $img, $destination, $position, $opacity) {
$watermark = imagecreatefrompng($watermark);
$watermark_width = imagesx($watermark);
$watermark_height = imagesy($watermark);
$image = imagecreatetruecolor($watermark_width, $watermark_height);
$image = imagecreatefromjpeg($img);
$size = getimagesize($img);
if ($position=='0% 0%') { $dest_x=0; $dest_y=0; }
if ($position=='100% 0%') { $dest_x=$size[0]-$watermark_width; $dest_y=0; }
if ($position=='50% 50%') { $dest_x=($size[0]/2)-($watermark_width/2); $dest_y=($size[1]/2)-($watermark_height/2); }
if ($position=='100% 100%') { $dest_x=$size[0]-$watermark_width; $dest_y=$size[1]-$watermark_height; }
if ($position=='0% 100%') { $dest_x=0; $dest_y=$size[1]-$watermark_height; }
// Vlozim transparentni vodoznk se 100% krytim (kvuli vyhlazeni hran)
imagecopy($image, $watermark, $dest_x, $dest_y, 0, 0, $watermark_width, $watermark_height);
// Znovu vlozim original s prednastavenou pruhlednosti
$image2=imagecreatefromjpeg($img);
imagecopymerge($image, $image2, 0, 0, 0, 0, $size[0], $size[1], $opacity);
imagejpeg($image, $destination, 100);
imagedestroy($image);
imagedestroy($image2);
imagedestroy($watermark);
}
}*/
?>
JCC | Dřevěné polotovary Dřevěné polotovary JCC Sestavte si rychle a jednoduše DVEŘNÍ KŘÍDLA, KAZETY, PŘEKLIŽKY a SPOJOVACÍ PANELY přesně dle Vašich požadavků.
Využijte široké možnosti variant a mějte neustálý přehled o ceně aktuální konfigurace. Objednejte a do týdne máte hotový výrobek!
Naše produkty
Překližka Voděodolná překližka vyráběná na míru
5 dřevin | jednostranná-oboustranná | frézovatelná-nefrézovatelná | 5 tlouštěk
Více o produktu Dveřní kazeta Tepelně-izolační dveřní kazeta vyráběná na míru
5 dřevin | frézovatelná-nefrézovatelná-s nákližkem | 2 typy rádiusů u nákližků
Více o produktu
Napište nám
Rychlá navigace
Produkty
Odkazy Tato webová stránka používá cookies
K personalizaci obsahu a reklam, poskytování funkcí sociálních médií a analýze naší návštěvnosti využíváme soubory cookie. Informace o tom, jak náš web používáte, sdílíme se svými partnery pro sociální média, inzerci a analýzy. Partneři tyto údaje mohou zkombinovat s dalšími informacemi, které jste jim poskytli nebo které získali v důsledku toho, že používáte jejich služby.
Nastavení preferencí
Informace o cookies
Zde máte možnost přizpůsobit soubory cookie podle kategorií, v souladu s vlastními preferencemi.
Běžné cookies pro provoz webu
Nutné cookies pomáhají, aby byla webová stránka použitelná tak, že umožní základní funkce jako navigace stránky a přístup k zabezpečeným sekcím webové stránky. Webová stránka nemůže správně fungovat bez těchto cookies.
Vylepšují funkce webových stránek tím, že sledují pohyb a aktivitu návštěvníku na nich.
Analytické cookies pomáhají majitelům webových stránek, aby porozuměli, jak návštěvníci používají webové stránky. Anonymně sbírají a sdělují informace.