예제 #1
0
 @Test
 public void testScroll() throws Exception {
   POResultSet<MTable> rs =
       new Query(getCtx(), "AD_Table", "TableName IN (?,?)", getTrxName())
           .setParameters(new Object[] {"C_Invoice", "M_InOut"})
           .setOrderBy("TableName")
           .scroll();
   try {
     int i = 0;
     while (rs.hasNext()) {
       MTable t = rs.next();
       if (i == 0) {
         assertEquals("Invalid object " + i, "C_Invoice", t.getTableName());
       } else if (i == 1) {
         assertEquals("Invalid object " + i, "M_InOut", t.getTableName());
       } else {
         assertFalse("More objects retrived than expected", true);
       }
       i++;
     }
   } finally {
     DB.close(rs);
     rs = null;
   }
 }
예제 #2
0
 @Test
 public void testFirstOnly() throws Exception {
   MTable t =
       new Query(getCtx(), "AD_Table", "AD_Table_ID=?", getTrxName())
           .setParameters(new Object[] {318})
           .firstOnly();
   assertEquals("Invalid table ID", 318, t.get_ID());
 }
예제 #3
0
  /** Print result generate for this report */
  void print() throws Exception {
    Language language = Language.getLoginLanguage(); // Base Language
    MPrintFormat pf = null;
    int pfid = 0;

    // get print format for client, else copy system to client
    RowSet pfrs =
        MPrintFormat.getAccessiblePrintFormats(
            MTable.getTable_ID(X_RV_PP_Product_BOMLine_Storage_TableName), -1, null);
    pfrs.next();
    pfid = pfrs.getInt("AD_PrintFormat_ID");

    if (pfrs.getInt("AD_Client_ID") != 0) pf = MPrintFormat.get(getCtx(), pfid, false);
    else pf = MPrintFormat.copyToClient(getCtx(), pfid, getAD_Client_ID());
    pfrs.close();

    if (pf == null) raiseError("Error: ", "No Print Format");

    pf.setLanguage(language);
    pf.setTranslationLanguage(language);
    // query
    MQuery query = new MQuery(X_RV_PP_Product_BOMLine_Storage_TableName);
    query.addRestriction(
        X_T_BOMLine.COLUMNNAME_AD_PInstance_ID,
        MQuery.EQUAL,
        AD_PInstance_ID,
        getParamenterName(X_T_BOMLine.COLUMNNAME_AD_PInstance_ID),
        getParamenterInfo(X_T_BOMLine.COLUMNNAME_AD_PInstance_ID));

    query.addRestriction(
        X_T_BOMLine.COLUMNNAME_M_Warehouse_ID,
        MQuery.EQUAL,
        p_M_Warehouse_ID,
        getParamenterName(X_T_BOMLine.COLUMNNAME_M_Warehouse_ID),
        getParamenterInfo(X_T_BOMLine.COLUMNNAME_M_Warehouse_ID));

    query.addRestriction(
        X_T_BOMLine.COLUMNNAME_M_Warehouse_ID,
        MQuery.EQUAL,
        p_M_Warehouse_ID,
        getParamenterName("DateTrx"),
        getParamenterInfo("DateTrx"));

    PrintInfo info =
        new PrintInfo(
            X_RV_PP_Product_BOMLine_Storage_TableName,
            MTable.getTable_ID(X_RV_PP_Product_BOMLine_Storage_TableName),
            getRecord_ID());
    ReportEngine re = new ReportEngine(getCtx(), pf, query, info);

    ReportCtl.preview(re);
    // wait for report window to be closed as t_bomline
    // records are deleted when process ends
    while (re.getView().isDisplayable()) {
      Env.sleep(1);
    }
  }
예제 #4
0
 @Test
 public void testFirst() throws Exception {
   MTable t =
       new Query(getCtx(), "AD_Table", "TableName IN (?,?)", getTrxName())
           .setParameters(new Object[] {"C_Invoice", "M_InOut"})
           .setOrderBy("TableName")
           .first();
   assertEquals("Invalid object", "C_Invoice", t.getTableName());
 }
 private void createSequence(MTable table, String trxName) {
   if (!table.isView()) {
     if (!MSequence.createTableSequence(getCtx(), table.getTableName(), trxName)) {
       throw new AdempiereException(
           "Can not create Native Sequence for table " + table.getTableName());
     } else {
       this.addLog("Create Native Sequence for : " + table.getTableName());
     }
   }
 }
예제 #6
0
  protected void updateHelpWidthPreference(String width) {

    if (width != null) {
      Query query =
          new Query(
              Env.getCtx(),
              MTable.get(Env.getCtx(), I_AD_Preference.Table_ID),
              " Attribute=? AND AD_User_ID=? AND AD_Process_ID IS NULL AND PreferenceFor = 'W'",
              null);

      int userId = Env.getAD_User_ID(Env.getCtx());
      MPreference preference =
          query
              .setOnlyActiveRecords(true)
              .setApplyAccessFilter(true)
              .setParameters("HelpController.Width", userId)
              .first();

      if (preference == null || preference.getAD_Preference_ID() <= 0) {

        preference = new MPreference(Env.getCtx(), 0, null);
        preference.set_ValueOfColumn("AD_User_ID", userId); // required set_Value for System=0 user
        preference.setAttribute("HelpController.Width");
      }
      preference.setValue(width);
      preference.saveEx();
    }
  }
예제 #7
0
 /**
  * Execute Drill to Query
  *
  * @param query query
  */
 private void executeDrill(MQuery query) {
   int AD_Table_ID = MTable.getTable_ID(query.getTableName());
   if (!MRole.getDefault().isCanReport(AD_Table_ID)) {
     FDialog.error(0, null, "AccessCannotReport", query.getTableName());
     return;
   }
   if (AD_Table_ID != 0) new WReport(AD_Table_ID, query);
 } //	executeDrill
예제 #8
0
 @Test
 public void testIterate() throws Exception {
   final Iterator<MTable> it =
       new Query(getCtx(), "AD_Table", "TableName IN (?,?)", getTrxName())
           .setParameters(new Object[] {"C_Invoice", "M_InOut"})
           .setOrderBy("TableName")
           .iterate(null, false); // guaranteed=false
   int i = 0;
   while (it.hasNext()) {
     MTable t = it.next();
     if (i == 0) {
       assertEquals("Invalid object " + i, "C_Invoice", t.getTableName());
     } else if (i == 1) {
       assertEquals("Invalid object " + i, "M_InOut", t.getTableName());
     } else {
       assertFalse("More objects retrived than expected", true);
     }
     i++;
   }
 }
예제 #9
0
  @Override
  public int retrieveTableId(final String tableName) {
    // NOTE: make sure we are returning -1 in case tableName was not found (and NOT throw
    // exception),
    // because there is business logic which depends on this

    @SuppressWarnings("deprecation")
    // TODO move getTable_ID out of MTable
    final int tableId = MTable.getTable_ID(tableName);

    return tableId;
  }
예제 #10
0
  public void actionZoom() {
    int AD_Window_ID = MTable.get(Env.getCtx(), MLocator.Table_ID).getAD_Window_ID();
    if (AD_Window_ID <= 0) AD_Window_ID = 139; // 	hardcoded window Warehouse & Locators
    log.info("");
    //

    MQuery zoomQuery = new MQuery();
    zoomQuery.addRestriction(MLocator.COLUMNNAME_M_Locator_ID, MQuery.EQUAL, getValue());
    zoomQuery.setRecordCount(1); // 	guess

    AEnv.zoom(AD_Window_ID, zoomQuery);
  }
예제 #11
0
  @Override
  public String retrieveTableName(final int adTableId) {
    final Properties ctx = Env.getCtx();

    // guard against 0 AD_Table_ID
    if (adTableId <= 0) {
      return null;
    }

    @SuppressWarnings("deprecation")
    final String tableName = MTable.getTableName(ctx, adTableId);

    return tableName;
  }
예제 #12
0
 @Override
 public String retrieveWindowName(final Properties ctx, final String tableName) {
   // NOTE: atm we use MTable.get because that's the only place where we have the table cached.
   // In future we shall replace it with something which is database independent.
   final I_AD_Table adTable = MTable.get(ctx, tableName);
   if (adTable == null) {
     return "";
   }
   final I_AD_Window adWindow = adTable.getAD_Window();
   if (adWindow == null) {
     return "";
   }
   final I_AD_Window adWindowTrl = InterfaceWrapperHelper.translate(adWindow, I_AD_Window.class);
   return adWindowTrl.getName();
 }
 public org.eevolution.model.I_WM_InOutBound getWM_InOutBound() throws RuntimeException {
   Class<?> clazz = MTable.getClass(org.eevolution.model.I_WM_InOutBound.Table_Name);
   org.eevolution.model.I_WM_InOutBound result = null;
   try {
     Constructor<?> constructor = null;
     constructor =
         clazz.getDeclaredConstructor(new Class[] {Properties.class, int.class, String.class});
     result =
         (org.eevolution.model.I_WM_InOutBound)
             constructor.newInstance(
                 new Object[] {getCtx(), new Integer(getWM_InOutBound_ID()), get_TrxName()});
   } catch (Exception e) {
     log.log(Level.SEVERE, "(id) - Table=" + Table_Name + ",Class=" + clazz, e);
     log.saveError("Error", "Table=" + Table_Name + ",Class=" + clazz);
     throw new RuntimeException(e);
   }
   return result;
 }
 public I_M_Warehouse getM_Warehouse() throws RuntimeException {
   Class<?> clazz = MTable.getClass(I_M_Warehouse.Table_Name);
   I_M_Warehouse result = null;
   try {
     Constructor<?> constructor = null;
     constructor =
         clazz.getDeclaredConstructor(new Class[] {Properties.class, int.class, String.class});
     result =
         (I_M_Warehouse)
             constructor.newInstance(
                 new Object[] {getCtx(), new Integer(getM_Warehouse_ID()), get_TrxName()});
   } catch (Exception e) {
     log.log(Level.SEVERE, "(id) - Table=" + Table_Name + ",Class=" + clazz, e);
     log.saveError("Error", "Table=" + Table_Name + ",Class=" + clazz);
     throw new RuntimeException(e);
   }
   return result;
 }
예제 #15
0
  /** Action - Zoom */
  @Override
  public void actionZoom() {
    int AD_Window_ID = MTable.get(Env.getCtx(), MLocator.Table_ID).getAD_Window_ID();
    if (AD_Window_ID <= 0) AD_Window_ID = 139; // 	hardcoded window Warehouse & Locators
    log.info("");
    //
    setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
    AWindow frame = new AWindow();

    MQuery zoomQuery = new MQuery();
    zoomQuery.addRestriction(MLocator.COLUMNNAME_M_Locator_ID, Operator.EQUAL, getValue());
    zoomQuery.setRecordCount(1); // 	guess

    if (!frame.initWindow(AD_Window_ID, zoomQuery)) return;
    AEnv.addToWindowManager(frame);
    AEnv.showCenterScreen(frame);
    frame = null;
    setCursor(Cursor.getDefaultCursor());
  } //	actionZoom
예제 #16
0
  @Override
  protected String doIt() throws Exception {
    final ISubscriptionBL subscriptionBL = Services.get(ISubscriptionBL.class);

    if (getRecord_ID() > 0) {
      Check.assume(
          getTable_ID() == MTable.getTable_ID(I_C_OLCand.Table_Name),
          "Process is called for C_OLCands");

      final I_C_OLCand olCand =
          InterfaceWrapperHelper.create(getCtx(), getRecord_ID(), I_C_OLCand.class, get_TrxName());
      subscriptionBL.createTermForOLCand(
          getCtx(), olCand, getAD_PInstance_ID(), true, get_TrxName());
      addLog("@C_OLCand_ID@ " + olCand.getC_OLCand_ID() + " @Processed@");
    } else {
      final int counter =
          subscriptionBL.createMissingTermsForOLCands(
              getCtx(), true, getAD_PInstance_ID(), get_TrxName());
      addLog("@Processed@ " + counter + " @C_OLCand_ID@");
    }

    return "@Success@";
  }
예제 #17
0
  /**
   * Perform process.
   *
   * @return Message
   * @throws Exception if not successful
   */
  protected String doIt() throws Exception {
    String where = " Password IS NOT NULL AND Salt IS NULL ";

    int count = 0;
    boolean isEncrypted = MColumn.isEncrypted(417);

    List<MUser> users =
        MTable.get(getCtx(), MUser.Table_ID).createQuery(where, get_TrxName()).list();
    for (MUser user : users) {
      if (user.getAD_User_ID() == 0) {
        String password =
            DB.getSQLValueString(
                get_TrxName(), "SELECT Password FROM AD_User WHERE AD_User_ID=?", 0);
        if (isEncrypted) password = SecureEngine.decrypt(password);

        user.setPassword(password);
        String sql = "UPDATE AD_User SET Updated=SysDate, UpdatedBy=" + getAD_User_ID();
        if (!Util.isEmpty(password)) {
          sql +=
              ", Password="******", Salt=" + DB.TO_STRING(user.getSalt());
        }
        sql += " WHERE AD_User_ID=0";
        DB.executeUpdateEx(sql, get_TrxName());
        count++;
      } else {
        user.setPassword(user.getPassword());
        count++;
        user.saveEx();
      }
    }

    return "@Updated@ " + count;
  } //	doIt
예제 #18
0
 public org.compiere.model.I_C_DocType getC_DocType() throws RuntimeException {
   return (org.compiere.model.I_C_DocType)
       MTable.get(getCtx(), org.compiere.model.I_C_DocType.Table_Name)
           .getPO(getC_DocType_ID(), get_TrxName());
 }
예제 #19
0
 public org.eevolution.model.I_HR_Payroll getHR_Payroll() throws RuntimeException {
   return (org.eevolution.model.I_HR_Payroll)
       MTable.get(getCtx(), org.eevolution.model.I_HR_Payroll.Table_Name)
           .getPO(getHR_Payroll_ID(), get_TrxName());
 }
예제 #20
0
 public org.eevolution.LMX.model.I_LMX_Certificate getLMX_Certificate() throws RuntimeException {
   return (org.eevolution.LMX.model.I_LMX_Certificate)
       MTable.get(getCtx(), org.eevolution.LMX.model.I_LMX_Certificate.Table_Name)
           .getPO(getLMX_Certificate_ID(), get_TrxName());
 }
예제 #21
0
 public org.compiere.model.I_AD_Sequence getAD_Sequence() throws RuntimeException {
   return (org.compiere.model.I_AD_Sequence)
       MTable.get(getCtx(), org.compiere.model.I_AD_Sequence.Table_Name)
           .getPO(getAD_Sequence_ID(), get_TrxName());
 }
예제 #22
0
 public I_M_Product getM_Product() throws RuntimeException {
   return (I_M_Product)
       MTable.get(getCtx(), I_M_Product.Table_Name).getPO(getM_Product_ID(), get_TrxName());
 }
예제 #23
0
 public I_M_ChangeNotice getM_ChangeNotice() throws RuntimeException {
   return (I_M_ChangeNotice)
       MTable.get(getCtx(), I_M_ChangeNotice.Table_Name)
           .getPO(getM_ChangeNotice_ID(), get_TrxName());
 }
예제 #24
0
 public I_M_AttributeSetInstance getM_AttributeSetInstance() throws RuntimeException {
   return (I_M_AttributeSetInstance)
       MTable.get(getCtx(), I_M_AttributeSetInstance.Table_Name)
           .getPO(getM_AttributeSetInstance_ID(), get_TrxName());
 }
예제 #25
0
/**
 * Generated Interface for HR_SalaryStructure
 *
 * @author Adempiere (generated)
 * @version Release 3.8.0
 */
public interface I_HR_SalaryStructure {

  /** TableName=HR_SalaryStructure */
  public static final String Table_Name = "HR_SalaryStructure";

  /** AD_Table_ID=53689 */
  public static final int Table_ID = MTable.getTable_ID(Table_Name);

  KeyNamePair Model = new KeyNamePair(Table_ID, Table_Name);

  /** AccessLevel = 3 - Client - Org */
  BigDecimal accessLevel = BigDecimal.valueOf(3);

  /** Load Meta Data */

  /** Column name AD_Client_ID */
  public static final String COLUMNNAME_AD_Client_ID = "AD_Client_ID";

  /** Get Client. Client/Tenant for this installation. */
  public int getAD_Client_ID();

  /** Column name AD_Org_ID */
  public static final String COLUMNNAME_AD_Org_ID = "AD_Org_ID";

  /** Set Organization. Organizational entity within client */
  public void setAD_Org_ID(int AD_Org_ID);

  /** Get Organization. Organizational entity within client */
  public int getAD_Org_ID();

  /** Column name Created */
  public static final String COLUMNNAME_Created = "Created";

  /** Get Created. Date this record was created */
  public Timestamp getCreated();

  /** Column name CreatedBy */
  public static final String COLUMNNAME_CreatedBy = "CreatedBy";

  /** Get Created By. User who created this records */
  public int getCreatedBy();

  /** Column name Description */
  public static final String COLUMNNAME_Description = "Description";

  /** Set Description. Optional short description of the record */
  public void setDescription(String Description);

  /** Get Description. Optional short description of the record */
  public String getDescription();

  /** Column name HR_SalaryStructure_ID */
  public static final String COLUMNNAME_HR_SalaryStructure_ID = "HR_SalaryStructure_ID";

  /** Set Salary Structure. Salary Structure of an Employee */
  public void setHR_SalaryStructure_ID(int HR_SalaryStructure_ID);

  /** Get Salary Structure. Salary Structure of an Employee */
  public int getHR_SalaryStructure_ID();

  /** Column name IsActive */
  public static final String COLUMNNAME_IsActive = "IsActive";

  /** Set Active. The record is active in the system */
  public void setIsActive(boolean IsActive);

  /** Get Active. The record is active in the system */
  public boolean isActive();

  /** Column name Name */
  public static final String COLUMNNAME_Name = "Name";

  /** Set Name. Alphanumeric identifier of the entity */
  public void setName(String Name);

  /** Get Name. Alphanumeric identifier of the entity */
  public String getName();

  /** Column name Updated */
  public static final String COLUMNNAME_Updated = "Updated";

  /** Get Updated. Date this record was updated */
  public Timestamp getUpdated();

  /** Column name UpdatedBy */
  public static final String COLUMNNAME_UpdatedBy = "UpdatedBy";

  /** Get Updated By. User who updated this records */
  public int getUpdatedBy();

  /** Column name ValidTo */
  public static final String COLUMNNAME_ValidTo = "ValidTo";

  /** Set Valid to. Valid to including this date (last day) */
  public void setValidTo(Timestamp ValidTo);

  /** Get Valid to. Valid to including this date (last day) */
  public Timestamp getValidTo();

  /** Column name Value */
  public static final String COLUMNNAME_Value = "Value";

  /** Set Search Key. Search key for the record in the format required - must be unique */
  public void setValue(String Value);

  /** Get Search Key. Search key for the record in the format required - must be unique */
  public String getValue();
}
예제 #26
0
/**
 * Generated Interface for C_AdvComDoc
 *
 * @author Adempiere (generated)
 * @version Release 3.5.4a
 */
public interface I_C_AdvComDoc {

  /** TableName=C_AdvComDoc */
  public static final String Table_Name = "C_AdvComDoc";

  /** AD_Table_ID=540288 */
  public static final int Table_ID = MTable.getTable_ID(Table_Name);

  KeyNamePair Model = new KeyNamePair(Table_ID, Table_Name);

  /** AccessLevel = 1 - Org */
  BigDecimal accessLevel = BigDecimal.valueOf(1);

  /** Load Meta Data */

  /** Column name AD_Client_ID */
  public static final String COLUMNNAME_AD_Client_ID = "AD_Client_ID";

  /** Get Mandant. Mandant für diese Installation. */
  public int getAD_Client_ID();

  /** Column name AD_Org_ID */
  public static final String COLUMNNAME_AD_Org_ID = "AD_Org_ID";

  /** Set Organisation. Organisatorische Einheit des Mandanten */
  public void setAD_Org_ID(int AD_Org_ID);

  /** Get Organisation. Organisatorische Einheit des Mandanten */
  public int getAD_Org_ID();

  /** Column name AD_Table_ID */
  public static final String COLUMNNAME_AD_Table_ID = "AD_Table_ID";

  /** Set DB-Tabelle. Database Table information */
  public void setAD_Table_ID(int AD_Table_ID);

  /** Get DB-Tabelle. Database Table information */
  public int getAD_Table_ID();

  public org.compiere.model.I_AD_Table getAD_Table() throws RuntimeException;

  /** Column name C_AdvComDoc_ID */
  public static final String COLUMNNAME_C_AdvComDoc_ID = "C_AdvComDoc_ID";

  /** Set Provisionsauslöser */
  public void setC_AdvComDoc_ID(int C_AdvComDoc_ID);

  /** Get Provisionsauslöser */
  public int getC_AdvComDoc_ID();

  /** Column name C_AllocationLine_ID */
  public static final String COLUMNNAME_C_AllocationLine_ID = "C_AllocationLine_ID";

  /** Set Zuordnungs-Position. Zuordnungs-Position */
  public void setC_AllocationLine_ID(int C_AllocationLine_ID);

  /** Get Zuordnungs-Position. Zuordnungs-Position */
  public int getC_AllocationLine_ID();

  public org.compiere.model.I_C_AllocationLine getC_AllocationLine() throws RuntimeException;

  /** Column name C_DocType_Ref_ID */
  public static final String COLUMNNAME_C_DocType_Ref_ID = "C_DocType_Ref_ID";

  /** Set Belegart */
  public void setC_DocType_Ref_ID(int C_DocType_Ref_ID);

  /** Get Belegart */
  public int getC_DocType_Ref_ID();

  public org.compiere.model.I_C_DocType getC_DocType_Ref() throws RuntimeException;

  /** Column name Created */
  public static final String COLUMNNAME_Created = "Created";

  /** Get Erstellt. Datum, an dem dieser Eintrag erstellt wurde */
  public Timestamp getCreated();

  /** Column name CreatedBy */
  public static final String COLUMNNAME_CreatedBy = "CreatedBy";

  /** Get Erstellt durch. Nutzer, der diesen Eintrag erstellt hat */
  public int getCreatedBy();

  /** Column name DateDoc_Ref */
  public static final String COLUMNNAME_DateDoc_Ref = "DateDoc_Ref";

  /** Set Belegdatum */
  public void setDateDoc_Ref(Timestamp DateDoc_Ref);

  /** Get Belegdatum */
  public Timestamp getDateDoc_Ref();

  /** Column name DateFact */
  public static final String COLUMNNAME_DateFact = "DateFact";

  /** Set Valuta-Datum */
  public void setDateFact(Timestamp DateFact);

  /** Get Valuta-Datum */
  public Timestamp getDateFact();

  /** Column name DateFact_Override */
  public static final String COLUMNNAME_DateFact_Override = "DateFact_Override";

  /** Set Abw. Valutadatum */
  public void setDateFact_Override(Timestamp DateFact_Override);

  /** Get Abw. Valutadatum */
  public Timestamp getDateFact_Override();

  /** Column name DocAction */
  public static final String COLUMNNAME_DocAction = "DocAction";

  /** Set Belegverarbeitung. Der zukünftige Status des Belegs */
  public void setDocAction(String DocAction);

  /** Get Belegverarbeitung. Der zukünftige Status des Belegs */
  public String getDocAction();

  /** Column name DocStatus */
  public static final String COLUMNNAME_DocStatus = "DocStatus";

  /** Set Belegstatus. The current status of the document */
  public void setDocStatus(String DocStatus);

  /** Get Belegstatus. The current status of the document */
  public String getDocStatus();

  /** Column name DocumentNo_Ref */
  public static final String COLUMNNAME_DocumentNo_Ref = "DocumentNo_Ref";

  /** Set Belegnummer */
  public void setDocumentNo_Ref(String DocumentNo_Ref);

  /** Get Belegnummer */
  public String getDocumentNo_Ref();

  /** Column name IsActive */
  public static final String COLUMNNAME_IsActive = "IsActive";

  /** Set Aktiv. Der Eintrag ist im System aktiv */
  public void setIsActive(boolean IsActive);

  /** Get Aktiv. Der Eintrag ist im System aktiv */
  public boolean isActive();

  /** Column name IsApproved */
  public static final String COLUMNNAME_IsApproved = "IsApproved";

  /** Set Freigegeben. Zeigt an, ob dieser Beleg eine Freigabe braucht */
  public void setIsApproved(boolean IsApproved);

  /** Get Freigegeben. Zeigt an, ob dieser Beleg eine Freigabe braucht */
  public boolean isApproved();

  /** Column name IsDateFactOverridable */
  public static final String COLUMNNAME_IsDateFactOverridable = "IsDateFactOverridable";

  /** Set Valutadatum Änderbar */
  public void setIsDateFactOverridable(boolean IsDateFactOverridable);

  /** Get Valutadatum Änderbar */
  public boolean isDateFactOverridable();

  /** Column name IsProcessedByComSystem */
  public static final String COLUMNNAME_IsProcessedByComSystem = "IsProcessedByComSystem";

  /** Set In Buchauszug verbucht. Änderung wurde in den Buchauszug aufgenommen */
  public void setIsProcessedByComSystem(boolean IsProcessedByComSystem);

  /** Get In Buchauszug verbucht. Änderung wurde in den Buchauszug aufgenommen */
  public boolean isProcessedByComSystem();

  /** Column name Processed */
  public static final String COLUMNNAME_Processed = "Processed";

  /** Set Verarbeitet. The document has been processed */
  public void setProcessed(boolean Processed);

  /** Get Verarbeitet. The document has been processed */
  public boolean isProcessed();

  /** Column name Processing */
  public static final String COLUMNNAME_Processing = "Processing";

  /** Set Process Now */
  public void setProcessing(boolean Processing);

  /** Get Process Now */
  public boolean isProcessing();

  /** Column name Record_ID */
  public static final String COLUMNNAME_Record_ID = "Record_ID";

  /** Set Datensatz-ID. Direct internal record ID */
  public void setRecord_ID(int Record_ID);

  /** Get Datensatz-ID. Direct internal record ID */
  public int getRecord_ID();

  /** Column name Updated */
  public static final String COLUMNNAME_Updated = "Updated";

  /** Get Aktualisiert. Datum, an dem dieser Eintrag aktualisiert wurde */
  public Timestamp getUpdated();

  /** Column name UpdatedBy */
  public static final String COLUMNNAME_UpdatedBy = "UpdatedBy";

  /** Get Aktualisiert durch. Nutzer, der diesen Eintrag aktualisiert hat */
  public int getUpdatedBy();
}
예제 #27
0
 public org.eevolution.LMX.model.I_LMX_Vendor getLMX_Vendor() throws RuntimeException {
   return (org.eevolution.LMX.model.I_LMX_Vendor)
       MTable.get(getCtx(), org.eevolution.LMX.model.I_LMX_Vendor.Table_Name)
           .getPO(getLMX_Vendor_ID(), get_TrxName());
 }
  public void startElement(Properties ctx, Element element) throws SAXException {
    String elementValue = element.getElementValue();
    int AD_Backup_ID = -1;
    String Object_Status = null;
    Attributes atts = element.attributes;
    log.info(elementValue + " " + atts.getValue("Name"));

    String name = atts.getValue("Name");
    int id = get_IDWithColumn(ctx, "AD_PrintFormat", "Name", name);
    X_AD_PrintFormat m_PrintFormat = new X_AD_PrintFormat(ctx, id, getTrxName(ctx));
    if (id <= 0
        && atts.getValue("AD_PrintFormat_ID") != null
        && Integer.parseInt(atts.getValue("AD_PrintFormat_ID")) <= PackOut.MAX_OFFICIAL_ID)
      m_PrintFormat.setAD_PrintFormat_ID(Integer.parseInt(atts.getValue("AD_PrintFormat_ID")));
    if (id > 0) {
      AD_Backup_ID = copyRecord(ctx, "AD_PrintFormat", m_PrintFormat);
      Object_Status = "Update";
    } else {
      Object_Status = "New";
      AD_Backup_ID = 0;
    }

    name = atts.getValue("ADReportviewnameID");
    if (name != null && name.trim().length() > 0) {
      id = get_IDWithColumn(ctx, "AD_ReportView", "Name", name);
      if (id <= 0) {
        element.defer = true;
        return;
      }
      m_PrintFormat.setAD_ReportView_ID(id);
    }

    name = atts.getValue("ADTableNameID");
    id = get_IDWithColumn(ctx, "AD_Table", "TableName", name);
    if (id == 0) {
      MTable m_Table = new MTable(ctx, 0, getTrxName(ctx));
      m_Table.setAccessLevel("3");
      m_Table.setName(name);
      m_Table.setTableName(name);
      if (m_Table.save(getTrxName(ctx)) == true) {
        record_log(
            ctx,
            1,
            m_Table.getName(),
            "Table",
            m_Table.get_ID(),
            0,
            "New",
            "AD_Table",
            get_IDWithColumn(ctx, "AD_Table", "TableName", "AD_Table"));
      } else {
        record_log(
            ctx,
            0,
            m_Table.getName(),
            "Table",
            m_Table.get_ID(),
            0,
            "New",
            "AD_Table",
            get_IDWithColumn(ctx, "AD_Table", "TableName", "AD_Table"));
      }
      id = get_IDWithColumn(ctx, "AD_Table", "TableName", name);
    }
    m_PrintFormat.setAD_Table_ID(id);

    name = atts.getValue("ADPrintTableFormatID");
    if (name != null && name.trim().length() > 0) {
      id = get_IDWithColumn(ctx, "AD_PrintTableFormat", "Name", name);
      if (id <= 0) {
        element.defer = true;
        return;
      }
      m_PrintFormat.setAD_PrintTableFormat_ID(id);
    }

    name = atts.getValue("ADPrintColorID");
    if (name != null && name.trim().length() > 0) {
      id = get_IDWithColumn(ctx, "AD_PrintColor", "Name", name);
      if (id <= 0) {
        element.defer = true;
        return;
      }
      m_PrintFormat.setAD_PrintColor_ID(id);
    }

    name = atts.getValue("ADPrintFontID");
    if (name != null && name.trim().length() > 0) {
      id = get_IDWithColumn(ctx, "AD_PrintFont", "Name", name);
      if (id <= 0) {
        element.defer = true;
        return;
      }
      m_PrintFormat.setAD_PrintFont_ID(id);
    }

    name = atts.getValue("ADPrintPaperID");
    if (name != null && name.trim().length() > 0) {
      id = get_IDWithColumn(ctx, "AD_PrintPaper", "Name", name);
      if (id <= 0) {
        element.defer = true;
        return;
      }
      m_PrintFormat.setAD_PrintPaper_ID(id);
    }

    m_PrintFormat.setDescription(getStringValue(atts, "Description"));
    m_PrintFormat.setName(atts.getValue("Name"));
    m_PrintFormat.setPrinterName(getStringValue(atts, "PrinterName"));
    m_PrintFormat.setFooterMargin(Integer.parseInt(atts.getValue("FooterMargin")));

    m_PrintFormat.setHeaderMargin(Integer.parseInt(atts.getValue("HeaderMargin")));
    m_PrintFormat.setCreateCopy(atts.getValue("CreateCopy"));
    m_PrintFormat.setIsActive(
        atts.getValue("isActive") != null
            ? Boolean.valueOf(atts.getValue("isActive")).booleanValue()
            : true);

    m_PrintFormat.setIsTableBased(Boolean.valueOf(atts.getValue("isTableBased")).booleanValue());
    m_PrintFormat.setIsForm(Boolean.valueOf(atts.getValue("isForm")).booleanValue());
    m_PrintFormat.setIsStandardHeaderFooter(
        Boolean.valueOf(atts.getValue("isStandardHeader")).booleanValue());

    m_PrintFormat.setIsDefault(Boolean.valueOf(atts.getValue("isDefault")).booleanValue());
    if (m_PrintFormat.save(getTrxName(ctx)) == true) {
      record_log(
          ctx,
          1,
          m_PrintFormat.getName(),
          "PrintFormat",
          m_PrintFormat.get_ID(),
          AD_Backup_ID,
          Object_Status,
          "AD_PrintFormat",
          get_IDWithColumn(ctx, "AD_Table", "TableName", "AD_PrintFormat"));
      element.recordId = m_PrintFormat.getAD_PrintFormat_ID();
    } else {
      record_log(
          ctx,
          0,
          m_PrintFormat.getName(),
          "PrintFormat",
          m_PrintFormat.get_ID(),
          AD_Backup_ID,
          Object_Status,
          "AD_PrintFormat",
          get_IDWithColumn(ctx, "AD_Table", "TableName", "AD_PrintFormat"));
      throw new POSaveFailedException("Failed to save Print Format");
    }
  }
예제 #29
0
/**
 * Generated Interface for HR_Concept
 *
 * @author Adempiere (generated)
 * @version Release 3.6.0LTS
 */
public interface I_HR_Concept {

  /** TableName=HR_Concept */
  public static final String Table_Name = "HR_Concept";

  /** AD_Table_ID=53090 */
  public static final int Table_ID = MTable.getTable_ID(Table_Name);

  KeyNamePair Model = new KeyNamePair(Table_ID, Table_Name);

  /** AccessLevel = 7 - System - Client - Org */
  BigDecimal accessLevel = BigDecimal.valueOf(7);

  /** Load Meta Data */

  /** Column name AD_Client_ID */
  public static final String COLUMNNAME_AD_Client_ID = "AD_Client_ID";

  /** Get Client. Client/Tenant for this installation. */
  public int getAD_Client_ID();

  /** Column name AD_Org_ID */
  public static final String COLUMNNAME_AD_Org_ID = "AD_Org_ID";

  /** Set Organization. Organizational entity within client */
  public void setAD_Org_ID(int AD_Org_ID);

  /** Get Organization. Organizational entity within client */
  public int getAD_Org_ID();

  /** Column name AD_Reference_ID */
  public static final String COLUMNNAME_AD_Reference_ID = "AD_Reference_ID";

  /** Set Reference. System Reference and Validation */
  public void setAD_Reference_ID(int AD_Reference_ID);

  /** Get Reference. System Reference and Validation */
  public int getAD_Reference_ID();

  public org.compiere.model.I_AD_Reference getAD_Reference() throws RuntimeException;

  /** Column name AccountSign */
  public static final String COLUMNNAME_AccountSign = "AccountSign";

  /** Set Account Sign. Indicates the Natural Sign of the Account as a Debit or Credit */
  public void setAccountSign(String AccountSign);

  /** Get Account Sign. Indicates the Natural Sign of the Account as a Debit or Credit */
  public String getAccountSign();

  /** Column name ColumnType */
  public static final String COLUMNNAME_ColumnType = "ColumnType";

  /** Set Column Type */
  public void setColumnType(String ColumnType);

  /** Get Column Type */
  public String getColumnType();

  /** Column name Created */
  public static final String COLUMNNAME_Created = "Created";

  /** Get Created. Date this record was created */
  public Timestamp getCreated();

  /** Column name CreatedBy */
  public static final String COLUMNNAME_CreatedBy = "CreatedBy";

  /** Get Created By. User who created this records */
  public int getCreatedBy();

  /** Column name Description */
  public static final String COLUMNNAME_Description = "Description";

  /** Set Description. Optional short description of the record */
  public void setDescription(String Description);

  /** Get Description. Optional short description of the record */
  public String getDescription();

  /** Column name HR_Concept_Category_ID */
  public static final String COLUMNNAME_HR_Concept_Category_ID = "HR_Concept_Category_ID";

  /** Set Payroll Concept Category */
  public void setHR_Concept_Category_ID(int HR_Concept_Category_ID);

  /** Get Payroll Concept Category */
  public int getHR_Concept_Category_ID();

  public org.eevolution.model.I_HR_Concept_Category getHR_Concept_Category()
      throws RuntimeException;

  /** Column name HR_Concept_ID */
  public static final String COLUMNNAME_HR_Concept_ID = "HR_Concept_ID";

  /** Set Payroll Concept */
  public void setHR_Concept_ID(int HR_Concept_ID);

  /** Get Payroll Concept */
  public int getHR_Concept_ID();

  /** Column name HR_Department_ID */
  public static final String COLUMNNAME_HR_Department_ID = "HR_Department_ID";

  /** Set Payroll Department */
  public void setHR_Department_ID(int HR_Department_ID);

  /** Get Payroll Department */
  public int getHR_Department_ID();

  public org.eevolution.model.I_HR_Department getHR_Department() throws RuntimeException;

  /** Column name HR_Job_ID */
  public static final String COLUMNNAME_HR_Job_ID = "HR_Job_ID";

  /** Set Payroll Job */
  public void setHR_Job_ID(int HR_Job_ID);

  /** Get Payroll Job */
  public int getHR_Job_ID();

  public org.eevolution.model.I_HR_Job getHR_Job() throws RuntimeException;

  /** Column name HR_Payroll_ID */
  public static final String COLUMNNAME_HR_Payroll_ID = "HR_Payroll_ID";

  /** Set Payroll */
  public void setHR_Payroll_ID(int HR_Payroll_ID);

  /** Get Payroll */
  public int getHR_Payroll_ID();

  public org.eevolution.model.I_HR_Payroll getHR_Payroll() throws RuntimeException;

  /** Column name IsActive */
  public static final String COLUMNNAME_IsActive = "IsActive";

  /** Set Active. The record is active in the system */
  public void setIsActive(boolean IsActive);

  /** Get Active. The record is active in the system */
  public boolean isActive();

  /** Column name IsDefault */
  public static final String COLUMNNAME_IsDefault = "IsDefault";

  /** Set Default. Default value */
  public void setIsDefault(boolean IsDefault);

  /** Get Default. Default value */
  public boolean isDefault();

  /** Column name IsEmployee */
  public static final String COLUMNNAME_IsEmployee = "IsEmployee";

  /** Set Employee. Indicates if this Business Partner is an employee */
  public void setIsEmployee(boolean IsEmployee);

  /** Get Employee. Indicates if this Business Partner is an employee */
  public boolean isEmployee();

  /** Column name IsManual */
  public static final String COLUMNNAME_IsManual = "IsManual";

  /** Set Manual. This is a manual process */
  public void setIsManual(boolean IsManual);

  /** Get Manual. This is a manual process */
  public boolean isManual();

  /** Column name IsPaid */
  public static final String COLUMNNAME_IsPaid = "IsPaid";

  /** Set Paid. The document is paid */
  public void setIsPaid(boolean IsPaid);

  /** Get Paid. The document is paid */
  public boolean isPaid();

  /** Column name IsPrinted */
  public static final String COLUMNNAME_IsPrinted = "IsPrinted";

  /** Set Printed. Indicates if this document / line is printed */
  public void setIsPrinted(boolean IsPrinted);

  /** Get Printed. Indicates if this document / line is printed */
  public boolean isPrinted();

  /** Column name IsReceipt */
  public static final String COLUMNNAME_IsReceipt = "IsReceipt";

  /** Set Receipt. This is a sales transaction (receipt) */
  public void setIsReceipt(boolean IsReceipt);

  /** Get Receipt. This is a sales transaction (receipt) */
  public boolean isReceipt();

  /** Column name IsSaveInHistoric */
  public static final String COLUMNNAME_IsSaveInHistoric = "IsSaveInHistoric";

  /** Set Save In Historic */
  public void setIsSaveInHistoric(boolean IsSaveInHistoric);

  /** Get Save In Historic */
  public boolean isSaveInHistoric();

  /** Column name Name */
  public static final String COLUMNNAME_Name = "Name";

  /** Set Name. Alphanumeric identifier of the entity */
  public void setName(String Name);

  /** Get Name. Alphanumeric identifier of the entity */
  public String getName();

  /** Column name SeqNo */
  public static final String COLUMNNAME_SeqNo = "SeqNo";

  /** Set Sequence. Method of ordering records; lowest number comes first */
  public void setSeqNo(int SeqNo);

  /** Get Sequence. Method of ordering records; lowest number comes first */
  public int getSeqNo();

  /** Column name Type */
  public static final String COLUMNNAME_Type = "Type";

  /** Set Type. Type of Validation (SQL, Java Script, Java Language) */
  public void setType(String Type);

  /** Get Type. Type of Validation (SQL, Java Script, Java Language) */
  public String getType();

  /** Column name Updated */
  public static final String COLUMNNAME_Updated = "Updated";

  /** Get Updated. Date this record was updated */
  public Timestamp getUpdated();

  /** Column name UpdatedBy */
  public static final String COLUMNNAME_UpdatedBy = "UpdatedBy";

  /** Get Updated By. User who updated this records */
  public int getUpdatedBy();

  /** Column name ValidFrom */
  public static final String COLUMNNAME_ValidFrom = "ValidFrom";

  /** Set Valid from. Valid from including this date (first day) */
  public void setValidFrom(Timestamp ValidFrom);

  /** Get Valid from. Valid from including this date (first day) */
  public Timestamp getValidFrom();

  /** Column name ValidTo */
  public static final String COLUMNNAME_ValidTo = "ValidTo";

  /** Set Valid to. Valid to including this date (last day) */
  public void setValidTo(Timestamp ValidTo);

  /** Get Valid to. Valid to including this date (last day) */
  public Timestamp getValidTo();

  /** Column name Value */
  public static final String COLUMNNAME_Value = "Value";

  /** Set Search Key. Search key for the record in the format required - must be unique */
  public void setValue(String Value);

  /** Get Search Key. Search key for the record in the format required - must be unique */
  public String getValue();
}
예제 #30
0
 public I_C_UOM getC_UOM() throws RuntimeException {
   return (I_C_UOM) MTable.get(getCtx(), I_C_UOM.Table_Name).getPO(getC_UOM_ID(), get_TrxName());
 }