Last query SELECT CR.*,VU.* FROM certificate_report CR,vendor_user VU WHERE CR.user_id = 13677 and CR.factory_id in ('30','31','33', '34') and CR.user_id=VU.user_id and CR.valid_upto>=now() order by CR.factory_id desc<!--<link href='/assets/datatables/Datatables/css/jquery.dataTables.css' rel='stylesheet' >-->


<div id="print_div" style="border:1px solid black;">
<div>
<img alt="TCL" style="text-align:left;" title="TCL" src="https://ovr.troopcomfortslimited.co.in//resource/images/tcl_main_logo.png" />
<!--<div style="border: 2px solid #000;padding: 10px;width: 20%; margin-left: auto;">-->
    <p style="text-align:center;border: 2px solid #000;padding: 10px;width: 20%; margin-left: auto; float:right;height: 20%;margin-top:0%;"><br/>Troop Comforts Limited<br/>
              A Government of India Enterprise<br/>
              Ministry of Defence</p>
              <!--</div>-->
</div>

<div class="row">

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

    <div class="box-inner">
      <div class="box-content">
      <h3 style="text-align:center;text-decoration:underline;"><u>REGISTRATION CERTIFICATE</u></h3>
      <p style="text-align:center;">This is to certify that M/S Eastern Global Limited, Kanpur, Pin-208001 is registered at Troop Comforts Limited for following 
Items. </p>
        <table border="1px" cellspacing="0" cellpadding="0" style="margin-left: auto;margin-right: auto;text-align:center;width:80%">

            <thead>

                <tr>

                    <th width="4%">Sr No</th>

                  <th width="16%">Factory/ Unit</th>

                  <th width="70%">Item Nomenclature </th>

                  <th width="10%">Valid Upto</th>

                </tr>

            </thead>

	    <tbody>

                          <tr>
                  <td>1</td>
                  <td>Ordnance Clothing Factory Avadi </td>
                  <td style='text-align:left;'>Waterproof HDPE WOVEN SACK WHITE 75X50X100CM[21](
                         Specification : IS:11652-2000 )
                  </td>
                  <td>2026-02-10 </td>
                                <tr>
                  <td>2</td>
                  <td>Ordnance Clothing Factory Avadi </td>
                  <td style='text-align:left;'>WATER PROOF HDPE WOVEN SACK WHITE 75 X50X130CM[21](
                         Specification : SPECIFICATION IS : 11652-2000 AND THAT )
                  </td>
                  <td>2026-02-10 </td>
                  
        <tr>
        
            </tbody>

        </table>
        
                <p style="margin-left: 20%; margin-right: auto">Registration No. : 20800109AAACE4867G1ZH </br>
          <!--Initial Date of Registration : 2021-02-11 </br>-->
          <!--Valid Upto : 2026-02-10 </br>-->
          Conditions of Registration: Normal</br>
          This Registration has been carried out based on self-declared documents furnished by Vendor. </br>
          Changes, if any, in Address or constitution of the Firm, major Machinery/Equipment or Technology should be </br>
          intimated to the Registration Authority immediately. </br>
          The Registration Authority reserves the right to cancel this Registration Certificate at any time. </br>
          Registration will be valid for 03 years </br></p>
          <p style="text-align:right;margin-right:20%;">(Troop Comforts Limited) </br>
          (Signature is not </br>
          required) </br></p>
          <!--<p style="margin-left: 20%; margin-right: auto">M stands for Manufacturer</br>-->
          <!--S stands for Stockiest </br>-->
          <!--D Stands for Dealer </br>-->
          <!--SSA stands Sole Selling Agent </br>-->
          <!--I Stands for System Integrator </br>-->
          <!--NOTE: It is only a registration of vendor. It does not grant any special supply status to the </br>-->
          <!--Vendor. It is for the purpose of participation in Tender process only</p>-->
        </div>
        </div>
        
     
      </div>

  </div>

</div>
<input type="button"  style="text-align:center;" value="Print" onclick="" class="btn btn-success" id="Print">
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script> 
<script src='/admin/js/jquery.dataTables.min.js'></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/printThis/1.15.0/printThis.min.js"></script>


<script type="text/javascript">

	$(document).ready(function(){

		document.getElementById("Print").onclick = function () {

		 //alert("Hello");

		 $("#print_div").printThis({ 

				debug: false, 

				importCSS:false,

				printContainer: true,    

				pageTitle: "List of registered vendors", 

				loadCSS: ["https://ovr.troopcomfortslimited.co.in//resource/bootstrap/css/bootstrap.min.css","https://ovr.troopcomfortslimited.co.in//resource/css/form.css"],

				removeInline: false,        

				printDelay: 150,     
        noPageBreak: true,       

				header: null,             

				formValues: true,

				callback: function(){

							$(this).addhtml($("#print_foot").html());

							//$(this).css('width','100%');

							//$(this).css('word-break','break-all');

							$(this).addcss([ {"style" : "width","value":"100%" },{"style" : "word-break","value":"break-all"},{"style":"font-size","value":"4px" }]);

							$(this).delhtml('pag_nav');

							//$("#pag_nav").hide();

						}          

			}); 

		};

	});

</script>