EVOLUTION-NINJA
Edit File: packing_location_wise_old_stock.php
<script> $(function () { $(".invoice_date").datepicker({ dateFormat: "dd-mm-yy", changeMonth: true, changeYear: true }); }); </script> <style> .form-control { height: 22px !important; } </style> <script> $( document ).ready(function() { var financial_year=$('#financial_year').val(); // //alert(fiscalYr); var invoice_res=$('#invoice_number_g').val(); // //alert(invoice_res); var invoice_result = 'DTL' + '/' + invoice_res + '/' + financial_year; // //alert(invoice_result); $('#invoice').val(invoice_result); }); function pkgtypes(str) { // alert(str); if(str=="osl") { // alert(str); $('#po_types').hide(); $('#custom_types').hide(); $('#osl_types').show(); $('#check_box_val').val('osl'); $('#po_no').val(''); $('#osl_no').val(''); $('#oldstock').hide(); window.location.href = "<?php echo base_url('packing_list/paking_list_data'); ?>"; } else if(str=="po") { // alert(str); $('#po_types').show(); $('#osl_types').hide(); $('#custom_types').hide(); $('#check_box_val').val('po'); $('#po_no').val(''); $('#osl_no').val(''); $('#oldstock').hide(); window.location.href = "<?php echo base_url('packing_list/paking_list_data'); ?>"; } else if(str=="OLDSTOCK") { window.location.href = "<?php echo base_url('packing_list/osl_packing_list'); ?>"; } else if(str=="customer_osl") { window.location.href = "<?php echo base_url('packing_list/customer_packing_list'); ?>"; } else if(str=="ALLSTOCK") { window.location.href = "<?php echo base_url('packing_list/all_stock_packing_list'); ?>"; } } function customer_wise_osl() { var cname=$('#customer_name').val(); $.ajax({ type: "post", url:"<?php echo base_url('packing_list/cname_wise_data');?>", type:"POST", data:{'cname':cname}, async:false, success: function (data) { $('#osl_no').empty(); var obj = jQuery.parseJSON(data); var content = ''; content += '<option value="Select">'+ ' Select' +'</option>'; $.each(obj,function(key,val) { //alert(val.yarnSpecification); content += '<option value="'+val.po_no+'">'+val.po_no+'</option>'; }); $('#osl_no').html(content); } }); } function osl_wise_customer() { var cname=$('#osl_no').val(); $.ajax({ type: "post", url:"<?php echo base_url('packing_list/osl_wise_data');?>", type:"POST", data:{'cname':cname}, async:false, success: function (data) { var obj = jQuery.parseJSON(data); var customer=obj.c; var osl_detail=obj.osl_details; var date_f=osl_detail.orderDate; var date_f=osl_detail.orderDate; var date_d=osl_detail.deliveryDate; var d_f=$.datepicker.formatDate('dd-mm-yy', new Date(date_f)); var d_d=$.datepicker.formatDate('dd-mm-yy', new Date(date_d)); $("#order_date").val(d_f); $('#customer_name').val(customer.customerName); // $('#order_date').val(d_f); $('#customer_order_no').val(osl_detail.orderNo); $('#delivery_date').val(d_d); $('#units').val(osl_detail.unit); } }); } function po_wise_customer() { var cname=$('#po_no').val(); //alert(cname); $.ajax({ type: "post", url:"<?php echo base_url('packing_list/po_wise_data');?>", type:"POST", data:{'cname':cname}, async:false, success: function (data) { var obj = jQuery.parseJSON(data); var customer=obj.c; var osl_detail=obj.osl_details; var date_f=osl_detail.orderDate; var date_f=osl_detail.orderDate; var date_d=osl_detail.deliveryDate; var d_f=$.datepicker.formatDate('dd-mm-yy', new Date(date_f)); var d_d=$.datepicker.formatDate('dd-mm-yy', new Date(date_d)); $("#order_date").val(d_f); $('#customer_name').val(customer.customerName); // $('#order_date').val(d_f); $('#customer_order_no').val(osl_detail.orderNo); $('#delivery_date').val(d_d); $('#units1').val(osl_detail.unit); } }); } </script> <?php if (date('m') <= 3) {//Upto June 2014-2015 $financial_year = (date('y')-1) . '-' . date('y'); } else {//After June 2015-2016 $financial_year = date('y') . '-' . (date('y') + 1); } ?> <div class="page-content-wrapper"> <div class="page-content"> <?php $this->load->view('templates/nav_menu'); ?> <label class="radio-inline" style="margin-left: 390px;font-size: 15px;"> <input type="radio" id="c_osl" class="md-radiobtn" name="osltypes" value="OSL" onclick="pkgtypes('osl')" style="top: 0px; border: 2px solid #666; height: 16px; width: 20px; margin-top: 72px;">   DTL</label> <label class="radio-inline" style="margin-left: 28px;font-size: 15px;"> <input type="radio" id="c_po" class="md-radiobtn" name="osltypes" value="PO" onclick="pkgtypes('po')" style="top: 0px; border: 2px solid #666; height: 16px; width: 20px; margin-top: 72px;">   PO</label> <label class="radio-inline" style="margin-left: 28px;font-size: 15px;"> <input type="radio" class="md-radiobtn" id="customer_osl" name="osltypes" value="customer_osl" onclick="pkgtypes('customer_osl')" style="top: 0px; border: 2px solid #666; height: 16px; width: 20px; margin-top: 72px;">   CUSTOMER NAME</label> <!--<label class="radio-inline" style="margin-left: 28px;font-size: 15px;"> <input type="radio" class="md-radiobtn" id="o_po" name="osltypes" value="OLDSTOCK" checked="checked" onclick="pkgtypes('OLDSTOCK')" style="top: 0px; border: 2px solid #666; height: 16px; width: 20px; margin-top: 72px;">   OLD STOCK</label>--> <label class="radio-inline" style="margin-left: 28px;font-size: 17px;"> <input type="radio" class="md-radiobtn" id="o_po" name="osltypes" value="ALLSTOCK" onclick="pkgtypes('ALLSTOCK')" style="top: 0px; border: 2px solid #666; height: 16px; width: 20px; margin-top: 72px;">   ALL STOCK</label> <form action="" method="post" class="transfer_modal_application"> <div id="twisting"> <div class="portlet-body form"> <div class="content-wrapper"> <section class="body-middle"> <div class="twisting"> <table style="width:100%"> <tr style="background:#337AB7; color:#fff;"> <td colspan="14"><strong>Packing List</strong></td> </tr> <tr> <td colspan="7">Invoice No. : <input type="hidden" id="financial_year" value="<?php echo $financial_year; ?>"><input type="text" class="text-input1 work_order" id="invoice" name="invoice" readonly="readonly"> <input type="hidden" class="text-input1 work_order" id="invoice_number_g" name="invoice_number_g" value="<?php echo $invoice; ?>" readonly="readonly"> </td> <td colspan="7">Date : <input type="text" class="text-input1 sys_date openDatePicker" id="sys_date" value="<?php echo $f1; ?>" name="sys_date" data-provide="datepicker" value="<?php echo Date('d-m-Y'); ?>"></td> </tr> <tr> <td colspan="7">Customer Name     :     <select type="text" class="text-input1" name="customer_name" id="customer_name"> <?php if(isset($customer_name)) { foreach($customer_name as $customer_name) { ?> <option value="<?php echo $customer_name->customerID; ?>" <?php if($customer_name->customerID == $f2 ) {echo "selected";}?> style="text-transform: uppercase !important"><?php echo $customer_name->customerName; ?></option> <?php } } ?> </select></td> <td colspan="7">Unit       :       <!--<input type="text" class="text-input1" name="unit_po" id="units1" style="width: 74%;" value="<?php// echo "Mtrs"; ?>"> --> <select type="text" class="text-input1" name="unit_po" id="units1" style="width: 74%;" > <option value="<?php echo 'MTRS'; ?>" <?php if('MTRS' == $f3 ) {echo "selected";}?> ><?php echo 'MTRS'; ?></option> <option value="<?php echo 'YARDS'; ?>" <?php if('YARDS' == $f3 ) {echo "selected";}?> ><?php echo 'YARDS'; ?></option> </select> <input type="hidden" class="text-input1 order_date openDatePicker" data-provide="datepicker" style="width: 70%;" id="order_date" name="order_date" value=""></td> <tr> <td colspan="7">Location : <select type="text" class="text-input1 work_order" id="old_location" name="old_location" style="width:249px"> <?php if(isset($location)) { foreach($location as $location) { ?> <option value="<?php echo $location->id; ?>" <?php if($location->id == $f0 ) {echo "selected";}?> style="text-transform: uppercase !important"><?php echo $location->consumed_at; ?></option> <?php } } ?> </select> <td colspan="7">Invoice Date                           :       <input type="text" class="text-input1 openDatePicker invoice_date" data-provide="datepicker" style="width:40%" id="invoice_date" name="invoice_date" value="<?php echo $f6; ?>"> </td> </tr> <tr id=""> <td colspan="7">Discount       :       <input type="text" class="text-input1" name="discount" id="discount" style="width: 74%;" value="<?php echo $f4; ?>"> </td> <td colspan="7">Other Charges                       :       <input type="text" class="text-input1" style="width:40%" id="other_charges" name="other_charges" value="<?php echo $f5; ?>"> </td> </tr> </tr> <tr style="display:none;"> <td colspan="7">Customer Order No.     :     <input type="text" class="text-input1" name="customer_order_no" id="customer_order_no" style="width: 74%;" ></td> <td colspan="7">Delivery Date     :     <input type="text" class="text-input1 delivery_date openDatePicker" data-provide="datepicker" style="width: 70%;" id="delivery_date" name="delivery_date" ></td> </tr> </table> </div> <div class="packing"> <table style="width:100%"> <tr style="background:#337AB7; color:#fff;"> <td colspan="18"><strong>Packing List</strong> <button type="button" style="margin-left: 25%;color:#fff;" id="waeving_modal" onclick="m_function()" name="weaving_modal"> <i class="fa fa-plus" style="color:#337AB7;"></i></button></td> </tr> <tr class="material-tr"> <td>SI #</td> <td>DTL NO</td> <td>CUSTOMER ORDER NO</td> <td>SHADE</td> <td>BUYER SHADE</td> <td>DTL PIECE#</td> <td>WIDTH</td> <td>ARTICLE</td> <td>STOCK QTY</td> <td>STOCK WT</td> <td>EXP QTY</td> <td>EXP WT</td> <td>ALLO QTY</td> <td>BAL QTY</td> <td>BAL WT</td> <td>UNITS</td> <td>ORDER TYPE</td> <td>SKU NO</td> <td>BOX#</td> </tr> <tbody class="yarnTbody" id="yarnTbody" name="yarnTbody"> <tr> <td style="width:4%;text-align:right;">1</td> <td style="width:5%;"><input type="text" class="text-input m_yarn_name" name="m_yarn_name" id="m_yarn_name"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:4%;text-align:right;"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_name" name="m_yarn_name" id="m_yarn_name"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> </tr> </tbody> </table> </div> <br/> <div class="invoice"> <table style="width:100%"> <tr style="background:#337AB7; color:#fff;"> <td colspan="16"><strong>Invoice List</strong> </td> </tr> <tr class="material-tr"> <td>SI #</td> <td>DTL NO</td> <td>ARTICLE</td> <td>WIDTH</td> <td>DESIGN</td> <td>SHADE</td> <td>BUYER SHADE</td> <td>QTY</td> <td>WT</td> <td>UNIT PRICE</td> <td>ORDER TYPE</td> <td>VALUE</td> <td>CURRENCY</td> <td>TERMS</td> </tr> <tbody class="invoicebody" id="invoicebody" name="yarnTbody"> <tr> <td style="width:4%;text-align:right;">1</td> <td style="width:5%;"><input type="text" class="text-input m_yarn_name" name="m_yarn_name" id="m_yarn_name"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:4%;text-align:right;"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_name" name="m_yarn_name" id="m_yarn_name"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> </tr> </tbody> </table> </div> <br/> <div class="invoice"> <table style="width:100%"> <tr style="background:#337AB7; color:#fff;"> <td colspan="16"><strong>Box Master</strong> </td> </tr> <tr class="material-tr"> <td>SI #</td> <td>BOX #</td> <td>TOTAL PCS</td> <td>TOTAL NET WT</td> <td>GROSS WT</td> <td>BOX TARE WT</td> <td>BOX SIZE</td> </tr> <tbody class="pkgbody" id="pkgbody" name="pkgbody"> <tr id="pkg_tr"> <td style="width:4%;text-align:right;">1</td> <td style="width:5%;"><input type="text" class="text-input pkg_box_id" name="m_yarn_name" id="m_yarn_name"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:8%;"><input type="text" class="text-input m_yarn_denier" name="m_yarn_denier" id="m_yarn_denier"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> <td style="width:5%;"><input type="text" class="text-input m_yarn_specification" name="m_yarn_specification" id="m_yarn_specification"></td> </tr> </tbody> </table> </div> </section> </div> <!--- content-wrapper ----> </div> <!--- portlet-body form ---> <input type="hidden" class="ids" value="<?php echo $ids_data2; ?>" > <div class="modal-footer"> <!--<button name="submit_data" id="submit_data" class="btn center-block submit" style="background:rgb(35,134,202);color:white">Submit</button>--> <button type="submit" name="submit_data" id="submit_data" class="btn center-block submit ss" style="background:rgb(35,134,202);color:white;float: left; ">Submit</button> <a href="<?php echo base_url(); ?>packing_list/paking_list_details?prop_id=1" class="btn default" style="background:rgb(35,134,202);color:white;float: left;">Cancel</a> </div> </div> </form> </div> </div> <!---------------------------osl modal------------------------------------------------> <div id="myModal" class="modal fade" role="dialog" style="color:#000;"> <div class="modal-dialog" > <!-- Modal content--> <div class="modal-content" style=" width: 1281px; height: auto; max-height: 800px; overflow-y: scroll; overflow-x: scroll; "> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title"><input type="text" id="osl_number" style="border:none !important;"></h4> </div> <div class="modal-body"> <fieldset> <div class="row" style="padding-bottom:20px;"> <div class="col-sm-5 col-xs-4"></div> <div class="col-sm-2 col-xs-4"> </div> <div class="col-sm-5 col-xs-4"> <button type="button" id="yarn_generate" class="btn btn-primary generate" value="Generate" style="float:right;margin-left: 10px;" data-dismiss="modal" >Submit</button> </div> </div> <!-- radio button ---> <!-- <input type="text" id="myInput" onkeyup="myFunction_filetr()" placeholder="Search for names.." title="Type in a name"> <input type="text" id="search" placeholder=" live search"></input>--> <!-- Form Name --> <div class="portlet-body" id="portlet-body"> <div class="col-xs-6"> <label class="col-sm-2 col-xs-2" style="padding-right:0 !important;"><b>Search :</b> </label> <input type="text" id="search_warp" class="col-xs-5" placeholder="Type to search"> </div> <br/><br/> <table class="table table-striped table-bordered table-hover" > <thead> <tr> <th> Select yarn </th> <th> Vendor Name </th> <th> PO# / DTL No. </th> <th> DTL Piece No. </th> <th> Supplier Piece No. </th> <th> Article(Product) </th> <th> Width </th> <th> Design </th> <th> Shade </th> <th> Received Weight </th> <th> Actual Quantity </th> <th> Rejected Mtrs </th> <th> Variance Mtrs </th> <th> Location </th> <!-- <th> Stage </th> --> </tr> </thead> <tbody id="osl_details" class="osl_details"> </tbody> </table> </div> </fieldset> </div> </div> </div> </div> <!------------------------------------------------------------------------------------------------------------------------------------------> <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> function m_function() { var as1=$('#old_location').val(); // var as2=$('#invoice').val(); // var as3=$('#invoice_number_g').val(); var as4=$('#sys_date').val(); var as5=$('#customer_name').val(); var as6=$('#units1').val(); var as7=$('#invoice_date').val(); var as8=$('#discount').val(); var as9=$('#other_charges').val(); // window.location.href = '<?php echo base_url('packing_list/old_stock_data');?>/'+ '?id='+as; window.location.href = '<?php echo base_url('packing_list/old_stock_data');?>/'+ '?id='+as1+'/'+as4+'/'+as5+'/'+as6+'/'+as8+'/'+as9+'/'+as7; } </script> <script> $( document ).ready(function() { var checkbox_value= $(".ids").val(); //var check_val=$('#check_box_val').val(); //alert(check_val); $.ajax({ url:"<?php echo base_url('packing_list/fetch_m_function_fabric_packing_checkbox_data');?>", type:"POST", data:{'ids':checkbox_value}, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var content = ''; $("#yarnTbody").empty(); var i=1; //var key=0; $.each(objData.result,function(key,value) { var u=$('#units1').val(); if(u == 'YARDS') { if(value.unit == 'MTRS' || value.unit == 'MTRs' || value.unit == '') { var stock_q=value.balanced_mtrs; var stock_w=value.rec_weight; var yard_qty_conv1=value.balanced_mtrs / 0.914; var yard_wt_conv2=value.rec_weight / 0.914; var yard_qty_conv=parseFloat(yard_qty_conv1).toFixed(2); var yard_wt_conv=parseFloat(yard_wt_conv2).toFixed(2); } else { var yard_qty_conv=value.balanced_mtrs; var yard_wt_conv=value.rec_weight; } } else if(u == 'MTRS') { if(value.unit == 'YARDS' || value.unit == 'YARDs' ) { var stock_q=value.balanced_mtrs; var stock_w=value.rec_weight; var yard_qty_conv1=value.balanced_mtrs * 0.914; var yard_wt_conv2=value.rec_weight * 0.914; var yard_qty_conv=parseFloat(yard_qty_conv1).toFixed(2); var yard_wt_conv=parseFloat(yard_wt_conv2).toFixed(2); } else { var yard_qty_conv=value.balanced_mtrs; var yard_wt_conv=value.rec_weight; } } else if(u == '') { var stock_q=value.balanced_mtrs; var stock_w=value.rec_weight; var yard_qty_conv1=value.balanced_mtrs; var yard_wt_conv2=value.rec_weight; var yard_qty_conv=parseFloat(yard_qty_conv1).toFixed(2); var yard_wt_conv=parseFloat(yard_wt_conv2).toFixed(2); } content += '<tr>'; content += '<td><input type="text" class="fabric_id" value="'+i+'" style="width: 20px;border:transparent;">'; content += '<input type="hidden" value="'+value.id+'" class="p_id_d'+i+' p_id" name="p_id[]" style="width: 80px;border:transparent;"></td>'; content += '<td><input type="text" name="p_po_no[]" style="width: 120px !important;border:transparent;" id="purpose" value="'+value.po_no+'" class="perticular p_po_no" readonly="readonly"></td>'; content += '<td><input type="text" name="p_buy_ref[]" style="width: 50px;border:transparent;" id="article" class="skuno p_buy_ref" ></td>'; content += '<td><input type="text" name="p_shades[]" style="width: 120px;border:transparent;" id="shade" class="shade p_shades" value="'+value.shades+'" readonly="readonly"></td>'; content += '<td><input type="text" name="p_buyer_shades[]" style="width: 120px;border:transparent;" id="shade" class="shade " ></td>'; content += '<td><input type="text" name="p_ssl_pc_no[]" style="width: 80px;border:transparent;" id="weft_quality" class="rec_weight p_ssl_pc_no" value="'+value.ssl_pc_no+'" readonly="readonly"></td>'; content += '<td><input type="text" name="p_width[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_mtrs p_width" value="'+value.width+'" readonly="readonly"></td>'; content += '<td><input type="text" name="p_article[]" style="width: 80px;border:transparent;" id="shade" class="shade p_article" value="'+value.product_name+'" readonly="readonly"></td>'; content += '<td><input type="text" name="p_stock_qty[]" style="width: 70px;border:transparent;" class="stock_qty'+i+' s_qty p_stock_qty" id="weft_spec" value="'+yard_qty_conv+'" readonly="readonly"></td>'; content += '<td><input type="text" name="p_stock_wt[]" style="width: 70px;border:transparent;" id="weft_quality" class="stock_wt'+i+' s_wt p_stock_wt" value="'+value.rec_weight+'" readonly="readonly"></td>'; content += '<td><input type="text" name="p_exp_qty[]" style="width: 80px;border:transparent;" class="exp_qty'+i+' e_qty p_exp_qty" onfocusout="exported_wt(this.value,'+i+')" onkeyup="exp_qty_val(this.value,'+i+')" id="weft_denier" value="'+yard_qty_conv+'" ><input type="hidden" name="hidden_exp_qty[]" style="width: 80px;border:transparent;" class="hidden_exp_qty'+i+'" value="'+yard_qty_conv+'" ></td>'; content += '<td><input type="text" name="p_exp_wt[]" style="width: 80px;border:transparent;" class="exp_wt'+i+' e_wt p_exp_wt" onkeyup="exp_wt_val(this.value,'+i+')" id="exported_wt " value="'+value.rec_weight+'" readonly="readonly"><input type="hidden" name="hidden_exp_wt[]" style="width: 80px;border:transparent;" class="hidden_exp_wt'+i+'" value="'+value.rec_weight+'"></td>'; content += '<td><input type="text" name="p_allo_wt[]" style="width: 80px;border:transparent;" id="shade" onkeyup="allo_exp_qty_val(this.value,'+i+')" class="allo_weight'+i+' p_allo_wt" value="'+0+'" ></td>'; content += '<td><input type="text" name="p_bal_qty[]" style="width: 80px;border:transparent;" value="'+0+'" class="bal_qty'+i+' b_qty p_bal_qty" id="weft_quality" readonly="readonly"></td>'; if(value.unit == '') { content += '<td><input type="text" name="p_bal_wt[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_wt'+i+' b_wt p_bal_wt" value="'+0+'" readonly="readonly"></td>'; content += '<td><input type="text" id="" name="p_units[]" class="" value="MTRs" style="width: 65px;border:transparent;" ></td>'; } else { content += '<td><input type="text" name="p_bal_wt[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_wt'+i+' b_wt p_bal_wt" value="'+0+'" readonly="readonly"></td>'; content += '<td><input type="text" id="" name="p_units[]" class="" value="'+value.unit+'" style="width: 65px;border:transparent;" ></td>'; } content += '<td><input type="text" name="p_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="'+i+' box_dim p_ordertype" ></td>'; content += '<td><input type="text" name="p_skuno[]" style="width: 80px;border:transparent;" id="weft_denier" class="'+i+' box_dim p_ordertype" ></td>'; content += '<td><input type="text" id="box" name="p_box_id[]" class="box'+i+' box_id p_box_id" onkeyup="box_unique_no(this.value,'+i+')" style="width: 65px;border:transparent;" ></td>'; content += '</tr>'; i++; }); $("#yarnTbody").html(content); var contentt = ''; $("#invoicebody").empty(); var j=1; //var key=0; $.each(objData.res,function(key,value) { var ar_new1=objData.t_q[key]; var ar_new2=objData.t_r[key]; var bal_m=parseFloat(ar_new1.balanced_mtrs).toFixed(2); var rec_W=parseFloat(ar_new2.rec_weight).toFixed(2); contentt += '<tr>'; contentt += '<td><input type="text" class="fabric_id" value="'+j+'" style="width: 80px;border:transparent;">'; contentt += '<input type="text" value="'+value.id+'" style="width: 80px;border:transparent;"></td>'; contentt += '<td><input type="text" name="in_po_no[]" style="width: 130px !important;border:transparent;" id="purpose" value="'+value.po_no+'" class="in_po_no" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_article[]" style="width: 100px;border:transparent;" id="shade" class="shade in_article" value="'+value.product_name+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_width[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_mtrs in_width" value="'+value.width+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_design_val[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_mtrs in_designing" ></td>'; contentt += '<td><input type="text" name="in_shades[]" style="width: 150px;border:transparent;" id="shade" class="shade in_design" value="'+value.shades+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" class="p_b_shades" ></td>'; contentt += '<td><input type="text" name="in_stk_wt[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_stk_wt in_bal_m'+j+'" value="'+bal_m+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_qty[]" style="width: 80px;border:transparent;" id="weft_quality" class="rec_weight in_stk_qty" value="'+rec_W+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice in_uni'+j+'" onkeyup="unit_price_value(this.value,'+j+')" value="'+0.00+'"></td>'; contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" ></td>'; contentt += '<td><input type="text" name="in_netval[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_netval in_val'+j+'" value="'+0.00+'"></td>'; contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" ></td>'; contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" ></td>'; contentt += '</tr>'; j++; }); $("#invoicebody").html(contentt); } }); }); function unit_price_value(str,j) { var in_bal_m =$('.in_bal_m'+j).val(); var in_uni =$('.in_uni'+j).val(); var in_value= parseFloat(in_bal_m) * parseFloat(in_uni); $('.in_val'+j).val(in_value); } t_val=[]; o_val=[]; n_val=[]; c_val=[]; ct_val=[]; buy_val=[]; b_val=[]; in_d=[]; in_ds=[]; boxes=[]; e_wt=[]; function exp_qty_val(str,i) { $('.exp_qty'+i).on('change keyup', function() { var sanitized = $(this).val().replace(/[^0-9.]/g, ''); $(this).val(sanitized); }); var exp_qtyr =$('.exp_qty'+i).val(); var stock_qtyy =$('.stock_qty'+i).val(); var s_q =$('.stock_qty'+i).val(); var a_w =$('.allo_weight'+i).val(); var result=parseFloat(s_q) - parseFloat(a_w); var e_q =$('.exp_qty'+i).val(); // if(parseFloat(e_q) > result) // { // $('.exp_qty'+i).val(result); // swal({ // title: "Exp Quantity Exceeded", // text: "", // }); // } if(parseFloat(e_q) > result) { //var stock_qtyy =$('.stock_qty'+i).val(); $('.exp_qty'+i).val(result); var exp_qty =$('.exp_qty'+i).val(); var allo_weight =$('.allo_weight'+i).val(); //$('.exp_qty'+i).val(exp_qtyr); $('.exp_wt'+i).val(exp_wrt); var stock_qty =$('.stock_qty'+i).val(); var valy = parseFloat(stock_qty) - (parseFloat(exp_qty) + parseFloat(allo_weight)) ; //alert(val) if(valy == 'undefined') { $('.bal_qty'+i).val(0); } else { $('.bal_qty'+i).val(valy.toFixed(2)); } var stock_wt =$('.stock_wt'+i).val(); //$('.exp_wt'+i).val(stock_wt); var exp_wt =$('.exp_wt'+i).val(); if(exp_wt == 'NaN' || exp_wt == '') { exp_wt=0; } //alert(exp_wt); //alert(stock_wt) var value = parseFloat(stock_wt) - parseFloat(exp_wt); $('.bal_wt'+i).val(value.toFixed(2)); swal({ title: "Exp Quantity Exceeded", text: "", }); //$('.exp_qty'+i).val(stock_qty); } else { var exp_qty =$('.exp_qty'+i).val(); var exp_qtyr =$('.exp_qty'+i).val(); var exp_wrt =$('.exp_wt'+i).val(); var allo_weight =$('.allo_weight'+i).val(); if(allo_weight == 'NaN' || allo_weight == '' || allo_weight == 0) { allo_weight=0; // var stock_qty =$('.stock_qty'+i).val(); //var stock_wtt =$('.stock_wt'+i).val(); $('.exp_qty'+i).val(exp_qtyr); $('.exp_wt'+i).val(exp_wrt); } // var exp_rem_qty=parseFloat(exp_qty) - parseFloat(allo_weight); // $('.exp_qty'+i).val(exp_rem_qty.toFixed(2)); var stock_qty =$('.stock_qty'+i).val(); if(stock_qty == 'NaN' || stock_qty == '') { stock_qty=0; } var stock_wt =$('.stock_wt'+i).val(); if(stock_wt == 'NaN' || stock_wt == '') { stock_wt=0; } var exp_qty =$('.exp_qty'+i).val(); if(exp_qty == 'NaN' || exp_qty == '') { exp_qty=0; } var allo_weight =$('.allo_weight'+i).val(); if(allo_weight == 'NaN' || allo_weight == '' || allo_weight == 0) { allo_weight=0; $('.exp_qty'+i).val(exp_qtyr); $('.exp_wt'+i).val(exp_wrt); } var val = parseFloat(stock_qty) - (parseFloat(exp_qty) + parseFloat(allo_weight)) ; $('.bal_qty'+i).val(val.toFixed(2)); var exp_wt= parseFloat(exp_qty) * parseFloat(stock_wt) / parseFloat(stock_qty); $('.exp_wt'+i).val(exp_wt.toFixed(2)); var stock_wt =$('.stock_wt'+i).val(); if(stock_wt == 'NaN' || stock_wt == '') { stock_wt=0; } var exp_wt =$('.exp_wt'+i).val(); if(exp_wt == 'NaN' || exp_wt == '') { exp_wt=0; } var value = parseFloat(stock_wt) - parseFloat(exp_wt); $('.bal_wt'+i).val(value.toFixed(2)); var p_id=$('.p_id_d'+i).val(); var p_id=$('.p_id_d'+i).val(); var exp_qtyr1 =$('.exp_qty'+i).val(); var exp_wrt1 =$('.exp_wt'+i).val(); $('.hidden_exp_qty'+i).val(exp_qtyr1); $('.hidden_exp_wt'+i).val(exp_wrt1); $('.in_ordertype').each(function () { o_val.push($(this).val()); }); $('.in_netval').each(function () { n_val.push($(this).val()); }); $('.in_currency').each(function () { c_val.push($(this).val()); }); $('.in_con_type').each(function () { ct_val.push($(this).val()); }); $('.in_buyershade').each(function () { b_val.push($(this).val()); }); $('.in_unitprice').each(function () { t_val.push($(this).val()); }); $('.p_b_shades').each(function () { buy_val.push($(this).val()); }); $('.in_designing').each(function () { in_ds.push($(this).val()); }); $('.box_id').each(function () { boxes.push($(this).val()); }); $('.e_wt').each(function () { e_wt.push($(this).val()); }); //alert(e_wt); var invoice =$('#invoice').val(); //in_design //alert(buy_val); //alert(t_val); $.ajax({ url:"<?php echo base_url('packing_list/fetch_exp_qw_packing_checkbox_data');?>", type:"POST", data:{'invoice':invoice,'boxes':boxes,'e_wt':e_wt,'in_d':in_ds,'buy_val':buy_val,'ids':p_id ,'exp_qty':exp_qty,'exp_wt':exp_wt,'o_val':o_val,'n_val':n_val,'c_val':c_val,'ct_val':ct_val,'b_val':b_val,'t_val':t_val}, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var contentt = ''; $("#invoicebody").empty(); var j=1; //var key=0; $.each(objData.res,function(key,value) { var ar_new1=objData.tot_q[key]; var ar_new2=objData.tot_r[key]; var ar_new=objData.osl[key]; var r=parseFloat(ar_new1.exp_qty).toFixed(2); var rr=parseFloat(ar_new2.exp_wt).toFixed(2); var unit_p =ar_new.t_val; var value_res=parseFloat(r) * parseFloat(unit_p); //alert(value_res); var val_res=parseFloat(value_res).toFixed(2); contentt += '<tr>'; contentt += '<td><input type="text" class="fabric_id" value="'+j+'" style="width: 80px;border:transparent;">'; contentt += '<input type="text" value="'+value.id+'" style="width: 80px;border:transparent;"></td>'; contentt += '<td><input type="text" name="in_po_no[]" style="width: 130px !important;border:transparent;" id="purpose" value="'+value.po_no+'" class="in_po_no" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_article[]" style="width: 100px;border:transparent;" id="shade" class="shade in_article" value="'+value.product_name+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_width[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_mtrs in_width" value="'+value.width+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_design_val[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+ar_new.in_d+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_shades[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+value.shades+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_buyershade[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+ar_new.buy_val+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_wt[]" style="width: 80px;border:transparent;" value="'+r+'" id="weft_denier" class="in_stk_wt" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_qty[]" style="width: 80px;border:transparent;" value="'+rr+'" id="weft_quality" class="rec_weight in_stk_qty" readonly="readonly"></td>'; // if(value.b_val == '') // { // contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_buyershade" value="" value="'+value.b_val+'"></td>'; // } // else // { // contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_buyershade" value="" readonly="readonly" value="'+value.b_val+'"></td>'; // } if(ar_new.t_val == '') { contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice" value="'+ar_new.t_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice" value="'+ar_new.t_val+'" readonly="readonly"></td>'; } if(ar_new.o_val == '') { contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" value="'+ar_new.o_val+'"></td>'; } else { contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" readonly="readonly" value="'+ar_new.o_val+'"></td>'; } contentt += '<td><input type="text" name="in_netval[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_netval" value="'+val_res+'" readonly="readonly"></td>'; if(ar_new.c_val == '') { contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" value="'+ar_new.c_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" value="'+ar_new.c_val+'" readonly="readonly"></td>'; } if(ar_new.ct_val == '') { contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" value="'+ar_new.ct_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" value="'+ar_new.ct_val+'" readonly="readonly"></td>'; } contentt += '</tr>'; j++; }); $("#invoicebody").html(contentt); var contenttt = ''; boxes.length=0; e_wt.length=0; k=1; $.each(objData.getalldata,function(key,value) { if(value.datas == 0) { } else { var ar_new=objData.tot_q1[key]; var net_wt1=objData.net_wt1[key]; var nn= parseFloat(net_wt1.e_wt).toFixed(2); contenttt += '<tr>'; contenttt += '<td><input type="text" class="fabric_id" value="'+k+'" style="width: 80px;border:transparent;">'; contenttt += '<input type="hidden" style="width: 80px;border:transparent;"></td>'; contenttt += '<td><input type="text" name="pkg_box_id[]" style="width: 150px !important;border:transparent;" id="purpose" class="pkg_box_id" readonly="readonly" value="'+value.datas+'" ></td>'; contenttt += '<td><input type="text" name="b_total_pcs[]" style="width: 150px;border:transparent;" id="shade" value="'+ar_new.count+'" class="shade b_total_pcs" readonly="readonly"></td>'; contenttt += '<td><input type="text" name="b__net_wt[]" style="width: 80px;border:transparent;" id="" class="net_wt'+k+' n_wt b__net_wt" readonly="readonly" value="'+nn+'" ></td>'; contenttt += '<td><input type="text" name="b_gross_wt[]" style="width: 150px;border:transparent;" class="gross_wt'+k+' g_wt b_gross_wt" onkeyup="gross_Wt_val(this.value,'+k+')"></td>'; contenttt += '<td><input type="text" name="b_tare_wt[]" style="width: 80px;border:transparent;" id="" class="tare_wt'+k+' t_wt b_tare_wt" readonly="readonly"></td>'; contenttt += '<td><select name="box_diamension[]" id="shade" class="shade box_diamension"><option value="">'+'Select'+'</option>'; $.each(objData.box_data,function(key,val) { contenttt += '<option value="'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'">'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'</option>'; }); contenttt += '</select></td>'; contenttt += '</tr>'; k++; } }); $("#pkgbody").html(contenttt); t_val.length=0; o_val.length=0; n_val.length=0; c_val.length=0; ct_val.length=0; b_val.length=0; //buy_val.length=0; } }); } } function allo_qty_val(str,i) { var exp_qty =$('.exp_qty'+i).val(); var allo_weight =$('.allo_weight'+i).val(); var exp_rem_qty=parseFloat(exp_qty) - parseFloat(allo_weight); $('.exp_qty'+i).val(exp_rem_qty.toFixed(2)); var stock_qty =$('.stock_qty'+i).val(); var stock_wt =$('.stock_wt'+i).val(); var exp_qty =$('.exp_qty'+i).val(); var allo_weight =$('.allo_weight'+i).val(); var val = (parseFloat(exp_qty) + parseFloat(allo_weight)) - parseFloat(stock_qty); $('.bal_qty'+i).val(val.toFixed(2)); var exp_wt= parseFloat(exp_qty) * parseFloat(stock_wt) / parseFloat(stock_qty); $('.exp_wt'+i).val(exp_wt.toFixed(2)); var stock_wt =$('.stock_wt'+i).val(); var exp_wt =$('.exp_wt'+i).val(); var value = parseFloat(stock_wt) - parseFloat(exp_wt); $('.bal_wt'+i).val(value.toFixed(2)); $('.in_ordertype').each(function () { o_val.push($(this).val()); }); $('.in_netval').each(function () { n_val.push($(this).val()); }); $('.in_currency').each(function () { c_val.push($(this).val()); }); $('.in_con_type').each(function () { ct_val.push($(this).val()); }); $('.in_buyershade').each(function () { b_val.push($(this).val()); }); $('.in_unitprice').each(function () { t_val.push($(this).val()); }); $('.p_b_shades').each(function () { buy_val.push($(this).val()); }); $('.in_designing').each(function () { in_ds.push($(this).val()); }); //in_design //alert(buy_val); //alert(t_val); $.ajax({ url:"<?php echo base_url('packing_list/fetch_exp_qw_packing_checkbox_data');?>", type:"POST", data:{'in_d':in_ds,'buy_val':buy_val,'ids':p_id ,'exp_qty':exp_qty,'exp_wt':exp_wt,'o_val':o_val,'n_val':n_val,'c_val':c_val,'ct_val':ct_val,'b_val':b_val,'t_val':t_val}, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var contentt = ''; $("#invoicebody").empty(); var j=1; //var key=0; $.each(objData.res,function(key,value) { var ar_new1=objData.tot_q[key]; var ar_new2=objData.tot_r[key]; var ar_new=objData.osl[key]; var r=parseFloat(ar_new1.exp_qty).toFixed(2); var rr=parseFloat(ar_new2.exp_wt).toFixed(2); var unit_p =ar_new.t_val; var value_res=parseFloat(r) * parseFloat(unit_p); //alert(value_res); var val_res=parseFloat(value_res).toFixed(2); contentt += '<tr>'; contentt += '<td><input type="text" class="fabric_id" value="'+j+'" style="width: 80px;border:transparent;">'; contentt += '<input type="hidden" value="'+value.id+'" style="width: 80px;border:transparent;"></td>'; contentt += '<td><input type="text" name="in_po_no[]" style="width: 130px !important;border:transparent;" id="purpose" value="'+value.po_no+'" class="in_po_no" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_article[]" style="width: 100px;border:transparent;" id="shade" class="shade in_article" value="'+value.product_name+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_width[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_mtrs in_width" value="'+value.width+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_design_val[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+ar_new.in_d+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_shades[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+value.shades+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_buyershade[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+ar_new.buy_val+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_wt[]" style="width: 80px;border:transparent;" value="'+r+'" id="weft_denier" class="in_stk_wt" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_qty[]" style="width: 80px;border:transparent;" value="'+rr+'" id="weft_quality" class="rec_weight in_stk_qty" readonly="readonly"></td>'; // if(value.b_val == '') // { // contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_buyershade" value="" value="'+value.b_val+'"></td>'; // } // else // { // contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_buyershade" value="" readonly="readonly" value="'+value.b_val+'"></td>'; // } if(ar_new.t_val == '') { contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice" value="'+ar_new.t_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice" value="'+ar_new.t_val+'" readonly="readonly"></td>'; } if(ar_new.o_val == '') { contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" value="'+ar_new.o_val+'"></td>'; } else { contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" readonly="readonly" value="'+ar_new.o_val+'"></td>'; } contentt += '<td><input type="text" name="in_netval[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_netval" value="'+val_res+'" readonly="readonly"></td>'; if(ar_new.c_val == '') { contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" value="'+ar_new.c_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" value="'+ar_new.c_val+'" readonly="readonly"></td>'; } if(ar_new.ct_val == '') { contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" value="'+ar_new.ct_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" value="'+ar_new.ct_val+'" readonly="readonly"></td>'; } contentt += '</tr>'; j++; }); $("#invoicebody").html(contentt); t_val.length=0; o_val.length=0; n_val.length=0; c_val.length=0; ct_val.length=0; b_val.length=0; //buy_val.length=0; } }); } </script> <script> function exported_wt(str,i) { var string =$('.box'+i).val(); $.ajax({ url:"<?php echo base_url('packing_list/fetch_box_unique_data');?>", type:"POST", data:{'ids':string }, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var uni=objData.length_cm; uni+='*'; uni+=objData.width_cm; uni+='*'; uni+=objData.height_cm; // alert(uni); $('.box_diamension'+i).val(uni); <!---------------box list -----------------------------> $('.box_id').each(function () { boxes.push($(this).val()); }); $('.e_wt').each(function () { e_wt.push($(this).val()); }); //alert(e_wt); var invoice =$('#invoice').val() $.ajax({ url:"<?php echo base_url('packing_list/box_list_data');?>", type:"POST", data:{'invoice':invoice,'boxes':boxes,'e_wt':e_wt}, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var contentt = ''; boxes.length=0; e_wt.length=0; k=1; $.each(objData.getalldata,function(key,value) { var ar_new=objData.tot_q[key]; var net_wt1=objData.net_wt1[key]; var nn= parseFloat(net_wt1.e_wt).toFixed(2); contentt += '<tr>'; contentt += '<td><input type="text" class="fabric_id" value="'+k+'" style="width: 80px;border:transparent;">'; contentt += '<input type="hidden" style="width: 80px;border:transparent;"></td>'; contentt += '<td><input type="text" name="pkg_box_id[]" style="width: 150px !important;border:transparent;" id="purpose" class="pkg_box_id" readonly="readonly" value="'+value.datas+'" ></td>'; contentt += '<td><input type="text" name="b_total_pcs[]" style="width: 150px;border:transparent;" id="shade" value="'+ar_new.count+'" class="shade b_total_pcs" readonly="readonly"></td>'; contentt += '<td><input type="text" name="b__net_wt[]" style="width: 80px;border:transparent;" id="" class="net_wt'+k+' n_wt b__net_wt" readonly="readonly" value="'+nn+'" ></td>'; contentt += '<td><input type="text" name="b_gross_wt[]" style="width: 150px;border:transparent;" class="gross_wt'+k+' g_wt b_gross_wt" onkeyup="gross_Wt_val(this.value,'+k+')"></td>'; contentt += '<td><input type="text" name="b_tare_wt[]" style="width: 80px;border:transparent;" id="" class="tare_wt'+k+' t_wt b_tare_wt" readonly="readonly"></td>'; contentt += '<td><select name="box_diamension[]" id="shade" class="shade box_diamension"><option value="">'+'Select'+'</option>'; $.each(objData.box_data,function(key,val) { contentt += '<option value="'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'">'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'</option>'; }); contentt += '</select></td>'; contentt += '</tr>'; k++; }); $("#pkgbody").html(contentt); } }); } }); } function gross_Wt_val(str,i) { $('.gross_wt'+i).on('change keyup', function() { var sanitized = $(this).val().replace(/[^0-9.]/g, ''); $(this).val(sanitized); // $('.box'+i).val(''); }); var g =$('.gross_wt'+i).val(); var n =$('.net_wt'+i).val(); // alert(g); // alert(n); var f=parseFloat(n) - parseFloat(g); $('.tare_wt'+i).val(f.toFixed(2)); //var n =$('.nets_wt'+i).val(); } $(function () { $("#sys_date").datepicker({ dateFormat: "dd/mm/yy", changeMonth: true, changeYear: true }); }); $(function () { $("#order_date").datepicker({ dateFormat: "dd/mm/yy", changeMonth: true, changeYear: true }); }); $(function () { $("#delivery_date").datepicker({ dateFormat: "dd/mm/yy", changeMonth: true, changeYear: true }); }); boxes=[]; e_wt=[]; function box_unique_no(str,i) { $('.box'+i).on('change keyup', function() { var sanitized = $(this).val().replace(/[^0-9.]/g, ''); $(this).val(sanitized); // $('.box'+i).val(''); }); var string =$('.box'+i).val(); if(string > 0) { $.ajax({ url:"<?php echo base_url('packing_list/fetch_box_unique_data');?>", type:"POST", data:{'ids':string }, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var uni=objData.length_cm; uni+='*'; uni+=objData.width_cm; uni+='*'; uni+=objData.height_cm; // alert(uni); $('.box_diamension'+i).val(uni); <!---------------box list -----------------------------> $('.box_id').each(function () { boxes.push($(this).val()); }); $('.e_wt').each(function () { e_wt.push($(this).val()); }); //alert(e_wt); var invoice =$('#invoice').val() $.ajax({ url:"<?php echo base_url('packing_list/box_list_data');?>", type:"POST", data:{'invoice':invoice,'boxes':boxes,'e_wt':e_wt}, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var contentt = ''; boxes.length=0; e_wt.length=0; k=1; $.each(objData.getalldata,function(key,value) { if(value.datas == 0) { } else { var ar_new=objData.tot_q[key]; var net_wt1=objData.net_wt1[key]; var nn= parseFloat(net_wt1.e_wt).toFixed(2); contentt += '<tr>'; contentt += '<td><input type="text" class="fabric_id" value="'+k+'" style="width: 80px;border:transparent;">'; contentt += '<input type="hidden" style="width: 80px;border:transparent;"></td>'; contentt += '<td><input type="text" name="pkg_box_id[]" style="width: 150px !important;border:transparent;" id="purpose" class="pkg_box_id" readonly="readonly" value="'+value.datas+'" ></td>'; contentt += '<td><input type="text" name="b_total_pcs[]" style="width: 150px;border:transparent;" id="shade" value="'+ar_new.count+'" class="shade b_total_pcs" readonly="readonly"></td>'; contentt += '<td><input type="text" name="b_net_wt[]" style="width: 80px;border:transparent;" id="weft_spec" class="net_wt'+k+' n_wt b_net_wt" readonly="readonly" value="'+nn+'" ></td>'; contentt += '<td><input type="text" name="b_gross_wt[]" style="width: 150px;border:transparent;" class="gross_wt'+k+' g_wt b_gross_wt" onkeyup="gross_Wt_val(this.value,'+k+')"></td>'; contentt += '<td><input type="text" name="b_tare_wt[]" style="width: 80px;border:transparent;" id="" class="tare_wt'+k+' t_wt b_tare_wt" readonly="readonly"></td>'; contentt += '<td><select name="box_diamension[]" id="shade" class="shade box_diamension"><option value="">'+'Select'+'</option>'; $.each(objData.box_data,function(key,val) { contentt += '<option value="'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'">'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'</option>'; }); contentt += '</select></td>'; // contentt += '<td><input type="text" name="box_diamension[]" style="width: 150px;border:transparent;" id="shade" class="shade box_diamension" readonly="readonly" value="'+value.box_len+'*'+value.box_wid+'*'+value.box_hei+'" ></td>'; contentt += '</tr>'; k++; } }); $("#pkgbody").html(contentt); } }); } }); } else { } } </script> <!--------------------------------Allo Qty calculations--------------------------------------------------> <script> t_val=[]; o_val=[]; n_val=[]; c_val=[]; ct_val=[]; buy_val=[]; b_val=[]; in_d=[]; in_ds=[]; boxes=[]; e_wt=[]; function allo_exp_qty_val(str,i) { $('.allo_weight'+i).on('change keyup', function() { var sanitized = $(this).val().replace(/[^0-9.]/g, ''); $(this).val(sanitized); }); var allo_weighte =$('.allo_weight'+i).val(); if(allo_weighte > 0) { if(parseFloat(allo_weighte) > 2) { swal({ title: "Allo Quantity Exceeded", text: "", }); $('.allo_weight'+i).val('0'); } else { var exp_qty =$('.exp_qty'+i).val(); var exp_qtyr =$('.exp_qty'+i).val(); var exp_wrt =$('.exp_wt'+i).val(); var exp_qtyrr =$('.hidden_exp_qty'+i).val(); var exp_wrtt =$('.hidden_exp_qty'+i).val(); if(exp_qty == 'NaN' || exp_qty == '') { exp_qty=0; } var allo_weight =$('.allo_weight'+i).val(); if(allo_weight == 'NaN' || allo_weight == '' || allo_weight == 0) { allo_weight=0; $('.exp_qty'+i).val(exp_qtyrr); $('.exp_wt'+i).val(exp_wrtt); } var exp_rem_qty=parseFloat(exp_qty) - parseFloat(allo_weight); $('.exp_qty'+i).val(exp_rem_qty.toFixed(2)); var stock_qty =$('.stock_qty'+i).val(); if(stock_qty == 'NaN' || stock_qty == '') { stock_qty=0; } var stock_wt =$('.stock_wt'+i).val(); if(stock_wt == 'NaN' || stock_wt == '') { stock_wt=0; } var exp_qty =$('.exp_qty'+i).val(); if(exp_qty == 'NaN' || exp_qty == '') { exp_qty=0; } var allo_weight =$('.allo_weight'+i).val(); if(allo_weight == 'NaN' || allo_weight == '' || allo_weight == 0) { allo_weight=0; $('.exp_qty'+i).val(exp_qtyrr); $('.exp_wt'+i).val(exp_wrtt); } var val = parseFloat(stock_qty) - (parseFloat(exp_qty) + parseFloat(allo_weight)) ; $('.bal_qty'+i).val(val.toFixed(2)); var exp_wt= parseFloat(exp_qty) * parseFloat(stock_wt) / parseFloat(stock_qty); $('.exp_wt'+i).val(exp_wt.toFixed(2)); var stock_wt =$('.stock_wt'+i).val(); if(stock_wt == 'NaN' || stock_wt == '') { stock_wt=0; } var exp_wt =$('.exp_wt'+i).val(); if(exp_wt == 'NaN' || exp_wt == '') { exp_wt=0; } var value = parseFloat(stock_wt) - parseFloat(exp_wt); $('.bal_wt'+i).val(value.toFixed(2)); var p_id=$('.p_id_d'+i).val(); var p_id=$('.p_id_d'+i).val(); // var allo_weight =$('.allo_weight'+i).val(); // if(allo_weight == 'NaN' || allo_weight == '' || allo_weight == 0) // { // allo_weight=0; // var stock_qty =$('.stock_qty'+i).val(); // var stock_wt =$('.stock_wt'+i).val(); // $('.exp_qty'+i).val(stock_qty.toFixed(2)); // $('.exp_wt'+i).val(stock_wt.toFixed(2)); // } $('.in_ordertype').each(function () { o_val.push($(this).val()); }); $('.in_netval').each(function () { n_val.push($(this).val()); }); $('.in_currency').each(function () { c_val.push($(this).val()); }); $('.in_con_type').each(function () { ct_val.push($(this).val()); }); $('.in_buyershade').each(function () { b_val.push($(this).val()); }); $('.in_unitprice').each(function () { t_val.push($(this).val()); }); $('.p_b_shades').each(function () { buy_val.push($(this).val()); }); $('.in_designing').each(function () { in_ds.push($(this).val()); }); $('.box_id').each(function () { boxes.push($(this).val()); }); $('.e_wt').each(function () { e_wt.push($(this).val()); }); //alert(e_wt); var invoice =$('#invoice').val(); $.ajax({ url:"<?php echo base_url('packing_list/fetch_exp_qw_packing_checkbox_data');?>", type:"POST", data:{'boxes':boxes,'e_wt':e_wt,'in_d':in_ds,'invoice':invoice,'buy_val':buy_val,'ids':p_id ,'exp_qty':exp_qty,'exp_wt':exp_wt,'o_val':o_val,'n_val':n_val,'c_val':c_val,'ct_val':ct_val,'b_val':b_val,'t_val':t_val}, async:false, success: function (data) { var objData = jQuery.parseJSON(data); var contentt = ''; $("#invoicebody").empty(); var j=1; //var key=0; $.each(objData.res,function(key,value) { var ar_new1=objData.tot_q[key]; var ar_new2=objData.tot_r[key]; var ar_new=objData.osl[key]; var r=parseFloat(ar_new1.exp_qty).toFixed(2); var rr=parseFloat(ar_new2.exp_wt).toFixed(2); var unit_p =ar_new.t_val; var value_res=parseFloat(r) * parseFloat(unit_p); //alert(value_res); var val_res=parseFloat(value_res).toFixed(2); contentt += '<tr>'; contentt += '<td><input type="text" class="fabric_id" value="'+j+'" style="width: 80px;border:transparent;">'; contentt += '<input type="text" value="'+value.id+'" style="width: 80px;border:transparent;"></td>'; contentt += '<td><input type="text" name="in_po_no[]" style="width: 130px !important;border:transparent;" id="purpose" value="'+value.po_no+'" class="in_po_no" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_article[]" style="width: 100px;border:transparent;" id="shade" class="shade in_article" value="'+value.product_name+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_width[]" style="width: 80px;border:transparent;" id="weft_spec" class="bal_mtrs in_width" value="'+value.width+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_design_val[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+ar_new.in_d+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_shades[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+value.shades+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_buyershade[]" style="width: 150px;border:transparent;" id="shade" class="shade in_shades" value="'+ar_new.buy_val+'" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_wt[]" style="width: 80px;border:transparent;" value="'+r+'" id="weft_denier" class="in_stk_wt" readonly="readonly"></td>'; contentt += '<td><input type="text" name="in_stk_qty[]" style="width: 80px;border:transparent;" value="'+rr+'" id="weft_quality" class="rec_weight in_stk_qty" readonly="readonly"></td>'; // if(value.b_val == '') // { // contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_buyershade" value="" value="'+value.b_val+'"></td>'; // } // else // { // contentt += '<td><input type="text" name="in_buyershade[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_buyershade" value="" readonly="readonly" value="'+value.b_val+'"></td>'; // } if(ar_new.t_val == '') { contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice" value="'+ar_new.t_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_unitprice[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_unitprice" value="'+ar_new.t_val+'" readonly="readonly"></td>'; } if(ar_new.o_val == '') { contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" value="'+ar_new.o_val+'"></td>'; } else { contentt += '<td><input type="text" name="in_ordertype[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_ordertype" readonly="readonly" value="'+ar_new.o_val+'"></td>'; } contentt += '<td><input type="text" name="in_netval[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_netval" value="'+val_res+'" readonly="readonly"></td>'; if(ar_new.c_val == '') { contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" value="'+ar_new.c_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_currency[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_currency" value="'+ar_new.c_val+'" readonly="readonly"></td>'; } if(ar_new.ct_val == '') { contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" value="'+ar_new.ct_val+'" ></td>'; } else { contentt += '<td><input type="text" name="in_con_type[]" style="width: 80px;border:transparent;" id="weft_denier" class="in_con_type" value="'+ar_new.ct_val+'" readonly="readonly"></td>'; } contentt += '</tr>'; j++; }); $("#invoicebody").html(contentt); var contenttt = ''; boxes.length=0; e_wt.length=0; k=1; $.each(objData.getalldata,function(key,value) { if(value.datas == 0) { } else { var ar_new=objData.tot_q1[key]; var net_wt1=objData.net_wt1[key]; var nn= parseFloat(net_wt1.e_wt).toFixed(2); contenttt += '<tr>'; contenttt += '<td><input type="text" class="fabric_id" value="'+k+'" style="width: 80px;border:transparent;">'; contenttt += '<input type="hidden" style="width: 80px;border:transparent;"></td>'; contenttt += '<td><input type="text" name="pkg_box_id[]" style="width: 150px !important;border:transparent;" id="purpose" class="pkg_box_id" readonly="readonly" value="'+value.datas+'" ></td>'; contenttt += '<td><input type="text" name="b_total_pcs[]" style="width: 150px;border:transparent;" id="shade" value="'+ar_new.count+'" class="shade b_total_pcs" readonly="readonly"></td>'; contenttt += '<td><input type="text" name="b__net_wt[]" style="width: 80px;border:transparent;" id="" class="net_wt'+k+' n_wt b__net_wt" readonly="readonly" value="'+nn+'" ></td>'; contenttt += '<td><input type="text" name="b_gross_wt[]" style="width: 150px;border:transparent;" class="gross_wt'+k+' g_wt b_gross_wt" onkeyup="gross_Wt_val(this.value,'+k+')"></td>'; contenttt += '<td><input type="text" name="b_tare_wt[]" style="width: 80px;border:transparent;" id="" class="tare_wt'+k+' t_wt b_tare_wt" readonly="readonly"></td>'; contenttt += '<td><select name="box_diamension[]" id="shade" class="shade box_diamension"><option value="">'+'Select'+'</option>'; $.each(objData.box_data,function(key,val) { contenttt += '<option value="'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'">'+val.length_cm+' X '+val.width_cm+' X '+val.height_cm+'</option>'; }); contenttt += '</select></td>'; contenttt += '</tr>'; k++; } }); $("#pkgbody").html(contenttt); t_val.length=0; o_val.length=0; n_val.length=0; c_val.length=0; ct_val.length=0; b_val.length=0; //buy_val.length=0; } }); } } else if(allo_weighte == '-') { alert('Please Enter Positive Numbers'); } } </script> <link href="<?php echo base_url('assets/css/sweetalert2.min.css');?>" rel="stylesheet"/> <script src="<?php echo base_url('assets/js/sweetalert2.min.js');?>"></script> <link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>"> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" /> <script> $('.transfer_modal_application').submit(function(e){ e.preventDefault(); var u=$('#units').val(); // alert(u); formdata = new FormData($(this)[0]); $.ajax({ type : 'post', url:"<?php echo base_url('packing_list/insert_old_Stock_packing_data');?>", data : formdata, contentType: false, processData: false, success:function(response) { var obj = jQuery.parseJSON(response); //alert(obj.invoice); //alert(obj.invoice_num); var confirmMsg= confirm("Do You Want To Create One More Packing List For Same Invoice No.!"); if (confirmMsg==true) { //alert('sadasd'); $('#invoice').val(obj.invoice_num); $('#invoice_number_g').val(obj.invoice); $("#yarnTbody").empty(); $("#invoicebody").empty(); $("#pkgbody").empty(); $('#customer_name').val(''); $('#osl_no').val(''); $('#order_date').val(''); $('#delivery_date').val(''); $('#units').val(''); $('#units1').val(''); //$('.transfer_modal_application')[0].reset(); } else if (confirmMsg==false) { window.location.href = '<?php echo base_url('packing_list/paking_list_details?prop_id=1');?>'; } // window.location.href = '<?php echo base_url('packing_list/paking_list_details?prop_id=1');?>'; } }); }); </script> <style> #dying{ display:none; } .form-horizontal .radio-inline { padding-top: 2px !important; margin-top: 0; margin-bottom: 0; } .form-horizontal .radio > span { margin-top: -3px !important; } .skin-blue .wrapper, .skin-blue .left-side { background-color: #ffffff !important; } .skin-blue .main-sidebar { background-color: #e6e6e6 !important; } @media only screen and (min-width:641px) and (max-width:991px) { .form-group label{ padding-left:20px !important; } } .body-middle { //width:550px; padding-top: 20px; padding-left: 20px; padding-right: 20px; color:#000; } .twisting { padding-bottom:50px; } .twisting table, th, td { border: 1px solid black; border-collapse: collapse; } .twisting th, td { padding:5px; } .text-input { border: initial; width:100%; } .text-input1 { border: initial; width:80%; } .material-tr td { text-align:center; } </style> <style> .content-wrapper{ overflow:auto !important; } .modal-dialog{ width:70% !important; } .ss{ margin-left:415px; } .modal-content{ margin-left:-170px; } @media only screen and (min-width:320px) and (max-width:640px){ .modal-dialog{ width:1200px !important; } #myModal_weft_dying{ width:100% !important; overflow-x:scroll; } .ss{ margin-left:0px; } .modal-content{ margin-left:0px; } } </style>