/**
* This function is used to get the related product list
*
*
* @return HTML data
*/
function relatedProducts()
{
$j = 0;
$sql = "SELECT * from cross_products_table where product_id=" . (int) $_GET['prodid'];
$query = new Bin_Query();
if ($query->executeQuery($sql)) {
$flag = '1';
$resultproduct = $query->records;
$arr = explode(',', $resultproduct[0]['cross_product_ids']);
$arr = '"' . implode('","', $arr) . '"';
if (count($arr) > 0) {
for ($i = 0; $i < count($arr); $i++) {
$sql = "SELECT * from products_table where product_id in(" . $arr . ")";
$query = new Bin_Query();
if ($query->executeQuery($sql)) {
$cnt = count($query->records);
if ($cnt > 0) {
for ($i = 0; $i < $cnt; $i++) {
foreach ($query->records as $row) {
$r[$j] = $row;
$prid = $row['product_id'];
$obj1 = new Core_CProductDetail();
$minval = $obj1->disRates($prid);
if ($minval > 0 or $minval != '') {
$r[$j]['msrp'] = '$' . number_format($row['msrp'], 2) . ' - $' . number_format($minval, 2);
} else {
$r[$j]['msrp'] = '$' . number_format($row['msrp'], 2);
}
$j++;
}
}
$output .= Display_DProductDetail::relatedProducts($query->records, $flag, $r);
}
}
}
}
return $output1 . $output;
} else {
//return '<div class="exc_msgbox">Related Products Not Found</div>';
$output1 = '<div id="middle_details"><div id=""> <table width="" border="0" cellpadding="0" cellspacing="0"><tr>';
return $output1;
}
}
/**
* Function gets the releated products from the cross products table
*
*
* @return string
*/
function relatedProducts()
{
$sql = "SELECT * from cross_products_table where product_id=" . (int) $_GET['prodid'];
$query = new Bin_Query();
if ($query->executeQuery($sql)) {
$resultproduct = $query->records;
$arr = explode(',', $resultproduct[0]['cross_product_ids']);
$output1 = '
<table width="20%" border="0" cellpadding="0" cellspacing="0"><tr>';
if (count($arr) > 0) {
for ($i = 0; $i < count($arr); $i++) {
$sql = "SELECT * from products_table where product_id=" . $arr[$i];
$query = new Bin_Query();
$query->executeQuery($sql);
if ($query->totrows > 0) {
foreach ($query->records as $row) {
$r[$j] = $row;
$prid = $row['product_id'];
$obj1 = new Core_CProductDetail();
$minval = $obj1->disRates($prid);
if ($minval > 0 or $minval != '') {
$r[$j]['msrp'] = $_SESSION['currency']['currency_tocken'] . $row['msrp'] . ' - ' . $_SESSION['currency']['currency_tocken'] . $minval;
} else {
$r[$j]['msrp'] = $_SESSION['currency']['currency_tocken'] . $row['msrp'];
}
//$j++;
//print_r($r);
$output .= Display_DProductDetail::relatedProducts($r);
}
}
}
}
return $output1 . $output;
} else {
//return '<div class="exc_msgbox">Related Products Not Found</div>';
$output1 = '<div id="middle_details"><div id=""> <table width="100%" border="0" cellpadding="0" cellspacing="0"><tr>';
return $output1;
}
}