EVOLUTION-NINJA
Edit File: madeups_list_weight_note.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> <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.3/jspdf.min.js"></script> <script type="text/javascript" src="<?php echo base_url('jquery-2.2.4.min.js');?>"></script> <script src="<?php echo base_url('bootstrap.min.js');?>"></script> <style> .invoice_table{ font-family:Arial, Helvetica, sans-serif !important; font-size:10px; } table { border-spacing: 0 !important; border-color: #cacaca !important; } td { padding:5px 5px; line-height: 1.6; } .products td { line-height: 0.1; padding: 2px 5px; } </style> </head> <!-- <div> <?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 //} ?>--> <script> function back_function() { window.location.href = "<?php echo base_url('packing_list/madeups_list_data?prop_id=1'); ?>"; } </script> <div class="row"> <input type="button" onclick="back_function()" id="back_button" value="Back" style=" right:100px; padding-top: 2px; padding-bottom: 1px; padding-left: 15px; padding-right: 15px; float: right;margin-right: 5px;"> <?php if($fetchh->confirm == 'Yes') { ?> <input type="button" onclick="tableToExcel('excelexport', 'W3C Example Table')" id="excel_export" style="float: right; margin-right: 5px;" value="Export to Excel" > <button type="button" id="generate_pdf_btn" style="float: right; margin-right: 5px;" class="btn btn-primary" >Export to PDF</button> <input type="button" onclick="goods_details()" id="submit_booking_print1" value="Submit" style="float: right; margin-right: 5px;" disabled> <input type="button" id="booking_print1" value="Print" style="float: right; margin-right: 5px;" > <?php } else { ?> <input type="button" onclick="tableToExcel('excelexport', 'W3C Example Table')" id="excel_export" style="float: right; margin-right: 5px;" value="Export to Excel" disabled> <button type="button" id="generate_pdf_btn" style="float: right; margin-right: 5px;" class="btn btn-primary" disabled>Export to PDF</button> <input type="button" onclick="goods_details()" id="submit_booking_print1" value="Submit" style="float: right; margin-right: 5px;" > <input type="button" id="booking_print1" value="Print" style="float: right; margin-right: 5px;" > <?php } ?> <!--<?php if($indent_p == 'indent_preview') { ?> <span class="close-right" id="back_button"><a href="<?php echo base_url('packing_list/madeups_list_data?prop_id=1');?>" style="font-size: 22px;border: 1px solid;padding-bottom: 5px; margin-top: 10%; text-decoration: none; padding-top: 1px; padding-right: 12px; padding-left: 12px;background: rgb(72,91,127);color: white;margin-top:10%;text-decoration:none;position:absolute;right:0;margin-right: 24px;margin-top: 13px;">Back</a></span> <?php } else if($indent_p == 'today_preview') { ?> <span class="close-right" id="back_button"><a href="<?php echo base_url('packing_list/madeups_list_data?prop_id=2');?>" style="font-size: 22px;border: 1px solid;padding-bottom: 5px; margin-top: 10%; text-decoration: none; padding-top: 1px; padding-right: 12px; padding-left: 12px;background: rgb(72,91,127);color: white;margin-top:10%;text-decoration:none;position:absolute;right:0;margin-right: 24px;margin-top: 13px;">Back</a></span> <?php } else if($indent_p == 'monthly_preview') { ?> <span class="close-right" id="back_button"><a href="<?php echo base_url('packing_list/madeups_list_data?prop_id=3');?>" style="font-size: 22px;border: 1px solid;padding-bottom: 5px; margin-top: 10%; text-decoration: none; padding-top: 1px; padding-right: 12px; padding-left: 12px;background: rgb(72,91,127);color: white;margin-top:10%;text-decoration:none;position:absolute;right:0;margin-right: 24px;margin-top: 13px;">Back</a></span> <?php } else if($indent_p == 'year_preview') { ?> <span class="close-right" id="back_button"><a href="<?php echo base_url('packing_list/madeups_list_data?prop_id=4');?>" style="font-size: 22px;border: 1px solid;padding-bottom: 5px; margin-top: 10%; text-decoration: none; padding-top: 1px; padding-right: 12px; padding-left: 12px;background: rgb(72,91,127);color: white;margin-top:10%;text-decoration:none;position:absolute;right:0;margin-right: 24px;margin-top: 13px;">Back</a></span> <?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: 15px;padding-left: 20%;">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; ?> <br/> <?php echo $fetch->invoice_date; ?></b> </td> <?php if($fetch->wt_note_submitted == 0 ) { ?> <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> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <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> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <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> <?php } else { ?> <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; ?>" readonly="readonly"> </b></td> <?php } ?> </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 District:Bangalore Urban State Code:29</td> <!---<?php if($fetch->wt_note_submitted == 0 ) { ?> <td colspan="" style="border-right:1px solid transparent;">Buyer's order no & Date<br> <b> <input type="text" id="order_num_myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:12px !important;" value="<?php echo $fetch->weight_order_num; ?>"> <input type="hidden" id="invoice_no" style=" width: ;height: 18px;font-size:11px;" value="<?php echo $fetch->invoice_num; ?>"> </b></td> <td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> <input type="text" id="myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:12px !important;" value="<?php echo $fetch->weight_other_ref; ?>"></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <td colspan="" style="border-right:1px solid transparent;">Buyer's order no & Date<br> <b> <input type="text" id="order_num_myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:12px !important;" value="<?php echo $fetch->weight_order_num; ?>"> <input type="hidden" id="invoice_no" style=" width: ;height: 18px;font-size:11px;" value="<?php echo $fetch->invoice_num; ?>"> </b></td> <td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> <input type="text" id="myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:12px !important;" value="<?php echo $fetch->weight_other_ref; ?>"></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <td colspan="" style="border-right:1px solid transparent;">Buyer's order no & Date<br> <b> <input type="text" id="order_num_myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:12px !important;" value="<?php echo $fetch->weight_order_num; ?>"> <input type="hidden" id="invoice_no" style=" width: ;height: 18px;font-size:11px;" value="<?php echo $fetch->invoice_num; ?>"> </b></td> <td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> <input type="text" id="myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:12px !important;" value="<?php echo $fetch->weight_other_ref; ?>"></td> <?php } else { ?> <td colspan="" style="border-right:1px solid transparent;">Buyer's order no & Date<br> <b> <input type="text" id="order_num_myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:10px !important;" value="<?php echo $fetch->weight_order_num; ?>" readonly="readonly"> <input type="hidden" id="invoice_no" style=" width: ;height: 18px;font-size:11px;" value="<?php echo $fetch->invoice_num; ?>"> </b></td> <td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> <input type="text" id="myInput1" style="font-weight:bold;width:95%;height: 18px;font-size:10px !important;" value="<?php echo $fetch->weight_other_ref; ?>" readonly="readonly"></td> <?php } ?>--> <?php $dist = ''; foreach($dist_order_no as $val){ $dist .= $val->orderNo.","; } $dist = rtrim($dist, ", "); $other = ''; foreach($dist_osl_no as $key=>$val){ $temp = $val->osl_no; 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); } } } $dist = rtrim($dist, ", "); //print_r($dist_osl_no); //echo $other; //die(); //print_r($dist_osl_no); // echo $val->orderNo; // 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:11px;" value="<?php echo $fetch->invoice_num; ?>"> <input type="hidden" id="financ_year" style=" width: ;height: 18px;font-size:11px;" value="<?php echo $fetch->financ_year; ?>"> </b></td> <?php if($fetch->weight_other_ref != ''){ ?> <td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> <input type="text" id="myInput1" style="font-weight:bold;width: 99%;height: 18px;font-size:10px !important;" value="<?php echo $fetch->weight_other_ref; ?>"></td> <?php } else{ ?> <td colspan="" style="border-left:1px solid transparent;">Other Reference's <br> <input type="text" id="myInput1" style="font-weight:bold;width: 99%;height: 18px;font-size:10px !important;" value="<?php echo $other; ?>"></td> <?php } ?> </tr> </table> <table class="table" border="1" style="width:100%;border-top:1px solid transparent;"> <tr> <td style="width:15%;border-right: 1px solid transparent;">Marks & Nos Container No</td> <td style="width:10%;border-right: 1px solid transparent;border-left: 1px solid transparent;"></td> <td colspan="" style="width:10%;border-right: 1px solid transparent;border-left: 1px solid transparent;">No & kind of Packages</td> <td colspan="2" style="width:20%;border-left: 1px solid transparent;">Description of goods</td> <td style="width:5%;">Quantity</td> <td colspan="4" style="width:30%;">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 . '/1-' . $count_package_fetch_invoice; ?></b></td> <?php if($fetch->wt_note_submitted == 0 ) { ?> <td colspan="4" 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> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <td colspan="4" 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> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <td colspan="4" 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> <?php } else { ?> <td colspan="4" 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;" readonly="readonly"><?php echo $fetch->weight_first_details; ?></textarea></td> <?php } ?> <td colspan="" style="border-bottom: 1px solid transparent;"></td> <td colspan="4" 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;display:none;"><b>PC.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>SKU</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>PO 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>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>PCS</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-right: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>SIZE</b></td> <td colspan="" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>BOX DIMENTION</b></td> </tr> <!--<tr> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;"></td> <?php if($fetch->wt_note_submitted == 0 ) { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } else { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;" readonly="readonly"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } ?> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"></td> <td colspan="4" style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"></td> </tr>--> <?php $i=1; foreach($group_package_fetch_invoice as $key=>$pkgg) { ?> <?php if($pkgg->invoice_description == '') { ?> <?php } else { ?> <tr> <td colspan='5' style="padding-top: 10px;padding-bottom: 5px;border-top: 1px solid transparent;border-bottom: 1px solid transparent;font-size: 14px;"><b><?php echo $pkgg->invoice_description; ?></b></td> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;font-size: 14px;"></td> <td colspan="4" style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;font-size: 14px;"></td> </tr> <?php } ?> <tr class="products"> <td style="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="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;display:none;"><?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="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b><?php echo $pkgg->skuno; ?></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 $pkgg->osl_no; ?></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 $pkgg->orderNo; ?></b></td> <td style="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="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); ?> </b><?php } ?></p><?php } ?><!--<p><span style="border-bottom:2px solid black;border-top:2px solid black;"><?php ///echo number_format($package_fetch_invoice7[$key]->exp_qty); ?></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, 2, '.', ''); ?></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 echo number_format($pkgg->gross_wt,3); ?></b></td> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><?php foreach($package_fetch_invoice6 as $pkg6) { if($pkg6->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg6->size; ?> </b><?php } ?></p><?php } ?></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 $pkgg->box_dimension; ?></b></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;"><b></b></td> <td style="border-top: 1px solid transparent;"><b><?php echo number_format((float)$package_fetch_invoice9->exp_qty) . ' ' . $fetch->units; ?></b></td> <td colspan="2" 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_package_ttl_gross->gross_wt, 3, '.', '') . ' ' . 'GROSS WT' ; ?> </b></td> <td style="border-top: 1px solid transparent;border-left: 1px solid transparent;"></td> </tr> <tr> <td colspan="5" style="border-top: 1px solid transparent !important;"></td> <td colspan="5"><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 = "Madeups-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(); $('#generate_pdf_btn').toggle(); $('#excelexport').toggle(); $('#excel_export').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"; $('#excelexport').hide(); // $("textarea").css({"resize": "none"}); var divToPrint=document.getElementById("print_report"); //$('#excelexport').HIDE(); window.print(); }); }); function goods_details() { var invoice_no=$('#invoice_no').val(); var financ_year=$('#financ_year').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_data1');?>", type:"POST", data:{'invoice_no':invoice_no,'financ_year':financ_year,'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><!--[if gte mso9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--><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/></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="2" 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; ?> <br/> <?php echo $fetch->invoice_date; ?></b> </td> <?php if($fetch->wt_note_submitted == 0 ) { ?> <td colspan="4" style="width:25%;vertical-align:top;">Exporter's Ref. <br> <b><?php echo $fetch->weight_exp_ref; ?> </b></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <td colspan="4" style="width:25%;vertical-align:top;">Exporter's Ref. <br> <b><?php echo $fetch->weight_exp_ref; ?> </b></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <td colspan="4" style="width:25%;vertical-align:top;">Exporter's Ref. <br> <b><?php echo $fetch->weight_exp_ref; ?> </b></td> <?php } else { ?> <td colspan="4" style="width:25%;vertical-align:top;">Exporter's Ref. <br> <b><?php echo $fetch->weight_exp_ref; ?> </b></td> <?php } ?> </tr> <tr> <td colspan="4" 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> <?php if($fetch->wt_note_submitted == 0 ) { ?> <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="5" style="border-left:1px solid transparent;">Other Reference's <br> <b><?php echo $fetch->weight_other_ref; ?></b></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <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><b> <?php echo $fetch->weight_other_ref; ?></b></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <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><b> <?php echo $fetch->weight_other_ref; ?></b></td> <?php } else { ?> <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> <b><?php echo $fetch->weight_other_ref; ?></b></td> <?php } ?> </tr> </table> <table class="table" border="1" style="width:100%;border-top:1px solid transparent;"> <tr> <td style="width:15%;border-right: 1px solid transparent;">Marks & Nos Container No</td> <td style="width:10%;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="2" style="width:30%;border-left: 1px solid transparent;">Description of goods</td> <td style="width:10%;">Quantity</td> <td colspan="5" style="width:20%;">Amount</td> </tr> <tr> <td style="border-right: 1px solid transparent;border-bottom: 1px solid transparent;"><b><?php echo $fetch->invoice . '/1-' . $count_package_fetch_invoice; ?></b></td> <?php if($fetch->wt_note_submitted == 0 ) { ?> <td colspan="4" style="border-left: 1px solid transparent;border-bottom: 1px solid transparent;"><?php echo $fetch->weight_first_details; ?></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <td colspan="4" style="border-left: 1px solid transparent;border-bottom: 1px solid transparent;"><?php echo $fetch->weight_first_details; ?></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <td colspan="4" style="border-left: 1px solid transparent;border-bottom: 1px solid transparent;"><?php echo $fetch->weight_first_details; ?></td> <?php } else { ?> <td colspan="4" style="border-left: 1px solid transparent;border-bottom: 1px solid transparent;"><?php echo $fetch->weight_first_details; ?></td> <?php } ?> <td colspan="" style="border-bottom: 1px solid transparent;"></td> <td colspan="4" 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;display:none;"><b>PC.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>SKU</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>PO 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>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>PCS</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-right: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>SIZE</b></td> <td colspan="" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b>BOX DIMENTION</b></td> </tr> <!--<tr> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-right: 1px solid transparent;"></td> <?php if($fetch->wt_note_submitted == 0 ) { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Super Admin' || $emp_details->designation == 'Admin') { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } else if($fetch->wt_note_submitted == 1 && $emp_details->designation == 'Admin') { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } else { ?> <td colspan="4" style="border-left: 1px solid transparent;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><textarea type="text" id="myInput3" name="des" rows="2" style="width:94%;font-size:11px;font-weight:bold;" readonly="readonly"><?php echo $fetch->weight_box_details; ?></textarea></td> <?php } ?> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"></td> <td colspan="4" style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"></td> </tr>--> <?php $i=1; foreach($group_package_fetch_invoice as $key=>$pkgg) { ?> <?php if($pkgg->invoice_description == '') { ?> <?php } else { ?> <tr> <td colspan='5' style=" padding-top: 10px; padding-bottom: 5px;border-top: 1px solid transparent;border-bottom: 1px solid transparent;"><b><?php echo $pkgg->invoice_description; ?></b></td> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"></td> <td colspan="4" style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;"></td> </tr> <?php } ?> <tr class="products"> <td style="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="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;display:none;"><?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="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b><?php echo $pkgg->skuno; ?></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 $pkgg->osl_no; ?></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 $pkgg->orderNo; ?></b></td> <td style="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="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); ?> </b><?php } ?></p><?php } ?><!--<p><span style="border-bottom:2px solid black;border-top:2px solid black;"><?php ///echo number_format($package_fetch_invoice7[$key]->exp_qty); ?></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, 2, '.', ''); ?></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 echo number_format($pkgg->gross_wt,3); ?></b></td> <td style="border-top: 1px solid transparent;border-bottom: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><?php foreach($package_fetch_invoice6 as $pkg6) { if($pkg6->box_id == $pkgg->box_id) { ?><p><b><?php echo $pkg6->size; ?> </b><?php } ?></p><?php } ?></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 $pkgg->box_dimension; ?></b></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;"><b></b></td> <td style="border-top: 1px solid transparent;"><b><?php echo number_format((float)$package_fetch_invoice9->exp_qty) . ' ' . $fetch->units; ?></b></td> <td colspan="2" 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="3" style="border-top: 1px solid transparent;border-left: 1px solid transparent;border-right: 1px solid transparent;"><b><?php echo number_format((float)$group_package_ttl_gross->gross_wt, 3, '.', '') . ' ' . 'GROSS WT' ; ?> </b></td> </tr> <tr> <td colspan="5" style="border-top: 1px solid transparent !important;"></td> <td colspan="6"><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="6"></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="6"></td> </tr> <?php } ?> </table> </div>