stab(ResultSet k) {
super("PATIENT FOUND");
String[] chd = {
"Date",
"Patient ID",
"Name",
"Gender",
"Age",
"Weight",
"Address",
"Contact No.",
"Doctor Name",
"Symptoms",
"Dignosis",
"Fee: Rs.",
"Blood Group"
};
// DefaultTableModel dtm=new DefaultTableModel();
// jt.setModel(new DefaultTableModel(arr,chd));
jt = new JTable();
jsp = new JScrollPane(jt);
btn = new JButton("CLOSE");
btn.addActionListener(this);
int i = 0;
try {
while (k.next()) {
arr[i][0] = k.getString(1);
// System.out.println("ddddddddddddd"+arr[i][0]);
arr[i][1] = "" + k.getInt(2);
arr[i][2] = k.getString(3) + " " + k.getString(4) + " " + k.getString(5);
arr[i][3] = k.getString(6);
arr[i][4] = "" + k.getInt(7);
arr[i][5] = k.getString(8);
arr[i][6] = k.getString(9);
arr[i][7] = k.getString(10);
arr[i][8] = k.getString(11);
arr[i][9] = k.getString(12);
arr[i][10] = k.getString(13);
arr[i][11] = "" + k.getInt(14);
arr[i][12] = k.getString(15);
arr[i][13] = k.getString(16);
// dtm.insertRow(i,new Object[]{patient.rs.getString(1),
// patient.rs.getInt(2),patient.rs.getString(3)+patient.rs.getString(4)+patient.rs.getString(5),patient.rs.getString(6),patient.rs.getInt(7),patient.rs.getString(8),patient.rs.getString(9),patient.rs.getString(10),patient.rs.getString(11),patient.rs.getString(12),patient.rs.getString(13),patient.rs.getInt(14)});
i++;
}
} catch (Exception e12) {
System.out.println("" + e12);
}
jt.setModel(new DefaultTableModel(arr, chd));
Container con = getContentPane();
con.setLayout(null);
jsp.setBounds(20, 20, 1230, 600);
btn.setBounds(685, 630, 100, 30);
add(jsp);
add(btn);
setSize(1330, 800);
setVisible(true);
}
public void connectItems(String query)
// PRE: query must be initialized
// POST: Updates the list of Items based on the query.
{
String driver = "org.apache.derby.jdbc.ClientDriver"; // Driver for DB
String url = "jdbc:derby://localhost:1527/ShopDataBase"; // Url for DB
String user = "******"; // Username for db
String pass = "******"; // Password for db
Connection myConnection; // Connection obj to db
Statement stmt; // Statement to execute a result appon
ResultSet results; // A set containing the returned results
int rowcount; // Num objects in the resultSet
int i; // Index for the array
try { // Try connection to db
Class.forName(driver).newInstance(); // Create our db driver
myConnection = DriverManager.getConnection(url, user, pass); // Initalize our connection
stmt =
myConnection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE); // Create a new statement
results = stmt.executeQuery(query); // Store the results of our query
rowcount = 0;
if (results.last()) // Go to the last result
{
rowcount = results.getRow();
results.beforeFirst();
}
itemsArray = new Item[rowcount];
i = 0;
while (results.next()) // Itterate through the results set
{
itemsArray[i] =
new Item(
results.getInt("item_id"),
results.getString("item_name"),
results.getString("item_type"),
results.getInt("price"),
results.getInt("owner_id"),
results.getString("item_path")); // Creat new Item
i++;
}
results.close(); // Close the ResultSet
stmt.close(); // Close the statement
myConnection.close(); // Close the connection to db
} catch (Exception e) // Cannot connect to db
{
System.err.println(e.toString());
System.err.println("Error, something went horribly wrong in connectItems!");
}
}
public void updateTables(String updateQuery1, String updateQuery2, String updateQuery3)
// PRE: updateQuery1,updateQuery2, updateQuery3 must be initialized
// POST: Updates the list of Items based on the querys.
{
String driver = "org.apache.derby.jdbc.ClientDriver"; // Driver for DB
String url = "jdbc:derby://localhost:1527/ShopDataBase"; // Url for DB
String user = "******"; // Username for db
String pass = "******"; // Password for db
Connection myConnection; // Connection obj to db
Statement stmt; // Statement to execute a result appon
ResultSet results; // A set containing the returned results
int i; // Index for the array
try // Try connection to db
{
Class.forName(driver).newInstance(); // Create our db driver
myConnection = DriverManager.getConnection(url, user, pass); // Initalize our connection
stmt =
myConnection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(updateQuery1);
stmt.executeUpdate(updateQuery2);
stmt.executeUpdate(updateQuery3);
results = stmt.executeQuery(previous_query); // Call the previous query
i = 0;
while (results.next()) // Itterate through the results set
{
itemsArray[i] =
new Item(
results.getInt("item_id"),
results.getString("item_name"),
results.getString("item_type"),
results.getInt("price"),
results.getInt("owner_id"),
results.getString("item_path"));
i++;
}
results.close(); // Close the ResultSet
stmt.close(); // Close the statement
myConnection.close(); // Close the connection to db
} catch (Exception e) // Cannot connect to db
{
System.err.println(e.toString());
System.err.println("Error, something went horribly wrong! in updateTables");
}
}
public void actionPerformed(ActionEvent ae) {
try {
Integer num = Integer.parseInt(tfdid.getText());
String name;
String addr;
String contact;
String spec;
String workf;
String workt;
Statement st = cn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM DOC WHERE did=" + num);
if (rs.next()) {
num = rs.getInt("did");
name = rs.getString("name");
addr = rs.getString("address");
contact = rs.getString("contact");
spec = rs.getString("specialization");
workf = rs.getString("workfrom");
workt = rs.getString("workto");
tfname.setText(name);
taadd.setText(addr);
tftel.setText(contact);
taspecial.setText(spec);
tfworkf.setText(workf);
tfworkt.setText(workt);
}
} catch (SQLException sq) {
System.out.println(sq);
}
}
public void setJenis() {
dataJenis = new ArrayList<Jenis>();
try {
String qry = "SELECT * from jenis";
ResultSet rs = stm.executeQuery(qry);
while (rs.next()) {
Jenis j = new Jenis();
j.setIdJenis(rs.getInt("id_jenis"));
j.setNamaJenis(rs.getString("nama_jenis"));
dataJenis.add(j);
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
public void actionPerformed(ActionEvent ae) {
String str = ae.getActionCommand();
if (str.equals("Ok")) {
String str1 = (String) jcmname.getSelectedItem();
Connection con = null;
Statement stat = null;
if (str1.equals("Pulsar")
|| str1.equals("CT 100")
|| str1.equals("Discover DTS-i")
|| str1.equals("Wave DTS-i")) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("Jdbc:Odbc:showroom");
System.out.println("Got Connection :" + con);
stat = con.createStatement();
ResultSet rs = stat.executeQuery("select * from vehicle");
System.out.println("chk1");
while (rs.next()) {
if (str1.equals(rs.getString(1))) {
tfcap.setText("" + rs.getInt(2));
tfeng.setText("" + rs.getInt(3));
tfbhp.setText("" + rs.getInt(4));
tfvolt.setText("" + rs.getInt(5));
tfrpm.setText("" + rs.getInt(6));
tfweight.setText("" + rs.getInt(7));
tfgear.setText("" + rs.getInt(8));
}
}
stat.close();
con.close();
} catch (Exception ex) {
}
} else {
JOptionPane.showMessageDialog(
null, "Please Choose Model Name", "Error", JOptionPane.ERROR_MESSAGE);
}
}
if (str.equals("can")) {
this.dispose();
// new menu(1);
}
}
private void generator() {
try {
ResultSet rst =
DBConnection.getDBConnection()
.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE)
.executeQuery("SELECT Payment_No FROM Payment");
text1.setText("1000");
while (rst.next()) {
String s;
int number = rst.getInt(1);
number = number + 1;
s = "" + number;
text1.setText(s);
int x;
}
} catch (Exception n) {
n.printStackTrace();
}
}
public static int getPersonId(int id) {
Connection con = getConnect();
ResultSet rs = null;
int personId = 0;
try {
String SQL = "SELECT PersonId FROM 2761DB.Persons WHERE SchoolId = " + id;
Statement stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
if (rs.next()) {
rs.first();
personId = rs.getInt("PersonId");
} else {
AddUserQuery addUserQuery = new AddUserQuery();
addUserQuery.setVisible(true);
}
} catch (Exception err) {
MessageBox.infoBox(err.toString(), "Error in getPersonId");
}
closeConnect();
return personId;
}
/**
* verifica si hay productos asociados
*
* @param table table
*/
private boolean verify() {
String sql =
"SELECT XX_VMR_ReferenceMatrix_ID "
+ "FROM XX_VMR_ReferenceMatrix "
+ "WHERE XX_VMR_PO_LINEREFPROV_ID="
+ (Integer) LineRefProv.getXX_VMR_PO_LineRefProv_ID();
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql, null);
rs = pstmt.executeQuery();
while (rs.next()) {
associatedReference_ID = rs.getInt("XX_VMR_ReferenceMatrix_ID");
rs.close();
pstmt.close();
return true;
}
} catch (SQLException e) {
log.log(Level.SEVERE, sql, e);
} finally {
try {
rs.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return false;
} // tableLoad
public void tableChanged(TableModelEvent tme) {
int baris = tme.getFirstRow();
int kolom = tme.getColumn();
TableModel model = (TableModel) tme.getSource();
int id = (Integer) model.getValueAt(baris, 0);
String query = "";
switch (kolom) {
case 1:
String nama = (String) model.getValueAt(baris, kolom);
query = "UPDATE produk SET nama_produk='" + nama + "' WHERE id_produk=" + id;
prosesEdit(query);
break;
case 2:
String jenis = (String) model.getValueAt(baris, kolom);
try {
query = "select * from jenis where nama_jenis='" + jenis + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idJenis = rs.getInt("id_jenis");
query = "UPDATE produk SET id_jenis=" + idJenis + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,jenis tidak ada");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
case 3:
int stok = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE `stok_produk` SET stok=" + stok + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 4:
int harga = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE produk SET harga=" + harga + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 5:
String suplier = (String) model.getValueAt(baris, kolom);
try {
query = "SELECT * FROM suplier WHERE nama_suplier='" + suplier + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idSuplier = rs.getInt("id_suplier");
query = "UPDATE produk SET id_suplier=" + idSuplier + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,suplier belum terdaftar");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
default:
break;
}
}
// ambil data dari database untuk tabel
public void setDataTabel() {
// combobox jenis
JComboBox cbJenis = new JComboBox();
cbJenis.setModel(new DefaultComboBoxModel(dataJenis.toArray()));
dataProduk = new ArrayList<Produk>();
try {
String qry =
"SELECT * FROM produk,suplier,jenis,stok_produk WHERE produk.id_jenis = jenis.id_jenis AND produk.id_suplier = suplier.id_suplier AND produk.id_produk=stok_produk.id_produk";
ResultSet rs = stm.executeQuery(qry);
while (rs.next()) {
Produk p = new Produk();
p.setIdProduk(rs.getInt("id_produk"));
p.setNamaProduk(rs.getString("nama_produk"));
p.setJenis(rs.getString("nama_jenis"));
p.setHarga(rs.getInt("harga"));
p.setStok(rs.getInt("stok"));
p.setNamaSuplier(rs.getString("nama_suplier"));
p.setComboJenis(cbJenis);
dataProduk.add(p);
}
} catch (Exception err) {
err.printStackTrace();
}
model = new TableModelProduk(dataProduk);
tabel.setModel(model);
tabel.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
class EditProdukListener implements TableModelListener {
public void tableChanged(TableModelEvent tme) {
int baris = tme.getFirstRow();
int kolom = tme.getColumn();
TableModel model = (TableModel) tme.getSource();
int id = (Integer) model.getValueAt(baris, 0);
String query = "";
switch (kolom) {
case 1:
String nama = (String) model.getValueAt(baris, kolom);
query = "UPDATE produk SET nama_produk='" + nama + "' WHERE id_produk=" + id;
prosesEdit(query);
break;
case 2:
String jenis = (String) model.getValueAt(baris, kolom);
try {
query = "select * from jenis where nama_jenis='" + jenis + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idJenis = rs.getInt("id_jenis");
query = "UPDATE produk SET id_jenis=" + idJenis + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,jenis tidak ada");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
case 3:
int stok = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE `stok_produk` SET stok=" + stok + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 4:
int harga = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE produk SET harga=" + harga + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 5:
String suplier = (String) model.getValueAt(baris, kolom);
try {
query = "SELECT * FROM suplier WHERE nama_suplier='" + suplier + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idSuplier = rs.getInt("id_suplier");
query = "UPDATE produk SET id_suplier=" + idSuplier + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,suplier belum terdaftar");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
default:
break;
}
}
private void prosesEdit(String query) {
try {
int hasil = stm.executeUpdate(query);
if (hasil == 1) {
setDataTabel();
JOptionPane.showMessageDialog(null, "edit berhasil");
} else {
JOptionPane.showMessageDialog(null, "gagal");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
}
}
model.addTableModelListener(new EditProdukListener());
}
/** Method declaration */
private void refreshTree() {
tTree.removeAll();
try {
int color_table = Color.yellow.getRGB();
int color_column = Color.orange.getRGB();
int color_index = Color.red.getRGB();
tTree.addRow("", dMeta.getURL(), "-", 0);
String usertables[] = {"TABLE"};
ResultSet result = dMeta.getTables(null, null, null, usertables);
Vector tables = new Vector();
// sqlbob@users Added remarks.
Vector remarks = new Vector();
while (result.next()) {
tables.addElement(result.getString(3));
remarks.addElement(result.getString(5));
}
result.close();
for (int i = 0; i < tables.size(); i++) {
String name = (String) tables.elementAt(i);
String key = "tab-" + name + "-";
tTree.addRow(key, name, "+", color_table);
// sqlbob@users Added remarks.
String remark = (String) remarks.elementAt(i);
if ((remark != null) && !remark.trim().equals("")) {
tTree.addRow(key + "r", " " + remark);
}
ResultSet col = dMeta.getColumns(null, null, name, null);
while (col.next()) {
String c = col.getString(4);
String k1 = key + "col-" + c + "-";
tTree.addRow(k1, c, "+", color_column);
String type = col.getString(6);
tTree.addRow(k1 + "t", "Type: " + type);
boolean nullable = col.getInt(11) != DatabaseMetaData.columnNoNulls;
tTree.addRow(k1 + "n", "Nullable: " + nullable);
}
col.close();
tTree.addRow(key + "ind", "Indices", "+", 0);
ResultSet ind = dMeta.getIndexInfo(null, null, name, false, false);
String oldiname = null;
while (ind.next()) {
boolean nonunique = ind.getBoolean(4);
String iname = ind.getString(6);
String k2 = key + "ind-" + iname + "-";
if ((oldiname == null || !oldiname.equals(iname))) {
tTree.addRow(k2, iname, "+", color_index);
tTree.addRow(k2 + "u", "Unique: " + !nonunique);
oldiname = iname;
}
String c = ind.getString(9);
tTree.addRow(k2 + "c-" + c + "-", c);
}
ind.close();
}
tTree.addRow("p", "Properties", "+", 0);
tTree.addRow("pu", "User: "******"pr", "ReadOnly: " + cConn.isReadOnly());
tTree.addRow("pa", "AutoCommit: " + cConn.getAutoCommit());
tTree.addRow("pd", "Driver: " + dMeta.getDriverName());
tTree.addRow("pp", "Product: " + dMeta.getDatabaseProductName());
tTree.addRow("pv", "Version: " + dMeta.getDatabaseProductVersion());
} catch (SQLException e) {
tTree.addRow("", "Error getting metadata:", "-", 0);
tTree.addRow("-", e.getMessage());
tTree.addRow("-", e.getSQLState());
}
tTree.update();
}
public void setContent(String cat) {
cat = cat.trim();
selectAllCB.setVisible(false);
selectAllCB.setSelected(false);
deleteBut.setVisible(false);
restoreBut.setVisible(false);
refreshBut.setVisible(true);
Object columns[] = null;
int count = 0;
switch (cat) {
case "Inbox":
columns = new Object[] {"", "From", "Date", "Subject", "Content"};
count = Database.getCount("Inbox");
workingSet = db.getData("SELECT * FROM messages WHERE tag='inbox' ORDER BY msg_id desc");
;
break;
case "SentMail":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Sentmail");
workingSet = db.getData("SELECT * FROM messages WHERE tag='sentmail' ORDER BY msg_id desc");
break;
case "Draft":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Draft");
workingSet = db.getData("SELECT * FROM messages WHERE tag='draft' ORDER BY msg_id desc");
break;
case "Outbox":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Outbox");
workingSet = db.getData("SELECT * FROM messages WHERE tag='outbox' ORDER BY msg_id desc");
break;
case "Trash":
// restoreBut.setVisible(true);
columns = new Object[] {"", "To/From", "Date", "Subject", "Content"};
count = Database.getCount("Trash");
workingSet =
db.getData(
"SELECT * FROM messages,trash WHERE messages.tag='trash' and messages.msg_id=trash.msg_id ORDER BY deleted_at desc");
break;
default:
System.out.println("in default case");
}
if (count > 0) {
selectAllCB.setVisible(true);
rows = new Object[count][];
msgID = new int[count];
try {
workingSet.beforeFirst();
for (int i = 0; i < count && workingSet.next(); i++) {
msgID[i] = workingSet.getInt(1);
rows[i] =
new Object[] {
false,
workingSet.getString(2),
workingSet.getDate(3),
workingSet.getString(4),
workingSet.getString(5)
};
}
} catch (SQLException sqlExc) {
JOptionPane.showMessageDialog(null, sqlExc, "EXCEPTION", JOptionPane.ERROR_MESSAGE);
sqlExc.printStackTrace();
}
tableModel = new MyDefaultTableModel(rows, columns);
table = new JTable(tableModel);
table.getSelectionModel().addListSelectionListener(this);
table.addMouseListener(this);
table.getTableHeader().setOpaque(true);
table.getTableHeader().setReorderingAllowed(false);
// table.getTableHeader().setBackground(Color.blue);
table.getTableHeader().setForeground(Color.blue);
// table.setRowSelectionAllowed(false);
// table.setColumnSelectionAllowed(false);
table.setFont(new Font(Font.SANS_SERIF, Font.PLAIN, 14));
table.setRowHeight(20);
table.setFillsViewportHeight(true);
TableColumn column = null;
for (int i = 0; i < 5; i++) {
column = table.getColumnModel().getColumn(i);
if (i == 0) {
column.setPreferredWidth(6);
} else if (i == 3) {
column.setPreferredWidth(250);
} else if (i == 4) {
column.setPreferredWidth(450);
} else {
column.setPreferredWidth(40);
}
}
table.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
remove(contentPan);
contentPan = new JScrollPane(table);
contentPan.setBackground(Color.orange);
contentPan.setOpaque(true);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
Home.home.homeFrame.setVisible(true);
} else {
JPanel centPan = new JPanel(new GridBagLayout());
centPan.setBackground(new Color(52, 86, 70));
JLabel label = new JLabel("No Messages In This Category");
label.setFont(new Font(Font.SANS_SERIF, Font.BOLD, 22));
label.setForeground(Color.orange);
centPan.add(label);
remove(contentPan);
contentPan = new JScrollPane(centPan);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
contentPan.repaint();
}
}
/** Process Button Pressed - Process Matching */
private void cmd_newProduct() {
// Selecciono el departamento
int depart = 0;
String SQL =
"Select XX_VMR_DEPARTMENT_ID "
+ "from XX_VMR_VENDORPRODREF "
+ "where XX_VMR_VENDORPRODREF_ID="
+ LineRefProv.getXX_VMR_VendorProdRef_ID();
try {
PreparedStatement pstmt = DB.prepareStatement(SQL, null);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
depart = rs.getInt("XX_VMR_DEPARTMENT_ID");
}
rs.close();
pstmt.close();
} catch (Exception a) {
log.log(Level.SEVERE, SQL, a);
}
MVMRVendorProdRef vendorProdRef =
new MVMRVendorProdRef(Env.getCtx(), LineRefProv.getXX_VMR_VendorProdRef_ID(), null);
if (vendorProdRef.getXX_VMR_ProductClass_ID() > 0
&& vendorProdRef.getXX_VMR_TypeLabel_ID() > 0) {
MOrder order = new MOrder(Env.getCtx(), LineRefProv.getC_Order_ID(), null);
// Selecciono el departamento
X_XX_VMR_Department dept =
new X_XX_VMR_Department(Env.getCtx(), vendorProdRef.getXX_VMR_Department_ID(), null);
int category = dept.getXX_VMR_Category_ID();
// Selecciono la línea
X_XX_VMR_Line line = new X_XX_VMR_Line(Env.getCtx(), vendorProdRef.getXX_VMR_Line_ID(), null);
int typeInventory = line.getXX_VMR_TypeInventory_ID();
MProduct newProduct =
new MProduct(
Env.getCtx(),
vendorProdRef.getXX_VMR_Department_ID(),
vendorProdRef.getXX_VMR_Line_ID(),
vendorProdRef.getXX_VMR_Section_ID(),
vendorProdRef.get_ID(),
vendorProdRef.getC_TaxCategory_ID(),
vendorProdRef.getXX_VME_ConceptValue_ID(),
typeInventory,
null);
// Se buscará si por la referencia para producto ya existe para asignarle el Tipo de
// Exhibición
String sql =
"select * from M_Product where XX_VMR_DEPARTMENT_ID = "
+ vendorProdRef.getXX_VMR_Department_ID()
+ " and "
+ "XX_VMR_LINE_ID = "
+ vendorProdRef.getXX_VMR_Line_ID()
+ " and XX_VMR_SECTION_ID = "
+ vendorProdRef.getXX_VMR_Section_ID()
+ " and "
+ "XX_VMR_VendorProdRef_id = "
+ vendorProdRef.getXX_VMR_VendorProdRef_ID()
+ " order by M_Product_ID desc";
PreparedStatement pstmt = DB.prepareStatement(sql, null);
ResultSet rs = null;
try {
rs = pstmt.executeQuery();
if (rs.next())
newProduct.setXX_VMR_TypeExhibition_ID(rs.getInt("XX_VMR_TypeExhibition_ID"));
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.closeResultSet(rs);
DB.closeStatement(pstmt);
}
if (vendorProdRef.getXX_VMR_Section_ID() > 0) {
X_XX_VMR_Section section =
new X_XX_VMR_Section(Env.getCtx(), vendorProdRef.getXX_VMR_Section_ID(), null);
newProduct.setName(section.getName());
} else {
newProduct.setName(vendorProdRef.getName());
}
newProduct.setXX_VMR_Category_ID(category);
newProduct.setXX_VMR_LongCharacteristic_ID(vendorProdRef.getXX_VMR_LongCharacteristic_ID());
newProduct.setXX_VMR_Brand_ID(vendorProdRef.getXX_VMR_Brand_ID());
newProduct.setXX_VMR_UnitConversion_ID(vendorProdRef.getXX_VMR_UnitConversion_ID());
newProduct.setXX_PiecesBySale_ID(vendorProdRef.getXX_PiecesBySale_ID());
newProduct.setXX_VMR_UnitPurchase_ID(vendorProdRef.getXX_VMR_UnitPurchase_ID());
newProduct.setXX_SaleUnit_ID(vendorProdRef.getXX_SaleUnit_ID());
newProduct.setC_Country_ID(order.getC_Country_ID());
newProduct.setIsActive(true);
newProduct.setC_BPartner_ID(vendorProdRef.getC_BPartner_ID());
newProduct.setXX_VMR_TypeLabel_ID(vendorProdRef.getXX_VMR_TypeLabel_ID());
newProduct.setXX_VMR_ProductClass_ID(vendorProdRef.getXX_VMR_ProductClass_ID());
newProduct.setM_AttributeSet_ID(Env.getCtx().getContextAsInt("#XX_L_P_ATTRIBUTESETST_ID"));
newProduct.setProductType(X_Ref_M_Product_ProductType.ITEM.getValue());
newProduct.save();
} else {
// Creo variables de sesion para atraparlas en la ventana producto
Env.getCtx().setContext("#Depart_Aux", depart);
Env.getCtx().setContext("#Section_Aux", LineRefProv.getXX_VMR_Section_ID());
Env.getCtx().setContext("#Line_Aux", LineRefProv.getXX_VMR_Line_ID());
Env.getCtx().setContext("#VendorRef_Aux", LineRefProv.getXX_VMR_VendorProdRef_ID());
Env.getCtx().setContext("#FromProcess_Aux", "Y");
AWindow window_product = new AWindow();
Query query = Query.getNoRecordQuery("M_Product", true);
window_product.initWindow(140, query);
AEnv.showCenterScreen(window_product);
// Obtenemos el GridController para setear la variable m_changed=true
JRootPane jRootPane = ((JRootPane) window_product.getComponent(0));
JLayeredPane jLayeredPane = (JLayeredPane) jRootPane.getComponent(1);
JPanel jPanel = (JPanel) jLayeredPane.getComponent(0);
APanel aPanel = (APanel) jPanel.getComponent(0);
VTabbedPane vTabbedPane = (VTabbedPane) aPanel.getComponent(0);
GridController gridController = (GridController) vTabbedPane.getComponent(0);
GridTable mTable = gridController.getMTab().getTableModel();
mTable.setChanged(true);
MProduct.loadLineRefProv(LineRefProv, Env.getCtx());
// Borro las variables de sesion creadas
Env.getCtx().remove("#Depart_Aux");
Env.getCtx().remove("#FromProcess_Aux");
Env.getCtx().remove("#Line_Aux");
Env.getCtx().remove("#Section_Aux");
Env.getCtx().remove("#VendorRef_Aux");
}
} // cmd_newProduct
public Summary(int patient_id) {
this.patient_id = patient_id;
setTitle("Summary");
setSize(
(int) (Toolkit.getDefaultToolkit().getScreenSize().getWidth()),
(int) (Toolkit.getDefaultToolkit().getScreenSize().getHeight()) - 40);
setResizable(false);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
head = new JLabel("MEDI_SCAN DIAGNOSTIC LAB SERVICES", SwingConstants.CENTER);
head.setForeground(Color.WHITE);
Font f2 = new Font("Papyrus", Font.BOLD, 36);
head.setFont(f2);
res = new JLabel("RESULT SUMMARY", SwingConstants.CENTER);
res.setForeground(Color.WHITE);
Font f3 = new Font("Papyrus", Font.BOLD, 28);
res.setFont(f3);
Font f1 = new Font("Goudy Old Style", Font.BOLD, 16);
hello = new JLabel("Hello Mr./Miss ");
hello.setForeground(new Color(54, 34, 174));
hello.setFont(f1);
fin = new JLabel("Your Medical Test Is Finished");
fin.setFont(f1);
fin.setForeground(new Color(54, 34, 174));
pname = new JLabel("Patient Name");
pname.setForeground(new Color(54, 34, 174));
pname.setFont(f1);
ldate = new JLabel("Test Date");
ldate.setForeground(new Color(54, 34, 174));
ldate.setFont(f1);
age = new JLabel("Age");
age.setForeground(new Color(54, 34, 174));
age.setFont(f1);
sex = new JLabel("Sex");
sex.setForeground(new Color(54, 34, 174));
sex.setFont(f1);
tname = new JLabel("Test Name");
tname.setForeground(new Color(54, 34, 174));
tname.setFont(f1);
nvalue = new JLabel("Normal Value");
nvalue.setForeground(new Color(54, 34, 174));
nvalue.setFont(f1);
trate = new JLabel("Test Rate");
trate.setForeground(new Color(54, 34, 174));
trate.setFont(f1);
tresult = new JLabel("Test Result");
tresult.setForeground(new Color(54, 34, 174));
tresult.setFont(f1);
tamt = new JLabel("Total Amout");
tamt.setForeground(new Color(54, 34, 174));
tamt.setFont(f1);
exit = new JButton("EXIT");
exit.setFont(f1);
pHead = new JPanel(new GridLayout(2, 1));
pHead.setBackground(new Color(134, 134, 234));
pCenter = new JPanel(new GridBagLayout());
pCenter.setBackground(new Color(211, 248, 253));
pCom = new JPanel(new BorderLayout());
pCom.setBackground(new Color(211, 248, 253));
pSouth = new JPanel(new FlowLayout(FlowLayout.RIGHT));
pSouth.setBackground(new Color(211, 248, 253));
// Adding Icon on top-left.
ImageIcon img = new ImageIcon("pics/logo.jpg");
this.setIconImage(img.getImage());
try {
Connection con = JDBCConnection.getConnection();
PreparedStatement pstmt =
con.prepareStatement(
"Select first_name,last_name,age,sex,test_id,tdate from patientreg where patient_id=?");
pstmt.setInt(1, this.patient_id);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
first_name = rs.getString("first_name");
lname = rs.getString("last_name");
name = new JLabel(first_name + " " + lname);
name1 = new JLabel(first_name + " " + lname);
p_age = rs.getInt("age");
pAge = new JLabel(p_age + "");
p_sex = rs.getString("sex");
psex = new JLabel(p_sex);
t_id = rs.getInt("test_id");
t_date = rs.getString("tdate");
date1 = new JLabel(t_date);
}
} catch (SQLException s) {
s.printStackTrace();
}
try {
Connection con = JDBCConnection.getConnection();
PreparedStatement pstmt =
con.prepareStatement("Select test_result from reportbydoctor where patient_id=?");
pstmt.setInt(1, this.patient_id);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
te_res = rs.getString("test_result");
result = new JLabel(te_res);
}
} catch (SQLException s) {
s.printStackTrace();
}
try {
Connection con = JDBCConnection.getConnection();
PreparedStatement pstmt =
con.prepareStatement("select normal_val,rate,test_name from addtest where test_id=?");
pstmt.setInt(1, t_id);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
n_value = rs.getInt("normal_val");
normal_value1 = new JLabel(n_value + "");
te_rate = rs.getInt("rate");
rate1 = new JLabel(te_rate + "");
rate2 = new JLabel(te_rate + "");
te_name = rs.getString("test_name");
testname = new JLabel(te_name);
}
} catch (SQLException a) {
a.printStackTrace();
}
content = getContentPane();
// for label hello
GridBagConstraints gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 1;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 50, 20, 0);
pCenter.add(hello, gc);
// for label name1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 1;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 0);
pCenter.add(name1, gc);
// for label fin
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 2;
gc.gridy = 1;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(fin, gc);
// for label pname
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 2;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(pname, gc);
// for label name
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 2;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(name, gc);
// for label ldate
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 3;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(ldate, gc);
// for label date1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 3;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(date1, gc);
// for label age
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 4;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(age, gc);
// for label pAge
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 4;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(pAge, gc);
// for label sex
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 5;
gc.ipadx = 125;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(sex, gc);
// for label psex
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 5;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(psex, gc);
// for label tname
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(tname, gc);
// for label nvalue
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(nvalue, gc);
// for label trate
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(trate, gc);
// for label tresult
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 4;
gc.gridwidth = 1;
gc.gridy = 6;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(tresult, gc);
// for label testname
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 1;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(testname, gc);
// for label normal_value1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 2;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(normal_value1, gc);
// for label rate1
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(rate1, gc);
// for label result
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 4;
gc.gridwidth = 1;
gc.gridy = 7;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(result, gc);
// for label tamt
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 3;
gc.gridwidth = 1;
gc.gridy = 8;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(tamt, gc);
// for label rate2
gc = new GridBagConstraints();
gc.fill = GridBagConstraints.NONE;
gc.gridx = 4;
gc.gridwidth = 1;
gc.gridy = 8;
gc.ipadx = 0;
gc.ipady = 10;
gc.weightx = 0;
gc.weighty = 0;
gc.anchor = GridBagConstraints.WEST;
gc.insets = new Insets(0, 0, 20, 20);
pCenter.add(rate2, gc);
exit.addActionListener(this);
pSouth.add(exit);
content.add(pSouth, BorderLayout.SOUTH);
pHead.add(head);
pHead.add(res);
content.add(pHead, BorderLayout.NORTH);
content.add(pCenter, BorderLayout.CENTER);
setVisible(true);
}
/** Dispose */
public void dispose() {
if (m_frame != null) m_frame.dispose();
m_frame = null;
MOrder order = new MOrder(Env.getCtx(), LineRefProv.getC_Order_ID(), null);
String oS = order.getXX_OrderStatus();
String compS = order.getDocStatus();
if (!oS.equals("AN") && !compS.equals("CO")) {
if (isInMatrix()) {
fullAssociated();
} else {
String SQL10 =
"UPDATE XX_VMR_PO_LineRefProv "
+ " SET XX_ReferenceIsAssociated='N'"
+ " WHERE XX_VMR_PO_LineRefProv_ID="
+ LineRefProv.getXX_VMR_PO_LineRefProv_ID();
DB.executeUpdate(null, SQL10);
// LineRefProv.setXX_ReferenceIsAssociated(false);
// LineRefProv.save();
}
}
// pelle
String SQL =
("SELECT A.XX_REFERENCEISASSOCIATED AS ASOCIATE "
+ "FROM XX_VMR_PO_LINEREFPROV A , C_ORDER B "
+ "WHERE A.C_ORDER_ID = B.C_ORDER_ID "
+ "AND A.C_ORDER_ID = '"
+ LineRefProv.getC_Order_ID()
+ "' ");
try {
PreparedStatement pstmt = DB.prepareStatement(SQL, null);
ResultSet rs = pstmt.executeQuery();
BigDecimal cifTotal = new BigDecimal(0);
Boolean check = true;
Integer maritimo = 0;
Integer aereo = 0;
Integer terrestre = 0;
BigDecimal montoBs = new BigDecimal(0);
BigDecimal rate = new BigDecimal(0);
BigDecimal Seguro = new BigDecimal(0);
BigDecimal perfleteInt = new BigDecimal(0);
BigDecimal fleteInternac = new BigDecimal(0);
Integer productid = 0;
Integer poline = 0;
BigDecimal costoitem = new BigDecimal(0);
BigDecimal porcentitem = new BigDecimal(0);
BigDecimal cifuni = new BigDecimal(0);
BigDecimal percentarancel = new BigDecimal(0);
BigDecimal arancelitem = new BigDecimal(0);
BigDecimal rateseniat = new BigDecimal(0);
BigDecimal montoseniat = new BigDecimal(0);
BigDecimal ratetesoreria = new BigDecimal(0);
BigDecimal montotesoreria = new BigDecimal(0);
BigDecimal tasaaduana = new BigDecimal(0);
BigDecimal part1 = new BigDecimal(0);
BigDecimal part2 = new BigDecimal(0);
BigDecimal iva = new BigDecimal(0);
BigDecimal ivaactual = new BigDecimal(0);
BigDecimal part = new BigDecimal(0);
BigDecimal montesorerianac = new BigDecimal(0);
while (rs.next()) {
if (rs.getString("ASOCIATE").trim().equalsIgnoreCase("N")) {
check = false;
}
}
rs.close();
pstmt.close();
if (check == true) {
String SQL2 =
("SELECT (A.TOTALLINES * B.MULTIPLYRATE) + A.XX_INTNACESTMEDAMOUNT + A.XX_ESTEEMEDINSURANCEAMOUNT AS CIFTOTAL "
+ "FROM C_ORDER A, C_CONVERSION_RATE B "
+ "WHERE B.C_CONVERSION_RATE_ID = A.XX_CONVERSIONRATE_ID "
+ "AND A.C_ORDER_ID = '"
+ LineRefProv.getC_Order_ID()
+ "' "
+ "AND A.AD_Client_ID IN(0,"
+ Env.getCtx().getAD_Client_ID()
+ ") "
+ "AND B.AD_Client_ID IN(0,"
+ Env.getCtx().getAD_Client_ID()
+ ")");
PreparedStatement pstmt2 = DB.prepareStatement(SQL2, null);
ResultSet rs2 = pstmt2.executeQuery();
if (rs2.next()) {
// Calculo del CIF Total
cifTotal = rs2.getBigDecimal("CIFTOTAL");
}
rs2.close();
pstmt2.close();
// Busco la via de despacho de la O/C
String SQL3 =
("SELECT XX_L_DISPATCHROUTE AS AEREO, XX_L_DISPATCHROUTEMAR AS MARITIMO, XX_L_DISPATCHROUTETER AS TERRESTRE "
+ "FROM XX_VSI_KEYNAMEINFO ");
PreparedStatement pstmt3 = DB.prepareStatement(SQL3, null);
ResultSet rs3 = pstmt3.executeQuery();
if (rs3.next()) {
maritimo = rs3.getInt("MARITIMO");
terrestre = rs3.getInt("TERRESTRE");
aereo = rs3.getInt("AEREO");
}
rs3.close();
pstmt3.close();
String SQL4 =
("SELECT (A.TOTALLINES * B.MULTIPLYRATE) AS MONTO "
+ "FROM C_ORDER A, C_CONVERSION_RATE B "
+ "WHERE B.C_CONVERSION_RATE_ID = A.XX_CONVERSIONRATE_ID "
+ "AND A.C_ORDER_ID = '"
+ LineRefProv.getC_Order_ID()
+ "' ");
PreparedStatement pstmt4 = DB.prepareStatement(SQL4, null);
ResultSet rs4 = pstmt4.executeQuery();
if (rs4.next()) {
// Monto de la O/C en Bs
montoBs = rs4.getBigDecimal("MONTO");
}
rs4.close();
pstmt4.close();
if (order.getXX_VLO_DispatchRoute_ID() == maritimo) {
String SQL5 =
("SELECT XX_RATE AS RATE "
+ "FROM XX_VLO_DispatchRoute "
+ "WHERE XX_VLO_DispatchRoute_ID = '"
+ maritimo
+ "' ");
PreparedStatement pstmt5 = DB.prepareStatement(SQL5, null);
ResultSet rs5 = pstmt5.executeQuery();
if (rs5.next()) {
rate = rs5.getBigDecimal("RATE").divide(new BigDecimal(100));
// (new BigDecimal(100), 2, RoundingMode.HALF_UP);
// Calculo del Seguro con Via Maritimo
Seguro = montoBs.multiply(rate);
}
rs5.close();
pstmt5.close();
} else if (order.getXX_VLO_DispatchRoute_ID() == aereo) {
String SQL5 =
("SELECT XX_RATE AS RATE "
+ "FROM XX_VLO_DispatchRoute "
+ "WHERE XX_VLO_DispatchRoute_ID = '"
+ aereo
+ "' ");
PreparedStatement pstmt5 = DB.prepareStatement(SQL5, null);
ResultSet rs5 = pstmt5.executeQuery();
if (rs5.next()) {
rate = rs5.getBigDecimal("RATE").divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
// Calculo del Seguro con Via aereo
Seguro = montoBs.multiply(rate);
}
rs5.close();
pstmt5.close();
} else if (order.getXX_VLO_DispatchRoute_ID() == terrestre) {
String SQL5 =
("SELECT XX_RATE AS RATE "
+ "FROM XX_VLO_DispatchRoute "
+ "WHERE XX_VLO_DispatchRoute_ID = '"
+ terrestre
+ "' ");
PreparedStatement pstmt5 = DB.prepareStatement(SQL5, null);
ResultSet rs5 = pstmt5.executeQuery();
if (rs5.next()) {
rate = rs5.getBigDecimal("RATE").divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
// Calculo del Seguro con Via terrestre
Seguro = montoBs.multiply(rate);
}
rs5.close();
pstmt5.close();
}
// Busco el porcentaje del flete internacional segun el proveedor, puerto y pais de la O/C
String SQL6 =
("SELECT DISTINCT A.XX_INTERFREESTIMATEPERT AS PERTFLEINTER "
+ "FROM XX_VLO_COSTSPERCENT A, C_ORDER B "
+ "WHERE B.XX_VLO_ARRIVALPORT_ID = '"
+ order.getXX_VLO_ArrivalPort_ID()
+ "' "
+ "AND B.C_BPARTNER_ID = '"
+ order.getC_BPartner_ID()
+ "' "
+ "AND B.C_COUNTRY_ID = '"
+ order.getC_Country_ID()
+ "' "
+ "AND B.XX_VLO_ARRIVALPORT_ID = A.XX_VLO_ARRIVALPORT_ID "
+ "AND B.XX_VLO_ARRIVALPORT_ID = A.XX_VLO_ARRIVALPORT_ID "
+ "AND B.C_BPARTNER_ID = A.C_BPARTNER_ID "
+ "AND B.C_COUNTRY_ID = A.C_COUNTRY_ID ");
PreparedStatement pstmt6 = DB.prepareStatement(SQL6, null);
ResultSet rs6 = pstmt6.executeQuery();
if (rs6.next()) {
// Porcentaje del flete internacional
perfleteInt =
rs6.getBigDecimal("PERTFLEINTER")
.divide(new BigDecimal(100), 4, RoundingMode.HALF_UP);
// Flete Internacional
fleteInternac = montoBs.multiply(perfleteInt);
}
rs6.close();
pstmt6.close();
// Busco los productos que tienen asociados las Ref de la O/C
String SQL7 =
("SELECT C.M_PRODUCT AS PRODUCT, A.XX_VMR_PO_LINEREFPROV_ID AS POLINE "
+ "FROM XX_VMR_PO_LINEREFPROV A, C_ORDER B, XX_VMR_REFERENCEMATRIX C "
+ "WHERE A.XX_VMR_PO_LINEREFPROV_ID = C.XX_VMR_PO_LINEREFPROV_ID "
+ "AND A.C_ORDER_ID = B.C_ORDER_ID "
+ "AND A.C_ORDER_ID = '"
+ LineRefProv.getC_Order_ID()
+ "' ");
PreparedStatement pstmt7 = DB.prepareStatement(SQL7, null);
ResultSet rs7 = pstmt7.executeQuery();
while (rs7.next()) {
// Calculo del Porcentaje de cada item = costo de cada item Bs / Monto O/C Bs
productid = rs7.getInt("PRODUCT");
poline = rs7.getInt("POLINE");
// Costo de cada item Bs
/*String SQL8 = ("SELECT (A.XX_UNITPURCHASEPRICE / B.XX_UNITCONVERSION) AS COSTO " +
"FROM XX_VMR_PO_LINEREFPROV A, XX_VMR_UNITCONVERSION B, XX_VMR_REFERENCEMATRIX C, M_PRODUCT D " +
"WHERE A.XX_VMR_UNITCONVERSION_ID = B.XX_VMR_UNITCONVERSION_ID " +
"AND A.XX_VMR_PO_LINEREFPROV_ID = C.XX_VMR_PO_LINEREFPROV_ID " +
"AND C.M_PRODUCT = D.M_PRODUCT_ID " +
"AND C.M_PRODUCT = '"+productid+"' " +
"AND A.XX_VMR_PO_LINEREFPROV_ID = '"+poline+"' ");*/
String SQL8 =
("SELECT (A.LINENETAMT * E.MULTIPLYRATE) AS COSTO "
+ "FROM XX_VMR_PO_LINEREFPROV A, XX_VMR_REFERENCEMATRIX C, M_PRODUCT D, C_CONVERSION_RATE E, C_ORDER F "
+ "WHERE A.XX_VMR_PO_LINEREFPROV_ID = C.XX_VMR_PO_LINEREFPROV_ID "
+ "AND C.M_PRODUCT = D.M_PRODUCT_ID "
+ "AND E.C_CONVERSION_RATE_ID = F.XX_CONVERSIONRATE_ID "
+ "AND A.C_ORDER_ID = F.C_ORDER_ID "
+ "AND C.M_PRODUCT = '"
+ productid
+ "' "
+ "AND A.XX_VMR_PO_LINEREFPROV_ID = '"
+ poline
+ "' ");
PreparedStatement pstmt8 = DB.prepareStatement(SQL8, null);
ResultSet rs8 = pstmt8.executeQuery();
if (rs8.next()) {
costoitem = rs8.getBigDecimal("COSTO");
// Porcentaje de cada item = costo de cada item Bs / Monto O/C Bs
porcentitem = (costoitem.divide(montoBs, 8, RoundingMode.HALF_UP));
// CIF Unitario = Porcentaje de cada Item * CIF total
cifuni = porcentitem.multiply(cifTotal);
// Busco Porcentaje Arancelario
String SQL9 =
("SELECT (D.XX_PERCENTAGETARIFF/100) AS PERARANCEL "
+ "FROM XX_VMR_PO_LINEREFPROV A, C_ORDER B, XX_VMR_REFERENCEMATRIX C, M_PRODUCT D "
+ "WHERE A.XX_VMR_PO_LINEREFPROV_ID = C.XX_VMR_PO_LINEREFPROV_ID "
+ "AND A.C_ORDER_ID = B.C_ORDER_ID "
+ "AND C.M_PRODUCT = D.M_PRODUCT_ID "
+ "AND D.M_PRODUCT_ID = '"
+ productid
+ "' "
+ "AND A.C_ORDER_ID = '"
+ LineRefProv.getC_Order_ID()
+ "' ");
PreparedStatement pstmt9 = DB.prepareStatement(SQL9, null);
ResultSet rs9 = pstmt9.executeQuery();
if (rs9.next()) {
// Porcentaje Arancelario
percentarancel = rs9.getBigDecimal("PERARANCEL");
// Arancel de cada item = CIF unitario * Porcentaje Arancelario
arancelitem = cifuni.multiply(percentarancel).add(arancelitem);
}
rs9.close();
pstmt9.close();
}
rs8.close();
pstmt8.close();
// cif total(Creo que no hace falta) t arancel item se usan abajo
} // end While rs7
rs7.close();
pstmt7.close();
String SQL9 =
("SELECT XX_RATE/100 AS RATESENIAT FROM XX_VLO_IMPORTRATE WHERE NAME = 'Tasa de Servicio de aduanas SENIAT' "
+ "And AD_Client_ID IN(0,"
+ Env.getCtx().getAD_Client_ID()
+ ")");
PreparedStatement pstmt9 = DB.prepareStatement(SQL9, null);
ResultSet rs9 = pstmt9.executeQuery();
if (rs9.next()) {
rateseniat = rs9.getBigDecimal("RATESENIAT");
montoseniat = arancelitem.multiply(rateseniat);
String SQL10 =
("SELECT XX_RATE/100 AS RATETESORERIA FROM XX_VLO_IMPORTRATE WHERE NAME = 'Tasa de Servicio Aduana Tesorería' "
+ "And AD_Client_ID IN(0,"
+ Env.getCtx().getAD_Client_ID()
+ ")");
PreparedStatement pstmt10 = DB.prepareStatement(SQL10, null);
ResultSet rs10 = pstmt10.executeQuery();
if (rs10.next()) {
ratetesoreria = rs10.getBigDecimal("RATETESORERIA");
montotesoreria = arancelitem.multiply(ratetesoreria);
// Monto Tasa aduanera =monto tasa seniat + monto tasa tesoreria
tasaaduana = montoseniat.add(montotesoreria);
}
rs10.close();
pstmt10.close();
}
rs9.close();
pstmt9.close();
// Calculo del IVA = (CIF total + Impuesto de importación + tasa aduanera) *%iva actual
String SQL11 =
("SELECT MAX (VALIDFROM) AS FECHA, A.RATE/100 AS IVACT "
+ "FROM C_TAX A, C_TAXCATEGORY B "
+ "WHERE A.C_TAXCATEGORY_ID = B.C_TAXCATEGORY_ID "
+ "AND B.DESCRIPTION = 'Impuesto al Valor Agregado' "
+ "AND A.C_TAXCATEGORY_ID = B.C_TAXCATEGORY_ID "
+ "GROUP BY A.RATE ");
PreparedStatement pstmt11 = DB.prepareStatement(SQL11, null);
ResultSet rs11 = pstmt11.executeQuery();
if (rs11.next()) {
part1 = cifTotal.add(arancelitem);
part2 = part1.add(tasaaduana);
iva = part2.multiply(rs11.getBigDecimal("IVACT"));
}
rs11.close();
pstmt11.close();
// Monto tesorería Nacional = IVA + impuesto de importación + monto tasa tesoreria
part = iva.add(arancelitem);
montesorerianac = part.add(montotesoreria);
// redondeo los BigDecimal
montesorerianac = montesorerianac.setScale(2, BigDecimal.ROUND_UP);
montoseniat = montoseniat.setScale(2, BigDecimal.ROUND_UP);
String sql =
"UPDATE C_Order po"
+ " SET XX_NatTreasuryEstAmount="
+ montesorerianac
+ " , XX_SENIATESTEEMEDAMUNT="
+ montoseniat
+ " WHERE po.C_Order_ID="
+ LineRefProv.getC_Order_ID();
DB.executeUpdate(null, sql);
} // end if Check
else {
// alguna referencia no tiene producto asociado
String sql =
"UPDATE C_Order po"
+ " SET XX_NatTreasuryEstAmount="
+ 0
+ " , XX_SENIATESTEEMEDAMUNT="
+ 0
+ " WHERE po.C_Order_ID="
+ LineRefProv.getC_Order_ID();
DB.executeUpdate(null, sql);
}
} // end try
catch (Exception e) {
}
} // dispose
/**
* Finds out if a SaoWorker is supposed to be working now
* or not. It consults the tables AIDESCHED for this, and
* if they have a entry in the current slot then they're
* okay. Otherwise they're covering for somebody.<P>
*
* Also, if it's 10 minutes before a new slot starts this
* looks at the next slot. This is to accomodate for the
* fact that sometimes aides will try to Aide In a few
* minutes before they're supposed to start working.<P>
*
* What's more, if the SaoWorker trying to AIDE IN is a
* Supervisor or Programmer, the method considers them
* always scheduled. How convenient!
*
* @param w The Aide trying to aide in
* @return True scheduled for this slot, or False not
*/
public boolean Scheduled(SaoWorker w)
{
BatSQL bSQL = new BatSQL();
String q = "select * from AIDESCHED where USERID='" + w.getUserID() + "'";
ResultSet rs = bSQL.query(q);
int h = bd.getHours();
int m = bd.getMinutes();
int slot = 0;
int sched = 0;
//first check if the worker is a Supervisor or Programmer
//these two Titles are always Scheduled to work.
if ((w.getTitle().equals("Supervisor")) || (w.getTitle().equals("Programmer")))
{
sched = 1;
}
else { //aides have to be in the correct slot
//this is the part where we check if they're early
if (((m >= 20) && (m < 30)) || ((m >= 50) && (m < 60)))
{
if (m > 30) { h = h + 1; m = m + 10 - 60; }
else { m = m + 10; }
int dopp = bd.getDoPP();
if (dopp > 7) { dopp = dopp - 7; }
slot = bd.getIntSlot(h, m, dopp);
}
else
{
int dopp = bd.getDoPP();
if (dopp > 7) { dopp = dopp - 7; }
slot = bd.getIntSlot(h, m, dopp);
}
//now we carry on as usual
try
{
rs.next();
sched = rs.getInt(slot+1); //+1 to skip the USERID field!
} //end of try
catch (SQLException ex)
{
System.out.println("!*******SQLException caught*******!");
System.out.println("Scheduled");
while (ex != null)
{
System.out.println ("SQLState: " + ex.getSQLState ());
System.out.println ("Message: " + ex.getMessage ());
System.out.println ("Vendor: " + ex.getErrorCode ());
ex = ex.getNextException ();
System.out.println ("");
}
System.exit(0);
} //end catching SQLExceptions
catch (java.lang.Exception ex)
{
System.out.println("!*******Exception caught*******!");
System.out.println("Scheduled");
System.exit(0);
} //end catching other Exceptions
} //end of else this is an aide
boolean scheded = (sched == 1);
return scheded;
} //end of Scheduled?
/* Clear all existing nodes from the tree model and rebuild from scratch.
*/
protected void refreshTree() {
DefaultMutableTreeNode propertiesNode;
DefaultMutableTreeNode leaf;
// First clear the existing tree by simply enumerating
// over the root node's children and removing them one by one.
while (treeModel.getChildCount(rootNode) > 0) {
DefaultMutableTreeNode child = (DefaultMutableTreeNode) treeModel.getChild(rootNode, 0);
treeModel.removeNodeFromParent(child);
child.removeAllChildren();
child.removeFromParent();
}
treeModel.nodeStructureChanged(rootNode);
treeModel.reload();
tScrollPane.repaint();
// Now rebuild the tree below its root
try {
// Start by naming the root node from its URL:
rootNode.setUserObject(dMeta.getURL());
// get metadata about user tables by building a vector of table names
String usertables[] = {"TABLE", "GLOBAL TEMPORARY", "VIEW"};
ResultSet result = dMeta.getTables(null, null, null, usertables);
Vector tables = new Vector();
// sqlbob@users Added remarks.
Vector remarks = new Vector();
while (result.next()) {
tables.addElement(result.getString(3));
remarks.addElement(result.getString(5));
}
result.close();
// For each table, build a tree node with interesting info
for (int i = 0; i < tables.size(); i++) {
String name = (String) tables.elementAt(i);
DefaultMutableTreeNode tableNode = makeNode(name, rootNode);
ResultSet col = dMeta.getColumns(null, null, name, null);
// sqlbob@users Added remarks.
String remark = (String) remarks.elementAt(i);
if ((remark != null) && !remark.trim().equals("")) {
makeNode(remark, tableNode);
}
// With a child for each column containing pertinent attributes
while (col.next()) {
String c = col.getString(4);
DefaultMutableTreeNode columnNode = makeNode(c, tableNode);
String type = col.getString(6);
makeNode("Type: " + type, columnNode);
boolean nullable = col.getInt(11) != DatabaseMetaData.columnNoNulls;
makeNode("Nullable: " + nullable, columnNode);
}
col.close();
DefaultMutableTreeNode indexesNode = makeNode("Indices", tableNode);
ResultSet ind = dMeta.getIndexInfo(null, null, name, false, false);
String oldiname = null;
// A child node to contain each index - and its attributes
while (ind.next()) {
DefaultMutableTreeNode indexNode = null;
boolean nonunique = ind.getBoolean(4);
String iname = ind.getString(6);
if ((oldiname == null || !oldiname.equals(iname))) {
indexNode = makeNode(iname, indexesNode);
makeNode("Unique: " + !nonunique, indexNode);
oldiname = iname;
}
// And the ordered column list for index components
makeNode(ind.getString(9), indexNode);
}
ind.close();
}
// Finally - a little additional metadata on this connection
propertiesNode = makeNode("Properties", rootNode);
makeNode("User: "******"ReadOnly: " + cConn.isReadOnly(), propertiesNode);
makeNode("AutoCommit: " + cConn.getAutoCommit(), propertiesNode);
makeNode("Driver: " + dMeta.getDriverName(), propertiesNode);
makeNode("Product: " + dMeta.getDatabaseProductName(), propertiesNode);
makeNode("Version: " + dMeta.getDatabaseProductVersion(), propertiesNode);
} catch (SQLException se) {
propertiesNode = makeNode("Error getting metadata:", rootNode);
makeNode(se.getMessage(), propertiesNode);
makeNode(se.getSQLState(), propertiesNode);
}
treeModel.nodeStructureChanged(rootNode);
treeModel.reload();
tScrollPane.repaint();
}
