<?php
  session_start();
  include "config/fungsi_indotgl.php";  
  include "config/config78.inc";
  include "config/garam.php";

  $mkue = "GRC".uniqid();
  
  if (!isset($_COOKIE['log_attend'])) {
        setcookie('log_attend', $mkue , time() + (86400 * 30), "/");
    }

    if (isset($_COOKIE["log_attend"])) { $mkue =  $_COOKIE['log_attend']; }

    if (!isset($_SESSION['log_attend'])) { $_SESSION['log_attend'] = $mkue; } //$_COOKIE['log_attend']; }


  $string = trim($_GET['product_id']);
  $str_arr = explode (";", $string);  
  
  $nama_aff = "GraceMebel";
  $nama_aff2 = "";
  $email_aff = "admin@gracemebel.com";
  $telp_aff = "-";
  $pict_aff = "upload/profil/grace.png";

  $promo_kategori = "";
  
  $email_toko_login = "";
  if (isset($_SESSION["toko_user_email"])) {
	  $email_toko_login = $_SESSION["toko_user_email"];
  }

//   echo $str_arr;

//   echo count($str_arr); 
  

  if (count($str_arr) > 1) {
    $kode_barang = $str_arr[0];
    if (substr($kode_barang,0,4) != "AJM.") {
        // echo "Kode Barang : " + $kode_barang;
        $dataEnkripsi = str_replace(' ', '+', $str_arr[1]);
        $mkatasandi = strtoupper(decrypt($dataEnkripsi, $GaramDunia));
        $ktsandi = explode(";",$mkatasandi);
        $type_appliate = $ktsandi[0];
        $kode_appliate = $ktsandi[1];

        if (count($ktsandi) > 2) {
            $voucher_id = $ktsandi[3];
            // echo "DI SINI ....";
            //setcookie("kode_voucher", strtoupper($voucher_id), time() + (86400 * 30), "/"); // 86400 = 1 day
            $dataVoucher = mysqli_query($MyCon,"SELECT * FROM promo_kode_vouchertbl WHERE id = $voucher_id LIMIT 0,1;");
            if (mysqli_num_rows($dataVoucher) > 0) {
                $rowVoucher = mysqli_fetch_array($dataVoucher,MYSQLI_ASSOC);
                $tanggalVoucher = $rowVoucher["tanggal_ahir"];
                $minimBelanja = $rowVoucher["min_belanja"];
                $statusVoucher = $rowVoucher["promo_status"];
                $nominalVoucher = $rowVoucher["nominal_voucher"];
                $namaVoucher = $rowVoucher["nama_voucher"]; 
            }
            if (count($ktsandi >= 5)) {
            $voucher_id = $voucher_id . ";" . $kode_appliate;
            }
        }
    } else {
        $emascode = str_replace('AJM.', 'PCH.', $string) ;
        $sqle = "SELECT p.*,i.seo_nama_produk FROM productcodetbl p LEFT JOIN produk i ON i.idproduk = p.ProductID WHERE UPPER(p.QrCode) = '$emascode'";
        $dataEmas = mysqli_query($MyCon,$sqle);
        // print_r( $dataEmas);
        if (mysqli_num_rows($dataEmas) > 0) {
            $emasrow = mysqli_fetch_array($dataEmas,MYSQLI_ASSOC);
            $kode_barang = $emasrow["seo_nama_produk"]; 
        }
    }
} else {
    $kode_barang = $_GET['product_id'];
}


  if ($email_toko_login == "") {
	  $kode_appliate1 = "";
	  $kode_appliate2 = "";
	//   $kode_appliate = "";
	  
	  setcookie("KODEAFFILIATE", "",time() - 3600, "/");
	  unset($_COOKIE["KODEAFFILIATE"]);
	  
	  if (isset($kode_appliate)) {
          if ($kode_appliate != "") {
              if ($type_appliate = "link") {
                  $dataAff1 = mysqli_query($MyCon,"SELECT * FROM affiliate WHERE upper(alias_affiliate) = upper('$kode_appliate')");
                  if (mysqli_num_rows($dataAff1) > 0) {
                      setcookie("kode_link", strtoupper($kode_appliate), time() + (86400 * 30), "/"); // 86400 = 1 day
                  } else {
                      setcookie("kode_link", "GRACE", time() + (86400 * 30), "/"); // 86400 = 1 day
                  }
              } else {
                  if ($type_appliate == "P") {
                      $affquery = "SELECT foto_appiliate1 app1,foto_appiliate2 app2, foto_link gambarxxx FROM fotolink WHERE foto_id = '$kode_appliate'";
                  } else {
                      $affquery = "SELECT video_appiliate1 app1,video_appiliate2 app2, video_thumbnail gambarxxx FROM videolink WHERE video_id = '$kode_appliate'";
                  }
                  $affdata = mysqli_query($MyCon,$affquery);
                  if (mysqli_num_rows($affdata) > 0 ) {
                      $affrow = mysqli_fetch_array($affdata,MYSQLI_ASSOC);
                      $kode_appliate1 = $affrow["app1"];
                      $kode_appliate2 = $affrow["app2"];
                      $gambarxxx  = $affrow["gambarxxx"];
                  }
                  setcookie("KODEAFFILIATE", $kode_appliate, time() + (86400 * 30), "/"); // 86400 = 1 day
                          
                  $dataAff = mysqli_query($MyCon,"SELECT a.*,b.foto_aff FROM affiliate a LEFT OUTER JOIN affiliate_extra b ON a.alias_affiliate = b.alias_aff WHERE idaffiliate = '$kode_appliate1'");
                  if (mysqli_num_rows($dataAff) > 0) {
                      $affrow2 = mysqli_fetch_array($dataAff,MYSQLI_ASSOC);
                      $nama_aff = $affrow2["nama_affiliate"]."(".$affrow2["alias_affiliate"].")";
                      $nama_aff2 = "";
                      $email_aff = $affrow2["email_affiliate"];
                      $telp_aff = $affrow2["telp_affiliate"];
                      $pict_aff = "upload/profil/".$affrow2["foto_aff"];
                  }
                  
              }
          }
      }
  } else {
    if (substr($str_arr[0],0,4) != "AJM.") {
        $kode_barang = $str_arr[0];      
    }

	  unset($_COOKIE["KODEAFFILIATE"]);
  }
   
  $product_id = "";
  $product_categorie = "";
  $formula_bundle = "";
  $dataFormula = false;
//   $_qkode_barang = mysqli_query($MyCon,"SELECT idproduk,idkategori FROM produk WHERE trim(seo_nama_produk) = '".$kode_barang."'");


  $_qkode_barang = mysqli_query($MyCon,"SELECT p.idproduk, p.idkategori, pe.produk_formula FROM produk p LEFT OUTER JOIN produk_extra pe ON (pe.idproduk = p.idproduk) WHERE TRIM(p.seo_nama_produk) = '".$kode_barang."'");


  if  (mysqli_num_rows($_qkode_barang) > 0) {
	  $nrowx = mysqli_fetch_array($_qkode_barang,MYSQLI_ASSOC);
	  $product_id = $nrowx['idproduk'];
      $product_categorie = $nrowx['idkategori'];
      $formula_bundle = $nrowx['produk_formula'];
  }
  
  if ($formula_bundle != "") {
        $dataFormula = true;
  }

  $isi_keyword = "";
  $isi_deskripsi = "";
  /*
  $keyword = mysqli_query($MyCon,"SELECT keyword FROM keywordtbl WHERE idproduk = $product_id");
  if  (mysqli_num_rows($keyword) > 0) {
	  $nrowk = mysqli_fetch_array($keyword,MYSQLI_ASSOC);
	  $isi_keyword = $nrowk['keyword'];
  }*/

  $thumnail_video = "";
  $link_video = "";
  $link_manual_download = "";

  $dataSEO = mysqli_query($MyCon,"SELECT * FROM produk_extra WHERE idproduk = $product_id");
  if($dataSEO == true) {
      if (mysqli_num_rows($dataSEO) > 0) {
          $rowSEO = mysqli_fetch_array($dataSEO,MYSQLI_ASSOC);
          $isi_keyword = $rowSEO["produk_seo_keyword"];
          $isi_deskripsi = $rowSEO["produk_seo_deskripsi"];
          $thumnail_video = $rowSEO["produk_video_thumb"];
          $link_video = $rowSEO["produk_video_link"];
          $link_manual_download = $rowSEO['produk_rakit_link'];
      }
  }
  
  $gratis_ongkir = false;
  if ($email_toko_login == "") {
	  $promo_ongkir = mysqli_query($MyCon,"SELECT * FROM gratisongkirtbl WHERE idproduk = $product_id AND CAST(now() AS date) BETWEEN tanggal_awal AND tanggal_ahir");
      if ($promo_ongkir == true) {
          if (mysqli_num_rows($promo_ongkir)>0) {
              $gratis_ongkir = true;
          }
      }
  } else {
	  $_data_promo = mysqli_query($MyCon,"SELECT * FROM v_promo_webonly WHERE NOW() >= tgl_awal AND NOW() <= tgl_ahir AND id_produk = '".$product_id."'");
	  $_num_promo = mysqli_num_rows($_data_promo);
  }
  
  
  $_product_query = "SELECT v.*,IFNULL(q.total,0) sales, IFNULL(q2.total,0) sales_new, IFNULL(pe.produk_berat,1000) berat, pe.foto_utama f_u, pe.foto_dalam f_d, pe.foto_samping f_s, pe.produk_dimensi, pe.produk_warna, pe.produk_ukuran,pe.produk_manufacture,pe.produk_material,pe.produk_finishing,pe.produk_ukuran,fnc_cariharga(v.idproduk,'HARGA_PROMO_RESELER') hppreseller FROM v_product_qty v LEFT OUTER JOIN v_sales_qty_new q2 ON v.idproduk = q2.idbarang LEFT OUTER JOIN v_sales_qty q ON v.idproduk = q.idbarang LEFT OUTER JOIN v_product_berat v2 ON v.idproduk = v2.idproduk LEFT OUTER JOIN produk_extra pe ON v.idproduk = pe.idproduk WHERE v.idproduk = '" . $product_id . "'";
  $_product_result = mysqli_query($MyCon,$_product_query);
  $namaBarang = "";
  $init_categ = "#";
  $deskripsi = "";
  $title_seo = str_replace("-"," ",$kode_barang);
  if  (mysqli_num_rows($_product_result) > 0) {	  
	  $_product_data = mysqli_fetch_array($_product_result,MYSQLI_ASSOC);
	  $namaBarang = $_product_data['nama_produk'];
	  $init_categ = $_product_data['init_kategori'];
      $deskripsi = $_product_data["deskripsi"];


      if ($dataFormula == true) {
        $_product_bundle = mysqli_query($MyCon,"SELECT v.*,f.FormulaQty, IFNULL(q.total,0) sales, IFNULL(q2.total,0) sales_new, IFNULL(pe.produk_berat,1000) berat, pe.foto_utama f_u, pe.foto_dalam f_d, pe.foto_samping f_s, pe.produk_dimensi, pe.produk_warna, pe.produk_ukuran,pe.produk_manufacture,pe.produk_material,pe.produk_finishing,pe.produk_ukuran,fnc_cariharga(v.idproduk,'HARGA_PROMO_RESELER') hppreseller FROM v_product_qty v LEFT OUTER JOIN v_sales_qty_new q2 ON v.idproduk = q2.idbarang LEFT OUTER JOIN v_sales_qty q ON v.idproduk = q.idbarang LEFT OUTER JOIN v_product_berat v2 ON v.idproduk = v2.idproduk LEFT OUTER JOIN produk_extra pe ON v.idproduk = pe.idproduk LEFT OUTER JOIN formuladtbl f ON f.FormulaProduct = v.idproduk AND f.FormulaID = '".$formula_bundle."'  WHERE v.idproduk IN(SELECT FormulaProduct FROM formuladtbl WHERE FormulaID = '".$formula_bundle."')");
      }
    }
  
  $stock_barang = 0;

  if ($email_toko_login != "") {

        $cari_promo_kat = mysqli_query($MyCon,"SELECT p.* FROM v_promo_cat_produk_webonly p WHERE p.id_produk = $product_id AND NOW() between p.tgl_awal AND p.tgl_ahir AND p.status_promo = 0 LIMIT 0,1");
        if (mysqli_num_rows($cari_promo_kat) > 0) {
            $_product_data_promo_kat = mysqli_fetch_array($cari_promo_kat,MYSQLI_ASSOC);
            $promo_id_kategory = $_product_data_promo_kat["id_cat"];
            $promo_tgl_awal_kategory = $_product_data_promo_kat["tgl_awal"];
            $promo_tgl_akhir_kategory = $_product_data_promo_kat["tgl_ahir"];
            $promo_qty_awal_kategory = $_product_data_promo_kat["qty_awal"];
            $promo_qty_akhir_kategory = $_product_data_promo_kat["qty_ahir"];
            $promo_id_code = $_product_data_promo_kat["id_promo"];
            $promo_harga_kategory = $_product_data_promo_kat["nilai_uang"];
        }

  
  }


//   $dataStock = mysqli_query($MyCon,"SELECT * FROM smartpos_ajmshopee.v_stock_perlokasi_2022 WHERE productid =  fnc_carikdbrg($product_id)");

//   if ($dataStock) {

//       if (mysqli_num_rows($dataStock) > 0) {
//           $rowDataGudang = [];
    
//           while ($rowStock = mysqli_fetch_array($dataStock,MYSQLI_ASSOC)) {
//               $kodeGudang = $rowStock["LokasiId"]; 
//               $rowDataGudang[] = $rowStock;
//               if ($kodeGudang == "L0001") {
//               } else {
//                   if ($kodeGudang == "L0002") {
//                   } else {
//                       if ($kodeGudang == "L0003") {
//                       } else {
//                           if ($rowStock["Qty"] > 0) {
//                             $tampilStockViewMore  = true;
//                           }
//                       }
//                   }
//               }
    
    
//           }
//       }
//   }


?>

<!DOCTYPE html>
<base href="/" />

<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

    <!-- Mobile Web-app fullscreen -->
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="mobile-web-app-capable" content="yes">
    <meta name="description" content="<?php echo $isi_deskripsi;?>">

    <!-- Meta tags -->
    <meta name="keywords" content="<?php echo $isi_keyword;?>">
    <meta name="author" content="">
    <link rel="shortcut icon" href="favicon.ico" type="image/x-icon"/>

    <!--Title-->
    <title><?php echo $title_seo;?></title>

    <!--CSS styles-->
    <link rel="stylesheet" media="all" href="mobel2020/css/bootstrap.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/animate.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/font-awesome.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/furniture-icons.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/linear-icons.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/magnific-popup.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/owl.carousel.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/ion-range-slider.css" />
    <link rel="stylesheet" media="all" href="mobel2020/css/theme.css" />
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jquery-confirm/3.3.2/jquery-confirm.min.css">


    <!--Google fonts-->
    <link href="https://fonts.googleapis.com/css?family=Montserrat:400,500,600&amp;subset=latin-ext" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Roboto:300,400,500" rel="stylesheet">

    <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->

    <style>
}
        .container_video {
            position: relative;
            overflow: hidden;
            width: 100%;
            height:300px;
            padding-top: 56.25%; /* 16:9 Aspect Ratio (divide 9 by 16 = 0.5625) */
        }

        /* Then style the iframe to fit in the container div with full height and width */
        .responsive-iframe {
            position: absolute;
            top: 0;
            left: 0;
            bottom: 0;
            right: 0;
            width: 100%;
            height: 100%;
        }


        .modal {
            border-radius: 7px;
            overflow: hidden;
            background-color: transparent;
         }

         .modal-dialog {
                transform: translate(0, -50%);
                top: 30%;
                margin: 0 auto;
            }

        
        .modal .logo a img {
            width: 30px; }

        .modal .modal-content {
            background-color: transparent;
            border: none;
            border-radius: 7px; }
            
        .modal .modal-content .modal-body {
            border-radius: 7px;
            overflow: hidden;
            color: #fff;
            padding-left: 0px;
            padding-right: 0px;
            -webkit-box-shadow: 0 10px 50px -10px rgba(0, 0, 0, 0.9);
            box-shadow: 0 10px 50px -10px rgba(0, 0, 0, 0.9); }

        .modal .modal-content .modal-body h2 {
            font-size: 18px; }

        .modal .modal-content .modal-body p {
            color: #777;
            font-size: 14px; }

        .modal .modal-content .modal-body h3 {
            color: #000;
            font-size: 22px; }

        .modal .modal-content .modal-body .close-btn {
            color: #000; }

        .modal .modal-content .modal-body .promo-img {
            -webkit-box-flex: 0;
            -ms-flex: 0 0 200px;
            flex: 0 0 200px; }

        .modal .main-content {
            padding-left: 20px;
            padding-right: 20px; }

        .modal .coupon {
            padding: 10px;
            color: #000;
            text-align: center;
            background-color: #fff;
            border: 2px dashed #6c757d;
            margin-bottom: 20px; }

        .modal .cancel {
            color: gray;
            font-size: 14px; }

        .form-control {
            border: transparent; }

        .form-control:active, .form-control:focus, .form-control:hover {
            -webkit-box-shadow: none !important;
            box-shadow: none !important; }

        .btn {
            border-radius: 4px;
            border: none; }

        .btn:active, .btn:focus {
            outline: none;
            -webkit-box-shadow: none !important;
            box-shadow: none !important; }

        .bg-image {
            background-size: cover;
            background-position: center;
            background-repeat: no-repeat; }

        .logo img {
            width: 70px; } 

        .bg-4 {
              background: #fff4e4; }
    </style>

</head>

<body>

    <div class="page-loader"></div>

    <div class="wrapper">

        <!--Use class "navbar-fixed" or "navbar-default" -->
        <!--If you use "navbar-fixed" it will be sticky menu on scroll (only for large screens)-->

        <!-- ======================== Navigation ======================== -->

		<?php
		   include("headernew2020.php");
		?>
        <!-- ========================  Main header ======================== -->

        <section class="main-header" style="background-image:url(mobel2020/assets/images/gallery-2.jpg)">
            <header>
                <div class="container">
                    <h1 class="h2 title"><?php echo $namaBarang;?></h1>
                    <ol class="breadcrumb breadcrumb-inverted">
                        <li><a href="/"><span class="icon icon-home"></span></a></li>
                        <li><a href="listcate">Kategori</a></li>
                        <li><a href="kategory/<?php echo $init_categ;?>"><?php echo $init_categ;?></a></li>
                        <li><a class="active" href="<?php echo "pdetail/".$kode_barang; ?>"><?php echo $namaBarang;?></a></li>
                        <!-- <li><a class="active" href="product.html">xxxx</a></li>-->
                    </ol>
                </div>
            </header>
        </section>

        <!-- ========================  Product ======================== -->

        <section class="product">
            <div class="main">
                <div class="container">
                    <div class="row product-flex">

                        <!-- product flex is used only for mobile order -->
                        <!-- on mobile 'product-flex-info' goes bellow gallery 'product-flex-gallery' -->

                        <?php
                          if (isset($voucher_id)) {
                            echo "<input type='hidden' id='vds' name='vds' value='$voucher_id'/>";
                          } else {
                            echo "<input type='hidden' id='vds' name='vds' value=''/>";
                          }
                        ?>


                        <div class="col-md-4 col-sm-12 product-flex-info">
                            <div class="clearfix">

                                <!-- === product-title === -->

                                <h1 class="title" data-title="Grace"><?php echo $namaBarang?>  <small><?php echo $kode_barang;?></small></h1>

                                <div class="clearfix">

                                    <!-- === price wrapper === -->

                                    <div class="price">
                                        <span class="h3">
										<input type="hidden" name="kodeBarang" id="kodeBarang" value="<?php 
                                        $kd = $_product_data['idproduk'] ?? null;
                                        if ($kd !== null) {
                                            echo $_product_data['idproduk'];
                                        } else {
                                            echo "zzzzz";
                                        }
                                        ?>">
										<input type="hidden" name="TokoLoginEmail" id="TokoLoginEmail" value="<?php echo $email_toko_login;?>">
										
										<?php 
                                          $skdj = $_product_data['sales'] ?? null;
                                          if ($skdj !== null) {
                                            $onPending = $_product_data['sales'] + $_product_data['sales_new'];

                                          } else {
                                            $onPending = 0;

                                          }
                                        //    echo $onPending;
                                           if ($dataFormula == true) {
                                              $stock_barang  = 0;
                                              $bundleStock = 0;
                                              $itemAvaliable = array();
                                              $nc = 0;
                                              while($rowB = mysqli_fetch_array($_product_bundle)) {
                                                  $nc = $nc + 1;
                                                  $qStock = $rowB['qty_stock'] - ($rowB['sales'] + $rowB['sales_new']);
                                                  $avalStock = floor($qStock / $rowB['FormulaQty']); 
                                                  $itemAvaliable[] = $avalStock; 
                                                }
                                                if ($nc > 0) {
                                                    sort($itemAvaliable);
                                                    $stock_barang = $itemAvaliable[0];
                                                }                                                
                                           } else {
                                               $qq23 = $_product_data['qty_stock'] ?? null;
                                               if ($qq23 !== null) {
                                                   $stock_barang = $_product_data['qty_stock']  - ($_product_data['sales'] + $_product_data['sales_new']);
                                               } else {
                                                    $stock_barang = 0;
                                                    //  - ($_product_data['sales'] + $_product_data['sales_new']);
                                               }
                                           }
										   if ($stock_barang < 0) {
											   $nstock = 0;
										   } else {
										 	   $nstock = $stock_barang;
										   }
										   $mberat       = $_product_data["berat"] ?? 0;
										   $mberat       = $mberat / 1000;
										   $harga_barang = $_product_data["harga_jual"] ?? 0;
										   $diskon       = $_product_data['diskon'] ?? 0;
										   $harga_coret  = $harga_barang;
										   if ($email_toko_login != "") {
											   $harga_barang = $harga_coret - (($harga_coret * $diskon)/100);
										   } else {
                                            if (isset($_COOKIE["kode_link"])) {

                                                if ($_product_data["hppreseller"] > 0) {
                                                    $harga_barang = $_product_data["hppreseller"];
                                                }
                                                
                                            }
                                           }


										?>
                                            <?php echo "Rp. ". number_format($harga_barang);?>
											<?php 
											   if ($email_toko_login != "" || isset($_COOKIE["kode_link"])) {
											?>
                                            <small><?php echo number_format($harga_coret);?></small>
											<?php
											   }
											?>
                                        </span>
                                    </div>
									<div class="info-box">
                                        <span><strong>Availability</strong></span>
										<?php 
										  if ($nstock > 0) {
										?>
                                        <span><h4 style="margin-bottom:1px;"><strong><?php echo number_format($nstock); ?> </strong></h4></span>
										<span>&nbsp; In stock</span>

										<?php
										  } else {
										?>
                                        <span> <i class="fa fa-exclamation-circle"></i><span class='label label-warning'>&nbsp; Out of stock</span></span>
										<?php
										  }
										?>
                                    </div>

                                    <?php
                                      if (isset($tampilStockViewMore) && ($nstock > 0)) {
                                          $x1 = 0;
                                          foreach($rowDataGudang as $item) {
                                              $x1 = $x1 + 1;
                                            $kodeGudang = $item["LokasiId"];
                                            $namaGudang = $item["LokasiName"];
                                            $qtyGudang = $item["Qty"];
                                            if ($kodeGudang == 'L0001') {
                                                $qtyGudang = $qtyGudang - $onPending;
                                                if ($qtyGudang < 0) {
                                                    $qtyGudang = 0;
                                                }
                                            }

                                            $newKata = "";

                                            if ($kodeGudang == 'L0001' or $kodeGudang == 'L0003') {
                                            } else {
                                                $newKata = " *";
                                                
                                            }

                                            $namaGudang2 = "";

                                            if (strpos($namaGudang,'_') !== false) { //first we check if the url contains the string 'en-us'
                                                $namaGudang2  = str_replace('_', ' ', $namaGudang); //if yes, we simply replace it with en
                                            } else {
                                                $namaGudang2 = $namaGudang;
                                            }


                                            echo "<div class='info-box' style='padding:2px 0;'>";
                                            if ($x1 == 1) {
                                                echo "<span><h6 style='margin-top:0px;margin-bottom:0px;color:red'>Detail Stock</h6></span>";
                                            } else {
                                                echo "<span></span>";
                                            }
                                            echo "<span><h6 style='margin-top:0px;margin-bottom:0px;color:red;'>".$qtyGudang." in ".$namaGudang2.$newKata."</h6></span>";
                                            echo "</div>";

                                          }
                                          echo "<div class='info-box' style='padding:2px 0;'><span></span><span><h6 style='margin-top:0px;margin-bottom:0px;color:red;'><small style='color:red;'>* Pre Order / Reseller promo</small></h6></span>";
                                          echo "</div>";
                                          
                                        }


                                        ?>


                                    <hr />

                                    <?php
                                      if (isset($promo_id_code)) {
                                    ?>
									<div class="info-box">
                                        <div class='alert alert-warning' role='alert'>
                                        <span><strong>PROMO KATEGORI ... !!!</strong></span>
                                        <ul class='fa-ul'>
                                        <li><i class='fa-li fa fa-gift'></i>Minimal belanja <?php echo $promo_qty_awal_kategory ;?> Unit</span></li>
                                        <li><i class='fa-li fa fa-gift'></i>Periode promo sampai <?php echo tgl_indo($promo_tgl_akhir_kategory); ?></li>
                                        <li><i class='fa-li fa fa-gift'></i><strong>Harga satuan <?php echo "Rp. " . number_format($promo_harga_kategory); ?></strong></li>
                                        </ul>
                                        </div>
                                    </div>

                                    <hr />


                                    <?php
                                      }
                                    ?>
									
									
                                    <!-- === info-box === -->

                                <div class="info-box">
                                    <strong>Manufacturer</strong>
                                    <span><?php echo "GRACE";?></span>
                                </div>
								
                                <div class="info-box">
                                    <strong>Color</strong>
                                    <span>
                                        <?php
                                           $oo = $_product_data["produk_warna"] ?? null; 
                                           if ($oo !== null) {
                                               echo $_product_data["produk_warna"];
                                           }
                                        ?>
                                    </span>
                                </div>
                                <div class="info-box">
                                    <strong>Finishing</strong>
                                    <span>
                                        <?php 
                                            $oo2 = $_product_data["produk_finishing"] ?? null;
                                            if ($oo2 !== null) {
                                                echo $_product_data["produk_finishing"];
                                            } 
                                        ?>
                                    </span>
                                </div>
                                <div class="info-box">
                                    <strong>Materials</strong>
                                    <span>
                                        <?php 
                                            $oo2 = $_product_data["produk_material"] ?? null;
                                            if ($oo2 !== null) {
                                                echo $_product_data["produk_material"];
                                            } 
                                        ?>
                                    </span>
                                </div>									
									

                                    <!-- === info-box === -->

                             
                                    <hr />

                                    <div class="info-box">
                                        <span><strong>Weight </strong></span>
                                        <span>
										
										<?php echo $mberat . " Kg";?> 
										
                                        </span>
                                    </div>
                                <div class="info-box">
                                    <strong>Dimensions (cm)</strong>
                                    <span>
                                        <?php
                                            $qqq = $_product_data["produk_dimensi"] ?? null; 
                                            if ($qqq !== null) {
                                                echo $_product_data["produk_dimensi"];
                                            }
                                        ?>
                                    </span>
                                </div>

                                <div class="info-box">
                                    <strong>Packaging (cm)</strong>
                                    <span>
                                        <?php 
                                           $qq2 = $_product_data["produk_ukuran"] ?? null;
                                           if ($qq2 !== null) {                                            
                                               echo $_product_data["produk_ukuran"];
                                           }
                                        ?>
                                    </span>
                                </div>
									
									<?php
									   if ($email_toko_login != "") {
										   if ($_num_promo > 0) {
											   echo "<hr />";
											   echo "<div class='alert alert-danger' role='alert'><strong>PROMO ITEM!!!!</strong>";
											   $tgl_awal_promo = "";
											   $tgl_akhir_promo = "";
											   while ($promo_row = mysqli_fetch_array($_data_promo,MYSQLI_ASSOC)) {
												   $tgl_awal_promo  = $promo_row['tgl_awal'];
												   $tgl_akhir_promo = $promo_row['tgl_ahir'];
												   

													  echo "<ul class='fa-ul'>";
													  echo "<li><i class='fa-li fa fa-check-square'></i>Setiap Minimal Pembelian ".$promo_row['qty_awal']." item</li>";
													  echo "<ul class='fa-ul'>";
													  if ($promo_row['nilai_uang'] <> "") {
														  echo "<li><i class='fa-li fa fa-gift'></i>Harga Satuan sebesar <span class='highlight fourth-color'>Rp. ".number_format($promo_row['nilai_uang'])."</span></li>";
													  }
													  if ($promo_row['nilai_persen'] <> '0'){
														  echo "<li><i class='fa-li fa fa-gift'></i>Discount tambahan sebesar ".$promo_row['nilai_persen']."%</li>";
													  }
													  if ($promo_row['nilai_point'] <> '0' ){
														  echo "<li><i class='fa-li fa fa-gift'></i>Tambahan Point sebesar ".$promo_row['nilai_point']." Point</li>";
													  }
													  echo "</ul></ul>";

												 
											   }
											   echo "<small>Promo ini berlaku dari tanggal ".$tgl_awal_promo." sampai ".$tgl_akhir_promo."</small>";
											   echo "</div>";
										   }
									   }
									?>
									
									<!--

                                    <div class="info-box info-box-addto">
                                        <span><strong>Wishlist</strong></span>
                                        <span>
                                            <i class="add"><i class="fa fa-eye-slash"></i> Add to Watch list</i>
                                            <i class="added"><i class="fa fa-eye"></i> Remove from Watch list</i>
                                        </span>
                                    </div>

                                    <div class="info-box info-box-addto">
                                        <span><strong>Collection</strong></span>
                                        <span>
                                            <i class="add"><i class="fa fa-star-o"></i> Add to Collection</i>
                                            <i class="added"><i class="fa fa-star"></i> Remove from Collection</i>
                                        </span>
                                    </div>

                                    <hr />

                                    === info-box ===
                                    <div class="info-box">
                                        <span><strong>Available Colors</strong></span>
                                        <div class="product-colors clearfix">
                                            <span class="color-btn color-btn-red"></span>
                                            <span class="color-btn color-btn-blue checked"></span>
                                            <span class="color-btn color-btn-green"></span>
                                            <span class="color-btn color-btn-gray"></span>
                                            <span class="color-btn color-btn-biege"></span>
                                        </div>
                                    </div>
                                    <div class="info-box">
                                        <span><strong>Choose size</strong></span>
                                        <div class="product-colors clearfix">
                                            <span class="color-btn color-btn-biege">
                                                <span class="product-size" data-text="">S</span>
                                            </span>
                                            <span class="color-btn color-btn-biege checked">M</span>
                                            <span class="color-btn color-btn-biege">XL</span>
                                            <span class="color-btn color-btn-biege">XXL</span>
                                        </div>
                                    </div>
									
									-->

                                    <hr />

                                    <?php

                                    if ($link_manual_download != '' || $link_manual_download != null) {

                                    ?>

                                    <div class="info-box">
                                        <span><strong>Panduan Rakit</strong></span>
                                        <a href="<?php echo $link_manual_download;?>" target="_blank" class="btn btn-sm btn-primary"><span><strong>Link Download</strong></span></a>

                                        <!-- <div class="product-colors clearfix">
                                            <span class="color-btn color-btn-red"></span>
                                            <span class="color-btn color-btn-blue checked"></span>
                                            <span class="color-btn color-btn-green"></span>
                                            <span class="color-btn color-btn-gray"></span>
                                            <span class="color-btn color-btn-biege"></span>
                                        </div> -->
                                    </div>

                                    <?php
                                    }
                                    ?>

                                </div> <!--/clearfix-->
                            </div> <!--/product-info-wrapper-->
                        </div> <!--/col-md-4-->
                        <!-- === product item gallery === -->
                        <div style="position: absolute">

                        <div class="modal fade" id="exampleModalCenter" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                            <div class="modal-dialog modal-dialog-centered" role="document">
                                <div class="modal-content rounded-0">
                                    <div class="modal-body bg-4">
                                        <div class="d-flex main-content">
                                            <div class="bg-image promo-img mr-3" style="background-image: url('mobel2020/assets/images/gambar_kamera.jpg');">
                                            </div>
                                            <div>
                                                <div class="text-center">
                                                    <h3><?php echo isset($nominalVoucher) ? "Voucher Diskon Rp. " . number_format($nominalVoucher).",-" : ""  ;?></h3>
                                                    <p><?php echo isset($tanggalVoucher) ? "Masa Berlaku Voucher sampai dengan ".$tanggalVoucher : "";?></p>
                                                    <p><?php echo isset($minimBelanja) ? "Minimal Belanja Rp. " . number_format($minimBelanja).",-" : "";?></p>

                                                    <?php
                                                      if (isset($statusVoucher)) {
                                                          if ($statusVoucher == 0) {
                                                              echo "<p>Voucher berlaku Khusus Member Toko Gracemebel.com</p>";
                                                          } else {
                                                            echo "<p>Voucher berlaku Khusus Reseller dan umum (bukan Member Toko Gracemebel.com)</p>";
                                                          }
                                                      }

                                                    ?>
                                                </div>
                                                <div class="coupon">
                                                <?php echo isset($namaVoucher) ? $namaVoucher : "";?>                                                </div>
                                                <p>
                                                    <a href="javascript:void(0);" id="btnVoucherOK" name="btnVoucherOK" class="btn py-3 btn-primary btn-block">Gunakan Sekarang</a>
                                                </p>
                                                <p class="text-center">
                                                    <a href="#" class="cancel" data-dismiss="modal">Maaf, Lain waktu.</a>
                                                </p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        </div>


                        <div class="col-md-8 col-sm-12 product-flex-gallery">

                            <!-- === add to cart === -->
							
							<?php
							  if ($nstock > 0) {
							?>

                            <button type="button" class="btn btn-buy" id="btnBeli" name="btnBeli" data-text="Beli"></button>
							
							<?php
							  }
							?>


                            <!-- === product gallery === -->

                            <div class="owl-product-gallery open-popup-gallery">
							    <?php
								  $prodimgx = "upload/produk2020/";
                                  if (isset($_product_data['f_u'])) {
                                    $fhoto1 = $prodimgx.$_product_data['f_u'];
                                    $fhoto2 = $prodimgx.$_product_data['f_d'];
                                    $fhoto3 = $prodimgx.$_product_data['f_s'];

                                  } else {

                                      $fhoto1 = null;
                                      $fhoto2 = null;
                                      $fhoto3 = null;
                                  }
								  if (is_null($fhoto1)) {
									  echo "<a href='mobel2020/assets/images/product-1.png'><img src='mobel2020/assets/images/product-1.png' alt='' height='500' /></a>";
								  } else {
									  echo "<a href='$fhoto1'><img src='$fhoto1' alt='".$namaBarang."' height='500' /></a>";
								  }
								  if (is_null($fhoto2)) {
									  echo "<a href='mobel2020/assets/images/product-1.png'><img src='mobel2020/assets/images/product-1.png' alt='' height='500' /></a>";
								  } else {
									  echo "<a href='$fhoto2'><img src='$fhoto2' alt='".$namaBarang."' height='500' /></a>";
								  }
								  if (is_null($fhoto3)) {
									  echo "<a href='mobel2020/assets/images/product-1.png'><img src='mobel2020/assets/images/product-1.png' alt='' height='500' /></a>";
								  } else {
									  echo "<a href='$fhoto3'><img src='$fhoto3' alt='".$namaBarang."' height='500' /></a>";
								  }
								  
								?>
							
							
                            </div>
                        </div>

                    </div>
                </div>
            </div>

            <!-- === product-info === -->

            <div class="info">
                <div class="container">
                    <div class="row">


                        <!-- === product-designer === -->

                        <div class="col-md-4">
                            <div class="designer">
                                <div class="box">
                                    <div class="image">
                                        <img src="<?php echo $pict_aff;?>" alt="Alternate Text" />
                                    </div>
                                    <div class="name">
                                        <div class="h3 title"><?php echo $nama_aff;?><small><?php echo $nama_aff2;?></small></div>
                                        <hr />
                                        <p><a href="mailto:<?php echo $email_aff;?>"><i class="icon icon-envelope"></i> <?php echo $email_aff;?></a></p>
                                        <p><a href="tel:<?php echo $telp_aff;?>"><i class="icon icon-phone-handset"></i><?php echo $telp_aff;?></a></p>
										<!--
                                        <p>
                                            <a href="#" class="btn btn-main btn-xs"><i class="icon icon-user"></i></a>
                                            <a href="#" class="btn btn-main btn-xs"><i class="icon icon-printer"></i></a>
                                            <a href="#" class="btn btn-main btn-xs"><i class="icon icon-layers"></i></a>
                                        </p>
										-->
                                    </div> <!--/name-->
                                </div> <!--/box-->
                                <div class="btn btn-add">
                                    <i class="icon icon-phone-handset"></i>
                                </div>
                            </div> <!--/designer-->
                        </div> <!--/col-md-4-->
                        <!-- === nav-tabs === -->

                        <div class="col-md-8">
                            <ul class="nav nav-tabs" role="tablist">
                                <li role="presentation" class="active">
                                    <a href="#designer" aria-controls="designer" role="tab" data-toggle="tab">
                                        <i class="icon icon-user"></i>
                                        <span>Related Product</span>
                                    </a>
                                </li>
								<!--
                                <li role="presentation">
                                    <a href="#design" aria-controls="design" role="tab" data-toggle="tab">
                                        <i class="icon icon-sort-alpha-asc"></i>
                                        <span>Specification</span>
                                    </a>
                                </li>
								-->
                                <?php
                                  if (isset($thumnail_video)) {
                                ?>
                                <li role="presentation">
                                    <a href="#videoRakit" aria-controls="videoRakit" role="tab" data-toggle="tab">
                                        <i class="icon  icon-camera-video"></i>
                                        <span>Video Perakitan</span>
                                    </a>
                                </li>

                                <?php
                                  }
                                ?>
                                <li role="presentation">
                                    <a href="#rating" aria-controls="rating" role="tab" data-toggle="tab">
                                        <i class="icon icon-thumbs-up"></i>
                                        <span>Rating</span>
                                    </a>
                                </li>
                            </ul>

                            <!-- === tab-panes === -->

                            <div class="tab-content">

                                <div role="tabpanel" class="tab-pane active" id="designer">
                                    <div class="content">

                                        <!-- === designer collection title === -->

                                        <h3>Related Product</h3>
                                        <div class="products">
                                            <div class="row">


											<?php
											  $dataRelated = array();
											  $queryBarang = "SELECT v.*,p.seo_nama_produk, pe.foto_utama f_u, pe.foto_dalam f_d, pe.foto_samping f_s, fnc_cariharga(v.idproduk, 'STOCK') curstock, pe.produk_dimensi, pe.produk_warna, pe.produk_ukuran,pe.produk_manufacture,pe.produk_material,pe.produk_finishing,pe.produk_ukuran  FROM v_product_qty v, produk p, produk_extra pe WHERE v.idproduk = p.idproduk AND v.discountinue = 0 AND v.idproduk = pe.idproduk AND v.nama_produk like '%" . substr($namaBarang,0,4) ."%'  ORDER BY RAND() limit 0,4 ";
											  $recordBarang = mysqli_query($MyCon,$queryBarang);
											  
											  if($recordBarang->num_rows <= 0) {
//											  if (mysqli_num_rows($recordBarang <= 0)) {
												  $queryBarang = "SELECT v.*,p.seo_nama_produk, , pe.foto_utama f_u, pe.foto_dalam f_d, pe.foto_samping f_s, fnc_cariharga(v.idproduk, 'STOCK') curstock, pe.produk_dimensi, pe.produk_warna, pe.produk_ukuran,pe.produk_manufacture,pe.produk_material,pe.produk_finishing,pe.produk_ukuran  FROM v_product_qty v, produk p, produk_extra pe WHERE v.idproduk = p.idproduk AND v.discountinue = 0 AND v.idproduk = pe.idproduk ORDER BY RAND() limit 0,4 ";
												  $recordBarang = mysqli_query($MyCon,$queryBarang);
											  } 
											  while ($rowsData = mysqli_fetch_array($recordBarang,MYSQLI_ASSOC)) {
												  $produrl  = "pdetail/".$rowsData['seo_nama_produk'];
												  $prodname = $rowsData['nama_produk'];
												  $prodimg  = "upload/produk2020/".$rowsData["f_u"];
												  $idTag    = "product".$rowsData["idproduk"];
												  $arrayProduct[] = array('item' => $rowsData["idproduk"]);
												  
												  if (is_null($rowsData["curstock"])) {
													  $curStock = 0;
												  } else {
													  $curStock = $rowsData["curstock"];
												  }
												  
											?>

                                                <!-- === product-item === -->

                                                <div class="col-md-6 col-xs-6">
                                                    <article>
                                                        <div class="figure-grid">
                                                            <div class="image">
                                                                <a href="#<?php echo $idTag;?>" class="mfp-open">
                                                                    <img src="<?php echo $prodimg;?>" alt="<?php echo $prodname;?>" width="360" />
                                                                </a>
                                                            </div>
                                                            <div class="text">
                                                                <h4 class="title"><a href="<?php echo $produrl;?>"><?php echo $prodname;?></a></h4>
                                                                <!--<span class="description clearfix">Gubergren amet dolor ea diam takimata consetetur facilisis blandit et aliquyam lorem ea duo labore diam sit et consetetur nulla</span>-->
                                                            </div>
                                                        </div>
                                                    </article>
                                                </div>
												
											<?php
											  }
											?>

                                                <!-- === product-item === -->

                                            </div> <!--/row-->
                                        </div> <!--/products-->
                                    </div> <!--/content-->
                                </div> <!--/tab-pane-->
                                <!-- ============ tab #2 ============ -->

                                <div role="tabpanel" class="tab-pane" id="videoRakit">
                                    <div class="content">
                                        <div class="row">
                                            <div class="container_video" style="height:300px;" >
                                                <iframe class="responsive-iframe"  src="<?php echo $link_video;?>" allowfullscreen="allowfullscreen">
                                                </iframe>
                                            </div>
                                        </div>
                                    </div>
                                </div>


                                <div role="tabpanel" class="tab-pane" id="design">
                                    <div class="content">
                                        <div class="row">
                                            <div class="col-md-4">
                                                <h3>Dimensions</h3>
                                                <p>
                                                    <img class="full-image" src="mobel2020/assets/images/specs.png" alt="Alternate Text" width="350" />
                                                </p>
                                                <hr />
                                                <p>
                                                    <img class="full-image" src="mobel2020/assets/images/specs.png" alt="Alternate Text" width="350" />
                                                </p>
                                            </div>
                                            <div class="col-md-8">
                                                <h3>Product Specification</h3>
                                                <p>
                                                    Sofa Laura is a casual, contemporary collection that your family is sure to love.
                                                    The plush pillows and soft sloped arms create the ultimate combination for relaxation and comfort.
                                                </p>
                                                <p>
                                                    The collection is tailored with rounded padded arms, box-welted seat cushions, and loose back cushions.
                                                    Comfort is provided by high density seat cushions supported with a hardwood frame construction.
                                                    This collection is built for comfort and style!
                                                </p>
                                                <p>
                                                    Sofa is fun and elegant with beauty and style that will stay cutting-edge trendy through the years.
                                                    It is completely padded, including the back and outside arms - combining comfort and value to make rewarding relaxatio.
                                                </p>
                                            </div>

                                        </div> <!--/row-->
                                    </div> <!--/content-->
                                </div> <!--/tab-pane-->
                                <!-- ============ tab #3 ============ -->

                                <div role="tabpanel" class="tab-pane" id="rating">

                                    <!-- ============ ratings ============ -->

                                    <div class="content">
                                        <h3>Rating</h3>

                                        <div class="row">

                                            <!-- === comments === -->

                                            <div class="col-md-12">
                                                <div class="comments">

                                                    <!-- === rating === -->

                                                    <div class="rating clearfix">
                                                        <div class="rate-box">
                                                            <strong>Quality</strong>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <span>5</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>5</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star "></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                        </div>

                                                        <!-- rate -->
                                                        <div class="rate-box">
                                                            <strong>Design</strong>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <span>12</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star "></i>
                                                                <span>5</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star "></i>
                                                                <i class="fa fa-star "></i>
                                                                <span>0</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star "></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                        </div>

                                                        <!-- rate -->
                                                        <div class="rate-box">
                                                            <strong>General</strong>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <span>3</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>5</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                            <div class="rating">
                                                                <i class="fa fa-star active"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <i class="fa fa-star"></i>
                                                                <span>0</span>
                                                            </div>
                                                        </div>

                                                    </div>
                                                    <div class="comment-wrapper">

                                                        <!-- === comment === 

                                                        <div class="comment-block">
                                                            <div class="comment-user">
                                                                <div><img src="mobel2020/assets/images/user-2.jpg" alt="Alternate Text" width="70" /></div>
                                                                <div>
                                                                    <h5>
                                                                        <span>John Doe</span>
                                                                        <span class="pull-right">
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star"></i>
                                                                        </span>
                                                                        <small>03.05.2017</small>
                                                                    </h5>
                                                                </div>
                                                            </div>


                                                            <div class="comment-desc">
                                                                <p>
                                                                    In vestibulum tellus ut nunc accumsan eleifend. Donec mattis cursus ligula, id
                                                                    iaculis dui feugiat nec. Etiam ut ante sed neque lacinia volutpat. Maecenas
                                                                    ultricies tempus nibh, sit amet facilisis mauris vulputate in. Phasellus
                                                                    tempor justo et mollis facilisis. Donec placerat at nulla sed suscipit. Praesent
                                                                    accumsan, sem sit amet euismod ullamcorper, justo sapien cursus nisl, nec
                                                                    gravida
                                                                </p>
                                                            </div>


                                                            <div class="comment-block">
                                                                <div class="comment-user">
                                                                    <div><img src="mobel2020/assets/images/user-2.jpg" alt="Alternate Text" width="70" /></div>
                                                                    <div>
                                                                        <h5>Administrator<small>08.05.2017</small></h5>
                                                                    </div>
                                                                </div>
                                                                <div class="comment-desc">
                                                                    <p>
                                                                        Curabitur sit amet elit quis tellus tincidunt efficitur. Cras lobortis id
                                                                        elit eu vehicula. Sed porttitor nulla vitae nisl varius luctus. Quisque
                                                                        a enim nisl. Maecenas facilisis, felis sed blandit scelerisque, sapien
                                                                        nisl egestas diam, nec blandit diam ipsum eget dolor. Maecenas ultricies
                                                                        tempus nibh, sit amet facilisis mauris vulputate in.
                                                                    </p>
                                                                </div>
                                                            </div>
                                                        </div>

                                                        <div class="comment-block">
                                                            <div class="comment-user">
                                                                <div><img src="mobel2020/assets/images/user-2.jpg" alt="Alternate Text" width="70" /></div>
                                                                <div>
                                                                    <h5>
                                                                        <span>John Doe</span>
                                                                        <span class="pull-right">
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star active"></i>
                                                                            <i class="fa fa-star"></i>
                                                                            <i class="fa fa-star"></i>
                                                                        </span>
                                                                        <small>03.05.2017</small>
                                                                    </h5>
                                                                </div>
                                                            </div>
                                                            <div class="comment-desc">
                                                                <p>
                                                                    Cras lobortis id elit eu vehicula. Sed porttitor nulla vitae nisl varius luctus.
                                                                    Quisque a enim nisl. Maecenas facilisis, felis sed blandit scelerisque, sapien
                                                                    nisl egestas diam, nec blandit diam ipsum eget dolor. In vestibulum tellus
                                                                    ut nunc accumsan eleifend. Donec mattis cursus ligula, id iaculis dui feugiat
                                                                    nec. Etiam ut ante sed neque lacinia volutpat. Maecenas ultricies tempus
                                                                    nibh, sit amet facilisis mauris vulputate in. Phasellus tempor justo et mollis
                                                                    facilisis. Donec placerat at nulla sed suscipit. Praesent accumsan, sem sit
                                                                    amet euismod ullamcorper, justo sapien cursus nisl, nec gravida
                                                                </p>
                                                            </div>
                                                        </div>

                                                    </div>

                                                    <div class="comment-header">
                                                        <a href="#" class="btn btn-clean-dark">12 comments</a>
                                                    </div>
													-->
                                                    <!-- === add comment === -->

                                                    <div class="comment-add">

                                                        <div class="comment-reply-message">
                                                            <div class="h3 title">Leave a Reply </div>
                                                            <p>Your email address will not be published.</p>
                                                        </div>

                                                        <form action="#" method="post">
                                                            <div class="form-group">
                                                                <input type="text" class="form-control" name="name" value="" placeholder="Your Name" />
                                                            </div>
                                                            <div class="form-group">
                                                                <input type="text" class="form-control" name="name" value="" placeholder="Your Email" />
                                                            </div>
                                                            <div class="form-group">
                                                                <textarea rows="10" class="form-control" placeholder="Your comment"></textarea>
                                                            </div>
                                                            <div class="clearfix text-center">
                                                                <a href="#" class="btn btn-main">Add comment</a>
                                                            </div>
                                                        </form>

                                                    </div><!--/comment-add-->
                                                </div> <!--/comments-->
                                            </div>


                                        </div> <!--/row-->
                                    </div> <!--/content-->
                                </div> <!--/tab-pane-->
                            </div> <!--/tab-content-->
                        </div>
                    </div> <!--/row-->
                </div> <!--/container-->
            </div> <!--/info-->
        </section>

        <!-- ========================  Product info popup - quick view ======================== -->
		<?php
//		  print_r($arrayProduct);
		  foreach ($arrayProduct as $key => $val) {
			$kodeBarang = $val["item"];
			$idTag      = "product".$kodeBarang;
			$pathGambar = "upload/produk2020/";
			$dataDetail = mysqli_query($MyCon,"SELECT v.*,i.nama_produk,pe.foto_utama,pe.foto_dalam,pe.foto_samping,i.deskripsi,i.popular,i.rating,i.harga_jual,i.qty_stock,i.diskon,v.seo_nama_produk, fnc_cariharga(v.idproduk, 'STOCK') curstock,  pe.produk_dimensi, pe.produk_warna, pe.produk_ukuran,pe.produk_manufacture,pe.produk_material,pe.produk_finishing,pe.produk_ukuran FROM produk v, v_product_qty i, produk_extra pe WHERE v.idproduk = i.idproduk AND v.idproduk = pe.idproduk AND v.idproduk = $kodeBarang");
	//		echo "SELECT v.*,i.nama_produk,pe.foto_utama,pe.foto_dalam,pe.foto_samping,i.deskripsi,i.popular,i.rating,i.harga_jual,i.qty_stock,i.diskon,v.seo_nama_produk, fnc_cariharga(v.idproduk, 'STOCK') curstock FROM produk v, v_product_qty i, produk_extra pe WHERE v.idproduk = i.idproduk AND v.idproduk = pe.idproduk AND v.idproduk = $kodeBarang";
			while ($rowDetail = mysqli_fetch_array($dataDetail,MYSQLI_ASSOC)) {
				$prodprice2 = $rowDetail["harga_jual"];
				$diskon2 = $rowDetail["diskon"];
				$produrl2 = "pdetail/".$rowDetail['seo_nama_produk'];
				$hargaCoret2 = 0;
				if ($email_toko_login != "") {
					$hargaCoret2 = $rowDetail["harga_jual"];
					$prodprice2 = $hargaCoret2 - (($hargaCoret2 * $diskon2)/100);
				}
				if (is_null($rowDetail["curstock"])) {
					$curStock2 = 0;
				} else {
					$curStock2 = $rowDetail["curstock"];
				}
		?>


        <div class="popup-main mfp-hide" id="<?php echo $idTag;?>">

            <!-- === product popup === -->

            <div class="product">

                <!-- === popup-title === -->

                <div class="popup-title">
                    <div class="h1 title"><?php echo $rowDetail["nama_produk"];?><small>product category</small></div>
                </div>

                <!-- === product gallery === -->

                <div class="owl-product-gallery">
					<img src="<?php echo $pathGambar.$rowDetail["foto_utama"];?>" alt="" width="640" />
					<img src="<?php echo $pathGambar.$rowDetail["foto_dalam"];?>" alt="" width="640" />
					<img src="<?php echo $pathGambar.$rowDetail["foto_samping"];?>" alt="" width="640" />
                </div>

                <!-- === product-popup-info === -->

                <div class="popup-content">
                    <div class="product-info-wrapper">
                        <div class="row">

                            <!-- === left-column === -->

                            <div class="col-sm-6">
                                <div class="info-box">
                                    <strong>Manufacturer</strong>
                                    <span><?php echo $rowDetail["produk_manufacture"];?></span>
                                </div>
                                <div class="info-box">
                                    <strong>Dimensions (cm)</strong>
                                    <span><?php echo $rowDetail["produk_dimensi"];?></span>
                                </div>
                                <div class="info-box">
                                    <strong>Packaging (cm)</strong>
                                    <span><?php echo $rowDetail["produk_ukuran"];?></span>
                                </div>
                                <div class="info-box">
                                    <strong>Color</strong>
                                    <span><?php echo $rowDetail["produk_warna"];?></span>
                                </div>
                                <div class="info-box">
                                    <strong>Finishing</strong>
                                    <span><?php echo $rowDetail["produk_finishing"];?></span>
                                </div>
                                <div class="info-box">
                                    <strong>Materials</strong>
                                    <span><?php echo $rowDetail["produk_material"];?></span>
                                </div>
                                <div class="info-box">
                                    <strong>Availability</strong>
									<?php
									  if ($curStock2 > 0) {
									?>
                                    <span><i class="fa fa-check-square-o"></i> <?php echo " ".$curStock2. " "; ?>in stock</span>
									<?php
									  } else {
									?>
                                    <span><i class="fa fa-frown-o"></i> Stock Kosong</span>
									<?php
									  }
									?>
                                </div>
                            </div>

                            <!-- === right-column === 

                            <div class="col-sm-6">
                                <div class="info-box">
                                    <strong>Available Colors</strong>
                                    <div class="product-colors clearfix">
                                        <span class="color-btn color-btn-red"></span>
                                        <span class="color-btn color-btn-blue checked"></span>
                                        <span class="color-btn color-btn-green"></span>
                                        <span class="color-btn color-btn-gray"></span>
                                        <span class="color-btn color-btn-biege"></span>
                                    </div>
                                </div>
                                <div class="info-box">
                                    <strong>Choose size</strong>
                                    <div class="product-colors clearfix">
                                        <span class="color-btn color-btn-biege">S</span>
                                        <span class="color-btn color-btn-biege checked">M</span>
                                        <span class="color-btn color-btn-biege">XL</span>
                                        <span class="color-btn color-btn-biege">XXL</span>
                                    </div>
                                </div>
                            </div>
							
							-->

                        </div><!--/row-->
                    </div> <!--/product-info-wrapper-->
                </div><!--/popup-content-->
                <!-- === product-popup-footer === -->

                <div class="popup-table">
                    <div class="popup-cell">
                        <div class="price">

							<span class="h3"><?php echo "Rp. ".number_format($prodprice2);?> 
							<?php
							  if ($email_toko_login != "") {
							?>
								<small><?php echo number_format($hargaCoret2);?></small>
							<?php
							  }
							?>

                        </div>
                    </div>
                    <div class="popup-cell">
                        <div class="popup-buttons">
                            <a href="<?php echo $produrl2;?>"><span class="icon icon-eye"></span> <span class="hidden-xs">View more</span></a>
							<?php
							   if ($curStock > 0) {
							?>
                            <a href="javascript:void(0);"><span class="icon icon-cart"></span> <span class="hidden-xs">Buy</span></a>
							<?php
							   } else {
							?>
                            <a href="javascript:void(0);"><span class="icon icon-cross"></span> <span class="hidden-xs">Sold Out</span></a>
							<?php
							   }
							?>
                        </div>
                    </div>
                </div>

            </div> <!--/product-->
        </div> <!--popup-main-->

		<?php
			}
		  }
		?>
        <!-- ================== Footer  ================== -->

		<?php
		   include("footernew2020.php");
		?>


    </div>
    <!--/wrapper-->


    <!--JS files-->
    <script src="mobel2020/js/jquery.min.js"></script>
    <script src="mobel2020/js/jquery.bootstrap.js"></script>
    <script src="mobel2020/js/jquery.magnific-popup.js"></script>
    <script src="mobel2020/js/jquery.owl.carousel.js"></script>
    <script src="mobel2020/js/jquery.ion.rangeSlider.js"></script>
    <script src="mobel2020/js/jquery.isotope.pkgd.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.blockUI/2.70/jquery.blockUI.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-confirm/3.3.2/jquery-confirm.min.js"></script>
    <script src="mobel2020/js/grace17092020_rev1.js"></script>
    <script src="mobel2020/js/main22092020_rev1.js"></script>
    <script src="mobel2020/js/pdetail20211101.js"></script>


    <script>

    </script>
    
</body>

</html>