<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>Chandrani Pearls Gold Billing</title>
<link rel="icon" type="image/jpg" href="dist/img/favicon.png?v=2">
  <!-- Google Font: Source Sans Pro -->
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
  
  <!-- DataTables -->
  <link rel="stylesheet" href="plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
  <link rel="stylesheet" href="plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
  <link rel="stylesheet" href="plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/adminlte.min.css">
  <link rel="stylesheet" href="dist/css/custom.css">
  <style>
#tooltip
{
    text-align: center;
    color: #FFF;
    background: #777777;
    position: absolute;
    z-index: 100;
    padding: 8px 15px;
	font-size:12px;
	font-family: 'Roboto', sans-serif;
}
 
    #tooltip:after /* triangle decoration */
    {
        width: 0;
        height: 0;
        border-left: 10px solid transparent;
        border-right: 10px solid transparent;
        border-top: 10px solid #777777;
        content: '';
        position: absolute;
        left: 50%;
        bottom: -10px;
        margin-left: -10px;
    }
 
        #tooltip.top:after
        {
            border-top-color: transparent;
            border-bottom: 10px solid #777777;
            top: -20px;
            bottom: auto;
        }
 
        #tooltip.left:after
        {
            left: 10px;
            margin: 0;
        }
 
        #tooltip.right:after
        {
            right: 10px;
            left: auto;
            margin: 0;
        }
.fulldiv {
    float: left;
    width: 100%;
    height: 100%;
    top: 0;
    bottom: 0;
    background-color: rgba(38, 53, 68, 0.80);
    background: rgba(38, 53, 68, 0.80);
    z-index: 1500;
    position: fixed;
}
	  .message_maindiv_new {
    width: 430px;
    height: auto;
    margin: 0px auto;
}
	  .message_div_new {
    float: left;
    width: 100%;
    height: auto;
    padding: 3%;
    background-color: #FFFFFF;
    margin-top: 300px;
}
	  .message_title {
    float: left;
    width: 100%;
    height: auto;
    text-align: center;
    font-size: 20px;
    color: #000000;
    margin-bottom: 20px;
    text-transform: capitalize;
	  }
	  
	  .bg-maroon{
	  background-color:#d5042d !important;
	  }
	  


        .col-sm-12 {
        -ms-flex: 0 0 100%;
        flex: 0 0 100%;
        max-width: 100%;
        font-size: 13px;
    }


    th{

        font-size: 13px;

        
    }

button:focus{

outline: none;

}


</style>
<script>
$( function()
{
    var targets = $( '[rel~=tooltip]' ),
        target  = false,
        tooltip = false,
        title   = false;
 
    targets.bind( 'mouseenter', function()
    {
        target  = $( this );
        tip     = target.attr( 'title' );
        tooltip = $( '<div id="tooltip"></div>' );
 
        if( !tip || tip == '' )
            return false;
 
        target.removeAttr( 'title' );
        tooltip.css( 'opacity', 0 )
               .html( tip )
               .appendTo( 'body' );
 
        var init_tooltip = function()
        {
            if( $( window ).width() < tooltip.outerWidth() * 1.5 )
                tooltip.css( 'max-width', $( window ).width() / 2 );
            else
                tooltip.css( 'max-width', 340 );
 
            var pos_left = target.offset().left + ( target.outerWidth() / 2 ) - ( tooltip.outerWidth() / 2 ),
                pos_top  = target.offset().top - tooltip.outerHeight() - 20;
 
            if( pos_left < 0 )
            {
                pos_left = target.offset().left + target.outerWidth() / 2 - 20;
                tooltip.addClass( 'left' );
            }
            else
                tooltip.removeClass( 'left' );
 
            if( pos_left + tooltip.outerWidth() > $( window ).width() )
            {
                pos_left = target.offset().left - tooltip.outerWidth() + target.outerWidth() / 2 + 20;
                tooltip.addClass( 'right' );
            }
            else
                tooltip.removeClass( 'right' );
 
            if( pos_top < 0 )
            {
                var pos_top  = target.offset().top + target.outerHeight();
                tooltip.addClass( 'top' );
            }
            else
                tooltip.removeClass( 'top' );
 
            tooltip.css( { left: pos_left, top: pos_top } )
                   .animate( { top: '+=10', opacity: 1 }, 50 );
        };
 
        init_tooltip();
        $( window ).resize( init_tooltip );
 
        var remove_tooltip = function()
        {
            tooltip.animate( { top: '-=10', opacity: 0 }, 50, function()
            {
                $( this ).remove();
            });
 
            target.attr( 'title', tip );
        };
 
        target.bind( 'mouseleave', remove_tooltip );
        tooltip.bind( 'click', remove_tooltip );
    });
});
</script>
	
	</head>
	<body class="hold-transition sidebar-mini">
		
		
<div class="wrapper">
  <!-- Navbar -->
    <?php include ("topheader.php"); ?>
  <!-- /.navbar -->
  <!-- Main Sidebar Container -->
    <?php include ("sidemenu.php"); ?>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1></h1>
                </div>
                <div class="col-sm-6">
                    
                </div>
            </div>
        </div>
    </section>
    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
			<div class="col-12">
      <div class="card">
                        <div class="card-header">
        <h4>Export For Certification 
            <!-- <button type="button" class="btn btn-custom" style="float: right; background-color: #ffd700; color: #062e50;" data-toggle="modal" data-target="#ratemodal"><i class="fa-solid fa-circle-plus fa-beat"></i> ADD RATE</button> -->
        </h4>
    </div>




            <div class="card-body">
            <a href="export-for-certification.php"><button type="button" class="btn btn-custom" style="float: right; background-color: #17a2b8; color: #ffff;" data-toggle="modal" data-target="#ratemodal"> Export</button></a>


<?php 


$table_name = "gold_temp_product_master";
$fields = "*";
$condition = "SLN>0 and add_to_product='No' and igi_updation='No' and confirm='Yes' ORDER BY SLN DESC"; // Modify as necessary

// Fetch data from the table
$products = $Mainclass->Fetch_multiple_data($table_name, $fields, $condition);




?>

                         <table id="example1" class="table table-bordered table-striped" >
    <thead >
        <tr >
            <th>SLN</th>
            <th>Category</th>
            <th>Product Id</th>
            <th>Product Name</th>
            <th>Gold Purity</th>
            <th>Gold Weight</th>
            <th>Stone Details</th>
            <th>Diamond Details</th>
            <th>Solitaire Details</th>

        </tr>
    </thead>
    <tbody>
        <?php
        $i = 1;
        foreach ($products as $product) {


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

 if($product['has_stone']=="No"){

        $Stone_Details = "N/A";

 }

else{

       $Stone_Details = "Stone Name : ".$product['StoneName']."<br>"."Stone Quantity : ".$product['No_Stone'];


 }


  if($product['has_diamond']=="No"){

        $Diamond_Details = "N/A";

 }

else{

        
        $Diamond_Details = "Diamond Type : ".$product['Diamond_Creation_Type']."<br>"."Diamond Quality : ".$product['DiamondQuality']."<br>"."Diamond Color : ".$product['DiamondColor']."<br>"."Diamond Size : ".$product['DiamondType']."<br>"."Diamond Quantity : ".$product['No_Diamond'];

 }

  if($product['has_solitaire']=="No"){

        $Solitaire_Details = "N/A";

 }

else{

        $Solitaire_Details = "Solitaire Type : ".$product['Solitaire_Creation_Type']."<br>"."Solitaire Quality : ".$product['SolitaireQuality']."<br>"."Solitaire Color : ".$product['SolitaireColor']."<br>"."Solitaire Size : ".$product['SolitaireType']."<br>"."Solitaire Quantity : ".$product['No_Solitaire'];

 }
 
        ?>
        

        <tr>
            <td><?php echo $i; ?></td>
            <td><?php echo $cat['Category']; ?></td>
            <td><?php echo $product['Product_Id']; ?></td>
            <td><?php echo $product['ProductName']; ?></td>
            <td><?php echo $product['GoldPurity']; ?></td>
            <td><?php echo $product['GoldWeight']; ?> GM</td>
			<td><?php echo $Stone_Details; ?></td>
            <td><?php echo $Diamond_Details; ?></td>
            <td><?php echo $Solitaire_Details; ?></td>

        </tr>
        <?php
            $i++;
        }
        ?>
    </tbody>
</table>



                        </div>
                    </div> 
				</div>
            <!-- /.card -->
			</div>
			<!--/.row-->    
        
      </div>
      <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
   <?php include ("footer.php"); ?>
  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<!--<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>-->
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- DataTables  & Plugins -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="plugins/jszip/jszip.min.js"></script>
<script src="plugins/pdfmake/pdfmake.min.js"></script>
<script src="plugins/pdfmake/vfs_fonts.js"></script>
<script src="plugins/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="plugins/datatables-buttons/js/buttons.colVis.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- Page specific script -->
<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true,
      "lengthChange": false,
      "autoWidth": false,
      "searching": true,
      "scrollX": true, // Enable horizontal scroll
      "paging": false,
      //"buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
      "scrollX": true, // Enable horizontal scroll
      "columnDefs": [
        { "width": "25%", "targets": 2 }, // Set width for the third column
      ]
    });
  });
  
  
</script>
	<script>
    /*ClassicEditor
        .create( document.querySelector( '#responsibility' ) )
        .catch( error => {
            console.error( error );
        } );*/
		var myEditor;

    ClassicEditor
        .create( document.querySelector( '#responsibility' ) )
        .then( editor => {
            console.log( 'Editor was initialized', editor );
            myEditor = editor;
        } )
        .catch( err => {
            console.error( err.stack );
        } );
    
</script>
	<script>
		function close_modal()
  {
    $(':input').val('');
    $('#ratemodal').modal('hide');
    $(':input').css('border-color','');
  }	
  

  
		</script>	
	

		

		

<div class="modal fade" id="product_modal" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">



<div class="modal-dialog">
<div class="modal-content">

<div class="modal-header" style="background:#fff;border:none">
<h4 class="modal-title fs-5" id="exampleModalLabel">Update IGI and Hallmark No</h4>
<i class="fa-solid fa-xmark" data-bs-dismiss="modal" style="cursor: pointer;"></i>
</div>


<div class="modal-body" style="background-color: #fff !important;">
<div class="row">

<input type="hidden" name="slno" id="slno" >

<div class="col-12" id="form_select">
<div class="form-group">
<label>Certifying Organization <span class="text text-danger">*</span></label>
<select class="form-control err" id="org" name="org" onchange="remove_error()">
<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" id="form_select">

<div class="form-group">
<label>Certification No <span class="text text-danger">*</span></label>
<input type="text" name="igi_no" id="igi_no" placeholder=" Enter Certification No " class="form-control err" onkeypress="remove_error()"  autocomplete="off" >
</div>  
            
</div>

<div class="col-12" id="form_select">

<div class="form-group">
<label>Hallmark No <span class="text text-danger">*</span></label>
<input type="text" name="hm_no" id="hm_no" placeholder=" Enter Hallmark No " class="form-control err" onkeypress="remove_error()"  autocomplete="off" >
</div>  
            
</div>


</div>
</div>


<div class="modal-footer">
<button type="button" class="btn btn-default" data-bs-dismiss="modal">Close</button>
<button type="button" id="add_rate_btn" class="btn btn-custom" onclick="modal_valid()" >Save</button>
</div>

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


		
		
		
</body>
</html>