Perencanaan Sistem Informasi Distro

User Toko Baju (Distro):

- Admin: mengelola stock barang, menentukan harga barang.
- Customer: pembeli
- Penjualan: melakukan transaksi dengan customer


Menu Admin:
- Login
- Employer: pengelolaan data karyawan
- Employer Fee: gaji karyawan
- Konfigurasi Rekening: konfigurasi rekening bank penerima
- Brand: brand/merek product.
- Supplier: supplier product.
- City: kode kota/provinsi/negara.
- Color: warna product. Misalnya: Merah, Biru, dsb.
- Size: ukuran product. Misalnya: 30,40, S, M, L, XL, dsb.
- Category: kategori product. Misalnya: pakaian, celana, dsb.
- Sub Category: sub kategori product. Misalnya: Laki, perempuan, anak-anak.
- Product: product yang dijual.
- Stock: stok produk.
- Discount: konfigurasi diskon.
- Discount Items: barang-barang yang terkena diskon.
- Shipping: konfigurasi pengiriman product ke customer.
- Logout

DATABASE

employer:
id, code_karyawan, user, pass, position, name, address, phone

employer_kontrak:
id, id_karyawan, begin, until, expl

employer_gj:
id, id_karyawan, fee, expl

rekening:
id, atsnm, bank, norek, expl

brand:
id, code_brand, name, expl

supplier:
id, code_supplier, name, address, email, phone, expl

city:
id, code, state_id, nation_id, name, expl

color:
id, code_color, name, heksa, expl

size:
id, code_size, name, expl

category:
id, code_category, name, expl

category_sub:
id, parent_id, name, expl

product:
id, code_product, id_brand, id_supplier, id_color, id_size, id_category, id_category_sub, name, price

product_img:
id, id_product, file

stock:
id, id_product, stock_front, stock_real

discount:
id, nama, discount, tgla, tglb, expl

discount_items:
id, id_discount, id_product

shipping:
id, code_city, price, expl


Menu Penjualan:
- Login: login user penjualan
- Customer: data customer
- Penjualan: data penjualan product
- Pembelian: data pembelian product
- Retur Jual: data retur penjualan
- Retur Beli: data retur pembelian
- Logout

DATABASE

sales:
id, no_trans, date, id_costumer, id_shipping, total

sales_detail:
id, no_trans, id_product, qty, id_discount, price, price_total

sales_destination:
id, no_trans, name, address, code_city

sales_retur:
id, no_record, date, fee

sales_retur_detail:
id, no_record, id_product, qty

purchase:
id, no_trans, date, id_supplier, total

purchase_detail:
id, no_trans, id_product, qty, price, price_total

purchase_retur:
id, no_record, date, fee

purchase_retur_detail:
id, no_record, id_product, qty



Menu Customer:
- Login: login untuk customer
- Register: form pendaftaran customer
- Account: data diri customer
- Data Product: data product
- Pembelian/cart: transaksi pembelian
- Logout

DATABASE

customer:
id, name, address, city, state, nation, email, hp, register_at, user, pass, login

Posted in: Sistem Informasi