include_once("mysql_bijoux.inc");
$q1 = "SELECT * from BC_products where products_id='$products_id'";
$results1 = mysql_query($q1);
$row1 = $db_product_data = mysql_fetch_array($results1);
$office_lot =$row1[office_lot];
#mr($db_product_data);
while(list($k,$v) = each($row1)){
$$k = $v;
}
$q = "SELECT * from BC_finding_type where finding_type_id='$finding_type_id' order by finding_type_name";
$results = mysql_query($q);
$row = mysql_fetch_array($results);
$db_finding_type_name = $row["finding_type_name"];
if($active!='Y')
{
echo "";
}
//echo $metal_id;
#print_r($_COOKIE);
$accounts_id = getSessionAccountId();
$PHPSESSID = $_COOKIE['PHPSESSID'];
$ip= $_SERVER['REMOTE_ADDR'];
$row_wish = 0;
list($row_wish, $product_arr, $wishlist_size_id_arr) = getWishListItems($products_id);
if($accounts_id > 0)
{
$wish_link="";
}else{
$wish_str="Please note that you are not logged in to your account, and your wish list will
not be saved unless you: login to your account or register for an account.
";
}
$itemadded = base64_decode($itemadded);
$html_mini = "";
$html_mini.= "
";
$html_mini.= "
";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "This Item Has Been Added To Your Cart";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "$product_name ";
$html_mini.= "$itemadded ";
$html_mini.= "Qty: $qtyadded $db_finding_type_name ";
$html_mini.= " | ";
$html_mini.= "";
//$html_mini.= $wish_link;
//$html_mini.= "$wish_str ";
$html_mini.= "";
$html_mini.= " | ";
$html_mini.= "
";
$html_mini.= "
";
$html_mini.= "
";
//ADD WISHLIST MINI WINDOW
$html_mini.= "";
$html_mini.= "
";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "This Item Has Been Added To Your Wish List";
$html_mini.= "";
$html_mini.= "";
$html_mini.= "$product_name ";
$html_mini.= "$itemadded ";
$html_mini.= "Qty: $qtyadded $db_finding_type_name ";
$html_mini.= " | ";
$html_mini.= "";
$html_mini.= $wish_link;
$html_mini.= "$wish_str ";
$html_mini.= "";
$html_mini.= " | ";
$html_mini.= "
";
$html_mini.= "
";
$html_mini.= "
";
//echo $html_mini;exit;
//END
?>
echo $html_mini;
?>
include_once('topnav_bijoux.inc');
?>
$product_block_sec_title = "";
$sizes = $sizesb = array();
if ($metal_id!='0') {
$q = "SELECT metal_name from BC_metals where metal_id='$metal_id'";
$results = mysql_query($q);
$row = mysql_fetch_array($results);
$metal_name = $row["metal_name"];
$product_block_sec_title .= $metal_name;
$htmlselect = $stone_size = "";
$q = "SELECT * from BC_products_sizes where products_id='$products_id' and (size1 > 0 or size2 > 0) and active='Y'";
$results = mysql_query($q);
if (mysql_num_rows($results) > 0)
{
$htmlselect.= " with ";
while($row = mysql_fetch_array($results))
{
$products_sizes_id = $row["products_sizes_id"];
$size1 = $row["size1"];
$size2 = $row["size2"];
$size3 = $row["size3"];
$size4 = $row["size4"];
$size_name = $size1;
if ($size1)
$size_name;
if ($size2 > 0)
$size_name .= "x". $size2;
if ($size3 > 0)
$size_name .= "-". $size3;
if ($size4 > 0)
$size_name .= "x". $size4;
$size_name .= " mm";
$sizes[$products_sizes_id] = $size_name;
$stone_finding_size2 = $size_name;
$prices[$products_sizes_id] = $row["price"];
$beads_per_strand[$products_sizes_id] = $row["beads_per_strand"];
}
if(count($sizes) > 0)
{
natsort($sizes);
while(list($k,$v) = each($sizes))
{
$price = $prices[$k];
$bead_per_strand = $beads_per_strand[$k];
$price_per_bead = @($price / $bead_per_strand);
$display_price_per_bead = Make_Currency($price_per_bead);
if($price > 0)
{
$display_price = Make_Currency($price);
$htmlselect.= "$v";
$has_at_least_one_price = "y";
}
}
}
$htmlselect.= "";
}
if(!empty ($bead_per_strand)){
$product_block_sec_title .= $htmlselect;
}
if ($stone_id)
{
$q = "SELECT category from BC_categories where categories_id='$stone_id' and category!=''";
$results = mysql_query($q);
$row = mysql_fetch_array($results);
$stone_name = $row["category"];
if ($stone_id_display)
{
$product_block_sec_title .= " $stone_name";
}
}
if ($shapes_id)
{
$q = "SELECT shape_name from BC_shapes where shapes_id='$shapes_id' and shape_name!=''";
$results = mysql_query($q);
$row = mysql_fetch_array($results);
$shape_name = $row["shape_name"];
$product_block_sec_title .= " $shape_name";
}
}
$htmlselect = "";
?>
Home / Catalog /
$q = "SELECT c.category,cc.category as parent_category,cc.categories_id as parent_categories_id from BC_categories as c, BC_categories as cc where c.categories_id='$categories_id' and c.parent_categories_id=cc.categories_id";
$results = mysql_query($q);
$row = mysql_fetch_array($results);
$parent_category = $row["parent_category"];
$parent_categories_id = $row["parent_categories_id"];
$category = $row["category"];
echo "$parent_category / ";
echo "$category";
?>
|
« Return To Previous Page
|
|
|
» Need help?
|
if(trim($product_block_sec_title)!="") { ?>
|
if(trim($short_description)!="") { ?>
|
}else{ ?>
|
if(trim($product_block_sec_title)=="") { ?>
|
|
|
| Product#
|
if ($db_product_data['new'] == "Y")
echo " | | ";
else if ($db_product_data['closeout'] == "Y")
echo " | ";
?>
|
$finding_stone_product = false;
if ($metal_id!='0') {
$finding_stone_product = true;
include_once('view_details_finding.html');
}else{
include_once('view_details_beads.html');
}
?>
$htmlselect = "";
//$q = "SELECT * from BC_products_sizes where products_id='$products_id' and active='Y' and ( price > 0 and beads_per_strand>0)";
$q = "SELECT * from BC_products_sizes where products_id='$products_id' and active='Y' and price > 0 and (size1 > 0 or size2 > 0)";
$results = mysql_query($q);
$sizes = $sizesb = $product_size_rowdata = array();
$bead_cnt=0;
if (mysql_num_rows($results) > 0) {
while($row = mysql_fetch_array($results))
{
$products_sizes_id = $row["products_sizes_id"];
$size1 = $row["size1"];
$size2 = $row["size2"];
$size3 = $row["size3"];
$size4 = $row["size4"];
$size_name = $size1;
if ($size1)
$size_name;
if ($size2 > 0)
$size_name .= "x". $size2;
if ($size3 > 0)
$size_name .= "-". $size3;
if ($size4 > 0)
$size_name .= "x". $size4;
$size_name .= " mm";
$price = $row["price"];
$beads_per_strand = $row["beads_per_strand"];
if(trim($row["length_per_strand"]) == "" || $row["length_per_strand"] == 0){
$row["length_per_strand"] = "-";
}else{
$row["length_per_strand"] .= '"';
}
$beads_per_strand = round($beads_per_strand);
if ($beads_per_strand == 0)
{
$price_per_bead = $price;
}else{
$price_per_bead = @($price / $beads_per_strand);
}
$sizes[$products_sizes_id] = $size_name;
$sizesb[$products_sizes_id] = $size_name;
/*
$prices[$products_sizes_id] = $row["price"];
$beads_per_strand[$products_sizes_id] = $row["beads_per_strand"];
$lengths_per_strand[$products_sizes_id] = $row["length_per_strand"];
$pricesb[$products_sizes_id] = $row["price"];
*/
if(trim($beads_per_strand) == "" || $beads_per_strand == 0){
$beads_per_strand = "-";
}else{
$bead_cnt++;
}
$product_size_rowdata[$products_sizes_id]['size'] = $size_name;
$product_size_rowdata[$products_sizes_id]['length_per_strand'] = $row["length_per_strand"];
$product_size_rowdata[$products_sizes_id]['price'] = $price;
$product_size_rowdata[$products_sizes_id]['beads_per_strand'] = $beads_per_strand;
$product_size_rowdata[$products_sizes_id]['price_per_bead'] = $price_per_bead;
}
natsort($sizes);
}
$htmlselect = "";
if($bead_cnt > 0 && !($finding_stone_product))
{
$htmlselect.= "
|
Bead Size |
Strand Length |
# Beads |
$ Bead |
";
while(list($k,$v) = each($sizes))
{
$price = $product_size_rowdata[$k]['price'];
$bead_per_strand = $product_size_rowdata[$k]['beads_per_strand'];
$length_per_strand = $product_size_rowdata[$k]['length_per_strand'];
$price_per_bead = $product_size_rowdata[$k]['price_per_bead'];
$display_price_per_bead = Make_Currency($price_per_bead);
$display_price = Make_Currency($price);
#$bead_per_strand = round($bead_per_strand);
$htmlselect.= "
$v |
$length_per_strand |
$bead_per_strand |
$display_price_per_bead |
";
}
$htmlselect.= "
|
|
| ";
}
//echo $htmlselect;exit;
if(intval($bead_cnt) > 0){
echo $htmlselect;
}
?>
|
» Large View
|
$detail_related = "y";
if($detail_related=="y")
{
$fromt_product_page = "view_details";
$assoc_query = "SELECT p.*,min(ps.price) as minimum_price from BC_products_sizes as ps, BC_products as p";
$assoc_query .= " LEFT JOIN BC_categories as bc ON p.categories_id = bc.categories_id ";
$assoc_query .= " LEFT JOIN BC_products_colors as pc ON p.products_id = pc.products_id ";
$assoc_query .= " where p.active='Y' and p.products_id=ps.products_id and ps.active='Y' ";
/*
if ($db_product_data['new']=='Y')
{
$assoc_query .= " and p.new='Y' ";
}else if($db_product_data['closeout']=='Y'){
$assoc_query .= " and p.closeout='Y' ";
}
*/
if($products_id != "")
{
$exclude_prod_id = " and p.products_id not in ($products_id) ";
}
if ($db_product_data['categories_id'] && ($db_product_data['categories_id'] > 0))
{
$metaland .= " and p.categories_id='".$db_product_data['categories_id']."' ";
$category_union_query = "UNION ". $assoc_query . " and p.categories_id='".$db_product_data['categories_id']."' $exclude_prod_id group by ps.products_id";
//$metalor = " p.categories_id='".$db_product_data['categories_id']."' ";
}
if ($db_product_data['colors_id'] && ($db_product_data['colors_id'] > 0))
{
$metaland .= " and pc.colors_id = '".$db_product_data['colors_id']."'";
$color_union_query = "UNION ". $assoc_query . " and pc.colors_id = '".$db_product_data['colors_id']."' $exclude_prod_id group by ps.products_id";
#$metalor .= " or pc.colors_id = '".$db_product_data['colors_id']."'";
}
if ($db_product_data['shapes_id'] && ($db_product_data['shapes_id'] > 0))
{
$metaland .= " and p.shapes_id='".$db_product_data['shapes_id']."' ";
$shapes_union_query = "UNION ". $assoc_query . " and p.shapes_id='".$db_product_data['shapes_id']."' $exclude_prod_id group by ps.products_id";
# $metalor .= " or p.shapes_id='".$db_product_data['shapes_id']."'";
}
if ($db_product_data['cuts_id'] && ($db_product_data['cuts_id'] > 0))
{
$metaland .= " and p.cuts_id='".$db_product_data['cuts_id']."' ";
$cuts_union_query = "UNION ". $assoc_query . " and p.cuts_id='".$db_product_data['cuts_id']."' $exclude_prod_id group by ps.products_id";
# $metalor .= " or p.cuts_id='".$db_product_data['cuts_id']."'";
}
if ($db_product_data['drills_id'] && ($db_product_data['drills_id'] > 0))
{
$metaland .= " and p.drills_id='".$db_product_data['drills_id']."'";
$drills_union_query = "UNION ". $assoc_query . " and p.drills_id='".$db_product_data['drills_id']."' $exclude_prod_id group by ps.products_id";
# $metalor .= " or p.drills_id='".$db_product_data['drills_id']."'";
}
if ($db_product_data['metal_id'] && ($db_product_data['metal_id'] > 0))
{
$metaland .= " and p.metal_id='".$db_product_data['metal_id']."' ";
$metal_union_query = "UNION ". $assoc_query . " and p.metal_id='".$db_product_data['metal_id']."' $exclude_prod_id group by ps.products_id";
# $metalor .= " or p.metal_id='".$db_product_data['metal_id']."' ";
}
if($metaland!="") $metaland = substr($metaland,4);
if($metalor!="") $metalor = substr($metalor,3);
$q = $assoc_query . " and ( $metaland ) $exclude_prod_id group by ps.products_id ";
//$q .= $assoc_query . " and ( $metaland ) $exclude_prod_id group by ps.products_id ";
$q .= " $category_union_query ";
$q .= " $color_union_query ";
$q .= " $shapes_union_query ";
$q .= " $cuts_union_query ";
$q .= " $drills_union_query ";
$q .= " $metal_union_query ";
$q .= " LIMIT 0,3";
# echo $q; //exit;
$sql_assoc_query = $q;
$db_results_arr = $obj->select($sql_assoc_query);
#$results = mysql_query($q);
#$amount = mysql_num_rows($results);
$amount = count($db_results_arr);
if ($amount > 0)
{
echo " |
Associated Items
";
$i=0;
for($i=0; $i<$amount; $i++)
{
$product_name = $db_results_arr[$i][product_name];
$price = $db_results_arr[$i][minimum_price];
$products_id = $db_results_arr[$i][products_id];
$display_price = number_format($price,2);
echo "
$product_name";
echo " |
| \$$display_price |
|
|
|
| ";
}
for($j=$i;$j<=3;$j++)
echo " | ";
echo "
";
}
}
?>
if($showprompt == "y" && $prompttype == "cart"){
//echo "";
echo "";
}
if($showprompt == "y" && $prompttype == "wishlist"){
//echo "here";exit;
//echo "";
//#TB_inline?height=155&width=300&inlineId=hiddenModalContent&modal=true
echo "";
}
?>