table Warehouse {
  id bigint notnull inc pk
  is_default boolean default=false
  name varchar(200) notnull
  address text
  created_at timestamp notnull
}

table ProductStock {
  id bigint notnull inc pk
  id_product Product.id notnull
  id_warehouse Warehouse.id notnull

  // as per basic unit
  quantity bigint notnull default=0

  created_at timestamp notnull
  updated_at timestamp
}


api get /admin/capability {
  headers {
    authorization string required
  }
  return schema AdminCapabilityResult {
    total number required
    data array table.Capability required
  } required
}

api get /admin/capability/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Capability required
}

api post /admin/capability {
  headers {
    authorization string required
  }
  body {
    data schema AdminCapabilityPayload {
      code string required
    } required
  }
  return table.Capability required
}

api put /admin/capability/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminCapabilityPayload required
  }
  return table.Capability required
}

api delete /admin/capability/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Capability required
}


api get /admin/category {
  headers {
    authorization string required
  }
  return schema AdminCategoryResult {
    total number required
    data array table.Category required
  } required
}

api get /admin/category/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Category required
}

api post /admin/category {
  headers {
    authorization string required
  }
  body {
    data schema AdminCategoryPayload {
      label string required
      icon_url string
    } required
  }
  return table.Category required
}

api put /admin/category/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminCategoryPayload required
  }
  return table.Category required
}

api delete /admin/category/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Category required
}


api post /login {
  description login dengan username
  body {
    username string required
    password string required
  }
  return schema AuthResponse {
    token string required
    user table.User required
  }
}


table Category {
  id bigint pk notnull inc
  label varchar(200) notnull
  created_at timestamp notnull
}

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

table UnitConversion {
  id bigint pk notnull inc
  id_product Product.id notnull
  id_unit_to_convert Unit.id notnull
  basic_unit_value bigint notnull
}

table Product {
  id bigint pk notnull inc

  // basic unit, use as reference to unit conversion
  id_unit Unit.id notnull

  id_category Category.id notnull
  
  name varchar(200) notnull
  price bigint notnull
  imgurl varchar(200)
  description text

  created_at timestamp notnull
}


table Vendor {
  id bigint pk notnull inc
  name varchar(200) notnull
  phone_number varchar(20)
  email varchar(200)
  address text
  created_at timestamp notnull
}

table Purchase {
  id bigint pk notnull inc
  id_vendor Vendor.id notnull
  id_user User.id notnull

  // derivative value from total purchase item value
  amount bigint notnull
  invoice_number varchar(100) notnull
  
  tax_amount bigint notnull default=0

  created_at timestamp notnull
}

table PurchaseItem {
  id bigint pk notnull inc
  id_product Product.id notnull
  id_purchase Purchase.id notnull
  quantity bigint notnull

  // must be the basic unit or present on unit conversion
  id_unit Unit.id notnull

  // purchase price
  price bigint notnull

  created_at timestamp notnull
}

table Receive {
  id bigint pk notnull inc
  id_user User.id notnull
  id_warehouse Warehouse.id notnull
  id_purchase Purchase.id notnull

  created_at timestamp notnull
}

table ReceiveItem {
  id bigint pk notnull inc
  id_unit Unit.id notnull
  id_product Product.id notnull
  id_receive Receive.id notnull
  quantity bigint notnull
}


table SalesSession {
  id bigint pk inc notnull
  id_user User.id notnull

  // derivative value from
  // total sales value
  total_amount bigint notnull

  // derivative value from
  // total product sold
  total_product_sold bigint notnull
  opened_at timestamp notnull
  closed_at timestamp
}

table Sales {
  id bigint pk inc notnull
  id_user User.id notnull

  id_sales_session SalesSession.id

  created_at timestamp notnull
}

table SalesItem {
  id bigint pk inc notnull
  id_product Product.id notnull
  id_sales Sales.id notnull
  id_unit Unit.id notnull

  quantity bigint notnull
  price bigint notnull
}


table Capability {
  id bigint pk notnull inc

  // user capability, like: "WRITE_USER", "DELETE_PRODUCT"
  code varchar(50) notnull

  created_at timestamp notnull
}

table User {
  id bigint pk notnull inc
  fullname varchar(200) notnull
  username varchar(50) notnull
  password varchar(100) notnull
  created_at timestamp notnull
}

table UserCapability {
  id bigint pk notnull inc
  id_user User.id notnull
  id_capability Capability.id notnull
  created_at timestamp notnull
}


api get /admin/product {
  headers {
    authorization string required
  }
  return schema AdminProductResult {
    total number required
    data array table.Product required
  } required
}

api get /admin/product/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Product required
}

api post /admin/product {
  headers {
    authorization string required
  }
  body {
    data schema AdminProductPayload {
      nama string required
      id_category number required
      id_unit number required
      description string
      price number required
      imgurl string
      list_unit_conversion array schema AdminUnitConversionPayload {
        id_unit number required
        value number required
      } required
    } required
  }
  return table.Product required
}

api put /admin/product/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminProductPayload required
  }
  return table.Product required
}

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


api get /product {
  description get products
  query {
    q string
    limit number
    offset number
  }
  return schema ProductResult {
    total number required
    data array table.Product required
  }
}

api get /product/:id {
  description get product detail
  path {
    id number required
  }
  return table.Product required
}


api get /admin/user {
  headers {
    authorization string required
  }
  return schema AdminUserResult {
    total number required
    data array table.User required
  } required
}

api get /admin/user/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.User required
}

api post /admin/user {
  headers {
    authorization string required
  }
  body {
    data schema AdminUserPayload {
      fullname string required
      username string required
      password string required
      list_id_capability array number required
    } required
  }
  return table.User required
}

api put /admin/user/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminUserPayload required
  }
  return table.User required
}

api delete /admin/user/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.User required
}


api get /admin/purchase {
  description data pembelian
  headers {
    authorization string required
  }
  query {
    limit number
    query number
    id_vendor number
    status string
    q string
  }
  return schema AdminPurchaseResult {
    total number required
    data array table.Purchase required
  } required
}

api get /admin/purchase/:id {
  description detail data pembelian
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return schema AdminDetailPurchase {
    pembelian table.Purchase required
    list_item array table.PurchaseItem required
  } required
}

api post /admin/purchase {
  description tambah pembelian
  headers {
    authorization string required
  }
  body {
    data schema AdminPurchasePayload {
      id_vendor number required
      nomor_invoice number required
      pajak number required
      list_item array schema AdminItemPurchasePayload {
        id_product number required
        kuantitas number required
        harga number required
        id_unit number required
      } required
    } required
  }
  return schema.AdminDetailPurchase required
}

api put /admin/purchase/:id {
  description ubah pembelian
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPurchasePayload required
  }
  return schema.AdminDetailPurchase required
}

api delete /admin/purchase/:id {
  description hapus pembelian
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Purchase required
}


api get /admin/unit {
  headers {
    authorization string required
  }
  return schema AdminUnitResult {
    total number required
    data array table.Unit required
  } required
}

api get /admin/unit/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Unit required
}

api post /admin/unit {
  headers {
    authorization string required
  }
  body {
    data schema AdminUnitPayload {
      label string required
    } required
  }
  return table.Unit required
}

api put /admin/unit/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminUnitPayload required
  }
  return table.Unit required
}

api delete /admin/unit/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Unit required
}


api post /start-session {
  description start a sales session, return existing session if other session is still active
  headers {
    authorization string required
  }
  return table.SalesSession required
}

api post /end-session {
  description end existing active (unclosed) session
  headers {
    authorization string required
  }
  return table.SalesSession required
}


api get /admin/vendor {
  description data vendor
  headers {
    authorization string required
  }
  query {
    limit number
    query number
    id_vendor number
    status string
    q string
  }
  return schema AdminVendorResult {
    total number required
    data array table.Vendor required
  } required
}

api get /admin/vendor/:id {
  description detail data vendor
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Vendor required
}

api post /admin/vendor {
  description tambah vendor
  headers {
    authorization string required
  }
  body {
    data schema AdminVendorPayload {
      nama string required
      alamat string
      nomor_telepon string
      email string
    } required
  }
  return table.Vendor required
}

api put /admin/vendor/:id {
  description ubah vendor
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminVendorPayload required
  }
  return table.Vendor required
}

api delete /admin/vendor/:id {
  description hapus vendor
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Vendor required
}


api post /add-sales {
  description add new sales
  headers {
    authorization string required
  }
  body {
    list_item array schema SalesItemPayload {
      id_product number required
      qty number required
    } required
  }
  return table.Sales required
}

api delete /sales/:id_sales {
  description cancel sales
  headers {
    authorization string required
  }
  path {
    id_sales number required
  }
  return table.Sales required
}


api get /admin/receive {
  description data receive
  headers {
    authorization string required
  }
  query {
    limit number
    query number
    id_vendor number
    status string
    q string
  }
  return schema AdminReceiveResult {
    total number required
    data array table.Receive required
  } required
}

api get /admin/receive/:id {
  description detail data receive
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return schema AdminDetailReceive {
    receive table.Receive required
    list_item array table.ReceiveItem required
  } required
}

api post /admin/receive {
  description tambah receive
  headers {
    authorization string required
  }
  body {
    data schema AdminReceivePayload {
      id_purchase number required
      id_warehouse number required
      list_item array schema AdminItemReceivePayload {
        id_product number required
        kuantitas number required
        id_unit number required
      } required
    } required
  }
  return schema.AdminDetailReceive required
}

api put /admin/receive/:id {
  description ubah receive
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminReceivePayload required
  }
  return schema.AdminDetailReceive required
}

api delete /admin/receive/:id {
  description hapus receive
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Receive required
}
