stocktable | Quick and extendable stock comparision tool | Business library

im using Laravel 6.2

I want to make a inventory database system. i have 2 modals Produk and Stock. in that case, i want to input data p_name and sku from ProdukTable and place it into StockTable using Eloquent ORM.

I tried using belongsTo(),

Here's my modal Produk code

i wanna ask how to add get data from ProdukTable as p_nama into StockTable ? Im using Laravel 6.2 instead. what should i do ?

Model : App\Produk.php

I want to display a Table in crystal reports but its show only the last column, this is my code :

Hi I have two tabels PURCHASE and DELIVERY where by I want to show the remaining quantity in another table 'STOCK'. Below is the output I got from my STOCK table and the code I did, but the calculation is wrong. Can anyone help me with this?

My table data has nested objects, so I need to use a v-slot to render it correctly on a table. The thing is that the table columns depend on the lenght of another array.

I tried using a v-for outside my v-slot, but then I get an error telling me that the v-slots need to be directly under the root level inside its component.

i want to find the max ID in my Ms-access db ! im trying to do that with this simple code but i got error because is datatable and cannot converted to string ! how to solve this ?

In using more than 1 index field like this: stocktable.INDEXFIELDnames:='NUMBER;PRE';

I get the error: "No index for fields 'NUMBER;PRE'.

Using them separately works.

Can anyone help please?

Thanks.

I display the stock of items composing a product, the user must be able to update the sizes and quantities of these items in a DataGridView for each item after selecting a product.

I create the DataGridViews and event allowing to update the database programatically because each product can be composed of 1 up to 5 items.

The following is the exact implementation from https://docs.oracle.com/cd/B28359_01/appdev.111/b28425/pipelined_example.htm#CHDHDHEE

Let's assume we have the following table deifinition: