7/17/2019 Procedure

http://slidepdf.com/reader/full/procedure-568c1991d2aa8 1/4

1. BARANGDISKONDELIMITER $$CREATE PROCEDURE barangdiskon()

BEGINSELECT nama_barang, hrg_jual,diskon, (hrg_jual-diskon)harga_setelah_diskon FROMbarang;

END $$DELIMITER |;

2.BARANGTERJUALDELIMITER $$CREATE PROCEDURE barangterjual()

BEGINSELECT penjualan.id_jual, penjualan.tgl, barang.nama_barang, (hrg_jual-diskon)harga_setelah_diskon, penjualan.jml, ((hrg_jual-diskon)*penjualan.jml)total, ket FROM barang,barangmasuk,penjualan where barangmasuk.id_brg=penjualan.id_brg AND barangmasuk.id_sup=barang.id_sup;

END $$DELIMITER |;

3. JUMLAH STOK >5DELIMITER $$CREATE PROCEDURE jmlstok()BEGINSELECT kd_brg, nama_barang,jml_stok, ms_blaku FROM barangWHERE barang.jml_stok > 5;END $$DELIMITER |;

4. PEMBELIAN BARANG

DELIMITER $$CREATE PROCEDURE pembelianbarang()BEGINSELECTpembelian.tgl,pembelian.id_beli,supplier.id_sup,supplier.nama_sup,barang.kd_brg,barang.nama_barang,pembelian.jml,barang.hrg_beli,pembelian.total FROM pembelian, barang, supplierWHERE barang.kd_brg = pembelian.id_brg AND barang.id_sup = supplier.id_sup;END $$DELIMITER |;

5. PROFITBARANG

DELIMITER $$CREATE PROCEDURE profitbarang()

BEGINSELECT penjualan.tgl, barang.nama_barang, barang.hrg_beli, barang.hrg_jual, barang.diskon,(hrg_jual-diskon), penjualan.jml, ((hrg_jual-diskon)*penjualan.jml), ((hrg_jual-diskon)*penjualan.jml)-(hrg_beli*penjualan.jml) FROM barang,penjualanwhere barang.kd_brg=penjualan.id_brg;END $$DELIMITER |;

6. PROFITSTOK

DELIMITER $$CREATE PROCEDURE profitstok()

7/17/2019 Procedure

http://slidepdf.com/reader/full/procedure-568c1991d2aa8 2/4

BEGINSELECT nama_barang, hrg_beli, hrg_jual, jml_stok, diskon,((hrg_jual-diskon)*jml_ stok)harga_total, (((hrg_jual-diskon)*jml_stok)-(hrg_beli*jml_stok))keuntungan,nama_sup FROM barang, supplierwhere supplier.id_sup=barang.id_sup;END $$DELIMITER |;

7.NOTADELIMITER $$CREATE PROCEDURE nota()

BEGINSELECT penjualan.nota, penjualan.tgl, barang.kd_brg, barang.nama_barang, barang.hrg_jual, barang.diskon, (hrg_jual-diskon)harga_setelah_diskon, penjualan.jml, ((hrg_jual-diskon)*penjualan.jml)total FROM barang, penjualanwhere barang.kd_brg=penjualan.id_brg;END $$DELIMITER |;

8. barang diterimaDELIMITER $$CREATE PROCEDURE barangdterima()BEGINSELECT diterima.id_brg, barang.nama_barang,diterima.jml,barang.ket FROM barang,diterimaWHERE barang.kd_brg = diterima.id_brg;END $$DELIMITER |;

9.pengirimanbarangDELIMITER $$

CREATE PROCEDURE pengirimanbarang()

BEGINSELECT nama_brg, mengirim.jml_kluar,hrg_jual, diskon, (hrg_jual-diskon)harga_setelah_diskon,((hrg_jual-diskon)*mengirim.jml_kluar)total_hargaFROM barang,mengirimwhere barang.kd_brg=mengirim.kd_brg;END $$DELIMITER |;

10. keuntunganDELIMITER $$CREATE PROCEDURE keuntungan()

BEGINSELECT nama_barang,hrg_jual,hrg_beli, (hrg_jual-hrg_beli)keuntungan_per_unit,jml,((hrg_jual-hrg_beli)*jml) keuntungan, ket FROM barang,pembelianwhere pembelian.id_sup=barang.id_sup;END $$DELIMITER |;

11. total keuntungan lunasDELIMITER $$CREATE PROCEDURE totalkeuntungan()BEGIN

SELECT sum((hrg_jual-hrg_beli)*jml)total_keuntungan_lunas FROM barang, pembelian where pembelian.id_sup=barang.id_sup and ket like '%lunas%';

7/17/2019 Procedure

http://slidepdf.com/reader/full/procedure-568c1991d2aa8 3/4

END $$DELIMITER |;

12. penjualan belum lunasDELIMITER $$CREATE PROCEDURE penjualanBL()BEGIN

SELECT penjualan.tgl, penjualan.id_brg, barang.nama_barang,(hrg_jual-diskon)harga_setelah_diskon, penjualan.jml, ((hrg_jual-diskon)*penjualan.jml)total, barang.id_sup, ket FROM barang,penjualanwhere barang.kd_brg=penjualan.id_brg AND ket like '%belum%';END$$DELIMITER $$

13. penjualan lunasDELIMITER $$CREATE PROCEDURE penjualanlunas()BEGINSELECT penjualan.tgl, penjualan.id_brg, barang.nama_barang,(hrg_jual-diskon)harg

a_setelah_diskon, penjualan.jml, ((hrg_jual-diskon)*penjualan.jml)total, barang.id_sup, ket FROM barang,penjualanwhere barang.kd_brg=penjualan.id_brg AND ket like '%lunas%';END$$DELIMITER $$

14. jumlah penjualanDELIMITER $$CREATE PROCEDURE jumlahpenjualan()BEGINSELECT COUNT(jml) FROM penjualan;END $$DELIMITER |;

15. retur barang supplierDELIMITER $$CREATE PROCEDURE returbarangsupplier()BEGINSELECT tgl_retur, id_retur, retur.id_beli, barang.kd_brg, nama_barang,retur.jml, barang.hrg_beli,(barang.hrg_beli*retur.jml) total, nama_sup from barang, retur, supplierwhere barang.kd_brg=retur.id_brg and barang.id_sup=supplier.id_sup;END $$DELIMITER |;

16.datasuppliermadiunDELIMITER $$CREATE PROCEDURE datasuppliermadiun()BEGINSELECT id_sup,nama_sup,telp, alamat, kd_sup FROM supplierWHERE alamat like '%madiun%';END $$DELIMITER |;

17.datasupplierponorogoDELIMITER $$CREATE PROCEDURE datasupplierponorogo()BEGIN

SELECT id_sup,nama_sup,telp, alamat, kd_sup FROM supplierWHERE alamat like '%ponorogo%';END $$

7/17/2019 Procedure

http://slidepdf.com/reader/full/procedure-568c1991d2aa8 4/4

DELIMITER |;

18. datasuppliermagetanDELIMITER $$CREATE PROCEDURE datasuppliermagetan()BEGINSELECT id_sup,nama_sup,telp, alamat, kd_sup FROM supplier

WHERE alamat like '%magetan%';END $$DELIMITER |;