/**
* ************************************************************************ Create Missing
* Document Types
*
* @param ctx context
* @param AD_Client_ID client
* @param sp server process
* @param trx transaction
*/
public static void createDocumentTypes(Ctx ctx, int AD_Client_ID, SvrProcess sp, Trx trx) {
s_log.info("AD_Client_ID=" + AD_Client_ID);
String sql =
"SELECT rl.Value, rl.Name "
+ "FROM AD_Ref_List rl "
+ "WHERE rl.AD_Reference_ID=183"
+ " AND rl.IsActive='Y' AND NOT EXISTS "
+ " (SELECT * FROM C_DocType dt WHERE dt.AD_Client_ID=? AND rl.Value=dt.DocBaseType)";
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql, trx);
pstmt.setInt(1, AD_Client_ID);
rs = pstmt.executeQuery();
while (rs.next()) {
String name = rs.getString(2);
String value = rs.getString(1);
s_log.config(name + "=" + value);
MDocType dt = new MDocType(ctx, value, name, trx);
if (dt.save()) {
if (sp != null) sp.addLog(0, null, null, name);
else s_log.fine(name);
} else {
if (sp != null) sp.addLog(0, null, null, "Not created: " + name);
else s_log.warning("Not created: " + name);
}
}
} catch (Exception e) {
s_log.log(Level.SEVERE, sql, e);
} finally {
DB.closeResultSet(rs);
DB.closeStatement(pstmt);
}
} // createDocumentTypes
protected CFSecurityTSecGroupBuff unpackTSecGroupResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackTSecGroupResultSetToBuff";
int idxcol = 1;
CFSecurityTSecGroupBuff buff = schema.getFactoryTSecGroup().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredTSecGroupId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFAccFeeDetailBuff unpackFeeDetailResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackFeeDetailResultSetToBuff";
int idxcol = 1;
CFAccFeeDetailBuff buff = schema.getFactoryFeeDetail().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFAccSybaseSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFAccSybaseSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredFeeId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredFeeDetailId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredAmountCharged(resultSet.getBigDecimal(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecurityISOCountryLanguageBuff unpackISOCountryLanguageResultSetToBuff(
ResultSet resultSet) throws SQLException {
final String S_ProcName = "unpackISOCountryLanguageResultSetToBuff";
int idxcol = 1;
CFSecurityISOCountryLanguageBuff buff = schema.getFactoryISOCountryLanguage().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFCrmMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFCrmMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
buff.setRequiredISOCountryId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredISOLanguageId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecuritySecFormBuff unpackSecFormResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackSecFormResultSetToBuff";
int idxcol = 1;
CFSecuritySecFormBuff buff = schema.getFactorySecForm().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFCrmDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFCrmDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredClusterId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredSecFormId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredSecAppId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredJEEServletMapName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFCrmMemoDataBuff unpackMemoDataResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackMemoDataResultSetToBuff";
int idxcol = 1;
CFCrmMemoDataBuff buff = schema.getFactoryMemoData().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFCrmMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFCrmMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredMemoId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredContactId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredMemo(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecurityServiceTypeBuff unpackServiceTypeResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackServiceTypeResultSetToBuff";
int idxcol = 1;
CFSecurityServiceTypeBuff buff = schema.getFactoryServiceType().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecuritySybaseSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecuritySybaseSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredServiceTypeId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
/**
* Set Resource Assignment - Callout
*
* @param oldS_ResourceAssignment_ID old value
* @param newS_ResourceAssignment_ID new value
* @param windowNo window
* @throws Exception
*/
@UICallout
public void setS_ResourceAssignment_ID(
String oldS_ResourceAssignment_ID, String newS_ResourceAssignment_ID, int windowNo)
throws Exception {
if (newS_ResourceAssignment_ID == null || newS_ResourceAssignment_ID.length() == 0) return;
int S_ResourceAssignment_ID = Integer.parseInt(newS_ResourceAssignment_ID);
if (S_ResourceAssignment_ID == 0) return;
//
super.setS_ResourceAssignment_ID(S_ResourceAssignment_ID);
int M_Product_ID = 0;
String Name = null;
String Description = null;
BigDecimal Qty = null;
String sql =
"SELECT p.M_Product_ID, ra.Name, ra.Description, ra.Qty "
+ "FROM S_ResourceAssignment ra"
+ " INNER JOIN M_Product p ON (p.S_Resource_ID=ra.S_Resource_ID) "
+ "WHERE ra.S_ResourceAssignment_ID=?";
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql, get_Trx());
pstmt.setInt(1, S_ResourceAssignment_ID);
rs = pstmt.executeQuery();
if (rs.next()) {
M_Product_ID = rs.getInt(1);
Name = rs.getString(2);
Description = rs.getString(3);
Qty = rs.getBigDecimal(4);
}
} catch (SQLException e) {
log.log(Level.SEVERE, sql, e);
} finally {
DB.closeResultSet(rs);
DB.closeStatement(pstmt);
}
log.fine(
"S_ResourceAssignment_ID=" + S_ResourceAssignment_ID + " - M_Product_ID=" + M_Product_ID);
if (M_Product_ID != 0) {
setM_Product_ID(M_Product_ID);
if (Description != null) Name += " (" + Description + ")";
if (!".".equals(Name)) setDescription(Name);
if (Qty != null) setQty(Qty);
}
} // setS_ResourceAssignment_ID
protected CFInternetURLProtocolBuff unpackURLProtocolResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackURLProtocolResultSetToBuff";
int idxcol = 1;
CFInternetURLProtocolBuff buff = schema.getFactoryURLProtocol().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFBamDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFBamDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredURLProtocolId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredIsSecure(("Y".equals(resultSet.getString(idxcol)) ? true : false));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecurityAuditActionBuff unpackAuditActionResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackAuditActionResultSetToBuff";
int idxcol = 1;
CFSecurityAuditActionBuff buff = schema.getFactoryAuditAction().newBuff();
buff.setRequiredAuditActionId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFBamAccessSecurityBuff unpackAccessSecurityResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackAccessSecurityResultSetToBuff";
int idxcol = 1;
CFBamAccessSecurityBuff buff = schema.getFactoryAccessSecurity().newBuff();
buff.setRequiredId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
/* return list of all Devices within the specified DeviceGroup (NOT SCALABLE BEYOND A FEW HUNDRED GROUPS) */
public static java.util.List<String> getUsersForGroup(String acctId, String groupId)
throws DBException {
/* valid account/groupId? */
if (StringTools.isBlank(acctId)) {
return null;
} else if (StringTools.isBlank(groupId)) {
return null;
}
/* get db selector */
DBSelect dsel = GroupList._getUserListSelect(acctId, groupId);
if (dsel == null) {
return null;
}
/* read users for group */
java.util.List<String> usrList = new Vector<String>();
DBConnection dbc = null;
Statement stmt = null;
ResultSet rs = null;
try {
dbc = DBConnection.getDefaultConnection();
stmt = dbc.execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
String usrId = rs.getString(GroupList.FLD_userID);
usrList.add(usrId);
}
} catch (SQLException sqe) {
throw new DBException("Get Group GroupeList", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
DBConnection.release(dbc);
}
/* return list */
return usrList;
}
/**
* initFromResultSet initializes the data members from PersonalProfile. This code was separated
* from the ResultSet constructor so that createExisting(ResultSet) could handle VIEWs.
*/
private void initFromResultSet(ResultSet rs)
throws SQLException, ObjectIdException, DataObjectException, DatabaseManagerException {
// Constructing a DO from a ResultSet means we definitely need the
// DataStruct ready for the setXxx methods invoked below.
data = new PersonalProfileDataStruct();
// writeMemberStuff uses the ResultSetExtraction.template
// to build up the value for this tag:
// the value is a series of calls to the DO set methods.
setMinAge(rs.getInt("MinAge"));
setMaxAge(rs.getInt("MaxAge"));
setNationality(jobmatch.data.CountryDO.createExisting(rs.getBigDecimal("Nationality", 0)));
setSex(rs.getString("Sex"));
markClean();
}
/**
* Gets the instances of <CODE>Template</CODE> that have an ID that is already in the database.
*
* @return An <CODE>ArrayList</CODE> containing the instances of <CODE>Template</CODE> already in
* the database.
* @throws java.sql.SQLException Thrown on sql exception.
*/
public ArrayList findTemplatesInDatabase() throws java.sql.SQLException {
ArrayList templatesInDatabase = new ArrayList();
Connection oracleConnection = getDataSource().getConnection();
try {
Statement query = oracleConnection.createStatement();
try {
StringBuffer sql = new StringBuffer("SELECT TMPL_ID FROM ");
sql.append(MPSBrowserView.SCHEMA);
sql.append(".TEMPLATE WHERE TMPL_ID IN (");
ArrayList templates = getTemplates();
int templateCount = templates.size();
for (int i = 0; i < templateCount; i++) {
if (i > 0) sql.append(", ");
sql.append("'");
sql.append(((Template) templates.get(i)).getID());
sql.append("'");
}
sql.append(")");
ResultSet result = query.executeQuery(sql.toString());
try {
while (result.next()) {
String templateID = result.getString("TMPL_ID");
for (int i = 0; i < templateCount; i++) {
Template currentTemplate = (Template) templates.get(i);
if (templateID.equals(currentTemplate.getID())) {
templatesInDatabase.add(currentTemplate);
currentTemplate.setInDatabase(true);
}
}
}
} finally {
result.close();
}
} finally {
query.close();
}
} finally {
oracleConnection.close();
}
return templatesInDatabase;
}
protected CFSecurityISOTimezoneBuff unpackISOTimezoneResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackISOTimezoneResultSetToBuff";
int idxcol = 1;
CFSecurityISOTimezoneBuff buff = schema.getFactoryISOTimezone().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFDbTestPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFDbTestPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredISOTimezoneId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredIso8601(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredTZName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredTZHourOffset(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredTZMinOffset(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredVisible(resultSet.getBoolean(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFInternetTopDomainBuff unpackTopDomainResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackTopDomainResultSetToBuff";
int idxcol = 1;
String classCode = resultSet.getString(idxcol);
idxcol++;
CFInternetTopDomainBuff buff;
if (classCode.equals("TDOM")) {
buff = schema.getFactoryTopDomain().newBuff();
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Unrecognized class code \"" + classCode + "\"");
}
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFDbTestDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFDbTestDb2LUWSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredTenantId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredId(resultSet.getLong(idxcol));
idxcol++;
{
String colVal = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setOptionalDescription(null);
} else {
buff.setOptionalDescription(colVal);
}
}
idxcol++;
buff.setRequiredTldId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
public DTIPAddrList(ResultSet rs, String fldName) throws SQLException {
// set to default value if 'rs' is null
this((rs != null) ? new IPTools.IPAddressList(rs.getString(fldName)) : null);
}
public DTIPAddress(ResultSet rs, String fldName) throws SQLException {
super(rs, fldName);
// set to default value if 'rs' is null
this.ipAddr = (rs != null) ? new IPTools.IPAddress(rs.getString(fldName)) : null;
}
public void calculate() {
int id = 0;
double tf = 0, maxtf = 0, nf = 0, n = 0;
double tfidf = 0.0;
String qry1, qry2, redoc, qry3;
PreparedStatement ps1, ps2, ps3;
ResultSet rs1, rs2;
try {
init();
String query = "select distinct(id) from index "; // where weburl='"+we+"'";
PreparedStatement preparedstatement = con.prepareStatement(query);
ResultSet rs = preparedstatement.executeQuery();
while (rs.next()) {
n++;
}
// System.out.println("THE TOTAL DOCUMENT== "+n);
query = "select distinct(id) from index "; // where weburl='"+we+"'";
preparedstatement = con.prepareStatement(query);
rs = preparedstatement.executeQuery();
while (rs.next()) {
id = rs.getInt(1);
System.out.println(id);
qry1 = "select max(totcon) from wordcount where urlid=" + id + "";
ps1 = con.prepareStatement(qry1);
rs1 = ps1.executeQuery();
while (rs1.next()) {
maxtf = rs1.getDouble(1);
}
// System.out.println("THE MAximaus "+maxtf);
qry1 = "select word,totcon from wordcount where urlid=" + id + "";
ps1 = con.prepareStatement(qry1);
rs1 = ps1.executeQuery();
while (rs1.next()) {
redoc = rs1.getString(1);
tf = rs1.getDouble(2);
// System.out.println("TF "+tf);
qry2 = "select word from wordcount where word='" + redoc + "'";
ps2 = con.prepareStatement(qry2);
rs2 = ps2.executeQuery();
while (rs2.next()) {
nf++;
}
tfidf = (tf / maxtf) * (nf / n);
String xx = "" + tfidf;
double finl;
if (xx.length() > 5) finl = Double.parseDouble(xx.substring(0, 5));
else finl = tfidf;
qry3 = "update wordcount set tfidf=" + finl + " where word='" + redoc + "'";
// System.out.println(qry3);
ps3 = con.prepareStatement(qry3);
ps3.executeUpdate();
System.out.println("THE N=" + n + "MAX=" + maxtf + "THE Tf=" + tf + "THE NF " + nf);
System.out.println("THE TFIDF NT===" + finl);
nf = 0;
}
}
con.close();
} catch (Exception ex) {
System.out.println("Error in verb :" + ex);
}
}
/**
* Create Period Controls
*
* @param ctx context
* @param AD_Client_ID client
* @param sp server process
* @param trx transaction
*/
public static void createPeriodControls(Ctx ctx, int AD_Client_ID, SvrProcess sp, Trx trx) {
s_log.info("AD_Client_ID=" + AD_Client_ID);
// Delete Duplicates
String sql =
"DELETE FROM C_PeriodControl "
+ "WHERE (C_Period_ID, DocBaseType) IN "
+ "(SELECT C_Period_ID, DocBaseType "
+ "FROM C_PeriodControl pc2 "
+ "GROUP BY C_Period_ID, DocBaseType "
+ "HAVING COUNT(*) > 1)"
+ " AND C_PeriodControl_ID NOT IN "
+ "(SELECT MIN(C_PeriodControl_ID) "
+ "FROM C_PeriodControl pc3 "
+ "GROUP BY C_Period_ID, DocBaseType)";
int no = DB.executeUpdate(trx, sql);
s_log.info("Duplicates deleted #" + no);
// Insert Missing
sql =
"SELECT DISTINCT p.AD_Client_ID, p.C_Period_ID, dbt.DocBaseType "
+ "FROM C_Period p, "
+ "C_DocBaseType dbt "
+ "WHERE p.AD_Client_ID=? "
+ " AND NOT EXISTS"
+ " (SELECT * FROM C_PeriodControl pc "
+ "WHERE pc.C_Period_ID=p.C_Period_ID AND pc.DocBaseType=dbt.DocBaseType)"
+ " AND (dbt.AD_Client_ID = 0 OR p.AD_Client_ID = dbt.AD_Client_ID)";
PreparedStatement pstmt = null;
ResultSet rs = null;
int counter = 0;
try {
pstmt = DB.prepareStatement(sql, trx);
pstmt.setInt(1, AD_Client_ID);
rs = pstmt.executeQuery();
while (rs.next()) {
int Client_ID = rs.getInt(1);
int C_Period_ID = rs.getInt(2);
String DocBaseType = rs.getString(3);
s_log.config(
"AD_Client_ID="
+ Client_ID
+ ", C_Period_ID="
+ C_Period_ID
+ ", DocBaseType="
+ DocBaseType);
//
MPeriodControl pc = new MPeriodControl(ctx, Client_ID, C_Period_ID, DocBaseType, trx);
if (pc.save()) {
counter++;
s_log.fine(pc.toString());
} else s_log.warning("Not saved: " + pc);
}
} catch (Exception e) {
s_log.log(Level.SEVERE, sql, e);
} finally {
DB.closeResultSet(rs);
DB.closeStatement(pstmt);
}
if (sp != null) sp.addLog(0, null, new BigDecimal(counter), "@C_PeriodControl_ID@ @Created@");
s_log.info("Inserted #" + counter);
} // createPeriodControls
public Design() throws Exception {
super.setBackground(Color.BLACK);
this.setTitle("");
con = getContentPane();
con.setLayout(null);
dim = tk.getDefaultToolkit().getScreenSize();
this.setTitle("Customer Peer Login");
l1 = new JLabel(new ImageIcon("plain.jpg"));
l1.setBounds(0, 0, 400, 400);
con.add(l1);
l1.setBorder(BorderFactory.createEtchedBorder(5, Color.black, Color.black));
title = new JLabel("CUSTOMER PEER LOGIN ");
title.setFont(new Font("Bookman Old Style", Font.ROMAN_BASELINE, 20));
title.setForeground(Color.red);
title.setBounds(80, 30, 300, 30);
l1.add(title);
l4 = new JLabel("CMACHINE NAME");
l4.setFont(new Font("Bookman Old Style", Font.BOLD, 16));
l4.setForeground(Color.BLUE);
l4.setBounds(70, 100, 160, 20);
// l4.setBorder(BorderFactory.createEtchedBorder(5,Color.green,Color.green));
l1.add(l4);
jtf2 = new JTextField();
jtf2.setBounds(250, 100, 100, 20);
jtf2.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green));
l1.add(jtf2);
l2 = new JLabel("CUSER LOGIN");
l2.setFont(new Font("Bookman Old Style", Font.BOLD, 16));
l2.setForeground(Color.blue);
l2.setBounds(70, 150, 120, 20);
l1.add(l2);
jtf1 = new JTextField();
jtf1.setBounds(250, 150, 100, 20);
jtf1.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green));
l1.add(jtf1);
l3 = new JLabel("CPASSWORD");
l3.setFont(new Font("Bookman Old Style", Font.BOLD, 16));
l3.setForeground(Color.blue);
l3.setBounds(70, 200, 120, 20);
l1.add(l3);
jptf1 = new JPasswordField();
jptf1.setBounds(250, 200, 100, 20);
jptf1.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green));
l1.add(jptf1);
JLabel l4 = new JLabel("DAgent");
l4.setFont(new Font("Bookman Old Style", Font.BOLD, 16));
l4.setForeground(Color.blue);
l4.setBounds(70, 250, 120, 20);
l1.add(l4);
box = new JComboBox();
box.setBounds(250, 250, 100, 20);
box.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green));
l1.add(box);
b2 = new JButton("Register");
b2.setBounds(50, 300, 100, 20);
l1.add(b2);
b2.setBorder(BorderFactory.createEtchedBorder(10, Color.BLUE, Color.BLUE));
b3 = new JButton("Login");
b3.setBounds(150, 300, 100, 20);
b3.setBorder(BorderFactory.createEtchedBorder(10, Color.BLUE, Color.BLUE));
l1.add(b3);
b1 = new JButton("Cancel");
b1.setBounds(250, 300, 100, 20);
b1.setBorder(BorderFactory.createEtchedBorder(10, Color.BLUE, Color.BLUE));
l1.add(b1);
b1.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent we) {
dispose();
}
});
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:agent");
} catch (Exception exp) {
}
try {
Statement satem = conn.createStatement();
ResultSet rsatem = satem.executeQuery("select * from Dagent");
while (rsatem.next()) {
String namem = rsatem.getString("uname");
box.addItem(namem);
}
} catch (Exception expo1) {
}
b2.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent we) {
String username = jtf1.getText().trim();
String password = jptf1.getText().trim();
String mechine = jtf2.getText().trim();
String dname = box.getSelectedItem().toString();
int porte = 0;
try {
Statement sate = conn.createStatement();
ResultSet rsate =
sate.executeQuery("select * from Dagent where uname='" + dname + "'");
if (rsate.next()) {
servermachine = rsate.getString("umechine");
porte = rsate.getInt("ulistport");
System.out.println(servermachine);
}
System.out.println(servermachine);
} catch (Exception exp) {
exp.printStackTrace();
}
try {
packet p = new packet();
p.setaction("Creg");
p.setCuser(username);
p.setCpass(password);
p.setCmname(mechine);
p.setCDpeer(dname);
Socket soc = new Socket(servermachine, porte);
ObjectOutputStream out = new ObjectOutputStream(soc.getOutputStream());
out.writeObject(p);
ObjectInputStream in = new ObjectInputStream(soc.getInputStream());
packet rpac = (packet) in.readObject();
if (rpac.getaction().equals("ok")) {
JOptionPane.showMessageDialog(null, "Sucessfully Registered");
jtf2.setText("");
jtf1.setText("");
jptf1.setText("");
} else {
JOptionPane.showMessageDialog(null, "Already Registered");
jtf2.setText("");
jtf1.setText("");
jptf1.setText("");
}
} catch (Exception exp) {
}
}
});
b3.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent we) {
String username = jtf1.getText().trim();
String password = jptf1.getText().trim();
String mechine = jtf2.getText().trim();
String Dname = box.getSelectedItem().toString();
int porte = 0;
try {
Statement sate = conn.createStatement();
ResultSet rsate =
sate.executeQuery("select * from Dagent where uname='" + Dname + "'");
if (rsate.next()) {
servermachine = rsate.getString("umechine");
porte = rsate.getInt("ulistport");
System.out.println(servermachine);
}
System.out.println(servermachine);
} catch (Exception exp) {
}
try {
packet p1 = new packet();
p1.setaction("clogin");
p1.setCuser(username);
p1.setCpass(password);
p1.setCmname(mechine);
p1.setCDpeer(Dname);
Socket soc1 = new Socket(servermachine, porte);
ObjectOutputStream out1 = new ObjectOutputStream(soc1.getOutputStream());
out1.writeObject(p1);
ObjectInputStream in1 = new ObjectInputStream(soc1.getInputStream());
packet rpac1 = (packet) in1.readObject();
if (rpac1.getaction().equals("ok")) {
int port1 = 0;
try {
int portm = rpac1.getCport();
System.out.println("XXXXXXX" + portm);
// JOptionPane.showMessageDialog(null,"Sucessfully Started");
new Listen(portm);
new process(username, portm);
dispose();
} catch (Exception exp) {
}
} else {
JOptionPane.showMessageDialog(
null, "Enter valid username and password", "Server reply", 2);
jtf1.setText("");
jtf2.setText("");
jptf1.setText("");
}
} catch (Exception exp) {
}
}
});
setSize(400, 400);
show();
setLocation(150, 100);
setResizable(false);
}
protected CFSecurityISOCurrencyBuff unpackISOCurrencyResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackISOCurrencyResultSetToBuff";
int idxcol = 1;
CFSecurityISOCurrencyBuff buff = schema.getFactoryISOCurrency().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFInternetMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFInternetMSSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredISOCurrencyId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredISOCode(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredName(resultSet.getString(idxcol));
idxcol++;
{
String colVal = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setOptionalUnitSymbol(null);
} else {
buff.setOptionalUnitSymbol(colVal);
}
}
idxcol++;
buff.setRequiredPrecis(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
protected CFSecuritySecDeviceBuff unpackSecDeviceResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackSecDeviceResultSetToBuff";
int idxcol = 1;
CFSecuritySecDeviceBuff buff = schema.getFactorySecDevice().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecurityMySqlSchema.convertTimestampString(colString));
}
}
idxcol++;
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
}
idxcol++;
buff.setRequiredSecUserId(CFSecurityMySqlSchema.convertUuidString(resultSet.getString(idxcol)));
idxcol++;
buff.setRequiredDevName(resultSet.getString(idxcol));
idxcol++;
{
String colVal = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setOptionalPubKey(null);
} else {
buff.setOptionalPubKey(colVal);
}
}
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
/**
* ** Constructor ** @param rs SQL ResultSet ** @param fldName Field name in ResultSet containing
* the field template
*/
public DTTemplate(ResultSet rs, String fldName) throws SQLException {
super(rs, fldName);
// set to default value if 'rs' is null
this.templateProps = new RTProperties((rs != null) ? rs.getString(fldName) : "");
this.fieldCount = -1;
}
/** Business logic to execute. */
public VOListResponse loadItemVariants(GridParams pars, String serverLanguageId, String username)
throws Throwable {
PreparedStatement pstmt = null;
Connection conn = null;
try {
if (this.conn == null) conn = getConn();
else conn = this.conn;
String tableName = (String) pars.getOtherGridParams().get(ApplicationConsts.TABLE_NAME);
ItemPK pk = (ItemPK) pars.getOtherGridParams().get(ApplicationConsts.ITEM_PK);
String productVariant = (String) productVariants.get(tableName);
String variantType = (String) variantTypes.get(tableName);
String variantTypeJoin = (String) variantTypeJoins.get(tableName);
String variantCodeJoin = (String) variantCodeJoins.get(tableName);
String sql =
"select "
+ tableName
+ "."
+ variantTypeJoin
+ ","
+ tableName
+ ".VARIANT_CODE,A.DESCRIPTION,B.DESCRIPTION, "
+ tableName
+ ".PROGRESSIVE_SYS10,"
+ variantType
+ ".PROGRESSIVE_SYS10 "
+ "from "
+ tableName
+ ","
+ variantType
+ ",SYS10_COMPANY_TRANSLATIONS A,SYS10_COMPANY_TRANSLATIONS B "
+ "where "
+ tableName
+ ".COMPANY_CODE_SYS01=? and "
+ tableName
+ ".COMPANY_CODE_SYS01="
+ variantType
+ ".COMPANY_CODE_SYS01 and "
+ tableName
+ "."
+ variantTypeJoin
+ "="
+ variantType
+ ".VARIANT_TYPE and "
+ tableName
+ ".COMPANY_CODE_SYS01=A.COMPANY_CODE_SYS01 and "
+ tableName
+ ".PROGRESSIVE_SYS10=A.PROGRESSIVE and A.LANGUAGE_CODE=? and "
+ variantType
+ ".COMPANY_CODE_SYS01=B.COMPANY_CODE_SYS01 and "
+ variantType
+ ".PROGRESSIVE_SYS10=B.PROGRESSIVE and B.LANGUAGE_CODE=? and "
+ tableName
+ ".ENABLED='Y' and "
+ variantType
+ ".ENABLED='Y' and "
+ // and not "+tableName+"."+variantTypeJoin+"=? and "+
"not "
+ tableName
+ ".VARIANT_CODE=? "
+ "order by "
+ tableName
+ "."
+ variantTypeJoin
+ ","
+ tableName
+ ".CODE_ORDER";
Map attribute2dbField = new HashMap();
attribute2dbField.put("variantType", tableName + "." + variantTypeJoin);
attribute2dbField.put("variantCode", tableName + ".VARIANT_CODE");
attribute2dbField.put("variantDesc", "A.DESCRIPTION");
attribute2dbField.put("variantTypeDesc", "B.DESCRIPTION");
attribute2dbField.put("variantProgressiveSys10", tableName + ".PROGRESSIVE_SYS10");
attribute2dbField.put("variantTypeProgressiveSys10", variantType + ".PROGRESSIVE_SYS10");
ArrayList values = new ArrayList();
values.add(pk.getCompanyCodeSys01ITM01());
values.add(serverLanguageId);
values.add(serverLanguageId);
// values.add(ApplicationConsts.JOLLY);
values.add(ApplicationConsts.JOLLY);
// read from ITMxxx table...
Response answer =
QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql,
values,
attribute2dbField,
ItemVariantVO.class,
"Y",
"N",
null,
pars,
50,
true);
if (!answer.isError()) {
java.util.List vos = ((VOListResponse) answer).getRows();
HashMap map = new HashMap();
ItemVariantVO vo = null;
for (int i = 0; i < vos.size(); i++) {
vo = (ItemVariantVO) vos.get(i);
vo.setCompanyCodeSys01(pk.getCompanyCodeSys01ITM01());
vo.setItemCodeItm01(pk.getItemCodeITM01());
vo.setTableName(tableName);
map.put(vo.getVariantType() + "." + vo.getVariantCode(), vo);
}
pstmt =
conn.prepareStatement(
"select "
+ productVariant
+ "."
+ variantTypeJoin
+ ","
+ productVariant
+ "."
+ variantCodeJoin
+ " "
+ "from "
+ productVariant
+ " "
+ "where "
+ productVariant
+ ".COMPANY_CODE_SYS01=? and "
+ productVariant
+ ".ITEM_CODE_ITM01=? and "
+ productVariant
+ ".ENABLED='Y' ");
pstmt.setString(1, pk.getCompanyCodeSys01ITM01());
pstmt.setString(2, pk.getItemCodeITM01());
ResultSet rset = pstmt.executeQuery();
while (rset.next()) {
vo = (ItemVariantVO) map.get(rset.getString(1) + "." + rset.getString(2));
if (vo != null) vo.setSelected(Boolean.TRUE);
}
rset.close();
pstmt.close();
}
if (answer.isError()) throw new Exception(answer.getErrorMessage());
else return (VOListResponse) answer;
} catch (Throwable ex) {
Logger.error(
username,
this.getClass().getName(),
"getItemVariants",
"Error while fetching item variants list",
ex);
throw new Exception(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
if (this.conn == null && conn != null) {
// close only local connection
conn.commit();
conn.close();
}
} catch (Exception exx) {
}
}
}