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

$Barcode = $_REQUEST['Barcode'];

$product = $Mainclass->Fetch_individual_data("gold_products_master","*","Barcode='".$Barcode."'");

?>


<div class="row">
	
	
	<div class="col-12">
			<div class="form-group">
            <label>Select Quality: <span class="text text-danger">*</span></label>
            <select class="form-control" id="quality" name="quality">
			  <option value="">Select Quality</option>
				<?php
				$Get_Karat=$Mainclass->Fetch_multiple_data('diamond_quality_code',"*","Inactive='0'");
				foreach($Get_Karat as $karat)
				{
					?>
				<option value="<?php echo $karat['Code'];?>"><?php echo $karat['Code'];?></option>			  
				<?php
				}
				?>

			  </select>            
          </div>
	
	</div>
<div class="col-12">

            <div class="form-group">
            <label>Select Color 1: <span class="text text-danger">*</span></label>
            <select class="form-control" id="color" name="color">
              <option value="">Select Color</option>
                <?php
                $Get_Karat=$Mainclass->Fetch_multiple_data('diamond_color_code',"*","Inactive='0'");
                foreach($Get_Karat as $karat)
                {
                    ?>
                <option value="<?php echo $karat['Code'];?>"><?php echo $karat['Code'];?></option>            
                <?php
                }
                ?>

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

<div class="col-12">
		            <div class="form-group">
            <label>Select Color 2 : </label>
            <select class="form-control" id="color2" name="color2">
              <option value="">Select Color</option>
                <?php
                $Get_Karat=$Mainclass->Fetch_multiple_data('diamond_color_code',"*","Inactive='0'");
                foreach($Get_Karat as $karat)
                {
                    ?>
                <option value="<?php echo $karat['Code'];?>"><?php echo $karat['Code'];?></option>            
                <?php
                }
                ?>

              </select>            
          </div>		
	
	</div>
	
	<div class="col-12">
			<div class="form-group">
            <label>Select Quality: <span class="text text-danger">*</span></label>
            <select class="form-control" id="quality" name="quality">
			  <option value="">Select Quality</option>
				<?php
				$Get_Karat=$Mainclass->Fetch_multiple_data('diamond_quality_code',"*","Inactive='0'");
				foreach($Get_Karat as $karat)
				{
					?>
				<option value="<?php echo $karat['Code'];?>"><?php echo $karat['Code'];?></option>			  
				<?php
				}
				?>

			  </select>            
          </div>
	
	</div>
<div class="col-12">

            <div class="form-group">
            <label>Select Color 1: <span class="text text-danger">*</span></label>
            <select class="form-control" id="color" name="color">
              <option value="">Select Color</option>
                <?php
                $Get_Karat=$Mainclass->Fetch_multiple_data('diamond_color_code',"*","Inactive='0'");
                foreach($Get_Karat as $karat)
                {
                    ?>
                <option value="<?php echo $karat['Code'];?>"><?php echo $karat['Code'];?></option>            
                <?php
                }
                ?>

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

<div class="col-12">
		            <div class="form-group">
            <label>Select Color 2 : </label>
            <select class="form-control" id="color2" name="color2">
              <option value="">Select Color</option>
                <?php
                $Get_Karat=$Mainclass->Fetch_multiple_data('diamond_color_code',"*","Inactive='0'");
                foreach($Get_Karat as $karat)
                {
                    ?>
                <option value="<?php echo $karat['Code'];?>"><?php echo $karat['Code'];?></option>            
                <?php
                }
                ?>

              </select>            
          </div>		
	
	</div>	
	
<div class="col-12">

<div class="form-group">
            <label>Certifying Organization <span class="text text-danger">*</span></label>
<select class="form-control err" id="org<?php echo $product['SLN'] ?>" name="org<?php echo $product['SLN'] ?>" >
<option value="">--- please select---</option>
<?php
$fetch_p_cate=$Mainclass->Fetch_multiple_data("certifying_organization","Organization","Active='Yes' order by Organization asc");
foreach ($fetch_p_cate as $get_p_cate)
{
?>
<option value="<?php echo $get_p_cate['Organization']?>"><?php echo $get_p_cate['Organization']?></option>
<?php
}
?>
</select>
	
</div>	
	
</div>
	
	
	
<div class="col-12">

<div class="form-group">
            <label>Certification No <span class="text text-danger">*</span></label>
	
<input type="text" class="form-control" value="<?php echo $product['IGINo']; ?>" placeholder="Enter Certification No" autocomplete="off" name="igi_no<?php echo $product['SLN'] ?>" id="igi_no<?php echo $product['SLN'] ?>"> 
	
</div>	
	
</div>	

	
<div class="col-12">

<div class="form-group">
            <label>Hallmark No <span class="text text-danger">*</span></label>
	
<input type="text" class="form-control" value="<?php echo $product['HMNo']; ?>" placeholder="Enter Hallmark No" autocomplete="off" name="hm_no<?php echo $product['SLN'] ?>" id="hm_no<?php echo $product['SLN'] ?>">
	
</div>	
	
</div>		
	
</div>