MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.68
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home2/imyrqtmy/www/inventory/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/www/inventory/invoice_edit.php
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
    header("Location: login.php");
}
include("include/db.php");;
date_default_timezone_set('Asia/Kolkata');
 $date = date('Y-m-d');

 $bid  = $_GET['id'];

  $sql = "select * from tbl_invoice where id='$bid'";
  $sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
  $sql_row = mysqli_fetch_assoc($sql_res);

  $fe_img = $sql_row['file'];
?>
<!doctype html>
<html lang="en">


<!-- Mirrored from themesdesign.in/morvin/layouts/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:25:02 GMT -->
<head>

    
    <?php include 'include/head.php'; ?>
     <link href="assets/libs/select2/css/select2.min.css" rel="stylesheet" type="text/css" />
<style>
  .select2-dropdown
  {
    width: 188px;
  }
  .select2-selection
  {
    width: 188px;
  }
.one,
td,th,
tr {
    border: 1px solid black;

    border-collapse: collapse;

}

body {
    font-family: verdana;
}

.one {

    margin: auto;
    width: 90%;

}

td,th,
td {
    height: 25px;
}

#one {
    width: 40%;

}

#two {
    width: 20%;
}

.two,
td,th,
tr {
    border: 1px solid black;

    border-collapse: collapse;

}

.two {
    margin: auto;
    margin-top: 4px;
    width: 100%;

}
.three {
    
    border:1px solid black;
     
    border-collapse:collapse;
    margin: auto;
    
    margin-top: 4px;
    width: 90%;
    margin-bottom:4px;

}
#n,#new{
    border:none;
    
}
</style>

</head>


<body>

    <!-- Begin page -->
    <div id="layout-wrapper">

       <?php include 'include/header.php'; ?>

        <!-- ========== Left Sidebar Start ========== -->
        <div class="vertical-menu">
            <?php include 'include/sidebar.php'; ?>
        </div>
        <!-- Left Sidebar End -->

        <!-- ============================================================== -->
        <!-- Start right Content here -->
        <!-- ============================================================== -->
         <div class="main-content">

                <div class="page-content">

                    <!-- start page title -->
                    <div class="page-title-box">
                        <div class="container-fluid">
                         <div class="row align-items-center">
                             <div class="col-sm-6">
                                 <div class="page-title">
                                     <h4>NEW INVOICE</h4>
                                         <!-- <ol class="breadcrumb m-0">
                                             <li class="breadcrumb-item"><a href="javascript: void(0);">Morvin</a></li>
                                             <li class="breadcrumb-item"><a href="javascript: void(0);">Tables</a></li>
                                             <li class="breadcrumb-item active">Data Tables</li>
                                         </ol> -->
                                 </div>
                             </div>
                             <div class="col-sm-6">
                               
                             </div>
                         </div>
                        </div>
                     </div>
                     <!-- end page title -->    


                    <div class="container-fluid">

                        <div class="page-content-wrapper">

                        

                             <div class="row">
                                    <div class="col-lg-12">
                                    <div class="card">
                                        <div class="card-body">
                                           
                                            
                                            <form method="POST" action="action/invoice_edit.php?id=<?php echo $bid; ?>" enctype="multipart/form-data" >
                                                <div class="row">

                                               

                                                   

                                            
                                                   


                                                      <div class="row" style="margin-bottom: 25px;">

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                                Customer Name*
                                                            </label>
                                                        </div>

                                                        <div class="col-md-8">
                                                             
                                                            <div class="input-group bootstrap-touchspin bootstrap-touchspin-injected">
                                                              <select class="form-select" id="cust_name" name="cust_name">
                                                               
                                                               


                                                               <?php
                                                          $new_qu = "select * from tbl_customer";
                                                          $new_res = mysqli_query($con, $new_qu) or die(mysqli_error($con));

                                                          while ($new_row = mysqli_fetch_assoc($new_res)) { ?>
                                                              <?php if ($new_row['id'] == $sql_row['cust_name']) { ?>
                                                                  <option value="<?php echo $new_row['id']; ?>" selected><?php echo $new_row['c_name_dis']; ?></option>
                                                              <?php } else { ?>
                                                                  <option value="<?php echo $new_row['id']; ?>"><?php echo $new_row['c_name_dis']; ?></option>
                                                              <?php } ?>
                                                          <?php } ?>
                                                            </select>
                                                            <span class="input-group-btn input-group-append"><button class="btn btn-primary bootstrap-touchspin-up" type="button"><i class="mdi mdi-magnify"></i></button></span></div>
                                                            
                                                        </div>

                                                        
                                                         
                                                      </div>
                                                      <br>
                                                      <br>

                                                      <div class="row" style="margin-bottom: 25px;">

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                               Invoice#
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <input class="form-control" type="text"  id="example-text-input" name="so_no" value="<?php echo $sql_row['so_no']; ?>" >
                                                            
                                                        </div>

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                               Vehicle No
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <input class="form-control" type="text"  id="example-text-input" name="vehno" value="<?php echo $sql_row['vehno']; ?>" >
                                                            
                                                        </div>

                                                        
                                                         
                                                      </div>
                                                      <br>

                                                      <div class="row" style="margin-bottom: 25px;">

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                                Order Number
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <input class="form-control" type="text"  id="example-text-input" name="ref_no" value="<?php echo $sql_row['ref_no']; ?>" >
                                                            
                                                        </div>

                                                         <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                                GST No.
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <input class="form-control" type="text"  id="example-text-input" name="gst_no" value="<?php echo $sql_row['gst_no']; ?>">
                                                            
                                                        </div>

                                                        
                                                         
                                                      </div>
                                                      <br>

                                                      <div class="row" style="margin-bottom: 25px;">

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                                Invoice Date
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <input class="form-control" type="date"   value="<?php echo $sql_row['so_date']; ?>" name="so_date">
                                                            
                                                        </div>

                                                        
                                                         
                                                      </div>
                                                      <br>

                                                      <div class="row" style="margin-bottom: 25px;">

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                               Due Date
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <input class="form-control" type="date"  id="example-text-input" name="ship_date" value="<?php echo $sql_row['ship_date']; ?>">
                                                            
                                                        </div>

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                                Payment Terms
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <select class="form-select" name="pay_terms" id="pay_terms">

                                                               <option value="Net 15"<?=$sql_row['pay_terms'] == 'Net 15' ? ' selected="selected"' : '';?>>Net 15</option>

                                                                <option value="Net 45"<?=$sql_row['pay_terms'] == 'Net 45' ? ' selected="selected"' : '';?>>Net 45</option>

                                                                 <option value="Net 30"<?=$sql_row['pay_terms'] == 'Net 30' ? ' selected="selected"' : '';?>>Net 30</option>

                                                                 <option value="Net 60"<?=$sql_row['pay_terms'] == 'Net 60' ? ' selected="selected"' : '';?>>Net 60</option>

                                                                 <option value="Due end of the month"<?=$sql_row['pay_terms'] == 'Due end of the month' ? ' selected="selected"' : '';?>>Due end of the month</option>

                                                                  <option value="Due end of next month"<?=$sql_row['pay_terms'] == 'Due end of next month' ? ' selected="selected"' : '';?>>Due end of next month</option>

                                                                  <option value="Due on Receipt"<?=$sql_row['pay_terms'] == 'Due on Receipt' ? ' selected="selected"' : '';?>>Due on Receipt</option>
                                                               
                                                               
                                                                
                                                            </select>
                                                            
                                                        </div>

                                                        
                                                         
                                                      </div>
                                                      <br>

                                                       <hr>

                                                         

                                                       <div class="row" style="margin-bottom: 25px;">

                                                       

                                                        <div class="col-md-2">
                                                            <label class="form-check-label" for="formCheck1">
                                                               Salesperson
                                                            </label>
                                                        </div>

                                                        <div class="col-md-4">
                                                             
                                                             <select class="form-select" name="sales_person">
                                                               
                                                                  <?php
                                                          $new_qu = "select * from tbl_saleperson";
                                                          $new_res = mysqli_query($con, $new_qu) or die(mysqli_error($con));

                                                          while ($new_row = mysqli_fetch_assoc($new_res)) { ?>
                                                              <?php if ($new_row['name'] == $sql_row['sales_person']) { ?>
                                                                  <option value="<?php echo $new_row['name']; ?>" selected><?php echo $new_row['name']; ?></option>
                                                              <?php } else { ?>
                                                                  <option value="<?php echo $new_row['name']; ?>"><?php echo $new_row['name']; ?></option>
                                                              <?php } ?>
                                                          <?php } ?>
                                                            </select>
                                                            
                                                        </div>

                                                        
                                                         
                                                      </div>
                                                      <br>

                                                       <div class="row" style="margin-bottom: 25px;">

                                                       

                                                        
                                                      <table class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;" width="100%" id="dynamic_field">
                                                        <tr>
                                                           <th width="30%">Item Details </th>
                                                           <th>Quantity</th>
                                                           <th>RATE  </th>
                                                           <th>DISCOUNT</th>
                                                           <th>AMOUNT</th>
                                                           <!-- <th></th> -->
                                                        </tr>

                                                        <?php 

                                                          $bid  = $_GET['id'];
                                                          $count = 1;
                                                           $sqlt = "select * from tbl_invo_item where soid='$bid'";

                                                           $sql_rest = mysqli_query($con, $sqlt) or die(mysqli_error($con));

                                                            while ($sql_rowt = mysqli_fetch_array($sql_rest))
                                                            {
                                                        ?>
                                                        <tr id="<?php echo $count; ?>">

                                                          <input type="hidden" name="auto[]" id="auto" class="" value="<?php echo $sql_rowt['id']; ?>">
                                                          <td>
                                                              <select class="form-control item select2" name="state[]" id="state<?php echo $count; ?>" >
                                                            

                                                         <?php
                                                         
                                                          $new_qu = "select * from tbl_item";
                                                          $new_res = mysqli_query($con, $new_qu) or die(mysqli_error($con));

                                                          while ($new_row = mysqli_fetch_assoc($new_res)) { ?>
                                                              <?php if ($new_row['name'] == $sql_rowt['item_name']) { ?>
                                                                  <option value="<?php echo $new_row['name']; ?>" selected><?php echo $new_row['name']; ?></option>
                                                              <?php } else { ?>
                                                                  <option value="<?php echo $new_row['name']; ?>"><?php echo $new_row['name']; ?></option>
                                                              <?php } ?>
                                                          <?php } ?>
                                                                     
                                                        </select>
                                                        
                                                          </td>
                                                          <td><input type="number" name="Qty[]" id="Qty<?php echo $count; ?>" class="qty form-control"  min="1" value="<?php echo $sql_rowt['qty']; ?>"></td>

                                                          <td><input type="number" name="price[]" class="pprice form-control" id="price<?php echo $count; ?>" min="0" value="<?php echo $sql_rowt['rate']; ?>"></td>

                                                          <td>
                                                            <select class="form-select" id="percen<?php echo $count; ?>" name="percen[]" style="width: 67px;">

                                                          

                                                            <option value="per"<?=$sql_rowt['dis_type'] == 'per' ? ' selected="selected"' : '';?>>%</option>

                                                            <option value="RS"<?=$sql_rowt['dis_type'] == 'RS' ? ' selected="selected"' : '';?>>RS</option>
                                                                
                                                            </select>
                                                            <br>
                                                            <input type="number" name="discount[]" class="discount form-control" id="discount<?php echo $count; ?>" min="0" value="<?php echo $sql_rowt['discount']; ?>">
                                                            
                                                             
                                                          </td>

                                                          
                                                              <td><input type="text" class="totprice form-control" name="tprice[]" id="totalprice<?php echo $count; ?>"  value="<?php echo $sql_rowt['amt']; ?>"></td>
                                                          
                                                          <!-- <td>
                                                              <button type="button"  class=" btn-md btn btn-success added"><i class="fa fa-plus"></i></button>
                                                          </td> -->
                                                        </tr>
                                                       <?php $count++;
                                                } ?>

                                                </table>

                                                        
                                                         
                                                      </div>


                                                      <div class="row" style="margin-bottom: 25px;">

                                                        <div class="row">
                                                          <div class="col-md-6">

                                                           <!--  <div class="row" style="margin-bottom: 25px;">

                                                           <div class="col-md-8">
                                                             <a href="#"><i class="fa fa-plus"></i>Add another line</a>
                                                          </div>

                                                        </div> -->



                                                        <div class="row">

                                                           <div class="col-md-12">
                                                             <label class="form-check-label" for="formCheck1">
                                                               Customer Notes
                                                            </label>

                                                            <textarea placeholder="Enter any notes to be displayed in your transaction" name="cnote" id="ember1161" class="ember-text-area ember-view form-control"><?php echo $sql_row['cnote']; ?></textarea>
                                                          </div>

                                                        </div>

                                                      </div>
                                                      <div class="col-md-6" style="background-color: #fbfafa;border-radius: 10px!important;margin-left: auto!important;">

                                                         <div class="row" style="margin-bottom: 25px;">

                                                           <div class="col-md-3">
                                                             <label class="form-check-label" for="formCheck1">
                                                               Sub Total
                                                            </label>
                                                          </div>

                                                            <div class="col-md-4">
                                                             
                                                          </div>

                                                           <div class="col-md-4">

                                                            <span style="float: right;" id="subtotal"><?php echo $sql_row['sub_total']; ?></span>

                                                            <input type="hidden" name="subtotalval" id="subtotalval" value="<?php echo $sql_row['sub_total']; ?>">
                                                             
                                                          </div>

                                                        </div>

                                                         <div class="row" style="margin-bottom: 25px;">

                                                           <div class="col-md-3">
                                                             <label class="form-check-label" for="formCheck1">
                                                               Adjustment
                                                            </label>
                                                          </div>

                                                          <div class="col-md-4">
                                                              <input class="form-control adjust" type="text"  id="example-text-input" id="adjust" name="adjust">
                                                          </div>

                                                          <div class="col-md-4">

                                                            <span id="adjuste" style="float: right;">
                                                              <?php 
                                                              if ($sql_row['adjustment'] == '') {
                                                                 echo '0.00';
                                                              }
                                                              else
                                                              {
                                                                 echo $sql_row['adjustment'];
                                                              }
                                                              ?>
                                                              <?php echo $sql_row['adjustment']; ?></span>
                                                             
                                                          </div>

                                                        </div>

                                                         <div class="row" style="margin-bottom: 25px;">

                                                           <div class="col-md-4">
                                                             <label class="form-check-label" for="formCheck1" style="font-weight: 600;">
                                                               Total ( Rs. )
                                                            </label>
                                                          </div>

                                                          <div class="col-md-3">
                                                             
                                                          </div>

                                                          <div class="col-md-4">

                                                            <span style="float: right; font-weight: 600;" id="total"><?php echo $sql_row['total']; ?></span>

                                                            <input type="hidden" name="totalval" id="totalval" value="<?php echo $sql_row['total']; ?>">
                                                             
                                                          </div>

                                                        </div>



                                                      </div>
                                                    </div>
                                                  </div>
                                                      <br>

                                                      <hr>

                                                      <div class="row" style="margin-bottom: 25px;">

                                                        

                                                        <div class="col-md-8"  style="border-right: 1px solid #eee;">
                                                          <label class="form-check-label" for="formCheck1">
                                                                Terms & Conditions
                                                            </label>
                                                             
                                                             <textarea placeholder="Enter the terms and conditions of your business to be displayed in your transaction" id="ember1161" class="ember-text-area ember-view form-control" rows="4" name="term_con"><?php echo $sql_row['term_con']; ?></textarea>
                                                            
                                                        </div>

                                                        <div class="col-md-4">

                                                       <div class="mb-3">
                                                            <label class="form-label">Attach File to Invoice</label>
                                                           <input type="file" name="do_photo" class="form-control "  id="images" onchange="readThumb(this, 'thumb-error')" class="" accept="image/*">
                                                             <span><?php echo $fe_img; ?></span>
                                                             <br>
                                                          <img id="thumb" src="salesorder/<?php echo $fe_img; ?>" alt=""  style="width: 100px;height: 100px;">
                                                          <div id="thumb-error" style="color: red; margin: 10px 0px 0 10px; display: none;">
                                                           Please upload file having extensions .jpeg / .jpg / .png only.</div>
                                                           
                                                        </div>
                                                      
                                                    </div>
                                                        
                                                      </div>

                                                   
                                                

                                                <div>
                                                    <button class="btn btn-primary" type="submit">Save</button>
                                                     <button class="btn btn-info" type="submit">cancel</button>
                                                </div>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                               <!-- end col -->
                            </div>
                           <!-- end row -->
            
                      

                        </div>
        
                        
                    </div> <!-- container-fluid -->
                </div>
                <!-- End Page-content -->

              
                
                <footer class="footer">
                 <?php include 'include/footer.php'; ?>
            </footer>
            </div>
        <!-- end main content-->

    </div>
    <!-- END layout-wrapper -->

    <!-- Right Sidebar -->
   
    <!-- /Right-bar -->

    <!-- Right bar overlay-->
    <div class="rightbar-overlay"></div>

    <!-- JAVASCRIPT -->
       <?php include 'include/bscript.php'; ?>
       <script src="assets/libs/select2/js/select2.min.js"></script>
       <script src="assets/js/pages/form-advanced.init.js"></script>
       <script type="text/javascript">
     $(document).on('change', '.item', function(e){
                var stateID1 = $(this).val();    
                // var aid = $('#auto').val();
                 var aid = $(this).closest('tr').attr('id');
                 var subt = $('#subtotalval').val();
                 var tot =  $('#totalval').val();

                  var percen =  $('#percen'+aid).val();
                  var discount =  $('#discount'+aid).val();
                 
                   // alert(subt);
                   // alert(tot);
                   // alert(stateID1);
                   // alert(discount);
                   // alert(percen);
                   // alert(aid);
                     $.ajax({  
                    type: 'POST',  
                    url: 'Ajax/get_item_inv.php', 
                    data: {bid: stateID1,subt: subt,tot: tot,discount: discount,percen: percen },
                    success: function(data) {
                        // console.log(data);
                        data = JSON.parse(data);
                       // datas =  JSON.parse(JSON.stringify(data));
                        // alert(data);
                         // $('#tax').val(data.tax);
                         $('#price'+aid).val(data.sellprice);
                         $('#Qty'+aid).val(data.qty);
                         $('#totalprice'+aid).val(data.amt);

                          var icsum = 0;
                            $('.totprice').each(function()
                            {
                                icsum += parseFloat($(this).val());
                            });


                         $('#subtotal').text(icsum);
                         $('#total').text(icsum);

                         $('#subtotalval').val(icsum);
                         $('#totalval').val(icsum);

                         

                         


                     }
                    });
            });
</script>
 

 <script type="text/javascript">
     $(document).on('change', '.discount', function(e){
                var disID1 = $(this).val(); 

                var trid = $(this).closest('tr').attr('id');

                var percen = $('#percen'+trid).val();

                var dpri = $('#price'+trid).val();

                var dqty = $('#Qty'+trid).val();

                

                // var totalprice = $('#totalprice').val();

                var totalprice = (dpri * dqty);

                var subt = $('#subtotalval').val();
                 var tot =  $('#totalval').val();

                 
                // alert(totalprice); 

                // alert(percen);  
                 
                  // alert(disID1);

                  if(percen == 'per')
                  {
                      var ndisval = (totalprice*disID1/100);
                      var disval =  (totalprice)-(ndisval);
                  }
                  // else
                  // {
                  //     var disval = (subt - disID1);
                  // }

                  else if(percen == 'RS')
                  {
                      // var ndisval = (disID1/totalprice*100);
                      // var disval = (subt)-(ndisval);
                      var disval = (totalprice - disID1);
                       // var ntotp = (totalprice) - (ndisval);
                  }
                  // else
                  // {
                      
                  //      // var ntotp = (totalprice) - (disval);
                  // }

                   // alert(disval);

                   // var ntotp = (totalprice) - (disval) ;


                   $('#totalprice'+trid).val(disval);
                   

                   var icsum = 0;
                            $('.totprice').each(function()
                            {
                                icsum += parseFloat($(this).val());
                            });
                           

                         $('#subtotal').text(icsum);
                         $('#total').text(icsum);

                         $('#subtotalval').val(icsum);
                         $('#totalval').val(icsum);

                         

                         


                     
                    });
            
</script>

 <script type="text/javascript">
     $(document).on('change', '.qty', function(e){
                var  iqty = $(this).val();    
                 var id1 = $(this).attr('id').split('e').pop();
                 var trid = $(this).closest('tr').attr('id');
                 var subt = $('#subtotalval').val();
                 var tot =  $('#totalval').val();
                 var stateID1 =  $('#state'+trid).val();

                 var percen = $('#percen'+trid).val();

                 var discount = $('#discount'+trid).val();

                  
                   // alert(subt);
                   // alert(tot);
                   // alert(stateID1);
                   // alert(trid);
                     $.ajax({  
                    type: 'POST',  
                    url: 'Ajax/get_qty_inv.php', 
                    data: {bid: stateID1,subt: subt,tot: tot,iqty: iqty,discount: discount,percen: percen },
                    success: function(data) {
                        // console.log(data);
                        data = JSON.parse(data);
                       // datas =  JSON.parse(JSON.stringify(data));
                        // alert(data);
                         // $('#tax').val(data.tax);
                         $('#price'+trid).val(data.sellprice);
                         $('#Qty'+trid).val(data.qty);
                         $('#totalprice'+trid).val(data.amt);

                         var icsum = 0;
                            $('.totprice').each(function()
                            {
                                icsum += parseFloat($(this).val());
                            });
                            $('#costotal').text(icsum);

                         
                         $('#costotalval').val(icsum);

                         $('#subtotal').text(icsum);
                         $('#total').text(icsum);

                         $('#subtotalval').val(icsum);
                         $('#totalval').val(icsum);

                         

                         


                     }
                    });
            });
</script>

<script type="text/javascript">
     $(document).on('change', '.adjust', function(e){
                var adjust = $(this).val(); 

                var subt = $('#subtotalval').val();
                

                // alert(subt); 

                // alert(adjust);  
                 
                   var atotp = (parseInt(subt)+parseInt(adjust)) ;


                   
                   $('#total').text(atotp);

                    
                    $('#totalval').val(atotp);

                    $('#adjuste').text(adjust);

                         

                         


                     
                    });
            
</script>


       <script>  
 $(document).ready(function(){  
     // alert("o");
      var i=0;  
      // $(document).on('change', '.added', function(){
         $(".added").click(function(){
        // alert("d");
        if(i <= 9)
        {
           
           i++;  
           $('#dynamic_field').append('<tr id="row'+i+'"><td> <select class="form-control iname select2" name="state[]" id="state'+i+'" ><option value="">-- Select Item --</option> <?php $SQL = "SELECT * FROM tbl_item ";$cat_result = mysqli_query($con, $SQL) or die(mysqli_error($con));while($cat_row = mysqli_fetch_assoc($cat_result)){?><option value="<?php echo $cat_row["name"] ?>"><?php echo $cat_row["name"] ?></option><?php }?></select></td><td><input type="number" name="Qty[]" id="Qty'+i+'" class="kmmname form-control"  min="0" value=""></td><td><input type="number" name="price[]" class="pprice form-control" id="price'+i+'" value=""></td><td><select class="form-select" id="percen'+i+'" name="percen" style="width: 67px;"><option value="per">%</option><option value="RS">RS</option></select><br><input type="number" name="discount[]" class="ddiscount dis'+i+' form-control" id="'+i+'" value="0" ></td> <td><input type="text" class="totprice form-control" name="tprice[]" id="totalprice'+i+'"  value=""></td><td><button type="button" name="remove" id="'+i+'" class="btn-md btn btn-danger btn_remove">X</button></td></tr>');

           $('.select2').select2(); 

           }
        else{
          // alert('o');
        } 
      });  
      $(document).on('click', '.btn_remove', function(){  
           var button_id = $(this).attr("id");   
           $('#row'+button_id+'').remove();  
      });  

        $(document).on('change', '.iname', function(e){
                var stateID1 = $(this).val();    
                 var id1 = $(this).attr('id').split('e').pop();

                 var subt = $('#subtotalval').val();
                 var tot =  $('#totalval').val();
                   // alert(subt);
                   // alert(tot);
                     $.ajax({  
                    type: 'POST',  
                    url: 'Ajax/get_item.php', 
                    data: {bid: stateID1,subt: subt,tot: tot, },
                    success: function(data) {
                        console.log(data);
                        data = JSON.parse(data);
                       // datas =  JSON.parse(JSON.stringify(data));
                         
                         $('#price'+id1).val(data.sellprice);
                         $('#Qty'+id1).val(data.qty);
                         $('#totalprice'+id1).val(data.amt);

                       


                         $('#subtotal').text(data.newsubtotal);
                         $('#total').text(data.newtotal);

                         $('#subtotalval').val(data.newsubtotal);
                         $('#totalval').val(data.newtotal);
                     }
                    });
            });



     $(document).on('change', '.kmmname', function(e){
                var  iqty = $(this).val();    
                 var id1 = $(this).attr('id').split('e').pop();

                 var myString = id1;
               var id3 = myString[myString.length-1]

                 var subt = $('#subtotalval').val();
                 var tot =  $('#totalval').val();
                 var stateID1 =  $('#state'+id3).val();

                 var percen = $('#percen'+id3).val();

                 var discount = $('.dis'+id3).val();
                    
                   // alert(subt);
                   // alert(id3);
                   // alert(discount);
                   // alert(tot);
                   // alert(stateID1);
                   // alert(id1);
                     $.ajax({  
                    type: 'POST',  
                    url: 'Ajax/get_qty.php', 
                    data: {bid: stateID1,subt: subt,tot: tot,iqty: iqty,discount: discount,percen: percen },
                    success: function(data) {
                        // console.log(data);
                        data = JSON.parse(data);
                       // datas =  JSON.parse(JSON.stringify(data));
                        // alert(data);
                         // $('#tax').val(data.tax);
                         $('#price'+id3).val(data.sellprice);
                         $('#Qty'+id3).val(data.qty);
                         $('#totalprice'+id3).val(data.amt);

                          var icsum = 0;
                            $('.totprice').each(function()
                            {
                                icsum += parseFloat($(this).val());
                            });
                            $('#costotal').text(icsum);

                         
                         $('#costotalval').val(icsum);

                         $('#subtotal').text(icsum);
                         $('#total').text(icsum);

                         $('#subtotalval').val(icsum);
                         $('#totalval').val(icsum);

                         // $('#subtotal').text(data.newsubtotal);
                         // $('#total').text(data.newtotal);

                         // $('#subtotalval').val(data.newsubtotal);
                         // $('#totalval').val(data.newtotal);

                         

                         


                     }
                    });
            });



     $(document).on('change', '.ddiscount', function(e){
      var stateID1 = $(this).val();    
              var id1 = $(this).attr('id').split('e').pop();
                var disID1 = $(this).val(); 

                var percen = $('#percen'+id1).val();

                var dpri = $('#price'+id1).val();

                var dqty = $('#Qty'+id1).val();

                // var totalprice = $('#totalprice'+id1).val();

                 var totalprice = (dpri * dqty);

                 var subt = $('#subtotalval').val();
                 var tot =  $('#totalval').val();

                // alert(totalprice); 

                // alert(percen);  
                 
                  // alert(disID1);

                  // alert(subt);
                  // alert(tot);

                  

                  if(percen == 'per')
                  {
                      var ndisval = (totalprice*disID1/100);


                      // alert(ndisval);

                      var disval =  (totalprice)-(ndisval);
                  }
                  // else
                  // {
                  //     var disval = (subt - disID1);
                  // }

                  else if(percen == 'RS')
                  {
                      // var ndisval = (disID1/totalprice*100);
                      // var disval = (subt)-(ndisval);
                      var disval = (totalprice - disID1);
                       // var ntotp = (totalprice) - (ndisval);
                  }

                   

                   // alert(disval);

                   $('#totalprice'+id1).val(disval);
                   
                   var icsum = 0;
                            $('.totprice').each(function()
                            {
                                icsum += parseFloat($(this).val());
                            });

                            // alert(icsum)
                           

                         $('#subtotal').text(icsum);
                         $('#total').text(icsum);

                         $('#subtotalval').val(icsum);
                         $('#totalval').val(icsum);


                         

                         


                     
                    });
            


            // caalculation total price

            //   $(document).on('change', '.ddiscount', function(e){
            //     var stateID1 = $(this).val();    
            //   var id1 = $(this).attr('id').split('e').pop();
            //       // alert(stateID1);
            //       // alert(id1);
                
            //        var price = $('#price'+id1).val();
            //        var qty = $('#Qty'+id1).val();
            //        var tax = $('#tax'+id1).val();
            //         // alert(price);
            //         // alert(qty);
            //         // alert(tax);

            //          var a =  qty *  price ;
            //          // alert(a);

            //          var b = a * stateID1 / 100;
            //          // alert(b);

            //          var c = a - b ;
            //          // alert(c);

            //          var d = c * tax/100;
            //         // alert(d);

            //         var e = c + d ;

            //         // alert(e);
            //         // // alert(total);
            //          $('#totalprice'+id1).val(e);
                    
            // });



         $(document).on('change', '.kmmname', function(e){
                var stateID1 = $(this).val();    
                 
                var id2 = $(this).attr('id').split('e').pop();
                   // alert(stateID1);
                   // alert(id2);
                   var price = $('#price'+id2).val();
                    var barcode = $('#barcode'+id2).val();
                     // alert(price);
                   // alert(barcode);
                 $.ajax({  
                  type: 'POST',  
                  url: 'checkquantity.php', 
                  data: {cre_quantity: stateID1,barcode:barcode },
                  success: function(data) {
                     //  console.log(data);
                   // alert(data);
                     
                    if(data == 1)
                    {
                        alert('please enter less quanity');
                      
                    }
                    if(data == 2){
                    var discount = $('#ddiscount'+id2).val(); 
                    var total =  stateID1 *  price ;
                    // alert(total);
                    $('#totalprice'+id2).val(total);
                    
                     
                    }
                 }
      });   

        
            });

              $(document).on('change', '.discount', function(e){
                

                         var sum = 0;
    $('.totprice').each(function() {
        sum += Number($(this).val());
        // alert(sum);
        
        $('#ftotal').val(sum);
    }); 
               
          });   

 $(document).on('change', '.discount', function(e){
          $('input[name^="barcode"]').change(function() {

    var $current = $(this);
      // alert($current);
    $('input[name^="barcode"]').each(function() {
        if ($(this).val() == $current.val() && $(this).attr('id') != $current.attr('id'))
        {
            alert('duplicate found!');
        }

    });
  });
           });   

                      
      
 });  
 </script>

</body>


<!-- Mirrored from themesdesign.in/morvin/layouts/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 04 Apr 2022 13:25:42 GMT -->
</html>

MMCT - 2023