APLIKASI PENGOLAHAN DATA PRODUKSI BERBASIS WEB DI PT. TELEHOUSE ENGINEERING

1 APLIKASI PENGOLAHAN DATA PRODUKSI BERBASIS WEB DI PT. TELEHOUSE ENGINEERING KERJA PRAKTEK Diajukan untuk Memenuhi Tugas Mata Kuliah Kerja Praktek Pr...
Author:  Sri Sudirman
163 downloads 553 Views 2MB Size
Report
DOWNLOAD PDF

Recommend Documents



Data.php <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> Selamat Datang!! <script type="text/javascript" src="script.js"> <style type="text/css">


Selamat Datang,









A-3


else{ echo "

MODUL BELUM ADA ATAU BELUM LENGKAP

"; } ?>

Petugas.php

src='images/admin_05.jpg' />";


else

$aksi = "petugas/aksi_petugas.php"; switch($_GET['act']){

echo ""; ?>

//Tampil Data Petugas case "tampilpetugas" : ?>

Data Petugas



cari(); ?>





menu_utama(); ?>
Selamat Datang di aplikasi pengolahan Data Produksi
Silahkan pilih menu di atas untuk mengelola data.


Isi.php

$link = koneksi_db(); $sql = "SELECT * FROM petugas"; $res = mysql_query($sql,$link); if(mysql_num_rows($res) > 0){ //tombol tambah echo "
onclick=\"window.location.href='?isi=petugas&ac t=tambahpetugas';\">

"; ?>





// Bagian Home if ($_GET['isi']=='home'){ ?>

$no = 1;

Selamat Datang di aplikasi pengolahan Data Produksi


while($data=mysql_fetch_array($res)){ echo "
Silahkan pilih menu di atas untuk mengelola

bgcolor=".warna_baris($no).">

data.




align="center">




// Bagian Petugas elseif ($_GET['isi']=='petugas'){ include "petugas/petugas.php"; }



// Bagian Customer elseif ($_GET['isi']=='customer'){ include "customer/customer.php"; } // Bagian proses elseif ($_GET['isi']=='proses'){ include "proses/proses.php"; }

"; $no++; }

// Apabila modul tidak ditemukan

A-4


?> value="Ulang">
NoNIPusernameNam aLevelAksi
$no $data[NIP] $data[username] $data[nama_petugas] $data[level] ubah"; if($data['level'] == 'user'){

// Bagian order elseif ($_GET['isi']=='order'){ include "order/order.php"; } // Bagian plan_order elseif ($_GET['isi']=='plan'){ include "plan_order/plan.php"; } // Bagian produksi elseif ($_GET['isi']=='produksi'){ include "produksi/produksi.php"; }

echo" |
onClick=\"return confirm('Apakah Anda Yakin akan menghapus $data[nama_petugas]?')\">hapus"; } echo "







else{



echo "Data Tidak Ditemukan";

}


?>
//Ubah Data Petugas case "ubahpetugas" :

//tambah Data Petugas case "tambahpetugas" : ?>

//ambil data


align="center">Tambah Data Petugas



//koneksi

"

$link = koneksi_db(); name="f_petugas" onsubmit="return $sql = "SELECT * FROM petugas WHERE

v_petugas();"> nip = '$nip'";

$res = mysql_query($sql,$link); if($res) $data =

echo "Data Error : ".mysql_error();



?>
align="center">Ubah Data Petugas





method="post" action="">
NIP:

mysql_fetch_array($res); else
Nama :


















A-5







(kosongkan jika tidak diubah)



"; $no++;
NIP :
Data Login
Username Nama : :

Data Login

Password : (default)
Username :


Password : $no

$data[id_customer] $data[nama_customer]
$data[website]
Ubah |




onClick=\"return confirm('Apakah Anda Yakin akan menghapus $data[nama_customer]?')\">Hapus
}
?>




}

}

?> else{

Customer.php

echo "Data Tidak Ditemukan";


}

//Tampil Data Customer case "tampilcustomer" : ?>



?>


Data Customer


//Tambah Data Customer case "tambahcustomer" : ?>

Tambah Data Customer



$sql = "SELECT * FROM customer ORDER BY nama_customer"; $res = mysql_query($sql,$link); if(mysql_num_rows($res) > 0){

" name="f_customer" onsubmit="return v_customer();">
?>

bgcolor="#FFCC33">






















$no = 1;

while($data=mysql_fetch_array($res)){

echo "







Proses.php


//Tampil Data Petugas case "tampilproses" :

No
Nama Customer :
ID Customer
Nama Customer Website Website : Aksi


A-6


?>

Data Proses










$link = koneksi_db(); //Ubah Data Customer

$sql = "SELECT * FROM proses ORDER BY

case "ubahcustomer" : ?>
id_proses";

align="center">Ubah Data Customer

$res = mysql_query($sql,$link);



if(mysql_num_rows($res) > 0){


?>

$id_customer = $_REQUEST['id_customer'];



$link = koneksi_db();



$sql = "SELECT * FROM customer WHERE id_customer = '$id_customer'";



$res = mysql_query($sql,$link);



if($res)



$data = mysql_fetch_array($res);



else


$no = 1;

".mysql_error(); ?> ">
No ID Proses Nama Proses Aksi


while($data=mysql_fetch_array($res)){ echo "









onClick=\"return confirm('Apakah Anda Yakin akan menghapus $data[nama_proses]?')\">HAPUS





"; $no++;



}



?>

$no
$data[id_proses] Nama Customer :
Website : $data[nama_proses] EDIT |






A-7



echo "Data Tidak Ditemukan";

Nama proses }

?>




//tambah Data Petugas case "tambahproses" : ?>



Tambah Data Proses

value="Ulang">
" name="f_proses" onsubmit="return v_proses();">
Nama proses :




Order.php

case "tampilorder" : ?>

Data Order



//Ubah Data Petugas case "ubahproses" : ?>



Ubah Data Proses


$link = koneksi_db();


$sql ="SELECT * FROM `order` ORDER BY tgl_order"; $res = mysql_query($sql,$link); if(mysql_num_rows($res) > 0){

$link = koneksi_db(); $sql = "SELECT * FROM proses WHERE id_proses = '$id_proses'"; $res = mysql_query($sql,$link); if($res) $data =

?>

mysql_fetch_array($res);



else echo "Data Error : ".mysql_error(); ?> ">


<script type="text/javascript"> function cek_hapus(){ if((document.hapus.cek.value==null) || (document.hapus.cek.value==""){ alert("Tidak Ada Data yang



Dipilih")

return false



}

A-8

" onsubmit="return cek_hapus()">

echo "Data Tidak Ditemukan".mysql_error(); }


?> $no = 1;
while($data=mysql_fetch_array($res)){ echo " //tambah Data order

case "tambahorder" : ?>

Tambah Data Order



onsubmit="return v_order();">
#NoWork OrderDeskripsiCustomerJml OrderTanggal Order StatusAksi
ID Proses :
}

$id_proses; ?>
" name="f_order" title='Ubah'>
Work Order : onClick=\"return confirm('Apakah Anda Yakin akan menghapus $data[work_order]?')\">












 $data[status] $link=koneksi_db();

?>



"; $no++;

echo



}

(contoh : TE-0610P999)
$no Deskripsi : $data[work_order]
$data[deskripsi] Customer : $data[nama_customer] <select name="customer">

align=center>$data[jml_order]		 ".tgl_indo($data['tgl_order'])." $pil_customer = mysql_query("SELECT nama_customer FROM customer",$link); $k[0]"; type=button value='Produksi' onClick=\"window.location.href='data.php?isi=produksi&act =tampilproduksi&wo=$data[work_order]'\">
Jumlah Order
left:50px">; unit i++){document.getElementById('id'+i).checked=true;}">Chec k All / $no;?>; i++){document.getElementById('id'+i).checked=false;}">Unc Tanggal Order heck All ?>

 

Jumlah Data : Record.




A-9








Jumlah Order

//Ubah Data order case "ubahorder" : ?>

Ubah Data Order



unit


Tanggal Order

$id_order = $_REQUEST['id_order'];


//koneksi $link = koneksi_db(); $sql = "SELECT * FROM `order` WHERE id_order = '$id_order'"; $res = mysql_query($sql,$link);

?> Status

if($res)

>Dalam Proses


$data = mysql_fetch_array($res); else echo "Data Error : ".mysql_error(); ?>
>Selesai

method="post" action="">





Work Order :


Deskripsi :




} ?>

Customer :

Plan.php

<select name="customer">



//Tampil Data Petugas case "tampilplan" :


?>


if($data['nama_customer']==$k['nama_customer']) {

$wo = $_REQUEST['wo'];

echo ""; }

if (empty($wo)){

?>

Cari Order



else echo ""; } ?>





A-10





";

?>

Work Order







(contoh : TE-0610P102)



}

else{

$link = koneksi_db();
$sql ="SELECT * FROM `order` WHERE work_order='$wo'";

$jplan = $jprod = $jreal =

$res = 0;

mysql_query($sql,$link);

$no=1;

if(mysql_num_rows($res) > 0){ $data = mysql_fetch_array($res);

while($data2=mysql_fetch_array($res_plan)){ ?> echo "



align="center">Data Plan Order

NoTanggalJumlahAksi
PlanProduksiRealisasi


"; if($data2['plan']==0) echo ""; else echo ""; if($data2['produksi']==0) echo "";

$no
Work Order:
".tgl_indo($data2['tanggal'])."
Deskripsi:
-
Customer:
$data2[plan]
Jumlah Order: Unit
-



else echo "$data2[produksi]";

$sql_plan = "SELECT * FROM plan_order WHERE work_order='$wo' ORDER BY tanggal"; if($data2['realisasi']==0) echo " - "; $res_plan = mysql_query($sql_plan,$link);

echo "
";

if(mysql_num_rows($res_plan) > 0){

echo "

else echo "$data2[realisasi]";

echo "


A-11

onClick=\"return confirm('Apakah Anda Yakin akan menghapus Data ini?')\">


(contoh : TE-0610P102)
"; } $jplan = $jplan }

+ $data2['plan'];

?> $jprod = $jprod


+ $data2['produksi'];

$no++;

}//endwhile

if (empty($wo)){ echo "Total$jplan$jprod$jr eal ";

?>

Cari Order





echo "";

Work Order //Paging Akhir $sql_plan2 = mysql_query("SELECT * FROM plan_order WHERE work_order = '$wo'",$link);



$jmldata =
mysql_num_rows($sql_plan2); } echo "

Jumlah Data : else{

$jmldata Record.

"; ?> }

Tambah Plan Order

" name="f_plan" onsubmit="return v_plan();">

else{

echo "

Belum ada Plan

untuk order ini.";



}



} else{ echo "

Data Order Tidak Ditemukan

".mysql_error();



?>

Cari Order















Work Order Plan

name="wo" size="15">





A-12







unit









unit







Work Order :
Tanggal

?>
Jumlah
unit Work Order :
Produksi


Tanggal
Realisasi


Jumlah
Plan

unit
Produksi




unit




Realisasi

//Ubah Data Petugas

case "ubahplan" : ?>

unit //ambil data $id = $_REQUEST['id']; //koneksi $link = koneksi_db();



$sql = "SELECT * FROM `plan_order` WHERE id_plan_order = '$id'";



$res = mysql_query($sql,$link);

if($res) $data =

mysql_fetch_array($res);



else


echo "Data Error }

: ".mysql_error(); ?> ?>

Ubah Plan Order



Produksi.php
">

//Tampil Data order



align="center">Data Produksi



case "tampilproduksi" :

?>

A-13

}

$wo = $_REQUEST['wo'];

echo

if (empty($wo)){ "
?>

Cari Order

"; Work

while($proses = mysql_fetch_row($sql_proses)){

Order
echo "";

type="hidden" name="halaman" />
}//endwhile

type="submit" value="Cari">

echo

"";
}

$no=1;

else{ $link = koneksi_db();

while($kolom = mysql_fetch_row($sql_prod)){ $sql ="SELECT * FROM `order` WHERE work_order='$wo'"; $res = mysql_query($sql,$link);

echo "";

if(mysql_num_rows($res) > 0){ $data = mysql_fetch_array($res);

echo ""; //konversi ke format tgl Indonesia

?> for($i=3; $i<=20; $i++){
TanggalShift $proses[1] Aksi
".tgl_indo($kolom[2])."
if($kolom[$i]=='0'){ echo "";

}

else{



echo "";

Work Order:
-
Deskripsi:
Customer:
Jumlah Order: Unit
$kolom[$i]
$total[$i] = $total[$i] + $kolom[$i];

}


$sql_proses = mysql_query("SELECT * FROM proses ORDER BY id_proses",$link);

}

echo "UBAH WHERE work_order = '$wo' ORDER BY tanggal",$link);

echo "


";

if(mysql_num_rows($sql_prod) > 0){


onClick=\"return confirm('Apakah Anda Yakin akan menghapus Data ini?')\">HAPUS

";

//inisialisasi Array Total

for($i=0; $i<=20; $i++){

$total[$i] = 0;

echo "";

A-14



$no++;

Work Order
}//endwhile name="wo" size="15">

//Tampil Total echo



"Total";

for($i=4; $i<=20; $i++){
echo"$total[$i]";

else{

} echo

?>
""; method="post" action="produksi_tambah_proses.php" name="f_produksi" onsubmit="return v_produksi();">



//Paging Akhir

$sql_prod2 = mysql_query("SELECT * FROM produksi WHERE work_order = '$wo'",$link);



else{

echo "

Belum ada Produksi untuk order ini.

";



echo mysql_error(); } }

else{ echo "

Data Tidak Ditemukan

".mysql_error();


?>

Cari Order

colspan="2" bgcolor="#AAD5FF">



<strong>PROSES Work Order

<span class="style6">Work Order : <span class="style6">

$jmldata = mysql_num_rows($sql_prod2);



}
<strong>Tanggal
<strong>Shift <strong>Pagi <strong>Malam




type="submit" value="Cari">








} ?>




break;



//TAMBAH DATA PRODUKSI case "tambahproduksi" : ?>

Tambah Data Produksi








$wo = $_REQUEST['wo']; if (empty($wo)){

?>

Cari Order





A-15



">







PPIC  Bending   Galvanis
Gambar Kerja  

Plasma Cutting   Final Assy

Nesting & Cam size="10" value="0"> 
Welding   Finish Goods

break;

//UBAH DATA PRODUKSI case "ubahproduksi" : ?>

Ubah Data Produksi




$id = $_REQUEST['id'];



$link = koneksi_db(); $sql = "SELECT * FROM produksi WHERE id_produksi = '$id'";

Part List  

$res = mysql_query($sql,$link);

Grinding $data = mysql_fetch_row($res);

 

?>


Delivery



width="625" cellpadding="5" cellspacing="0" bgcolor="#208FFF">





















A-16











<span class="style6">Work Order :
<span class="style6">

Check List   Painting  
  <strong>Tanggal  
<strong>Shift Punching   Coating   Simulasi
/> <strong>Pagi /> <strong>Malam
<strong>PROSES

PPIC  
    Bending     Galvanis
Gambar Kerja   Plasma Cutting  
Punching   Coating   Simulasi


Final Assy

 

Nesting & Cam &halaman="> size="10" value="">  value="Batal"> Welding maxlength="10"> 
Finish Goods
?> Part List   Grinding   Delivery Check List   Painting