我有下表&需要获得以下输出。
+---------+-----------+------+----------+------------+
| item_id | item_name | qty | status | unit_price |
+---------+-----------+------+----------+------------+
| 1 | A | 161 | purchase | 7.50 |
| 2 | A | 108 | purchase | 8.50 |
| 3 | B | 100 | purchase | 10.00 |
| 4 | A | -74 | issue | 7.50 |
| 5 | A | -100 | issue | 8.50 |
| 6 | B | -24 | issue | 10.00 |
+---------+-----------+------+----------+------------+
所需输出
+-----------+-----+------------+
| item_name | qty | unit_price |
+-----------+-----+------------+
| A | 87 | 7.50 |
| A | 8 | 8.50 |
| B | 76 | 10.00 |
+-----------+-----+------------+
我使用了以下查询。
select item_name, qty, unit_price from stock group by unit_price
JavaScript
var jData = JSON.parse(data);
if (jData.status == true) {
jData.data.forEach(data => {
$('#request_table').append('<tr>' +
'<td ><span id="product" >' + jData.data[0].item_name + '</span>' +
'<input type="hidden" id="item_id[]" name="item_id[]" value="' + jData.data[0].item_id + '">' +
'</td>' +
'<td class="text-center">' + jData.data[0].qty + '</td>' +
'<td class="text-center"><input class="form-control text-right" disabled id="sales_price[]" name="sales_price[]" value="' + jData.data[0].up+ '"></td>' +
'<td class="text-center" ><i class="fa fa-remove remove" style="cursor: pointer"></i></td>' +
'</tr>');
})
}
Outs
+-----------+-----+------------+
| item_name | qty | unit_price |
+-----------+-----+------------+
| A | 87 | 7.50 |
| A | 87 | 7.50 |
+-----------+-----+------------+
但没有得到预期的产出。在我的查询中可以修改什么来实现这一点。有人能帮我吗?
如果只访问数据数组的第一个索引,这将不起作用
以下内容应适用于
var jData = JSON.parse(data);
if (jData.status == true)
{
jData.data.forEach(objItem => {
$('#request_table').append('<tr>' +
'<td ><span id="product" >' + objItem.item_name + '</span>' +
'<input type="hidden" id="item_id[]" name="item_id[]" value="' + objItem.item_id + '">' +
'</td>' +
'<td class="text-center">' + objItem.qty + '</td>' +
'<td class="text-center"><input class="form-control text-right" disabled id="sales_price[]" name="sales_price[]" value="' + objItem.up+ '"></td>' +
'<td class="text-center" ><i class="fa fa-remove remove" style="cursor: pointer"></i></td>' +
'</tr>'
);
});
}