如何为两个不同的参数分配条目类型

Question

我想问我如何在数组中为应收账款分配条目类型10和应付账款分配条目类型20，因为我的api使用xml，所以我需要将数组传递给它。

这是我的数据库外观

NAME|Purchase|  Sales | Tax | Discount | EntryType|
AR  | 303-00 | 200-00 | 6.0 |    3.0   |    10    |
AP  | 200-00 | 800-00 | 4.0 |    2.0   |    20    |

当我插入时，它将保存到同一个表中，但是用条目类型区分它们。我没有在数组中传递数据。我不知道如何给它们赋具体的值。有人能帮帮我吗?这个问题已经困扰了我很久了。

$(document).ready(function() {
$("#btnUpdateAccControl").click(function(e) {
var arrayItem = [];
var sArrayItem = "";
// at here how can I assign entry type 10 for the account receivable and 20 for account payable in array, because my api is using xml so i need to pass array into it.
$(.row),function(index, value) {
let item = {
Purchase: $(".col-purchase").val(),
Sales: $(".col-sales").val(),
Tax: $(".col-tax").val(),
Discount: $(".col-discount").val(),
}
arrayItem.push(item)
}); console.log(arrayItem)
sArrayItem = JSON.stringify(arrayItem);
$.ajax({
type: "POST",
url: "UpdateAccControl",
data: JSON.stringify({
sArrayItem
}),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(result) {
if (result.d.indexOf(".aspx") != -1)
window.location.href = result.d;
else
showPopup(result);
},
failure: function(response) {
alert(response.d);
}
});
});

<!-- Row -->
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="card custom-card">
<div class="card-body">
<div class="row">
<div class="col-md-6">
<h5>Account Receivable</h5>
<hr />
<div class="form-group text-left">
<label>Purchase</span></label>
<input class="form-control col-purchase" type="text" required>
</div>
<div class="form-group text-left">
<label>Sales</label>
<input class="form-control col-sales" type="text" required>
</div>
<div class="form-group text-left">
<label>Tax</label>
<input class="form-control col-tax" type="text" required>
</div>
<div class="form-group text-left">
<label>Discount</label>
<input class="form-control col-discount" type="text" required>
</div>
</div>
<div class="col-md-6">
<h5>Account Payable</h5>
<hr />
<div class="form-group text-left">
<label>Purchase</span></label>
<input class="form-control col-purchase" type="text" required>
</div>
<div class="form-group text-left">
<label>Sales</label>
<input class="form-control col-sales" type="text" required>
</div>
<div class="form-group text-left">
<label>Tax</label>
<input class="form-control col-tax" type="text" required>
</div>
<div class="form-group text-left">
<label>Discount</label>
<input class="form-control col-discount" type="text" required>
</div>
</div>
</div>
<div class="card-footer">
<div class="btn ripple btn-info" id='btnUpdateAccControl'><i class="fe fe-plus-circle"></i>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- End Row -->

Answer 1

您可以检查col-md-6中h5元素的值是否为Account Receivable，这取决于将10或20赋值给EntryType。

演示代码 :

$("#btnUpdateAccControl").click(function(e) {
var arrayItem = [];
var sArrayItem = "";
//loop through each divs
$(" .card-body .row .col-md-6").each(function(index, value) {
//use this .find to get only required value one col-md-6
arrayItem.push({
Purchase: $(this).find(".col-purchase").val(),
Sales: $(this).find(".col-sales").val(),
Tax: $(this).find(".col-tax").val(),
Discount: $(this).find(".col-discount").val(),
EntryType: $(this).find("h5:first").text().trim() == "Account Receivable" ? 10 : 20 //check if h5 is acc rec or payable
})
});
console.log(arrayItem)
//other codes..
});

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="card custom-card">
<div class="card-body">
<div class="row">
<div class="col-md-6">
<h5>Account Receivable</h5>
<hr />
<div class="form-group text-left">
<label><span>Purchase</span></label>
<input class="form-control col-purchase" type="text" required>
</div>
<div class="form-group text-left">
<label>Sales</label>
<input class="form-control col-sales" type="text" required>
</div>
<div class="form-group text-left">
<label>Tax</label>
<input class="form-control col-tax" type="text" required>
</div>
<div class="form-group text-left">
<label>Discount</label>
<input class="form-control col-discount" type="text" required>
</div>
</div>
<div class="col-md-6">
<h5>Account Payable</h5>
<hr />
<div class="form-group text-left">
<label><span>Purchase</span></label>
<input class="form-control col-purchase" type="text" required>
</div>
<div class="form-group text-left">
<label>Sales</label>
<input class="form-control col-sales" type="text" required>
</div>
<div class="form-group text-left">
<label>Tax</label>
<input class="form-control col-tax" type="text" required>
</div>
<div class="form-group text-left">
<label>Discount</label>
<input class="form-control col-discount" type="text" required>
</div>
</div>
</div>
<div class="card-footer">
<div class="btn ripple btn-info" id='btnUpdateAccControl'><i class="fe fe-plus-circle">Send</i>
</div>
</div>
</div>
</div>
</div>
</div>