public RepairOrderVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
//add columns
this.Name = "RepairOrderTable";
this.Label = "EBS Repair Order Table";
this.Description = "EBS Repair Order Table";
addColumns(RepairOrder.getRepairOrderListSchema());
//add filters
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenIncidentID",
Name = "HiddenIncidentID",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenContactID",
Name = "HiddenContactID",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "SR_DETAIL_LINK",
Name = "SR_DETAIL_LINK",
CanDisplay = true,
CanFilter = false
});
}
public EntitlementListVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "EntitlementTable";
this.Label = "EBS Entitlement Table";
this.Description = "EBS Entitlement Table";
addColumns(Entitlement.getDetailedSchema());
//add filter
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenInstanceId",
Name = "HiddenInstanceId",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenValidateFlag",
Name = "HiddenValidateFlag",
CanDisplay = false,
CanFilter = true
});
}
public ItemListVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
//add columns
this.Name = "ItemTable";
this.Label = "EBS Item Table";
this.Description = "EBS Item Table";
addColumns(Item.getDetailedSchema());
//add filters
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSerialNumber",
Name = "HiddenSerialNumber",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenContactOrgID",
Name = "HiddenContactOrgID",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenActiveInstanceOnly",
Name = "HiddenActiveInstanceOnly",
CanDisplay = false,
CanFilter = true
});
}
public EntitlementListVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "EntitlementTable";
this.Label = "EBS Entitlement Table";
this.Description = "EBS Entitlement Table";
addColumns(Entitlement.getDetailedSchema());
//add filter
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenInstanceId",
Name = "HiddenInstanceId",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenValidateFlag",
Name = "HiddenValidateFlag",
CanDisplay = false,
CanFilter = true
});
}
public OrderMgmtHeaderVirtualTable(EBSVirtualReportTablesPackage package, ref IList <IReportTable> reportTables)
: base(package)
{
this.Name = "OrderMgmtHeaderValTable";
this.Label = "EBS Order Mgmt Header Value Table";
this.Description = "EBS Order Mgmt Header Value Table";
// from generated proxy HEADER_VAL_REC
APPSOE_ORDER_PUB_HX219471X29X254 orderHeader = new APPSOE_ORDER_PUB_HX219471X29X254();
addColumns(orderHeader.GetType());
//HEADER_VAL_REC has no ID, add one for report linking
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "ID",
Name = "ID",
CanDisplay = true,
CanFilter = true
});
OutputParameters2 order = new OutputParameters2();
// add the order child tables
foreach (PropertyInfo propertyInfo in order.GetType().GetProperties())
{
if (propertyInfo.PropertyType.IsArray)
{
OrderMgmtGenericChildTable newTable = new OrderMgmtGenericChildTable(package, propertyInfo);
reportTables.Add(newTable);
}
}
}
public ItemListVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
//add columns
this.Name = "ItemTable";
this.Label = "EBS Item Table";
this.Description = "EBS Item Table";
addColumns(Item.getDetailedSchema());
//add filters
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSerialNumber",
Name = "HiddenSerialNumber",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenContactOrgID",
Name = "HiddenContactOrgID",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenActiveInstanceOnly",
Name = "HiddenActiveInstanceOnly",
CanDisplay = false,
CanFilter = true
});
}
public RepairOrderVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
//add columns
this.Name = "RepairOrderTable";
this.Label = "EBS Repair Order Table";
this.Description = "EBS Repair Order Table";
addColumns(RepairOrder.getRepairOrderListSchema());
//add filters
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenIncidentID",
Name = "HiddenIncidentID",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenContactID",
Name = "HiddenContactID",
CanDisplay = false,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "SR_DETAIL_LINK",
Name = "SR_DETAIL_LINK",
CanDisplay = true,
CanFilter = false
});
}
public OrderMgmtHeaderVirtualTable(EBSVirtualReportTablesPackage package, ref IList<IReportTable> reportTables)
: base(package)
{
this.Name = "OrderMgmtHeaderValTable";
this.Label = "EBS Order Mgmt Header Value Table";
this.Description = "EBS Order Mgmt Header Value Table";
// from generated proxy HEADER_VAL_REC
APPSOE_ORDER_PUB_HX219471X29X254 orderHeader = new APPSOE_ORDER_PUB_HX219471X29X254();
addColumns(orderHeader.GetType());
//HEADER_VAL_REC has no ID, add one for report linking
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "ID",
Name = "ID",
CanDisplay = true,
CanFilter = true
});
OutputParameters2 order = new OutputParameters2();
// add the order child tables
foreach (PropertyInfo propertyInfo in order.GetType().GetProperties())
{
if (propertyInfo.PropertyType.IsArray)
{
OrderMgmtGenericChildTable newTable = new OrderMgmtGenericChildTable(package, propertyInfo);
reportTables.Add(newTable);
}
}
}
// Build the columns schema dynamically based on Contact.getDetailSchema()
public ContactDetailVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "ContactDetailTable";
this.Label = "EBS Contact Detail Table";
this.Description = "EBS Contact Detail Table";
Dictionary<string, string> dictDetail = ContactModel.getDetailSchema();
addColumns(dictDetail);
}
// Build the columns schema dynamically based on Contact.getDetailSchema()
public ContactDetailVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "ContactDetailTable";
this.Label = "EBS Contact Detail Table";
this.Description = "EBS Contact Detail Table";
Dictionary <string, string> dictDetail = ContactModel.getDetailSchema();
addColumns(dictDetail);
}
public OrderHeaderByContactVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "OrdersByContactVirtualTable";
this.Label = "EBS Order Header By Contact Table";
this.Description = "EBS Order Header By Contact Table";
// from generated proxy
APPSOE_ORDER_CUST_ORX3349377X1X3 orderHeader = new APPSOE_ORDER_CUST_ORX3349377X1X3();
addColumns(orderHeader.GetType());
}
public OrderHeaderByContactVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "OrdersByContactVirtualTable";
this.Label = "EBS Order Header By Contact Table";
this.Description = "EBS Order Header By Contact Table";
// from generated proxy
APPSOE_ORDER_CUST_ORX3349377X1X3 orderHeader = new APPSOE_ORDER_CUST_ORX3349377X1X3();
addColumns(orderHeader.GetType());
}
public RepairLogisticsVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "RepairLogisticsTable";
this.Label = "EBS Repair Logistics Table";
this.Description = "EBS Repair Logistics Table";
addColumns(RepairLogistics.getRepairLogisticsListSchema());
//add filter
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenRepairOrderID",
Name = "HiddenRepairOrderID",
CanDisplay = false,
CanFilter = true
});
}
public RepairLogisticsVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "RepairLogisticsTable";
this.Label = "EBS Repair Logistics Table";
this.Description = "EBS Repair Logistics Table";
addColumns(RepairLogistics.getRepairLogisticsListSchema());
//add filter
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HiddenRepairOrderID",
Name = "HiddenRepairOrderID",
CanDisplay = false,
CanFilter = true
});
}
/* Build the columns schema dynamically based on ServiceRequest.getDetailSchema()
* and add one more column, HiddenSRconcatIncident_ID.
* The reason is the Service Request List view has "Subject" as report linking
* to this detail table, and it is based on this special column
*/
public SRdetailVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRDetailTable";
this.Label = "EBS SR Detail Table";
this.Description = "EBS SR Detail Table";
Dictionary<string, string> dictSRDetail = ServiceRequest.getDetailSchema();
addColumns(dictSRDetail);
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = true,
CanFilter = true
});
}
/* Build the columns schema dynamically based on ServiceRequest.getDetailSchema()
* and add one more column, HiddenSRconcatIncident_ID.
* The reason is the Service Request List view has "Subject" as report linking
* to this detail table, and it is based on this special column
*/
public SRdetailVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRDetailTable";
this.Label = "EBS SR Detail Table";
this.Description = "EBS SR Detail Table";
Dictionary <string, string> dictSRDetail = ServiceRequest.getDetailSchema();
addColumns(dictSRDetail);
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = true,
CanFilter = true
});
}
public OrderMgmtGenericChildTable(EBSVirtualReportTablesPackage package, PropertyInfo tableInfo)
: base(package)
{
this.Name = tableInfo.Name;
this.Label = "EBS " + tableInfo.Name;
this.Description = "EBS " + tableInfo.Name;
addColumns(tableInfo.PropertyType.GetElementType());
/* _VAL_TBL has no HEADER_ID, add it
* this filter for report linking
*/
if (this.Name.Contains("_VAL_TBL"))
{
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HEADER_ID",
Name = "HEADER_ID",
CanDisplay = true,
CanFilter = true
});
}
}
public OrderMgmtGenericChildTable(EBSVirtualReportTablesPackage package, PropertyInfo tableInfo)
: base(package)
{
this.Name = tableInfo.Name;
this.Label = "EBS " + tableInfo.Name;
this.Description = "EBS " + tableInfo.Name;
addColumns(tableInfo.PropertyType.GetElementType());
/* _VAL_TBL has no HEADER_ID, add it
* this filter for report linking
*/
if (this.Name.Contains("_VAL_TBL"))
{
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "HEADER_ID",
Name = "HEADER_ID",
CanDisplay = true,
CanFilter = true
});
}
}
public SRlistVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRlistTable";
this.Label = "EBS Service Request List Table";
this.Description = "EBS Service Request List Table";
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "SR ID",
Name = "SrID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "SR Number",
Name = "SrNumber",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "Contact Party ID",
Name = "ContactPartyID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Incident Reference",
Name = "IncidentRef",
CanDisplay = true,
CanFilter = false
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Status",
Name = "Status",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Summary",
Name = "Summary",
CanDisplay = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.DateTime,
Label = "Created",
Name = "Created",
CanDisplay = true
});
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = true,
CanFilter = true
});
}
public SRlistVirtualTable(EBSVirtualReportTablesPackage package)
: base(package)
{
this.Name = "SRlistTable";
this.Label = "EBS Service Request List Table";
this.Description = "EBS Service Request List Table";
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "SR ID",
Name = "SrID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "SR Number",
Name = "SrNumber",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.Integer,
Label = "Contact Party ID",
Name = "ContactPartyID",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Incident Reference",
Name = "IncidentRef",
CanDisplay = true,
CanFilter = false
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Status",
Name = "Status",
CanDisplay = true,
CanFilter = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "Summary",
Name = "Summary",
CanDisplay = true
});
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.DateTime,
Label = "Created",
Name = "Created",
CanDisplay = true
});
// format is either SrID_ OR _IncidentID
this.Columns.Add(new ReportColumn()
{
DataType = ReportColumnType.String,
Label = "HiddenSRconcatIncident_ID",
Name = "HiddenSRconcatIncident_ID",
CanDisplay = true,
CanFilter = true
});
}
