validation.js

// JavaScript Document
function simpan(v){
if(form1.orderID.value == "") {
alert("Order Number Belum Diisi!")
form1.orderID.focus()
return false
}
else if(form1.order_date.value == "") {
alert("Orde Date Belum Diisi!")
form1.order_date.focus()
return false
}
else {
document.form1.action="addorde_pre.jsp";
document.form1.submit();
}
}

function addNewRow() {
var tbl = document.getElementById("lineItemTable");
var row = tbl.insertRow(tbl.rows.length);
var td0 = document.createElement("td");
var td1 = document.createElement("td");
var td2 = document.createElement("td");
var td3 = document.createElement("td");
var td4 = document.createElement("td");
td0.appendChild(generateCheckBox(row.rowIndex));
td1.appendChild(generateNomorInduk(row.rowIndex));
td2.appendChild(generateNomorRegister(row.rowIndex));
td3.appendChild(generateNamaSiswa(row.rowIndex));
td4.appendChild(generateItemName(row.rowIndex));
row.appendChild(td0);
row.appendChild(td1);
row.appendChild(td2);
row.appendChild(td3);
row.appendChild(td4);
}
function generateCheckBox(index) {
var check = document.createElement("input");
check.type = "checkbox";
check.name = "check[ ]";
check.id = "check["+index+"]";
return check;
}
function generateNomorInduk(index) {
var idx = document.createElement("input");
idx.type = "text";
idx.name = "nomorInduk[ ]";
idx.id = "nomorInduk["+index+"]";
idx.size = "15";
return idx;
}
function generateNomorRegister(index) {
var idx = document.createElement("input");
idx.type = "hidden";
idx.name = "nomorRegister[ ]";
idx.id = "nomorRegister["+index+"]";
return idx;
}
function generateNamaSiswa(index) {
var idx = document.createElement("input");
idx.type = "text";
idx.name = "namaSiswa[ ]";
idx.id = "namaSiswa["+index+"]";
idx.size = "25";
return idx;
}
function generateItemName(index) {
var itemName = document.createElement("input");
itemName.type = "text";
itemName.name = "alamatSiswa[ ]";
itemName.id = "alamatSiswa["+index+"]";
itemName.size = "40";
return itemName;
}
function clickAll() {
var checked = false;
if (document.getElementById("checkMaster").checked == true)
checked = true;
var tbl = document.getElementById("lineItemTable");
var rowLen = tbl.rows.length;
for (var idx=1;idx var row = tbl.rows[idx];
var cell = row.cells[1];
var node = cell.lastChild;
node.checked = checked;
}
}
function deleteAll() {
var tbl = document.getElementById("lineItemTable");
var rowLen = tbl.rows.length - 1;
for (var idx=rowLen;idx > 0;idx--) {
tbl.deleteRow(idx)
}
}
function bufferRow(table) {
var tbl = document.getElementById("lineItemTable");
var rowLen = tbl.rows.length;
for (var idx=1;idx var row = tbl.rows[idx];
var cell = row.cells[1];
var node = cell.lastChild;
if (node.checked == false) {
var rowNew = table.insertRow(table.rows.length);
var td0 = document.createElement("td");
var td1 = document.createElement("td");
var td2 = document.createElement("td");
var td3 = document.createElement("td");
var td4 = document.createElement("td");
td0.appendChild(row.cells[0].lastChild);
td1.appendChild(row.cells[1].lastChild);
td2.appendChild(row.cells[2].lastChild);
td3.appendChild(row.cells[3].firstChild);
td3.appendChild(row.cells[3].lastChild);
td4.appendChild(row.cells[4].lastChild);
rowNew.appendChild(td0);
rowNew.appendChild(td1);
rowNew.appendChild(td2);
rowNew.appendChild(td3);
rowNew.appendChild(td4);
}
}
}
function reIndex(table) {
var tbl = document.getElementById("lineItemTable");
var rowLen = table.rows.length;
for (var idx=0;idx < rowLen;idx++) {
var row = table.rows[idx];
var rowTbl = tbl.insertRow(tbl.rows.length);
var td0 = document.createElement("td");
var td1 = document.createElement("td");
var td2 = document.createElement("td");
var td3 = document.createElement("td");
var td4 = document.createElement("td");
td0.appendChild(row.cells[0].lastChild);
td1.appendChild(row.cells[1].lastChild);
td2.appendChild(row.cells[2].lastChild);
td3.appendChild(row.cells[3].firstChild);
td3.appendChild(row.cells[3].lastChild);
td4.appendChild(row.cells[4].lastChild);
rowTbl.appendChild(td0);
rowTbl.appendChild(td1);
rowTbl.appendChild(td2);
rowTbl.appendChild(td3);
rowTbl.appendChild(td4);
}
}
function deleteRow() {
var tbl = document.getElementById("lineItemTable");
var error = false;
if (document.getElementById("checkMaster").checked == false)
error = true;
var tbl = document.getElementById("lineItemTable");
var rowLen = tbl.rows.length;
for (var idx=1;idx var row = tbl.rows[idx];
var cell = row.cells[1];
var node = cell.lastChild;
if (node.checked == true) {
error = false;
break;
}
}
if (error == true) {
alert ("Checkbox tidak di cek, proses tidak dapat dilanjutkan");
return;
}
if (document.getElementById("checkMaster").checked == true) {
deleteAll();
document.getElementById("checkMaster").checked = false;
} else {
var table = document.createElement("table");
bufferRow(table);
deleteAll();
reIndex(table);
}
}

tabel

Table Brand --> kl ditampilan itu Merk

CREATE TABLE BRAND (
ID int IDENTITY(1,1) NOT NULL,
S_NAME varchar(15) NOT NULL,
S_NOTE varchar(30) NULL,
USER_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;
contoh Insert
INSERT INTO [pims].[dbo].[BRAND]
([S_NAME]
,[S_NOTE]
,[USER_ID]
,[DT_MOD]
,[I_ST_DOC])
VALUES
('Nusantara'
,Null
,null
,GETDATE()
,1)
GO


Table Destination
CREATE TABLE Destination(
ID int IDENTITY(1,1) NOT NULL,
S_NAME varchar(15) NOT NULL,
S_NOTE varchar(30) NULL,
USER_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;

contoh Insert
INSERT INTO [pims].[dbo].[BRAND]
([S_NAME]
,[S_NOTE]
,[USER_ID]
,[DT_MOD]
,[I_ST_DOC])
VALUES
('Afrika'
,Null
,null
,GETDATE()
,1)
GO

Table Etiket --> kl ditampilan ini yang Brand
CREATE TABLE ETIKET (
ID int IDENTITY(1,1) NOT NULL,
BRAND_ID int NOT NULL,
KODE_BRAND varchar(20) NOT NULL,
TAR binary null,
NIKOTIN binary null,
CO binary null,
S_NOTE varchar(30) NULL,
USER_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;

INSERT INTO [pims].[dbo].[ETIKET]
([BRAND_ID]
,[KODE_BRAND]
,[TAR]
,[NIKOTIN]
,[CO]
,[S_NOTE]
,[USER_ID]
,[DT_MOD]
,[I_ST_DOC])
VALUES
(1
,'12 KNM'
,'0'
,'0'
,'0'
,Null
,Null
,getDate()
,1)


Table Order
CREATE TABLE ORDERS(
ORDER_ID varchar(15) NOT NULL,
ORDER_DATE varchar(10) NOT NULL,
S_NOTE varchar(30) NULL,
USER_PIMS_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;

CREATE TABLE ORDER_DETAIL (
ORDER_DETAIL_ID varchar(10) NOT NULL,
ORDER_ID varchar(15) NOT NULL,
BRAND_ID int NOT NULL,
ETIKET_ID int NOT NULL,
DESTINATION_ID int NOT NULL,
KODE_PRODUKSI_ID int NOT NULL,
QUANTITY float NOT NULL,
DELIVER_DATE datetime NOT NULL,
USER_PIMS_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL,
S_NOTE varchar(30) NULL
)
;

gambar

Help

<%@ page import="java.util.*,java.sql.*" %>
<% String status = String.valueOf(session.getAttribute("login"));

//out.print(divisi+level);
if ((status.equalsIgnoreCase("!logged_in") == true)||(session.getAttribute("login") == null)){
session.setAttribute("pesan","ANDA TIDAK MEMILIKI HAK UNTUK MENGAKSES HALAMAN TADI!");
response.sendRedirect("../index.jsp");
}
else{
String username = String.valueOf(session.getAttribute("username"));
String user_group = String.valueOf(session.getAttribute("user_group"));
String userID = String.valueOf(session.getAttribute("userID"));%>



















<%@ include file="../library/connection.jsp" %>
<%
String type_order=(request.getParameter("type_order")==null?"":request.getParameter("type_order"));
String order_date = (request.getParameter("order_date")==null?"":request.getParameter("order_date"));
if(!order_date.equals("")) order_date = " and trunc(tgl_lhr) = to_date('"+order_date.trim()+"','dd/mm/yyyy') ";
String destination=(request.getParameter("destination")==null?"":request.getParameter("destination"));
String market_brand=(request.getParameter("market_brand")==null?"":request.getParameter("market_brand"));
String brand=(request.getParameter("brand")==null?"":request.getParameter("brand"));
String kode_produksi=(request.getParameter("kode_produksi")==null?"":request.getParameter("kode_produksi"));
String order_quantity=(request.getParameter("order_quantity")==null?"":request.getParameter("order_quantity"));
String deliver_date = (request.getParameter("deliver_date")==null?"":request.getParameter("deliver_date"));
if(!deliver_date.equals("")) deliver_date = " and trunc(tgl_lhr) = to_date('"+deliver_date.trim()+"','dd/mm/yyyy') ";
String note=(request.getParameter("note")==null?"":request.getParameter("note"));



%>

Pencatatan Order Type Order : -- Pilih Jenis Order -- >Lokal >Export No. Order : Generate By System

	Order Order Date : value="<%=order_date%>" onKeypress="if (event.keyCode <> 57) event.returnValue = false; " /> Destination : -- Pilih Destination-- <% rs = st.executeQuery("select * from destination where n_record_stat_id=1 order by id"); while(rs.next()){ %> " <% if(rs.getString(1).equals(request.getParameter("id"))) out.print("selected"); %>> <%= rs.getString(2) %> <% } rs.close(); %> Market Brand : -- Pilih Market-- <% rs = st.executeQuery("select * from market_brand where n_record_stat_id=1 order by id"); while(rs.next()){ %> " <% if(rs.getString(1).equals(request.getParameter("id"))) out.print("selected"); %>> <%= rs.getString(2) %> <% } rs.close(); %> Brand : -- Pilih Brand-- <% rs = st.executeQuery("select * from brand where id_market_brand="+request.getParameter("market_brand")+" and n_record_stat_id=1 order by id"); while(rs.next()){ %> " <% if(rs.getString(1).equals(request.getParameter("id"))) out.print("selected"); %>> <%= rs.getString(4) %> <% } rs.close(); %> Production Code : -- Pilih Production Code-- <% rs = st.executeQuery("select * from kode_produksi where n_record_stat_id=1 order by id"); while(rs.next()){ %> " <% if(rs.getString(1).equals(request.getParameter("id"))) out.print("selected"); %>> <%= rs.getString(2) %> <% } rs.close(); %> Order Quantity : " class="boxdefault" onKeypress="if (event.keyCode <> 57) event.returnValue = false; "> / Pack Delivery Estimation Date : value="<%=deliver_date%>" onKeyPress="if (event.keyCode <> 57) event.returnValue = false; " /> Note : ">

Keterangan : *Data harus diisi sesuai kondisi sebenarnya

<% }//end else if login true %>

cukup sudah

tak ada lagi yang tersisa dalam hidupku..semuanya telah hilang dengan berjalannya waktu..semua rasa cintaku yang tulus kepadamu hanya kamu anggap angin lalu..yang kubutuhkan dari kamu hanyalah kejelasan dari hubungan kita berdua..dimana janjimu yang dulu, dimana dirimu yang dulu..aq rindu pada sosok dirimu yang dulu, yang selalu ada buat aq..cukup sudah aq menunggu...