To meet my specific requirements, I am tasked with creating two separate tables that will contain the same number of rows but different data. The first table will display Item Information, while the second table will provide consolidated information about the items, such as the number of items sold in the last week and the current inventory levels.
For the first table, I have chosen to utilize jQuery datatable due to the need for sorting functionality which is easily achievable with it. The second table will be a standard table created once all the item data has been loaded into the first table.
Take a look at this example :
$(document).ready(function(){
var displayShopColumns = [
"QOH",
"PO",
"Sold LW",
"QTY",
"Cost"
];
var shopColumns = [
"qoh",
"po",
"sold",
"qty",
""
];
var arr=[
{'itemCread':'202/09/01','imageUrl':'https://picsum.photos/seed/picsum/200/300','description':'test1','manSKU':'654789','moq':'10','cost':'12.36','Retail':'12.36','margin':'0','Category':'Test Category 1','subCat1':'Sub Category 1','subCat2':'Sub Category...
...
</pre>
<pre>
... </tbody>
</table>
</div>
<div id="ddd" class="col-md-3">
</div>
</div>
</body>
</html>