EVOLUTION-NINJA
Edit File: po_generate.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-2.2.4.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" onfocusout="po_searchname(this.value)" style="width: 100%;border: transparent;" value="<?php echo $sl_no; ?>" required> </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> <?php if ($details->role == 3) { ?> <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(!empty($details->gstin)){ echo $details->gstin;} else {echo "";}?>" style="width: 100%;border: transparent;"/> <input type="hidden" id="add6" value="<?php if(!empty($details->state_code)){ echo $details->state_code;} else {echo "";}?>" style="width: 100%;border: transparent;"/> </td> <?php } ?> <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;" required="required"> <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 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> <tr> <td scope="row">Region</td> <td style="padding:0;"> <select id="region" name="region" required="required" style="width: 100%;border: transparent;"> <option>Select</option> <?php foreach ($region as $reg){ ?> <option value="<?php echo $reg->id;?>"><?php echo $reg->region;?></option> <?php } ?> </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="15%">Description</th> <th width="6%">Quantity</th> <th width="6%">Unit</th> <th width="9%">Delivery Date</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" pattern="[0-9]+" 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; ?>)" required="required"/></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="10%"><input type="text" style="width:100%; border:transparent;" class="delivery_date booking_calendar<?php echo $key; ?>" name="delivery_date" id="delivery_date<?php echo $key; ?>" value="" style="border: transparent;" onmouseover="find_date(this.value,<?php echo $key; ?>)" required="required"></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" pattern="[0-9]+" style="border: transparent;" onfocusout="find_data(this.value,<?php echo $key; ?>)" required="required"></td> <td width="8%" ><input type="text" style="width:100%; border: transparent;text-transform: uppercase !important;" class="trade<?php echo $key; ?> trades" pattern="[0-9]+" name="trade" id="trade" onfocusout="find_tradealldata(this.value,<?php echo $key; ?>)" required="required"/><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;" pattern="[0-9]+" 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;" onfocusout="total_val(this.value,<?php echo $key; ?>);" readonly="readonly" ></td> </tr> <?php $i++; } } ?> <tr> <th colspan="12" rowspan="5"> <textarea id="note" name="note" rows="3" style="width: 100%; border: transparent; margin-top: -15px;text-transform: uppercase !important;color:rgb(65,68,65);" placeholder="not applicable"><?php echo "NOTE: ";?></textarea> <textarea id="hidden_note" name="note" rows="3" style="width: 100%; border: transparent; margin-top: -15px;text-transform: uppercase !important;color:rgb(65,68,65);" placeholder="not applicable" class="note_show<?php echo $key; ?> notes_show" onclick="note_show(this.value,<?php echo $key; ?>);" ></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);" required> </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);" required> </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;" placeholder="Not Applicable" ><br> <label>2. Tax:</label> <input type="text" class="tax_total" id="tax_total" name="tax_total" style="width: 70%;border: transparent;" placeholder="Not Applicable"><br> <label>3. Terms of Payment :</label> <input type="text" class="term" id="term" name="term" style="width: 70%;border: transparent;" placeholder="Not Applicable" ><br> <label>4. Bank Details:</label> <input type="text" class="bank" id="bank" name="bank" style="width: 70%;border: transparent;" placeholder="Not Applicable" > </td> </tr> </tbody> </table> </div> <br/><br/> <button name="submitOrder" id="submitOrder" class="btn center-block submitOrder" style="float: left;margin-left: 39%;" >Submit</button> <button id="cancel" class="btn center-block" style="margin-right: 477px;" >Cancel</button><br/><br/> <!-----------------------single row-----------------------------------------> </div> <!-- page-content --> <input type="hidden" style="width:100%; border:transparent;" class="delivery_date" value="" /> <input type="hidden" class="po_type" id="po_type" name="po_type" style="width: 70%;border: transparent;" value="normal"> </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@yaskawa.in"><i class="fa fa-envelope-o" aria-hidden="true"></i> : services@yaskawa.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 numberWithCommas(number) { var parts = number.toString().split("."); parts[0] = parts[0].replace(/\B(?=(\d{3})+(?!\d))/g, ","); return parts.join("."); } var note = $('#note').val(); if(note == "NOTE: ") { $('#hidden_note').show(); $('#note').hide(); } function note_show(str,i) { $('#hidden_note').hide(); $('#note').show(); } 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_data(str,i) { var unit_price = str; var a=unit_price.replace(/\,/g,''); var b =Number(a); var quant=$('.quantity'+i).val(); var base=parseFloat(b) * quant; var comma_base = numberWithCommas(base); $('.unit_net'+i).val(comma_base); $('.base'+i).val(comma_base); $('.total_value'+i).val(comma_base); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); var a=tots.replace(/\,/g,''); var b =Number(a); tot +=parseFloat(b); }); var comma_tot = numberWithCommas(tot.toFixed(2)); $('.total_amt').val(comma_tot); $('.g_total').val(comma_tot); $('.paid').val(0); $('.due').val(comma_tot); var trade=$(".trade"+i).val(); var a_trade=trade.replace(/\,/g,''); var b_trade =Number(a_trade); if (trade !="") { var trades=b_trade; } else { var trades=0; } var cash=$(".cash"+i).val(); var a_cash=cash.replace(/\,/g,''); var b_cash =Number(a_cash); if (cash !="") { var cashs=b_cash; } else { var cashs=0; } 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); var abc = parseFloat(base_total1); var comma_base1 = numberWithCommas(abc.toFixed(2)); $('.base'+i).val(comma_base1); var sgst=$('.sgst'+i).val(); if(sgst == "") { sgst = 0; } else { sgst=$('.sgst'+i).val(); } var cgst=$('.cgst'+i).val(); if(cgst == "") { cgst = 0; } else { cgst=$('.cgst'+i).val(); } var igst=$('.igst'+i).val(); if(igst == "") { igst = 0; } else { 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 commaNum = numberWithCommas(sub1); $('.total_value'+i).val(commaNum); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); var a=tots.replace(/\,/g,''); var b =Number(a); tot +=parseFloat(b); }); var commaTot = numberWithCommas(tot.toFixed(2)); $('.total_amt').val(commaTot); $('.g_total').val(commaTot); $('.paid').val(0); $('.due').val(commaTot); } function find_tradealldata(str,i) { var unit=$(".unit_price"+i).val(); var unit1 = unit; var a=unit1.replace(/\,/g,''); var b =Number(a); var str1 = str; var str_a=str1.replace(/\,/g,''); var str_b =Number(str_a); if (str_b !="") { var trades=str_b; } else { var trades=0; } var cash=$(".cash"+i).val(); var cash1=cash.replace(/\,/g,''); var cash2 =Number(cash1); if (cash2 != "") { var cashs=cash2; } else { var cashs=0; } var subs=parseFloat(b)-parseFloat(trades); var subs1=parseFloat(subs)-parseFloat(cashs); var commaSub = numberWithCommas(subs1); $('.unit_net'+i).val(commaSub); 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); var abc = parseFloat(base); var commaBase = numberWithCommas(abc); $('.base'+i).val(commaBase); var sgst=$('.sgst'+i).val(); if(sgst == "") { sgst = 0; } else { sgst=$('.sgst'+i).val(); } var cgst=$('.cgst'+i).val(); if(cgst == "") { cgst = 0; } else { cgst=$('.cgst'+i).val(); } var igst=$('.igst'+i).val(); if(igst == "") { igst = 0; } else { 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(); var a=tots.replace(/\,/g,''); var b =Number(a); tot +=parseFloat(b); }); var commaTot1 = numberWithCommas(tot.toFixed(2)); $('.total_amt').val(commaTot1); $('.g_total').val(commaTot1); $('.paid').val(0); $('.due').val(commaTot1); } function find_cashalldata(str,i) { var unit=$(".unit_price"+i).val(); var unit2 = unit; var unit_a=unit2.replace(/\,/g,''); var unit_b =Number(unit_a); var trade=$(".trade"+i).val(); var trade1 = trade; var trade2=trade1.replace(/\,/g,''); var trade3 =Number(trade2); if (trade3 !="") { var trades=trade3; } else { var trades=0; } var str_cash1 = str; var str_a1=str_cash1.replace(/\,/g,''); var str_b1 =Number(str_a1); if (str_b1 !="") { var cashs=str_b1; } else { var cashs=0; } var subs=parseFloat(unit_b)-parseFloat(trades); var subs1=parseFloat(subs)-parseFloat(cashs); var commaNum = numberWithCommas(subs1); $('.unit_net'+i).val(commaNum); var quant=$('.quantity'+i).val(); var base=parseFloat(subs1) * quant; var commabase = numberWithCommas(base); // var taxs=(base * parseFloat(trades))/100; // var taxs1=(base * parseFloat(cashs))/100; var base_total=parseFloat(base) - parseFloat(trades); var base_total1=parseFloat(base_total) - parseFloat(cashs); $('.base'+i).val(commabase); var sgst=$('.sgst'+i).val(); if(sgst == "") { sgst = 0; } else { sgst=$('.sgst'+i).val(); } var cgst=$('.cgst'+i).val(); if(cgst == "") { cgst = 0; } else { cgst=$('.cgst'+i).val(); } var igst=$('.igst'+i).val(); if(igst == "") { igst = 0; } else { 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 commaNum = numberWithCommas(sub1); //var total=parseFloat(sub) + parseFloat(sub1); //alert(unit); $('.total_value'+i).val(commaNum); var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); var a=tots.replace(/\,/g,''); var b =Number(a); tot +=parseFloat(b); }); var commaTots = numberWithCommas(tot.toFixed(2)); $('.total_amt').val(commaTots); $('.g_total').val(commaTots); $('.paid').val(0); $('.due').val(commaTots); } function amount_total() { var tot=0; $('.tt_val').each(function () { var tots=$(this).val(); var a=tots.replace(/\,/g,''); var b =Number(a); tot +=parseFloat(b); }); var commaTotal = numberWithCommas(tot.toFixed(2)); $('.total_amt').val(commaTotal); } function discountvalue(str) { var tot=$('.total_amt').val(); var a=tot.replace(/\,/g,''); var b =Number(a); var str_dis = str; var str_d=str_dis.replace(/\,/g,''); var str_d1 =Number(str_d); if(str_d1 !="") { var total=parseFloat(b) + parseFloat(str_d1); var commaNum = numberWithCommas(total.toFixed(2)); $('.g_total').val(commaNum); $('.due').val(commaNum); $('.paid').val(0); } else { var total=parseFloat(b); var commaNum = numberWithCommas(total.toFixed(2)); $('.g_total').val(commaNum); $('.due').val(commaNum); $('.paid').val(0); } } function paidvalue(str) { var invoice_val=$('.g_total').val(); var a=invoice_val.replace(/\,/g,''); var b =Number(a); var str_paid = str; var str_p=str_paid.replace(/\,/g,''); var str_p1 =Number(str_p); if(str !="") { var due_total=parseFloat(b) - parseFloat(str_p1); var commaNum = numberWithCommas(due_total.toFixed(2)); var due_amt = $('.due').val(commaNum); } else { var due_total=parseFloat(b); var commaNum = numberWithCommas(due_total.toFixed(2)); var due_amt = $('.due').val(commaNum); } } </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=[]; deliverydate=[]; $("#submitOrder").click(function(e) { e.preventDefault(); $("#submitOrder").attr('disabled', 'disabled'); $("#submitOrder").text("Submitting..."); //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 po_type =$('#po_type').val(); var region =$('#region').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()); }); $('.delivery_date').each(function () { deliverydate.push($(this).val()); }); if(selecthsn != '' && po_no != '' && location != 'Select' && region != '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,'delivery_date':deliverydate,'po_type':po_type,'region':region}, async:false, success:function(data) { $("#submitOrder").text("Submit"); $("#submitOrder").removeAttr('disabled'); window.location.href = '<?php echo site_url('controller/purchase_order');?>'; } }); } else { swal({ title: "Please Fill The Fields", text: "", }); } }); function po_searchname(str) { // alert(str); $.ajax({ url:"<?php echo base_url('controller/po_number_validation');?>", type:"POST", data:{'id':str }, async:false, success:function(data) { var objData = jQuery.parseJSON(data); //alert(objData.result); if(objData.result==1) { setTimeout(function() { swal({ title: objData.message, text: "", }, function() { location.reload(); }); }, 1000); //location.reload(); } else { swal({ title: objData.message, 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(9); $(".cgst"+i).val(9); $(".igst"+i).val(0); } else { $(".sgst"+i).val(0); $(".cgst"+i).val(0); $(".igst"+i).val(18); } } } }); } $("#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(); } } }); }); function find_date(str,i){ // alert(i); $('.booking_calendar'+i).val(); $('.booking_calendar'+i).datepicker({ changeMonth:true, changeYear:true, yearRange: "2000:c", dateFormat: 'dd-mm-yy' }); var date= $('#delivery_date'+i).val(); $(this).val(date); // $( ".datepicker").datepicker({ dateFormat: "yy-mm-dd" }); } </script> <script type="text/javascript"> $('input.price').keyup(function(event) { // skip for arrow keys if(event.which >= 37 && event.which <= 40) return; // format number $(this).val(function(index, value) { return value .replace(/\D/g, "") .replace(/\B(?=(\d{3})+(?!\d))/g, ",") ; }); }); $('input.trades').keyup(function(event) { // skip for arrow keys if(event.which >= 37 && event.which <= 40) return; // format number $(this).val(function(index, value) { return value .replace(/\D/g, "") .replace(/\B(?=(\d{3})+(?!\d))/g, ",") ; }); }); $('input.cashes').keyup(function(event) { // skip for arrow keys if(event.which >= 37 && event.which <= 40) return; // format number $(this).val(function(index, value) { return value .replace(/\D/g, "") .replace(/\B(?=(\d{3})+(?!\d))/g, ",") ; }); }); $('input.discount').keyup(function(event) { // skip for arrow keys if(event.which >= 37 && event.which <= 40) return; // format number $(this).val(function(index, value) { return value .replace(/\D/g, "") .replace(/\B(?=(\d{3})+(?!\d))/g, ",") ; }); }); $('input.paid').keyup(function(event) { // skip for arrow keys if(event.which >= 37 && event.which <= 40) return; // format number $(this).val(function(index, value) { return value .replace(/\D/g, "") .replace(/\B(?=(\d{3})+(?!\d))/g, ",") ; }); }); </script>