function lhg_insert_overview_table($products)
{
//echo "<br>Num Prod:".count($products);
//echo "<br>ID: ".$products[0]["shop_id"];
//print_r($products);
//only amazon, then skip
//$region == get_region();
global $region;
//echo "<br>REG: $region";
if ($region == "de") {
$amazon_shop_id = 4;
}
//echo "ASID: $amazon_shop_id";
if (count($products) == 1 && $products[0]["shop_id"] == $amazon_shop_id) {
//only Amazon
//skip
} elseif (count($products) == 0) {
//nothing found
//skip
} elseif (count($products) == 1) {
//only one found, which is already shown as main square
//skip
} elseif (count($products) == 1 && $products[0]["shop_id"] == -1) {
//something strange e.g. only Amazon on .com sites
//skip
} else {
$price_meta = "USD";
if ($region == "de") {
$price_meta = "EUR";
}
if ($region == "it") {
$price_meta = "EUR";
}
if ($region == "fr") {
$price_meta = "EUR";
}
if ($region == "es") {
$price_meta = "EUR";
}
if ($region == "com") {
$price_meta = "USD";
}
if ($region == "co.uk") {
$price_meta = "GBP";
}
if ($region == "co.jp") {
$price_meta = "JPY";
}
if ($region == "cn") {
$price_meta = "CNY";
}
if ($region == "ca") {
$price_meta = "CAD";
}
if ($region == "in") {
$price_meta = "INR";
}
$vspacer = '<div class="spacer" style="border-top: 1px solid #2b8fc3; height: 0px; margin-top: 9px; margin-bottom: 9px;"></div>';
echo $vspacer;
global $txt_lhgdb_overview;
global $txt_lhgdb_exclporto;
global $txt_lhgdb_inclporto;
echo "<b>{$txt_lhgdb_overview}:</b>";
echo "<br />\n <table>";
for ($i = 0; $i < count($products); $i++) {
$shop_img = lhg_get_shop_small_icon($products[$i]["shop_id"]);
$shop_name = lhg_get_shop_name($products[$i]["shop_id"]);
$shop_name_long = lhg_get_shop_long_name($products[$i]["shop_id"]);
//print "$i: ".$products[$i]["shop_id"]."<br>";
// print "$i: ".$products[$i]["last_update"]."<br>";
if (strpos($shop_name, "mazon") > 0 or strpos($products[$i]["shipping"], "ULL") > 0) {
// no shipping costs available
echo '<tr><td>EUR ' . lhg_float_to_currency_string($products[$i]["price"] + $products[$i]["shipping"], $region) . '<br /><div class="portoline">' . $txt_lhgdb_exclporto . '</div>
</td><td valign="middle"><a href="' . $products[$i]["url"] . '" rel="nofollow">
<img src="' . $shop_img . '" style="border: 1px solid #2B8FC3;" title="' . $shop_name_long . '" alt="' . $shop_name_long . '" /></a></td>';
#<td>
#<a href="'.$products[$i]["url"].'" rel="nofollow">'.$shop_name.'</a></td></tr>';
} else {
echo '<tr><td>EUR ' . lhg_float_to_currency_string($products[$i]["price"] + $products[$i]["shipping"], $region) . '<br /><div class="portoline">' . $txt_lhgdb_inclporto . ': ' . lhg_float_to_currency_string($products[$i]["shipping"], $region) . ' EUR</div></td><td valign="middle"><a href="' . $products[$i]["url"] . '" rel="nofollow">
<img src="' . $shop_img . '" style="border: 1px solid #2B8FC3;" title="' . $shop_name_long . '"></a></td>';
#<td>
#<a href="'.$products[$i]["url"].'" rel="nofollow">'.$shop_name.'</a></td></tr>';
}
}
echo "</table>";
}
}
function lhg_country_row($p_region, $URLC, $URLD, $posturlcom, $posturlde)
{
# store url to be available globally (e.g. by wp-one-post-widget)
global $posturlcom_glob;
global $posturlde_glob;
$posturlcom = $posturlcom_glob;
$posturlde = $posturlde_glob;
global $post;
global $txt_out_of_stock;
global $region;
$selected = "";
if ($region == $p_region) {
$selected = 'class="ct_pricetop" ';
}
#print "URLD: $URLD -- $posturlde<br>";
print "<tr {$selected}>";
#print "PID: $post->ID";
# get the correct postid for .com and .de server
$relevant_postid = $post->ID;
if ($lang == "de") {
$relevant_postid = lhg_get_postid_de_from_com($post->ID);
}
$price = lhg_db_get_cheapest_price_by_region($relevant_postid, $p_region);
$price = lhg_float_to_currency_string($price, $p_region);
if ($price == 0) {
$price = $txt_out_of_stock;
$txt_currency = "";
} else {
$txt_currency = lhg_get_currency_symbol($p_region);
$price = $price;
}
#if ($p_region == "de"){
#
# print "PRI: $price<br>";
# # ToDo: need access to .de database or Amazon prices to be stored on priceDB
# $price = "-";
# $txt_currency = "";
#}
echo '<td class="ct_country"> ';
if ($p_region == "de") {
$URL_add = '/';
$flag = "de";
$country = "Germany";
}
if ($p_region == "ca") {
$URL_add = '/ca/';
$flag = "ca";
$country = "Canada";
}
if ($p_region == "com") {
$URL_add = '/';
$flag = "us";
$country = "USA";
}
if ($p_region == "co.uk") {
$URL_add = '/uk/';
$flag = "uk";
$country = "United Kingdom";
}
if ($p_region == "fr") {
$URL_add = '/fr/';
$flag = "fr";
$country = "France";
}
if ($p_region == "es") {
$URL_add = '/es/';
$flag = "es";
$country = "Espana";
}
if ($p_region == "it") {
$URL_add = '/it/';
$flag = "it";
$country = "Italia";
}
if ($p_region == "nl") {
$URL_add = '/nl/';
$flag = "nl";
$country = "Netherlands";
}
if ($p_region == "in") {
$URL_add = '/in/';
$flag = "in";
$country = "India";
}
if ($p_region == "co.jp") {
$URL_add = '/ja/';
$flag = "jp";
$country = "Japan";
}
if ($p_region == "cn") {
$URL_add = '/zh/';
$flag = "cn";
$country = "China";
}
if ($p_region == "de") {
$URL = $URLD . $URL_add . $posturlde;
}
if ($p_region != "de") {
$URL = $URLC . $URL_add . $posturlcom;
}
echo '<a href="' . $URL . '"><img src="/wp-content/plugins/qtranslate/flags/' . $flag . '.png" alt="' . $country . '" /> ' . $country . '</a></td>';
echo '<td class="ct_price">' . $price . '</td>';
echo '<td class="ct_currency">' . $txt_currency . '</td>';
echo '<td class="ct_comment">';
# comment number
#not yet implemented for "de"
#if ($p_region == "de"){
# echo "-";
#}else{
lhg_comments_number_language($p_region, $p_region, 0, $post->ID, "shortversion");
#}
echo '</td></tr>';
}
function lhg_get_shop_button($postid)
{
global $region;
global $txt_on_stock;
global $txt_out_of_stock;
global $txt_shipping;
global $txt_tooltip2;
global $txt_button;
global $txt_not_avail_at;
global $txt_price;
global $txt_search_at;
global $txt_preorder;
global $txt_buy_from;
global $txt_shipping_costs;
$tooltip = $txt_tooltip2;
//"Die von Amazon zur Verfügung gestellten Preise sind exklusive möglicherweise zusätzlich anfallender Versandkosten (abhängig vom jeweiligen Anbieter des Amazon-Marketplace).";
//$button .= "PID: $postid<br>";
$shopid = lhg_db_get_cheapest_supplier_id($postid);
$products = lhg_get_sorted_products($shopid, $postid, false);
$url = $products[0]["url"];
$price = $products[0]["price"];
#+$products[0]["shipping"];
#$price_total = $products[0]["price"]+$products[0]["shipping"];
$shipping = $products[0]["shipping"];
$shipping = lhg_float_to_currency_string($shipping, $region);
$price = lhg_float_to_currency_string($price, $region);
$name = lhg_get_shop_long_name($shopid);
$txt_currency = lhg_get_currency_symbol($region);
//format button depending on availability
if ($shopid != "") {
//product available at a shop
$price_meta = "USD";
if ($region == "de") {
$price_meta = "EUR";
}
if ($region == "it") {
$price_meta = "EUR";
}
if ($region == "fr") {
$price_meta = "EUR";
}
if ($region == "nl") {
$price_meta = "EUR";
}
if ($region == "es") {
$price_meta = "EUR";
}
if ($region == "com") {
$price_meta = "USD";
}
if ($region == "co.uk") {
$price_meta = "GBP";
}
if ($region == "co.jp") {
$price_meta = "JPY";
}
if ($region == "cn") {
$price_meta = "CNY";
}
if ($region == "ca") {
$price_meta = "CAD";
}
if ($region == "in") {
$price_meta = "INR";
}
$schema_start = '<div itemprop="offers" itemscope itemtype="http://schema.org/Offer">';
$schema_end = '</div>';
$button_string = '<i class="icon-shopping-cart icon-large3"></i> ' . $txt_buy_from . ' ' . $name;
$price_string = $txt_price . ': ' . $txt_currency . ' <span itemprop="price">' . $price . '</span>
<meta itemprop="priceCurrency" content="' . $price_meta . '" />
<span itemprop="availability" itemtype="http://schema.org/InStock" class="instock">
(' . $txt_on_stock . ')
</span>';
$shipping_string = '<span class="shippingcosts">
(+ ' . $txt_shipping_costs . ': ' . $txt_currency . ' ' . $shipping . ')
</span>';
//unknown shipping costs for Amazon, add warning
if (strpos($name, "mazon") > 0) {
$shipping_string = '<font size="1">
(' . $txt_shipping . ')</font>
<span class="tooltip">' . tooltip($tooltip) . '</span>
';
}
//no shipping costs in DB
if (strpos($products[0]["shipping"], "ULL") > 0) {
$shipping_string = '<font size="1">
(' . $txt_shipping . ')
</font>';
}
} elseif ($region == "nl") {
//currently no Amazon.de shown
} else {
// see if we have "Check Amazon for pricing"
$meta = "price-amazon." . $region;
$aprice = get_post_meta($postid, $meta, true);
#print "AP: $aprice";
if ($aprice != "Check Amazon For Pricing") {
$aid = get_id();
//nowhere available! not even in Amazon catalog
//
$region_tmp = $region;
if ($region == "nl") {
$region_tmp = "de";
}
$price_string = '<span class="outofstock">(' . $txt_out_of_stock . ')</span>
<br /><div class="amazon-cr"></div>' . $txt_never_avail_at . '
<a target="_blank" href="http://www.amazon.' . $region_tmp . '/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag=' . $aid . '" rel="nofollow">
Amazon.' . $region_tmp . '
</a>
<div class="amazon-cr"></div>';
$button_string = '<i class="icon-search icon-large3"></i> ' . $txt_search_at . ' Amazon.' . $region_tmp;
$url = 'http://www.amazon.' . $region_tmp . '/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag=' . $aid;
$shipping_string = "";
#'<font size="1">('.$txt_shipping.')
#<span class="tooltip">'.tooltip($tooltip).'<span>
#</font>';
// Check if at least a Amazon URL exists?!
//
$meta = "url-amazon." . $region;
$pageurl = get_post_meta($postid, $meta, true);
if ($pageurl != "") {
// not possible because we have no price ...
//$schema_start = '<div itemprop="offers" itemscope itemtype="http://schema.org/Offer">';
//$schema_end = '</div>';
$region_tmp = $region;
if ($region == "nl") {
$region_tmp = "de";
}
//$price_string = '<span itemprop="availability" itemtype="http://schema.org/OutOfStock" class="outofstock">('.$txt_out_of_stock.')</span>
$price_string = '<span class="outofstock">(' . $txt_out_of_stock . ')</span>
<br /><div class="amazon-cr"></div>' . $txt_not_avail_at . '
<a target="_blank" href="http://www.amazon.' . $region_tmp . '/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag=' . $aid . '" rel="nofollow">
Amazon.' . $region_tmp . '
</a>
<div class="amazon-cr"></div>';
$button_string = '<i class="icon-search icon-large3"></i> ' . $txt_preorder . ' Amazon.' . $region_tmp;
$url = $pageurl;
}
$do_not_show = 1;
} else {
//echo "AAA";
$schema_start = '<div itemprop="offers" itemscope itemtype="http://schema.org/Offer">';
$schema_end = '</div>';
//Check Amazon for pricing returned
$meta = "url-amazon." . $region;
$pageurl = get_post_meta($postid, $meta, true);
$price_string = '
<span itemprop="availability" itemtype="http://schema.org/InStock" class="instock">
' . $txt_on_stock . ' at <a href="' . $pageurl . '">Amazon.com</a>
</span>';
$region_tmp = $region;
if ($region == "nl") {
$region_tmp = "de";
}
$button_string = '<i class="icon-search icon-large3"></i> Check Price at Amazon.' . $region_tmp;
$url = $pageurl;
}
}
$button .= '
<div class="amaz-grey-box" style="border: 0px solid #eee; background-color: #eee;">
' . $schema_start . $price_string . '
<br />';
if ($shipping_string != "") {
$button .= '
<div class="shipping">' . $shipping_string . '
</div>
<br />';
}
$button .= '
<a href="' . $url . '" class="css_btn_class" rel="nofollow">' . $button_string . '
</a>
' . $schema_end . '
</div>
<br />
';
if ($region == "nl" and $shopid == "") {
$button = "";
}
if ($do_not_show == 1) {
$button = "";
}
return $button;
}