/// <summary>
/// Get active Items
/// </summary>
/// <returns>items</returns>
public static MChart[] GetCharts(Ctx ctx)
{
List <MChart> list = new List <MChart>();
String sql = "SELECT pfi.AD_CLIENT_ID, " +
"pfi.AD_ORG_ID, " +
"pfi.CHARTTYPE, " +
"pfi.D_CHART_ID, " +
"pfi.ENABLE3D , " +
"pfi.ISACTIVE, " +
"pfi.NAME, " +
"pfi.AD_CHART_BG_COLOR_ID, " +
"pfi.ISSHOWLEGEND, " +
"pfi.ISSHOWZEROSERIES, " +
"pfi.SEQNO, " +
"pfi.IsTiltLabel " +
"FROM D_Chart pfi INNER JOIN D_CHARTACCESS DCA " +
"ON pfi.D_CHART_ID=DCA.D_CHART_ID " +
"INNER JOIN (SELECT DISTINCT D_CHART_ID FROM D_Series WHERE ISACTIVE ='Y') ds " +
"ON DS.D_CHART_ID = DCA.D_CHART_ID " +
"WHERE pfi.IsActive='Y' " +
"AND DCA.AD_ROLE_ID='" + ctx.GetAD_Role_ID() + "' AND DCA.ISACTIVE='Y' AND DCA.ISREADWRITE = 'Y' ORDER BY SeqNo asc";
MRole role = MRole.GetDefault(ctx, false);
if (role.IsTableAccess(Table_ID, false))
{
try
{
//SqlParameter[] param = new SqlParameter[1];
//param[0] = new SqlParameter("@D_ChartID", Get_ID());
DataSet ds = DB.ExecuteDataset(sql, null);
foreach (DataRow dr in ds.Tables[0].Rows)
{
MChart pfi = new MChart(ctx, dr, null);
//if (role.IsColumnAccess(GetAD_Table_ID(), pfi.GetAD_Column_ID(), true))
list.Add(pfi);
}
}
catch (Exception e)
{
s_log.Severe(e.ToString());
//log entry, if any
}
}
//
MChart[] retValue = new MChart[list.Count];
retValue = list.ToArray();
return(retValue);
} // getItems
} // create
/// <summary>
/// Load Tab Details from dr into vo
/// </summary>
/// <param name="vo">GridTabVO object</param>
/// <param name="dr">Datarow</param>
/// <returns>true if successful</returns>
private static bool LoadTabDetails(GridTabVO vo, IDataReader dr)
{
MRole role = MRole.GetDefault(vo.ctx, false);
bool showTrl = "Y".Equals(vo.ctx.GetContext("#ShowTrl")) || DataBase.GlobalVariable.IsVisualEditor;
bool showAcct = "Y".Equals(vo.ctx.GetContext("#ShowAcct")) || DataBase.GlobalVariable.IsVisualEditor;
bool showAdvanced = "Y".Equals(vo.ctx.GetContext("#ShowAdvanced")) || DataBase.GlobalVariable.IsVisualEditor;
// VLogger.get().warning("ShowTrl=" + showTrl + ", showAcct=" + showAcct);
try
{
vo.AD_Tab_ID = Utility.Util.GetValueOfInt(dr["AD_Tab_ID"]);
vo.Referenced_Tab_ID = Utility.Util.GetValueOfInt(dr["Referenced_Tab_ID"]);
vo.ctx.SetContext(vo.windowNo, vo.tabNo, "AD_Tab_ID", vo.AD_Tab_ID.ToString());
vo.Name = Utility.Util.GetValueOfString(dr["Name"]);
vo.ctx.SetContext(vo.windowNo, vo.tabNo, "Name", vo.Name);
// Translation Tab **
if (Utility.Util.GetValueOfString(dr["IsTranslationTab"]).Equals("Y"))
{
// Document Translation
vo.TableName = Utility.Util.GetValueOfString(dr["TableName"]);
if (!Env.IsBaseTranslation(vo.TableName) && // C_UOM, ...
!Env.IsMultiLingualDocument(vo.ctx))
{
showTrl = false;
}
if (!showTrl)
{
VLogger.Get().Config("TrlTab Not displayed - AD_Tab_ID="
+ vo.AD_Tab_ID + "=" + vo.Name + ", Table=" + vo.TableName
+ ", BaseTrl=" + Env.IsBaseTranslation(vo.TableName)
+ ", MultiLingual=" + Env.IsMultiLingualDocument(vo.ctx));
return(false);
}
}
// Advanced Tab **
if (!showAdvanced && Utility.Util.GetValueOfString(dr["IsAdvancedTab"]).Equals("Y"))
{
VLogger.Get().Config("AdvancedTab Not displayed - AD_Tab_ID="
+ vo.AD_Tab_ID + " " + vo.Name);
return(false);
}
// Accounting Info Tab **
if (!showAcct && Utility.Util.GetValueOfString(dr["IsInfoTab"]).Equals("Y"))
{
VLogger.Get().Fine("AcctTab Not displayed - AD_Tab_ID="
+ vo.AD_Tab_ID + " " + vo.Name);
return(false);
}
// DisplayLogic
vo.DisplayLogic = Utility.Util.GetValueOfString(dr["DisplayLogic"]);
// Access Level
vo.AccessLevel = Utility.Util.GetValueOfString(dr["AccessLevel"]);
if (!role.CanView(vo.ctx, vo.AccessLevel) && !DataBase.GlobalVariable.IsVisualEditor) // No Access
{
VLogger.Get().Fine("No Role Access - AD_Tab_ID=" + vo.AD_Tab_ID + " " + vo.Name);
return(false);
} // Used by MField.getDefault
vo.ctx.SetContext(vo.windowNo, vo.tabNo, "AccessLevel", vo.AccessLevel);
// Table Access
vo.AD_Table_ID = Utility.Util.GetValueOfInt(dr["AD_Table_ID"]);
vo.ctx.SetContext(vo.windowNo, vo.tabNo, "AD_Table_ID", vo.AD_Table_ID.ToString());
if (!role.IsTableAccess(vo.AD_Table_ID, true) && !DataBase.GlobalVariable.IsVisualEditor)
{
VLogger.Get().Config("No Table Access - AD_Tab_ID="
+ vo.AD_Tab_ID + " " + vo.Name);
return(false);
}
if (role.IsTableReadOnly(vo.AD_Table_ID) && !DataBase.GlobalVariable.IsVisualEditor)
{
vo.IsReadOnly = true;
}
if (Utility.Util.GetValueOfString(dr["IsReadOnly"]).Equals("Y"))
{
vo.IsReadOnly = true;
}
vo.ReadOnlyLogic = Utility.Util.GetValueOfString(dr["ReadOnlyLogic"]);
if (Utility.Util.GetValueOfString(dr["IsInsertRecord"]).Equals("N"))
{
vo.IsInsertRecord = false;
}
//
vo.Description = Utility.Util.GetValueOfString(dr["Description"]);
if (vo.Description == null)
{
vo.Description = "";
}
vo.Help = Utility.Util.GetValueOfString(dr["Help"]);
if (vo.Help == null)
{
vo.Help = "";
}
if (Utility.Util.GetValueOfString(dr["IsSingleRow"]).Equals("Y"))
{
vo.IsSingleRow = true;
}
if (Utility.Util.GetValueOfString(dr["HasTree"]).Equals("Y"))
{
vo.HasTree = true;
}
if (Utility.Util.GetValueOfString(dr["ShowSummaryLevelNodes"]).Equals("Y"))
{
vo.ShowSummaryLevel = true;
}
vo.AD_Table_ID = Utility.Util.GetValueOfInt(dr["AD_Table_ID"]);
vo.TableName = Utility.Util.GetValueOfString(dr["TableName"]);
if (Utility.Util.GetValueOfString(dr["IsView"]).Equals("Y"))
{
vo.IsView = true;
}
vo.AD_Column_ID = Utility.Util.GetValueOfInt(dr["AD_Column_ID"]); // Primary Parent Column
if (Utility.Util.GetValueOfString(dr["IsSecurityEnabled"]).Equals("Y"))
{
vo.IsSecurityEnabled = true;
}
if (Utility.Util.GetValueOfString(dr["IsDeleteable"]).Equals("Y"))
{
vo.IsDeleteable = true;
}
if (Utility.Util.GetValueOfString(dr["IsHighVolume"]).Equals("Y"))
{
vo.IsHighVolume = true;
}
vo.CommitWarning = Utility.Util.GetValueOfString(dr["CommitWarning"]);
if (vo.CommitWarning == null)
{
vo.CommitWarning = "";
}
vo.WhereClause = Utility.Util.GetValueOfString(dr["WhereClause"]);
if (vo.WhereClause == null)
{
vo.WhereClause = "";
}
vo.OrderByClause = Utility.Util.GetValueOfString(dr["OrderByClause"]);
if (vo.OrderByClause == null)
{
vo.OrderByClause = "";
}
vo.AD_Process_ID = Utility.Util.GetValueOfInt(dr["AD_Process_ID"]);
//if (dr.wasNull())
// vo.AD_Process_ID = 0;
vo.AD_Image_ID = Utility.Util.GetValueOfInt(dr["AD_Image_ID"]);
//if (dr.wasNull())
// vo.AD_Image_ID = 0;
vo.Included_Tab_ID = Utility.Util.GetValueOfInt(dr["Included_Tab_ID"]);
//if (dr.wasNull())
// vo.Included_Tab_ID = 0;
//
vo.TabLevel = Utility.Util.GetValueOfInt(dr["TabLevel"]);
//if (dr.wasNull())
// vo.TabLevel = 0;
//
vo.IsSortTab = Utility.Util.GetValueOfString(dr["IsSortTab"]).Equals("Y");
if (vo.IsSortTab)
{
vo.AD_ColumnSortOrder_ID = Utility.Util.GetValueOfInt(dr["AD_ColumnSortOrder_ID"]);
vo.AD_ColumnSortYesNo_ID = Utility.Util.GetValueOfInt(dr["AD_ColumnSortYesNo_ID"]);
}
//
// Replication Type - set R/O if Reference
try
{
//int index = dr.fin .findColumn("ReplicationType");
vo.ReplicationType = Utility.Util.GetValueOfString(dr["ReplicationType"]);
if ("R".Equals(vo.ReplicationType))
{
vo.IsReadOnly = true;
}
}
catch
{
}
}
catch (System.Exception ex)
{
VLogger.Get().Log(Level.SEVERE, "", ex);
return(false);
}
return(true);
}
