EVOLUTION-NINJA
Edit File: issue_loom_preview.php
<?php //include("menu.php"); error_reporting(E_ALL); ?> <link rel="stylesheet" type="text/css" href="<?php echo base_url(); ?>assets/css/avinash.min.css" > <link rel="stylesheet" type="text/css" href="<?php echo base_url(); ?>assets/css/skin-blue.min.css" > <link rel='shortcut icon' type='image/x-icon' href="<?php echo base_url(); ?>assets/images/samll-big.png"/> <div class="page-content-wrapper"> <div class="page-content"> <div class="row" style=" text-align: right;"> <button class="btn btn-success btn-lg" type="button" id="booking_print" style=" padding-top: 2px; padding-bottom: 3px; padding-left: 15px; padding-right: 15px; background: rgb(72,91,127); color: white; border: initial !important; font-size: 22px;">Print </button> <span class="close-right" ><a href="<?php echo base_url('weaving_panel/issued_loom');?>" style="font-size: 22px;border: 1px solid;padding-left: 15px;padding-right: 15px;background: rgb(72,91,127);color: white;padding-bottom: 7px;text-decoration:none;">Back</a></span> </div> <div class="content-wrapper print" id="print_report" style=""> <table style="width:100%;border-spacing:0;"> <tr> <td colspan="11"></td> <td style="text-align:right;">E-mail : sales@swansilk.com</td> </tr> <tr> <td colspan="11"></td> <td style="text-align:right;">Phone : 080-41888298</td> </tr> <tr> <td colspan="12" style="text-align:center;font-weight:900;font-size:20px;font-style:Akashi;">Deco-Textil</td> </tr> <tr> <td colspan="12" style="text-align:center;">"SWAN HOUSE" No:40, 4th cross, Residency Road, Banglore - 560025. INDIA</td> </tr> <tr> <td colspan="12" style="text-align:center;font-weight:600;text-decoration: underline;">ISSUED LOOMS</td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;"> </td> </tr> <tr> <td colspan="10"><?php if(empty($fetch_address->name)) echo "Deco-Textil" . "<br/>" ."NO 40 4TH CROSS RESIDENCY ROAD". "<br/>". "BANGALORE-560025" . "<br/>". "INDIA "; else echo $fetch_address->name . "<br/>" .$fetch_address->address . "<br/>". $fetch_address->city . "<br/>". $fetch_address->country . "-". $fetch_address->pincode; ?></td> <!-- <td colspan="10"><?php //if(empty($fetch_address->name)) echo "Deco-Textil" . "<br/>" ."NO 40 4TH CROSS RESIDENCY ROAD". "<br/>". "BANGALORE-560025" . "<br/>". "INDIA "; else echo $fetch_address->name . "<br/>" .$fetch_address->address . "<br/>". $fetch_address->city . "<br/>". $fetch_address->country . "-". $fetch_address->pincode; ?></td>--> <td colspan="2" style="text-align:right;"> OSL No. :<?php if(empty($getyarndata)) { } else { echo $getyarndata->osl_no; } ?></td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;">Date : <?php if(empty($getyarndata)) { } else { echo $getyarndata->created_at; } ?></td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;">Delivery Date : <?php echo date("d-m-Y", strtotime($fetch->delivery_date)); ?></td> </tr> <tr> <td colspan="2" style="padding-top: 1%;">Sir / Madam,</td> <!--<td colspan="2" style="padding-top: 1%;">INDENT NO.114 DT. 23.05.17</td>--> <td colspan="8"></td> </tr> <tr> <td colspan="12"> <p style="padding-left:5%;padding-top: 1%;">We requested you to process Issue Loom requirement.</p> </td> </tr> </table> <input type="hidden" id="shadeID" name="shadeID" value="<?php echo $fetch->subNo; ?>" function="myfunction()" > <table border="1" style="width:100%;border-spacing:0;margin-top: 1%;" cellpadding="5px"> <thead> <tr> <th>SL No.</th> <th>OSL #</th> <th>Planned Width</th> <th>Article</th> <th>Design</th> <th>SSL Shade</th> <th>Planned Warp</th> <th>Planned Weft</th> </tr> </thead> <tbody> <?php $i=1; ?> <?php if(empty($getyarndata)) { } else { ?> <tr > <td><?php echo $i; ?></td> <td><?php echo $getyarndata->osl_no; ?></td> <td><?php echo $getyarndata->planned_width; ?></td> <td><?php echo $getyarndata->article; ?></td> <td><?php echo $getyarndata->design ; ?></td> <td><?php echo $getyarndata->ssl_shade_w; ?></td> <td><?php echo $getyarndata->planned_warp; ?></td> <td><?php echo $getyarndata->planned_weft; ?></td> </tr> <?php $i++; } ?> </tbody> </table> <div class="col-sm-12"> <!-----Warp Details ----------------------> <br/>Below is the Warp &Weft Details <table border="1" style="width:100%;border-spacing:0;margin-top: 1%;" cellpadding=""> <thead> <tr> <th>SL No.</th> <th>Warp Quality</th> <th>Warp Specification</th> <th>Warp Denier</th> <th>Warp Code</th> <th>Warp Color</th> <th>Warp Wt</th> </tr> </thead> <tbody id="warp_details" function="myfunction();"> </tbody> </table> <!-------------Weft Details----------------------> <table border="1" style="width:100%;border-spacing:0;margin-top: 1%;" cellpadding=""> <thead> <tr> <th>SL No.</th> <th>Weft Quality</th> <th>Weft Specification</th> <th>Weft Denier</th> <th>PPC</th> <th>Weft Code</th> <th>Weft Color</th> <th>Weft Wt</th> </tr> </thead> <tbody id="weft_details"> </tbody> </table><br/><br/> </div> <div> <!-----Warp Details ----------------------> <br/>Below is the Raw Material Issued Process <table border="1" style="width:100%;border-spacing:0;margin-top: 1%;" cellpadding=""> <thead> <tr> <th>SL No.</th> <th>Yarn Name</th> <th>Yarn Denier</th> <th>Yarn Specification</th> <th>Purpose/OSL</th> <th>SSL Shade</th> <th>Color Code</th> <th>Lot</th> <th>Bale / Issue#</th> <th>Stock Net Weight</th> <th>Issued Net Weight</th> <th>Remnants</th> <th>Balanced Stock Net Weight </th> <th>Issued Date</th> <th>Added Date</th> <th>Added Quantity</th> <th>Re-Process</th> <th>Received By</th> </tr> </thead> <tbody> <?php $i=1; ?> <?php if(isset($getalldata)) { foreach($getalldata as $fetch_data){ ?> <tr > <td><?php echo $i; ?></td> <!--<td><?php echo $fetch_data->yarn_name; ?></td>--> <!--<td><?php echo $fetch_data->yarn_den; ?></td>--> <!--<td><?php echo $fetch_data->yarn_spec; ?></td>--> <!--<td><?php echo $fetch_data->ssl_shade_w; ?></td>--> <!--<td><?php echo $fetch_data->color_code; ?></td>--> <!--<td><?php echo $fetch_data->yarn_lot; ?></td>--> <!--<td><?php echo $fetch_data->yarn_bale; ?></td>--> <!--<td><?php echo bcdiv($fetch_data->stock_net_wt, 1, 2) ; ?></td>--> <!--<td><?php echo $fetch_data->issue_net_wt; ?></td>--> <!-- <td><?php echo bcdiv($fetch_data->rements, 1, 2); ?></td>--> <!--<td><?php echo bcdiv($fetch_data->balanced_stock_wt, 1, 2); ?></td>--> <!--<td><?php echo $fetch_data->issued_date; ?></td>--> <!--<td><?php echo $fetch_data->re_process; ?></td>--> <!--<td><?php echo $fetch_data->approved_by; ?></td>--> <td><?php echo $fetch_data['yarn_name']; ?></td> <td><?php echo $fetch_data['yarn_den']; ?></td> <td><?php echo $fetch_data['yarn_spec']; ?></td> <td><?php echo strtoupper($fetch_data['purpose']); ?></td> <td><?php echo $fetch_data['ssl_shade_w']; ?></td> <td><?php echo $fetch_data['color_code']; ?></td> <td><?php echo $fetch_data['yarn_lot']; ?></td> <td><?php echo $fetch_data['yarn_bale']; ?></td> <td><?php echo bcdiv($fetch_data['stock_net_wt'], 1, 2) ; ?></td> <td><?php echo $fetch_data['issue_net_wt']; ?></td> <td><?php echo bcdiv($fetch_data['rements'], 1, 2); ?></td> <td><?php echo bcdiv($fetch_data['balanced_stock_wt'], 1, 2); ?></td> <td><?php echo $fetch_data['issued_date']; ?></td> <td><?php echo $fetch_data['add_stock_date']; ?></td> <td><?php echo $fetch_data['add_stock_val']; ?></td> <td><?php echo $fetch_data['re_process']; ?></td> <td><?php echo $fetch_data['approved_by']; ?></td> </tr> <?php $i++; } } ?> <tr> <td colspan="15" style="text-align:right;"> Total Issued Net Weight : <?php echo number_format((float)$getalldata_net->issue_net_wt, 2, '.', ''); ?><br/> Total Remnants : <?php echo number_format((float)$getalldata_rem->rements, 2, '.', ''); ?> </td> </tr> <!--<tr> <td colspan="2" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;">Yarn Type </td> <td colspan="3" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"> </td> <td colspan="1" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"></td> <td colspan="2" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;">Total Net Weight</td> <td colspan="1" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"></td> <td colspan="1" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"></td> <?php foreach($getotalval as $totval){ if($totval->name !=""){?> <tr> <td colspan="2" style="border-bottom:1px solid transparent !important;border-right:1px solid transparent !important;"><?php echo $totval->name;?></td> <td colspan="3" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"> </td> <td colspan="1" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"></td> <td colspan="2" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"><?php echo $totval->net;?></td> <td colspan="1" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"></td> <td colspan="1" style="border-bottom:1px solid transparent !important;border-left:1px solid transparent !important;text-align:center;"></td> </tr> <?php } } ?> </tr>--> <!--<tr> <td colspan="5" style="border-top:1px solid transparent !important;"></td> <td colspan="3" style="border-top:1px solid transparent !important;border-right:1px solid transparent !important;">GRAND Total in Rs</td> <td colspan="3" style="border-top:1px solid transparent !important;border-left:1px solid transparent !important;text-align:right;"><?php echo $ttl_amt; ?></td> </tr>--> <tr> <td colspan="5" style="border-top:1px solid transparent !important;"></td> <td colspan="5" style="border-top:1px solid transparent !important;"><b></b></td> </tr> </tbody> </table></div> <!--New table--> <?php if(!empty($check_reprocess->re_process)){?> <br/>Below is the Re-Process / Add to Stock Details: <table border="1" style="width:100%;border-spacing:0;margin-top: 1%;" cellpadding=""> <thead> <tr> <th>SL No.</th> <th>Yarn Name</th> <th>Yarn Denier</th> <th>Yarn Specification</th> <th>SSL Shade</th> <th>Color Code</th> <th>Lot</th> <th>Bale / Issue#</th> <th>Add Stock Net Weight</th> <th>Date</th> <th>Re-Process</th> <th>Added_by </th> </tr> </thead> <tbody> <?php $i=1; ?> <?php if(isset($getalldata_reprocess)) { foreach($getalldata_reprocess as $fetch_data){ ?> <tr > <td><?php echo $i; ?></td> <td><?php echo $fetch_data->yarn_name; ?></td> <td><?php echo $fetch_data->yarn_den; ?></td> <td><?php echo $fetch_data->yarn_spec; ?></td> <td><?php echo $fetch_data->yarn_ssl_shade; ?></td> <td><?php echo $fetch_data->color_code; ?></td> <td><?php echo $fetch_data->yarn_lot; ?></td> <td><?php echo $fetch_data->yarn_bale; ?></td> <td><?php echo bcdiv($fetch_data->add_stock_val, 1, 2) ; ?></td> <td><?php echo $fetch_data->add_stock_date; ?></td> <td><?php if($fetch_data->re_process='redyeing') { echo 'RE-DYEING'; }else if($fetch_data->re_process='add_to_stock'){ echo 'ADD TO STOCK'; } else{echo ''; }?></td> <td><?php echo $fetch_data->add_stock_by; ?></td> </tr> <?php $i++; } } ?> </tbody> </table> <?php } ?> <table style="margin-top:10px;"> <!--<tr> <td><?php echo $fetch_data->comment; ?></td> </tr>--> <tr> <?php if(empty($fetch_address)) { echo ""; } else { ?> <td > Bank Details : <?php echo 'A/c No. '. $fetch_address->ac_no . ',' . $fetch_address->name . ' ' . $fetch_address->bank_address ; ?></td> <?php } ?> </tr> </table> <table style="width:100%;margin-top:20px;"> <tr> <td>FOR Deco-Textil</td> <td style="text-align:right;">FOR Deco-Textil</td> </tr> <tr > <td style="padding-top:7%;">EXECUTIVE - PURCHASE</td> <td style="text-align:right;padding-top:7%;">DIRECTOR</td> </tr> <tr> <td colspan="2" style="text-align:center; padding-top:5%;">IT IS A COMPUTER GENERATED FORMAT. SIGNATURE IS NOT REQUIRED</td> </tr> </table> </div> <!--- content-wrapper ----> <!------------- content-wrapper END -----------------------------------------------------------------------------------------------------> <script> function myfunction() { // alert(); } </script> <script> $( document ).ready(function() { var shadeID=$('#shadeID').val(); // alert(shadeID); var something = $.ajax({ type: "post", url: "<?php echo base_url(); ?>planning/get_planned_warping_details", data: "subNumber=" + shadeID, success: function (data) { //alert(); var objData = jQuery.parseJSON(data); var obj1 = objData.shadeID; var obj2 = objData.shadeName; var obj4 = objData.resultWarp; // alert(obj4); var obj3 = objData.resultWeft; $('#sslShade_no').val(obj1); $('#sslShade').val(obj2); var content = ''; $("#warp_details").empty(); var i=1; $.each(obj4,function(key,val){ // alert(val.Warp_Specification); var ar_new=objData.sm_warp[key]; var ar_new1=objData.planned_warp_wt[key]; content += '<tr>'; content += '<td>'+i+'</td>'; content += '<td>'+val.Warp_Quality+'</td>'; content += '<td>'+val.Warp_Specification+'</td>'; content += '<td><input type="text" id="buyerShade" class="form-control buyerShade"'; content += 'style="height: 30px; width: 100px; border: transparent;" value="'+val.Warp_Denier+'" readonly/></td>'; content += '<td>'+ar_new.warpCode+'</td>'; content += '<td>'+ar_new.warpColor+'</td>'; content += '<td>'+ar_new1.warpWt+'</td>'; content += '</tr>'; i++; }); $("#warp_details").html(content); var contentt=''; $("#weft_details").empty(); var i=1; $.each(obj3,function(key,val){ var ar_new=objData.sm_weft[key]; var ar_new1=objData.planned_weft_wt[key]; contentt += '<tr>'; //alert(val.Weft_Denier); contentt += '<td>'+i+'</td>'; contentt += '<td>'+val.Weft_Quality+'</td>'; contentt += '<td>'+val.Weft_Specification+'</td>'; contentt += '<td>'+val.Weft_Denier+'</td>'; contentt += '<td>'+val.PPC+'</td>'; contentt += '<td>'+ar_new.weftCode+'</td>'; contentt += '<td>'+ar_new.weftColor+'</td>'; contentt += '<td>'+ar_new1.weftWt+'</td>'; contentt += '</tr>'; i++; }); $("#weft_details").html(contentt); } }); }); </script> <?php function convert_number_to_words($no) { //$no = round($number); //alert(); $hundred = null; $digits_1 = strlen($no); $i = 0; $str = array(); $words = array('0' => '', '1' => 'One', '2' => 'Two', '3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six', '7' => 'Seven', '8' => 'Eight', '9' => 'Nine', '10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve', '13' => 'Thirteen', '14' => 'Fourteen', '15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen', '18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty', '30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty', '60' => 'Sixty', '70' => 'Seventy', '80' => 'Eighty', '90' => 'Ninety'); $digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore'); while ($i < $digits_1) { $divider = ($i == 2) ? 10 : 100; $number = floor($no % $divider); $no = floor($no / $divider); $i += ($divider == 10) ? 1 : 2; if ($number) { $plural = (($counter = count($str)) && $number > 9) ? 's' : null; $hundred = ($counter == 1 && $str[0]) ? ' And ' : null; $str [] = ($number < 21) ? $words[$number] . " " . $digits[$counter] . $plural . " " . $hundred : $words[floor($number / 10) * 10] . " " . $words[$number % 10] . " " . $digits[$counter] . $plural . " " . $hundred; } else $str[] = null; } $str = array_reverse($str); $result = implode('', $str); return $result ; } ?> </div> <!----- wrapper -----> </div> <script> $(document).ready(function(){ $("#booking_print").click(function(){ var divToPrint=document.getElementById("print_report"); newWin= window.open(""); newWin.document.write(divToPrint.outerHTML); newWin.print(); newWin.close(); }); }); </script> <!--<script> var divContents = $(".print").html(); newWin= window.open(""); newWin.document.write(divContents); newWin.print(); newWin.close(); </script>--> <style> .content-wrapper{ overflow:auto !important; } .form-control[disabled], .form-control[readonly], fieldset[disabled] .form-control { cursor: not-allowed; background-color: #fdfafa !important; opacity: 1; } </style>