EVOLUTION-NINJA
Edit File: po_edit.php
<!DOCTYPE HTML> <html lang="en-US"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <title>Yaskawa PO Acknowledgemets Import</title> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/main.css');?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/bootstrap.min.css');?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/font-awesome.min.css');?>" /> <link href="https://fonts.googleapis.com/css?family=Roboto" rel="stylesheet"> <script type="text/javascript" src="<?php echo base_url('assets/js/jquery-3.6.0.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/bootstrap.min.js');?>"></script> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc.--> <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.css'); ?>" /> <script src="<?php echo base_url('assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <style type="text/css"> #editmodlist2 { //height: 232px !important; width: 326px !important; } #FrmGrid_list2 { width: 100% !important; } .ui-jqdialog .ui-jqdialog-titlebar { height: 29px !important; background-color:#2A4474 !important; color: white; padding-left: 10px; } .fm-button { height: 21px !important; padding: 1px; margin-right: 10px !important; height: 21px !important; width: 43%; margin-top: -7px !important; } .ui-jqdialog-content td.navButton { padding-top: 12px !important; } .ui-jqgrid .ui-jqgrid-titlebar { height: 27px !important; background-color: #2A4474!important; color:white !important; } .ui-jqgrid-bdiv { height: 232px !important; } .ui-widget-overlay { z-index:0 !important; } .text_color a{ color:white !important; } .my-nav{ width:100% !important; } .my-nav li{ width:100% !important; } .my-nav a:hover{ color:black !important; } .navbar-collapse{ padding-right:0px !important; padding-left:0px !important; } .menu-left{ padding-right:0px !important; } </style> </head> <body> <header class="cf"> <div class="container"> <div class="logo col-sm-4"> <a href="" class="hidden-xs hidden-sm"><img src="<?php echo base_url('assets/img/yaskawa_logo.png');?>" class="img-responsive"></a> <a href="" class="hidden-md hidden-lg"><img src="<?php echo base_url('assets/img/yaskawa_logo2.png');?>" class="img-responsive center-block"></a> </div> <div class="navigation col-sm-8"> <nav> <a href="javascript:void(0)" class="smobitrigger ion-navicon-round"><span>Menu</span></a> <ul class="mobimenu"> <?php if($details->role == 2) { if($details->department == 4) {?> <li class="dropdown"> <a href="" class="dropdown-toggle active" data-toggle="dropdown">Information <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/inventory_import');?>">Stock Updates</a></li> <li><a href="<?php echo site_url('controller/po_import');?>">PO Acknowledgemets</a></li> </ul> </li> <li><a href="<?php echo site_url('controller/insert_po');?>">PO Generate</a></li> <!--<li><a href="<?php echo site_url('controller/news');?>">News</a></li> --> <?php }elseif($details->department == 5) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Financials <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/outstanding_statement');?>">Outstanding Statement</a></li> <li><a href="<?php echo site_url('controller/overdue_statement');?>">Overdue Statement</a></li> <li><a href="<?php echo site_url('controller/c_forms');?>">C forms</a></li> </ul> </li> <!--<li><a href="<?php echo site_url('controller/news');?>" class="active">News</a></li> --> <?php }elseif($details->department == 6) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Technical Support <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/drive_mannual_upload');?>">Drive Catalogues</a></li> <li><a href="<?php echo site_url('controller/case_stories_upload');?>">Case Stories</a></li> </ul> </li> <!--<li><a href="<?php echo site_url('controller/news');?>" class="active">News</a></li>--> <?php }elseif($details->department == 7) {?> <!--<li><a href="<?php echo site_url('controller/news_upload');?>" class="active">News</a></li>--> <?php } } elseif ($details->role == 3) {?> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Information <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/stock_updates');?>">Stock Updates</a></li> <li><a href="<?php echo site_url('controller/po_acknowledgemets');?>">PO Acknowledgemets</a></li> </ul> </li> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Financials <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/outstanding_statements_display');?>">Outstanding Statement</a></li> <li><a href="<?php echo site_url('controller/overdue_statements_display');?>">Overdue Statement</a></li> <li><a href="<?php echo site_url('controller/c_forms_display');?>">C forms</a></li> </ul> </li> <li class="dropdown"> <a href="" class="dropdown-toggle" data-toggle="dropdown">Technical Support <span class="glyphicon glyphicon-chevron-down"></span> </a> <ul class="dropdown-menu multi-column-dropdown"> <li><a href="<?php echo site_url('controller/drive_catalogues');?>">Drive Catalogues</a></li> <li><a href="<?php echo site_url('controller/case_stories');?>">Case Stories</a></li> </ul> </li> <!--<li><a href="<?php echo site_url('controller/news');?>" class="active">News</a></li> --> <?php }?> <ul class="navbar-right"> <li><a href="<?php echo site_url('controller/profile');?>">Profile</a></li> <li><a href="<?php echo site_url('controller/logout');?>">Logout</a></li> </ul> </ul> </nav> </div> </div> </header> <div class="main-container ace-save-state" id="main-container"> <script type="text/javascript"> try{ace.settings.loadState('main-container')}catch(e){} </script> <div class="row"> <div class="col-sm-2 menu-left" style="background-color:#2a4474;height:700px;"> <!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens --> <div class="collapse navbar-collapse navbar-ex1-collapse text_color"> <ul class="nav navbar-nav side-nav my-nav" > <?php if ($details->role == 3) {?> <li class="active" > <a href="<?php echo site_url('controller/add_new_po');?>"> Add New PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/create_po');?>"> Create PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/po_list');?>"> View All PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/upload_signed_po');?>"> Upload Signed PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/signed_po_list');?>"> Signed PO List</a> </li> <?php } else {?> <li class="active" > <a href="<?php echo site_url('controller/add_new_po');?>"> Add New PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/create_po');?>"> Create PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/po_list');?>"> View All PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/add_product');?>"> Insert Product</a> </li> </br> <li> <a href="<?php echo site_url('controller/upload_signed_po');?>"> Upload Signed PO</a> </li> </br> <li> <a href="<?php echo site_url('controller/signed_po_list');?>"> Signed PO List</a> </li> </br> <li> <a href="<?php echo site_url('controller/add_shipaddress');?>"> Add PO Address</a> </li> <?php }?> </ul> </div> <!-- /.navbar-collapse --> </div><!---left side---> <div class="col-sm-10"> <div class="main-content"> <div class="main-content-inner"> <div class="page-content-wrapper"> <form id="formid"> <div class="page-content"> <h3 class="page-title">Generate PO</h3> <table> <tr> <td scope="row" style="width:8%;" >PO #</td> <td style="padding:0;width:15.5%;"> <input type="text" name="po_no" id="po_no" style="width: 100%;border: transparent;" value="<?php echo $po; ?>" > </td> <td style="width:22.3% ;padding:5px;" rowspan="4" > <h4></h4><br/><br/> <input type="text" value="Yaskawa India Private Limited" style="text-transform:uppercase; width: 100%;border: transparent;"/><br/> <input type="text" value="Plot No. 17/A, Electronic City, Phase I," style="text-transform:uppercase; width: 100%;border: transparent;"/> <input type="text" value="Bangalore" style="text-transform:uppercase; width: 100%;border: transparent;"/><br/> <input type="text" value="Karnataka Pincode:560100" style="text-transform:uppercase; width: 100%;border: transparent;"/> </td> <td style="width:50% padding:5px;" rowspan="4" > <h4>Billing To:</h4><br/> <input type="text" id="add1" value="<?php echo $details->company_name;?>" style="width: 100%;border: transparent;"/> <br/> <input type="text" id="add2" value="<?php echo $details->address;?>" style="width: 100%;border: transparent;"/> <input type="text" id="add3" value="<?php echo $details->city;?>" style="width: 100%;border: transparent;"/><br/> <input type="text" id="add4" value="<?php echo $details->state.'-'.$details->pin;?>" style="width: 100%;border: transparent;"/> <input type="hidden" id="add5" value="<?php if($details->gstin != ""){echo $details->gstin;} else {echo "";}?>" style="width: 100%;border: transparent;"/> <input type="hidden" id="add6" value="<?php if($details->state_code != ""){echo $details->state_code;} else {echo "";}?>" style="width: 100%;border: transparent;"/> </td> <td style="width:50% padding:5px;" rowspan="4" > <h4>Shipping To:</h4><br/> <input type="text" id="addr1" value="" style="width: 100%;border: transparent;"/> <br/> <input type="text" id="addr2" value="" style="width: 100%;border: transparent;"/> <input type="text" id="addr3" value="" style="width: 100%;border: transparent;"/><br/> <input type="text" id="addr4" value="" style="width: 100%;border: transparent;"/> <input type="hidden" id="addr5" value="" style="width: 100%;border: transparent;"/> <input type="hidden" id="addr6" value="" style="width: 100%;border: transparent;"/> </td> </tr> <tr> <td scope="row">Location</td> <td style="padding:0;"> <select id="location" name="location" onkeyup="vendor_searchname()" onchange="vendor_myFunction(this.value)" style="width: 100%;border: transparent;"> <option>Select</option> <!--<option value="Bangalore">Bangalore</option> <option value="Mangalore">Mangalore</option>--> <?php foreach ($address as $add){ ?> <option value="<?php echo $add->id;?>" <?php if($add->city == $p_details->shipadd3){echo 'selected';}?>><?php echo $add->city;?></option> <?php } ?> </select> </td> </tr> <tr> <td scope="row">Date</td> <td style="padding:0;"> <input type="text" name="po_date" id="po_date" value="<?php echo date("d-m-Y"); ?>" style="width: 100%;border: transparent;" readonly="readonly"> </td> </tr> <tr> <td scope="row">Currency</td> <td style="padding:0;"> <input type="text" value="INR"name="currency" id="currency" onfocusout="currency_myFunction()" style="width: 100%;border: transparent;" /> <!--<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>--> </td> </tr> </table> <div id="addele_more"> <table id="maintable" style="width:100%; table-layout:fixed; " > <thead class="thead-default"> <tr> <th width="5%">Sl. No.</th> <th width="9%">Product Code</th> <th width="16%">Description</th> <th width="6%">Quantity</th> <th width="6%">Unit</th> <th width="6%" >Unit Price</th> <th width="8%">Trade Discount</th> <th width="6%">Cash Discount</th> <th width="6%">Unit Net Price</th> <th width="6%" class="inr_val" id="inr_val" name="inr_val">Base Price</th> <th width="6%" class="chf_val" id="chf_val" name="chf_val" style="display: none;">CHF Value</th> <th width="6%" style="display: none;" class="eur_val" id="eur_val" name="eur_val">EUR Value</th> <th width="6%" style="display: none;" class="gbp_val" id="gbp_val" name="gbp_val">GBP Value</th> <th width="6%" style="display: none;" class="usd_val" id="usd_val" name="usd_val">USD Value</th> <th width="6%">SGST</th> <th width="6%">CGST</th> <th width="6%">IGST</th> <th width="8%">Total Amount</th> </tr> </thead> <tbody id="tbody"> <?php $i=1; ?> <?php if(isset($confirmed_data)) { foreach($confirmed_data as $key=>$c_data) { ?> <tr> <td width="8%" scope="row"><?php echo $i;?> </td> <td width="8%"><input type="text" style=" width:100%;border: transparent; text-transform: uppercase !important;" class="product_name" name="product_name" id="product_name" value="<?php echo $c_data->item_code;?>" > <input type="hidden" class="hsn" name="hsn" id="hsn" value="<?php echo $c_data->hsn_code;?>"> </td> <td width="8%"><input type="text" style="width:100%; border:transparent; text-transform: uppercase !important;" class="description" name="description" id="description" value="<?php echo $c_data->item_description;?>"></td> <td width="8%"><input type="text" style="width:100%; border:transparent; text-transform: uppercase !important;" class="quantity<?php echo $key; ?> quant" name="quantity" id="quantity" value="" onkeyup="find_alldata(this.value,<?php echo $key; ?>)" /></td> <td width="10%"><input type="text" style="width:100%; border:transparent;" class="unit" name="unit" id="unit" style="border: transparent;" value="NOS" readonly></span></td> <td width="8%" ><input type="text" style="width:100%; border:transparent;" class="unit_price<?php echo $key; ?> price" name="unit_price" id="unit_price" style="border: transparent;" onkeyup="find_data(this.value,<?php echo $key; ?>)"></td> <td width="8%" ><input type="text" style="width:100%; border: transparent;text-transform: uppercase !important;" class="trade<?php echo $key; ?> trades" name="trade" id="trade" onkeyup="find_tradealldata(this.value,<?php echo $key; ?>)" /><span style="margin-left: -39px;" >%</span></td> <td width="8%"style="width: 10%;padding: 1px;"><input type="text" id="cash" class="cash<?php echo $key; ?> cashes" name="cash" style="width: 100%;border: transparent;" onfocusout="find_unit(this.value,<?php echo $key; ?>)" onkeyup="find_cashalldata(this.value,<?php echo $key; ?>)"><span style="margin-left: -39px;">%</span></td> <td width="8%" style="width: 10%;padding: 1px;"><input type="text" id="unit_net" name="unit_net" class="unit_net<?php echo $key; ?> net" style="width: 100%;border: transparent;" onfocusout="find_base(this.value,<?php echo $key; ?>)" readonly ></td> <td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="base<?php echo $key; ?> bases" id="base" name="base" style="width: 100%;border: transparent;" onfocusout="find_total(this.value,<?php echo $key; ?>)" readonly ></td> <td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="sgst<?php echo $key; ?> ssgst" id="sgst" name="sgst" style="width: 75%;border: transparent;" readonly><span>%</span></td> <td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="cgst<?php echo $key; ?> ccgst" id="cgst" name="cgst"style="width: 74%;border: transparent;" readonly><span>%</span></td> <td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="igst<?php echo $key; ?> i_igst" id="igst" name="igst" style="width: 74%;border: transparent;" readonly><span>%</span></td> <td width="8%" style="width: 10%;padding: 1px;"><input type="text" class="total_value<?php echo $key; ?> tt_val" id="total_value" name="total_value" style="width: 100%;border: transparent;" readonly="readonly" ></td> </tr> <?php $i++; } } ?> <tr> <th colspan="11" rowspan="5"> <textarea rows="3" id="note" name="note" style="width: 100%; border: transparent; margin-top: -15px;text-transform: uppercase !important;color:rgb(65,68,65);" placeholder="NOTE : "></textarea> </th> <th colspan="2" style="padding:0;"> Sub Total </th> <th colspan="2" style="padding:0;"> <input type="text" class="total_amt" id="total_amt" name="total_amt" style="width: 100%;border: transparent;color:rgb(65,68,65);" onfocusin="amount_total()" readonly> </th> </tr> <tr> <th colspan="2" style="padding:0;"> Frieght </th> <th colspan="1" style="padding:0;"> <input type="text" class="discount" id="discount" name="discount" onkeyup="discountvalue(this.value)" style="width: 100%;border: transparent;color:rgb(65,68,65);"> </th> </tr> <tr> <th colspan="2" style="padding:0;"> Invoice Total </th> <th colspan="1" style="padding:0;"> <input type="text" class="g_total" id="g_total" name="g_total" style="width: 100%;border: transparent;color:rgb(65,68,65);" readonly> </th> </tr> <tr> <th colspan="2" style="padding:0;"> Amount Paid </th> <th colspan="1" style="padding:0;"> <input type="text" class="paid" id="paid" name="paid" onkeyup="paidvalue(this.value)" style="width: 100%;border: transparent;color:rgb(65,68,65);"> </th> </tr> <tr> <th colspan="2" style="padding:0;"> Balance Due </th> <th colspan="1" style="padding:0;"> <input type="text" class="due" id="due" name="due" style="width: 100%;border: transparent;color:rgb(65,68,65);" readonly="readonly" > </th> </tr> <tr> <td colspan="24" style=""> <label>Terms & Conditions</label><br> <label>1. Material Delivery:</label> <input type="text" class="delivery" id="delivery" name="delivery" style="width: 70%;border: transparent;" ><br> <label>2. Tax:</label> <input type="text" class="tax_total" id="tax_total" name="tax_total" style="width: 70%;border: transparent;" ><br> <label>3. Terms of Payment :</label> <input type="text" class="term" id="term" name="term" style="width: 70%;border: transparent;" ><br> <label>4. Bank Details:</label> <input type="text" class="bank" id="bank" name="bank" style="width: 70%;border: transparent;" > </td> </tr> </tbody> </table> </div> <br/><br/> <button name="submitOrder" id="submitOrder" class="btn center-block" style="float: left;margin-left: 39%;" >Submit</button> <button id="cancel" class="btn center-block" >Cancel</button><br/><br/> <!-----------------------single row-----------------------------------------> </div> <!-- page-content --> </form> </div> </div> </div> </div> </div> </div> <footer > <div class="top-bg"> <div class="container"> <ul class="top_marqu"> <li><a href="tel:+91-9731676611"><i class="fa fa-mobile" aria-hidden="true"></i> : +91 9731676611</a></li> <li><a href="mailto:services@powerpik.in"><i class="fa fa-envelope-o" aria-hidden="true"></i> : services@powerpik.in</a></li> <li><a href=""> | </a></li> <li><a href="tel:+91-9711351351">North <i class="fa fa-mobile" aria-hidden="true"></i> : +91 9711351351</a></li> <li><a href="tel:+91-9620512399">South <i class="fa fa-mobile" aria-hidden="true"></i> : +91 9620512399</a></li> </ul> </div> </div> </footer> </body> </html> <link rel="stylesheet" href="http://code.jquery.com/ui/1.11.0/themes/smoothness/jquery-ui.css"> <script src="assets/js/jquery-ui.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.css'); ?>" /> <style type="text/css"> body{ overflow-x:hidden; } .thead-default{ background:#337ab7; color:white; } .table{ margin-bottom:0 !important; //width:auto !important; } th, td{ border:1px solid gray; padding:6px; } .inner th{ border:transparent !important; } .inner tr{ border-bottom:1px solid gray; } table{ width:100%; } #ui-id-1 { display: none; width: 350px; top: 258px; overflow-x: hidden !important; overflow-y: scroll !important; height: 203px !important; } .file { position: relative; height: 35px; width: 100px;float:right; } .file > input[type="file"] { position: absoulte; opacity: 0; top: 0; left: 0; right: 0; bottom: 0 } .file > label { position: absolute; top: 0; right: 0; left: 0; bottom: 0; background-color: #337AB7; color: #fff; line-height: 30px; text-align: center; cursor: pointer; } </style> <!---------- Navigation -----------------------> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" type="text/css" href="http://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css"> <link rel="stylesheet" type="text/css" href="<?php echo base_url('assets/css/simpleMobileMenu.css');?>" /> <script src="<?php echo base_url('assets/js/simpleMobileMenu.js');?>"></script> <script type="text/javascript"> jQuery(document).ready(function($) { $('.smobitrigger').smplmnu(); }); </script> <!---------------- Menu Drodown ---------------------> <script type="text/javascript"> function amount_total() { //alert('sub_total'); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); tot +=parseFloat(tots); //alert(tot); }); $('.total_amt').val(tot.toFixed(2)); } jQuery(document).ready(function($) { $('.mobimenu li.dropdown').hover(function() { $(this).find('.dropdown-menu').stop(true, true).delay(200).fadeIn(500); }, function() { $(this).find('.dropdown-menu').stop(true, true).delay(200).fadeOut(500); }); }); function find_unit(str,i) { //alert(); var unit=$(".unit_price"+i).val(); var trade=$(".trade"+i).val(); if (trade !="") { var trades=$(".trade"+i).val(); } else { var trades=0; } var cash=$(".cash"+i).val(); if (cash !="") { var cashs=$(".cash"+i).val(); } else { var cashs=0; } var tax=(unit * parseFloat(trades))/100; var tax1=(unit * parseFloat(cashs))/100; var sub=parseFloat(unit)-parseFloat(tax); var sub1=parseFloat(sub)-parseFloat(tax1); var total=parseFloat(sub) + parseFloat(sub1); //alert(unit); $('.unit_net'+i).val(parseFloat(sub1)); } function find_base(str,i) { var net=$('.unit_net'+i).val(); var quant=$('.quantity'+i).val(); var base=parseFloat(net) * quant; $('.base'+i).val(base); } function find_total(str,i) { var sgst=$('.sgst'+i).val(); var cgst=$('.cgst'+i).val(); var igst=$('.igst'+i).val(); var base=$('.base'+i).val(); var tax=(base * parseFloat(sgst))/100; var tax1=(base * parseFloat(cgst))/100; var tax2=(base * parseFloat(igst))/100; var sub= parseFloat(tax1)+parseFloat(tax)+parseFloat(tax2); //alert(sub); var sub1=parseFloat(sub)+parseFloat(base); //var total=parseFloat(sub) + parseFloat(sub1); //alert(unit); $('.total_value'+i).val(sub1); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); tot +=parseFloat(tots); //alert(tot); }); $('.total_amt').val(tot.toFixed(2)); } function discountvalue(str) { var tot=$('.total_amt').val(); if(str !="") { var total=parseFloat(tot) + parseFloat(str); $('.g_total').val(total.toFixed(2)); $('.paid').val(0); } else { var total=parseFloat(tot); $('.g_total').val(total.toFixed(2)); $('.paid').val(0); } } function paidvalue(str) { //alert(); var invoice_val=$('.g_total').val(); if(str !="") { var due_total=parseFloat(invoice_val) - parseFloat(str); $('.due').val(due_total.toFixed(2)); } else { var due_total=parseFloat(invoice_val); $('.due').val(due_total.toFixed(2)); } } function find_data(str,i) { var quant=$('.quantity'+i).val(); var base=parseFloat(str) * quant; $('.base'+i).val(base); var unit=$(".unit_price"+i).val(); var trade=$(".trade"+i).val(); if (trade !="") { var trades=$(".trade"+i).val(); } else { var trades=0; } var cash=$(".cash"+i).val(); if (cash !="") { var cashs=$(".cash"+i).val(); } else { var cashs=0; } var tax=(unit * parseFloat(trades))/100; var tax1=(unit * parseFloat(cashs))/100; var subs=parseFloat(unit)-parseFloat(tax); var subs1=parseFloat(subs)-parseFloat(tax1); var taxs=(base * parseFloat(trades))/100; var taxs1=(base * parseFloat(cashs))/100; var base_total=parseFloat(base) - parseFloat(taxs); var base_total1=parseFloat(base_total) - parseFloat(taxs1); $('.base'+i).val(parseFloat(base_total1)); $('.unit_net'+i).val(parseFloat(subs1)); var sgst=$('.sgst'+i).val(); var cgst=$('.cgst'+i).val(); var igst=$('.igst'+i).val(); var ta=(base_total1 * parseFloat(sgst))/100; var ta1=(base_total1 * parseFloat(cgst))/100; var ta2=(base_total1 * parseFloat(igst))/100; var sub= parseFloat(ta1)+parseFloat(ta) + parseFloat(ta2); var sub1=parseFloat(sub)+parseFloat(base_total1); //var total=parseFloat(sub) + parseFloat(sub1); //alert(sub); $('.total_value'+i).val(sub1); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); tot +=parseFloat(tots); }); $('.total_amt').val(tot.toFixed(2)); $('.g_total').val(tot.toFixed(2)); $('.paid').val(0); $('.due').val(tot.toFixed(2)); } function find_alldata(str,i) { //$('.unit_price'+i).val(str); var quant=$('.unit_price'+i).val(); var base=parseFloat(str) * quant; $('.base'+i).val(base); var unit=$(".unit_price"+i).val(); var trade=$(".trade"+i).val(); if (trade !="") { var trades=$(".trade"+i).val(); } else { var trades=0; } var cash=$(".cash"+i).val(); if (cash !="") { var cashs=$(".cash"+i).val(); } else { var cashs=0; } var tax=(unit * parseFloat(trades))/100; var tax1=(unit * parseFloat(cashs))/100; var subs=parseFloat(unit)-parseFloat(tax); var subs1=parseFloat(subs)-parseFloat(tax1); var taxs=(base * parseFloat(trades))/100; var taxs1=(base * parseFloat(cashs))/100; var base_total=parseFloat(base) - parseFloat(taxs); var base_total1=parseFloat(base_total) - parseFloat(taxs1); $('.base'+i).val(parseFloat(base_total1)); $('.unit_net'+i).val(parseFloat(subs1)); var sgst=$('.sgst'+i).val(); var cgst=$('.cgst'+i).val(); var igst=$('.igst'+i).val(); var tax=(base_total1 * parseFloat(sgst))/100; var tax1=(base_total1 * parseFloat(cgst))/100; var tax2=(base_total1 * parseFloat(igst))/100; var sub= parseFloat(tax1)+parseFloat(tax)+parseFloat(tax2); var sub1=parseFloat(sub)+parseFloat(base_total1); //var total=parseFloat(sub) + parseFloat(sub1); //alert(unit); $('.total_value'+i).val(sub1); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); tot +=parseFloat(tots); }); $('.total_amt').val(tot.toFixed(2)); $('.g_total').val(tot.toFixed(2)); $('.paid').val(0); $('.due').val(tot.toFixed(2)); } function find_tradealldata(str,i) { var unit=$(".unit_price"+i).val(); //var trade=$(".trade"+i).val(); if (str !="") { var trades=str; } else { var trades=0; } var cash=$(".cash"+i).val(); if (cash !="") { var cashs=$(".cash"+i).val(); } else { var cashs=0; } var tax=(unit * parseFloat(trades))/100; var tax1=(unit * parseFloat(cashs))/100; var subs=parseFloat(unit)-parseFloat(tax); var subs1=parseFloat(subs)-parseFloat(tax1); $('.unit_net'+i).val(parseFloat(subs1)); var quant=$('.quantity'+i).val(); var base=parseFloat(subs1) * quant; var taxs=(base * parseFloat(trades))/100; var taxs1=(base * parseFloat(cashs))/100; var base_total=parseFloat(base) - parseFloat(taxs); var base_total1=parseFloat(base_total) - parseFloat(taxs1); $('.base'+i).val(parseFloat(base)); var sgst=$('.sgst'+i).val(); var cgst=$('.cgst'+i).val(); var igst=$('.igst'+i).val(); var tax=(base * parseFloat(sgst))/100; var tax1=(base * parseFloat(cgst))/100; var tax2=(base * parseFloat(igst))/100; var sub= parseFloat(tax1)+parseFloat(tax)+parseFloat(tax2); var sub1=parseFloat(sub)+parseFloat(base); //var total=parseFloat(sub) + parseFloat(sub1); //alert(unit); $('.total_value'+i).val(sub1); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); tot +=parseFloat(tots); }); $('.total_amt').val(tot.toFixed(2)); $('.g_total').val(tot.toFixed(2)); $('.paid').val(0); $('.due').val(tot.toFixed(2)); } function find_cashalldata(str,i) { var unit=$(".unit_price"+i).val(); var trade=$(".trade"+i).val(); if (trade !="") { var trades=$(".trade"+i).val(); } else { var trades=0; } //var cash=$(".cash"+i).val(); if (str !="") { var cashs=str; } else { var cashs=0; } var tax=(unit * parseFloat(trades))/100; var tax1=(unit * parseFloat(cashs))/100; var subs=parseFloat(unit)-parseFloat(tax); var subs1=parseFloat(subs)-parseFloat(tax1); $('.unit_net'+i).val(parseFloat(subs1)); var quant=$('.quantity'+i).val(); var base=parseFloat(subs1) * quant; var taxs=(base * parseFloat(trades))/100; var taxs1=(base * parseFloat(cashs))/100; var base_total=parseFloat(base) - parseFloat(taxs); var base_total1=parseFloat(base_total) - parseFloat(taxs1); $('.base'+i).val(parseFloat(base)); var sgst=$('.sgst'+i).val(); var cgst=$('.cgst'+i).val(); var igst=$('.igst'+i).val(); var tax=(base * parseFloat(sgst))/100; var tax1=(base * parseFloat(cgst))/100; var tax2=(base * parseFloat(igst))/100; var sub= parseFloat(tax1)+parseFloat(tax)+parseFloat(tax2); var sub1=parseFloat(sub)+parseFloat(base); //var total=parseFloat(sub) + parseFloat(sub1); //alert(unit); $('.total_value'+i).val(sub1); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); tot +=parseFloat(tots); }); $('.total_amt').val(tot.toFixed(2)); $('.g_total').val(tot.toFixed(2)); $('.paid').val(0); $('.due').val(tot.toFixed(2)); } </script> <script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script> <link href="<?php echo base_url(); ?>assets/css/sweetalert.css" rel="stylesheet" type="text/css" > <script type="text/javascript"> select =[]; selecthsn =[]; quentity=[]; q=[]; unit =[]; foreign=[]; delivery_date=[]; sku=[]; t_val=[]; ind_id=[]; approved_by=[]; approved_date=[]; ind_unit=[]; purpose=[]; width=[]; shades=[]; type=[]; cgst=[]; igst_t=[]; sgst=[]; desc=[]; product_id=[]; $("#submitOrder").click(function(e) { e.preventDefault(); //alert('Hai'); var po_id =$('#po_id').val(); var po_no =$('#po_no').val(); var location =$('#location').val(); var po_date =$('#po_date').val(); // var bill_address =$('#bill_address').val(); // var ship_address =$('#ship_address').val(); var currency =$('#currency').val(); var delivery =$('#delivery').val(); var tax_total =$('#tax_total').val(); var term =$('#term').val(); var bank =$('#bank').val(); var sub_tot =$('#total_amt').val(); var frieght =$('#discount').val(); var invoice =$('#g_total').val(); var paid =$('#paid').val(); var due =$('#due').val(); var note =$('#note').val(); var add1=$('#add1').val(); var add2=$('#add2').val(); var add3=$('#add3').val(); var add4=$('#add4').val(); var add5=$('#add5').val(); var add6=$('#add6').val(); var addr1=$('#addr1').val(); var addr2=$('#addr2').val(); var addr3=$('#addr3').val(); var addr4=$('#addr4').val(); var addr5=$('#addr5').val(); var addr6=$('#addr6').val(); $('.product_name').each(function () { select.push($(this).val()); }); $('.hsn').each(function () { selecthsn.push($(this).val()); }); //console.log(select); $('.description').each(function () { quentity.push($(this).val()); }); $('.quant').each(function () { q.push($(this).val()); }); $('.unit').each(function () { unit.push($(this).val()); }); $('.price').each(function () { purpose.push($(this).val()); }); $('.trades').each(function () { foreign.push($(this).val()); }); $('.cashes').each(function () { ind_unit.push($(this).val()); }); $('.net').each(function () { delivery_date.push($(this).val()); }); $('.bases').each(function () { ind_id.push($(this).val()); }); $('.ssgst').each(function () { approved_by.push($(this).val()); }); $('.ccgst').each(function () { approved_date.push($(this).val()); }); $('.i_igst').each(function () { width.push($(this).val()); }); $('.tt_val').each(function () { t_val.push($(this).val()); }); if(selecthsn != '' && po_no != '' && location != 'Select' && po_date != '' && currency != '' && sub_tot != '' && invoice != '' && due != '' && select != '' && quentity != '' && unit != '' && q != '' ) { $.ajax({ url:"<?php echo base_url('controller/insert_po_multi_data');?>", type:"POST", data:{'hsn':selecthsn,'po_no':po_no,'location':location,'po_date':po_date,'currency':currency,'delivery':delivery,'taxes':tax_total,'term':term,'bank':bank,'sub_tot':sub_tot,'frieght':frieght,'invoice':invoice,'paid':paid,'due':due,'note':note,'product':select,'description':quentity,'quant':q,'unit':unit,'price':purpose,'trade':foreign,'cash':ind_unit,'net':delivery_date,'base':ind_id,'sgst':approved_by,'cgst':approved_date,'igst':width,'tot_value':t_val,'add1':add1,'add2':add2,'add3':add3,'add4':add4,'add5':add5,'add6':add6,'addr1':addr1,'addr2':addr2,'addr3':addr3,'addr4':addr4,'addr5':addr5,'addr6':addr6}, async:false, success:function(data) { //alert(); // var objData = jQuery.parseJSON(data); // obj=objData; //alert(obj); window.location.href = '<?php echo site_url('controller/purchase_order');?>'; } }); } else { swal({ title: "Please Fill The Fields", text: "", }); } }); function vendor_myFunction(str) { $.ajax({ url:"<?php echo base_url('controller/address_details');?>", type:"POST", data:{'id':str }, async:false, success:function(data) { //alert(); var objData = jQuery.parseJSON(data); // obj=objData; //alert(objData.state_code); $("#addr1").val(objData.name); $("#addr2").val(objData.street); $("#addr3").val(objData.city); $("#addr4").val(objData.state+'-'+objData.pincode); $("#addr5").val(objData.gstin); $("#addr6").val(objData.state_gst); var a=$('.product_name').length; //alert(a); for(i=0; i<=a; i++){ if(objData.state == "Karnataka") { $(".sgst"+i).val(14); $(".cgst"+i).val(14); $(".igst"+i).val(0); } else { $(".sgst"+i).val(0); $(".cgst"+i).val(0); $(".igst"+i).val(28); } } } }); } $("#cancel").click(function(e) { e.preventDefault(); window.location.href = '<?php echo base_url('controller/create_po');?>'; }); $('#formid').on('keyup keypress', function(e) { var keyCode = e.keyCode || e.which; if (keyCode === 13) { e.preventDefault(); return false; } }); $(document).ready(function() { $('input:text:first').focus(); $('input:text').bind("keydown", function(e) { var n = $("input:text").length; if (e.which == 13) { //Enter key e.preventDefault(); //Skip default behavior of the enter key var nextIndex = $('input:text').index(this) + 1; if(nextIndex < n) $('input:text')[nextIndex].focus(); else { $('input:text')[nextIndex-1].blur(); // $('#submitOrder').click(); } } }); }); </script>