EVOLUTION-NINJA
Edit File: generate_product_po_page.php
<?php $this->load->view('includes/header.php')?> <link rel="stylesheet" href="<?php echo base_url('assets/css/jquery-ui.css');?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url('dashboard_assets/css/main.css'); ?>" /> <link href="https://fonts.googleapis.com/css?family=Roboto" rel="stylesheet"> <script src="<?php echo base_url('assets/js/jquery-ui.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('dashboard_assets/js/popper.min.js'); ?>" ></script> <div class="page-content-wrapper"> <div class="page-content"> <h3 class="page-title" style="padding-top: 20px;">Generate PO</h3> <form method="post" id="po_submit"> <div class="row"> <div class="col-sm-4"> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>PO#</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <input class="form-control" type="text" name="po_no" id="po_no" style="width: 100%;border: transparent; background: #ffffff !important;" value="<?php echo "MMG-".$fin_y."-PO-". $sl_no; ?>" readonly="readonly"> <input type="hidden" name="po_id" id="po_id" value="<?php echo $sl_no; ?>" style="background: #ffffff !important;"> <input type="hidden" name="financial_year" id="financial_year" value="<?php echo $fin_y; ?>" style="background: #ffffff !important;"> </div> </div> </div> <div class="row site_detail1"> <div class="col-sm-4"> <div class="form-group"> <label><b>Site</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="site_number" class="form-control site_number" id="site_number" required > </select> </div> </div> </div> <div class="row godown_detail1"> <div class="col-sm-4"> <div class="form-group"> <label><b>Godown</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="godown_id" class="form-control godown_id" id="godown_id" required > </select> </div> </div> </div> <div class="row site_detail2"> <div class="col-sm-4"> <div class="form-group"> <label><b>Level</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="level" class="form-control" id="level" required> <option value="">Select</option> <?php foreach ($level as $key => $value) {?> <option value="<?php echo $value->id;?>"><?php echo $value->level_name;?></option> <?php } ?> </select> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>Date</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <input class="form-control" type="text" name="g_date" id="g_date" value="<?php echo date("d-m-Y"); ?>" required readonly > </div> </div> </div> </div> <div class="col-sm-4"> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>Layout</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="layout" class="form-control" id="layout" required> <option value="">Select</option> <?php foreach ($layouts as $key => $value) {?> <option value="<?php echo $value->id;?>"><?php echo $value->layout_name;?></option> <?php } ?> </select> </div> </div> </div> <div class="row site_detail3"> <div class="col-sm-4"> <div class="form-group"> <label><b>Customer</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <input class="form-control" type="text" name="customer" id="customer" readonly > </div> </div> </div> <div class="row site_detail4"> <div class="col-sm-4"> <div class="form-group"> <label><b>Customer Address</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <textarea name="customer_address" class="form-control customer_address" id="customer_address" required></textarea> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>Currency</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="currency" id="currency" class="form-control" style="width: 100%;border: transparent;" readonly required> <option value="INR">INR</option> <!-- <option value="CHF">CHF</option> <option value="EUR">EUR</option> <option value="GBP">GBP</option> <option value="USD">USD</option>--> </select> </div> </div> </div> </div> <div class="col-sm-4"> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>PO For</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="po_for" class="form-control" id="po_for" onchange="selection_hide();" required> <!-- <option value="">Select</option> <option value="Site">Site</option> <option value="Godown">Godown</option> --> </select> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>Vendor</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <select name="vendor" class="form-control change_vendor" id="vendor" required> <option value="">Select</option> <?php foreach ($vendor as $key => $value) {?> <option value="<?php echo $value->id;?>"><?php echo $value->vendor;?></option> <?php } ?> </select> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label><b>Vendor Address</b></label> </div> </div> <div class="col-sm-8"> <div class="form-group"> <textarea name="vendor_address" class="form-control vendor_address" id="vendor_address" required readonly ></textarea> </div> </div> </div> </div> </div> <div class="row"> <div class="table-responsive po_create_input"> <table style="width:100%;" class="table table-bordered tab_vendor"> <thead class="thead-default"> <tr style="background:#367fa9;color:#ffffff;"> <th>Sl. No.</th> <th style="width: 200px;">Product Type</th> <th>Product Name</th> <th>Quantity</th> <th>Unit Price</th> <th class="inr_val" id="inr_val" name="inr_val">INR Value</th> <th class="chf_val" id="chf_val" name="chf_val" style="display: none;">CHF Value</th> <th style="display: none;" class="eur_val" id="eur_val" name="eur_val">EUR Value</th> <th style="display: none;" class="gbp_val" id="gbp_val" name="gbp_val">GBP Value</th> <th style="display: none;" class="usd_val" id="usd_val" name="usd_val">USD Value</th> <th>SGST</th> <th>CGST</th> <th>IGST</th> <th>Total Value</th> <th class="action">Action</th> </tr> </thead> <tbody> <?php $i=1; ?> <?php if(isset($product_list)) { foreach($product_list as $key=>$productlist) { ?> <tr> <td scope="row"><?php echo $i; ?></td> <td><input type="text" style="border:transparent;text-transform: uppercase !important;" class="product_type" name="product_type[]" id="product_type" value="<?php echo $productlist->product_group_name; ?>" readonly > <input type="hidden" style="border:transparent;" class="product_type_id" name="product_type_id[]" id="product_type_id" value="<?php echo $productlist->product_type; ?>" readonly> </td> <td><input type="text" class="product_name" name="product_name[]" id="product_name" value="<?php echo $productlist->product_name;?>" style="border: transparent;text-transform: uppercase !important;" readonly> <input type="hidden" style="border:transparent;" class="product_id" name="product_id[]" id="product_id" value="<?php echo $productlist->product_id; ?>" readonly> </td> <td><!-- <input type="text" id="quantity" class="quantity" name="quantity[]" value="<?php //echo $productlist->quantity." ".$productlist->unit_name; ?>" style="width: 100%;border: transparent;" required> --> <input type="text" id="quantity<?php echo $key;?>" class="quantity<?php echo $key;?>" name="quantity[]" value="0" onkeyup="quantity_valuefirst(this.value,<?php echo $key;?>)" style="width: 100%;border: transparent;" required> <!-- <input type="hidden" id="quantity_no<?php echo $key;?>" class="quantity_no<?php echo $key;?>" name="quantity_no[]" value="<?php echo $productlist->quantity; ?>" style="width: 100%;border: transparent;" required> --> <input type="hidden" id="unit_id" class="unit_id" name="unit_id[]" value="<?php echo $productlist->unit_id; ?>" style="width: 100%;border: transparent;" readonly> </td> <td><input type="text" id="unit_price<?php echo $key;?>" name="unit_price[]" onkeyup="unit_valuefirst(this.value,<?php echo $key;?>)" class="unit_price<?php echo $key;?>" value="<?php echo $productlist->unit_price; ?>" style="width: 100%;border: transparent;" required></td> <td><input type="text" class="inr_value<?php echo $key;?> inrval" id="inr_value<?php echo $key;?>" name="inr_value[]" style="width: 100%;border: transparent;" required readonly></td> <td ><input type="text" class="sgst<?php echo $key;?>" id="sgst<?php echo $key;?>" name="sgst[]" onkeyup="gstvalue1(this.value,<?php echo $key;?>)" value="<?php echo $productlist->sgst; ?>" style="width: 50%;border: transparent;" required> <span>%</span></td> <td><input type="text" class="cgst<?php echo $key;?>" id="cgst<?php echo $key;?>" name="cgst[]" onkeyup="gstvalue2(this.value,<?php echo $key;?>)" value="<?php echo $productlist->cgst; ?>" style="width: 50%;border: transparent;" required> <span>%</span></td> <td><input type="text" class="igst<?php echo $key;?>" id="igst<?php echo $key;?>" name="igst[]" onkeyup="gstvalue3(this.value,<?php echo $key;?>)" value="<?php echo $productlist->igst; ?>" style="width: 50%;border: transparent;" required> <span>%</span></td> <td><input type="text" class="total_value<?php echo $key;?> tot_val" id="total_value<?php echo $key;?>" name="total_value[]" style="width: 100%;border: transparent;" readonly></td> <td class="action" style="text-align:center;padding: 5px;border: 1px solid #000;vertical-align: middle;"><a class="remove" href="javascript:void(0);"><i class="fa fa-trash" aria-hidden="true"></i></a></td> </tr> <?php $i++; } } ?> <tr> <th scope="row"></th> <td colspan="2"><input type="text" placeholder="OTHER CHARGES :" name="ot_charges" id="ot_charges" style="width: 100%;border: transparent;text-transform: uppercase !important;" ></td> <td ><input type="text" id="ot_charges_quantity" name="ot_charges_quantity" value="0" style="width: 100%;border: transparent;" ></td> <td ><input type="text" id="ot_charges_unit_price" name="ot_charges_unit_price" value="0" onfocusout="unitvalue1(this.value)" style="width: 100%;border: transparent;" ></td> <td><input type="text" class="ot_charges_inr_value" id="ot_charges_inr_value" name="ot_charges_inr_value" value="0" style="width: 100%;border: transparent;" readonly></td> <td><input type="text" class="ot_charges_sgst ot_sgst" id="ot_charges_sgst" name="ot_charges_sgst" value="0" onfocusout="sgstvalue1(this.value)" style="width: 42%;border: transparent;" > <span>%</span></td> <td><input type="text" class="ot_charges_cgst ot_cgst" id="ot_charges_cgst" name="ot_charges_cgst" value="0" onfocusout="sgstvalue2(this.value)" style="width: 42%;border: transparent;" > <span>%</span></td> <td><input type="text" class="ot_charges_igst ot_igst" id="ot_charges_igst" name="ot_charges_igst" value="0" onfocusout="sgstvalue3(this.value)" style="width: 42%;border: transparent;" > <span>%</span></td> <td><input type="text" class="ot_charges_tot_val to_val" id="ot_charges_tot_val" name="ot_charges_tot_val" value="0" style="width: 100%;border: transparent;" ></td> </tr> <tr> <th colspan="5" rowspan="5"> <textarea rows="3" id="note" name="note" style="width: 100%; border: transparent;text-transform: uppercase !important;" placeholder="NOTE : " ></textarea> </th> <td colspan="3">TOTAL AMOUNT</td> <td colspan="2" style="padding-bottom: 10px;"><input type="text" class="total_amt" id="total_amt" name="total_amt" style="width: 100%;border: transparent;" readonly="readonly" required onfocusin="amount_total1()"></td> </tr> <tr> <!-- <td colspan="3"><p>DISCOUNT %</p><p>DISCOUNT Rs</p></td> <td colspan="2" style="padding-bottom: 10px;"><input type="text" class="discount" id="discount" name="discount" value="0" onkeyup="discountvalue(this.value)" style="width: 55%;border: transparent;" required>%<br><input type="text" name="discount_amount" class="discount_amount" value="0" onkeyup="discountamount(this.value)" style="width: 55%;border: transparent;margin-top: 10px;" required>Rs</td> --> <td colspan="3">TAX AMOUNT</td> <td colspan="2" style="padding-bottom: 10px;"><input type="text" class="total_tax" id="total_tax" name="tax_amount" value="0" style="width: 55%;border: transparent;" required></td> </tr> <tr> <td colspan="3">TOTAL</td> <td colspan="2" style="padding-bottom: 10px;"><input type="text" name="total" value="0" class="total" style="width: 55%;border: transparent;" required></td> </tr> <tr> <td colspan="3"><p><span onclick="plus_function();">Plus</span>/<span onclick="minus_function();">Minus</span></p></td> <td colspan="2" style="padding-bottom: 10px;"><input type="text" name="round_off" value="0" class="round_off" onkeyup="rounded_of(this.value)" style="width: 55%;border: transparent;" required></td> </tr> <tr> <td colspan="3">GRAND TOTAL</td> <td colspan="2" style="padding-bottom: 10px;"><input type="text" class="g_total" id="g_total" name="g_total" style="width: 100%;border: transparent;" readonly="readonly" required></td> </tr> <tr> <td colspan="10" style=""> <h5 style="padding-bottom: 15px;">Terms and Conditions:</h5> <ol> <li>Material Delivery :<input type="text" class="comment" id="comment" name="comment" style="width: 70%;border: transparent; text-transform: uppercase !important;" ></li> <li>GST No. :<input type="text" class="gst_no" id="gst_no" name="gst_no" value="" style="width: 70%;border: transparent; text-transform: uppercase !important;" ></li> <li>Terms of payment :<input type="text" class="terms_payment" id="terms_payment" name="terms_payment" style="width: 70%;border: transparent; text-transform: uppercase !important;" ></li> <li>BANK DETAILS :<input type="text" class="bank_details" id="bank_details" name="bank_details" value="" style="width: 70%;border: transparent; text-transform: uppercase !important;" ></li> </ol> </td> </tr> </tbody> </table> </div> </div> <br/><br/> <button type="submit" class="btn center-block submit" id="submit_button" style="float: left;margin-left: 39%;width: 100px; background: #405189 !important ; color: white;">Submit</button> <button type="button" class="btn default cancel" style="background: white; margin-left: 20px;" >Cancel</button> <!-- <a href="<?php echo base_url(); ?>purchase-order" class="btn default" style=" width:8%; background:rgb(240,240,240) !important;margin-left: 20px;">Cancel</a> --> </form> </div> <!-- page-content --> </div> <script type="text/javascript"> $('.cancel').click(function(){ window.location = '<?php echo site_url("create-po")?>'; }); $(document).ready(function() { $(".site_detail1").hide(); $(".site_detail2").hide(); $(".site_detail3").hide(); $(".site_detail4").hide(); $(".godown_detail1").hide(); }); function selection_hide() { var po_for = $("#po_for").val(); if(po_for == "Site") { $(".site_detail1").show(); $('#site_number').attr('required', 'required'); $(".site_detail2").show(); $('#level').attr('required', 'required'); $(".site_detail3").show(); $('#customer').attr('required', 'required'); $(".site_detail4").show(); $('#customer_address').attr('required', 'required'); $(".godown_detail1").hide(); $('#godown_id').removeAttr('required'); } else { $(".godown_detail1").show(); $('#godown_id').attr('required', 'required'); $(".site_detail1").hide(); $('#site_number').removeAttr('required'); $(".site_detail2").hide(); $('#level').removeAttr('required'); $(".site_detail3").hide(); $('#customer').removeAttr('required'); $(".site_detail4").hide(); $('#customer_address').removeAttr('required'); } } $('#po_for').change(function() { var po_for = $(this).val(); var layout_id = $('#layout').val(); $.ajax({ type:'post', url:'<?php echo site_url('fetch-site-godown');?>', data:{"po_for":po_for,"layout_id":layout_id}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); $('.site_number').empty(); $('.godown_id').empty(); if(response.result == 1) { var con = ''; if(po_for == 'Site') { con += '<option value="">select</option>'; $.each( response.message, function( key, value ) { con += '<option value="'+value.id+'">'+value.site_no+'</option>'; }); $('.site_number').append(con); } else if(po_for == 'Godown') { con += '<option value="">select</option>'; $.each( response.message, function( key, value ) { con += '<option value="'+value.id+'">'+value.godown_name+'</option>'; }); $('.godown_id').append(con); } } else { toastr["error"](response.message); } } }); }); $('#layout').change(function() { var con = ''; con += '<option value="">select</option>'; con += '<option value="Site">Site</option>'; con += '<option value="Godown">Godown</option>'; $('#po_for').empty(); $('#po_for').append(con); }); /*$('#layout').change(function() { var layout_name = $(this).val(); var po_for = $('#po_for').val(); alert(po_for); $.ajax({ type:'post', url:'<?php echo site_url('fetch-site-id');?>', data:{"layout_name":layout_name}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { var con = ''; con += '<option value="">select</option>'; $.each( response.message, function( key, value ) { con += '<option value="'+value.id+'">'+value.site_no+'</option>'; }); $('.site_number').empty(); $('.site_number').append(con); } else { toastr["error"](response.message); } } }); });*/ $('#site_number').change(function() { var layout_id = $('#layout').val(); var site_number = $(this).val(); // alert(site_number); $.ajax({ type:'post', url:'<?php echo site_url('fetch-sales-customer');?>', data:{"layout_id":layout_id,"site_id":site_number}, success:function(response){ response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { var customer_name = response.message.name; var customer_address = response.message.address; $('#customer').val(customer_name); $('#customer_address').val(customer_address); } else { toastr["error"](response.message); } } }); }); $(document).ready(function() { $("#vendor_name" ).autocomplete({ source: '<?php echo site_url("auto-complete-vendor-name"); ?>', }); }); $('.change_vendor').change(function() { $('#address').val(''); $('#bank_details').val(''); $('#gst_no').val(''); var id = $('#vendor option:selected').val(); //var customer = document.getElementById('supplier_name').value; $.ajax({ type : 'post', url :"<?php echo site_url('vendor-data')?>", data :{'id':id}, success:function(response) { obj=jQuery.parseJSON(response); console.log(obj); if(obj.result == 1) { document.getElementById('vendor_address').value+=obj.message.address+"\n"; document.getElementById('vendor_address').value+=obj.message.city+"\n"; document.getElementById('vendor_address').value+=obj.message.country+"\n"; document.getElementById('vendor_address').value+=obj.message.pincode; /*document.getElementById('bank_details').value=' '+'A/c No. '+obj.message.ac_no+"\n"; document.getElementById('bank_details').value+=','+obj.message.bank_name+"\n"; document.getElementById('bank_details').value+=','+obj.message.bank_address+"\n"; document.getElementById('bank_details').value+=','+obj.message.ifsc_code+"\n"; document.getElementById('bank_details').value+=','+obj.message.pan_no; document.getElementById('gst_no').value+=obj.message.gst_no;*/ } } }); }); $('#po_submit').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); swal({ title: "Are you sure?", text: "You want to Save this?", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : "<?php echo site_url('add-product-po');?>", data : formdata, contentType: false, processData: false, success:function(response) { response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); setTimeout(function wait(){ window.location = '<?php echo site_url("inward-purchases")?>'; }, 1000); } else { toastr["error"](response.message); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); }); $(".remove").click(function(){ $(this).closest('tr').remove(); amount_total1(); }); function quantity_valuefirst(str,i) { var quantity_val=str; var stock = $('.stock_qty'+i).val(); /* if(parseFloat(quantity_val) > parseFloat(stock)) { swal({ title: "Quantity exceeded stock quantity!!", //text: "You want to Save this?", type: "warning", showCancelButton: false, confirmButtonColor: "#DD6B55", confirmButtonText: "OK!", //cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }); $('.quantity'+i).val(0); } else {*/ var unit = $('.unit_price'+i).val(); var inr_val = str * unit; $('.inr_value'+i).val(inr_val); var cgst =$('.cgst'+i).val(); var sgst =$('.sgst'+i).val(); var igst =$('.igst'+i).val(); var tax=parseFloat(cgst) + parseFloat(sgst)+ parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); // } } function unit_valuefirst(str,i) { var unit=str; var quantity_val = $('.quantity'+i).val(); var inr_val = str * quantity_val; $('.inr_value'+i).val(inr_val); var cgst =$('.cgst'+i).val(); var sgst =$('.sgst'+i).val(); var igst =$('.igst'+i).val(); var tax=parseFloat(cgst) + parseFloat(sgst)+ parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function amount_total1() { var a=$(".to_val").val(); /*var tot_vals=[]; $('.tot_val').each(function () { tot_vals.push($(this).val()); }); var sum = 0; for(var i=0; i < tot_vals.length; i++) { sum += parseFloat(tot_vals[i]); }*/ var sum = 0; $('.tot_val').each(function(i,val){ if($(this).val()!=''){ n=$(this).val(); n=parseFloat(n); sum+=n; } }); var inr = 0; $('.inrval').each(function(i,val){ if($(this).val()!=''){ m=$(this).val(); m=parseFloat(m); inr+=m; } }); if(a==0) { var tot_tax = parseFloat(sum) - parseFloat(inr); //$('.total_amt').val(parseFloat(sum).toFixed(2)); $('.total_amt').val(parseFloat(inr).toFixed(2)); $('.total_tax').val(parseFloat(tot_tax).toFixed(2)); $('.g_total').val(parseFloat(sum).toFixed(2)); $('.total').val(parseFloat(sum).toFixed(2)); } else { // var amnt=parseFloat(sum) + parseFloat(a); // $('.total_amt').val(amnt.toFixed(2)); var amnt=parseFloat(inr) + parseFloat(a); var tot_tax = parseFloat(amnt) - parseFloat(inr); $('.total_amt').val(amnt.toFixed(2)); $('.total_tax').val(parseFloat(tot_tax).toFixed(2)); $('.g_total').val(amnt.toFixed(2)); $('.total').val(amnt.toFixed(2)); } } function unitvalue1(str) { var unit=str; var quantity_val =$('#ot_charges_quantity').val(); var inr_val = str * quantity_val; $('.ot_charges_inr_value').val(inr_val); var cgst =$('.ot_charges_cgst').val(); var sgst =$('.ot_charges_sgst').val(); var igst =$('.ot_charges_igst').val(); var tax=parseFloat(cgst) + parseFloat(sgst) + parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } function gstvalue1(str,i) { var gst=str; var inr_val =$('.inr_value'+i).val(); var cgst =$('.cgst'+i).val(); var igst =$('.igst'+i).val(); var sgst =$('.sgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst) + parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function gstvalue2(str,i) { var inr_val =$('.inr_value'+i).val(); var cgst =$('.cgst'+i).val(); var igst =$('.igst'+i).val(); var sgst =$('.sgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function gstvalue3(str,i) { var inr_val =$('.inr_value'+i).val(); var cgst =$('.cgst'+i).val(); var igst =$('.igst'+i).val(); var sgst =$('.sgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function sgstvalue1(str) { var gst=str; var inr_val =$('.ot_charges_inr_value').val(); var cgst =$('.ot_charges_cgst').val(); var igst =$('.ot_charges_igst').val(); var sgst =$('.ot_charges_sgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } function sgstvalue2(str) { var gst=str; var inr_val =$('.ot_charges_inr_value').val(); var sgst =$('.ot_charges_sgst').val(); var igst =$('.ot_charges_igst').val(); var cgst =$('.ot_charges_cgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } function sgstvalue3(str) { var gst=str; var inr_val =$('.ot_charges_inr_value').val(); var sgst =$('.ot_charges_sgst').val(); var igst =$('.ot_charges_igst').val(); var cgst =$('.ot_charges_cgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } /*function quantity_valuefirst(str,i) { var quantity_val=str; var unit = $('.unit_price'+i).val(); var inr_val = str * unit; $('.inr_value'+i).val(inr_val); var cgst =$('.cgst'+i).val(); var sgst =$('.sgst'+i).val(); var igst =$('.igst'+i).val(); var tax=parseFloat(cgst) + parseFloat(sgst)+ parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function unit_valuefirst(str,i) { var unit=str; var quantity_val = $('.quantity'+i).val(); var inr_val = str * quantity_val; $('.inr_value'+i).val(inr_val); var cgst =$('.cgst'+i).val(); var sgst =$('.sgst'+i).val(); var igst =$('.igst'+i).val(); var tax=parseFloat(cgst) + parseFloat(sgst)+ parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function amount_total1() { var a=$(".to_val").val(); var tot_vals=[]; $('.tot_val').each(function () { tot_vals.push($(this).val()); }); var sum = 0; for(var i=0; i < tot_vals.length; i++) { sum += parseFloat(tot_vals[i]); } if(a=="") { $('.total_amt').val(parseFloat(sum).toFixed(2)); $('.g_total').val(parseFloat(sum).toFixed(2)); } else { var amnt=parseFloat(sum) + parseFloat(a); $('.total_amt').val(amnt.toFixed(2)); $('.g_total').val(amnt.toFixed(2)); } } function unitvalue1(str) { var unit=str; var quantity_val =$('#ot_charges_quantity').val(); var inr_val = str * quantity_val; $('.ot_charges_inr_value').val(inr_val); var cgst =$('.ot_charges_cgst').val(); var sgst =$('.ot_charges_sgst').val(); var igst =$('.ot_charges_igst').val(); var tax=parseFloat(cgst) + parseFloat(sgst) + parseFloat(igst); var total_val =(inr_val * tax)/100 ; var total=parseFloat(total_val) + parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } function gstvalue1(str,i) { var gst=str; var inr_val =$('.inr_value'+i).val(); var cgst =$('.cgst'+i).val(); var igst =$('.igst'+i).val(); var sgst =$('.sgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst) + parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function gstvalue2(str,i) { var inr_val =$('.inr_value'+i).val(); var cgst =$('.cgst'+i).val(); var igst =$('.igst'+i).val(); var sgst =$('.sgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function gstvalue3(str,i) { var inr_val =$('.inr_value'+i).val(); var cgst =$('.cgst'+i).val(); var igst =$('.igst'+i).val(); var sgst =$('.sgst'+i).val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.total_value'+i).val(total); amount_total1(); } function sgstvalue1(str) { var gst=str; var inr_val =$('.ot_charges_inr_value').val(); var cgst =$('.ot_charges_cgst').val(); var igst =$('.ot_charges_igst').val(); var sgst =$('.ot_charges_sgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } function sgstvalue2(str) { var gst=str; var inr_val =$('.ot_charges_inr_value').val(); var sgst =$('.ot_charges_sgst').val(); var igst =$('.ot_charges_igst').val(); var cgst =$('.ot_charges_cgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } function sgstvalue3(str) { var gst=str; var inr_val =$('.ot_charges_inr_value').val(); var sgst =$('.ot_charges_sgst').val(); var igst =$('.ot_charges_igst').val(); var cgst =$('.ot_charges_cgst').val(); var total_cgst =(inr_val * cgst)/100 ; var total_sgst =(inr_val * sgst)/100 ; var total_igst =(inr_val * igst)/100 ; var total=parseFloat(total_cgst) + parseFloat(total_sgst) + parseFloat(total_igst)+ parseFloat(inr_val); $('.ot_charges_tot_val').val(total); amount_total1(); } var discount_total_value=0; function discountvalue(str) { var discount=str; var total_amt = $(".total_amt").val(); var mul_val =(discount * total_amt)/100; var discount_total_value = parseFloat(total_amt) - parseFloat(mul_val); //var g_total = Math.round(discount_total_value); $('.g_total').val(discount_total_value.toFixed(2)); } function discountamount(str) { var discount=str; var total_amt = $(".total_amt").val(); var mul_val = total_amt - discount; var discount_total_value = parseFloat(mul_val); $('.g_total').val(discount_total_value.toFixed(2)); }*/ function plus_function() { /* var total_amt = $(".total").val(); var a=Math.ceil(total_amt); var b=parseFloat(a) - parseFloat(total_amt); $(".round_off").val(b.toFixed(2)); $('.g_total').val(a.toFixed(2));*/ $(".round_off").val('+'); } function minus_function() { /* var total_amt = $(".total").val(); var a= Math.floor(total_amt); var b=parseFloat(total_amt) - parseFloat(a); $(".round_off").val(b.toFixed(2)); $('.g_total').val(a.toFixed(2));*/ $(".round_off").val('-'); } function rounded_of() { var total_amt = $(".total").val(); var a= $(".round_off").val(); var b=parseFloat(a) + parseFloat(total_amt); $('.g_total').val(b.toFixed(2)); } </script> <?php $this->load->view('includes/footer.php')?> <style type="text/css"> .page-content-wrapper{ padding-left: 30px; padding-right: 30px; } table { border-collapse: collapse !important; } table, th, td { border: 1px solid black !important; } table input, textarea{ background: #eeeeee !important; } #po_submit{ padding-top: 30px; padding-bottom: 20px; } .po_create_input input,textarea{ background: none !important; } .tab_vendor > thead > tr > th, .tab_vendor > tbody > tr > td { border: 1px solid #367fa9 !important; white-space: nowrap; } </style>