EVOLUTION-NINJA

Edit File: packing_list_weight_note.php

<?php
 
?>
<!DOCTYPE HTML>
<html lang="en-US">
<head>
		<meta charset="UTF-8">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
		<title>Weight Note</title>
		<script type="text/javascript" src="<?php echo base_url('assets/js/jquery-3.2.1.min.js');?>"></script>
		<script src="<?php echo base_url('assets/js/bootstrap.min.js');?>"></script>

<!--<?php //if($access_row->preview_submit == 1) { ?>
 <button type="button" onclick="goods_details()" id="submit_booking_print1" style="
	margin-top: 13px;
	right: 180px;
	margin-right: 4px;
	padding-bottom: 1px;
	padding-left: 15px;
	padding-right: 15px;
	background: rgb(72,91,127);
	color: white;
	font-size: 22px;
	position:absolute;
	"
	>Submit</button>

<?php //} else { ?>
 <button type="button" onclick="goods_details()" id="submit_booking_print1" style="
	margin-top: 13px;
	right: 180px;
	margin-right: 4px;
	padding-bottom: 1px;
	padding-left: 15px;
	padding-right: 15px;
	background: rgb(72,91,127);
	color: white;
	font-size: 22px;
	position:absolute;cursor: not-allowed;"
	 disabled>Submit</button>
<?php //} ?>-->

<?php if($fetchh->confirm == 'Yes')  { ?>
<input type="button" onclick="back_function()" id="back_button" value="Back" style="
	margin-top: 13px;
    right:100px;
    padding-top: 2px;
    padding-bottom: 1px;
    padding-left: 15px;
    padding-right: 15px;
         float: right;margin-right: 5px;">

<input type="button" id="export_id" onclick="tableToExcel('excelexport', 'W3C Example Table')" value="Export to Excel" style="
	margin-top: 13px;
    right:100px;
    padding-top: 2px;
    padding-bottom: 1px;
    padding-left: 15px;
    padding-right: 15px;
        float: right;margin-right: 5px; ">
        
        <button type="button" id="generate_pdf_btn" style="margin-top: 14px;float: right;margin-right: 5px;" class="btn btn-primary" >Export to PDF</button>

<?php } else { ?>
<input type="button" onclick="back_function()" id="back_button" value="Back" style="
	margin-top: 13px;
    right:100px;
    padding-top: 2px;
    padding-bottom: 1px;
    padding-left: 15px;
    padding-right: 15px;
         float: right;margin-right: 5px;">

<input type="button" id="export_id"  onclick="tableToExcel('excelexport', 'W3C Example Table')" value="Export to Excel" style="
	margin-top: 13px;
    right:100px;
    padding-top: 2px;
    padding-bottom: 1px;
    padding-left: 15px;
    padding-right: 15px;
        float: right;margin-right: 5px; " disabled>
        
        <button type="button" id="generate_pdf_btn" style="margin-top: 14px;float: right;margin-right: 5px;" class="btn btn-primary" disabled>Export to PDF</button>
<?php } ?>

</div>
<body>
<div class="invoice_table" id="print_report" style="background-color:white;">
<div class="row">
<h4 style="text-align:center; padding-top:1%;font-size: 20px;padding-left: 8%;">Packing List / Weight Note</h4>
</div>
	<table class="table" border="1" style="width:100%;border-bottom:1px solid transparent;">
		<tr>
			<td colspan="" rowspan="" style="width:25%;border-right:1px solid transparent;border-bottom:1px solid transparent;"><img src="<?php echo base_url('assets/img/logo2.png');?>" class="img-responsive"></td>
			<td colspan="" style="width:25%;border-bottom:1px solid transparent;border-left:1px solid transparent;">Phone No. :+91 80 41888298 <br> Fax No. : +91 80 25598300 <br> E- Mail. : sales@swansilk.com <br> WEBSITE : www.swansilk.com</td>
			<td colspan="" style="width:25%;">Invoice No & date <br>  <b style="font-size: 12px;"><?php echo $fetch->invoice_num; ?> <br/> <?php echo $fetch->invoice_date; ?></b> </td>
			
			
			
				<td colspan="" style="width:25%;">Exporter's Ref. <br> <b><input type="text" id="myInput" style="font-weight:bold;width:95%;height: 18px;font-size:11px;" value="<?php echo $fetch->weight_exp_ref; ?>"> </b></td>
			
		
			
		</tr>
		<tr>
			<td colspan="2" style="clear:both; font-weight:600;border-top:1px solid transparent;border-bottom:1px solid transparent;">P.B. 25210, #40, 4TH CROSS, RESIDENCY ROAD, BANGALORE - 560 025, INDIA<br>State:Karnataka  &nbsp; District:Bangalore Urban &nbsp; State Code:29</td>
			<?php
    $dist = '';
    
    //print_r($dist_order_no);
    //die();
    foreach($dist_order_no as $val){
        $dist .= $val->orderNo.",";
    }
    
    $dist =  rtrim($dist, ", ");
    
    $other = '';
    
    
    foreach($dist_order_no as  $key=>$val){
        $temp = $val->oslNo;
        if($key == 0){
            if(strlen($temp) == 9){
                $other .= substr($temp,2,2)."0";
                $other .= substr($temp,-2,2);
            }
            else if(strlen($temp) == 10){
                $other .= substr($temp,2,2);
                $other .= substr($temp,-3,3);
            }
        }
        else{
             if(strlen($temp) == 9){
                $other .= ",".substr($temp,-2,2);
            }
            else if(strlen($temp) == 10){
                $other .= ",".substr($temp,-3,3);
            }
          
        }
        
    }
    
   
     //print_r($dist);
    //echo $other;
    //die();
    
    //print_r($dist_osl_no);
    // echo $other;
     //die();
?>
			
					<td colspan="" style="border-right:1px solid transparent;">Buyer's order no & Date<br> <b> 
			<?php if($fetch->weight_order_num != ''){
                ?>
                     <input type="text" id="order_num_myInput1" style="font-weight:bold;width: 99%;height: 18px;font-size:10px !important;" value="<?php echo $fetch->weight_order_num; ?>">
                <?php
            }
            else{
                ?>
                     <input type="text" id="order_num_myInput1" style="font-weight:bold;width: 99%;height: 18px;font-size:10px !important;" value="<?php echo $dist; ?>">
                <?php
            }
            ?>

<input type="hidden" id="invoice_no" style=" width: ;height: 18px;font-size:12px;" value="<?php echo $fetch->invoice_num; ?>">
				</b></td>
			<td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> 
				<?php if($fetch->weight_other_ref != ''){
                ?>
                     <input type="text" id="order_num_myInput1" style="font-weight:bold;width: 99%;height: 18px;font-size:10px !important;" value="<?php echo $fetch->weight_other_ref; ?>">
                <?php
            }
            else{
                ?>
                     <input type="text" id="order_num_myInput1" style="font-weight:bold;width: 99%;height: 18px;font-size:10px !important;" value="<?php echo $other; ?>">
                <?php
            }
            ?>
			
		</tr>
	</table>
	<table class="table" border="1" style="width:100%;border-top:1px solid transparent;">
		<tr>
			<td style="width:8%;border-right: 1px solid transparent;">Marks & Nos Container No</td>
			<td style="width:5%;border-right: 1px solid transparent;border-left: 1px solid transparent;"></td>
			<td colspan="" style="width:15%;border-right: 1px solid transparent;border-left: 1px solid transparent;">No & kind of Packages</td>
			<td colspan="3" style="width:30%;border-left: 1px solid transparent;">Description of goods</td>
			<td style="width:10%;">Quantity</td>
			<td colspan="3" style="width:20%;">Amount</td>
		</tr>
		<tr>
			<td style="border-right: 1px solid transparent;border-bottom: 1px solid transparent;font-weight: bold;font-size: 11px;"><b><?php echo $fetch->invoice_num . '/' . '1-' . $count_package_fetch_invoice ?></b></td>
			
					<td colspan="5" style="border-left: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput2" name="des" rows="2" style="width: 94%;font-size:13px;font-weight: bold;line-height: 1.6;font-family: 'Times New Roman', Times, serif;"><?php echo $fetch->weight_first_details; ?></textarea></td>
			
			
			
			<td colspan="" style="border-bottom: 1px solid transparent;"></td>
			<td colspan="3" style="border-bottom: 1px solid transparent;"></td>
		</tr>
		<tr>
			<td style="border-right: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>BOX No.</b></td>
			<td style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>PC.No.</b></td>
			<td colspan="" style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>DESCRIPTION</b></td>
<td colspan="" style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>DESIGN</b></td>
			<td colspan="" style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>ART. NO.</b></td>
			<td colspan="" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>SHADE</b></td>
			<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>QTY</b></td>
			<td style="border-right: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>NET WT.</b></td>
<td style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>GROSS WT.</b></td>
			<td colspan="" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>WIDTH CMS</b></td>
		</tr>
		
		
		<?php $i=1;  foreach($group_package_fetch_invoice as $key=>$pkgg) {  ?>

<tr class="product">
				
				
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;    font-size: 12px;"><b><?php echo $fetchh->invoice . '/' . $pkgg->box_id ;?></b></td>
			
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;    font-size: 12px;"><?php  foreach($package_fetch_invoice1 as $pkg) {  if($pkg->box_id == $pkgg->box_id) { ?><p><b><?php echo $i; ?> </b><?php $i++; }  ?></p><?php  } ?></td>
			
			<td style="font-size:12px !important;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;line-height:1.6;"><?php  foreach($package_fetch_invoice_des_article as $pkgh) {  if($pkgh->box_id == $pkgg->box_id) { ?><p><b><?php if($pkgh->description == '') { echo $pkgh->des; } else { echo $pkgh->description; } ?></p><?php   }} ?></td>
			
			
	<td style="border-right: 1px solid transparent;vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;    font-size: 12px;"><?php  foreach($package_fetch_invoice3 as $pkg3) {  if($pkg3->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg3->design; ?> </b><?php  }  ?></p><?php  } ?></td>
	
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;    font-size: 12px;"><?php  foreach($package_fetch_invoice2 as $pkg2) {  if($pkg2->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg2->article; ?></b> </p><?php  }  ?><?php  } ?></td>
			
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;    font-size: 12px;"><?php  foreach($package_fetch_invoice3 as $pkg3) {  if($pkg3->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg3->shades; ?> </b><?php  }  ?></p><?php  } ?></td>
			
			
			<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;font-size: 12px;"><?php  foreach($package_fetch_invoice4 as $pkg4) {  if($pkg4->box_id == $pkgg->box_id) { ?><p></p><b><?php echo number_format($pkg4->exp_qty,2); ?> </b><?php  }  ?></p><?php  } ?><p><span style="border-bottom:2px solid black;border-top:2px solid black;"><?php echo number_format((float)$package_fetch_invoice7[$key]->exp_qty, 2, '.', ''); ?></span></p></td>
						
			<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;    font-size: 12px;"><b><?php  foreach($package_fetch_invoice5 as $pkg5) {  if($pkg5->box_id == $pkgg->box_id) { ?><p><b><?php echo number_format($pkg5->exp_wt,3); ?> </b><?php  }  ?></p><?php  } ?><p><span style="border-bottom:2px solid black;border-top:2px solid black;"><?php echo number_format((float)$package_fetch_invoice8[$key]->exp_wt, 3, '.', ''); ?></span></p>
			</td>

<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;    font-size: 12px;"><b><?php  foreach($group_box_package_fetch_invoice as $pkg22) {  if($pkg22->box_id == $pkgg->box_id) { ?><p><span style="border-bottom:2px solid black;border-top:2px solid black;"><b><?php echo number_format($pkg22->gross_wt,3); ?></b> </p><?php  }  ?><?php  } ?></b></span></p></td>

<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;font-size: 12px;"><?php  foreach($package_fetch_invoice6 as $pkg6) {  if($pkg6->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg6->width; ?> </b><?php  }  ?></p><?php  } ?></td>
				
							
		</tr>
		
			<?php   $i+1; } ?>
			<tr>
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b>Total : <?php echo $count_package_fetch_invoice . ' ' . 'PKGS' ; ?></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b> <?php echo $count_package_fetch_invoice1 . ' ' . 'PCS' ; ?></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b></b></td>
                                        <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;font-size: 12px;"><b></b></td>
					
					<td style="border-top: 1px solid transparent;font-size: 12px;"><b><?php echo number_format((float)$package_fetch_invoice9->exp_qty, 2, '.', '') . ' ' . $fetch->units; ?></b></td>
					
					<td style="border-top: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b><?php echo number_format((float)$package_fetch_invoice10->exp_wt, 3, '.', '') . ' ' . 'KGS.NET WT' ; ?> </b></td>
					<td colspan="" style="border-top: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;font-size: 12px;"><b><?php echo number_format((float)$group_sum_gross_box_package_fetch_invoice->gross_wt, 3, '.', '') . ' ' . 'GROSS WT' ; ?> </b></td>
					<td style="border-top: 1px solid transparent;border-left: 1px solid transparent;border-right:1px solid transparent;font-size: 12px;"></td>
				</tr>

<tr>
					<td colspan="6" style="border-top: 1px solid transparent !important;"></td>
					<td colspan="4"><b>For Deco Textil <br><br><br><br>Authorised Signatory</b></td>
				</tr>
<tr>
					<td colspan="" style="">Box Size (Inches)</td>
					<td colspan="" style="">Box No</td>
					<td colspan="" style="">CBM <b> (Total CBM : <?php echo $total_cbms; ?>) </b> </td>
                                        <td colspan="2"></td>
					<td colspan="5"></td>
				</tr>
				
				<?php foreach($box_summary as $key=>$s) {  $new_width =0; $new_width = $box_s[$key] * $s->total_cmb; ?>
				<tr>	
					<td><?php echo  $s->box_dimension; ?></td>	
				<td><?php echo  $box_s[$key]; ?></td>
				<td><?php echo  $new_width ; ?></td>
				<td colspan="2"></td>
					<td colspan="5"></td>
						</tr>
						<?php } ?>
	</table>
	</div>
</body>
</html>
<script>
$ = jQuery;

$( "#generate_pdf_btn" ).click(function() {
     //   alert();
  make_product_sheet();
});

function make_product_sheet() {
    var today = new Date();
var dd = today.getDate();
var mm = today.getMonth() + 1; //January is 0!

var yyyy = today.getFullYear();
var d = dd + '/' + mm + '/' + yyyy;

console.log("#generate_pdf_btn clicked");
    var pdf = new jsPDF('p', 'pt', 'a4');
    pdf.addHTML(document.getElementById("print_report"), function() {

ps_filename = "Fabric-Weight-Note-"+d;
        pdf.save(ps_filename+'.pdf');
    });
}
</script>
<script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script>
<link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" >
	<script>
$(document).ready(function(){
	$("#booking_print1").click(function(){
		$('#booking_print1').toggle();
		$('#back_button').toggle();
$('#export_id').toggle();
$('#generate_pdf_btn').toggle();
			$('#submit_booking_print1').toggle();
		var myInput = document.getElementById("myInput").style;
   myInput.borderStyle="none";
   
   var myInput1 = document.getElementById("myInput1").style;
   myInput1.borderStyle="none";
   
   var myInput2 = document.getElementById("myInput2").style;
   myInput2.borderStyle="none";
   
  //var myInput3 = document.getElementById("myInput3").style;
  // myInput3.borderStyle="none";
   $("textarea").css({"resize": "none"});
   
    var order_num_myInput1 = document.getElementById("order_num_myInput1").style;
   order_num_myInput1.borderStyle="none";
 //  $("textarea").css({"resize": "none"});
  	var divToPrint=document.getElementById("print_report");
		window.print();

});

});
	
	
	function goods_details()
	{
	    
	    var invoice_no=$('#invoice_no').val();
		var exp_ref=$('#myInput').val();
		var order_no=$('#order_num_myInput1').val();
		var other_ref=$('#myInput1').val();
		var first_det=$('#myInput2').val();
		var box_details=$('#myInput3').val();
	
			$.ajax({
            url:"<?php echo base_url('packing_list/add_weight_note_preview_data');?>",

type:"POST",
           
				data:{'invoice_no':invoice_no,'exp_ref':exp_ref,'order_no':order_no,'other_ref':other_ref,'first_det':first_det,'box_details':box_details},

async:false,

success:function(data)
				 {
swal({
	 title: "Added Sucessfully",
	  text: "",
	 
	});
				 }
			});
	}
	
	
	</script>
	
	<script type="text/javascript">
	var tableToExcel = (function() {
 var uri = 'data:application/vnd.ms-excel;base64,'
    , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="https://www.w3.org/TR/REC-html40"><head><link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/'); ?>" /></head><body><table>{table}</table></body></html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
  return function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
    window.location.href = uri + base64(format(template, ctx))
  }
})()
</script>

<div class="invoice_table" id="excelexport" style="display:none">
<table class="table" border="" style="width:100%;border: none;">
<tr>
<td colspan="10" style="text-align: center;line-height: initial !important;"> <h4 style="font-size: 20px;">Packing List / Weight Note<br/><span class="buyer" style="font-size: 15px;"></span></h4></td>
</tr>
			
</table>
	<table class="table" border="1" style="width:100%;border-bottom:1px solid transparent;">
		<tr>
			<td colspan="2" rowspan="" style="width:25%;border-right:1px solid transparent;border-bottom:1px solid transparent;"><img src="https://drive.google.com/uc?export=view&id=0B6tsz21Ma0kFbUMybjRSSzhDc19wZ0FXdHRXTDRJZVJENmZv" class="img-responsive"></td>
			<td colspan="1" style="width:25%;border-bottom:1px solid transparent;border-left:1px solid transparent;">Phone No. :+91 80 41888298 <br> Fax No. : +91 80 25598300 <br> E- Mail. : sales@swansilk.com <br> WEBSITE : www.swansilk.com</td>
			<td colspan="3" style="width:25%;">Invoice No & date <br>  <b><?php echo $fetch->invoice_num; ?> <br/> <?php echo $fetch->invoice_date; ?></b> </td>
			<td colspan="4" style="width:25%;">Exporter's Ref. <br> <b><?php echo $fetch->weight_exp_ref; ?></b></td>
		</tr>
		<tr>
			<td colspan="3" style="clear:both; font-weight:600;border-top:1px solid transparent;border-bottom:1px solid transparent;">P.B. 25210, #40, 4TH CROSS, RESIDENCY ROAD, BANGALORE - 560 025, INDIA</td>
			
			
					<td colspan="3" style="border-right:1px solid transparent;">Buyer's order no & Date<br> <b> <?php echo $fetch->weight_order_num; ?>
			
				</b></td>
			<td colspan="4" style="border-left:1px solid transparent;">Other Reference's <br> <?php echo $fetch->weight_other_ref; ?></td>
			
			
		</tr>
	</table>
	<table class="table" border="1" style="width:100%;border-top:1px solid transparent;">
		<tr>
			<td style="width:8%;border-right: 1px solid transparent;">Marks & Nos Container No</td>
			<td style="width:5%;border-right: 1px solid transparent;border-left: 1px solid transparent;"></td>
			<td colspan="" style="width:15%;border-right: 1px solid transparent;border-left: 1px solid transparent;">No & kind of Packages</td>
			<td colspan="3" style="width:30%;border-left: 1px solid transparent;">Description of goods</td>
			<td style="width:10%;">Quantity</td>
			<td colspan="3" style="width:20%;">Amount</td>
		</tr>
		<tr>
			<td style="border-right: 1px solid transparent;border-bottom: 1px solid transparent;"><b><?php echo $fetch->invoice_num . '/' . '1-' . $count_package_fetch_invoice ?></b></td>
			
					<td colspan="4" style="border-left: 1px solid transparent;border-bottom: 1px solid transparent;"><?php echo $fetch->weight_first_details; ?></td>
			
			
			
			<td colspan="" style="border-bottom: 1px solid transparent;"></td>
			<td colspan="3" style="border-bottom: 1px solid transparent;"></td>
		</tr>
		<tr>
			<td style="border-right: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>BOX No.</b></td>
			<td style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>PC.No.</b></td>
			<td colspan="" style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>DESCRIPTION</b></td>
<td colspan="" style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>DESIGN</b></td>
			<td colspan="" style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>ART. NO.</b></td>
			<td colspan="" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>SHADE</b></td>
			<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>QTY</b></td>
			<td style="border-right: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>NET WT.</b></td>
<td style="border-right: 1px solid transparent;border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>GROSS WT.</b></td>
			<td colspan="" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>WIDTH CMS</b></td>
		</tr>
		
		
		<?php $i=1;  foreach($group_package_fetch_invoice as $key=>$pkgg) {  ?>

<tr class="product">
				
				
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;"><b><?php echo $fetchh->invoice . '/' . $pkgg->box_id ;?></b></td>
			
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><?php  foreach($package_fetch_invoice1 as $pkg) {  if($pkg->box_id == $pkgg->box_id) { ?><p><b><?php echo $i; ?> </b><?php $i++; }  ?></p><?php  } ?></td>
			
		<td style="font-size:9px !important;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><?php  foreach($package_fetch_invoice_des_article as $pkgh) {  if($pkgh->box_id == $pkgg->box_id) { ?><p><b><?php if($pkgh->description == '') { echo $pkgh->des; } else { echo $pkgh->description; } ?></p><?php   }} ?></td>

<td style="border-right: 1px solid transparent;vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;"><?php  foreach($package_fetch_invoice3 as $pkg3) {  if($pkg3->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg3->design; ?> </b><?php  }  ?></p><?php  } ?></td>

<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><?php  foreach($package_fetch_invoice2 as $pkg2) {  if($pkg2->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg2->article; ?></b> </p><?php  }  ?><?php  } ?></td>
			
			<td style="vertical-align: top;border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;"><?php  foreach($package_fetch_invoice3 as $pkg3) {  if($pkg3->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg3->shades; ?> </b><?php  }  ?></p><?php  } ?></td>
			
			
			<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><?php  foreach($package_fetch_invoice4 as $pkg4) {  if($pkg4->box_id == $pkgg->box_id) { ?><p></p><b><?php echo number_format($pkg4->exp_qty,2); ?> </b><?php  }  ?></p><?php  } ?><p><span style="border-bottom:2px solid black;border-top:2px solid black;"><?php echo number_format((float)$package_fetch_invoice7[$key]->exp_qty, 2, '.', ''); ?></span></p></td>
						
			<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;"><b><?php  foreach($package_fetch_invoice5 as $pkg5) {  if($pkg5->box_id == $pkgg->box_id) { ?><p><b><?php echo number_format($pkg5->exp_wt,3); ?> </b><?php  }  ?></p><?php  } ?><p><span style="border-bottom:2px solid black;border-top:2px solid black;"><?php echo number_format((float)$package_fetch_invoice8[$key]->exp_wt, 3, '.', ''); ?></span></p>
			</td>

<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b><?php  foreach($group_box_package_fetch_invoice as $pkg22) {  if($pkg22->box_id == $pkgg->box_id) { ?><p><span style="border-bottom:2px solid black;border-top:2px solid black;"><b><?php echo number_format($pkg22->gross_wt,3); ?></b> </p><?php  }  ?><?php  } ?></b></span></p></td>

<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;"><?php  foreach($package_fetch_invoice6 as $pkg6) {  if($pkg6->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg6->width; ?> </b><?php  }  ?></p><?php  } ?></td>
				
							
		</tr>
		
			<?php   $i+1; } ?>
			<tr>
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;"><b>Total : <?php echo $count_package_fetch_invoice . ' ' . 'PKGS' ; ?></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b> <?php echo $count_package_fetch_invoice1 . ' ' . 'PCS' ; ?></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b></b></td>
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b></b></td>
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b></b></td>
					
					<td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;"><b></b></td>
					
					<td style="border-top: 1px solid transparent;"><b><?php echo number_format((float)$package_fetch_invoice9->exp_qty, 2, '.', '') . ' ' . $fetch->units; ?></b></td>
					
					<td style="border-top: 1px solid transparent;border-right: 1px solid transparent;"><b><?php echo number_format((float)$package_fetch_invoice10->exp_wt, 3, '.', '') . ' ' . 'KGS.NET WT' ; ?> </b></td>
					<td colspan="" style="border-top: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b><?php echo number_format((float)$group_sum_gross_box_package_fetch_invoice->gross_wt, 3, '.', '') . ' ' . 'GROSS WT' ; ?> </b></td>
					<td style="border-top: 1px solid transparent;border-left: 1px solid transparent;border-right:1px solid transparent;"></td>
				</tr>