lampiran 1. lampiran utama...surat jalan nota penyerahan bukti timbangan bahan baku barang dicek...

1

LAMPIRAN

1. Lampiran Utama

a. Struktur Organisasi Perusahaan

2

b. Flowchart Pemasukan dan Pengeluaran Benang

PT TIGA MANUNGGAL SYNTHETIC INDUSTRIES

PROSEDUR PERMINTAAN PEMBELIAN

ANALYTIC FLOWCHART

KANTOR PUSAT (Bagian Pembelian) BAGIAN PPC

MULAI

Production Order

For Weaving

Production Order

For WeavingTextile

Design

Daftar Stock

Perseidaan

Benang

Menghitung

kebutuhan

produksi

Benang

tersedia

Membuat

Permintaan

Benang

Otorisasi Ka.

Dep. PPC dan

Wakil

Pimpinan

Form Permintaan

Benang

Membuat

permintaan

pembelian

Form Permintaan

Benang

Purchase

Order

SUPPLIER

Purchase

Order

Textile

Design

Daftar

Stock

Perseidaan

Benang

tidak

Prosedur Produksi

Ya

Melakukan Penawaran

Harga. Setelah sepakat

Supplier menandatangani

Purchase Order dan

mengirimnya ke Kantor

Pusat.

Form Permintaan

Benang

12

Form Permintaan

Benang

12

1

T

Purchase

Order

T

Selesai

3


PROSEDUR PENERIMAAN BAHAN BAKU DARI PEMASOK

ANALYTIC FLOWCHART

BAGIAN GUDANG PPC

MULAI

Surat JalanNota

Penyerahan

Bukti

TimbanganBahan

Baku

Barang dicek

dengan Surat

yang dilampirkan

Sesuai dengan

permintaan ?

Membuat Bukti Penerimaan

Barang dan ditandatangani

oleh kepala bagian gudang

benang

Bukti

Timbangan

Bahan

BakuSurat Jalan

Nota

Penyerahan

1

Mencatat di Data

Penerimaan dan

Pengeluaran Bahan

baku

Stock

Bahan

Baku

Bukti

TimbanganBahan

Baku

Surat JalanSurat

Pengantar

Angkut

1

Bukti

TimbanganSurat Jalan

Nota

Penyerahan

1

Mengisi No PO, Harga,

dan No Kaber di Surat

Pengantar Angkut dan

Membuat Form

Pemberitahuan

Pemasukkan Barang

45

Supplier

Ya

Tidak

Supplier mengirim Surat Jalan,

Surat Pengantar Angkut, berserta

barang ke Bagian Gudang

T

Purchase

Order

Purchase

Order

23

4

5Bukti

Penerimaan

Barang

6

12

3

4

5Bukti

Penerimaan

Barang

6

23

4

5Bukti

Penerimaan

Barang

6

54

3

2Bukti

Penerimaan

Barang

1

23

Formulir

Pemberitahuan

Pemasukkan

Barang

1

Kantor Bea dan

Cukai

23

Formulir

Pemberitahuan

Pemasukkan

Barang

1

Mencatat pemasukan

benang

Bukti

Timbangan

Surat Jalan

Surat

Pengantar

Angkut

Purchase

Order

4

3

2Bukti

Penerimaan

Barang

1

Bukti

Timbangan

Surat Jalan

Surat

Pengantar

Angkut

23

Formulir

Pemberitahuan

Pemasukkan

Barang

1

Pemasukan

Benang

Dari Luar

T

Bukti Penerimaan Barang

rangkap 4 dan Pemberitahuan

Pemasukan Barang rangkap 3

diarsip oleh bagian akuntansi

pemasok dari

kawasan berikat,

menggunkan

Pemberitahuan

Pemasukkan

Barang BC 4.0,

dan jika bukan dari

kawasan berikan

menggunakan

Pemberitahuan

Pemasukan

Barang BC 2.3.

4


Prosedur Pengeluaran Bahan Baku Untuk Produksi Benang Twist

ANALYTIC FLOWCHART

BAGIAN TWISTING (I / II / III) BAGIAN GUDANG

MULAIMembuat jadwal produksi

benang twist berdasarkat

Order Twisting

Menyiapkan Nota

Permintaan Twist

dan ditandatangani

oleh kepala Bagian

Twisting

Jadwal

Produksi

Twisting

Jadwal

Produksi

TwistingNot Permintaan

Twist

21

Not Permintaan

Twist

21

Menyiapkan

Bahan Baku

dan Nota

Pengeluaran

Ke Bagian

Not Permintaan

Twist

21

Bahan

Baku

Dokumen

ditandatangani oleh

kepala Bagian

Gudang

Not Permintaan

Twist

21

1

1

Bahan

Baku

Not Permintaan

Twist

2

Mengecek bahan

baku dengan

permintaan

Sesuai dengan

permintaan ?

Menyiapkan Bon

Penerimaan Barang

Not

Permintaan

Twist

2

Bon Penerimaan

Barang

1 23

Bahan

Baku

Nota Pengeluaran

ke Bagian dan Bon

Penerimaan Barang

ditandatangani oleh

Kepala Bagian

Twisting

Bon Penerimaan

Barang

1 233 2

1

2

Bon Penerimaan

Barang

1 23

2

Bon Penerimaan

Barang ditandatangani

oleh Kepala Bagian

Gudang

Bon Penerimaan

Barang

1 23

Mencatat

Pengeluaran

Bahan Baku

Stock

Bahan

Baku

Bon Penerimaan

Barang

1 2

Bon Penerimaan

Barang

3

3

3

T

Ya

Tidak

Laporan pemasukan

dan pengeluaran

Bahan Baku

T

4

Nota

Pengeluaran Ke

Bagian

1 23

4

Nota

Pengeluaran Ke

Bagian

1 23

4

Nota

Pengeluaran Ke

Bagian

1 23

4

Nota

Pengeluaran

Ke Bagian

1 23

Nota

Pengeluaran Ke

Bagian

4

Nota

Pengeluaran Ke

Bagian

1 23

Nota

Pengeluaran Ke

Bagian

1 23

1

5


Prosedur Pengeluaran Bahan Baku Untuk Produksi Benang Twist

ANALYTIC FLOWCHART

Bagian Gudang PPC

Bon Penerimaan

Barang

1 2

Nota

Pengeluaran Ke

Bagian

1 23

1

T T4 4

Bon Penerimaan

Barang

1Nota

Pengeluaran Ke

Bagian

1 2

4

Mencatat

Pengeluaran

Bahan Baku

Pemasukk

an Bahan

Baku

Bon Penerimaan

Barang

1Nota

Pengeluaran Ke

Bagian

1 2

Selesai

T

6

c. Coding List

Koneksi database dengan aplikasi.

package control;

import java.sql.SQLException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class KoneksiDB {

public static Connection koneksi=null;

public KoneksiDB() {

}

public static Connection getConnection(){

boolean ada_kesalahan = false;

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (Exception ex)

{

System.out.println("ada kesalahan saat koneksi database pertama : "+ ex);

ada_kesalahan=true;

}

if (!ada_kesalahan) {

try {

koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbinventory","

root","");

System.out.println("Koneksi mysql berhasil");

}catch (Exception ex)

{

System.out.println("ada kesalahan saat koneksi mencari database

inventory : "+ ex);

ada_kesalahan=true;

}

}

return koneksi;

}

public Statement createStatement() {

return null;

}

public Connection getTutup() throws SQLException {

try {

if (koneksi != null) {

koneksi.close();

}

System.out.println("Koneksi Berhasil di Tutup");

} catch (SQLException ex) {

ex.printStackTrace();

}

return koneksi;

}

}

Kode Program Package “control”-class “kontrol”

package control;

import java.sql.*;

import java.util.Vector;

import javax.swing.JOptionPane;

public class kontrol extends KoneksiDB{

7

public String sql;

public Statement stmt = null;

public ResultSet rs;

public Vector judulKolom = new Vector();

public Vector tabel = new Vector();

public void setSQL(String sequel) {

sql = sequel;

}

public String getSQL() {

return (sql);

}

Kode Program Login Aplikasi-“FrameLogin”

package gudang;

import control.KoneksiDB;

import java.awt.event.KeyEvent;


import java.sql.ResultSet;



import javax.swing.*;

import gudang.FrameUtama;

public class FrameLogin extends javax.swing.JFrame {

public FrameLogin() {

initComponents();

}

@SuppressWarnings("unchecked")

Generated Code

private void bt_loginActionPerformed(java.awt.event.ActionEvent evt) {

String user = tf_user.getText().trim();

String pass = tf_pass.getText().trim();

Connection koneksi = KoneksiDB.getConnection();

try {

String sql = "select password from user where username='" + user +

"'";

Statement stm = koneksi.createStatement();

ResultSet rs = stm.executeQuery(sql);

if (rs.next()) {

String pasw = rs.getString("password");

if (pasw.equals(pass)) {

FrameUtama utama = new FrameUtama();

utama.setExtendedState(FrameUtama.MAXIMIZED_BOTH);

utama.setVisible(true);

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

this.dispose();

} else {

JOptionPane.showMessageDialog(null, "Username atau Password

salah", "Warning", JOptionPane.WARNING_MESSAGE);

ClearForm();

}

} else {

JOptionPane.showMessageDialog(null, "Username atau Password

salah", "Warning", JOptionPane.WARNING_MESSAGE);

ClearForm();

}

stm.close();

} catch (Exception e) {

System.out.println(e.getMessage());

}

}

private void bt_cancelActionPerformed(java.awt.event.ActionEvent evt) {

this.dispose();

8

}

public void ClearForm(){

tf_user.setText("");

tf_pass.setText("");

}

/**

* @param args the command line arguments

*/

public static void main(String args[]) {

/* Set the Nimbus look and feel */

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new FrameLogin().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.JButton bt_cancel;

private javax.swing.JButton bt_login;

private javax.swing.JLabel jLabel1;






private javax.swing.JPasswordField tf_pass;

private javax.swing.JTextField tf_user;

// End of variables declaration

}

Kode Program Menu Utama-“FrameUtama” package gudang;

import java.awt.CardLayout;

public class FrameUtama extends javax.swing.JFrame {

private PanelSupplier panelSupplier; private PanelBarang panelBarang;

private PanelTransaksi panelTransaksi;

private PanelDataTransaksi panelDataTransaksi;

private Panel_laporan panelLaporan;

public FrameUtama() {

initComponents();

panelSupplier = new PanelSupplier();

panelU.add("supplier", panelSupplier);

panelBarang = new PanelBarang();

panelU.add("barang", panelBarang);

panelTransaksi = new PanelTransaksi();

panelU.add("transaksi", panelTransaksi);

panelDataTransaksi = new PanelDataTransaksi();

panelU.add("datatransaksi", panelDataTransaksi);

panelLaporan = new Panel_laporan();

panelU.add("laporan", panelLaporan);

}

public void showPanel(String panelIdentifier) {

CardLayout cardLayout = (CardLayout) panelU.getLayout();

cardLayout.show(panelU, panelIdentifier);

}


private void bt_pemasokActionPerformed(java.awt.event.ActionEvent evt) {

showPanel("supplier");

}

private void bt_logoutActionPerformed(java.awt.event.ActionEvent evt) {

FrameLogin keluar = new FrameLogin();

keluar.setVisible(true);

9

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

this.dispose();

}

private void bt_barangActionPerformed(java.awt.event.ActionEvent evt) {

showPanel("barang");

}

private void bt_transaksiActionPerformed(java.awt.event.ActionEvent evt) {

showPanel("transaksi");

}

private void bt_laporanActionPerformed(java.awt.event.ActionEvent evt) {

showPanel("datatransaksi");

}

private void bt_laporan1ActionPerformed(java.awt.event.ActionEvent evt) {

showPanel("laporan");

}

public static void main(String args[]) {

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

//new FrameUtama().setVisible(true);

FrameUtama mn=new FrameUtama();

mn.setExtendedState(FrameUtama.MAXIMIZED_BOTH);

mn.setVisible(true);

}

});

}


private javax.swing.JButton bt_barang;

private javax.swing.JButton bt_laporan;

private javax.swing.JButton bt_laporan1;

private javax.swing.JButton bt_logout;

private javax.swing.JButton bt_pemasok;

private javax.swing.JButton bt_transaksi;

private javax.swing.JDesktopPane jDesktopPane1;


private javax.swing.JMenu jMenu1;

private javax.swing.JMenu jMenu2;

private javax.swing.JMenuBar jMenuBar1;

public javax.swing.JPanel panelU;


}

Kode Program Panel Pemasok dan Bagian-“PanelSupplier”

package gudang;

import control.kontrol;



import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.table.DefaultTableModel;



import gudang.FCPemasok;


import net.sf.jasperreports.engine.JRException;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.view.JasperViewer;

public class PanelSupplier extends javax.swing.JPanel {

public PanelSupplier() {

initComponents();

}


private void formComponentShown(java.awt.event.ComponentEvent evt) {

try {

prosTampilPemasok();

prosTampilBagian();

} catch (Exception ex) {

Logger.getLogger(PanelSupplier.class.getName()).log(Level.SEVERE, null,

ex);

10

}

}

private void bt_hapuspActionPerformed(java.awt.event.ActionEvent evt) {

try {

kontrol objCRUD = new kontrol();

objCRUD.getDeletePemasok(tf_kodep.getText());

prosBersihPemasok();




}

}

private void tf_caripActionPerformed(java.awt.event.ActionEvent evt) {

try {

kontrol cari = new kontrol();

cari.getCariSemuaPemasok(tf_kodep.getText());

tf_namap.setText(cari.rs.getString("namapmsk"));

tf_alamat.setText(cari.rs.getString("alamat"));

tf_telp.setText(cari.rs.getString("telp"));



JOptionPane.showMessageDialog(null, "Terjadi Kesalahan. Pastikan Kode

Sudah Dimasukkan / Data Belum Ada");

}

}

private void tbl_pemasokMouseClicked(java.awt.event.MouseEvent evt) {

int baris = tbl_pemasok.getSelectedRow();

int kolom = tbl_pemasok.getSelectedColumn();

tf_kodep.setText(tbl_pemasok.getValueAt(baris, kolom).toString());

}

private void tf_ubahpActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getUpdatePemasok( tf_namap.getText(), tf_alamat.getText(),

tf_telp.getText(),tf_kodep.getText());





}}

private void bt_simpanpActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getSimpanPemasok(tf_kodep.getText(), tf_namap.getText(),

tf_alamat.getText(),tf_telp.getText());





}// TODO add your handling code here:

}

private void bt_simpanbActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getSimpanBagian(tf_kodeb.getText(), tf_namab.getText());

prosBersihBagian();

prosTampilBagian();




}

private void bt_ubahbActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getUpdateBagian( tf_namab.getText(), tf_kodeb.getText());

prosBersihBagian();

prosTampilBagian();

11




}

private void bt_hapusbActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getDeleteBagian(tf_kodeb.getText());

prosBersihBagian();

prosTampilBagian();




}

private void tbl_bagianMouseClicked(java.awt.event.MouseEvent evt) {

int baris = tbl_bagian.getSelectedRow();

int kolom = tbl_bagian.getSelectedColumn();

tf_kodeb.setText(tbl_bagian.getValueAt(baris, kolom).toString());

}

private void bt_cetakDPActionPerformed(java.awt.event.ActionEvent evt) {

try {

report_pemasok();// TODO add your handling code here:

} catch (JRException ex) {

Logger.getLogger(PanelSupplier.class.getName()).log(Level.SEVERE,

null, ex);

}

}

private void report_pemasok() throws JRException{

Connection koneksi = KoneksiDB.getConnection();

String filePemasok="src/laporan/reportDP.jasper";

JasperPrint cetakLaporan = JasperFillManager.fillReport(filePemasok,null,

koneksi);

JasperViewer tampillap=new JasperViewer(cetakLaporan,false);

tampillap.setVisible(true);

}

private void prosTampilBagian() throws Exception {


objCRUD.getSemuaBagian();

objCRUD.isiTabelBagian();

DefaultTableModel dtm = new DefaultTableModel(objCRUD.tabel,

objCRUD.judulKolom);

tbl_bagian.setModel(dtm);

objCRUD.getTutup();

}

private void prosBersihBagian() throws Exception {

tf_kodeb.setText("");

tf_namab.setText("");

}

private void prosTampilPemasok() throws Exception {


objCRUD.getSemuaPemasok();

objCRUD.isiTabelPmsk();



tbl_pemasok.setModel(dtm);

objCRUD.getTutup();

}

private void prosBersihPemasok() throws Exception {

tf_kodep.setText("");

tf_namap.setText("");

12

tf_alamat.setText("");

tf_telp.setText("");

}


private javax.swing.JButton bt_cetakDP;

private javax.swing.JButton bt_hapusb;

private javax.swing.JButton bt_hapusp;

private javax.swing.JButton bt_simpanb;

private javax.swing.JButton bt_simpanp;

private javax.swing.JButton bt_ubahb;









private javax.swing.JPanel jPanel1;


private javax.swing.JScrollPane jScrollPane1;


private javax.swing.JTable tbl_bagian;

private javax.swing.JTable tbl_pemasok;

private javax.swing.JTextField tf_alamat;

private javax.swing.JButton tf_carip;

private javax.swing.JTextField tf_kodeb;

private javax.swing.JTextField tf_kodep;

private javax.swing.JTextField tf_namab;

private javax.swing.JTextField tf_namap;

private javax.swing.JTextField tf_telp;

private javax.swing.JButton tf_ubahp;


}

Kode Program Panel Pemasok dan Bagian-Package control-“kontrol”

//Source Code PanelSupplier

public void getSimpanPemasok(String kodepmsk, String namapmsk, String alamat,

String telp) throws ClassNotFoundException {

try {

KoneksiDB ogS = new KoneksiDB();

ogS.getConnection();

PreparedStatement perintah = ogS.koneksi.prepareStatement("INSERT INTO

tb_pemasok VALUES(?,?,?,?)");

perintah.setString(1, kodepmsk);

perintah.setString(2, namapmsk);

perintah.setString(3, alamat);

perintah.setString(4, telp);

perintah.executeUpdate();

ogS.getTutup();


JOptionPane.showMessageDialog(null, "Terjadi Kesalahan. Pastikan data

yang dimasukkan sesuai", "Warning", JOptionPane.WARNING_MESSAGE);

}

}

public void getUpdatePemasok(String namapmsk, String alamat,String telp,

String kodepmsk) throws SQLException, ClassNotFoundException {

try {

KoneksiDB ogU = new KoneksiDB();

ogU.getConnection();

PreparedStatement perintah = ogU.koneksi.prepareStatement("UPDATE

tb_pemasok SET namapmsk=?, alamat=?, telp=? WHERE kodepmsk=?");

perintah.setString(1, namapmsk);

perintah.setString(2, alamat);

perintah.setString(3, telp);



ogU.getTutup();



}

13

}

public void getDeletePemasok(String kodepmsk) throws SQLException,

ClassNotFoundException {

try {

KoneksiDB ogD = new KoneksiDB();

ogD.getConnection();

PreparedStatement perintah = ogD.koneksi.prepareStatement("DELETE FROM

tb_pemasok WHERE kodepmsk=?");



ogD.getTutup();


JOptionPane.showMessageDialog(null, "Tidak Bisa Di Hapus. Data Sedang

Digunakan Untuk Transaksi", "Warning", JOptionPane.WARNING_MESSAGE);

}

}

public ResultSet getCariPemasok(String cari) throws SQLException {

try {

KoneksiDB ogCN = new KoneksiDB();

ogCN.getConnection();

PreparedStatement perintah = ogCN.koneksi.prepareStatement("SELECT *

FROM tb_pemasok WHERE namapmsk = ?");

perintah.setString(1, cari);

rs = perintah.executeQuery();

rs.first();



}

return rs;

}

public void isiTabelCariPmsk() throws Exception {

try {

KoneksiDB oiT = new KoneksiDB();

judulKolom.add("KODE");

judulKolom.add("NAMA");

while (rs.next()) {

Vector baris = new Vector();

baris.add(rs.getString("kodepmsk"));

baris.add(rs.getString("namapmsk"));

tabel.add(baris);

}

System.out.println("Tabel berhasil di Isi");



}

}

public ResultSet getCariSemuaPemasok(String kode) throws

ClassNotFoundException, SQLException {

try{




FROM tb_pemasok WHERE kodepmsk = ?");

perintah.setString(1, kode);


rs.first();



}

return rs;

}

public ResultSet getSemuaPemasok() throws ClassNotFoundException, SQLException

{



stmt = ogS.koneksi.createStatement();

14

rs = stmt.executeQuery("SELECT * FROM tb_pemasok ORDER BY kodepmsk");

return rs;

}

public void isiTabelPmsk() throws Exception {

try {




judulKolom.add("ALAMAT");

judulKolom.add("TELEPON");

while (rs.next()) {


baris.add(rs.getString("kodepmsk"));


baris.add(rs.getString("alamat"));

baris.add(rs.getString("telp"));

tabel.add(baris);

}




}

}

//Source Code Panel Bagian

public void getSimpanBagian(String kodebgn, String namabgn) throws


try {




tb_bgn VALUES(?,?)");

perintah.setString(1, kodebgn);

perintah.setString(2, namabgn);


ogS.getTutup();


JOptionPane.showMessageDialog(null, "Terjadi Kesalahan. Pastikan data

yang dimasukkan sesuai", "Warning", JOptionPane.WARNING_MESSAGE);

}

}

public void getUpdateBagian(String namabgn, String kodebgn) throws

SQLException, ClassNotFoundException {

try {




tb_bgn SET namabgn=?WHERE kodebgn=?");

perintah.setString(1, namabgn);



ogU.getTutup();



}

}

public void getDeleteBagian(String kodebgn) throws SQLException,


try {




tb_bgn WHERE kodebgn=?");



ogD.getTutup();


15

JOptionPane.showMessageDialog(null, "Tidak Bisa Di Hapus. Data Sedang

Digunakan Untuk Transaksi", "Warning", JOptionPane.WARNING_MESSAGE);

}

}

public ResultSet getCariBagian(String cari) throws SQLException {

try {




FROM tb_bng WHERE namabgn = ?");

perintah.setString(1, cari);


rs.first();



}

return rs;

}

public void isiTabelCariBagian() throws Exception {

try {




while (rs.next()) {


baris.add(rs.getString("kodebgn"));

baris.add(rs.getString("namabgn"));

tabel.add(baris);

}




}

}

public ResultSet getCariSemuaBagian(String kode) throws

ClassNotFoundException, SQLException {

try{




FROM tb_bgn WHERE kodebgn = ?");



rs.first();



}

return rs;

}

public ResultSet getSemuaBagian() throws ClassNotFoundException, SQLException

{




rs = stmt.executeQuery("SELECT * FROM tb_bgn ORDER BY kodebgn");

return rs;

}

public void isiTabelBagian() throws Exception {

try {




while (rs.next()) {


baris.add(rs.getString("kodebgn"));

16

baris.add(rs.getString("namabgn"));

tabel.add(baris);

}




}

}

Kode Program Data Barang Pada Panel Barang-“PanelBarang”

package gudang;







import gudang.FCPemasok;






import net.sf.jasperreports.engine.JRException;

import net.sf.jasperreports.engine.JRResultSetDataSource;

import net.sf.jasperreports.engine.JasperCompileManager;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.view.JasperViewer;

public class PanelBarang extends javax.swing.JPanel {

/** Creates new form PanelBarang */

public PanelBarang() {

initComponents();

}

/** This method is called from within the constructor to

* initialize the form.

* WARNING: Do NOT modify this code. The content of this method is

* always regenerated by the Form Editor.

*/


private void tf_namapemasokActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void tf_kodebnActionPerformed(java.awt.event.ActionEvent evt) {


}

private void bt_simpanbbActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getSimpanBB(tf_kodebb.getText(), tf_namabb.getText(),

tf_pemasok.getText(), tf_lotbb.getText(),

Integer.parseInt(tf_jumlahbb.getText()));

prosBersihBB();

prosTampilBB();



}

}

17


try {

prosTampilBN();

prosTampilBB();// TODO add your handling code here:


Logger.getLogger(PanelBarang.class.getName()).log(Level.SEVERE, null, ex);

}

}

private void bt_simpanbnActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getSimpanBN(tf_kodebn.getText(), tf_kodebb2.getText(),

tf_jtwist.getText(), tf_tipelot.getText(), tf_stdr.getText(), tf_ket.getText(),

Integer.parseInt("0"), Integer.parseInt("0"));

prosBersihBN();

prosTampilBN();



}

}

private void tf_jumlahbbActionPerformed(java.awt.event.ActionEvent evt) {


}

private void bt_cariPemasokActionPerformed(java.awt.event.ActionEvent evt) {

FCPemasok cari = new FCPemasok();

cari.pemasok = this;

cari.setVisible(true);

tf_pemasok.setText(kodepemasok);

tf_namapemasok.setText(namapemasok);

}

private void bt_ubahActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getUpdateBB(tf_namabb.getText(), tf_pemasok.getText(),

tf_lotbb.getText(), Integer.parseInt(tf_jumlahbb.getText()), tf_kodebb.getText());

prosBersihBB();

prosTampilBB();


JOptionPane.showMessageDialog(null, "Terjadi Kesalahan. Pastikan data yang

dimasukkan sesuai", "Warning", JOptionPane.WARNING_MESSAGE);

}


}

private void bt_hapusActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getDeleteBB(tf_kodebb.getText());

prosBersihBB();

prosTampilBB();


JOptionPane.showMessageDialog(null, "Masukkan Kode Barang");


}

private void bt_caribb2ActionPerformed(java.awt.event.ActionEvent evt) {

FCPBarang2 cari = new FCPBarang2();


cari.barang1 = this;


}

private void tf_lot2ActionPerformed(java.awt.event.ActionEvent evt) {


}

18

private void bt_updatebnActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getUpdateBN(tf_kodebb2.getText(), tf_jtwist.getText(),

tf_tipelot.getText(), tf_stdr.getText(), tf_ket.getText(),

Integer.parseInt(tf_bobbin.getText()), Integer.parseInt(tf_kg.getText()),

tf_kodebn.getText());

prosBersihBN();

prosTampilBN();


JOptionPane.showMessageDialog(null, "Terjadi Kesalahan. Pastikan data yang

dimasukkan sesuai", "Warning", JOptionPane.WARNING_MESSAGE);


}

private void bt_caribnActionPerformed(java.awt.event.ActionEvent evt) {

try {


cari.getSemuaBN(tf_kodebn.getText());

tf_kodebb2.setText(cari.rs.getString("kodebb"));

tf_namabb2.setText(cari.rs.getString("namabb"));

tf_lot2.setText(cari.rs.getString("lot"));

tf_pemasok2.setText("-");

tf_jtwist.setText(cari.rs.getString("twist"));

tf_tipelot.setText(cari.rs.getString("jtwist"));

tf_stdr.setText(cari.rs.getString("stdr"));

tf_ket.setText(cari.rs.getString("ket"));

tf_bobbin.setText(cari.rs.getString("jmlbobbin"));

tf_kg.setText(cari.rs.getString("jmlkg"));


JOptionPane.showMessageDialog(null, "Data Belum Ada");


}

private void bt_caribbActionPerformed(java.awt.event.ActionEvent evt) {

try {


cari.getCariSemuaBB(tf_kodebb.getText());

tf_namabb.setText(cari.rs.getString("namabb"));

tf_lotbb.setText(cari.rs.getString("lot"));

tf_pemasok.setText(cari.rs.getString("kodepmsk"));

tf_namapemasok.setText(cari.rs.getString("namapmsk"));

tf_jumlahbb.setText(cari.rs.getString("jumlah"));


JOptionPane.showMessageDialog(null, "Masukkan Kode Barang");


}

private void tbl_bahanbakuMouseClicked(java.awt.event.MouseEvent evt) {

int baris = tbl_bahanbaku.getSelectedRow();

tf_kodebb.setText(tbl_bahanbaku.getValueAt(baris, 0).toString());// TODO add

your handling code here:

}

private void tbl_bnMouseClicked(java.awt.event.MouseEvent evt) {

int baris = tbl_bn.getSelectedRow();

tf_kodebn.setText(tbl_bn.getValueAt(baris, 0).toString());// TODO add your

handling code here:

}

private void bt_hapusbnActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getDeleteBN(tf_kodebn.getText());

prosBersihBN();

prosTampilBN();



}

private void bt_cetakBBActionPerformed(java.awt.event.ActionEvent evt) {

try {

Connection koneksi1 = KoneksiDB.getConnection();

19

String filePemasok="src/laporan/lap_BB.jasper";

JasperPrint cetakLaporan = JasperFillManager.fillReport(filePemasok,null,

koneksi1);

JasperViewer tampillap=new JasperViewer(cetakLaporan,false);

tampillap.setVisible(true);

} catch (JRException ex) {

Logger.getLogger(Panel_laporan.class.getName()).log(Level.SEVERE, null,

ex);

} // TODO add your handling code here:

}

private void prosTampilBB() throws Exception {


objCRUD.getSemuaBB();

objCRUD.isiTabelBB();



tbl_bahanbaku.setModel(dtm);

objCRUD.getTutup();

}

private void prosBersihBB() throws Exception {

tf_kodebb.setText("");

tf_namabb.setText("");

tf_lotbb.setText("");

tf_pemasok.setText("");

tf_namapemasok.setText("");

}

private void prosTampilBN() throws Exception {


objCRUD.getBN();

objCRUD.isiTabelBN();



tbl_bn.setModel(dtm);

objCRUD.getTutup();

}

private void prosBersihBN() throws Exception {

tf_kodebn.setText("");

tf_kodebb2.setText("");

tf_namabb2.setText("");

tf_lot2.setText("");

tf_pemasok2.setText("");

tf_jtwist.setText("");

tf_tipelot.setText("");

tf_stdr.setText("");

tf_ket.setText("");

}

public String kodebarang, namabarang, asalbarang, lotbarang, kodepemasok,

namapemasok;

public String getkodePemasok() {

return kodepemasok;

}

public String getnamaPemasok() {

return namapemasok;

}

public String getkodeBarang() {

return kodebarang;

}

public String getnamaBarang() {

return namabarang;

}

20

public String getasalBarang() {

return asalbarang;

}

public String getlotBarang() {

return lotbarang;

}


private javax.swing.JButton bt_cariPemasok;

private javax.swing.JButton bt_caribb;

private javax.swing.JButton bt_caribb2;

private javax.swing.JButton bt_caribn;

private javax.swing.JButton bt_cetakBB;

private javax.swing.JButton bt_cetakBN;

private javax.swing.JButton bt_hapus;

private javax.swing.JButton bt_hapusbn;

private javax.swing.JButton bt_simpanbb;

private javax.swing.JButton bt_simpanbn;

private javax.swing.JButton bt_ubah;

private javax.swing.JButton bt_updatebn;



























private javax.swing.JTabbedPane jTabbedPane1;

private javax.swing.JTable jTable1;

private javax.swing.JTextField jTextField1;



private javax.swing.JTable tbl_bahanbaku;

private javax.swing.JTable tbl_bn;

private javax.swing.JTextField tf_bobbin;

private javax.swing.JTextField tf_jtwist;

private javax.swing.JTextField tf_jumlahbb;

private javax.swing.JTextField tf_ket;

private javax.swing.JTextField tf_kg;

private javax.swing.JTextField tf_kodebb;

public javax.swing.JTextField tf_kodebb2;

private javax.swing.JTextField tf_kodebn;

public javax.swing.JTextField tf_lot2;

private javax.swing.JTextField tf_lotbb;

private javax.swing.JTextField tf_namabb;

public javax.swing.JTextField tf_namabb2;

public javax.swing.JTextField tf_namapemasok;

public javax.swing.JTextField tf_pemasok;

public javax.swing.JTextField tf_pemasok2;

private javax.swing.JTextField tf_stdr;

private javax.swing.JTextField tf_tipelot;


}

Kode Program Panel Barang-Package control-“kontrol”

21

//Source Code PanelBarang_Bahan baku

public void getSimpanBB(String kodebb, String namabb, String kodepmsk, String

lot, Integer jumlah) throws ClassNotFoundException {

try {




tb_bb VALUES(?,?,?,?,?)");

perintah.setString(1, kodebb);

perintah.setString(2, namabb);


perintah.setString(4, lot);

perintah.setInt(5, jumlah);


ogS.getTutup();


JOptionPane.showMessageDialog(null, "Terjadi Kesalahan !");

}

}

public void getUpdateBB( String namabb, String kodepmsk, String lot, Integer

jumlah,String kodebb) throws SQLException, ClassNotFoundException {

try {




tb_bb SET namabb=?, kodepmsk=?, lot=?, jumlah=? WHERE kodebb=?");

perintah.setString(1, namabb);


perintah.setString(3, lot);

perintah.setInt(4, jumlah);



ogU.getTutup();



}

}

public void getDeleteBB(String kodebb) throws SQLException,


try {




tb_bb WHERE kodebb=?");



ogD.getTutup();


JOptionPane.showMessageDialog(null, "Tidak Dapat Dihapus, Data

Diguanakan Dalam Transaksi");

}

}

public ResultSet getCariSemuaBB(String kode) throws ClassNotFoundException,

SQLException {

try{



PreparedStatement perintah = ogCN.koneksi.prepareStatement("SELECT

`tb_bb`.`kodebb`,`tb_bb`.`namabb`,`tb_pemasok`.`kodepmsk`,`tb_pemasok`.`namapmsk`,

`tb_bb`.`lot`, `tb_bb`.`jumlah` FROM tb_bb LEFT JOIN `dbinventory`.`tb_pemasok` ON

`tb_bb`.`kodepmsk` = `tb_pemasok`.`kodepmsk` WHERE kodebb=?");



rs.first();



}

return rs;

}

22

public ResultSet getSemuaBB() throws ClassNotFoundException, SQLException {




rs = stmt.executeQuery("SELECT

`tb_bb`.`kodebb`,`tb_bb`.`namabb`,`tb_pemasok`.`kodepmsk`,`tb_pemasok`.`namapmsk`,

`tb_bb`.`lot`, `tb_bb`.`jumlah` FROM tb_bb LEFT JOIN `dbinventory`.`tb_pemasok` ON

`tb_bb`.`kodepmsk` = `tb_pemasok`.`kodepmsk` ");

return rs;

}

public void isiTabelBB() throws Exception {

try {




judulKolom.add("ASAL");

judulKolom.add("lOT");

judulKolom.add("JUMLAH");

while (rs.next()) {


baris.add(rs.getString("kodebb"));

baris.add(rs.getString("namabb"));


baris.add(rs.getString("lot"));

baris.add(rs.getInt("jumlah"));

tabel.add(baris);

}




}

}

public void isiTabelCariBB() throws Exception {

try {




judulKolom.add("ASAL");


while (rs.next()) {


baris.add(rs.getString("kodebb"));



baris.add(rs.getString("lot"));

tabel.add(baris);

}




}

}

//Source Code PanelBarang_Benang

public void getSimpanBN(String kodebn, String kodebb, String twist, String

jtwist, String stdr , String ket,Integer jumlahbobbin,Integer jumlahkg) throws


try {




tb_bn VALUES(?,?,?,?,?,?,?,?)");

perintah.setString(1, kodebn);


perintah.setString(3, twist);

perintah.setString(4, jtwist);

23

perintah.setString(5, stdr);

perintah.setString(6, ket);

perintah.setInt(7, jumlahbobbin);

perintah.setInt(8, jumlahkg);


ogS.getTutup();



}

}

public void getUpdateBN( String kodebb, String twist, String jtwist, String

stdr, String ket, Integer jmlbobbin, Integer jmlkg, String kodebn) throws

SQLException, ClassNotFoundException {

try {




tb_bn SET kodebb=?, twist=?, jtwist=?, stdr=?, ket=?, jmlbobbin=?, jmlkg=? WHERE

kodebn=?");


perintah.setString(2, twist);

perintah.setString(3, jtwist);

perintah.setString(4, stdr);

perintah.setString(5, ket);

perintah.setInt(6, jmlbobbin);

perintah.setInt(7, jmlkg);



ogU.getTutup();



}

}

public void getDeleteBN(String kodebn) throws SQLException,


try {




tb_bn WHERE kodebn=?");



ogD.getTutup();


JOptionPane.showMessageDialog(null, "Tidak Dapat Dihapus, Data

Diguanakan Dalam Transaksi");

}

}

public ResultSet getSemuaBN(String kode) throws ClassNotFoundException,

SQLException {

try{



PreparedStatement perintah = ogCN.koneksi.prepareStatement("SELECT

`tb_bn`.`kodebn`,`tb_bb`.`kodebb`,`tb_bb`.`namabb`,`tb_bb`.`lot`, `tb_bn`.`twist`,

`tb_bn`.`jtwist`,`tb_bn`.`stdr`,`tb_bn`.`jmlbobbin`,`tb_bn`.`jmlkg`,`tb_bn`.`ket`

FROM `tb_bn` LEFT JOIN `dbinventory`.`tb_bb` ON `tb_bn`.`kodebb` =

`tb_bb`.`kodebb` WHERE kodebn=?");



rs.first();



}

return rs;

}

public ResultSet getBN() throws ClassNotFoundException, SQLException {



24


rs = stmt.executeQuery("SELECT `tb_bn`.`kodebn`,`tb_bb`.`namabb`,CONCAT(

`tb_bb`.`lot` , '-', `tb_bn`.`twist` , '-', `tb_bn`.`jtwist` ) AS

LOT,`tb_bn`.`stdr`,`tb_bn`.`jmlbobbin`,`tb_bn`.`jmlkg`,`tb_bn`.`ket` FROM `tb_bn`

LEFT JOIN `dbinventory`.`tb_bb` ON `tb_bn`.`kodebb` = `tb_bb`.`kodebb`");

return rs;

}

public void isiTabelBN() throws Exception {

try {




judulKolom.add("LOT");

judulKolom.add("STDR");

judulKolom.add("KET");

judulKolom.add("BOBBIN");

judulKolom.add("KG");

while (rs.next()) {


baris.add(rs.getString("kodebn"));


baris.add(rs.getString("LOT"));

baris.add(rs.getString("stdr"));

baris.add(rs.getString("ket"));

baris.add(rs.getInt("jmlbobbin"));

baris.add(rs.getInt("jmlkg"));

tabel.add(baris);

}




}

}

public void isiTabelCariBN() throws Exception {

try {





while (rs.next()) {


baris.add(rs.getString("kodebn"));


baris.add(rs.getString("LOT"));

tabel.add(baris);

}




}

}

Kode Program Memasukkan Transaksi-“PanelTransaksi”

package gudang;









import gudang.FCPBarang;

25

import java.awt.CardLayout;

import java.sql.Date;


public class PanelTransaksi extends javax.swing.JPanel {

protected ResultSet rs;

protected Vector judulKolom = new Vector();

protected Vector tabel = new Vector();

DefaultTableModel tableModel = new DefaultTableModel(

new Object[][]{},

new String[]{

"Kd Barang", "Jenis Barang", "Lot", "Jumlah (Kg)"

});

DefaultTableModel tableModel2 = new DefaultTableModel(

new Object[][]{},

new String[]{

"Kd Barang", "Jenis Barang", "Lot", "Jumlah (Bobbin)", "Jumlah

(Kg)"

});

/** Creates new form PanelTransaksi */

public PanelTransaksi() {

initComponents();

setTanggal();

}

/** This method is called from within the constructor to

* initialize the form.

* WARNING: Do NOT modify this code. The content of this method is

* always regenerated by the Form Editor.

*/




}

private void bt_tambahbnkActionPerformed(java.awt.event.ActionEvent evt) {

bt_simpanbnk.setEnabled(true);

bt_hapustbnk.setEnabled(true);

int total = Integer.parseInt(tf_totalbobbink.getText());

int tambah = Integer.parseInt(tf_jmlbobbink.getText());

int total1 = total + tambah;

tf_totalbobbink.setText(String.valueOf(total1));

int total2 = Integer.parseInt(tf_totaltbnk.getText());

int tambah2 = Integer.parseInt(tf_kgbnk.getText());

int total3 = total2 + tambah2;

tf_totaltbnk.setText(String.valueOf(total3));

try {

String tKode = tf_kodebnk.getText();

String tNama = tf_namabnk.getText();

String tLot = tf_lotbnk.getText();

tableModel2.addRow(new Object[]{tKode, tNama, tLot, tambah, tambah2});

tbl_tbnk.setModel(tableModel2);


System.out.println("Error : " + e);


}

private void bt_simpanbnmActionPerformed(java.awt.event.ActionEvent evt) {

Boolean retAktif = cb_returBgn1.isSelected();

if (retAktif){

try {


objCRUD.getSimpanTranRetBN(tf_bonbnm.getText(),

Date.valueOf(tf_tglbonbn.getText()),

26

tf_kodebgnbnm.getText(),

Integer.parseInt(tf_totalbobbinm.getText()),

Integer.parseInt(tf_totaltbnm.getText()));

for (int i = 0; i < tbl_tbnm.getRowCount(); i++) {

String xkd = (String) tbl_tbnm.getValueAt(i, 0);

int xbobbin = (Integer) tbl_tbnm.getValueAt(i, 3);

int xkg = (Integer) tbl_tbnm.getValueAt(i, 4);

objCRUD.getSimpanDetailRetBN(tf_bonbnm.getText(), xkd, xbobbin,xkg);

}

prosBersihTBNM();

prosBersihTabelBN();


Logger.getLogger(PanelTransaksi.class.getName()).log(Level.SEVERE, null,

ex);

}

}else{

try {


objCRUD.getSimpanTranBNM(tf_bonbnm.getText(),

Date.valueOf(tf_tglbonbn.getText()), tf_kodebgnbnm.getText(),

Integer.parseInt(tf_totalbobbinm.getText()),

Integer.parseInt(tf_totaltbnm.getText()));

for (int i = 0; i < tbl_tbnm.getRowCount(); i++) {

String xkd = (String) tbl_tbnm.getValueAt(i, 0);

int xbobbin = (Integer) tbl_tbnm.getValueAt(i, 3);

int xkg = (Integer) tbl_tbnm.getValueAt(i, 4);

objCRUD.getSimpanDetailBNM(tf_bonbnm.getText(), xkd, xbobbin, xkg);

}

prosBersihTBNM();




ex);

}


}

}

private void bt_tambahbbkActionPerformed(java.awt.event.ActionEvent evt) {

bt_simpantbbk.setEnabled(true);

bt_hapustbbk.setEnabled(true);

int total = Integer.parseInt(tf_totaltbbk.getText());

int tambah = Integer.parseInt(tf_jumlahbbk.getText());


tf_totaltbbk.setText(String.valueOf(total1));

try {

String tKode = tf_kodebbk.getText();

String tNama = tf_namabbk.getText();

String tLot = tf_lotbbk.getText();

tableModel.addRow(new Object[]{tKode, tNama, tLot, tambah});

tbl_tbbk.setModel(tableModel);




}

private void bt_caribgnbbActionPerformed(java.awt.event.ActionEvent evt) {

FCBagian cari = new FCBagian();

cari.bagian = this;


// tf_kodebgnbb.setText(kodebagian);

// tf_namabgnbb.setText(namabagian);// TODO add your handling code here:

}

private void bt_caribbkActionPerformed(java.awt.event.ActionEvent evt) {

FCPBarang cari = new FCPBarang();

cari.barang = this;


27

tf_kodebbk.setText(kodebarang);

tf_namabbk.setText(namabarang);

tf_asalbbk.setText(asalbarang);

tf_lotbbk.setText(lotbarang);


}

private void bt_tambahbbActionPerformed(java.awt.event.ActionEvent evt) {

bt_simpantbbm.setEnabled(true);

bt_hapustbbm.setEnabled(true);

int total = Integer.parseInt(tf_totaltbbm.getText());

int tambah = Integer.parseInt(tf_jumlahbb.getText());


tf_totaltbbm.setText(String.valueOf(total1));

try {

String tKode = tf_kodebb.getText();

String tNama = tf_namabb.getText();

String tLot = tf_lotbb.getText();

tableModel.addRow(new Object[]{tKode, tNama, tLot, tambah});

tbl_tbbm.setModel(tableModel);




}

private void tf_tglbonbbActionPerformed(java.awt.event.ActionEvent evt) {


}

private void tf_caribbActionPerformed(java.awt.event.ActionEvent evt) {

FCPBarang cari = new FCPBarang();

cari.barang = this;


tf_kodebb.setText(kodebarang);

tf_namabb.setText(namabarang);

tf_asalbb.setText(asalbarang);

tf_lotbb.setText(lotbarang);// TODO add your handling code here:

}

private void bt_simpantbbmActionPerformed(java.awt.event.ActionEvent evt) {

Boolean retAktif = cb_returBgn.isSelected();

if (retAktif){

try {


objCRUD.getSimpanTranRetBB(tf_nobonbb.getText(),

Date.valueOf(tf_tglbonbb.getText()),

tf_bondari.getText(), Integer.parseInt(tf_totaltbbm.getText()));

for (int i = 0; i < tbl_tbbm.getRowCount(); i++) {

String xkd = (String) tbl_tbbm.getValueAt(i, 0);

int xkgbb = (Integer) tbl_tbbm.getValueAt(i, 3);

objCRUD.getSimpanDetailRetBB(tf_nobonbb.getText(),tf_bondari.getText(), xkd,

xkgbb);

}

prosBersihTBBM();

prosBersihTabelBB();



ex);

}

}else{

try {


objCRUD.getSimpanTranBBM(tf_nobonbb.getText(),

Date.valueOf(tf_tglbonbb.getText()),

tf_bondari.getText(), Integer.parseInt(tf_totaltbbm.getText()));

for (int i = 0; i < tbl_tbbm.getRowCount(); i++) {

String xkd = (String) tbl_tbbm.getValueAt(i, 0);

28

int xkgbb = (Integer) tbl_tbbm.getValueAt(i, 3);

objCRUD.getSimpanDetailBBM(tf_nobonbb.getText(), xkd, xkgbb);

}

prosBersihTBBM();




ex);

} // TODO add your handling code here:

}

}

private void tf_notabnkActionPerformed(java.awt.event.ActionEvent evt) {


}

private void bt_simpantbbkActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getSimpanTranBBK(tf_nonotabb.getText(),

Date.valueOf(tf_tglnotabb.getText()), tf_kodebgnbb.getText(),

Integer.parseInt(tf_totaltbbk.getText()));

for (int i = 0; i < tbl_tbbk.getRowCount(); i++) {

String xkd = (String) tbl_tbbk.getValueAt(i, 0);

int xkgbb = (Integer) tbl_tbbk.getValueAt(i, 3);

objCRUD.getSimpanDetailBBK(tf_nonotabb.getText(),

tf_kodebgnbb.getText(), xkd, xkgbb);

}

prosBersihTBBK();




ex);


}

private void bt_tambahbnmActionPerformed(java.awt.event.ActionEvent evt) {

bt_simpanbnm.setEnabled(true);

bt_hapustbnm.setEnabled(true);

int total = Integer.parseInt(tf_totalbobbinm.getText());

int tambah = Integer.parseInt(tf_jmlbobbinm.getText());


tf_totalbobbinm.setText(String.valueOf(total1));

int total2 = Integer.parseInt(tf_totaltbnm.getText());

int tambah2 = Integer.parseInt(tf_kgbnm.getText());

int total3 = total2 + tambah2;

tf_totaltbnm.setText(String.valueOf(total3));

try {

String tKode = tf_kodebnm.getText();

String tNama = tf_namabnm.getText();

String tLot = tf_lotbnm.getText();

tableModel2.addRow(new Object[]{tKode, tNama, tLot, tambah, tambah2});

tbl_tbnm.setModel(tableModel2);




}

private void bt_simpanbnkActionPerformed(java.awt.event.ActionEvent evt) {

try {


objCRUD.getSimpanTranBNK(tf_notabnk.getText(),

Date.valueOf(tf_tglnotabn.getText()), tf_kodebgnbnk.getText(),

Integer.parseInt(tf_totalbobbink.getText()),

Integer.parseInt(tf_totaltbnk.getText()));

for (int i = 0; i < tbl_tbnk.getRowCount(); i++) {

String xkd = (String) tbl_tbnk.getValueAt(i, 0);

int xbobbin = (Integer) tbl_tbnk.getValueAt(i, 3);

int xkg = (Integer) tbl_tbnk.getValueAt(i, 4);

objCRUD.getSimpanDetailBNK(tf_notabnk.getText(), xkd, xbobbin, xkg);

29

}

prosBersihTBNK();




ex);


}

private void bt_caribnmActionPerformed(java.awt.event.ActionEvent evt) {




tf_kodebnm.setText(kodebarang);

tf_namabnm.setText(namabarang);

tf_lotbnm.setText(lotbarang);// TODO add your handling code here:

}

private void bt_caribnkActionPerformed(java.awt.event.ActionEvent evt) {




tf_kodebnk.setText(kodebarang);

tf_namabnk.setText(namabarang);

tf_lotbnk.setText(lotbarang);// TODO add your handling code here:

}

private void bt_hapustbbkActionPerformed(java.awt.event.ActionEvent evt) {

if (tbl_tbbk.getRowCount() < 1) {

JOptionPane.showMessageDialog(null, "Data Yang Dihapus Tidak Ada");

} else {

int baris = tbl_tbbk.getSelectedRow();

int total = Integer.parseInt(tf_totaltbbk.getText());

int kurang = (Integer) tbl_tbbk.getValueAt(baris, 3);

tf_totaltbbk.setText(String.valueOf(total - kurang));

tableModel.removeRow(baris);

}


}

private void bt_hapustbnmActionPerformed(java.awt.event.ActionEvent evt) {

if (tbl_tbnm.getRowCount() < 1) {

JOptionPane.showMessageDialog(null, "Data Yang Dihapus Tidak Ada");

} else {

int baris = tbl_tbnm.getSelectedRow();

int total = Integer.parseInt(tf_totalbobbinm.getText());

int kurang = (Integer) tbl_tbnm.getValueAt(baris, 3);

tf_totalbobbinm.setText(String.valueOf(total - kurang));

int total1 = Integer.parseInt(tf_totaltbnm.getText());

int kurang1 = (Integer) tbl_tbnm.getValueAt(baris, 4);

tf_totaltbnm.setText(String.valueOf(total1 - kurang1));

tableModel2.removeRow(baris);


}

private void bt_hapustbnkActionPerformed(java.awt.event.ActionEvent evt) {

int jmlbaris = tbl_tbnk.getRowCount();

if (jmlbaris 1) {

int baris = tbl_tbnk.getSelectedRow();

int total = Integer.parseInt(tf_totalbobbink.getText());

int kurang = (Integer) tbl_tbnk.getValueAt(baris, 3);

tf_totalbobbink.setText(String.valueOf(total - kurang));

int total1 = Integer.parseInt(tf_totaltbnk.getText());

int kurang1 = (Integer) tbl_tbnk.getValueAt(baris, 4);

tf_totaltbnk.setText(String.valueOf(total1 - kurang1));

tableModel2.removeRow(baris);

30


}

private void jPanel2ComponentShown(java.awt.event.ComponentEvent evt) {

tf_kodebgnbb.setText("");

tf_namabgnbb.setText("");

tf_kodebbk.setText("");

tf_namabbk.setText("");

tf_lotbbk.setText("");

tf_asalbbk.setText("");

bt_simpantbbk.setEnabled(false);

bt_hapustbbk.setEnabled(false);// TODO add your handling code here:

}


tf_kodebgnbnm.setText("");

tf_kodebnm.setText("");

tf_namabnm.setText("");

tf_lotbnm.setText("");

bt_simpanbnm.setEnabled(false);

bt_hapustbnm.setEnabled(false);


}


tf_kodebgnbnk.setText("");

tf_namabgnbnk.setText("");

tf_kodebnk.setText("");

tf_namabnk.setText("");

tf_lotbnk.setText("");

bt_simpanbnk.setEnabled(false);

bt_hapustbnk.setEnabled(false);


}




tf_asalbb.setText("");


bt_simpantbbm.setEnabled(false);

bt_hapustbbm.setEnabled(false);

bt_caribagian.setEnabled(false);


}

private void bt_hapustbbmActionPerformed(java.awt.event.ActionEvent evt) {

int jmlbaris = tbl_tbbm.getRowCount();

if (jmlbaris 1) {

int baris1 = tbl_tbbm.getSelectedRowCount();

if (baris1 < 1) {

JOptionPane.showMessageDialog(null, "Pilih Data Yang Akan Dihapus");

} else {

int baris = tbl_tbbm.getSelectedRow();

int total = Integer.parseInt(tf_totaltbbm.getText());

int kurang = (Integer) tbl_tbbm.getValueAt(baris, 3);

tf_totaltbbm.setText(String.valueOf(total - kurang));

tableModel.removeRow(baris);

}

}

}

private void bt_bgnbnmActionPerformed(java.awt.event.ActionEvent evt) {


cari.bagian = this;

cari.setVisible(true);// TODO add your handling code here:

}

private void bt_caribgnbnkActionPerformed(java.awt.event.ActionEvent evt) {

31


cari.bagian = this;


}

private void cb_returBgnActionPerformed(java.awt.event.ActionEvent evt) {

Boolean aktif = cb_returBgn.isSelected();

if (aktif) {

bt_caribagian.setEnabled(true);

} else {


}


}

private void bt_caribagianActionPerformed(java.awt.event.ActionEvent evt) {


cari.bagian = this;


}

private void cb_returBgn1ActionPerformed(java.awt.event.ActionEvent evt) {


}

private void prosTampilBB() throws Exception {


objCRUD.getSemuaBB();

objCRUD.isiTabelBB();



tbl_tbbk.setModel(dtm);

objCRUD.getTutup();

}

private void prosBersihTBBM() throws Exception {

tf_nobonbb.setText("");

tf_bondari.setText("");




tf_asalbb.setText("");

tf_jumlahbb.setText("0");

tf_totaltbbm.setText("0");

bt_simpantbbm.setEnabled(false);

bt_hapustbbm.setEnabled(false);


cb_returBgn.setSelected(false);

}

private void prosBersihTBBK() throws Exception {

tf_nonotabb.setText("");

tf_kodebgnbb.setText("");

tf_namabgnbb.setText("");

tf_kodebbk.setText("");

tf_namabbk.setText("");

tf_lotbbk.setText("");

tf_asalbbk.setText("");

tf_jumlahbbk.setText("0");

tf_totaltbbk.setText("0");

bt_simpantbbk.setEnabled(false);

bt_hapustbbk.setEnabled(false);

}

private void prosBersihTBNM() throws Exception {

tf_bonbnm.setText("");

tf_kodebgnbnm.setText("");

tf_kodebnm.setText("");

tf_namabnm.setText("");

tf_lotbnm.setText("");

32

tf_jmlbobbinm.setText("0");

tf_kgbnm.setText("0");

tf_totalbobbinm.setText("0");

tf_totaltbnm.setText("0");

bt_simpanbnm.setEnabled(false);

bt_hapustbnm.setEnabled(false);

}

private void prosBersihTBNK() throws Exception {

tf_notabnk.setText("");

tf_kodebgnbnk.setText("");

tf_namabgnbnk.setText("");

tf_kodebnk.setText("");

tf_namabnk.setText("");

tf_lotbnk.setText("");

tf_jmlbobbink.setText("0");

tf_kgbnk.setText("0");

tf_totalbobbink.setText("0");

tf_totaltbnk.setText("0");

bt_simpanbnk.setEnabled(false);

bt_hapustbnk.setEnabled(false);

}

private void prosBersihTabelBB() throws Exception {

int i = tableModel.getRowCount();

for (int r = 0; r < i; r++) {

tableModel.removeRow(0);

}

}

private void prosBersihTabelBN() throws Exception {

int i = tableModel2.getRowCount();

for (int r = 0; r < i; r++) {

tableModel2.removeRow(0);

}

}

public void setTanggal() {

java.util.Date skrg = new java.util.Date();

java.text.SimpleDateFormat kal = new java.text.SimpleDateFormat("yyyy-MM-

dd");

tf_tglbonbb.setText(kal.format(skrg));

tf_tglnotabb.setText(kal.format(skrg));

tf_tglbonbn.setText(kal.format(skrg))

lampiran 1. lampiran utama...surat jalan nota penyerahan bukti timbangan bahan baku barang dicek...

Documents