schema DataKategoriBarang {
  label string required
  deskripsi string
}
schema DataSatuanBarang {
  label string required
}

schema DataKonversiSatuan {
  id_satuan_konversi number
  data_satuan_konversi schema.DataSatuanBarang
  kuantitas_dasar number required
}

schema BarangPayload {
  id_satuan_utama number
  data_satuan_utama schema.DataSatuanBarang
  id_kategori number
  data_kategori schema.DataKategoriBarang
  nama string required
  harga number required
  deskripsi string
  foto string
  list_konversi_satuan array schema.DataKonversiSatuan required
}


schema COAPayload {
  id_header number
  kode string required
  nama string required
  deskripsi string
  aktif boolean required
}


table Penjualan {
  id bigint pk inc notnull
  id_admin Admin.id notnull
  diskon bigint notnull default=0
  total_harga bigint notnull
  pajak bigint notnull
  metode_pembayaran varchar(255) notnull
  created_at timestamp notnull
  cancelled_at timestamp
}

table ItemPenjualan {
  id bigint pk inc notnull
  id_penjualan Penjualan.id notnull
  id_barang Barang.id notnull
  id_satuan Satuan.id notnull
  kuantitas bigint notnull
}


{"id":"root","label":"Akunting","icon":"https://adf-lang.com/logo.png","data":{"type":"folder"}}

enum JenisAdmin {
  AKUNTING
  POS
}

table Admin {
  id bigint pk inc notnull
  jenis JenisAdmin notnull default=JenisAdmin.AKUNTING
  fullname varchar(255) notnull
  username varchar(255) notnull
  password varchar(255) notnull
  created_at timestamp notnull
}


table KategoriBarang {
  id bigint pk inc notnull
  label varchar(255) notnull
  deskripsi text
}

table Satuan {
  id bigint pk inc notnull
  label varchar(255) notnull
}

table Barang {
  id bigint pk inc notnull
  id_satuan_utama Satuan.id notnull
  id_kategori KategoriBarang.id
  nama varchar(255) notnull
  harga bigint notnull
  deskripsi text
  foto varchar(512)
  created_at timestamp notnull
  deleted_at timestamp
}

table KonversiSatuan {
  id bigint pk inc notnull
  id_barang Barang.id notnull
  id_satuan_konversi Satuan.id notnull
  kuantitas_dasar bigint
}

table StokBarang {
  id bigint pk inc notnull
  id_barang Barang.id notnull
  stok bigint notnull default=0
  updated_at timestamp notnull
}


table COA {
  id bigint pk inc notnull
  id_header COA.id
  kode varchar(15) notnull
  nama varchar(255) notnull
  deksripsi text
  aktif boolean notnull default=true
}

table Jurnal {
  id bigint pk inc notnull
  deskripsi text
  nomor_referensi varchar(255)
  tanggal date notnull
  created_at timestamp notnull
  id_ref_penjualan Penjualan.id
  id_ref_pembelian Pembelian.id
}

table ItemJurnal {
  id bigint pk inc notnull
  id_coa COA.id notnull
  id_jurnal Jurnal.id notnull
  nomor_referensi varchar(255)
  debit bigint notnull default=0
  kredit bigint notnull default=0
  deskripsi text
}


table Pemasok {
  id bigint pk inc notnull
  nama varchar(512) notnull
}

table Pembelian {
  id bigint pk inc notnull
  id_admin Admin.id notnull
  id_pemasok Pemasok.id notnull
  diskon bigint notnull default=0
  total_harga bigint notnull
  pajak bigint notnull
  created_at timestamp notnull
  cancelled_at timestamp
}

table ItemPembelian {
  id bigint pk inc notnull
  id_pembelian Pembelian.id notnull
  id_barang Barang.id notnull
  id_satuan Satuan.id notnull
  harga_beli_satuan bigint notnull
  kuantitas bigint notnull
  kondisi_barang text
}


// >>> COA
api get /coa {
  description data coa
  headers {
    authorization string required
  }
  query {
    q string
    limit number
    offset number
  }
  return schema GetCOAData {
    total number required
    data array table.COA required
  } required
}

api post /coa {
  description tambah coa
  headers {
    authorization string required
  }
  body {
    data schema.COAPayload required
  }
  return table.COA required
}

api get /coa/:kode {
  description detail coa
  headers {
    authorization string required
  }
  path {
    kode string required
  }
  return table.COA required
}

api put /coa/:kode {
  description update coa
  headers {
    authorization string required
  }
  path {
    kode string required
  }
  body {
    data schema.COAPayload required
  }
  return table.COA required
}

api delete /coa/:kode {
  description hapus coa
  headers {
    authorization string required
  }
  path {
    kode string required
  }
  return table.COA required
}

// >>> Jurnal
api get /jurnal {
  description data jurnal
  headers {
    authorization string required
  }
  query {
    q string
    limit number
    offset number
  }
  return schema GetJurnalData {
    total number required
    data array table.Jurnal required
  } required
}

api post /jurnal {
  description tambah jurnal
  headers {
    authorization string required
  }
  body {
    data schema.JurnalPayload required
  }
  return table.Jurnal required
}

api get /jurnal/:id {
  description detail jurnal
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Jurnal required
}

api put /jurnal/:id {
  description update jurnal
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.JurnalPayload required
  }
  return table.Jurnal required
}

api delete /jurnal/:id {
  description hapus jurnal
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Jurnal required
}


schema JurnalPayload {
  deskripsi string
  nomor_referensi string

  // ISO 8601
  tanggal string required

  list_item array schema ItemJurnalPayload {
    id_coa number required
    nomor_referensi string
    debit number required
    kredit number required
    deskripsi string
  } required
}


api post /login {
  description login admin dengan username dan password
  body {
    username string required
    password string required
  }
  return schema LoginResponse {
    token string required
    data table.Admin required
  } required
}

api get /profile {
  description data profile user
  headers {
    authorization string required
  }
  return table.Admin required
}



api get /barang {
  description data barang
  headers {
    authorization string required
  }
  query {
    q string
    limit number
    offset number
  }
  return schema GetBarangData {
    total number required
    data array table.Barang required
  } required
}

api post /barang {
  description tambah barang
  headers {
    authorization string required
  }
  body {
    data schema.BarangPayload required
  }
  return table.Barang required
}

api get /barang/:id {
  description detail barang
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Barang required
}

api put /barang/:id {
  description update barang
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.BarangPayload required
  }
  return table.Barang required
}

api delete /barang/:id {
  description hapus barang
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Barang required
}
