EVOLUTION-NINJA
Edit File: work_order_complete_summary_weaving_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('out_source/weaving_fabric?prop_id=1');?>" 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;">SUMMARY</td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;"> </td> </tr> <tr> <td colspan="10">OSL No. :<?php if(empty($getyarndata)) { } else { echo $getyarndata->osl_no; } ?></td> <!-- <td colspan="10"><?php //if(empty($fetch_address->name)) echo "SWAN SILK PVT LTD" . "<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;"> </td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;"></td> </tr> <tr> <td colspan="10"></td> <td colspan="2" style="text-align:right;"></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> </table> <input type="hidden" id="shadeID" name="shadeID" value="<?php echo $fetch->subNo; ?>" function="myfunction()" > <br/>Below is the Weaving Plan <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 Issue for Warping / Weaving <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>Stock Net Weight</th> <th>Issued Net Weight</th> <th>Remnants</th> <th>Balanced Stock Net Weight </th> <th>Issued Date</th> <th>Remarks</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->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->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->remarks; ?></td> <td><?php echo $fetch_data->approved_by; ?></td> </tr> <?php $i++; } } ?> <!--<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> <td colspan="15" style="border-bottom:1px solid transparent !important;border: transparent !important;text-align: right;"><?php echo 'Total Issue Net Weight : ' . bcdiv($getalldata_net->issue_net_wt, 1, 2);?> </td> <tr/> <tr> <td colspan="15" style="border-bottom:1px solid transparent !important;border: transparent !important;text-align: right;"><?php echo 'Total Remnants : ' . bcdiv($getalldata_rem->rements, 1, 2);?> </td> </tr> </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> <br/>Below is the Raw Fabric Received<br/><br/> <table border="1" style="width:100%;border-spacing:0 !important;"> <tr> <th style="">OSL No. </th> <th style="">Article </th> <th style=""> Shades </th> <th style="">Width </th> <th style="">Planned Width </th> <th style="">Reed </th> <th style="">Reed Width </th> <th style="">PPC </th> <th style=""> Quality </th> <th style="">Design </th> <th style="">Finished Weight </th> <th style="">Weaving Factory </th> <th style="">Piece Length </th> <th style="">Ordered Mtrs </th> <th style="">Warp Plad Mtrs </th> <th style="">Weft Plad Mtrs </th> <th style=""> Weaving Date </th> <th style="">Tentative Date </th> </tr> <tr style="height:50px;"> <td style="text-transform: uppercase !important;"><?php echo $po_details->osl_no; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->article; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->shade; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->width; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->selWidth; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->reed; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->reed_width; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->ppc; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->quality; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->design; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->finished_weight; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->weaving_factory; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->piece_length; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->ordered_mtrs; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->warp_pland_mtr; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->weft_pland_mtr; ?></td> <td style="text-transform: uppercase !important;"><?php echo $registration_date; ?></td> <td style="text-transform: uppercase !important;"><?php echo $po_details->tentative_date; ?></td> </tr> </table> <!--</td> </tr> </tbody> </table>--> <table align="center" style="width:100%;border-spacing:0px !important;margin-top:20px;" border="1"> <thead> <tr > <th style="text-align:center;">Sl.No.</th> <th style="text-align:center;">Purpose/OSL No.</th> <th style="text-align:center;">Received Mtrs</th> <!-- <th style="text-align:center;">Ordered Goods</th>--> <th style="text-align:center;">Received Weight</th> <th style="text-align:center;">Received Date</th> <th style="text-align:center;">Location</th> <th style="text-align:center;">Weaving Factory</th> <th style="text-align:center;">Piece No.</th> <th style="text-align:center;">Invoice/DC No.</th> <th style="text-align:center;">Received By</th> </tr> </thead> <tbody> <?php $i=1;?> <?php if(isset($goods_details)) { foreach($goods_details as $fetch_data) {?> <tr style="height:30px;"> <td><?php echo $i; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->oslno; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->received_mtrs; ?></td> <!-- <td><?php echo $fetch_data->quantity; ?></td>--> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->received_weight; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->rec_date; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->location; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->factory; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->piece_no; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->in_dc_val; ?></td> <td style="text-transform: uppercase !important;"><?php echo $fetch_data->rec_by; ?></td> </tr> <?php $i++;} } ?> <tr> <td colspan="12" style="border-bottom:1px solid transparent !important;border: transparent !important;text-align: right;"> <span style=" margin-right: 12px;"><?php if(empty($rec_mtr)) { } else { echo 'Total Received Mtrs : ' . ' '.$rec_mtr->received_mtrs . ' '; } ?></span> </td> </tr> <tr> <td colspan="12" style="border-bottom:1px solid transparent !important;border: transparent !important;text-align: right;"> <span style=" margin-right: 12px;"><?php if(empty($rec_wei)) { } else { echo 'Total Received Weight : ' . ' '.$rec_wei->received_weight . ' '; } ?></span> </td> </tr> </tbody> </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><input type="text" class="form-control ourShade_new"'; content += 'value="'+i+'" style="height: 30px; width: 100px; border: transparent;" readonly/></td>'; content += '<td><input type="text" class="form-control ourShade_new"'; content += 'value="'+val.Warp_Quality+'" style="height: 30px; width: 100px; border: transparent;" readonly/></td>'; content += '<td><input type="text" id="buyerShade" class="form-control buyerShade"'; content += 'style="height: 30px; width: 100px; border: transparent;" value="'+val.Warp_Specification+'" readonly/></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><input type="text" id="quantity" class="form-control quantity" '; content += 'style="height: 30px; width: 100px; border: transparent;" value="'+ar_new.warpCode+'" readonly/></td>'; content += '<td><input type="text" class="form-control sub_form_controll unitPrice" '; content += 'style="height: 30px; width: 100px; border: transparent;" value="'+ar_new.warpColor+'" readonly/></td>'; content += '<td><input type="text"class="unitPrice" style="height: 30px; width: 100px; border: transparent;" value="'+ar_new1.warpWt+'" readonly/></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><input type="text" class="form-control ourShade_new"'; contentt += 'value="'+i+'" style="height: 30px; width: 100px; border: transparent;" readonly/></td>'; contentt += '<td><input type="text" class="form-control ourShade_new"'; contentt += 'value="'+val.Weft_Quality+'" style="height: 30px; width: 100px; border: transparent;" readonly/></td>'; contentt += '<td><input type="text" id="buyerShade" class="form-control buyerShade"'; contentt += 'style="height: 30px; width: 100px; border: transparent;" value="'+val.Weft_Specification+'" readonly/></td>'; contentt += '<td><input type="text" id="buyerShade" class="form-control buyerShade"'; contentt += 'style="height: 30px; width: 100px; border: transparent;" value="'+val.Weft_Denier+'" readonly/></td>'; contentt += '<td><input type="text" id="quantity" class="form-control quantity" '; contentt += 'style="height: 30px; width: 100px; border: transparent;" value="'+val.PPC+'" readonly/></td>'; contentt += '<td><input type="text" class="form-control sub_form_controll unitPrice" '; contentt += 'style="height: 30px; width: 100px; border: transparent;" value="'+ar_new.weftCode+'"readonly/></td>'; contentt += '<td><input type="text" class="form-control sub_form_controll unitPrice" '; contentt += 'style="height: 30px; width: 100px; border: transparent;" value="'+ar_new.weftColor+'"readonly/></td>'; contentt += '<td><input type="text"class="unitPrice" style="height: 30px; width: 100px; border: transparent;" value="'+ar_new1.weftWt+'" readonly/></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>