schema DataProduk {
  produk table.Produk required
  list_varian array table.VarianProduk required
  list_foto_produk array table.FotoProduk required
}


api get /produk {
  query {
    limit number
    query number
    filter_keyword string
    filter_harga_min number
    filter_harga_max number
    filter_id_kategori number
  }
  return schema ProductResult {
    total number required
    data array schema.DataProduk required
  } required
}

api get /produk/:id {
  path {
    id number required
  }
  return schema.DataProduk required
}

api get /kategori-produk {
  return array table.Kategori required
}


api get /admin/pr/satuan {
  headers {
    authorization string required
  }
  return schema AdminPRSatuanResult {
    total number required
    data array table.Satuan required
  } required
}

api get /admin/pr/satuan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Satuan required
}

api post /admin/pr/satuan {
  headers {
    authorization string required
  }
  body {
    data schema AdminPRSatuanPayload {
      label string required
    } required
  }
  return table.Satuan required
}

api put /admin/pr/satuan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPRSatuanPayload required
  }
  return table.Satuan required
}

api delete /admin/pr/satuan/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Satuan required
}


api get /admin/pr/kategori {
  headers {
    authorization string required
  }
  return schema AdminPRKategoriResult {
    total number required
    data array table.Kategori required
  } required
}

api get /admin/pr/kategori/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Kategori required
}

api post /admin/pr/kategori {
  headers {
    authorization string required
  }
  body {
    data schema AdminPRKategoriPayload {
      label string required
      icon_url string
    } required
  }
  return table.Kategori required
}

api put /admin/pr/kategori/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPRKategoriPayload required
  }
  return table.Kategori required
}

api delete /admin/pr/kategori/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Kategori required
}


api get /admin/pr/produk {
  headers {
    authorization string required
  }
  return schema AdminPRProdukResult {
    total number required
    data array schema.DataProduk required
  } required
}

api get /admin/pr/produk/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return schema.DataProduk required
}

api post /admin/pr/produk {
  headers {
    authorization string required
  }
  body {
    data schema AdminPRProdukPayload {
      nama string required
      deskripsi string
      harga number required
      list_foto array schema AdminPRFotoPayload {
        imgurl string required
        urutan number
      } required
      list_varian array schema AdminPRVarianPayload {
        nama string required
        harga number required
        list_foto array schema.AdminPRFotoPayload required
      } required
    } required
  }
  return schema.DataProduk required
}

api put /admin/pr/produk/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPRProdukPayload required
  }
  return schema.DataProduk required
}

api delete /admin/pr/produk/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Produk required
}


table Kategori {
  id bigint pk notnull inc
  label varchar(200) notnull
  icon_url varchar(100)
  created_at timestamp notnull
}

table Satuan {
  id bigint pk notnull inc
  label varchar(50) notnull
  created_at timestamp notnull
}

table KonversiSatuan {
  id bigint pk notnull inc
  id_produk Produk.id notnull
  id_satuan Satuan.id notnull
  nilai_satuan_dasar bigint notnull
}

table Produk {
  id bigint pk notnull inc

  // satuan dasar, gunakan sebagai acuan
  // untuk konversi satuan
  id_satuan Satuan.id notnull
  id_kategori Kategori.id notnull
  
  nama varchar(200) notnull
  deskripsi text
  harga bigint notnull

  created_at timestamp notnull
}

table VarianProduk {
  id bigint pk notnull inc
  id_produk Produk.id notnull
  nama varchar(200) notnull

  // jika harga berikut null gunakan harga produk
  harga bigint

  created_at timestamp notnull
}

table FotoProduk {
  id bigint pk notnull inc
  id_varian_produk VarianProduk.id
  id_produk Produk.id notnull
  urutan int notnull default=0
  imgurl varchar(200) notnull
  created_at timestamp notnull
}
