schema AdminPenjualanResult {
  total number required
  data array table.Penjualan required
}
schema DetailPenjualan {
  penjualan table.Penjualan required
  list_item array table.ItemPenjualan required
}
schema AdminRingkasanPenjualan {
  frekuensi_penjualan number required
  total_nominal number required
  total_item_terjual number required
}
schema AdminPenjualanPayload {
  pajak number required
  list_item array schema.AdminItemPenjualanPayload required
}
schema AdminItemPenjualanPayload {
  id_tiket number required
  nomor_kursi number required
}
schema TransaksiPelangganResult {
  total number required
  data array table.Penjualan required
}

table LokasiBerangkatTiba {
  id bigint pk notnull inc
  nama varchar(200) notnull
  created_at timestamp notnull
}
table AgenPerjalanan {
  id bigint pk notnull inc
  nama varchar(200) notnull
  logo_url varchar(200) 
  deskripsi text 
  nomor_telepon varchar(50) 
  email varchar(200) 
}
table Rute {
  id bigint pk notnull inc
  id_agen AgenPerjalanan.id notnull
  id_lokasi_asal LokasiBerangkatTiba.id notnull
  id_lokasi_tujuan LokasiBerangkatTiba.id notnull
  jumlah_kursi int notnull
  label varchar(200) 
  deskripsi text 
  created_at timestamp notnull
}
table KelasTiket {
  id bigint pk notnull
  label varchar(200) notnull
  created_at timestamp notnull
}
table Tiket {
  id bigint pk notnull
  id_kelas KelasTiket.id 
  id_rute Rute.id notnull
  harga bigint notnull
  label varchar(200) 
  kuota int notnull default=0
  deskripsi text 
  waktu_berangkat timestamp notnull
}

schema AdminPejalananKelasTiketResult {
  total number required
  data array table.KelasTiket required
}
schema AdminPejalananKelasTiketPayload {
  nama string required
}
schema AdminPejalananAgenResult {
  total number required
  data array table.AgenPerjalanan required
}
schema AdminPejalananAgenPayload {
  nama string required
  logo_url string 
  deskripsi string 
  nomor_telepon string 
  email string 
}
schema AdminPejalananLokasiBTResult {
  total number required
  data array table.LokasiBerangkatTiba required
}
schema AdminPejalananLokasiBTPayload {
  nama string required
}
schema AdminPejalananRuteResult {
  total number required
  data array table.Rute required
}
schema AdminPejalananRutePayload {
  id_agen number required
  id_lokasi_asal number required
  id_lokasi_tujuan number required
  jumlah_kursi number required
  label string 
  deskripsi string 
}
schema AdminPejalananTiketResult {
  total number required
  data array table.Tiket required
}
schema AdminPejalananTiketPayload {
  id_kelas number 
  id_rute number required
  harga number required
  label string
  kuota number required
  deskripsi string 
  waktu_berangkat_ts string required
}
schema LokasiBTResult {
  total number required
  data array table.LokasiBerangkatTiba required
}
schema CariTiketResult {
  total number required
  data array table.Tiket required
}

api get /admin/pejalanan/kelas-tiket {
  headers {
    authorization string required
  }
  return schema.AdminPejalananKelasTiketResult required
}
api get /admin/pejalanan/kelas-tiket/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.KelasTiket required
}
api post /admin/pejalanan/kelas-tiket {
  headers {
    authorization string required
  }
  body {
    data schema.AdminPejalananKelasTiketPayload required
  }
  return table.KelasTiket required
}
api put /admin/pejalanan/kelas-tiket/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPejalananKelasTiketPayload required
  }
  return table.KelasTiket required
}
api delete /admin/pejalanan/kelas-tiket/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.KelasTiket required
}
api get /admin/pejalanan/agen {
  headers {
    authorization string required
  }
  return schema.AdminPejalananAgenResult required
}
api get /admin/pejalanan/agen/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.AgenPerjalanan required
}
api post /admin/pejalanan/agen {
  headers {
    authorization string required
  }
  body {
    data schema.AdminPejalananAgenPayload required
  }
  return table.AgenPerjalanan required
}
api put /admin/pejalanan/agen/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPejalananAgenPayload required
  }
  return table.AgenPerjalanan required
}
api delete /admin/pejalanan/agen/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.AgenPerjalanan required
}
api get /admin/pejalanan/lokasi-bt {
  headers {
    authorization string required
  }
  return schema.AdminPejalananLokasiBTResult required
}
api get /admin/pejalanan/lokasi-bt/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.LokasiBerangkatTiba required
}
api post /admin/pejalanan/lokasi-bt {
  headers {
    authorization string required
  }
  body {
    data schema.AdminPejalananLokasiBTPayload required
  }
  return table.LokasiBerangkatTiba required
}
api put /admin/pejalanan/lokasi-bt/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPejalananLokasiBTPayload required
  }
  return table.LokasiBerangkatTiba required
}
api delete /admin/pejalanan/lokasi-bt/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.LokasiBerangkatTiba required
}
api get /admin/pejalanan/rute {
  headers {
    authorization string required
  }
  return schema.AdminPejalananRuteResult required
}
api get /admin/pejalanan/rute/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Rute required
}
api post /admin/pejalanan/rute {
  headers {
    authorization string required
  }
  body {
    data schema.AdminPejalananRutePayload required
  }
  return table.Rute required
}
api put /admin/pejalanan/rute/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPejalananRutePayload required
  }
  return table.Rute required
}
api delete /admin/pejalanan/rute/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Rute required
}
api get /admin/pejalanan/tiket {
  headers {
    authorization string required
  }
  return schema.AdminPejalananTiketResult required
}
api get /admin/pejalanan/tiket/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Tiket required
}
api post /admin/pejalanan/tiket {
  headers {
    authorization string required
  }
  body {
    data schema.AdminPejalananTiketPayload required
  }
  return table.Tiket required
}
api put /admin/pejalanan/tiket/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPejalananTiketPayload required
  }
  return table.Tiket required
}
api delete /admin/pejalanan/tiket/:id {
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Tiket required
}
api get /kelas-tiket {
  return array table.KelasTiket required
}
api get /lokasi-berangkat-tiba {
  query {
    q string 
    limit number 
    offset number 
  }
  return schema.LokasiBTResult required
}
api get /agen-perjalanan {
  query {
    id_lokasi_asal number 
    id_lokasi_tujuan number 
  }
  return array table.AgenPerjalanan required
}
api get /cari-tiket {
  query {
    q string 
    id_lokasi_asal number 
    id_lokasi_tujuan number 
    id_agen_perjalanan number 
    waktu_yyyymmdd_awal string 
    waktu_yyyymmdd_akhir string 
    limit number 
    offset number 
  }
  return schema.CariTiketResult required
}

table Penjualan {
  id bigint pk notnull inc
  id_user User.id notnull
  total bigint notnull
  pajak bigint notnull
  created_at timestamp notnull
}
table ItemPenjualan {
  id bigint pk notnull inc
  id_penjualan Penjualan.id notnull
  id_tiket Tiket.id notnull
  nomor_kursi int notnull
  harga bigint notnull
}

table LokasiBerangkatTiba {
  id bigint pk notnull inc
  nama varchar(200) notnull
  created_at timestamp notnull
}
table AgenPerjalanan {
  id bigint pk notnull inc
  nama varchar(200) notnull
  logo_url varchar(200) 
  deskripsi text 
  nomor_telepon varchar(50) 
  email varchar(200) 
}
table Rute {
  id bigint pk notnull inc
  id_agen AgenPerjalanan.id notnull
  id_lokasi_asal LokasiBerangkatTiba.id notnull
  id_lokasi_tujuan LokasiBerangkatTiba.id notnull
  jumlah_kursi int notnull
  label varchar(200) 
  deskripsi text 
  created_at timestamp notnull
}
table KelasTiket {
  id bigint pk notnull
  label varchar(200) notnull
  created_at timestamp notnull
}
table Tiket {
  id bigint pk notnull
  id_kelas KelasTiket.id 
  id_rute Rute.id notnull
  label varchar(200) 
  kuota int notnull default=0
  deskripsi text 
  waktu_berangkat timestamp notnull
}

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

api post /login {
  description login dengan email
  body {
    email string required
    password string required
  }
  return schema.AuthResponse required
}
api post /register {
  description register new user
  body {
    data schema.UserRegisterData required
  }
  return schema.AuthResponse required
}
api get /admin/user {
  description get user data, filter by limit, query, and query search q
  headers {
    authorization string required
  }
  query {
    limit number 
    query number 
    q number 
  }
  return schema.AdminUserResult 
}
api get /admin/user/:id {
  description ambil data user berdasarkan id
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.User required
}
api post /admin/user {
  description tambah data user
  headers {
    authorization string required
  }
  body {
    data schema.AdminUserPayload required
  }
  return table.User required
}
api put /admin/user/:id {
  description update data user berdasarkan id
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminUserPayload required
  }
  return table.User required
}
api delete /admin/user/:id {
  description hapus data user berdasarkan id
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.User required
}

api get /admin/penjualan {
  description ambil data penjualan
  headers {
    authorization string required
  }
  query {
    limit number 
    offset number 
    date_yyyymmdd_start string 
    date_yyyymmdd_end string 
  }
  return schema.AdminPenjualanResult required
}
api get /admin/penjualan/:id {
  description detail data penjualan berdasarkan id
  headers {
    authorization string required
  }
  return schema.DetailPenjualan 
}
api get /admin/ringkasan-penjualan {
  description ringkasan penjualan
  headers {
    authorization string required
  }
  query {
    date_yyyymmdd_start string 
    date_yyyymmdd_end string 
  }
  return schema.AdminRingkasanPenjualan required
}
api post /admin/penjualan {
  description tambah penjualan
  headers {
    authorization string required
  }
  body {
    data schema.AdminPenjualanPayload required
  }
  return schema.DetailPenjualan required
}
api put /admin/penjualan/:id {
  description ubah penjualan
  headers {
    authorization string required
  }
  path {
    id number required
  }
  body {
    data schema.AdminPenjualanPayload required
  }
  return schema.DetailPenjualan required
}
api delete /admin/penjualan/:id {
  description hapus penjualan
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return table.Penjualan required
}
api post /beli {
  description proses pembelian melalui sistem enduser
  headers {
    authorization string required
  }
  body {
    list_item array schema.AdminItemPenjualanPayload required
  }
  return schema.DetailPenjualan required
}
api get /transaksi {
  description daftar transaksi enduser melalui sistem enduser
  headers {
    authorization string required
  }
  query {
    limit number 
    offset number 
    date_yyyymmdd_start string 
    date_yyyymmdd_end string 
  }
  return schema.TransaksiPelangganResult required
}
api get /transaksi/:id {
  description detail transaksi enduser melalui sistem enduser
  headers {
    authorization string required
  }
  path {
    id number required
  }
  return schema.DetailPenjualan required
}

schema AuthResponse {
  token string required
  user table.User required
}
schema UserRegisterData {
  fullname string required
  email string required
  password string required
}
schema AdminUserResult {
  total number required
  data array table.User required
}
schema AdminUserPayload {
  fullname string required
  email string required
  password string required
}