drop view if exists dashboard_jenis_barang;

--gopg:split

CREATE VIEW dashboard_jenis_barang AS
SELECT
    jenis_barangs.id AS j_id,
    NULL :: text AS toko_id,
    jenis_barangs.nama,
    0 AS total_produk,
    0.0 AS total_berat
FROM
    jenis_barangs;