Examples with MTable org.compiere.model.MTable used on opensource projects

Example 26 with MTable

use of org.compiere.model.MTable in project adempiere by adempiere.

the class ReportViewElementHandler method startElement.

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("ADReportviewnameID"));
    //String entitytype = atts.getValue("EntityType");
    String name = atts.getValue("ADReportviewnameID");
    int id = get_ID(ctx, "AD_ReportView", name);
    X_AD_ReportView m_Reportview = new X_AD_ReportView(ctx, id, getTrxName(ctx));
    if (id <= 0 && atts.getValue("AD_ReportView_ID") != null && Integer.parseInt(atts.getValue("AD_ReportView_ID")) <= PackOut.MAX_OFFICIAL_ID)
        m_Reportview.setAD_ReportView_ID(Integer.parseInt(atts.getValue("AD_ReportView_ID")));
    if (id > 0) {
        AD_Backup_ID = copyRecord(ctx, "AD_Reportview", m_Reportview);
        Object_Status = "Update";
    } else {
        Object_Status = "New";
        AD_Backup_ID = 0;
    }
    String Name = atts.getValue("ADTableNameID");
    id = get_IDWithColumn(ctx, "AD_Table", "TableName", Name);
    MTable m_Table = null;
    if (id == 0) {
        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_Reportview.setAD_Table_ID(id);
    m_Reportview.setDescription(getStringValue(atts, "Description"));
    m_Reportview.setEntityType(atts.getValue("EntityType"));
    m_Reportview.setName(atts.getValue("Name"));
    m_Reportview.setIsActive(atts.getValue("isActive") != null ? Boolean.valueOf(atts.getValue("isActive")).booleanValue() : true);
    m_Reportview.setOrderByClause(getStringValue(atts, "OrderByClause"));
    m_Reportview.setWhereClause(getStringValue(atts, "WhereClause"));
    if (m_Reportview.save(getTrxName(ctx)) == true) {
        record_log(ctx, 1, m_Reportview.getName(), "Reportview", m_Reportview.get_ID(), AD_Backup_ID, Object_Status, "AD_Reportview", get_IDWithColumn(ctx, "AD_Table", "TableName", "AD_Reportview"));
        element.recordId = m_Reportview.getAD_ReportView_ID();
    } else {
        record_log(ctx, 0, m_Reportview.getName(), "Reportview", m_Reportview.get_ID(), AD_Backup_ID, Object_Status, "AD_Reportview", get_IDWithColumn(ctx, "AD_Table", "TableName", "AD_Reportview"));
        throw new POSaveFailedException("ReportView");
    }
}

Example 27 with MTable

use of org.compiere.model.MTable in project adempiere by adempiere.

the class VOrderPlanning method getTableName.

//  getSelectedRowKey
/**
	 *  Get Table name Synonym
	 *  @return table name
	 */
String getTableName() {
    table = new MTable(Env.getCtx(), AD_Table_ID, "AD_Table");
    p_tableName = table.getTableName();
    return p_tableName;
}

Example 28 with MTable

use of org.compiere.model.MTable in project adempiere by adempiere.

the class MWorkflow method unlock.

/**
	 * Unlock the entity data based on field processing set off for this document
	 * @param tableId
	 * @param recordId
	 */
private void unlock(int tableId, int recordId) {
    MTable domain = MTable.get(getCtx(), tableId);
    String update = "UPDATE " + domain.getTableName() + " SET Processing='N' WHERE " + domain.getKeyColumns()[0] + "=?";
    DB.executeUpdateEx(update, new Object[] { recordId }, null);
}

Example 29 with MTable

use of org.compiere.model.MTable in project adempiere by adempiere.

the class MWorkflow method isLock.

//	MWFProcess
/**
	 * Validate if a workflow is running for same Entity Data Id
	 * @param tableId
	 * @param recordId
	 * @return
	 */
private boolean isLock(int tableId, int recordId) {
    MTable domain = MTable.get(getCtx(), tableId);
    String sqlProcessing = "SELECT Processing FROM " + domain.getTableName() + " WHERE " + domain.getKeyColumns()[0] + "=?";
    return "Y".equals(DB.getSQLValueStringEx(null, sqlProcessing, recordId));
}

Example 30 with MTable

use of org.compiere.model.MTable in project adempiere by adempiere.

the class RecordInfoController method dynInit.

/**
	 * 	Dynamic Init
	 *	@param dse data status event
	 *	@param title title
	 *	@param mField field
	 */
private void dynInit(DataStatusEvent dse, String title, GridField mField) {
    m_Field = mField;
    //	Yamel Senih FR[ 146 ] Add support to change log in a specific column
    //	2015-12-03
    //	For Field
    int m_Record_ID = 0;
    int m_AD_Table_ID = 0;
    int m_AD_Column_ID = 0;
    if (m_Field != null) {
        //	Set Values
        m_Record_ID = m_Field.getGridTab().getRecord_ID();
        m_AD_Table_ID = m_Field.getGridTab().getAD_Table_ID();
        m_AD_Column_ID = m_Field.getAD_Column_ID();
        //	
        MColumn column = MColumn.get(Env.getCtx(), m_AD_Column_ID);
        X_AD_Reference reference = new X_AD_Reference(Env.getCtx(), m_Field.getDisplayType(), null);
        DecimalFormat format = DisplayType.getNumberFormat(reference.getAD_Reference_ID());
        MTable table = MTable.get(Env.getCtx(), m_AD_Table_ID);
        //  Info
        m_info.append("(").append(table.getTableName()).append(" - ").append(m_Field.getColumnName()).append(" = ").append(m_Field.getValue()).append(")").append("\n").append(Msg.translate(Env.getCtx(), "Name")).append(": ").append(m_Field.getHeader()).append("\n").append(Msg.translate(Env.getCtx(), "Description")).append(": ").append(m_Field.getDescription()).append("\n").append(Msg.translate(Env.getCtx(), "AD_Reference_ID")).append(": ").append(reference.get_Translation("Name")).append("\n");
        //	For Reference Key
        if (m_Field.getDisplayType() == DisplayType.List || m_Field.getDisplayType() == DisplayType.Table || m_Field.getDisplayType() == DisplayType.Search) {
            //	Valid Reference Value
            if (m_Field.getAD_Reference_Value_ID() != 0) {
                X_AD_Reference referenceKey = new X_AD_Reference(Env.getCtx(), m_Field.getAD_Reference_Value_ID(), null);
                m_info.append(Msg.translate(Env.getCtx(), "AD_Reference_Value_ID")).append(": ").append(referenceKey.get_Translation("Name")).append(" (").append(m_Field.getAD_Reference_Value_ID()).append(")").append("\n");
            }
        }
        //	Valid Dynamic Validation
        if (column.getAD_Val_Rule_ID() != 0) {
            X_AD_Val_Rule validation = (X_AD_Val_Rule) column.getAD_Val_Rule();
            m_info.append(Msg.translate(Env.getCtx(), "AD_Val_Rule_ID")).append(": ").append(validation.get_Translation("Name")).append(" (").append(column.getAD_Val_Rule_ID()).append(")").append("\n");
        }
        m_info.append(Msg.translate(Env.getCtx(), "Length")).append(": ").append(format.format(column.getFieldLength())).append("\n");
        //	Add Entity Type for info
        MEntityType entity = MEntityType.get(Env.getCtx(), column.getEntityType());
        m_info.append(Msg.translate(Env.getCtx(), "EntityType")).append(": ").append(entity.get_Translation("Name"));
        //	Title
        m_Title = title + " - " + m_Field.getHeader();
    } else {
        if (dse.CreatedBy == null)
            return;
        //  Info
        MUser user = MUser.get(Env.getCtx(), dse.CreatedBy.intValue());
        m_info.append(" ").append(Msg.translate(Env.getCtx(), "CreatedBy")).append(": ").append(user.getName()).append(" - ").append(m_dateTimeFormat.format(dse.Created)).append("\n");
        if (!dse.Created.equals(dse.Updated) || !dse.CreatedBy.equals(dse.UpdatedBy)) {
            if (!dse.CreatedBy.equals(dse.UpdatedBy))
                user = MUser.get(Env.getCtx(), dse.UpdatedBy.intValue());
            m_info.append(" ").append(Msg.translate(Env.getCtx(), "UpdatedBy")).append(": ").append(user.getName()).append(" - ").append(m_dateTimeFormat.format(dse.Updated)).append("\n");
        }
        if (dse.Info != null && dse.Info.length() > 0)
            m_info.append("\n (").append(dse.Info).append(")");
        //	Title
        if (dse.AD_Table_ID != 0) {
            m_AD_Table_ID = dse.AD_Table_ID;
            MTable table1 = MTable.get(Env.getCtx(), dse.AD_Table_ID);
            m_Title = title + " - " + table1.getName();
        }
        //	Set Record ID
        if (dse.Record_ID instanceof Integer)
            m_Record_ID = ((Integer) dse.Record_ID).intValue();
        else
            log.info("dynInit - Invalid Record_ID=" + dse.Record_ID);
    }
    //	Valid Record Identifier
    if (m_Record_ID == 0)
        return;
    //	Only Client Preference can view Change Log
    if (!MRole.PREFERENCETYPE_Client.equals(MRole.getDefault().getPreferenceType()))
        return;
    //	Data
    String sql = "SELECT AD_Column_ID, Updated, UpdatedBy, OldValue, NewValue " + "FROM AD_ChangeLog " + "WHERE AD_Table_ID=? AND Record_ID=? " + (m_AD_Column_ID != 0 ? "AND AD_Column_ID=? " : "") + "ORDER BY Updated DESC";
    PreparedStatement pstmt = null;
    try {
        pstmt = DB.prepareStatement(sql, null);
        pstmt.setInt(1, m_AD_Table_ID);
        pstmt.setInt(2, m_Record_ID);
        //	Add support to column
        if (m_AD_Column_ID != 0)
            pstmt.setInt(3, m_AD_Column_ID);
        //	
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()) {
            addLine(rs.getInt(1), rs.getTimestamp(2), rs.getInt(3), rs.getString(4), rs.getString(5));
        }
        rs.close();
        pstmt.close();
        pstmt = null;
    } catch (Exception e) {
        log.log(Level.SEVERE, sql, e);
    }
    try {
        if (pstmt != null)
            pstmt.close();
        pstmt = null;
    } catch (Exception e) {
        pstmt = null;
    }
    //	Set Loaded to Ok
    m_IsLoaded = true;
}