Used:

• scala play framework 2.6
• anorm
• spoiwo Database : SQLite

it's so simple! Just write.

$ sbt run

in your terminal in your project directory, and VOILA! It's running and you can try it

1. table jumlah_barang columns: -sku varchar -item_name varchar -qty int 2.table barang_masuk columns:

• waktu datetime, -sku varchar -item_name varchar -jumlah_pemesanan int, -jumlah_diterima int -harga_beli int -total int -catatan text -id Integer autoincrement 3.table barang_keluar
• waktu datetime, -sku varchar -item_name varchar -jumlah_keluar int -harga_jual int -total int -catatan text -id Integer autoincrement Toko Ijah Inventory Activities: ========================== Postman url : import this link for easier way checking this API. https://www.getpostman.com/collections/693dd269bbcf99cdf24e.

1. Store jumlah barang routes : /create/jumlah-barang method : POST input example:

{
    "sku":"abcd",
    "item_name":"baju monyet baru",
    "jumlah":105
}

2. Store barang masuk routes : /create/barang-masuk. method : POST. input example:

{
    "sku":"abc",
    "item_name":"baju",
    "waktu": "2018-01-01 01:00:00",
    "pemesanan":100,
    "terima":99,
    "beli":14000,
    "kwitansi":"ID-0001",
    "catatan": "bagus kok barangnya, ga da masalah"
 }

3. Store barang keluar. routes : /create/barang-keluar. method : POST. input example :

{
    "sku":"abc",
    "item_name":"baju",
    "waktu": "2018-01-01 01:00:00",
    "keluar":99,
    "jual":14000,
    "catatan": "Pesanan ID-0001"
}

4. show laporan penjualan barang. routes : /laporan/penjualan?ds=<yyyy-mm-dd>&de=<yyyy-mm-dd>. method : GET.

5. show laporan nilai barang. routes : /laporan/nilai-barang. method : GET.

6. export laporan penjualan barang. routes : /export/penjualan. method : GET.

7. export laporan nilai barang. routes : /export/nilai-barang. method : GET.

8. import catatan jumlah barang. routes : /import/jumlah-barang?filename=<file name only>

9. import catatan barang masuk. routes : /import/barang-masuk?filename=<file name only>

10. import catatan barang keluar. routes : /import/barang-keluar?filename=<file name only>