|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 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/public_html/inventory/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("include/db.php");;
?>
<!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'; ?>
<style>
.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;
}
.select2-container {
display: none !important;
}
.table-bordered {
border: 1px solid;
}
</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 Composite Item</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/com_item_add.php" enctype="multipart/form-data">
<div class="row">
<div class="row" style="margin-bottom: 25px;">
<div class="col-md-6">
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Name
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="iname" id="example-text-input">
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
SKU
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="sku" id="example-text-input">
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
unit
</label>
</div>
<div class="col-md-8">
<select class="form-select" id="validationCustom03" name="unit" >
<option selected="" disabled="" value="">Choose...</option>
<option value="box">box</option>
<option value="cm">cm</option>
<option value="dz">dz</option>
<option value="ft">ft</option>
<option value="g">g</option>
<option value="in">in</option>
<option value="kg">kg</option>
<option value="km">km</option>
<option value="lb">lb</option>
<option value="mg">mg</option>
<option value="ml">ml</option>
<option value="m">m</option>
<option value="PCS">PCS</option>
<option value="ltr">ltr</option>
</select>
<!-- <div class="reitem">
<input class="form-check-input" type="checkbox" name="ret_item" id="formCheck1" value="1" checked="">
<label class="form-check-label" for="formCheck1">
Returnable Item
</label>
</div> -->
</div>
</div>
</div>
<div class="col-md-6">
<div class="mb-3">
<label class="form-label">Attach File</label>
<input type="file" class="form-control " name="do_photo" id="do_photo" onchange="readThumb(this, 'thumb-error')" class="" accept="image/*" required="">
<div id="thumb" class="col-md-4"></div>
<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 class="mb-3">
<label class="form-check-label" for="formCheck1">
Warehouse
</label>
<select class="form-select" name="wname" >
<option value="">Choose</option>
<?php
$sql = "select * from tbl_warhouse ";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($marriage = mysqli_fetch_assoc($sql_res)){
?>
<option value="<?php echo $marriage['w_name'];?>"><?php echo $marriage['w_name'];?></option>
<?php } ?>
</select>
<!-- <i class="fa fa-plus" aria-hidden="true"><a href="#" data-bs-toggle="modal" data-bs-target="#myModal">Add new unit</a> </i> -->
</div>
<div class="mb-3">
<label class="form-label">Barcode</label>
<input type="file" class="form-control " name="do_photo1" id="do_photo" onchange="readThumb(this, 'thumb-error')" class="" accept="image/*" required="">
</div>
</div>
</div>
<br><br>
<div class="row" style="margin-bottom: 25px;">
<label class="form-check-label" for="formCheck1">
Associate Items
</label>
<table class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;" width="100%" >
<tr>
<th>Item Details </th>
<th>Quantity</th>
<th>Selling Price </th>
<th>Cost Price</th>
<th></th>
</tr>
<tr id="dynamic_field">
<td>
<select class="form-control item select2" name="state[]" id="state" >
<option value="">-- Select Item --</option>
<?php
$SQL = "SELECT * FROM tbl_item where type='goods'";
$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" class="qty form-control" min="1" value=""></td>
<td><input type="number" name="price[]" class="pprice form-control" id="price" min="0" value="" readonly=""></td>
<td><input type="text" class="totprice form-control" name="tprice[]" id="totalprice" value="" readonly=""></td>
<td>
<button type="button" class=" btn-md btn btn-success added"><i class="fa fa-plus"></i></button>
</td>
</tr>
<tr>
<td colspan="2" align="right">Total:</td>
<td>
<span id="saltotal"></span>
<input type="hidden" name="stotal" id="saltotalval" value="0">
</td>
<td>
<span id="costotal"></span>
<input type="hidden" name="ctotal" id="costotalval" value="0">
</td>
<!-- <td>
<button type="button" class=" btn-md btn btn-success gtot">Get Total</button>
</td> -->
</tr>
</table>
</div>
<br><br>
<div class="row" style="margin-bottom: 25px;">
<label class="form-check-label" for="formCheck1">
Associate Service
</label>
<table class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;" width="100%" >
<tr>
<th>Item Details </th>
<th>Quantity</th>
<th>Selling Price </th>
<th>Cost Price</th>
<th></th>
</tr>
<tr id="sdynamic_field">
<td>
<select class="form-control sitem select2" name="sstate[]" id="sstate" >
<option value="">-- Select Item --</option>
<?php
$SQL = "SELECT * FROM tbl_item where type='services'";
$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="sQty[]" id="sQty" class="sqty form-control" min="1" value=""></td>
<td><input type="number" name="sprice[]" class="spprice form-control" id="sprice" min="0" value="" readonly=""></td>
<td><input type="text" class="stotprice form-control" name="stprice[]" id="stotalprice" value="" readonly=""></td>
<td>
<button type="button" class=" btn-md btn btn-success sadded"><i class="fa fa-plus"></i></button>
</td>
</tr>
<tr>
<td colspan="2" align="right">Total:</td>
<td>
<span id="ssaltotal"></span>
<input type="hidden" name="sstotal" id="ssaltotalval" value="0">
</td>
<td>
<span id="scostotal"></span>
<input type="hidden" name="sctotal" id="scostotalval" value="0">
</td>
<!-- <td>
<button type="button" class=" btn-md btn btn-success gtot">Get Total</button>
</td> -->
</tr>
</table>
</div>
<br><br>
<div class="row" style="margin-bottom: 25px;">
<div class="col-md-6">
<div class="row">
<div class="col-md-3">
<label class="form-check-label" for="formCheck1">
Dimensions
(Length X Width X Height)
</label>
</div>
<div class="col-md-3">
<select class="form-select" id="validationCustom03" name="dim_type" required="">
<option value="cm">cm</option>
<option value="in">in</option>
</select>
</div>
<div class="col-md-2">
<input class="form-control" type="text" name="l" id="example-text-input">
</div>
<div class="col-md-2">
<input class="form-control" type="text" name="w" id="example-text-input">
</div>
<div class="col-md-2">
<input class="form-control" type="text" name="h" id="example-text-input">
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Manufa<br>cturer
</label>
</div>
<div class="col-md-8">
<select class="form-select" id="manfu" name="manfu" >
<option value="">Choose</option>
<?php
$sql = "select * from tbl_manufacturer ";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($marriage = mysqli_fetch_assoc($sql_res)){
?>
<option value="<?php echo $marriage['name'];?>"><?php echo $marriage['name'];?></option>
<?php } ?>
</select>
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
UPC
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="upc" id="example-text-input">
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
EAN
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="ean" id="example-text-input">
</div>
</div>
</div>
<div class="col-md-6">
<div class="row">
<div class="col-md-3">
<label class="form-check-label" for="formCheck1">
Weight
</label>
</div>
<div class="col-md-6">
<input class="form-control" type="text" name="wval" id="example-text-input">
</div>
<div class="col-md-3">
<select class="form-select" id="wunit" name="wunit" required="">
<option value="kg">kg</option>
<option value="g">g</option>
<option value="lb">lb</option>
<option value="oz">oz</option>
</select>
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Brand
</label>
</div>
<div class="col-md-8">
<select class="form-select" name="brand" >
<option value="">Choose</option>
<?php
$sql = "select * from tbl_brand ";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($marriage = mysqli_fetch_assoc($sql_res)){
?>
<option value="<?php echo $marriage['name'];?>"><?php echo $marriage['name'];?></option>
<?php } ?>
</select>
<!-- <i class="fa fa-plus" aria-hidden="true"><a href="#" data-bs-toggle="modal" data-bs-target="#myModal">Add new unit</a> </i> -->
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
MPN
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="mpn" id="example-text-input">
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
ISBN
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="isbn" id="example-text-input">
</div>
</div>
</div>
</div>
<hr>
<div class="row" style="margin-bottom: 25px;">
<div class="col-md-6">
<input class="form-check-input salecheck" type="checkbox" id="formCheck1" checked="">
<label class="form-check-label" for="formCheck1">
Sales Information
</label>
<br>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Selling Price
</label>
</div>
<div class="col-md-8">
<div class="input-group bootstrap-touchspin bootstrap-touchspin-injected"><input id="demo3_22sal" type="text" name="sale_price" class="form-control"><span class="input-group-btn input-group-append"><button class="btn btn-primary bootstrap-touchspin-up" type="button">INR</button></span></div>
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Account
</label>
</div>
<div class="col-md-8">
<select class="form-select" id="validationCustom03sal" name="s_account" required="">
<option value="Discount">Discount</option>
<option value="General Income">General Income</option>
<option value="Interest Income">Interest Income</option>
<option value="Late Fee Income">Late Fee Income</option>
<option value="Other Charges">Other Charges</option>
<option value="Sales">Sales</option>
<option value="Shipping Charge">Shipping Charge</option>
</select>
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Descrip<br>tion
</label>
</div>
<div class="col-md-8">
<textarea placeholder="Enter the description" name="s_description" id="ember1161sal" class="ember-text-area ember-view form-control"></textarea>
</div>
</div>
</div>
<div class="col-md-6">
<input class="form-check-input purcheck" type="checkbox" id="formCheck1" checked="">
<label class="form-check-label" for="formCheck1">
Purchase Information
</label>
<br>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Cost Price
</label>
</div>
<div class="col-md-8">
<div class="input-group bootstrap-touchspin bootstrap-touchspin-injected"><input id="cost_price" type="text" name="cost_price" class="form-control"><span class="input-group-btn input-group-append"><button class="btn btn-primary bootstrap-touchspin-up" type="button">INR</button></span></div>
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Account
</label>
</div>
<div class="col-md-8">
<select class="form-select" id="pursec" name="p_account" required="">
>
<?php
$sql = "select * from tbl_pur_acc ";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($marriage = mysqli_fetch_assoc($sql_res)){
?>
<option value="<?php echo $marriage['name'];?>"><?php echo $marriage['name'];?></option>
<?php } ?>
</select>
</div>
</div>
<br>
<div class="row">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Descrip<br>tion
</label>
</div>
<div class="col-md-8">
<textarea placeholder="Enter the description" name="p_description" id="ember1161pur" class="ember-text-area ember-view form-control" ></textarea>
</div>
</div>
</div>
</div>
<hr>
<div class="row trackitem" style="margin-bottom: 25px;">
<div class="col-md-6">
<input class="form-check-input trackite" type="checkbox" id="formCheck1" checked="">
<label class="form-check-label" for="formCheck1">
Track Inventory for this item
</label>
<span>You cannot enable/disable inventory tracking once you've created transactions for this item</span>
<br>
<br>
<div class="row trait">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Inventory <br> Account
</label>
</div>
<div class="col-md-8">
<select class="form-select" id="validationCustom03" name="inventory_acc" required="">
<option value="Inventory Asset">Inventory Asset</option>
<option value="Finished Goods">Finished Goods</option>
<option value="Work In Progress">Work In Progress</option>
</select>
</div>
</div>
<br>
<br>
<div class="row trait">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Opening Stock
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="openstock" id="example-text-input">
</div>
</div>
<br>
<div class="row trait">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Reorder Point
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="reorderpoint" id="example-text-input">
</div>
</div>
</div>
<div class="col-md-6">
<br>
<div class="row">
</div>
<br>
<!-- <div class="row trait">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Opening Stock <br>
Rate per Unit
</label>
</div>
<div class="col-md-8">
<input class="form-control" type="text" name="openingstock_per_unit" id="example-text-input">
</div>
</div> -->
<br>
<!-- <div class="row trait">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Preferred <br> Vendor
</label>
</div>
<div class="col-md-8">
<select class="form-select" id="validationCustom03" name="prevendor" required="">
<option value="choose">choose</option>
</select>
</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>
$(document).ready(function(){
// alert("o");
var i=0;
// $(document).on('change', '.added', function(){
$(".added").click(function(){
// alert("d");
// alert(i);
if(i <= 9)
{
// alert('p');
i++;
$('#dynamic_field').after('<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 where type='goods' ";$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="" readonly></td><td><input type="text" class="totprice form-control" name="tprice[]" id="totalprice'+i+'" value="" readonly></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 = 0 ;
// var tot = 0 ;
var subt = $('#saltotalval').val();
var tot = $('#costotalval').val();
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
$.ajax({
type: 'POST',
url: 'Ajax/get_com_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));
// alert(data);
// $('#tax').val(data.tax);
$('#price'+id1).val(data.sellprice);
$('#Qty'+id1).val(data.qty);
$('#totalprice'+id1).val(data.costprice);
$('#saltotalval').val(data.selingtotal);
$('#costotal').text(data.costtotal);
$('#saltotal').text(data.selingtotal);
$('#costotalval').val(data.costtotal );
}
});
});
$(document).on('change', '.kmmname', function(e){
var stateID1 = $(this).val();
var idq = $(this).attr('id').split('e').pop();
// var asubt = $('#saltotalval').val();
// var atot = $('#costotal').val();
var myString = idq;
var id3 = myString[myString.length-1]
//
// alert(asubt);
// alert(atot);
// alert(stateID1)
// var ek = $('.pprice').map((_,el) => el.value).get()
// alert(ek);
var itemname = $('#state'+id3).val();
$.ajax({
type: 'POST',
url: 'Ajax/qty_change.php',
data: {bid: itemname,qty: stateID1 },
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);
$('#totalprice'+id3).val(data.costprice);
var ipsum = 0;
$('.pprice ').each(function()
{
ipsum += parseFloat($(this).val());
});
// alert(sum);
$('#saltotalval').val(ipsum);
$('#saltotal').text(ipsum);
var icsum = 0;
$('.totprice').each(function()
{
icsum += parseFloat($(this).val());
});
$('#costotal').text(icsum);
$('#costotalval').val(icsum);
}
});
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
});
$(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 = (disID1/subt*100);
var disval = (subt)-(ndisval);
var ntotp = (totalprice) - (ndisval);
}
else
{
var disval = (subt - disID1);
var ntotp = (totalprice) - (disval);
}
if(percen == 'per')
{
var ndisval = (disID1/totalprice*100);
var disvals = (subt)-(ndisval);
// var ntotp = (totalprice) - (ndisval);
}
else
{
var disvals = (totalprice - disID1);
// var ntotp = (totalprice) - (disval);
}
alert(disval);
$('#totalprice'+id1).val(disvals);
$('#subtotal').text(disval);
$('#total').text(disval);
$('#subtotalval').val(disval);
$('#totalval').val(disval);
});
$(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>
<!-- services add -->
<script>
$(document).ready(function(){
// alert("o");
var i=0;
// $(document).on('change', '.added', function(){
$(".sadded").click(function(){
// alert("d");
if(i <= 9)
{
i++;
$('#sdynamic_field').after('<tr id="rows'+i+'"><td> <select class="form-control siname select2" name="sstate[]" id="sstate'+i+'" ><option value="">-- Select Item --</option> <?php $SQL = "SELECT * FROM tbl_item where type='services' ";$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="sQty[]" id="sQty'+i+'" class="skmmname form-control" min="0" value=""></td><td><input type="number" name="sprice[]" class="spprice form-control" id="sprice'+i+'" value="" readonly></td><td><input type="text" class="stotprice form-control" name="stprice[]" id="stotalprice'+i+'" value="" readonly></td><td><button type="button" name="remove" id="'+i+'" class="btn-md btn btn-danger btn_removes">X</button></td></tr>');
$('.select2').select2();
}
else{
// alert('o');
}
});
$(document).on('click', '.btn_removes', function(){
var button_id = $(this).attr("id");
$('#rows'+button_id+'').remove();
});
$(document).on('change', '.siname', function(e){
var stateID1 = $(this).val();
var id1 = $(this).attr('id').split('e').pop();
// var subt = 0 ;
// var tot = 0 ;
var subt = $('#ssaltotalval').val();
var tot = $('#scostotalval').val();
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
$.ajax({
type: 'POST',
url: 'Ajax/get_com_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));
// alert(data);
// $('#tax').val(data.tax);
$('#sprice'+id1).val(data.sellprice);
$('#sQty'+id1).val(data.qty);
$('#stotalprice'+id1).val(data.costprice);
$('#ssaltotalval').val(data.selingtotal);
$('#scostotalval').val(data.costtotal);
$('#ssaltotal').text(data.selingtotal);
$('#scostotal').text(data.costtotal );
}
});
});
$(document).on('change', '.skmmname', function(e){
var stateID1 = $(this).val();
var idq = $(this).attr('id').split('e').pop();
var myString = idq;
var id3 = myString[myString.length-1]
// alert(id3);
var itemname = $('#sstate'+id3).val();
$.ajax({
type: 'POST',
url: 'Ajax/qty_change.php',
data: {bid: itemname,qty: stateID1 },
success: function(data) {
// console.log(data);
data = JSON.parse(data);
// datas = JSON.parse(JSON.stringify(data));
// alert(data);
// $('#tax').val(data.tax);
$('#sprice'+id3).val(data.sellprice);
$('#stotalprice'+id3).val(data.costprice);
var sipsum = 0;
$('.spprice').each(function()
{
sipsum += parseFloat($(this).val());
});
// alert(sum);
$('#ssaltotalval').val(sipsum);
$('#ssaltotal').text(sipsum);
var sicsum = 0;
$('.stotprice').each(function()
{
sicsum += parseFloat($(this).val());
});
$('#scostotalval').val(sicsum);
$('#scostotal').text(sicsum);
}
});
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
});
$(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 = (disID1/subt*100);
var disval = (subt)-(ndisval);
var ntotp = (totalprice) - (ndisval);
}
else
{
var disval = (subt - disID1);
var ntotp = (totalprice) - (disval);
}
if(percen == 'per')
{
var ndisval = (disID1/totalprice*100);
var disvals = (subt)-(ndisval);
// var ntotp = (totalprice) - (ndisval);
}
else
{
var disvals = (totalprice - disID1);
// var ntotp = (totalprice) - (disval);
}
alert(disval);
$('#totalprice'+id1).val(disvals);
$('#subtotal').text(disval);
$('#total').text(disval);
$('#subtotalval').val(disval);
$('#totalval').val(disval);
});
$(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>
<script type="text/javascript">
$(".purcheck").click(function() {
if($(this).is(":checked")) {
$(".trackitem").show();
$('#cost_price').attr('readonly', false);
$('#pursec').attr("disabled", false);
$('#ember1161pur').attr('readonly', false);
} else {
$(".trackitem").hide();
$('#cost_price').attr('readonly', true);
$('#pursec').attr("disabled", true);
$('#ember1161pur').attr('readonly', true);
}
});
</script>
<script type="text/javascript">
$(".salecheck").click(function() {
if($(this).is(":checked")) {
$(".trackitem").show();
$('#demo3_22sal').attr('readonly', false);
$('#validationCustom03sal').attr("disabled", false);
$('#ember1161sal').attr('readonly', false);
} else {
$(".trackitem").hide();
$('#demo3_22sal').attr('readonly', true);
$('#validationCustom03sal').attr("disabled", true);
$('#ember1161sal').attr('readonly', true);
}
});
</script>
<script type="text/javascript">
$(".trackite").click(function() {
if($(this).is(":checked")) {
$(".trait").show();
} else {
$(".trait").hide();
}
});
</script>
<script type="text/javascript">
$("#services").click(function() {
if($(this).is(":checked")) {
// alert('abc');
$(".reitem").hide();
$(".trackitem").hide();
} else {
// alert('abcd');
}
});
</script>
<script type="text/javascript">
$("#goods").click(function() {
if($(this).is(":checked")) {
$(".reitem").show();
$(".trackitem").show();
} else {
}
});
</script>
<script type="text/javascript">
$(document).on('change', '.item', function(e){
var stateID1 = $(this).val();
var id1 = $(this).attr('id').split('e').pop();
// var subt = 0 ;
// var tot = 0 ;
var subt = $('#saltotalval').val();
var tot = $('#costotalval').val();
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
$.ajax({
type: 'POST',
url: 'Ajax/get_com_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));
// alert(data);
// $('#tax').val(data.tax);
$('#price').val(data.sellprice);
$('#Qty').val(data.qty);
$('#totalprice').val(data.costprice);
$('#saltotalval').val(data.selingtotal);
$('#costotal').text(data.costtotal);
$('#saltotal').text(data.selingtotal);
$('#costotalval').val(data.costtotal );
}
});
});
</script>
<script type="text/javascript">
$(document).on('change', '.sitem', function(e){
var stateID1 = $(this).val();
var id1 = $(this).attr('id').split('e').pop();
// var subt = 0 ;
// var tot = 0 ;
var subt = $('#ssaltotalval').val();
var tot = $('#scostotalval').val();
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
$.ajax({
type: 'POST',
url: 'Ajax/get_com_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));
// alert(data);
// $('#tax').val(data.tax);
$('#sprice').val(data.sellprice);
$('#sQty').val(data.qty);
$('#stotalprice').val(data.costprice);
$('#ssaltotalval').val(data.selingtotal);
$('#scostotalval').val(data.costtotal);
$('#ssaltotal').text(data.selingtotal);
$('#scostotal').text(data.costtotal );
}
});
});
</script>
<script type="text/javascript">
$(document).on('change', '.qty', function(e){
var stateID1 = $(this).val();
var itemname = $('.item').val();
// var subt = $('#saltotalval').val();
// var tot = $('#costotal').val();
$.ajax({
type: 'POST',
url: 'Ajax/qty_change.php',
data: {bid: itemname,qty: stateID1 },
success: function(data) {
// console.log(data);
data = JSON.parse(data);
// datas = JSON.parse(JSON.stringify(data));
// alert(data);
// $('#tax').val(data.tax);
$('#price').val(data.sellprice);
$('#totalprice').val(data.costprice);
var ipsum = 0;
$('.pprice').each(function()
{
ipsum += parseFloat($(this).val());
});
var icsum = 0;
$('.totprice').each(function()
{
icsum += parseFloat($(this).val());
});
// alert(sum);
$('#saltotalval').val(ipsum);
$('#saltotal').text(ipsum);
$('#costotal').val(icsum);
$('#costotal').text(icsum);
}
});
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
});
</script>
<script type="text/javascript">
$(document).on('change', '.sqty', function(e){
var stateID1 = $(this).val();
var itemname = $('.sitem').val();
$.ajax({
type: 'POST',
url: 'Ajax/qty_change.php',
data: {bid: itemname,qty: stateID1 },
success: function(data) {
// console.log(data);
data = JSON.parse(data);
// datas = JSON.parse(JSON.stringify(data));
// alert(data);
// $('#tax').val(data.tax);
$('#sprice').val(data.sellprice);
$('#stotalprice').val(data.costprice);
var sipsum = 0;
$('.spprice').each(function()
{
sipsum += parseFloat($(this).val());
});
// alert(sum);
$('#ssaltotalval').val(sipsum);
$('#ssaltotal').text(sipsum);
var sicsum = 0;
$('.stotprice').each(function()
{
sicsum += parseFloat($(this).val());
});
$('#scostotalval').val(sicsum);
$('#scostotal').text(sicsum);
}
});
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
});
</script>
<!-- item add -->
<!-- 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>