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

$SLN = $_REQUEST['SLN'];
$org = $_REQUEST['org'];
$igi_no = $_REQUEST['igi_no'];
$hm_no = "Yes";



$data = $Mainclass->Fetch_individual_data("gold_temp_product_master","*","SLN='".$SLN."'");	

$m = date('m');
$y = date('y');
$barcode = $data['Product_Id'] . $m . $y;


$added_on = date('Y-m-d H:i:s');
$User_Name = $_COOKIE['User_Name'];
$IP = $_SERVER['REMOTE_ADDR'];

$Mainclass->Update_Data("gold_temp_product_master","IGINo='".$igi_no."',Certifying_Organization='".$org."',HMNo='".$hm_no."',igi_updation='Yes',update_for_certification='Yes'","SLN='".$SLN."'");

//$Mainclass->Insert_Data("gold_products_master","Vendor_Name,VendorDesignCode,Metal_Type,ProductCategory,GoldWeight,ParentId,ProductName,Productid,Barcode,HSNCode,GoldPurity,Stock,StoneName,No_Stone,StoneValue,total_stone_price,Diamond_Creation_Type,DiamondQuality,DiamondColor,DiamondType,No_Diamond,DiamondValue,Diamond_Carat,total_diamond_price,Solitaire_Creation_Type,SolitaireQuality,SolitaireColor,SolitaireType,No_Solitaire,Solitaire_Value,sollitaire_Carat,total_sollitaire_price,Has_Size_Variation,Product_Size,MakingChargesType,MakingChargesValue,Remark,has_stone,has_diamond,has_solitaire,IGINo,Certifying_Organization,HMNo,Added_On,Added_By,IP,Active,Color","'".$data['Vendor_Name']."','".$data['VendorDesignCode']."','".$data['Metal_Type']."','".$data['ProductCategory']."','".$data['GoldWeight']."','".$data['ParentId']."','".$data['ProductName']."','".$data['Product_Id']."','".$barcode."','".$data['HSNCode']."','".$data['GoldPurity']."','1','".$data['StoneName']."','".$data['No_Stone']."','".$data['Stone_Value']."','".$data['total_stone_value']."','".$data['Diamond_Creation_Type']."','".$data['DiamondQuality']."','".$data['DiamondColor']."','".$data['DiamondType']."','".$data['No_Diamond']."','".$data['Diamond_Value']."','".$data['Diamond_Carat']."','".$data['total_diamond_price']."','".$data['Solitaire_Creation_Type']."','".$data['SolitaireQuality']."','".$data['SolitaireColor']."','".$data['SolitaireType']."','".$data['No_Solitaire']."','".$data['Solitaire_Value']."','".$data['sollitaire_Carat']."','".$data['total_sollitaire_price']."','".$data['Has_Size_Variation']."','".$data['Product_Size']."','".$data['MakingChargesType']."','".$data['MakingChargesValue']."','".$data['Remark']."','".$data['has_stone']."','".$data['has_diamond']."','".$data['has_solitaire']."','".$igi_no."','".$org."','".$hm_no."','".$added_on."','".$User_Name."' ,'".$IP."' ,'Yes','".$data['Color']."'");

?>