<?php
include("db_connection.php");
$Mainclass=new DB_Controller();

$design_id=$_REQUEST['design_id'];

$m_type=$_REQUEST['m_type'];

$p_cate=$_REQUEST['p_cate'];

$GetData=$Mainclass->Fetch_individual_data("design_code_master","*","ParentId='".$design_id."' ");

$cat  = $Mainclass->Fetch_individual_data("gold_product_category_master","Category","SLN='".$GetData['ProductCategory']."'");


if($design_id!="" || $m_type!="" || $p_cate!=""){

?>




<div class="col-lg-2"><img src="https://placehold.co/200x200" class="w-100" /></div>    
    
<div class="col-lg-10">
    
<div class="row m-0">
<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Product Category</b></br><?php echo $cat['Category']; ?></lable></div></div>    
    
<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Design Code</b></br><?php echo $GetData['ParentId']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Product Name</b></br><?php echo $GetData['ProductName']; ?></lable></div></div> 
<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">HSN Code</b></br><?php echo $GetData['HSNCode']; ?></lable></div> </div> 

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Gold Purity
</b></br><?php echo $GetData['GoldPurity']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Stone</b></br><?php echo $GetData['StoneName']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">No of Stones</b></br><?php echo $GetData['No_Stone']; ?></lable></div></div> 

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Stone Value</b></br><?php echo $GetData['Stone_Value']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Diamond Type</b></br><?php echo $GetData['Diamond_Creation_Type']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Diamond Quality</b></br><?php echo $GetData['DiamondQuality']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Diamond Color</b></br><?php echo $GetData['DiamondColor']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Diamond Size</b></br><?php echo $GetData['DiamondType']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">No of Diamonds</b></br><?php echo $GetData['No_Diamond']; ?></lable></div></div> 

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Diamond Value</b></br><?php echo $GetData['Diamond_Value']; ?></lable></div></div> 

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Solitaire Type</b></br><?php echo $GetData['Solitaire_Creation_Type']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Solitaire Quality</b></br><?php echo $GetData['SolitaireQuality']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-01"><div class="bg1"><lable><b class="text-primary">Solitaire Color</b></br><?php echo $GetData['SolitaireColor']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Solitaire Size</b></br><?php echo $GetData['SolitaireType']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">No of Solitaires</b></br><?php echo $GetData['No_Solitaire']; ?></lable></div></div> 

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Solitaire Value</b></br><?php echo $GetData['Solitaire_Value']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Color</b></br><?php echo $GetData['Color']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">Making Charges Type</b></br><?php echo $GetData['MakingChargesType']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg2"><lable><b class="text-primary">Making Charges Value</b></br><?php echo $GetData['MakingChargesValue']; ?></lable></div></div>

<div class="col-lg-3 col-12 mb-2 pr-0"><div class="bg1"><lable><b class="text-primary">MRP</b></br><?php echo $GetData['MRP']; ?></lable></div></div> 

<div class="col-lg-12 col-12 mb-2 pr-0" ><div class="bg2" style="height: 100px;"><lable><b class="text-primary">Product Description</b></br><?php echo $GetData['Remark']; ?></lable></div></div> 
    
</div>    
    
    
</div>      


<?php } ?>
