1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : create-purchase-order.php
back
<?php
   ob_start();
   session_start();
   include 'config.php';
   
   $login = $_SESSION['login_email'];
   if ($login == '')
   {
       echo '<script>location.replace("index.php")</script>';
   }
   
   if (isset($_SESSION["source_id"]))
   {
       $source_id = $_SESSION['source_id'];
   }
   
   $item = "";
   $sqlitem = "SELECT * FROM inventory WHERE data_delete = 'no' and source_id = '$source_id'";
   $resultitem = mysqli_query($conn, $sqlitem);
   if ($resultitem)
   {
       if (mysqli_num_rows($resultitem) > 0)
       {
           while ($rowitem = mysqli_fetch_assoc($resultitem))
           {
               $item .= "<option value='" . $rowitem['id'] . "'>" . $rowitem['name'] . "</option> ";
           }
       }
   }
   
   $id = strip_tags($_GET['id']);
   
   $sql = " SELECT * FROM proforma where id = '$id' and data_delete = 'NO'";
   $result = mysqli_query($conn, $sql);
   $row = mysqli_fetch_array($result);
   
   $bill_pay_name = $row['bill_pay_name'];
   $proforma_id = $row['proforma_id'];
   $date = $row['date'];
   $terms = $row['terms'];
   $due_date = $row['due_date'];
   $deliver_address = $row['deliver_address'];
   $pincode = $row['pincode'];
   $client_name = $row['client_name'];
   $mobile_no = $row['mobile_no'];
   $email = $row['email'];
   $gstin = $row['gstin'];
   $type = $row['type'];
   $buyer_reference = $row['buyer_reference'];
   $delivery_type = $row['delivery_type'];
   $delivery_terms = $row['delivery_terms'];
   $mode_of_shipment = $row['mode_of_shipment'];
   $shipping_date = $row['shipping_date'];
   $port_of_loading = $row['port_of_loading'];
   $port_of_delivery = $row['port_of_delivery'];
   $payment_method_g = $row['payment_method'];
   $hs_code = $row['hs_code'];
   $terms_of_payment = $row['terms_of_payment'];
   $bank_details = $row['bank_details'];
   
   $other_charges = $row['other_charges'];
   $other_charge_msg = $row['other_charge_msg'];
   $comment = $row['comment'];
   $other_price = $row['other_price'];
   $subtotal_price = $row['subtotal_price'];
   
   $amount_paid = $row['amount_paid'];
   $bank_charge = $row['bank_charge'];


   
?>
<!DOCTYPE html>
<html>
   <head>
      <meta charset="utf-8" />
      <title> Create Purchase Order | Purchase Order</title>
      <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
      <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
      <meta content="Coderthemes" name="author" />
      <meta http-equiv="X-UA-Compatible" content="IE=edge" />
      <!-- Font Awsome -->
      <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
      <!-- App favicon -->
      <link rel="shortcut icon" href="assets/images/favicon.png">
      <!-- Pie Chart Css -->
      <!--<link href="assets/pie charts/style.css" rel="stylesheet" type="text/css" />-->
      <!-- App css -->
      <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/style.css" rel="stylesheet" type="text/css" />
      <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/css/select2.min.css'>
      <link href="https://code.jquery.com/ui/1.10.4/themes/ui-lightness/jquery-ui.css" rel="stylesheet">
   </head>
   <body>
      <!-- Begin page -->
      <div id="wrapper">
         <!-- Top Bar Start -->
         <?php include 'top-header.php'; ?>
         <!-- Top Bar End -->
         <!-- ========== Left Sidebar Start ========== -->
         <?php include 'left-sidebar.php'; ?>
         <!-- Left Sidebar End -->
         <!-- ============================================================== -->
         <!-- Start right Content here -->
         <!-- ============================================================== -->
         <div class="content-page">
            <!-- Start content -->
            <div class="content">
               <div class="container-fluid">
                  <div class="row">
                     <div class="col-12">
                        <div class="page-title-box">
                           <h4 class="page-title float-left">Create Purchase Order</h4>
                           <ol class="breadcrumb float-right">
                              <li class="breadcrumb-item ">Sales</li>
                              <li class="breadcrumb-item active">Create Purchase Order</li>
                           </ol>
                           <div class="clearfix"></div>
                        </div>
                     </div>
                  </div>
                  <!-- end row -->
                  <form action="insert-purchase-order.php" method="post" class="form-horizontal" role="form">
                     <div class="card-box">
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="col-form-label">Manufacturer</label>
                                 <select class="form-control select" name="manufacturer" required>
                                    <option value=''>--Select Manufacturer--</option>
                                    <?php
                                       $sql = "SELECT * FROM manufacturer where trim(data_delete) != 'yes'";
                                       $result = mysqli_query($conn, $sql);
                                       while ($row = mysqli_fetch_array($result))
                                       {
                                           $company_name = $row['manufacturer'];
                                       
                                       ?>
                                    <option value="<?php echo $row['id'] ?>"><?php echo $company_name ?></option>
                                    <?php
                                       } 
                                    ?>
                                 </select>
                              </div>
                           </div>
                           <?php
                           //   $getting_proforma = mysqli_query($conn, "SELECT max(id) AS performa_number FROM `purchase_order`");
                              $getting_proforma = mysqli_query($conn, "SELECT * FROM `purchase_order` ORDER BY `id` DESC LIMIT 1");
                              $getting_proformarow = mysqli_fetch_assoc($getting_proforma);
                              
                            // $getting_proforma_id = $getting_proformarow['performa_number'] + 21;
                            
                            $getting_proforma_id = $getting_proformarow['po_id'];
                            $get_performa_ids=(int)substr($getting_proforma_id,8);
                            $get_performa_ids=create_slug_bill($get_performa_ids+1);
                            // $get_performa_ids=create_slug_bill(1);   
    
                            $getting_proforma_id = "PO/".$get_c_year."/".$get_performa_ids;
                            //   PO/2022/01
                            
                            
                            
                            //   $getting_proforma = mysqli_query($conn, "SELECT max(id) AS performa_number FROM `purchase_order`");
                            //   $getting_proformarow = mysqli_fetch_assoc($getting_proforma);
                              
                            //   $getting_proforma_id = $getting_proformarow['performa_number'] + 21;
                              
                              ?>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="col-form-label">Purchase Order Id</label>
                                 <input type="text" name="po_id" class="form-control" value="<?php echo $getting_proforma_id ?>" readonly>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="inputPassword4" class="col-form-label">Order Date</label>
                                 <input type="text" class="form-control" name="date" id="date"
                                    value="<?php echo date('j F Y'); ?>">
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="col-form-label">Proforma Id</label>
                                 <input type="text" name="proforma_id" class="form-control" value="<?php echo $proforma_id ?>" readonly>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="col-form-label">Receive Info</label>
                                 <select class="form-control" name="receive_info" required>
                                    <option value="">-- select receive info --</option>
                                    <option value="Guangzhou">Guangzhou</option>
                                    <option value="Shanghai">Shanghai</option>
                                 </select>
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="inputEmail3" class="col-form-label">Delivery Address</label>
                                 <input class="form-control" name="delivery" placeholder="Enter Deliver Address" required>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label>Delivery Type</label> 
                                 <select class="form-control select" name="delivery_type" required>
                                    <option value="">-- Select Delivery Type--</option>
                                    <option value="FOB" <?php if ($delivery_type == 'FOB')
                                       {
                                           echo "selected";
                                       } ?>>FOB</option>
                                    <option value="EXW China" <?php if ($delivery_type == 'EXW China')
                                       {
                                           echo "selected";
                                       } ?>>EXW China</option>
                                    <option value="CNF Air" <?php if ($delivery_type == 'CNF Air')
                                       {
                                           echo "selected";
                                       } ?>>CNF Air</option>
                                    <option value="CNF Sea" <?php if ($delivery_type == 'CNF Sea')
                                       {
                                           echo "selected";
                                       } ?>>CNF Sea</option>
                                    <option value="Corriere" <?php if ($delivery_type == 'Corriere')
                                       {
                                           echo "selected";
                                       } ?>>Corriere</option>
                                    <option value="other">Other</option>
                                 </select>
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label>Delivery Terms</label>
                                 <select class="form-control" name="delivery_terms" id="delivery_terms" required>
                                    <option value="">--Select--</option>
                                    <option value="deliver" <?php if ($delivery_terms == 'deliver')
                                       {
                                           echo "selected";
                                       } ?>>Deliver</option>
                                    <option value="7" <?php if ($delivery_terms == '7')
                                       {
                                           echo "selected";
                                       } ?>>7 days</option>
                                    <option value="15" <?php if ($delivery_terms == '15')
                                       {
                                           echo "selected";
                                       } ?>>15 days</option>
                                    <option value="30" <?php if ($delivery_terms == '30')
                                       {
                                           echo "selected";
                                       } ?>>30 days</option>
                                    <option value="60" <?php if ($delivery_terms == '60')
                                       {
                                           echo "selected";
                                       } ?>>60 days</option>
                                    <option value="Due end of the month" <?php if ($delivery_terms == 'Due end of the month')
                                       {
                                           echo "selected";
                                       } ?>>Due end of the month</option>
                                    <option value="Due end of the next month" <?php if ($delivery_terms == 'Due end of the next month')
                                       {
                                           echo "selected";
                                       } ?>>Due end of the next month</option>
                                    <option value="Due on reciept" <?php if ($delivery_terms == 'Due on reciept')
                                       {
                                           echo "selected";
                                       } ?>>Due on reciept</option>
                                    <option value="Custom"  <?php if ($delivery_terms == 'Custom')
                                       {
                                           echo "selected";
                                       } ?>>Custom</option>
                                 </select>
                              </div>
                           </div>
                        </div>
                        <div class="row">
                           <div class="col-md-12">
                              <div class="form-group">
                                 <label>Type</label>
                                 <select class="form-control" name="type" required>
                                    <option  value=''>--select type--</option>
                                    <option value="Export" >Export</option>
                                    <option value="Import" >Import</option>
                                    <option value="Domastic" >Domastic</option>
                                 </select>
                              </div>
                           </div>
                        </div>
                     </div>
                     <div class="card-box">
                        <div class="row mt-3">
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label for="terms" class="col-form-label">Payment Terms</label>
                                 <textarea class="form-control" name="terms" id="terms" placeholder="Enter payment terms and conditions"></textarea>
                              </div>
                           </div>
                           <div class="col-md-6">
                              <div class="form-group">
                                 <label class="col-form-label">Comment</label>
                                 <textarea class="form-control" name="comment" placeholder="Enter Your Comment"><?php echo $comment ?></textarea>
                              </div>
                           </div>
                        </div>
                        <div class="row mt-3">
                           <button id="add" class="btn add-more button-yellow uppercase" type="button"> + Add Line Item</button>
                           <table class="table table-responsive">
                              <thead>
                                 <tr style="width:100%">
                                    <th>Item Code</th>
                                    <th>Item Image</th>
                                    <th>Item Name</th>
                                    <th>Item Name Ch.</th>
                                    <th>Size</th>
                                    <th>Color</th>
                                    <th>Color Ch.</th>
                                    <th>Qty</th>
                                    <th>Unit</th>
                                    <th>LPP</th>
                                    <th>Price</th>
                                    <th>Total</th>
                                    <th></th>
                                 </tr>
                              </thead>
                              <tbody id='itemsadd'>
                                 <?php
                                    $getitemsql = mysqli_query($conn, "SELECT * FROM proforma_item a left join inventory b on a.item_id = b.id where a.proforma_id = '$proforma_id'");
                                    while ($item_row = mysqli_fetch_assoc($getitemsql))
                                    {
                                    
                                        $item_id_p = $item_row['item_id'];
                                        $item_code_p = $item_row['item_code'];
                                        $qty_p = $item_row['qty'];
                                        $price_p = $item_row['price'];
                                        $size_p = $item_row['size'];
                                        $row_total = $item_row['row_total'];
                                        $item_p_img = 'inventory/' . $item_row['item_image'];
                                        $item_name = $item_row['name'];
                                        $color_p = $item_row['color'];
                                        $unit_p = $item_row['unit_of_measure'];
                                     
                                    ?>
                                 <tr id='next-referral'  style="width:100%">
                                    <td style="width:10%">
                                       <input class='form-control itemcode' name="item_code[]" type='text'  value='<?php echo $item_code_p ?>'>
                                    </td>
                                    <td style="width:10%">
                                       <img class="img_item" src="<?php echo $item_p_img ?>" width="80">
                                    </td>
                                    <td style="width:15%">
                                       <div id="text">
                                          <select class="form-control select itemClass" name="item[]" onchange="showitem(this)">
                                             <option value='<?php echo $item_id_p ?>'><?php echo $item_name ?></option>
                                             <?php
                                                $sqlitem = "SELECT * FROM inventory WHERE data_delete = 'no' and source_id = '$source_id'";
                                                $resultitem = mysqli_query($conn, $sqlitem);
                                                if ($resultitem)
                                                {
                                                    if (mysqli_num_rows($resultitem) > 0)
                                                    {
                                                        while ($rowitem = mysqli_fetch_assoc($resultitem))
                                                        {
                                                
                                                ?>
                                             <option value='<?php echo $rowitem['id'] ?>' <?php if ($item_id_p == $rowitem['id'])
                                                {
                                                    echo "selected";
                                                } ?>><?php echo $rowitem['name'] ?></option>
                                             <?php
                                                }
                                                }
                                                }
                                                  
                                                ?>     
                                          </select>
                                       </div>
                                    </td>
                                    <td style="width:15%">
                                       <input class='form-control chines_name' name="chines_name[]" type="text" ondrop='return false;' onpaste='return false;'>
                                    </td>
                                    <td style="width:6%">
                                       <input class='form-control sizeClass' name="size[]" type="text" ondrop='return false;' onpaste='return false;' value='<?php echo $size_p ?>'>
                                    </td>
                                    <td style="width:7%">
                                       <input class='form-control colorClass' name='color[]' type="text" ondrop='return false;' onpaste='return false;' value='<?php echo $color_p ?>'>
                                    </td>
                                    <td style="width:7%">
                                       <input class='form-control colorClass_ch' name='color_ch[]' type="text" ondrop='return false;' onpaste='return false;'>
                                    </td>
                                    <td style="width:6%">
                                       <input class='form-control quantityClass' name='qty[]' type="text" ondrop='return false;' onpaste='return false;' value='<?php echo $qty_p ?>'>
                                    </td>
                                    <td style="width:5%">
                                       <input class='form-control unitClass' name='unit[]' type='text' ondrop='return false;' onpaste='return false;' value="<?php echo $unit_p ?>">
                                    </td>
                                    <?php
                                    $item_id_p = $item_row['item_id'];
                                    $sql2 = "SELECT *,(select price from po_item where item_id = '$item_id_p' order by date_creation asc limit 1) as last_price FROM inventory WHERE id = '$item_id_p'";

                                                	$result2 = mysqli_query($conn,$sql2);
                                              while($row2= mysqli_fetch_assoc($result2))
                                                     {
                                            $lpp= $row2['last_price'];
                                                  
                                    
                                    ?>
                                     <td style="width:5%">
                                       <input class='form-control priceClass' id='lpp_input' name='price[]' type='text' ondrop='return false;' value='<?php echo $lpp ?>'>
                                    </td>
                                    <?php }?>
                                    <td style="width:7%">
                                       <input class='form-control priceClass' name='price[]' type='text' ondrop='return false;' onpaste='return false;' value='<?php echo $price_p ?>'>
                                    </td>
                                    <td style="width:7%">
                                       <input type="text" name="total_amt[]" class='form-control totalClass' value='<?php echo $row_total ?>' readonly>
                                    </td>
                                    <td><button type="button" class="btn btn-xs btn-danger delete"><span class="fa fa-trash"></span></button></td>
                                 </tr>
                                 <?php
                                    } ?> 
                              </tbody>
                           </table>
                        </div>
                        <div class="row">
                           <div class="col-md-6">
                           </div>
                           <div class="col-md-6">
                              <div class="form-group row">
                                 <label class="col-4 col-form-label" for="example-email">Subtotal </label>
                                 <div class="col-8">
                                    <input type="text" id="a4" class="form-control" name="subtotal"  value="<?php echo $subtotal_price ?>"  readonly>
                                 </div>
                              </div> 
                              <div class="form-group row">
                                 <label class="col-4 col-form-label" for="example-email">Amount Paid </label>
                                 <div class="col-8">
                                    <input type="text" id="amountvalue" class="form-control" name="amount_paid"  value="<?php echo $subtotal_price ?>" readonly>
                                 </div>
                              </div>
                           </div>
                        </div>
                     </div>
                     <button type="submit" class="btn btn-info waves-effect waves-light w-100">Submit</button>
                  </form>
               </div>
            </div>
            <!-- container -->
         </div>
         <!-- content -->
         <?php include 'copyrignt.php' ?>
      </div>
      <!-- ============================================================== -->
      <!-- End Right content here -->
      <!-- ============================================================== -->
      </div>
      <!-- END wrapper -->
      <!-- Chart Js -->
      <script src='https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.17/d3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.11/c3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.1.3/Chart.js'></script>
      <!-- jQuery  -->
      <script src="assets/js/jquery.min.js"></script>
      <script src="assets/js/popper.min.js"></script><!-- Popper for Bootstrap -->
      <script src="assets/js/bootstrap.min.js"></script>
      <script src="assets/js/metisMenu.min.js"></script>
      <!--<script src="assets/js/waves.js"></script>-->
      <script src="assets/js/jquery.slimscroll.js"></script>
      <!-- Dashboard init -->
      <script src="assets/pages/jquery.dashboard.js"></script>
      <!-- App js -->
      <script src="assets/js/jquery.core.js"></script>
      <script src="assets/js/jquery.app.js"></script>
      <!-- Chart Js -->
      <!-- <script src="assets/pie charts/script.js"></script>-->
      <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js'></script>
      <script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/js/select2.min.js'></script>
      <script src="assets/js/modernizr.min.js"></script>
      <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script> -->
      <script type="text/javascript" src="script.js"></script>
      <script>
         $(document).ready(function() {
           
             //when the Add Field button is clicked
             $("#add").click(function(e) {
                 $(".delete").fadeIn("1500");
                 //Append a new row of code to the "#items" div
                 $("#itemsadd").append(
                     "<tr id='next-referral' style='width:100%'><td style='width:10%'><input class='form-control itemcode' name='item_code[]' type='text'></td><td style='width:10%'><img class='img_item' src='' width='50'></td><td style='width:20%'><div id='text'><select class='form-control select itemClass' name='item[]' onchange='showitem(this)'><option value=''>--Select Item--</option><?php echo $item; ?></select></div></td><td style='width:15%'><input class='form-control chines_name' name='chines_name[]' type='text' ondrop='return false;' onpaste='return false;'></td><td style='width:10%'><input class='form-control sizeClass' name='size[]' type='text' ondrop='return false;' onpaste='return false;'></td><td style='width:10%'><input class='form-control colorClass' name='color[]' type='text' ondrop='return false;' onpaste='return false;'></td><td style='width:7%'><input class='form-control colorClass_ch' name='color_ch[]' type='text' ondrop='return false;' onpaste='return false;'></td><td style='width:6%'><input class='form-control quantityClass' name='qty[]' type='text' ondrop='return false;' onpaste='return false;'></td><td style='width:5%'><input class='form-control unitClass' name='unit[]' type='text' ondrop='return false;' onpaste='return false;' ></td><td style="width:5%"><input class='form-control priceClass' id='lpp_input' name='price[]' type='text' ondrop='return false;' value="<?php echo $lpp ?>"></td><td style='width:5%'><input class='form-control priceClass' name='price[]' type='text' ondrop='return false;' onpaste='return false;' ></td><td style='width:15%'><input type='text' name='total_amt[]' value='' class='form-control totalClass' readonly></td><td><button type='button' class='btn btn-xs btn-danger delete'><span class='fa fa-trash'></span></button></td></tr>"
                 );
                 forSelect();
             });
             //("body").on("click", ".delete", function(e) {
             //$("#next-referral").last().remove();
             //});
         });
      </script>
      <script>
         $(function () {
              $(".select") 
                .on('select2:close', function() {
                  var el = $(this);
                  if(el.val()==="other") {
                    var newval = prompt("Enter other value you want: ");
                    if(newval !== null) {
                      el.append('<option>'+newval+'</option>')
                        .val(newval);
                    }
                  }
              });
          });
          
         
          function selectOption() {
              $('.select').select2();
          }
          
          $(document).ready(function() {
              forSelect();
          });
          
          function forSelect() {
              selectOption();
          
              $('#add').click(function() {
                  var text = $('#text').html();
          
                  $('#demo').append(text);
                  $('#demo .select').select2();
                  $('#demo .select').last().next().next().remove();
              });
          }
          
          
          
          
                   $(document).on('keyup', '.quantityClass,.priceClass', function() {
              var sum = 0;
              var gsum = 0;
              var price = 0;
              var quantity = 0;
              var tax = 0;
              var discountApplied = 0;
              
              var thisRow = $(this).closest('tr');
              thisRow.find('.priceClass').each(function() {
                  if (this.value == null || this.value == '')
                      price = 0;
                  else
                      price = this.value;
              });
          
              thisRow.find('.quantityClass').each(function() {
                  if (this.value == null || this.value == '')
                      quantity = 0;
                  else
                      quantity = this.value;
              });
              
          
          
              var decreaseValue = parseFloat(price) * parseFloat(quantity);
             
          
             
               
          
              var subTotal = (parseFloat(decreaseValue)).toFixed(2);
          
              thisRow.find('.totalClass').val(subTotal); 
          
              var totalColumn = $(this).closest('tr').parent();
              // for total amount
              var totalPrice = 0;
              totalColumn.find('.totalClass').each(function() {
                  totalPrice = (parseFloat(totalPrice) + parseFloat(this.value)).toFixed(2);
              });
              $("#a4").val(totalPrice);
              //-----------------------------
           
              
             var bank_charges = $('#bank_charges').val();    
             
              
             if (bank_charges == null || bank_charges == ''){
                 var bank_charges = 0;
             }else{
                 var bank_charges = $('#bank_charges').val();  
             }
             
            
             
              
         
             var other_foreign_subtotal =  (parseFloat(totalPrice) + parseFloat(bank_charges)).toFixed(2);
            
              $("#amountvalue").val((parseFloat(other_foreign_subtotal)).toFixed(2));
              
              
          });
          
          
          
          $(document).on('keyup', '.bank_charges', function() {
          
                 
               var bank_charges = 0;
               
               
               
              var totalPrice = $('#a4').val();    
                
              var bank_charges = $('#bank_charges').val();    
                
              
             if (totalPrice == null || totalPrice == ''){
                 var totalPrice = 0;
             }else{
                 var totalPrice = $('#a4').val();  
             }
              
         
             
              
             if (bank_charges == null || bank_charges == ''){
                 var bank_charges = 0;
             }else{
                 var bank_charges = $('#bank_charges').val();  
             }
             
            
              
              
         
                
             var other_subtotal =  (parseFloat(totalPrice) + parseFloat(bank_charges)).toFixed(2);
         
             
              $("#amountvalue").val((parseFloat(other_subtotal)).toFixed(2));
              
              
          });
          
          
          
           
          
          
          
          $(document).on('click', '.delete', function() {
          
          
              var totalColumn = $(this).closest('tr').parent();
              $(this).closest('tr').remove();
              // for total amount
              var totalPrice = 0;
              totalColumn.find('.totalClass').each(function() {
                  totalPrice = (parseFloat(totalPrice) + parseFloat(this.value)).toFixed(2); 
              });
          
              $("#a4").val(totalPrice);
              
         
              var other_charges = $('#other_charges').val();   
                          if (other_charges == null || other_charges == ''){
                 var other_charges = 0;
             }else{
                 var other_charges = $('#other_charges').val();  
             }
             
              var bank_charges = $('#bank_charges').val();
             
             
              
             if (bank_charges == null || bank_charges == ''){
                 var bank_charges = 0;
             }else{
                 var bank_charges = $('#bank_charges').val();  
             }
             
                        
             
              var other_subtotal =  (parseFloat(totalPrice) + parseFloat(other_charges) + parseFloat(bank_charges)).toFixed(2);
         
              $("#amountvalue").val((parseFloat(other_subtotal)).toFixed(2));
          
          });
          
           
          
          $(document).ready(function() {
              $("#s").change(function() {
                  if (!this.checked) {
                      $("#due_date").removeAttr('disabled');
                      $("#due_date").removeAttr('readonly');
                      if ($("#due_date").val() == "Paid") {
                          $("#due_date").val("<?php echo date('j F Y'); ?> ");
                      }
                  } else {
                      $("#due_date").attr('disabled', 'disabled');
                      $("#due_date").attr('readonly', 'true');
                      $("#due_date").val("Paid");
          
                  }
              });
          
              //triger change event in case checkbox checked when user accessed page
              $("#s").trigger("change")
          });
          
          
          $(document).ready(function() {
              $("#due_date,#date,#shipping_date,#revised_date").datepicker({
                  dateFormat: 'dd MM yy'
              });
          });
          
          $(document).ready(function(){
              $("#terms").change(function(){
                  var date1 = $('#date').val();
                  var date = new Date( Date.parse( date1 ) ); 
                  var terms = $( "#terms option:selected" ).val();
                  if(terms === "Paid"){
          
                  }
                  else if(terms === "7"){
                      date.setDate( date.getDate() + 7 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#due_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "15"){
                      date.setDate( date.getDate() + 15 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#due_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "30"){
                      date.setDate( date.getDate() + 30 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#due_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "60"){
                      date.setDate( date.getDate() + 60 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#due_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "Due end of the month"){
                      $('#due_date').datepicker('setDate', new Date(date.getFullYear(), date.getMonth() + 1, 0));
                  }
                  else if(terms === "Due on reciept"){
                      $('#due_date').datepicker('setDate', date);
                  }
                  else if(terms === "Due end of the next month"){
                      $('#due_date').datepicker('setDate', new Date(date.getFullYear(), date.getMonth() + 2, 0));
                  }
              });
          });
          
          $(document).ready(function(){
              $("#date").change(function(){
                  $("#terms").trigger("change");
              });
          
              $("#due_date").change(function(){
                  $('#terms option[value="Custom"]').attr("selected", "selected");
              });
              $("#date").datepicker("setDate", new Date());
              $("#due_date").datepicker("setDate", new Date());
          });  
          
          
           
          $(document).ready(function(){
              $("#delivery_terms").change(function(){
                  var date1 = $('#date').val();
                  var date = new Date( Date.parse( date1 ) ); 
                  var terms = $( "#delivery_terms option:selected" ).val();
                   
                  
                  if(terms === "deliver"){
          
                  }
                  else if(terms === "7"){
                      date.setDate( date.getDate() + 7 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#shipping_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "15"){
                      date.setDate( date.getDate() + 15 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#shipping_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "30"){
                      date.setDate( date.getDate() + 30 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#shipping_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "60"){
                      date.setDate( date.getDate() + 60 );
                      var newDate = date.toDateString(); 
                      newDate = new Date( Date.parse( newDate ) );
                      $('#shipping_date').datepicker('setDate', newDate );
                  }
                  else if(terms === "Due end of the month"){
                      $('#shipping_date').datepicker('setDate', new Date(date.getFullYear(), date.getMonth() + 1, 0));
                  }
                  else if(terms === "Due on reciept"){
                      $('#shipping_date').datepicker('setDate', date);
                  }
                  else if(terms === "Due end of the next month"){
                      $('#shipping_date').datepicker('setDate', new Date(date.getFullYear(), date.getMonth() + 2, 0));
                  }
              });
          });
          
          $(document).ready(function(){
              $("#shipping_date").change(function(){
                  $("#delivery_terms").trigger("change");
              });
          
              $("#shipping_date").change(function(){
                  $('#delivery_terms option[value="Custom"]').attr("selected", "selected");
              });
              $("#date").datepicker("setDate", new Date());
              $("#shipping_date").datepicker("setDate", new Date());
          });  
          
          
          //  getInvoicePrefix("<?php echo $source_id; ?>");
          
          
          //  $("input[name=invoiceType]").click(function(){
          //      if($(this).val() == "Invoice"){
          //          $("#lblInvoice").text("Invoice Number");
          //          getInvoicePrefix("<?php echo $source_id; ?>");
          //      }
          //      else{
                  
          //          getPerformaNumber();
          //          $("#lblInvoice").text("Performa Id");
                  
          //      }
          //  });
          
          //  function getPerformaNumber(){
          //      var companyId = "<?php echo $source_id; ?>";
          //      $.ajax({
          //          url : "PHP/response.php",
          //          data : "action=GetPerforma&companyId="+companyId,
          //          async : false,
          //          method : "POST",
          //          success : function(response){
          //              var val = (response * 1) + 1;
          //              $("#invoice_number").val(val);
          //              var s_number = ('0000' + val).substr(-5);
          //              $("#invoice_id").val("#PI"+s_number);
          //          },
          //          error : function(err){
          
          //          }
          //      });
          //  }
          
          
      </script>
      <script>
         function getAddressDetail(addressId){
          
            $.ajax({ 
                
                 url: "get-contact-details.php?companyId=" + addressId,
                 method: "GET",
                 async: false,
                  success : function(response){
                      var str = JSON.parse(response);
                      if(str != ""){ 
                        
                          $("#address").val(str.address);
                          $("#country").val(str.country);
                          $("#country").trigger("change");
                          $("#state").val(str.state);
                          $("#city").val(str.city);
                          $("#pin").val(str.pin);
                          $("#phone").val(str.phone);
                          $("#email").val(str.email);
                          $("#gstin").val(str.gstin);
                          $("#bank_charges").val(str.bank_charges);
                          $("#iecno").val(str.iecno);
                          $("#type").val(str.type);
                          $("#panno").val(str.panno);
                          $("#currency").val(str.currency);
                          $("#opening_balance").val(str.opening_balance);
                          $("#terms_condtion").val(str.terms_condtion);
                            
                      }
                  },
                  error:function(err){
                      
                  }
              }); 
              
          }
         
                  
         function showUser(str) {
         
             $.ajax({
                 url: "getCustomerAddress.php?companyId=" + str,
                 method: "GET",
                 async: false,
                 success: function(response) {
                     $("#billingAddress").html(response); 
                 },
                 error: function(jqXHR, textStatus, errorThrown) {
                     alert('Internal error: ' + jqXHR.responseText);
                 }
             })
         }
          
         
         function showitem(str) {
             var thisRow = $(str).closest('tr');
             var item = thisRow.find('.itemClass').val();
             if (item == "") {
                 document.getElementById("txtHint").innerHTML = "";
                 return;
             }
             $.ajax({
                 url: "getitem.php",
                 method: "POST",
                 async: false,
                 data: {q:item},
                 success: function(response) {
                     var str1 = JSON.parse(response);
                     thisRow.find('.itemcode').val(str1.item_code);
                     thisRow.find('.item_qty').val(str1.item_qty);
                     thisRow.find('.item_id').val(str1.id);
                     thisRow.find('.sizeClass').val(str1.size);
                     thisRow.find('.colorClass').val(str1.color);
                     thisRow.find('#lpp_input').val(str1.last_price);
                     thisRow.find('.unitClass').val(str1.unit_of_measure);
                     thisRow.find(".img_item").attr("src",'inventory/'+str1.item_image); 
                     // thisRow.find('.discountAppliedClass').val(str1.discount_applied);
                     // thisRow.find('.discountCategoryClass').val(str1.discount_category);
                     if(thisRow.find('.quantityClass').val() != ""){
                         thisRow.find('.quantityClass').trigger("keyup");
                     }
                 },
                 error: function(jqXHR, textStatus, errorThrown) {
                     alert('Internal error: ' + jqXHR.responseText);
                 }
             })
         }
         
                 
      </script>   
   </body>
</html>