public final void populateDivisionColumn() throws SQLException {
Sql sql = sqlhand.als_mysoftsql();
if (sql == null) return;
List<GroovyRowResult> tlist = null;
String sqlstm =
"select distinct stock_cat from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' order by stock_cat";
try {
tlist = sql.rows(sqlstm);
sql.close();
} catch (SQLException e) {
}
if (tlist.size() == 0) return;
Listbox newlb = lbhand.makeVWListbox(division_holder, blankish_lb_headers, division_lbid, 20);
newlb.addEventListener("onSelect", new divisionOnClick());
String[] strarray = new String[1];
String tp_division = luhand.getRec_Origid("TP_DIVISIONS"); // hardcoded
// debugLabel.setValue("getrec_origid: " + tp_division);
for (GroovyRowResult ilist : tlist) {
strarray[0] =
luhand.matchLookup_ReturnStr("TP_DIVISIONS", (String) ilist.get("stock_cat"), 1);
// strarray[0] = (String)ilist.get("stock_cat");
lbhand.insertListItems(newlb, strarray, "true", "");
}
} // end of populateDivisionColumn()
// Populate division column - refer to mysoft.stockmasterdetails.stock_cat
// nominal_code=glcode=5xxxxx = services we sell
// istock_cat = as in stockmasterdetails.stock_cat
public final void populateSectionColumn(String istock_cat) {
Sql sql = sqlhand.als_mysoftsql();
if (sql == null) return;
String sqlstm =
"select distinct groupcode from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' "
+ "and stock_cat='"
+ istock_cat
+ "' order by groupcode";
List<GroovyRowResult> tlist = null;
try {
tlist = sql.rows(sqlstm);
sql.close();
} catch (SQLException e) {
}
if (tlist == null) return;
selected_category = istock_cat; // save for later usage
if (tlist.size() == 0) return;
Listbox newlb = lbhand.makeVWListbox(section_holder, blankish_lb_headers, section_lbid, 20);
newlb.addEventListener("onSelect", new sectionOnClick());
String[] strarray = new String[1];
for (GroovyRowResult ilist : tlist) {
strarray[0] = (String) ilist.get("groupcode");
lbhand.insertListItems(newlb, strarray, "true", "");
}
} // end of populateSectionColumn()
@Override
public Boolean call() throws Exception {
Sql sql = null;
try {
sql = Upgrades.DatabaseFilters.NEWVERSION.getConnection("eucalyptus_cloud");
sql.execute(
"create index metadata_group_ips_rule_id_idx on metadata_network_rule_ip_ranges ( networkrule_id )");
sql.execute(
"create index metadata_group_peers_rule_id_idx on metadata_network_group_rule_peers ( networkrule_id )");
} catch (Exception ex) {
logger.error("Error creating network rule indexes", ex);
} finally {
if (sql != null) {
sql.close();
}
}
return true;
}
@Override
public Boolean call() throws Exception {
Sql sql = null;
try {
sql = Upgrades.DatabaseFilters.NEWVERSION.getConnection("eucalyptus_auth");
sql.execute(
"alter table auth_group add constraint uk_4ns2wloivviwxjbx7jeg5ip31 unique ( auth_group_id_external )");
sql.execute(
"create index auth_group_users_user_idx on auth_group_has_users ( auth_user_id )");
sql.execute(
"create index auth_group_users_group_idx on auth_group_has_users ( auth_group_id )");
} catch (Exception ex) {
logger.error("Error creating group indexes", ex);
} finally {
if (sql != null) {
sql.close();
}
}
return true;
}
public static Sql getDbConnection() throws Exception {
if (sqlInstance != null) {
return sqlInstance;
}
/*
* db connection if there is one
* postgresql:host:port:database:user:passwd
*/
if (p_remotedbUrl != null) {
String[] urlSplit = p_remotedbUrl.split(":");
StringBuilder jdbcUrlBuilder = new StringBuilder();
jdbcUrlBuilder.append("jdbc:");
jdbcUrlBuilder.append(urlSplit[0]);
jdbcUrlBuilder.append("://");
jdbcUrlBuilder.append(urlSplit[1]);
jdbcUrlBuilder.append(":");
jdbcUrlBuilder.append(urlSplit[2]);
jdbcUrlBuilder.append("/");
jdbcUrlBuilder.append(urlSplit[3]);
String driverString = "";
if (urlSplit[0].equals("postgresql")) {
driverString = "org.postgresql.Driver";
}
try {
sqlInstance =
Sql.newInstance(jdbcUrlBuilder.toString(), urlSplit[4], urlSplit[5], driverString);
} catch (Exception e) {
e.printStackTrace();
p_err.println(e.getLocalizedMessage());
}
return sqlInstance;
}
return null;
}
// Populate division column - refer to mysoft.stockmasterdetails.stock_cat
// nominal_code=glcode=5xxxxx = services we sell
// istock_cat = as in stockmasterdetails.stock_cat
// 27/03/2012: uses showType to determine which one to show,
// 1=default,2=stock-pricing,3=testpackage
// 07/03/2013: pricing_lb_headers add "Subcon" column = stockmasterdetails.newfield4
public final void populateTestParametersColumn(String istock_cat, String igroupcode)
throws SQLException {
Object[] testparameters_lb_headers = {
new listboxHeaderObj("mysoftcode", false),
new listboxHeaderObj("Test", true),
new listboxHeaderObj("Method", true),
};
Object[] pricing_lb_headers = {
new listboxHeaderObj("mysoftcode", false),
new listboxHeaderObj("Stock.Code", true),
new listboxHeaderObj("Test", true),
new listboxHeaderObj("Method", true),
new listboxHeaderObj("Cost", true),
new listboxHeaderObj("Selling", true),
new listboxHeaderObj("Subcon", true),
};
Object[] testpackages_lb_headers = {
new listboxHeaderObj("mysoftcode", false),
new listboxHeaderObj("Stock.Code", true),
new listboxHeaderObj("Test", true),
new listboxHeaderObj("Method", true),
new listboxHeaderObj("S.Price", true),
new listboxHeaderObj("LOR", true),
new listboxHeaderObj("Bill", true),
new listboxHeaderObj("Units", true),
};
Object[] whichheader = null;
String sqlstm = "";
// NumberFormat nf = NumberFormat.getCurrencyInstance();
DecimalFormat nf = new DecimalFormat("####.00");
String costprice, sellingprice;
switch (showType) {
case 1:
whichheader = testparameters_lb_headers;
// 30/9/2010: put a filter to knockout p-p2-%METALS items
sqlstm =
"select id,description,description2 from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' "
+ "and stock_cat='"
+ istock_cat
+ "' "
+ "and groupcode='"
+ igroupcode
+ "' "
+ "and stock_code not like 'p-p2-%METALS' "
+ "order by description";
break;
case 2:
whichheader = pricing_lb_headers;
sqlstm =
"select id,stock_code,description,description2,cost_price,selling_price,newfield4 "
+ "from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' "
+ "and stock_cat='"
+ istock_cat
+ "' "
+ "and groupcode='"
+ igroupcode
+ "' "
+ "order by description";
break;
case 3:
whichheader = testpackages_lb_headers;
sqlstm =
"select id,stock_code,description,description2,newfield8,newfield9,newfield10,selling_price "
+ "from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' "
+ "and stock_cat='"
+ istock_cat
+ "' "
+ "and groupcode='"
+ igroupcode
+ "' "
+ "order by description";
break;
}
Listbox newlb = lbhand.makeVWListbox(tests_holder, whichheader, tests_lbid, 15);
Sql sql = sqlhand.als_mysoftsql();
if (sql == null) return;
List<GroovyRowResult> tlist = sql.rows(sqlstm);
sql.close();
String lor, bill, units;
if (tlist.size() == 0) return;
if (testOnClicker != null) newlb.addEventListener("onSelect", testOnClicker);
for (GroovyRowResult ilist : tlist) {
ArrayList kabom = new ArrayList();
switch (showType) {
case 1:
kabom.add(String.valueOf(ilist.get("id")));
kabom.add(kiboo.checkNullString((String) ilist.get("description")));
kabom.add(kiboo.checkNullString((String) ilist.get("description2")));
break;
case 2:
kabom.add(ilist.get("id").toString());
kabom.add(kiboo.checkNullString((String) ilist.get("stock_code")));
kabom.add(
lbhand.trimListitemLabel(
kiboo.checkNullString((String) ilist.get("description")), 35));
kabom.add(
lbhand.trimListitemLabel(
kiboo.checkNullString((String) ilist.get("description2")), 35));
costprice = nf.format((Double) ilist.get("cost_price"));
kabom.add(costprice);
sellingprice = nf.format((Double) ilist.get("selling_price"));
kabom.add(sellingprice);
kabom.add(kiboo.checkNullString((String) ilist.get("newfield4")));
break;
case 3:
kabom.add(ilist.get("id").toString());
kabom.add(kiboo.checkNullString((String) ilist.get("stock_code")));
kabom.add(kiboo.checkNullString_RetWat((String) ilist.get("description"), "---"));
// methodme = trimListitemLabel(ilist.get("description2"), 30);
kabom.add(kiboo.checkNullString_RetWat((String) ilist.get("description2"), "---"));
kabom.add(nf.format(ilist.get("selling_price")));
lor = kiboo.checkNullString((String) ilist.get("newfield8"));
bill = kiboo.checkNullString((String) ilist.get("newfield9"));
units = kiboo.checkNullString((String) ilist.get("newfield10"));
lor = (lor.equals("")) ? "----" : lor;
bill = (bill.equals("")) ? "---" : bill;
units = (units.equals("")) ? "----" : units;
kabom.add(lor);
kabom.add(bill);
kabom.add(units);
break;
}
String[] strarray = kiboo.convertArrayListToStringArray(kabom);
lbhand.insertListItems(newlb, strarray, "true", "");
}
if (testOnDoubleClicker != null) lbhand.setDoubleClick_ListItems(newlb, testOnDoubleClicker);
} // end of populateTestParametersColumn()