Lampiran 1: Struktur Orgasnisasi Perusahaan Spv. Spv ...
Transcript of Lampiran 1: Struktur Orgasnisasi Perusahaan Spv. Spv ...
Lampiran 1: Struktur Orgasnisasi Perusahaan
BOARD OF
COMMISSIONER
PRESIDENT
DIRECTOR
VICE PRESIDENT
Sales & Marketing
DirectorHRD & GA
Director
Accounting &
Finance DirectorProduction
Manager
Maintenance
ManagerQuality Control
Manager
Sales & Marketing
ManagerAccounting
ManagerFinance Manager HRD Manager GA Manager
Internal AuditorExecutive
Secretary
AM West
Java
AM East
Java
AM
Central
Java
WHFP
Koord.
Staff
WHRP
Koord.
Purchasing
Spv
IT &
Processing
Spv.
Accounting
Spv.Cashier
StaffStaff Adm
StaffStaff
Driver, Security, Maintenance
Building, General Employees.
Production
Assistant Manager
Staff
Admin
Engineering
Staff
WHSP &
RM
Process
Spv.
Foremen
Production
Employees
PPIC
Staff
Adm
Chief of
Electric
Chief of
Mechanic
Chief of
Utility
Otomotif
Genset
Electrical
Engineering
Boiler
QC Laboratory
Staff
Admin
LOADING
Koord.
HUMAS
Management
Representative
Lampiran 2: Flowchart Bahan Baku Kertas Semen
Analytic Flowchart
Prosedur Penilaian Supplier Bahan Baku Kertas
Bagian Gudang Timbangan Audit Internal
MULAI
Surat
Jalan
12
Kertas
Menerima bahan baku
kertas
1
Surat
Jalan
12
Kertas
1
Menimbang,
membuat Struk
Timbangan (ST) dan
menandatangani
Surat
Jalan
12
Kertas
Struk
Timbangan
(ST)
12
2
Surat
Jalan
12
Kertas
Struk
Timbangan
(ST)
12
2
Gudang
penyimpanan
kertas
Informasi
no.polisi truk,
supplier, berat
setelah
ditimbang
3
Informasi
no.polisi truk,
supplier, berat
setelah
ditimbang
3
Mengecek kadar air
kertas, membuat
Laporan Hasil
Pengecekan (LHP)
LHP1
23
Menandatangani
, ditandatangani
oleh Ka. Audit
Internal
LHP1
23
4
LHP1
23
4
Membuat
Tanda Terima
Barang (TTB)
TTB1
23
Surat
Jalan
12 Struk
Timbangan
(ST)
12
LHP1
23
A
Kualitas
SupplierBersih
Kotor
Lampiran 3: Flowchart Bahan Baku Kertas Semen lanjutan
A
Analytic Flowchart
Prosedur Penilaian Supplier Bahan Baku Kertas
Bagian Gudang Audit Internal Bagian Pembelian
TTB1
23
Surat
Jalan
12
Struk
Timbangan
(ST)
12
LHP1
23
menandatanga
ni
Ditandatangani oleh
pengirim, penerima,
Ka.Gudang
LHP1
23
TTB1
23
Supplier5
Surat
Jalan
12
5
LHP3
D
TTB3Struk
Timbangan
(ST)
2
Membuat
penilaian
supplier
Penilaian
supplierTTB
3Struk
Timbangan
(ST)
2
SELESAI
8
TTB3Struk
Timbangan
(ST)
2
D
Formulir
Penilaian
Supplier
Bagian Keuangan
6
6
Supplier
Struk
Timbanga
n (ST)
2
TTB2
3Surat
Jalan
1LHP
1
7
7
8
Lampiran 4: Flowchart Bahan Baku Semen
Analytic Flowchart
Prosedur Penilaian Supplier Bahan Baku Semen
Bagian Gudang Bagian Pembelian
MULAI
Surat Jalan1
2 semen
Menerima bahan baku
semen
Memeriksa
kondisi bahan
baku semen
sesuai
supplier
tidak
Membuat Tanda
Terima Barang
(TTB)
ya
Surat Jalan1
2Sem
en
Gudang
penyimpanan semen
TTB
12
3
Menandatangani
(oleh pengirim,
penerima, dan
Ka.Gudang
TTB
12
3
Surat Jalan1
2
1
supplier
2
TTB3
Membuat
penilaian
supplier
Penilaian
supplierTTB
3
3
SELESAI
TTB3
3
D
Formulir
Penilaian
Supplier
Bagian Keuangan
Surat Jalan2
TTB2
3
1
2
Lampiran 5: Flowchart Bahan Baku Asbestos/Chrysotile
Analytic Flowchart
Prosedur Penilaian Supplier Bahan Baku Asbestos/Chrysotile
Bagian Gudang Bagian Pembelian
MULAI
Surat Jalan1
2A
sbestos/
Chrysotile
Menerima bahan baku
Asbestos/Chrysotile
Memeriksa
kondisi bahan
baku Asbestos/
Chrysotile
sesuai
supplier
tidak
Membuat Tanda
Terima Barang
(TTB)
ya
Surat Jalan1
2A
sbestos/
Chrysotile
Gudang
penyimpanan
Asbestos/Chrysotile
TTB
12
3
Menandatangani
(oleh pengirim,
penerima, dan
Ka.Gudang
TTB
12
3
Surat Jalan1
2
1
supplier
2
TTB3
Membuat
penilaian
supplier
Penilaian
supplierTTB
3
3
SELESAI
TTB3
3
D
Formulir
Penilaian
Supplier
Bagian Keuangan
Surat Jalan2
TTB2
3
1
2
Lampiran 6: Coding List
1. Class kontrol
public Statement stmt = null;
public ResultSet rs;
public Vector judulKolom = new Vector();
public Vector tabel = new Vector();
public ResultSet getRs() {
return rs;
}
public void getTambahSupp(String vid_supplier, String vnama_supplier, String
vkota, String valamat, String vtelp, String vfax) throws ClassNotFoundException {
try {
koneksi ogT = new koneksi();
ogT.getBuka();
PreparedStatement perintah = ogT.conn.prepareStatement("INSERT INTO
supplier VALUES(?,?,?,?,?,?)");
perintah.setString(1, vid_supplier);
perintah.setString(2, vnama_supplier);
perintah.setString(3, vkota);
perintah.setString(4, valamat);
perintah.setString(5, vtelp);
perintah.setString(6, vfax);
perintah.executeUpdate();
ogT.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getTambahPo(Integer vno, String vno_po, String vid_supplier, String
vdel_date, String vtgl_po) throws ClassNotFoundException {
try {
koneksi ogTPo = new koneksi();
ogTPo.getBuka();
PreparedStatement perintah = ogTPo.conn.prepareStatement("INSERT INTO po
VALUES(?,?,?,?,?)");
perintah.setInt(1, vno);
perintah.setString(2, vno_po);
perintah.setString(3, vid_supplier);
perintah.setString(4, vdel_date);
perintah.setString(5, vtgl_po);
perintah.executeUpdate();
ogTPo.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getTambahAs(Integer vno, String vno_po, String vno_ttb, String
vtgl_faktur, Integer vnilai, String vperiode) throws ClassNotFoundException,
ParseException {
try {
koneksi ogTAs = new koneksi();
ogTAs.getBuka();
PreparedStatement perintah = ogTAs.conn.prepareStatement("INSERT INTO
ps_asbestos VALUES(?,?,?,?,?,?)");
perintah.setInt(1, vno);
perintah.setString(2, vno_po);
perintah.setString(3, vno_ttb);
perintah.setString(4, vtgl_faktur);
perintah.setInt(5, vnilai);
perintah.setString(6, vperiode);
perintah.executeUpdate();
ogTAs.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getTambahSe(Integer vno, String vno_po, String vno_ttb, String
vtgl_faktur, Integer vnilai, String vperiode) throws ClassNotFoundException,
ParseException {
try {
koneksi ogTSe = new koneksi();
ogTSe.getBuka();
PreparedStatement perintah = ogTSe.conn.prepareStatement("INSERT INTO
ps_semen VALUES(?,?,?,?,?,?)");
perintah.setInt(1, vno);
perintah.setString(2, vno_po);
perintah.setString(3, vno_ttb);
perintah.setString(4, vtgl_faktur);
perintah.setInt(5, vnilai);
perintah.setString(6, vperiode);
perintah.executeUpdate();
ogTSe.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getTambahKer(Integer vno, String vno_po, String vno_ttb, Float
vkadar_air, Float vnilai_ka, Float vnilai, String vperiode) throws
ClassNotFoundException, ParseException {
try {
koneksi ogTKer = new koneksi();
ogTKer.getBuka();
PreparedStatement perintah = ogTKer.conn.prepareStatement("INSERT INTO
ps_kertas VALUES(?,?,?,?,?,?,?)");
perintah.setInt(1, vno);
perintah.setString(2, vno_po);
perintah.setString(3, vno_ttb);
perintah.setFloat(4, vkadar_air);
perintah.setFloat(5, vnilai_ka);
perintah.setFloat(6, vnilai);
perintah.setString(7, vperiode);
perintah.executeUpdate();
ogTKer.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getTambahUser(String vusername, String vpassword) throws
ClassNotFoundException, ParseException {
try {
koneksi ogTKer = new koneksi();
ogTKer.getBuka();
PreparedStatement perintah = ogTKer.conn.prepareStatement("INSERT INTO
karyawan VALUES(?,?)");
perintah.setString(1, vusername);
perintah.setString(2, vpassword);
perintah.executeUpdate();
ogTKer.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getPerbaharuiSupp(String vnama_supplier, String vkota, String
valamat, String vtelp, String vfax, String vid_supplier) throws SQLException,
ClassNotFoundException {
try {
koneksi ogPS = new koneksi();
ogPS.getBuka();
PreparedStatement perintah = ogPS.conn.prepareStatement("UPDATE supplier
SET nama_supplier=?, kota=?, alamat=?, telp=?, fax=? WHERE id_supplier=?");
perintah.setString(1, vnama_supplier);
perintah.setString(2, vkota);
perintah.setString(3, valamat);
perintah.setString(4, vtelp);
perintah.setString(5, vfax);
perintah.setString(6, vid_supplier);
perintah.executeUpdate();
ogPS.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getPerbaharuiPo(Integer vno,String vno_po, String vid_supplier,
String vdel_date, String vtgl_po) throws SQLException, ClassNotFoundException {
koneksi ogPPo = new koneksi();
ogPPo.getBuka();
PreparedStatement perintah = ogPPo.conn.prepareStatement("UPDATE po SET
no_po=?, id_supplier=?, del_date=?, tgl_po=? WHERE no=?");
perintah.setString(1, vno_po);
perintah.setString(2, vid_supplier);
perintah.setString(3, vdel_date);
perintah.setString(4, vtgl_po);
perintah.setInt(5, vno);
perintah.executeUpdate();
ogPPo.getTutup();
}
public void getPerbaharuiAs(String vno_po, String vno_ttb, String vtgl_faktur,
Integer vnilai, String vperiode,Integer vno) throws SQLException,
ClassNotFoundException {
koneksi ogPAs = new koneksi();
ogPAs.getBuka();
PreparedStatement perintah = ogPAs.conn.prepareStatement("UPDATE ps_asbestos
SET no_po=?, no_ttb=?, tgl_faktur=?, nilai=?, periode=? WHERE no=?");
perintah.setString(1, vno_po);
perintah.setString(2, vno_ttb);
perintah.setString(3, vtgl_faktur);
perintah.setInt(4, vnilai);
perintah.setString(5, vperiode);
perintah.setInt(6, vno);
perintah.executeUpdate();
ogPAs.getTutup();
}
public void getPerbaharuiSe(String vno_po, String vno_ttb, String vtgl_faktur,
Integer vnilai, String vperiode,Integer vno) throws SQLException,
ClassNotFoundException {
koneksi ogPSe = new koneksi();
ogPSe.getBuka();
PreparedStatement perintah = ogPSe.conn.prepareStatement("UPDATE ps_semen
SET no_po=?, no_ttb=?, tgl_faktur=?, nilai=?, periode=? WHERE no=?");
perintah.setString(1, vno_po);
perintah.setString(2, vno_ttb);
perintah.setString(3, vtgl_faktur);
perintah.setInt(4, vnilai);
perintah.setString(5, vperiode);
perintah.setInt(6, vno);
perintah.executeUpdate();
ogPSe.getTutup();
}
public void getPerbaharuiKer(String vno_po, String vno_ttb, Float vkadar_air,
Float vnilai_ka, Float vnilai, String vperiode, Integer vno) throws SQLException,
ClassNotFoundException {
koneksi ogPSe = new koneksi();
ogPSe.getBuka();
PreparedStatement perintah = ogPSe.conn.prepareStatement("UPDATE ps_kertas
SET no_po=?, no_ttb=?, kadar_air=?, nilai_ka=?, nilai_ka=?, periode=? WHERE no=?");
perintah.setString(1, vno_po);
perintah.setString(2, vno_ttb);
perintah.setFloat(3, vkadar_air);
perintah.setFloat(4, vnilai_ka);
perintah.setFloat(5, vnilai);
perintah.setString(6, vperiode);
perintah.setInt(7, vno);
perintah.executeUpdate();
ogPSe.getTutup();
}
public void getHapusSupp(String vid_supplier) throws SQLException,
ClassNotFoundException {
try {
koneksi ogHS = new koneksi();
ogHS.getBuka();
PreparedStatement perintah = ogHS.conn.prepareStatement("DELETE FROM
supplier WHERE id_supplier=?");
perintah.setString(1, vid_supplier);
perintah.executeUpdate();
ogHS.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void getHapusPo(String vno_po) throws SQLException,
ClassNotFoundException {
try {
koneksi ogHP = new koneksi();
ogHP.getBuka();
PreparedStatement perintah = ogHP.conn.prepareStatement("DELETE FROM po
WHERE no_po=?");
perintah.setString(1, vno_po);
perintah.executeUpdate();
ogHP.getTutup();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public ResultSet getCariSupp(String vid_supplier) throws SQLException {
try {
koneksi ogCS = new koneksi();
ogCS.getBuka();
PreparedStatement perintah = ogCS.conn.prepareStatement("SELECT * FROM
supplier WHERE id_supplier=?");
perintah.setString(1, vid_supplier);
rs = perintah.executeQuery();
rs.first();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
return rs;
}
public ResultSet getSemuaSupp() throws ClassNotFoundException, SQLException {
koneksi ogSS = new koneksi();
ogSS.getBuka();
stmt = ogSS.conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM supplier ORDER BY id_supplier");
return rs;
}
public ResultSet getSemuaPo() throws ClassNotFoundException, SQLException {
koneksi ogSPo = new koneksi();
ogSPo.getBuka();
stmt = ogSPo.conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM po ORDER BY no");
return rs;
}
public ResultSet getSemuaAs() throws ClassNotFoundException, SQLException {
koneksi ogSA = new koneksi();
ogSA.getBuka();
stmt = ogSA.conn.createStatement();
rs = stmt.executeQuery("SELECT `ps_asbestos`.`no` , `ps_asbestos`.`no_po` ,
`ps_asbestos`.`no_ttb` , `ps_asbestos`.`tgl_faktur` , `po`.`del_date` ,
`ps_asbestos`.`nilai` "
+ "FROM `ps_asbestos` LEFT JOIN `tripilar`.`po` ON
`ps_asbestos`.`no_po` = `po`.`no_po` ");
return rs;
}
public ResultSet getSemuaSe() throws ClassNotFoundException, SQLException {
koneksi ogSS = new koneksi();
ogSS.getBuka();
stmt = ogSS.conn.createStatement();
rs = stmt.executeQuery("SELECT `ps_semen`.`no` , `ps_semen`.`no_po` ,
`ps_semen`.`no_ttb` , `ps_semen`.`tgl_faktur` , `po`.`del_date` , `ps_semen`.`nilai`
"
+ "FROM `ps_semen` LEFT JOIN `tripilar`.`po` ON `ps_semen`.`no_po` =
`po`.`no_po` ");
return rs;
}
public ResultSet getSemuaKer() throws ClassNotFoundException, SQLException {
koneksi ogSK = new koneksi();
ogSK.getBuka();
stmt = ogSK.conn.createStatement();
rs = stmt.executeQuery("SELECT `ps_kertas`.`no` , `ps_kertas`.`no_po` ,
`ps_kertas`.`no_ttb` , `ps_kertas`.`kadar_air` , "
+ "`ps_kertas`.`nilai_ka` , `ps_kertas`.`nilai` "
+ "FROM `ps_kertas` LEFT JOIN `tripilar`.`po` ON `ps_kertas`.`no_po`
= `po`.`no_po` ");
return rs;
}
public void isiTabelSupp() throws Exception {
try {
koneksi oiT = new koneksi();
judulKolom.add("Id Supplier");
judulKolom.add("Nama Supplier");
judulKolom.add("Kota");
judulKolom.add("Alamat");
judulKolom.add("No. Telp");
judulKolom.add("No. Fax");
while (rs.next()) {
Vector baris = new Vector();
baris.add(rs.getString("id_Supplier"));
baris.add(rs.getString("nama_supplier"));
baris.add(rs.getString("kota"));
baris.add(rs.getString("alamat"));
baris.add(rs.getString("telp"));
baris.add(rs.getString("fax"));
tabel.add(baris);
}
System.out.println("Tabel berhasil di Isi");
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void isiTabelPo() throws Exception {
try {
koneksi oiTPo = new koneksi();
judulKolom.add("No");
judulKolom.add("No. Purchase Order");
judulKolom.add("Id Supplier");
judulKolom.add("Tanggal PO");
judulKolom.add("Delivery Date");
while (rs.next()) {
Vector baris = new Vector();
baris.add(rs.getString("no"));
baris.add(rs.getString("no_po"));
baris.add(rs.getString("id_supplier"));
baris.add(rs.getString("tgl_po"));
baris.add(rs.getString("del_date"));
tabel.add(baris);
}
System.out.println("Tabel berhasil di Isi");
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void isiTabelAs() throws Exception {
try {
koneksi oiTAs = new koneksi();
judulKolom.add("No");
judulKolom.add("No. Purchase Order");
judulKolom.add("No TTB");
judulKolom.add("Tanggal Faktur");
judulKolom.add("Delivery Date");
judulKolom.add("Nilai");
while (rs.next()) {
Vector baris = new Vector();
baris.add(rs.getString("no"));
baris.add(rs.getString("no_po"));
baris.add(rs.getString("no_ttb"));
baris.add(rs.getString("tgl_faktur"));
baris.add(rs.getString("del_date"));
baris.add(rs.getString("nilai"));
tabel.add(baris);
}
System.out.println("Tabel berhasil di Isi");
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void isiTabelSe() throws Exception {
try {
koneksi oiTSe = new koneksi();
judulKolom.add("No");
judulKolom.add("No. Purchase Order");
judulKolom.add("No TTB");
judulKolom.add("Tanggal Faktur");
judulKolom.add("Delivery Date");
judulKolom.add("Nilai");
while (rs.next()) {
Vector baris = new Vector();
baris.add(rs.getString("no"));
baris.add(rs.getString("no_po"));
baris.add(rs.getString("no_ttb"));
baris.add(rs.getString("tgl_faktur"));
baris.add(rs.getString("del_date"));
baris.add(rs.getString("nilai"));
tabel.add(baris);
}
System.out.println("Tabel berhasil di Isi");
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public void isiTabelKer() throws Exception {
try {
koneksi oiTKer = new koneksi();
judulKolom.add("No.");
judulKolom.add("No. Purchase Order");
judulKolom.add("No TTB");
judulKolom.add("Kadar Air");
judulKolom.add("Nilai Ka");
judulKolom.add("Nilai");
while (rs.next()) {
Vector baris = new Vector();
baris.add(rs.getString("no"));
baris.add(rs.getString("no_po"));
baris.add(rs.getString("no_ttb"));
baris.add(rs.getString("kadar_air"));
baris.add(rs.getString("nilai_ka"));
baris.add(rs.getString("nilai"));
tabel.add(baris);
}
System.out.println("Tabel berhasil di Isi");
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public ResultSet getIsiComboSupp() throws ClassNotFoundException, SQLException {
koneksi ogICS = new koneksi();
ogICS.getBuka();
stmt = ogICS.conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT id_supplier FROM supplier ORDER BY
id_supplier");
return rs;
}
public ResultSet getIsiUser() throws ClassNotFoundException, SQLException {
koneksi ogIU = new koneksi();
ogIU.getBuka();
stmt = ogIU.conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT username FROM karyawan ORDER BY
username");
return rs;
}
public ResultSet getIsiComboAs() throws ClassNotFoundException, SQLException {
koneksi ogICA = new koneksi();
ogICA.getBuka();
stmt = ogICA.conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT no_po FROM po ORDER BY no_po");
return rs;
}
public ResultSet getIsiComboSe() throws ClassNotFoundException, SQLException {
koneksi ogICS = new koneksi();
ogICS.getBuka();
stmt = ogICS.conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT no_po FROM po ORDER BY no_po");
return rs;
}
public ResultSet getIsiComboKer() throws ClassNotFoundException, SQLException {
koneksi ogICK = new koneksi();
ogICK.getBuka();
stmt = ogICK.conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT no_po FROM po ORDER BY no_po");
return rs;
}
public ResultSet getIsiDataAs(String vno_po) throws ClassNotFoundException,
SQLException {
koneksi ogIDA = new koneksi();
ogIDA.getBuka();
stmt = ogIDA.conn.createStatement();
rs = stmt.executeQuery("SELECT nama_supplier, del_date, tgl_po FROM po,
supplier where po.no_po='" + vno_po + "' AND po.id_supplier=supplier.id_supplier");
return rs;
}
public ResultSet getIsiDataSe(String vno_po) throws ClassNotFoundException,
SQLException {
koneksi ogIDS = new koneksi();
ogIDS.getBuka();
stmt = ogIDS.conn.createStatement();
rs = stmt.executeQuery("SELECT nama_supplier, del_date, tgl_po FROM po,
supplier where po.no_po='" + vno_po + "' AND po.id_supplier=supplier.id_supplier");
return rs;
}
public ResultSet getIsiDataKer(String vno_po) throws ClassNotFoundException,
SQLException {
koneksi ogIDK = new koneksi();
ogIDK.getBuka();
stmt = ogIDK.conn.createStatement();
rs = stmt.executeQuery("SELECT nama_supplier, del_date, tgl_po FROM po,
supplier where po.no_po='" + vno_po + "' AND po.id_supplier=supplier.id_supplier");
return rs;
}
}
2. Class koneksi
public class koneksi {
public static Connection conn = null;
public static Connection getBuka() throws ClassNotFoundException{
try {
Class.forName("com.mysql.jdbc.Driver");
conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/tripilar", "root", "");
System.out.println("Koneksi Berhasil di Buka");
} catch (SQLException ex) {
ex.printStackTrace();
}
return conn;
}
public Connection getTutup() throws SQLException {
try {
if (conn != null) {
conn.close();
}
System.out.println("Koneksi Berhasil di Tutup");
} catch (SQLException ex) {
ex.printStackTrace();
}
return conn;
}
}
3. Class login_button “login”
private void bt_loginActionPerformed(java.awt.event.ActionEvent evt) {
koneksi kon = new koneksi();
try {
String sql = "select * from karyawan where username='" + tf1.getText() +
"'and password='"
+ String.valueOf(tf2.getPassword()) + "'";
kon.getBuka();
stmt = kon.conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
utama hm = new utama();
hm.setVisible(true);
this.dispose();
} else {
JOptionPane.showMessageDialog(null, "Login Error !!!");
}
} catch (Exception e) {
tf1.setText("");
tf2.setText("");
JOptionPane.showMessageDialog(null, "Kesalahan dalam Input Data");
}
}
4. Class utama_menu “form”
Dituliskan pada setiap menu
private void d_psActionPerformed(java.awt.event.ActionEvent evt) {
new po().show();
dispose();
}
private void d_supplierActionPerformed(java.awt.event.ActionEvent evt) {
new supplier().show();
dispose();
}
private void out_utamaActionPerformed(java.awt.event.ActionEvent evt) {
new login().show();
dispose();
}
private void ps_laporanActionPerformed(java.awt.event.ActionEvent evt) {
new laporan().show();
dispose();
}
private void input_semenActionPerformed(java.awt.event.ActionEvent evt) {
new ps_semen().show();
dispose();
}
private void input_asbestosActionPerformed(java.awt.event.ActionEvent evt) {
new ps_asbestos().show();
dispose();
}
private void input_kertasActionPerformed(java.awt.event.ActionEvent evt) {
new ps_kertas().show();
dispose();
}
private void jtambahuserActionPerformed(java.awt.event.ActionEvent evt) {
new tambahuser().show();
dispose();
}
5. Class tambahuser
a. Button “Buat”
private void bt_tambahuserActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getTambahUser(tf_usertambah.getText(),
tf_passtambah.getText());
} catch (Exception ex) {
ex.printStackTrace();
}
new login().show();
dispose();
}
b. Button “Batal”
private void bt_batalActionPerformed(java.awt.event.ActionEvent evt) {
new utama().show();
dispose();
}
6. Class supplier
a. Button “Tambah”
private void bt_tambah_suppActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getTambahSupp(tf_idsupp.getText(), tf_namasupp.getText(),
tf_kota.getText(), tf_alamat.getText(), tf_telp.getText(), tf_fax.getText());
BersihSupp();
TampilTabelSupp();
} catch (Exception ex) {
ex.printStackTrace();
}
}
b. Button “Perbaharui”
private void bt_perbaharui_suppActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getPerbaharuiSupp(tf_namasupp.getText(), tf_kota.getText(),
tf_alamat.getText(), tf_telp.getText(), tf_fax.getText(), tf_idsupp.getText());
objCRUD.getTutup();
BersihSupp();
TampilTabelSupp();
} catch (Exception ex) {
ex.printStackTrace();
}
}
c. Button “Hapus”
private void bt_hapus_suppActionPerformed(java.awt.event.ActionEvent evt) {
if (JOptionPane.showConfirmDialog(this,
"Anda Ingin menghapus Data Supplier : " + tf_namasupp.getText() +
" ?", "Konfirmasi", JOptionPane.YES_NO_OPTION) == 0) {
try {
objCRUD = new kontrol();
objCRUD.getHapusSupp(tf_namasupp.getText());
BersihSupp();
TampilTabelSupp();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
7. Class po
a. Button “Tambah”
private void bt_tambah_poActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getTambahPo(Integer.parseInt(tf_no.getText()),
tf_po.getText(), cb_supplier.getSelectedItem().toString(), tf_tgl_po.getText(),
tf_del_date.getText());
TampilTabelPo();
BersihPo();
} catch (Exception ex) {
ex.printStackTrace();
}
}
b. Button “Perbaharui”
private void bt_perbaharui_poActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getTutup();
objCRUD.getPerbaharuiPo(Integer.parseInt(tf_no.getText()),
tf_po.getText(), cb_supplier.getSelectedItem().toString(), tf_del_date.getText(),
tf_tgl_po.getText());
BersihPo();
TampilTabelPo();
} catch (Exception ex) {
ex.printStackTrace();
}
}
c. Button “Hapus”
private void bt_hapus_poActionPerformed(java.awt.event.ActionEvent evt) {
if (JOptionPane.showConfirmDialog(this,
"Anda Ingin menghapus Data Purchase Order : " + tf_po.getText() +
" ?", "Konfirmasi", JOptionPane.YES_NO_OPTION) == 0) {
try {
objCRUD = new kontrol();
objCRUD.getHapusPo(tf_po.getText());
BersihPo();
TampilTabelPo();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
8. Class ps_asbestos
a. Button “hitung”
private void bt_hitung_asActionPerformed(java.awt.event.ActionEvent evt)
{
Date Tanggal1 = Date.valueOf(tf_faktur_as.getText());
Date Tanggal2 = Date.valueOf(tf_del_as.getText());
int a = Tanggal1.getDate();
int a1 = Tanggal2.getDate();
int aa = a - a1;
System.out.println(aa);
if (aa <= 1) {
tf_nilai_as.setText("100");
}
if (aa >= 2) {
tf_nilai_as.setText("90");
}
if (aa >= 4) {
tf_nilai_as.setText("80");
}
if (aa >= 6) {
tf_nilai_as.setText("70");
}
if (aa >= 8) {
tf_nilai_as.setText("60");
}
if (aa >= 10) {
tf_nilai_as.setText("50");
}
if (aa >= 12) {
tf_nilai_as.setText("40");
}
b. Button “Tambah”
private void bt_tambah_asbestosActionPerformed(java.awt.event.ActionEvent
evt) {
try {
objCRUD = new kontrol();
objCRUD.getTambahAs(Integer.parseInt(tf_no_asbestos.getText()),(String)cb_po_
as.getSelectedItem(), tf_ttb_as.getText(),
tf_faktur_as.getText().toString(),
Integer.parseInt(tf_nilai_as.getText()),
tf_periode_as.getText().toString() + "-0");
TampilTabelAs();
BersihAs();
} catch (Exception ex) {
ex.printStackTrace();
}
}
c. Button “Perbaharui”
private void bt_perbaharui_asbestosActionPerformed(java.awt.event.ActionEvent
evt) {
try {
objCRUD = new kontrol();
objCRUD.getPerbaharuiAs((String)cb_po_as.getSelectedItem(),tf_ttb_as.getText(
),tf_faktur_as.getText().toString(),
Integer.parseInt(tf_nilai_as.getText()),
tf_periode_as.getText().toString() + "-0",
Integer.parseInt(tf_no_asbestos.getText()));
TampilTabelAs();
BersihAs();
} catch (Exception ex) {
ex.printStackTrace();
}
}
9. Class ps_semen
a. Button “hitung”
private void bt_hitung_seActionPerformed(java.awt.event.ActionEvent evt) {
Date Tanggal1 = Date.valueOf(tf_faktur_semen.getText());
Date Tanggal2 = Date.valueOf(tf_del_semen.getText());
int a = Tanggal1.getDate();
int a1 = Tanggal2.getDate();
int aa = a - a1;
System.out.println(aa);
if (aa <= 1) {
tf_nilai_se.setText("100");
}
if (aa >= 2) {
tf_nilai_se.setText("90");
}
if (aa >= 4) {
tf_nilai_se.setText("80");
}
if (aa >= 6) {
tf_nilai_se.setText("70");
}
if (aa >= 8) {
tf_nilai_se.setText("60");
}
if (aa >= 10) {
tf_nilai_se.setText("50");
}
if (aa >= 12) {
tf_nilai_se.setText("40");
}
}
b. Button “Tambah”
private void bt_tambah_semenActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getTambahSe(Integer.parseInt(tf_no_semen.getText()),(String)cb_po_semen.g
etSelectedItem(), tf_ttb_semen.getText(),
tf_faktur_semen.getText().toString(),
Integer.parseInt(tf_nilai_se.getText()),
tf_periodesemen.getText().toString() + "-0");
TampilTabelSe();
BersihSe();
} catch (Exception ex) {
ex.printStackTrace();
}
}
c. Button “Perbaharui”
private void bt_perbaharui_semenActionPerformed(java.awt.event.ActionEvent evt) {
try {
objCRUD = new kontrol();
objCRUD.getPerbaharuiSe((String)cb_po_semen.getSelectedItem(),tf_ttb_semen.getTex
t(),tf_faktur_semen.getText().toString(),
Integer.parseInt(tf_nilai_se.getText()),
tf_periodesemen.getText().toString() + "-0",
Integer.parseInt(tf_no_semen.getText()));
TampilTabelSe();
BersihSe();
} catch (Exception ex) {
ex.printStackTrace();
}
}
10. Class ps_kertas
a. Button “hitung”
private void bt_hitung_kerActionPerformed(java.awt.event.ActionEvent evt) {
float aa = Float.valueOf(tf_ka.getText());
if (aa >= 35.1) {
tf_nilai_ka.setText("40");
}
if (aa <= 35) {
tf_nilai_ka.setText("60");
}
if (aa <= 26) {
tf_nilai_ka.setText("80");
}
if (aa <= 15) {
tf_nilai_ka.setText("100");
}
}
b. Button “Tambah”
private void bt_tambah_kertasActionPerformed(java.awt.event.ActionEvent evt) {
try {
float ka = Float.valueOf(tf_ka.getText());
float nilaika = Float.valueOf(tf_nilai_ka.getText());
float nilai= (ka+nilaika)/2;
objCRUD = new kontrol();
objCRUD.getTambahKer(Integer.parseInt(tf_no_ker.getText()),
cb_po_kertas.getSelectedItem().toString(), tf_ttb_kertas.getText().toString(),
Float.parseFloat(tf_ka.getText()),
Float.parseFloat(tf_nilai_ka.getText()),nilai ,
tf_periode_ker.getText().toString() + "-0");
BersihKer();
TampilTabelKer();
} catch (Exception ex) {
ex.printStackTrace();
}
}
c. Button “Perbaharui”
private void bt_perbaharui_kertasActionPerformed(java.awt.event.ActionEvent evt)
{
try {
float ka = Float.valueOf(tf_ka.getText());
float nilaika = Float.valueOf(tf_nilai_ka.getText());
float nilai= (ka+nilaika)/2;
objCRUD = new kontrol();
objCRUD = new kontrol();
objCRUD.getPerbaharuiKer((String)cb_po_kertas.getSelectedItem(),
tf_ttb_kertas.getText().toString(),
Float.parseFloat(tf_ka.getText()),
Float.parseFloat(tf_nilai_ka.getText()),nilai ,
tf_periode_ker.getText().toString() + "-0",
Integer.parseInt(tf_no_ker.getText()));
TampilTabelKer();
BersihKer();
} catch (Exception ex) {
ex.printStackTrace();
}
}
11. Class laporan_button “tampil”
private void bt_tampilActionPerformed(java.awt.event.ActionEvent evt) {
String bb = cb_bahanbaku.getSelectedItem().toString();
if (bb.equals("Asbestos/Chrysotile")) {
try {
try {
lap_asbes();
} catch (ClassNotFoundException ex) {
Logger.getLogger(laporan.class.getName()).log(Level.SEVERE,
null, ex);
}
} catch (JRException ex) {
Logger.getLogger(laporan.class.getName()).log(Level.SEVERE, null,
ex);
}
}
if (bb.equals("Semen")) {
try {
try {
lap_semen();
} catch (ClassNotFoundException ex) {
Logger.getLogger(laporan.class.getName()).log(Level.SEVERE,
null, ex);
}
} catch (JRException ex) {
Logger.getLogger(laporan.class.getName()).log(Level.SEVERE, null,
ex);
}
}
if (bb.equals("Kertas Semen")) {
try {
try {
lap_kertas();
} catch (ClassNotFoundException ex) {
Logger.getLogger(laporan.class.getName()).log(Level.SEVERE,
null, ex);
}
} catch (JRException ex) {
Logger.getLogger(laporan.class.getName()).log(Level.SEVERE, null,
ex);
}
}
}
Lampiran 7: Purchase Order
Lampiran 8: Struk Timbangan
Lampiran 9: Tanda Terima Barang
Lampiran 10: Laporan Hasil Pengecekan Kadar Air Kertas
Lampiran 11: Laporan Penilaian Supplier
Lampiran 12: Laporan Penilaian Supplier Lanjutan
Lampiran 13: Surat Keterangan Praktek Kerja
Lampiran 14: Rekapitulasi Kehadiran Kerja Praktek
29
Lampiran 15: Jurnal Kerja Praktek
30
Lampiran 16: Jurnal Kerja Praktek Lanjutan
31
Lampiran 17: Jurnal Bimbingan Tugas Akhir
32
Lampiran 18: Jurnal Bimbingan Tugas Akhir Lanjutan